Homula Realty Brokerage
The information provided herein must only be used by consumers that have a bona fide interest in the purchase, sale, or lease of real estate and may not be used for any commercial purpose or any other purpose.

699 Castleguard Crescent, Burlington, ON L7N 2W7

2+1 beds · 2 baths · 1+1 kitchens · 6+4 rooms · 5 parking spaces · 1100-1500 sq ft · Detached
$1,199,999
Property tax
$4,975 / year

Incredible Blue-Chip Investment Opportunity. Beautifully fully renovated two-unit income property. Exceptional opportunity for investors seeking a turnkey sale-leaseback investment (1100+sf upper, 900+sflower). Updated from top to bottom combines strong income potential with outstanding quality and long-term value. Located on a quiet, newly paved crescent. Bright open-concept design. Stunning fully renovated kitchen. Extensive upgrades: waterproofing, excellent insulation for lower utility costs, high quality sound insulation between upper/lower units for enhanced comfort and privacy. Luxurious walk-in laundry and dressing room, complete with elegant French pocket doors, a built-in wardrobe, integrated hamper, and an abundance of thoughtfully organized storage. Beautifully landscaped property featuring a private mature backyard, large beautiful mature maple tree, raised-bed gardens, a spacious shed with power, interior and exterior lighting, a stylish deck with an enclosed tree, privacy wall, and sleek black metal railing. Additional features: 4-car driveway, spacious garage. Unbeatable location minutes from Downtown Burlington, convenient access to the GO Train Station. Restaurants, major shopping centre, and several grocery stores within 1 km Access to the QEW in 5 short minutes. Excellent selection of public, catholic, and private primary and secondary schools all within approximately 1 km. Purchase as Sale-Leaseback with agree upon main level lease OR normal purchase with no tenants. Min 5% deposit. *For Additional Property Details Click The Brochure Icon Below*

MLS number
W13645700
Type
Detached
Status
Active
Bedrooms
3
Bathrooms
2
Postal code
L7N 2W7
Photos
26
Laundry
Not in the unit
39days · this listing
Total days on market across every earlier listing of this propertyRegistration and sign-in required

This listing’s own days on market are shown above. How long the property has been for sale across every earlier listing is drawn from records the board releases only to registered users — a free account opens it, along with the sale history below.

Listing history

No previous listings found for this address.

Where this property is

Where this address sits, matched against open government data.

Matched to a published address point for this address.

Schools

The school boundaries this address is inside, and the schools nearest it. Boards redraw boundaries and cap programs — confirm with the board before this affects a decision.

Other schools nearby

By distance from this address, not school boundary — a school 400 m away can be in another school’s attendance area.

SchoolLevelDistanceRating
Assumption Catholic Secondary School
Halton CDSB
Secondary198 m7.8 / 10
78% met the standard · 2 of 6 measures
Tecumseh Public School
Halton DSB
Elementary438 m5.9 / 10
59% met the standard
St. Paul Catholic Elementary School
Halton CDSB
Elementary442 m8.4 / 10
84% met the standard
Ashwood GlenElementary763 mNot reported
Makwendam Public School
Halton DSB
Elementary637 m8.4 / 10
84% met the standard
Fairview Glen MontessoriElementary839 mNot reported
How the rating is calculated

EQAO — Ontario’s testing agency — publishes, for each school, the percentage of students meeting the provincial standard in Grade 3 and Grade 6 reading, writing and mathematics. The rating is the average of those percentages divided by ten. A school where 72% of students met the standard rates 7.2 out of 10.

Nothing is weighted or adjusted, and schools are not ranked against each other. Where EQAO withholds a result to protect the privacy of a small group of students, that measure is left out rather than counted as zero — so a rating built on fewer than six measures says so.

What it does not measure. It is one year of standardised testing in three subjects. It says nothing about teaching, programs, or whether a school suits a particular child, and it tracks neighbourhood household income closely enough that it partly measures the neighbourhood rather than the school. Treat it as one figure among many.

Source: Ontario Ministry of Education, School Information and Student Demographics (2024–25), Open Government Licence – Ontario.

H-Value

