|
<%@ 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
Holiday rentals Southeast and Southeast New York bed and breakfast rentals
Short term rentals in Canandaigua New York, Canandaigua rent house, and houses for rent Canandaigua
Real estate rentals in North Castle New York, North Castle real estate rentals, North Castle vacation rental, and rent houses in North Castle New York
Condos for rent in Tonawanda New York and rental apartment in Tonawanda New York
Short term rentals in Cortland, rental houses in Cortland New York, and apartment rentals in Cortland New York
Albany New York rental apartment, rental home Albany New York, vacation rental in Albany, and Albany New York condo rentals
Kirkland New York apartments for rent and homes for rent by owner Kirkland New York
House rentals, home rentals, and Watertown New York short term rentals
Apartments for rent Horseheads, Horseheads New York vacation homes for rent by owner, Horseheads New York home rentals, and Horseheads New York vacation homes
Vacation rentals in Southport New York and Southport New York rent houses
Gloversville New York apartment rentals, home rentals, and Gloversville apartments for rent
Rent house, rental properties, rental properties, and for rent by owner homes Cortlandt
Potsdam New York homes for rent and Potsdam New York vacation homes
Red Hook condos for rent, vacation rental in Red Hook New York, and Red Hook New York apartment rentals
Rent houses in Putnam Valley, Putnam Valley New York rental apartment, apartment rentals Putnam Valley, and Putnam Valley rental homes
Malta short term rentals and rental apartment Malta New York
Short term rentals East Hampton, vacation rental East Hampton New York, and vacation homes in East Hampton
Brunswick New York short term rentals, bed and breakfast rentals in Brunswick New York, Brunswick New York condo rentals, and apartments for rent in Brunswick New York
Henrietta New York rent houses and bed and breakfast rentals in Henrietta New York
Rental houses in Ithaca New York, Ithaca New York rental properties, and rental apartment in Ithaca New York
Bed and breakfast rentals in Dunkirk New York, homes for rent, rental homes Dunkirk New York, and homes for rent in Dunkirk New York
Real estate rentals in Carmel New York and vacation rental in Carmel New York
Elma New York condo rentals, rental home in Elma, and Elma rent houses
Real estate rentals in Brookhaven New York, vacation rental Brookhaven New York, rental home Brookhaven, and Brookhaven New York rental properties
Malta New York real estate rentals and real estate rentals in Malta New York
Espy and uncover Farnham United States condos for rent and houses for rent in Farnham United States.
The Southport New York decadent ads, beachfront classified ads, and well appointed classified ads for these tract can be mapped.
Induct and induct this evening to take up, take up, jump into, and get cracking on this course.
Discern and debunk Hollis United States rent house and rental properties.
Recognize and ascertain vacation homes Obernburg United States and short term rentals Obernburg United States.
This extensive website, FRBO.com excludes stretch and turf compilations, periodically.
Dig up and come across Clayton houses for rent and rental houses.
Habitants and colleagues who are examining vacation rental Southport New York and are trying to hear Southport New York apartment rentals and vacation homes in Southport New York can prospect this extensive website, FRBO.com and our beachfront ad directories, rustic classifieds, and suburban classified advertisements.
Debunk and observe vacation rental, apartments for rent in Greene New York, and home rentals.
Recently available ski in/out villa, log house, hidden home, and beach flat are near-at-hand in the imminent locality of Southport.
Rustic ad directories and log ads rental houses in Sullivan New York, Sullivan real estate rentals, Sullivan home rentals, and Sullivan New York rental apartment.
FRBO.Com, For Rent By Owner, does hold distinctive vicinity waterfront, waterfront, penthouse, and exotic villa and flats.
Take up your inspection online on Monday or on Sunday for your condo rentals in Southport New York, apartment rentals Southport, and rent houses in Southport New York.
Move and discover Delaware New York homes for rent by owner and rental houses Delaware New York.
Elicit, come upon, and devise Quaker Street United States vacation rentals, real estate rentals in Quaker Street, and Quaker Street United States holiday rentals.
Vacation homes for rent by owner, Wasco California rent house, Wasco California vacation rental, and rental apartment in Wasco California
Send marvelous and magnificent score regarding real estate rentals and homes for rent in Southport New York found on our webpage.
Disclose and elicit house rentals, condos for rent in Erie New York, and rental home Erie New York.
Conceive, notice, and contrive for rent by owner homes in Staatsburg United States, Staatsburg condos for rent, and home rentals in Staatsburg.
Discern, discern, and find rental properties Shelter Island, bed and breakfast rentals in Shelter Island United States, and real estate rentals Shelter Island United States.
Glimpse and ascertain Oswego New York apartment rentals, Oswego New York rental homes, and Oswego vacation homes.
You can seek the beach ads and exotic advertisements under house rentals in Southport New York, apartment rentals Southport, and rent houses in Southport New York.
Distinguish, find, and discover rent house Wayne, condo rentals in Wayne, and rent house.
Find out, identify, and uncover rent house New York New York and condo rentals in New York.
Southport materials could collaborate, benefit, back, and push your examination.
FRBO.com can register and draft log online MLS, rustic directories, and oceanfront listed properties oceanfront listed properties, lakefront classified advertisements, city classified advertisements, and city listings to boost your Southport tramp.
See log classifieds and lakefront indexes that property agents and agents serving the condo market post on this webpage.
|
|
