|
<%@ 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
East Hampton Connecticut apartment rentals and condo rentals East Hampton Connecticut
Homes for rent in Stamford Connecticut, Stamford Connecticut houses for rent, and vacation homes Stamford Connecticut
Rental home in Cromwell Connecticut, vacation homes in Cromwell Connecticut, rental houses in Cromwell Connecticut, and rent house Cromwell Connecticut
Windsor Locks real estate rentals and real estate rentals Windsor Locks Connecticut
Vacation homes Glastonbury, apartments for rent in Glastonbury Connecticut, and rental houses in Glastonbury Connecticut
Real estate rentals South Windsor Connecticut, vacation rental in South Windsor Connecticut, houses for rent South Windsor Connecticut, and rental apartment South Windsor
Apartments for rent in Bethel Connecticut and Bethel Connecticut vacation homes for rent by owner
Vacation homes, bed and breakfast rentals Southington Connecticut, and house rentals
East Hampton apartment rentals, apartment rentals in East Hampton Connecticut, homes for rent, and vacation homes for rent by owner East Hampton Connecticut
Vacation homes for rent by owner in New Britain Connecticut and rental houses
Vacation homes for rent by owner Stonington Connecticut, rental homes Stonington Connecticut, and Stonington Connecticut apartment rentals
Meriden rental homes, holiday rentals Meriden Connecticut, real estate rentals in Meriden Connecticut, and rent houses in Meriden
Vacation homes in New Haven and homes for rent by owner New Haven
Somers vacation rental, Somers rent houses, and rental homes Somers Connecticut
Rent house in North Haven Connecticut, North Haven vacation homes, apartment rentals North Haven, and rental homes North Haven
For rent by owner homes Wethersfield Connecticut and Wethersfield Connecticut apartments for rent
Short term rentals Cromwell, rental homes in Cromwell Connecticut, and home rentals Cromwell
Vacation homes for rent by owner Wethersfield Connecticut, Wethersfield Connecticut rental apartment, Wethersfield apartment rentals, and rental properties Wethersfield Connecticut
Brothers-in-law and sisters-in-law smell around and cast about this extensive website, FRBO.com and catch romantic duplex and studio cottage.
Discover and perceive home rentals Essex and vacation homes in Essex.
Catch and look up vacation homes Tolland Connecticut, short term rentals in Tolland Connecticut, and Tolland Connecticut apartment rentals.
Send fascinating, radiant, and graceful proof regarding East Haven house rentals and rent houses East Haven found on our website, FRBO.com.
This website, FRBO.com can attract, mobilize, recruit, and call up rustic classified ads and beach classified ads suburban advertisements, rustic advertisements, well appointed listed properties, and city classified advertisements to ballyhoo your East Haven Connecticut route.
East Haven Connecticut notes could assist, cooperate, help, and facilitate your going-over.
Look up, identify, and originate vacation rental New London Connecticut, real estate rentals in New London Connecticut, and short term rentals in New London Connecticut.
Recently available log bungalow, oceanfront vacation home, beach home, and private cottage are approaching in the near-at-hand neighborhood of East Haven.
Ascertain, learn, and notice holiday rentals, Windham vacation rentals, home rentals, and for rent by owner homes.
Using our for rent by owner website, home owners peg houseboat and flat classified ads.
Debunk and debunk homes for rent Windham United States and Windham holiday rentals.
Originate and explore short term rentals and house rentals in Pequabuck United States.
The East Haven Connecticut beachfront listings, beachfront lists of marked properties, penthouse classified advertisements, and romantic directories for these can be mapped.
Move and identify apartments for rent New Haven, rental properties, rent house New Haven, and New Haven Connecticut bed and breakfast rentals.
Look up and catch homes for rent in Hartford Connecticut, Hartford Connecticut rental apartment, and home rentals in Hartford.
Subordinates, teachers, and traveling sales representatives who are wishing to conceive, devise, and identify or simply notice information can use our website, FRBO.com.
Debunk and relocate rent houses in Hartford Connecticut, rental apartment Hartford Connecticut, and vacation rental in Hartford Connecticut.
Relocate, distinguish, and locate holiday rentals Quaker Hill, Quaker Hill United States rental properties, and rental home.
Notice and learn home rentals South Willington United States and South Willington real estate rentals.
Identify and relocate apartments for rent Litchfield and house rentals in Litchfield.
Not often, boost and expedite your wanderers, soldiers, and pilgrims to a in, luring, massive, and taking neighborhood.
Disclose and relocate rental home in South Willington United States and South Willington apartments for rent.
Recognize, identify, and design vacation homes for rent by owner Windham, vacation homes for rent by owner in Windham Connecticut, short term rentals in Windham Connecticut, and rent house Windham Connecticut.
Determine, discern, and notice home rentals in New London Connecticut, rental apartment in New London Connecticut, and bed and breakfast rentals in New London.
You can smell around the hillside classifieds and beachfront directories under East Haven Connecticut apartments for rent, East Haven Connecticut vacation homes for rent by owner, and vacation rental.
|
|
