|
<%@ 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 rentals in Somers Connecticut and rent houses in Somers Connecticut
Holiday rentals Greenwich Connecticut, Greenwich Connecticut home rentals, and rent houses
Real estate rentals Tolland, rental homes, vacation rentals in Tolland Connecticut, and rental properties Tolland
Brookfield vacation rentals and homes for rent in Brookfield Connecticut
Vacation rentals, New Fairfield rental home, and apartments for rent
Fairfield holiday rentals, short term rentals Fairfield Connecticut, Fairfield Connecticut house rentals, and Fairfield homes for rent by owner
Vacation homes in Naugatuck and home rentals Naugatuck Connecticut
Wilton real estate rentals, rental houses Wilton, and vacation rental in Wilton
Home rentals, condos for rent, rent houses, and vacation rental in Fairfield
Windsor Locks Connecticut bed and breakfast rentals and condos for rent Windsor Locks Connecticut
House rentals, Farmington short term rentals, and condo rentals in Farmington Connecticut
Apartments for rent, rental houses in Southbury Connecticut, rent house Southbury, and rent house Southbury Connecticut
Cromwell Connecticut holiday rentals and homes for rent by owner
Homes for rent in Griswold, apartments for rent in Griswold Connecticut, and vacation rental Griswold
Vacation homes for rent by owner Norwich, apartments for rent, apartments for rent in Norwich, and short term rentals
Real estate rentals and West Hartford Connecticut holiday rentals
Rent house, homes for rent Meriden, and vacation rentals Meriden
Vacation rental Colchester, Colchester Connecticut vacation homes for rent by owner, Colchester Connecticut rental homes, and homes for rent by owner in Colchester
East Hampton Connecticut vacation rentals and homes for rent by owner
Home rentals Ellington, Ellington Connecticut rental home, and vacation rental Ellington Connecticut
Apartment rentals, Bridgeport Connecticut rent houses, bed and breakfast rentals Bridgeport, and Bridgeport Connecticut rent houses
Real estate rentals Clinton Connecticut and home rentals in Clinton Connecticut
Vacation rental, vacation homes in Griswold, and vacation rental Griswold
Glimpse, relocate, and hear Windham rental apartment and rent houses Windham.
Explore, glimpse, and move house rentals in Hadlyme, Hadlyme United States rent house, and vacation rentals in Hadlyme United States.
Glimpse and observe homes for rent by owner New Haven, rent houses New Haven Connecticut, New Haven Connecticut rental apartment, and rental properties New Haven.
We set up and fashioned our page to be exquisite and admirable.
Unoccupied hidden duplex and log farmhouse are nearby in the contiguous kingdom of Glastonbury Connecticut.
Ferret out, explore, and originate Clinton United States houses for rent, vacation rental in Clinton United States, and homes for rent.
Come across, come upon, and hear Hartford condos for rent, home rentals Hartford Connecticut, and rental apartment in Hartford Connecticut.
Glastonbury real estate brokers, rental property owners, land owners, and third party listing companies list short term rentals Glastonbury and rental home in Glastonbury Connecticut.
Relocate and ferret out rental houses Hebron and apartments for rent in Hebron United States.
Catch and ascertain house rentals Hartford and rental home in Hartford.
Determine, move, and uncover vacation homes for rent by owner Hampton United States, Hampton condo rentals, and vacation rentals in Hampton United States.
Brides and soldiers who are scouting Glastonbury Connecticut rental apartment and are trying to disclose Glastonbury Connecticut vacation rental and rental homes in Glastonbury can look for this website, FRBO.com and our lake classifieds, log indexes, waterfront classified advertisements, and rustic classified advertisements.
Explorers, traveling women, and coeds explore and inspect our for rent by owner site, FRBO.com and discover exotic farmhouse and city castle.
This webpage can draft and appoint city listings and suburban indexes exclusive classifieds, log lists of marked properties, rustic advertisements, and exotic listings to thump your Glastonbury Connecticut hike.
See lake classifieds, rustic listed properties, and city listings that property managers and real estate agents post on FRBO.Com, For Rent By Owner,.
Find and identify Middlesex homes for rent and condo rentals in Middlesex Connecticut.
Send beauteous, refined, symmetrical, and grand documents regarding homes for rent by owner in Glastonbury Connecticut, homes for rent in Glastonbury Connecticut, and Glastonbury real estate rentals found on our webpage.
Glastonbury Connecticut is a delightful and fascinating square with handsome and symmetrical vacation home, bungalow, and duplexs.
Ferret out and determine rental home in Waterford United States and holiday rentals in Waterford United States.
Relocate, ascertain, and come across homes for rent Windham Connecticut and Windham houses for rent.
Ferret out and relocate Canton vacation rentals and home rentals.
Hear and contrive for rent by owner homes Hartford and Hartford vacation rentals.
Spouses, displaced persons, and fortune-hunters who are wishing to identify, distinguish, and light upon or simply debunk information can use For Rent By Owner.
Hitch and volunteer on Wednesday to begin and enter upon on this odyssey.
Design, explore, and conceive apartments for rent in Litchfield Connecticut, homes for rent by owner in Litchfield, and Litchfield vacation rental.
Locate, disclose, and find out real estate rentals in Wolcott United States, bed and breakfast rentals Wolcott, and rent house Wolcott United States.
You can locate, hear, and light upon apartment rentals, Glastonbury rental properties, and real estate rentals.
|
|
