Kaneohe, HI 96744

Listing
Overview

Price: $795,000
Area: COUNTRY CLUB
Status: Active

Immaculate, Gorgeous, Remodeled END unit. Single Level. Bright and Breezy. No popcorn ceiling. Remodeled top to bottom in 2021, including new electrical panel. Quality, Well Designed, Open kitchen. Vaulted ceilings. Walk In closet in the Primary bedroom. Green lawns and flowering trees wrap around this home, just like a house. Enclosed front yard for BBQing, plants, kids and pets. Guest stalls conveniently located right in front of this unit. Club house and pool too. Well managed, preferred project. VA Ok. Listing by: Locations LLC (808) 306-0430

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202325834"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(15) "Condo/Townhouse"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["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) "795000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(9) "795000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(12) "COUNTRY CLUB"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(513) "Immaculate, Gorgeous, Remodeled END unit. Single Level. Bright and Breezy. No popcorn ceiling. Remodeled top to bottom in 2021, including new electrical panel.  Quality, Well Designed, Open kitchen. Vaulted ceilings. Walk In closet in the Primary bedroom.  Green lawns and flowering trees wrap around this home, just like a house. Enclosed front yard for BBQing, plants, kids and pets. Guest stalls conveniently located right in front of this unit. Club house and pool too. Well managed, preferred project. VA Ok."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(13) "Locations LLC"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "1497"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1973"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(18) "Yacht Club Terrace"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(9) "Excellent"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(6) "Garden"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "643.97"
  }
  ["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) "LOCA"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(31) "bernie.tong@locationshawaii.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 306-0430"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(11) "Bernie Tong"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2023-11-20T16:27:11.660"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "17685987"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2023-11-20T16:27:11.660"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(7) "Kaneohe"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26029652"
  }
  ["listing_image"]=>
  array(18) {
    [0]=>
    string(8) "26029652"
    [1]=>
    string(8) "26029653"
    [2]=>
    string(8) "26029654"
    [3]=>
    string(8) "26029655"
    [4]=>
    string(8) "26029656"
    [5]=>
    string(8) "26029657"
    [6]=>
    string(8) "26029658"
    [7]=>
    string(8) "26029659"
    [8]=>
    string(8) "26029660"
    [9]=>
    string(8) "26029661"
    [10]=>
    string(8) "26029662"
    [11]=>
    string(8) "26029663"
    [12]=>
    string(8) "26029664"
    [13]=>
    string(8) "26029665"
    [14]=>
    string(8) "26029666"
    [15]=>
    string(8) "26029667"
    [16]=>
    string(8) "26029668"
    [17]=>
    string(8) "26029669"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202325834
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Immaculate, Gorgeous, Remodeled END unit. Single Level. Bright and Breezy. No popcorn ceiling. Remodeled top to bottom in 2021, including new electrical panel.  Quality, Well Designed, Open kitchen. Vaulted ceilings. Walk In closet in the Primary bedroom.  Green lawns and flowering trees wrap around this home, just like a house. Enclosed front yard for BBQing, plants, kids and pets. Guest stalls conveniently located right in front of this unit. Club house and pool too. Well managed, preferred project. VA Ok.
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => bernie.tong@locationshawaii.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 306-0430
        )

    [ListAgentFullName] => Array
        (
            [0] => Bernie Tong
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2023-11-20T16:27:11.660
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2023-11-20T16:27:11.660
        )

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

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

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

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

    [listing_image] => Array
        (
            [0] => 26029652
            [1] => 26029653
            [2] => 26029654
            [3] => 26029655
            [4] => 26029656
            [5] => 26029657
            [6] => 26029658
            [7] => 26029659
            [8] => 26029660
            [9] => 26029661
            [10] => 26029662
            [11] => 26029663
            [12] => 26029664
            [13] => 26029665
            [14] => 26029666
            [15] => 26029667
            [16] => 26029668
            [17] => 26029669
        )

)

  • BedsTotal: 2
  • Full Baths: 1
  • Living (sf): 1,497
  • Year Built: 1973
  • Building Name: Yacht Club Terrace

  • Property Condition: Excellent
  • Number of Parking Spaces: 2
  • View: Garden
  • Listing Office: Locations LLC

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

CONTACT US

Marcus Realty

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