$550,000
PENDING PRE-FORECLOSURE The borrower is in default on their loan obligation and/or the bank or lender has initiated foreclosure proceedings. This property is occupied, do not disturb the occupants. Trespassing is a criminal offense.

40687 Millstream Ln Madera, CA 93636

Estimated payment $3,363/month

Total Views 3,016
3 Beds
3 Baths
3,572 Sq Ft
$154 Price per Sq Ft

Highlights

  • 19.1 Acre Lot
  • Jetted Tub in Primary Bathroom
  • Corner Lot
  • 2-Story Property
  • 3 Fireplaces
  • Great Room

About This Home

Spacious Custom Ranch Home on 19 Acres - Priced Below Market Value!Positioned on a 19 private acre corner lot, this custom-built 3-bedroom, 3-bath ranch-style home offers over 3,500 sq ft of living space with room to grow, create, or expand. Redwood tongue-and-groove paneling and a dramatic floor-to-ceiling stone fireplace bring warmth and character to the large great room, while separated bedroom wings make multi-generational living or flexible use effortless.The lower-level family room with new LVP flooring and a wet bar opens up even more options for entertaining or relaxing. Outside, mature landscaping provides a shaded oasis, while the expansive property offers potential for livestock, horses, or creating your own ranch setup.Additional features include:Owned solar systemWhole-house generatorLarge detached 3-door garage with workshop spaceQuiet, private setting with plenty of space to stretch outWith solid custom construction and unique character throughout, this property is ready for your personal touch and vision. Perfect for those looking for space, privacy, and opportunity in a ranch-style setting.

Listing Agent

Justin Barigian

Realty Concepts - Oakhurst License #02208199 Listed on: 07/18/2025

Realty Concepts - Oakhurst

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,220

Year Built

  • Built in 1980

Lot Details

  • 19.1 Acre Lot
  • Cross Fenced
  • Corner Lot
  • Front and Back Yard Sprinklers
  • Manual Sprinklers System

Home Design

  • 2-Story Property
  • Metal Roof
  • Wood Siding

Interior Spaces

  • 3,572 Sq Ft Home
  • 3 Fireplaces
  • Free Standing Fireplace
  • Fireplace Features Masonry
  • Great Room
  • Family Room
  • Formal Dining Room
  • Home Office
  • Unfinished Basement

Flooring

  • Carpet
  • Tile
  • Vinyl

Bedrooms and Bathrooms

  • 3 Bedrooms
  • 3 Bathrooms
  • Jetted Tub in Primary Bathroom
  • Bathtub with Shower
  • Separate Shower

Laundry

  • Laundry on lower level
  • Electric Dryer Hookup

Utilities

  • Central Heating and Cooling System
  • Power Generator
  • Propane
  • Well
  • Septic Tank

Additional Features

  • Covered Patio or Porch
  • Pasture

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,220

Year Built

Built in 1980

Lot Details

0

Listing Details

  • Type: Residential
  • Property Sub Type: Single Family Residence
  • Style: Ranch
  • Price Per Square Foot: 153.98
  • Year Built Exception: 0
  • Number Of Stories: Two
  • Special Features: None
  • Stories: 2
  • Year Built: 1980

Interior Features

  • Fireplace Type: Masonry, Free Standing
  • Number Of Fireplaces: 3
  • Flooring: Carpet, Tile, Vinyl
  • Bathrooms: 3.00
  • Bedrooms: 3
  • Bathroom Features: Tub/Shower, Shower, Jetted Tub
  • Dining Room Features: Formal
  • Kitchen: Electric Appliances
  • Laundry: Inside, Utility Room, On Lower Level, Electric Hook Up
  • Extra Rooms: Great Room, Office, Family Room
  • Basement: Unfinished
  • Square Footage: 3572.00

Exterior Features

  • Yard: Sprinklers Front, Sprinklers Back, Sprinklers Manual
  • Roofing: Metal
  • Exterior: Wood
  • Foundation: Both
  • Patio: Covered, Wood Deck
  • Pool: No

Garage/Parking

  • Parking Features: Potential RV Parking, Work/Shop Area

Utilities

  • Heating And Cooling: Central Heat & Cool
  • Gas And Electric: Propane, All Electric, Generator
  • Sewer/Water: Septic Tank, Private Well

Condo/Co-op/Association

  • Association: Fresno MLS

Association/Amenities

  • Site Amenities: Corner, Cross Fenced, Pasture

Lot Info

  • Acres: 19.1000
  • Lot Measurement: Acres
  • Lot Size Sq Ft: 831996.00
  • Price Per Acre: 28795.81

Building Info

  • Year Built: 1980

MLS Schools

  • School District 2: Chawanakee
  • School Type: High School
  • School Name: Minarets
  • School Type: Junior High School
  • School Name: Spring Valley
  • School Type: Grade School
  • School Name: Spring Valley

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

Home Values in the Area

Source: Public Records

Average Home Value in this Area





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
2025 $5,220 $497,606 $106,623 $390,983
2023 $5,220 $478,285 $102,484 $375,801
2022 $5,055 $468,908 $100,475 $368,433
2021 $4,904 $459,714 $98,505 $361,209
2020 $4,753 $455,001 $97,495 $357,506
2019 $4,714 $446,081 $95,584 $350,497
2018 $4,529 $437,335 $93,710 $343,625
2017 $4,487 $428,761 $91,873 $336,888
2016 $4,387 $420,355 $90,072 $330,283
2015 $4,349 $414,042 $88,720 $325,322
2014 $3,956 $385,700 $82,650 $303,050
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
10/03/2025 10/03/25 Sold $575,000 +4.5% $161 / Sq Ft View Prior Sale
08/25/2025 08/25/25 Pending -- -- --
08/22/2025 08/22/25 For Sale $550,000 0.0% $154 / Sq Ft
08/05/2025 08/05/25 Pending -- -- --
07/18/2025 07/18/25 For Sale $550,000 -- $154 / Sq Ft
Source: Fresno MLS

Purchase History

Date Type Sale Price Title Company
Grant Deed $350,000 Fidelity
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Previous Owner $329,900 Seller Take Back
Source: Public Records

Source: Fresno MLS

MLS Number: 633942

Fresno MLS

APN: 050-280-020