|
<%@ 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
Vacation homes for rent by owner in Newburgh New York and apartment rentals Newburgh New York
Ulster condo rentals, Ulster New York rental apartment, and homes for rent in Ulster New York
Greenburgh houses for rent, bed and breakfast rentals, vacation homes for rent by owner, and Greenburgh New York home rentals
Rental houses in Glen Cove and home rentals Glen Cove
North Tonawanda vacation homes, rent house North Tonawanda, and home rentals in North Tonawanda New York
Vacation rental in Fishkill New York, houses for rent in Fishkill New York, for rent by owner homes Fishkill, and rental home
Bed and breakfast rentals and apartments for rent in Ramapo
Homes for rent in Clarkstown New York, homes for rent in Clarkstown, and condo rentals in Clarkstown
Cortland real estate rentals, vacation homes in Cortland New York, vacation homes in Cortland, and apartment rentals in Cortland New York
Yonkers rental properties and vacation homes for rent by owner
Espy, observe, and ascertain apartments for rent in Yates New York and Yates homes for rent by owner.
Owego New York is a bewitching and dazzling field with fascinating, angelic, and pulchritudinous farmhouse, houseboat, townhouse, and apartments.
Glimpse and look up Hamilton real estate rentals, rental homes Hamilton, and homes for rent Hamilton.
Inaugurate your pursual online on Sunday, this week, on Monday, or day after tomorrow for your holiday rentals in Owego, vacation rentals in Owego New York, and rental properties.
Originate and locate condos for rent in Parksville United States and Parksville rental properties.
Owego condo owners, real estate brokers, agents serving the condo market, and property brokers list Owego New York apartment rentals and rental homes Owego.
Notice, come across, and conceive rental home Warren New York and Warren rent houses.
Unoccupied beach cottage, exotic flat, and romantic villa are immediate in the not far away kingdom of Owego New York.
Look up, discern, and notice the locality and not to distant Owego New York territory.
Come across and dig up rent house in Wells and Wells United States vacation rental.
Disclose specific and various documents in Owego New York and note rental houses Owego New York.
Owego domain employs many town home owners and real estate agents.
Glimpse, design, and catch Westons Mills United States rental homes, rental home Westons Mills, and vacation rental in Westons Mills.
Periodically, stump, work with, bail out, and hype your collegiates and locals to a fascinating, chock-full, and magnetic county.
Contrive and come upon East Durham United States holiday rentals and rent house in East Durham United States.
Elicit and elicit homes for rent by owner Stittville United States and apartment rentals in Stittville United States.
Identify and ferret out house rentals in Otsego New York and vacation rentals in Otsego New York.
Catch and perceive house rentals in Delaware New York, Delaware New York rental properties, Delaware New York apartment rentals, and Delaware New York homes for rent.
Initiate, induct, and procure this weekend to get cracking, lead off, kick off, and kick off on this traveling.
The Owego classified ads set down and written down on our page hold mountain hacienda, beachfront chalet, and lake hacienda.
Owego New York results could do for, relieve, benefit, and assist your frisking.
Using our webpage, property owners particularize castle and villa advertisements.
Determine, find out, and identify rent houses, Geneseo short term rentals, and Geneseo vacation rentals.
Send admirable, cute, splendid, and pleasing statistics regarding vacation rentals Owego New York and apartments for rent in Owego New York found on this extensive website, FRBO.com.
Convenient listed properties and exclusive classified advertisements Orleans New York vacation homes, Orleans New York holiday rentals, house rentals Orleans New York, and bed and breakfast rentals Orleans.
|
|
