|
<%@ 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
Condo rentals in Newington and rent houses in Newington Connecticut
Condo rentals, rent house in Norwich Connecticut, and rent houses Norwich
Greenwich Connecticut vacation homes for rent by owner, vacation rentals in Greenwich, Greenwich condos for rent, and vacation homes Greenwich Connecticut
Apartments for rent in Meriden Connecticut and homes for rent in Meriden
Ansonia rental properties, Ansonia Connecticut holiday rentals, and Ansonia Connecticut apartment rentals
Vacation rentals Seymour Connecticut, rent house in Seymour Connecticut, Seymour Connecticut vacation rentals, and Seymour Connecticut rental properties
Home rentals Westport and Westport Connecticut for rent by owner homes
Windham Connecticut houses for rent, holiday rentals Windham Connecticut, and Windham Connecticut short term rentals
West Hartford bed and breakfast rentals, vacation rental West Hartford, vacation rentals in West Hartford, and rental properties
Ledyard Connecticut rental properties and apartments for rent in Ledyard Connecticut
Bed and breakfast rentals in Madison, homes for rent, and rental homes in Madison
Granby Connecticut bed and breakfast rentals, Granby Connecticut apartment rentals, vacation homes in Granby Connecticut, and vacation rental in Granby Connecticut
Apartments for rent in Bridgeport Connecticut and apartment rentals Bridgeport
Condo rentals in Hartford Connecticut, apartment rentals Hartford Connecticut, and Hartford rental houses
New Britain homes for rent by owner, New Britain Connecticut short term rentals, vacation homes New Britain Connecticut, and New Britain vacation homes for rent by owner
Rental homes in East Haven and East Haven Connecticut vacation homes
Fairfield Connecticut vacation homes, Fairfield Connecticut vacation rentals, and vacation homes for rent by owner in Fairfield Connecticut
Condos for rent in Monroe, vacation homes in Monroe Connecticut, rental properties, and rental homes
Homes for rent in Fairfield Connecticut and Fairfield Connecticut vacation homes
Rental homes Middletown Connecticut, vacation homes Middletown Connecticut, and houses for rent in Middletown Connecticut
New London Connecticut rent house, holiday rentals in New London, rental home in New London Connecticut, and New London Connecticut apartments for rent
Come across and determine vacation homes Windham and rent house in Windham Connecticut.
New Milford Connecticut input could reinforce, do for, and hype your investigation.
The New Milford Connecticut city classifieds, beach listed properties, romantic advertisements, and waterfront lists of marked properties for these turf can be mapped.
Hear, come across, and discern vacation homes Middlesex Connecticut, rent houses in Middlesex Connecticut, and Middlesex Connecticut homes for rent.
Ascertain, determine, and conceive houses for rent in Litchfield and Litchfield Connecticut homes for rent by owner.
Contrive and uncover apartment rentals in Hartford Connecticut, Hartford condo rentals, and vacation rental in Hartford.
Originate and discover vacation rentals in Fairfield and condo rentals in Fairfield Connecticut.
Come across, originate, and relocate Ballouville United States rental properties, for rent by owner homes Ballouville United States, and Ballouville United States rental houses.
Catch unique, specialized, peculiar, and sparse whole story in New Milford Connecticut and peg rental houses New Milford.
Traveling agents, sailors, and traveling men who are wishing to espy and contrive or simply come upon information can use our online website, FRBO.com.
Dig up and ascertain holiday rentals in Litchfield Connecticut, Litchfield apartment rentals, and short term rentals in Litchfield Connecticut.
Distinguish and light upon North Stonington condos for rent and vacation homes in North Stonington United States.
Come upon and dig up home rentals in Avon United States and rental houses Avon United States.
You can disclose and come upon holiday rentals in New Milford Connecticut and rental homes in New Milford Connecticut.
Light upon, determine, and identify New Haven Connecticut vacation rentals and vacation homes.
Devise and look up rental homes Windham, rental houses in Windham, Windham short term rentals, and vacation homes for rent by owner in Windham Connecticut.
Our page does comprehend unconventional precinct log and mountain ranch, villa, houseboat, and lodges.
Discover, find out, and discover rental home in Middlesex, homes for rent Middlesex, rent houses in Middlesex Connecticut, and home rentals.
We fathered and planned our website, FRBO.com to be comely, stunning, cute, and dazzling.
Come across and learn the patch and not remote New Milford Connecticut stretch.
New Milford agents serving the condo market, real estate brokers, property brokers, and landlords list home rentals New Milford Connecticut, New Milford Connecticut condos for rent, and condo rentals in New Milford Connecticut.
Relocate and relocate rental homes Middlesex, Middlesex Connecticut real estate rentals, and rental properties Middlesex.
Espy and glimpse houses for rent Brookfield United States and rental apartment in Brookfield United States.
Distinguish, discover, and discover New London Connecticut for rent by owner homes, rental houses in New London Connecticut, and New London rental houses.
Come upon and look up rental properties Hebron United States and rental apartment.
The New Milford Connecticut directories charted and spelled out on FRBO.com eliminate hillside chalet, oceanfront farmhouse, mountain lodge, and waterfront hacienda.
Learn and explore Winsted rent house and short term rentals Winsted.
Perceive, catch, and find rental houses Middlefield United States, rent house in Middlefield United States, and Middlefield United States rent house.
|
|
