44-1731 Laha Street Unit 2101 Kaneohe, HI 96744

Listing
Overview

Price: $969,950
Area: COUNTRY CLUB
Status: Active Under Contract

NOW AVAILABLE in the desirable Yacht Club Terrace community - a pristine single level 3 bedroom 2 bath home that has just been painstakingly updated with new LVP flooring throughout, all new appliances, new cabinets in kitchen and bathrooms, all new lighting fixtures, all new plumbing fixtures and MORE!! This unit is a must-see! The elegant kitchen with an eat-in bar flows seamlessly into the gracious high ceilinged living and dining areas. This home features a generous 600 sq ft lanai with fabulous views- Kaneohe Bay, the Koolau mountains, and a lovely park. You can dine or or just relax while enjoying the stunning vistas. AND there is a sweet courtyard (with a storage shed!) that two bedrooms open out onto - perfect for gardening or just relaxing. 2 convenient parking stalls # 2101- one in front of unit and one right across. Listing by: Homequest LLC (808) 284-2043

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202408990"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(7) "44-1731"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(15) "Condo/Townhouse"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(4) "Laha"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(4) "2101"
  }
  ["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) "969950.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(9) "969950.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(12) "COUNTRY CLUB"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(21) "Active Under Contract"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(851) "NOW AVAILABLE in the desirable Yacht Club Terrace community - a pristine single level 3 bedroom 2 bath home that has just been painstakingly updated with new LVP flooring throughout, all new appliances, new cabinets in kitchen and bathrooms, all new lighting fixtures, all new plumbing fixtures and MORE!!  This unit is a must-see!  The elegant kitchen with an eat-in bar flows seamlessly into the gracious high ceilinged living and dining areas. 

This home features a generous 600 sq ft  lanai with fabulous views- Kaneohe Bay, the  Koolau mountains, and a lovely park.
You can dine or or just relax while enjoying the stunning vistas.
AND there is a sweet courtyard (with a storage shed!) that two bedrooms open out onto - perfect for gardening or just relaxing.

2 convenient parking stalls # 2101- one in front of unit and one right across."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(13) "Homequest LLC"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(10) "1427635.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "1810"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1973"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(18) "Yacht Club Terrace"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(23) "Excellent,Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(20) "Mountain,Ocean,Other"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "838.00"
  }
  ["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) "HOMQ"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(22) "casademarisa@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 284-2043"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(15) "Marisa Villalba"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-06-04T16:02:29.770"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "17960533"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-05-29T20:30:56.157"
  }
  ["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) "26545655"
  }
  ["listing_image"]=>
  array(24) {
    [0]=>
    string(8) "26545655"
    [1]=>
    string(8) "26545656"
    [2]=>
    string(8) "26545657"
    [3]=>
    string(8) "26545658"
    [4]=>
    string(8) "26545659"
    [5]=>
    string(8) "26545660"
    [6]=>
    string(8) "26545661"
    [7]=>
    string(8) "26545662"
    [8]=>
    string(8) "26545663"
    [9]=>
    string(8) "26545664"
    [10]=>
    string(8) "26545665"
    [11]=>
    string(8) "26545666"
    [12]=>
    string(8) "26545667"
    [13]=>
    string(8) "26545668"
    [14]=>
    string(8) "26545669"
    [15]=>
    string(8) "26545670"
    [16]=>
    string(8) "26545671"
    [17]=>
    string(8) "26545672"
    [18]=>
    string(8) "26545673"
    [19]=>
    string(8) "26545674"
    [20]=>
    string(8) "26545675"
    [21]=>
    string(8) "26545676"
    [22]=>
    string(8) "26545677"
    [23]=>
    string(8) "26545678"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202408990
        )

    [StreetNumber] => Array
        (
            [0] => 44-1731
        )

    [PropertyType] => Array
        (
            [0] => Condo/Townhouse
        )

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

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

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

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

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

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

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

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

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

    [Neighbourhood] => Array
        (
            [0] => COUNTRY CLUB
        )

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

    [PublicRemarks] => Array
        (
            [0] => NOW AVAILABLE in the desirable Yacht Club Terrace community - a pristine single level 3 bedroom 2 bath home that has just been painstakingly updated with new LVP flooring throughout, all new appliances, new cabinets in kitchen and bathrooms, all new lighting fixtures, all new plumbing fixtures and MORE!!  This unit is a must-see!  The elegant kitchen with an eat-in bar flows seamlessly into the gracious high ceilinged living and dining areas. 

This home features a generous 600 sq ft  lanai with fabulous views- Kaneohe Bay, the  Koolau mountains, and a lovely park.
You can dine or or just relax while enjoying the stunning vistas.
AND there is a sweet courtyard (with a storage shed!) that two bedrooms open out onto - perfect for gardening or just relaxing.

2 convenient parking stalls # 2101- one in front of unit and one right across.
        )

    [ListOfficeName] => Array
        (
            [0] => Homequest LLC
        )

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

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

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

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

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

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

    [BuildingName] => Array
        (
            [0] => Yacht Club Terrace
        )

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 284-2043
        )

    [ListAgentFullName] => Array
        (
            [0] => Marisa Villalba
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-06-04T16:02:29.770
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-05-29T20:30:56.157
        )

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

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

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

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

    [listing_image] => Array
        (
            [0] => 26545655
            [1] => 26545656
            [2] => 26545657
            [3] => 26545658
            [4] => 26545659
            [5] => 26545660
            [6] => 26545661
            [7] => 26545662
            [8] => 26545663
            [9] => 26545664
            [10] => 26545665
            [11] => 26545666
            [12] => 26545667
            [13] => 26545668
            [14] => 26545669
            [15] => 26545670
            [16] => 26545671
            [17] => 26545672
            [18] => 26545673
            [19] => 26545674
            [20] => 26545675
            [21] => 26545676
            [22] => 26545677
            [23] => 26545678
        )

)

  • BedsTotal: 3
  • Full Baths: 2
  • Land Area (sf): 1,427,635
  • Living (sf): 1,810
  • Year Built: 1973
  • Building Name: Yacht Club Terrace

  • Property Condition: Excellent,Above Average
  • Number of Parking Spaces: 2
  • View: Mountain,Ocean,Other
  • Listing Office: Homequest LLC

  • Maintenance Fees: $838
  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

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