|
<%@ 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
Middletown house rentals and holiday rentals in Middletown Connecticut
Meriden vacation homes, Meriden Connecticut house rentals, and Meriden Connecticut rental home
Cheshire Connecticut vacation homes, bed and breakfast rentals in Cheshire, house rentals in Cheshire Connecticut, and homes for rent by owner
Apartment rentals Derby and apartment rentals in Derby Connecticut
Rent houses Meriden Connecticut, vacation homes in Meriden Connecticut, and house rentals Meriden
Southington vacation homes for rent by owner, rent house in Southington Connecticut, homes for rent, and vacation rental Southington
Home rentals and condo rentals in New London Connecticut
Glastonbury Connecticut rental apartment, Glastonbury Connecticut vacation rentals, and vacation rental in Glastonbury
Rental houses in Guilford Connecticut, homes for rent in Guilford, rental apartment in Guilford, and Guilford Connecticut home rentals
For rent by owner homes Rocky Hill and vacation homes in Rocky Hill Connecticut
Derby real estate investors, rental agents, real estate investors, and home owners list vacation homes in Derby, Derby Connecticut rental home, Derby Connecticut vacation homes for rent by owner, and condo rentals in Derby Connecticut.
Derby testimony could assist, run interference, and ride shotgun your frisking.
Derby Connecticut is a grand, good-looking, refined, and shapely square with good-looking, refined, and excellent villa, farmhouse, ranch, and houses.
The Derby classifieds posted and enrolled on our website, FRBO.com comprehend romantic farmhouse, oceanfront flat, and waterfront vacation home.
Explore and notice Old Mystic United States rental properties and vacation homes for rent by owner in Old Mystic United States.
Locals and comrades scour, look for, and smell around this website, FRBO.com and ascertain beach houseboat, exotic cottage, secluded villa, and beach castle.
You can comb the penthouse online MLS, lakeside indexes, lakefront listings, and waterfront listed properties under houses for rent in Derby Connecticut and condos for rent Derby Connecticut.
Dig up and conceive Fairfield Connecticut home rentals, Fairfield Connecticut homes for rent, and Fairfield homes for rent by owner.
Locate and espy homes for rent by owner and bed and breakfast rentals in Old Lyme.
Uncover and determine the sector and abutting Derby Connecticut zone.
Recognize, locate, and debunk Stevenson United States rent houses, real estate rentals, and vacation homes for rent by owner in Stevenson United States.
Soon to be vacant hidden hacienda, mountain timeshare, beachfront flat, and lakefront home are adjoining in the not far parcel of Derby Connecticut.
Using For Rent By Owner, third party listing companies book home and castle ads.
|
|
