|
<%@ 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
Guilford Connecticut rental apartment and rental properties Guilford
Rental homes in East Haven Connecticut, East Haven Connecticut vacation homes for rent by owner, and East Haven Connecticut homes for rent
Rental home in Cromwell, condo rentals in Cromwell Connecticut, for rent by owner homes in Cromwell Connecticut, and Cromwell rental apartment
Bed and breakfast rentals in West Haven Connecticut and condo rentals in West Haven Connecticut
Rental apartment Cheshire, vacation rental Cheshire Connecticut, and homes for rent in Cheshire Connecticut
Homes for rent by owner in Branford Connecticut, short term rentals Branford Connecticut, rent houses in Branford Connecticut, and rent house in Branford
Condo rentals and vacation rental Vernon Connecticut
For rent by owner homes in Coventry Connecticut, houses for rent Coventry, and apartment rentals in Coventry
Rent houses, real estate rentals in Ledyard, rental home, and apartment rentals Ledyard Connecticut
Torrington Connecticut homes for rent by owner and Torrington homes for rent
Condo rentals, apartments for rent in Westport, and Westport Connecticut rent house
Bed and breakfast rentals in Groton, apartments for rent in Groton Connecticut, condo rentals, and condo rentals in Groton Connecticut
Short term rentals Derby Connecticut and Derby Connecticut homes for rent by owner
Rental properties in Darien Connecticut, Darien rental home, and rental properties Darien
Waterbury Connecticut for rent by owner homes, rental homes, rental homes in Waterbury Connecticut, and Waterbury Connecticut vacation homes
This extensive website, FRBO.com holds sector and state dossier, regularly.
Our for rent by owner website does omit bizarre principality romantic, beach, and well appointed duplex, apartment, houseboat, and chalets.
East Lyme home owners, landlords, brokers leasing foreclosures, and real estate investors list East Lyme Connecticut apartments for rent, bed and breakfast rentals, bed and breakfast rentals, and condo rentals.
For Rent By Owner can incorporate, embody, enroll, and muster hillside listed properties, lakeside ad directories, romantic lists of marked properties, and oceanfront classified advertisements log listings, penthouse listed properties, and beach directories to work with your East Lyme Connecticut expedition.
Uncover and discover house rentals Guilford United States and rent house Guilford.
See beach classifieds and hidden online MLS that property owners and land owners post on our website, FRBO.com.
Find out, elicit, and discern apartments for rent, rental properties, and rental homes in Fairfield Connecticut.
East Lyme Connecticut is a ideal and cute kingdom with ideal, enticing, cute, and ravishing lodge, hacienda, and haciendas.
Disclose, dig up, and glimpse vacation rentals in Tariffville United States, Tariffville United States vacation rental, and Tariffville United States for rent by owner homes.
Light upon and hear bed and breakfast rentals in Pequabuck and rental houses in Pequabuck United States.
Observe, ascertain, and determine vacation homes in Washington, Washington United States bed and breakfast rentals, and vacation homes for rent by owner Washington.
Get, enter, recruit, and oblige this evening to begin and launch on this passage.
Find out, discern, and catch Hartford Connecticut homes for rent and Hartford rental home.
Find out and uncover Pomfret Center United States rent house and house rentals Pomfret Center.
Come upon and devise apartments for rent in Litchfield Connecticut, Litchfield Connecticut apartments for rent, vacation rentals in Litchfield Connecticut, and vacation rental in Litchfield Connecticut.
Debunk and explore rental properties in Riverton United States and Riverton United States apartments for rent.
Devise, determine, and identify vacation homes for rent by owner, Windham Connecticut vacation homes, Windham homes for rent by owner, and Windham Connecticut apartment rentals.
Debunk, espy, and look up Tolland Connecticut houses for rent and Tolland Connecticut apartments for rent.
Kick off your expedition online this weekend, this week, on Tuesday, or day after tomorrow for your East Lyme apartment rentals, East Lyme condo rentals, and East Lyme Connecticut homes for rent.
Light upon, disclose, and distinguish rental apartment, condos for rent, and rental apartment in East Windsor Hill United States.
Originate and recognize condo rentals and Hartford Connecticut rent houses.
Counterparts and rovers cast about and scour this webpage and discern secluded condominium, lake castle, and mountain cottage.
Uncover, originate, and identify apartment rentals, rent houses in Redding Ridge United States, and rental homes in Redding Ridge United States.
You can check the ski in/out indexes, penthouse classified ads, exotic classified ads, and studio online MLS under for rent by owner homes, vacation rental East Lyme, and rental properties East Lyme Connecticut.
Disclose and ferret out North Grosvenordale United States house rentals and apartments for rent North Grosvenordale.
Conceive and relocate Orange United States holiday rentals and for rent by owner homes in Orange United States.
Occupants and fellow workers who are looking over rent house East Lyme and are trying to detect real estate rentals in East Lyme Connecticut and East Lyme Connecticut rental properties can run down our online website, FRBO.com and our mountain directories, city online MLS, waterfront online MLS, and suburban classified ads.
Recognize singular, unusual, express, and unconventional figures in East Lyme Connecticut and chart apartments for rent in East Lyme Connecticut.
Observe, come upon, and ascertain house rentals Canton Center, rent house in Canton Center, and Canton Center United States real estate rentals.
|
|
