Robert Hinsperger & Associates

Call Direct: 403.860.2107 |

Forgot password Extend Verify Contact

623 24 Avenue NW
Mount Pleasant Calgary T2M 1X6

$1,478,800
Residential beds: 5 baths: 5.0 2,305 sq. ft. built: 2025

Main Photo: 623 24 Avenue NW in Calgary: Mount Pleasant Detached for sale : MLS®# A2200291
Photo 1: 623 24 Avenue NW in Calgary: Mount Pleasant Detached for sale : MLS®# A2200291
Photo 2: 623 24 Avenue NW in Calgary: Mount Pleasant Detached for sale : MLS®# A2200291
Photo 3: 623 24 Avenue NW in Calgary: Mount Pleasant Detached for sale : MLS®# A2200291
Photo 4: 623 24 Avenue NW in Calgary: Mount Pleasant Detached for sale : MLS®# A2200291
Photo 5: 623 24 Avenue NW in Calgary: Mount Pleasant Detached for sale : MLS®# A2200291
Photo 6: 623 24 Avenue NW in Calgary: Mount Pleasant Detached for sale : MLS®# A2200291
Photo 7: 623 24 Avenue NW in Calgary: Mount Pleasant Detached for sale : MLS®# A2200291
Photo 8: 623 24 Avenue NW in Calgary: Mount Pleasant Detached for sale : MLS®# A2200291
Photo 9: 623 24 Avenue NW in Calgary: Mount Pleasant Detached for sale : MLS®# A2200291
Photo 10: 623 24 Avenue NW in Calgary: Mount Pleasant Detached for sale : MLS®# A2200291
Status:
Active
Prop. Type:
Residential
MLS® Num:
A2200291
Bedrooms:
5
Bathrooms:
5
Year Built:
2025
COMING THIS SUMMER TO MOUNT PLEASANT! Surrounded by parks and 4th Street amenities – you won’t want to miss this PREMIUM LUXURY DETACHED home w/ over 3175 sq ft of living space. Complete w/ 4-BEDS (optional 5th bedroom in basement), SOUTH BACKYARD, high-end finishes, & luxury upgrades including eng. hardwood flooring, 10’ ceilings, & custom detailing throughout. The open-concept main floor features a HOME OFFICE with views into the main living/dining areas and an impressive, upscale kitchen. Offering custom-built cabinetry, a large central island, a flush eating bar, premium stainless- steel appliances, large pantry & a built-in custom range hood. The spacious living room enjoys an inset gas fireplace w/ tile surround & built-in cabinetry w/ large sliding glass doors that take you out to the South-facing backyard. A side mudroom w/ a bench, closet, & coat hooks keep your family organized & a gorgeous powder room finishes off the main floor. The second level hosts the primary suite featuring a vaulted ceiling, a large walk-in closet, & a 5-pc ensuite w/ dual vanity, heated floors, large glass enclosed shower, a free-standing soaker tub, & a private water closet. Two additional bedrooms have custom closets & their own 3-pc ENSUITE w/ quartz counters, an under-mount sink, & walk-in shower. The fully finished basement makes the perfect entertainment space with a large family room, wet bar w/ sink, a massive 4th bedroom w/ a walk-in closet & easy access to a 4pc bathroom. A large HOME GYM area or optional 5th bedroom nicely completes this level. This home offers a rare TRIPLE GARAGE with tandem parking, with the longest point being 48'. The garage dimensions are 20' x 24', extending to another 13' x 24' giving you and your family ample parking or an optional workshop. Mount Pleasant is a beautiful, mature community made for families & professionals alike. Outdoor activities & trips to the park are easy with Confederation Park, & the Confederation Park playground, only a few blocks away, the Queen’s Park Village Off-Leash Area a short walk away through the park. And when summertime hits, you can cool off in the community-favourite OUTDOOR POOL located right behind your house! Activities & eateries are abundant & conveniently close with easy access to North Mount Pleasant Arts Centre, 4th Spot Kitchen & Bar, Velvet Café, & Milk Ice Cream! Nearby schools include St. Joseph Elementary Junior High School & Ecole de la Rose Sauvage. Plus, commuting around the city is easy w/ 16th Ave nearby & easy navigation to 14th Street or John Laurie Blvd to get around the city! This is the perfect house and community to call home! Currently under construction with an estimated completion mid June there is still time to customize the finishes in this elegant upscale home!
Property Type:
Residential
Property Sub Type:
Detached
Condo Type:
Not a Condo
Transaction Type:
For Sale
Suite:
No
Home Style:
2 Storey
Total Living Area:
2,305.03 sq. ft.
Main Level Finished Area:
1,108.2 sq. ft.
Upper Level Finished Area:
1,196.83 sq. ft.
Below Grade Finished Area:
875.29 sq. ft.
Lot Area:
4,480 sq. ft.
Lot Frontage:
24'11"
Front Exposure:
North
Unit Exposure:
North
Levels:
Two
Total Rooms Above Grade:
7
Year built:
2025 (Age: 0)
Bedrooms:
5 (Above Grd: 3)
Bedrooms Above Grade:
3
Bedrooms Below Grade:
2
Bathrooms:
5.0 (Full:4, Half:1)
Plan:
29340
Heating:
Forced Air
Basement:
Finished, Full
Foundation:
Poured Concrete
New Constr.:
Yes
Construction Material:
Brick, Composite Siding, Concrete, Stucco, Wood Frame
Structure Type:
House
Roof:
Asphalt Shingle
Ensuite:
Yes
Flooring:
Carpet, Hardwood, Tile
Cooling:
Rough-In
Fireplaces:
1
Fireplace Details:
Gas
Garage:
1
Garage Spaces:
3
Parking:
See Remarks, Tandem, Triple Garage Detached
Parking Places:
3
Parking Total/Covered:
3 / -
Laundry Features:
Upper Level
Mount Pleasant (Calgary)
Built-In Oven, Garage Control(s), Gas Cooktop, Microwave, Range Hood, Refrigerator
N/A
Restrictive Covenant
Floor
Type
Size
Other
Main Floor
Living Room
17'8" × 12'
Main Floor
Kitchen
23' × 12'
Main Floor
Dining Room
12' × 10'
Main Floor
Office
10' × 9'6"
Main Floor
Mud Room
5'8" × 5'2"
2nd Floor
Bedroom - Primary
15'11" × 10'
2nd Floor
Walk-In Closet
8' × 6'2"
2nd Floor
Bedroom
15'1" × 9'8"
2nd Floor
Bedroom
15'1" × 9'8"
2nd Floor
Laundry
7'6" × 6'10"
Basement
Bedroom
15' × 9'
Basement
Bedroom
15' × 12'
Basement
Game Room
20' × 11'6"
Basement
Other
8'6" × 6'6"
Floor
Ensuite
Pieces
Other
Main Floor
No
2
2nd Floor
Yes
3
2nd Floor
Yes
3
2nd Floor
Yes
5
Basement
No
4
Title to Land:
Fee Simple
Community Features:
Playground, Pool, Schools Nearby, Shopping Nearby, Sidewalks, Street Lights, Walking/Bike Paths
Interior Features:
Bar, Built-in Features, Closet Organizers, Double Vanity, Kitchen Island, Open Floorplan, Recessed Lighting, Storage, Vaulted Ceiling(s), Walk-In Closet(s)
Exterior Features:
BBQ gas line, Private Yard
Patio And Porch Features:
Deck
Lot Features:
Back Yard, Low Maintenance Landscape, Rectangular Lot
Num. of Parcels:
0
Fencing:
Fenced
Region:
Calgary
Zone:
CAL Zone CC
Zoning:
R-C2
Listed Date:
Mar 11, 2025
  • Photo 1: 623 24 Avenue NW in Calgary: Mount Pleasant Detached for sale : MLS®# A2200291
    Photo 1 of 10
  • Photo 2: 623 24 Avenue NW in Calgary: Mount Pleasant Detached for sale : MLS®# A2200291
    *Photos are for inspiration purposes only, actual finishes and layouts will vary.
  • Photo 3: 623 24 Avenue NW in Calgary: Mount Pleasant Detached for sale : MLS®# A2200291
    Photo 3 of 10
  • Photo 4: 623 24 Avenue NW in Calgary: Mount Pleasant Detached for sale : MLS®# A2200291
    Photo 4 of 10
  • Photo 5: 623 24 Avenue NW in Calgary: Mount Pleasant Detached for sale : MLS®# A2200291
    Photo 5 of 10
  • Photo 6: 623 24 Avenue NW in Calgary: Mount Pleasant Detached for sale : MLS®# A2200291
    Community Photo
  • Photo 7: 623 24 Avenue NW in Calgary: Mount Pleasant Detached for sale : MLS®# A2200291
    Community Photo
  • Photo 8: 623 24 Avenue NW in Calgary: Mount Pleasant Detached for sale : MLS®# A2200291
    Community Photo
  • Photo 9: 623 24 Avenue NW in Calgary: Mount Pleasant Detached for sale : MLS®# A2200291
    Community Photo
  • Photo 10: 623 24 Avenue NW in Calgary: Mount Pleasant Detached for sale : MLS®# A2200291
    Community Photo
