select * from wp_property_db where `property-status` not like '%|Sold|%' and `property-status` not like '%|Off Market|%' and `property-category` like '%|Residential Property|%'  ORDER BY `wpcf-highlighted-property` DESC, `wpcf-total-price-sort` desc
  • Blum Estate

    Bryan, TX 77803

      3 Bedroom/1 Bath fixer-upper house in need of renovation 910 +/-square feet living area Each bedroom has a closet One car garage attached Large back yard Elementary school nearby