Current List of Open Houses

March 13, 2010

Main View
895 El Nido Dr, Pueblo West 81007
3 Bedrooms, 2 Bathrooms, 2 Car Garage Attached, Ranch

More PhotosAdditional Photos -
$189,000
1472 SQ. Ft.


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

More PhotosAdditional Photos Virtual TourVirtual Tour -
$152,900
1911 SQ. Ft.


Details
Main View
285 Sifford Court, Pueblo West 81007
4 Bedrooms, 3 Bathrooms, 3 Car Garage Attached, Ranch

More PhotosAdditional Photos Virtual TourVirtual Tour -
$365,000
2927 SQ. Ft.


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

More PhotosAdditional Photos -
$141,000
1440 SQ. Ft.


Details
2 queries took 1509 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `openhouses`554
2select * 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 > 1268210478 and photoOrder = 0 order by start441505