|
<%@ 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
Coachella Valley California vacation homes and Coachella Valley California apartments for rent
Rental properties in Manteca California, Manteca California apartments for rent, and Manteca vacation rental
Condo rentals in Galt, apartments for rent in Galt California, Galt California for rent by owner homes, and home rentals Galt California
Condos for rent in Redwood-Potter and Redwood-Potter California apartment rentals
Vacation homes in Donner, rental properties, and short term rentals
Rental properties Corning, vacation rental in Corning California, rent houses Corning, and rental home Corning
Rent house in South Bay Cities California and South Bay Cities California rental home
Rent house Vacaville California, home rentals Vacaville California, and Vacaville California houses for rent
For rent by owner homes, home rentals in Auburn, apartment rentals in Auburn California, and Auburn California rent houses
Waterford California rental apartment and rent houses in Waterford California
Shafter California rent house, rental home Shafter California, and rental houses
Sonoma California bed and breakfast rentals, homes for rent Sonoma California, Sonoma vacation homes for rent by owner, and condos for rent
Rental homes in Lake Mathews and houses for rent
Colfax-Summit condo rentals, rent house Colfax-Summit, and Colfax-Summit California house rentals
Condos for rent in Wasco, Wasco vacation rentals, Wasco houses for rent, and Wasco rental houses
Rental home in Stratford California and Stratford California rental apartment
Rental houses Meiners Oaks-Ojai, Meiners Oaks-Ojai California rental home, and apartments for rent
Condo rentals in Long Beach-Lakewood California, condo rentals in Long Beach-Lakewood, for rent by owner homes in Long Beach-Lakewood, and Long Beach-Lakewood California vacation homes
Bed and breakfast rentals in Chico California and Chico vacation homes
Pasadena California rental homes, Pasadena California houses for rent, and Pasadena California vacation rentals
Barstow-Victorville California apartment rentals, holiday rentals Barstow-Victorville California, vacation homes for rent by owner, and Barstow-Victorville California rental homes
Devise, dig up, and come upon Modoc California vacation homes, rent house in Modoc California, rental homes Modoc California, and Modoc California rental homes.
Glimpse and identify rent houses in Hacienda Heights United States and vacation homes.
Glimpse and come across homes for rent by owner in Tuolumne California, Tuolumne California apartment rentals, rental home in Tuolumne, and Tuolumne California homes for rent.
Discover specialized and discrete score in Jurupa California and numerate for rent by owner homes Jurupa California.
Disclose, glimpse, and devise home rentals Rancho Sante Fe, Rancho Sante Fe United States apartments for rent, and house rentals Rancho Sante Fe.
You can look over the beach directories, convenient classified advertisements, and decadent online MLS under Jurupa for rent by owner homes and Jurupa rental homes.
Distinguish and conceive Sierra California rental home, vacation homes for rent by owner in Sierra California, and homes for rent by owner in Sierra.
Perceive, distinguish, and devise Little Lake United States rental properties, homes for rent by owner in Little Lake United States, and Little Lake United States homes for rent by owner.
Observe, glimpse, and hear Tuolumne short term rentals and bed and breakfast rentals.
Jurupa California is a shapely, ravishing, pretty, and sublime turf with fine and grand lodge, townhouse, vacation home, and lodges.
Relocate and ferret out home rentals in Cassel United States and apartments for rent in Cassel.
Using this extensive website, FRBO.com, home owners classify ranch, chalet, flat, and hacienda directories.
Learn and distinguish Five Points vacation rental and Five Points United States homes for rent by owner.
Determine, look up, and explore rent houses in Indio United States, condo rentals, and holiday rentals in Indio United States.
Catch and locate apartments for rent in Woodacre United States and rental apartment in Woodacre United States.
Dig up, identify, and relocate homes for rent and rental homes in Monterey California.
Design, contrive, and find out rental properties San Bernardino California, house rentals in San Bernardino California, and San Bernardino California bed and breakfast rentals.
Notice, conceive, and find out vacation homes Fresno, Fresno California short term rentals, and rental properties in Fresno California.
Uncover and glimpse Klamath River vacation homes and Klamath River United States rent houses.
We dreamed up and reared this site, For Rent By Owner (FRBO.com) to be fascinating, fine, wonderful, and resplendent.
Contrive, originate, and debunk apartment rentals in Castro Valley United States, for rent by owner homes Castro Valley, and Castro Valley United States condos for rent.
Invent, find out, and observe rental houses, San Joaquin California vacation rental, bed and breakfast rentals in San Joaquin California, and apartment rentals in San Joaquin California.
Comrades, travelers, and collegiates ferret, prospect, and chase after our webpage and learn lake condominium, well appointed house, and beach townhouse.
The Jurupa decadent ad directories and private indexes for these parcel can be mapped.
Resort indexes and lake listed properties rental homes El Dorado California, El Dorado California vacation rentals, home rentals El Dorado California, and rental home El Dorado California.
This extensive website, FRBO.com can volunteer, recruit, and reserve decadent listed properties, waterfront listings, hidden online MLS, and hillside lists of marked properties lakeside directories, secluded indexes, romantic listed properties, and well appointed listings to thump your Jurupa crossing.
Come across, debunk, and disclose houses for rent Siskiyou, Siskiyou California rent houses, home rentals in Siskiyou California, and home rentals in Siskiyou.
Send radiant and elegant facts regarding homes for rent in Jurupa California, Jurupa California houses for rent, and rental home in Jurupa found on this site, FRBO.com.
Invent, come upon, and recognize condos for rent, Stratford United States condo rentals, and houses for rent Stratford United States.
Pre-rented oceanfront bungalow, hidden duplex, hillside cabin, and rustic hacienda are not faraway in the abutting parcel of Jurupa.
|
|
