61-275 Kamehameha Highway Haleiwa, HI 96712

Listing
Overview

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

Take advantage of this unique opportunity for unobstructed panoramic sunset views & the sound of waves washing ashore, this rarely available location is a two-story oceanfront home located in Haleiwa along the Seven Mile Miracle stretch of shoreline with natural sandy beaches. Private beach access to the ocean area known as Alligator Rock. Improved utilities include a new 1500 Gal. septic upgrade completed 2023. Separate entrances into each living space; currently configured as a 3 bedroom and full bath upstairs and a 2 bedroom and full bath downstairs or as a large 5 bedroom 2 bath with featuring both up and downstairs having a full kitchen, living & dining space, washer and dryer, & a large oceanfront patio...interior door separates the upstairs from downstairs. Outdoor shower w/ hot & cold H2O is available to rinse off after enjoying water activities such as paddle boarding, surfing, and swimming. A rolling gate secures the property along Kamehameha Highway. Priced to sell AS IS; this home is ready for the right buyer and little TLC! Virtual Open Houses Available Upon Request w/ prior notice Listing by: TLC Realty LLC (808) 852-2555

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202411324"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "61-275"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(10) "Kamehameha"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(7) "Highway"
  }
  ["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) "2900000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "2900000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(20) "KAWAILOA-NORTH SHORE"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1120) "Take advantage of this unique opportunity for unobstructed panoramic sunset views & the sound of waves washing ashore, this rarely available location is a two-story oceanfront home located in Haleiwa along the Seven Mile Miracle stretch of shoreline with natural sandy beaches.  Private beach access to the ocean area known as Alligator Rock.  Improved utilities include a new 1500 Gal. septic upgrade completed 2023.  Separate entrances into each living space; currently configured as a 3 bedroom and full bath upstairs and a 2 bedroom and full bath downstairs or as a large 5 bedroom 2 bath with featuring both up and downstairs having a full kitchen, living & dining space, washer and dryer, & a large oceanfront patio...interior door separates the upstairs from downstairs.  Outdoor shower w/ hot & cold H2O is available to rinse off after enjoying water activities such as paddle boarding, surfing, and swimming.  A rolling gate secures the property along Kamehameha Highway.  Priced to sell AS IS; this home is ready for the right buyer and little TLC!

Virtual Open Houses Available Upon Request w/ prior notice"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(14) "TLC Realty LLC"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "5690.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "1936"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1966"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["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) "TLCT"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(20) "lailamryun@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 852-2555"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(10) "Laila Ryun"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-09-30T12:54:56.810"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18007870"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-05-15T12:58:35.870"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(11) "North Shore"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(28) "Ocean,Sandy Beach,Waterfront"
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26614135"
  }
  ["listing_image"]=>
  array(3) {
    [0]=>
    string(8) "26614135"
    [1]=>
    string(8) "26614136"
    [2]=>
    string(8) "26614137"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202411324
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Take advantage of this unique opportunity for unobstructed panoramic sunset views & the sound of waves washing ashore, this rarely available location is a two-story oceanfront home located in Haleiwa along the Seven Mile Miracle stretch of shoreline with natural sandy beaches.  Private beach access to the ocean area known as Alligator Rock.  Improved utilities include a new 1500 Gal. septic upgrade completed 2023.  Separate entrances into each living space; currently configured as a 3 bedroom and full bath upstairs and a 2 bedroom and full bath downstairs or as a large 5 bedroom 2 bath with featuring both up and downstairs having a full kitchen, living & dining space, washer and dryer, & a large oceanfront patio...interior door separates the upstairs from downstairs.  Outdoor shower w/ hot & cold H2O is available to rinse off after enjoying water activities such as paddle boarding, surfing, and swimming.  A rolling gate secures the property along Kamehameha Highway.  Priced to sell AS IS; this home is ready for the right buyer and little TLC!

Virtual Open Houses Available Upon Request w/ prior notice
        )

    [ListOfficeName] => Array
        (
            [0] => TLC Realty LLC
        )

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 852-2555
        )

    [ListAgentFullName] => Array
        (
            [0] => Laila Ryun
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-09-30T12:54:56.810
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-05-15T12:58:35.870
        )

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

    [PropertyFrontage] => Array
        (
            [0] => Ocean,Sandy Beach,Waterfront
        )

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

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

    [listing_image] => Array
        (
            [0] => 26614135
            [1] => 26614136
            [2] => 26614137
        )

)

  • BedsTotal: 5
  • Full Baths: 2
  • Land Area (sf): 5,690
  • Living (sf): 1,936
  • Year Built: 1966

  • Property Condition: Above Average
  • Number of Parking Spaces: 3
  • View: Coastline,Mountain,Ocean,Sunset
  • Listing Office: TLC Realty LLC

  • 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