$520,000

5723 Londonberrie Ct Midland, MI 48640

Estimated payment $2,772/month

Total Views 9,665
5 Beds
4.5 Baths
4,664 Sq Ft
$111 Price per Sq Ft

Highlights

  • Hot Property
  • Deck
  • Cathedral Ceiling
  • Woodcrest Elementary School Rated A-
  • Traditional Architecture
  • 4-minute walk to Chippewassee Park

About This Home

Step inside this well cared for 3314 sq ft, two story home that has blended elements of both traditional and contemporary architectural design! As you enter this home, the second story balcony greets you and provides stunning views of the 2 story foyer and the cathedral ceiling in the great room. This open floor plan are include the formal living room, dining room, great room, open staircase, and balcony. The kitchen was designed with the home chef in mind with an island cooking area, double ovens, great storage, and a breakfast nook. Enjoy a true retreat in the main floor, primary bedroom suite that includes 2 walk-in closets, a 5 piece bath that has stunning glass and black tile, jet tub, walk-in shower, double vanity, and a private entrance into the home office. The office has 2 sets of double doors that open into both the bedroom and great room, a wet bar and bay windows for peaceful views of the backyard. The 2nd story has a bedroom with a private ensuite bath and 2 bedrooms that share a jack & jill bathroom. The finished lower level includes a 33'x26' family room with newer vinyl plank flooring, daylight windows, a bar area, 5th bedroom that has a private entrance to the full basement bath. Additional highlights include a main floor laundry, a side-load 3 car garage, a private backyard with both a deck and brick paver patio. This home is conveniently located with in walking distance to 2 top rated schools: Woodcrest Elementary and H.H. Dow High School. Schedule your private showing today!

Listing Agent

Michelle Hill

Ayre Rhinehart Real Estate Partners License #MBR-6501332498 Listed on: 09/04/2025

Ayre Rhinehart Real Estate Partners

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 1994

Lot Details

  • 0.43 Acre Lot
  • Lot Dimensions are 122x155
  • Corner Lot
  • Sprinkler System

Home Design

  • Traditional Architecture
  • Poured Concrete
  • Wood Siding
  • Vinyl Siding
  • Stucco

Interior Spaces

  • 2-Story Property
  • Wet Bar
  • Cathedral Ceiling
  • Ceiling Fan
  • Skylights
  • Gas Fireplace
  • Window Treatments
  • Entryway
  • Great Room with Fireplace
  • Family Room
  • Living Room
  • Formal Dining Room
  • Den

Kitchen

  • Breakfast Area or Nook
  • Double Oven
  • Microwave
  • Dishwasher
  • Disposal

Flooring

  • Wood
  • Carpet
  • Ceramic Tile
  • Vinyl

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Main Floor Bedroom
  • Walk-In Closet
  • 4.5 Bathrooms
  • Hydromassage or Jetted Bathtub

Laundry

  • Laundry Room
  • Dryer
  • Washer

Finished Basement

  • Basement Fills Entire Space Under The House
  • Sump Pump
  • Basement Window Egress

Parking

  • 3 Car Attached Garage
  • Side Facing Garage
  • Garage Door Opener

Outdoor Features

  • Deck
  • Patio
  • Porch

Schools

  • Woodcrest Elementary School
  • Jefferson Middle School
  • Hh Dow High School

Utilities

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

Community Details

  • Walden Woods No 5 Subdivision

Listing and Financial Details

  • Assessor Parcel Number 14-05-70-550

Home Details

Home Type

Single Family

Est. Annual Taxes

$8

Year Built

Built in 1994

Lot Details

0

Listing Details

  • Originating MLS: Midland Board of REALTORS
  • Class: RESIDENTIAL
  • Type Of Property: Single Family
  • Architecture Style: Traditional
  • Structure Style: 2 Story
  • Total Tax Amount: 8811
  • Total Tax Year: 2025
  • Year Built: 1994
  • Mail City: Midland
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 2

