NOT LISTED FOR SALE

554 W Barnes Lake Rd Columbiaville, MI 48421

Deerfield Township Neighborhood

Estimated Value: $246,000 - $305,000

3 Beds
1 Bath
1,268 Sq Ft
$218/Sq Ft Est. Value

Last Sold July 15, 2024

Last sale price $250,000 $197 Per Sq Ft

Est. 11% increase in value since last sale

Current estimated payment $1,728/month

101 Days on Market

Highlights

  • 20 Acre Lot
  • Ground Level Unit
  • Stainless Steel Appliances
  • Wooded Lot
  • No HOA
  • Bungalow

About This Home

As of July 2024

Welcome to your own little piece of paradise. This adorable 3 bedroom bungalow home has so much to offer. With 20 acres and a flowing river you can hunt and fish right in your own backyard. If you're curious about what you could be hunting please feel free to check out some photos from the trail cam. The sellers recently cleared a large part of the parcel from brush and trees leaving plenty of room to ride ATV's! Electricity has also been ran to the pole barn. When you walk inside you're greeted with an open concept living and dining, with an oversized pantry. Large master bedroom on the first floor and two additional large bedrooms upstairs. Newer updates as of 2023 include: Water Heater, Exhaust fan, insulation, door seal, and underground dog fence. The dog fence is about an acre so plenty of room for your fury ones to run without worry. Newer dishwasher and microwave (2022.) New asphalt millings for the driveway as of 2023.

Sale is contingent on seller closing on new home.

Last Agent to Sell the Property

Salena Herr

Solutions Realty Group LLC License #6506048780 Listed on: 01/18/2024

Last Buyer's Agent

Sheena Short

License #6501426625

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 1940

Lot Details

  • 20 Acre Lot
  • Lot Dimensions are 327x 2536
  • Dirt Road
  • Wooded Lot

Home Design

  • Bungalow
  • Slab Foundation
  • Asphalt Roof
  • Vinyl Construction Material

Interior Spaces

  • 1,268 Sq Ft Home
  • 1.5-Story Property
  • Ceiling Fan

Kitchen

  • Free-Standing Gas Range
  • Microwave
  • Dishwasher
  • Stainless Steel Appliances

Bedrooms and Bathrooms

  • 3 Bedrooms
  • 1 Full Bathroom

Laundry

  • Dryer
  • Washer

Location

  • Ground Level Unit

Utilities

  • Forced Air Heating System
  • Heating System Uses Natural Gas
  • Natural Gas Water Heater

Community Details

  • No Home Owners Association
  • Property is near a ravine

Listing and Financial Details

  • Assessor Parcel Number 00601801500
  • $8,750 Seller Concession

Home Details

Home Type

Single Family

Est. Annual Taxes

$2,442

Year Built

Built in 1940

Lot Details

0

Listing Details

  • Property Type: Residential
  • Architecture Style: Bungalow
  • Architecture Level: 1 1/2 Story
  • Assessment: 92.00
  • Year Built: 1940
  • State Equalized Value: 96600.0000
  • Entry Location: Ground Level
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 1

Interior Features

  • Room Count: 9
  • Total Bedrooms: 3
  • Total Bathrooms: 1.00
  • Full Bathrooms: 1
  • Kitchen Appliances: Dishwasher, Dryer, Free-Standing Gas Range, Microwave, Stainless Steel Appliance(s), Washer
  • Sq Ft Combined: 1268
  • Total Sq Ft: 1268

Exterior Features

  • Roof Material: Asphalt
  • Foundation Details: Slab
  • Construction Materials: Vinyl
  • Frontage Feet: 327
  • Road Frontage Type: Dirt
  • Sideof Street: W

Garage/Parking

  • Garage Size: No Garage

Utilities

  • Heating Fuel: Natural Gas
  • Cooling: Ceiling Fan(s)
  • Heating: Forced Air
  • Sewer: Septic Tank (Existing)
  • Water Heater Fuel: Natural Gas
  • Water Source: Well (Existing)

