Nestled on a picturesque .71-acre parcel with serene pond frontage in highly sought-after Franklin, this exceptional three level above grade residence offers nearly 3,800 square feet including 5 bedrooms, 4 full baths, 1 powder room, expansive living spaces and abundant storage. Designed to impress inside and out, the property showcases a stunning heated gunite saltwater pool (2024) surrounded by brick paver pool decking, patio, and walkway, that create a private outdoor retreat overlooking tranquil water views. Recent major improvements include a new roof completed in 2024 along with the added peace of mind and convenience of a whole-house generator and new a/c units (2019). Multiple gathering spaces throughout the home include fireplaces in the kitchen, living room, and family room, creating warmth and ambiance across every level. The sun-filled marble floored solarium offers a peaceful escape year-round, while two bedroom suites with ensuite baths provide elevated comfort and privacy. The lower-level guest suite with direct exterior access creates ideal accommodations for extended family, visitors, or multi-generational living. Combining spacious interiors, scenic pond frontage, and exceptional outdoor living in one of Metro Detroit’s most charming villages, this distinctive property presents a rare opportunity to enjoy luxury living in a truly idyllic setting where you'll encounter friendly folks walking and biking on neighborhood streets.
New construction
$749,000
25461 Tweed Dr, Franklin, MI 48025
5beds
3,789sqft
Single Family Residence
Built in 1959
0.71 Acres Lot
$734,800 Zestimate®
$198/sqft
$-- HOA
What's special
- 12 days
- 1,190
- 42
Zillow last checked:
Listing updated:
Listed by:
Darlene Jackson 248-302-0414,
Max Broock, REALTORS®-Birmingham 248-644-6700
Source: Realcomp II,MLS#: 20261066558
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 5
- Full bathrooms: 4
- 1/2 bathrooms: 1
Primary bedroom
- Level: Upper
- Area: 221
- Dimensions: 17 X 13
Bedroom
- Level: Lower
- Area: 120
- Dimensions: 12 X 10
Bedroom
- Level: Lower
- Area: 342
- Dimensions: 19 X 18
Bedroom
- Level: Upper
- Area: 120
- Dimensions: 12 X 10
Bedroom
- Level: Upper
- Area: 169
- Dimensions: 13 X 13
Primary bathroom
- Level: Upper
- Area: 40
- Dimensions: 8 X 5
Other
- Level: Lower
- Area: 72
- Dimensions: 9 X 8
Other
- Level: Lower
- Area: 35
- Dimensions: 7 X 5
Other
- Level: Upper
- Area: 60
- Dimensions: 10 X 6
Other
- Level: Entry
- Area: 28
- Dimensions: 7 X 4
Family room
- Level: Lower
- Area: 550
- Dimensions: 25 X 22
Other
- Level: Lower
- Area: 256
- Dimensions: 16 X 16
Kitchen
- Level: Entry
- Area: 378
- Dimensions: 21 X 18
Laundry
- Level: Lower
- Area: 48
- Dimensions: 8 X 6
Living room
- Level: Entry
- Area: 345
- Dimensions: 23 X 15
Heating
- Baseboard, Natural Gas
Cooling
- Central Air
Appliances
- Included: Built In Refrigerator, Down Draft, Dishwasher, Disposal, Double Oven, Dryer, Gas Cooktop, Washer
- Laundry: Gas Dryer Hookup, Laundry Room, Washer Hookup
Features
- High Speed Internet, Programmable Thermostat
- Has basement: No
- Has fireplace: Yes
- Fireplace features: Family Room, Gas, Kitchen, Living Room
Interior area
- Total interior livable area: 3,789 sqft
- Finished area above ground: 3,789
Video & virtual tour
Property
Parking
- Total spaces: 2.5
- Parking features: Twoand Half Car Garage, Attached, Direct Access, Electricityin Garage, Garage Door Opener, Side Entrance
- Attached garage spaces: 2.5
Features
- Levels: Tri Level
- Entry location: GroundLevelwSteps
- Patio & porch: Covered, Patio, Porch, Terrace
- Exterior features: Chimney Caps, Gutter Guard System
- Pool features: In Ground
- Waterfront features: Pond
Lot
- Size: 0.71 Acres
- Dimensions: 140 x 189 x 180 x 205
- Features: Dead End Street, Water View, Sprinklers
Details
- Parcel number: 2408153005
- Special conditions: Short Sale No,Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Split Level
- Property subtype: Single Family Residence
Materials
- Brick
- Foundation: Crawl Space, Slab
- Roof: Asphalt
Condition
- Platted Sub,Quick Delivery Home
- New construction: Yes
- Year built: 1959
Utilities & green energy
- Electric: Volts 220, Circuit Breakers, Generator
- Sewer: Public Sewer
- Water: Well
- Utilities for property: Above Ground Utilities, Cable Available
Community & HOA
Community
- Security: Fire Alarm
- Subdivision: MC KINNEYS FRANKLIN VILLAGE FARMS
HOA
- Has HOA: No
Location
- Region: Franklin
Financial & listing details
- Price per square foot: $198/sqft
- Tax assessed value: $260,540
- Annual tax amount: $9,180
- Date on market: 8/20/2026
- Cumulative days on market: 107 days
- Listing agreement: Exclusive Right To Sell
- Listing terms: Cash,Conventional
Estimated market value
$734,800
$698,000 - $772,000
$5,995/mo
Price history
| Date | Event | Price |
|---|---|---|
| 8/20/2026 | Listed for sale | $749,000$198/sqft |
Source:  Realcomp II #20261066558 Report a problem | ||
| 8/18/2026 | Listing removed | $749,000$198/sqft |
Source: Realcomp II #20261032510 Report a problem | ||
| 8/6/2026 | Price change | $749,000-11.9%$198/sqft |
Source: Realcomp II #20261032510 Report a problem | ||
| 5/15/2026 | Listed for sale | $850,000$224/sqft |
Source: Realcomp II #20261032510 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $6,550 +4.9% | $381,380 +7.8% |
| 2024 | $6,243 +5.5% | $353,650 +8.4% |
| 2023 | $5,920 -2% | $326,110 +15.3% |
| 2022 | $6,039 -1.3% | $282,880 +1.1% |
| 2021 | $6,119 | $279,790 +1.6% |
| 2020 | -- | $275,440 +2.7% |
| 2019 | $7,869 +30.7% | $268,270 +0.2% |
| 2018 | $6,020 -17.8% | $267,760 |
| 2017 | $7,326 | $267,760 +5.4% |
| 2016 | $7,326 | $254,090 +8.4% |
| 2015 | -- | $234,460 +4.6% |
| 2014 | -- | $224,110 +15.7% |
| 2011 | -- | $193,770 -15.8% |
| 2010 | $7,654 +6.1% | $230,150 -10% |
| 2009 | $7,215 +94.8% | $255,690 -46.4% |
| 2005 | $3,704 | $477,020 +59.7% |
| 2003 | -- | $298,700 +27.2% |
| 2002 | -- | $234,840 +39.5% |
| 2001 | $6,511 +8.1% | $168,290 +3.2% |
| 2000 | $6,022 | $163,080 |
Find assessor info on the county website
Monthly payment
Est. payment
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.Climate risks
Neighborhood: 48025
Similar homes
- $899,9003 bd4 ba3.9k sqft25933 Hersheyvale Dr, Franklin, MI 48025For Sale
MLS ID #20261061545, Chris G Pero, Max Broock, REALTORS®-Birmingham. Realcomp II - $960,0004 bd3 ba4.2k sqft22636 King Richard Ct, Beverly Hills, MI 48025For Sale
MLS ID #20261068394, Chris G Pero, Max Broock, REALTORS®-Birmingham. Realcomp II - $739,0004 bd4 ba5.5k sqft4566 Walden Dr, Bloomfield Hills, MI 48301For Sale
MLS ID #20261065196, Nicolas Petrucci, @properties Christie's Int'l R.E. Birmingham. Realcomp II - $774,9004 bd4 ba4.6k sqft1211 Kensington Rd, Bloomfield Hills, MI 48304For Sale
MLS ID #20261068569, Jeffrey S Barker, Max Broock, REALTORS®-Birmingham. Realcomp II - $750,0003 bd2 ba4.6k sqft2626 W Wattles Rd, Troy, MI 48098For SaleMLS ID #20261068862, Tom Nelson, Real Estate One-Rochester. Realcomp II
- $649,9996 bd6 ba2.7k sqft17348 Hilton St, Southfield, MI 48075For SaleMLS ID #20261070262, Moshe Lange, Max Broock, REALTORS®-Birmingham. Realcomp II
- $779,0005 bd3 ba4k sqft745 Hawthorne Dr, Bloomfield Hills, MI 48304For SaleMLS ID #20261062946, Pashko P Dushaj, Century 21 Professionals Utica. Realcomp II
- $749,9004 bd3 ba3.9k sqft3265 Bloomfield Shore Dr, West Bloomfield, MI 48323For SaleMLS ID #20261059071, Chris G Pero, Max Broock, REALTORS®-Birmingham. Realcomp II
- $699,0004 bd5 ba4.1k sqft2855 Cranbrook Ridge Ct, Rochester, MI 48306For SaleMLS ID #20261069105, Dan A Gutfreund, Signature Sotheby's International Realty Bham. Realcomp II
- $650,0004 bd4 ba3.4k sqft4665 W Maple Rd, Bloomfield Hills, MI 48301For SaleMLS ID #20261022124, Olga Mackenzie, Brookstone, Realtors LLC. Realcomp II
- $728,9005 bd4 ba4.4k sqft7439 Millwood, West Bloomfield, MI 48322For SaleMLS ID #20261047275, Timothy Egan, RE/MAX Classic. Realcomp II
- $949,9005 bd4 ba3.1k sqft2985 Summervale Ln, Bloomfield Hills, MI 48301For SaleMLS ID #20261066997, John A Apap, @properties Christie's Int'l R.E. Birmingham. Realcomp II
- $600,0004 bd4 ba4.8k sqft3086 Bloomfield Park Dr, West Bloomfield, MI 48323For SaleMLS ID #20261070277, Tony Yazbeck, KW Metro. Realcomp II
- $899,9005 bd5 ba5.4k sqft1830 Lone Pine Rd, Bloomfield Hills, MI 48302For SaleMLS ID #20261062334, John A Apap, @properties Christie's Int'l R.E. Birmingham. Realcomp II
- $559,9003 bd3 ba2.5k sqft27869 Old Colony St, Farmington Hills, MI 48334For SaleMLS ID #20261058671, John K Goodman, Century 21 Curran & Oberski. Realcomp II
- $649,9005 bd4 ba3.4k sqft4301 Macqueen Dr, West Bloomfield, MI 48323For SaleMLS ID #20261051503, Ray Ashley, Coldwell Banker Town & Country. Realcomp II
- $599,9004 bd4 ba3.5k sqft6679 Edinborough Dr, West Bloomfield, MI 48322For SaleMLS ID #20261057690, Rachael Abraham, Max Broock, REALTORS®-Bloomfield Hills. Realcomp II
- $995,0003 bd4 ba3.7k sqft3159 Middlebury Ln, Bloomfield Hills, MI 48301For SaleMLS ID #20261066212, James C Smith, Max Broock, REALTORS®-Birmingham. Realcomp II
- $400,0004 bd3 ba2.7k sqft31917 Olde Franklin Dr, Farmington Hills, MI 48334For SaleMLS ID #20261069173, Mo Thweny, Max Broock Realtors. Realcomp II
- $650,0004 bd5 ba5.4k sqft19262 Strathcona Dr, Detroit, MI 48203For SaleMLS ID #20261066194, Austin Black II, @properties Christie's Int'l R.E. Detroit. Realcomp II
