Previous Next

57-120 Lalo Kuilima Way Unit 2/17 Kahuku, HI 96731

Listing
Overview

Price: $1,275,000
Area: KUILIMA
Status: Active

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202512173"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "57-120"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(15) "Condo/Townhouse"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(12) "Lalo Kuilima"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(3) "Way"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(4) "2/17"
  }
  ["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) "1275000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KUILIMA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1184) "Legal short-term rental goldmine on Oahu's North Shore with near $100,000 annual returns! Turn-key and guest-ready. Current and future bookings are available to inherit. Kuilima Estates East is immediately adjacent to the Ritz-Carlton Turtle Bay luxury hotel. This beautiful 1/1 unit is a cash cow with super-host status on AirB&B. The unit is situated on the back 9 of the Fazio golf course. The second Turtle Bay golf course is the championship-level Palmer course. The orientation of the unit provides an outstanding cross-breeze with the prevailing trade winds. The adjacent Ritz-Carlton Turtle Bay property also offers publicly accessible surf spots, hiking trails, mountain biking trails, beaches, stables, frisbee golf, restaurants, cafes and shops. Kuilima Estates East offers a pool, tennis court, pavilion (available for reservation at no cost), and a resident manager. A legal short-term rental is the perfect way to maintain a home on the North Shore of Oahu that generates revenue while you are not staying there. For use as a primary residence, Kuilima Estates East is approved for VA and USDA financing, and two dogs are allowed (as big as can be carried by the owner)."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(22) "HomeSmart Island Homes"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(9) "647519.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "785"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1975"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(17) "Kuilima Ests East"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(9) "Excellent"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(11) "Golf Course"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "934.99"
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(6) "Kahuku"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(6) "Kahuku"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(6) "Kahuku"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "HSIH"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(24) "mikeybruneau@hotmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 371-3001"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(13) "Mikey Bruneau"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18751351"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-07-07T11:19:57.037"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-05-17"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(11) "North Shore"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "11:19:57.037"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27000728"
  }
  ["listing_image"]=>
  array(21) {
    [0]=>
    string(8) "27000728"
    [1]=>
    string(8) "27000729"
    [2]=>
    string(8) "27000730"
    [3]=>
    string(8) "27000731"
    [4]=>
    string(8) "27000732"
    [5]=>
    string(8) "27000733"
    [6]=>
    string(8) "27000734"
    [7]=>
    string(8) "27000735"
    [8]=>
    string(8) "27000736"
    [9]=>
    string(8) "27000737"
    [10]=>
    string(8) "27000738"
    [11]=>
    string(8) "27000739"
    [12]=>
    string(8) "27000740"
    [13]=>
    string(8) "27000741"
    [14]=>
    string(8) "27000742"
    [15]=>
    string(8) "27000743"
    [16]=>
    string(8) "27000744"
    [17]=>
    string(8) "27000745"
    [18]=>
    string(8) "27000746"
    [19]=>
    string(8) "27000747"
    [20]=>
    string(8) "27000748"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202512173
        )

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

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

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

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

    [UnitNumber] => Array
        (
            [0] => 2/17
        )

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Legal short-term rental goldmine on Oahu's North Shore with near $100,000 annual returns! Turn-key and guest-ready. Current and future bookings are available to inherit. Kuilima Estates East is immediately adjacent to the Ritz-Carlton Turtle Bay luxury hotel. This beautiful 1/1 unit is a cash cow with super-host status on AirB&B. The unit is situated on the back 9 of the Fazio golf course. The second Turtle Bay golf course is the championship-level Palmer course. The orientation of the unit provides an outstanding cross-breeze with the prevailing trade winds. The adjacent Ritz-Carlton Turtle Bay property also offers publicly accessible surf spots, hiking trails, mountain biking trails, beaches, stables, frisbee golf, restaurants, cafes and shops. Kuilima Estates East offers a pool, tennis court, pavilion (available for reservation at no cost), and a resident manager. A legal short-term rental is the perfect way to maintain a home on the North Shore of Oahu that generates revenue while you are not staying there. For use as a primary residence, Kuilima Estates East is approved for VA and USDA financing, and two dogs are allowed (as big as can be carried by the owner).
        )

    [ListOfficeName] => Array
        (
            [0] => HomeSmart Island Homes
        )

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

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

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

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

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

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

    [BuildingName] => Array
        (
            [0] => Kuilima Ests East
        )

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

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

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

    [View] => Array
        (
            [0] => Golf Course
        )

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => mikeybruneau@hotmail.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 371-3001
        )

    [ListAgentFullName] => Array
        (
            [0] => Mikey Bruneau
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-07-07T11:19:57.037
        )

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

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 11:19:57.037
        )

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

    [listing_image] => Array
        (
            [0] => 27000728
            [1] => 27000729
            [2] => 27000730
            [3] => 27000731
            [4] => 27000732
            [5] => 27000733
            [6] => 27000734
            [7] => 27000735
            [8] => 27000736
            [9] => 27000737
            [10] => 27000738
            [11] => 27000739
            [12] => 27000740
            [13] => 27000741
            [14] => 27000742
            [15] => 27000743
            [16] => 27000744
            [17] => 27000745
            [18] => 27000746
            [19] => 27000747
            [20] => 27000748
        )

)

PROPERTY INFO

• BedsTotal: 1
• Full Baths: 1
• Land Area (sf): 647,519 sf
• Living (sf): 785
• Year Built: 1975
• Building Name: Kuilima Ests East

KEY FEATURES

• Property Condition: Excellent
• Number of Parking Spaces: 1
• View: Golf Course
• Listing Office: HomeSmart Island Homes

FINANCIAL INFO

• Maintenance Fees: $935
• Land Tenure: FS - Fee Simple

SCHOOLS

• Elementary School: Kahuku
• Middle School: Kahuku
• High School: Kahuku

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 July 7, 2025 - 11:19 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.