Forgot password Extend Verify Contact
Courtesy of Nicholas J Golden of RE/MAX Professionals

404 Duncan
Moonlight Bay_CBAR Rural Barrhead County T0E 1A0

$575,000
Country Residential beds: 5 baths: 3.0 1,553 sq. ft. built: 2018

Main Photo: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 1: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 2: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 3: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 4: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 5: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 6: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 7: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 8: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 9: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 10: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 11: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 12: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 13: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 14: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 15: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 16: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 17: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 18: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 19: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 20: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 21: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 22: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 23: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 24: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 25: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 26: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 27: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 28: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 29: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 30: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 31: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 32: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 33: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 34: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 35: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 36: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 37: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 38: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 39: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 40: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 41: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 42: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 43: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 44: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 45: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 46: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Photo 47: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
Status:
Active
Prop. Type:
Country Residential
MLS® Num:
E4434701
Bedrooms:
5
Bathrooms:
3
Year Built:
2018
Year round living Steps from the Lake, with lake access! This meticulously finished bungalow offers the perfect setup for family & retirement living, complete with a shared dock for your boat. The main floor features bright, spacious rooms with a natural, open flow. The great room showcases vaulted ceilings that add to the airy feel, while the kitchen is outfitted with granite countertops, stainless steel appliances, breakfast island, & plenty of storage. The dining area opens onto a massive, partially covered deck—perfect for entertaining. The sunlit living room includes a stone-front fireplace, ideal for cozy evenings. Also on the main floor: 3 generous bedrooms, a full bathroom, a primary suite with a 5-piece ensuite, walk-in closet, & patio doors that lead directly to the deck. The f/f basement offers even more space with 2 large bedrooms, a full bathroom, a spacious rumpus room, and dedicated laundry and utility area. Flawless in both design & finish, this home checks every box.
North on Hwy 2 or HWY 44 30 kms to HWY 651, west on HWY 651 to RR 25(30 km from HWY 44), south 1.6 km to Duncan road, west on Duncan road.
Property Type:
Country Residential
Dwelling Type:
Detached Single Family
Home Style:
Bungalow
Total Floor Area:
1,552.71 sq. ft.
Price Per SqFt:
$370.32
Total area above grade.:
1,553 sq. ft.
Finished Area Below Grade:
1,429.55 sq. ft.
Secondary Suite:
No
Second Residence:
No
Taxes:
Lot Area:
21,344.4 sq. ft.
Lot Shape:
Rectangular
Lot Details:
22.80x71.83
Grade Level Entry:
No
Levels:
2
Exposure / Faces:
West
Year built:
2018 (Age: 7)
Bedrooms:
5 (Above Grd: 3)
Bathrooms:
3.0 (Full:3/Half:0)
Total Rooms Above Grade:
6
Building Type:
Detached Single Family
Exterior Finish:
Hardie Board Siding
Power Service:
Paid For
Heating Source Desc:
Paid For
Num. of Parcels:
1
Construction:
Wood
Foundation:
Concrete Perimeter
Basement:
Full, Finished
Basement Development:
Fully Finished
Floor Finish:
Vinyl Plank
Heating:
Forced Air-1, Natural Gas
Fireplace:
Yes
Fireplace Fuel:
Gas
Fireplace Type:
Stone Facing
Parking:
Double Garage Attached, Insulated, Over Sized
Enclosed Parking:
2
Total Parking Spaces:
12
Garage:
Yes
Ensuite:
Yes
Garage Dimensions:
7.34x7.04
Phone Desc:
Paid
Water Supply:
Cistern
Water Paid For:
None
Sewer Septic:
Holding Tank
Ceiling 9 ft., Deck, Lake Privileges, No Animal Home, No Smoking Home, Vaulted Ceiling, Vinyl Windows, See Remarks
Moonlight Bay_CBAR
Boating, Flat Site, Lake View, Landscaped, Level Land, No Through Road, Paved Lane, Recreation Use, Schools, Shopping Nearby, See Remarks
Boating, Flat Site, Lake View, Landscaped, Level Land, No Through Road, Paved Lane, Recreation Use, Schools, Shopping Nearby, See Remarks
ensuite bathroom
Dishwasher-Built-In, Dryer, Garage Opener, Microwave Hood Fan, Refrigerator, Stove-Gas, Washer
None Known
Private
Floor
Type
Size
Other
Main
Living Room
16'10" × 14'6"
-
Main
Dining Room
13'8" × 9'10"
-
Main
Kitchen
13'8" × 12'6"
-
Basement
Family Room
36'6" × 16'6"
-
Main
Master Bedroom
13'2" × 12'5"
-
Main
Bedroom 2
13'4" × 10'2"
-
Main
Bedroom 3
14'10" × 11'1"
-
Basement
Bedroom 4
13'5" × 11'11"
-
Basement
Bedroom
13'5" × 10'
-
Floor
Ensuite
Pieces
Other
Main
-
4
Main
-
5
Basement
-
3
Association Fee Frequency:
Association Fee Amount:
Seller Rights Reserved:
No
School Bus:
Yes
Zone:
Zone 72
Zoning:
Zone 72
Title to Land:
Fee Simple
Legal Lot:
5
Road Access:
Paved
LINC Number:
0036040939
Dist to Nearest Town:
24.8 km
Nearest Town:
Barrhead
Township:
57
Quarter 1:
Northwest
West Meridian 1:
5
Section 1:
18
Range 1:
2
  • Photo 1: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 1 of 47
  • Photo 2: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 2 of 47
  • Photo 3: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 3 of 47
  • Photo 4: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 4 of 47
  • Photo 5: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 5 of 47
  • Photo 6: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 6 of 47
  • Photo 7: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 7 of 47
  • Photo 8: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 8 of 47
  • Photo 9: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 9 of 47
  • Photo 10: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 10 of 47
  • Photo 11: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 11 of 47
  • Photo 12: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 12 of 47
  • Photo 13: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 13 of 47
  • Photo 14: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 14 of 47
  • Photo 15: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 15 of 47
  • Photo 16: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 16 of 47
  • Photo 17: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 17 of 47
  • Photo 18: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 18 of 47
  • Photo 19: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 19 of 47
  • Photo 20: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 20 of 47
  • Photo 21: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 21 of 47
  • Photo 22: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 22 of 47
  • Photo 23: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 23 of 47
  • Photo 24: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 24 of 47
  • Photo 25: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 25 of 47
  • Photo 26: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 26 of 47
  • Photo 27: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 27 of 47
  • Photo 28: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 28 of 47
  • Photo 29: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 29 of 47
  • Photo 30: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 30 of 47
  • Photo 31: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 31 of 47
  • Photo 32: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 32 of 47
  • Photo 33: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 33 of 47
  • Photo 34: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 34 of 47
  • Photo 35: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 35 of 47
  • Photo 36: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 36 of 47
  • Photo 37: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 37 of 47
  • Photo 38: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 38 of 47
  • Photo 39: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 39 of 47
  • Photo 40: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 40 of 47
  • Photo 41: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 41 of 47
  • Photo 42: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 42 of 47
  • Photo 43: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 43 of 47
  • Photo 44: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 44 of 47
  • Photo 45: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 45 of 47
  • Photo 46: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 46 of 47
  • Photo 47: 404 Duncan: Rural Barrhead County House for sale : MLS®# E4434701
    Photo 47 of 47
Data was last updated May 6, 2025 at 09:30 PM (UTC)
Area Statistics
Listings on market:
19
Avg list price:
$479,000
Min list price:
$139,000
Max list price:
$1,849,000
Avg days on market:
34
Min days on market:
1
Max days on market:
618
Avg price per sq.ft.:
$320.14
These statistics are generated based on the current listing's property type and located in Rural Barrhead County. Average values are derived using median calculations.
GREG STEELE
Copyright 2025 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.