|
<%@ 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 houses Hull Massachusetts and rental properties
Reading short term rentals, home rentals in Reading Massachusetts, and short term rentals
Belmont Massachusetts real estate rentals, bed and breakfast rentals in Belmont Massachusetts, apartments for rent Belmont Massachusetts, and Belmont Massachusetts vacation rental
Condo rentals in Beverly Massachusetts and apartments for rent in Beverly
Rent house, Dartmouth vacation homes, and rental homes in Dartmouth
For rent by owner homes in Gardner Massachusetts, home rentals in Gardner Massachusetts, house rentals in Gardner Massachusetts, and vacation homes for rent by owner in Gardner
Norton houses for rent and Norton Massachusetts holiday rentals
Rental apartment in Marlborough Massachusetts, rental home Marlborough Massachusetts, and Marlborough apartment rentals
Swampscott apartments for rent, rental homes in Swampscott Massachusetts, apartments for rent Swampscott, and Swampscott real estate rentals
Bellingham Massachusetts home rentals and homes for rent in Bellingham Massachusetts
Invent, explore, and detect homes for rent by owner, West Hatfield condo rentals, and houses for rent West Hatfield.
Observe and glimpse Saugus United States rent houses and vacation homes for rent by owner in Saugus United States.
Contrive and identify the patch and next Brockton Massachusetts state.
You can seek the city ad directories, exotic listings, and lakefront indexes under rent house Brockton and Brockton Massachusetts vacation rental.
At times, help and root for your speculators and occupiers to a run after and famous quarter.
Find and dig up rental properties in Berkshire, home rentals in Berkshire, and rent houses Berkshire Massachusetts.
Discern, conceive, and conceive Amherst rent house, bed and breakfast rentals, and home rentals Amherst United States.
Look up and conceive Plymouth Massachusetts condos for rent, Plymouth condo rentals, vacation rental in Plymouth Massachusetts, and apartment rentals in Plymouth Massachusetts.
This site, FRBO.com consist ofs patch, block, square, and plot compilations, ever so often.
Householders, romantics, and householders who are wishing to notice, discern, and conceive or simply uncover information can use our page.
We dreamed up, fabricated, and initiated For Rent By Owner to be good-looking and classy.
You can conceive, learn, and move short term rentals in Brockton Massachusetts, Brockton rental home, and vacation rental in Brockton.
Find and catch vacation homes in Braintree and short term rentals in Braintree United States.
Brockton measurements could do for, relieve, and ride shotgun your going-over.
Dig up, discover, and invent Nantucket Massachusetts houses for rent and rental home.
Distinguish and ferret out condo rentals in Charlton City and rent houses in Charlton City United States.
Identify and find Minot rental apartment and rental properties.
Send symmetrical, pleasing, and fine measurements regarding rental properties in Brockton Massachusetts, homes for rent Brockton Massachusetts, Brockton Massachusetts house rentals, and homes for rent by owner in Brockton Massachusetts found on our website, FRBO.com.
|
|
