Agent profile image in chat bubble
Agent profile image in chat header

Jenn Smart

| v3 pdp, v2 chat

Agent profile image in message

By proceeding you are providing with your express written consent to send you marketing and promotional communications via calls or prerecorded messages dialed by a natural person or by using an artificial or automated telephone dialing system.

By checking the box, you consent to receive marketing text messages. If checked, you consent to receiving texts including marketing and promotional communications, from . Messages and data rates may apply. Message frequency varies. To opt out of text messages, reply STOP. Your consent is not required as a condition of any purchase. By continuing, you also agree to our Terms & Conditions and Privacy Policy.
main property photo 0
main property photo 1
main property photo 2
main property photo 3
main property photo 4
main property photo 5
main property photo 6
main property photo 7
main property photo 8
main property photo 9
main property photo 10
main property photo 11
main property photo 12
main property photo 13
main property photo 14
main property photo 15
main property photo 16
main property photo 17
main property photo 18
main property photo 19
main property photo 20
main property photo 21
main property photo 22
main property photo 23
main property photo 24
main property photo 25
main property photo 26
main property photo 27
main property photo 28
main property photo 29
main property photo 30
main property photo 31
main property photo 32
main property photo 33
main property photo 34
main property photo 35
main property photo 36
main property photo 37
main property photo 38
main property photo 39
main property photo 40
main property photo 41
main property photo 42
main property photo 43
main property photo 44
main property photo 45
main property photo 46
main property photo 47
main property photo 48
main property photo 49
main property photo 50
main property photo 51
main property photo 52
View All (53)
property photo 1
property photo 2
property photo 3
34254 Quartz Ter , Fremont, CA 94555
$1,898,000
Est. Payment: $4,217.78/mo
4 Bed
3 Bath
1950 Sqft
0.09 Acres
Status: active | Days on site: 7
Get Pre-Qualified
CCBE-SSQ02 - CCBE-206518617
By proceeding you are providing Jenn Smart with your express written consent to send you marketing and promotional communications via calls or prerecorded messages dialed by a natural person or by using an artificial or automated telephone dialing system.

By checking the box, you consent to receive marketing text messages. If checked, you consent to receiving texts including marketing and promotional communications, from Jenn Smart. Messages and data rates may apply. Message frequency varies. To opt out of text messages, reply STOP. Your consent is not required as a condition of any purchase. By continuing, you also agree to our Terms & Conditions and Privacy Policy.
Agent profile image
Jenn Smart
View agent profile
Email
Call

House Description

**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!
Show more

Highlights

Listed by Sirisha Sinha , 510-757-6196 SKYE Residentials , 510-757-6196. CRMLS/Multi-Regional MLS mls logo

Property Type

Residential
Lot/Acreage
0.09

HOA Fee

38 Monthly

Year Built

1989

County

Alameda

 Neighborhood

Forest Park

Listing ID

41153181

Questions about this listing?

Contact Agent

Interior Features

Bedrooms and Bathrooms
  • ▪ Bedrooms:4
  • ▪ Bathrooms:3
  • ▪ Full Bathrooms:2
  • ▪ 1/2 Bathrooms:1
Air Cond:Central Air
Fireplaces:Family Room,Wood Burning
Floor:Laminate,Tile
Other:
  • ▪ Additional:Eat-in Kitchen

Exterior Features

Lot:Back Yard,Front Yard,Garden,Yard,No Land Lease
Garage Capacity:2
Roof:Shingle
Others:
  • ▪ Additional:Wood Siding
Parking Features:Garage,Garage Door Opener

Open House

Upcoming Open Houses
Sunday 3:00 pm - 5:00 pm Nov 15
Principal Interest
$4,218
Taxes
$1,210
HOA
$38

Home Price

$1,898,000

Loan Details

30 yrs
0%

Down Payment

20%
$379,600
All calculations are estimates and provided by Blueroof360. Today’s Rates provided by Blueroof360. Information and interactive calculators are made available to you only as self-help tools for your independent use and are not intended to provide investment or tax advice. We cannot and do not guarantee their applicability or accuracy in regards to your individual circumstances. All examples are hypothetical and are for illustrative purposes. We encourage you to seek personalized advice from qualified professionals regarding all personal finance issues.
Monthly Price:
$4,217.78

Principal

Taxes

HOA

Principal Taxes HOA Total
Monthly $4,217.78 $1,209.98 $38.00 $5,465.75
Yearly $50,613.33 $14,519.70 $456.00 $65,589.03
Total $1,518,400.00 $435,591.00 $13,680.00 $1,967,671.00
Lender profile image
So-Crates Johnson
Dust, Wind, Dude
Email
Call
Visit
GET PRE-QUALIFIED

Never Miss a Property

Be the first to know when a property hits the market.

Current Listings

Last 30 Days
N/A
Nov 2026

Average Price

All Price Ranges
N/A
Nov 2026

Average Days on Market

All Price Ranges
N/A
Nov 2026
Market insight data is pulled from the same city as the listing being viewed (Fremont, CA).

The schools listed are within a 2-mile radius of the property; however, attendance is not guaranteed. Please contact the local school district to confirm zoning and enrollment options.

Based on information from California Regional Multiple Listing Service, Inc. This information is for your personal, non-commercial use and may not be used for any purpose other than to identify prospective properties you may be interested in purchasing. Display of MLS data is usually deemed reliable but is NOT guaranteed accurate by the MLS. Buyers are responsible for verifying the accuracy of all information and should investigate the data themselves or retain appropriate professionals. Information from sources other than the Listing Agent may have been included in the MLS data. Unless otherwise specified in writing, Broker/Agent has not and will not verify any information obtained from other sources. The Broker/Agent providing the information contained herein may or may not have been the Listing and/or Selling Agent. All properties are subject to prior sale, change or withdrawal.

IDX service by Blueroof 360

Data last updated: 2026-11-14T23:39:01.000Z

© 2026 CRMLS/Multi-Regional MLS

MLS Logo - CRMLS/Multi-Regional MLS