Condo/Co-op/Association

  • Association Fee: No

Schools

  • School District: North Branch

Lot Info

  • Homestead: Yes
  • Lot Features: Hilly-Ravine, Wooded
  • Lot Size Area: 20.00
  • Lot Dimensions: 327x 2536
  • Parcel Number: 00601801500
  • Percent Wooded: 25

Tax Info

  • Tax Amount Summer: 939.0000
  • Tax Amount Winter: 1503.0000
  • Total Tax: 2442.0000
  • Taxable Value: 96600.0000

MLS Schools

  • School District: North Branch

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jan 18, 2024
Closed on
Jul 17, 2024
Sold by
Weingartz Stephanie and Morris Stephanie
Bought by
Egbers Rodney
Seller's Agent
Salena Herr
Solutions Realty Group LLC
Buyer's Agent
Sheena Short
List Price
$249,900
Sold Price
$250,000
Premium/Discount to List
$100
0.04%
Views
273
Current Estimated Value
$276,447

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$26,447
Avg. Annual Appreciation
9.14%
Original Mortgage
$242,500
Outstanding Balance
$239,974
Interest Rate
6.87%
Mortgage Type
New Conventional
Estimated Equity
$36,473

Purchase Details

Listed on
Mar 2, 2022
Closed on
Apr 26, 2022
Sold by
Hart Steven N
Bought by
Weingartz Stephanie
Seller's Agent
Robert Mckinney
Move Realty LLC
Buyer's Agent
Marie Moore
Solutions Realty Group LLC
List Price
$239,900
Sold Price
$215,000
Premium/Discount to List
-$24,900
-10.38%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
7.03%
Original Mortgage
$204,250
Interest Rate
4.13%
Mortgage Type
New Conventional

Purchase Details

Listed on
May 31, 2016
Closed on
Aug 29, 2016
Sold by
Klauka James and Klauka James
Bought by
Hart Steven N
Seller's Agent
Peter Relken
Michpro Realty LLC
Buyer's Agent
David Tietz
RE/MAX Plus
List Price
$149,000
Sold Price
$150,000
Premium/Discount to List
$1,000
0.67%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
6.52%
Original Mortgage
$154,241
Interest Rate
3.42%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jun 29, 2011
Sold by
Bac Home Loans Servicing Lp
Bought by
Secretary Of Housing & Urban Development

Purchase Details

Closed on
Jun 16, 2010
Sold by
Frey Tammi
Bought by
Bac Home Loans Servicing Lp

Purchase Details

Closed on
Mar 13, 2007
Bought by
Frey Tammie

Purchase Details

Closed on
Oct 26, 2005
Sold by
Kaake Russell and Kaake Beth
Bought by
Deutsche Bank

Purchase Details

