NOT LISTED FOR SALE

5154 Sapphire Cir Unit 29 East Lansing, MI 48823

Estimated Value: $413,012 - $461,000

2 Beds
2 Baths
2,888 Sq Ft
$280/mo HOA Fee

Last Sold March 28, 2024

Last sale price $402,250 $139 Per Sq Ft

Est. 7% increase in value since last sale

Current estimated payment $2,660/month

205 Days on Market

Highlights

  • View of Trees or Woods
  • Open Floorplan
  • Private Lot
  • Bennett Woods Elementary School Rated A
  • Deck
  • Ranch Style House

About This Home

As of March 2024

Modern Luxury Condo! A rare find nestled at the back of a cul-de-sac overlooking quiet nature preserve. Elegantly appointed Over 2888 fin sq ft, 2BR, 2BTH, finished lower level stubbed for full bath.
This former Jim Giguere parade model was completed in 2002 and still looks brand new! Professionally decorated & pristinely maintained with light colored ceramic tile and beautiful newer carpet and fresh warm pallet paint colors ready for you to move right in. Newer glass front storm door lets light filter in from front to back. The oversized foyer welcomes you into the open floor plan. Open Great room & Dining room (flex room) with pillared accents & custom wall mirror. The Great room boasts cathedral ceiling and Southern Palladium window wall, making it sunny & bright throughout. Glamorous updated white kitchen features GE Café series designer styled appliances, Stove/oven, Dishwasher, Refrigerator & microwave, white Quartz surface countertops & fresh white tile back splash & wide plank maple flooring; the miles of counter space and built in desk area. The kitchen allows for breakfast seating and is open to the handsome Hearth Room; featuring soothing paint colors & built in TV cabinet with gas fireplace and includes sliders to the new maintenance free deck. Lovely main level Primary suite boasts dream bath; luxurious double vanity, soaking tub & walk in closet. The 2nd bedroom could be used as an office or guest suite as the bathroom is adjacent. Amazing, finished walk out Lower level, perfect for family fun, overnight stays; could add theater room, pool table, game table etc. Many updates include: newer shower door Master Bath, 4 New windows in kitchen/hearth room on westerly wall & Master Bedroom 2 new windows; carpet & paint & kitchen appliances. Wonderful location, 3 miles to East Lansing (MSU), 5 miles to downtown Lansing Hospitals, 2 miles to malls & shopping, easy highway access (I-96 & I-69). Okemos class A Schools, many nearby restaurants & shopping.

Last Listed By

Shelly Hall

Coldwell Banker Professionals -Okemos License #6506040859 Listed on: 02/29/2024

Coldwell Banker Professionals -Okemos

Property Details

Home Type

  • Condominium

Est. Annual Taxes

  • $5,296

Year Built

  • Built in 2001 | Remodeled

Lot Details

  • North Facing Home
  • Native Plants
  • Front Yard Sprinklers
  • Few Trees

HOA Fees

  • $280 Monthly HOA Fees

Parking

  • Driveway

Home Design

  • Ranch Style House
  • Brick Exterior Construction
  • Shingle Roof
  • Vinyl Siding
  • Concrete Perimeter Foundation

Interior Spaces

  • Open Floorplan
  • Cathedral Ceiling
  • Electric Fireplace
  • Gas Fireplace
  • Window Treatments
  • Entrance Foyer
  • Family Room with Fireplace
  • Living Room
  • Dining Room
  • Storage
  • Views of Woods

Kitchen

  • Eat-In Kitchen
  • Breakfast Bar
  • Electric Cooktop
  • Dishwasher
  • Stone Countertops
  • Disposal

Flooring

  • Wood
  • Carpet
  • Ceramic Tile

Bedrooms and Bathrooms

  • 2 Bedrooms
  • Walk-In Closet
  • In-Law or Guest Suite
  • 2 Full Bathrooms
  • Double Vanity
  • Soaking Tub

Laundry

  • Laundry on main level
  • Dryer
  • Washer
  • Sink Near Laundry

Partially Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Exterior Basement Entry
  • Sump Pump
  • Fireplace in Basement
  • Stubbed For A Bathroom
  • Basement Window Egress

Outdoor Features

  • Deck
  • Front Porch

Utilities

  • Humidifier
  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Natural Gas Connected
  • Gas Water Heater
  • Cable TV Available

