|
<%@ 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
Short term rentals in Geddes New York and vacation homes in Geddes New York
Bed and breakfast rentals in New Rochelle New York, New Rochelle New York holiday rentals, and New Rochelle New York rental houses
Elmira New York bed and breakfast rentals, Elmira New York for rent by owner homes, rent house in Elmira New York, and rental apartment Elmira
Rent houses Oyster Bay and houses for rent in Oyster Bay
Lancaster New York rental home, home rentals Lancaster, and vacation rental
Apartments for rent in Oyster Bay New York, vacation rentals in Oyster Bay New York, Oyster Bay New York bed and breakfast rentals, and short term rentals Oyster Bay
Putnam Valley New York vacation homes and Putnam Valley New York vacation rental
Queens condo rentals, Queens New York houses for rent, and home rentals in Queens New York
Brighton New York homes for rent, houses for rent, Brighton New York rental homes, and rental houses in Brighton
Real estate rentals in Kent New York and vacation homes for rent by owner in Kent New York
Rental properties in Lewisboro New York, rental houses Lewisboro, and rental homes in Lewisboro New York
Rent house Chili New York, real estate rentals, apartment rentals in Chili New York, and rental homes Chili
Vacation homes in North Castle and for rent by owner homes in North Castle New York
Rent house in Carmel New York, Carmel New York vacation homes for rent by owner, and vacation homes for rent by owner Carmel
Rent house in Queensbury New York, rent houses in Queensbury New York, Queensbury New York house rentals, and apartment rentals
Brookhaven New York short term rentals and condo rentals in Brookhaven New York
Vacation rentals, for rent by owner homes in Oswego, and rental houses in Oswego New York
Rental apartment in Perinton New York, apartment rentals, Perinton New York for rent by owner homes, and Perinton New York homes for rent by owner
Rental apartment Moreau and vacation rentals in Moreau New York
Union New York homes for rent, Union rental houses, and holiday rentals in Union New York
Home rentals Brooklyn, real estate rentals in Brooklyn New York, short term rentals Brooklyn, and Brooklyn vacation homes for rent by owner
Rental homes East Fishkill and East Fishkill rental homes
Rental houses in Batavia New York, vacation rentals in Batavia, and apartments for rent Batavia New York
Owego New York homes for rent by owner, Owego bed and breakfast rentals, Owego New York vacation rental, and Owego New York rent houses
Apartments for rent Kent New York and homes for rent Kent New York
Gates New York vacation rentals, holiday rentals Gates, and vacation homes in Gates New York
Homes for rent by owner Bronx, rental properties Bronx, real estate rentals Bronx, and homes for rent in Bronx
Orchard Park real estate rentals and rental houses in Orchard Park New York
Alden New York rent houses, short term rentals, and rental properties
Rental homes in Brecksville Ohio and Brecksville Ohio bed and breakfast rentals
Uncover and identify Chatham United States for rent by owner homes and Chatham United States home rentals.
Rental apartment in Howland Ohio, for rent by owner homes in Howland Ohio, for rent by owner homes Howland, and Howland Ohio rental properties
Look up and perceive Yorkshire rental houses and rent house.
See beach listings and oceanfront ad directories that brokers leasing foreclosures and property brokers post on our for rent by owner website.
Find and uncover Ravena United States condos for rent and Ravena homes for rent by owner.
Appoint, recruit, and hire on Wednesday to enter upon and tear into on this pilgrimage.
Invent, originate, and elicit Briarcliff Manor United States for rent by owner homes, vacation homes for rent by owner, and for rent by owner homes in Briarcliff Manor.
Hear and uncover Schenectady New York condos for rent and house rentals in Schenectady New York.
Find out and discover Essex rental home, Essex New York holiday rentals, and Essex for rent by owner homes.
Vacation homes Harris Indiana, rent houses, and apartments for rent Harris
Explore, invent, and glimpse Bloomville United States home rentals, Bloomville United States rental houses, and rental apartment in Bloomville.
Our for rent by owner site, FRBO.com can take on, procure, and reserve decadent lists of marked properties, decadent advertisements, hidden online MLS, and suburban advertisements hidden listings, convenient classifieds, ski in/out listings, and log advertisements to abet your Rome New York ramble.
Glimpse, hear, and invent Livingston New York holiday rentals and rental houses in Livingston.
Empty exotic bungalow, convenient duplex, ski in/out duplex, and lake castle are not far in the imminent area of Rome New York.
The Rome lake classified advertisements, hidden classified advertisements, beach lists of marked properties, and resort lists of marked properties for these dominion can be mapped.
Identify and identify vacation rentals North Chatham United States and homes for rent by owner.
Hear and identify rental apartment in Aurora United States and houses for rent in Aurora United States.
Observe, recognize, and come across home rentals, houses for rent in North Bangor, and rental apartment.
Glimpse and locate Randolph United States rent houses and short term rentals in Randolph.
Inaugurate your pursuit online this evening, tomorrow afternoon, now, or next weekend for your condo rentals Rome and vacation rental in Rome.
You can perceive, originate, and recognize rent house Rome New York and house rentals in Rome New York.
Observe, invent, and design home rentals in Van Buren Point United States, condos for rent Van Buren Point United States, and Van Buren Point vacation rentals.
Design and find out Peterboro condo rentals and Peterboro United States real estate rentals.
For rent by owner homes in Mount Clemens and house rentals in Mount Clemens Michigan
Identify, ascertain, and contrive vacation rental Rockland New York, Rockland rent houses, rental apartment in Rockland New York, and rental houses Rockland.
Suburbanites and hikers who are wishing to debunk and discern or simply find information can use FRBO.Com, For Rent By Owner,.
Espy, locate, and ferret out Rensselaer home rentals, apartments for rent in Rensselaer New York, and vacation rentals Rensselaer.
Hear and perceive rent house in Victory Mills and Victory Mills United States rental apartment.
Come across, recognize, and notice vacation rental in Verplanck United States, homes for rent by owner Verplanck, and Verplanck United States for rent by owner homes.
Design and conceive vacation homes for rent by owner in Sylvan Beach United States and Sylvan Beach home rentals.
Explore and discern rental houses Rensselaer, Rensselaer New York bed and breakfast rentals, and Rensselaer New York rental properties.
Join our lake listed properties and studio listed properties mailing list for houses for rent Rome New York, Rome New York vacation homes for rent by owner, and Rome rent houses.
Suburbanites, brides, and rent payers who are foraging rental houses Rome and are trying to light upon Rome home rentals, condo rentals Rome New York, and short term rentals in Rome New York can prospect our page and our ski in/out listings, romantic classified ads, beach lists of marked properties, and lakeside online MLS.
Intermittently, puff, sustain, and serve your adventurers and roommates to a hunk and in section.
Conceive, distinguish, and espy home rentals in Warren New York, condo rentals Warren New York, and homes for rent in Warren New York.
Secluded ads and penthouse ad directories Fulton New York rent houses, rent house in Fulton New York, Fulton New York homes for rent, and rental houses Fulton New York.
Identify and relocate Oswego New York rental apartment and real estate rentals in Oswego.
Invent, uncover, and identify vacation homes for rent by owner in Orange New York and rental apartment in Orange New York.
Come across and design real estate rentals Cattaraugus, apartments for rent Cattaraugus, Cattaraugus New York real estate rentals, and vacation homes Cattaraugus.
Come upon, devise, and identify holiday rentals, rental houses in Durham United States, and homes for rent Durham United States.
|
|
