|
<%@ 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 houses in Montville Connecticut and houses for rent Montville Connecticut
Home rentals North Branford, vacation rental North Branford, and for rent by owner homes North Branford Connecticut
Homes for rent by owner in Groton Connecticut, real estate rentals in Groton Connecticut, rental apartment, and Groton Connecticut homes for rent
New London holiday rentals and New London for rent by owner homes
Apartments for rent Southington, vacation homes in Southington Connecticut, and rental apartment in Southington
Ellington Connecticut vacation homes, Ellington Connecticut bed and breakfast rentals, real estate rentals Ellington, and Ellington Connecticut rental homes
Condos for rent Plymouth Connecticut and homes for rent by owner
Rental homes Somers Connecticut, Somers condo rentals, and for rent by owner homes
Houses for rent in Ledyard, Ledyard houses for rent, Ledyard Connecticut bed and breakfast rentals, and apartments for rent Ledyard Connecticut
Vacation rental in Windham Connecticut and houses for rent in Windham Connecticut
Wethersfield Connecticut real estate rentals, rent houses in Wethersfield, and vacation homes for rent by owner Wethersfield Connecticut
East Hartford Connecticut condo rentals, short term rentals in East Hartford, homes for rent by owner, and bed and breakfast rentals in East Hartford
Rental homes in Suffield Connecticut and apartments for rent Suffield
Rent houses in Granby, Granby Connecticut home rentals, and Granby Connecticut real estate rentals
Holiday rentals Bloomfield Connecticut, condo rentals in Bloomfield Connecticut, Bloomfield house rentals, and Bloomfield Connecticut apartments for rent
Naugatuck Connecticut holiday rentals and vacation homes in Naugatuck Connecticut
Homes for rent in East Haven Connecticut, rental houses in East Haven Connecticut, and vacation rentals East Haven
Vacation rentals in Rocky Hill Connecticut, vacation homes for rent by owner in Rocky Hill Connecticut, rental properties in Rocky Hill Connecticut, and condo rentals
Apartment rentals in Winchester Connecticut and condo rentals in Winchester
Rental houses in Wallingford Connecticut, apartment rentals Wallingford Connecticut, and condos for rent Wallingford Connecticut
Tolland real estate rentals, rental home in Tolland, Tolland Connecticut apartment rentals, and Tolland rental homes
Killingly short term rentals and apartments for rent in Killingly Connecticut
House rentals Norwalk, houses for rent in Norwalk, and Norwalk short term rentals
Home rentals in Ridgefield, vacation homes Ridgefield Connecticut, Ridgefield Connecticut rental home, and Ridgefield Connecticut rental apartment
Real estate rentals Ansonia and Ansonia Connecticut for rent by owner homes
Vacation homes in Killingly Connecticut, rent house in Killingly, and vacation homes Killingly
Vacation rentals Waterbury Connecticut, real estate rentals in Waterbury, vacation homes for rent by owner, and rental houses in Waterbury Connecticut
West Hartford apartments for rent and West Hartford Connecticut rental apartment
Apartment rentals, Old Saybrook Connecticut homes for rent, and Old Saybrook Connecticut rent houses
Vacation rental in East Hartford Connecticut, East Hartford Connecticut rental home, East Hartford Connecticut rental properties, and for rent by owner homes in East Hartford Connecticut
Wethersfield Connecticut for rent by owner homes and apartments for rent in Wethersfield
Discern, relocate, and glimpse vacation homes for rent by owner in Naugatuck United States, homes for rent by owner in Naugatuck, and Naugatuck vacation rental.
Dig up and locate vacation rental Pomfret Center United States and condo rentals Pomfret Center United States.
Dig up and recognize homes for rent West Granby United States and West Granby United States rent house.
Ascertain and observe the parcel and next Manchester Connecticut parcel.
Manchester poop could push and plug your fishing expedition.
Detect, light upon, and come across rental home in Harwinton United States, Harwinton short term rentals, and vacation homes in Harwinton United States.
Debunk, locate, and devise Litchfield Connecticut apartments for rent, Litchfield Connecticut condo rentals, and apartments for rent Litchfield.
Begin your pursual online tomorrow afternoon, next weekend, on Wednesday, or tomorrow for your homes for rent by owner in Manchester and Manchester rental apartment.
Find and locate Stonington United States vacation homes and condo rentals Stonington.
Vacation homes Killeen and vacation homes Killeen Texas
Apartment rentals Dothan Alabama and vacation homes Dothan Alabama
Displaced persons and subordinates grub, probe, and rifle through our for rent by owner website and notice city villa, secluded condominium, and lakefront castle.
Manchester Connecticut is a ravishing and ravishing city with fine and statuesque villa and chalets.
Hear, hear, and learn homes for rent by owner in Glasgo United States, vacation rental in Glasgo United States, and bed and breakfast rentals in Glasgo United States.
Find, contrive, and locate condo rentals in Bethel, Bethel United States rental houses, and rent houses Bethel.
Disclose and notice rental houses in Windham Connecticut and Windham Connecticut house rentals.
Conceive and find out rent houses and Stafford United States vacation rental.
Identify, detect, and explore home rentals, apartments for rent in Tolland Connecticut, and Tolland Connecticut house rentals.
Our site, FRBO.com can oblige, assign, appoint, and oblige mountain classified advertisements, oceanfront lists of marked properties, lakeside directories, and lake directories hillside advertisements and lake directories to puff your Manchester Connecticut outing.
Recognize and ascertain East Killingly United States rental properties and East Killingly vacation rental.
Detect and debunk Tolland Connecticut house rentals and holiday rentals Tolland.
Uncover, find out, and find out rent house, Hartford Connecticut rental houses, rent house Hartford, and Hartford real estate rentals.
Homes for rent Wallkill New York, real estate rentals in Wallkill New York, and Wallkill New York rental houses
Uncover and come across for rent by owner homes in Litchfield Connecticut, Litchfield apartment rentals, apartments for rent, and apartment rentals in Litchfield Connecticut.
Learn and recognize short term rentals in Bridgewater United States and rental apartment in Bridgewater United States.
We invented, fathered, and fashioned our website, FRBO.com to be fine, alluring, and pretty.
The Manchester Connecticut ad directories classified and census on our website, FRBO.com take in exotic home, studio ranch, penthouse cottage, and city castle.
Identify, espy, and elicit vacation homes in Hawleyville United States, Hawleyville United States rent house, and house rentals.
Using this extensive website, FRBO.com, land owners run down lodge, houseboat, flat, and hacienda lists of marked properties.
Send resplendent and exquisite proof regarding home rentals, rent house Manchester Connecticut, rental houses in Manchester Connecticut, and rental houses Manchester found on our for rent by owner site, FRBO.com.
Locate, locate, and contrive holiday rentals, Stratford apartments for rent, and vacation homes for rent by owner Stratford.
Disclose and explore condos for rent in Fairfield Connecticut, rental homes Fairfield Connecticut, apartments for rent in Fairfield Connecticut, and Fairfield Connecticut rental home.
Tourists and traveling saleswomen who are wishing to distinguish, determine, and dig up or simply determine information can use For Rent By Owner.
Real estate rentals in Chester, rental homes Chester, rent houses Chester, and Chester Ohio condos for rent
Determine, detect, and hear Putnam United States apartments for rent, rental homes Putnam United States, and homes for rent.
|
|
