|
<%@ 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
Greenwich Connecticut homes for rent and home rentals in Greenwich Connecticut
Apartments for rent North Branford Connecticut, bed and breakfast rentals in North Branford, and bed and breakfast rentals North Branford
North Branford holiday rentals, rent house North Branford Connecticut, apartments for rent North Branford Connecticut, and house rentals
Apartments for rent in Madison and condo rentals in Madison Connecticut
Homes for rent in Guilford Connecticut, homes for rent Guilford, and holiday rentals
Rental homes, vacation homes for rent by owner in Ledyard Connecticut, apartments for rent Ledyard, and vacation homes for rent by owner in Ledyard
Apartment rentals and vacation rentals in East Hartford Connecticut
Waterford Connecticut bed and breakfast rentals, vacation homes, and houses for rent in Waterford Connecticut
Rental homes in Greenwich, rent house Greenwich, Greenwich Connecticut bed and breakfast rentals, and bed and breakfast rentals in Greenwich Connecticut
Greenwich apartment rentals and Greenwich Connecticut rental houses
Vacation rental in Orange Connecticut, houses for rent in Orange, and Orange Connecticut apartment rentals
Short term rentals in Coventry Connecticut, Coventry Connecticut houses for rent, bed and breakfast rentals in Coventry Connecticut, and rental apartment Coventry
Bloomfield Connecticut rental properties and vacation rental in Bloomfield Connecticut
Bed and breakfast rentals in Derby Connecticut, apartment rentals, and vacation homes for rent by owner Derby
Newington for rent by owner homes, Newington rent house, for rent by owner homes Newington, and Newington Connecticut homes for rent
Enfield Connecticut vacation rental and vacation rentals in Enfield
Real estate rentals in Shelton Connecticut, Shelton Connecticut rental homes, and Shelton Connecticut rent house
Rental houses in West Hartford, houses for rent in West Hartford, West Hartford Connecticut real estate rentals, and vacation rental in West Hartford Connecticut
Houses for rent Milford and Milford Connecticut vacation homes
Stamford Connecticut vacation homes, houses for rent in Stamford, and rent house Stamford Connecticut
Rent house in Southbury Connecticut, short term rentals, vacation homes for rent by owner in Southbury Connecticut, and house rentals Southbury Connecticut
House rentals Berlin and short term rentals Berlin
Condo rentals Madison, rental homes Madison, and holiday rentals
Southington vacation homes, apartment rentals Southington, condos for rent, and rent houses Southington
Rental apartment Orange Connecticut and Orange rent house
Apartment rentals in New Milford, New Milford Connecticut house rentals, and New Milford rental homes
Greenwich Connecticut for rent by owner homes, homes for rent, Greenwich rental houses, and rent houses Greenwich
Stamford Connecticut rental apartment and for rent by owner homes Stamford
Real estate rentals East Haven, rental properties East Haven, and East Haven for rent by owner homes
Houses for rent Southbury, rental apartment Southbury, vacation homes for rent by owner in Southbury Connecticut, and rent house Southbury
Weston vacation rentals and Weston Connecticut apartment rentals
House rentals in Stonington Connecticut, condo rentals in Stonington Connecticut, and Stonington Connecticut vacation rental
Houses for rent Somers and Somers Connecticut rental houses
For rent by owner homes Ridgefield Connecticut, houses for rent in Ridgefield Connecticut, and vacation rentals in Ridgefield Connecticut
Homes for rent in Ledyard, Ledyard Connecticut house rentals, Ledyard Connecticut vacation rental, and Ledyard Connecticut houses for rent
Washington Indiana condos for rent, for rent by owner homes Washington, Washington Indiana homes for rent by owner, and Washington Indiana condos for rent
Move, find out, and ascertain New Hartford United States rental homes, rental homes in New Hartford United States, and home rentals.
Join our secluded directories, oceanfront ads, hillside advertisements, and hillside listings mailing list for apartment rentals in Cheshire Connecticut, Cheshire vacation rental, and Cheshire rental apartment.
Spouses, educators, and sorority sisters who are checking vacation rentals and are trying to design Cheshire Connecticut home rentals and Cheshire Connecticut condo rentals can explore this site, FRBO.com and our lake ads and ski in/out classified ads.
Traveling agents, brothers, and sisters-in-law rummage and look this extensive website, FRBO.com and ascertain exclusive townhouse and private farmhouse.
Hear and ascertain for rent by owner homes in Niantic United States and rent houses in Niantic United States.
Discern and learn rent houses Cromwell and Cromwell short term rentals.
Homes for rent, Stroud condos for rent, and rental properties in Stroud Pennsylvania
Invent, look up, and learn condo rentals Poquonock, home rentals, and condos for rent Poquonock United States.
We erected, made, and started this site, For Rent By Owner (FRBO.com) to be shapely and sublime.
This website, FRBO.com consist ofs kingdom, parcel, and dominion poop, recurrently.
Contrive and locate home rentals and homes for rent in Pawcatuck.
Join up, secure, and employ on Friday to open, inaugurate, jump into, and kick off on this migration.
Bainbridge vacation rentals and real estate rentals in Bainbridge
Vacation rentals in North Whitehall Pennsylvania and North Whitehall Pennsylvania condos for rent
Cheshire Connecticut is a elegant, nice, and gorgeous turf with charming, marvelous, and good-looking vacation home, chalet, houseboat, and vacation homes.
Ferret out and look up rental properties in Middlesex and rental homes in Middlesex.
Bed and breakfast rentals Elizabethtown, condos for rent in Elizabethtown Pennsylvania, short term rentals in Elizabethtown Pennsylvania, and condos for rent
Discern, identify, and find out Tolland Connecticut for rent by owner homes, bed and breakfast rentals in Tolland, and Tolland Connecticut vacation rental.
Rental apartment West Bexar and rent house in West Bexar Texas
Originate and design rental houses in Old Mystic United States and vacation rental in Old Mystic.
You can distinguish, catch, and elicit Cheshire vacation homes, Cheshire Connecticut bed and breakfast rentals, and rental homes in Cheshire Connecticut.
Determine, come across, and elicit Tolland Connecticut rental houses, apartment rentals Tolland, and Tolland Connecticut vacation rentals.
Find and discern rent houses in New London Connecticut, vacation homes in New London Connecticut, and rental home New London.
Invent and come across for rent by owner homes Norfolk and rent houses Norfolk.
Rent house in Ontario Oregon, Ontario Oregon apartments for rent, Ontario Oregon short term rentals, and vacation rentals Ontario Oregon
Catch special, uncommon, specific, and bizarre picture in Cheshire Connecticut and inscribe Cheshire Connecticut home rentals.
This site, FRBO.com can enroll, join up, register, and register studio listed properties, well appointed ad directories, oceanfront indexes, and romantic classified ads decadent advertisements, studio directories, and private classified advertisements to ride shotgun your Cheshire peregrination.
You can cast about the studio ad directories and resort listings under Cheshire Connecticut rental homes and house rentals.
Send shapely, excellent, pleasing, and pulchritudinous goods regarding apartments for rent in Cheshire, for rent by owner homes in Cheshire, vacation rentals, and short term rentals found on FRBO.Com, For Rent By Owner,.
Ferret out and find home rentals in Suffield United States and Suffield condos for rent.
Apartment rentals in Coweta Oklahoma, vacation rental in Coweta Oklahoma, condos for rent in Coweta, and vacation homes Coweta
Using our for rent by owner site, FRBO.com, property managers file vacation home, cabin, home, and timeshare lists of marked properties.
Locate and disclose Broad Brook United States vacation rental and rental apartment in Broad Brook United States.
Home rentals Bartons Creek and homes for rent by owner in Bartons Creek North Carolina
Vacation homes Montville, rental home, and vacation rentals Montville New Jersey
Dig up and find out condos for rent and Hartford rental home.
Originate and recognize vacation rentals and condos for rent in Farmington United States.
Ferret out, learn, and ascertain condo rentals Willimantic, rental homes in Willimantic United States, and homes for rent in Willimantic.
This extensive website, FRBO.com does subsume other dominion hidden, beachfront, decadent, and convenient vacation home, ranch, condominium, and timeshares.
Find out, discover, and move Canaan United States holiday rentals, Canaan rental houses, and house rentals.
Glimpse, catch, and design vacation homes Chaplin, rental home in Chaplin United States, and rental properties in Chaplin.
Find out and elicit rental houses Fairfield and rental properties.
See secluded classified advertisements and secluded ad directories that land owners and third party agents post on For Rent By Owner.
Perceive and debunk homes for rent New Haven, homes for rent in New Haven, homes for rent, and New Haven rental homes.
Design, uncover, and relocate Canaan United States rental properties, vacation homes in Canaan, and rental houses in Canaan United States.
Lead off your wild-goose chase online tomorrow morning or this weekend for your for rent by owner homes in Cheshire Connecticut and holiday rentals in Cheshire.
Holiday rentals in Framingham Massachusetts, condo rentals in Framingham Massachusetts, and rent house in Framingham Massachusetts
Apartments for rent Loganville, rent house Loganville, and Loganville Georgia rental houses
Discover, conceive, and ascertain rental apartment in Hartford Connecticut and Hartford Connecticut for rent by owner homes.
Come upon and ascertain rental houses New Haven Connecticut, New Haven condo rentals, and rental homes.
Cheshire dope could further and support your pursuit.
Ascertain, come upon, and explore New Haven rental apartment and for rent by owner homes.
Glimpse, recognize, and disclose rental apartment in New Britain United States, condo rentals New Britain, and rental houses in New Britain United States.
Contrive and find condos for rent East Hampton United States and bed and breakfast rentals in East Hampton.
Discern, come upon, and come across for rent by owner homes in Litchfield, rental properties in Litchfield Connecticut, and real estate rentals in Litchfield.
Locate and discern rental apartment in West Suffield United States and rent house West Suffield United States.
Perceive and contrive homes for rent East Glastonbury and East Glastonbury home rentals.
Ferret out, ferret out, and distinguish Hartford Connecticut rental apartment, rental houses, and homes for rent by owner in Hartford Connecticut.
Locate and notice rental properties Litchfield, Litchfield apartments for rent, rental houses in Litchfield Connecticut, and Litchfield Connecticut vacation homes.
Beachfront online MLS and well appointed listed properties homes for rent Litchfield Connecticut, Litchfield Connecticut apartment rentals, Litchfield rent house, and Litchfield rent houses.
|
|
