Prevu by reAlpha
BuySellBlogBrowse Listings
34907 Limestone Ct CT, Union City CA 94587
34907 Limestone Ct CT, Union City CA 94587
California>Union City>Downtown Union City

34907 Limestone Ct CTUnion City, CA 94587

For Sale

$1,560,000

Smart Buyer Rebate $15,600

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

·

5109909999

Last updated June 25, 2026

·

Source: CRMLS #41135729

Listing Facts

  • TypeSingle-family
  • NeighborhoodDowntown Union City
  • Bedrooms4
  • Bathrooms2.5
  • Days on Prevu113
  • Size2,146 sqft
  • Price per sqft$727

Amenities

  • Private Outdoor Space
  • Air Conditioning
  • Parking
  • Swimming Pool

Location

Mortgage Calculator

Listing History

05/26/2026
Listed by Coldwell Banker Realty
$1,560,000
  1. 05/26/2026$1,560,000
    Listed by Coldwell Banker Realty

Property Details for 34907 Limestone Ct CT

Exterior

Construction

  • Roof: Tile
  • Stories: 2
  • Year Built: 2000
  • Architectural Style: Contemporary
  • Construction Materials: Brick, Stucco

Features

  • Patio And Porch Features: Patio

Measurements

  • Lot Features: Back Yard, Front Yard
  • Lot Size Acres: 0.13
  • Lot Size Area: 5,975
  • Lot Size Source: Public Records
  • Lot Size Square Feet: 5,975
  • Lot Size Units: Square Feet

Financial

Taxes

  • Parcel Number: 8718104

Interior

Features

  • Appliances: Gas Water Heater
  • Fireplace Features: Family Room, Gas
  • Fireplace: Yes
  • Flooring: Carpet, Laminate, Tile

Measurements

  • Living Area: 2,146

Rooms

  • Bathrooms Full: 2
  • Bathrooms Half: 1
  • Bathrooms Total Integer: 3
  • Bedrooms Total: 4

Other

Location

  • Subdivision Name: UNION CITY

Parking

Parking

  • Attached Garage: Yes
  • Garage Spaces: 2
  • Garage: Yes
  • Parking Features: Attached, Garage, Garage Door Opener
  • Parking Total: 2

Utilities

Equipment

  • Cooling: Central Air
  • Has Cooling: Yes
  • Heating: Forced Air
  • Has Heating: Yes

Frequently Asked Questions

How many bedrooms and bathrooms does this single-family home have?

There are 4 bedrooms and 2.5 bathrooms in this single-family home at 34907 Limestone Ct CT.

Does this single-family home have parking?

Yes, there are 2 parking spaces available for 34907 Limestone Ct CT.

How does 34907 Limestone Ct CT compare to other single-family homes in Downtown Union City?

This single-family home is listed 4% below the average price for single-family homes in Downtown Union City and has been on the market for 26 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,146 sqft.

34907 Limestone Ct CT is a 4-bedroom, 2.5-bath single-family home for sale in Union City CA 94587. On Prevu for 113 days at $1,560,000. This home features 2,146 square feet of living space, located in Downtown Union City. The median listing price for single-family homes in this area is $1,349,000. The home offers private outdoor space, air conditioning, parking, and swimming pool. View other single-family home listings in Union City.

Based on information from California Regional Multiple Listing Service, Inc. 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.

Full MLS Disclaimers

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.