Holiday Hours: Our office will close at Noon on December 24th and 31st and will be closed all day on December 25th and January 1st. Happy Holidays!
2847 Waialae Avenue Unit 407 Honolulu, HI 96826
Listing Overview
Price: $275,000 Area: MOILIILI Status: Active
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. Listing by: eXp Realty (808) 498-5560
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
)
)
