Foreclosure List

"The properties included in the 'foreclosure' category are owned by banks, or lenders, or other corporate entities. The title to these properties may have been obtained through foreclosure, deed-in-lieu of foreclosure or other means."
RE/MAX Featured Listing
Main View
4108 Woodside Lane, Pueblo 81008
3 Bedrooms, 2 Bathrooms, 2 Car Garage Attached, 4 Level

More PhotosAdditional Photos -
$84,900
1392 SQ. Ft.


Details
7 queries took 1070 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `profiles`23237
2DESCRIBE `agent_list`14145
3DESCRIBE `residential`535311
4DESCRIBE `office_list`994
5DESCRIBE `openhouses`554
6DESCRIBE `images`774
7SELECT * FROM residential inner join forclose on forclose.mls = residential.mls inner join images as i on i.mls = residential.mls WHERE i.photoOrder = 0111035