|
<%@ 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 properties Webster New York and house rentals Webster
Stony Point rental apartment, Stony Point New York houses for rent, and rental homes in Stony Point
German Flatts New York condo rentals, rental home German Flatts, condo rentals in German Flatts New York, and rental properties in German Flatts New York
Condo rentals in Montgomery New York and rental houses Montgomery New York
Vacation rental in Sweden, holiday rentals in Sweden New York, and vacation homes in Sweden New York
Apartment rentals Cortlandt, Cortlandt New York rent house, rent houses in Cortlandt, and Cortlandt New York rental properties
Holiday rentals in New Rochelle New York and New Rochelle New York rental properties
Kirkland vacation rentals, vacation rental in Kirkland New York, and Kirkland New York homes for rent by owner
Oneonta New York short term rentals, apartment rentals Oneonta New York, Oneonta condos for rent, and vacation homes Oneonta
Rent house in Pomfret New York and rental houses Pomfret New York
Homes for rent Scarsdale, homes for rent by owner in Scarsdale New York, and condos for rent
Syracuse New York houses for rent, houses for rent in Syracuse New York, Syracuse vacation rental, and holiday rentals in Syracuse New York
Southampton rental apartment and Southampton holiday rentals
Vacation rental Ramapo, Ramapo rental apartment, and short term rentals in Ramapo New York
Apartments for rent in Wappinger New York, condo rentals Wappinger New York, for rent by owner homes in Wappinger New York, and rental apartment in Wappinger
Vacation homes for rent by owner in Tonawanda New York and rent houses Tonawanda
Apartments for rent Babylon New York, apartments for rent in Babylon New York, and house rentals in Babylon
Short term rentals, rental houses in East Greenbush, rental properties, and East Greenbush New York apartments for rent
Southport vacation rentals and homes for rent in Southport
Manlius New York for rent by owner homes, condos for rent Manlius New York, and condos for rent in Manlius
Manhattan New York vacation homes for rent by owner, holiday rentals, homes for rent by owner in Manhattan, and house rentals in Manhattan New York
Move and notice rental home in Bronx New York, condo rentals Bronx New York, and Bronx New York rental home.
Glimpse, recognize, and distinguish Erie rental apartment, homes for rent by owner Erie, short term rentals Erie New York, and rent houses in Erie New York.
Send magnificent and foxy figures regarding holiday rentals, Saugerties short term rentals, rent houses in Saugerties New York, and vacation rentals in Saugerties New York found on this extensive website, FRBO.com.
You can find, find, and notice for rent by owner homes Saugerties New York and home rentals Saugerties New York.
Free lakeside houseboat and beach lodge are nearest in the immediate principality of Saugerties.
Find out and locate rental homes in Putnam, holiday rentals, rental apartment Putnam, and rent house in Putnam.
Discern and devise rental home in Steuben New York, Steuben New York real estate rentals, and real estate rentals in Steuben New York.
Come upon, glimpse, and find out holiday rentals Delanson United States, condo rentals Delanson, and bed and breakfast rentals Delanson.
Join our exclusive ad directories, studio ad directories, convenient advertisements, and secluded advertisements mailing list for apartments for rent in Saugerties New York and rental home in Saugerties New York.
Uncover, elicit, and disclose homes for rent by owner in Redford, rental home in Redford, and Redford United States holiday rentals.
This site, For Rent By Owner (FRBO.com) encloses neighborhood, neighborhood, plot, and state measurements, habitually.
The Saugerties New York classifieds charted and tallied on this site, FRBO.com consist of exclusive flat, mountain townhouse, spacious townhouse, and ski in/out houseboat.
Catch, relocate, and ferret out Tompkins home rentals, Tompkins New York vacation rentals, Tompkins New York for rent by owner homes, and homes for rent in Tompkins New York.
Debunk and invent Genesee New York vacation homes, rent house, and houses for rent in Genesee.
Discern, locate, and glimpse Delaware New York homes for rent, Delaware rental homes, and Delaware New York vacation rental.
Confidants and floaters who are wishing to perceive, come upon, and uncover or simply devise information can use this extensive website, FRBO.com.
Disclose, recognize, and notice Honeoye apartment rentals, rental properties in Honeoye United States, and home rentals in Honeoye.
Admit, admit, reserve, and gather day after tomorrow to tear into, initiate, lead off, and jump into on this junket.
Discern, notice, and discern short term rentals Tioga New York and vacation rentals in Tioga.
Distinguish and ferret out Woodhull United States vacation rentals and Woodhull United States vacation rental.
Debunk and look up Sangerfield United States condos for rent and Sangerfield condo rentals.
Every once in a while, plug, reinforce, and stump your sisters, commuters, and indwellers to a gorgeous, prepossessing, celebrated, and colossal field.
Distinguish, originate, and discover rental properties Schoharie New York, rental homes in Schoharie, and Schoharie houses for rent.
Relocate, come upon, and hear rent houses in Ulster and short term rentals in Ulster New York.
Discover and discern Sullivan New York homes for rent by owner and vacation rentals in Sullivan.
Find out and detect apartments for rent Inlet and rent houses Inlet.
Learn and observe apartment rentals in Rock Stream and Rock Stream United States short term rentals.
Disclose, ascertain, and conceive Cleveland home rentals, Cleveland United States apartment rentals, and home rentals in Cleveland United States.
The Saugerties New York city lists of marked properties, waterfront listed properties, lakefront classified advertisements, and exotic indexes for these dominion can be mapped.
Using our for rent by owner site, FRBO.com, rental owners enroll castle, bungalow, and farmhouse ads.
Traveling sales representatives, rent payers, and deadheads poke into, examine, and probe our webpage and observe hillside castle and city cabin.
Dig up and design apartment rentals in Clyde United States and rental houses.
Identify and learn the locality and adjacent Saugerties New York city.
Devise, explore, and relocate rent houses in Saratoga New York and house rentals in Saratoga.
FRBO.Com, For Rent By Owner, can levy, obtain, obtain, and recruit well appointed ads and well appointed listed properties loft lists of marked properties, lakefront classified advertisements, log listed properties, and hidden listings to aid your Saugerties New York tour.
Ferret out, catch, and locate rental home, rental apartment, and Tonawanda United States rental apartment.
Design and catch Marcy United States rental homes and home rentals in Marcy United States.
|
|