Community Details

  • Association fees include trash, snow removal, lawn care, exterior maintenance
  • Sapphire Lakes Association
  • Sapphire Lakes Subdivision

Property Details

Home Type

Condominium

Est. Annual Taxes

$5,296

Year Built

Built in 2001 | Remodeled

Lot Details

0

HOA Fees

$280 per month

Listing Details

  • Property Sub Type: Condominium
  • Bedroom 2 Level: First
  • Dining Room Level: First
  • Living Room Level: First
  • Property Conditions Updated Remodeled: Yes
  • Current Use: Primary
  • Tax Year: 2022
  • Levels: One
  • Year Built: 2001
  • Lot Size: Condo
  • Subdivision Name: Sapphire Lakes
  • Above Grade Finished Sq Ft: 1688.0
  • Architectural Style: Ranch
  • Living Area: 2888.0
  • New Construction: No
  • General Property Info:Lot Size Dimensions: Condo
  • General Property Info:Above Grade Finished Area: 1688.0
  • General Property Info:Total Livable Area: 2888.0
  • Baths:_pound_Full Baths 1: 2
  • Rooms:Dining Room2: Yes
  • Rooms:Living Room2: Yes
  • Primary Bedroom Level: First
  • Laundry Features:Main Level: Yes
  • Location Legal Info:Real Estate Owned: No
  • Appliances Dryer: Yes
  • Appliances Refrigerators: Yes
  • Washers: Yes
  • Flooring:Carpet: Yes
  • Sewer:Public Sewer: Yes
  • Utilities:Cable Available: Yes
  • Roof:Shingle: Yes
  • Levels:One: Yes
  • Cooling:Central Air: Yes
  • Exterior:Vinyl Siding: Yes
  • Architectural Style:Ranch: Yes
  • Exterior:Brick: Yes
  • Foundation Details:Concrete Perimeter: Yes
  • Utilities:Natural Gas Connected: Yes
  • Flooring:Ceramic Tile: Yes
  • Flooring:Hardwood: Yes
  • Utilities:Electricity Connected: Yes
  • Laundry Features:Sink: Yes
  • View:TreesWoods: Yes
  • Tax Info:Zoning3: Residential
  • General Property Info:Building Area Total SqFt: 3376.0
  • Fireplace Features:Gas5: Yes
  • General Property Info:Front Door: North
  • Special Features: VirtualTour

Interior Features

  • Basement: Bath/Stubbed, Egress Windows, Exterior Entry, Full, Partially Finished, Sump Pump, Walk-Out Access
  • Heating: Forced Air, Natural Gas
  • EntryLocation: Front Door
  • Flooring: Carpet, Ceramic Tile, Hardwood
  • Interior Amenities: Breakfast Bar, Cathedral Ceiling(s), Double Vanity, Eat-in Kitchen, Entrance Foyer, In-Law Floorplan, Open Floorplan, Soaking Tub, Stone Counters, Storage, Walk-In Closet(s)
  • Total Bedrooms: 2
  • Room: 8
  • Property Type: Residential
  • Other Level: First
  • Window Features: Window Coverings, Window Treatments
  • Full Bathrooms: 2
  • Below Grade Sq Ft: 1200.0
  • Fireplace Features: Gas, Electric, Basement, Family Room
  • Fireplace: Yes
  • Appliances:Gas Water Heater: Yes
  • Full Basement: Yes
  • Basement:Exterior Entry: Yes
  • Community Features:Curbs: Yes
  • Community Features:Sidewalks: Yes
  • Appliances Dishwasher: Yes
  • Interior Features:Cathedral Ceiling(s): Yes
  • Basement:Partially Finished: Yes
  • Appliances:Humidifier: Yes
  • Interior Features:Entrance Foyer: Yes
  • Basement:Walk-Out Access: Yes
  • Interior Features:In-Law Floorplan: Yes
  • Appliances:Electric Range: Yes
  • Interior Features:Breakfast Bar: Yes
  • Interior Features:Open Floorplan: Yes
  • Interior Features:Walk-In Closet(s): Yes
  • Basement:Sump Pump: Yes
  • Interior Features:Eat-in Kitchen: Yes
  • Basement:Egress Windows: Yes
  • Fireplace Features:Family Room: Yes
  • Interior Features:Double Vanity: Yes
  • Interior Features:Stone Counters: Yes
  • Interior Features:Storage: Yes
  • Basement:BathStubbed: Yes
  • Fireplace Features:Basement4: Yes
  • Appliances:Electric Cooktop: Yes
  • Interior Features:Soaking Tub: Yes
  • Fireplace Features:Electric4: Yes

