3 hours on Market

404 Lillian Freiman Private, Ottawa, Ontario K2J 7K7

In the same building:
-
Condo
2
3
~1000-1199 sqft
$449,990
Get pre-qualifiedPowered by nesto
Buy with Wahi to get
Up to
$2,250Cashback
Condo
2
3
~1000-1199 sqft

Contact us about this property

Call

Highlights

Property Estimate

Days on market3 hours

Estimated valueNot available

Price/Sqft$412/sqft

Monthly cost

Open Calculator

CMA Subject Property

Curious about what homes are selling for in this area?

Get a report on comparable homes with helpful insights and trends.

+10

Properties sold*

$415K

Median sold price*

*Based on last 30 days

Description

MODEL HOME ALERT! Mattamy is releasing their fully FURNISHED Aster model home for sale, an upgraded 2-bedroom, 2.5-bath stacked townhome showcasing thousands of dollars in premium finishes. Featuring rare HERRINGBONE-PATTERN flooring throughout the second and third levels, upgraded metal railings, a designer kitchen with high-end quartz countertops, backsplash, and stainless steel appliances, plus beautifully upgraded washrooms, this home blends style with functionality. The bright open-concept living and dining area includes an upgraded electric fireplace with a TV-ready wall and patio doors leading to a private balcony, perfect for enjoying warm summer days. Upstairs, you'll find a spacious primary bedroom with a walk-in closet and a 3-piece luxury ensuite, along with a second bedroom that also includes its own 3-piece luxury ensuite and a private deck offering stunning views of the community. A conveniently located laundry room completes this level. Complete with all FURNITURE INCLUDED and 2 PARKING SPOTS, this is your chance to own a true showpiece located just steps from Barrhaven Marketplace, schools, parks, shopping, restaurants, and transit.


Property Details

StyleStacked Townhouse
View-
Age of property-
SqFt~1000-1199 SqFt
Lot Size-
Parking Spaces2
MLS ®NumberX12368521
Community NameNew Barrhaven - New Development - Stonebridge
Data SourceTRREB
Listing byROYAL LEPAGE TEAM REALTY

Features

Heating: Forced Air
Cooling: Central Air
Fireplace

3rd Floor

Bathroom

0.0 x 0.0

3 Pc Ensuite

Primary

4.11 x 2.9

2nd Br

3.3 x 2.74

Bathroom

0.0 x 0.0

3 Pc Ensuite


Features

Patio: Open
Balcony: Open

Parking

Garage spaces -

Garage type -

Total parking spaces 2


1Story
Inclusions
Hydro
Water
Parking
Cable
Heat

Property History

Aug 28, 2025
ListedActive
$449,990
3 hours on market
history photo preview16
Listing by trreb®

Market Data - New Barrhaven - New Development - Stonebridge

Geo Zone Map ThumbnailNew Barrhaven - New Development - Stonebridge

Balanced Market

View Market Data

Condo - for the past 30 days

Buyer's market Seller's market

Avg. Days on Market

Past 30 days

37 days

Compared to

2024

34 days

2023

63 days

2022

35 days

New Listings

Past 30 days

15 listings

Compared to

2024

14 listings

2023

6 listings

2022

4 listings

Units sold

Past 30 days

8 units

Compared to

2024

10 units

2023

3 units

2022

2 units

Median Sold Price

Past 30 days

$428,250

Compared to

2024

$415,000

2023

$416,000

2022

$382,500


Population and Demographics

Overview

Total population 60491
Average household income $148,943

Age (%)

0 to 19
29%
20 to 34
19%
35 to 49
23%
50 to 64
18%
65 and plus
11%

Household composition (%)

Single family
79%
Single person
17%
Multi person
4%
Multi family
1%

Mother tongue (%)

English
63%
Arabic
7%
French
7%
Mandarin
7%
Others
3%
Yue (Cantonese)
2%
English and French
2%
Urdu
1%
Punjabi (Panjabi)
1%
Spanish
1%

House tenancy (%)

Owners
78%
Renters
22%

What’s nearby?Essentials within 5 km

Local Logic

Transportation Scores

Estimated Budget