$879,000
PENDING

617 W Esplanade Dr Mountain House, CA 95391

Estimated payment $5,596/month

Total Views 90
4 Beds
3 Baths
2,782 Sq Ft
$316 Price per Sq Ft

Highlights

  • Built-In Refrigerator
  • Wood Flooring
  • Park or Greenbelt View
  • Altamont Elementary School Rated A
  • Main Floor Bedroom
  • 2 Fireplaces

About This Home

Welcome to 617 Esplanade Drive in the highly sought-after Questa Village. Built by Shea Homes, this amazing Promenade model was originally the showcase model home for the community and offers an incredible blend of luxury, functionality, and location. Perfectly situated directly across the street from award-winning Sebastian Questa K-8 School, rated 10 out of 10 by Great Schools, and just steps from beautiful Questa Park, this home delivers an unmatched lifestyle for families. As you arrive, you are greeted by a private gated entrance leading to a charming courtyard with a palm trees and planter box, creating an inviting first impression. With no HOA, this stunning residence offers 4 bedrooms, 3 full bathrooms, and a highly desirable downstairs bedroom and full bath, making it ideal for multigenerational living, guests, or a private home office. The home is loaded with upgrades throughout. The first floor has been recently painted and features plantation shutters, updated LED lighting, elegant crown molding, 5-inch baseboards, surround sound speakers, and brand-new luxury vinyl plank flooring. The gourmet kitchen is designed for both everyday living and entertaining, featuring a generous center island, walk-in pantry, built-in refrigerator, built-in wine refrigerator, and stainless steel appliances. Upstairs, every bedroom showcases its own unique designer theme, reflecting the home's original model home status. You'll also find a convenient study or work area, upgraded high-end carpeting, and beautiful hardwood flooring throughout the hallway. One of the home's most unique features is the inviting sitting room complete with custom built-ins, a cozy fireplace, and its own private sliding glass door leading directly to your backyard oasis. The incredible yard is truly a gardener's paradise, boasting an impressive variety of mature fruit trees including apple, pear, pomegranate, grape, mulberry, guava, almond, nectarine, plum, peach, persimmon, fig, orange, and cherry trees. Entertaining is effortless with a built-in barbecue, natural gas-plumbed fire pit, and multiple outdoor gathering spaces. With ample parking, no immediate neighbors directly in front of the home, and exceptional privacy, 617 Esplanade Drive truly checks every box for modern, comfortable living in one of Mountain House's most desirable neighborhoods.

Listing Agent

Salah Salah

Refined Real Estate License #02022642 Listed on: 06/25/2026

Home Details

Home Type

  • Single Family

Year Built

  • Built in 2007 | Remodeled

Lot Details

  • 5,127 Sq Ft Lot
  • North Facing Home
  • Back Yard Fenced
  • Landscaped
  • Zero Lot Line

Parking

  • 2 Car Attached Garage
  • Alley Access
  • Rear-Facing Garage

Home Design

  • Slab Foundation
  • Tile Roof
  • Stucco

Interior Spaces

  • 2,782 Sq Ft Home
  • 2-Story Property
  • Crown Molding
  • Ceiling Fan
  • 2 Fireplaces
  • Electric Fireplace
  • Plantation Shutters
  • Great Room
  • Family Room
  • Living Room
  • Formal Dining Room
  • Park or Greenbelt Views

Kitchen

  • Breakfast Bar
  • Built-In Gas Oven
  • Gas Cooktop
  • Range Hood
  • Microwave
  • Built-In Refrigerator
  • Dishwasher
  • Wine Refrigerator
  • Kitchen Island
  • Granite Countertops
  • Disposal

Flooring

  • Wood
  • Carpet
  • Tile
  • Luxury Vinyl Plank Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Main Floor Bedroom
  • Primary Bedroom Upstairs
  • Walk-In Closet
  • Split Bathroom
  • 3 Full Bathrooms
  • Secondary Bathroom Double Sinks
  • Bathtub with Shower
  • Separate Shower
  • Window or Skylight in Bathroom

Laundry

  • Laundry on main level
  • Sink Near Laundry
  • Laundry Cabinets

Home Security

  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Outdoor Features

  • Patio
  • Fire Pit
  • Pergola
  • Built-In Barbecue
  • Front Porch

Utilities

  • Forced Air Zoned Heating and Cooling System
  • 220 Volts
  • Natural Gas Connected
  • Property is located within a water district

Community Details

  • No Home Owners Association
  • Built by Shea Homes
  • Questa Village Subdivision, The Promenade Floorplan

