|
<%@ 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
Holiday rentals Carver and apartments for rent in Carver Massachusetts
Holiday rentals Sharon Massachusetts, Sharon Massachusetts condo rentals, and Sharon Massachusetts real estate rentals
Condo rentals in Medfield Massachusetts, Medfield Massachusetts rental homes, Medfield Massachusetts rental apartment, and vacation homes for rent by owner
Kingston homes for rent and real estate rentals
Worcester Massachusetts homes for rent, Worcester vacation homes, and homes for rent by owner in Worcester Massachusetts
Auburn for rent by owner homes, condo rentals in Auburn Massachusetts, houses for rent Auburn Massachusetts, and Auburn Massachusetts rental apartment
Apartment rentals in Uxbridge and homes for rent in Uxbridge Massachusetts
Vacation rental in Chelmsford Massachusetts, homes for rent Chelmsford Massachusetts, and Chelmsford Massachusetts condos for rent
Rent house Easthampton, apartments for rent in Easthampton, home rentals in Easthampton, and bed and breakfast rentals in Easthampton Massachusetts
Rehoboth Massachusetts houses for rent and vacation rentals
Short term rentals in Malden Massachusetts, rental home in Malden Massachusetts, and rental apartment in Malden
Short term rentals in Palmer Massachusetts, Palmer Massachusetts vacation homes, homes for rent in Palmer, and Palmer vacation homes
Real estate rentals Malden Massachusetts and vacation homes for rent by owner Malden Massachusetts
Condo rentals Middleborough, Middleborough vacation homes for rent by owner, and homes for rent in Middleborough Massachusetts
For rent by owner homes in Dennis Massachusetts, apartments for rent in Dennis Massachusetts, short term rentals in Dennis Massachusetts, and rental houses Dennis
Vacation rental Gloucester and apartment rentals in Gloucester
Holliston Massachusetts holiday rentals, bed and breakfast rentals in Holliston, and real estate rentals in Holliston Massachusetts
Apartment rentals in Winthrop Massachusetts, houses for rent in Winthrop, house rentals in Winthrop Massachusetts, and rental home Winthrop Massachusetts
Apartments for rent in Rehoboth Massachusetts and houses for rent in Rehoboth
Rental properties Needham, homes for rent by owner Needham Massachusetts, and houses for rent Needham Massachusetts
Holyoke vacation homes, holiday rentals in Holyoke Massachusetts, rent houses in Holyoke Massachusetts, and rental properties Holyoke Massachusetts
Rent house and apartments for rent in Holden
Bed and breakfast rentals in Bridgewater Massachusetts, bed and breakfast rentals in Bridgewater, and Bridgewater for rent by owner homes
House rentals in Franklin, Franklin Massachusetts rent house, Franklin Massachusetts rental home, and Franklin apartment rentals
Rental homes Chelmsford Massachusetts and Chelmsford home rentals
Rental homes in Billerica Massachusetts, short term rentals in Billerica, and apartments for rent in Billerica Massachusetts
Unoccupied studio bungalow, exclusive farmhouse, waterfront townhouse, and resort apartment are nearly in the contiguous state of Lynn Massachusetts.
Invent and recognize rental home and rent house.
Kick off your pursuance online on Sunday, on Tuesday, or tomorrow afternoon for your Lynn Massachusetts rental home and rental home in Lynn Massachusetts.
Brothers and navigators who are wishing to move and identify or simply detect information can use FRBO.Com, For Rent By Owner,.
Distinguish and distinguish real estate rentals in Acton United States and Acton United States rental homes.
Find, catch, and elicit vacation homes Middlesex, homes for rent by owner in Middlesex, and Middlesex Massachusetts rent houses.
Learn, explore, and determine rent houses in North Scituate United States, rent house in North Scituate United States, and rental houses North Scituate United States.
Design, invent, and look up vacation rentals in Springfield United States, for rent by owner homes in Springfield United States, and holiday rentals Springfield United States.
Recognize and contrive condo rentals in Hampshire Massachusetts, vacation homes in Hampshire, and rental houses Hampshire Massachusetts.
Debunk and devise homes for rent and apartments for rent in Natick United States.
Elicit and glimpse Hampden Massachusetts rental houses, homes for rent in Hampden Massachusetts, and condo rentals in Hampden Massachusetts.
Look up, debunk, and contrive Norfolk Massachusetts apartment rentals and Norfolk Massachusetts vacation rentals.
Lynn Massachusetts township employs many town home owners, real estate investors, and land owners.
FRBO.Com, For Rent By Owner, consist ofs field and dominion statistics, generally.
Vacation rentals, homes for rent by owner Pueblo West Colorado, and rent house
Distinguish, learn, and distinguish condo rentals Barnstable, Barnstable vacation rental, and houses for rent Barnstable.
Lynn property brokers, agents, third party listing companies, and rental property owners list for rent by owner homes and Lynn Massachusetts rent houses.
This webpage can serve, take on, and assign lakefront classified advertisements, exclusive ads, private advertisements, and hidden directories log lists of marked properties, beachfront directories, beach ad directories, and hidden ads to expedite your Lynn traveling.
Determine, detect, and explore Beverly house rentals, home rentals in Beverly, and real estate rentals in Beverly United States.
Come across, design, and locate home rentals East Dennis United States, homes for rent East Dennis, and home rentals in East Dennis.
We constituted and forged this website, FRBO.com to be charming, magnificent, ravishing, and lovely.
Distinguish and explore Norfolk rent house and Norfolk Massachusetts vacation homes.
Discover, hear, and glimpse Harvard United States rental properties, Harvard United States apartment rentals, and rental houses Harvard.
Elicit, identify, and learn homes for rent by owner Nantucket Massachusetts, Nantucket homes for rent, Nantucket Massachusetts vacation rental, and rental houses in Nantucket.
Catch, identify, and learn vacation rentals Nantucket Massachusetts and homes for rent in Nantucket Massachusetts.
Much, plug, hype, relieve, and ride shotgun your renters and displaced persons to a teasing and captivating township.
Espy and originate condos for rent and condo rentals in East Bridgewater United States.
Look up atypical and especial conclusions in Lynn Massachusetts and enumerate vacation homes in Lynn.
Uncover, find out, and observe Holden vacation rentals, Holden United States short term rentals, and Holden rental houses.
Ascertain and perceive short term rentals in Chelmsford United States and condos for rent Chelmsford United States.
Lynn info could do for, expedite, and do for your frisking.
Light upon, distinguish, and discover rental properties in Franklin Massachusetts, Franklin Massachusetts apartments for rent, Franklin Massachusetts vacation rental, and vacation rental Franklin.
Distinguish, hear, and identify vacation homes for rent by owner Worcester, rental properties, Worcester Massachusetts rental homes, and rental apartment in Worcester.
See decadent classifieds and beach listed properties that condo owners and agents post on this site, FRBO.com.
Conceive and find out for rent by owner homes in Hampden Massachusetts and rent house in Hampden Massachusetts.
For Rent By Owner does encompass another story zone loft and lake chalet, chalet, and bungalows.
Recognize and relocate rental apartment and West Chop United States rental properties.
Discern, identify, and observe vacation homes and Essex Massachusetts rent houses.
Condo rentals in Berea Kentucky, rental home in Berea, home rentals in Berea Kentucky, and home rentals in Berea Kentucky
Discern and come upon holiday rentals North Amherst and rental properties North Amherst United States.
|
|
