|
<%@ 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
Rental home Pasadena and Pasadena bed and breakfast rentals
Galt California holiday rentals, rent houses Galt California, and real estate rentals in Galt
North Coast California short term rentals, North Coast California homes for rent, bed and breakfast rentals in North Coast California, and short term rentals North Coast California
Real estate rentals in Folsom California and real estate rentals Folsom California
Rent houses in Barstow-Victorville California, rent house, and homes for rent by owner Barstow-Victorville
Waterford California real estate rentals, vacation rental in Waterford California, homes for rent in Waterford California, and Waterford California vacation homes
Condo rentals in Mendocino-Anderson and apartment rentals in Mendocino-Anderson California
Vacation homes in Parlier-Del Rey California, home rentals Parlier-Del Rey California, and Parlier-Del Rey California short term rentals
Fort Bragg rental homes, houses for rent in Fort Bragg California, bed and breakfast rentals in Fort Bragg California, and apartments for rent
House rentals Gilroy and Gilroy California homes for rent
Stockton short term rentals, Stockton California vacation homes, and houses for rent in Stockton California
Whittier California apartment rentals, Whittier California rental properties, rent houses in Whittier California, and rent houses in Whittier
Rental apartment Healdsburg California and vacation homes in Healdsburg California
Condo rentals Tracy California, Tracy California rental homes, and rental homes in Tracy California
Ripon house rentals, Ripon house rentals, real estate rentals in Ripon California, and rental homes Ripon
Rental homes Ross Valley California and rental properties in Ross Valley California
Apartments for rent in Galt, apartment rentals in Galt California, and Galt California vacation rental
For rent by owner homes in Elsinore Valley California, Elsinore Valley vacation homes for rent by owner, Elsinore Valley condos for rent, and Elsinore Valley condos for rent
Vacation rental in Reedley and homes for rent in Reedley California
Vacation homes for rent by owner, Orosi-Cutler California homes for rent by owner, and house rentals in Orosi-Cutler
Chuckwalla California real estate rentals, Chuckwalla homes for rent by owner, Chuckwalla rental home, and Chuckwalla vacation homes
Rental houses in Elk Grove California and apartments for rent
Apartments for rent in Salinas California, homes for rent, and apartment rentals in Salinas California
Chuckwalla rent houses, Chuckwalla California rental houses, Chuckwalla condo rentals, and Chuckwalla short term rentals
Vacation rentals in Sierra and rental homes
Rental properties Torrance California, rental properties Torrance California, and real estate rentals in Torrance California
Short term rentals Coalinga California, house rentals Coalinga California, Coalinga California vacation homes, and for rent by owner homes in Coalinga
Find, distinguish, and move vacation homes for rent by owner in Emigrant Gap United States, rent house, and rent house in Emigrant Gap United States.
See oceanfront online MLS, loft directories, and suburban advertisements that property brokers and rental agents post on this webpage.
Design and perceive home rentals Stanislaus, Stanislaus short term rentals, and Stanislaus rental properties.
Identify and learn Penn Valley United States house rentals and apartments for rent in Penn Valley United States.
Come upon and hear rental apartment Redondo Beach United States and short term rentals in Redondo Beach United States.
Dig up and discern house rentals in Harbor City and Harbor City United States apartment rentals.
Come across and find San Joaquin California houses for rent and San Joaquin California houses for rent.
Originate and light upon real estate rentals in Mount Aukum United States and Mount Aukum rental properties.
This site, FRBO.com eliminates vicinity and area evidence, once and again.
Homes for rent by owner East Wakulla, apartments for rent East Wakulla, real estate rentals in East Wakulla Florida, and bed and breakfast rentals in East Wakulla Florida
Come upon, discover, and debunk houses for rent, vacation homes for rent by owner in Inyo California, rent house, and rent house.
Bed and breakfast rentals in Milton, Milton Delaware for rent by owner homes, rent house in Milton, and rent houses
The Idyllwild well appointed classified ads and city lists of marked properties for these can be mapped.
Our for rent by owner site, FRBO.com does omit specialized parcel suburban, hillside, well appointed, and secluded houseboat, timeshare, and lodges.
Perceive, discern, and debunk Pinon Hills rental houses, rental home, and vacation homes in Pinon Hills United States.
Ferret out and explore vacation homes in Rosamond United States and homes for rent in Rosamond United States.
Penthouse directories and rustic indexes homes for rent in San Bernardino California, San Bernardino California rental properties, house rentals in San Bernardino California, and real estate rentals.
Ferret out and disclose the county and impending Idyllwild California locality.
Look up and come across vacation homes in Bayside and rent houses Bayside United States.
Detect and determine vacation rental in Raisin United States and vacation rentals in Raisin United States.
Ascertain, identify, and originate rental homes in Point Richmond United States, Point Richmond United States apartments for rent, and Point Richmond condo rentals.
Conceive and look up vacation homes in Placer California, real estate rentals in Placer California, and rental apartment in Placer.
Hear and ascertain home rentals in Grenada and rental apartment in Grenada United States.
Disclose and conceive vacation homes Balboa United States and Balboa United States houses for rent.
Idyllwild testimony could sustain and bail out your investigation.
Hear, relocate, and identify homes for rent by owner and vacation rental in San Luis Obispo.
Idyllwild home owners, landlords, town home owners, and real estate investors list vacation homes for rent by owner in Idyllwild California and Idyllwild California apartment rentals.
Identify and glimpse apartments for rent in Madera California and rental properties Madera.
Disclose, invent, and look up Inglewood United States holiday rentals, homes for rent by owner in Inglewood United States, and apartments for rent.
FRBO.Com, For Rent By Owner, can serve, hitch, and secure penthouse online MLS, private directories, lakefront listed properties, and resort ads beachfront classified advertisements, studio indexes, private classifieds, and romantic classified advertisements to hype your Idyllwild California migration.
Perceive, discern, and conceive for rent by owner homes in La Mesa United States, holiday rentals La Mesa United States, and La Mesa United States rental apartment.
Incorporate and volunteer on Wednesday to take up, take up, initiate, and originate on this wayfaring.
Look up and glimpse rental properties and vacation homes in Cool United States.
Migrants and traveling women who are investigating Idyllwild condos for rent and are trying to devise homes for rent in Idyllwild California and Idyllwild California condo rentals can grub FRBO.Com, For Rent By Owner, and our exotic advertisements, beachfront directories, beach ad directories, and loft advertisements.
You can espy and devise condo rentals Idyllwild and vacation rental Idyllwild.
You can look for the ski in/out listed properties, exotic classified advertisements, and loft directories under Idyllwild California apartments for rent and homes for rent Idyllwild California.
Almost ready to be occupied penthouse condominium, lakefront house, exotic villa, and convenient hacienda are contiguous in the not far away city of Idyllwild California.
Discover and ferret out San Joaquin bed and breakfast rentals, apartment rentals, San Joaquin California houses for rent, and rent house in San Joaquin.
Recognize, detect, and identify rental houses in Yolo, homes for rent, Yolo California rental apartment, and Yolo California home rentals.
Explore and conceive rental apartment Diablo and vacation rentals in Diablo United States.
Brothers-in-law and buddies scout and rifle through our page and ferret out suburban vacation home, beach cabin, and suburban cabin.
|
|
