$1,750,000
SOLD AUG 9, 2024

1651 N Berkeley Ave Turlock, CA 95382

3 Beds
2.5 Baths
3,664 Sq Ft
1.09 Acres

Recently Sold

$478 Per Sq Ft

8% Below List Price

40 Days on Market

Highlights

  • In Ground Pool
  • Custom Home
  • Deck
  • RV Access or Parking
  • Built-In Refrigerator
  • Wood Flooring

About This Home

As of August 2024

The epitome of casual elegance and uniquely impressive custom craftmanship defines this luxury estate. Approximately 3,700 sf, 3 bedroom/2.5 bath home on an artistically landscaped 1.1-acre park-like backyard with pool, pergula, and 6-car garage. Located in established East Central Turlock and features 3 majestic oak trees that are nearly a century old. Over the past 5 years, home and grounds have been extensively remodeled and is sure to impress. Each room is treated with exceptional attention to detail with designer finishes, custom cabinetry, and large Pella windows that provide ample natural lighting throughout. Living areas are accented with oak hardwood flooring. Gourmet kitchen boasts Wolf appliances, built-in Sub Zero refrigerator/freezer, Sub Zero 102-bottle wine cooler, and oversized walnut wood island with farm-style sink and dining bar. The breakfast nook looks out into the park-like backyard and sparkling pool. The downstairs master suite includes large walk-in closet and outside access for spa, sauna, & pool use. Upstairs boasts 2 large bedrooms, guest bath, laundry room, loft area with built-in entertainment center/beverage cooler, and office with built-in desk, bookcase, and storage cabinets. This one-of-a-kind estate is a must see for the discerning Buyer.

Last Agent to Sell the Property

Marcus Theis

Theis Realty Group Inc. License #01404681 Listed on: 06/14/2024

Co-Listed By

Matt Theis

Theis Realty Group Inc. License #01978512

Last Buyer's Agent

Mari Tamimi

HomeSmart PV & Associates License #02121883

HomeSmart PV & Associates

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $7,207

Year Built

  • Built in 1937 | Remodeled

Lot Details

  • 1.09 Acre Lot
  • East Facing Home
  • Landscaped
  • Back Yard Fenced and Front Yard

Parking

  • 6 Car Garage
  • 4 Open Parking Spaces
  • Garage Door Opener
  • Drive Through
  • RV Access or Parking

Home Design

  • Custom Home
  • Raised Foundation
  • Frame Construction
  • Composition Roof
  • Stucco

Interior Spaces

  • 3,664 Sq Ft Home
  • Ceiling Fan
  • Fireplace
  • Double Pane Windows
  • Family Room
  • Formal Dining Room
  • Home Office
  • Loft
  • Partial Basement

Kitchen

  • Breakfast Area or Nook
  • Breakfast Bar
  • Double Oven
  • Gas Cooktop
  • Range Hood
  • Microwave
  • Built-In Refrigerator
  • Dishwasher
  • Kitchen Island
  • Wood Countertops
  • Ceramic Countertops
  • Disposal

Flooring

  • Wood
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Primary Bedroom on Main
  • Walk-In Closet
  • Primary Bathroom is a Full Bathroom
  • Tile Bathroom Countertop
  • Secondary Bathroom Double Sinks
  • Soaking Tub
  • Separate Shower

Laundry

  • Laundry Room
  • Laundry on upper level
  • Sink Near Laundry

Home Security

  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Pool

  • In Ground Pool
  • Gunite Pool
  • Spa

Outdoor Features

  • Deck
  • Covered patio or porch
  • Pergola

Utilities

  • Multiple cooling system units
  • Central Heating and Cooling System
  • Refrigerated and Evaporative Cooling System
  • Multiple Heating Units
  • 220 Volts
  • Well
  • Tankless Water Heater

Community Details

  • No Home Owners Association
  • Net Lease

Listing and Financial Details

  • Assessor Parcel Number 072-042-013-000

Home Details

Home Type

Single Family

Est. Annual Taxes

$7,207

Year Built

Built in 1937 | Remodeled

Lot Details

0

Parking

6

Listing Details

  • Property Type: Residential
  • Subtype Description: Custom, Detached
  • Property Subtype 1: Single Family Residence
  • Remodeled Updated: Yes
  • Year Built: 1937
  • Remodeled/Updated Desc: Bath 0-5YR, Kitchen 0-5YR, Bed 0-5YR, Other-Rmks 0-5YR
  • ResoPropertyType: Residential
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 0

