Home > Blogs > Karen Kruschka > Manassas Woodbridge,,Dumfries, Bristow and Prince William County Real Estate Service

Simple, Effective Hyper-Local Market Reports in 10 MINUTES

By Karen Kruschka

Real Estate Agent with RE/MAX Executives

November 03, 2010 02:27 AM

Each January I run the prior year sales units and dollars for each of the 30 subdivisions for which I regulary update hyper-local posts. The numbers are then entered into an editable market report and saved. They are not JPEG photos with text or number distortion

Lake RidgeWoodbridge VA Town Home Market Report

Homes Sold and Settled
Year-To-Date 2010 Vs. Total Year 2009

	2009	2010	+/- %
Number of Homes	234	0	0
Average List Price	141,413	0	0
Average Sales Price	142,150	0	0
Seller Contribution	-3,135	0	0
Net Sales Price	139,015	0	0

As of 1/1/2010

Since I post 10 hyper-local subdivision market reports each Monday

I query the MLS for a CMA with YTD stats from 1/1/2010,
enter the most recent numbers and calculate the percentages.
the report is saved and inserted in my community hyper-local post

The report below shows how it will look for each subdividion every three weeks since I report on 30 subdivisions. Each of the updates and insertions take 10 minutes per report from start to finish

Lake Ridge
Woodbridge VA
Town Home Market Report

Homes Sold and Settled
Year-To-Date 2010 Vs. Total Year 2009

	2009	2010	+/- %
Number of Homes	234	46
Average List Price	141,413	178,238	+26%
Average Sales Price	142,150	180,807	+27%
Seller Contribution	-3,135	-3,024	-4%
Net Sales Price	139,015	177,783	+28%

As of 4/27/2010

KEEPING GOOGLE HAPPY WITH ALL OF THIS

Since an updated market report may not be enough to maintain Google Page 1 positioning I make slight modifications to the hyper-local post and add a different insert each month.

The insert is stored and requires minimal editing to be relevant for each of the 30 subdivisions.. This is my most recent one

"Lake Ridge town home prices posted a substantial increase over full year 2009 as of November 1, 2010. It is higher than the overall average sold price increase of 18% percent throughout Woodbridge, all of Prince William County and most certainly is a major improvement over the price declines of recent years. The higher price increase for all of Prince William County is reflective of the fact that lower priced town homes have rebounded significantly

Interest rates are currently at record low levels. It would appear now may be the best time to consider a town home purchase in Lake Ridge while home prices are still considerably below the market norm."

TO CONCLUDE

In my opinion, modular hyper-local posts with the addition of editable market reports and modifying insertions are

Effective
Easy to develop
Reader friendly

Every aspect of my hyper-local posts (commuting, schools, shopping and recreation) is modular and can be easily moved or removed. It can be seen at Lake Ridge Woodbridge Market Report

Others like Renee Burrows prefer graphs for their market reports. Her market report graphs are actually lovely and the source of many well deserved compliments - that just doesn't happen to be my style.

Each Monday morning my husband runs the stats on our MLS and performs every other aspect of it in less than two hours. That provides the time for us to do tutorials and other posts that are of interest to us.

++++++++++++++++++++++++++++++++++++++++++++++++++

My Team has 34 years experience in Woodbridge, Dumfries, Manassas, Bristow, Gainesville, Haymarket Prince William County

”Experience Isn’t Expensive – It’s PRICELESS”
If you plan to buy or sell a Lake Ridge, Woodbridge or other Prince William County home or property contact Karen and Art by Email or call us at 703-690-6569. Put our record of customer service, real estate experience and state-of-the-art technology to work for you in Alexandria, Arlington County, Fairfax County, Prince William County, Stafford County or the entire Northern Virginia Area.

Prince William County

Karen Kruschka's Web Site

Re-Blog

Comments(26)

Comment

Show All Comments

Sort:

John Novak

Keller Williams Realty The Marketplace - Las Vegas, NV

Henderson, Las Vegas and Summerlin Real Estate

Most of my consumer contact comes from market reports. Many will follow the numbers for months before calling or emailing. To make it easy and consistent for them (and me), a template approach works best.

Nov 03, 2010 12:24 PM

Rebecca Gaujot, Realtor®

Lewisburg, WV

Lewisburg WV, the go to agent for all real estate

Karen, just two hours to run the stats on the MLS and do the reports....awesome. I need to think of a new approach, thanks!

Nov 03, 2010 02:39 PM

Jim Frimmer

HomeSmart Realty West - San Diego, CA

Realtor & CDPE, Mission Valley specialist

I’m still trying to get something good for my 39 condominium communities. The report that the MLS creates looks like garbage.

Nov 03, 2010 03:57 PM

Pat Haddad, ABR, CRS, ePRO, GRI

