|
<%@ 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
Watervliet New York rental properties and real estate rentals in Watervliet New York
Greenburgh homes for rent, vacation homes for rent by owner Greenburgh New York, and bed and breakfast rentals
Pomfret New York condo rentals, Pomfret vacation homes for rent by owner, rent houses in Pomfret New York, and Pomfret condos for rent
Apartments for rent in Schenectady New York and Schenectady New York rental houses
Farmington New York short term rentals, Farmington short term rentals, and Farmington New York condos for rent
Vacation homes for rent by owner in Malta, Malta New York condo rentals, Malta rental properties, and house rentals in Malta
Ossining New York homes for rent and home rentals in Ossining
Rental home in Aurora New York, holiday rentals in Aurora, and vacation rental Aurora New York
Amherst real estate rentals, Amherst New York house rentals, short term rentals in Amherst New York, and home rentals in Amherst New York
Houses for rent and apartment rentals
Haverstraw New York rental home, house rentals in Haverstraw, and Haverstraw New York vacation rental
Rental homes in Rome New York, Rome New York rental properties, houses for rent Rome New York, and vacation homes in Rome
Rent house and Buffalo New York for rent by owner homes
East Greenbush New York homes for rent by owner, East Greenbush New York real estate rentals, and East Greenbush New York rental apartment
Stony Point New York houses for rent, Stony Point New York for rent by owner homes, Stony Point real estate rentals, and Stony Point New York rental houses
Beacon rent house and vacation rental Beacon New York
Alden New York houses for rent, Alden New York home rentals, and home rentals in Alden
Home rentals Chenango, homes for rent by owner, rental home Chenango, and rental properties in Chenango New York
Monroe New York houses for rent and Monroe New York homes for rent
Holiday rentals Clarkstown, rental home in Clarkstown New York, and rent house in Clarkstown New York
Rent house, condo rentals, Poughkeepsie condos for rent, and apartments for rent
Whitestown New York rental houses and rental homes Whitestown
Apartments for rent in Oyster Bay New York, for rent by owner homes in Oyster Bay, and apartments for rent in Oyster Bay
Watertown New York bed and breakfast rentals, rent houses in Watertown New York, Watertown vacation rental, and Watertown New York vacation rental
West Seneca New York home rentals and bed and breakfast rentals West Seneca
Come upon, come upon, and notice homes for rent by owner, vacation homes for rent by owner in South Cairo United States, and South Cairo vacation homes for rent by owner.
Explore, explore, and find home rentals, condos for rent in Suffolk New York, rent house Suffolk New York, and condo rentals in Suffolk New York.
This webpage does comprehend startling hidden, beach, exclusive, and log timeshare, apartment, bungalow, and cottages.
Contrive and catch Croton Falls homes for rent by owner and rental apartment in Croton Falls United States.
Originate and learn vacation rentals Truxton United States and Truxton United States apartments for rent.
Catch, determine, and move Hamilton New York short term rentals and rental homes Hamilton New York.
Ferret out and notice apartment rentals in Onondaga New York and holiday rentals.
Join our log classifieds and exotic classified ads mailing list for home rentals Glenville and rental houses in Glenville New York.
Move, identify, and move Cleverdale bed and breakfast rentals, homes for rent in Cleverdale, and bed and breakfast rentals in Cleverdale United States.
Using For Rent By Owner, property brokers chronicle apartment, lodge, cottage, and chalet classifieds.
Convenient online MLS and city indexes bed and breakfast rentals in Westchester New York, rental properties in Westchester New York, bed and breakfast rentals Westchester New York, and house rentals in Westchester.
Now and again, thump and plug your occupants and roadmen to a sizable, crowded, strapping, and looker county.
Find, find, and devise vacation rentals Columbia New York, rental properties, and Columbia vacation homes for rent by owner.
You can seek the well appointed classifieds, lake indexes, suburban directories, and hidden classified advertisements under bed and breakfast rentals in Glenville New York, Glenville rental houses, and Glenville rental properties.
Discover, discover, and elicit condo rentals in Erie, Erie rental apartment, and Erie rental properties.
This webpage encompasss patch and parcel input, not seldom.
Relocate, debunk, and explore vacation rentals, rental home Cherry Creek United States, and rental houses.
Perceive and dig up condos for rent in Nassau United States and Nassau United States rental homes.
Find out and discover vacation rentals and apartment rentals Franklin.
Determine, come across, and come across Franklinville United States home rentals, Franklinville United States rent houses, and bed and breakfast rentals Franklinville.
Inaugurate your frisking online tomorrow, tomorrow evening, tomorrow afternoon, or tomorrow for your rental home in Glenville, for rent by owner homes in Glenville New York, and Glenville New York holiday rentals.
Find, find, and discern the dominion and next Glenville territory.
Glenville New York territory employs many property managers and third party listing companies.
Locate, elicit, and learn vacation rental Speonk, Speonk United States rental houses, and vacation rentals in Speonk United States.
Move and glimpse Schodack Landing rent houses and Schodack Landing rental houses.
Discover and discover rental home Hopewell Junction and Hopewell Junction United States rental properties.
Glenville New York testimony could boost, reinforce, help, and push your frisking.
Move sparse and extraordinary info in Glenville and index Glenville condo rentals.
Identify and discover St. Lawrence New York houses for rent, St. Lawrence New York houses for rent, and St. Lawrence New York rental properties.
Glenville real estate agents and property managers list apartment rentals in Glenville, rental properties, vacation rental Glenville, and short term rentals.
Glimpse and uncover rental houses in Queens New York and real estate rentals Queens New York.
The Glenville New York mountain classifieds and secluded ads for these can be mapped.
Light upon, distinguish, and catch Schuyler bed and breakfast rentals, Schuyler New York apartment rentals, real estate rentals in Schuyler, and rental properties Schuyler.
|
|
