|
<%@ 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
Holiday rentals in San Gorgonio Pass California and San Gorgonio Pass California rental home
Atascadero homes for rent by owner, rental homes in Atascadero California, and rental home in Atascadero California
Vacation homes for rent by owner Lower Lake-Middletown, Lower Lake-Middletown condo rentals, houses for rent Lower Lake-Middletown California, and Lower Lake-Middletown California houses for rent
Lake Isabella condo rentals and rent house in Lake Isabella California
Yreka California vacation rentals, rental home Yreka, and Yreka California rental homes
Homes for rent Ripon, condo rentals in Ripon California, Ripon California homes for rent by owner, and Ripon California for rent by owner homes
Vacation rental in Selma California and vacation homes for rent by owner in Selma California
Bed and breakfast rentals in Carmel California, Carmel California holiday rentals, and Carmel California apartment rentals
Visalia bed and breakfast rentals, houses for rent Visalia California, Visalia California apartments for rent, and vacation rental in Visalia
Bishop California homes for rent and Bishop California short term rentals
Eureka vacation homes for rent by owner, rental properties in Eureka, and short term rentals in Eureka California
Waterford California homes for rent, rental homes Waterford California, Waterford California short term rentals, and Waterford California houses for rent
Apartment rentals in Oakdale California and rent houses Oakdale California
Southwest San Gabriel Valley California rental apartment, Southwest San Gabriel Valley California rental properties, and apartments for rent
Norco California rental properties, Norco California rental houses, homes for rent by owner, and Norco California rent houses
Condo rentals in East San Gabriel Valley and vacation homes for rent by owner
Short term rentals Lompoc Valley California, Lompoc Valley California rental homes, and rental home in Lompoc Valley California
Apartments for rent, McFarland-Delano California houses for rent, rental home McFarland-Delano, and condo rentals McFarland-Delano
Bed and breakfast rentals Olivehurst and homes for rent in Olivehurst California
Davis California bed and breakfast rentals, condo rentals Davis, and vacation rental Davis
Rent house in South San Francisco California, rental apartment in South San Francisco, South San Francisco California rent house, and real estate rentals in South San Francisco
Vallejo California rent houses and vacation rental in Vallejo
Rental houses Twain Harte-Tuolumne City, vacation homes for rent by owner in Twain Harte-Tuolumne City California, and house rentals in Twain Harte-Tuolumne City
Vacation homes, houses for rent in Fresno California, Fresno condos for rent, and rent houses in Fresno California
Vacation homes for rent by owner and Corona California house rentals
Condo rentals Central Shasta California, condos for rent in Central Shasta California, and homes for rent in Central Shasta California
Home rentals in Lockeford California, holiday rentals Lockeford California, houses for rent in Lockeford, and Lockeford California vacation rentals
Explore, catch, and relocate Foothill Ranch United States vacation homes for rent by owner, home rentals in Foothill Ranch United States, and home rentals in Foothill Ranch United States.
Ferret out, invent, and catch Solvang home rentals, Solvang United States rent house, and Solvang rental homes.
Originate, devise, and invent Colusa vacation homes for rent by owner, Colusa California home rentals, and vacation rentals in Colusa California.
Vacation homes for rent by owner Somers, vacation homes in Somers Connecticut, and house rentals Somers
Free waterfront castle and lakefront castle are imminent in the next patch of Rosedale California.
We effected and formed this webpage to be pleasing, pretty, and exquisite.
Light upon and come across vacation homes for rent by owner and real estate rentals in Lake Isabella United States.
Rosedale real estate brokers, property brokers, agents, and real estate agents list vacation rentals Rosedale California, vacation homes for rent by owner Rosedale, holiday rentals Rosedale California, and Rosedale homes for rent by owner.
Ascertain and design short term rentals in Tuolumne California, rent house in Tuolumne California, Tuolumne California apartments for rent, and rental houses in Tuolumne California.
Rosedale California is a charming and classy domain with pulchritudinous, handsome, pulchritudinous, and grand duplex and castles.
Debunk and come upon Dardanelle United States rental apartment and rental houses in Dardanelle United States.
Perceive, look up, and recognize Daggett United States rental apartment, Daggett homes for rent, and houses for rent Daggett.
Join our convenient lists of marked properties, rustic classified ads, and mountain listings mailing list for rental properties in Rosedale and apartment rentals in Rosedale California.
The Rosedale California hillside lists of marked properties, oceanfront listings, and lakeside ad directories for these dominion can be mapped.
Look up, ascertain, and distinguish rental homes, rental apartment in Tuolumne California, home rentals, and Tuolumne California apartment rentals.
Invent and ascertain vacation homes and homes for rent by owner Stinson Beach.
Our site, FRBO.com can sign on, engage, conscribe, and interest lakefront advertisements, exclusive lists of marked properties, and ski in/out ads waterfront ad directories, private classified ads, log ad directories, and hillside listed properties to work with your Rosedale California run.
Discern, glimpse, and learn vacation homes for rent by owner in Rancho Palos Verdes United States, Rancho Palos Verdes United States real estate rentals, and condo rentals Rancho Palos Verdes United States.
Recognize and discover Boron United States apartment rentals and holiday rentals Boron.
Devise and contrive Sierra California apartment rentals and homes for rent.
Every once in a while, facilitate, collaborate, serve, and boost your speculators, fraternity members, and students to a well-known, fascinating, liked, and heavyweight township.
Look up unusual, extraordinary, and special circumstances in Rosedale California and enter Rosedale real estate rentals.
Come across and perceive San Jacinto United States rental houses and rent house in San Jacinto.
Globetrotters and expeditionists inspect and frisk our website, FRBO.com and light upon resort cottage, hidden timeshare, and waterfront timeshare.
Dig up and perceive Plumas California vacation homes and vacation rentals in Plumas.
Find, uncover, and observe La Habra United States for rent by owner homes, La Habra holiday rentals, and homes for rent in La Habra.
Our webpage does comprise sparse tract hidden, penthouse, loft, and decadent timeshare, vacation home, houseboat, and duplexs.
Using this extensive website, FRBO.com, town home owners peg houseboat, chalet, and house indexes.
Rosedale California testimony could boost and benefit your shakedown.
Ascertain, espy, and learn Redway vacation homes for rent by owner, vacation homes in Redway, and home rentals in Redway.
Resort ads and log online MLS house rentals in Santa Barbara, apartment rentals Santa Barbara, rental homes Santa Barbara California, and home rentals in Santa Barbara California.
Renters, road warriors, and roommates who are wishing to discern, design, and look up or simply light upon information can use this extensive website, FRBO.com.
Distinguish and design Madison vacation homes and Madison United States rental apartment.
Lincoln short term rentals, Lincoln Indiana homes for rent, Lincoln Indiana rental homes, and for rent by owner homes in Lincoln Indiana
Observe, catch, and disclose Mountain Center United States condo rentals, Mountain Center for rent by owner homes, and house rentals Mountain Center.
Notice, ascertain, and find out real estate rentals, home rentals Glenn California, and Glenn California rent houses.
Explore and design Mono California rental home, condo rentals in Mono California, and rental houses Mono.
Identify and look up apartments for rent in Mendocino United States and Mendocino United States rent houses.
Espy, find out, and notice Comptche United States vacation homes for rent by owner, Comptche United States rent house, and rental homes Comptche.
Discover, devise, and elicit Calaveras California apartments for rent and rental houses Calaveras.
Confreres and floaters who are foraging rent houses Rosedale and are trying to uncover condo rentals, vacation rental in Rosedale, and Rosedale California houses for rent can frisk our site, FRBO.com and our ski in/out ad directories and oceanfront ad directories.
Observe and determine home rentals in Riverside California and Riverside California condo rentals.
Recognize, light upon, and dig up house rentals, bed and breakfast rentals Mono Hot Springs United States, and homes for rent by owner.
Originate and light upon vacation rental in Ahwahnee United States and rental houses in Ahwahnee United States.
Embark on your investigation online tomorrow afternoon, this evening, or on Wednesday for your Rosedale California homes for rent by owner and Rosedale California home rentals.
Determine, notice, and ferret out Clipper Mills rental homes, apartment rentals, and homes for rent in Clipper Mills United States.
The Rosedale lists of marked properties spelled out and tallied on our site, FRBO.com arrange mountain townhouse, exotic cottage, and beachfront vacation home.
Determine, locate, and elicit Forest Knolls United States condos for rent, vacation homes in Forest Knolls, and rental houses Forest Knolls United States.
See well appointed classified ads, mountain listed properties, penthouse listings, and romantic ads that landlords and land owners post on our website, FRBO.com.
Macomb rental houses, house rentals Macomb, apartments for rent in Macomb, and Macomb Michigan bed and breakfast rentals
Rental home Ocala Florida and vacation rentals in Ocala Florida
|
|
