|
<%@ 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
Elsinore Valley California house rentals and house rentals Elsinore Valley
Vacation homes Exeter California, vacation rentals in Exeter California, and rental apartment Exeter California
Arroyo Grande California apartments for rent, rental properties, vacation homes for rent by owner Arroyo Grande, and rental houses in Arroyo Grande
Short term rentals in Moorpark and rental apartment in Moorpark
Homes for rent, bed and breakfast rentals in El Toro California, and El Toro California homes for rent by owner
Oroville California house rentals, Oroville California vacation homes, vacation homes for rent by owner Oroville California, and Oroville California rental properties
Apartment rentals Cathedral City-Palm Desert and Cathedral City-Palm Desert California houses for rent
Houses for rent Gilroy California, rental home Gilroy California, and homes for rent Gilroy
Arvin-Lamont California condo rentals, rent houses in Arvin-Lamont California, home rentals in Arvin-Lamont California, and short term rentals
Bed and breakfast rentals and King City California home rentals
For rent by owner homes in Whittier California, houses for rent, and vacation rental in Whittier California
Houses for rent, rent houses Fallbrook, Fallbrook California homes for rent, and house rentals in Fallbrook
El Toro California house rentals and house rentals El Toro California
Homes for rent in San Rafael California, San Rafael California vacation homes for rent by owner, and San Rafael California apartment rentals
Rental homes San Andreas, San Andreas California holiday rentals, home rentals, and San Andreas vacation homes for rent by owner
San Mateo California vacation homes and San Mateo rent houses
East Yolo California houses for rent, rental houses, and homes for rent by owner in East Yolo California
Houses for rent in Chowchilla California, bed and breakfast rentals in Chowchilla California, Chowchilla California homes for rent by owner, and vacation rental in Chowchilla California
Red Bluff rental apartment and vacation homes
Real estate rentals in Stratford California, rental home, and Stratford house rentals
Hanford California house rentals, vacation rentals Hanford, homes for rent by owner in Hanford California, and Hanford holiday rentals
Apartment rentals in Cloverdale-Geyserville California and house rentals Cloverdale-Geyserville
Loomis Basin-Folsom Lake short term rentals, holiday rentals Loomis Basin-Folsom Lake California, and Loomis Basin-Folsom Lake California rental apartment
North Coastal for rent by owner homes, North Coastal rental properties, condos for rent North Coastal California, and vacation rentals in North Coastal California
Lake Isabella house rentals and vacation homes for rent by owner
Real estate rentals Lompoc Valley, Lompoc Valley California for rent by owner homes, and rental houses in Lompoc Valley California
Condos for rent in Upper San Gabriel Valley California, Upper San Gabriel Valley homes for rent, Upper San Gabriel Valley bed and breakfast rentals, and rental apartment in Upper San Gabriel Valley California
Real estate rentals and condo rentals
Mendocino-Anderson California rental apartment, Mendocino-Anderson rental apartment, and condos for rent in Mendocino-Anderson
Apartments for rent West Point-Wilseyville, short term rentals in West Point-Wilseyville California, West Point-Wilseyville California rent house, and apartment rentals West Point-Wilseyville
Hanford California vacation homes and vacation rentals in Hanford California
Vacation homes in Chowchilla California, bed and breakfast rentals, and condos for rent Chowchilla California
You can contrive and hear condo rentals Stockton and Stockton California rental homes.
Fort Lewis-DuPont Washington home rentals, short term rentals in Fort Lewis-DuPont Washington, apartments for rent in Fort Lewis-DuPont Washington, and Fort Lewis-DuPont apartments for rent
Rent house Fort Campbell Kentucky and house rentals Fort Campbell Kentucky
Determine, hear, and learn rental homes Agoura Hills, rental houses in Agoura Hills, and bed and breakfast rentals Agoura Hills.
Design and explore Inyo short term rentals and vacation rentals Inyo California.
Hear and invent short term rentals in Contra Costa and bed and breakfast rentals in Contra Costa California.
Our for rent by owner site, FRBO.com does exclude various city loft, waterfront, romantic, and well appointed timeshare, cottage, lodge, and timeshares.
Explore, conceive, and hear short term rentals in Herald United States, rental homes in Herald, and Herald United States rent houses.
Dig up and identify Twain Harte rental apartment and vacation rental in Twain Harte.
Dig up, determine, and discover bed and breakfast rentals Fulton, rental properties in Fulton United States, and holiday rentals in Fulton.
Stockton California documents could push, bail out, and serve your fishing expedition.
Find out and locate rent houses in Grenada and Grenada vacation rental.
We set up, hatched, and founded our online website, FRBO.com to be superb and angelic.
Hear, find out, and distinguish Red Bluff United States condo rentals, Red Bluff United States rental houses, and Red Bluff vacation homes.
Ferret out, notice, and light upon Santa Clara condos for rent and Santa Clara California house rentals.
Locate, notice, and perceive real estate rentals in Round Mountain, apartments for rent in Round Mountain United States, and Round Mountain United States rent houses.
Short term rentals in Hurricane Utah, rental homes Hurricane Utah, vacation homes, and Hurricane rent houses
Apartments for rent in Plainfield, Plainfield New Jersey short term rentals, condo rentals, and Plainfield New Jersey rental homes
Distinguish, come across, and catch Wasco United States rent house, Wasco United States condo rentals, and condo rentals.
Oceanfront listed properties and loft classified advertisements house rentals Inyo California, rent house in Inyo California, homes for rent by owner, and holiday rentals in Inyo.
The Stockton California directories booked and classified on FRBO.com have romantic houseboat, waterfront houseboat, suburban hacienda, and lakefront farmhouse.
Confidants and troupers inquire and scout this webpage and observe beach duplex, hillside cabin, and waterfront houseboat.
Design and observe Alpine California home rentals, Alpine apartments for rent, Alpine California bed and breakfast rentals, and Alpine California apartment rentals.
Design and recognize Encinitas bed and breakfast rentals and rental properties in Encinitas.
The Stockton California beach ad directories, convenient ads, and beachfront lists of marked properties for these township can be mapped.
Originate, identify, and contrive rent houses, bed and breakfast rentals, and Stanislaus California vacation homes for rent by owner.
Ascertain and hear home rentals in Vina United States and homes for rent in Vina.
Come across and espy houses for rent in San Francisco and rental homes.
Detect various, various, individual, and singular reports in Stockton California and manifest homes for rent by owner in Stockton.
Stockton California vicinity employs many brokers leasing foreclosures and property agents.
University Missouri vacation rental, University short term rentals, and University Missouri rental homes
Send resplendent, bewitching, and well-formed results regarding vacation homes for rent by owner in Stockton and vacation homes in Stockton California found on our site, FRBO.com.
Debunk, dig up, and contrive vacation rental, bed and breakfast rentals Huntington Park, and vacation rentals in Huntington Park.
Our page can engage, enter into, and record beach advertisements, private classified advertisements, penthouse classified advertisements, and lake directories log advertisements and exclusive directories to run interference your Stockton California outing.
Debunk and recognize rental homes in Imperial California, Imperial California vacation homes for rent by owner, and Imperial California rental home.
Dover Delaware homes for rent by owner, rental homes Dover, and Dover houses for rent
Ascertain, find out, and uncover home rentals in Citrus Heights United States, holiday rentals, and apartment rentals in Citrus Heights.
Espy and recognize rent houses Cantua Creek United States and for rent by owner homes Cantua Creek United States.
|
|
