RENTED JUL 20, 2026

Estimated Value: $735,728

3 Beds
3.5 Baths
2,886 Sq Ft
$255/Sq Ft Est. Value

Highlights

  • Clubhouse
  • Contemporary Architecture
  • Community Pool
  • Ranchos Middle School Rated A-
  • Great Room
  • Covered Patio or Porch

About This Home

As of July 2026

Welcome to 822 Overstone Ave, a stunning single-story home in the award-winning Tesoro Viejo master-planned community. Designed for comfort and modern living, this beautiful Makena model offers 4 spacious bedrooms, 3.5 bathrooms, soaring 10-foot ceilings, owned and fully paid-for solar, and high-speed internet included in the monthly rent. Large windows throughout fill the home with natural light, creating a bright and inviting atmosphere.The heart of the home is built for entertaining, featuring generous living spaces, a built-in entertainment center, and a seamless flow between the kitchen, dining, and family areas. The primary suite offers a luxurious retreat with a beautifully tiled shower and a thoughtfully designed layout. The home is equipped with both gas and electric utilities, providing flexibility, efficiency, and long-term savings.Outside, you'll enjoy an enclosed front courtyard, professionally landscaped front and back yards, a cement patio deck, gas stub for outdoor grilling, and a spacious 3-car garage. Every detail has been carefully designed to create a welcoming and low-maintenance lifestyle.Living in Tesoro Viejo means enjoying exceptional community amenities including the Ranch House resort-style pool, clubhouse, fitness center, scenic parks, amphitheater, walking and biking trails, community events, and Town Center gathering spaces. Residents are just a short distance from AXIS Coffee Bar & Eatery, the community's popular caf and dining destination, along with community services and gathering areas. The neighborhood also features Hillside Elementary School (TK-8), allowing children to walk to school without the daily carpool routine.Conveniently located along Highway 41, this home provides easy access to Fresno while serving as the gateway to Yosemite National Park and the Sierra Nevada mountains. With owned solar, high-speed internet included in the rent, outstanding community amenities, and a vibrant neighborhood atmosphere, this home offers an exceptional lifestyle opportunity in one of the Central Valley's most desirable master-planned communities.

Last Agent to Rent the Property

Shiela Avakian

John Carey, Broker License #01341351 Listed on: 06/18/2026

Last Renter's Agent

Shiela Avakian

John Carey, Broker License #01341351 Listed on: 06/18/2026

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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 Details

Home Type

  • Single Family

Year Built

  • Built in 2021

Lot Details

  • 7,405 Sq Ft Lot
  • Front and Back Yard Sprinklers
  • Property is zoned r1

Home Design

  • Contemporary Architecture
  • Concrete Foundation
  • Composition Roof
  • Stucco

Interior Spaces

  • 2,886 Sq Ft Home
  • 1-Story Property
  • Great Room

Bedrooms and Bathrooms

  • 3 Bedrooms
  • 3.5 Bathrooms
  • Bathtub with Shower
  • Separate Shower

Additional Features

  • Covered Patio or Porch
  • Central Heating and Cooling System

Community Details

Amenities

  • Clubhouse

Recreation

  • Community Pool
  • Community Spa

Home Details

Home Type

Single Family

Year Built

Built in 2021

Lot Details

7,405 Sq Ft Lot

Rental Info

  • Lease Type: Net
  • Sub Lease: False

Listing Details

  • Type: Residential
  • Property Sub Type: Single Family Residence
  • Style: Contemporary
  • Year Built Exception: 0
  • Number Of Stories: Single Story
  • Special Features: None
  • Stories: 1
  • Year Built: 2021

Interior Features

  • Bathrooms: 3.50
  • Bedrooms: 3
  • Bathroom Features: Tub/Shower, Shower
  • Kitchen: Built In Range/Oven, Gas Appliances
  • Laundry: None
  • Extra Rooms: Great Room
  • Basement: None
  • Square Footage: 2886.00

Exterior Features

  • Yard: Sprinklers Front, Sprinklers Back
  • Roofing: Composition
  • Exterior: Stucco
  • Foundation: Concrete
  • Patio: Covered
  • Pool: No

Utilities

  • Heating And Cooling: Central Heat & Cool, Central Heating
  • Gas And Electric: Public Utilities
  • Sewer/Water: Public Water, Public Sewer

Condo/Co-op/Association

  • Association: Fresno MLS

Association/Amenities

  • Association Park Amenities: Pool, Spa, Club House

Lot Info

  • Acres: 0.1700
  • Lot Measurement: Square Feet
  • Lot Size Sq Ft: 7405.00

Building Info

  • Year Built: 2021

MLS Schools

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

Ownership History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Name Owned For Owner Type

Purchase Details

Closed on
Feb 1, 2021
Sold by
Treasure Hills Llc
Bought by
Current Estimated Value
$735,728

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$450,916
Outstanding Balance
$392,633
Interest Rate
2.65%
Mortgage Type
New Conventional
Estimated Equity
$343,095

Purchase Details

Closed on
Feb 12, 2020
Sold by
Hillside Rm Llc
Bought by
Treasure Hills Llc
Source: Public Records

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Agents Specializing in Madera, CA

See All Agents

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Buyer Sale Price Title Company
$564,000 Old Republic Title Company
Treasure Hills Llc $1,540,000 Old Republic Title Company
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Borrower Loan Amount
Open $450,916
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft
07/20/2026 07/20/26 Rented $3,400 0.0% --
07/20/2026 07/20/26 Under Contract -- -- --
06/18/2026 06/18/26 For Rent $3,400 -- --
Source: Fresno MLS

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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
2026 $8,484 $622,305 $99,366 $522,939
2025 $8,484 $610,104 $97,418 $512,686
2023 $8,264 $586,415 $93,636 $492,779
2022 $8,031 $563,645 $90,000 $473,645
2021 $1,841 $14,505 $14,505 $0
2020 $1,049 $14,357 $14,357 $0
2019 $1,036 $14,076 $14,076 $0
2018 $920 $13,800 $13,800 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: Fresno MLS

MLS Number: 650386

Fresno MLS

APN: 081-220-018

Your Personal Tour Guide

Ask me questions while you tour the home.