Previous Next

45-523 Halekou Road Kaneohe, HI 96744

Listing
Overview

Price: $2,250,000
Area: HALE KOU
Status: Active

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202518490"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "45-523"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(7) "Halekou"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(4) "Road"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(7) "Kaneohe"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96744"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "2250000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(8) "HALE KOU"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(625) "Discover the potential of this unique property, offering over half an acre of land with R-5 zoning and positioned to enjoy the stunning backdrop of the beautiful Koolau mountains. Well thought out interior floor plan that frames the large inground pool. While the home is in need of some updating, it presents a rare opportunity to transform it into a wonderful estate. Sold as-is, this property is ideal for buyers seeking value, investors with vision, or anyone looking to customize a large lot in wonderful Kaneohe. With its expansive land, mountain views, and endless potential, this is truly a one-of-a-kind opportunity."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(16) "LUVA Real Estate"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(8) "22498.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "3121"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1973"
  }
  ["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(8) "Mountain"
  }
  ["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) "LUVA"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(21) "Kimi.Correa@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 222-3047"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(11) "Kimi Correa"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18936673"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-08-25T11:30:56.033"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-08-25"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(7) "Kaneohe"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "11:30:56.033"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27122123"
  }
  ["listing_image"]=>
  array(17) {
    [0]=>
    string(8) "27122123"
    [1]=>
    string(8) "27122124"
    [2]=>
    string(8) "27122125"
    [3]=>
    string(8) "27122126"
    [4]=>
    string(8) "27122127"
    [5]=>
    string(8) "27122128"
    [6]=>
    string(8) "27122129"
    [7]=>
    string(8) "27122130"
    [8]=>
    string(8) "27122131"
    [9]=>
    string(8) "27122132"
    [10]=>
    string(8) "27122133"
    [11]=>
    string(8) "27122134"
    [12]=>
    string(8) "27122135"
    [13]=>
    string(8) "27122136"
    [14]=>
    string(8) "27122137"
    [15]=>
    string(8) "27122138"
    [16]=>
    string(8) "27122139"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202518490
        )

    [StreetNumber] => Array
        (
            [0] => 45-523
        )

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

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

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

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

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

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

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

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

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

    [Neighbourhood] => Array
        (
            [0] => HALE KOU
        )

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

    [PublicRemarks] => Array
        (
            [0] => Discover the potential of this unique property, offering over half an acre of land with R-5 zoning and positioned to enjoy the stunning backdrop of the beautiful Koolau mountains. Well thought out interior floor plan that frames the large inground pool. While the home is in need of some updating, it presents a rare opportunity to transform it into a wonderful estate. Sold as-is, this property is ideal for buyers seeking value, investors with vision, or anyone looking to customize a large lot in wonderful Kaneohe. With its expansive land, mountain views, and endless potential, this is truly a one-of-a-kind opportunity.
        )

    [ListOfficeName] => Array
        (
            [0] => LUVA Real Estate
        )

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

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

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

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

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

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

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

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

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

    [StoriesType] => Array
        (
            [0] => One
        )

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => Kimi.Correa@gmail.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 222-3047
        )

    [ListAgentFullName] => Array
        (
            [0] => Kimi Correa
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-08-25T11:30:56.033
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-08-25
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 11:30:56.033
        )

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

    [listing_image] => Array
        (
            [0] => 27122123
            [1] => 27122124
            [2] => 27122125
            [3] => 27122126
            [4] => 27122127
            [5] => 27122128
            [6] => 27122129
            [7] => 27122130
            [8] => 27122131
            [9] => 27122132
            [10] => 27122133
            [11] => 27122134
            [12] => 27122135
            [13] => 27122136
            [14] => 27122137
            [15] => 27122138
            [16] => 27122139
        )

)

PROPERTY INFO

• BedsTotal: 5
• Full Baths: 2
• Half Baths: 1
• Land Area (sf): 22,498 sf
• Living (sf): 3,121
• Year Built: 1973

KEY FEATURES

• Property Condition: Fair
• Number of Parking Spaces: 2
• View: Mountain
• Listing Office: LUVA Real Estate

FINANCIAL INFO

• Land Tenure: FS - Fee Simple

SCHOOLS

CONTACT US

Marcus Realty

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

Based on information from the Multiple Listing Service of HiCentral MLS, Ltd. listings last updated on August 25, 2025 - 11:30 AM Information is deemed reliable but not guaranteed. Copyright: 2025 by HiCentral MLS, Ltd.
Some of the active listings appearing on this site may be listed by other REALTORS®. If you are interested in those active listings, our company may represent you as the buyer's agent. If the active listing you are interested in is our company's active listing, you may speak to one of our agents regarding your options for representation.