The article gives enough details about the properties (neighborhood, adjacent street, sell prices and sell dates of it and neighboring properties) that I was able to find them on zillow and redfin in about a minute. I'm not going to give the addresses, but what I could find are:

Subject property: 4 bed, 3.5 bath, 2600 sq ft, 0.26 acre

Neighbor property (that sold for $465k): 3 bed, 3 bath, 2068 sq ft, 0.29 acres

If the Subject Houses were worth the same $/sq ft ($225/sq ft) as the Neighbor, then the Subject House would be worth $585k. While it's a little tough to tell because the pics for the Subject Property aren't very good, the interior finishes and condition appear to be comparable between the two houses, except for the kitchen, which is much nicer in the Neighbor Property. There are no pics of the Subject House's finished basement, but the one in the Neighbor Property looks better than most, so I suspect it has an edge there. The Neighbor House is more attractive from the outside while the landscapings are comparable. It would make sense to me that the Subject House would be appraised at a lower price per sq ft than the Neighbors. How much lower? I'm not sure, but I'd expect no less than $200/sq ft or $520k. IMO, the notion that $550k ($212/sq ft) was "conservative" was wrong - that sounds about right to me. Additionally, the penalty for being directly on Northern Parkway appears to be at least 20%.

$472k puts the subject house at $181/sq ft, which is pretty low, but it's closer than $288/sq ft that the second appraiser put it at, which is nuts. The handful of houses that sell that high are nicer in virtually every way.