|
<%@ 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
Falmouth homes for rent by owner and vacation homes for rent by owner Falmouth Massachusetts
Millbury Massachusetts vacation rental, rental properties Millbury, and Millbury bed and breakfast rentals
Short term rentals in Rockland, Rockland Massachusetts home rentals, Rockland Massachusetts apartments for rent, and Rockland Massachusetts rent houses
Waltham Massachusetts rental home and bed and breakfast rentals in Waltham
Rent houses Yarmouth, vacation rentals, and Yarmouth Massachusetts holiday rentals
Milford Massachusetts condo rentals, houses for rent Milford Massachusetts, Milford rental houses, and Milford Massachusetts vacation rental
Palmer Massachusetts real estate rentals and Palmer Massachusetts bed and breakfast rentals
Houses for rent, rental houses in Dudley Massachusetts, and Dudley Massachusetts rental properties
Maynard Massachusetts condos for rent, vacation rental in Maynard Massachusetts, Maynard vacation rental, and Maynard short term rentals
Vacation homes for rent by owner in Newton Massachusetts and Newton Massachusetts houses for rent
Bridgewater rent house, home rentals in Bridgewater Massachusetts, and homes for rent by owner Bridgewater Massachusetts
Houses for rent in Yarmouth Massachusetts, vacation homes for rent by owner in Yarmouth, homes for rent in Yarmouth Massachusetts, and Yarmouth Massachusetts holiday rentals
Vacation homes for rent by owner in Mansfield Massachusetts and Mansfield Massachusetts rent houses
Rent house in Wakefield, condo rentals in Wakefield Massachusetts, and rental home Wakefield
Vacation rentals in Tewksbury Massachusetts, home rentals Tewksbury, rental homes Tewksbury, and rental properties in Tewksbury Massachusetts
Weston Massachusetts field employs many brokers leasing foreclosures, rental owners, real estate brokers, and brokers leasing foreclosures.
Recognize, elicit, and light upon for rent by owner homes Suffolk, short term rentals in Suffolk Massachusetts, and Suffolk apartments for rent.
Discover, ferret out, and look up the sector and contiguous Weston Massachusetts plot.
Catch, notice, and locate Middlesex Massachusetts homes for rent and Middlesex Massachusetts homes for rent by owner.
Identify, originate, and learn homes for rent by owner Hampshire, Hampshire Massachusetts homes for rent, and Hampshire Massachusetts rent house.
Ascertain and discern Hampden Massachusetts house rentals and rental properties Hampden.
We imagined and contrived this extensive website, FRBO.com to be alluring, comely, cute, and angelic.
Relocate and elicit Nantucket Massachusetts condo rentals and rental properties.
Weston landlords, condo owners, town home owners, and property managers list rental apartment in Weston, homes for rent in Weston Massachusetts, Weston real estate rentals, and vacation rentals.
Tear into your investigation online on Saturday, on Tuesday, or tonight for your for rent by owner homes in Weston Massachusetts, Weston vacation homes, and vacation homes for rent by owner in Weston.
Disclose, find, and identify Acushnet United States rental apartment, apartment rentals in Acushnet, and real estate rentals in Acushnet United States.
Perceive, identify, and disclose Peabody United States apartments for rent, Peabody houses for rent, and real estate rentals in Peabody United States.
Identify, devise, and devise rental houses, Maynard United States real estate rentals, and houses for rent Maynard United States.
Infrequently, relieve, sustain, and run interference your trekkers and transmigrants to a provocative, mammoth, and comely domain.
Locate and distinguish condos for rent in Burlington United States and for rent by owner homes Burlington United States.
Relocate especial and atypical score in Weston Massachusetts and index Weston Massachusetts houses for rent.
Salesmen and renters examine, prospect, and search for this website, FRBO.com and ascertain decadent cottage, beachfront ranch, mountain villa, and lakefront house.
|
|
