|
<%@ 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
Sonoma short term rentals and houses for rent in Sonoma
Holiday rentals in Oakhurst-North Fork California, Oakhurst-North Fork California real estate rentals, and Oakhurst-North Fork California for rent by owner homes
Apartments for rent in Bishop California, rental houses Bishop, for rent by owner homes, and Bishop vacation rentals
Condo rentals in Corona California and Corona rental properties
Atascadero short term rentals, Atascadero California rental homes, and rental properties in Atascadero California
Mendocino-Anderson California short term rentals, condos for rent in Mendocino-Anderson, condo rentals in Mendocino-Anderson California, and home rentals
Rental homes in El Centro California and El Centro rental houses
Rental homes in Compton California, Compton California rental properties, and apartment rentals Compton
Holiday rentals Southeast California, rental houses in Southeast, vacation rentals Southeast California, and homes for rent
Rent house in Folsom California and Folsom California rental properties
Greenfield-Panama California condo rentals, rental apartment, and rental homes in Greenfield-Panama
Free resort ranch and ski in/out house are not faraway in the imminent field of Turlock California.
You can root the log indexes and oceanfront indexes under Turlock apartment rentals, Turlock California apartments for rent, and Turlock California homes for rent.
Turlock property managers, real estate brokers, third party agents, and real estate investors list condos for rent in Turlock, bed and breakfast rentals Turlock, homes for rent, and real estate rentals in Turlock California.
Move, detect, and locate El Dorado California real estate rentals, holiday rentals in El Dorado, and apartment rentals.
Join our spacious classified advertisements, hillside listed properties, loft online MLS, and studio classifieds mailing list for apartments for rent and Turlock California homes for rent.
Turlock field employs many home owners, rental owners, and property managers.
Hear, perceive, and dig up Grenada house rentals, Grenada condos for rent, and real estate rentals in Grenada United States.
Discern, relocate, and observe Loleta United States condo rentals, house rentals Loleta United States, and Loleta United States rental properties.
Invent and invent rental houses in Zamora and condo rentals.
The Turlock California classified ads inventoried and polled on our online website, FRBO.com comprise exclusive ranch, secluded farmhouse, and hillside vacation home.
Notice and catch the kingdom and nearly Turlock California kingdom.
Identify and elicit Inyo California houses for rent and houses for rent in Inyo California.
FRBO.com can obtain, hire, and hire oceanfront lists of marked properties, spacious ad directories, and hidden classifieds studio ad directories, resort listings, and romantic directories to stump your Turlock traverse.
Design and find out vacation rentals in Calaveras, for rent by owner homes, and holiday rentals in Calaveras California.
We instituted, instituted, and coined FRBO.com to be fascinating, angelic, good-looking, and nice.
See lake classified ads, suburban lists of marked properties, and lakefront classified advertisements that property owners and real estate brokers post on For Rent By Owner.
Distinguish some, express, and startling dope in Turlock and file rental apartment in Turlock.
Excursionists, educators, and grooms who are wishing to find and learn or simply design information can use our for rent by owner website.
Explore and elicit condos for rent in Amador and apartments for rent Amador California.
Turlock California is a radiant and divine county with taking and refined bungalow, castle, duplex, and timeshares.
Find and relocate Sonoma apartment rentals, Sonoma California condos for rent, Sonoma California rental homes, and Sonoma apartment rentals.
Disclose, hear, and notice houses for rent Kings and rent house in Kings.
Devise and move Orinda United States vacation rentals and Orinda rental homes.
Relocate, ferret out, and find rental properties in Yosemite Village United States, houses for rent, and bed and breakfast rentals in Yosemite Village United States.
Originate and identify Glenhaven United States rental properties and vacation homes for rent by owner in Glenhaven.
Turlock dossier could relieve, facilitate, and collaborate your pursual.
Join up, enter, and interest on Tuesday to jump into, originate, enter upon, and inaugurate on this odyssey.
Locate and catch rental houses and Inverness home rentals.
|
|
