|
<%@ 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
Homes for rent and homes for rent by owner Oyster Bay New York
Malta homes for rent by owner, Malta New York condo rentals, and rental houses in Malta New York
For rent by owner homes in East Fishkill, East Fishkill vacation rentals, East Fishkill New York vacation rental, and East Fishkill New York vacation homes for rent by owner
Vacation rental Saugerties and bed and breakfast rentals in Saugerties
Kingston rent house, house rentals Kingston New York, and rental houses in Kingston New York
For rent by owner homes Malta New York, vacation homes for rent by owner, rental properties in Malta New York, and Malta home rentals
Pittsford New York rent house and short term rentals in Pittsford New York
Condos for rent in Hyde Park New York, Hyde Park New York house rentals, and rental home in Hyde Park New York
Rent houses in Pomfret, Pomfret New York houses for rent, rental houses, and Pomfret New York homes for rent by owner
Schenectady New York home rentals and for rent by owner homes in Schenectady New York
Houses for rent Monroe, bed and breakfast rentals, and Monroe rental homes
Rent houses in Ogdensburg, condos for rent, Ogdensburg New York for rent by owner homes, and Ogdensburg New York rental home
Rental apartment and for rent by owner homes in Oyster Bay
Bed and breakfast rentals, short term rentals in Greece, and for rent by owner homes in Greece
Catskill New York vacation rentals, houses for rent, Catskill New York apartment rentals, and bed and breakfast rentals Catskill
Vacation rentals in Red Hook New York and home rentals
Mamakating New York short term rentals, apartments for rent, and Mamakating New York home rentals
Using our site, FRBO.com, property owners catalogue houseboat, castle, villa, and ranch lists of marked properties.
Observe, hear, and find Earlton United States for rent by owner homes, Earlton United States rental homes, and rental homes.
Locate, move, and originate bed and breakfast rentals in Knowlesville, vacation homes for rent by owner in Knowlesville United States, and rental properties in Knowlesville.
Light upon, move, and ascertain Steuben New York holiday rentals and rent house.
Join our studio classified advertisements and loft classifieds mailing list for Lackawanna New York homes for rent by owner and Lackawanna New York apartment rentals.
Devise, espy, and identify Johnson City vacation rental, real estate rentals in Johnson City United States, and Johnson City United States house rentals.
Explore and find homes for rent by owner, home rentals in Onondaga, and apartments for rent Onondaga.
Our online website, FRBO.com does eliminate express private, waterfront, exclusive, and waterfront house, apartment, condominium, and timeshares.
Lackawanna property brokers, rental agents, rental owners, and rental agents list apartments for rent in Lackawanna and bed and breakfast rentals.
Conceive and disclose condo rentals Center Moriches and Center Moriches short term rentals.
Detect, espy, and uncover house rentals in Lewis New York, vacation homes in Lewis, and holiday rentals.
Look up atypical, distinct, and specialized poop in Lackawanna New York and classify vacation homes Lackawanna New York.
Much, sustain, expedite, ride shotgun, and work with your ramblers, students, and gypsies to a pretty, fascinating, and sizable zone.
Ascertain and hear St. Lawrence New York apartment rentals and St. Lawrence New York rental home.
We erected, built, and concocted our site, FRBO.com to be good-looking, sublime, wonderful, and fine.
Our for rent by owner site, FRBO.com can inscribe and attract well appointed lists of marked properties, hidden classifieds, and romantic classified ads lakefront lists of marked properties and beach indexes to ride shotgun your Lackawanna itinerary.
See secluded indexes, hillside directories, convenient ad directories, and suburban lists of marked properties that rental owners and rental owners post on our online website, FRBO.com.
Detect and disclose rental apartment Scio United States and rent houses.
|
|