our estimate of this home is for registered usersWhat comparable homes nearby actually sold for, worked into an estimate for this one — with the range it sits in and how far the method has been off in testing.Create a free accountAlready have one? Sign in.

What an H-Value is and how it is calculated — the method and our measured error, no account needed.

The market around this home

Detached houses in Roseland181 sales over the last five years.

Median sold priceWhat comparable homes actually sold for
$1.09M$1.32M$1.54M20252026this home’s asking price
$1.53Mlatest quarter · hover to read any
Sold vs askingAbove 100% means bidding wars were normal
96%98%100%20252026the asking price
98%latest quarter · hover to read any
Days to sellMedian days on market before the deal closed
0d12d24d20252026
20dlatest quarter · hover to read any
How these are built, and what they cannot tell you

Each point is the median of the sales that closed in that quarter among detached houses in roseland. A quarter with fewer than eight is left out rather than drawn, and the line breaks where that happens — a median over three sales is really one home’s price, and joining across a gap would draw a number nobody measured.

This is not an estimate of what this home is worth. The segment is a property type in an area; it takes no account of this home’s size, condition, renovations, lot, exposure or how it compares to its neighbours, and half the homes in any quarter sold for more than the median and half for less. It is context for a conversation with an agent, not a valuation.

Toronto Regional Real Estate Board closed transactions. Deemed reliable but not guaranteed accurate by PropTx.

This neighbourhood

Statistics Canada 2021 Census, for the surrounding few blocks — about 915 people.

$92,000Median household income
28.1%Own their home
25%Detached houses
37.2Median age
18.5%Born outside Canada
21.6%University degree

The neighbourhood, by the census

Statistics Canada 2021 Census for dissemination area 35240594 — the few blocks around this address, home to 915 people. It describes the area, not this property.

915Population
37.4Average age
3.1Household size
$111,000Average household income
$92,000Median household income
28%Own their home
72%Rent
0%Condominiums
19%Born outside Canada
22%University degree
$960,000Average home value
9%Low income
47%Not in the labour force
33%Never married
$20,000 to $24,9991%
$25,000 to $29,9991%
$30,000 to $34,9991%
$35,000 to $39,9992%
$40,000 to $44,9991%
$45,000 to $49,9993%
$50,000 to $59,9995%
$60,000 to $69,9995%
$70,000 to $79,9997%
$80,000 to $89,9997%
$90,000 to $99,9995%
$100,000 and over31%
$100,000 to $124,99914%
$125,000 to $149,9996%
$150,000 to $199,9996%
$200,000 and over5%

Percentages are of the 430 responses in this category. Statistics Canada rounds counts and withholds small ones to keep individuals unidentifiable, so categories with too few people to publish are absent rather than shown as zero.

Source: Statistics Canada, 2021 Census of Population. Contains information licensed under the Open Government Licence – Canada.

Work out the numbers

Everything below is calculated in your browser from figures you can change. Nothing is sent anywhere.

$240,000 · minimum here is $95,000
$5,313.33per month
Borrowed before insurance$959,999
Total borrowed$959,999
Interest over 25 years at 4.5%$634,001

If you rented it out

-$5,727.92per month out of pocket
Rent$0.00
Everything it costs to hold$5,727.92
How this is calculated, and what it leaves out

Canadian fixed-rate mortgages compound semi-annually, not monthly, so the monthly rate here is (1 + rate/2)1/6 − 1. Most calculators use rate ÷ 12, which is the American convention and overstates the payment by tens of dollars a month.

Below 20% down, default insurance is mandatory and is added to the loan rather than paid at closing: 2.80% at 85% loan-to-value, 3.10% at 90%, 4.00% at 95%. It is unavailable at or above $1.5M, which is why 20% is a hard floor there.

Not included: vacancy, property management, capital repairs, income tax, and the fact that a lender qualifies you at a stress-test rate rather than the one you are quoted. This is arithmetic on the numbers above, not a mortgage approval or an opinion of what you can afford.

Listed by ICI SOURCE REAL ASSET SERVICES INC.. Listing data provided by the Toronto Regional Real Estate Board.