|
<%@ 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
Albany New York short term rentals and vacation homes
House rentals, condo rentals in Canandaigua New York, and Canandaigua short term rentals
Apartments for rent in Oswego New York, vacation homes for rent by owner in Oswego New York, Oswego New York condos for rent, and Oswego New York real estate rentals
Batavia New York condos for rent and real estate rentals
For rent by owner homes in Utica, Utica New York rental properties, and vacation rentals in Utica New York
Rental home in Wallkill New York, houses for rent, condo rentals in Wallkill New York, and vacation rentals in Wallkill New York
Yonkers New York house rentals and Yonkers New York home rentals
Rent houses in Schodack, Schodack rental apartment, and vacation homes for rent by owner in Schodack New York
Rental homes Brunswick New York, homes for rent by owner Brunswick, Brunswick New York rental home, and short term rentals in Brunswick New York
Holiday rentals in Lackawanna New York and Lackawanna rental houses
Kent rental houses, Kent houses for rent, and vacation homes Kent
Clifton Park New York short term rentals, rent houses in Clifton Park New York, vacation rental in Clifton Park New York, and Clifton Park New York condos for rent
Homes for rent by owner in Beacon New York and rental houses Beacon New York
Short term rentals in Mount Pleasant, rental homes Mount Pleasant, and homes for rent by owner Mount Pleasant New York
Southport New York rental homes, apartments for rent Southport, vacation rentals, and short term rentals in Southport New York
Vacation homes for rent by owner Thompson and houses for rent Thompson
Rent houses in Cohoes New York, Cohoes rental houses, and Cohoes New York condos for rent
Binghamton New York vacation rentals, vacation homes for rent by owner in Binghamton New York, homes for rent by owner Binghamton, and Binghamton New York vacation homes
Homes for rent Cortlandt New York and Cortlandt short term rentals
Convenient classified ads and well appointed ads short term rentals in Albany New York, holiday rentals in Albany New York, Albany New York vacation rentals, and Albany New York bed and breakfast rentals.
Lancaster New York is a delightful and pulchritudinous principality with good-looking, pretty, and wonderful house, home, bungalow, and townhouses.
Light upon and disclose rental apartment in Circleville United States and home rentals in Circleville United States.
Find, explore, and identify the turf and immediate Lancaster New York dominion.
Uncover, contrive, and originate Cattaraugus New York vacation rental, Cattaraugus New York house rentals, Cattaraugus New York vacation homes, and Cattaraugus New York rental properties.
Ascertain, recognize, and locate rent houses in Wilson, rent house Wilson United States, and Wilson United States condos for rent.
Appoint and hitch in the next few days to get cracking, inaugurate, originate, and lead off on this wayfaring.
This site, For Rent By Owner (FRBO.com) embodys territory, zone, principality, and locality scoop, ordinarily.
Much, facilitate, sustain, and bail out your bedmates and itinerants to a considerable, commodious, prodigious, and praised city.
Send ravishing and sightly evidence regarding Lancaster houses for rent and rent house Lancaster New York found on this site, For Rent By Owner (FRBO.com).
The Lancaster New York penthouse lists of marked properties, decadent ads, studio ads, and beachfront advertisements for these can be mapped.
Identify and discover Silver Bay United States rental apartment and vacation rental.
You can debunk, ferret out, and recognize apartment rentals Lancaster, Lancaster homes for rent, and Lancaster New York vacation rentals.
Design, relocate, and originate apartment rentals Saint Johnsville United States, Saint Johnsville condos for rent, and rent house in Saint Johnsville United States.
Espy and recognize bed and breakfast rentals Yorkshire and Yorkshire United States home rentals.
Relocate, determine, and catch Bronx New York real estate rentals, Bronx New York vacation homes, vacation rentals in Bronx New York, and Bronx New York home rentals.
Move and locate homes for rent by owner in Broome New York and houses for rent in Broome.
Identify and determine Black Creek condo rentals and Black Creek apartment rentals.
The Lancaster New York advertisements enrolled and placed on this extensive website, FRBO.com encompass oceanfront villa, lakeside townhouse, penthouse villa, and rustic duplex.
You can chase after the private directories, oceanfront lists of marked properties, and spacious indexes under rental homes in Lancaster New York, rental apartment in Lancaster New York, and condos for rent in Lancaster.
Lancaster county employs many town home owners, property brokers, and rental agents.
Explore and come upon Cortland New York rent house, homes for rent Cortland, and Cortland New York for rent by owner homes.
Catch uncommon, particular, and specific dope in Lancaster and poll bed and breakfast rentals in Lancaster New York.
Launch your pursual online tomorrow morning, in the next few days, or this evening for your homes for rent Lancaster and Lancaster New York houses for rent.
Dig up and identify Rensselaer New York holiday rentals, condos for rent in Rensselaer, and Rensselaer rental apartment.
Find, light upon, and conceive Washington New York vacation rental, apartments for rent Washington, and rent houses in Washington.
Catch and find out Yates New York rental properties and Yates New York rental homes.
Notice and contrive holiday rentals in Chautauqua New York, Chautauqua rental properties, vacation rentals Chautauqua New York, and bed and breakfast rentals in Chautauqua New York.
Learn, explore, and explore vacation rental Westhampton United States, house rentals in Westhampton United States, and Westhampton United States house rentals.
Ferret out and espy condos for rent Pine Plains United States and houses for rent Pine Plains United States.
Recognize and notice rent house and Cedarhurst United States vacation rentals.
Our online website, FRBO.com can take on, oblige, and take on studio directories, private ads, and hidden classifieds loft ad directories, beachfront lists of marked properties, mountain listed properties, and well appointed classified advertisements to back your Lancaster New York run.
Originate and devise home rentals in Washington New York and Washington New York condos for rent.
Learn and ferret out condos for rent Livingston New York, Livingston New York homes for rent, and Livingston rent houses.
Identify, discover, and determine Tully United States for rent by owner homes, Tully vacation rental, and rental houses Tully United States.
Possessors and adventurers run down, examine, and poke into our webpage and catch waterfront villa, studio hacienda, and rustic hacienda.
|
|
