NOT LISTED FOR SALE

18451 SW 158th St Miami, FL 33187

Miami Area

Estimated Value: $6,094,000 - $6,390,000

6 Beds
8.5 Baths
11,520 Sq Ft
$539/Sq Ft Est. Value

Sale Details

Date Sold: May 26, 2026

Last sale price $6,100,000 $530 Per Sq Ft

Est. 2% increase in value since last sale

Current estimated payment $39,319 / mo

340 Days on Market

Highlights

  • Barn or Stable
  • Horses Allowed in Community
  • Media Room
  • Norma Butler Bossard Elementary School Rated A-
  • Tennis Courts
  • Heated In Ground Pool

About This Home

As of May 2026

Welcome to your private equestrian estate “Casa da Campagna”. Built in 2006 this home sprawls over 11 acres of land in tranquil Redland! Gated community with front driveway gated security, or choose to fly in onto your private airstrip, or land on your helicopter pad. Spacious home with over 11,000 sq foot of living areas, 6 beds, 8.5 baths, 3-car garage, Expansive primary suite with spa bath and private terrace. The resort style grounds feature covered patios, summer kitchen, saltwater pool, jacuzzi, basketball court, mini golf course, detached garage for 20 plus car collection, detached entertainment building with movie theatre and video games and casino games and a band set up. Six horse stables and fenced training yards. This home is ideal for entertaining or multigenerational living!

Last Agent to Sell the Property

Julian Johnston

One Sotheby's International Realty License #3041178 Listed on: 05/12/2025

One Sotheby's International Realty

Co-Listed By

Judith Puknat

The Corcoran Group License #3346554

Last Buyer's Agent

Anamaria Velasquez

NEXXOS REALTY LLC License #3166173

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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 Details

Home Type

  • Single Family

Est. Annual Taxes

  • $54,917

Year Built

  • Built in 2006

Lot Details

  • 11.07 Acre Lot
  • Home fronts a pond
  • South Facing Home
  • Fenced
  • Property is zoned 8900

HOA Fees

  • $300 Monthly HOA Fees

Parking

  • 3 Car Garage
  • Automatic Garage Door Opener
  • Circular Driveway
  • Open Parking
  • RV or Boat Parking

Property Views

  • Garden
  • Pool

Home Design

  • Mediterranean Architecture
  • Barrel Roof Shape
  • Concrete Block And Stucco Construction

Interior Spaces

  • 11,520 Sq Ft Home
  • Built-In Features
  • Bar
  • Vaulted Ceiling
  • Ceiling Fan
  • Paddle Fans
  • Fireplace
  • Blinds
  • Arched Windows
  • Great Room
  • Family Room
  • Formal Dining Room
  • Media Room
  • Den
  • Recreation Room
  • Attic

Kitchen

  • Breakfast Area or Nook
  • Eat-In Kitchen
  • Built-In Self-Cleaning Oven
  • Electric Range
  • Microwave
  • Ice Maker
  • Dishwasher
  • Cooking Island

Flooring

  • Wood
  • Carpet
  • Marble

Bedrooms and Bathrooms

  • 6 Bedrooms
  • Split Bedroom Floorplan
  • Dual Sinks
  • Jettted Tub and Separate Shower in Primary Bathroom
  • Soaking Tub

Laundry

  • Laundry in Utility Room
  • Dryer
  • Washer

Home Security

  • Security System Owned
  • Impact Glass
  • Fire and Smoke Detector

Eco-Friendly Details

  • Air Purifier

Pool

  • Heated In Ground Pool
  • Pool Bathroom

Outdoor Features

  • Tennis Courts
  • Patio
  • Outdoor Grill

Horse Facilities and Amenities

  • Horses Allowed On Property
  • Barn or Stable

Utilities

  • Zoned Heating and Cooling System
  • Well
  • Water Softener is Owned
  • Septic Tank

Listing and Financial Details

  • Assessor Parcel Number 30-58-25-000-0491

