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
View
  • 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


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

 

Detailed Interior Descriptions


Amenities
  • Patio/Deck
  • Storage

Flooring
  • Ceramic Tile
  • Hardwood

Floor Number: 2
Stories Type
  • Two

Inclusions
  • 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:
TMKPLAT:
Zoning:
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

Tools

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 187 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