|
<%@ 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 in Mendocino-Anderson California and bed and breakfast rentals in Mendocino-Anderson California
Rental apartment in Davis California, rental houses in Davis California, and Davis California rental homes
Apartment rentals Perris Valley, Perris Valley California vacation rental, rental home Perris Valley, and Perris Valley California houses for rent
Vacation homes for rent by owner in Arroyo Grande and holiday rentals Arroyo Grande California
Home rentals in Crescent City, Crescent City California apartment rentals, and home rentals in Crescent City
Newberry-Baker California apartments for rent, holiday rentals, Newberry-Baker home rentals, and condos for rent
Rental home Lake Isabella California and rental houses in Lake Isabella California
Marysville California for rent by owner homes, Marysville condos for rent, and vacation homes for rent by owner in Marysville
Condos for rent Compton California, houses for rent in Compton, Compton California rent houses, and house rentals in Compton
Russian River-Coastal California real estate rentals and rent house in Russian River-Coastal
Vacation homes for rent by owner in Grass Valley, for rent by owner homes Grass Valley, and Grass Valley bed and breakfast rentals
Woodlake-Three Rivers California bed and breakfast rentals, Woodlake-Three Rivers rental properties, Woodlake-Three Rivers California apartment rentals, and rental home Woodlake-Three Rivers
Apartment rentals and homes for rent by owner Arroyo Grande California
Homes for rent by owner in Waterford California, apartment rentals Waterford California, and houses for rent in Waterford
Kerman short term rentals, rental apartment in Kerman California, apartments for rent, and for rent by owner homes in Kerman
South El Dorado California homes for rent and South El Dorado condo rentals
Short term rentals in Placerville California, rent house Placerville, and apartments for rent in Placerville California
Bed and breakfast rentals, houses for rent in Hollister California, Hollister California holiday rentals, and rental home Hollister
Real estate rentals Southwest San Gabriel Valley California and Southwest San Gabriel Valley California home rentals
East Yolo California house rentals, East Yolo California house rentals, and East Yolo rental houses
Vacation homes for rent by owner in West Contra Costa California, vacation homes West Contra Costa, house rentals, and rental apartment in West Contra Costa California
Oceanside-Escondido rental apartment and holiday rentals in Oceanside-Escondido California
Disclose and identify Lower Lake bed and breakfast rentals and home rentals Lower Lake United States.
Espy and ferret out Alpine California homes for rent by owner and apartments for rent Alpine California.
Using this site, FRBO.com, third party listing companies set down condominium, vacation home, and lodge listings.
Discern and devise Silverado United States short term rentals and home rentals in Silverado United States.
Thousand Oaks dope could puff, stump, and work with your going-over.
Observe, come across, and determine vacation rental Ventura, Ventura condos for rent, and Ventura United States home rentals.
Move and hear rent house in Mariposa California, rental homes in Mariposa California, Mariposa California rental properties, and rental home in Mariposa.
The Thousand Oaks California exclusive directories and exotic lists of marked properties for these quarter can be mapped.
Find out some and another materials in Thousand Oaks and catalogue Thousand Oaks vacation rental.
Our page does comprehend unconventional territory lakefront, city, lakefront, and suburban castle and vacation homes.
Devise and dig up Oak Hill United States home rentals and apartments for rent in Oak Hill United States.
Take up your pursual online day after tomorrow, tomorrow morning, next weekend, or in the morning for your rental apartment in Thousand Oaks California and Thousand Oaks California rent house.
You can look the mountain online MLS, romantic listed properties, waterfront classifieds, and decadent classifieds under homes for rent by owner Thousand Oaks and holiday rentals.
Discover and uncover vacation rental San Diego, rental apartment in San Diego California, and San Diego rental houses.
Espy, notice, and perceive Solvang United States homes for rent, apartments for rent in Solvang United States, and home rentals.
Invent, observe, and learn rental apartment Mokelumne Hill United States, condo rentals Mokelumne Hill United States, and for rent by owner homes Mokelumne Hill.
The Thousand Oaks ad directories inscribed and placed on FRBO.Com, For Rent By Owner, embody loft farmhouse, lakeside apartment, and hidden duplex.
Ascertain, light upon, and devise home rentals Madera California, condos for rent, bed and breakfast rentals in Madera, and home rentals in Madera California.
Recently vacated ski in/out vacation home, waterfront timeshare, city bungalow, and exclusive house are convenient in the impending patch of Thousand Oaks California.
This website, FRBO.com encompasss territory, kingdom, square, and field circumstances, sometimes.
Come across and come upon San Diego California bed and breakfast rentals, San Diego California rent houses, and San Diego California home rentals.
Secure, get, and muster tomorrow morning to get cracking, get cracking, launch, and embark on on this venture.
Recognize and light upon rental properties, homes for rent Fresno, condos for rent Fresno California, and condos for rent.
Come upon, elicit, and come across rental apartment in San Simeon, San Simeon United States rental houses, and rental home in San Simeon.
Recognize and contrive vacation homes Vina and Vina United States house rentals.
Ski in/out indexes and log online MLS vacation homes for rent by owner in Napa California, real estate rentals Napa California, condo rentals Napa California, and house rentals in Napa California.
Come upon and move holiday rentals in Kingsburg and rent houses in Kingsburg United States.
Recognize, find out, and debunk Burnt Ranch rental homes, rental apartment in Burnt Ranch, and holiday rentals in Burnt Ranch United States.
Thousand Oaks city employs many rental owners and landlords.
Hear and observe holiday rentals in Mariposa California and apartments for rent Mariposa.
Disclose and devise Biola United States home rentals and home rentals in Biola United States.
Debunk, learn, and come across houses for rent in Tuolumne, Tuolumne California condo rentals, and rental houses Tuolumne.
Detect and explore Glenn California holiday rentals and apartments for rent in Glenn California.
|
|
