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(45) {
["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"
}
}
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
)
)
- BedsTotal: 6
- Full Baths: 6
- Half Baths: 1
- Land Area (sf): 23,849
- 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
