NOT LISTED FOR SALE

6157 Columbia St Haslett, MI 48840

Haslett Area

Estimated Value: $564,533 - $673,000

7 Beds
4 Baths
4,295 Sq Ft
$145/Sq Ft Est. Value

Sale Details

Date Sold: August 9, 2019

Last sale price $405,000 $94 Per Sq Ft

Est. 54% increase in value since last sale

Current estimated payment $4,413 / mo

34 Days on Market

Highlights

  • Lake Front
  • Vaulted Ceiling
  • Home Gym
  • Haslett High School Rated A-
  • Granite Countertops
  • Covered Patio or Porch

About This Home

As of August 2019

AMAZING OPPORTUNITY WITH BEAUTIFUL LAKE LANSING VIEWS AND DEEDED LAKE EASEMENT. COTTAGE AND HOME IN ONE. PERCHED ON A HILL AND UPDATED IN THE MOST AMAZING WAYS, HIGH END FINISHES THROUGHOUT! ENJOY THE IN-LAW QUARTERS WITH DIRECT ACCESS TO THE GARAGE OR USE IT AS EXTRA LIVING SPACE. FABULOUS FOYER ENTRY. THE FORMAL LIVING ROOM/DINING ROOM COMBINATION HAS FRENCH DOORS LEADING TO THE FRONT DECK. MAIN FLOOR STUDY WITH A 6 PANELED OAK DOOR. UPDATED MAIN FLOOR BATH INCLUDING GRANITE COUNTER TOPS AND A LOVELY VANITY. NEW OVER THE TOP KITCHEN INCLUDING AN OVER-SIZED CENTER ISLAND, GRANITE COUNTERS, DESIGNER BACK SPLASH, STAINLESS STEEL APPLIANCES, TILE FLOORING, AND BEAUTIFUL WINDOWS & CEILINGS. OVER-SIZED EATING AREA PLUS AN EATING BAR OPENING TO THE GORGEOUS FAMILY ROOM WITH A FREESTANDING GAS STOVE FIREPLACE. MAIN FLOOR LAUNDRY WITH GRANITE COUNTER AND SORTING BASKETS. OVER THE TOP THIRD FLOOR MASTER SUITE OFFERING VIEWS GALORE! ENJOY THE PINE FLOORS AND VAULTED CEILINGS, PLUS 2 BARRAL ARCHED WINDOWS WITH LAKE VIEWS. DREAMY SITTING AREA. STUNNING NEW FULL BATH WITH AMAZING WATER VISTAS, TILE SHOWER, NEW DOUBLE VANITY, TILE FLOORS, AND WALK-IN LINEN CLOSET. 4 MORE BEDROOMS ON THE 2ND FLOOR! ENJOY THE EXERCISE ROOM IN THE LOWER LEVEL PLUS AN AMAZING IN-LAW SUITE OR EXTRA LIVING SPACE WITH ITS OWN STAIRCASE TO THE GARAGE, LAUNDRY HOOK-UP, SPECIAL LIVING AREA KITCHEN & EATING SPACE WITH ITS OWN OUTSIDE ACCESS & WATER VIEWS, AND 2 BEDROOMS! GREAT KIDS PLAY HOUSE, POTTING SHED, AND DOG RUN IN THE BACK YARD. DO YOU LOVE TO GARDEN? YOU CAN SWITCH TO WELL WATER FOR GARDENING IF YOU LIKE! NEED EXTRA STORAGE OR ROOM FOR THAT VINTAGE CAR? NO WORRIES WITH THE 2 CAR AND 1 & A HALF CAR GARAGE WITH GAS HEAT AND OVER HEAD STORAGE. SOLID HARDWOOD SIX PANEL DOORS THROUGHOUT WITH NEW HINGES AND HARDWARE. CENTRAL VACUUM. ALL NEW LIGHT FIXTURES. ENJOY THE ANDERSON WINDOWS AND ALL NEW BLINDS. NEWER CARPET. ALL NEW EXTERIOR DOORS WITH THE EXCEPTION OF THE BEAUTIFUL ENTRY DOOR! SEE ATTACHED DESCRIPTION OF ALL THE UPGRADES! JUST BEAUTIFUL! SELLER RESERVES: SECURITY CAMERAS.

Last Agent to Sell the Property

Lynne VanDeventer

Coldwell Banker Professionals -Okemos License #6501128440 Listed on: 06/04/2019

Coldwell Banker Professionals -Okemos

Last Buyer's Agent

Non Member

Non Member Office

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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 Details

Home Type

  • Single Family

Est. Annual Taxes

  • $4,909

Year Built

  • Built in 1983

Lot Details

  • 10,454 Sq Ft Lot
  • Lot Dimensions are 80x132
  • Lake Front
  • East Facing Home