Listing and Financial Details

  • Assessor Parcel Number 256-470-30

Home Details

Home Type

Single Family

Year Built

Built in 2007 | Remodeled

Lot Details

5,127 Sq Ft Lot

Parking

2

Listing Details

  • Property Type: Residential
  • Subtype Description: Detached
  • Property Subtype 1: Single Family Residence
  • Remodeled Updated: Yes
  • Stories: 2
  • Year Built: 2007
  • Subdivision: Questa Village
  • Remodeled/Updated Desc: Other-Rmks 0-5YR
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Appliances: Gas Cook Top, Built-In Gas Oven, Built-In Refrigerator, Hood Over Range, Dishwasher, Disposal, Microwave, Wine Refrigerator
  • Fireplace Features: Electric
  • Fireplaces: 2
  • Flooring: Carpet, Tile, Luxury Vinyl Plank, Wood
  • Master Bathroom Features: Shower Stall(s), Double Sinks, Tub, Walk-In Closet, Window
  • Total Bathrooms: 3
  • Bathroom Features: Shower Stall(s), Double Sinks, Split Bath, Tub w/Shower Over, Window
  • Dining Room Features: Dining Bar, Formal Area
  • Kitchen Features: Pantry Closet, Granite Counter, Island w/Sink
  • Living Room Features: Great Room
  • Main Level: Bedroom(s), Living Room, Dining Room, Family Room, Full Bath(s), Street Entrance
  • Price Per Square Foot: 315.96
  • Square Footage: 2782.00

Exterior Features

  • Other Structures: Pergola
  • Builder Name: Shea Homes
  • Construction Materials: Stucco, Wood
  • Property Faces: North
  • Disclosures/Documents: Roof Inspection, Seller Property Questionnaire, Disclosure Package Available, Transfer Disclosure Statement, Home Inspection Report, Natural Hazard Disclosure Available, Preliminary Title Report
  • Exterior Features: Built-In Barbeque, Fire Pit
  • Fencing: Back Yard, Wood, Fenced
  • Foundation: Slab
  • Home Warranty: No
  • Horse Property: No
  • Listing Price: 879000.00
  • Lot Features: Landscape Back, Zero Lot Line, Landscape Front
  • New Construction: No
  • Patio And Porch Features: Front Porch, Back Porch, Uncovered Patio
  • Pool: No
  • Roof: Tile
  • Spa: No
  • View Description: Park

Garage/Parking

  • Garage Spaces: 2.00
  • Parking Features: Alley Access, Attached, Garage Facing Rear

Utilities

  • Security: Carbon Mon Detector, Smoke Detector
  • Sewer: Public Sewer
  • Utilities: Public, Electric, Sewer In & Connected, Natural Gas Connected
  • Cooling: Ceiling Fan(s), Central, MultiZone
  • Electric: 220 Volts
  • Heating: Central, Fireplace(s), MultiZone
  • Laundry Features: Cabinets, Sink, Ground Floor
  • Water Source: Public, Meter on Site, Water District

Condo/Co-op/Association

  • Association: No
  • Senior Community: No

Fee Information

  • Land Lease: No

Schools

  • Senior High School District: Lammersville

Lot Info

  • Zoning: res
  • Irrigation: Irrigation Available
  • Lot Size Acres: 0.1177
  • Lot Size Sq Ft: 5127.00

Multi Family

Tax Info

  • Assessor Parcel Number: 256-470-30
  • Bonds/Assessments/Taxes: Unknown

MLS Schools

  • School District (County): San Joaquin

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 $10,511 $612,919 $214,520 $398,399
2024 $10,232 $600,902 $210,314 $390,588
2023 $10,050 $589,121 $206,191 $382,930
2022 $9,828 $577,571 $202,149 $375,422
2021 $11,514 $566,247 $198,186 $368,061
2020 $9,604 $560,441 $196,154 $364,287
2019 $9,483 $549,453 $192,308 $357,145
2018 $9,725 $538,681 $188,538 $350,143
2017 $9,182 $528,120 $184,842 $343,278
2016 $8,773 $517,765 $181,218 $336,547
2014 $8,303 $481,000 $172,000 $309,000
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/30/2026 06/30/26 Pending -- -- --
06/25/2026 06/25/26 For Sale $879,000 -- $316 / Sq Ft
Source: MetroList

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 $500,000 Chicago Title Company
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 $400,000 Adjustable Rate Mortgage/ARM
Source: Public Records

Source: MetroList

MLS Number: 226080890

MetroList

APN: 256-470-30

Your Personal Tour Guide

Ask me questions while you tour the home.