NOT LISTED FOR SALE

2350 W Keenan Hollow Rd Niles, MI 49120

6 Beds
4.5 Baths
5,739 Sq Ft
195 Acres

Last Sold October 30, 2020

Last sale price $4,480,000 $781 Per Sq Ft

34 Days on Market

Highlights

  • Boathouse
  • Deeded Waterfront Access Rights
  • On Golf Course
  • Private Waterfront
  • Docks
  • Barn

About This Home

As of October 2020

THE FINEST ESTATE IN THE MIDWEST COMPRISED OF 200 MAGNIFICENT ACRES ON THE ST JOE RIVER WITH LITERALLY MILES OF VIEWS AND VISTAS UNLIKE ANY OTHER. 6 Bedroom CUSTOM house, Treehouse, Pergola, and Boathouse/Game Room, Farmhouse and 5 Barns. The main home and other associated buildings are a masterpiece in design, materials and construction and create an atmosphere of modern, casual sophistication. Construction features include solid 14'' thick Douglas fir beams transported directly from Washington state, hand cut and placed Wisconsin fieldstone inside and out, cedar shake shingles, vaulted ceilings, exotic granite countertops high end appliances and more. This amazing compound took 30 months to complete and the exterior grounds took 7 years to perfect. The main house features 3 Master suites, 3 additional bedrooms, 4 1/2 baths, 2 offices, detached screened porch with fireplace and an 8 seat professionally installed and calibrated movie theatre with 120" screen. Great room with 28-foot heavily beamed ceiling and two fireplaces comfortably seats 65 for dinner. A 2 story "Treehouse" overlooking a natural spring, an open-air pergola in the vineyard, and separate boathouse/gameroom building dockside adorn the property. Nine natural stone fireplaces are in the various buildings on the compound. The sporting enthusiast will enjoy the riverside 3-hole golf course and the walking trails throughout the property. Three electric gated entries provide privacy and security to the property. Massive mature walnut, oak, maple and cherry trees beautify the estate. Professionally landscaped and entire property, inside and out, is 100% turnkey maintained. Ask about additional acreage available which provides extremely favorable tax benefit. This one of a kind estate is only 86 minutes to downtown Chicago and 15 minutes to Notre Dame or the South Bend Airport.

Last Agent to Sell the Property

The Dennis Bamber Group

Cressy & Everett Real Estate License #6501392410 Listed on: 08/20/2020

Last Buyer's Agent

The Dennis Bamber Group

Cressy & Everett Real Estate License #6501392410 Listed on: 08/20/2020

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $26,784

Year Built

  • Built in 2008

Lot Details

  • 195 Acre Lot
  • Private Waterfront
  • 5,458 Feet of Waterfront
  • On Golf Course
  • Shrub
  • Level Lot
  • Sprinkler System
  • Wooded Lot

Parking

  • 3 Car Attached Garage
  • Garage Door Opener
  • Gravel Driveway

Home Design

  • Contemporary Architecture
  • Brick or Stone Mason
  • Composition Roof
  • Wood Siding
  • Shingle Siding
  • Stone

Interior Spaces

  • 5,739 Sq Ft Home
  • 1-Story Property
  • Wet Bar
  • Ceiling Fan
  • Wood Burning Stove
  • Wood Burning Fireplace
  • Gas Log Fireplace
  • Low Emissivity Windows
  • Window Treatments
  • Garden Windows
  • Mud Room
  • Family Room with Fireplace
  • 9 Fireplaces
  • Living Room with Fireplace
  • Dining Area
  • Home Theater
  • Sun or Florida Room
  • Screened Porch
  • Water Views
  • Home Security System

Kitchen

  • Eat-In Kitchen
  • Built-In Oven
  • Stove
  • Cooktop
  • Microwave
  • Freezer
  • Dishwasher
  • Kitchen Island
  • Disposal
  • Fireplace in Kitchen

Flooring

  • Wood
  • Stone

Bedrooms and Bathrooms

  • 6 Bedrooms | 1 Main Level Bedroom
  • Maid or Guest Quarters
  • Whirlpool Bathtub

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Natural lighting in basement

