R
Seller's Agent in 2018
Ricci Bartlett
RE/MAX Michigan
1407 Squirrel Run Saint Johns, MI 48879
Estimated Value: $478,000 - $788,000
6
Beds
6
Baths
4,715
Sq Ft
$134/Sq Ft
Est. Value
Highlights
- Cathedral Ceiling
- Covered Patio or Porch
- Bar
- Main Floor Primary Bedroom
- 3 Car Attached Garage
- Living Room
About This Home
As of July 2018WOW!!! Welcome to 1407 Squirrel Run! This beautiful Fred Motz Home features 6 bedrooms, 6 baths, two Story with nearly 4715 sq ft of living space. Upon entering the beautiful covered brick entry way, you enter the roomy foyer with a lovely 1st floor office flanking the right side. Walking straight into the home you have the formal living room which leads you to the formal dining room with beautiful tile floors. The newly remodeled kitchen is fabulous!!! It boasts tile floors, quartz counters, an abundance of wood cabinets, a large oversized island and large sliding door leading out to the heated salt water swimming pool. In addition, off of the dining room you will see the bar with a built in grill and fridge to entertain those summer parties. Upstairs you will find 4 beautiful bedrooms with 2 master suites, one of which has a Jack and Jill bathroom. The Master bedroom on the main level of the living room features a beautiful master bathroom with steam shower so much space to get ready for your day. The 1650 sq ft basement has a finished mother in law suite with a full kitchen, 6th bedroom and 1 ½ baths. There is also a living room which is great for entertaining. There is a 3 car garage that was just recently painted. Other updates in the last five years include: furnace, central air, sprinkler system, outdoor kitchen, screened in pool patio, kitchen counter tops, kitchen cabinets and home has been hard wired for a generator.
Last Agent to Sell the Property
Ricci Bartlett
RE/MAX Finest License #6501378707 Listed on: 05/18/2018
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $4,086
Year Built
- Built in 2004
Lot Details
- 0.49 Acre Lot
- West Facing Home
- Fenced
Parking
- 3 Car Attached Garage
- Parking Storage or Cabinetry
- Garage Door Opener
Home Design
- Brick Exterior Construction
- Shingle Roof
- Vinyl Siding
Interior Spaces
- 2-Story Property
- Sound System
- Bar
- Cathedral Ceiling
- Ceiling Fan
- Gas Fireplace
- Living Room
- Dining Room
- Finished Basement
- Basement Fills Entire Space Under The House
- Fire and Smoke Detector
- Laundry on main level
Kitchen
- Gas Oven
- Microwave
- Dishwasher
- Disposal
Bedrooms and Bathrooms
- 6 Bedrooms
- Primary Bedroom on Main
Outdoor Features
- Covered Patio or Porch
- Outdoor Grill
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Natural Gas
- Vented Exhaust Fan
- Well
- Gas Water Heater
- Septic Tank
- High Speed Internet
- Satellite Dish
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
May 18, 2018
Closed on
Jul 12, 2018
Sold by
Colthorp Ryan R and Ryan R Colthorp Living Trust
Bought by
Edwards Robert C
Seller's Agent
Ricci Bartlett
RE/MAX Finest
Buyer's Agent
Lisa Fletcher
Berkshire Hathaway HomeServices
List Price
$499,000
Sold Price
$501,000
Premium/Discount to List
$2,000
0.4%
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$131,064
Avg. Annual Appreciation
3.34%
Original Mortgage
$453,100
Interest Rate
4.5%
Mortgage Type
New Conventional
Purchase Details
Closed on
Sep 8, 2016
Sold by
Colthorp Ryan Ralph
Bought by
Colthorp Ryan R and Ryan R Colthorp Living Trust
Purchase Details
Closed on
Jul 26, 2005
Sold by
Colthorp Niccole Marie
Bought by
Colthorp Ryan Ralph
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$409,100
Interest Rate
6.95%
Mortgage Type
Fannie Mae Freddie Mac
Purchase Details
Closed on
Dec 11, 2003
Sold by
Fred Motz Builder Inc
Bought by
Colthorp Ryan and Colthorp Niccole
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$421,800
Interest Rate
6.01%
Mortgage Type
Purchase Money Mortgage
Purchase Details
Closed on
Jul 3, 2003
Sold by
Mtc Development Inc
Bought by
Fred Motz Builder Inc
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
Average Home Value in this Area
Purchase History
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Edwards Robert C | $501,000 | Ata National Title Group Llc | |
| Colthorp Ryan R | -- | Attorney | |
| Colthorp Ryan Ralph | -- | Devon Title | |
| Colthorp Ryan | $50,000 | Midstate Title Co | |
| Fred Motz Builder Inc | $96,768 | Midstate Title Company |
Source: Public Records
Mortgage History
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | Edwards Robert C | $420,000 | |
| Closed | Edwards Robert C | $406,400 | |
| Closed | Edwards Robert C | $453,100 | |
| Previous Owner | Colthorp Ryan Ralph | $342,000 | |
| Previous Owner | Colthorp Ryan Ralph | $35,000 | |
| Previous Owner | Colthrop Ryan Ralph | $409,600 | |
| Previous Owner | Colthorp Ryan | $409,100 | |
| Previous Owner | Colthorp Ryan R | $412,300 | |
| Previous Owner | Colthorp Ryan | $421,800 | |
| Closed | Fred Motz Builder Inc | $0 |
Source: Public Records
Property History
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 07/12/2018 07/12/18 | Sold | $501,000 | +0.4% | $106 / Sq Ft |
| 05/25/2018 05/25/18 | Pending | -- | -- | -- |
| 05/18/2018 05/18/18 | For Sale | $499,000 | -- | $106 / Sq Ft |
Source: Greater Lansing Association of Realtors®
Tax History Compared to Growth
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 | -- | $347,000 | $30,000 | $317,000 |
| 2024 | $3,159 | $309,700 | $30,000 | $279,700 |
| 2023 | $2,991 | $282,600 | $0 | $0 |
| 2022 | $6,839 | $245,800 | $23,500 | $222,300 |
| 2021 | $6,497 | $235,200 | $22,500 | $212,700 |
| 2020 | $6,314 | $234,700 | $18,900 | $215,800 |
| 2019 | $6,014 | $225,500 | $16,000 | $209,500 |
| 2018 | $4,179 | $198,700 | $16,500 | $182,200 |
| 2017 | -- | $206,100 | $17,500 | $188,600 |
| 2016 | $4,100 | $203,100 | $20,000 | $183,100 |
| 2015 | -- | $175,400 | $0 | $0 |
| 2011 | -- | $184,100 | $0 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
-
Buyer's Agent in 2018
Lisa Fletcher
Berkshire Hathaway HomeServices
(517) 449-6100
1 in this area
277 Total Sales
Map
Source: Greater Lansing Association of Realtors®
MLS Number: 226288
APN: 030-190-000-038-00
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.
IDX information is provided exclusively for Consumers'
personal, non-commercial use, that it may not be used for any purpose other than to identify prospective properties Consumers may be interested in purchasing. Data is deemed reliable but is not guaranteed accurate by the MLS.
Copyright © 2025 Greater Lansing Association of REALTORS®
Nearby Homes
- 1315 Harvest Moon Way
- 3430 Win Mill Dr
- 1055 Summerfield Ln
- 3387 Old U S 27
- 1055 Woodridge Dr
- 1060 Woodridge Dr
- 1080 Woodridge Dr
- 3180 S Bus 127
- 0 S Us 27 Unit 287962
- 11760 S Us 27
- 1480 Superior Dr Unit 24
- 1396 Superior Dr Unit 28
- 1398 Superior Dr Unit 27
- 1300 Superior Dr Unit 1
- 700 E Townsend Rd
- 1275 Fieldstone Dr
- 2150 W Parks Rd
- 1173 Sunview Dr
- 2239 Secretariat Ln
- 2242 Winners Cir
- 1397 Squirrel Run
- 3400 Grouse Way
- 1391 Brown Hollow Dr
- 1455 Squirrel Run
- 1414 Squirrel Run
- 1404 Squirrel Run
- 1394 Squirrel Run
- 1380 Brown Hollow Dr
- 3360 Grouse Way
- 1371 Brown Hollow Dr
- 1444 Squirrel Run
- 3385 Grouse Way
- 1390 Brown Hollow Dr
- 1477 Squirrel Run
- 1400 Brown Hollow Dr
- 3330 Grouse Way
- 1484 Squirrel Run
- 3343 Grouse Way
- 1320 Harvest Moon Way
- 1300 Harvest Moon Way