query
RESULTSET
query
  ADDRESS ADTYPE AGENTID BANNER BATHS BEDROOMS BROKERID CITY CITYID COUNTYID DATEADDED DESCRIPTION DISPLAY FIREPLACES GARAGE GRABBER GRABBER2 IDENTIFIER LASTUPDATE LINK LISTINGID LOFT LOTSIZEUNIT LOT_SIZE L_STATE MLSID MLS_NUMBER NEWPHOTO OPENHOUSE OVERSIZED PAGENAME PRICE SCHOOLDIST SORTID SPECIALID SQ_FEET SQ_FEET_UNFIN SUBDIVISION TYPEID UNITNUM VTOUR YEARBUILT ZIP ZONEID ZONING
1 4101 Nordland Trail 0 92226 [empty string] 2.00 3 44292 CASTLE ROCK [empty string] 0 2022-07-16 16:15:53.0 2.5 bathroom home features new carpet and paint throughout! The attached two car garage leads up to the main floor which boasts a spacious living room. Up a few stairs and you will be greeted by a fabulous flex space that would make a great office or playroom! This is just around the corner from the kitchen, half bath and laundry area. Upstairs you will find a primary retreat, 2 secondary bedrooms and a bathroom. The front of the home includes a great yard space for any of your outdoor inspiration to take hold! Dont miss this one, its a real gem! 1 [empty string] 2 THIS GREAT 3 BEDROOM, CASTLE ROCK $460,000 2027849867 2022-07-26 16:15:46.0 shelby@newagere.com 553935 0 acres 0.000 CO 141 9159157 [empty string] [empty string] 0 460000.0000 0 0 1491 0 THE MEADOWS 8 [empty string] [empty string] 2004 80109 0
CACHED false
EXECUTIONTIME 2
SQL SELECT * from listing_info where listingid='553935'
THERE IS A PROBLEM WITH THIS LISTING AND THE WEBMASTER HAS BEEN NOTIFIED