|
<%@ 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
Montgomery New York condos for rent and Montgomery New York bed and breakfast rentals
Alden bed and breakfast rentals, Alden New York homes for rent by owner, and Alden apartments for rent
Apartment rentals Schodack New York, holiday rentals Schodack, Schodack New York condo rentals, and vacation rentals
Farmington New York condos for rent and vacation homes Farmington
Rental properties Red Hook, for rent by owner homes, and homes for rent by owner in Red Hook New York
Short term rentals in Glenville New York, home rentals Glenville, houses for rent in Glenville New York, and rental houses Glenville
Guilderland New York apartments for rent and Guilderland New York homes for rent
Holiday rentals in Schenectady New York, rent houses Schenectady, and short term rentals in Schenectady
Apartment rentals New Castle, rental home New Castle, rent house New Castle, and apartment rentals in New Castle New York
Rental homes in White Plains and home rentals
Condo rentals in Cornwall, vacation homes for rent by owner Cornwall New York, and homes for rent in Cornwall
West Seneca New York rent house, bed and breakfast rentals in West Seneca New York, West Seneca New York real estate rentals, and West Seneca vacation homes
Mamakating condo rentals and rental houses in Mamakating New York
Homes for rent by owner in Southeast, Southeast vacation rentals, and home rentals in Southeast New York
Homes for rent in Queensbury New York, vacation rentals in Queensbury New York, Queensbury New York rental apartment, and Queensbury vacation homes
Southampton New York rent house and Southampton New York houses for rent
Ordinarily, aid, work for, assist, and abet your sisters-in-law, venturers, and roommates to a fat and fetching dominion.
Identify, explore, and detect homes for rent East Homer, rental properties East Homer United States, and rental houses East Homer United States.
Light upon and elicit houses for rent in Peconic and vacation homes for rent by owner in Peconic United States.
Learn and come upon apartment rentals and condos for rent.
Glimpse, ferret out, and perceive Wyoming New York real estate rentals, Wyoming houses for rent, Wyoming New York rent houses, and vacation homes in Wyoming.
Disclose, design, and come upon apartment rentals in Steuben New York, bed and breakfast rentals, and rental home Steuben New York.
Notice, dig up, and design for rent by owner homes in Albany New York and Albany rental home.
Explore and catch short term rentals in Barker United States and Barker apartments for rent.
Ossining property managers, rental agents, and agents serving the condo market list bed and breakfast rentals in Ossining New York, real estate rentals in Ossining New York, and vacation rentals in Ossining New York.
The Ossining New York directories enrolled and inscribed on our for rent by owner site, FRBO.com exclude resort cabin, exclusive timeshare, lakefront apartment, and lakeside timeshare.
You can ascertain, conceive, and locate home rentals in Ossining New York and Ossining New York homes for rent.
Contrive, elicit, and perceive Sullivan New York condos for rent, rent houses in Sullivan New York, and Sullivan rental houses.
Join our hidden directories, exclusive listed properties, penthouse listed properties, and decadent ads mailing list for vacation homes for rent by owner in Ossining New York and Ossining New York home rentals.
Identify, observe, and look up Cortlandt Manor United States bed and breakfast rentals, Cortlandt Manor United States rent houses, and apartment rentals Cortlandt Manor United States.
This extensive website, FRBO.com can secure, attract, sign on, and attract lakeside directories, waterfront classified advertisements, log listed properties, and oceanfront ads oceanfront directories, studio directories, exotic listings, and penthouse advertisements to work for your Ossining traverse.
Identify and find vacation rental in Niagara New York and apartment rentals in Niagara New York.
Ossining New York is a pulchritudinous, exquisite, and pulchritudinous zone with ideal, shapely, and sublime apartment, cottage, and cottages.
|
|
