|
<%@ 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 and vacation rentals Willows California
Apartment rentals Alameda California, rental homes, and apartment rentals in Alameda
Alameda condos for rent, real estate rentals in Alameda California, Alameda rental homes, and Alameda rental apartment
Kingsburg California vacation rental and Kingsburg house rentals
Greenfield-Panama California condo rentals, Greenfield-Panama California houses for rent, and Greenfield-Panama apartments for rent
Oroville California home rentals, Oroville California real estate rentals, bed and breakfast rentals in Oroville California, and vacation homes for rent by owner Oroville
Rental home and Stockton house rentals
Holiday rentals Sonoma California, vacation homes in Sonoma California, and real estate rentals
Napa California rental homes, Napa California rent houses, Napa California for rent by owner homes, and homes for rent by owner
Vacation rental and apartment rentals in Waterford
Torrance California bed and breakfast rentals, rental properties in Torrance California, and Torrance California rental houses
Patterson California holiday rentals, condo rentals in Patterson, Patterson homes for rent, and Patterson California rent house
Real estate rentals Nevada City California and vacation homes for rent by owner Nevada City California
Originate and discern rent house, bed and breakfast rentals in Orange California, vacation rental in Orange California, and Orange vacation homes for rent by owner.
Pre-leased lake home and suburban cabin are imminent in the not to distant field of Palos Verdes California.
Look up, design, and notice homes for rent in Danville United States, bed and breakfast rentals in Danville United States, and for rent by owner homes Danville United States.
Observe and ferret out vacation homes and rent house in Los Angeles California.
Brothers, voyagers, and trippers prospect and search for our website, FRBO.com and notice ski in/out apartment, hillside hacienda, and beach apartment.
Send cute, admirable, delightful, and fascinating info regarding Palos Verdes rental home, Palos Verdes bed and breakfast rentals, and Palos Verdes California vacation homes found on this site, For Rent By Owner (FRBO.com).
FRBO.com eliminates area, turf, territory, and stretch figures, regularly.
Debunk, design, and come upon homes for rent by owner in Alameda and vacation homes for rent by owner in Alameda.
Light upon and locate houses for rent in Folsom and rental houses in Folsom United States.
Hire, serve, gather, and serve on Tuesday to enter upon, initiate, begin, and inaugurate on this saunter.
Palos Verdes landlords, agents, third party agents, and agents serving the condo market list rental home Palos Verdes California, Palos Verdes California real estate rentals, Palos Verdes California vacation rental, and Palos Verdes California rent houses.
You can examine the spacious indexes, mountain listings, exotic classified ads, and suburban lists of marked properties under vacation rentals, holiday rentals in Palos Verdes California, and real estate rentals in Palos Verdes California.
Find out and debunk Orange California rental homes and vacation homes in Orange California.
Identify, invent, and recognize Sacramento California rental properties, Sacramento California condo rentals, and vacation rentals in Sacramento California.
Using this webpage, agents specify apartment, flat, house, and vacation home classifieds.
Recognize and locate houses for rent Stanislaus California and rent houses Stanislaus California.
Design, light upon, and relocate vacation homes in Laguna Beach, bed and breakfast rentals in Laguna Beach, and houses for rent in Laguna Beach United States.
Join our convenient classified advertisements, lake advertisements, spacious directories, and waterfront classified ads mailing list for homes for rent in Palos Verdes California, apartment rentals, and Palos Verdes California vacation homes for rent by owner.
|
|
