Home | Alameda County | Fremont | 94555 | 33267 Lake Pyramid St
MLS: BE41047112 | Status: Sold | Price: $1,400,001
Beds/Baths: 4 / 2 /1
Property Type: Residential
| Beds | Baths | Sq Ft | Sq Ft Lot | Yr Built |
|---|---|---|---|---|
| 4 | 2 /1 | 1,651 | 3,440 | 1969 |
This exceptional North-facing residence has undergone extensive upgrades, showcasing a commitment to quality and modern living. Experience culinary delight in the brand-new kitchen featuring contemporary cabinets and top-of-the-line stainless appliances. Cooking becomes a joy in this stylish and functional space. Enjoy the convenience of a new hot water heater, fresh interior and exterior paint, and a cutting-edge two-stage quiet Bryant Gas Furnace. Stay cool with a 17-seer Bryant AC and effortlessly control your home environment with the Nest Thermostat. Step into the low-maintenance backyard, an oasis of tranquility with lush turf – perfect for entertaining or relaxing in absolute privacy. The front yard is beautifully landscaped, complete with a drip system for easy maintenance. This home is conveniently located near the highly-rated Warwick Elementary School, ensuring an excellent education for your family. Explore the nearby Sylvester Harvey Park with tennis courts, baseball diamonds, and a walking track. Enjoy the outdoors with access to the Alameda Creek Trail and Coyote Hills Regional Park. Benefit from the proximity to major freeways for easy commuting. Nearby supermarkets include Lucky’s, Ranch 99, Dulhan Indian Store, Namaste Indian, and Indian Cash and Carry.
| Field | Value |
|---|---|
| MLS # | BE41047112 |
| MLS Source | Bay East |
| Feature | Details |
|---|---|
| Bathrooms | Primary - Shower(s) over Tub(s), Primary - Solid Surface, Primary - Updated Bath(s), Updated Bath(s) |
| Kitchen | Countertop - Stone, Hookups - Ice Maker, Updated |
| Appliances | Dishwasher, Garbage Disposal, Oven Range - Built-In, Oven Range - Gas, Refrigerator, Dryer, Washer |
| Dining Room | Dining Area |
| Fireplace | None |
| Flooring | Carpet - Wall to Wall, Laminate, Linoleum |
| Laundry | 220 Volt Outlet, In Garage |
| Cooling | Ceiling Fan, Central -1 Zone |
| Heating | Forced Air |
| Feature | Details |
|---|---|
| Roof | Tile |
| Foundation | Slab |
| Pool | None, Pool - No |
| Style | Contemporary |
| Feature | Details |
|---|---|
| Garage/Parking | Attached Garage, Garage, Gate/Door Opener, Garage: 2 Car(s) |
| Elementary District | Fremont Unified |
| High School District | Fremont Unified |
| Sewer | Public Sewer |
| Water | Public |
| Listing Agent | Co-Listing Agent |
|---|---|
| Aimee Ran Song | Robert Lewis |
| Coldwell Banker Realty | Coldwell Banker Realty |
| License #: 01951402 | License #: 00633105 |
| Phone: (510) 990-9999 | Phone: (510) 502-8893 |
School data provided by GreatSchools.org
©2026 Bay East. 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 Bay East.
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 April 23, 2025. For the most current information, please contact Aimee Ran Song, (510) 990-9999.