Listing
Overview
Price: $1,750,000
Area: ST. LOUIS
Status: Pending
Ultra-Captivating Single Level Home with Panoramic Views, 38 Photovoltaic Panels, Pool and Spa! Situated atop a 6,116sqft lot less than 1-mile from Waialae Avenue, this fully renovated 2BR/2BA, 1,858sqft property features professional Japanese landscaping, open floorplan, recessed lighting, and a spacious living room. Entertain in the open concept gourmet kitchen with Corian countertops, premium stainless-steel Sub-Zero and Bertazzoni appliances, large pantry, and breakfast bar. Step outdoors to find a private pool, spa, covered lanai, and breathtaking views of the cityscape, Diamond Head and Pacific Ocean. Both bedrooms are abundantly sized, while the primary bedroom also has dual closets and an en suite boasting a whirlpool tub, double sinks, and an extra large walk-in shower. Other features include a 2-car garage, full-size LG W/D, split A/C in every room, designer ceilings fans, built-in display cabinetry, 38 photovoltaic panels and much more! Start living the good life, and come see it today! Listing by: Real Estate Specialists (808) 347-8005
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202501595"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(4) "1516"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(11) "Kalaepohaku"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Place"
}
["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(60) "https://my.matterport.com/show/?m=dHUhCMgujGm&brand=0&mls=1&"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1750000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(9) "ST. LOUIS"
}
["Status"]=>
array(1) {
[0]=>
string(7) "Pending"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1012) "Ultra-Captivating Single Level Home with Panoramic Views, 38 Photovoltaic Panels, Pool and Spa! Situated atop a 6,116sqft lot less than 1-mile from Waialae Avenue, this fully renovated 2BR/2BA, 1,858sqft property features professional Japanese landscaping, open floorplan, recessed lighting, and a spacious living room. Entertain in the open concept gourmet kitchen with Corian countertops, premium stainless-steel Sub-Zero and Bertazzoni appliances, large pantry, and breakfast bar. Step outdoors to find a private pool, spa, covered lanai, and breathtaking views of the cityscape, Diamond Head and Pacific Ocean. Both bedrooms are abundantly sized, while the primary bedroom also has dual closets and an en suite boasting a whirlpool tub, double sinks, and an extra large walk-in shower. Other features include a 2-car garage, full-size LG W/D, split A/C in every room, designer ceilings fans, built-in display cabinetry, 38 photovoltaic panels and much more! Start living the good life, and come see it today!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(23) "Real Estate Specialists"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "6116.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "2838"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1961"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(49) "City,Coastline,Diamond Head,Mountain,Ocean,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) "HRES"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(23) "derek.lau@reshawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 347-8005"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(11) "Derek C Lau"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18482278"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-02-05T00:08:54.507"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-01-06"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(9) "DiamondHd"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "00:08:54.507"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26833161"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26833161"
[1]=>
string(8) "26833162"
[2]=>
string(8) "26833163"
[3]=>
string(8) "26833164"
[4]=>
string(8) "26833165"
[5]=>
string(8) "26833166"
[6]=>
string(8) "26833167"
[7]=>
string(8) "26833168"
[8]=>
string(8) "26833169"
[9]=>
string(8) "26833170"
[10]=>
string(8) "26833171"
[11]=>
string(8) "26833172"
[12]=>
string(8) "26833173"
[13]=>
string(8) "26833174"
[14]=>
string(8) "26833175"
[15]=>
string(8) "26833176"
[16]=>
string(8) "26833177"
[17]=>
string(8) "26833178"
[18]=>
string(8) "26833179"
[19]=>
string(8) "26833180"
[20]=>
string(8) "26833181"
[21]=>
string(8) "26833182"
[22]=>
string(8) "26833183"
[23]=>
string(8) "26833184"
[24]=>
string(8) "26833185"
[25]=>
string(8) "26833186"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202501595
)
[StreetNumber] => Array
(
[0] => 1516
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Kalaepohaku
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96816
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://my.matterport.com/show/?m=dHUhCMgujGm&brand=0&mls=1&
)
[ListPrice] => Array
(
[0] => 1750000.00
)
[Neighbourhood] => Array
(
[0] => ST. LOUIS
)
[Status] => Array
(
[0] => Pending
)
[PublicRemarks] => Array
(
[0] => Ultra-Captivating Single Level Home with Panoramic Views, 38 Photovoltaic Panels, Pool and Spa! Situated atop a 6,116sqft lot less than 1-mile from Waialae Avenue, this fully renovated 2BR/2BA, 1,858sqft property features professional Japanese landscaping, open floorplan, recessed lighting, and a spacious living room. Entertain in the open concept gourmet kitchen with Corian countertops, premium stainless-steel Sub-Zero and Bertazzoni appliances, large pantry, and breakfast bar. Step outdoors to find a private pool, spa, covered lanai, and breathtaking views of the cityscape, Diamond Head and Pacific Ocean. Both bedrooms are abundantly sized, while the primary bedroom also has dual closets and an en suite boasting a whirlpool tub, double sinks, and an extra large walk-in shower. Other features include a 2-car garage, full-size LG W/D, split A/C in every room, designer ceilings fans, built-in display cabinetry, 38 photovoltaic panels and much more! Start living the good life, and come see it today!
)
[ListOfficeName] => Array
(
[0] => Real Estate Specialists
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 6116.00
)
[SqftTotal] => Array
(
[0] => 2838
)
[YearBuilt] => Array
(
[0] => 1961
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => City,Coastline,Diamond Head,Mountain,Ocean,Sunset
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => HRES
)
[ListAgentEmail] => Array
(
[0] => derek.lau@reshawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 347-8005
)
[ListAgentFullName] => Array
(
[0] => Derek C Lau
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18482278
)
[MatrixModifiedDT] => Array
(
[0] => 2025-02-05T00:08:54.507
)
[ListingContractDate] => Array
(
[0] => 2025-01-06
)
[MLSAreaMajor] => Array
(
[0] => DiamondHd
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 00:08:54.507
)
[_thumbnail_id] => Array
(
[0] => 26833161
)
[listing_image] => Array
(
[0] => 26833161
[1] => 26833162
[2] => 26833163
[3] => 26833164
[4] => 26833165
[5] => 26833166
[6] => 26833167
[7] => 26833168
[8] => 26833169
[9] => 26833170
[10] => 26833171
[11] => 26833172
[12] => 26833173
[13] => 26833174
[14] => 26833175
[15] => 26833176
[16] => 26833177
[17] => 26833178
[18] => 26833179
[19] => 26833180
[20] => 26833181
[21] => 26833182
[22] => 26833183
[23] => 26833184
[24] => 26833185
[25] => 26833186
)
)
- BedsTotal: 2
- Full Baths: 2
- Land Area (sf): 6,116 sf
- Living (sf): 2,838
- Year Built: 1961
- Property Condition: Excellent
- Number of Parking Spaces: 4
- View: City,Coastline,Diamond Head,Mountain,Ocean,Sunset
- Listing Office: Real Estate Specialists
- Land Tenure: FS - Fee Simple
