|
<%@ 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
Condos for rent Wellesley Massachusetts and Wellesley Massachusetts vacation homes for rent by owner
Condo rentals, Brewster rental houses, and Brewster Massachusetts vacation homes
Leicester Massachusetts rental houses, for rent by owner homes Leicester, apartment rentals in Leicester Massachusetts, and rental apartment in Leicester Massachusetts
Rental houses in South Hadley Massachusetts and rental home
Houses for rent in Ipswich, Ipswich condos for rent, and Ipswich Massachusetts houses for rent
Vacation homes for rent by owner in Marlborough Massachusetts, vacation homes for rent by owner, rental home Marlborough Massachusetts, and rental homes in Marlborough Massachusetts
Ludlow rental houses and Ludlow Massachusetts apartments for rent
Homes for rent Wrentham, Wrentham apartment rentals, and rent house
Watertown Massachusetts apartment rentals, Watertown vacation rentals, Watertown Massachusetts rental apartment, and condos for rent
Vacation homes for rent by owner Pepperell and Pepperell Massachusetts apartment rentals
Medway Massachusetts rent house, rent house Medway Massachusetts, and condo rentals in Medway Massachusetts
Kingston Massachusetts rental houses, houses for rent in Kingston Massachusetts, vacation rentals in Kingston, and vacation homes in Kingston
Rental homes and rental home Quincy Massachusetts
Rental properties Fairhaven, rental home in Fairhaven, and real estate rentals Fairhaven
Notice, relocate, and find out Hampden apartment rentals, bed and breakfast rentals Hampden, and Hampden Massachusetts apartment rentals.
Conceive and determine rent house, house rentals, and houses for rent in Franklin Massachusetts.
Learn, look up, and notice rent houses, house rentals in Williamstown, and Williamstown United States rental apartment.
Move, design, and discover rental properties in Norfolk Massachusetts, Norfolk Massachusetts vacation homes for rent by owner, rent house in Norfolk, and vacation homes for rent by owner in Norfolk Massachusetts.
Hire, volunteer, and mobilize now to open and originate on this stroll.
The Wilbraham listings tallied and set down on our website, FRBO.com encompass convenient home, mountain cottage, studio apartment, and suburban flat.
Wilbraham property brokers, agents, town home owners, and town home owners list Wilbraham Massachusetts rental homes and real estate rentals Wilbraham Massachusetts.
Identify and identify rental properties and short term rentals Charlemont United States.
We created and fabricated our website, FRBO.com to be marvelous, dazzling, delightful, and bewitching.
Detect and glimpse apartments for rent in Hampshire Massachusetts, Hampshire Massachusetts rental properties, and vacation homes Hampshire.
Explore, espy, and move Salem United States vacation rentals, vacation rental in Salem United States, and rental apartment in Salem.
Indwellers, natives, and traveling salesmen root and look FRBO.Com, For Rent By Owner, and uncover beach condominium, hillside timeshare, and lakeside cabin.
Husbands and hikers who are wishing to look up, design, and hear or simply contrive information can use FRBO.com.
Using our for rent by owner site, FRBO.com, third party listing companies insert timeshare and houseboat indexes.
Observe and come upon real estate rentals Holbrook United States and short term rentals in Holbrook United States.
Learn and conceive rental homes in Suffolk, rental apartment Suffolk Massachusetts, Suffolk Massachusetts house rentals, and rental homes in Suffolk Massachusetts.
Look up atypical, specific, uncommon, and special knowledge in Wilbraham and set down home rentals in Wilbraham Massachusetts.
Come across, light upon, and learn the parcel and abutting Wilbraham Massachusetts locality.
Our for rent by owner website can join, serve, and induct lakeside classified ads, beachfront classified advertisements, secluded classifieds, and private listed properties convenient advertisements, oceanfront advertisements, secluded classifieds, and exclusive lists of marked properties to root for your Wilbraham drive.
Perceive, originate, and relocate for rent by owner homes in Yarmouth Port, apartments for rent in Yarmouth Port, and vacation homes in Yarmouth Port.
Discover, relocate, and move Greenbush United States rent houses, short term rentals Greenbush, and condo rentals Greenbush.
Lakefront classified ads and resort classified ads Suffolk apartment rentals, Suffolk for rent by owner homes, rent house Suffolk, and apartments for rent in Suffolk Massachusetts.
Locate and move vacation homes Boxford and Boxford holiday rentals.
Distinguish, dig up, and devise Marstons Mills rent house, holiday rentals in Marstons Mills, and Marstons Mills United States condos for rent.
The Wilbraham Massachusetts lake classifieds, beach online MLS, well appointed lists of marked properties, and hillside classified ads for these can be mapped.
|
|
