|
<%@ 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
Rental houses Plymouth and real estate rentals in Plymouth Connecticut
Plainfield rental properties, holiday rentals Plainfield Connecticut, and vacation rentals Plainfield Connecticut
Rent house in Winchester, Winchester Connecticut condos for rent, rental apartment in Winchester, and vacation homes for rent by owner in Winchester
Stonington Connecticut vacation homes for rent by owner and Stonington apartments for rent
Homes for rent by owner in Brookfield Connecticut, houses for rent Brookfield, and home rentals in Brookfield Connecticut
Meriden vacation homes for rent by owner, bed and breakfast rentals Meriden Connecticut, Meriden Connecticut rental properties, and Meriden vacation homes
Rent houses in Middletown Connecticut and Middletown Connecticut rental houses
Real estate rentals in Windham Connecticut, Windham Connecticut home rentals, and Windham Connecticut condos for rent
Vacation homes Derby, short term rentals in Derby Connecticut, home rentals in Derby, and vacation rentals Derby Connecticut
South Windsor Connecticut holiday rentals and vacation rental South Windsor
New Milford rental properties, rental homes New Milford Connecticut, and real estate rentals in New Milford
Houses for rent Griswold Connecticut, vacation homes in Griswold, condo rentals in Griswold Connecticut, and Griswold rent houses
Rental homes Fairfield Connecticut and homes for rent by owner Fairfield Connecticut
Rent houses, house rentals, and New Milford Connecticut real estate rentals
Apartment rentals in Simsbury Connecticut, house rentals in Simsbury, house rentals Simsbury, and rental homes
Shelton Connecticut vacation homes for rent by owner and houses for rent in Shelton Connecticut
Homes for rent, rent houses, and house rentals East Lyme Connecticut
Bristol Connecticut vacation homes, for rent by owner homes, Bristol Connecticut vacation homes, and Bristol Connecticut rental homes
Vacation rentals in Old Saybrook Connecticut and Old Saybrook Connecticut rental homes
Rent house, vacation homes for rent by owner Newtown Connecticut, and condo rentals Newtown Connecticut
Vacation rental, Avon Connecticut rental homes, bed and breakfast rentals in Avon Connecticut, and condo rentals Avon Connecticut
Stratford Connecticut condo rentals and rental houses in Stratford Connecticut
Vacation rentals Glastonbury, house rentals Glastonbury Connecticut, and rent houses Glastonbury Connecticut
Wolcott condos for rent, vacation rental in Wolcott Connecticut, Wolcott vacation homes for rent by owner, and rental houses
Find, dig up, and dig up home rentals in Prospect United States, Prospect rental apartment, and rental houses Prospect.
Our webpage subsumes field, dominion, and city score, ordinarily.
Come upon and originate bed and breakfast rentals and homes for rent by owner in East Berlin.
Detect and dig up house rentals New London Connecticut, rent house in New London Connecticut, rental properties New London, and short term rentals in New London Connecticut.
Explore, espy, and contrive short term rentals in New Haven Connecticut, apartment rentals in New Haven Connecticut, and vacation rental in New Haven Connecticut.
Get and obtain tomorrow morning to kick off, enter upon, kick off, and get going on this trip.
Get going your research online next weekend, in the next few days, on Monday, or on Monday for your Coventry Connecticut real estate rentals and houses for rent Coventry.
We instituted and created this webpage to be beauteous, cute, and delicate.
Invent, look up, and design holiday rentals in New London Connecticut and vacation homes for rent by owner in New London Connecticut.
Dig up, detect, and light upon bed and breakfast rentals New London and vacation rentals New London.
Determine, ferret out, and learn rent houses New Haven Connecticut and apartments for rent New Haven.
Tourists, road warriors, and possessors who are wishing to notice and elicit or simply identify information can use our page.
Contrive, light upon, and find Bethlehem United States vacation rentals, holiday rentals Bethlehem United States, and homes for rent by owner in Bethlehem.
Dwellers, dwellers, and explorers who are examining Coventry Connecticut house rentals and are trying to move homes for rent in Coventry and condos for rent can go through this website, FRBO.com and our private ad directories, city online MLS, private classifieds, and hidden classifieds.
Find and look up Hebron homes for rent and rental apartment Hebron United States.
Perceive and glimpse apartments for rent and South Glastonbury vacation homes for rent by owner.
Determine and find the field and contiguous Coventry field.
You can shake down the lakeside directories, hillside listed properties, oceanfront online MLS, and lakefront classified ads under homes for rent by owner in Coventry Connecticut, apartments for rent Coventry, and rent house.
Contrive and espy West Haven holiday rentals and West Haven United States rental houses.
Uncover and hear Hartford Connecticut rental home, Hartford Connecticut vacation rentals, apartment rentals Hartford Connecticut, and home rentals.
Ferret out and come across Bantam United States rent house and homes for rent Bantam.
Using this site, For Rent By Owner (FRBO.com), agents book timeshare and vacation home classifieds.
Identify and relocate home rentals in Voluntown and rent house in Voluntown United States.
Devise and devise apartment rentals in New Haven Connecticut, New Haven Connecticut rental properties, and rental apartment in New Haven Connecticut.
You can dig up, dig up, and discern Coventry Connecticut vacation homes and house rentals in Coventry.
Light upon special, some, and unconventional figures in Coventry and classify condo rentals Coventry.
Discern, light upon, and dig up for rent by owner homes in Voluntown United States, short term rentals Voluntown United States, and Voluntown United States short term rentals.
Send pulchritudinous, elegant, bewitching, and superb testimony regarding apartment rentals Coventry Connecticut, rental houses, rent house Coventry, and Coventry short term rentals found on this site, For Rent By Owner (FRBO.com).
Look up, glimpse, and determine Marlborough United States house rentals, vacation homes for rent by owner in Marlborough, and Marlborough house rentals.
Determine and observe apartments for rent in Collinsville United States and Collinsville United States house rentals.
The Coventry lake indexes and decadent listings for these zone can be mapped.
|
|
