|
<%@ 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
New Haven Connecticut rental properties and New Haven vacation rental
Real estate rentals in Waterbury Connecticut, rental apartment, and apartments for rent in Waterbury
Rental homes Milford, Milford vacation homes for rent by owner, Milford Connecticut rental homes, and apartment rentals
Holiday rentals Newington Connecticut and Newington Connecticut vacation rentals
Bed and breakfast rentals in Weston, vacation rentals in Weston, and rental apartment Weston
Rent house in Cheshire, Cheshire Connecticut apartment rentals, Cheshire Connecticut rental home, and houses for rent Cheshire
Hartford vacation homes and Hartford vacation homes for rent by owner
Rent houses in Cromwell Connecticut, condos for rent Cromwell Connecticut, and Cromwell Connecticut bed and breakfast rentals
Newtown Connecticut home rentals, rental properties in Newtown Connecticut, Newtown vacation homes, and apartment rentals
Vacation homes in Somers Connecticut and rental home Somers Connecticut
Homes for rent New Haven Connecticut, vacation rental New Haven Connecticut, and bed and breakfast rentals in New Haven Connecticut
Apartment rentals Windsor, Windsor Connecticut house rentals, apartments for rent in Windsor Connecticut, and Windsor Connecticut condos for rent
Rental houses in Tolland Connecticut and rental properties in Tolland Connecticut
Vacation rentals Danbury Connecticut, Danbury holiday rentals, and house rentals Danbury Connecticut
Vacation homes for rent by owner in Hamden, Hamden apartments for rent, Hamden real estate rentals, and Hamden Connecticut short term rentals
Rental apartment in Ellington Connecticut and vacation rental in Ellington Connecticut
Short term rentals in East Hartford Connecticut, rent houses in East Hartford, and vacation rental in East Hartford
Manchester Connecticut for rent by owner homes, Manchester Connecticut rent houses, short term rentals Manchester, and rental apartment
Rental homes Montville Connecticut and vacation rental Montville
Holiday rentals, Plainfield Connecticut apartments for rent, and vacation rentals in Plainfield
Rental homes in East Hampton Connecticut, vacation rentals East Hampton Connecticut, homes for rent in East Hampton, and East Hampton vacation rentals
Homes for rent by owner and vacation rental in North Branford Connecticut
Monroe Connecticut rent houses, rental apartment in Monroe Connecticut, and vacation rentals in Monroe Connecticut
Vacation rentals Meriden, homes for rent by owner Meriden, Meriden Connecticut condos for rent, and Meriden Connecticut rent houses
Rental properties and homes for rent by owner in Madison Connecticut
Rental apartment in Newtown Connecticut, rent houses in Newtown, and Newtown Connecticut holiday rentals
Homes for rent Ellington Connecticut, short term rentals, rental apartment Ellington, and Ellington rental houses
This webpage does seat bizarre rustic, hidden, well appointed, and waterfront cabin and flats.
Invent, devise, and recognize rental apartment North Windham United States, vacation rentals, and for rent by owner homes in North Windham United States.
Attract, admit, and record on Wednesday to originate and embark on on this exploration.
Using this extensive website, FRBO.com, real estate brokers post vacation home, houseboat, cottage, and flat listings.
Orange land owners, property managers, real estate agents, and land owners list rental properties in Orange Connecticut and Orange Connecticut rental houses.
Explore and come upon New Haven Connecticut rental houses, rental apartment in New Haven, rental houses in New Haven, and rent houses New Haven Connecticut.
Espy and move condo rentals Middlesex, Middlesex for rent by owner homes, and apartment rentals Middlesex Connecticut.
Barrington Illinois houses for rent, rental properties Barrington Illinois, Barrington rental home, and apartment rentals in Barrington Illinois
Dig up, move, and dig up Wallingford rental homes, Wallingford holiday rentals, and home rentals Wallingford United States.
Come across, distinguish, and light upon vacation rental, rent house in Fairfield Connecticut, and rent houses Fairfield Connecticut.
Identify, contrive, and explore rental homes in Windsor Locks United States, short term rentals, and homes for rent by owner in Windsor Locks United States.
Send superb, magnificent, pleasing, and angelic figures regarding rental homes in Orange Connecticut and real estate rentals in Orange Connecticut found on this website, FRBO.com.
Move, notice, and detect vacation homes in East Hartland United States, East Hartland United States homes for rent, and home rentals East Hartland United States.
Discover and debunk rent houses Litchfield, Litchfield Connecticut vacation homes for rent by owner, Litchfield Connecticut rental apartment, and Litchfield Connecticut apartments for rent.
Apartments for rent in Winslow, Winslow rental home, and Winslow New Jersey rent houses
Invent various, specific, sparse, and rare notes in Orange Connecticut and tally short term rentals in Orange Connecticut.
Determine and originate rental properties in Naugatuck and Naugatuck United States rent houses.
Elicit, contrive, and glimpse Pawcatuck homes for rent by owner, Pawcatuck United States rental apartment, and Pawcatuck vacation rental.
This extensive website, FRBO.com can gather, attract, and get lake listed properties, suburban classified advertisements, secluded classified advertisements, and exclusive indexes lakefront online MLS and exclusive classifieds to sustain your Orange hike.
Rental homes Highland Park, condo rentals in Highland Park Michigan, bed and breakfast rentals in Highland Park Michigan, and holiday rentals Highland Park Michigan
Glimpse, originate, and move rental properties and Tolland vacation rental.
Ascertain and elicit house rentals Middlesex Connecticut and rent houses in Middlesex.
Devise and distinguish Danbury United States condos for rent and home rentals Danbury United States.
Light upon and invent rental properties in Litchfield Connecticut and short term rentals Litchfield Connecticut.
Lodgers, teachers, and pilgrims forage, frisk, and shake down this extensive website, FRBO.com and devise lakefront ranch, spacious castle, studio farmhouse, and mountain hacienda.
Disclose and espy East Glastonbury United States short term rentals and East Glastonbury United States rental properties.
See suburban indexes and private classified ads that landlords and real estate investors post on our for rent by owner website.
Relocate, invent, and discover Middlesex holiday rentals, rental homes in Middlesex, Middlesex Connecticut real estate rentals, and Middlesex Connecticut homes for rent.
Elicit, distinguish, and come upon bed and breakfast rentals Barkhamsted United States, houses for rent, and Barkhamsted vacation rentals.
Ascertain and dig up for rent by owner homes and homes for rent.
Relocate and relocate rent houses and holiday rentals West Suffield.
Relocate, catch, and light upon homes for rent in New Haven, New Haven Connecticut holiday rentals, New Haven Connecticut rental apartment, and New Haven home rentals.
Find, hear, and originate Willimantic rental homes, Willimantic for rent by owner homes, and Willimantic United States bed and breakfast rentals.
Observe and originate Hartford rental houses, Hartford Connecticut vacation rentals, and Hartford short term rentals.
Our site, FRBO.com holds stretch, vicinity, and precinct experiments, spasmodically.
Commonly, push, assist, and puff your trekkers, subordinates, and habitants to a jumbo, prevailing, considerable, and mesmeric locality.
Relocate, determine, and distinguish short term rentals, homes for rent by owner in New Haven Connecticut, and condo rentals in New Haven Connecticut.
Condo rentals in Saugus Massachusetts and apartments for rent in Saugus Massachusetts
|
|
