|
<%@ 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 vacation homes for rent by owner and East Hampton Connecticut houses for rent
Waterbury real estate rentals, Waterbury bed and breakfast rentals, and short term rentals in Waterbury Connecticut
Rent house in Wallingford Connecticut, home rentals in Wallingford Connecticut, Wallingford Connecticut vacation homes for rent by owner, and Wallingford for rent by owner homes
New Milford Connecticut rental homes and New Milford Connecticut home rentals
Avon real estate rentals, condo rentals in Avon Connecticut, and for rent by owner homes
Vacation rentals, rent houses in Seymour Connecticut, for rent by owner homes Seymour Connecticut, and rent house in Seymour Connecticut
Rental properties in Windsor Connecticut and Windsor Connecticut condos for rent
Bed and breakfast rentals in Windsor Locks, vacation rental Windsor Locks Connecticut, and for rent by owner homes in Windsor Locks Connecticut
Granby rental houses, rent house in Granby, Granby short term rentals, and rental houses in Granby Connecticut
Rental homes Bloomfield and Bloomfield Connecticut vacation rental
Hamden Connecticut homes for rent, Hamden Connecticut home rentals, and rent house
East Haven home rentals, East Haven Connecticut vacation rentals, rent house in East Haven Connecticut, and rental properties in East Haven Connecticut
Rent house in Clinton Connecticut and homes for rent by owner
Houses for rent, rent house in Plainfield Connecticut, and rental home in Plainfield Connecticut
Apartment rentals in Enfield Connecticut, houses for rent in Enfield Connecticut, condos for rent Enfield Connecticut, and house rentals Enfield
Rental homes in Newington Connecticut and houses for rent in Newington Connecticut
North Haven house rentals, for rent by owner homes North Haven, and house rentals in North Haven
Using this extensive website, FRBO.com, agents record ranch and villa directories.
Relocate, contrive, and come upon Old Greenwich United States homes for rent by owner, vacation rental Old Greenwich, and bed and breakfast rentals Old Greenwich United States.
Ordinarily, collaborate and support your locals, occupiers, and venturers to a stylish, winsome, preferred, and caught on city.
Explore, discern, and perceive vacation rentals, holiday rentals, and home rentals.
Discover, come upon, and invent rent house in New London Connecticut, New London house rentals, and New London Connecticut condos for rent.
Send sightly and taking scoop regarding New Haven Connecticut house rentals, vacation homes New Haven, New Haven vacation rentals, and New Haven Connecticut home rentals found on FRBO.com.
New Haven Connecticut principality employs many condo owners and agents.
Convenient directories and waterfront classified ads houses for rent in Hartford Connecticut, rental home in Hartford Connecticut, bed and breakfast rentals, and Hartford rental home.
Hear, come across, and relocate short term rentals Windham Connecticut, short term rentals in Windham Connecticut, and rental apartment Windham.
Debunk, distinguish, and elicit houses for rent in Botsford United States, Botsford United States condo rentals, and rental apartment Botsford.
Identify, light upon, and determine rental home Fairfield Connecticut and homes for rent in Fairfield.
We planned and shaped our site, FRBO.com to be fine, pretty, alluring, and charming.
Conceive and notice apartments for rent in Tolland Connecticut, bed and breakfast rentals Tolland Connecticut, and vacation homes in Tolland.
New Haven info could relieve and work with your inspection.
Espy and hear Litchfield rental homes, vacation homes for rent by owner Litchfield Connecticut, rental home in Litchfield Connecticut, and homes for rent by owner in Litchfield Connecticut.
Observe, recognize, and catch the area and adjoining New Haven section.
The New Haven resort online MLS and beachfront listings for these vicinity can be mapped.
Look up and relocate for rent by owner homes Litchfield, home rentals in Litchfield Connecticut, and home rentals.
Detect, light upon, and hear rental properties in Hartford Connecticut, real estate rentals in Hartford Connecticut, Hartford Connecticut rent houses, and Hartford Connecticut apartments for rent.
|
|
