Featured Homes


 ----- Information herein deemed reliable but not guaranteed. -----

Copyright:  2010 by HiCentral MLS, Ltd.  Tue, Aug 10, 2010 11:47 AM

Single Family
ML#: 1004511 Active   List: $599,000* FS - Fee Simple
TMK: 1-3-1-007-088-0000
Addr: 3354 Esther St
City: Honolulu HI Zip: 96816
Regn: DiamondHd Neighborhood: KAPAHULU

Roofd Liv Ar: 900 New Dev/Const: No Bedrms: 3
Roofd Oth Ar: Yr Built: 1960 Baths: 1 / 0
Opn Lanai Ar: Remod Yr: Furnished: Partial

Garage SF:   Mon Maint Fees: $
Land SF: 2,250 Fractional: No Mon Assn Fees: $
Acres: 0.052 Flood: X Other Mon Fees: $
Zoning: 07 - R-3.5 Residential District Mon Rental Inc: $ Total Mon Fees: $0

Assd Val Land: $406,000 Tax Year: 2010 Elem School: Liholiho
Assd Val Imprv: $66,100 Mon Taxes: $158 Middle School: Kaimuki
Assd Val Total: $472,100 Home Exemp: 0 High School: Kalani
Community Assn: Community Assn #: CPR: No   Public Rpt #:

BACK ON MARKET 7/29! Fabulous location with great cross ventilation and views of Diamond Head to Waikiki. Not a CPR. Perfect for first time home Buyer! Open living area with spacious bedrooms huge storage area under home and two covered parking. Recently tented. Sold 'As Is'. Actual sq ft may differ from tax records.

View
     Coastline
     Diamond Head
     Mountain
     Ocean
     Sunset
Lot Description
     Other
Predominant Topography
     Level
Location
     Inside
Number of Stories
     Two
Building Style
     Detached
Property Condition
     Above Average
Parking
     2Car
     Carport
     Street
Construction/Exterior Finish
     Above Ground
     Single Wall
Roofing
     Composition
Pool
     None
Amenities
     Storage
Additional Rooms
     None
Floor Covering
     W/W Carpet
Inclusions
     Ceiling Fan
     Disposal
     Range/Oven
     Refrigerator
     Smoke Detector
Security
     Key
Easements
     Other
Set-Backs
     C&C
Disclosures
     Property Disclosure Stmt
Other Fee Includes
     None
Utilities Included
     Cable
     Connected
     Public Water
     Telephone
Roads
     County
Possession
     45 or Less
     At Closing
Occupancy
     Vacant
Terms Acceptable
     Cash
     Conventional
Land Recorded
     Land Court
Showing
     Appointment Only
     Call Listor
     Listor Must Be Present
 
LO: Prudential Advantage Realty LD: 4/6/2010 DOM: 127

Single Family
ML#: 1008863 Active   List: $1,450,000 FS - Fee Simple
TMK: 1-4-3-069-004-0000
Addr: 55 S Kalaheo Ave
City: Kailua HI Zip: 96734
Regn: Kailua Neighborhood: KUULEI TRACT

Roofd Liv Ar: 3,145 New Dev/Const: No Bedrms: 4
Roofd Oth Ar: 220 Yr Built: 1985 Baths: 3 / 1
Opn Lanai Ar: Remod Yr: 2010 Furnished: Partial

Garage SF: 323   Mon Maint Fees: $
Land SF: 14,475 Fractional: No Mon Assn Fees: $
Acres: 0.332 Flood: X Other Mon Fees: $
Zoning: 03 - R10 - Residential District Mon Rental Inc: $ Total Mon Fees: $0

Assd Val Land: $961,200 Tax Year: 2009 Elem School: Kailua
Assd Val Imprv: $349,800 Mon Taxes: $347 Middle School: Kailua
Assd Val Total: $1,311,000 Home Exemp: 80000 High School: Kalaheo
Community Assn: Community Assn #: CPR: No   Public Rpt #:

Rare offering! Elegantly remodeled, custom residence on a prime, completely level 14,475 sqft estate. Access to world famous Kailua Beach is across the street, w/ shopping & dining just a short bike ride away. This private 3bd/2.5ba main residence w/ 1bd/1ba maid's qtrs offers casual, yet sophisticated, Hawaiian style living. Move-in cond. w/ gorgeous oak flrs, silestone counters, new appliances.

View
     Mountain
     Other
Lot Description
     Clear
Predominant Topography
     Level
Location
     Other
Number of Stories
     Two
Building Style
     1 Bedroom Cottage
     Detached
Property Condition
     Excellent
Parking
     2Car
     Carport
Construction/Exterior Finish
     DoubleWall
     Slab
     Wood Frame
Roofing
     Asphalt Shingle
Pool
     None
Amenities
     Bedoom on 1st Floor
     Full Bath on 1st Floor
     Landscaped
     Maids/Guest Qrters
     Storage
     Wall/Fence
     Workshop
Additional Rooms
     Dining Room
     Eat In Kitchen/Nook
     Enclosed Lanai
     Family Room
     Laundry Room
     Other
Floor Covering
     Hardwood
     Vinyl
     W/W Carpet
