$310,000
SOLD SEP 5, 2019

40504 Franklin Mill St Novi, MI 48375

3 Beds
2.5 Baths
1,845 Sq Ft
10,019 Sq Ft Lot

Recently Sold

$168 Per Sq Ft

2% Below List Price

11 Days on Market

Highlights

  • Outdoor Pool
  • Clubhouse
  • Jetted Tub in Primary Bathroom
  • Novi High School Rated A+
  • Ranch Style House
  • 2 Car Direct Access Garage

About This Home

As of February 2025

FANTASTIC NOVI RANCH IN VILLAGE OAKS! WELL MAINTAINED & READY TO MOVE INTO! BRAND NEW CARPET THROUGHOUT MAIN FLOOR & NEW COUNTERTOPS IN KIT. GREAT LOCATION IN SUB CLOSE TO AWARD WINNING VILLAGE OAKS ELEMENTARY! HOME HAS NEUTRAL DECOR THROUGHOUT & BEAUTIFUL CURB APPEAL W/EXTENSIVE LANDSCAPING. LARGE FORMAL LIVING ROOM. EAT-IN KIT HAS TONS OF CABINET & COUNTER SPACE & IS OPEN TO GREAT ROOM. GR HAS VAULTED CEILING, TONS OF NATURAL LIGHT FROM 2 DOOR WALLS & A GAS FP W/BRICK SURROUND. HUGE MASTER SUITE FEATURES WALK-IN CLOSET, WINDOW SEAT & ATTACHED BATH W/JACUZZI TUB & SEPARATE SHOWER W/BATH FITTERS ENCLOSURE & GLASS DOOR. UPDATED FULL BATH ON MAIN LEVEL. FRESHLY PAINTED W/NEW LIGHTING FIXTURES THROUGHOUT HOME. FIN LOWER LEVEL W/LARGE REC AREA. NEW ROOF, FURNACE & A/C. EXTERIOR HAS NEW WOOD TRIM, NEW GUTTERS & DOWNSPOUTS. BEAUTIFUL BACKYARD BOASTS PAVER PATIO W/TONS OF PRIVACY FROM MATURE LANDSCAPING. DON'T MISS THIS ONE! ENJOY THE CLUBHOUSE & COMMON POOL IN THIS WONDERFUL SUB!

Last Agent to Sell the Property

Jamey Kramer

RE/MAX Classic License #6501261596 Listed on: 08/02/2019

RE/MAX Classic

Last Buyer's Agent

Christine Winans

Berkshire Hathaway HomeServices Kee Realty Bham License #6501319579

Berkshire Hathaway HomeServices Kee Realty Bham

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 1975

Lot Details

  • 10,019 Sq Ft Lot
  • Lot Dimensions are 80.00x125.00

HOA Fees

  • $22 Monthly HOA Fees

Home Design

  • Ranch Style House
  • Brick Exterior Construction
  • Poured Concrete
  • Asphalt Roof
  • Vinyl Construction Material

Interior Spaces

  • 1,845 Sq Ft Home
  • Ceiling Fan
  • Gas Fireplace
  • Great Room with Fireplace
  • Finished Basement
  • Sump Pump

Kitchen

  • Freezer
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Jetted Tub in Primary Bathroom

Parking

  • 2 Car Direct Access Garage
  • Garage Door Opener

Outdoor Features

  • Outdoor Pool
  • Patio
  • Exterior Lighting
  • Porch

Utilities

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

Listing and Financial Details

  • Assessor Parcel Number 2225251016
  • $2,000 Seller Concession

Community Details

Overview

  • Fairfield Farms Sub Subdivision

Amenities

  • Clubhouse

Recreation

  • Community Pool

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,652

Year Built

Built in 1975

Lot Details

0

HOA Fees

$22 per month

Listing Details

  • Property Type: Residential
  • Architecture Style: Ranch
  • Architecture Level: 1 Story
  • Assessment: 82.74
  • Year Built: 1975
  • Foundation Features: Sump Pump
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 1

Interior Features

  • Interior Amenities: Cable Available, High Spd Internet Avail, Humidifier, Jetted Tub
  • Fireplace: Yes
  • Fireplace Fuel: Gas
  • Fireplace Locations: Great Room
  • Room Count: 12
  • Total Bedrooms: 3
  • Total Bathrooms: 2.10
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Basement: Yes
  • Basement Type: Finished
  • Kitchen Appliances: Dishwasher, Disposal, Freezer, Range/Stove
  • Sq Ft Combined: 3045
  • Sq Ft Lower Floor: 1200
  • Total Sq Ft: 1845
  • Sq Ft Total Bsmt: 1264

Exterior Features

  • Roof Material: Asphalt
  • Pool: Yes
  • Foundation Details: Basement
  • Construction Materials: Brick, Vinyl, Wood
  • Exterior Features: Club House, Lighting, Pool – Community
  • Foundation Materials: Poured
  • Frontage Feet: 80
  • Porch Type: Patio, Porch
  • Road Frontage Type: Paved

