Discover the epitome of modern comfort in this lovingly cared-for home. Tucked away in a desirable court location, this spacious residence features 4 bedrooms and 2.5 bathrooms with a thoughtful layout designed for both everyday living and entertaining. Step inside to a separate living room and family room highlighted by soaring ceilings, an open staircase, and abundant natural light. The bright interior is enhanced by new laminate flooring throughout the downstairs, creating a warm and modern feel. The large kitchen features new quartz countertops, a new sink and faucet, stainless-steel appliances, a central island, and a pantry. A comfortable breakfast nook opens to the family room, making it the perfect space for casual dining and gatherings. The spacious primary suite offers a relaxing retreat with a walk-in closet and an en-suite bathroom featuring both a shower and soaking tub. Enjoy the convenience of living near a community park, shopping, dining, and Quarry Lakes. Commuters will appreciate easy access to Highways 880 and 84, BART, and nearby bridges. This home offers the ideal balance of comfort, location, and lifestyle.
For sale
$1,440,000
34905 Limestone Ct, Union City, CA 94587
4beds
2,008sqft
Residential, Single Family Residence
Built in 1999
4,102 Square Feet Lot
$1,417,300 Zestimate®
$717/sqft
$-- HOA
What's special
Open staircaseCentral islandNew sink and faucetAbundant natural lightDesirable court locationSpacious primary suiteSoaring ceilings
- 9 days
- 662
- 22
Zillow last checked:
Listing updated:
Listed by:
Aimee Ran Song DRE #01951402 510-990-9999,
Coldwell Banker Realty
Source: Bay East AOR,MLS#: 41145513
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 3
- Full bathrooms: 2
- Partial bathrooms: 1
Rooms
- Room types: 0.5 Bath, Main Entry, 4 Bedrooms, Primary Bedrm Suite - 1, Dining Room, Family Room, Dining Area, Kitchen, Laundry, Living Room, Primary Bathroom, Primary Bedroom
Bathroom
- Features: Shower Over Tub, Updated Baths, Solid Surface, Split Bath, Stall Shower, Tile, Tub, Window
Kitchen
- Features: Counter - Solid Surface, Dishwasher, Gas Range/Cooktop, Kitchen Island, Microwave, Range/Oven Free Standing, Updated Kitchen
Heating
- Forced Air
Cooling
- Central Air
Appliances
- Included: Dishwasher, Gas Range, Microwave, Free-Standing Range, Gas Water Heater
- Laundry: Gas Dryer Hookup, Hookups Only, Laundry Room, Upper Level, Common Area
Features
- Formal Dining Room, Counter - Solid Surface, Updated Kitchen
- Flooring: Laminate, Tile, Carpet
- Windows: Screens, Window Coverings
- Number of fireplaces: 1
- Fireplace features: Family Room, Gas
Interior area
- Total structure area: 2,008
- Total interior livable area: 2,008 sqft
Video & virtual tour
Property
Parking
- Total spaces: 2
- Parking features: Attached, Direct Access, Garage Faces Front, Garage Door Opener
- Garage spaces: 2
Accessibility
- Accessibility features: None
Features
- Levels: Two,One
- Stories: 2
- Patio & porch: Patio
- Pool features: None
- Fencing: Fenced,Wood
Lot
- Size: 4,102 Square Feet
- Features: Level, Back Yard, Front Yard, Side Yard
Details
- Parcel number: 8718103
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Contemporary
- Property subtype: Residential, Single Family Residence
Materials
- Stucco
- Foundation: Slab
- Roof: Tile
Condition
- Existing
- New construction: No
- Year built: 1999
Utilities & green energy
- Electric: No Solar, 220 Volts in Laundry
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Natural Gas Available, Natural Gas Connected, Individual Electric Meter, Individual Gas Meter
Community & HOA
Community
- Security: Fire Alarm, Fire Sprinkler System, Security System Leased, Carbon Monoxide Detector(s), Double Strapped Water Heater, Smoke Detector(s)
- Subdivision: Union City
HOA
- Has HOA: No
Location
- Region: Union City
Financial & listing details
- Price per square foot: $717/sqft
- Tax assessed value: $1,024,028
- Annual tax amount: $14,407
- Price range: $1.4M - $1.4M
- Date on market: 8/19/2026
- Listing agreement: Excl Right
- Listing terms: Cash,Conventional
- Electric utility on property: Yes
Estimated market value
$1,417,300
$1.35M - $1.49M
$4,596/mo
Price history
| Date | Event | Price |
|---|---|---|
| 8/19/2026 | Listed for sale | $1,440,000-3.4%$717/sqft |
Source:  Bay East AOR #41145513 Report a problem | ||
| 8/3/2026 | Listing removed | $1,490,000$742/sqft |
Source: Bay East AOR #41135730 Report a problem | ||
| 5/26/2026 | Listed for sale | $1,490,000+22.1%$742/sqft |
Source: Bay East AOR #41135730 Report a problem | ||
| 11/23/2004 | Sold | $1,220,000+203.5%$608/sqft |
Source: Public Record Report a problem | ||
| 5/2/2000 | Sold | $402,000$200/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $14,407 -1.1% | $1,024,028 +2% |
| 2024 | $14,560 +4.8% | $1,003,950 +4.1% |
| 2023 | $13,900 +1.6% | $964,561 +2% |
| 2022 | $13,679 +2.2% | $945,654 +2% |
| 2021 | $13,378 +2.4% | $927,114 +1% |
| 2020 | $13,066 -3.6% | $917,610 +2% |
| 2019 | $13,557 +3.2% | $899,624 +2% |
| 2018 | $13,133 | $881,991 +2% |
| 2017 | $13,133 +7% | $864,704 +6.1% |
| 2016 | $12,270 +3.3% | $815,000 +3.3% |
| 2015 | $11,881 +8.1% | $789,000 +7.3% |
| 2014 | $10,991 | $735,000 +24.6% |
| 2013 | -- | $590,000 +12.4% |
| 2012 | -- | $525,000 -7.9% |
| 2011 | -- | $570,000 +12.9% |
| 2010 | -- | $505,000 |
| 2009 | -- | -- |
| 2008 | -- | $680,000 -9.2% |
| 2007 | -- | $749,087 +2% |
| 2006 | -- | $734,400 +2% |
| 2005 | -- | $720,000 +65.9% |
| 2004 | -- | $434,030 +1.9% |
| 2003 | -- | $426,076 +2% |
| 2002 | -- | $417,720 +2% |
| 2001 | $5,523 | $409,530 |
Find assessor info on the county website
Monthly payment
Est. payment
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.Climate risks
Neighborhood: 94587
Nearby schools
Schools provided by the listing agent
- District: New Haven (510) 471-1100
Source: Bay East AOR. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Similar homes
- $1,499,8883 bd3 ba1.5k sqft34778 Siward Dr, Fremont, CA 94555For Sale
MLS ID #ML82059145, Jennifer Guarnera. MLSListings Inc - $1,449,9994 bd5 ba1.9k sqft4468 Peralta Blvd, Fremont, CA 94536For Sale
MLS ID #41143430, Prasanna Rangaswamy. Bay East AOR - $1,498,0003 bd2 ba1.5k sqft1029 Bonner Ave, Fremont, CA 94536For Sale
MLS ID #41144863, Joseph Sabeh Jr. Bay East AOR - $1,299,0004 bd4 ba2.2k sqft4467 Maybeck Ter, Fremont, CA 94536For Sale
MLS ID #41138254, Lisa Soltesz. bridgeMLS/CCAR/Bay East AOR
Local buyer's agents are ready to help
