NOT LISTED FOR SALE

Estimated Value: $984,000 - $1,105,000

6 Beds
5 Baths
5,243 Sq Ft
$198/Sq Ft Est. Value

Last Sold January 03, 2023

Last sale price $975,000 $186 Per Sq Ft

Est. 6% increase in value since last sale

Current estimated payment $6,403/month

12 Days on Market

Highlights

  • Primary Bedroom Suite
  • Open Floorplan
  • A-Frame Home
  • Indian Ridge Elementary School Rated A-
  • Mountain View
  • Clubhouse

About This Home

As of January 2023

Beautifully remodeled residence in the Piney Creek Estates. Updated from top to bottom, there's a lot to love about this turnkey home. Upon entering the foyer you'll appreciate the abundance of light, space and vaulted ceilings. On the left, the formal living has a vaulted ceiling while the dining room has a tray ceiling. To the right are a set of French doors leading to an office with wood paneling. Step further into the home you'll love the spacious family room with two story windows, cozy gas fireplace and mini bar. The remodeled chef's kitchen built in refrigerator, double oven and gas stove boasts a custom island with seating for 8! The main level also has a three quarter bathroom and a sizable laundry/mud room which leads to the oversized 3 car garage filled with built in storage. At the top of the grand staircase you have a principal bedroom suite with a gas fireplace and a remodeled 5 piece bathroom complete with beautifully updated shower with glass enclosure and a soaking tub and with yet another gas fireplace. You'll never get cold feet in the huge, custom built closet with heated floors! Enjoy your bedroom's own oversized deck and take in all of the beautiful sunsets that Colorado has to offer. On this floor is another bedroom with an en suite bathroom and then two more bedrooms (one is currently being used as a fitness room) with a full bathroom to share. There's also a laundry shoot to make life easier! The basement has egress windows throughout and has a second family/gaming room with a pool table and wet bar. Another two bedrooms (one currently being used as a weight room) and full bathroom complete the basement. Enjoy evenings in the back yard in front of the gas fireplace or cooking on the built in gas grill. There's a shed to house your lawn care equipment, a horseshoe pit and also plenty of space for a pool should you choose to install one! The owner spared no expense remodeling the home! This house has it all! MOTIVATED SELLER!!!

Last Listed By

Michelle Betts

West and Main Homes Inc License #100041881 Listed on: 10/27/2022

West and Main Homes Inc

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,391

Year Built

  • Built in 1997 | Remodeled

Lot Details

  • 0.33 Acre Lot
  • East Facing Home
  • Partially Fenced Property
  • Landscaped
  • Level Lot
  • Front and Back Yard Sprinklers
  • Irrigation
  • Many Trees
  • Private Yard

HOA Fees

  • $105 Monthly HOA Fees

Parking

  • 3 Car Attached Garage

Home Design

  • A-Frame Home
  • Brick Exterior Construction
  • Concrete Roof
  • Wood Siding
  • Concrete Perimeter Foundation

Interior Spaces

  • 2-Story Property
  • Open Floorplan
  • Wet Bar
  • Sound System
  • Built-In Features
  • Bar Fridge
  • Vaulted Ceiling
  • Ceiling Fan
  • Electric Fireplace
  • Gas Fireplace
  • Double Pane Windows
  • Window Treatments
  • Bay Window
  • Entrance Foyer
  • Smart Doorbell
  • Family Room with Fireplace
  • 4 Fireplaces
  • Living Room
  • Dining Room
  • Home Office
  • Mountain Views

Kitchen

  • Eat-In Kitchen
  • Double Convection Oven
  • Cooktop
  • Warming Drawer
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Granite Countertops
  • Utility Sink
  • Disposal

Flooring

  • Wood
  • Carpet

Bedrooms and Bathrooms

  • 6 Bedrooms
  • Fireplace in Primary Bedroom
  • Primary Bedroom Suite
  • Walk-In Closet
  • In-Law or Guest Suite

