,
Email:
Office:
Cell:
Beach To Bay Real Estate Center
Brokerage: 302 644-6880
Address: 17316 Coastal Highway, Lewes, DE 19958
Fax: 302 644-6881
Visit:



Return to the agent directory.



Contact


*


*

 

Could not complete query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(`ContractInformation` LIKE '%Bank Addendum%' OR `ContractInformation` LIKE '%Re' at line 1 Query: SELECT * FROM listings2 LEFT JOIN `agents` ON `agents`.`agent_id` = `listings2`.`ListAgentAgentID` LEFT JOIN `offices` ON CONCAT(`listings2`.`ListingBoardID`, `listings2`.`ListingFirmID`, `listings2`.`ListingOfficeID`) = `offices`.`OfficeUID` WHERE list_brtot = 'BAY COAST REALTY' AND (city = 'Lewes' OR city = 'Rehoboth Beach')(`ContractInformation` LIKE '%Bank Addendum%' OR `ContractInformation` LIKE '%Relo Addendum%' OR `ContractInformation` LIKE '%Short Sale Addendum%' OR `DISCLOSURES` LIKE '%Short Sale%') AND `list_price` > 50000