$350,000
SOLD JUL 18, 2025

17550 Mayfield St Livonia, MI 48152

4 Beds
1.5 Baths
1,561 Sq Ft
0.69 Acres

Recently Sold

$224 Per Sq Ft

2% Below List Price

11 Days on Market

Highlights

  • 0.69 Acre Lot
  • Wooded Lot
  • Ground Level Unit
  • Holmes Middle School Rated A-
  • Ranch Style House
  • No HOA

About This Home

As of July 2025

Back on the market, one buyers lose can be your gain! Be the next lucky owner of this stunning custom built Usonian masterpiece on an idyllic 3/4 acre property. Upon pulling into the winding driveway you'll feel both a sense of welcoming and inspiration by the attractive and inviting front elevation. Once entering the home, the slate floored foyer and continuous tongue and groove cedar ceilings will draw you around the open concept floor plan with amazing lot views of both the front and back yards from the floor to ceiling windows. The primary bedroom (currently being used as a home office) is surrounded on 3 sides by the tranquil backyard and offers a large enough closet that could be a future bathroom. Step out under the pergola with a vine covered canopy and enjoy watching the wild life and listening to the wind at your own private sanctuary. Explore further and approach a pond and a potting shed that's ready for your green thumbs. Back inside you'll see the 3 guest bedrooms show off the hardwood flooring that runs under the carpet. The large lower level is ready for you finishing touches. The brand new HVAC will keep you comfortable year round and the recent tree trimming will provide piece of mind. With Rotary Park and walking trails around the corner, this home is perfectly positioned for all that love what mother nature has to offer. All appliances stay. Livonia Public Schools: Buchanan K-4, Riley 5-6, Holmes 7-8 and Stevenson 9-12.

Last Agent to Sell the Property

Dave MacFarland

Keller Williams Advantage License #6501387057 Listed on: 06/13/2025

Keller Williams Advantage

Last Buyer's Agent

Jamie Proper

Brookstone, Realtors LLC License #6506049386

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 1952

Lot Details

  • 0.69 Acre Lot
  • Lot Dimensions are 100x300
  • Back Yard Fenced
  • Wooded Lot

Parking

  • 2.5 Car Attached Garage

Home Design

  • Ranch Style House
  • Block Foundation
  • Asphalt Roof
  • Stone Siding

Interior Spaces

  • 1,561 Sq Ft Home
  • Ceiling Fan
  • Gas Fireplace
  • Entrance Foyer
  • Family Room with Fireplace
  • Partially Finished Basement
  • Fireplace in Basement

Kitchen

  • Built-In Electric Oven
  • Gas Cooktop
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms

Laundry

  • Dryer
  • Washer

Outdoor Features

  • Covered patio or porch
  • Exterior Lighting
  • Shed

Location

  • Ground Level Unit

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Natural Gas Water Heater
  • High Speed Internet
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number 46039010069000

Community Details

Overview

  • No Home Owners Association
  • Green Brier Estate Sub Subdivision

Amenities

  • Laundry Facilities

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,109

Year Built

Built in 1952

Lot Details

0

Listing Details

  • Property Type: Residential
  • Architecture Style: Ranch
  • Architecture Level: 1 Story
  • Year Built: 1952
  • State Equalized Value: 143100.0000
  • Entry Location: Ground Level
  • Pets Allowed: Yes
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 1

Interior Features

  • Interior Amenities: Cable Available, Circuit Breakers, Entrance Foyer, High Spd Internet Avail
  • Fireplace: Yes
  • Fireplace Fuel: Natural
  • Fireplace Locations: Basement, Family Room
  • Room Count: 12
  • Total Bedrooms: 4
  • Total Bathrooms: 1.10
  • Full Bathrooms: 1
  • Half Bathrooms: 1
  • Basement: Yes
  • Basement Type: Partially Finished
  • Kitchen Appliances: Built-In Electric Oven, Dishwasher, Disposal, Dryer, Electric Cooktop, Free-Standing Refrigerator, Gas Cooktop, Washer
  • Sq Ft Combined: 2661
  • Sq Ft Lower Floor: 1100
  • Total Sq Ft: 1561
  • Sq Ft Total Bsmt: 1300

Exterior Features

  • Roof Material: Asphalt
  • Foundation Details: Basement
  • Construction Materials: Stone, Wood
  • Exterior Features: Lighting, Fenced
  • Foundation Materials: Block
  • Frontage Feet: 100
  • Porch Type: Porch - Covered, Patio, Porch, Patio - Covered, Covered
  • Road Frontage Type: Paved
  • Fencing: Back Yard, Fenced, Fence Allowed

