NOT LISTED FOR SALE

1938 W Columbia Rd Mason, MI 48854

Estimated Value: $685,000 - $949,000

3 Beds
3.5 Baths
4,760 Sq Ft
$173/Sq Ft Est. Value

Last Sold September 08, 2022

Last sale price $780,000 $164 Per Sq Ft

Est. 6% increase in value since last sale

Current estimated payment $5,453/month

47 Days on Market

Highlights

  • Docks
  • Pond View
  • Deck
  • Home fronts a pond
  • 35.36 Acre Lot
  • Private Lot

About This Home

As of September 2022

This is a once in a lifetime opportunity to own 35 acres of secluded land, 1000' off the road complete with your own private pond & fountain. This home has everything you could want, including high speed internet, natural gas & 2 pole barns 40x40 & 40x70. Finished room in the barn has its own 1/2 bath & in-floor heat. You'll love the covered patio, formal dining & living rooms, 4 season room & in-law suite w/ full kitchen. 1st floor office and large mudroom/laundry. There's even a walk out basement & whole house generator.

Last Agent to Sell the Property

Tracey Hernly

Howard Hanna Real Estate Executives License #6502424313 Listed on: 06/23/2022

Howard Hanna Real Estate Executives

Co-Listed By

Amber Kennell

Howard Hanna Real Estate Executives License #6506046599

Last Buyer's Agent

John Hagerty, Jr.

Five Star Real Estate - Lansing License #6501359884

Five Star Real Estate - Lansing

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $8,200

Year Built

  • Built in 1991

Lot Details

  • 35.36 Acre Lot
  • Lot Dimensions are 855 x 1684
  • Home fronts a pond
  • Property fronts a county road
  • West Facing Home
  • Landscaped
  • Native Plants
  • Private Lot
  • Secluded Lot
  • Rectangular Lot
  • Wooded Lot
  • Many Trees

Parking

  • 2.5 Car Attached Garage
  • Front Facing Garage

Home Design

  • Brick Exterior Construction
  • Shingle Roof

Interior Spaces

  • 2-Story Property
  • High Ceiling
  • Ceiling Fan
  • Wood Burning Fireplace
  • Heatilator
  • Raised Hearth
  • Awning
  • Bay Window
  • Entrance Foyer
  • Great Room with Fireplace
  • 2 Fireplaces
  • Living Room
  • Formal Dining Room
  • Pond Views

Kitchen

  • Eat-In Kitchen
  • Breakfast Bar
  • Gas Oven
  • Gas Range
  • Dishwasher
  • Stone Countertops
  • Disposal

Flooring

  • Wood
  • Carpet
  • Laminate
  • Ceramic Tile

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Soaking Tub

Laundry

  • Laundry Room
  • Laundry in multiple locations
  • Dryer
  • Washer
  • Sink Near Laundry

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Apartment Living Space in Basement

Home Security

  • Home Security System
  • Fire and Smoke Detector

Outdoor Features

  • Docks
  • Deck
  • Covered Patio or Porch
  • Fire Pit
  • Pole Barn
  • Gazebo
  • Separate Outdoor Workshop

Farming

  • Agricultural

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Power Generator
  • Natural Gas Connected
  • Well
  • Water Heater
  • Water Softener
  • Septic Tank
  • High Speed Internet

Community Details

  • No Home Owners Association
  • Office

Home Details

Home Type

Single Family

Est. Annual Taxes

$8,200

Year Built

Built in 1991

Lot Details

0

Parking

2

