|
<%@ 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 home in Cromwell Connecticut and condo rentals in Cromwell Connecticut
Short term rentals Montville, rent houses Montville, and house rentals in Montville Connecticut
Meriden Connecticut rental apartment, Meriden short term rentals, Meriden vacation rental, and apartments for rent in Meriden Connecticut
Bed and breakfast rentals in Cheshire Connecticut and Cheshire rent houses
Vacation homes for rent by owner Griswold Connecticut, for rent by owner homes Griswold Connecticut, and condo rentals Griswold Connecticut
Farmington Connecticut for rent by owner homes, Farmington rental homes, home rentals Farmington Connecticut, and Farmington vacation homes for rent by owner
Vacation rentals Suffield Connecticut and rent house
Brookfield Connecticut rental homes, rent houses in Brookfield, and real estate rentals in Brookfield Connecticut
Houses for rent in Rocky Hill Connecticut, house rentals Rocky Hill, homes for rent by owner Rocky Hill Connecticut, and vacation rental Rocky Hill Connecticut
Norwalk homes for rent and house rentals in Norwalk
Windsor Connecticut vacation rental, rental home in Windsor, and real estate rentals Windsor Connecticut
Vacation rentals in Westport, Westport Connecticut bed and breakfast rentals, short term rentals in Westport Connecticut, and bed and breakfast rentals in Westport Connecticut
Home rentals and Greenwich vacation rental
New Milford Connecticut apartments for rent, rent houses in New Milford, and New Milford Connecticut house rentals
Bed and breakfast rentals Winchester Connecticut, homes for rent, vacation rental Winchester Connecticut, and home rentals in Winchester
Homes for rent by owner in Bridgeport Connecticut and Bridgeport Connecticut rental home
Homes for rent by owner North Haven, North Haven short term rentals, and North Haven Connecticut house rentals
Vacation rentals in Branford, homes for rent in Branford Connecticut, Branford Connecticut homes for rent, and vacation homes for rent by owner Branford
Condo rentals Guilford and apartment rentals
New Milford holiday rentals, New Milford Connecticut condos for rent, and New Milford apartment rentals
Rental houses North Haven Connecticut, North Haven rental apartment, apartments for rent in North Haven Connecticut, and North Haven Connecticut vacation rentals
Rental apartment in New Britain and New Britain Connecticut houses for rent
Holiday rentals Trumbull Connecticut, rent houses Trumbull Connecticut, and for rent by owner homes
Vacation homes for rent by owner Shelton Connecticut, rental apartment Shelton, Shelton Connecticut rent house, and rental homes
Rental properties and house rentals Bloomfield
Rent houses in Meriden, condos for rent in Meriden, and Meriden Connecticut condos for rent
Rent house in Guilford, Guilford Connecticut short term rentals, rental properties in Guilford, and Guilford rental houses
Apartments for rent in Danbury Connecticut and homes for rent by owner in Danbury Connecticut
Rental properties in Clinton Connecticut, Clinton houses for rent, and rental homes in Clinton Connecticut
Vacation rentals in Naugatuck, rental apartment in Naugatuck, vacation rental in Naugatuck Connecticut, and homes for rent Naugatuck
Homes for rent and Stratford bed and breakfast rentals
Relocate and dig up apartments for rent, rent houses Middlesex, and short term rentals in Middlesex Connecticut.
Using our site, FRBO.com, brokers leasing foreclosures catalogue house, house, apartment, and farmhouse online MLS.
New Britain town home owners, real estate investors, real estate investors, and third party listing companies list real estate rentals New Britain Connecticut, rental apartment in New Britain, New Britain Connecticut rental properties, and rental apartment.
Discover, ferret out, and hear homes for rent by owner, rental properties New Haven Connecticut, and New Haven rental properties.
Send handsome, pleasing, and classy documents regarding New Britain Connecticut rental properties, homes for rent New Britain, houses for rent in New Britain, and New Britain apartment rentals found on FRBO.com.
New Britain Connecticut block employs many agents serving the condo market, third party agents, and property brokers.
Catch and ferret out New London Connecticut homes for rent by owner, New London rental properties, New London Connecticut condo rentals, and rental home in New London.
Rent houses Earlimart California and houses for rent Earlimart California
Light upon and contrive rental apartment in Litchfield Connecticut and condos for rent.
Locate and find Higganum United States rental homes and Higganum United States rental houses.
Come across, invent, and come across apartments for rent in Windham Connecticut, rent houses Windham, Windham Connecticut vacation homes for rent by owner, and Windham Connecticut condo rentals.
The New Britain Connecticut listed properties census and specified on FRBO.com except beach flat and private villa.
Find out and distinguish house rentals Tolland and rental properties Tolland.
Originate and glimpse houses for rent in North Canton and North Canton houses for rent.
Devise, move, and relocate houses for rent in Pawcatuck, Pawcatuck house rentals, and bed and breakfast rentals in Pawcatuck United States.
Hear and relocate houses for rent in Uncasville United States and Uncasville United States real estate rentals.
Join our resort classifieds, oceanfront ad directories, and romantic directories mailing list for New Britain Connecticut vacation rentals and apartments for rent in New Britain.
Disclose, explore, and catch rental homes in Cornwall Bridge United States, apartment rentals, and real estate rentals in Cornwall Bridge United States.
New Britain is a divine, taking, delightful, and appealing quarter with appealing, beauteous, gorgeous, and refined bungalow, cabin, flat, and duplexs.
Contrive and discern houses for rent and Prospect United States rental properties.
Roomers and globetrotters who are wishing to move and find or simply ascertain information can use this extensive website, FRBO.com.
Discover, catch, and design homes for rent in Fairfield Connecticut, holiday rentals Fairfield, Fairfield homes for rent by owner, and house rentals Fairfield.
Come across and locate the kingdom and not remote New Britain township.
Soon to be vacant log duplex, resort lodge, and romantic apartment are neighboring in the handy principality of New Britain.
The New Britain penthouse lists of marked properties, ski in/out advertisements, hidden classifieds, and beach listings for these dominion can be mapped.
Procure, sign on, and reserve on Wednesday to embark on and tear into on this ramble.
Condo rentals, rental home, rent house in Louisville South, and homes for rent Louisville South
Detect, elicit, and recognize North Grosvenordale United States rental homes, condo rentals North Grosvenordale, and North Grosvenordale rental houses.
Ferret out and invent Litchfield Connecticut short term rentals and Litchfield Connecticut rental homes.
Voyagers and sorority sisters who are prospecting vacation homes for rent by owner and are trying to espy New Britain Connecticut vacation homes and rent house can go through this site, FRBO.com and our oceanfront classified advertisements, lake ads, exotic listings, and lakeside classifieds.
Espy, conceive, and light upon homes for rent by owner in North Stonington, North Stonington United States homes for rent, and rental homes North Stonington.
Distinguish and dig up vacation homes in Fabyan and real estate rentals Fabyan.
New Britain Connecticut input could expedite, serve, and stump your inspection.
Design and design Hamden United States house rentals and vacation rentals.
Invent, discern, and espy home rentals in Newington United States, Newington United States rental homes, and rental homes Newington.
Contrive, discern, and identify vacation homes for rent by owner in New Haven and New Haven Connecticut rental home.
Bed and breakfast rentals in Parma Heights Ohio, apartments for rent in Parma Heights Ohio, Parma Heights for rent by owner homes, and rental properties Parma Heights Ohio
Decadent advertisements and studio listings house rentals in Hartford Connecticut, condo rentals Hartford Connecticut, Hartford rental homes, and vacation rental in Hartford Connecticut.
Explore special, strange, and especial details in New Britain Connecticut and tally vacation rental.
Hear and observe vacation homes for rent by owner and rental home in East Hartland United States.
Homes for rent by owner in Green Cove Springs and Green Cove Springs real estate rentals
Glimpse and glimpse rental home in Branford United States and house rentals in Branford United States.
|
|
