NOT LISTED FOR SALE

4175 Rainbows End Trail Indian River, MI 49749

Estimated Value: $361,000 - $494,670

3 Beds
2 Baths
1,301 Sq Ft
$326/Sq Ft Est. Value

Last Sold October 06, 2022

Last sale price $400,000 $307 Per Sq Ft

Est. 6% increase in value since last sale

Current estimated payment $2,847/month

Highlights

  • 150 Feet of Waterfront
  • Pole Barn
  • Thermal Windows
  • Spa
  • Main Floor Primary Bedroom
  • 4 Car Attached Garage

About This Home

As of October 2022

Absolutely charming home situated on 150 feet of the Sturgeon River. Three bedrooms and two full baths along with an open floor plan for comfort and ease of living. There is a garage steps away that needs completion but offers the start of a bed and bath suite, while still maintaining garage space. AND, next to that is a large pole barn for all of your storage needs. BUT!!! The best part is the Sturgeon River is waiting for you and all the fun activities one can imagine. There are so many opportunities on the River. Kayaking, tubing and fishing are just a few. This home is just outside of the Burt Lake State Park and boat launch. You can easily moor your boat overnight there and store it in the pole barn when you leave, it is the perfect setup. The current owners rent the home as an Air BNB. They generate a full schedule of renters for the summer and a steady stream of renters for the winter. Due to the busy rental schedule, there will be no showings before the open house Friday August 12th from 3pm to 5pm and Saturday August 13th from 10am to noon. As a courtesy to the renters, please refrain from pulling into the property.

Last Agent to Sell the Property

Jane Fisher

Gaslight Group Properties License #6501333848 Listed on: 08/05/2022

Last Buyer's Agent

Jane Fisher

Gaslight Group Properties License #6501333848 Listed on: 08/05/2022

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $7,490

Lot Details

  • 150 Feet of Waterfront

Parking

  • 4 Car Attached Garage

Home Design

  • Wood Frame Construction
  • Asphalt Shingled Roof

Interior Spaces

  • 1,301 Sq Ft Home
  • Ceiling Fan
  • Thermal Windows
  • Family Room
  • Living Room
  • Dining Room
  • Water Views
  • Crawl Space
  • Dishwasher

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Primary Bedroom on Main
  • 2 Full Bathrooms

Laundry

  • Dryer
  • Washer

Outdoor Features

  • Spa
  • Pole Barn

Utilities

  • Central Air
  • Heating System Uses Natural Gas
  • Well
  • Natural Gas Water Heater
  • Septic System

Listing and Financial Details

  • Assessor Parcel Number 161-581-000-002-00 & 003

Home Details

Home Type

Single Family

Est. Annual Taxes

$7,490

Lot Details

0

Listing Details

  • Class: RESIDENTIAL
  • Type: Residential
  • Lvt Date: 08/06/2022
  • Measurement Source: Owner
  • Section: 25
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Features: Ceiling Fans, Central Air, Dishwasher, Dryer, Hot Tub, Refrigerator, Washer
  • Total Finished Sq Ft: 1301
  • Master Bedroom: On Level: Main
  • Bedroom 2: On Level: Main
  • Bedroom 3: On Level: Main
  • Bedroom 4: On Level: N/A
  • Basement: Crawl
  • Dining Room: On Level: Main
  • Kitchen: On Level: Main
  • Family Room: On Level: Main
  • Living Room: On Level: Main
  • Above Grade Finished Sq Ft: 1301
  • Bathroom 1: On Level: Main
  • Bathroom 2: On Level: Main
  • Number Of Bedrooms: 3
  • Full Bathrooms: 2
  • Rooms 1: On Level: N/A
  • Rooms 2: On Level: N/A
  • Windows: Thermo

Exterior Features

  • Construction: Wood Frame/Site Built
  • Lake: Sturgeon River
  • Roof: Asphalt Shingle
  • Waterfront Frontage: 150
  • Waterfront Water Access: Water Front
  • Water View: Y
  • Wf Wa Ownership Type: Deeded and Private Ownership

Garage/Parking

  • Garage Carport: Garage-Attached
  • Gar Car Capacity: Four +