Garage/Parking

  • Garage Size: 2 Car
  • Garage Features: Attached, Direct Access, Door Opener, Electricity
  • 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)
  • Laundry Facilities: No

Condo/Co-op/Association

  • Association Fee Frequency: Annually
  • Association Fee: 266
  • Association Fee: Yes

Schools

  • School District: Novi

Lot Info

  • Homestead: Yes
  • List Price per Acre: 1369565.2174
  • Lot Size Area: 0.23
  • Lot Dimensions: 80.00X125.00
  • Parcel Number: 2225251016

Tax Info

  • Tax Amount Summer: 2979.0000
  • Tax Amount Winter: 673.0000
  • Total Tax: 3652.0000

MLS Schools

  • School District: Novi

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jan 23, 2025
Closed on
Feb 12, 2025
Sold by
Martinez-Perez Marcos
Bought by
Yoshida Elton Hideo Tarui and Yoshida Sylvia Mayumi
Seller's Agent
Yasmin Rogers
EXP Realty Main
Buyer's Agent
Lygia Galizia
Keller Williams Advantage
List Price
$425,000
Sold Price
$440,000
Premium/Discount to List
$15,000
3.53%
Views
90
Current Estimated Value
$448,691

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$8,691
Avg. Annual Appreciation
1.60%
Original Mortgage
$352,000
Outstanding Balance
$351,426
Interest Rate
7.04%
Mortgage Type
New Conventional
Estimated Equity
$92,352

Purchase Details

Listed on
Aug 2, 2019
Closed on
Sep 5, 2019
Sold by
Queen Tamara L and Queen Brian J
Bought by
Martinez Perez Marcos
Seller's Agent
Jamey Kramer
RE/MAX Classic
Buyer's Agent
Christine Winans
Berkshire Hathaway HomeServices Kee Realty Bham
List Price
$315,000
Sold Price
$310,000
Premium/Discount to List
-$5,000
-1.59%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
6.64%
Original Mortgage
$294,500
Interest Rate
3.6%
Mortgage Type
New Conventional

Purchase Details

Closed on
Mar 25, 2005
Sold by
Miller Michael D and Miller Helen K
Bought by
Queen Brian J and Queen Tamara L

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$192,000
Interest Rate
5.12%
Mortgage Type
Fannie Mae Freddie Mac
Source: Public Records

