57-320 Pahipahialua Street Kahuku, HI 96731

Listing
Overview

Price: $4,590,000
Area: KAWELA BAY
Status: Active

Paradise Found! Beachfront Home with Private access steps onto the sand at Kawela Bay on the North Shore near Turtle Bay Resort! Gated highly sought after community, hurry and make this UNIQUELY Large 4 bedroom 4 1/2 bathroom your Hawaiian retreat! You'll love the tranquility of your drive towards the entry of your large garage as a Hawaiian freshwater pond sits to the right of the home. Take in the Sunrise from your extended lanais! Whether you are working from home or taking time away from work to relax, the Master Bedroom will be enjoyed for morning coffee on your deck watching the surf roll in. Modern black finishes complement the fireplace that peers into the Master Bathroom and the view of the ocean from your jacuzzi tub is simply stunning! Spacious Dining & Entertaining options throughout the home, why not welcome family and guests to enjoy Hawaii living at it's best! Luxurious Flagstone Flooring throughout the generous floor-plan of the home which has a private entry studio below with its own personal wet bar! Large Rooms either have their own private bathrooms or a door leading out onto the covered lanai! Lush green lawn outback has private steps onto the beach! Listing by: eXp Realty (808) 381-7824

array(42) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202132041"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "57-320"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(12) "Pahipahialua"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(6) "Kahuku"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96731"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "4590000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "4590000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(10) "KAWELA BAY"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1189) "Paradise Found! Beachfront Home with Private access steps onto the sand at Kawela Bay on the North Shore near Turtle Bay Resort! Gated highly sought after community, hurry and make this UNIQUELY Large 4 bedroom 4 1/2 bathroom your Hawaiian retreat! You'll love the tranquility of your drive towards the entry of your large garage as a Hawaiian freshwater pond sits to the right of the home. Take in the Sunrise from your extended lanais! Whether you are working from home or taking time away from work to relax, the Master Bedroom will be enjoyed for morning coffee on your deck watching the surf roll in. Modern black finishes complement the fireplace that peers into the Master Bathroom and the view of the ocean from your jacuzzi tub is simply stunning! Spacious Dining & Entertaining options throughout the home, why not welcome family and guests to enjoy Hawaii living at it's best! Luxurious Flagstone Flooring throughout the generous floor-plan of the home which has a private entry studio below with its own personal wet bar! Large Rooms either have their own private bathrooms or a door leading out onto the covered lanai! Lush green lawn outback has private steps onto the beach!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(10) "eXp Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(8) "11326.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "4825"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1940"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(9) "Excellent"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "Two"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(22) "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) "EXPI"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(30) "tiarelando@legacylivingnow.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 381-7824"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(11) "Tiare Lando"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2023-07-03T12:05:25.110"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "16366368"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2022-01-04T14:24:21.310"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "25830064"
  }
  ["listing_image"]=>
  array(25) {
    [0]=>
    string(8) "25830064"
    [1]=>
    string(8) "25830065"
    [2]=>
    string(8) "25830066"
    [3]=>
    string(8) "25830067"
    [4]=>
    string(8) "25830068"
    [5]=>
    string(8) "25830069"
    [6]=>
    string(8) "25830070"
    [7]=>
    string(8) "25830071"
    [8]=>
    string(8) "25830072"
    [9]=>
    string(8) "25830073"
    [10]=>
    string(8) "25830074"
    [11]=>
    string(8) "25830075"
    [12]=>
    string(8) "25830076"
    [13]=>
    string(8) "25830077"
    [14]=>
    string(8) "25830078"
    [15]=>
    string(8) "25830079"
    [16]=>
    string(8) "25830080"
    [17]=>
    string(8) "25830081"
    [18]=>
    string(8) "25830082"
    [19]=>
    string(8) "25830083"
    [20]=>
    string(8) "25830084"
    [21]=>
    string(8) "25830085"
    [22]=>
    string(8) "25830086"
    [23]=>
    string(8) "25830087"
    [24]=>
    string(8) "25830088"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202132041
        )

    [StreetNumber] => Array
        (
            [0] => 57-320
        )

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

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

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

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

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

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

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

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

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

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

    [Neighbourhood] => Array
        (
            [0] => KAWELA BAY
        )

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

    [PublicRemarks] => Array
        (
            [0] => Paradise Found! Beachfront Home with Private access steps onto the sand at Kawela Bay on the North Shore near Turtle Bay Resort! Gated highly sought after community, hurry and make this UNIQUELY Large 4 bedroom 4 1/2 bathroom your Hawaiian retreat! You'll love the tranquility of your drive towards the entry of your large garage as a Hawaiian freshwater pond sits to the right of the home. Take in the Sunrise from your extended lanais! Whether you are working from home or taking time away from work to relax, the Master Bedroom will be enjoyed for morning coffee on your deck watching the surf roll in. Modern black finishes complement the fireplace that peers into the Master Bathroom and the view of the ocean from your jacuzzi tub is simply stunning! Spacious Dining & Entertaining options throughout the home, why not welcome family and guests to enjoy Hawaii living at it's best! Luxurious Flagstone Flooring throughout the generous floor-plan of the home which has a private entry studio below with its own personal wet bar! Large Rooms either have their own private bathrooms or a door leading out onto the covered lanai! Lush green lawn outback has private steps onto the beach!
        )

    [ListOfficeName] => Array
        (
            [0] => eXp Realty
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => tiarelando@legacylivingnow.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 381-7824
        )

    [ListAgentFullName] => Array
        (
            [0] => Tiare Lando
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2023-07-03T12:05:25.110
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2022-01-04T14:24:21.310
        )

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

    [listing_image] => Array
        (
            [0] => 25830064
            [1] => 25830065
            [2] => 25830066
            [3] => 25830067
            [4] => 25830068
            [5] => 25830069
            [6] => 25830070
            [7] => 25830071
            [8] => 25830072
            [9] => 25830073
            [10] => 25830074
            [11] => 25830075
            [12] => 25830076
            [13] => 25830077
            [14] => 25830078
            [15] => 25830079
            [16] => 25830080
            [17] => 25830081
            [18] => 25830082
            [19] => 25830083
            [20] => 25830084
            [21] => 25830085
            [22] => 25830086
            [23] => 25830087
            [24] => 25830088
        )

)

  • BedsTotal: 4
  • Full Baths: 4
  • Half Baths: 1
  • Land Area (sf): 11,326
  • Living (sf): 4,825
  • Year Built: 1940

  • Property Condition: Excellent
  • Number of Parking Spaces: 3
  • View: Mountain,Ocean,Sunrise
  • Listing Office: eXp Realty

  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

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