Skip main navigation
Pending
  • $499,900

    26835 Celtic Dr, Flat Rock, MI 48134

    4beds
    2,712sqft
    : 
    $3,813/mo
    Get pre-qualified
    Single Family Residence
    Built in 2023
    0.34 Acres Lot
    $-- Zestimate®
    $184/sqft
    $-- HOA

    What's special

    Absolutely stunning newly built 4 bedroom, 2.5 bath home with full basement in the highly sought-after Celtic Farms subdivision! Bursting with curb appeal, this impeccable property sits on nearly half an acre and backs to a peaceful wooded area, offering privacy with all the conveniences of a subdivision! Step inside to a breathtaking open-concept floor plan featuring soaring ceilings and an abundance of natural light from beautiful Pella windows with deluxe upgrades throughout. The main level offers a well-appointed office, an expansive living room, and a stunning eat-in kitchen with granite countertops and plenty of room for gathering and entertaining! The luxurious first-floor primary suite features a spa-inspired en-suite bath and an impressive walk-in closet. A convenient first-floor laundry room completes the main level. Upstairs, you’ll find a versatile loft or den area, three exceptionally spacious bedrooms, and a sleek additional full bathroom. The exterior is equally impressive, featuring a custom extended driveway, attached garage, sprinkler system, storage shed, and a beautiful patio overlooking the private wooded backdrop. This deluxe, move-in-ready home delivers the space, quality, privacy, and modern design you’ve been searching for! Schedule your private tour today!!
    10 days
    |
    1,886
    |
    81
    |

    Likely to sell faster than

    Zillow last checked:

    Listing updated:

    Listed by:

    Victoria Camaj 734-486-5540,

    Providence Properties, Realty & Management 734-486-5540

    Source: MiRealSource,MLS#: 50214924MLS LogoOriginating MLS: Southeastern Border Association of REALTORS

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 4
      • Bathrooms: 3
      • Full bathrooms: 2
      • 1/2 bathrooms: 1
      Bedroom 1
      • Level: Entry
      • Area: 256
      • Dimensions: 16 x 16
      Bedroom 2
      • Level: Second
      • Area: 165
      • Dimensions: 11 x 15
      Bedroom 3
      • Level: Second
      • Area: 143
      • Dimensions: 11 x 13
      Bedroom 4
      • Level: Second
      • Area: 187
      • Dimensions: 11 x 17
      Bathroom 1
      • Level: Entry
      • Area: 99
      • Dimensions: 11 x 9
      Bathroom 2
      • Level: Second
      • Area: 65
      • Dimensions: 13 x 5
      Dining room
      • Level: Entry
      • Area: 126
      • Dimensions: 14 x 9
      Kitchen
      • Level: Entry
      • Area: 220
      • Dimensions: 22 x 10
      Living room
      • Level: Entry
      • Area: 168
      • Dimensions: 12 x 14
      Office
      • Level: Entry
      • Area: 169
      • Dimensions: 13 x 13
      Heating
      • Forced Air, Natural Gas
      Cooling
      • Ceiling Fan(s), Central Air
      Appliances
      • Included: Dishwasher, Disposal, Dryer, Microwave, Range/Oven, Refrigerator, Washer, Gas Water Heater
      • Laundry: Entry
      Features
      • High Ceilings, Cathedral/Vaulted Ceiling, Sump Pump, Walk-In Closet(s)
      • Basement: Concrete,Sump Pump
      • Number of fireplaces: 1
      • Fireplace features: Living Room
      Interior area
      • Total structure area: 4,355
      • Total interior livable area: 2,712 sqft
      • Finished area above ground: 2,712
      • Finished area below ground: 0

      Property

      Parking
      • Total spaces: 2
      • Parking features: Attached, Electric in Garage, Garage Door Opener
      • Attached garage spaces: 2
      Features
      • Levels: Two
      • Stories: 2
      • Patio & porch: Patio
      • Exterior features: Lawn Sprinkler
      • Frontage type: Road
      • Frontage length: 92
      Lot
      • Size: 0.34 Acres
      • Dimensions: 92 x 163
      • Features: Wooded
      Details
      • Additional structures: Gazebo, Shed(s)
      • Parcel number: 58089020017000
      • Special conditions: Private

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Cape Cod
      • Property subtype: Single Family Residence
      Materials
      • Brick
      • Foundation: Basement, Concrete Perimeter
      Condition
      • Year built: 2023

      Utilities & green energy

      • Sewer: Public Sanitary
      • Water: Public

      Community & HOA

      Community
      • Subdivision: Celtic Farms Sub
      HOA
      • Has HOA: No
      Location
      • Region: Flat Rock

      Financial & listing details

      • Price per square foot: $184/sqft
      • Tax assessed value: $34,500
      • Annual tax amount: $11,512
      • Date on market: 7/15/2026
      • Cumulative days on market: 12 days
      • Listing agreement: Exclusive Right To Sell
      • Listing terms: Cash,Conventional,FHA,VA Loan

        Estimated market value

        Not available

        Estimated sales range

        Not available

        $3,829/mo

        Price history

        DateEventPrice
        7/20/2026Pending sale$499,900$184/sqft
        Source: MiRealSource #50214924 Report a problem
        7/16/2026Listed for sale$499,900+8.3%$184/sqft
        Source: MiRealSource #50214924 Report a problem
        5/22/2024Sold$461,526+0.9%$170/sqft
        Source: Realcomp II #20240013763 Report a problem
        3/8/2024Pending sale$457,276$169/sqft
        Source: Realcomp II #20240013763 Report a problem
        3/5/2024Listed for sale$457,276$169/sqft
        Source: Realcomp II #20240013763 Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025-- $34,500
        2024-- $34,500 +31.7%
        2023-- $26,200 +9.6%
        2022-- $23,900
        2021-- $23,900
        2020$738 +2.4%$23,900 +10.6%
        2019$721 $21,600 +34.2%
        2018$721 $16,100 -10.6%
        2017-- $18,000 +5.9%
        2016$804 $17,000 +3.7%
        2015$804 -10%$16,400 +23.3%
        2013$894 +11.2%$13,300 +12.7%
        2012$804 $11,800 -6.3%
        2010-- $12,600
        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: 48134

        Getting around

        0 / 100
        Car-Dependent
        25 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • District: Flat Rock Community Schools

        Source: MiRealSource. 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