• Facebook
  • Twitter
  • Instagram
  • LinkedIn
  • Blog
Phone714-745-2708
Login or sign up for new accountLogin / Register
Email Our TeamEmail Us
  • Search Listings
    • Residential
    • Lease
    • Commercial
  • Previous Sales
  •   Local
    • Fullerton
    • Tustin
    • Yorba Linda
    • Santa Ana
    • Orange Park Acres
    • North Tustin
    • Orange
    • Anaheim
  •   Buyers
    • Ways To Take Title In California
    • Vesting
    • Renting vs. buying
    • Why work with a real estate agent
    • How much can I afford?
    • Finding your home
    • Submitting an offer
    • Moving
    • After the offer is accepted
    • What do you want in a home?
  •     Sellers
    • Anaheim FAQ
    • New Sellers and Buyers Guide
    • Why work with a real estate agent
    • Getting your home ready for sale
    • Pricing your home to sell
    • Negotiating the sale
    • Moving
    • Transaction management
  •     Services
    • Onepoint
    • Home Financing
    • Insurance
    • Escrow
    • Title
    • Home Warranty
    • PRESALE/STAGING
    • Relocation
  •     About
    • Why Choose The Keaty Team
    • Globally Respected
    • About Us
    • The Charitable Foundation
    • Diversity & Inclusion
    • Doyle
    • Agents Only
  • Our Team
  •     My Links
    • Seniors
  • Blog
Menu
Berkshire Hathaway HomeServices California Properties Berkshire Hathaway HomeServices California Properties
Any Price
-
  • 0
  • $100,000+
  • $250,000+
  • $500,000+
  • $750,000+
  • $1,000,000+
0+ Beds
  • 0+
  • 1+
  • 2+
  • 3+
  • 4+
  • 5+
0+ Baths
  • 0+
  • 1+
  • 2+
  • 3+
  • 4+
  • 5+
Property Type
Other
34254 Quartz Ter Fremont, CA 94555
$1,898,000 4 beds, 3 baths
1, 950 sqft
Save My Notes
 
The Keaty Team

View Team Members

Interested in This Property? Your message will be sent to Kevin.
By submitting your information, you consent to be contacted by email, SMS message, and/or phone call. You may opt out at any time per our Privacy Policy.
  • Save
  • My Notes

Agent Remarks

**This is it - ONLY 4 Bedroom Detached home** in ALL of Forest Park priced well under $2Million!! North-West facing door! SPECIAL FINANCING, *LOW RATES* available for qualified buyers! 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!

Listing Details

Property type: Single Family Residence (Single Family)
Status: Active
MLS# 41153181
List price is $1,898,000
HOA Fee is $38.00
Beds: 4
Baths: 3 (2 full) (1 half)
Family Room,Wood Burning fireplaces
Built in 1989
1,950 sqft
2 stories
0.09 acres
Lot size: 0.0926
Subdivision: FOREST PARK
County: Alameda
Property style: Craftsman
Construction: Wood Siding
Interior features: Eat-in Kitchen
Parking description: Garage,Garage Door Opener
Lot description: Back Yard,Front Yard,Garden,Yard
Heating/cooling: Central Air

Last Updated: 11/6/2026

 Find more Fremont homes and real estate

 Find more homes in 94555 zip code

 Find more homes in the FOREST PARK subdivision

The style of this listing is Craftsman.
Find more Craftsman style homes for sale

Lat/Long: 37.563804, -122.054025.
Find nearby listings


Listing Agent: Sirisha Sinha
Lic#: 01276603
Office Name: Tustin

Area Map

CLICK TO VIEW MAP

Nearby Schools

No schools were found in the area

Area Overview

Total population of , which has changed by % since 1990.
The median age of the population is , while the median age of dwellings is .
Out of households, are families.

Community Characteristics:

Occupancy Type

White/Blue Collar Jobs

Population by Gender

Hispanic/Non-Hispanic Population

Compared to National:

  • Search
    • My Previous Sales
    • Residential
    • Lease
    • Open Houses
  • Buyers
    • Ways To Take Title In California
    • Vesting
    • Renting vs. buying
    • Why work with a real estate agent
    • How much can I afford?
    • Finding your home
    • Submitting an offer
    • Moving
    • After the offer is accepted
    • What do you want in a home?
  • Sellers
    • Anaheim FAQ
    • New Sellers and Buyers Guide
    • Why work with a real estate agent
    • Getting your home ready for sale
    • Pricing your home to sell
    • Negotiating the sale
    • Moving
    • Transaction management
  • Services
    • Prosperity Home Mortgage
    • HomeServices Relocation
    • HomeServices Insurance Agency
    • Pickford Escrow
    • California Title Company
    • American Home Shield
    • PINNACLE
    • myNHD
  • About
    • Why Choose The Keaty Team
  • My Links
    • Seniors
  • Blog
  • Our Team
The Keaty Team
Lic#: 01276603

View Team Members


Tustin Office
18302 Irvine Blvd, Suite 240
Tustin, CA 92780
hsoa-logo
  • Facebook
  • Twitter
  • Instagram
  • LinkedIn
  • Blog

© 2026 BHH Affiliates, LLC. An independently operated subsidiary of HomeServices of America, Inc., a Berkshire Hathaway affiliate, and a franchisee of BHH Affiliates, LLC. Berkshire Hathaway HomeServices and the Berkshire Hathaway HomeServices symbol are registered service marks of Columbia Insurance Company, a Berkshire Hathaway affiliate. Equal Housing Opportunity.
Lic#: 01317331

Photo of Equal Housing Opportunity Privacy Policy - California Privacy Notice - Terms of Use - Accessibility
Do Not Sell My Personal Information DMCA.com Protection Status