Community Details

Overview

  • Lindberg Landing Subdivision

Recreation

  • Horses Allowed in Community

Security

  • Gated Community

Home Details

Home Type

Single Family

Est. Annual Taxes

$54,917

Year Built

Built in 2006

Lot Details

11.07 Acres

HOA Fees

$300 per month

Parking

3

Listing Details

  • Property Type: Residential
  • Year Built: 2006
  • Property Sub Type: Single Family Residence
  • Architectural Style: Detached, Mediterranean
  • Co List Office Mls Id: CSMG02
  • Co List Office Phone: 305-395-4982
  • Garage Yn: Yes
  • Horses: Yes
  • Inclusions: Other
  • New Construction: No
  • Structure Type: House
  • Subdivision Name: LINDBERG LANDING
  • Year Built Details: Resale
  • MIAMIRE_PoolYN: Yes
  • MIAMIRE_PetsAllowedYN: Yes
  • MIAMIRE_MembershipPurchRqdYN: No
  • LastStatus: Pending
  • CurrentPrice: 6100000
  • InternetRemarks: Welcome to your private equestrian estate with over 11 acres of land in tranquil Redland!
  • ShowingTimeFlag: No
  • Special Features: VirtualTour

Interior Features

  • Appliances: Dishwasher, Dryer, Ice Maker, Microwave, Electric Range, Refrigerator, Self Cleaning Oven, Wall Oven, Washer, Water Softener Owned
  • Interior Amenities: First Floor Entry, Bar, Built-in Features, Cooking Island, Split Bedroom, Volume Ceilings, Attic, Den/Library/Office, Family Room, Great Room, Media Room, Recreation Room, Utility Room/Laundry
  • Full Bathrooms: 8
  • Half Bathrooms: 1
  • Total Bedrooms: 6
  • Fireplace Features: Fireplace
  • Fireplace: Yes
  • Flooring: Carpet, Marble, Wood
  • Furnished: Unfurnished
  • Living Area: 11520
  • Other Equipment: Air Purifier, Automatic Garage Door Opener
  • Possible Use: Primary
  • Window Features: Hurricane Shutters, Arched Windows, Blinds, Impact Glass
  • Bedroom Features: Entry Level
  • Dining Room Features: Breakfast Area, Eat-In Kitchen, Formal Dining
  • Living Room Features: Attic, Den/Library/Office, Family Room, Great Room, Media Room, Recreation Room, Utility Room/Laundry
  • Master Bathroom Features: Dual Sinks, Separate Tub & Shower, Whirlpool/Spa

Exterior Features

  • Roof: Barrel Roof
  • View: Garden, Pool
  • Exterior Features: Barbeque, Built-In Grill, Tennis Court(s)
  • Construction Type: CBS Construction
  • Direction Faces: South
  • Disclosures: Disclosure
  • Fencing: Fenced
  • Lot Features: 10 Or More Acre Lot
  • Patio And Porch Features: Patio
  • Pool Features: Automatic Chlorination, In Ground, Heated, Pool Bath
  • Pool Private: No
  • View: Yes
  • Waterfront Features: WF/Pool/No Ocean Access, Pond
  • Waterfront: Yes

Garage/Parking

  • Park Building Name: LINDBERG LANDING
  • Covered Parking Spaces: 3
  • Garage Spaces: 3
  • Open Parking: Yes
  • Parking Features: Circular Driveway, Covered, Rv/Boat Parking

Utilities

  • Sewer: Septic Tank
  • Water Source: Well
  • Cooling: Air Purifier, Ceiling Fan(s), Central Air, Paddle Fans
  • Cooling Y N: Yes
  • Heating: Central, Zoned
  • Heating Yn: Yes
  • Laundry Features: Utility Room/Laundry
  • Security: Fire Alarm, Owned Burglar Alarm

Condo/Co-op/Association

  • Association Fee: 300
  • Association Fee Frequency: Monthly
  • Association: Yes
  • Community Features: Gated, Horses Permitted

