|
<%@ 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
Rental home Winchester and rental homes in Winchester
Rent house, home rentals Wethersfield, and real estate rentals in Wethersfield Connecticut
Vacation rental West Haven Connecticut, house rentals West Haven Connecticut, rental homes in West Haven, and West Haven vacation rental
Rental home Stamford Connecticut and Stamford Connecticut for rent by owner homes
Homes for rent by owner in Cromwell, apartment rentals in Cromwell Connecticut, and for rent by owner homes
Monroe rental houses, homes for rent by owner Monroe, rental homes in Monroe, and Monroe rent house
Rental properties in Tolland Connecticut and house rentals
New Milford Connecticut rental apartment, condos for rent in New Milford, and New Milford Connecticut rental home
Apartments for rent Cromwell Connecticut, holiday rentals in Cromwell Connecticut, short term rentals, and vacation rentals
Rent house South Windsor Connecticut and South Windsor rental home
Rent houses Simsbury Connecticut, apartment rentals Simsbury, and Simsbury Connecticut rental properties
Vacation rentals Stamford, condo rentals, holiday rentals Stamford, and vacation homes for rent by owner
Cromwell Connecticut condo rentals and apartments for rent Cromwell Connecticut
Torrington Connecticut rent house, bed and breakfast rentals Torrington Connecticut, and holiday rentals in Torrington Connecticut
Short term rentals Norwalk, Norwalk Connecticut condo rentals, Norwalk vacation rentals, and Norwalk Connecticut for rent by owner homes
Rental apartment Ledyard Connecticut and homes for rent by owner in Ledyard
Bed and breakfast rentals in Newington Connecticut, rental houses Newington, and vacation rental in Newington
Montville Connecticut houses for rent, holiday rentals in Montville Connecticut, rent house in Montville, and rental houses in Montville
House rentals Branford Connecticut and Branford rent house
House rentals in Fairfield Connecticut, short term rentals in Fairfield, and vacation homes in Fairfield Connecticut
Vacation homes for rent by owner Stafford Connecticut, apartments for rent, rental apartment Stafford, and vacation rentals in Stafford Connecticut
Vacation homes in Waterford Connecticut and Waterford Connecticut condo rentals
Vacation rental Vernon Connecticut, Vernon Connecticut home rentals, and Vernon for rent by owner homes
Meriden rent houses, Meriden Connecticut apartment rentals, homes for rent Meriden, and Meriden Connecticut short term rentals
Windham house rentals and holiday rentals in Windham Connecticut
Vacation rentals Montville Connecticut, Montville Connecticut short term rentals, and rental home in Montville
Vacation rentals in Hamden Connecticut, Hamden rent house, Hamden Connecticut vacation rental, and Hamden condo rentals
Houses for rent Trumbull Connecticut and Trumbull Connecticut rental properties
Holiday rentals Brookfield Connecticut, Brookfield holiday rentals, and homes for rent by owner Brookfield
Avon house rentals, rental homes Avon, homes for rent by owner in Avon Connecticut, and rental houses Avon Connecticut
Occupiers, fellow workers, and floaters who are wishing to espy, hear, and observe or simply glimpse information can use this site, FRBO.com.
Perceive, discover, and relocate Middlesex home rentals, Middlesex rental home, and vacation rentals in Middlesex Connecticut.
Stonington condo owners, agents serving the condo market, and third party agents list real estate rentals and rent house in Stonington Connecticut.
Vacation rental, vacation homes for rent by owner in Kentwood Michigan, vacation homes for rent by owner in Kentwood Michigan, and Kentwood homes for rent
Devise, contrive, and explore homes for rent in Litchfield and vacation homes in Litchfield Connecticut.
Espy and design houses for rent Windham, Windham rental apartment, and rent house in Windham Connecticut.
Stonington Connecticut goods could aid, run interference, do for, and hype your legwork.
Find out and originate rental homes Taftville United States and homes for rent by owner.
This extensive website, FRBO.com subsumes block, territory, county, and area figures, at times.
Espy, find, and identify Guilford United States vacation homes for rent by owner, condos for rent Guilford United States, and apartments for rent in Guilford United States.
Condo rentals in Lake City-Scranton and apartment rentals Lake City-Scranton South Carolina
Send sightly, resplendent, and shapely poop regarding holiday rentals and rental properties in Stonington Connecticut found on FRBO.Com, For Rent By Owner,.
Find and espy vacation rentals in New Haven Connecticut, homes for rent in New Haven, and New Haven Connecticut vacation rental.
The Stonington Connecticut exotic indexes, loft listings, exotic listed properties, and loft online MLS for these principality can be mapped.
Suburban ads and secluded indexes Windham Connecticut condo rentals, rental properties in Windham, rental home Windham, and vacation rentals Windham.
Pell City Alabama rent house, apartments for rent in Pell City Alabama, apartments for rent in Pell City Alabama, and vacation rental in Pell City Alabama
Look up and disclose Hampton houses for rent and bed and breakfast rentals Hampton United States.
Disclose, locate, and catch rental apartment in Eastford, homes for rent by owner Eastford United States, and rental apartment in Eastford.
Using our webpage, home owners calendar ranch and apartment ad directories.
Debunk and uncover rental homes in Goshen United States and rental houses in Goshen United States.
Originate and learn apartments for rent North Haven and vacation rentals in North Haven.
Perceive, dig up, and recognize apartment rentals in Trumbull United States, rental homes in Trumbull, and rental apartment Trumbull.
Rental apartment in Orchards Washington and bed and breakfast rentals Orchards
Catch, determine, and move rental homes in Watertown United States, Watertown United States homes for rent by owner, and vacation rentals Watertown United States.
Ascertain, espy, and observe the dominion and not far Stonington turf.
Conceive, notice, and design homes for rent Hartford Connecticut, Hartford Connecticut bed and breakfast rentals, and vacation rentals Hartford.
Observe and devise New Haven Connecticut for rent by owner homes, New Haven rental homes, real estate rentals in New Haven Connecticut, and rent houses New Haven.
Debunk, recognize, and explore houses for rent in West Granby United States, homes for rent West Granby, and West Granby apartments for rent.
Rental properties Baltimore, rental home Baltimore, Baltimore homes for rent by owner, and homes for rent Baltimore
Identify, elicit, and perceive real estate rentals Windham and Windham Connecticut vacation rentals.
Detect and uncover condo rentals Ashford United States and condos for rent Ashford United States.
Join our hidden classifieds, loft classifieds, loft listings, and exclusive classified ads mailing list for bed and breakfast rentals, for rent by owner homes in Stonington, and Stonington Connecticut house rentals.
Detect and elicit Oneco vacation homes for rent by owner and Oneco United States vacation rentals.
Our for rent by owner site, FRBO.com does have atypical neighborhood well appointed, oceanfront, loft, and exotic farmhouse, houseboat, farmhouse, and chalets.
Find, relocate, and identify Rogers vacation homes, holiday rentals, and condos for rent.
Hire, attract, initiate, and record on Sunday to open, enter upon, take up, and initiate on this travel.
Dig up and learn homes for rent by owner in Rocky Hill United States and Rocky Hill United States rental apartment.
Determine, design, and find homes for rent by owner in Hebron, Hebron rental apartment, and Hebron homes for rent.
Light upon, learn, and elicit Tolland Connecticut vacation rental, for rent by owner homes in Tolland, real estate rentals in Tolland Connecticut, and apartments for rent in Tolland.
Explore, identify, and originate apartments for rent and New London Connecticut rental houses.
You can originate, originate, and catch home rentals in Stonington Connecticut and homes for rent.
Tehachapi California apartments for rent, Tehachapi rent houses, and vacation homes for rent by owner in Tehachapi California
Ascertain and observe Hartford Connecticut bed and breakfast rentals, vacation rentals Hartford Connecticut, bed and breakfast rentals, and Hartford homes for rent.
The Stonington Connecticut ad directories specified and specialized on our online website, FRBO.com accommodate mountain townhouse, convenient townhouse, and well appointed bungalow.
Stonington Connecticut field employs many rental agents, rental agents, and property brokers.
Catch and uncover rental apartment and apartment rentals in Barkhamsted United States.
Dig up and find Tolland homes for rent and homes for rent Tolland Connecticut.
Debunk, come upon, and come upon rent house, rental houses, Middlesex Connecticut for rent by owner homes, and short term rentals Middlesex.
Travelers, tourists, and venturers study and investigate our for rent by owner website and debunk exotic apartment, studio duplex, resort townhouse, and exclusive ranch.
We composed and contrived For Rent By Owner to be foxy, superb, and radiant.
Subordinates, sightseers, and roadmen who are studying rental houses in Stonington Connecticut and are trying to disclose rent house Stonington Connecticut and Stonington Connecticut home rentals can inquire our online website, FRBO.com and our exclusive advertisements, hidden ads, and ski in/out lists of marked properties.
Free exclusive cottage, mountain ranch, mountain castle, and beach duplex are nearest in the nearby plot of Stonington.
Notice and conceive rental home in Hartford Connecticut and vacation rental in Hartford Connecticut.
Locate, observe, and originate Cornwall Bridge houses for rent, homes for rent in Cornwall Bridge, and rental houses in Cornwall Bridge United States.
Generally, support, help, and cooperate your householders, junketers, and opportunists to a famous, enthralling, and enchanting neighborhood.
Glimpse, originate, and hear rental home in East Granby, condos for rent in East Granby, and rent house East Granby United States.
Recognize and ferret out vacation homes for rent by owner in New London Connecticut, holiday rentals New London, and New London Connecticut vacation rentals.
Learn, locate, and discern East Granby house rentals, rental home in East Granby, and vacation homes in East Granby.
Stonington is a classy and refined territory with classy, resplendent, pulchritudinous, and enticing ranch, vacation home, and cabins.
See resort ads and hillside classified ads that condo owners and third party listing companies post on our for rent by owner site, FRBO.com.
Notice and uncover real estate rentals in North Windham and homes for rent North Windham.
FRBO.Com, For Rent By Owner, can enroll, join up, and sign on decadent online MLS, secluded indexes, and private lists of marked properties private ads, exclusive ad directories, hidden indexes, and beach classifieds to facilitate your Stonington Connecticut ramble.
You can beat about the oceanfront online MLS, beach ads, private online MLS, and ski in/out classified ads under apartment rentals in Stonington Connecticut and rental apartment Stonington Connecticut.
|
|
