Listing
Overview
Price: $1,895,000
Area: SUNSET/VELZY
Status: Active
Nestled at the end of a quiet cul-de-sac, this meticulously maintained home stands as a testament to 23 years of love and care from its dedicated owners. A grand vaulted ceiling, adorned with custom ohia posts, sets the tone for the spacious and inviting open concept living, dining, and kitchen area. Rich and exotic Cumaru (Brazilian teak) flooring adds a touch of elegance and warmth, enhancing the overall aesthetic of the home. A converted carport offers a versatile separate living space, ideal for accommodating multigenerational living or generating additional rental income. Enveloping the home in a serene oasis is a beautiful and well established landscape that adds privacy and charm. With two outdoor showers available for rinsing off after the beach, convenience and practicality are top of mind, reflecting a lifestyle centered around outdoor living and recreation. Situated in the heart of a legendary surfing mecca, on the 7 mile miracle of Oahu’s fabled North Shore. Hop on the bike path and in mere minutes discover world class surfing spots, like Sunset Point, V-land, and Rockys. For shopping, dining, and entertainment, Haleiwa town and Turtle Bay are just a short drive away. Listing by: Corcoran Pacific Properties (808) 589-2040
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202415106"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "58-015"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(5) "Maika"
}
["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(54) "https://shoots.styronphoto.com/sites/qaxpqmb/unbranded"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1895000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1895000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(12) "SUNSET/VELZY"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1200) "Nestled at the end of a quiet cul-de-sac, this meticulously maintained home stands as a testament to 23 years of love and care from its dedicated owners. A grand vaulted ceiling, adorned with custom ohia posts, sets the tone for the spacious and inviting open concept living, dining, and kitchen area. Rich and exotic Cumaru (Brazilian teak) flooring adds a touch of elegance and warmth, enhancing the overall aesthetic of the home. A converted carport offers a versatile separate living space, ideal for accommodating multigenerational living or generating additional rental income. Enveloping the home in a serene oasis is a beautiful and well established landscape that adds privacy and charm. With two outdoor showers available for rinsing off after the beach, convenience and practicality are top of mind, reflecting a lifestyle centered around outdoor living and recreation. Situated in the heart of a legendary surfing mecca, on the 7 mile miracle of Oahu’s fabled North Shore. Hop on the bike path and in mere minutes discover world class surfing spots, like Sunset Point, V-land, and Rockys. For shopping, dining, and entertainment, Haleiwa town and Turtle Bay are just a short drive away."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(27) "Corcoran Pacific Properties"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "5"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "1"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "5003.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "2060"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1985"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(6) "Garden"
}
["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) "ELIT"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(34) "stephen.cipres@corcoranpacific.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 589-2040"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(16) "Stephen A Cipres"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-08-18T17:00:01.927"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18100230"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-06-28T13:50:30.300"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(25) "Subject To Repl. Property"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26603188"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26603188"
[1]=>
string(8) "26603189"
[2]=>
string(8) "26603190"
[3]=>
string(8) "26603191"
[4]=>
string(8) "26603192"
[5]=>
string(8) "26603193"
[6]=>
string(8) "26603194"
[7]=>
string(8) "26603195"
[8]=>
string(8) "26603196"
[9]=>
string(8) "26603197"
[10]=>
string(8) "26603198"
[11]=>
string(8) "26603199"
[12]=>
string(8) "26603200"
[13]=>
string(8) "26603201"
[14]=>
string(8) "26603202"
[15]=>
string(8) "26603203"
[16]=>
string(8) "26603204"
[17]=>
string(8) "26603205"
[18]=>
string(8) "26603206"
[19]=>
string(8) "26603207"
[20]=>
string(8) "26603208"
[21]=>
string(8) "26603209"
[22]=>
string(8) "26603210"
[23]=>
string(8) "26603211"
[24]=>
string(8) "26603212"
[25]=>
string(8) "26603213"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202415106
)
[StreetNumber] => Array
(
[0] => 58-015
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Maika
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Haleiwa
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96712
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://shoots.styronphoto.com/sites/qaxpqmb/unbranded
)
[ListPrice] => Array
(
[0] => 1895000.00
)
[CurrentPrice] => Array
(
[0] => 1895000.00
)
[Neighbourhood] => Array
(
[0] => SUNSET/VELZY
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Nestled at the end of a quiet cul-de-sac, this meticulously maintained home stands as a testament to 23 years of love and care from its dedicated owners. A grand vaulted ceiling, adorned with custom ohia posts, sets the tone for the spacious and inviting open concept living, dining, and kitchen area. Rich and exotic Cumaru (Brazilian teak) flooring adds a touch of elegance and warmth, enhancing the overall aesthetic of the home. A converted carport offers a versatile separate living space, ideal for accommodating multigenerational living or generating additional rental income. Enveloping the home in a serene oasis is a beautiful and well established landscape that adds privacy and charm. With two outdoor showers available for rinsing off after the beach, convenience and practicality are top of mind, reflecting a lifestyle centered around outdoor living and recreation. Situated in the heart of a legendary surfing mecca, on the 7 mile miracle of Oahu’s fabled North Shore. Hop on the bike path and in mere minutes discover world class surfing spots, like Sunset Point, V-land, and Rockys. For shopping, dining, and entertainment, Haleiwa town and Turtle Bay are just a short drive away.
)
[ListOfficeName] => Array
(
[0] => Corcoran Pacific Properties
)
[BedsTotal] => Array
(
[0] => 5
)
[BathsFull] => Array
(
[0] => 3
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 5003.00
)
[SqftTotal] => Array
(
[0] => 2060
)
[YearBuilt] => Array
(
[0] => 1985
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 3
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Garden
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => ELIT
)
[ListAgentEmail] => Array
(
[0] => stephen.cipres@corcoranpacific.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 589-2040
)
[ListAgentFullName] => Array
(
[0] => Stephen A Cipres
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-08-18T17:00:01.927
)
[Matrix_Unique_ID] => Array
(
[0] => 18100230
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-06-28T13:50:30.300
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] => Subject To Repl. Property
)
[_thumbnail_id] => Array
(
[0] => 26603188
)
[listing_image] => Array
(
[0] => 26603188
[1] => 26603189
[2] => 26603190
[3] => 26603191
[4] => 26603192
[5] => 26603193
[6] => 26603194
[7] => 26603195
[8] => 26603196
[9] => 26603197
[10] => 26603198
[11] => 26603199
[12] => 26603200
[13] => 26603201
[14] => 26603202
[15] => 26603203
[16] => 26603204
[17] => 26603205
[18] => 26603206
[19] => 26603207
[20] => 26603208
[21] => 26603209
[22] => 26603210
[23] => 26603211
[24] => 26603212
[25] => 26603213
)
)
- BedsTotal: 5
- Full Baths: 3
- Half Baths: 1
- Land Area (sf): 5,003
- Living (sf): 2,060
- Year Built: 1985
- Property Condition: Excellent
- Number of Parking Spaces: 3
- View: Garden
- Listing Office: Corcoran Pacific Properties
- Land Tenure: FS - Fee Simple
