$2,188,000
1,914
SQ FT
$1,143
SQ/FT
40220 Hacienda Court
@ Las Palmas Ave - 3700 - Fremont, Fremont
- 4 Bed
- 3 Bath
- 2 Park
- 1,914 sqft
- FREMONT
-
Welcome to this beautifully updated 4-bedroom, 3-bath home tucked away on a quiet cul-de-sac in Fremonts highly desirable Mission San Jose neighborhood. The bright, open floor plan features dramatic vaulted ceilings, abundant natural light, new flooring, fresh interior paint, recessed lighting, and dual-pane windows. The spacious kitchen offers custom hickory cabinetry, stainless steel appliances, generous counter space, and a convenient breakfast bar, opening directly to the inviting family room with a fireplace and wet bar. A main-level bedroom and full bathroom provide excellent flexibility for guests, extended family, multigenerational living, or a private home office. Upstairs, the primary suite enjoys beautiful Mission Peak views, a walk-in closet, and an updated bathroom with a skylight. The private backyard is surrounded by mature fruit trees and lush landscaping, creating an ideal setting for gardening, outdoor dining, entertaining, or relaxing. Additional highlights include owned solar and a prime location near Lake Elizabeth, Central Park, shopping, dining, Fremont BART, and major commuter routes. Located within the attendance area for Gomes Elementary, Hopkins Junior High, and Mission San Jose High School.
- Days on Market
- 1 day
- Current Status
- Active
- Original Price
- $2,188,000
- List Price
- $2,188,000
- On Market Date
- Aug 4, 2026
- Property Type
- Single Family Home
- Area
- 3700 - Fremont
- Zip Code
- 94539
- MLS ID
- ML82056324
- APN
- 525-0003-054
- Year Built
- 1967
- Stories in Building
- 3
- Possession
- Unavailable
- Data Source
- MLSL
- Origin MLS System
- MLSListings, Inc.
John Gomes Elementary School
Public K-6 Elementary
Students: 746 Distance: 0.3mi
Kimber Hills Academy
Private K-8 Elementary, Religious, Coed
Students: 261 Distance: 0.4mi
Mission Hills Christian School
Private K-8 Elementary, Religious, Coed
Students: NA Distance: 0.7mi
William Hopkins Junior High School
Public 7-8 Middle
Students: 1060 Distance: 0.7mi
California School For The Deaf-Fremont
Public PK-12
Students: 372 Distance: 0.8mi
California School For The Blind
Public K-12
Students: 66 Distance: 1.0mi
- Bed
- 4
- Bath
- 3
- Full on Ground Floor
- Parking
- 2
- Attached Garage
- SQ FT
- 1,914
- SQ FT Source
- Unavailable
- Lot SQ FT
- 6,000.0
- Lot Acres
- 0.137741 Acres
- Kitchen
- Dishwasher, Exhaust Fan, Refrigerator, Skylight
- Cooling
- Central AC
- Dining Room
- Breakfast Bar, Formal Dining Room
- Disclosures
- Natural Hazard Disclosure
- Family Room
- Separate Family Room
- Flooring
- Laminate
- Foundation
- Crawl Space
- Fire Place
- Family Room
- Heating
- Central Forced Air
- Laundry
- Washer / Dryer
- Views
- Mountains
- Fee
- Unavailable
MLS and other Information regarding properties for sale as shown in Theo have been obtained from various sources such as sellers, public records, agents and other third parties. This information may relate to the condition of the property, permitted or unpermitted uses, zoning, square footage, lot size/acreage or other matters affecting value or desirability. Unless otherwise indicated in writing, neither brokers, agents nor Theo have verified, or will verify, such information. If any such information is important to buyer in determining whether to buy, the price to pay or intended use of the property, buyer is urged to conduct their own investigation with qualified professionals, satisfy themselves with respect to that information, and to rely solely on the results of that investigation.
School data provided by GreatSchools. School service boundaries are intended to be used as reference only. To verify enrollment eligibility for a property, contact the school directly.































