Inclusions
     AC Window Unit
     Book Shelves
     Cable TV
     Ceiling Fan
     Disposal
     Dryer
     Range Hood
     Range/Oven
     Refrigerator
     Smoke Detector
     Solar Heater
     Washer
Security
     Key
Easements
     None
Set-Backs
     C&C
Disclosures
     Property Disclosure Stmt
Other Fee Includes
     None
Utilities Included
     Cable
     Internet Cable
     Public Water
     Telephone
     Underground Electricity
Roads
     Paved
Possession
     45 or Less
     At Closing
Occupancy
     Owner
Terms Acceptable
     Cash
     Conventional
Land Recorded
     Land Court
Showing
     Appointment Only
     Call Listor
     Listor Must Be Present
 
LO: Prudential Advantage Realty LD: 7/7/2010 DOM: 35

Single Family
ML#: 1010013 Active   List: $595,000 FS - Fee Simple
TMK: 1-9-5-068-046-0000
Addr: 95210 Ulahea Pl
City: Mililani HI Zip: 96789
Regn: Central Neighborhood: MILILANI MAUKA

Roofd Liv Ar: 1,584 New Dev/Const: No Bedrms: 3
Roofd Oth Ar: Yr Built: 1998 Baths: 2 / 1
Opn Lanai Ar: Remod Yr: Furnished: Partial

Garage SF: 400   Mon Maint Fees: $
Land SF: 4,700 Fractional: No Mon Assn Fees: $34
Acres: 0.108 Flood: D Other Mon Fees: $
Zoning: 05 - R-5 Residential District Mon Rental Inc: $ Total Mon Fees: $34

Assd Val Land: $366,400 Tax Year: 2009 Elem School: Mililani Ike
Assd Val Imprv: $235,700 Mon Taxes: $149 Middle School: Mililani
Assd Val Total: $602,100 Home Exemp: 80000 High School: Mililani
Community Assn: MTA Community Assn #: CPR: No   Public Rpt #:

**NOT a Short Sale** BEAUTIFULLY maintained 3 bdrm 2.5 bth home on a 4,700 sq ft level lot. Located on a quiet cul-de-sac, this home boasts new paint, gorgeous wood laminate flrs, fully fenced, great for kids & pets! Top rated school district too!

View
     None
Lot Description
     Other
Predominant Topography
     Level
Location
     Other
Number of Stories
     Two
Building Style
     Detached
Property Condition
     Above Average
Parking
     2Car
     Driveway
     Garage
     Street
Construction/Exterior Finish
     Slab
     Steel Frame
Roofing
     Asphalt Shingle
Pool
     None
Additional Rooms
     Dining Area
     Dining Room
Floor Covering
     Ceramic Tile
     Laminate
     W/W Carpet
Inclusions
     AC Window Unit
     Auto Garage Door Opener
     Cable TV
     Dishwasher
     Disposal
     Dryer
     Refrigerator
     Smoke Detector
     Washer
Security
     Key
Exclusions
     Window Coverings
Easements
     Other
Set-Backs
     C&C
Disclosures
     Property Disclosure Stmt
Other Fee Includes
     Association
Utilities Included
     Cable
     Connected
     Internet Cable
     Public Water
     Telephone
     Underground Electricity
Roads
     Paved
Possession
     45 or Less
Occupancy
     Tenant
Terms Acceptable
     Cash
     Conventional
     FHA
     VA
Land Recorded
     Land Court
Showing
     Appointment Only
     Call Listor
     One Day Notice Reqd
 
LO: Prudential Advantage Realty LD: 7/30/2010 DOM: 12

Condo/Townhouse
ML#: 1008932 Active   List: $318,000 FS - Fee Simple
TMK: 1-2-4-019-014-0013 Sub-Type: Condo PR#: 1067
Bldg: Makiki Plaza Mstr: 500098
Addr: 1561 Pensacola St 602
City: Honolulu HI Zip: 96822
Regn: Metro Neighborhood: MAKIKI AREA

Inter Liv Ar: 715 New Dev/Const: No Bedrms: 1
Open Lanai: Yr Built: 1980 Baths: 1 / 0
Land SqFt: 34,472 Conversn Yr: Land Acres: 0.749
Total Area: 715 Remod Yr: Furnished:

#Pk: 1 Fractional: No Developer: Mon Maint: $515
Stall#s: 90 Flood Zone: X Model Open Days:  
Floor: 6 Mon Rental Inc: $ Model Site Contact: Mon Assn: $
Elevators: 2 Site Contact Ph#: Other Mon Fees: $
  Total Mon Fees: $515

Assd Val Land: $37,600 Tax Year: 2009 Elem School: Lincoln
Assd Val Imprv: $283,500 Mon Taxes: $92 Middle School: Stevenson
Assd Val Total: $321,100 Home Exemp: 0 High School: Roosevelt
Community Assn: Ph#:  
Management Co: Certified Mgmt Ph#: 836-0911  

LO: Prudential Advantage Realty LD: 7/8/2010 DOM: 34

