BuySellBlogBrowse Listings

509 W 175th AvenueBroomfield, CO 80023

For Sale

$679,900

Smart Buyer Rebate $6,799

Welcome to this beautifully maintained corner-lot home in sought-after Palisade Park, North Broomfield. Ideally located near Vista Ridge Golf Course, top-rated schools (8/10 GreatSchools), and just 12 mins to Boulder, 25 mins to Denver, with Costco, King Soopers, Safeway, and major shopping/dining within 10 minutes. This sun-filled home faces a large park with open lawn and playground, offering scenic views from the upstairs loft and main-floor study. Features include a spacious great room, expanded patio, fenced yard, large kitchen island, gas stove, and stainless appliances. Upstairs offers a 5-piece primary suite, guest room with private bath, loft, and laundry room with newer washer/dryer. Enjoy a 3-car tandem garage, unfinished basement, and dual A/C units for energy efficiency. Move-in ready with modern amenities in a quiet, family-friendly neighborhood.

Listed by Shuying Lou

·

License #155065434

·

Good Neighbor LLC

·

720-742-5839

Last updated September 05, 2025

·

Source: REcolorado #4531852

Listing Facts

  • TypeSingle-family
  • NeighborhoodNorth Broomfield
  • Bedrooms4
  • Bathrooms4
  • Days on Prevu59
  • HOA/Maint. Fees$65/month
  • Taxes$8,328/year
  • Size2,808 sqft
  • Price per sqft$242

Amenities

  • Dishwasher
  • Private Outdoor Space
  • Washer/Dryer
  • Air Conditioning
  • Parking

Location

Mortgage Calculator

Listing History

09/05/2025
Price Decreased
$679,900
08/22/2025
Price Decreased
$689,900
08/13/2025
Price Decreased
$694,900
07/09/2025
Listed by Good Neighbor LLC
$699,500

Property Details for 509 W 175th Avenue

Association

Fees

  • Association Fee: $65.00 Monthly

General

  • Association Name: Advance HOA

Exterior

Construction

  • Property Condition: Updated/Remodeled
  • Roof: Composition
  • Structure Type: House
  • Year Built: 2020
  • Common Walls: No Common Walls
  • Construction Materials: Frame
  • Exterior Features: Rain Gutters

Features

  • Fencing: Partial
  • Patio And Porch Features: Covered, Front Porch, Patio
  • Road Frontage Type: Public

Measurements

  • Building Area Total: 3,396
  • Lot Features: Level
  • Lot Size Acres: 0.13
  • Lot Size Area: 5,750
  • Lot Size Square Feet: 5,750
  • Lot Size Units: Square Feet

Financial

Taxes

  • Parcel Number: R8873615
  • Tax Annual Amount: $8,328.00
  • Tax Year: 2024

Interior

Features

  • Appliances: Dishwasher, Disposal, Dryer, Microwave, Oven, Range, Refrigerator, Washer
  • Flooring: Carpet, Wood
  • Interior Features: Five Piece Bath, Granite Counters, Kitchen Island, Walk-In Closet(s)

Measurements

  • Living Area: 2,808

Rooms

  • Basement: Partial, Unfinished
  • Has Basement: Yes
  • Bathrooms Full: 3
  • Bathrooms Half: 1
  • Bathrooms Total Integer: 4
  • Bedrooms Total: 4
  • Main Level Bathrooms: 1

Other

General

  • Exclusions: Seller's personal property and any staging items/furniture

Location

  • Subdivision Name: Palisade Park

Parking

Parking

  • Attached Garage: Yes
  • Garage Spaces: 3
  • Parking Features: Tandem
  • Parking Total: 3

Schools

Elementary School

  • Elementary School: Soaring Heights
  • Elementary School District: St. Vrain Valley RE-1J

High School

  • High School: Erie
  • High School District: St. Vrain Valley RE-1J

Middle or Junior School

  • Middle Or Junior School: Soaring Heights
  • Middle Or Junior School District: St. Vrain Valley RE-1J

Utilities

Equipment

  • Cooling: Central Air
  • Heating: Forced Air
  • Sewer: Public Sewer
  • Water Source: Public

The content relating to real estate for sale in this Web site comes in part from the Internet Data eXchange ("IDX") program of METROLIST, INC., DBA RECOLORADO® Real estate listings held by brokers other than Prevu are marked with the IDX Logo. This information is being provided for the consumers' personal, non-commercial use and may not be used for any other purpose. All information subject to change and should be independently verified.

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.