67-273 Kiapoko Street Unit 1 Waialua, HI 96791

Listing
Overview

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

This charming multi-unit home is located in a special neighborhood of Waialua oceanside of Waialua beach road. Flexible floor plan allows either a 3 bed/2 bath or currently configured as a 2/1 upstairs with an elevated deck that has an additional possibility of a crow's nest with an ocean view and a 1/1 downstairs each with separate entrances. This is an Attached home, part of a CPR. It has Vaulted ceilings upstairs bring in lots of light. The downstairs has been fully remodeled and currently brings in $3000/ month as a 30 day rental. Over 20K of extensive tropical landscaping surrounds the home with each unit having their own private outdoor space that has a resort like feel. A beautiful sandy beach is just a block away along with an amazing bike path. Haleiwa restaurants and shopping are close by. Convenient access to Schofield and the airport. Don't miss this opportunity to live on north shore and have additional rental income help pay for your mortgage! Listing by: eXp Realty (808) 725-2794

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202426358"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "67-273"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(7) "Kiapoko"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(7) "Waialua"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96791"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "1275000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "1275000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIALUA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(975) "This charming multi-unit home is located in a special neighborhood of Waialua oceanside of Waialua beach road.  Flexible floor plan allows either a 3 bed/2 bath or currently configured as a 2/1 upstairs with an elevated deck that has an additional possibility of a crow's nest with an ocean view and a 1/1 downstairs each with separate entrances. This is an Attached home, part of a CPR. It has Vaulted ceilings upstairs bring in lots of light. The downstairs has been fully remodeled and currently brings in $3000/ month as a 30 day rental. Over 20K of extensive tropical landscaping surrounds the home with each unit having their own private outdoor space that has a resort like feel.  A beautiful sandy beach is just a block away along with an amazing bike path.  Haleiwa restaurants and shopping are close by. Convenient access to Schofield and the airport.  Don't miss this opportunity to live on north shore and have additional rental income help pay for your mortgage!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(10) "eXp 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) "4025.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "1556"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1963"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(9) "Excellent"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "Two"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(8) "Mountain"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["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) "EXPI"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(24) "jason@oahuhomerealty.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 725-2794"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(10) "Jason Subt"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-11-22T18:30:01.483"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18375241"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-11-09T12:18:03.333"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(11) "North Shore"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26762282"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "26762282"
    [1]=>
    string(8) "26762283"
    [2]=>
    string(8) "26762284"
    [3]=>
    string(8) "26762285"
    [4]=>
    string(8) "26762286"
    [5]=>
    string(8) "26762287"
    [6]=>
    string(8) "26762288"
    [7]=>
    string(8) "26762289"
    [8]=>
    string(8) "26762290"
    [9]=>
    string(8) "26762291"
    [10]=>
    string(8) "26762292"
    [11]=>
    string(8) "26762293"
    [12]=>
    string(8) "26762294"
    [13]=>
    string(8) "26762295"
    [14]=>
    string(8) "26762296"
    [15]=>
    string(8) "26762297"
    [16]=>
    string(8) "26762298"
    [17]=>
    string(8) "26762299"
    [18]=>
    string(8) "26762300"
    [19]=>
    string(8) "26762301"
    [20]=>
    string(8) "26762302"
    [21]=>
    string(8) "26762303"
    [22]=>
    string(8) "26762304"
    [23]=>
    string(8) "26762305"
    [24]=>
    string(8) "26762306"
    [25]=>
    string(8) "26762307"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202426358
        )

    [StreetNumber] => Array
        (
            [0] => 67-273
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => This charming multi-unit home is located in a special neighborhood of Waialua oceanside of Waialua beach road.  Flexible floor plan allows either a 3 bed/2 bath or currently configured as a 2/1 upstairs with an elevated deck that has an additional possibility of a crow's nest with an ocean view and a 1/1 downstairs each with separate entrances. This is an Attached home, part of a CPR. It has Vaulted ceilings upstairs bring in lots of light. The downstairs has been fully remodeled and currently brings in $3000/ month as a 30 day rental. Over 20K of extensive tropical landscaping surrounds the home with each unit having their own private outdoor space that has a resort like feel.  A beautiful sandy beach is just a block away along with an amazing bike path.  Haleiwa restaurants and shopping are close by. Convenient access to Schofield and the airport.  Don't miss this opportunity to live on north shore and have additional rental income help pay for your mortgage!
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 725-2794
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-11-22T18:30:01.483
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-11-09T12:18:03.333
        )

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

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

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

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

    [listing_image] => Array
        (
            [0] => 26762282
            [1] => 26762283
            [2] => 26762284
            [3] => 26762285
            [4] => 26762286
            [5] => 26762287
            [6] => 26762288
            [7] => 26762289
            [8] => 26762290
            [9] => 26762291
            [10] => 26762292
            [11] => 26762293
            [12] => 26762294
            [13] => 26762295
            [14] => 26762296
            [15] => 26762297
            [16] => 26762298
            [17] => 26762299
            [18] => 26762300
            [19] => 26762301
            [20] => 26762302
            [21] => 26762303
            [22] => 26762304
            [23] => 26762305
            [24] => 26762306
            [25] => 26762307
        )

)

  • BedsTotal: 3
  • Full Baths: 2
  • Land Area (sf): 4,025
  • Living (sf): 1,556
  • Year Built: 1963

  • Property Condition: Excellent
  • Number of Parking Spaces: 3
  • View: Mountain
  • Listing Office: eXp Realty

  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

#RB-7120
info@marcushawaii.com
(808)839-7446