$530,000
SOLD AUG 14, 2014

2139 N Celena Dr Midland, MI 48642

4 Beds
4 Baths
3,760 Sq Ft
2 Acres

Recently Sold

$141 Per Sq Ft

9% Below List Price

54 Days on Market

Highlights

  • In Ground Pool
  • 2 Acre Lot
  • Fireplace
  • Siebert School Rated A-
  • Deck
  • Porch

About This Home

As of March 2017

EXECUTIVE 2 story is the perfect entertaining home! As you enter the fabulous foyer, the views draw you in and you may never want to leave! Wonderful highlights include 3760 square feet, gourmet kitchen with sleek black cabinets and granite, newer stainless appliances, bright breakfast nook, main floor laundry room with new sink and counter, main floor master suite with sitting area and completely renovated master bathroom, indoor heated, variable speed endless lap pool right off the master bath, 3 upstairs bedrooms; 1 with en suite bath; other 2 bedrooms share a new Jack & Jill bath, newer lighting and fixtures throughout, full 2500 square foot fully finished walk-out basement has a new office with daylight window, and an amazing theater room, exercise area, full bathroom. There is also a spacious deck, patio, newer roof and insulation, water softener, all on 2 acres in Larkin Twp! Owners substantially and tastefully updated their home and have meticulously maintained it!

Last Agent to Sell the Property

Badger Beall

Ayre Rhinehart Real Estate Partners License #MBR-6502367320 Listed on: 04/24/2014

Ayre Rhinehart Real Estate Partners

Last Buyer's Agent

Mirs Staff

MiRealSource Michigan MLS License #MISPE

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 1995

Lot Details

  • 2 Acre Lot
  • Sprinkler System

Home Design

  • Brick Exterior Construction
  • Poured Concrete
  • Wood Siding

Interior Spaces

  • Fireplace
  • Entryway
  • Finished Basement
  • Walk-Out Basement
  • Home Security System

Kitchen

  • Oven or Range
  • Microwave
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms
  • 4 Full Bathrooms

Parking

  • 3.5 Car Attached Garage
  • Heated Garage
  • Garage Door Opener

Outdoor Features

  • In Ground Pool
  • Deck
  • Patio
  • Porch

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Gas Water Heater
  • Septic Tank

Listing and Financial Details

  • Assessor Parcel Number 090-161-500-160-00

Home Details

Home Type

Single Family

Est. Annual Taxes

$6

Year Built

Built in 1995

Lot Details

0

Listing Details

  • Originating MLS: Midland Board of Realtors
  • Class: RESIDENTIAL CONDO
  • Type Of Property: Residential
  • Total Tax Amount: 6104.31
  • Year Built: 1995
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Interior Amenities: Security System
  • Appliances: Dishwasher, Disposal, Microwave, Range/Oven, Refrigerator
  • Fireplace: Yes
  • Basement: Yes
  • Basement: Finished, Walk Out, Poured
  • Bedrooms: 4
  • Bedroom 1: Dimensions: 21 x 16
  • Bedroom 2: Dimensions: 12 x 14
  • Bedroom 3: Dimensions: 13 x 14
  • Bedroom 4: Dimensions: 13 x 13
  • Full Bathrooms: 4
  • Total Bathrooms: 5
  • Room Types: Entry, First Floor Laundry, First Floor Mstr Bedroom, Master Bedroom
  • Dining Room: Dimensions: 16 x 12
  • Kitchen: Dimensions: 20 x 18
  • Laundry: Dimensions: 8 x 11
  • Library Den: Dimensions: 12 x 14
  • Living Room: Dimensions: 30 x 17
  • Finished Below Grade Sq Ft: 2500
  • Half Bathrooms: 1
  • Above Grade Finished Sq Ft: 3760

Exterior Features

  • Pool: Yes
  • Exterior: Brick, Wood
  • Exterior Features: Deck, Inground Pool, Lawn Sprinkler, Patio, Porch
  • Foundation: Basement

Garage/Parking

  • Garage: Attached Garage, Gar Door Opener, Heated Garage
  • Garage Spaces: 3.5
  • Garage: Yes

Utilities

  • Heating: Forced Air
  • Heating Fuel: Natural Gas
  • Sewer: Septic
  • Water: Private Well
  • Water Heater: Gas
  • Cooling: Central A/C

Lot Info

  • Assessor Parcel Number: 090-161-500-160-00
  • Lot Dimensions: Irregular
  • Acreage: 2
  • Geo Subdivision: MI

Tax Info

  • Summer Tax: Amount: $2,743.48
  • Winter Tax: Amount: $3,360.83
  • Total Tax: Amount: $6,104.31

