$424,900

4705 Lonsberry Rd Columbiaville, MI 48421

Estimated payment $2,404/month

Total Views 3,998
3 Beds
1.5 Baths
2,600 Sq Ft
$163 Price per Sq Ft

Highlights

  • 66 Feet of Waterfront
  • Deck
  • Pole Barn
  • 9.31 Acre Lot
  • Wood Burning Stove
  • Ground Level Unit

About This Home

Second Owner Custom Built Home, 3 Bedrooms, 1.5 Baths, Huge Great Room, Almost 2500sf of finished Living Space. Custom counters, Hardwood Floors, Gas fire stove in Living Room, Wrap around Deck, Large Pole Barn, and on almost 10 acre Park like lot with tons of wildlife! Back of property has frontage on the South Branch of the Flint River with Great fishing! Property is perfect for Hunting Deer, Fishing or a great place to even have Horses! Buses for North Branch Schools, Lapeer Schools and Lakeville Schools run down this road for many options for School of choice! This is a Must See Home! This house is Move in Ready! Shows Great! More details & Survey available.

Listing Agent

Douglas Ferrell

Realty Executives Main St LLC License #6501342658 Listed on: 10/06/2025

Realty Executives Main St LLC

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 1972 | Remodeled in 2021

Lot Details

  • 9.31 Acre Lot
  • Lot Dimensions are 299x1296x299x1296
  • 66 Feet of Waterfront
  • River Front

Parking

  • 2.5 Car Attached Garage

Home Design

  • Split Level Home
  • Quad-Level Property
  • Block Foundation
  • Slab Foundation
  • Asphalt Roof
  • Vinyl Construction Material

Interior Spaces

  • 2,600 Sq Ft Home
  • Wood Burning Stove
  • Gas Fireplace
  • Family Room with Fireplace
  • Unfinished Basement

Kitchen

  • Double Oven
  • Built-In Gas Oven
  • Gas Cooktop
  • Microwave
  • Dishwasher

Bedrooms and Bathrooms

  • 3 Bedrooms

Laundry

  • Dryer
  • Washer

Outdoor Features

  • Deck
  • Patio
  • Pole Barn
  • Porch

Location

  • Ground Level Unit

Utilities

  • Forced Air Heating and Cooling System
  • High Efficiency Heating System
  • Heating System Uses Wood
  • Heating System Uses Propane
  • Programmable Thermostat
  • Water Softener is Owned

Community Details

  • No Home Owners Association
  • Laundry Facilities

Listing and Financial Details

  • Assessor Parcel Number 01302501100

Home Details

Home Type

Single Family

Est. Annual Taxes

$1,813

Year Built

Built in 1972 | Remodeled in 2021

Lot Details

0

Listing Details

  • Property Type: Residential
  • Architecture Style: Split Level
  • Architecture Level: Quad-Level
  • Year Built: 1972
  • State Equalized Value: 169700.0000
  • Year Renovated: 2021
  • Foundation Features: Drainage System
  • Entry Location: Ground Level
  • Pets Allowed: Yes
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 4

Interior Features

  • Interior Amenities: Programmable Thermostat, Water Softener (owned)
  • Fireplace: Yes
  • Fireplace Fuel: Gas, Wood Stove
  • Fireplace Locations: Family Room
  • Total Bedrooms: 3
  • Total Bathrooms: 1.10
  • Full Bathrooms: 1
  • Half Bathrooms: 1
  • Basement: Yes
  • Basement Type: Unfinished
  • Kitchen Appliances: Built-In Gas Oven, Dishwasher, Double Oven, Dryer, Free-Standing Refrigerator, Gas Cooktop, Microwave, Washer
  • Total Sq Ft: 2600

Exterior Features

  • Roof Material: Asphalt
  • Waterfront Name: South Branch of the Flint River
  • Waterfront: Yes
  • Foundation Details: Slab, Basement
  • Construction Materials: Vinyl
  • Foundation Materials: Block
  • Porch Type: Deck, Patio, Porch
  • Road Frontage Type: Gravel
  • Sideof Street: W
  • Water Frontage Feet: 66.00
  • Waterfront Description: River Front, Water Front

Garage/Parking

  • Garage Size: 2.5 Car
  • Garage Features: Attached
  • Garage: Yes

