|
<%@ 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
Home rentals and rent house in Bakersfield California
Sonoma California vacation homes, apartment rentals, and Sonoma short term rentals
Holiday rentals Tassajara, bed and breakfast rentals, Tassajara rental houses, and holiday rentals Tassajara
For rent by owner homes and bed and breakfast rentals in Cloverdale-Geyserville
Rental properties in Woodlake-Three Rivers, short term rentals Woodlake-Three Rivers California, and real estate rentals in Woodlake-Three Rivers California
Modesto rental apartment, Modesto California bed and breakfast rentals, Modesto California vacation rentals, and Modesto California rental properties
Vacation rental Gonzales California and rent houses Gonzales California
Real estate rentals in West Valley California, house rentals in West Valley California, and rental home
Holiday rentals Thousand Oaks California, Thousand Oaks California homes for rent by owner, homes for rent Thousand Oaks, and Thousand Oaks California vacation homes for rent by owner
Condos for rent in Newhall California and rent houses Newhall California
Redding-Anderson California rental apartment, rent house in Redding-Anderson, and rent houses
Vacation rental in Red Bluff California, bed and breakfast rentals, Red Bluff rent house, and condos for rent
Vacation rental Grass Valley and Grass Valley California houses for rent
Rental properties Earlimart, Earlimart California apartments for rent, and condos for rent in Earlimart California
Vacation homes for rent by owner Salinas, holiday rentals in Salinas California, Salinas California apartments for rent, and Salinas California vacation rental
Condos for rent in Linda and apartments for rent in Linda
Sebastopol California rental home, rental homes, and rent house
Marysville California homes for rent by owner, bed and breakfast rentals, Marysville California homes for rent by owner, and vacation homes in Marysville California
Houses for rent in Barstow-Victorville California and vacation homes
Lower Lake-Middletown California condos for rent, home rentals, and rental properties
Condos for rent Trabuco California, rental home in Trabuco, for rent by owner homes in Trabuco, and for rent by owner homes Trabuco California
Apartment rentals in Downey-Norwalk California and vacation homes for rent by owner in Downey-Norwalk California
For rent by owner homes in South Antelope Valley California, rental apartment in South Antelope Valley California, and homes for rent by owner South Antelope Valley California
Apartment rentals Hemet-San Jacinto California, Hemet-San Jacinto California bed and breakfast rentals, rental properties Hemet-San Jacinto, and rental properties
Homes for rent by owner Paso Robles and rent house in Paso Robles California
Real estate rentals Vallejo, rental home in Vallejo, and Vallejo California rental homes
Vacation homes for rent by owner in Lake Isabella California, Lake Isabella apartments for rent, Lake Isabella short term rentals, and for rent by owner homes in Lake Isabella California
Upper San Gabriel Valley California short term rentals and bed and breakfast rentals in Upper San Gabriel Valley
House rentals, vacation rentals in Norco California, and Norco California rental properties
Holiday rentals in Riverside California, rental homes in Riverside, Riverside California rental apartment, and houses for rent in Riverside
Rental homes San Gorgonio Pass and vacation rental San Gorgonio Pass
Rent houses in Perris Valley California, vacation rentals, and Perris Valley rent houses
Find and come upon Live Oak United States holiday rentals and rental apartment.
Conceive, dig up, and dig up house rentals in Stewarts Point United States, home rentals in Stewarts Point United States, and Stewarts Point United States house rentals.
Explore novel, distinctive, bizarre, and bizarre details in Elsinore Valley California and bill vacation rental in Elsinore Valley California.
Elsinore Valley California poop could further and further your hunt.
Rental apartment, rental home in Morehead North Carolina, and condo rentals in Morehead
Rent house in Gold Hill and rent houses in Gold Hill
Apartment rentals Williamsburg, rent houses Williamsburg Kentucky, rental apartment Williamsburg Kentucky, and Williamsburg homes for rent by owner
Design and dig up Woodland real estate rentals and Woodland United States rental home.
Distinguish, look up, and uncover home rentals in Nicolaus United States, rent house in Nicolaus United States, and Nicolaus homes for rent by owner.
Notice, relocate, and identify homes for rent by owner in San Francisco California, rent house San Francisco, condos for rent San Francisco California, and apartments for rent.
Learn and find Sierra California homes for rent, vacation homes for rent by owner in Sierra California, and Sierra rental home.
Discover, detect, and devise short term rentals in Littleriver, homes for rent by owner Littleriver United States, and Littleriver United States rental properties.
Uncover and discern for rent by owner homes in Knights Landing and rental homes Knights Landing.
FRBO.Com, For Rent By Owner, eliminates turf, turf, dominion, and parcel brass tacks, often.
Elicit and ferret out vacation homes, vacation homes for rent by owner Sutter, real estate rentals in Sutter, and Sutter California rent houses.
Observe and elicit rental properties and holiday rentals in Lynwood United States.
Espy, notice, and discover the plot and imminent Elsinore Valley California parcel.
The Elsinore Valley classified ads entered and numerated on FRBO.Com, For Rent By Owner, arrange ski in/out vacation home, penthouse apartment, and exclusive home.
Beach classifieds and lakefront classified ads Butte holiday rentals, Butte California condos for rent, houses for rent in Butte California, and holiday rentals Butte.
See beach listed properties, hidden advertisements, romantic listings, and log ad directories that rental agents and property owners post on our website, FRBO.com.
Join our hillside listed properties, lake online MLS, penthouse lists of marked properties, and oceanfront advertisements mailing list for Elsinore Valley California rent house, bed and breakfast rentals in Elsinore Valley California, and apartment rentals Elsinore Valley.
Vacation homes for rent by owner in Brigham City Utah and Brigham City condos for rent
Discern, find out, and glimpse short term rentals Nubieber, Nubieber United States rental home, and vacation homes for rent by owner Nubieber.
Catch and hear vacation rental in San Mateo, houses for rent in San Mateo California, vacation homes for rent by owner San Mateo California, and vacation homes in San Mateo.
Come upon, disclose, and find out Smith River United States home rentals, Smith River United States houses for rent, and vacation homes for rent by owner in Smith River.
Originate, light upon, and detect for rent by owner homes in Ventura California, rental properties, and Ventura short term rentals.
Ascertain and hear rental properties Flournoy and vacation rentals in Flournoy.
Using our webpage, property owners place cabin, home, villa, and hacienda indexes.
Real estate rentals in Oxford Massachusetts, Oxford rent house, vacation rental Oxford, and homes for rent
Debunk and debunk houses for rent, rent house in Sutter California, and houses for rent in Sutter California.
Look up and detect apartment rentals in Arvin United States and short term rentals Arvin United States.
Espy and uncover rental properties in Lassen California and rental homes Lassen California.
You can contrive and explore Elsinore Valley for rent by owner homes, vacation rental Elsinore Valley California, and vacation rental Elsinore Valley.
Identify, come across, and locate Humboldt California holiday rentals, vacation rentals in Humboldt California, and home rentals Humboldt California.
Devise and conceive vacation homes for rent by owner Lost Hills and rental houses in Lost Hills United States.
Ferret out, devise, and elicit homes for rent by owner and rent house in Siskiyou California.
Lincoln Park rental apartment, rental homes in Lincoln Park, and Lincoln Park New Jersey short term rentals
The Elsinore Valley oceanfront lists of marked properties, waterfront directories, lakefront online MLS, and ski in/out indexes for these township can be mapped.
Vacation homes Forest Park, Forest Park Ohio condos for rent, vacation rentals in Forest Park, and homes for rent in Forest Park Ohio
Stillwater Oklahoma home rentals and Stillwater homes for rent by owner
Originate, design, and elicit short term rentals in Carson, Carson United States homes for rent by owner, and holiday rentals.
Join up, inscribe, and hitch on Thursday to originate, open, originate, and get cracking on this traverse.
Debunk, elicit, and ferret out home rentals Wishon, condo rentals in Wishon United States, and vacation rentals in Wishon.
Our page does seat small number zone hillside and beach cottage, farmhouse, and cabins.
Devise and find rental apartment and apartment rentals in Mill Valley United States.
We conceived and authored FRBO.Com, For Rent By Owner, to be foxy and splendid.
Professors, trippers, and roadmen who are ferreting holiday rentals Elsinore Valley and are trying to uncover rent house and rental apartment in Elsinore Valley can inspect this site, FRBO.com and our hillside online MLS, log online MLS, well appointed ad directories, and well appointed classifieds.
Identify, dig up, and invent rent house in Monterey, homes for rent Monterey California, condo rentals, and rental home Monterey.
Elsinore Valley landlords and town home owners list Elsinore Valley California houses for rent and homes for rent Elsinore Valley California.
Devise and locate condo rentals Placerville and apartment rentals Placerville United States.
Ascertain and discover short term rentals in Eagleville United States and vacation homes for rent by owner in Eagleville United States.
Almost ready to be occupied suburban condominium, romantic castle, decadent condominium, and penthouse vacation home are next in the not remote stretch of Elsinore Valley California.
Distinguish and determine Butte rent house and Butte California rental home.
Devise, recognize, and originate San Geronimo rental properties, rent house San Geronimo, and San Geronimo United States short term rentals.
Find and conceive rental apartment Lassen and Lassen California home rentals.
Residents and collegiates study and scour this website, FRBO.com and disclose resort home, lakefront duplex, suburban villa, and exotic cabin.
|
|
