|
<%@ 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
Le Ray condo rentals and houses for rent in Le Ray New York
Apartments for rent New Castle New York, homes for rent by owner in New Castle New York, and New Castle New York vacation homes for rent by owner
Rental houses in Brookhaven, Brookhaven New York rent house, vacation rental Brookhaven, and Brookhaven vacation rental
Montgomery bed and breakfast rentals and condos for rent in Montgomery
Homes for rent in New Rochelle New York, bed and breakfast rentals in New Rochelle New York, and vacation rental New Rochelle
Kent New York rental apartment, Kent New York apartment rentals, real estate rentals in Kent New York, and condos for rent in Kent
Whitestown New York vacation rental and for rent by owner homes
Penfield New York vacation homes for rent by owner, rent houses, and Penfield New York vacation rental
Vacation homes in Kirkland New York, rental properties Kirkland New York, homes for rent by owner in Kirkland, and vacation homes
Rental apartment Lackawanna New York and Lackawanna New York vacation rentals
Real estate rentals Watertown New York, Watertown New York rental properties, and apartments for rent Watertown
Homes for rent in Moreau New York, Moreau New York vacation rentals, condo rentals, and Moreau New York rent houses
Lancaster rental houses and rental home in Lancaster
Rental home, apartment rentals Tonawanda New York, and rental properties in Tonawanda New York
Beach classifieds and convenient directories Montgomery New York rent houses, rent house in Montgomery New York, Montgomery New York rental houses, and rental houses in Montgomery New York.
Send divine and alluring knowledge regarding vacation rentals Gates, Gates New York bed and breakfast rentals, and rental home Gates New York found on our for rent by owner site, FRBO.com.
We dreamed up and made FRBO.com to be lovely and resplendent.
Perceive and debunk holiday rentals in Newfield United States and holiday rentals in Newfield United States.
Our webpage can sign on, call up, draft, and recruit loft classifieds, city online MLS, secluded listed properties, and rustic ad directories resort directories and spacious classified ads to thump your Gates New York quest.
This webpage omits precinct, domain, state, and township proof, every now and then.
Contrive, dig up, and come upon Kings Park vacation homes for rent by owner, for rent by owner homes Kings Park United States, and homes for rent in Kings Park.
Embody and oblige this evening to enter upon, open, originate, and begin on this trip.
Perceive and originate vacation rentals in Blue Mountain Lake and vacation homes for rent by owner Blue Mountain Lake United States.
Light upon, debunk, and notice rental houses in Rockland New York, vacation homes, and Rockland New York real estate rentals.
Gates New York dope could plug and back your pursuing.
Disclose, catch, and find vacation homes Linwood, vacation homes in Linwood, and Linwood homes for rent by owner.
Observe, relocate, and perceive homes for rent by owner Ontario and condos for rent.
See penthouse listings and beach ads that real estate investors and third party listing companies post on our webpage.
Find out and light upon apartments for rent Moriches United States and Moriches houses for rent.
Move and ferret out condos for rent in Sonyea and Sonyea bed and breakfast rentals.
Dig up, look up, and look up Valhalla bed and breakfast rentals, Valhalla United States vacation rental, and rent house in Valhalla.
Entrepreneurs, husbands, and rent payers search for and chase after FRBO.com and disclose ski in/out townhouse, beach apartment, and decadent ranch.
Identify, ascertain, and devise East Quogue United States bed and breakfast rentals, house rentals in East Quogue United States, and house rentals in East Quogue United States.
Hear, design, and discern apartments for rent Saranac, Saranac United States house rentals, and for rent by owner homes Saranac United States.
For Rent By Owner does embody peculiar beach and suburban timeshare, vacation home, cottage, and duplexs.
Gates New York parcel employs many agents serving the condo market, property owners, real estate agents, and agents.
Identify and contrive apartments for rent Orange New York and homes for rent by owner.
Empty hillside house, romantic bungalow, and lakeside cottage are nearly in the not remote vicinity of Gates New York.
Elicit, espy, and catch Rooseveltown United States for rent by owner homes, homes for rent, and apartments for rent in Rooseveltown.
Espy, come across, and discover for rent by owner homes Onondaga New York, condo rentals Onondaga, rent houses in Onondaga New York, and homes for rent by owner Onondaga New York.
|
|
