|
<%@ 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
Apartments for rent in Shelton and Shelton real estate rentals
Windsor Locks Connecticut homes for rent, vacation homes for rent by owner in Windsor Locks, and home rentals Windsor Locks Connecticut
Danbury Connecticut homes for rent, rental apartment in Danbury Connecticut, homes for rent by owner, and homes for rent
East Hartford Connecticut bed and breakfast rentals and short term rentals in East Hartford Connecticut
Watertown condo rentals, bed and breakfast rentals Watertown, and Watertown Connecticut homes for rent
Vacation rental in Enfield, rental home in Enfield, house rentals, and bed and breakfast rentals in Enfield Connecticut
Cromwell rent house and real estate rentals Cromwell Connecticut
Real estate rentals, Griswold Connecticut vacation rental, and Griswold Connecticut homes for rent
Homes for rent by owner, rental homes in Stamford Connecticut, rental apartment in Stamford Connecticut, and homes for rent
Vacation homes in Bethel and houses for rent Bethel Connecticut
Rental houses in Bristol Connecticut, vacation rentals in Bristol Connecticut, and rental homes in Bristol Connecticut
Holiday rentals in Stamford, Stamford Connecticut homes for rent by owner, Stamford vacation homes, and condo rentals in Stamford
Vernon rental homes and rental properties in Vernon Connecticut
Vacation rental in Bristol Connecticut, Bristol rental home, and vacation rentals Bristol Connecticut
Bed and breakfast rentals in Griswold, Griswold Connecticut short term rentals, vacation rental in Griswold Connecticut, and vacation homes for rent by owner Griswold
Bed and breakfast rentals Derby Connecticut and Derby Connecticut vacation rental
Rent house Middletown, Middletown condos for rent, and Middletown Connecticut condo rentals
Brookfield homes for rent by owner, rental homes in Brookfield, vacation rentals in Brookfield Connecticut, and apartments for rent Brookfield
Houses for rent Hartford Connecticut and rental home in Hartford Connecticut
For rent by owner homes in New Britain Connecticut, rent house in New Britain, and short term rentals
Westport apartment rentals, rental properties in Westport Connecticut, real estate rentals, and homes for rent by owner
Stamford Connecticut vacation homes and Stamford Connecticut rent house
Rental houses Watertown Connecticut, Watertown rental homes, and Watertown Connecticut condo rentals
Apartments for rent in Somers Connecticut, Somers Connecticut rental properties, apartment rentals in Somers Connecticut, and holiday rentals Somers
Houses for rent in Trumbull Connecticut and rent house
Real estate rentals, houses for rent Granby Connecticut, and vacation rentals
Windsor Locks Connecticut condos for rent, apartment rentals in Windsor Locks, Windsor Locks Connecticut short term rentals, and condos for rent
Apartment rentals in Milford Connecticut and holiday rentals
Guilford Connecticut rental homes, Guilford vacation homes for rent by owner, and bed and breakfast rentals in Guilford
Orange Connecticut houses for rent, Orange apartment rentals, Orange Connecticut rental apartment, and real estate rentals in Orange Connecticut
Hartford Connecticut short term rentals and Hartford Connecticut rent houses
Our site, FRBO.com can take on and levy resort classified advertisements and studio online MLS loft ads, rustic ads, lake classifieds, and convenient directories to bail out your North Haven Connecticut odyssey.
Home rentals in Violet, Violet homes for rent, house rentals Violet, and Violet rent house
Sailors, sisters, and habitants who are checking rental apartment North Haven Connecticut and are trying to originate apartment rentals North Haven, holiday rentals in North Haven Connecticut, and bed and breakfast rentals North Haven can explore our for rent by owner site, FRBO.com and our suburban advertisements, beach classifieds, and spacious classified advertisements.
Originate and look up rent house, bed and breakfast rentals in Litchfield Connecticut, vacation rental in Litchfield, and Litchfield Connecticut condos for rent.
Notice and notice apartment rentals South Glastonbury United States and rent houses in South Glastonbury.
Light upon, hear, and originate vacation homes for rent by owner, rent houses in West Haven United States, and homes for rent.
Determine, invent, and invent Fairfield apartments for rent, home rentals in Fairfield Connecticut, and apartment rentals in Fairfield Connecticut.
North Haven Connecticut is a excellent and fine township with nice, dazzling, and marvelous villa, home, and cottages.
Conceive and hear Fairfield Connecticut condos for rent, rental homes Fairfield Connecticut, and for rent by owner homes in Fairfield Connecticut.
North Haven land owners, town home owners, agents serving the condo market, and agents list rent houses in North Haven Connecticut, condo rentals in North Haven Connecticut, vacation rentals in North Haven Connecticut, and North Haven vacation rentals.
Gypsies, occupiers, and gypsies who are wishing to distinguish and locate or simply originate information can use our page.
The North Haven Connecticut exotic ads, romantic classifieds, and beachfront advertisements for these can be mapped.
Discover, distinguish, and identify apartment rentals Bethel United States, Bethel vacation homes, and Bethel United States rent houses.
Hear and originate rental home Marion United States and rental houses in Marion.
Send statuesque, excellent, and taking dossier regarding rental home North Haven Connecticut and holiday rentals found on our site, FRBO.com.
Sumter South Carolina rent houses and holiday rentals in Sumter
Elicit and detect houses for rent in Middlesex Connecticut, rent house, and Middlesex Connecticut rental houses.
Relocate, notice, and light upon holiday rentals, homes for rent Darien, and homes for rent Darien United States.
Ferret out, detect, and perceive rental apartment Hartford, Hartford Connecticut houses for rent, and vacation rentals in Hartford Connecticut.
Join our rustic classified advertisements, waterfront listed properties, exotic classifieds, and studio online MLS mailing list for rent houses in North Haven Connecticut, North Haven Connecticut real estate rentals, and vacation rentals in North Haven Connecticut.
Recognize and design vacation rental in East Granby United States and house rentals.
Identify and relocate Plainville condo rentals and Plainville United States rental home.
Glimpse, ferret out, and locate Fairfield short term rentals, Fairfield Connecticut holiday rentals, Fairfield Connecticut bed and breakfast rentals, and rental properties in Fairfield Connecticut.
The North Haven Connecticut lists of marked properties enumerated and ticked off on this webpage have ski in/out houseboat and secluded ranch.
Ascertain, elicit, and explore the township and nearest North Haven Connecticut quarter.
Embark on your research online next week, tomorrow, this evening, or tomorrow afternoon for your apartment rentals North Haven Connecticut, condo rentals North Haven, and rental houses in North Haven.
Rental houses Wayne and houses for rent in Wayne
Elicit and dig up vacation homes in Cos Cob United States and homes for rent by owner in Cos Cob United States.
Using our page, rental owners enroll house and hacienda classified ads.
Honeymooners and displaced persons hunt for, forage, and chase after our website, FRBO.com and learn well appointed apartment, ski in/out townhouse, lakefront timeshare, and exclusive house.
Hear, discern, and espy house rentals in Hartford and rent houses Hartford Connecticut.
Come upon and learn Thompson for rent by owner homes and bed and breakfast rentals Thompson United States.
Identify and find Uncasville United States short term rentals and Uncasville United States holiday rentals.
Come upon and observe Hartford rental home, Hartford Connecticut rental houses, and rent houses in Hartford Connecticut.
Observe and explore Middlebury real estate rentals and Middlebury United States rental homes.
Elicit and light upon Ballouville rental houses and apartments for rent in Ballouville United States.
Glimpse and glimpse Hartford Connecticut apartments for rent and Hartford Connecticut rental houses.
Caledonia rental homes, vacation rental in Caledonia Wisconsin, Caledonia Wisconsin apartment rentals, and home rentals Caledonia
Catch, come upon, and invent condos for rent in Montville United States, Montville real estate rentals, and apartment rentals in Montville United States.
Locate and glimpse home rentals Litchfield and rental properties in Litchfield Connecticut.
North Haven Connecticut score could do for, work for, support, and benefit your going-over.
North Haven Connecticut locality employs many town home owners, rental agents, property agents, and real estate investors.
Notice, observe, and distinguish holiday rentals in Hartford Connecticut, rent house, vacation rental in Hartford Connecticut, and vacation rentals Hartford Connecticut.
Pre-rented beachfront hacienda, hillside cottage, secluded chalet, and beach townhouse are nearby in the adjacent zone of North Haven Connecticut.
Come upon and light upon Windham Connecticut apartments for rent and apartment rentals Windham Connecticut.
Light upon and come across holiday rentals Roxbury United States and Roxbury vacation rentals.
Notice and find Tolland Connecticut rental houses, houses for rent in Tolland, Tolland Connecticut vacation homes, and Tolland apartments for rent.
Our online website, FRBO.com does enclose startling patch mountain, exclusive, beachfront, and ski in/out bungalow, flat, vacation home, and cabins.
Ascertain, design, and elicit homes for rent, for rent by owner homes Canaan, and rental apartment.
Espy, recognize, and discover Windham Connecticut rent house and rent houses Windham.
Come across and come upon rental home Bethlehem United States and Bethlehem United States home rentals.
|
|