Interior Features

  • Appliances: Gas Cook Top, Built-In Refrigerator, Hood Over Range, Dishwasher, Disposal, Microwave, Double Oven, Tankless Water Heater
  • Other Equipment: Water Cond Equipment Owned
  • Flooring: Carpet, Tile, Wood
  • Master Bathroom Features: Shower Stall(s), Double Sinks, Soaking Tub, Walk-In Closet
  • Master Bedroom Features: Ground Floor, Walk-In Closet, Outside Access
  • Total Bathrooms: 3
  • Bathroom Features: Shower Stall(s), Double Sinks, Tile
  • Basement: Partial
  • Dining Room Features: Breakfast Nook, Formal Room, Dining Bar
  • Kitchen Features: Breakfast Area, Ceramic Counter, Island w/Sink, Wood Counter
  • Living Room Features: Other
  • Room Type: Loft, Master Bathroom, Master Bedroom, Office, Dining Room, Family Room, Kitchen, Laundry
  • Main Level: Dining Room, Family Room, Master Bedroom, Partial Bath(s), Kitchen, Street Entrance
  • Price Per Square Foot: 477.62
  • Square Footage: 3664.00
  • Window Features: Dual Pane Full
  • ResoLivingAreaSource: Owner

Exterior Features

  • Other Structures: Pergola
  • Construction Materials: Stucco, Frame, Wood
  • Property Faces: East
  • Exterior Features: Fireplace
  • Fencing: Back Yard, Front Yard
  • Foundation: Raised
  • Home Warranty: No
  • Horse Property: No
  • Listing Price: 1899900.00
  • Lot Features: Auto Sprinkler F&R, Shape Regular, Landscape Back, Landscape Front
  • New Construction: No
  • Patio And Porch Features: Front Porch, Uncovered Deck, Covered Patio
  • Pool Features: Built-In, Gunite Construction
  • Pool: Yes
  • Property Condition: Updated/Remodeled
  • Road Surface Type: Paved
  • Roof: Composition
  • Spa Features: Spa/Hot Tub Personal
  • Spa: Yes
  • Topography: Level,Trees Few,Level,Trees Few
  • Land Use: Residential

Garage/Parking

  • Open Parking Spaces: 4.00
  • Garage Spaces: 6.00
  • Parking Features: RV Possible, Detached, Drive Thru Garage, Garage Door Opener
  • Driveway/Sidewalks: Gated

Utilities

  • Security: Carbon Mon Detector, Smoke Detector
  • Sewer: In & Connected, Public Sewer
  • Utilities: Public
  • Cooling: Ceiling Fan(s), Central, MultiUnits
  • Electric: 220 Volts
  • Heating: Central, MultiUnits
  • Laundry Features: Cabinets, Sink, Upper Floor, Inside Room
  • Water Source: Well

Condo/Co-op/Association

  • Association: No
  • Senior Community: No

Fee Information

  • Land Lease: No

Schools

  • Senior High School District: Turlock Unified

Lot Info

  • Zoning Description: R-1
  • Irrigation: Other
  • Lot Size Acres: 1.0900
  • Lot Size Sq Ft: 47480.00
  • ResoLotSizeUnits: Acres

Rental Info

  • Lease Type: Net

Multi Family

Tax Info

  • Assessor Parcel Number: 072-042-013-000
  • Bonds/Assessments/Taxes: Unknown

MLS Schools

  • School District (County): Stanislaus

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 14, 2024
Closed on
Aug 2, 2024
Sold by
Pearson Jonathan B and Pearson Kandice N
Bought by
Niniv And Mad Tamimi Revocable Trust and Tamimi
Seller's Agent
Marcus Theis
Theis Realty Group Inc.
Buyer's Agent
Mari Tamimi
HomeSmart PV & Associates
List Price
$1,899,900
Sold Price
$1,750,000
Premium/Discount to List
-$149,900
-7.89%
Views
217
Current Estimated Value
$1,119,600

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$630,400
Avg. Annual Appreciation
-40.51%
Original Mortgage
$1,312,500
Outstanding Balance
$1,303,474
Interest Rate
6.86%
Mortgage Type
New Conventional
Estimated Equity
-$183,874

Purchase Details

Listed on
Apr 16, 2018
Closed on
Jul 5, 2018
Sold by
Rootlieb Thomas H
Bought by
Pearson Jonathan B and Pearson Kandice N
Seller's Agent
Clarence Oliveira
Century 21 Select Real Estate
Buyer's Agent
Marcus Theis
Theis Realty Group Inc.
List Price
$689,900
Sold Price
$560,000
Premium/Discount to List
-$129,900
-18.83%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
20.57%
Original Mortgage
$448,000
Interest Rate
4.6%
Mortgage Type
New Conventional

Purchase Details

Closed on
Aug 12, 2004
Sold by
Teekell Gordon
Bought by
Rootieb Thomas H

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$471,200
Interest Rate
3.73%
Mortgage Type
Negative Amortization

Purchase Details

Closed on
Mar 8, 2004
Sold by
Teekell Marjorie C
Bought by
Teekell Marjorie C
Source: Public Records

