|
<%@ 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
Fitchburg homes for rent and holiday rentals
Houses for rent in Falmouth Massachusetts, Falmouth Massachusetts for rent by owner homes, and apartment rentals in Falmouth Massachusetts
Bed and breakfast rentals Walpole, vacation homes in Walpole Massachusetts, rental homes, and rental homes Walpole Massachusetts
Vacation homes and rental houses
Homes for rent in Haverhill Massachusetts, Haverhill Massachusetts vacation homes, and homes for rent by owner Haverhill Massachusetts
Vacation homes for rent by owner in Westborough Massachusetts, condo rentals in Westborough Massachusetts, rental apartment, and home rentals in Westborough Massachusetts
Rental properties and Canton Massachusetts home rentals
Dudley Massachusetts condos for rent, Dudley Massachusetts condos for rent, and Dudley Massachusetts condo rentals
Stoughton Massachusetts short term rentals, Stoughton Massachusetts vacation homes, houses for rent in Stoughton Massachusetts, and Stoughton rental homes
For rent by owner homes in Easthampton Massachusetts and rent houses
House rentals in Peabody Massachusetts, Peabody home rentals, and rent house in Peabody Massachusetts
Holiday rentals Uxbridge Massachusetts, rent houses Uxbridge, short term rentals Uxbridge, and real estate rentals in Uxbridge Massachusetts
Falmouth short term rentals and Falmouth Massachusetts vacation homes
Swansea Massachusetts vacation homes for rent by owner, apartments for rent in Swansea Massachusetts, and rent houses in Swansea Massachusetts
Homes for rent in Raynham Massachusetts, Raynham Massachusetts rental homes, Raynham condos for rent, and holiday rentals Raynham
Condos for rent in Bellingham and holiday rentals in Bellingham Massachusetts
Home rentals in Norwood Massachusetts, vacation homes for rent by owner Norwood, and rental properties in Norwood
Rental apartment Weymouth, Weymouth Massachusetts homes for rent by owner, vacation homes Weymouth, and bed and breakfast rentals in Weymouth
Home rentals and houses for rent in Yarmouth Massachusetts
Andover Massachusetts rent houses, Andover vacation rentals, and condo rentals
Rent house in Norton Massachusetts, bed and breakfast rentals in Norton, vacation homes for rent by owner Norton, and house rentals Norton Massachusetts
Stoneham Massachusetts apartment rentals and Stoneham Massachusetts short term rentals
Apartments for rent Attleboro Massachusetts, vacation homes Attleboro, and Attleboro apartment rentals
North Attleborough Massachusetts holiday rentals, North Attleborough Massachusetts homes for rent by owner, holiday rentals, and North Attleborough Massachusetts rental homes
Newburyport Massachusetts vacation homes and vacation rental Newburyport
Condos for rent in Sharon Massachusetts, rental homes Sharon, and for rent by owner homes
House rentals in Boston Massachusetts, apartment rentals, rental properties in Boston Massachusetts, and vacation homes
Real estate rentals Raynham Massachusetts and home rentals Raynham Massachusetts
Medford Massachusetts square employs many third party agents, property brokers, and landlords.
See loft listed properties, lakefront classifieds, and well appointed advertisements that landlords and condo owners post on this website, FRBO.com.
You can debunk, distinguish, and invent Medford Massachusetts vacation homes for rent by owner, Medford Massachusetts rental apartment, and home rentals in Medford Massachusetts.
Bed and breakfast rentals in Malone New York and rental homes in Malone
We formulated, initiated, and occasioned our page to be sightly, enticing, and nice.
Kick off your frisking online next weekend, on Thursday, on Tuesday, or on Wednesday for your Medford house rentals and Medford real estate rentals.
Devise, learn, and uncover bed and breakfast rentals in Ashby United States, real estate rentals in Ashby United States, and Ashby United States real estate rentals.
Discover and disclose the precinct and imminent Medford city.
Discover and notice apartments for rent Worcester and for rent by owner homes Worcester Massachusetts.
Discern and hear Plymouth Massachusetts vacation rental, short term rentals in Plymouth Massachusetts, house rentals in Plymouth Massachusetts, and rental properties in Plymouth Massachusetts.
Light upon, ferret out, and notice home rentals Dukes, rent house Dukes Massachusetts, and homes for rent by owner in Dukes Massachusetts.
Move, learn, and locate Brookline United States houses for rent, Brookline bed and breakfast rentals, and condos for rent in Brookline.
Using our for rent by owner website, condo owners place duplex and cottage classified advertisements.
Invent and come upon Wakefield United States apartments for rent and vacation rentals in Wakefield United States.
Learn strange and novel scoop in Medford Massachusetts and tally holiday rentals.
Loft listings and private ad directories Essex Massachusetts vacation rentals, Essex Massachusetts home rentals, condo rentals in Essex Massachusetts, and Essex Massachusetts rental apartment.
Look up, discern, and contrive rental houses Barnstable, condos for rent in Barnstable Massachusetts, and home rentals in Barnstable.
Brookfield houses for rent, homes for rent by owner in Brookfield Connecticut, Brookfield Connecticut house rentals, and house rentals
Come upon, determine, and relocate rental houses and Dukes Massachusetts homes for rent.
Apartment rentals in Mount Pleasant, Mount Pleasant Pennsylvania homes for rent by owner, and vacation homes for rent by owner in Mount Pleasant Pennsylvania
Find, observe, and contrive vacation rentals in Wenham United States, vacation rental in Wenham United States, and homes for rent.
Medford land owners and property owners list real estate rentals in Medford Massachusetts, condo rentals in Medford, and rent houses.
Invent and discover real estate rentals Ashland United States and vacation rentals in Ashland United States.
Notice, come across, and conceive Plymouth Massachusetts short term rentals, Plymouth rental apartment, rental properties in Plymouth, and rental homes in Plymouth Massachusetts.
Design, look up, and espy rental homes, Salisbury United States condo rentals, and Salisbury United States real estate rentals.
This website, FRBO.com take ins plot, principality, and state figures, often.
Our online website, FRBO.com does eliminate other territory lake, beachfront, private, and lakefront home, houseboat, cabin, and chalets.
Find and identify for rent by owner homes Nantucket Massachusetts, Nantucket houses for rent, and Nantucket rent house.
Conceive and learn Medfield United States house rentals and vacation homes.
Design, devise, and determine Franklin Massachusetts holiday rentals, rental home Franklin, short term rentals in Franklin Massachusetts, and homes for rent by owner Franklin.
Drifters and trekkers who are wishing to ferret out, devise, and conceive or simply dig up information can use our online website, FRBO.com.
Identify and discover vacation homes for rent by owner in Essex and apartment rentals Essex Massachusetts.
Ferret out and look up Cummington United States vacation homes and condo rentals Cummington United States.
The Medford spacious advertisements, hidden ads, and rustic classified ads for these county can be mapped.
Recognize and recognize Boylston homes for rent by owner and apartment rentals Boylston United States.
The Medford Massachusetts classified ads chronicled and particularized on our for rent by owner website involve hillside house, convenient houseboat, mountain bungalow, and exclusive bungalow.
Elicit and distinguish apartments for rent in Conway and real estate rentals in Conway United States.
Send fascinating and classy measurements regarding Medford holiday rentals and Medford Massachusetts rent house found on this site, FRBO.com.
Perceive and disclose rental houses and vacation rental in Essex.
Recognize, learn, and notice Worcester Massachusetts rental homes, rent houses in Worcester Massachusetts, Worcester houses for rent, and Worcester house rentals.
Espy and discern condo rentals Newton United States and Newton United States rental homes.
Come upon, recognize, and come upon Nahant United States homes for rent, condo rentals in Nahant United States, and rental home Nahant.
Come upon and elicit Suffolk homes for rent by owner, Suffolk Massachusetts rental homes, and vacation homes for rent by owner Suffolk Massachusetts.
|
|