Outdoor Features

  • Deeded Waterfront Access Rights
  • Boathouse
  • Docks
  • Deck
  • Patio
  • Gazebo

Location

  • Mineral Rights

Farming

  • Barn
  • Tillable Land

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Powered By Owned Propane
  • Power Generator
  • Propane
  • Well
  • Electric Water Heater
  • Water Softener is Owned
  • Septic System
  • High Speed Internet
  • Phone Available
  • Cable TV Available

Community Details

  • Recreational Area

Home Details

Home Type

Single Family

Est. Annual Taxes

$26,784

Year Built

Built in 2008

Lot Details

0

Parking

3

Listing Details

  • Property Sub-Type: Single Family Residence
  • Property Type: Residential
  • New Construction: No
  • ArchitecturalStyle: Contemporary
  • Stories: 1
  • Year Built: 2008
  • ResoPropertyType: Residential
  • Location Property Info:Property Sub-Type: Single Family Residence
  • General Property Info:New Construction2: No
  • General Property Info:Lot Dimensions: irr
  • General Property Info:Waterfront3: Yes
  • General Property Info:Basement: Yes
  • General Property Info:Total Fin SqFt All Levels: 5739.0
  • General Property Info:Main Level Primary: Yes
  • General Property Info:Main Level Laundry: Yes
  • Tax Info:Annual Property Tax: 26784.19
  • Waterfront Options:Water Access YN: Yes
  • Lot Description:Wooded: Yes
  • Roofing:Composition: Yes
  • Heat Type:Forced Air: Yes
  • Air Conditioning:Central Air: Yes
  • Sewer:Septic System: Yes
  • Manufactured:Manufactured YN: No
  • Substructure:Full: Yes
  • Appliances Dryer: Yes
  • Appliances Refrigerators: Yes
  • Washers: Yes
  • Landscape:ShrubsHedges: Yes
  • General Property Info:Total Fireplaces: 9.0
  • Util Avail at Street:Electric: Yes
  • Lot Description:Level: Yes
  • Utilities Attached:Cable: Yes
  • Waterfront Options:Water Frontage3: 5458.0
  • Util Avail at Street:Broadband: Yes
  • Util Avail at Street:Cable2: Yes
  • Util Avail at Street:Telephone Line2: Yes
  • Windows:Low Emissivity Windows: Yes
  • General Property Info:Fireplace: Yes
  • Lot Description:Rolling Hills: Yes
  • Utilities Attached:Telephone Line: Yes
  • Driveway:Gravel: Yes
  • Additional Items:Ceiling Fans: Yes
  • Additional Items:Window Treatments: Yes
  • Appliances Microwave: Yes
  • Substructure:Walk Out: Yes
  • Landscape:Underground Sprinkler: Yes
  • Substructure:Daylight: Yes
  • Landscape:Terraced Yard: Yes
  • Additional Items:GasWood Stove: Yes
  • Additional Items:Whirlpool Tub: Yes
  • Appliances:Built in Oven: Yes
  • Water Heater:Electric3: Yes
  • Lot Description:Tillable: Yes
  • Additional Items:Wet Bar: Yes
  • Additional Items:LP Tank Owned: Yes
  • Mineral Rights:Available: Yes
  • Additional Items:Generator: Yes
  • Lot Description:Golf Course Frontage: Yes
  • Additional Items:Guest Quarters: Yes
  • General Property Info:SqFt Above Grade: 3444.0
  • General Property Info Garage YN: Yes
  • Architectural Style:Contemporary: Yes
  • Flooring:Wood Floor: Yes
  • Security Features:Security System: Yes
  • Flooring Stone Floor: Yes
  • Other Structures:Barn: Yes
  • Other Structures Boat House: Yes
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Appliances: Built in Oven, Cooktop, Dishwasher, Disposal, Dryer, Freezer, Microwave, Oven, Range, Refrigerator, Washer, Water Softener Owned
  • Flooring: Stone, Wood
  • Interior Amenities: Ceiling Fan(s), Garage Door Opener, Gas/Wood Stove, Generator, Guest Quarters, LP Tank Owned, Wet Bar, Whirlpool Tub, Kitchen Island, Eat-in Kitchen, Pantry
  • Fireplace Features: Family Room, Gas Log, Kitchen, Living Room, Wood Burning, Other
  • Fireplace: Yes
  • Fireplaces: 9
  • Total Bedrooms: 6
  • Main Level Bedrooms: 1
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Total Bathrooms: 5
  • Basement: Daylight, Full, Walk-Out Access
  • LivingArea: 5739.0
  • Window Features: Low-Emissivity Windows, Garden Window(s), Window Treatments
  • General Property Info:Stories2: 1.0
  • Kitchen Features:Eating Area: Yes
  • Appliances:Oven: Yes
  • Appliances Range: Yes
  • Kitchen Features:Center Island: Yes
  • Kitchen Features:Mud Room Access: Yes
  • Kitchen Features Pantry: Yes
  • Fireplace:Gas Log: Yes
  • Fireplace:Living: Yes
  • Appliances Dishwasher: Yes
  • Fireplace:Family: Yes
  • Fireplace:Wood Burning: Yes
  • Appliances:Cook Top: Yes
  • Kitchen Features:Garden Window: Yes
  • Appliances:Freezer: Yes
  • Fireplace:Kitchen: Yes
  • Appliances:Water Softener-Owned: Yes

