Dwight Fleming

keystone homes staff

Agent Listings

No Properties Found Matching Your Search

query
RESULTSET
query
  BOARDNAME DTIDATEADDED LNGLISTINGAGENTID LNGLISTINGOFFICEID LNGLISTPRICE LNGMLSNUMBER PROPERTYTYPE TXTCITY TXTCOUNTY TXTDETAIL1 TXTDETAIL2 TXTDETAIL3 TXTDETAIL4 TXTDETAIL5 TXTDETAIL6 TXTDETAIL7 TXTDETAIL8 TXTELEMENTARYSCHOOL TXTHIGHSCHOOL TXTMIDDLESCHOOL TXTPHOTOLINK TXTPROPERTYSTATUS TXTPUBLICREMARKS1 TXTSTATE TXTSTREETDIR TXTSTREETNAME TXTSTREETNUMBER TXTSTREETSUFFIX TXTSUBDIVISION TXTZIPCODE YSNACTIVE YSNFEATURED
CACHED false
EXECUTIONTIME 48
SQL SELECT (SELECT TOP 1 tblPhotoLinks.txtPhotoLink FROM tblPhotoLinks AS tblPhotoLinks WHERE tblPhotoLinks.lngMLSNumber = Properties.lngMLSNumber ORDER BY tblPhotoLinks.lngPhotoOrder) AS txtPhotoLink, Properties.PropertyType, Properties.BoardName, Properties.lngMLSNumber, Properties.lngListPrice, Properties.txtStreetNumber, Properties.txtStreetDir, Properties.txtStreetName, Properties.txtStreetSuffix, Properties.txtCity, Properties.txtState, Properties.txtZipcode, Properties.txtCounty, Properties.txtDetail1, Properties.txtDetail2, Properties.txtDetail3, Properties.txtDetail4, Properties.txtDetail5, Properties.txtDetail6, Properties.txtDetail7, Properties.txtDetail8, Properties.txtSubdivision, Properties.txtElementarySchool, Properties.txtMiddleSchool, Properties.txtHighSchool, Properties.txtPublicRemarks1, Properties.dtiDateAdded, Properties.lngListingAgentID, Properties.lngListingOfficeID, Properties.ysnFeatured, Properties.txtPropertyStatus, Properties.ysnActive FROM vw_AugProperties AS Properties WHERE Properties.ysnActive = 1 AND Properties.lngListingOfficeID = ? AND Properties.lngListingAgentID = ?
SQLPARAMETERS
array
1 446
2 3