Listing Details

  • Property Sub Type: Single Family Residence
  • Bedroom 2 Level: Second
  • Dining Room Level: First
  • Living Room Level: First
  • Current Use: Primary
  • Tax Year: 2021
  • Levels: Two
  • Parking Features Garage Spaces: 2.5
  • Year Built: 1991
  • Fireplaces: 2
  • Primary Bathroom Level: Second
  • Lot Size Acres: 35.36
  • Lot Size: 855 x 1684
  • Co List Office Mls Id: 1104
  • Co List Office Phone: 517-657-9100
  • Subdivision Name: None
  • Above Grade Finished Sq Ft: 2856.0
  • Living Area: 4760.0
  • General Property Info:Lot Size Dimensions: 855 x 1684
  • General Property Info:Above Grade Finished Area: 2856.0
  • General Property Info:Total Livable Area: 4760.0
  • Baths:_pound_Full Baths 2: 2
  • Baths:_pound_Full Baths B: 1
  • Baths:_pound_Half Baths 1: 1
  • Rooms:Dining Room2: Yes
  • Rooms:Living Room2: Yes
  • Primary Bedroom Level: Second
  • Laundry Features:Main Level: Yes
  • Other Structures:Barn(s): Yes
  • Other Structures:Pole Barn: Yes
  • Levels:Two2: Yes
  • Location Legal Info:Real Estate Owned: No
  • General Property Info:Waterfront: Yes
  • Appliances Dryer: Yes
  • Appliances Refrigerators: Yes
  • Washers: Yes
  • Flooring:Carpet: Yes
  • Flooring:Laminate: Yes
  • Roof:Shingle: Yes
  • Security Features:Smoke Detector(s): Yes
  • Cooling:Central Air: Yes
  • Improvements:Formal Dining Room: Yes
  • Improvements:Great Room: Yes
  • Security Features:Security System: Yes
  • Exterior:Brick: Yes
  • Water Softeners: Yes
  • Percent Basement Finished: Yes
  • Land Acreage:Wooded4: Yes
  • Rooms:Laundry2: Yes
  • Laundry Features:Laundry Room: Yes
  • Laundry Features:Lower Level: Yes
  • Utilities:Natural Gas Connected: Yes
  • Rooms:Office: Yes
  • Flooring:Ceramic Tile: Yes
  • Flooring:Hardwood: Yes
  • Road Frontage Type:County Road: Yes
  • Location Legal Info:Senior Community: No
  • Other Equipment:Generator2: Yes
  • View:Pond: Yes
  • Utilities:High Speed Internet Connected: Yes
  • Laundry Features:Sink: Yes
  • Other Structures:Gazebo: Yes
  • Tax Info:Zoning3: Residential
  • Other Structures:Workshop: Yes
  • Rooms:Great Room3: Yes
  • Laundry Features:Multiple Locations: Yes
  • General Property Info:Building Area Total SqFt: 4760.0
  • General Property Info:Front Door: West
  • Special Features: None

Interior Features

  • Basement: Apartment, Finished, Full, Walk-Out Access
  • Heating: Forced Air, Natural Gas
  • Flooring: Carpet, Ceramic Tile, Hardwood, Laminate
  • Interior Amenities: Breakfast Bar, Ceiling Fan(s), Eat-in Kitchen, Entrance Foyer, High Ceilings, High Speed Internet, Pantry, Soaking Tub, Stone Counters
  • Total Bedrooms: 3
  • Property Type: Residential
  • Other Equipment: Generator
  • Bedroom 3 Level: Second
  • Great Room Level: First
  • Laundry Level: First
  • Office Level: First
  • Window Features: Bay Window(s)
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Below Grade Sq Ft: 1904.0
  • Fireplace Features: Great Room, Heatilator, Raised Hearth, Wood Burning
  • Fireplaces: 2
  • Fireplace: Yes
  • Full Basement: Yes
  • Appliances Dishwasher: Yes
  • Interior Features:Ceiling Fan(s): Yes
  • Interior Features:Pantry: Yes
  • Interior Features:Entrance Foyer: Yes
  • Fireplace Features:Wood Burning: Yes
  • Basement:Walk-Out Access: Yes
  • Fireplace Features:Heatilator: Yes
  • Interior Features:Breakfast Bar: Yes
  • Interior Features:Eat-in Kitchen: Yes
  • Appliances:Gas Range: Yes
  • Interior Features:High Ceilings: Yes
  • Interior Features:High Speed Internet: Yes
  • Interior Features:Stone Counters: Yes
  • Appliances:Gas Oven: Yes
  • Interior Features:Soaking Tub: Yes
  • Fireplace Features:Great Room2: Yes
  • Fireplace Features:Raised Hearth: Yes
  • Basement:Apartment2: Yes

Exterior Features

  • Roof: Shingle
  • ExteriorFeatures: Awning(s), Dock, Fire Pit
  • Lot Features: Agricultural, Landscaped, Many Trees, Native Plants, Private, Rectangular Lot, Secluded, Views, Wooded
  • OtherStructures: Barn(s), Gazebo, Workshop, Pole Barn
  • RoadFrontageType: County Road
  • RoadSurfaceType: Asphalt
  • Patio And Porch Features: Covered, Deck, Patio
  • View: Pond
  • WaterfrontFeatures: Pond
  • Waterfront: Yes
  • Home Warranty: No
  • Construction Type: Brick
  • Direction Faces: West
  • Patio Porch Features:Deck: Yes
  • Exterior Features:Awning(s)2: Yes
  • Patio Porch Features:Covered: Yes
  • Patio Porch Features:Patio: Yes
  • Lot Features:Many Trees: Yes
  • Lot Features:Wooded2: Yes
  • Lot Features:Private2: Yes
  • Exterior Features:Fire Pit: Yes
  • Window Features:Bay Window(s): Yes
  • Lot Features:Views: Yes
  • Lot Features:Agricultural: Yes
  • Lot Features:Landscaped: Yes
  • Lot Features:Rectangular Lot: Yes
  • Lot Features:Native Plants: Yes
  • Waterfront Features:Pond2: Yes
  • Exterior Features:Dock: Yes
  • Lot Features:Secluded: Yes

