Prevu by reAlpha
BuySellBlogBrowse Listings

523 Union AvenueCampbell, CA 95008

For Sale

$1,579,000

Smart Buyer Rebate $15,790

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

·

Metis Real Estate, Inc.

·

3109855462

Last updated October 26, 2026

·

Source: MLSL #ML82031100

Listing Facts

  • TypeSingle-family
  • NeighborhoodMcGlincey
  • Bedrooms4
  • Bathrooms4.5
  • Days on Prevu290
  • HOA/Maint. Fees$374/month
  • Size1,942 sqft
  • Price per sqft$813

Amenities

  • Dishwasher
  • Private Outdoor Space
  • Washer/Dryer

Location

Mortgage Calculator

Listing History

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

Property Details for 523 Union Avenue

Association

Amenities

  • Association Amenities: Electricity

Fees

  • Association Fee: $374.00 Monthly
  • Association Fee Includes: Insurance, Maintenance Grounds

General

  • Association Name: Union Villas Owners Association

Exterior

Construction

  • New Construction: Yes
  • Property Condition: New Construction
  • Roof: Composition, Shingle
  • Stories: 3
  • Stories Total: 3
  • Year Built: 2026
  • Architectural Style: Contemporary
  • Construction Materials: Stucco
  • Exterior Features: Balcony

Features

  • Direction Faces: South
  • Fencing: Back Yard
  • Patio And Porch Features: Patio
  • View: Mountain(s)

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: Dryer, Disposal, Dishwasher, Exhaust Fan, Freezer, Ice Maker, Microwave, Refrigerator, Electric Cooktop, Electric Range, Washer
  • Interior Features: Master Downstairs, Walk-In Closet(s), Double Vanity, Kitchen Island

Measurements

  • Living Area: 1,942

Rooms

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

Other

Features

  • Accessibility Features: Accessible Entrance, Accessible Hallway(s)

Location

  • City Region: Campbell
  • Subdivision Name: Union Villas

Parking

Parking

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

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: Zoned
  • Has Cooling: Yes
  • Heating: Heat Pump
  • Has Heating: Yes
  • Laundry Features: Inside, Upper Level

Frequently Asked Questions

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

There are 4 bedrooms and 4.5 bathrooms 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 29% above the average price for single-family homes in McGlincey and has been on the market for 61 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, 4.5-bath single-family home for sale in CAMPBELL CA 95008. On Prevu for 290 days at $1,579,000. This includes a recent price increase of $54,000. 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,127,000. Nearby schools include Bagby Elementary, Price Charter Middle, and Branham High. Additional amenities include private outdoor space, dishwasher, and washer/dryer. Browse more 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 10/26/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.