Refine Search
Map
Sort by
34254 Quartz Ter, Fremont
$1,898,888
4 Beds ⋅ 3 Baths ⋅ 41150440 MLS
**This is it - ONLY 4 Bedroom Detached home** in ALL of Forest Park! Loaded with Upgrades! ALL 3 Bathrooms have been **NEWly and FULLY upgraded** with white Quartz Counters, White Shaker Style Cabinets, White Porcelain Tile flooring, New Mirrors, Sink, Fixtures, Shower Doors,**New Interior Paint all through!! Upgraded kitchen with Shaker Style cabinets and white mosaic QUARTZ Counters, FULL Quartz backsplash,Stainless Steel appliances! Designer Main bath with French Tub and Separate Shower - ALL NEW! Soaring ceilings at entry with separate dining area, NEW recessed lights!! *CORNER LOT* home! **NEW siding on once side and NEW Exterior paint!! ALL Appliances, including AC, included! Newer style Dual Pane Windows! Nicely landscaped yard with Citrus and Apple Trees! Within close proximity to Forest park Elementary, Fisher park, shopping, dining and freeways - 880, 84. Award Winning Schools - Forest park Elementary, Thornton Junior High and American High schools! MOVE IN CONDITION!! Close to 880, 84, FaceBook and Google Shuttle Stops!

34254 Quartz Ter, Fremont

Listing courtesy of Sirisha Sinha from SKYE Residentials. 510-757-6196
34480 Alberta Ter, Fremont
$1,598,888
3 Beds ⋅ 3 Baths ⋅ 41150435 MLS
**ONLY ONE of it's kind** on the market now - one of the most desired floor plans in all of Forest Park! Soaring, High ceilings, 2 tiered windows and FULLY UPGRADED with rich, high-end finishes! **BRAND NEW Luxury Vinyl Plank Flooring ALL THROUGH the stairs and second level!! *Oversized porcelain tile counters downstairs!**BRAND NEW European Style Spa Primary bath with flat panel cabinetry, expensive quartz counters, oversized porcelain tiles, rain shower! **BRAND NEW interior paint all through the home with NEWly painted trims, and NEW hardware. **UPGRADED Top Tier Quartz Counters with custom edging in kitchen and baths, **Air Conditioning, **SOLAR panels (paid off)and EV charger Included! **NEW Chandelier, **NEW recessed lighting, HUGE back yard lovingly crafted with slate flooring, NEW mulch, Rose Trees, Tall Cypresses for added privacy! Close proximity to Forest Park Elementary, around the corner from Fisher Park. Convenient Commute location with easy access to Dumbarton Bridge, 880, 84 and maps to Award Winning Schools - Forest Park Elementary, Thornton Junior High and American High Schools!

34480 Alberta Ter, Fremont

Listing courtesy of Sirisha Sinha from SKYE Residentials. 510-757-6196

Bay East © 2026. CCAR © 2026. BridgeMLS © 2026. Information Deemed Reliable But Not Guaranteed. This information is being provided by the Bay East MLS, or CCAR MLS, or bridgeMLS. The listings presented here may or may not be listed by the Broker/Agent operating this website. This information is intended for the personal use of consumers and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data last updated on:

How much is your home worth?

Get instant property value now!