Listing
Overview
Price: $1,188,000
Area: WAIALAE NUI RDGE
Status: Active Under Contract
This single-family home offers remarkable coastal views of Diamond Head, Kahala, and the city. Situated at the base of Waialae Niu Ridge, it provides convenient access to the beach, Kahala Mall, Kaimuki, and urban Honolulu. With an open floor plan and fresh paint inside and out, the home is move-in ready. The property's standout feature is its viewing terrace, offering a perfect vantage point for breathtaking sunrises and sunsets. The stunning views add significant value to the home and create a meditative beginning and end to each day. Overall, this home combines a desirable location, well-designed interior, and unforgettable views, making it an excellent opportunity for those seeking a stylish and comfortable living space in a sought-after area. Listing by: Marcus Realty (808) 839-7446
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202312925"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(4) "1487"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(7) "Halekoa"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Drive"
}
["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) "96821"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(41) "https://www.youtube.com/embed/hXKW0Yeo9uQ"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1188000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1188000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(16) "WAIALAE NUI RDGE"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(757) "This single-family home offers remarkable coastal views of Diamond Head, Kahala, and the city. Situated at the base of Waialae Niu Ridge, it provides convenient access to the beach, Kahala Mall, Kaimuki, and urban Honolulu. With an open floor plan and fresh paint inside and out, the home is move-in ready. The property's standout feature is its viewing terrace, offering a perfect vantage point for breathtaking sunrises and sunsets. The stunning views add significant value to the home and create a meditative beginning and end to each day. Overall, this home combines a desirable location, well-designed interior, and unforgettable views, making it an excellent opportunity for those seeking a stylish and comfortable living space in a sought-after area."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(13) "Marcus Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "5795.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1136"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1963"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(55) "Coastline,Diamond Head,Golf Course,Ocean,Sunrise,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(0) ""
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["HighSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "MARC"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(24) "PamelaM@marcushawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 839-7446"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(14) "Pamela M Maeda"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2023-09-19T12:54:45.890"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17362037"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2023-06-02T11:02:46.840"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "25853410"
}
["listing_image"]=>
array(18) {
[0]=>
string(8) "25853410"
[1]=>
string(8) "25853411"
[2]=>
string(8) "25853412"
[3]=>
string(8) "25853413"
[4]=>
string(8) "25853414"
[5]=>
string(8) "25853415"
[6]=>
string(8) "25853416"
[7]=>
string(8) "25853417"
[8]=>
string(8) "25853418"
[9]=>
string(8) "25853419"
[10]=>
string(8) "25853420"
[11]=>
string(8) "25853421"
[12]=>
string(8) "25853422"
[13]=>
string(8) "25853423"
[14]=>
string(8) "25853424"
[15]=>
string(8) "25853425"
[16]=>
string(8) "25853426"
[17]=>
string(8) "25853427"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(9) "DiamondHd"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202312925
)
[StreetNumber] => Array
(
[0] => 1487
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Halekoa
)
[StreetSuffix] => Array
(
[0] => Drive
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96821
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://www.youtube.com/embed/hXKW0Yeo9uQ
)
[ListPrice] => Array
(
[0] => 1188000.00
)
[CurrentPrice] => Array
(
[0] => 1188000.00
)
[Neighbourhood] => Array
(
[0] => WAIALAE NUI RDGE
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => This single-family home offers remarkable coastal views of Diamond Head, Kahala, and the city. Situated at the base of Waialae Niu Ridge, it provides convenient access to the beach, Kahala Mall, Kaimuki, and urban Honolulu. With an open floor plan and fresh paint inside and out, the home is move-in ready. The property's standout feature is its viewing terrace, offering a perfect vantage point for breathtaking sunrises and sunsets. The stunning views add significant value to the home and create a meditative beginning and end to each day. Overall, this home combines a desirable location, well-designed interior, and unforgettable views, making it an excellent opportunity for those seeking a stylish and comfortable living space in a sought-after area.
)
[ListOfficeName] => Array
(
[0] => Marcus Realty
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 5795.00
)
[SqftTotal] => Array
(
[0] => 1136
)
[YearBuilt] => Array
(
[0] => 1963
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Coastline,Diamond Head,Golf Course,Ocean,Sunrise,Sunset
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => MARC
)
[ListAgentEmail] => Array
(
[0] => PamelaM@marcushawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 839-7446
)
[ListAgentFullName] => Array
(
[0] => Pamela M Maeda
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2023-09-19T12:54:45.890
)
[Matrix_Unique_ID] => Array
(
[0] => 17362037
)
[OriginalEntryTimestamp] => Array
(
[0] => 2023-06-02T11:02:46.840
)
[_thumbnail_id] => Array
(
[0] => 25853410
)
[listing_image] => Array
(
[0] => 25853410
[1] => 25853411
[2] => 25853412
[3] => 25853413
[4] => 25853414
[5] => 25853415
[6] => 25853416
[7] => 25853417
[8] => 25853418
[9] => 25853419
[10] => 25853420
[11] => 25853421
[12] => 25853422
[13] => 25853423
[14] => 25853424
[15] => 25853425
[16] => 25853426
[17] => 25853427
)
[MLSAreaMajor] => Array
(
[0] => DiamondHd
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
)
- BedsTotal: 3
- Full Baths: 2
- Land Area (sf): 5,795
- Living (sf): 1,136
- Year Built: 1963
- Property Condition: Above Average
- Number of Parking Spaces: 2
- View: Coastline,Diamond Head,Golf Course,Ocean,Sunrise,Sunset
- Listing Office: Marcus Realty
- Land Tenure: FS - Fee Simple
Pamela M Maeda
(808) 839-7446
PamelaM@marcushawaii.com
PamelaM@marcushawaii.com