Fresno Bee People's Choice Award Winner - #1 Best Real Estate Company

Leading Real Estate Companies Of The World Award Winner - #1 Most Innovative Nationwide Broker

The Business Journal Award Winner - #1 Best Residential Real Estate Company

The Business Journal Award Winner - #1 Best Company To Work For

Create Account

Fields marked with * are required. However, providing more information will allow us to better serve your needs.
* First Name:
* Last Name:
* Email Address:
* Password:
* Confirm Password:
Street Address:
City:
State:
Zip:
Cell Phone:
Other Phone:

BUYING

Central Valley Luxury Homes

SELLING

Home Value Calculator

Commission Options

Home Seller's Guide

For Sale By Owner Assistance

AGENTS

CONTACT

ABOUT US

Create Account | Login

Home BUYING SELLING MOVING AGENTS Careers CONTACT ABOUT US

Company History

Our Leadership

Affiliated Companies

"Meta Title" is the name of your page in search results.
Try to incorporate your most important keywords, but keep it short.

"Meta Description" is the block of text that appears below your site on search results.
The search engine will cut it off after so many characters, so it's best to keep it short, focus on the most important information, and include key search terms you want people to use to find you.

"Meta Keywords" is a list of key search terms you expect people to use to find your site.
They are a hidden part of your site's source code, so they don't have to look attractive. Separate keywords with commas.

Page Title:
Meta Title: What's this mean?
Meta Description: What's this mean?	Holiday Bike Giveaway
Meta Keywords: What's this mean?

Holiday Bike Giveaway

Thanks to the generosity of our associates and clients, throughout the Valley, London Properties gifted over 435 bicycles (including helmets and locks) this holiday season. Students receiving the bicycles were nominated by their teachers based on their hard work, effort, attendance, and character.

Download Fresno Unified Press Release

Copyright © 2022 London Properties, Ltd.
6442 N. Maroa Ave. | Fresno CA 93704
All Rights Reserved
Terms of Use | Privacy Policy
Do Not Sell My Personal Information | Affiliated Business Disclosure
California Department Of Real Estate License #00463722

