Listing
Overview
Price: $1,699,000
Area: MOANALUA GARDENS
Status: Active
This completely renovated, spacious single-family residence boasts five bedrooms, three stunning full walk-in showers, with an additional office space. This home is ideally designed for remote work, extended family living and/or rental possibilities. Step inside and be enchanted by the contemporary open floorplan that seamlessly connects living, dining, and kitchen areas, making it perfect for entertaining family and friends. The heart of the home features high-end finishes, stylish fixtures, and an abundance of natural light. Prepare to be amazed by the dream laundry/mud room that is off of a two-car garage. When it’s time to unwind, step outside to your fully enclosed, expansive yard, featuring a remarkable 450 sq ft deck and multiple patio areas—perfect for relaxing, exercising, or hosting unforgettable gatherings under the stars. Ample outdoor storage, landscaped backdrop. Nestled in the coveted Moanalua Gardens, you’ll enjoy a serene environment while being centrally located to shopping, dining, parks, golf courses, hospitals, the airport, military bases, and all the amenities that the vibrant community has to offer. Listing by: Advantage Properties Unlimited (808) 306-4973
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202427088"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(4) "1545"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(11) "Ala Mahamoe"
}
["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) "96819"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(50) "https://hommati.tours/tour/2278950?play=no&mls=yes"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1699000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1699000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(16) "MOANALUA GARDENS"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1145) "This completely renovated, spacious single-family residence boasts five bedrooms, three stunning full walk-in showers, with an additional office space. This home is ideally designed for remote work, extended family living and/or rental possibilities. Step inside and be enchanted by the contemporary open floorplan that seamlessly connects living, dining, and kitchen areas, making it perfect for entertaining family and friends. The heart of the home features high-end finishes, stylish fixtures, and an abundance of natural light. Prepare to be amazed by the dream laundry/mud room that is off of a two-car garage. When it’s time to unwind, step outside to your fully enclosed, expansive yard, featuring a remarkable 450 sq ft deck and multiple patio areas—perfect for relaxing, exercising, or hosting unforgettable gatherings under the stars. Ample outdoor storage, landscaped backdrop. Nestled in the coveted Moanalua Gardens, you’ll enjoy a serene environment while being centrally located to shopping, dining, parks, golf courses, hospitals, the airport, military bases, and all the amenities that the vibrant community has to offer."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(30) "Advantage Properties Unlimited"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "5"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "6455.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "3917"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1960"
}
["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(6) "Three+"
}
["View"]=>
array(1) {
[0]=>
string(44) "City,Coastline,Mountain,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) "ADPU"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(24) "jessica.haumea@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 306-4973"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(16) "Jessica L Haumea"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-11-22T06:45:01.560"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18395544"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-11-21T01:28:51.380"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(5) "Metro"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26778239"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26778239"
[1]=>
string(8) "26778240"
[2]=>
string(8) "26778241"
[3]=>
string(8) "26778242"
[4]=>
string(8) "26778243"
[5]=>
string(8) "26778244"
[6]=>
string(8) "26778245"
[7]=>
string(8) "26778246"
[8]=>
string(8) "26778247"
[9]=>
string(8) "26778248"
[10]=>
string(8) "26778249"
[11]=>
string(8) "26778250"
[12]=>
string(8) "26778251"
[13]=>
string(8) "26778252"
[14]=>
string(8) "26778253"
[15]=>
string(8) "26778254"
[16]=>
string(8) "26778255"
[17]=>
string(8) "26778256"
[18]=>
string(8) "26778257"
[19]=>
string(8) "26778258"
[20]=>
string(8) "26778259"
[21]=>
string(8) "26778260"
[22]=>
string(8) "26778261"
[23]=>
string(8) "26778262"
[24]=>
string(8) "26778263"
[25]=>
string(8) "26778264"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202427088
)
[StreetNumber] => Array
(
[0] => 1545
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Ala Mahamoe
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96819
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://hommati.tours/tour/2278950?play=no&mls=yes
)
[ListPrice] => Array
(
[0] => 1699000.00
)
[CurrentPrice] => Array
(
[0] => 1699000.00
)
[Neighbourhood] => Array
(
[0] => MOANALUA GARDENS
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => This completely renovated, spacious single-family residence boasts five bedrooms, three stunning full walk-in showers, with an additional office space. This home is ideally designed for remote work, extended family living and/or rental possibilities. Step inside and be enchanted by the contemporary open floorplan that seamlessly connects living, dining, and kitchen areas, making it perfect for entertaining family and friends. The heart of the home features high-end finishes, stylish fixtures, and an abundance of natural light. Prepare to be amazed by the dream laundry/mud room that is off of a two-car garage. When it’s time to unwind, step outside to your fully enclosed, expansive yard, featuring a remarkable 450 sq ft deck and multiple patio areas—perfect for relaxing, exercising, or hosting unforgettable gatherings under the stars. Ample outdoor storage, landscaped backdrop. Nestled in the coveted Moanalua Gardens, you’ll enjoy a serene environment while being centrally located to shopping, dining, parks, golf courses, hospitals, the airport, military bases, and all the amenities that the vibrant community has to offer.
)
[ListOfficeName] => Array
(
[0] => Advantage Properties Unlimited
)
[BedsTotal] => Array
(
[0] => 5
)
[BathsFull] => Array
(
[0] => 3
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 6455.00
)
[SqftTotal] => Array
(
[0] => 3917
)
[YearBuilt] => Array
(
[0] => 1960
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => Three+
)
[View] => Array
(
[0] => City,Coastline,Mountain,Ocean,Sunrise,Sunset
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => ADPU
)
[ListAgentEmail] => Array
(
[0] => jessica.haumea@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 306-4973
)
[ListAgentFullName] => Array
(
[0] => Jessica L Haumea
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-11-22T06:45:01.560
)
[Matrix_Unique_ID] => Array
(
[0] => 18395544
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-11-21T01:28:51.380
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26778239
)
[listing_image] => Array
(
[0] => 26778239
[1] => 26778240
[2] => 26778241
[3] => 26778242
[4] => 26778243
[5] => 26778244
[6] => 26778245
[7] => 26778246
[8] => 26778247
[9] => 26778248
[10] => 26778249
[11] => 26778250
[12] => 26778251
[13] => 26778252
[14] => 26778253
[15] => 26778254
[16] => 26778255
[17] => 26778256
[18] => 26778257
[19] => 26778258
[20] => 26778259
[21] => 26778260
[22] => 26778261
[23] => 26778262
[24] => 26778263
[25] => 26778264
)
)
- BedsTotal: 5
- Full Baths: 3
- Land Area (sf): 6,455
- Living (sf): 3,917
- Year Built: 1960
- Property Condition: Excellent
- Number of Parking Spaces: 4
- View: City,Coastline,Mountain,Ocean,Sunrise,Sunset
- Listing Office: Advantage Properties Unlimited
- Land Tenure: FS - Fee Simple
