• 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
  • Home
  • 34254 Quartz Ter

34254 Quartz Ter, Fremont, CA 94555

$1,898,000 Approx. USD 4 beds, 3 baths
1,950 sqft

  VIRTUAL TOUR New Listing
Save My Notes
Share
  • Copy Link
  • Facebook
  • Twitter
  • Pinterest
Source MLS Verified
MORE INFO
BrochureBrochure Virtual Tour
The Keaty Team

View Team Members

Photo of Kevin Keaty

The Keaty Team REALTOR® - Sales Associate 714-608-3298 m
714-745-2708 o
Lic#: 01276603
NRDS ID: 187514104
thekeatyteam@bhhscal.com Text Me
Call My Cell
Call My Office
Lic#: 01276603
NRDS ID: 187514104
thekeatyteam@bhhscal.com Tustin Office
18302 Irvine Blvd, Suite 240
Tustin, CA 92780
Phone: 714-832-8800
Fax: 949-565-7700
 Tustin 18302 Irvine Blvd, Suite 240
Tustin, CA 92780
Call Branch Office
Fax: 949-565-7700
Mortgage Calculator
GET PRE-APPROVED
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

Listing Agent


Sirisha Sinha | sirishahomes@gmail.com
Lic#: 01342758
Broker: Courtesy of SKYE Residentials
Phone: 510-757-6196

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
Price: $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

 Days On Market (DOM): 6

 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

DISCLAIMER: There is NO WARRANTY, expressed or implied, for the accuracy of this information or its applicability to your financial situation. Please consult your financial and/or tax advisor. GET PRE-APPROVED The loan's interest rate will depend upon the specific characteristics of the loan transaction and credit profile up to the time of closing.

94555 Area Map

Demographics

Schools

CLICK TO VIEW MAP

Similar Listings

Next Listing
34157 Donahue Terrace VIRTUAL TOUR
34157 Donahue Terrace ,
$2,110,000 Approx. USD 4 beds, 3 baths

List Date: 10/27/2026
 Status: Pending
 MLS #: ML82065425

My Notes Save
Listing courtesy of
34136 Finnigan Ter VIRTUAL TOUR
34136 Finnigan Ter ,
$1,788,888 Approx. USD 3 beds, 3 baths

List Date: 10/1/2026
 Status: Active
 MLS #: 41150044

My Notes Save
Listing courtesy of
34312 Mulberry Terrace VIRTUAL TOUR
34312 Mulberry Terrace ,
$2,100,000 Approx. USD 4 beds, 3 baths

List Date: 10/10/2026
 Status: Active
 MLS #: ML82060654

My Notes Save
Listing courtesy of
4533 Lodovico Ct VIRTUAL TOUR
4533 Lodovico Ct ,
$1,899,000 Approx. USD 4 beds, 2 baths

List Date: 10/7/2026
 Status: Active
 MLS #: 41150165

My Notes Save
Listing courtesy of
34626 Mobile Ct VIRTUAL TOUR
34626 Mobile Ct ,
$1,688,000 Approx. USD 3 beds, 2 baths

List Date: 10/22/2026
 Status: Active
 MLS #: 41151952

My Notes Save
Listing courtesy of
4800 La Habra Street VIRTUAL TOUR
4800 La Habra Street ,
$1,898,000 Approx. USD 5 beds, 3 baths

List Date: 10/22/2026
 Status: Pending
 MLS #: ML82061267

My Notes Save
Listing courtesy of
32808 Oakdale Ct VIRTUAL TOUR
32808 Oakdale Ct ,
$1,775,000 Approx. USD 4 beds, 3 baths

List Date: 9/16/2026
 Status: Active
 MLS #: 41148487

My Notes Save
Listing courtesy of
35515 Farnham Dr VIRTUAL TOUR
35515 Farnham Dr ,
$1,650,000 Approx. USD 3 beds, 2 baths

List Date: 11/6/2024
 Status: Coming Soon
 MLS #: 41078295

My Notes Save
Listing courtesy of
35611 Sheridan Court VIRTUAL TOUR
35611 Sheridan Court ,
$1,699,950 Approx. USD 4 beds, 3 baths

List Date: 7/11/2026
 Status: Pending
 MLS #: ML82052606

My Notes Save
Listing courtesy of
3619 Dryden Rd VIRTUAL TOUR
3619 Dryden Rd ,
$1,650,000 Approx. USD 3 beds, 2 baths

List Date: 10/29/2026
 Status: Active
 MLS #: 41152517

My Notes Save
Listing courtesy of
Previous Listing
  • 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