Spacious, clean & very well maintained 1bd/1ba/1cvrd pkg, conveniently located in lower Makiki. Washer/dryer in the unit, great Resident Mngr, guest pkg, sparkling pool, sauna and rec. deck. Perfect for Owner Occupants or Investors. Lending will be a breeze with this building at an impeccable 54% owner occupancy as of 7/8/10!

View
     City
     Coastline
     Ocean
     Sunset
Building Style
     High-Rise 7+ Stories
Unit Features
     Even# Unit
     Single Level
Property Condition
     Above Avg
Parking
     Assigned
     Covered1
     Guest
Construction/Exterior Finish
     Concrete
Property Frontage
     Other
Amenities
     Patio/Deck
     Pool
     Recreation Area
     Resident Manager
     Sauna
     Trash Chute
Maintenance Fee Includes
     Cable TV
     Electricity
     Hot Water
     Sewer
     Water
Additional Rooms
     Dining Area
     Eat In Kitchen/Nook
Inclusions
     Auto Garage Door Opener
     Dishwasher
     Disposal
     Dryer
     Range Hood
     Range/Oven
     Refrigerator
     Smoke Detector
     Washer
Security
     Card
     Key
Disclosures
     Property Disclosure Stmt
Other Fee Includes
     None
Floor Covering
     Vinyl
     W/W Carpet
Possession
     45 Days or Less
Occupancy
     Owner
Terms Acceptable
     Cash
     Conventional
Land Recorded
     Regular System
Showing
     Appointment Only
     Listor Must Be Present
 

Condo/Townhouse
ML#: 1008807 Sold   List: $375,000
Sold: $386,000
FS - Fee Simple
TMK: 1-4-2-001-048-0161 Sub-Type: Condo PR#: 720
Bldg: Poinciana Manor Mstr: 500443
Addr: 1015 Aoloa Pl 439
City: Kailua HI Zip: 96734
Regn: Kailua Neighborhood: KAILUA TOWN

Inter Liv Ar: 944 New Dev/Const: No Bedrms: 2
Open Lanai: 82 Yr Built: 1975 Baths: 2 / 0
Land SqFt: 220,764 Conversn Yr: Land Acres: 4.799
Total Area: 1026 Remod Yr: Furnished:

#Pk: 2 Fractional: No Developer: Mon Maint: $595
Stall#s: 208, 210 Flood Zone: X Model Open Days:  
Floor: 4 Mon Rental Inc: $ Model Site Contact: Mon Assn: $
Elevators: 3 Site Contact Ph#: Other Mon Fees: $
  Total Mon Fees: $595

Assd Val Land: $128,200 Tax Year: 2009 Elem School: Kailua
Assd Val Imprv: $305,300 Mon Taxes: $101 Middle School: Kailua
Assd Val Total: $433,500 Home Exemp: 80000 High School: Kalaheo
Community Assn: Ph#:  
Management Co: Touchstone Ph#: 566-4100  

LO: Prudential Advantage Realty LD: 7/6/2010 DOM: 5

2bd/2ba/2cov.pkg in Kailua Town. A short walk to shopping, dining & world famous Kailua Beach. Gorgeous remodel incl custom maple cabinets w/pull-outs, new paint, solid surface counters, custom shelving, Pella sliding patio doors w/interior blinds & Pella windows. The high vaulted ceilings give this unit dramatic depth & space, a perfect setting for this tasteful remodel. Owner Occ. 58% on 7/6.

View
     Garden
     Mountain
     Sunrise
Building Style
     Townhouse
Unit Features
     Bedroom on 1st Level
     Full Bath on 1st Floor
     Odd# Unit
     Single Level
     Storage
Property Condition
     Excellent
Parking
     Assigned
     Covered2
     Guest
Construction/Exterior Finish
     Wood Frame
Amenities
     BBQ
     Club House
     Pool
     Recreation Area
     Resident Manager
     Security Guard
     Storage
     Trash Chute
     Walking/Jogging Path
Maintenance Fee Includes
     Sewer
     Water
Additional Rooms
     Dining Area
     Open Lanai
Inclusions
     Book Shelves
     Cable TV
     CeilingFan
     Convection Oven
     Dishwasher
     Disposal
     Drapes
     Dryer
     Microwave Oven Hood
     Refrigerator
     Smoke Detector
     Washer
Security
     Key
     Security Patrol
     Video
Exclusions
     Other
Disclosures
     Property Disclosure Stmt
Other Fee Includes
     Maintenance
Floor Covering
     Ceramic Tile
     W/W Carpet
Possession
     At Closing
Occupancy
     Owner
Terms Acceptable
     Cash
     Conventional
     FHA
     VA
Land Recorded
     Regular System
Showing
     Appointment Only
     Call Listor
 

Contract Date: 7/10/2010 Closed Date: 7/30/2010 DOM: 5 Sold: $386,000
Fee Purchase:  Concessions:  


 ----- Information herein deemed reliable but not guaranteed. -----

Copyright:  2010 by HiCentral MLS, Ltd.  Tue, Aug 10, 2010 11:47 AM



Allan & Soomi Crooks
Prudential Advantage Realty
3465 Waialae Avenue #210, Honolulu, HI 96816
Phone: 808-222-1656