Keller Williams Indianapolis Metro NE - Carmel, IN

Carmel, Fishers, Westfield IN Real Estate Expert

Karen---I appreciate this simple and easy for the consumer to understand format. I am embarrassed to say that I have not consistently been doing these market reports. Maybe you have now given me the tools I need to get started. I have suggested your post!

Nov 03, 2010 04:26 PM

Bill Gassett

RE/MAX Executive Realty - Hopkinton, MA

Metrowest Massachusetts Real Estate

There is no question that market reports get a lot of views. People are always interested in what is going on in their market.

Nov 04, 2010 01:36 AM

Karen Kruschka

RE/MAX Executives - Woodbridge, VA

- "My Experience Isn't Expensive - It's PRICELESS"

John They are effective

Nov 04, 2010 04:04 AM

Karen Kruschka

RE/MAX Executives - Woodbridge, VA

- "My Experience Isn't Expensive - It's PRICELESS"

Rebecca That is true - 2 hours only because they are editable and updating is easy

Nov 04, 2010 04:05 AM

Karen Kruschka

RE/MAX Executives - Woodbridge, VA

- "My Experience Isn't Expensive - It's PRICELESS"

Jim They usually are too complicated

Nov 04, 2010 04:06 AM

Karen Kruschka

RE/MAX Executives - Woodbridge, VA

- "My Experience Isn't Expensive - It's PRICELESS"

Pat As you can see by some top bloggers and successful agents market reports are effective Thank you for suggesting so I can spread the word

Nov 04, 2010 04:08 AM

Karen Kruschka

RE/MAX Executives - Woodbridge, VA

- "My Experience Isn't Expensive - It's PRICELESS"

Bill So that's why you do them - Hmm :)

Nov 04, 2010 04:09 AM

Bob & Leilani Souza

Souza Realty 916.408.5500 - Roseville, CA

Greater Sacramento Area Homes, Land & Investments

Karen, thank you for the wonderful tutorial on how to create simple and effective market reports! I just suggested this post and will bookmark it as a reference. So far, I've just been reporting on trustee sales and new foreclosures, but this will come in handy for the communities I will be doing hyper-local posts on. :)

Leilani

Nov 04, 2010 02:52 PM

Jennifer Fivelsdal

JFIVE Home Realty LLC | 845-758-6842|162 Deer Run Rd Red Hook NY 12571 - Rhinebeck, NY

Mid Hudson Valley real estate connection

Karen you do so much to make your market report interest. I find consumer prefer this type of a market report instead of the canned versions.

Nov 04, 2010 04:31 PM

Martha Brown

Long & Foster Real Estate, Inc., Annapolis MD 21403 - Annapolis, MD

Your Homes Around Annapolis Agent

This is great Karen. I have been doing something similar but never as consistant as I need to. You have now shown me a way to make it simpler and hopefully something I can do regularly. Thanks

Nov 04, 2010 05:09 PM

Karen Kruschka

RE/MAX Executives - Woodbridge, VA

- "My Experience Isn't Expensive - It's PRICELESS"

Leilani Thank you for commenting. If I can help you implement it please don't hesitate to contact me

Nov 05, 2010 02:23 AM

Karen Kruschka

RE/MAX Executives - Woodbridge, VA

- "My Experience Isn't Expensive - It's PRICELESS"

Jennifer That certianly is the case in your market reports as well

Nov 05, 2010 02:24 AM

Karen Kruschka

RE/MAX Executives - Woodbridge, VA

- "My Experience Isn't Expensive - It's PRICELESS"

Martha Consistency is the key

Nov 05, 2010 02:25 AM

Debi Boucher

Real Estate Showcase Photography - Woodland Park, CO

"Realtor Showcase" - Real Estate Photography/Virtual Tours

Great job Karen - I have always felt your reports were very professional. Nice to know they are simple, too!

Nov 05, 2010 11:44 AM

Karen Kruschka

RE/MAX Executives - Woodbridge, VA

- "My Experience Isn't Expensive - It's PRICELESS"

Debi They need to be simple for me to do

Nov 05, 2010 12:07 PM

Renée Donohue~Home Photography

Savvy Home Pix - Allegan, MI

Western Michigan Real Estate Photographer

Thanks for the mention Karen! My husband made my absorption graphs in excel but I am jealous that you have a partner assisting you with pulling data. Still when you look at the return on investment with a market report - it is still very low even though I do it all myself!

I love your market reports too. Each one of us is different in our own ways!

Nov 07, 2010 01:42 AM

Karen Kruschka

RE/MAX Executives - Woodbridge, VA

- "My Experience Isn't Expensive - It's PRICELESS"

Renee Have your husband get a license :)

Nov 07, 2010 02:24 AM