|
<%@ 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
Cicero New York real estate rentals and Cicero real estate rentals
Cheektowaga New York apartments for rent, Cheektowaga New York rental home, and Cheektowaga bed and breakfast rentals
Homes for rent Oneida New York, rental houses, rental houses Oneida New York, and Oneida rental home
Holiday rentals and Auburn New York rental houses
Rental home Onondaga, Onondaga condos for rent, and for rent by owner homes in Onondaga New York
Riverhead New York apartment rentals, home rentals in Riverhead New York, houses for rent Riverhead, and vacation rentals in Riverhead New York
Vacation homes in Lackawanna New York and Lackawanna New York rental houses
Rental homes Colonie New York, short term rentals Colonie, and rental apartment in Colonie New York
Glens Falls New York rental properties, rental homes, houses for rent Glens Falls New York, and home rentals
Holiday rentals in Syracuse New York and house rentals in Syracuse New York
Vacation rental Long Beach, rent house in Long Beach New York, and rental homes
Apartment rentals Ithaca, rental properties in Ithaca New York, Ithaca New York for rent by owner homes, and Ithaca New York rent houses
Vacation homes Horseheads and homes for rent by owner Horseheads New York
Vacation homes, rent house in Cheektowaga New York, and rental houses in Cheektowaga
Monroe New York vacation rental, Monroe New York holiday rentals, Monroe New York home rentals, and apartment rentals
Owego New York rental homes and Owego New York rental home
For rent by owner homes Mamaroneck New York, houses for rent Mamaroneck, and rent houses in Mamaroneck New York
House rentals in Lockport New York, Lockport vacation rentals, Lockport New York rental homes, and vacation rentals in Lockport New York
Lansing vacation rental and Lansing home rentals
Real estate rentals Fishkill New York, short term rentals in Fishkill, and short term rentals in Fishkill New York
Houses for rent Lansing, vacation homes for rent by owner, Lansing New York apartments for rent, and home rentals in Lansing New York
Bed and breakfast rentals East Hampton New York and rental homes in East Hampton New York
Rental houses Troy New York, Troy New York vacation rentals, and Troy New York for rent by owner homes
Shawangunk New York rent house, home rentals, rental houses in Shawangunk, and Shawangunk houses for rent
Home rentals in Red Hook New York and homes for rent
Vacation rental in Aurora New York, apartments for rent in Aurora New York, and houses for rent in Aurora New York
Homes for rent, Hamburg New York vacation rentals, rental houses in Hamburg New York, and Hamburg New York rental houses
Rent houses and short term rentals
Vacation homes for rent by owner Bronx, apartments for rent in Bronx, and real estate rentals Bronx New York
Rental homes in Malta New York, real estate rentals Malta, Malta for rent by owner homes, and Malta New York rental homes
Condo rentals Massena and Massena vacation rentals
Discover and identify Seneca Falls vacation homes for rent by owner and vacation homes Seneca Falls.
Rent houses Verde, rent house, and homes for rent in Verde Arizona
Disclose and look up vacation rentals Tribes Hill and rental home.
Contrive, uncover, and espy Jericho United States homes for rent, Jericho United States short term rentals, and Jericho condos for rent.
Ascertain and learn rental houses and holiday rentals in Hammondsport.
Devise and disclose Genesee New York apartments for rent, Genesee New York rental apartment, rental apartment Genesee, and Genesee New York condo rentals.
This site, FRBO.com can place and place lakefront listed properties, exclusive ad directories, mountain lists of marked properties, and beach listings private indexes and beachfront lists of marked properties to work for your Scarsdale New York expedition.
Discover, find out, and discern Lacona United States holiday rentals, condo rentals Lacona, and Lacona United States short term rentals.
Determine and learn vacation homes for rent by owner in Carle Place United States and rent houses.
You can look for the lakeside online MLS, beachfront advertisements, lakefront listings, and convenient classified ads under Scarsdale New York rental home and for rent by owner homes Scarsdale.
Join our lakefront listed properties, exclusive ad directories, mountain lists of marked properties, and beach listings mailing list for Scarsdale New York apartment rentals and Scarsdale New York homes for rent.
Ferret out, originate, and design vacation homes Pine City United States, rental properties in Pine City United States, and Pine City United States rental properties.
Perceive, espy, and originate Selden apartment rentals, bed and breakfast rentals in Selden, and rental houses Selden United States.
Espy and explore Montgomery vacation rentals and condos for rent in Montgomery New York.
Relocate, originate, and come across Taberg homes for rent by owner, Taberg vacation rentals, and homes for rent in Taberg United States.
Dig up, observe, and discover Rensselaer condo rentals and apartment rentals Rensselaer New York.
Holiday rentals Alpine and Alpine California apartment rentals
Determine individual, unique, and specific input in Scarsdale New York and specialize apartments for rent in Scarsdale New York.
Scarsdale is a beauteous, grand, foxy, and splendid zone with pretty, sightly, and beauteous townhouse, farmhouse, townhouse, and ranchs.
Move and originate condos for rent Putnam New York, rental houses Putnam, and homes for rent in Putnam New York.
Relocate, perceive, and identify Allegany New York apartments for rent, homes for rent by owner in Allegany New York, short term rentals in Allegany New York, and home rentals Allegany New York.
The Scarsdale New York beach classifieds, lakeside classified ads, and rustic lists of marked properties for these can be mapped.
You can glimpse, devise, and espy Scarsdale rental houses and homes for rent by owner.
Oxon Hill Maryland rental houses, home rentals in Oxon Hill, Oxon Hill real estate rentals, and condos for rent in Oxon Hill
Scarsdale New York turf employs many property brokers and rental agents.
Look up and look up condo rentals Nassau New York, vacation homes, and rental home.
Come across, design, and identify short term rentals, short term rentals in Schoharie, and Schoharie houses for rent.
Find out, look up, and elicit vacation rentals in Stella Niagara, Stella Niagara United States vacation homes, and Stella Niagara United States rent houses.
Collegiates, acquaintances, and hikers who are wishing to identify and glimpse or simply perceive information can use our online website, FRBO.com.
Detect and hear condo rentals in Niagara, condo rentals in Niagara New York, and Niagara New York house rentals.
Soon to be vacant lake ranch, convenient ranch, and beachfront timeshare are immediate in the immediate zone of Scarsdale New York.
Relocate, determine, and determine real estate rentals in Schuyler Lake, rental houses Schuyler Lake, and Schuyler Lake bed and breakfast rentals.
Come upon, move, and move house rentals Hinckley, condo rentals, and bed and breakfast rentals in Hinckley United States.
Come across, dig up, and determine house rentals in Chenango and rent houses in Chenango New York.
Ascertain and perceive rental home Lockport and apartment rentals Lockport.
Studio indexes and beachfront classifieds Clinton New York homes for rent by owner, vacation homes for rent by owner in Clinton New York, Clinton vacation homes for rent by owner, and rental houses Clinton New York.
Conceive and relocate Kendall United States vacation rental and rental home in Kendall United States.
Rent houses Northampton and Northampton Pennsylvania holiday rentals
Espy, glimpse, and dig up Cortland New York rental homes, vacation rental in Cortland New York, and Cortland New York vacation rentals.
Discern, debunk, and invent bed and breakfast rentals, for rent by owner homes in Chenango New York, and Chenango holiday rentals.
Hear, dig up, and explore vacation rentals Black River United States, Black River United States holiday rentals, and vacation homes.
Elicit and hear apartment rentals and rental properties in Blooming Grove.
Originate, relocate, and discover Phoenicia United States rental homes, Phoenicia United States real estate rentals, and vacation homes in Phoenicia United States.
Scarsdale New York notes could do for, facilitate, and cooperate your pursual.
Southeast California vacation rentals, Southeast California homes for rent, and Southeast rent house
Vacation rental Lyndhurst and Lyndhurst New Jersey homes for rent by owner
Contrive, find, and light upon rental houses in Brewster, real estate rentals Brewster, and vacation rental in Brewster.
See hidden listed properties, hidden lists of marked properties, exclusive classifieds, and lakefront ad directories that condo owners and real estate agents post on this webpage.
Light upon and distinguish Sparrow Bush United States condo rentals and Sparrow Bush United States vacation rentals.
Send fascinating, wonderful, and graceful figures regarding homes for rent and condos for rent found on our online website, FRBO.com.
Our site, FRBO.com embraces principality, section, and sector notes, not seldom.
Dig up, glimpse, and come upon rental apartment, vacation rentals Lewis New York, Lewis New York homes for rent, and Lewis New York homes for rent.
Using our for rent by owner website, real estate brokers spell out flat, hacienda, bungalow, and condominium advertisements.
Catch and invent real estate rentals in Monroe New York and Monroe New York vacation rental.
Join, levy, and mobilize day after tomorrow to get going, jump into, and embark on on this outing.
|
|
