$1,195,000
PENDING $55K PRICE DROP

700 W Esplanade Dr Tracy, CA 95391

Tracy Area

Estimated payment $7,784/month

Total Views 1,805
6 Beds
4.5 Baths
3,827 Sq Ft
$312 Price per Sq Ft

Highlights

  • Updated Kitchen
  • Corner Lot
  • Breakfast Area or Nook
  • Contemporary Architecture
  • No HOA
  • 2 Car Attached Garage

About This Home

QUESTA VILLAGE MUST-SEE | CORNER LOT | CASITA/IN-LAW UNIT One home. Two addresses. Endless possibilities. Why wait to build? This finished, upgraded, north-facing home is ready now — offered at a compelling new price. A 3,353 sq ft main home (5BD/3.5BA) plus a contiguous built-in 474 sq ft Casita/ADU (1BD/1BA) totals 6BD/4.5BA and 3,827 livable sq ft — with an additional 560 sq ft permitted finished sunroom of usable space, wrapped in fans, sliding doors, and abundant glass. Inside, the main home delivers formal dining, a chef's kitchen, a living room fireplace, and a sunroom opening to a sprawling yard. A downstairs guest suite with private bath, an office or 6th-bedroom option with French doors, and an upstairs oversized primary retreat with private nook plus Jack & Jill bedrooms give everyone room to spread out, gather, and grow. The Casita changes everything: full kitchen, full bath, living room, in-unit laundry hookups, and a private exterior entrance. Rent it, house family, host guests, or offset your mortgage — income potential built right in. Set on a corner lot wrapped in mature landscaping for instant curb appeal and natural privacy, with room to potentially build the backyard of your dreams: pool, outdoor kitchen, playground, or all three. Just a short distance to highly rated Questa Elementary and Questa Park. Space to grow, freedom to live, and possibilities buyers spend years searching for. Come see it fresh — schedule your private showing today. Buyer to verify square footage, room count, and school enrollment.

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

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
08/04/2026 08/04/26 Pending -- -- --
08/01/2026 08/01/26 Price Changed $1,195,000 -4.4% $312 / Sq Ft
07/25/2026 07/25/26 For Sale $1,250,000 0.0% $327 / Sq Ft
07/18/2026 07/18/26 Pending -- -- --
07/02/2026 07/02/26 For Sale $1,250,000 0.0% $327 / Sq Ft
06/25/2026 06/25/26 Pending -- -- --
06/19/2026 06/19/26 For Sale $1,250,000 -- $327 / Sq Ft
Source: Contra Costa Association of REALTORS®

Purchase 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 Type Sale Price Title Company
Grant Deed $751,500 Chicago Title Company
Grant Deed -- First American Title
Source: Public Records

Mortgage 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 Status Loan Amount Loan Type
Open $548,250 New Conventional
Closed $600,822 Adjustable Rate Mortgage/ARM
Previous Owner -- Credit Line Revolving
Source: Public Records

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.