Closed on
Nov 12, 1998
Sold by
Kaake Russell and Kaake Sharon
Bought by
Kaake Russell and Kaake Beth
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 Buyer Sale Price Title Company
Egbers Rodney $250,000 Ata National Title Group
Weingartz Stephanie $215,000 Partners Title
Hart Steven N $150,000 --
Secretary Of Housing & Urban Development -- --
Bac Home Loans Servicing Lp $138,975 --
Frey Tammie $125,000 --
Deutsche Bank $95,100 --
Kaake Russell -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Egbers Rodney $242,500
Previous Owner Weingartz Stephanie $204,250
Previous Owner Hart Steven N $154,241
Previous Owner Niester Anthony C $9,282
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
07/15/2024 07/15/24 Sold $250,000 0.0% $197 / Sq Ft
04/28/2024 04/28/24 Pending -- -- --
04/24/2024 04/24/24 For Sale $249,900 0.0% $197 / Sq Ft
03/22/2024 03/22/24 Off Market $250,000 -- --
02/07/2024 02/07/24 Price Changed $249,900 -2.0% $197 / Sq Ft
02/05/2024 02/05/24 Price Changed $254,900 -1.9% $201 / Sq Ft
01/18/2024 01/18/24 For Sale $259,900 +20.9% $205 / Sq Ft
04/26/2022 04/26/22 Sold $215,000 -6.5% $170 / Sq Ft
03/27/2022 03/27/22 Pending -- -- --
03/16/2022 03/16/22 Price Changed $229,900 -2.1% $181 / Sq Ft
03/12/2022 03/12/22 Price Changed $234,900 -2.1% $185 / Sq Ft
03/02/2022 03/02/22 For Sale $239,900 +59.9% $189 / Sq Ft
08/15/2016 08/15/16 Sold $150,000 +0.7% $118 / Sq Ft
06/06/2016 06/06/16 Pending -- -- --
05/31/2016 05/31/16 For Sale $149,000 +254.8% $118 / Sq Ft
05/13/2013 05/13/13 Sold $42,000 0.0% $42 / Sq Ft
05/13/2013 05/13/13 Sold $42,000 -19.5% $42 / Sq Ft
02/15/2013 02/15/13 Pending -- -- --
02/15/2013 02/15/13 Pending -- -- --
01/09/2013 01/09/13 For Sale $52,200 -10.0% $53 / Sq Ft
06/14/2012 06/14/12 For Sale $58,000 -- $59 / Sq Ft
Source: Realcomp

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 $2,793 $124,500 $0 $0
2024 $983 $113,900 $0 $0
2023 $939 $96,600 $0 $0
2022 $2,319 $88,400 $0 $0
2021 $2,153 $87,500 $0 $0
2020 $2,157 $83,000 $0 $0
2019 $2,133 $80,300 $0 $0
2018 $2,087 $77,700 $77,700 $0
2017 $2,036 $75,200 $0 $0
2016 $1,170 $52,000 $52,000 $0
2015 -- $0 $0 $0
2014 -- $41,300 $41,300 $0
2013 -- $40,600 $40,600 $0
Source: Public Records

Agents Affiliated with this Home

  • Salena Herr

    Seller's Agent in 2024

    Salena Herr

    Solutions Realty Group LLC

    (248) 260-8403

    2 in this area

    14 Total Sales

    Salena Herr
    Section Image

  • S

    Buyer's Agent in 2024

    Sheena Short

  • R

    Seller's Agent in 2022

    Robert Mckinney

    Move Realty LLC

    Section Image
  • Marie Moore

    Buyer's Agent in 2022

    Marie Moore

    Solutions Realty Group LLC

    (586) 246-4132

    1 in this area

    41 Total Sales

    Marie Moore
    Section Image
  • Peter Relken

    Seller's Agent in 2016

    Peter Relken

    Michpro Realty LLC

    (810) 278-5825

    21 Total Sales

    Peter Relken
    Section Image
  • David Tietz

    Buyer's Agent in 2016

    David Tietz

    RE/MAX Michigan

    (810) 650-4485

    5 in this area

    58 Total Sales

    David Tietz
    Section Image
See All Agents

Map

Source: Realcomp

MLS Number: 20240002134

Realcomp

APN: 006-018-015-00

Michigan Lapeer County Columbiaville 48421 Deerfield Township

554 W Barnes Lake Rd, Columbiaville, MI

This home is located at 554 W Barnes Lake Rd, Columbiaville, MI 48421 since 18 January 2024 and is currently estimated at $276,447, approximately $218 per square foot. This property was built in 1940. 554 W Barnes Lake Rd is a home located in Lapeer County with nearby schools including North Branch Elementary School, North Branch Middle School, and Ruth Fox Middle School.

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

Realcomp IDX provided courtesy of Realcomp II Ltd. via Ten-X and MLS
Copyright 2025 Realcomp II Ltd. Shareholders
IDX information is provided exclusively for consumers' personal, noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified.
Listing Information presented by local MLS brokerage: Ten-X, local REALTOR®- Arlene Richardson - (888)-952-6393

Nearby Homes