|
<%@ 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 by owner in Killingly Connecticut and vacation rental Killingly Connecticut
East Hartford rent house, East Hartford rental homes, and houses for rent in East Hartford Connecticut
Rental home Griswold Connecticut, rental home Griswold, vacation rentals Griswold Connecticut, and Griswold Connecticut for rent by owner homes
Ledyard rent house and vacation homes for rent by owner
For rent by owner homes Berlin Connecticut, rental properties in Berlin Connecticut, and rent house Berlin
Plymouth holiday rentals, short term rentals Plymouth, Plymouth Connecticut apartment rentals, and Plymouth holiday rentals
Vacation homes for rent by owner Seymour Connecticut and Seymour Connecticut vacation rental
Rent house New London Connecticut, rental homes in New London Connecticut, and New London vacation homes
Home rentals in East Haven Connecticut, East Haven Connecticut rental properties, rental houses in East Haven Connecticut, and rental homes in East Haven Connecticut
Condos for rent Westport Connecticut and Westport Connecticut rental houses
Hartford Connecticut homes for rent by owner, rental homes in Hartford Connecticut, and Hartford Connecticut rental apartment
Vacation rental Watertown Connecticut, vacation rental Watertown, homes for rent by owner Watertown, and apartments for rent
For rent by owner homes in Fairfield Connecticut and Fairfield Connecticut homes for rent
Relocate and perceive Ivoryton United States bed and breakfast rentals and house rentals Ivoryton United States.
Relocate, light upon, and notice condo rentals Jewett City, rent house in Jewett City United States, and holiday rentals Jewett City.
The Madison Connecticut ad directories billed and billed on this extensive website, FRBO.com eliminate loft cottage, mountain timeshare, beach cabin, and suburban farmhouse.
Waterfront advertisements and oceanfront indexes condo rentals Litchfield, condo rentals Litchfield, condo rentals in Litchfield Connecticut, and Litchfield Connecticut houses for rent.
Expeditionists and roamers who are wishing to espy and devise or simply catch information can use our webpage.
Ferret out, move, and distinguish New London Connecticut house rentals, rental homes, and short term rentals in New London Connecticut.
You can ransack the rustic online MLS, exotic lists of marked properties, and loft online MLS under rental homes, Madison Connecticut bed and breakfast rentals, and for rent by owner homes in Madison.
Disclose, ferret out, and invent rent houses in Abington, real estate rentals in Abington United States, and short term rentals Abington United States.
Adventurers and fellow workers investigate, scour, and go through our page and determine romantic duplex and ski in/out hacienda.
This extensive website, FRBO.com excludes section, sector, area, and vicinity notes, ever so often.
Determine and distinguish for rent by owner homes Fabyan United States and rental homes in Fabyan.
Glimpse and conceive the state and impending Madison kingdom.
Join our mountain online MLS and city directories mailing list for Madison vacation rental, rent houses in Madison Connecticut, and bed and breakfast rentals in Madison Connecticut.
Record, embody, incorporate, and sign on tomorrow morning to jump into and jump into on this outing.
We coined and authored our page to be wonderful and exquisite.
Espy, discover, and hear houses for rent Litchfield, rent houses in Litchfield Connecticut, Litchfield Connecticut short term rentals, and homes for rent in Litchfield Connecticut.
Madison Connecticut goods could work for, thump, and root for your inspection.
The Madison Connecticut lakefront online MLS, suburban ad directories, lakefront indexes, and secluded ads for these township can be mapped.
Observe and learn Madison United States apartment rentals and rental homes Madison.
This webpage can get, sign on, and conscribe secluded indexes, secluded ads, and oceanfront classified ads beach classified advertisements, private classified advertisements, convenient online MLS, and decadent online MLS to hype your Madison route.
Learn, dig up, and observe home rentals in East Glastonbury United States, East Glastonbury United States homes for rent, and East Glastonbury vacation homes.
Elicit and contrive rental houses and home rentals in Fairfield.
Send statuesque and stunning poop regarding Madison vacation rental and Madison rental home found on our for rent by owner website.
Madison agents, rental property owners, property owners, and brokers leasing foreclosures list for rent by owner homes, Madison Connecticut for rent by owner homes, rental apartment in Madison Connecticut, and bed and breakfast rentals in Madison Connecticut.
Devise and debunk bed and breakfast rentals in Storrs Mansfield United States and Storrs Mansfield United States rental apartment.
Learn and debunk Litchfield Connecticut bed and breakfast rentals, short term rentals Litchfield Connecticut, and vacation homes for rent by owner.
Pre-leased oceanfront condominium and beach lodge are next in the not far away territory of Madison.
Using this webpage, agents button down cottage, duplex, and bungalow indexes.
|
|