Garage/Parking

  • Garage Size: 2.5 Car
  • Garage Features: Electricity, Attached
  • Garage: Yes

Utilities

  • Heating Fuel: Natural Gas
  • Cooling: Ceiling Fan(s), Central Air
  • Heating: Forced Air
  • Sewer: Public Sewer (Sewer-Sanitary)
  • Water Heater Fuel: Natural Gas
  • Water Source: Public (Municipal), Community
  • Laundry Facilities: Yes

Condo/Co-op/Association

  • Association Fee: No

Schools

  • School District: Livonia

Lot Info

  • Homestead: Yes
  • Lot Features: Wooded
  • Lot Size Area: 0.69
  • Lot Dimensions: 100X300
  • Parcel Number: 46039010069000

Tax Info

  • Tax Amount Summer: 3197.0000
  • Tax Amount Winter: 1912.0000
  • Total Tax: 5109.0000
  • Taxable Value: 143100.0000

MLS Schools

  • School District: Livonia

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 7, 2024
Closed on
Jul 31, 2024
Sold by
Richard K Sprague K and Richard Yvonne M
Bought by
Zielke Adam and Duffy Jessica
Seller's Agent
Birgit Maun
Keller Williams Advantage
Buyer's Agent
Stephanie Prior
Community Choice Realty Associates, LLC
List Price
$350,000
Sold Price
$300,000
Premium/Discount to List
-$50,000
-14.29%
Views
128

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
8.25%
Original Mortgage
$270,000
Interest Rate
6.95%
Mortgage Type
New Conventional

Purchase Details

Closed on
May 17, 2002
Sold by
Sprague Richard K and Sprague Yvonne M
Bought by
Richard K Sprague And Yvonne M Sprague Trust and Sprague
Source: Public Records

