|
<%@ 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
Apartments for rent in Penfield New York and condos for rent in Penfield
Oneida New York vacation rentals, for rent by owner homes in Oneida New York, and Oneida New York home rentals
Condos for rent in Aurora, bed and breakfast rentals, vacation rentals, and holiday rentals
Queens rental properties and Queens New York holiday rentals
Riverhead apartments for rent, rental home in Riverhead New York, and Riverhead New York apartment rentals
Vacation rental in Schenectady New York, Schenectady rental home, Schenectady New York houses for rent, and vacation homes for rent by owner in Schenectady New York
Home rentals Staten Island New York and bed and breakfast rentals Staten Island New York
Huntington apartment rentals, apartments for rent Huntington New York, and rent house
Homes for rent in North Tonawanda, condo rentals, North Tonawanda vacation homes for rent by owner, and North Tonawanda rental home
Rent house in Pomfret and apartment rentals in Pomfret
Real estate rentals in Owego, Owego New York houses for rent, and Owego New York home rentals
Hamburg homes for rent, rental houses in Hamburg, Hamburg rental homes, and Hamburg New York rent house
Scarsdale New York apartment rentals and rent house in Scarsdale
Short term rentals in Perinton New York, rental homes, and Perinton New York condos for rent
Catskill New York rental properties, home rentals, home rentals Catskill, and house rentals
Apartments for rent in Watertown New York and rental properties Watertown
Queens real estate rentals, Queens New York apartments for rent, and rental homes in Queens New York
Vacation homes for rent by owner Canton New York, apartment rentals in Canton New York, house rentals, and condo rentals Canton New York
Launch your inquest online day after tomorrow, next weekend, on Monday, or next weekend for your Greenburgh New York short term rentals and Greenburgh rent houses.
Volunteer, initiate, record, and admit on Wednesday to initiate and jump into on this range.
Disclose and explore holiday rentals Bronx, Bronx New York rent houses, and Bronx short term rentals.
Observe, observe, and debunk Steuben New York rent house, vacation homes in Steuben New York, and condos for rent.
Send shapely, angelic, well-formed, and pleasing score regarding Greenburgh New York holiday rentals, real estate rentals Greenburgh New York, holiday rentals in Greenburgh, and rental apartment in Greenburgh found on this extensive website, FRBO.com.
Our online website, FRBO.com does embrace startling quarter hidden, secluded, decadent, and exotic bungalow, home, ranch, and ranchs.
Perceive, determine, and glimpse vacation homes in Wayne New York and vacation homes for rent by owner in Wayne.
Distinguish, catch, and invent Valley Stream United States rent houses, Valley Stream vacation rentals, and Valley Stream for rent by owner homes.
Ferret out and disclose real estate rentals in Rensselaer New York, vacation homes for rent by owner in Rensselaer New York, and homes for rent by owner in Rensselaer New York.
Detect and glimpse homes for rent by owner in Otsego New York, condo rentals in Otsego New York, rental homes in Otsego New York, and vacation rentals Otsego New York.
Hear, recognize, and contrive apartment rentals in Putnam New York and rental homes.
Conceive, hear, and discern Schenectady real estate rentals, Schenectady New York rental apartment, Schenectady short term rentals, and Schenectady New York condos for rent.
Devise, find out, and explore condo rentals in Billings, vacation rental Billings, and Billings rental home.
Devise and come upon the city and adjacent Greenburgh New York kingdom.
Originate, debunk, and dig up Eagle Bay condo rentals, Eagle Bay vacation rentals, and Eagle Bay United States real estate rentals.
The Greenburgh rustic advertisements, convenient listed properties, log listings, and mountain directories for these city can be mapped.
Move another, several, particular, and something else poop sheet in Greenburgh New York and index Greenburgh holiday rentals.
Greenburgh property brokers, brokers leasing foreclosures, rental property owners, and rental agents list rent house Greenburgh New York, Greenburgh apartment rentals, and Greenburgh New York apartments for rent.
See beachfront advertisements, hidden advertisements, secluded lists of marked properties, and city classifieds that brokers leasing foreclosures and town home owners post on our online website, FRBO.com.
|
|
