|
Call us toll-free @
1-866-502-LIST
Can't create/write to file '#sql_678a_0.MYD' (Errcode: 17)
select * from rets_property_all WHERE lower(State)='PA' AND ListPrice > 200000 AND ListPrice < 500000 AND PropertyType='Residential' AND TotalPhotos > 0 order by rand() limit 0,1
Pennsylvania Real Estate Company serving
Home Buyers and
Home Sellers. Find homes throughout the region:
Berks County Real Estate,
Bucks County Real Estate,
Chester County Real Estate,
Delaware County Real Estate,
Lancaster County Real Estate,
Philadelphia County Real Estate and
Montgomery County Real Estate. Also visit our Pennsylvania New Homes.
Every agent is a licensed PA Real Estate Agent & Pennsylvania REALTOR, REALTOR® - A registered collective membership
mark of the NAR.
©2000 - 2010 Home Marketsite, LLC. All rights reserved. Please review our Privacy Policy.Home Marketsite, LLC | 255 Gordon Drive Ste 202 | Exton, PA 19341 |866-502-LIST (5478) | Brokerage License: RB065432
HOME | BUYERS | SELLERS | PRIVACY POLICY | TERMS AND CONDITIONS | ABOUT US |