2847 Waialae Avenue Unit 407 Honolulu, HI 96826

Listing
Overview

Price: $275,000
Area: MOILIILI
Status: Active

**Sunday Open House 2PM-5PM ** Convenient Location with the Best of Both Worlds! Situated in an ideal spot close to UH Manoa, this home offers easy access to the vibrant nightlife and attractions of Waikiki, while still providing a peaceful retreat next to the serene outdoor pool. You'll enjoy the perfect balance of city living and tranquility, with the convenience of being near major H-1 freeway entrances and exits, making commuting a breeze. Whether you're a first-time homebuyer looking for a comfortable, convenient residence or an investor seeking a great rental opportunity, this property offers unbeatable potential and value. Listing by: eXp Realty (808) 498-5560

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202420627"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(4) "2847"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(15) "Condo/Townhouse"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(7) "Waialae"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Avenue"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(3) "407"
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(8) "Honolulu"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96826"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(9) "275000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(9) "275000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(8) "MOILIILI"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(637) "**Sunday Open House 2PM-5PM ** Convenient Location with the Best of Both Worlds! Situated in an ideal spot close to UH Manoa, this home offers easy access to the vibrant nightlife and attractions of Waikiki, while still providing a peaceful retreat next to the serene outdoor pool. You'll enjoy the perfect balance of city living and tranquility, with the convenience of being near major H-1 freeway entrances and exits, making commuting a breeze. Whether you're a first-time homebuyer looking for a comfortable, convenient residence or an investor seeking a great rental opportunity, this property offers unbeatable potential and value."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(10) "eXp Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(8) "55759.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "460"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1975"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(10) "Waialae Pl"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "4-7"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "904.00"
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(5) "Kuhio"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(10) "Washington"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(7) "Kaimuki"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "EXPI"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(21) "David@pineapplehi.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 498-5560"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(11) "David Hwang"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-09-15T17:00:01.380"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18249879"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-09-07T13:01:23.833"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(5) "Metro"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26691968"
  }
  ["listing_image"]=>
  array(17) {
    [0]=>
    string(8) "26691968"
    [1]=>
    string(8) "26691969"
    [2]=>
    string(8) "26691970"
    [3]=>
    string(8) "26691971"
    [4]=>
    string(8) "26691972"
    [5]=>
    string(8) "26691973"
    [6]=>
    string(8) "26691974"
    [7]=>
    string(8) "26691975"
    [8]=>
    string(8) "26691976"
    [9]=>
    string(8) "26691977"
    [10]=>
    string(8) "26691978"
    [11]=>
    string(8) "26691979"
    [12]=>
    string(8) "26691980"
    [13]=>
    string(8) "26691981"
    [14]=>
    string(8) "26691982"
    [15]=>
    string(8) "26691983"
    [16]=>
    string(8) "26691984"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202420627
        )

    [StreetNumber] => Array
        (
            [0] => 2847
        )

    [PropertyType] => Array
        (
            [0] => Condo/Townhouse
        )

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => **Sunday Open House 2PM-5PM ** Convenient Location with the Best of Both Worlds! Situated in an ideal spot close to UH Manoa, this home offers easy access to the vibrant nightlife and attractions of Waikiki, while still providing a peaceful retreat next to the serene outdoor pool. You'll enjoy the perfect balance of city living and tranquility, with the convenience of being near major H-1 freeway entrances and exits, making commuting a breeze. Whether you're a first-time homebuyer looking for a comfortable, convenient residence or an investor seeking a great rental opportunity, this property offers unbeatable potential and value.
        )

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

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

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

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

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

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

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

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

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

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

    [StoriesType] => Array
        (
            [0] => 4-7
        )

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => David@pineapplehi.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 498-5560
        )

    [ListAgentFullName] => Array
        (
            [0] => David Hwang
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-09-15T17:00:01.380
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-09-07T13:01:23.833
        )

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

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

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

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

    [listing_image] => Array
        (
            [0] => 26691968
            [1] => 26691969
            [2] => 26691970
            [3] => 26691971
            [4] => 26691972
            [5] => 26691973
            [6] => 26691974
            [7] => 26691975
            [8] => 26691976
            [9] => 26691977
            [10] => 26691978
            [11] => 26691979
            [12] => 26691980
            [13] => 26691981
            [14] => 26691982
            [15] => 26691983
            [16] => 26691984
        )

)

  • BedsTotal: 1
  • Full Baths: 1
  • Land Area (sf): 55,759
  • Living (sf): 460
  • Year Built: 1975
  • Building Name: Waialae Pl

  • Property Condition: Above Average
  • Number of Parking Spaces: 1
  • View: None
  • Listing Office: eXp Realty

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

  • Elementary School: Kuhio
  • Middle School: Washington
  • High School: Kaimuki

CONTACT US

Marcus Realty

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