•Banner•

All independent businesses, all under one virtual roof.  Shop local, independent first.



 

Real Estate

•Listings• RSS
•Add your listing here•

Abstract Resources, Inc.

1128 Memorial Highway, Dallas, PA, 18612
Telephone570-675-2026

Andrew Trevino

303 Wyoming Avenue, Wyoming, PA, 18644
Telephone570-613-9090

Green Acres Homes

11 Holiday Drive, Kingston, PA, 18704
Telephone570-288-9019

Humford Realities

Suite 302, 15 Public Square, Wilkes-Barre, PA, 18701
Telephone570-822-5126
E-mail

Lewith & Freeman Real Estate

69 North Memorial Highway, Shavertown, PA, 18708
Telephone570-696-3801

Mcdermott & Mcdermott Real Estate Inc.

57 North Main Street, Shavertown, PA, 18708
Telephone570-696-2468

Pat Gazenski Century 21

303 Market Street, Kingston, PA, 18704
Telephone570-829-1150

Twin Stacks Development Co.

1100 Memorial Highway, Dallas, PA, 18612
Telephone570-674-7800

•Profile Information•

Application afterLoad: 0.000 seconds, 0.39 MB
Application afterInitialise: 0.057 seconds, 5.38 MB
Application afterRoute: 0.082 seconds, 8.51 MB
Application afterDispatch: 0.177 seconds, 13.02 MB
Application afterRender: 0.217 seconds, 13.81 MB

•Memory Usage•

14846576

