NOT LISTED FOR SALE

1938 W Columbia Rd Mason, MI 48854

Estimated Value: $614,000 - $854,364

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

Last Sold September 08, 2022

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

Est. 6% decrease in value since last sale

Current estimated payment $4,085/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
  • Room: 9
  • 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
$732,091

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$313,000
Interest Rate
4.45%

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
$49,900
Interest Rate
6.08%
Mortgage Type
Credit Line Revolving
Source: Public Records

Similar Homes in Mason, MI

  • 2474 Tomlinson Rd, Mason, MI 48854

    $850,000

    • 3 Beds
    • 3 Baths
    • 2,116 Sq Ft
    • 2474 Tomlinson Rd
    • Mason, MI

    Discover this incredible opportunity to own an iconic Mason property! This sprawling 60.71-acre estate features a charming 3-bedroom, 3-bath home, ideal for easy living with a main floor primary bedroom, bathroom, and laundry. Large windows in the living room overlook the pastures and flood the living room with natural light. Outside, you'll be greeted by mature trees planted by the owner as you

    Chris Brooks Keller Williams Realty Lansing

    Section Image
  • 1600 Tuttle Rd, Mason, MI 48854

    $589,900

    • 3 Beds
    • 3 Baths
    • 1,952 Sq Ft
    • 1600 Tuttle Rd
    • Mason, MI

    Introducing a truly rare opportunity—this fully renovated 3-bedroom, 3-bathroom home sits on 2 pristine acres and offers a perfect blend of comfort, functionality, and modern luxury. From the moment you arrive, you'll notice the care and attention invested throughout, inside and out.Step inside to a welcoming foyer that leads to a sun-drenched family room with beautiful rich floors, the living

    Savannah Murphy Thrive Realty Company

    Section Image
  • 1153 S Edgar Rd, Mason, MI 48854

    $729,900

    • 4 Beds
    • 3.5 Baths
    • 4,605 Sq Ft
    • 1153 S Edgar Rd
    • Mason, MI

    Discover exceptional living in this stunning custom-built ranch, perfectly situated on 2.45 private acres in the award-winning Mason School District. Boasting over 4,600 square feet of finished living space, this 4-bedroom, 3.5-bath home offers the perfect combination of space, comfort, and luxury.Inside, you'll find an open-concept layout designed for both everyday living and entertaining. The

    Rick Hebden Greenridge Realty (Ionia)

    Section Image
  • 5056 Bunker Rd, Mason, MI 48854

    $679,900

    • 4 Beds
    • 4 Baths
    • 5,456 Sq Ft
    • 5056 Bunker Rd
    • Mason, MI

    Welcome to 5056 Bunker Road, Mason. Impressive architecture - open, expansive spaces and volume ceilings. Approximately 5,456 sq ft living space on 3.46 acres. You are going to love it. Great rm w/built ins/gas fireplace. An abundance of cabinetry in the expansive kitchen w/large sit up bar. Informal & formal dining rms. Dining rm could easily be a home-office. Primary suite with door to

    Carin Whybrew Coldwell Banker Professionals -Okemos

    Section Image
  • 2958 S Edgar Rd, Mason, MI 48854

    $785,000

    • 4 Beds
    • 3.5 Baths
    • 3,284 Sq Ft
    • 2958 S Edgar Rd
    • Mason, MI

    Modern Farmhouse Retreat on 10 Acres! Secluded, Stylish, & Spacious. Escape to this stunning newer custom farmhouse, energy-efficient, and built with quality in mind. A rare opportunity to own acreage with privacy, modern conveniences, and timeless design, privately tucked back on a tree-lined drive. Enjoy peaceful views from covered front & back porches. Inside, the home boasts a bright and open

    Susie Mohlman Sproat Realty Professionals-J

    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
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 Nebbeling David J $624,000
Closed Ranshaw Todd M $308,000
Closed Ranshaw Todd $308,000
Closed Ranshaw Todd $313,000
Closed Ranshaw Todd M $90,339
Closed Ranshaw Todd M $49,900
Closed Ranshaw Todd M $399,200
Previous Owner Nestle Harold W $236,000
Previous Owner Nestle Harold W $196,000
Previous Owner Nestle Harold W $45,000
Previous Owner Nestle Harold W $145,000
Previous Owner Nestle Harold W $45,000
Source: Public Records

Property History

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

  • Section Image
  • Section Image
  • 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