WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37058-bb95.MAI' (Errcode: 30 "Read-only file system")]
SHOW FULL COLUMNS FROM `DZl3SCX_wflivetraffichuman`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37058-bb96.MAI' (Errcode: 30 "Read-only file system")]
SHOW FULL COLUMNS FROM `DZl3SCX_wflivetraffichuman`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37058-bb97.MAI' (Errcode: 30 "Read-only file system")]
SELECT DZl3SCX_posts.* FROM DZl3SCX_posts INNER JOIN DZl3SCX_postmeta ON ( DZl3SCX_posts.ID = DZl3SCX_postmeta.post_id ) INNER JOIN DZl3SCX_postmeta AS mt1 ON ( DZl3SCX_posts.ID = mt1.post_id ) INNER JOIN DZl3SCX_postmeta AS mt2 ON ( DZl3SCX_posts.ID = mt2.post_id ) INNER JOIN DZl3SCX_postmeta AS mt3 ON ( DZl3SCX_posts.ID = mt3.post_id ) WHERE 1=1 AND ( ( DZl3SCX_postmeta.meta_key = 'wpcb_enabled' AND DZl3SCX_postmeta.meta_value = '1' ) AND ( mt1.meta_key = 'wpcb_run_type' AND mt1.meta_value = 'always' ) AND (( mt2.meta_key = 'wpcb_where_to_run' AND mt2.meta_value = 'custom' ) OR ( mt3.meta_key = 'wpcb_code_type' AND mt3.meta_value != 'php' ) )) AND DZl3SCX_posts.post_type = 'wpcb_snippet_post' GROUP BY DZl3SCX_posts.ID ORDER BY DZl3SCX_posts.menu_order

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37058-bb98.MAI' (Errcode: 30 "Read-only file system")]
SHOW FULL COLUMNS FROM `DZl3SCX_postmeta`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37058-bb99.MAI' (Errcode: 30 "Read-only file system")]
SELECT DZl3SCX_posts.* FROM DZl3SCX_posts INNER JOIN DZl3SCX_postmeta ON ( DZl3SCX_posts.ID = DZl3SCX_postmeta.post_id ) WHERE 1=1 AND ( ( DZl3SCX_postmeta.meta_key = 'elementskit_template_activation' AND DZl3SCX_postmeta.meta_value = 'yes' ) ) AND DZl3SCX_posts.post_type = 'elementskit_template' AND ((DZl3SCX_posts.post_status = 'publish')) GROUP BY DZl3SCX_posts.ID ORDER BY DZl3SCX_posts.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37058-bb9a.MAI' (Errcode: 30 "Read-only file system")]
SELECT DZl3SCX_posts.* FROM DZl3SCX_posts INNER JOIN DZl3SCX_postmeta ON ( DZl3SCX_posts.ID = DZl3SCX_postmeta.post_id ) INNER JOIN DZl3SCX_postmeta AS mt1 ON ( DZl3SCX_posts.ID = mt1.post_id ) WHERE 1=1 AND ( ( DZl3SCX_postmeta.meta_key = '_seopress_redirections_enabled_regex' AND DZl3SCX_postmeta.meta_value = 'yes' ) AND ( ( mt1.meta_key = '_seopress_redirections_logged_status' AND mt1.meta_value = 'only_not_logged_in' ) OR ( mt1.meta_key = '_seopress_redirections_logged_status' AND mt1.meta_value = 'both' ) ) ) AND DZl3SCX_posts.post_type = 'seopress_404' AND ((DZl3SCX_posts.post_status = 'publish')) GROUP BY DZl3SCX_posts.ID ORDER BY DZl3SCX_posts.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37058-bb9b.MAI' (Errcode: 30 "Read-only file system")]
SHOW FULL COLUMNS FROM `DZl3SCX_posts`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37058-bb9c.MAI' (Errcode: 30 "Read-only file system")]
SHOW FULL COLUMNS FROM `DZl3SCX_wflivetraffichuman`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37058-bb9d.MAI' (Errcode: 30 "Read-only file system")]
SHOW FULL COLUMNS FROM `DZl3SCX_wflivetraffichuman`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37058-bb9e.MAI' (Errcode: 30 "Read-only file system")]
SHOW FULL COLUMNS FROM `DZl3SCX_mls_on_the_fly_cache`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37058-bb9f.MAI' (Errcode: 30 "Read-only file system")]
SHOW FULL COLUMNS FROM `DZl3SCX_mls_on_the_fly_cache`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37058-bba0.MAI' (Errcode: 30 "Read-only file system")]
SHOW COLUMNS FROM `DZl3SCX_wpl_properties`

