Featured Listings
64 STREET NE Coal Trail Northwest
$8,280,000
92 ACRES OF LAND FOR DEVELOPMENT IN THE NORTHWEST CORNER OF HIGH RIVER / NEXT TO HWY 549 (498 AVENUE) HWY 2 / HWY 2A...
Century 21 Foothills Real Estate
2 28 12 Southeast
$3,228
Super location / newly renovated / turnkey business opportunity / all equipment and furniture in...
Century 21 Foothills Real Estate
Current Listings in:
547 Mercado Avenue SE
$874,900

















































547 Mercado Avenue SE
Mahogany
Calgary
T3M 4C9
$874,900
Residential
beds: 4
baths: 3.0
2,398 sq. ft.
built: 2026
- Status:
- Active
- Prop. Type:
- Residential
- MLS® Num:
- A2305875
- Bedrooms:
- 4
- Bathrooms:
- 3
- Year Built:
- 2026
- Photos (50)
- Schedule / Email
- Send listing
- Mortgage calculator
- Print listing
Schedule a viewing:
Cancel any time.
**Open House Sun Aug 9th 1-4PM** Welcome to The Lina by Hopewell Residential, a beautifully designed 4-bedroom home where elevated finishes, thoughtful function & everyday comfort come together in one truly impressive package. From the moment you step inside, this home makes an impact with rich vinyl plank flooring, champagne gold hardware, designer lighting, and warm cabinetry that creates a refined yet welcoming feel throughout. At the front of the home, a versatile flex room offers the perfect space for a home office, reading lounge, kids’ playroom, or quiet morning coffee spot. Added pot lights elevate the space and create a warm, polished feel. As you move into the heart of the home, the upgraded kitchen layout immediately stands out. Featuring stainless steel appliances, a built-in microwave, quartz countertops, timeless subway tile, gas line rough-in for a future gas range, and a statement chimney hood fan, this kitchen blends style & function beautifully. The rear of the home is designed to feel bright, open, and connected, with an impressive wall of windows that fills the main floor with natural light. Pot lights in the kitchen add to the bright, elevated feel, while the spacious dining area easily accommodates family dinners and larger gatherings. Sliding French patio doors extend the living space outdoors to the south-facing backyard, giving you a sunny outdoor space for summer evenings, weekend barbecues, and future backyard plans. The living room is anchored by a striking gas fireplace with mantel, Carrara marble-style tile surround, and media wiring above, creating the perfect focal point for cozy nights in, holiday décor, or everyday family living. A side entrance adds valuable flexibility for future basement development options. Upstairs, upgraded railing along the stairs, upper hall, and entertainment room creates an open, elevated feel as you arrive on the second level. The stunning central entertainment room is thoughtfully positioned to create separation between the primary retreat and the secondary bedrooms. With added windows, a tray ceiling, and plenty of room to gather, this space feels bright, comfortable, and beautifully finished. The oversized primary suite is filled with natural light and feels like a true retreat. The luxurious 5-piece ensuite features a freestanding tub centered between dual vanities, marble-style tile, a standalone shower, and elevated finishes that bring a spa-inspired feel to your daily routine. The generous walk-in closet connects directly to the laundry room, adding a level of convenience that makes everyday living easier. On the opposite side of the entertainment room, three spacious bedrooms provide plenty of room for kids, guests, or growing families, ensuring everyone has their own comfortable space. All this located in the desirable Lake community of Mahogany. **Photos are from the show home/previous builds to demonstrate quality of construction & finishes and may not be an exact representation of this home**
- Property Type:
- Residential
- Property Sub Type:
- Detached
- Condo Type:
- Not a Condo
- Transaction Type:
- For Sale
- Possession:
- Signup
- Possession Date:
- Signup
- Suite:
- No
- Num Legal Suites:
- 0
- Num Illegal Suites:
- 0
- Home Style:
- 2 Storey
- Total Living Area:
- 2,398 sq. ft.223 m2
- Main Level Finished Area:
- 1,012 sq. ft.94 m2
- Upper Level Finished Area:
- 1,386 sq. ft.129 m2
- Lower Level Finished Area:
- Signup
- Above Grade Finished Area:
- Signup
- Taxes:
- Signup
- Tax Assessed Value:
- Signup
- HOA Fee Frequency:
- Annually
- HOA Fee Includes:
- Signup
- Acreage:
- No
- Lot Area:
- 4,140 sq. ft.385 m2
- Lot Frontage:
- 36'1"11 m
- Acres Cleared:
- Signup
- Acres Cultivated:
- Signup
- Acres Irrigated:
- Signup
- Acres Leasehold:
- Signup
- Acres Not Cultivated:
- Signup
- Acres Freehold:
- Signup
- Acres Seeded:
- Signup
- Acres Tame Hay:
- Signup
- Acres Treed:
- Signup
- Acres Waste:
- Signup
- Acres Water Rights:
- Signup
- Front Exposure:
- North
- Reg. Size:
- Signup
- Reg. Size Includes:
- Signup
- Entry Level:
- 1
- Levels:
- Two
- Total Rooms Above Grade:
- 7
- Year built:
- 2026 (Age: 0)
- Bedrooms:
- 4 (Above Grd: 4)
- Bedrooms Above Grade:
- 4
- Bedrooms On Main:
- 0
- Bedrooms Below Grade:
- 0
- Bathrooms:
- 3.0 (Full:2, Half:1)
- Num Ensuite Baths:
- 1
- Plan:
- 2510243
- Heating:
- Forced Air, Natural Gas
- Basement:
- Full, Unfinished, Separate/Exterior Entry
- Foundation:
- Poured Concrete
- Builder:
- Hopewell Residential
- New Constr.:
- Yes
- Construction Material:
- Cement Fiber Board, Stone, Wood Frame
- Structure Type:
- House
- Roof:
- Asphalt Shingle
- Ensuite:
- Yes
- Flooring:
- Carpet, Vinyl Plank
- Cooling:
- None
- Fireplaces:
- 1
- Fireplace Details:
- Gas, Living Room, Tile
- Garage:
- Yes
- Garage Spaces:
- 2
- Parking:
- Double Garage Attached
- Parking Places:
- 4
- Parking Total/Covered:
- 4 / -
- Laundry Features:
- Upper Level
- HOA Fee:
- $621.65
- Southeast
- Mahogany
- None
- Dishwasher, Electric Stove, Microwave, Range Hood, Refrigerator
- N/A
- Utility Right Of Way
- Floor
- Type
- Size
- Other
- Main Floor
- Living/Dining Room Combination
- 26'11"8.20 m × 12'3.66 m
- Main Floor
- Kitchen
- 13'7"4.14 m × 10'3.05 m
- Main Floor
- Flex Space
- 11'3.35 m × 7'4"2.24 m
- Upper Level
- Bonus Room
- 15'1"4.60 m × 13'3"4.04 m
- Upper Level
- Bedroom - Primary
- 14'6"4.42 m × 13'6"4.11 m
- Upper Level
- Bedroom
- 10'10"3.30 m × 10'3.05 m
- Upper Level
- Bedroom
- 10'11"3.33 m × 10'3.05 m
- Upper Level
- Bedroom
- 10'10"3.30 m × 10'3.05 m
- Upper Level
- Laundry
- 8'6"2.59 m × 6'1.83 m
- Floor
- Ensuite
- Pieces
- Other
- Main Floor
- No
- 2
- 7'2" x 4'10"
- Upper Level
- Yes
- 5
- 12'4" x 12'1"
- Upper Level
- No
- 5
- 13'3" x 4'11"
- Title to Land:
- Fee Simple
- Community Features:
- Clubhouse, Fishing, Lake, Park, Playground, Pond, Schools Nearby, Shopping Nearby, Sidewalks, Street Lights, Tennis Court(s), Walking/Bike Paths
- Interior Features:
- Bathroom Rough-in, Double Vanity, Kitchen Island, No Animal Home, No Smoking Home, Open Floorplan, Pantry, Quartz Counters
- Exterior Features:
- BBQ gas line
- Patio And Porch Features:
- None
- Lot Features:
- Back Yard, Level, No Back Lane, Rectangular Lot, Street Lighting
- Num. of Parcels:
- 0
- Fencing:
- None
- Region:
- Calgary
- Zone:
- CAL Zone SE
- Zoning:
- R-G
- Listed Date:
- Apr 30, 2026
- Days on Mkt:
- Signup
-
Photo 1 of 50
-
Photo 2 of 50
-
Photo 3 of 50
-
Photo 4 of 50
-
Photo 5 of 50
-
Photo 6 of 50
-
Photo 7 of 50
-
Photo 8 of 50
-
Photo 9 of 50
-
Photo 10 of 50
-
Photo 11 of 50
-
Photo 12 of 50
-
Photo 13 of 50
-
Photo 14 of 50
-
Photo 15 of 50
-
Photo 16 of 50
-
Photo 17 of 50
-
Photo 18 of 50
-
Photo 19 of 50
-
Photo 20 of 50
-
Photo 21 of 50
-
Photo 22 of 50
-
Photo 23 of 50
-
Photo 24 of 50
-
Photo 25 of 50
-
Photo 26 of 50
-
Photo 27 of 50
-
Photo 28 of 50
-
Photo 29 of 50
-
Photo 30 of 50
-
Photo 31 of 50
-
Photo 32 of 50
-
Photo 33 of 50
-
Photo 34 of 50
-
Photo 35 of 50
-
Photo 36 of 50
-
Photo 37 of 50
-
Photo 38 of 50
-
Photo 39 of 50
-
Photo 40 of 50
-
Photo 41 of 50
-
Photo 42 of 50
-
Photo 43 of 50
-
Photo 44 of 50
-
Photo 45 of 50
-
Photo 46 of 50
-
Photo 47 of 50
-
Photo 48 of 50
-
Photo 49 of 50
-
Photo 50 of 50
Larger map options:
Listed by Real Broker
Data was last updated September 6, 2026 at 10:05 AM (UTC)
Area Statistics
- Listings on market:
- 127
- Avg list price:
- $689,900
- Min list price:
- $229,900
- Max list price:
- $2,149,900
- Avg days on market:
- 39
- Min days on market:
- 2
- Max days on market:
- 351
- Avg price per sq.ft.:
- $407.52
These statistics are generated based on the current listing's property type
and located in
Mahogany. Average values are
derived using median calculations. This data is not produced by
the MLS® system.
- Terry Arnett
- Century 21 Foothills Real Estate
- 403-336-1555
- Contact by Email
- Trevor Arnett
- Century 21 Foothills Real Estate
- 403-992-5697
- Contact by Email
Data is supplied by Pillar 9™ MLS® System. Pillar 9™ is the owner of the copyright in its MLS®System. Data is deemed reliable but is not guaranteed accurate by Pillar 9™.
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. Used under license.




