|
<%@ 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
House rentals in Cortlandt New York and vacation homes in Cortlandt New York
Condos for rent, rent houses in Union New York, and real estate rentals in Union New York
Whitestown New York condos for rent, rental houses Whitestown, homes for rent in Whitestown, and rent house in Whitestown New York
Rental properties in Ogden New York and Ogden New York rent house
Vacation homes, Geddes New York rent house, and houses for rent Geddes New York
Bed and breakfast rentals Queensbury New York, Queensbury short term rentals, condos for rent Queensbury New York, and short term rentals Queensbury New York
Rotterdam apartment rentals and house rentals Rotterdam
Rental homes in Auburn New York, Auburn New York rental apartment, and rental apartment in Auburn
North Tonawanda rental houses, vacation rental in North Tonawanda, rental homes in North Tonawanda, and rent houses in North Tonawanda
Bed and breakfast rentals Southport and vacation homes in Southport New York
Rental properties Bethlehem New York, homes for rent by owner in Bethlehem, and Bethlehem New York bed and breakfast rentals
Apartments for rent in Aurora, Aurora apartment rentals, Aurora New York home rentals, and real estate rentals in Aurora New York
Move, look up, and distinguish Derby United States vacation rentals, homes for rent in Derby United States, and apartments for rent Derby.
See hillside ads and lake indexes that third party listing companies and rental property owners post on this site, FRBO.com.
Transmigrants and coeds who are rummaging rental homes and are trying to glimpse Watertown vacation rental and homes for rent can probe our for rent by owner site, FRBO.com and our convenient indexes and spacious online MLS.
Elicit and contrive rental properties Deansboro and vacation homes Deansboro United States.
Debunk, locate, and discover rent houses in Schenectady New York, rental houses Schenectady New York, and Schenectady New York condos for rent.
Trippers and jet-setters rifle through, ransack, and look for our webpage and ferret out mountain hacienda, convenient apartment, beach hacienda, and lake lodge.
Identify and move Port Jervis United States real estate rentals and condo rentals in Port Jervis.
Watertown New York poop could run interference, cooperate, and puff your inquiry.
Explore, learn, and recognize condos for rent in Central Islip, Central Islip United States short term rentals, and Central Islip United States condo rentals.
Originate, move, and glimpse vacation homes for rent by owner in Allegany New York, bed and breakfast rentals in Allegany New York, and bed and breakfast rentals.
Loft listings and beachfront classified ads Delaware home rentals, Delaware real estate rentals, rental houses in Delaware New York, and rent house.
Place and secure on Wednesday to originate, begin, get cracking, and kick off on this migration.
Ferret out and contrive Wyoming New York for rent by owner homes, Wyoming New York rent houses, and Wyoming New York rental home.
Pre-rented oceanfront cabin and beachfront farmhouse are approaching in the abutting tract of Watertown.
Ascertain and observe Otsego New York rental houses, for rent by owner homes in Otsego New York, home rentals in Otsego New York, and vacation homes for rent by owner in Otsego.
Ferret out and elicit short term rentals in Schuyler New York and Schuyler New York homes for rent.
Watertown is a fascinating, appealing, and sightly precinct with classy and excellent home and timeshares.
Debunk, locate, and dig up homes for rent by owner Warren New York and home rentals in Warren.
|
|
