NOT LISTED FOR SALE

5200 Underhill Rd Turlock, CA 95380

Estimated Value: $754,000 - $1,170,000

3 Beds
2 Baths
2,038 Sq Ft
$492/Sq Ft Est. Value

Last Sold January 25, 2019

Last sale price $725,000 $356 Per Sq Ft

Est. 38% increase in value since last sale

Current estimated payment $5,996/month

47 Days on Market

Highlights

  • Horses Allowed On Property
  • Custom Home
  • 16.9 Acre Lot
  • Spa
  • Gated Community
  • No HOA

About This Home

As of January 2019

Nearly 17 acres with Custom Home and Horse Setup. Private location at the End Of Street. 3 bedroom 2 bath with a unique kitchen setup that has views of nearly the whole property. Real wood Floors, Vaulted ceilings, quality construction. Large 512 sqft finished basement(not included in the home square footage). Detached 4-garage W/ Full Bath., Large Tack Rm. 24x40 Shop, Horse Barn. Pastures & Paddocks W/Shelters, 70x150 Riding Area, over 2 Mi. Of Industrial Fencing. To must to list. A must see!

Last Agent to Sell the Property

Elvis Dias

Century 21 Select Real Estate License #01261050 Listed on: 11/30/2018

Century 21 Select Real Estate

Last Buyer's Agent

Jaime Silva Esteves

HomeSmart PV & Associates License #01856542

HomeSmart PV & Associates

Home Details

Home Type

  • Single Family

Year Built

  • Built in 1992

Lot Details

  • 16.9 Acre Lot
  • North Facing Home
  • Zoning described as AG

Parking

  • 4 Car Garage

Home Design

  • Custom Home
  • Raised Foundation
  • Tile Roof

Interior Spaces

  • 2,038 Sq Ft Home
  • 2-Story Property
  • Double Pane Windows
  • Family Room with Fireplace
  • Partial Basement
  • 220 Volts In Laundry

Bedrooms and Bathrooms

  • 3 Bedrooms
  • 2 Full Bathrooms
  • Separate Shower

Outdoor Features

  • Spa
  • Balcony
  • Covered Patio or Porch
  • Separate Outdoor Workshop

Utilities

  • Central Heating and Cooling System
  • Well
  • Septic System

Additional Features

  • Upper Level
  • Horses Allowed On Property

Community Details

  • No Home Owners Association
  • Gated Community

Listing and Financial Details

  • Assessor Parcel Number 024-043-011-000

Home Details

Home Type

Single Family

Year Built

Built in 1992

Lot Details

0

Parking

4

Listing Details

  • Property Type: Residential
  • Subtype Description: Custom
  • Property Subtype 1: Single Family Residence
  • Remodeled Updated: No
  • Year Built: 1992
  • Stories: 2
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Fireplace Features: Family Room
  • Fireplaces: 1
  • Flooring: Carpet,Wood,Linoleum/Vinyl
  • Bathroom Features: Shower Stall(s)
  • Bathrooms: 2.00
  • Basement: Partial
  • Dining Room Features: Breakfast Nook,Formal Area
  • Room Type: Baths Other
  • Main Level: Bedroom(s),Full Bath(s)
  • Price Per Square Foot: 355.74
  • Square Footage: 2038
  • Window Features: Dual Pane Full

Exterior Features

  • Other Structures: Workshop
  • Construction Materials: Frame,Stucco
  • Property Faces: North
  • Disclosures/Documents: CC&Rs
  • Exterior Features: Balcony
  • Foundation: Raised
  • Horse Property: Yes
  • Listing Price: 759950.00
  • Lot Features: Dead End,See Remarks
  • Patio And Porch Features: Covered Patio
  • Pool: No
  • Roof: Tile
  • Spa Features: Spa/Hot Tub Personal
  • Spa: Yes
  • Land Use: Ranch

Garage/Parking

  • Garage Spaces: 4
  • Parking Features: Detached,RV Possible

Utilities

  • Security: Unguarded Gate
  • Sewer: Septic Connected
  • Utilities: All Electric
  • Cooling: Central
  • Electric: 220 Volts in Laundry
  • Heating: Central
  • Laundry Features: Inside Room,Sink
  • Water Source: Well

Condo/Co-op/Association

  • Association: No
  • Location of Unit: Upper Level

Schools

  • Senior High School District: Denair Unified

Lot Info

  • Horse Amenities: 7+ Stalls,Barn(s),Fenced,Pasture,Irrigated Pasture,Round Pen,Wash Rack
  • Zoning Description: AG
  • Irrigation: Irrigation Connected
  • Lot Size Acres: 16.9000
  • Lot Size Sq Ft: 736164

Tax Info

  • Assessor Parcel Number: 024-043-011-000
  • Bonds/Assessments/Taxes: Unknown

MLS Schools

  • School District (County): Stanislaus

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Jun 18, 2025
Sold by
George John J and George John Gilbert
Bought by
John Gilbert George Revocable Trust and George
Current Estimated Value
$1,003,089

Purchase Details

Closed on
Sep 3, 2020
Sold by
Zamaroni Tina and Zamaroni Ben
Bought by
Soiseth Taylor S and Soiseth Jade M

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$400,000
Interest Rate
2.9%
Mortgage Type
Commercial

Purchase Details

Listed on
Nov 30, 2018
Closed on
Jan 24, 2019
Sold by
Stern Alison
Bought by
Zamaroni Ben and Zamaroni Tina
Seller's Agent
Elvis Dias
Century 21 Select Real Estate
Buyer's Agent
Jaime Silva Esteves
HomeSmart PV & Associates
List Price
$759,950
Sold Price
$725,000
Premium/Discount to List
-$34,950
-4.6%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
4.70%

Purchase Details

Closed on
Sep 26, 2012
Sold by
Stern Alison
Bought by
Stern Alison

Purchase Details

Closed on
Aug 7, 2002
Sold by
The Eileen C Henson Trust
Bought by
Stern Alison

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$150,000
Interest Rate
4.4%

Purchase Details

Closed on
Jul 25, 2000
Sold by
Henson Eileen C
Bought by
Henson Eileen C
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

Purchase History

Date Buyer Sale Price Title Company
John Gilbert George Revocable Trust -- None Listed On Document
Soiseth Taylor S $800,000 North American Title Co Inc
Zamaroni Ben $725,000 Cypress Title Co
Stern Alison -- None Available
Stern Alison $575,000 Fidelity National Title Co
Henson Eileen C -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Soiseth Taylor S $400,000
Previous Owner Stern Alison $150,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
01/25/2019 01/25/19 Sold $725,000 -4.6% $356 / Sq Ft
01/16/2019 01/16/19 Pending -- -- --
11/30/2018 11/30/18 For Sale $759,950 -- $373 / Sq Ft
Source: MetroList

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,438 $813,009 $515,390 $297,619
2024 $8,767 $761,650 $511,208 $250,442
2023 $8,546 $749,418 $503,886 $245,532
2022 $8,367 $735,077 $494,359 $240,718
2021 $8,304 $717,581 $481,582 $235,999
2020 $8,283 $707,890 $474,310 $233,580
2019 $7,365 $643,990 $280,458 $363,532
2018 $7,261 $617,294 $260,890 $356,404
2017 $6,901 $598,699 $249,283 $349,416
2016 $6,846 $586,228 $243,663 $342,565
2015 $6,203 $548,548 $265,500 $283,048
2014 $5,178 $449,156 $197,000 $252,156
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: MetroList

MLS Number: 18079554

MetroList

APN: 024-43-11

Your Personal Tour Guide

Ask me questions while you tour the home.