Current List of Open Houses

March 14, 2010

Main View
180 Mangrum Court, Pueblo West 81007
4 Bedrooms, 4 Bathrooms, 2 Car Garage Attached, 1.5 Story

More PhotosAdditional Photos Virtual TourVirtual Tour -
$398,000
4485 SQ. Ft.


Details
Main View
345 Bahia Dr, Pueblo West 81007
3 Bedrooms, 2 Bathrooms, 3 Car Garage Attached, Ranch

More PhotosAdditional Photos -
$268,000
1732 SQ. Ft.


Details
1 query took 1093 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1select * from residential inner join openhouses on residential.mls = openhouses.mls inner join geocode on residential.mls = geocode.mls inner join images as i on i.mls = residential.mls where openhouses.end > 1268543054 and photoOrder = 0 order by start221093