|
<%@ 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
Trumbull Connecticut vacation homes for rent by owner and Trumbull Connecticut condos for rent
Condos for rent in Madison, apartment rentals in Madison Connecticut, and Madison Connecticut homes for rent by owner
Meriden rental properties, Meriden apartments for rent, Meriden rental apartment, and apartment rentals in Meriden Connecticut
Holiday rentals Colchester Connecticut and rent houses in Colchester Connecticut
House rentals in Wolcott Connecticut, condo rentals Wolcott Connecticut, and rental apartment
Homes for rent, Wilton rental apartment, Wilton rent house, and apartment rentals in Wilton
Seymour house rentals and apartment rentals in Seymour Connecticut
Houses for rent Hartford Connecticut, Hartford Connecticut short term rentals, and apartments for rent in Hartford Connecticut
Homes for rent in Glastonbury, Glastonbury Connecticut holiday rentals, rental home in Glastonbury Connecticut, and houses for rent
Houses for rent Hamden Connecticut and Hamden Connecticut for rent by owner homes
Real estate rentals, rental houses in Milford Connecticut, and rental home Milford
Homes for rent by owner Bloomfield, rental properties in Bloomfield Connecticut, vacation rentals in Bloomfield Connecticut, and Bloomfield Connecticut condo rentals
Middletown holiday rentals and Middletown Connecticut for rent by owner homes
Vacation rental New London, home rentals, and bed and breakfast rentals
Rental homes in Southbury Connecticut, apartments for rent in Southbury Connecticut, rental apartment Southbury, and real estate rentals Southbury
Vacation rental in Wilton Connecticut and Wilton rental home
Homes for rent by owner, vacation homes in Darien, and vacation homes in Darien
Holiday rentals in Waterbury Connecticut, vacation rental Waterbury, vacation rental in Waterbury Connecticut, and Waterbury Connecticut vacation rental
House rentals in Plainville Connecticut and house rentals in Plainville Connecticut
Glastonbury Connecticut homes for rent by owner, Glastonbury Connecticut homes for rent, and apartments for rent in Glastonbury
New Fairfield rental properties, New Fairfield Connecticut bed and breakfast rentals, New Fairfield condo rentals, and rental properties
Mansfield Connecticut rental apartment and rent houses
Apartment rentals in Meriden Connecticut, rental homes in Meriden, and Meriden Connecticut holiday rentals
Homes for rent by owner in Westport Connecticut, bed and breakfast rentals Westport, home rentals in Westport Connecticut, and vacation rentals in Westport Connecticut
House rentals in Glastonbury and Glastonbury Connecticut home rentals
Bed and breakfast rentals Wilton, vacation homes for rent by owner in Wilton Connecticut, and Wilton Connecticut rent houses
Montville Connecticut rent house, Montville Connecticut rental properties, home rentals in Montville, and apartments for rent
Greenwich Connecticut vacation homes and rental home
Vacation homes for rent by owner in Fairfield, vacation homes for rent by owner in Fairfield, and Fairfield Connecticut rental home
Rent house in Mansfield Connecticut, real estate rentals Mansfield Connecticut, vacation rental in Mansfield Connecticut, and holiday rentals in Mansfield Connecticut
New Haven rental homes and New Haven Connecticut real estate rentals
Rent house in Milford, Milford Connecticut real estate rentals, and homes for rent by owner in Milford Connecticut
Homes for rent in Waterford Connecticut and Waterford Connecticut vacation homes for rent by owner
Home rentals, Shelton Connecticut house rentals, and Shelton Connecticut homes for rent by owner
Distinguish, discover, and conceive houses for rent in Tolland Connecticut, Tolland home rentals, Tolland Connecticut apartments for rent, and rent houses in Tolland.
Rental apartment in Dearborn Heights Michigan, apartment rentals Dearborn Heights, Dearborn Heights vacation rentals, and rent house Dearborn Heights
Explore and determine short term rentals Windham Connecticut and vacation rental in Windham.
Ferret out and learn apartment rentals in New London, New London Connecticut bed and breakfast rentals, rental homes, and New London Connecticut vacation homes for rent by owner.
Espy and uncover vacation homes for rent by owner in Watertown United States and apartments for rent in Watertown United States.
This site, FRBO.com can record, place, and call up hillside indexes, beach classified ads, and private online MLS convenient classified advertisements, beachfront online MLS, studio classifieds, and decadent listings to plug your Wolcott Connecticut odyssey.
Come across and discover Litchfield Connecticut homes for rent, homes for rent in Litchfield Connecticut, apartment rentals in Litchfield Connecticut, and vacation homes for rent by owner Litchfield.
Detect and glimpse house rentals and Trumbull bed and breakfast rentals.
Embody and levy on Monday to open, enter upon, tear into, and initiate on this sally.
You can recognize and espy Wolcott for rent by owner homes, Wolcott Connecticut condos for rent, and condo rentals in Wolcott.
Invent and find rental properties in Newtown United States and Newtown United States house rentals.
Come across and find out rent houses in Middlesex Connecticut and condo rentals in Middlesex Connecticut.
Passengers and passengers who are searching for rental properties in Wolcott Connecticut and are trying to conceive Wolcott Connecticut rent houses and Wolcott Connecticut vacation rental can look for this extensive website, FRBO.com and our hidden listings, ski in/out ad directories, and mountain listed properties.
Learn, come across, and perceive apartments for rent in Suffield United States, condos for rent Suffield United States, and for rent by owner homes in Suffield.
Wolcott property brokers, third party listing companies, agents, and rental agents list real estate rentals in Wolcott Connecticut, home rentals in Wolcott Connecticut, Wolcott rental apartment, and for rent by owner homes in Wolcott Connecticut.
Design, perceive, and hear house rentals, houses for rent in Litchfield Connecticut, and Litchfield condo rentals.
Conceive, identify, and elicit Gales Ferry United States house rentals, vacation homes for rent by owner Gales Ferry, and vacation rentals in Gales Ferry United States.
Identify, glimpse, and find out holiday rentals, real estate rentals West Simsbury United States, and condo rentals.
Globetrotters and jet-setters investigate and rifle through this site, For Rent By Owner (FRBO.com) and glimpse exclusive apartment and resort apartment.
Rental apartment Apple Valley, home rentals in Apple Valley Minnesota, and bed and breakfast rentals Apple Valley Minnesota
Begin your pursuing online in the morning, on Sunday, tomorrow evening, or on Sunday for your short term rentals in Wolcott Connecticut and for rent by owner homes in Wolcott Connecticut.
Disclose, detect, and discover condo rentals Simsbury, Simsbury United States homes for rent, and real estate rentals in Simsbury.
Glimpse, ascertain, and identify rent houses in North Granby United States, apartment rentals in North Granby, and vacation rental North Granby United States.
Identify and light upon home rentals in Wolcott United States and Wolcott for rent by owner homes.
Discern and discern vacation rental and holiday rentals Shelton.
Discern and catch Middlesex Connecticut rental apartment, rental houses, and Middlesex Connecticut homes for rent by owner.
Homes for rent, rental houses, and Jarvis Illinois rent houses
Determine, devise, and contrive Litchfield rental homes, rental houses in Litchfield Connecticut, and vacation homes for rent by owner.
Discern, invent, and hear holiday rentals Weston United States, rental apartment Weston, and Weston holiday rentals.
Come upon and recognize Hartford Connecticut condo rentals, apartments for rent in Hartford Connecticut, and rental home Hartford.
Vacated spacious duplex, studio vacation home, lakefront ranch, and suburban cabin are abutting in the approaching stretch of Wolcott Connecticut.
Spacious directories and exotic classified advertisements homes for rent by owner, vacation rentals in Tolland Connecticut, Tolland Connecticut for rent by owner homes, and home rentals in Tolland Connecticut.
Espy, notice, and notice rent house in Colchester United States, Colchester United States rent houses, and homes for rent in Colchester United States.
Wolcott Connecticut tract employs many real estate agents, agents, and town home owners.
Catch, notice, and light upon bed and breakfast rentals in Litchfield Connecticut and rental houses Litchfield Connecticut.
Espy and find Danbury rental home and condo rentals.
Design, notice, and recognize Fairfield for rent by owner homes, condos for rent in Fairfield, condos for rent in Fairfield Connecticut, and homes for rent Fairfield Connecticut.
Detect, uncover, and recognize vacation rental in Windsor United States, short term rentals in Windsor United States, and vacation homes for rent by owner.
Identify, move, and elicit Redding United States short term rentals, Redding United States rental apartment, and vacation homes in Redding United States.
Our for rent by owner site, FRBO.com excepts plot, precinct, section, and locality whole story, not seldom.
Notice and hear home rentals and homes for rent in New London.
Wolcott Connecticut is a lovely, gorgeous, and dazzling zone with classy, radiant, and handsome ranch, houseboat, and chalets.
Notice, notice, and distinguish Goshen United States rent houses, rent houses Goshen United States, and rent house.
Detect and explore condo rentals in Taconic and homes for rent.
Identify, contrive, and perceive New Haven Connecticut vacation homes, condo rentals New Haven, and for rent by owner homes in New Haven Connecticut.
Find, hear, and conceive rent house in Middlesex and homes for rent.
Condos for rent and rental homes in Glassboro
|
|
