Results
Lead Claim Limits
0
Nurtured Leads
0
Credits
What are daily, nurtured and bonus? Learn more Learn More
Contact Info is 100% Guaranteed
Qazzoo provides assurance that you don’t waste your time calling bogus leads.
Tell Me More
Open Your Account
FAQ’S
How Do I Use Qazzoo?
Using Qazzoo is simple. Search for Homebuyers in a particular area. You will now see a list of homebuyers that are looking for a real estate professional to help them. Pick a homebuyer that you want to help purchase a home and unlock their contact info!
What is the benefit of using Qazzoo?
Qazzoo is a more cost effective and time efficient than traditional methods of generating homebuyer contacts.
How do I claim a profile?
Do a search in the area that you want. Click the "Unlock Contact Info" button. It’s pretty simple once you get used to it!
Why does one profile come up before another?
Some profiles are more complete than others as some consumers are more ready willing and able. Combined with other variables, such as most recent Qazzoo is always trying to present the consumers it thinks you want to see. But Qazzoo is a search engine and not a database and therefore you should search deeper than the first page in order to ensure you get the best results.
Daily Leads
Nurtured Leads
Showing results near Pasco (County Southeast), Florida.
Profiles found near this location: 439
TM
TM
Tiffany M.
Home buyer
I am a
Home buyer
I’m looking In
Saint Johns County, FL
Email
Email Available
Phone Number
Phone Available
I am Home Buyer from Saint Johns County, Florida and I am looking to buy a home in Saint Johns County, Florida. I'm looking for a home for $150,000 - $300,000 with a possible down payment of $20,000 - $40,000. I have Good credit with a household income of $60k+ view details »
View Details
profile picture
Stock Photo
Tiffany M.
I am Home Buyer from Saint Johns County, Florida and I am looking to buy a home in Saint Johns County, Florida. I'm looking for a home for $150,000 - $300,000 with a possible down payment of $20,000 - $40,000. I have Good credit with a household income of $60k+ view details »
I am a: Home buyer
I'm looking In: Saint Johns County, FL
My contact info: Email Available
Phone Available
VO
VO
Victor O.
Home buyer
I am a
Home buyer
I’m looking In
Saint Johns County, FL
Email
Email Available
Phone Number
Phone Available
I am Home Buyer from Saint Johns County, Florida and I am looking to buy a home in Saint Johns County, Florida. I'm looking for a home for $150,000 - $500,000 with a possible down payment of $75,000 - $150,000. I have Good credit with a household income of $150k+ view details »
View Details
profile picture
Stock Photo
Victor O.
I am Home Buyer from Saint Johns County, Florida and I am looking to buy a home in Saint Johns County, Florida. I'm looking for a home for $150,000 - $500,000 with a possible down payment of $75,000 - $150,000. I have Good credit with a household income of $150k+ view details »
I am a: Home buyer
I'm looking In: Saint Johns County, FL
My contact info: Email Available
Phone Available
SH
SH
Samantha H.
Home buyer
I am a
Home buyer
I’m looking In
Okaloosa (South), FL
Email
Email Available
Phone Number
Phone Available
I am Home Buyer from Okaloosa (South), Florida and I am looking to buy a home in Okaloosa (South), Florida. I'm looking for a home for $200,000-$300,000 with a possible down payment of $5,000 - $20,000. I have Good credit with a household income of $45k+ view details »
View Details
profile picture
Stock Photo
Samantha H.
I am Home Buyer from Okaloosa (South), Florida and I am looking to buy a home in Okaloosa (South), Florida. I'm looking for a home for $200,000-$300,000 with a possible down payment of $5,000 - $20,000. I have Good credit with a household income of $45k+ view details »
I am a: Home buyer
I'm looking In: Okaloosa (South), FL
My contact info: Email Available
Phone Available
RW
RW
Rhonda W.
Home buyer
I am a
Home buyer
I’m looking In
Leon, FL
Email
Email Available
Phone Number
Phone Available
I am Home Buyer from Leon, Florida and I am looking to buy a home in Leon, Florida. I'm looking for a home for $150,000 - $300,000 with a possible down payment of $5,000 - $20,000. I have Good credit with a household income of $100k+ view details »
View Details
profile picture
Stock Photo
Rhonda W.
I am Home Buyer from Leon, Florida and I am looking to buy a home in Leon, Florida. I'm looking for a home for $150,000 - $300,000 with a possible down payment of $5,000 - $20,000. I have Good credit with a household income of $100k+ view details »
I am a: Home buyer
I'm looking In: Leon, FL
My contact info: Email Available
Phone Available
SP
SP
Sarah P.
Home Owner
I am a
Home Owner
I’m looking In
Nassau, FL
Email
Email Available
Phone Number
Phone Available
I have a home to sell in Nassau, Florida and I am looking to buy a home in Nassau, Florida. I'm looking for a home for $150,000 - $300,000 with a possible down payment of $5,000 - $20,000. I have Good credit with a household income of $90k+ view details »
View Details
profile picture
Stock Photo
Sarah P.
I have a home to sell in Nassau, Florida and I am looking to buy a home in Nassau, Florida. I'm looking for a home for $150,000 - $300,000 with a possible down payment of $5,000 - $20,000. I have Good credit with a household income of $90k+ view details »
I am a: Home Owner
I'm looking In: Nassau, FL
My contact info: Email Available
Phone Available
LS
LS
Lisa S.
Home buyer
I am a
Home buyer
I’m looking In
Brevard (Central), FL
Email
Email Available
Phone Number
Phone Available
I am Home Buyer from Brevard (Central), Florida and I am looking to buy a home in Brevard (Central), Florida. I'm looking for a home for less than $350,000 with a possible down payment of Cash Purchase. I have Good credit with a household income of $60k+ view details »
View Details
profile picture
Stock Photo
Lisa S.
I am Home Buyer from Brevard (Central), Florida and I am looking to buy a home in Brevard (Central), Florida. I'm looking for a home for less than $350,000 with a possible down payment of Cash Purchase. I have Good credit with a household income of $60k+ view details »
I am a: Home buyer
I'm looking In: Brevard (Central), FL
My contact info: Email Available
Phone Available
VP
VP
Victoria P.
Home Owner
I am a
Home Owner
I’m looking In
Hendry, FL
Email
Email Available
Phone Number
Phone Available
I have a home to sell in Hendry, Florida and I am looking to buy a home in Hendry, Florida. I'm looking for a home for $150,000 - $250,000 with a possible down payment of $20,000 - $40,000. I have Good credit with a household income of $80k+ view details »
View Details
profile picture
Stock Photo
Victoria P.
I have a home to sell in Hendry, Florida and I am looking to buy a home in Hendry, Florida. I'm looking for a home for $150,000 - $250,000 with a possible down payment of $20,000 - $40,000. I have Good credit with a household income of $80k+ view details »
I am a: Home Owner
I'm looking In: Hendry, FL
My contact info: Email Available
Phone Available
KJ
KJ
Kaely J.
Home Owner
I am a
Home Owner
I’m looking In
Bay (West), FL
Email
Email Available
Phone Number
Phone Available
I have a home to sell in Bay (West), Florida and I am looking to buy a home in Bay (West), Florida. I'm looking for a home for $150,000 - $250,000 with a possible down payment of $5,000 - $20,000. I have Good credit with a household income of $100k+ view details »
View Details
profile picture
Stock Photo
Kaely J.
I have a home to sell in Bay (West), Florida and I am looking to buy a home in Bay (West), Florida. I'm looking for a home for $150,000 - $250,000 with a possible down payment of $5,000 - $20,000. I have Good credit with a household income of $100k+ view details »
I am a: Home Owner
I'm looking In: Bay (West), FL
My contact info: Email Available
Phone Available
AL
AL
Astrida L.
Home buyer
I am a
Home buyer
I’m looking In
Palm Beach (County South), FL
Email
Email Available
Phone Number
Phone Available
I am Home Buyer from Palm Beach (County South), Florida and I am looking to buy a home in Palm Beach (County South), Florida. I'm looking for a home for $150,000 - $749,001 with a possible down payment of $75,000 - $150,000. I have Good credit with a household income of $250k+ view details »
View Details
profile picture
Stock Photo
Astrida L.
I am Home Buyer from Palm Beach (County South), Florida and I am looking to buy a home in Palm Beach (County South), Florida. I'm looking for a home for $150,000 - $749,001 with a possible down payment of $75,000 - $150,000. I have Good credit with a household income of $250k+ view details »
I am a: Home buyer
I'm looking In: Palm Beach (County South), FL
My contact info: Email Available
Phone Available
RP
RP
Robert P.
Home buyer
I am a
Home buyer
I’m looking In
Duval (Northwest), FL
Email
Email Available
Phone Number
Phone Available
I am Home Buyer from Duval (Northwest), Florida and I am looking to buy a home in Duval (Northwest), Florida. I'm looking for a home for $150,000 - $500,000 with a possible down payment of $5,000 - $20,000. I have Good credit with a household income of $70k+ view details »
View Details
profile picture
Stock Photo
Robert P.
I am Home Buyer from Duval (Northwest), Florida and I am looking to buy a home in Duval (Northwest), Florida. I'm looking for a home for $150,000 - $500,000 with a possible down payment of $5,000 - $20,000. I have Good credit with a household income of $70k+ view details »
I am a: Home buyer
I'm looking In: Duval (Northwest), FL
My contact info: Email Available
Phone Available
13 14 15 16 17 18 19 20 21 22
dbSelectObj[64]: Qazzoo_Model_QAdapterDbselect Object ( [_countSelect:protected] => [_select:protected] => Zend_Db_Select Object ( [_bind:protected] => Array ( ) [_adapter: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 ( [_keys:protected] => Array ( [0] => locationID [1] => state [2] => county [3] => statename [4] => lat [5] => lon [6] => latitude [7] => longitude [8] => county_latitude [9] => county_longitude [10] => county_name [11] => countyFIPS [12] => seo_county [13] => seo_statename [14] => county_normalized ) [_values:protected] => Array ( [0] => 3233 [1] => FL [2] => PASCO (COUNTY SOUTHEAST) [3] => Florida [4] => -82.431938 [5] => 28.323242 [6] => 28.113583 [7] => -82.262619 [8] => 28.323242 [9] => -82.431938 [10] => Pasco [11] => 12101 [12] => pasco-county-southeast [13] => florida [14] => pasco ) [_meta:protected] => mysqli_result Object ( [current_field] => 0 [field_count] => 15 [lengths] => [num_rows] => 0 [type] => 1 ) [_stmt:protected] => mysqli_stmt Object ( [affected_rows] => 1 [insert_id] => 0 [num_rows] => 1 [param_count] => 1 [field_count] => 15 [errno] => 0 [error] => [error_list] => Array ( ) [sqlstate] => 00000 [id] => 4 ) [_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 * from ushud.states where locationID = [1] => ? ) [_sqlParam:protected] => Array ( [0] => SELECT * from ushud.states where locationID = [1] => ? ) [_queryId:protected] => 3 ) [_defaultStmtClass:protected] => Zend_Db_Statement_Mysqli [_config:protected] => Array ( [host] => a98001a1f89847065bbf32aef6b9916b464f102e.rackspaceclouddb.com [username] => livebuyers [password] => mmbc,hy@m [dbname] => livebuyers [charset] => [persistent] => [options] => Array ( [caseFolding] => 0 [autoQuoteIdentifiers] => 1 [fetchMode] => 2 ) [driver_options] => Array ( ) ) [_fetchMode:protected] => 2 [_profiler:protected] => Qazzoo_Model_DbProfiler Object ( [_log:protected] => [_totalElapsedTime:protected] => [_queryProfiles:protected] => Array ( [0] => Zend_Db_Profiler_Query Object ( [_query:protected] => SELECT `session`.* FROM `session` WHERE (((`session`.`session_id` = 'fsh46raudmuj5qiqopq9miks86' AND `session`.`save_path` = '/var/www/myqazzoo/application/../data/session/' AND `session`.`name` = 'PHPSESSID'))) [_queryType:protected] => 32 [_startedMicrotime:protected] => 1771794664.0182 [_endedMicrotime:protected] => 1771794664.0187 [_boundParams:protected] => Array ( ) ) [1] => Zend_Db_Profiler_Query Object ( [_query:protected] => SELECT `seo_page_info`.* FROM `seo_page_info` WHERE (mca_string = 'default/leads/index') LIMIT 1 [_queryType:protected] => 32 [_startedMicrotime:protected] => 1771794664.0356 [_endedMicrotime:protected] => 1771794664.0361 [_boundParams:protected] => Array ( ) ) [2] => Zend_Db_Profiler_Query Object ( [_query:protected] => SELECT locationid FROM ushud.zips WHERE zip = '91001' LIMIT 1; [_queryType:protected] => 32 [_startedMicrotime:protected] => 1771794664.0486 [_endedMicrotime:protected] => 1771794664.049 [_boundParams:protected] => Array ( ) ) [3] => Zend_Db_Profiler_Query Object ( [_query:protected] => SELECT * from ushud.states where locationID = ? [_queryType:protected] => 32 [_startedMicrotime:protected] => 1771794664.0511 [_endedMicrotime:protected] => 1771794664.0516 [_boundParams:protected] => Array ( [1] => 3233 ) ) ) [_enabled:protected] => 1 [_filterElapsedSecs:protected] => [_filterTypes:protected] => ) [_defaultProfilerClass:protected] => Zend_Db_Profiler [_connection:protected] => mysqli Object ( [affected_rows] => 1 [client_info] => mysqlnd 7.4.33 [client_version] => 70433 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 15 [host_info] => a98001a1f89847065bbf32aef6b9916b464f102e.rackspaceclouddb.com via TCP/IP [info] => [insert_id] => 0 [server_info] => 8.0.18 [server_version] => 80018 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 464943973 [warning_count] => 0 ) [_caseFolding:protected] => 0 [_autoQuoteIdentifiers:protected] => 1 [_allowSerialization:protected] => 1 [_autoReconnectOnUnserialize:protected] => ) [_parts:protected] => Array ( [distinct] => 1 [columns] => Array ( [0] => Array ( [0] => l [1] => * [2] => ) [1] => Array ( [0] => l [1] => Zend_Db_Expr Object ( [_expression:protected] => IF(dold.ts_added IS NULL, l.ts_added, dold.ts_added) ) [2] => time ) [2] => Array ( [0] => l [1] => id [2] => leadID ) [3] => Array ( [0] => l [1] => Zend_Db_Expr Object ( [_expression:protected] => livebuyers.fn_leads_transactions_totalused(l.id, 1) ) [2] => numTimesSold ) [4] => Array ( [0] => loc [1] => locationid [2] => ) [5] => Array ( [0] => dist [1] => distance [2] => ) [6] => Array ( [0] => dist [1] => DistSort [2] => ) [7] => Array ( [0] => crh [1] => credithistory [2] => ) [8] => Array ( [0] => la [1] => loanamount [2] => ) [9] => Array ( [0] => dlam [1] => minval [2] => loanamount_manual_min ) [10] => Array ( [0] => dlam [1] => maxval [2] => loanamount_manual_max ) [11] => Array ( [0] => own [1] => ownership [2] => ) [12] => Array ( [0] => dmxs [1] => Zend_Db_Expr Object ( [_expression:protected] => IFNULL(dmxs.maxshares,4) ) [2] => maxshares ) [13] => Array ( [0] => xlf9 [1] => Zend_Db_Expr Object ( [_expression:protected] => IF(xlf9.leadflagid IS NULL, 0, 1) ) [2] => isBogusFlag ) [14] => Array ( [0] => lstattype [1] => vis_allusers_searchresults [2] => ) [15] => Array ( [0] => lstattype [1] => vis_shareowner_searchresults [2] => ) [16] => Array ( [0] => drprem [1] => household_income [2] => rapleaf_household_income ) [17] => Array ( [0] => drprem [1] => home_owner_status [2] => rapleaf_home_owner_status ) [18] => Array ( [0] => dold [1] => ts_added [2] => ts_added_et ) [19] => Array ( [0] => sc [1] => qualityscore [2] => ) [20] => Array ( [0] => s [1] => latitude [2] => ) [21] => Array ( [0] => s [1] => longitude [2] => ) [22] => Array ( [0] => z [1] => Latitude [2] => ziplat ) [23] => Array ( [0] => z [1] => Longitude [2] => ziplon ) ) [union] => Array ( ) [from] => Array ( [l] => Array ( [joinType] => from [schema] => leads [tableName] => leads_recent [joinCondition] => ) [loc] => Array ( [joinType] => left join [schema] => leads [tableName] => data_location [joinCondition] => l.id = loc.leadid ) [dist] => Array ( [joinType] => left join [schema] => ushud [tableName] => states_distances [joinCondition] => dist.locationid1 = loc.locationid AND dist.locationid2 = 3233 ) [dcrh] => Array ( [joinType] => left join [schema] => leads [tableName] => data_credithistory [joinCondition] => l.id = dcrh.leadid ) [crh] => Array ( [joinType] => left join [schema] => leads [tableName] => _credithistory [joinCondition] => dcrh.credithistory_id = crh.id ) [dla] => Array ( [joinType] => left join [schema] => leads [tableName] => data_loanamount [joinCondition] => l.id = dla.leadid ) [la] => Array ( [joinType] => left join [schema] => leads [tableName] => _loanamount [joinCondition] => dla.loanamount_id = la.id ) [dlam] => Array ( [joinType] => left join [schema] => leads [tableName] => data_loanamount_manual [joinCondition] => l.id = dlam.leadid ) [down] => Array ( [joinType] => left join [schema] => leads [tableName] => data_ownership [joinCondition] => l.id = down.leadid ) [own] => Array ( [joinType] => left join [schema] => leads [tableName] => _ownership [joinCondition] => down.ownership_id = own.id ) [dmxs] => Array ( [joinType] => left join [schema] => leads [tableName] => data_maxshares [joinCondition] => l.id = dmxs.leadid ) [owner] => Array ( [joinType] => left join [schema] => livebuyers [tableName] => lead_transactions [joinCondition] => l.id = owner.leadid and owner.userid = 0 ) [xlf9] => Array ( [joinType] => left join [schema] => livebuyers [tableName] => xref_users_leadflags [joinCondition] => l.id = xlf9.leadid and xlf9.userid = 0 and xlf9.leadflagid = 9 ) [lstat] => Array ( [joinType] => left join [schema] => livebuyers [tableName] => lead_status [joinCondition] => l.id = lstat.leadid ) [lstattype] => Array ( [joinType] => left join [schema] => livebuyers [tableName] => _lead_status_types [joinCondition] => lstattype.status_type_id = lstat.statusid ) [drprem] => Array ( [joinType] => left join [schema] => leads [tableName] => data_rapleaf_premium [joinCondition] => l.id = drprem.leadid ) [dold] => Array ( [joinType] => left join [schema] => leads [tableName] => data_onlinedate [joinCondition] => l.id = dold.leadid and dold.usertypeid = 1 ) [sc] => Array ( [joinType] => left join [schema] => leads [tableName] => data_score [joinCondition] => l.id = sc.leadid ) [s] => Array ( [joinType] => left join [schema] => ushud [tableName] => states [joinCondition] => loc.locationid = s.locationid ) [z] => Array ( [joinType] => left join [schema] => ushud [tableName] => zips [joinCondition] => l.zip = z.zip ) ) [where] => Array ( [0] => (dist.locationid1 IS NOT NULL) [1] => AND (IF(loc.locationid = 106 and l.source_id = 3, 1, 0) <> 1) [2] => AND (IF(xlf9.leadflagid IS NULL, 0, 1) = 0) [3] => AND (s.state = 'FL') [4] => AND (crh.credithistory IN ('good')) [5] => AND (200000 BETWEEN IFNULL(la.minval, 0) AND IF(la.minval IS NULL, IFNULL(la.maxval, 0), IFNULL(la.maxval, 4294967295)) OR 200000 BETWEEN IFNULL(dlam.minval, 0) AND IF(dlam.minval IS NULL, IFNULL(dlam.maxval, 0), IFNULL(dlam.maxval, 4294967295))) [6] => AND (IF(IFNULL(vis_shareowner_searchresults, 1) = 0 AND owner.leadid IS NOT NULL, 0, 1) = 1) [7] => AND (IFNULL(vis_allusers_searchresults, 1) = 1) [8] => AND (loc.locationID != 0) [9] => AND (sc.isvalid = 1) [10] => AND (sc.underreview = 0) [11] => AND (IF(dold.ts_added IS NULL, l.ts_added, dold.ts_added) > DATE_SUB(CURDATE(), INTERVAL 120 DAY)) ) [group] => Array ( ) [having] => Array ( [0] => (numTimesSold < maxshares) ) [order] => Array ( [0] => Array ( [0] => DistSort [1] => ASC ) [1] => Array ( [0] => l.ts_added [1] => DESC ) ) [limitcount] => [limitoffset] => [forupdate] => ) [_tableCols:protected] => Array ( ) ) [_rowCount:protected] => ) dbSelectObj[119]: Qazzoo_Model_QAdapterDbselect Object ( [_countSelect:protected] => [_select:protected] => Zend_Db_Select Object ( [_bind:protected] => Array ( ) [_adapter: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 ( [_keys:protected] => Array ( [0] => numTimesSold [1] => locationid [2] => distance [3] => DistSort [4] => credithistory [5] => loanamount [6] => loanamount_manual_min [7] => loanamount_manual_max [8] => ownership [9] => maxshares [10] => isBogusFlag [11] => vis_allusers_searchresults [12] => vis_shareowner_searchresults [13] => ts_added_et ) [_values:protected] => Array ( [0] => 2 [1] => 382 [2] => 71.88672 [3] => 7 [4] => Good [5] => [6] => 200000 [7] => 349999 [8] => Own [9] => 4 [10] => 0 [11] => [12] => [13] => ) [_meta:protected] => mysqli_result Object ( [current_field] => 0 [field_count] => 14 [lengths] => [num_rows] => 0 [type] => 1 ) [_stmt:protected] => mysqli_stmt Object ( [affected_rows] => -1 [insert_id] => 0 [num_rows] => 439 [param_count] => 0 [field_count] => 14 [errno] => 0 [error] => [error_list] => Array ( ) [sqlstate] => 00000 [id] => 5 ) [_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 DISTINCT livebuyers.fn_leads_transactions_totalused(l.id, 1) AS `numTimesSold`, `loc`.`locationid`, `dist`.`distance`, `dist`.`DistSort`, `crh`.`credithistory`, `la`.`loanamount`, `dlam`.`minval` AS `loanamount_manual_min`, `dlam`.`maxval` AS `loanamount_manual_max`, `own`.`ownership`, IFNULL(dmxs.maxshares,4) AS `maxshares`, IF(xlf9.leadflagid IS NULL, 0, 1) AS `isBogusFlag`, `lstattype`.`vis_allusers_searchresults`, `lstattype`.`vis_shareowner_searchresults`, `dold`.`ts_added` AS `ts_added_et` FROM `leads`.`leads_recent` AS `l` LEFT JOIN `leads`.`data_location` AS `loc` ON l.id = loc.leadid LEFT JOIN `ushud`.`states_distances` AS `dist` ON dist.locationid1 = loc.locationid AND dist.locationid2 = 3233 LEFT JOIN `leads`.`data_credithistory` AS `dcrh` ON l.id = dcrh.leadid LEFT JOIN `leads`.`_credithistory` AS `crh` ON dcrh.credithistory_id = crh.id LEFT JOIN `leads`.`data_loanamount` AS `dla` ON l.id = dla.leadid LEFT JOIN `leads`.`_loanamount` AS `la` ON dla.loanamount_id = la.id LEFT JOIN `leads`.`data_loanamount_manual` AS `dlam` ON l.id = dlam.leadid LEFT JOIN `leads`.`data_ownership` AS `down` ON l.id = down.leadid LEFT JOIN `leads`.`_ownership` AS `own` ON down.ownership_id = own.id LEFT JOIN `leads`.`data_maxshares` AS `dmxs` ON l.id = dmxs.leadid LEFT JOIN `livebuyers`.`lead_transactions` AS `owner` ON l.id = owner.leadid and owner.userid = 0 LEFT JOIN `livebuyers`.`xref_users_leadflags` AS `xlf9` ON l.id = xlf9.leadid and xlf9.userid = 0 and xlf9.leadflagid = 9 LEFT JOIN `livebuyers`.`lead_status` AS `lstat` ON l.id = lstat.leadid LEFT JOIN `livebuyers`.`_lead_status_types` AS `lstattype` ON lstattype.status_type_id = lstat.statusid LEFT JOIN `leads`.`data_rapleaf_premium` AS `drprem` ON l.id = drprem.leadid LEFT JOIN `leads`.`data_onlinedate` AS `dold` ON l.id = dold.leadid and dold.usertypeid = 1 LEFT JOIN `leads`.`data_score` AS `sc` ON l.id = sc.leadid LEFT JOIN `ushud`.`states` AS `s` ON loc.locationid = s.locationid WHERE (dist.locationid1 IS NOT NULL) AND (IF(loc.locationid = 106 and l.source_id = 3, 1, 0) <> 1) AND (IF(xlf9.leadflagid IS NULL, 0, 1) = 0) AND (s.state = ) AND (crh.credithistory IN ()) AND (200000 BETWEEN IFNULL(la.minval, 0) AND IF(la.minval IS NULL, IFNULL(la.maxval, 0), IFNULL(la.maxval, 4294967295)) OR 200000 BETWEEN IFNULL(dlam.minval, 0) AND IF(dlam.minval IS NULL, IFNULL(dlam.maxval, 0), IFNULL(dlam.maxval, 4294967295))) AND (IF(IFNULL(vis_shareowner_searchresults, 1) = 0 AND owner.leadid IS NOT NULL, 0, 1) = 1) AND (IFNULL(vis_allusers_searchresults, 1) = 1) AND (loc.locationID != 0) AND (sc.isvalid = 1) AND (sc.underreview = 0) AND (IF(dold.ts_added IS NULL, l.ts_added, dold.ts_added) > DATE_SUB(CURDATE(), INTERVAL 120 DAY)) HAVING (numTimesSold < maxshares) ) [_sqlParam:protected] => Array ( [0] => SELECT DISTINCT livebuyers.fn_leads_transactions_totalused(l.id, 1) AS `numTimesSold`, `loc`.`locationid`, `dist`.`distance`, `dist`.`DistSort`, `crh`.`credithistory`, `la`.`loanamount`, `dlam`.`minval` AS `loanamount_manual_min`, `dlam`.`maxval` AS `loanamount_manual_max`, `own`.`ownership`, IFNULL(dmxs.maxshares,4) AS `maxshares`, IF(xlf9.leadflagid IS NULL, 0, 1) AS `isBogusFlag`, `lstattype`.`vis_allusers_searchresults`, `lstattype`.`vis_shareowner_searchresults`, `dold`.`ts_added` AS `ts_added_et` FROM `leads`.`leads_recent` AS `l` LEFT JOIN `leads`.`data_location` AS `loc` ON l.id = loc.leadid LEFT JOIN `ushud`.`states_distances` AS `dist` ON dist.locationid1 = loc.locationid AND dist.locationid2 = 3233 LEFT JOIN `leads`.`data_credithistory` AS `dcrh` ON l.id = dcrh.leadid LEFT JOIN `leads`.`_credithistory` AS `crh` ON dcrh.credithistory_id = crh.id LEFT JOIN `leads`.`data_loanamount` AS `dla` ON l.id = dla.leadid LEFT JOIN `leads`.`_loanamount` AS `la` ON dla.loanamount_id = la.id LEFT JOIN `leads`.`data_loanamount_manual` AS `dlam` ON l.id = dlam.leadid LEFT JOIN `leads`.`data_ownership` AS `down` ON l.id = down.leadid LEFT JOIN `leads`.`_ownership` AS `own` ON down.ownership_id = own.id LEFT JOIN `leads`.`data_maxshares` AS `dmxs` ON l.id = dmxs.leadid LEFT JOIN `livebuyers`.`lead_transactions` AS `owner` ON l.id = owner.leadid and owner.userid = 0 LEFT JOIN `livebuyers`.`xref_users_leadflags` AS `xlf9` ON l.id = xlf9.leadid and xlf9.userid = 0 and xlf9.leadflagid = 9 LEFT JOIN `livebuyers`.`lead_status` AS `lstat` ON l.id = lstat.leadid LEFT JOIN `livebuyers`.`_lead_status_types` AS `lstattype` ON lstattype.status_type_id = lstat.statusid LEFT JOIN `leads`.`data_rapleaf_premium` AS `drprem` ON l.id = drprem.leadid LEFT JOIN `leads`.`data_onlinedate` AS `dold` ON l.id = dold.leadid and dold.usertypeid = 1 LEFT JOIN `leads`.`data_score` AS `sc` ON l.id = sc.leadid LEFT JOIN `ushud`.`states` AS `s` ON loc.locationid = s.locationid WHERE (dist.locationid1 IS NOT NULL) AND (IF(loc.locationid = 106 and l.source_id = 3, 1, 0) <> 1) AND (IF(xlf9.leadflagid IS NULL, 0, 1) = 0) AND (s.state = ) AND (crh.credithistory IN ()) AND (200000 BETWEEN IFNULL(la.minval, 0) AND IF(la.minval IS NULL, IFNULL(la.maxval, 0), IFNULL(la.maxval, 4294967295)) OR 200000 BETWEEN IFNULL(dlam.minval, 0) AND IF(dlam.minval IS NULL, IFNULL(dlam.maxval, 0), IFNULL(dlam.maxval, 4294967295))) AND (IF(IFNULL(vis_shareowner_searchresults, 1) = 0 AND owner.leadid IS NOT NULL, 0, 1) = 1) AND (IFNULL(vis_allusers_searchresults, 1) = 1) AND (loc.locationID != 0) AND (sc.isvalid = 1) AND (sc.underreview = 0) AND (IF(dold.ts_added IS NULL, l.ts_added, dold.ts_added) > DATE_SUB(CURDATE(), INTERVAL 120 DAY)) HAVING (numTimesSold < maxshares) ) [_queryId:protected] => 4 ) [_defaultStmtClass:protected] => Zend_Db_Statement_Mysqli [_config:protected] => Array ( [host] => a98001a1f89847065bbf32aef6b9916b464f102e.rackspaceclouddb.com [username] => livebuyers [password] => mmbc,hy@m [dbname] => livebuyers [charset] => [persistent] => [options] => Array ( [caseFolding] => 0 [autoQuoteIdentifiers] => 1 [fetchMode] => 2 ) [driver_options] => Array ( ) ) [_fetchMode:protected] => 2 [_profiler:protected] => Qazzoo_Model_DbProfiler Object ( [_log:protected] => [_totalElapsedTime:protected] => [_queryProfiles:protected] => Array ( [0] => Zend_Db_Profiler_Query Object ( [_query:protected] => SELECT `session`.* FROM `session` WHERE (((`session`.`session_id` = 'fsh46raudmuj5qiqopq9miks86' AND `session`.`save_path` = '/var/www/myqazzoo/application/../data/session/' AND `session`.`name` = 'PHPSESSID'))) [_queryType:protected] => 32 [_startedMicrotime:protected] => 1771794664.0182 [_endedMicrotime:protected] => 1771794664.0187 [_boundParams:protected] => Array ( ) ) [1] => Zend_Db_Profiler_Query Object ( [_query:protected] => SELECT `seo_page_info`.* FROM `seo_page_info` WHERE (mca_string = 'default/leads/index') LIMIT 1 [_queryType:protected] => 32 [_startedMicrotime:protected] => 1771794664.0356 [_endedMicrotime:protected] => 1771794664.0361 [_boundParams:protected] => Array ( ) ) [2] => Zend_Db_Profiler_Query Object ( [_query:protected] => SELECT locationid FROM ushud.zips WHERE zip = '91001' LIMIT 1; [_queryType:protected] => 32 [_startedMicrotime:protected] => 1771794664.0486 [_endedMicrotime:protected] => 1771794664.049 [_boundParams:protected] => Array ( ) ) [3] => Zend_Db_Profiler_Query Object ( [_query:protected] => SELECT * from ushud.states where locationID = ? [_queryType:protected] => 32 [_startedMicrotime:protected] => 1771794664.0511 [_endedMicrotime:protected] => 1771794664.0516 [_boundParams:protected] => Array ( [1] => 3233 ) ) [4] => Zend_Db_Profiler_Query Object ( [_query:protected] => SELECT DISTINCT livebuyers.fn_leads_transactions_totalused(l.id, 1) AS `numTimesSold`, `loc`.`locationid`, `dist`.`distance`, `dist`.`DistSort`, `crh`.`credithistory`, `la`.`loanamount`, `dlam`.`minval` AS `loanamount_manual_min`, `dlam`.`maxval` AS `loanamount_manual_max`, `own`.`ownership`, IFNULL(dmxs.maxshares,4) AS `maxshares`, IF(xlf9.leadflagid IS NULL, 0, 1) AS `isBogusFlag`, `lstattype`.`vis_allusers_searchresults`, `lstattype`.`vis_shareowner_searchresults`, `dold`.`ts_added` AS `ts_added_et` FROM `leads`.`leads_recent` AS `l` LEFT JOIN `leads`.`data_location` AS `loc` ON l.id = loc.leadid LEFT JOIN `ushud`.`states_distances` AS `dist` ON dist.locationid1 = loc.locationid AND dist.locationid2 = 3233 LEFT JOIN `leads`.`data_credithistory` AS `dcrh` ON l.id = dcrh.leadid LEFT JOIN `leads`.`_credithistory` AS `crh` ON dcrh.credithistory_id = crh.id LEFT JOIN `leads`.`data_loanamount` AS `dla` ON l.id = dla.leadid LEFT JOIN `leads`.`_loanamount` AS `la` ON dla.loanamount_id = la.id LEFT JOIN `leads`.`data_loanamount_manual` AS `dlam` ON l.id = dlam.leadid LEFT JOIN `leads`.`data_ownership` AS `down` ON l.id = down.leadid LEFT JOIN `leads`.`_ownership` AS `own` ON down.ownership_id = own.id LEFT JOIN `leads`.`data_maxshares` AS `dmxs` ON l.id = dmxs.leadid LEFT JOIN `livebuyers`.`lead_transactions` AS `owner` ON l.id = owner.leadid and owner.userid = 0 LEFT JOIN `livebuyers`.`xref_users_leadflags` AS `xlf9` ON l.id = xlf9.leadid and xlf9.userid = 0 and xlf9.leadflagid = 9 LEFT JOIN `livebuyers`.`lead_status` AS `lstat` ON l.id = lstat.leadid LEFT JOIN `livebuyers`.`_lead_status_types` AS `lstattype` ON lstattype.status_type_id = lstat.statusid LEFT JOIN `leads`.`data_rapleaf_premium` AS `drprem` ON l.id = drprem.leadid LEFT JOIN `leads`.`data_onlinedate` AS `dold` ON l.id = dold.leadid and dold.usertypeid = 1 LEFT JOIN `leads`.`data_score` AS `sc` ON l.id = sc.leadid LEFT JOIN `ushud`.`states` AS `s` ON loc.locationid = s.locationid WHERE (dist.locationid1 IS NOT NULL) AND (IF(loc.locationid = 106 and l.source_id = 3, 1, 0) <> 1) AND (IF(xlf9.leadflagid IS NULL, 0, 1) = 0) AND (s.state = 'FL') AND (crh.credithistory IN ('good')) AND (200000 BETWEEN IFNULL(la.minval, 0) AND IF(la.minval IS NULL, IFNULL(la.maxval, 0), IFNULL(la.maxval, 4294967295)) OR 200000 BETWEEN IFNULL(dlam.minval, 0) AND IF(dlam.minval IS NULL, IFNULL(dlam.maxval, 0), IFNULL(dlam.maxval, 4294967295))) AND (IF(IFNULL(vis_shareowner_searchresults, 1) = 0 AND owner.leadid IS NOT NULL, 0, 1) = 1) AND (IFNULL(vis_allusers_searchresults, 1) = 1) AND (loc.locationID != 0) AND (sc.isvalid = 1) AND (sc.underreview = 0) AND (IF(dold.ts_added IS NULL, l.ts_added, dold.ts_added) > DATE_SUB(CURDATE(), INTERVAL 120 DAY)) HAVING (numTimesSold < maxshares) [_queryType:protected] => 32 [_startedMicrotime:protected] => 1771794664.057 [_endedMicrotime:protected] => 1771794664.9419 [_boundParams:protected] => Array ( ) ) ) [_enabled:protected] => 1 [_filterElapsedSecs:protected] => [_filterTypes:protected] => ) [_defaultProfilerClass:protected] => Zend_Db_Profiler [_connection:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 7.4.33 [client_version] => 70433 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 14 [host_info] => a98001a1f89847065bbf32aef6b9916b464f102e.rackspaceclouddb.com via TCP/IP [info] => [insert_id] => 0 [server_info] => 8.0.18 [server_version] => 80018 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 464943973 [warning_count] => 0 ) [_caseFolding:protected] => 0 [_autoQuoteIdentifiers:protected] => 1 [_allowSerialization:protected] => 1 [_autoReconnectOnUnserialize:protected] => ) [_parts:protected] => Array ( [distinct] => 1 [columns] => Array ( [0] => Array ( [0] => l [1] => * [2] => ) [1] => Array ( [0] => l [1] => Zend_Db_Expr Object ( [_expression:protected] => IF(dold.ts_added IS NULL, l.ts_added, dold.ts_added) ) [2] => time ) [2] => Array ( [0] => l [1] => id [2] => leadID ) [3] => Array ( [0] => l [1] => Zend_Db_Expr Object ( [_expression:protected] => livebuyers.fn_leads_transactions_totalused(l.id, 1) ) [2] => numTimesSold ) [4] => Array ( [0] => loc [1] => locationid [2] => ) [5] => Array ( [0] => dist [1] => distance [2] => ) [6] => Array ( [0] => dist [1] => DistSort [2] => ) [7] => Array ( [0] => crh [1] => credithistory [2] => ) [8] => Array ( [0] => la [1] => loanamount [2] => ) [9] => Array ( [0] => dlam [1] => minval [2] => loanamount_manual_min ) [10] => Array ( [0] => dlam [1] => maxval [2] => loanamount_manual_max ) [11] => Array ( [0] => own [1] => ownership [2] => ) [12] => Array ( [0] => dmxs [1] => Zend_Db_Expr Object ( [_expression:protected] => IFNULL(dmxs.maxshares,4) ) [2] => maxshares ) [13] => Array ( [0] => xlf9 [1] => Zend_Db_Expr Object ( [_expression:protected] => IF(xlf9.leadflagid IS NULL, 0, 1) ) [2] => isBogusFlag ) [14] => Array ( [0] => lstattype [1] => vis_allusers_searchresults [2] => ) [15] => Array ( [0] => lstattype [1] => vis_shareowner_searchresults [2] => ) [16] => Array ( [0] => drprem [1] => household_income [2] => rapleaf_household_income ) [17] => Array ( [0] => drprem [1] => home_owner_status [2] => rapleaf_home_owner_status ) [18] => Array ( [0] => dold [1] => ts_added [2] => ts_added_et ) [19] => Array ( [0] => sc [1] => qualityscore [2] => ) [20] => Array ( [0] => s [1] => latitude [2] => ) [21] => Array ( [0] => s [1] => longitude [2] => ) [22] => Array ( [0] => z [1] => Latitude [2] => ziplat ) [23] => Array ( [0] => z [1] => Longitude [2] => ziplon ) ) [union] => Array ( ) [from] => Array ( [l] => Array ( [joinType] => from [schema] => leads [tableName] => leads_recent [joinCondition] => ) [loc] => Array ( [joinType] => left join [schema] => leads [tableName] => data_location [joinCondition] => l.id = loc.leadid ) [dist] => Array ( [joinType] => left join [schema] => ushud [tableName] => states_distances [joinCondition] => dist.locationid1 = loc.locationid AND dist.locationid2 = 3233 ) [dcrh] => Array ( [joinType] => left join [schema] => leads [tableName] => data_credithistory [joinCondition] => l.id = dcrh.leadid ) [crh] => Array ( [joinType] => left join [schema] => leads [tableName] => _credithistory [joinCondition] => dcrh.credithistory_id = crh.id ) [dla] => Array ( [joinType] => left join [schema] => leads [tableName] => data_loanamount [joinCondition] => l.id = dla.leadid ) [la] => Array ( [joinType] => left join [schema] => leads [tableName] => _loanamount [joinCondition] => dla.loanamount_id = la.id ) [dlam] => Array ( [joinType] => left join [schema] => leads [tableName] => data_loanamount_manual [joinCondition] => l.id = dlam.leadid ) [down] => Array ( [joinType] => left join [schema] => leads [tableName] => data_ownership [joinCondition] => l.id = down.leadid ) [own] => Array ( [joinType] => left join [schema] => leads [tableName] => _ownership [joinCondition] => down.ownership_id = own.id ) [dmxs] => Array ( [joinType] => left join [schema] => leads [tableName] => data_maxshares [joinCondition] => l.id = dmxs.leadid ) [owner] => Array ( [joinType] => left join [schema] => livebuyers [tableName] => lead_transactions [joinCondition] => l.id = owner.leadid and owner.userid = 0 ) [xlf9] => Array ( [joinType] => left join [schema] => livebuyers [tableName] => xref_users_leadflags [joinCondition] => l.id = xlf9.leadid and xlf9.userid = 0 and xlf9.leadflagid = 9 ) [lstat] => Array ( [joinType] => left join [schema] => livebuyers [tableName] => lead_status [joinCondition] => l.id = lstat.leadid ) [lstattype] => Array ( [joinType] => left join [schema] => livebuyers [tableName] => _lead_status_types [joinCondition] => lstattype.status_type_id = lstat.statusid ) [drprem] => Array ( [joinType] => left join [schema] => leads [tableName] => data_rapleaf_premium [joinCondition] => l.id = drprem.leadid ) [dold] => Array ( [joinType] => left join [schema] => leads [tableName] => data_onlinedate [joinCondition] => l.id = dold.leadid and dold.usertypeid = 1 ) [sc] => Array ( [joinType] => left join [schema] => leads [tableName] => data_score [joinCondition] => l.id = sc.leadid ) [s] => Array ( [joinType] => left join [schema] => ushud [tableName] => states [joinCondition] => loc.locationid = s.locationid ) [z] => Array ( [joinType] => left join [schema] => ushud [tableName] => zips [joinCondition] => l.zip = z.zip ) ) [where] => Array ( [0] => (dist.locationid1 IS NOT NULL) [1] => AND (IF(loc.locationid = 106 and l.source_id = 3, 1, 0) <> 1) [2] => AND (IF(xlf9.leadflagid IS NULL, 0, 1) = 0) [3] => AND (s.state = 'FL') [4] => AND (crh.credithistory IN ('good')) [5] => AND (200000 BETWEEN IFNULL(la.minval, 0) AND IF(la.minval IS NULL, IFNULL(la.maxval, 0), IFNULL(la.maxval, 4294967295)) OR 200000 BETWEEN IFNULL(dlam.minval, 0) AND IF(dlam.minval IS NULL, IFNULL(dlam.maxval, 0), IFNULL(dlam.maxval, 4294967295))) [6] => AND (IF(IFNULL(vis_shareowner_searchresults, 1) = 0 AND owner.leadid IS NOT NULL, 0, 1) = 1) [7] => AND (IFNULL(vis_allusers_searchresults, 1) = 1) [8] => AND (loc.locationID != 0) [9] => AND (sc.isvalid = 1) [10] => AND (sc.underreview = 0) [11] => AND (IF(dold.ts_added IS NULL, l.ts_added, dold.ts_added) > DATE_SUB(CURDATE(), INTERVAL 120 DAY)) ) [group] => Array ( ) [having] => Array ( [0] => (numTimesSold < maxshares) ) [order] => Array ( [0] => Array ( [0] => DistSort [1] => ASC ) [1] => Array ( [0] => l.ts_added [1] => DESC ) ) [limitcount] => [limitoffset] => [forupdate] => ) [_tableCols:protected] => Array ( ) ) [_rowCount:protected] => 439 ) Paginator: Qazzoo_Model_QPaginator Object ( [select] => [cacheId] => [_cacheEnabled:protected] => 1 [_adapter:protected] => Qazzoo_Model_QAdapterDbselect Object ( [_countSelect:protected] => [_select:protected] => Zend_Db_Select Object ( [_bind:protected] => Array ( ) [_adapter: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 ( [_keys:protected] => Array ( [0] => numTimesSold [1] => locationid [2] => distance [3] => DistSort [4] => credithistory [5] => loanamount [6] => loanamount_manual_min [7] => loanamount_manual_max [8] => ownership [9] => maxshares [10] => isBogusFlag [11] => vis_allusers_searchresults [12] => vis_shareowner_searchresults [13] => ts_added_et ) [_values:protected] => Array ( [0] => 2 [1] => 382 [2] => 71.88672 [3] => 7 [4] => Good [5] => [6] => 200000 [7] => 349999 [8] => Own [9] => 4 [10] => 0 [11] => [12] => [13] => ) [_meta:protected] => mysqli_result Object ( [current_field] => 0 [field_count] => 14 [lengths] => [num_rows] => 0 [type] => 1 ) [_stmt:protected] => mysqli_stmt Object ( [affected_rows] => -1 [insert_id] => 0 [num_rows] => 439 [param_count] => 0 [field_count] => 14 [errno] => 0 [error] => [error_list] => Array ( ) [sqlstate] => 00000 [id] => 5 ) [_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 DISTINCT livebuyers.fn_leads_transactions_totalused(l.id, 1) AS `numTimesSold`, `loc`.`locationid`, `dist`.`distance`, `dist`.`DistSort`, `crh`.`credithistory`, `la`.`loanamount`, `dlam`.`minval` AS `loanamount_manual_min`, `dlam`.`maxval` AS `loanamount_manual_max`, `own`.`ownership`, IFNULL(dmxs.maxshares,4) AS `maxshares`, IF(xlf9.leadflagid IS NULL, 0, 1) AS `isBogusFlag`, `lstattype`.`vis_allusers_searchresults`, `lstattype`.`vis_shareowner_searchresults`, `dold`.`ts_added` AS `ts_added_et` FROM `leads`.`leads_recent` AS `l` LEFT JOIN `leads`.`data_location` AS `loc` ON l.id = loc.leadid LEFT JOIN `ushud`.`states_distances` AS `dist` ON dist.locationid1 = loc.locationid AND dist.locationid2 = 3233 LEFT JOIN `leads`.`data_credithistory` AS `dcrh` ON l.id = dcrh.leadid LEFT JOIN `leads`.`_credithistory` AS `crh` ON dcrh.credithistory_id = crh.id LEFT JOIN `leads`.`data_loanamount` AS `dla` ON l.id = dla.leadid LEFT JOIN `leads`.`_loanamount` AS `la` ON dla.loanamount_id = la.id LEFT JOIN `leads`.`data_loanamount_manual` AS `dlam` ON l.id = dlam.leadid LEFT JOIN `leads`.`data_ownership` AS `down` ON l.id = down.leadid LEFT JOIN `leads`.`_ownership` AS `own` ON down.ownership_id = own.id LEFT JOIN `leads`.`data_maxshares` AS `dmxs` ON l.id = dmxs.leadid LEFT JOIN `livebuyers`.`lead_transactions` AS `owner` ON l.id = owner.leadid and owner.userid = 0 LEFT JOIN `livebuyers`.`xref_users_leadflags` AS `xlf9` ON l.id = xlf9.leadid and xlf9.userid = 0 and xlf9.leadflagid = 9 LEFT JOIN `livebuyers`.`lead_status` AS `lstat` ON l.id = lstat.leadid LEFT JOIN `livebuyers`.`_lead_status_types` AS `lstattype` ON lstattype.status_type_id = lstat.statusid LEFT JOIN `leads`.`data_rapleaf_premium` AS `drprem` ON l.id = drprem.leadid LEFT JOIN `leads`.`data_onlinedate` AS `dold` ON l.id = dold.leadid and dold.usertypeid = 1 LEFT JOIN `leads`.`data_score` AS `sc` ON l.id = sc.leadid LEFT JOIN `ushud`.`states` AS `s` ON loc.locationid = s.locationid WHERE (dist.locationid1 IS NOT NULL) AND (IF(loc.locationid = 106 and l.source_id = 3, 1, 0) <> 1) AND (IF(xlf9.leadflagid IS NULL, 0, 1) = 0) AND (s.state = ) AND (crh.credithistory IN ()) AND (200000 BETWEEN IFNULL(la.minval, 0) AND IF(la.minval IS NULL, IFNULL(la.maxval, 0), IFNULL(la.maxval, 4294967295)) OR 200000 BETWEEN IFNULL(dlam.minval, 0) AND IF(dlam.minval IS NULL, IFNULL(dlam.maxval, 0), IFNULL(dlam.maxval, 4294967295))) AND (IF(IFNULL(vis_shareowner_searchresults, 1) = 0 AND owner.leadid IS NOT NULL, 0, 1) = 1) AND (IFNULL(vis_allusers_searchresults, 1) = 1) AND (loc.locationID != 0) AND (sc.isvalid = 1) AND (sc.underreview = 0) AND (IF(dold.ts_added IS NULL, l.ts_added, dold.ts_added) > DATE_SUB(CURDATE(), INTERVAL 120 DAY)) HAVING (numTimesSold < maxshares) ) [_sqlParam:protected] => Array ( [0] => SELECT DISTINCT livebuyers.fn_leads_transactions_totalused(l.id, 1) AS `numTimesSold`, `loc`.`locationid`, `dist`.`distance`, `dist`.`DistSort`, `crh`.`credithistory`, `la`.`loanamount`, `dlam`.`minval` AS `loanamount_manual_min`, `dlam`.`maxval` AS `loanamount_manual_max`, `own`.`ownership`, IFNULL(dmxs.maxshares,4) AS `maxshares`, IF(xlf9.leadflagid IS NULL, 0, 1) AS `isBogusFlag`, `lstattype`.`vis_allusers_searchresults`, `lstattype`.`vis_shareowner_searchresults`, `dold`.`ts_added` AS `ts_added_et` FROM `leads`.`leads_recent` AS `l` LEFT JOIN `leads`.`data_location` AS `loc` ON l.id = loc.leadid LEFT JOIN `ushud`.`states_distances` AS `dist` ON dist.locationid1 = loc.locationid AND dist.locationid2 = 3233 LEFT JOIN `leads`.`data_credithistory` AS `dcrh` ON l.id = dcrh.leadid LEFT JOIN `leads`.`_credithistory` AS `crh` ON dcrh.credithistory_id = crh.id LEFT JOIN `leads`.`data_loanamount` AS `dla` ON l.id = dla.leadid LEFT JOIN `leads`.`_loanamount` AS `la` ON dla.loanamount_id = la.id LEFT JOIN `leads`.`data_loanamount_manual` AS `dlam` ON l.id = dlam.leadid LEFT JOIN `leads`.`data_ownership` AS `down` ON l.id = down.leadid LEFT JOIN `leads`.`_ownership` AS `own` ON down.ownership_id = own.id LEFT JOIN `leads`.`data_maxshares` AS `dmxs` ON l.id = dmxs.leadid LEFT JOIN `livebuyers`.`lead_transactions` AS `owner` ON l.id = owner.leadid and owner.userid = 0 LEFT JOIN `livebuyers`.`xref_users_leadflags` AS `xlf9` ON l.id = xlf9.leadid and xlf9.userid = 0 and xlf9.leadflagid = 9 LEFT JOIN `livebuyers`.`lead_status` AS `lstat` ON l.id = lstat.leadid LEFT JOIN `livebuyers`.`_lead_status_types` AS `lstattype` ON lstattype.status_type_id = lstat.statusid LEFT JOIN `leads`.`data_rapleaf_premium` AS `drprem` ON l.id = drprem.leadid LEFT JOIN `leads`.`data_onlinedate` AS `dold` ON l.id = dold.leadid and dold.usertypeid = 1 LEFT JOIN `leads`.`data_score` AS `sc` ON l.id = sc.leadid LEFT JOIN `ushud`.`states` AS `s` ON loc.locationid = s.locationid WHERE (dist.locationid1 IS NOT NULL) AND (IF(loc.locationid = 106 and l.source_id = 3, 1, 0) <> 1) AND (IF(xlf9.leadflagid IS NULL, 0, 1) = 0) AND (s.state = ) AND (crh.credithistory IN ()) AND (200000 BETWEEN IFNULL(la.minval, 0) AND IF(la.minval IS NULL, IFNULL(la.maxval, 0), IFNULL(la.maxval, 4294967295)) OR 200000 BETWEEN IFNULL(dlam.minval, 0) AND IF(dlam.minval IS NULL, IFNULL(dlam.maxval, 0), IFNULL(dlam.maxval, 4294967295))) AND (IF(IFNULL(vis_shareowner_searchresults, 1) = 0 AND owner.leadid IS NOT NULL, 0, 1) = 1) AND (IFNULL(vis_allusers_searchresults, 1) = 1) AND (loc.locationID != 0) AND (sc.isvalid = 1) AND (sc.underreview = 0) AND (IF(dold.ts_added IS NULL, l.ts_added, dold.ts_added) > DATE_SUB(CURDATE(), INTERVAL 120 DAY)) HAVING (numTimesSold < maxshares) ) [_queryId:protected] => 4 ) [_defaultStmtClass:protected] => Zend_Db_Statement_Mysqli [_config:protected] => Array ( [host] => a98001a1f89847065bbf32aef6b9916b464f102e.rackspaceclouddb.com [username] => livebuyers [password] => mmbc,hy@m [dbname] => livebuyers [charset] => [persistent] => [options] => Array ( [caseFolding] => 0 [autoQuoteIdentifiers] => 1 [fetchMode] => 2 ) [driver_options] => Array ( ) ) [_fetchMode:protected] => 2 [_profiler:protected] => Qazzoo_Model_DbProfiler Object ( [_log:protected] => [_totalElapsedTime:protected] => [_queryProfiles:protected] => Array ( [0] => Zend_Db_Profiler_Query Object ( [_query:protected] => SELECT `session`.* FROM `session` WHERE (((`session`.`session_id` = 'fsh46raudmuj5qiqopq9miks86' AND `session`.`save_path` = '/var/www/myqazzoo/application/../data/session/' AND `session`.`name` = 'PHPSESSID'))) [_queryType:protected] => 32 [_startedMicrotime:protected] => 1771794664.0182 [_endedMicrotime:protected] => 1771794664.0187 [_boundParams:protected] => Array ( ) ) [1] => Zend_Db_Profiler_Query Object ( [_query:protected] => SELECT `seo_page_info`.* FROM `seo_page_info` WHERE (mca_string = 'default/leads/index') LIMIT 1 [_queryType:protected] => 32 [_startedMicrotime:protected] => 1771794664.0356 [_endedMicrotime:protected] => 1771794664.0361 [_boundParams:protected] => Array ( ) ) [2] => Zend_Db_Profiler_Query Object ( [_query:protected] => SELECT locationid FROM ushud.zips WHERE zip = '91001' LIMIT 1; [_queryType:protected] => 32 [_startedMicrotime:protected] => 1771794664.0486 [_endedMicrotime:protected] => 1771794664.049 [_boundParams:protected] => Array ( ) ) [3] => Zend_Db_Profiler_Query Object ( [_query:protected] => SELECT * from ushud.states where locationID = ? [_queryType:protected] => 32 [_startedMicrotime:protected] => 1771794664.0511 [_endedMicrotime:protected] => 1771794664.0516 [_boundParams:protected] => Array ( [1] => 3233 ) ) [4] => Zend_Db_Profiler_Query Object ( [_query:protected] => SELECT DISTINCT livebuyers.fn_leads_transactions_totalused(l.id, 1) AS `numTimesSold`, `loc`.`locationid`, `dist`.`distance`, `dist`.`DistSort`, `crh`.`credithistory`, `la`.`loanamount`, `dlam`.`minval` AS `loanamount_manual_min`, `dlam`.`maxval` AS `loanamount_manual_max`, `own`.`ownership`, IFNULL(dmxs.maxshares,4) AS `maxshares`, IF(xlf9.leadflagid IS NULL, 0, 1) AS `isBogusFlag`, `lstattype`.`vis_allusers_searchresults`, `lstattype`.`vis_shareowner_searchresults`, `dold`.`ts_added` AS `ts_added_et` FROM `leads`.`leads_recent` AS `l` LEFT JOIN `leads`.`data_location` AS `loc` ON l.id = loc.leadid LEFT JOIN `ushud`.`states_distances` AS `dist` ON dist.locationid1 = loc.locationid AND dist.locationid2 = 3233 LEFT JOIN `leads`.`data_credithistory` AS `dcrh` ON l.id = dcrh.leadid LEFT JOIN `leads`.`_credithistory` AS `crh` ON dcrh.credithistory_id = crh.id LEFT JOIN `leads`.`data_loanamount` AS `dla` ON l.id = dla.leadid LEFT JOIN `leads`.`_loanamount` AS `la` ON dla.loanamount_id = la.id LEFT JOIN `leads`.`data_loanamount_manual` AS `dlam` ON l.id = dlam.leadid LEFT JOIN `leads`.`data_ownership` AS `down` ON l.id = down.leadid LEFT JOIN `leads`.`_ownership` AS `own` ON down.ownership_id = own.id LEFT JOIN `leads`.`data_maxshares` AS `dmxs` ON l.id = dmxs.leadid LEFT JOIN `livebuyers`.`lead_transactions` AS `owner` ON l.id = owner.leadid and owner.userid = 0 LEFT JOIN `livebuyers`.`xref_users_leadflags` AS `xlf9` ON l.id = xlf9.leadid and xlf9.userid = 0 and xlf9.leadflagid = 9 LEFT JOIN `livebuyers`.`lead_status` AS `lstat` ON l.id = lstat.leadid LEFT JOIN `livebuyers`.`_lead_status_types` AS `lstattype` ON lstattype.status_type_id = lstat.statusid LEFT JOIN `leads`.`data_rapleaf_premium` AS `drprem` ON l.id = drprem.leadid LEFT JOIN `leads`.`data_onlinedate` AS `dold` ON l.id = dold.leadid and dold.usertypeid = 1 LEFT JOIN `leads`.`data_score` AS `sc` ON l.id = sc.leadid LEFT JOIN `ushud`.`states` AS `s` ON loc.locationid = s.locationid WHERE (dist.locationid1 IS NOT NULL) AND (IF(loc.locationid = 106 and l.source_id = 3, 1, 0) <> 1) AND (IF(xlf9.leadflagid IS NULL, 0, 1) = 0) AND (s.state = 'FL') AND (crh.credithistory IN ('good')) AND (200000 BETWEEN IFNULL(la.minval, 0) AND IF(la.minval IS NULL, IFNULL(la.maxval, 0), IFNULL(la.maxval, 4294967295)) OR 200000 BETWEEN IFNULL(dlam.minval, 0) AND IF(dlam.minval IS NULL, IFNULL(dlam.maxval, 0), IFNULL(dlam.maxval, 4294967295))) AND (IF(IFNULL(vis_shareowner_searchresults, 1) = 0 AND owner.leadid IS NOT NULL, 0, 1) = 1) AND (IFNULL(vis_allusers_searchresults, 1) = 1) AND (loc.locationID != 0) AND (sc.isvalid = 1) AND (sc.underreview = 0) AND (IF(dold.ts_added IS NULL, l.ts_added, dold.ts_added) > DATE_SUB(CURDATE(), INTERVAL 120 DAY)) HAVING (numTimesSold < maxshares) [_queryType:protected] => 32 [_startedMicrotime:protected] => 1771794664.057 [_endedMicrotime:protected] => 1771794664.9419 [_boundParams:protected] => Array ( ) ) ) [_enabled:protected] => 1 [_filterElapsedSecs:protected] => [_filterTypes:protected] => ) [_defaultProfilerClass:protected] => Zend_Db_Profiler [_connection:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 7.4.33 [client_version] => 70433 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 14 [host_info] => a98001a1f89847065bbf32aef6b9916b464f102e.rackspaceclouddb.com via TCP/IP [info] => [insert_id] => 0 [server_info] => 8.0.18 [server_version] => 80018 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 464943973 [warning_count] => 0 ) [_caseFolding:protected] => 0 [_autoQuoteIdentifiers:protected] => 1 [_allowSerialization:protected] => 1 [_autoReconnectOnUnserialize:protected] => ) [_parts:protected] => Array ( [distinct] => 1 [columns] => Array ( [0] => Array ( [0] => l [1] => * [2] => ) [1] => Array ( [0] => l [1] => Zend_Db_Expr Object ( [_expression:protected] => IF(dold.ts_added IS NULL, l.ts_added, dold.ts_added) ) [2] => time ) [2] => Array ( [0] => l [1] => id [2] => leadID ) [3] => Array ( [0] => l [1] => Zend_Db_Expr Object ( [_expression:protected] => livebuyers.fn_leads_transactions_totalused(l.id, 1) ) [2] => numTimesSold ) [4] => Array ( [0] => loc [1] => locationid [2] => ) [5] => Array ( [0] => dist [1] => distance [2] => ) [6] => Array ( [0] => dist [1] => DistSort [2] => ) [7] => Array ( [0] => crh [1] => credithistory [2] => ) [8] => Array ( [0] => la [1] => loanamount [2] => ) [9] => Array ( [0] => dlam [1] => minval [2] => loanamount_manual_min ) [10] => Array ( [0] => dlam [1] => maxval [2] => loanamount_manual_max ) [11] => Array ( [0] => own [1] => ownership [2] => ) [12] => Array ( [0] => dmxs [1] => Zend_Db_Expr Object ( [_expression:protected] => IFNULL(dmxs.maxshares,4) ) [2] => maxshares ) [13] => Array ( [0] => xlf9 [1] => Zend_Db_Expr Object ( [_expression:protected] => IF(xlf9.leadflagid IS NULL, 0, 1) ) [2] => isBogusFlag ) [14] => Array ( [0] => lstattype [1] => vis_allusers_searchresults [2] => ) [15] => Array ( [0] => lstattype [1] => vis_shareowner_searchresults [2] => ) [16] => Array ( [0] => drprem [1] => household_income [2] => rapleaf_household_income ) [17] => Array ( [0] => drprem [1] => home_owner_status [2] => rapleaf_home_owner_status ) [18] => Array ( [0] => dold [1] => ts_added [2] => ts_added_et ) [19] => Array ( [0] => sc [1] => qualityscore [2] => ) [20] => Array ( [0] => s [1] => latitude [2] => ) [21] => Array ( [0] => s [1] => longitude [2] => ) [22] => Array ( [0] => z [1] => Latitude [2] => ziplat ) [23] => Array ( [0] => z [1] => Longitude [2] => ziplon ) ) [union] => Array ( ) [from] => Array ( [l] => Array ( [joinType] => from [schema] => leads [tableName] => leads_recent [joinCondition] => ) [loc] => Array ( [joinType] => left join [schema] => leads [tableName] => data_location [joinCondition] => l.id = loc.leadid ) [dist] => Array ( [joinType] => left join [schema] => ushud [tableName] => states_distances [joinCondition] => dist.locationid1 = loc.locationid AND dist.locationid2 = 3233 ) [dcrh] => Array ( [joinType] => left join [schema] => leads [tableName] => data_credithistory [joinCondition] => l.id = dcrh.leadid ) [crh] => Array ( [joinType] => left join [schema] => leads [tableName] => _credithistory [joinCondition] => dcrh.credithistory_id = crh.id ) [dla] => Array ( [joinType] => left join [schema] => leads [tableName] => data_loanamount [joinCondition] => l.id = dla.leadid ) [la] => Array ( [joinType] => left join [schema] => leads [tableName] => _loanamount [joinCondition] => dla.loanamount_id = la.id ) [dlam] => Array ( [joinType] => left join [schema] => leads [tableName] => data_loanamount_manual [joinCondition] => l.id = dlam.leadid ) [down] => Array ( [joinType] => left join [schema] => leads [tableName] => data_ownership [joinCondition] => l.id = down.leadid ) [own] => Array ( [joinType] => left join [schema] => leads [tableName] => _ownership [joinCondition] => down.ownership_id = own.id ) [dmxs] => Array ( [joinType] => left join [schema] => leads [tableName] => data_maxshares [joinCondition] => l.id = dmxs.leadid ) [owner] => Array ( [joinType] => left join [schema] => livebuyers [tableName] => lead_transactions [joinCondition] => l.id = owner.leadid and owner.userid = 0 ) [xlf9] => Array ( [joinType] => left join [schema] => livebuyers [tableName] => xref_users_leadflags [joinCondition] => l.id = xlf9.leadid and xlf9.userid = 0 and xlf9.leadflagid = 9 ) [lstat] => Array ( [joinType] => left join [schema] => livebuyers [tableName] => lead_status [joinCondition] => l.id = lstat.leadid ) [lstattype] => Array ( [joinType] => left join [schema] => livebuyers [tableName] => _lead_status_types [joinCondition] => lstattype.status_type_id = lstat.statusid ) [drprem] => Array ( [joinType] => left join [schema] => leads [tableName] => data_rapleaf_premium [joinCondition] => l.id = drprem.leadid ) [dold] => Array ( [joinType] => left join [schema] => leads [tableName] => data_onlinedate [joinCondition] => l.id = dold.leadid and dold.usertypeid = 1 ) [sc] => Array ( [joinType] => left join [schema] => leads [tableName] => data_score [joinCondition] => l.id = sc.leadid ) [s] => Array ( [joinType] => left join [schema] => ushud [tableName] => states [joinCondition] => loc.locationid = s.locationid ) [z] => Array ( [joinType] => left join [schema] => ushud [tableName] => zips [joinCondition] => l.zip = z.zip ) ) [where] => Array ( [0] => (dist.locationid1 IS NOT NULL) [1] => AND (IF(loc.locationid = 106 and l.source_id = 3, 1, 0) <> 1) [2] => AND (IF(xlf9.leadflagid IS NULL, 0, 1) = 0) [3] => AND (s.state = 'FL') [4] => AND (crh.credithistory IN ('good')) [5] => AND (200000 BETWEEN IFNULL(la.minval, 0) AND IF(la.minval IS NULL, IFNULL(la.maxval, 0), IFNULL(la.maxval, 4294967295)) OR 200000 BETWEEN IFNULL(dlam.minval, 0) AND IF(dlam.minval IS NULL, IFNULL(dlam.maxval, 0), IFNULL(dlam.maxval, 4294967295))) [6] => AND (IF(IFNULL(vis_shareowner_searchresults, 1) = 0 AND owner.leadid IS NOT NULL, 0, 1) = 1) [7] => AND (IFNULL(vis_allusers_searchresults, 1) = 1) [8] => AND (loc.locationID != 0) [9] => AND (sc.isvalid = 1) [10] => AND (sc.underreview = 0) [11] => AND (IF(dold.ts_added IS NULL, l.ts_added, dold.ts_added) > DATE_SUB(CURDATE(), INTERVAL 120 DAY)) ) [group] => Array ( ) [having] => Array ( [0] => (numTimesSold < maxshares) ) [order] => Array ( [0] => Array ( [0] => DistSort [1] => ASC ) [1] => Array ( [0] => l.ts_added [1] => DESC ) ) [limitcount] => [limitoffset] => [forupdate] => ) [_tableCols:protected] => Array ( ) ) [_rowCount:protected] => 439 ) [_currentItemCount:protected] => [_currentItems:protected] => [_currentPageNumber:protected] => 1 [_filter:protected] => [_itemCountPerPage:protected] => [_pageCount:protected] => [_pageRange:protected] => [_pages:protected] => [_view:protected] => )
The Company
About Qazzoo Team Qazzoo Terms of Use Privacy Policy Contact Us
Resources
Qazzoo Blog Frequently Asked Questions Jobs @ Qazzoo Our Integrations Download Qazzoo App Real Estate Leads
Business & Consumers
Get Consumers Join Today Sign In My Account Consumer Profiles Tell A Friend
How Qazzoo Works
Follow Us
This site is not authorized by the NY State Department of Financial Services.
No mortgage solicitation activity or loan applications
for properties located in the State of NY can be facilitated through this site.
Pat. 7,813,958
Additional Patents Pending
Qazzoo, Internet Services, Annapolis, MD
Website Security Test