Homes for Sale Fresno | Clovis Homes | Real Estate

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

Safely View Any Home - Live Virtual Showings!

By searching, you agree to the end user license agreement

New Listings	Open Houses	Detailed Search
Find Nearby Properties

Though our strength is based on deep valley roots, we are also proud to be affiliated with 'Leading Real Estate Companies of the World'

AFFILIATED BUSINESS DISCLOSURE

OPEN HOUSES

MY HOME'S VALUE

HOME VALUE CALCULATOR

Find out how much your home or property is worth

NEW LISTINGS SENT TO YOU DAILY

FIND-IT-FIRST: BE THE FIRST TO KNOW

Get new property listings by email every day - be the first to know!

FEDS PROJECT THREE INTEREST RATE RISES IN 2022!

MARKET UPDATES

CAREERS

GET MORE:
• MONEY
• TIME
• FREEDOM

Licensing info, courses, career seminars

NATURAL HAZARD REPORTS

FIND-IT-FIRST

Be the first to be notified when your dream home is available.

CREATE A NEW ACCOUNT

London Properties on Instagram:

Connect with us

London Properties, the number one Fresno / Clovis / Madera real estate company with more homes than anyone. Search for homes, Real Estate, foreclosures, luxury homes and property in Fresno, Clovis, Madera, Coarsegold, Hanford, Kingsburg, Madera, Merced, Oakhurst, Prather, Reedley, Sanger, Selma, Kingsburg, Visalia, Tulare, Chowchilla, and the Central Valley. London Properties specializes in neighborhoods and communities including Harlan Ranch, Old Fig Garden, Van Ness, Lake Van Ness, Bullard High, Tower District, Copper River, Fresno High, Woodward Park, Woodward Lake, Sunnyside, Clovis High, Buchanan, Central High, and Fresno State.

Leading Real Estate Companies Of The World

Website Accessibility Disclaimer - London Properties, Ltd. is committed to providing an accessible website to those with special needs, including those with visual, hearing, cognitive and motor impairments. Our efforts to make this website adhere to WCAG 2.0 conformity guidelines are ongoing, so if you come across a page you find difficult to use, please contact London Properties to specify the nature of the accessibility issue and any assistive technology you use. London Properties will strive to provide the content you need in the format you require.

AGENTS: THE LONDON EDGE| LONDON MAIL| LONDON FORMS| LEADING RE OUR WORLD

