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 `BedroomsTotal` = '4' and `BedroomsTotal` = '3' and ListingID!=27140416 having distance <= 11 order by distance limit 3

609 WILD ROSE DRIVE For Sale

merritt, British Columbia V1K1B8
$ 825,000
$ 230 / Sq. Ft.
  • ©MLS 179723
  • Area 3583 sq ft
  • Bedrooms 4
  • Bathrooms 3

Description

All measurements are approximate and buyer to confirm if deemed important. (id:48970) Show More

Details

  • Property Type: Single Family
  • Type: House
  • Construction Material: Wood frame
  • Road: No thru road
  • Community: Merritt

Ammenities + Nearby

  • Recreation
  • Recreation

Features

  • Quiet Area
  • Mountain view
  • Refrigerator
  • Washer & Dryer
  • Dishwasher
  • Window Coverings
  • Stove
  • Microwave
  • Central air conditioning
  • Forced air
  • Furnace

Rooms Details For 609 WILD ROSE DRIVE

Type Level Dimension
4pc Bathroom Above Measurements not available
Bedroom Above 10 ft ,9 in x 12 ft ,9 in
Bedroom Above 10 ft ,9 in x 12 ft ,9 in
Other Above 9 ft ,9 in x 17 ft ,8 in
3pc Bathroom Basement Measurements not available
Bedroom Basement 10 ft ,3 in x 11 ft ,3 in
Utility room Basement 8 ft ,9 in x 6 ft ,7 in
Hobby room Basement 26 ft ,9 in x 31 ft ,9 in
Storage Basement 8 ft ,9 in x 10 ft ,3 in
4pc Ensuite bath Main level Measurements not available
Kitchen Main level 11 ft ,3 in x 12 ft ,5 in
Other Main level 18 ft ,2 in x 21 ft
Dining room Main level 17 ft ,8 in x 9 ft
Other Main level 4 ft ,6 in x 6 ft ,7 in
Laundry room Main level 10 ft ,9 in x 6 ft ,9 in
Foyer Main level 6 ft ,9 in x 9 ft ,9 in
Primary Bedroom Main level 15 ft x 14 ft
Office Main level 10 ft ,9 in x 11 ft ,4 in

Location



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

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