34905 Limestone Ct

$1,490,000 2,008 SQ FT
$742 SQ/FT

34905 Limestone Ct

@ Serpentine Dr - Union City

Map direct
  • 4 Bed
  • 2.5 (2/1) Bath
  • 2 Park
  • 2,008 sqft
  • Union City
  • Payment calculator
DTCH
  • Favorite
  • Hide
Message Brian Byers
  • Sat May 30, 1:30 pm - 4:30 pm

    Discover the epitome of modern comfort in this lovingly cared-for home, offered for the first time ever on the market.

  • Sun May 31, 1:30 pm - 4:30 pm

    Discover the epitome of modern comfort in this lovingly cared-for home, offered for the first time ever on the market.

Discover the epitome of modern comfort in this lovingly cared-for home, offered for the first time ever on the market. 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.

Current Status
New
Original Price
$1,490,000
List Price
$1,490,000
On Market Date
May 22, 2026
Property Type
Detached
D/N/S
Union City
Zip Code
94587
MLS ID
41135730
APN
8718103
Year Built
1999
Stories in Building
2
Possession
Close Of Escrow
Data Source
MAXEBRDI
Origin MLS System
BAY EAST
Bed
4
Bath
2.5 (2/1)
Parking
2
Attached, Int Access From Garage, Garage Faces Front, Garage Door Opener
SQ FT
2,008
SQ FT Source
Public Records
Lot SQ FT
4,102.0
Lot Acres
0.09 Acres
Pool Info
None
Kitchen
Dishwasher, Gas Range, Microwave, Free-Standing Range, Gas Water Heater, Counter - Solid Surface, Gas Range/Cooktop, Kitchen Island, Range/Oven Free Standing, Updated Kitchen
Cooling
Central Air
Disclosures
Nat Hazard Disclosure, Disclosure Package Avail
Entry Level
Exterior Details
Back Yard, Front Yard, Side Yard
Flooring
Laminate, Tile, Carpet
Foundation
Fire Place
Family Room, Gas
Heating
Forced Air
Laundry
220 Volt Outlet, Gas Dryer Hookup, Hookups Only, Laundry Room, Upper Level
Upper Level
4 Bedrooms, Primary Bedrm Suite - 1, Laundry Facility
Main Level
0.5 Bath, Main Entry
Possession
Close Of Escrow
Architectural Style
Contemporary
Non-Master Bathroom Includes
Shower Over Tub, Updated Baths, Double Vanity
Construction Status
Existing
Additional Miscellaneous Features
Back Yard, Front Yard, Side Yard
Location
Level, Back Yard
Roof
Tile
Water and Sewer
Public
Fee
Unavailable

MLS and other Information regarding properties for sale as shown in Theo have been obtained from various sources such as sellers, public records, agents and other third parties. This information may relate to the condition of the property, permitted or unpermitted uses, zoning, square footage, lot size/acreage or other matters affecting value or desirability. Unless otherwise indicated in writing, neither brokers, agents nor Theo have verified, or will verify, such information. If any such information is important to buyer in determining whether to buy, the price to pay or intended use of the property, buyer is urged to conduct their own investigation with qualified professionals, satisfy themselves with respect to that information, and to rely solely on the results of that investigation.

School data provided by GreatSchools. School service boundaries are intended to be used as reference only. To verify enrollment eligibility for a property, contact the school directly.

Listings © 2026 Paragon MLS

Copyright © 2026 Theo Inc. All Rights Reserved