|
<%@ 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" %>
|
Connecticut Rental Links
Vacation homes for rent by owner Wallingford and Wallingford Connecticut vacation rental
Rental properties in South Windsor Connecticut, homes for rent by owner South Windsor, and home rentals in South Windsor Connecticut
Vacation rentals in Greenwich Connecticut, Greenwich short term rentals, rental houses Greenwich, and vacation rental in Greenwich Connecticut
Old Saybrook home rentals and rent houses in Old Saybrook
Apartment rentals Killingly Connecticut, Killingly houses for rent, and Killingly Connecticut bed and breakfast rentals
Rental homes Cromwell Connecticut, vacation rental in Cromwell Connecticut, houses for rent in Cromwell, and rental homes
Vacation homes in New Britain Connecticut and apartment rentals in New Britain
Berlin Connecticut rental apartment, Berlin Connecticut apartment rentals, and Berlin house rentals
Weston Connecticut vacation homes, Weston Connecticut for rent by owner homes, holiday rentals in Weston, and bed and breakfast rentals in Weston
East Hampton Connecticut vacation rental and houses for rent East Hampton
New London vacation rentals, New London rental homes, and holiday rentals New London
Find and recognize rental houses in Scotland United States and condos for rent Scotland United States.
Danbury rental property owners and agents serving the condo market list houses for rent in Danbury and rent house in Danbury Connecticut.
Join our convenient classified ads, resort classified ads, and studio listed properties mailing list for house rentals Danbury and real estate rentals Danbury.
Identify and perceive Terryville homes for rent by owner and Terryville United States condo rentals.
Glimpse and discover vacation homes and rent house W Hartford United States.
Distinguish, uncover, and espy short term rentals in Mansfield Depot, home rentals in Mansfield Depot, and rent houses Mansfield Depot.
Get cracking your research online on Thursday or this evening for your vacation rentals, rental homes Danbury Connecticut, and rent house Danbury.
Invent, contrive, and move the stretch and nearly Danbury Connecticut area.
We parented and reared this website, FRBO.com to be delightful, beauteous, and gorgeous.
Explore and notice home rentals Windham Connecticut, rental home in Windham, real estate rentals in Windham Connecticut, and vacation homes in Windham Connecticut.
See waterfront classified ads, spacious listings, lake directories, and oceanfront ad directories that property owners and real estate brokers post on this website, FRBO.com.
Find, hear, and invent Fairfield apartment rentals, bed and breakfast rentals, and rental homes Fairfield Connecticut.
Danbury facts could push, cooperate, and back your scrutiny.
The Danbury Connecticut mountain ad directories, spacious listed properties, beach directories, and waterfront advertisements for these quarter can be mapped.
Ramblers, sailors, and expeditionists scan and scrutinize our online website, FRBO.com and elicit studio vacation home and suburban townhouse.
Send stunning and magnificent conclusions regarding Danbury Connecticut holiday rentals and holiday rentals in Danbury Connecticut found on our page.
|
|
