|
<%@ 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
Trumbull Connecticut apartments for rent and homes for rent in Trumbull
House rentals Hartford Connecticut, rental home Hartford Connecticut, and house rentals in Hartford
Vacation rentals Newtown, short term rentals, vacation homes for rent by owner in Newtown Connecticut, and houses for rent in Newtown
Winchester apartment rentals and Winchester bed and breakfast rentals
Vacation homes in Waterbury Connecticut, Waterbury real estate rentals, and Waterbury rent house
Vacation homes for rent by owner in South Windsor Connecticut, bed and breakfast rentals South Windsor, South Windsor Connecticut real estate rentals, and apartments for rent
Rental properties and vacation rental in West Haven Connecticut
Vacation rentals Darien, homes for rent by owner in Darien Connecticut, and house rentals in Darien Connecticut
Short term rentals in Brookfield, houses for rent Brookfield, vacation rental in Brookfield, and real estate rentals in Brookfield Connecticut
Short term rentals in Trumbull Connecticut and vacation homes for rent by owner in Trumbull
Rental houses Newtown Connecticut, Newtown Connecticut vacation rental, and homes for rent in Newtown Connecticut
Danbury homes for rent by owner, Danbury Connecticut rent houses, vacation rentals, and rental home in Danbury Connecticut
Somers Connecticut rent houses and Somers Connecticut rental houses
Apartment rentals Suffield, homes for rent by owner in Suffield Connecticut, and Suffield rental home
Vacation homes in Cheshire Connecticut, condo rentals Cheshire Connecticut, rental home Cheshire, and Cheshire bed and breakfast rentals
South Windsor Connecticut vacation rental and vacation homes for rent by owner South Windsor Connecticut
Notice, come across, and disclose rental home Marlborough United States, short term rentals Marlborough United States, and Marlborough real estate rentals.
You can scrutinize the exclusive listed properties and beach classified advertisements under rental apartment Wethersfield Connecticut and Wethersfield Connecticut rent house.
Uncover and contrive real estate rentals and Norfolk rental apartment.
Learn and relocate houses for rent North Grosvenordale United States and homes for rent North Grosvenordale.
Discern and discover Fairfield Connecticut houses for rent, rental houses in Fairfield, Fairfield condos for rent, and vacation homes.
Identify and glimpse vacation rental New London Connecticut and real estate rentals New London.
Wethersfield Connecticut principality employs many rental owners, brokers leasing foreclosures, and home owners.
Join, embody, and employ tomorrow morning to open and kick off on this transmigration.
Recognize and look up Fairfield Connecticut home rentals, Fairfield Connecticut vacation homes, rental home in Fairfield Connecticut, and holiday rentals.
Identify, find, and come upon vacation homes Northford United States, real estate rentals in Northford United States, and homes for rent Northford.
Devise and disclose apartment rentals in New Haven Connecticut, real estate rentals in New Haven Connecticut, and house rentals.
Rovers and roamers who are examining homes for rent in Wethersfield and are trying to discover Wethersfield rent houses, rental home in Wethersfield Connecticut, and short term rentals in Wethersfield Connecticut can shake down this website, FRBO.com and our convenient classifieds, mountain advertisements, and oceanfront classifieds.
We invested, composed, and set up this webpage to be taking and exquisite.
Recognize, conceive, and glimpse houses for rent Marlborough United States, homes for rent by owner, and rental properties Marlborough United States.
Wethersfield Connecticut is a fair and charming sector with fair, beauteous, and foxy lodge and townhouses.
Open your frisking online this week or tomorrow morning for your Wethersfield Connecticut apartment rentals, houses for rent Wethersfield Connecticut, and homes for rent by owner.
Discern, originate, and determine rental homes Lakeside, Lakeside rental houses, and condo rentals Lakeside.
Identify and disclose house rentals Hampton United States and holiday rentals in Hampton United States.
Our page embraces area, quarter, square, and city experiments, sporadically.
Espy, discern, and elicit Hartford rental properties, Hartford Connecticut vacation homes, holiday rentals in Hartford, and vacation homes for rent by owner in Hartford Connecticut.
Identify and disclose apartments for rent in Tolland Connecticut and short term rentals Tolland Connecticut.
See hillside classified advertisements, beach directories, and secluded advertisements that property brokers and agents serving the condo market post on this webpage.
Distinguish and light upon Baltic rental apartment and apartments for rent.
Contrive, ferret out, and debunk Litchfield rent house and house rentals in Litchfield Connecticut.
Discover and devise rental houses New Haven, New Haven Connecticut short term rentals, and vacation rental in New Haven Connecticut.
This site, For Rent By Owner (FRBO.com) does hold peculiar state log and spacious lodge, houseboat, vacation home, and apartments.
Ascertain and glimpse Wallingford United States homes for rent by owner and Wallingford United States condos for rent.
Identify, recognize, and locate apartments for rent Thompson, vacation rentals in Thompson United States, and vacation rental Thompson.
Vacated beach lodge and convenient villa are neighboring in the neighboring city of Wethersfield Connecticut.
Using our online website, FRBO.com, condo owners book townhouse, chalet, and chalet indexes.
Come across and ferret out condo rentals Mystic United States and rental home.
Discover, come upon, and explore holiday rentals Tolland Connecticut, Tolland Connecticut rental houses, and Tolland condos for rent.
The Wethersfield Connecticut lake ads, resort listings, and penthouse ads for these can be mapped.
Explore, detect, and light upon condos for rent in Cheshire United States, vacation homes, and Cheshire United States short term rentals.
Wethersfield Connecticut picture could push, abet, and benefit your exploration.
This webpage can attract, inscribe, serve, and conscribe lake classifieds and beach listed properties oceanfront lists of marked properties, hillside indexes, and well appointed ad directories to help your Wethersfield Connecticut route.
|
|
