$1,250,000
PENDING

700 W Esplanade Dr Tracy, CA 95391

Estimated payment $7,955/month

Total Views 296
6 Beds
4.5 Baths
4,002 Sq Ft
$312 Price per Sq Ft

Highlights

  • Updated Kitchen
  • Contemporary Architecture
  • No HOA
  • Altamont Elementary School Rated A
  • Corner Lot
  • Breakfast Area or Nook

About This Home

QUESTA VILLAGE'S MUST-SEE | CORNER LOT | CASITA One home. Two Addresses. Endless possibilities. 6 BD | 4.5 BA | 4,000+ SQ FT | PRIVATE IN-LAW SUITE WITH SEPARATE ENTRANCE. Step inside and be impressed. Formal dining. Chef's kitchen. Fireplace living room. Permitted sunroom opening to a sprawling backyard. Guest suite with private bath. Office or 6th bedroom with French doors. Upstairs primary retreat with private nook. Jack & Jill bedrooms. This home has it all and then some. The Casita changes everything. Full kitchen. Full bath. Living room. In-unit laundry. Private exterior entrance. Rent it. House family. Host guests. Offset your mortgage. This is the feature buyers spend years searching for. Outside, a corner lot wrapped in mature landscaping delivers instant curb appeal, natural privacy, and room to build the backyard of your dreams; potential for pool, outdoor kitchen, playground or all three! . Close distance to Questa Elementary & Questa Park. Space to grow. Freedom to live. Income potential built right in.

Listing Agent

Mary Arnerich

Vanguard Properties Brokerage Phone: 925-872-7975 License #01419839 Listed on: 06/19/2026

Co-Listing Agent

Leslie Whitney

Vanguard Properties Brokerage Phone: 925-872-7975 License #01950037

Home Details

Home Type

  • Single Family

Year Built

  • Built in 2017

Lot Details

  • 9,297 Sq Ft Lot
  • North Facing Home
  • Corner Lot

Parking

  • 2 Car Attached Garage
  • Garage Door Opener

Home Design

  • Contemporary Architecture
  • Slab Foundation
  • Tile Roof
  • Fiber Cement Roof
  • Stucco

Interior Spaces

  • 2-Story Property
  • Fireplace With Gas Starter

Kitchen

  • Updated Kitchen
  • Breakfast Area or Nook
  • Breakfast Bar
  • Built-In Oven
  • Gas Range
  • Microwave
  • Dishwasher

Flooring

  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 6 Bedrooms

Laundry

  • Dryer
  • Washer

Utilities

  • Zoned Heating and Cooling System
  • Gas Water Heater

Community Details

  • No Home Owners Association
  • Built by Shea Homes
  • Mountain House Subdivision

Listing and Financial Details

  • Assessor Parcel Number 256250120000

Home Details

Home Type

Single Family

Year Built

Built in 2017

Lot Details

9,297 Sq Ft Lot

Parking

2

Listing Details

  • Stories: 2
  • Year Built: 2017
  • Property Sub Type: Detached
  • Prop. Type: Residential
  • Co List Office Mls Id: CCVANPR2
  • Subdivision Name: Mountain House
  • Directions: Altamont Pass Road to Grant Line Road to Great Valley Pkwy to W Esplanade DR..
  • Architectural Style: Contemporary
  • Garage Yn: Yes
  • Unit Levels: Two Story
  • New Construction: No
  • Attribution Contact: Agt: 925-872-7975
  • Special Features: VirtualTour

Interior Features

  • Flooring: Tile, Carpet
  • Appliances: Dishwasher, Gas Range, Microwave, Oven, Refrigerator, Dryer, Washer, Gas Water Heater
  • Full Bathrooms: 4
  • Total Bedrooms: 6
  • Fireplace Features: Gas Starter
  • Fireplaces: 1
  • Fireplace: Yes
  • Window Features: Window Coverings
  • Room Kitchen Features: Breakfast Bar, Breakfast Nook, Stone Counters, Dishwasher, Eat-in Kitchen, Disposal, Gas Range/Cooktop, Kitchen Island, Microwave, Oven Built-in, Refrigerator, Updated Kitchen

Exterior Features

  • Roof: Tile, Cement
  • Lot Features: Corner Lot, Premium Lot
  • Pool Features: None
  • Pool Private: No
  • Builder Name: Shea Homes
  • Construction Type: Stucco
  • Direction Faces: North
  • Foundation Details: Slab
  • Property Condition: Existing

Garage/Parking

  • Garage Spaces: 2
  • Parking Features: Attached, Garage Door Opener

Utilities

  • Heating: Zoned
  • Cooling: Central Air
  • Laundry Features: Dryer, Hookups Only, Laundry Room, Washer
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Electric: No Solar
  • Water Source: Public

Condo/Co-op/Association

  • Association: No

Lot Info

  • Lot Size Sq Ft: 9297
  • Parcel Number: 256250120000

Map

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

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
2025 $14,440 $910,666 $203,099 $707,567
2024 $14,058 $892,811 $199,117 $693,694
2023 $13,814 $875,306 $195,213 $680,093
2022 $13,524 $858,144 $191,386 $666,758
2021 $13,369 $841,319 $187,634 $653,685
2020 $13,216 $832,694 $185,711 $646,983
2019 $12,677 $781,368 $182,070 $599,298
2018 $13,784 $766,048 $178,500 $587,548
2017 $8,640 $444,239 $143,239 $301,000
2016 $3,242 $140,431 $140,431 $0
2014 $3,136 $135,613 $135,613 $0
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
06/25/2026 06/25/26 Pending -- -- --
06/19/2026 06/19/26 For Sale $1,250,000 -- $312 / Sq Ft
Source: Contra Costa Association of REALTORS®

Source: Contra Costa Association of REALTORS®

MLS Number: 41138947

Contra Costa Association of REALTORS®

APN: 256-250-12

Your Personal Tour Guide

Ask me questions while you tour the home.