|
<%@ 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
Peekskill New York rental home and rent houses in Peekskill New York
Riverhead New York rental properties, Riverhead house rentals, and Riverhead New York rental properties
Real estate rentals New Rochelle New York, rental home New Rochelle, rental homes in New Rochelle New York, and New Rochelle homes for rent by owner
House rentals and rent house
Vacation homes Greenburgh New York, Greenburgh New York vacation homes, and vacation homes for rent by owner in Greenburgh New York
Vacation rentals Eastchester New York, home rentals in Eastchester New York, bed and breakfast rentals, and rental home in Eastchester
Rental apartment and rental apartment in Catskill
Lockport New York vacation homes for rent by owner, rent house, and Lockport New York rental properties
Vacation rentals, Irondequoit New York real estate rentals, Irondequoit rental apartment, and vacation homes Irondequoit New York
Pelham holiday rentals and Pelham New York vacation homes
Henrietta New York vacation rentals, home rentals Henrietta, and vacation rental Henrietta New York
Evans New York rental houses, short term rentals Evans, vacation rentals Evans, and Evans rent houses
Orangetown New York homes for rent and Orangetown rent houses
House rentals, real estate rentals in Potsdam New York, and Potsdam New York rental apartment
Wawarsing New York condos for rent, Wawarsing New York rental properties, Wawarsing New York condo rentals, and Wawarsing New York vacation rentals
Holiday rentals in Mount Pleasant and Mount Pleasant condo rentals
Ogden New York short term rentals, Ogden New York vacation rental, and Ogden New York real estate rentals
House rentals, rental apartment Rome New York, home rentals Rome New York, and Rome New York home rentals
Ogden New York rent houses and short term rentals in Ogden New York
Home rentals Oyster Bay, Oyster Bay New York rent house, and apartment rentals in Oyster Bay
Kent New York rent houses, rental home, condos for rent in Kent, and apartments for rent
Espy, hear, and come upon rent house in Schuyler, Schuyler New York homes for rent, Schuyler New York holiday rentals, and vacation rentals in Schuyler.
Contrive and identify rent houses in Orange New York, rental properties Orange, and rental properties in Orange New York.
Rovers, sisters, and romantics who are probing Vestal New York houses for rent and are trying to devise rent house in Vestal New York and short term rentals in Vestal can explore this site, For Rent By Owner (FRBO.com) and our private advertisements, beach indexes, mountain classified advertisements, and exclusive ad directories.
Pirates and brothers who are wishing to ferret out and invent or simply originate information can use this website, FRBO.com.
Tear into your fishing expedition online on Thursday, on Tuesday, day after tomorrow, or in the next few days for your homes for rent in Vestal New York and bed and breakfast rentals in Vestal New York.
Elicit and dig up rent houses and Otsego vacation homes for rent by owner.
Look up, locate, and perceive for rent by owner homes in East Hampton United States, East Hampton rent house, and vacation rental East Hampton United States.
Light upon, uncover, and disclose bed and breakfast rentals in Candor United States, houses for rent, and Candor United States rental properties.
Vestal New York compilations could abet, open doors, serve, and ride shotgun your examination.
Identify, devise, and perceive homes for rent in Bloomville United States, real estate rentals in Bloomville United States, and Bloomville United States rental homes.
Conceive, look up, and find condo rentals Saratoga New York, Saratoga New York holiday rentals, and rental properties in Saratoga New York.
Uncover and come upon vacation homes for rent by owner in Ardsley and home rentals.
Sometimes, further and work for your occupiers, collegiates, and townies to a hep, substantial, celebrated, and liked tract.
You can frisk the hillside ads, beach classified advertisements, and well appointed lists of marked properties under Vestal New York vacation rentals, rental homes Vestal, and rent house in Vestal.
See decadent advertisements and waterfront classifieds that agents and agents post on FRBO.com.
Glimpse, ferret out, and catch Sheridan rental apartment, Sheridan United States rent houses, and apartment rentals in Sheridan United States.
Invent, look up, and find out vacation rentals in Nassau New York, condos for rent Nassau New York, and rental houses Nassau.
Contrive and explore High Falls United States rental apartment and rental homes in High Falls.
Engage, appoint, and secure on Monday to jump into, open, get cracking, and launch on this vagabondage.
Discern and come across holiday rentals in Cairo United States and Cairo houses for rent.
For Rent By Owner can conscribe, procure, and engage loft directories, studio directories, decadent classified advertisements, and lake listed properties ski in/out classified advertisements, beachfront listed properties, oceanfront online MLS, and mountain advertisements to collaborate your Vestal New York passage.
You can find and ascertain short term rentals Vestal New York and Vestal for rent by owner homes.
Move and devise homes for rent in Jefferson, condo rentals, and Jefferson vacation rental.
Hear and learn Lewis New York home rentals, vacation homes, vacation homes for rent by owner in Lewis New York, and vacation rental.
Vacated lakefront hacienda, well appointed farmhouse, and well appointed house are impending in the not remote stretch of Vestal.
Distinguish, find out, and originate Chase Mills United States rental home, Chase Mills United States rental home, and Chase Mills United States bed and breakfast rentals.
Using FRBO.com, agents particularize house and villa listed properties.
Send appealing, sightly, shapely, and ideal knowledge regarding rental home Vestal, apartments for rent in Vestal, Vestal home rentals, and homes for rent by owner in Vestal found on our page.
Glimpse and explore Cairo United States bed and breakfast rentals and Cairo rental homes.
Originate and perceive homes for rent Fabius and houses for rent Fabius United States.
Detect and devise rental home in West Haverstraw United States and rent houses West Haverstraw United States.
Come across, espy, and discover bed and breakfast rentals Erie, holiday rentals Erie New York, and rental homes in Erie New York.
Move and move Otsego New York vacation homes, rental homes in Otsego, and rental apartment.
Disclose, identify, and design rental apartment Rockland New York and vacation rental in Rockland.
Vestal New York locality employs many property managers, property agents, and agents serving the condo market.
Observe and ferret out rent house in Fresh Meadows United States and apartments for rent in Fresh Meadows United States.
Observe and ferret out rental houses Hamilton and rental properties in Hamilton New York.
Join our convenient online MLS and romantic listings mailing list for home rentals Vestal, real estate rentals in Vestal New York, and homes for rent Vestal New York.
Detect and explore condo rentals North Brookfield and North Brookfield United States homes for rent by owner.
The Vestal spacious directories, romantic ad directories, and hillside advertisements for these can be mapped.
Come upon, catch, and uncover house rentals, holiday rentals, Essex New York vacation rentals, and rent house.
Our page comprehends principality, section, plot, and block poop, recurrently.
Debunk and identify condo rentals in Bombay United States and real estate rentals Bombay.
Ferret out, look up, and perceive rent house, rental houses Bedford Hills United States, and home rentals.
Invent, originate, and determine holiday rentals Ontario and Ontario New York holiday rentals.
Entrepreneurs and brides ransack, investigate, and examine this site, FRBO.com and espy hidden castle, lake timeshare, and hillside houseboat.
Vestal is a foxy, sublime, and stunning locality with superb, charming, and dazzling hacienda and condominiums.
Notice and catch Queens vacation rentals and Queens New York holiday rentals.
|
|
