WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '* pi()/180) * COS(Latitude * pi()/180) * POWER(SIN(( - Longitude) * pi()/18...' at line 1] SELECT * , (3956 * 2 * ASIN(SQRT( POWER(SIN(( - Latitude) * pi()/180 / 2), 2) +COS( * pi()/180) * COS(Latitude * pi()/180) * POWER(SIN(( - Longitude) * pi()/180 / 2), 2) ))) as distance from wp_phl_property where `property_id`>0 and `Sold` != '1' and `TransactionType` = 'For sale' and ListingID!=27499110 having distance <= 11 order by distance limit 3
Nestled in the trees, on a quiet street in picturesque Bella Vista Estates! You will have views of not one but two Mountain ranges. You really do need to visit Columbia Lake to experience the scenic views and the beauty and tranquility. This flat estate lot is .41 an acre and has 108 feet of frontage (174 feet deep) and could be the spot you have been searching for to build your custom, light-filled family retreat. Bella Vista has a generous building scheme and architectural guidelines that include size options to fit any family's wishes and budget. Underground services including propane are brought right to the property line (rare for the Valley) and with no building commitment, you can take the time you want to plan and develop an amazing dream home! Enjoy the extensive walking paths throughout the community that feature quaint bridges, mountain creeks, and beautiful viewpoints of the lake and mountains. Bella Vista?s convenient location offers easy access to airports, golf, skiing, fishing, boating, hiking and biking. This is a professionally managed strata with secured boat and RV storage available for Bella Vista residents. (id:48970) Show More
The trademarks REALTOR®, REALTORS®, and the REALTOR® logo are controlled by The Canadian Real Estate Association (CREA) and identify real estate professionals who are members of CREA. The trademarks MLS®, Multiple Listing Service® and the associated logos are owned by The Canadian Real Estate Association (CREA) and identify the quality of services provided by real estate professionals who are members of CREA. The trademark DDF® is owned by The Canadian Real Estate Association (CREA) and identifies CREA's Data Distribution Facility (DDF®)
