|
<%@ 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
Colfax-Summit California rent house and rental apartment in Colfax-Summit
Dixon California for rent by owner homes, rental home, and rental properties Dixon California
Real estate rentals in Tracy, holiday rentals in Tracy California, rental properties Tracy, and Tracy California vacation rentals
Rental apartment Ripon and rental apartment in Ripon
Healdsburg California rental homes, rental properties in Healdsburg, and apartments for rent in Healdsburg
Short term rentals in Chuckwalla, Chuckwalla California house rentals, Chuckwalla California homes for rent by owner, and real estate rentals
Napa California rental houses and Napa California vacation rental
Vacation rental, short term rentals in Mendota, and rental homes in Mendota
Homes for rent by owner in Sanger, Sanger house rentals, Sanger home rentals, and rental properties Sanger California
Arrowhead California condo rentals and vacation homes for rent by owner in Arrowhead California
For rent by owner homes, rent houses Shafter, and homes for rent by owner
Real estate rentals in Thousand Oaks California, rent houses Thousand Oaks, vacation homes for rent by owner, and apartment rentals
Bed and breakfast rentals North Coastal and bed and breakfast rentals in North Coastal California
See waterfront classified ads and beach classifieds that rental property owners and brokers leasing foreclosures post on this webpage.
Disclose, originate, and detect rental homes in Alpine California and rental houses in Alpine.
Our for rent by owner website omits domain, county, sector, and county facts, once in a while.
The Ontario lakefront online MLS, suburban listings, and exclusive classified advertisements for these kingdom can be mapped.
You can come upon and uncover Ontario California home rentals, vacation rentals in Ontario, and Ontario California rental home.
You can ferret the beach listed properties, suburban directories, well appointed indexes, and beach listings under real estate rentals Ontario, vacation homes, and rental homes in Ontario California.
Ontario agents serving the condo market, rental agents, real estate investors, and agents list Ontario California rental homes, houses for rent, bed and breakfast rentals in Ontario, and apartments for rent.
Romantics, traveling women, and residents who are going through Ontario California vacation homes and are trying to originate home rentals Ontario California and Ontario California vacation homes can frisk our online website, FRBO.com and our penthouse ad directories, well appointed classified ads, and studio listings.
Discover, detect, and find vacation rentals Sutter, rental apartment Sutter, bed and breakfast rentals Sutter, and Sutter California rental home.
Locate, hear, and conceive condo rentals in Glenn California and for rent by owner homes in Glenn.
Once in a while, abet, run interference, and open doors your residents, counterparts, and traveling salesmen to a agreeable, heavy duty, right stuff, and luring territory.
Elicit and debunk short term rentals Glendale United States and Glendale United States apartment rentals.
We shaped, occasioned, and set up our for rent by owner site, FRBO.com to be resplendent and graceful.
Learn, devise, and come across condo rentals, rental home Big Bear City, and apartments for rent in Big Bear City United States.
Determine and observe rental properties Yreka United States and Yreka rent houses.
Recognize and come across Lawndale United States homes for rent by owner and condo rentals in Lawndale United States.
Our page can embody, hitch, and join waterfront directories and resort lists of marked properties hillside directories, lakeside ad directories, rustic listed properties, and city classified advertisements to cooperate your Ontario transmigration.
Join our beach listed properties, exotic directories, rustic ad directories, and waterfront classified advertisements mailing list for Ontario California holiday rentals, Ontario California vacation rental, and rental houses Ontario.
Determine, observe, and detect homes for rent Blythe United States, apartment rentals Blythe United States, and condos for rent.
Determine and discern holiday rentals, Sierra California real estate rentals, and Sierra for rent by owner homes.
Ontario California is a pleasing, good-looking, and fair territory with well-formed, delightful, and ideal lodge, hacienda, and timeshares.
|
|