Listed by RE/MAX House of Real Estate
Data was last updated April 4, 2025 at 12:05 PM (UTC)
Area Statistics
Listings on market:
30
Avg list price:
$1,217,000
Min list price:
$209,000
Max list price:
$2,398,800
Avg days on market:
29
Min days on market:
1
Max days on market:
164
Avg price per sq.ft.:
$560.72
These statistics are generated based on the current listing's property type and located in Mount Pleasant. Average values are derived using median calculations.
Robert Hinsperger

Calgary Inner City Real Estate for Sale:

View Brand New Luxury Infill Homes, bungalows, walkouts, single family, condos, foreclosures, suited homes, town homes, downtown city views available. Your comprehensive guide to Calgary city center Real Estate for sale. There are dozens of neighborhoods to choose from: 


Altadore, Banff Trail, Capitol Hill, Bel-Aire, Britannia, Crescent Heights, Elboya, Elbow Park, Cliff Bungalow, Downtown Commercial Core, Hillhurst, Lower Mount Royal, Mount Pleasant, Richmond, South Calgary, Sunnyside, Upper Mount Royal


Contact Robert Hinsperger today! Urban Real Estate Services Ltd. ROBERTHINSPERGER@GMAIL.COM   Direct 403.860.2107




Central city Calgary Real Estate

