Recently Viewed Properties
See This Home
Save This Listing
Close

View All Photos

$675,000

  • For Sale
  • Under Contract
  • Single Family
  • 4 Beds
  • 3 Full Baths
  • 1 Partial Bath
  • 4,668 Sq. Ft.
  • 4 Car Garage
See This Home
Save This Home
See This Home
Save This Home
Check out the new price! Don't miss out on the opportunity to live in this amazing neighborhood! Step inside this expansive 4-bedroom, 4-bath home that perfectly blends comfort, style, and functionality. The bright, open main floor welcomes you with soaring ceilings, a seamless flow between the living, dining, and kitchen areas, and an inviting family room featuring a custom tile surround gas fireplace-creating a warm, elegant focal point just off the kitchen. Enjoy BBQ and family time in the backyard with extended patio and covered pergola. A dedicated main-floor office provides the perfect workspace or quiet retreat. With 4 bedrooms upstairs there are two bedrooms that share a convenient Jack-and-Jill bath, while a third bedroom offers its own private ensuite. The impressive primary suite is a true retreat-featuring a spacious layout, butler's cabinet, and a luxurious spa-inspired bathroom designed for relaxation. All new carpet! A massive 4-car garage delivers exceptional storage and parking options for all your vehicles, gear, and hobbies. This home's thoughtful design, abundant space, and upscale finishes make it a standout opportunity for those seeking room to live, work, and play.Located in the desirable Wyndham Hills community, homeowners enjoy access to neighborhood amenities including a pool, playground, walking paths, and beautifully maintained common areas-perfect for connecting with neighbors and enjoying Colorado's sunny outdoors.

Full Property Details for 2623 Steeple Rock Dr

General

  • Price: $675,000
  • HOA FEE: $70/month
  • Taxes: $7,033 (2024)
  • Status: Under Contract
  • Type: Single Family
  • Source: IRES
  • MLS ID: 1045932
  • Updated: 12/23/2025
  • Added to Site: 94 day(s) ago

Interior

  • Interior Features: Eat-In Kitchen, Separate Dining Room, Cathedral Ceiling(s), Open Floorplan, Walk-In Closet(s), Washer/Dryer Hookup, Jack and Jill Bath, Kitchen Island, Two Primary Suites
  • Fireplace: Yes
  • Fireplace(s): Gas, Family Room
  • Appliances: Electric Range, Dishwasher, Refrigerator, Microwave, Disposal, Fire Alarm
  • Flooring: Wood

Rooms

Bathrooms

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

Bedrooms

  • Total Bedrooms: 4

Exterior

  • Exterior Features: Sprinkler System, Oversized Garage, Tandem Garage
  • Porch/Patio/Deck: Patio

Parking

  • Garage: Yes
  • Attached garage: Yes
  • Garage Spaces: 4
  • Parking Features: Garage Door Opener
  • Garage Description: Attached

Location

  • Area: Frederick
  • County: Weld
  • Subdivision: Wyndham Hill Fg#1 Final

School Information

  • School District: ST Vrain Dist RE 1J
  • Elementary School: Grand View
  • Middle School: Erie
  • High School: Erie

Community

  • Association: Yes
  • Assoc. Name: Wyndham Hill
  • Assoc. Fees Include: Common Amenities, Management

Heating & Cooling

  • Cooling Type: Central Air, Ceiling Fan(s)
  • Heating Type: Forced Air

Utilities

  • Gas: Yes
  • Gas: Xcel
  • Sewer: Public Sewer
  • Water: City
  • Utility Description: Natural Gas Available, Electricity Available, Cable Available, Satellite Available

Structural Information

  • Construction: Frame, Brick
  • Exterior Const.: Frame, Brick
  • Basement: Yes
  • Basement Desc.: Full, Unfinished
  • Roof: Composition
  • Windows: Window Coverings
  • Square Feet: 4,668
  • Sq. Ft. Source: Assessor
  • Living Area: 3,222 Sq. Ft.
  • Year Built: 2012

Lot Features

  • Lot Size (Acres): 0.16
  • Lot Size (Sq. Ft.): 7,150
  • Frontage: City Street
  • Street/Road Desc.: Asphalt
  • Fence: Yes
  • Lot Features: Level, Mineral Rights Included
  • Potential Use: Single-Family
  • Zoning: RES
  • Fencing (Description): Fenced

Green Features

  • Energy Efficient: Windows, Demand Control Limiter, Thermostat

Financial Considerations

  • Association Fee: Yes
  • Association Fee: $70
  • Assoc Fee Freq.: Monthly
  • Tax Amount: $7,033
  • Tax Year: 2024
  • Terms: Cash, Conventional, FHA, VA