Utilities

  • Heat Type: Natural Gas
  • Sewer: Septic
  • Water: Well
  • Water Heater: Natural Gas

Lot Info

  • Zoning: residential

Tax Info

  • Assessor Parcel Number: 161-581-000-002-00 & 003

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Aug 5, 2022
Closed on
Oct 6, 2022
Sold by
Plott Christopher J
Bought by
Hart Thomas A and Hart Waverly
Seller's Agent
Jane Fisher
Gaslight Group Properties
Buyer's Agent
Jane Fisher
Gaslight Group Properties
List Price
$399,000
Sold Price
$400,000
Premium/Discount to List
$1,000
0.25%
Current Estimated Value
$424,668

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$24,668
Avg. Annual Appreciation
1.97%
Original Mortgage
$300,000
Outstanding Balance
$258,267
Interest Rate
5.16%
Mortgage Type
New Conventional
Estimated Equity
$166,401

Purchase Details

Listed on
Feb 24, 2021
Closed on
Apr 23, 2021
Sold by
Crudo Cheree
Bought by
Plott Christopher J and Plott Stacey L
Seller's Agent
Jane Fisher
Gaslight Group Properties
Buyer's Agent
Jane Fisher
Gaslight Group Properties
List Price
$289,000
Sold Price
$330,000
Premium/Discount to List
$41,000
14.19%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
14.19%
Original Mortgage
$286,200
Interest Rate
3.1%
Mortgage Type
New Conventional

Purchase Details

Closed on
Apr 21, 2020
Sold by
Belfy John
Bought by
Curdo Cheree

Purchase Details

Listed on
May 27, 2016
Closed on
Jul 18, 2016
Sold by
John 2 And Marle M Maximiuk Revocable Tr
Bought by
Crudo Cheree and Belfy John
Seller's Agent
C.T. Shuman
Real Estate One
Buyer's Agent
Jane Fisher
Gaslight Group Properties
List Price
$167,500
Sold Price
$164,000
Premium/Discount to List
-$3,500
-2.09%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
10.80%
Source: Public Records

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area

Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Hart Thomas A $400,000 --
Plott Christopher J -- --
Curdo Cheree -- --
Crudo Cheree -- None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Hart Thomas A $300,000
Previous Owner Plott Christopher J $286,200
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
10/06/2022 10/06/22 Sold $400,000 +0.3% $307 / Sq Ft
08/05/2022 08/05/22 For Sale $399,000 +20.9% $307 / Sq Ft
04/23/2021 04/23/21 Sold $330,000 +14.2% $254 / Sq Ft View Prior Sale
02/24/2021 02/24/21 For Sale $289,000 +76.2% $222 / Sq Ft
07/20/2016 07/20/16 Sold $164,000 -2.1% $126 / Sq Ft View Prior Sale
05/28/2016 05/28/16 Pending -- -- --
05/27/2016 05/27/16 For Sale $167,500 -- $129 / Sq Ft
Source: Northern Michigan MLS

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $7,490 $192,500 $0 $0
2024 $2,004 $181,000 $0 $0
2023 $1,920 $162,900 $0 $0
2022 $1,290 $109,400 $0 $0
2021 $2,077 $98,100 $98,100 $0
2020 $1,966 $93,400 $93,400 $0
2019 $1,947 $88,000 $88,000 $0
2018 $1,877 $74,900 $0 $0
2017 $1,982 $80,700 $0 $0
2016 $1,541 $65,900 $0 $0
2015 -- $68,400 $0 $0
2014 -- $84,500 $0 $0
2012 -- $76,500 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Jane Fisher

    Seller's Agent in 2022

    Jane Fisher

    Gaslight Group Properties

    (231) 409-8060

    162 Total Sales

    Jane Fisher
    Section Image
  • C.T. Shuman

    Seller's Agent in 2016

    C.T. Shuman

    Real Estate One

    (231) 838-4200

    137 Total Sales

    C.T. Shuman
    Section Image
See All Agents

Map

Source: Northern Michigan MLS

MLS Number: 469144

Northern Michigan MLS

APN: 161-S81-000-002-00

Michigan Cheboygan County Indian River 49749

4175 Rainbows End Trail, Indian River, MI

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

Northern Michigan MLS IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.

Nearby Homes