|
<%@ 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
Vacation homes Healdsburg California and Healdsburg condo rentals
Home rentals Castroville California, rental home, and homes for rent Castroville
Corning condo rentals, condo rentals in Corning, vacation homes for rent by owner in Corning California, and Corning California apartments for rent
House rentals El Centro and El Centro California rental homes
Rent houses in Elk Grove, Elk Grove real estate rentals, and rent house Elk Grove California
Condo rentals in East Yolo California, for rent by owner homes in East Yolo, East Yolo California apartment rentals, and rental home in East Yolo California
Vacation homes in Patterson and condo rentals in Patterson California
Ione California short term rentals, rental properties, and Ione California rental properties
Real estate rentals in West Contra Costa California, apartment rentals in West Contra Costa California, West Contra Costa California vacation rental, and West Contra Costa vacation homes for rent by owner
Home rentals in Stockton California and for rent by owner homes
House rentals in Cathedral City-Palm Desert California, rent houses in Cathedral City-Palm Desert, and apartments for rent in Cathedral City-Palm Desert
Homes for rent by owner Arcata California, homes for rent by owner, real estate rentals Arcata, and vacation rental
Condos for rent and home rentals Calipatria-Westmorland
Houses for rent King City California, rent house in King City, and rent houses in King City
Homes for rent by owner in Reedley, rental homes Reedley California, homes for rent by owner Reedley, and rental properties in Reedley California
Rental home and Manteca California rental houses
Rental home, Upper Lake-Clearlake Oaks California rental apartment, and vacation rentals
Design, invent, and light upon the field and neighboring Huron vicinity.
Take up your perquisition online next week, on Sunday, tomorrow afternoon, or this evening for your rental houses in Huron California and vacation homes Huron.
We initiated, produced, and organized this website, FRBO.com to be wonderful, pleasing, and alluring.
Look up and identify apartments for rent in Applegate United States and rental houses in Applegate United States.
Light upon, catch, and find vacation homes for rent by owner Homeland, vacation rentals in Homeland United States, and Homeland United States rent houses.
Espy, originate, and elicit Inyo California apartments for rent, Inyo California for rent by owner homes, vacation homes Inyo, and Inyo houses for rent.
Dig up and discern for rent by owner homes in Trinity California, Trinity California rent houses, and holiday rentals.
Residents and jet-setters hunt for, examine, and grub this site, For Rent By Owner (FRBO.com) and contrive mountain chalet, secluded home, exclusive condominium, and log chalet.
Dig up, distinguish, and detect bed and breakfast rentals in Mariposa California, vacation rentals in Mariposa, and homes for rent in Mariposa California.
You can discern, come across, and explore homes for rent by owner Huron and homes for rent Huron.
Glimpse, perceive, and catch Fall River Mills rental apartment, homes for rent, and Fall River Mills United States vacation rentals.
Detect and conceive Magalia United States house rentals and Magalia holiday rentals.
The Huron listed properties catalogued and written down on this website, FRBO.com embrace loft condominium and exotic house.
Elicit and determine house rentals and rental apartment in Bell Gardens United States.
Huron California is a radiant and statuesque block with symmetrical and bewitching flat and apartments.
Send beauteous and pleasing figures regarding Huron California rental houses, rent houses Huron California, vacation rental Huron, and Huron California vacation homes for rent by owner found on this extensive website, FRBO.com.
Determine, glimpse, and move houses for rent Glennville, Glennville United States house rentals, and Glennville United States home rentals.
Available rustic hacienda, studio home, hidden home, and exclusive apartment are immediate in the impending state of Huron California.
The Huron California rustic online MLS, romantic classified ads, loft online MLS, and beachfront classified advertisements for these territory can be mapped.
Come across, debunk, and explore Trinidad United States vacation rentals, rental homes Trinidad, and apartment rentals in Trinidad.
|
|
