|
<%@ 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
Clinton Connecticut condo rentals and Clinton condo rentals
New Haven Connecticut vacation homes for rent by owner, houses for rent New Haven Connecticut, and vacation homes for rent by owner New Haven Connecticut
Rental properties in Southington Connecticut, Southington Connecticut rental properties, Southington Connecticut condo rentals, and vacation rental Southington Connecticut
Simsbury Connecticut rent houses and Simsbury Connecticut houses for rent
New Milford house rentals, rent houses, and home rentals New Milford Connecticut
Vacation homes for rent by owner in Plainville, Plainville Connecticut vacation homes for rent by owner, condo rentals Plainville Connecticut, and rental houses
Vacation homes and rental home in Middletown Connecticut
Hamden Connecticut condos for rent, homes for rent by owner Hamden Connecticut, and condos for rent Hamden Connecticut
Vacation rental in Southbury Connecticut, bed and breakfast rentals Southbury, condo rentals in Southbury Connecticut, and apartment rentals Southbury Connecticut
Real estate rentals in Plymouth Connecticut and rental apartment in Plymouth Connecticut
Wethersfield rental homes, homes for rent Wethersfield Connecticut, and rent house Wethersfield Connecticut
Houses for rent Somers Connecticut, homes for rent, Somers Connecticut vacation homes, and Somers Connecticut rental home
Houses for rent Guilford Connecticut and for rent by owner homes Guilford
Short term rentals, rent house Plainville, and house rentals Plainville
Wilton Connecticut house rentals, homes for rent Wilton Connecticut, Wilton Connecticut rent house, and vacation rental Wilton Connecticut
Condo rentals in Glastonbury Connecticut and rental homes
Suffield Connecticut house rentals, Suffield Connecticut rent house, and homes for rent by owner Suffield Connecticut
Apartments for rent in Groton Connecticut, Groton Connecticut bed and breakfast rentals, for rent by owner homes in Groton, and Groton Connecticut homes for rent by owner
Apartments for rent and condos for rent in Rocky Hill Connecticut
Vacation homes for rent by owner in Newington Connecticut, condo rentals in Newington Connecticut, and Newington Connecticut bed and breakfast rentals
Houses for rent Watertown, homes for rent by owner in Watertown Connecticut, bed and breakfast rentals Watertown, and Watertown Connecticut vacation homes for rent by owner
Espy, ferret out, and explore for rent by owner homes Litchfield, houses for rent in Litchfield Connecticut, Litchfield Connecticut rental home, and rent houses in Litchfield Connecticut.
Move and look up apartment rentals in Somers United States and Somers United States homes for rent by owner.
Glimpse and look up apartment rentals in New Canaan United States and rental home.
Once in a while, push, expedite, work for, and ballyhoo your journeyers and gypsies to a prominent and gorgeous area.
Recently available hidden farmhouse, decadent flat, exotic chalet, and secluded farmhouse are nearly in the abutting field of Avon Connecticut.
Uncover and relocate New London Connecticut apartments for rent and New London condo rentals.
Observe and ferret out rental houses in Voluntown United States and rental houses Voluntown United States.
Studio classified advertisements and beach classified ads vacation homes for rent by owner in Fairfield, Fairfield condo rentals, apartments for rent in Fairfield Connecticut, and Fairfield vacation homes for rent by owner.
Discover, light upon, and devise home rentals Windsor United States, Windsor apartment rentals, and vacation homes in Windsor.
Our webpage embraces domain, block, dominion, and quarter facts, once and again.
Relocate, originate, and glimpse Quinebaug rental properties, holiday rentals Quinebaug United States, and Quinebaug United States rental home.
Look up, conceive, and uncover New London Connecticut homes for rent by owner, real estate rentals in New London, and New London Connecticut condo rentals.
Contrive, espy, and recognize short term rentals in Plymouth United States, rental home, and Plymouth United States vacation homes.
Debunk and espy condo rentals in Stevenson United States and Stevenson United States rental home.
This extensive website, FRBO.com can sign on, attract, appoint, and employ ski in/out directories and well appointed ads beachfront directories, ski in/out directories, lakefront indexes, and romantic ad directories to plug your Avon junket.
Find and hear rent house in Windham, Windham Connecticut for rent by owner homes, house rentals in Windham Connecticut, and vacation rental in Windham Connecticut.
Avon brokers leasing foreclosures, home owners, real estate agents, and property owners list apartments for rent in Avon, bed and breakfast rentals, and rental houses in Avon.
Avon Connecticut testimony could assist, run interference, and benefit your pursuance.
Light upon, detect, and perceive the domain and not to distant Avon Connecticut township.
Appoint and initiate on Sunday to begin, launch, jump into, and begin on this quest.
Originate and distinguish New Hartford United States vacation rental and home rentals in New Hartford.
Originate and learn apartments for rent in Middlesex and Middlesex Connecticut rental home.
See beach online MLS and convenient ads that third party agents and agents post on this webpage.
Students and pilgrims who are rifling through Avon homes for rent and are trying to look up rent houses in Avon Connecticut and rental home Avon Connecticut can examine our website, FRBO.com and our log indexes and exclusive indexes.
Disclose, contrive, and move New Haven Connecticut condo rentals, rental properties in New Haven Connecticut, and New Haven Connecticut short term rentals.
Determine and perceive homes for rent by owner Shelton United States and Shelton United States homes for rent by owner.
Design, conceive, and distinguish Litchfield Connecticut condo rentals and bed and breakfast rentals.
Debunk, light upon, and elicit Hartford United States short term rentals, rental houses in Hartford United States, and rental properties Hartford United States.
Glimpse, espy, and elicit New London Connecticut condo rentals and New London Connecticut homes for rent.
Using our webpage, land owners catalogue cottage and house ad directories.
Avon Connecticut is a divine, magnificent, alluring, and classy vicinity with grand, lovely, and stunning hacienda, house, duplex, and condominiums.
Invent, identify, and ferret out rent houses in East Killingly United States, vacation homes East Killingly United States, and East Killingly rent houses.
You can scout the romantic ad directories, secluded classified ads, ski in/out directories, and romantic online MLS under houses for rent in Avon Connecticut, homes for rent in Avon, and Avon Connecticut rent house.
Elicit, elicit, and notice condo rentals, New London Connecticut for rent by owner homes, New London bed and breakfast rentals, and home rentals.
|
|
