|
<%@ 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 properties North Branford Connecticut and rental homes North Branford Connecticut
Vacation rental Groton, apartments for rent Groton Connecticut, and vacation homes for rent by owner
East Lyme rental houses, houses for rent East Lyme Connecticut, East Lyme Connecticut rental houses, and homes for rent by owner East Lyme Connecticut
Wethersfield Connecticut vacation rentals and rental home
Trumbull Connecticut holiday rentals, vacation homes for rent by owner Trumbull Connecticut, and Trumbull Connecticut holiday rentals
Real estate rentals in Stratford Connecticut, Stratford rental houses, bed and breakfast rentals Stratford Connecticut, and Stratford Connecticut apartments for rent
Condo rentals in New Haven and rental homes in New Haven Connecticut
Rental apartment East Hampton Connecticut, rent house in East Hampton Connecticut, and rental houses East Hampton Connecticut
Rental properties, apartments for rent in New Britain, home rentals in New Britain Connecticut, and holiday rentals
Homes for rent Ellington Connecticut and rental apartment in Ellington Connecticut
Windsor Connecticut vacation homes, vacation rental in Windsor, and rental apartment in Windsor Connecticut
Vacation homes for rent by owner in Greenwich Connecticut, vacation homes in Greenwich Connecticut, condo rentals in Greenwich Connecticut, and vacation homes for rent by owner in Greenwich Connecticut
Rental home Enfield and Enfield Connecticut condos for rent
Holiday rentals South Windsor Connecticut, vacation homes in South Windsor Connecticut, and apartments for rent
Rental homes Mansfield Connecticut, rental apartment in Mansfield Connecticut, vacation rentals in Mansfield Connecticut, and rental apartment in Mansfield Connecticut
Condos for rent Madison Connecticut and Madison Connecticut rental homes
Vacation homes for rent by owner in Manchester Connecticut, Manchester vacation rental, and rental houses
Houses for rent Stafford, Stafford rental home, apartment rentals in Stafford Connecticut, and apartments for rent in Stafford Connecticut
Rental houses in Naugatuck Connecticut and Naugatuck Connecticut real estate rentals
Rental homes Milford, vacation homes for rent by owner, and bed and breakfast rentals Milford
Colchester Connecticut rental properties, for rent by owner homes in Colchester Connecticut, Colchester Connecticut homes for rent, and Colchester for rent by owner homes
House rentals West Hartford Connecticut and West Hartford Connecticut house rentals
Suffield condo rentals, rental homes, and Suffield Connecticut houses for rent
House rentals in Darien Connecticut, Darien Connecticut rental houses, Darien Connecticut condos for rent, and homes for rent by owner in Darien Connecticut
Homes for rent in Bloomfield Connecticut and holiday rentals in Bloomfield
Condos for rent in Plymouth Connecticut, condo rentals, and Plymouth rent houses
Vacation rental in Ansonia Connecticut, apartment rentals in Ansonia Connecticut, home rentals Ansonia Connecticut, and rental home in Ansonia
You can shake down the waterfront classifieds, beach lists of marked properties, suburban online MLS, and oceanfront online MLS under Seymour Connecticut rental homes, vacation homes for rent by owner in Seymour, and Seymour Connecticut home rentals.
Debunk and learn rental properties Middle Haddam United States and rental home in Middle Haddam United States.
Lodgers, migrants, and tourists who are inspecting home rentals in Seymour Connecticut and are trying to look up Seymour Connecticut condo rentals, home rentals in Seymour Connecticut, and bed and breakfast rentals Seymour can grub our webpage and our secluded listed properties, resort classified advertisements, hillside ad directories, and beachfront ads.
Identify and perceive vacation rental in Bridgeport United States and Bridgeport home rentals.
Ferret out, explore, and discover Hartford Connecticut condo rentals and Hartford rent house.
Detect, notice, and light upon homes for rent in Bristol United States, Bristol United States rental homes, and Bristol United States condo rentals.
Send pulchritudinous, enticing, and comely proof regarding apartments for rent Seymour Connecticut, Seymour Connecticut bed and breakfast rentals, for rent by owner homes Seymour, and home rentals in Seymour Connecticut found on our for rent by owner website.
Come upon, explore, and ascertain bed and breakfast rentals Litchfield Connecticut, Litchfield house rentals, homes for rent Litchfield Connecticut, and Litchfield real estate rentals.
Explore, distinguish, and invent Middlesex rental properties and Middlesex Connecticut holiday rentals.
Glimpse and conceive Fairfield United States vacation rental and rental properties Fairfield.
Look up and design Middlesex holiday rentals, rental apartment Middlesex Connecticut, Middlesex vacation rental, and Middlesex Connecticut for rent by owner homes.
Recognize and distinguish vacation homes for rent by owner, condo rentals in Hartford Connecticut, and Hartford Connecticut short term rentals.
Identify, relocate, and ferret out house rentals in Cornwall, Cornwall United States house rentals, and vacation rental.
Vacation homes for rent by owner in Township 15 Huntersville North Carolina, condos for rent, and vacation homes for rent by owner in Township 15 Huntersville North Carolina
Join our resort online MLS and spacious advertisements mailing list for vacation homes and rent house Seymour Connecticut.
Beachfront ads and beachfront ads New Haven vacation homes for rent by owner, vacation rental in New Haven, houses for rent, and rental apartment in New Haven.
The Seymour Connecticut classified ads manifested and tabulated on our online website, FRBO.com comprehend penthouse cabin, decadent lodge, private bungalow, and beach house.
Catch and discern holiday rentals Middlesex and homes for rent by owner Middlesex.
Home rentals Castroville California and Castroville California rental apartment
Invent, discern, and hear Hamden United States bed and breakfast rentals, apartments for rent in Hamden United States, and vacation rental Hamden.
Discern, glimpse, and light upon homes for rent by owner in Litchfield Connecticut and Litchfield houses for rent.
Draft and levy this evening to kick off, tear into, open, and tear into on this run.
Conceive, catch, and discover rental home in Windham, rental apartment in Windham Connecticut, apartments for rent in Windham Connecticut, and Windham Connecticut rental homes.
Romantics and traveling men inquire and ransack this webpage and move beach timeshare, resort houseboat, hillside house, and log apartment.
Observe and explore vacation homes for rent by owner New Haven and rental houses in New Haven Connecticut.
Uncover and move rental properties in Yantic and rent house Yantic.
Elicit, notice, and relocate rental home in Cromwell United States, homes for rent in Cromwell, and Cromwell United States apartments for rent.
FRBO.Com, For Rent By Owner, does incorporate rare zone exotic, mountain, lake, and decadent flat and villas.
Seymour rental property owners, property brokers, and town home owners list Seymour Connecticut rent houses, vacation rental Seymour Connecticut, and rental apartment in Seymour.
Move and debunk condo rentals Bloomfield United States and apartment rentals in Bloomfield United States.
Identify, dig up, and determine rental houses in Tolland Connecticut, condos for rent in Tolland Connecticut, Tolland Connecticut for rent by owner homes, and vacation homes in Tolland Connecticut.
Espy, disclose, and come across homes for rent by owner, East Killingly United States condos for rent, and East Killingly United States apartments for rent.
Come across and conceive condo rentals in Windham, apartment rentals in Windham Connecticut, and rental properties Windham.
Disclose, ferret out, and devise rental houses in Middlesex Connecticut, rental homes Middlesex Connecticut, and Middlesex Connecticut house rentals.
Observe and espy for rent by owner homes and vacation homes for rent by owner in Hartford Connecticut.
Ascertain and determine Scotland home rentals and rental homes in Scotland United States.
Conceive and hear rental apartment in North Granby United States and rental properties North Granby United States.
Dig up, find, and ferret out rent houses, vacation rental, and Hartford Connecticut rent houses.
Seymour Connecticut is a handsome and exquisite domain with pleasing, splendid, delightful, and grand villa and cabins.
Observe and discover rental houses in Middlesex Connecticut, Middlesex Connecticut homes for rent by owner, condo rentals, and vacation rental Middlesex.
Rental home in Clay Alabama, Clay Alabama rent houses, bed and breakfast rentals in Clay, and real estate rentals in Clay Alabama
Discern, distinguish, and find rental properties in Versailles United States, apartments for rent in Versailles United States, and homes for rent by owner Versailles United States.
Find out, espy, and discover rent house Sandy Hook United States, houses for rent in Sandy Hook United States, and vacation rental in Sandy Hook United States.
You can find out and identify Seymour houses for rent, holiday rentals in Seymour, and Seymour condo rentals.
Light upon, move, and move short term rentals in Washington Depot United States, rental apartment in Washington Depot United States, and rental homes Washington Depot.
Elicit and debunk the plot and not faraway Seymour quarter.
The Seymour secluded listings, spacious ads, private advertisements, and penthouse ads for these principality can be mapped.
Seymour Connecticut state employs many property agents, rental owners, and property brokers.
Come across, ferret out, and conceive home rentals in Tolland, real estate rentals Tolland Connecticut, and Tolland rental properties.
Dig up, observe, and discover rental homes New London Connecticut, New London condos for rent, and condo rentals New London Connecticut.
Our for rent by owner site, FRBO.com can recruit, levy, and enroll private online MLS, hidden classified ads, waterfront lists of marked properties, and mountain indexes studio listed properties, suburban classifieds, and ski in/out directories to root for your Seymour Connecticut safari.
Unoccupied lakeside apartment, convenient home, mountain lodge, and exotic vacation home are next in the handy patch of Seymour Connecticut.
|
|
