Skip main navigation
Accepting backups
  • $1,290,000

    3652 Pier Ave, Indian River, MI 49749

    6beds
    3,551sqft
    : 
    $8,994/mo
    Get pre-qualified
    SingleFamily
    Built in 1899
    10,000 Square Feet Lot
    $1,248,800 Zestimate®
    $363/sqft
    $590/mo HOA

    What's special

    The Issaqueen is a beautifully preserved and impeccably maintained historic cottage located in the sought-after Columbus Beach Club on Burt Lake. This rare offering combines timeless charm with modern comfort, making it the perfect four-season retreat. With six spacious bedrooms and two and a half baths, the home comfortably accommodates up to 15 guests--ideal for hosting and entertaining. Being offered with most furnishings, The Issaqueen is ready for immediate enjoyment. Inside, you'll find a warm and inviting kitchen, a cozy family room, and a comfortable living room designed for relaxation and gathering. One of the home's standout features is the expansive screened wraparound porch, where you can fully embrace summer living while enjoying peaceful lake breezes. The thoughtfully designed first floor offers both comfort and functionality, beginning with a welcoming mudroom--perfect for coming in from the lake. A dedicated laundry room features a newer, extra-large capacity washer and dryer, while the updated kitchen provides abundant cabinetry and storage. The kitchen is ideal for gathering, with a dining table that seats six and additional island seating for four. The main living area is anchored by a spacious family room and a formal living room featuring a cozy gas fireplace, creating inviting spaces for both relaxation and entertaining. A separate formal dining room accommodates six to eight guests, perfect for hosting memorable meals. Three bedrooms are conveniently located on the first floor, along with one full and one half bathroom. Upstairs, you'll find three additional bedrooms, a full bathroom, a generous walk-in closet, and ample attic storage. The expansive wraparound screened-in porch is where the home truly comes to life....absolutely magical. It's the perfect setting for gatherings of all kinds--offering shelter from the elements while still allowing you to fully enjoy the fresh air and natural surroundings.
    145 days
    145
    1

    Zillow last checked:

    Listing updated:

    Listed by:

    Terri Vizina,

    WaterWonderland Board

    Source: Northern Michigan MLS,MLS#: 479246MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 6
      • Bathrooms: 3
      • Full bathrooms: 2
      • 1/2 bathrooms: 1
      Primary bedroom
      • Area: 182
      • Dimensions: 13 x 14
      Bedroom
      • Area: 182
      • Dimensions: 13 x 14
      Bedroom 1
      • Area: 187.69
      • Dimensions: 13.7 x 13.7
      Bedroom 2
      • Area: 182
      • Dimensions: 13 x 14
      Dining room
      • Area: 98.8
      • Dimensions: 7.6 x 13
      Family room
      • Area: 450
      • Dimensions: 30 x 15
      Kitchen
      • Area: 169
      • Dimensions: 13 x 13
      Living room
      • Area: 308
      • Dimensions: 22 x 14
      Heating
      • Hot Water Baseboard
      Cooling
      • Ceiling Fan(s)
      Appliances
      • Included: Dishwasher, Disposal, Refrigerator, Washer, Dryer, Range
      Features
      • Basement: Crawl Space
      • Has fireplace: Yes
      • Fireplace features: Gas
      Interior area
      • Total interior livable area: 3,551 sqft

      Property

      Parking
      • Parking features: Attached Garage
      • Has attached garage: Yes
      • Covered spaces: 2
      Features
      • Levels: Two Or More
      • Patio & porch: Patio
      • Waterfront features: Water Access
      Lot
      • Size: 10,000 Square Feet
      • Dimensions: 100 x 100
      • Features: Sprinkler System
      Details
      • Parcel number: 161I2900001000

      Construction

      Type & style
      • Home type: SingleFamily
      Materials
      • Wood Frame/Site Built
      Condition
      • Year built: 1899

      Utilities & green energy

      • Sewer: City
      • Water: Well

      Community & HOA

      HOA
      • Has HOA: Yes
      • HOA fee: $7,075 annually
      • HOA name: Other
      • Additional fee info: $598.50
      Location
      • Region: Indian River

      Financial & listing details

      • Price per square foot: $363/sqft
      • Tax assessed value: $594,600
      • Annual tax amount: $7,175
      • Date on market: 5/5/2026

        Estimated market value

        $1,248,800

        Estimated sales range

        Not available

        Not available

        Price history

        DateEventPrice
        9/4/2026Sold$1,250,000-3.1%$352/sqft
        Source: WWMLS #201839584 Report a problem
        8/5/2026Contingent$1,290,000$363/sqft
        Source: WWMLS #201839584 Report a problem
        7/23/2026Price change$1,290,000-1.5%$363/sqft
        Source: WWMLS #201839584 Report a problem
        7/16/2026Price change$1,310,000-3.7%$369/sqft
        Source: WWMLS #201839584 Report a problem
        7/3/2026Price change$1,360,000-1.1%$383/sqft
        Source: WWMLS #201839584 Report a problem
        6/18/2026Price change$1,375,000-0.7%$387/sqft
        Source: WWMLS #201839584 Report a problem
        6/1/2026Price change$1,385,000-0.7%$390/sqft
        Source: WWMLS #201839584 Report a problem
        4/23/2026Listed for sale$1,395,000+26.2%$393/sqft
        Source: WWMLS #201839584 Report a problem
        2/28/2025Sold$1,105,000+0.5%$311/sqft
        Source: WWMLS #201832980 Report a problem
        1/3/2025Listed for sale$1,100,000+152.9%$310/sqft
        Source: WWMLS #201832980 Report a problem
        5/19/2015Sold$435,000$123/sqft
        Source: WWMLS #292761 Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025$7,175 +16.4%$297,300 +26%
        2024$6,166 +4.2%$236,000 +21.1%
        2023$5,917 +1.8%$194,800 +23.7%
        2022$5,814 $157,500 +12%
        2021-- $140,600 +8.1%
        2020-- $130,100 +2.4%
        2019-- $127,100 -21.4%
        2018-- $161,800 -0.6%
        2017-- $162,800 +11.5%
        2016-- $146,000 +46.7%
        2015-- $99,500 +14.1%
        2014-- $87,200 -5.3%
        2012-- $92,100 -1.2%
        2011-- $93,200 +1.9%
        2010-- $91,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: 49749

        Getting around

        19 / 100
        Car-Dependent
        40 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • District: Inland Lakes

        Source: Northern Michigan MLS. 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