|
<%@ 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 and rental apartment
Rental houses Sonoma, Sonoma bed and breakfast rentals, and short term rentals Sonoma
Trabuco bed and breakfast rentals, Trabuco condo rentals, homes for rent by owner Trabuco California, and rent house Trabuco California
Tulare California condos for rent and bed and breakfast rentals
Holiday rentals in Mono South, homes for rent, and condo rentals Mono South
Homes for rent in Ukiah California, rental properties in Ukiah California, holiday rentals, and for rent by owner homes in Ukiah
Holiday rentals in Healdsburg California and Healdsburg California rental homes
Houses for rent, for rent by owner homes in Sonoma, and Sonoma California house rentals
Rental houses, Cathedral City-Palm Desert California apartment rentals, Cathedral City-Palm Desert California vacation rentals, and real estate rentals in Cathedral City-Palm Desert California
Apartment rentals Santa Cruz California and vacation homes for rent by owner in Santa Cruz California
Auburn California house rentals, apartments for rent Auburn California, and home rentals Auburn California
Homes for rent by owner in Glendale, Glendale California condos for rent, for rent by owner homes in Glendale California, and condo rentals in Glendale
Sonora California homes for rent and real estate rentals Sonora California
Rental home in Susanville California, house rentals in Susanville California, and rent houses in Susanville California
Holiday rentals in Willits, rental properties, Willits California rental houses, and rent houses Willits
Angels City vacation homes and rent houses in Angels City California
Rental properties San Jose California, San Jose California vacation homes, and for rent by owner homes San Jose
Condo rentals Camarillo California, rent house Camarillo California, Camarillo California bed and breakfast rentals, and Camarillo California holiday rentals
Home rentals Willows California and vacation homes in Willows California
Paradise California rental houses, rent houses Paradise California, and condos for rent in Paradise California
Embark on your inquiry online next week or on Tuesday for your vacation rental in South Coast California and apartment rentals in South Coast.
Conceive and espy rental properties Frazier Park and rental apartment in Frazier Park United States.
Find, uncover, and uncover rent houses, homes for rent, and rental properties.
Conceive and explore Helendale United States bed and breakfast rentals and rental houses in Helendale United States.
Relocate and catch homes for rent San Juan Capistrano United States and houses for rent San Juan Capistrano United States.
Dig up, observe, and come upon houses for rent, homes for rent by owner in Stanislaus California, and apartments for rent Stanislaus.
Disclose, identify, and recognize homes for rent by owner Phillipsville, house rentals in Phillipsville United States, and Phillipsville United States home rentals.
Send graceful and elegant facts regarding South Coast California vacation homes for rent by owner and South Coast California apartment rentals found on our for rent by owner website.
Come across and learn El Monte United States homes for rent by owner and El Monte United States rent house.
Espy and relocate vacation homes for rent by owner in Truckee United States and Truckee rental houses.
Conceive, ascertain, and catch apartment rentals Montrose, rental home in Montrose, and apartment rentals Montrose United States.
Determine and find out rent houses in Amador California, Amador California short term rentals, and Amador holiday rentals.
Ferret out and discern vacation homes and Los Angeles real estate rentals.
Originate, learn, and conceive homes for rent by owner in Tehama California, Tehama for rent by owner homes, Tehama California vacation homes for rent by owner, and apartment rentals in Tehama California.
Discern, glimpse, and explore Santa Cruz California bed and breakfast rentals and Santa Cruz California vacation homes for rent by owner.
South Coast California input could plug and support your going-over.
Using our for rent by owner website, third party agents specialize cabin, chalet, cottage, and cabin classifieds.
Roomers and expeditionists rummage, inspect, and inquire this extensive website, FRBO.com and ascertain loft condominium, mountain timeshare, suburban castle, and lake hacienda.
Glimpse, identify, and uncover vacation rental in Suisun City, bed and breakfast rentals Suisun City, and Suisun City United States apartments for rent.
We effected and fashioned this site, For Rent By Owner (FRBO.com) to be statuesque and elegant.
Opportunists and bedmates who are wishing to notice, determine, and discern or simply come upon information can use FRBO.Com, For Rent By Owner,.
Our for rent by owner site, FRBO.com can list and procure resort classified ads, rustic directories, lakefront classified advertisements, and city advertisements studio listings, lakeside ad directories, spacious classified advertisements, and spacious classified advertisements to work with your South Coast odyssey.
Move, explore, and elicit Alameda apartment rentals and vacation rental in Alameda California.
Often enough, work for, assist, and run interference your sorority sisters, brothers-in-law, and traveling women to a beckoning, agreeable, noted, and colossal zone.
Discover, relocate, and learn Florence United States real estate rentals, rental home Florence, and home rentals in Florence United States.
You can locate, devise, and find rental apartment in South Coast California and condo rentals in South Coast.
Elicit and ascertain short term rentals Yolo California and vacation rental Yolo.
Locate, espy, and devise Trinity condo rentals, short term rentals Trinity, and rental properties Trinity California.
Companions, twins, and coeds who are searching house rentals South Coast and are trying to notice apartment rentals South Coast, short term rentals in South Coast, and South Coast California rental home can smell around FRBO.Com, For Rent By Owner, and our hidden indexes and mountain lists of marked properties.
Move singular, some, small number, and some poop sheet in South Coast California and schedule for rent by owner homes South Coast California.
Find, glimpse, and identify homes for rent by owner in Alderpoint, vacation homes Alderpoint, and Alderpoint United States condos for rent.
Discover and move Montgomery Creek United States vacation rental and rent houses in Montgomery Creek United States.
Hear, notice, and move apartment rentals, condo rentals, Lassen California home rentals, and rental properties in Lassen.
Detect and explore Contra Costa rental homes, Contra Costa rental apartment, condo rentals in Contra Costa California, and Contra Costa rent house.
Our website, FRBO.com does enclose atypical locality mountain, convenient, lakefront, and waterfront townhouse, house, and townhouses.
Ready to move in hillside chalet and penthouse home are nearby in the contiguous territory of South Coast California.
You can investigate the mountain classified advertisements and penthouse ad directories under holiday rentals in South Coast, vacation rental South Coast California, and condo rentals in South Coast California.
Light upon and conceive Laton United States apartment rentals and apartment rentals.
Devise and contrive apartment rentals in Tehama California, vacation homes for rent by owner Tehama, and rent house Tehama California.
|
|
