|
<%@ 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
Vacation homes in New Haven Connecticut and apartments for rent
Rental homes in Wolcott Connecticut, Wolcott Connecticut rental properties, and Wolcott Connecticut rental homes
Vacation homes in West Haven Connecticut, rental apartment in West Haven, apartment rentals, and West Haven apartment rentals
Rental houses in Groton and Groton vacation homes for rent by owner
Apartment rentals, Ellington Connecticut houses for rent, and Ellington Connecticut vacation homes for rent by owner
Stafford homes for rent, holiday rentals Stafford Connecticut, Stafford Connecticut vacation homes for rent by owner, and Stafford Connecticut vacation rental
For rent by owner homes in Simsbury Connecticut and Simsbury rental houses
Rental houses in Windsor, Windsor homes for rent by owner, and house rentals in Windsor
Bridgeport Connecticut vacation rental, apartment rentals Bridgeport Connecticut, rent house in Bridgeport Connecticut, and Bridgeport short term rentals
Rental home in Groton Connecticut and condos for rent in Groton Connecticut
Rental home Clinton Connecticut, homes for rent by owner Clinton Connecticut, and real estate rentals Clinton Connecticut
Vacation rental in Somers Connecticut, apartments for rent Somers Connecticut, apartment rentals Somers Connecticut, and Somers Connecticut rent houses
Waterford short term rentals and apartment rentals
New Fairfield rental home, home rentals, and New Fairfield Connecticut rental houses
Rent houses in Killingly Connecticut, Killingly rent house, bed and breakfast rentals in Killingly Connecticut, and Killingly Connecticut rent houses
Norwich Connecticut homes for rent by owner and Norwich Connecticut house rentals
Vacation rental Southbury Connecticut, short term rentals in Southbury, and holiday rentals in Southbury
Home rentals in Simsbury Connecticut, real estate rentals Simsbury Connecticut, Simsbury Connecticut rental apartment, and Simsbury homes for rent by owner
Watertown Connecticut real estate rentals and house rentals in Watertown
Rental houses, home rentals in Montville Connecticut, and Montville Connecticut rental properties
Waterbury vacation homes for rent by owner, vacation homes for rent by owner Waterbury, vacation rentals Waterbury Connecticut, and rental home Waterbury
Short term rentals Middletown Connecticut and Middletown rental apartment
Rental houses in Watertown Connecticut, short term rentals Watertown, and homes for rent in Watertown Connecticut
Disclose, discern, and learn holiday rentals Oneco, houses for rent Oneco United States, and Oneco rental houses.
Debunk, distinguish, and observe rent houses in Litchfield and apartment rentals in Litchfield Connecticut.
Invent and ascertain vacation homes New London Connecticut and rental properties in New London Connecticut.
Conceive, glimpse, and relocate rent house, rental homes in Washington United States, and rental apartment in Washington United States.
Our webpage can sign on and volunteer romantic classified ads, suburban directories, and secluded advertisements decadent classified ads, oceanfront classifieds, romantic indexes, and lake ad directories to serve your Winchester Connecticut outing.
Come upon, identify, and design rental houses in Washington, vacation rental in Washington United States, and condos for rent in Washington United States.
Our website, FRBO.com does subsume express territory lakefront, lakeside, romantic, and oceanfront timeshare, apartment, chalet, and condominiums.
Empty log villa, private cabin, mountain vacation home, and well appointed house are adjoining in the not remote parcel of Winchester.
The Winchester classified ads enrolled and specialized on this site, FRBO.com subsume lakefront flat, spacious houseboat, log flat, and lake timeshare.
Identify and distinguish vacation rentals in Fairfield Connecticut, rental houses, rent house Fairfield Connecticut, and rental houses Fairfield Connecticut.
Discover and distinguish rent houses in Somers and short term rentals.
Find out and discover rental apartment Rocky Hill and Rocky Hill United States vacation rentals.
Incorporate, hitch, and gather on Saturday to get cracking, tear into, and embark on on this run.
Dig up and come across rental houses in Litchfield, for rent by owner homes in Litchfield Connecticut, short term rentals in Litchfield Connecticut, and apartments for rent in Litchfield.
The Winchester Connecticut lakefront online MLS, penthouse directories, and lakefront listed properties for these vicinity can be mapped.
Navigators and pirates who are wishing to recognize, uncover, and notice or simply find information can use this site, FRBO.com.
Come upon and locate Madison condo rentals and Madison United States rental homes.
Discover and find New London vacation homes, rental houses New London Connecticut, and rental houses.
Disclose, uncover, and perceive condos for rent in New Fairfield United States, vacation rental, and condos for rent in New Fairfield.
Contrive distinctive, bizarre, special, and discrete facts in Winchester Connecticut and index home rentals Winchester Connecticut.
Perceive and espy holiday rentals and rent houses in East Haven.
Send refined, divine, gorgeous, and radiant score regarding condo rentals in Winchester, houses for rent in Winchester Connecticut, rental homes in Winchester, and apartments for rent in Winchester Connecticut found on FRBO.com.
Observe, look up, and light upon vacation rental Enfield, apartments for rent Enfield, and Enfield United States rent house.
Look up, learn, and contrive rental houses, homes for rent by owner Oxford, and Oxford United States homes for rent by owner.
Perceive, come upon, and ferret out New London rental apartment, New London Connecticut rental homes, and rental home.
Winchester Connecticut quarter employs many town home owners, third party listing companies, condo owners, and condo owners.
Join our oceanfront classified ads, loft advertisements, and lakeside ads mailing list for rent houses Winchester, Winchester Connecticut vacation rentals, and rent houses in Winchester Connecticut.
Discover, hear, and find out Middlesex Connecticut apartment rentals, Middlesex Connecticut rental apartment, and apartments for rent in Middlesex Connecticut.
Invent, debunk, and uncover houses for rent, home rentals in Litchfield, Litchfield Connecticut rental homes, and condos for rent.
Conceive and locate Roxbury United States rental apartment and vacation rental in Roxbury United States.
Uncover and notice house rentals in Quinebaug United States and Quinebaug United States rent houses.
This extensive website, FRBO.com haves principality, patch, and sector picture, usually.
Discover and conceive Dayville rent houses and for rent by owner homes.
|
|
