217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997

As a Sales Representative, I am able to help Buyers find the right home in Niagara-on-the-Lake or anywhere else for that matter! The home does not have to be listed by me in order for me to sell it, so if you find homes on the MLS and you want to see them, just let me know and I will make the arrangements and act as your Realtor – in your best interest!

Forgot password Extend Verify Contact

217 CONCESSION 5 Road
105 - St. Davids Niagara-on-the-Lake L0S 1J0

$5,490,000
Single Family beds: 4 baths: 5.0 built: 2015

Main Photo: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 1: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 2: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 3: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 4: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 5: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 6: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 7: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 8: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 9: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 10: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 11: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 12: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 13: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 14: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 15: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 16: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 17: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 18: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 19: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 20: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 21: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 22: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 23: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 24: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 25: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 26: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 27: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 28: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 29: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 30: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 31: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 32: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 33: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 34: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 35: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 36: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 37: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 38: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 39: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 40: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 41: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 42: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 43: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 44: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 45: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 46: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 47: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Photo 48: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
Status:
Active
Prop. Type:
Single Family
MLS® Num:
40612997
Bedrooms:
4
Bathrooms:
5
Year Built:
2015
Luxurious 3,404 sq. ft. modern farmhouse bungaloft, blending architectural beauty with its expansive surroundings. The home offers four spacious bedrooms, five luxurious bathrooms, and a three-car garage. Its open concept design is bathed in natural light from large windows, showcasing exceptional finishes and craftsmanship. The chef's kitchen is perfect for hosting gatherings, while the unique floor plan includes a main floor primary bedroom with a six-piece ensuite and an impressive upper loft. The loft serves as a games and entertainment centre, featuring a wet bar and two balconies with breathtaking views of the wine country. The home's lower level adds to its already incredible living areas with a workout room complete with a sauna, a second full kitchen, and additional bedrooms ideal for in-law accommodations. Nestled on 9.83 acres of beautifully landscaped land, the property includes an outdoor covered sitting area with a pizza oven, a recreation pond, and a stone waterfall. With convenient access to QEW, White Oaks Fitness Club, golf courses, the Outlet Collection Mall, and some of Niagara's finest restaurants. Don't miss the chance to make this your dream home! (id:2493)
Property Type:
Single Family
Common Interest:
Freehold
Property Attached:
No
Total Living Area:
3,396 sq. ft.
Finished Area Above Grade:
3,396 sq. ft.
Transaction Type:
For sale
Zoning:
A
Ownership Type:
Freehold
Taxes:
$8,950 / -
Community:
105 - St. Davids
Subdivision Name:
105 - St. Davids
Amenities:
Airport, Golf Nearby, Schools, Shopping
Exterior Features:
Stone, Stucco
Community Features:
Industrial Park, School Bus
Security Features:
Security system
Structure Type:
House
Structures:
Shed, Porch
Appliances Included:
Washer, Refrigerator, Water softener, Sauna, Central Vacuum, Range - Gas, Dishwasher, Stove, Dryer, Wet Bar, Hood Fan, Window Coverings, Garage door opener
Age:
9 years
Bedrooms:
4
Bedrooms Above Grade:
2
Bedrooms Below Grade:
2
Bathrooms:
5.0
Half Bathrooms:
2
Construction Style Attachment:
Detached
Cooling:
Central air conditioning
Exterior Finish:
Stone, Stucco
Fireplace:
Yes
Fireplaces:
2
Fire Protection:
Security system
Fixture:
Ceiling fans
Foundation:
Poured Concrete
Heating:
Forced air, Natural gas
# Storeys:
1.5
Water:
Municipal water
Sewer:
Septic System
Basement:
Finished, Full
Basement Development:
Finished
Land Amenities:
Airport, Golf Nearby, Schools, Shopping
Road Access:
Highway access
Acreage:
Yes
Lot Size:
9.83 acre(s)
Lot Size:
9.83 ac|5 - 9.99 acres
Lot Details:
9.83
Lot Features:
Ravine, Conservation/green belt, Wet bar, Skylight, Country residential, Automatic Garage Door Opener, In-Law Suite
Parking:
Attached Garage
Total Parking Spaces:
7
Floor
Type
Size
Other
Main level
Laundry room
0 × 0
Main level
Bedroom
13'1" × 12'
13'1'' x 12'0''
Main level
Primary Bedroom
16'1" × 16'
16'1'' x 16'0''
Main level
Office
12'10" × 8'3"
12'10'' x 8'3''
Main level
Living room/Dining room
30'6" × 22'1"
30'6'' x 22'1''
Main level
Kitchen
18'9" × 12'9"
12'9'' x 18'9''
Second level
Loft
36'11" × 17'6"
36'11'' x 17'6''
Basement
Wine Cellar
0 × 0
Basement
Storage
0 × 0
Basement
Storage
0 × 0
Basement
Other
0 × 0
Basement
Gym
18'5" × 7'3"
7'3'' x 18'5''
Basement
Kitchen
16'2" × 9'10"
9'10'' x 16'2''
Basement
Family room
29'7" × 28'4"
28'4'' x 29'7''
Basement
Bedroom
12'7" × 11'8"
12'7'' x 11'8''
Basement
Bedroom
23'1" × 13'
13'0'' x 23'1''
Floor
Ensuite
Pieces
Other
Main level
No
4
Main level
No
-
Main level
No
2
Second level
No
2
Basement
No
3
  • Photo 1: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 1 of 48
  • Photo 2: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 2 of 48
  • Photo 3: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 3 of 48
  • Photo 4: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 4 of 48
  • Photo 5: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 5 of 48
  • Photo 6: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 6 of 48
  • Photo 7: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 7 of 48
  • Photo 8: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 8 of 48
  • Photo 9: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 9 of 48
  • Photo 10: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 10 of 48
  • Photo 11: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 11 of 48
  • Photo 12: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 12 of 48
  • Photo 13: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 13 of 48
  • Photo 14: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 14 of 48
  • Photo 15: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 15 of 48
  • Photo 16: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 16 of 48
  • Photo 17: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 17 of 48
  • Photo 18: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 18 of 48
  • Photo 19: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 19 of 48
  • Photo 20: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 20 of 48
  • Photo 21: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 21 of 48
  • Photo 22: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 22 of 48
  • Photo 23: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 23 of 48
  • Photo 24: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 24 of 48
  • Photo 25: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 25 of 48
  • Photo 26: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 26 of 48
  • Photo 27: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 27 of 48
  • Photo 28: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 28 of 48
  • Photo 29: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 29 of 48
  • Photo 30: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 30 of 48
  • Photo 31: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 31 of 48
  • Photo 32: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 32 of 48
  • Photo 33: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 33 of 48
  • Photo 34: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 34 of 48
  • Photo 35: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 35 of 48
  • Photo 36: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 36 of 48
  • Photo 37: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 37 of 48
  • Photo 38: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 38 of 48
  • Photo 39: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 39 of 48
  • Photo 40: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 40 of 48
  • Photo 41: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 41 of 48
  • Photo 42: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 42 of 48
  • Photo 43: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 43 of 48
  • Photo 44: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 44 of 48
  • Photo 45: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 45 of 48
  • Photo 46: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 46 of 48
  • Photo 47: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 47 of 48
  • Photo 48: 217 CONCESSION 5 Road in Niagara-on-the-Lake: Single Family for sale : MLS®# 40612997
    Photo 48 of 48

Video Tour Website

Listed by RE/MAX NIAGARA REALTY LTD, BROKERAGE
Data was last updated September 11, 2024 at 08:15 AM (UTC)
Area Statistics
Listings on market:
49
Avg list price:
$1,249,000
Min list price:
$299,900
Max list price:
$6,999,000
Avg days on market:
53
Min days on market:
1
Max days on market:
239
Avg price per sq.ft.:
$612.25
These statistics are generated based on the current listing's property type and located in 105 - St. Davids. Average values are derived using median calculations.
powered by myRealPage.com