NOT LISTED FOR SALE

822 Charles Rd Hughson, CA 95326

Estimated Value: $1,766,000 - $1,877,272

4 Beds
5 Baths
3,600 Sq Ft
$505/Sq Ft Est. Value

Last Sold August 02, 2023

Last sale price $1,800,000 $500 Per Sq Ft

Est. 1% increase in value since last sale

Current estimated payment $11,303/month

31 Days on Market

Highlights

  • River Access
  • Horses Allowed On Property
  • RV Garage
  • Barn
  • Second Garage
  • River View

About This Home

As of August 2023

MASSIVE PRICE ADJUSTMENT! Come fall in love with this Rare Riverfront Hughson Ranch Estate! For the first time in nearly 40 years, the stunning Keckler Ranch is for sale. Situated on 11 beautifully manicured acres on the Tuolumne River, this rare estate delivers the quintessential river lifestyle. As you enter the tree-line drive, the day's stress will begin to melt away as you pass through the private gates. A serene pasture, 4-stalled cedar barn and an elegant 3,600SF 1-story home beckons family and friends to sit on the wrap-around covered porch to enjoy the evening breezes. Inside, classic brick floors create a seamless transition from room to room while the timeless kitchen acts as the central gathering place of gracious living. A 1400SF deck cantilevers over the river bluff and spread out on the acreage below, is a second barn, green pasture, and a 1-acre pond that will provide hours of fun and enjoyment. Idyllic, Rare, Exclusive are all words used to describe this incredible property. Don't miss this once in a lifetime opportunity! **Photos of property were taken at different times of year. Once in the 08/22 and once in 02/23**

Last Agent to Sell the Property

Meredith Brandsma

PMZ Real Estate License #01721918 Listed on: 05/01/2023

PMZ Real Estate

Last Buyer's Agent

Debbi Agresti

PMZ Real Estate License #01358241

PMZ Real Estate

Home Details

Home Type

  • Single Family

Year Built

  • Built in 1955

Lot Details

  • 11 Acre Lot
  • River Front
  • Dog Run
  • Cross Fenced
  • Wood Fence
  • Aluminum or Metal Fence
  • Fenced For Horses
  • Landscaped
  • Private Lot
  • Sprinklers on Timer

Property Views

  • River
  • Ridge
  • Pasture
  • Valley

Home Design

  • Brick Exterior Construction
  • Slab Foundation
  • Composition Roof
  • Wood Siding

Interior Spaces

  • 3,600 Sq Ft Home
  • 1-Story Property
  • Wet Bar
  • 1 Fireplace
  • Double Pane Windows
  • Great Room
  • Living Room
  • Home Office
  • Bonus Room
  • Sun or Florida Room
  • Carpet

Bedrooms and Bathrooms

  • 4 Bedrooms
  • In-Law or Guest Suite
  • Bathtub with Shower

Laundry

  • Laundry Room
  • Laundry on main level
  • Sink Near Laundry
  • Laundry Cabinets

Home Security

  • Security Gate
  • Fire and Smoke Detector

Parking

  • Garage
  • 3 Carport Spaces
  • Second Garage
  • Guest Parking
  • RV Garage

Outdoor Features

  • River Access
  • Deck
  • Outdoor Kitchen
  • Fire Pit
  • Outdoor Storage
  • Outbuilding
  • Built-In Barbecue
  • Wrap Around Porch

Farming

  • Barn
  • Electricity in Barn
  • Pasture

Horse Facilities and Amenities

  • Horses Allowed On Property
  • Tack Room
  • Water to Barn
  • Trailer Storage

Utilities

  • Central Heating and Cooling System
  • Ductless Heating Or Cooling System
  • Gas Tank Leased
  • Well
  • Septic System

Community Details

  • No Home Owners Association
  • Pond Year Round

Listing and Financial Details

  • Assessor Parcel Number 009-029-003-000

Home Details

Home Type

Single Family

Year Built

Built in 1955

Lot Details

0

Listing Details

  • Property Type: Residential
  • Subtype Description: Custom,Ranchette/Country,Detached
  • Property Subtype 1: Single Family Residence
  • Remodeled Updated: No
  • Stories: 1
  • Year Built: 1955
  • Architectural Style: Ranch
  • Levels: One
  • ResoPropertyType: Residential
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Fireplace Features: Living Room
  • Fireplaces: 1
  • Flooring: Carpet, Other
  • Master Bathroom Features: Shower Stall(s),Tile,Walk-In Closet
  • Master Bedroom Features: Ground Floor,Outside Access
  • Total Bathrooms: 5
  • Bathroom Features: Tub w/Shower Over
  • Dining Room Features: Dining/Family Combo,Space in Kitchen
  • Kitchen Features: Breakfast Area,Pantry Closet,Island,Island w/Sink,Tile Counter
  • Living Room Features: Great Room
  • Room Type: Bonus Room, Den, Office, Possible Guest, Sun Room, Kitchen, Laundry, Living Room
  • Main Level: Bedroom(s),Living Room,Family Room,Master Bedroom,Full Bath(s),Kitchen
  • Price Per Square Foot: 500.00
  • Square Footage: 3600.00
  • Window Features: Dual Pane Full
  • ResoLivingAreaSource: Appraiser

