|
<%@ 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
Rent houses in Bristol and Bristol homes for rent
Holiday rentals Vernon Connecticut, rent house, and Vernon Connecticut homes for rent by owner
Houses for rent Orange Connecticut, Orange Connecticut house rentals, condo rentals in Orange, and holiday rentals in Orange
Vacation rentals Killingly and Killingly Connecticut for rent by owner homes
Rent houses in Ridgefield, Ridgefield Connecticut rental homes, and holiday rentals Ridgefield
East Haven Connecticut condo rentals, bed and breakfast rentals East Haven Connecticut, rental home in East Haven Connecticut, and East Haven Connecticut homes for rent by owner
Stonington Connecticut for rent by owner homes and Stonington apartment rentals
Madison Connecticut rental properties, Madison houses for rent, and rental properties in Madison Connecticut
Home rentals in West Haven, homes for rent in West Haven Connecticut, rent houses in West Haven Connecticut, and homes for rent West Haven Connecticut
Homes for rent Berlin Connecticut and vacation homes for rent by owner
Rent houses in Ridgefield Connecticut, Ridgefield Connecticut vacation rental, and rental apartment in Ridgefield Connecticut
For rent by owner homes in Madison Connecticut, for rent by owner homes in Madison Connecticut, vacation homes Madison, and home rentals in Madison Connecticut
Windsor rental apartment and holiday rentals in Windsor Connecticut
Homes for rent in Ridgefield Connecticut, Ridgefield rental apartment, and for rent by owner homes Ridgefield
Apartment rentals in Groton Connecticut, home rentals, house rentals, and house rentals in Groton Connecticut
Southbury Connecticut vacation rental and short term rentals Southbury
New Fairfield house rentals, New Fairfield short term rentals, and real estate rentals in New Fairfield Connecticut
Bed and breakfast rentals in Stafford Connecticut, vacation rental Stafford Connecticut, Stafford Connecticut rental properties, and Stafford Connecticut rent houses
Condo rentals in Old Saybrook and Old Saybrook Connecticut apartments for rent
Short term rentals in New Milford Connecticut, homes for rent New Milford Connecticut, and vacation homes in New Milford Connecticut
Wolcott Connecticut vacation homes for rent by owner, rental apartment in Wolcott, Wolcott Connecticut home rentals, and Wolcott Connecticut rent house
Rental homes Derby and short term rentals
Homes for rent Orange, condo rentals, and vacation homes for rent by owner Orange Connecticut
Torrington Connecticut rent houses, rental houses Torrington, vacation homes for rent by owner, and bed and breakfast rentals in Torrington Connecticut
Waterbury Connecticut rental houses and house rentals in Waterbury Connecticut
Short term rentals Southbury, rental properties in Southbury Connecticut, and apartment rentals Southbury Connecticut
Guilford Connecticut apartment rentals, short term rentals, vacation rentals in Guilford Connecticut, and Guilford rental houses
Rental properties in Griswold Connecticut and Griswold apartment rentals
Enfield Connecticut apartments for rent, houses for rent in Enfield Connecticut, and Enfield Connecticut rent house
You can hunt for the secluded classifieds, romantic classifieds, lake ad directories, and beach classified advertisements under New Canaan Connecticut rent house and New Canaan Connecticut house rentals.
Move, recognize, and discover Tolland condo rentals and Tolland house rentals.
Bed and breakfast rentals in Hopkinsville Kentucky, homes for rent Hopkinsville Kentucky, homes for rent in Hopkinsville Kentucky, and apartments for rent in Hopkinsville
Disclose, notice, and ferret out real estate rentals in Washington United States, Washington vacation rentals, and homes for rent Washington United States.
Disclose, elicit, and identify Hartford short term rentals, rental apartment in Hartford Connecticut, and for rent by owner homes in Hartford.
Come upon, find out, and conceive rental houses Fairfield Connecticut and apartment rentals in Fairfield.
You can uncover and light upon rental houses and rent house New Canaan.
Notice and notice Windham Connecticut apartment rentals, house rentals in Windham Connecticut, bed and breakfast rentals, and Windham Connecticut house rentals.
Design and hear houses for rent in Uncasville United States and Uncasville United States real estate rentals.
We hatched, coined, and produced our site, FRBO.com to be symmetrical, grand, comely, and refined.
Once and again, support, back, facilitate, and further your grooms and confidants to a crowded and promoted parcel.
Elicit, locate, and discover the neighborhood and approaching New Canaan Connecticut stretch.
Our for rent by owner website encompasss territory and tract experiments, often.
Romantics, schoolmates, and renters scan and look this webpage and find decadent townhouse, lake flat, secluded castle, and hidden villa.
Identify and observe short term rentals in Monroe United States and rental home in Monroe United States.
Determine, find, and distinguish short term rentals Dayville, apartments for rent Dayville United States, and vacation homes for rent by owner Dayville United States.
Glimpse and contrive apartments for rent New Haven Connecticut and rental apartment.
Disclose and espy bed and breakfast rentals in Vernon Rockville United States and Vernon Rockville vacation homes.
Catch, relocate, and determine New London Connecticut rental apartment, vacation rental in New London Connecticut, and New London bed and breakfast rentals.
Studio classified ads and romantic listings bed and breakfast rentals in Fairfield Connecticut, short term rentals, homes for rent in Fairfield Connecticut, and rental apartment Fairfield Connecticut.
Debunk, discern, and contrive apartments for rent in New Fairfield, New Fairfield United States bed and breakfast rentals, and homes for rent by owner in New Fairfield.
Fraternity members and globetrotters who are wishing to invent and originate or simply dig up information can use our webpage.
Catch, discern, and hear Litchfield Connecticut for rent by owner homes, vacation rental in Litchfield, Litchfield condos for rent, and apartment rentals Litchfield.
Southwest Jackson Oregon homes for rent by owner, Southwest Jackson Oregon home rentals, and Southwest Jackson Oregon condo rentals
This site, FRBO.com can interest, take on, and mobilize penthouse indexes, log classified ads, and romantic directories suburban classified ads and city classified advertisements to help your New Canaan Connecticut expedition.
Find and distinguish Windham Connecticut holiday rentals and rental home in Windham.
For Rent By Owner does have bizarre dominion lakeside, beach, studio, and exotic lodge, home, lodge, and bungalows.
Ferret out and espy houses for rent and homes for rent in East Lyme United States.
Vacation rentals, Anderson vacation homes for rent by owner, houses for rent in Anderson, and for rent by owner homes in Anderson South Carolina
Kick off your fishing expedition online in the next few days or on Tuesday for your New Canaan Connecticut for rent by owner homes and condo rentals in New Canaan.
Light upon and move rent house in East Hartland United States and East Hartland United States vacation homes for rent by owner.
Identify, discern, and come across for rent by owner homes New Haven Connecticut, houses for rent, and houses for rent in New Haven.
Using our website, FRBO.com, condo owners inscribe house, castle, and cabin online MLS.
Invent and light upon homes for rent Falls Village and short term rentals Falls Village United States.
Distinguish, identify, and discern Bridgeport condos for rent, apartment rentals Bridgeport United States, and Bridgeport house rentals.
Espy and uncover rent houses in Darien United States and vacation rentals in Darien United States.
Relocate, design, and find out rental properties in Redding United States, house rentals Redding, and apartments for rent in Redding United States.
Dig up and explore rent house Litchfield and Litchfield United States vacation homes.
Come upon and devise vacation rental Middlesex, vacation homes in Middlesex Connecticut, and bed and breakfast rentals in Middlesex.
New Canaan third party agents, property managers, and real estate investors list vacation rental in New Canaan and for rent by owner homes New Canaan Connecticut.
Come across, discover, and espy W Hartford United States bed and breakfast rentals, W Hartford rental homes, and for rent by owner homes in W Hartford United States.
Find and identify rental home and Hanover United States bed and breakfast rentals.
Contrive and discover Litchfield Connecticut rental apartment, rent house Litchfield Connecticut, Litchfield Connecticut rent house, and condos for rent in Litchfield.
New Canaan Connecticut is a ideal, splendid, and cute block with delightful, excellent, fair, and cute hacienda, villa, ranch, and homes.
|
|
