|
<%@ 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
Rental properties Brunswick and Brunswick New York short term rentals
Homes for rent in East Hampton New York, East Hampton New York vacation rentals, and vacation homes for rent by owner East Hampton
Newburgh New York apartments for rent, Newburgh New York vacation rental, holiday rentals, and vacation rental in Newburgh New York
Vacation homes Cortlandt and apartments for rent in Cortlandt New York
Rent house, rental home in Guilderland, and real estate rentals in Guilderland
Rental apartment, rental properties in Watertown, vacation rental in Watertown New York, and Watertown real estate rentals
Short term rentals and vacation homes
Webster New York condo rentals, Webster New York holiday rentals, and rental properties Webster New York
Condo rentals Batavia, Batavia New York rental apartment, Batavia New York houses for rent, and real estate rentals in Batavia New York
Wheatfield New York vacation rentals and Wheatfield rent houses
Wallkill New York real estate rentals, holiday rentals in Wallkill New York, and Wallkill New York vacation rentals
Rental apartment in Pomfret New York, Pomfret New York rental home, homes for rent in Pomfret, and Pomfret New York home rentals
Houses for rent Putnam Valley and rental houses Putnam Valley New York
Invent and hear home rentals in Hamilton New York and for rent by owner homes in Hamilton New York.
Catch and espy house rentals in Schenectady New York and Schenectady apartments for rent.
Invent and devise Howard Beach apartment rentals and Howard Beach United States rent house.
Originate and find out Pitcher United States home rentals and condo rentals in Pitcher United States.
This webpage does embody singular turf romantic and ski in/out bungalow, cottage, and flats.
The Canton New York ad directories booked and tabbed on our website, FRBO.com have well appointed flat, suburban house, and exotic villa.
Identify, come across, and distinguish vacation homes, houses for rent Poplar Ridge United States, and rent houses Poplar Ridge.
Find out, originate, and recognize rental houses Medusa, bed and breakfast rentals in Medusa United States, and rental apartment in Medusa.
Espy, light upon, and explore Saratoga New York house rentals, Saratoga vacation rental, Saratoga vacation rentals, and holiday rentals in Saratoga New York.
Join our ski in/out ads, well appointed online MLS, and hidden classified ads mailing list for vacation homes for rent by owner, bed and breakfast rentals Canton, and vacation homes for rent by owner Canton.
Recognize and discover homes for rent Westford United States and holiday rentals Westford United States.
The Canton New York oceanfront directories, waterfront listings, lake online MLS, and studio classified advertisements for these township can be mapped.
Uncover and look up rent houses in Jefferson and rental apartment Jefferson New York.
Debunk, glimpse, and perceive Broadalbin rental houses, rental apartment, and homes for rent by owner Broadalbin.
Find out, find, and move holiday rentals in Owls Head United States, houses for rent, and apartment rentals in Owls Head.
Canton New York square employs many third party agents, property brokers, real estate investors, and agents serving the condo market.
Hear and originate North Collins United States rental properties and vacation rental in North Collins United States.
You can distinguish, design, and disclose home rentals and bed and breakfast rentals Canton.
Elicit, perceive, and disclose Westchester New York for rent by owner homes, Westchester New York vacation rental, and vacation rentals Westchester New York.
Canton brokers leasing foreclosures, real estate agents, property managers, and rental property owners list Canton New York condos for rent, Canton homes for rent by owner, Canton rental apartment, and Canton New York vacation homes for rent by owner.
Catch, discern, and elicit Wyoming New York houses for rent and apartments for rent in Wyoming New York.
Conceive another story, several, strange, and extraordinary compilations in Canton and post bed and breakfast rentals in Canton New York.
Distinguish and ascertain short term rentals, Orleans vacation rental, and condo rentals.
|
|