Interior Features

  • Interior Amenities: 9 ft + Ceilings, Cathedral/Vaulted Ceiling, Ceramic Floors, Hardwood Floors, Spa/Jetted Tub, Sump Pump, Walk-In Closet, Wet Bar/Bar, Window Treatment(s), Skylights
  • Appliances: Dishwasher, Disposal, Dryer, Microwave, Range/Oven, Refrigerator, Washer
  • Fireplace: Yes
  • Fireplaces: Gas Fireplace, Grt Rm Fireplace
  • Basement: Yes
  • Basement: Egress/Daylight Windows, Finished, Full, Poured, Sump Pump
  • Bedrooms: 5
  • Bedroom 1: On 1st Floor, Dimensions: 19 x 14
  • Bedroom 1 Floor Covering: Carpet
  • Bedroom 2: On 2nd Floor, Dimensions: 15 x 13
  • Bedroom 2 Floor Covering: Carpet
  • Bedroom 3: On 2nd Floor, Dimensions: 13 x 13
  • Bedroom 3 Floor Covering: Carpet
  • Bedroom 4: On 2nd Floor, Dimensions: 15 x 13
  • Bedroom 4 Floor Covering: Carpet
  • Bedroom 5: On Lower Floor, Dimensions: 14 x 12
  • Bedroom 5 Floor Covering: Vinyl
  • Full Bathrooms: 4
  • Total Bathrooms: 5
  • Bathroom 1: Dimensions: 14 x 14, On Level: First, Flooring: Ceramic
  • Bathroom 2: Dimensions: 10 x 10, On Level: Second, Flooring: Ceramic
  • Bathroom 3: Dimensions: 10 x 8, On Level: Second, Flooring: Ceramic
  • Bathroom 4: Dimensions: 14 x 12, On Level: Basement, Flooring: Ceramic
  • Room Types: Den/Study/Lib, Entry, Family Room, First Floor Laundry, First Flr Primary Bedroom, Living Room, Utility/Laundry Room, Basement Full Bath, First Flr Lavatory, Primary Bdrm Suite, Second Flr Full Bathroom, Shared Bathroom, Breakfast Nook/Room, Formal Dining Room
  • Dining Room: On 1st Floor, Dimensions: 14 x 13
  • Dining Room Floor Covering: Carpet
  • Family Room: In Basement, Dimensions: 33 x 26
  • Family Room Floor Covering: Vinyl
  • Great Room: On 1st Floor, Dimensions: 22 x 18
  • Great Room Floor Covering: Ceramic
  • Kitchen: On 1st Floor, Dimensions: 22 x 14
  • Kitchen Floor Covering: Wood
  • Laundry: On 1st Floor
  • Laundry Room Floor Covering: Ceramic
  • Library Den: On 1st Floor, Dimensions: 13 x 13
  • Library Den Floor Covering: Carpet
  • Living Room: On 1st Floor, Dimensions: 13 x 13
  • Living Room Floor Covering: Carpet
  • Below Grade Sq Ft: 2192
  • Finished Below Grade Sq Ft: 1350
  • Above Grade Finished Sq Ft: 3314
  • Total Finished Sq Ft: 4664
  • Half Bathrooms: 1

Exterior Features

  • Exterior: Vinyl Siding, Wood, Stucco
  • Exterior Features: Deck, Lawn Sprinkler, Patio, Porch, Sidewalks
  • Foundation: Basement
  • Frontage: 122
  • Road: City/County, Paved Street
  • Frontage Type: Road

Garage/Parking

  • Garage: Attached Garage, Gar Door Opener, Side Loading Garage
  • Garage Spaces: 3
  • Parking: Garage
  • Garage: Yes

Utilities

  • Heating: Forced Air
  • Heating Fuel: Natural Gas
  • Sewer: Public Sanitary
  • Water: Public Water
  • Water Heater: Gas
  • Cooling: Ceiling Fan(s), Central A/C

