TOP UP YOUR INVESTMENT PORTFOLIO with this remarkable investment opportunity at #628 & #629 Stanley St, in Esterhazy.
This exceptional 1967-built duplex spans 1,954 sq ft, has been meticulously renovated with modern updates. Each unit offers an exquisite living experience, featuring amenities that cater to the discerning homeowner. From the foyer to the state-of-the-art kitchen, every space has been thoughtfully designed to enhance daily life. The Units boat spacious interiors flooded with natural light, creating an atmosphere of warmth and style. Unit 628: Features a bright kitchen with ample white cabinetry.Unit 629: Highlights a sleek kitchen with dark cabinetry.Both units include BI ovens, cooktop stoves, microwave range hoods, BI dishwashers, central AC, central vac and so much more! The open-concept design connects the kitchen to the living room, complemented by illuminated open staircase (Unit #628) . The second floor in each unit has 3 bdrms & 4-piece bath. Fully finished basements provide a spacious & comfortable rec room, 3pc bath & laundry in the utility room. Each unit features a single drive, deck /patio area with privacy divider & is fully fenced.This property is a standout opportunity for comfortable living or better yet, an investment opportunity. Duplexes are a manageable entry point into real estate investing & can serve as a foundation for building a rental portfolio. It is a versatile & cost effective choice for generating passive income.The location of #628 & #629 Stanley St in Esterhazy impacts market value by its community appeal, proximity to amenities and investment potential. The investment potential offers a diverse tenant appeal for families or professionals as well as enhancing revenue streams to rent out both units separately compared to single use properties.This is a turn-key investment opportunity. Don't miss this one-of-a-kind rental income opportunity. Furnishings are included with the list price. Turn-key is an understatement!
Listing Area:
Esterhazy
Property Type:
Residential
Property Sub Type:
Attached
Building Type:
Duplex (both units)
Home Style:
2 Storey
Year built:
1967
(Age: 58)
Total Floor Area:
1,954 sq. ft.182 m2
Bedrooms:
6
Number of bathrooms:
4.0
Kitchens:
2
Taxes:
$2,001 /
2024
Frontage:
68'20.7 m
Ownership Title:
Freehold
Heating:
Forced Air, Natural Gas
Furnace:
Furnace Owned
Fireplaces:
0
Water Heater:
Included
Water Heater Type:
Gas
Water Softener:
Included
Construction:
Wood Frame
Basement:
Full Basement, Fully Finished
Basement Walls:
Concrete
Roof:
Asphalt Shingles
Exterior Finish:
Siding, Other
Air Conditioner (Central), Sump Pump, T.V. Mounts
Deck, Fenced, Lawn Back, Lawn Front, Trees/Shrubs
Recreation Usage: No, Separate Basement Entry: No
Floor
Type
Size
Other
Main
Foyer
7'2.13 m × 4'1.22 m
Laminate
Main
Living Room
13'7"4.14 m × 13'6"4.11 m
Laminate
Main
Kitchen
13'3"4.04 m × 11'7"3.53 m
Laminate
Main
Porch
5'1.52 m × 4'2"1.27 m
Laminate
Main
Kitchen
13'4"4.06 m × 11'3.35 m
Ceramic
Main
Living Room
14'4.27 m × 13'7"4.14 m
Ceramic
Main
Foyer
4'1.22 m × 3'4"1.02 m
Ceramic
Main
Porch
5'4"1.63 m × 4'2"1.27 m
Ceramic
2nd
Bedroom
10'3"3.12 m × 9'8"2.95 m
Laminate
2nd
Bedroom
13'4"4.06 m × 8'6"2.59 m
Laminate
2nd
Bedroom
9'11"3.02 m × 8'4"2.54 m
Laminate
2nd
Bedroom
10'3"3.12 m × 9'4"2.84 m
Carpet
2nd
Bedroom
13'4"4.06 m × 8'5"2.57 m
Carpet
2nd
Bedroom
9'8"2.95 m × 8'5"2.57 m
Carpet
Basement
Recreation Room
16'4"4.98 m × 11'10"3.61 m
Laminate
Basement
Laundry In Utility
11'7"3.53 m × 8'5"2.57 m
Ceramic
Basement
Recreation Room
16'4"4.98 m × 11'3.35 m
Carpet
Basement
Laundry In Utility
11'7"3.53 m × 8'5"2.57 m
Ceramic
Floor
Ensuite
Pieces
Other
2nd
No
4
4'10" x 8'3" Ceramic
2nd
No
4
4'10" x 8'4" Ceramic
Basement
No
3
4'7" x 7'8" Ceramic
Basement
No
3
4'7" x 7'8" Ceramic
Occupancy:
Vacant
Equipment Included:
Fridge, Stove, Washer, Dryer, Central Vac Attached, Central Vac Attachments, Dishwasher Built In, Microwave Hood Fan, Oven Built In, Reverse Osmosis System, Vac Power Nozzle, Window Treatment
A direct line of view from the livingroom to the kitchen with an open well-lit staircase to the second level
Designed with the comfort of luxury and functionality
Lighting is breathtaking with the abundance of potlightling and natural light flowing from the livingroom and kitchen. Plenty of kitchen cabinetry with ample storage space and built in oven, microwave range hood fan, BI dishwasher and fridge.
Photo 9 of 50
Streamlined spacious kitchen
2nd storey main bath
Bedroom #1 - designed for your comfort
Bedroom #1
Bedroom #2
Bedroom #3
Hallway design
Photo 17 of 50
Basement rec room fully finished
Basement bathroom
Basement bathroom
Laundry in utility room
Hallway from bathroom to the rec room
Photo 23 of 50
Photo 24 of 50
#629 Stanley St (North side of the duplex)
Unit #629 -kitchen
Unit #629 - kitchen
Unit #629 - kitchen
Photo 29 of 50
Photo 30 of 50
Photo 31 of 50
Unit #629 -open concept floor plan encompassing livingroom, kitchen & stairwell to the 2nd storey
Data was last updated April 2, 2025 at 05:35 PM (UTC)
Area Statistics
Listings on market:
22
Avg list price:
$239,000
Min list price:
$99,000
Max list price:
$699,000
Avg days on market:
230
Min days on market:
21
Max days on market:
334
Avg price per sq.ft.:
$194.27
These statistics are generated based on the current listing's property type
and located in
Esterhazy. Average values are
derived using median calculations.
The Saskatchewan REALTORS® Association (SRA) IDX Reciprocity listings are displayed in
accordance with SRA's MLS® Data Access Agreement and are copyright of the Saskatchewan REALTORS® Association (SRA).
The above information is from sources deemed reliable but should not be relied upon without independent verification.
The information presented here is for general interest only, no guarantees apply.
Trademarks are owned and controlled by the Canadian Real Estate Association (CREA).
Used under license.
MLS® System data of the Saskatchewan REALTORS® Association (SRA) displayed on this site is refreshed every 2 hours.