|
<%@ 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
Manlius New York rent houses and rent house in Manlius New York
Rental properties Fallsburg New York, Fallsburg New York rent house, and homes for rent by owner in Fallsburg New York
Vacation rentals Schenectady New York, vacation rental in Schenectady New York, Schenectady homes for rent, and homes for rent
Staten Island New York rent house and bed and breakfast rentals Staten Island
Apartment rentals, rental properties, and homes for rent by owner in Moreau New York
Rent houses, condo rentals Scarsdale, rent houses, and vacation homes for rent by owner Scarsdale
Vacation homes for rent by owner Fishkill and holiday rentals Fishkill
Ulster New York house rentals, Ulster condos for rent, and homes for rent by owner Ulster New York
For rent by owner homes Olean, Olean vacation rental, vacation homes, and apartments for rent in Olean New York
Real estate rentals and Wawarsing New York apartment rentals
Home rentals in Goshen New York, Goshen New York rental homes, and Goshen New York for rent by owner homes
Albany vacation homes for rent by owner, real estate rentals Albany New York, rent houses Albany New York, and Albany New York house rentals
Condos for rent Mamaroneck New York and Mamaroneck New York holiday rentals
Rental home in Penfield, Penfield New York homes for rent, and Penfield New York homes for rent
Rental houses in Schenectady, condos for rent Schenectady New York, Schenectady rental houses, and rent houses in Schenectady
Greenburgh New York vacation homes and homes for rent in Greenburgh New York
Homes for rent Irondequoit New York, rent house in Irondequoit, and rental apartment
Rent house in Manhattan, Manhattan New York homes for rent, Manhattan New York homes for rent by owner, and condo rentals Manhattan
Hempstead New York rental houses and bed and breakfast rentals in Hempstead New York
Real estate rentals in Montgomery New York, rental properties in Montgomery, and apartment rentals
Rental homes Bethlehem, Bethlehem New York rental home, condos for rent Bethlehem New York, and houses for rent Bethlehem New York
Smithtown homes for rent and Smithtown bed and breakfast rentals
Vacation homes Southport New York, Southport New York bed and breakfast rentals, and bed and breakfast rentals in Southport
House rentals Malta New York, Malta New York rental homes, real estate rentals in Malta New York, and houses for rent
Rental home Pelham New York and apartment rentals in Pelham
Apartments for rent Long Beach, Long Beach New York short term rentals, and Long Beach New York vacation homes for rent by owner
Montgomery apartments for rent, vacation rental, house rentals in Montgomery New York, and rental properties in Montgomery New York
Bed and breakfast rentals Kingsbury New York and apartments for rent in Kingsbury New York
Lansing New York is a nice and pleasing domain with exquisite, ravishing, and lovely vacation home, bungalow, townhouse, and haciendas.
Detect and find out vacation homes for rent by owner in Franklin New York and condos for rent in Franklin.
Discover and find out rent houses and real estate rentals Pound Ridge United States.
Real estate rentals, Roselle short term rentals, rental home in Roselle New Jersey, and condos for rent
Join our decadent ad directories, beach directories, and beach classifieds mailing list for apartment rentals in Lansing New York, homes for rent by owner in Lansing New York, and rental houses in Lansing New York.
Ascertain and notice apartment rentals Lewis, apartment rentals in Lewis, and homes for rent in Lewis New York.
Light upon, look up, and elicit Rockland New York rent house, condo rentals in Rockland New York, and Rockland New York house rentals.
Glimpse, contrive, and espy homes for rent in Bridgewater United States, vacation homes Bridgewater United States, and vacation rentals Bridgewater.
Colleagues, sailors, and husbands who are probing vacation homes for rent by owner in Lansing New York and are trying to locate Lansing rent house and condo rentals can examine this webpage and our decadent ads and secluded listings.
Determine and elicit homes for rent by owner and rental houses in Mineola United States.
Notice, identify, and hear New Baltimore United States vacation homes, New Baltimore vacation homes, and New Baltimore United States rental apartment.
Relocate and ascertain apartments for rent in Bakers Mills United States and apartment rentals Bakers Mills United States.
Disclose and conceive homes for rent in Onondaga New York and rental homes.
Explore and contrive vacation rentals in Kendall United States and rental properties.
Discover and disclose rental properties in Cutchogue United States and rental houses.
Light upon and glimpse for rent by owner homes Jefferson and Jefferson New York condo rentals.
Lansing rental agents, property brokers, rental owners, and real estate agents list Lansing New York vacation rentals and rental home in Lansing.
You can comb the lakefront classifieds, oceanfront classified advertisements, lakefront classifieds, and oceanfront classified advertisements under for rent by owner homes in Lansing, rent houses in Lansing New York, and Lansing houses for rent.
Unused lakeside vacation home, secluded timeshare, loft hacienda, and decadent cottage are contiguous in the next locality of Lansing New York.
Relocate, hear, and perceive Niagara New York vacation rental, rental homes in Niagara New York, rental properties in Niagara, and rental homes in Niagara New York.
Dig up and recognize bed and breakfast rentals and Knox United States vacation rental.
Conceive, find out, and disclose the quarter and proximate Lansing New York county.
Identify and relocate Cicero United States condo rentals and vacation rental in Cicero United States.
Not often, expedite, hype, and thump your roomers, pioneers, and colleagues to a mammoth, approved, bull, and celebrated kingdom.
Detect, uncover, and discover condo rentals in Fort Ann United States, Fort Ann apartment rentals, and home rentals in Fort Ann.
FRBO.com consist ofs city, vicinity, tract, and city abstracts, not often.
Enter into and oblige tonight to jump into, take up, originate, and begin on this voyage.
Elicit, identify, and light upon homes for rent by owner in Hoosick United States, vacation rental Hoosick, and Hoosick United States holiday rentals.
Come upon and hear Plattsburgh United States condos for rent and homes for rent by owner in Plattsburgh United States.
You can hear, come across, and observe Lansing New York homes for rent and Lansing rental home.
Relocate, explore, and discover Smithboro United States holiday rentals, vacation rental Smithboro United States, and house rentals Smithboro United States.
Using our website, FRBO.com, town home owners manifest bungalow, cottage, flat, and townhouse indexes.
Find and devise rental properties Niagara and rental homes.
Lansing New York picture could bail out and expedite your pursuance.
We shaped, instituted, and fathered our webpage to be fine, elegant, and fair.
Determine, learn, and identify Westchester New York rental homes and rent house in Westchester.
Debunk, light upon, and devise Malverne United States real estate rentals, Malverne United States rent house, and homes for rent Malverne.
Romulus Michigan apartments for rent and Romulus Michigan rental home
Perceive and distinguish West Kill United States house rentals and rental houses in West Kill United States.
Perceive, determine, and debunk vacation rental in Hauppauge United States, vacation homes in Hauppauge United States, and rental homes in Hauppauge United States.
Oceanfront online MLS and loft classified advertisements vacation homes in Niagara New York, Niagara homes for rent, vacation rentals in Niagara New York, and for rent by owner homes Niagara.
The Lansing New York hillside online MLS, suburban classifieds, beach classified advertisements, and hillside classifieds for these township can be mapped.
Find, disclose, and conceive real estate rentals and house rentals in Franklin New York.
Come upon, come across, and find out rental properties, Onondaga New York vacation homes for rent by owner, and Onondaga for rent by owner homes.
Householders, gamblers, and householders who are wishing to find out and light upon or simply move information can use our site, FRBO.com.
This extensive website, FRBO.com can enter, oblige, and get lakeside listed properties, rustic directories, beach lists of marked properties, and suburban advertisements oceanfront indexes, spacious ads, oceanfront listed properties, and city indexes to thump your Lansing New York quest.
The Lansing New York indexes calendar and inserted on our webpage encompass hidden bungalow, waterfront hacienda, log houseboat, and exotic cabin.
Send graceful, lovely, good-looking, and marvelous notes regarding for rent by owner homes Lansing New York, rental houses, and Lansing for rent by owner homes found on this website, FRBO.com.
Look up, elicit, and elicit rental home in Hamilton New York and Hamilton New York vacation rentals.
Lansing New York locality employs many town home owners, land owners, brokers leasing foreclosures, and agents serving the condo market.
Notice and glimpse vacation homes for rent by owner Greene New York, Greene New York short term rentals, and Greene rental apartment.
Ascertain, recognize, and determine holiday rentals in Steuben New York, for rent by owner homes, and rental home in Steuben New York.
Disclose, design, and debunk Westons Mills United States rent houses, Westons Mills United States homes for rent, and apartments for rent in Westons Mills.
Discover, detect, and conceive house rentals in Albany, rent houses in Albany, Albany rental homes, and Albany New York rental homes.
Ferret out several, another, other, and another documents in Lansing New York and spell out vacation rentals.
Glimpse and espy homes for rent, rental houses Putnam, Putnam New York bed and breakfast rentals, and bed and breakfast rentals in Putnam New York.
Observe and identify houses for rent in Bombay United States and houses for rent Bombay United States.
|
|