Similar Homes in the area

  • 23533 Nilan Dr, Novi, MI 48375

    $375,000

    • 3 Beds
    • 1.5 Baths
    • 1,400 Sq Ft
    • 23533 Nilan Dr
    • Novi, MI

    Beautiful colonial in desirable Fairfield Farms/Village Oaks Subdivision. Exterior well maintained, paver pathway, large porch and private lot in back. Hardwood floors in living room, eat-in kitchen open to family room with fireplace. Recent updates include; Roof 2019, Furnace/AC 2015, Garage opener and door 2019, Garbage disposal 2020, laminate floors 2018, Storm door 2020, block glass windows

    Sunil Paingol The Paingol Group Realtors Inc

    Section Image
  • 23568 Cranbrooke Dr, Novi, MI 48375

    $349,000

    • 3 Beds
    • 1 Bath
    • 1,250 Sq Ft
    • 23568 Cranbrooke Dr
    • Novi, MI

    What a Gem! You will not be disappointed in this Immaculate and extremely well maintained inside and out 3 br brick and aluminum ranch. Open flowing floor plan. Large living room currently used as a dining room, spacious kitchen overlooking the comfortable family room w/brick and mantelled fireplace w/sliding door wall to the beautiful deck and magnificent fenced yard. 3 nice sized bedrooms

    Santina Palazeti Signature Sotheby's International Realty Nvl

    Section Image
  • 23334 Meadowbrook Rd, Novi, MI 48375

    $299,000

    • 3 Beds
    • 1 Bath
    • 1,144 Sq Ft
    • 23334 Meadowbrook Rd
    • Novi, MI

    Great opportunity! You can be in NOVI in this three-bedroom ranch with NOVI schools for under $300K. Sure, it needs updating, but what a great way to build equity with your remodeling skills. You get to make it the way you want it to be. This home offers 3 Bedrooms, 1 Full Bath, a Full unfinished basement, and a 2-car attached garage with a door opener. All Appliances stay! Plenty of room in this

    Ron Targanski National Realty Centers, Inc

    Section Image
  • 23925 W Le Bost, Novi, MI 48375

    $298,000

    • 3 Beds
    • 1.5 Baths
    • 1,211 Sq Ft
    • 23925 W Le Bost
    • Novi, MI

    Discover this charming 3-bedroom, one and half bath ranch nestled in a serene Novi neighborhood. Built in 1956 and spanning approximately 1,211 sq ft. You'll enjoy a newer roof (2020) and water heater, plus open kitchen floor plans. With fenced, park-like backyard off the kitchen, it's perfect for gathering or quiet relaxation. Situated on just over a fenced lot, this property combines privacy

    Xu Jiang Real Estate One-Troy

    Section Image
  • 26018 Whipple, Novi, MI 48375

    $369,000

    • 3 Beds
    • 1.5 Baths
    • 1,350 Sq Ft
    • 26018 Whipple
    • Novi, MI

    This beautifully updated 3 bedroom ranch combines modern comfort with timeless charm and exceptional curb appeal. Set among mature landscaping, the home welcomes you with an open-concept floor plan, updated flooring, and neutral finishes throughout. The stylish kitchen features quartz counters, stainless appliances, and plenty of space for cooking and entertaining. The adjoining room offers a

    DANIEL BEIRNE OpenDoor Brokerage LLC

    Section Image
  • 44620 W 11 Mile Rd, Novi, MI 48375

    $350,000

    • 2 Beds
    • 2 Baths
    • 1,364 Sq Ft
    • 44620 W 11 Mile Rd
    • Novi, MI

    Move-in ready and well-maintained, this home features 2 bedrooms, 2 full bathrooms, and a rare setup with both a 2-car attached garage and a 2-car detached garage—ideal for car enthusiasts, storage, or a workshop. Situated on a large lot with plenty of parking, the property offers a bright family room with a door wall leading to a private patio, perfect for relaxing or entertaining. The full

    Jason Strat Rocket Homes Real Estate LLC

    Section Image
  • 822 Springfield Dr, Northville, MI 48167

    $369,000

    • 4 Beds
    • 3 Baths
    • 2,682 Sq Ft
    • 822 Springfield Dr
    • Northville, MI

    4 bedroom, 3 full bath home located in one of Northville's most sought-after neighborhoods! Custom built home by the original one-time owners. Designed ahead of its time! Charming curb appeal, double front doors, covered front porch, large 3 car attached garage and private backyard lot. The heart of this home is the expansive open kitchen and family room featuring a vaulted ceiling, wood burning

    Katherine Keener Berkshire Hathaway Tomie Raines

    Section Image
  • 46275 W 11 Mile Rd, Novi, MI 48374

    $299,900

    • 3 Beds
    • 1 Bath
    • 1,083 Sq Ft
    • 46275 W 11 Mile Rd
    • Novi, MI

    Rare opportunity in Novi! This 3 bedroom charming ranch home sits on one of the largest lots in the area. Featuring a desirable wraparound driveway and endless potential - move in as-is or build your own custom dream home! This home is surrounded by woods on 2 of it's sides. Located within 1 mile of top-rated Novi schools, including Parkview Elementary, Novi Meadows, Novi Middle, and Novi

    Devin Simpson GoodHome Realty LLC

    Section Image
  • 23095 Beck Rd, Novi, MI 48374

    $375,000

    • 3 Beds
    • 2 Baths
    • 1,601 Sq Ft
    • 23095 Beck Rd
    • Novi, MI

    Tucked away on a private, wooded half-acre, this ranch in Novi with Northville schools with a unique lifestyle. While just minutes from all the shopping, dining, and freeway access Novi is known for, this home feels like an escape. As you pull into the drive, you're surrounded by trees and serene nature, set apart from the bustle. Inside you'll find a spacious 3-bedroom, 2-bath single story

    John Goodman Century 21 Curran & Oberski

    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 $440,000 Dream Title & Escrow
Warranty Deed $310,000 Title One Inc
Warranty Deed $274,900 First Michigan Title Inc
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $352,000 New Conventional
Closed $352,000 New Conventional
Previous Owner $140,000 New Conventional
Previous Owner $114,500 New Conventional
Previous Owner $294,500 New Conventional
Previous Owner $223,200 Unknown
Previous Owner $192,000 Fannie Mae Freddie Mac
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
02/14/2025 02/14/25 Sold $440,000 +3.5% $238 / Sq Ft
01/26/2025 01/26/25 Pending -- -- --
01/23/2025 01/23/25 For Sale $425,000 +37.1% $230 / Sq Ft
09/05/2019 09/05/19 Sold $310,000 -1.6% $168 / Sq Ft
08/13/2019 08/13/19 Pending -- -- --
08/02/2019 08/02/19 For Sale $315,000 -- $171 / 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
2023 $5,177 $172,450 $0 $0
2022 $5,767 $163,100 $0 $0
2020 $4,678 $149,300 $20,600 $128,700
2015 -- $118,000 $0 $0
2014 -- $90,300 $0 $0
2011 -- $98,950 $0 $0
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Realcomp

MLS Number: 219076589

Realcomp

APN: 22-25-251-016