We use cookies for basic analytics + follow-up. Privacy
We remember this notice, run basic analytics, and use account activity like saved homes and listing views to provide real-estate follow-up. Privacy.
Swipe through similar matches — tap the heart to save, or open one for the full read.
203 2 Street NE
RARE RIVERFRONT RETREAT ON BEARBERRY CREEK & THE RED DEER RIVER. This exceptional property backs directly onto Bearberry Creek and the Red Deer River, offering a setting that feels more like an acreage than an in-town residence. Enjoy outstanding privacy, beautiful views, abundant wildlife, and direct access to walking trails, fishing, and recreation right from your backyard.This impressive 1,776 sq. ft. walkout bungalow features 4 bedrooms, 3.5 bathrooms, and 3 kitchens, creating endless possibilities for entertaining, extended family living, hobbies, or home-based pursuits. Numerous upgrades throughout the home have been designed to enhance both comfort and lifestyle.The bright open-concept floor plan is flooded with natural light and showcases hardwood and luxury vinyl plank flooring, recessed pot lighting, and distinctive custom finishes throughout. The custom oak kitchen features a granite sink, décor drawers, cupboard transoms, and unique salamander hardware that perfectly complement the home’s western character. Guests will naturally gather around the breakfast bar island while you prepare meals on the built-in commercial gas range. The dining area opens onto a massive southeast-facing deck with glass railings, allowing you to fully appreciate the spectacular views of the park, creek, and surrounding greenspace. Relax in the hot tub and enjoy beautiful sunrises and the peaceful sounds of nature from your own private retreat. The primary suite is truly extraordinary, featuring hardwood flooring, vaulted ceilings, three skylights, and numerous windows overlooking the park and creek. The adjoining dressing room offers extensive organized storage, mirrored walls, and abundant closet space.The fully developed walkout lower level includes a second kitchen, fourth bedroom, additional bathrooms, extensive storage, and a versatile bonus room complete with a third kitchen—perfect for wine making, hobbies, crafts, or additional workspace. The sunroom walks out to the beautifully landscaped backyard featuring a custom-built stone patio and firepit area.The oversized 400 sq. ft. attached garage is finished with durable epoxy flooring. Additional front parking and RV parking provide plenty of space for vehicles and recreational equipment.Beautifully landscaped with mature fruit trees, evergreen hedges, and stone flower beds. Located in one of Sundre’s most desirable neighborhoods, just one block from the schools, swimming pool, arena, and recreational facilities. Step out your door to enjoy fishing, walking trails, and all the natural beauty this unique location has to offer.This is a truly one-of-a-kind home in an extraordinary setting. Book your private viewing today!Seller is a licensed Associate Broker in the province of Alberta (id:65958)
Lower level
| Room | Dimensions | Features |
|---|---|---|
| Great room | 18.50 Ft x 21.17 Ft | |
| Bedroom | 12.33 Ft x 10.17 Ft | |
| Kitchen | 5.50 Ft x 10.58 Ft | |
| 4pc Bathroom | 6.75 Ft x 6.50 Ft | |
| Furnace | 9.17 Ft x 10.58 Ft | |
| 2pc Bathroom | 4.75 Ft x 7.83 Ft | |
| Storage | 11.33 Ft x 10.83 Ft | |
| Bonus Room | 14.83 Ft x 22.42 Ft | |
| Office | 23.50 Ft x 9.33 Ft | |
| Other | 5.58 Ft x 13.58 Ft |
Main level
| Room | Dimensions | Features |
|---|---|---|
| Bedroom | 8.92 Ft x 11.40 Ft | |
| Living room | 133.67 Ft x 14.92 Ft | |
| Kitchen | 17.58 Ft x 20.67 Ft | |
| 4pc Bathroom | 4.92 Ft x 7.92 Ft | |
| Dining room | 11.58 Ft x 8.17 Ft | |
| 3pc Bathroom | 6.83 Ft x 7.42 Ft | |
| Bedroom | 13.42 Ft x 11.25 Ft | |
| Primary Bedroom | 14.92 Ft x 22.83 Ft | |
| Other | 13.92 Ft x 10.25 Ft |
10-item due-diligence checklist. We can pre-flight most of these for you on a CMA call.
Comparable sales
Ask for 3–5 recent solds within ~1 km and the same beds/baths so the list price has context.
Property condition
Roof age, furnace age, hot-water tank age, electrical panel size, windows. Cosmetic vs structural.
Zoning
Confirm zoning matches your intent (single-family vs duplex vs secondary suite vs commercial).
Suite legality / potential
If suited or being marketed as suited: confirm permits, separate entrance, ceiling height, egress windows.
Monthly carrying cost
Mortgage + property tax + insurance + condo fee (if any) + utilities. Compare to your max budget.
Property taxes
Confirm the annual tax amount on the current assessment — and whether a reassessment is pending.
Insurance estimate
Get a same-day quote. Older homes, knob-and-tube wiring, polybutylene plumbing, flood plains all change the number.
Commute
Drive it (or transit it) at the actual time of day you'd commute. Map ETA lies during peak hours.
Deposit and financing conditions
Deposit size, financing condition window, condition removal date, possession date — all negotiable.
Inspection considerations
Budget for a home inspector ($500–700) and any specialty inspections (sewer scope, mould, asbestos for pre-1990 builds).
Cash on cash
-0.97%
Cap rate
4.67%
GRM
13.9
Break-even rent
$4,627
Financing
Operating expenses (monthly)
Save this analysis — go Pro (free)
Approximation only. Actual cash flow depends on financing terms, condition reports, current market rents, property tax assessment, condo fees, and tenant quality. Defaults: 4.5% rate, 30-year amortization, 5% vacancy, 1%/yr maintenance, 0.5%/yr CapEx reserve, $80/mo insurance. Property tax estimated at 0.55%/yr where not provided. Talk to a mortgage broker before relying on these numbers.
Pick a down payment and tap any underlined number to edit. Total updates live. Confirm with a mortgage broker before writing an offer.
Monthly carrying costs (shared)
Approximation only. CMHC default insurance is included when down payment is under 20%. Property tax and condo fees come from MLS when listed and may not reflect the current billing year. Accelerated bi-weekly frequency reduces total interest paid vs. monthly — confirm with a broker. Suite rental income depends on permits, market rent, and vacancy. Always validate with a mortgage broker before writing an offer.
We'll reply by text within a few hours. Comparable sales, condition flags, things worth checking — sent before you book a showing.
Listing brokerage
Listing brokerage on file
Listing data via CREA DDF®. Information is deemed reliable but not guaranteed accurate by CREA. Last updated Jun 13, 2026.
Location of this listing. Distances are straight-line.
Full neighbourhood intelligence (schools, halal, mosques, transit) is still building for this address.
Buyer-fit signals
Derived from listing data and nearby-amenity proximity. Verify anything that matters to your decision — distances are approximate.