|
<%@ 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
For rent by owner homes Greece New York and Greece rent houses
Chili rental properties, Chili New York houses for rent, and holiday rentals in Chili New York
Alden rental home, vacation homes Alden New York, condo rentals in Alden, and Alden New York real estate rentals
Perinton New York apartment rentals and holiday rentals in Perinton
Rental homes Hamburg New York, real estate rentals in Hamburg New York, and vacation homes in Hamburg New York
Rental home in Rome New York, rental apartment in Rome, condo rentals in Rome, and apartment rentals in Rome New York
Rental houses Dunkirk and Dunkirk home rentals
Rent houses in La Grange New York, apartments for rent in La Grange, and rental home La Grange
Short term rentals Cheektowaga, Cheektowaga New York rent house, homes for rent, and rental properties in Cheektowaga New York
House rentals and rental home Wheatfield
Carmel New York bed and breakfast rentals, rental homes Carmel New York, and Carmel vacation rentals
Aurora condo rentals, for rent by owner homes, Aurora bed and breakfast rentals, and Aurora rental properties
Southeast New York rental homes and rental apartment in Southeast New York
Wawarsing New York bed and breakfast rentals, vacation homes in Wawarsing, and rental home in Wawarsing New York
Chili New York vacation homes, apartments for rent in Chili, Chili New York holiday rentals, and condos for rent Chili New York
Apartment rentals Ogdensburg and holiday rentals in Ogdensburg New York
Rental homes Penfield New York, Penfield rental homes, and vacation homes in Penfield New York
Apartment rentals in Oswego New York, vacation homes, Oswego New York homes for rent, and apartments for rent in Oswego New York
Brunswick rent houses and condo rentals
Home rentals in New Windsor New York, vacation homes in New Windsor New York, and New Windsor New York apartments for rent
Homes for rent in Putnam Valley New York, apartment rentals in Putnam Valley, apartments for rent in Putnam Valley New York, and vacation homes in Putnam Valley New York
Lansing New York for rent by owner homes and holiday rentals in Lansing New York
Rent house Bethlehem New York, vacation rental in Bethlehem New York, and holiday rentals in Bethlehem New York
Brighton New York vacation homes, Brighton New York rent house, vacation homes for rent by owner Brighton, and Brighton New York home rentals
Cicero vacation rentals and homes for rent Cicero
Rental homes in Catskill New York, rental apartment Catskill New York, and houses for rent Catskill New York
Condo rentals in Lansing New York, Lansing New York rental home, apartment rentals Lansing, and houses for rent
Binghamton New York apartments for rent and Binghamton New York vacation rental
Pomfret New York homes for rent, Pomfret rent house, and vacation homes for rent by owner
Espy, look up, and discern apartments for rent Westchester, home rentals, and Westchester home rentals.
Find out, recognize, and hear homes for rent by owner in Madison New York, rental apartment in Madison, and homes for rent Madison New York.
Relocate and glimpse rental home Campbell and vacation rentals in Campbell United States.
We imagined and performed this extensive website, FRBO.com to be sublime, dazzling, stunning, and admirable.
The Eastchester New York loft lists of marked properties and studio directories for these vicinity can be mapped.
Elicit, explore, and devise Putnam New York apartment rentals and rental apartment Putnam.
Relocate and ferret out house rentals Savannah and homes for rent in Savannah United States.
Eastchester condo owners, real estate investors, and property managers list Eastchester New York home rentals, Eastchester apartments for rent, and holiday rentals in Eastchester New York.
Detect and identify Dutchess New York homes for rent by owner and vacation homes in Dutchess New York.
Locate, discover, and glimpse bed and breakfast rentals, Queensbury United States vacation homes for rent by owner, and Queensbury United States rental homes.
Jump into your shakedown online on Tuesday, this evening, on Thursday, or tomorrow evening for your for rent by owner homes in Eastchester New York and real estate rentals in Eastchester New York.
Identify and detect rental homes in Cragsmoor United States and Cragsmoor rent house.
Observe and espy Mountainville vacation rentals and Mountainville United States rental properties.
Eastchester reports could expedite and puff your quest.
Dig up and disclose home rentals Croton on Hudson United States and Croton on Hudson apartment rentals.
Determine, conceive, and perceive homes for rent by owner Billings United States, houses for rent Billings, and vacation homes for rent by owner Billings United States.
Explore, elicit, and conceive condo rentals in Clinton New York and for rent by owner homes in Clinton.
Come across and hear rent houses Merrick United States and real estate rentals in Merrick United States.
Recognize, debunk, and distinguish rent houses in Bloomingburg United States, vacation homes in Bloomingburg United States, and real estate rentals.
Apartments for rent in Palos Verdes California and for rent by owner homes Palos Verdes
Ascertain, devise, and perceive Wyoming New York vacation rental and houses for rent.
Relocate, invent, and contrive rent houses, for rent by owner homes, condo rentals in Rensselaer, and rental homes Rensselaer.
Condo rentals, West Hartford homes for rent, and West Hartford Connecticut rental houses
High Springs-Alachua vacation homes for rent by owner and High Springs-Alachua home rentals
Debunk and perceive rental properties in Verona Beach United States and condo rentals in Verona Beach United States.
Much, ballyhoo, support, do for, and relieve your grooms and residents to a adorable, prevailing, social, and copious county.
Uncover specialized, another, unusual, and peculiar evidence in Eastchester New York and catalogue vacation rental in Eastchester.
This extensive website, FRBO.com omits turf, sector, and parcel results, ofttimes.
Look up, determine, and relocate rent houses Saint Regis Falls United States, rent house in Saint Regis Falls United States, and Saint Regis Falls United States rental apartment.
Pirates and comrades beat about, inquire, and scour our page and debunk oceanfront vacation home and hillside condominium.
Shoreview Minnesota holiday rentals, vacation homes for rent by owner Shoreview, Shoreview Minnesota homes for rent by owner, and Shoreview Minnesota rental homes
Observe, catch, and espy the locality and nearest Eastchester New York block.
Identify, find, and learn rental apartment in Orange New York, rent houses Orange New York, and Orange New York rent house.
Elicit, look up, and come upon rental home Old Westbury United States, real estate rentals in Old Westbury United States, and apartment rentals Old Westbury.
Using this extensive website, FRBO.com, property brokers insert lodge, lodge, condominium, and farmhouse classified advertisements.
Espy and identify homes for rent by owner in Delmar United States and Delmar United States bed and breakfast rentals.
Conceive and originate home rentals Hortonville United States and rental houses in Hortonville.
Locate and perceive Chemung New York rental home, apartment rentals in Chemung New York, and Chemung New York rental properties.
Identify and conceive North Chatham United States houses for rent and vacation homes in North Chatham United States.
Conceive and discern vacation rentals in Chautauqua and rental home Chautauqua New York.
Penthouse lists of marked properties and city online MLS homes for rent Hamilton New York, Hamilton New York condo rentals, rent houses Hamilton, and homes for rent by owner in Hamilton New York.
Learn and distinguish rental properties and rental properties Sullivan.
Elicit and recognize rental properties in Clinton New York, Clinton New York real estate rentals, rental apartment in Clinton New York, and real estate rentals.
Empty exotic ranch and spacious timeshare are nearby in the imminent township of Eastchester New York.
Find and discover home rentals in Java Village and rental home Java Village.
Homes for rent by owner Sebastopol California, rental homes, houses for rent Sebastopol California, and short term rentals in Sebastopol California
Catch, distinguish, and relocate home rentals in Rockland New York, Rockland rental home, rent houses, and Rockland vacation rentals.
Move, identify, and design Bronx New York for rent by owner homes, Bronx short term rentals, Bronx New York houses for rent, and Bronx for rent by owner homes.
Dig up, relocate, and dig up Steamburg United States bed and breakfast rentals, vacation homes for rent by owner Steamburg, and vacation homes for rent by owner in Steamburg.
Our website, FRBO.com does take in special county decadent, beach, city, and resort condominium and duplexs.
Devise, design, and dig up house rentals Austerlitz United States, rental properties in Austerlitz United States, and Austerlitz United States vacation rental.
See lakefront advertisements, decadent online MLS, and lake indexes that landlords and third party agents post on this extensive website, FRBO.com.
Home rentals Ochoco, condo rentals in Ochoco Oregon, and rental properties Ochoco Oregon
Conceive and discover home rentals Albany, rent house Albany New York, and real estate rentals Albany.
Ascertain, find out, and explore vacation rentals in Schuyler New York, vacation homes for rent by owner in Schuyler, and houses for rent.
Send admirable, sublime, fascinating, and ravishing abstracts regarding home rentals in Eastchester New York, Eastchester rent house, Eastchester New York for rent by owner homes, and Eastchester New York rent house found on our online website, FRBO.com.
Explore, find, and contrive Fillmore United States bed and breakfast rentals, vacation rentals in Fillmore, and Fillmore United States for rent by owner homes.
Move and discover house rentals and Herkimer rental homes.
Elicit and debunk apartment rentals Bloomingburg United States and homes for rent by owner Bloomingburg United States.
|
|
