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!
Listing Overview
Price: $1,298,000
Area: MCCULLY
Status: Active
RARE OPPORTUNITY! Don't miss this A-2 zoned, beautifully maintained 5 bdrms + DEN/2 bath single-family home conveniently located in the heart of McCully. Features include fresh exterior paint, solar water heater, and ample parking. The upper level offers 3 bdrms/1 bath with a separate entry; and the lower-level features 2 bdrms + DEN/1 bath with a spacious open living area. Just minutes from shopping, restaurants, and entertainment. Hurry this won’t last! Listing by: BHGRE Advantage Realty (808) 738-3633
array(43) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202428483"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(3) "737"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(6) "Hauoli"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["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) "96826"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(61) "https://www.youtube.com/embed/vktCZATg0uE?si=9ZQMtLCMfaiZffjK"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1298000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "MCCULLY"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(465) "RARE OPPORTUNITY! Don't miss this A-2 zoned, beautifully maintained 5 bdrms + DEN/2 bath single-family home conveniently located in the heart of McCully. Features include fresh exterior paint, solar water heater, and ample parking. The upper level offers 3 bdrms/1 bath with a separate entry; and the lower-level features 2 bdrms + DEN/1 bath with a spacious open living area. Just minutes from shopping, restaurants, and entertainment. Hurry this won’t last!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "BHGRE Advantage Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "5"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "3648.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1784"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1944"
}
["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(13) "City,Mountain"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(8) "Lunalilo"
}
["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) "MyronK@BetterHawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 738-3633"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(13) "Myron N Kiriu"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-12-19T09:25:33.060"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18444068"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2024-12-19"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(5) "Metro"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26811706"
}
["listing_image"]=>
array(20) {
[0]=>
string(8) "26811706"
[1]=>
string(8) "26811707"
[2]=>
string(8) "26811708"
[3]=>
string(8) "26811709"
[4]=>
string(8) "26811710"
[5]=>
string(8) "26811711"
[6]=>
string(8) "26811712"
[7]=>
string(8) "26811713"
[8]=>
string(8) "26811714"
[9]=>
string(8) "26811715"
[10]=>
string(8) "26811716"
[11]=>
string(8) "26811717"
[12]=>
string(8) "26811718"
[13]=>
string(8) "26811719"
[14]=>
string(8) "26811720"
[15]=>
string(8) "26811721"
[16]=>
string(8) "26811722"
[17]=>
string(8) "26811723"
[18]=>
string(8) "26811724"
[19]=>
string(8) "26811725"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202428483
)
[StreetNumber] => Array
(
[0] => 737
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Hauoli
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96826
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://www.youtube.com/embed/vktCZATg0uE?si=9ZQMtLCMfaiZffjK
)
[ListPrice] => Array
(
[0] => 1298000.00
)
[Neighbourhood] => Array
(
[0] => MCCULLY
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => RARE OPPORTUNITY! Don't miss this A-2 zoned, beautifully maintained 5 bdrms + DEN/2 bath single-family home conveniently located in the heart of McCully. Features include fresh exterior paint, solar water heater, and ample parking. The upper level offers 3 bdrms/1 bath with a separate entry; and the lower-level features 2 bdrms + DEN/1 bath with a spacious open living area. Just minutes from shopping, restaurants, and entertainment. Hurry this won’t last!
)
[ListOfficeName] => Array
(
[0] => BHGRE Advantage Realty
)
[BedsTotal] => Array
(
[0] => 5
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 3648.00
)
[SqftTotal] => Array
(
[0] => 1784
)
[YearBuilt] => Array
(
[0] => 1944
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 6
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => City,Mountain
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Lunalilo
)
[MiddleOrJuniorSchool] => Array
(
[0] => Washington
)
[HighSchool] => Array
(
[0] => Kaimuki
)
[ListOfficeMLSID] => Array
(
[0] => ADVG
)
[ListAgentEmail] => Array
(
[0] => MyronK@BetterHawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 738-3633
)
[ListAgentFullName] => Array
(
[0] => Myron N Kiriu
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-12-19T09:25:33.060
)
[Matrix_Unique_ID] => Array
(
[0] => 18444068
)
[ListingContractDate] => Array
(
[0] => 2024-12-19
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] =>
)
[_thumbnail_id] => Array
(
[0] => 26811706
)
[listing_image] => Array
(
[0] => 26811706
[1] => 26811707
[2] => 26811708
[3] => 26811709
[4] => 26811710
[5] => 26811711
[6] => 26811712
[7] => 26811713
[8] => 26811714
[9] => 26811715
[10] => 26811716
[11] => 26811717
[12] => 26811718
[13] => 26811719
[14] => 26811720
[15] => 26811721
[16] => 26811722
[17] => 26811723
[18] => 26811724
[19] => 26811725
)
)
BedsTotal: 5
Full Baths: 2
Land Area (sf): 3,648 sf
Living (sf): 1,784
Year Built: 1944
Property Condition: Above Average
Number of Parking Spaces: 6
View: City,Mountain
Listing Office: BHGRE Advantage Realty
Land Tenure: FS - Fee Simple
Elementary School: Lunalilo
Middle School: Washington
High School: Kaimuki