Previous Next

47-649 Lamaula Road Kaneohe, HI 96744

Listing
Overview

Price: $2,950,000
Area: KAALAEA
Status: Active Under Contract

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202520278"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "47-649"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(7) "Lamaula"
  }
  ["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) "2950000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAALAEA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(21) "Active Under Contract"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(559) "Listed way below current appraisal of $4,000,000 copy in supplements. There are 10 older plantation style homes on this 7.929 acres.7 three bedroom and 3 two-bedroom homes. Lot is zoned AG-2 make this your family compound or keep them as rentals. Gross income approx. $192,000 per yr. Expenses approx. $67,000 per yr. Can't get you into the homes, would need to make an offer subject to sight inspection. Call listing agent to meet at the property. Inclusion is only water heater. All appliances (refrigerator, stove, washer, and/or dryer belong to tenant(s)."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(28) "Island Heritage Realty, Inc."
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(2) "27"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(2) "10"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(9) "345387.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "6568"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1941"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(12) "Average,Fair"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(2) "20"
  }
  ["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(7) "Kahaluu"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(4) "King"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(6) "Castle"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "ISLR"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(25) "danny_pacheco@hotmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 226-6510"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(20) "Daniel J Pacheco Jr."
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18979525"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-09-12T21:18:02.983"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-09-12"
  }
  ["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) "21:18:02.983"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27147567"
  }
  ["listing_image"]=>
  array(18) {
    [0]=>
    string(8) "27147567"
    [1]=>
    string(8) "27147568"
    [2]=>
    string(8) "27147569"
    [3]=>
    string(8) "27147570"
    [4]=>
    string(8) "27147571"
    [5]=>
    string(8) "27147572"
    [6]=>
    string(8) "27147573"
    [7]=>
    string(8) "27147574"
    [8]=>
    string(8) "27147575"
    [9]=>
    string(8) "27147576"
    [10]=>
    string(8) "27147577"
    [11]=>
    string(8) "27147578"
    [12]=>
    string(8) "27147579"
    [13]=>
    string(8) "27147580"
    [14]=>
    string(8) "27147581"
    [15]=>
    string(8) "27147582"
    [16]=>
    string(8) "27147583"
    [17]=>
    string(8) "27147584"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202520278
        )

    [StreetNumber] => Array
        (
            [0] => 47-649
        )

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

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

    [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] => 2950000.00
        )

    [Neighbourhood] => Array
        (
            [0] => KAALAEA
        )

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

    [PublicRemarks] => Array
        (
            [0] => Listed way below current appraisal of $4,000,000 copy in supplements. There are 10 older plantation style homes on this 7.929 acres.7 three bedroom and 3 two-bedroom homes. Lot is zoned AG-2 make this your family compound or keep them as rentals. Gross income approx. $192,000 per yr. Expenses approx. $67,000 per yr. Can't get you into the homes, would need to make an offer subject to sight inspection. Call listing agent to meet at the property. Inclusion is only water heater. All appliances (refrigerator, stove, washer, and/or dryer belong to tenant(s).
        )

    [ListOfficeName] => Array
        (
            [0] => Island Heritage Realty, Inc.
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => danny_pacheco@hotmail.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 226-6510
        )

    [ListAgentFullName] => Array
        (
            [0] => Daniel J Pacheco Jr.
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-09-12T21:18:02.983
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-09-12
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 21:18:02.983
        )

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

    [listing_image] => Array
        (
            [0] => 27147567
            [1] => 27147568
            [2] => 27147569
            [3] => 27147570
            [4] => 27147571
            [5] => 27147572
            [6] => 27147573
            [7] => 27147574
            [8] => 27147575
            [9] => 27147576
            [10] => 27147577
            [11] => 27147578
            [12] => 27147579
            [13] => 27147580
            [14] => 27147581
            [15] => 27147582
            [16] => 27147583
            [17] => 27147584
        )

)

PROPERTY INFO

• BedsTotal: 27
• Full Baths: 10
• Land Area (sf): 345,387 sf
• Living (sf): 6,568
• Year Built: 1941

KEY FEATURES

• Property Condition: Average,Fair
• Number of Parking Spaces: 20
• View: Mountain
• Listing Office: Island Heritage Realty, Inc.

FINANCIAL INFO

• Land Tenure: FS - Fee Simple

SCHOOLS

• Elementary School: Kahaluu
• Middle School: King
• High School: Castle

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 September 12, 2025 - 9:18 PM 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.