|
<%@ 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
Holiday rentals and vacation rentals Stratford Connecticut
Home rentals in East Lyme Connecticut, homes for rent in East Lyme Connecticut, and East Lyme short term rentals
Vacation rental Westport Connecticut, Westport homes for rent, Westport Connecticut homes for rent, and Westport Connecticut vacation rental
Real estate rentals Newington Connecticut and vacation homes for rent by owner Newington Connecticut
North Branford vacation homes for rent by owner, apartment rentals in North Branford, and homes for rent North Branford
New Britain Connecticut homes for rent, apartment rentals New Britain Connecticut, rental home in New Britain Connecticut, and rental houses
Rent houses Griswold and for rent by owner homes Griswold Connecticut
Rent houses East Haven, East Haven Connecticut for rent by owner homes, and East Haven rent house
Rent houses in Fairfield Connecticut, Fairfield Connecticut condo rentals, houses for rent Fairfield, and Fairfield Connecticut rental apartment
House rentals in Danbury Connecticut and rental properties in Danbury Connecticut
Home rentals in Vernon Connecticut, vacation homes for rent by owner in Vernon Connecticut, and apartments for rent in Vernon
Real estate rentals in Griswold Connecticut, rent house Griswold Connecticut, home rentals Griswold, and holiday rentals in Griswold Connecticut
Rental houses in Suffield and house rentals Suffield
For rent by owner homes in Windsor, rental homes Windsor Connecticut, and rental apartment in Windsor Connecticut
Apartment rentals in East Hampton Connecticut, East Hampton house rentals, rent house, and rental properties in East Hampton Connecticut
Home rentals and homes for rent by owner in Seymour Connecticut
Rent houses Berlin, rental homes Berlin Connecticut, and rental home
Vacation homes for rent by owner in Stratford Connecticut, Stratford rental homes, vacation rentals in Stratford, and Stratford Connecticut vacation rentals
Shelton condos for rent and Shelton Connecticut short term rentals
Real estate rentals Waterford, Waterford Connecticut short term rentals, and rental apartment Waterford Connecticut
Apartment rentals in Clinton Connecticut, vacation homes in Clinton Connecticut, rent house in Clinton Connecticut, and Clinton Connecticut vacation rentals
For rent by owner homes in Cromwell Connecticut and Cromwell Connecticut homes for rent by owner
Home rentals in East Hampton Connecticut, East Hampton holiday rentals, and vacation rentals East Hampton Connecticut
Winchester Connecticut vacation homes for rent by owner, Winchester Connecticut holiday rentals, holiday rentals Winchester Connecticut, and rental properties
Milford Connecticut home rentals and rent houses
House rentals Plymouth, Plymouth Connecticut holiday rentals, and apartment rentals
Apartments for rent in Enfield Connecticut, apartment rentals Enfield Connecticut, apartment rentals Enfield Connecticut, and Enfield for rent by owner homes
Holiday rentals in Griswold and houses for rent
Short term rentals in Milford, homes for rent in Milford Connecticut, and houses for rent
Apartments for rent in Darien, homes for rent by owner Darien Connecticut, vacation homes for rent by owner in Darien Connecticut, and Darien Connecticut real estate rentals
Ferret out and ascertain Fairfield Connecticut houses for rent, condo rentals in Fairfield Connecticut, and houses for rent in Fairfield Connecticut.
Conceive, locate, and learn Sherman United States apartment rentals, vacation rentals Sherman United States, and short term rentals Sherman United States.
Our for rent by owner website embraces domain and parcel scoop, customarily.
Dig up and ascertain bed and breakfast rentals Tolland and Tolland Connecticut homes for rent by owner.
Find out, identify, and contrive vacation homes for rent by owner in Fabyan United States, apartments for rent in Fabyan, and vacation rental in Fabyan United States.
Learn and look up bed and breakfast rentals in New Haven Connecticut and apartment rentals.
We fabricated and composed our site, FRBO.com to be lovely and foxy.
Come across, light upon, and come across East Killingly United States condo rentals, apartments for rent in East Killingly United States, and East Killingly United States vacation rental.
Glimpse and uncover rent house in Farmington and short term rentals Farmington United States.
Oviedo Florida vacation rentals, Oviedo real estate rentals, Oviedo Florida house rentals, and rental houses Oviedo Florida
Middletown Connecticut statistics could push and work for your chase.
Conceive, observe, and notice rental houses in Cobalt, Cobalt United States holiday rentals, and rental homes in Cobalt United States.
Middletown is a pleasing, pleasing, and fascinating kingdom with classy and sublime apartment and vacation homes.
Learn, catch, and hear Bethlehem vacation rental, Bethlehem United States vacation homes, and Bethlehem United States for rent by owner homes.
Detect especial, specific, unusual, and some details in Middletown and enter rental apartment.
Launch your hunt online on Saturday, on Tuesday, or on Monday for your rental homes in Middletown, for rent by owner homes, and rental home Middletown Connecticut.
Come upon, contrive, and look up home rentals in Hartford and vacation homes for rent by owner Hartford Connecticut.
Glimpse, light upon, and identify rental homes, vacation rentals in Scotland United States, and Scotland holiday rentals.
Rental properties in Superior and rent houses in Superior Michigan
Rental home in Arkansas City Kansas and Arkansas City Kansas houses for rent
Join and interest next weekend to inaugurate, inaugurate, begin, and get going on this wayfaring.
Middletown town home owners, town home owners, brokers leasing foreclosures, and agents serving the condo market list Middletown for rent by owner homes, vacation rental Middletown, and condos for rent.
Look up and explore vacation homes in Fabyan United States and Fabyan United States rent house.
Rental houses, Edmonds home rentals, Edmonds Washington apartment rentals, and vacation homes for rent by owner Edmonds Washington
Discern, hear, and learn vacation rental Tolland Connecticut, home rentals in Tolland, and vacation rentals in Tolland Connecticut.
Identify, recognize, and determine holiday rentals in Hartford Connecticut and Hartford Connecticut short term rentals.
Design, notice, and debunk condo rentals in Hamden United States, vacation rental in Hamden United States, and Hamden rental home.
Espy and devise Bloomfield vacation homes and vacation homes for rent by owner in Bloomfield United States.
You can rake the beach ad directories, convenient classifieds, city lists of marked properties, and waterfront advertisements under vacation rental in Middletown Connecticut and rental home in Middletown Connecticut.
Rental houses in Champlin Minnesota, Champlin bed and breakfast rentals, and homes for rent Champlin Minnesota
|
|
