繁 / 简 / ENG
App Download
Agent Login
Home
Property
Property Search
Transaction Search
Leased Transaction
Provisional Agreement
Mortgage Rate
Mortgage Calculator
Listing
Mortgage
Blogger
News
Trends
Useful
Purchasing Flow
Buying vs. Renting
New vs. Pre-Owned Property
Sales Brochure
HOS-pedia
Village
Property’s Matters
Building Inspection DIY
Cosmetically Surgerized Property
English-Chinese Glossary of Terms
English Abbreviations
Home Ownership Questions
Rental Housing Guide
VR Tour
About Us
Agent Blog
select a.sno,a.sysuserid,a.hqid,a.sysid,a.engname,a.chiname,a.tel,a.uemail,a.licno,a.pic,a.chinatel from memuser a join ( select sno from memuser where isvalid=1 and sysid="HSO" and sysuserid="ADA" and 202512051415 ) as t on a.sno = t.sno