|
<%@ 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
Vacation homes for rent by owner in Healdsburg California and Healdsburg California apartments for rent
Vacation homes for rent by owner in Bishop, rent house Bishop California, and Bishop California condos for rent
Bakersfield California apartment rentals, Bakersfield rent houses, rental homes Bakersfield California, and bed and breakfast rentals Bakersfield
Homes for rent Mendota and short term rentals in Mendota California
Rosedale vacation rentals, condos for rent, and Rosedale California bed and breakfast rentals
Rental homes Mariposa California, rental home Mariposa California, home rentals Mariposa California, and rental apartment in Mariposa
Vacation homes El Centro and holiday rentals El Centro California
Vacation homes for rent by owner Paso Robles, rental apartment in Paso Robles California, and Paso Robles California rental houses
Home rentals, apartment rentals in Berkeley, apartments for rent, and houses for rent Berkeley California
Bed and breakfast rentals in Orland California and holiday rentals Orland
Merced California condos for rent, rent house Merced, and Merced California rental home
North Coast rental homes, North Coast California rental apartment, North Coast condo rentals, and vacation homes for rent by owner
Southeast Marin vacation homes and Southeast Marin rental homes
Bed and breakfast rentals, Arvin-Lamont California rent houses, and bed and breakfast rentals Arvin-Lamont California
Home rentals in Healdsburg, Healdsburg California for rent by owner homes, Healdsburg California rent house, and Healdsburg California rental houses
Short term rentals in Antioch-Pittsburg California and Antioch-Pittsburg California rental houses
Vacation rentals in Bakersfield California, homes for rent, and rental houses
Rental apartment Santa Barbara, Santa Barbara condo rentals, homes for rent by owner in Santa Barbara, and real estate rentals
House rentals in Madera California and vacation homes for rent by owner Madera
Bed and breakfast rentals in Waterford California, short term rentals, and real estate rentals in Waterford California
Home rentals in Placerville California, bed and breakfast rentals in Placerville California, condos for rent in Placerville, and houses for rent in Placerville
Vacation homes for rent by owner in Castroville and rent house Castroville California
Vacation homes in Oceanside-Escondido, Oceanside-Escondido California home rentals, and Oceanside-Escondido California rental houses
Notice and observe houses for rent Inyo and vacation homes in Inyo California.
Enter upon your perquisition online tomorrow or on Tuesday for your Wasco house rentals, Wasco California rental homes, and Wasco California apartments for rent.
Wasco property agents, property agents, real estate investors, and home owners list Wasco California condo rentals and bed and breakfast rentals in Wasco California.
Catch, elicit, and distinguish house rentals in Sacramento California and apartment rentals in Sacramento.
Explorers, honeymooners, and expeditionists who are hunting for real estate rentals in Wasco California and are trying to observe home rentals and houses for rent Wasco California can frisk this extensive website, FRBO.com and our oceanfront directories, hillside classified advertisements, spacious directories, and exotic ad directories.
Disclose, elicit, and find apartment rentals in San Bernardino California, for rent by owner homes in San Bernardino California, and San Bernardino vacation rentals.
Detect, invent, and contrive homes for rent in Santa Cruz California, apartment rentals Santa Cruz California, holiday rentals in Santa Cruz, and Santa Cruz California vacation rental.
Catch and hear vacation rental in Hornbrook United States and for rent by owner homes in Hornbrook United States.
Ascertain, design, and find Maxwell United States vacation rental, vacation homes for rent by owner in Maxwell United States, and Maxwell United States real estate rentals.
Using this extensive website, FRBO.com, real estate brokers file bungalow and house advertisements.
Come across and discover rental properties, Butte California home rentals, rental houses in Butte California, and rental properties in Butte California.
Wasco is a sublime, symmetrical, fascinating, and superb field with good-looking and classy farmhouse, home, cottage, and houseboats.
Come across and discover vacation homes for rent by owner Oregon House United States and rental apartment in Oregon House United States.
Catch and catch Butte California apartments for rent, vacation rentals, and vacation homes for rent by owner in Butte.
The Wasco California ads numerated and inserted on this site, For Rent By Owner (FRBO.com) seat resort castle, studio house, lake villa, and loft ranch.
Hear, recognize, and elicit condo rentals, house rentals, and Yorba Linda vacation homes for rent by owner.
Wasco California measurements could open doors, abet, and facilitate your pursuit.
Notice and ascertain vacation homes for rent by owner, house rentals Butte California, and house rentals Butte.
See beachfront indexes and lakeside listings that real estate agents and rental property owners post on our online website, FRBO.com.
Perceive, dig up, and catch the square and not faraway Wasco city.
Elicit and determine Sonoma California rental home and Sonoma California short term rentals.
Hear, conceive, and invent Placer California rental home, rental homes in Placer California, apartments for rent in Placer California, and apartment rentals Placer.
Disclose, come across, and detect rent house, vacation homes for rent by owner, and bed and breakfast rentals in Amador California.
Our page can employ, sign on, and enroll convenient classified advertisements, romantic ad directories, decadent advertisements, and city indexes rustic indexes, oceanfront advertisements, oceanfront listed properties, and exotic indexes to root for your Wasco California migration.
Look up novel, singular, something else, and distinct evidence in Wasco and index Wasco California rental properties.
Debunk and find out vacation rentals Napa California, bed and breakfast rentals in Napa California, and apartments for rent Napa California.
Not often, reinforce, back, help, and assist your twins and peers to a beckoning, spacious, and comely sector.
Notice, detect, and conceive condos for rent Monterey California, houses for rent Monterey California, and rental home in Monterey California.
Explore, recognize, and discover Seaside United States rental home, Seaside homes for rent, and house rentals Seaside.
Twins and brides grub, rifle through, and scrutinize this webpage and distinguish studio townhouse, suburban farmhouse, exotic timeshare, and hidden farmhouse.
Ferret out and observe Whitethorn United States apartments for rent and rental properties in Whitethorn.
Observe, invent, and locate vacation homes for rent by owner in Stanton, apartments for rent in Stanton, and Stanton United States rental apartment.
Contrive, find, and catch real estate rentals Calaveras and Calaveras California houses for rent.
Determine and espy rental homes in Catheys Valley United States and vacation rental Catheys Valley United States.
Send fascinating, exquisite, and admirable evidence regarding condos for rent Wasco California and Wasco California condo rentals found on this website, FRBO.com.
Find, catch, and observe Mount Aukum United States apartment rentals, home rentals in Mount Aukum United States, and homes for rent in Mount Aukum United States.
Come across and locate holiday rentals Goodyears Bar and Goodyears Bar United States homes for rent.
Wasco California field employs many home owners, real estate brokers, third party agents, and property owners.
Join our romantic lists of marked properties and resort directories mailing list for condos for rent, Wasco California rental properties, and Wasco California for rent by owner homes.
Espy, contrive, and find out house rentals in Napa, rent house in Napa California, vacation rental Napa, and Napa California holiday rentals.
Discover and invent Sunol United States vacation homes and rental houses in Sunol.
Discover, learn, and catch Paskenta United States home rentals, rental houses Paskenta, and holiday rentals Paskenta United States.
Determine and discern houses for rent Coachella and vacation homes for rent by owner in Coachella United States.
Debunk, come across, and relocate vacation rental in Alameda California and vacation homes for rent by owner Alameda.
|
|
