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='95288'
		  -- put some where clause here
		  ORDER BY x.SP
		) AS t1,
		(
		  SELECT COUNT(*) as 'count'
		  FROM nwmls.LISTINGS x
		  WHERE ST = 'S' AND LAG='95288'
		  -- 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='95288') :: 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='95288'
		  -- put some where clause here
		  ORDER BY x.SP
		) AS t1,
		(
		  SELECT COUNT(*) as 'count'
		  FROM nwmls.LISTINGS x
		  WHERE ST = 'S' AND LAG='95288'
		  -- 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='95288') :: 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='95288'
				OR SAG='95288'
				OR CLA='95288'
			)
            

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
         ..., 95288) :: 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='95288'
		  -- put some where clause here
		  ORDER BY x.SP
		) AS t1,
		(
		  SELECT COUNT(*) as 'count'
		  FROM nwmls.LISTINGS x
		  WHERE ST = 'S' AND LAG='95288'
		  -- 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='95288') :: 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='95288'
				OR SAG='95288'
				OR CLA='95288'
			)
            

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
         ..., 95288) :: 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='95288'
				OR SAG='95288'
				OR CLA='95288'
			)
            

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
         ..., 95288, 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='95288'
		  -- put some where clause here
		  ORDER BY x.SP
		) AS t1,
		(
		  SELECT COUNT(*) as 'count'
		  FROM nwmls.LISTINGS x
		  WHERE ST = 'S' AND LAG='95288'
		  -- 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='95288') :: 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='95288'
				OR SAG='95288'
				OR CLA='95288'
			)
            

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
         ..., 95288) :: 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='95288'
				OR SAG='95288'
				OR CLA='95288'
			)
            

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
         ..., 95288, 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='95288' OR SAG='95288' 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..., 95288) :: 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='95288'
		  -- put some where clause here
		  ORDER BY x.SP
		) AS t1,
		(
		  SELECT COUNT(*) as 'count'
		  FROM nwmls.LISTINGS x
		  WHERE ST = 'S' AND LAG='95288'
		  -- 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='95288') :: 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='95288'
				OR SAG='95288'
				OR CLA='95288'
			)
            

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
         ..., 95288) :: 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='95288'
				OR SAG='95288'
				OR CLA='95288'
			)
            

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
         ..., 95288, 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='95288' OR SAG='95288' 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..., 95288) :: 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='95288'OR SAG= '95288' OR CLA='95288')
	

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

Call: 425-250-3301

Sign In or Join Asset

A My Asset account helps you track your favorite homes, get custom alerts when new listings hit the market, and work with Asset Realty Group agents.

• SEARCH FOR HOMES
• REAL ESTATE AGENTS
• BUYING
  • Mortgage Calculator
  • First-Time Buyers
  • Financing
  • Stop Paying Rent
  • Relocation
• SELLING
  • How much is my home worth
  • Why Asset Is Better
  • Seller Mistakes

Contact

Romi Hancock, Associate

Brokerage: Asset Realty Group

Phone (Office) #: 425-250-3301

Phone (Mobile) #: 425-625-3000

Phone (Fax) #: 425-629-9998

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 Romi help you with your next real estate transaction!

---

A Little Bit About Romi

Romi holds the customer service bar high. As an Asset Realty Group broker you can expect Romi to always be on your side and to be availabe for any of your real estate needs. Please check back soon for more about Romi!

Serving:

Vashon, Seattle, Des Moines, Maple Valley, Issaquah

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.

BUYERS	RESOURCES	COMPANY
Mortgage Calculator First-Time Buyers Financing Stop Paying Rent Relocation	Bellevue Issaquah Kirkland Redmond Seattle	Company Overview History of Asset Our Agents Contact Us	Properties Bought Loading...

Century21 Northwest | AssetRealtyGroup.com | 425-250-3301 | admin@assetrealtygroup.com

Programming ©2005-2021 Asset Realty Group. All rights reserved. Privacy Policy

Real Estate Site by Asset Realty Group