572004 Highway 857
None Rural Two Hills County T0B 4R0

$749,000
Country Residential beds: 4 baths: 2.0 1,574 sq. ft. built: 1942

Stucco exterior residence featuring a dark shingle roof, white trim accents, and stone detailing around the foundation
Photo 1: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 2: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 3: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 4: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 5: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 6: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 7: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 8: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 9: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 10: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 11: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 12: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 13: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 14: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 15: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 16: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 17: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 18: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 19: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 20: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 21: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 22: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 23: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 24: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 25: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 26: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 27: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 28: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 29: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 30: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 31: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 32: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 33: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 34: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 35: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 36: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 37: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 38: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 39: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 40: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 41: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 42: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 43: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 44: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 45: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 46: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 47: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 48: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 49: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 50: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 51: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 52: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 53: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 54: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 55: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 56: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 57: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 58: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 59: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 60: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 61: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 62: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 63: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 64: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 65: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 66: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 67: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 68: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 69: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 70: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 71: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Photo 72: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
Status:
Active
Prop. Type:
Country Residential
MLS® Num:
E4492323
Bedrooms:
4
Bathrooms:
2
Year Built:
1942
* Sold date and price are as reported on the RAE’s MLS® system
Opportunity meets charm on this meticulously maintained 6-acre acreage with prime highway frontage—ideal for a home-based business, hobby farm, or anyone needing exceptional shop space! The character-filled 4-bedroom home features a country kitchen, original hardwood floors, coved ceilings, and a classic clawfoot tub. Two bedrooms are located on the main floor, with a spacious upper-level bedroom and a fully finished basement offering a family room, second bathroom, 4th bedroom, and abundant storage. Outside, you'll find an impressive 40' x 60' heated shop with a 34' x 28' addition, concrete floors throughout, and a 2-post hoist included. A detached garage has been converted into a fantastic games and entertaining space. Additional features include a barn, pole barn, 2 chicken coops, and 3 bored wells servicing the house, shop, and yard irrigation separately. A rare, versatile property in an unbeatable location!
From Andrew, head East on Highway 45 turn left onto Highway 645 then left onto 857. Property will be on the left.
Property Type:
Country Residential
Dwelling Type:
Detached Single Family
Home Style:
1 and Half Storey
Total Floor Area:
1,574.24 sq. ft.
Price Per SqFt:
$475.79
Total area above grade.:
1,574 sq. ft.
Secondary Suite:
No
Second Residence:
No
Lot Area:
5.93 acre(s)
Grade Level Entry:
No
Levels:
3
Year built:
1942 (Age: 84)
Bedrooms:
4 (Above Grd: 3)
Bathrooms:
2.0 (Full:2/Half:0)
Total Rooms Above Grade:
6
Plan:
9322495
Building Type:
Detached Single Family
Exterior Finish:
Stucco
Power Service:
Paid For
Heating Source Desc:
Paid For
Construction:
Wood
Foundation:
Concrete Perimeter
Basement:
Full, Finished
Basement Development:
Fully Finished
Floor Finish:
Hardwood
Heating:
Forced Air-1, Natural Gas
Parking:
Double Garage Detached, Shop, See Remarks
Garage:
Yes
Ensuite:
No
Phone Desc:
Paid
Water Supply:
Bored Well
Water Paid For:
Paid For
Sewer Septic:
Gravity, Holding Tank
See Remarks
None
Landscaped, See Remarks
Landscaped, See Remarks
Dishwasher-Built-In, Dryer, Refrigerator, Stove-Electric, Washer, Window Coverings
Caveat on Title, Utility Right Of Way
Private
Floor
Type
Size
Other
Main
Living Room
Measurements not available
-
Main
Dining Room
Measurements not available
-
Main
Kitchen
Measurements not available
-
Basement
Family Room
Measurements not available
-
Floor
Ensuite
Pieces
Other
Main
No
3
Basement
No
3
Seller Rights Reserved:
No
Zone:
Zone 60
Zoning:
Zone 60
Title to Land:
Fee Simple
Legal Lot:
1
Road Access:
Paved
LINC Number:
0025521890
Days On Website:
19 day(s)
  • Photo 1: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Stucco exterior residence featuring a dark shingle roof, white trim accents, and stone detailing around the foundation
  • Photo 2: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Dining area featuring wood-finish flooring, an arched doorway, and a linear pendant light fixture
  • Photo 3: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Dining area with wood-finish flooring, featuring an arched entryway, a built-in light fixture, and white trim
  • Photo 4: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Kitchen featuring white beadboard cabinetry, wood-finish countertops, and a farmhouse sink
  • Photo 5: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Kitchen featuring wood-finish flooring, white cabinetry, and stainless steel appliances
  • Photo 6: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Kitchen featuring hardwood flooring, white cabinetry, a farmhouse sink, and a rustic light fixture
  • Photo 7: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Living area featuring wood-finish flooring, light yellow walls, and crown molding
  • Photo 8: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Hardwood flooring throughout featuring white crown molding and a prominent ceiling fixture
  • Photo 9: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Living space featuring wood-finish flooring, an arched doorway, and crown molding
  • Photo 10: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Bright living area featuring wood-finish flooring, a multi-pane window, crown molding, and a solid wood entry door
  • Photo 11: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Bright living area featuring wood-finish flooring, a decorative ceiling light fixture, and crown molding
  • Photo 12: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Hardwood flooring throughout a bright hallway with white trim, featuring multiple paneled doors and an arched doorway
  • Photo 13: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Bathroom featuring a freestanding clawfoot tub, pedestal sink, and window with natural light
  • Photo 14: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Pedestal sink and freestanding bathtub with an overhead window
  • Photo 15: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Spacious room featuring hardwood flooring, crown molding, and two windows providing natural light
  • Photo 16: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Hardwood flooring and a large butcher block island define this space, featuring stainless steel countertops, a window with decorative stained glass, and a paneled door
  • Photo 17: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Hardwood flooring featuring a window with natural light, crown molding, and neutral wall tones
  • Photo 18: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Wood-finish flooring with a white paneled door
  • Photo 19: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Attic space featuring dormer windows, sloped ceilings, beadboard half-walls, a wood-finish railing, and built-in wood shelving
  • Photo 20: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Sloped ceilings with recessed lighting and a ceiling-mounted light fixture illuminate this flexible room
  • Photo 21: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Spacious bonus room featuring sloped ceilings and a window
  • Photo 22: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Attic space featuring sloped ceilings, a window, and wood-finish flooring
  • Photo 23: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Spacious finished attic space featuring sloped ceilings, a window dormer, and recessed lighting
  • Photo 24: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Finished lower level featuring wood-finish flooring, wood plank ceiling, recessed lighting, a built-in desk, and a carpeted staircase
  • Photo 25: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Wood-finish flooring and a wood-paneled ceiling define this lower-level area, featuring a black cast-iron wood-burning stove with a stone hearth
  • Photo 26: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Wood-finish flooring with a cast iron wood-burning stove on a tile hearth
  • Photo 27: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Recreation room featuring wood-finish flooring, a wood stove with a slate hearth, and a wood plank ceiling with recessed lighting
  • Photo 28: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Recreation room featuring paneled wood-finish ceiling, light green walls, and wood-finish flooring
  • Photo 29: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Spacious lower-level living area featuring wood-finish flooring and a wood-paneled ceiling
  • Photo 30: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Compact utility space featuring a window, built-in shelving, checkered floor tiling, and a louvered door
  • Photo 31: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    White vanity with a rectangular sink and chrome faucet
  • Photo 32: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Corner shower enclosure with white surround, built-in shelving, and a brushed nickel showerhead
  • Photo 33: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Utility space featuring white cabinetry, a light-colored countertop, and a black and white checkerboard backsplash
  • Photo 34: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Neutral wall finishes with a ceiling-mounted fluorescent light fixture and window with textile drapes
  • Photo 35: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Image quality insufficient for description
  • Photo 36: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Image quality insufficient for description
  • Photo 37: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Built-in sauna with wood paneling and a clear glass door
  • Photo 38: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Expansive wooden deck featuring horizontal railings, ample space for outdoor dining, and a verdant lawn backdrop with mature trees
  • Photo 39: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Expansive wood deck with a brown stucco exterior
  • Photo 40: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Spacious wooden deck with natural wood railing
  • Photo 41: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Expansive backyard featuring a natural wood deck with matching railings, mature trees, and a spacious lawn area
  • Photo 42: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Expansive green lawn with scattered trees and a distant building, featuring a rustic wood deck with railings and integrated post lighting
  • Photo 43: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Red barn structure featuring a gambrel roof and white trim accents
  • Photo 44: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Rustic barn interior featuring exposed wood beams, wood paneling, and visible rafter ceiling
  • Photo 45: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Expansive green lawn with a large red barn featuring a gambrel roof and multiple windows
  • Photo 46: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Red barn with white trim and a diamond window detail
  • Photo 47: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Expansive green lawn featuring a red barn, a red shed, a white fence, mature trees, and a distant wooded area
  • Photo 48: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Expansive green lawn with mature evergreen trees, a large arched structure featuring a roll-up garage door, and a rustic wooden covered shelter
  • Photo 49: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Large Quonset hut structure featuring multiple bay doors and an exterior stairway
  • Photo 50: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Quonset-style building with a large white roll-up door featuring multiple windows
  • Photo 51: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Spacious garage featuring a high arched ceiling, multiple overhead light fixtures, and a vehicle lift
  • Photo 52: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Spacious garage with high vaulted ceilings and insulated walls
  • Photo 53: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Spacious, high-ceiling structure featuring a large overhead door, an automotive lift, and ample workspace
  • Photo 54: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Spacious utility building featuring corrugated metal walls and ceiling, exposed conduit, concrete flooring, and multiple shelving units
  • Photo 55: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Spacious garage featuring corrugated metal walls, high ceilings with exposed metal beams, and a large roll-up garage door
  • Photo 56: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Expansive green lawn with a red-sided barn and a tan-sided outbuilding
  • Photo 57: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Spacious green lawn with a detached auxiliary building featuring a shed roof and a red entry door
  • Photo 58: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Utility building featuring a red barn-style door with white trim, a concrete floor, and an exposed wood beam ceiling with a metal roof
  • Photo 59: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Detached garage featuring an exposed beam ceiling, corrugated metal roofing, an overhead door, and a dedicated storage area with a window
  • Photo 60: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Garage space featuring an overhead door, string lighting, an orange accent wall, a foosball table, and a green utility structure
  • Photo 61: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Garage space featuring a patterned floor, overhead lighting, and an orange accent wall
  • Photo 62: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Utility room with a wood-burning stove, white and orange painted walls, and concrete flooring
  • Photo 63: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Expansive green lawn surrounded by mature trees, featuring a brown-sided structure with a dark roof in the background
  • Photo 64: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Open-sided barn structure featuring a metal roof and wooden support beams
  • Photo 65: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Expansive gravel lot featuring a large open-sided shed with a metal roof, surrounded by mature evergreen trees
  • Photo 66: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Expansive gravel area with distinct circular patterns, bordered by a substantial grass expanse
  • Photo 67: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Expansive green lawn surrounded by mature evergreen trees
  • Photo 68: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Stucco exterior residence featuring a dark shingle roof, white-trimmed windows, and stone detailing on the foundation
  • Photo 69: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Expansive gravel driveway leading to a residence featuring a tan exterior and dark roof
  • Photo 70: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Brown-sided residence with white trim and a dark shingled roof, featuring a bay window and an inviting entryway
  • Photo 71: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Stucco-clad residence featuring a dark shingled roof, white trim windows, and a stone accent foundation
  • Photo 72: 572004 Highway 857: Rural Two Hills County House for sale : MLS®# E4492323
    Expansive green lawn surrounding a charming residence with a dark shingle roof, light-colored trim, and a raised wooden deck
Courtesy of Shannon M Kowal of Kowal Realty Ltd
Data was last updated June 24, 2026 at 05:30 AM (UTC)
SHANNON KOWAL
MELISSA HAUSSER
Data last updated on June 24, 2026 at 05:30 AM (UTC).
Copyright 2026 by the REALTORS® Association of Edmonton. All Rights Reserved.
Data is deemed reliable but is not guaranteed accurate by the REALTORS® Association of Edmonton.
The trademarks REALTOR®, REALTORS® and the REALTOR® logo are controlled by The Canadian Real Estate Association (CREA) and identify real estate professionals who are members of CREA. The trademarks MLS®, Multiple Listing Service® and the associated logos are owned by CREA and identify the quality of services provided by real estate professionals who are members of CREA.