$665,000
SOLD JAN 31, 2025

2330 W Bertrand Rd Niles, MI 49120

5 Beds
5 Baths
5,226 Sq Ft
15.6 Acres

Recently Sold

$127 Per Sq Ft

22% Below List Price

241 Days on Market

Highlights

  • Barn
  • 15.6 Acre Lot
  • Wooded Lot
  • Indoor Pool
  • Maid or Guest Quarters
  • Traditional Architecture

About This Home

As of January 2025

Step into a blend of old-world charm and modern luxury in this remarkable custom home sitting on over 15 acres with a beautiful stone facade.
From the spacious foyer to the vaulted ceilings of the Great Room, every detail exudes warmth and elegance.
Entertain in style with the open-flowing layout, where the kitchen seamlessly connects to the formal Dining Room and Family Room areas, creating the perfect ambiance for gatherings.
Experience true comfort and convenience with wheelchair accessibility on the main level, ensuring everyone can enjoy the beauty of this home.
Retreat to your expansive Primary Suite, complete with a heated tile floor in the luxurious bathroom and a spacious walk-in closet.
Indulge in relaxation and wellness in your private workout room and enclosed hot tub. Unleash your creativity in the full basement, with endless possibilities for customization, including an "endless exercise pool for invigorating swimming workouts.
Enjoy the tranquility of country living on this vast amount of land, with ample space for gardening, outdoor activities, and even your dream of owning animals.
Unlock the potential of the two huge barns, perfect for storing toys and equipment, or transforming into a unique venue, like an equestrian estate or picturesque wedding destination.
Don't miss this one with the perfect balance of rural serenity and urban convenience, with close proximity to shopping, dining, and the vibrant wine trails, breweries, and distilleries of southwestern Michigan

Last Agent to Sell the Property

Ryan Green

Green Towne Coastal Realty License #6501325481 Listed on: 05/27/2024

Last Buyer's Agent

Scott McLauchlin

McLauchlin Realty, Inc.

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $9,736

Year Built

  • Built in 2005

Lot Details

  • 15.6 Acre Lot
  • Level Lot
  • Sprinkler System
  • Wooded Lot
  • Garden
  • Back Yard Fenced
  • Property is zoned R-R Rural Res, R-R Rural Res

Parking

  • 2 Car Attached Garage
  • Garage Door Opener

Home Design

  • Traditional Architecture
  • Brick or Stone Mason
  • Shingle Roof
  • Composition Roof
  • Vinyl Siding
  • Stone

Interior Spaces

  • 2-Story Property
  • Ceiling Fan
  • Skylights
  • Wood Burning Fireplace
  • Insulated Windows
  • Window Treatments
  • Window Screens
  • Living Room with Fireplace
  • Home Security System

Kitchen

  • Eat-In Kitchen
  • Double Oven
  • Built-In Electric Oven
  • Cooktop
  • Microwave
  • Freezer
  • Dishwasher
  • Kitchen Island
  • Snack Bar or Counter
  • Disposal

Flooring

  • Carpet
  • Laminate
  • Ceramic Tile

Bedrooms and Bathrooms

  • 5 Bedrooms | 2 Main Level Bedrooms
  • Maid or Guest Quarters
  • Bathroom on Main Level
  • Whirlpool Bathtub

Laundry

  • Laundry Room
  • Laundry on main level
  • Dryer
  • Washer
  • Sink Near Laundry

Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Stubbed For A Bathroom

Accessible Home Design

  • Roll Under Sink
  • Accessible Bedroom
  • Halls are 36 inches wide or more
  • Doors are 36 inches wide or more
  • Accessible Approach with Ramp
  • Accessible Ramps

Pool

  • Indoor Pool
  • Spa

Farming

  • Barn

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Oil
  • Heating System Uses Propane
  • Heating System Powered By Leased Propane
  • Baseboard Heating
  • Generator Hookup
  • Power Generator
  • Propane
  • Well
  • Electric Water Heater
  • Water Softener is Owned
  • Septic System
  • Satellite Dish
  • Cable TV Available

Listing and Financial Details

  • Home warranty included in the sale of the property

Home Details

Home Type

Single Family

Est. Annual Taxes

$9,736

Year Built

Built in 2005

Lot Details

0

Parking

2

