• buy
  • rent
  • sell
  • agents
new developmentWORLD OF ELLIMAN
The latest in luxury property, lifestyle & culture, curated just for you.

company

  • about us
  • leadership
  • offices
  • press & news
  • elliman cares
  • join as an agent
  • careers
  • INTERNATIONAL PARTNERSHIP
  • THE ISLES GROUP
  • investors

resources

  • WORLD OF ELLIMAN
  • elliman insider
  • magazines
  • market reports
  • research reports
  • The wealth report
  • Elliman Exclusives
  • Featured Cities
  • guides to buying & selling

brand portfolio

  • new development
  • commercial
  • relocation
  • property management
  • sports & entertainment
  • farm & ranch
  • building broker specialists
  • title services
  • master trust & probate

  • California
  • Colorado
  • Connecticut
  • Florida
  • Massachusetts
  • Mid-Atlantic
  • Nevada
  • New Jersey
  • New York
  • New York City
  • Texas
  • Vermont
  • SITE MAP
  • TERMS
  • PRIVACY
  • COOKIE PREFERENCES
  • DO NOT SELL OR SHARE MY PERSONAL INFORMATION
  • NYS Housing Discrimination Disclosure Notice & Form
  • NYS Standard Operating Procedure
  • NYS Tenants' Rights to Reasonable Accommodations for persons with disabilities
  • California Consumer Privacy Act Notice
  • Texas Consumer Protection Notice
  • Texas Real Estate Commission Information About Brokerage Services
  • text of new york city human rights law
  • new york city commission on human rights
  • nyc source of income discrimination information
  • nyc source of income discrimination tenant faqs

THE SOURCE OF THE DISPLAYED DATA IS EITHER THE PROPERTY OWNER OR PUBLIC RECORD PROVIDED BY NON-GOVERNMENTAL THIRD PARTIES. IT IS BELIEVED TO BE RELIABLE BUT NOT GUARANTEED. FOR COLORADO VIEWERS, INFORMATION ABOUT NON-COMMERCIAL PROPERTIES IS PROVIDED EXCLUSIVELY FOR YOUR PERSONAL, NON-COMMERCIAL USE.

575 MADISON AVENUE, NEW YORK, NY 10022. 212.891.7000 © 2025 DOUGLAS ELLIMAN REAL ESTATE. EQUAL EMPLOYMENT OPPORTUNITY PROVIDER. ALL MATERIAL PRESENTED HEREIN IS INTENDED FOR INFORMATION PURPOSES ONLY. WHILE THIS INFORMATION IS BELIEVED TO BE CORRECT, IT IS REPRESENTED SUBJECT TO ERRORS, OMISSIONS, CHANGES, OR WITHDRAWAL WITHOUT NOTICE. ALL PROPERTY INFORMATION, INCLUDING, BUT NOT LIMITED TO SQUARE FOOTAGE, ROOM COUNT, NUMBER OF BEDROOMS, AND THE SCHOOL DISTRICT IN PROPERTY LISTINGS SHOULD BE VERIFIED BY YOUR OWN ATTORNEY, ARCHITECT, OR ZONING EXPERT. EQUAL HOUSING OPPORTUNITY.LISTING DATA REFRESHED ON MAY 25 2025 AT 6:14 PM.

DOUGLAS ELLIMAN IS A LICENSED REAL ESTATE BROKER IN CALIFORNIA WITH LICENSE # 01947727, COLORADO WITH LICENSE # EC100053892, CONNECTICUT WITH LICENSE # REB.0314827, THE DISTRICT OF COLUMBIA WITH LICENSE # REO40000160, FLORIDA WITH LICENSE # CQ1020232, MARYLAND WITH LICENSE # 645270, MASSACHUSETTS WITH LICENSE # 422764, NEVADA WITH LICENSE # 1454643, NEW JERSEY WITH LICENSE # 0572105, NEW YORK WITH LICENSE # 10991211812, TEXAS WITH LICENSE # 9008706, AND VIRGINIA WITH LICENSE # 0226035659.

POWERED BY PURLIN.AI

24015 PICKETT Ave

farmington, MI 48335

$369,900

  • 3 BR
    1 BA, 1 HALF BA
    APPROX. 2,399 SF
  • contract signed

INTERESTED? LET'S CONNECT

Final offers are due by Saturday, May 17th at 5PM.

Luxury meets character just steps from downtown. Welcome to 24015 Pickett St — a beautifully updated gem that blends timeless charm with modern comforts in one of the most walkable pockets of town.

From the moment you arrive, the curb appeal draws you in with a classic covered porch and a warm, inviting vibe. Inside, you'll find a fully renovated kitchen with a spacious walk-in pantry, ideal for both everyday living and elevated entertaining. The main floor also features a stylish office space with its own half bath — a rare and refined touch for a home of this era.

Upstairs, brand-new carpet (installed May 2025) offers fresh comfort, while the basement has been thoughtfully upgraded with a full indoor French drain system. The home’s layout maximizes storage, including a hidden under-the-stairs closet that feels like a secret bonus and a huge attic that allows for ample storage.

Out back, the private and perfectly sized yard is made for summer gatherings — and yes, there’s a concrete pad ready for a future garage addition.

Whether you’re drawn to the walkable lifestyle, the historic charm, or the investment in smart updates, this home delivers it all with style.

Details

2,399 Sq Ft

6,534 Sq Ft Exterior Space

Single Family Home

$6,541 Annual Tax

Built in 1926

MLS/Listing ID 20250033543

Amenities & Features

Covered

Patio

Porch

Dryer

Free-standing Refrigerator

Gas Cooktop

Washer

Parking - No Garage

Heating - Radiant

Basement

Block

Construction - Brick

Community - Sidewalks

Style - Colonial

Dishwasher

REALCOMP

Source of Data: REALCOMP

Interested in 24015 PICKETT Ave?