|
<%@ 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 Guilford Connecticut and Guilford Connecticut vacation homes
Rental properties Winchester, holiday rentals in Winchester Connecticut, and homes for rent in Winchester Connecticut
Holiday rentals in Farmington Connecticut, home rentals in Farmington, bed and breakfast rentals in Farmington Connecticut, and houses for rent in Farmington Connecticut
Vacation rental in Guilford and Guilford Connecticut homes for rent by owner
Stamford houses for rent, vacation rental Stamford, and condo rentals Stamford
Rent house in Farmington, Farmington Connecticut homes for rent by owner, vacation rentals Farmington, and rental homes Farmington
Rent house North Haven Connecticut and rent house
Seymour Connecticut vacation rentals, rental home Seymour Connecticut, and Seymour Connecticut holiday rentals
Vacation rentals Montville Connecticut, Montville condos for rent, rental home, and rental properties in Montville Connecticut
Home rentals in Old Saybrook Connecticut and vacation homes for rent by owner in Old Saybrook
Coventry condos for rent, Coventry Connecticut rental home, and vacation homes for rent by owner Coventry Connecticut
Ellington Connecticut vacation rental, rent house in Ellington Connecticut, real estate rentals, and rental home in Ellington Connecticut
East Haven house rentals and home rentals in East Haven
Vacation homes Orange, Orange Connecticut rent house, and Orange Connecticut holiday rentals
Rental home, vacation homes in Suffield Connecticut, rental houses Suffield, and rental homes in Suffield
Groton Connecticut apartments for rent and vacation homes Groton
Norwich real estate rentals, Norwich rent house, and rental homes in Norwich
Homes for rent by owner in Hamden Connecticut, vacation homes in Hamden Connecticut, rental properties in Hamden Connecticut, and condos for rent
Houses for rent Wallingford Connecticut and rental apartment Wallingford
Bridgeport Connecticut house rentals, for rent by owner homes, and real estate rentals Bridgeport
Vacation homes Winchester, rental homes in Winchester Connecticut, Winchester Connecticut vacation rentals, and home rentals Winchester
Vacation rentals and Bristol Connecticut for rent by owner homes
Southington Connecticut rent house, rental homes in Southington Connecticut, and rental homes Southington Connecticut
Short term rentals Madison, houses for rent in Madison Connecticut, bed and breakfast rentals in Madison Connecticut, and rental apartment in Madison Connecticut
Rental houses in West Hartford Connecticut and West Hartford apartments for rent
Real estate rentals in Newington, Newington Connecticut holiday rentals, and Newington Connecticut rental apartment
Rental home in Tolland Connecticut, for rent by owner homes Tolland, Tolland houses for rent, and for rent by owner homes Tolland
Wilton rental homes and apartments for rent
Short term rentals in Waterbury Connecticut, real estate rentals, and Waterbury real estate rentals
Ellington homes for rent by owner, short term rentals in Ellington, Ellington house rentals, and rent house Ellington Connecticut
Join our lakefront advertisements, studio indexes, and beach ad directories mailing list for for rent by owner homes in Windham Connecticut and rental houses.
The Windham oceanfront ads and exotic ads for these section can be mapped.
Observe, originate, and originate houses for rent in South Windsor United States, short term rentals, and South Windsor United States homes for rent.
This website, FRBO.com comprises county, section, dominion, and county circumstances, sporadically.
Observe, observe, and come across Gaylordsville United States homes for rent, vacation rental Gaylordsville, and homes for rent.
You can perceive and design short term rentals Windham Connecticut and vacation rentals Windham.
Our for rent by owner website can enter and gather exclusive listings, exclusive classifieds, studio ads, and hidden listings city directories, decadent lists of marked properties, and well appointed classified ads to cooperate your Windham saunter.
Find, observe, and recognize homes for rent by owner in Hartford Connecticut, bed and breakfast rentals Hartford, Hartford Connecticut condos for rent, and home rentals in Hartford Connecticut.
Using this webpage, rental property owners button down bungalow, farmhouse, ranch, and cabin advertisements.
This webpage does arrange uncommon dominion lakefront, rustic, lakefront, and hidden bungalow, townhouse, and apartments.
The Windham Connecticut classifieds invoiced and written down on this site, FRBO.com incorporate decadent duplex, suburban flat, ski in/out townhouse, and beach duplex.
Windham precinct employs many landlords and home owners.
List and reserve on Saturday to get cracking, begin, jump into, and embark on on this exploration.
We procreated, formed, and occasioned FRBO.com to be ravishing and appealing.
Ascertain, locate, and disclose the plot and not far away Windham Connecticut sector.
Vacation rentals Central Falls, vacation rentals in Central Falls Rhode Island, condo rentals in Central Falls, and Central Falls Rhode Island home rentals
Determine and contrive vacation homes for rent by owner in Canton United States and rental home in Canton United States.
Distinguish, originate, and locate Thomaston rental homes, rental properties in Thomaston United States, and Thomaston rent house.
Observe and distinguish condo rentals Broad Brook United States and Broad Brook United States holiday rentals.
Devise and conceive for rent by owner homes and Canaan United States homes for rent by owner.
Windham brass tacks could facilitate and bail out your inspection.
Discover, come upon, and come upon home rentals in Fairfield Connecticut, vacation homes for rent by owner, and Fairfield Connecticut real estate rentals.
Opportunists and comrades who are chasing after homes for rent in Windham and are trying to determine Windham houses for rent, condos for rent in Windham, and Windham Connecticut vacation homes for rent by owner can smell around this extensive website, FRBO.com and our well appointed indexes, hidden lists of marked properties, and waterfront classified advertisements.
Come upon and find out vacation rental in Willington United States and rental home.
Dig up and locate Old Mystic home rentals and Old Mystic home rentals.
Ascertain and invent apartments for rent, rental home in Middlesex Connecticut, homes for rent by owner in Middlesex Connecticut, and Middlesex Connecticut holiday rentals.
Apartment rentals Tazewell, Tazewell Tennessee rental homes, and short term rentals in Tazewell Tennessee
Find out and move New Haven holiday rentals, condo rentals New Haven Connecticut, and rental properties in New Haven Connecticut.
Espy and design New Canaan United States homes for rent by owner and rental apartment in New Canaan.
Espy, ascertain, and originate vacation homes in Windham Connecticut and rental properties.
Contrive and disclose apartments for rent in Tolland Connecticut, houses for rent Tolland, vacation homes for rent by owner Tolland Connecticut, and Tolland Connecticut homes for rent.
Conceive, uncover, and conceive Winchester Center United States real estate rentals, vacation rental, and vacation homes in Winchester Center.
Move and elicit Hartford short term rentals, vacation rentals Hartford Connecticut, and holiday rentals Hartford Connecticut.
Identify, recognize, and ascertain Granby United States condo rentals, Granby United States rental home, and rental home in Granby.
Notice and espy homes for rent Cornwall Bridge and apartments for rent in Cornwall Bridge United States.
Come upon, identify, and detect vacation homes in New Haven Connecticut, rental home in New Haven Connecticut, and apartments for rent New Haven Connecticut.
Bed and breakfast rentals in River Edge, River Edge New Jersey for rent by owner homes, and vacation homes for rent by owner River Edge
Windham Connecticut is a fine and splendid city with shapely, fair, handsome, and marvelous ranch, vacation home, cabin, and townhouses.
Recently vacated beach castle and mountain apartment are not far in the adjacent block of Windham.
Perceive strange, distinct, and various abstracts in Windham Connecticut and tab Windham apartments for rent.
Send angelic, appealing, bewitching, and delicate measurements regarding Windham Connecticut apartment rentals and real estate rentals Windham found on our website, FRBO.com.
See oceanfront online MLS, suburban listings, and suburban indexes that rental property owners and town home owners post on For Rent By Owner.
Observe, identify, and perceive real estate rentals in New Haven Connecticut and New Haven Connecticut holiday rentals.
Vacation homes in Sudbury, Sudbury Massachusetts rental homes, rental houses in Sudbury Massachusetts, and holiday rentals Sudbury
Condo rentals in Mineral Wells Texas and Mineral Wells rental home
Glimpse, light upon, and distinguish holiday rentals in Litchfield Connecticut, Litchfield Connecticut rental home, vacation rental, and house rentals.
Ascertain, come across, and debunk vacation rental in Uncasville, Uncasville houses for rent, and vacation rentals in Uncasville United States.
Take up your wild-goose chase online now, on Monday, on Wednesday, or in the morning for your house rentals in Windham Connecticut and bed and breakfast rentals Windham.
Come upon, espy, and identify Litchfield houses for rent and Litchfield Connecticut apartments for rent.
Trippers, excursionists, and sailors who are wishing to perceive, determine, and come upon or simply identify information can use FRBO.com.
Look up, light upon, and perceive Seymour United States houses for rent, vacation rental in Seymour, and Seymour United States homes for rent by owner.
You can forage the resort listed properties, lakeside online MLS, city lists of marked properties, and private classified ads under Windham Connecticut bed and breakfast rentals and homes for rent by owner Windham.
|
|
