61-1006 Tutu Place Haleiwa, HI 96712

Listing
Overview

Price: $2,175,000
Area: KAWAILOA-NORTH SHORE
Status: Active

BEAUTIFUL Ocean View Home on one of top lots in The Bluffs at Waimea, North Shore’s newest upscale sub-division! Custom Home, with Asian mahogany throughout! PANORAMIC OCEAN VIEW! SPACIOUS GREAT ROOM, GOURMET KITCHEN, LARGE CUSTOM SLIDING GLASS DOORS THROUGHOUT. Large decks for indoor outdoor entertaining. Huge primary bedroom with equally large front deck, walk-in closet and large primary bathroom. Separate open recreation room with its own bathroom. Large 2 car garage with extra space and separate storage. Steps away from beaches and close to Waimea Bay, Historic Haleiwa Town and Turtle Bay. Cool and quiet. Country living at its best! Listing by: Pacific Real Estate Institute (808) 778-6348

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202407547"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(7) "61-1006"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(4) "Tutu"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(5) "Place"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(7) "Haleiwa"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96712"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "2175000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "2175000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(20) "KAWAILOA-NORTH SHORE"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(655) "BEAUTIFUL Ocean View Home on one of top lots in The Bluffs at Waimea, North Shore’s newest upscale sub-division!  Custom Home, with Asian mahogany throughout!  PANORAMIC OCEAN VIEW!  SPACIOUS GREAT ROOM, GOURMET KITCHEN, LARGE CUSTOM SLIDING GLASS DOORS THROUGHOUT.  Large decks for indoor outdoor entertaining.  Huge primary bedroom with equally large front deck, walk-in closet and large primary bathroom.  Separate open recreation room with its own bathroom.  Large 2 car garage with extra space and separate storage.  Steps away from beaches and close to Waimea Bay, Historic Haleiwa Town and Turtle Bay.  Cool and quiet. Country living at its best!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(29) "Pacific Real Estate Institute"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "8427.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "3787"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "2016"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(9) "Excellent"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "Two"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(31) "Coastline,Mountain,Ocean,Sunset"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(7) "Haleiwa"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(7) "Waialua"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(7) "Waialua"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "LISH"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(36) "PacificRealEstateInstitute@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 778-6348"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(14) "Lishan Z Chong"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-04-06T11:08:59.670"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "17919768"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-04-06T08:22:17.147"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(11) "North Shore"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26155694"
  }
  ["listing_image"]=>
  array(13) {
    [0]=>
    string(8) "26155694"
    [1]=>
    string(8) "26155695"
    [2]=>
    string(8) "26155696"
    [3]=>
    string(8) "26155697"
    [4]=>
    string(8) "26155698"
    [5]=>
    string(8) "26155699"
    [6]=>
    string(8) "26155700"
    [7]=>
    string(8) "26155701"
    [8]=>
    string(8) "26155702"
    [9]=>
    string(8) "26155703"
    [10]=>
    string(8) "26155704"
    [11]=>
    string(8) "26155705"
    [12]=>
    string(8) "26155918"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202407547
        )

    [StreetNumber] => Array
        (
            [0] => 61-1006
        )

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

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

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

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

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

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

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

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

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

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

    [Neighbourhood] => Array
        (
            [0] => KAWAILOA-NORTH SHORE
        )

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

    [PublicRemarks] => Array
        (
            [0] => BEAUTIFUL Ocean View Home on one of top lots in The Bluffs at Waimea, North Shore’s newest upscale sub-division!  Custom Home, with Asian mahogany throughout!  PANORAMIC OCEAN VIEW!  SPACIOUS GREAT ROOM, GOURMET KITCHEN, LARGE CUSTOM SLIDING GLASS DOORS THROUGHOUT.  Large decks for indoor outdoor entertaining.  Huge primary bedroom with equally large front deck, walk-in closet and large primary bathroom.  Separate open recreation room with its own bathroom.  Large 2 car garage with extra space and separate storage.  Steps away from beaches and close to Waimea Bay, Historic Haleiwa Town and Turtle Bay.  Cool and quiet. Country living at its best!
        )

    [ListOfficeName] => Array
        (
            [0] => Pacific Real Estate Institute
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 778-6348
        )

    [ListAgentFullName] => Array
        (
            [0] => Lishan Z Chong
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-04-06T11:08:59.670
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-04-06T08:22:17.147
        )

    [MLSAreaMajor] => Array
        (
            [0] => North Shore
        )

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

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

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

    [listing_image] => Array
        (
            [0] => 26155694
            [1] => 26155695
            [2] => 26155696
            [3] => 26155697
            [4] => 26155698
            [5] => 26155699
            [6] => 26155700
            [7] => 26155701
            [8] => 26155702
            [9] => 26155703
            [10] => 26155704
            [11] => 26155705
            [12] => 26155918
        )

)

  • BedsTotal: 3
  • Full Baths: 4
  • Half Baths: 1
  • Land Area (sf): 8,427
  • Living (sf): 3,787
  • Year Built: 2016

  • Property Condition: Excellent
  • Number of Parking Spaces: 2
  • View: Coastline,Mountain,Ocean,Sunset
  • Listing Office: Pacific Real Estate Institute

  • Land Tenure: FS - Fee Simple

  • Elementary School: Haleiwa
  • Middle School: Waialua
  • High School: Waialua

CONTACT US

Marcus Realty

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