58-107 Mamao Street Haleiwa, HI 96712
Listing
Overview
Price: $1,400,000
Area: SUNSET/VELZY
Status: Active
*No showings until first Open House this Sunday 11/24/24 2:00PM-5:00PM* Welcome Home to this spacious single level remodeled 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 with Sunset Towers Homeowners Assn. *This is a probate sale, subject to court confirmation* Listing by: Oceans Realty Group (808) 864-1534
array(45) {
["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) "1400000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1400000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(12) "SUNSET/VELZY"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(774) "*No showings until first Open House this Sunday 11/24/24 2:00PM-5:00PM* Welcome Home to this spacious single level remodeled 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 with Sunset Towers Homeowners Assn. *This is a probate sale, subject to court confirmation*"
}
["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) "2024-11-22T16:00:00.980"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18341964"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-11-18T09:33:00.540"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(7) "Probate"
}
["_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"
}
}
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] => 1400000.00
)
[CurrentPrice] => Array
(
[0] => 1400000.00
)
[Neighbourhood] => Array
(
[0] => SUNSET/VELZY
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => *No showings until first Open House this Sunday 11/24/24 2:00PM-5:00PM* Welcome Home to this spacious single level remodeled 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 with Sunset Towers Homeowners Assn. *This is a probate sale, subject to court confirmation*
)
[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] => 2024-11-22T16:00:00.980
)
[Matrix_Unique_ID] => Array
(
[0] => 18341964
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-11-18T09:33:00.540
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => Probate
)
[_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
)
)
- BedsTotal: 3
- Full Baths: 2
- Land Area (sf): 5,000
- 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
