Previous Next

57-020 Kuilima Drive Unit 207 Kahuku, HI 96731

Listing
Overview

Price: $4,200,000
Area: KUILIMA
Status: Active

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202511552"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "57-020"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(15) "Condo/Townhouse"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(7) "Kuilima"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(5) "Drive"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(3) "207"
  }
  ["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) "4200000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KUILIMA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(935) "Luxurious cceanfront 3 bedroom Legal vacation rental property. Be part of the newly branded Ritz Carlton at Turtle Bay resort. Recent and extensive updates make this an ideal investment as it is a completely furnished and turn key property. High end finishes and appliances throughout. Enjoy ocean views from the lanai of this exceptional location.  Very close to a protected swimming cove with a sandy beach. Rare opportunity to invest and enjoy one of the most desirable resorts in the Hawaiian Islands. You and your guests have access to the many amenities of the resort. Roy's Beach house restaurant is adjacent to the building and provides great food and drinks at the swimming beach. Exceptional golfing on the Palmer course, restaurants, horseback riding, snorkeling, hiking to remote beaches and the world class surfing on north shore is all close by. Excellent income generating property legally recognized for nightly rental."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(16) "Real Broker, LLC"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "1698"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1972"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(26) "Ocean Villas at Turtle Bay"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(9) "Excellent"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(5) "Three"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(22) "Coastline,Garden,Ocean"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(7) "1744.00"
  }
  ["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) "RBLL"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(24) "jason@oahuhomerealty.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 497-2083"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(10) "Jason Subt"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18733208"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-05-06T14:24:47.780"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-05-06"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(11) "North Shore"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(17) "Ocean,Sandy Beach"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "14:24:47.780"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26986615"
  }
  ["listing_image"]=>
  array(22) {
    [0]=>
    string(8) "26986615"
    [1]=>
    string(8) "26986616"
    [2]=>
    string(8) "26986617"
    [3]=>
    string(8) "26986618"
    [4]=>
    string(8) "26986619"
    [5]=>
    string(8) "26986620"
    [6]=>
    string(8) "26986621"
    [7]=>
    string(8) "26986622"
    [8]=>
    string(8) "26986623"
    [9]=>
    string(8) "26986624"
    [10]=>
    string(8) "26986625"
    [11]=>
    string(8) "26986626"
    [12]=>
    string(8) "26986627"
    [13]=>
    string(8) "26986628"
    [14]=>
    string(8) "26986629"
    [15]=>
    string(8) "26986630"
    [16]=>
    string(8) "26986631"
    [17]=>
    string(8) "26986632"
    [18]=>
    string(8) "26986633"
    [19]=>
    string(8) "26986634"
    [20]=>
    string(8) "26986635"
    [21]=>
    string(8) "26986636"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202511552
        )

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

    [PropertyType] => Array
        (
            [0] => Condo/Townhouse
        )

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Luxurious cceanfront 3 bedroom Legal vacation rental property. Be part of the newly branded Ritz Carlton at Turtle Bay resort. Recent and extensive updates make this an ideal investment as it is a completely furnished and turn key property. High end finishes and appliances throughout. Enjoy ocean views from the lanai of this exceptional location.  Very close to a protected swimming cove with a sandy beach. Rare opportunity to invest and enjoy one of the most desirable resorts in the Hawaiian Islands. You and your guests have access to the many amenities of the resort. Roy's Beach house restaurant is adjacent to the building and provides great food and drinks at the swimming beach. Exceptional golfing on the Palmer course, restaurants, horseback riding, snorkeling, hiking to remote beaches and the world class surfing on north shore is all close by. Excellent income generating property legally recognized for nightly rental.
        )

    [ListOfficeName] => Array
        (
            [0] => Real Broker, LLC
        )

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

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

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

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

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

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

    [BuildingName] => Array
        (
            [0] => Ocean Villas at Turtle Bay
        )

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => jason@oahuhomerealty.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 497-2083
        )

    [ListAgentFullName] => Array
        (
            [0] => Jason Subt
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-05-06T14:24:47.780
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-05-06
        )

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

    [PropertyFrontage] => Array
        (
            [0] => Ocean,Sandy Beach
        )

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

    [MatrixModifiedTime] => Array
        (
            [0] => 14:24:47.780
        )

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

    [listing_image] => Array
        (
            [0] => 26986615
            [1] => 26986616
            [2] => 26986617
            [3] => 26986618
            [4] => 26986619
            [5] => 26986620
            [6] => 26986621
            [7] => 26986622
            [8] => 26986623
            [9] => 26986624
            [10] => 26986625
            [11] => 26986626
            [12] => 26986627
            [13] => 26986628
            [14] => 26986629
            [15] => 26986630
            [16] => 26986631
            [17] => 26986632
            [18] => 26986633
            [19] => 26986634
            [20] => 26986635
            [21] => 26986636
        )

)

PROPERTY INFO

• BedsTotal: 3
• Full Baths: 2
• Living (sf): 1,698
• Year Built: 1972
• Building Name: Ocean Villas at Turtle Bay

KEY FEATURES

• Property Condition: Excellent
• Number of Parking Spaces: 1
• View: Coastline,Garden,Ocean
• Listing Office: Real Broker, LLC

FINANCIAL INFO

• Maintenance Fees: $1,744
• Land Tenure: FS - Fee Simple

SCHOOLS

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 May 6, 2025 - 2:24 PM 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.