NOT LISTED FOR SALE

597 Crescent Ln Madera, CA 93636

Estimated Value: $634,000 - $751,000

3 Beds
2.5 Baths
2,406 Sq Ft
$288/Sq Ft Est. Value

Last Sold August 24, 2023

Last sale price $682,000 $283 Per Sq Ft

Est. 2% increase in value since last sale

Current estimated payment $4,512/month

44 Days on Market

Highlights

  • Fitness Center
  • In Ground Pool
  • Community Playground
  • Ranchos Middle School Rated A-
  • Clubhouse
  • 1-Story Property

About This Home

As of August 2023

Experience the pinnacle of luxury living with this former model home at McCaffrey's Ivy Collection in Riverstone. Immerse yourself in this exquisite home, thoughtfully designed and filled with exceptional upgrades that will leave you breathless. From the moment you arrive, you'll be greeted by an impressive front entryway, complete w/ a custom water feature, low-maintenance Synlawn turf, meticulously landscaped surroundings, and a custom driveway that exudes sophistication. Inside, you'll be delighted as the great room seamlessly flows into the gourmet kitchen. Upgraded hardwood floors set the stage for a culinary masterpiece, complemented by custom kitchen cabinets, stunning quartz countertops, abundant storage, and an oversized pantry that caters to your every need. Indulge in the luxurious owner's suite, where a spa-inspired bath awaits to create an oasis of relaxation. Every detail has been carefully curated, including lovely window coverings, an eye-catching brick accent wall and a comprehensive security system for your peace of mind. Outside, the rear yard beckons with its gorgeous landscape, inviting you to create your own personalized entertaining area amidst the natural beauty. A charming water feature and a profusion of potted fruit trees, add charm and tranquility to the outdoor haven. This remarkable home is a testament to perfection, offering a turnkey opportunity and savor the unparalleled comfort and luxury within the prestigious Riverstone Community.

Last Agent to Sell the Property

Lance Heredia-McCampbell

Real Broker License #02090029 Listed on: 06/28/2023

Real Broker

Co-Listed By

Joshua Ledezma

Real Broker License #02132296

Last Buyer's Agent

Catherine Olsen

Realty Concepts, Ltd. - Fresno License #00707040

Realty Concepts, Ltd. - Fresno

Home Details

Home Type

  • Single Family

Year Built

  • Built in 2018

Lot Details

  • 7,700

HOA Fees

  • $125 Monthly HOA Fees

Home Design

  • Concrete Foundation
  • Tile Roof
  • Wood Siding
  • Stucco

Interior Spaces

  • 2,406 Sq Ft Home
  • 1-Story Property
  • Laundry in unit

Bedrooms and Bathrooms

  • 3 Bedrooms
  • 2.5 Bathrooms

Additional Features

  • In Ground Pool
  • 7,700 Sq Ft Lot
  • Central Heating and Cooling System

Community Details

Overview

  • Greenbelt

Amenities

  • Clubhouse

Recreation

  • Community Playground
  • Fitness Center
  • Community Pool
  • Community Spa

Home Details

Home Type

Single Family

Year Built

Built in 2018

Lot Details

7,700 Sq Ft Lot

HOA Fees

$125 per month

Listing Details

  • Type: Residential
  • Property Sub Type: Single Family Residence
  • Price Per Square Foot: 283.46
  • Year Built Exception: 0
  • Number Of Stories: Single Story
  • Special Features: None
  • Stories: 1
  • Year Built: 2018

Interior Features

  • Bathrooms: 2.50
  • Bedrooms: 3
  • Laundry: Inside
  • Square Footage: 2406.00

Exterior Features

  • Roofing: Tile
  • Pool Type: In Ground
  • Exterior: Stucco, Wood
  • Foundation: Concrete
  • Pool: Yes

Utilities

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

Condo/Co-op/Association

  • Association: Fresno MLS
  • Frequency: Monthly
  • HOA Fees: 125.00

Association/Amenities

  • Association Park Amenities: Pool, Spa, Club House, Exercise Room, Green Area, Playground, Other/None

Lot Info

  • Acres: 0.1768
  • Lot Measurement: Square Feet
  • Lot Size Sq Ft: 7700.00
  • Price Per Acre: 3857466.06

Building Info

  • Year Built: 2018

