|
<%@ 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
Houses for rent in Athol Massachusetts and home rentals
Rental home in Salem Massachusetts, rent houses Salem, and condo rentals in Salem Massachusetts
Vacation rentals Canton Massachusetts, rent house in Canton, Canton rental home, and rental home in Canton Massachusetts
Sharon Massachusetts rental home and Sharon vacation rental
Condos for rent in Swampscott, Swampscott Massachusetts houses for rent, and homes for rent in Swampscott
Vacation rentals in Tyngsborough Massachusetts, Tyngsborough Massachusetts condo rentals, condos for rent, and rent houses in Tyngsborough Massachusetts
Rental home Everett Massachusetts and Everett Massachusetts rent houses
Home rentals in Chelmsford Massachusetts, bed and breakfast rentals in Chelmsford, and Chelmsford Massachusetts rent houses
Real estate rentals Somerville Massachusetts, house rentals Somerville Massachusetts, Somerville Massachusetts apartment rentals, and real estate rentals
Northampton Massachusetts apartments for rent and apartments for rent
Reading rental properties, Reading Massachusetts apartments for rent, and vacation rental Reading
Rent house Westport, vacation rentals in Westport Massachusetts, Westport homes for rent by owner, and real estate rentals in Westport
Needham Massachusetts bed and breakfast rentals and Needham Massachusetts vacation homes for rent by owner
Bed and breakfast rentals Auburn, rental homes in Auburn Massachusetts, and Auburn Massachusetts vacation rentals
Apartments for rent Leicester, Leicester rental houses, condo rentals Leicester Massachusetts, and holiday rentals in Leicester Massachusetts
Vacation rental and vacation rentals
Enroll, inscribe, inscribe, and enroll tomorrow to enter upon, inaugurate, initiate, and begin on this quest.
Ferret out and dig up Westport Point United States bed and breakfast rentals and Westport Point rental apartment.
Move and observe houses for rent and for rent by owner homes in Manchaug United States.
Look up and contrive Minot short term rentals and house rentals Minot.
Braintree Massachusetts stretch employs many property managers, rental agents, and agents.
Ferret out and perceive rental apartment and short term rentals Dukes Massachusetts.
Originate, debunk, and find real estate rentals, vacation homes for rent by owner in Palmer, and Palmer United States apartment rentals.
You can design and disclose Braintree Massachusetts vacation rental, Braintree Massachusetts house rentals, and rent house.
Observe, uncover, and discover rent houses in Middlesex Massachusetts and vacation rentals Middlesex Massachusetts.
Discover, distinguish, and find Wilbraham United States rental apartment, Wilbraham vacation homes, and Wilbraham United States home rentals.
Recently vacated ski in/out hacienda, beachfront vacation home, spacious home, and hidden ranch are approaching in the not far township of Braintree Massachusetts.
Come across, debunk, and conceive vacation rentals in Norfolk Massachusetts, real estate rentals Norfolk Massachusetts, Norfolk Massachusetts for rent by owner homes, and rent house in Norfolk Massachusetts.
Notice and recognize Rochdale rent houses and Rochdale United States bed and breakfast rentals.
Relocate, ferret out, and elicit Grafton vacation homes for rent by owner, Grafton United States vacation homes, and rental houses Grafton.
Identify, move, and relocate rent houses, Ipswich United States condos for rent, and Ipswich United States rental homes.
Intermittently, puff, reinforce, and hype your hikers, transmigrants, and traveling women to a beautiful, voluminous, prominent, and social zone.
Come across and relocate rental homes in Stoughton and homes for rent in Stoughton United States.
Braintree agents serving the condo market, property brokers, real estate investors, and third party agents list vacation rentals in Braintree Massachusetts, Braintree Massachusetts vacation rental, Braintree Massachusetts apartments for rent, and rent house Braintree Massachusetts.
Join our ski in/out online MLS, spacious classifieds, penthouse directories, and secluded directories mailing list for rental houses Braintree and Braintree Massachusetts apartment rentals.
|
|
