• Welcome to AppraisersForum.com, the premier online  community for the discussion of real estate appraisal. Register a free account to be able to post and unlock additional forums and features.

MLS Comparables' Marketing Comments into ACI?

Status
Not open for further replies.
----
Pardon the expression, but HOLY ****. I'm unaware of the full functionality of the MLS Export feature, but if it can create a document like yours, exporting multiple properties simultaneously, I'm a gonna double-down. [BTW per ACI technical support on numerous occasions, the ACI Spillover addendum is not meant to receive files/documents/charts/etc, which must be copy/pasted/exported into an image addendum. For example, just about every time I used to copy/pasts Excel tables, often to reflect mini vacant land analyses, the program would crash. Literally sevearl different ACI tech reps advised me never to download or copy/past anything into the Spilleverf. BUT THANK YOU FOR THE IDEA.

The example above is an excel export that I formatted into a table. I can then drag the cursor around it and copy it and paste it into word. That image can be pasted into an exhibit addendum. Or copied into a word document which gets copied and pasted into a comment addendum in the report.

The raw export looks like this...

1588968810558.png
 
The example above is an excel export that I formatted into a table. I can then drag the cursor around it and copy it and paste it into word. That image can be pasted into an exhibit addendum. Or copied into a word document which gets copied and pasted into a comment addendum in the report.

The raw export looks like this...

View attachment 46045
---

I somewhat pride myself on the quality of my product, but I would be able to complete about 1 assignment a week if my due diligence and reporting were as comprehensive as yours!!!!!
 
---

I somewhat pride myself on the quality of my product, but I would be able to complete about 1 assignment a week if my due diligence and reporting were as comprehensive as yours!!!!!

I ate a lot of my fee doing these things a long time ago. But after some practice it doesn't take all that much longer. Besides, I work a rural area and it's often difficult to get a handle on the market and the comps and explain it to a lender type client. It's why I charge more than typical. But I still leave money on the table. A good friend told me I'm not charging enough. Trying to fix that and still get jobs.
 
A good friend told me I'm not charging enough. Trying to fix that and still get jobs.
Always the double edged sword in the appraisal (or any business) world.
Charge enough to make $$$ on each one, but not too much to lose each one
 
I realize that the OP is trying to be as competent and explanatory as possible...but...this is just overkill unless you have a unique product. The lender doesn’t give a hoot about that much detail. Been there. The reviewer simply wants a summary. He doesn’t want to know if the home overlooks a particular city. What the reviewer wants is to know that the subject has a typical view, while Comp 1 is on a hillside with a superior view, market shows X.
 
The example above is an excel export that I formatted into a table. I can then drag the cursor around it and copy it and paste it into word. That image can be pasted into an exhibit addendum. Or copied into a word document which gets copied and pasted into a comment addendum in the report.

The raw export looks like this...

View attachment 46045
----------------------
Preliminary research reveals that your protocol provides the type of data I sought, based upon the following:

Select necessary comps in the MLS 1-line format.
MLS "Export" Function into Excel where a 150-point row height and a 100-point column width easily accommodates text for 6 -- 9 MLS marketing descriptions, after applying the Excel Wrap Text function.
Delete hundreds of unnecessary colums;
Format font, borders, etc.
Copy/paste into an ACU Extra Image page.

Only challenge I encounter is that the addresses aren't imported into Excel so it's necessary to scroll back and forth between Excel and ACI to ensure that the sequence of properties in the addendum corresponds the SCA grid, requiring the addresses to be added manually into a new column#1..

Sure couldn't find a MLS tutorial on the Export function; and GREATLY APPRECIATE YOUR INSIGHT!!!!!!!!!!!!!!!
 
I realize that the OP is trying to be as competent and explanatory as possible...but...this is just overkill unless you have a unique product. The lender doesn’t give a hoot about that much detail. Been there. The reviewer simply wants a summary. He doesn’t want to know if the home overlooks a particular city. What the reviewer wants is to know that the subject has a typical view, while Comp 1 is on a hillside with a superior view, market shows X.
-------------

Your perspective pobably is true, but somewhere . . . somewhere . . . a "requirement" exists to describe each comparable; and doing so by copy/pasting seems more reasonable than to manually paraphrase the MLS marketing comments. I did, however, recently consolidate my Market Analysis, saving more than 1 hour per report.
 
I realize that the OP is trying to be as competent and explanatory as possible...but...this is just overkill unless you have a unique product. The lender doesn’t give a hoot about that much detail. Been there. The reviewer simply wants a summary. He doesn’t want to know if the home overlooks a particular city. What the reviewer wants is to know that the subject has a typical view, while Comp 1 is on a hillside with a superior view, market shows X.

I don't do that on every report. In fact, only a few of the more complex assignments. It also depends on the client and especially a fussy intended user... like HUD.
 
-------------

Your perspective pobably is true, but somewhere . . . somewhere . . . a "requirement" exists to describe each comparable; and doing so by copy/pasting seems more reasonable than to manually paraphrase the MLS marketing comments. I did, however, recently consolidate my Market Analysis, saving more than 1 hour per report.

Sometimes I do just that. Copy and paste the public comments from MLS

Comparable Sale 1 76919 Tabor Ln This is a good comparable sale and very recent. 1.28 acre lot with a modest single-family residence and garage. Includes an exterior building remodeled to serve as a third bedroom. Public comments: “1 acre, zoned RR1. This is a great starter home, fix and flip or rental investment property. This is a 2 bedroom 1 bath with an outside building that has been remodeled as a 3rd bedroom. There is an additional shed and a garage as well. There is plenty of room for animals, gardening or both!” No adjustments needed for this sale. Private financing, 33 days on market. Adjusted MV indication of $205,000 which is at the lower end of the range of indications.

Comparable 2 24521 Biggar Ln 5-acre rural site with a larger, but similar quality and age farmhouse or cabin. Three bedrooms and two baths, Some updates to the kitchen appliances. Accessory unit is an older mobile home. Public Comments: “5 acre lot with 3 bedroom 2 bath home plus office of Master Suite. Can apply for county permits. New Stainless Steel stove and double door refrigerator Has train container with electricity, newer well pump, and mobile home on lot. Also has small barn, Chicken coop and apple orchard. Good zone for a 5,000 sq ft farm. Private location and flat land. Zoned RR10. Gas heater in LR.” Adjustments for lager site as described above; additional full bathroom, GLA as described above, no garage. No adjustment for the variance in ADU amenity. Conventional financing, 226 days on market, 19% gross adjustments with a MV indication of $229,000 which is bracketed.

Comparable 3 22420 Henderson Relatively (for Covelo) recent sale. 10-acres with a small cabin in fair condition. Allows bracketing of most elements of comparison. The lot is level and has good utility for cannabis cultivation. Public comments: “Zoned RR10. Peaceful artist cabin located on 10 full acres. The cabin is cozy, clean and has a homey feel to it. This property has good water, hoop houses, full sun and is very private. Part of the property is wooded with the cabin nestled in among the trees overlooking the lovely meadows below.” Lot adjustment reflects market reaction to both lot size and prior history of cultivation. Condition adjustment for lack of recent updates and deferred exterior maintenance. Seller financing, 84 days on market, 35% gross adjustments, MV indication of $235,000 which represents the higher range of MV indications.

Comparable 4 22868 Biggar Ln This was a pending sale on the effective date of this appraisal. The transaction closed about a week later. Last list price was $339,000 and sale closed at $313,500. I have made an adjustment for the difference in list versus sale price and rounded to account for suspected seller credit. The MLS listing states no concessions but the final sale price appears to be random and the financing terms were FHA so I suspect there was a concessions for closing costs which are typically around 3% for an FHA loan. There are only two or three real estate agents who serve this market and they typically don't provide concessions data. Public listing comments: “This home was built to last and has everything needed to be your family home! Wonderful location with all the amenities including a huge yard with above ground pool, large shade trees, and over an acre of room to run and play. Includes a wonderful garden area and a wide variety of well established fruit trees. Private man cave with it's own bathroom. This is the perfect family/entertainment home. Also has end of the road privacy!” The “man cave” with bathroom is a framed in section in a breeze way between the residence and the garage. No significant contributory value. 1.29-acre site, located across the street from the subject. Estimate GLA at about 1,600 sf (aerial view measurements), super condition with more recent updating. Three bedrooms and two baths. The yard is well maintained and attractive. FHA financing, 157 days on market, 25% gross adjustments, MV indication of $254,000.
 
I guess my question is what is the value of quoting the marketing remarks of a comp in the addendum? I have the listing, but see no need to regurgitate the entire thing into a report. In fact, I balk at anyone wanting the MLS printout...join the MLS if you want it.

"A place in the country with recent updates and manicured lawn..." DOM 478 There is a lawnmower burned up in the back yard so I guess that is why the lawn "manicure" isn't so good now."
DSCN2998 (Medium).JPG
 
Status
Not open for further replies.
Find a Real Estate Appraiser - Enter Zip Code

Copyright © 2000-, AppraisersForum.com, All Rights Reserved
AppraisersForum.com is proudly hosted by the folks at
AppraiserSites.com
Back
Top