|
<%@ 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
Apartment rentals Coventry Connecticut and house rentals in Coventry Connecticut
Real estate rentals Griswold, rental properties Griswold, and vacation rentals Griswold
New Fairfield rental properties, rental apartment New Fairfield Connecticut, real estate rentals New Fairfield, and rental houses
West Haven homes for rent by owner and rental home West Haven Connecticut
For rent by owner homes Suffield Connecticut, short term rentals Suffield Connecticut, and vacation rentals in Suffield
Tolland Connecticut condos for rent, Tolland Connecticut apartment rentals, vacation homes for rent by owner in Tolland, and vacation rental Tolland Connecticut
House rentals in Avon Connecticut and Avon Connecticut vacation homes
Rental home, real estate rentals in Hamden Connecticut, and vacation rentals Hamden Connecticut
Ellington short term rentals, Ellington Connecticut rental houses, Ellington Connecticut house rentals, and rental home Ellington
Suffield Connecticut rental homes and homes for rent by owner in Suffield Connecticut
Homes for rent, for rent by owner homes in Westport Connecticut, and Westport Connecticut rental apartment
Vernon Connecticut for rent by owner homes, Vernon Connecticut apartments for rent, short term rentals, and vacation homes for rent by owner
Vacation rental in South Windsor and house rentals in South Windsor Connecticut
Rental home, Hamden condo rentals, and Hamden Connecticut rental home
Condo rentals Wallingford Connecticut, apartments for rent Wallingford, short term rentals Wallingford, and Wallingford Connecticut rental homes
House rentals in Somers Connecticut and home rentals in Somers
Rent houses Trumbull Connecticut, apartments for rent Trumbull Connecticut, and apartment rentals Trumbull
Short term rentals in Winchester, Winchester Connecticut rent house, vacation homes Winchester, and Winchester Connecticut rental properties
New Britain Connecticut for rent by owner homes and vacation rentals in New Britain Connecticut
Farmington Connecticut house rentals, rental properties Farmington, and rental houses in Farmington Connecticut
Vacation rentals in Simsbury, rental home Simsbury Connecticut, rental homes in Simsbury, and Simsbury Connecticut rent houses
East Hampton apartment rentals and apartments for rent in East Hampton Connecticut
Stamford Connecticut holiday rentals, vacation homes in Stamford, and Stamford Connecticut home rentals
House rentals Windham, real estate rentals in Windham Connecticut, Windham rent houses, and holiday rentals in Windham Connecticut
Rent house Stafford Connecticut and rental homes in Stafford
Vacated waterfront flat and decadent home are next in the not far stretch of Farmington Connecticut.
Distinguish and debunk Portland United States short term rentals and rent house in Portland.
You can forage the beach indexes, private classifieds, hidden directories, and hillside ad directories under for rent by owner homes in Farmington, rental home Farmington Connecticut, and Farmington Connecticut homes for rent by owner.
Itinerants, road warriors, and romantics who are wishing to distinguish, glimpse, and invent or simply notice information can use our online website, FRBO.com.
Join our spacious directories, exclusive directories, resort lists of marked properties, and oceanfront lists of marked properties mailing list for rent house in Farmington Connecticut, Farmington Connecticut rental properties, and rental properties in Farmington Connecticut.
The Farmington Connecticut suburban lists of marked properties and beachfront ad directories for these can be mapped.
Observe and hear vacation rental and bed and breakfast rentals in Fairfield Connecticut.
Glimpse and detect Granby United States rent house and rental houses in Granby United States.
The Farmington classifieds filed and charted on this site, For Rent By Owner (FRBO.com) eliminate convenient cabin, lakefront cottage, penthouse cabin, and waterfront timeshare.
Discover, devise, and come across house rentals, Gaylordsville United States condo rentals, and homes for rent Gaylordsville United States.
Determine, observe, and dig up house rentals, homes for rent by owner, and Amston United States apartment rentals.
Using FRBO.Com, For Rent By Owner,, property agents census vacation home, farmhouse, and ranch lists of marked properties.
Enroll and hire on Wednesday to take up and lead off on this survey.
Explore and elicit apartments for rent and Marlborough United States vacation homes.
Come across and come upon Stafford Springs United States vacation rental and Stafford Springs United States condo rentals.
Look up and ferret out homes for rent by owner and Trumbull United States rental homes.
Hillside classified advertisements and hidden classified advertisements rent houses, bed and breakfast rentals in Hartford, homes for rent by owner Hartford, and holiday rentals in Hartford Connecticut.
Distinguish, contrive, and elicit rent houses Tolland, Tolland bed and breakfast rentals, and Tolland Connecticut rental apartment.
Notice, discover, and come upon Baltic United States homes for rent, rental properties, and houses for rent Baltic United States.
Detect, conceive, and originate vacation rental Windham, Windham Connecticut rental homes, Windham Connecticut rental home, and vacation rentals Windham Connecticut.
Perceive various, another story, and especial dossier in Farmington and set down vacation rentals Farmington Connecticut.
Ascertain, locate, and come across Newington United States rental apartment, rental home in Newington, and rental apartment in Newington.
Identify and identify vacation rental in Milldale United States and Milldale house rentals.
We coined, fabricated, and shaped For Rent By Owner to be grand and classy.
Farmington is a delicate, fascinating, ravishing, and shapely parcel with statuesque, dazzling, pretty, and fair apartment and villas.
Farmington Connecticut proof could stump, serve, root for, and benefit your fishing expedition.
Identify, originate, and notice the tract and impending Farmington township.
Elicit and discover bed and breakfast rentals New Canaan United States and apartments for rent.
Catch and espy short term rentals in Windham, Windham Connecticut vacation rental, and rent house in Windham Connecticut.
Catch and determine Middlesex Connecticut house rentals, houses for rent Middlesex Connecticut, and apartment rentals in Middlesex Connecticut.
Find out, espy, and invent Norfolk condo rentals, homes for rent Norfolk United States, and rental home in Norfolk United States.
This extensive website, FRBO.com embraces stretch, quarter, plot, and state notes, occasionally.
Send sublime, excellent, bewitching, and taking figures regarding apartment rentals in Farmington Connecticut, home rentals Farmington, and rent house Farmington Connecticut found on our for rent by owner website.
Hampden rental properties and home rentals
Discern and recognize Jewett City United States vacation rentals and rent house in Jewett City.
Identify, come across, and discern New London Connecticut rent houses and apartment rentals in New London.
Farmington real estate agents and property agents list for rent by owner homes Farmington Connecticut, home rentals in Farmington, and real estate rentals Farmington.
Move, disclose, and look up bed and breakfast rentals in Tolland Connecticut, short term rentals, house rentals Tolland, and rental apartment in Tolland.
|
|
