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.
Listed by Aimee Ran Song
·
License #01951402
·
Coldwell Banker Realty
·
aimeesongrealtor@gmail.com
Last updated June 02, 2026
·
Source: bridgeMLS #41135730
Listing Facts
TypeSingle-family
NeighborhoodDowntown Union City
Bedrooms4
Bathrooms3
Days on Prevu21
Size2,008 sqft
Price per sqft$742
Amenities
Dishwasher
Private Outdoor Space
Air Conditioning
Parking
Swimming Pool
Location
Mortgage Calculator
Listing History
05/26/2026
Listed by Coldwell Banker Realty
$1,490,000
Property Details for 34905 Limestone Ct
Exterior
Construction
Stories: 2
Window Features: Screens, Window Coverings
Year Built: 1999
Architectural Style: Contemporary
Construction Materials: Stucco
Exterior Features: Back Yard, Front Yard, Side Yard
Features
Direction Faces: North
Fencing: Fenced, Wood
Patio And Porch Features: Patio
Measurements
Building Area Total: 2,008
Lot Features: Level, Back Yard
Lot Size Acres: 0.09
Lot Size Area: 0
Lot Size Square Feet: 4,102
Lot Size Units: Acres
Financial
Taxes
Parcel Number: 8718103
Interior
Features
Appliances: Dishwasher, Gas Range, Microwave, Free-Standing Range, Gas Water Heater
Parking Features: Attached, Int Access From Garage, Garage Faces Front, Garage Door Opener
Utilities
Equipment
Cooling: Central Air
Electric: No Solar
Heating: Forced Air
Has Heating: Yes
Laundry Features: 220 Volt Outlet, Gas Dryer Hookup, Hookups Only, Laundry Room, Upper Level
Sewer: Public Sewer
Utilities: All Utilities, Natural Gas Available, Natural Gas Connected, Individual Electric Meter, Individual Gas Meter
Water Source: Public
Frequently Asked Questions
How many bedrooms and bathrooms does this single-family home have?
There are 4 bedrooms and 3 bathrooms in this single-family home at 34905 Limestone Ct.
Does this single-family home have parking?
Yes, there are 2 parking spaces available for 34905 Limestone Ct.
How does 34905 Limestone Ct compare to other single-family homes in Downtown Union City?
This single-family home is listed 12% above the average price for single-family homes in Downtown Union City and has been on the market for 8 more days than the typical home in this area.
What is the square footage on this single-family home?
According to the MLS, this listing is 2,008 sqft.
34905 Limestone Ct is a 4-bedroom, 3-bath single-family home for sale in Union City CA 94587. Listed on Prevu for 21 days at $1,490,000. This residence features 2,008 square feet of living space, located in Downtown Union City. The median listing price for single-family homes in this area is $1,073,500. Additional amenities include private outdoor space, dishwasher, air conditioning, parking, and swimming pool. Browse more single-family home listings in Union City.
Based on information from bridgeMLS and/or other sources. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by Prevu or the MLS. Information is provided exclusively for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing.
Rebate estimate is indicative only and based on listing price and estimated buyer's agent commission paid by owner, if applicable. Final rebates are subject to Terms of Use and may vary due to final negotiated transaction terms.