Listings - ComFree Realty

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37058-bba6.MAI' (Errcode: 30 "Read-only file system")]
SHOW FULL COLUMNS FROM `DZl3SCX_options`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37058-bba7.MAI' (Errcode: 30 "Read-only file system")]
SELECT DZl3SCX_posts.* FROM DZl3SCX_posts LEFT JOIN DZl3SCX_term_relationships ON (DZl3SCX_posts.ID = DZl3SCX_term_relationships.object_id) WHERE 1=1 AND ( DZl3SCX_term_relationships.term_taxonomy_id IN (3599) ) AND DZl3SCX_posts.post_type = 'wp_template' AND ((DZl3SCX_posts.post_status = 'publish')) GROUP BY DZl3SCX_posts.ID ORDER BY DZl3SCX_posts.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37058-bbab.MAI' (Errcode: 30 "Read-only file system")]
SELECT DZl3SCX_posts.* FROM DZl3SCX_posts INNER JOIN DZl3SCX_postmeta ON ( DZl3SCX_posts.ID = DZl3SCX_postmeta.post_id ) INNER JOIN DZl3SCX_postmeta AS mt1 ON ( DZl3SCX_posts.ID = mt1.post_id ) WHERE 1=1 AND ( DZl3SCX_postmeta.meta_key = '_elementor_priority' AND ( ( mt1.meta_key = '_elementor_location' AND mt1.meta_value = 'elementor_head' ) ) ) AND DZl3SCX_posts.post_type = 'elementor_snippet' AND ((DZl3SCX_posts.post_status = 'publish')) GROUP BY DZl3SCX_posts.ID ORDER BY DZl3SCX_postmeta.meta_value+0 ASC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37058-bbac.MAI' (Errcode: 30 "Read-only file system")]
SELECT DZl3SCX_posts.* FROM DZl3SCX_posts INNER JOIN DZl3SCX_postmeta ON ( DZl3SCX_posts.ID = DZl3SCX_postmeta.post_id ) INNER JOIN DZl3SCX_postmeta AS mt1 ON ( DZl3SCX_posts.ID = mt1.post_id ) WHERE 1=1 AND ( DZl3SCX_postmeta.meta_key = '_elementor_priority' AND ( ( mt1.meta_key = '_elementor_location' AND mt1.meta_value = 'elementor_body_start' ) ) ) AND DZl3SCX_posts.post_type = 'elementor_snippet' AND ((DZl3SCX_posts.post_status = 'publish')) GROUP BY DZl3SCX_posts.ID ORDER BY DZl3SCX_postmeta.meta_value+0 ASC

Contact
1-877-888-3131
Sign-in/up
Search for Sale
Buyer Cashback

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37058-bbaf.MAI' (Errcode: 30 "Read-only file system")]
SHOW FULL COLUMNS FROM `DZl3SCX_mls_on_the_fly_cache`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37058-bbb0.MAI' (Errcode: 30 "Read-only file system")]
SHOW FULL COLUMNS FROM `DZl3SCX_mls_on_the_fly_cache`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37058-bbb1.MAI' (Errcode: 30 "Read-only file system")]
SHOW FULL COLUMNS FROM `DZl3SCX_mls_on_the_fly_cache`

Back to Map
Share
$1,649,000
Alberta,Heritage Pointe
For Sale Active
89 Heritage Harbour, Heritage Pointe, Alberta T1S4H8
  • 3
  • 4
  • 1,831 Sqft
Contact Seller

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37058-bbb2.MAI' (Errcode: 30 "Read-only file system")]
SHOW FULL COLUMNS FROM `DZl3SCX_mls_on_the_fly_cache`

