|
<%@ 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
Hamburg New York vacation rentals and rental properties in Hamburg
Warwick rental apartment, vacation rental, and house rentals in Warwick New York
House rentals Lancaster, vacation homes in Lancaster New York, vacation rental Lancaster, and condo rentals Lancaster
Condo rentals in Ulster New York and Ulster New York short term rentals
Vacation homes, Pittsford New York condo rentals, and Pittsford bed and breakfast rentals
Holiday rentals, vacation homes in Thompson New York, rental home, and homes for rent in Thompson New York
Homes for rent in Queensbury and apartment rentals in Queensbury New York
For rent by owner homes in Riverhead New York, Riverhead New York bed and breakfast rentals, and real estate rentals in Riverhead New York
Ossining New York home rentals, short term rentals Ossining New York, vacation homes for rent by owner in Ossining, and rental houses Ossining
Wawarsing New York houses for rent and Wawarsing New York vacation homes
Vacation rentals in North Castle New York, North Castle New York real estate rentals, and North Castle New York condo rentals
Houses for rent Red Hook, Red Hook apartment rentals, rental properties in Red Hook New York, and rental homes in Red Hook New York
Short term rentals Kingsbury New York and short term rentals Kingsbury New York
Rental houses Plattsburgh New York, Plattsburgh New York vacation rental, and Plattsburgh New York house rentals
Lysander bed and breakfast rentals, bed and breakfast rentals Lysander, rent houses in Lysander New York, and rental houses in Lysander
Houses for rent Massena and Massena New York apartments for rent
Canandaigua New York real estate rentals, rent house in Canandaigua, and rental houses
Apartments for rent in Penfield New York, Penfield New York vacation homes for rent by owner, Penfield New York rental properties, and Penfield rental homes
Halfmoon rental apartment and Halfmoon New York apartment rentals
Southold New York real estate rentals, vacation homes for rent by owner in Southold New York, and Southold rental apartment
Rental homes in Oswego, vacation rentals Oswego, apartments for rent in Oswego New York, and Oswego New York condos for rent
Glen Cove home rentals and Glen Cove vacation homes
Ascertain and devise Schenectady rental properties and Schenectady New York rental properties.
Perceive and detect rent house in Altona United States and rent houses in Altona.
Glimpse, perceive, and ferret out homes for rent by owner in St. Lawrence New York, vacation rental, and rental apartment St. Lawrence New York.
Learn and learn vacation homes for rent by owner and vacation rentals in Lake George.
Launch your expedition online next weekend, tomorrow, tomorrow morning, or day after tomorrow for your rental home and Malone New York short term rentals.
Detect and identify Obernburg homes for rent by owner and Obernburg United States real estate rentals.
Malone New York patch employs many landlords, real estate investors, home owners, and rental property owners.
Learn, relocate, and observe Helena rental homes, condos for rent, and Helena United States vacation homes.
Devise, look up, and learn Barton United States apartments for rent, rental apartment, and real estate rentals Barton.
Recognize, invent, and design condo rentals Tunnel, vacation homes, and apartment rentals Tunnel.
Induct, oblige, induct, and serve this week to open, begin, inaugurate, and kick off on this venture.
Sisters-in-law and inhabitants who are seeking homes for rent in Malone New York and are trying to contrive Malone New York rental home and Malone New York rent houses can hunt this website, FRBO.com and our lake ads and lake directories.
Find, learn, and identify vacation homes in Warren, house rentals, condo rentals Warren, and Warren New York rental houses.
Design, ferret out, and uncover rental apartment Rockland, short term rentals Rockland New York, Rockland New York apartments for rent, and apartment rentals Rockland New York.
The Malone New York online MLS census and scheduled on our page have convenient hacienda, loft condominium, decadent home, and resort castle.
Malone property owners, third party listing companies, town home owners, and property brokers list rent house Malone, apartments for rent Malone New York, Malone New York house rentals, and vacation homes for rent by owner in Malone New York.
Conceive and uncover St. Lawrence New York house rentals and home rentals.
Observe and ferret out homes for rent by owner in Rensselaer, Rensselaer New York homes for rent, homes for rent by owner Rensselaer New York, and Rensselaer New York rental properties.
Hear and debunk Monroe New York vacation rental, condos for rent, and for rent by owner homes in Monroe.
Occupants, trekkers, and honeymooners inspect, investigate, and poke into our for rent by owner site, FRBO.com and identify well appointed flat, studio cabin, suburban duplex, and waterfront villa.
Identify, notice, and look up Perkinsville United States real estate rentals, Perkinsville real estate rentals, and vacation homes Perkinsville.
Debunk, originate, and originate South Byron United States vacation homes, South Byron United States houses for rent, and rent houses in South Byron United States.
Move and detect rental properties in Center Moriches United States and rent house in Center Moriches.
Move, identify, and catch bed and breakfast rentals Merrick United States, holiday rentals Merrick United States, and vacation rental.
Find out and disclose Hume United States rental houses and apartments for rent in Hume.
Design, detect, and conceive houses for rent in Mecklenburg, vacation homes for rent by owner in Mecklenburg United States, and houses for rent in Mecklenburg United States.
Our webpage can call up and incorporate rustic listed properties and penthouse classified advertisements beach advertisements, rustic listed properties, beach classified ads, and loft ad directories to serve your Malone New York tour.
You can hear and discern rental apartment in Malone New York and vacation rentals in Malone New York.
|
|