Laundry

  • Laundry Room
  • Dryer
  • Washer

Finished Basement

  • Basement Fills Entire Space Under The House
  • Bedroom in Basement
  • Stubbed For A Bathroom
  • 2 Bedrooms in Basement

Home Security

  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Outdoor Features

  • Balcony
  • Deck
  • Patio
  • Outdoor Fireplace
  • Exterior Lighting
  • Outdoor Gas Grill
  • Front Porch

Schools

  • Indian Ridge Elementary School
  • Laredo Middle School
  • Smoky Hill High School

Utilities

  • Forced Air Heating and Cooling System
  • High Speed Internet
  • Phone Available
  • Cable TV Available

Listing and Financial Details

  • Exclusions: Seller's personal property. Pool table.
  • Assessor Parcel Number 033415302

Community Details

Overview

  • Association fees include ground maintenance, recycling, snow removal, trash
  • Westwind Management Group Association, Phone Number (303) 369-1800
  • Piney Creek Subdivision

Amenities

  • Clubhouse

Recreation

  • Tennis Courts
  • Community Playground
  • Community Pool
  • Park

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,391

Year Built

Built in 1997 | Remodeled

Lot Details

0

HOA Fees

$105 per month

Parking

3

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Architectural Style: A-Frame
  • Structure Type: House
  • Levels: Two
  • Year Built: 1997
  • Above Grade Finished Sq Ft: 3867
  • Exclusions: Seller's personal property. Pool table.
  • Living Area: 5243
  • Property Condition: Updated/Remodeled
  • Directions: GPS
  • SubdivisionName: Piney Creek
  • Ownership: Individual
  • ResoBuildingAreaSource: PublicRecords
  • REC_BasementLevelBathrooms: 1
  • REC_BasementLevelBedrooms: 2
  • REC_BelowGradeUnfinishedArea: 658.00
  • REC_RVSpaces: 0
  • REC_UpperLevelBathrooms: 3
  • REC_UpperLevelBedrooms: 4
  • REC_WaterIncludedYN: 1
  • Special Features: VirtualTour

Interior Features

  • Appliances: Bar Fridge, Convection Oven, Cooktop, Dishwasher, Disposal, Double Oven, Dryer, Microwave, Oven, Range, Refrigerator, Warming Drawer, Washer
  • Fireplaces: 4
  • Interior Amenities: Built-in Features, Ceiling Fan(s), Eat-in Kitchen, Entrance Foyer, Five Piece Bath, Granite Counters, High Ceilings, High Speed Internet, In-Law Floor Plan, Kitchen Island, Open Floorplan, Pantry, Primary Suite, Solid Surface Counters, Sound System, Stone Counters, Utility Sink, Vaulted Ceiling(s), Walk-In Closet(s), Wet Bar
  • Flooring: Carpet, Wood
  • Fireplace Features: Electric, Family Room, Gas, Outside, Primary Bedroom
  • Full Bathrooms: 4
  • Basement: Bath/Stubbed, Finished, Full
  • Basement: Yes
  • Three Quarter Bathrooms: 1
  • Total Bedrooms: 6
  • Below Grade Sq Ft: 1376
  • Main Level Bathrooms: 1
  • Window Features: Bay Window(s), Double Pane Windows, Window Coverings, Window Treatments

Exterior Features

  • Direction Faces: East
  • Foundation Details: Concrete Perimeter
  • Roof: Concrete
  • Construction Materials: Brick, Wood Siding
  • View: Mountain(s)
  • Exterior Features: Balcony, Gas Grill, Lighting, Private Yard
  • Patio and Porch Features: Deck, Front Porch, Patio
  • Road Frontage Type: Public
  • Road Surface Type: Paved

Garage/Parking

  • Parking Features: Concrete
  • Attached Garage: Yes
  • Garage Spaces: 3
  • Total Parking Spaces: 3
  • REC_ParkingCount: 1

