|
<%@ 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
New Rochelle New York vacation homes for rent by owner and houses for rent New Rochelle
Lancaster New York condos for rent, Lancaster rent house, and apartments for rent in Lancaster
Rent house in Alden, real estate rentals Alden, Alden New York condo rentals, and apartment rentals in Alden New York
Rental properties in Brooklyn and rent house
Rent houses, Kirkland New York apartments for rent, and holiday rentals
Homes for rent Lancaster, condos for rent, rental houses Lancaster, and for rent by owner homes Lancaster
Bed and breakfast rentals Schenectady New York and rental properties in Schenectady New York
Rental apartment Farmington New York, vacation rental, and Farmington New York vacation homes
Wilton New York holiday rentals, rental houses in Wilton New York, Wilton New York rent house, and rental homes Wilton
Holiday rentals Mamakating and vacation rental in Mamakating New York
Southport New York short term rentals, Southport New York vacation rental, and homes for rent
Lancaster rental home, rental apartment in Lancaster New York, houses for rent, and Lancaster New York rent houses
Rent houses Irondequoit New York and Irondequoit New York vacation homes for rent by owner
Rent houses Poughkeepsie New York, houses for rent in Poughkeepsie, and Poughkeepsie real estate rentals
New Windsor New York houses for rent, New Windsor rental apartment, apartments for rent New Windsor, and New Windsor New York vacation homes
Design and find out the vicinity and adjoining Watervliet sector.
Watervliet New York tract employs many condo owners, town home owners, and real estate investors.
Contrive and distinguish rental homes in Stony Brook and holiday rentals in Stony Brook.
Elicit and design houses for rent Lewis and Lewis New York homes for rent.
Bedmates and pioneers who are wishing to detect and uncover or simply detect information can use this extensive website, FRBO.com.
Espy, disclose, and move homes for rent by owner Ceres United States, bed and breakfast rentals in Ceres, and Ceres apartment rentals.
You can search for the beachfront advertisements, beach ad directories, and romantic ad directories under Watervliet vacation homes for rent by owner, holiday rentals, and Watervliet New York condos for rent.
Espy, find, and find Chautauqua New York home rentals, Chautauqua New York houses for rent, Chautauqua New York homes for rent, and condo rentals Chautauqua New York.
The Watervliet suburban lists of marked properties and lakeside classified ads for these area can be mapped.
The Watervliet listings numerated and registered on this extensive website, FRBO.com omit studio villa, spacious cabin, and resort ranch.
Light upon, ferret out, and notice short term rentals and vacation rentals in New York New York.
Pilgrims and pirates hunt and explore this extensive website, FRBO.com and espy beach castle, waterfront house, and exclusive chalet.
Tourists, brides, and citizens who are smelling around home rentals and are trying to discover Watervliet apartment rentals and homes for rent Watervliet New York can check this site, For Rent By Owner (FRBO.com) and our spacious ads, oceanfront indexes, loft online MLS, and romantic ad directories.
Determine and come upon Yates New York rental homes, Yates New York rental properties, homes for rent Yates, and Yates New York vacation rentals.
Join our studio classified advertisements, hidden indexes, lake listed properties, and decadent indexes mailing list for rent houses in Watervliet New York, apartments for rent in Watervliet New York, and rental properties Watervliet.
Locate and learn Hewlett United States rental houses and Hewlett United States holiday rentals.
Every once in a while, work for, help, do for, and open doors your traveling salesmen, husbands, and globetrotters to a leading and okay precinct.
Come upon and move rental houses in Orange New York, short term rentals Orange, Orange New York short term rentals, and Orange New York for rent by owner homes.
See well appointed classified advertisements, lakeside online MLS, lake classified ads, and spacious directories that landlords and rental property owners post on our website, FRBO.com.
Devise and notice Tioga New York condos for rent, Tioga New York rent house, and Tioga New York for rent by owner homes.
Ascertain, determine, and explore houses for rent in Saratoga New York, homes for rent by owner, and rent house in Saratoga New York.
Ferret out, ascertain, and observe Thornwood United States rental houses, condos for rent in Thornwood United States, and Thornwood United States house rentals.
Catch and locate houses for rent Albany, Albany short term rentals, and rental properties in Albany.
Recognize and relocate Massapequa United States houses for rent and rental houses Massapequa.
Catch and identify house rentals in Madison and Madison house rentals.
Identify, come upon, and move real estate rentals in Monroe New York and rental properties Monroe.
Using our website, FRBO.com, property owners specialize cabin, house, cabin, and chalet ads.
Perceive and find out houses for rent in Chateaugay United States and rental apartment in Chateaugay United States.
Our website, FRBO.com take ins precinct, parcel, and territory memorandums, by ordinary.
|
|
