Previous Next

47-523 Waipaipai Street Kaneohe, HI 96744

Take a Virtual Tour

Listing
Overview

Price: $1,300,000
Area: AHUIMANU AREA
Status: Active Under Contract

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202604193"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "47-523"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(9) "Waipaipai"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(7) "Kaneohe"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96744"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(45) "https://my.matterport.com/show/?m=R4a3YVftkjE"
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "1300000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(13) "AHUIMANU AREA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(21) "Active Under Contract"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1203) "Located on a quiet street in Ahuimanu, this 4 bed / 3 bath, 2390 sf house, has a very open floor plan complemented by huge picturesque windows with awesome panoramic Koolau views and plenty of natural light. There is 448-sf lanai directly off the living/dining room that is perfect for indoor/outdoor living, and fantastic for entertaining. The 9,450-sf lot is very private, nicely landscaped, terraced, and perched above Kahalu’u Stream which flows right behind your back yard. The versatile floor plan is ideal for a big family. There are 2 beds/2 baths upstairs with a full kitchen and 2 beds/1 bath, wet bar, and a 336sf screen in porch downstairs. There is an interior staircase between all 3 levels but also a separate entrance for downstairs so it very easily could be used for one big family, multigenerational living, or rental income. Additional features include a Monier tile roof, solar water heater, ceramic tile, hardwood floor, enclosed garage, and a driveway big enough for 2+ cars. Priced below assessed value for a quick sale, it’s in good shape, has solid bones, and with a little bit of updating this house could easily shine again. Come to the first open house on 3-1-26, 2-5pm."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(25) "American Dream Realty LLC"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "9450.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "3192"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1985"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(21) "Above Average,Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(18) "Three+,Split Level"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(15) "Garden,Mountain"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(7) "Kahaluu"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(4) "King"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(6) "Castle"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "ADRL"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(19) "gregstudt@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 258-2436"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(15) "Gregory D Studt"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19285955"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-03-03T16:46:27.703"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2026-02-23"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(7) "Kaneohe"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(18) "Other,Stream/Canal"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "16:46:27.703"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27313231"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "27313231"
    [1]=>
    string(8) "27313232"
    [2]=>
    string(8) "27313233"
    [3]=>
    string(8) "27313234"
    [4]=>
    string(8) "27313235"
    [5]=>
    string(8) "27313236"
    [6]=>
    string(8) "27313237"
    [7]=>
    string(8) "27313238"
    [8]=>
    string(8) "27313239"
    [9]=>
    string(8) "27313240"
    [10]=>
    string(8) "27313241"
    [11]=>
    string(8) "27313242"
    [12]=>
    string(8) "27313243"
    [13]=>
    string(8) "27313244"
    [14]=>
    string(8) "27313245"
    [15]=>
    string(8) "27313246"
    [16]=>
    string(8) "27313247"
    [17]=>
    string(8) "27313248"
    [18]=>
    string(8) "27313249"
    [19]=>
    string(8) "27313250"
    [20]=>
    string(8) "27313251"
    [21]=>
    string(8) "27313252"
    [22]=>
    string(8) "27313253"
    [23]=>
    string(8) "27313254"
    [24]=>
    string(8) "27313255"
    [25]=>
    string(8) "27313256"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202604193
        )

    [StreetNumber] => Array
        (
            [0] => 47-523
        )

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

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

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

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

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

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

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

    [VirtualTourURLUnbranded] => Array
        (
            [0] => https://my.matterport.com/show/?m=R4a3YVftkjE
        )

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

    [Neighbourhood] => Array
        (
            [0] => AHUIMANU AREA
        )

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

    [PublicRemarks] => Array
        (
            [0] => Located on a quiet street in Ahuimanu, this 4 bed / 3 bath, 2390 sf house, has a very open floor plan complemented by huge picturesque windows with awesome panoramic Koolau views and plenty of natural light. There is 448-sf lanai directly off the living/dining room that is perfect for indoor/outdoor living, and fantastic for entertaining. The 9,450-sf lot is very private, nicely landscaped, terraced, and perched above Kahalu’u Stream which flows right behind your back yard. The versatile floor plan is ideal for a big family. There are 2 beds/2 baths upstairs with a full kitchen and 2 beds/1 bath, wet bar, and a 336sf screen in porch downstairs. There is an interior staircase between all 3 levels but also a separate entrance for downstairs so it very easily could be used for one big family, multigenerational living, or rental income. Additional features include a Monier tile roof, solar water heater, ceramic tile, hardwood floor, enclosed garage, and a driveway big enough for 2+ cars. Priced below assessed value for a quick sale, it’s in good shape, has solid bones, and with a little bit of updating this house could easily shine again. Come to the first open house on 3-1-26, 2-5pm.
        )

    [ListOfficeName] => Array
        (
            [0] => American Dream Realty LLC
        )

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

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

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

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

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

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

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

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

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

    [StoriesType] => Array
        (
            [0] => Three+,Split Level
        )

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

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

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

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

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

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

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

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

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 258-2436
        )

    [ListAgentFullName] => Array
        (
            [0] => Gregory D Studt
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-03-03T16:46:27.703
        )

    [ListingContractDate] => Array
        (
            [0] => 2026-02-23
        )

    [MLSAreaMajor] => Array
        (
            [0] => Kaneohe
        )

    [PropertyFrontage] => Array
        (
            [0] => Other,Stream/Canal
        )

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

    [MatrixModifiedTime] => Array
        (
            [0] => 16:46:27.703
        )

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

    [listing_image] => Array
        (
            [0] => 27313231
            [1] => 27313232
            [2] => 27313233
            [3] => 27313234
            [4] => 27313235
            [5] => 27313236
            [6] => 27313237
            [7] => 27313238
            [8] => 27313239
            [9] => 27313240
            [10] => 27313241
            [11] => 27313242
            [12] => 27313243
            [13] => 27313244
            [14] => 27313245
            [15] => 27313246
            [16] => 27313247
            [17] => 27313248
            [18] => 27313249
            [19] => 27313250
            [20] => 27313251
            [21] => 27313252
            [22] => 27313253
            [23] => 27313254
            [24] => 27313255
            [25] => 27313256
        )

)

PROPERTY INFO

• BedsTotal: 4
• Full Baths: 3
• Land Area (sf): 9,450 sf
• Living (sf): 3,192
• Year Built: 1985

KEY FEATURES

• Property Condition: Above Average,Average
• Number of Parking Spaces: 3
• View: Garden,Mountain
• Listing Office: American Dream Realty LLC

FINANCIAL INFO

• Land Tenure: FS - Fee Simple

SCHOOLS

• Elementary School: Kahaluu
• Middle School: King
• High School: Castle

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 3, 2026 - 4:46 PM 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.