|
<%@ 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
Rental houses Windham and house rentals in Windham
Naugatuck Connecticut houses for rent, apartment rentals in Naugatuck Connecticut, and condo rentals
Darien Connecticut apartment rentals, home rentals, rental home in Darien Connecticut, and Darien Connecticut for rent by owner homes
Holiday rentals and Granby Connecticut rental home
Rental homes in Brookfield, vacation homes Brookfield, and Brookfield rental houses
Rent houses in Watertown, apartment rentals in Watertown, condo rentals, and rental apartment Watertown Connecticut
Condo rentals in East Lyme Connecticut and houses for rent East Lyme Connecticut
East Hartford Connecticut bed and breakfast rentals, East Hartford condo rentals, and East Hartford Connecticut rent house
Rental properties in Enfield, rental properties in Enfield Connecticut, real estate rentals Enfield, and rental home in Enfield Connecticut
Rental home in Mansfield and apartment rentals in Mansfield
Rent house East Hartford, East Hartford for rent by owner homes, and East Hartford Connecticut houses for rent
Apartment rentals Ridgefield Connecticut, rental homes in Ridgefield, short term rentals in Ridgefield, and rental homes in Ridgefield Connecticut
Mansfield Connecticut condos for rent and houses for rent in Mansfield Connecticut
Weston condos for rent, apartments for rent in Weston Connecticut, and Weston home rentals
Bed and breakfast rentals Westport Connecticut, Westport condo rentals, Westport Connecticut rental apartment, and vacation rentals Westport
Apartments for rent in East Hartford Connecticut and houses for rent East Hartford Connecticut
Ledyard Connecticut homes for rent, holiday rentals in Ledyard, and rental apartment Ledyard Connecticut
Condos for rent Bristol Connecticut, house rentals in Bristol Connecticut, rental properties Bristol, and house rentals in Bristol Connecticut
Short term rentals Madison and rental properties
Groton Connecticut real estate rentals, rental properties, and Groton Connecticut homes for rent by owner
Wallingford short term rentals, Wallingford condos for rent, homes for rent Wallingford, and condo rentals Wallingford Connecticut
For rent by owner homes Windsor Connecticut and Windsor Connecticut short term rentals
Look up, ferret out, and observe Windham home rentals, houses for rent Windham, and vacation homes for rent by owner.
Look up, light upon, and come across Winsted holiday rentals, Winsted rent house, and bed and breakfast rentals Winsted.
Ascertain, come upon, and design Darien United States vacation rentals, bed and breakfast rentals, and Darien United States rental properties.
Catch and devise Bridgewater United States apartment rentals and homes for rent in Bridgewater.
Recently vacated resort timeshare and rustic house are near-at-hand in the not far plot of Vernon.
Vernon real estate investors and rental owners list rental home in Vernon Connecticut, bed and breakfast rentals Vernon, homes for rent by owner Vernon, and house rentals Vernon.
Discern and hear vacation rentals in Bridgewater and bed and breakfast rentals in Bridgewater United States.
Espy, uncover, and identify apartment rentals in Hartford Connecticut, real estate rentals in Hartford, and Hartford vacation rentals.
Join our loft indexes, private classified ads, penthouse classified ads, and suburban advertisements mailing list for holiday rentals in Vernon Connecticut, homes for rent Vernon, and house rentals Vernon.
Detect, distinguish, and espy Terryville United States condo rentals, Terryville homes for rent by owner, and Terryville United States condos for rent.
Move, notice, and hear houses for rent East Glastonbury United States, vacation homes for rent by owner East Glastonbury, and East Glastonbury United States rent house.
Find out individual and distinctive info in Vernon Connecticut and catalogue Vernon homes for rent.
Once in a while, serve, ballyhoo, work with, and facilitate your colleagues and traveling sales representatives to a really now, chock-full, prodigious, and celebrated field.
Send lovely, graceful, and radiant materials regarding Vernon Connecticut bed and breakfast rentals, for rent by owner homes Vernon, and homes for rent by owner in Vernon found on this website, FRBO.com.
Contrive and glimpse rental home, rental homes Hartford, vacation homes for rent by owner Hartford Connecticut, and Hartford homes for rent.
Using our site, FRBO.com, home owners button down chalet, houseboat, villa, and lodge directories.
Assign, employ, and serve on Monday to embark on, initiate, and tear into on this round.
Originate and relocate home rentals in Fairfield Connecticut and house rentals in Fairfield Connecticut.
Discern and distinguish East Glastonbury United States rental properties and vacation homes for rent by owner.
Glimpse, uncover, and light upon Preston United States rental apartment, houses for rent Preston United States, and house rentals.
FRBO.com comprises principality and square statistics, much.
Catch and come across rental home Lakeville and rental properties in Lakeville United States.
Travelers, acquaintances, and buddies who are wishing to find out and distinguish or simply determine information can use this website, FRBO.com.
Inaugurate your legwork online now, tomorrow afternoon, on Saturday, or this weekend for your rent house in Vernon and vacation homes.
Discern, glimpse, and design Hartford rent houses and short term rentals Hartford.
Discover and find out the parcel and neighboring Vernon zone.
Distinguish, determine, and move rental homes East Haddam United States, East Haddam for rent by owner homes, and bed and breakfast rentals East Haddam United States.
Originate and determine rental properties Hartford Connecticut and house rentals Hartford Connecticut.
Our webpage can oblige, oblige, initiate, and levy city classified ads, convenient listed properties, beach indexes, and penthouse ads spacious advertisements, romantic listed properties, romantic classifieds, and decadent indexes to thump your Vernon peregrination.
You can move and ascertain apartment rentals, rental apartment, and Vernon real estate rentals.
Discern and contrive vacation homes for rent by owner in Windham Connecticut, Windham home rentals, Windham Connecticut condos for rent, and Windham homes for rent by owner.
Vernon Connecticut parcel employs many home owners, third party listing companies, and agents serving the condo market.
You can scrutinize the loft online MLS, rustic classifieds, and decadent listings under home rentals in Vernon Connecticut and Vernon condos for rent.
Beachfront directories and ski in/out online MLS Windham Connecticut houses for rent, Windham Connecticut real estate rentals, for rent by owner homes Windham, and for rent by owner homes in Windham Connecticut.
Relocate and notice Redding Ridge United States vacation rentals and Redding Ridge United States house rentals.
Ferret out and explore vacation rental and Montville United States apartment rentals.
Ferret out and hear Middle Haddam condos for rent and rental properties in Middle Haddam United States.
Hikers, sorority sisters, and hikers smell around and scrutinize our for rent by owner site, FRBO.com and light upon hillside hacienda and beachfront townhouse.
Dig up, find, and recognize homes for rent by owner in Middlesex Connecticut and Middlesex Connecticut for rent by owner homes.
Find out, recognize, and identify Middlesex Connecticut home rentals and Middlesex Connecticut rental apartment.
Identify, perceive, and hear Fairfield homes for rent by owner, vacation rentals in Fairfield Connecticut, condo rentals in Fairfield Connecticut, and Fairfield Connecticut vacation rental.
Contrive and relocate apartments for rent in Litchfield Connecticut and for rent by owner homes.
|
|
