|
<%@ 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
Rent houses in Newtown Connecticut and Newtown Connecticut rental houses
Vacation rental in Manchester, Manchester rental home, and Manchester Connecticut for rent by owner homes
Stonington Connecticut vacation rental, apartment rentals in Stonington, vacation homes Stonington, and short term rentals Stonington Connecticut
Rental homes and New Canaan home rentals
Rental houses in Clinton, vacation rental Clinton, and Clinton Connecticut bed and breakfast rentals
Vacation homes Norwich, Norwich Connecticut house rentals, home rentals in Norwich Connecticut, and Norwich home rentals
Rental home Ansonia Connecticut and holiday rentals Ansonia
Rent houses Weston Connecticut, houses for rent in Weston, and rental properties in Weston Connecticut
Rental apartment in North Haven Connecticut, house rentals, house rentals North Haven, and North Haven vacation homes for rent by owner
Shelton Connecticut vacation homes for rent by owner and Shelton Connecticut rental home
Rent houses South Windsor, South Windsor Connecticut short term rentals, and holiday rentals South Windsor Connecticut
Rent house in Norwich Connecticut, Norwich Connecticut rental houses, bed and breakfast rentals in Norwich, and vacation rental in Norwich Connecticut
Holiday rentals in Stamford Connecticut and Stamford rental properties
Send taking, fascinating, resplendent, and superb statistics regarding houses for rent in West Hartford, West Hartford Connecticut condos for rent, and vacation rentals in West Hartford Connecticut found on For Rent By Owner.
Find, come across, and light upon rent house and for rent by owner homes New London.
Spouses and habitants who are searching rental home and are trying to notice rent houses in West Hartford Connecticut, West Hartford Connecticut rent house, and rent house in West Hartford can prospect our for rent by owner site, FRBO.com and our rustic classified advertisements, ski in/out directories, and beachfront ads.
Locate and perceive rental houses Tolland, rental properties Tolland, and holiday rentals.
Catch and disclose rental houses Tolland Connecticut and Tolland apartment rentals.
Glimpse and hear holiday rentals in Salem and Salem United States rent houses.
Dig up and catch rental properties in East Granby and houses for rent in East Granby United States.
Determine and move condos for rent and rent house Waterbury.
Locate, identify, and invent rental homes in Windham Connecticut, Windham homes for rent, and house rentals Windham Connecticut.
The West Hartford listings buttoned down and placed on our for rent by owner website exclude hidden condominium, beach vacation home, exclusive houseboat, and lakeside ranch.
Contrive, detect, and find condos for rent, short term rentals New Haven Connecticut, and New Haven Connecticut condo rentals.
Our webpage can enter into, levy, and record studio ads and beach indexes resort listed properties, studio classifieds, log listed properties, and suburban classifieds to puff your West Hartford traverse.
Uncover and find out rental properties in New Haven Connecticut, New Haven Connecticut holiday rentals, vacation rental New Haven Connecticut, and New Haven Connecticut rental home.
Recognize and catch rent house in Plainfield United States and Plainfield United States condo rentals.
Discover and learn vacation rentals and home rentals Fairfield.
|
|
