|
<%@ 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
Homes for rent by owner Hyde Park New York and Hyde Park New York house rentals
Apartment rentals in Kingsbury New York, Kingsbury New York vacation rentals, and for rent by owner homes in Kingsbury
Houses for rent Binghamton, Binghamton vacation homes for rent by owner, home rentals, and apartments for rent in Binghamton New York
Bed and breakfast rentals in Canandaigua New York and homes for rent Canandaigua New York
Condo rentals, for rent by owner homes in Bath New York, and apartments for rent
Eastchester holiday rentals, Eastchester condo rentals, vacation homes in Eastchester New York, and condos for rent Eastchester New York
Oneonta rental apartment and apartment rentals in Oneonta
Holiday rentals Beekman, rent houses Beekman New York, and vacation homes for rent by owner in Beekman New York
Holiday rentals in Horseheads, rental homes Horseheads New York, homes for rent by owner Horseheads, and Horseheads apartment rentals
North Tonawanda real estate rentals and rent house North Tonawanda
For rent by owner homes in Kingsbury, house rentals in Kingsbury, and rental apartment in Kingsbury
Homes for rent by owner in Ramapo, Ramapo rent houses, Ramapo New York vacation rental, and vacation rentals in Ramapo New York
Condos for rent Fallsburg New York and homes for rent
Originate and perceive bed and breakfast rentals Manlius United States and condo rentals in Manlius.
Design and relocate homes for rent West Stockholm United States and house rentals in West Stockholm United States.
Send angelic, wonderful, classy, and well-formed goods regarding rental houses, apartment rentals in Niagara Falls, Niagara Falls New York vacation rental, and vacation homes in Niagara Falls New York found on our for rent by owner site, FRBO.com.
You can inspect the private listings and convenient indexes under rental homes in Niagara Falls New York and condos for rent.
Ascertain, catch, and light upon Dunkirk vacation rentals, Dunkirk United States apartment rentals, and real estate rentals in Dunkirk United States.
Seafarers, friends, and roomers hunt and scrutinize this site, For Rent By Owner (FRBO.com) and catch mountain apartment, waterfront townhouse, decadent houseboat, and beachfront house.
Detect, recognize, and identify Chemung houses for rent, rental houses in Chemung New York, rental home Chemung, and vacation rentals.
Discern, look up, and come upon Montour Falls United States rental home, rent house, and Montour Falls United States homes for rent by owner.
Niagara Falls New York quarter employs many rental owners, rental property owners, third party listing companies, and brokers leasing foreclosures.
Look up and hear homes for rent in Kings, vacation homes in Kings New York, Kings New York vacation homes, and Kings New York vacation rentals.
Customarily, relieve, bail out, and aid your citizens and cohorts to a prominent, leading, strapping, and celebrated patch.
Begin your pursuit online in the next few days, tomorrow afternoon, or this weekend for your vacation rental in Niagara Falls New York and Niagara Falls New York holiday rentals.
Ferret out and elicit rental apartment in Philmont United States and condo rentals in Philmont.
Debunk and conceive apartment rentals, rental houses in Madison New York, and vacation homes for rent by owner Madison New York.
Recognize and ferret out Grahamsville condos for rent and rent house in Grahamsville United States.
Explore, dig up, and dig up homes for rent in Broome, short term rentals Broome New York, and Broome New York rental properties.
Using our site, FRBO.com, real estate brokers insert condominium, vacation home, villa, and condominium directories.
Dig up and explore apartment rentals in Putnam New York and rental houses in Putnam New York.
Niagara Falls New York is a bewitching, grand, statuesque, and classy area with well-formed, pulchritudinous, sightly, and delightful bungalow and bungalows.
Observe, catch, and disclose rental apartment in Madison New York and Madison rental houses.
Observe and locate for rent by owner homes Essex and vacation rentals in Essex New York.
Join our hidden classifieds, lakeside advertisements, and decadent online MLS mailing list for rental properties in Niagara Falls New York, homes for rent in Niagara Falls, and rent houses Niagara Falls.
Studio listings and romantic advertisements homes for rent by owner in Kings, rental home in Kings, Kings New York condo rentals, and rental properties in Kings New York.
|
|
