Sign up to get new listings emailed daily! JOIN SIGN IN
Theresa Carroll, DRE#01890268, REALTOR®
(720) 530-5098

34905 Limestone Ct, Union City, CA 94587

$1,490,000
  • 34905 Limestone Ct, Union City, CA 94587 Main Photo

46 Total Photos [Click to View All]

Active
BEDS4 BATHS2 full 1 partial SQUARE FEET2,008 MLS#41135730
STATUSActive PROPERTY TYPEResidential - Single Family SUBDIVISIONUNION CITY

Listing Courtesy of: Coldwell Banker Realty
Agency Phone: 510-608-7600
Associate Name: Aimee Ran Song
IDX logo


Listing Shown by: Farrell Smyth, Inc.
Associate Name: Theresa Carroll, DRE#01890268, REALTOR®


Property Description

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.

34905 Limestone Ct | MLS# 41135730

This single family home located at 34905 Limestone Ct, Union City, CA 94587 is currently listed for sale with an asking price of $1,490,000. This property was built in 1999 and has 4 bedrooms and 2 full and 1 partial baths with 2008 sq. ft. Limestone Ct is located in the UNION CITY subdivision. Search UNION CITY real estate on theresacarroll.farrellsmyth.com today.

Property Features

Property Type: Residential - Single Family
Cooling: CentralAir
Garage: 2 car attached
Heating: ForcedAir
Home Style: Contemporary
Lot Size: 0.09 Acres
Roof Type: Tile
Stories: 2.0
Year Built: 1999

Feature Descriptions

Accessibility: None
Appliances: GasWaterHeater
Days on Site: 8
Exterior: Brick, Stucco
Fireplace: FamilyRoom, Gas
Flooring: Carpet, Laminate, Tile
Lot: BackYard, FrontYard, StreetLevel, Yard
Parcel#: 8718103
Parking: Garage
Parking Notes: Garage
Patio/Porch: Patio
Window: Screens

Listed By / Shown By

Listed By

Agency Name: Coldwell Banker Realty
Agent Name: Aimee Ran Song
Agency Phone: 510-608-7600

agent picture

Shown By

Agent Name: Theresa Carroll, DRE#01890268, REALTOR®
Agent Phone: (720) 530-5098
Agency Title: Farrell Smyth, Inc.

IDX logo

Estimate Your Payment

Estimated Payment

$ 3,750.68 per month $3,316.09 Principal & Interest $0.00 Property Tax (data not provided by mls) $434.58 Homeowner's Insurance

Change Payment Information

%
years/fixed
yearly
yearly (est.)
(Payments are an estimate and may vary by lender)
Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information on this site was last updated 06/04/2026. The listing information on this page last changed on 06/04/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Delta Media Group MLS (last updated Thu 06/04/2026 12:00:21 AM EST) or CRMLS (last updated Wed 06/03/2026 11:49:32 PM EST). Real estate listings held by brokerage firms other than Farrell Smyth, Inc. may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.
Privacy Policy / DMCA Notice / ADA Accessibility

Login to My Homefinder

Pixel