Seller's Agent in 2024
Lisa Fletcher
Berkshire Hathaway HomeServices
(517) 449-6100
15 in this area
247 Total Sales
5318 Conrad Haslett, MI 48840
Estimated Value: $604,489 - $696,000
4
Beds
3
Baths
3,713
Sq Ft
$175/Sq Ft
Est. Value
Highlights
- Spa
- Granite Flooring
- Sun or Florida Room
- Haslett High School Rated A-
- 0.92 Acre Lot
- Corner Lot
About This Home
As of October 2024Your dreams have come true here at 5318 Conrad, in Blueberry Farms, Haslett Schools. This exceptional ranch home in a country neighborhood offers a dynamic open floor plan, 4 bedrooms, 3 full baths, a Michigan sunroom, and a heated 3-season room. Upon entry, you will find a study or formal dining room and access to the lower level. Perfect for today's modern living, the great room with a gas fireplace, kitchen, and dinette gathers everyone together. The fully equipped granite kitchen includes all appliances, a vented hood fan, and an amazing walk-in pantry with wooden shelves. You will love the Michigan Sunroom with a vaulted ceiling, remote control battery-operated blinds, and country neighborhood views. A favorite hang-out space is the newly added three-season room heated by an electric fireplace, or by opening the windows from the great room or sunroom sliding door. A wonderful multi-tiered composite deck features a hot tub and steps down to a desirable near-acre corner lot with an invisible fence, raised garden, and incredible landscaping. Just wait for your first spring as perennials to start popping up to greet you! This contemporary split floor plan has an expansive primary suite on the home's north wing. It has a generous walk-in closet, a tiled ensuite bath with a double vanity with a granite countertop, a Euro-style glassed-in shower, and a private commode. The back mudroom has wonderful organization and storage, a laundry room including the washer and dryer, and access to the 3-car garage. There are two bedrooms and an expanded main hall bath shared by two sizable bedrooms. Downstairs is mostly finished featuring daylight and egress windows, a fourth bedroom and full bath, recreation room, hobby space, and wet bar - snack bar that includes a dishwasher, plenty of cabinetry, and bar fridge. Need storage, it's here too. A surplus of dry storage is ready for all your seasonal storage, a 20 KW Generac generator will keep the lights on during storms, and two electrical panels of 200 and 100 amperage. Blueberry Farms is tucked away off Piper Rd. and has easy access to expressways, shopping, schools, and eateries via Meridian and VanAtta Rds.
Last Agent to Sell the Property
Berkshire Hathaway HomeServices License #6506019559 Listed on: 08/30/2024
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $9,927
Year Built
- Built in 2014 | Remodeled
Lot Details
- 0.92 Acre Lot
- Lot Dimensions are 200.88x200
- Landscaped
- Corner Lot
- Front and Back Yard Sprinklers
- Garden
Parking
- 3 Car Attached Garage
- Front Facing Garage
Home Design
- Shingle Roof
- Vinyl Siding
- Stone Exterior Construction
- Concrete Perimeter Foundation
Interior Spaces
- 1-Story Property
- Wet Bar
- Bar Fridge
- High Ceiling
- Ceiling Fan
- Recessed Lighting
- Gas Fireplace
- Blinds
- Entrance Foyer
- Living Room
- Formal Dining Room
- Sun or Florida Room
- Neighborhood Views
- Smart Thermostat
Kitchen
- Eat-In Kitchen
- Self-Cleaning Convection Oven
- Gas Range
- Range Hood
- Ice Maker
- Dishwasher
- Granite Countertops
- Disposal
Flooring
- Carpet
- Granite
- Ceramic Tile
- Vinyl
Bedrooms and Bathrooms
- 4 Bedrooms
- Dual Closets
- Double Vanity
Laundry
- Laundry Room
- Laundry on main level
- Dryer
- Washer
Finished Basement
- Basement Fills Entire Space Under The House
- Bedroom in Basement
- Basement Window Egress
Outdoor Features
- Spa
- Front Porch
Utilities
- Dehumidifier
- Humidifier
- Forced Air Zoned Heating and Cooling System
- Heating System Uses Natural Gas
- Vented Exhaust Fan
- 200+ Amp Service
- Power Generator
- Well
- Water Purifier Leased
- Water Softener Leased
- Septic Tank
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Aug 30, 2024
Closed on
Oct 16, 2024
Sold by
Waldron Joan L and Waldron Kathleen M
Bought by
Brown Mccallum Trust and Brown
Seller's Agent
Lisa Fletcher
Berkshire Hathaway HomeServices
Buyer's Agent
Sean Gardner
Coldwell Banker Professionals -Okemos
List Price
$635,000
Sold Price
$590,000
Premium/Discount to List
-$45,000
-7.09%
Views
62
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
$59,372
Avg. Annual Appreciation
7.97%
Purchase Details
Listed on
May 4, 2012
Closed on
Aug 1, 2013
Sold by
Ddgs Llc
Bought by
Waldron Joan L and Waldron Kathleen M
Seller's Agent
Doug Eschtruth
RE/MAX Real Estate Professionals
Buyer's Agent
Lisa Fletcher
Berkshire Hathaway HomeServices
List Price
$49,900
Sold Price
$49,900
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
24.63%
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 |
|---|---|---|---|
| Brown Mccallum Trust | $590,000 | Title Resource | |
| Waldron Joan L | $49,900 | None Available |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 10/16/2024 10/16/24 | Sold | $590,000 | -1.5% | $159 / Sq Ft | |
| 10/02/2024 10/02/24 | Pending | -- | -- | -- | |
| 09/06/2024 09/06/24 | Price Changed | $599,000 | -5.7% | $161 / Sq Ft | |
| 08/30/2024 08/30/24 | For Sale | $635,000 | +71.0% | $171 / Sq Ft | |
| 08/08/2014 08/08/14 | Sold | $371,345 | 0.0% | $107 / Sq Ft | View Prior Sale |
| 08/08/2014 08/08/14 | Pending | -- | -- | -- | |
| 08/08/2014 08/08/14 | For Sale | $371,345 | +644.2% | $107 / Sq Ft | |
| 08/01/2013 08/01/13 | Sold | $49,900 | 0.0% | $14 / Sq Ft | View Prior Sale |
| 06/13/2013 06/13/13 | Pending | -- | -- | -- | |
| 05/04/2012 05/04/12 | For Sale | $49,900 | -- | $14 / 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 | $10,298 | $295,200 | $39,900 | $255,300 |
| 2024 | $46 | $262,700 | $39,000 | $223,700 |
| 2023 | $9,709 | $234,400 | $38,000 | $196,400 |
| 2022 | $3,809 | $212,100 | $35,600 | $176,500 |
| 2020 | $8,523 | $186,300 | $28,500 | $157,800 |
| 2019 | $8,244 | $175,000 | $28,500 | $146,500 |
| 2018 | $7,857 | $168,500 | $29,700 | $138,800 |
| 2017 | $7,473 | $158,900 | $28,500 | $130,400 |
| 2016 | $868 | $152,500 | $26,100 | $126,400 |
| 2015 | $868 | $144,300 | $50,635 | $93,665 |
| 2014 | $868 | $26,400 | $0 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
Lisa Fletcher
-
Sean Gardner
Buyer's Agent in 2024
Sean Gardner
Coldwell Banker Professionals -Okemos
(586) 524-7112
5 in this area
107 Total Sales
-
J
Seller's Agent in 2014
Jennifer Seguin
Coldwell Banker Realty-Dewitt
-
Doug Eschtruth
D
Seller's Agent in 2013
Doug Eschtruth
RE/MAX Michigan
(517) 455-7964
4 in this area
14 Total Sales
Map
Source: Greater Lansing Association of Realtors®
MLS Number: 283213
APN: 02-02-13-251-004
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
- 5384 van Atta Rd
- 5396 van Atta Rd
- 5560 Strawberry Ln
- 0 van Atta Rd
- 5614 Copper Creek Dr
- 161 Germany Rd
- 5603 Copper Creek Dr
- 5868 Buttonwood Dr
- 4551 Sandstone Dr
- 5187 Twinging Dr
- 6003 Green Rd
- 4552 van Atta Rd
- 725 W Grand River Ave
- 5581 Woodville Rd
- 5837 Carlton St
- 1488 Silverstone Way
- 4400 Selwood Ct
- 1235 Woodwind Trail
- 5684 Shaw St
- 1460 E Pond Dr