Frank Locricchio
Realty Executives Home Towne Shelby
(810) 479-5361
56 Total Sales
1 in Columbus
$54,000 Price
574 Mayer Rd Columbus, MI 48063
Columbus AreaEstimated Value: $407,000 - $460,000
3
Beds
2
Baths
2,500
Sq Ft
$177/Sq Ft
Est. Value
Highlights
- Stables
- Deck
- Pole Barn
- 13.28 Acre Lot
- Wood Burning Stove
- Farmhouse Style Home
About This Home
As of July 2018An awesome opportunity for horse enthusiasts! Home features 13 acres with natural gas, having 2500 sq. ft., 3 bedrooms (1 on main level), 2 baths, updated kitchen with granite countertops, oak cabinets, trim, and flooring, stainless steel appliances, built-in oven and microwave, island with glass stove-top, sliding window door to a 22 x 14 deck, raised ceiling, and a walk-in AND a closet pantry, separate dining area with a wood stove set back in decorative masonry heat shield surround. The family room is 40 foot with full bath, another wood stove with real brick heat shield backing, and a French slider door leading to the backyard patio. Off the dining room is a living room with bay-window, and an enclosed seasonal front porch. Home has been efficient to heat with 2 wood stoves and also prepared for power outages with a whole house Generac back-up generator. Buyers' dream with these outbuildings…...north building is a 3600 sq. ft. horse barn which has a riding arena, 2 horse ...
Last Agent to Sell the Property
Eric Liniarski
Sine & Monaghan Realtors Real Living LLC SC License #6501294580 Listed on: 04/16/2018
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 Details
Home Type
- Single Family
Est. Annual Taxes
Year Built
- Built in 1871 | Remodeled in 2008
Lot Details
- 13.28 Acre Lot
- Lot Dimensions are 286x1362x286x690
- Irregular Lot
Home Design
- Farmhouse Style Home
- Block Foundation
- Asphalt Roof
- Vinyl Construction Material
Interior Spaces
- 2,500 Sq Ft Home
- 1.5-Story Property
- Ceiling Fan
- Wood Burning Stove
- Family Room with Fireplace
- Dining Room with Fireplace
- Crawl Space
Kitchen
- Microwave
- Dishwasher
- Disposal
Bedrooms and Bathrooms
- 3 Bedrooms
- 2 Full Bathrooms
Laundry
- Dryer
- Washer
Outdoor Features
- Deck
- Patio
- Pole Barn
Horse Facilities and Amenities
- Stables
- Arena
Utilities
- Forced Air Heating and Cooling System
- Humidifier
- Heating System Uses Natural Gas
- Natural Gas Water Heater
Community Details
- No Home Owners Association
Listing and Financial Details
- Assessor Parcel Number 74160122007000
Ownership History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Apr 16, 2018
Closed on
Jul 13, 2018
Sold by
Ralph A Miller And Marilyn M Miller Trus
Bought by
Seller's Agent
Eric Liniarski
Sine & Monaghan Realtors Real Living LLC SC
Buyer's Agent
Becky Brougham
Realty Executives Home Towne
List Price
$289,900
Sold Price
$270,000
Premium/Discount to List
-$19,900
-6.86%
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$173,340
Avg. Annual Appreciation
6.25%
Original Mortgage
$256,500
Outstanding Balance
$221,362
Interest Rate
4.5%
Mortgage Type
New Conventional
Estimated Equity
$221,978
Purchase Details
Closed on
Jul 24, 2006
Sold by
Miller Ralph Arthur and Miller Marilyn
Bought by
Miller Ralph A and Miller Marilyn M
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Columbus, MI
-
Frank Locricchio
-
Jamison Agnello
Jamison Agnello
J Michael Realty LLC
(517) 701-3594
122 Total Sales
1 in Columbus
$412,000 Price
-
Matthew Kallabat
Matthew Kallabat
Top Agent Realty
(947) 210-6260
82 Total Sales
1 in Columbus
$450,000 Price
-
Dawn Waldrip Bertani
Dawn Waldrip Bertani
Real Estate One Inc-Shelby
(586) 571-8718
83 Total Sales
1 in Columbus
$132,500 Price
-
Wynne Achatz
Wynne Achatz
Real Estate One Westrick
(586) 488-0948
220 Total Sales
2 in Columbus
$450,000 Price Range
-
Robert Kluck
Robert Kluck
Professional Leasing & Sales
(586) 619-8812
202 Total Sales
2 in Columbus
$315,000 Price Range
Purchase History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| $270,000 | Ata National Title Group | ||
| Miller Ralph A | -- | None Available |
Source: Public Records
Mortgage History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | $256,500 |
Source: Public Records
Property History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 07/05/2018 07/05/18 | Sold | $270,000 | -6.9% | $108 / Sq Ft |
| 04/22/2018 04/22/18 | Pending | -- | -- | -- |
| 04/16/2018 04/16/18 | For Sale | $289,900 | -- | $116 / Sq Ft |
Source: Realcomp
Tax History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| 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 | $1,836 | $226,400 | $0 | $0 |
| 2024 | $1,781 | $199,200 | $0 | $0 |
| 2023 | $1,696 | $184,600 | $0 | $0 |
| 2022 | $4,642 | $165,800 | $0 | $0 |
| 2020 | $4,008 | $144,600 | $31,400 | $113,200 |
| 2019 | $3,933 | $132,400 | $0 | $0 |
| 2018 | $2,789 | $126,800 | $0 | $0 |
| 2017 | $2,490 | $124,600 | $0 | $0 |
| 2016 | $1,017 | $124,600 | $0 | $0 |
| 2015 | -- | $105,100 | $105,100 | $0 |
| 2014 | -- | $96,800 | $96,800 | $0 |
| 2013 | -- | $85,900 | $0 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
EL
Seller's Agent in 2018
Eric Liniarski
Sine & Monaghan Realtors Real Living LLC SC
-
Becky Brougham
Buyer's Agent in 2018
Becky Brougham
Realty Executives
(810) 434-6133
84 Total Sales
Map
Source: Realcomp
MLS Number: 218031297
APN: 16-012-2007-000
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.
IDX provided courtesy of Realcomp II Ltd. via Ten-X and MLS
Copyright 2026 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
- 0 Drexler Roads Unit 50219466
- 00 Meskill Rd
- 1301 Palms Rd
- 1621 Preservation Ln
- 7992 Gratiot Ave
- 8828 Meskill Rd
- 6100 Frith Rd
- 7544 Ravenswood Rd
- 1070 Burns Rd
- 0 Wadhams Rd Unit G50043992
- 5771 Gratiot Ave
- 000 Meskill Rd
- 00000 Wadhams Rd
- 9227 Yager Rd
- 1225 Orchard Ln
- 1201 Orchard Ct
- 00 Smiths Creek Rd Smiths Creek Rd
- 0 Richman Rd Unit 50219615
- 0 Weber (Lot B) Rd Unit 50207231
- 0 Meskill (Lot D) Rd Unit 50172630
Your Personal Tour Guide
Ask me questions while you tour the home.