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!=25495916 having distance <= 11 order by distance limit 3

Lot 6 VALLEY HEIGHTS DRIVE For Sale

grand forks, British Columbia V0H1H2
$ 165,000
  • ©MLS 2470195
  • Parkings 2

Description

For more information,please click the Brochure button below. .202 acre view lot in Valley Heights, suitable for daylight basement entry home. Unobstructed view of downtown Grand Forks and the valley beyond, faces southwest. One of the last lots available in this R1A zoned subdivision. (id:48970) Show More

Details

  • Property Type: Vacant Land
  • Access Type: Public Road, Highway access, Easy access
  • Community: Grand Forks
  • Communication: High Speed Internet

Ammenities + Nearby

  • Stores
  • Schools
  • Highway
  • Shopping
  • Stores
  • Schools
  • Highway
  • Shopping

Features

  • Sloping
  • Family Oriented
  • Mountain view
  • Valley view
  • City view

Location



This REALTOR.ca listing content is owned and licensed by REALTOR® members of The Canadian Real Estate Association
Data provided by: Kootenay Real Estate Board

©️ Hybrid Real Estate Plugin For CREA DDF

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®)