Association/Amenities

  • MIAMIRE_TypeofAssociation: Homeowners

Lot Info

  • Parcel Number: 30-58-25-000-0491
  • Horse Amenities: Barn &/Or Stalls
  • Lot Size Sq Ft: 482209
  • Zoning: 8900

Rental Info

  • Pets Allowed: Yes

Tax Info

  • Tax Year: 2024
  • Tax Annual Amount: 54917

Ownership History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Name Owned For Owner Type

Purchase Details

Listed on
May 12, 2025
Closed on
May 20, 2026
Sold by
Alexis Lodde and Kihjuana Schular-Mack
Bought by
Seller's Agent
Julian Johnston
One Sotheby's International Realty
Buyer's Agent
Anamaria Velasquez
NEXXOS REALTY LLC
List Price
$8,300,000
Sold Price
$6,100,000
Premium/Discount to List
-$2,200,000
-26.51%
Views
248
Current Estimated Value
$6,213,494

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$113,494
Avg. Annual Appreciation
7.07%
Original Mortgage
$4,880,000
Outstanding Balance
$4,862,611
Interest Rate
5.58%
Mortgage Type
New Conventional
Estimated Equity
$1,350,883

Purchase Details

Closed on
Apr 12, 2011
Sold by
Lobue Samuel and Lobue Sandra Deleonardo
Bought by
Lodde Alexis

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$2,906,250
Interest Rate
4.25%
Mortgage Type
Adjustable Rate Mortgage/ARM

Purchase Details

Closed on
Apr 15, 2005
Sold by
Melo Aquilino and Melo Lourdes M
Bought by
Lobue Samuel and Lobue Sandra Deleonardo

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,147,500
Interest Rate
5.79%
Mortgage Type
Balloon

Purchase Details

Closed on
Oct 13, 1999
Sold by
Village Development Inc Nv
Bought by
Melo Aquilino and Melo Lourdes M

Purchase Details

Closed on
Oct 12, 1999
Sold by
Village Development Inc
Bought by
Melo Aquilino and Melo Lourdes M
Source: Public Records

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Buyer Sale Price Title Company
$6,100,000 Priority Title
Lodde Alexis $4,100,000 Sunbelt Title Agency
Lobue Samuel $1,350,000 --
Melo Aquilino $180,000 --
Melo Aquilino $180,000 --
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Borrower Loan Amount
Open $4,880,000
Previous Owner Lodde Alexis $2,906,250
Previous Owner Lobue Samuel $2,125,000
Previous Owner Lobue Samuel $1,147,500
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft
05/26/2026 05/26/26 Sold $6,100,000 -11.6% $530 / Sq Ft
04/17/2026 04/17/26 Pending -- -- --
01/12/2026 01/12/26 Price Changed $6,900,000 -8.0% $599 / Sq Ft
08/26/2025 08/26/25 Price Changed $7,500,000 -9.6% $651 / Sq Ft
05/12/2025 05/12/25 For Sale $8,300,000 -- $720 / Sq Ft
Source: MIAMI REALTORS® MLS

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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 $58,804 $3,472,214
2024 $55,732 $3,374,358
2023 $55,732 $3,276,076 $0 $0
2022 $54,030 $3,180,657 $0 $0
2021 $54,145 $3,088,017 $0 $0
2020 $53,552 $3,045,382 $553,500 $2,491,882
2019 $54,204 $3,073,986 $553,500 $2,520,486
2018 $52,378 $3,047,240 $498,150 $2,549,090
2017 $67,446 $3,865,209 $0 $0
2016 $67,972 $3,814,233 $0 $0
2015 $68,871 $3,787,719 $0 $0
2014 -- $3,757,658 $0 $0
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: MIAMI REALTORS® MLS

MLS Number: A11807595

MIAMI REALTORS® MLS

APN: 30-5825-000-0491

Your Personal Tour Guide

Ask me questions while you tour the home.