Schools

  • Elementary School: Woodcrest
  • Middle School: Jefferson
  • High School: HH Dow

Lot Info

  • Assessor Parcel Number: 14-05-70-550
  • Zoning: Residential
  • Lot Dimensions: 122x155
  • Acreage: 0.43
  • Geo Subdivision: MI
  • Site/Lot Features: Corner Lot, Subdivision, Walk to School, Sidewalks, City Limits

Tax Info

  • Summer Tax: Year: 2025, Amount: $6,895.82
  • Winter Tax: Year: 2024, Amount: $1,915.18
  • Total Tax: Year: 2025, Amount: $8,811.00

MLS Schools

  • Elementary School: Woodcrest
  • Middle School: Jefferson
  • School District: Midland Public Schools
  • HighSchool: HH Dow

Map

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

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,605 $274,100 $0 $0
2024 $6,690 $250,100 $0 $0
2023 $6,376 $223,500 $0 $0
2022 $7,827 $194,200 $0 $0
2021 $7,546 $197,700 $0 $0
2020 $7,624 $189,500 $0 $0
2019 $7,447 $187,300 $27,500 $159,800
2018 $7,213 $222,700 $30,000 $192,700
2017 $0 $183,700 $30,000 $153,700
2016 $7,462 $183,500 $30,000 $153,500
2012 -- $253,000 $30,000 $223,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
09/04/2025 09/04/25 For Sale $520,000 -- $111 / Sq Ft
Source: Midland Board of REALTORS®

About the Listing Agent

Michelle Hill

Ayre Rhinehart Real Estate Partners

(989) 447-4783

Section Image

Whether you are a buyer or a seller, it is more important than ever to have an objective third party by your side to help you stay focused on the issues most important to you. Michelle’s clients are always her top priority. As a Midland resident for more than 41 years, Michelle has put her boundless energy to work in many areas in the community she loves. Some of these include leading Boy Scouts (and having all three sons become Eagle Scouts!), MADD, Midland Cancer Services, local schools, and

