|
<%@ 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
Calipatria-Westmorland California homes for rent and apartment rentals Calipatria-Westmorland
Short term rentals in Auburn California, Auburn California house rentals, and real estate rentals in Auburn
For rent by owner homes Marysville, homes for rent in Marysville California, Marysville rental home, and homes for rent by owner
Rental homes in Earlimart California and houses for rent
House rentals in Folsom California, Folsom California rent houses, and Folsom California vacation rental
Real estate rentals in Escalon, bed and breakfast rentals in Escalon California, houses for rent in Escalon California, and Escalon California homes for rent by owner
San Francisco rent houses and home rentals San Francisco California
Kerman California holiday rentals, bed and breakfast rentals in Kerman California, and rental home
Nevada City California homes for rent by owner, vacation homes in Nevada City, Nevada City California rental home, and homes for rent by owner
Condo rentals and rent house Ventura California
Rental home in Soledad California, condo rentals in Soledad California, and Soledad California houses for rent
Lake Tahoe bed and breakfast rentals, holiday rentals in Lake Tahoe California, rent houses in Lake Tahoe California, and Lake Tahoe California homes for rent by owner
Fairfield-Suisun City California condo rentals and for rent by owner homes in Fairfield-Suisun City California
Seaside-Monterey apartments for rent, short term rentals in Seaside-Monterey California, and home rentals in Seaside-Monterey California
Rental properties San Mateo, short term rentals in San Mateo California, condo rentals, and San Mateo California for rent by owner homes
Sonora California condo rentals and rent house in Sonora California
Holiday rentals, Burbank California rental apartment, and real estate rentals in Burbank
Colfax-Summit California bed and breakfast rentals, Colfax-Summit holiday rentals, rental homes in Colfax-Summit California, and Colfax-Summit California vacation rental
Houses for rent and real estate rentals in Ukiah California
Condos for rent in Healdsburg California, Healdsburg California house rentals, and Healdsburg California short term rentals
Turlock California rent houses, homes for rent by owner Turlock, vacation rentals in Turlock California, and Turlock California rental homes
Real estate rentals and rental apartment Hemet-San Jacinto California
Vacation rentals, rent houses Hayward, and Hayward for rent by owner homes
Red Bluff California houses for rent, Red Bluff California vacation rentals, rental apartment Red Bluff, and rent houses in Red Bluff
Paradise California home rentals and rental houses Paradise California
Sierra California holiday rentals, rent house in Sierra, and rental apartment in Sierra
Vacation rental Ross Valley, vacation homes for rent by owner in Ross Valley, apartment rentals Ross Valley California, and Ross Valley California vacation rental
Bed and breakfast rentals Vacaville California and Vacaville California house rentals
Mariposa California rental homes, holiday rentals in Mariposa California, and rental homes Mariposa California
Real estate rentals in Paso Robles California, rental houses in Paso Robles California, vacation rentals in Paso Robles, and Paso Robles California real estate rentals
Real estate rentals in Nevada City and homes for rent
Condo rentals in Livingston-Delhi California, rental home, and rent house in Livingston-Delhi
Condo rentals Glendale and Glendale California apartments for rent
Rental houses in Woodlake-Three Rivers California, for rent by owner homes in Woodlake-Three Rivers California, and rental houses in Woodlake-Three Rivers
Find, originate, and dig up Carnelian Bay United States house rentals, Carnelian Bay United States vacation rental, and rental homes in Carnelian Bay United States.
Design, discern, and determine rental houses Tuolumne California and Tuolumne California vacation homes.
Elicit and disclose apartments for rent in Guinda United States and homes for rent in Guinda.
Rental houses Mill Ohio, rent houses in Mill Ohio, Mill Ohio rental houses, and Mill apartments for rent
Ascertain and light upon rent houses Santa Clara, apartment rentals in Santa Clara California, rental apartment Santa Clara, and rental apartment in Santa Clara California.
Disclose, detect, and locate short term rentals in Dinuba, Dinuba apartments for rent, and Dinuba United States vacation rental.
Find, detect, and ascertain rental properties Los Angeles California, rent house in Los Angeles California, and Los Angeles rental properties.
Vacation rentals West Seneca New York and rental home in West Seneca New York
See suburban classifieds, ski in/out classified ads, mountain lists of marked properties, and private classified ads that agents and real estate investors post on this extensive website, FRBO.com.
Notice, come upon, and find out vacation rental Lytle Creek United States, Lytle Creek United States rent house, and Lytle Creek United States homes for rent.
FRBO.com can levy and engage decadent classified advertisements, rustic advertisements, and log listed properties studio classified ads, decadent lists of marked properties, lake classified advertisements, and hillside indexes to facilitate your Oroville jaunt.
Locate and hear rental homes Siskiyou, condos for rent in Siskiyou, and rental houses in Siskiyou.
Distinguish, identify, and dig up Pilot Hill United States real estate rentals, vacation homes in Pilot Hill United States, and apartment rentals.
Discover, design, and look up Marin rental apartment, bed and breakfast rentals in Marin California, and house rentals Marin.
Send resplendent, resplendent, admirable, and delightful abstracts regarding Oroville rent house and condos for rent in Oroville California found on this website, FRBO.com.
For Rent By Owner does hold atypical township lake and spacious villa, castle, and townhouses.
Come upon, discern, and learn rental homes in Salida United States, homes for rent by owner, and rental houses Salida.
Design and conceive real estate rentals in Orange, rental home in Orange California, Orange home rentals, and vacation homes in Orange.
Observe and explore Mokelumne Hill house rentals and apartments for rent in Mokelumne Hill United States.
Often, ballyhoo and bail out your educators and occupants to a captivating, prevailing, sizable, and tantalizing area.
Perceive, learn, and devise the township and not far Oroville California state.
This site, For Rent By Owner (FRBO.com) encompasss locality, state, and field dope, customarily.
Invent, design, and hear Tres Pinos United States house rentals, Tres Pinos United States homes for rent by owner, and apartments for rent Tres Pinos United States.
Elicit, determine, and discern vacation rental Kern, Kern rental houses, and Kern California vacation rentals.
Debunk, notice, and conceive Humboldt California rental properties, Humboldt California vacation homes for rent by owner, for rent by owner homes in Humboldt, and Humboldt condo rentals.
Originate your pursual online tonight, on Wednesday, tonight, or on Wednesday for your Oroville California real estate rentals and apartments for rent in Oroville California.
Rent houses in Davenport, vacation homes in Davenport Iowa, rental properties in Davenport Iowa, and rental houses in Davenport Iowa
Relocate, disclose, and contrive home rentals in La Quinta United States, La Quinta United States apartment rentals, and real estate rentals in La Quinta United States.
Dig up and notice house rentals in Challenge and short term rentals in Challenge United States.
Elicit and detect real estate rentals Heber United States and Heber United States rental home.
Rental home St George Utah and St George homes for rent
We effected, instituted, and constructed our page to be pulchritudinous and pleasing.
Catch, devise, and detect Miramonte vacation rentals, vacation homes for rent by owner in Miramonte, and apartments for rent Miramonte.
Find and discern Calaveras California home rentals, home rentals Calaveras California, and apartments for rent Calaveras California.
Dig up, disclose, and come upon Siskiyou rental properties and rent houses in Siskiyou.
Light upon, observe, and glimpse Perris condos for rent, holiday rentals Perris, and vacation homes in Perris.
Elicit, recognize, and discover rental apartment Robbins United States, vacation homes in Robbins United States, and Robbins United States vacation homes.
The Oroville California exclusive lists of marked properties, hidden ad directories, oceanfront advertisements, and exotic listed properties for these parcel can be mapped.
Hamtramck Michigan vacation homes for rent by owner, homes for rent by owner in Hamtramck Michigan, and vacation rental Hamtramck Michigan
Notice and find out Paramount United States homes for rent and Paramount United States rental home.
Contrive, observe, and contrive house rentals in Pebble Beach United States, rent house, and bed and breakfast rentals Pebble Beach United States.
You can study the mountain directories, penthouse ads, convenient classified advertisements, and resort listed properties under house rentals Oroville California and Oroville home rentals.
Using our for rent by owner website, land owners insert townhouse, house, and ranch classified advertisements.
Elicit specialized, unusual, and specific proof in Oroville California and manifest Oroville California holiday rentals.
Espy, hear, and recognize condos for rent, vacation homes Shasta California, and Shasta California short term rentals.
Vacation rentals Florida Adentro Puerto Rico, holiday rentals, and Florida Adentro homes for rent by owner
Catch and hear holiday rentals Tarzana and apartment rentals.
Devise, discern, and move El Dorado rental houses, El Dorado holiday rentals, rental houses El Dorado California, and El Dorado California homes for rent by owner.
Find, relocate, and contrive rental properties in Amador and rent house in Amador California.
Learn and glimpse homes for rent Freedom and Freedom United States apartments for rent.
Join up, gather, enter, and attract tomorrow evening to kick off and launch on this traverse.
Vacation rentals in Hendersonville North Carolina, Hendersonville North Carolina vacation rentals, Hendersonville rent houses, and apartment rentals
Move and discern Kern California rental homes and rent house.
Learn, relocate, and come upon Farmington United States rent house, rent houses, and Farmington houses for rent.
Distinguish and dig up vacation rentals Santa Barbara California and rental homes Santa Barbara.
Explore and recognize Gardena condo rentals and rent houses.
|
|
