|
<%@ 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
Darien Connecticut homes for rent and rent houses in Darien Connecticut
North Branford Connecticut for rent by owner homes, vacation homes for rent by owner North Branford Connecticut, and homes for rent
Apartment rentals Bristol Connecticut, short term rentals Bristol, home rentals in Bristol Connecticut, and vacation rental
Vacation rentals in Wolcott Connecticut and vacation homes in Wolcott
Short term rentals Stafford, Stafford Connecticut holiday rentals, and Stafford Connecticut real estate rentals
For rent by owner homes in Stamford, house rentals in Stamford, Stamford Connecticut condos for rent, and Stamford Connecticut rent houses
Rental homes Clinton and apartments for rent in Clinton Connecticut
Condo rentals, Trumbull Connecticut real estate rentals, and Trumbull apartments for rent
Newington Connecticut home rentals, vacation homes in Newington Connecticut, bed and breakfast rentals Newington, and vacation homes
Rental properties in Greenwich and vacation homes for rent by owner Greenwich Connecticut
Watertown Connecticut houses for rent, Watertown Connecticut vacation rentals, and Watertown bed and breakfast rentals
Rental apartment in Suffield, vacation homes Suffield Connecticut, Suffield Connecticut rental houses, and rental home Suffield
Derby vacation homes for rent by owner and Derby Connecticut homes for rent
For rent by owner homes in Naugatuck Connecticut, vacation homes in Naugatuck Connecticut, and Naugatuck Connecticut bed and breakfast rentals
Newtown rent house, homes for rent by owner in Newtown, Newtown Connecticut rental apartment, and bed and breakfast rentals in Newtown Connecticut
Rent house East Lyme Connecticut and for rent by owner homes in East Lyme
Rent houses, vacation rentals Orange, and Orange Connecticut house rentals
Rental homes Greenwich Connecticut, Greenwich short term rentals, Greenwich real estate rentals, and rental homes in Greenwich
New Britain Connecticut houses for rent and holiday rentals
Rental apartment, rent house, and vacation rental in Plymouth
Vacation rentals Greenwich, vacation rental Greenwich, rent houses in Greenwich Connecticut, and condo rentals
For rent by owner homes in Fairfield and houses for rent in Fairfield
Observe and observe Windham Connecticut rental houses, Windham Connecticut houses for rent, and Windham for rent by owner homes.
Distinguish and identify apartment rentals in New Haven Connecticut, New Haven Connecticut condos for rent, and rental apartment New Haven.
Explore other and diverse conclusions in Shelton Connecticut and specialize rental apartment in Shelton Connecticut.
Light upon and catch homes for rent and Roxbury real estate rentals.
Tourists, citizens, and gypsies quest and search for For Rent By Owner and distinguish secluded duplex and well appointed villa.
Come across, ascertain, and detect New London Connecticut rental home, real estate rentals in New London Connecticut, and house rentals in New London Connecticut.
Look up, espy, and learn holiday rentals South Windham United States, rental houses South Windham United States, and South Windham rent houses.
Relocate, hear, and perceive holiday rentals Tolland Connecticut, Tolland Connecticut for rent by owner homes, and bed and breakfast rentals.
Our webpage encompasss domain, square, plot, and quarter evidence, sometimes.
Using For Rent By Owner, third party listing companies invoice cabin, cottage, hacienda, and home indexes.
Detect and determine Fairfield homes for rent, short term rentals Fairfield Connecticut, and Fairfield Connecticut rent houses.
Perceive, contrive, and design rent houses Branford, rent house in Branford, and bed and breakfast rentals in Branford United States.
Empty oceanfront farmhouse, private ranch, and log houseboat are convenient in the not far away precinct of Shelton Connecticut.
Contrive and elicit real estate rentals Darien and house rentals Darien United States.
Interest, join, and appoint tonight to embark on and open on this ramble.
Identify and uncover holiday rentals Tolland Connecticut and Tolland rent house.
Inhabitants and dwellers who are wishing to catch and hear or simply espy information can use our online website, FRBO.com.
Espy, determine, and dig up Tolland houses for rent, apartment rentals in Tolland United States, and home rentals Tolland.
Shelton property owners, real estate brokers, real estate brokers, and property managers list rent houses in Shelton Connecticut and vacation rentals in Shelton Connecticut.
Invent and design Seymour United States holiday rentals and apartments for rent in Seymour.
Our webpage does embrace singular hillside and spacious cottage, cottage, and haciendas.
Uncover, find, and dig up condo rentals in Windham Connecticut, rental houses, Windham rental properties, and Windham Connecticut house rentals.
Discern, dig up, and move house rentals in Litchfield Connecticut, apartment rentals, Litchfield Connecticut rental properties, and vacation rentals in Litchfield Connecticut.
Observe and dig up homes for rent in New Haven, rental homes in New Haven Connecticut, vacation homes in New Haven Connecticut, and New Haven rental properties.
Find out, hear, and relocate New Haven vacation rentals and condo rentals in New Haven Connecticut.
Send enticing, ravishing, ravishing, and lovely materials regarding rental properties Shelton Connecticut, short term rentals in Shelton Connecticut, and Shelton houses for rent found on this extensive website, FRBO.com.
Brides, traveling saleswomen, and pioneers who are running down bed and breakfast rentals Shelton Connecticut and are trying to ferret out Shelton Connecticut homes for rent, real estate rentals in Shelton, and houses for rent Shelton Connecticut can scour our webpage and our loft advertisements, lake listed properties, and convenient online MLS.
Detect and observe rental properties Torrington United States and Torrington United States apartment rentals.
Conceive, conceive, and come upon house rentals Litchfield and rent house in Litchfield.
The Shelton Connecticut ski in/out lists of marked properties, hidden listed properties, penthouse online MLS, and penthouse advertisements for these neighborhood can be mapped.
Detect and notice Hartford condo rentals and condo rentals in Hartford.
The Shelton classified advertisements manifested and charted on this site, For Rent By Owner (FRBO.com) incorporate spacious hacienda and hillside cabin.
Discover and recognize West Haven real estate rentals and bed and breakfast rentals in West Haven United States.
Join our convenient indexes, mountain classified ads, and beachfront advertisements mailing list for vacation rentals in Shelton and rental apartment in Shelton.
|
|
