NOT LISTED FOR SALE

2330 W Bertrand Rd Niles, MI 49120

Estimated Value: $637,000 - $894,089

5 Beds
5 Baths
5,226 Sq Ft
$148/Sq Ft Est. Value

Last Sold January 31, 2025

Last sale price $665,000 $127 Per Sq Ft

Est. 17% increase in value since last sale

Current estimated payment $5,191/month

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
  • Stories: 2
  • Year Built: 2005
  • ResoPropertyType: Residential
  • Appliances Dryer: Yes
  • Appliances Refrigerators: Yes
  • Washers: Yes
  • Appliances Microwave: Yes
  • Architectural Style:Traditional: 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
  • 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
  • Appliances:Freezer: 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
  • Access Feat:Accessibility Features2: Yes

Garage/Parking

  • Attached Garage: Yes
  • Garage Spaces: 2.0
  • Garage: Yes
  • Parking Features: Attached
  • Additional Items:Garage Door Opener: 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

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
$776,022

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$111,022
Avg. Annual Appreciation
39.34%

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
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

Similar Homes in Niles, MI

  • 33192 Old Post Rd, Niles, MI 49120

    $799,000

    • 4 Beds
    • 4.5 Baths
    • 4,258 Sq Ft
    • 33192 Old Post Rd
    • Niles, MI

    Gorgeous 4-bed, 4-bath home in the gated Reserves at Knollwood! A grand 2-story foyer with hardwood floors and an elegant staircase welcomes you. Main floor features an office, formal dining, and a spacious family room with fireplace. The chef's kitchen boasts ample counters, center island, walk-in pantry, and breakfast nook. Stunning primary suite offers his & hers closets and a private

    Jan Lazzara RE/MAX by the Lake

    Section Image
  • 1411 Harrah Rd, Niles, MI 49120

    $670,000

    • 5 Beds
    • 4 Baths
    • 2,900 Sq Ft
    • 1411 Harrah Rd
    • Niles, MI

    Welcome to this stunning home! Nestled on nearly 4 acres of mostly wooded land, this updated 5-bedroom, 4-bath home offers convenience with a spacious floor plan that perfectly blends modern design and timeless elegance. Bright and inviting kitchen with new granite countertops and center island. The main floor features primary bedroom with an ensuite, walk-in closet with laundry. Upstairs, you'll

    Kate Campbell IREP ERA Powered

    Section Image
  • 33081 Old Post Rd, Niles, MI 49120

    $749,900

    • 6 Beds
    • 4 Baths
    • 3,999 Sq Ft
    • 33081 Old Post Rd
    • Niles, MI

    One of Michiana's most beautiful neighborhoods; The Reserve at Knollwood! Literally balanced on the state line, the rolling hills & curving private roads welcome you home to your hidden paradise. Just 10-15 minutes from Notre Dame, area hospitals, & downtown South Bend. Michigan 'school of choice' opens the door to the Blue Ribbon awarded Edwardsburg schools. Grab your clubs & play a round on

    Monica Eckrich Cressy & Everett Real Estate

    Section Image
  • 71438 Forest Eagle Ln, Niles, MI 49120

    $757,000

    • 5 Beds
    • 4.5 Baths
    • 4,100 Sq Ft
    • 71438 Forest Eagle Ln
    • Niles, MI

    Imagine coming home to a true retreat in the Reserve at Knollwood! This classic, well-built home sits on a private lot surrounded by woods and offers a backyard haven, featuring a beautiful in ground pool. The twinkling lights surrounding the fenced pool area create a magical ambiance for your enjoyment or for a spectacular space to entertain. The landscaping has been carefully selected to create

    Julia Robbins The Collective Home Group

    Section Image

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 Buyer Sale Price Title Company
Macfarlane Jeffrey Lopez -- None Listed On Document
Macfarlane Jeffrey Lopez -- None Listed On Document
Macfarlane Jeffrey Lopez -- None Listed On Document
Macfarlane Jeffrey Lopez -- None Listed On Document
Reed John Richard -- --
Reed John R -- --
-- -- --
-- -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Reed John R $750,000
Previous Owner Reed John R $832,000
Previous Owner Reed John R $106,277
Previous Owner Reed John R $744,000
Previous Owner Reed John R $650,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
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