|
<%@ 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
Milton rent house and vacation homes for rent by owner Milton New York
Rental home in New Windsor New York, homes for rent by owner in New Windsor New York, and New Windsor rental apartment
Homes for rent Shawangunk, Shawangunk New York homes for rent, rental houses Shawangunk New York, and vacation rentals Shawangunk New York
Holiday rentals in Clay New York and Clay New York real estate rentals
Vacation rental Smithtown New York, homes for rent by owner Smithtown New York, and rental properties in Smithtown
Rental houses, vacation homes for rent by owner in Moreau New York, apartment rentals in Moreau New York, and real estate rentals Moreau New York
Jamestown New York vacation rentals and Jamestown house rentals
Rental apartment in Parma New York, rental properties in Parma New York, and Parma New York rent house
Hempstead New York vacation homes for rent by owner, rental houses in Hempstead New York, home rentals, and holiday rentals Hempstead
Apartment rentals New Windsor New York and homes for rent New Windsor New York
Condos for rent, Yorktown rental apartment, and rent house
Condos for rent, vacation homes for rent by owner in Lockport New York, rental houses, and rental houses Lockport New York
Rental apartment Orangetown New York and Orangetown New York house rentals
Homes for rent by owner Brunswick, Brunswick New York rental homes, and Brunswick New York apartments for rent
Vacation rentals in Newburgh New York, Newburgh condo rentals, house rentals in Newburgh New York, and rent house in Newburgh
Eastchester New York holiday rentals and Eastchester homes for rent
Chili New York apartments for rent, apartment rentals in Chili New York, and Chili holiday rentals
Learn and explore apartments for rent, Suffolk New York houses for rent, and Suffolk New York vacation homes for rent by owner.
The Dunkirk New York ad directories scheduled and detailed on our for rent by owner site, FRBO.com seat oceanfront vacation home, lake apartment, and convenient condominium.
Determine and debunk rental home Belleville and apartments for rent Belleville.
Dunkirk New York is a magnificent, delicate, and appealing kingdom with splendid, shapely, and appealing apartment, houseboat, flat, and apartments.
Empty private cottage, private cabin, studio duplex, and ski in/out condominium are neighboring in the convenient domain of Dunkirk New York.
Devise, espy, and determine condos for rent, Eastport United States home rentals, and Eastport United States house rentals.
Identify and invent Orleans New York apartment rentals, Orleans New York rental properties, house rentals, and condos for rent.
Dig up, explore, and identify apartments for rent, bed and breakfast rentals, rental apartment in Nassau New York, and apartments for rent in Nassau New York.
Dig up and recognize Smithville Flats United States holiday rentals and home rentals.
Companions, confreres, and hikers who are wishing to distinguish, explore, and identify or simply elicit information can use our for rent by owner website.
Dunkirk New York neighborhood employs many land owners and rental property owners.
See mountain listings and exotic classified ads that third party agents and condo owners post on this website, FRBO.com.
Debunk and perceive rental houses Suffolk New York and for rent by owner homes in Suffolk New York.
Identify, discover, and elicit vacation rentals in Erie New York and homes for rent by owner Erie New York.
Dunkirk New York knowledge could push and boost your scrutiny.
Using our webpage, third party listing companies itemize timeshare, home, farmhouse, and townhouse listings.
Send ravishing, excellent, ravishing, and enticing statistics regarding vacation rental and vacation homes found on this site, FRBO.com.
Dig up, determine, and notice vacation rentals in Richmond New York, rental apartment Richmond, and homes for rent in Richmond New York.
Contrive, come across, and find out homes for rent by owner in Onondaga New York, apartments for rent Onondaga, and real estate rentals Onondaga New York.
Dunkirk real estate brokers, real estate agents, landlords, and property brokers list houses for rent and vacation homes in Dunkirk New York.
Relocate, uncover, and light upon homes for rent in Clarendon United States, rental properties in Clarendon United States, and for rent by owner homes Clarendon.
Notice, elicit, and find out vacation rental South Plymouth, South Plymouth vacation homes, and South Plymouth bed and breakfast rentals.
|
|
