Welcome to Holiday Farms Subdivision!!! This beautifully updated tri-level sits on almost 1 wooded and fenced acre!!! The Huge fenced in yard with mature trees, private patio for entertaining, storage shed, creates a private setting with endless possibilities!!!! Walking in, you are in awe with the stunning open NEW kitchen with large island, coffee bar and butlers pantry!!! New stainless appliances. . all included!!! New roof (12), Kitchen, appliances, fresh paint and floors (21) Hardwoods upstairs. This home is truly turnkey and ready for a new owner!!!Walking distance to elementary school, easy access to major freeways and close to shopping and restaurants. Doing miss this one!
Welcome to Holiday Farms Subdivision!!! This beautifully updated tri-level sits on almost 1 wooded and fenced acre!!! The Huge fenced in yard with mature trees, private patio for entertaining, storage shed, creates a private setting with endless possibilities!!!! Walking in, you are in awe with the stunning open NEW kitchen with large island, coffee bar and butlers pantry!!! New stainless appliances. . all included!!! New roof (12), Kitchen, appliances, fresh paint and floors (21) Hardwoods upstairs. This home is truly turnkey and ready for a new owner!!!Walking distance to elementary school, easy access to major freeways and close to shopping and restaurants. Doing miss this one!
REALCOMP #2210049381
Aug 8, 2021
Listing Removed
—
Aug 2, 2021
Sold
$235,000
$143/sq ft
Jun 28, 2021
Pending
—
Jun 24, 2021
Listed
$220,000
$134/sq ft
Welcome to Holiday Farms Subdivision!!! This beautifully updated tri-level sits on almost 1 wooded and fenced acre!!! The Huge fenced in yard with mature trees, private patio for entertaining, storage shed, creates a private setting with endless possibilities!!!! Walking in, you are in awe with the stunning open NEW kitchen with large island, coffee bar and butlers pantry!!! New stainless appliances. . all included!!! New roof (12), Kitchen, appliances, fresh paint and floors (21) Hardwoods upstairs. This home is truly turnkey and ready for a new owner!!!Walking distance to elementary school, easy access to major freeways and close to shopping and restaurants. Doing miss this one!
Public Records
Jun 8, 2017
Sold
$138,400
$84/sq ft
REALCOMP #216114999
May 5, 2017
Sold
$138,400
$84/sq ft
Feb 24, 2017
Pending
—
Feb 4, 2017
Price Changed
$145,000
$88/sq ft
Feb 4, 2017
Relisted
—
Jan 9, 2017
Pending
—
Dec 28, 2016
Price Changed
$149,900
$91/sq ft
Dec 7, 2016
Listed
$155,000
$95/sq ft
Greater Lansing AoR #21243538
May 5, 2017
Sold
$138,400
$84/sq ft
Feb 24, 2017
Pending
—
Feb 4, 2017
Price Changed
$145,000
$88/sq ft
Feb 4, 2017
Relisted
—
Jan 9, 2017
Pending
—
Dec 28, 2016
Price Changed
$149,900
$91/sq ft
Dec 8, 2016
Listed
$155,000
$95/sq ft
Dec 7, 2016
Listed
$145,000
$88/sq ft
MiRealSource-MiMLS #60055211
Mar 31, 2011
Sold
$50,000
$30/sq ft
Jan 12, 2011
Listed
$49,900
$30/sq ft
REALCOMP #211004598
Mar 31, 2011
Sold
$50,000
$30/sq ft
Jan 12, 2011
Listed
$49,900
$30/sq ft
MiRealSource-MiMLS #60069563
Jan 12, 2011
Listing Removed
—
Dec 14, 2010
Listed
$56,950
$35/sq ft
REALCOMP #210140026
Jan 12, 2011
Listing Removed
—
Dec 14, 2010
Listed
$56,950
$35/sq ft
MiRealSource-MiMLS #60164036
Dec 14, 2010
Listing Removed
—
Oct 26, 2010
Listed
$64,900
$40/sq ft
REALCOMP #210123421
Dec 14, 2010
Listing Removed
—
Oct 26, 2010
Listed
$64,900
$40/sq ft
MiRealSource-MiMLS #60144786
Oct 26, 2010
Listing Removed
—
Sep 17, 2010
Listed
$64,900
$40/sq ft
REALCOMP #210108655
Oct 26, 2010
Listing Removed
—
Sep 17, 2010
Listed
$64,900
$40/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$5,115 (+8.7%)
2024
$4,703 (−3.8%)
2023
$4,888 (+10.6%)
2022
$4,418 (+46.6%)
2021
$3,015 (+0.4%)
2020
$3,003 (−14.5%)
2019
$3,512 (+18.9%)
2018
$2,953 (+87.5%)
2017
$1,575 (−32.0%)
2016
$2,317 (−0.9%)
2015
$2,339 (+3.8%)
2014
$2,254
Tax history for 5401 Farm Rd
Year
Property tax
Land + Additions
Assessment*
2025
$5,115 (+8.7%)
2024
$4,703 (−3.8%)
2023
$4,888 (+10.6%)
2022
$4,418 (+46.6%)
2021
$3,015 (+0.4%)
2020
$3,003 (−14.5%)
2019
$3,512 (+18.9%)
2018
$2,953 (+87.5%)
2017
$1,575 (−32.0%)
2016
$2,317 (−0.9%)
2015
$2,339 (+3.8%)
2014
$2,254
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Beds
3
Baths
1.5
Stories
—
Lot width
—
Lot depth
—
Lot size
0.66 Acres
Year renovated
1988
Sq. Ft.
1,160
Year built
1963
Style
Single Family Residential
County
Oakland County
APN
W -13-21-254-009
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Nov 5, 2026.
Property details
Parking
Parking/Garage Information
Has Garage
Has Attached Garage
# of Garage Spaces: 1
Parking Features: Attached, Paved, Direct Access, Workshop in Garage, Garage Faces Side
Interior
Bathroom Information
# of Full Bathrooms: 1
Heating & Cooling
Has Cooling
Cooling: Central Air
Has Heating
Heating: Forced Air, Natural Gas
Interior Features
Appliances: Dishwasher, Microwave, Refrigerator, Range, Oven, Gas Water Heater
Room Information
# of Rooms Total: 8
Laundry Features: Upper Level
Has Basement
Basement Details: Finished
Exterior
Exterior Features
Patio And Porch Features: Patio, Porch
Building Information
Above Grade Finished Area: 1,160
Below Grade Finished Area: 480
Levels: Three Or More
Construction Materials: Brick, Vinyl Siding
Has Home Warranty
Property Features
Other Structures: Shed(s)
Property Information
Property Type: Residential
Property Sub Type: Single Family Residence
Raw Mls Property Sub Type: Single Family
Lot Information
Frontage Length: 111
Lot Size : 111.00X256.00
Lot Size Acres: 0.58
Financial
Tax Information
Tax Annual Amount: $3,003
Utilities
Utility Information
Water Source: Public
Sewer: Public Sewer
Location
Schools Information
School District: Waterford School District
Location Information
Directions: Pontiac LK RD to Farm RD on Right
Subdivision Name: HOLIDAY FARMS NO 3
Cross Street: N of Pontiac Lake/W of Cr
Public facts
Beds: 3
Baths: 1.5
Sq. Ft.: 1,160
Stories: —
Lot Size: 0.66 acres
Style: Single Family Residential
Year Built: 1963
Year Renovated: 1988
County: Oakland County
APN: W -13-21-254-009
Home facts updated by county records on Nov 5, 2026
Other
Listing Information
List AOR: RealComp
Around this home
Schools
K - 12
Preschool & daycare
Riverside Elementary School
Public PreK-5 • Assigned • 0.2mi
4/10
Pierce Middle School
Public 6-8 • Assigned • 1.4mi
5/10
Waterford Mott High School
Public 9-12 • Assigned • 2.2mi
5/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
2/10 Heat Factor
7 days above 97° expected this year, 15 days in 30 years
2/10 Wind Factor
Minor risk of severe winds over next 30 years
3/10 Air Factor
2 unhealthy days expected this year, 4 days in 30 years
Provided by First Street
Historical weather
Waterford, MI • 48327
Average low and high temperatures (°F)
27
14
33
18
51
30
60
40
67
48
79
60
84
66
79
60
76
54
64
44
48
35
34
22
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 9.6 hours in
June and 2.6 hours in December, placing it below the
U.S. average for solar exposure.
9.6 hrs
2.6 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$273,000 – $330,000
Reach more buyers when you sell with Redfin. Save up to $2,868 in fees.3 minutes to get started.