James Smyth Estate Agents

9905 4100

9905 4111

Renet_Coffsagent_Row Object ( [_schema:protected] => properties [_name:protected] => coffsagents [Salesreps] => Array ( ) [Preferences] => [_data:protected] => Array ( [id] => 11584 [portal_id] => 5 [last_updated_id] => 40 [country_id] => 13 [agent] => 1 [company] => Smyth Estate Agents [owner] => James Smyth [owner2] => [sec] => Jessica Hogan [contact] => James Smyth [email] => james@smythestateagents.com.au [mail] => PO Box 612 [address1] => Suite 4, 1-3 Moore Road [address2] => Freshwater NSW 2096 [address_rentals] => Suite 4, 1-3 Moore Rd Freshwater NSW 2096 [date] => 2011-11-17 16:38:32 [notes] => [phone] => 02 9905 4100 [phone2] => 02 9905 4111 [web] => http://www.smythestateagents.com.au [username] => smyth [password] => moore [keywords] => Freshwater, Curl Curl, North Manly, Queenscliff, North Curl Curl, Freshwater Beach, House, unit, apartment, duplex, townhouse, water views, CBD transport, headland views, rentals, leases, Sponsorships, Surf Club, South Curl Curl, beds, baths, carport, lounge, pool, best agent, James Smyth, SEA, Sandon Stolle, smythestateagents, Jessica Hogan, Rana Free Richmond, Santa Claus, independent, data base, buyers, stamp duty, purchase, sell, auctions, sales, investment, leasing, application, market appraisal, promotions, beachside, beach hotel, Moore Rd, Smyth, local agents, www.smythestateagents.com.au, luxury homes, sold prices, experience, skill, negotiation, lead selling agent, strata, levies, St John The Baptist, Harbord, Freshwater Heights, capital growth, 1, Freshie, Surf Life Saving, active agent, highest price, highest sale price, record price, niche, boutique, deliver results, 2096, property management, advice, [logo] => http://www.real-estate-australia.com.au/images/agent_11584_logo.gif [addimg] => http://www.real-estate-australia.com.au/images/agent_11584_banner.gif [town] => Freshwater [agentshort] => JamesSmy11584 [system_user] => 1 [system_cost] => [residential] => Yes [commercial] => Yes [holiday_letting] => No [rentals] => Yes [city] => Sydney [state] => NSW [post_code] => 2096 [agentsdbase] => james_smyth [local] => [yearly] => 0 [due] => [intro] => Freshwater's best estate agency (SEA) created by James Smyth [description] => [rural] => No [prestige] => Yes [qtrs] => 53 [chain] => 0 [extras] => [contracted] => 0 [contracted_date] => [maximisation] => [accounts_email] => james@smythestateagents.com.au [delegated] => 1 [groups] => 0 [portal_db] => oz_counter [owner_type] => Owner [rentals_email] => rana@smythestateagents.com.au [renet_salesman] => 20 [priceupgradecategory] => 1 [allowed_ips] => [latitude] => -33.7790908813 [longitude] => 151.285705566 [zoom] => [DueDate] => 2012-03-01 ) [_cleanData:protected] => Array ( [id] => 11584 [portal_id] => 5 [last_updated_id] => 40 [country_id] => 13 [agent] => 1 [company] => Smyth Estate Agents [owner] => James Smyth [owner2] => [sec] => Jessica Hogan [contact] => James Smyth [email] => james@smythestateagents.com.au [mail] => PO Box 612 [address1] => Suite 4, 1-3 Moore Road [address2] => Freshwater NSW 2096 [address_rentals] => Suite 4, 1-3 Moore Rd Freshwater NSW 2096 [date] => 2011-11-17 16:38:32 [notes] => [phone] => 02 9905 4100 [phone2] => 02 9905 4111 [web] => http://www.smythestateagents.com.au [username] => smyth [password] => moore [keywords] => Freshwater, Curl Curl, North Manly, Queenscliff, North Curl Curl, Freshwater Beach, House, unit, apartment, duplex, townhouse, water views, CBD transport, headland views, rentals, leases, Sponsorships, Surf Club, South Curl Curl, beds, baths, carport, lounge, pool, best agent, James Smyth, SEA, Sandon Stolle, smythestateagents, Jessica Hogan, Rana Free Richmond, Santa Claus, independent, data base, buyers, stamp duty, purchase, sell, auctions, sales, investment, leasing, application, market appraisal, promotions, beachside, beach hotel, Moore Rd, Smyth, local agents, www.smythestateagents.com.au, luxury homes, sold prices, experience, skill, negotiation, lead selling agent, strata, levies, St John The Baptist, Harbord, Freshwater Heights, capital growth, 1, Freshie, Surf Life Saving, active agent, highest price, highest sale price, record price, niche, boutique, deliver results, 2096, property management, advice, [logo] => http://www.real-estate-australia.com.au/images/agent_11584_logo.gif [addimg] => http://www.real-estate-australia.com.au/images/agent_11584_banner.gif [town] => Freshwater [agentshort] => JamesSmy11584 [system_user] => 1 [system_cost] => [residential] => Yes [commercial] => Yes [holiday_letting] => No [rentals] => Yes [city] => Sydney [state] => NSW [post_code] => 2096 [agentsdbase] => james_smyth [local] => [yearly] => 0 [due] => [intro] => Freshwater's best estate agency (SEA) created by James Smyth [description] => [rural] => No [prestige] => Yes [qtrs] => 53 [chain] => 0 [extras] => [contracted] => 0 [contracted_date] => [maximisation] => [accounts_email] => james@smythestateagents.com.au [delegated] => 1 [groups] => 0 [portal_db] => oz_counter [owner_type] => Owner [rentals_email] => rana@smythestateagents.com.au [renet_salesman] => 20 [priceupgradecategory] => 1 [allowed_ips] => [latitude] => -33.7790908813 [longitude] => 151.285705566 [zoom] => [DueDate] => 2012-03-01 ) [_modifiedFields:protected] => Array ( ) [_table:protected] => Renet_Coffsagent Object ( [_schema:protected] => properties [_name:protected] => coffsagents [_primary:protected] => Array ( [1] => id ) [_rowsetClass:protected] => Reef_Db_Table_Rowset [_db:protected] => Zend_Db_Adapter_Mysqli Object ( [_numericDataTypes:protected] => Array ( [0] => 0 [1] => 1 [2] => 2 [INT] => 0 [INTEGER] => 0 [MEDIUMINT] => 0 [SMALLINT] => 0 [TINYINT] => 0 [BIGINT] => 1 [SERIAL] => 1 [DEC] => 2 [DECIMAL] => 2 [DOUBLE] => 2 [DOUBLE PRECISION] => 2 [FIXED] => 2 [FLOAT] => 2 ) [_stmt:protected] => Zend_Db_Statement_Mysqli Object ( [_stmt:protected] => mysqli_stmt Object ( ) [_keys:protected] => Array ( [0] => ListingID [1] => ForeignID [2] => id [3] => agents_id [4] => chain [5] => for_sale [6] => for_rent [7] => holiday_rental [8] => rental_short_term [9] => agent [10] => inserted_by_id [11] => portal_id [12] => country_id [13] => heading [14] => intro [15] => price [16] => pricemid [17] => pricehigh [18] => pricexmas [19] => price_hidden [20] => price_view [21] => price_per [22] => location [23] => description [24] => thum_img [25] => main_img [26] => main_img_original [27] => main_img_desc [28] => ximgis [29] => extra_img1 [30] => extra_img1_original [31] => extra_img1_desc [32] => extra_img2 [33] => extra_img2_original [34] => extra_img2_desc [35] => extra_img3 [36] => extra_img3_original [37] => extra_img3_desc [38] => extra_img4 [39] => extra_img4_original [40] => extra_img4_desc [41] => extra_img5 [42] => extra_img5_original [43] => extra_img5_desc [44] => extra_img6 [45] => extra_img6_original [46] => extra_img6_desc [47] => keywords [48] => contact_name [49] => contact_email [50] => contact_phone [51] => contact_mobile [52] => business [53] => business_category [54] => vtour [55] => address [56] => salesrep [57] => agentfull [58] => sold [59] => listed_date [60] => modified_date [61] => owners [62] => owners_phone [63] => owners_email [64] => owners_address_nu [65] => owners_address_st [66] => owners_address_town [67] => owners_address_state [68] => owners_address_pcode [69] => owners2 [70] => owners_phone2 [71] => owners_email2 [72] => owners2_address_nu [73] => owners2_address_st [74] => owners2_address_town [75] => owners2_address_state [76] => owners2_address_pcode [77] => prop_address_unit [78] => prop_address_nu [79] => prop_address_st [80] => bedrooms [81] => bathrooms [82] => garages [83] => carports [84] => prop_id [85] => vacant_land [86] => non_urban_land [87] => local [88] => unit [89] => units_in_complex [90] => state [91] => prestige [92] => rural [93] => auction [94] => advertise [95] => advertise_realestate [96] => advertise_domain [97] => advertise_homehound [98] => commercial [99] => commercial_category [100] => house [101] => auction_date [102] => auction_time [103] => auction_location [104] => xvtours [105] => beachfront [106] => waterfront [107] => riverfront [108] => landsize [109] => landsize_unit [110] => land_content [111] => rates [112] => rates_period [113] => zoning [114] => building_age [115] => building_type [116] => city [117] => postcode [118] => pom [119] => exclusive [120] => bodycorp [121] => bodycorp_period [122] => exclusive_expiry [123] => comments [124] => tender [125] => building_size [126] => building_size_unit [127] => floors [128] => archived [129] => hot [130] => turnover [131] => nettreturn [132] => stars [133] => xvtourslink [134] => villa [135] => appartment [136] => studio [137] => highrise [138] => townhouse [139] => development [140] => investment [141] => sub_devision [142] => house_land [143] => bedroom_details [144] => bathroom_details [145] => garage_details [146] => lounge_details [147] => inclusions_details [148] => exclusions_details [149] => kitchen_details [150] => pool_details [151] => air_cond_details [152] => under_house_details [153] => flooring_details [154] => duplex [155] => block_of [156] => gst [157] => map_reference [158] => frontyard [159] => backyard [160] => security [161] => close_to [162] => availability [163] => pets [164] => hol_date_norm [165] => hol_date_mid [166] => hol_date_high [167] => link_to_id [168] => solicitor_details [169] => extra [170] => outgoings [171] => outgoings_period [172] => show_address [173] => penthouse [174] => golf_estate [175] => laundry_details [176] => facilities [177] => depreciation [178] => rental_return [179] => rental_return_period [180] => rental_return_actual [181] => on_site_management [182] => off_the_plan [183] => project_marketing [184] => resort [185] => notable_features [186] => xml_provider_id [187] => advertising_heading [188] => advertising_desc [189] => alpine [190] => acerage [191] => acerage_semi_rural [192] => semi_rural [193] => retirement [194] => terrace [195] => serviced_apartment [196] => mobile_home [197] => energy_rating [198] => office_id [199] => latitude [200] => longitude [201] => zoom [202] => id [203] => prop_id [204] => img1 [205] => img1_original [206] => img1_desc [207] => img2 [208] => img2_original [209] => img2_desc [210] => img3 [211] => img3_original [212] => img3_desc [213] => img4 [214] => img4_original [215] => img4_desc [216] => img5 [217] => img5_original [218] => img5_desc [219] => img6 [220] => img6_original [221] => img6_desc [222] => img7 [223] => img7_original [224] => img7_desc [225] => img8 [226] => img8_original [227] => img8_desc [228] => img9 [229] => img9_original [230] => img9_desc [231] => img10 [232] => img10_original [233] => img10_desc [234] => img11 [235] => img11_original [236] => img11_desc [237] => img12 [238] => img12_original [239] => img12_desc [240] => img13 [241] => img13_original [242] => img13_desc [243] => img14 [244] => img14_original [245] => img14_desc [246] => img15 [247] => img15_original [248] => img15_desc [249] => img16 [250] => img16_original [251] => img16_desc [252] => img17 [253] => img17_original [254] => img17_desc [255] => img18 [256] => img18_original [257] => img18_desc [258] => img19 [259] => img19_original [260] => img19_desc [261] => img20 [262] => img20_original [263] => img20_desc [264] => websiteDateStart [265] => sold_date [266] => sold_price [267] => hide [268] => sold_by ) [_values:protected] => Array ( [0] => 0 [1] => [2] => 0 [3] => 0 [4] => 0 [5] => [6] => [7] => [8] => 0 [9] => [10] => 0 [11] => 0 [12] => 0 [13] => [14] => [15] => 0 [16] => 0 [17] => 0 [18] => 0 [19] => [20] => [21] => [22] => [23] => [24] => [25] => [26] => [27] => [28] => [29] => [30] => [31] => [32] => [33] => [34] => [35] => [36] => [37] => [38] => [39] => [40] => [41] => [42] => [43] => [44] => [45] => [46] => [47] => [48] => [49] => [50] => [51] => [52] => [53] => [54] => [55] => [56] => [57] => [58] => [59] => 0 [60] => [61] => [62] => [63] => [64] => [65] => [66] => [67] => [68] => [69] => [70] => [71] => [72] => [73] => [74] => [75] => [76] => [77] => [78] => [79] => [80] => [81] => [82] => [83] => 0 [84] => [85] => [86] => 0 [87] => [88] => [89] => 0 [90] => [91] => [92] => [93] => [94] => 0 [95] => 0 [96] => 0 [97] => 0 [98] => [99] => [100] => [101] => [102] => [103] => [104] => [105] => [106] => [107] => [108] => [109] => [110] => [111] => [112] => [113] => [114] => [115] => [116] => [117] => 0 [118] => [119] => [120] => [121] => [122] => [123] => [124] => [125] => [126] => [127] => [128] => [129] => [130] => [131] => [132] => 0 [133] => [134] => [135] => [136] => 0 [137] => [138] => [139] => [140] => [141] => [142] => [143] => [144] => [145] => [146] => [147] => [148] => [149] => [150] => [151] => [152] => [153] => [154] => [155] => [156] => [157] => [158] => [159] => [160] => [161] => [162] => [163] => 0 [164] => [165] => [166] => [167] => [168] => [169] => 0 [170] => [171] => [172] => [173] => 0 [174] => 0 [175] => [176] => [177] => [178] => [179] => [180] => [181] => [182] => [183] => 0 [184] => [185] => [186] => 0 [187] => [188] => [189] => [190] => [191] => [192] => [193] => [194] => [195] => [196] => [197] => [198] => 0 [199] => [200] => [201] => 0 [202] => 0 [203] => 0 [204] => [205] => [206] => [207] => [208] => [209] => [210] => [211] => [212] => [213] => [214] => [215] => [216] => [217] => [218] => [219] => [220] => [221] => [222] => [223] => [224] => [225] => [226] => [227] => [228] => [229] => [230] => [231] => [232] => [233] => [234] => [235] => [236] => [237] => [238] => [239] => [240] => [241] => [242] => [243] => [244] => [245] => [246] => [247] => [248] => [249] => [250] => [251] => [252] => [253] => [254] => [255] => [256] => [257] => [258] => [259] => [260] => [261] => [262] => [263] => [264] => [265] => [266] => 0 [267] => [268] => ) [_meta:protected] => mysqli_result Object ( ) [_adapter:protected] => Zend_Db_Adapter_Mysqli Object *RECURSION* [_fetchMode:protected] => 2 [_attribute:protected] => Array ( ) [_bindColumn:protected] => Array ( ) [_bindParam:protected] => Array ( ) [_sqlSplit:protected] => Array ( [0] => SELECT . AS , . AS , .*, ., ., ., ., .*, . AS , ., ., ., . FROM . LEFT JOIN . ON listings_agents_office_id.prop_id = listings.id LEFT JOIN . ON listings_mapping.prop_id = listings.id LEFT JOIN . ON listings_images_gallery.prop_id = listings.id LEFT JOIN . ON listings_website_advertising_dates.prop_id = listings.id LEFT JOIN . ON listings_sold.prop_id = listings.id WHERE (listings_website_advertising_dates.date_start is null) AND (listings.agents_id = 11584) AND (listings_agents_office_id.office_id = 0 OR listings_agents_office_id.office_id is null) AND (listings.sold = OR listings.sold is null OR listings.sold = OR listings.sold = OR listings.sold = ) AND (listings.archived = OR listings.archived is null) AND (listings.pom = ) AND (listings.for_sale = ) GROUP BY . ORDER BY . ASC, RAND() ASC ) [_sqlParam:protected] => Array ( [0] => SELECT . AS , . AS , .*, ., ., ., ., .*, . AS , ., ., ., . FROM . LEFT JOIN . ON listings_agents_office_id.prop_id = listings.id LEFT JOIN . ON listings_mapping.prop_id = listings.id LEFT JOIN . ON listings_images_gallery.prop_id = listings.id LEFT JOIN . ON listings_website_advertising_dates.prop_id = listings.id LEFT JOIN . ON listings_sold.prop_id = listings.id WHERE (listings_website_advertising_dates.date_start is null) AND (listings.agents_id = 11584) AND (listings_agents_office_id.office_id = 0 OR listings_agents_office_id.office_id is null) AND (listings.sold = OR listings.sold is null OR listings.sold = OR listings.sold = OR listings.sold = ) AND (listings.archived = OR listings.archived is null) AND (listings.pom = ) AND (listings.for_sale = ) GROUP BY . ORDER BY . ASC, RAND() ASC ) [_queryId:protected] => ) [_config:protected] => Array ( [type] => mysqli [host] => 118.107.59.254 [username] => schindler1 [password] => 16firstave [dbname] => renet [options] => Array ( [caseFolding] => 0 [autoQuoteIdentifiers] => 1 ) [driver_options] => Array ( ) ) [_fetchMode:protected] => 2 [_profiler:protected] => Zend_Db_Profiler Object ( [_queryProfiles:protected] => Array ( ) [_enabled:protected] => [_filterElapsedSecs:protected] => [_filterTypes:protected] => ) [_defaultProfilerClass:protected] => Zend_Db_Profiler [_connection:protected] => mysqli Object ( ) [_caseFolding:protected] => 0 [_autoQuoteIdentifiers:protected] => 1 ) [_cols:protected] => Array ( [0] => id [1] => portal_id [2] => last_updated_id [3] => country_id [4] => agent [5] => company [6] => owner [7] => owner2 [8] => sec [9] => contact [10] => email [11] => mail [12] => address1 [13] => address2 [14] => address_rentals [15] => date [16] => notes [17] => phone [18] => phone2 [19] => web [20] => username [21] => password [22] => keywords [23] => logo [24] => addimg [25] => town [26] => agentshort [27] => system_user [28] => system_cost [29] => residential [30] => commercial [31] => holiday_letting [32] => rentals [33] => city [34] => state [35] => post_code [36] => agentsdbase [37] => local [38] => yearly [39] => due [40] => intro [41] => description [42] => rural [43] => prestige [44] => qtrs [45] => chain [46] => extras [47] => contracted [48] => contracted_date [49] => maximisation [50] => accounts_email [51] => delegated [52] => groups [53] => portal_db [54] => owner_type [55] => rentals_email [56] => renet_salesman [57] => priceupgradecategory [58] => allowed_ips [59] => latitude [60] => longitude [61] => zoom ) [_identity:protected] => 1 [_sequence:protected] => 1 [_metadata:protected] => Array ( [id] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => id [COLUMN_POSITION] => 1 [DATA_TYPE] => int [DEFAULT] => [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => 1 [PRIMARY_POSITION] => 1 [IDENTITY] => 1 ) [portal_id] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => portal_id [COLUMN_POSITION] => 2 [DATA_TYPE] => int [DEFAULT] => 0 [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [last_updated_id] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => last_updated_id [COLUMN_POSITION] => 3 [DATA_TYPE] => int [DEFAULT] => 0 [NULLABLE] => 1 [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [country_id] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => country_id [COLUMN_POSITION] => 4 [DATA_TYPE] => int [DEFAULT] => 13 [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [agent] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => agent [COLUMN_POSITION] => 5 [DATA_TYPE] => enum('0','1') [DEFAULT] => 0 [NULLABLE] => 1 [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [company] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => company [COLUMN_POSITION] => 6 [DATA_TYPE] => varchar [DEFAULT] => [NULLABLE] => 1 [LENGTH] => 100 [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [owner] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => owner [COLUMN_POSITION] => 7 [DATA_TYPE] => varchar [DEFAULT] => [NULLABLE] => 1 [LENGTH] => 40 [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [owner2] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => owner2 [COLUMN_POSITION] => 8 [DATA_TYPE] => varchar [DEFAULT] => [NULLABLE] => 1 [LENGTH] => 40 [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [sec] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => sec [COLUMN_POSITION] => 9 [DATA_TYPE] => varchar [DEFAULT] => [NULLABLE] => 1 [LENGTH] => 40 [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [contact] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => contact [COLUMN_POSITION] => 10 [DATA_TYPE] => varchar [DEFAULT] => [NULLABLE] => 1 [LENGTH] => 20 [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [email] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => email [COLUMN_POSITION] => 11 [DATA_TYPE] => varchar [DEFAULT] => [NULLABLE] => 1 [LENGTH] => 100 [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [mail] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => mail [COLUMN_POSITION] => 12 [DATA_TYPE] => varchar [DEFAULT] => [NULLABLE] => 1 [LENGTH] => 80 [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [address1] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => address1 [COLUMN_POSITION] => 13 [DATA_TYPE] => varchar [DEFAULT] => [NULLABLE] => 1 [LENGTH] => 80 [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [address2] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => address2 [COLUMN_POSITION] => 14 [DATA_TYPE] => varchar [DEFAULT] => [NULLABLE] => 1 [LENGTH] => 80 [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [address_rentals] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => address_rentals [COLUMN_POSITION] => 15 [DATA_TYPE] => varchar [DEFAULT] => [NULLABLE] => 1 [LENGTH] => 80 [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [date] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => date [COLUMN_POSITION] => 16 [DATA_TYPE] => timestamp [DEFAULT] => CURRENT_TIMESTAMP [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [notes] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => notes [COLUMN_POSITION] => 17 [DATA_TYPE] => text [DEFAULT] => [NULLABLE] => 1 [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [phone] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => phone [COLUMN_POSITION] => 18 [DATA_TYPE] => varchar [DEFAULT] => [NULLABLE] => 1 [LENGTH] => 19 [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [phone2] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => phone2 [COLUMN_POSITION] => 19 [DATA_TYPE] => varchar [DEFAULT] => [NULLABLE] => 1 [LENGTH] => 25 [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [web] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => web [COLUMN_POSITION] => 20 [DATA_TYPE] => varchar [DEFAULT] => [NULLABLE] => 1 [LENGTH] => 100 [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [username] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => username [COLUMN_POSITION] => 21 [DATA_TYPE] => varchar [DEFAULT] => [NULLABLE] => [LENGTH] => 20 [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [password] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => password [COLUMN_POSITION] => 22 [DATA_TYPE] => varchar [DEFAULT] => [NULLABLE] => [LENGTH] => 20 [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [keywords] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => keywords [COLUMN_POSITION] => 23 [DATA_TYPE] => text [DEFAULT] => [NULLABLE] => 1 [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [logo] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => logo [COLUMN_POSITION] => 24 [DATA_TYPE] => varchar [DEFAULT] => [NULLABLE] => 1 [LENGTH] => 80 [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [addimg] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => addimg [COLUMN_POSITION] => 25 [DATA_TYPE] => varchar [DEFAULT] => [NULLABLE] => 1 [LENGTH] => 100 [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [town] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => town [COLUMN_POSITION] => 26 [DATA_TYPE] => varchar [DEFAULT] => [NULLABLE] => 1 [LENGTH] => 35 [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [agentshort] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => agentshort [COLUMN_POSITION] => 27 [DATA_TYPE] => varchar [DEFAULT] => [NULLABLE] => 1 [LENGTH] => 25 [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [system_user] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => system_user [COLUMN_POSITION] => 28 [DATA_TYPE] => enum('0','1') [DEFAULT] => 0 [NULLABLE] => 1 [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [system_cost] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => system_cost [COLUMN_POSITION] => 29 [DATA_TYPE] => int [DEFAULT] => [NULLABLE] => 1 [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [residential] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => residential [COLUMN_POSITION] => 30 [DATA_TYPE] => enum('No','Yes') [DEFAULT] => [NULLABLE] => 1 [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [commercial] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => commercial [COLUMN_POSITION] => 31 [DATA_TYPE] => enum('No','Yes') [DEFAULT] => [NULLABLE] => 1 [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [holiday_letting] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => holiday_letting [COLUMN_POSITION] => 32 [DATA_TYPE] => enum('No','Yes') [DEFAULT] => [NULLABLE] => 1 [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [rentals] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => rentals [COLUMN_POSITION] => 33 [DATA_TYPE] => enum('No','Yes') [DEFAULT] => [NULLABLE] => 1 [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [city] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => city [COLUMN_POSITION] => 34 [DATA_TYPE] => varchar [DEFAULT] => [NULLABLE] => 1 [LENGTH] => 35 [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [state] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => state [COLUMN_POSITION] => 35 [DATA_TYPE] => enum('NSW','QLD','VIC','SA','TAS','WA','ACT','NT') [DEFAULT] => NSW [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [post_code] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => post_code [COLUMN_POSITION] => 36 [DATA_TYPE] => smallint [DEFAULT] => [NULLABLE] => 1 [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => 1 [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [agentsdbase] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => agentsdbase [COLUMN_POSITION] => 37 [DATA_TYPE] => varchar [DEFAULT] => [NULLABLE] => 1 [LENGTH] => 60 [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [local] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => local [COLUMN_POSITION] => 38 [DATA_TYPE] => varchar [DEFAULT] => [NULLABLE] => [LENGTH] => 100 [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [yearly] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => yearly [COLUMN_POSITION] => 39 [DATA_TYPE] => enum('0','1') [DEFAULT] => 0 [NULLABLE] => 1 [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [due] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => due [COLUMN_POSITION] => 40 [DATA_TYPE] => text [DEFAULT] => [NULLABLE] => 1 [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [intro] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => intro [COLUMN_POSITION] => 41 [DATA_TYPE] => varchar [DEFAULT] => [NULLABLE] => 1 [LENGTH] => 80 [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [description] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => description [COLUMN_POSITION] => 42 [DATA_TYPE] => text [DEFAULT] => [NULLABLE] => 1 [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [rural] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => rural [COLUMN_POSITION] => 43 [DATA_TYPE] => enum('No','Yes') [DEFAULT] => [NULLABLE] => 1 [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [prestige] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => prestige [COLUMN_POSITION] => 44 [DATA_TYPE] => enum('No','Yes') [DEFAULT] => [NULLABLE] => 1 [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [qtrs] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => qtrs [COLUMN_POSITION] => 45 [DATA_TYPE] => float [DEFAULT] => [NULLABLE] => 1 [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [chain] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => chain [COLUMN_POSITION] => 46 [DATA_TYPE] => int [DEFAULT] => 0 [NULLABLE] => 1 [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [extras] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => extras [COLUMN_POSITION] => 47 [DATA_TYPE] => enum('y','n') [DEFAULT] => [NULLABLE] => 1 [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [contracted] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => contracted [COLUMN_POSITION] => 48 [DATA_TYPE] => tinyint [DEFAULT] => 0 [NULLABLE] => 1 [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [contracted_date] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => contracted_date [COLUMN_POSITION] => 49 [DATA_TYPE] => date [DEFAULT] => [NULLABLE] => 1 [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [maximisation] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => maximisation [COLUMN_POSITION] => 50 [DATA_TYPE] => enum('1','2','3') [DEFAULT] => [NULLABLE] => 1 [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [accounts_email] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => accounts_email [COLUMN_POSITION] => 51 [DATA_TYPE] => varchar [DEFAULT] => [NULLABLE] => 1 [LENGTH] => 100 [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [delegated] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => delegated [COLUMN_POSITION] => 52 [DATA_TYPE] => enum('0','1') [DEFAULT] => 0 [NULLABLE] => 1 [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [groups] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => groups [COLUMN_POSITION] => 53 [DATA_TYPE] => int [DEFAULT] => 0 [NULLABLE] => 1 [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [portal_db] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => portal_db [COLUMN_POSITION] => 54 [DATA_TYPE] => varchar [DEFAULT] => [NULLABLE] => 1 [LENGTH] => 100 [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [owner_type] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => owner_type [COLUMN_POSITION] => 55 [DATA_TYPE] => varchar [DEFAULT] => Owner [NULLABLE] => 1 [LENGTH] => 100 [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [rentals_email] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => rentals_email [COLUMN_POSITION] => 56 [DATA_TYPE] => varchar [DEFAULT] => [NULLABLE] => 1 [LENGTH] => 100 [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [renet_salesman] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => renet_salesman [COLUMN_POSITION] => 57 [DATA_TYPE] => int [DEFAULT] => [NULLABLE] => 1 [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [priceupgradecategory] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => priceupgradecategory [COLUMN_POSITION] => 58 [DATA_TYPE] => int [DEFAULT] => [NULLABLE] => 1 [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [allowed_ips] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => allowed_ips [COLUMN_POSITION] => 59 [DATA_TYPE] => varchar [DEFAULT] => [NULLABLE] => 1 [LENGTH] => 255 [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [latitude] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => latitude [COLUMN_POSITION] => 60 [DATA_TYPE] => float [DEFAULT] => [NULLABLE] => 1 [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [longitude] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => longitude [COLUMN_POSITION] => 61 [DATA_TYPE] => float [DEFAULT] => [NULLABLE] => 1 [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) [zoom] => Array ( [SCHEMA_NAME] => [TABLE_NAME] => coffsagents [COLUMN_NAME] => zoom [COLUMN_POSITION] => 62 [DATA_TYPE] => int [DEFAULT] => [NULLABLE] => 1 [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => [IDENTITY] => ) ) [_metadataCache:protected] => Zend_Cache_Core Object ( [_backend:private] => Zend_Cache_Backend_File Object ( [_options:protected] => Array ( [cache_dir] => /usr/home/renet/data/dbcache/ [file_locking] => 1 [read_control] => 1 [read_control_type] => crc32 [hashed_directory_level] => 0 [hashed_directory_umask] => 448 [file_name_prefix] => zend_cache [cache_file_umask] => 384 [metadatas_array_max_size] => 100 ) [_metadatasArray:private] => Array ( [6b3d51bfb856cc0901384b21d2a04239] => Array ( [hash] => 1336027566 [mtime] => 1327721263 [expire] => 1327724863 [tags] => Array ( ) ) [d9a4ccec5f2a60037f8f315d93a47e53] => Array ( [hash] => 699637578 [mtime] => 1327722034 [expire] => 1327725634 [tags] => Array ( ) ) [b03326e2c31b40e553192192b44eb97c] => Array ( [hash] => 888223936 [mtime] => 1327720389 [expire] => 1327723989 [tags] => Array ( ) ) ) [_directives:protected] => Array ( [lifetime] => 3600 [logging] => [logger] => ) ) [_options:protected] => Array ( [write_control] => 1 [caching] => 1 [cache_id_prefix] => [automatic_serialization] => 1 [automatic_cleaning_factor] => 10 [lifetime] => 3600 [logging] => [logger] => [ignore_user_abort] => ) [_specificOptions:protected] => Array ( ) [_lastId:private] => b03326e2c31b40e553192192b44eb97c ) [_rowClass:protected] => Renet_Coffsagent_Row [_referenceMap:protected] => Array ( ) [_dependentTables:protected] => Array ( ) ) [_connected:protected] => 1 [_readOnly:protected] => [_tableClass:protected] => Renet_Coffsagent [_primary:protected] => Array ( [1] => id ) ) 1