Welcome to luxurious collection of 2 Story high end Ravine town homes with finished basement located in the South of London, These townhomes feature all high-end finishes with a contemporary touch. These luxurious towns come with upgrades such as a custom glass shower in the master ensuite, high-end flooring, quartz kitchen countertops, quartz tops in all washrooms designer light fixtures massive backyards ravine lots no house on the back . This Property Is Surrounded By Schools, Shopping Malls, Parks, Banks, Restaurants, And Is Minutes Away From The Public Transit . This property features dining having patio doors leading to your own private backyard with patio deck included! Heading upstairs you will be greeted with a spacious landing area where you will find 3 generous-sized bedrooms. Primary bedrooms boasts large walk-in closet and spa like ensuite bath, double vanity and walk-in shower. Finished Basement having Beautiful Living, Bedroom , Kitchen and Full washroom. (id:55598)
- MLS® 40578257
- Date Listed04/25/2024
- Days on Realty 81 Days
- Bedrooms 4
- Bathrooms 1 Half baths
- Lot Size -
- Sewer Public Sewer
- Property Type Single Family Residence
- Water Public
- Square Feet 1,577 sq. ft
- Price Per Sq. Ft $440.65
Interior Features
- Cooling Central Air Conditioning
- Heating Forced Air
Exterior / Lot Features
- Roof -
- Lot Size Acres -
- Lot Size SQFT -
- Lot Features -
Nearby Schools
Source: School Digger
École élémentaire La Pommeraie
Public • PK - 5
1.03 km
Distance
Public • PK - 8
1.68 km
Distance
Public • PK - 8
3.46 km
Distance
Public • PK - 8
3.74 km
Distance
Public • PK - 8
3.74 km
Distance
Public • PK - 8
3.46 km
Distance
St. George Catholic Elementary School
Public • PK - 8
4.51 km
Distance
Public • PK - 8
4.22 km
Distance
Public • PK - 8
4.81 km
Distance
Public • PK - 8
5.58 km
Distance
Public • 6 - 8
10.25 km
Distance
Lester B. Pearson School for the Arts
Public • 6 - 8
10.05 km
Distance
Public • 9 - 12
3.74 km
Distance
Public • 9 - 12
5.12 km
Distance
St. Thomas Aquinas Secondary School
Public • 9 - 12
5.58 km
Distance
Public • 9 - 12
6.55 km
Distance
London South Collegiate Institute
Public • 9 - 12
8.09 km
Distance
London Central Secondary School
Public • 9 - 12
9.73 km
Distance
Public • 9 - 12
9.73 km
Distance
Public • 9 - 12
10.25 km
Distance
Wheable Adult Education Centre
Public • 9 - 12
9.37 km
Distance
Public • 9 - 12
10.05 km
Distance
Private • PK - 8
2.39 km
Distance
Our Lady of Lourdes Separate School
Private • PK - 8
4.93 km
Distance
Sales & Tax History
Source: Public Records
Street Address | Beds | Baths | Sold Date | List Price |
---|---|---|---|---|
LOT 131 Big Leaf Trail, London ON N6P 1H5 | 4 | 3 | Jun 10, 2024 | $979,900 |
LOT 129 Big Leaf Trail, London ON N6P 1H5 | 4 | 3 | Jun 10, 2024 | $979,900 |
LOT 130 Big Leaf Trail, London ON N6P 1H5 | 4 | 3 | Jun 10, 2024 | $979,900 |
7345 Silver Creek Circle, London ON N6P 0G8 | 5 | 5 | Jun 10, 2024 | $1,999,900 |
2-3557 Colonel Talbot Road, London ON N6P 1H6 | 4 | 4 | Jun 15, 2024 | $729,900 |
LOT 60 7132 Silver Creek Circle, London ON N6P 0G9 | 4 | 5 | Jun 10, 2024 | $1,799,900 |
1-3557 Colonel Talbot Road, London ON N6P 1H6 | 4 | 4 | Jun 15, 2024 | $779,900 |
3909 Big Leaf (Lot 113) Trail, London ON N6P 0A3 | 4 | 3 | Jun 03, 2024 | $899,800 |
6631 Royal Magnolia Avenue, London ON N6P 0J5 | 3 | 3 | Jun 10, 2024 | $729,900 |
6639 Royal Magnolia Avenue, London ON N6P 0J5 | 3 | 3 | Jun 10, 2024 | $689,900 |
18/100
Car-Dependent
Walk Score ®
10/100
Minimal Transit
Transit Score ®
28/100
Bikable
Bike Score ®
Overview
Almost all errands require a car. It is possible to get on a bus. Minimal bike infrastructure.Transit Summary
1 nearby routes: 1 bus, 0 rail, 0 other
Walkability averages in the surrounding area
The average walkability score in the surrounding area is Walk Score: 32/100, Transit Score: 27/100, Bike Score: 41/100.
Points of interest near 3557 COLONEL TALBOT Road Unit# 7, London, ON N6P1H6
Royal Canadian Legion Hall, London, ON, Canada
Education Entertainment
0.8 km
Distance
London Public Library - Lambeth, London, ON, Canada
Education Entertainment
1.37 km
Distance
1.42 km
Distance
Lambeth Arena, London, ON, Canada
Recreation • Education Entertainment
1.42 km
Distance
1.6 km
Distance
1.27 km
Distance
Shoppers Drug Mart, London, ON, Canada
Health Retail
1.47 km
Distance
Retail Food
1.52 km
Distance
1.62 km
Distance
Food • Retail • Nightlife
1.63 km
Distance
Vanderlinder Parkette, London, ON, Canada
Recreation
1.37 km
Distance
Lambeth Arena, London, ON, Canada
Recreation • Education Entertainment
1.42 km
Distance
Talbot Park, London, ON, Canada
Recreation
1.47 km
Distance
Raleigh Park, London, ON, Canada
Recreation
1.47 km
Distance
Lambeth Centennial Park, London, ON, Canada
Recreation
1.54 km
Distance
Royal Canadian Legion Hall, London, ON, Canada
Education Entertainment
0.8 km
Distance
London Public Library - Lambeth, London, ON, Canada
Education Entertainment
1.37 km
Distance
Lambeth Arena, London, ON, Canada
Recreation • Education Entertainment
1.42 km
Distance
0.81 km
Distance
1.62 km
Distance
1.67 km
Distance
Retail Food
1.52 km
Distance
Food • Retail • Nightlife
1.63 km
Distance
Shoppers Drug Mart, London, ON, Canada
Health Retail
1.47 km
Distance
TD Canada Trust, London, ON, Canada
Finance Professional
1.6 km
Distance
TD Canada Trust, London, ON, Canada
Finance Professional
1.6 km
Distance
Food • Retail • Nightlife
1.63 km
Distance
1.17 km
Distance
1.5 km
Distance
Nearby Properties
-
$694,900 Active
4 bds • 4 ba • 1,577 sqft
7-3557 Colonel Talbot Road, London ON N6P 1H6, London, ON N6P 1H6
Welcome to luxurious collection of 2 Story high end Ravine town homes with finished basement located in the South of London, These townhomes feature all high-end finishes with a contemporary touch. These luxurious towns come with upgrades such as a c...Listing by: Rizwan Sadiq - Keller Williams Legacies Realty Brokerage -
$664,900 Active
4 bds • 4 ba • 1,577 sqft
3557 COLONEL TALBOT Road Unit# 6, London, ON N6P1H6
Introducing luxurious collection of 2 Story high end town homes with finished basement located in the South of London where luxury meets convenience. High-end upgrades with a contemporary touch included in the price with value of over $70, 000. These...Listing by: RIZWAN SADIQ - KELLER WILLIAMS LEGACIES REALTY -
$664,900 Active
4 bds • 4 ba • 1,577 sqft
6-3557 Colonel Talbot Road, London ON N6P 1H6, London, ON N6P 1H6
Introducing luxurious collection of 2 Story high end town homes with finished basement located in the South of London where luxury meets convenience. High-end upgrades with a contemporary touch included in the price with value of over $70, 000. These...Listing by: Rizwan Sadiq - Keller Williams Legacies Realty Brokerage -
New$649,800 Active
3 bds • 3 ba • 1,525 sqft
LOT 118 Heathwoods Avenue, London ON N6P 1H5, London, ON N6P 1H5
**SALES OFFICE HOURS Tuesday & Thursday: 4:00PM -7:00PM; Saturday & Sunday: 1:00PM 5:00PM At 3 Queensbrook Cres, Cambridge.** Welcome To This Stunning Freehold Townhome In The Desirable Community Of Lambeth. Boasting 3 Bedrooms And 2.5 Baths, This Ho...Listing by: Vongdeuane Kennedy - PSR -
$674,800 Active
3 bds • 3 ba • 1,525 sqft
LOT 116 TBD Heathwoods Avenue, London ON N6P 1H5, London, ON N6P 1H5
***SALES OFFICE HOURS Tuesday & Thursday: 4:00PM-7:00PM; Saturday & Sunday: 1:00PM-5:00PM At 3 Queensbrook Cres, Cambridge** Experience Luxury Living At Its Finest In This Exquisite End-Unit Freehold Townhome Nestled In Lambeth's Sought-After Communi...Listing by: Vongdeuane Kennedy - PSR -
$659,900 Active
3 bds • 3 ba • 1,745 sqft
6686 Hayward Drive, London ON N6P 0H7, London, ON N6P 0H7
FREEHOLD TOWNHOMES AVAILABLE FOR RESERVATION NOW; CLOSING DECEMBER 2024! This 1, 745 SqFt Townhome features 9' Ceilings on the Main Floor & Many Upgraded Standard Finishes. Three Bedrooms, Two Full Baths, and a Tiled Upstairs Laundry Room comprise th...Listing by: Patrick Hazzard - CENTURY 21 FIRST CANADIAN CORP., BROKERAGE -
$749,000 Active
3 bds • 3 ba • 1,760 sqft
6441 Royal Magnolia Avenue, London ON N6P 1H5, London, ON N6P 1H5
Welcome to your next home in the heart of Lambeth, where charm meets convenience! Nestled in one of the most coveted neighbourhoods, this detached gem boasts easy access to major highways, ensuring your commute is a breeze. Step inside and be greeted...Listing by: Richard Leitao - BLUE FOREST REALTY INC. -
$759,900 Active
3 bds • 3 ba • 1,632 sqft
3245 Maidstone Lane, London ON N6P 1V6, London, ON N6P 1V6
Presenting your rare opportunity to live in this immaculately maintained gem situated in one of London's most sought after neighborhoods in Talbot Village! This spacious multi level beauty sits on a premium walk-out lot and is sure to impress. You en...Listing by: Navid Akmal-Sisan - ZOLO REALTY, BROKERAGE -
$649,900 Active
3 bds • 2 ba • 1,649 sqft
4220 Colonel Talbot Road, London ON N6P 1A1, London, ON N6P 1A1
Welcome to Lovely Lambeth! This beautiful bungalow is loaded with Charm and Character. There are 3 bedrooms and 2 full bathrooms. The large living room features craftsman plastered ceilings and a gas fireplace. You will be WOWED by the impressive 4 s...Listing by: Morag Mclean - SUTTON GROUP - SELECT REALTY INC., BROKERAGE -
$699,900 Active Under Contract
3 bds • 3 ba • 1,423 sqft
9-947 Adirondack Road, London ON N6K 4Y7, London, ON N6K 4Y7
Loaded with updates! Welcome to Westmount Pines, a small complex tucked away on a quiet street. Looks can be deceiving as this 3 bedroom, 3 bathroom unit with 1.5 car garage is much larger than it appears. Upon entry you will be greeted by a 10 foot...Listing by: Melissa Mason - RE/MAX ADVANTAGE REALTY LTD., BROKERAGE -
$799,000 Active
3 bds • 4 ba • 1,765 sqft
6-727 Apricot Drive, London ON N6K 5A7, London, ON N6K 5A7
Welcome to 6-727 Apricot Drive, a stylish and modern two-storey home located in the prestigious neighborhood of Byron. This meticulously designed property offers three spacious bedrooms, a double car garage with a double-wide driveway, a well-appoint...Listing by: Victor Deng - FOREST HILL REAL ESTATE INC. -
$669,900 Active
3 bds • 3 ba • 1,768 sqft
4297 Calhoun Way, London ON N6P 1J9, London, ON N6P 1J9
TO BE BUILT: FREEHOLD TOWNHOMES OF SOUTH LONDON! Liberty Crossing is a Brand-New Development on the Corner of Wonderland Rd S & Hamlyn St - Only 1.5 KM from 402! These Two-Storey Townhomes have an Open-Concept Main Floor Area with Eng. Hardwood/Tile...Listing by: Patrick Hazzard - CENTURY 21 FIRST CANADIAN CORP., BROKERAGE -
$729,900 Active Under Contract
3 bds • 4 ba • 1,771 sqft
11 Lynngate Grove, London ON N6K 3S7, London, ON N6K 3S7
THIS THREE BEDROOM TWO STORY WESTMOUNT HOME IS FAMILY READY. SPACIOUS MAIN FLOOR WITH COSY FAMILY ROOM, DINING AND LIVING ROOM WITH MAIN FLOOR LAUNDRY. THREE SPACIOUS BEDROOMS UPSTAIRS WITH A LARGE PRIMARY BEDROOM WITH ENSUITE AND WALK IN CLOSET. THE...Listing by: Steven George Baarda - ROYAL LEPAGE TRILAND REALTY -
$629,900 Active
3 bds • 2 ba • 1,405 sqft
526 Cranbrook Road, London ON N6K 2X3, London, ON N6K 2X3
Very unique, spotless, one floor living at its best! Prepare to be enchanted by this exquisite Westmount condo, meticulously renovated to dazzle the senses! Discover 4 patio doors drawing you to the two separate outdoor spaces, alongside a private at...Listing by: Volodymyr Vorobets - CANADIAN DREAM REALTY INC., BROKERAGE -
$639,900 Active Under Contract
4 bds • 3 ba • 1,450 sqft
10-500 Cranbrook Road, London ON N6K 4T3, London, ON N6K 4T3
A truly exceptional one floor condo. Situated on the premium end of the complex and backs onto single family homes. Steps away from beautiful Reservoir Park and all terrific amenities of Westmount. This very spacious condo features 9' ceiling, huge l...Listing by: Terry Lyn Stevens - ROYAL LEPAGE TRILAND REALTY -
$689,900 Active
3 bds • 3 ba • 1,480 sqft
26-681 Commissioners Road W, London ON N6K 4T9, London, ON N6K 4T9
Immaculate large and bright 2 + 1 bedroom on a quiet neighborhood in sought after Rosecliffe Ridge complex. Main floor features all hardwood flooring throughout, large great room with gas fireplace and door to rear deck with retractable awing to keep...Listing by: Joe Pinheiro - PINHEIRO REALTY LTD., BROKERAGE -
$629,900 Active
2 bds • 3 ba • 1,366 sqft
18-211 Pine Valley Drive, London ON N6J 4W5, London, ON N6J 4W5
This fabulous 1-floor townhome condo is located inside a quiet community in London’s Westmount neighbourhood. The main level is light and bright with large windows and open concept layout. The eat in kitchen offers lots of storage and a bay window th...Listing by: Michael Leff - ROYAL LEPAGE TRILAND REALTY -
$724,900 Active
4 bds • 2 ba • 1,560 sqft
467 Belvedere Place, London ON N6K 2G2, London, ON N6K 2G2
Located in Byron steps, away from Belvedere Park and situated on a quiet cul-de-sac lot, this home has a lot to offer. As you walk through this home you will appreciate how well it has been kept. Picture yourself spending time with family and friends...Listing by: Matt Gilboe - CENTURY 21 FIRST CANADIAN CORP., BROKERAGE -
$619,900 Active
3 bds • 3 ba • 1,747 sqft
14-3400 Castle Rock Place, London ON N6L 0E4, London, ON N6L 0E4
This beautiful end corner unit built by Rembrandt offers a perfect blend of comfort and style. The foyer features a closet, a 2-piece bathroom, and direct access to the garage. The main level boasts a spacious and bright interior with a modern kitche...Listing by: Hill Ham - KELLER WILLIAMS LIFESTYLES REALTY, BROKERAGE
Similar Priced Comparison
-
$694,900 Active
4 bds • 4 ba • 1577 sqft
7-3557 Colonel Talbot Road, London ON N6P 1H6
- Same size
- Lot larger by 153 sqft
- Unknown year built
Listing by: Rizwan Sadiq - Keller Williams Legacies Realty Brokerage -
$664,900 Active
4 bds • 4 ba • 1577 sqft
3557 COLONEL TALBOT Road Unit# 6
- Same size
- Unknown size
- Unknown year built
Listing by: RIZWAN SADIQ - KELLER WILLIAMS LEGACIES REALTY -
$664,900 Active
4 bds • 4 ba • 1577 sqft
6-3557 Colonel Talbot Road, London ON N6P 1H6
- Same size
- Lot larger by 153 sqft
- Unknown year built
Listing by: Rizwan Sadiq - Keller Williams Legacies Realty Brokerage -
$689,500 Active
3 bds • 3 ba • 1908 sqft
6873 Royal Magnolia Avenue, London ON N6P 1H5
- Home larger by 331 sqft
- Unknown size
- Unknown year built
Listing by: Mike Mcdonald - SUTTON GROUP - SELECT REALTY INC., BROKERAGE -
$659,000 Active
3 bds • 3 ba • 0 sqft
6901 ROYAL MAGNOLIA AVENUE E
- Home smaller by 1,577 sqft
- Unknown size
- Unknown year built
Listing by: ABRAR SHAMIM - RE/MAX REAL ESTATE CENTRE INC. -
$779,900 Active
3 bds • 3 ba • 2172 sqft
6461 Royal Magnolia Avenue, London ON N6P 1H5
- Home larger by 595 sqft
- Unknown size
- Newer by 2,024 years
Listing by: Devin Nadeau - ROYAL LEPAGE TRILAND REALTY -
$779,900 Active
3 bds • 3 ba • 2161 sqft
6465 Royal Magnolia Avenue, London ON N6P 1H5
- Home larger by 584 sqft
- Unknown size
- Newer by 2,024 years
Listing by: Devin Nadeau - ROYAL LEPAGE TRILAND REALTY -
$679,900 Active
3 bds • 3 ba • 1908 sqft
6795 Royal Magnolia Avenue, London ON N6P 1H5
- Home larger by 331 sqft
- Unknown size
- Newer by 2,023 years
Listing by: Sara Marisa Da Silva - CENTURY 21 FIRST CANADIAN CORP., BROKERAGE -
$659,900 Active
3 bds • 3 ba • 0 sqft
6893 ROYAL MAGNOLIA AVENUE
- Home smaller by 1,577 sqft
- Unknown size
- Unknown year built
Listing by: CALVIN BARRETT - SUTTON GROUP - SELECT REALTY -
New$649,800 Active
3 bds • 3 ba • 1525 sqft
LOT 118 Heathwoods Avenue, London ON N6P 1H5
- Home smaller by 52 sqft
- Unknown size
- Unknown year built
Listing by: Vongdeuane Kennedy - PSR -
$689,500 Active
3 bds • 3 ba • 0 sqft
6873 ROYAL MAGNOLIA AVENUE
- Home smaller by 1,577 sqft
- Unknown size
- Unknown year built
Listing by: MIKE MCDONALD - SUTTON GROUP - SELECT REALTY -
$659,900 Active
3 bds • 3 ba • 1908 sqft
6893 Royal Magnolia Avenue, London ON N6P 1H5
- Home larger by 331 sqft
- Unknown size
- Unknown year built
Listing by: Calvin Barrett - SUTTON GROUP - SELECT REALTY INC., BROKERAGE -
$709,900 Active
4 bds • 4 ba • 1908 sqft
6849 Royal Magnolia Avenue, London ON N6P 1H5
- Home larger by 331 sqft
- Unknown size
- Unknown year built
Listing by: Mike Mcdonald - SUTTON GROUP - SELECT REALTY INC., BROKERAGE -
$709,900 Active
4 bds • 4 ba • 0 sqft
6849 ROYAL MAGNOLIA AVENUE
- Home smaller by 1,577 sqft
- Unknown size
- Unknown year built
Listing by: MIKE MCDONALD - SUTTON GROUP - SELECT REALTY -
$694,900 Active
4 bds • 4 ba • 0 sqft
7-3557 COLONEL TALBOT RD ROAD
- Home smaller by 1,577 sqft
- Unknown size
- Unknown year built
Listing by: REHMAN KHAN - KELLER WILLIAMS LEGACIES REALTY -
$664,900 Active
4 bds • 4 ba • 0 sqft
6-3557 COLONEL TALBOT RD ROAD
- Home smaller by 1,577 sqft
- Unknown size
- Unknown year built
Listing by: REHMAN KHAN - KELLER WILLIAMS LEGACIES REALTY -
$699,900 Active
2 bds • 2 ba • 1281 sqft
6708 Hayward Drive, London ON N6P 0J5
- Home smaller by 296 sqft
- Unknown size
- Newer by 2,024 years
Listing by: Patrick Hazzard - CENTURY 21 FIRST CANADIAN CORP., BROKERAGE -
$799,000 Active
3 bds • 3 ba • 2510 sqft
3425 Grand Oak Crossing, London ON N6P 0G6
- Home larger by 933 sqft
- Unknown size
- Newer by 2,023 years
Listing by: Summit Sud - TRI CAPITAL REALTY INC., BROKERAGE -
$699,900 Active
2 bds • 3 ba • 1908 sqft
3425 Grand Oak Crossing, London ON N6P 0G6
- Home larger by 331 sqft
- Unknown size
- Newer by 2,023 years
Listing by: Summit Sud - TRI CAPITAL REALTY INC., BROKERAGE
Nearby Locations
Communities
- Lambeth Homes For Sale
- Talbot Homes For Sale
- Bostwick Homes For Sale
- Westmount Homes For Sale
- Longwoods Homes For Sale
- Byron Homes For Sale
- Southcrest Homes For Sale
- Highland Homes For Sale
- Oakridge Homes For Sale
- White Oak Homes For Sale
- West London Homes For Sale
- River Bend Homes For Sale
- Woodhull Homes For Sale
- South London Homes For Sale
- Hyde Oark Homes For Sale
- Westminister Homes For Sale
- London Homes For Sale
- Medway Homes For Sale
- Glen Carin Homes For Sale
- North London Homes For Sale
Nearby Cities
- Lambeth, ON Homes for Sale
- London, ON Homes for Sale
- Komoka, ON Homes for Sale
- Southwold, ON Homes for Sale
- St. Thomas, ON Homes for Sale
- Mount Brydges, ON Homes for Sale
- Ilderton, ON Homes for Sale
- Middlesex Centre, ON Homes for Sale
- Belmont, ON Homes for Sale
- Central Elgin, ON Homes for Sale
- Port Stanley, ON Homes for Sale
- Thames Centre, ON Homes for Sale
- Thorndale, ON Homes for Sale
- Dorchester, ON Homes for Sale
- Melbourne, ON Homes for Sale
- Lucan, ON Homes for Sale
- Dutton-dunwich, ON Homes for Sale
- Lucan Biddulph, ON Homes for Sale
- Granton, ON Homes for Sale
- Strathroy-caradoc, ON Homes for Sale
Similar Searches
- London Land for Sale
- London New Homes for Sale
- London Single Story Homes for Sale
- London Homes with Pools for Sale
- London Cheap Homes for Sale
- London Luxury Homes for Sale
- London Condos for Sale
- London Town Homes for Sale
- London Commercial for Sale
- London Open Houses for Sale
- London Two Car Garage Homes for Sale
- London Large Lots for Sale
- National Listings
- National Home Values
- Properties in ON
- Home Values in ON
- Home Values in London, ON
Frequently Asked Questions for 3557 COLONEL TALBOT Road Unit# 7
Source: Realty.com
3557 COLONEL TALBOT Road Unit# 7, London, ON N6P1H6 is a Single Family Residence, Residential property listed for $694,900 The property is 1577 sq. ft with 4 bedrooms and 4 bathrooms
Realty.com has 40 photos of 3557 COLONEL TALBOT Road Unit# 7.
The full address for this home is 3557 COLONEL TALBOT Road Unit# 7, London, ON N6P1H6.
3557 COLONEL TALBOT Road Unit# 7 has been listed on Realty.com since Thu April 25, 2024
Almost all errands require a car. It is possible to get on a bus. Minimal bike infrastructure.
The average walkability score in the surrounding area is Walk Score: 32/100, Transit Score: 27/100, Bike Score: 41/100.
Listing provided courtesy of:
KELLER WILLIAMS LEGACIES REALTY
(tel: (905) 669-2200)
Listing agent:
RIZWAN SADIQ
(tel: (647) 939-4875)
This content last refreshed on 2024-07-15 10:11:29. Some properties which appear for sale on this web site may subsequently have sold or may no longer be available.
Export listing data of 3557 COLONEL TALBOT Road Unit# 7, London, ON N6P1H6 : MLS® 40578257