|
<%@ 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 vacation homes for rent by owner and houses for rent in Elsinore Valley California
For rent by owner homes in Exeter, holiday rentals in Exeter California, and Exeter apartments for rent
Ontario California for rent by owner homes, home rentals in Ontario California, homes for rent, and Ontario California homes for rent by owner
San Rafael California holiday rentals and San Rafael California vacation homes for rent by owner
Apartments for rent in Cloverdale-Geyserville, Cloverdale-Geyserville California houses for rent, and homes for rent by owner
Livingston-Delhi house rentals, rental properties, Livingston-Delhi California home rentals, and Livingston-Delhi California for rent by owner homes
Houses for rent in Coalinga and Coalinga California short term rentals
Rent houses in Calabasas California, Calabasas for rent by owner homes, and vacation homes for rent by owner in Calabasas California
Calexico California apartment rentals, apartment rentals in Calexico, houses for rent, and Calexico California rent house
Cathedral City-Palm Desert California rental properties and rental houses Cathedral City-Palm Desert
Real estate rentals Escalon, rent house, and for rent by owner homes in Escalon California
Home rentals, rent house Los Banos, house rentals in Los Banos California, and real estate rentals in Los Banos
Rent houses Lake Isabella California and Lake Isabella California for rent by owner homes
Catch and dig up Colusa California homes for rent by owner, Colusa rent house, rental home Colusa, and for rent by owner homes Colusa.
Learn, design, and light upon Edwards holiday rentals, home rentals Edwards, and Edwards real estate rentals.
Contrive and observe rental home in Riverside, rental properties in Riverside California, and condo rentals Riverside.
FRBO.com can procure and engage convenient classified ads, hillside listings, hidden classifieds, and city classifieds loft ads and penthouse lists of marked properties to facilitate your Barstow-Victorville California exploration.
Move, disclose, and identify house rentals in Westlake Village United States, for rent by owner homes in Westlake Village United States, and Westlake Village United States real estate rentals.
Our page seats territory and plot proof, recurrently.
Ferret out and explore bed and breakfast rentals Burson United States and apartments for rent Burson.
Espy, light upon, and ferret out the principality and abutting Barstow-Victorville California sector.
You can check the beachfront listed properties, lakeside ad directories, spacious classified advertisements, and well appointed lists of marked properties under bed and breakfast rentals in Barstow-Victorville California, rental homes in Barstow-Victorville California, and Barstow-Victorville California rental home.
Observe and identify Nicolaus United States vacation homes and rental houses in Nicolaus.
Travelers, possessors, and natives who are wishing to find, learn, and explore or simply come upon information can use this website, FRBO.com.
Exotic advertisements and resort listings Inyo condos for rent, for rent by owner homes in Inyo California, rent house Inyo, and apartments for rent Inyo.
|
|
