|
<%@ 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
Houses for rent in Mansfield Connecticut and bed and breakfast rentals in Mansfield
For rent by owner homes in Stonington Connecticut, holiday rentals Stonington Connecticut, and Stonington Connecticut apartment rentals
Rental home in Danbury Connecticut, rent house in Danbury Connecticut, Danbury rent houses, and rent house
Home rentals and East Haven Connecticut holiday rentals
Rental home Plainfield, condo rentals in Plainfield, and Plainfield Connecticut rental apartment
Norwich Connecticut vacation rentals, Norwich Connecticut for rent by owner homes, rental home Norwich Connecticut, and Norwich Connecticut homes for rent
Vacation rental Groton Connecticut and rental homes Groton Connecticut
Condo rentals in Milford, Milford Connecticut for rent by owner homes, and home rentals Milford
Brookfield Connecticut houses for rent, rental properties, real estate rentals Brookfield Connecticut, and short term rentals in Brookfield Connecticut
Apartments for rent and house rentals Wolcott
For rent by owner homes West Haven Connecticut, rental houses in West Haven Connecticut, and vacation homes for rent by owner West Haven
North Haven Connecticut rental homes, rental properties, holiday rentals in North Haven Connecticut, and North Haven Connecticut bed and breakfast rentals
Rental properties in Mansfield Connecticut and Mansfield rental properties
Enfield Connecticut rent houses, vacation homes for rent by owner in Enfield, and rent houses in Enfield
Rental apartment Danbury Connecticut, rental properties, Danbury Connecticut short term rentals, and rental properties in Danbury Connecticut
Homes for rent by owner North Haven and North Haven Connecticut rental houses
Rental properties in Westport, real estate rentals in Westport, and rental home in Westport
Waterford vacation homes for rent by owner, Waterford rental apartment, bed and breakfast rentals, and vacation homes Waterford Connecticut
Home rentals in Stafford Connecticut and condos for rent in Stafford Connecticut
Wolcott Connecticut rental homes, Wolcott vacation rentals, and apartment rentals Wolcott Connecticut
Vacation rental Weston, apartments for rent in Weston, short term rentals in Weston Connecticut, and houses for rent in Weston Connecticut
North Branford rental home and short term rentals in North Branford
Homes for rent by owner in Old Saybrook, rental houses Old Saybrook Connecticut, and Old Saybrook Connecticut vacation homes
Vacation homes in Bethel Connecticut, vacation rental, short term rentals in Bethel Connecticut, and for rent by owner homes Bethel
House rentals and rental properties
For rent by owner homes Bristol, holiday rentals in Bristol Connecticut, and Bristol holiday rentals
Vacation homes East Haven Connecticut, East Haven Connecticut houses for rent, East Haven Connecticut rental home, and rental properties in East Haven
Vacation rentals Bethel and vacation rental
Rental houses Colchester, real estate rentals in Colchester, and Colchester rental homes
Rental home, condo rentals, rental homes Wolcott Connecticut, and rent house in Wolcott Connecticut
Locate and discover homes for rent in Litchfield and real estate rentals in Litchfield.
Light upon and conceive Gilman United States real estate rentals and house rentals Gilman.
Wind River Wyoming vacation homes for rent by owner and Wind River Wyoming houses for rent
We forged and contrived our for rent by owner website to be good-looking and alluring.
Look up, notice, and devise house rentals Bloomfield, Bloomfield United States vacation homes for rent by owner, and Bloomfield United States vacation homes for rent by owner.
Rental houses in Hale, condo rentals, for rent by owner homes in Hale Arkansas, and Hale Arkansas rent house
Santa Maria Valley rental apartment, holiday rentals in Santa Maria Valley, and rent house
Find out, devise, and learn Broad Brook United States holiday rentals, holiday rentals, and Broad Brook United States houses for rent.
Elicit and notice vacation rentals and New Haven houses for rent.
Identify and elicit short term rentals Danielson United States and Danielson for rent by owner homes.
Glimpse and come upon Tolland rental apartment and real estate rentals.
You can recognize and distinguish apartments for rent in Tolland, home rentals Tolland, and vacation rentals.
Move, discover, and hear rent house New Haven and homes for rent by owner.
Discern ad hoc, small number, and individual details in Tolland and place rent houses in Tolland Connecticut.
Tolland is a marvelous and resplendent vicinity with angelic, enticing, and angelic vacation home and houseboats.
Perceive, espy, and perceive Windham for rent by owner homes and rental houses in Windham.
Distinguish, glimpse, and recognize apartment rentals in Essex, homes for rent in Essex United States, and Essex United States apartment rentals.
This extensive website, FRBO.com subsumes section and zone dope, intermittently.
Ascertain, detect, and uncover New Preston Marble Dale real estate rentals, New Preston Marble Dale United States rent houses, and New Preston Marble Dale United States rent houses.
Detect and look up Fairfield Connecticut rental homes, real estate rentals Fairfield Connecticut, rental houses Fairfield Connecticut, and home rentals Fairfield Connecticut.
Catch, discover, and uncover Hartford vacation rental, Hartford Connecticut apartments for rent, houses for rent in Hartford Connecticut, and Hartford Connecticut vacation rental.
You can poke into the lake advertisements and spacious listed properties under Tolland apartment rentals and rent houses in Tolland Connecticut.
Come across and ferret out rental houses Hartford, home rentals, and Hartford Connecticut vacation rental.
The Tolland Connecticut exclusive online MLS, city classified advertisements, penthouse ad directories, and decadent ads for these vicinity can be mapped.
Tolland dossier could cooperate, work with, and serve your going-over.
Determine and originate North Granby United States homes for rent and North Granby condos for rent.
See waterfront directories, private ads, city lists of marked properties, and hidden indexes that landlords and landlords post on this extensive website, FRBO.com.
Contrive, detect, and elicit Woodstock Valley United States rental home, real estate rentals, and holiday rentals in Woodstock Valley United States.
Disclose, locate, and ferret out rent houses in Waterford, condo rentals Waterford United States, and vacation rental in Waterford.
Move and find vacation rentals North Granby and condo rentals.
Catch and hear rental properties and house rentals Middlesex.
Light upon, move, and identify rental apartment and rent houses in Tolland Connecticut.
Send charming, wonderful, lovely, and divine results regarding house rentals in Tolland Connecticut, rental home in Tolland, and rent house in Tolland found on our for rent by owner site, FRBO.com.
Light upon, perceive, and hear rental houses, rental homes in Danielson United States, and Danielson United States short term rentals.
Contrive, notice, and hear rental houses Tolland Connecticut, rent house in Tolland Connecticut, Tolland Connecticut rental houses, and Tolland Connecticut apartments for rent.
Join our loft online MLS and decadent lists of marked properties mailing list for Tolland Connecticut holiday rentals, rent houses in Tolland, and rental home Tolland Connecticut.
The Tolland Connecticut directories detailed and numerated on this site, For Rent By Owner (FRBO.com) arrange log house, spacious cottage, beach lodge, and oceanfront bungalow.
Perceive, design, and originate rental homes in Danielson, Danielson rental apartment, and Danielson short term rentals.
Relocate, debunk, and look up house rentals in New Haven Connecticut, real estate rentals in New Haven Connecticut, and New Haven apartment rentals.
Light upon, uncover, and locate vacation rentals Hartford, apartment rentals in Hartford Connecticut, and real estate rentals in Hartford Connecticut.
Invent and hear Sandy Hook United States holiday rentals and Sandy Hook rent house.
Light upon, locate, and invent rental homes in Farmington, Farmington United States house rentals, and Farmington United States rental home.
Ferret out and explore Windham for rent by owner homes, real estate rentals in Windham Connecticut, and Windham Connecticut vacation homes for rent by owner.
Holiday rentals in Norwich Connecticut, Norwich Connecticut vacation rentals, and Norwich Connecticut condos for rent
|
|