Explore all central city Calgary homes for sale. With in Calgary's City Centre you'll find numerous distinct neighborhoods, including the Downtown Commercial Core,Eau Claire, Chinatown, the Beltline,East Village and the Downtown West End. For additional information about City Centre Calgary real estate listings and properties for sale or to schedule a private home showing, contact your Calgary real estate experts today!


Explore ALL REAL ESTATE FOR SALE IN CALGARY

Find today's brand-new listings, explore by number of beds, baths, type of home & lot size, listing status, days on market & more!


CALGARY PROPERTY SEARCHES

Condos

Townhomes

Luxury Homes

New Construction

Golf Course Homes

Lakefront Homes

Acreage & Country

Infill Homes

Land


Looking to buy or sell a home in City Centre Calgary? Call Robert Hinsperger

Urban Real Estate Services Ltd.

RobertHinsperger@gmail.com

www.yyc-realestate.ca

403.860.2107. Your local real estate team is here to help you navigate the central city real estate market.


Calgary City Centre Community spotlights

* The C-Train is free within the downtown core but everything is easily found within a short walk.

* An extensive inner-city bicycle path network brings all areas of the city together

* Olympic Plaza is a common meeting place with a wintertime ice rink and a summertime wading pool

* Home base of Calgary festivals such as The Big Taste Dining Festival, Funny Fest, Sled Island, Cyclepalooza and others

* TheCalgaryInternationalAirportis only a 30 minute ride onCalgary's express bus service, costing riders $8


