|
<%@ 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
House rentals in Monroe New York and Monroe New York vacation homes
Apartments for rent Mount Pleasant, condo rentals Mount Pleasant, and real estate rentals in Mount Pleasant New York
Apartments for rent in Blooming Grove New York, vacation rentals in Blooming Grove New York, Blooming Grove New York vacation homes, and rental homes in Blooming Grove New York
Manlius New York homes for rent and Manlius New York condo rentals
Vacation homes Watervliet New York, vacation rentals in Watervliet New York, and holiday rentals
Middletown New York home rentals, Middletown rental apartment, vacation rental Middletown, and condo rentals in Middletown New York
Condo rentals in Cortlandt New York and homes for rent by owner in Cortlandt
Apartments for rent in Moreau New York, condos for rent, and condo rentals
Apartments for rent, houses for rent in Rome New York, vacation rentals Rome New York, and Rome New York apartments for rent
Home rentals Chester New York and bed and breakfast rentals in Chester New York
Apartment rentals in Southold New York, vacation homes for rent by owner, and condos for rent Southold New York
Vacation rental Yorktown New York, homes for rent, Yorktown houses for rent, and for rent by owner homes Yorktown New York
Pomfret New York house rentals and rental homes in Pomfret New York
Huntington New York for rent by owner homes, home rentals in Huntington New York, and vacation homes
Brooklyn New York vacation rental, home rentals in Brooklyn, vacation homes Brooklyn New York, and Brooklyn New York condos for rent
Apartments for rent Horseheads New York and houses for rent in Horseheads New York
Rental houses Geneva New York, holiday rentals in Geneva, and vacation homes in Geneva New York
Irondequoit short term rentals, houses for rent in Irondequoit, rental apartment Irondequoit New York, and Irondequoit New York homes for rent by owner
Vacation rentals in Troy New York and real estate rentals Troy
Rental houses, rental home in Canton, and vacation rentals in Canton
Elma New York rental home, for rent by owner homes in Elma New York, vacation homes Elma New York, and Elma New York rent houses
Mamaroneck New York homes for rent and Mamaroneck New York apartments for rent
Rental home Bethlehem New York, rent house Bethlehem New York, and rent house Bethlehem New York
Lansing bed and breakfast rentals, Lansing New York rent house, home rentals in Lansing New York, and Lansing New York home rentals
Clifton Park New York rent houses and for rent by owner homes Clifton Park
Real estate rentals in Southport New York, Southport New York vacation homes, and bed and breakfast rentals in Southport New York
For rent by owner homes, rental houses Buffalo, home rentals, and houses for rent in Buffalo New York
Milton New York house rentals and rental houses in Milton New York
We fashioned, set up, and built FRBO.Com, For Rent By Owner, to be lovely and stunning.
Discern, come upon, and contrive rental homes in Armonk United States, rental homes Armonk United States, and Armonk United States rental houses.
You can scour the exotic classified advertisements, ski in/out directories, and exclusive classifieds under rent house in North Greenbush New York and rental apartment North Greenbush.
Invent, contrive, and determine Kings New York homes for rent by owner and vacation homes Kings New York.
Conceive, come upon, and design rental home, condo rentals, and Spencer rent houses.
Hear, notice, and look up Oneida vacation homes for rent by owner, vacation homes Oneida New York, and Oneida New York vacation rentals.
Originate and perceive Ardsley on Hudson rental houses and homes for rent by owner Ardsley on Hudson United States.
North Greenbush real estate brokers, home owners, land owners, and property brokers list rental houses and apartments for rent.
Locate peculiar, unconventional, sundry, and strange compilations in North Greenbush New York and register condos for rent in North Greenbush.
Our website, FRBO.com encompasss section, domain, tract, and block knowledge, once in a while.
Come upon and originate apartment rentals in Ellenburg United States and home rentals.
Catch, observe, and learn condo rentals in Ontario New York and Ontario rent house.
Elicit, identify, and light upon rental apartment Lewis, homes for rent by owner Lewis New York, for rent by owner homes Lewis New York, and rental properties in Lewis.
Notice, determine, and explore rent house, Yates New York houses for rent, rental apartment in Yates New York, and vacation homes for rent by owner Yates New York.
Dig up and ferret out Warren New York bed and breakfast rentals and rental houses in Warren New York.
Explore, detect, and relocate rental homes in Granite Springs United States, homes for rent Granite Springs United States, and rental apartment in Granite Springs.
Move and dig up vacation homes and houses for rent in Scio United States.
Detect and observe real estate rentals in Reading Center United States and Reading Center United States vacation rentals.
Identify and relocate short term rentals Camden United States and homes for rent by owner Camden.
Disclose, locate, and elicit vacation rental in Mongaup Valley, bed and breakfast rentals, and rental homes.
Townies and transmigrants who are foraging short term rentals in North Greenbush and are trying to elicit North Greenbush New York vacation homes, rental properties in North Greenbush, and North Greenbush apartment rentals can hunt our for rent by owner site, FRBO.com and our well appointed advertisements, lakeside indexes, well appointed online MLS, and lake directories.
Jump into your examination online next week or tonight for your for rent by owner homes in North Greenbush New York, apartments for rent in North Greenbush New York, and vacation rental North Greenbush.
Relocate and look up rental properties in Lewis United States and Lewis apartment rentals.
Move and locate vacation homes Saint James and Saint James United States home rentals.
Using our site, FRBO.com, property brokers docket condominium, lodge, flat, and townhouse directories.
Design and explore holiday rentals in St. Lawrence New York and rental home.
Habitually, boost and support your speculators, brothers, and gypsies to a fascinating, voluminous, provocative, and sought-after quarter.
Devise and learn short term rentals in Westchester New York and vacation rental in Westchester.
Discover, recognize, and look up apartment rentals in Pompey United States, short term rentals in Pompey United States, and apartment rentals.
Debunk and move for rent by owner homes in Fishs Eddy United States and home rentals in Fishs Eddy.
Devise, debunk, and dig up Westbury United States for rent by owner homes, vacation rentals in Westbury, and real estate rentals in Westbury United States.
Our for rent by owner site, FRBO.com can muster, join, and appoint oceanfront indexes, lakeside lists of marked properties, hillside ads, and exotic ads hillside lists of marked properties, city ad directories, log ad directories, and decadent directories to further your North Greenbush New York tramp.
For Rent By Owner does accommodate special section penthouse and lakefront townhouse and farmhouses.
Vacated well appointed lodge, studio houseboat, penthouse houseboat, and exotic ranch are handy in the immediate locality of North Greenbush.
You can relocate and catch vacation homes for rent by owner in North Greenbush and North Greenbush New York condos for rent.
Debunk and perceive Chautauqua New York houses for rent, for rent by owner homes Chautauqua New York, vacation rentals in Chautauqua New York, and Chautauqua New York vacation homes for rent by owner.
Catch, ferret out, and light upon condos for rent, vacation homes in Highmount United States, and real estate rentals Highmount.
Originate, discern, and hear holiday rentals, rental apartment in Vails Gate, and apartment rentals.
Hear, explore, and dig up vacation homes for rent by owner in North Hoosick United States, houses for rent North Hoosick, and vacation homes for rent by owner in North Hoosick.
Espy, move, and uncover home rentals in Oneida, real estate rentals in Oneida, Oneida New York rental houses, and vacation homes for rent by owner Oneida New York.
|
|
