Off Market Jul 2018 for $270K

$474,725

Est. refi paymentEst. refi $2,045/mo

•

2,500

sq ft

574 Mayer Rd, Columbus, MI 48063

About this home

An 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 . ..

Single-familyProperty Type

1871Year Built

13.28 acresLot Size

$190Est. Price/Sq.Ft.

Listed by Eric Liniarski • Sine & Monaghan Realtors Real Living LLC SC

Bought with Rebecca Brougham • Realty Executives Home Towne

Redfin checked: a minute ago

•Source:REALCOMP #218031297

Listing provided courtesy of Realcomp MLS

Redfin Estimate

$474,725

$205K since sold in July 2018$2,000 since July

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 46.6% higher than the average sale price ($324K) of 6 comparable homes.

SOLD JUN 26, 2026
$298,000
A
3 beds2 baths2,336 sq ft
5428 Gratiot Ave, Saint Clair, MI 48079 1427
SOLD JUL 28, 2026
$250,000
B
3 beds2 baths1,582 sq ft
7219 Main, Kimball, MI 48074 4011
SOLD AUG 14, 2026
$205,000
C
3 beds1.5 baths1,906 sq ft
7592 Rattle Run Rd, Columbus, MI 48063 2107
SOLD AUG 10, 2026
$405,000
D
3 beds2 baths1,862 sq ft
5324 Ravenswood Rd, Kimball, MI 48074 3212
SOLD AUG 11, 2026
$335,000
E
3 beds1.5 baths1,605 sq ft
5930 Gratiot Ave, Saint Clair, MI 48079 1914
SOLD OCT 21, 2025
$450,000
F
3 beds2 baths1,700 sq ft
6206 Gratiot Ave, Saint Clair, MI 48079

Claim this home to receive a free report every month with insights on the changing estimate.

Earn from this home

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$2,059/mo

Redfin rental estimate

List your home for rent

Market trends in 48063, MI

Last updated July 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-List Price

96.7%

1.1% MoM

Median sale price

$481K

$14K MoM

Avg. days on market

15d

6 days MoM

Recently sold homes

1 MoM

New listings for sale

$615,000
4 beds2.5 baths2,750 sq ft
9227 Yager Rd, Columbus, MI 48063
$495,000
4 beds2.5 baths2,500 sq ft
2635 Palms Rd, Columbus, MI 48063
(586) 799-8000
$550,000
4 beds2.5 baths3,784 sq ft
8828 Meskill Sts, Columbus, MI 48063
(586) 774-2300
See all

Provided by Redfin

Sale history for 574 Mayer Rd

Date

Event

Price

Greater Lansing AoR #21435684

Jul 5, 2018

Sold

$270,000

$108/sq ft

Apr 22, 2018

Pending

—

Apr 16, 2018

Listed

$289,900

$116/sq ft

Apr 16, 2018

Listed

$289,900

$116/sq ft

An 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 . ..

REALCOMP #218031297

Jul 5, 2018

Sold

$270,000

$108/sq ft

Apr 22, 2018

Pending

—

Apr 16, 2018

Listed

$289,900

$116/sq ft

Tax history for 574 Mayer Rd

*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.

Public record

Beds

—

Baths

—

Stories

—

Lot width

286 ft.

Lot depth

—

Lot size

13.28 Acres

Year renovated

—

Sq. Ft.

—

Year built

—

Style

Single Family Residential

County

St. Clair County

APN

16-012-2007-000

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Aug 7, 2026.

Property details

Parking

Parking/Garage Information
Parking Features: No Garage

Interior

Bathroom Information
# of Full Bathrooms: 2

Heating & Cooling
Has Cooling
Cooling: Ceiling Fan(s), Central Air
Has Heating
Heating: Wood Stove, Forced Air, Natural Gas

Interior Features
Appliances: Gas Water Heater, Dishwasher, Disposal, Dryer, Humidifier, Microwave, Refrigerator, Range, Washer
Flooring: Carpet, Ceramic Tile, Wood
Has Fireplace
Fireplace Features: Dining Room, Family Room, Wood Burning Stove

Room Information
# of Rooms Total: 9
Basement Details: Crawl Space

Exterior

Exterior Features
Patio And Porch Features: Deck, Patio
Roof: Asphalt

Pool Information
Pool Features: None

Building Information
Above Grade Finished Area: 2,500
Above Grade Finished Area Units: Square Feet
Levels: One and One Half
Construction Materials: Vinyl Siding
Foundation Details: Block

Property Features
Other Structures: Barn(s), Arena, Stable(s)

Property Information
Property Type: Residential
Property Sub Type: Single Family Residence
Raw Mls Property Sub Type: SingleFamilyResidence

Land Information
Wooded Area: 10.0

Lot Information
Lot Features: Irregular Lot
Road Surface Type: Paved
Lot Size Dimensions: 286 x 1362 x 286 x 690
Lot Size Area: 13.28
Lot Size Units: Acres
Lot Size Acres: 13.28

Financial

Tax Information
Tax Annual Amount: $2,699

Utilities

Utility Information
Water Source: Private, Well
Sewer: Septic Tank

Location

Schools Information
High School District: Marysville

