$440,000
SOLD FEB 14, 2025

40504 Franklin Mill St Novi, MI 48375

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

Recently Sold

$238 Per Sq Ft

4% Above List Price

2 Days on Market

Highlights

  • Ranch Style House
  • 2 Car Direct Access Garage
  • Patio
  • Village Oaks Elementary School Rated A+
  • Porch
  • Forced Air Heating and Cooling System

About This Home

As of February 2025

Welcome to this inviting ranch-style home offering the perfect blend of comfort and convenience. Freshly painted with new carpet, AND in Novi school district. With 3 spacious bedrooms and 2.5 bathrooms, this home is ideal for families or those who love to entertain. The main living space flows effortlessly from the bright living room to the modern kitchen, creating a welcoming environment for gatherings. Includes stainless steel appliances and ample counter space. A Master suite that's a serene retreat with an en-suite bathroom featuring a double vanity and walk-in shower, along with a jetted tub. Schedule your showing today!

Last Agent to Sell the Property

Yasmin Rogers

EXP Realty Main License #6501405305

EXP Realty Main

Last Buyer's Agent

Lygia Galizia

Keller Williams Advantage License #6501418880

Keller Williams Advantage

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.00 x 125.00

HOA Fees

  • $22 Monthly HOA Fees

Home Design

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

Interior Spaces

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

Kitchen

  • Free-Standing Gas Range
  • Microwave

Bedrooms and Bathrooms

  • 3 Bedrooms

Laundry

  • Dryer
  • Washer

Parking

  • 2 Car Direct Access Garage
  • Garage Door Opener

Outdoor Features

  • Patio
  • Porch

Location

  • Ground Level

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas

Community Details

  • Fairfield Farms Association
  • Fairfield Farms Sub Subdivision

Listing and Financial Details

  • Assessor Parcel Number 2225251016

Home Details

Home Type

Single Family

Est. Annual Taxes

$6,280

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: 140.00
  • Year Built: 1975
  • State Equalized Value: 186440.0000
  • Foundation Features: Sump Pump
  • Entry Location: Ground Level w/Steps
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 1

Interior Features

  • 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: Partially Finished
  • Kitchen Appliances: Dryer, Free-Standing Gas Range, Free-Standing Refrigerator, Microwave, Washer
  • Sq Ft Combined: 3045
  • Sq Ft Lower Floor: 1200
  • Total Sq Ft: 1845
  • Sq Ft Total Bsmt: 1264

Exterior Features

  • Foundation Details: Basement
  • Construction Materials: Brick, Vinyl, Wood
  • Foundation Materials: Poured
  • Frontage Feet: 80
  • Porch Type: Patio, Porch
  • Road Frontage Type: Paved

Garage/Parking

  • Garage Size: 2 Car
  • Garage Features: Direct Access, Electricity, Door Opener, Attached
  • Garage: Yes

Utilities

  • Heating Fuel: Natural Gas
  • Cooling: Ceiling Fan(s), Central Air
  • Heating: Forced Air
  • Sewer: Public Sewer (Sewer-Sanitary)
  • Water Source: Public (Municipal)

Condo/Co-op/Association

  • Association Fee Frequency: Annually
  • Phone: fairfieldfarms.com
  • Association Fee: 266
  • Association Contact: Fairfield Farms
  • Association Fee: Yes

Schools

  • School District: Novi

Lot Info

  • Homestead: Yes
  • Lot Size Area: 0.23
  • Lot Dimensions: 80.00 x 125.00
  • Parcel Number: 2225251016

Tax Info

  • Tax Amount Summer: 5177.0000
  • Tax Amount Winter: 1103.0000
  • Total Tax: 6280.0000
  • Taxable Value: 172390.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%
Total Days on Market
2
Views
90
Current Estimated Value
$440,669

Home Financials for this Owner

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

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

Map

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

