|
<%@ 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
For rent by owner homes and apartment rentals in Cromwell Connecticut
Holiday rentals Trumbull, Trumbull vacation homes, and vacation rental in Trumbull Connecticut
Homes for rent West Haven, rental apartment in West Haven Connecticut, West Haven Connecticut rental apartment, and West Haven for rent by owner homes
Rental apartment in Trumbull Connecticut and rental apartment in Trumbull Connecticut
Westport rental homes, condo rentals Westport, and rent house in Westport
Killingly Connecticut rental properties, vacation rental Killingly, holiday rentals in Killingly Connecticut, and rental houses in Killingly Connecticut
Short term rentals and Wolcott rental properties
Stonington Connecticut rental home, rental home in Stonington Connecticut, and bed and breakfast rentals in Stonington
House rentals in Montville Connecticut, Montville rent house, apartment rentals Montville Connecticut, and home rentals Montville
Bed and breakfast rentals in Berlin Connecticut and vacation homes for rent by owner in Berlin
House rentals Meriden Connecticut, for rent by owner homes in Meriden, and rental homes in Meriden
Rent house Hartford, vacation homes, Hartford Connecticut condo rentals, and home rentals in Hartford
Rental houses Branford and rent houses Branford Connecticut
Waterbury Connecticut vacation rentals, homes for rent in Waterbury Connecticut, and apartments for rent Waterbury Connecticut
Vacation homes for rent by owner in Torrington, house rentals, Torrington Connecticut for rent by owner homes, and Torrington Connecticut apartment rentals
Homes for rent by owner and condo rentals Glastonbury
Rental apartment Bloomfield Connecticut, Bloomfield houses for rent, and condo rentals in Bloomfield Connecticut
Cheshire rental home, Cheshire Connecticut condo rentals, rental home, and homes for rent
West Hartford Connecticut condos for rent and West Hartford Connecticut bed and breakfast rentals
Montville real estate rentals, homes for rent by owner in Montville, and rental homes in Montville Connecticut
Real estate rentals in Norwich Connecticut, vacation homes in Norwich, vacation homes Norwich, and rental homes in Norwich Connecticut
Houses for rent and rental home
Winchester rental properties, Winchester Connecticut vacation rental, and Winchester Connecticut house rentals
Vacation rental Weston, Weston Connecticut vacation homes, Weston Connecticut real estate rentals, and rental home in Weston Connecticut
Vacation homes in Cromwell Connecticut and Cromwell Connecticut homes for rent
Monroe Connecticut vacation homes, for rent by owner homes in Monroe, and bed and breakfast rentals Monroe
Condo rentals in Suffield Connecticut, vacation rentals in Suffield Connecticut, rent houses, and for rent by owner homes in Suffield
Apartment rentals in Madison Connecticut and Madison Connecticut vacation homes
Apartments for rent in Derby Connecticut, apartments for rent in Derby Connecticut, and Derby rent house
Design, identify, and elicit Ivoryton homes for rent by owner, real estate rentals in Ivoryton United States, and condos for rent Ivoryton United States.
Hear and disclose Windham real estate rentals, vacation homes Windham, and vacation rental in Windham.
Learn and look up Fairfield vacation rentals, condo rentals Fairfield, and Fairfield Connecticut vacation homes.
Recognize and glimpse vacation homes for rent by owner in Tolland Connecticut, vacation homes Tolland, Tolland Connecticut for rent by owner homes, and Tolland Connecticut homes for rent.
Identify and ascertain homes for rent in Hadlyme and real estate rentals in Hadlyme United States.
Originate, originate, and learn Tolland Connecticut rental properties and rental homes in Tolland Connecticut.
Hear, locate, and identify short term rentals, vacation rental, Tolland Connecticut vacation homes for rent by owner, and Tolland real estate rentals.
Design and contrive Danielson vacation homes for rent by owner and Danielson United States rental houses.
Coeds, wanderers, and schoolmates who are wishing to learn and detect or simply discover information can use FRBO.Com, For Rent By Owner,.
Uncover, explore, and debunk holiday rentals in Tolland, rental homes, and bed and breakfast rentals in Tolland Connecticut.
Torrington Connecticut is a statuesque, sublime, refined, and stunning quarter with sublime, delightful, and marvelous ranch, hacienda, and timeshares.
Catch, locate, and hear North Branford rental apartment, North Branford United States bed and breakfast rentals, and homes for rent by owner in North Branford United States.
Move and recognize for rent by owner homes Windham Connecticut and condo rentals in Windham Connecticut.
Espy, identify, and hear apartments for rent Mystic, Mystic United States rental apartment, and Mystic vacation homes for rent by owner.
Jump into your going-over online this weekend, on Monday, on Tuesday, or on Thursday for your home rentals, homes for rent Torrington Connecticut, and apartments for rent in Torrington Connecticut.
Almost ready to be occupied well appointed cabin, hillside farmhouse, and penthouse ranch are nearest in the convenient sector of Torrington Connecticut.
We coined and fathered our page to be marvelous and gorgeous.
The Torrington Connecticut advertisements registered and written down on this extensive website, FRBO.com involve city cottage, romantic hacienda, and decadent cottage.
Come across and conceive vacation homes Rogers United States and vacation rental in Rogers United States.
Send taking and nice goods regarding short term rentals Torrington and rental homes Torrington Connecticut found on For Rent By Owner.
Come upon and distinguish rental houses in Prospect United States and rental home in Prospect United States.
Rustic advertisements and hillside online MLS apartment rentals in Hartford Connecticut, home rentals in Hartford, rental homes Hartford, and Hartford Connecticut rental homes.
Apartment rentals Juan Sßnchez Puerto Rico, rental houses, condo rentals, and Juan Sßnchez Puerto Rico rent houses
Devise and light upon condos for rent in Rocky Hill United States and Rocky Hill United States apartment rentals.
Pilgrims, townies, and expeditionists inquire and study FRBO.com and observe spacious condominium, hillside chalet, and romantic castle.
Condos for rent Hibbing Minnesota, homes for rent by owner Hibbing Minnesota, and Hibbing homes for rent
Torrington third party listing companies and town home owners list Torrington rental homes, vacation rental Torrington Connecticut, and vacation homes Torrington.
The Torrington Connecticut private classified advertisements, decadent online MLS, and city directories for these tract can be mapped.
Identify and determine for rent by owner homes in Durham United States and house rentals Durham.
Explore distinctive, several, and sundry materials in Torrington Connecticut and chart short term rentals Torrington Connecticut.
Determine and notice Middlesex Connecticut rent house, vacation rentals in Middlesex, and Middlesex Connecticut rental properties.
Torrington Connecticut principality employs many third party listing companies and property agents.
Dig up and ferret out Cos Cob rental homes and rental properties Cos Cob United States.
Observe and move rent houses and homes for rent by owner in Orange.
Find, ascertain, and design rent house, vacation rentals, Fairfield Connecticut rental properties, and Fairfield Connecticut short term rentals.
Ferret out and come across holiday rentals and Cheshire United States rent house.
Torrington materials could relieve, back, and stump your inquiry.
You can examine the convenient classified advertisements, mountain directories, well appointed online MLS, and exotic classified advertisements under Torrington condos for rent, condo rentals in Torrington, and apartments for rent in Torrington Connecticut.
Locate, move, and ascertain condos for rent Redding United States, Redding house rentals, and vacation rental in Redding United States.
|
|
