Previous Next

57-091 Lalo Kuilima Place Unit #6/51 Kahuku, HI 96731

Listing
Overview

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

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202605741"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "57-091"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(15) "Condo/Townhouse"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(12) "Lalo Kuilima"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(5) "Place"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(5) "#6/51"
  }
  ["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) "1200000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KUILIMA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1216) "INVESTOR’S PARADISE Legal Vac. Rental on Oahu’s North Shore within Turtle Bay Resort which includes beach & Resort access to the Ritz-Carlton Oahu Turtle Bay with it’s in-house dining offerings(Alaia Restaurant,Off The Lip Lobby Bar,Sunset Pool Bar,Ho’olana Coffee Shop,Paniolo Luau),as well as Beach House by Roy’s & Leileis Bar n Grill. On-property Free activities include Surfing,Boogieboarding,Swimming,Snorkeling,SUP’ing,Hike & Bike Trails,Pickleball,& Tennis while Paid activities include Sea Turtle Outrigger Canoeing,Kayaking,Horseback Riding,Guided Night Snorkeling,Wood Carving,Bird Watch Tour,& Helicopter Tours. This unit is less than 10-min drive to the famous N. Shore beaches, Sunset Beach, Pipeline & Waimea Bay. Located on the preferred “East” Kuilima Estates for cooler tradewinds & level grounds. Lovely corner unit has private front lanai for sunning and relaxing. Bedroom has a King & screened in lanai with green space & golf course view. 2 A/C units insure your comfort. Updated Kitchen & Bathroom, Walk-in shower has seat & hand held option. Full sofa bed,2 TVs,cable,desk & wifi,even on the lanais. Flexible to vac. rent OR block time for you to enjoy your oasis in paradise!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(21) "Hawaii Seaside Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["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) "848"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1975"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(17) "Kuilima Ests East"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(18) "Garden,Golf Course"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "945.61"
  }
  ["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) "HISR"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(24) "rockyhiseaside@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 371-4641"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(16) "Rockwell K Canon"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19339388"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-03-30T09:20:34.680"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2026-03-13"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(11) "North Shore"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(17) "Golf Course,Other"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "09:20:34.680"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27334551"
  }
  ["listing_image"]=>
  array(22) {
    [0]=>
    string(8) "27334551"
    [1]=>
    string(8) "27334552"
    [2]=>
    string(8) "27334553"
    [3]=>
    string(8) "27334554"
    [4]=>
    string(8) "27334555"
    [5]=>
    string(8) "27334556"
    [6]=>
    string(8) "27334557"
    [7]=>
    string(8) "27334558"
    [8]=>
    string(8) "27334559"
    [9]=>
    string(8) "27334560"
    [10]=>
    string(8) "27334561"
    [11]=>
    string(8) "27334562"
    [12]=>
    string(8) "27334563"
    [13]=>
    string(8) "27334564"
    [14]=>
    string(8) "27345157"
    [15]=>
    string(8) "27345158"
    [16]=>
    string(8) "27345159"
    [17]=>
    string(8) "27345160"
    [18]=>
    string(8) "27345161"
    [19]=>
    string(8) "27345162"
    [20]=>
    string(8) "27345163"
    [21]=>
    string(8) "27345164"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202605741
        )

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

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

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

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

    [UnitNumber] => Array
        (
            [0] => #6/51
        )

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => INVESTOR’S PARADISE Legal Vac. Rental on Oahu’s North Shore within Turtle Bay Resort which includes beach & Resort access to the Ritz-Carlton Oahu Turtle Bay with it’s in-house dining offerings(Alaia Restaurant,Off The Lip Lobby Bar,Sunset Pool Bar,Ho’olana Coffee Shop,Paniolo Luau),as well as Beach House by Roy’s & Leileis Bar n Grill. On-property Free activities include Surfing,Boogieboarding,Swimming,Snorkeling,SUP’ing,Hike & Bike Trails,Pickleball,& Tennis while Paid activities include Sea Turtle Outrigger Canoeing,Kayaking,Horseback Riding,Guided Night Snorkeling,Wood Carving,Bird Watch Tour,& Helicopter Tours. This unit is less than 10-min drive to the famous N. Shore beaches, Sunset Beach, Pipeline & Waimea Bay. Located on the preferred “East” Kuilima Estates for cooler tradewinds & level grounds. Lovely corner unit has private front lanai for sunning and relaxing. Bedroom has a King & screened in lanai with green space & golf course view. 2 A/C units insure your comfort. Updated Kitchen & Bathroom, Walk-in shower has seat & hand held option. Full sofa bed,2 TVs,cable,desk & wifi,even on the lanais. Flexible to vac. rent OR block time for you to enjoy your oasis in paradise!
        )

    [ListOfficeName] => Array
        (
            [0] => Hawaii Seaside Realty
        )

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

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

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

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

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

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

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

    [PropertyCondition] => Array
        (
            [0] => Above Average
        )

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => rockyhiseaside@gmail.com
        )

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

    [ListAgentFullName] => Array
        (
            [0] => Rockwell K Canon
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-03-30T09:20:34.680
        )

    [ListingContractDate] => Array
        (
            [0] => 2026-03-13
        )

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

    [PropertyFrontage] => Array
        (
            [0] => Golf Course,Other
        )

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

    [MatrixModifiedTime] => Array
        (
            [0] => 09:20:34.680
        )

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

    [listing_image] => Array
        (
            [0] => 27334551
            [1] => 27334552
            [2] => 27334553
            [3] => 27334554
            [4] => 27334555
            [5] => 27334556
            [6] => 27334557
            [7] => 27334558
            [8] => 27334559
            [9] => 27334560
            [10] => 27334561
            [11] => 27334562
            [12] => 27334563
            [13] => 27334564
            [14] => 27345157
            [15] => 27345158
            [16] => 27345159
            [17] => 27345160
            [18] => 27345161
            [19] => 27345162
            [20] => 27345163
            [21] => 27345164
        )

)

PROPERTY INFO

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

KEY FEATURES

• Property Condition: Above Average
• Number of Parking Spaces: 1
• View: Garden,Golf Course
• Listing Office: Hawaii Seaside Realty

FINANCIAL INFO

• Maintenance Fees: $946
• 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 March 30, 2026 - 9:20 AM Information is deemed reliable but not guaranteed. Copyright: 2026 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.