Welcome to this exceptional 5-bedroom, 3.5-bath home in the Trail Creek Subdivision! Offering the perfect blend of space and functionality, this home features **5 bedrooms plus a dedicated first-floor office**, making it ideal for working from home or a growing family.
The thoughtfully designed floor plan includes a **first-floor primary suite**, while the four additional bedrooms are upstairs. Two bedrooms are located on each side of the upper level with a full bath between each pair, providing an ideal layout for family and guests.
Step inside to a grand two-story foyer with an impressive staircase. The spacious living room features vaulted ceilings, a gas fireplace, and abundant natural light. The kitchen offers granite countertops, ample cabinetry, and all appliances stay. The adjoining dining area opens to a stamped concrete patio accented by decorative light posts.
Just inside the attached 3-car garage are the first-floor laundry room and half bath.
The finished basement is an entertainer's dream with a huge wet bar, DJ booth, dance floor, cash register, and stereo system that stays. You'll also find plenty of dedicated storage space.
For peace of mind, Weathergard windows were installed in 2017 and include a transferable 35-year warranty. The seller is also providing the Certificate of Occupancy.
Trail Creek residents enjoy access to a community pool, clubhouse, and tennis courts. This home truly has it all—space, updates, amenities, and an unbeatable floor plan!
Pending
$484,900
23313 Crescent Ridge Dr, New Boston, MI 48164
5beds
3,900sqft
:
Get pre-qualified$3,418/mo
Single Family Residence
Built in 2004
7,405 Square Feet Lot
$491,100 Zestimate®
$124/sqft
$75/mo HOA
What's special
- 23 days |
- 68 |
- 2 |
Zillow last checked:
Listing updated:
Listed by:
Sarah Stoner 734-516-7167,
Berkshire Hathaway HomeServices Kee Realty Browns 734-676-2900,
Mary Stockert 734-652-7388,
Berkshire Hathaway HomeServices Kee Realty Browns
Source: Realcomp II,MLS#: 20261050825
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
Primary bedroom
- Level: Entry
- Area: 208
- Dimensions: 13 X 16
Bedroom
- Level: Second
- Area: 143
- Dimensions: 13 X 11
Bedroom
- Level: Second
- Area: 143
- Dimensions: 13 X 11
Bedroom
- Level: Second
- Area: 121
- Dimensions: 11 X 11
Bedroom
- Level: Second
- Area: 121
- Dimensions: 11 X 11
Primary bathroom
- Level: Entry
- Area: 130
- Dimensions: 10 X 13
Other
- Level: Second
- Area: 50
- Dimensions: 10 X 5
Other
- Level: Second
- Area: 35
- Dimensions: 7 X 5
Other
- Level: Entry
- Area: 25
- Dimensions: 5 X 5
Dining room
- Level: Entry
- Area: 110
- Dimensions: 11 X 10
Flex room
- Level: Entry
- Area: 120
- Dimensions: 12 X 10
Kitchen
- Level: Entry
- Area: 143
- Dimensions: 11 X 13
Laundry
- Level: Entry
- Area: 40
- Dimensions: 5 X 8
Living room
- Level: Entry
- Area: 361
- Dimensions: 19 X 19
Heating
- Forced Air, Natural Gas
Cooling
- Ceiling Fans, Central Air
Appliances
- Included: Bar Fridge, Dishwasher, Disposal, Dryer, Free Standing Gas Range, Free Standing Refrigerator, Microwave, Washer
Features
- Wet Bar
- Basement: Full,Partially Finished
- Has fireplace: Yes
- Fireplace features: Family Room, Gas
Interior area
- Total interior livable area: 3,900 sqft
- Finished area above ground: 2,700
- Finished area below ground: 1,200
Property
Parking
- Total spaces: 3
- Parking features: Three Car Garage, Attached, Electricityin Garage, Garage Door Opener
- Garage spaces: 3
Features
- Levels: Two
- Stories: 2
- Entry location: GroundLevelwSteps
- Patio & porch: Patio
- Pool features: Community
Lot
- Size: 7,405 Square Feet
- Dimensions: 70 x 105
Details
- Parcel number: 75089050059000
- Special conditions: Short Sale No,Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Contemporary
- Property subtype: Single Family Residence
Materials
- Brick, Vinyl Siding
- Foundation: Basement, Poured, Sump Pump
- Roof: Asphalt
Condition
- New construction: No
- Year built: 2004
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
Community & HOA
Community
- Subdivision: REPLAT 1 OF WAYNE COUNTY CONDO SUB PLAN 605
HOA
- Has HOA: Yes
- Services included: Maintenance Grounds, Snow Removal
- HOA fee: $225 quarterly
- HOA phone: 734-285-4442
Location
- Region: New Boston
Financial & listing details
- Price per square foot: $124/sqft
- Tax assessed value: $177,034
- Annual tax amount: $7,087
- Date on market: 7/8/2026
- Cumulative days on market: 23 days
- Listing agreement: Exclusive Right To Sell
- Listing terms: Cash,Conventional,FHA,Usda Loan,Va Loan
- Exclusions: Exclusion(s) Exist
Estimated market value
Zestimate®
$491,100
Estimated sales range
$467,000 - $516,000
Rent Zestimate®
$3,798/mo
Price history
| Date | Event | Price |
|---|---|---|
| 7/10/2026 | Pending sale | $484,900$124/sqft |
Source: | ||
| 7/8/2026 | Listed for sale | $484,900-2.8%$124/sqft |
Source: | ||
| 11/24/2025 | Listing removed | $499,000$128/sqft |
Source: | ||
| 10/30/2025 | Price change | $499,000-2%$128/sqft |
Source: | ||
| 10/3/2025 | Listed for sale | $509,000+167.9%$131/sqft |
Source: | ||
| 8/28/2008 | Sold | $190,000$49/sqft |
Source: | ||
Public tax history
Tax history is unavailable.
Monthly payment
Est. payment
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.Climate risks
Neighborhood: 48164
Nearby schools
GreatSchools rating
- 8/10Brown Elementary SchoolGrades: PK,1-5Distance: 1.2 mi
- 7/10Carl T. Renton Jr. High SchoolGrades: 6-8Distance: 1.1 mi
- 6/10Huron High SchoolGrades: 9-12Distance: 1.2 mi
- $406,700-- bd2 ba2.5k sqft23313 Crescent Ridge Dr #59, New Boston, MI 48164Off Market
Save - $382,5004 bd3 ba2k sqft23285 Crescent Ridge Dr #60, New Boston, MI 48164Off Market
Save - $376,6003 bd3 ba1.7k sqft23341 Crescent Ridge Dr #58, New Boston, MI 48164Off Market
Save - $--3 bd3 ba1.7k sqft23341 Crescent Ridge Dr, New Boston, MI 48164Off Market
Save - $340,800-- bd2 ba1.7k sqft23369 Crescent Ridge Dr #57, New Boston, MI 48164Off Market
Save - $394,8993 bd2 ba1.5k sqft23150 Waterview Dr, New Boston, MI 48164Sold
Save - $424,9004 bd2 ba2.3k sqft23324 Crescent Ridge Dr #42, New Boston, MI 48164Off Market
Save - $373,100-- bd2 ba2.3k sqft23257 Crescent Ridge Dr #61, New Boston, MI 48164Off Market
Save
A local agent can set up tours, give advice and negotiate with sellers.