Michelle's Other Listings

  • 715 State St, Midland, MI 48640

    $180,000 Open Sat 1PM - 2:30PM

    • 3 Beds
    • 1 Bath
    • 1,098 Sq Ft
    • 715 State St
    • Midland, MI

    Located conveniently close to downtown Midland, the Midland Community Center, and Central Park School, this recently updated 3 bedroom, 1 bath bungalow is ready for you to call it your own. Updates include Mitsubishi mini split AC/heat, newer windows, bath, exterior doors, garage doors, and flooring, with a fenced, landscaped yard and 2.5 car garage. Schedule your showing today!

    Michelle Hill Ayre Rhinehart Real Estate Partners

    Section Image
  • 3390 W Mcnally Rd, Coleman, MI 48618

    $315,000 Pending

    • 3 Beds
    • 2 Baths
    • 2,038 Sq Ft
    • 3390 W Mcnally Rd
    • Coleman, MI

    If heaven on earth exists, it's here in this home, on this property! This raised ranch 3 bedroom, 2 bath home overlooks a 1+ acre of lawn, settled in the midst of an 11 acre wooded parcel of land that is 20 minutes to Midland and 10 minutes to Mt Pleasant. This home has an open floor plan, vaulted ceilings in the living room, dining area and kitchen. The wall of windows and sliders in the living

    Michelle Hill Ayre Rhinehart Real Estate Partners

    Section Image
  • 2710 Longfellow Ln, Midland, MI 48640

    $377,000 Sold Jul 31, 2025

    • 4 Beds
    • 3.5 Baths
    • 3,484 Sq Ft
    • 2710 Longfellow Ln
    • Midland, MI

    Welcome to this beautifully maintained 4 bedroom, 3.5 bath traditional home located in the heart of Midland. With 2,484 sq ft of living space, this home offers comfort, style, and convenience in one of Midland's most desirable neighborhoods. Step inside to find a large kitchen featuring granite countertops, perfect for cooking and entertaining. With freshly refinished hardwood flooring, this home

    Michelle Hill Ayre Rhinehart Real Estate Partners

  • 5709 Sturgeon Ave, Midland, MI 48640

    $307,000 Sold Jul 18, 2025

    • 3 Beds
    • 2 Baths
    • 2,184 Sq Ft
    • 5709 Sturgeon Ave
    • Midland, MI

    Wow! All the work is done and the only job left to do is to move in!! This open floor plan, 3 bedroom, 2 bath home has been completely updated. With a bright white kitchen that includes granite counter tops, large island, that opens to the dining room and living room the living options are endless. Two bedrooms and full bath are located on the first floor. The basement has a private primary

    Michelle Hill Ayre Rhinehart Real Estate Partners

  • 2707 Valorie Ln, Midland, MI 48640

    $231,500 Sold Sep 20, 2024

    • 4 Beds
    • 1.5 Baths
    • 2,048 Sq Ft
    • 2707 Valorie Ln
    • Midland, MI

    The work is all done and all that needs to be done is to enjoy this open floor plan home! The living room has a southern exposure with double doors to the fenced backyard. The basement has been completely remodeled and fully finished to add an additional 1024' of living space to this great ranch home that is located close to Woodcrest school and park. The updates include the following items

    Michelle Hill Ayre Rhinehart Real Estate Partners

  • 2220 N Eastman Rd, Midland, MI 48642

    $255,000 Sold Jun 06, 2025

    • 3 Beds
    • 2 Baths
    • 3,768 Sq Ft
    • 2220 N Eastman Rd
    • Midland, MI

    Zoned Comercial B. The house is residential and is grandfathered into the zoning as residential as long as the current structure remains standing. This 3 bedroom, 2 bath, 1961 home built by a builder for his personal use, has many custom features that are unique and very useful. The washer, dryer, and hot water heater were replaced in 2017. Walk-out basement, heated workshop in the garage,

    Michelle Hill Ayre Rhinehart Real Estate Partners

  • 505 Adams Dr, Midland, MI 48642

    $310,000 Sold Jul 23, 2025

    • 3 Beds
    • 3 Baths
    • 2,549 Sq Ft
    • 505 Adams Dr
    • Midland, MI

    Welcome to this beautifully updated 3 bedroom, 3 bath, brick ranch offering 1,800 sq ft of comfortable living space in a highly desirable neighborhood. Just a short walk from one of the area's premier elementary schools, this home is perfect for those seeking convenience and quality. Step inside to find a bright and spacious layout featuring an updated kitchen with granite countertops, farmhouse

    Michelle Hill Ayre Rhinehart Real Estate Partners

  • 5708 Evergreen St, Midland, MI 48642

    $292,000 Sold Apr 01, 2025

    • 4 Beds
    • 2.5 Baths
    • 2,962 Sq Ft
    • 5708 Evergreen St
    • Midland, MI

    Step back into the groovy days of the 1960's into this completely retro 3 bedroom, 2.5 bath all brick ranch home with a full party pad basement and a 2.5 car attached garage! All of the details that make this a truely unique home have all been lovingly preserved and improved on with updates that enhance, but not detract. The birch cabinetry in the kitchen, kitchenette, bathrooms, and built-ins

    Michelle Hill Ayre Rhinehart Real Estate Partners

  • 1801 E Wheeler St, Midland, MI 48642

    $129,000 Sold Nov 19, 2024

    • 2 Beds
    • 1 Bath
    • 836 Sq Ft
    • 1801 E Wheeler St
    • Midland, MI

    This amazing 2 bedroom, 1 bath home is ready for you. With a new roof, 3 windows in 2023, living rm carpet in 2022, and new paint on deck and porch, 2024. There is almost an acre to spread out and create new dreams. Call for your personal showing today!

    Michelle Hill Ayre Rhinehart Real Estate Partners

Source: Midland Board of REALTORS®

MLS Number: 50187331

Midland Board of REALTORS®

APN: 14-05-70-550