Disclosures and Reports

  • Special Conditions: Private Owner
  • Property ID: R4033306

Listed by RE/MAX Alliance-Lsvl (303) 666-6500

Quickly Find Out More

* Indicates a required field

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Send Message, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby’s International Realty®). I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.

We Value Your Privacy

Listing agents

— 2623 Steeple Rock Dr —

  • RE/MAX Alliance-Lsvl

    303-666-6500

  • RE/MAX Alliance-Lsvl

    303-666-6500

3036666500

Get Pre-Approved Today

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Schools serving 2623 Steeple Rock Dr

School District:St. Vrain Valley School District Re 1j
NameGradesDistance
Legacy Elementary School
7701 Eagle Boulevard, Frederick, CO 80504
PK-52.4 mi
Erie Middle School
650 Main Street, Erie, CO 80516
6-84 mi
Erie High School
3180 County Road 5, Erie, CO 80516
9-123.2 mi
Disclaimer: School attendance boundaries provided by Pitney Bowes and are for reference only. Contact the school directly to verify enrollment eligibility.

Price & Sales History for 2623 Steeple Rock Dr Get Price Alerts and Save Property

Date
Details
Price
Change
Source
12/05/2025
Price Reduced
$675,000
-3.57%
MLS
11/12/2025
Price Reduced
$700,000
-2.1%
MLS
10/30/2025
Price Reduced
$715,000
-1.38%
MLS
10/17/2025
Listed
$725,000
122.79%
MLS
12/21/2012
Sold
$325,420
—
Public Record
Get Price Alerts and Save Property
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Tax History for 2623 Steeple Rock Dr

Year
Property Taxes
Change
Tax Assessment
Change
2024
$7,033
2%
$45,460
-1%
2023
$6,868
19%
$45,900
26%
2021
$5,754
1%
$36,400
3%
2022
$5,716
7%
$35,380
4%
2020
$5,338
-1%
$33,940
—
2019
$5,388
11%
$33,940
8%
2018
$4,865
-1%
$31,470
—
2017
$4,935
10%
$31,470
8%
2016
$4,475
2%
$29,210
—
2015
$4,383
14%
$29,210
13%
2014
$3,859
-1%
$25,740
—
2013
$3,885
—
$25,740
—
View All
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Estimate the Cost for 2623 Steeple Rock Dr

$
Down Payment
%
$
%

$
$
$

*These costs are estimates, and the interest rates assume exceptional credit standing.

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Listed by RE/MAX Alliance-Lsvl (303) 666-6500

Similar Properties near 2623 Steeple Rock Dr

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

2274 Alpine Dr, Erie, CO 80516 - Photo 1
$675,000

2274 Alpine Dr  Erie, CO 80516

  • Single Family
  • Active
  • 4
    Beds
  • 4
    Total Baths
  • 2,914
    Sq. Ft.
  • MLS # 1048907
Listed by Compass - Boulder
1004 Chokecherry Ln, Longmont, CO 80503 - Photo 1
$669,000

1004 Chokecherry Ln  Longmont, CO 80503

  • Single Family
  • Active
  • 4
    Beds
  • 4
    Total Baths
  • 2,518
    Sq. Ft.
  • MLS # 1043987
Listed by JWL Associates
524 Flicker Ave, Longmont, CO 80501 - Photo 1 New to Website
$665,000

524 Flicker Ave  Longmont, CO 80501

  • Single Family
  • Active
  • Updated 6 days ago
  • 4
    Beds
  • 4
    Total Baths
  • 4,336
    Sq. Ft.
  • MLS # 5061204
Listed by Your Castle Real Estate Inc
5619 Blue Mountain Cir, Longmont, CO 80503 - Photo 1
$699,000

5619 Blue Mountain Cir  Longmont, CO 80503

  • Single Family
  • Active
  • 4
    Beds
  • 4
    Total Baths
  • 2,079
    Sq. Ft.
  • MLS # 1048823
Listed by The Agency - Boulder

Just Listed near 2623 Steeple Rock Dr

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

8009 James Ct, Niwot, CO 80503 - Photo 1 New to Website
$1,190,000
Open House

8009 James Ct  Niwot, CO 80503

  • Single Family
  • Active
  • Updated 4 hours ago
  • 4
    Beds
  • 3
    Total Baths
  • 2,856
    Sq. Ft.
  • MLS # 1049663
Listed by Compass - Boulder
799 Robert St, Longmont, CO 80503 - Photo 1 New to Website
$700,000

799 Robert St  Longmont, CO 80503

  • Townhouse
  • Active
  • Updated 1 day ago
  • 6
    Beds
  • 5
    Total Baths
  • 3,469
    Sq. Ft.
  • MLS # 4052255
