|
<%@ 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
Homes for rent Lake Mathews and rental apartment
Rent houses San Lorenzo Valley California, houses for rent San Lorenzo Valley California, and vacation homes for rent by owner
Fresno apartment rentals, vacation rental, home rentals Fresno, and vacation homes Fresno
Rental home in Galt California and homes for rent by owner
Condo rentals in Bishop California, Bishop California for rent by owner homes, and Bishop California rental homes
Bed and breakfast rentals in Fairfield-Suisun City, Fairfield-Suisun City rental houses, rent houses in Fairfield-Suisun City California, and apartment rentals Fairfield-Suisun City California
Napa California home rentals and rental apartment
Twentynine Palms-Morongo Valley California apartments for rent, Twentynine Palms-Morongo Valley rent houses, and rent houses in Twentynine Palms-Morongo Valley California
House rentals, Redding-Anderson California condo rentals, short term rentals in Redding-Anderson, and Redding-Anderson California rental homes
Brawley California apartment rentals and apartment rentals in Brawley California
Rent house, vacation rentals in East Kern California, and vacation rentals East Kern
Condos for rent in Willows, short term rentals in Willows California, rental houses Willows California, and Willows California rental home
Rental houses Folsom and rental apartment
Rosedale California condos for rent, vacation homes for rent by owner in Rosedale California, and for rent by owner homes in Rosedale California
Vacation rental Donner, rent houses in Donner California, apartment rentals, and Donner real estate rentals
Home rentals North Antelope Valley California and apartments for rent North Antelope Valley
Apartments for rent, houses for rent in Calabasas California, and Calabasas California vacation homes for rent by owner
Ukiah California house rentals, Ukiah California apartments for rent, rental houses, and rental properties
Short term rentals in Newberry-Baker California and bed and breakfast rentals in Newberry-Baker California
Nevada City California apartment rentals, apartment rentals in Nevada City California, and rental properties
Homes for rent by owner in Marysville California, vacation rentals in Marysville California, vacation homes, and Marysville California rental home
Santa Barbara California vacation rental and Santa Barbara house rentals
Gonzales California bed and breakfast rentals, Gonzales apartments for rent, and Gonzales California house rentals
Houses for rent Vacaville, rental apartment Vacaville, apartments for rent, and Vacaville homes for rent
Salida California apartments for rent and Salida California rent houses
Watsonville California vacation rental, houses for rent in Watsonville, and rental apartment in Watsonville California
Arvin-Lamont California homes for rent by owner, rental home in Arvin-Lamont California, homes for rent in Arvin-Lamont California, and Arvin-Lamont vacation rentals
Vacaville California rent houses and rental properties in Vacaville California
Calipatria-Westmorland California rental apartment, Calipatria-Westmorland bed and breakfast rentals, and rental apartment in Calipatria-Westmorland California
Vacation rental Alpine California, Alpine for rent by owner homes, Alpine California bed and breakfast rentals, and Alpine California rental properties
Perceive and devise Moorpark real estate rentals and house rentals in Moorpark.
Eufaula Alabama apartments for rent, rental home Eufaula, vacation homes, and home rentals in Eufaula Alabama
Come upon and discover Orange California homes for rent and for rent by owner homes in Orange California.
Sandusky Ohio vacation rental and condo rentals in Sandusky Ohio
Locate, find, and discover the parcel and not far away Salinas California stretch.
Disclose, disclose, and notice Caspar United States vacation rentals, homes for rent Caspar, and Caspar United States rental apartment.
Real estate rentals in Upper San Gabriel Valley, Upper San Gabriel Valley California houses for rent, and house rentals in Upper San Gabriel Valley California
Espy, dig up, and come across Lake for rent by owner homes, condo rentals in Lake California, rental home Lake, and rental home.
Espy, look up, and hear vacation homes Greenview United States, Greenview rental houses, and for rent by owner homes in Greenview.
Originate, observe, and contrive Kit Carson United States homes for rent by owner, homes for rent Kit Carson United States, and Kit Carson apartment rentals.
Roamers, itinerants, and pilgrims ransack, root, and prospect our webpage and hear oceanfront lodge, suburban cottage, log ranch, and decadent houseboat.
Tremonton Utah rental houses and Tremonton Utah house rentals
Dig up, distinguish, and glimpse rent house in Paso Robles United States, rental home, and rental homes in Paso Robles United States.
Devise and contrive Lincoln rental houses and Lincoln United States vacation homes.
Relocate, find, and locate bed and breakfast rentals, apartments for rent, and Hathaway Pines United States houses for rent.
Identify, light upon, and learn Orange California bed and breakfast rentals, rental properties Orange California, and rental homes in Orange California.
Notice and observe condo rentals in Thermal and Thermal United States apartments for rent.
Find and come across rental houses in Lake, vacation rental, and bed and breakfast rentals in Lake California.
Dig up and perceive Kings California short term rentals and vacation homes Kings California.
Distinguish and find Santa Rosa bed and breakfast rentals and Santa Rosa vacation rental.
Beach ads and oceanfront lists of marked properties Mendocino California homes for rent by owner, apartment rentals in Mendocino California, Mendocino California rental home, and house rentals in Mendocino.
Ferret out, hear, and dig up rental houses in Kern California, Kern California for rent by owner homes, and rental houses in Kern.
Look up and determine condos for rent Floriston United States and rental homes Floriston.
You can invent, conceive, and devise vacation rentals in Salinas California, real estate rentals Salinas, and Salinas California rental houses.
You can cast about the studio ad directories, mountain advertisements, lakeside online MLS, and hidden ads under apartments for rent Salinas and bed and breakfast rentals Salinas California.
Gather, get, and secure next weekend to embark on and get going on this traverse.
Join our spacious advertisements, hidden ads, waterfront classified advertisements, and suburban ad directories mailing list for rental homes Salinas and Salinas California homes for rent.
Husbands, sorority sisters, and commuters who are poking into rent house and are trying to distinguish Salinas rental apartment and Salinas vacation rental can study this webpage and our ski in/out listings, secluded ads, private indexes, and exotic listings.
Uncover, locate, and espy Acton bed and breakfast rentals, Acton homes for rent, and for rent by owner homes in Acton United States.
Notice, learn, and notice rental houses Trinity, houses for rent Trinity, and bed and breakfast rentals in Trinity California.
Apartments for rent Western Virginia, rental apartment in Western Virginia, and bed and breakfast rentals in Western
FRBO.Com, For Rent By Owner, does incorporate another sector ski in/out, waterfront, studio, and exclusive bungalow and castles.
Illinois Arkansas houses for rent, Illinois Arkansas rental properties, rental houses, and vacation rental in Illinois Arkansas
Identify and ascertain vacation homes for rent by owner Millville United States and vacation rentals Millville.
Identify, conceive, and identify vacation homes for rent by owner in Klamath River, real estate rentals in Klamath River United States, and condo rentals in Klamath River United States.
Look up and perceive rent house in Willow Brook and bed and breakfast rentals.
We constructed, authored, and planned our webpage to be excellent, nice, excellent, and ravishing.
Perceive, disclose, and detect houses for rent in Calaveras California and short term rentals Calaveras California.
See well appointed online MLS, well appointed ads, hillside listed properties, and exotic listings that brokers leasing foreclosures and condo owners post on our for rent by owner website.
|
|
