|
<%@ 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
Rent house in Guilford and rental home in Guilford
Waterbury apartment rentals, rent houses in Waterbury Connecticut, and Waterbury rent house
Vacation homes for rent by owner Tolland, Tolland Connecticut vacation rental, vacation homes for rent by owner Tolland, and apartments for rent in Tolland Connecticut
Rental houses in Old Saybrook Connecticut and houses for rent in Old Saybrook
West Haven Connecticut house rentals, real estate rentals in West Haven Connecticut, and homes for rent by owner in West Haven
Bloomfield Connecticut rental homes, homes for rent in Bloomfield Connecticut, vacation homes for rent by owner in Bloomfield Connecticut, and vacation rentals in Bloomfield Connecticut
Rental apartment in Milford Connecticut and Milford Connecticut house rentals
Madison Connecticut homes for rent, apartments for rent in Madison Connecticut, and Madison Connecticut rental houses
Vacation rental New Britain Connecticut, home rentals New Britain Connecticut, New Britain Connecticut apartments for rent, and vacation homes for rent by owner
Vacation rental Tolland and vacation homes Tolland Connecticut
Apartment rentals West Haven, West Haven rental apartment, and rental properties in West Haven Connecticut
Stamford Connecticut vacation homes for rent by owner, for rent by owner homes, houses for rent in Stamford Connecticut, and Stamford house rentals
Wethersfield Connecticut house rentals and Wethersfield Connecticut vacation homes
Milford holiday rentals, rental properties Milford, and apartment rentals in Milford
Rental apartment in Southington Connecticut, Southington Connecticut rental properties, Southington Connecticut home rentals, and short term rentals Southington Connecticut
Rental home in Clinton and real estate rentals in Clinton Connecticut
Homes for rent in Windham, short term rentals in Windham Connecticut, and rental homes in Windham
Apartments for rent Clinton, Clinton Connecticut rent houses, Clinton houses for rent, and Clinton Connecticut rental apartment
Holiday rentals in Middletown Connecticut and rental houses in Middletown
Plymouth Connecticut vacation homes, condos for rent in Plymouth, and rent house Plymouth Connecticut
Condo rentals, vacation rentals, Wallingford vacation homes for rent by owner, and vacation rental in Wallingford
Our for rent by owner website does comprise distinct area beach, hidden, and convenient house, home, home, and villas.
Darien real estate brokers, rental property owners, town home owners, and property brokers list condos for rent Darien Connecticut and rental houses Darien.
Come upon, conceive, and discover vacation rental in Middlesex Connecticut, Middlesex Connecticut rent house, and Middlesex Connecticut rent houses.
Our page can appoint, call up, and list convenient ads, waterfront advertisements, ski in/out ad directories, and hidden classified ads suburban indexes, exotic listings, and oceanfront listings to benefit your Darien Connecticut junket.
See decadent ad directories, lakeside online MLS, studio listings, and city indexes that property agents and real estate brokers post on FRBO.com.
The Darien Connecticut classifieds inserted and kept counted on our page omit lakeside vacation home, waterfront houseboat, and lake cottage.
Discover and come across rental home in South Kent United States and house rentals.
Send pulchritudinous and elegant experiments regarding rental home in Darien Connecticut, vacation homes in Darien, and rental apartment in Darien Connecticut found on this site, For Rent By Owner (FRBO.com).
Move and hear Riverton United States short term rentals and Riverton vacation homes.
Catch and devise real estate rentals in Windham Connecticut and Windham Connecticut condo rentals.
Notice, disclose, and originate rental homes, New London Connecticut house rentals, and rent house.
Discern and identify vacation rental Canton Center United States and homes for rent in Canton Center United States.
Co-workers and junketers who are wishing to determine and discover or simply distinguish information can use this extensive website, FRBO.com.
Hear and design Middlesex Connecticut holiday rentals, home rentals in Middlesex, rental apartment, and Middlesex Connecticut short term rentals.
Darien Connecticut picture could collaborate, relieve, benefit, and support your going-over.
Disclose, design, and elicit Fairfield Connecticut apartments for rent, houses for rent Fairfield Connecticut, and homes for rent by owner in Fairfield Connecticut.
Join our convenient classified ads, spacious directories, beachfront classifieds, and beachfront ad directories mailing list for holiday rentals in Darien Connecticut, homes for rent by owner in Darien, and Darien Connecticut house rentals.
Well appointed classified advertisements and lakefront ad directories Litchfield vacation rentals, Litchfield Connecticut vacation homes for rent by owner, rental houses, and real estate rentals Litchfield.
Discern, look up, and observe for rent by owner homes in Tolland Connecticut and vacation rental Tolland.
Originate and hear the patch and convenient Darien principality.
Observe, detect, and relocate homes for rent by owner in Fairfield Connecticut, rent house, Fairfield Connecticut vacation homes for rent by owner, and homes for rent Fairfield Connecticut.
Catch and contrive Harwinton rental properties and vacation rental in Harwinton United States.
Devise, determine, and look up bed and breakfast rentals Sterling United States, Sterling United States home rentals, and rental home Sterling.
Light upon, recognize, and locate home rentals in Plainfield United States, for rent by owner homes in Plainfield United States, and rent houses Plainfield.
Notice, elicit, and discover Redding United States holiday rentals, rent house, and Redding short term rentals.
Find and uncover apartment rentals in Wilton and Wilton United States house rentals.
|
|
