Previous Next

2847 Waialae Avenue Unit 210 Honolulu, HI 96826

Take a Virtual Tour

Listing
Overview

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

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202515808"
  }
  ["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) "210"
  }
  ["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(59) "https://listings.hetproductions.com/sites/engvgzr/unbranded"
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(9) "305000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(8) "MOILIILI"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(786) "Perfect for first-time buyers, this charming 2-bedroom, 1-bathroom end unit offers 607 sqft of inviting living area.  Conveniently located on the ground floor, you’ll never have to wait for an elevator again! The open-concept layout provides a seamless flow, making it ideal for both relaxation and entertaining.  Enjoy the convenience of a storage locker, 6 guest stalls, community laundry and an on-site pool for a refreshing escape.  Located just minutes from the University of Hawaii, Manoa, Market City Shopping Center, and with easy access to freeway entrances and exits, this prime location offers everything you need within reach.  Move-in ready and offering great value, this home is an opportunity you won’t want to miss! A few photos have been virtually staged(enhanced)."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(22) "BHGRE Advantage Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "620"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1975"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(10) "Waialae Pl"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(23) "Excellent,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) "784.54"
  }
  ["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) "ADVG"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(23) "GlennI@BetterHawaii.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 738-3600"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(13) "Glenn A Ikeda"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18857408"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-07-16T11:30:01.210"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-07-11"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(5) "Metro"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "11:30:01.210"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27065150"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "27065150"
    [1]=>
    string(8) "27065151"
    [2]=>
    string(8) "27065152"
    [3]=>
    string(8) "27065153"
    [4]=>
    string(8) "27065154"
    [5]=>
    string(8) "27065155"
    [6]=>
    string(8) "27065156"
    [7]=>
    string(8) "27065157"
    [8]=>
    string(8) "27065158"
    [9]=>
    string(8) "27065159"
    [10]=>
    string(8) "27065160"
    [11]=>
    string(8) "27065161"
    [12]=>
    string(8) "27065162"
    [13]=>
    string(8) "27065163"
    [14]=>
    string(8) "27065164"
    [15]=>
    string(8) "27065165"
    [16]=>
    string(8) "27065166"
    [17]=>
    string(8) "27065167"
    [18]=>
    string(8) "27065168"
    [19]=>
    string(8) "27065169"
    [20]=>
    string(8) "27065170"
    [21]=>
    string(8) "27065171"
    [22]=>
    string(8) "27065172"
    [23]=>
    string(8) "27065173"
    [24]=>
    string(8) "27065174"
    [25]=>
    string(8) "27065175"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202515808
        )

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

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

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

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

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

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

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

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

    [VirtualTourURLUnbranded] => Array
        (
            [0] => https://listings.hetproductions.com/sites/engvgzr/unbranded
        )

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Perfect for first-time buyers, this charming 2-bedroom, 1-bathroom end unit offers 607 sqft of inviting living area.  Conveniently located on the ground floor, you’ll never have to wait for an elevator again! The open-concept layout provides a seamless flow, making it ideal for both relaxation and entertaining.  Enjoy the convenience of a storage locker, 6 guest stalls, community laundry and an on-site pool for a refreshing escape.  Located just minutes from the University of Hawaii, Manoa, Market City Shopping Center, and with easy access to freeway entrances and exits, this prime location offers everything you need within reach.  Move-in ready and offering great value, this home is an opportunity you won’t want to miss! A few photos have been virtually staged(enhanced).
        )

    [ListOfficeName] => Array
        (
            [0] => BHGRE Advantage Realty
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => GlennI@BetterHawaii.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 738-3600
        )

    [ListAgentFullName] => Array
        (
            [0] => Glenn A Ikeda
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-07-16T11:30:01.210
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-07-11
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 11:30:01.210
        )

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

    [listing_image] => Array
        (
            [0] => 27065150
            [1] => 27065151
            [2] => 27065152
            [3] => 27065153
            [4] => 27065154
            [5] => 27065155
            [6] => 27065156
            [7] => 27065157
            [8] => 27065158
            [9] => 27065159
            [10] => 27065160
            [11] => 27065161
            [12] => 27065162
            [13] => 27065163
            [14] => 27065164
            [15] => 27065165
            [16] => 27065166
            [17] => 27065167
            [18] => 27065168
            [19] => 27065169
            [20] => 27065170
            [21] => 27065171
            [22] => 27065172
            [23] => 27065173
            [24] => 27065174
            [25] => 27065175
        )

)

PROPERTY INFO

• BedsTotal: 2
• Full Baths: 1
• Living (sf): 620
• Year Built: 1975
• Building Name: Waialae Pl

KEY FEATURES

• Property Condition: Excellent,Above Average
• Number of Parking Spaces: 1
• View: None
• Listing Office: BHGRE Advantage Realty

FINANCIAL INFO

• Maintenance Fees: $785
• 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 July 16, 2025 - 11:30 AM 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.