94-470 Paiwa Street Unit 14 Waipahu, HI 96797

Listing
Overview

Price: $815,000
Area: WAIPAHU ESTATES
Status: Active

Recent PRICE DROP & VA eligible assumable financing! This is your opportunity to make this house your own. Welcome to this beautiful 4 bedroom, 2.5 bathroom home located in the charming community of Waipahu. With a lot parking options and a vinyl fence for added privacy, this home also features a spacious yard perfect for outdoor BBQs and entertaining guests. Conveniently situated near the popular Waikele Shopping outlets, you'll have easy access to all the amenities you could ever need. Don't miss out on the chance to call this stunning Waipahu property your new home sweet home! Listing by: Coldwell Banker Realty (808) 676-7200

array(48) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202415329"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "94-470"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(5) "Paiwa"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(2) "14"
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96797"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(9) "815000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(15) "WAIPAHU ESTATES"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(587) "Recent PRICE DROP & VA eligible assumable financing! This is your opportunity to make this house your own. Welcome to this beautiful 4 bedroom, 2.5 bathroom home located in the charming community of Waipahu. With a lot parking options and a vinyl fence for added privacy, this home also features a spacious yard perfect for outdoor BBQs and entertaining guests.  Conveniently situated near the popular Waikele Shopping outlets, you'll have easy access to all the amenities you could ever need. Don't miss out on the chance to call this stunning Waipahu property your new home sweet home!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(22) "Coldwell Banker Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "4492.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "1712"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "2018"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(12) "Puuwai Place"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "Two"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "539.35"
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(13) "August Ahrens"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(6) "CBPP15"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(20) "mikikot@cbrealty.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 676-7200"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(15) "Mikiko Terahira"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-01-25T16:33:10.700"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18106879"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26635039"
  }
  ["listing_image"]=>
  array(14) {
    [0]=>
    string(8) "26635039"
    [1]=>
    string(8) "26635040"
    [2]=>
    string(8) "26635041"
    [3]=>
    string(8) "26635042"
    [4]=>
    string(8) "26635043"
    [5]=>
    string(8) "26635044"
    [6]=>
    string(8) "26635045"
    [7]=>
    string(8) "26635046"
    [8]=>
    string(8) "26635047"
    [9]=>
    string(8) "26635048"
    [10]=>
    string(8) "26635049"
    [11]=>
    string(8) "26635050"
    [12]=>
    string(8) "26635051"
    [13]=>
    string(8) "26635052"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2024-07-24"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "16:33:10.700"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202415329
        )

    [StreetNumber] => Array
        (
            [0] => 94-470
        )

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

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

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

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

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

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

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

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

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

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

    [Neighbourhood] => Array
        (
            [0] => WAIPAHU ESTATES
        )

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

    [PublicRemarks] => Array
        (
            [0] => Recent PRICE DROP & VA eligible assumable financing! This is your opportunity to make this house your own. Welcome to this beautiful 4 bedroom, 2.5 bathroom home located in the charming community of Waipahu. With a lot parking options and a vinyl fence for added privacy, this home also features a spacious yard perfect for outdoor BBQs and entertaining guests.  Conveniently situated near the popular Waikele Shopping outlets, you'll have easy access to all the amenities you could ever need. Don't miss out on the chance to call this stunning Waipahu property your new home sweet home!
        )

    [ListOfficeName] => Array
        (
            [0] => Coldwell Banker Realty
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => mikikot@cbrealty.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 676-7200
        )

    [ListAgentFullName] => Array
        (
            [0] => Mikiko Terahira
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-01-25T16:33:10.700
        )

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

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

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

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

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

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

    [listing_image] => Array
        (
            [0] => 26635039
            [1] => 26635040
            [2] => 26635041
            [3] => 26635042
            [4] => 26635043
            [5] => 26635044
            [6] => 26635045
            [7] => 26635046
            [8] => 26635047
            [9] => 26635048
            [10] => 26635049
            [11] => 26635050
            [12] => 26635051
            [13] => 26635052
        )

    [ListingContractDate] => Array
        (
            [0] => 2024-07-24
        )

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

    [MatrixModifiedTime] => Array
        (
            [0] => 16:33:10.700
        )

)

  • BedsTotal: 4
  • Full Baths: 2
  • Half Baths: 1
  • Land Area (sf): 4,492 sf
  • Living (sf): 1,712
  • Year Built: 2018
  • Building Name: Puuwai Place

  • Property Condition: Above Average
  • Number of Parking Spaces: 4
  • View: None
  • Listing Office: Coldwell Banker Realty

  • Maintenance Fees: $539
  • Land Tenure: FS - Fee Simple

  • Elementary School: August Ahrens
  • Middle School: Waipahu
  • High School: Waipahu

CONTACT US

Marcus Realty

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