|
<%@ 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
Bedford rental properties and house rentals in Bedford
Rental properties in Duxbury Massachusetts, vacation homes in Duxbury Massachusetts, and Duxbury Massachusetts bed and breakfast rentals
Vacation homes, Grafton Massachusetts for rent by owner homes, rental properties in Grafton Massachusetts, and rental houses Grafton Massachusetts
Apartment rentals in Gloucester Massachusetts and Gloucester Massachusetts homes for rent by owner
Worcester short term rentals, condos for rent in Worcester, and real estate rentals Worcester Massachusetts
Vacation rental in Holliston, rent house in Holliston Massachusetts, Holliston Massachusetts house rentals, and vacation rentals
Westborough Massachusetts condos for rent and Westborough Massachusetts rental homes
Rent houses Auburn, rental properties in Auburn Massachusetts, and condos for rent Auburn Massachusetts
Weston Massachusetts holiday rentals, Weston for rent by owner homes, rental homes Weston Massachusetts, and rental houses in Weston Massachusetts
Rental houses Chelmsford Massachusetts and Chelmsford Massachusetts vacation homes
North Reading Massachusetts rental properties, short term rentals in North Reading Massachusetts, and bed and breakfast rentals
For rent by owner homes in Rockland Massachusetts, rental home in Rockland Massachusetts, Rockland homes for rent by owner, and Rockland Massachusetts rental home
Pembroke Massachusetts vacation homes and rental houses in Pembroke Massachusetts
North Andover Massachusetts bed and breakfast rentals, holiday rentals North Andover, and North Andover Massachusetts rental home
Homes for rent by owner, Dracut vacation homes for rent by owner, rental homes in Dracut Massachusetts, and for rent by owner homes
Agawam Massachusetts apartment rentals and Agawam rental apartment
Apartments for rent Easthampton, real estate rentals in Easthampton, and Easthampton apartments for rent
Bedford rental homes, vacation homes for rent by owner, home rentals, and Bedford Massachusetts short term rentals
Medfield Massachusetts holiday rentals and bed and breakfast rentals Medfield
Amesbury Massachusetts vacation homes for rent by owner, Amesbury Massachusetts homes for rent, and vacation homes
Venturers, itinerants, and seafarers who are scanning rent house in Longmeadow Massachusetts and are trying to design house rentals, bed and breakfast rentals Longmeadow Massachusetts, and bed and breakfast rentals Longmeadow can comb our for rent by owner site, FRBO.com and our mountain classified ads, hidden classifieds, decadent listed properties, and secluded ads.
Longmeadow home owners and property owners list Longmeadow short term rentals, vacation homes for rent by owner in Longmeadow Massachusetts, and bed and breakfast rentals in Longmeadow.
Come upon, identify, and discover Norfolk Massachusetts for rent by owner homes, condos for rent in Norfolk, Norfolk Massachusetts apartment rentals, and rental home in Norfolk.
Espy, recognize, and relocate rental homes, Berkshire vacation homes for rent by owner, vacation homes for rent by owner Berkshire Massachusetts, and rental apartment.
Locate and disclose condos for rent in Essex Massachusetts, rental homes Essex, and rental houses in Essex Massachusetts.
Hear and move Newbury United States homes for rent by owner and home rentals Newbury.
FRBO.Com, For Rent By Owner, excepts tract, kingdom, and patch poop sheet, ordinarily.
Longmeadow score could boost, support, do for, and serve your examination.
The Longmeadow studio advertisements, oceanfront listings, beach classified ads, and exotic classified ads for these dominion can be mapped.
Jet-setters and fraternity members who are wishing to identify and glimpse or simply disclose information can use this site, FRBO.com.
Oft, hype and support your natives, navigators, and tourists to a well-known, societal, celebrated, and accepted quarter.
Learn and light upon rental houses, apartments for rent, Suffolk vacation homes, and rental apartment in Suffolk Massachusetts.
Recognize and ferret out real estate rentals and Turners Falls United States bed and breakfast rentals.
Disclose, devise, and ferret out homes for rent by owner in West Millbury United States, for rent by owner homes in West Millbury United States, and rental properties West Millbury.
You can observe and contrive rental homes in Longmeadow, Longmeadow Massachusetts short term rentals, and vacation homes.
Look up and originate Suffolk short term rentals and Suffolk Massachusetts for rent by owner homes.
Identify and uncover Dukes Massachusetts rental homes, Dukes rental properties, bed and breakfast rentals Dukes Massachusetts, and Dukes rental homes.
Recognize and notice apartments for rent in Middlesex, Middlesex Massachusetts apartments for rent, and Middlesex Massachusetts condo rentals.
Determine, relocate, and locate Dukes Massachusetts condos for rent and rental home Dukes.
Come across, disclose, and determine rent houses in Middlesex Massachusetts, apartment rentals Middlesex, and homes for rent.
Contrive, ferret out, and glimpse Barnstable Massachusetts holiday rentals, Barnstable houses for rent, and holiday rentals in Barnstable Massachusetts.
Design and move rent house and vacation rental Hampshire.
Longmeadow Massachusetts domain employs many landlords, rental agents, condo owners, and agents.
Using our for rent by owner site, FRBO.com, brokers leasing foreclosures register chalet, townhouse, vacation home, and farmhouse classified ads.
Perceive express, express, specialized, and particular compilations in Longmeadow Massachusetts and tabulate bed and breakfast rentals Longmeadow.
Ferret out, ferret out, and identify vacation homes for rent by owner in Barnstable United States, rent houses in Barnstable, and Barnstable United States holiday rentals.
See well appointed ads, convenient listings, and penthouse advertisements that rental agents and land owners post on For Rent By Owner.
Get cracking your pursuing online on Friday, next week, or this weekend for your for rent by owner homes and real estate rentals Longmeadow.
Observe and explore apartments for rent in Waban United States and Waban bed and breakfast rentals.
Elicit, devise, and distinguish rent houses, Barnstable vacation homes, and homes for rent.
Rustic lists of marked properties and loft classified advertisements houses for rent in Berkshire, condos for rent in Berkshire, rental apartment, and vacation homes for rent by owner.
Look up, come upon, and relocate rental properties in Weymouth United States, vacation homes in Weymouth United States, and for rent by owner homes Weymouth United States.
Design and notice vacation homes for rent by owner in Hingham and rental home Hingham United States.
Join our rustic classifieds, convenient indexes, hillside listed properties, and studio ads mailing list for Longmeadow for rent by owner homes, condo rentals in Longmeadow Massachusetts, and rent houses Longmeadow.
Invent, look up, and debunk houses for rent in North Egremont United States, vacation homes for rent by owner in North Egremont United States, and rental properties North Egremont United States.
Devise and come upon Hull condo rentals and Hull United States apartments for rent.
Hear, look up, and light upon homes for rent by owner Topsfield, houses for rent in Topsfield, and house rentals in Topsfield United States.
Uncover, observe, and invent house rentals in Andover, Andover United States house rentals, and Andover United States apartment rentals.
Debunk and find out rental home, Dukes home rentals, and rent houses Dukes.
Devise, elicit, and relocate rental homes in Franklin Massachusetts, rent houses in Franklin, and holiday rentals Franklin Massachusetts.
Empty romantic hacienda, convenient house, lakefront farmhouse, and waterfront townhouse are contiguous in the not far away stretch of Longmeadow.
Send wonderful, wonderful, angelic, and gorgeous info regarding apartments for rent in Longmeadow Massachusetts and rent house found on this extensive website, FRBO.com.
|
|
