1 of 44

Want to see this home?

617 W Esplanade Drive

Tracy, CA 95391

4 beds
3 baths
2,782 sqft
5,127 sqft lot
$387 per sqft
2007 build
– on site

First time on the market! The Premier Model Home The Promenade by Shea Homes'' is offering a blend of Sophistication, Elegance and Great Living. Nestled in the Heart of Questa Village. Meticulously upgraded with over $150,000 in modern enhancements. The Gated entrance leads to 2 separate private patios with a direct access to main level of the house. This unique floorplan home is offering 4 bedrooms & 3 baths with expanded white Oak hardwood floor throughout. Very convenient 1 bedroom & 1 bathroom downstairs, perfect for guests or multigenerational living. Beautifully designed crown molding & custom made shutters throughout, the sleek glass doors off the cozy Den space is spreading a great feel of peace & privacy. Formal dining room with access to a prestigious & elegant kitchen with granite countertops island surrounded by marble backsplash The chef's kitchen boasts granite countertops & kitchen island with Cherrywood cabinets throughout. Formal dining room with access to a prestigious & elegant kitchen with granite countertops island surrounded by marble backsplash. Heavenly designed yard filled with lots of fruit trees. Very desirable location, walking distance to Questa Elementary school, close to all shops and freeways. NO HOA!!! This Home is A MUST see!

Listing courtesy of METROLIST / Real Estate Source Inc

Last checked: Checking… • Last updated Jul 4, 2025 •

MLS# 225088683 —

The Building

Year Built:

2007
Year Built Source:

Assessor Auto-Fill
Remodeled Updated:

Yes
Construction Materials:

Ceiling Insulation, Concrete, Stucco, Wood
Construction Materials:

#Collection(String)
Builder Name:

SHEA HOMES
Builder Model:

The PROMENADE
Building Features:

#Collection(String)
Architectural Style:

Rustic, Spanish
Architectural Style:

#Collection(String)
Development Status:

#Collection(String)
Structure Type:

#Collection(String)
Subtype Description:

#Collection(String)
Roof:

Spanish Tile
Roof:

#Collection(String)
Foundation Details:

Slab
Foundation Details:

#Collection(String)
Stories:

2
Levels:

Two
Levels:

#Collection(String)
Upper Level:

#Collection(String)
Main Level:

#Collection(String)
Lower Level:

#Collection(String)
Basement:

#Collection(String)
Direction Faces:

Southwest
Exterior Features:

Covered Courtyard, Entry Gate, Fire Pit
Exterior Features:

#Collection(String)
Window Features:

Dual Pane Full
Window Features:

#Collection(String)
Patio And Porch Features:

Front Porch, Covered Deck, Enclosed Patio
Patio And Porch Features:

#Collection(String)
Accessibility Features:

#Collection(String)

Interior

Interior Features:

#Collection(String)
Kitchen Features:

Breakfast Area, Granite Counter, Island w/Sink, Kitchen/Family Combo
Flooring:

Carpet, Stone, Tile, Wood
Flooring:

#Collection(String)
Upper Level:

Bedroom(s), Loft, Master Bedroom
Main Level:

Bedroom(s), Living Room, Dining Room, Family Room, Full Bath(s), Garage, Kitchen
Dining Room Features:

Breakfast Nook, Formal Room, Dining/Family Combo
Living Room Features:

Great Room, Open Beam Ceiling
Fireplace Features:

#Collection(String)
Laundry Features:

Cabinets, Ground Floor, Hookups Only, Inside Room
Laundry Features:

#Collection(String)

Room Dimensions

Living Area:

2782.0
Living Area Source:

Assessor Auto-Fill

Financial & Terms

Lease Type:

Net
Lease Type:

#Collection(String)
Lease Info:

#Collection(String)
Lease Includes:

#Collection(String)
Rent Includes:

#Collection(String)
Tenant Pays:

#Collection(String)
Owner Pays:

#Collection(String)
Pets Allowed:

#Collection(String)

Location

Directions:

From Byron, left on Great Valley, Left on Questa Trail & right on Esplanade Dr.

The Property

Property Type:

Residential
Property Subtype:

Single Family Residence
Property Condition:

#Collection(String)
Parcel Number:

256-470-30
Current Use:

#Collection(String)
Possible Use:

#Collection(String)
Zoning:

R1
Lot Features:

Landscape Front
Lot Features:

#Collection(String)
Lot Size Acres:

0.1177
Lot Size Square Feet:

5127.0
Land Use:

Residential
Lot Size Units:

Acres
Lot Size Source:

Assessor Auto-Fill
Land Lease:

false
View:

#Collection(String)
View:

Garden/Greenbelt
Vegetation:

#Collection(String)
Irrigation Source:

#Collection(String)
Fencing:

Fenced, Wood
Fencing:

#Collection(String)
Horse:

false
Horse Amenities:

#Collection(String)
Crops:

#Collection(String)
Soil:

#Collection(String)
Land Use:

#Collection(String)
Irrigation Source:

Public District
Frontage Type:

#Collection(String)
Road Surface Type:

#Collection(String)
Road Frontage Type:

#Collection(String)
Road Responsibility:

#Collection(String)
Driveway Sidewalks:

#Collection(String)

Listing Agent

Contact info:

Beds

Bedrooms Total:

4
Master Bedroom Features:

Walk-In Closet

Baths

Total Baths:

3
Full Baths:

3
Master Bathroom Features:

Shower Stall(s), Jetted Tub, Stone, Marble, Window

The Listing

Home Warranty:

false

Heating & Cooling

Heating:

Central, Fireplace(s), Gas
Heating:

#Collection(String)
Cooling:

Ceiling Fan(s), Central, MultiZone
Cooling:

#Collection(String)

Utilities

Utilities:

Cable Connected, Electric, Natural Gas Connected
Utilities:

#Collection(String)
Electric:

220 Volts in Laundry
Electric:

#Collection(String)
Sewer:

In & Connected
Sewer:

#Collection(String)
Water Source:

Public
Water Source:

#Collection(String)
Green Energy Efficient:

#Collection(String)

Appliances

Appliances:

Built-In Electric Oven, Built-In Refrigerator, Dishwasher, Disposal, Microwave
Appliances:

#Collection(String)

Schools

Elementary School District:

Lammersville
Middle Or Junior School District:

Lammersville
High School District:

Lammersville

The Community

Community Features:

#Collection(String)
Association:

false
Association Amenities:

#Collection(String)
Spa:

false
Spa Features:

#Collection(String)
Pool Private:

false
Pool Features:

#Collection(String)
Senior Community:

false

Parking

Garage Spaces:

2.0
Parking Type:

#Collection(String)
Parking Access:

#Collection(String)
Parking Features:

Attached, Garage Facing Rear, Guest Parking Available
Parking Features:

#Collection(String)

Extra Units

Unit 1 Type:

#Collection(String)
Unit 2 Type:

#Collection(String)
Unit 3 Type:

#Collection(String)
Unit 4 Type:

#Collection(String)
Other Units:

#Collection(String)

Monthly cost estimate

Asking price

$1,079,000

Expense	Monthly cost
Mortgage	$5,777
Taxes	N/A
Insurance	$296
Utilities	$193 See report
Total	$6,266/mo.^*
	^*This is an estimate

Explore the Area

My Commute

From

Walk Score®

Provided by WalkScore® Inc.

Bike Score®

Provided by WalkScore® Inc.

Air Pollution Index

Provided by ClearlyEnergy

Max Internet Speed

Xfinity

Provided by BroadbandNow®

Sale history

Date	Event	Source	Price	% Change
7/4/25 Jul 4, 2025	Listed / Active	METROLIST	$1,079,000

Want a closer look?

Go see 617 W Esplanade Drive