Utilities

  • Utilities: Cable Available, Electricity Available, Electricity Connected, Internet Access (Wired), Natural Gas Available, Phone Available
  • Sewer: Public Sewer
  • Cooling: Central Air
  • Heating: Forced Air
  • Water Source: Public
  • Security: Carbon Monoxide Detector(s), Smoke Detector(s), Video Doorbell

Condo/Co-op/Association

  • HOA Fee Includes: Maintenance Grounds, Recycling, Snow Removal, Trash
  • Association Name: Westwind Management Group
  • Association Fee Frequency: Monthly
  • Association Amenities: Clubhouse, Park, Playground, Pool, Tennis Court(s)
  • Association Fee: 105
  • Phone: 303.369.1800
  • Association: Yes
  • Senior Community: No

Association/Amenities

  • REC_AssociationFee2Annual: 0.00
  • REC_AssociationFee3Annual: 0.00
  • REC_AssociationFeeAnnual: 1260.00
  • REC_AssociationFeeTotalAnnual: 1260.00
  • REC_AssociationManagementType: Professionally Managed
  • REC_MultipleAssociationsYN: 0
  • REC_AssociationURL: www.westwindmanagement.com

Schools

  • Middle Or Junior School: Laredo

Lot Info

  • Parcel Number: 033415302
  • Lot Size Acres: 0.33
  • Fencing: Partial
  • Building Area Total: 5901
  • Lot Features: Irrigated, Landscaped, Level, Many Trees, Sprinklers In Front, Sprinklers In Rear
  • Lot Size Sq Ft: 14549
  • ResoLotSizeUnits: SquareFeet

Rental Info

  • Furnished: Unfurnished

Tax Info

  • Tax Year: 2021
  • Tax Annual Amount: 5391

MLS Schools

  • Elementary School: Indian Ridge
  • High School: Smoky Hill

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Oct 27, 2022
Closed on
Dec 29, 2022
Sold by
Gesquiere Jill
Bought by
Schiller Steven and Schiller Ann
Seller's Agent
Michelle Betts
West and Main Homes Inc
Buyer's Agent
Mckinze Casey
LIV Sotheby's International Realty
List Price
$1,100,000
Sold Price
$975,000
Premium/Discount to List
-$125,000
-11.36%
Total Days on Market
12
Views
9
Current Estimated Value
$1,036,107

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$61,107
Avg. Annual Appreciation
2.03%
Original Mortgage
$750,000
Outstanding Balance
$732,166
Interest Rate
6.58%
Mortgage Type
New Conventional
Estimated Equity
$290,311

Purchase Details

Closed on
Dec 31, 2013
Sold by
Gesquiere Jill and Gesquiere Michael
Bought by
Gesquiere Jill

Purchase Details

Closed on
Jun 15, 2004
Sold by
Cendant Mobility Financial Corp
Bought by
Gesquiere Michael

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$550,000
Interest Rate
6.12%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Dec 29, 2003
Sold by
Ambrose Richard F and Ambrose Kathryn M
Bought by
Ambrose Richard F and Ambrose Kathryn M

Purchase Details

Closed on
Nov 7, 1997
Sold by
Chaparral Homes Ltd Liability Company
Bought by
Ambrose Richard F and Ambrose Kathryn M

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$416,000
Interest Rate
7.25%

Purchase Details

Closed on
Apr 15, 1997
Sold by
Richmond American Homes Of Colorado Inc
Bought by
Chaparral Homes Ltd Liability Company

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$39,000
Interest Rate
7.82%
Mortgage Type
Seller Take Back

Purchase Details

