|
<%@ 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
Southbury Connecticut homes for rent by owner and Southbury houses for rent
Naugatuck Connecticut houses for rent, real estate rentals in Naugatuck Connecticut, and Naugatuck Connecticut houses for rent
Rental apartment in Glastonbury Connecticut, Glastonbury houses for rent, short term rentals in Glastonbury Connecticut, and holiday rentals
Homes for rent by owner in Avon Connecticut and house rentals in Avon Connecticut
Rental apartment North Branford, homes for rent in North Branford, and North Branford rental home
New London Connecticut rental apartment, vacation rental, apartments for rent, and rental properties New London
Shelton house rentals and home rentals
Vacation homes, Tolland vacation rentals, and Tolland Connecticut bed and breakfast rentals
Vacation rental in New Britain, short term rentals, New Britain Connecticut rental home, and rental houses in New Britain Connecticut
Homes for rent by owner in Trumbull Connecticut and real estate rentals in Trumbull Connecticut
Home rentals, houses for rent Branford, and rental apartment Branford
Ferret out and glimpse rental houses, rental houses in Litchfield Connecticut, and apartments for rent in Litchfield.
Find out and find out Essex rent house and houses for rent in Essex United States.
The New London directories enumerated and written down on our site, FRBO.com embrace hidden house, loft chalet, hidden ranch, and spacious vacation home.
Launch your fishing expedition online now, this evening, or on Friday for your New London Connecticut rental apartment and New London Connecticut house rentals.
Relocate, originate, and find out apartment rentals Tolland, Tolland rental apartment, and Tolland rental apartment.
Design and devise vacation homes for rent by owner in Fairfield Connecticut, house rentals in Fairfield Connecticut, and apartment rentals Fairfield Connecticut.
Learn, move, and elicit homes for rent by owner in Canton, Canton United States houses for rent, and house rentals in Canton United States.
Disclose and relocate New Haven Connecticut rental properties and condo rentals New Haven.
Perceive, uncover, and light upon New Haven rent house, New Haven Connecticut apartment rentals, and New Haven Connecticut for rent by owner homes.
Hear, discern, and light upon rental home and apartments for rent.
Draft, procure, and recruit this weekend to inaugurate, kick off, take up, and initiate on this visit.
Convenient lists of marked properties and mountain classified ads short term rentals in New London Connecticut, rental houses in New London, bed and breakfast rentals New London, and condos for rent New London Connecticut.
Join our oceanfront ads, resort directories, ski in/out classifieds, and secluded classified advertisements mailing list for New London Connecticut rent houses, real estate rentals New London, and vacation homes for rent by owner New London Connecticut.
Residents, possessors, and occupiers examine, explore, and look over this extensive website, FRBO.com and hear lakefront apartment, private chalet, romantic hacienda, and rustic apartment.
Empty private lodge and lakefront villa are proximate in the handy section of New London.
The New London Connecticut waterfront lists of marked properties, studio listed properties, exclusive ad directories, and private classified advertisements for these can be mapped.
Ferret out and devise holiday rentals, vacation rentals Middlesex Connecticut, vacation homes for rent by owner, and rental houses Middlesex.
Send divine, appealing, and dazzling conclusions regarding rental apartment, New London Connecticut holiday rentals, and New London Connecticut short term rentals found on this webpage.
|
|
