888 Cresta Rider Place, Newmarket

$1,999,000
888 Cresta Rider Place

$1,999,000

New
6d
Detached2-Storey

888 Cresta Rider Place, Newmarket

Total Monthly Obligation $9,246

Beds
5
Baths
4
Park
2
Sqft
3500-5000
DOM
6d
Score
14
Yield
2.4%
Cash on Cash
-13.1%
Cap Rate
1.8%
5Y IRR
5.4%
10Y IRR
6.7%
Property Type-Detached
MLS® Number-N14171284
Beds-5
Bathrooms-4
Size-3500-5000 sqft
Lot Size-64.54 × 133.8 ft
Listed on site-Nov 11, 2026
Style-2-Storey
Building Type-Detached
Taxes-$9,686.73 (2026)
Parking-4 - Built-In
Basement-Finished
Heating-Forced Air (Gas)
Brokerage-SAGE REAL ESTATE LIMITED
Cooling-Central Air
Laundry-No
Fireplace-Natural Gas
Pool-None
Facing-South
Exterior-Brick
Roof-Shingles
Foundation-Poured Concrete
Sewer-Sewer
Possession-60 days
Neighbourhood-Stonehaven-Wyndham
Title-Residential Freehold

No agent assigned

Welcome to 888 Cresta Rider Place, an exceptional executive residence tucked away on a quiet court in prestigious Stonehaven. Offering approximately 5,500 sq. ft. of total living space, including a finished lower level, this elegant 4+1 bedroom, 4 bathroom home showcases timeless craftsmanship, luxurious upgrades and a functional family layout. A grand entrance and Piano Foyer set the tone with marble flooring, custom inlaid hardwood, wainscoting, crown moulding, an open octagonal ceiling and an elegant staircase. Formal principal rooms feature refined millwork, coffered ceilings, oversized bay windows and rich hardwood flooring throughout. The sunken family room is ideal for everyday living and entertaining with a gas fireplace, custom built-ins and walkout to the covered deck and hot tub. At the heart of the home is a custom chef-inspired kitchen complete with premium JennAir stainless steel appliances, Cambria Quartz countertops, large centre island, breakfast bar, soft-close cabinetry and seamless access to the backyard oasis. The upper level offers four spacious bedrooms, including a luxurious primary retreat with French door entry, hardwood flooring, custom walk-in closet and spa-inspired 5-piece ensuite with glass shower, oversized soaking tub and dual sinks. A second-floor study offers flexibility as a potential fifth bedroom, den or home office. The lower level features a large recreation area, wet bar, 3-piece bathroom, extensive storage and versatile living space ideal for entertaining, guests, fitness or multi-generational living. Outside, the beautifully landscaped and fully fenced backyard offers a newer composite deck with covered seating areas, custom lighting and a private 6-person hot tub retreat. Complete with a double-car garage and double private driveway, this exceptional home is located minutes from top-rated schools, parks, trails, shopping, dining, golf and Highway 404.

$
$
%
%
$
$
$
(utilities, internet...)
$
%
%

Closing Costs

Mortgage Amount
$1,599,200
Land Transfer Taxes$36,455
Legal Fees (Est.)
$
Total cash required for closing$437,755

Total Monthly Obligation

$9,246/mo
Mortgage $8,063
Monthly Loss $7,124
Principal$2,122
Interest$5,942
Property Tax$807
Home Insurance$125
Variable Costs$250
Returns
Weight: 25%
Cap Rate
1.5%9
Cash-on-Cash
-15.8%0
5-Year IRR
3.2%7
10-Year IRR
5.4%
Returns Index
4.6/ 100
Growth Sentiment
Weight: 20%
%/yr
Score+50
%/yr
Score+50
%
%
Growth Index
50.0/ 100
GradeD
14/ 100
Avoid•Pass

Strategy: Buy & Hold — Weights: CFI 35% · RI 25%
RKI 20% · GI 20%

Assumptions & Inputs
$/mo
%
$
yr
%
Cash Flow
Weight: 35%
Gross Rent
$48,000/yr
NOI
$29,013/yr
Net Cash Flow
-$5,646/mo
Cash Margin
-141.1%0
Cash Flow Index
0.0/ 100
Risk Profile
Weight: 20%
DSCR
0.302
LTV Ratio
80.0%18
Vacancy Buffer
1.1 mo17
Risk Index
12.6/ 100

*This analysis is independently generated NOT provided by TREB or CREA.

Comparables

Properties near 888 Cresta Rider Place

Time

Comparables are calculated within a 3km radius based on properties sold or leased within the past 6 months. This helps you understand the current market value and potential rental yield with high precision.

Data is provided courtesy of PropTx.

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

Listing information is deemed reliable but not guaranteed accurate by PropTx or TRREB.

REALTOR®, REALTORS®, and the REALTOR® logo are certification marks owned by REALTOR® Canada Inc. and licensed exclusively to the Canadian Real Estate Association (CREA).

The MLS® trademark and MLS® logo are owned by CREA and identify the quality of services provided by real estate professionals who are members of CREA.

Data last updated within the past 24 hours.