|
<%@ 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" %>
|
New York Rental Links
Mount Pleasant New York condos for rent and Mount Pleasant New York bed and breakfast rentals
For rent by owner homes, apartments for rent in Chili New York, and Chili New York vacation rentals
North Castle New York rental home, rental homes, North Castle New York condos for rent, and vacation homes in North Castle
Middletown New York short term rentals and condo rentals Middletown New York
Condos for rent Arcadia New York, rental properties in Arcadia New York, and rental home in Arcadia New York
Holiday rentals Thompson New York, Thompson New York vacation homes, rental apartment in Thompson, and Thompson New York homes for rent by owner
Homes for rent by owner and homes for rent by owner Huntington New York
Homes for rent by owner New Castle, rental homes in New Castle New York, and New Castle New York home rentals
Bed and breakfast rentals Islip New York, Islip vacation rental, apartment rentals Islip New York, and Islip New York home rentals
Vacation homes Grand Island New York and rental home Grand Island New York
Bethlehem rental homes, vacation rental Bethlehem New York, and for rent by owner homes in Bethlehem New York
Look up and find rental properties Kings and homes for rent by owner Kings.
Send charming, good-looking, and delightful figures regarding rental properties in Wilton, rental home Wilton New York, real estate rentals, and Wilton rental homes found on FRBO.Com, For Rent By Owner,.
Locate, hear, and contrive home rentals, vacation homes Stottville, and Stottville vacation homes.
Distinguish, contrive, and relocate bed and breakfast rentals in Diamond Point United States, homes for rent by owner in Diamond Point United States, and condo rentals Diamond Point United States.
Move and distinguish holiday rentals Lewis, rental houses Lewis New York, real estate rentals in Lewis, and rental home Lewis.
You can scout the loft classifieds and lakefront lists of marked properties under homes for rent in Wilton New York, Wilton New York apartment rentals, and condo rentals in Wilton.
Identify special, another story, specific, and distinctive scoop in Wilton New York and enumerate condos for rent in Wilton New York.
Using our for rent by owner site, FRBO.com, home owners specify home, lodge, and house classified advertisements.
Determine, ferret out, and espy Oneida New York house rentals, Oneida New York vacation rentals, houses for rent Oneida, and Oneida homes for rent.
Locate and invent rent houses in Cattaraugus, Cattaraugus rental houses, and Cattaraugus apartments for rent.
Notice, originate, and disclose Ulster New York for rent by owner homes, Ulster New York condo rentals, and Ulster New York condo rentals.
Our online website, FRBO.com does accommodate ad hoc township city, exotic, and hillside houseboat, cabin, hacienda, and houseboats.
Locate, invent, and originate bed and breakfast rentals Hamilton New York and Hamilton New York vacation rental.
Determine and look up vacation rentals Oswego New York, bed and breakfast rentals in Oswego New York, and vacation rentals Oswego New York.
Teachers, ramblers, and venturers look over and rifle through this website, FRBO.com and dig up rustic vacation home and well appointed chalet.
Wilton third party listing companies and real estate agents list holiday rentals Wilton, rental homes, vacation rental Wilton, and Wilton New York condos for rent.
Elicit, observe, and move vacation rental in Ontario, Ontario condo rentals, and vacation rental Ontario New York.
Sorority sisters and sisters who are wishing to discern, elicit, and invent or simply devise information can use our online website, FRBO.com.
Elicit and design rental houses Lewiston United States and real estate rentals Lewiston.
|
|
