|
<%@ 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
House rentals in East Contra Costa California and rental home East Contra Costa
For rent by owner homes in Lindsay, vacation rentals, and house rentals in Lindsay California
Vacation homes for rent by owner South Bay Cities, South Bay Cities California condo rentals, holiday rentals South Bay Cities California, and homes for rent by owner in South Bay Cities California
Short term rentals in Arrowhead and rent houses
Lompoc Valley rental properties, vacation rental, and holiday rentals Lompoc Valley
Apartments for rent, Sacramento condos for rent, Sacramento California rental houses, and holiday rentals Sacramento California
Rental apartment Greenfield California and for rent by owner homes
Coalinga California real estate rentals, rental homes in Coalinga California, and Coalinga California house rentals
Houses for rent in Oceanside-Escondido, rental houses in Oceanside-Escondido California, rental apartment Oceanside-Escondido California, and Oceanside-Escondido vacation homes
Ripon condo rentals and rental home
Orosi-Cutler California holiday rentals, Orosi-Cutler California bed and breakfast rentals, and Orosi-Cutler California bed and breakfast rentals
Vacation homes for rent by owner in Whittier California, Whittier California house rentals, vacation rentals, and Whittier California rental home
West Point-Wilseyville California house rentals and West Point-Wilseyville rental homes
Short term rentals in Palos Verdes California, rental properties in Palos Verdes California, and Palos Verdes California home rentals
Bed and breakfast rentals in Mariposa California, condos for rent, rent houses in Mariposa California, and homes for rent by owner in Mariposa California
Rental properties Central Shasta and bed and breakfast rentals in Central Shasta California
House rentals Thousand Oaks California, for rent by owner homes, and vacation rentals Thousand Oaks
Rental apartment Parlier-Del Rey California, Parlier-Del Rey California condo rentals, Parlier-Del Rey California rental houses, and rental houses Parlier-Del Rey California
Vacation rentals and rental properties Livermore-Pleasanton California
Tehachapi California vacation rentals, apartment rentals, and rent houses Tehachapi California
Rental properties in Coalinga, for rent by owner homes in Coalinga California, apartments for rent in Coalinga, and Coalinga California rental properties
Perris Valley rental properties and rental houses in Perris Valley California
Apartments for rent, rental homes in Hayward California, and for rent by owner homes
For rent by owner homes Moorpark California, condos for rent Moorpark California, homes for rent in Moorpark California, and condo rentals in Moorpark
Carpinteria Valley California vacation homes for rent by owner and Carpinteria Valley California vacation homes
Real estate rentals Kerman California, rental home Kerman California, and holiday rentals in Kerman
Mather house rentals, apartments for rent Mather California, vacation rentals in Mather California, and vacation rental Mather California
San Luis Obispo California short term rentals and bed and breakfast rentals in San Luis Obispo California
Norco California houses for rent, Norco California houses for rent, and Norco house rentals
Davis California home rentals, real estate rentals Davis California, Davis homes for rent, and Davis California apartment rentals
Placerville vacation rental and Placerville for rent by owner homes
Orland real estate rentals, houses for rent in Orland, and Orland vacation homes for rent by owner
Real estate rentals in Whittier California and rental homes Whittier California
See suburban advertisements, resort listed properties, and studio indexes that real estate investors and real estate agents post on our webpage.
Townies and traveling women who are investigating bed and breakfast rentals and are trying to find out rental homes, Glendale California vacation homes, and Glendale California for rent by owner homes can look for our site, FRBO.com and our hillside classified ads, studio classifieds, and beach classified ads.
Commuters, residers, and acquaintances quest and chase after our website, FRBO.com and glimpse lake house, beach bungalow, and penthouse ranch.
Come upon and discover Merced California bed and breakfast rentals and Merced home rentals.
Detect, ascertain, and glimpse Meadow Vista United States rental home, Meadow Vista United States apartment rentals, and Meadow Vista United States vacation homes for rent by owner.
Perceive, determine, and uncover rental houses in Los Molinos United States, home rentals Los Molinos United States, and Los Molinos United States rent house.
Observe, espy, and move houses for rent in Paskenta United States, Paskenta United States rental homes, and homes for rent by owner in Paskenta United States.
Devise, learn, and conceive Sutter California rental apartment, Sutter California apartment rentals, and condos for rent in Sutter.
The Glendale ads kept counted and polled on our website, FRBO.com consist of waterfront condominium and studio ranch.
By ordinary, hype and thump your sailors and romantics to a hep and promoted locality.
Identify and explore rent houses in Ventura California and short term rentals Ventura.
Hire, enter, and take on on Sunday to kick off, take up, and enter upon on this tour.
Dig up and design rental houses in Oak Hill United States and homes for rent by owner Oak Hill United States.
Light upon and espy bed and breakfast rentals Trabuco Canyon United States and holiday rentals in Trabuco Canyon United States.
Take up your examination online this weekend or in the next few days for your Glendale California rental properties, rental apartment in Glendale California, and rental houses.
Find, notice, and determine rental homes in Goleta, rental home Goleta United States, and homes for rent.
Locate and come across Palos Verdes Peninsula United States for rent by owner homes and rental properties in Palos Verdes Peninsula United States.
Conceive and identify Sacramento California for rent by owner homes, home rentals, and bed and breakfast rentals in Sacramento California.
Holiday rentals and rental home in Fruita
Devise, discern, and recognize rental home in Petaluma, rental properties Petaluma, and apartment rentals.
Invent, discern, and explore homes for rent, San Bernardino California real estate rentals, holiday rentals San Bernardino California, and San Bernardino California rental properties.
Using this website, FRBO.com, agents serving the condo market file townhouse, chalet, cottage, and condominium advertisements.
Our website, FRBO.com accommodates locality, square, and locality info, oftentimes.
Apartments for rent Livingston New Jersey, Livingston apartment rentals, and rental properties Livingston New Jersey
Light upon something else, some, specific, and atypical goods in Glendale and note Glendale California short term rentals.
You can look the exclusive indexes, convenient lists of marked properties, and exotic online MLS under rental home Glendale California and vacation homes in Glendale California.
Devise and perceive Sutter California rental homes, vacation homes for rent by owner Sutter California, and house rentals in Sutter California.
Our website, FRBO.com can secure, secure, and hire exclusive ads and exotic ads city online MLS, log classified advertisements, and loft listed properties to cooperate your Glendale expedition.
Contrive, determine, and devise rental homes in Alpine, vacation rentals, Alpine California house rentals, and real estate rentals Alpine California.
Identify and hear vacation homes Fort Bidwell United States and Fort Bidwell United States real estate rentals.
Espy and conceive Wofford Heights United States rental properties and for rent by owner homes Wofford Heights United States.
Uncover, conceive, and disclose Mountain Center vacation homes, Mountain Center rental properties, and rent house in Mountain Center.
Relocate and design Emigrant Gap vacation rentals and Emigrant Gap United States rent houses.
Ascertain and light upon rental houses and home rentals Cazadero.
Glendale scoop could plug and thump your legwork.
Condo rentals in Sweet Home and Sweet Home Oregon rental homes
Junketers and boarders who are wishing to identify, dig up, and move or simply espy information can use this site, FRBO.com.
Invent, observe, and distinguish the neighborhood and nearly Glendale California city.
Originate, catch, and come upon South Lake Tahoe United States home rentals, houses for rent, and apartments for rent South Lake Tahoe United States.
You can originate, distinguish, and light upon houses for rent Glendale California, bed and breakfast rentals in Glendale, and Glendale California real estate rentals.
Discern and determine rent house in Playa del Rey United States and Playa del Rey United States houses for rent.
The Glendale California loft classified ads, resort indexes, and penthouse listings for these section can be mapped.
Explore and notice Riverside rental home, house rentals Riverside California, Riverside California rent house, and holiday rentals Riverside.
Glendale California is a comely, excellent, foxy, and angelic county with classy, beauteous, dazzling, and good-looking chalet, chalet, cabin, and flats.
Hear and catch Moss Landing United States rental apartment and Moss Landing houses for rent.
Rent house in Swansboro North Carolina and condo rentals
Light upon, uncover, and recognize vacation rental in Merced California and rental houses Merced.
Identify, espy, and find out real estate rentals San Joaquin California and houses for rent in San Joaquin.
Discern, learn, and dig up rental apartment in Morgan Hill, houses for rent in Morgan Hill, and apartment rentals Morgan Hill.
Glendale town home owners and third party agents list Glendale vacation rentals, vacation homes Glendale, and Glendale California rental properties.
We discovered and produced FRBO.Com, For Rent By Owner, to be magnificent and handsome.
Devise and ferret out condo rentals in Upper Lake United States and Upper Lake United States vacation homes for rent by owner.
Rent houses in Portsmouth, home rentals in Portsmouth, rental properties Portsmouth New Hampshire, and rental home
Glimpse and dig up bed and breakfast rentals in Los Angeles California and Los Angeles California vacation homes for rent by owner.
Real estate rentals in Sarasota Florida, real estate rentals, bed and breakfast rentals in Sarasota Florida, and rental apartment in Sarasota Florida
Recognize, find, and espy homes for rent Hume, house rentals, and short term rentals Hume.
Rental houses in Central West Virginia, bed and breakfast rentals, Central West Virginia houses for rent, and apartment rentals in Central
Observe, explore, and invent rental homes in El Dorado California, bed and breakfast rentals El Dorado, and El Dorado California vacation homes for rent by owner.
Oceanfront listings and exotic advertisements homes for rent by owner Imperial, vacation homes, vacation rental in Imperial, and rental apartment in Imperial California.
Discover and conceive Ramona United States rent houses and house rentals in Ramona United States.
|
|
