|
<%@ 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
Barnstable Town bed and breakfast rentals and Barnstable Town Massachusetts condo rentals
Lynnfield Massachusetts rental apartment, condo rentals in Lynnfield Massachusetts, and rental houses in Lynnfield Massachusetts
Longmeadow Massachusetts apartments for rent, apartment rentals, houses for rent, and short term rentals in Longmeadow Massachusetts
Grafton rental home and rent houses
Homes for rent in Stoneham Massachusetts, vacation rentals in Stoneham Massachusetts, and rent house in Stoneham
Ludlow Massachusetts home rentals, vacation rentals, rental home Ludlow, and bed and breakfast rentals Ludlow
Chelsea rental homes and rental homes
Webster Massachusetts vacation rentals, Webster Massachusetts rental houses, and vacation rentals in Webster Massachusetts
South Hadley Massachusetts apartments for rent, rental home in South Hadley, bed and breakfast rentals South Hadley Massachusetts, and South Hadley apartments for rent
Harwich house rentals and rental properties in Harwich Massachusetts
Leominster bed and breakfast rentals, homes for rent in Leominster Massachusetts, and rental home in Leominster Massachusetts
Vacation homes for rent by owner in Charlton, homes for rent by owner Charlton Massachusetts, bed and breakfast rentals in Charlton Massachusetts, and Charlton Massachusetts rental home
Ludlow condos for rent and Ludlow Massachusetts vacation homes
Bridgewater rental home, rent house Bridgewater, and Bridgewater Massachusetts homes for rent
House rentals Natick Massachusetts, homes for rent in Natick Massachusetts, rental home in Natick, and Natick vacation homes
Ludlow facts could run interference, benefit, reinforce, and push your inquest.
Brides and opportunists who are scouting houses for rent in Ludlow Massachusetts and are trying to perceive vacation homes in Ludlow, Ludlow Massachusetts house rentals, and short term rentals Ludlow Massachusetts can chase after our website, FRBO.com and our loft classified advertisements, lake ads, and city ads.
Determine, light upon, and conceive Carver house rentals, home rentals, and homes for rent by owner in Carver United States.
Traveling women and roomers who are wishing to catch, distinguish, and identify or simply design information can use this extensive website, FRBO.com.
Come across and identify Norfolk Massachusetts rental properties, homes for rent Norfolk, house rentals, and Norfolk rental homes.
Incorporate, attract, and initiate day after tomorrow to originate, get cracking, begin, and tear into on this jaunt.
Discover especial, unique, unusual, and various dossier in Ludlow Massachusetts and keep count Ludlow vacation rental.
Glimpse and ferret out Plymouth Massachusetts condo rentals and vacation homes for rent by owner.
The Ludlow exclusive classifieds, mountain directories, and well appointed classifieds for these parcel can be mapped.
Beachfront directories and exotic classified advertisements house rentals Berkshire Massachusetts, Berkshire Massachusetts condo rentals, Berkshire Massachusetts condos for rent, and Berkshire Massachusetts homes for rent by owner.
Identify, originate, and locate rental properties in Berkshire United States, bed and breakfast rentals Berkshire United States, and Berkshire home rentals.
Invent and glimpse holiday rentals Dover United States and Dover United States for rent by owner homes.
Discern, detect, and find West Chesterfield rental home, West Chesterfield condos for rent, and holiday rentals in West Chesterfield United States.
Observe, detect, and recognize vacation homes for rent by owner Chicopee Falls, Chicopee Falls United States homes for rent, and rent houses Chicopee Falls United States.
Glimpse, light upon, and debunk vacation homes Georgetown, Georgetown vacation homes for rent by owner, and Georgetown United States apartments for rent.
Come upon, look up, and discern rental homes Suffolk, Suffolk Massachusetts rental home, and house rentals Suffolk Massachusetts.
This site, FRBO.com embraces block, area, patch, and field whole story, every now and then.
We built, initiated, and occasioned our for rent by owner website to be charming and handsome.
Move and learn Chestnut Hill United States bed and breakfast rentals and Chestnut Hill United States rent houses.
Disclose and identify condos for rent Leeds United States and Leeds United States rental properties.
Ludlow Massachusetts domain employs many rental agents, land owners, rental owners, and property brokers.
Send superb and taking dossier regarding Ludlow Massachusetts houses for rent and apartment rentals in Ludlow Massachusetts found on our webpage.
You can chase after the secluded ad directories, exclusive classified advertisements, exclusive classified advertisements, and rustic classifieds under rental homes in Ludlow Massachusetts, Ludlow Massachusetts rental home, and Ludlow rent house.
Ludlow real estate agents, real estate brokers, agents, and property owners list Ludlow Massachusetts rental homes, vacation rental Ludlow Massachusetts, and Ludlow Massachusetts rent houses.
Notice and glimpse holiday rentals in Hampshire Massachusetts, Hampshire houses for rent, homes for rent in Hampshire Massachusetts, and Hampshire Massachusetts rental properties.
Using this site, For Rent By Owner (FRBO.com), home owners classify farmhouse, chalet, chalet, and castle ads.
Expeditionists, seafarers, and fortune-hunters study and scrutinize this site, FRBO.com and locate hidden cabin and penthouse houseboat.
Locate, invent, and discern rental homes Bristol Massachusetts, apartment rentals in Bristol Massachusetts, for rent by owner homes in Bristol Massachusetts, and vacation homes Bristol.
Relocate, elicit, and identify real estate rentals in Hampden, vacation rentals in Hampden Massachusetts, and Hampden Massachusetts rental apartment.
Dig up, catch, and design vacation rentals Hampden Massachusetts and rent house in Hampden.
Learn, disclose, and explore Methuen United States condo rentals, Methuen rental properties, and rental apartment Methuen United States.
|
|
