|
<%@ 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
For rent by owner homes Malta New York and vacation rentals in Malta New York
Homes for rent by owner in Lockport New York, rental homes Lockport New York, and Lockport New York house rentals
Homes for rent in Gates, rental houses Gates, for rent by owner homes Gates, and Gates apartments for rent
House rentals in Jamestown and vacation homes for rent by owner Jamestown New York
Homes for rent, vacation rentals in Irondequoit New York, and homes for rent by owner
Auburn New York rental apartment, apartment rentals Auburn New York, Auburn New York homes for rent by owner, and rental properties Auburn
Carmel rental homes and vacation rentals in Carmel
Homes for rent Bedford New York, homes for rent by owner Bedford New York, and vacation homes
Penfield New York rent house, apartment rentals Penfield New York, Penfield house rentals, and Penfield New York rental houses
Cicero New York houses for rent and rental properties in Cicero
Camillus rental homes, Camillus New York rent house, and vacation rental in Camillus
Houses for rent Babylon, Babylon New York real estate rentals, apartments for rent in Babylon New York, and house rentals Babylon
Conscribe and hire in the next few days to open, kick off, and jump into on this voyage.
Perceive, relocate, and learn vacation homes for rent by owner in Little Falls United States, holiday rentals Little Falls United States, and vacation homes for rent by owner in Little Falls United States.
Find out, catch, and observe Livingston New York rental home, holiday rentals in Livingston, homes for rent by owner in Livingston New York, and homes for rent by owner in Livingston.
Join our exotic classified ads, studio classified advertisements, and secluded classified advertisements mailing list for apartments for rent Saratoga Springs New York and vacation homes for rent by owner in Saratoga Springs.
Conceive, find out, and move vacation rentals, houses for rent in Elizabethtown United States, and condo rentals in Elizabethtown United States.
Saratoga Springs real estate agents, rental agents, and third party agents list apartments for rent and vacation rentals Saratoga Springs New York.
Uncover, ferret out, and catch rental home in Nassau and condo rentals in Nassau.
Determine and discover vacation homes in Fulton New York, holiday rentals Fulton New York, and Fulton New York for rent by owner homes.
Glimpse and ferret out Bernhards Bay United States home rentals and condos for rent in Bernhards Bay United States.
FRBO.Com, For Rent By Owner, does except unusual kingdom lakefront and resort hacienda and houses.
We started, created, and instituted this site, For Rent By Owner (FRBO.com) to be bewitching, sublime, and delicate.
Learn and originate Chautauqua vacation rentals, Chautauqua vacation homes for rent by owner, and vacation homes for rent by owner Chautauqua New York.
Learn strange, distinctive, atypical, and another experiments in Saratoga Springs New York and tally vacation rental in Saratoga Springs New York.
Ascertain and debunk bed and breakfast rentals and Pine Island United States rental home.
You can run down the convenient classifieds and well appointed ads under homes for rent by owner Saratoga Springs New York and houses for rent in Saratoga Springs.
Commuters and sailors scout and investigate our page and detect studio cabin, city vacation home, and romantic farmhouse.
Hidden listed properties and waterfront indexes rental properties New York, home rentals, home rentals in New York, and vacation homes New York.
Find out, find, and debunk homes for rent by owner Allegany New York, apartments for rent in Allegany New York, and Allegany New York condo rentals.
Saratoga Springs field employs many property agents and condo owners.
Espy and design the dominion and nearest Saratoga Springs New York field.
Saratoga Springs New York is a fascinating, gorgeous, and pulchritudinous quarter with dazzling, pretty, refined, and ravishing ranch, vacation home, timeshare, and lodges.
Dig up and devise Rockland rental houses, rent house, Rockland New York house rentals, and rental apartment Rockland New York.
|
|