Similar Homes in Novi, MI

  • 40692 Village Oaks, Novi, MI 48375

    $439,000

    • 4 Beds
    • 2 Baths
    • 1,734 Sq Ft
    • 40692 Village Oaks
    • Novi, MI

    FANTASTIC OPPORTUNITY TO BE LAKE FRONT IN NOVI! THIS 4 BEDROOM, 2 FULL BATH BI-LEVEL IN VILLAGE OAKS HAS BEEN WELL-MAINTAINED AND BOASTS OVER 150 FEET OF LAKE FRONTAGE. BEAUTIFUL LAMINATE FLOORS THROUGHOUT MOST OF HOME. THE LOWER LEVEL OFFERS A FAMILY ROOM WITH NATURAL FIREPLACE AND BRICK SURROUND WITH A DOOR WALL TO THE PATIO, BEDROOM, FULL BATH AND LAUNDRY ROOM. ON THE UPPER LEVEL YOU'LL FIND

    Jamey Kramer RE/MAX Classic

    Section Image
  • 41152 Hollydale, Novi, MI 48375

    $394,900

    • 3 Beds
    • 2 Baths
    • 2,329 Sq Ft
    • 41152 Hollydale
    • Novi, MI

    Welcome to this beautifully maintained 3-bedroom, 2-bath brick ranch! Located in a desirable neighborhood, this home features a spacious, open floor plan perfect for both relaxing and entertaining. The inviting living room leads to a bright and airy kitchen with plenty of cabinet space and room for dining. There is a 4th bedroom in the basement. Drive way was done in 2024, New Kitchen 2024, Water

    Mays Al Raheem Century 21 Professionals Sterling Heights

    Section Image
  • 22626 Deerfield Rd, Novi, MI 48375

    $489,900

    • 4 Beds
    • 2.5 Baths
    • 2,124 Sq Ft
    • 22626 Deerfield Rd
    • Novi, MI

    Outstanding location for this move-in ready 4 Bedroom, 2 1/2 Bath Colonial, deep within the Heathwyke subdivision (part of Village Oaks community), offering acclaimed Novi Public Schools; Village Oaks Elementary, Novi Meadows MS, and Novi High School. Features of this lovely home include a bright and functional floor plan, an updated kitchen with ample cabinetry, stainless steel appliances and

    Maria Bardy Coldwell Banker Professionals Birm

    Section Image
  • 22548 Heatherwoode, Novi, MI 48375

    $550,000

    • 4 Beds
    • 3 Baths
    • 1,882 Sq Ft
    • 22548 Heatherwoode
    • Novi, MI

    Welcome to 22548 Heatherwoode – a beautifully updated ranch home located in Novi’s prestigious Village Oaks community! This 4-bedroom, 3-bath home offers over 2,500 sq ft of stylish, single-level living with an open-concept layout with abundant natural light throughout. The spacious family room features a wall of windows, flowing seamlessly into the dining area and a gourmet kitchen with granite

    Joseph Delia Keller Williams Paint Creek

    Section Image
  • 22511 Deerfield Rd, Novi, MI 48375

    $449,900

    • 3 Beds
    • 3 Baths
    • 1,440 Sq Ft
    • 22511 Deerfield Rd
    • Novi, MI

    This beautifully updated 3-bedroom, 3-bathroom ranch home offers 1,440 sq ft of modern living space. The open-concept layout features a spacious living room with a large three-panel door wall leading to the backyard, allowing for an abundance of natural light. The kitchen boasts all new appliances and cabinetry. The primary bedroom includes an ensuite bathroom for added privacy. The finished

    Kyle Lang RE/MAX Dream Properties

    Section Image
  • 41772 Aspen Dr, Novi, MI 48375

    $356,900

    • 4 Beds
    • 2 Baths
    • 1,628 Sq Ft
    • 41772 Aspen Dr
    • Novi, MI

    Welcome to 41772 Aspen Drive, a charming residence nestled in the heart of Novi, MI. This delightful home offers a perfect blend of comfort and convenience, situated on a generous 0.27-acre lot. Located within the highly acclaimed Novi School District and walking distance to the elementary school, it provides an excellent location within the area. Once inside, you will find an open concept home

    Chris Cogswell Preferred, Realtors Ltd

    Section Image
  • 41870 Chattman St, Novi, MI 48375

    $524,900

    • 3 Beds
    • 2.5 Baths
    • 2,137 Sq Ft
    • 41870 Chattman St
    • Novi, MI

    Downsize in Style! This Sprawling All Brick Ranch Offers Single Level Living with Generous Room Sizes and Beautiful Views! Refinished/Never Lived on Hardwood Floors Throughout the Bedrooms, Hallway and Living Room. Master Bedroom with Dual Closets, Full Bath, and Dressing Area. Kitchen Features Maple Cabinets with Soft Close Drawers and Pull Out Shelves, Built in Appliances, Ceramic Tiled

    James Balk Real Estate One-Troy

    Section Image
  • 21950 Greentree Ln, Novi, MI 48375

    $439,900

    • 3 Beds
    • 2.5 Baths
    • 1,784 Sq Ft
    • 21950 Greentree Ln
    • Novi, MI

    OPEN HOUSE THIS SATURDAY 5/10 from 12-2pm... Welcome to 21950 Greentree Lane, a comfortable colonial-style home located in the established Whispering Meadows neighborhood of Novi. This property offers a spacious and functional layout with multiple living areas to suit a variety of needs. The dual-entry design provides easy access to both the formal living and dining rooms, creating a natural flow

    Julie Tucker KW Realty Livingston

    Section Image
  • 42006 Aspen Dr, Novi, MI 48375

    $499,900

    • 4 Beds
    • 2.5 Baths
    • 2,163 Sq Ft
    • 42006 Aspen Dr
    • Novi, MI

    WELCOME HOME TO THIS NEWER BUILT 4-BEDROOM COLONIAL WITH AN EXCELLENT LOCATION CLOSE TO SHOPPING, RESTAURANTS, FREEWAYS, AND MORE*STEP INTO A 2-STORY FOYER, LARGE LIVING ROOM AND ADJACENT DINING ROOM WITH LARGE BAY WINDOW*GOURMET KITCHEN WITH GRANITE, HARDWOOD FLOORS, TILED BACK SPLASH, STAINLESS STEEL APPLIANCES, SNACK BAR AND PANTRY*KITCHEN OPENS TO A LARGE BREAKFAST NOOK WITH A DOOR WALL TO A

    Robert Harrell Real Estate One-Commerce

    Section Image

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

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

Source: Realcomp

MLS Number: 20250004708

Realcomp

APN: 22-25-251-016