SQL ERROR :: 1064 :: You have an error in your SQL syntax; check the manual that corresponds to your ... 
SELECT AVG(middle_values) AS 'median' FROM ( SELECT t1.SP AS 'middle_values' FROM ( SELECT @row:=@row+1 as `row`, x.SP FROM nwmls.LISTINGS AS x, (SELECT @row:=0) AS r WHERE ST = 'S' AND LAG='28608' -- put some where clause here ORDER BY x.SP ) AS t1, ( SELECT COUNT(*) as 'count' FROM nwmls.LISTINGS x WHERE ST = 'S' AND LAG='28608' -- put same where clause here ) AS t2 -- the following condition will return 1 record for odd number sets, or 2 records for even number sets. WHERE t1.row >= t2.count/2 and t1.row <= ((t2.count/2) +1)) AS t3
BACKTRACE ::
   SQL_QUERY(
	SELECT AVG(middle_values) AS 'median' FROM (
	  SELECT t1.SP 
...) :: line #322, file: /var/www/web/includes/feed_stubs/agent.php
get_agent_median_price(
	SELECT AVG(middle_values) AS 'median' FROM (
	  SELECT t1.SP 
..., nwmls.LISTINGS, SP, LAG='28608') :: line #51, file: /var/www/web/htdocs/agents/kirkland_detail.php

SQL ERROR :: 1064 :: You have an error in your SQL syntax; check the manual that corresponds to your ... 
SELECT AVG(middle_values) AS 'median' FROM ( SELECT t1.SP AS 'middle_values' FROM ( SELECT @row:=@row+1 as `row`, x.SP FROM nwmls.LISTINGS AS x, (SELECT @row:=0) AS r WHERE ST = 'S' AND LAG='28608' -- put some where clause here ORDER BY x.SP ) AS t1, ( SELECT COUNT(*) as 'count' FROM nwmls.LISTINGS x WHERE ST = 'S' AND LAG='28608' -- put same where clause here ) AS t2 -- the following condition will return 1 record for odd number sets, or 2 records for even number sets. WHERE t1.row >= t2.count/2 and t1.row <= ((t2.count/2) +1)) AS t3
BACKTRACE ::
   SQL_QUERY(
	SELECT AVG(middle_values) AS 'median' FROM (
	  SELECT t1.SP 
...) :: line #322, file: /var/www/web/includes/feed_stubs/agent.php
get_agent_median_price(
	SELECT AVG(middle_values) AS 'median' FROM (
	  SELECT t1.SP 
..., nwmls.LISTINGS, SP, LAG='28608') :: line #51, file: /var/www/web/htdocs/agents/kirkland_detail.php
SQL ERROR :: 1064 :: You have an error in your SQL syntax; check the manual that corresponds to your ...
SELECT COUNT(*) AS c FROM nwmls.LISTINGS_SOLD WHERE (LAG='28608' OR SAG='28608' OR CLA='28608' )
BACKTRACE ::
   SQL_QUERY(
                SELECT 
                COUNT(*) AS c
         ...) :: line #175, file: /var/www/web/includes/feed_stubs/agent.php
get_agent_clients_counter(
                SELECT 
                COUNT(*) AS c
         ..., 28608) :: line #78, file: /var/www/web/htdocs/agents/kirkland_detail.php

SQL ERROR :: 1064 :: You have an error in your SQL syntax; check the manual that corresponds to your ... 
SELECT AVG(middle_values) AS 'median' FROM ( SELECT t1.SP AS 'middle_values' FROM ( SELECT @row:=@row+1 as `row`, x.SP FROM nwmls.LISTINGS AS x, (SELECT @row:=0) AS r WHERE ST = 'S' AND LAG='28608' -- put some where clause here ORDER BY x.SP ) AS t1, ( SELECT COUNT(*) as 'count' FROM nwmls.LISTINGS x WHERE ST = 'S' AND LAG='28608' -- put same where clause here ) AS t2 -- the following condition will return 1 record for odd number sets, or 2 records for even number sets. WHERE t1.row >= t2.count/2 and t1.row <= ((t2.count/2) +1)) AS t3
BACKTRACE ::
   SQL_QUERY(
	SELECT AVG(middle_values) AS 'median' FROM (
	  SELECT t1.SP 
...) :: line #322, file: /var/www/web/includes/feed_stubs/agent.php
get_agent_median_price(
	SELECT AVG(middle_values) AS 'median' FROM (
	  SELECT t1.SP 
..., nwmls.LISTINGS, SP, LAG='28608') :: line #51, file: /var/www/web/htdocs/agents/kirkland_detail.php
SQL ERROR :: 1064 :: You have an error in your SQL syntax; check the manual that corresponds to your ...
SELECT COUNT(*) AS c FROM nwmls.LISTINGS_SOLD WHERE (LAG='28608' OR SAG='28608' OR CLA='28608' )
BACKTRACE ::
   SQL_QUERY(
                SELECT 
                COUNT(*) AS c
         ...) :: line #175, file: /var/www/web/includes/feed_stubs/agent.php
get_agent_clients_counter(
                SELECT 
                COUNT(*) AS c
         ..., 28608) :: line #78, file: /var/www/web/htdocs/agents/kirkland_detail.php
SQL ERROR :: 1064 :: You have an error in your SQL syntax; check the manual that corresponds to your ...
SELECT COUNT(*) AS c FROM nwmls.LISTINGS_SOLD WHERE (LAG='28608' OR SAG='28608' OR CLA='28608' )
BACKTRACE ::
   SQL_QUERY(
                SELECT 
                COUNT(*) AS c
         ...) :: line #175, file: /var/www/web/includes/feed_stubs/agent.php
get_agent_clients_counter(
                SELECT 
                COUNT(*) AS c
         ..., 28608, 0) :: line #82, file: /var/www/web/htdocs/agents/kirkland_detail.php

SQL ERROR :: 1064 :: You have an error in your SQL syntax; check the manual that corresponds to your ... 
SELECT AVG(middle_values) AS 'median' FROM ( SELECT t1.SP AS 'middle_values' FROM ( SELECT @row:=@row+1 as `row`, x.SP FROM nwmls.LISTINGS AS x, (SELECT @row:=0) AS r WHERE ST = 'S' AND LAG='28608' -- put some where clause here ORDER BY x.SP ) AS t1, ( SELECT COUNT(*) as 'count' FROM nwmls.LISTINGS x WHERE ST = 'S' AND LAG='28608' -- put same where clause here ) AS t2 -- the following condition will return 1 record for odd number sets, or 2 records for even number sets. WHERE t1.row >= t2.count/2 and t1.row <= ((t2.count/2) +1)) AS t3
BACKTRACE ::
   SQL_QUERY(
	SELECT AVG(middle_values) AS 'median' FROM (
	  SELECT t1.SP 
...) :: line #322, file: /var/www/web/includes/feed_stubs/agent.php
get_agent_median_price(
	SELECT AVG(middle_values) AS 'median' FROM (
	  SELECT t1.SP 
..., nwmls.LISTINGS, SP, LAG='28608') :: line #51, file: /var/www/web/htdocs/agents/kirkland_detail.php
SQL ERROR :: 1064 :: You have an error in your SQL syntax; check the manual that corresponds to your ...
SELECT COUNT(*) AS c FROM nwmls.LISTINGS_SOLD WHERE (LAG='28608' OR SAG='28608' OR CLA='28608' )
BACKTRACE ::
   SQL_QUERY(
                SELECT 
                COUNT(*) AS c
         ...) :: line #175, file: /var/www/web/includes/feed_stubs/agent.php
get_agent_clients_counter(
                SELECT 
                COUNT(*) AS c
         ..., 28608) :: line #78, file: /var/www/web/htdocs/agents/kirkland_detail.php
SQL ERROR :: 1064 :: You have an error in your SQL syntax; check the manual that corresponds to your ...
SELECT COUNT(*) AS c FROM nwmls.LISTINGS_SOLD WHERE (LAG='28608' OR SAG='28608' OR CLA='28608' )
BACKTRACE ::
   SQL_QUERY(
                SELECT 
                COUNT(*) AS c
         ...) :: line #175, file: /var/www/web/includes/feed_stubs/agent.php
get_agent_clients_counter(
                SELECT 
                COUNT(*) AS c
         ..., 28608, 0) :: line #82, file: /var/www/web/htdocs/agents/kirkland_detail.php
SQL ERROR :: 1064 :: You have an error in your SQL syntax; check the manual that corresponds to your ...
SELECT MIN(UNIX_TIMESTAMP(LD)) AS first_deal_time FROM nwmls.LISTINGS_SOLD AS nwmls WHERE (LAG='28608' OR SAG='28608' OR CLA = '') LIMIT 1
BACKTRACE ::
   SQL_QUERY(
        SELECT 
            MIN(UNIX_TIMESTAMP(LD)) AS first_de...) :: line #218, file: /var/www/web/includes/feed_stubs/agent.php
get_first_deal_time(
        SELECT 
            MIN(UNIX_TIMESTAMP(LD)) AS first_de..., 28608) :: line #89, file: /var/www/web/htdocs/agents/kirkland_detail.php

SQL ERROR :: 1064 :: You have an error in your SQL syntax; check the manual that corresponds to your ... 
SELECT AVG(middle_values) AS 'median' FROM ( SELECT t1.SP AS 'middle_values' FROM ( SELECT @row:=@row+1 as `row`, x.SP FROM nwmls.LISTINGS AS x, (SELECT @row:=0) AS r WHERE ST = 'S' AND LAG='28608' -- put some where clause here ORDER BY x.SP ) AS t1, ( SELECT COUNT(*) as 'count' FROM nwmls.LISTINGS x WHERE ST = 'S' AND LAG='28608' -- put same where clause here ) AS t2 -- the following condition will return 1 record for odd number sets, or 2 records for even number sets. WHERE t1.row >= t2.count/2 and t1.row <= ((t2.count/2) +1)) AS t3
BACKTRACE ::
   SQL_QUERY(
	SELECT AVG(middle_values) AS 'median' FROM (
	  SELECT t1.SP 
...) :: line #322, file: /var/www/web/includes/feed_stubs/agent.php
get_agent_median_price(
	SELECT AVG(middle_values) AS 'median' FROM (
	  SELECT t1.SP 
..., nwmls.LISTINGS, SP, LAG='28608') :: line #51, file: /var/www/web/htdocs/agents/kirkland_detail.php
SQL ERROR :: 1064 :: You have an error in your SQL syntax; check the manual that corresponds to your ...
SELECT COUNT(*) AS c FROM nwmls.LISTINGS_SOLD WHERE (LAG='28608' OR SAG='28608' OR CLA='28608' )
BACKTRACE ::
   SQL_QUERY(
                SELECT 
                COUNT(*) AS c
         ...) :: line #175, file: /var/www/web/includes/feed_stubs/agent.php
get_agent_clients_counter(
                SELECT 
                COUNT(*) AS c
         ..., 28608) :: line #78, file: /var/www/web/htdocs/agents/kirkland_detail.php
SQL ERROR :: 1064 :: You have an error in your SQL syntax; check the manual that corresponds to your ...
SELECT COUNT(*) AS c FROM nwmls.LISTINGS_SOLD WHERE (LAG='28608' OR SAG='28608' OR CLA='28608' )
BACKTRACE ::
   SQL_QUERY(
                SELECT 
                COUNT(*) AS c
         ...) :: line #175, file: /var/www/web/includes/feed_stubs/agent.php
get_agent_clients_counter(
                SELECT 
                COUNT(*) AS c
         ..., 28608, 0) :: line #82, file: /var/www/web/htdocs/agents/kirkland_detail.php
SQL ERROR :: 1064 :: You have an error in your SQL syntax; check the manual that corresponds to your ...
SELECT MIN(UNIX_TIMESTAMP(LD)) AS first_deal_time FROM nwmls.LISTINGS_SOLD AS nwmls WHERE (LAG='28608' OR SAG='28608' OR CLA = '') LIMIT 1
BACKTRACE ::
   SQL_QUERY(
        SELECT 
            MIN(UNIX_TIMESTAMP(LD)) AS first_de...) :: line #218, file: /var/www/web/includes/feed_stubs/agent.php
get_first_deal_time(
        SELECT 
            MIN(UNIX_TIMESTAMP(LD)) AS first_de..., 28608) :: line #89, file: /var/www/web/htdocs/agents/kirkland_detail.php
SQL ERROR :: 1064 :: You have an error in your SQL syntax; check the manual that corresponds to your ...
SELECT COUNT(LN) AS num FROM nwmls.LISTINGS_SOLD WHERE (LAG='28608'OR SAG= '28608' OR CLA='28608')
BACKTRACE ::
   SQL_QUERY(
            SELECT 
                COUNT(LN) AS num
          ...) :: line #53, file: /var/www/web/includes/feed_stubs/agent.php
get_closed_homes(
            SELECT 
                COUNT(LN) AS num
          ..., Array[24]) :: line #92, file: /var/www/web/htdocs/agents/kirkland_detail.php

AssetRealtyGroup - Kirkland
Contact
Melissa Canfield, Associate
Brokerage: Asset Realty Group
Phone (Office) #: 425.250.3301
Phone (Mobile) #: 425.238.1298
Phone (Fax) #: 425.952.0123

Why work with a Asset agent?

  • We're on your side: we use industry leading custom software to get the job done. Whether you're buying or selling.
  • We're always here:You're backed by a team always. Our entire staff is dedicated to provide the best level of service to you.
Let the winning team at Asset and Melissa help you with your next real estate transaction!

A Little Bit About Melissa

Managing Real Estate Broker

  • My name is Melissa Canfield and I am a Managing Real Estate Broker with Century 21 Northwest Realty and a Mortgage Broker with All Square Mortgage. I have been in the real estate business for 13 years servicing residential and investment property buyers and sellers throughout Snohomish, King and Skagit Counties. I also have owned my own brokerage for a period of time. Additionally, I have been in the mortgage industry for 23 years and therefore am well-versed on all the financing options that are available for home buyers today. In addition, I have bought and sold many investment properties over the years, and am experienced with finding the best rental properties for my clients. Prior to my career in mortgage lending and real estate, I was in retail management with Nordstrom for 11 years where we all know customer service is number one!

Serving:

Seattle, Monroe, Marysville, Everett, Granite Falls

The database information herein is provided from and copyrighted by the Northwest Multiple Listing Service (NWMLS). NWMLS data may not be reproduced or redistributed and is only for people viewing this site. All information provided is deemed reliable but is not guaranteed and should be independently verified. All properties are subject to prior sale or withdrawal. All rights are reserved by copyright.

Are you sure?

0/250
+