Utilities

  • Heating Fuel: Propane, Wood
  • Cooling: Central Air
  • Heating: Forced Air, High Efficiency Sealed Combustion
  • Sewer: Septic Tank (Existing)
  • Water Source: Well (Existing)
  • Laundry Facilities: Yes

Condo/Co-op/Association

  • Association Fee: No

Lot Info

  • Homestead: Yes
  • Lot Size Area: 9.31
  • Lot Dimensions: 299x1296x299x1296
  • Parcel Number: 01302501100
  • Soil Type: Gravel/Sand

Tax Info

  • Tax Amount Summer: 734.0000
  • Tax Amount Winter: 1079.0000
  • Total Tax: 1813.0000
  • Taxable Value: 163380.0000

MLS Schools

  • School District: North Branch

Map

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

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 $4,011 $171,700 $0 $0
2024 $3,848 $169,700 $0 $0
2023 $1,513 $155,600 $0 $0
2022 $1,971 $122,500 $0 $0
2021 $1,813 $118,800 $0 $0
2020 $1,794 $103,500 $0 $0
2019 $1,825 $85,600 $0 $0
2018 $1,779 $84,900 $84,900 $0
2017 $1,853 $86,800 $0 $0
2016 $681 $80,400 $80,400 $0
2015 -- $81,200 $0 $0
2014 -- $74,700 $74,700 $0
2013 -- $67,100 $67,100 $0
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
10/06/2025 10/06/25 For Sale $424,900 +8.9% $163 / Sq Ft
06/08/2022 06/08/22 Sold $390,000 -2.5% $156 / Sq Ft View Prior Sale
05/31/2022 05/31/22 Pending -- -- --
04/12/2022 04/12/22 For Sale $399,900 -- $160 / Sq Ft
Source: Realcomp

Purchase History

Date Type Sale Price Title Company
Quit Claim Deed -- Liberty Title
Warranty Deed $390,000 Cislo Title
Quit Claim Deed -- --
Quit Claim Deed -- --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $382,936 No Value Available
Closed $382,936 FHA
Source: Public Records

About the Listing Agent

Douglas Ferrell

Realty Executives Main St LLC

(810) 535-6616

Section Image

SELL Your Home FAST! CALL ME FIRST AND WORK WITH THE BEST! Voted " Best of the BEST" Realtor 12 Years! Licensed to LIST, SHOW and SELL any home in Michigan (810) 691-0731

Specialized in LISTING and SELLING Homes, Assisting First-time Home BUYERS, Finding FORECLOSED, BANK OWNED Properties, and Other Great DEALS. Just Email or Call Me With What You are Looking For. I Will Find Your Dream Deal!

SELLERS:
Ready to move? Sounds great! Let's get started- Call today for a FREE Market

