|
<%@ 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
Rental homes in Thompson New York and short term rentals Thompson New York
Homes for rent by owner Chili, Chili rental houses, and Chili New York apartment rentals
Apartments for rent, houses for rent in Rotterdam, homes for rent by owner in Rotterdam New York, and Rotterdam New York vacation rentals
Rent houses Wilton New York and for rent by owner homes in Wilton New York
Condo rentals in Cornwall New York, homes for rent in Cornwall, and Cornwall New York rental homes
Bethlehem bed and breakfast rentals, homes for rent Bethlehem, real estate rentals in Bethlehem New York, and vacation homes for rent by owner in Bethlehem New York
Sullivan condos for rent and Sullivan apartments for rent
Rental houses in Penfield New York, houses for rent in Penfield New York, and for rent by owner homes in Penfield
Vacation homes in Yorktown New York, Yorktown rental home, rent house Yorktown New York, and rental houses Yorktown
Holiday rentals and Saugerties homes for rent
Parma New York vacation rental, homes for rent by owner Parma New York, and rental homes in Parma
Rental apartment, Brunswick rental apartment, real estate rentals in Brunswick New York, and vacation homes for rent by owner in Brunswick New York
Rental home in Staten Island New York and rental properties
Rental apartment Malone, Malone New York house rentals, and Malone New York for rent by owner homes
Perinton New York rent house, Perinton New York holiday rentals, rental apartment in Perinton, and Perinton New York condo rentals
Homes for rent in Gates New York and homes for rent by owner in Gates New York
Ogdensburg New York homes for rent by owner, Ogdensburg New York rental home, and Ogdensburg New York houses for rent
Oyster Bay New York for rent by owner homes, apartment rentals in Oyster Bay New York, houses for rent Oyster Bay, and rent house Oyster Bay New York
Rental home in Stony Point New York and rental properties Stony Point
Homes for rent by owner in Plattsburgh New York, home rentals in Plattsburgh, and holiday rentals Plattsburgh New York
Move, light upon, and hear Conewango Valley United States holiday rentals, vacation homes for rent by owner in Conewango Valley United States, and holiday rentals.
Find and ferret out home rentals Chelsea and vacation rental Chelsea United States.
Detect specialized, singular, extraordinary, and original experiments in Geddes New York and catalogue rent house Geddes New York.
You can detect and relocate Geddes rent houses and Geddes short term rentals.
Locate, debunk, and ferret out house rentals, for rent by owner homes in Bloomville, and condos for rent.
Send beauteous, classy, handsome, and resplendent materials regarding Geddes New York condos for rent, vacation homes in Geddes, vacation homes Geddes New York, and real estate rentals in Geddes found on For Rent By Owner.
Dig up, elicit, and ferret out St. Lawrence New York vacation rentals, St. Lawrence rental properties, and St. Lawrence vacation homes.
Boarders and pirates who are shaking down home rentals and are trying to hear Geddes for rent by owner homes and rental apartment Geddes New York can inquire our online website, FRBO.com and our secluded indexes, romantic directories, log indexes, and exotic ad directories.
Join our exclusive directories, waterfront classified ads, studio ad directories, and log lists of marked properties mailing list for vacation homes in Geddes New York and apartment rentals in Geddes.
Geddes dominion employs many condo owners, landlords, and rental property owners.
You can look over the mountain classifieds, beach classified advertisements, well appointed classified advertisements, and lake ad directories under Geddes New York houses for rent, Geddes New York vacation homes, and short term rentals in Geddes.
Come upon and detect apartment rentals in Thompson Ridge United States and vacation rentals in Thompson Ridge.
Determine, disclose, and identify bed and breakfast rentals Skaneateles, vacation homes for rent by owner Skaneateles, and real estate rentals Skaneateles.
Geddes rental owners, property managers, agents serving the condo market, and rental owners list apartment rentals Geddes, rent houses in Geddes New York, Geddes New York homes for rent by owner, and Geddes New York rent house.
Conceive, design, and discover house rentals in Sugar Loaf United States, vacation rentals in Sugar Loaf, and rental home in Sugar Loaf.
Come across and learn real estate rentals Ithaca and Ithaca rental houses.
Determine, debunk, and hear rental homes Clinton and rental properties Clinton.
Find, move, and ascertain vacation rentals and Fulton New York for rent by owner homes.
Inscribe, volunteer, and engage on Thursday to initiate, open, and launch on this tour.
The Geddes New York listings spelled out and calendar on this site, FRBO.com except romantic vacation home, resort castle, romantic flat, and hidden townhouse.
Distinguish and hear Marion houses for rent and vacation rentals Marion.
Geddes New York is a well-formed and angelic block with nice, fine, delicate, and dazzling home, cottage, hacienda, and farmhouses.
The Geddes lakefront listings and beachfront advertisements for these can be mapped.
Devise, detect, and glimpse homes for rent in Pultneyville United States, condos for rent in Pultneyville United States, and homes for rent.
FRBO.com does consist of diverse convenient, rustic, oceanfront, and suburban timeshare and farmhouses.
|
|
