Listing
Overview
Price: $7,900,000
Area: HAWAII LOA RIDGE
Status: Active
Price reduction for next owner to make any renovations. View! View! View! Spectacular ocean and Diamond Head views from this stunning residence. Estate sized rim lot - 23,849 square feet - level, fully landscaped gardens in the Pointe at Hawaii Loa Ridge.
Drive up to this large home with a very open floor plan - living room, dining room, kitchen all seamlessly connected.
Big, open living room with high ceilings - finished with marble and lots of glass. There is a fully tiled lanai, inviting heated infinity edge pool and hot tub to soak in spectacular sunset views. Home has different wings with several huge suites for everyone to enjoy their privacy. Primary bedrooms on both levels with the main primary on the second level commanding some of the most panoramic views - home has an elevator too. Other amenities include an exercise room, theatre, wine room... plus lots of extra space to build out additional rooms. Property has endless possibilities. A great entertainment home and a true masterpiece at the Pointe! Listing by: Coldwell Banker Realty (808) 596-0456
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202417691"
}
["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(60) "https://my.matterport.com/show/?m=HsZ4Hir8Ufx&brand=0&mls=1&"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "7900000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "7900000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(16) "HAWAII LOA RIDGE"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1026) "Price reduction for next owner to make any renovations. View! View! View! Spectacular ocean and Diamond Head views from this stunning residence. Estate sized rim lot - 23,849 square feet - level, fully landscaped gardens in the Pointe at Hawaii Loa Ridge.
Drive up to this large home with a very open floor plan - living room, dining room, kitchen all seamlessly connected.
Big, open living room with high ceilings - finished with marble and lots of glass. There is a fully tiled lanai, inviting heated infinity edge pool and hot tub to soak in spectacular sunset views. Home has different wings with several huge suites for everyone to enjoy their privacy. Primary bedrooms on both levels with the main primary on the second level commanding some of the most panoramic views - home has an elevator too. Other amenities include an exercise room, theatre, wine room... plus lots of extra space to build out additional rooms. Property has endless possibilities. A great entertainment home and a true masterpiece at the Pointe!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "Coldwell Banker Realty"
}
["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(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["StoriesType"]=>
array(1) {
[0]=>
string(15) "Basement,Three+"
}
["View"]=>
array(1) {
[0]=>
string(18) "Diamond Head,Ocean"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "569.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) "CBPP"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(29) "dolores.bediones@cbrealty.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 596-0456"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(18) "Dolores P Bediones"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-09-23T15:46:03.990"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18184540"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-08-08T08:18:08.027"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(9) "DiamondHd"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26651617"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26651617"
[1]=>
string(8) "26651618"
[2]=>
string(8) "26651619"
[3]=>
string(8) "26651620"
[4]=>
string(8) "26651621"
[5]=>
string(8) "26651622"
[6]=>
string(8) "26651623"
[7]=>
string(8) "26651624"
[8]=>
string(8) "26651625"
[9]=>
string(8) "26651626"
[10]=>
string(8) "26651627"
[11]=>
string(8) "26651628"
[12]=>
string(8) "26651629"
[13]=>
string(8) "26651630"
[14]=>
string(8) "26651631"
[15]=>
string(8) "26651632"
[16]=>
string(8) "26651633"
[17]=>
string(8) "26651634"
[18]=>
string(8) "26651635"
[19]=>
string(8) "26659505"
[20]=>
string(8) "26659506"
[21]=>
string(8) "26659507"
[22]=>
string(8) "26659508"
[23]=>
string(8) "26659509"
[24]=>
string(8) "26687888"
[25]=>
string(8) "26687889"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202417691
)
[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] => https://my.matterport.com/show/?m=HsZ4Hir8Ufx&brand=0&mls=1&
)
[ListPrice] => Array
(
[0] => 7900000.00
)
[CurrentPrice] => Array
(
[0] => 7900000.00
)
[Neighbourhood] => Array
(
[0] => HAWAII LOA RIDGE
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Price reduction for next owner to make any renovations. View! View! View! Spectacular ocean and Diamond Head views from this stunning residence. Estate sized rim lot - 23,849 square feet - level, fully landscaped gardens in the Pointe at Hawaii Loa Ridge.
Drive up to this large home with a very open floor plan - living room, dining room, kitchen all seamlessly connected.
Big, open living room with high ceilings - finished with marble and lots of glass. There is a fully tiled lanai, inviting heated infinity edge pool and hot tub to soak in spectacular sunset views. Home has different wings with several huge suites for everyone to enjoy their privacy. Primary bedrooms on both levels with the main primary on the second level commanding some of the most panoramic views - home has an elevator too. Other amenities include an exercise room, theatre, wine room... plus lots of extra space to build out additional rooms. Property has endless possibilities. A great entertainment home and a true masterpiece at the Pointe!
)
[ListOfficeName] => Array
(
[0] => Coldwell Banker Realty
)
[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] => Above Average
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => Basement,Three+
)
[View] => Array
(
[0] => Diamond Head,Ocean
)
[MaintenanceExpense] => Array
(
[0] => 569.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => CBPP
)
[ListAgentEmail] => Array
(
[0] => dolores.bediones@cbrealty.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 596-0456
)
[ListAgentFullName] => Array
(
[0] => Dolores P Bediones
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-09-23T15:46:03.990
)
[Matrix_Unique_ID] => Array
(
[0] => 18184540
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-08-08T08:18:08.027
)
[MLSAreaMajor] => Array
(
[0] => DiamondHd
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26651617
)
[listing_image] => Array
(
[0] => 26651617
[1] => 26651618
[2] => 26651619
[3] => 26651620
[4] => 26651621
[5] => 26651622
[6] => 26651623
[7] => 26651624
[8] => 26651625
[9] => 26651626
[10] => 26651627
[11] => 26651628
[12] => 26651629
[13] => 26651630
[14] => 26651631
[15] => 26651632
[16] => 26651633
[17] => 26651634
[18] => 26651635
[19] => 26659505
[20] => 26659506
[21] => 26659507
[22] => 26659508
[23] => 26659509
[24] => 26687888
[25] => 26687889
)
)
- BedsTotal: 6
- Full Baths: 6
- Half Baths: 1
- Land Area (sf): 23,849
- Living (sf): 11,987
- Year Built: 2006
- Property Condition: Above Average
- Number of Parking Spaces: 4
- View: Diamond Head,Ocean
- Listing Office: Coldwell Banker Realty
- Maintenance Fees: $569
- Land Tenure: FS - Fee Simple
