Company Logo
Greenville SC Homes and Real Estate
ERA Greenville, Greenville SC 29607
To Contact one of our Outstanding Realtors.
Call: 864-235-0209, Toll Free: 866-206-3910
ERA Logo

This property is no longer available

The last day that this property was available was 2015-08-10

Boiling Springs SC Home for Sale $0 at 290 Chateau St

This property is no longer available, please search for another. 3 Bedrooms, 2 Full Baths, 1 Half Bath
290 Chateau St     Boiling Springs, SC 29316
1250-1499 sq ft on 0.27 acres

   
For Realtor Help
Brian ONeill
864-497-7107

   
For Lender Help
Greg Bailey
864-316-6213
Property Features
Marker position questionable: street name not found.
 
Map Quest
Yahoo Maps
Google Maps
 
 Privacy Policy  |  Sitemap  |  Webmaster              Independent Member Broker, Copyright © 2007-2015 ERA Greenville. All rights reserved.            


30 Photos

290 Chateau St Boiling Springs SC Home Boiling Springs SC Home 2Boiling Springs SC Home 3Boiling Springs SC Home 4Boiling Springs SC Home 5Boiling Springs SC Home 6Boiling Springs SC Home 7Boiling Springs SC Home 8Boiling Springs SC Home 9Boiling Springs SC Home 10Boiling Springs SC Home 11Boiling Springs SC Home 12Boiling Springs SC Home 13Boiling Springs SC Home 14Boiling Springs SC Home 15Boiling Springs SC Home 16Boiling Springs SC Home 17Boiling Springs SC Home 18Boiling Springs SC Home 19Boiling Springs SC Home 20Boiling Springs SC Home 21Boiling Springs SC Home 22Boiling Springs SC Home 23Boiling Springs SC Home 24Boiling Springs SC Home 25Boiling Springs SC Home 26Boiling Springs SC Home 27Boiling Springs SC Home 28Boiling Springs SC Home 29Boiling Springs SC Home 30
This information is deemed reliable but not guaranteed. Neither the Greater Greenville Association of Realtors®, Inc., Multiple Listing Service of Greenville South Carolina, Inc., Spartanburg Association of Realtors®, Inc., Multiple Listing Service of Spartanburg South Carolina, Inc., Anderson Association of Realtors®, Inc. or Upstate Multiple Listing Service of South Carolina, Inc., not the listing broker, not their subagents are responsible for the accuracy of the information. The buyer is responsible for verifying all information. This information is provided by the Greeter Greenville Association of Realtors®, Inc., Multiple Listing Service of Greenville South Carolina, Inc., Spartanburg Association of Realtors®, Inc., Multiple Listing Service of Spartanburg South Carolina, Inc., Anderson Association of Realtors®, Inc. and Upstate Multiple Listing Service of South Carolina, Inc. for use by their respective members and is not intended for any other purpose.
SESSION Array
(
    [G] => Array
        (
            [referrer] => www.eragreenville.com
            [cookiekey] => newuser
            [visitkey] => 4392028
        )

    [Breadcrumb] => D
    [TRAIL] => /AN/290-Chateau-St-Boiling-Springs-SC-home-for-sale|
    [MY_NAME] => 290-Chateau-St-Boiling-Springs-SC-home-for-sale
    [MY_URL] => AN/290-Chateau-St-Boiling-Springs-SC-home-for-sale
    [Sel] => Array
        (
            [PropTYPES] => 
            [ListingCNT] => 1
            [BEGIN] => 1
            [PREV] => 1
            [NEXT] => 1
            [INDEX] => 1
            [NAME] => 1
            [MLS] => AN20166434
            [CMD] => SELECT * From Listing WHERE mls='AN20166434'
        )

    [Srch] => Array
        (
            [URL] => 
            [OPTION] => mlsnumbers
            [MAP] => 
            [BROWSE] => 
            [DETAIL] => AN/290-Chateau-St-Boiling-Springs-SC-home-for-sale
            [WHERE] => mls='AN20166434'
            [PARMS] => &searchmls=AN20166434
        )

    [db] => Array
        (
            [SQL_CMD] => 
            [SQL_ERR] => 
            [30] => 
            [29] => 
            [28] => 
            [27] => 
            [26] => 
            [25] => 
            [24] => 
            [23] => 
            [22] => 
            [21] => 
            [20] => 
            [19] => 
            [18] => 
            [17] => 
            [16] => 
            [15] => 
            [14] => 
            [13] => 
            [12] => 
            [11] => 
            [10] => 
            [9] => 
            [8] => 19:44:03 select 13895 SELECT mlsid, pageurl From ActiveListing  ORDER BY listingprice DESC
            [7] => 19:44:03 select 1 SELECT * From Listing WHERE mls='AN20166434'
            [6] => 19:44:03 read 1 SELECT * From Listing WHERE mls='AN20166434'
            [5] => 19:44:03 read 0 SELECT * FROM GuestVisit WHERE phpsessid='' and visittime >= SYSDATE() - INTERVAL 8 HOUR
            [4] => 19:44:03 insert 1 k=4392028 Insert into GuestVisit (guestkey,phpsessid,visittime,hostbyaddr,referrer,useragent,userdomain) values ('0','20150831194403000000listing-detail',NOW(),'ec2-54-167-58-159.compute-1.amazonaws.com','www.eragreenville.com',' listing-detail','www.eragreenville.com') on duplicate key update guestkey='0'
            [3] => 19:44:03 update 0 Update Guest join (select guestkey, count(visittime) as xvisits, max(visittime) as xlastvisit from GuestVisit where guestkey=0) as x on x.guestkey=0 set visits=xvisits, lastvisit=xlastvisit where Guest.guestkey=0
            [2] => 19:44:03 insert 1 k=0 Insert into GuestProperty (visitkey,mls,listingprice,viewtime) values ('4392028','AN20166434','0',NOW()) on duplicate key update viewtime=NOW()
            [1] => 19:44:03 read 1 Select count(*) as propertycnt from GuestProperty where visitkey='4392028'
        )

    [admin] => Array
        (
            [menu_fname] => home
        )

    [agentlistingkey] => 0
    [request-info] => AN20166434|https://www.exitlead.com/mls/AN/img34/20166434_01.jpg|290 Chateau St|Boiling Springs, SC 29316
    [favorites] => Array
        (
        )

    [teaserlistings] => 5
    [propertycnt] => 1
)