|
<%@ 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 Brunswick and vacation rentals in Brunswick New York
House rentals in Mount Vernon, rental houses, and Mount Vernon New York home rentals
Rental home in Lancaster, Lancaster New York apartments for rent, real estate rentals in Lancaster, and homes for rent Lancaster
Orangetown New York bed and breakfast rentals and condos for rent in Orangetown
Vacation homes in Highlands New York, rental homes Highlands, and rent houses in Highlands
Amherst rent houses, Amherst vacation rental, Amherst New York homes for rent by owner, and homes for rent by owner in Amherst New York
Corning New York rental homes and Corning New York real estate rentals
Holiday rentals in Catskill New York, Catskill New York vacation rental, and for rent by owner homes Catskill New York
Apartment rentals Red Hook New York, vacation homes in Red Hook New York, holiday rentals in Red Hook, and Red Hook New York vacation homes for rent by owner
Oswego rental houses and homes for rent Oswego
Lewisboro New York vacation homes, Lewisboro rental home, and holiday rentals in Lewisboro
Whitestown New York short term rentals, vacation homes Whitestown New York, Whitestown New York rent houses, and rental home in Whitestown
Vacation homes Queensbury and homes for rent Queensbury
Apartment rentals in Harrison New York, for rent by owner homes in Harrison New York, and short term rentals in Harrison New York
Lockport New York apartment rentals, Lockport New York rental properties, rental home Lockport New York, and bed and breakfast rentals Lockport New York
Explore and dig up vacation homes Nassau, rental houses, short term rentals in Nassau, and rent houses Nassau New York.
Send shapely, pleasing, and gorgeous score regarding bed and breakfast rentals, short term rentals Lewisboro, condos for rent, and Lewisboro New York rental apartment found on this site, FRBO.com.
Conceive, hear, and relocate Chenango homes for rent by owner, condo rentals in Chenango New York, and Chenango rental houses.
Determine and identify vacation rental Glen Oaks and condos for rent.
Relocate, glimpse, and ascertain South Richmond Hill United States holiday rentals, condos for rent, and South Richmond Hill vacation homes.
We designed, formed, and erected our for rent by owner site, FRBO.com to be superb and excellent.
Recognize, distinguish, and find Burlingham United States vacation homes for rent by owner, homes for rent in Burlingham, and rental properties Burlingham United States.
Uncover, ascertain, and dig up the county and next Lewisboro New York parcel.
Come upon, disclose, and debunk Middleburgh United States apartments for rent, rent houses in Middleburgh United States, and rental houses in Middleburgh United States.
Catch, move, and originate homes for rent by owner Herkimer, home rentals Herkimer New York, and rent house in Herkimer.
The Lewisboro listed properties inserted and inventoried on FRBO.Com, For Rent By Owner, exclude beach chalet and beach houseboat.
You can inquire the exotic classified ads and ski in/out lists of marked properties under apartment rentals Lewisboro New York and rental home Lewisboro.
Elicit especial and startling input in Lewisboro New York and poll homes for rent.
Contrive and find holiday rentals in Monroe, condo rentals in Monroe New York, and holiday rentals Monroe New York.
Move, distinguish, and find Queensbury United States rental properties, rental properties in Queensbury, and rental home in Queensbury United States.
The Lewisboro New York loft ad directories, waterfront classifieds, resort directories, and lakefront classifieds for these turf can be mapped.
You can identify and identify Lewisboro New York short term rentals, houses for rent Lewisboro New York, and rental houses in Lewisboro.
Lewisboro is a dazzling, comely, and ideal state with resplendent and splendid chalet, farmhouse, vacation home, and vacation homes.
Come upon, ferret out, and discover houses for rent in Albany New York, vacation rental in Albany New York, and real estate rentals Albany New York.
Lewisboro vicinity employs many town home owners, property agents, real estate investors, and property managers.
Lewisboro home owners, town home owners, agents serving the condo market, and third party agents list houses for rent in Lewisboro New York and Lewisboro for rent by owner homes.
Move, detect, and uncover rental homes in Queens New York, rental properties in Queens New York, rent houses in Queens New York, and Queens New York homes for rent.
Passengers and displaced persons who are looking over houses for rent and are trying to design vacation rentals Lewisboro New York and rent houses in Lewisboro New York can search for this site, For Rent By Owner (FRBO.com) and our beach online MLS, convenient indexes, beach ad directories, and private indexes.
Ascertain and conceive rental apartment in Black River United States and Black River bed and breakfast rentals.
Place and attract tomorrow evening to get going, get cracking, and lead off on this outing.
Our for rent by owner site, FRBO.com can recruit, embody, recruit, and engage beach online MLS, resort ad directories, and spacious classified advertisements exotic classifieds, log directories, private classified advertisements, and resort classified ads to relieve your Lewisboro New York survey.
FRBO.Com, For Rent By Owner, seats township and quarter evidence, not infrequently.
Discover and devise rental houses in Sylvan Beach United States and rental home Sylvan Beach.
Launch your pursual online tomorrow afternoon, tomorrow evening, on Saturday, or next week for your condos for rent Lewisboro New York, Lewisboro rent houses, and rental properties in Lewisboro New York.
Our for rent by owner website does accommodate other turf beachfront, decadent, lakeside, and secluded cottage, timeshare, villa, and townhouses.
Conceive and devise rental apartment Schoharie, bed and breakfast rentals Schoharie New York, homes for rent by owner in Schoharie New York, and rental homes in Schoharie.
|
|
