---
listing_id: ML81953130
status: Closed
price: 1550000
beds: 3
baths_full: 2
baths_half: 0
sqft_living: 1390
sqft_lot: 5858
lot_acres: 
year_built: 1971
property_type: Residential
property_subtype: Single Family Residence
address: "34842 Warwick Ct"
city: Fremont
state: CA
zip: 94555
county: "Alameda County"
lat: 37.577445
lng: -122.028471
days_on_market: 824
hoa_fee: 
hoa_frequency: 
garage_spaces: 2
list_agent: "Raul Profeta, Jr."
list_office: "Sharp Point Realty Group"
list_agent_phone: "(408) 705-1965"
list_agent_license: 01277931
mls_source: MLSL
modified: 2026-02-01
transaction_type: recentlySold
---

Home | Alameda County | Fremont | 94555 | 34842 Warwick Ct

34842 Warwick Ct, Fremont, CA 94555

MLS: ML81953130 | Status: Sold | Price: $1,550,000
Beds/Baths: 3 / 2
Property Type: Residential

Quick Facts

Beds Baths Sq Ft Sq Ft Lot Yr Built
3 2 1,390 5,858 1971

Remarks

Location, location, location! Take a look at this charming single-story home in the desirable Northgate neighborhood. This well-maintained residence offers 3 bedrooms, 2 bathrooms, and a convenient 2-car attached garage, providing both comfort and convenience. The backyard is a true entertainer's delight, boasting a pool and space, perfect for hosting parties with friends and family. Whether it's setting up a cozy evening sit-in or for outdoor activities, this area provides endless possibilities for enjoyment. Inside, the updated kitchen features recessed lightings, elegant countertops and stainless-steel appliances, effortlessly blending this modern style with practicality. With convenient access to parks, shopping, and major routes including the Dumbarton Bridge and 880 freeway, this location offers a perfect balance of convenience and peace of mind. Surrounded by top rated Schools, restaurants, hiking/biking trails and recreational parks. Only minutes away from Quarry Lake, Lake Elizabeth and Coyote Hills. Run, don't walk, must see this home now! All information provided is deemed reliable, but is not guaranteed and should be independently verified.

MLS Listing Information

Field Value
MLS # ML81953130
MLS Source MLSListings, Inc.

Features

Interior Features

Feature Details
Dining Room No Formal Dining Room
Family Room Separate Family Room
Fireplace Wood Burning
Cooling None
Heating Central Forced Air

Exterior Features

Feature Details
Roof Shingle
Foundation Reinforced Concrete

Parking, School, and Other Information

Feature Details
Garage/Parking Attached Garage, Garage: 2 Car(s)
Elementary District Fremont Unified
High School District Fremont Unified
Sewer Public Sewer
Water Public
Zoning R1

Contact Information

Raul Profeta, Jr.
Sharp Point Realty Group
License #: 01277931
Phone: (408) 705-1965

Disclosures

©2026 MLSListings Inc. All rights reserved. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Information provided is for personal, non-commercial use by the viewer and may not be redistributed without explicit authorization from MLSListings Inc.

Presently MLSListings.com displays Active, Contingent, Pending, and Recently Sold listings. Recently Sold listings are properties which were sold within the last three years. After that period listings are no longer displayed in MLSListings.com. Pending listings are properties under contract and no longer available for sale. Contingent listings are properties where there is an accepted offer, and seller may be seeking back-up offers. Active listings are available for sale.

This listing information is up-to-date as of February 01, 2026. For the most current information, please contact Raul Profeta, Jr., (408) 705-1965.