Listing
Overview
Price: $1,295,000
Area: KAAAWA
Status: Active
Discover the perfect blend of coastal serenity and mountain majesty with this upgraded multi-family home on the beautiful Windward Coast. Whether you’re looking for an investment property, a vacation retreat, or a multi-generational living solution, TURNKEY luxurious retreat offers endless possibilities with modern upgrades, spacious interiors, and ocean views. Moments from a beach park and hiking trails this is truly where the mountain meets the sea. Enjoy a unique home with 2 generously sized open concept layouts, each with light-filled living spaces and luxury designer finishes. A gourmet chef's kitchen and primary spa-like bathroom are the epitome of luxury. The expansive, covered wrap-around lanai with ocean views is perfect for seamless indoor-outdoor living and entertaining. An oversized private dwelling downstairs with soaring ceilings lanai has pristine upgrades throughout. Privacy gate, solar panels, lush landscaping and plenty of parking are the icing on the cake to this incredible property! Don't miss his rarely available versatile property ideal for extended families, rental income, or a combination of both - a rare gem that truly has it all. Listing by: List Sotheby's Int'l Realty (808) 282-1764
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202502343"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "51-409"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(7) "Hauhele"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(4) "Road"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(1) "B"
}
["City"]=>
array(1) {
[0]=>
string(6) "Kaaawa"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96730"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(41) "https://player.vimeo.com/video/1051497967"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1295000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(6) "KAAAWA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1175) "Discover the perfect blend of coastal serenity and mountain majesty with this upgraded multi-family home on the beautiful Windward Coast. Whether you’re looking for an investment property, a vacation retreat, or a multi-generational living solution, TURNKEY luxurious retreat offers endless possibilities with modern upgrades, spacious interiors, and ocean views. Moments from a beach park and hiking trails this is truly where the mountain meets the sea. Enjoy a unique home with 2 generously sized open concept layouts, each with light-filled living spaces and luxury designer finishes. A gourmet chef's kitchen and primary spa-like bathroom are the epitome of luxury. The expansive, covered wrap-around lanai with ocean views is perfect for seamless indoor-outdoor living and entertaining. An oversized private dwelling downstairs with soaring ceilings lanai has pristine upgrades throughout. Privacy gate, solar panels, lush landscaping and plenty of parking are the icing on the cake to this incredible property! Don't miss his rarely available versatile property ideal for extended families, rental income, or a combination of both - a rare gem that truly has it all."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(27) "List Sotheby's Int'l Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "5016.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "2848"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "2007"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(31) "Coastline,Garden,Mountain,Ocean"
}
["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) "LIST"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(29) "heather@surfhawaiianhomes.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 282-1764"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(18) "Heather Selvitelle"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18502095"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-02-04T15:30:01.727"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-01-30"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "15:30:01.727"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26860761"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26860761"
[1]=>
string(8) "26860762"
[2]=>
string(8) "26860763"
[3]=>
string(8) "26860764"
[4]=>
string(8) "26860765"
[5]=>
string(8) "26860766"
[6]=>
string(8) "26860767"
[7]=>
string(8) "26860768"
[8]=>
string(8) "26860769"
[9]=>
string(8) "26860770"
[10]=>
string(8) "26860771"
[11]=>
string(8) "26860772"
[12]=>
string(8) "26860773"
[13]=>
string(8) "26860774"
[14]=>
string(8) "26860775"
[15]=>
string(8) "26860776"
[16]=>
string(8) "26860777"
[17]=>
string(8) "26860778"
[18]=>
string(8) "26860779"
[19]=>
string(8) "26860780"
[20]=>
string(8) "26860781"
[21]=>
string(8) "26860782"
[22]=>
string(8) "26860783"
[23]=>
string(8) "26860784"
[24]=>
string(8) "26860785"
[25]=>
string(8) "26860786"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202502343
)
[StreetNumber] => Array
(
[0] => 51-409
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Hauhele
)
[StreetSuffix] => Array
(
[0] => Road
)
[UnitNumber] => Array
(
[0] => B
)
[City] => Array
(
[0] => Kaaawa
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96730
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://player.vimeo.com/video/1051497967
)
[ListPrice] => Array
(
[0] => 1295000.00
)
[Neighbourhood] => Array
(
[0] => KAAAWA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Discover the perfect blend of coastal serenity and mountain majesty with this upgraded multi-family home on the beautiful Windward Coast. Whether you’re looking for an investment property, a vacation retreat, or a multi-generational living solution, TURNKEY luxurious retreat offers endless possibilities with modern upgrades, spacious interiors, and ocean views. Moments from a beach park and hiking trails this is truly where the mountain meets the sea. Enjoy a unique home with 2 generously sized open concept layouts, each with light-filled living spaces and luxury designer finishes. A gourmet chef's kitchen and primary spa-like bathroom are the epitome of luxury. The expansive, covered wrap-around lanai with ocean views is perfect for seamless indoor-outdoor living and entertaining. An oversized private dwelling downstairs with soaring ceilings lanai has pristine upgrades throughout. Privacy gate, solar panels, lush landscaping and plenty of parking are the icing on the cake to this incredible property! Don't miss his rarely available versatile property ideal for extended families, rental income, or a combination of both - a rare gem that truly has it all.
)
[ListOfficeName] => Array
(
[0] => List Sotheby's Int'l Realty
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 3
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 5016.00
)
[SqftTotal] => Array
(
[0] => 2848
)
[YearBuilt] => Array
(
[0] => 2007
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Coastline,Garden,Mountain,Ocean
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => LIST
)
[ListAgentEmail] => Array
(
[0] => heather@surfhawaiianhomes.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 282-1764
)
[ListAgentFullName] => Array
(
[0] => Heather Selvitelle
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18502095
)
[MatrixModifiedDT] => Array
(
[0] => 2025-02-04T15:30:01.727
)
[ListingContractDate] => Array
(
[0] => 2025-01-30
)
[MLSAreaMajor] => Array
(
[0] => Kaneohe
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 15:30:01.727
)
[_thumbnail_id] => Array
(
[0] => 26860761
)
[listing_image] => Array
(
[0] => 26860761
[1] => 26860762
[2] => 26860763
[3] => 26860764
[4] => 26860765
[5] => 26860766
[6] => 26860767
[7] => 26860768
[8] => 26860769
[9] => 26860770
[10] => 26860771
[11] => 26860772
[12] => 26860773
[13] => 26860774
[14] => 26860775
[15] => 26860776
[16] => 26860777
[17] => 26860778
[18] => 26860779
[19] => 26860780
[20] => 26860781
[21] => 26860782
[22] => 26860783
[23] => 26860784
[24] => 26860785
[25] => 26860786
)
)
- BedsTotal: 3
- Full Baths: 3
- Land Area (sf): 5,016 sf
- Living (sf): 2,848
- Year Built: 2007
- Property Condition: Excellent
- Number of Parking Spaces: 4
- View: Coastline,Garden,Mountain,Ocean
- Listing Office: List Sotheby's Int'l Realty
- Land Tenure: FS - Fee Simple
