Listings Search Open Houses Buyer's 20% Rebate Sell for 2% Sell for $3,500 Statistics Help Tools Saved Searches Testimonials Blog Contact ☰

Oahu Real Estate Logo

We've sold 2,090+ listings for over $1.34 billion, saving our clients over $12 million. See our sales on Google Maps.

St. Louis Active Single Family

Photo View | Sold Listings

6 Active 3 Contract 0 Pending 9 Total

Property Type: Single Family | Status: Active, Active Under Contract, Pending | Region: Diamond Head

Compare up to 6 properties with your favorite AI. Check your main property first (the one you may buy or sell).

Main property: Compare with:

Print a comparison PDF that includes the AI prompt. Remove all. You already have 6.

To see one photo and the description, move the pointer over Status.

Legend Photos Status MLS# Current
Price
Original
Price
Tax FeesRegion Neighborhood Address Condition Beds Baths DOM List Date Living
Sq Ft
Avg.
Living
Land
Sq Ft
Avg.
Land
Year
Built
Year
Rem
Assessed
Total
Assessed
Land
Assessed
Improve
Assessed
Ratio
View Frontage Pool Parking Elementary Junior High Zoning
1FS|OV|MVPhotosActive202609743$1,549,000$1,650,000$588Diamond HeadSt. Louis1588 St Louis DriveExcellent33/012805-23-20261,699$9125,196$29819622026$1,265,400$1,049,700$215,700122%City, Mountain, Ocean, SunsetNone2 Car, Carport05 - R-5
2FS|OVPhotosActive202601634$1,564,998$1,590,000$262Diamond HeadSt. Louis1952 Bertram StreetExcellent32/124501-26-20262,189$7155,549$28219552017$1,055,300$996,600$58,700148%City, Coastline, Diamond Head, Ocean, SunsetNone2 Car, Driveway, GarageHokulaniJarrettKaimuki05 - R-5
3FS|OVPhotosActive202612360$1,675,000$1,795,000$904Diamond HeadSt. Louis1766 St Louis DriveAbove Average55/08707-03-20262,552$6567,854$21319421990$1,600,900$1,126,200$474,700105%City, Ocean, Sunrise, SunsetNone3 Car+, Garage05 - R-5
4FS|OVPhotosActive202613079$1,700,000$1,750,000$681Diamond HeadSt. Louis1938 Bertram StreetAbove Average52/08307-07-20262,027$8395,357$31719542023$1,467,600$961,900$505,700116%City, Diamond Head, OceanOtherNone3 Car+, Garage, StreetHokulaniJarrettKaimuki05 - R-5
5FS|OV|MVPhotosActive202613122$1,995,000$2,260,000$1,098Diamond HeadSt. Louis1499 Alencastre StreetExcellent65/08507-05-20263,552$5626,000$33319832012$2,057,600$1,102,500$955,10097%Diamond Head, Mountain, OceanNone2 Car, GarageHokulaniJarrettKaimuki05 - R-5
6FS|OVPhotosActive202609866$2,570,000$2,750,000$464Diamond HeadSt. Louis2505 Saul PlaceExcellent54/012505-26-20263,149$8166,755$3802024$1,538,300$1,107,900$430,400167%City, Diamond Head, OceanOtherNone3 Car+, CarportHokulaniJarrettKaimuki05 - R-5
7FS|OVPhotosContract202610393$1,089,000$1,200,000$305Diamond HeadSt. Louis2970 Robert PlaceNeeds Major Repair32/18005-29-20261,722$6326,594$1651933$1,203,900$1,133,700$70,20090%City, Diamond Head, OceanNoneCarport, Street05 - R-5
8FS|OVPhotosContract202616169$1,299,000$1,299,000$264Diamond HeadSt. Louis2911 Eugene PlaceAverage42/0508-22-20261,776$7317,121$1821957$1,076,200$975,500$100,700121%City, Diamond Head, OceanNone2 Car, CarportHokulaniJarrettKaimuki05 - R-5
9FS|OVPhotosContract202614187$1,625,000$1,625,000$308Diamond HeadSt. Louis1516 Alencastre StreetAbove Average33/01507-27-20262,500$6505,272$30819472019$1,252,400$1,011,100$241,300130%City, Ocean, SunsetOtherNone3 Car+, CarportHokulaniJarrettKaimuki05 - R-5
Guide
DOMDays on Market until in escrow.
Up to 30 Days on MarketLight Green
31 to 60 Days on MarketPink
Over 60 Days on MarketYellow
ActiveAvailable for sale — Under or equal to 10 Days on Market.
ActiveAvailable for sale — Over 10 Days on Market.
ContractIn escrow but still showing and looking for backup offers.
PendingIn escrow and not looking for backup offers and possibly closing soon.
SoldNot available for sale.
CancelledThe seller canceled the listing contract. Not available for sale.
ExpiredThe listing contract expired. Might still be in escrow.
HoldActive listing that is paused. Does not accrue Days on Market.
FSFee Simple — you own the land.
LHLeasehold — you do not own the land, you are leasing it.
OHOpen House — Upcoming Open House
FCForeclosure — Bank owned.
SSShort Sale — needs lender approval to sell for less than the mortgage balance.
SUSubject to replacement property. Seller must find a replacement property to close.
OVOcean View
MVMountain View
CPRCondo — Condominium Property Regime.
PLPool — Example: Above Ground, Heated, In Ground, Spa/HotTub, Tile, Pool on Property, Community Association Pool
BFBeachfront
OFOceanfront