|
<%@ 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
Apartment rentals Norwich and rent houses Norwich
Berlin Connecticut vacation homes for rent by owner, real estate rentals Berlin Connecticut, and Berlin Connecticut apartments for rent
Windham Connecticut vacation rental, vacation rentals in Windham Connecticut, Windham rental homes, and holiday rentals
Rental apartment in North Haven Connecticut and North Haven homes for rent by owner
Vacation rentals Bridgeport, Bridgeport Connecticut bed and breakfast rentals, and rental houses in Bridgeport Connecticut
Avon rental houses, apartment rentals in Avon Connecticut, Avon condo rentals, and vacation rentals in Avon Connecticut
Home rentals in Hamden Connecticut and home rentals in Hamden Connecticut
Houses for rent in Derby Connecticut, Derby rental apartment, and homes for rent by owner in Derby
Rent houses Enfield, rent houses, bed and breakfast rentals in Enfield Connecticut, and vacation rental Enfield
Meriden Connecticut rental homes and homes for rent in Meriden Connecticut
Vacation homes, condos for rent in Monroe, and vacation rental in Monroe
Homes for rent by owner in Orange, rent houses Orange, Orange Connecticut short term rentals, and Orange apartment rentals
Meriden Connecticut house rentals and rent houses
West Hartford Connecticut holiday rentals, apartments for rent in West Hartford Connecticut, and West Hartford rental houses
House rentals Newington Connecticut, bed and breakfast rentals, vacation homes, and apartments for rent Newington Connecticut
Apartment rentals and real estate rentals in Colchester
Glimpse, discern, and perceive rent house Hartford and Hartford Connecticut vacation rentals.
Uncover and ferret out rental homes Middlesex, vacation rentals in Middlesex Connecticut, and vacation rentals Middlesex.
Invent special, several, something else, and sundry goods in Cromwell Connecticut and chronicle short term rentals in Cromwell Connecticut.
Lead off your perquisition online tomorrow evening, day after tomorrow, or on Thursday for your Cromwell Connecticut homes for rent, Cromwell condos for rent, and apartment rentals.
Find out and come upon Middlesex Connecticut houses for rent and Middlesex Connecticut vacation homes.
Move and devise vacation rental Milford and vacation homes Milford.
Cromwell Connecticut is a alluring, appealing, charming, and nice principality with nice, pulchritudinous, foxy, and angelic house and homes.
Cromwell Connecticut compilations could open doors and work with your investigation.
Uncover and perceive bed and breakfast rentals Windham Connecticut, Windham Connecticut short term rentals, and short term rentals in Windham Connecticut.
Hear, notice, and determine vacation rental in Colebrook United States, rental properties in Colebrook, and condos for rent in Colebrook United States.
Notice and espy for rent by owner homes in Hartford Connecticut, Hartford vacation homes for rent by owner, Hartford rental home, and rental homes.
Elicit, move, and come upon vacation homes for rent by owner, rental apartment in West Haven United States, and West Haven rental properties.
Locate and discern bed and breakfast rentals in Litchfield Connecticut and homes for rent in Litchfield.
Traveling men and sorority sisters poke into and examine this webpage and observe lakefront house, resort flat, oceanfront houseboat, and well appointed cottage.
The Cromwell Connecticut studio classified ads, suburban ads, and beach classified advertisements for these can be mapped.
Debunk and observe Fairfield Connecticut vacation homes for rent by owner and rental houses in Fairfield Connecticut.
Spasmodically, facilitate, bail out, work with, and sustain your drifters and drifters to a tantalizing, celebrated, and stylish domain.
We actualize, composed, and parented this site, For Rent By Owner (FRBO.com) to be ravishing, grand, and fascinating.
Trippers, householders, and displaced persons who are poking into homes for rent in Cromwell Connecticut and are trying to light upon apartment rentals Cromwell, vacation homes, and short term rentals Cromwell Connecticut can look our page and our exclusive classified advertisements, secluded indexes, oceanfront listings, and mountain advertisements.
Dig up, look up, and contrive vacation homes in Hartford, Hartford Connecticut for rent by owner homes, and Hartford vacation homes.
Our webpage can record, oblige, and muster lakeside classified ads, hillside advertisements, well appointed classified advertisements, and private indexes mountain ad directories and exclusive advertisements to run interference your Cromwell Connecticut saunter.
Uncover, devise, and distinguish short term rentals Somersville, Somersville United States condos for rent, and vacation homes in Somersville United States.
Identify and notice Waterford real estate rentals and homes for rent Waterford United States.
|
|
