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='55147' -- put some where clause here ORDER BY x.SP ) AS t1, ( SELECT COUNT(*) as 'count' FROM nwmls.LISTINGS x WHERE ST = 'S' AND LAG='55147' -- 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='55147') :: 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='55147' -- put some where clause here ORDER BY x.SP ) AS t1, ( SELECT COUNT(*) as 'count' FROM nwmls.LISTINGS x WHERE ST = 'S' AND LAG='55147' -- 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='55147') :: 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='55147' OR SAG='55147' OR CLA='55147' )
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
         ..., 55147) :: 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='55147' -- put some where clause here ORDER BY x.SP ) AS t1, ( SELECT COUNT(*) as 'count' FROM nwmls.LISTINGS x WHERE ST = 'S' AND LAG='55147' -- 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='55147') :: 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='55147' OR SAG='55147' OR CLA='55147' )
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
         ..., 55147) :: 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='55147' OR SAG='55147' OR CLA='55147' )
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
         ..., 55147, 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='55147' -- put some where clause here ORDER BY x.SP ) AS t1, ( SELECT COUNT(*) as 'count' FROM nwmls.LISTINGS x WHERE ST = 'S' AND LAG='55147' -- 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='55147') :: 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='55147' OR SAG='55147' OR CLA='55147' )
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
         ..., 55147) :: 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='55147' OR SAG='55147' OR CLA='55147' )
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
         ..., 55147, 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='55147' OR SAG='55147' 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..., 55147) :: 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='55147' -- put some where clause here ORDER BY x.SP ) AS t1, ( SELECT COUNT(*) as 'count' FROM nwmls.LISTINGS x WHERE ST = 'S' AND LAG='55147' -- 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='55147') :: 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='55147' OR SAG='55147' OR CLA='55147' )
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
         ..., 55147) :: 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='55147' OR SAG='55147' OR CLA='55147' )
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
         ..., 55147, 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='55147' OR SAG='55147' 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..., 55147) :: 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='55147'OR SAG= '55147' OR CLA='55147')
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
Stuart Anderson, Associate
Brokerage: Asset Realty Group
Phone (Office) #: 425-250-3301
Phone (Mobile) #: 425-351-5100
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 Stuart help you with your next real estate transaction!

A Little Bit About Stuart

Broker

  • Thank you for visiting my profile. I want your experience here to be worth your while. I never want to waste a minute of your time. My number one goal is to serve my listing and buyer clients as a valued real estate professional. Two of my passions are realized in the business of real estate. First, I love helping people successfully reach their goals! Whether it's listing and marketing your home, a first time home buyer or a seasoned individual stepping up to the home of their dreams, I am committed to providing current information, trustworthy advice and professional service every step of the way. My clients appreciate that I have more that fourteen years of real estate experience in the greater Seattle area's. I am now working in Kittitas county, as I have been going over there since the mid 1970's. Upper Kittitas county is a mecca for outdoor fun in all the season's. Before entering the field of real estate I worked in residential and commercial construction for twelve years. I stay current on the economic changes in lending matters, tax issues and other key details that influence my clients' decisions when they are ready to purchase a home. I value the long term relationships I have had with my clients and look forward to developing one with you. I am grateful for your consideration to be your real estate professional.

Serving:

98006,98004,98001

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
+