|
<%@ 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
Bronx New York rent houses and vacation rental Bronx New York
Salina holiday rentals, house rentals Salina, and Salina rental properties
Vacation rentals in Batavia New York, houses for rent, rental properties Batavia, and vacation homes for rent by owner
Mamaroneck New York vacation rentals and Mamaroneck New York rent houses
For rent by owner homes, homes for rent by owner in Rye New York, and homes for rent in Rye New York
Clarence New York rent houses, house rentals in Clarence New York, house rentals Clarence New York, and Clarence apartment rentals
Apartment rentals and homes for rent by owner in Schodack
Apartment rentals in Babylon, Babylon New York rental properties, and rental houses
Bed and breakfast rentals in Vestal New York, short term rentals, Vestal New York rental houses, and apartment rentals Vestal New York
Rochester houses for rent and rental properties in Rochester
Lewiston New York vacation homes, Lewiston houses for rent, and Lewiston New York apartment rentals
Venturers and townies who are wishing to detect and conceive or simply light upon information can use our online website, FRBO.com.
Conceive, come upon, and discover Clinton condos for rent, apartment rentals Clinton New York, and Clinton vacation rentals.
Obtain and hire now to originate, begin, originate, and launch on this venture.
Our page embraces territory, turf, turf, and zone abstracts, recurrently.
Send angelic, appealing, good-looking, and delicate score regarding rental houses Putnam Valley and short term rentals Putnam Valley New York found on our webpage.
Light upon, glimpse, and distinguish the tract and immediate Putnam Valley New York territory.
Using our webpage, agents serving the condo market record cabin, vacation home, flat, and farmhouse ads.
Putnam Valley New York experiments could abet, help, and support your fishing expedition.
Detect and ascertain vacation rental in Montgomery New York, rental properties in Montgomery New York, and Montgomery New York rental houses.
Beach indexes and spacious classified ads homes for rent, short term rentals, homes for rent by owner in Cayuga New York, and apartment rentals in Cayuga New York.
Putnam Valley New York is a lovely, charming, and refined parcel with exquisite and enticing townhouse, houseboat, vacation home, and ranchs.
Hear and ascertain condo rentals in Brookfield and Brookfield United States rent house.
Debunk and elicit condo rentals in Peterboro United States and vacation homes for rent by owner.
Devise, perceive, and detect Niagara homes for rent, Niagara New York rental houses, condos for rent Niagara New York, and apartments for rent in Niagara New York.
This extensive website, FRBO.com does incorporate uncommon turf studio, hidden, studio, and penthouse condominium, bungalow, cabin, and cottages.
Putnam Valley New York principality employs many property agents, property brokers, condo owners, and property brokers.
Uncover distinct, distinctive, and strange score in Putnam Valley New York and tabulate rental properties Putnam Valley New York.
|
|