Exterior Features

  • Roof: Shingle
  • Foundation Details: Concrete Perimeter
  • Lot Features: Few Trees, Native Plants, Private, Sprinklers In Front
  • RoadFrontageType: City Street
  • RoadSurfaceType: Asphalt, Concrete
  • Patio And Porch Features: Deck, Front Porch
  • View: Trees/Woods
  • Construction Type: Brick, Vinyl Siding
  • Direction Faces: North
  • Property Condition: Updated/Remodeled
  • Patio Porch Features:Deck: Yes
  • Patio Porch Features:Front Porch: Yes
  • Lot Features:Private2: Yes
  • Lot Features:Few Trees: Yes
  • Window Features:Window Coverings: Yes
  • Lot Features:Sprinklers In Front: Yes
  • Window Features:Window Treatments: Yes
  • Lot Features:Native Plants: Yes

Garage/Parking

  • Parking Features: Driveway
  • Attached Garage: No
  • Parking Features:Driveway: Yes
  • Parking Features:Concrete6: Yes

Utilities

  • Sewer: Public Sewer
  • Appliances: Disposal, Electric Cooktop, Electric Range, Gas Water Heater, Washer, Refrigerator, Humidifier, Dryer, Dishwasher
  • Cooling: Central Air
  • LaundryFeatures: Main Level, Sink
  • Utilities: Natural Gas Connected, Electricity Connected, Cable Available
  • Water Source: Public
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Heating:Forced Air: Yes
  • Heating:Natural Gas: Yes

Condo/Co-op/Association

  • Association Fee: 280.0
  • Association Fee Frequency: Monthly
  • Association Name: Sapphire Lakes
  • Community Features: Curbs, Sidewalks
  • Association: Yes

Association/Amenities

  • Location Legal Info:Association Fee: 280.0
  • Location Legal Info:Association Name: Sapphire Lakes
  • Location Legal Info:Association Fee Frequency: Monthly
  • Association Fee Includes:Trash: Yes

Fee Information

  • Association Fee Includes: Trash, Snow Removal, Lawn Care, Exterior Maintenance

Schools

  • Junior High Dist: Okemos

Tax Info

  • Tax Carrier Route: 7266
  • Tax Annual Amount: 5296.0

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Feb 29, 2024
Closed on
Mar 27, 2024
Sold by
Stearns Laura O
Bought by
Pierce Brenda and Pierce Brent
Seller's Agent
Shelly Hall
Coldwell Banker Professionals -Okemos
Buyer's Agent
Amy Yaroch
Keller Williams Realty Lansing
List Price
$429,500
Sold Price
$402,250
Premium/Discount to List
-$27,250
-6.34%
Total Days on Market
205
Views
21
Current Estimated Value
$429,003

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$26,753
Avg. Annual Appreciation
4.91%
Original Mortgage
$206,775
Outstanding Balance
$204,768
Interest Rate
6.77%
Mortgage Type
New Conventional
Estimated Equity
$219,676

Purchase Details

Closed on
Sep 21, 2021
Sold by
Stearns Laura O
Bought by
Stearns Laura O and Valentino Damon L

Purchase Details

Closed on
Sep 25, 2020
Sold by
Laura Ronald E and Laura Oneil
Bought by
Stearns Laura O

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$180,200
Interest Rate
2.8%
Mortgage Type
New Conventional

Purchase Details

Closed on
Dec 20, 2010
Sold by
Stearns Laura O
Bought by
Stearns Laura O E and Ronald E & Laura Oneil Stearns Joint Tru

Purchase Details

Closed on
Mar 22, 2010
Sold by
Clouse Ted T and Clouse Dixie M
Bought by
Stearns Laura O

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$218,250
Interest Rate
4.96%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jun 14, 2002
Sold by
Sapphire Lakes Development Llc
Bought by
Clouse Ted T and Clouse Dixie M

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$170,000
Interest Rate
6.82%
Mortgage Type
Purchase Money Mortgage

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

