Our office will be closed on November 28 and 29, 2024, for Thanksgiving and the Day After Thanksgiving.
3923 Waialae Avenue Honolulu, HI 96816
Listing Overview
Price: $1,565,000 Area: KAIMUKI Status: Active
Discover an exceptional opportunity in the coveted Kaimuki/Kahala/Diamond Head area, ideal for a 1031 exchange. This property includes 2 duplexes, 1 triplex, and a standalone studio, all built in 2003. The layout features 4 rental units, with two bedrooms downstairs and one bedroom plus a studio upstairs, currently occupied by the owner, offering flexible living arrangements. Ample parking includes a two-car garage, 1 carport, and 3 open spaces, ensuring convenience for residents and visitors. Live in one unit while generating rental income from the others, perfect for an owner/occupant eager to capitalize on this prime location and investment opportunity.Please note that the property is tenant-occupied, requiring 48 hours' notice for showings, with serious buyers only. The bedroom count may not match tax records, so buyers should perform due diligence to fully understand the property's offerings and potential. This is a rare chance to invest in a property that combines location, flexibility, and income potential in one of the most desirable areas. Don't miss this opportunity to secure a valuable asset in a thriving community. Listing by: Compass (808) 445-0538
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202423778"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(4) "3923"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(7) "Waialae"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Avenue"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["City"]=>
array(1) {
[0]=>
string(8) "Honolulu"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96816"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1565000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1565000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "KAIMUKI"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1144) "Discover an exceptional opportunity in the coveted Kaimuki/Kahala/Diamond Head area, ideal for a 1031 exchange. This property includes 2 duplexes, 1 triplex, and a standalone studio, all built in 2003. The layout features 4 rental units, with two bedrooms downstairs and one bedroom plus a studio upstairs, currently occupied by the owner, offering flexible living arrangements. Ample parking includes a two-car garage, 1 carport, and 3 open spaces, ensuring convenience for residents and visitors. Live in one unit while generating rental income from the others, perfect for an owner/occupant eager to capitalize on this prime location and investment opportunity.Please note that the property is tenant-occupied, requiring 48 hours' notice for showings, with serious buyers only. The bedroom count may not match tax records, so buyers should perform due diligence to fully understand the property's offerings and potential. This is a rare chance to invest in a property that combines location, flexibility, and income potential in one of the most desirable areas. Don't miss this opportunity to secure a valuable asset in a thriving community."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(7) "Compass"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "6"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "5"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "6634.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "3634"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "2003"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "6"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(14) "Mountain,Ocean"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(7) "Waialae"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(7) "Kaimuki"
}
["HighSchool"]=>
array(1) {
[0]=>
string(6) "Kalani"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "COHI"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(27) "marisa.norfleet@compass.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 445-0538"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(17) "Marisa F Norfleet"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-10-22T11:31:57.823"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18320460"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-10-15T11:38:30.860"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(9) "DiamondHd"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26731649"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26731649"
[1]=>
string(8) "26731650"
[2]=>
string(8) "26731651"
[3]=>
string(8) "26731652"
[4]=>
string(8) "26731653"
[5]=>
string(8) "26731654"
[6]=>
string(8) "26731655"
[7]=>
string(8) "26731656"
[8]=>
string(8) "26731657"
[9]=>
string(8) "26731658"
[10]=>
string(8) "26731659"
[11]=>
string(8) "26731660"
[12]=>
string(8) "26731661"
[13]=>
string(8) "26731662"
[14]=>
string(8) "26731663"
[15]=>
string(8) "26731664"
[16]=>
string(8) "26731665"
[17]=>
string(8) "26731666"
[18]=>
string(8) "26731667"
[19]=>
string(8) "26731668"
[20]=>
string(8) "26731669"
[21]=>
string(8) "26731670"
[22]=>
string(8) "26731671"
[23]=>
string(8) "26731672"
[24]=>
string(8) "26731673"
[25]=>
string(8) "26731674"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202423778
)
[StreetNumber] => Array
(
[0] => 3923
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Waialae
)
[StreetSuffix] => Array
(
[0] => Avenue
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96816
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 1565000.00
)
[CurrentPrice] => Array
(
[0] => 1565000.00
)
[Neighbourhood] => Array
(
[0] => KAIMUKI
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Discover an exceptional opportunity in the coveted Kaimuki/Kahala/Diamond Head area, ideal for a 1031 exchange. This property includes 2 duplexes, 1 triplex, and a standalone studio, all built in 2003. The layout features 4 rental units, with two bedrooms downstairs and one bedroom plus a studio upstairs, currently occupied by the owner, offering flexible living arrangements. Ample parking includes a two-car garage, 1 carport, and 3 open spaces, ensuring convenience for residents and visitors. Live in one unit while generating rental income from the others, perfect for an owner/occupant eager to capitalize on this prime location and investment opportunity.Please note that the property is tenant-occupied, requiring 48 hours' notice for showings, with serious buyers only. The bedroom count may not match tax records, so buyers should perform due diligence to fully understand the property's offerings and potential. This is a rare chance to invest in a property that combines location, flexibility, and income potential in one of the most desirable areas. Don't miss this opportunity to secure a valuable asset in a thriving community.
)
[ListOfficeName] => Array
(
[0] => Compass
)
[BedsTotal] => Array
(
[0] => 6
)
[BathsFull] => Array
(
[0] => 5
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 6634.00
)
[SqftTotal] => Array
(
[0] => 3634
)
[YearBuilt] => Array
(
[0] => 2003
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 6
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Mountain,Ocean
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Waialae
)
[MiddleOrJuniorSchool] => Array
(
[0] => Kaimuki
)
[HighSchool] => Array
(
[0] => Kalani
)
[ListOfficeMLSID] => Array
(
[0] => COHI
)
[ListAgentEmail] => Array
(
[0] => marisa.norfleet@compass.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 445-0538
)
[ListAgentFullName] => Array
(
[0] => Marisa F Norfleet
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-10-22T11:31:57.823
)
[Matrix_Unique_ID] => Array
(
[0] => 18320460
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-10-15T11:38:30.860
)
[MLSAreaMajor] => Array
(
[0] => DiamondHd
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26731649
)
[listing_image] => Array
(
[0] => 26731649
[1] => 26731650
[2] => 26731651
[3] => 26731652
[4] => 26731653
[5] => 26731654
[6] => 26731655
[7] => 26731656
[8] => 26731657
[9] => 26731658
[10] => 26731659
[11] => 26731660
[12] => 26731661
[13] => 26731662
[14] => 26731663
[15] => 26731664
[16] => 26731665
[17] => 26731666
[18] => 26731667
[19] => 26731668
[20] => 26731669
[21] => 26731670
[22] => 26731671
[23] => 26731672
[24] => 26731673
[25] => 26731674
)
)