Or Call Toll Free 1-800-258-2512

We guarantee that we’ll never spam you.

* indicates a required field

More homes

Newest listings in Mountain House, CA

Similar sold homes

This house located in Mountain House, CA 95391 is currently for sale for $1,079,000. 617 W Esplanade Drive is a 2,782 square foot house with 4 beds and 3 baths that has been on Estately for 0 days.

Listing courtesy of Real Estate Source Inc

Terms of service, data current as of 4:48pm on Jul 04.

Every person who intends to view or use such MLS information agrees to Terms of Use that include the following terms and conditions:

All measurements and all calculations of area are approximate. Information provided by Seller/Other sources, not verified by Broker. All interested persons should independently verify accuracy of information. Provided properties may or may not be listed by the office/agent presenting the information.”

Copyright 2025 MetroList Services, Inc. Information being provided by Metrolist Services, Inc. is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing

Kevin Boer is Estately's licensed broker in the state of California and Subscriber with Metrolist. Office #01842161; DRE License #01404898.

Terms of Use

The following are terms of a legal agreement between you, the person viewing and/or using this Internet site (“User”) and the operator ("Provider") of this Internet site ("Site"), By accessing, browsing and/or using this Site, User acknowledges that User has read, understood, and agrees to be bound by these terms and to comply with all applicable laws and regulations, including but not limited to U.S. export and re-export control laws and regulations. If User does not agree to these terms, User is not authorized to use this Site. The material provided on this Site is protected by law, including, but not limited to, United States Copyright law and international treaties.
User must be a prospective purchaser or seller of real estate with a bona fide interest in the purchase or sale of such real estate.
All real estate data and other informational content provided on this Site (including but not limited to descriptions, images, and other information constituting or relating to real estate listings) is strictly for the personal, private, non-commercial use of User and is not made available for redistribution, retransmission, reformatting, modification or copying. User may not sell or use any of the real estate data on this Site for any purpose other than attempting to evaluate houses or properties for sale or purchase by User. User acknowledges that the real estate data and other informational content on this Site is provided by MetroList Services, Inc., a California corporation (“MetroList”), and User acknowledges the validity of MetroList's copyright as to such data. User expressly acknowledges and agrees that MetroList is a third-party beneficiary of these Terms of Use, and that MetroList will be entitled to enforce these Terms of Use against User.
To the fullest extent permitted by law, the data on this Site is provided "as is," without warranty or representation of any kind, either express or implied, as to the nature, quality, characteristics or value of any property or information to which the data pertains. NEITHER PROVIDER NOR METROLIST MAKES ANY WARRANTIES, EXPRESS OR IMPLIED, REGARDING THE DATA DISPLAYED ON THIS SITE, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, OR AS TO THE TIMELINESS, ACCURACY AND/OR COMPLETENESS OF THE DATA.
NEITHER PROVIDER NOR METROLIST SHALL BE LIABLE FOR ANY INCIDENTAL, SPECIAL, CONSEQUENTIAL, INDIRECT, SPECIAL, PUNITIVE OR EXEMPLARY DAMAGES WHATSOEVER (INCLUDING WITHOUT LIMITATION, DAMAGES FOR LOSS OF BUSINESS INFORMATION, LOSS OF DATA, LOST PROFITS, LOSS OF CUSTOMERS OR OTHER PECUNIARY LOSS), ARISING OUT OF THE USE OR INABILITY TO USE THE DATA DISPLAYED ON THIS SITE, WHETHER THE CLAIM OR CAUSE OF ACTION ARISES IN TORT, CONTRACT, NEGLIGENCE, STRICT LIABILITY OR UNDER ANY OTHER LEGAL THEORY.
User agrees that the prevailing party or parties in any action brought to enforce or for breach of these Terms of Use shall be entitled to recover, in addition to any other relief, that party’s or those parties’ reasonable attorney’s fees and court costs incurred in such action from the non-prevailing party or parties.