Similar Homes in East Lansing, MI

  • 5259 Golden Cir, East Lansing, MI 48823

    $352,000

    • 3 Beds
    • 3 Baths
    • 2,430 Sq Ft
    • 5259 Golden Cir
    • East Lansing, MI

    On the Lake tucked away in the peaceful Wildwood Lakes - Emerald Lakes Condominium in Meridian Twp is 5259 Golden Circle, just minutes from downtown East Lansing. This beautifully maintained three-bedroom, three-full-bath ranch offers a spacious, light-filled layout that feels warm and welcoming when you enter. The fully renovated kitchen is designed for someone who loves to cook—whether it's a

    Lisa Fletcher Berkshire Hathaway HomeServices

    Section Image
  • 6116 E Longview Dr Unit 73, East Lansing, MI 48823

    $447,700

    • 3 Beds
    • 3 Baths
    • 3,490 Sq Ft
    • 6116 E Longview Dr
    • Unit 73
    • East Lansing, MI

    WELCOME HOME TO 6116 E. LONGVIEW DRIVE! THIS CUSTOM BUILT LUXURY CONDO HAS BEEN GENTLY LIVED IN SEASONALLY BY THE ORIGINAL OWNERS! IT OFFERS 3500 FINISHED SQ. FT. OF LIVING SPACE WITH WONDERFUL ENTERTAINING OPTIONS! 3 LARGE BEDROOMS, INCLUDING A SPACIOUS PRIMARY SUITE WITH MASSIVE BATHROOM AND WALK-IN CLOSET, 3 FULL BATHS, FORMAL DINING, A LARGE OPEN LIVING-GREAT-ROOM WITH ISLAND KITCHEN, CROWN

    Travis Conti RE/MAX Real Estate Professionals

    Section Image
  • 5267 E Hidden Lake Dr, East Lansing, MI 48823

    $325,000

    • 3 Beds
    • 3.5 Baths
    • 3,095 Sq Ft
    • 5267 E Hidden Lake Dr
    • East Lansing, MI

    Spacious 3 BR, 4 bath two story condo in Emeral Lakes with walkout and water views!Large rooms, open floor plan with hardwood floors on main level. Great room has slider onto the deck to enjoy the beautiful views. Huge living area with fireplace and connects to the dining area. Kitchen with white cabinets, tile countertops and breakfast bar along with pantry. Upper level with primary suite

    Terry Lasky Coldwell Banker Professionals -Okemos

    Section Image
  • 2411 Emerald Lake Dr, East Lansing, MI 48823

    $475,000

    • 4 Beds
    • 3.5 Baths
    • 3,151 Sq Ft
    • 2411 Emerald Lake Dr
    • East Lansing, MI

    Exquisitely renovated Lake Front 4-bedroom, 4-bathroom condo in the desirable Wildwood Lake community, within Okemos Schools! This stunning home features a 2-car attached garage and breathtaking lake views. The main floor boasts a fabulous kitchen with stainless steel appliances, a stunning 2-story living room with a fireplace, and a luxurious primary suite with a walk-in closet and a spa-like

    Brian Ozbun Bellabay Realty, LLC

    Section Image
  • 2430 Emerald Lake Dr, East Lansing, MI 48823

    $324,900

    • 3 Beds
    • 2 Baths
    • 2,238 Sq Ft
    • 2430 Emerald Lake Dr
    • East Lansing, MI

    Welcome to 2430 Emerald Lake Dr. 2-car attached garage. Volume Ceilings. Many enhancements. Finished walkout. Over 2,200 sq ft living space. Finished walkout! The house has such a cool vibe with the vaulted ceilings and many enhancements - you are going to love it. Two beds, two baths up front. Works well for long-term company, work at home and much more. Centered 1st level office space

    Carin Whybrew Coldwell Banker Professionals -Okemos

    Section Image
  • 2454 Emerald Lake Dr Unit 106, East Lansing, MI 48823

    $335,000

    • 4 Beds
    • 3 Baths
    • 3,135 Sq Ft
    • 2454 Emerald Lake Dr
    • Unit 106
    • East Lansing, MI

    LAKE ACCESS! Tucked away on a quiet cul-de-sac in the sought-after Emerald Lake condo neighborhood, this East Lansing home offers an incredible combo of space, location, and lake access—all in the award-winning Okemos School District. Enjoy maintenance free living outside, with 4 bedrooms and 3 full baths inside, there's room for everyone, and the finished walk-out lower level adds even more

    Missy Lord RE/MAX Real Estate Professionals Dewitt

    Section Image
  • 5331 E Hidden Lake Dr, East Lansing, MI 48823

    $325,000

    • 3 Beds
    • 3 Baths
    • 2,972 Sq Ft
    • 5331 E Hidden Lake Dr
    • East Lansing, MI

    Welcome to 5331 E Hidden Lake Drive - comfort, convenience, and space in one beautiful home! This charming ranch-style condominium offers the perfect blend of low-maintenance living and spacious comfort. Featuring 3 bedroom and 3 full bathrooms, this home is thoughtfully designed to accommodate both everyday living and entertaining. Step inside to discover a bright and welcoming layout with first

    Farrin Forsberg Bellabay Realty, LLC

    Section Image
  • 2397 Emerald Forest Cir Unit 26, East Lansing, MI 48823

    $349,900

    • 3 Beds
    • 3.5 Baths
    • 2,772 Sq Ft
    • 2397 Emerald Forest Cir
    • Unit 26
    • East Lansing, MI

    Popular and secluded 2 story condo in Wildwood Lakes subdivision. Primary bedroom on Main floor, including main floor laundry. Updated kitchen with quartz counters. Newer oak flooring in kitchen, formal dining, living room and primary bedroom. Newer GE Profile cooktop and newer Dryer. All appliances stay! Partially finished basement with a full bath. The other unfinished part has

    Sonya Pentecost Berkshire Hathaway HomeServices

    Section Image
  • 2371 Emerald Forest Cir, East Lansing, MI 48823

    $335,000

    • 3 Beds
    • 2.5 Baths
    • 2,642 Sq Ft
    • 2371 Emerald Forest Cir
    • East Lansing, MI

    This is your LUCKY day! Seller is willing to cover the special assessment for the next 2 years! Run! Contemporary main level living condo w/option of guest accommodations upstairs and partially finished lower level. Lots of square footage for the dollar. Cozy corner fireplace strategically situated. Light, bright. Roomy kitchen. Open floorplan. Multi level deck to enjoy nature. Lovely

    Deb Federau Keller Williams Realty Lansing

    Section Image

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
Pierce Brenda $402,250 None Listed On Document
Stearns Laura O -- None Available
Stearns Laura O -- Transnation Title
Stearns Laura O E -- None Available
Stearns Laura O $242,500 Tri County Title Agency Llc
Clouse Ted T $240,000 Midstate Title Company
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Pierce Brenda $206,775
Previous Owner Stearns Laura O $180,200
Previous Owner Stearns Laura O $196,500
Previous Owner Stearns Laura O $218,250
Previous Owner Clouse Ted T $170,000
Previous Owner Sapphire Lakes Development Llc $342,600
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
03/28/2024 03/28/24 Sold $402,250 -6.3% $139 / Sq Ft
02/29/2024 02/29/24 Pending -- -- --
02/29/2024 02/29/24 Price Changed $429,500 0.0% $149 / Sq Ft
02/29/2024 02/29/24 For Sale $429,500 0.0% $149 / Sq Ft
02/23/2024 02/23/24 Off Market $429,500 -- --
11/27/2023 11/27/23 Price Changed $429,500 -3.5% $149 / Sq Ft
11/02/2023 11/02/23 Pending -- -- --
09/18/2023 09/18/23 Price Changed $445,000 -6.3% $154 / Sq Ft
08/08/2023 08/08/23 For Sale $474,900 -- $164 / Sq Ft
Source: Greater Lansing Association of Realtors®

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
2024 $29 $197,500 $38,300 $159,200
2023 $5,463 $135,500 $37,800 $97,700
2022 $5,296 $132,200 $36,000 $96,200
2021 $5,193 $126,200 $32,500 $93,700
2020 $5,030 $121,700 $32,500 $89,200
2019 $4,917 $109,100 $29,500 $79,600
2018 $4,667 $97,200 $32,000 $65,200
2017 $4,438 $98,400 $31,400 $67,000
2016 $1,979 $97,400 $33,300 $64,100
2015 $1,979 $89,700 $52,650 $37,050
2014 $1,979 $87,600 $53,900 $33,700
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Greater Lansing Association of Realtors®

MLS Number: 275105

Greater Lansing Association of Realtors®

APN: 02-02-16-327-029