Garage/Parking

  • Parking Features: Attached, Finished, Garage Faces Front
  • Attached Garage: Yes
  • Garage Spaces: 2.5
  • Parking Features:Garage Faces Front: Yes
  • Parking Features:Attached: Yes
  • Parking Features:Finished2: Yes

Utilities

  • Sewer: Septic Tank
  • Appliances: Disposal, Gas Oven, Water Heater, Water Softener, Washer, Refrigerator, Gas Range, Dryer, Dishwasher
  • Cooling: Central Air
  • LaundryFeatures: Laundry Room, Lower Level, Main Level, Multiple Locations, Sink
  • SecurityFeatures: Security System, Smoke Detector(s)
  • Utilities: Natural Gas Connected, High Speed Internet Connected
  • Water Source: Well
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Sewer Septic Tank: Yes
  • Heating:Forced Air: Yes
  • Heating:Natural Gas: Yes
  • Water Heater: Yes

Condo/Co-op/Association

  • Association Name: none
  • Senior Community: No
  • Association: No

Association/Amenities

  • Location Legal Info:Association Name: none

Schools

  • Junior High Dist: Mason

Lot Info

  • Lot Size Sq Ft: 1540281.6
  • ResoLotSizeUnits: Acres

Tax Info

  • Tax Carrier Route: 9241
  • Tax Annual Amount: 8200.0

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Feb 21, 2018
Sold by
Ranshaw Todd M and Ranshaw Connie R
Bought by
Ranshaw Todd M and Ranshaw Connie R
Current Estimated Value
$825,335

Purchase Details

Closed on
Mar 15, 2011
Sold by
Ranshaw Todd M and Lehman Ranshaw Connie R
Bought by
Ranshaw Todd M and Lehman Ranshaw Connie R

Purchase Details

Closed on
Aug 25, 2004
Sold by
Nestle Harold W and Nestle Cindy L
Bought by
Ranshaw Todd M and Lehman Ranshaw Connie R

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$399,200
Outstanding Balance
$198,780
Interest Rate
6.17%
Mortgage Type
Purchase Money Mortgage
Estimated Equity
$626,555
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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
Ranshaw Todd M -- None Available
Ranshaw Todd M -- None Available
Ranshaw Todd M $499,000 Trans
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Ranshaw Todd M $399,200
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
09/08/2022 09/08/22 Sold $780,000 -1.9% $164 / Sq Ft
08/09/2022 08/09/22 Pending -- -- --
07/26/2022 07/26/22 Price Changed $795,000 -1.6% $167 / Sq Ft
06/23/2022 06/23/22 For Sale $808,000 -- $170 / Sq Ft
Source: Greater Lansing 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 $13,329 $385,300 $97,300 $288,000
2024 $79 $360,050 $87,000 $273,050
2023 $12,434 $327,250 $81,850 $245,400
2022 $7,771 $300,550 $80,000 $220,550
2021 $7,836 $293,000 $71,000 $222,000
2020 $7,447 $258,300 $71,000 $187,300
2019 $7,292 $245,150 $63,650 $181,500
2018 $7,056 $234,350 $62,150 $172,200
2017 $6,158 $230,800 $60,550 $170,250
2016 -- $189,500 $58,550 $130,950
2015 -- $180,200 $117,436 $62,764
2014 -- $179,300 $118,235 $61,065
Source: Public Records

Agents Affiliated with this Home

  • Tracey Hernly

    Seller's Agent in 2022

    Tracey Hernly

    Howard Hanna Real Estate Executives

    (517) 300-2089

    31 in this area

    388 Total Sales

    Tracey Hernly
    Section Image

  • A

    Seller Co-Listing Agent in 2022

    Amber Kennell

    Howard Hanna Real Estate Executives

    4 in this area

    116 Total Sales

    Amber Kennell
    Section Image
  • John Hagerty, Jr.

    Buyer's Agent in 2022

    John Hagerty, Jr.

    Five Star Real Estate - Lansing

    (517) 803-5868

    9 in this area

    261 Total Sales

    John Hagerty, Jr.
    Section Image
See All Agents

Map

Source: Greater Lansing Association of Realtors®

MLS Number: 266089

Greater Lansing Association of Realtors®

APN: 10-10-03-300-021

Michigan Ingham County Mason 48854

1938 W Columbia Rd, Mason, MI

Not Listed for Sale

Detached

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.

Greater Lansing Association of Realtors® IDX information is provided exclusively for Consumers'
personal, non-commercial use, that it may not be used for any purpose other than to identify prospective properties Consumers may be interested in purchasing. Data is deemed reliable but is not guaranteed accurate by the MLS.
Copyright © 2025 Greater Lansing Association of REALTORS®

Nearby Homes