66-465 Kilioe Place Haleiwa, HI 96712

Listing
Overview

Price: $1,400,000
Area: HALEIWA
Status: Active

Location! A rare opportunity to own in the heart of Historic Haleiwa Town. Live on a quiet Cul-de-sac that borders lush farmland and yet, walking distance to all of the North Shore restaurants, cafes, boutiques, art galleries, surf shops, grocery shopping and medical/dental offices. Close to all the surf spots, close to schools and 10 miles to Scholfield. This is truly country living in the hub of Haleiwa. Listing by: Sterman Realty (808) 799-7014

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202422036"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "66-465"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(6) "Kilioe"
  }
  ["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) "1400000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "1400000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "HALEIWA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(409) "Location! A rare opportunity to own in the heart of Historic Haleiwa Town. Live on a quiet Cul-de-sac that borders lush farmland and yet, walking distance to all of the North Shore restaurants, cafes, boutiques, art galleries, surf shops, grocery shopping and medical/dental offices. Close to all the surf spots, close to schools and 10 miles to Scholfield. This is truly country living in the hub of Haleiwa."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(14) "Sterman Realty"
  }
  ["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(7) "5169.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "1120"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1974"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(7) "Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(6) "Garden"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(7) "Haleiwa"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(7) "Waialua"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(7) "Waialua"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "STER"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(22) "krissiecrowe@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 799-7014"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(15) "Kristin A Crowe"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-10-03T07:35:40.640"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18288751"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-10-02T19:50:54.043"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(11) "North Shore"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26716868"
  }
  ["listing_image"]=>
  array(10) {
    [0]=>
    string(8) "26716868"
    [1]=>
    string(8) "26716869"
    [2]=>
    string(8) "26716870"
    [3]=>
    string(8) "26716871"
    [4]=>
    string(8) "26716872"
    [5]=>
    string(8) "26716873"
    [6]=>
    string(8) "26716874"
    [7]=>
    string(8) "26716875"
    [8]=>
    string(8) "26716876"
    [9]=>
    string(8) "26716877"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202422036
        )

    [StreetNumber] => Array
        (
            [0] => 66-465
        )

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

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

    [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] => 1400000.00
        )

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Location! A rare opportunity to own in the heart of Historic Haleiwa Town. Live on a quiet Cul-de-sac that borders lush farmland and yet, walking distance to all of the North Shore restaurants, cafes, boutiques, art galleries, surf shops, grocery shopping and medical/dental offices. Close to all the surf spots, close to schools and 10 miles to Scholfield. This is truly country living in the hub of Haleiwa.
        )

    [ListOfficeName] => Array
        (
            [0] => Sterman Realty
        )

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

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

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

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

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

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

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

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

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

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

    [View] => Array
        (
            [0] => Garden
        )

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

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

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

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

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

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

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

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 799-7014
        )

    [ListAgentFullName] => Array
        (
            [0] => Kristin A Crowe
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-10-03T07:35:40.640
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-10-02T19:50:54.043
        )

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

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

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

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

    [listing_image] => Array
        (
            [0] => 26716868
            [1] => 26716869
            [2] => 26716870
            [3] => 26716871
            [4] => 26716872
            [5] => 26716873
            [6] => 26716874
            [7] => 26716875
            [8] => 26716876
            [9] => 26716877
        )

)

  • BedsTotal: 3
  • Full Baths: 2
  • Land Area (sf): 5,169 sf
  • Living (sf): 1,120
  • Year Built: 1974

  • Property Condition: Average
  • Number of Parking Spaces: 2
  • View: Garden
  • Listing Office: Sterman Realty

  • Land Tenure: FS - Fee Simple

  • Elementary School: Haleiwa
  • Middle School: Waialua
  • High School: Waialua

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 October 3, 2024 - 7:35 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.

© Marcus Realty. All Rights Reserved.