Skip main navigation
Active
    • Price cut: $15K (7/16)
    $259,900

    16874 Farmington Rd, Livonia, MI 48154

    3beds
    1,735sqft
    : 
    $2,396/mo
    Get pre-qualified
    Condominium
    Built in 2002
    -- sqft lot
    $259,000 Zestimate®
    $150/sqft
    $507/mo HOA

    What's special

    Dramatic Price Reduction! Amazing End-Unit! Bell Creek condo in sought-after Livonia Schools! This spacious 3-bedroom, 2.5-bath home features a Private Primary Suite with a Full Bath and Walk-In Closet. NEW Furnace, A/C and HWT! Enjoy an Open Floor Plan with a Vaulted Ceiling Great Room, Gas Fireplace, and Generous Living Space--Perfect for Entertaining. The Main Floor offers a Versatile 3rd bedroom or an Office, along with a Convenient Half Bath. A Beautiful Staircase leads to the upper level with Two Bedrooms and Two Full Bathrooms. Dedicated Laundry Room with Extra Storage. One-Car Attached Garage with Additional Storage Space, Plus Extra Parking behind and Guest Parking in the Front. The condo can be accessed through the Attached Garage or the Main Front Entry. Large, Tree-Shaded Green Space out Front Enhances the Private Setting. A rare opportunity for comfort, space, and low-maintenance living!
    69 days
    |
    715
    |
    16
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    David Chapman 269-605-3555,

    Compass Realty 269-605-3555

    Source: MichRIC,MLS#: 26026037MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 3
      • Bathrooms: 3
      • Full bathrooms: 2
      • 1/2 bathrooms: 1
      • Main level bedrooms: 1
      Heating
      • Forced Air
      Cooling
      • Central Air
      Appliances
      • Laundry: In Unit, Main Level
      Features
      • Basement: Other
      • Number of fireplaces: 1
      • Fireplace features: Family Room
      Interior area
      • Total structure area: 1,735
      • Total interior livable area: 1,735 sqft

      Property

      Parking
      • Total spaces: 1
      • Parking features: Garage Faces Rear, Garage Door Opener, Attached
      • Garage spaces: 1
      Features
      • Stories: 3
      Details
      • Parcel number: 46058050048000

      Construction

      Type & style
      • Home type: Condo
      • Architectural style: Other
      • Property subtype: Condominium
      Materials
      • Brick, Vinyl Siding
      • Roof: Composition
      Condition
      • New construction: No
      • Year built: 2002

      Utilities & green energy

      • Sewer: Public Sewer
      • Water: Public

      Community & HOA

      HOA
      • Has HOA: Yes
      • Amenities included: End Unit
      • Services included: Water
      • HOA fee: $507 monthly
      Location
      • Region: Livonia

      Financial & listing details

      • Price per square foot: $150/sqft
      • Tax assessed value: $90,977
      • Annual tax amount: $5,262
      • Date on market: 6/1/2026
      • Listing terms: Cash,FHA,VA Loan,Conventional

        Estimated market value

        $259,000

        $246,000 - $272,000

        $2,742/mo

        Price history

        DateEventPrice
        7/16/2026Price change$259,900-5.5%$150/sqft
        Source: MichRIC #26026037 Report a problem
        6/30/2026Price change$274,900-1.4%$158/sqft
        Source: MichRIC #26026037 Report a problem
        6/27/2026Price change$278,900-0.4%$161/sqft
        Source: MichRIC #26026037 Report a problem
        6/20/2026Price change$279,900-1.8%$161/sqft
        Source: MichRIC #26026037 Report a problem
        6/4/2026Price change$284,900-1.7%$164/sqft
        Source: MichRIC #26026037 Report a problem
        6/1/2026Price change$289,8000%$167/sqft
        Source: MichRIC #26026037 Report a problem
        5/27/2026Price change$289,900-1.7%$167/sqft
        Source: MichRIC #26015859 Report a problem
        5/22/2026Price change$294,900-1.4%$170/sqft
        Source: MichRIC #26015859 Report a problem
        5/15/2026Price change$299,000-0.3%$172/sqft
        Source: MichRIC #26015859 Report a problem
        5/8/2026Price change$299,900-2.9%$173/sqft
        Source: MichRIC #26015859 Report a problem
        5/1/2026Price change$309,000-0.3%$178/sqft
        Source: MichRIC #26015859 Report a problem
        4/27/2026Price change$309,900-3.1%$179/sqft
        Source: MichRIC #26015859 Report a problem
        4/16/2026Listed for sale$319,900+120.6%$184/sqft
        Source: MichRIC #26015859 Report a problem
        11/18/2025Listing removed$1,750$1/sqft
        Source: Zillow Rentals Report a problem
        11/11/2025Price change$1,750-11.4%$1/sqft
        Source: Zillow Rentals Report a problem
        10/13/2025Price change$1,975-10.2%$1/sqft
        Source: Zillow Rentals Report a problem
        9/2/2025Price change$2,200-12%$1/sqft
        Source: Zillow Rentals Report a problem
        8/25/2025Listed for rent$2,500+38.9%$1/sqft
        Source: Zillow Rentals Report a problem
        1/15/2023Listing removed--
        Source: Zillow Rentals Report a problem
        1/11/2023Price change$1,800-5.3%$1/sqft
        Source: Zillow Rentals Report a problem
        12/20/2022Price change$1,900-5%$1/sqft
        Source: Zillow Rentals Report a problem
        11/18/2022Listed for rent$2,000+25%$1/sqft
        Source: Zillow Rental Manager Report a problem
        6/5/2014Listing removed$1,600$1/sqft
        Source: Desco Properties LLC #214043493 Report a problem
        5/17/2014Listed for rent$1,600$1/sqft
        Source: Desco Properties LLC #214043493 Report a problem
        1/16/2014Sold$145,000-3.3%$84/sqft
        Source: Public Record Report a problem
        9/6/2013Listing removed$150,000+82.7%$86/sqft
        Source: RE/MAX Classic #213087210 Report a problem
        6/22/2011Sold$82,116-50.5%$47/sqft
        Source: Public Record Report a problem
        9/13/2010Sold$166,044-22.2%$96/sqft
        Source: Public Record Report a problem
        1/21/2004Sold$213,391$123/sqft
        Source: Public Record Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025-- $124,400 +12.7%
        2024-- $110,400 +12.4%
        2023-- $98,200 +3.9%
        2022-- $94,500 +4.5%
        2021-- $90,400
        2020$4,280 +2.3%$90,400 +5.2%
        2019$4,184 $85,900 +0.7%
        2018$4,184 $85,300 +11.1%
        2017-- $76,800 +3.1%
        2016$2,103 $74,500 +4.4%
        2015$2,103 $71,330 +35.8%
        2012-- $52,510
        2003$361 --
        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.
        Get pre-qualified

        Climate risks

        Neighborhood: 48154

        Getting around

        37 / 100
        Car-Dependent
        38 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating

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

        Browse local experts

        Similar homes

              Nearby cities

              Nearby neighborhoods

              Nearby zip codes

              Other Livonia Topics

                Search
                Updates
                Favorites
                Plan
                Inbox