Understanding MLS info in my blog…..

Aloha,

Recently, I was asked how to read the information contained within my weekly update and thought it would be more helpful to post the answer on my blog for everyone’s benefit. MLS information is taken directly from the Hawaii Information System which is the entity that bring us our MLS. (Multiple Listing Service) Here is the Island update for Tuesday, March 17th:

Copyright 3/18/2009 by Hawaii Information Service

NEW LISTINGS

MLS # Tp St DOM Taxkey Tnr Price Location Land area Details
191493 T A 1 4-2-8-19-4-28 FS $698,000 Poipu Shores #B101 630 #B101 1/1.5
222144 T A 1 4-2-8-17-26-136 LH $750,000 Kiahuna Ph Ii #165 620 #165 1/1
222193 T A 1 4-3-7-1-17-85 LH $215,000 Sun Village-kauai #B401 747 #B401 2/1
215411 LN A 1 4-2-3-24-7 FS $295,000 Kakela Makai Dr 14,229 sqft
222041 LN A 1 4-2-8-31-97 FS $525,000 Poipu Beach Estates Lot #:97 15,007 sqft
222276 RS A 1 4-4-2-17-44 FS $385,000 295 Molo St 8,155 sqft 1,026 3/2
222146 RC A 1 4-4-6-22-3-9001 FS $375,000 5026 Laipo Rd 4,906 sqft 835 2/2
222147 RC A 1 4-4-6-22-3-9002 FS $425,000 5026 Laipo Rd 5,095 sqft 1,274 3/2
222321 RC A 1 4-5-2-23-10-1 FS $529,000 2567 Titcomb St #A 4,248 sqft 1,052 3/2
222312 RS A 1 4-5-3-11-32 FS $1,450,000 4066 Aloalii Dr 13,511 sqft 2,784 3/2.5
221534 RS A 1 4-5-4-13-48 FS $899,000 3677 Keoniana Rd 11,432 sqft 2,066 3/2.5

BACK ON THE MARKET

MLS # Tp St DOM Taxkey Tnr Price Location Land area Details
220195 T A 57 4-2-8-17-26-130 LH $650,000 Kiahuna Ph Ii #159 620 #159 1/1

CONTINGENT SALES

MLS # Tp St DOM Taxkey Tnr Price Location Land area Details
220522 RS C 49 4-2-4-4-54-2 FS $678,900 5027-A Puuwai Rd #B 18,949 sqft 2,101 3/4

SALES

MLS # Tp St DOM Taxkey Tnr Price Location Land area Details
218298 B S 113 4-5-5-10-1 LH $60,000 Hanalei 7,501 sqft
SOLD 3/16/2009 for $35,000 (CASH) DOM 113

207576 LN S 105 4-2-8-9-901 FS $235,000 Koloa Town Lot #:B-1 10,065 sqft
SOLD 3/1/2009 for $210,000 (CASH) DOM 105

UNDER CONTRACT

EXPIRED

MLS # Tp St DOM Taxkey Tnr Price Location Land area Details
208842 T X 364 4-3-2-5-8-134 FS $350,000 Banyan Harbor #134 920 #K/134 2/1.5
210587 LC X 314 4-5-2-5-35-4 FS $3,950,000 Kauapea Rd #4 9.36 ac
205051 RC X 456 4-5-2-17-22-6 FS $695,000 05-2821 Kuhio Hwy #F 2.71 ac 716 1/0.5

WITHDRAWN

TEMPORARILY WITHDRAWN

PRICE CHANGES