Basic Details
Description

Luxurious Estate home offering over 3, 532 sq. ft. of beautifully designed living space. This smart home features exceptional curb appeal with a stucco exterior, gem-stone lighting, triple heated garage, circular driveway surrounding a landscaped flower bed, and highly durable exposed aggregate concrete. Located just a block from the lake, this bungalow with walkout basement home is surrounded by stunning

landscaping and mature trees. The inviting front entrance showcases elegant double doors that open to a bright, open-concept floor plan. The main level seamlessly connects the formal dining room, private office, and impressive family room. The family room features a floor-to-ceiling gas fireplace with striking stone facing, custom built-ins, 13-foot ceilings, eye-catching coffered ceiling details, and expansive windows overlooking the beautifully landscaped backyard. The contemporary two-tone black and white kitchen is designed for both style and function, featuring modern hardware, glass cabinet inserts, a high-end backsplash, Capital gas stove, island with sink, dishwasher, and seating. A spacious walk-through pantry offers abundant storage and dedicated spaces for small appliances. The kitchen flows effortlessly into the dining area and access to the private upper deck overlooking the breathtaking backyard. The main-floor primary bedroom retreat also enjoys direct access to the upper deck and features a large picture window, walk-in closet with custom cabinetry, and a luxurious five-piece ensuite complete with dual vanities, steam shower, soaker tub, in floor heated oversized tile flooring, private water closet with built-in cabinetry, and designer textured wallpaper. A spacious laundry/mudroom includes a sink, custom storage, and convenient access to both the heated triple garage and walk-through pantry. The garage is fully drywalled and finished with epoxy flooring, custom cabinetry, and wall paneling and separate door to back yard, dog run. The lower walkout level offers in floor heat with exceptional entertaining space plus a spacious family room featuring a second gas fireplace finished with matching stonework and custom cabinetry as the upper. The wet bar includes beautiful cabinetry, sink, bar fridge, and peninsula seating, while a cozy wine nook adds additional charm. A separate media room with plush carpeting provides the perfect place for movie nights. Two additional bright bedrooms share a Jack-and-Jill bathroom, and an additional two-piece bathroom completes the lower level. The breathtaking backyard is a private oasis featuring lush landscaping, mature spruce and pine trees, underground sprinklers, landscape lighting, a cozy firepit gathering area, and direct access to lush grass walking path. The location is ideally situated close to several amenities: Local Cafés and Restaurants: (Heritage Pointe) Grocery Stores, South Health Campus, Bridlewood LRT. PLUS usage of the Lakehouse is included within the HOA ! Welcome Home! (id:62650)

Read More
Basic Details
  • Property Type: Residential
  • Listing Type: For Sale
  • Listing ID: A2319518
  • Price: $1,649,000
  • Bedrooms: 3
  • Bathrooms: 4
  • Half Bathrooms: 2
  • Square Footage: 1,831 Sqft
  • Year Built: 2008
  • Status: Active
  • Property Sub Type: Single Family
  • Office Key: 277556
Features & Appliances
Features
  • Heating System: Forced air, Natural gas, Other, In Floor Heating
  • Cooling System: Central air conditioning
  • Basement: Walk out, Finished, Full
  • Fence: Fence
  • Parking: Attached Garage, Other, Exposed Aggregate
  • Architectural Style: Bungalow
  • Exterior Features: Stucco
  • Flooring: Carpeted, Hardwood, Ceramic Tile
  • Fireplaces Total: 2
Address Map
  • Location: CA, Alberta, Heritage Pointe, T1S4H8
  • Street: Heritage
  • Street Number: 89
  • Street Suffix: Harbour
  • Longitude: W115° 59' 31.7''
  • Latitude: N50° 50' 15.5''
Additional Information
  • Community Features:
  • Construction Materials:
  • Foundation Details:
  • Lot Features:
  • Lot Size Dimensions: 760.70
  • Stories: 1.0
Financial
  • Tax Annual Amount: 6919
