Previous Next

57-101 Kuilima Drive Unit 132F Kahuku, HI 96731

Listing
Overview

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

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202510247"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "57-101"
  }
  ["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(4) "132F"
  }
  ["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) "1035000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KUILIMA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1184) "Discover your perfect getaway with this rare fully furnished turn-key legal vacation rental nestled adjacent to the renowned Turtle Bay Resort. This exquisite golf course front studio unit, featuring a sleeping loft with a queen-size bed is ideal for those seeking a serene retreat on Oahu's stunning North Shore. Step into modern elegance with a beautifully designed space featuring a stylish bathroom complete with a newly tiled shower, mosaic floor, and sleek glass doors. The kitchen shines with shaker-style cabinets, gleaming quartz countertops, and brand-new appliances, making it as functional as it is stylish. Enjoy the fresh feel of new luxury vinyl plank flooring on the first floor and plush new carpet in the loft, all enhanced by a fresh coat of paint and a practical new staircase offering ample storage. Relish in the convenience of in-unit laundry, includes parking, and enjoy breathtaking golf course views from the comfort of a gated community. With two swimming pools, BBQ areas, tennis courts, scenic walking paths, lush landscaping, ample guest parking, and 24-hour security, this unit promises a tranquil and enjoyable stay. Your idyllic vacation haven awaits!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(7) "Compass"
  }
  ["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) "765523.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "489"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1973"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(17) "Kuilima Ests West"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(9) "Excellent"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "Two"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(11) "Golf Course"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "516.65"
  }
  ["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) "COHI"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(24) "lisa.styring@compass.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 381-5857"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(12) "Lisa Styring"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18696235"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-04-22T14:19:29.077"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-04-22"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(11) "North Shore"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(11) "Golf Course"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "14:19:29.077"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26968309"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "26968309"
    [1]=>
    string(8) "26968310"
    [2]=>
    string(8) "26968311"
    [3]=>
    string(8) "26968312"
    [4]=>
    string(8) "26968313"
    [5]=>
    string(8) "26968314"
    [6]=>
    string(8) "26968315"
    [7]=>
    string(8) "26968316"
    [8]=>
    string(8) "26968317"
    [9]=>
    string(8) "26968318"
    [10]=>
    string(8) "26968319"
    [11]=>
    string(8) "26968320"
    [12]=>
    string(8) "26968321"
    [13]=>
    string(8) "26968322"
    [14]=>
    string(8) "26968323"
    [15]=>
    string(8) "26968324"
    [16]=>
    string(8) "26968325"
    [17]=>
    string(8) "26968326"
    [18]=>
    string(8) "26968327"
    [19]=>
    string(8) "26968328"
    [20]=>
    string(8) "26968329"
    [21]=>
    string(8) "26968330"
    [22]=>
    string(8) "26968331"
    [23]=>
    string(8) "26968332"
    [24]=>
    string(8) "26968333"
    [25]=>
    string(8) "26968334"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202510247
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Discover your perfect getaway with this rare fully furnished turn-key legal vacation rental nestled adjacent to the renowned Turtle Bay Resort. This exquisite golf course front studio unit, featuring a sleeping loft with a queen-size bed is ideal for those seeking a serene retreat on Oahu's stunning North Shore. Step into modern elegance with a beautifully designed space featuring a stylish bathroom complete with a newly tiled shower, mosaic floor, and sleek glass doors. The kitchen shines with shaker-style cabinets, gleaming quartz countertops, and brand-new appliances, making it as functional as it is stylish. Enjoy the fresh feel of new luxury vinyl plank flooring on the first floor and plush new carpet in the loft, all enhanced by a fresh coat of paint and a practical new staircase offering ample storage. Relish in the convenience of in-unit laundry, includes parking, and enjoy breathtaking golf course views from the comfort of a gated community. With two swimming pools, BBQ areas, tennis courts, scenic walking paths, lush landscaping, ample guest parking, and 24-hour security, this unit promises a tranquil and enjoyable stay. Your idyllic vacation haven awaits!
        )

    [ListOfficeName] => Array
        (
            [0] => Compass
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => lisa.styring@compass.com
        )

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

    [ListAgentFullName] => Array
        (
            [0] => Lisa Styring
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-04-22T14:19:29.077
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-04-22
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 14:19:29.077
        )

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

    [listing_image] => Array
        (
            [0] => 26968309
            [1] => 26968310
            [2] => 26968311
            [3] => 26968312
            [4] => 26968313
            [5] => 26968314
            [6] => 26968315
            [7] => 26968316
            [8] => 26968317
            [9] => 26968318
            [10] => 26968319
            [11] => 26968320
            [12] => 26968321
            [13] => 26968322
            [14] => 26968323
            [15] => 26968324
            [16] => 26968325
            [17] => 26968326
            [18] => 26968327
            [19] => 26968328
            [20] => 26968329
            [21] => 26968330
            [22] => 26968331
            [23] => 26968332
            [24] => 26968333
            [25] => 26968334
        )

)

PROPERTY INFO

• Full Baths: 1
• Land Area (sf): 765,523 sf
• Living (sf): 489
• Year Built: 1973
• Building Name: Kuilima Ests West

KEY FEATURES

• Property Condition: Excellent
• Number of Parking Spaces: 1
• View: Golf Course
• Listing Office: Compass

FINANCIAL INFO

• Maintenance Fees: $517
• 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 April 22, 2025 - 2:19 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.