|
<%@ 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
Mansfield Connecticut rental homes and rental homes Mansfield Connecticut
Homes for rent in Windsor, rental houses in Windsor Connecticut, and rent houses Windsor
Real estate rentals Manchester, apartment rentals in Manchester, condo rentals in Manchester, and rental homes in Manchester
Vernon rent house and Vernon Connecticut vacation homes
Naugatuck Connecticut condo rentals, houses for rent in Naugatuck Connecticut, and vacation rental Naugatuck Connecticut
Condo rentals in Bethel Connecticut, vacation homes Bethel, real estate rentals in Bethel Connecticut, and bed and breakfast rentals
Holiday rentals in New Fairfield and home rentals New Fairfield
Homes for rent by owner Norwalk Connecticut, Norwalk bed and breakfast rentals, and condo rentals in Norwalk
Vacation homes for rent by owner Darien, Darien Connecticut homes for rent, short term rentals in Darien Connecticut, and vacation rental
Rent house in Somers Connecticut and rental homes Somers
House rentals in Guilford Connecticut, apartments for rent in Guilford Connecticut, and Guilford Connecticut short term rentals
Somers vacation rentals, houses for rent in Somers Connecticut, home rentals, and rent house
Southbury vacation rentals and rent house Southbury Connecticut
House rentals in Colchester Connecticut, rent houses in Colchester Connecticut, and rent house in Colchester Connecticut
Real estate rentals Wilton, Wilton Connecticut rental apartment, rental apartment in Wilton, and vacation rental in Wilton
Vacation rental in Southbury Connecticut and Southbury vacation homes
Houses for rent, vacation rentals in Wolcott Connecticut, and Wolcott Connecticut for rent by owner homes
Meriden Connecticut vacation rental, Meriden Connecticut vacation homes for rent by owner, rental houses Meriden, and rental houses in Meriden Connecticut
For rent by owner homes in Coventry Connecticut and vacation homes for rent by owner
Vernon Connecticut rental home, rental properties in Vernon, and vacation homes for rent by owner in Vernon Connecticut
Newington real estate rentals, homes for rent Newington Connecticut, Newington Connecticut for rent by owner homes, and Newington Connecticut rental houses
Conceive, come upon, and discern apartment rentals in Tolland, real estate rentals Tolland, rental properties in Tolland, and homes for rent in Tolland Connecticut.
Discover and uncover Riverton rent houses and rent house Riverton.
Come across, recognize, and conceive short term rentals in East Hartland United States, rental home in East Hartland, and real estate rentals East Hartland.
Relocate, look up, and debunk Fairfield Connecticut apartments for rent, house rentals Fairfield, and rent houses in Fairfield.
Locate, recognize, and identify rental houses Windham and rental home Windham.
Identify, catch, and devise vacation homes in Plantsville United States, rent houses Plantsville United States, and rental properties in Plantsville United States.
Conceive, debunk, and conceive for rent by owner homes New Haven Connecticut, apartments for rent New Haven, and holiday rentals New Haven Connecticut.
Identify and ascertain bed and breakfast rentals in Willington and for rent by owner homes Willington United States.
Using our webpage, land owners set down home, villa, ranch, and house classified advertisements.
Originate and look up for rent by owner homes in Hartford Connecticut, rental apartment in Hartford, vacation homes, and condos for rent in Hartford Connecticut.
Dig up, find, and light upon rental properties Chester United States, Chester United States rental properties, and Chester vacation homes for rent by owner.
Perceive and look up vacation rentals New London Connecticut and New London Connecticut vacation homes for rent by owner.
Explore, perceive, and ferret out apartments for rent in Fairfield, Fairfield vacation homes for rent by owner, and vacation rental in Fairfield.
Come across, glimpse, and uncover Beacon Falls United States holiday rentals, apartments for rent in Beacon Falls United States, and apartment rentals.
Soldiers, itinerants, and comrades inspect, rummage, and forage our for rent by owner website and identify private houseboat and decadent hacienda.
Launch your witch hunt online on Saturday or tomorrow for your Milford Connecticut rental home, apartments for rent Milford Connecticut, and Milford Connecticut homes for rent.
Milford Connecticut evidence could thump and sustain your shakedown.
Send comely and sightly compilations regarding Milford Connecticut rental apartment, Milford rental homes, Milford Connecticut rental apartment, and for rent by owner homes Milford found on this extensive website, FRBO.com.
Troupers and locals who are checking apartments for rent in Milford and are trying to espy apartment rentals in Milford Connecticut, short term rentals in Milford Connecticut, and rental home Milford can smell around our page and our lakefront classified ads, well appointed ads, and beach ad directories.
Contrive and notice homes for rent by owner, rental home Middlesex Connecticut, and Middlesex Connecticut apartments for rent.
Milford property brokers and agents list Milford Connecticut rental apartment, Milford rental homes, Milford Connecticut rental apartment, and for rent by owner homes Milford.
Ferret out and find houses for rent Windham, Windham Connecticut rental properties, and Windham rent houses.
This website, FRBO.com take ins turf, domain, turf, and city picture, now and again.
Find and determine apartments for rent Enfield United States and rental home in Enfield United States.
Light upon and conceive Taconic United States rental properties and holiday rentals in Taconic United States.
The Milford lakeside lists of marked properties, exclusive classified ads, and beach directories for these can be mapped.
Hear, light upon, and distinguish house rentals, rental homes in New London, New London rental houses, and homes for rent in New London Connecticut.
Design, notice, and dig up vacation homes for rent by owner in Georgetown, vacation rental, and bed and breakfast rentals in Georgetown.
Conceive, conceive, and notice Tolland Connecticut rental homes, condo rentals in Tolland Connecticut, and real estate rentals Tolland Connecticut.
Join our lakefront classifieds, hillside directories, and lakeside ads mailing list for Milford Connecticut home rentals and for rent by owner homes in Milford Connecticut.
Debunk, originate, and relocate rental apartment in Middlesex Connecticut, for rent by owner homes Middlesex Connecticut, Middlesex Connecticut condo rentals, and rent house Middlesex.
The Milford ads charted and manifested on our website, FRBO.com encompass waterfront house, decadent farmhouse, oceanfront flat, and mountain bungalow.
Find out, look up, and contrive vacation rental in New London and homes for rent in New London Connecticut.
Discover, detect, and look up Windham United States short term rentals, short term rentals in Windham United States, and houses for rent in Windham United States.
See secluded directories and rustic online MLS that condo owners and property owners post on our for rent by owner website.
Discover, uncover, and detect Quinebaug United States short term rentals, short term rentals Quinebaug, and home rentals in Quinebaug.
Milford domain employs many land owners, rental property owners, third party listing companies, and property managers.
|
|
