• Find Your Next Property
    Find Your Next Property
    Want an even more powerful MLS® search experience?
    Scroll down to find out how
Forgot password Extend Verify Contact

628-629 Stanley Street
Esterhazy Esterhazy S0A 0X0

$499,000
Residential beds: 6 baths: 4.0 1,954 sq. ft. built: 1967

#628 Stanley St. Front view of the duplex
Photo 1: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 2: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 3: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 4: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 5: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 6: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 7: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 8: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 9: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 10: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 11: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 12: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 13: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 14: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 15: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 16: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 17: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 18: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 19: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 20: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 21: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 22: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 23: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 24: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 25: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 26: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 27: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 28: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 29: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 30: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 31: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 32: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 33: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 34: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 35: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 36: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 37: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 38: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 39: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 40: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 41: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 42: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 43: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 44: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 45: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 46: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 47: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 48: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 49: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Photo 50: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
Status:
Active
Prop. Type:
Residential
MLS® Num:
SK993803
Bedrooms:
6
Bathrooms:
4
Year Built:
1967
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.
Bedrooms:
6
Number of bathrooms:
4.0
Kitchens:
2
Taxes:
$2,001 / 2024
Frontage:
68'
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' × 4'
Laminate
Main
Living Room
13'7" × 13'6"
Laminate
Main
Kitchen
13'3" × 11'7"
Laminate
Main
Porch
5' × 4'2"
Laminate
Main
Kitchen
13'4" × 11'
Ceramic
Main
Living Room
14' × 13'7"
Ceramic
Main
Foyer
4' × 3'4"
Ceramic
Main
Porch
5'4" × 4'2"
Ceramic
2nd
Bedroom
10'3" × 9'8"
Laminate
2nd
Bedroom
13'4" × 8'6"
Laminate
2nd
Bedroom
9'11" × 8'4"
Laminate
2nd
Bedroom
10'3" × 9'4"
Carpet
2nd
Bedroom
13'4" × 8'5"
Carpet
2nd
Bedroom
9'8" × 8'5"
Carpet
Basement
Recreation Room
16'4" × 11'10"
Laminate
Basement
Laundry In Utility
11'7" × 8'5"
Ceramic
Basement
Recreation Room
16'4" × 11'
Carpet
Basement
Laundry In Utility
11'7" × 8'5"
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
Lot Size:
7,480 sq. ft.
Lot Shape:
Rectangular
Garage:
No Garage, Parking Spaces
Parking Places:
4.0
Parking Surface:
Asphalt, Single Drive
Date Listed:
Days on Mkt:
  • Photo 1: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    #628 Stanley St. Front view of the duplex
  • Photo 2: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    628 Stanley St. West entrance into livingroom
  • Photo 3: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    Open concept livingroom and kitchen area
  • Photo 4: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    Photo 4 of 50
  • Photo 5: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    Photo 5 of 50
  • Photo 6: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    A direct line of view from the livingroom to the kitchen with an open well-lit staircase to the second level
  • Photo 7: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    Designed with the comfort of luxury and functionality
  • Photo 8: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    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: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    Photo 9 of 50
  • Photo 10: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    Streamlined spacious kitchen
  • Photo 11: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    2nd storey main bath
  • Photo 12: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    Bedroom #1 - designed for your comfort
  • Photo 13: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    Bedroom #1
  • Photo 14: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    Bedroom #2
  • Photo 15: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    Bedroom #3
  • Photo 16: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    Hallway design
  • Photo 17: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    Photo 17 of 50
  • Photo 18: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    Basement rec room fully finished
  • Photo 19: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    Basement bathroom
  • Photo 20: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    Basement bathroom
  • Photo 21: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    Laundry in utility room
  • Photo 22: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    Hallway from bathroom to the rec room
  • Photo 23: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    Photo 23 of 50
  • Photo 24: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    Photo 24 of 50
  • Photo 25: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    #629 Stanley St (North side of the duplex)
  • Photo 26: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    Unit #629 -kitchen
  • Photo 27: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    Unit #629 - kitchen
  • Photo 28: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    Unit #629 - kitchen
  • Photo 29: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    Photo 29 of 50
  • Photo 30: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    Photo 30 of 50
  • Photo 31: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    Photo 31 of 50
  • Photo 32: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    Unit #629 -open concept floor plan encompassing livingroom, kitchen & stairwell to the 2nd storey
  • Photo 33: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    Photo 33 of 50
  • Photo 34: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    Photo 34 of 50
  • Photo 35: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    Photo 35 of 50
  • Photo 36: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    2nd storey bath
  • Photo 37: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    2nd storey hall
  • Photo 38: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    2nd storey hall
  • Photo 39: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    Bedroom #1 - 2nd storey
  • Photo 40: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    Bedroom #1 - 2nd storey
  • Photo 41: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    Photo 41 of 50
  • Photo 42: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    Bedroom #2 - second storey
  • Photo 43: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    Bedroom #3- second storey
  • Photo 44: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    Stairwell to basement
  • Photo 45: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    Unit #629 - Rec room
  • Photo 46: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    Photo 46 of 50
  • Photo 47: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    Photo 47 of 50
  • Photo 48: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    Photo 48 of 50
  • Photo 49: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    Unit #629 basement 3 pc bath
  • Photo 50: 628-629 Stanley Street in Esterhazy: Residential for sale : MLS®# SK993803
    Unit #629 basement 3 pc bath
Listed by RE/MAX Revolution Realty
Data was last updated March 3, 2025 at 03:35 PM (UTC)
Area Statistics
Listings on market:
24
Avg list price:
$222,250
Min list price:
$49,000
Max list price:
$699,000
Avg days on market:
222
Min days on market:
1
Max days on market:
304
Avg price per sq.ft.:
$188.54
These statistics are generated based on the current listing's property type and located in Esterhazy. Average values are derived using median calculations.

Get all the benefits below, by registering today. A better MLS® search and advantage over other buyers and sellers.

Finding real estate should be a joy

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.