Exterior Features

  • Construction Materials: Shingle Siding, Stone, Wood Siding
  • Exterior Features: Scrn Porch, 3 Season Room
  • List Price: 4999000.0
  • Lot Features: Level, Recreational, Sidewalk, Tillable, Wooded, Rolling Hills
  • Other Structures: Barn(s), Boat House
  • Patio and Porch Features: Deck, Patio, Porch(es)
  • Road Surface Type: Paved
  • Roof: Composition
  • Water Body Name: St Joseph River
  • Waterfront Features: River
  • Waterfront: Yes
  • Access Feat:Accessibility Features2: No
  • Driveway Paved: Yes
  • Exterior Features:Gazebo: Yes
  • Exterior Material:Wood Siding: Yes
  • Exterior Material:Stone: Yes
  • Exterior Features:Scrn Porch: Yes
  • Exterior Material:Shingle Siding: Yes
  • Exterior Features 3 Season Room: Yes
  • Patio and Porch Features:Porch(es): Yes
  • Patio and Porch Features:Deck(s): Yes
  • Patio And Porch Features:Patio: Yes

Garage/Parking

  • Attached Garage: Yes
  • Garage Spaces: 3.0
  • Garage: Yes
  • Parking Features: Attached
  • Additional Items:Garage Door Opener: Yes
  • Parking Features Attached2: Yes
  • General Property Info:Garage Spaces: 3.0

Utilities

  • Cooling: Central Air
  • Cooling: Yes
  • Heating: Forced Air
  • Heating: Yes
  • Security Features: Security System
  • Sewer: Septic Tank
  • Utilities: Phone Available, Electricity Available, Cable Available, Phone Connected, Cable Connected, Broadband
  • Water Source: Well
  • Water Well: Yes

Association/Amenities

  • Water Fea Amenities:All Sports: Yes
  • Water Fea Amenities:Private Frontage: Yes
  • Water Fea Amenities:Deeded Access: Yes
  • Water Fea Amenities:View: Yes
  • Water Fea Amenities:Dock: Yes

Lot Info

  • Lot Size Acres: 195.0
  • Lot Size Area: 195.0
  • Lot Dimensions: irr
  • Lot Size Sq Ft: 8494200.0
  • ResoLotSizeUnits: Acres

Tax Info

  • Tax Annual Amount: 26784.19
  • Tax Year: 2019

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Property History

Date Event Price Change Sq Ft Price
10/30/2020 10/30/20 Sold $4,480,000 -10.4% $781 / Sq Ft
09/23/2020 09/23/20 Pending -- -- --
08/20/2020 08/20/20 For Sale $4,999,000 -- $871 / Sq Ft
Source: Southwestern Michigan Association of REALTORS®

Tax History Compared to Growth

Source: Public Records

Agents Affiliated with this Home

See All Agents

Map

Source: Southwestern Michigan Association of REALTORS®

MLS Number: 20034163

Southwestern Michigan Association of REALTORS®