Listing
Overview
Price: $968,000
Area: WHITMORE VILLAGE
Status: Active
PRICE IMPROVEMENT and 15K SELLER CREDIT FOR 2/1 BUYDOWN! This beautifully renovated two-story home serves as your gateway to the world-famous North Shore beaches and surf spots in Oahu. Immerse yourself in the allure of this upgraded property, featuring an open-concept kitchen with top-notch appliances and granite countertops and pristine white bathrooms with a soothing contemporary feel. The main level boasts of a balcony with breathtaking mountain views. Has luxurious vinyl laminate flooring, energy-efficient vinyl windows, new ceiling fans, and a lower-level laundry area with room for appliances. With separate entrances for each level, this versatile home is perfect for extended family living or as income-generating rental opportunity. Spacious backyard offers ample parking, storage, space for outdoor gatherings, and has a raised garden bed for your favorite flowers and vegetables. This corner lot home offers a tranquil island lifestyle, while minutes away from restaurants, Wheeler Army, Schofield Barracks, and North Shore beaches. Don't miss out on the opportunity to make this your dream home in paradise. Listing by: Compass (808) 321-6465
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202318886"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(3) "502"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(7) "Lalawai"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["City"]=>
array(1) {
[0]=>
string(7) "Wahiawa"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96786"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(51) "https://my.matterport.com/show/?m=Dcucs4CADEA&mls=1"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "968000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "968000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(16) "WHITMORE VILLAGE"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1126) "PRICE IMPROVEMENT and 15K SELLER CREDIT FOR 2/1 BUYDOWN! This beautifully renovated two-story home serves as your gateway to the world-famous North Shore beaches and surf spots in Oahu. Immerse yourself in the allure of this upgraded property, featuring an open-concept kitchen with top-notch appliances and granite countertops and pristine white bathrooms with a soothing contemporary feel. The main level boasts of a balcony with breathtaking mountain views. Has luxurious vinyl laminate flooring, energy-efficient vinyl windows, new ceiling fans, and a lower-level laundry area with room for appliances. With separate entrances for each level, this versatile home is perfect for extended family living or as income-generating rental opportunity. Spacious backyard offers ample parking, storage, space for outdoor gatherings, and has a raised garden bed for your favorite flowers and vegetables. This corner lot home offers a tranquil island lifestyle, while minutes away from restaurants, Wheeler Army, Schofield Barracks, and North Shore beaches. Don't miss out on the opportunity to make this your dream home in paradise."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(7) "Compass"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "6"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "6040.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1760"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1970"
}
["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(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) "COHI"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(24) "alma.eustace@compass.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 321-6465"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(12) "Alma Eustace"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2023-11-05T17:00:02.060"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17491450"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2023-09-11T05:14:45.563"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Central"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "25950818"
}
["listing_image"]=>
array(25) {
[0]=>
string(8) "25950818"
[1]=>
string(8) "25950819"
[2]=>
string(8) "25950820"
[3]=>
string(8) "25950821"
[4]=>
string(8) "25950822"
[5]=>
string(8) "25950823"
[6]=>
string(8) "25950824"
[7]=>
string(8) "25950825"
[8]=>
string(8) "25950826"
[9]=>
string(8) "25950827"
[10]=>
string(8) "25950828"
[11]=>
string(8) "25950829"
[12]=>
string(8) "25950830"
[13]=>
string(8) "25950831"
[14]=>
string(8) "25950832"
[15]=>
string(8) "25950833"
[16]=>
string(8) "25950834"
[17]=>
string(8) "25950835"
[18]=>
string(8) "25950836"
[19]=>
string(8) "25950837"
[20]=>
string(8) "25950838"
[21]=>
string(8) "25950839"
[22]=>
string(8) "25950840"
[23]=>
string(8) "25950841"
[24]=>
string(8) "25950842"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202318886
)
[StreetNumber] => Array
(
[0] => 502
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Lalawai
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Wahiawa
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96786
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://my.matterport.com/show/?m=Dcucs4CADEA&mls=1
)
[ListPrice] => Array
(
[0] => 968000.00
)
[CurrentPrice] => Array
(
[0] => 968000.00
)
[Neighbourhood] => Array
(
[0] => WHITMORE VILLAGE
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => PRICE IMPROVEMENT and 15K SELLER CREDIT FOR 2/1 BUYDOWN! This beautifully renovated two-story home serves as your gateway to the world-famous North Shore beaches and surf spots in Oahu. Immerse yourself in the allure of this upgraded property, featuring an open-concept kitchen with top-notch appliances and granite countertops and pristine white bathrooms with a soothing contemporary feel. The main level boasts of a balcony with breathtaking mountain views. Has luxurious vinyl laminate flooring, energy-efficient vinyl windows, new ceiling fans, and a lower-level laundry area with room for appliances. With separate entrances for each level, this versatile home is perfect for extended family living or as income-generating rental opportunity. Spacious backyard offers ample parking, storage, space for outdoor gatherings, and has a raised garden bed for your favorite flowers and vegetables. This corner lot home offers a tranquil island lifestyle, while minutes away from restaurants, Wheeler Army, Schofield Barracks, and North Shore beaches. Don't miss out on the opportunity to make this your dream home in paradise.
)
[ListOfficeName] => Array
(
[0] => Compass
)
[BedsTotal] => Array
(
[0] => 6
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 6040.00
)
[SqftTotal] => Array
(
[0] => 1760
)
[YearBuilt] => Array
(
[0] => 1970
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => Two
)
[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] => COHI
)
[ListAgentEmail] => Array
(
[0] => alma.eustace@compass.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 321-6465
)
[ListAgentFullName] => Array
(
[0] => Alma Eustace
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2023-11-05T17:00:02.060
)
[Matrix_Unique_ID] => Array
(
[0] => 17491450
)
[OriginalEntryTimestamp] => Array
(
[0] => 2023-09-11T05:14:45.563
)
[MLSAreaMajor] => Array
(
[0] => Central
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 25950818
)
[listing_image] => Array
(
[0] => 25950818
[1] => 25950819
[2] => 25950820
[3] => 25950821
[4] => 25950822
[5] => 25950823
[6] => 25950824
[7] => 25950825
[8] => 25950826
[9] => 25950827
[10] => 25950828
[11] => 25950829
[12] => 25950830
[13] => 25950831
[14] => 25950832
[15] => 25950833
[16] => 25950834
[17] => 25950835
[18] => 25950836
[19] => 25950837
[20] => 25950838
[21] => 25950839
[22] => 25950840
[23] => 25950841
[24] => 25950842
)
)
- BedsTotal: 6
- Full Baths: 2
- Land Area (sf): 6,040
- Living (sf): 1,760
- Year Built: 1970
- Property Condition: Above Average
- Number of Parking Spaces: 4
- View: Garden,Mountain
- Listing Office: Compass
- Land Tenure: FS - Fee Simple
