3772 Waialae Avenue Honolulu, HI 96816
Listing
Overview
Price: $1,000,000
Area: WILHELMINA
Status: Active Under Contract
Discover the incredible potential of this spacious 4-bedroom, 2.5-bath single-family home in desirable Waialae! This property is conveniently located near Kahala Mall, Foodland, the scenic Diamond Head State Park and the University of Chaminade. With its versatile layout and prime location, this home is ready for your personal touch to transform it into a perfect oasis. Situated in a welcoming neighborhood, this property offers a blend of comfort and practicality, making it an ideal choice for those looking to add a personal touch. Don’t miss the opportunity to make this charming home your own. Reserve your showing today! Listing by: Stott Real Estate, Inc. (808) 286-3394
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202418460"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(4) "3772"
}
["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) "1000000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1000000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(10) "WILHELMINA"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(631) "Discover the incredible potential of this spacious 4-bedroom, 2.5-bath single-family home in desirable Waialae! This property is conveniently located near Kahala Mall, Foodland, the scenic Diamond Head State Park and the University of Chaminade. With its versatile layout and prime location, this home is ready for your personal touch to transform it into a perfect oasis. Situated in a welcoming neighborhood, this property offers a blend of comfort and practicality, making it an ideal choice for those looking to add a personal touch. Don’t miss the opportunity to make this charming home your own. Reserve your showing today!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(23) "Stott Real Estate, Inc."
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "1"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "5349.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1300"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1940"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(4) "Fair"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(4) "None"
}
["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) "SOLD"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(27) "traceystottkelley@stott.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 286-3394"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(24) "Tracey Anne Stott Kelley"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-09-13T11:04:22.600"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18207272"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-08-27T12:10:22.953"
}
["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) "26673343"
}
["listing_image"]=>
array(18) {
[0]=>
string(8) "26673343"
[1]=>
string(8) "26673344"
[2]=>
string(8) "26673345"
[3]=>
string(8) "26673346"
[4]=>
string(8) "26673347"
[5]=>
string(8) "26673348"
[6]=>
string(8) "26673349"
[7]=>
string(8) "26673350"
[8]=>
string(8) "26673351"
[9]=>
string(8) "26673352"
[10]=>
string(8) "26673353"
[11]=>
string(8) "26673354"
[12]=>
string(8) "26673355"
[13]=>
string(8) "26673356"
[14]=>
string(8) "26673357"
[15]=>
string(8) "26673358"
[16]=>
string(8) "26673359"
[17]=>
string(8) "26673360"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202418460
)
[StreetNumber] => Array
(
[0] => 3772
)
[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] => 1000000.00
)
[CurrentPrice] => Array
(
[0] => 1000000.00
)
[Neighbourhood] => Array
(
[0] => WILHELMINA
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => Discover the incredible potential of this spacious 4-bedroom, 2.5-bath single-family home in desirable Waialae! This property is conveniently located near Kahala Mall, Foodland, the scenic Diamond Head State Park and the University of Chaminade. With its versatile layout and prime location, this home is ready for your personal touch to transform it into a perfect oasis. Situated in a welcoming neighborhood, this property offers a blend of comfort and practicality, making it an ideal choice for those looking to add a personal touch. Don’t miss the opportunity to make this charming home your own. Reserve your showing today!
)
[ListOfficeName] => Array
(
[0] => Stott Real Estate, Inc.
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 5349.00
)
[SqftTotal] => Array
(
[0] => 1300
)
[YearBuilt] => Array
(
[0] => 1940
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Fair
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => None
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Waialae
)
[MiddleOrJuniorSchool] => Array
(
[0] => Kaimuki
)
[HighSchool] => Array
(
[0] => Kalani
)
[ListOfficeMLSID] => Array
(
[0] => SOLD
)
[ListAgentEmail] => Array
(
[0] => traceystottkelley@stott.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 286-3394
)
[ListAgentFullName] => Array
(
[0] => Tracey Anne Stott Kelley
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-09-13T11:04:22.600
)
[Matrix_Unique_ID] => Array
(
[0] => 18207272
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-08-27T12:10:22.953
)
[MLSAreaMajor] => Array
(
[0] => DiamondHd
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26673343
)
[listing_image] => Array
(
[0] => 26673343
[1] => 26673344
[2] => 26673345
[3] => 26673346
[4] => 26673347
[5] => 26673348
[6] => 26673349
[7] => 26673350
[8] => 26673351
[9] => 26673352
[10] => 26673353
[11] => 26673354
[12] => 26673355
[13] => 26673356
[14] => 26673357
[15] => 26673358
[16] => 26673359
[17] => 26673360
)
)
- BedsTotal: 4
- Full Baths: 2
- Half Baths: 1
- Land Area (sf): 5,349
- Living (sf): 1,300
- Year Built: 1940
- Property Condition: Fair
- Number of Parking Spaces: 2
- View: None
- Listing Office: Stott Real Estate, Inc.
- Land Tenure: FS - Fee Simple
- Elementary School: Waialae
- Middle School: Kaimuki
- High School: Kalani