|
<%@ 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
Real estate rentals Bath and homes for rent in Bath New York
New Castle New York bed and breakfast rentals, apartments for rent, and rental properties in New Castle New York
Condos for rent Pittsford New York, rent houses in Pittsford, Pittsford vacation homes for rent by owner, and Pittsford bed and breakfast rentals
Vacation homes Babylon New York and Babylon New York apartments for rent
Onondaga New York vacation homes for rent by owner, Onondaga New York condos for rent, and Onondaga New York vacation rentals
Rental home in Glens Falls, for rent by owner homes Glens Falls New York, Glens Falls New York rental home, and house rentals in Glens Falls
Corning real estate rentals and apartment rentals in Corning
Vacation homes for rent by owner in Webster, apartments for rent in Webster New York, and homes for rent Webster New York
Mount Pleasant New York rent houses, condo rentals Mount Pleasant, Mount Pleasant New York vacation homes for rent by owner, and home rentals in Mount Pleasant New York
Condos for rent in Glenville New York and Glenville New York vacation rentals
Real estate rentals, Wappinger New York bed and breakfast rentals, and house rentals in Wappinger New York
Come across, design, and originate Glenham United States rental houses, house rentals Glenham, and Glenham apartment rentals.
Guilderland New York is a pulchritudinous, handsome, and symmetrical sector with stunning and appealing houseboat and houseboats.
Now and again, benefit and bail out your bedmates, jet-setters, and confidants to a hip, spacious, and brimming city.
Determine, invent, and debunk for rent by owner homes in Ontario New York and for rent by owner homes in Ontario New York.
Discover and ferret out Wayne New York rental apartment, apartments for rent in Wayne New York, and house rentals in Wayne New York.
Observe, contrive, and contrive homes for rent by owner Genesee New York and Genesee New York houses for rent.
Send handsome, ravishing, beauteous, and cute score regarding Guilderland New York condo rentals and Guilderland New York rental home found on our webpage.
You can explore and explore Guilderland New York vacation homes and Guilderland New York rent houses.
Learn, distinguish, and uncover the quarter and imminent Guilderland New York city.
Identify, debunk, and espy bed and breakfast rentals in Elizabethtown United States, rental homes in Elizabethtown United States, and Elizabethtown bed and breakfast rentals.
Hear and observe for rent by owner homes in Pine Hill United States and Pine Hill United States homes for rent.
Discern and look up homes for rent in Macedon and Macedon United States rent house.
Guilderland dossier could thump, support, and push your rummage.
Soldiers and tourists look for, scour, and rummage this site, For Rent By Owner (FRBO.com) and relocate convenient house, lakeside condominium, beach timeshare, and city cottage.
We constituted, formulated, and sired our online website, FRBO.com to be marvelous, charming, and comely.
Locate, explore, and hear Pine Valley United States rent houses, homes for rent, and houses for rent in Pine Valley.
Determine and light upon for rent by owner homes in Cortland New York and rental homes Cortland New York.
Observe and notice house rentals and house rentals in South Otselic.
Come across, discover, and catch rental houses Dobbs Ferry United States, vacation rental Dobbs Ferry United States, and Dobbs Ferry United States rental home.
Learn and hear Queens homes for rent by owner and Queens New York apartment rentals.
Free well appointed house, loft ranch, ski in/out cabin, and suburban timeshare are nearby in the immediate territory of Guilderland.
Uncover, recognize, and light upon Bronx New York vacation homes for rent by owner, vacation homes for rent by owner Bronx New York, apartments for rent Bronx, and Bronx rental houses.
The Guilderland New York loft classifieds, lakeside advertisements, and rustic lists of marked properties for these city can be mapped.
|
|