Similar Homes in Turlock, CA

  • 4121 Country Walk Ln, Turlock, CA 95382

    $1,695,000

    • 4 Beds
    • 4.5 Baths
    • 5,485 Sq Ft
    • 4121 Country Walk Ln
    • Turlock, CA

    A one-of-a-kind luxury estate in Turlock’s most elite neighborhood—this fully custom-designed residence offers over 5,000 sq ft of flawless craftsmanship and refined elegance, perfectly positioned along the lush greenbelt for total seclusion and serenity.Enter through impressive double doors into a stunning luxury entrance featuring a masterful staircase that elevates the home’s grandeur. Soaring

    Paulina Mujica Exp Realty Of California

    Section Image
  • 1119 N Verduga Rd, Turlock, CA 95380

    $1,999,900

    • 3 Beds
    • 3.5 Baths
    • 2,902 Sq Ft
    • 1119 N Verduga Rd
    • Turlock, CA

    Location, Location...just outside Turlock's city limits...next in line for annexation, awaits this lovely almond ranch. The property features a near 3000sf ranch style complete with a red brick front porch & white picket fence. The home boasts 3 bdrms, 3.5 bathrms, separate living & family rooms, an oversized galley kitchen w/dual ovens, lots of cabinets, a traditional pantry & a double pantry

    Jessie Espinosa Century 21 Select Real Estate

    Section Image
  • 2631 Youngstown Rd, Turlock, CA 95380

    $1,790,777

    • 2 Beds
    • 2 Baths
    • 962 Sq Ft
    • 2631 Youngstown Rd
    • Turlock, CA

    Country Living right outside the city limits with all the amenities of living in town! The lovely Almond Ranch offers a great location and easy access to HWY 99 at a couple of miles distance. The main home is a combined approx 1600sf with recent upgrades to the roof, wrap around porch with the stamped concrete, full outdoor kitchen, and exterior paint to name a few. The home is a three

    Jessie Espinosa Century 21 Select Real Estate

    Section Image
  • 307 Dianne Dr, Turlock, CA 95380

    $1,980,000

    • 3 Beds
    • 2 Baths
    • 2,068 Sq Ft
    • 307 Dianne Dr
    • Turlock, CA

    Parcel with light industrial and/ or warehousing uses. Single family residence on property with monthly income of $3,000.00 The zoning is IBP (Industrial Business Park)

    Raman Pannu JRP Realty Group

    Section Image
  • 2901 Youngstown Rd, Turlock, CA 95380

    $1,936,800

    • 3 Beds
    • 2 Baths
    • 1,527 Sq Ft
    • 2901 Youngstown Rd
    • Turlock, CA

    Approx. 48.42 acres in eleven year old producing almonds within the Turlock Irrigation District (TID). Home is fixer (3 bed/2bath). Addresses of other two parcels included are 3818 Youngstown Road and 2818 Youngstown Road. Do not disturb tenant on property.

    John Lazar Century 21 Select Real Estate

    Section Image
  • 2007 W Glenwood Ave, Turlock, CA 95380

    $1,350,000

    • 3 Beds
    • 2 Baths
    • 1,888 Sq Ft
    • 2007 W Glenwood Ave
    • Turlock, CA

    Welcome to 2007 W Glenwood Ave, Turlock, a unique 9.7-acre country property that blends comfort, functionality, and income potential. This 1,888 sq ft home features 3 bedrooms, 2 full baths, a cozy fireplace in the living room, tile finishes in the kitchen and bathrooms, and a charming breakfast nook. Outside, the property is fully equipped with horse stalls, pole fencing, hay storage, a large

    Raman Pannu JRP Realty Group

    Section Image

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

Purchase History

Date Type Sale Price Title Company
Grant Deed $1,750,000 Wfg National Title Insurance C
Grant Deed $560,000 Stewart Title Of California
Grant Deed $589,000 Fidelity National Title
Interfamily Deed Transfer -- --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $1,312,500 New Conventional
Previous Owner $510,400 New Conventional
Previous Owner $448,000 New Conventional
Previous Owner $471,200 Negative Amortization
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/09/2024 08/09/24 Sold $1,750,000 -7.9% $478 / Sq Ft
07/24/2024 07/24/24 Pending -- -- --
07/20/2024 07/20/24 For Sale $1,899,900 0.0% $519 / Sq Ft
06/28/2024 06/28/24 Pending -- -- --
06/14/2024 06/14/24 For Sale $1,899,900 +239.3% $519 / Sq Ft
07/10/2018 07/10/18 Sold $560,000 -18.8% $183 / Sq Ft
05/21/2018 05/21/18 Pending -- -- --
04/15/2018 04/15/18 For Sale $689,900 -- $225 / 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
2024 $7,207 $671,585 $259,192 $412,393
2023 $7,196 $658,417 $254,110 $404,307
2022 $7,106 $645,508 $249,128 $396,380
2021 $6,377 $576,480 $244,244 $332,236
2020 $6,333 $570,570 $241,740 $328,830
2019 $5,606 $503,500 $237,000 $266,500
2018 $4,931 $441,500 $199,500 $242,000
2017 $4,735 $425,839 $183,701 $242,138
2016 $4,904 $462,500 $159,000 $303,500
2015 $4,316 $405,000 $110,000 $295,000
2014 $3,872 $360,500 $85,000 $275,500
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: MetroList

MLS Number: 224063846

MetroList

APN: 072-42-13