58-107 Mamao Street Haleiwa, HI 96712
Listing
Overview
Price: $1,350,000
Area: SUNSET/VELZY
Status: Active
Welcome Home to this spacious single level 3/2 home with huge fenced in gated yard and backyard. Located across the street from world famous Sunset Velzy beach in Oahu's Northshore! Island Style home with great open floor plan with front entry covered lanai, carport with driveway. Short distance to Elementary school, Ted’s Bakery, Bike paths, Shark’s Cove & Foodland. A 15 min drive down the road is Turtle Bay Resort with golf, beaches, activities & dining. There is a sewage treatment facility owned by the neighborhood association - so no cesspool. Located in the Sunset Terrace subdivision*This is a probate sale, subject to court confirmation**Please allow 72 hour notice for showings** Listing by: Oceans Realty Group (808) 864-1534
array(48) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202424505"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "58-107"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(5) "Mamao"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["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) "1350000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
NULL
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(12) "SUNSET/VELZY"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(698) "Welcome Home to this spacious single level 3/2 home with huge fenced in gated yard and backyard. Located across the street from world famous Sunset Velzy beach in Oahu's Northshore! Island Style home with great open floor plan with front entry covered lanai, carport with driveway. Short distance to Elementary school, Ted’s Bakery, Bike paths, Shark’s Cove & Foodland. A 15 min drive down the road is Turtle Bay Resort with golf, beaches, activities & dining. There is a sewage treatment facility owned by the neighborhood association - so no cesspool. Located in the Sunset Terrace subdivision*This is a probate sale, subject to court confirmation**Please allow 72 hour notice for showings**"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(19) "Oceans Realty Group"
}
["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) "5000.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1120"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1974"
}
["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) "One"
}
["View"]=>
array(1) {
[0]=>
string(15) "Garden,Mountain"
}
["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) "OCRG"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(34) "Michelle.lynch@oceansrealtygrp.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 864-1534"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(19) "Michelle Anne Lynch"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-01-06T14:29:13.703"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18341964"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
NULL
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
NULL
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26780826"
}
["listing_image"]=>
array(22) {
[0]=>
string(8) "26780826"
[1]=>
string(8) "26780827"
[2]=>
string(8) "26780828"
[3]=>
string(8) "26780829"
[4]=>
string(8) "26780830"
[5]=>
string(8) "26780831"
[6]=>
string(8) "26780832"
[7]=>
string(8) "26780833"
[8]=>
string(8) "26780834"
[9]=>
string(8) "26780835"
[10]=>
string(8) "26780836"
[11]=>
string(8) "26780837"
[12]=>
string(8) "26780838"
[13]=>
string(8) "26780839"
[14]=>
string(8) "26780840"
[15]=>
string(8) "26780841"
[16]=>
string(8) "26780842"
[17]=>
string(8) "26780843"
[18]=>
string(8) "26780844"
[19]=>
string(8) "26780845"
[20]=>
string(8) "26780846"
[21]=>
string(8) "26780847"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2024-11-22"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "14:29:13.703"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202424505
)
[StreetNumber] => Array
(
[0] => 58-107
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Mamao
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Haleiwa
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96712
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 1350000.00
)
[CurrentPrice] => Array
(
[0] =>
)
[Neighbourhood] => Array
(
[0] => SUNSET/VELZY
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Welcome Home to this spacious single level 3/2 home with huge fenced in gated yard and backyard. Located across the street from world famous Sunset Velzy beach in Oahu's Northshore! Island Style home with great open floor plan with front entry covered lanai, carport with driveway. Short distance to Elementary school, Ted’s Bakery, Bike paths, Shark’s Cove & Foodland. A 15 min drive down the road is Turtle Bay Resort with golf, beaches, activities & dining. There is a sewage treatment facility owned by the neighborhood association - so no cesspool. Located in the Sunset Terrace subdivision*This is a probate sale, subject to court confirmation**Please allow 72 hour notice for showings**
)
[ListOfficeName] => Array
(
[0] => Oceans Realty Group
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 5000.00
)
[SqftTotal] => Array
(
[0] => 1120
)
[YearBuilt] => Array
(
[0] => 1974
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 3
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Garden,Mountain
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => OCRG
)
[ListAgentEmail] => Array
(
[0] => Michelle.lynch@oceansrealtygrp.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 864-1534
)
[ListAgentFullName] => Array
(
[0] => Michelle Anne Lynch
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2025-01-06T14:29:13.703
)
[Matrix_Unique_ID] => Array
(
[0] => 18341964
)
[OriginalEntryTimestamp] => Array
(
[0] =>
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] =>
)
[_thumbnail_id] => Array
(
[0] => 26780826
)
[listing_image] => Array
(
[0] => 26780826
[1] => 26780827
[2] => 26780828
[3] => 26780829
[4] => 26780830
[5] => 26780831
[6] => 26780832
[7] => 26780833
[8] => 26780834
[9] => 26780835
[10] => 26780836
[11] => 26780837
[12] => 26780838
[13] => 26780839
[14] => 26780840
[15] => 26780841
[16] => 26780842
[17] => 26780843
[18] => 26780844
[19] => 26780845
[20] => 26780846
[21] => 26780847
)
[ListingContractDate] => Array
(
[0] => 2024-11-22
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 14:29:13.703
)
)
- BedsTotal: 3
- Full Baths: 2
- Land Area (sf): 5,000 sf
- Living (sf): 1,120
- Year Built: 1974
- Property Condition: Above Average
- Number of Parking Spaces: 3
- View: Garden,Mountain
- Listing Office: Oceans Realty Group
- Land Tenure: FS - Fee Simple