Listed by LPT Realty
2417 Calais Dr, Longmont, CO 80504 - Photo 1 New to Website
$489,750

2417 Calais Dr  #19-G  Longmont, CO 80504

  • Condo
  • Active
  • Updated 3 days ago
  • 2
    Beds
  • 2
    Total Baths
  • 1,692
    Sq. Ft.
  • MLS # 1049681
Listed by RE/MAX of Boulder, Inc
3811-3813 Findlay Ln, Longmont, CO 80503 - Photo 1 New to Website
$750,000

3811-3813 Findlay Ln  Longmont, CO 80503

  • Duplex
  • Active
  • Updated 5 days ago
  • 6
    Beds
  • 4
    Total Baths
  • 3,164
    Sq. Ft.
  • MLS # 6955637
Listed by MB Team Lassen

Price Reduced near 2623 Steeple Rock Dr

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

8050 Niwot Rd, Niwot, CO 80503 - Photo 1 Price Reduced
-$30,000 (-9.38%)
$290,000

8050 Niwot Rd  #40  Niwot, CO 80503

  • Condo
  • Active
  • Updated 4 days ago
  • 2
    Beds
  • 1
    Total Bath
  • 882
    Sq. Ft.
  • MLS # 3441742
Listed by Kimberly Henry
729 17th Ave, Longmont, CO 80501 - Photo 1 Price Reduced
-$2,000 (-4%)
$48,000

729 17th Ave  #16  Longmont, CO 80501

  • Mobile Home
  • Active
  • Updated 6 days ago
  • 2
    Beds
  • 1
    Total Bath
  • 672
    Sq. Ft.
  • MLS # 6150
Listed by Mary Rose Gutierrez
2858 Bear Springs Circle, Longmont, CO 80503 - Photo 1 Price Reduced
-$100 (-0.02%)
$539,890

2858 Bear Springs Circle  Longmont, CO 80503

  • Townhouse
  • Active
  • Updated 5 days ago
  • 3
    Beds
  • 3
    Total Baths
  • 2,031
    Sq. Ft.
  • MLS # 1047817
Listed by DFH Colorado Realty LLC
2062 Ridgeview Dr, Longmont, CO 80504 - Photo 1 Price Reduced
-$1,000 (-0.11%)
$949,000

2062 Ridgeview Dr  Longmont, CO 80504

  • Single Family
  • Active
  • Updated 5 days ago
  • 6
    Beds
  • 4
    Total Baths
  • 3,870
    Sq. Ft.
  • MLS # 1046658
Listed by RE/MAX Alliance-Longmont

Recent Sales near 2623 Steeple Rock Dr

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

6325 Saratoga Trail, Erie, CO 80516 - Photo 1 Sold
$727,500

6325 Saratoga Trail  Erie, CO 80516

  • Single Family
  • Closed
  • Updated 12 days ago
  • 5
    Beds
  • 5
    Total Baths
  • 4,658
    Sq. Ft.
  • MLS # 6792868
Listed by Due South Realty
Sold by Walters & Co.
6324 Saratoga Trail, Erie, CO 80516 - Photo 1 Sold
$640,000

6324 Saratoga Trail  Erie, CO 80516

  • Single Family
  • Closed
  • 5
    Beds
  • 4
    Total Baths
  • 3,786
    Sq. Ft.
  • MLS # 1037398
Listed by Kentwood RE Cherry Creek
6523 Steeple Rock Dr, Frederick, CO 80516 - Photo 1 Sold
$665,000

6523 Steeple Rock Dr  Frederick, CO 80516

  • Single Family
  • Closed
  • 5
    Beds
  • 3
    Total Baths
  • 4,563
    Sq. Ft.
  • MLS # 1042554
Listed by The TC Group, LLC
6229 Black Mesa Rd, Frederick, CO 80516 - Photo 1 Sold
$680,000

6229 Black Mesa Rd  Frederick, CO 80516

  • Single Family
  • Closed
  • 5
    Beds
  • 4
    Total Baths
  • 4,006
    Sq. Ft.
  • MLS # 1039951
Listed by St Vrain Realty LLC

2623 Steeple Rock Dr, Frederick, CO 80516 (MLS# 1045932) is a Single Family property with 4 bedrooms, 3 full bathrooms and 1 partial bathroom. 2623 Steeple Rock Dr is currently listed for $675,000 and was received on October 17, 2025. Want to learn more about 2623 Steeple Rock Dr? Do you have questions about finding other Single Family real estate for sale in Frederick? You can browse all Frederick real estate or contact a Coldwell Banker agent to request more information.

Tour this property