84-551 Upena Street Waianae, HI 96792

Take a Virtual Tour

Listing
Overview

Price: $2,500,000
Area: MAKAHA
Status: Active

This stunning oceanfront property located close to Makaha beach was built in 2005. This home features an open living and kitchen area that offers breathtaking panoramic views of the ocean. Features include a large, beautifully landscaped yard perfect for outdoor activities, covered patio, split unit a/c, security alarm system, fully gated, 3-car enclosed garage with tons of storage and a large paved driveway allowing for additioanal parking if needed. This oceanfront property offers a rare opportunity to live on the ocean in one of the most beautiful locations on the West side of Oahu, or make it your ideal weekend getaway beach house! Listing by: Property Profiles, Inc.

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202309055"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "84-551"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(5) "Upena"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(7) "Waianae"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96792"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(61) "https://www.youtube.com/embed/_fjacPZPYfg?si=4j9-yp4ie1rDBf-B"
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "2500000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "2500000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(6) "MAKAHA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(646) "This stunning oceanfront property located close to Makaha beach was built in 2005.  This home features an open living and kitchen area that offers breathtaking panoramic views of the ocean. Features include a large, beautifully landscaped yard perfect for outdoor activities, covered patio, split unit a/c, security alarm system, fully gated,  3-car enclosed garage with tons of storage and a large paved driveway allowing for additioanal parking if needed.  This oceanfront property offers a rare opportunity to live on the ocean in one of the most beautiful locations on the West side of Oahu, or make it your ideal weekend getaway beach house!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(23) "Property Profiles, Inc."
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(8) "10165.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "3226"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "2005"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "Two"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(39) "Coastline,Mountain,Ocean,Sunrise,Sunset"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(6) "Makaha"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(7) "Waianae"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(7) "Waianae"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "PPIN"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(17) "brandi@pro808.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(16) "Brandi KW Oshiro"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2023-08-07T12:11:32.497"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "17271924"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2023-04-24T14:07:21.183"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "25844177"
  }
  ["listing_image"]=>
  array(25) {
    [0]=>
    string(8) "25844177"
    [1]=>
    string(8) "25844178"
    [2]=>
    string(8) "25844179"
    [3]=>
    string(8) "25844180"
    [4]=>
    string(8) "25844181"
    [5]=>
    string(8) "25844182"
    [6]=>
    string(8) "25844183"
    [7]=>
    string(8) "25844184"
    [8]=>
    string(8) "25844185"
    [9]=>
    string(8) "25844186"
    [10]=>
    string(8) "25844187"
    [11]=>
    string(8) "25844188"
    [12]=>
    string(8) "25844189"
    [13]=>
    string(8) "25844190"
    [14]=>
    string(8) "25844191"
    [15]=>
    string(8) "25844192"
    [16]=>
    string(8) "25844193"
    [17]=>
    string(8) "25844194"
    [18]=>
    string(8) "25844195"
    [19]=>
    string(8) "25844196"
    [20]=>
    string(8) "25844197"
    [21]=>
    string(8) "25844198"
    [22]=>
    string(8) "25874504"
    [23]=>
    string(8) "25874505"
    [24]=>
    string(8) "25874506"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(7) "Leeward"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(28) "Ocean,Sandy Beach,Waterfront"
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202309055
        )

    [StreetNumber] => Array
        (
            [0] => 84-551
        )

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

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

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

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

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

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

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

    [VirtualTourURLUnbranded] => Array
        (
            [0] => https://www.youtube.com/embed/_fjacPZPYfg?si=4j9-yp4ie1rDBf-B
        )

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => This stunning oceanfront property located close to Makaha beach was built in 2005.  This home features an open living and kitchen area that offers breathtaking panoramic views of the ocean. Features include a large, beautifully landscaped yard perfect for outdoor activities, covered patio, split unit a/c, security alarm system, fully gated,  3-car enclosed garage with tons of storage and a large paved driveway allowing for additioanal parking if needed.  This oceanfront property offers a rare opportunity to live on the ocean in one of the most beautiful locations on the West side of Oahu, or make it your ideal weekend getaway beach house!
        )

    [ListOfficeName] => Array
        (
            [0] => Property Profiles, Inc.
        )

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

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

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

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

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

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

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

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

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

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

    [View] => Array
        (
            [0] => Coastline,Mountain,Ocean,Sunrise,Sunset
        )

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => brandi@pro808.com
        )

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

    [ListAgentFullName] => Array
        (
            [0] => Brandi KW Oshiro
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2023-08-07T12:11:32.497
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2023-04-24T14:07:21.183
        )

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

    [listing_image] => Array
        (
            [0] => 25844177
            [1] => 25844178
            [2] => 25844179
            [3] => 25844180
            [4] => 25844181
            [5] => 25844182
            [6] => 25844183
            [7] => 25844184
            [8] => 25844185
            [9] => 25844186
            [10] => 25844187
            [11] => 25844188
            [12] => 25844189
            [13] => 25844190
            [14] => 25844191
            [15] => 25844192
            [16] => 25844193
            [17] => 25844194
            [18] => 25844195
            [19] => 25844196
            [20] => 25844197
            [21] => 25844198
            [22] => 25874504
            [23] => 25874505
            [24] => 25874506
        )

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

    [PropertyFrontage] => Array
        (
            [0] => Ocean,Sandy Beach,Waterfront
        )

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

)

  • BedsTotal: 3
  • Full Baths: 3
  • Half Baths: 1
  • Land Area (sf): 10,165
  • Living (sf): 3,226
  • Year Built: 2005

  • Property Condition: Above Average
  • Number of Parking Spaces: 3
  • View: Coastline,Mountain,Ocean,Sunrise,Sunset
  • Listing Office: Property Profiles, Inc.

  • Land Tenure: FS - Fee Simple

  • Elementary School: Makaha
  • Middle School: Waianae
  • High School: Waianae

CONTACT US

Marcus Realty

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