Calgary City Centre Real Estate Agents

Buying or selling a home in central city Calgary? Let our team of Calgary real estate agents help you through the purchase of your new City Centre Calgary property or your current City Centre Calgary home. As local City Centre Calgary real estate agents and real estate agents, we have expert insider knowledge of the market dynamics unique to the City Centre Calgary real estate market. We're here to work with you today!


Contact  Robert Hinsperger

Urban Real Estate Services Ltd.

RobertHinsperger@gmail.com

www.yyc-realestate.ca

403.860.2107.


To acquire a lot more information about buyer or seller agency in City Centre Calgary. Planning to get involved in the City Centre Calgary real estate market? Ask for our CMA (comparative market analysis) form to quickly see your City Centre Calgary property economic value estimate within moments. Get more real estate statistics.


Calgary central City Real Estate

Inner-city Homes & Condos forSale

VIEW ALL communities of interests


OVERVIEW

Unique single family homes and condos abound in the Calgary central City residential areas, which a lot of the communities of interests boasts the downtown vistas. The distinct neighborhoods in every quadrants of the city offer every future home owner different selections of home ownership. Calgary Inner city living, friendly neighborhoods, close to amenities, work, shopping, downtown Calgary and easily to commute to just about everywhere, make it a popular place to live.


Calgary Inner City Real Estate

It has amazing home types, styles and sizes that make up Calgary Inner City real estate. You would think that close to the business district that houses would be small and prices high, and while luxury priced properties do dominate, there's enough variety available that you will find something for most every budget and taste. Luxury homes in this part of the city include everything from sprawling estates on acreage to penthouses in the central city. Infill homes are very popular and you'll find a significant amount of new construction, wherever older homes are being replaced by brand-new ones.

Inner City Calgary Real Estate


Inner urban centre Calgaryreal estate, condominiums, apartments and townhomes for sale plus Calgary inner city real estate maps, residential district with impressive vistas of the business district Calgary. Inner City real estate listings include newer residential areas that are being built up along the edge of the city boundaries and older more conventional neighborhoods Inner city, downtown Calgary districts. More matured areas along the Bow Riverare very popular among young professionals requiring living close to downtown.


Discover Downtown Inner City Calgary real estate homes & Apartments in some of the most picturesque Calgary neighborhoods offering up a broad range of home alternatives. Downtown Calgary homes, Condos and townhomes, flats to single family and elegant estate homes. Shopping Inner City Calgary maps is handy and walking paths are abundant. A few of our favorite Inner City Calgary residential areas include Upper Mount Royal real estate, Elbow Park, Eau Claire real estate, Renfrew, Beltline real estate plus Roxboro to name a few.



Explore Inner City Calgary real estate listings plus just listed homes for sale below. Looking to settle downtown or Inner City Calgary but curious where to start? Even if you believe you know occasionally it can be difficult to find the perfect Downtown Calgary home or Apartment, we are here to help.


Inner City Calgary real estate market statistics: As of December 6, 2019 currently 1,730 properties for sale in Inner City Calgary listed as active, with an average asking price of $747,001. The highest-priced property is $8,700,000; the lowest priced property can be purchased for around $100,000.


Inner City Calgary Homes for Sale

Find Inner City Calgary homes for sale, schools, search condos, community news, and Inner City Calgary new homes for sale.  Whether you are searching a quiet place to settle down, or you want to be close to the business district we would like to help you find that dream home.


Discover Inner City Calgary Real Estate & Community Reviews

Locate Inner Calgary real estate reviews, Inner City Calgary Community REVIEWS, statistics, Inner City Calgary community maps. As residents in Downtown Calgary will tell you this is a GREAT place to live. Extraordinary restaurants, shops, parks and of course, people! Every day we see improvements to the neighborhoods with residential district events attract more people each year.


Information for Buyers:


Calgary Inner City Public Schools:


Calgary Inner City Catholic Separate Schools:


Calgary Inner City French Immersion Schools:


Calgary Inner City Bus & C-Train Transit: Calgary Inner City Transit Route Map and Schedule

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.