MLS # Tp St DOM Taxkey Tnr Price Location Land area Details
221838 T A 128 4-2-8-20-3-54 FS $338,000- Makahuena #IIC104 1,145 #IIC104 2/2
220195 T A 57 4-2-8-17-26-130 LH $650,000- Kiahuna Ph Ii #159 620 #159 1/1
211776 T A 242 4-2-8-19-22-13 FS $749,000- Nihi Kai Villas #402 1,221 #402 2/2
207723 T A 387 4-2-8-27-17-58 FS $775,000- Manualoha Ph I & Ii #1006 1,412 #1006 2/2
220956 T A 21 4-2-8-15-3-39 FS $825,000- Poipu Kapili #39 1,170 #39 1/2
216467 T A 161 4-3-3-3-29-8 FS $245,888- Halelani Village At Puhi Ph Ib #M204 750 #M204 2/1.5
219417 T A 79 4-3-3-3-36-1 FS $361,000- Hookena At Puhi #101 1,398 #101 3/2.5
209244 T A 352 4-5-3-6-22-63 FS $894,000- Kaiulani Of Princeville #63 1,901 #63 2/2.5
221121 T A 34 4-5-4-5-3-3 FS $239,900- Princeville Paniolo #103 1,058 #103 1/2
220078 T A 54 4-5-4-5-3-19 FS $279,000- Princeville Paniolo #204 1,058 #204 1/2
210669 SH A 322 4-5-8-11-27-24 FS $200,000- Hanalei Colony Resort #F3 850 #F3 2/2
220795 LN A 42 4-1-8-14-66 FS $299,000- 3647 Uwao St 12,633 sqft
220647 LN A 46 4-2-3-8-60 FS $595,000- Hawea Estates Lot #:3 2.60 ac
220645 LN A 46 4-2-3-8-60 FS $595,000- Hawea Estates Lot #:3 3.40 ac
218152 LN A 120 4-2-8-31-111 FS $375,000- Poipu Beach Estates Lot #:111 13,064 sqft
218183 LN A 120 4-2-8-31-127 FS $375,000- Poipu Beach Estates Lot #:127 12,998 sqft
218184 LN A 120 4-2-8-31-128 FS $375,000- Poipu Beach Estates Lot #:128 13,657 sqft
218187 LN A 120 4-2-8-31-162 FS $375,000- Poipu Beach Estates Lot #:162 12,800 sqft
218211 LN A 120 4-2-8-31-167 FS $375,000- Poipu Beach Estates Lot #:167 12,072 sqft
210190 LN A 156 4-3-3-17-58 FS $379,000- Kauila St 13,704 sqft
199693 RS A 586 4-2-6-13-50 FS $450,000- 3280 Hailima Rd 8,140 sqft 1,240 3/2
219581 RS A 71 4-3-8-13-19 FS $565,000- 5032 Paka Dr 10,911 sqft 1,169 3/2.5
214547 RS A 218 4-4-1-4-33 FS $1,699,000- 4617 Anolani St 11,771 sqft 2,057 4/3
211656 RS A 300 4-4-2-16-56 FS $726,000- 5825 Haaheo St 11,571 sqft 1,662 3/2
219200 RS A 90 4-4-2-15-78 FS $749,000- 273 Aina Pua Pl 22,694 sqft 1,710 3/3
221589 RC A 20 4-4-5-2-3-2 FS $844,000- 1127-C Moanakai Rd #2 10,123 sqft 904 3/1
219295 RS A 79 4-5-2-15-60 FS $450,000- 4230 Waipua St 6,000 sqft 1,638 3/2
216585 RS A 166 4-5-2-9-29 FS $695,000- Kolo Rd 17,598 sqft 2,820 5/3.5
213870 RS A 237 4-5-4-6-12 FS $598,000- 4154 Lei O Papa Rd 11,369 sqft 1,544 2/2
219148 RS A 92 4-5-4-15-16 FS $644,900- 3834 Haulani Pl 11,020 sqft 2,048 3/3
220705 RS A 44 4-5-4-19-19 FS $859,900- 5086 Napo’okala Cir 15,326 sqft 2,206 3/3

This information has been supplied by third parties and has not been independently verified by Hawaii Information Service and is, therefore, not guaranteed.

As you can see, there’s quite a bit of activity on a daily basis. (All the more reason to have a real estate agent on your side helping you keep up with everything.) But let me explain the data — the first number is the MLS number. The second item tells what kind of property it is: RS and RC for residential single family homes, T for condos, LN and LC for vacant land, B for Business, C is commercial and SH is for fractional or shared interests in property.

Next is the Status which is either A – active, C – contingent (the property owner received an acceptable offer and escrow was opened) U – the property is in escrow with no remaining contingencies, S – Sold, X – Expired, W – Withdrawn and T – Temporarily Withdrawn. Do not confuse the “T” under property type (Tp) which indicates a condo with the status (St) change of T for temporarily withdrawn.

Moving right along, the number following the status is the days on the market or DOM. This number stops progressing when the property goes into escrow. Next up is the tax map key (TMK) commonly called a taxkey number, which is like a social security number for each piece of real estate in Hawaii. The tax key number is a unique property indentifier and tells you where the property is located. All property on Kauai starts with “4″ the next number is the the zone of which there are 5 : 1 is Waimea, 2 Koloa, 3 Lihue, 4 Kawaihau, and 5 for Hanalei. The mere fact that a property has a 5 for the second digit does not necessarily mean it is in Hanalei proper but that it is in the Hanalei Zone. The third number designates a section of the zone. The next two numbers are plat and parcel. If the land has been further divided it will have a 6th number to indicate which unit it is. If the house is built on “divided” land it too will have a 6 number TMK. For a more detailed describtion of the TMK click here to go to my website to learn more. If you understand the TMK system, just by looking at the TMK you’ll have a general idea of the property location.

After the TMK is the land tenure which is either FS for Fee simple (you own land along with improvements on the land) or LH for Leasehold. (You only own the improvements and pay a fee, usually monthly, like rent, for the land.) List price is next, then the property location. You’ll see an address for single family residence and the name of the complex along with the unit number for condos. Land may have a project number or just an address depending on the parcel.

The final bit of information is a brief property description. If the listing is a condo, you’ll see the square footage of the unit, followed by the unit number then the number of bedrooms and baths. For a single family residence, the first number is the lot square footage, followed by the house square footage and bedrooms / baths. Land just has the lot square footage or acreage.

That about covers it. Let me know if there are any more questions out there.

Aloha Elaine

This is a great spot along Ka Haku Rd. in Princeville where you can just sit and enjoy. This is almost across the street from my Hale Moi listing discussed in a prior posting.

Elaine Schaefer (R, CRS, GRI, ABR)
Broker in Charge – Princeville Resort Office
Certified Residential Specialist
Graduate, Realtor’s Institute
Accredited Buyer’s Representative
Top Producer 100% Club

RE/MAX Kauai
Princeville Resort Office
POB 223632
Princeville, HI 96722
cell: 808 639 2935
home fax: 1 808 440 4552
email:soldonkauai@yahoo.com
website: www.kauairealestatenow.com
blog: www.blogs.alohaliving.com/princeville-condo-sales

……you can have your own piece of paradise
ask me how!

March 18th, 2009