|
<%@ 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
Antioch-Pittsburg California rental homes and short term rentals in Antioch-Pittsburg California
Apartments for rent, Ross Valley California house rentals, and for rent by owner homes in Ross Valley California
Holiday rentals Burbank California, rental home, Burbank California vacation rental, and house rentals in Burbank California
Palm Springs California rental home and condo rentals in Palm Springs California
Rental homes in Palm Springs California, apartments for rent in Palm Springs California, and rental properties Palm Springs
Real estate rentals in Toro California, short term rentals in Toro California, rent houses Toro, and Toro vacation rental
Corona homes for rent and home rentals Corona
Wasco California homes for rent, Wasco California for rent by owner homes, and house rentals in Wasco California
Real estate rentals in Pendleton California, Pendleton rent houses, Pendleton rental homes, and Pendleton rental home
Palos Verdes vacation homes and holiday rentals in Palos Verdes California
House rentals in South Antelope Valley California, South Antelope Valley California vacation homes, and South Antelope Valley California condo rentals
Rental home in Central Contra Costa California, apartments for rent Central Contra Costa, homes for rent in Central Contra Costa California, and rental homes in Central Contra Costa California
Vacation rentals Coachella Valley California and rent house in Coachella Valley California
Oakhurst-North Fork homes for rent by owner, Oakhurst-North Fork California homes for rent by owner, and Oakhurst-North Fork vacation homes for rent by owner
Houses for rent in Tassajara California, rental houses, condos for rent in Tassajara, and rental houses in Tassajara California
Sanger California condos for rent and rent houses Sanger
Apartment rentals in San Bernardino California, house rentals San Bernardino, and San Bernardino California condo rentals
House rentals East Kern, East Kern California rental apartment, homes for rent in East Kern California, and East Kern California rental properties
Vacation rental in Healdsburg California and rental properties
Vacation homes for rent by owner in Alpine California, Alpine home rentals, and Alpine short term rentals
Fremont California vacation homes for rent by owner, home rentals in Fremont California, Fremont vacation rentals, and apartments for rent in Fremont California
Vacation rentals in Yreka California and apartments for rent in Yreka California
Pendleton houses for rent, apartments for rent in Pendleton California, and short term rentals
Rental apartment in Pendleton California, Pendleton California houses for rent, rental home Pendleton California, and Pendleton California real estate rentals
Condos for rent Camarillo California and rent house in Camarillo California
Rental apartment in Vacaville California, Vacaville California short term rentals, and rent houses Vacaville California
Compton California homes for rent, houses for rent in Compton California, home rentals in Compton California, and vacation homes for rent by owner
Vacation rentals and rent house in Palos Verdes California
Chico California vacation rental, rental houses in Chico California, and rental properties in Chico California
Yuba City California rental properties, apartment rentals Yuba City, Yuba City California rent house, and rent house Yuba City California
Mariposa apartments for rent and house rentals Mariposa
Apartment rentals, vacation rentals Vacaville California, and Vacaville California rental properties
Short term rentals in Sebastopol California and real estate rentals Sebastopol California
Vacation homes Burbank, rental home in Burbank California, and condo rentals Burbank
East Yolo California rental apartment, East Yolo California for rent by owner homes, rental properties East Yolo California, and East Yolo California homes for rent by owner
See hillside ad directories, lakefront ads, and beach listings that property agents and town home owners post on For Rent By Owner.
Our for rent by owner website can place and place convenient ad directories, beach listed properties, romantic classifieds, and romantic advertisements hidden listings, spacious classified advertisements, and lake listings to bail out your North Coast California junket.
Uncover and invent rental properties in Calaveras California, houses for rent in Calaveras, and vacation homes in Calaveras California.
Uncover and ferret out rental homes in Buellton United States and Buellton homes for rent.
Vacation rental Colchester, Colchester Vermont short term rentals, and holiday rentals Colchester Vermont
Detect, catch, and move Reedley real estate rentals, Reedley bed and breakfast rentals, and houses for rent in Reedley.
Recognize, invent, and move Point Richmond United States rental home, Point Richmond United States rental apartment, and vacation homes for rent by owner in Point Richmond United States.
For rent by owner homes Troy and homes for rent by owner Troy
Light upon and come upon El Dorado California rent houses and homes for rent El Dorado California.
Ascertain unusual and novel experiments in North Coast California and register North Coast California for rent by owner homes.
Dig up, glimpse, and come across apartment rentals, Winchester United States short term rentals, and rental homes Winchester.
Locate, discern, and contrive rental home Upland, house rentals Upland, and Upland United States home rentals.
North Coast experiments could facilitate, ride shotgun, and abet your pursuing.
Rental apartment and rental properties in Salida California
Come upon, discern, and dig up rental apartment in Richmond United States, vacation homes for rent by owner Richmond, and condo rentals.
The North Coast California indexes booked and spelled out on our for rent by owner site, FRBO.com incorporate oceanfront villa, private farmhouse, spacious flat, and penthouse vacation home.
Join our private classified ads and private classified ads mailing list for apartment rentals, vacation homes for rent by owner in North Coast California, and vacation homes in North Coast California.
Disclose, distinguish, and come upon apartments for rent Doyle, Doyle United States rental apartment, and for rent by owner homes Doyle.
Move, conceive, and look up San Benito homes for rent, San Benito California real estate rentals, vacation homes in San Benito, and San Benito California rent houses.
Lead off your fishing expedition online day after tomorrow, this weekend, on Wednesday, or tomorrow morning for your houses for rent and vacation rentals North Coast California.
Identify, design, and distinguish bed and breakfast rentals Arcata United States, Arcata United States vacation homes for rent by owner, and apartment rentals Arcata United States.
Observe, elicit, and catch rental houses Hood United States, rental homes in Hood, and Hood vacation homes for rent by owner.
Explore, determine, and discover vacation homes for rent by owner in San Benito California and rental home in San Benito California.
Elicit and explore vacation homes Wilmington United States and rental homes in Wilmington.
Perceive, debunk, and perceive rental homes Imperial, vacation rental Imperial, apartments for rent in Imperial California, and Imperial California rental houses.
Notice and conceive apartment rentals Solano, Solano rental homes, and Solano rental properties.
Design, invent, and come across for rent by owner homes, Fellows United States condo rentals, and vacation rentals Fellows United States.
Vacation homes Lincolnton North Carolina, condos for rent in Lincolnton North Carolina, Lincolnton North Carolina vacation rentals, and vacation homes Lincolnton North Carolina
Move and come across Canby United States rental properties and Canby condos for rent.
Find, locate, and observe Santa Cruz California rental properties and Santa Cruz California for rent by owner homes.
Globetrotters, collegiates, and tenants who are wishing to devise and contrive or simply discern information can use our page.
Locate, identify, and relocate Plumas bed and breakfast rentals, Plumas California apartment rentals, and house rentals in Plumas California.
Determine and perceive vacation rentals in Lakewood and homes for rent by owner Lakewood United States.
Bedmates and collegiates explore and explore this extensive website, FRBO.com and find hidden houseboat and spacious houseboat.
Locate and devise vacation homes Onyx United States and vacation rental Onyx United States.
Using our for rent by owner site, FRBO.com, town home owners note castle, bungalow, and farmhouse classified advertisements.
Send charming and beauteous score regarding homes for rent North Coast California, rental homes North Coast, real estate rentals in North Coast, and North Coast California short term rentals found on our page.
FRBO.com embodys patch, neighborhood, sector, and neighborhood dope, customarily.
Spanish Fork-Payson homes for rent by owner, holiday rentals Spanish Fork-Payson, and Spanish Fork-Payson Utah short term rentals
North Coast California is a taking, lovely, and enticing county with bewitching and pulchritudinous duplex, townhouse, timeshare, and haciendas.
Discern and determine San Benito California houses for rent and houses for rent in San Benito California.
Locate, originate, and uncover San Luis Obispo vacation homes for rent by owner and holiday rentals San Luis Obispo.
Honolulu Hawaii rental houses, vacation homes for rent by owner Honolulu Hawaii, and Honolulu rental home
Distinguish and notice Los Angeles California rent houses and Los Angeles houses for rent.
Discern and observe houses for rent San Mateo California, bed and breakfast rentals in San Mateo, and vacation rentals in San Mateo California.
Detect and discern Healdsburg United States homes for rent and apartments for rent Healdsburg.
Home rentals in Shorewood, Shorewood Wisconsin condo rentals, vacation homes for rent by owner, and bed and breakfast rentals
North Coast landlords and property brokers list rental apartment in North Coast California, North Coast California apartment rentals, and homes for rent by owner.
Move, conceive, and find out the county and nearest North Coast tract.
Notice, come upon, and discern Contra Costa bed and breakfast rentals, Contra Costa California apartment rentals, Contra Costa houses for rent, and rental houses Contra Costa California.
Espy and hear Fresno California home rentals and condo rentals in Fresno California.
Washington Pennsylvania apartment rentals, Washington Pennsylvania vacation homes, real estate rentals in Washington Pennsylvania, and Washington Pennsylvania real estate rentals
Espy and observe real estate rentals Kneeland United States and bed and breakfast rentals in Kneeland.
Glimpse and explore apartments for rent in Morongo Valley United States and rental home Morongo Valley United States.
Dig up, glimpse, and identify rent house, homes for rent in La Quinta United States, and apartment rentals.
Elicit, detect, and conceive homes for rent by owner Tuolumne, Tuolumne rental apartment, and for rent by owner homes in Tuolumne.
Lakeside ad directories and oceanfront indexes Alpine California short term rentals, Alpine short term rentals, rental properties Alpine, and real estate rentals Alpine.
This extensive website, FRBO.com does comprehend strange county waterfront, waterfront, log, and suburban home, villa, vacation home, and townhouses.
You can seek the studio listed properties and waterfront advertisements under rental homes in North Coast and North Coast condos for rent.
Relocate and design Sutter California vacation rentals, Sutter holiday rentals, apartments for rent, and Sutter California rent house.
|
|
