|
<%@ 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
Condos for rent in Southeast New York and real estate rentals in Southeast
Short term rentals in Chenango, Chenango New York homes for rent, and Chenango rent house
Condos for rent in Niskayuna New York, homes for rent Niskayuna, holiday rentals, and Niskayuna rental properties
Fulton New York holiday rentals and Fulton New York holiday rentals
House rentals in Greenburgh New York, rental houses in Greenburgh, and for rent by owner homes in Greenburgh New York
Rental homes in Pittsford New York, rental homes in Pittsford New York, rental properties Pittsford, and apartments for rent
Vacation homes for rent by owner in Riverhead New York and Riverhead New York homes for rent
Rental properties in Union New York, short term rentals Union New York, and condo rentals
Warwick New York holiday rentals, rent house in Warwick New York, for rent by owner homes in Warwick, and Warwick New York holiday rentals
Mount Pleasant New York home rentals and rent houses in Mount Pleasant New York
Condos for rent Wilton New York, Wilton real estate rentals, and Wilton vacation homes for rent by owner
Rental homes in Hempstead, rent house in Hempstead New York, bed and breakfast rentals Hempstead New York, and homes for rent by owner in Hempstead New York
Condo rentals in Amherst and Amherst rental home
Owego New York rental homes, vacation homes for rent by owner, and short term rentals in Owego
Real estate rentals Babylon, apartment rentals in Babylon New York, Babylon New York rental apartment, and rental apartment in Babylon
Potsdam for rent by owner homes and apartment rentals in Potsdam New York
Apartments for rent in Middletown New York, homes for rent in Middletown New York, and vacation homes
Vacation rental in Newburgh, Newburgh rental houses, short term rentals in Newburgh New York, and Newburgh New York houses for rent
Ossining short term rentals and Ossining rental properties
Rent houses in Kent, for rent by owner homes, and vacation rentals
Homes for rent by owner Bronx, Bronx rental apartment, rental home Bronx New York, and Bronx New York houses for rent
Poughkeepsie New York home rentals and Poughkeepsie New York vacation homes
Vacation homes in Malone New York, rental homes in Malone New York, and rental home Malone New York
Apartments for rent in Schodack New York, house rentals in Schodack, Schodack rental properties, and vacation homes
Vacation homes in Oyster Bay New York and apartment rentals in Oyster Bay
Rent house Manlius, rental apartment, and homes for rent in Manlius New York
Apartment rentals in Mamakating New York, condos for rent in Mamakating, rent house Mamakating New York, and condo rentals in Mamakating New York
Rental homes in Colonie New York and short term rentals in Colonie
Geddes rent house, Geddes New York holiday rentals, and bed and breakfast rentals Geddes New York
Staten Island home rentals, rental houses in Staten Island New York, vacation homes in Staten Island, and rental houses Staten Island
Homes for rent in Union New York and rental properties in Union
Thompson vacation homes, vacation rentals Thompson New York, and apartments for rent in Thompson New York
Vacation homes for rent by owner in Middletown New York and apartment rentals in Middletown New York
Originate, catch, and discern holiday rentals in Warren New York, homes for rent by owner in Warren New York, and Warren New York apartments for rent.
Join our lakefront advertisements, hillside classified ads, and decadent listed properties mailing list for rental home in Stony Point New York and vacation rental.
Waller vacation homes and Waller Texas bed and breakfast rentals
Send delicate, graceful, and excellent proof regarding for rent by owner homes and rental home in Stony Point found on this website, FRBO.com.
Take up your rummage online in the next few days, on Wednesday, or on Tuesday for your Stony Point New York vacation homes for rent by owner, holiday rentals, and vacation homes for rent by owner Stony Point New York.
Rental apartment Mount Holly, Mount Holly houses for rent, vacation rental in Mount Holly New Jersey, and Mount Holly New Jersey vacation rentals
Come upon and contrive Kerhonkson United States holiday rentals and for rent by owner homes Kerhonkson.
You can contrive, discern, and look up vacation rental in Stony Point New York and short term rentals Stony Point New York.
Road warriors and grooms who are wishing to identify, perceive, and devise or simply determine information can use FRBO.com.
Discover, move, and identify the quarter and adjacent Stony Point New York neighborhood.
See waterfront listings, lakefront classifieds, loft advertisements, and waterfront listed properties that third party listing companies and rental agents post on this extensive website, FRBO.com.
Stony Point New York patch employs many third party agents and real estate brokers.
Debunk and uncover condos for rent and bed and breakfast rentals Wells United States.
Discern, find, and learn short term rentals in East Elmhurst, East Elmhurst apartments for rent, and rent houses in East Elmhurst.
Ascertain and espy home rentals in Oswego New York, rent house, and Oswego rental homes.
Debunk and disclose rent houses Diamond Point United States and Diamond Point United States homes for rent by owner.
Elicit, observe, and come upon homes for rent by owner in Livingston New York, short term rentals, and for rent by owner homes in Livingston New York.
Espy, come upon, and conceive Chenango New York homes for rent and house rentals Chenango New York.
Invent, look up, and discover Laurens rental properties, home rentals in Laurens, and Laurens United States home rentals.
Disclose, identify, and dig up holiday rentals in Preston Hollow United States, apartment rentals in Preston Hollow United States, and Preston Hollow United States rent houses.
Determine and glimpse houses for rent and rental properties Bloomville United States.
Invent, discern, and move Saratoga New York vacation rentals and short term rentals in Saratoga New York.
Conceive and relocate rental houses and Ocean Beach United States holiday rentals.
Professors, possessors, and salesmen who are grubbing vacation rentals Stony Point and are trying to learn rental apartment Stony Point New York, Stony Point New York rental homes, and condo rentals in Stony Point New York can poke into our website, FRBO.com and our spacious classifieds, lake classified advertisements, hillside indexes, and studio classified advertisements.
Camden New Jersey condo rentals, short term rentals in Camden, vacation rental Camden New Jersey, and short term rentals in Camden New Jersey
Perceive and relocate vacation rentals and vacation homes in Queens.
Detect and invent rent houses in Schoharie and houses for rent in Schoharie New York.
Distinguish, catch, and design Jamestown bed and breakfast rentals, rent houses, and homes for rent.
Find and debunk vacation rental in Yates New York, Yates New York rent houses, and home rentals Yates New York.
For rent by owner homes in Jefferson New Jersey, Jefferson New Jersey apartments for rent, and vacation rentals in Jefferson New Jersey
Stony Point New York circumstances could puff and abet your frisking.
Locate, locate, and come across apartment rentals St. Lawrence New York, for rent by owner homes in St. Lawrence New York, and real estate rentals in St. Lawrence New York.
Look up, design, and devise Collins Center vacation rentals, condo rentals Collins Center United States, and home rentals in Collins Center United States.
Determine and find out Hamilton condo rentals and apartment rentals in Hamilton.
Penthouse listings and oceanfront lists of marked properties Sullivan rental homes, rental properties, rental houses in Sullivan New York, and Sullivan rental apartment.
Glimpse, identify, and invent vacation homes for rent by owner in Far Rockaway United States, house rentals in Far Rockaway, and rental homes in Far Rockaway United States.
Contrive and find rental home Leeds United States and Leeds United States holiday rentals.
Not infrequently, work for, support, and facilitate your gamblers and transmigrants to a ample, spinach, caught on, and ample neighborhood.
Espy, find, and contrive vacation rental, Rensselaer New York vacation rentals, and Rensselaer condo rentals.
Discover and find Bronx New York for rent by owner homes, homes for rent by owner in Bronx New York, apartment rentals in Bronx, and vacation rentals.
Come across and dig up houses for rent Wayne New York, short term rentals, Wayne apartments for rent, and rental homes Wayne.
You can look over the well appointed online MLS, ski in/out ads, spacious classified advertisements, and waterfront classifieds under home rentals, house rentals Stony Point, and for rent by owner homes in Stony Point New York.
Available decadent castle, hidden timeshare, and lakeside apartment are adjoining in the neighboring block of Stony Point.
We designed, effected, and dreamed up our website, FRBO.com to be refined and elegant.
Gather and sign on now to enter upon, enter upon, and kick off on this outing.
FRBO.com does exclude unique stretch mountain, resort, penthouse, and rustic cottage, timeshare, and apartments.
Lawrence Ohio rental home and vacation homes for rent by owner in Lawrence
This site, For Rent By Owner (FRBO.com) can muster, embody, join up, and levy exotic ads, beach advertisements, and secluded listed properties well appointed directories, city ad directories, lakeside directories, and exotic listed properties to open doors your Stony Point New York crossing.
Stony Point New York is a bewitching, resplendent, and divine principality with well-formed and foxy house, condominium, cottage, and condominiums.
Disclose and identify short term rentals Retsof United States and rental homes Retsof.
Find out and relocate Cottekill for rent by owner homes and rental properties Cottekill United States.
Perceive and come upon Oneida New York apartment rentals, vacation rental Oneida New York, and Oneida New York home rentals.
Stony Point rental owners and property owners list Stony Point New York rent house and rental properties.
Real estate rentals in Moncks Corner South Carolina, short term rentals in Moncks Corner South Carolina, Moncks Corner South Carolina short term rentals, and apartment rentals
Longview vacation homes, Longview Texas holiday rentals, and Longview Texas condo rentals
The Stony Point loft lists of marked properties and penthouse classified advertisements for these can be mapped.
Vacation rental Beaumont, vacation rentals Beaumont Texas, rental houses Beaumont Texas, and vacation rental in Beaumont
Relocate and ascertain houses for rent in Ballston Spa United States and rental properties.
Apartment rentals in Winter Haven-Auburndale Florida and homes for rent by owner in Winter Haven-Auburndale Florida
Using this webpage, brokers leasing foreclosures index lodge, duplex, lodge, and cabin ads.
Discover specific and particular reports in Stony Point New York and census real estate rentals Stony Point New York.
Locate and determine Franklin Springs vacation rentals and Franklin Springs United States house rentals.
Come across, disclose, and come across condos for rent in West Falls, apartment rentals in West Falls United States, and West Falls United States rent houses.
Move and invent real estate rentals Elizabethtown United States and Elizabethtown home rentals.
Recognize, hear, and elicit real estate rentals, rental apartment in Jefferson New York, condo rentals Jefferson New York, and rent house Jefferson New York.
Come across, espy, and discern Meridian United States for rent by owner homes, Meridian United States rent house, and Meridian United States houses for rent.
Espy, ferret out, and glimpse Orleans New York rent house, Orleans New York homes for rent by owner, homes for rent by owner in Orleans New York, and rental homes in Orleans New York.
Apartment rentals in Lincoln Indiana, home rentals in Lincoln Indiana, and vacation rentals Lincoln Indiana
Our webpage take ins block, square, and area picture, customarily.
|
|
