Prevu by reAlpha
BuySellBlogBrowse Listings

523 Union AvenueCampbell, CA 95008

For Sale

$1,525,000

Smart Buyer Rebate $15,250

Don't miss this exceptional opportunity in Campbell -- beautiful new construction walkable to Pruneyard and downtown, excellent schools, parks/trails and ready to move-in. This 4-bed/4.5-bath offers modern elegance and everyday convenience. Large ground floor bedroom with spacious ensuite bathroom. The main level features another ensuite bedroom with walk-in closet plus common living areas and powder room. Premium S/S appliances, custom cabinetry, and porcelain countertops with waterfall peninsula and island and opens into the dining and living areas. The top level offers two additional bedrooms, one with ensuite bath and walk-in closet, plus full bath and laundry. Stunning finishes, premium materials, and energy efficient features. Beautiful wainscoting in dining, wide plank LVP flooring, dual pane Andersen windows, Ring doorbell, mini-split HVAC, owned solar panels, and epoxy finished tandem 2-car garage and level-2 EV charging. Low HOA and maintenance living with all new appliances, modern systems, plus home warranty! Highly regarded Cambrian schools with easy access to Highways 85/17/280 plus public transit. Walk to parks/trails, shops, dining, farmers market. Welcome to the coveted Campbell lifestyle!

Listed by Jina Lee

·

License #02159656

·

Metis Real Estate, Inc.

·

310-985-5462

Last updated September 12, 2026

·

Source: MLSListings #ML82031100

Listing Facts

  • TypeSingle-family
  • NeighborhoodMcGlincey
  • Bedrooms4
  • Days on Prevu245
  • HOA/Maint. Fees$374/month
  • Size1,942 sqft
  • Price per sqft$785

Amenities

  • Private Outdoor Space
  • Pets Allowed
  • Parking

Location

Mortgage Calculator

Listing History

09/05/2026
Price Increased
$1,525,000
06/18/2026
Price Decreased
$1,499,999
06/03/2026
Price Increased
$1,549,999
04/07/2026
Price Decreased
$1,499,000
03/23/2026
Status changed to Active
$1,675,000
03/23/2026
Status changed to Removed from Feed
$1,675,000
02/26/2026
Price Decreased
$1,675,000
01/27/2026
Status changed to Active
$1,725,000
01/24/2026
Status changed to Removed from Feed
$1,725,000
01/24/2026
Status changed to Active
$1,725,000
01/22/2026
Status changed to Removed from Feed
$1,725,000
01/14/2026
Listed by Metis Real Estate, Inc.
$1,725,000
  1. 09/05/2026$1,525,000
    Price Increased
  2. 06/18/2026$1,499,999
    Price Decreased
  3. 06/03/2026$1,549,999
    Price Increased
  4. 04/07/2026$1,499,000
    Price Decreased
  5. 03/23/2026$1,675,000
    Status changed to Active
  6. 03/23/2026$1,675,000
    Status changed to Removed from Feed
  7. 02/26/2026$1,675,000
    Price Decreased
  8. 01/27/2026$1,725,000
    Status changed to Active
  9. 01/24/2026$1,725,000
    Status changed to Removed from Feed
  10. 01/24/2026$1,725,000
    Status changed to Active
  11. 01/22/2026$1,725,000
    Status changed to Removed from Feed
  12. 01/14/2026$1,725,000
    Listed by Metis Real Estate, Inc.

Property Details for 523 Union Avenue

Association

Fees

  • Association Fee: $374.00 Monthly

General

  • Association Name: Union Villas Owners Association
  • Number Of Units In Community: 7

Exterior

Construction

  • New Construction: Yes
  • Roof: Composition, Shingle
  • Stories: 3
  • Year Built: 2026
  • Year Built Details: 6
  • Architectural Style: Contemporary

Features

  • Direction Faces: South
  • Fencing: Fenced Back
  • Patio And Porch Features: Balcony/Patio
  • View: Mountains

Measurements

  • Building Area Total: 1,942
  • Lot Size Acres: 0.02
  • Lot Size Source: Assessor

Financial

Taxes

  • Parcel Number: 412-30-056

Interior

Features

  • Appliances: Cooktop - Electric, Dishwasher, Exhaust Fan, Freezer, Garbage Disposal, Ice Maker, Microwave, Oven Range - Electric, Refrigerator, Dryer, Washer
  • Interior Features: Walk-in Closet

Measurements

  • Living Area: 1,942

Rooms

  • Bathrooms Full: 4
  • Bathrooms Half: 1
  • Bedrooms Total: 4

Other

Features

  • Accessibility Features: Bathroom Features, Wheelchair Access, Wide Halls/Doors (3 Ft+)

Parking

Parking

  • Attached Garage: Yes
  • Garage Spaces: 2
  • Garage: Yes
  • Parking Features: Attached Garage, On Street, Tandem Parking

Schools

Elementary School

  • Elementary School: Bagby Elementary
  • Elementary School District: Cambrian Elementary

High School

  • High School: Branham High
  • High School District: Campbell Union High

Middle or Junior School

  • Middle Or Junior School: Price Charter Middle

Utilities

Equipment

  • Cooling: Multi-Zone
  • Heating: Heat Pump
  • Laundry Features: Upper Floor, Inside
  • Utilities: Solar

Frequently Asked Questions

How many bedrooms does this single-family home have?

There are 4 bedrooms in this single-family home at 523 Union Avenue.

What schools are nearby to 523 Union Avenue?

Nearby schools include the Bagby Elementary, Price Charter Middle, and Branham High.

Does this single-family home have parking?

Yes, there are 2 parking spaces available for 523 Union Avenue.

How does 523 Union Avenue compare to other single-family homes in McGlincey?

This single-family home is listed 25% above the average price for single-family homes in McGlincey and has been on the market for 112 more days than the typical home in this area.

What building or home owners association is the single-family home part of?

This single-family home is part of the Union Villas Owners Association home owners association.

What is the square footage on this single-family home?

According to the MLS, this listing is 1,942 sqft.

523 Union Avenue is a 4-bedroom single-family home for sale in Campbell CA 95008. Listed on Prevu for 245 days at $1,525,000. This includes a recent price increase of $25,001. This home features 1,942 square feet of living space, located in Campbell. The median listing price for single-family homes in this area is $1,125,000. Nearby schools include Bagby Elementary, Price Charter Middle, and Branham High. Additional amenities include private outdoor space, pets allowed, and parking. View other single-family home listings in Campbell.

The data relating to real estate for sale on this display comes in part from the Internet Data Exchange program of the MLSListings™️ MLS system. Real estate listings held by brokerage firms other than Prevu Real Estate are marked with the Internet Data Exchange and detailed information about them includes the names of the listing brokers and listing agents. Based on information from the MLSListings MLS) as of 09/12/2026. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Data Services by Constellation Data Labs. IDX display powered by Prevu Real Estate. Copyright 2026 MLSListings Inc. All rights reserved.

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.