Listing Details

  • Property Sub-Type: Single Family Residence
  • Property Type: Residential
  • New Construction: No
  • ArchitecturalStyle: Traditional
  • Stories: 2
  • Year Built: 2005
  • ResoPropertyType: Residential
  • Location Property Info:Property Sub-Type: Single Family Residence
  • General Property Info:New Construction2: No
  • General Property Info:Lot Dimensions: irregular
  • General Property Info:Waterfront3: No
  • General Property Info:Basement: Yes
  • General Property Info:Total Fin SqFt All Levels: 5226.0
  • General Property Info:Main Level Primary: Yes
  • Tax Info:Annual Property Tax: 9736.0
  • Tax Info:Zoning3: R-R Rural Res
  • Waterfront Options:Water Access YN: No
  • Lot Description:Wooded: Yes
  • Roofing:Composition: Yes
  • Heat Source:Propane: 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
  • General Property Info:Total Fireplaces: 1.0
  • Lot Description:Level: Yes
  • Utilities Attached:Cable: Yes
  • Windows:Insulated Windows: Yes
  • Windows:Screens: Yes
  • General Property Info:Fireplace: Yes
  • Additional Items:Ceiling Fans: Yes
  • Additional Items:Window Treatments: Yes
  • Appliances Microwave: Yes
  • Roofing:Shingle: Yes
  • Substructure:Walk Out: Yes
  • Landscape:Underground Sprinkler: Yes
  • Additional Items:Home Warranty: Yes
  • Windows:Skylight(s): Yes
  • Additional Items:Whirlpool Tub: Yes
  • Landscape:Flower Garden: Yes
  • Heat Type:Baseboard: Yes
  • Water Heater:Electric3: Yes
  • Additional Items:Hot Tub Spa: Yes
  • Additional Items:Generator: Yes
  • Additional Items:LP Tank Rented: Yes
  • Accessibility Feat:Ramped Entrance: Yes
  • Additional Items:Guest Quarters: Yes
  • Additional Items:Generator Hook-up: Yes
  • General Property Info:SqFt Above Grade: 5130.0
  • Laundry Features Laundry Room: Yes
  • Laundry Features Main Level: Yes
  • Laundry Features Sink: Yes
  • Laundry Features Gas Dryer Hookup: Yes
  • Laundry Features Washer Hookup: Yes
  • General Property Info Garage YN: Yes
  • Accessibility Feat 36 Inch Entrance Door: Yes
  • Accessibility Feat 36' or Hallway: Yes
  • Architectural Style:Traditional: Yes
  • Other Equipment:Satellite Dish2: Yes
  • Flooring:Carpet Floor: Yes
  • Flooring:Laminate Floor: Yes
  • Fencing:Fenced Back: Yes
  • Flooring:Tile Floor: Yes
  • Flooring:Ceramic Floor: Yes
  • Security Features:Security System: Yes
  • Other Structures:Barn: Yes
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Appliances: Built-In Electric Oven, Cooktop, Dishwasher, Disposal, Double Oven, Dryer, Freezer, Microwave, Oven, Range, Refrigerator, Washer, Water Softener Owned
  • Accessibility Features: Ramped Entrance, 36 Inch Entrance Door, 36' or + Hallway, Accessible Bath Sink, Accessible Mn Flr Bedroom, Accessible Mn Flr Full Bath
  • Flooring: Carpet, Ceramic Tile, Laminate, Tile
  • Interior Amenities: Ceiling Fan(s), Garage Door Opener, Generator, Guest Quarters, Hot Tub Spa, LP Tank Rented, Whirlpool Tub, Kitchen Island, Eat-in Kitchen, Pantry
  • Fireplace Features: Living Room, Wood Burning
  • Fireplace: Yes
  • Fireplaces: 1
  • Total Bedrooms: 5
  • Main Level Bedrooms: 2
  • Full Bathrooms: 3
  • Half Bathrooms: 2
  • Total Bathrooms: 5
  • Basement: Full, Walk-Out Access
  • LivingArea: 5226.0
  • Other Equipment: Satellite Dish
  • Window Features: Skylight(s), Screens, Insulated Windows, Window Treatments
  • General Property Info:Stories2: 2.0
  • Basement Rooms:Basement Half Baths: 1
  • Basement Rooms:Basement Finished SQFT: 96.0
  • Basement Rooms:Total Basement SQFT: 3900.0
  • Kitchen Features:Eating Area: Yes
  • Appliances:Oven: Yes
  • Appliances Range: Yes
  • Kitchen Features:Center Island: Yes
  • Kitchen Features Pantry: Yes
  • Fireplace:Living: Yes
  • Appliances Dishwasher: Yes
  • Kitchen Features:Snack Bar: Yes
  • Fireplace:Wood Burning: Yes
  • Appliances:Cook Top: Yes
  • Appliances:Built-In Electric Oven: Yes
  • Accessibility Feat:Accessible Mn Flr Bedroom: Yes
  • Accessibility Feat:Accessible Mn Flr Full Bath: Yes
  • Appliances:Freezer: Yes
  • Additional Items:Basement Plumbed for Bath: Yes
  • Appliances:Double Oven: Yes
  • Appliances:Water Softener-Owned: Yes
  • Below Grade Sq Ft: 96.0

