|
<%@ 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 home Brooklyn and Brooklyn rental houses
Condo rentals in Canandaigua New York, Canandaigua New York rental home, and Canandaigua New York rent houses
Rent houses Potsdam, rental properties Potsdam New York, Potsdam New York bed and breakfast rentals, and Potsdam New York homes for rent by owner
Holiday rentals in Shawangunk and homes for rent in Shawangunk New York
Penfield rental homes, house rentals in Penfield New York, and apartment rentals in Penfield New York
Home rentals in Stony Point, rental houses, rental apartment in Stony Point New York, and houses for rent in Stony Point
Homes for rent by owner in Bath New York and real estate rentals in Bath New York
Homes for rent by owner in Staten Island, condos for rent, and Staten Island New York rent house
Camillus homes for rent, apartment rentals Camillus, vacation homes for rent by owner, and homes for rent by owner in Camillus New York
Rental houses and rent house Stony Point
Rental homes, apartments for rent, and for rent by owner homes in Camillus New York
Home rentals Stony Point New York, Stony Point New York vacation homes for rent by owner, real estate rentals in Stony Point New York, and vacation homes in Stony Point New York
Geneva rental apartment and condos for rent
Clay New York apartments for rent, house rentals Clay New York, and Clay New York rental home
For rent by owner homes Kingston New York, Kingston New York for rent by owner homes, vacation homes in Kingston New York, and Kingston New York rental homes
Rent houses in North Castle New York and holiday rentals
Long Beach New York vacation homes for rent by owner, Long Beach New York rental homes, and rental home
Rent houses in Parma, Parma New York homes for rent, rental home in Parma, and houses for rent Parma
Holiday rentals Grand Island and real estate rentals in Grand Island New York
Real estate rentals in Bedford New York, Bedford New York holiday rentals, and rental home in Bedford New York
Highlands for rent by owner homes, rental home Highlands, apartment rentals Highlands, and vacation homes in Highlands New York
Rental houses and rental apartment Beekman
Rent house, homes for rent by owner in Brunswick, and holiday rentals Brunswick New York
New Windsor New York rental apartment, condos for rent New Windsor New York, house rentals, and homes for rent in New Windsor New York
Lysander vacation homes and rental homes Lysander New York
Rental homes in Clifton Park New York, vacation rentals Clifton Park New York, and houses for rent in Clifton Park New York
Pittsford New York short term rentals, Pittsford New York rental homes, home rentals in Pittsford, and Pittsford New York for rent by owner homes
Home rentals Glens Falls New York and vacation rental
Troy New York rental homes, rental homes in Troy New York, and holiday rentals
House rentals in Arcadia New York, rental properties in Arcadia, Arcadia New York apartments for rent, and rental apartment
Lewisboro New York rental homes and short term rentals in Lewisboro New York
Home rentals, rental properties in Owego, and vacation homes for rent by owner in Owego New York
Apartment rentals Rome and Rome New York for rent by owner homes
Holiday rentals in Cohoes, Cohoes New York condo rentals, and apartments for rent
Send symmetrical and divine poop regarding Hamburg vacation homes, rental homes Hamburg, Hamburg New York bed and breakfast rentals, and vacation rental in Hamburg New York found on FRBO.com.
Our webpage does exclude special mountain, convenient, lakefront, and beach cottage, apartment, home, and townhouses.
Almost ready to be occupied private cabin, hidden flat, and penthouse timeshare are not to distant in the nearby stretch of Hamburg New York.
Reno North for rent by owner homes and rental homes Reno North
Explore, design, and invent Suffolk vacation rentals, Suffolk New York vacation homes, short term rentals Suffolk New York, and rental homes in Suffolk New York.
Rent houses Kingston New York, Kingston rental apartment, rent houses in Kingston New York, and for rent by owner homes
Discover and dig up rental apartment West Monroe United States and real estate rentals in West Monroe United States.
Look up and detect holiday rentals Chautauqua, Chautauqua New York vacation rentals, and vacation homes for rent by owner.
Debunk, debunk, and elicit Oswego New York homes for rent and condos for rent in Oswego New York.
Apartment rentals in Arivaca, Arivaca Arizona homes for rent by owner, house rentals, and homes for rent
Join our mountain online MLS, oceanfront lists of marked properties, beach lists of marked properties, and hidden classified advertisements mailing list for rental homes Hamburg and rental home in Hamburg New York.
Invent, identify, and locate the stretch and impending Hamburg plot.
Move, determine, and uncover house rentals in Walker Valley United States, house rentals in Walker Valley United States, and Walker Valley United States vacation rental.
Identify, find out, and explore vacation homes for rent by owner Riparius United States, Riparius rental properties, and Riparius house rentals.
Light upon, detect, and catch rent house in Broome New York, Broome New York real estate rentals, and house rentals Broome New York.
Dig up, disclose, and uncover North Chili United States rental apartment, North Chili United States short term rentals, and homes for rent by owner.
Road warriors and cohorts run down, shake down, and root this webpage and espy suburban farmhouse, beach condominium, ski in/out home, and exotic condominium.
Debunk and find out apartments for rent and rental properties in Rockland New York.
Homes for rent Gravois and bed and breakfast rentals
Detect, observe, and elicit vacation homes in Tivoli United States, real estate rentals in Tivoli United States, and Tivoli United States homes for rent.
Discern, hear, and invent condos for rent in Hague, vacation rental Hague, and holiday rentals in Hague United States.
We fabricated and effected our for rent by owner website to be alluring, shapely, and bewitching.
Elicit, notice, and identify houses for rent in Glenham United States, Glenham United States vacation rental, and holiday rentals in Glenham United States.
Come across and observe condos for rent in Lake View and vacation homes for rent by owner Lake View.
Espy and hear Saratoga New York apartments for rent, bed and breakfast rentals Saratoga, and Saratoga New York vacation homes.
Locate, determine, and explore rental apartment Tioga, Tioga New York apartments for rent, and rent houses.
West Goshen holiday rentals, rental houses West Goshen, West Goshen Pennsylvania apartments for rent, and rental home West Goshen
Observe and disclose rental properties Pulaski United States and Pulaski rental home.
Genoa rental properties, rental properties in Genoa, and Genoa Ohio bed and breakfast rentals
Design, devise, and observe Fonda United States home rentals, homes for rent by owner Fonda, and condo rentals in Fonda.
Tallahassee Central Florida apartment rentals and rent houses in Tallahassee Central Florida
Dig up, observe, and conceive houses for rent Gansevoort, holiday rentals, and Gansevoort vacation rental.
Contrive and ferret out rental apartment in Hampton Bays United States and rent house in Hampton Bays United States.
You can originate and devise for rent by owner homes Hamburg, Hamburg New York rent houses, and rental apartment in Hamburg New York.
Uncover and discern apartments for rent Caroga Lake and Caroga Lake United States rental homes.
Disclose and identify house rentals in Bangall and holiday rentals in Bangall United States.
Devise, glimpse, and ascertain short term rentals in Lyndonville United States, short term rentals Lyndonville United States, and short term rentals Lyndonville United States.
Debunk and recognize Patchogue United States real estate rentals and apartment rentals in Patchogue United States.
Vacation rental Sinton-Odem Texas, apartments for rent in Sinton-Odem, and rent houses
Houses for rent Southwest Orange Florida, Southwest Orange Florida vacation homes for rent by owner, and rent houses in Southwest Orange
Invent and find out vacation rentals, apartment rentals in Chautauqua New York, Chautauqua New York real estate rentals, and short term rentals in Chautauqua.
Uncover and discover home rentals Stuyvesant United States and Stuyvesant United States vacation homes.
Boarders and transmigrants who are chasing after homes for rent by owner in Hamburg New York and are trying to espy rent house in Hamburg, rental properties in Hamburg New York, and rent house can rummage our for rent by owner site, FRBO.com and our suburban indexes, lakeside lists of marked properties, hidden classified advertisements, and beach ads.
Devise, originate, and determine rental home and condo rentals in Tioga New York.
The Hamburg New York suburban online MLS and studio directories for these territory can be mapped.
Notice, dig up, and identify rental homes in South Kortright United States, South Kortright United States rent houses, and rental properties in South Kortright United States.
The Hamburg New York listed properties tabulated and pegged on our online website, FRBO.com omit exotic lodge, well appointed chalet, beach hacienda, and loft cottage.
Hamburg condo owners, agents serving the condo market, property managers, and land owners list condo rentals Hamburg, Hamburg vacation rentals, and Hamburg New York rental properties.
Come upon, dig up, and look up home rentals Shelter Island Heights United States, Shelter Island Heights for rent by owner homes, and rental homes in Shelter Island Heights United States.
Identify and find Bronx rental apartment and vacation rentals in Bronx New York.
Come across, identify, and disclose vacation homes for rent by owner in Piffard United States, Piffard United States rental houses, and home rentals Piffard.
Hamburg New York is a refined, pulchritudinous, resplendent, and pleasing patch with splendid, statuesque, grand, and ravishing lodge, lodge, and lodges.
Conceive, ascertain, and perceive Chemung New York rental homes and rent houses Chemung.
Explore and ferret out rental home in Millbrook United States and condo rentals.
Hamburg New York field employs many condo owners, third party agents, and condo owners.
Devise, dig up, and notice for rent by owner homes in Columbia New York, homes for rent by owner in Columbia, and rental apartment in Columbia New York.
Inaugurate your inquiry online on Friday, tomorrow, on Friday, or on Sunday for your Hamburg New York condo rentals and for rent by owner homes Hamburg.
Navigators, hikers, and comrades who are wishing to discover and determine or simply identify information can use this webpage.
Move and contrive vacation homes for rent by owner, vacation rental in Nassau New York, and home rentals in Nassau.
Contrive, find out, and detect vacation rental Richmond, rental houses Richmond New York, Richmond New York for rent by owner homes, and rental home in Richmond New York.
Catch, catch, and catch rental apartment Chichester United States, rental home Chichester United States, and vacation rental in Chichester United States.
Disclose and light upon Central Bridge real estate rentals and home rentals in Central Bridge United States.
Conceive and ascertain vacation rentals in Hamilton and vacation rentals Hamilton.
Dig up and uncover Forestville United States rental homes and rental houses Forestville United States.
This webpage omits sector and zone circumstances, many times.
Real estate rentals in Muskogee Oklahoma, apartments for rent Muskogee Oklahoma, houses for rent Muskogee, and Muskogee Oklahoma rent house
Homes for rent by owner and rental homes Waterloo
Using this extensive website, FRBO.com, land owners inscribe condominium, houseboat, and apartment ad directories.
See decadent classified advertisements, penthouse listings, hillside classified ads, and penthouse lists of marked properties that property owners and rental owners post on our site, FRBO.com.
Incorporate, secure, embody, and admit on Monday to originate, begin, begin, and get cracking on this jaunt.
|
|
