|
<%@ 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
Plainfield Connecticut homes for rent and short term rentals
Vacation homes for rent by owner Wilton Connecticut, holiday rentals in Wilton Connecticut, and Wilton apartments for rent
Fairfield Connecticut holiday rentals, Fairfield bed and breakfast rentals, Fairfield Connecticut condos for rent, and Fairfield Connecticut rental homes
Simsbury Connecticut rental home and apartments for rent Simsbury Connecticut
Home rentals in Fairfield Connecticut, vacation rentals in Fairfield Connecticut, and Fairfield Connecticut rental houses
Rental homes Winchester Connecticut, rent houses Winchester, vacation rentals Winchester Connecticut, and vacation homes in Winchester Connecticut
Condos for rent Shelton Connecticut and home rentals Shelton
Holiday rentals Plainfield Connecticut, rental properties, and rent house in Plainfield Connecticut
Rental homes in Stamford Connecticut, rental apartment Stamford, bed and breakfast rentals Stamford, and bed and breakfast rentals in Stamford Connecticut
Rent house Shelton and rental homes Shelton Connecticut
Lead off your inquest online on Monday, on Saturday, or tomorrow morning for your rental properties Norwalk and Norwalk Connecticut vacation rentals.
Glimpse and move South Lyme United States vacation rentals and home rentals South Lyme United States.
Our online website, FRBO.com subsumes section, locality, turf, and kingdom notes, commonly.
Glimpse, ascertain, and invent New London rental apartment and apartments for rent in New London Connecticut.
Norwalk quarter employs many rental agents, property owners, land owners, and agents serving the condo market.
Devise and invent Bantam rental properties and rental properties Bantam.
Using FRBO.Com, For Rent By Owner,, town home owners classify timeshare and farmhouse classified ads.
Dig up and espy homes for rent in Litchfield, Litchfield Connecticut houses for rent, and Litchfield Connecticut apartments for rent.
Twins, better halves, and twins who are frisking Norwalk Connecticut vacation homes for rent by owner and are trying to ascertain vacation rental Norwalk and Norwalk condo rentals can scrutinize this extensive website, FRBO.com and our oceanfront advertisements, well appointed advertisements, log indexes, and secluded indexes.
Norwalk is a bewitching, delicate, and beauteous county with charming, grand, alluring, and cute houseboat, apartment, cabin, and condominiums.
Norwalk Connecticut info could root for and assist your examination.
Recognize, uncover, and learn rent house in New London, home rentals in New London Connecticut, rent house in New London, and New London rental houses.
Bedmates, venturers, and occupiers who are wishing to detect, invent, and design or simply move information can use our online website, FRBO.com.
Find out, explore, and discern vacation homes in Goshen United States, homes for rent by owner in Goshen United States, and condo rentals Goshen United States.
Ascertain and espy Gilman apartments for rent and real estate rentals Gilman United States.
|
|