Similar Homes in Livonia, MI

  • 18913 Myron St, Livonia, MI 48152

    $300,000

    • 3 Beds
    • 1 Bath
    • 1,452 Sq Ft
    • 18913 Myron St
    • Livonia, MI

    Sprawling ranch on a large corner lot in Livonia with fantastic curb appeal, beautiful landscaping, and an additional lot next door included! Step into a bright and welcoming living room and dining area with built-in shelving and stylish vinyl plank flooring. The spacious family room is flooded with natural light and offers serene views of the backyard. A roomy kitchen features hardwood floors

    Jim Shaffer Good Company

    Section Image
  • 15040 Berwick St, Livonia, MI 48154

    $325,000

    • 5 Beds
    • 2 Baths
    • 1,608 Sq Ft
    • 15040 Berwick St
    • Livonia, MI

    Welcome to this charming colonial home in the heart of Livonia, located directly across from the Jack E. Kirksey Community Center. With five spacious bedrooms and two full bathrooms, this newly renovated home offers a perfect blend of classic appeal and modern convenience. The home boasts a large, fenced-in backyard, ideal for outdoor activities, gardening, or simply relaxing in privacy. The

    Jonathan Pan Crown Properties International

    Section Image
  • 15434 Bainbridge St, Livonia, MI 48154

    $299,900

    • 3 Beds
    • 2 Baths
    • 1,125 Sq Ft
    • 15434 Bainbridge St
    • Livonia, MI

    HIGHEST AND BEST DUE BY 6:00PM SUNDAY JUNE 29TH! Beautifully Remodeled Ranch in Stevenson School DistrictThis stunning 3-bedroom, 2-bath ranch offers turnkey living with both bathrooms conveniently located on the main level. Located within the sought-after Stevenson High School District, the home has undergone extensive updates over the past 7 years.Highlights include a fully

    James Wolfe Century 21 Curran & Oberski

    Section Image
  • 29811 Lamar Ln, Livonia, MI 48152

    $299,900

    • 3 Beds
    • 2 Baths
    • 1,125 Sq Ft
    • 29811 Lamar Ln
    • Livonia, MI

    Welcome home to this beautifully updated, move-in ready gem in the heart of Livonia. From the moment you step inside, you’ll be greeted by a light-filled, open-concept living space that’s perfect for both entertaining guests and unwinding in comfort. The original hardwood floors add timeless character, while the stunning floor-to-ceiling front windows fill the home with natural light. The modern

    Anthony Djon Anthony Djon Luxury Real Estate

    Section Image
  • 29647 Gaylord Ct, Livonia, MI 48154

    $365,000

    • 4 Beds
    • 3 Baths
    • 1,687 Sq Ft
    • 29647 Gaylord Ct
    • Livonia, MI

    Tucked away at the end of a quiet street with only five homes, this meticulously maintained 4 bedroom, 1 full bath, 2 powder room, brick ranch with a dormer offers privacy, charm, and an unbeatable location. You have only one neighbor, as the other side borders a serene, city-maintained park the size of a football field. Step inside to hardwood floors and a thoughtfully designed layout. The main

    Rodger Dabish RE/MAX Classic

    Section Image
  • 34958 Parkdale St, Livonia, MI 48150

    $290,000

    • 3 Beds
    • 1.5 Baths
    • 1,142 Sq Ft
    • 34958 Parkdale St
    • Livonia, MI

    Step into this beautifully maintained 3-bedroom, 1.5-bath gem where style meets function. The updated kitchen has fresh white cabinets and modern finishes, perfect for both culinary creativity and everyday convenience. Hardwood floors flow throughout the main level, complemented by a large picture window that bathes the space in natural light.Enjoy bonus living space with a partially finished

    Jaime Burkhart Preferred, Realtors® Ltd

    Section Image
  • 11785 Cardwell St, Livonia, MI 48150

    $415,000

    • 3 Beds
    • 2 Baths
    • 1,784 Sq Ft
    • 11785 Cardwell St
    • Livonia, MI

    A Newer Construction Stunning Livonia Ranch! The heart of this home is a stunning 14-foot island—perfect for meal prep, casual dining, or hosting—complete with built-in cabinets on one side and bar stool seating on the other. Open floor plan is an understatement, the living room has tons of natural sunlight that complements your bright kitchen, perfect for entertaining on any occasion. You have

    David Fisher Keller Williams Advantage

    Section Image
  • 18624 Irving St, Livonia, MI 48152

    $400,000

    • 4 Beds
    • 1.5 Baths
    • 2,100 Sq Ft
    • 18624 Irving St
    • Livonia, MI

    Welcome to 18624 Irving Street! This delightful 4-bedroom, 1.5-bath bungalow features 2,100 square feet of carefully planned living space set on a 0.23-acre lot in the heart of Livonia. With a bright, spacious layout, this home is ideal for both relaxed everyday living and entertaining guests.The backyard is fully fenced for privacy and security, perfect for pets or outdoor gatherings,

    Nicholas Zeoli Real Broker LLC

    Section Image
  • 31260 Mayville St, Livonia, MI 48152

    $425,000

    • 3 Beds
    • 2.5 Baths
    • 1,619 Sq Ft
    • 31260 Mayville St
    • Livonia, MI

    HIGHEST & BEST IS DUE BY MONDAY (7/21/25) BY 4PM. Welcome to this beautifully maintained 3-bed, 2.5-bath ranch offering 1,619 sqft on the main level & an additional 1,305 sqft of finished living space in the basement—perfectly designed for comfort, entertaining & everyday living. The main floor features a warm & inviting layout w/ vaulted ceilings & charming wooden beams in the family room,

    Joel Schmidt Realty Concierge Group

    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 Type Sale Price Title Company
Warranty Deed $300,000 None Listed On Document
Quit Claim Deed -- None Listed On Document
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $215,000 New Conventional
Previous Owner $270,000 New Conventional
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
07/18/2025 07/18/25 Sold $350,000 -2.1% $224 / Sq Ft
06/24/2025 06/24/25 Pending -- -- --
06/20/2025 06/20/25 For Sale $357,500 0.0% $229 / Sq Ft
06/15/2025 06/15/25 Pending -- -- --
06/13/2025 06/13/25 For Sale $357,500 +19.2% $229 / Sq Ft
07/31/2024 07/31/24 Sold $300,000 -14.3% $192 / Sq Ft
07/01/2024 07/01/24 Pending -- -- --
06/07/2024 06/07/24 For Sale $350,000 -- $224 / Sq Ft
Source: Realcomp

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 $3,197 $143,100 $0 $0
2023 $3,040 $136,400 $0 $0
2022 $3,795 $127,100 $0 $0
2021 $3,686 $124,100 $0 $0
2019 $3,537 $114,300 $0 $0
2018 $1,827 $106,000 $0 $0
2017 $3,234 $103,900 $0 $0
2016 $3,061 $94,100 $0 $0
2015 $7,411 $88,130 $0 $0
2012 -- $70,130 $30,000 $40,130
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: Realcomp

MLS Number: 20251006931

Realcomp

APN: 46-039-01-0069-000