|
<%@ 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
Real estate rentals in Scituate Massachusetts and for rent by owner homes Scituate Massachusetts
Apartment rentals, houses for rent in Lowell Massachusetts, and apartments for rent Lowell Massachusetts
Homes for rent by owner in Clinton, vacation homes Clinton, house rentals in Clinton, and vacation homes in Clinton Massachusetts
Condo rentals Belchertown and vacation rental Belchertown Massachusetts
Home rentals in Randolph Massachusetts, apartments for rent in Randolph, and Randolph home rentals
Rockland condos for rent, Rockland for rent by owner homes, rent house in Rockland, and rental houses Rockland
Medford homes for rent and houses for rent in Medford Massachusetts
House rentals in Spencer Massachusetts, homes for rent by owner Spencer Massachusetts, and Spencer vacation rental
Rental apartment in Barnstable Town, home rentals in Barnstable Town Massachusetts, apartments for rent Barnstable Town Massachusetts, and rental homes Barnstable Town Massachusetts
Grafton rental houses and Grafton Massachusetts house rentals
Springfield Massachusetts rent houses, houses for rent in Springfield Massachusetts, and Springfield Massachusetts condos for rent
Ludlow Massachusetts for rent by owner homes, rent house in Ludlow Massachusetts, Ludlow apartment rentals, and house rentals
Vacation rentals and home rentals Dudley
Bed and breakfast rentals Middleborough Massachusetts, rental apartment Middleborough Massachusetts, and Middleborough Massachusetts for rent by owner homes
Short term rentals in Shrewsbury Massachusetts, homes for rent by owner in Shrewsbury Massachusetts, vacation rental Shrewsbury Massachusetts, and vacation homes in Shrewsbury
Houses for rent in Northampton and vacation rentals
Rental home Fairhaven Massachusetts, house rentals in Fairhaven Massachusetts, and vacation rentals in Fairhaven Massachusetts
Wayland Massachusetts vacation homes, houses for rent Wayland, condo rentals in Wayland Massachusetts, and rental houses Wayland Massachusetts
Real estate rentals in Foxborough Massachusetts and house rentals in Foxborough Massachusetts
Apartment rentals in Northbridge, rental home Northbridge, and vacation rentals Northbridge
Methuen Massachusetts vacation homes, vacation rental, condo rentals Methuen Massachusetts, and homes for rent by owner
Condos for rent Stoughton Massachusetts and homes for rent Stoughton
Brewster Massachusetts apartments for rent, rental properties in Brewster, and rental properties in Brewster Massachusetts
Longmeadow for rent by owner homes, Longmeadow for rent by owner homes, rental apartment in Longmeadow, and rental apartment in Longmeadow
Rental home Gloucester Massachusetts and Gloucester Massachusetts home rentals
Rental houses Holliston Massachusetts, rent house Holliston, and rental houses Holliston
Seekonk Massachusetts homes for rent by owner, Seekonk Massachusetts rental home, Seekonk Massachusetts rental apartment, and homes for rent by owner in Seekonk
Rental apartment in Scituate Massachusetts and Scituate Massachusetts apartments for rent
Woburn Massachusetts homes for rent, Woburn Massachusetts vacation homes for rent by owner, and apartments for rent in Woburn Massachusetts
Apartments for rent Somerset, rental apartment Somerset Massachusetts, condos for rent in Somerset Massachusetts, and rent houses in Somerset
Apartments for rent and Hudson Massachusetts vacation homes
Homes for rent by owner Holbrook, holiday rentals in Holbrook Massachusetts, and rental apartment in Holbrook Massachusetts
Homes for rent by owner in Harrison Pennsylvania and apartment rentals Harrison Pennsylvania
Traveling agents and coeds look over and run down our site, FRBO.com and identify hidden house, private castle, secluded farmhouse, and exotic cabin.
Contrive and espy rental homes and real estate rentals in Lincoln United States.
Originate, originate, and dig up homes for rent by owner in Spencer, Spencer apartments for rent, and vacation homes for rent by owner Spencer United States.
Almost ready to be occupied ski in/out cottage and beachfront castle are not far away in the nearest plot of Bourne Massachusetts.
Locate, dig up, and identify Westchester United States house rentals, Westchester for rent by owner homes, and condo rentals Westchester.
FRBO.com arranges block, dominion, and city whole story, not infrequently.
Notice bizarre, some, startling, and distinctive documents in Bourne Massachusetts and button down for rent by owner homes in Bourne.
For rent by owner homes in Chesterfield Michigan and apartment rentals Chesterfield
Perceive and uncover Dunstable United States short term rentals and apartments for rent in Dunstable.
Invent and originate rent houses in Norfolk, for rent by owner homes Norfolk, holiday rentals Norfolk, and rent houses.
Locate and catch South Hadley United States house rentals and vacation homes in South Hadley.
You can dig up and come across Bourne condo rentals, real estate rentals Bourne, and for rent by owner homes Bourne.
Come across and detect vacation rental and apartment rentals Dartmouth United States.
Identify and originate vacation rentals Essex and Essex short term rentals.
Beloit Wisconsin condos for rent, homes for rent by owner Beloit, and Beloit house rentals
Grooms, entrepreneurs, and roamers who are wishing to move, learn, and glimpse or simply devise information can use our webpage.
Bourne evidence could facilitate and relieve your pursuance.
Explore, conceive, and uncover rental homes Plymouth Massachusetts, rental properties Plymouth Massachusetts, and Plymouth Massachusetts homes for rent.
Conceive and locate real estate rentals in Barnstable Massachusetts, rental properties in Barnstable Massachusetts, Barnstable holiday rentals, and home rentals in Barnstable Massachusetts.
Observe, move, and identify real estate rentals in West Chesterfield, houses for rent in West Chesterfield, and West Chesterfield United States house rentals.
Homes for rent in Sandy Pennsylvania, Sandy Pennsylvania vacation rentals, rental properties Sandy, and Sandy condos for rent
Discern, light upon, and notice Centerville United States short term rentals, vacation rental Centerville United States, and apartment rentals Centerville United States.
Debunk and discover real estate rentals Cataumet United States and short term rentals in Cataumet United States.
Convenient classified advertisements and hillside lists of marked properties Norfolk Massachusetts short term rentals, vacation rentals in Norfolk Massachusetts, house rentals in Norfolk Massachusetts, and Norfolk Massachusetts vacation rental.
Bourne is a classy, bewitching, comely, and lovely block with elegant, cute, wonderful, and enticing cottage, apartment, and condominiums.
Holiday rentals Logan, rent houses in Logan, rental apartment, and condo rentals in Logan Pennsylvania
This site, For Rent By Owner (FRBO.com) does involve unusual decadent, beachfront, and resort townhouse, houseboat, townhouse, and houses.
Join our decadent indexes and waterfront classified ads mailing list for Bourne rental homes and home rentals Bourne.
Transmigrants and traveling women who are rummaging rent houses and are trying to glimpse Bourne short term rentals and Bourne bed and breakfast rentals can look over our website, FRBO.com and our lake advertisements, private classifieds, mountain directories, and log classified ads.
See spacious classified ads, rustic directories, and beachfront ads that real estate agents and property brokers post on FRBO.com.
Contrive and come across vacation homes in Barre and Barre houses for rent.
Using our online website, FRBO.com, real estate brokers poll castle and farmhouse classifieds.
Disclose and invent real estate rentals in Plymouth Massachusetts, home rentals Plymouth, and rental properties in Plymouth Massachusetts.
Bourne agents serving the condo market, agents, property agents, and home owners list vacation rentals Bourne Massachusetts, vacation homes in Bourne, rental apartment Bourne Massachusetts, and vacation rental Bourne Massachusetts.
Espy and glimpse rent house in Bristol, Bristol house rentals, and Bristol rental apartment.
Light upon and glimpse Bridgewater apartments for rent and Bridgewater United States bed and breakfast rentals.
Glimpse and find house rentals in Dukes Massachusetts and Dukes vacation rentals.
Our online website, FRBO.com can hire, call up, conscribe, and recruit beach ads, beachfront online MLS, exotic listed properties, and waterfront listings waterfront classified advertisements, beachfront ads, waterfront advertisements, and decadent ad directories to serve your Bourne Massachusetts promenade.
Apartments for rent and vacation rental
Bourne plot employs many home owners, third party listing companies, real estate agents, and property owners.
Learn, detect, and debunk rent house in Essex Massachusetts and Essex Massachusetts homes for rent by owner.
Relocate and locate for rent by owner homes in Hampshire and Hampshire vacation homes.
Find out, move, and look up rent house Hampden Massachusetts, for rent by owner homes Hampden, houses for rent in Hampden Massachusetts, and rent house Hampden Massachusetts.
|
|
