40743 Rainwater

$3,799,000 3,321 SQ FT
$1,144 SQ/FT

40743 Rainwater

@ Lemos - Mission San Jose, Fremont

Map direct
  • 4 Bed
  • 2.5 (2/1) Bath
  • 3 Park
  • 3,321 sqft
  • Fremont
  • Payment calculator
DTCH
  • Favorite
  • Hide
Message Brian Byers

First Time Listed on the Market – Spacious Home Steps from Gomes Elementary Available on the market for the first time since this family home was built, this well-maintained semi-custom home is located in one of Fremont’s most desirable school districts—just a stone’s throw from Gomes Elementary and within easy walking distance to Hopkins Junior High and Mission San Jose High. The home offers 4 spacious bedrooms plus an office/den, 2.5 bathrooms, and an open, comfortable layout with vaulted ceilings and hardwood floors throughout. Two fireplaces and a wet bar add warmth and character, while the large, landscaped backyard with a waterfall feature provides plenty of space to relax or play. An attached 3-car garage offers ample storage. A rare find in a prime location—close to top schools, parks, and neighborhood conveniences

Current Status
Canceled
Original Price
$3,799,000
List Price
$3,799,000
On Market Date
Oct 22, 2025
Property Type
Detached
D/N/S
Mission San Jose
Zip Code
94539
MLS ID
41115423
APN
5251654045
Year Built
1989
Stories in Building
2
Possession
Close Of Escrow
Data Source
MAXEBRDI
Origin MLS System
BAY EAST
Bed
4
Bath
2.5 (2/1)
Parking
3
Attached, Garage Door Opener
SQ FT
3,321
SQ FT Source
Public Records
Lot SQ FT
10,003.0
Lot Acres
0.23 Acres
Pool Info
None
Kitchen
Dishwasher, Electric Range, Microwave, Refrigerator, Dryer, Washer, 220 Volt Outlet, Electric Range/Cooktop, Disposal, Wet Bar
Cooling
Central Air
Disclosures
None
Entry Level
Exterior Details
Back Yard, Front Yard, Sprinklers Front, Landscape Back, Landscape Front
Flooring
Hardwood, Tile
Foundation
Fire Place
Family Room, Living Room
Heating
Forced Air, Natural Gas
Laundry
220 Volt Outlet, Dryer, Washer, Cabinets
Upper Level
4 Bedrooms, 2 Baths
Main Level
0.5 Bath, Laundry Facility, Main Entry
Possession
Close Of Escrow
Basement
Crawl Space
Architectural Style
Other
Non-Master Bathroom Includes
Stall Shower, Tile, Double Vanity
Construction Status
Existing
Additional Miscellaneous Features
Back Yard, Front Yard, Sprinklers Front, Landscape Back, Landscape Front
Location
Cul-De-Sac, Back Yard, Front Yard, Landscaped, Sprinklers In Rear
Roof
Composition Shingles
Water and Sewer
Public, Water District
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.

Listings © 2026 Paragon MLS

Copyright © 2026 Theo Inc. All Rights Reserved