6105 of /var/www2/includes/functions.php - totalFileTime: 6.4380168914795 milliseconds ^%^ 0.0064380168914795 seconds
1667 of /var/www2/actions/initialize-dat-mofo.php - SELECT * FROM `lpdotcom`.`sold_data` WHERE `id` < 0 0.18906593322754 milliseconds ^%^ 0.00018906593322754 seconds
1776 of /var/www2/actions/initialize-dat-mofo.php - SELECT `id`,`agent_id` FROM `lpdotcom`.`sites` WHERE `url` = 'www.rickhauffrealestate.com' OR `url` = 'www.www.rickhauffrealestate.com' LIMIT 1 0.081062316894531 milliseconds ^%^ 8.1062316894531E-5 seconds
354 of /var/www2/includes/functions.php - check_for_scss 0.028848648071289 milliseconds ^%^ 2.8848648071289E-5 seconds
1945 of /var/www2/actions/initialize-dat-mofo.php - SELECT `id` FROM `lpdotcom`.`menus` WHERE `site_id` IN (SELECT `id` FROM `lpdotcom`.`sites` WHERE `agent_id` = 0) AND `label` != '-sections-' ORDER BY `id` LIMIT 1 0.082015991210938 milliseconds ^%^ 8.2015991210938E-5 seconds
1954 of /var/www2/actions/initialize-dat-mofo.php - SELECT `page_id` FROM `lpdotcom`.`menu_items` WHERE `menu_id` = 32424 AND `hidden` = '0' ORDER BY `position` LIMIT 1 0.081062316894531 milliseconds ^%^ 8.1062316894531E-5 seconds
2439 of /var/www2/actions/initialize-dat-mofo.php - SELECT `menu_id` FROM `lpdotcom`.`menu_items` WHERE `page_id` = '6313' AND `menu_id` IN(SELECT `id` FROM `lpdotcom`.`menus` WHERE `site_id` = 0 ORDER BY `id`) ORDER BY `menu_id`,`position` LIMIT 1 4.3091773986816 milliseconds ^%^ 0.0043091773986816 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 6313 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.2140998840332 milliseconds ^%^ 0.0002140998840332 seconds
28 of /var/www2/figure-outters/pagelayoutfigureoutter.php - SELECT * FROM `lpdotcom`.`pages` WHERE `id` = '6313' LIMIT 1 ^%^ 0.19502639770508 milliseconds ^%^ 0.00019502639770508 seconds
141 of /var/www2/includes/header-minimalMenu.php - SELECT * FROM `lpdotcom`.`testimonials` WHERE (`agent_id` = '0' OR `agent_id` LIKE '0;%' OR `agent_id` LIKE '%;0;%' OR `agent_id` LIKE '%;0') AND `approved` = 1 AND `visible` = 1 ORDER BY IF(TRIM(`content`) = '' OR `content` IS NULL,1,0),`date` DESC,`id` DESC; ^%^ 0.12898445129395 milliseconds ^%^ 0.00012898445129395 seconds
158 of /var/www2/includes/header-minimalMenu.php - SELECT * FROM `lpdotcom`.`menu_items` WHERE `menu_id` IN (SELECT `id` FROM `lpdotcom`.`menus` WHERE `label` = '-sections-' AND `site_id` = 0) AND (`gadget_id` IS NULL OR `gadget_id` != '12') AND (`link_url` IS NULL OR `link_url` NOT LIKE '%my-listings%') AND (`gadget_id` IS NULL OR `gadget_id` != '27') AND `hidden` != 1 ORDER BY `position` ASC ^%^ 0.091791152954102 milliseconds ^%^ 9.1791152954102E-5 seconds
169 of /var/www2/includes/header-minimalMenu.php - SELECT `id` FROM `lpdotcom`.`pages` WHERE `is_mn` = 1; ^%^ 0.082969665527344 milliseconds ^%^ 8.2969665527344E-5 seconds
181 of /var/www2/includes/header-minimalMenu.php - SELECT `id` FROM `lpdotcom`.`pages` WHERE `is_as` = 1; ^%^ 0.087976455688477 milliseconds ^%^ 8.7976455688477E-5 seconds
868 of /var/www2/includes/header-minimalMenu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '10' ^%^ 0.085830688476562 milliseconds ^%^ 8.5830688476562E-5 seconds
817 of /var/www2/includes/header-minimalMenu.php - SELECT * FROM `lpdotcom`.`menu_items` WHERE `menu_id` = '55' AND (`gadget_id` IS NULL OR `gadget_id` != '12') AND (`link_url` IS NULL OR `link_url` NOT LIKE '%my-listings%') AND (`gadget_id` IS NULL OR `gadget_id` != '27') AND `hidden` = '0' ^%^ 0.090837478637695 milliseconds ^%^ 9.0837478637695E-5 seconds
831 of /var/www2/includes/header-minimalMenu.php - SELECT * FROM `lpdotcom`.`menu_items` WHERE `menu_id` = '55' AND (`gadget_id` IS NULL OR `gadget_id` != '12') AND (`link_url` IS NULL OR `link_url` NOT LIKE '%my-listings%') AND (`gadget_id` IS NULL OR `gadget_id` != '27') AND `hidden` = '0' ORDER BY `position` ^%^ 0.089883804321289 milliseconds ^%^ 8.9883804321289E-5 seconds
842 of /var/www2/includes/header-minimalMenu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '1' ^%^ 0.082015991210938 milliseconds ^%^ 8.2015991210938E-5 seconds
912 of /var/www2/includes/header-minimalMenu.php - SELECT * FROM `lpdotcom`.`menu_items` WHERE `menu_id` = '55' AND (`gadget_id` IS NULL OR `gadget_id` != '12') AND (`link_url` IS NULL OR `link_url` NOT LIKE '%my-listings%') AND (`gadget_id` IS NULL OR `gadget_id` != '27') AND `hidden` = '0' ORDER BY `position` ^%^ 0.087976455688477 milliseconds ^%^ 8.7976455688477E-5 seconds
943 of /var/www2/includes/header-minimalMenu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '1' ^%^ 0.082015991210938 milliseconds ^%^ 8.2015991210938E-5 seconds
943 of /var/www2/includes/header-minimalMenu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '7' ^%^ 0.082969665527344 milliseconds ^%^ 8.2969665527344E-5 seconds
943 of /var/www2/includes/header-minimalMenu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '4' ^%^ 0.080108642578125 milliseconds ^%^ 8.0108642578125E-5 seconds
943 of /var/www2/includes/header-minimalMenu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '2' ^%^ 0.081062316894531 milliseconds ^%^ 8.1062316894531E-5 seconds
943 of /var/www2/includes/header-minimalMenu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '24' ^%^ 0.082015991210938 milliseconds ^%^ 8.2015991210938E-5 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 6415 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.082969665527344 milliseconds ^%^ 8.2969665527344E-5 seconds
943 of /var/www2/includes/header-minimalMenu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '14' ^%^ 0.082969665527344 milliseconds ^%^ 8.2969665527344E-5 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 6420 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.082015991210938 milliseconds ^%^ 8.2015991210938E-5 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 125 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.080108642578125 milliseconds ^%^ 8.0108642578125E-5 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 4225 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.077962875366211 milliseconds ^%^ 7.7962875366211E-5 seconds
817 of /var/www2/includes/header-minimalMenu.php - SELECT * FROM `lpdotcom`.`menu_items` WHERE `menu_id` = '56' AND (`gadget_id` IS NULL OR `gadget_id` != '12') AND (`link_url` IS NULL OR `link_url` NOT LIKE '%my-listings%') AND (`gadget_id` IS NULL OR `gadget_id` != '27') AND `hidden` = '0' ^%^ 0.087976455688477 milliseconds ^%^ 8.7976455688477E-5 seconds
831 of /var/www2/includes/header-minimalMenu.php - SELECT * FROM `lpdotcom`.`menu_items` WHERE `menu_id` = '56' AND (`gadget_id` IS NULL OR `gadget_id` != '12') AND (`link_url` IS NULL OR `link_url` NOT LIKE '%my-listings%') AND (`gadget_id` IS NULL OR `gadget_id` != '27') AND `hidden` = '0' ORDER BY `position` ^%^ 0.097036361694336 milliseconds ^%^ 9.7036361694336E-5 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 6456 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.079870223999023 milliseconds ^%^ 7.9870223999023E-5 seconds
912 of /var/www2/includes/header-minimalMenu.php - SELECT * FROM `lpdotcom`.`menu_items` WHERE `menu_id` = '56' AND (`gadget_id` IS NULL OR `gadget_id` != '12') AND (`link_url` IS NULL OR `link_url` NOT LIKE '%my-listings%') AND (`gadget_id` IS NULL OR `gadget_id` != '27') AND `hidden` = '0' ORDER BY `position` ^%^ 0.084877014160156 milliseconds ^%^ 8.4877014160156E-5 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 6456 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.079870223999023 milliseconds ^%^ 7.9870223999023E-5 seconds
943 of /var/www2/includes/header-minimalMenu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '20' ^%^ 0.082015991210938 milliseconds ^%^ 8.2015991210938E-5 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 27 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.079870223999023 milliseconds ^%^ 7.9870223999023E-5 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 6469 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.079870223999023 milliseconds ^%^ 7.9870223999023E-5 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 6421 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.081062316894531 milliseconds ^%^ 8.1062316894531E-5 seconds
817 of /var/www2/includes/header-minimalMenu.php - SELECT * FROM `lpdotcom`.`menu_items` WHERE `menu_id` = '85' AND (`gadget_id` IS NULL OR `gadget_id` != '12') AND (`link_url` IS NULL OR `link_url` NOT LIKE '%my-listings%') AND (`gadget_id` IS NULL OR `gadget_id` != '27') AND `hidden` = '0' ^%^ 0.08702278137207 milliseconds ^%^ 8.702278137207E-5 seconds
831 of /var/www2/includes/header-minimalMenu.php - SELECT * FROM `lpdotcom`.`menu_items` WHERE `menu_id` = '85' AND (`gadget_id` IS NULL OR `gadget_id` != '12') AND (`link_url` IS NULL OR `link_url` NOT LIKE '%my-listings%') AND (`gadget_id` IS NULL OR `gadget_id` != '27') AND `hidden` = '0' ORDER BY `position` ^%^ 0.081062316894531 milliseconds ^%^ 8.1062316894531E-5 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 6471 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.081062316894531 milliseconds ^%^ 8.1062316894531E-5 seconds
817 of /var/www2/includes/header-minimalMenu.php - SELECT * FROM `lpdotcom`.`menu_items` WHERE `menu_id` = '61' AND (`gadget_id` IS NULL OR `gadget_id` != '12') AND (`link_url` IS NULL OR `link_url` NOT LIKE '%my-listings%') AND (`gadget_id` IS NULL OR `gadget_id` != '27') AND `hidden` = '0' ^%^ 0.085115432739258 milliseconds ^%^ 8.5115432739258E-5 seconds
831 of /var/www2/includes/header-minimalMenu.php - SELECT * FROM `lpdotcom`.`menu_items` WHERE `menu_id` = '61' AND (`gadget_id` IS NULL OR `gadget_id` != '12') AND (`link_url` IS NULL OR `link_url` NOT LIKE '%my-listings%') AND (`gadget_id` IS NULL OR `gadget_id` != '27') AND `hidden` = '0' ORDER BY `position` ^%^ 0.082015991210938 milliseconds ^%^ 8.2015991210938E-5 seconds
842 of /var/www2/includes/header-minimalMenu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '9' ^%^ 0.077009201049805 milliseconds ^%^ 7.7009201049805E-5 seconds
912 of /var/www2/includes/header-minimalMenu.php - SELECT * FROM `lpdotcom`.`menu_items` WHERE `menu_id` = '61' AND (`gadget_id` IS NULL OR `gadget_id` != '12') AND (`link_url` IS NULL OR `link_url` NOT LIKE '%my-listings%') AND (`gadget_id` IS NULL OR `gadget_id` != '27') AND `hidden` = '0' ORDER BY `position` ^%^ 0.082969665527344 milliseconds ^%^ 8.2969665527344E-5 seconds
943 of /var/www2/includes/header-minimalMenu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '9' ^%^ 0.078916549682617 milliseconds ^%^ 7.8916549682617E-5 seconds
943 of /var/www2/includes/header-minimalMenu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '11' ^%^ 0.081062316894531 milliseconds ^%^ 8.1062316894531E-5 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 6415 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.082015991210938 milliseconds ^%^ 8.2015991210938E-5 seconds
817 of /var/www2/includes/header-minimalMenu.php - SELECT * FROM `lpdotcom`.`menu_items` WHERE `menu_id` = '27654' AND (`gadget_id` IS NULL OR `gadget_id` != '12') AND (`link_url` IS NULL OR `link_url` NOT LIKE '%my-listings%') AND (`gadget_id` IS NULL OR `gadget_id` != '27') AND `hidden` = '0' ^%^ 0.085115432739258 milliseconds ^%^ 8.5115432739258E-5 seconds
831 of /var/www2/includes/header-minimalMenu.php - SELECT * FROM `lpdotcom`.`menu_items` WHERE `menu_id` = '27654' AND (`gadget_id` IS NULL OR `gadget_id` != '12') AND (`link_url` IS NULL OR `link_url` NOT LIKE '%my-listings%') AND (`gadget_id` IS NULL OR `gadget_id` != '27') AND `hidden` = '0' ORDER BY `position` ^%^ 0.082015991210938 milliseconds ^%^ 8.2015991210938E-5 seconds
817 of /var/www2/includes/header-minimalMenu.php - SELECT * FROM `lpdotcom`.`menu_items` WHERE `menu_id` = '57' AND (`gadget_id` IS NULL OR `gadget_id` != '12') AND (`link_url` IS NULL OR `link_url` NOT LIKE '%my-listings%') AND (`gadget_id` IS NULL OR `gadget_id` != '27') AND `hidden` = '0' ^%^ 0.082969665527344 milliseconds ^%^ 8.2969665527344E-5 seconds
831 of /var/www2/includes/header-minimalMenu.php - SELECT * FROM `lpdotcom`.`menu_items` WHERE `menu_id` = '57' AND (`gadget_id` IS NULL OR `gadget_id` != '12') AND (`link_url` IS NULL OR `link_url` NOT LIKE '%my-listings%') AND (`gadget_id` IS NULL OR `gadget_id` != '27') AND `hidden` = '0' ORDER BY `position` ^%^ 0.082015991210938 milliseconds ^%^ 8.2015991210938E-5 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 573 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.077962875366211 milliseconds ^%^ 7.7962875366211E-5 seconds
912 of /var/www2/includes/header-minimalMenu.php - SELECT * FROM `lpdotcom`.`menu_items` WHERE `menu_id` = '57' AND (`gadget_id` IS NULL OR `gadget_id` != '12') AND (`link_url` IS NULL OR `link_url` NOT LIKE '%my-listings%') AND (`gadget_id` IS NULL OR `gadget_id` != '27') AND `hidden` = '0' ORDER BY `position` ^%^ 0.082969665527344 milliseconds ^%^ 8.2969665527344E-5 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 573 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.077962875366211 milliseconds ^%^ 7.7962875366211E-5 seconds
943 of /var/www2/includes/header-minimalMenu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '5' ^%^ 0.079154968261719 milliseconds ^%^ 7.9154968261719E-5 seconds
817 of /var/www2/includes/header-minimalMenu.php - SELECT * FROM `lpdotcom`.`menu_items` WHERE `menu_id` = '59' AND (`gadget_id` IS NULL OR `gadget_id` != '12') AND (`link_url` IS NULL OR `link_url` NOT LIKE '%my-listings%') AND (`gadget_id` IS NULL OR `gadget_id` != '27') AND `hidden` = '0' ^%^ 0.085115432739258 milliseconds ^%^ 8.5115432739258E-5 seconds
831 of /var/www2/includes/header-minimalMenu.php - SELECT * FROM `lpdotcom`.`menu_items` WHERE `menu_id` = '59' AND (`gadget_id` IS NULL OR `gadget_id` != '12') AND (`link_url` IS NULL OR `link_url` NOT LIKE '%my-listings%') AND (`gadget_id` IS NULL OR `gadget_id` != '27') AND `hidden` = '0' ORDER BY `position` ^%^ 0.082015991210938 milliseconds ^%^ 8.2015991210938E-5 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 55 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.077962875366211 milliseconds ^%^ 7.7962875366211E-5 seconds
912 of /var/www2/includes/header-minimalMenu.php - SELECT * FROM `lpdotcom`.`menu_items` WHERE `menu_id` = '59' AND (`gadget_id` IS NULL OR `gadget_id` != '12') AND (`link_url` IS NULL OR `link_url` NOT LIKE '%my-listings%') AND (`gadget_id` IS NULL OR `gadget_id` != '27') AND `hidden` = '0' ORDER BY `position` ^%^ 0.08392333984375 milliseconds ^%^ 8.392333984375E-5 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 55 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.077962875366211 milliseconds ^%^ 7.7962875366211E-5 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 56 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.079870223999023 milliseconds ^%^ 7.9870223999023E-5 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 57 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.078916549682617 milliseconds ^%^ 7.8916549682617E-5 seconds
983 of /var/www2/includes/header-minimalMenu.php - totalFileTime: ^%^ 11.913061141968 milliseconds ^%^ 0.011913061141968 seconds
400 of /var/www2/includes/header-accountTab.php - totalFileTime: ^%^ 0.13589859008789 milliseconds ^%^ 0.00013589859008789 seconds
131 of /var/www2/includes/header-menu.php - SELECT * FROM `lpdotcom`.`testimonials` WHERE (`agent_id` = '0' OR `agent_id` LIKE '0;%' OR `agent_id` LIKE '%;0;%' OR `agent_id` LIKE '%;0') AND `approved` = 1 AND `visible` = 1 ORDER BY IF(TRIM(`content`) = '' OR `content` IS NULL,1,0),`date` DESC,`id` DESC; ^%^ 0.10919570922852 milliseconds ^%^ 0.00010919570922852 seconds
158 of /var/www2/includes/header-menu.php - SELECT * FROM `lpdotcom`.`menu_items` WHERE `menu_id` IN (SELECT `id` FROM `lpdotcom`.`menus` WHERE `label` = '-sections-' AND `site_id` = 0) AND (`gadget_id` IS NULL OR `gadget_id` != '12') AND (`link_url` IS NULL OR `link_url` NOT LIKE '%my-listings%') AND (`gadget_id` IS NULL OR `gadget_id` != '27') AND `hidden` != 1 ORDER BY `position` ASC ^%^ 0.091075897216797 milliseconds ^%^ 9.1075897216797E-5 seconds
239 of /var/www2/includes/header-menu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '10' ^%^ 0.080108642578125 milliseconds ^%^ 8.0108642578125E-5 seconds
179 of /var/www2/includes/header-menu.php - SELECT * FROM `lpdotcom`.`menu_items` WHERE `menu_id` = '55' AND (`gadget_id` IS NULL OR `gadget_id` != '12') AND (`link_url` IS NULL OR `link_url` NOT LIKE '%my-listings%') AND (`gadget_id` IS NULL OR `gadget_id` != '27') AND `hidden` = '0' ^%^ 0.08702278137207 milliseconds ^%^ 8.702278137207E-5 seconds
201 of /var/www2/includes/header-menu.php - SELECT * FROM `lpdotcom`.`menu_items` WHERE `menu_id` = '55' AND (`gadget_id` IS NULL OR `gadget_id` != '12') AND (`link_url` IS NULL OR `link_url` NOT LIKE '%my-listings%') AND (`gadget_id` IS NULL OR `gadget_id` != '27') AND `hidden` = '0' ORDER BY `position` ^%^ 0.08702278137207 milliseconds ^%^ 8.702278137207E-5 seconds
212 of /var/www2/includes/header-menu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '1' ^%^ 0.077962875366211 milliseconds ^%^ 7.7962875366211E-5 seconds
309 of /var/www2/includes/header-menu.php - SELECT * FROM `lpdotcom`.`menu_items` WHERE `menu_id` = '55' AND (`gadget_id` IS NULL OR `gadget_id` != '12') AND (`link_url` IS NULL OR `link_url` NOT LIKE '%my-listings%') AND (`gadget_id` IS NULL OR `gadget_id` != '27') AND `hidden` = '0' ORDER BY `position` ^%^ 0.088930130004883 milliseconds ^%^ 8.8930130004883E-5 seconds
344 of /var/www2/includes/header-menu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '1' ^%^ 0.079870223999023 milliseconds ^%^ 7.9870223999023E-5 seconds
344 of /var/www2/includes/header-menu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '7' ^%^ 0.080108642578125 milliseconds ^%^ 8.0108642578125E-5 seconds
344 of /var/www2/includes/header-menu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '4' ^%^ 0.077962875366211 milliseconds ^%^ 7.7962875366211E-5 seconds
344 of /var/www2/includes/header-menu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '2' ^%^ 0.078916549682617 milliseconds ^%^ 7.8916549682617E-5 seconds
344 of /var/www2/includes/header-menu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '24' ^%^ 0.079154968261719 milliseconds ^%^ 7.9154968261719E-5 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 6415 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.079870223999023 milliseconds ^%^ 7.9870223999023E-5 seconds
344 of /var/www2/includes/header-menu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '14' ^%^ 0.078916549682617 milliseconds ^%^ 7.8916549682617E-5 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 6420 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.079870223999023 milliseconds ^%^ 7.9870223999023E-5 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 125 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.078916549682617 milliseconds ^%^ 7.8916549682617E-5 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 4225 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.078916549682617 milliseconds ^%^ 7.8916549682617E-5 seconds
179 of /var/www2/includes/header-menu.php - SELECT * FROM `lpdotcom`.`menu_items` WHERE `menu_id` = '56' AND (`gadget_id` IS NULL OR `gadget_id` != '12') AND (`link_url` IS NULL OR `link_url` NOT LIKE '%my-listings%') AND (`gadget_id` IS NULL OR `gadget_id` != '27') AND `hidden` = '0' ^%^ 0.092029571533203 milliseconds ^%^ 9.2029571533203E-5 seconds
201 of /var/www2/includes/header-menu.php - SELECT * FROM `lpdotcom`.`menu_items` WHERE `menu_id` = '56' AND (`gadget_id` IS NULL OR `gadget_id` != '12') AND (`link_url` IS NULL OR `link_url` NOT LIKE '%my-listings%') AND (`gadget_id` IS NULL OR `gadget_id` != '27') AND `hidden` = '0' ORDER BY `position` ^%^ 0.085830688476562 milliseconds ^%^ 8.5830688476562E-5 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 6456 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.078916549682617 milliseconds ^%^ 7.8916549682617E-5 seconds
309 of /var/www2/includes/header-menu.php - SELECT * FROM `lpdotcom`.`menu_items` WHERE `menu_id` = '56' AND (`gadget_id` IS NULL OR `gadget_id` != '12') AND (`link_url` IS NULL OR `link_url` NOT LIKE '%my-listings%') AND (`gadget_id` IS NULL OR `gadget_id` != '27') AND `hidden` = '0' ORDER BY `position` ^%^ 0.086069107055664 milliseconds ^%^ 8.6069107055664E-5 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 6456 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.077009201049805 milliseconds ^%^ 7.7009201049805E-5 seconds
344 of /var/www2/includes/header-menu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '20' ^%^ 0.08392333984375 milliseconds ^%^ 8.392333984375E-5 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 27 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.080108642578125 milliseconds ^%^ 8.0108642578125E-5 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 6469 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.081062316894531 milliseconds ^%^ 8.1062316894531E-5 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 6421 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.08082389831543 milliseconds ^%^ 8.082389831543E-5 seconds
179 of /var/www2/includes/header-menu.php - SELECT * FROM `lpdotcom`.`menu_items` WHERE `menu_id` = '85' AND (`gadget_id` IS NULL OR `gadget_id` != '12') AND (`link_url` IS NULL OR `link_url` NOT LIKE '%my-listings%') AND (`gadget_id` IS NULL OR `gadget_id` != '27') AND `hidden` = '0' ^%^ 0.085115432739258 milliseconds ^%^ 8.5115432739258E-5 seconds
201 of /var/www2/includes/header-menu.php - SELECT * FROM `lpdotcom`.`menu_items` WHERE `menu_id` = '85' AND (`gadget_id` IS NULL OR `gadget_id` != '12') AND (`link_url` IS NULL OR `link_url` NOT LIKE '%my-listings%') AND (`gadget_id` IS NULL OR `gadget_id` != '27') AND `hidden` = '0' ORDER BY `position` ^%^ 0.081062316894531 milliseconds ^%^ 8.1062316894531E-5 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 6471 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.081777572631836 milliseconds ^%^ 8.1777572631836E-5 seconds
179 of /var/www2/includes/header-menu.php - SELECT * FROM `lpdotcom`.`menu_items` WHERE `menu_id` = '61' AND (`gadget_id` IS NULL OR `gadget_id` != '12') AND (`link_url` IS NULL OR `link_url` NOT LIKE '%my-listings%') AND (`gadget_id` IS NULL OR `gadget_id` != '27') AND `hidden` = '0' ^%^ 0.087976455688477 milliseconds ^%^ 8.7976455688477E-5 seconds
201 of /var/www2/includes/header-menu.php - SELECT * FROM `lpdotcom`.`menu_items` WHERE `menu_id` = '61' AND (`gadget_id` IS NULL OR `gadget_id` != '12') AND (`link_url` IS NULL OR `link_url` NOT LIKE '%my-listings%') AND (`gadget_id` IS NULL OR `gadget_id` != '27') AND `hidden` = '0' ORDER BY `position` ^%^ 0.082969665527344 milliseconds ^%^ 8.2969665527344E-5 seconds
212 of /var/www2/includes/header-menu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '9' ^%^ 0.077009201049805 milliseconds ^%^ 7.7009201049805E-5 seconds
309 of /var/www2/includes/header-menu.php - SELECT * FROM `lpdotcom`.`menu_items` WHERE `menu_id` = '61' AND (`gadget_id` IS NULL OR `gadget_id` != '12') AND (`link_url` IS NULL OR `link_url` NOT LIKE '%my-listings%') AND (`gadget_id` IS NULL OR `gadget_id` != '27') AND `hidden` = '0' ORDER BY `position` ^%^ 0.08392333984375 milliseconds ^%^ 8.392333984375E-5 seconds
344 of /var/www2/includes/header-menu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '9' ^%^ 0.079870223999023 milliseconds ^%^ 7.9870223999023E-5 seconds
344 of /var/www2/includes/header-menu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '11' ^%^ 0.082015991210938 milliseconds ^%^ 8.2015991210938E-5 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 6415 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.077962875366211 milliseconds ^%^ 7.7962875366211E-5 seconds
179 of /var/www2/includes/header-menu.php - SELECT * FROM `lpdotcom`.`menu_items` WHERE `menu_id` = '27654' AND (`gadget_id` IS NULL OR `gadget_id` != '12') AND (`link_url` IS NULL OR `link_url` NOT LIKE '%my-listings%') AND (`gadget_id` IS NULL OR `gadget_id` != '27') AND `hidden` = '0' ^%^ 0.085830688476562 milliseconds ^%^ 8.5830688476562E-5 seconds
201 of /var/www2/includes/header-menu.php - SELECT * FROM `lpdotcom`.`menu_items` WHERE `menu_id` = '27654' AND (`gadget_id` IS NULL OR `gadget_id` != '12') AND (`link_url` IS NULL OR `link_url` NOT LIKE '%my-listings%') AND (`gadget_id` IS NULL OR `gadget_id` != '27') AND `hidden` = '0' ORDER BY `position` ^%^ 0.082015991210938 milliseconds ^%^ 8.2015991210938E-5 seconds
179 of /var/www2/includes/header-menu.php - SELECT * FROM `lpdotcom`.`menu_items` WHERE `menu_id` = '57' AND (`gadget_id` IS NULL OR `gadget_id` != '12') AND (`link_url` IS NULL OR `link_url` NOT LIKE '%my-listings%') AND (`gadget_id` IS NULL OR `gadget_id` != '27') AND `hidden` = '0' ^%^ 0.086069107055664 milliseconds ^%^ 8.6069107055664E-5 seconds
201 of /var/www2/includes/header-menu.php - SELECT * FROM `lpdotcom`.`menu_items` WHERE `menu_id` = '57' AND (`gadget_id` IS NULL OR `gadget_id` != '12') AND (`link_url` IS NULL OR `link_url` NOT LIKE '%my-listings%') AND (`gadget_id` IS NULL OR `gadget_id` != '27') AND `hidden` = '0' ORDER BY `position` ^%^ 0.082969665527344 milliseconds ^%^ 8.2969665527344E-5 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 573 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.078916549682617 milliseconds ^%^ 7.8916549682617E-5 seconds
309 of /var/www2/includes/header-menu.php - SELECT * FROM `lpdotcom`.`menu_items` WHERE `menu_id` = '57' AND (`gadget_id` IS NULL OR `gadget_id` != '12') AND (`link_url` IS NULL OR `link_url` NOT LIKE '%my-listings%') AND (`gadget_id` IS NULL OR `gadget_id` != '27') AND `hidden` = '0' ORDER BY `position` ^%^ 0.085115432739258 milliseconds ^%^ 8.5115432739258E-5 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 573 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.078916549682617 milliseconds ^%^ 7.8916549682617E-5 seconds
344 of /var/www2/includes/header-menu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '5' ^%^ 0.1380443572998 milliseconds ^%^ 0.0001380443572998 seconds
179 of /var/www2/includes/header-menu.php - SELECT * FROM `lpdotcom`.`menu_items` WHERE `menu_id` = '59' AND (`gadget_id` IS NULL OR `gadget_id` != '12') AND (`link_url` IS NULL OR `link_url` NOT LIKE '%my-listings%') AND (`gadget_id` IS NULL OR `gadget_id` != '27') AND `hidden` = '0' ^%^ 0.094890594482422 milliseconds ^%^ 9.4890594482422E-5 seconds
201 of /var/www2/includes/header-menu.php - SELECT * FROM `lpdotcom`.`menu_items` WHERE `menu_id` = '59' AND (`gadget_id` IS NULL OR `gadget_id` != '12') AND (`link_url` IS NULL OR `link_url` NOT LIKE '%my-listings%') AND (`gadget_id` IS NULL OR `gadget_id` != '27') AND `hidden` = '0' ORDER BY `position` ^%^ 0.085830688476562 milliseconds ^%^ 8.5830688476562E-5 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 55 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.077962875366211 milliseconds ^%^ 7.7962875366211E-5 seconds
309 of /var/www2/includes/header-menu.php - SELECT * FROM `lpdotcom`.`menu_items` WHERE `menu_id` = '59' AND (`gadget_id` IS NULL OR `gadget_id` != '12') AND (`link_url` IS NULL OR `link_url` NOT LIKE '%my-listings%') AND (`gadget_id` IS NULL OR `gadget_id` != '27') AND `hidden` = '0' ORDER BY `position` ^%^ 0.092029571533203 milliseconds ^%^ 9.2029571533203E-5 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 55 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.11110305786133 milliseconds ^%^ 0.00011110305786133 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 56 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.073909759521484 milliseconds ^%^ 7.3909759521484E-5 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 57 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.082969665527344 milliseconds ^%^ 8.2969665527344E-5 seconds
393 of /var/www2/includes/header-menu.php - totalFileTime: ^%^ 11.955976486206 milliseconds ^%^ 0.011955976486206 seconds
6105 of /var/www2/includes/functions.php - totalFileTime: 0.026941299438477 milliseconds ^%^ 2.6941299438477E-5 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 55 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.079870223999023 milliseconds ^%^ 7.9870223999023E-5 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 56 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.077962875366211 milliseconds ^%^ 7.7962875366211E-5 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 57 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.081062316894531 milliseconds ^%^ 8.1062316894531E-5 seconds
8 of /var/www2/includes/featuredproperty.php - SELECT * FROM `lpdotcom`.`featured_props` WHERE `agent_id` = '0' ORDER BY `id` DESC LIMIT 1; ^%^ 0.098943710327148 milliseconds ^%^ 9.8943710327148E-5 seconds
24 of /var/www2/includes/featuredproperty.php - SELECT * FROM `lpdotcom`.`props-main` WHERE `MLSFeed` = 'kings' AND `MLNumber` = '212527' AND `Delayed` = 0 LIMIT 1; ^%^ 0.50091743469238 milliseconds ^%^ 0.00050091743469238 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 586 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.08702278137207 milliseconds ^%^ 8.702278137207E-5 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 587 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.081062316894531 milliseconds ^%^ 8.1062316894531E-5 seconds
1686 of /var/www2/layouts/londonproperties-0/londonproperties-0.php - totalFileTime: 346.49801254272 milliseconds ^%^ 0.34649801254272 seconds

Total SQL Time: 391.90006256104 milliseconds / 0.39190006256104 seconds

Get Your FREE Copy
Share a few contact details and we will send you the guide to your inbox.