54-002 Haukoi Place Hauula, HI 96717

Take a Virtual Tour

Listing
Overview

Price: $1,950,000
Area: HAUULA
Status: Active

Welcome to your dream oceanfront retreat! This stunning property offers panoramic ocean views from every room, making it a true coastal paradise. Located directly adjacent to sandy beaches and a protected cove, you'll enjoy incredible swimming and beach days right at your doorstep. One of the standout features of this home is the permitted seawall, a rare and valuable addition for oceanfront properties. Inside, the home has been meticulously renovated with a focus on quality and attention to detail. Upgrades include a custom kitchen renovation with stainless steel appliances, redesigned bathrooms, new sliding doors and luxury vinyl flooring. The interior drywall has been replaced with shipboard style Cedar (tongue & groove) to enhance moisture protection and breathability as well the exterior finishes utilize high quality paint and materials to minimize maintenance With a versatile 3-bedroom, 3 bath layout, this home is perfect for entertaining, a weekend escape, or your permanent residence. Experience the ultimate in coastal living - schedule your private tour today! Listing by: Berkshire Hathaway HmSvc HI RE (808) 792-3910

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202421292"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "54-002"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(6) "Haukoi"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(5) "Place"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(6) "Hauula"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96717"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(41) "https://player.vimeo.com/video/1023881309"
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "1950000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "1950000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(6) "HAUULA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1087) "Welcome to your dream oceanfront retreat! This stunning property offers panoramic ocean views from every room, making it a true coastal paradise. Located directly adjacent to sandy beaches and a protected cove, you'll enjoy incredible swimming and beach days right at your doorstep. One of the standout features of this home is the permitted seawall, a rare and valuable addition for oceanfront properties.  Inside, the home has been meticulously renovated with a focus on quality and attention to detail. Upgrades include a custom kitchen renovation with stainless steel appliances, redesigned bathrooms, new sliding doors and luxury vinyl flooring. The interior drywall has been replaced with shipboard style Cedar (tongue & groove) to enhance moisture protection and breathability as well the exterior finishes utilize high quality paint and materials to minimize maintenance  With a versatile 3-bedroom, 3 bath layout, this home is perfect for entertaining, a weekend escape, or your permanent residence.  Experience the ultimate in coastal living - schedule your private tour today!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(30) "Berkshire Hathaway HmSvc HI RE"
  }
  ["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) "7372.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "1456"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1997"
  }
  ["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(32) "Coastline,Mountain,Ocean,Sunrise"
  }
  ["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) "BHHR"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(20) "scott@bhhshawaii.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 792-3910"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(15) "Scott D Larimer"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-10-31T16:27:15.600"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18268705"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-10-24T11:05:16.443"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(7) "Kaneohe"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(5) "Ocean"
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26748916"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "26748916"
    [1]=>
    string(8) "26748917"
    [2]=>
    string(8) "26748918"
    [3]=>
    string(8) "26748919"
    [4]=>
    string(8) "26748920"
    [5]=>
    string(8) "26748921"
    [6]=>
    string(8) "26748922"
    [7]=>
    string(8) "26748923"
    [8]=>
    string(8) "26748924"
    [9]=>
    string(8) "26748925"
    [10]=>
    string(8) "26748926"
    [11]=>
    string(8) "26748927"
    [12]=>
    string(8) "26748928"
    [13]=>
    string(8) "26748929"
    [14]=>
    string(8) "26748930"
    [15]=>
    string(8) "26748931"
    [16]=>
    string(8) "26748932"
    [17]=>
    string(8) "26748933"
    [18]=>
    string(8) "26748934"
    [19]=>
    string(8) "26748935"
    [20]=>
    string(8) "26748936"
    [21]=>
    string(8) "26748937"
    [22]=>
    string(8) "26748938"
    [23]=>
    string(8) "26748939"
    [24]=>
    string(8) "26748940"
    [25]=>
    string(8) "26748941"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202421292
        )

    [StreetNumber] => Array
        (
            [0] => 54-002
        )

    [PropertyType] => Array
        (
            [0] => Single Family
        )

    [StreetName] => Array
        (
            [0] => Haukoi
        )

    [StreetSuffix] => Array
        (
            [0] => Place
        )

    [UnitNumber] => Array
        (
            [0] => 
        )

    [City] => Array
        (
            [0] => Hauula
        )

    [StateOrProvince] => Array
        (
            [0] => HI
        )

    [PostalCode] => Array
        (
            [0] => 96717
        )

    [VirtualTourURLUnbranded] => Array
        (
            [0] => https://player.vimeo.com/video/1023881309
        )

    [ListPrice] => Array
        (
            [0] => 1950000.00
        )

    [CurrentPrice] => Array
        (
            [0] => 1950000.00
        )

    [Neighbourhood] => Array
        (
            [0] => HAUULA
        )

    [Status] => Array
        (
            [0] => Active
        )

    [PublicRemarks] => Array
        (
            [0] => Welcome to your dream oceanfront retreat! This stunning property offers panoramic ocean views from every room, making it a true coastal paradise. Located directly adjacent to sandy beaches and a protected cove, you'll enjoy incredible swimming and beach days right at your doorstep. One of the standout features of this home is the permitted seawall, a rare and valuable addition for oceanfront properties.  Inside, the home has been meticulously renovated with a focus on quality and attention to detail. Upgrades include a custom kitchen renovation with stainless steel appliances, redesigned bathrooms, new sliding doors and luxury vinyl flooring. The interior drywall has been replaced with shipboard style Cedar (tongue & groove) to enhance moisture protection and breathability as well the exterior finishes utilize high quality paint and materials to minimize maintenance  With a versatile 3-bedroom, 3 bath layout, this home is perfect for entertaining, a weekend escape, or your permanent residence.  Experience the ultimate in coastal living - schedule your private tour today!
        )

    [ListOfficeName] => Array
        (
            [0] => Berkshire Hathaway HmSvc HI RE
        )

    [BedsTotal] => Array
        (
            [0] => 3
        )

    [BathsFull] => Array
        (
            [0] => 3
        )

    [BathsHalf] => Array
        (
            [0] => 0
        )

    [LotSizeArea] => Array
        (
            [0] => 7372.00
        )

    [SqftTotal] => Array
        (
            [0] => 1456
        )

    [YearBuilt] => Array
        (
            [0] => 1997
        )

    [BuildingName] => Array
        (
            [0] => 
        )

    [PropertyCondition] => Array
        (
            [0] => Excellent
        )

    [ParkingTotal] => Array
        (
            [0] => 2
        )

    [StoriesType] => Array
        (
            [0] => Two
        )

    [View] => Array
        (
            [0] => Coastline,Mountain,Ocean,Sunrise
        )

    [MaintenanceExpense] => Array
        (
            [0] => 
        )

    [LandTenure] => Array
        (
            [0] => FS - Fee Simple
        )

    [ElementarySchool] => Array
        (
            [0] => 
        )

    [MiddleOrJuniorSchool] => Array
        (
            [0] => 
        )

    [HighSchool] => Array
        (
            [0] => 
        )

    [ListOfficeMLSID] => Array
        (
            [0] => BHHR
        )

    [ListAgentEmail] => Array
        (
            [0] => scott@bhhshawaii.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 792-3910
        )

    [ListAgentFullName] => Array
        (
            [0] => Scott D Larimer
        )

    [CloseDate] => Array
        (
            [0] => 
        )

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-10-31T16:27:15.600
        )

    [Matrix_Unique_ID] => Array
        (
            [0] => 18268705
        )

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-10-24T11:05:16.443
        )

    [MLSAreaMajor] => Array
        (
            [0] => Kaneohe
        )

    [PropertyFrontage] => Array
        (
            [0] => Ocean
        )

    [SpecialListingConditions] => Array
        (
            [0] => None
        )

    [_thumbnail_id] => Array
        (
            [0] => 26748916
        )

    [listing_image] => Array
        (
            [0] => 26748916
            [1] => 26748917
            [2] => 26748918
            [3] => 26748919
            [4] => 26748920
            [5] => 26748921
            [6] => 26748922
            [7] => 26748923
            [8] => 26748924
            [9] => 26748925
            [10] => 26748926
            [11] => 26748927
            [12] => 26748928
            [13] => 26748929
            [14] => 26748930
            [15] => 26748931
            [16] => 26748932
            [17] => 26748933
            [18] => 26748934
            [19] => 26748935
            [20] => 26748936
            [21] => 26748937
            [22] => 26748938
            [23] => 26748939
            [24] => 26748940
            [25] => 26748941
        )

)

  • BedsTotal: 3
  • Full Baths: 3
  • Land Area (sf): 7,372
  • Living (sf): 1,456
  • Year Built: 1997

  • Property Condition: Excellent
  • Number of Parking Spaces: 2
  • View: Coastline,Mountain,Ocean,Sunrise
  • Listing Office: Berkshire Hathaway HmSvc HI RE

  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

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