Skip main navigation
For sale
  • $1,625,000

    2903 Quarry Rd, Prospect, KY 40059

    5beds
    3,455sqft
    : 
    $10,954/mo
    Get pre-qualified
    Single Family Residence
    Built in 2025
    0.56 Acres Lot
    $-- Zestimate®
    $470/sqft
    $125/mo HOA

    What's special

    Modern and elegant entranceCustom beamed front porchLarge private yardEv charger in garageSpectacular kitchenPainted brick facadeFormal and luxurious feel
    Welcome to 2903 Quarry Road. This beautiful home is built by award winning builder John Waller of J.P. Waller Design Group. This exceptional home has been constructed with quality and the attention to detail seldom seen. Looking at the front elevation with its abundant curb appeal, just hints at what awaits inside. With its painted brick facade, custom beamed front porch, and custom made Bevelo gas lanterns, this home is warm and welcoming. Upon entry into the foyer, you will notice the wealth of incredible trim details that are featured throughout the home. Custom imported glass steel doors from England provide a modern and elegant entrance to the adjacent study. The study has fully paneled walls that give the space a formal and luxurious feel. Th staircase to the second floor is anchored by custom milled newel posts and open railing. Leaving the entry and entering the great room that highlights as incredible coffered ceiling that has custom designed molding by John. Th custom built mantel and overmantel are flanked by built-ins custom made for the space. The back wall of the great room places focus on oversized windows allowing for a great view onto the large, private yard and covered deck beyond. Th great room is open to a spectacular kitchen. The focal point of this space is the custom-made hood with brass banding. Amish mad custom cabinets are highlighted by Cambria tops with full high backsplash. A 12' long island in sage green matches the hood color is elegant and practical. Thermador appliances that include a 6-burner gas oven, panelized dishwasher and refrigerator complete this incredible space. The dining area is located off the kitchen and has wonderful Anderson windows and door that leads to the covered porch. The primary bedroom is located on the opposite side of the house and is accentuated by a barrel ceiling with trim paneling. The primary bath feels like your own personal spa. The shower is oversized and the walls have a custom plaster finish. There is also a large soaking tub, heated floors and incredible cabinetry with Cambria tops. The primary closet is oversized and is ready to be customized to your desire. Moving up to the second floor, there are 4 additional bedrooms that share 2 jack and jill bathrooms. The 4th bedroom has a fantastic bonus area perfect for the child that needs extra space. The 5th bedroom is truly unique, in that it has its own loft, with a window, and is accessed via a library ladder. Some of the other items to not are 10' tall minimum ceiling height on the first floor, as well as solid core 8' doors. Real 3-1/4" white oak hardwood flooring in entry foyer, library, great room, kitchen, dining area, and master bedroom. Generous 3-car garage. EV charger in garage. Amish cabinets throughout. Full irrigation and landscape lighting. The Reserve at Paramont is located in the award-winning North Oldham school district. Currently the home is still being finished and items that can still be selected are flooring for the 2nd floor bedrooms, and closet shelving throughout the home. This home needs to be seen to be truly appreciated.
    3 hours
    219
    24

    Zillow last checked:

    Listing updated:

    Listed by:

    Steve Canfield 502-649-5687,

    Canfield Realty Group, LLC

    Source: Metro Search Inc. LLC DBA Apex MLS,MLS#: 1734057MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 5
      • Bathrooms: 4
      • Full bathrooms: 3
      • 1/2 bathrooms: 1
      Primary bedroom
      • Level: First
      Bedroom
      • Level: Second
      Bedroom
      • Level: Second
      Bedroom
      • Level: Second
      Bedroom
      • Level: Second
      Primary bathroom
      • Level: First
      Half bathroom
      • Level: First
      Full bathroom
      • Level: Second
      Full bathroom
      • Level: Second
      Breakfast room
      • Level: First
      Great room
      • Level: First
      Kitchen
      • Level: First
      Laundry
      • Level: First
      Library
      • Level: First
      Heating
      • Forced Air, Natural Gas
      Cooling
      • Central Air
      Features
      • Open Floorplan
      • Basement: Unfinished
      • Number of fireplaces: 1
      Interior area
      • Total structure area: 3,455
      • Total interior livable area: 3,455 sqft
      • Finished area above ground: 3,455
      • Finished area below ground: 0

      Property

      Parking
      • Total spaces: 3
      • Parking features: Attached, Entry Side
      • Attached garage spaces: 3
      Features
      • Stories: 2
      • Patio & porch: Patio, Porch
      • Exterior features: See Remarks
      • Pool features: Association, Community
      • Fencing: None
      Lot
      • Size: 0.56 Acres
      • Features: Covt/Restr, Sidewalk, Storm Sewer
      Details
      • Parcel number: 0

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Traditional
      • Property subtype: Single Family Residence
      Materials
      • Brick Veneer
      • Foundation: Concrete Perimeter
      • Roof: Shingle
      Condition
      • Year built: 2025

      Utilities & green energy

      • Sewer: Private Sewer
      • Water: Public
      • Utilities for property: Electricity Connected, Natural Gas Connected

      Community & HOA

      Community
      • Subdivision: The Reserve At Paramont
      HOA
      • Has HOA: Yes
      • Amenities included: Clubhouse, Fitness Center, Playground, Pool
      • HOA fee: $1,500 annually
      Location
      • Region: Prospect

      Financial & listing details

      • Price per square foot: $470/sqft
      • Date on market: 11/6/2026
      • Electric utility on property: Yes

        Estimated market value

        Not available

        Estimated sales range

        Not available

        Not available

        Price history

        DateEventPrice
        11/6/2026Listed for sale$1,625,000$470/sqft
        Source: Metro Search Inc. LLC DBA Apex MLS #1734057 Report a problem

        Public tax history

        Tax history is unavailable.

        Monthly payment

        Est. payment

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: 40059

        Getting around

        0 / 100
        Car-Dependent
        23 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts