Client Experience Rating
Rate your experience with your Realtor and share your feedback
| Query Template: /Realtor-Agent-Rating/process/dispInquiryUpdate.cfm:100 Execution Time: 11.1 ms Record Count: 1 Cached: No Lazy: No SQL: select a.transactionid, a.mlnum, a.streetNum, a.streetDir, a.streetName, a.closedDate, isnull(a.unitNum,'') unitNum, isnull(b.submitDT,'') submitDT, d.ratingkey, d.AgentType, Case d.agentType When 'list' then 'Seller' When 'sell' then 'Buyer' else '' end as Representing, isnull(c.score,0) score, c.scoreCat1, c.scoreCat2, c.scoreCat3, c.scoreCat4, c.comments, c.clientCommentDT, c.agentComment, c.agentCommentDT, c.publishDT, isnull(a.photoPrimary,'/images/nophoto_lg.jpg') MediaSource from dbo.CERTransaction_tbl a, dbo.CERSurvey_tbl b, dbo.CERSurveyResults_tbl c, ( select transactionid, ratingkey, agentType, member_number from dbo.CERTransactionAgents_tbl where member_number = 605051 and inquiry_id = 2728 ) d where a.transactionid = d.transactionid and d.ratingkey = b.ratingkey and d.ratingkey = c.ratingkey and c.deleted <>1 order by publishDT desc | |||||||||||||||||||||||
| transactionid | mlnum | streetNum | streetDir | streetName | closedDate | unitNum | submitDT | ratingkey | AgentType | Representing | score | scoreCat1 | scoreCat2 | scoreCat3 | scoreCat4 | comments | clientCommentDT | agentComment | agentCommentDT | publishDT | MediaSource | ||
| 1 | 878511 | 34887804 | 32711 | Morrison | {ts '2015-12-23 00:00:00'} | {ts '2015-12-28 18:18:26'} | 5657183A-CEE9-4614-AF11-0007A095632C | list | Seller | 5 | 5 | 5 | 5 | 5 | What a wonderful experience to have a Realtor that was this attentive and determined to sell our property. She stayed in constant contact and was always available to us. Her attention went not only to any potential Buyer but to the other Realtors. See really is a Queen Bee. | {ts '2015-12-28 18:57:40'} | {ts '2016-01-03 00:02:06'} | https://prpmedia.harstatic.com/7238667/lr/img-1.jpeg | |||||
Please provide client name and contact number for the following transaction.
Survey Date
Address
MLNUM
Representing
Overall Rating
12/28/2015
32711 Morrison
34887804
Seller
5.00/5.0
|
|
What a wonderful experience to have a Realtor that was this attentive and determined to sell our property. She stayed in constant contact and was always available to us. Her attention went not only to any potential Buyer but to the other Realtors. See really is a Queen Bee. |
Client Name :
Contact Number :
If you cannot update client contact information for any reason, please email us with MLS#, transaction type, contact name and number to support@har.com
