5238 Trident Lane SW $1,775,000

    Close

    5238 Trident Lane SW Rochester, MN 55902

    • 6 Beds
    • 7 Baths
    • 8,665 sq. ft.
    • Single-Family
    • MLS# 6238944
    Favorite Share
    Views: 245 Days On Site: 310

    Go Tour This Listing

    Schedule A Showing

    Property Details

    A stunning masterpiece of over 8,000 sq feet inspired by the charm and allure of the East Coast's beloved Montauk. Every inch of this custom-designed abode is crafted to meet the needs of discerning buyers who seek nothing but the best. Let your imagination soar as you tee up your golf skills in the comfort of your own home, thanks to the state-of-the-art simulator. Channel your inner athlete with the sport court and when it's time to indulge in culinary delights, the gourmet kitchen will be your haven. Retreat to the expansive master suite, where you can unwind in luxury amid your fireplaces and spa like retreat. Step outside onto the wooded walkout setting and immerse yourself in the serene surroundings of the sought-after Lilly Farm subdivision.

    • General Features
      • Association Fee 0
      • Association Fee Frequency Annually
      • Association Y/N No
      • Contingency None
      • County Or Parish Olmsted
      • New Construction Y/N Yes
      • Property Sub Type Single Family Residence
      • Subdivision Name Lilly Farm 2nd
      • Tax Annual Amount 2602
      • Tax Year 2021
      • Year Built 2022
    • Building Features
      • Above Grade Finished Area 5121
      • Full Bathrooms 2
      • Half Bathrooms 2
      • One-Qtr Bathrooms 0
      • Three-Qtr Bathrooms 3
      • Below Grade Finished Area 3544
      • Fireplaces Total 3
      • Garage Spaces 3
      • Living Area 8665
    • Property Features
      • Lot Size Dimensions Irreg
      • Lot Size Square Feet 90169.2
    • Schools
      • Elementary School Bamber Valley
      • High School Mayo
      • Middle Or Junior School John Adams

    Contact

    Barry & Sharon Mingo

    Barry & Sharon Mingo

    Broker/Branch Manager

    BHHS North Properties Blaine

    Business: 651-324-4607
    • Prosperity Home Mortgage logo
    • HSA Home Warranty logo
    • HomeServices Insurance logo
    • Prosperity First Title logo

    Neighborhood

    55902 (Rochester) Demographics

    41 Median Age
    616 Population Density (per sq. mile)
    72% College Educated
    $91,627 Estimated Median Income
    7,736 Estimated Total Home Owners
    3,291 Estimated Total Renters
    70% / 30% Estimated Owner / Renter Divide
    2 Estimated Average Household Size
    25,063 Total Population
    Community data courtesy of LiveBy, Inc.

    Market Last 30 Days In This Postal Code

    $399,900 Median Sales Price
    43 Homes Sold
    45 New On Market

    Average Days on Site

      Properties for Sale

        Calculations provided by Reliance Network

        Property History

        Date Event Price Percent Change
        -- Current Price Source: Multiple Listing Service New Value: $1,775,000
        4/7/2023 11:24:28 AM Status Changed Source: Multiple Listing Service New Value: Pending
        7/25/2022 10:25:00 AM New in Database Source: Multiple Listing Service New Value: $1,775,000

        Payment Calculator

        $0 per month
        Year Fixed, Interest
        Principal and Interest
        $0
        Property Taxes
        Homeowners' Insurance

        Home Price
        Down Payment
        * This payment calculator is intended for educational and planning purposes only.
        ** Assumes 3.5% APR, 20% down payment, and conventional 30-year fixed rate first mortgage. Rates cited are for instructional purposes only; current rates are subject to change at any time without notice. You should not make any decisions based simply on the information provided. Additional required amounts such as taxes, insurance, homeowner association dues, assessments, mortgage insurance premiums, flood insurance or other such required payments should also be considered. Contact your mortgage company for current rates and additional information.
        Copyright 2023 Regional Multiple Listing Service of Minnesota, Inc. All rights reserved. Information Deemed Reliable But Not Guaranteed. The data relating to real estate for sale on this web site comes in part from the Broker ReciprocitySM Program of the Regional Multiple Listing Service of Minnesota, Inc. Real estate listings held by brokerage firms other than Berkshire Hathaway HomeServices North Properties are marked with the Broker ReciprocitySM logo or the Broker ReciprocitySM thumbnail logo (a little black house) and detailed information about them includes the name of the listing brokers.
        The Digital Millennium Copyright Act of 1998, 17 U.S.C. § 512 (the "DMCA"), provides recourse for copyright owners who believe that material appearing on the Internet infringes their rights under U.S. copyright law. If you believe in good faith that any content or material made available in connection with our website or services infringes your copyright, you (or your agent) may send us a notice requesting that the content or material be removed, or access to it blocked. Notices and counter-notices should be sent in writing by mail to: Michael Bisping, Director of Customer Relations at Regional Multiple Listing Service of Minnesota, Inc., 2550 University Avenue West, Suite 259S, Saint Paul, MN 55114 or by email to mbisping@northstarmls.com.


        Note: All room dimensions, including square footage data, are approximate and must be verified by the buyer. The information contained herein is furnished by the owner to the best of his/her knowledge but is subject to verification by the purchaser, and agent assumes no responsibility for the correctness thereof. The sale offering is made subject to errors, omissions, change of price, prior sale, or withdrawal without notice. In accordance with the Law, this property is offered without respect to race, color, creed, national origin, sex, familial status or disability. This is not intended to solicit property currently listed.