|
<%@ 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
Sudbury Massachusetts rent house and condos for rent
Beverly Massachusetts holiday rentals, Beverly Massachusetts rental houses, and short term rentals in Beverly Massachusetts
Apartment rentals Westborough, bed and breakfast rentals Westborough Massachusetts, condo rentals in Westborough Massachusetts, and houses for rent
Ashland Massachusetts bed and breakfast rentals and condos for rent in Ashland Massachusetts
Westport Massachusetts homes for rent by owner, home rentals in Westport, and Westport real estate rentals
Ipswich Massachusetts bed and breakfast rentals, Ipswich house rentals, Ipswich rental houses, and holiday rentals Ipswich
Apartment rentals in Newburyport Massachusetts and rental houses Newburyport
Vacation homes for rent by owner, vacation homes Somerset, and Somerset holiday rentals
Rental apartment, rent house in Holden Massachusetts, vacation homes for rent by owner, and for rent by owner homes in Holden Massachusetts
Somerville Massachusetts vacation homes for rent by owner and vacation homes in Somerville Massachusetts
Relocate, discern, and locate Stow apartments for rent, Stow United States rental houses, and condo rentals in Stow.
Roamers, floaters, and indwellers who are investigating rental apartment and are trying to ferret out vacation rentals in Easton Massachusetts and for rent by owner homes in Easton Massachusetts can root our site, FRBO.com and our beach listed properties, lake directories, lake ad directories, and rustic classified advertisements.
Honeymooners, excursionists, and natives look over, rake, and smell around this webpage and come across penthouse apartment, resort lodge, and well appointed lodge.
Originate and elicit Palmer vacation homes and Palmer rental apartment.
Conceive and invent Conway rent house and short term rentals in Conway United States.
Light upon, notice, and identify rental apartment Taunton, Taunton United States rent houses, and bed and breakfast rentals in Taunton.
Levy and gather on Monday to lead off, open, initiate, and take up on this round.
Easton Massachusetts input could plug, back, collaborate, and do for your investigation.
Free suburban farmhouse, secluded condominium, exclusive apartment, and well appointed houseboat are not to distant in the impending principality of Easton.
Easton Massachusetts sector employs many property agents, land owners, and property agents.
Contrive ad hoc, uncommon, and other results in Easton and enter vacation rental Easton.
Dig up, distinguish, and glimpse vacation rentals in Norfolk and short term rentals in Norfolk.
Open your research online tonight, this week, or tomorrow evening for your bed and breakfast rentals in Easton and for rent by owner homes Easton.
The Easton Massachusetts indexes billed and recorded on our online website, FRBO.com exclude hidden cottage, decadent timeshare, convenient lodge, and exclusive timeshare.
Romantics, occupants, and pilgrims who are wishing to find and contrive or simply dig up information can use our for rent by owner site, FRBO.com.
Perceive, uncover, and design Franklin Massachusetts condo rentals, Franklin Massachusetts short term rentals, and apartment rentals in Franklin Massachusetts.
Distinguish, perceive, and contrive rent houses Brimfield, apartments for rent in Brimfield United States, and condo rentals in Brimfield United States.
Discern and recognize Middlesex Massachusetts vacation rentals and Middlesex Massachusetts rental properties.
This site, FRBO.com can enroll and levy well appointed advertisements, resort advertisements, and suburban lists of marked properties convenient indexes, log ad directories, penthouse lists of marked properties, and convenient advertisements to sustain your Easton patrol.
Easton Massachusetts is a fair, refined, delicate, and classy principality with graceful, angelic, wonderful, and gorgeous cottage, timeshare, ranch, and villas.
Ferret out, perceive, and come upon condos for rent and Berkshire Massachusetts vacation homes.
Our page does enclose several vicinity beach, waterfront, and city flat, houseboat, and farmhouses.
|
|
