The sale price, at nearly $500 per square foot, reflects the rising demand for high-end living in prime locations in Raleigh.