51-441 Haahaa Street Kaaawa, HI 96730

Take a Virtual Tour

Listing
Overview

Price: $1,550,000
Area: KAAAWA
Status: Active Under Contract

Nestled amongst nature's beauty, this turn-key fully furnished, exceptionally renovated 4-br, 3-ba home offers a serene and private escape while showcasing stunning panoramic mountain views and a glimpse of the ocean. As you step inside, you'll be greeted by an open-concept living area that seamlessly combines the living room, dining room, and kitchen, adorned with large windows that let in a constant cool ocean breeze. The home offers separate living options that are great for multi-generation living or additional rental income possibility including two sets of washer/dryers and two refrigerators. Step outside to the lush tropical oasis, the fully fenced yard is a landscaped paradise, featuring a spacious lanai for al fresco dining, a manicured lawn for play, and a variety of fruiting trees and flowering plants that provide beauty. The outdoor space is perfect for hosting garden parties, or simply unwinding after a long day. This haven of tranquility is complemented by its convenient location – just a short walk to the beach, hiking trails, and outdoor rec activities and its over 10,000 sf lot offers future expansion opportunities. Don't miss out on this stunning designer home! Listing by: Compass (808) 381-2750

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202320271"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "51-441"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(6) "Haahaa"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(6) "Kaaawa"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96730"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(39) "http://player.vimeo.com/video/861489071"
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "1550000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "1550000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(6) "KAAAWA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(21) "Active Under Contract"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1199) "Nestled amongst nature's beauty, this turn-key fully furnished, exceptionally renovated 4-br, 3-ba home offers a serene and private escape while showcasing stunning panoramic mountain views and a glimpse of the ocean. As you step inside, you'll be greeted by an open-concept living area that seamlessly combines the living room, dining room, and kitchen, adorned with large windows that let in a constant cool ocean breeze. The home offers separate living options that are great for multi-generation living or additional rental income possibility including two sets of washer/dryers and two refrigerators. Step outside to the lush tropical oasis, the fully fenced yard is a landscaped paradise, featuring a spacious lanai for al fresco dining, a manicured lawn for play, and a variety of fruiting trees and flowering plants that provide beauty. The outdoor space is perfect for hosting garden parties, or simply unwinding after a long day. This haven of tranquility is complemented by its convenient location – just a short walk to the beach, hiking trails, and outdoor rec activities and its over 10,000 sf lot offers future expansion opportunities. Don't miss out on this stunning designer home!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(7) "Compass"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(8) "10859.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "3218"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1969"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(21) "Garden,Mountain,Other"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(6) "Kaaawa"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(6) "Kahuku"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(6) "Kahuku"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "COHI"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(28) "mstyring@hawaiirealtyllc.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 381-2750"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(17) "Michael D Styring"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-04-12T14:58:07.927"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "17529388"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2023-08-31T15:01:23.820"
  }
  ["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) "25938829"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "25938829"
    [1]=>
    string(8) "25938830"
    [2]=>
    string(8) "25938831"
    [3]=>
    string(8) "25938832"
    [4]=>
    string(8) "25938833"
    [5]=>
    string(8) "25938834"
    [6]=>
    string(8) "25938835"
    [7]=>
    string(8) "25938836"
    [8]=>
    string(8) "25938837"
    [9]=>
    string(8) "25938838"
    [10]=>
    string(8) "25938839"
    [11]=>
    string(8) "25938840"
    [12]=>
    string(8) "25938841"
    [13]=>
    string(8) "25938842"
    [14]=>
    string(8) "25938843"
    [15]=>
    string(8) "25938844"
    [16]=>
    string(8) "25938845"
    [17]=>
    string(8) "25938846"
    [18]=>
    string(8) "25938847"
    [19]=>
    string(8) "25938848"
    [20]=>
    string(8) "25938849"
    [21]=>
    string(8) "25938850"
    [22]=>
    string(8) "25938851"
    [23]=>
    string(8) "25938852"
    [24]=>
    string(8) "25938853"
    [25]=>
    string(8) "25938854"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202320271
        )

    [StreetNumber] => Array
        (
            [0] => 51-441
        )

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

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

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

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

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

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

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

    [VirtualTourURLUnbranded] => Array
        (
            [0] => http://player.vimeo.com/video/861489071
        )

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Nestled amongst nature's beauty, this turn-key fully furnished, exceptionally renovated 4-br, 3-ba home offers a serene and private escape while showcasing stunning panoramic mountain views and a glimpse of the ocean. As you step inside, you'll be greeted by an open-concept living area that seamlessly combines the living room, dining room, and kitchen, adorned with large windows that let in a constant cool ocean breeze. The home offers separate living options that are great for multi-generation living or additional rental income possibility including two sets of washer/dryers and two refrigerators. Step outside to the lush tropical oasis, the fully fenced yard is a landscaped paradise, featuring a spacious lanai for al fresco dining, a manicured lawn for play, and a variety of fruiting trees and flowering plants that provide beauty. The outdoor space is perfect for hosting garden parties, or simply unwinding after a long day. This haven of tranquility is complemented by its convenient location – just a short walk to the beach, hiking trails, and outdoor rec activities and its over 10,000 sf lot offers future expansion opportunities. Don't miss out on this stunning designer home!
        )

    [ListOfficeName] => Array
        (
            [0] => Compass
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => mstyring@hawaiirealtyllc.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 381-2750
        )

    [ListAgentFullName] => Array
        (
            [0] => Michael D Styring
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-04-12T14:58:07.927
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2023-08-31T15:01:23.820
        )

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

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

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

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

    [listing_image] => Array
        (
            [0] => 25938829
            [1] => 25938830
            [2] => 25938831
            [3] => 25938832
            [4] => 25938833
            [5] => 25938834
            [6] => 25938835
            [7] => 25938836
            [8] => 25938837
            [9] => 25938838
            [10] => 25938839
            [11] => 25938840
            [12] => 25938841
            [13] => 25938842
            [14] => 25938843
            [15] => 25938844
            [16] => 25938845
            [17] => 25938846
            [18] => 25938847
            [19] => 25938848
            [20] => 25938849
            [21] => 25938850
            [22] => 25938851
            [23] => 25938852
            [24] => 25938853
            [25] => 25938854
        )

)

  • BedsTotal: 4
  • Full Baths: 3
  • Land Area (sf): 10,859
  • Living (sf): 3,218
  • Year Built: 1969

  • Property Condition: Above Average
  • Number of Parking Spaces: 2
  • View: Garden,Mountain,Other
  • Listing Office: Compass

  • Land Tenure: FS - Fee Simple

  • Elementary School: Kaaawa
  • Middle School: Kahuku
  • High School: Kahuku

CONTACT US

Marcus Realty

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