|
<%@ 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
Windsor vacation homes for rent by owner and Windsor Connecticut vacation homes
New Milford Connecticut vacation homes for rent by owner, New Milford Connecticut real estate rentals, and home rentals
Rental homes, rental homes in East Hartford Connecticut, East Hartford Connecticut vacation rentals, and rental home East Hartford Connecticut
Houses for rent and rent houses Killingly Connecticut
Apartments for rent in Stafford Connecticut, Stafford home rentals, and Stafford Connecticut home rentals
Condos for rent in South Windsor Connecticut, South Windsor Connecticut bed and breakfast rentals, house rentals in South Windsor, and South Windsor Connecticut homes for rent by owner
New Milford Connecticut rental homes and New Milford vacation rentals
Short term rentals in Plainfield Connecticut, rental houses in Plainfield, and bed and breakfast rentals in Plainfield
Condos for rent in Derby, Derby Connecticut apartment rentals, Derby short term rentals, and houses for rent Derby
Newington Connecticut rental properties and rental houses in Newington Connecticut
House rentals in West Hartford, West Hartford Connecticut home rentals, and apartment rentals West Hartford
Windham Connecticut rental homes, vacation homes in Windham, apartments for rent, and vacation homes for rent by owner in Windham Connecticut
Rocky Hill short term rentals and Rocky Hill Connecticut apartment rentals
Short term rentals, bed and breakfast rentals Brookfield, and rent house Brookfield
Short term rentals in Griswold Connecticut, condo rentals, short term rentals in Griswold Connecticut, and Griswold Connecticut apartments for rent
Condo rentals in Ledyard Connecticut and Ledyard Connecticut real estate rentals
Vacation homes in Stamford, Stamford house rentals, and Stamford Connecticut vacation rentals
Granby Connecticut bed and breakfast rentals, houses for rent in Granby, Granby Connecticut rental homes, and vacation homes Granby
Rental apartment Windsor Locks and condo rentals Windsor Locks
Vacation rental, real estate rentals Groton, and Groton vacation homes
Vacation rentals in Farmington Connecticut, rental apartment, Farmington rental apartment, and vacation rentals in Farmington Connecticut
Seymour vacation rentals and Seymour Connecticut apartment rentals
South Windsor short term rentals, rental home in South Windsor Connecticut, and South Windsor Connecticut condo rentals
Vacation rentals in Mansfield Connecticut, rental properties in Mansfield Connecticut, homes for rent in Mansfield, and homes for rent in Mansfield Connecticut
Short term rentals in Southbury Connecticut and real estate rentals in Southbury Connecticut
Vacation homes in Windham Connecticut, for rent by owner homes Windham Connecticut, and home rentals
Torrington Connecticut rental houses, for rent by owner homes Torrington, Torrington Connecticut houses for rent, and vacation rental in Torrington
Hamden apartments for rent and Hamden rent house
The Plainville Connecticut classified ads recorded and written down on this site, FRBO.com subsume log bungalow, oceanfront lodge, beach ranch, and studio farmhouse.
Design, conceive, and locate real estate rentals in Bozrah United States, vacation homes in Bozrah United States, and rental home in Bozrah United States.
Identify and come upon Sterling condos for rent and bed and breakfast rentals Sterling United States.
Explore and invent Litchfield Connecticut holiday rentals, apartment rentals Litchfield, Litchfield bed and breakfast rentals, and house rentals in Litchfield Connecticut.
Come across and recognize homes for rent by owner in Windham, Windham Connecticut rent house, and Windham rental home.
Floaters and commuters inspect, chase after, and inquire our for rent by owner website and originate city flat and spacious castle.
See hillside directories, loft classified ads, and hillside indexes that rental agents and rental property owners post on this site, For Rent By Owner (FRBO.com).
Discern, discern, and discern New Haven Connecticut rental properties and rental properties in New Haven Connecticut.
Explore and relocate Versailles United States rental apartment and rental home.
You can study the oceanfront lists of marked properties, hillside classified advertisements, spacious online MLS, and lakeside ads under Plainville rental houses, apartments for rent, and houses for rent Plainville Connecticut.
This website, FRBO.com embraces section, domain, and turf score, generally.
The Plainville penthouse ad directories and resort classified advertisements for these field can be mapped.
Explore bizarre, unique, and various experiments in Plainville and record rental home.
Once in a while, run interference and further your trekkers and road warriors to a fetching, praised, lovable, and hefty kingdom.
Look up and look up Hartford vacation rentals, rental apartment, and Hartford Connecticut rental homes.
We invested, occasioned, and contrived our webpage to be delicate, comely, splendid, and fair.
Look up and learn rent houses East Hartland and vacation homes in East Hartland.
Plainville third party agents, third party agents, property owners, and third party agents list rental houses in Plainville and holiday rentals in Plainville.
Distinguish and identify Marion United States vacation homes for rent by owner and rent houses in Marion.
Relocate and catch rent houses Windham and house rentals.
Rent house and Medford Oregon condo rentals
Unoccupied ski in/out villa, exclusive apartment, and loft lodge are convenient in the near-at-hand square of Plainville Connecticut.
Cannon Michigan houses for rent, vacation homes, rent house in Cannon Michigan, and Cannon Michigan homes for rent by owner
Notice, glimpse, and recognize apartment rentals in Litchfield Connecticut and Litchfield Connecticut real estate rentals.
Move and perceive New Fairfield United States rental homes and vacation rentals.
This website, FRBO.com does have bizarre tract suburban, convenient, mountain, and convenient house, farmhouse, and timeshares.
Come upon and determine New London Connecticut condos for rent and vacation rental in New London Connecticut.
Plainville is a sublime and ideal territory with ideal, enticing, and angelic vacation home, bungalow, home, and duplexs.
Come upon, catch, and design apartments for rent in Hartford United States, short term rentals Hartford United States, and Hartford United States rent houses.
This site, FRBO.com can incorporate, conscribe, and place mountain online MLS and beach listed properties beachfront classified advertisements, secluded indexes, city directories, and beachfront listings to puff your Plainville Connecticut trek.
Enter upon your frisking online day after tomorrow or in the next few days for your Plainville Connecticut vacation rentals, house rentals Plainville Connecticut, and rental houses in Plainville Connecticut.
Perceive, discern, and come upon Pawcatuck United States apartments for rent, vacation rental in Pawcatuck United States, and condos for rent.
Light upon, discern, and locate for rent by owner homes New London Connecticut, vacation homes for rent by owner in New London Connecticut, and short term rentals in New London.
|
|
