Skip main navigation
For sale
  • Price cut: $51K (6/12)
    $1,799,000

    2004 Trent Basin Dr, Frisco, TX 75034

    6beds
    4,800sqft
    : 
    $12,305/mo
    Get pre-qualified
    Single Family Residence
    Built in 2024
    8,494 Square Feet Lot
    $1,736,800 Zestimate®
    $375/sqft
    $126/mo HOA

    What's special

    Central vacuum systemAbundant natural lightIdeal for outdoor livingImpressive storage throughoutExquisite marble flooringAdjacent wet barSoaring ceilings
    ***Seller Motivated***Experience refined sophistication in this meticulously crafted modern Mediterranean residence with architectural elegance by Grand Homes; located in the heart of Frisco. Completed in 2024 and never-lived-in, this expansive 4,800 sq. ft. custom-built residence blends timeless taste with modern innovation and exceptional energy efficiency. From the moment you enter, you’re greeted by exquisite marble flooring, soaring ceilings, abundant natural light, and a dramatic dual staircase that truly sets a grand tone. A robust 1,000-pound residential elevator enhances the home’s effortless flow, providing seamless access to every level with unmatched convenience. The gourmet kitchen is a chef’s dream, showcasing KitchenAid commercial-grade appliances, a 6-burner gas range, an oversized island, sleek 42-inch cabinetry, a spacious walk-in pantry, and an adjacent wet bar; perfect for both intimate gatherings and large-scale entertaining. The main level also features a versatile mother-in-law suite or private executive office. Upstairs, discover 4 generously sized bedrooms, a large game room with a second wet bar, an additional living area, and impressive storage throughout. Intentional custom touches continue with a central vacuum system and a sprawling 350 sq. ft. extended patio running the full width of the home; ideal for outdoor living. Just minutes from premier destinations including The Star, PGA Headquarters, and the highly anticipated Universal Kids' Resort, this residence offers unparalleled access to Frisco’s finest amenities. Zoned to highly acclaimed Frisco ISD schools, this home delivers exceptional luxury, lifestyle, and convenience in one extraordinary package.
    225 days
    |
    253
    |
    12
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Herbert Johnson 0641355 972-821-9536,

    Compass RE Texas, LLC 469-485-7806,

    Chavayee Johnson 0781185 903-366-9693,

    Compass RE Texas, LLC

    Source: NTREIS,MLS#: 21129835

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 6
      • Bathrooms: 5
      • Full bathrooms: 5
      Primary bedroom
      • Features: Ceiling Fan(s), Double Vanity, En Suite Bathroom, Garden Tub/Roman Tub, Separate Shower, Walk-In Closet(s)
      • Level: First
      • Dimensions: 17 x 17
      Primary bedroom
      • Features: Ceiling Fan(s), Walk-In Closet(s)
      • Level: Second
      • Dimensions: 15 x 14
      Bedroom
      • Features: Ceiling Fan(s), Walk-In Closet(s)
      • Level: Second
      • Dimensions: 17 x 13
      Bedroom
      • Features: Ceiling Fan(s), Walk-In Closet(s)
      • Level: Second
      • Dimensions: 14 x 12
      Bedroom
      • Features: Ceiling Fan(s), Walk-In Closet(s)
      • Level: Second
      • Dimensions: 16 x 14
      Breakfast room nook
      • Level: First
      • Dimensions: 14 x 9
      Dining room
      • Level: First
      • Dimensions: 18 x 12
      Game room
      • Features: Built-in Features
      • Level: Second
      • Dimensions: 20 x 18
      Other
      • Features: Ceiling Fan(s), Walk-In Closet(s)
      • Level: First
      • Dimensions: 13 x 11
      Kitchen
      • Features: Built-in Features, Eat-in Kitchen, Granite Counters, Kitchen Island, Pantry, Walk-In Pantry
      • Level: First
      • Dimensions: 16 x 14
      Laundry
      • Features: Built-in Features, Concrete Counters, Utility Sink
      • Level: First
      • Dimensions: 10 x 7
      Living room
      • Features: Ceiling Fan(s), Fireplace
      • Level: First
      • Dimensions: 25 x 12
      Living room
      • Features: Built-in Features
      • Level: Second
      • Dimensions: 15 x 14
      Living room
      • Features: Ceiling Fan(s)
      • Level: First
      • Dimensions: 23 x 17
      Storage room
      • Level: Second
      • Dimensions: 9 x 6
      Heating
      • Central, Fireplace(s), Natural Gas, Zoned
      Cooling
      • Central Air, Ceiling Fan(s), Electric, Zoned
      Appliances
      • Included: Double Oven, Dishwasher, Gas Range, Microwave, Some Commercial Grade, Tankless Water Heater, Vented Exhaust Fan
      • Laundry: Washer Hookup, Dryer Hookup, Laundry in Utility Room
      Features
      • Wet Bar, Chandelier, Central Vacuum, Dry Bar, Decorative/Designer Lighting Fixtures, Double Vanity, Eat-in Kitchen, Elevator, Granite Counters, High Speed Internet, Kitchen Island, Multiple Staircases, Open Floorplan, Pantry, Vaulted Ceiling(s), Walk-In Closet(s)
      • Flooring: Carpet, Marble, Tile
      • Has basement: No
      • Number of fireplaces: 1
      • Fireplace features: Gas, Gas Log, Living Room
      Interior area
      • Total interior livable area: 4,800 sqft
      Video & virtual tour

      Property

      Parking
      • Total spaces: 2
      • Parking features: Door-Single, Driveway, Garage, Garage Door Opener, Garage Faces Side
      • Attached garage spaces: 2
      Features
      • Levels: Two
      • Stories: 2
      • Patio & porch: Covered
      • Exterior features: Lighting, Rain Gutters
      • Pool features: None
      • Fencing: Back Yard,Wood
      Lot
      • Size: 8,494 Square Feet
      • Features: Interior Lot
      • Residential vegetation: Grassed
      Details
      • Parcel number: R983155

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Mediterranean,Detached
      • Property subtype: Single Family Residence
      Materials
      • Stucco
      • Foundation: Slab
      • Roof: Tile
      Condition
      • Year built: 2024

      Utilities & green energy

      • Sewer: Public Sewer
      • Water: Public
      • Utilities for property: Natural Gas Available, Sewer Available, Separate Meters, Underground Utilities, Water Available

      Community & HOA

      Community
      • Features: Sidewalks
      • Security: Security System Owned, Carbon Monoxide Detector(s), Smoke Detector(s)
      • Subdivision: Silverleaf
      HOA
      • Has HOA: Yes
      • Services included: Association Management, Maintenance Grounds
      • HOA fee: $756 semi-annually
      • HOA name: Silverleaf Homeowners Association
      • HOA phone: 469-480-8000
      Location
      • Region: Frisco

      Financial & listing details

      • Price per square foot: $375/sqft
      • Tax assessed value: $1,348,063
      • Annual tax amount: $21,985
      • Date on market: 12/11/2025
      • Cumulative days on market: 226 days
      • Listing terms: Cash,Conventional,FHA,VA Loan

        Estimated market value

        $1,736,800

        $1.65M - $1.82M

        $6,969/mo

        Price history

        DateEventPrice
        6/12/2026Price change$1,799,000-2.8%$375/sqft
        Source: NTREIS #21129835 Report a problem
        3/6/2026Price change$1,850,000-1.3%$385/sqft
        Source: NTREIS #21129835 Report a problem
        12/11/2025Listed for sale$1,875,000$391/sqft
        Source: NTREIS #21129835 Report a problem
        11/6/2025Listing removed$1,875,000$391/sqft
        Source: NTREIS #21026195 Report a problem
        10/14/2025Price change$1,875,000-3.8%$391/sqft
        Source: NTREIS #21026195 Report a problem
        9/18/2025Price change$1,949,000-2.5%$406/sqft
        Source: NTREIS #21026195 Report a problem
        8/12/2025Listed for sale$1,999,000$416/sqft
        Source: NTREIS #21026195 Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025$2,507 +807.8%$1,348,063 +817.3%
        2024$276 +19%$146,966 +20%
        2023$232 -12.9%$122,472
        2022$266 $122,472
        Find assessor info on the county website

        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.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: 75034

        Getting around

        18 / 100
        Car-Dependent
        36 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • Elementary: Hosp
        • Middle: Pearson
        • High: Frisco
        • District: Frisco ISD

        Source: NTREIS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

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

        Browse local experts

        Similar homes