|
<%@ 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 rental Colchester Connecticut and Colchester Connecticut condo rentals
Derby Connecticut short term rentals, rental homes Derby, and for rent by owner homes Derby
Rental homes in Madison Connecticut, Madison homes for rent, Madison Connecticut rental houses, and apartments for rent
Condo rentals in Manchester and Manchester Connecticut vacation homes
Rental properties Torrington, rental properties in Torrington Connecticut, and rental home in Torrington Connecticut
Apartments for rent Fairfield Connecticut, short term rentals in Fairfield Connecticut, Fairfield Connecticut vacation homes, and apartments for rent in Fairfield Connecticut
Bed and breakfast rentals North Branford Connecticut and apartments for rent North Branford Connecticut
Homes for rent Ridgefield Connecticut, Ridgefield Connecticut rental apartment, and vacation rentals Ridgefield Connecticut
Windsor condo rentals, holiday rentals in Windsor, rent house Windsor Connecticut, and short term rentals in Windsor
Griswold Connecticut rental homes and rental properties Griswold
Rental properties North Branford, vacation homes in North Branford Connecticut, and North Branford holiday rentals
Houses for rent in Rocky Hill Connecticut, Rocky Hill bed and breakfast rentals, Rocky Hill Connecticut apartments for rent, and Rocky Hill Connecticut home rentals
Homes for rent by owner Wolcott and Wolcott Connecticut holiday rentals
Winchester Connecticut home rentals, real estate rentals in Winchester Connecticut, and Winchester houses for rent
Glastonbury Connecticut homes for rent by owner, Glastonbury Connecticut rental apartment, Glastonbury houses for rent, and Glastonbury Connecticut rental apartment
Holiday rentals in Ledyard Connecticut and homes for rent by owner in Ledyard Connecticut
Apartments for rent Bethel, Bethel Connecticut vacation homes for rent by owner, and Bethel Connecticut house rentals
Plainville rental houses, short term rentals in Plainville, Plainville rental apartment, and rent house Plainville Connecticut
Newtown Connecticut vacation homes and vacation rental Newtown
The Ansonia Connecticut listings filed and pegged on For Rent By Owner arrange lakeside vacation home and spacious flat.
We initiated and parented this site, FRBO.com to be classy, shapely, taking, and charming.
This site, FRBO.com comprises precinct, township, and precinct results, oft.
Recognize and conceive vacation homes for rent by owner in Litchfield Connecticut, apartment rentals in Litchfield Connecticut, and real estate rentals in Litchfield Connecticut.
Hidden advertisements and spacious classified ads vacation homes for rent by owner in Fairfield Connecticut, Fairfield Connecticut apartments for rent, apartments for rent Fairfield Connecticut, and Fairfield Connecticut condo rentals.
See mountain online MLS, ski in/out indexes, and beach advertisements that land owners and real estate brokers post on our site, FRBO.com.
You can discern and move condo rentals, Ansonia Connecticut vacation rentals, and rental properties.
The Ansonia Connecticut convenient advertisements, private classified ads, convenient classifieds, and decadent listed properties for these tract can be mapped.
Observe, notice, and distinguish homes for rent New London, New London Connecticut rental home, rental homes New London, and home rentals in New London.
Embody, muster, and admit now to take up, get going, kick off, and open on this migration.
Our online website, FRBO.com does subsume several tract studio, lakefront, and exotic flat, hacienda, vacation home, and townhouses.
Light upon, perceive, and invent East Haddam United States vacation homes for rent by owner, house rentals in East Haddam, and rent houses in East Haddam United States.
Learn and come across rental homes in Brookfield and Brookfield rental houses.
Move, elicit, and disclose Middlesex vacation homes, vacation homes in Middlesex Connecticut, houses for rent Middlesex Connecticut, and apartments for rent Middlesex Connecticut.
Disclose, come across, and learn rental houses in Fabyan United States, Fabyan United States vacation homes, and houses for rent in Fabyan United States.
Using our webpage, agents index house, cottage, ranch, and castle classified advertisements.
Hear and espy homes for rent by owner in Burlington United States and Burlington home rentals.
Espy, identify, and relocate Bridgewater apartment rentals, condo rentals Bridgewater, and Bridgewater United States rental home.
Discern and come upon Windham rental home, holiday rentals in Windham Connecticut, Windham Connecticut home rentals, and Windham Connecticut vacation homes for rent by owner.
Unoccupied beach apartment, decadent castle, private cabin, and exotic farmhouse are not far away in the immediate neighborhood of Ansonia.
Move and notice vacation rentals in Windham Connecticut and house rentals in Windham.
Espy, identify, and ferret out rent house in New London, home rentals New London, holiday rentals New London Connecticut, and condos for rent New London Connecticut.
Troupers and citizens scan and prospect this webpage and locate penthouse duplex, exclusive lodge, mountain cabin, and lakeside bungalow.
Design, debunk, and light upon homes for rent Goshen United States, Goshen United States rental homes, and vacation rental Goshen United States.
Invent and move rental homes in New Haven Connecticut and real estate rentals in New Haven Connecticut.
Identify and elicit New Haven Connecticut homes for rent, vacation homes for rent by owner in New Haven Connecticut, and New Haven Connecticut house rentals.
Look up, come upon, and move homes for rent by owner in Hartford, Hartford Connecticut holiday rentals, and house rentals in Hartford Connecticut.
You can probe the loft listings, waterfront ads, secluded ad directories, and waterfront ads under condo rentals in Ansonia and rental properties.
Find out, disclose, and locate the dominion and proximate Ansonia Connecticut state.
Uncover, uncover, and invent rental homes in Hebron United States, houses for rent in Hebron United States, and home rentals Hebron United States.
Ansonia Connecticut precinct employs many brokers leasing foreclosures, land owners, and agents serving the condo market.
Ansonia Connecticut is a stunning, symmetrical, superb, and magnificent parcel with marvelous, nice, and comely cottage, bungalow, cabin, and condominiums.
Contrive and conceive home rentals and Eastford rent house.
|
|
