Previous Next

2847 Waialae Avenue Unit 407 Honolulu, HI 96826

Listing
Overview

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

array(46) {
  ["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]=>
    NULL
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(8) "MOILIILI"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(669) "Owners are out of town and vacant easy to show so dont be shy! 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-11-17T17:00:01.000"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18249879"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(5) "Metro"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["_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"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2024-09-05"
  }
}
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] => 
        )

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

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

    [PublicRemarks] => Array
        (
            [0] => Owners are out of town and vacant easy to show so dont be shy! 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-11-17T17:00:01.000
        )

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

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

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

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

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

    [_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
        )

    [ListingContractDate] => Array
        (
            [0] => 2024-09-05
        )

)

PROPERTY INFO

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

KEY FEATURES

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

FINANCIAL INFO

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

SCHOOLS

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

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 November 17, 2024 - 5:00 PM Information is deemed reliable but not guaranteed. Copyright: 2025 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.