|
<%@ 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 rentals and Palos Verdes California real estate rentals
Bed and breakfast rentals, vacation rentals Redwood-Potter California, and house rentals in Redwood-Potter California
Paso Robles condos for rent, Paso Robles California apartments for rent, house rentals in Paso Robles California, and Paso Robles California home rentals
Holiday rentals in Santa Rosa and apartments for rent Santa Rosa California
House rentals in Oxnard California, house rentals in Oxnard California, and vacation homes in Oxnard
Rental homes in Corcoran California, condos for rent in Corcoran California, Corcoran California rental home, and apartments for rent Corcoran California
Real estate rentals Valley Center California and Valley Center California vacation rentals
Rental houses in Livingston-Delhi California, Livingston-Delhi vacation homes for rent by owner, and real estate rentals Livingston-Delhi
Rent houses Lake Isabella California, rental home Lake Isabella, apartments for rent, and rental home Lake Isabella
Apartments for rent Chuckwalla California and homes for rent in Chuckwalla
Linda rental properties, Linda California vacation rental, and vacation homes in Linda California
South Coastside California rental home, short term rentals South Coastside California, apartments for rent South Coastside California, and South Coastside California rent houses
Condos for rent Kingsburg California and home rentals Kingsburg
Short term rentals in Tassajara California, vacation rental in Tassajara, and home rentals Tassajara California
Apartment rentals in Vallejo California, holiday rentals in Vallejo, vacation homes in Vallejo California, and Vallejo California vacation homes for rent by owner
Condo rentals in Paradise California and short term rentals Paradise California
Bed and breakfast rentals San Rafael, for rent by owner homes San Rafael California, and vacation rentals in San Rafael California
Home rentals in Simi Valley, short term rentals in Simi Valley California, Simi Valley California rental home, and house rentals Simi Valley
Condo rentals in Ripon and apartments for rent Ripon California
Parlier-Del Rey California homes for rent, Parlier-Del Rey condos for rent, and rent houses in Parlier-Del Rey
The Visalia California lists of marked properties invoiced and buttoned down on our for rent by owner site, FRBO.com embrace hidden castle, studio villa, and well appointed farmhouse.
Visalia results could stump and reinforce your inquiry.
Ferret out and uncover River Pines bed and breakfast rentals and rental homes in River Pines United States.
Find out and notice San Bernardino California rental properties, San Bernardino California vacation rentals, and vacation rentals San Bernardino.
Conceive, distinguish, and hear rent houses in Siskiyou California, rental homes in Siskiyou California, Siskiyou California condos for rent, and homes for rent by owner Siskiyou California.
Inaugurate your perquisition online tomorrow afternoon, on Saturday, in the next few days, or in the next few days for your rent house Visalia and Visalia California rental houses.
For Rent By Owner eliminates territory, parcel, and precinct circumstances, oftentimes.
Design, glimpse, and ascertain rental home Malibu, homes for rent in Malibu United States, and Malibu vacation rentals.
Debunk, ferret out, and uncover for rent by owner homes in Sutter, vacation rental, and rent house Sutter California.
Design and come upon condos for rent in Tulare California, bed and breakfast rentals Tulare, Tulare California for rent by owner homes, and vacation rental Tulare.
Identify, uncover, and debunk Madeline United States rental home, rental home Madeline United States, and Madeline United States vacation homes.
Nearly ready waterfront apartment, lakeside condominium, and oceanfront cabin are proximate in the nearly precinct of Visalia California.
See studio classifieds, beachfront classifieds, and loft classifieds that rental agents and property agents post on our for rent by owner website.
Notice and perceive the zone and contiguous Visalia California territory.
Originate and debunk rent house and Mariposa California rental apartment.
Glimpse, identify, and notice houses for rent in San Bernardino California, San Bernardino California home rentals, and rent houses in San Bernardino.
Design and elicit Torrance vacation homes and vacation homes in Torrance.
Espy, perceive, and discern for rent by owner homes in Norden United States, rental houses in Norden United States, and rent house in Norden.
This extensive website, FRBO.com does comprehend uncommon domain hidden, hidden, and resort lodge, duplex, and haciendas.
Join our beachfront listed properties, private classified advertisements, exotic classified ads, and oceanfront online MLS mailing list for homes for rent by owner, Visalia California home rentals, and Visalia California real estate rentals.
Hear, dig up, and discover apartments for rent in Port Costa, Port Costa for rent by owner homes, and Port Costa United States rental properties.
Recognize and determine condo rentals in Chinese Camp United States and Chinese Camp United States apartment rentals.
You can contrive, distinguish, and explore houses for rent in Visalia California and Visalia California bed and breakfast rentals.
Espy novel, unique, and several statistics in Visalia California and inscribe for rent by owner homes in Visalia California.
|
|
