Our office will be closed on Monday, November 11th, 2024.
58-260 Kamehameha Highway Haleiwa, HI 96712
Listing
Price: $1,150,000Area: SUNSET/VELZYStatus: Active
Now is your chance to secure the lowest priced home on the North Shore Haleiwa, steps away from Velzyland Surf Break and the Seven Mile Miracle! Rare opportunity, minutes away from Sunset Beach, Pipeline, Turtle Bay Resort and Haleiwa town. This island style 3 BR/1.5 BTH (en suite 1/2 BTH) House lives big with a smart layout. Remodeled inside/outside in 2023. Brand new roof and fence recently installed June 2024. Flood zone X (no required flood insurance), plenty of parking and room for a boat! Live, Rent, Remodel or Build!!! Listing by: Trinity Properties, LLC (808) 679-2442
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202421424"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "58-260"
}
["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) "1150000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1150000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(12) "SUNSET/VELZY"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(531) "Now is your chance to secure the lowest priced home on the North Shore Haleiwa, steps away from Velzyland Surf Break and the Seven Mile Miracle! Rare opportunity, minutes away from Sunset Beach, Pipeline, Turtle Bay Resort and Haleiwa town. This island style 3 BR/1.5 BTH (en suite 1/2 BTH) House lives big with a smart layout. Remodeled inside/outside in 2023. Brand new roof and fence recently installed June 2024. Flood zone X (no required flood insurance), plenty of parking and room for a boat! Live, Rent, Remodel or Build!!!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(23) "Trinity Properties, LLC"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "1"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "1"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "5132.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "792"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1974"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(7) "Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(4) "None"
}
["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) "TRIP"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(28) "steven@trinityproperties.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 679-2442"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(19) "Steven De Los Reyes"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-09-18T15:26:43.250"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18271637"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-09-18T15:26:43.250"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26700249"
}
["listing_image"]=>
array(12) {
[0]=>
string(8) "26700249"
[1]=>
string(8) "26700250"
[2]=>
string(8) "26700251"
[3]=>
string(8) "26700252"
[4]=>
string(8) "26700253"
[5]=>
string(8) "26700254"
[6]=>
string(8) "26700255"
[7]=>
string(8) "26700256"
[8]=>
string(8) "26700257"
[9]=>
string(8) "26700258"
[10]=>
string(8) "26700259"
[11]=>
string(8) "26700260"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202421424
)
[StreetNumber] => Array
(
[0] => 58-260
)
[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] => 1150000.00
)
[CurrentPrice] => Array
(
[0] => 1150000.00
)
[Neighbourhood] => Array
(
[0] => SUNSET/VELZY
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Now is your chance to secure the lowest priced home on the North Shore Haleiwa, steps away from Velzyland Surf Break and the Seven Mile Miracle! Rare opportunity, minutes away from Sunset Beach, Pipeline, Turtle Bay Resort and Haleiwa town. This island style 3 BR/1.5 BTH (en suite 1/2 BTH) House lives big with a smart layout. Remodeled inside/outside in 2023. Brand new roof and fence recently installed June 2024. Flood zone X (no required flood insurance), plenty of parking and room for a boat! Live, Rent, Remodel or Build!!!
)
[ListOfficeName] => Array
(
[0] => Trinity Properties, LLC
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 5132.00
)
[SqftTotal] => Array
(
[0] => 792
)
[YearBuilt] => Array
(
[0] => 1974
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Average
)
[ParkingTotal] => Array
(
[0] => 3
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => None
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => TRIP
)
[ListAgentEmail] => Array
(
[0] => steven@trinityproperties.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 679-2442
)
[ListAgentFullName] => Array
(
[0] => Steven De Los Reyes
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-09-18T15:26:43.250
)
[Matrix_Unique_ID] => Array
(
[0] => 18271637
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-09-18T15:26:43.250
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26700249
)
[listing_image] => Array
(
[0] => 26700249
[1] => 26700250
[2] => 26700251
[3] => 26700252
[4] => 26700253
[5] => 26700254
[6] => 26700255
[7] => 26700256
[8] => 26700257
[9] => 26700258
[10] => 26700259
[11] => 26700260
)
)
BedsTotal: 3Full Baths: 1Half Baths: 1Land Area (sf): 5,132Living (sf): 792Year Built: 1974
Property Condition: AverageNumber of Parking Spaces: 3View: NoneListing Office: Trinity Properties, LLC
Land Tenure: FS - Fee Simple
