47-446 Aialii Place Kaneohe, HI 96744

Listing
Overview

Price: $750,000
Area: AHUIMANU AREA
Status: Active

Nestled in the lush Ahuimanu neighborhood, this 4-bdrm, 2-bath home offers 1,467 sq ft of interior living space on a level 6,196 sq ft lot. Situated in a cul-de-sac, this property boasts great potential for investors or those seeking to transform it into their dream home. Priced $200K below assessed value, this is a rare opportunity to create something truly special in a highly desirable Windward Oahu location. The property requires major repair or teardown, offering a blank canvas for your vision. Enjoy convenient access to major highways including H-3, Likelike, and Pali, making your commute a breeze. Just minutes away from Windward Mall, local restaurants, and markets, you'll appreciate the accessibility of modern conveniences while still enjoying the tranquility of Ahuimanu. Don't miss this chance to reimagine and revitalize a property with endless possibilities! Listing by: BHGRE Advantage Realty (808) 561-2969

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202427049"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "47-446"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(6) "Aialii"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(5) "Place"
  }
  ["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(9) "750000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(9) "750000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(13) "AHUIMANU AREA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(882) "Nestled in the lush Ahuimanu neighborhood, this 4-bdrm, 2-bath home offers 1,467 sq ft of interior living space on a level 6,196 sq ft lot. Situated in a cul-de-sac, this property boasts great potential for investors or those seeking to transform it into their dream home.
Priced $200K below assessed value, this is a rare opportunity to create something truly special in a highly desirable Windward Oahu location. The property requires major repair or teardown, offering a blank canvas for your vision.
Enjoy convenient access to major highways including H-3, Likelike, and Pali, making your commute a breeze. Just minutes away from Windward Mall, local restaurants, and markets, you'll appreciate the accessibility of modern conveniences while still enjoying the tranquility of Ahuimanu.
Don't miss this chance to reimagine and revitalize a property with endless possibilities!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(22) "BHGRE Advantage Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "6196.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "1467"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1973"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(28) "Needs Major Repair,Tear Down"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["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(6) "ADVG02"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(23) "TracyB@BetterHawaii.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 561-2969"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(12) "Tracy R Bean"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-11-22T22:04:24.927"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18394547"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-11-22T08:37:49.587"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(7) "Kaneohe"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(7) "Probate"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26779921"
  }
  ["listing_image"]=>
  array(15) {
    [0]=>
    string(8) "26779921"
    [1]=>
    string(8) "26779922"
    [2]=>
    string(8) "26779923"
    [3]=>
    string(8) "26779924"
    [4]=>
    string(8) "26779925"
    [5]=>
    string(8) "26779926"
    [6]=>
    string(8) "26779927"
    [7]=>
    string(8) "26779928"
    [8]=>
    string(8) "26779929"
    [9]=>
    string(8) "26779930"
    [10]=>
    string(8) "26779931"
    [11]=>
    string(8) "26779932"
    [12]=>
    string(8) "26779933"
    [13]=>
    string(8) "26779934"
    [14]=>
    string(8) "26779935"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202427049
        )

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

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

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

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

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

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

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

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

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

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

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

    [Neighbourhood] => Array
        (
            [0] => AHUIMANU AREA
        )

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

    [PublicRemarks] => Array
        (
            [0] => Nestled in the lush Ahuimanu neighborhood, this 4-bdrm, 2-bath home offers 1,467 sq ft of interior living space on a level 6,196 sq ft lot. Situated in a cul-de-sac, this property boasts great potential for investors or those seeking to transform it into their dream home.
Priced $200K below assessed value, this is a rare opportunity to create something truly special in a highly desirable Windward Oahu location. The property requires major repair or teardown, offering a blank canvas for your vision.
Enjoy convenient access to major highways including H-3, Likelike, and Pali, making your commute a breeze. Just minutes away from Windward Mall, local restaurants, and markets, you'll appreciate the accessibility of modern conveniences while still enjoying the tranquility of Ahuimanu.
Don't miss this chance to reimagine and revitalize a property with endless possibilities!
        )

    [ListOfficeName] => Array
        (
            [0] => BHGRE Advantage Realty
        )

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

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

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

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

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

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

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

    [PropertyCondition] => Array
        (
            [0] => Needs Major Repair,Tear Down
        )

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

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

    [ListAgentEmail] => Array
        (
            [0] => TracyB@BetterHawaii.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 561-2969
        )

    [ListAgentFullName] => Array
        (
            [0] => Tracy R Bean
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-11-22T22:04:24.927
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-11-22T08:37:49.587
        )

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

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

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

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

    [listing_image] => Array
        (
            [0] => 26779921
            [1] => 26779922
            [2] => 26779923
            [3] => 26779924
            [4] => 26779925
            [5] => 26779926
            [6] => 26779927
            [7] => 26779928
            [8] => 26779929
            [9] => 26779930
            [10] => 26779931
            [11] => 26779932
            [12] => 26779933
            [13] => 26779934
            [14] => 26779935
        )

)

  • BedsTotal: 4
  • Full Baths: 2
  • Land Area (sf): 6,196
  • Living (sf): 1,467
  • Year Built: 1973

  • Property Condition: Needs Major Repair,Tear Down
  • Number of Parking Spaces: 3
  • View: Mountain
  • Listing Office: BHGRE Advantage Realty

  • Land Tenure: FS - Fee Simple

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

CONTACT US

Marcus Realty

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