Calgary Open Houses scheduled for today
Jan 31, 2025
03:00 PM
-
07:00 PM
MST
517 28 Avenue NW
Mount Pleasant
Calgary
T2M 2K9
$2,625,000
Residential
beds: 6
baths: 5.0
3,193 sq. ft.
built: 2024
Open House
-
Jan 31, 2025
03:00 PM
-
07:00 PM
MST
NOTES: Open House on Friday, January 31, 2025 3:00PM - 7:00PM
- Status:
- Active
- Prop. Type:
- Residential
- MLS® Num:
- A2188005
- Bedrooms:
- 6
- Bathrooms:
- 5
- Year Built:
- 2024
- Photos (50)
- Schedule / Email
- Send listing
- Mortgage calculator
- Print listing
Schedule a viewing:
Cancel any time.
**OPEN HOUSE - Friday, Jan 31st 4pm-8pm** This remarkable residence embodies the pinnacle of luxury living with bespoke custom finishes, & was meticulously crafted by the renowned design firm Mercedes and Singh. This iconic home invites you to explore the epitome of urban elegance and is Calgary's freshest, luxurious inner-city sanctuary. This picturesque home features over 4500 sq.ft of developed living space and welcomes you with a striking entryway, unveiling the floor above. The main floor offers a versatile office/flex room, a tasteful powder room, a practical mudroom, & a living room adorned with a bespoke feature wall & a cozy gas fireplace. The interior seamlessly connects with the outdoors through expansive, sunlit windows & glass doors that beckon you to the private rear deck & yard. For the culinary enthusiast, the chef-inspired kitchen is nothing short of a dream. Adorned with custom cabinetry, a generous island graced with marble countertop & an ingeniously designed walkthrough butler's pantry that effortlessly leads to the formal dining area, adding an extra layer of convenience to your lifestyle. An elevator can also be installed making accessing all levels easy and hassle free. Ascend to the second level of this magnificent home via the custom staircase, & the charm continues to unfold, catering to families at every stage of life. Impeccably designed, this level boasts four bedrooms, including not one but two primary bedrooms, each graced with its own spacious walk-in closet & luxurious ensuite bathroom. The southern bedroom also features its own private balcony overlooking the rear yard. The two additional bedrooms are thoughtfully appointed & conveniently share access to another full bathroom. But that's not all; practicality meets luxury with elevator access & a dedicated second-level laundry room, ensuring every need is met effortlessly. Descend to the lower level, where you'll discover a full legal suite with two generously sized bedrooms, accompanied by a well-appointed full bathroom & storage room. For added convenience, a second laundry room has been thoughtfully included, making daily tasks easy & efficient. But the true gem of this level is the expansive recreation room & charming kitchenette. Elevator access is also seamlessly integrated, ensuring both practicality & luxury blend effortlessly. The outside continues to impress with a large rear deck, detached triple garage & one-of-a-kind finishes, including the custom aluminum front facade that instantly transforms this home into an architectural masterpiece. As the name of this home implies, this stunning residence is located close to Confederation Park where you can enjoy peaceful walks daily. It’s also located in the desirable community of Mount Pleasant which means that everything is conveniently located including shopping, schools & restaurants. This beautiful home also provides easy access to SAIT, U of C, The Children's Hospital, Foothills Hospital, LRT, Highway 1 & Deerfoot Trail.
- Property Type:
- Residential
- Property Sub Type:
- Detached
- Condo Type:
- Not a Condo
- Transaction Type:
- For Sale
- Possession:
- Signup
- Possession Date:
- Signup
- Suite:
- Suite - Legal
- Home Style:
- 2 Storey
- Total Living Area:
- 3,193 sq. ft.297 m2
- Main Level Finished Area:
- 1,602 sq. ft.149 m2
- Upper Level Finished Area:
- 1,590 sq. ft.148 m2
- Lower Level Finished Area:
- Signup
- Above Grade Finished Area:
- Signup
- Below Grade Finished Area:
- 1,385 sq. ft.129 m2
- Taxes:
- Signup
- Tax Assessed Value:
- Signup
- HOA Fee Includes:
- Signup
- Lot Area:
- 5,069 sq. ft.471 m2
- Lot Frontage:
- 42'12.8 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
- Levels:
- Two
- Total Rooms Above Grade:
- 8
- Year built:
- 2024 (Age: 1)
- Bedrooms:
- 6 (Above Grd: 4)
- Bedrooms Above Grade:
- 4
- Bedrooms Below Grade:
- 2
- Bathrooms:
- 5.0 (Full:4, Half:1)
- Plan:
- 3955R
- Heating:
- Forced Air
- Basement:
- Separate/Exterior Entry, Finished, Full, Suite
- Foundation:
- Poured Concrete
- New Constr.:
- Yes
- Construction Material:
- Metal Siding, See Remarks, Stucco, Wood Frame
- Structure Type:
- House
- Roof:
- Flat Torch Membrane
- Ensuite:
- Yes
- Flooring:
- Carpet, Ceramic Tile, Hardwood
- Cooling:
- Central Air
- Fireplaces:
- 1
- Fireplace Details:
- Gas, Living Room
- Garage:
- 1
- Garage Spaces:
- 3
- Parking:
- Alley Access, In Garage Electric Vehicle Charging Station(s), Plug-In, See Remarks, Triple Garage Detached
- Parking Places:
- 3.0
- Parking Total/Covered:
- 3 / -
- Laundry Features:
- In Basement, Laundry Room, See Remarks, Upper Level
- Mount Pleasant (Calgary)
- Bar Fridge, Built-In Refrigerator, Central Air Conditioner, Dishwasher, Dryer, Electric Stove, Garage Control(s), Gas Range, Range Hood, Refrigerator, Washer
- n/a
- None Known
- Floor
- Type
- Size
- Other
- Main Floor
- Kitchen
- 48'11"14.90 m × 48'11"14.90 m
- Main Floor
- Dining Room
- 52'9"16.10 m × 37'2"11.30 m
- Main Floor
- Living Room
- 69'6"21.20 m × 50'10"15.50 m
- Main Floor
- Office
- 35'3"10.70 m × 27'8"8.43 m
- Main Floor
- Pantry
- 30'1"9.17 m × 29'3"8.92 m
- Main Floor
- Mud Room
- 27'11"8.51 m × 22'8"6.91 m
- Upper Level
- Bedroom - Primary
- 58'10"17.90 m × 33'8"10.30 m
- Upper Level
- Balcony
- 35'6"10.80 m × 14'3"4.34 m
- Upper Level
- Bedroom
- 52'9"16.10 m × 37'6"11.40 m
- Upper Level
- Bedroom
- 35'10"10.90 m × 32'7"9.93 m
- Upper Level
- Bedroom
- 35'10"10.90 m × 32'7"9.93 m
- Upper Level
- Laundry
- 27'1"8.25 m × 18'4"5.59 m
- Basement
- Kitchen
- 46'9"14.20 m × 19'5"5.92 m
- Basement
- Living Room
- 71'1"21.70 m × 42'5"12.90 m
- Basement
- Bedroom
- 50'4"15.30 m × 43'9"13.30 m
- Basement
- Bedroom
- 51'1"15.60 m × 41'3"12.60 m
- Basement
- Laundry
- 19'2"5.84 m × 17'5.18 m
- Basement
- Furnace/Utility Room
- 37'2"11.30 m × 37'2"11.30 m
- Floor
- Ensuite
- Pieces
- Other
- Main Floor
- No
- 2
- 18'1" x 22'5"
- Upper Level
- Yes
- 5
- 28'5" x 39'1"
- Upper Level
- Yes
- 4
- 27'11" x 35'10"
- Upper Level
- No
- 4
- 20'3" x 32'7"
- Basement
- No
- 4
- 24'7" x 33'4"
- Title to Land:
- Fee Simple
- Community Features:
- Park, Playground, Schools Nearby, Shopping Nearby, Sidewalks, Street Lights, Walking/Bike Paths
- Interior Features:
- Beamed Ceilings, Built-in Features, Chandelier, Closet Organizers, Double Vanity, Elevator, French Door, High Ceilings, Kitchen Island, No Animal Home, No Smoking Home, Open Floorplan, Pantry, Quartz Counters, Recessed Lighting, See Remarks, Separate Entrance, Skylight(s), Smart Home, Soaking Tub, Stone Counters, Storage, Walk-In Closet(s), Wet Bar
- Exterior Features:
- Lighting, Other, Private Entrance, Private Yard
- Patio And Porch Features:
- Balcony(s), Deck
- Lot Features:
- Back Lane, Low Maintenance Landscape, Landscaped, Level, Rectangular Lot
- Num. of Parcels:
- 0
- Fencing:
- Fenced
- Region:
- Calgary
- Zone:
- CAL Zone CC
- Zoning:
- R-C2
- Listed Date:
- Jan 22, 2025
- Days on Mkt:
- Signup
-
Custom fabricated art/screen installation with LED features
-
Custom fabricated art/screen installation with LED features
-
Custom fabricated dual tone entryway
-
Soaring ceilings with multi-level sky light feature
-
Photo 5 of 50
-
Open concept main foyer with inlayed tile detail accented by the metal beams
-
Front formal dining room with butlers pantry
-
Front flex room/ office
-
Custom high end kitchen with luxury appliances and countertops
-
Rear patio access from kitchen
-
Photo 11 of 50
-
Custom 1 of a kind hand made light fixtures throughout
-
Dual tone luxury appliances, exotic countertops and custom brass accents make this kitchen one of a kind!
-
Photo 14 of 50
-
Photo 15 of 50
-
Built in refrigerator
-
Pass through butlers pantry to dining room
-
Butlers pantry
-
Bright and open main floor living room
-
Custom feature wall with built in shelving accented by a cozy gas fireplace.
-
Built in LED lighting throughout
-
Main floor 2 pc bathroom
-
Main floor side entry/mud room.
-
Vaulted ceiling above front foyer with additional LED accents.
-
Photo 25 of 50
-
LED accents continue upstairs
-
Primary bedroom with private ensuite, walk in closet and private balcony
-
Spa inspired ensuite bathroom
-
Relax in the Japanese inspired soaker tub
-
Beautiful walk-in shower with bench
-
Every girls dream closet!
-
Photo 32 of 50
-
Primary bedrooms private balcony
-
2nd upper level primary bedroom
-
Photo 35 of 50
-
2nd primary walkthrough closet
-
2nd primary walk-in shower
-
2nd primary ensuite bathroom
-
3 of 4 upper level bedrooms/flexrooms
-
4 of 4 upper level bedrooms/flex rooms
-
Additional full bathroom on upper level
-
1 of laundry rooms- this one located on the upper level
-
Side entry including basement suite entry
-
Legal basement suite with full kitchen
-
1 of 2 basement bedrooms
-
Basement full bathroom
-
2 of 2 basement bedrooms
-
Award winning design aesthetics throughout
-
Well appointed rear year with large deck, greenspace and easy access to the triple garage.
-
Fully finished detached triple garage with EV charger.
Larger map options:
Listed by Real Broker
Data was last updated January 30, 2025 at 04:05 AM (UTC)
Area Statistics
- Listings on market:
- 23
- Avg list price:
- $1,039,888
- Min list price:
- $209,000
- Max list price:
- $2,639,000
- Avg days on market:
- 50
- Min days on market:
- 5
- Max days on market:
- 166
- Avg price per sq.ft.:
- $520.69
These statistics are generated based on the current listing's property type
and located in
Mount Pleasant. Average values are
derived using median calculations.
- Robb Leece, REALTOR®
- Graham Realty Inc.
- 403-478-4335
- Contact by Email
- Stan Leece, Associate Broker
- Graham Realty Inc.
- 403-835-7826
- 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.
Robb Leece
robbleece@gmail.com
Direct:
403-478-4335
Fax:
403-476-5270
Graham Realty Inc.
4321 84 STREET N.E.
Calgary
AB
T1Y 7H3
CA
Featured Listing
Location: Thorncliffe
816 Thorneycroft Drive Northwest
$499,900
MLS®#: A1080703
Bedrooms: 5
Bathrooms: 3.0
ROYAL LEPAGE BENCHMARK