Previous Next

552 Moaniala Street Honolulu, HI 96821

Listing
Overview

Price: $8,880,000
Area: HAWAII LOA RIDGE
Status: Active

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
        )

)

PROPERTY INFO

• BedsTotal: 6
• Full Baths: 6
• Half Baths: 1
• Land Area (sf): 23,849 sf
• Living (sf): 11,987
• Year Built: 2006

KEY FEATURES

• 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

FINANCIAL INFO

• Maintenance Fees: $569
• Land Tenure: FS - Fee Simple

SCHOOLS

• Elementary School: Aina Haina
• Middle School: Niu Valley
• High School: Kalani

CONTACT US

Marcus Realty

#RB-7120
info@marcushawaii.com
(808)839-7446

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.