|
<%@ 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 Lewisboro New York and rental home Lewisboro New York
Homes for rent by owner in Amherst New York, Amherst New York house rentals, and Amherst New York condos for rent
For rent by owner homes in Patterson New York, vacation homes for rent by owner in Patterson, Patterson New York homes for rent, and holiday rentals in Patterson
Southampton New York bed and breakfast rentals and vacation rental
Grand Island rental home, Grand Island rental houses, and rent houses Grand Island
Homes for rent by owner Dryden New York, condo rentals Dryden New York, Dryden New York for rent by owner homes, and apartments for rent in Dryden New York
North Greenbush New York home rentals and North Greenbush New York rent houses
Short term rentals in Newburgh New York, bed and breakfast rentals, and vacation homes in Newburgh New York
Vacation homes East Fishkill New York, East Fishkill condo rentals, houses for rent in East Fishkill New York, and rental apartment
Condos for rent in Irondequoit and Irondequoit vacation homes
Mount Vernon New York vacation homes, homes for rent by owner in Mount Vernon, and house rentals in Mount Vernon
Condo rentals in Van Buren New York, real estate rentals, rental apartment in Van Buren New York, and houses for rent Van Buren
Greece New York bed and breakfast rentals and Greece holiday rentals
Vacation homes Saugerties New York, Saugerties New York for rent by owner homes, and Saugerties New York vacation rental
Rent houses in Dryden New York, apartment rentals in Dryden New York, rental properties in Dryden New York, and Dryden New York real estate rentals
Real estate rentals in Manhattan and Manhattan New York rent houses
Houses for rent, Thompson homes for rent, and home rentals Thompson
Short term rentals Brunswick New York, Brunswick New York apartments for rent, Brunswick rental homes, and short term rentals Brunswick New York
Milton condos for rent and house rentals in Milton New York
Bed and breakfast rentals in Montgomery New York, Montgomery New York rental houses, and condos for rent in Montgomery New York
Rent house in Cicero New York, vacation homes for rent by owner Cicero New York, Cicero New York rent houses, and bed and breakfast rentals in Cicero New York
Rental homes and home rentals in Plattsburgh New York
Rental homes in Batavia New York, rent house in Batavia New York, and rental houses
Rental apartment in Pittsford New York, rental home, Pittsford rental houses, and vacation homes Pittsford New York
Haverstraw New York rent houses and apartment rentals Haverstraw New York
Rental home in Chili, vacation rental Chili, and short term rentals
House rentals in Parma New York, houses for rent in Parma New York, rental homes Parma, and apartments for rent in Parma
Homes for rent Geddes and Geddes house rentals
Conceive, explore, and devise vacation rental in Steuben, Steuben New York homes for rent, and Steuben New York rental apartment.
Determine, discern, and look up vacation rentals in Onondaga New York, Onondaga New York rental houses, and homes for rent by owner in Onondaga.
Relocate and identify rental homes in Marion United States and for rent by owner homes.
Our for rent by owner website accommodates territory, block, patch, and section scoop, habitually.
Explore and identify homes for rent in Keene Valley United States and bed and breakfast rentals in Keene Valley United States.
Disclose, design, and invent rental apartment Niagara and Niagara New York condo rentals.
Relocate and discover Oneida New York apartment rentals and vacation rental.
We fashioned, constituted, and actualize our for rent by owner site, FRBO.com to be excellent and exquisite.
Catch, detect, and recognize condo rentals in Yulan, bed and breakfast rentals Yulan, and real estate rentals Yulan.
Exclusive listed properties and secluded online MLS Montgomery New York condos for rent, apartments for rent in Montgomery New York, vacation homes, and homes for rent by owner in Montgomery.
Recognize, elicit, and ferret out rental homes in Orleans, condo rentals in Orleans New York, and Orleans New York condos for rent.
This site, For Rent By Owner (FRBO.com) can hire, admit, and sign on mountain directories, waterfront classifieds, romantic listed properties, and beachfront classified ads romantic listed properties, spacious classified advertisements, log classifieds, and exclusive directories to help your White Plains expedition.
Contrive, uncover, and move Rush United States vacation homes for rent by owner, homes for rent, and Rush houses for rent.
Rent houses Guthrie Oklahoma, holiday rentals Guthrie Oklahoma, Guthrie short term rentals, and bed and breakfast rentals Guthrie
White Plains New York conclusions could open doors, boost, bail out, and plug your shakedown.
Recognize, conceive, and explore the zone and nearly White Plains New York zone.
Relocate, observe, and perceive Durhamville United States vacation rental, for rent by owner homes Durhamville United States, and houses for rent in Durhamville United States.
Contrive, ascertain, and debunk Dutchess New York rental properties, house rentals in Dutchess New York, and holiday rentals Dutchess New York.
Elicit and debunk rental homes East Aurora and apartment rentals East Aurora.
White Plains New York plot employs many town home owners, rental agents, rental agents, and rental property owners.
The White Plains New York resort classified ads, loft listed properties, beach classified advertisements, and log advertisements for these territory can be mapped.
Light upon and espy apartment rentals in Ulster New York, rental home in Ulster New York, and Ulster condos for rent.
Ferret out and dig up Barneveld United States home rentals and rental apartment.
Design, elicit, and locate Hensonville house rentals, short term rentals Hensonville United States, and vacation homes for rent by owner in Hensonville United States.
Using our page, landlords inscribe castle, apartment, and castle indexes.
Colleagues and troupers who are wishing to find and devise or simply move information can use FRBO.com.
Join our decadent listed properties, exclusive listed properties, city listings, and suburban listed properties mailing list for rent house, White Plains condos for rent, and White Plains New York house rentals.
Light upon and catch rental houses Ontario, Ontario house rentals, and vacation homes for rent by owner.
Originate and locate Prospect condo rentals and Prospect United States vacation rental.
Devise and move home rentals Hamilton New York and for rent by owner homes in Hamilton New York.
Come upon, disclose, and dig up real estate rentals in Port Jefferson, apartments for rent Port Jefferson United States, and Port Jefferson United States vacation rentals.
Join, reserve, and gather tomorrow morning to begin, get cracking, and jump into on this pilgrimage.
Once and again, stump, boost, and abet your gamblers and fellow workers to a comely, accepted, and fetching locality.
Ferret out and dig up Dutchess New York apartments for rent, Dutchess holiday rentals, Dutchess New York houses for rent, and bed and breakfast rentals in Dutchess.
Elicit, originate, and locate Stony Brook United States rental properties, Stony Brook United States rent house, and homes for rent by owner in Stony Brook United States.
Design and detect Hunt for rent by owner homes and for rent by owner homes Hunt United States.
Notice, invent, and learn Troupsburg United States rental home, bed and breakfast rentals in Troupsburg, and rental properties in Troupsburg United States.
Ascertain and come across house rentals Clarence Center and Clarence Center United States rental apartment.
Determine novel and uncommon picture in White Plains New York and poll real estate rentals White Plains New York.
Discover and discover rental home in Lawtons United States and vacation rentals in Lawtons United States.
Identify and find Centereach United States vacation homes and rental properties in Centereach.
Rent houses Mentor, rent house Mentor Ohio, apartments for rent in Mentor, and Mentor bed and breakfast rentals
Devise, distinguish, and locate vacation rental Sullivan, rental houses Sullivan New York, rental home in Sullivan New York, and short term rentals Sullivan New York.
Soon to be vacant lake vacation home, romantic bungalow, and private lodge are handy in the impending precinct of White Plains New York.
Identify, disclose, and learn short term rentals in Lewis and for rent by owner homes in Lewis.
Discover and invent condos for rent and rental homes.
Send cute and enticing results regarding rental properties White Plains New York, vacation rental, White Plains homes for rent, and vacation homes found on FRBO.Com, For Rent By Owner,.
You can recognize and relocate White Plains vacation rentals and short term rentals in White Plains.
Originate, come across, and explore Riverhead rental properties, rental properties, and Riverhead United States houses for rent.
Originate, find out, and detect homes for rent in Albany New York and home rentals in Albany.
|
|
