58-307 Kaunala Place Haleiwa, HI 96712

Listing
Overview

Price: $1,799,000
Area: SUNSET/VELZY
Status: Active

Immerse yourself in luxury with this fully renovated home on a tranquil street of Oahu's North Shore, designed with high-end furniture tailored for every space. This turnkey property comes fully furnished and features two distinct units: the main house with 3 bedrooms and 2.5 baths, including a separate primary suite accessible from the pool deck with its own full bathroom, enhancing privacy and luxury. This main house also has a 1 car garage with a new, modern garage door. The upper unit adds an exclusive touch with its own entrance, deck, and a spa-like bathroom complete with a rainfall shower and freestanding tub. Beneath this unit is a massive carport big enough for a boat. Steps from Sunset Beach (with deeded access!), this home is perfect for those who value refined living in a prime location. Ideal for buyers looking for a sophisticated, fully furnished residence. Other amenities include 2 sets of washers and dryers, 6 split AC units, a bonus room with high ceilings and a half bath, new exterior gates, 2 enclosed storage rooms, and custom closet systems. Full upgrade list available soon! Listing by: Coldwell Banker Realty (808) 738-3904

array(48) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202417228"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "58-307"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(7) "Kaunala"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(5) "Place"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(7) "Haleiwa"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96712"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "1799000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "1875000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(12) "SUNSET/VELZY"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1111) "Immerse yourself in luxury with this fully renovated home on a tranquil street of Oahu's North Shore, designed with high-end furniture tailored for every space. This turnkey property comes fully furnished and features two distinct units: the main house with 3 bedrooms and 2.5 baths, including a separate primary suite accessible from the pool deck with its own full bathroom, enhancing privacy and luxury. This main house also has a 1 car garage with a new, modern garage door. The upper unit adds an exclusive touch with its own entrance, deck, and a spa-like bathroom complete with a rainfall shower and freestanding tub. Beneath this unit is a massive carport big enough for a boat. Steps from Sunset Beach (with deeded access!), this home is perfect for those who value refined living in a prime location. Ideal for buyers looking for a sophisticated, fully furnished residence. Other amenities include 2 sets of washers and dryers, 6 split AC units, a bonus room with high ceilings and a half bath, new exterior gates, 2 enclosed storage rooms, and custom closet systems. Full upgrade list available soon!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(22) "Coldwell Banker Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "5204.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "1609"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1963"
  }
  ["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(15) "Mountain,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(6) "CBPP02"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(26) "james.jenkins@cbrealty.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 738-3904"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(13) "James Jenkins"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-02-27T08:58:26.173"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18161585"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-08-02T08:11:50.757"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(11) "North Shore"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26645366"
  }
  ["listing_image"]=>
  array(23) {
    [0]=>
    string(8) "26645366"
    [1]=>
    string(8) "26645367"
    [2]=>
    string(8) "26645368"
    [3]=>
    string(8) "26645369"
    [4]=>
    string(8) "26645370"
    [5]=>
    string(8) "26645371"
    [6]=>
    string(8) "26645372"
    [7]=>
    string(8) "26645373"
    [8]=>
    string(8) "26645374"
    [9]=>
    string(8) "26645375"
    [10]=>
    string(8) "26645376"
    [11]=>
    string(8) "26645377"
    [12]=>
    string(8) "26645378"
    [13]=>
    string(8) "26645379"
    [14]=>
    string(8) "26645380"
    [15]=>
    string(8) "26645381"
    [16]=>
    string(8) "26645382"
    [17]=>
    string(8) "26645383"
    [18]=>
    string(8) "26645384"
    [19]=>
    string(8) "26645385"
    [20]=>
    string(8) "26645386"
    [21]=>
    string(8) "26645387"
    [22]=>
    string(8) "26645388"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2024-08-02"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "08:58:26.173"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202417228
        )

    [StreetNumber] => Array
        (
            [0] => 58-307
        )

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

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

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

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

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

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

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

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

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

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

    [Neighbourhood] => Array
        (
            [0] => SUNSET/VELZY
        )

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

    [PublicRemarks] => Array
        (
            [0] => Immerse yourself in luxury with this fully renovated home on a tranquil street of Oahu's North Shore, designed with high-end furniture tailored for every space. This turnkey property comes fully furnished and features two distinct units: the main house with 3 bedrooms and 2.5 baths, including a separate primary suite accessible from the pool deck with its own full bathroom, enhancing privacy and luxury. This main house also has a 1 car garage with a new, modern garage door. The upper unit adds an exclusive touch with its own entrance, deck, and a spa-like bathroom complete with a rainfall shower and freestanding tub. Beneath this unit is a massive carport big enough for a boat. Steps from Sunset Beach (with deeded access!), this home is perfect for those who value refined living in a prime location. Ideal for buyers looking for a sophisticated, fully furnished residence. Other amenities include 2 sets of washers and dryers, 6 split AC units, a bonus room with high ceilings and a half bath, new exterior gates, 2 enclosed storage rooms, and custom closet systems. Full upgrade list available soon!
        )

    [ListOfficeName] => Array
        (
            [0] => Coldwell Banker Realty
        )

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

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

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

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

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

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

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

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

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

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

    [View] => Array
        (
            [0] => Mountain,Sunset
        )

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => james.jenkins@cbrealty.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 738-3904
        )

    [ListAgentFullName] => Array
        (
            [0] => James Jenkins
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-02-27T08:58:26.173
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-08-02T08:11:50.757
        )

    [MLSAreaMajor] => Array
        (
            [0] => North Shore
        )

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

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

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

    [listing_image] => Array
        (
            [0] => 26645366
            [1] => 26645367
            [2] => 26645368
            [3] => 26645369
            [4] => 26645370
            [5] => 26645371
            [6] => 26645372
            [7] => 26645373
            [8] => 26645374
            [9] => 26645375
            [10] => 26645376
            [11] => 26645377
            [12] => 26645378
            [13] => 26645379
            [14] => 26645380
            [15] => 26645381
            [16] => 26645382
            [17] => 26645383
            [18] => 26645384
            [19] => 26645385
            [20] => 26645386
            [21] => 26645387
            [22] => 26645388
        )

    [ListingContractDate] => Array
        (
            [0] => 2024-08-02
        )

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

    [MatrixModifiedTime] => Array
        (
            [0] => 08:58:26.173
        )

)

  • BedsTotal: 4
  • Full Baths: 2
  • Half Baths: 1
  • Land Area (sf): 5,204 sf
  • Living (sf): 1,609
  • Year Built: 1963

  • Property Condition: Excellent
  • Number of Parking Spaces: 3
  • View: Mountain,Sunset
  • Listing Office: Coldwell Banker Realty

  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

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

Based on information from the Multiple Listing Service of HiCentral MLS, Ltd. listings last updated on February 27, 2025 - 8:58 AM Information is deemed reliable but not guaranteed. Copyright: 2025 by HiCentral MLS, Ltd.
Some of the active listings appearing on this site may be listed by other REALTORS®. If you are interested in those active listings, our company may represent you as the buyer's agent. If the active listing you are interested in is our company's active listing, you may speak to one of our agents regarding your options for representation.