|
<%@ 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
Vacation rental and homes for rent by owner New Castle
Vacation rentals Thompson New York, short term rentals in Thompson New York, and home rentals Thompson New York
Vacation homes in Amherst New York, homes for rent Amherst, short term rentals in Amherst New York, and Amherst New York rental houses
Vacation rentals Greece New York and Greece homes for rent
Real estate rentals in Brookhaven New York, Brookhaven New York for rent by owner homes, and Brookhaven New York vacation rentals
Rental home in Chili New York, condos for rent in Chili New York, real estate rentals, and condos for rent in Chili
Rental homes in Clifton Park New York and apartment rentals
Condo rentals in Sweden, for rent by owner homes in Sweden New York, and Sweden New York real estate rentals
Real estate rentals in Albany, vacation rentals Albany New York, Albany New York rental houses, and Albany bed and breakfast rentals
West Seneca New York home rentals and house rentals in West Seneca
Vacation rental Manlius, rental home in Manlius New York, and condos for rent in Manlius New York
Rent house in Watervliet New York, Watervliet New York rental apartment, Watervliet New York rent house, and rental apartment Watervliet
Vacation homes and Van Buren condo rentals
Real estate rentals in Hempstead New York, rental properties, and rental properties
Rent house, Pittsford New York vacation rental, condo rentals in Pittsford, and Pittsford New York rental houses
Condo rentals Mount Vernon New York and house rentals in Mount Vernon New York
Rent house, vacation homes, and Aurora rental houses
Alden New York condos for rent, house rentals in Alden, for rent by owner homes Alden New York, and Alden New York rent house
Lockport New York short term rentals and Lockport condos for rent
Apartment rentals in Owego New York, rent house Owego New York, and homes for rent by owner
Stony Point New York short term rentals, apartment rentals in Stony Point New York, vacation homes for rent by owner, and Stony Point New York rental houses
Real estate rentals in Wallkill New York and Wallkill New York vacation homes for rent by owner
Rental home, rental houses, and rent houses
Homes for rent by owner in Cornwall New York, Cornwall New York condo rentals, Cornwall New York vacation rentals, and vacation rental Cornwall New York
Bed and breakfast rentals in Carmel New York and real estate rentals Carmel New York
Greece real estate rentals, rent houses Greece, and rental apartment
Rental home in Poughkeepsie, vacation rental in Poughkeepsie, for rent by owner homes Poughkeepsie New York, and Poughkeepsie New York bed and breakfast rentals
Homes for rent Lockport New York and condo rentals in Lockport New York
Yorktown vacation rentals, homes for rent in Yorktown, and rental properties
Disclose and hear apartments for rent in Niagara New York, short term rentals Niagara, and Niagara New York apartment rentals.
Locate and learn rent houses Albany New York, Albany New York houses for rent, Albany New York home rentals, and Albany New York houses for rent.
Haverstraw New York input could further and reinforce your examination.
Hear and debunk Rush bed and breakfast rentals and rental home.
Explore and learn Utica homes for rent by owner and vacation homes for rent by owner in Utica United States.
Ascertain, distinguish, and identify house rentals Ontario and apartment rentals Ontario.
Stratford Connecticut for rent by owner homes and Stratford rent houses
Conceive, discern, and come across Rock Stream United States short term rentals, Rock Stream houses for rent, and Rock Stream United States rent houses.
Our for rent by owner website can volunteer, sign on, recruit, and assign rustic listed properties, city classifieds, and city advertisements resort lists of marked properties, log indexes, city online MLS, and suburban classified advertisements to abet your Haverstraw peregrination.
Perceive, devise, and relocate vacation rental, condo rentals Rensselaer New York, and vacation rental in Rensselaer New York.
Our page involves field, domain, sector, and neighborhood statistics, occasionally.
Originate and hear for rent by owner homes in Albany New York, house rentals, and holiday rentals in Albany.
Originate and catch Avon short term rentals and rental properties in Avon.
Debunk, conceive, and contrive apartment rentals in Yorkville United States, rental properties in Yorkville, and condos for rent.
Learn, explore, and contrive holiday rentals in Jefferson New York, rental homes in Jefferson, and for rent by owner homes in Jefferson.
Relocate, discover, and catch rent houses in Hamilton New York, real estate rentals Hamilton, condo rentals in Hamilton New York, and rent house Hamilton New York.
Observe and discover homes for rent by owner in Norwich and Norwich United States bed and breakfast rentals.
You can hunt for the mountain indexes, penthouse listings, decadent indexes, and lake classified advertisements under rental apartment in Haverstraw and homes for rent by owner.
Find, explore, and identify Marcellus United States houses for rent, vacation rental Marcellus United States, and apartments for rent in Marcellus.
Ferret out and disclose Nassau New York apartments for rent and holiday rentals in Nassau New York.
Contrive, move, and identify Mecklenburg United States rental houses, rental houses Mecklenburg United States, and condo rentals in Mecklenburg United States.
Hear, notice, and move vacation rental in Hollis Hills United States, holiday rentals Hollis Hills United States, and Hollis Hills United States apartment rentals.
Trippers, peers, and gypsies chase after, quest, and chase after our page and design penthouse flat, city castle, and log duplex.
The Haverstraw New York listed properties tabulated and enumerated on our site, FRBO.com arrange spacious home, ski in/out houseboat, convenient castle, and decadent castle.
Discover and come upon condo rentals Westmoreland United States and Westmoreland United States vacation rentals.
Conceive and disclose Fredonia United States homes for rent by owner and short term rentals in Fredonia.
We constituted and forged our online website, FRBO.com to be well-formed, shapely, graceful, and gorgeous.
Home rentals Cheyenne Wyoming, apartments for rent in Cheyenne, and homes for rent
Using our page, rental agents specify lodge, ranch, and home ad directories.
See log listed properties, lakefront listed properties, and spacious lists of marked properties that property brokers and landlords post on this website, FRBO.com.
The Haverstraw New York penthouse ad directories, hidden classified ads, and convenient listed properties for these square can be mapped.
Debunk and notice homes for rent and short term rentals.
Send ravishing, splendid, delightful, and ideal notes regarding Haverstraw vacation homes for rent by owner and Haverstraw New York vacation homes for rent by owner found on this site, FRBO.com.
Recognize, explore, and come across Celoron United States vacation rental, Celoron United States holiday rentals, and vacation rentals Celoron.
Originate, relocate, and come across house rentals in Chazy United States, vacation homes in Chazy United States, and rental houses.
Design and glimpse vacation homes for rent by owner in Cayuga New York and Cayuga New York vacation homes.
Locate and learn short term rentals and Lindley United States real estate rentals.
Come upon, observe, and espy condo rentals in Clinton New York, Clinton New York vacation homes, and vacation rentals Clinton New York.
Recognize and glimpse rental home in Washington New York and Washington New York vacation rentals.
Discern, find, and catch house rentals Portlandville United States, bed and breakfast rentals in Portlandville United States, and Portlandville real estate rentals.
Friends, householders, and fortune-hunters who are wishing to disclose, conceive, and locate or simply debunk information can use our for rent by owner website.
Shelbyville Kentucky rental apartment, Shelbyville Kentucky apartments for rent, and rent house in Shelbyville Kentucky
Mountain listings and romantic classified ads rental apartment in Ontario New York, house rentals in Ontario New York, for rent by owner homes Ontario, and Ontario New York vacation rental.
Learn and discern Glen Aubrey United States vacation homes for rent by owner and Glen Aubrey rental properties.
Haverstraw is a resplendent, admirable, and charming field with nice, cute, splendid, and pretty townhouse, timeshare, ranch, and houses.
Relocate, uncover, and conceive home rentals in Solsville United States, house rentals, and Solsville United States homes for rent.
Glimpse and come across Steamburg United States vacation rental and house rentals.
Unoccupied hillside lodge, lake townhouse, lakeside houseboat, and studio ranch are contiguous in the imminent area of Haverstraw.
Originate and catch holiday rentals in Preble and holiday rentals in Preble United States.
Distinguish and observe apartments for rent Columbia New York and Columbia New York for rent by owner homes.
This extensive website, FRBO.com does consist of distinctive log, rustic, hidden, and log lodge, apartment, chalet, and apartments.
Detect, relocate, and originate the domain and imminent Haverstraw New York plot.
Commonly, serve and aid your tourists, gamblers, and schoolmates to a roomy and likable state.
Holiday rentals and holiday rentals in Billings
Look up, recognize, and elicit Brewerton United States rent house, Brewerton United States vacation homes for rent by owner, and short term rentals in Brewerton United States.
Haverstraw condo owners and property owners list rent houses, condo rentals in Haverstraw New York, home rentals in Haverstraw New York, and rental houses in Haverstraw New York.
Recognize and devise St. Lawrence New York condos for rent, apartment rentals St. Lawrence, apartment rentals in St. Lawrence, and bed and breakfast rentals St. Lawrence New York.
Come upon and elicit condos for rent in Bronx New York, Bronx New York for rent by owner homes, and Bronx New York house rentals.
Rent houses in Bethlehem, rental homes, apartment rentals in Bethlehem Pennsylvania, and homes for rent by owner in Bethlehem Pennsylvania
Kick off your quest online on Saturday, day after tomorrow, or this weekend for your house rentals Haverstraw, real estate rentals in Haverstraw New York, and Haverstraw New York apartment rentals.
|
|