Parking

  • 2 Car Attached Garage
  • Parking Storage or Cabinetry

Home Design

  • Brick Exterior Construction
  • Shingle Roof
  • Vinyl Siding

Interior Spaces

  • 2.5-Story Property
  • Vaulted Ceiling
  • Gas Fireplace
  • Entrance Foyer
  • Living Room
  • Formal Dining Room
  • Home Gym
  • Fire and Smoke Detector

Kitchen

  • Oven
  • Gas Range
  • Microwave
  • Dishwasher
  • Granite Countertops
  • Disposal

Bedrooms and Bathrooms

  • 7 Bedrooms
  • In-Law or Guest Suite

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Finished Basement

  • Walk-Out Basement
  • Exterior Basement Entry
  • Basement Window Egress

Outdoor Features

  • Covered Patio or Porch

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Vented Exhaust Fan
  • Gas Water Heater
  • High Speed Internet
  • Cable TV Available

Community Details

  • Lakebrook Subdivision

Home Details

Home Type

Single Family

Est. Annual Taxes

$4,909

Year Built

Built in 1983

Lot Details

10,454 Sq Ft Lot

Parking

2

Listing Details

  • Property Sub Type: Single Family Residence
  • Property Type: Residential
  • Year Built: 1983
  • Above Grade Finished Sq Ft: 2805.0
  • General Property Info:Lot Size Dimensions: 80x132
  • General Property Info:Reserved Items: Yes
  • General Property Info:Above Grade Finished Area: 2805.0
  • General Property Info:Level 2 Finished Area: 920.0
  • General Property Info:Level 1 Finished Area: 1354.0
  • General Property Info:Total Livable Area: 4295.0
  • General Property Info:Level 3 Finished Area: 454.0
  • Improvements:Formal Dining Room: Yes
  • General Property Info:Front Door: East
  • Special Features: None

Interior Features

  • Basement: Egress Windows, Exterior Entry, Finished, Walk-Out Access
  • Heating: Forced Air, Natural Gas
  • Interior Amenities: Entrance Foyer, Granite Counters, High Speed Internet, In-Law Floorplan, Pantry, Primary Bathroom, Stove Hookup - Gas, Vaulted Ceiling(s)
  • Total Bedrooms: 7
  • Dining Room Level: First
  • Living Room Level: First
  • Levels: Two and One Half
  • Bedroom 3 Level: Second
  • Bedroom 4 Level: Second
  • Bedroom 5 Level: Second
  • Exercise Room Level: Basement
  • Other Level: First
  • Full Bathrooms: 4
  • Below Grade Sq Ft: 1490.0
  • Fireplaces: 1
  • Fireplace: Yes
  • Living Area: 4295.0
  • Baths:_pound_Full Baths 3: 1
  • Baths:_pound_Full Baths 2: 1
  • Baths:_pound_Full Baths 1: 1
  • Baths:_pound_Full Baths B: 1
  • Appliances:Gas Water Heater: Yes
  • Rooms:Bedroom 2: Yes
  • Rooms:Bedroom 3: Yes
  • Rooms:Dining Room2: Yes
  • Rooms:Kitchen2: Yes
  • Rooms:Kitchen Level2: First
  • Rooms:Living Room2: Yes
  • Rooms:Primary Bedroom2: Yes
  • Primary Bedroom Level: Third
  • Laundry Features:Main Level: Yes
  • Basement:Exterior Entry: Yes
  • Appliances Dishwasher: Yes
  • Appliances:Oven: Yes
  • Interior Features:Pantry: Yes
  • Interior Features:Entrance Foyer: Yes
  • Interior Features:Primary Bathroom: Yes
  • Percent Basement Finished: Yes
  • Basement:Walk-Out Access: Yes
  • Interior Features:In-Law Floorplan: Yes
  • Levels:Two and One Half: Yes
  • Rooms:Bedroom 4: Yes
  • Interior Features:Granite Counters: Yes
  • Interior Features:Vaulted Ceiling(s): Yes
  • Appliances:Gas Range: Yes
  • Interior Features:High Speed Internet: Yes
  • Basement:Egress Windows: Yes
  • Rooms:Bedroom 5: Yes
  • Rooms:Exercise Room: Yes
  • Interior Features:Stove Hookup - Gas: Yes
  • General Property Info:SqFt - Basement: 1475.0
  • Rooms:Other37: Yes
  • Fireplace Features:Gas5: Yes

