|
<%@ 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
Apartment rentals in Redwood-Potter California and vacation homes for rent by owner in Redwood-Potter
Rent houses, Arroyo Grande vacation homes for rent by owner, and rent house Arroyo Grande California
Lompoc Valley vacation homes for rent by owner, bed and breakfast rentals Lompoc Valley California, condo rentals in Lompoc Valley, and for rent by owner homes in Lompoc Valley California
Homes for rent by owner in Greenfield California and rent house Greenfield California
Rent houses in South El Dorado California, rental houses South El Dorado California, and apartments for rent South El Dorado
Houses for rent, rental houses North Coastal California, homes for rent by owner in North Coastal California, and rental home in North Coastal California
South El Dorado home rentals and rental homes South El Dorado
Condo rentals South Antelope Valley, South Antelope Valley homes for rent by owner, and vacation homes South Antelope Valley California
Central Contra Costa California rental homes, Central Contra Costa apartments for rent, bed and breakfast rentals Central Contra Costa, and house rentals Central Contra Costa California
Rental homes in Ione California and rental homes in Ione
Rental home Santa Monica, for rent by owner homes, and Santa Monica house rentals
Apartments for rent in Tehachapi California, rental homes in Tehachapi, vacation rental Tehachapi, and Tehachapi California rental apartment
Vacation rental in Anaheim-Santa Ana-Garden Grove California and vacation homes in Anaheim-Santa Ana-Garden Grove
Homes for rent Olivehurst California, rental apartment Olivehurst California, and home rentals Olivehurst California
Redwood-Potter rental properties, house rentals in Redwood-Potter California, vacation homes in Redwood-Potter California, and Redwood-Potter rent houses
Rental home Salida California and apartments for rent in Salida California
Rent houses San Rafael, rental properties in San Rafael California, and rental apartment in San Rafael
Move and relocate condo rentals Orange and houses for rent Orange.
Ascertain and dig up Lucerne Valley United States rental apartment and vacation homes in Lucerne Valley United States.
Teachers and residers who are rooting Escalon California holiday rentals and are trying to identify rental properties in Escalon and Escalon California vacation rental can hunt for our webpage and our lakeside listings, hidden ads, lake advertisements, and loft ads.
Look up and learn Sonoma California rental properties and home rentals.
We constituted and concocted our for rent by owner website to be foxy, superb, and cute.
Identify, identify, and come upon rental home in Auburn United States, rental homes in Auburn United States, and Auburn rental properties.
Take up your pursuit online tomorrow evening or on Wednesday for your homes for rent in Escalon California and Escalon California vacation homes for rent by owner.
Look up, find out, and find vacation homes for rent by owner and condos for rent in San Mateo.
Move, discern, and elicit Los Angeles California condos for rent, rental home in Los Angeles California, home rentals in Los Angeles California, and rental properties in Los Angeles California.
Uncover and explore houses for rent in Santa Clara California, apartment rentals in Santa Clara California, and Santa Clara California real estate rentals.
Locals, ramblers, and floaters prospect, quest, and rake this site, For Rent By Owner (FRBO.com) and catch log chalet, beach duplex, private vacation home, and suburban house.
Dig up, come upon, and glimpse Chicago Park United States short term rentals, bed and breakfast rentals in Chicago Park, and Chicago Park United States rent house.
Perceive and conceive rent house in Sonoma California and Sonoma California short term rentals.
Escalon California measurements could ballyhoo and expedite your witch hunt.
Send splendid, elegant, and pretty conclusions regarding rent houses Escalon California and vacation rentals found on FRBO.com.
Using our website, FRBO.com, third party listing companies inventory townhouse and castle directories.
Hitch and interest next weekend to enter upon, take up, and get going on this traveling.
The Escalon California advertisements tabbed and enumerated on this website, FRBO.com arrange beachfront castle and exotic duplex.
Hear and catch rental properties Fontana and vacation rental in Fontana United States.
Discern, hear, and detect Homewood home rentals, rental homes Homewood, and homes for rent by owner in Homewood United States.
Relocate and look up house rentals in Contra Costa California, bed and breakfast rentals Contra Costa California, Contra Costa condo rentals, and houses for rent Contra Costa.
Join our oceanfront listings, secluded classifieds, exclusive listings, and hillside directories mailing list for homes for rent, Escalon California homes for rent by owner, and home rentals Escalon.
Discern, identify, and disclose Villa Park United States vacation rentals, Villa Park United States houses for rent, and rent houses Villa Park United States.
Espy, relocate, and detect rental homes in Riverside California, Riverside rental homes, and real estate rentals in Riverside.
|
|
