98-664 Puailima Street Aiea, HI 96701

Listing
Overview

Price: $1,378,500
Area: PEARLRIDGE
Status: Active Under Contract

Wow! A Dream Come True! A Rare Opportunity! Beautiful, Custom, Upgraded, three story gem of a home on a special cul-de-sac location with relaxing HUGE decks to enjoy located off of both living areas! Spacious 4 bedrooms/3.5 baths! *Downstairs special unit has a wet bar! Large back down sloping lot has many possibilities and a couple of fruit trees, too. Listing by: Real Estate Update, Inc. (808) 593-1803

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202320547"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "98-664"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(8) "Puailima"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(4) "Aiea"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96701"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "1378500.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "1378500.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(10) "PEARLRIDGE"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(21) "Active Under Contract"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(361) "Wow!  A Dream Come True!  A Rare Opportunity!  Beautiful, Custom, Upgraded, three story gem of a home on a special cul-de-sac location with relaxing HUGE decks to enjoy located off of both living areas!  Spacious 4 bedrooms/3.5 baths!  *Downstairs special unit has a wet bar!  Large back down sloping lot has many possibilities and a couple of fruit trees, too."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(24) "Real Estate Update, Inc."
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "9609.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "3082"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "2006"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(23) "Excellent,Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(6) "Three+"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(20) "City,Mountain,Sunset"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(11) "Pearl Ridge"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(4) "Aiea"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(4) "Aiea"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "REUI"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(20) "mail@reupdateinc.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 593-1803"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(16) "Patti Ann Hokama"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-03-22T08:04:29.740"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "17547048"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2023-09-06T06:19:36.203"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(9) "PearlCity"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "25945464"
  }
  ["listing_image"]=>
  array(24) {
    [0]=>
    string(8) "25945464"
    [1]=>
    string(8) "25945465"
    [2]=>
    string(8) "25945466"
    [3]=>
    string(8) "25945467"
    [4]=>
    string(8) "25945468"
    [5]=>
    string(8) "25945469"
    [6]=>
    string(8) "25945470"
    [7]=>
    string(8) "25945471"
    [8]=>
    string(8) "25945472"
    [9]=>
    string(8) "25945473"
    [10]=>
    string(8) "25945474"
    [11]=>
    string(8) "25945475"
    [12]=>
    string(8) "25945476"
    [13]=>
    string(8) "25945477"
    [14]=>
    string(8) "25945478"
    [15]=>
    string(8) "25945479"
    [16]=>
    string(8) "25945480"
    [17]=>
    string(8) "25945481"
    [18]=>
    string(8) "25945482"
    [19]=>
    string(8) "25945483"
    [20]=>
    string(8) "25945484"
    [21]=>
    string(8) "25945485"
    [22]=>
    string(8) "25945486"
    [23]=>
    string(8) "25945487"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202320547
        )

    [StreetNumber] => Array
        (
            [0] => 98-664
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Wow!  A Dream Come True!  A Rare Opportunity!  Beautiful, Custom, Upgraded, three story gem of a home on a special cul-de-sac location with relaxing HUGE decks to enjoy located off of both living areas!  Spacious 4 bedrooms/3.5 baths!  *Downstairs special unit has a wet bar!  Large back down sloping lot has many possibilities and a couple of fruit trees, too.
        )

    [ListOfficeName] => Array
        (
            [0] => Real Estate Update, Inc.
        )

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

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

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

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

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

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

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

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

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

    [StoriesType] => Array
        (
            [0] => Three+
        )

    [View] => Array
        (
            [0] => City,Mountain,Sunset
        )

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => mail@reupdateinc.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 593-1803
        )

    [ListAgentFullName] => Array
        (
            [0] => Patti Ann Hokama
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-03-22T08:04:29.740
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2023-09-06T06:19:36.203
        )

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

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

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

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

    [listing_image] => Array
        (
            [0] => 25945464
            [1] => 25945465
            [2] => 25945466
            [3] => 25945467
            [4] => 25945468
            [5] => 25945469
            [6] => 25945470
            [7] => 25945471
            [8] => 25945472
            [9] => 25945473
            [10] => 25945474
            [11] => 25945475
            [12] => 25945476
            [13] => 25945477
            [14] => 25945478
            [15] => 25945479
            [16] => 25945480
            [17] => 25945481
            [18] => 25945482
            [19] => 25945483
            [20] => 25945484
            [21] => 25945485
            [22] => 25945486
            [23] => 25945487
        )

)

  • BedsTotal: 4
  • Full Baths: 3
  • Half Baths: 1
  • Land Area (sf): 9,609
  • Living (sf): 3,082
  • Year Built: 2006

  • Property Condition: Excellent,Above Average
  • Number of Parking Spaces: 3
  • View: City,Mountain,Sunset
  • Listing Office: Real Estate Update, Inc.

  • Land Tenure: FS - Fee Simple

  • Elementary School: Pearl Ridge
  • Middle School: Aiea
  • High School: Aiea

CONTACT US

Marcus Realty

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