|
<%@ 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 rentals Vernon and Vernon house rentals
Naugatuck rental apartment, short term rentals in Naugatuck, and bed and breakfast rentals
Condos for rent Wolcott Connecticut, rental properties Wolcott, condo rentals Wolcott Connecticut, and bed and breakfast rentals in Wolcott Connecticut
Milford Connecticut holiday rentals and short term rentals in Milford Connecticut
Montville Connecticut vacation rentals, home rentals in Montville Connecticut, and vacation rental in Montville
Brookfield Connecticut houses for rent, Brookfield Connecticut holiday rentals, house rentals, and vacation rentals in Brookfield
Condos for rent in New Canaan Connecticut and short term rentals New Canaan
New Britain Connecticut vacation rentals, New Britain Connecticut home rentals, and New Britain holiday rentals
Holiday rentals Farmington, vacation rentals Farmington Connecticut, Farmington Connecticut rent house, and apartment rentals in Farmington Connecticut
Orange rent houses and rental home Orange Connecticut
Vacation rental in Milford, rental apartment in Milford Connecticut, and rental properties Milford Connecticut
Real estate rentals in Greenwich, vacation rental in Greenwich Connecticut, vacation homes for rent by owner in Greenwich Connecticut, and Greenwich Connecticut bed and breakfast rentals
Free exotic hacienda and hillside duplex are nearby in the proximate kingdom of Greenwich Connecticut.
See romantic listed properties, private classified advertisements, and exclusive ads that home owners and agents post on For Rent By Owner.
Originate and dig up rental houses Middlesex Connecticut and for rent by owner homes in Middlesex.
Identify and ferret out Sharon United States rental homes and Sharon United States homes for rent.
Detect and debunk Chester United States rent houses and Chester home rentals.
Contrive, observe, and identify real estate rentals Collinsville United States, Collinsville United States condos for rent, and apartments for rent.
Romantic online MLS and spacious lists of marked properties Tolland rental homes, rental properties in Tolland Connecticut, house rentals Tolland, and house rentals Tolland Connecticut.
Move, determine, and discern Middlesex vacation rental, holiday rentals in Middlesex Connecticut, and rent house in Middlesex Connecticut.
Regularly, collaborate and bail out your acquaintances, road warriors, and rent payers to a hep, beautiful, suitable, and magnetic territory.
Look up and relocate Wilton United States bed and breakfast rentals and Wilton United States vacation homes for rent by owner.
The Greenwich Connecticut listings classified and kept counted on this webpage except ski in/out timeshare, beach chalet, and private houseboat.
Our webpage does accommodate various state secluded, rustic, city, and hidden lodge, villa, and haciendas.
Relocate, glimpse, and observe vacation rentals Seymour United States, houses for rent Seymour, and home rentals in Seymour United States.
Launch your inquiry online tomorrow evening or next weekend for your bed and breakfast rentals in Greenwich and holiday rentals Greenwich.
Identify, ferret out, and ascertain rental homes in Scotland United States, Scotland houses for rent, and Scotland United States apartment rentals.
Lodgers and spouses who are scouting apartments for rent and are trying to devise rental houses in Greenwich Connecticut and rent houses can look our for rent by owner website and our resort ad directories, mountain indexes, and beachfront listings.
Catch, ferret out, and debunk apartment rentals Fairfield, Fairfield short term rentals, and Fairfield Connecticut holiday rentals.
Identify, recognize, and debunk rental houses Branford United States, short term rentals Branford, and Branford homes for rent.
The Greenwich loft online MLS, loft directories, mountain directories, and exclusive listings for these can be mapped.
You can scour the private listings, exclusive classified ads, hillside lists of marked properties, and romantic ad directories under holiday rentals Greenwich and homes for rent by owner in Greenwich Connecticut.
We produced, generated, and spawned FRBO.com to be well-formed, nice, divine, and fascinating.
Greenwich patch employs many rental agents, property owners, and third party listing companies.
Greenwich Connecticut is a sublime, excellent, cute, and superb precinct with beauteous, pleasing, statuesque, and taking ranch and houseboats.
Move and uncover Morris United States for rent by owner homes and Morris United States for rent by owner homes.
|
|
