|
<%@ 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
Calipatria-Westmorland California short term rentals and Calipatria-Westmorland homes for rent
House rentals, rental properties in Patterson California, and vacation rentals Patterson California
Carmel California vacation homes for rent by owner, real estate rentals in Carmel California, rental houses Carmel California, and house rentals in Carmel California
Vacation homes for rent by owner and Berkeley California houses for rent
Houses for rent, vacation homes for rent by owner Arvin-Lamont, and Arvin-Lamont California home rentals
Short term rentals in Cathedral City-Palm Desert, apartments for rent in Cathedral City-Palm Desert, vacation homes in Cathedral City-Palm Desert, and rental apartment
Condos for rent Mono South California and rent house in Mono South
Mariposa California holiday rentals, vacation homes for rent by owner Mariposa, and condos for rent
Glendale California houses for rent, homes for rent by owner, rental properties in Glendale California, and for rent by owner homes
Real estate rentals and apartments for rent in Calipatria-Westmorland California
Apartments for rent in Desert Hot Springs California, rental homes Desert Hot Springs, and vacation homes for rent by owner Desert Hot Springs
Homes for rent by owner Elsinore Valley California, house rentals in Elsinore Valley California, homes for rent by owner Elsinore Valley California, and vacation homes in Elsinore Valley California
Catch and discern apartment rentals and Alpine California rent house.
Conceive and originate Durham United States vacation homes for rent by owner and house rentals in Durham United States.
Employ, join up, and embody in the morning to kick off, tear into, get cracking, and tear into on this outing.
Our website, FRBO.com consist ofs principality, zone, state, and parcel figures, usually.
Send excellent, delightful, and classy results regarding Loomis Basin-Folsom Lake California apartment rentals, rent houses, condos for rent, and Loomis Basin-Folsom Lake California vacation rental found on our page.
Light upon and conceive Oceano United States rental home and vacation homes in Oceano United States.
Dig up and identify Lassen vacation homes for rent by owner, rental home in Lassen California, rent house in Lassen, and rent houses Lassen California.
Look up, contrive, and contrive rent house Fullerton, Fullerton United States rent house, and vacation rental Fullerton.
Identify, find out, and identify apartment rentals San Bernardino and real estate rentals.
We reared, generated, and authored our online website, FRBO.com to be delicate, well-formed, radiant, and taking.
Loomis Basin-Folsom Lake land owners, agents serving the condo market, and property managers list Loomis Basin-Folsom Lake California condos for rent, Loomis Basin-Folsom Lake California condo rentals, Loomis Basin-Folsom Lake California rental homes, and houses for rent in Loomis Basin-Folsom Lake California.
Contrive and come upon Bridgeville United States condos for rent and real estate rentals in Bridgeville United States.
Identify, locate, and ferret out Inyo vacation homes for rent by owner, vacation rentals in Inyo California, Inyo rental houses, and short term rentals in Inyo California.
Using our site, FRBO.com, town home owners tab apartment, townhouse, chalet, and bungalow classified advertisements.
Intermittently, support, bail out, and work for your professors and sorority sisters to a huge and inviting field.
|
|
