Listing
Overview
Price: $2,395,000
Area: KUALOA AREA
Status: Active
Welcome to Sugar Mill Beach House, your gated oceanfront oasis! Stunning views abound! Inside you'll find a modern kitchen with all upgraded appliances, spacious living room, separate dining room with access to the wrap around lanai. Full bathroom downstairs with a side door that leads out to the backyard. Perfect for rinsing off after coming from the beach. All three bedrooms are upstairs. Primary bedroom with large closet has stunning views and opens up to the upstairs lanai. The second ocean view bedroom has lots of windows and access to the lanai. The third bedroom has built in bookshelves, lots of windows and light! Gorgeous fenced yard is perfect for entertaining with it own private entrance to the beach. This home also has a PV (photovoltaic) system NEM (Net Energy Metering program) to cut your electric bills, A/C units and an electric gate. Grab it fast! This is the Beach House you've been looking for! First showing is April 1st at 12:30 - 1pm.
3D virtual tour located in Agent Remarks Listing by: Avatina LLC (808) 772-0790
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202407121"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "49-643"
}
["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(6) "Kaaawa"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96730"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(62) "https://www.youtube.com/embed/-SYzu2nAz4A?si=RdpeQlfAJqX0YmjM""
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "2395000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "2395000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(11) "KUALOA AREA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1010) "Welcome to Sugar Mill Beach House, your gated oceanfront oasis! Stunning views abound! Inside you'll find a modern kitchen with all upgraded appliances, spacious living room, separate dining room with access to the wrap around lanai. Full bathroom downstairs with a side door that leads out to the backyard. Perfect for rinsing off after coming from the beach. All three bedrooms are upstairs. Primary bedroom with large closet has stunning views and opens up to the upstairs lanai. The second ocean view bedroom has lots of windows and access to the lanai. The third bedroom has built in bookshelves, lots of windows and light! Gorgeous fenced yard is perfect for entertaining with it own private entrance to the beach. This home also has a PV (photovoltaic) system NEM (Net Energy Metering program) to cut your electric bills, A/C units and an electric gate. Grab it fast! This is the Beach House you've been looking for! First showing is April 1st at 12:30 - 1pm.
3D virtual tour located in Agent Remarks"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(11) "Avatina 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(7) "5037.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1848"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1964"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(46) "Coastline,Garden,Mountain,Ocean,Sunrise,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["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) "AVAT"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(18) "thomas@avatina.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 772-0790"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(15) "Thomas E Wilson"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-04-28T15:42:42.180"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17908481"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-03-27T14:58:00.713"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(17) "Ocean,Sandy Beach"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26143941"
}
["listing_image"]=>
array(25) {
[0]=>
string(8) "26143941"
[1]=>
string(8) "26143942"
[2]=>
string(8) "26143943"
[3]=>
string(8) "26143944"
[4]=>
string(8) "26143945"
[5]=>
string(8) "26143946"
[6]=>
string(8) "26143947"
[7]=>
string(8) "26143948"
[8]=>
string(8) "26143949"
[9]=>
string(8) "26143950"
[10]=>
string(8) "26143951"
[11]=>
string(8) "26143952"
[12]=>
string(8) "26143953"
[13]=>
string(8) "26143954"
[14]=>
string(8) "26143955"
[15]=>
string(8) "26143956"
[16]=>
string(8) "26143957"
[17]=>
string(8) "26143958"
[18]=>
string(8) "26143959"
[19]=>
string(8) "26143960"
[20]=>
string(8) "26143961"
[21]=>
string(8) "26143962"
[22]=>
string(8) "26143963"
[23]=>
string(8) "26143964"
[24]=>
string(8) "26143965"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202407121
)
[StreetNumber] => Array
(
[0] => 49-643
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Kamehameha
)
[StreetSuffix] => Array
(
[0] => Highway
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Kaaawa
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96730
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://www.youtube.com/embed/-SYzu2nAz4A?si=RdpeQlfAJqX0YmjM"
)
[ListPrice] => Array
(
[0] => 2395000.00
)
[CurrentPrice] => Array
(
[0] => 2395000.00
)
[Neighbourhood] => Array
(
[0] => KUALOA AREA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Welcome to Sugar Mill Beach House, your gated oceanfront oasis! Stunning views abound! Inside you'll find a modern kitchen with all upgraded appliances, spacious living room, separate dining room with access to the wrap around lanai. Full bathroom downstairs with a side door that leads out to the backyard. Perfect for rinsing off after coming from the beach. All three bedrooms are upstairs. Primary bedroom with large closet has stunning views and opens up to the upstairs lanai. The second ocean view bedroom has lots of windows and access to the lanai. The third bedroom has built in bookshelves, lots of windows and light! Gorgeous fenced yard is perfect for entertaining with it own private entrance to the beach. This home also has a PV (photovoltaic) system NEM (Net Energy Metering program) to cut your electric bills, A/C units and an electric gate. Grab it fast! This is the Beach House you've been looking for! First showing is April 1st at 12:30 - 1pm.
3D virtual tour located in Agent Remarks
)
[ListOfficeName] => Array
(
[0] => Avatina LLC
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 5037.00
)
[SqftTotal] => Array
(
[0] => 1848
)
[YearBuilt] => Array
(
[0] => 1964
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Coastline,Garden,Mountain,Ocean,Sunrise,Sunset
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => AVAT
)
[ListAgentEmail] => Array
(
[0] => thomas@avatina.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 772-0790
)
[ListAgentFullName] => Array
(
[0] => Thomas E Wilson
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-04-28T15:42:42.180
)
[Matrix_Unique_ID] => Array
(
[0] => 17908481
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-03-27T14:58:00.713
)
[MLSAreaMajor] => Array
(
[0] => Kaneohe
)
[PropertyFrontage] => Array
(
[0] => Ocean,Sandy Beach
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26143941
)
[listing_image] => Array
(
[0] => 26143941
[1] => 26143942
[2] => 26143943
[3] => 26143944
[4] => 26143945
[5] => 26143946
[6] => 26143947
[7] => 26143948
[8] => 26143949
[9] => 26143950
[10] => 26143951
[11] => 26143952
[12] => 26143953
[13] => 26143954
[14] => 26143955
[15] => 26143956
[16] => 26143957
[17] => 26143958
[18] => 26143959
[19] => 26143960
[20] => 26143961
[21] => 26143962
[22] => 26143963
[23] => 26143964
[24] => 26143965
)
)
- BedsTotal: 3
- Full Baths: 2
- Land Area (sf): 5,037
- Living (sf): 1,848
- Year Built: 1964
- Property Condition: Above Average
- Number of Parking Spaces: 4
- View: Coastline,Garden,Mountain,Ocean,Sunrise,Sunset
- Listing Office: Avatina LLC
- Land Tenure: FS - Fee Simple
