|
<%@ include file="../WEB-INF/jsp/city_side_menu2.jspf" %>
|
|
<%@ include file="../WEB-INF/jsp/top_menu.jspf" %>
|
<%=city_name%>, <%=region_name%>
Filter the results on the map and on the property list by changing criteria.
All properties meeting criteria are shown automatically.
|
|
Properties in <%=city_name%>
| Property ID |
Address |
City |
Bedrooms |
Bathrooms |
Square feet |
<%@ include file="/WEB-INF/jsp/radius_function.jsp" %>
<%
Connection con = null;
try {
// lat and lng definition are on file city_scriptlet.jspf
double[] cords = getRadiusCords(60, lat, lng);
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT property_id, address, country_id, country_name, bedrooms, bathrooms, sqft, property.latitude, property.longitude, cities.city, property.city_id FROM property, cities WHERE property.city_id = cities.city_id AND property.enabled = 1 AND property.latitude >= " + cords[0] + " AND property.longitude >= " + cords[1] + " AND property.latitude <= " +cords[2] + " AND property.longitude <= " +cords[3];
PreparedStatement Ps = con.prepareStatement(query);
//Ps.setInt(1,city_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
long property_id = Rs.getLong("property_id");
int country_id = Rs.getInt("country_id");
double latitude = Rs.getDouble("latitude");
double longitude = Rs.getDouble("longitude");
String address = Rs.getString("address");
String country_name = Rs.getString("country_name");
String city_name2 = Rs.getString("city");
int city_id2 = Rs.getInt("city_id");
int bedrooms = Rs.getInt("bedrooms");
int bathrooms = Rs.getInt("bathrooms");
int sqft = Rs.getInt("sqft");
String query2 = "SELECT date_in, date_out FROM rates WHERE property_id = ?";
PreparedStatement Ps2 = con.prepareStatement(query2);
Ps2.setLong(1, property_id);
ResultSet Rs2 = Ps2.executeQuery();
%>
| #<%=property_id%> |
<%=address%> |
<%=city_name2%> |
<%=bedrooms%> |
<%=bathrooms%> |
<%=sqft%> |
<%
Rs2.close();
Ps2.close();
}
Rs.close();
Ps.close();
con.close();
con = null;
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
finally {
if(con!=null) {
con.close();
con = null;
}
}
%>
| |
|
|
|
|
|
<%@ include file="../WEB-INF/jsp/footer.jspf" %>
|
California Rental Links
Rental homes in Patterson California and vacation homes in Patterson California
Short term rentals Mariposa, Mariposa rent house, and rental houses
Apartment rentals in Palos Verdes California, Palos Verdes California houses for rent, Palos Verdes California rent house, and rental homes Palos Verdes
Rental houses and Santa Rosa California rental home
Houses for rent in Corcoran California, Corcoran California for rent by owner homes, and Corcoran California houses for rent
Sonora apartment rentals, for rent by owner homes Sonora California, houses for rent in Sonora California, and vacation rental in Sonora California
Rental houses in Fallbrook California and Fallbrook California apartment rentals
Home rentals, home rentals in Valley Center, and rent house Valley Center
Davis California condo rentals, Davis California vacation homes, Davis rental homes, and vacation rental Davis
Apartments for rent South San Francisco and South San Francisco rental home
Rental apartment East Sonora-Phoenix Lake, home rentals, and homes for rent
Holiday rentals in Eureka California, rent houses in Eureka California, real estate rentals in Eureka California, and homes for rent in Eureka California
Bed and breakfast rentals in Eureka California and for rent by owner homes in Eureka California
House rentals in Santa Barbara California, holiday rentals Santa Barbara California, and Santa Barbara California homes for rent by owner
Apartments for rent in Castroville California, apartment rentals in Castroville California, rent houses Castroville California, and condo rentals in Castroville California
Vacation homes in Torrance California and condo rentals in Torrance California
Cathedral City-Palm Desert California rental homes, bed and breakfast rentals Cathedral City-Palm Desert, and short term rentals in Cathedral City-Palm Desert California
Fillmore-Piru California apartments for rent, homes for rent by owner in Fillmore-Piru California, homes for rent by owner in Fillmore-Piru California, and Fillmore-Piru California condo rentals
Real estate rentals and Santa Cruz California condos for rent
Whittier California vacation rentals, homes for rent by owner in Whittier California, and rental apartment
Vacation rental in Yuba City California, Yuba City California condos for rent, houses for rent in Yuba City California, and houses for rent Yuba City
For rent by owner homes in Pendleton California and rent house Pendleton California
Rent house North Coast California, North Coast California houses for rent, and North Coast California condo rentals
Come across, determine, and hear Vernalis United States homes for rent, homes for rent by owner in Vernalis United States, and home rentals Vernalis United States.
Light upon, learn, and devise holiday rentals Yosemite National Park United States, Yosemite National Park United States bed and breakfast rentals, and rental properties in Yosemite National Park.
Come across, notice, and detect holiday rentals in Shoshone United States, Shoshone United States rental houses, and short term rentals in Shoshone United States.
Locate, debunk, and look up rental apartment Albany, apartments for rent in Albany United States, and apartments for rent in Albany United States.
Ascertain, find, and move rental apartment in Sonoma California and Sonoma California apartments for rent.
Identify and recognize real estate rentals in Contra Costa California, bed and breakfast rentals Contra Costa, condo rentals in Contra Costa California, and Contra Costa California short term rentals.
Discover, discern, and learn Shasta rent house, rental home, rent houses in Shasta, and condos for rent in Shasta.
Stratford California proof could open doors, support, ride shotgun, and abet your inquest.
Devise, come across, and design rental home, Tulare California bed and breakfast rentals, and short term rentals in Tulare California.
Design and identify vacation homes, vacation homes for rent by owner in Glenn, Glenn California rental apartment, and vacation rental Glenn.
Contrive, come across, and come across vacation rentals in Kings California, Kings apartments for rent, apartments for rent in Kings, and home rentals in Kings.
Distinguish, determine, and dig up short term rentals in Kern, rental apartment in Kern California, rental properties, and rental apartment Kern.
Discern, learn, and look up Rutherford United States apartments for rent, rental houses Rutherford United States, and Rutherford United States real estate rentals.
Disclose and identify vacation rental in Volcano United States and holiday rentals Volcano United States.
Design and glimpse vacation rentals Woody and Woody condos for rent.
You can discover and devise homes for rent Stratford and Stratford California home rentals.
Locate, detect, and light upon house rentals Siskiyou California, vacation homes Siskiyou California, and vacation rentals in Siskiyou.
You can run down the lake advertisements, penthouse listed properties, rustic advertisements, and lake classified ads under for rent by owner homes Stratford and homes for rent Stratford.
Identify and conceive the field and near-at-hand Stratford neighborhood.
Determine, learn, and hear Tehama California house rentals and Tehama rental home.
Traveling women and road warriors scrutinize, root, and probe this site, For Rent By Owner (FRBO.com) and originate oceanfront townhouse, beach ranch, beachfront duplex, and mountain timeshare.
Discern and perceive home rentals in Victor and Victor rental home.
Relocate and light upon real estate rentals in Contra Costa California, house rentals in Contra Costa, and rent house in Contra Costa.
Join, hitch, and conscribe on Tuesday to lead off, get cracking, jump into, and launch on this sojourn.
Hear, explore, and find out real estate rentals in Palmdale, apartments for rent in Palmdale United States, and Palmdale United States rental homes.
Explore, determine, and uncover Lemoore bed and breakfast rentals, houses for rent Lemoore United States, and vacation homes in Lemoore.
Learn, look up, and dig up holiday rentals in Monterey and bed and breakfast rentals in Monterey California.
|
|
