Listing
Overview
Price: $4,300,000
Area: HAWAII LOA RIDGE
Status: Active
Spectacular Diamond Head view from this beautiful home in Honolulu’s most prestigious Hawaii Loa Ridge gated community. High ceilings and open floor plan with spacious living room and dining area is perfect for entertaining. The house is on a perimeter lot with no back neighbors. All the bedrooms except one have its own restroom. Swimming pool, elevator, theater room, storage space and more. Please see virtual tour. One or more photos have been enhanced. Listing by: Waikiki Realty LLC (808) 955-8282
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202407521"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(3) "637"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(6) "Kahiau"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(4) "Loop"
}
["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(51) "https://my.matterport.com/show/?m=1a1VMdvGTXd&mls=1"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "4300000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "4300000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(16) "HAWAII LOA RIDGE"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(466) "Spectacular Diamond Head view from this beautiful home in Honolulu’s most prestigious Hawaii Loa Ridge gated community. High ceilings and open floor plan with spacious living room and dining area is perfect for entertaining. The house is on a perimeter lot with no back neighbors. All the bedrooms except one have its own restroom. Swimming pool, elevator, theater room, storage space and more. Please see virtual tour. One or more photos have been enhanced."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(18) "Waikiki Realty LLC"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "5"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "5"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "1"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "10910.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "4941"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1995"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(51) "Coastline,Diamond Head,Garden,Mountain,Ocean,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["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) "WRII"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(13) "ew808@aol.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 955-8282"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(10) "Edgar Y Wu"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-10-06T17:00:01.260"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17918916"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-04-02T14:29:40.403"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(9) "DiamondHd"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(12) "Preservation"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26150746"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26150746"
[1]=>
string(8) "26150747"
[2]=>
string(8) "26150748"
[3]=>
string(8) "26150749"
[4]=>
string(8) "26150750"
[5]=>
string(8) "26150751"
[6]=>
string(8) "26150752"
[7]=>
string(8) "26150753"
[8]=>
string(8) "26150754"
[9]=>
string(8) "26150755"
[10]=>
string(8) "26150756"
[11]=>
string(8) "26150757"
[12]=>
string(8) "26150758"
[13]=>
string(8) "26150759"
[14]=>
string(8) "26150760"
[15]=>
string(8) "26150761"
[16]=>
string(8) "26150762"
[17]=>
string(8) "26150763"
[18]=>
string(8) "26150764"
[19]=>
string(8) "26150765"
[20]=>
string(8) "26150766"
[21]=>
string(8) "26150767"
[22]=>
string(8) "26150768"
[23]=>
string(8) "26150769"
[24]=>
string(8) "26150770"
[25]=>
string(8) "26150771"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202407521
)
[StreetNumber] => Array
(
[0] => 637
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Kahiau
)
[StreetSuffix] => Array
(
[0] => Loop
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96821
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://my.matterport.com/show/?m=1a1VMdvGTXd&mls=1
)
[ListPrice] => Array
(
[0] => 4300000.00
)
[CurrentPrice] => Array
(
[0] => 4300000.00
)
[Neighbourhood] => Array
(
[0] => HAWAII LOA RIDGE
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Spectacular Diamond Head view from this beautiful home in Honolulu’s most prestigious Hawaii Loa Ridge gated community. High ceilings and open floor plan with spacious living room and dining area is perfect for entertaining. The house is on a perimeter lot with no back neighbors. All the bedrooms except one have its own restroom. Swimming pool, elevator, theater room, storage space and more. Please see virtual tour. One or more photos have been enhanced.
)
[ListOfficeName] => Array
(
[0] => Waikiki Realty LLC
)
[BedsTotal] => Array
(
[0] => 5
)
[BathsFull] => Array
(
[0] => 5
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 10910.00
)
[SqftTotal] => Array
(
[0] => 4941
)
[YearBuilt] => Array
(
[0] => 1995
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Coastline,Diamond Head,Garden,Mountain,Ocean,Sunset
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => WRII
)
[ListAgentEmail] => Array
(
[0] => ew808@aol.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 955-8282
)
[ListAgentFullName] => Array
(
[0] => Edgar Y Wu
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-10-06T17:00:01.260
)
[Matrix_Unique_ID] => Array
(
[0] => 17918916
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-04-02T14:29:40.403
)
[MLSAreaMajor] => Array
(
[0] => DiamondHd
)
[PropertyFrontage] => Array
(
[0] => Preservation
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26150746
)
[listing_image] => Array
(
[0] => 26150746
[1] => 26150747
[2] => 26150748
[3] => 26150749
[4] => 26150750
[5] => 26150751
[6] => 26150752
[7] => 26150753
[8] => 26150754
[9] => 26150755
[10] => 26150756
[11] => 26150757
[12] => 26150758
[13] => 26150759
[14] => 26150760
[15] => 26150761
[16] => 26150762
[17] => 26150763
[18] => 26150764
[19] => 26150765
[20] => 26150766
[21] => 26150767
[22] => 26150768
[23] => 26150769
[24] => 26150770
[25] => 26150771
)
)
- BedsTotal: 5
- Full Baths: 5
- Half Baths: 1
- Land Area (sf): 10,910
- Living (sf): 4,941
- Year Built: 1995
- Property Condition: Excellent
- Number of Parking Spaces: 2
- View: Coastline,Diamond Head,Garden,Mountain,Ocean,Sunset
- Listing Office: Waikiki Realty LLC
- Land Tenure: FS - Fee Simple
