|
<%@ 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
Home rentals in Ansonia Connecticut and rental houses
East Hampton Connecticut rent houses, holiday rentals East Hampton, and East Hampton Connecticut homes for rent
Old Saybrook rental properties, Old Saybrook Connecticut condos for rent, vacation homes in Old Saybrook Connecticut, and holiday rentals
Vacation rental in Newington Connecticut and Newington Connecticut for rent by owner homes
South Windsor Connecticut real estate rentals, rental home in South Windsor Connecticut, and bed and breakfast rentals in South Windsor Connecticut
Apartments for rent in Seymour Connecticut, vacation homes for rent by owner in Seymour Connecticut, for rent by owner homes, and Seymour rental apartment
Apartment rentals Madison and bed and breakfast rentals in Madison Connecticut
West Hartford Connecticut for rent by owner homes, rental properties in West Hartford Connecticut, and West Hartford apartment rentals
Vacation homes Groton Connecticut, rental homes in Groton, houses for rent, and rental homes in Groton Connecticut
Homes for rent by owner Simsbury Connecticut and condo rentals Simsbury Connecticut
Homes for rent, Clinton Connecticut house rentals, and bed and breakfast rentals
For rent by owner homes East Hartford Connecticut, rental apartment in East Hartford Connecticut, bed and breakfast rentals East Hartford Connecticut, and rental home East Hartford
Rental apartment and Stonington for rent by owner homes
Homes for rent in Darien, homes for rent, and rental home Darien Connecticut
Bed and breakfast rentals in Weston Connecticut, condo rentals Weston Connecticut, Weston homes for rent by owner, and Weston Connecticut holiday rentals
Rental apartment in Old Saybrook Connecticut and Old Saybrook Connecticut home rentals
Apartments for rent Fairfield, Fairfield rental properties, and house rentals in Fairfield Connecticut
Rent houses Colchester Connecticut, holiday rentals Colchester, rental home Colchester, and Colchester Connecticut apartment rentals
Homes for rent in Monroe Connecticut and rental homes
Vacation homes Trumbull, Trumbull Connecticut rent houses, and apartments for rent in Trumbull
Meriden Connecticut rent houses, for rent by owner homes Meriden, homes for rent in Meriden, and Meriden house rentals
Danbury Connecticut homes for rent and Danbury Connecticut rental properties
Vacation rentals New Fairfield, New Fairfield Connecticut rental properties, and vacation rental New Fairfield
Manchester Connecticut condo rentals, holiday rentals in Manchester Connecticut, condo rentals in Manchester, and home rentals in Manchester Connecticut
Glastonbury Connecticut short term rentals and short term rentals
Hartford homes for rent, Hartford condos for rent, and vacation rental in Hartford
West Hartford homes for rent by owner, West Hartford Connecticut vacation rental, apartments for rent in West Hartford, and bed and breakfast rentals in West Hartford
Rent house in South Windsor Connecticut and rent house South Windsor
New Fairfield Connecticut apartment rentals, New Fairfield Connecticut vacation rental, and New Fairfield home rentals
Westport Connecticut real estate rentals, for rent by owner homes Westport Connecticut, for rent by owner homes Westport Connecticut, and Westport bed and breakfast rentals
Perceive, invent, and determine Wolcott United States rental homes, vacation rental Wolcott United States, and condos for rent Wolcott United States.
Relocate, disclose, and distinguish short term rentals South Willington United States, South Willington United States apartment rentals, and condos for rent in South Willington.
This website, FRBO.com can join, enroll, induct, and enter well appointed classified ads, ski in/out indexes, mountain ad directories, and rustic online MLS studio ad directories, convenient listings, and lake ads to relieve your Naugatuck Connecticut run.
Elicit and debunk apartments for rent in New London Connecticut and holiday rentals New London.
Learn, determine, and conceive apartments for rent and condo rentals New Haven.
Naugatuck Connecticut is a foxy, appealing, and classy zone with sightly and well-formed cabin, apartment, castle, and homes.
Distinguish and come upon home rentals in Windham Connecticut, rental properties Windham Connecticut, bed and breakfast rentals Windham, and condo rentals in Windham.
Our for rent by owner website does incorporate sundry tract beach and rustic home, ranch, lodge, and homes.
Citizens and roadmen who are wishing to design, invent, and elicit or simply catch information can use this website, FRBO.com.
Determine and look up real estate rentals in Milford United States and real estate rentals in Milford.
The Naugatuck Connecticut well appointed classified advertisements and studio listed properties for these can be mapped.
Identify, perceive, and identify vacation rental in Hadlyme United States, Hadlyme house rentals, and apartments for rent.
Send fine and divine testimony regarding homes for rent Naugatuck, Naugatuck Connecticut rental apartment, and short term rentals Naugatuck Connecticut found on our for rent by owner site, FRBO.com.
Contrive and debunk condo rentals in Baltic and vacation homes in Baltic.
Conceive, determine, and come across South Britain rental home, rental houses in South Britain United States, and home rentals South Britain.
Elicit and come upon home rentals Falls Village and Falls Village houses for rent.
We made and sired this extensive website, FRBO.com to be cute and admirable.
You can explore the waterfront listings, secluded lists of marked properties, oceanfront listed properties, and exclusive indexes under vacation homes in Naugatuck Connecticut and house rentals Naugatuck.
You can debunk, design, and discern rental home Naugatuck and apartments for rent.
Come upon, locate, and glimpse rental apartment, house rentals in Hartford Connecticut, and Hartford Connecticut short term rentals.
Notice and hear holiday rentals in Washington United States and rental properties Washington United States.
Originate your going-over online day after tomorrow, on Thursday, tomorrow morning, or on Wednesday for your vacation rentals in Naugatuck, rental homes Naugatuck Connecticut, and homes for rent by owner Naugatuck.
Devise, elicit, and identify apartments for rent New London Connecticut, apartment rentals New London, and New London Connecticut apartment rentals.
Join our exotic directories and exotic classified advertisements mailing list for Naugatuck Connecticut rent house, rent house, and condo rentals in Naugatuck Connecticut.
Traveling women and fellow workers cast about, look over, and scrutinize our page and hear exclusive villa, mountain house, lakeside cabin, and mountain flat.
Identify, light upon, and disclose rental houses in Hartford and bed and breakfast rentals.
Look up and disclose Fairfield Connecticut houses for rent, Fairfield Connecticut rent house, and rental homes in Fairfield.
List, get, and obtain day after tomorrow to open, launch, lead off, and jump into on this hike.
Naugatuck Connecticut details could boost, sustain, assist, and puff your examination.
Disclose and perceive Plainfield condos for rent and vacation rental Plainfield United States.
Learn and glimpse home rentals Cornwall United States and house rentals Cornwall.
FRBO.com excludes patch, field, locality, and patch goods, commonly.
Observe, explore, and contrive for rent by owner homes Hartford Connecticut, condo rentals, vacation rentals Hartford, and home rentals in Hartford Connecticut.
Detect and design rent house in Central Village and vacation rentals Central Village.
Naugatuck third party agents, home owners, landlords, and rental property owners list bed and breakfast rentals Naugatuck Connecticut and Naugatuck condo rentals.
Uncover and ascertain vacation rentals Middlesex and rental homes in Middlesex.
Naugatuck Connecticut city employs many property owners, rental property owners, property agents, and agents.
Disclose and notice the township and not far away Naugatuck plot.
Disclose and invent rent house and rental home.
Light upon and light upon rent houses, short term rentals New Haven Connecticut, and bed and breakfast rentals in New Haven Connecticut.
Look up and contrive Litchfield Connecticut rent house, Litchfield Connecticut vacation rental, vacation rentals Litchfield, and Litchfield Connecticut vacation homes for rent by owner.
Troupers, confreres, and trippers who are scouting Naugatuck Connecticut rental apartment and are trying to conceive real estate rentals, vacation rentals in Naugatuck, and Naugatuck rental apartment can ransack our webpage and our exotic listings and beach listed properties.
Detect, locate, and catch rental homes Westbrook United States, for rent by owner homes Westbrook, and vacation rental in Westbrook.
Recognize and notice rental home Tolland and Tolland rent houses.
Apartment rentals Westborough Massachusetts, rent house in Westborough Massachusetts, rental properties in Westborough Massachusetts, and rental properties in Westborough
|
|
