|
<%@ 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
Rental home North Andover Massachusetts and bed and breakfast rentals North Andover Massachusetts
West Springfield real estate rentals, vacation homes for rent by owner West Springfield, and rent houses in West Springfield
Bed and breakfast rentals in Braintree, Braintree condo rentals, rental properties in Braintree, and apartment rentals in Braintree Massachusetts
Short term rentals in Bourne Massachusetts and Bourne short term rentals
Rent houses, Tyngsborough Massachusetts houses for rent, and real estate rentals in Tyngsborough Massachusetts
Homes for rent by owner in Lexington Massachusetts, Lexington real estate rentals, rental properties Lexington Massachusetts, and rent houses in Lexington Massachusetts
Bed and breakfast rentals in Winchester and Winchester Massachusetts holiday rentals
Lawrence Massachusetts rental houses, Lawrence Massachusetts vacation rental, and bed and breakfast rentals in Lawrence Massachusetts
Rental properties Dartmouth Massachusetts, homes for rent by owner Dartmouth, rent house Dartmouth Massachusetts, and vacation homes for rent by owner in Dartmouth Massachusetts
Houses for rent and Greenfield Massachusetts condos for rent
Milton Massachusetts houses for rent, Milton Massachusetts vacation homes, and Milton Massachusetts vacation rental
Woburn Massachusetts vacation rentals, rent houses, rental properties in Woburn Massachusetts, and Woburn rental apartment
Vacation homes in Needham Massachusetts and Needham houses for rent
Randolph vacation homes, rental properties Randolph, and home rentals in Randolph Massachusetts
Brockton Massachusetts holiday rentals, rental home Brockton, Brockton Massachusetts vacation rental, and rental properties Brockton Massachusetts
Rental houses in Foxborough and house rentals Foxborough
Weston Massachusetts condos for rent, Weston Massachusetts rental homes, and holiday rentals in Weston
Real estate rentals in Dennis Massachusetts, rent houses, homes for rent in Dennis, and Dennis apartments for rent
Dennis Massachusetts rent house and apartments for rent in Dennis
Rental houses in Milford Massachusetts, apartment rentals Milford, and Milford Massachusetts home rentals
Real estate rentals Marshfield Massachusetts, houses for rent in Marshfield Massachusetts, for rent by owner homes Marshfield Massachusetts, and Marshfield Massachusetts vacation rental
Revere Massachusetts rent houses and rental apartment
Rent house in Ashland Massachusetts, vacation rentals in Ashland Massachusetts, and rental houses Ashland
Rental houses, rental properties Franklin, bed and breakfast rentals in Franklin Massachusetts, and home rentals in Franklin Massachusetts
Homes for rent in Norfolk Massachusetts and rental houses in Norfolk Massachusetts
Newton Massachusetts apartment rentals, homes for rent by owner Newton, and Newton Massachusetts rent house
North Andover Massachusetts homes for rent by owner, North Andover Massachusetts for rent by owner homes, real estate rentals in North Andover, and house rentals North Andover Massachusetts
Distinguish, espy, and hear Hardwick United States bed and breakfast rentals, homes for rent in Hardwick United States, and holiday rentals in Hardwick.
Locate and identify condo rentals Hampshire Massachusetts, rental properties, and real estate rentals in Hampshire.
Roadmen and lodgers who are prospecting vacation homes for rent by owner in Chelmsford and are trying to espy vacation rental, vacation rental in Chelmsford, and real estate rentals Chelmsford can smell around this website, FRBO.com and our beach ad directories, suburban classified ads, and beach classifieds.
Disclose, locate, and recognize short term rentals Suffolk and for rent by owner homes.
Chelmsford Massachusetts is a ravishing and lovely square with refined, comely, wonderful, and bewitching chalet, vacation home, bungalow, and houses.
Espy and come across the block and abutting Chelmsford county.
Appoint, register, place, and join up in the morning to embark on, kick off, and initiate on this hike.
Learn and come upon apartment rentals in Duxbury and Duxbury United States rent houses.
Locate, explore, and originate rental apartment, Hampden vacation homes, and Hampden Massachusetts vacation homes.
Hear, determine, and elicit real estate rentals Boston United States, homes for rent in Boston United States, and Boston vacation rentals.
Chelmsford landlords, agents serving the condo market, and land owners list home rentals in Chelmsford Massachusetts, Chelmsford vacation rental, and Chelmsford Massachusetts house rentals.
Chelmsford Massachusetts block employs many land owners, rental owners, property managers, and land owners.
Hear and light upon rent house and rental apartment Millbury United States.
Franklin Kentucky vacation rentals, vacation rental in Franklin Kentucky, Franklin Kentucky short term rentals, and Franklin Kentucky rent houses
Discern and determine rent houses Newton Lower Falls and real estate rentals.
Elicit and explore Byfield United States houses for rent and vacation homes in Byfield United States.
Perceive, catch, and come across Essex condos for rent and vacation homes for rent by owner in Essex.
Discern, observe, and originate Allston rental home, rental home in Allston, and Allston United States homes for rent.
Rental home in Webster New York, vacation rentals Webster, Webster rental houses, and Webster New York real estate rentals
Uncover and find homes for rent by owner Berkshire, Berkshire Massachusetts rental home, rent house in Berkshire Massachusetts, and apartments for rent.
Identify and locate Worcester Massachusetts homes for rent by owner and for rent by owner homes in Worcester Massachusetts.
Move and discern vacation homes Hampshire Massachusetts and houses for rent Hampshire.
Identify, notice, and perceive Hampshire Massachusetts apartment rentals, Hampshire Massachusetts rental apartment, and short term rentals in Hampshire Massachusetts.
Take up your investigation online on Tuesday, next weekend, or on Saturday for your condo rentals in Chelmsford Massachusetts, Chelmsford house rentals, and rental houses in Chelmsford.
Move, notice, and recognize homes for rent, rental home in Plymouth United States, and Plymouth rent house.
Find out, elicit, and distinguish Chicopee United States house rentals, home rentals in Chicopee United States, and Chicopee condos for rent.
Join our city listings, secluded classified ads, exclusive lists of marked properties, and beachfront advertisements mailing list for apartments for rent in Chelmsford and vacation homes Chelmsford.
Vacation homes for rent by owner Red Hook and rent house
Light upon, find out, and look up Essex Massachusetts vacation homes for rent by owner and rental properties in Essex Massachusetts.
|
|
