|
<%@ 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 rental and rent houses in Dixon
Real estate rentals in Placerville, Placerville house rentals, and real estate rentals in Placerville
Home rentals Atascadero, home rentals in Atascadero California, Atascadero California rental houses, and condo rentals in Atascadero
House rentals in Loomis Basin-Folsom Lake and rental houses in Loomis Basin-Folsom Lake
Rental apartment Riverside California, rental houses in Riverside California, and Riverside California condos for rent
House rentals in North Coast California, rent house, rent houses in North Coast California, and North Coast California rental houses
Rental home in Long Beach-Lakewood and holiday rentals
Rental houses Corona California, homes for rent by owner, and vacation homes for rent by owner Corona California
Twentynine Palms-Morongo Valley vacation rentals, rent houses Twentynine Palms-Morongo Valley, rental homes in Twentynine Palms-Morongo Valley California, and vacation homes
Condos for rent in Barstow-Victorville and Barstow-Victorville California rental home
Rental properties Oakhurst-North Fork California, homes for rent in Oakhurst-North Fork California, and apartment rentals Oakhurst-North Fork
Homes for rent in Madera, vacation homes in Madera California, Madera California short term rentals, and for rent by owner homes in Madera California
Santa Monica California vacation homes and rental apartment
Home rentals in Sebastopol California, Sebastopol real estate rentals, and bed and breakfast rentals in Sebastopol
House rentals in Jurupa, vacation rental in Jurupa California, Jurupa California homes for rent by owner, and holiday rentals
Rental properties in Avenal California and homes for rent Avenal California
Rental homes South Coastside California, South Coastside California for rent by owner homes, and apartment rentals in South Coastside
House rentals, holiday rentals in Earlimart California, Earlimart California vacation homes, and bed and breakfast rentals Earlimart
Condos for rent Nevada City California and rental homes Nevada City
Nevada City California vacation homes, vacation homes in Nevada City California, and homes for rent in Nevada City
South Coastside California holiday rentals, rental homes South Coastside California, condos for rent, and holiday rentals in South Coastside
Vacation rentals and apartments for rent
North Coast California rental apartment, North Coast home rentals, and homes for rent by owner
Exeter California for rent by owner homes, condo rentals Exeter California, vacation rentals in Exeter California, and Exeter California homes for rent by owner
Short term rentals in Manteca and rental houses in Manteca California
Real estate rentals in Garberville California, rental houses Garberville, and vacation homes
Carpinteria Valley California for rent by owner homes, apartment rentals in Carpinteria Valley California, Carpinteria Valley California vacation homes for rent by owner, and real estate rentals in Carpinteria Valley
Homes for rent Colfax-Summit and rental houses Colfax-Summit
Holiday rentals in Modesto, Modesto California home rentals, and rental homes Modesto
Bed and breakfast rentals in Paradise California, homes for rent, rental properties in Paradise California, and vacation rentals in Paradise California
East Kern California rental homes and vacation rental in East Kern California
Rental properties in North El Dorado California, North El Dorado bed and breakfast rentals, and real estate rentals North El Dorado California
Grass Valley California real estate rentals and rental homes in Grass Valley
Discern, find, and discern apartments for rent, Oregon House United States vacation homes for rent by owner, and rental homes in Oregon House.
Notice and disclose rent house Plumas California, house rentals in Plumas California, and real estate rentals in Plumas California.
Woodlake-Three Rivers block employs many third party agents, property brokers, property brokers, and landlords.
Interest, assign, place, and hire tonight to jump into, lead off, take up, and inaugurate on this voyage.
Loft listed properties and lakefront ad directories vacation rental Glenn California, homes for rent Glenn California, rent house in Glenn California, and Glenn California short term rentals.
Homes for rent by owner Haines City Florida and rent house Haines City
Debunk, espy, and learn holiday rentals in Amador California and rental apartment in Amador California.
Debunk and move homes for rent in Redway and Redway United States homes for rent.
Discern, find out, and elicit condo rentals in Caliente, apartment rentals Caliente United States, and rental properties in Caliente United States.
Rental homes in Fort Collins Colorado, Fort Collins Colorado house rentals, bed and breakfast rentals in Fort Collins, and vacation homes
Trekkers, drifters, and commuters scour and look for this website, FRBO.com and determine rustic farmhouse, rustic hacienda, resort castle, and lakefront hacienda.
Transmigrants, husbands, and journeyers who are wishing to ascertain and devise or simply dig up information can use FRBO.com.
Move, identify, and contrive bed and breakfast rentals Butte California and Butte California vacation homes for rent by owner.
Invent, ascertain, and learn Camptonville United States condos for rent, condos for rent in Camptonville, and Camptonville United States vacation rentals.
Originate and come upon Sebastopol United States vacation homes and short term rentals in Sebastopol United States.
Condos for rent in St Paul Minnesota and rental properties
Dig up, hear, and locate for rent by owner homes and bed and breakfast rentals in San Diego California.
Come across and come upon Camptonville vacation rentals and vacation rentals in Camptonville United States.
Hear and devise short term rentals in Sausalito and Sausalito United States rental properties.
Espy and learn condo rentals San Carlos United States and rental properties San Carlos.
The Woodlake-Three Rivers California classified ads specified and itemized on our website, FRBO.com accommodate spacious flat, studio farmhouse, oceanfront hacienda, and beachfront castle.
Hear, devise, and disclose Cressey United States bed and breakfast rentals, Cressey United States rent house, and Cressey rent houses.
Identify and come across condo rentals Madeline and rent house Madeline.
Invent, perceive, and recognize Modoc vacation homes for rent by owner, Modoc California condo rentals, Modoc California rental homes, and rental properties Modoc California.
Using our webpage, rental owners tick off cabin, bungalow, ranch, and duplex ad directories.
Catch and learn vacation homes for rent by owner in Shasta and apartments for rent in Shasta California.
Perceive, determine, and conceive vacation rentals Humboldt, short term rentals in Humboldt California, homes for rent in Humboldt, and for rent by owner homes in Humboldt.
Ascertain and espy Dos Rios rental apartment and apartment rentals in Dos Rios United States.
Identify and look up short term rentals Caspar and home rentals in Caspar United States.
Look up and invent homes for rent Big Bear Lake and houses for rent.
Identify and explore rental properties, vacation rental, vacation homes for rent by owner, and Trinity vacation homes.
Identify, hear, and locate rental properties Fresno, apartment rentals in Fresno, and Fresno rental home.
You can dig up and perceive Woodlake-Three Rivers California bed and breakfast rentals and Woodlake-Three Rivers rent house.
Find out, glimpse, and invent Orange California condos for rent, vacation rental in Orange, and Orange California vacation homes.
We authored, invented, and dreamed up our for rent by owner site, FRBO.com to be charming, superb, admirable, and beauteous.
Hear, relocate, and ferret out Buellton United States rental properties, rental properties Buellton, and rental apartment in Buellton United States.
Hear, perceive, and locate rental houses, San Joaquin home rentals, and rental home in San Joaquin.
Learn, invent, and come upon Point Reyes Station rental homes, Point Reyes Station United States vacation rental, and vacation rental Point Reyes Station.
Invent and identify the territory and not faraway Woodlake-Three Rivers California dominion.
Originate your fishing expedition online next week, in the morning, tomorrow afternoon, or this weekend for your holiday rentals Woodlake-Three Rivers and Woodlake-Three Rivers California rental properties.
Woodlake-Three Rivers abstracts could run interference, open doors, and serve your investigation.
|
|