6105 of /var/www2/includes/functions.php - totalFileTime: 6.511926651001 milliseconds ^%^ 0.006511926651001 seconds
33 of /var/www2/index.php - SELECT * FROM `lpdotcom`.`sites` WHERE `url` != '' AND `url` != 'www.londonproperties.com' ORDER BY `sites`.`url` ^%^ 0.35285949707031 milliseconds ^%^ 0.00035285949707031 seconds
6105 of /var/www2/includes/functions.php - totalFileTime: 0.026941299438477 milliseconds ^%^ 2.6941299438477E-5 seconds
1667 of /var/www2/actions/initialize-dat-mofo.php - SELECT * FROM `lpdotcom`.`sold_data` WHERE `id` < 0 0.30994415283203 milliseconds ^%^ 0.00030994415283203 seconds
1776 of /var/www2/actions/initialize-dat-mofo.php - SELECT `id`,`agent_id` FROM `lpdotcom`.`sites` WHERE `url` = 'www.yourrealtor559.com' OR `url` = 'www.www.yourrealtor559.com' LIMIT 1 0.25796890258789 milliseconds ^%^ 0.00025796890258789 seconds
354 of /var/www2/includes/functions.php - check_for_scss 0.029087066650391 milliseconds ^%^ 2.9087066650391E-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.2589225769043 milliseconds ^%^ 0.0002589225769043 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.25391578674316 milliseconds ^%^ 0.00025391578674316 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; ^%^ 5.7229995727539 milliseconds ^%^ 0.0057229995727539 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 ^%^ 3.9529800415039 milliseconds ^%^ 0.0039529800415039 seconds
169 of /var/www2/includes/header-minimalMenu.php - SELECT `id` FROM `lpdotcom`.`pages` WHERE `is_mn` = 1; ^%^ 3.9749145507812 milliseconds ^%^ 0.0039749145507812 seconds
181 of /var/www2/includes/header-minimalMenu.php - SELECT `id` FROM `lpdotcom`.`pages` WHERE `is_as` = 1; ^%^ 3.9780139923096 milliseconds ^%^ 0.0039780139923096 seconds
868 of /var/www2/includes/header-minimalMenu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '10' ^%^ 3.7670135498047 milliseconds ^%^ 0.0037670135498047 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' ^%^ 3.9608478546143 milliseconds ^%^ 0.0039608478546143 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` ^%^ 3.978967666626 milliseconds ^%^ 0.003978967666626 seconds
842 of /var/www2/includes/header-minimalMenu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '1' ^%^ 0.087976455688477 milliseconds ^%^ 8.7976455688477E-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.084161758422852 milliseconds ^%^ 8.4161758422852E-5 seconds
943 of /var/www2/includes/header-minimalMenu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '1' ^%^ 0.077962875366211 milliseconds ^%^ 7.7962875366211E-5 seconds
943 of /var/www2/includes/header-minimalMenu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '7' ^%^ 0.077962875366211 milliseconds ^%^ 7.7962875366211E-5 seconds
943 of /var/www2/includes/header-minimalMenu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '4' ^%^ 0.077962875366211 milliseconds ^%^ 7.7962875366211E-5 seconds
943 of /var/www2/includes/header-minimalMenu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '2' ^%^ 0.075101852416992 milliseconds ^%^ 7.5101852416992E-5 seconds
943 of /var/www2/includes/header-minimalMenu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '24' ^%^ 0.077962875366211 milliseconds ^%^ 7.7962875366211E-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.077009201049805 milliseconds ^%^ 7.7009201049805E-5 seconds
943 of /var/www2/includes/header-minimalMenu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '14' ^%^ 0.077009201049805 milliseconds ^%^ 7.7009201049805E-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.076055526733398 milliseconds ^%^ 7.6055526733398E-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.076055526733398 milliseconds ^%^ 7.6055526733398E-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
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.083208084106445 milliseconds ^%^ 8.3208084106445E-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.078916549682617 milliseconds ^%^ 7.8916549682617E-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
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.082015991210938 milliseconds ^%^ 8.2015991210938E-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.075817108154297 milliseconds ^%^ 7.5817108154297E-5 seconds
943 of /var/www2/includes/header-minimalMenu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '20' ^%^ 0.078916549682617 milliseconds ^%^ 7.8916549682617E-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.074148178100586 milliseconds ^%^ 7.4148178100586E-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.084877014160156 milliseconds ^%^ 8.4877014160156E-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.075101852416992 milliseconds ^%^ 7.5101852416992E-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.082969665527344 milliseconds ^%^ 8.2969665527344E-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.077009201049805 milliseconds ^%^ 7.7009201049805E-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.076055526733398 milliseconds ^%^ 7.6055526733398E-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.081062316894531 milliseconds ^%^ 8.1062316894531E-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.077009201049805 milliseconds ^%^ 7.7009201049805E-5 seconds
842 of /var/www2/includes/header-minimalMenu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '9' ^%^ 0.074148178100586 milliseconds ^%^ 7.4148178100586E-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.077962875366211 milliseconds ^%^ 7.7962875366211E-5 seconds
943 of /var/www2/includes/header-minimalMenu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '9' ^%^ 0.074863433837891 milliseconds ^%^ 7.4863433837891E-5 seconds
943 of /var/www2/includes/header-minimalMenu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '11' ^%^ 0.089883804321289 milliseconds ^%^ 8.9883804321289E-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.074148178100586 milliseconds ^%^ 7.4148178100586E-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.082969665527344 milliseconds ^%^ 8.2969665527344E-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.074863433837891 milliseconds ^%^ 7.4863433837891E-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.079870223999023 milliseconds ^%^ 7.9870223999023E-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.092029571533203 milliseconds ^%^ 9.2029571533203E-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.074148178100586 milliseconds ^%^ 7.4148178100586E-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.081062316894531 milliseconds ^%^ 8.1062316894531E-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.07319450378418 milliseconds ^%^ 7.319450378418E-5 seconds
943 of /var/www2/includes/header-minimalMenu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '5' ^%^ 0.075101852416992 milliseconds ^%^ 7.5101852416992E-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.081062316894531 milliseconds ^%^ 8.1062316894531E-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.076055526733398 milliseconds ^%^ 7.6055526733398E-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.072956085205078 milliseconds ^%^ 7.2956085205078E-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.079154968261719 milliseconds ^%^ 7.9154968261719E-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.072956085205078 milliseconds ^%^ 7.2956085205078E-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.07319450378418 milliseconds ^%^ 7.319450378418E-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.073909759521484 milliseconds ^%^ 7.3909759521484E-5 seconds
983 of /var/www2/includes/header-minimalMenu.php - totalFileTime: ^%^ 40.712833404541 milliseconds ^%^ 0.040712833404541 seconds
400 of /var/www2/includes/header-accountTab.php - totalFileTime: ^%^ 0.13494491577148 milliseconds ^%^ 0.00013494491577148 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; ^%^ 1.0051727294922 milliseconds ^%^ 0.0010051727294922 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.085830688476562 milliseconds ^%^ 8.5830688476562E-5 seconds
239 of /var/www2/includes/header-menu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '10' ^%^ 0.079154968261719 milliseconds ^%^ 7.9154968261719E-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.084161758422852 milliseconds ^%^ 8.4161758422852E-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.079154968261719 milliseconds ^%^ 7.9154968261719E-5 seconds
212 of /var/www2/includes/header-menu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '1' ^%^ 0.072002410888672 milliseconds ^%^ 7.2002410888672E-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.084161758422852 milliseconds ^%^ 8.4161758422852E-5 seconds
344 of /var/www2/includes/header-menu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '1' ^%^ 0.074863433837891 milliseconds ^%^ 7.4863433837891E-5 seconds
344 of /var/www2/includes/header-menu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '7' ^%^ 0.075101852416992 milliseconds ^%^ 7.5101852416992E-5 seconds
344 of /var/www2/includes/header-menu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '4' ^%^ 0.076055526733398 milliseconds ^%^ 7.6055526733398E-5 seconds
344 of /var/www2/includes/header-menu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '2' ^%^ 0.073909759521484 milliseconds ^%^ 7.3909759521484E-5 seconds
344 of /var/www2/includes/header-menu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '24' ^%^ 0.075817108154297 milliseconds ^%^ 7.5817108154297E-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.074863433837891 milliseconds ^%^ 7.4863433837891E-5 seconds
344 of /var/www2/includes/header-menu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '14' ^%^ 0.076055526733398 milliseconds ^%^ 7.6055526733398E-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.075101852416992 milliseconds ^%^ 7.5101852416992E-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.072956085205078 milliseconds ^%^ 7.2956085205078E-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.075101852416992 milliseconds ^%^ 7.5101852416992E-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.08082389831543 milliseconds ^%^ 8.082389831543E-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.077962875366211 milliseconds ^%^ 7.7962875366211E-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.075817108154297 milliseconds ^%^ 7.5817108154297E-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.082969665527344 milliseconds ^%^ 8.2969665527344E-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.075101852416992 milliseconds ^%^ 7.5101852416992E-5 seconds
344 of /var/www2/includes/header-menu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '20' ^%^ 0.077009201049805 milliseconds ^%^ 7.7009201049805E-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.07319450378418 milliseconds ^%^ 7.319450378418E-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.075101852416992 milliseconds ^%^ 7.5101852416992E-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.073909759521484 milliseconds ^%^ 7.3909759521484E-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.079870223999023 milliseconds ^%^ 7.9870223999023E-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.076055526733398 milliseconds ^%^ 7.6055526733398E-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.075101852416992 milliseconds ^%^ 7.5101852416992E-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.081062316894531 milliseconds ^%^ 8.1062316894531E-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.076055526733398 milliseconds ^%^ 7.6055526733398E-5 seconds
212 of /var/www2/includes/header-menu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '9' ^%^ 0.072002410888672 milliseconds ^%^ 7.2002410888672E-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.079154968261719 milliseconds ^%^ 7.9154968261719E-5 seconds
344 of /var/www2/includes/header-menu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '9' ^%^ 0.076055526733398 milliseconds ^%^ 7.6055526733398E-5 seconds
344 of /var/www2/includes/header-menu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '11' ^%^ 0.076055526733398 milliseconds ^%^ 7.6055526733398E-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.074863433837891 milliseconds ^%^ 7.4863433837891E-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.082969665527344 milliseconds ^%^ 8.2969665527344E-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.076055526733398 milliseconds ^%^ 7.6055526733398E-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.079154968261719 milliseconds ^%^ 7.9154968261719E-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.27108192443848 milliseconds ^%^ 0.00027108192443848 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.072956085205078 milliseconds ^%^ 7.2956085205078E-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.3819465637207 milliseconds ^%^ 0.0003819465637207 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.073909759521484 milliseconds ^%^ 7.3909759521484E-5 seconds
344 of /var/www2/includes/header-menu.php - SELECT `path` FROM `lpdotcom`.`gadgets` WHERE `id` = '5' ^%^ 0.076055526733398 milliseconds ^%^ 7.6055526733398E-5 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.078916549682617 milliseconds ^%^ 7.8916549682617E-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.077009201049805 milliseconds ^%^ 7.7009201049805E-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.074148178100586 milliseconds ^%^ 7.4148178100586E-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.080108642578125 milliseconds ^%^ 8.0108642578125E-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.072956085205078 milliseconds ^%^ 7.2956085205078E-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.23198127746582 milliseconds ^%^ 0.00023198127746582 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.57411193847656 milliseconds ^%^ 0.00057411193847656 seconds
393 of /var/www2/includes/header-menu.php - totalFileTime: ^%^ 13.82303237915 milliseconds ^%^ 0.01382303237915 seconds
6105 of /var/www2/includes/functions.php - totalFileTime: 0.02598762512207 milliseconds ^%^ 2.598762512207E-5 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.15807151794434 milliseconds ^%^ 0.00015807151794434 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 70 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.4730224609375 milliseconds ^%^ 0.0004730224609375 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.079154968261719 milliseconds ^%^ 7.9154968261719E-5 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 5923 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.28300285339355 milliseconds ^%^ 0.00028300285339355 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 70 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.074863433837891 milliseconds ^%^ 7.4863433837891E-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.076055526733398 milliseconds ^%^ 7.6055526733398E-5 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 5923 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.076055526733398 milliseconds ^%^ 7.6055526733398E-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.073909759521484 milliseconds ^%^ 7.3909759521484E-5 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 5333 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.077009201049805 milliseconds ^%^ 7.7009201049805E-5 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.077009201049805 milliseconds ^%^ 7.7009201049805E-5 seconds
596 of /var/www2/includes/functions.php - SELECT `page_title` FROM `lpdotcom`.`pages` WHERE `id` = 7161 AND `page_title` IS NOT NULL AND TRIM(`page_title`) != '' LIMIT 1; 0.076055526733398 milliseconds ^%^ 7.6055526733398E-5 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.074863433837891 milliseconds ^%^ 7.4863433837891E-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.084161758422852 milliseconds ^%^ 8.4161758422852E-5 seconds
1686 of /var/www2/layouts/londonproperties-0/londonproperties-0.php - totalFileTime: 536.88287734985 milliseconds ^%^ 0.53688287734985 seconds

Total SQL Time: 640.20299911499 milliseconds / 0.64020299911499 seconds

AFFILIATED BUSINESS DISCLOSURE

WHY LIST WITH US?

REVIEW US

EXCLUSIVE LISTINGS

CRIME

AGENT STUFF

EXCLUSIVE LISTINGS

HOME LOANS

INSURANCE QUOTES

FIND AN AGENT

WHY LIST WITH US?

REVIEW US

CRIME

AGENT STUFF

OPEN HOUSES