Listing
Overview
Price: $2,650,000
Area: SALT LAKE
Status: Active
This exceptional single-level estate sits on 12,131 sf land, offering astonishing views of Koolau Mountain ranges, golf course, Diamond Head, and ocean. As you enter through the automated driveway gate, you'll be greeted by mature landscaping. An abundance of natural beauty complements this exquisite home. This incredible home is accompanied with a 4 bedrooms , 3 ½ -bathrooms with wrap-around decks. Two expansive great rooms with soaring ceilings are also a standout feature of the property. Calling all chefs and entertainers! The gourmet commercial kitchen is equipped with Thermador refrigerator & Freezer, GE Monogram 6-burner gas stove, GE Profile combination double wall Advantium oven, Miele built-in coffee machines, a specious island with two sinks, and lots of cabinets. The estate also includes a pool, pool deck and poolside cabana. Additional amenities include Rheem central and Mitsubishi split AC, water heater, Takagi tankless water heater, 31 solar panels, and more.. This estate presents a rare opportunity to own an extraordinary piece of paradise. Some photos are digitally enhanced and virtually staged. Must see! Listing by: Moana Realty LLC (808) 389-1902
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202425960"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(3) "941"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(8) "Aliamanu"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Place"
}
["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) "96818"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(61) "https://www.youtube.com/embed/gdhZlQ9hg48?si=HRTRpFcIcfF4W318"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "2650000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "2650000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(9) "SALT LAKE"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1143) "This exceptional single-level estate sits on 12,131 sf land, offering astonishing views of Koolau Mountain ranges, golf course, Diamond Head, and ocean. As you enter through the automated driveway gate, you'll be greeted by mature landscaping. An abundance of natural beauty complements this exquisite home. This incredible home is accompanied with a 4 bedrooms , 3 ½ -bathrooms with wrap-around decks. Two expansive great rooms with soaring ceilings are also a standout feature of the property. Calling all chefs and entertainers! The gourmet commercial kitchen is equipped with Thermador refrigerator & Freezer, GE Monogram 6-burner gas stove, GE Profile combination double wall Advantium oven, Miele built-in coffee machines, a specious island with two sinks, and lots of cabinets. The estate also includes a pool, pool deck and poolside cabana. Additional amenities include Rheem central and Mitsubishi split AC, water heater, Takagi tankless water heater, 31 solar panels, and more.. This estate presents a rare opportunity to own an extraordinary piece of paradise. Some photos are digitally enhanced and virtually staged. Must see!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(16) "Moana Realty LLC"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "12131.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "3044"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1970"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "5"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(61) "City,Coastline,Diamond Head,Golf Course,Mountain,Ocean,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(9) "Salt Lake"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(8) "Moanalua"
}
["HighSchool"]=>
array(1) {
[0]=>
string(8) "Moanalua"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "MOAR"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(22) "hirokomiller@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 389-1902"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(15) "Hiroko O Miller"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-11-12T18:25:11.413"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18364754"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-11-12T10:14:40.320"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(5) "Metro"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26765532"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26765532"
[1]=>
string(8) "26765533"
[2]=>
string(8) "26765534"
[3]=>
string(8) "26765535"
[4]=>
string(8) "26765536"
[5]=>
string(8) "26765537"
[6]=>
string(8) "26765538"
[7]=>
string(8) "26765539"
[8]=>
string(8) "26765540"
[9]=>
string(8) "26765541"
[10]=>
string(8) "26765542"
[11]=>
string(8) "26765543"
[12]=>
string(8) "26765544"
[13]=>
string(8) "26765545"
[14]=>
string(8) "26765546"
[15]=>
string(8) "26765547"
[16]=>
string(8) "26765548"
[17]=>
string(8) "26765549"
[18]=>
string(8) "26765550"
[19]=>
string(8) "26765551"
[20]=>
string(8) "26765552"
[21]=>
string(8) "26765553"
[22]=>
string(8) "26765554"
[23]=>
string(8) "26765555"
[24]=>
string(8) "26765556"
[25]=>
string(8) "26765557"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202425960
)
[StreetNumber] => Array
(
[0] => 941
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Aliamanu
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96818
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://www.youtube.com/embed/gdhZlQ9hg48?si=HRTRpFcIcfF4W318
)
[ListPrice] => Array
(
[0] => 2650000.00
)
[CurrentPrice] => Array
(
[0] => 2650000.00
)
[Neighbourhood] => Array
(
[0] => SALT LAKE
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => This exceptional single-level estate sits on 12,131 sf land, offering astonishing views of Koolau Mountain ranges, golf course, Diamond Head, and ocean. As you enter through the automated driveway gate, you'll be greeted by mature landscaping. An abundance of natural beauty complements this exquisite home. This incredible home is accompanied with a 4 bedrooms , 3 ½ -bathrooms with wrap-around decks. Two expansive great rooms with soaring ceilings are also a standout feature of the property. Calling all chefs and entertainers! The gourmet commercial kitchen is equipped with Thermador refrigerator & Freezer, GE Monogram 6-burner gas stove, GE Profile combination double wall Advantium oven, Miele built-in coffee machines, a specious island with two sinks, and lots of cabinets. The estate also includes a pool, pool deck and poolside cabana. Additional amenities include Rheem central and Mitsubishi split AC, water heater, Takagi tankless water heater, 31 solar panels, and more.. This estate presents a rare opportunity to own an extraordinary piece of paradise. Some photos are digitally enhanced and virtually staged. Must see!
)
[ListOfficeName] => Array
(
[0] => Moana Realty LLC
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 4
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 12131.00
)
[SqftTotal] => Array
(
[0] => 3044
)
[YearBuilt] => Array
(
[0] => 1970
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 5
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => City,Coastline,Diamond Head,Golf Course,Mountain,Ocean,Sunset
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Salt Lake
)
[MiddleOrJuniorSchool] => Array
(
[0] => Moanalua
)
[HighSchool] => Array
(
[0] => Moanalua
)
[ListOfficeMLSID] => Array
(
[0] => MOAR
)
[ListAgentEmail] => Array
(
[0] => hirokomiller@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 389-1902
)
[ListAgentFullName] => Array
(
[0] => Hiroko O Miller
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-11-12T18:25:11.413
)
[Matrix_Unique_ID] => Array
(
[0] => 18364754
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-11-12T10:14:40.320
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26765532
)
[listing_image] => Array
(
[0] => 26765532
[1] => 26765533
[2] => 26765534
[3] => 26765535
[4] => 26765536
[5] => 26765537
[6] => 26765538
[7] => 26765539
[8] => 26765540
[9] => 26765541
[10] => 26765542
[11] => 26765543
[12] => 26765544
[13] => 26765545
[14] => 26765546
[15] => 26765547
[16] => 26765548
[17] => 26765549
[18] => 26765550
[19] => 26765551
[20] => 26765552
[21] => 26765553
[22] => 26765554
[23] => 26765555
[24] => 26765556
[25] => 26765557
)
)
- BedsTotal: 4
- Full Baths: 4
- Land Area (sf): 12,131
- Living (sf): 3,044
- Year Built: 1970
- Property Condition: Above Average
- Number of Parking Spaces: 5
- View: City,Coastline,Diamond Head,Golf Course,Mountain,Ocean,Sunset
- Listing Office: Moana Realty LLC
- Land Tenure: FS - Fee Simple
- Elementary School: Salt Lake
- Middle School: Moanalua
- High School: Moanalua