552 Moaniala Street Honolulu, HI 96821
Listing
Overview
Price: $8,880,000
Area: HAWAII LOA RIDGE
Status: Active
MASTERPIECE AT THE POINTE. Over 180 degrees of unobstructed ocean views framed by Diamond Head and Koko Head creating a sight to behold. Rare oversized (23,849sqft) rim lot with a main residence that includes an attached extended family/guest suite as well as a completed separate and private living area. Main home includes an elevator, oversized garage and flex room that could be a theatre. The top floor Primary Suite commands some of the most panoramic views whether from the bed or the bathroom. The first floor Family/Guest one-bedroom suite has easy access from the driveway and includes a bedroom, living area and kitchenette. Under the great lawn sits the detached, private living area that could be made into a living area, fitness/wellness area or entertainment alcove. Outdoor spaces include a heated infinity edge pool with hot tub overlooking a large flat lawn for outdoor entertaining or family play time. Balconies and terraces surround the homes extending living and entertaining both inside and out. Located within The Pointe, a gated community within the secure Hawaii Loa Ridge, there's an added layer of privacy and safety. Make this property your legacy home today! Listing by: Ko Olina Realty, LLC (808) 721-7188
array(46) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202408106"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(3) "552"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(8) "Moaniala"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["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) "96821"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "8880000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "8880000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(16) "HAWAII LOA RIDGE"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1193) "MASTERPIECE AT THE POINTE. Over 180 degrees of unobstructed ocean views framed by Diamond Head and Koko Head creating a sight to behold. Rare oversized (23,849sqft) rim lot with a main residence that includes an attached extended family/guest suite as well as a completed separate and private living area. Main home includes an elevator, oversized garage and flex room that could be a theatre. The top floor Primary Suite commands some of the most panoramic views whether from the bed or the bathroom. The first floor Family/Guest one-bedroom suite has easy access from the driveway and includes a bedroom, living area and kitchenette. Under the great lawn sits the detached, private living area that could be made into a living area, fitness/wellness area or entertainment alcove. Outdoor spaces include a heated infinity edge pool with hot tub overlooking a large flat lawn for outdoor entertaining or family play time. Balconies and terraces surround the homes extending living and entertaining both inside and out. Located within The Pointe, a gated community within the secure Hawaii Loa Ridge, there's an added layer of privacy and safety. Make this property your legacy home today!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(20) "Ko Olina Realty, LLC"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "6"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "6"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "1"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "23849.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(5) "11987"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "2006"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(23) "Excellent,Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["StoriesType"]=>
array(1) {
[0]=>
string(15) "Basement,Three+"
}
["View"]=>
array(1) {
[0]=>
string(70) "City,Coastline,Diamond Head,Garden,Mountain,Ocean,Other,Sunrise,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "569.25"
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(10) "Aina Haina"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(10) "Niu Valley"
}
["HighSchool"]=>
array(1) {
[0]=>
string(6) "Kalani"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "KORL"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(24) "matt.gabriel@koolina.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 721-7188"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(12) "Matt Gabriel"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-07-18T13:00:01.730"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17935008"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-04-16T11:34:30.540"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(9) "DiamondHd"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(18) "Other,Preservation"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26167568"
}
["listing_image"]=>
array(15) {
[0]=>
string(8) "26167568"
[1]=>
string(8) "26167569"
[2]=>
string(8) "26167570"
[3]=>
string(8) "26167571"
[4]=>
string(8) "26167572"
[5]=>
string(8) "26167573"
[6]=>
string(8) "26167574"
[7]=>
string(8) "26167575"
[8]=>
string(8) "26167576"
[9]=>
string(8) "26167577"
[10]=>
string(8) "26167578"
[11]=>
string(8) "26167579"
[12]=>
string(8) "26172088"
[13]=>
string(8) "26172089"
[14]=>
string(8) "26172090"
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "13:00:01.730"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202408106
)
[StreetNumber] => Array
(
[0] => 552
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Moaniala
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96821
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 8880000.00
)
[CurrentPrice] => Array
(
[0] => 8880000.00
)
[Neighbourhood] => Array
(
[0] => HAWAII LOA RIDGE
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => MASTERPIECE AT THE POINTE. Over 180 degrees of unobstructed ocean views framed by Diamond Head and Koko Head creating a sight to behold. Rare oversized (23,849sqft) rim lot with a main residence that includes an attached extended family/guest suite as well as a completed separate and private living area. Main home includes an elevator, oversized garage and flex room that could be a theatre. The top floor Primary Suite commands some of the most panoramic views whether from the bed or the bathroom. The first floor Family/Guest one-bedroom suite has easy access from the driveway and includes a bedroom, living area and kitchenette. Under the great lawn sits the detached, private living area that could be made into a living area, fitness/wellness area or entertainment alcove. Outdoor spaces include a heated infinity edge pool with hot tub overlooking a large flat lawn for outdoor entertaining or family play time. Balconies and terraces surround the homes extending living and entertaining both inside and out. Located within The Pointe, a gated community within the secure Hawaii Loa Ridge, there's an added layer of privacy and safety. Make this property your legacy home today!
)
[ListOfficeName] => Array
(
[0] => Ko Olina Realty, LLC
)
[BedsTotal] => Array
(
[0] => 6
)
[BathsFull] => Array
(
[0] => 6
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 23849.00
)
[SqftTotal] => Array
(
[0] => 11987
)
[YearBuilt] => Array
(
[0] => 2006
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent,Above Average
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => Basement,Three+
)
[View] => Array
(
[0] => City,Coastline,Diamond Head,Garden,Mountain,Ocean,Other,Sunrise,Sunset
)
[MaintenanceExpense] => Array
(
[0] => 569.25
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Aina Haina
)
[MiddleOrJuniorSchool] => Array
(
[0] => Niu Valley
)
[HighSchool] => Array
(
[0] => Kalani
)
[ListOfficeMLSID] => Array
(
[0] => KORL
)
[ListAgentEmail] => Array
(
[0] => matt.gabriel@koolina.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 721-7188
)
[ListAgentFullName] => Array
(
[0] => Matt Gabriel
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-07-18T13:00:01.730
)
[Matrix_Unique_ID] => Array
(
[0] => 17935008
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-04-16T11:34:30.540
)
[MLSAreaMajor] => Array
(
[0] => DiamondHd
)
[PropertyFrontage] => Array
(
[0] => Other,Preservation
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26167568
)
[listing_image] => Array
(
[0] => 26167568
[1] => 26167569
[2] => 26167570
[3] => 26167571
[4] => 26167572
[5] => 26167573
[6] => 26167574
[7] => 26167575
[8] => 26167576
[9] => 26167577
[10] => 26167578
[11] => 26167579
[12] => 26172088
[13] => 26172089
[14] => 26172090
)
[MatrixModifiedTime] => Array
(
[0] => 13:00:01.730
)
)
- BedsTotal: 6
- Full Baths: 6
- Half Baths: 1
- Land Area (sf): 23,849 sf
- Living (sf): 11,987
- Year Built: 2006
- Property Condition: Excellent,Above Average
- Number of Parking Spaces: 4
- View: City,Coastline,Diamond Head,Garden,Mountain,Ocean,Other,Sunrise,Sunset
- Listing Office: Ko Olina Realty, LLC
- Maintenance Fees: $569
- Land Tenure: FS - Fee Simple
- Elementary School: Aina Haina
- Middle School: Niu Valley
- High School: Kalani
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on July 18, 2024 - 1: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.
© Marcus Realty. All Rights Reserved.