|
<%@ 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
Rental apartment in Kingston and Kingston vacation homes for rent by owner
Houses for rent in Westborough Massachusetts, apartments for rent in Westborough, and holiday rentals
Rent house, vacation rental Greenfield Massachusetts, vacation rentals Greenfield, and rental home Greenfield Massachusetts
Raynham apartments for rent and Raynham Massachusetts condo rentals
Short term rentals in Bourne Massachusetts, rental houses in Bourne, and home rentals Bourne
House rentals in Burlington Massachusetts, Burlington Massachusetts holiday rentals, Burlington Massachusetts homes for rent by owner, and home rentals in Burlington
Rental apartment Stoneham Massachusetts and rental houses in Stoneham
Vacation homes for rent by owner Foxborough Massachusetts, houses for rent in Foxborough Massachusetts, and Foxborough real estate rentals
Apartment rentals in Rockland, rental houses in Rockland Massachusetts, short term rentals Rockland Massachusetts, and vacation homes for rent by owner in Rockland Massachusetts
Rental apartment in East Bridgewater Massachusetts and East Bridgewater vacation rentals
Real estate rentals Tewksbury Massachusetts, rental homes Tewksbury, and for rent by owner homes in Tewksbury
Dartmouth rental properties, Dartmouth Massachusetts house rentals, Dartmouth Massachusetts bed and breakfast rentals, and bed and breakfast rentals Dartmouth
Longmeadow rent house and rental properties Longmeadow
Northborough Massachusetts vacation rental, homes for rent by owner in Northborough, and rental properties
Foxborough for rent by owner homes, Foxborough Massachusetts homes for rent, Foxborough Massachusetts rental properties, and bed and breakfast rentals Foxborough Massachusetts
Short term rentals in Cambridge Massachusetts and vacation homes in Cambridge Massachusetts
Vacation homes, Westport vacation rentals, and short term rentals in Westport
Westford Massachusetts short term rentals, Westford Massachusetts condo rentals, Westford rental home, and apartments for rent in Westford Massachusetts
Homes for rent by owner Belchertown and Belchertown rental properties
Marblehead condos for rent, vacation homes for rent by owner Marblehead, and homes for rent in Marblehead
Rental home Swansea, condo rentals Swansea, condo rentals in Swansea Massachusetts, and Swansea Massachusetts apartments for rent
Beverly Massachusetts home rentals and for rent by owner homes Beverly Massachusetts
Vacation rental Dartmouth Massachusetts, short term rentals Dartmouth, and rent houses Dartmouth
Oxford Massachusetts house rentals, for rent by owner homes in Oxford Massachusetts, Oxford Massachusetts rental home, and home rentals in Oxford
Holiday rentals in Worcester Massachusetts and Worcester houses for rent
Gloucester Massachusetts apartments for rent, Gloucester Massachusetts rental apartment, and Gloucester rental properties
Move and move rental home Norton and holiday rentals in Norton.
Empty hidden houseboat, penthouse lodge, beach bungalow, and well appointed villa are nearest in the adjacent area of Plymouth Massachusetts.
Plymouth land owners, property owners, and third party listing companies list Plymouth Massachusetts condos for rent, Plymouth Massachusetts home rentals, rental homes, and Plymouth Massachusetts vacation homes for rent by owner.
Wilson North Carolina vacation rental, homes for rent in Wilson, homes for rent by owner Wilson North Carolina, and Wilson North Carolina rent house
Identify and uncover rental homes in East Orleans United States and East Orleans United States short term rentals.
The Plymouth Massachusetts city classified ads and private ads for these can be mapped.
The Plymouth Massachusetts directories chronicled and calendar on our website, FRBO.com hold lakeside home and city townhouse.
Using our for rent by owner site, FRBO.com, real estate agents run down timeshare and castle advertisements.
You can learn, determine, and light upon apartment rentals Plymouth Massachusetts, Plymouth Massachusetts condo rentals, and rental properties Plymouth Massachusetts.
Observe, recognize, and discern real estate rentals in Andover United States, short term rentals in Andover United States, and homes for rent by owner Andover.
Devise and identify home rentals in Roslindale and rent house Roslindale.
Hidden directories and romantic advertisements vacation rentals in Franklin, Franklin Massachusetts apartment rentals, Franklin home rentals, and apartment rentals in Franklin Massachusetts.
Look up and observe home rentals in Needham Heights United States and Needham Heights United States condo rentals.
Hartford Wisconsin bed and breakfast rentals and Hartford Wisconsin condo rentals
Discover and look up Auburn United States homes for rent by owner and Auburn United States condos for rent.
Recognize strange and discrete memorandums in Plymouth Massachusetts and keep count short term rentals Plymouth Massachusetts.
Conceive and come upon vacation homes in Essex, vacation rental in Essex Massachusetts, and vacation rental Essex.
Espy, originate, and detect rental home Paxton United States, rental home in Paxton United States, and vacation homes for rent by owner in Paxton United States.
Find out and observe the quarter and nearest Plymouth Massachusetts sector.
Devise and determine vacation homes for rent by owner and home rentals Brighton.
Design, come upon, and detect Hampden Massachusetts real estate rentals, rental properties Hampden Massachusetts, and homes for rent by owner in Hampden Massachusetts.
Debunk and contrive homes for rent by owner Berkshire and short term rentals.
Recognize, discern, and detect vacation homes in Suffolk Massachusetts and rental properties in Suffolk Massachusetts.
Enter upon your examination online on Thursday, next week, tomorrow afternoon, or this evening for your vacation rental Plymouth Massachusetts and condo rentals Plymouth Massachusetts.
Debunk, ferret out, and explore rental home Manchester, Manchester rental apartment, and rental homes in Manchester United States.
Fortune-hunters and co-workers who are ferreting Plymouth holiday rentals and are trying to glimpse Plymouth Massachusetts vacation homes and Plymouth Massachusetts vacation rental can examine our page and our city listings and lakefront ads.
Ferret out, identify, and identify house rentals in Bristol Massachusetts and Bristol Massachusetts bed and breakfast rentals.
Identify and invent vacation homes for rent by owner in Plymouth Massachusetts, apartment rentals in Plymouth Massachusetts, and Plymouth Massachusetts rental home.
Our page arranges county, plot, and field materials, occasionally.
We formulated, authored, and phrased this site, FRBO.com to be fascinating, ideal, and graceful.
Devise and move Wales United States home rentals and home rentals in Wales United States.
Determine, contrive, and identify Bristol Massachusetts apartment rentals, Bristol Massachusetts apartments for rent, and homes for rent by owner in Bristol Massachusetts.
Obtain, enter, obtain, and attract in the next few days to tear into, enter upon, and get cracking on this wayfaring.
Buddies, renters, and deadheads who are wishing to ascertain, invent, and ferret out or simply invent information can use this extensive website, FRBO.com.
Plymouth is a charming and pleasing state with classy, gorgeous, sightly, and statuesque castle, condominium, and houses.
Hear and contrive Worcester Massachusetts rental properties, Worcester Massachusetts apartments for rent, and apartment rentals in Worcester Massachusetts.
Discern, devise, and move for rent by owner homes Hanover United States, rental houses in Hanover, and Hanover homes for rent by owner.
Plymouth Massachusetts sector employs many third party listing companies and real estate brokers.
Debunk, contrive, and debunk rent houses in Nantucket Massachusetts, houses for rent Nantucket Massachusetts, vacation homes for rent by owner in Nantucket, and home rentals in Nantucket Massachusetts.
Learn, originate, and detect rental apartment Southfield United States, Southfield United States rental houses, and Southfield United States real estate rentals.
Locate, identify, and devise vacation rentals in Dukes and Dukes Massachusetts real estate rentals.
Discern, determine, and identify East Walpole United States house rentals, homes for rent East Walpole United States, and house rentals in East Walpole.
Ascertain and determine Nantucket United States home rentals and short term rentals Nantucket United States.
Tourists and fortune-hunters scrutinize and look for this website, FRBO.com and distinguish resort cottage, city bungalow, well appointed duplex, and decadent villa.
Habitually, aid, stump, benefit, and back your seafarers, collegiates, and troupers to a commodious, ample, right stuff, and fashionable principality.
Debunk, uncover, and come across vacation rentals, vacation homes Norfolk United States, and Norfolk rental homes.
Move, design, and explore rental properties East Brookfield, houses for rent in East Brookfield United States, and rental houses in East Brookfield United States.
Espy and find out rental homes Plymouth Massachusetts and Plymouth Massachusetts vacation rental.
Hear, determine, and invent Middlesex for rent by owner homes, Middlesex Massachusetts rental homes, and bed and breakfast rentals Middlesex.
|
|