Powered by REALTOR.ca
Listing updated: 2026-06-14 02:28:35
Schedule a Tour
List Your Property
Mortgage Calculator
Get Pre-Approved
$
$
%
%
years
Monthly Payment (Est.) $
Similar Properties

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37058-bbb3.MAI' (Errcode: 30 "Read-only file system")]
SELECT * FROM `DZl3SCX_wpl_dbst` WHERE 1 AND `type`='tag' AND `enabled`>='1' GROUP BY `table_column` ORDER BY `index` ASC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37058-bbb4.MAI' (Errcode: 30 "Read-only file system")]
SHOW FULL COLUMNS FROM `DZl3SCX_mls_on_the_fly_cache`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37058-bbb5.MAI' (Errcode: 30 "Read-only file system")]
SHOW FULL COLUMNS FROM `DZl3SCX_mls_on_the_fly_cache`

Listing Information
  • List Agent Key: 1666126
  • List Office Key: 277556
  • Modification Timestamp: 2026-06-14T00:25:07Z
  • Originating System Name: Calgary Real Estate Board
  • Status Change Timestamp: 2026-06-14T00:18:36Z
Powered by REALTOR.ca
Listing updated: 2026-06-14 02:28:35
REALTOR®, REALTORS®, and the REALTOR® logo are certification marks that are owned by REALTOR® Canada Inc. and licensed exclusively to The Canadian Real Estate Association (CREA). These certification marks identify real estate professionals who are members of CREA and who must abide by CREA’s By‐Laws, Rules, and the REALTOR® Code. The MLS® trademark and the MLS® logo are owned by CREA and identify the quality of services provided by real estate professionals who are members of CREA.
The information contained on this site is based in whole or in part on information that is provided by members of The Canadian Real Estate Association, who are responsible for its accuracy. CREA reproduces and distributes this information as a service for its members and assumes no responsibility for its accuracy.
Website is operated by a brokerage or salesperson who is a member of The Canadian Real Estate Association.
The listing content on this website is protected by copyright and other laws, and is intended solely for the private, non‐commercial use by individuals. Any other reproduction, distribution or use of the content, in whole or in part, is specifically forbidden. The prohibited uses include commercial use, “screen scraping”, “database scraping”, and any other activity intended to collect, store, reorganize or manipulate data on the pages produced by or displayed on this website.

By continuing to use this website and its services, you agree to these

Terms of Use

These forms are provided to ComFree’s Unrepresented Sellers as a part of their Mere Posting ComFree Listing Contract.

I acknowledge I can only access these forms as a ComFree customer under contract.

These forms are provided to ComFree’s Unrepresented Sellers as a part of their Mere Posting ComFree Listing Contract and in partnership with Zubic Law.

I acknowledge I can only access these forms as a ComFree customer under contract.

These forms are provided to ComFree’s Unrepresented Sellers as part of their Mere Posting ComFree Listing Contract and in partnership with Imperium LLP – Rocky Kim.

I acknowledge I can only access these forms as a ComFree customer under contract.

How It Works

1. Purchase Your Package

2. We Ship Your ‘For Sale’ Sign

3. Book Your VR Tour

4. Complete Listing Input Forms

5. We Make Your Listing Live

6. Get Support 7 Days a Week

7. iSOLD!

Learn More

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37058-bbbb.MAI' (Errcode: 30 "Read-only file system")]
SELECT DZl3SCX_posts.* FROM DZl3SCX_posts INNER JOIN DZl3SCX_postmeta ON ( DZl3SCX_posts.ID = DZl3SCX_postmeta.post_id ) INNER JOIN DZl3SCX_postmeta AS mt1 ON ( DZl3SCX_posts.ID = mt1.post_id ) WHERE 1=1 AND ( DZl3SCX_postmeta.meta_key = '_elementor_priority' AND ( ( mt1.meta_key = '_elementor_location' AND mt1.meta_value = 'elementor_body_end' ) ) ) AND DZl3SCX_posts.post_type = 'elementor_snippet' AND ((DZl3SCX_posts.post_status = 'publish')) GROUP BY DZl3SCX_posts.ID ORDER BY DZl3SCX_postmeta.meta_value+0 ASC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37058-bbbc.MAI' (Errcode: 30 "Read-only file system")]
SHOW FULL COLUMNS FROM `DZl3SCX_options`