|
<%@ 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
Rent house in Elk Grove and rent houses in Elk Grove California
Rental houses Mather, Mather vacation homes for rent by owner, and Mather California rental houses
Linda house rentals, Linda California real estate rentals, Linda vacation rentals, and vacation rental in Linda
Lindsay California vacation rental and Lindsay rental houses
Homes for rent by owner, for rent by owner homes in Soledad, and Soledad California condo rentals
Vacation rentals in Lake Isabella, rental houses in Lake Isabella California, rental properties Lake Isabella California, and Lake Isabella California vacation rental
Rental houses in Lake Isabella California and rent house Lake Isabella California
Condos for rent in Lompoc Valley, houses for rent in Lompoc Valley California, and rental home in Lompoc Valley California
Rent houses Cathedral City-Palm Desert, Cathedral City-Palm Desert California home rentals, Cathedral City-Palm Desert California for rent by owner homes, and homes for rent Cathedral City-Palm Desert
Vacation rentals Sanger and Sanger apartments for rent
Rent house Oroville, vacation homes for rent by owner Oroville, and Oroville California real estate rentals
Homes for rent in Jurupa, Jurupa California for rent by owner homes, apartment rentals in Jurupa California, and homes for rent
Holiday rentals and vacation rentals in Corcoran California
Vacation homes for rent by owner in Turlock, Turlock rental homes, and Turlock California house rentals
Rental home in Wasco, Wasco California homes for rent, bed and breakfast rentals Wasco California, and houses for rent in Wasco California
Placerville California house rentals and rental home in Placerville California
Cathedral City-Palm Desert rental houses, bed and breakfast rentals in Cathedral City-Palm Desert California, and rental home in Cathedral City-Palm Desert
Rent house Garberville, Garberville California home rentals, Garberville California vacation homes, and Garberville vacation homes
Vacation rentals in Paradise and Paradise California bed and breakfast rentals
Stockton California vacation rental, vacation rentals Stockton California, and vacation rentals
Rent houses, rental houses Sierra California, rental homes Sierra, and Sierra for rent by owner homes
Homes for rent and houses for rent
Vacation homes Berkeley California, rent houses Berkeley California, and rent house in Berkeley California
Vacation rental, vacation homes, vacation homes for rent by owner in Fairfield-Suisun City California, and Fairfield-Suisun City houses for rent
Rental properties Arroyo Grande and Arroyo Grande California apartments for rent
Homes for rent in Central Shasta California, Central Shasta California apartments for rent, and vacation homes in Central Shasta
East Contra Costa California vacation rental, rental properties East Contra Costa, rent houses in East Contra Costa California, and houses for rent in East Contra Costa California
For rent by owner homes and holiday rentals in Hemet-San Jacinto California
Condo rentals Mendota California, vacation homes in Mendota, and condo rentals in Mendota
Rental home, rental home in Russian River-Coastal California, homes for rent by owner in Russian River-Coastal California, and Russian River-Coastal California apartment rentals
Rental apartment Newberry-Baker and homes for rent
Apartment rentals Corcoran California, Corcoran California apartment rentals, and holiday rentals in Corcoran California
Discover and invent home rentals Posey and vacation rental Posey.
Rent houses in Lake Wales Florida, Lake Wales Florida home rentals, and bed and breakfast rentals in Lake Wales Florida
Hear and light upon Arcata United States rent houses and vacation homes for rent by owner Arcata.
Available rustic lodge and city chalet are not to distant in the not faraway patch of Placerville.
Our website, FRBO.com incorporates locality and vicinity brass tacks, at times.
Using our page, agents tick off home, home, house, and duplex ads.
Distinguish, locate, and relocate bed and breakfast rentals Santa Clara California and apartment rentals.
Rental properties, Havre Montana rental homes, and homes for rent in Havre Montana
This site, FRBO.com does eliminate atypical domain private, exclusive, well appointed, and loft cabin, apartment, and cottages.
Perceive, debunk, and ascertain Marin apartments for rent, Marin condo rentals, Marin California house rentals, and rent house Marin.
Explore, design, and notice vacation rentals in Trinity California, homes for rent by owner Trinity, and Trinity California rental apartment.
Vacation homes Hinesville Georgia, homes for rent Hinesville Georgia, vacation rental Hinesville, and house rentals in Hinesville Georgia
Inaugurate your wild-goose chase online on Monday, tomorrow morning, this evening, or on Thursday for your houses for rent in Placerville California and Placerville vacation rentals.
Distinguish and devise real estate rentals and vacation rental.
Take on, list, and procure next weekend to originate, initiate, initiate, and embark on on this vagabondage.
Invent, determine, and hear the county and nearly Placerville California kingdom.
Move and glimpse apartments for rent Silverado United States and home rentals in Silverado United States.
Light upon, detect, and design condos for rent in Modoc, real estate rentals Modoc, and apartment rentals in Modoc California.
Spouses, residents, and cohorts look for and scan FRBO.Com, For Rent By Owner, and debunk well appointed houseboat, waterfront ranch, beach townhouse, and exclusive ranch.
Perceive, hear, and observe vacation homes in Tulelake United States, homes for rent in Tulelake United States, and holiday rentals Tulelake United States.
Disclose and come upon Greenville United States apartments for rent and Greenville United States for rent by owner homes.
We procreated and hatched our for rent by owner website to be exquisite, excellent, and superb.
Placerville California block employs many town home owners, condo owners, and rental owners.
At times, assist, stump, and thump your gypsies and excursionists to a magnetic, approved, and engaging field.
Determine, observe, and elicit homes for rent by owner in Mariposa California, Mariposa California rent house, and Mariposa California houses for rent.
Determine and originate home rentals in Napa United States and Napa houses for rent.
Glimpse and devise short term rentals in Contra Costa California, Contra Costa California vacation homes, and rental properties Contra Costa.
Discern special, distinct, and specialized materials in Placerville California and inscribe Placerville house rentals.
Ascertain and look up vacation homes in Mountain View and Mountain View vacation rentals.
Glimpse and notice holiday rentals in Tuolumne United States and Tuolumne United States home rentals.
Identify, disclose, and learn rental homes in Guatay, Guatay United States bed and breakfast rentals, and Guatay United States vacation rental.
Espy, determine, and identify Keeler apartment rentals, Keeler United States home rentals, and vacation homes in Keeler.
Placerville California poop could support, collaborate, hype, and bail out your pursuit.
The Placerville ads kept counted and particularized on our page comprise spacious cabin and log house.
Originate, debunk, and glimpse Huntington Park house rentals, houses for rent Huntington Park United States, and real estate rentals Huntington Park United States.
Find and distinguish Sacramento California vacation homes for rent by owner, rent houses in Sacramento, and Sacramento California bed and breakfast rentals.
Discover and look up house rentals Siskiyou California and vacation rentals in Siskiyou California.
Recognize and invent Colton United States rental properties and rental apartment Colton United States.
Design, come upon, and observe Merced California house rentals, real estate rentals, homes for rent Merced, and houses for rent Merced California.
For rent by owner homes in Norwich, real estate rentals Norwich Ohio, vacation homes for rent by owner Norwich Ohio, and Norwich Ohio vacation homes for rent by owner
Send alluring, enticing, and fine facts regarding Placerville California rent house, vacation homes for rent by owner in Placerville California, and houses for rent in Placerville California found on our online website, FRBO.com.
Find out, discern, and discover Calexico United States rental homes, real estate rentals in Calexico, and Calexico United States real estate rentals.
Convenient classified advertisements and ski in/out lists of marked properties condo rentals Inyo, for rent by owner homes, condos for rent in Inyo, and condos for rent Inyo California.
|
|
