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.
Sold for $350,000 on 07/18/25
$350,000
17550 Mayfield St, Livonia, MI 48152
4beds
2,661sqft
Single Family Residence
Built in 1952
0.69 Acres Lot
$351,200 Zestimate®
$132/sqft
$2,794 Estimated rent
What's special
Zillow last checked: 7 hours ago
Listing updated: August 02, 2025 at 03:00pm
Listed by:
Dave MacFarland 734-637-7120,
Keller Williams Advantage
Bought with:
Jamie Proper, 6506049386
Brookstone, Realtors LLC
Source: Realcomp II,MLS#: 20251006931

Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 2
- Full bathrooms: 1
- 1/2 bathrooms: 1
Primary bedroom
- Level: Entry
- Dimensions: 14 X 14
Heating
- Forced Air, Natural Gas
Cooling
- Ceiling Fans, Central Air
Appliances
- Included: Built In Electric Oven, Dishwasher, Disposal, Dryer, Electric Cooktop, Free Standing Refrigerator, Gas Cooktop, Washer
- Laundry: Laundry Room
Features
- Entrance Foyer, High Speed Internet
- Basement: Partial,Partially Finished
- Has fireplace: Yes
- Fireplace features: Basement, Family Room, Wood Burning
Interior area
- Total interior livable area: 2,661 sqft
- Finished area above ground: 1,561
- Finished area below ground: 1,100
Property
Parking
- Total spaces: 2.5
- Parking features: Twoand Half Car Garage, Attached, Electricityin Garage
- Attached garage spaces: 2.5
Features
- Levels: One
- Stories: 1
- Entry location: GroundLevel
- Patio & porch: Covered, Patio, Porch
- Exterior features: Lighting
- Pool features: None
- Fencing: Back Yard,Fenced,Fencing Allowed
Lot
- Size: 0.69 Acres
- Dimensions: 100 x 300
- Features: Wooded
Details
- Additional structures: Sheds
- Parcel number: 46039010069000
- Special conditions: Short Sale No,Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Ranch
- Property subtype: Single Family Residence
Materials
- Stone, Wood Siding
- Foundation: Basement, Block
- Roof: Asphalt
Condition
- New construction: No
- Year built: 1952
Utilities & green energy
- Electric: Circuit Breakers
- Sewer: Public Sewer
- Water: Community, Public
- Utilities for property: Cable Available
Community & neighborhood
Location
- Region: Livonia
- Subdivision: GREEN BRIER ESTATE SUB
Other
Other facts
- Listing agreement: Exclusive Right To Sell
- Listing terms: Cash,Conventional
Services availability
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$351,200