MLS Schools

  • School District: Midland Public Schools

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jan 22, 2016
Closed on
Mar 29, 2017
Sold by
Alfani Adriano and Laspada Maria La
Bought by
Simmons Patrick R and Simmons Mindy K
Seller's Agent
Sofia Edmonds
Ayre Rhinehart Real Estate Partners
Buyer's Agent
Linda Sarmiento
Berkshire Hathaway HomeServices Michigan Real Estate
List Price
$525,000
Sold Price
$430,000
Premium/Discount to List
-$95,000
-18.1%
Current Estimated Value
$778,752

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$348,752
Avg. Annual Appreciation
7.33%

Purchase Details

Listed on
Apr 24, 2014
Closed on
Aug 14, 2014
Sold by
Bolland Stuart M and Bolland Joanne
Bought by
Alfani Adriano and Laspada Maria La
Seller's Agent
Badger Beall
Ayre Rhinehart Real Estate Partners
Buyer's Agent
Mirs Staff
MiRealSource Michigan MLS
List Price
$585,000
Sold Price
$530,000
Premium/Discount to List
-$55,000
-9.4%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
-7.67%

Purchase Details

Closed on
Jul 19, 2011
Sold by
Allison Brian R and Allison Barbara L H
Bought by
Bolland Stuart M and Bolland Joanne H

Purchase Details

Closed on
Apr 27, 2010
Sold by
Escudero Alfonso Et Ux *Trusts*
Bought by
Primacy Closing Corp and Allison Barbara L H

Purchase Details

Closed on
Nov 4, 1996
Sold by
Earl D Bennett Const Inc
Bought by
Escudero Alfonso
Source: Public Records

