|
<%@ 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
Homes for rent and Enfield vacation homes
Bridgeport Connecticut apartments for rent, Bridgeport Connecticut rent houses, and bed and breakfast rentals
Holiday rentals in Enfield Connecticut, vacation homes Enfield Connecticut, rental home in Enfield Connecticut, and Enfield Connecticut real estate rentals
Houses for rent and rental apartment in Ledyard Connecticut
Wethersfield condos for rent, homes for rent by owner in Wethersfield Connecticut, and Wethersfield real estate rentals
Holiday rentals in Windsor, bed and breakfast rentals in Windsor Connecticut, rental apartment in Windsor, and Windsor Connecticut condo rentals
House rentals in Stafford Connecticut and rental houses in Stafford Connecticut
Newington Connecticut homes for rent by owner, Newington Connecticut home rentals, and vacation rental
Rental homes, Montville Connecticut rental home, Montville Connecticut homes for rent by owner, and Montville house rentals
Apartment rentals and for rent by owner homes
Madison Connecticut homes for rent by owner, rental home in Madison Connecticut, and rental home Madison
Condo rentals in Branford Connecticut, vacation rentals in Branford, Branford Connecticut condo rentals, and rent houses in Branford
Apartment rentals in Clinton and home rentals Clinton Connecticut
Ridgefield Connecticut rental home, home rentals in Ridgefield Connecticut, and Ridgefield condo rentals
Apartments for rent, condos for rent Middletown Connecticut, for rent by owner homes Middletown, and rental home
Home rentals in Plymouth Connecticut and rental homes Plymouth Connecticut
Apartment rentals Ansonia, homes for rent Ansonia, and short term rentals in Ansonia Connecticut
Invent, ferret out, and design the field and nearly Griswold Connecticut county.
Residers and navigators who are wishing to look up, come upon, and identify or simply look up information can use our webpage.
Passengers and drifters scour, chase after, and prospect our online website, FRBO.com and recognize oceanfront villa, penthouse flat, beach castle, and exclusive houseboat.
Griswold property managers, rental owners, rental agents, and property brokers list Griswold Connecticut rental homes, homes for rent by owner in Griswold Connecticut, and houses for rent in Griswold.
Griswold domain employs many landlords and land owners.
Elicit, explore, and relocate New London bed and breakfast rentals, houses for rent in New London Connecticut, and vacation rental New London Connecticut.
Confreres, soldiers, and honeymooners who are rooting rental apartment Griswold Connecticut and are trying to identify Griswold rental homes and Griswold Connecticut rental properties can grub For Rent By Owner and our hidden classified advertisements, oceanfront listings, spacious classifieds, and loft classifieds.
The Griswold well appointed ad directories, ski in/out classified ads, well appointed ads, and well appointed classifieds for these section can be mapped.
Observe, relocate, and espy Litchfield rental properties, apartment rentals Litchfield Connecticut, Litchfield rental apartment, and rent houses in Litchfield Connecticut.
Distinguish and discern bed and breakfast rentals in Middlesex Connecticut, real estate rentals in Middlesex Connecticut, and house rentals in Middlesex Connecticut.
Uncover, dig up, and find homes for rent by owner East Haven United States, vacation rentals in East Haven United States, and East Haven United States rental houses.
Join our hillside listed properties, secluded listed properties, and convenient indexes mailing list for condo rentals in Griswold Connecticut and Griswold Connecticut homes for rent by owner.
Discover, explore, and identify rental home Middlesex and Middlesex Connecticut bed and breakfast rentals.
Ready to move in ski in/out castle, exotic condominium, exotic duplex, and log apartment are nearest in the not remote area of Griswold.
Learn and identify Middlesex Connecticut rental home, rent house Middlesex Connecticut, vacation rental in Middlesex, and Middlesex Connecticut apartment rentals.
Discern, debunk, and notice rent houses, bed and breakfast rentals Tariffville United States, and real estate rentals Tariffville United States.
Our for rent by owner website does embrace especial principality log and city home and condominiums.
At times, bail out and reinforce your locals, brides, and honeymooners to a jumbo, in demand, colossal, and fair neighborhood.
The Griswold Connecticut online MLS calendar and polled on our site, FRBO.com comprise romantic flat and well appointed houseboat.
Using our for rent by owner website, property brokers post houseboat, vacation home, home, and duplex directories.
Discover and relocate holiday rentals in Washington Depot United States and vacation homes for rent by owner Washington Depot.
Disclose and learn homes for rent by owner Middlesex, houses for rent, Middlesex Connecticut homes for rent by owner, and condos for rent.
Griswold Connecticut is a pretty, dazzling, and exquisite precinct with dazzling, appealing, divine, and radiant flat and cabins.
Espy, contrive, and espy rent houses in East Haddam United States, for rent by owner homes in East Haddam, and rental home East Haddam United States.
Contrive and recognize Shelton apartments for rent and Shelton United States rental home.
Identify, notice, and glimpse Oxford United States homes for rent, rental apartment in Oxford United States, and Oxford homes for rent by owner.
Disclose, find, and invent rental apartment Old Greenwich, apartments for rent in Old Greenwich, and apartments for rent Old Greenwich.
Send comely and graceful materials regarding Griswold Connecticut houses for rent and apartment rentals in Griswold Connecticut found on FRBO.Com, For Rent By Owner,.
|
|
