47-166 Wailehua Road Kaneohe, HI 96744

Listing
Overview

Price: $1,699,999
Area: KAALAEA
Status: Active

Great Opportunity for Investors and Owners! Two Single Family Homes- One two level home featuring 5 bedrooms/ 3 baths at 1,920sqft, and the other second, a single level with 3 bedrooms/ 2 baths at 1,436sqft and separate mailing address. Each home has their own enclosed garage, driveway parking, and lots of yard space. Buyers to do their own due diligence. As built does not match tax records. Sold AS IS. Listing by: LC Real Estate LLC (808) 922-7788

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202425988"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "47-166"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(8) "Wailehua"
  }
  ["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) "1699999.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "1699999.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAALAEA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(406) "Great Opportunity for Investors and Owners! Two Single Family Homes- One two level home featuring 5 bedrooms/ 3 baths at 1,920sqft, and the other second, a single level with 3 bedrooms/ 2 baths at 1,436sqft and separate mailing address. Each home has their own enclosed garage, driveway parking, and lots of yard space. Buyers to do their own due diligence. As built does not match tax records. Sold AS IS."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(18) "LC Real Estate LLC"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(2) "10"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "6"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(8) "16348.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "3356"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1974"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(7) "Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "6"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "Two"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(14) "Mountain,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(4) "King"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(6) "Castle"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "LCRE"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(28) "LCRealEstateHawaii@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 922-7788"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(17) "Man-Lin Chen Lieu"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-11-04T11:27:10.570"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18365567"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-11-04T11:17:53.650"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(7) "Kaneohe"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26755448"
  }
  ["listing_image"]=>
  array(11) {
    [0]=>
    string(8) "26755448"
    [1]=>
    string(8) "26755449"
    [2]=>
    string(8) "26755450"
    [3]=>
    string(8) "26755451"
    [4]=>
    string(8) "26755452"
    [5]=>
    string(8) "26755453"
    [6]=>
    string(8) "26755454"
    [7]=>
    string(8) "26755455"
    [8]=>
    string(8) "26755456"
    [9]=>
    string(8) "26755457"
    [10]=>
    string(8) "26755458"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202425988
        )

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Great Opportunity for Investors and Owners! Two Single Family Homes- One two level home featuring 5 bedrooms/ 3 baths at 1,920sqft, and the other second, a single level with 3 bedrooms/ 2 baths at 1,436sqft and separate mailing address. Each home has their own enclosed garage, driveway parking, and lots of yard space. Buyers to do their own due diligence. As built does not match tax records. Sold AS IS.
        )

    [ListOfficeName] => Array
        (
            [0] => LC Real Estate LLC
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 922-7788
        )

    [ListAgentFullName] => Array
        (
            [0] => Man-Lin Chen Lieu
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-11-04T11:27:10.570
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-11-04T11:17:53.650
        )

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

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

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

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

    [listing_image] => Array
        (
            [0] => 26755448
            [1] => 26755449
            [2] => 26755450
            [3] => 26755451
            [4] => 26755452
            [5] => 26755453
            [6] => 26755454
            [7] => 26755455
            [8] => 26755456
            [9] => 26755457
            [10] => 26755458
        )

)

  • BedsTotal: 10
  • Full Baths: 6
  • Land Area (sf): 16,348
  • Living (sf): 3,356
  • Year Built: 1974

  • Property Condition: Average
  • Number of Parking Spaces: 6
  • View: Mountain,Other
  • Listing Office: LC Real Estate LLC

  • Land Tenure: FS - Fee Simple

  • Middle School: King
  • High School: Castle

CONTACT US

Marcus Realty

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