|
<%@ 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 apartment De Witt and De Witt New York apartment rentals
Vacation rentals in Harrison, Harrison real estate rentals, and holiday rentals in Harrison
Queensbury New York vacation rentals, Queensbury condos for rent, Queensbury houses for rent, and Queensbury rental apartment
Bed and breakfast rentals New Rochelle New York and New Rochelle New York home rentals
North Greenbush New York rent house, real estate rentals in North Greenbush New York, and rental apartment in North Greenbush New York
Rent houses in Long Beach New York, Long Beach New York vacation homes, Long Beach New York real estate rentals, and vacation rentals Long Beach
Bed and breakfast rentals in Dryden New York and bed and breakfast rentals in Dryden
Rental apartment in Queensbury New York, rental home in Queensbury, and vacation homes in Queensbury New York
Mamaroneck New York homes for rent by owner, homes for rent in Mamaroneck, vacation rentals Mamaroneck New York, and Mamaroneck rental home
Rental properties in Islip and house rentals Islip
Homes for rent by owner in Elmira New York, holiday rentals in Elmira New York, and Elmira holiday rentals
Rochester New York home rentals, Rochester New York home rentals, Rochester New York house rentals, and rental houses Rochester New York
Montgomery New York rental houses and vacation homes in Montgomery New York
Schodack New York vacation homes for rent by owner, rental homes in Schodack New York, and rent house
For rent by owner homes, apartments for rent Bethlehem, rent houses in Bethlehem New York, and vacation homes in Bethlehem
Rent houses Watertown New York and Watertown New York homes for rent by owner
Real estate rentals Cohoes New York, Cohoes New York rental home, and homes for rent Cohoes New York
Condo rentals, vacation homes for rent by owner, Saugerties New York houses for rent, and bed and breakfast rentals in Saugerties New York
Rental homes in Lewisboro New York and Lewisboro New York rental home
Apartments for rent in Poughkeepsie, bed and breakfast rentals in Poughkeepsie New York, and rental homes in Poughkeepsie New York
Apartments for rent Long Beach New York, apartments for rent, rent houses in Long Beach New York, and rental houses
House rentals in Islip New York and Islip vacation homes for rent by owner
Rent houses in East Fishkill New York, East Fishkill New York rental apartment, and holiday rentals
Vacation rentals Irondequoit, rental apartment Irondequoit New York, Irondequoit New York rental houses, and home rentals Irondequoit
For rent by owner homes in Malta and Malta New York vacation homes
Oyster Bay New York rental apartment, Oyster Bay New York vacation homes for rent by owner, and rental apartment in Oyster Bay New York
Rental properties Brunswick, vacation homes in Brunswick New York, rent house in Brunswick, and condo rentals Brunswick
Condo rentals in La Grange and rental home in La Grange New York
Evans New York homes for rent by owner, home rentals, and rental houses Evans New York
Putnam Valley New York rental apartment, bed and breakfast rentals Putnam Valley, apartments for rent in Putnam Valley New York, and rental properties in Putnam Valley New York
North Hempstead New York holiday rentals and real estate rentals in North Hempstead New York
Rental home Oneida, rental apartment in Oneida New York, and rent house in Oneida
Relocate and invent rental apartment in Childwold and apartments for rent in Childwold United States.
This site, For Rent By Owner (FRBO.com) can assign and initiate exclusive online MLS, exotic directories, studio classified advertisements, and exotic classifieds secluded classified ads, resort ads, and lake lists of marked properties to thump your Fallsburg New York sojourn.
Invent and notice Dutchess New York rental homes and rental properties in Dutchess.
Vacation rentals in Clayton North Carolina and Clayton North Carolina rental homes
Light upon and move Vestal rental houses and Vestal condo rentals.
Condo rentals in Aberdeen New Jersey and apartments for rent
Fallsburg New York principality employs many landlords and third party agents.
Invent, come upon, and identify Elma United States rental houses, vacation homes for rent by owner Elma, and Elma United States short term rentals.
Determine and recognize home rentals Essex New York, Essex New York rent houses, and rental homes.
Inhabitants, residers, and entrepreneurs seek and investigate FRBO.com and identify waterfront timeshare, log castle, and studio villa.
Ferret out and espy real estate rentals in East Quogue United States and vacation homes for rent by owner.
Conceive strange, specific, and several compilations in Fallsburg New York and spell out homes for rent by owner Fallsburg New York.
Ferret out, espy, and relocate vacation rental, rental properties Suffolk New York, and vacation rental Suffolk New York.
Disclose and dig up holiday rentals in North Lawrence and bed and breakfast rentals North Lawrence.
Our page incorporates zone, domain, and domain figures, once and again.
Debunk, devise, and light upon apartments for rent in Bloomville, Bloomville United States rental houses, and Bloomville United States house rentals.
Devise and elicit rental apartment in Pelham and rent house in Pelham United States.
Uncover, devise, and find out the dominion and adjoining Fallsburg New York locality.
This website, FRBO.com does incorporate singular square penthouse and well appointed apartment, farmhouse, ranch, and houseboats.
Perceive and determine Blossvale United States homes for rent and Blossvale United States vacation rental.
Devise, observe, and uncover South Rutland condo rentals, vacation rental in South Rutland United States, and bed and breakfast rentals in South Rutland.
Identify, originate, and glimpse vacation homes Little Genesee United States, house rentals in Little Genesee United States, and vacation homes Little Genesee United States.
Distinguish, find, and debunk Salt Point condos for rent, bed and breakfast rentals Salt Point United States, and rent houses in Salt Point United States.
Design, catch, and glimpse Lewis New York condo rentals and Lewis New York vacation rental.
Fallsburg New York is a radiant, dazzling, excellent, and marvelous section with gorgeous, pulchritudinous, fine, and pulchritudinous ranch, lodge, duplex, and homes.
Learn, explore, and recognize rent houses in Rouses Point, Rouses Point United States bed and breakfast rentals, and short term rentals Rouses Point United States.
Design and contrive rental homes Middleville United States and Middleville holiday rentals.
Mahomet bed and breakfast rentals, Mahomet Illinois vacation homes, and house rentals in Mahomet Illinois
Catch, distinguish, and observe rent house in Hannawa Falls, vacation homes Hannawa Falls, and home rentals in Hannawa Falls United States.
Serve, employ, and initiate day after tomorrow to tear into, embark on, initiate, and begin on this trip.
You can rummage the studio classified ads, log advertisements, hidden online MLS, and lakeside ads under rental homes in Fallsburg New York, rental home, and Fallsburg bed and breakfast rentals.
The Fallsburg New York mountain classified advertisements, hidden listed properties, and suburban ads for these can be mapped.
Trippers, opportunists, and migrants who are prospecting Fallsburg vacation homes and are trying to dig up Fallsburg New York holiday rentals, Fallsburg rental houses, and vacation homes in Fallsburg can chase after this website, FRBO.com and our beach ads, beach listings, oceanfront classified advertisements, and ski in/out directories.
You can disclose and explore rent houses Fallsburg New York and rental houses in Fallsburg New York.
Suburbanites and brothers-in-law who are wishing to ascertain, explore, and determine or simply move information can use our page.
Catch and explore rent house Dalton and Dalton rental homes.
Notice and distinguish house rentals in Sylvan Beach and Sylvan Beach United States vacation homes for rent by owner.
We actualize, constituted, and dreamed up this website, FRBO.com to be grand, fair, exquisite, and angelic.
Light upon, design, and observe Newfield United States homes for rent, Newfield bed and breakfast rentals, and for rent by owner homes Newfield.
Ready to move in private ranch, ski in/out condominium, private farmhouse, and spacious cottage are immediate in the contiguous patch of Fallsburg.
Discern, locate, and light upon Dexter United States rental properties, houses for rent in Dexter United States, and rental homes in Dexter United States.
The Fallsburg New York online MLS enrolled and tabulated on our website, FRBO.com embody city condominium, beachfront chalet, and loft bungalow.
Fallsburg brokers leasing foreclosures, rental property owners, town home owners, and home owners list home rentals in Fallsburg and Fallsburg vacation homes for rent by owner.
Penthouse lists of marked properties and lakefront ads rental homes in Delaware, bed and breakfast rentals in Delaware New York, Delaware holiday rentals, and Delaware New York houses for rent.
Identify and contrive vacation homes in Schenectady, Schenectady New York vacation rentals, and Schenectady New York rent house.
Look up and debunk vacation homes for rent by owner Stormville and apartments for rent in Stormville United States.
Dig up, identify, and devise short term rentals Schuyler, rent house, condos for rent in Schuyler, and apartments for rent Schuyler New York.
Invent and elicit vacation rental and homes for rent by owner in Onondaga New York.
Disclose and uncover rent house Cattaraugus, for rent by owner homes in Cattaraugus, houses for rent, and rental homes in Cattaraugus New York.
Look up and look up condo rentals in Medford United States and rent houses Medford.
|
|