•96 queries logged•

  1. DELETE
      FROM jos_session
      WHERE ( TIME < '1539981063' )
  2. SELECT *
      FROM jos_session
      WHERE session_id = 'td670prgkqllnnvj9cb4lqtti3'
  3. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'td670prgkqllnnvj9cb4lqtti3','1539988263','','0','1','0' )
  4. SELECT *
      FROM jos_components
      WHERE parent = 0
  5. SELECT folder AS TYPE, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  6. SELECT setting,VALUE
      FROM jos_jfbconnect_config
  7. SELECT `value`

      FROM `jos_admintools_storage`

      WHERE `key` = 'cparams'
  8. SELECT *
      FROM jos_redj
      WHERE ( (('/directory/real-estate' REGEXP BINARY fromurl)>0
      AND case_sensitive<>'0') OR (('/directory/real-estate' REGEXP fromurl)>0
      AND case_sensitive='0') )
      AND published='1'
      ORDER BY ordering
  9. SELECT m.*, c.`option` AS component
      FROM jos_menu AS m
      LEFT JOIN jos_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
  10. SELECT `varname`, `value`, `default`
      FROM jos_mt_config
  11. SELECT cat_id, cat_parent, alias
      FROM jos_mt_cats
      WHERE cat_published='1'
      AND cat_approved='1' && BINARY alias = 'real-estate'
  12. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 247)
      ORDER BY menuid DESC
      LIMIT 0, 1
  13. SELECT cat_name, cat_id, lft, rgt
      FROM jos_mt_cats
      WHERE cat_id = '110'
  14. SELECT cat_id
      FROM jos_mt_cats
      WHERE lft < 54
      AND rgt > 55
      AND cat_id > 0
      AND cat_parent >= 0
      ORDER BY lft ASC
  15. SELECT *
      FROM jos_mt_cats
      WHERE cat_id='110'
      AND cat_published = 1
      LIMIT 1
  16. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '110'
      LIMIT 1
  17. SELECT COUNT(*)
      FROM (jos_mt_links AS l, jos_mt_cl AS cl)
      WHERE l.link_published = 1
      AND l.link_approved = 1 && cl.cat_id = '110'
     
      AND ( l.publish_up = '0000-00-00 00:00:00' OR l.publish_up <= '2018-10-19 22:31:03'  )
     
      AND ( l.publish_down = '0000-00-00 00:00:00' OR l.publish_down >= '2018-10-19 22:31:03' )
     
      AND cl.link_id = l.link_id
  18. SELECT cat.*
      FROM jos_mt_cats AS cat
      WHERE cat_published=1 && cat_approved=1 && cat_parent= '110'
      ORDER BY cat_name ASC
  19. SELECT r.rel_id
      FROM jos_mt_relcats AS r
      LEFT JOIN jos_mt_cats AS c
      ON c.cat_id = r.rel_id
      WHERE r.cat_id = '110'
      AND c.cat_published = 1
  20. SELECT l.*, cl.*, cat.*, u.username AS username, u.name AS owner, img.filename AS link_image
      FROM jos_mt_links AS l
     
      LEFT JOIN jos_mt_cl AS cl
      ON cl.link_id = l.link_id
     
      LEFT JOIN jos_users AS u
      ON u.id = l.user_id
     
      LEFT JOIN jos_mt_cats AS cat
      ON cl.cat_id = cat.cat_id
     
      LEFT JOIN jos_mt_images AS img
      ON img.link_id = l.link_id
      AND img.ordering = 1
     
      WHERE link_published='1' && link_approved='1' && cl.cat_id = '110'
     
      AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2018-10-19 22:31:03'  )
     
      AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2018-10-19 22:31:03' )
     
      ORDER BY link_featured DESC, link_name ASC
     
      LIMIT 0, 20
  21. SELECT CONCAT( 'cust_', cf_id ) AS name, caption AS VALUE, field_type
      FROM jos_mt_customfields
  22. SELECT cf.*, cfv.link_id, cfv.VALUE, cfv.attachment, cfv.counter, ft.ft_class
      FROM jos_mt_customfields AS cf

      LEFT JOIN jos_mt_cfvalues AS cfv
      ON cf.cf_id=cfv.cf_id

      LEFT JOIN jos_mt_fieldtypes AS ft
      ON ft.field_type=cf.field_type

      WHERE cf.published = '1'
      AND cf.summary_view = '1'

      AND cfv.link_id IN (366,474,198,315,199,347,200,201,202,249)

      ORDER BY cf.ordering ASC, link_id DESC
  23. SELECT cf. * , NULL AS link_id, '' AS VALUE, NULL AS attachment, ft.ft_class

      FROM jos_mt_customfields AS cf

      LEFT JOIN jos_mt_fieldtypes AS ft
      ON ft.field_type=cf.field_type

      WHERE cf.published = '1'

      AND cf.summary_view = '1'

      AND cf.iscore = '1'

      ORDER BY cf.ordering ASC
  24. SELECT r.link_id, COUNT( * ) AS total
      FROM jos_mt_cl AS cl
     
      LEFT JOIN jos_mt_reviews AS r
      ON cl.link_id = r.link_id
     
      WHERE cl.link_id IN ('366','474','198','315','199','347','200','201','202','249')
      AND r.rev_approved = '1'
      AND cl.main = '1'
     
      GROUP BY r.link_id
  25. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '110'
      LIMIT 1
  26. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '110'
      LIMIT 1
  27. SELECT params
      FROM jos_mt_templates
      WHERE tem_name = 'm2'
      LIMIT 1
  28. SELECT l.*, cl.cat_id AS cat_id
      FROM jos_mt_links AS l, jos_mt_cl AS cl
      WHERE l.link_id = cl.link_id
      AND l.link_id = '366'
      AND main = 1
  29. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '110'
      LIMIT 1
  30. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  31. SELECT cf_id, caption
      FROM jos_mt_customfields
      WHERE tag_search = 1
      AND published = 1
  32. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  33. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  34. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  35. SELECT l.*, cl.cat_id AS cat_id
      FROM jos_mt_links AS l, jos_mt_cl AS cl
      WHERE l.link_id = cl.link_id
      AND l.link_id = '474'
      AND main = 1
  36. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '110'
      LIMIT 1
  37. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  38. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  39. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  40. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  41. SELECT l.*, cl.cat_id AS cat_id
      FROM jos_mt_links AS l, jos_mt_cl AS cl
      WHERE l.link_id = cl.link_id
      AND l.link_id = '198'
      AND main = 1
  42. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '110'
      LIMIT 1
  43. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  44. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  45. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  46. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  47. SELECT l.*, cl.cat_id AS cat_id
      FROM jos_mt_links AS l, jos_mt_cl AS cl
      WHERE l.link_id = cl.link_id
      AND l.link_id = '315'
      AND main = 1
  48. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '110'
      LIMIT 1
  49. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  50. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  51. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  52. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  53. SELECT l.*, cl.cat_id AS cat_id
      FROM jos_mt_links AS l, jos_mt_cl AS cl
      WHERE l.link_id = cl.link_id
      AND l.link_id = '199'
      AND main = 1
  54. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '110'
      LIMIT 1
  55. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  56. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  57. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  58. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  59. SELECT l.*, cl.cat_id AS cat_id
      FROM jos_mt_links AS l, jos_mt_cl AS cl
      WHERE l.link_id = cl.link_id
      AND l.link_id = '347'
      AND main = 1
  60. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '110'
      LIMIT 1
  61. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  62. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  63. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  64. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  65. SELECT l.*, cl.cat_id AS cat_id
      FROM jos_mt_links AS l, jos_mt_cl AS cl
      WHERE l.link_id = cl.link_id
      AND l.link_id = '200'
      AND main = 1
  66. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '110'
      LIMIT 1
  67. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  68. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  69. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  70. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  71. SELECT l.*, cl.cat_id AS cat_id
      FROM jos_mt_links AS l, jos_mt_cl AS cl
      WHERE l.link_id = cl.link_id
      AND l.link_id = '201'
      AND main = 1
  72. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '110'
      LIMIT 1
  73. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  74. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  75. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  76. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  77. SELECT l.*, cl.cat_id AS cat_id
      FROM jos_mt_links AS l, jos_mt_cl AS cl
      WHERE l.link_id = cl.link_id
      AND l.link_id = '202'
      AND main = 1
  78. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '110'
      LIMIT 1
  79. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  80. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  81. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  82. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  83. SELECT l.*, cl.cat_id AS cat_id
      FROM jos_mt_links AS l, jos_mt_cl AS cl
      WHERE l.link_id = cl.link_id
      AND l.link_id = '249'
      AND main = 1
  84. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '110'
      LIMIT 1
  85. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  86. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  87. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  88. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  89. SELECT j_user_id
      FROM jos_jfbconnect_user_map
      WHERE fb_user_id=''
  90. SELECT id, title, module, POSITION, content, showtitle, control, params
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.published = 1
      AND m.access <= 0
      AND m.client_id = 0
      AND ( mm.menuid = 247 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  91. SELECT cat_id, cat_name
      FROM jos_mt_cats  
      WHERE cat_approved=1
      AND cat_published=1
      AND cat_parent = 0
      ORDER BY cat_name ASC
  92. SELECT *, RAND() AS ordering
      FROM jos_banner
      WHERE showBanner = 1
      AND (imptotal = 0 OR impmade < imptotal)
      AND catid = 8
      ORDER BY sticky DESC, ordering
      LIMIT 0, 1
  93. UPDATE jos_banner
      SET impmade = impmade + 1
      WHERE bid = 30
  94. SELECT a.id, a.alias AS username, a.title AS fullname, a.catid, a.sectionid, a.introtext AS intro, u.email AS email, u.id AS user_id, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
      FROM jos_content AS a
      LEFT JOIN jos_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos_users AS u
      ON u.username = a.alias
      WHERE a.sectionid = 15
      AND a.state = 1
  95. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '110'
      LIMIT 1
  96. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '110'
      LIMIT 1

•0 legacy queries logged•

    •Language Files Loaded•

    •Untranslated Strings Diagnostic•

    •None•

    •Untranslated Strings Designer•

    •None•