Closed on
Apr 5, 1993
Bought by
Conversion Arapco

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Similar Homes in the area

  • 5426 S Jasper Way, Centennial, CO 80015

    $899,000

    • 5 Beds
    • 5 Baths
    • 4,595 Sq Ft
    • 5426 S Jasper Way
    • Centennial, CO

    Welcome to this meticulously maintained & elegantly updated 5bd/5bth home in the prestigious Piney Creek community. Nestled w/in the highly sought after & award-winning Cherry Creek ISD, this spacious executive residence offers a perfect blend of luxury, comfort, and modern upgrades. Recent enhancements include interior & exterior paint, Class 4 impact-resistant roof, insulated garage doors, new

    Jim Loveridge Real Broker, LLC DBA Real

    Section Image
  • 15573 E Prentice Ln, Centennial, CO 80015

    $1,195,000

    • 5 Beds
    • 4.5 Baths
    • 5,110 Sq Ft
    • 15573 E Prentice Ln
    • Centennial, CO

    Don't miss this opportunity for a quality home in The Estates at Piney Creek! Celebrity built, custom home on the only cul-de-sac in The Estates. Open and spacious floor plan with both formal living and dining and casual living and dining. Great kitchen with center island, breakfast area and desk space plus tons of cabinet space, granite counters, built-in refrigerator, double ovens and

    Jonathan Keiler RE/MAX Professionals

    Section Image
  • 16119 E Prentice Ln, Centennial, CO 80015

    $750,000

    • 5 Beds
    • 4 Baths
    • 3,559 Sq Ft
    • 16119 E Prentice Ln
    • Centennial, CO

    Back on the market due to buyer’s contingency falling through—no issues with the home itself. The inspection report is available upon request. Won't last long. This two-story single-family home features five bedrooms and four bathrooms, totaling approximately 3,842 square feet of living space. Upon entering, you're greeted by a curved staircase with an open "catwalk" hallway overlooking the

    Yu Zhang Forever Home Real Estate LLC

    Section Image
  • 16234 E Belleview Dr, Centennial, CO 80015

    $750,000

    • 5 Beds
    • 4 Baths
    • 3,600 Sq Ft
    • 16234 E Belleview Dr
    • Centennial, CO

    Tucked away in a quiet neighborhood, this inviting home offers both charm and convenience. Just a short walk to top-rated middle and high schools in the Cherry Creek School District, it's perfectly situated for easy living. Inside, natural light pours through the windows, highlighting beautifully updated bathrooms and spacious living areas. The main level features a functional kitchen with wood

    Lyndi Martoia 8z Real Estate

    Section Image
  • 15407 E Crestline Place, Centennial, CO 80015

    $890,000

    • 5 Beds
    • 5 Baths
    • 4,375 Sq Ft
    • 15407 E Crestline Place
    • Centennial, CO

    This beautifully updated 5-bedroom, 5-bathroom home sits on a quiet cul-de-sac in Piney Creek, Centennial, CO. The open floor plan features formal living and dining areas, a gourmet kitchen with an island and breakfast nook, a main-floor study with a wet bar and built-ins, plus a powder and laundry room. Upstairs, the spacious primary suite boasts a five-piece bath and walk-in closet, with three

    Trelora Realty Team Trelora Realty, Inc.

    Section Image
  • 15395 E Penwood Place, Aurora, CO 80015

    $910,000

    • 4 Beds
    • 4.5 Baths
    • 4,910 Sq Ft
    • 15395 E Penwood Place
    • Aurora, CO

    Stunning Custom Home in Coveted Shenandoah Gated CommunityExperience the perfect blend of elegance and comfort in this spacious, beautifully updated custom home on a prime corner lot in the exclusive, gated Shenandoah neighborhood. This home offers luxury at every turn, featuring a gourmet chef’s kitchen with granite countertops, a center island, and rich hickory cabinetry, seamlessly flowing

    Douglas Hauck RE/MAX Professionals

    Section Image
  • 16222 E Prentice Ln, Centennial, CO 80015

    $775,000

    • 6 Beds
    • 4 Baths
    • 3,723 Sq Ft
    • 16222 E Prentice Ln
    • Centennial, CO

    Welcome to 16222 E Prentice Lane! Tucked into a quiet cul-de-sac in the heart of Piney Creek, this expansive 6-bedroom, 4-bathroom home offers space, comfort, and versatility for today’s lifestyle. Enjoy striking curb appeal, mature landscaping, and a welcoming front entry, complemented by an oversized 3-car garage. A standout feature of this quiet cul-de-sac is the walking trail that provides

    Gregory Pickett Compass - Denver

    Section Image
  • 15723 E Orchard Place, Aurora, CO 80016

    $1,200,000

    • 5 Beds
    • 4.5 Baths
    • 4,463 Sq Ft
    • 15723 E Orchard Place
    • Aurora, CO

    Welcome to the Home of Your Dreams – Prime Lot, and Award-Winning Design. Located in Piney Creek Village community, this stunning 5-bedroom, 5-bath home is offering unparalleled privacy and natural beauty, bordered by open space on one side and a scenic walking trail along Piney Creek . Step into a grand entryway that leads to a formal living room featuring soaring ceilings and a massive

    Reem Saidi RE/MAX Leaders

    Section Image
  • 15960 E Aberdeen Ave, Centennial, CO 80016

    $965,000

    • 5 Beds
    • 4 Baths
    • 3,181 Sq Ft
    • 15960 E Aberdeen Ave
    • Centennial, CO

    Experience the Piney Creek Village Lifestyle—where community, convenience, and Colorado beauty collide to offer a truly exceptional way of life. Enjoy exclusive access to a pool, tennis and pickleball courts and a vibrant swim club. Located just moments from the Trails Recreation Center, residents also benefit from literally miles of scenic biking and walking paths that wind through Cherry Creek

    Jerry Glass Realty One Group Elevations, LLC

    Section Image

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Schiller Steven $975,000 Stewart Title
Gesquiere Jill -- None Available
Gesquiere Michael $687,500 Guardian Title
Cendant Mobility Financial Corp $687,500 Guardian Title
Ambrose Richard F -- --
Ambrose Richard F $520,000 --
Chaparral Homes Ltd Liability Company $78,000 Land Title
Conversion Arapco -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Schiller Steven $750,000
Previous Owner Gesquiere Jill $484,350
Previous Owner Gesquiere Jill $406,500
Previous Owner Gesquiere Jill $179,700
Previous Owner Gesquiere Jill $417,000
Previous Owner Gesquiere Jill $417,000
Previous Owner Gesquiere Jill $50,000
Previous Owner Gesquiere Michael $100,000
Previous Owner Gesquiere Michael $550,000
Previous Owner Gesquiere Michael $68,700
Previous Owner Gesquiere Michael $550,000
Previous Owner Ambrose Richard F $398,000
Previous Owner Ambrose Richard F $161,000
Previous Owner Ambrose Richard F $85,000
Previous Owner Ambrose Richard F $416,000
Previous Owner Chaparral Homes Ltd Liability Company $39,000
Closed Chaparral Homes Ltd Liability Company $409,000
Closed Gesquiere Michael $68,750
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
01/03/2023 01/03/23 Sold $975,000 -11.4% $186 / Sq Ft
11/15/2022 11/15/22 Pending -- -- --
11/03/2022 11/03/22 For Sale $1,100,000 -- $210 / Sq Ft
Source: REcolorado®

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2024 $6,306 $67,409 -- --
2023 $6,306 $67,409 $0 $0
2022 $5,370 $54,210 $0 $0
2021 $5,391 $54,210 $0 $0
2020 $5,400 $55,427 $0 $0
2019 $5,210 $55,427 $0 $0
2018 $4,997 $47,534 $0 $0
2017 $4,914 $47,534 $0 $0
2016 $5,179 $47,617 $0 $0
2015 $5,000 $47,617 $0 $0
2014 $5,144 $44,297 $0 $0
2013 -- $43,790 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: REcolorado®

MLS Number: 6173251

REcolorado®

APN: 2073-17-2-23-009