Title Page Background
DEBUG FN args: Array ( [0] => 2505 [1] => SHELBY (NORTHWEST) [2] => TN [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2505 LocID: SHELBY (NORTHWEST) Region: TN State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2505 Igate: njhud LocID: 2505 Region: SHELBY (NORTHWEST) State: TN Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 2 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2505 AND i.igate IN ('tnhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2505 [1] => SHELBY (NORTHWEST) [2] => TN [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2505 LocID: SHELBY (NORTHWEST) Region: TN State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2505 Igate: njhud LocID: 2505 Region: SHELBY (NORTHWEST) State: TN Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 2 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2505 AND i.igate IN ('tnhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2505 [1] => SHELBY (NORTHWEST) [2] => TN [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2505 LocID: SHELBY (NORTHWEST) Region: TN State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2505 Igate: njhud LocID: 2505 Region: SHELBY (NORTHWEST) State: TN Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 2 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2505 AND i.igate IN ('tnhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back | All Foreclosures | | | Memphis, Tennessee

Memphis, Shelby (Northwest), Tennessee

Displaying 91 to 100 of 204 Properties (0 foreclosures)
Adaro Realty
$219,000
1 bd / 1 ba / -- sqft
413 S Main Memphis, Tennessee 38103
4 SUCCESS REALTY LLC
$219,000
2 bd / 2 ba / -- sqft
664 Stonewall Memphis, Tennessee 38107
Moss Real Estate
$214,900
3 bd / 1 ba / -- sqft
893 N Mcneil Memphis, Tennessee 38107
Hobson Realtors
$200,000
1 bd / 2 ba / -- sqft
721 Litty Memphis, Tennessee 38103
Crye-Leike, Inc REALTORS
$199,900
2 bd / 1 ba / -- sqft
1006 N Avalon Memphis, Tennessee 38107
InCity Realty
$199,900
3 bd / 1 ba / -- sqft
780 Dickinson Memphis, Tennessee 38107
RE/MAX Real Estate Experts
$199,000
3 bd / 2 ba / -- sqft
1078 Forrest Memphis, Tennessee 38105
KELLER WILLIAMS®
$199,000
4 bd / 3 ba / -- sqft
3070 St Charles Memphis, Tennessee 38127
eXp Realty LLC
$197,000
2 bd / 2 ba / -- sqft
1815 Lyndale Memphis, Tennessee 38107
KELLER WILLIAMS®
$195,000
2 bd / 1 ba / -- sqft
1116 Poplar Memphis, Tennessee 38105
Cities In SHELBY (NORTHWEST), TN






USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App

ExternalDB Queries logged

object(stdClass)#16 (6) { ["prefix"]=> string(11) "Application" ["time"]=> string(16) "+2.1018981933594" ["totalTime"]=> float(2.1018981933594) ["memory"]=> string(17) "+0.40534973144531" ["totalMemory"]=> float(0.75305938720703) ["label"]=> string(9) "afterLoad" } object(stdClass)#294 (6) { ["prefix"]=> string(11) "Application" ["time"]=> string(16) "+102.15091705322" ["totalTime"]=> float(104.25281524658) ["memory"]=> string(16) "+1.0365447998047" ["totalMemory"]=> float(1.7896041870117) ["label"]=> string(15) "afterInitialise" } object(stdClass)#293 (6) { ["prefix"]=> string(11) "Application" ["time"]=> string(16) "+15.984058380127" ["totalTime"]=> float(120.23687362671) ["memory"]=> string(17) "+0.62561798095703" ["totalMemory"]=> float(2.4152221679688) ["label"]=> string(10) "afterRoute" } object(stdClass)#988 (6) { ["prefix"]=> string(11) "Application" ["time"]=> string(15) "+21.67010307312" ["totalTime"]=> float(141.90697669983) ["memory"]=> string(18) "+0.048027038574219" ["totalMemory"]=> float(2.463249206543) ["label"]=> string(38) "beforeRenderComponent com_propertylist" } object(stdClass)#1005 (6) { ["prefix"]=> string(11) "Application" ["time"]=> string(16) "+332.64088630676" ["totalTime"]=> float(474.54786300659) ["memory"]=> string(17) "+0.57893371582031" ["totalMemory"]=> float(3.0421829223633) ["label"]=> string(37) "afterRenderComponent com_propertylist" } object(stdClass)#1055 (6) { ["prefix"]=> string(11) "Application" ["time"]=> string(16) "+1.8861293792725" ["totalTime"]=> float(476.43399238586) ["memory"]=> string(18) "+0.014663696289062" ["totalMemory"]=> float(3.0568466186523) ["label"]=> string(13) "afterDispatch" } object(stdClass)#1040 (6) { ["prefix"]=> string(11) "Application" ["time"]=> string(16) "+36.288976669312" ["totalTime"]=> float(512.72296905518) ["memory"]=> string(18) "+0.044441223144531" ["totalMemory"]=> float(3.1012878417969) ["label"]=> string(55) "beforeRenderModule mod_propertysearch (Property Search)" } object(stdClass)#836 (6) { ["prefix"]=> string(11) "Application" ["time"]=> string(16) "+15.759944915771" ["totalTime"]=> float(528.48291397095) ["memory"]=> string(18) "+0.086692810058594" ["totalMemory"]=> float(3.1879806518555) ["label"]=> string(54) "afterRenderModule mod_propertysearch (Property Search)" } object(stdClass)#844 (6) { ["prefix"]=> string(11) "Application" ["time"]=> string(16) "+10.268926620483" ["totalTime"]=> float(538.75184059143) ["memory"]=> string(18) "+0.018501281738281" ["totalMemory"]=> float(3.2064819335938) ["label"]=> string(74) "beforeRenderModule mod_propertysearch (Property Search (Sub Page Filters))" } object(stdClass)#1280 (6) { ["prefix"]=> string(11) "Application" ["time"]=> string(16) "+14.608144760132" ["totalTime"]=> float(553.35998535156) ["memory"]=> string(19) "+0.0052642822265625" ["totalMemory"]=> float(3.2117462158203) ["label"]=> string(73) "afterRenderModule mod_propertysearch (Property Search (Sub Page Filters))" } object(stdClass)#856 (6) { ["prefix"]=> string(11) "Application" ["time"]=> string(16) "+10.078907012939" ["totalTime"]=> float(563.4388923645) ["memory"]=> string(18) "+0.015274047851562" ["totalMemory"]=> float(3.2270202636719) ["label"]=> string(55) "beforeRenderModule mod_custom (Footer HTML SEO article)" } object(stdClass)#859 (6) { ["prefix"]=> string(11) "Application" ["time"]=> string(17) "+0.22506713867188" ["totalTime"]=> float(563.66395950317) ["memory"]=> string(19) "+0.0050811767578125" ["totalMemory"]=> float(3.2321014404297) ["label"]=> string(54) "afterRenderModule mod_custom (Footer HTML SEO article)" } object(stdClass)#855 (6) { ["prefix"]=> string(11) "Application" ["time"]=> string(18) "+0.029087066650391" ["totalTime"]=> float(563.69304656982) ["memory"]=> string(19) "-0.0011978149414062" ["totalMemory"]=> float(3.2309036254883) ["label"]=> string(47) "beforeRenderModule mod_menu (Footer Menu Row 1)" } object(stdClass)#873 (6) { ["prefix"]=> string(11) "Application" ["time"]=> string(17) "+0.89192390441895" ["totalTime"]=> float(564.58497047424) ["memory"]=> string(18) "+0.032737731933594" ["totalMemory"]=> float(3.2636413574219) ["label"]=> string(46) "afterRenderModule mod_menu (Footer Menu Row 1)" } object(stdClass)#853 (6) { ["prefix"]=> string(11) "Application" ["time"]=> string(18) "+0.028848648071289" ["totalTime"]=> float(564.61381912231) ["memory"]=> string(19) "+0.0032501220703125" ["totalMemory"]=> float(3.2668914794922) ["label"]=> string(47) "beforeRenderModule mod_menu (Footer Menu Row 2)" } object(stdClass)#840 (6) { ["prefix"]=> string(11) "Application" ["time"]=> string(17) "+0.84114074707031" ["totalTime"]=> float(565.45495986938) ["memory"]=> string(18) "+0.058113098144531" ["totalMemory"]=> float(3.3250045776367) ["label"]=> string(46) "afterRenderModule mod_menu (Footer Menu Row 2)" } object(stdClass)#858 (6) { ["prefix"]=> string(11) "Application" ["time"]=> string(18) "+0.025033950805664" ["totalTime"]=> float(565.47999382019) ["memory"]=> string(19) "-0.0059738159179688" ["totalMemory"]=> float(3.3190307617188) ["label"]=> string(51) "beforeRenderModule mod_custom (Footer HTML article)" } object(stdClass)#845 (6) { ["prefix"]=> string(11) "Application" ["time"]=> string(16) "+10.370969772339" ["totalTime"]=> float(575.85096359253) ["memory"]=> string(15) "+0.056396484375" ["totalMemory"]=> float(3.3754272460938) ["label"]=> string(50) "afterRenderModule mod_custom (Footer HTML article)" } object(stdClass)#860 (6) { ["prefix"]=> string(11) "Application" ["time"]=> string(18) "+0.077962875366211" ["totalTime"]=> float(575.9289264679) ["memory"]=> string(19) "-0.0003204345703125" ["totalMemory"]=> float(3.3751068115234) ["label"]=> string(60) "beforeRenderModule mod_custom (Parked Page Adsense - Footer)" } object(stdClass)#1221 (6) { ["prefix"]=> string(11) "Application" ["time"]=> string(18) "+0.082969665527344" ["totalTime"]=> float(576.01189613342) ["memory"]=> string(18) "+0.003387451171875" ["totalMemory"]=> float(3.3784942626953) ["label"]=> string(59) "afterRenderModule mod_custom (Parked Page Adsense - Footer)" } object(stdClass)#877 (6) { ["prefix"]=> string(11) "Application" ["time"]=> string(18) "+0.044107437133789" ["totalTime"]=> float(576.05600357056) ["memory"]=> string(19) "-0.0010452270507812" ["totalMemory"]=> float(3.3774490356445) ["label"]=> string(53) "beforeRenderModule mod_custom (What USHUD.com Offers)" } object(stdClass)#1219 (6) { ["prefix"]=> string(11) "Application" ["time"]=> string(18) "+0.069856643676758" ["totalTime"]=> float(576.12586021423) ["memory"]=> string(19) "+0.0034027099609375" ["totalMemory"]=> float(3.3808517456055) ["label"]=> string(52) "afterRenderModule mod_custom (What USHUD.com Offers)" } object(stdClass)#837 (6) { ["prefix"]=> string(11) "Application" ["time"]=> string(18) "+0.041961669921875" ["totalTime"]=> float(576.16782188416) ["memory"]=> string(19) "-0.0010147094726562" ["totalMemory"]=> float(3.3798370361328) ["label"]=> string(55) "beforeRenderModule mod_custom (Home & Foreclosure Info)" } object(stdClass)#1223 (6) { ["prefix"]=> string(11) "Application" ["time"]=> string(18) "+0.072002410888672" ["totalTime"]=> float(576.23982429504) ["memory"]=> string(19) "+0.0034942626953125" ["totalMemory"]=> float(3.3833312988281) ["label"]=> string(54) "afterRenderModule mod_custom (Home & Foreclosure Info)" } object(stdClass)#1220 (6) { ["prefix"]=> string(11) "Application" ["time"]=> string(18) "+0.021219253540039" ["totalTime"]=> float(576.26104354858) ["memory"]=> string(19) "-0.0014190673828125" ["totalMemory"]=> float(3.3819122314453) ["label"]=> string(60) "beforeRenderModule mod_custom (Parked Page Adsense - Footer)" } object(stdClass)#1225 (6) { ["prefix"]=> string(11) "Application" ["time"]=> string(18) "+0.061988830566406" ["totalTime"]=> float(576.32303237915) ["memory"]=> string(18) "+0.003387451171875" ["totalMemory"]=> float(3.3852996826172) ["label"]=> string(59) "afterRenderModule mod_custom (Parked Page Adsense - Footer)" } object(stdClass)#1224 (6) { ["prefix"]=> string(11) "Application" ["time"]=> string(18) "+0.038862228393555" ["totalTime"]=> float(576.36189460754) ["memory"]=> string(20) "+0.00067901611328125" ["totalMemory"]=> float(3.3859786987305) ["label"]=> string(59) "beforeRenderModule mod_custom (Susan G Komen Bottom Banner)" } object(stdClass)#1227 (6) { ["prefix"]=> string(11) "Application" ["time"]=> string(17) "+0.06413459777832" ["totalTime"]=> float(576.42602920532) ["memory"]=> string(17) "+0.00323486328125" ["totalMemory"]=> float(3.3892135620117) ["label"]=> string(58) "afterRenderModule mod_custom (Susan G Komen Bottom Banner)" } object(stdClass)#1222 (6) { ["prefix"]=> string(11) "Application" ["time"]=> string(18) "+0.037908554077148" ["totalTime"]=> float(576.4639377594) ["memory"]=> string(20) "-0.00098419189453125" ["totalMemory"]=> float(3.3882293701172) ["label"]=> string(47) "beforeRenderModule mod_custom (Google LinkUnit)" } object(stdClass)#1229 (6) { ["prefix"]=> string(11) "Application" ["time"]=> string(18) "+0.066995620727539" ["totalTime"]=> float(576.53093338013) ["memory"]=> string(18) "+0.003326416015625" ["totalMemory"]=> float(3.3915557861328) ["label"]=> string(46) "afterRenderModule mod_custom (Google LinkUnit)" } object(stdClass)#1226 (6) { ["prefix"]=> string(11) "Application" ["time"]=> string(18) "+0.020027160644531" ["totalTime"]=> float(576.55096054077) ["memory"]=> string(19) "-0.0010833740234375" ["totalMemory"]=> float(3.3904724121094) ["label"]=> string(52) "beforeRenderModule mod_custom (USHUD.com on the Go!)" } object(stdClass)#1231 (6) { ["prefix"]=> string(11) "Application" ["time"]=> string(14) "+0.06103515625" ["totalTime"]=> float(576.61199569702) ["memory"]=> string(18) "+0.003387451171875" ["totalMemory"]=> float(3.3938598632812) ["label"]=> string(51) "afterRenderModule mod_custom (USHUD.com on the Go!)" } object(stdClass)#1228 (6) { ["prefix"]=> string(11) "Application" ["time"]=> string(18) "+0.020027160644531" ["totalTime"]=> float(576.63202285767) ["memory"]=> string(20) "+0.00063323974609375" ["totalMemory"]=> float(3.3944931030273) ["label"]=> string(65) "beforeRenderModule mod_custom (Google Advertisement (Right Side))" } object(stdClass)#1233 (6) { ["prefix"]=> string(11) "Application" ["time"]=> string(18) "+0.059843063354492" ["totalTime"]=> float(576.69186592102) ["memory"]=> string(18) "+0.005584716796875" ["totalMemory"]=> float(3.4000778198242) ["label"]=> string(64) "afterRenderModule mod_custom (Google Advertisement (Right Side))" } object(stdClass)#1230 (6) { ["prefix"]=> string(11) "Application" ["time"]=> string(18) "+0.036001205444336" ["totalTime"]=> float(576.72786712646) ["memory"]=> string(20) "-0.00037384033203125" ["totalMemory"]=> float(3.3997039794922) ["label"]=> string(62) "beforeRenderModule mod_expertbanner (Local Real Estate Expert)" } object(stdClass)#1238 (6) { ["prefix"]=> string(11) "Application" ["time"]=> string(16) "+40.508985519409" ["totalTime"]=> float(617.23685264587) ["memory"]=> string(19) "+0.0043563842773438" ["totalMemory"]=> float(3.4040603637695) ["label"]=> string(61) "afterRenderModule mod_expertbanner (Local Real Estate Expert)" } object(stdClass)#1232 (6) { ["prefix"]=> string(11) "Application" ["time"]=> string(18) "+0.030994415283203" ["totalTime"]=> float(617.26784706116) ["memory"]=> string(16) "-0.0015869140625" ["totalMemory"]=> float(3.402473449707) ["label"]=> string(56) "beforeRenderModule mod_expertbanner (Local Mortgage Pro)" } object(stdClass)#1240 (6) { ["prefix"]=> string(11) "Application" ["time"]=> string(16) "+40.125131607056" ["totalTime"]=> float(657.39297866821) ["memory"]=> string(19) "+0.0029373168945312" ["totalMemory"]=> float(3.4054107666016) ["label"]=> string(55) "afterRenderModule mod_expertbanner (Local Mortgage Pro)" } object(stdClass)#1234 (6) { ["prefix"]=> string(11) "Application" ["time"]=> string(18) "+0.031948089599609" ["totalTime"]=> float(657.42492675781) ["memory"]=> string(20) "-0.00092315673828125" ["totalMemory"]=> float(3.4044876098633) ["label"]=> string(56) "beforeRenderModule mod_expertbanner (Foreclosure Expert)" } object(stdClass)#1242 (6) { ["prefix"]=> string(11) "Application" ["time"]=> string(16) "+42.253017425537" ["totalTime"]=> float(699.67794418335) ["memory"]=> string(19) "+0.0029373168945312" ["totalMemory"]=> float(3.4074249267578) ["label"]=> string(55) "afterRenderModule mod_expertbanner (Foreclosure Expert)" } object(stdClass)#1236 (6) { ["prefix"]=> string(11) "Application" ["time"]=> string(17) "+0.09608268737793" ["totalTime"]=> float(699.77402687073) ["memory"]=> string(17) "+0.00189208984375" ["totalMemory"]=> float(3.4093170166016) ["label"]=> string(43) "beforeRenderModule mod_gruemenu (Main Menu)" } object(stdClass)#1260 (6) { ["prefix"]=> string(11) "Application" ["time"]=> string(16) "+1.4429092407227" ["totalTime"]=> float(701.21693611145) ["memory"]=> string(18) "+0.053131103515625" ["totalMemory"]=> float(3.4624481201172) ["label"]=> string(42) "afterRenderModule mod_gruemenu (Main Menu)" }

Joomla! Debug Console

Session

Profile Information

Memory Usage

Database Queries