Skip main navigation
New construction
  • $489,990

    24796 Static Dr, Macomb, MI 48042

    4beds
    2,810sqft
    : 
    $3,192/mo
    Get pre-qualified
    Single Family Residence
    Built in 2027
    8,712 Square Feet Lot
    $489,800 Zestimate®
    $174/sqft
    $-- HOA

    What's special

    This home is to be built, with an estimated move-in of 10-12 months. May vary pending municipal approval. See Sales Manager for details. New homes in sought after Macomb Twp & within the L'Anse Cruse school district! Lombardo Homes proudly presents the BERKELEY in Stillwater Crossing! We offer ranch and colonial-style homes ranging from 1800 to 2800+ sq. ft. This home offers an open concept that is perfect for entertaining and spending time with loved ones. Unwind in your primary bedroom with a private bath. When you’re away from home, take advantage of everything that is nearby! Within close proximity to I-94, Partridge Creek mall, a wide variety of dining & shopping, and much more! We include a 10 year structural & basement waterproofing warranties. Photos are of a decorated model or a previously built home. *Love this home, but prefer to build on land? We can build on your lot with Anywhere Lombardo. Contact us for details!
    5 days
    196
    13

    Zillow last checked:

    Listing updated:

    Listed by:

    Anthony Lombardo 248-416-1462,

    Lombardo Realty 248-416-1462

    Source: Realcomp II,MLS#: 20261068520MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 4
      • Bathrooms: 3
      • Full bathrooms: 2
      • 1/2 bathrooms: 1
      Primary bedroom
      • Level: Second
      • Area: 224
      • Dimensions: 16 X 14
      Bedroom
      • Level: Second
      • Area: 121
      • Dimensions: 11 X 11
      Bedroom
      • Level: Second
      • Area: 120
      • Dimensions: 12 X 10
      Bedroom
      • Level: Second
      • Area: 132
      • Dimensions: 11 X 12
      Primary bathroom
      • Level: Second
      Other
      • Level: Second
      Other
      • Level: Entry
      Other
      • Level: Entry
      • Area: 154
      • Dimensions: 14 X 11
      Dining room
      • Level: Entry
      • Area: 140
      • Dimensions: 14 X 10
      Great room
      • Level: Entry
      • Area: 238
      • Dimensions: 14 X 17
      Kitchen
      • Level: Entry
      • Area: 176
      • Dimensions: 16 X 11
      Laundry
      • Level: Second
      • Area: 48
      • Dimensions: 6 X 8
      Living room
      • Level: Entry
      • Area: 143
      • Dimensions: 13 X 11
      Heating
      • Forced Air, Natural Gas
      Appliances
      • Included: Dishwasher, Disposal, Free Standing Electric Range, Humidifier, Microwave
      • Laundry: Gas Dryer Hookup, Laundry Room
      Features
      • Programmable Thermostat
      • Windows: Egress Windows
      • Basement: Full,Unfinished
      • Has fireplace: No
      Interior area
      • Total interior livable area: 2,810 sqft
      • Finished area above ground: 2,810

      Property

      Parking
      • Total spaces: 2
      • Parking features: Two Car Garage, Attached, Direct Access, Driveway, Electricityin Garage, Garage Faces Front
      • Attached garage spaces: 2
      Features
      • Levels: Two
      • Stories: 2
      • Entry location: GroundLevelwSteps
      • Patio & porch: Porch
      • Exterior features: Lighting
      • Pool features: None
      Lot
      • Size: 8,712 Square Feet
      • Dimensions: 70 x 120
      Details
      • Parcel number: 200813450308
      • Special conditions: Agent Owned,Short Sale No

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Colonial
      • Property subtype: Single Family Residence
      Materials
      • Brick, Vinyl Siding
      • Foundation: Basement, Poured, Sealed Foundation, Sump Pump
      • Roof: Asphalt
      Condition
      • Const Start Upon Sale,New Construction,Site Condo
      • New construction: Yes
      • Year built: 2027
      Details
      • Warranty included: Yes

      Utilities & green energy

      • Sewer: Public Sewer
      • Water: Public
      • Utilities for property: Cable Available, Underground Utilities

      Community & HOA

      Community
      • Features: Sidewalks
      • Security: Carbon Monoxide Detectors, Smoke Detectors
      • Subdivision: STILLWATER CROSSING MCCP NO 1188
      HOA
      • Has HOA: Yes
      • HOA fee: $90 one time
      • HOA phone: 248-655-1500
      Location
      • Region: Macomb

      Financial & listing details

      • Price per square foot: $174/sqft
      • Tax assessed value: $89,000
      • Date on market: 8/26/2026
      • Cumulative days on market: 5 days
      • Listing agreement: Exclusive Right To Sell
      • Listing terms: Cash,Conventional,FHA,Va Loan

        Estimated market value

        $489,800

        $465,000 - $514,000

        $3,673/mo

        Price history

        DateEventPrice
        8/26/2026Listed for sale$489,990$174/sqft
        Source: Realcomp II #20261068520 Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025-- $44,500
        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.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: 48042

        Getting around

        0 / 100
        Car-Dependent
        25 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating

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

        Browse local experts