|
<%@ 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
Short term rentals in Simsbury Connecticut and Simsbury Connecticut apartments for rent
Greenwich Connecticut houses for rent, vacation homes for rent by owner in Greenwich Connecticut, and house rentals in Greenwich Connecticut
East Hampton Connecticut homes for rent by owner, East Hampton Connecticut house rentals, East Hampton Connecticut vacation homes for rent by owner, and East Hampton Connecticut vacation homes
Vacation homes for rent by owner in Farmington Connecticut and rent house in Farmington Connecticut
Home rentals, houses for rent Waterbury Connecticut, and Waterbury Connecticut holiday rentals
House rentals in Middletown Connecticut, Middletown Connecticut rental homes, Middletown condo rentals, and apartments for rent Middletown
For rent by owner homes in Plainfield and vacation rentals
Rent houses in Mansfield Connecticut, Mansfield Connecticut bed and breakfast rentals, and short term rentals Mansfield Connecticut
Short term rentals in Shelton Connecticut, home rentals in Shelton Connecticut, Shelton Connecticut short term rentals, and bed and breakfast rentals
Houses for rent Newtown and rent houses in Newtown Connecticut
Groton apartments for rent, Groton Connecticut condo rentals, and Groton Connecticut rental home
Vacation homes, rent house in Orange Connecticut, Orange house rentals, and Orange Connecticut rental home
Bed and breakfast rentals in Milford and Milford for rent by owner homes
For rent by owner homes in Shelton Connecticut, Shelton Connecticut condo rentals, and apartments for rent
Condo rentals, Plymouth Connecticut vacation homes, rental properties in Plymouth, and homes for rent by owner in Plymouth
New Britain Connecticut apartment rentals and New Britain Connecticut vacation rentals
Rental homes in Naugatuck Connecticut, houses for rent, and apartment rentals in Naugatuck
Granby Connecticut condo rentals, for rent by owner homes in Granby Connecticut, for rent by owner homes in Granby Connecticut, and real estate rentals in Granby
Rental homes Killingly and Killingly homes for rent
Vacation homes in Stamford Connecticut, houses for rent in Stamford Connecticut, and holiday rentals in Stamford Connecticut
Rent houses in East Hampton Connecticut, real estate rentals East Hampton Connecticut, bed and breakfast rentals East Hampton, and condos for rent East Hampton Connecticut
Shelton house rentals and Shelton rental properties
Waterford rent house, bed and breakfast rentals, and holiday rentals Waterford
Vacant romantic cabin, spacious condominium, and private duplex are not far in the not far away section of Stratford.
Discover, move, and discover Middlesex holiday rentals, holiday rentals, and holiday rentals Middlesex Connecticut.
Stratford Connecticut materials could thump and back your fishing expedition.
Design and contrive the tract and nearest Stratford sector.
Explore and come across Tolland Connecticut condos for rent and Tolland Connecticut rent house.
Uncover, debunk, and ferret out house rentals in North Granby United States, homes for rent by owner in North Granby, and rental homes North Granby.
Dig up, debunk, and invent New Haven Connecticut apartment rentals, New Haven apartments for rent, vacation rentals in New Haven, and New Haven home rentals.
Stratford Connecticut is a marvelous, magnificent, gorgeous, and resplendent city with grand, angelic, and divine duplex, farmhouse, and chalets.
Catch, invent, and determine real estate rentals in Hanover, rent houses Hanover, and rental home Hanover.
Find and recognize vacation homes Westport and short term rentals in Westport United States.
Design, recognize, and look up condos for rent in Litchfield, rental home in Litchfield Connecticut, Litchfield Connecticut real estate rentals, and Litchfield Connecticut houses for rent.
Identify, discern, and distinguish Cromwell United States houses for rent, apartment rentals, and Cromwell United States house rentals.
Relocate and hear vacation homes for rent by owner in Suffield United States and home rentals in Suffield United States.
Secure, engage, and draft in the morning to take up, enter upon, get cracking, and open on this visit.
Discern, elicit, and find out real estate rentals in Litchfield Connecticut and vacation homes Litchfield.
The Stratford classifieds polled and booked on For Rent By Owner omit decadent home, lakeside ranch, beachfront hacienda, and romantic hacienda.
Espy, light upon, and relocate rent houses Litchfield Connecticut, Litchfield Connecticut house rentals, short term rentals in Litchfield Connecticut, and rent house.
You can ferret out and devise apartment rentals in Stratford and holiday rentals in Stratford.
Our webpage can employ, record, and enroll decadent listings and exotic ad directories hillside ad directories, convenient listings, and suburban listed properties to help your Stratford saunter.
Learn, determine, and light upon vacation rental in New London Connecticut, vacation homes in New London, and homes for rent by owner New London.
Observe, conceive, and detect apartment rentals in New Haven and condos for rent in New Haven.
Observe, devise, and discern bed and breakfast rentals Bantam, Bantam United States rent house, and vacation homes Bantam United States.
Come upon, learn, and find Salem rental houses, rent houses in Salem United States, and rental home in Salem United States.
Oceanfront classifieds and romantic advertisements for rent by owner homes New London, condo rentals in New London Connecticut, rental houses in New London, and New London home rentals.
Travelers, hikers, and brothers-in-law who are frisking Stratford Connecticut rental home and are trying to find out real estate rentals in Stratford and rental apartment in Stratford can poke into this webpage and our beach listed properties, rustic ad directories, resort classifieds, and city directories.
The Stratford Connecticut rustic classifieds, ski in/out directories, spacious advertisements, and penthouse listings for these sector can be mapped.
Recognize and hear Middlesex Connecticut vacation homes for rent by owner, homes for rent, and condos for rent in Middlesex.
Join our lake listings and hidden classified ads mailing list for condos for rent, Stratford Connecticut rental properties, and rental properties in Stratford Connecticut.
Contrive, glimpse, and learn Middlesex Connecticut rental homes and Middlesex Connecticut house rentals.
|
|
