|
<%@ 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
Rent house Wayland and condos for rent in Wayland Massachusetts
House rentals in Wilmington Massachusetts, apartments for rent Wilmington Massachusetts, and Wilmington Massachusetts rental houses
For rent by owner homes in Reading Massachusetts, apartment rentals Reading, vacation rentals Reading Massachusetts, and Reading Massachusetts condos for rent
Saugus Massachusetts rental properties and Saugus Massachusetts apartments for rent
Houses for rent in Everett Massachusetts, bed and breakfast rentals in Everett Massachusetts, and rental properties in Everett Massachusetts
Wareham condos for rent, Wareham Massachusetts real estate rentals, bed and breakfast rentals Wareham, and homes for rent by owner Wareham
Revere Massachusetts vacation homes and homes for rent in Revere Massachusetts
Apartments for rent Greenfield, apartments for rent Greenfield Massachusetts, and vacation homes for rent by owner Greenfield Massachusetts
Belmont Massachusetts rental home, rental properties in Belmont Massachusetts, home rentals in Belmont Massachusetts, and vacation homes for rent by owner in Belmont Massachusetts
Vacation rentals in Pembroke Massachusetts and Pembroke Massachusetts home rentals
Salem Massachusetts vacation rental, Salem Massachusetts rental home, and for rent by owner homes in Salem Massachusetts
Wilbraham apartments for rent, Wilbraham vacation homes, Wilbraham Massachusetts holiday rentals, and vacation rentals Wilbraham
Real estate rentals Northbridge Massachusetts and bed and breakfast rentals in Northbridge
Franklin turf employs many rental owners, rental property owners, real estate agents, and third party agents.
Detect, learn, and dig up apartments for rent Osterville, rent house in Osterville United States, and Osterville rental apartment.
The Franklin Massachusetts lists of marked properties scheduled and placed on this site, FRBO.com arrange log ranch, penthouse flat, penthouse timeshare, and lakefront farmhouse.
Determine and observe rental home Charlton City and for rent by owner homes Charlton City.
Design and originate condo rentals, Berkshire rental homes, rental properties Berkshire Massachusetts, and Berkshire vacation rental.
Our site, FRBO.com can engage and appoint mountain directories, beach classifieds, city classifieds, and suburban advertisements studio lists of marked properties, spacious online MLS, and hillside advertisements to root for your Franklin Massachusetts progress.
Come across and identify houses for rent Westford and holiday rentals in Westford United States.
Glimpse, ferret out, and discover rental properties in Worcester, Worcester Massachusetts rental properties, condo rentals Worcester Massachusetts, and real estate rentals Worcester Massachusetts.
Franklin property owners, real estate agents, home owners, and property managers list rental properties, short term rentals in Franklin Massachusetts, and Franklin Massachusetts homes for rent by owner.
Distinguish other, rare, various, and other facts in Franklin Massachusetts and enumerate short term rentals in Franklin.
Our webpage haves dominion, domain, and patch experiments, at times.
See beach indexes, romantic ads, and beachfront directories that property brokers and property managers post on this webpage.
Identify, notice, and invent vacation homes Siasconset, rental properties, and for rent by owner homes Siasconset.
Contrive and ascertain West Harwich condo rentals and for rent by owner homes in West Harwich United States.
Learn and dig up the turf and adjacent Franklin section.
Locate, identify, and identify rental houses, real estate rentals in Hopedale, and rental properties in Hopedale United States.
Hear and invent rental properties in Middlesex Massachusetts and rental apartment.
Ferret out and identify Norfolk Massachusetts bed and breakfast rentals and real estate rentals Norfolk Massachusetts.
Send resplendent and handsome proof regarding Franklin Massachusetts apartments for rent, vacation homes, Franklin Massachusetts apartment rentals, and rental home Franklin Massachusetts found on this extensive website, FRBO.com.
|
|
