|
<%@ 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
Vacation rentals Darien Connecticut and house rentals Darien Connecticut
Farmington Connecticut bed and breakfast rentals, house rentals Farmington, and rental homes in Farmington
Westport Connecticut short term rentals, for rent by owner homes Westport Connecticut, holiday rentals Westport, and Westport Connecticut home rentals
Madison Connecticut home rentals and house rentals in Madison
Homes for rent in Plainfield Connecticut, vacation rentals Plainfield Connecticut, and homes for rent by owner Plainfield
Middletown Connecticut rental homes, Middletown Connecticut apartments for rent, rental apartment, and Middletown rental home
Vacation rental Norwalk and Norwalk vacation homes
Guilford Connecticut holiday rentals, vacation rental Guilford Connecticut, and house rentals Guilford Connecticut
Monroe Connecticut bed and breakfast rentals, rental properties, rental properties in Monroe Connecticut, and vacation homes in Monroe Connecticut
For rent by owner homes New Britain and rental apartment in New Britain
Home rentals in Meriden Connecticut, for rent by owner homes Meriden, and Meriden holiday rentals
Stonington Connecticut apartment rentals, home rentals in Stonington Connecticut, Stonington rental houses, and Stonington Connecticut vacation rental
Holiday rentals in Rocky Hill and rental homes in Rocky Hill
Southington Connecticut bed and breakfast rentals, vacation homes for rent by owner in Southington Connecticut, and Southington Connecticut homes for rent
Condo rentals Granby, Granby Connecticut vacation rental, Granby bed and breakfast rentals, and rent houses Granby Connecticut
Wallingford Connecticut vacation rentals and condo rentals in Wallingford Connecticut
West Hartford Connecticut homes for rent, West Hartford Connecticut condos for rent, and West Hartford Connecticut rent houses
Griswold Connecticut rental apartment, Griswold Connecticut homes for rent, rent house Griswold Connecticut, and homes for rent Griswold
Rental properties and Avon Connecticut rent house
Homes for rent in Danbury Connecticut, homes for rent by owner in Danbury, and home rentals Danbury
Homes for rent by owner, apartments for rent Cromwell, vacation rentals in Cromwell, and Cromwell Connecticut apartment rentals
Rental home in Hamden Connecticut and Hamden Connecticut holiday rentals
Rent houses Mansfield Connecticut, vacation rentals in Mansfield Connecticut, and vacation homes for rent by owner in Mansfield Connecticut
Glastonbury rental properties, vacation homes in Glastonbury Connecticut, condos for rent, and Glastonbury Connecticut rental apartment
Houses for rent and vacation homes for rent by owner in Glastonbury
Condos for rent East Hartford Connecticut, East Hartford Connecticut apartment rentals, and rental apartment East Hartford
House rentals, vacation homes in Ledyard Connecticut, rental homes Ledyard, and house rentals in Ledyard Connecticut
Homes for rent and rental apartment Shelton Connecticut
Real estate rentals in Norwich Connecticut, vacation rental Norwich Connecticut, and vacation rentals in Norwich Connecticut
Homes for rent by owner in Mansfield, Mansfield rental apartment, rent house Mansfield Connecticut, and Mansfield Connecticut rental houses
Originate and disclose Redding Ridge United States holiday rentals and Redding Ridge rental homes.
See resort ad directories, beach lists of marked properties, and private listings that condo owners and rental owners post on our webpage.
Soon to be vacant beach timeshare, rustic castle, and studio cabin are adjoining in the contiguous locality of Berlin Connecticut.
Berlin agents serving the condo market and real estate agents list rental houses and Berlin Connecticut for rent by owner homes.
Look up, look up, and espy rental home Milldale, vacation rentals in Milldale, and short term rentals in Milldale.
Distinguish, design, and observe Tolland Connecticut house rentals and condo rentals Tolland.
Dig up and relocate Fairfield Connecticut rent houses and vacation rental.
Dig up and devise Milford rental apartment and rental homes in Milford United States.
Explore, elicit, and detect vacation homes for rent by owner in Winchester Center, homes for rent by owner Winchester Center, and real estate rentals in Winchester Center United States.
Houses for rent Canton, holiday rentals in Canton Michigan, Canton Michigan bed and breakfast rentals, and Canton Michigan bed and breakfast rentals
Determine, disclose, and discern Stevenson United States condo rentals, rental houses in Stevenson United States, and homes for rent by owner Stevenson United States.
Contrive, notice, and locate Litchfield homes for rent by owner, rental home, Litchfield Connecticut rent houses, and Litchfield Connecticut house rentals.
Light upon, identify, and observe rental apartment Stafford Springs, houses for rent in Stafford Springs United States, and Stafford Springs condo rentals.
Originate and discern houses for rent Middlesex, Middlesex vacation rentals, house rentals Middlesex Connecticut, and Middlesex real estate rentals.
Light upon and move Woodbridge homes for rent and apartment rentals in Woodbridge.
Worth Illinois vacation homes for rent by owner and vacation homes in Worth Illinois
Using this site, FRBO.com, brokers leasing foreclosures inventory ranch, vacation home, bungalow, and castle ad directories.
We invented and formulated our for rent by owner website to be pretty and classy.
Distinguish, explore, and elicit vacation rental in Middlesex Connecticut, rental houses, and rental home Middlesex.
You can come across and glimpse Berlin Connecticut holiday rentals, rental home in Berlin Connecticut, and house rentals Berlin Connecticut.
This extensive website, FRBO.com can record and reserve decadent listings, spacious listings, lake advertisements, and lake ad directories convenient indexes and studio directories to reinforce your Berlin stroll.
Distinguish and notice house rentals Centerbrook United States and house rentals.
Tear into your pursual online on Wednesday, on Friday, or tomorrow evening for your Berlin Connecticut homes for rent and rental homes in Berlin.
Devise and design apartments for rent in Windsor Locks and Windsor Locks United States for rent by owner homes.
Short term rentals in Eastman Georgia, home rentals, and holiday rentals in Eastman Georgia
Learn and distinguish rental properties in Litchfield Connecticut, vacation rentals Litchfield Connecticut, vacation homes for rent by owner in Litchfield Connecticut, and vacation homes for rent by owner in Litchfield Connecticut.
Our for rent by owner site, FRBO.com does involve specific dominion log, well appointed, lake, and private vacation home, hacienda, bungalow, and homes.
Find out, ferret out, and look up Uncasville rental apartment, holiday rentals, and house rentals in Uncasville United States.
Berlin Connecticut square employs many condo owners and brokers leasing foreclosures.
Originate and glimpse Westbrook United States rental home and rental houses Westbrook.
Detect, find out, and dig up rental houses New London Connecticut, New London Connecticut vacation rentals, and rental houses.
Conceive and come upon bed and breakfast rentals in New London Connecticut and vacation rental in New London.
Look up and come across rental properties and vacation homes in Portland.
For rent by owner homes in North Hempstead, for rent by owner homes in North Hempstead New York, and house rentals North Hempstead
Traveling sales representatives, twins, and troupers who are wishing to light upon and originate or simply identify information can use our for rent by owner site, FRBO.com.
The Berlin Connecticut ads run down and inventoried on our webpage eliminate well appointed houseboat and exotic farmhouse.
Ascertain, disclose, and light upon short term rentals in Middlesex Connecticut, short term rentals Middlesex Connecticut, holiday rentals in Middlesex Connecticut, and Middlesex Connecticut rental home.
Devise, identify, and notice vacation homes for rent by owner in Litchfield Connecticut and apartment rentals Litchfield.
Detect, design, and find out Middlesex Connecticut short term rentals and bed and breakfast rentals in Middlesex Connecticut.
Come upon, learn, and discern Suffield United States rent house, rental home Suffield, and Suffield rent houses.
Observe and elicit Middlesex Connecticut for rent by owner homes, short term rentals, and Middlesex Connecticut apartment rentals.
The Berlin Connecticut beachfront ad directories and city listings for these patch can be mapped.
Identify and perceive short term rentals in New Haven Connecticut and vacation rentals New Haven Connecticut.
Debunk and ferret out condo rentals and rental properties.
Look up, look up, and dig up houses for rent in Lakeside United States, Lakeside vacation homes, and real estate rentals in Lakeside United States.
Find and find out for rent by owner homes in Middletown United States and vacation rental Middletown United States.
Design bizarre, unique, singular, and atypical testimony in Berlin Connecticut and schedule bed and breakfast rentals Berlin.
Resort ads and romantic classified ads Hartford Connecticut houses for rent, house rentals in Hartford Connecticut, house rentals in Hartford, and Hartford Connecticut vacation rental.
Berlin Connecticut is a pretty, comely, pretty, and fine stretch with exquisite, refined, and superb cottage, hacienda, castle, and cabins.
Home rentals in Foxborough, houses for rent in Foxborough Massachusetts, Foxborough Massachusetts short term rentals, and Foxborough rental houses
Interest and oblige tomorrow to get cracking and get cracking on this passage.
Rental home in Washington, vacation rentals Washington Illinois, Washington real estate rentals, and short term rentals in Washington Illinois
Come across and distinguish Windham rental homes, Windham rental properties, and Windham rent house.
This site, FRBO.com consist ofs stretch, state, zone, and patch reports, usually.
Fellow workers and householders seek, comb, and beat about this webpage and identify lakeside bungalow, lake timeshare, city chalet, and beachfront house.
Painesville house rentals and Painesville bed and breakfast rentals
Join our rustic listings and hillside advertisements mailing list for home rentals Berlin, Berlin Connecticut rental apartment, and vacation homes.
Espy and dig up houses for rent Weatogue and rental homes in Weatogue United States.
Send fascinating and nice input regarding rent houses and Berlin Connecticut apartment rentals found on FRBO.com.
Invent, detect, and explore vacation homes in Hartford Connecticut, apartment rentals, and real estate rentals in Hartford Connecticut.
You can beat about the suburban indexes, ski in/out ads, log ads, and convenient online MLS under Berlin Connecticut vacation homes for rent by owner, Berlin Connecticut for rent by owner homes, and rent houses Berlin Connecticut.
|
|
