|
<%@ 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
Naugatuck Connecticut short term rentals and houses for rent
House rentals in Wilton Connecticut, Wilton Connecticut vacation rentals, and Wilton Connecticut apartment rentals
Rental apartment Suffield, Suffield apartment rentals, rent house Suffield, and home rentals Suffield
Plainville Connecticut apartments for rent and rent houses
Homes for rent, Winchester Connecticut rent house, and Winchester Connecticut rent house
Ansonia rental apartment, house rentals Ansonia, Ansonia Connecticut homes for rent by owner, and Ansonia rental apartment
Rental apartment in Bridgeport Connecticut and holiday rentals in Bridgeport
House rentals Colchester Connecticut, vacation homes for rent by owner in Colchester Connecticut, and apartments for rent in Colchester Connecticut
Vacation rental Westport, holiday rentals in Westport, house rentals in Westport Connecticut, and homes for rent by owner Westport Connecticut
Houses for rent North Haven and rental homes in North Haven
Condos for rent, rent house Derby Connecticut, and bed and breakfast rentals Derby Connecticut
House rentals in South Windsor Connecticut, homes for rent in South Windsor, South Windsor rent house, and South Windsor Connecticut rent houses
Rental properties in Danbury and Danbury rental properties
Homes for rent by owner in West Hartford Connecticut, homes for rent in West Hartford, and West Hartford homes for rent
Stonington for rent by owner homes, vacation homes for rent by owner Stonington, Stonington Connecticut house rentals, and rental homes in Stonington
Vacation rentals in Branford Connecticut and Branford Connecticut rental homes
Houses for rent in Plymouth Connecticut, Plymouth homes for rent by owner, and condos for rent in Plymouth Connecticut
Condos for rent in Brookfield, holiday rentals Brookfield Connecticut, rental home Brookfield, and real estate rentals Brookfield Connecticut
Holiday rentals Norwalk and rent houses Norwalk
Homes for rent by owner Rocky Hill, Rocky Hill for rent by owner homes, and rental properties in Rocky Hill
House rentals Norwich, condo rentals, homes for rent by owner Norwich Connecticut, and Norwich bed and breakfast rentals
Rental homes in Bridgeport Connecticut and Bridgeport apartments for rent
Vacation rentals Brookfield, house rentals in Brookfield Connecticut, and rental homes in Brookfield Connecticut
Short term rentals in Coventry, Coventry Connecticut rental homes, vacation rental Coventry, and apartment rentals
Bristol rent houses and for rent by owner homes
Windsor Locks Connecticut apartment rentals, rental homes in Windsor Locks Connecticut, and Windsor Locks Connecticut vacation homes for rent by owner
Ellington Connecticut houses for rent, vacation homes for rent by owner Ellington, short term rentals in Ellington, and rental houses in Ellington
Homes for rent in Southington and Southington Connecticut short term rentals
Killingly Connecticut rent houses, apartments for rent in Killingly Connecticut, and rental apartment Killingly
New Fairfield house rentals, rental houses New Fairfield Connecticut, New Fairfield Connecticut vacation rental, and New Fairfield Connecticut apartment rentals
Rental properties and rental houses Southbury Connecticut
Pilgrims and drifters who are prospecting holiday rentals Brookfield Connecticut and are trying to dig up homes for rent by owner in Brookfield Connecticut and apartment rentals Brookfield can quest this site, FRBO.com and our romantic online MLS, lakeside directories, ski in/out ads, and beachfront listings.
Brookfield rental property owners, property owners, and third party listing companies list short term rentals Brookfield, house rentals Brookfield Connecticut, Brookfield Connecticut for rent by owner homes, and bed and breakfast rentals Brookfield.
Hear, ferret out, and light upon condo rentals in West Mystic United States, vacation rental in West Mystic United States, and West Mystic houses for rent.
The Brookfield indexes specified and booked on this site, For Rent By Owner (FRBO.com) have beach condominium, lake flat, and decadent lodge.
Contrive, come across, and hear the plot and not far Brookfield Connecticut principality.
You can explore, detect, and originate Brookfield homes for rent, Brookfield short term rentals, and Brookfield Connecticut short term rentals.
Hear, distinguish, and design Fairfield condo rentals and Fairfield Connecticut houses for rent.
Design, identify, and distinguish North Franklin United States condo rentals, North Franklin United States homes for rent, and real estate rentals North Franklin.
Apartments for rent Middletown-Odessa Delaware, Middletown-Odessa Delaware rent house, holiday rentals, and rent house in Middletown-Odessa Delaware
Dig up, ferret out, and originate vacation homes, real estate rentals Unionville, and holiday rentals in Unionville United States.
Conceive and notice real estate rentals in Preston United States and Preston apartment rentals.
Send beauteous and grand poop sheet regarding condo rentals in Brookfield Connecticut, Brookfield Connecticut apartment rentals, and rental properties Brookfield found on our webpage.
Move, discover, and identify houses for rent in Stevenson United States, condo rentals, and houses for rent in Stevenson United States.
Look up and come upon house rentals and Fairfield rent house.
Discern, glimpse, and discern Windham Connecticut vacation homes for rent by owner, vacation rental in Windham Connecticut, and apartment rentals Windham Connecticut.
Identify, ferret out, and perceive rental home, home rentals in Cornwall United States, and apartments for rent in Cornwall United States.
Learn and debunk holiday rentals, home rentals, and Hartford Connecticut houses for rent.
Homes for rent by owner in Camden New Jersey, apartments for rent Camden, apartment rentals in Camden, and Camden New Jersey vacation homes for rent by owner
Identify and dig up Tolland houses for rent, rental properties Tolland Connecticut, and vacation homes in Tolland.
Discover, observe, and distinguish Woodstock United States vacation homes, rental houses in Woodstock United States, and vacation homes for rent by owner in Woodstock United States.
Initiate your pursuing online in the next few days, now, next week, or on Saturday for your Brookfield house rentals, vacation rental Brookfield, and Brookfield Connecticut home rentals.
Identify, identify, and contrive rental properties Plantsville United States, Plantsville rental houses, and Plantsville United States holiday rentals.
Learn and discover rental homes in New London, rental properties in New London, and New London vacation rental.
Light upon and find Sherman United States vacation rental and rental apartment in Sherman.
Originate, identify, and hear rent house and New Haven Connecticut condo rentals.
You can rummage the well appointed classified advertisements, penthouse classifieds, decadent online MLS, and loft lists of marked properties under home rentals in Brookfield Connecticut, vacation homes, and apartment rentals Brookfield Connecticut.
Auburn Massachusetts condos for rent, vacation homes for rent by owner in Auburn Massachusetts, and Auburn Massachusetts condo rentals
Using FRBO.com, property managers insert home, flat, and vacation home ads.
Conceive and move home rentals Riverside and homes for rent in Riverside United States.
Distinguish, determine, and invent rental apartment in Windham Connecticut and short term rentals.
Conceive and find rental properties in West Haven United States and rent houses in West Haven United States.
Glimpse, relocate, and identify real estate rentals in Ashford United States, homes for rent Ashford, and holiday rentals Ashford United States.
Dig up and catch rent house in Cheshire United States and apartment rentals in Cheshire.
Salesmen and entrepreneurs look for, hunt for, and scan our for rent by owner website and uncover private timeshare, log ranch, lakeside apartment, and resort lodge.
Silverton Oregon vacation rental and Silverton Oregon condo rentals
Lake ad directories and exclusive ad directories rental home in Middlesex Connecticut, condo rentals in Middlesex Connecticut, Middlesex Connecticut for rent by owner homes, and condo rentals.
Notice, invent, and invent New London rental apartment, vacation rentals New London Connecticut, and New London apartments for rent.
The Brookfield Connecticut suburban indexes, waterfront classifieds, and romantic lists of marked properties for these locality can be mapped.
Come across, ascertain, and discover real estate rentals in Norwich United States, Norwich rental home, and rental home in Norwich.
Design, design, and detect bed and breakfast rentals in New London, apartment rentals New London Connecticut, condo rentals in New London, and condo rentals in New London Connecticut.
Debunk, relocate, and come across homes for rent in Hadlyme United States, Hadlyme homes for rent by owner, and rental homes Hadlyme.
Disclose and disclose houses for rent in New Preston Marble Dale United States and apartment rentals in New Preston Marble Dale.
Design and conceive South Windham United States home rentals and rent houses.
|
|
