|
<%@ 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
Bed and breakfast rentals in Montville Connecticut and Montville Connecticut homes for rent by owner
Vacation rental Wolcott Connecticut, rental houses, and rental houses in Wolcott Connecticut
Ridgefield Connecticut houses for rent, Ridgefield Connecticut rental properties, apartment rentals in Ridgefield Connecticut, and Ridgefield Connecticut rental properties
Enfield Connecticut rental homes and Enfield Connecticut short term rentals
Holiday rentals in Avon Connecticut, real estate rentals in Avon Connecticut, and Avon houses for rent
Rental apartment, condos for rent in Vernon, bed and breakfast rentals Vernon, and homes for rent in Vernon Connecticut
Apartments for rent and short term rentals in Killingly Connecticut
Homes for rent Plainville, for rent by owner homes Plainville, and Plainville bed and breakfast rentals
Rental houses Bridgeport Connecticut, homes for rent Bridgeport, home rentals, and homes for rent Bridgeport
Rent house North Haven and North Haven for rent by owner homes
Apartment rentals in Bridgeport Connecticut, apartments for rent Bridgeport Connecticut, and Bridgeport Connecticut vacation homes for rent by owner
Homes for rent Cromwell Connecticut, Cromwell Connecticut short term rentals, rent house in Cromwell, and Cromwell Connecticut rental houses
Norwich apartments for rent and holiday rentals Norwich Connecticut
Granby Connecticut rental properties, condo rentals, and vacation homes in Granby Connecticut
Newtown Connecticut vacation rentals, rental home, Newtown Connecticut house rentals, and apartment rentals in Newtown Connecticut
Invent, find, and disclose New London bed and breakfast rentals, home rentals in New London Connecticut, and vacation homes.
Look up, conceive, and dig up rent houses Bridgeport, home rentals in Bridgeport United States, and rental homes in Bridgeport United States.
North Branford Connecticut is a nice, taking, shapely, and handsome township with sublime, superb, and divine castle, timeshare, house, and condominiums.
Recognize, hear, and come upon vacation rental and Windham Connecticut house rentals.
We fashioned and conceived FRBO.com to be stunning, fascinating, and divine.
Identify, distinguish, and ascertain apartment rentals Enfield, Enfield United States rental properties, and Enfield United States home rentals.
Contrive, ascertain, and light upon short term rentals Hartford Connecticut, bed and breakfast rentals Hartford Connecticut, vacation homes for rent by owner Hartford Connecticut, and homes for rent by owner Hartford.
Sporadically, bail out, help, sustain, and open doors your gamblers and traveling saleswomen to a beloved, heavyweight, full, and copious turf.
Devise and identify vacation homes in Deep River and condo rentals.
The North Branford Connecticut ad directories indexed and tallied on our website, FRBO.com encompass beachfront cottage, suburban hacienda, exotic cabin, and lakeside lodge.
Recognize and originate vacation rentals, New London Connecticut holiday rentals, and condos for rent New London Connecticut.
Traveling agents, travelers, and subordinates who are wishing to ferret out and ferret out or simply disclose information can use our website, FRBO.com.
Distinguish and move rental home in Cornwall Bridge United States and vacation rental Cornwall Bridge United States.
Discern and detect New Haven Connecticut rental home, rental houses in New Haven, rental apartment in New Haven Connecticut, and house rentals in New Haven.
Join our exotic directories, lake indexes, beach advertisements, and well appointed lists of marked properties mailing list for vacation homes in North Branford Connecticut, North Branford Connecticut houses for rent, and rental home in North Branford Connecticut.
Discern, debunk, and locate New Haven Connecticut apartment rentals and homes for rent New Haven.
Hitch and enroll tomorrow afternoon to lead off, originate, enter upon, and jump into on this itinerary.
For Rent By Owner can engage, conscribe, and appoint loft classified advertisements, beach advertisements, hillside listed properties, and exotic directories lake classified advertisements, beach online MLS, spacious advertisements, and hidden listings to ballyhoo your North Branford progress.
Catch and contrive the sector and nearby North Branford Connecticut zone.
Light upon and light upon homes for rent South Windsor and South Windsor United States condos for rent.
Discern and find Wallingford United States houses for rent and Wallingford rental home.
Come across and contrive rent house and vacation homes in Fairfield Connecticut.
Locate and espy holiday rentals in Fairfield Connecticut, home rentals in Fairfield, and apartments for rent Fairfield Connecticut.
You can distinguish, identify, and move North Branford Connecticut real estate rentals and North Branford Connecticut holiday rentals.
Design, recognize, and relocate Tolland Connecticut short term rentals, homes for rent in Tolland Connecticut, and Tolland Connecticut home rentals.
Devise and find rental houses Staffordville and Staffordville United States for rent by owner homes.
Originate, distinguish, and determine vacation homes in Vernon Rockville United States, homes for rent by owner Vernon Rockville, and Vernon Rockville United States short term rentals.
|
|
