Welcome to this gorgeous home in a cul-de-sac in the heart of Mission with amazing views of Mission Peak and the hills. Formal entry to marble tile flooring with high ceilings, a formal living room with vaulted ceilings, views of the hills, and a formal dining area. Family room comes with a cozy fireplace lined with marble tiles. A glass sliding door leads to a relaxing backyard with a beautiful swimming pool and spa, great for entertainment. Remodeled kitchen has tile countertops and backsplash, newer stainless steel appliances, and a breakfast nook. The kitchen cabinets have slide-a-shelf drawers that provide an efficient and ergonomic way to organize and retrieve items. A full bathroom and a bedroom on the ground floor. Upstairs, an East-facing spacious master bedroom with views of Mission Peak. Master bathroom has dual sinks, and a shower with a glass enclosure. Down the hall, two spacious bedrooms: one large bedroom with a sitting area and additional storage spaces. The two hallway bathrooms have new vanities, and accessories. The home offers hardwood flooring downstairs, carpet upstairs, tile flooring in bathrooms, and fresh interior paint. Mission Valley Elementary., Hopkins Junior High, MSJHS (check w/FUSD). The house has easy access to trails, parks, I-680, I-880.
Sold for $2,960,000 on 06/24/25
$2,960,000
1501 Quema Ct, Fremont, CA 94539
4beds
2,073sqft
Residential, Single Family Residence
Built in 1978
0.27 Acres Lot
$2,947,600 Zestimate®
$1,428/sqft
$6,243 Estimated rent
What's special
Zillow last checked: 7 hours ago
Listing updated: June 25, 2025 at 01:52pm
Listed by:
Surinder Gill DRE #01317808 510-209-1481,
Compass
Bought with:
Jessica Talamantes, DRE #02107688
Compass
Source: Bay East AOR,MLS#: 41097552

Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 3
- Full bathrooms: 3
Bathroom
- Features: Shower Over Tub, Tile, Stall Shower, Granite
Kitchen
- Features: Breakfast Bar, Dishwasher, Gas Range/Cooktop, Refrigerator
Heating
- Forced Air
Cooling
- None
Appliances
- Included: Dishwasher, Gas Range, Refrigerator, Dryer, Washer
- Laundry: In Garage
Features
- Breakfast Bar
- Flooring: Hardwood, Tile, Carpet
- Number of fireplaces: 1
- Fireplace features: Family Room
Interior area
- Total structure area: 2,073
- Total interior livable area: 2,073 sqft
Property
Parking
- Total spaces: 2
- Parking features: Attached
- Attached garage spaces: 2
Features
- Levels: Two
- Stories: 2
- Has private pool: Yes
- Pool features: In Ground
- Spa features: Heated
- Fencing: Fenced
- Has view: Yes
- View description: Mountain(s)
Lot
- Size: 0.27 Acres
- Features: Rectangular Lot, Back Yard, Front Yard, Side Yard
Details
- Parcel number: 51370515
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Contemporary
- Property subtype: Residential, Single Family Residence
Materials
- Stucco, Wood Siding
- Roof: Tile
Condition
- Existing
- New construction: No
- Year built: 1978
Utilities & green energy
- Electric: No Solar
- Sewer: Public Sewer
- Water: Public
Community & neighborhood
Location
- Region: Fremont
- Subdivision: Mission
Services availability
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$2,947,600
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$2,947,600