Similar Homes in Midland, MI

  • 110 Brass Leaf Ct, Midland, MI 48642

    $496,700

    • 3 Beds
    • 2 Baths
    • 1,711 Sq Ft
    • 110 Brass Leaf Ct
    • Midland, MI

    Built by Cobblestone Homes, this energy-efficient condo blends modern style with urban farmhouse charm. Offering 1,711 sq ft of open-concept living, the thoughtful split-bedroom layout provides privacy, with the spacious primary suite set apart from the two additional bedrooms. The primary features a large walk-in closet, a striking tray ceiling with painted wood beams, and a luxurious ensuite

    Tim Corcoran Cobblestone Realty LLC

    Section Image
  • 2018 N Harvest Cir, Midland, MI 48642

    $565,000

    • 4 Beds
    • 2.5 Baths
    • 2,373 Sq Ft
    • 2018 N Harvest Cir
    • Midland, MI

    2018 Harvest Circle – Quality Craftsmanship and Comfort in Larkin Township Located in peaceful Larkin Township, this craftsman-style Cobblestone Homes build combines quality construction, smart design, and modern finishes. Set on a beautifully landscaped 1-acre lot, the home offers everyday comfort in a quiet, well-kept neighborhood—just minutes from Midland schools, shopping, and parks.

    Peter Baiardi Ayre Rhinehart Real Estate Partners

    Section Image
  • 3727 E Julie Ann Dr, Midland, MI 48642

    $455,000

    • 4 Beds
    • 3.5 Baths
    • 3,720 Sq Ft
    • 3727 E Julie Ann Dr
    • Midland, MI

    Let's talk Larkin Luxury! This classic and beautiful 3,032 square foot Larkin Township home offers an abundance of charm, designed with an eye for entertaining. Set on a 1.35 acre lot near the end of a quiet cul-de-sac, the exterior has many of the hallmarks of a traditional Colonial, like a beautiful back deck overlooking a large wooded lot with block fire pit and shed, but also holds unique

    Bethany Law Modern Realty

    Section Image
  • 2188 N Rolling Ridge Dr, Midland, MI 48642

    $615,000

    • 4 Beds
    • 3.5 Baths
    • 4,021 Sq Ft
    • 2188 N Rolling Ridge Dr
    • Midland, MI

    Welcome to Rolling Ridge Dr. in Pine Hollow Estates! This beautiful home features four bedrooms and four bathrooms, offering both excellent utility and plenty of privacy. Inside, you'll find a spacious kitchen with ample cabinet and counter space. The primary bedroom on the first floor is generously sized, complete with an en-suite bathroom and walk in closet. The open-concept living room boasts

    Adam Sinclair Bay Valley Realty

    Section Image
  • 701 Broadhead Dr, Midland, MI 48642

    $509,000

    • 3 Beds
    • 2 Baths
    • 1,727 Sq Ft
    • 701 Broadhead Dr
    • Midland, MI

    NEWLY BUILT & BEAUTIFUL ON BROADHEAD! This thoughtfully designed 1,727 square foot ranch on a quiet cul-de-sac was built by Lifestyle Home Builders & Design and features 3 bedrooms, 2 full bathrooms with a floor plan that seamlessly blends style and function. The home offers a vaulted great room with a fireplace as the centerpiece. The open kitchen concept includes a large pantry and island

    Logan Richetti Modern Realty

    Section Image
  • 4117 E Old Pine Trail, Midland, MI 48642

    $620,000

    • 5 Beds
    • 3.5 Baths
    • 4,525 Sq Ft
    • 4117 E Old Pine Trail
    • Midland, MI

    *Open House Saturday, 8/2 10am-11:30am Welcome to this completely updated contemporary masterpiece offering over 4,500 sq ft of beautifully designed living space, nestled on a private 1.2-acre wooded lot. With 5 spacious bedrooms, 3.5 luxurious baths, and a layout designed for both comfort and entertaining this home is anything but ordinary. From the moment you step inside, you’ll be captivated

    Tina Patnode Century 21 Signature Realty Midland

    Section Image
  • 3650 E Jane Dr, Midland, MI 48642

    $415,000

    • 4 Beds
    • 2.5 Baths
    • 2,481 Sq Ft
    • 3650 E Jane Dr
    • Midland, MI

    TRADITIONAL BEAUTY tucked into the heart of an established Larkin Township neighborhood with a true “up north” feel — this is a home you’ll be proud to call your own. Set on a picturesque lot this beautifully maintained 2-story home offers timeless style, peaceful surroundings, and the convenience of being just minutes from Midland’s shopping, dining, and schools. Crafted with classic cedar

    Stephanie Fischer Ayre Rhinehart Real Estate Partners

    Section Image
  • 6202 Shirewood Cir, Midland, MI 48642

    $582,000

    • 4 Beds
    • 3.5 Baths
    • 3,629 Sq Ft
    • 6202 Shirewood Cir
    • Midland, MI

    SO MUCH TO OFFER ON SHIREWOOD! This Flora Homes built modern day colonial offers 4 bedrooms, 3 full baths and 1 half bath located on .38 acres in the highly desirable Scenic Estates neighborhood. With 2819 sqft above grade and 810 sqft finished below grade (3629 total finished) you'll enjoy having plenty of room for your family. Features like 10' ceilings, cherry hardwood floors, tray ceilings,

    Matt Smith Modern Realty

    Section Image
  • 3954 E Marilyn Ln, Midland, MI 48642

    $599,900

    • 3 Beds
    • 2.5 Baths
    • 1,817 Sq Ft
    • 3954 E Marilyn Ln
    • Midland, MI

    Stunning Ranch by Cobblestone Homes on Over an Acre! This 1,817 sq ft 3-bed, 2.5-bath open-concept ranch offers luxurious finishes and energy-efficient features throughout. Nestled on a spacious lot with mature trees, this home boasts vaulted ceilings with stained oak beams, a stone-wrapped fireplace, quartz countertops, soft-close cabinetry, and a stylish tile backsplash. The primary suite

    Tim Corcoran Cobblestone Realty LLC

    Section Image

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 Type Sale Price Title Company
Warranty Deed $43,000,000 None Available
Warranty Deed $530,000 --
Warranty Deed $525,000 --
Warranty Deed $489,400 --
Warranty Deed $370,000 --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $395,487 VA
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
03/29/2017 03/29/17 Sold $430,000 -18.1% $114 / Sq Ft
03/13/2017 03/13/17 Pending -- -- --
01/22/2016 01/22/16 For Sale $525,000 -0.9% $140 / Sq Ft
08/14/2014 08/14/14 Sold $530,000 -9.4% $141 / Sq Ft
06/17/2014 06/17/14 Pending -- -- --
04/24/2014 04/24/14 For Sale $585,000 -- $156 / Sq Ft
Source: Midland Board 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
2025 $8,166 $371,400 $0 $0
2024 $3,176 $362,600 $0 $0
2023 $3,025 $317,900 $0 $0
2022 $7,448 $271,400 $0 $0
2021 $7,090 $265,400 $0 $0
2020 $7,300 $267,200 $0 $0
2019 $7,113 $241,900 $0 $0
2018 $6,867 $241,900 $241,900 $0
2017 $0 $242,900 $242,900 $0
2016 $6,790 $252,200 $252,200 $0
2014 -- $239,800 $239,800 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: Midland Board of REALTORS®

MLS Number: 140779

Midland Board of REALTORS®

APN: 090-161-500-160-00