Douglas' Other Listings

  • 6208 Marathon Rd, Otter Lake, MI 48464

    $324,900

    • 3 Beds
    • 1.5 Baths
    • 1,550 Sq Ft
    • 6208 Marathon Rd
    • Otter Lake, MI

    Beautifully updated open floorplan ranch home on 10 acres in Otter Lake! This move-in ready property features a newer roof, windows, furnace, and gutters, along with fresh paint and new flooring throughout. The home includes an attached oversized garage and a powerful 9,000-watt backup generator for peace of mind. Enjoy the best of country living with natural gas, a paved road, and plenty of open

    Douglas Ferrell Realty Executives Main St LLC

    Section Image
  • 2672 N Lapeer Rd, Lapeer, MI 48446

    $289,900 Pending

    • 3 Beds
    • 1.5 Baths
    • 1,550 Sq Ft
    • 2672 N Lapeer Rd
    • Lapeer, MI

    Charming and well-kept home in Lapeer Schools with convenient M-24 access! This 3-bedroom, 1.5-bath home features a smart layout that’s ideal for entertaining, highlighted by a spacious kitchen, dining area, and a large deck off the back. The finished basement provides additional living space for a rec room, home office, or hobbies. Upstairs you’ll find the convenient second-floor laundry, saving

    Douglas Ferrell Realty Executives Main St LLC

    Section Image
  • VL Roods Lake Rd, Mayfield Township, MI 48446

    $449,900

    • Land
    • 87.55 Acres
    • $5,139 per Acre
    • VL Roods Lake Rd
    • Mayfield Township, MI

    Discover approximately 87.55 acres of prime real estate offering endless possibilities! This unique property is 75% wooded with valuable timber, making it a great investment opportunity. Perfect for outdoor enthusiasts, the land boasts excellent deer, coyote, and turkey hunting. With a paved road and easy access, it’s also an ideal candidate for a dragstrip-related business or other ventures. For

    Douglas Ferrell Realty Executives Main St LLC

    Section Image
  • 1408 Lincoln St, Lapeer, MI 48446

    $289,900

    • 2 Beds
    • 2 Baths
    • 1,500 Sq Ft
    • 1408 Lincoln St
    • Lapeer, MI

    Move-in ready and loaded with premium upgrades, this luxury 2-bedroom, 2-bath ranch condo offers maintenance-free living in the heart of Lapeer, thoughtfully priced below comparable units for unbeatable value. Enjoy an open-concept layout with tall ceilings, large windows flooding the space with natural light, and a gourmet kitchen featuring granite countertops, premium cabinetry, a spacious

    Douglas Ferrell Realty Executives Main St LLC

    Section Image
  • 1205 Lancaster St, Lapeer, MI 48446

    $359,900

    • 4 Beds
    • 2.5 Baths
    • 1,900 Sq Ft
    • 1205 Lancaster St
    • Lapeer, MI

    Why wait to build when this stunning 2023-built, 4-bedroom, 2.5-bath home is move-in ready and loaded with upgrades? Designed for modern living, this two-story home features a spacious open floor plan, a private primary suite with a walk-in closet and en-suite bath, and high-quality finishes throughout. The kitchen boasts beautiful granite countertops, upgraded fixtures, and plenty of

    Douglas Ferrell Realty Executives Main St LLC

    Section Image
  • 847 N Main St, Lapeer, MI 48446

    $219,900

    • 4 Beds
    • 2 Baths
    • 1,620 Sq Ft
    • 847 N Main St
    • Lapeer, MI

    Fully rebuilt in 2004, 4-bedroom, 2-bath home in the heart of Lapeer, set on an extra-large double lot with plenty of off-street parking and a 1.5-car garage with a workshop. Fully rebuilt in 2004 with all-new drywall, wiring, plumbing, and energy-efficient/sound-deadening insulation for comfort and efficiency..... this is a All NEW home!. Features include solid oak trim and doors, cedar-lined

    Douglas Ferrell Realty Executives Main St LLC

    Section Image
  • 835 N Main St, Lapeer, MI 48446

    $274,900 Pending

    • 3 Beds
    • 3.5 Baths
    • 1,750 Sq Ft
    • 835 N Main St
    • Lapeer, MI

    Fully remodeled and move-in ready, this spacious home offers 3 bedrooms, 3 full bathrooms, and 1 half bath, perfectly suited for flexible living. Situated on a large lot with plenty of parking and a carport, the home features a main-floor primary suite, granite countertops, and a beautifully updated interior with new flooring, fresh paint, modern fixtures, and more. The rear portion of the home

    Douglas Ferrell Realty Executives Main St LLC

    Section Image
  • 1511 Fish Lake Rd, Lapeer, MI 48446

    $449,900 Under Contract

    • 4 Beds
    • 2.5 Baths
    • 3,000 Sq Ft
    • 1511 Fish Lake Rd
    • Lapeer, MI

    Motivated sellers! This one-owner home has been exceptionally well maintained and is move-in ready. The spacious eat-in kitchen offers plenty of storage and opens to a 26x12 deck, ideal for family gatherings. The fully finished basement includes an additional full kitchen, perfect for entertaining, canning, or extended family needs. With four generously sized bedrooms, 2.5 baths, and convenient

    Douglas Ferrell Realty Executives Main St LLC

    Section Image
  • 6152 Old State Rd, North Branch, MI 48461

    $244,900

    • Land
    • 32.77 Acres
    • $7,473 per Acre
    • 6152 Old State Rd
    • North Branch, MI

    Explore this picturesque 33-acre property in the North Branch School District, offering over 2,000 feet of frontage on the tranquil Bottom Creek. Perfect for a variety of uses, the land includes a 30x36 Morton Barn with a brand-new cement floor, ready for storage, farming, or other projects. Previously utilized as a hobby farm, the property features former Christmas tree and blueberry plantings,

    Douglas Ferrell Realty Executives Main St LLC

    Section Image

Source: Realcomp

MLS Number: 20251042989

Realcomp

APN: 013-025-011-00