Can\'t create/write to file \'/var/tmp/#sql_6b_0.MYI\' (Errcode: 28) SQL=SELECT p.*, a.id AS agentid, a.name AS agent, a.photo AS aphoto, a.address AS addr, a.mobile AS phone, a.user AS user, c.name AS company, c.id AS companyid, t.name AS type, p.type AS typeid \n FROM (jrf_hp_properties AS p, jrf_hp_companies AS c)\n LEFT JOIN jrf_hp_agents AS a ON p.agent = a.id\n LEFT JOIN jrf_hp_prop_types AS t ON p.type = t.id\n LEFT JOIN jrf_hp_featured AS f ON f.property = p.id\n WHERE p.published=\'1\' AND p.approved=\'1\' AND t.published=\'1\'\n AND a.company=c.id\n AND (publish_up = \'0000-00-00 00:00:00\' OR publish_up <= NOW())\n AND (publish_down = \'0000-00-00 00:00:00\' OR publish_down >= NOW())\nAND p.featured=\'1\'\nORDER BY RAND()\nLIMIT 0, 1Can\'t create/write to file \'/var/tmp/#sql_6b_0.MYI\' (Errcode: 28) SQL=SELECT a.*, COUNT(p.id) AS properties, c.id AS companyid, c.name AS company FROM (jrf_hp_agents AS a, jrf_hp_prop_types AS t)\nLEFT JOIN jrf_hp_companies AS c ON c.id=a.company\nLEFT JOIN jrf_hp_properties AS p ON p.agent=a.id\nWHERE t.id=p.type\n AND p.published=\'1\' AND p.approved=\'1\' AND t.published=\'1\'\n AND (publish_up = \'0000-00-00 00:00:00\' OR publish_up <= NOW())\n AND (publish_down = \'0000-00-00 00:00:00\' OR publish_down >= NOW())\nGROUP BY p.agent

Welcome to RentalFinder

WELCOME to The News-Argus RentalFinder--the online rental site for Goldsboro and the Wayne County area. Search for a place that meets your needs 24 hours a day, 7 days a week, without leaving the comfort of your home. And RentalFinder appears on the most visited local website in Wayne County with over 1.2 MILLION page views per month!