MLS Schools

  • School District 2: Golden Valley
  • School Type: High School
  • School Name: Liberty
  • School Type: Junior High School
  • School Name: Ranchos
  • School Type: Grade School
  • School Name: Riverstone

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 28, 2023
Closed on
Aug 17, 2023
Sold by
Tavares Kevin
Bought by
Breena Siliznoff Revocable Living Trust and Siliznoff
Seller's Agent
Lance Heredia-McCampbell
Real Broker
Buyer's Agent
Catherine Olsen
Realty Concepts, Ltd. - Fresno
List Price
$684,999
Sold Price
$682,000
Premium/Discount to List
-$2,999
-0.44%
Views
96
Current Estimated Value
$693,325

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$11,325
Avg. Annual Appreciation
0.64%

Purchase Details

Listed on
Jan 30, 2020
Closed on
Jun 4, 2020
Sold by
Chauhan Jasmine P
Bought by
Tavares Kevin
Seller's Agent
Elaine Colett
Realty Concepts, Ltd. - Fresno
Buyer's Agent
Elaine Colett
Realty Concepts, Ltd. - Fresno
List Price
$534,950
Sold Price
$534,950

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
7.86%
Original Mortgage
$508,200
Interest Rate
3.3%
Mortgage Type
New Conventional

Purchase Details

Listed on
Jan 30, 2020
Closed on
Jun 3, 2020
Sold by
Lodge Root Creek No 1 Lp
Bought by
Tavares Kevin
Seller's Agent
Elaine Colett
Realty Concepts, Ltd. - Fresno
Buyer's Agent
Elaine Colett
Realty Concepts, Ltd. - Fresno
List Price
$534,950
Sold Price
$534,950

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$508,200
Interest Rate
3.3%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jul 13, 2016
Sold by
Riverstone Development Llc
Bought by
Lodge/Root Creek #1 Lp

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$4,569,000
Interest Rate
3.66%
Mortgage Type
Commercial
Source: Public Records

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 Values in the Area

Source: Public Records

Average Home Value in this Area

Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Breena Siliznoff Revocable Living Trust $682,000 Chicago Title Company
Tavares Kevin -- Old Republic Title Company
Tavares Kevin $535,000 Old Republic Title Company
Lodge/Root Creek #1 Lp $8,988,000 Old Republic Title Company
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Tavares Kevin $508,200
Previous Owner Lodge/Root Creek #1 Lp $4,569,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
08/24/2023 08/24/23 Sold $682,000 -0.4% $283 / Sq Ft
08/11/2023 08/11/23 Pending -- -- --
07/26/2023 07/26/23 For Sale $684,999 0.0% $285 / Sq Ft
07/10/2023 07/10/23 Pending -- -- --
06/28/2023 06/28/23 For Sale $684,999 +28.0% $285 / Sq Ft
06/08/2020 06/08/20 Sold $534,950 0.0% $223 / Sq Ft View Prior Sale
04/24/2020 04/24/20 Pending -- -- --
01/30/2020 01/30/20 For Sale $534,950 -- $223 / Sq Ft
Source: Fresno MLS

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 $9,347 $695,640 $91,800 $603,840
2023 $9,347 $562,326 $94,605 $467,721
2022 $7,912 $551,300 $92,750 $458,550
2021 $7,709 $540,491 $90,932 $449,559
2020 $6,722 $425,957 $83,666 $342,291
2019 $6,527 $417,606 $82,026 $335,580
2018 $5,093 $295,557 $80,418 $215,139
2017 $5,613 $289,763 $78,842 $210,921
2016 $384 $8,454 $8,454 $0
Source: Public Records

Agents Affiliated with this Home

  • Lance Heredia-McCampbell

    Seller's Agent in 2023

    Lance Heredia-McCampbell

    Real Broker

    (559) 260-6700

    1 in this area

    37 Total Sales

    Lance Heredia-McCampbell
    Section Image

  • J

    Seller Co-Listing Agent in 2023

    Joshua Ledezma

    Real Broker

    (559) 696-6136

    2 in this area

    29 Total Sales

    Joshua Ledezma
    Section Image
  • Catherine Olsen

    Buyer's Agent in 2023

    Catherine Olsen

    Realty Concepts, Ltd. - Fresno

    (559) 260-6004

    1 in this area

    15 Total Sales

    Catherine Olsen
    Section Image
  • Elaine Colett

    Seller's Agent in 2020

    Elaine Colett

    Realty Concepts, Ltd. - Fresno

    (559) 307-0532

    3 in this area

    111 Total Sales

    Elaine Colett
    Section Image
See All Agents

Map

Source: Fresno MLS

MLS Number: 596525

Fresno MLS

APN: 080-055-001

California Madera County Madera 93636

597 Crescent Ln, Madera, CA

Not Listed for Sale

Detached

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

Fresno MLS IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.

Nearby Homes
Your Personal Tour Guide

Ask me questions while you tour the home.