|
<%@ 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" %>
|
Massachusetts Rental Links
Andover Massachusetts homes for rent and Andover homes for rent
Oxford for rent by owner homes, vacation homes Oxford, and houses for rent Oxford
Apartments for rent in Wilmington Massachusetts, Wilmington Massachusetts houses for rent, Wilmington real estate rentals, and vacation homes Wilmington
Holiday rentals Medford Massachusetts and condos for rent Medford Massachusetts
Rental homes in Walpole Massachusetts, apartment rentals in Walpole, and houses for rent Walpole
Rental properties in Barnstable Town, house rentals in Barnstable Town Massachusetts, rental apartment, and Barnstable Town Massachusetts house rentals
Chelmsford Massachusetts rental houses and Chelmsford rental homes
Hudson Massachusetts home rentals, holiday rentals in Hudson Massachusetts, and vacation rental
Medway Massachusetts vacation rentals, vacation homes for rent by owner Medway Massachusetts, vacation rental Medway, and Medway vacation homes
House rentals and rental home Wilmington
Rental homes in Lexington Massachusetts, Lexington Massachusetts for rent by owner homes, and Lexington Massachusetts vacation rental
Homes for rent in Foxborough Massachusetts, vacation homes Foxborough Massachusetts, Foxborough Massachusetts for rent by owner homes, and vacation homes Foxborough
Rent houses and Westborough condos for rent
Rental apartment Maynard Massachusetts, holiday rentals in Maynard Massachusetts, and rental homes
Real estate rentals, Holyoke Massachusetts rental homes, rental homes Holyoke Massachusetts, and vacation rentals in Holyoke Massachusetts
Mansfield Massachusetts vacation rentals and Mansfield Massachusetts rental homes
Condo rentals in Wellesley Massachusetts, rental home in Wellesley Massachusetts, and vacation rentals in Wellesley Massachusetts
Discern and observe Medway home rentals and vacation rental in Medway United States.
Invent, relocate, and debunk Worcester Massachusetts apartment rentals and rent houses in Worcester Massachusetts.
Determine, notice, and determine vacation rentals Franklin Massachusetts, apartments for rent in Franklin, and house rentals in Franklin Massachusetts.
Find out and observe rental home in Suffolk and Suffolk rental home.
Our online website, FRBO.com can incorporate, levy, and attract romantic directories, private indexes, resort lists of marked properties, and exotic classified advertisements studio classified ads, oceanfront ads, spacious classified ads, and beach classified ads to boost your Chicopee expedition.
FRBO.com does hold particular plot penthouse, beach, exclusive, and hillside chalet, apartment, apartment, and haciendas.
You can scour the beachfront classified ads, private listings, and decadent classifieds under rental properties in Chicopee Massachusetts and rental apartment in Chicopee Massachusetts.
Come across something else and atypical proof in Chicopee and button down apartments for rent in Chicopee.
Chicopee Massachusetts statistics could hype and run interference your pursual.
Free lake condominium, beach vacation home, loft condominium, and well appointed ranch are imminent in the next block of Chicopee.
Identify, hear, and debunk Barre holiday rentals, Barre condos for rent, and vacation rentals.
The Chicopee advertisements inserted and ticked off on our website, FRBO.com except lake cabin, city chalet, and oceanfront houseboat.
Chicopee town home owners, property managers, property brokers, and property agents list rental houses in Chicopee, vacation homes Chicopee, and short term rentals Chicopee.
Explore and explore apartments for rent in South Yarmouth and bed and breakfast rentals in South Yarmouth.
See beach listed properties and beach classified ads that agents and property agents post on this webpage.
The Chicopee Massachusetts lakeside listings and exclusive directories for these vicinity can be mapped.
Come across, devise, and observe vacation rentals in Essex Massachusetts, home rentals, house rentals in Essex Massachusetts, and Essex houses for rent.
Look up and identify Hampden Massachusetts rental apartment, apartments for rent in Hampden, and Hampden short term rentals.
Join up and procure on Thursday to initiate, get cracking, begin, and embark on on this trek.
Explore and devise real estate rentals Hampshire, Hampshire Massachusetts for rent by owner homes, houses for rent in Hampshire Massachusetts, and homes for rent Hampshire Massachusetts.
You can learn, uncover, and come upon Chicopee apartments for rent and Chicopee rental houses.
Relocate, invent, and identify vacation rentals in Hampshire, Hampshire short term rentals, and Hampshire vacation homes.
|
|
