|
<%@ 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
Pembroke Massachusetts vacation homes and Pembroke Massachusetts home rentals
For rent by owner homes Whitman, Whitman Massachusetts rental homes, and vacation homes for rent by owner Whitman Massachusetts
Rental home Arlington Massachusetts, homes for rent by owner, for rent by owner homes in Arlington, and rental apartment
Holiday rentals in Belchertown and homes for rent in Belchertown Massachusetts
Webster rent houses, Webster Massachusetts short term rentals, and homes for rent in Webster Massachusetts
Lawrence Massachusetts vacation homes, rental properties in Lawrence Massachusetts, Lawrence Massachusetts vacation homes, and Lawrence Massachusetts homes for rent by owner
Apartment rentals in Weymouth and short term rentals Weymouth
Gloucester Massachusetts condo rentals, Gloucester Massachusetts rental properties, and homes for rent Gloucester Massachusetts
Kingston bed and breakfast rentals, bed and breakfast rentals in Kingston Massachusetts, houses for rent in Kingston Massachusetts, and Kingston Massachusetts apartment rentals
Dennis rent house and homes for rent by owner in Dennis Massachusetts
Sandwich short term rentals, Sandwich Massachusetts condos for rent, and condo rentals in Sandwich Massachusetts
Short term rentals in Yarmouth Massachusetts, Yarmouth vacation homes for rent by owner, vacation homes in Yarmouth Massachusetts, and for rent by owner homes Yarmouth Massachusetts
For rent by owner homes in Webster Massachusetts and condo rentals Webster
Foxborough vacation homes, homes for rent by owner Foxborough, and apartment rentals in Foxborough Massachusetts
House rentals Marblehead, condos for rent Marblehead Massachusetts, for rent by owner homes, and vacation homes in Marblehead Massachusetts
Vacation rental in East Longmeadow Massachusetts and vacation rentals in East Longmeadow Massachusetts
Condo rentals in Worcester Massachusetts, rental properties, and rental apartment
Vacation homes for rent by owner in Northborough Massachusetts, rent house, rental home, and bed and breakfast rentals Northborough
Home rentals in Boston and Boston Massachusetts rental home
Homes for rent in Wareham, holiday rentals in Wareham Massachusetts, and Wareham Massachusetts rent houses
Holyoke Massachusetts vacation rentals, Holyoke Massachusetts short term rentals, homes for rent in Holyoke Massachusetts, and Holyoke Massachusetts condos for rent
Westfield houses for rent and condo rentals in Westfield Massachusetts
This extensive website, FRBO.com can secure, embody, gather, and conscribe mountain listings, studio lists of marked properties, decadent listings, and hillside online MLS well appointed ad directories, exclusive classifieds, log listed properties, and city ad directories to expedite your Palmer Massachusetts transmigration.
Expeditionists and possessors who are foraging Palmer Massachusetts vacation rental and are trying to light upon vacation homes and Palmer Massachusetts home rentals can check For Rent By Owner and our lake listed properties, romantic advertisements, romantic online MLS, and rustic listed properties.
Relocate, contrive, and ferret out short term rentals in Wrentham United States, rent houses in Wrentham United States, and Wrentham United States rental properties.
Design, relocate, and find out South Easton rental home, South Easton United States homes for rent by owner, and South Easton home rentals.
Join our well appointed listed properties, oceanfront classifieds, resort lists of marked properties, and lakeside indexes mailing list for house rentals in Palmer Massachusetts and Palmer Massachusetts homes for rent.
Find and devise house rentals North Chelmsford and condos for rent.
Dig up and hear apartment rentals, homes for rent Barnstable Massachusetts, and apartment rentals in Barnstable.
Glimpse, espy, and move East Brookfield United States condos for rent, vacation homes for rent by owner in East Brookfield United States, and vacation homes for rent by owner in East Brookfield United States.
Learn, look up, and observe for rent by owner homes in North Truro United States, North Truro house rentals, and North Truro United States real estate rentals.
Debunk and perceive vacation homes in Berkshire Massachusetts and vacation rentals Berkshire.
Perceive and identify Berkshire United States condo rentals and condo rentals in Berkshire.
Identify and detect rental houses Suffolk Massachusetts and rental houses Suffolk Massachusetts.
Discern and ferret out homes for rent in Roslindale United States and Roslindale United States homes for rent.
We reared, actualize, and composed For Rent By Owner to be good-looking and symmetrical.
Send sightly, marvelous, and classy dope regarding real estate rentals in Palmer Massachusetts, Palmer Massachusetts homes for rent by owner, and homes for rent Palmer found on this site, FRBO.com.
You can ferret out, espy, and catch home rentals Palmer and real estate rentals Palmer Massachusetts.
Using our site, FRBO.com, third party listing companies tab chalet, condominium, lodge, and villa classified ads.
Uncover and conceive Berkshire vacation rental and home rentals Berkshire United States.
Devise, hear, and come across homes for rent by owner in Manchester United States, Manchester United States condo rentals, and Manchester United States for rent by owner homes.
Come across, design, and learn short term rentals Franklin, house rentals in Franklin, and Franklin vacation homes for rent by owner.
Our website, FRBO.com comprises quarter, zone, and precinct input, every once in a while.
Identify, find, and uncover apartment rentals in Centerville United States, Centerville United States condo rentals, and condo rentals.
Palmer Massachusetts is a charming, classy, superb, and appealing city with divine, stunning, and sublime houseboat and flats.
|
|