Exterior Features

  • Other Structures: Barn(s), Second Garage, Storage, Outbuilding, Other
  • Construction Materials: Brick, Wood, Wood Siding
  • Exterior Features: BBQ Built-In, Kitchen, Dog Run, Wet Bar, Fire Pit
  • Fencing: Metal, Cross Fenced, Fenced, Wood
  • Foundation: Slab
  • Frontage Type: River, Waterfront
  • Home Warranty: No
  • Horse Property: Yes
  • Listing Price: 2300000.00
  • Lot Features: Auto Sprinkler F&R, Pond Year Round, Private, River Access, Landscape Back, Landscape Front
  • Patio And Porch Features: Uncovered Deck, Wrap Around Porch
  • Pool: No
  • Roof: Composition
  • Spa: No
  • Topography: Rolling,Hillside
  • View Description: Pasture, Ridge, River, Valley
  • Land Use: Agricultural,Ranch,Residential,Pasture

Garage/Parking

  • Carport Spaces: 3.00
  • Parking Features: Boat Storage, Covered, RV Garage Detached, RV Storage, Guest Parking Available

Utilities

  • Security: Smoke Detector, Security Gate
  • Sewer: Septic System
  • Utilities: Propane Tank Leased, Electric
  • Cooling: Central, Ductless
  • Electric: Other
  • Heating: Central, Ductless
  • Laundry Features: Cabinets, Sink, Ground Floor, Inside Room
  • Water Source: Well

Condo/Co-op/Association

  • Association: No
  • Senior Community: No

Schools

  • Senior High School District: Hughson Union

Lot Info

  • Horse Amenities: 7+ Stalls, Pasture, Barn w/Electricity, Barn w/Water, Tack Room, Trailer Storage, Fenced
  • Zoning Description: R-1
  • Irrigation: Agricultural Well, Irrigation Connected, Riparian Rights
  • Lot Size Acres: 11.0000
  • Lot Size Sq Ft: 479160.00
  • ResoLotSizeUnits: Acres

Tax Info

  • Assessor Parcel Number: 009-029-003-000
  • Bonds/Assessments/Taxes Description: Local Assessments
  • Bonds/Assessments/Taxes: Yes

MLS Schools

  • School District (County): Stanislaus

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 1, 2023
Closed on
Jul 24, 2023
Sold by
James Michael and James Susanne Keckler
Bought by
Yamamoto Keith and Yamamoto Alexandria
Seller's Agent
Meredith Brandsma
PMZ Real Estate
Buyer's Agent
Debbi Agresti
PMZ Real Estate
List Price
$2,300,000
Sold Price
$1,800,000
Premium/Discount to List
-$500,000
-21.74%
Views
160
Current Estimated Value
$1,819,757

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$19,757
Avg. Annual Appreciation
0.46%
Original Mortgage
$1,200,000
Outstanding Balance
$1,170,731
Interest Rate
6.67%
Mortgage Type
New Conventional
Estimated Equity
$649,026

Purchase Details

Closed on
May 23, 2008
Sold by
Keckler James Michael
Bought by
Keckler James Michael and Keckler Susanne
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
Yamamoto Keith $1,800,000 Cypress Title
Keckler James Michael -- None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Yamamoto Keith $1,200,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
08/02/2023 08/02/23 Sold $1,800,000 0.0% $500 / Sq Ft
07/15/2023 07/15/23 Off Market $1,800,000 -- --
06/01/2023 06/01/23 Pending -- -- --
05/01/2023 05/01/23 For Sale $2,300,000 -- $639 / Sq Ft
Source: MetroList

Tax History Compared to Growth

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 $20,878 $1,836,000 $975,630 $860,370
2024 $19,585 $1,800,000 $956,500 $843,500
2023 $6,018 $557,325 $262,148 $295,177
2022 $5,924 $546,398 $257,008 $289,390
2021 $5,813 $535,685 $251,969 $283,716
2020 $5,795 $536,463 $249,386 $287,077
2019 $5,743 $526,568 $244,497 $282,071
2018 $5,609 $519,136 $239,703 $279,433
2017 $5,668 $509,974 $235,003 $274,971
2016 $5,362 $501,809 $230,396 $271,413
2015 $5,287 $495,443 $226,936 $268,507
2014 $5,252 $488,843 $222,491 $266,352
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: MetroList

MLS Number: 223037272

MetroList

APN: 009-29-03