Location Information
Directions: Gratiot Ave to Rattle Run Road, north on Rattle Run Road, right onto Mayer / between Rattle Run & Frith Road
Cross Street: N of Gratiot Ave/E of Rattle Run

Public facts

Beds: —
Baths: —
Sq. Ft.: —
Stories: —
Lot Size: 13.28 acres
Style: Single Family Residential
Year Built: —
Year Renovated: —
County: St. Clair County
APN: 16-012-2007-000

Home facts updated by county records on Aug 7, 2026

Around this home

Schools

Washington Elementary School

Public PreK-5 • Assigned • 6.8mi

6/10

Marysville Middle School

Public 6-8 • Assigned • 7.5mi

6/10

Marysville High School

Public 9-12 • Assigned • 7.5mi

7/10

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Climate risks

1/10 Flood Factor

Minimal risk of a flood reaching the building in the next 30 years

1/10 Fire Factor

Unlikely to be in a wildfire in next 30 years

3/10 Heat Factor

7 days above 97° expected this year, 14 days in 30 years

1/10 Wind Factor

Minimal risk of severe winds over next 30 years

2/10 Air Factor

1 unhealthy days expected this year, 2 days in 30 years

Provided by First Street

Historical weather

Columbus, MI • 48063

Average low and high temperatures (°F)

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Sun exposure

In this area, properties receive around 8.8 hours in June and 2.1 hours in December, placing it below the U.S. average for solar exposure.

8.8 hrs

2.1 hrs

JuneDecember

Provided by Shadowmap

Estimated sale price

$451,000 – $546,000

Sell confidently with a local market expert in Columbus. 3 minutes to get started.

Nearby similar homes

$120,000

Land— sq ft

6417 Dove Rd, Kimball, MI 48074 2419

(313) 658-6400

$649,900

3 beds2.5 baths5,500 sq ft

9202 Crawford Rd, Columbus, MI 48063

(586) 731-8180

$629,000

3 beds1 bath1,119 sq ft

7627 Lapeer Rd, Wales, MI 48027 1517

(810) 987-8600

FOR SALE BY OWNER

$540,000

5 beds3 baths2,640 sq ft

9777 Lambs Rd, Wales, MI 48027

$459,900

3 beds2 baths3,363 sq ft

5104 Ravenswood Rd, Kimball, MI 48074 3220

(248) 609-8000

$525,000

4 beds3 baths3,129 sq ft

6100 Frith Rd, Saint Clair, MI 48079

(810) 982-1400

New listings for sale in 48063

$615,000

4 beds2.5 baths2,750 sq ft

9227 Yager Rd, Columbus, MI 48063

$495,000

4 beds2.5 baths2,500 sq ft

2635 Palms Rd, Columbus, MI 48063

(586) 799-8000

$550,000

4 beds2.5 baths3,784 sq ft

8828 Meskill Sts, Columbus, MI 48063

(586) 774-2300

Home values near 574 Mayer Rd

Data from public records.

Address	Redfin Estimate
489 Mayer Road, Saint Clair, MI 3 Beds \| 1.5 Baths \| 2000 Sq. Ft.	$376,040
586 Mayer Road, Columbus, MI 3 Beds \| 2.5 Baths \| 2620 Sq. Ft.	$557,335

Address	Redfin Estimate
696 Mayer Road, Columbus, MI 3 Beds \| 1.5 Baths \| 2292 Sq. Ft.	$386,234
659 Mayer Road, Saint Clair, MI 3 Beds \| 3.5 Baths \| 3924 Sq. Ft.	$812,335

Address	Redfin Estimate
650 Mayer Road, Columbus, MI 3 Beds \| 2.5 Baths \| 1908 Sq. Ft.	$430,736
653 Mayer Road, Saint Clair, MI 3 Beds \| 2 Baths \| 1900 Sq. Ft.	$308,907

Property information provided by REALCOMP when last listed in 2018. This data may not match . Learn more.

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Find us

Subsidiaries

Affiliated Business

Countries

United States

Canada

Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.

Do not sell or share my personal information.

REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.

California DRE #01521930

Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures

New Mexico Real Estate Licenses

TREC: Info About Brokerage Services, Consumer Protection Notice

All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.

Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.

If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.

REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.

GreatSchools Ratings provided by GreatSchools.org.

Houses for rent in St. Clair County	Agents near me	Livonia, MI homes for sale	St. Clair County Housing Market
Houses for sale near me	Detroit, MI homes for sale	Novi, MI homes for sale
Land for sale near me	Ann Arbor, MI homes for sale	Royal Oak, MI homes for sale
Open Houses near me	Grand Rapids, MI homes for sale	St. Clair County Property Records
Condos for sale near me	Troy, MI homes for sale	MI New Listings

Oakland County homes for sale
Macomb County homes for sale
Wayne County homes for sale

St. Clair homes for sale
Romeo homes for sale
New Baltimore homes for sale

About this home

Redfin Estimate

Earn from this home

Market trends in 48063, MI

Sale history for 574 Mayer Rd

Tax history for 574 Mayer Rd

Public record

Property details

Around this home

Schools

Lifestyle

Climate risks

Historical weather

Sun exposure

Nearby similar homes

New listings for sale in 48063

Home values near 574 Mayer Rd

More real estate resources