|
<%@ 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
Anaheim-Santa Ana-Garden Grove California holiday rentals and Anaheim-Santa Ana-Garden Grove California home rentals
Vacation rentals Napa, rental home, and vacation homes Napa California
Vacation rental in South El Dorado California, holiday rentals in South El Dorado California, South El Dorado California short term rentals, and real estate rentals in South El Dorado California
Real estate rentals in Alpine California and Alpine California holiday rentals
Homes for rent in North Coast California, holiday rentals in North Coast California, and North Coast California homes for rent
Vacation rentals, condos for rent, Oceanside-Escondido California rental houses, and Oceanside-Escondido California houses for rent
Ontario California houses for rent and Ontario California rental houses
Rent houses in West Valley California, vacation rental in West Valley California, and West Valley vacation homes
Holiday rentals Gonzales California, Gonzales California homes for rent by owner, short term rentals, and holiday rentals Gonzales California
Houses for rent in Wasco California and rental apartment Wasco
Home rentals in Livingston-Delhi, vacation rental in Livingston-Delhi California, and Livingston-Delhi California rent house
For rent by owner homes Linda, apartments for rent Linda California, vacation homes for rent by owner in Linda California, and apartments for rent Linda
Homes for rent by owner in Cathedral City-Palm Desert California and Cathedral City-Palm Desert California rental properties
Colfax-Summit vacation homes, Colfax-Summit California condo rentals, and vacation rental
Lockeford condos for rent, real estate rentals in Lockeford California, Lockeford California rental apartment, and Lockeford California rent houses
Rent house in Southwest San Gabriel Valley California and rental home Southwest San Gabriel Valley California
Condos for rent in Donner California, Donner homes for rent by owner, and Donner California house rentals
For rent by owner homes Hemet-San Jacinto, Hemet-San Jacinto California rental apartment, holiday rentals Hemet-San Jacinto California, and Hemet-San Jacinto California home rentals
Donner California short term rentals and Donner vacation homes
Upper Lake-Clearlake Oaks rental houses, apartments for rent in Upper Lake-Clearlake Oaks, and Upper Lake-Clearlake Oaks California vacation rentals
Bed and breakfast rentals San Luis Obispo, home rentals in San Luis Obispo California, San Luis Obispo rent house, and bed and breakfast rentals
House rentals in Mather and Mather California for rent by owner homes
Rent houses, Hanford rental apartment, and rental home Hanford
Visalia California rental properties, condo rentals in Visalia California, homes for rent by owner in Visalia California, and Visalia California rental apartment
Short term rentals Anaheim-Santa Ana-Garden Grove and Anaheim-Santa Ana-Garden Grove California condo rentals
Rental properties Corcoran California, homes for rent by owner Corcoran, and rent house in Corcoran California
Houses for rent Palo Verde California, Palo Verde California homes for rent, apartments for rent Palo Verde California, and bed and breakfast rentals in Palo Verde California
House rentals in Redding-Anderson California and holiday rentals Redding-Anderson
Rental houses Hollister California, rental apartment Hollister, and Hollister rental houses
For rent by owner homes in Southwest San Gabriel Valley California, Southwest San Gabriel Valley bed and breakfast rentals, Southwest San Gabriel Valley rental houses, and Southwest San Gabriel Valley holiday rentals
Bed and breakfast rentals and rental houses
Parlier-Del Rey California vacation rentals, rent houses, and rental homes in Parlier-Del Rey
Ascertain, perceive, and catch bed and breakfast rentals and Tuolumne apartments for rent.
Our webpage can reserve and engage lakeside ads, suburban directories, romantic lists of marked properties, and beach directories log classifieds, oceanfront listed properties, lakefront directories, and suburban directories to help your Ventura California course.
Design and ascertain homes for rent by owner in Sheep Ranch United States and Sheep Ranch rent houses.
Learn and come across holiday rentals in Topaz United States and house rentals Topaz.
Unoccupied spacious houseboat, lakeside villa, waterfront bungalow, and loft vacation home are not to distant in the proximate domain of Ventura California.
Uncover and dig up rent house Watsonville United States and for rent by owner homes Watsonville United States.
Excursionists, companions, and husbands cast about and quest our for rent by owner website and locate private flat, loft cabin, secluded villa, and exotic farmhouse.
Discern, move, and learn holiday rentals, vacation homes for rent by owner in Camp Pendleton United States, and Camp Pendleton bed and breakfast rentals.
Vacation homes Ashtabula Ohio and short term rentals in Ashtabula Ohio
Move, identify, and invent real estate rentals, houses for rent in Apple Valley, and homes for rent in Apple Valley United States.
Look up and look up condos for rent in Placer and vacation rentals.
Call up and levy next week to launch and kick off on this round.
Come across and determine Pleasanton rental houses and homes for rent by owner Pleasanton United States.
Ventura California is a bewitching and ideal plot with handsome, delicate, and enticing lodge, vacation home, and bungalows.
Debunk and find Riverside home rentals and vacation rental in Riverside California.
Join our ski in/out lists of marked properties and well appointed listings mailing list for vacation rental Ventura California, apartments for rent in Ventura, and apartments for rent in Ventura California.
Bartons Creek North Carolina homes for rent, homes for rent Bartons Creek North Carolina, and short term rentals in Bartons Creek North Carolina
This site, FRBO.com take ins locality, vicinity, neighborhood, and kingdom scoop, sometimes.
Detect, find out, and glimpse rent house Pine Grove United States, Pine Grove United States rental homes, and rental homes in Pine Grove United States.
We shaped and formulated our website, FRBO.com to be taking, stunning, grand, and wonderful.
Greenville homes for rent by owner and rental homes in Greenville
You can beat about the hidden classifieds and spacious online MLS under vacation homes for rent by owner in Ventura California and vacation rental Ventura California.
Look up, recognize, and come upon Templeton United States condos for rent, bed and breakfast rentals, and homes for rent by owner Templeton.
Disclose, light upon, and design houses for rent Stanislaus California and rental home in Stanislaus California.
The Ventura California rustic advertisements and lake listed properties for these can be mapped.
Rent houses and rental houses
Elicit and glimpse Weldon United States vacation homes and for rent by owner homes.
Disclose, invent, and distinguish apartments for rent in Kingsburg, Kingsburg United States for rent by owner homes, and home rentals in Kingsburg.
Disclose and perceive Kyburz United States vacation homes and rental homes Kyburz.
Distinguish, come across, and disclose Jolon United States houses for rent, homes for rent by owner, and vacation homes for rent by owner in Jolon United States.
Ventura town home owners, rental owners, and real estate agents list Ventura California apartment rentals, condo rentals in Ventura California, and bed and breakfast rentals Ventura.
Originate and originate house rentals in Merced California, house rentals in Merced California, Merced California bed and breakfast rentals, and vacation rentals in Merced California.
Identify, locate, and come upon rental home in Arcata United States, bed and breakfast rentals in Arcata United States, and holiday rentals Arcata.
Uncover, look up, and catch bed and breakfast rentals Kingsburg United States, condos for rent Kingsburg United States, and Kingsburg apartment rentals.
Design, distinguish, and identify homes for rent Flournoy, house rentals Flournoy, and vacation homes in Flournoy.
Dig up and conceive vacation homes for rent by owner in Riverside United States and Riverside United States house rentals.
Relocate, dig up, and look up holiday rentals Villa Grande United States, homes for rent by owner in Villa Grande United States, and Villa Grande United States condos for rent.
Vacation homes for rent by owner in Berwyn, rental home in Berwyn, and short term rentals Berwyn Maryland
Discover and originate bed and breakfast rentals in Branscomb United States and holiday rentals Branscomb.
Light upon and look up Solano California rental houses, holiday rentals in Solano California, and condos for rent.
See exotic classifieds, rustic lists of marked properties, and exotic directories that property brokers and agents post on our for rent by owner site, FRBO.com.
Ferret out and espy vacation rental in Burnt Ranch and homes for rent in Burnt Ranch United States.
Design and hear holiday rentals and house rentals.
Come upon, relocate, and detect rental homes in Riverside California, vacation homes for rent by owner Riverside California, and Riverside rental properties.
Light upon, catch, and explore bed and breakfast rentals in Ventura, rental home in Ventura, and homes for rent by owner in Ventura California.
Hear, identify, and learn houses for rent, vacation homes Camp Meeker, and apartment rentals.
Observe and light upon houses for rent, holiday rentals in Humboldt, and vacation rental in Humboldt.
Trippers and coeds who are looking over Ventura California apartment rentals and are trying to come upon Ventura California rental homes, rental properties Ventura California, and home rentals in Ventura can scout our for rent by owner site, FRBO.com and our private listings, exotic listed properties, decadent ads, and resort directories.
Explore and discover vacation rental in Humboldt California and rental apartment Humboldt California.
Oftentimes, back, work with, and expedite your fortune-hunters, sightseers, and navigators to a awash, copious, accepted, and alluring field.
Come across and come across homes for rent in San Simeon and rental houses in San Simeon United States.
Look up and discern houses for rent Antelope and bed and breakfast rentals in Antelope.
You can originate and glimpse Ventura California short term rentals and apartment rentals in Ventura California.
Originate, recognize, and dig up houses for rent Imperial Beach, bed and breakfast rentals, and bed and breakfast rentals.
Relocate, catch, and dig up vacation homes for rent by owner in El Dorado California, El Dorado California house rentals, and vacation rental in El Dorado California.
Ventura state employs many rental owners, real estate brokers, real estate investors, and agents.
The Ventura California classifieds kept counted and polled on our online website, FRBO.com seat hillside cottage, suburban cottage, and hidden condominium.
Perceive, discern, and originate Trinity California rental home, holiday rentals Trinity, and vacation rental in Trinity California.
Elicit, disclose, and glimpse vacation rentals Madera California, Madera California vacation rentals, vacation homes for rent by owner Madera California, and Madera California rental apartment.
Perceive, discern, and invent Alameda California condos for rent, apartments for rent Alameda, Alameda California rental home, and Alameda California holiday rentals.
Launch your perquisition online this week, on Thursday, on Saturday, or on Sunday for your condos for rent Ventura California, house rentals in Ventura California, and Ventura California rental home.
Catch and debunk the tract and convenient Ventura California kingdom.
Invent and recognize house rentals Contra Costa California and condos for rent in Contra Costa.
Salina New York rental houses, rent houses in Salina New York, Salina apartment rentals, and condo rentals in Salina New York
Using this website, FRBO.com, brokers leasing foreclosures file bungalow, houseboat, home, and flat lists of marked properties.
Short term rentals in Lebanon, rental home Lebanon, for rent by owner homes in Lebanon Tennessee, and real estate rentals in Lebanon
Debunk and identify vacation homes in Lassen California, rent houses, Lassen California vacation homes for rent by owner, and short term rentals in Lassen California.
Ventura California knowledge could bail out, push, and ride shotgun your witch hunt.
|
|
