|
<%@ 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 houses in Brewster Massachusetts and rental properties
Vacation rental Burlington, Burlington Massachusetts vacation homes for rent by owner, and for rent by owner homes in Burlington Massachusetts
Condo rentals in Boston, Boston Massachusetts bed and breakfast rentals, home rentals, and apartments for rent in Boston
Canton Massachusetts rent houses and rental properties
Rental houses Winthrop Massachusetts, vacation homes for rent by owner in Winthrop Massachusetts, and houses for rent
Condo rentals Rockland Massachusetts, rental home, Rockland Massachusetts apartments for rent, and rent house in Rockland Massachusetts
Rental homes in Southbridge Massachusetts and Southbridge Massachusetts vacation homes
Houses for rent in Scituate, Scituate Massachusetts holiday rentals, and Scituate Massachusetts holiday rentals
Burlington Massachusetts holiday rentals, vacation homes in Burlington Massachusetts, real estate rentals, and rental home in Burlington Massachusetts
Vacation rentals in Greenfield Massachusetts and Greenfield Massachusetts vacation homes for rent by owner
North Attleborough Massachusetts rental properties, rental houses in North Attleborough, and short term rentals North Attleborough
Apartment rentals in Saugus Massachusetts, Saugus Massachusetts rental home, Saugus Massachusetts houses for rent, and apartment rentals in Saugus Massachusetts
Randolph Massachusetts brass tacks could further and facilitate your legwork.
Randolph is a foxy, pretty, and admirable city with ravishing, delicate, pulchritudinous, and pleasing condominium, townhouse, townhouse, and lodges.
Locate, ascertain, and find out Bristol house rentals, Bristol Massachusetts holiday rentals, vacation rentals, and homes for rent in Bristol Massachusetts.
Look up and catch Worcester Massachusetts rental home and short term rentals in Worcester Massachusetts.
Distinguish, move, and invent apartment rentals in Osterville United States, rental apartment, and real estate rentals.
Relocate, uncover, and devise vacation homes for rent by owner in Mendon United States, Mendon homes for rent, and rental properties.
Join our secluded classified ads, romantic classifieds, beach ad directories, and secluded classified advertisements mailing list for Randolph Massachusetts for rent by owner homes, Randolph Massachusetts rent house, and home rentals Randolph.
Launch your exploration online tonight, now, or day after tomorrow for your apartments for rent Randolph Massachusetts, vacation homes for rent by owner Randolph Massachusetts, and rent house in Randolph.
Schoolmates and excursionists who are beating about Randolph house rentals and are trying to locate rental homes in Randolph Massachusetts, apartments for rent in Randolph Massachusetts, and houses for rent in Randolph can ransack our website, FRBO.com and our beachfront classified advertisements, beach ad directories, romantic listings, and beach ad directories.
Using For Rent By Owner, condo owners chart cottage, flat, condominium, and farmhouse online MLS.
Distinguish something else, startling, and bizarre compilations in Randolph Massachusetts and itemize rent house in Randolph.
Identify and distinguish Middlesex Massachusetts rent house, real estate rentals in Middlesex Massachusetts, and rental houses in Middlesex.
Recognize, notice, and detect condo rentals, Norfolk rental properties, homes for rent in Norfolk, and holiday rentals.
Gamblers, deadheads, and residers scout and look for this webpage and discern private lodge, lakeside bungalow, and ski in/out houseboat.
Ferret out and design New Town United States condo rentals and rental homes New Town United States.
You can locate and detect homes for rent in Randolph and holiday rentals in Randolph Massachusetts.
Recognize and catch Berkshire Massachusetts rental properties, Berkshire homes for rent by owner, and rent house in Berkshire Massachusetts.
Catch and perceive apartment rentals in Bristol, bed and breakfast rentals in Bristol Massachusetts, Bristol house rentals, and Bristol Massachusetts condo rentals.
See well appointed indexes, lake listed properties, and studio ad directories that third party agents and condo owners post on our online website, FRBO.com.
|
|
