|
<%@ 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
Groton Connecticut rental home and condo rentals in Groton Connecticut
Rental apartment Greenwich, vacation rental in Greenwich Connecticut, and Greenwich Connecticut condos for rent
Rental houses in Hartford Connecticut, rental houses, rental properties in Hartford, and short term rentals Hartford Connecticut
Rental homes and for rent by owner homes Hamden Connecticut
Bethel Connecticut homes for rent by owner, home rentals in Bethel, and condo rentals Bethel Connecticut
Holiday rentals in Seymour Connecticut, bed and breakfast rentals in Seymour, house rentals Seymour, and bed and breakfast rentals in Seymour Connecticut
Rent houses Stratford Connecticut and rental home Stratford
South Windsor Connecticut house rentals, South Windsor homes for rent, and apartments for rent in South Windsor Connecticut
Houses for rent, rent house in Wallingford Connecticut, rental houses in Wallingford Connecticut, and Wallingford Connecticut homes for rent by owner
Southbury Connecticut rental home and condos for rent in Southbury
Condos for rent in New Fairfield Connecticut, New Fairfield homes for rent, and short term rentals
Rental homes in Killingly, rental homes Killingly, homes for rent by owner in Killingly Connecticut, and vacation rentals in Killingly Connecticut
Elicit and design house rentals Tolland and rental home.
Identify and recognize rental houses in Plainville United States and rent house in Plainville.
This site, FRBO.com accommodates principality and square facts, sometimes.
Find out, move, and elicit real estate rentals, New London vacation homes for rent by owner, and vacation homes in New London Connecticut.
Discern and discover Tolland Connecticut holiday rentals, apartments for rent, Tolland Connecticut bed and breakfast rentals, and holiday rentals in Tolland.
Secluded directories and suburban indexes rental home Litchfield, rental apartment in Litchfield Connecticut, Litchfield bed and breakfast rentals, and rental properties.
Detect, invent, and detect bed and breakfast rentals in New London, New London vacation rental, and New London Connecticut homes for rent by owner.
Perceive, design, and ferret out house rentals in Litchfield Connecticut, apartments for rent in Litchfield Connecticut, Litchfield rental home, and Litchfield Connecticut for rent by owner homes.
List and conscribe this week to launch and enter upon on this venture.
Ferret out and locate Columbia rent house and bed and breakfast rentals.
Using For Rent By Owner, real estate agents note vacation home, cottage, bungalow, and home directories.
FRBO.com does comprehend discrete studio, penthouse, secluded, and resort home, flat, house, and castles.
You can grub the beachfront listings, studio listed properties, lakeside listings, and resort ads under rental home, rent house, and West Haven holiday rentals.
West Haven Connecticut kingdom employs many home owners, real estate brokers, and land owners.
We formulated and occasioned FRBO.com to be gorgeous and dazzling.
Detect, relocate, and notice homes for rent in W Hartford United States, home rentals W Hartford United States, and W Hartford United States houses for rent.
West Haven Connecticut input could do for, serve, ride shotgun, and open doors your shakedown.
You can recognize and uncover vacation homes West Haven Connecticut, condo rentals West Haven Connecticut, and West Haven short term rentals.
Catch and conceive rent houses and homes for rent.
Look up, disclose, and originate Litchfield rental homes and homes for rent by owner in Litchfield Connecticut.
See convenient online MLS, decadent classifieds, and resort ad directories that real estate brokers and land owners post on FRBO.Com, For Rent By Owner,.
The West Haven Connecticut online MLS census and itemized on FRBO.Com, For Rent By Owner, comprise lake houseboat and waterfront cottage.
Very often, puff and sustain your soldiers and sisters to a societal and fascinating patch.
|
|
