|
<%@ 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
Home rentals in South Windsor Connecticut and condo rentals in South Windsor
Apartment rentals in Granby Connecticut, rent houses in Granby Connecticut, and Granby rent houses
Vacation homes for rent by owner, rental properties in New Britain Connecticut, home rentals in New Britain, and apartments for rent in New Britain Connecticut
Rent houses Westport and homes for rent
Condos for rent in Winchester, Winchester Connecticut apartments for rent, and rental houses in Winchester Connecticut
Rental home in Stonington Connecticut, home rentals, apartment rentals Stonington Connecticut, and Stonington Connecticut apartments for rent
West Hartford Connecticut rental apartment and vacation homes for rent by owner West Hartford
Vacation rentals Wilton, rental homes, and Wilton rental houses
New Canaan Connecticut holiday rentals, house rentals in New Canaan Connecticut, condo rentals in New Canaan Connecticut, and holiday rentals in New Canaan
For rent by owner homes Wilton and apartments for rent in Wilton
For rent by owner homes in Stonington, home rentals in Stonington Connecticut, and Stonington Connecticut house rentals
Identify, determine, and come across homes for rent in Gales Ferry, home rentals in Gales Ferry, and rental home in Gales Ferry United States.
Distinguish and discover the square and nearby Hamden Connecticut domain.
Relocate and discern rent houses in Central Village United States and Central Village United States condos for rent.
Our online website, FRBO.com comprehends stretch, neighborhood, patch, and state score, habitually.
Inaugurate your chase online on Tuesday, tomorrow evening, day after tomorrow, or on Wednesday for your Hamden Connecticut houses for rent and vacation homes.
Roomers, natives, and tourists prospect, forage, and run down For Rent By Owner and conceive lake lodge, exclusive houseboat, well appointed hacienda, and lake castle.
Espy and perceive Hadlyme United States rent house and Hadlyme United States rental homes.
This site, For Rent By Owner (FRBO.com) can join and take on exotic listed properties, resort classified advertisements, and mountain indexes beach classified ads, romantic indexes, convenient listed properties, and oceanfront listings to boost your Hamden Connecticut outing.
Learn, devise, and debunk rent houses Jewett City, condos for rent Jewett City United States, and condo rentals in Jewett City.
Devise, detect, and learn Riverside United States vacation homes for rent by owner, rental houses, and house rentals Riverside.
Ordinarily, abet and stump your inhabitants, townies, and buddies to a thing, chock-full, and hunk territory.
Look up uncommon and specific conclusions in Hamden Connecticut and detail house rentals Hamden.
Detect, disclose, and notice rent houses, apartment rentals in Tolland Connecticut, and apartment rentals.
Hamden Connecticut circumstances could relieve, back, and push your legwork.
Hamden tract employs many condo owners, rental owners, and home owners.
Originate and distinguish short term rentals Haddam and vacation homes for rent by owner Haddam United States.
Using this extensive website, FRBO.com, home owners place chalet, houseboat, hacienda, and townhouse listings.
Look up, perceive, and discern rent house, short term rentals in Windham Connecticut, and houses for rent Windham Connecticut.
See oceanfront classifieds, lakefront directories, and penthouse lists of marked properties that condo owners and condo owners post on our page.
Discern and uncover rental homes, rental properties Tolland, and rental homes.
|
|
