Thanksgiving - The office will be closed on Thursday 11/27/25 and Friday 11/28/25
Christmas - The office will be closed on Thursday 12/25/25 and Friday 12/26/25
New Years - The office will be closed on Thursday 1/1/26 and Friday 1/2/26
Price: $530,000 Area: MAKAKILO-UPPER Status: Active
ABSOLUTELY UNIQUE, as there is no other unit, I dare say, in all Makakilo with features such as these. For MOSAIC enthusiasts, you will enjoy the HANDCRAFTED MARINE THEME ARTISANAL MASTERPIECE WEAVED THROUGHOUT THE HOME. As you open the front door, the tiled mosaic flooring is a welcoming path to the underwater dream you are about to experience. It continues to the kitchen, whose upgrades include a vaulted ceiling conversion, where our display begins. As you swim along to the living room, you will walk up behind an enchanting wahine, who you wish would turn around so that you can get a glimpse of her face. Then as you head into the primary bedroom and into the primary ensuite, you are transported to an underwater kingdom. While in the shower, you can almost see yourself swimming along with Ariel, “under the sea.” Other improvements include raised bamboo wood flooring, newer kitchen elements, and TWO PRIMARY BEDROOMS! Yes, you read that right! And for the icing on the cake… STUNNING OCEAN VIEWS. On street level, so NO STAIRS, from your two assigned covered parking stalls. Truly a one-of-a-kind! Listing by: CLARITY Real Estate (808) 366-8211
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202525510"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "92-905"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(4) "Hame"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Place"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(5) "19203"
}
["City"]=>
array(1) {
[0]=>
string(7) "Kapolei"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96707"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(37) "https://youtube.com/embed/7rOtwbf25Rk"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "530000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(14) "MAKAKILO-UPPER"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1117) "ABSOLUTELY UNIQUE, as there is no other unit, I dare say, in all Makakilo with features such as these. For MOSAIC enthusiasts, you will enjoy the HANDCRAFTED MARINE THEME ARTISANAL MASTERPIECE WEAVED THROUGHOUT THE HOME. As you open the front door, the tiled mosaic flooring is a welcoming path to the underwater dream you are about to experience. It continues to the kitchen, whose upgrades include a vaulted ceiling conversion, where our display begins. As you swim along to the living room, you will walk up behind an enchanting wahine, who you wish would turn around so that you can get a glimpse of her face. Then as you head into the primary bedroom and into the primary ensuite, you are transported to an underwater kingdom. While in the shower, you can almost see yourself swimming along with Ariel, “under the sea.” Other improvements include raised bamboo wood flooring, newer kitchen elements, and TWO PRIMARY BEDROOMS! Yes, you read that right! And for the icing on the cake… STUNNING OCEAN VIEWS. On street level, so NO STAIRS, from your two assigned covered parking stalls. Truly a one-of-a-kind!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(19) "CLARITY Real Estate"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(10) "1033025.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "830"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1991"
}
["BuildingName"]=>
array(1) {
[0]=>
string(15) "Makakilo Cliffs"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(7) "Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(5) "Ocean"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "755.00"
}
["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) "19120547"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-11-16T17:00:01.343"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-11-14"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(8) "Makakilo"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "17:00:01.343"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27220491"
}
["listing_image"]=>
array(24) {
[0]=>
string(8) "27220491"
[1]=>
string(8) "27220492"
[2]=>
string(8) "27220493"
[3]=>
string(8) "27220494"
[4]=>
string(8) "27220495"
[5]=>
string(8) "27220496"
[6]=>
string(8) "27220497"
[7]=>
string(8) "27220498"
[8]=>
string(8) "27220499"
[9]=>
string(8) "27220500"
[10]=>
string(8) "27220501"
[11]=>
string(8) "27220502"
[12]=>
string(8) "27220503"
[13]=>
string(8) "27220504"
[14]=>
string(8) "27220505"
[15]=>
string(8) "27220506"
[16]=>
string(8) "27220507"
[17]=>
string(8) "27220508"
[18]=>
string(8) "27220509"
[19]=>
string(8) "27220510"
[20]=>
string(8) "27220511"
[21]=>
string(8) "27220512"
[22]=>
string(8) "27220513"
[23]=>
string(8) "27220514"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202525510
)
[StreetNumber] => Array
(
[0] => 92-905
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Hame
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] => 19203
)
[City] => Array
(
[0] => Kapolei
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96707
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://youtube.com/embed/7rOtwbf25Rk
)
[ListPrice] => Array
(
[0] => 530000.00
)
[Neighbourhood] => Array
(
[0] => MAKAKILO-UPPER
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => ABSOLUTELY UNIQUE, as there is no other unit, I dare say, in all Makakilo with features such as these. For MOSAIC enthusiasts, you will enjoy the HANDCRAFTED MARINE THEME ARTISANAL MASTERPIECE WEAVED THROUGHOUT THE HOME. As you open the front door, the tiled mosaic flooring is a welcoming path to the underwater dream you are about to experience. It continues to the kitchen, whose upgrades include a vaulted ceiling conversion, where our display begins. As you swim along to the living room, you will walk up behind an enchanting wahine, who you wish would turn around so that you can get a glimpse of her face. Then as you head into the primary bedroom and into the primary ensuite, you are transported to an underwater kingdom. While in the shower, you can almost see yourself swimming along with Ariel, “under the sea.” Other improvements include raised bamboo wood flooring, newer kitchen elements, and TWO PRIMARY BEDROOMS! Yes, you read that right! And for the icing on the cake… STUNNING OCEAN VIEWS. On street level, so NO STAIRS, from your two assigned covered parking stalls. Truly a one-of-a-kind!
)
[ListOfficeName] => Array
(
[0] => CLARITY Real Estate
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 1033025.00
)
[SqftTotal] => Array
(
[0] => 830
)
[YearBuilt] => Array
(
[0] => 1991
)
[BuildingName] => Array
(
[0] => Makakilo Cliffs
)
[PropertyCondition] => Array
(
[0] => Average
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Ocean
)
[MaintenanceExpense] => Array
(
[0] => 755.00
)
[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] => 19120547
)
[MatrixModifiedDT] => Array
(
[0] => 2025-11-16T17:00:01.343
)
[ListingContractDate] => Array
(
[0] => 2025-11-14
)
[MLSAreaMajor] => Array
(
[0] => Makakilo
)
[PropertyFrontage] => Array
(
[0] => Other
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 17:00:01.343
)
[_thumbnail_id] => Array
(
[0] => 27220491
)
[listing_image] => Array
(
[0] => 27220491
[1] => 27220492
[2] => 27220493
[3] => 27220494
[4] => 27220495
[5] => 27220496
[6] => 27220497
[7] => 27220498
[8] => 27220499
[9] => 27220500
[10] => 27220501
[11] => 27220502
[12] => 27220503
[13] => 27220504
[14] => 27220505
[15] => 27220506
[16] => 27220507
[17] => 27220508
[18] => 27220509
[19] => 27220510
[20] => 27220511
[21] => 27220512
[22] => 27220513
[23] => 27220514
)
)
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on November 16, 2025 - 5:00 PM
Information is deemed reliable but not guaranteed.
Copyright: 2025 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.
