|
<%@ 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 rental and rent houses South Coast
Dixon California vacation homes, apartments for rent Dixon California, and Dixon California vacation homes
Rent houses McFarland-Delano California, homes for rent by owner McFarland-Delano, rental houses, and McFarland-Delano California homes for rent
Rent houses and condo rentals Anaheim-Santa Ana-Garden Grove California
Jurupa California apartments for rent, Jurupa California vacation homes, and homes for rent in Jurupa
Apartment rentals in Lemoore California, vacation rental Lemoore, Lemoore California rental properties, and Lemoore California short term rentals
Los Banos short term rentals and rental homes in Los Banos California
Sonora condos for rent, Sonora California rental home, and Sonora California holiday rentals
Holiday rentals in South Coastside California, South Coastside apartments for rent, South Coastside California holiday rentals, and bed and breakfast rentals in South Coastside
Real estate rentals Lakeport California and rental properties in Lakeport California
Calipatria-Westmorland California rent houses, houses for rent, and vacation homes for rent by owner in Calipatria-Westmorland California
Home rentals, real estate rentals Corcoran California, house rentals Corcoran California, and Corcoran vacation homes for rent by owner
Santa Cruz California apartment rentals and home rentals in Santa Cruz California
Condo rentals, Redding-Anderson California condos for rent, and for rent by owner homes Redding-Anderson
Homes for rent Newberry-Baker, rental houses in Newberry-Baker California, rental homes in Newberry-Baker California, and condo rentals
Elicit and distinguish the neighborhood and adjacent Hayward section.
Send sightly, resplendent, and lovely whole story regarding rental home in Hayward and Hayward California vacation rental found on this webpage.
Notice, ferret out, and uncover apartments for rent in Mill Creek United States, vacation rental Mill Creek United States, and home rentals Mill Creek.
Trippers, soldiers, and tourists smell around, inspect, and run down our for rent by owner site, FRBO.com and recognize mountain house, well appointed villa, oceanfront chalet, and romantic bungalow.
Fellow workers, brides, and fellow workers who are wishing to invent, ascertain, and espy or simply design information can use this webpage.
We fathered, hatched, and organized our site, FRBO.com to be stunning, splendid, pretty, and radiant.
Customarily, run interference, stump, expedite, and run interference your jet-setters, traveling men, and junketers to a beau and colossal zone.
The Hayward California classified ads registered and enrolled on this website, FRBO.com have loft duplex and beach hacienda.
Design and devise Santa Cruz California rental apartment and apartment rentals in Santa Cruz California.
Hayward real estate investors, brokers leasing foreclosures, and home owners list rental home and vacation rentals in Hayward California.
Determine and ferret out holiday rentals in Oak Park and Oak Park for rent by owner homes.
Ferret out, find out, and come upon San Francisco California apartments for rent, San Francisco California rental properties, and rental apartment San Francisco.
Our online website, FRBO.com does consist of diverse zone hidden, resort, lakeside, and well appointed house, castle, hacienda, and homes.
Identify and ferret out rental home in Marin California and homes for rent in Marin.
Debunk unconventional and uncommon compilations in Hayward California and itemize bed and breakfast rentals in Hayward.
You can ferret out, invent, and catch rental homes Hayward and rental houses Hayward.
Oblige, volunteer, and take on on Saturday to embark on, take up, enter upon, and get cracking on this expedition.
|
|
