4509 Aliikoa Street Honolulu, HI 96821

Listing
Overview

Price: $3,000,000
Area: WAIALAE NUI-LWR
Status: Active

Contractor’s Special! ***Nestled in the highly desirable Wai Kahala neighborhood, this expansive single-family home offers the ultimate island living experience with renovations. Set on a rare 10,000-square-foot lot—the largest in the area—this 5,000-square-foot residence spans three+ levels and features 6 bedrooms, 2 full bathrooms, and 3 half bathrooms. Additionally, the property includes 5 bonus bedrooms and 2 bathrooms, offering incredible versatility. The home has a gated entrance, a pool on property, and a carport that accommodates 2 cars, plus extra parking on premises and on street. The lush grounds are adorned with a variety of fruit trees. Located in Wai Kahala, this home benefits from the area’s serene atmosphere, stunning natural beauty, and close proximity to top-rated schools, shopping, dining, and beaches. Wai Kahala is highly sought after for its blend of tranquility and accessibility, making it one of the most desirable places to live on the island. The number of bedrooms and bathrooms differ from the tax record, buyer to due diligence. With some TLC, this property can become your dream home. A must-see to fully appreciate its potential! Listing by: eXp Realty (808) 743-1899

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202419071"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(4) "4509"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(7) "Aliikoa"
  }
  ["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) "96821"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "3000000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "3000000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(15) "WAIALAE NUI-LWR"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1184) "Contractor’s Special! ***Nestled in the highly desirable Wai Kahala neighborhood, this expansive single-family home offers the ultimate island living experience with renovations. Set on a rare 10,000-square-foot lot—the largest in the area—this 5,000-square-foot residence spans three+ levels and features 6 bedrooms, 2 full bathrooms, and 3 half bathrooms. Additionally, the property includes 5 bonus bedrooms and 2 bathrooms, offering incredible versatility. The home has a gated entrance, a pool on property, and a carport that accommodates 2 cars, plus extra parking on premises and on street. The lush grounds are adorned with a variety of fruit trees. Located in Wai Kahala, this home benefits from the area’s serene atmosphere, stunning natural beauty, and close proximity to top-rated schools, shopping, dining, and beaches. Wai Kahala is highly sought after for its blend of tranquility and accessibility, making it one of the most desirable places to live on the island.
The number of bedrooms and bathrooms differ from the tax record, buyer to due diligence.  
With some TLC, this property can become your dream home. A must-see to fully appreciate its potential!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(10) "eXp Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "6"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(8) "10202.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "5029"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1956"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(4) "Fair"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(6) "Three+"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["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) "EXPI"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(28) "valentina.hirealty@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 743-1899"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(18) "Valentina Haberman"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-09-10T12:13:55.387"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18224182"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-08-29T22:07:53.947"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(9) "DiamondHd"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26689171"
  }
  ["listing_image"]=>
  array(10) {
    [0]=>
    string(8) "26689171"
    [1]=>
    string(8) "26689172"
    [2]=>
    string(8) "26689173"
    [3]=>
    string(8) "26689174"
    [4]=>
    string(8) "26689175"
    [5]=>
    string(8) "26689176"
    [6]=>
    string(8) "26689177"
    [7]=>
    string(8) "26689178"
    [8]=>
    string(8) "26689179"
    [9]=>
    string(8) "26689180"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202419071
        )

    [StreetNumber] => Array
        (
            [0] => 4509
        )

    [PropertyType] => Array
        (
            [0] => Single Family
        )

    [StreetName] => Array
        (
            [0] => Aliikoa
        )

    [StreetSuffix] => Array
        (
            [0] => Street
        )

    [UnitNumber] => Array
        (
            [0] => 
        )

    [City] => Array
        (
            [0] => Honolulu
        )

    [StateOrProvince] => Array
        (
            [0] => HI
        )

    [PostalCode] => Array
        (
            [0] => 96821
        )

    [VirtualTourURLUnbranded] => Array
        (
            [0] => 
        )

    [ListPrice] => Array
        (
            [0] => 3000000.00
        )

    [CurrentPrice] => Array
        (
            [0] => 3000000.00
        )

    [Neighbourhood] => Array
        (
            [0] => WAIALAE NUI-LWR
        )

    [Status] => Array
        (
            [0] => Active
        )

    [PublicRemarks] => Array
        (
            [0] => Contractor’s Special! ***Nestled in the highly desirable Wai Kahala neighborhood, this expansive single-family home offers the ultimate island living experience with renovations. Set on a rare 10,000-square-foot lot—the largest in the area—this 5,000-square-foot residence spans three+ levels and features 6 bedrooms, 2 full bathrooms, and 3 half bathrooms. Additionally, the property includes 5 bonus bedrooms and 2 bathrooms, offering incredible versatility. The home has a gated entrance, a pool on property, and a carport that accommodates 2 cars, plus extra parking on premises and on street. The lush grounds are adorned with a variety of fruit trees. Located in Wai Kahala, this home benefits from the area’s serene atmosphere, stunning natural beauty, and close proximity to top-rated schools, shopping, dining, and beaches. Wai Kahala is highly sought after for its blend of tranquility and accessibility, making it one of the most desirable places to live on the island.
The number of bedrooms and bathrooms differ from the tax record, buyer to due diligence.  
With some TLC, this property can become your dream home. A must-see to fully appreciate its potential!
        )

    [ListOfficeName] => Array
        (
            [0] => eXp Realty
        )

    [BedsTotal] => Array
        (
            [0] => 6
        )

    [BathsFull] => Array
        (
            [0] => 2
        )

    [BathsHalf] => Array
        (
            [0] => 3
        )

    [LotSizeArea] => Array
        (
            [0] => 10202.00
        )

    [SqftTotal] => Array
        (
            [0] => 5029
        )

    [YearBuilt] => Array
        (
            [0] => 1956
        )

    [BuildingName] => Array
        (
            [0] => 
        )

    [PropertyCondition] => Array
        (
            [0] => Fair
        )

    [ParkingTotal] => Array
        (
            [0] => 4
        )

    [StoriesType] => Array
        (
            [0] => Three+
        )

    [View] => Array
        (
            [0] => Other
        )

    [MaintenanceExpense] => Array
        (
            [0] => 
        )

    [LandTenure] => Array
        (
            [0] => FS - Fee Simple
        )

    [ElementarySchool] => Array
        (
            [0] => 
        )

    [MiddleOrJuniorSchool] => Array
        (
            [0] => 
        )

    [HighSchool] => Array
        (
            [0] => 
        )

    [ListOfficeMLSID] => Array
        (
            [0] => EXPI
        )

    [ListAgentEmail] => Array
        (
            [0] => valentina.hirealty@gmail.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 743-1899
        )

    [ListAgentFullName] => Array
        (
            [0] => Valentina Haberman
        )

    [CloseDate] => Array
        (
            [0] => 
        )

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-09-10T12:13:55.387
        )

    [Matrix_Unique_ID] => Array
        (
            [0] => 18224182
        )

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-08-29T22:07:53.947
        )

    [MLSAreaMajor] => Array
        (
            [0] => DiamondHd
        )

    [PropertyFrontage] => Array
        (
            [0] => Other
        )

    [SpecialListingConditions] => Array
        (
            [0] => None
        )

    [_thumbnail_id] => Array
        (
            [0] => 26689171
        )

    [listing_image] => Array
        (
            [0] => 26689171
            [1] => 26689172
            [2] => 26689173
            [3] => 26689174
            [4] => 26689175
            [5] => 26689176
            [6] => 26689177
            [7] => 26689178
            [8] => 26689179
            [9] => 26689180
        )

)

  • BedsTotal: 6
  • Full Baths: 2
  • Half Baths: 3
  • Land Area (sf): 10,202 sf
  • Living (sf): 5,029
  • Year Built: 1956

  • Property Condition: Fair
  • Number of Parking Spaces: 4
  • View: Other
  • Listing Office: eXp Realty

  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

#RB-7120
info@marcushawaii.com
(808)839-7446