Skip main navigation
For sale
    • $129,900

    37723 Sandstone Trl, New Haven, MI 48048

    3beds
    1,563sqft
    Manufactured Home
    Built in 2024
    435 Square Feet Lot
    $129,000 Zestimate®
    $83/sqft
    $700/mo HOA

    What's special

    Act fast to secure this brand new 2024 manufactured home for sale in the desirable Millstone Pond community, strategically located near the New Haven, MI 48048 and Lenox Township border in Macomb County. This spacious 1,568 sq ft property offers significant value with NO PROPERTY TAXES and a low $700/month lot rent, making it an incredibly affordable housing option for buyers. Inside, you'll find three bedrooms and two full bathrooms, a luxury feel provided by quartz countertops, an open-concept kitchen with all appliances included, and a spacious primary bedroom master on-suite. Outside, the home features extra convenience with an included shed for storage. The Millstone Pond community is loaded with amenities, including an inground pool, fitness center, playground, and clubhouse, perfect for families and pet owners. Located in the highly-rated New Haven School District, this opportunity is ideal for those seeking low-cost home ownership near the I-94 corridor. Financing is available with manufactured home loans accepted (I can provide loan contacts). All offers are subject to park approval, and final community approval is required after an accepted offer. Agents, a special license is not required to bring your qualified mobile home buyers.
    43 days
    |
    115
    |
    11
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Brett S Knybel 586-421-1569,

    KW Platinum 586-949-0200,

    Alexander Klott 586-201-4704,

    KW Platinum

    Source: Realcomp II,MLS#: 20261042864MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 3
      • Bathrooms: 2
      • Full bathrooms: 2
      Primary bedroom
      • Level: Entry
      • Area: 255
      • Dimensions: 15 X 17
      Bedroom
      • Level: Entry
      • Area: 143
      • Dimensions: 11 X 13
      Bedroom
      • Level: Entry
      • Area: 143
      • Dimensions: 11 X 13
      Primary bathroom
      • Level: Entry
      • Area: 90
      • Dimensions: 10 X 9
      Other
      • Level: Entry
      • Area: 35
      • Dimensions: 5 X 7
      Dining room
      • Level: Entry
      • Area: 80
      • Dimensions: 8 X 10
      Family room
      • Level: Entry
      • Area: 272
      • Dimensions: 16 X 17
      Kitchen
      • Level: Entry
      • Area: 182
      • Dimensions: 13 X 14
      Laundry
      • Level: Entry
      • Area: 54
      • Dimensions: 6 X 9
      Heating
      • Forced Air, Natural Gas
      Features
      • Has basement: No
      • Has fireplace: No
      Interior area
      • Total interior livable area: 1,563 sqft
      • Finished area above ground: 1,563
      Video & virtual tour

      Property

      Parking
      • Parking features: Assigned 2 Spaces, No Garage
      Features
      • Levels: One
      • Stories: 1
      • Entry location: GroundLevelwSteps
      • Pool features: In Ground
      Lot
      • Size: 435 Square Feet
      • Dimensions: 35 x 60
      Details
      • Parcel number: 0
      • Special conditions: Short Sale No,Standard

      Construction

      Type & style
      • Home type: MobileManufactured
      • Architectural style: Manufacturedwo Land,Ranch
      • Property subtype: Manufactured Home
      Materials
      • Vinyl Siding
      • Foundation: Crawl Space
      Condition
      • New construction: No
      • Year built: 2024

      Utilities & green energy

      • Sewer: Public Sewer
      • Water: Public

      Community & HOA

      HOA
      • Has HOA: Yes
      • HOA fee: $700 monthly
      Location
      • Region: New Haven

      Financial & listing details

      • Price per square foot: $83/sqft
      • Date on market: 6/9/2026
      • Cumulative days on market: 43 days
      • Listing agreement: Exclusive Right To Sell
      • Listing terms: Cash,Conventional
      BRETT KNYBEL

      (586) 295-9550

      By pressing Contact Agent, you agree that the real estate professional identified above may call/text you about your search, which may involve use of automated means and pre-recorded/artificial voices. You don't need to consent as a condition of buying any property, goods, or services. Message/data rates may apply. You also agree to our Terms of Use. Zillow does not endorse any real estate professionals. We may share information about your recent and future site activity with your agent to help them understand what you're looking for in a home.

        Estimated market value

        $129,000

        $123,000 - $135,000

        Not available

        Price history

        DateEventPrice
        6/9/2026Listed for sale$129,900$83/sqft
        Source: Realcomp II #20261042864 Report a problem
        2/2/2026Listing removed$129,900$83/sqft
        Source: Realcomp II #20251051842 Report a problem
        11/7/2025Listed for sale$129,900$83/sqft
        Source: Realcomp II #20251051842 Report a problem

        Public tax history

        Tax history is unavailable.

        Monthly payment

        Estimated monthly payment$1,822
        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.
        Get pre-qualified

        Climate risks

        Neighborhood: 48048

        Getting around

        13 / 100
        Car-Dependent
        30 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating

        Similar homes

            Nearby cities

            Nearby zip codes

            Other New Haven Topics

              Search
              Updates
              Favorites
              Plan
              Inbox