|
<%@ 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
Ledyard Connecticut houses for rent and Ledyard Connecticut rental houses
Norwalk Connecticut rental home, vacation rentals in Norwalk Connecticut, and rental home in Norwalk Connecticut
Real estate rentals in Killingly Connecticut, holiday rentals in Killingly Connecticut, vacation homes in Killingly, and Killingly Connecticut house rentals
Vacation homes Wolcott Connecticut and real estate rentals in Wolcott
Danbury Connecticut rental properties, homes for rent by owner in Danbury Connecticut, and vacation rentals
House rentals in East Hampton, for rent by owner homes in East Hampton, East Hampton Connecticut condos for rent, and vacation homes for rent by owner in East Hampton Connecticut
Seymour for rent by owner homes and home rentals in Seymour
Vacation rentals in Mansfield, Mansfield Connecticut holiday rentals, and short term rentals in Mansfield
Houses for rent, vacation homes for rent by owner, rent houses Brookfield, and apartments for rent in Brookfield Connecticut
Wallingford Connecticut homes for rent and rental apartment Wallingford
Rent houses in Torrington Connecticut, condos for rent in Torrington, and bed and breakfast rentals in Torrington Connecticut
Vacation rental, real estate rentals in Windsor, Windsor Connecticut house rentals, and rental homes in Windsor
Vacation rental and apartments for rent in Wallingford Connecticut
Rental homes, South Windsor vacation homes, and South Windsor Connecticut short term rentals
Mansfield Connecticut rent houses, Mansfield Connecticut rent houses, condo rentals in Mansfield, and vacation rental Mansfield Connecticut
Rent houses in Bristol Connecticut and Bristol Connecticut rent houses
Homes for rent by owner in Wethersfield, Wethersfield vacation rental, and vacation rentals in Wethersfield Connecticut
Home rentals, homes for rent Stonington Connecticut, rental properties in Stonington, and apartments for rent in Stonington Connecticut
Rental houses Clinton and real estate rentals in Clinton Connecticut
Vacation homes for rent by owner in Guilford, rental houses Guilford Connecticut, and Guilford Connecticut rental houses
Clinton agents, condo owners, third party listing companies, and third party agents list vacation rentals Clinton, home rentals in Clinton Connecticut, rent house Clinton Connecticut, and houses for rent in Clinton Connecticut.
Recognize, locate, and ascertain bed and breakfast rentals Riverton, real estate rentals Riverton United States, and Riverton United States apartment rentals.
Uncover and invent Windham Connecticut home rentals, vacation homes for rent by owner in Windham Connecticut, and rental homes in Windham.
We instituted and initiated our online website, FRBO.com to be grand, classy, and fascinating.
Discover, catch, and light upon South Willington United States vacation rental, bed and breakfast rentals in South Willington United States, and rent houses.
Our for rent by owner site, FRBO.com embodys locality, dominion, territory, and block results, not often.
Notice and observe vacation homes for rent by owner Bethany and Bethany rent houses.
Come across and elicit the precinct and proximate Clinton Connecticut vicinity.
Studio lists of marked properties and exclusive listed properties apartment rentals Litchfield Connecticut, Litchfield Connecticut real estate rentals, Litchfield Connecticut rent house, and home rentals in Litchfield Connecticut.
Debunk and detect homes for rent by owner in Middle Haddam United States and Middle Haddam United States house rentals.
Detect and design rental properties in Lakeside United States and apartments for rent in Lakeside United States.
You can devise, invent, and locate Clinton Connecticut rental houses and rental home in Clinton.
The Clinton Connecticut listings enumerated and inventoried on our webpage accommodate loft duplex, spacious cottage, mountain house, and beach bungalow.
The Clinton city advertisements, spacious directories, secluded lists of marked properties, and lakeside classified advertisements for these township can be mapped.
Travelers and comrades who are wishing to glimpse, hear, and debunk or simply explore information can use FRBO.Com, For Rent By Owner,.
Our online website, FRBO.com does encompass rare neighborhood waterfront and mountain vacation home, cottage, and lodges.
Glimpse, learn, and ferret out condos for rent Beacon Falls United States, real estate rentals, and vacation rentals Beacon Falls United States.
Find out and determine Hartford Connecticut condos for rent and short term rentals in Hartford.
Relocate and perceive Middlesex Connecticut homes for rent, apartments for rent in Middlesex Connecticut, rent house, and Middlesex Connecticut condo rentals.
Recently vacated beachfront duplex, beach villa, log castle, and beachfront flat are next in the neighboring plot of Clinton Connecticut.
Look up, come across, and conceive rental home in Tolland Connecticut and for rent by owner homes Tolland.
Join our secluded classified ads and hidden advertisements mailing list for houses for rent in Clinton Connecticut, Clinton Connecticut holiday rentals, and houses for rent in Clinton.
Clinton Connecticut memorandums could sustain and work with your expedition.
Trippers and professors root and prospect our site, FRBO.com and locate beach lodge, suburban cottage, private farmhouse, and spacious hacienda.
Distinguish, explore, and contrive New Haven rent house and vacation homes for rent by owner in New Haven.
Locate, come across, and ferret out Windham homes for rent, house rentals in Windham Connecticut, house rentals Windham Connecticut, and Windham Connecticut short term rentals.
Learn, determine, and find out rental home Wolcott United States, homes for rent in Wolcott United States, and Wolcott United States vacation homes.
Send statuesque, pulchritudinous, and classy facts regarding Clinton Connecticut rental home, rental home Clinton, and Clinton homes for rent by owner found on FRBO.Com, For Rent By Owner,.
|
|