Exterior Features

  • Construction Materials: Stone, Vinyl Siding
  • Fencing: Fenced Back
  • Home Warranty: Yes
  • List Price: 739000.0
  • Lot Features: Level, Wooded
  • Other Structures: Barn(s)
  • Pool Features: Indoor
  • Road Surface Type: Paved
  • Roof: Composition, Shingle
  • Waterfront: No
  • Exterior Material:Vinyl Siding: Yes
  • Access Feat:Accessibility Features2: Yes
  • Exterior Material:Stone: Yes
  • Pool:Indoor: Yes

Garage/Parking

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

Utilities

  • Cooling: Central Air
  • Cooling: Yes
  • Heating: Baseboard, Forced Air
  • Heating: Yes
  • Laundry Features: Gas Dryer Hookup, Laundry Room, Main Level, Sink, Washer Hookup
  • Security Features: Security System
  • Sewer: Septic Tank
  • Utilities: Cable Connected
  • Water Source: Well
  • Water Well: Yes
  • Heat Source:Oil: Yes

Lot Info

  • Lot Size Acres: 15.6
  • Lot Size Area: 15.6
  • Lot Dimensions: irregular
  • Lot Size Sq Ft: 679536.0
  • Zoning Description: R-R Rural Res
  • ResoLotSizeUnits: Acres

Tax Info

  • Tax Annual Amount: 9736.0
  • Tax Year: 2023

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 27, 2024
Closed on
Jan 30, 2025
Sold by
Martin Julie Lynn
Bought by
Macfarlane Jeffrey Lopez and Lopez Lauri Leigh
Seller's Agent
Ryan Green
Green Towne Coastal Realty
Buyer's Agent
Scott McLauchlin
McLauchlin Realty, Inc.
List Price
$850,000
Sold Price
$665,000
Premium/Discount to List
-$185,000
-21.76%
Views
231
Current Estimated Value
$821,711

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$156,711
Avg. Annual Appreciation
36.50%

Purchase Details

Listed on
May 27, 2024
Closed on
Jan 29, 2025
Sold by
Heartland Homes Llc
Bought by
Macfarlane Jeffrey Lopez and Lopez Lauri Leigh
Seller's Agent
Ryan Green
Green Towne Coastal Realty
Buyer's Agent
Scott McLauchlin
McLauchlin Realty, Inc.
List Price
$850,000
Sold Price
$665,000
Premium/Discount to List
-$185,000
-21.76%
Views
231

Purchase Details

Closed on
Oct 20, 2022
Sold by
Reed John R
Bought by
Reed John Richard

Purchase Details

Closed on
Feb 17, 2020
Sold by
Reed John R
Bought by
Reed John Richard

Purchase Details

Closed on
Sep 10, 2004
Sold by
Reed John R and Reed Sandra Colleen
Bought by
Reed John R and Reed Sandra C

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$650,000
Interest Rate
5%
Mortgage Type
New Conventional

Purchase Details

Closed on
May 28, 1988

Purchase Details

Closed on
Jan 28, 1986
Source: Public Records

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

Purchase History

Date Type Sale Price Title Company
Warranty Deed -- None Listed On Document
Warranty Deed -- None Listed On Document
Quit Claim Deed -- None Listed On Document
Quit Claim Deed -- None Listed On Document
Quit Claim Deed -- --
Quit Claim Deed -- None Listed On Document
Interfamily Deed Transfer -- --
Deed -- --
Deed -- --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Previous Owner $650,000 New Conventional
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
01/31/2025 01/31/25 Sold $665,000 +16525.0% $127 / Sq Ft
01/23/2025 01/23/25 Pending -- -- --
01/02/2025 01/02/25 Rented $4,000 0.0% --
11/15/2024 11/15/24 Price Changed $4,000 -4.8% $1 / Sq Ft
11/03/2024 11/03/24 For Rent $4,200 0.0% --
10/03/2024 10/03/24 Price Changed $739,000 -3.4% $141 / Sq Ft
08/20/2024 08/20/24 Price Changed $765,000 -3.0% $146 / Sq Ft
07/12/2024 07/12/24 Price Changed $789,000 -1.3% $151 / Sq Ft
06/10/2024 06/10/24 Price Changed $799,000 -6.0% $153 / Sq Ft
05/27/2024 05/27/24 For Sale $850,000 -- $163 / Sq Ft
Source: Southwestern Michigan Association of REALTORS®

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $10,262 $383,900 $0 $0
2024 $3,173 $353,000 $0 $0
2023 $3,022 $314,700 $0 $0
2022 $2,878 $267,200 $0 $0
2021 $5,173 $265,300 $53,400 $211,900
2020 $5,159 $268,500 $0 $0
2019 $5,064 $210,500 $49,500 $161,000
2018 $4,966 $210,500 $0 $0
2017 $4,912 $211,800 $0 $0
2016 $4,829 $240,900 $0 $0
2015 $4,623 $239,300 $0 $0
2014 $2,073 $212,300 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: Southwestern Michigan Association of REALTORS®

MLS Number: 24026401

Southwestern Michigan Association of REALTORS®

APN: 11-05-0117-0010-02-1