STUNNING DIAMOND HEAD VIEWS? Check. OCEAN VIEWS? Check. CITY SKYLINE VIEWS? Check. MULTIPLE DWELLINGS with income potential? Check. STUDIO or stand alone HOME BUSINESS SPACE? Check. 400+ SqFt UNFINISHED BASEMENT storage area? Check. LARGE USEABLE LOT? Check. HIGH-END REMODEL TOUCHES THROUGHOUT? Check. One would think that this property almost has it all! As virtually rendered in some of the photos, a wrap around lanai and personal aquatic oasis potential would make this gem over the top. Two stories, each with its own exterior entrance. Top level is all about the views! Open Living, Dining, Kitchen, and Family Room completely exposed to the captivating vistas. Two bedrooms, 1.5 baths with additional space conversion, that could serve as a primary bedroom with full en suite, or studio rental, or home business area or who knows what. Downstairs has a spacious open living space with full kitchen and its own in-door laundry. There’s such a cozy, soothing feeling about the unit. FURNITURE INCLUSION possible. And finally, to top it all off, there’s a 29 panel OWNED PV SYSTEM WITH TESLA VEHICLE CHARGER. So much to offer that you just have to come see for yourself… before it’s too late. Listing by: CLARITY Real Estate (808) 366-8211
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202610690"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(4) "1615"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(8) "St Louis"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Drive"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["City"]=>
array(1) {
[0]=>
string(8) "Honolulu"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96816"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(37) "https://youtube.com/embed/vW4XOXsJUAg"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1700000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(9) "ST. LOUIS"
}
["Status"]=>
array(1) {
[0]=>
string(7) "Pending"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1205) "STUNNING DIAMOND HEAD VIEWS? Check. OCEAN VIEWS? Check. CITY SKYLINE VIEWS? Check. MULTIPLE DWELLINGS with income potential? Check. STUDIO or stand alone HOME BUSINESS SPACE? Check. 400+ SqFt UNFINISHED BASEMENT storage area? Check. LARGE USEABLE LOT? Check. HIGH-END REMODEL TOUCHES THROUGHOUT? Check. One would think that this property almost has it all! As virtually rendered in some of the photos, a wrap around lanai and personal aquatic oasis potential would make this gem over the top. Two stories, each with its own exterior entrance. Top level is all about the views! Open Living, Dining, Kitchen, and Family Room completely exposed to the captivating vistas. Two bedrooms, 1.5 baths with additional space conversion, that could serve as a primary bedroom with full en suite, or studio rental, or home business area or who knows what. Downstairs has a spacious open living space with full kitchen and its own in-door laundry. There’s such a cozy, soothing feeling about the unit. FURNITURE INCLUSION possible. And finally, to top it all off, there’s a 29 panel OWNED PV SYSTEM WITH TESLA VEHICLE CHARGER. So much to offer that you just have to come see for yourself… before it’s too late."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(19) "CLARITY Real Estate"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "1"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "6000.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "2810"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1932"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(27) "Diamond Head,Mountain,Ocean"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(0) ""
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["HighSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "CLTY"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(27) "Jason@RealEstateCLARITY.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 366-8211"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(14) "Jason A Rivera"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "19493732"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2026-06-13T18:44:05.730"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2026-06-02"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(9) "DiamondHd"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "18:44:05.730"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27411246"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "27411246"
[1]=>
string(8) "27411247"
[2]=>
string(8) "27411248"
[3]=>
string(8) "27411249"
[4]=>
string(8) "27411250"
[5]=>
string(8) "27411251"
[6]=>
string(8) "27411252"
[7]=>
string(8) "27411253"
[8]=>
string(8) "27411254"
[9]=>
string(8) "27411255"
[10]=>
string(8) "27411256"
[11]=>
string(8) "27411257"
[12]=>
string(8) "27411258"
[13]=>
string(8) "27411259"
[14]=>
string(8) "27411260"
[15]=>
string(8) "27411261"
[16]=>
string(8) "27411262"
[17]=>
string(8) "27411263"
[18]=>
string(8) "27411264"
[19]=>
string(8) "27411265"
[20]=>
string(8) "27411266"
[21]=>
string(8) "27411267"
[22]=>
string(8) "27411268"
[23]=>
string(8) "27411269"
[24]=>
string(8) "27411270"
[25]=>
string(8) "27411271"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202610690
)
[StreetNumber] => Array
(
[0] => 1615
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => St Louis
)
[StreetSuffix] => Array
(
[0] => Drive
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96816
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://youtube.com/embed/vW4XOXsJUAg
)
[ListPrice] => Array
(
[0] => 1700000.00
)
[Neighbourhood] => Array
(
[0] => ST. LOUIS
)
[Status] => Array
(
[0] => Pending
)
[PublicRemarks] => Array
(
[0] => STUNNING DIAMOND HEAD VIEWS? Check. OCEAN VIEWS? Check. CITY SKYLINE VIEWS? Check. MULTIPLE DWELLINGS with income potential? Check. STUDIO or stand alone HOME BUSINESS SPACE? Check. 400+ SqFt UNFINISHED BASEMENT storage area? Check. LARGE USEABLE LOT? Check. HIGH-END REMODEL TOUCHES THROUGHOUT? Check. One would think that this property almost has it all! As virtually rendered in some of the photos, a wrap around lanai and personal aquatic oasis potential would make this gem over the top. Two stories, each with its own exterior entrance. Top level is all about the views! Open Living, Dining, Kitchen, and Family Room completely exposed to the captivating vistas. Two bedrooms, 1.5 baths with additional space conversion, that could serve as a primary bedroom with full en suite, or studio rental, or home business area or who knows what. Downstairs has a spacious open living space with full kitchen and its own in-door laundry. There’s such a cozy, soothing feeling about the unit. FURNITURE INCLUSION possible. And finally, to top it all off, there’s a 29 panel OWNED PV SYSTEM WITH TESLA VEHICLE CHARGER. So much to offer that you just have to come see for yourself… before it’s too late.
)
[ListOfficeName] => Array
(
[0] => CLARITY Real Estate
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 3
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 6000.00
)
[SqftTotal] => Array
(
[0] => 2810
)
[YearBuilt] => Array
(
[0] => 1932
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 3
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Diamond Head,Mountain,Ocean
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => CLTY
)
[ListAgentEmail] => Array
(
[0] => Jason@RealEstateCLARITY.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 366-8211
)
[ListAgentFullName] => Array
(
[0] => Jason A Rivera
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 19493732
)
[MatrixModifiedDT] => Array
(
[0] => 2026-06-13T18:44:05.730
)
[ListingContractDate] => Array
(
[0] => 2026-06-02
)
[MLSAreaMajor] => Array
(
[0] => DiamondHd
)
[PropertyFrontage] => Array
(
[0] => Other
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 18:44:05.730
)
[_thumbnail_id] => Array
(
[0] => 27411246
)
[listing_image] => Array
(
[0] => 27411246
[1] => 27411247
[2] => 27411248
[3] => 27411249
[4] => 27411250
[5] => 27411251
[6] => 27411252
[7] => 27411253
[8] => 27411254
[9] => 27411255
[10] => 27411256
[11] => 27411257
[12] => 27411258
[13] => 27411259
[14] => 27411260
[15] => 27411261
[16] => 27411262
[17] => 27411263
[18] => 27411264
[19] => 27411265
[20] => 27411266
[21] => 27411267
[22] => 27411268
[23] => 27411269
[24] => 27411270
[25] => 27411271
)
)
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on June 13, 2026 - 6:44 PM
Information is deemed reliable but not guaranteed.
Copyright: 2026 by HiCentral MLS, Ltd.
Some of the active listings appearing on this site may be listed by other REALTORS®.
If you are interested in those active listings, our company may represent you as the buyer's agent.
If the active listing you are interested in is our company's active listing, you may speak to one of our agents
regarding your options for representation.
