|
<%@ 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 houses Salinas California and rental homes
Orosi-Cutler California rent house, Orosi-Cutler houses for rent, and Orosi-Cutler California rental homes
Holiday rentals Yuba City California, Yuba City real estate rentals, house rentals Yuba City, and apartment rentals Yuba City
Vacation homes for rent by owner in Salida and house rentals in Salida California
House rentals Whittier California, vacation homes for rent by owner in Whittier California, and apartments for rent
Condo rentals, real estate rentals, Los Angeles rental home, and rental apartment in Los Angeles
Houses for rent Sonoma California and Sonoma rental houses
Real estate rentals Lemoore, Lemoore California vacation rentals, and homes for rent by owner
Home rentals in Paso Robles California, Paso Robles California houses for rent, Paso Robles California short term rentals, and rental homes in Paso Robles California
Rental houses Selma and vacation homes in Selma California
San Diego bed and breakfast rentals, vacation rental, and short term rentals in San Diego California
Homes for rent by owner Lake Isabella California, homes for rent by owner Lake Isabella California, home rentals Lake Isabella, and condos for rent in Lake Isabella California
Rental home in Burbank California and Burbank California vacation homes for rent by owner
Real estate rentals in Mendota California, home rentals in Mendota, and rent house in Mendota California
Toro California rent houses, Toro California rental houses, rental home in Toro, and Toro California vacation homes
Oroville California for rent by owner homes and apartment rentals in Oroville California
Condo rentals Whittier, house rentals in Whittier, and rental homes in Whittier
Rent house Long Beach-Lakewood California, apartments for rent in Long Beach-Lakewood California, rental apartment Long Beach-Lakewood, and home rentals in Long Beach-Lakewood California
This extensive website, FRBO.com does subsume especial beach, spacious, lakeside, and city hacienda, chalet, townhouse, and houseboats.
This extensive website, FRBO.com can levy and draft convenient online MLS, resort ads, exclusive indexes, and waterfront listed properties lake ad directories, lakeside classified ads, private listed properties, and rustic ad directories to support your Seaside-Monterey California trek.
Learn, find out, and explore house rentals in Zenia United States, real estate rentals, and house rentals Zenia United States.
We initiated and hatched our website, FRBO.com to be fair, appealing, superb, and well-formed.
Locate, elicit, and move Napa home rentals, Napa California short term rentals, and Napa California rent house.
Vacant studio cottage, well appointed condominium, loft duplex, and loft houseboat are adjacent in the not remote quarter of Seaside-Monterey California.
Observe and identify houses for rent in Winters United States and Winters United States rent houses.
The Seaside-Monterey California classifieds polled and itemized on this webpage incorporate beach house, hillside condominium, and beach lodge.
Elicit uncommon, distinctive, various, and uncommon measurements in Seaside-Monterey California and enroll real estate rentals.
Bedmates, traveling sales representatives, and citizens who are studying bed and breakfast rentals Seaside-Monterey California and are trying to catch Seaside-Monterey California condo rentals and vacation rentals in Seaside-Monterey California can chase after our for rent by owner site, FRBO.com and our hillside listed properties, penthouse ads, convenient ads, and suburban listings.
Ascertain, light upon, and look up bed and breakfast rentals Vina, Vina condo rentals, and vacation rental Vina United States.
Join our lakefront classified ads and city ads mailing list for rent houses in Seaside-Monterey California and apartments for rent in Seaside-Monterey.
Ferret out and dig up Santa Barbara California bed and breakfast rentals, Santa Barbara holiday rentals, and homes for rent in Santa Barbara.
Determine, devise, and identify Sacramento California for rent by owner homes and Sacramento California apartment rentals.
Design, identify, and ascertain condo rentals in Mono, homes for rent by owner Mono, and Mono California apartment rentals.
Determine, discern, and find rent house in Modoc California, for rent by owner homes in Modoc California, Modoc rental houses, and short term rentals Modoc California.
Relocate and observe Camino rental homes and for rent by owner homes.
Oblige, enter, join up, and inscribe in the next few days to begin and enter upon on this roaming.
Send comely, handsome, charming, and divine brass tacks regarding Seaside-Monterey house rentals, Seaside-Monterey California home rentals, vacation homes, and Seaside-Monterey rental homes found on our page.
Distinguish and dig up vacation rentals, real estate rentals in Yuba California, and Yuba California rental homes.
Ascertain and debunk apartments for rent, condo rentals in Sutter California, house rentals Sutter California, and Sutter California apartments for rent.
Locate, uncover, and originate Mendocino house rentals, apartments for rent in Mendocino California, and condo rentals Mendocino.
Debunk, dig up, and discover San Mateo California homes for rent by owner, houses for rent in San Mateo California, San Mateo condo rentals, and for rent by owner homes in San Mateo California.
|
|
