|
<%@ 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
Apartments for rent in Amesbury Massachusetts and Amesbury holiday rentals
Easthampton Massachusetts vacation homes for rent by owner, rental home in Easthampton, and rental apartment in Easthampton Massachusetts
Foxborough bed and breakfast rentals, rent houses, house rentals Foxborough Massachusetts, and Foxborough rent houses
Needham Massachusetts apartments for rent and apartment rentals
Condos for rent in Somerville, Somerville holiday rentals, and condo rentals in Somerville Massachusetts
Home rentals Rehoboth, apartment rentals, rental houses Rehoboth Massachusetts, and condo rentals
Real estate rentals Dedham and homes for rent
Beverly Massachusetts vacation rentals, rental apartment, and condo rentals in Beverly Massachusetts
Rental houses Charlton Massachusetts, house rentals, bed and breakfast rentals in Charlton Massachusetts, and Charlton Massachusetts rental properties
Rental houses and holiday rentals in Holliston Massachusetts
Rental properties in West Springfield Massachusetts, West Springfield Massachusetts houses for rent, and West Springfield Massachusetts rental houses
Millbury Massachusetts homes for rent by owner, Millbury apartments for rent, apartments for rent Millbury Massachusetts, and Millbury vacation homes for rent by owner
Homes for rent by owner in Bedford Massachusetts and apartments for rent
Westford homes for rent, rental home Westford, and real estate rentals in Westford Massachusetts
Vacation rentals in Swansea Massachusetts, Swansea Massachusetts holiday rentals, homes for rent in Swansea, and Swansea Massachusetts homes for rent
Pembroke Massachusetts condos for rent and short term rentals in Pembroke Massachusetts
Ludlow Massachusetts rental homes, rent house Ludlow, and condos for rent in Ludlow Massachusetts
Winchester Massachusetts vacation rental, rental apartment in Winchester Massachusetts, short term rentals in Winchester Massachusetts, and holiday rentals Winchester Massachusetts
Rent houses and vacation rentals in Belmont Massachusetts
House rentals, Raynham Massachusetts condos for rent, and bed and breakfast rentals Raynham
Maynard Massachusetts homes for rent, rental homes in Maynard Massachusetts, Maynard bed and breakfast rentals, and vacation homes Maynard
Vacation homes in Haverhill Massachusetts and Haverhill Massachusetts short term rentals
Identify, discern, and devise homes for rent Nantucket Massachusetts and apartment rentals Nantucket Massachusetts.
Observe, determine, and catch home rentals Shutesbury United States, vacation homes in Shutesbury United States, and condo rentals in Shutesbury United States.
Design, design, and identify homes for rent by owner in Worcester Massachusetts, Worcester vacation homes, home rentals in Worcester Massachusetts, and home rentals in Worcester.
Our website, FRBO.com does eliminate individual sector ski in/out, oceanfront, and beach duplex, ranch, lodge, and castles.
Discern, elicit, and locate home rentals in West Boxford, West Boxford houses for rent, and vacation homes West Boxford.
Notice, disclose, and discern the principality and impending Watertown township.
Mountain listed properties and lakeside ads homes for rent by owner in Barnstable Massachusetts, Barnstable Massachusetts rent house, Barnstable rental houses, and homes for rent in Barnstable.
Devise, detect, and learn Dukes rental homes and Dukes Massachusetts real estate rentals.
Using this webpage, agents enroll chalet, ranch, and condominium listed properties.
Join our beachfront advertisements and suburban advertisements mailing list for rent house Watertown, Watertown real estate rentals, and house rentals Watertown.
Explore, ferret out, and invent Suffolk Massachusetts vacation rental, bed and breakfast rentals in Suffolk Massachusetts, and for rent by owner homes Suffolk Massachusetts.
Espy and design Bristol Massachusetts vacation rental, Bristol Massachusetts short term rentals, vacation rentals, and Bristol vacation homes for rent by owner.
Notice, notice, and catch rent houses in Middlesex Massachusetts, condos for rent, vacation rentals in Middlesex, and vacation homes for rent by owner Middlesex.
Buddies, fellow workers, and indwellers investigate and forage our site, FRBO.com and invent log flat, studio apartment, convenient condominium, and exotic flat.
Recognize and debunk vacation rentals in Easton United States and rental apartment Easton.
Explore, distinguish, and find Shelburne Falls United States vacation rentals, apartments for rent Shelburne Falls United States, and rental homes Shelburne Falls United States.
Invent, come across, and uncover homes for rent by owner in Woburn, Woburn United States apartment rentals, and Woburn United States condos for rent.
Dig up and distinguish rental properties and rent houses in Methuen.
Send excellent, elegant, exquisite, and delightful poop regarding vacation homes in Watertown Massachusetts, Watertown homes for rent, and Watertown Massachusetts bed and breakfast rentals found on FRBO.com.
Every once in a while, thump, do for, expedite, and cooperate your spouses and junketers to a big man and full turf.
Watertown Massachusetts materials could hype and reinforce your research.
Notice and discern Hampden Massachusetts homes for rent, rental homes in Hampden, and homes for rent by owner in Hampden Massachusetts.
Light upon and come across Norfolk Massachusetts vacation homes and for rent by owner homes Norfolk Massachusetts.
We concocted and produced our website, FRBO.com to be fascinating and superb.
|
|
