Marker Icon 20.pngMarker Icon 12.pngMarker Icon 17.pngMarker Icon 24.pngMarker Icon 15.pngMarker Icon 6.pngMarker Icon 4.pngMarker Icon center.pngMarker Icon 13.pngMarker Icon 7.pngMarker Icon 10.pngMarker Icon 14.pngMarker Icon 11.pngMarker Icon shadow.pngMarker Icon 9.pngMarker Icon 3.pngMarker Icon 21.pngMarker Icon 2.pngMarker Icon 8.pngMarker Icon 1.pngMarker Icon 18.pngMarker Icon 5.pngMarker Icon 22.pngMarker Icon 19.pngMarker Icon 25.pngMarker Icon 0.pngMarker Icon 23.pngMarker Icon 16.png

Welcome to CENTURY 21 Realty Specialists. Call Us at +1 (808) 949-6322

59-043 Huelo Street PRKG, Haleiwa, HI 96712 -- MLS# 201719222

Listing Courtesy Of

List Office Name: REMAX Sunset Homes

Get the Flash Player to see this rotator.

Listing Detailed Information

Street Number: 59-043
Street Name: Huelo
Street Suffix: Street
City: Haleiwa
State: HI
ZipCode: 96712
Region: North Shore
Unit Number: PRKG
Island: Oahu
Year Built: 1985
MLS Number: 201719222
List Price: $1,250,000
Beds Total: 3
Baths Full: 2
Baths Total: 2.01
Baths Half: 1
Sqft Total: 2,118
Lot Size Area: 27966
Property Type: Condo/Townhouse
Status: In Escrow Showing
Days on Market: 168


Property Descriptions

Public Remarks: Beautiful and completely remodeled beachside home at popular Sunset Point! This is is very much like a single family residence except for the association as there are no adjoining walls! First floor bedrooms (third actually a den), two baths plus wet bar and laundry room. Stunning views from the second floor and huge entertain area with kitchen and dining area that flows to the covered lanai also with extra dining and powder bath. This is where most will congregate with the gorgeous ocean views and sunsets. There are two very large storage rooms which add an additional 312 sq.ft. to the 1848 sq. ft. of living space. New solar water heater. Furnishings are negotiable. Disclosure: Use of the 6 car garage underneath the house is for the other 6 condos and not the subject property!!
Property Condition
  • Excellent

Property Frontage
  • Ocean
  • Sandy Beach

Building Name: Sunset Beach Vista
  • Ocean
  • Sunset

Unit Features
  • Bedroom on 1st Level
  • Full Bath on 1st Floor
  • Multi Level
  • Storage
  • Yard

Street View Param: 1$21.677705$-158.03828399999998$347.06$13.33$1.00$iTSuCpRWc9tJTlQ2YxD6Gw
Furnished: Negotiable



Neighborhood: SUNSET AREA
Elementary School: Sunset Beach
Middle Or Junior School: Kahuku
High School: Kahuku


Detailed Interior Descriptions

  • Patio/Deck
  • Storage

  • Ceramic Tile
  • Hardwood

Floor Number: 2
Stories Type
  • Two

  • AC Split
  • Blinds
  • Cable TV
  • Ceiling Fan
  • Dishwasher
  • Disposal
  • Dryer
  • Microwave
  • Range/Oven
  • Refrigerator
  • Security System
  • Smoke Detector
  • Washer


Detailed Exterior Descriptions

SQFT Lanai Open: 270
SQFT Roofed Living: 1,848
Architectural Style
  • Detach Single Family
  • No Unit Above or Below

Condo Parking Unit: 2
Parking Total: 2
Parking Features
  • Assigned
  • Open - 2

Parking Additional: 1


Other Detailed Descriptions

Please login to see the detailed information below. If you do not have a login, please register for a free membership.

Member's Benefit! Below are some of the examples of the detailed information.

Current Price:
Original List Price:
Maintenance Expense:
Management Company Name:
Management Company Phone:
Active Open House Count:
Association Fee 2:
Association Fee Total:
Association Fee:
Construction Materials:
Foreclosure YN:
Land Recorded:
Land Tenure:
Open House Count:
Owner Occupancy Percentage:
Parcel Number:
Special Listing Conditions:
Sub Agency Compensation:
Tax Amount:
Tax Assessed Value Improvements:
Tax Assessed Value Land:
Tax Assessed Value:
Tax Excemption Owner Occupancy:
Tax Year:
TMK Area:
TMK Condo Property Regime Number:
TMK Division:
TMK Parcel:
TMK Section:
TMK Zone:
Modification Timestamp:
Original Entry Timestamp:
Listing Contract Date:
Status Change Timestamp:
Foreclosure YN: 0

Recommend Property On

Agent Info

Contact Agent
Office No: (808) 949-6322

Fax No: (808) 943-1668


Mortgage Calculator
Printer Friendly Version of This Page
Email This Listing to a Friend

Neighborhood Links

View a map of the area
School Profile
Neighborhood Profile

Google Map of the Listing

Sorry, Unable to map the location

Agent Information

HiCentral MLS Listings
Office No: (808) 949-6322

Fax No: (808) 943-1668

Send Email to Agent

Items marked * are required
* In Reference to Listing #62077

CAPTCHA ImageAudio Version
Reload Image

The information provided by this website is for the personal, non-commercial use of consumers and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, and that the data is deemed reliable but is not guaranteed accurate by the MLS..

Some of the active listings appearing on this site may be listed by other REALTORS®.
If you are interested in those active listings, CENTURY 21 Realty Specialists may represent you as the buyer's agent. If the active listing you are interested in is our company's active listing, you may speak to one of our agents regarding your options for representation.

Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
Listings last updated on .
Information is deemed reliable but not guaranteed.
Copyright: by HiCentral MLS, Ltd.

This listing has been viewed 90 times.

View Our Listings


Join our membership for Free!

Looking for a new home or Selling your home? Become A Member For Free!

Registered user benefits include:

  • My Favorites
    You get to save your favorite properties and share them by sending your listings to a friend.
  • My Searches
    Save your searches and simply login to your account to run your search!
  • View Additional Property Details
    Get to know the property better by viewing the additional details on the property.
  • Daily Listing Email Alerts!
    Get the properties you want delivered directly to your email! We utilize your Saved Search criteria and deliver only new listings to your email address. So Sign Up!
Registration is fast and free!. Register Here for Free!

Search for Homes

Search for Homes 
Search Zip:
Price Range:   To:
Beds:   Baths
  Advanced Search