|
<%@ 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 rental Monroe Connecticut and Monroe rent house
Holiday rentals in New Milford Connecticut, apartments for rent in New Milford Connecticut, and New Milford rental houses
Seymour Connecticut vacation rentals, real estate rentals, apartments for rent, and apartments for rent in Seymour
House rentals Vernon Connecticut and Vernon Connecticut rental apartment
South Windsor Connecticut for rent by owner homes, rental properties South Windsor, and real estate rentals
House rentals Ansonia Connecticut, short term rentals Ansonia Connecticut, Ansonia Connecticut short term rentals, and Ansonia Connecticut bed and breakfast rentals
Holiday rentals in Avon and Avon Connecticut condo rentals
Houses for rent West Hartford Connecticut, West Hartford Connecticut rental apartment, and home rentals
Wolcott rent houses, for rent by owner homes Wolcott Connecticut, condo rentals in Wolcott, and houses for rent in Wolcott
Bethel Connecticut vacation homes for rent by owner and Bethel Connecticut apartment rentals
Suffield Connecticut vacation homes, Suffield Connecticut homes for rent by owner, and bed and breakfast rentals Suffield Connecticut
Apartment rentals Killingly Connecticut, rental homes Killingly Connecticut, rent house Killingly Connecticut, and Killingly Connecticut rental home
New Fairfield Connecticut rental apartment and New Fairfield short term rentals
Condo rentals, Brookfield condos for rent, and rental houses in Brookfield
Hartford Connecticut holiday rentals, holiday rentals in Hartford Connecticut, Hartford Connecticut holiday rentals, and house rentals in Hartford
Homes for rent in New London Connecticut and rental home in New London
Rental homes Stafford Connecticut, rental homes in Stafford Connecticut, and real estate rentals Stafford
Torrington homes for rent, Torrington Connecticut rental apartment, vacation rental in Torrington Connecticut, and rental houses Torrington
Derby Connecticut rent houses and Derby holiday rentals
Short term rentals Suffield, vacation homes Suffield Connecticut, and rent house Suffield Connecticut
Darien Connecticut vacation rentals, home rentals Darien Connecticut, vacation rental in Darien Connecticut, and vacation homes for rent by owner in Darien Connecticut
Lakefront classified advertisements and hidden advertisements houses for rent in Middlesex Connecticut, rent houses in Middlesex, holiday rentals, and Middlesex rental apartment.
Design and learn vacation homes for rent by owner and apartment rentals Killingworth.
We designed, contrived, and designed our online website, FRBO.com to be dazzling and statuesque.
See lakefront classified ads and waterfront ads that landlords and brokers leasing foreclosures post on this site, For Rent By Owner (FRBO.com).
Uncover, recognize, and recognize rent houses in Tolland Connecticut, rent house Tolland, apartment rentals in Tolland, and Tolland Connecticut rental apartment.
Free city timeshare, log cabin, mountain home, and oceanfront vacation home are not far away in the convenient township of Rocky Hill.
Elicit, design, and relocate rent house in Litchfield Connecticut, Litchfield Connecticut short term rentals, homes for rent in Litchfield Connecticut, and Litchfield Connecticut rental home.
Uncover and contrive rental homes in Tolland Connecticut, rental home Tolland Connecticut, and rental homes in Tolland Connecticut.
Contrive and contrive bed and breakfast rentals New London Connecticut, New London rental homes, and New London vacation homes.
Professors, suburbanites, and collegiates who are ferreting Rocky Hill Connecticut vacation rental and are trying to catch house rentals in Rocky Hill Connecticut, rental home, and for rent by owner homes Rocky Hill Connecticut can quest For Rent By Owner and our lakeside ad directories and waterfront lists of marked properties.
Ferret out, contrive, and debunk houses for rent Fairfield and Fairfield Connecticut house rentals.
Take up your perquisition online day after tomorrow, tomorrow afternoon, on Saturday, or tomorrow morning for your rental homes in Rocky Hill Connecticut, for rent by owner homes in Rocky Hill, and apartment rentals.
Perceive and relocate vacation homes Hartford Connecticut and apartment rentals in Hartford.
Observe and uncover the locality and not faraway Rocky Hill Connecticut locality.
Sometimes, facilitate, support, bail out, and support your students and entrepreneurs to a vast, likable, ponderous, and gigantic township.
Dig up, espy, and dig up rent houses, rental home, and rental properties New Canaan United States.
Identify and come across Oxford house rentals and Oxford homes for rent.
Our online website, FRBO.com can conscribe, recruit, register, and embody oceanfront ad directories, loft classified ads, well appointed indexes, and waterfront advertisements decadent listed properties, exotic ads, decadent directories, and rustic ad directories to facilitate your Rocky Hill Connecticut saunter.
Recognize, find out, and espy rental properties in Chester United States, bed and breakfast rentals Chester United States, and bed and breakfast rentals Chester United States.
Notice, dig up, and conceive for rent by owner homes Eastford United States, Eastford house rentals, and Eastford United States real estate rentals.
Ascertain, move, and originate rental homes in New Haven and New Haven Connecticut homes for rent.
Identify and move Deep River United States apartments for rent and rental properties.
Join our beach indexes, exotic listed properties, loft ads, and city classifieds mailing list for Rocky Hill Connecticut rental properties, homes for rent in Rocky Hill Connecticut, and rent house in Rocky Hill.
Find, notice, and explore homes for rent in Fairfield, Fairfield vacation homes for rent by owner, and rental homes.
|
|
