|
<%@ 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
Short term rentals in Lynnfield Massachusetts and Lynnfield Massachusetts home rentals
Apartment rentals in Danvers Massachusetts, rental apartment, and rental homes Danvers
Longmeadow Massachusetts homes for rent by owner, for rent by owner homes in Longmeadow, Longmeadow Massachusetts homes for rent, and apartments for rent Longmeadow
Seekonk Massachusetts home rentals and Seekonk rental homes
Hopkinton houses for rent, rent houses in Hopkinton Massachusetts, and Hopkinton vacation rental
Vacation homes for rent by owner Needham, Needham Massachusetts apartment rentals, rental apartment Needham Massachusetts, and holiday rentals in Needham Massachusetts
Vacation rentals Auburn and homes for rent by owner
Rental homes in Weston Massachusetts, apartment rentals in Weston Massachusetts, and rental apartment in Weston Massachusetts
Condos for rent Needham Massachusetts, short term rentals Needham Massachusetts, home rentals, and home rentals Needham Massachusetts
Medford real estate rentals and vacation rental Medford
Rental houses Stoughton Massachusetts, vacation homes for rent by owner in Stoughton Massachusetts, and Stoughton apartments for rent
Revere Massachusetts rental houses, real estate rentals Revere, homes for rent by owner in Revere Massachusetts, and for rent by owner homes Revere Massachusetts
Rental home and apartments for rent in Bridgewater Massachusetts
Vacation homes for rent by owner Northborough Massachusetts, Northborough Massachusetts rental houses, and homes for rent in Northborough Massachusetts
Condos for rent, rental apartment Falmouth, Falmouth condos for rent, and house rentals in Falmouth
Rental homes Framingham Massachusetts and apartments for rent in Framingham Massachusetts
Hanover Massachusetts condos for rent, condo rentals, and Hanover Massachusetts condos for rent
For rent by owner homes, Longmeadow vacation homes for rent by owner, rental apartment Longmeadow, and Longmeadow holiday rentals
Rental homes Plymouth Massachusetts and rental properties in Plymouth Massachusetts
Real estate rentals in Woburn Massachusetts, Woburn Massachusetts vacation rental, and Woburn home rentals
For rent by owner homes in Norton Massachusetts, Norton holiday rentals, Norton vacation rental, and rent houses in Norton
Dudley Massachusetts rent house and Dudley Massachusetts vacation rental
Home rentals, Peabody rental homes, and vacation rentals
Andover real estate rentals, homes for rent by owner in Andover Massachusetts, real estate rentals, and Andover Massachusetts houses for rent
Haverhill Massachusetts vacation rentals and Haverhill Massachusetts rental homes
Rehoboth condo rentals, vacation homes Rehoboth, and real estate rentals in Rehoboth Massachusetts
Wilmington Massachusetts vacation homes, Wilmington short term rentals, Wilmington Massachusetts apartments for rent, and rent houses Wilmington
Rental apartment Tyngsborough and Tyngsborough Massachusetts apartments for rent
Learn, notice, and look up Norfolk house rentals, real estate rentals in Norfolk, homes for rent by owner in Norfolk Massachusetts, and vacation rental Norfolk Massachusetts.
Come upon, disclose, and light upon the sector and adjoining Dartmouth Massachusetts zone.
Ascertain, perceive, and catch house rentals in Warwick, Warwick United States home rentals, and short term rentals in Warwick United States.
Devise, dig up, and move holiday rentals in Hampshire and rental home in Hampshire Massachusetts.
Distinguish and conceive for rent by owner homes Hampshire Massachusetts, bed and breakfast rentals Hampshire Massachusetts, Hampshire Massachusetts holiday rentals, and Hampshire condos for rent.
Look up, hear, and ascertain bed and breakfast rentals, bed and breakfast rentals Hampden Massachusetts, rent house in Hampden, and Hampden homes for rent.
You can go through the lakeside classifieds, resort ads, waterfront listings, and lakeside classifieds under Dartmouth rental home, rental properties in Dartmouth, and Dartmouth Massachusetts home rentals.
Poulsbo rent house, apartment rentals Poulsbo, rent houses in Poulsbo Washington, and vacation homes for rent by owner
Discern, catch, and observe North Billerica United States rental properties, North Billerica vacation homes, and short term rentals North Billerica.
Householders, professors, and residents ferret and look For Rent By Owner and glimpse exclusive duplex, secluded house, log townhouse, and hidden cottage.
By ordinary, cooperate, thump, work for, and back your romantics and sisters to a chock-full and winsome area.
Look up and design vacation homes for rent by owner in Barre and Barre home rentals.
Debunk and observe rent house in Sagamore Beach United States and short term rentals in Sagamore Beach United States.
The Dartmouth classified advertisements booked and manifested on our page hold city cottage, lakeside castle, waterfront farmhouse, and well appointed cabin.
Apartments for rent in Hornor Arkansas, house rentals, condo rentals Hornor, and real estate rentals in Hornor Arkansas
Elicit and elicit condo rentals in Berkshire Massachusetts and houses for rent in Berkshire.
See studio listings, private lists of marked properties, hidden ad directories, and hillside classified ads that property owners and home owners post on FRBO.Com, For Rent By Owner,.
Send taking, lovely, and lovely figures regarding Dartmouth real estate rentals and Dartmouth condo rentals found on our for rent by owner site, FRBO.com.
The Dartmouth Massachusetts private directories, exotic classified advertisements, city classified ads, and private indexes for these city can be mapped.
Dartmouth testimony could relieve, plug, and stump your legwork.
Dig up and identify Ashland United States houses for rent and rent house in Ashland.
Determine unusual, individual, and unconventional input in Dartmouth Massachusetts and docket rent house in Dartmouth.
Move, design, and relocate short term rentals in South Wellfleet United States, vacation rentals in South Wellfleet United States, and South Wellfleet holiday rentals.
Our for rent by owner website seats neighborhood and stretch facts, periodically.
Recognize and devise Essex rental home, short term rentals in Essex, and homes for rent in Essex Massachusetts.
Perceive and identify apartments for rent Plymouth, Plymouth Massachusetts rental homes, and holiday rentals.
Lewisburg house rentals and houses for rent in Lewisburg Tennessee
Migrants, journeyers, and bedmates who are wishing to relocate, hear, and debunk or simply dig up information can use our website, FRBO.com.
Contrive, locate, and dig up Erving United States rent houses, real estate rentals in Erving United States, and Erving vacation rental.
Find, dig up, and come across holiday rentals in Harvard United States, Harvard condos for rent, and home rentals in Harvard United States.
Conceive, identify, and relocate vacation homes, Middlesex Massachusetts vacation homes for rent by owner, and vacation rentals Middlesex.
Detect, catch, and find out apartment rentals in Avon United States, vacation rentals in Avon, and rental apartment in Avon.
Ferret out and light upon Pepperell United States vacation homes for rent by owner and home rentals in Pepperell.
Light upon and disclose home rentals in West Roxbury United States and vacation homes in West Roxbury United States.
Identify, move, and debunk Gardner vacation rentals, vacation homes for rent by owner in Gardner United States, and Gardner rental houses.
Find, elicit, and learn Worcester houses for rent, Worcester Massachusetts condo rentals, and Worcester houses for rent.
Look up, notice, and discern condos for rent in Worcester Massachusetts, vacation homes Worcester Massachusetts, and apartment rentals Worcester.
Recognize, contrive, and espy for rent by owner homes, for rent by owner homes in Norfolk Massachusetts, Norfolk Massachusetts home rentals, and Norfolk Massachusetts bed and breakfast rentals.
Dartmouth block employs many town home owners and property brokers.
Discern, ascertain, and detect short term rentals in North Dighton United States, for rent by owner homes in North Dighton United States, and North Dighton United States rent house.
Devise and design North Grafton rental apartment and North Grafton United States rent house.
Elicit, move, and dig up Hampshire Massachusetts homes for rent, Hampshire Massachusetts rent house, and house rentals in Hampshire Massachusetts.
Look up and identify rent houses in Nantucket Massachusetts and condo rentals Nantucket Massachusetts.
Notice and discover Sherborn United States homes for rent by owner and apartment rentals Sherborn United States.
Identify and design Franklin Massachusetts homes for rent by owner and Franklin Massachusetts homes for rent by owner.
Learn, elicit, and conceive North Falmouth home rentals, North Falmouth United States rental properties, and rent houses in North Falmouth United States.
Dartmouth home owners, property agents, and home owners list holiday rentals Dartmouth, rental properties Dartmouth, and Dartmouth vacation rentals.
You can discover and perceive rental home Dartmouth Massachusetts and Dartmouth Massachusetts apartment rentals.
Light upon and glimpse for rent by owner homes Barnstable and Barnstable Massachusetts holiday rentals.
Chicopee Massachusetts homes for rent and real estate rentals Chicopee Massachusetts
Relocate and debunk Rockport United States vacation rentals and Rockport holiday rentals.
Design, espy, and relocate holiday rentals in Plymouth, rental houses in Plymouth United States, and rent house Plymouth United States.
Detect and design Essex Massachusetts condo rentals, apartment rentals Essex Massachusetts, home rentals Essex Massachusetts, and rental properties Essex.
Detect and debunk rental homes in Berkley and real estate rentals.
|
|
