Welcome to your own private RIVERFRONT retreat! Nestled on OVER 7 ACRES and backing to an additional 1,100 ACRES of State Land, this incredible property offers privacy, recreation, and tons of entertaining space. Tucked far off the road, the nearly 3,000 sqft home features 4 BEDROOMS, 2.5 bathrooms, a spacious PRIMARY SUITE with a great walk-in closet and private balcony overlooking the backyard, and an exceptional floorplan designed for both hosting guests as well as everyday living. Inside, you’ll find multiple entertaining spaces, a cozy FIREPLACE, beautiful views from nearly every window, and additional finished living space in the WALKOUT BASEMENT, offering an additional 1,000+ finished sqft. Step outside and enjoy everything this property has to offer, including a massive wraparound porch, huge covered rear deck and outdoor kitchen, a large INGROUND POOL with another great patio, beautiful RIVER FRONTAGE, and outstanding outdoor living spaces. The additional OVERSIZED detached GARAGE offers incredible storage along with a second-story loft area for even more storage. Whether you enjoy hunting, fishing, entertaining, or simply peaceful country living surrounded by nature, this property is a rare opportunity to own a home that can truly do it all!
Sold for $658,000
$658,000
4717 Lonsberry Rd, Columbiaville, MI 48421
4beds
4,083sqft
Single Family Residence
Built in 1999
7.06 Acres Lot
$664,700 Zestimate®
$161/sqft
$1,617 Estimated rent
Home value
$664,700
$631,000 - $698,000
$1,617/mo
Zestimate® history
Loading...
Owner options
List your home for rent
$1,617/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
Learn more$1,617/mo
Rent Zestimate®
Refinance and save
$4,031/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
See today's rates$4,031/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Zillow last checked:
Listing updated:
Listed by:
Ryan Scully 810-577-3146,
Tremaine Real Estate,
Kristen Steelman 810-750-4663,
Tremaine Real Estate
Bought with:
Keegan G Garrow, 6501428848
Century 21 Metro Brokers
Source: Realcomp II,MLS#: 20261037739
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
Primary bedroom
- Level: Second
- Area: 285
- Dimensions: 19 X 15
Bedroom
- Level: Second
- Area: 143
- Dimensions: 13 X 11
Bedroom
- Level: Second
- Area: 132
- Dimensions: 12 X 11
Bedroom
- Level: Basement
- Area: 540
- Dimensions: 36 X 15
Primary bathroom
- Level: Second
- Area: 160
- Dimensions: 16 X 10
Other
- Level: Second
- Area: 90
- Dimensions: 15 X 6
Other
- Level: Second
- Area: 21
- Dimensions: 7 X 3
Other
- Level: Entry
- Area: 156
- Dimensions: 13 X 12
Kitchen
- Level: Entry
- Area: 264
- Dimensions: 22 X 12
Laundry
- Level: Second
- Area: 42
- Dimensions: 7 X 6
Living room
- Level: Second
- Area: 300
- Dimensions: 20 X 15
Heating
- Forced Air, Propane
Cooling
- Ceiling Fans, Central Air
Features
- Basement: Finished,Full,Walk Out Access
- Has fireplace: Yes
- Fireplace features: Living Room
Interior area
- Total interior livable area: 4,083 sqft
- Finished area above ground: 2,983
- Finished area below ground: 1,100
Property
Parking
- Total spaces: 3
- Parking features: One Car Garage, Two Car Garage, Attached, Detached, Heated Garage, Workshop In Garage
- Attached garage spaces: 3
Features
- Levels: Two
- Stories: 2
- Entry location: GroundLevelwSteps
- Patio & porch: Porch
- Pool features: In Ground
- Waterfront features: River Access, River Front
- Body of water: Flint River
Lot
- Size: 7.06 Acres
- Dimensions: 662 x 330
Details
- Additional structures: Pole Barn, Second Garage
- Parcel number: 01302501110
- Special conditions: Short Sale No,Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Farmhouse
- Property subtype: Single Family Residence
Materials
- Vinyl Siding
- Foundation: Basement, Block
- Roof: Asphalt,Metal
Condition
- New construction: No
- Year built: 1999
Utilities & green energy
- Sewer: Septic Tank
- Water: Well
Community & neighborhood
Location
- Region: Columbiaville
Other
Other facts
- Listing agreement: Exclusive Right To Sell
- Listing terms: Cash,Conventional,FHA,Usda Loan,Va Loan
Price history
| Date | Event | Price |
|---|---|---|
| 6/5/2026 | Sold | $658,000-1.6%$161/sqft |
Source:  Realcomp II #20261037739 Report a problem | ||
| 6/3/2026 | Pending sale | $669,000$164/sqft |
Source: Realcomp II #20261037739 Report a problem | ||
| 5/28/2026 | Listed for sale | $669,000+12.4%$164/sqft |
Source: Realcomp II #20261037739 Report a problem | ||
| 6/9/2022 | Sold | $595,000-2.5%$146/sqft |
Source: Realcomp II #2220024604 Report a problem | ||
| 4/8/2022 | Pending sale | $610,000$149/sqft |
Source: Realcomp II #2220024604 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $6,222 +7.3% | $277,600 +1.3% |
| 2024 | $5,797 +191.6% | $274,100 +12.2% |
| 2023 | $1,988 +9.1% | $244,200 +51.9% |
| 2022 | $1,823 +0.9% | $160,800 +5% |
| 2021 | $1,807 | $153,100 +18% |
| 2020 | -- | $129,800 +18.9% |
| 2018 | $1,878 -2.3% | $109,200 -2.3% |
| 2017 | $1,922 | $111,800 +9% |
| 2016 | -- | $102,600 |
| 2015 | -- | -- |
| 2014 | -- | $76,300 +6.4% |
| 2013 | -- | $71,700 +0.4% |
| 2012 | -- | $71,400 -19.5% |
| 2011 | -- | $88,700 +14.7% |
| 2010 | -- | $77,300 -9.5% |
| 2009 | -- | $85,400 -12% |
| 2008 | -- | $97,000 -2.5% |
| 2007 | -- | $99,500 +55% |
| 2006 | -- | $64,200 +1.4% |
| 2005 | -- | $63,300 |
| 2004 | -- | $63,300 +4.1% |
| 2003 | -- | $60,800 +24.8% |
| 2002 | -- | $48,700 +18.8% |
| 2001 | -- | $41,000 |
Find assessor info on the county website
Neighborhood: 48421
Nearby schools
GreatSchools rating
- 4/10Columbiaville Elementary SchoolGrades: PK-4Distance: 3.1 mi
- 3/10Lakeville Middle SchoolGrades: 5-8Distance: 5.6 mi
- 6/10Lakeville High SchoolGrades: 9-12Distance: 5.6 mi
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$664,700
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$664,700
- Michigan
- Lapeer County
- Columbiaville
- 48421
- 4717 Lonsberry Rd