Exterior Features

  • Roof: Shingle
  • RoadFrontageType: City Street
  • RoadSurfaceType: Paved
  • Patio And Porch Features: Covered
  • WaterfrontFeatures: Lake
  • Waterfront: Yes
  • Home Warranty: No
  • Construction Type: Brick, Vinyl Siding
  • Direction Faces: East
  • Patio Porch Features:Covered: Yes
  • Roof:Shingle: Yes
  • Road Frontage Type:City Street: Yes
  • Exterior:Vinyl Siding: Yes
  • Exterior:Brick: Yes
  • Road Surface Type:Paved: Yes
  • Waterfront Features:Lake3: Yes

Garage/Parking

  • Parking Features: Attached, Finished, Overhead Storage
  • Parking Features Garage Spaces: 2.0
  • Attached Garage: Yes
  • Garage Spaces: 2.0
  • Parking Features:Overhead Storage: Yes
  • Parking Features:Attached: Yes
  • Parking Features:Finished2: Yes

Utilities

  • Sewer: Public Sewer
  • Appliances: Disposal, Gas Water Heater, Microwave, Washer, Refrigerator, Oven, Gas Range, Dryer, Dishwasher
  • Cooling: Central Air, Exhaust Fan
  • LaundryFeatures: Main Level
  • Utilities: Cable Available
  • Water Source: Public
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Heating:Forced Air: Yes
  • Heating:Natural Gas: Yes
  • Appliances Dryer: Yes
  • Appliances Microwave: Yes
  • Appliances Refrigerators: Yes
  • Washers: Yes
  • Sewer:Public Sewer: Yes
  • Utilities:Cable Available: Yes
  • Security Features:Smoke Detector(s): Yes
  • Cooling:Central Air: Yes
  • Cooling:Exhaust Fan: Yes

Schools

  • Junior High Dist: Haslett

Lot Info

  • Lot Size Acres: 0.24
  • Lot Size: 80x132
  • Lot Size Sq Ft: 10454.4
  • ResoLotSizeUnits: Acres
  • Land Acreage:Up to 14 Acre: Yes

Tax Info

  • Tax Carrier Route: 8267
  • Tax Annual Amount: 4909.0
  • Tax Info:Taxable Value: 126700.0
  • Tax Info:State Eq Value: 126700.0

Ownership History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 4, 2019
Closed on
Aug 9, 2019
Sold by
Bought by
Seller's Agent
Lynne VanDeventer
Coldwell Banker Professionals -Okemos
Buyer's Agent
Non Member
Non Member Office
List Price
$389,900
Sold Price
$405,000
Premium/Discount to List
$15,100
3.87%
Current Estimated Value
$623,883

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$218,883
Avg. Annual Appreciation
6.39%
Original Mortgage
$324,000
Interest Rate
3.7%
Mortgage Type
New Conventional

Purchase Details

Closed on
Apr 21, 2017
Sold by
Bought by

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$100,000
Interest Rate
4.1%
Mortgage Type
Unknown

Purchase Details

Closed on
Apr 14, 2003
Sold by
Bought by

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$10,000
Interest Rate
5.95%
Mortgage Type
Credit Line Revolving
Source: Public Records

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Agents Specializing in Haslett, MI

See All Agents

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Buyer Sale Price Title Company
$405,000 Tri County Title Agency Llc
-- None Available
-- None Available
-- --
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Borrower Loan Amount
Open $400,000
Closed $66,900
Closed $324,000
Previous Owner $20,000
Previous Owner $150,000
Previous Owner $100,000
Previous Owner $20,000
Previous Owner $209,612
Previous Owner $10,000
Previous Owner $196,000
Previous Owner $75,000
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft
08/09/2019 08/09/19 Sold $405,000 +3.9% $94 / Sq Ft
07/07/2019 07/07/19 Pending -- -- --
06/03/2019 06/03/19 For Sale $389,900 -- $91 / Sq Ft
Source: Greater Lansing Association of Realtors®

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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
2026 $11,740 $259,600 $20,600 $239,000
2025 $5,247 $259,600 $20,600 $239,000
2024 $10,718 $249,900 $19,700 $230,200
2023 $10,718 $230,800 $19,300 $211,500
2022 $10,206 $204,400 $18,200 $186,200
2021 $10,010 $193,600 $18,000 $175,600
2020 $8,578 $157,100 $18,000 $139,100
2019 $5,411 $142,400 $16,900 $125,500
2018 $5,137 $126,700 $19,500 $107,200
2017 $4,909 $123,000 $21,200 $101,800
2016 $2,220 $115,900 $20,500 $95,400
2015 $2,220 $113,800 $30,769 $83,031
2014 $2,220 $108,700 $25,000 $83,700
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: Greater Lansing Association of Realtors®

MLS Number: 237213

Greater Lansing Association of Realtors®

APN: 02-02-03-405-022

Your Personal Tour Guide

Ask me questions while you tour the home.