UPDATE properties SET AC='', AllowAVMs='1', Amenities='No Amenities', Appliances='', ApplicationFee='', ApproxHtdSqFt='', ApproximateBoatslipFt='', ApproxLotSize='0.5012', Area='Bluffton/Off Plantation', Attic='', Availability='', AvailableDate='', BathsFull='', BathsHalf='', BathsTotal='', BedsTotal='', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Bluffton', CloseDate='2019-07-22', ClosePrice='261000.00', CommunityTourURL='', ConstructionFeatures='', ConstructionStatus='', ConsumerComments='0', CountyOrParish='Beaufort', CtyTaxRecordLivingArea='', ExteriorFeatures='', ExteriorType='', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='', FractionSize='', FractionUsage='', FurnishedYN='', GreenFeatures='None', GrossOperatingIncome='', Heat='', IDXOptInYN='1', InteriorFeatures='', Land='', LeaseNetItems='', LeaseType='', LegalAddress='PINE ISLAND', LegalNumber='14', ListOfficeName='Premier Island Properties', ListPrice='300000.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='', Matrix_Unique_ID='10480906', MatrixModifiedDT='2019-08-07T17:00:16.060', MLS='Hilton Head Island', MLSNumber='360126', ModelNameList='', MonthAvailable='', NetOperatingIncome='', NumAcres='1 to 3 Acres', OpenHouseFlags='', Parking='', PetDeposit='', Pets='', PhotoCount='20', PhotoModificationTimestamp='2017-04-04T13:12:43.687', POAFee='No POA fee reported', Pool='', PostalCode='29910', PostalCodePlus4='', PropertyFrontFaces='', PropertySubType='', PropertyType='Land/Lots', PropStatus='', PublicRemarks='This extraordinary property is located in the private community of Pine Island in Bluffton. Close to All Joy Landing and Old Town Bluffton, lots have been combined for over an acre of gorgeous marsh frontage and a small private beach. At high tide, you can kayak or paddle board from your own yard. Sea walls have been installed. Tax ID for 2nd Lot: R600-048-000-0068-0000.', QuarterAvailable='', RegimeFeePerOwner='', Restrictions='Community Covs and Restricts Apply,Motorcycles Allowed,No Commercial', Roof='', Rooms='', Row='', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='', StateOrProvince='South Carolina', Status='Sold', StreetDirPrefix='', StreetDirSuffix='', StreetName='Driftwood', StreetNumber='15', StreetNumberNumeric='15', StreetSuffix='DRIVE', Style='', SubArea='HH Bridge to Burnt Church Rd', TermLength='', TotalAcres='', Treatment='', Type='Double Lot', TypeofSpace='', UnbrandedVirtualTourURL='', UnitNumber='', UnitType='', View='Marsh', Water='Public Water Available', WeekAvailable='', Windows='', YearBuilt='', Zoning='' WHERE MLSNumber='360126';

UPDATE properties SET AC='Central', AllowAVMs='0', Amenities='Business Center,Clubhouse,Community Pool,Tennis,Fitness Facility,Sec Gate/Guard', Appliances='Dishwasher,Disposal,Dryer,Microwave,Oven Self-Cleaning,Range,Refrigerator,Washer', ApplicationFee='', ApproxHtdSqFt='960', ApproximateBoatslipFt='', ApproxLotSize='', Area='HH/Off Plantation', Attic='Attic - Crawl Space', Availability='', AvailableDate='', BathsFull='1', BathsHalf='0', BathsTotal='1.00', BedsTotal='1', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Hilton Head Island', CloseDate='2017-10-19', ClosePrice='156500.00', CommunityTourURL='', ConstructionFeatures='', ConstructionStatus='Not Applicable', ConsumerComments='0', CountyOrParish='Beaufort', CtyTaxRecordLivingArea='936', ExteriorFeatures='Balcony,Screened Porch,Screens', ExteriorType='Hard Coat Stucco,Wood/Stucco', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='Carpet,Tile', FractionSize='', FractionUsage='', FurnishedYN='0', GreenFeatures='Unknown', GrossOperatingIncome='', Heat='Central Heat,Electric Heat,Single Zone Heat', IDXOptInYN='1', InteriorFeatures='Cable TV,Ceiling Fan(s),Window Treatments,Fire Sprinklers,Smoke Alarm,Smooth Ceilings', Land='', LeaseNetItems='', LeaseType='', LegalAddress='THE PRESERVE AT INDIGO RUN', LegalNumber='3311', ListOfficeName='Premier Island Properties', ListPrice='171000.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='Unit Level', Matrix_Unique_ID='10584181', MatrixModifiedDT='2017-12-04T09:12:02.300', MLS='Hilton Head Island', MLSNumber='365420', ModelNameList='Azalea', MonthAvailable='', NetOperatingIncome='', NumAcres='', OpenHouseFlags='', Parking='Garage - 1 Car,Garage - 2 Car', PetDeposit='', Pets='Dogs Weight Restricted,Leash Law', PhotoCount='30', PhotoModificationTimestamp='2017-08-03T16:26:51.233', POAFee='No POA fee reported', Pool='Community,Unheated', PostalCode='29926', PostalCodePlus4='', PropertyFrontFaces='South', PropertySubType='', PropertyType='Villas/Condos', PropStatus='', PublicRemarks='The Preserve’s entry-level single bedroom villa. The Preserve offers unique quality-of-life attributes: winding roads, old-growth trees, on-site management, high capital reserves combined with lowest (per asset value) regime fees. Perfect for investors as well as primary/vacation homeowners. Located on the quieter north end just a bike ride to nearly everything you need…Grocery, restaurants, hospital, churches, WallMart, all literally across the street. Investors-excellent tenant in place till next April', QuarterAvailable='', RegimeFeePerOwner='226.11', Restrictions='Community Covs and Restricts Apply,No Commercial,No Motorcycles,Pet Weight Limit', Roof='Asphalt', Rooms='Dining Area,Kitchen,Laun/Util Rm,Living Room,Screen Pat/Por', Row='', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='960', StateOrProvince='South Carolina', Status='Sold', StreetDirPrefix='', StreetDirSuffix='', StreetName='Indigo Run', StreetNumber='4', StreetNumberNumeric='4', StreetSuffix='DRIVE', Style='', SubArea='Wm Hilton Pkwy', TermLength='Long Term', TotalAcres='', Treatment='', Type='Flat', TypeofSpace='', UnbrandedVirtualTourURL='', UnitNumber='3311', UnitType='', View='Landscape', Water='City PSD', WeekAvailable='', Windows='Bay', YearBuilt='2004', Zoning='' WHERE MLSNumber='365420';

UPDATE properties SET AC='Central,Electric,Heat Pump', AllowAVMs='0', Amenities='Business Center,Clubhouse,Community Pool,Tennis,Fitness Facility,Sec Gate/Guard', Appliances='Dishwasher,Disposal,Dryer,Freezer,Ice Machine,Microwave,Oven Self-Cleaning,Refrigerator', ApplicationFee='', ApproxHtdSqFt='1813', ApproximateBoatslipFt='', ApproxLotSize='', Area='HH/Off Plantation', Attic='Attic - Crawl Space', Availability='', AvailableDate='', BathsFull='2', BathsHalf='0', BathsTotal='2.00', BedsTotal='3', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Hilton Head Island', CloseDate='2017-11-03', ClosePrice='311000.00', CommunityTourURL='', ConstructionFeatures='', ConstructionStatus='Not Applicable', ConsumerComments='0', CountyOrParish='Beaufort', CtyTaxRecordLivingArea='1813', ExteriorFeatures='Screened Porch', ExteriorType='Hard Coat Stucco,Wood/Stucco', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='Carpet,Tile,Wood', FractionSize='', FractionUsage='', FurnishedYN='0', GreenFeatures='Unknown', GrossOperatingIncome='', Heat='Central Heat,Electric Heat,Heat Pump', IDXOptInYN='1', InteriorFeatures='Book Shelves,Cable TV,Cathedral Ceilings,Ceiling Fan(s),Fire Sprinklers,Fireplace,Hot Tub/Spa', Land='', LeaseNetItems='', LeaseType='', LegalAddress='THE PRESERVE AT INDIGO RUN', LegalNumber='2823', ListOfficeName='Premier Island Properties', ListPrice='326500.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='Unit Level', Matrix_Unique_ID='10597379', MatrixModifiedDT='2017-11-04T09:13:39.910', MLS='Hilton Head Island', MLSNumber='365841', ModelNameList='Cypress', MonthAvailable='', NetOperatingIncome='', NumAcres='', OpenHouseFlags='', Parking='Garage - 1 Car,Garage - 2 Car', PetDeposit='', Pets='Dogs Weight Restricted,Leash Law', PhotoCount='36', PhotoModificationTimestamp='2017-09-26T11:00:19.760', POAFee='No POA fee reported', Pool='Community,Unheated', PostalCode='29926', PostalCodePlus4='', PropertyFrontFaces='East', PropertySubType='', PropertyType='Villas/Condos', PropStatus='', PublicRemarks='Incredible designer upgrades - great location. A kitchen to die for, center island contains KItchen Aid refrigerator and freezer with Decor appliances. Marble, granite, stainless, designer interior doors and newer HVAC. Full refrigerator/Freezer in the utility room that has plenty of space because the water heater has been moved to the over-size 2-car garage. All this contained in the Preserve’s largest model offering tons of windows, a step-up living room with wood burning fireplace (yes, it can get cold here). The balcony off the kitchen and master bath overlooks the serene nature walk.', QuarterAvailable='', RegimeFeePerOwner='437.97', Restrictions='Community Covs and Restricts Apply,No Commercial,No Motorcycles,Pet Weight Limit', Roof='Asphalt', Rooms='Dining Area,Eat-In Kitchen,Foyer Entrance,Library/Office,Kitchen,Laun/Util Rm,Living Room,Screen Pat/Por', Row='', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='1813', StateOrProvince='South Carolina', Status='Sold', StreetDirPrefix='', StreetDirSuffix='', StreetName='Indigo Run', StreetNumber='4', StreetNumberNumeric='4', StreetSuffix='DRIVE', Style='', SubArea='Wm Hilton Pkwy', TermLength='', TotalAcres='', Treatment='', Type='Flat', TypeofSpace='', UnbrandedVirtualTourURL='', UnitNumber='2823', UnitType='', View='Landscape,Wooded', Water='City PSD', WeekAvailable='', Windows='Unknown', YearBuilt='2004', Zoning='' WHERE MLSNumber='365841';

UPDATE properties SET AC='Central,Electric', AllowAVMs='0', Amenities='Business Center,Clubhouse,Community Pool,Tennis,Fitness Facility,Sec Gate/Guard', Appliances='Dishwasher,Disposal,Dryer,Microwave,Oven Self-Cleaning,Refrigerator', ApplicationFee='', ApproxHtdSqFt='1683', ApproximateBoatslipFt='', ApproxLotSize='', Area='HH/Off Plantation', Attic='No Attic', Availability='', AvailableDate='', BathsFull='2', BathsHalf='0', BathsTotal='2.00', BedsTotal='3', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Hilton Head Island', CloseDate='2018-03-01', ClosePrice='290000.00', CommunityTourURL='', ConstructionFeatures='', ConstructionStatus='Not Applicable', ConsumerComments='0', CountyOrParish='Beaufort', CtyTaxRecordLivingArea='1683', ExteriorFeatures='Balcony,Enclosed Porch,End Unit', ExteriorType='Hard Coat Stucco', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='Carpet', FractionSize='', FractionUsage='', FurnishedYN='0', GreenFeatures='Unknown', GrossOperatingIncome='', Heat='Central Heat,Electric Heat', IDXOptInYN='1', InteriorFeatures='Book Shelves,Cable TV,Ceiling Fan(s),Fire Sprinklers', Land='', LeaseNetItems='', LeaseType='', LegalAddress='THE PRESERVE AT INDIGO RUN', LegalNumber='3822', ListOfficeName='Premier Island Properties', ListPrice='319800.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='Unit Level', Matrix_Unique_ID='10685419', MatrixModifiedDT='2018-03-08T12:16:00.200', MLS='Hilton Head Island', MLSNumber='370541', ModelNameList='Camellia', MonthAvailable='', NetOperatingIncome='', NumAcres='', OpenHouseFlags='', Parking='Garage - 1 Car,Garage - 2 Car', PetDeposit='', Pets='Dogs Weight Restricted,Leash Law', PhotoCount='31', PhotoModificationTimestamp='2017-10-05T10:37:17.553', POAFee='No POA fee reported', Pool='Community,Unheated', PostalCode='29926', PostalCodePlus4='', PropertyFrontFaces='East', PropertySubType='', PropertyType='Villas/Condos', PropStatus='', PublicRemarks='A rare GROUND FLOOR 3 bed, 2 bath villa w/2-car attached garage. This well maintained 2nd home (never rented) is in move-in condition. So many upgrades including a new Air Conditioner…the upgrade that counts ($6,000), new washer/dryer, stainless appliances, top-of-the-line 80 gal Marathon WH and on, and on, and on…Serene views of the Preserve’s surrounding forest from a screened-in porch with access from the large EIK and Mstr Bed. No Hilton Head villa community at this price range offers more - old growth trees, winding roads, beautiful amenities, low regime fee that includes insurance.', QuarterAvailable='', RegimeFeePerOwner='406.57', Restrictions='Community Covs and Restricts Apply,No Commercial,No Motorcycles,Pet Weight Limit', Roof='Asphalt', Rooms='Dining Area,Eat-In Kitchen,Kitchen,Laun/Util Rm,Living Room,Pantry,Screen Pat/Por', Row='', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='1683', StateOrProvince='South Carolina', Status='Sold', StreetDirPrefix='', StreetDirSuffix='', StreetName='Indigo Run', StreetNumber='4', StreetNumberNumeric='4', StreetSuffix='DRIVE', Style='', SubArea='Wm Hilton Pkwy', TermLength='', TotalAcres='', Treatment='', Type='Flat', TypeofSpace='', UnbrandedVirtualTourURL='', UnitNumber='3822', UnitType='', View='Wooded', Water='City PSD', WeekAvailable='', Windows='Unknown', YearBuilt='2004', Zoning='' WHERE MLSNumber='370541';

UPDATE properties SET AC='Central,Electric', AllowAVMs='0', Amenities='Business Center,Clubhouse,Community Pool,Tennis,Fitness Facility,Sec Gate/Guard', Appliances='Dishwasher,Disposal,Microwave,Oven Self-Cleaning,Range,Refrigerator,Washer', ApplicationFee='', ApproxHtdSqFt='1513', ApproximateBoatslipFt='', ApproxLotSize='', Area='HH/Off Plantation', Attic='No Attic', Availability='', AvailableDate='', BathsFull='2', BathsHalf='0', BathsTotal='2.00', BedsTotal='2', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Hilton Head Island', CloseDate='2017-11-22', ClosePrice='273000.00', CommunityTourURL='', ConstructionFeatures='', ConstructionStatus='Not Applicable', ConsumerComments='0', CountyOrParish='Beaufort', CtyTaxRecordLivingArea='1513', ExteriorFeatures='Balcony', ExteriorType='Hard Coat Stucco', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='Carpet', FractionSize='', FractionUsage='', FurnishedYN='0', GreenFeatures='Unknown', GrossOperatingIncome='', Heat='Central Heat,Electric Heat', IDXOptInYN='1', InteriorFeatures='Cable TV,Ceiling Fan(s),Fire Sprinklers,Smooth Ceilings', Land='', LeaseNetItems='', LeaseType='', LegalAddress='THE PRESERVE AT INDIGO RUN', LegalNumber='1421', ListOfficeName='Premier Island Properties', ListPrice='281000.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='Unit Level', Matrix_Unique_ID='10687834', MatrixModifiedDT='2017-11-24T17:40:39.010', MLS='Hilton Head Island', MLSNumber='370615', ModelNameList='Palmetto', MonthAvailable='', NetOperatingIncome='', NumAcres='', OpenHouseFlags='', Parking='Garage - 1 Car,Garage - 2 Car', PetDeposit='', Pets='Dogs Weight Restricted,Leash Law', PhotoCount='32', PhotoModificationTimestamp='2017-10-08T11:44:02.020', POAFee='No POA fee reported', Pool='Community,Unheated', PostalCode='29926', PostalCodePlus4='', PropertyFrontFaces='Unknown', PropertySubType='', PropertyType='Villas/Condos', PropStatus='', PublicRemarks='Excellent GROUND floor 2/2 with a 2-car garage with ample storage AND located on the nature walk in the middle of the Preserve. Many refurbishment including the one that really makes a difference…a new $5,800 HVAC. New carpet, newer water heater, new paint, designer track lights. Located in the ‘quiet’ north end of Hilton Head, quite simply, there is no community on the Island in this price range that can beat the quality-of-life the Preserve offers. Winding roads, old-growth trees and real sense of ‘community’. Everything you need is literally a walk or bike ride away.', QuarterAvailable='', RegimeFeePerOwner='365.55', Restrictions='Community Covs and Restricts Apply,No Commercial,No Motorcycles,Pet Weight Limit', Roof='Asphalt', Rooms='Dining Area,Eat-In Kitchen,Kitchen,Laun/Util Rm,Living Room', Row='', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='1513', StateOrProvince='South Carolina', Status='Sold', StreetDirPrefix='', StreetDirSuffix='', StreetName='Indigo Run', StreetNumber='4', StreetNumberNumeric='4', StreetSuffix='DRIVE', Style='', SubArea='Wm Hilton Pkwy', TermLength='', TotalAcres='', Treatment='', Type='Flat', TypeofSpace='', UnbrandedVirtualTourURL='', UnitNumber='1421', UnitType='', View='Landscape', Water='City PSD', WeekAvailable='', Windows='Unknown', YearBuilt='2004', Zoning='' WHERE MLSNumber='370615';

UPDATE properties SET AC='Central,Electric', AllowAVMs='0', Amenities='Business Center,Clubhouse,Community Pool,Tennis,Fitness Facility,Sec Gate/Guard', Appliances='Dishwasher,Disposal,Dryer,Microwave,Oven Self-Cleaning,Range,Refrigerator', ApplicationFee='', ApproxHtdSqFt='1281', ApproximateBoatslipFt='', ApproxLotSize='', Area='HH/Off Plantation', Attic='Attic - Crawl Space', Availability='', AvailableDate='', BathsFull='2', BathsHalf='0', BathsTotal='2.00', BedsTotal='2', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Hilton Head Island', CloseDate='2017-12-14', ClosePrice='235000.00', CommunityTourURL='', ConstructionFeatures='', ConstructionStatus='Not Applicable', ConsumerComments='0', CountyOrParish='Beaufort', CtyTaxRecordLivingArea='1281', ExteriorFeatures='Balcony', ExteriorType='Hard Coat Stucco', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='Carpet', FractionSize='', FractionUsage='', FurnishedYN='0', GreenFeatures='Unknown', GrossOperatingIncome='', Heat='Central Heat,Electric Heat', IDXOptInYN='1', InteriorFeatures='Book Shelves,Built-Ins,Cable TV,Ceiling Fan(s),Fire Sprinklers', Land='', LeaseNetItems='', LeaseType='', LegalAddress='THE PRESERVE AT INDIGO RUN', LegalNumber='1311', ListOfficeName='Premier Island Properties', ListPrice='256000.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='Unit Level', Matrix_Unique_ID='10690111', MatrixModifiedDT='2017-12-14T15:03:35.563', MLS='Hilton Head Island', MLSNumber='370677', ModelNameList='Hawthorne', MonthAvailable='', NetOperatingIncome='', NumAcres='', OpenHouseFlags='', Parking='Garage - 1 Car,Garage - 2 Car', PetDeposit='', Pets='Dogs Weight Restricted,Leash Law', PhotoCount='35', PhotoModificationTimestamp='2017-10-10T14:48:32.653', POAFee='No POA fee reported', Pool='Community,Unheated', PostalCode='29926', PostalCodePlus4='', PropertyFrontFaces='Unknown', PropertySubType='', PropertyType='Villas/Condos', PropStatus='', PublicRemarks='Head thru our gated entry past our famous fountain…drive under the Heritage Oaks overhanging the street to your Hawthorne model 2/2 w/1-car garage attached. This beautifully maintained villa has the perfect layout. The bedrooms are on opposite sides of the living room offering maximum privacy. The second bath has two entries for guests and bedroom privacy. Many upgrades and dark wood builtins in the closets, maximizing storage space. New washer/dryer, granite…well, you’ll have to take a look yourself. The Preserve is on the \'quieter\' north end with everything you could need...steps away.', QuarterAvailable='', RegimeFeePerOwner='309.45', Restrictions='Community Covs and Restricts Apply,No Commercial,No Motorcycles,Pet Weight Limit', Roof='Asphalt', Rooms='Dining Area,Eat-In Kitchen,Kitchen,Laun/Util Rm,Living Room', Row='', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='1281', StateOrProvince='South Carolina', Status='Sold', StreetDirPrefix='', StreetDirSuffix='', StreetName='Indigo Run', StreetNumber='4', StreetNumberNumeric='4', StreetSuffix='DRIVE', Style='', SubArea='Wm Hilton Pkwy', TermLength='', TotalAcres='', Treatment='', Type='Flat', TypeofSpace='', UnbrandedVirtualTourURL='', UnitNumber='1311', UnitType='', View='Landscape', Water='City PSD', WeekAvailable='', Windows='Unknown', YearBuilt='2004', Zoning='' WHERE MLSNumber='370677';

UPDATE properties SET AC='Central,Electric,Heat Pump', AllowAVMs='0', Amenities='Clubhouse,Community Pool,Tennis,Fitness Facility,Golf Privileges,Leisure Trails,Sec Gate/Guard', Appliances='Dishwasher,Disposal,Dryer,Microwave,Oven,Oven Self-Cleaning,Range,Range - Gas,Refrigerator,Washer', ApplicationFee='', ApproxHtdSqFt='3642', ApproximateBoatslipFt='', ApproxLotSize='0.56', Area='Indigo Run', Attic='Attic - Floored,Attic - Insulated,Attic - Walk in', Availability='', AvailableDate='', BathsFull='4', BathsHalf='1', BathsTotal='5.00', BedsTotal='4', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Hilton Head Island', CloseDate='2019-02-28', ClosePrice='750000.00', CommunityTourURL='', ConstructionFeatures='', ConstructionStatus='Not Applicable', ConsumerComments='0', CountyOrParish='Beaufort', CtyTaxRecordLivingArea='3642', ExteriorFeatures='Back Porch,Balcony,Irri System,Patio,Paved Drive,Propane Tank - Above Ground,Propane Tank - Leased,Screens', ExteriorType='Block/Stucco,Hard Coat Stucco', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='Carpet,Wood', FractionSize='', FractionUsage='', FurnishedYN='0', GreenFeatures='None', GrossOperatingIncome='', Heat='Central Heat,Electric Heat,Multi Zone Heat', IDXOptInYN='1', InteriorFeatures='Book Shelves,Built-Ins,Ceiling Fan(s),Fireplace,Jetted Tub,Separate Shower,Smooth Ceilings', Land='', LeaseNetItems='', LeaseType='', LegalAddress='INDIGO P', LegalNumber='20', ListOfficeName='Premier Island Properties', ListPrice='769900.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='1st Floor', Matrix_Unique_ID='10716834', MatrixModifiedDT='2019-03-01T15:08:57.477', MLS='Hilton Head Island', MLSNumber='372111', ModelNameList='', MonthAvailable='', NetOperatingIncome='', NumAcres='1/2 to 1 Acre', OpenHouseFlags='', Parking='Golf Cart Bay Attached,Garage - 2 Car', PetDeposit='', Pets='', PhotoCount='29', PhotoModificationTimestamp='2017-11-10T14:36:22.280', POAFee='Ind Run - Brd Pt I $3072.34', Pool='Community', PostalCode='29928', PostalCodePlus4='', PropertyFrontFaces='NorthWest', PropertySubType='', PropertyType='Residential-Single Fam', PropStatus='', PublicRemarks='Immaculately maintained, open floorplan Custom built home on quiet cul de sac. Magnificent oaks on the 13th Fairway of the Golden Bear Golf Course. Golf and lagoon views from every room, this home is perfect for entertaining, and features a great room with beautiful light, high coffered ceilings, wormy chestnut hardwood floors, fireplace, 4 bay windows, home office, chef\'s kitchen with island featuring granite, top of the line appliances, dining area in kitchen plus formal dining room, outdoor patio overlooking the golf course, 4 bedrooms , 4 1/2 baths including a spacious bonus room over the 2 car plus golf cart garage. 2 new HVAC systems.', QuarterAvailable='', RegimeFeePerOwner='', Restrictions='Community Covs and Restricts Apply,No Motorcycles', Roof='Asphalt', Rooms='Bonus Room,Dining Area,Dining Room,Foyer Entrance,Great Room,Library/Office,Laun/Util Rm,Living Room,Pantry,Storage Room', Row='Over 12', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='3642', StateOrProvince='South Carolina', Status='Sold', StreetDirPrefix='', StreetDirSuffix='', StreetName='Primrose', StreetNumber='20', StreetNumberNumeric='20', StreetSuffix='LANE', Style='Two Story', SubArea='Golden Bear', TermLength='', TotalAcres='', Treatment='', Type='Full Size', TypeofSpace='', UnbrandedVirtualTourURL='', UnitNumber='', UnitType='', View='Golf,Lagoon', Water='City PSD', WeekAvailable='', Windows='Tinted', YearBuilt='2006', Zoning='' WHERE MLSNumber='372111';

UPDATE properties SET AC='Central', AllowAVMs='0', Amenities='Clubhouse,Community Pool,Tennis,Elevator,Golf Privileges,Leisure Trails,Marina,Sec Gate/Guard', Appliances='Dishwasher,Microwave,Oven,Refrigerator', ApplicationFee='', ApproxHtdSqFt='3214', ApproximateBoatslipFt='', ApproxLotSize='0.1053', Area='Wexford', Attic='Attic - Walk in', Availability='', AvailableDate='', BathsFull='3', BathsHalf='2', BathsTotal='5.00', BedsTotal='3', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Hilton Head Island', CloseDate='2018-10-22', ClosePrice='599000.00', CommunityTourURL='', ConstructionFeatures='', ConstructionStatus='Not Applicable', ConsumerComments='0', CountyOrParish='Beaufort', CtyTaxRecordLivingArea='3214', ExteriorFeatures='Back Porch,Balcony,Courtyard,Deck,End Unit,Front Porch,Gutters,Irri System,Just Painted,Paved Drive,Propane Tank - Above Ground', ExteriorType='Block/Stucco,Hard Coat Stucco', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='Carpet,Wood', FractionSize='', FractionUsage='', FurnishedYN='0', GreenFeatures='None', GrossOperatingIncome='', Heat='Central Heat', IDXOptInYN='1', InteriorFeatures='Book Shelves,Built-Ins,Cable TV,Ceiling Fan(s),Elevator,Fire Alarm,Fireplace,Jetted Tub,Just Painted In,Many Closets,Security Sys,Tray Ceiling', Land='Corner Lot', LeaseNetItems='', LeaseType='', LegalAddress='WEXFORD L', LegalNumber='29', ListOfficeName='Premier Island Properties', ListPrice='599000.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='2nd Floor', Matrix_Unique_ID='10773501', MatrixModifiedDT='2018-10-22T10:15:33.330', MLS='Hilton Head Island', MLSNumber='374497', ModelNameList='', MonthAvailable='', NetOperatingIncome='', NumAcres='Less than 1/4 Acres', OpenHouseFlags='', Parking='Golf Cart Bay Attached,Garage - 2 Car', PetDeposit='', Pets='', PhotoCount='25', PhotoModificationTimestamp='2018-01-15T14:45:45.420', POAFee='No POA Fee reported.', Pool='Community', PostalCode='29928', PostalCodePlus4='', PropertyFrontFaces='East', PropertySubType='', PropertyType='Residential-Single Fam', PropStatus='', PublicRemarks='3 bedroom, 4 full & 2 half bths exquisitely detailed townhome. Exterior details include stucco, excellent gated wrought ironworks. Elevator all 4 floors, spiraling wood & iron staircase, kitchen w gas range, Fireplace. MBR w full walk in closet, jacuzzi tub & tray ceilings. Concrete balustrade systems on all porches overlooks the marsh, water & green.Original construction costs over $1.2 million. Great investment property! This unique town home has a N/N/N lease in place for 12+ months.', QuarterAvailable='', RegimeFeePerOwner='', Restrictions='Community Covs and Restricts Apply', Roof='Asphalt', Rooms='Dining Area,Foyer Entrance,Great Room,Library/Office,Media Room,Pantry,Storage Room', Row='Over 12', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='3214', StateOrProvince='South Carolina', Status='Sold', StreetDirPrefix='', StreetDirSuffix='', StreetName='Wexford On The', StreetNumber='45', StreetNumberNumeric='45', StreetSuffix='GREEN', Style='Townhouse,4 Story +', SubArea='Wexford', TermLength='', TotalAcres='', Treatment='', Type='Townhouse/Multi-level', TypeofSpace='', UnbrandedVirtualTourURL='', UnitNumber='', UnitType='', View='Golf,Marsh', Water='Community', WeekAvailable='', Windows='Insulated', YearBuilt='2007', Zoning='' WHERE MLSNumber='374497';

UPDATE properties SET AC='Central', AllowAVMs='0', Amenities='Business Center,Clubhouse,Community Pool,Tennis,Fitness Facility,Sec Gate/Guard', Appliances='Dishwasher,Disposal,Dryer,Freezer,Microwave,Oven Self-Cleaning,Refrigerator,Washer', ApplicationFee='', ApproxHtdSqFt='1513', ApproximateBoatslipFt='', ApproxLotSize='', Area='HH/Off Plantation', Attic='No Attic', Availability='', AvailableDate='', BathsFull='2', BathsHalf='0', BathsTotal='2.00', BedsTotal='2', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Hilton Head Island', CloseDate='2018-02-26', ClosePrice='270000.00', CommunityTourURL='', ConstructionFeatures='', ConstructionStatus='Not Applicable', ConsumerComments='0', CountyOrParish='Beaufort', CtyTaxRecordLivingArea='1513', ExteriorFeatures='Patio', ExteriorType='Hard Coat Stucco', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='Carpet', FractionSize='', FractionUsage='', FurnishedYN='0', GreenFeatures='Unknown', GrossOperatingIncome='', Heat='Electric Heat', IDXOptInYN='1', InteriorFeatures='Book Shelves,Cable TV,Ceiling Fan(s),Fire Alarm,Fire Sprinklers,Smooth Ceilings', Land='', LeaseNetItems='', LeaseType='', LegalAddress='THE PRESERVE AT INDIGO RUN', LegalNumber='322', ListOfficeName='Premier Island Properties', ListPrice='279000.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='Unit Level', Matrix_Unique_ID='10779212', MatrixModifiedDT='2018-03-12T08:09:48.227', MLS='Hilton Head Island', MLSNumber='374644', ModelNameList='Palmetto', MonthAvailable='', NetOperatingIncome='', NumAcres='', OpenHouseFlags='', Parking='Garage - 1 Car,Garage - 2 Car', PetDeposit='', Pets='Dogs Weight Restricted,Leash Law', PhotoCount='24', PhotoModificationTimestamp='2018-01-19T16:54:02.727', POAFee='No POA fee reported', Pool='Community,Unheated', PostalCode='29926', PostalCodePlus4='', PropertyFrontFaces='South', PropertySubType='', PropertyType='Villas/Condos', PropStatus='', PublicRemarks='THIS is the only ground floor available indeed, it’s only 1 of 2 villas for sale in the entire community of 252 villas…tells you something. Ground floor models are difficult to find as only 2 of 6 models are on the ground floor. Nobody wants to leave the Preserve! No steps, 2 bed, 2 bath w/ attached 2-car garage. Beautifully kept with the upgrades that really count, Air Conditioner just about new and a water heater only 1/ 1/2 years old. Oh, AND, a new range, new dishwasher, new microwave and Fridge. Winding roads, healthy financials, low (insurance included) regime fees, heritage oaks..', QuarterAvailable='', RegimeFeePerOwner='365.55', Restrictions='Community Covs and Restricts Apply,No Commercial,No Motorcycles,Pet Weight Limit', Roof='Asphalt', Rooms='Dining Area,Eat-In Kitchen,Garage,Kitchen,Living Room,Pantry', Row='', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='1513', StateOrProvince='South Carolina', Status='Sold', StreetDirPrefix='', StreetDirSuffix='', StreetName='Indigo Run', StreetNumber='4', StreetNumberNumeric='4', StreetSuffix='DRIVE', Style='', SubArea='Wm Hilton Pkwy', TermLength='', TotalAcres='', Treatment='', Type='Flat', TypeofSpace='', UnbrandedVirtualTourURL='', UnitNumber='322', UnitType='', View='Landscape,Wooded', Water='City PSD', WeekAvailable='', Windows='Unknown', YearBuilt='2004', Zoning='' WHERE MLSNumber='374644';

UPDATE properties SET AC='Central,Electric', AllowAVMs='0', Amenities='Business Center,Clubhouse,Community Pool,Tennis,Fitness Facility,Sec Gate/Guard', Appliances='Dishwasher,Disposal,Microwave,Oven Self-Cleaning,Refrigerator,Washer', ApplicationFee='', ApproxHtdSqFt='1513', ApproximateBoatslipFt='', ApproxLotSize='', Area='HH/Off Plantation', Attic='No Attic', Availability='', AvailableDate='', BathsFull='2', BathsHalf='0', BathsTotal='2.00', BedsTotal='2', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Hilton Head Island', CloseDate='2018-02-26', ClosePrice='287500.00', CommunityTourURL='', ConstructionFeatures='', ConstructionStatus='Not Applicable', ConsumerComments='0', CountyOrParish='Beaufort', CtyTaxRecordLivingArea='1513', ExteriorFeatures='Screened Porch', ExteriorType='Hard Coat Stucco', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='Carpet,Tile', FractionSize='', FractionUsage='', FurnishedYN='0', GreenFeatures='Unknown', GrossOperatingIncome='', Heat='Central Heat,Heat Pump', IDXOptInYN='1', InteriorFeatures='Cable TV,Ceiling Fan(s),Fire Sprinklers,Smooth Ceilings', Land='', LeaseNetItems='', LeaseType='', LegalAddress='THE PRESERVE AT INDIGO RUN', LegalNumber='3321', ListOfficeName='Premier Island Properties', ListPrice='299000.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='Unit Level', Matrix_Unique_ID='10780573', MatrixModifiedDT='2018-03-19T08:37:33.053', MLS='Hilton Head Island', MLSNumber='374694', ModelNameList='Palmetto', MonthAvailable='', NetOperatingIncome='', NumAcres='', OpenHouseFlags='', Parking='Garage - 1 Car,Garage - 2 Car', PetDeposit='', Pets='Dogs Weight Restricted,Leash Law', PhotoCount='23', PhotoModificationTimestamp='2018-01-22T14:08:09.650', POAFee='No POA fee reported', Pool='Community,Unheated', PostalCode='29926', PostalCodePlus4='', PropertyFrontFaces='South', PropertySubType='', PropertyType='Villas/Condos', PropStatus='', PublicRemarks='Sit on your screened-in porch or EIK table and look out at the Preserve’s bucolic inner woods. GROUND FLOOR and located in the back section. Only THREE villas for sale at the Preserve and only two are ground floor. Stainless appliances and, the upgrade that really counts, a newer HVAC. This is the very popular ‘Palmetto’ model with 2 single-car garages attached - 2 bed/2 bath. Located on the quiet north end of the Island literally seconds from anything you could want. Movies, restaurants, grocery, churches, hospital, Island-wide bike path, you name it.', QuarterAvailable='', RegimeFeePerOwner='365.55', Restrictions='Community Covs and Restricts Apply,No Commercial,No Motorcycles,Pet Weight Limit', Roof='Asphalt', Rooms='Dining Area,Garage,Kitchen,Laun/Util Rm,Living Room,Pantry,Screen Pat/Por', Row='', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='1513', StateOrProvince='South Carolina', Status='Sold', StreetDirPrefix='', StreetDirSuffix='', StreetName='Indigo Run', StreetNumber='4', StreetNumberNumeric='4', StreetSuffix='DRIVE', Style='', SubArea='Wm Hilton Pkwy', TermLength='', TotalAcres='', Treatment='', Type='Flat', TypeofSpace='', UnbrandedVirtualTourURL='', UnitNumber='3321', UnitType='', View='Landscape,Wooded', Water='City PSD', WeekAvailable='', Windows='Unknown', YearBuilt='2004', Zoning='' WHERE MLSNumber='374694';

UPDATE properties SET AC='Central,Electric,Heat Pump', AllowAVMs='0', Amenities='Business Center,Clubhouse,Community Pool,Tennis,Fitness Facility,Sec Gate/Guard', Appliances='Dishwasher,Disposal,Dryer,Microwave,Oven Self-Cleaning,Refrigerator,Washer', ApplicationFee='', ApproxHtdSqFt='960', ApproximateBoatslipFt='', ApproxLotSize='', Area='HH/Off Plantation', Attic='Attic - Crawl Space', Availability='', AvailableDate='', BathsFull='1', BathsHalf='0', BathsTotal='1.00', BedsTotal='1', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Hilton Head Island', CloseDate='2018-03-14', ClosePrice='184000.00', CommunityTourURL='', ConstructionFeatures='', ConstructionStatus='Not Applicable', ConsumerComments='0', CountyOrParish='Beaufort', CtyTaxRecordLivingArea='936', ExteriorFeatures='Balcony,Screened Porch', ExteriorType='Hard Coat Stucco', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='Carpet,Vinyl', FractionSize='', FractionUsage='', FurnishedYN='0', GreenFeatures='Unknown', GrossOperatingIncome='', Heat='Central Heat,Electric Heat', IDXOptInYN='1', InteriorFeatures='Cable TV,Ceiling Fan(s),Fire Sprinklers', Land='', LeaseNetItems='', LeaseType='', LegalAddress='THE PRESERVE AT INDIGO RUN', LegalNumber='3011', ListOfficeName='Premier Island Properties', ListPrice='194300.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='Unit Level', Matrix_Unique_ID='10810073', MatrixModifiedDT='2018-03-26T15:11:50.770', MLS='Hilton Head Island', MLSNumber='375317', ModelNameList='Azalea', MonthAvailable='', NetOperatingIncome='', NumAcres='', OpenHouseFlags='', Parking='Assigned Parking', PetDeposit='', Pets='Dogs Weight Restricted,Leash Law', PhotoCount='31', PhotoModificationTimestamp='2018-02-09T15:13:16.950', POAFee='No POA fee reported', Pool='Community,Unheated', PostalCode='29926', PostalCodePlus4='', PropertyFrontFaces='East', PropertySubType='', PropertyType='Villas/Condos', PropStatus='', PublicRemarks='The Preserve, a gated villa residence on the Island’s quiet north end, literally seconds from anything you could want: grocery, WallMart, Hospital, Movie, outstanding restaurants, Island-wide bike path…. Nestled amongst the old-growth trees, winding roads and amenities (pool, fitness, tennis) Is this recently refurbished roomy 1/bed-1 bath villa with tasteful upgrades throughout (new vinyl-plank floor, paint, plantation shutters, designer lights, screen balcony, stainless, granite and on and on. The only Azalea model available…actually only 1 of 3 villas available in the entire 252-villa community! Kind of says it all, nobody wants to leave!', QuarterAvailable='', RegimeFeePerOwner='226.11', Restrictions='Community Covs and Restricts Apply,No Commercial,No Motorcycles,Pet Weight Limit', Roof='Asphalt', Rooms='Dining Area,Kitchen,Laun/Util Rm,Living Room,Screen Pat/Por', Row='', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='960', StateOrProvince='South Carolina', Status='Sold', StreetDirPrefix='', StreetDirSuffix='', StreetName='Indigo Run', StreetNumber='4', StreetNumberNumeric='4', StreetSuffix='DRIVE', Style='', SubArea='Wm Hilton Pkwy', TermLength='', TotalAcres='', Treatment='', Type='Flat', TypeofSpace='', UnbrandedVirtualTourURL='', UnitNumber='3011', UnitType='', View='Landscape', Water='City PSD', WeekAvailable='', Windows='Unknown', YearBuilt='2004', Zoning='' WHERE MLSNumber='375317';

UPDATE properties SET AC='No A/C', AllowAVMs='0', Amenities='Boat Storage,Deep Water Access', Appliances='None', ApplicationFee='', ApproxHtdSqFt='3104', ApproximateBoatslipFt='', ApproxLotSize='1.23', Area='Bluffton/Off Plantation', Attic='No Attic', Availability='', AvailableDate='', BathsFull='2', BathsHalf='0', BathsTotal='2.00', BedsTotal='2', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Bluffton', CloseDate='2018-04-16', ClosePrice='721000.00', CommunityTourURL='', ConstructionFeatures='', ConstructionStatus='Not Applicable', ConsumerComments='0', CountyOrParish='Beaufort', CtyTaxRecordLivingArea='3760', ExteriorFeatures='Deck,Dock Private,Patio,Storage Shed', ExteriorType='Block/Stucco', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='Concrete,Tile,Wood', FractionSize='', FractionUsage='', FurnishedYN='0', GreenFeatures='None', GrossOperatingIncome='', Heat='No Heating', IDXOptInYN='1', InteriorFeatures='Book Shelves,Fireplace,Wet Bar', Land='Dirt Road', LeaseNetItems='', LeaseType='', LegalAddress='BUCK ISLAND', LegalNumber='86', ListOfficeName='Premier Island Properties', ListPrice='789000.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='1st Floor', Matrix_Unique_ID='10820322', MatrixModifiedDT='2018-05-10T08:21:48.063', MLS='Hilton Head Island', MLSNumber='375628', ModelNameList='', MonthAvailable='', NetOperatingIncome='', NumAcres='1 to 3 Acres', OpenHouseFlags='', Parking='Carport - Detached', PetDeposit='', Pets='', PhotoCount='32', PhotoModificationTimestamp='2018-02-21T15:44:29.357', POAFee='No POA fee reported', Pool='None', PostalCode='29910', PostalCodePlus4='', PropertyFrontFaces='North', PropertySubType='', PropertyType='Residential-Single Fam', PropStatus='', PublicRemarks='Be a part of a true Lowcountry lifestyle! This property offers a tremendous rebuild opportunity with over 678 feet of water and marsh views on a tidal creek. You have the best of the private and serene Bluffton river community.', QuarterAvailable='', RegimeFeePerOwner='', Restrictions='No Restrictions', Roof='Asphalt', Rooms='Bonus Room,Carolina Room,Den,Dining Area,Eat-In Kitchen,Family Room,Foyer Entrance,Kitchen,Laun/Util Rm,Pantry,Storage Room,Workshop', Row='', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='3104', StateOrProvince='South Carolina', Status='Sold', StreetDirPrefix='', StreetDirSuffix='', StreetName='Buck Point', StreetNumber='86', StreetNumberNumeric='86', StreetSuffix='ROAD', Style='One Story', SubArea='Hwy 46 –May River Side', TermLength='', TotalAcres='', Treatment='', Type='Full Size', TypeofSpace='', UnbrandedVirtualTourURL='', UnitNumber='', UnitType='', View='Deep Water,River', Water='Public Water Available,Septic Tank,Well Water', WeekAvailable='', Windows='Insulated', YearBuilt='1959', Zoning='' WHERE MLSNumber='375628';

UPDATE properties SET AC='Central,Heat Pump', AllowAVMs='1', Amenities='Clubhouse,Community Pool,Tennis,Sec Gate/Guard', Appliances='Dishwasher,Disposal,Dryer,Microwave,Range,Refrigerator,Washer', ApplicationFee='', ApproxHtdSqFt='757', ApproximateBoatslipFt='', ApproxLotSize='', Area='Folly Field', Attic='Unknown', Availability='', AvailableDate='', BathsFull='2', BathsHalf='0', BathsTotal='2.00', BedsTotal='2', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Hilton Head Island', CloseDate='2019-05-16', ClosePrice='147000.00', CommunityTourURL='', ConstructionFeatures='', ConstructionStatus='Not Applicable', ConsumerComments='0', CountyOrParish='Beaufort', CtyTaxRecordLivingArea='757', ExteriorFeatures='Balcony', ExteriorType='Wood Siding', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='Wood', FractionSize='', FractionUsage='', FurnishedYN='1', GreenFeatures='Unknown', GrossOperatingIncome='', Heat='Heat Pump', IDXOptInYN='1', InteriorFeatures='Cable TV,Smoke Alarm,Wet Bar', Land='', LeaseNetItems='', LeaseType='', LegalAddress='FIDDLERS COVE VILLAS', LegalNumber='5J', ListOfficeName='Premier Island Properties', ListPrice='155000.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='3rd Floor', Matrix_Unique_ID='10904251', MatrixModifiedDT='2019-05-18T12:37:52.683', MLS='Hilton Head Island', MLSNumber='379154', ModelNameList='', MonthAvailable='', NetOperatingIncome='', NumAcres='', OpenHouseFlags='', Parking='Unassigned Parking', PetDeposit='', Pets='None', PhotoCount='17', PhotoModificationTimestamp='2018-08-07T20:20:34.877', POAFee='No POA Fee', Pool='Community,Free Form', PostalCode='29928', PostalCodePlus4='', PropertyFrontFaces='NorthEast', PropertySubType='', PropertyType='Villas/Condos', PropStatus='', PublicRemarks='This unit looks great with many updates through out including new floors. Only a short walk to the beach. This complex has 10 clay har-tru tennis courts, two racquetball courts, two heated pools and club house with 24 hour security. Would make a great investment with vacation rentals or long term rental potential.', QuarterAvailable='', RegimeFeePerOwner='335.00', Restrictions='', Roof='Asphalt', Rooms='Dining Area,Kitchen,Living Room', Row='', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='757', StateOrProvince='South Carolina', Status='Sold', StreetDirPrefix='', StreetDirSuffix='', StreetName='Folly Field', StreetNumber='45', StreetNumberNumeric='45', StreetSuffix='ROAD', Style='', SubArea='Folly Field', TermLength='', TotalAcres='', Treatment='', Type='Flat', TypeofSpace='', UnbrandedVirtualTourURL='', UnitNumber='5J', UnitType='', View='Golf', Water='City PSD,Community,Electric', WeekAvailable='', Windows='Unknown', YearBuilt='1980', Zoning='' WHERE MLSNumber='379154';

UPDATE properties SET AC='Central', AllowAVMs='0', Amenities='', Appliances='Dishwasher,Disposal,Dryer,Freezer,Ice Machine,Microwave,Oven,Range,Refrigerator', ApplicationFee='', ApproxHtdSqFt='1550', ApproximateBoatslipFt='', ApproxLotSize='', Area='Sea Pines', Attic='No Attic', Availability='', AvailableDate='', BathsFull='2', BathsHalf='0', BathsTotal='2.00', BedsTotal='3', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Hilton Head Island', CloseDate='2019-02-27', ClosePrice='612000.00', CommunityTourURL='', ConstructionFeatures='', ConstructionStatus='Not Applicable', ConsumerComments='0', CountyOrParish='Beaufort', CtyTaxRecordLivingArea='1550', ExteriorFeatures='Balcony,End Unit,Handicap Access,Just Painted', ExteriorType='Concrete Block,Hard Coat Stucco,Steel/Glass', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='Vinyl', FractionSize='', FractionUsage='', FurnishedYN='1', GreenFeatures='None', GrossOperatingIncome='', Heat='Electric Heat', IDXOptInYN='1', InteriorFeatures='Cable TV,Ceiling Fan(s),Elevator,Fire Alarm,Many Closets,Separate Shower,Smoke Alarm,Smooth Ceilings,Ventilating Fan', Land='', LeaseNetItems='', LeaseType='', LegalAddress='MARINERS WAY VILLAS', LegalNumber='683', ListOfficeName='Premier Island Properties', ListPrice='649000.00', Loading='', Location='Sound Front', MaintenanceFee='', MasterBedroom='1st Floor', Matrix_Unique_ID='10949636', MatrixModifiedDT='2019-03-02T09:14:03.327', MLS='Hilton Head Island', MLSNumber='381183', ModelNameList='', MonthAvailable='', NetOperatingIncome='', NumAcres='', OpenHouseFlags='', Parking='', PetDeposit='', Pets='', PhotoCount='40', PhotoModificationTimestamp='2018-10-04T22:44:28.723', POAFee='Sea Pines I $1076', Pool='', PostalCode='29928', PostalCodePlus4='', PropertyFrontFaces='NorthWest', PropertySubType='', PropertyType='Villas/Condos', PropStatus='', PublicRemarks='Maintenance free living in the heart of it all! BRAND NEW FULLY FURNISHED PENTHOUSE with views of Calibogue Sound and Harbour Town Lighthouse! All new mechanicals, wiring , appliances, etc. Enjoy a rare find in the heart of Harbour Town, home of the Heritage Classic.\r\nPROJECTED ANNUAL GROSS RENTAL INCOME based on unit in same building is 90K making this villa a wonderful second home and/or investment opportunity! Units 680,681,682 and 683 are all available; combined offer from investors will be considered!\r\nADDITIONAL BONUS: Seller will pay all current assessments at time of closing!', QuarterAvailable='', RegimeFeePerOwner='365.61', Restrictions='', Roof='Unknown', Rooms='Dining Area,Great Room,Kitchen,Laun/Util Rm,Pantry', Row='', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='1550', StateOrProvince='South Carolina', Status='Sold', StreetDirPrefix='', StreetDirSuffix='', StreetName='Lighthouse', StreetNumber='147', StreetNumberNumeric='147', StreetSuffix='ROAD', Style='', SubArea='Harbour Town', TermLength='Short Term', TotalAcres='', Treatment='', Type='Penthouse', TypeofSpace='', UnbrandedVirtualTourURL='', UnitNumber='683', UnitType='', View='Harbor,Sound', Water='City PSD', WeekAvailable='', Windows='Unknown', YearBuilt='1977', Zoning='' WHERE MLSNumber='381183';

UPDATE properties SET AC='Central', AllowAVMs='0', Amenities='', Appliances='Dishwasher,Disposal,Dryer,Freezer,Ice Machine,Microwave,Oven,Refrigerator', ApplicationFee='', ApproxHtdSqFt='1024', ApproximateBoatslipFt='', ApproxLotSize='', Area='Sea Pines', Attic='No Attic', Availability='', AvailableDate='', BathsFull='2', BathsHalf='0', BathsTotal='2.00', BedsTotal='2', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Hilton Head Island', CloseDate='2019-01-25', ClosePrice='435000.00', CommunityTourURL='', ConstructionFeatures='', ConstructionStatus='Not Applicable', ConsumerComments='0', CountyOrParish='Beaufort', CtyTaxRecordLivingArea='1024', ExteriorFeatures='Balcony,End Unit', ExteriorType='Block/Stucco,Concrete Block,Masonry/Steel', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='Luxury Vinyl Plank (LVP)', FractionSize='', FractionUsage='', FurnishedYN='1', GreenFeatures='None', GrossOperatingIncome='', Heat='Electric Heat', IDXOptInYN='1', InteriorFeatures='Cable TV,Ceiling Fan(s),Elevator,Fire Alarm,Handicap Access,Just Painted In,Just Painted Out,Many Closets,Network Wiring,Separate Shower,Smooth Ceilings,Ventilating Fan', Land='', LeaseNetItems='', LeaseType='', LegalAddress='MARINERS WAY VILLAS', LegalNumber='682', ListOfficeName='Premier Island Properties', ListPrice='449000.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='1st Floor', Matrix_Unique_ID='10949638', MatrixModifiedDT='2019-01-26T09:23:37.393', MLS='Hilton Head Island', MLSNumber='381184', ModelNameList='', MonthAvailable='', NetOperatingIncome='', NumAcres='', OpenHouseFlags='', Parking='', PetDeposit='', Pets='', PhotoCount='41', PhotoModificationTimestamp='2018-10-04T22:42:25.567', POAFee='Sea Pines I $1076', Pool='', PostalCode='29928', PostalCodePlus4='', PropertyFrontFaces='NorthWest', PropertySubType='', PropertyType='Villas/Condos', PropStatus='', PublicRemarks='Maintenance free living in PARADISE! NEWLY RENOVATED completely furnished 2 BR Penthouse with sunset views over Calibogue Sound! All new mechanicals, wiring, appliances,etc. Exquisitely furnished! Enjoy a rare find in the heart of world-renowned Harbour Town in Sea Pines Plantation!\r\nProjected gross rental income based on a 2 BR unit on same floor is 60,000K annually! \r\nADDITIONAL BONUS:Seller will pay all current assessments at time of closing!\r\nGREAT investment opportunity!\r\nA combined offer for units 680,681,682 and 683 will be considered from an investor!', QuarterAvailable='', RegimeFeePerOwner='291.26', Restrictions='', Roof='Flat', Rooms='Dining Area,Eat-In Kitchen,Family Room,Great Room,Laun/Util Rm,Living Room,Pantry', Row='', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='1024', StateOrProvince='South Carolina', Status='Sold', StreetDirPrefix='', StreetDirSuffix='', StreetName='Lighthouse', StreetNumber='147', StreetNumberNumeric='147', StreetSuffix='ROAD', Style='', SubArea='Harbour Town', TermLength='Short Term', TotalAcres='', Treatment='', Type='Penthouse', TypeofSpace='', UnbrandedVirtualTourURL='', UnitNumber='682', UnitType='', View='Deep Water,Sound', Water='City PSD', WeekAvailable='', Windows='Not Applicable', YearBuilt='1977', Zoning='' WHERE MLSNumber='381184';

UPDATE properties SET AC='', AllowAVMs='0', Amenities='Leisure Trails', Appliances='', ApplicationFee='', ApproxHtdSqFt='', ApproximateBoatslipFt='', ApproxLotSize='0.19', Area='Bluffton/Off Plantation', Attic='', Availability='', AvailableDate='', BathsFull='', BathsHalf='', BathsTotal='', BedsTotal='', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Bluffton', CloseDate='2019-06-10', ClosePrice='137000.00', CommunityTourURL='', ConstructionFeatures='', ConstructionStatus='', ConsumerComments='0', CountyOrParish='Beaufort', CtyTaxRecordLivingArea='', ExteriorFeatures='', ExteriorType='', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='', FractionSize='', FractionUsage='', FurnishedYN='', GreenFeatures='', GrossOperatingIncome='', Heat='', IDXOptInYN='1', InteriorFeatures='', Land='', LeaseNetItems='', LeaseType='', LegalAddress='STOCK FARM DEV S/D', LegalNumber='11', ListOfficeName='Premier Island Properties', ListPrice='159900.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='', Matrix_Unique_ID='10978447', MatrixModifiedDT='2019-08-12T10:08:55.463', MLS='Hilton Head Island', MLSNumber='382722', ModelNameList='', MonthAvailable='', NetOperatingIncome='', NumAcres='Less than 1/4 Acres', OpenHouseFlags='', Parking='', PetDeposit='', Pets='', PhotoCount='3', PhotoModificationTimestamp='2018-06-05T16:33:14.423', POAFee='No POA fee reported', Pool='', PostalCode='29910', PostalCodePlus4='', PropertyFrontFaces='', PropertySubType='', PropertyType='Land/Lots', PropStatus='', PublicRemarks='Stock Farm was originally envisioned by its third-generation owners as a small, southern, residential community. This realized vision combined with low impact, mixed-use properties, is unique in its aesthetics, as well as the capacity for retail and commercial value along Hwy. 46. Conveniently located within walking distance to Old Town Bluffton.', QuarterAvailable='', RegimeFeePerOwner='', Restrictions='Community Covs and Restricts Apply', Roof='', Rooms='', Row='', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='', StateOrProvince='South Carolina', Status='Sold', StreetDirPrefix='', StreetDirSuffix='', StreetName='Guilford', StreetNumber='5806', StreetNumberNumeric='5806', StreetSuffix='PLACE', Style='', SubArea='Old Town Bluffton', TermLength='', TotalAcres='', Treatment='', Type='Full Lot', TypeofSpace='', UnbrandedVirtualTourURL='', UnitNumber='', UnitType='', View='Wooded', Water='', WeekAvailable='', Windows='', YearBuilt='', Zoning='' WHERE MLSNumber='382722';

UPDATE properties SET AC='', AllowAVMs='0', Amenities='Leisure Trails', Appliances='', ApplicationFee='', ApproxHtdSqFt='', ApproximateBoatslipFt='', ApproxLotSize='0.17', Area='Bluffton/Off Plantation', Attic='', Availability='', AvailableDate='', BathsFull='', BathsHalf='', BathsTotal='', BedsTotal='', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Bluffton', CloseDate='', ClosePrice='', CommunityTourURL='', ConstructionFeatures='', ConstructionStatus='', ConsumerComments='0', CountyOrParish='Beaufort', CtyTaxRecordLivingArea='', ExteriorFeatures='', ExteriorType='', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='', FractionSize='', FractionUsage='', FurnishedYN='', GreenFeatures='', GrossOperatingIncome='', Heat='', IDXOptInYN='1', InteriorFeatures='', Land='', LeaseNetItems='', LeaseType='', LegalAddress='STOCK FARM DEV S/D', LegalNumber='13', ListOfficeName='Premier Island Properties', ListPrice='159900.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='', Matrix_Unique_ID='10978449', MatrixModifiedDT='2019-08-28T13:31:09.470', MLS='Hilton Head Island', MLSNumber='382723', ModelNameList='', MonthAvailable='', NetOperatingIncome='', NumAcres='Less than 1/4 Acres', OpenHouseFlags='', Parking='', PetDeposit='', Pets='', PhotoCount='3', PhotoModificationTimestamp='2018-06-05T16:32:33.937', POAFee='No POA fee reported', Pool='', PostalCode='29910', PostalCodePlus4='', PropertyFrontFaces='', PropertySubType='', PropertyType='Land/Lots', PropStatus='', PublicRemarks='Stock Farm was originally envisioned by its third-generation owners as a small, southern, residential community. This realized vision combined with low impact, mixed-use properties, is unique in its aesthetics, as well as the capacity for retail and commercial value along Hwy. 46. Conveniently located within walking distance to Old Town Bluffton.', QuarterAvailable='', RegimeFeePerOwner='', Restrictions='Community Covs and Restricts Apply', Roof='', Rooms='', Row='', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='', StateOrProvince='South Carolina', Status='Under Contract', StreetDirPrefix='', StreetDirSuffix='', StreetName='Guilford', StreetNumber='5818', StreetNumberNumeric='5818', StreetSuffix='PLACE', Style='', SubArea='Old Town Bluffton', TermLength='', TotalAcres='', Treatment='', Type='Full Lot', TypeofSpace='', UnbrandedVirtualTourURL='https://tour.hiltonheadmls.com/5818-Guilford-PLACE-Bluffton-SC-29910/unbranded', UnitNumber='', UnitType='', View='Wooded', Water='', WeekAvailable='', Windows='', YearBuilt='', Zoning='' WHERE MLSNumber='382723';

UPDATE properties SET AC='Central,Heat Pump', AllowAVMs='1', Amenities='Leisure Trails,Stables', Appliances='None', ApplicationFee='', ApproxHtdSqFt='2806', ApproximateBoatslipFt='', ApproxLotSize='4.13', Area='Bluffton/Off Plantation', Attic='Attic - Crawl Space,Attic - Insulated', Availability='', AvailableDate='', BathsFull='1', BathsHalf='0', BathsTotal='1.00', BedsTotal='1', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Bluffton', CloseDate='', ClosePrice='', CommunityTourURL='', ConstructionFeatures='', ConstructionStatus='Not Applicable', ConsumerComments='0', CountyOrParish='Beaufort', CtyTaxRecordLivingArea='2806', ExteriorFeatures='Back Porch,Just Painted', ExteriorType='Wood Siding', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='Wood', FractionSize='', FractionUsage='', FurnishedYN='0', GreenFeatures='None', GrossOperatingIncome='', Heat='Central Heat', IDXOptInYN='1', InteriorFeatures='Just Painted In', Land='Dirt Road,Horses Allowed,Stables', LeaseNetItems='', LeaseType='', LegalAddress='MAY RIVER RD', LegalNumber='1114', ListOfficeName='Premier Island Properties', ListPrice='689900.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='1st Floor', Matrix_Unique_ID='10981652', MatrixModifiedDT='2019-09-26T15:01:47.333', MLS='Hilton Head Island', MLSNumber='382824', ModelNameList='', MonthAvailable='', NetOperatingIncome='', NumAcres='3 to 5 Acres', OpenHouseFlags='', Parking='Driveway', PetDeposit='', Pets='', PhotoCount='14', PhotoModificationTimestamp='2018-07-17T15:59:58.890', POAFee='No POA Fee', Pool='None', PostalCode='29910', PostalCodePlus4='', PropertyFrontFaces='Unknown', PropertySubType='', PropertyType='Residential-Single Fam', PropStatus='', PublicRemarks='EXCELLENT PRICE REDUCTION: 4.13 acres located w/in minutes of Old Town Bluffton. Build your dream estate or compound! Windsong Farms is a place where life slows to days gone by. For those who value privacy in a natural setting, this is an ideal location. Has both city water and a deep well with good water. Irrigation systems, horse stalls and small storage barn w/power, and an emergency generator w/300 gal propane tank are already in place. A small 1 bedroom cottage with full bath, kitchen and living room has been recently repainted.(2806 sf is incorrect for house!)', QuarterAvailable='', RegimeFeePerOwner='', Restrictions='No Restrictions', Roof='Asphalt', Rooms='Kitchen', Row='', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='2806', StateOrProvince='South Carolina', Status='Active', StreetDirPrefix='', StreetDirSuffix='', StreetName='May River', StreetNumber='1114', StreetNumberNumeric='1114', StreetSuffix='ROAD', Style='1st Elevated', SubArea='Hwy 46 –May River Side', TermLength='', TotalAcres='', Treatment='', Type='Full Size', TypeofSpace='', UnbrandedVirtualTourURL='https://tour.hiltonheadmls.com/1114-May-River-ROAD-Bluffton-SC-29910/unbranded', UnitNumber='', UnitType='', View='Marsh,River', Water='City PSD,Septic Tank,Well Water', WeekAvailable='', Windows='Unknown', YearBuilt='1986', Zoning='' WHERE MLSNumber='382824';

UPDATE properties SET AC='Central', AllowAVMs='1', Amenities='', Appliances='Dishwasher,Disposal,Dryer,Freezer,Ice Machine,Microwave,Oven,Range,Refrigerator,Washer', ApplicationFee='', ApproxHtdSqFt='1024', ApproximateBoatslipFt='', ApproxLotSize='', Area='Sea Pines', Attic='No Attic', Availability='', AvailableDate='', BathsFull='2', BathsHalf='0', BathsTotal='2.00', BedsTotal='2', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Hilton Head Island', CloseDate='2018-11-16', ClosePrice='395000.00', CommunityTourURL='', ConstructionFeatures='', ConstructionStatus='Not Applicable', ConsumerComments='0', CountyOrParish='Beaufort', CtyTaxRecordLivingArea='1024', ExteriorFeatures='Balcony', ExteriorType='Concrete Block,Steel/Glass', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='Luxury Vinyl Plank (LVP)', FractionSize='', FractionUsage='', FurnishedYN='1', GreenFeatures='None', GrossOperatingIncome='', Heat='Central Heat', IDXOptInYN='1', InteriorFeatures='Cable TV,Window Treatments,Elevator,Network Wiring,Smooth Ceilings', Land='', LeaseNetItems='', LeaseType='', LegalAddress='MARINERS WAY VILLAS', LegalNumber='680', ListOfficeName='Premier Island Properties', ListPrice='399000.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='1st Floor', Matrix_Unique_ID='10983974', MatrixModifiedDT='2018-11-18T22:11:32.267', MLS='Hilton Head Island', MLSNumber='382894', ModelNameList='', MonthAvailable='', NetOperatingIncome='', NumAcres='', OpenHouseFlags='', Parking='', PetDeposit='', Pets='', PhotoCount='38', PhotoModificationTimestamp='2018-10-04T22:40:58.040', POAFee='Sea Pines I $1076', Pool='', PostalCode='29928', PostalCodePlus4='', PropertyFrontFaces='West', PropertySubType='', PropertyType='Villas/Condos', PropStatus='', PublicRemarks='ENJOY A MAINTENANCE FREE LIFESTYLE IN PARADISE! Recently renovated 2 bedroom penthouse condominium with amazing rental income! Projected annual gross rental income is 60K based on villa\'s personal history! \r\nVilla is sold completely furnished! Walk to shops, restaurants, pier to see the most amazing sunsets! Sea Pines Trolley is downstairs to transport you to the most amazing beach and beach club.Ideal location on Conde Nast\'s 2017 choice for #1 Island in the United States!\r\nThis property makes an ideal second home and investment!\r\nSeller will pay all current assessment costa at closing!', QuarterAvailable='', RegimeFeePerOwner='291.00', Restrictions='', Roof='Asphalt,Flat', Rooms='Dining Area,Eat-In Kitchen,Family Room,Great Room', Row='', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='1024', StateOrProvince='South Carolina', Status='Sold', StreetDirPrefix='', StreetDirSuffix='', StreetName='Lighthouse', StreetNumber='147', StreetNumberNumeric='147', StreetSuffix='ROAD', Style='', SubArea='Harbour Town', TermLength='Short Term', TotalAcres='', Treatment='', Type='Penthouse', TypeofSpace='', UnbrandedVirtualTourURL='', UnitNumber='680', UnitType='', View='Harbor,Landscape', Water='City PSD', WeekAvailable='', Windows='Unknown', YearBuilt='1977', Zoning='' WHERE MLSNumber='382894';

UPDATE properties SET AC='Central,Electric,Heat Pump', AllowAVMs='0', Amenities='Community Pool,Tennis,Golf Privileges,Leisure Trails,Sec Gate/Guard', Appliances='Dishwasher,Disposal,Dryer,Ice Machine,Microwave,Oven,Range,Refrigerator,Washer', ApplicationFee='', ApproxHtdSqFt='1335', ApproximateBoatslipFt='', ApproxLotSize='', Area='Shipyard', Attic='No Attic', Availability='', AvailableDate='', BathsFull='2', BathsHalf='0', BathsTotal='2.00', BedsTotal='2', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Hilton Head Island', CloseDate='2018-10-10', ClosePrice='293000.00', CommunityTourURL='', ConstructionFeatures='', ConstructionStatus='Not Applicable', ConsumerComments='0', CountyOrParish='Beaufort', CtyTaxRecordLivingArea='1335', ExteriorFeatures='Patio', ExteriorType='Block/Stucco', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='Bamboo,Carpet,Tile,Wood', FractionSize='', FractionUsage='', FurnishedYN='1', GreenFeatures='None', GrossOperatingIncome='', Heat='Central Heat,Electric Heat,Heat Pump', IDXOptInYN='1', InteriorFeatures='Cable TV,Ceiling Fan(s),Fireplace,Just Painted In,Smoke Alarm,Wet Bar', Land='', LeaseNetItems='', LeaseType='', LegalAddress='EVIAN VILLAS', LegalNumber='130', ListOfficeName='Premier Island Properties', ListPrice='319900.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='1st Floor', Matrix_Unique_ID='11020600', MatrixModifiedDT='2018-10-11T04:17:01.237', MLS='Hilton Head Island', MLSNumber='383962', ModelNameList='', MonthAvailable='', NetOperatingIncome='', NumAcres='', OpenHouseFlags='', Parking='Unassigned Parking', PetDeposit='', Pets='Leash Law', PhotoCount='21', PhotoModificationTimestamp='2018-07-25T08:31:17.170', POAFee='Shipyard I $955', Pool='Community,Free Form', PostalCode='29928', PostalCodePlus4='', PropertyFrontFaces='SouthEast', PropertySubType='', PropertyType='Villas/Condos', PropStatus='', PublicRemarks='Light and bright 2BR/2BA 1st floor end unit in Evian, a separate community w/in Shipyard Plantation with private pool and tennis courts. Great view of the golf course,walk or bike to Shipyard Beach Club. This unit features stainless steel appliances, granite counter tops, bamboo hardwood floor,s and tile flooring in the kitchen. Being sold furnished. Ready for the rental market, second home, or as a primary residence.', QuarterAvailable='', RegimeFeePerOwner='447', Restrictions='', Roof='Asphalt', Rooms='Dining Area,Great Room,Kitchen', Row='', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='1335', StateOrProvince='South Carolina', Status='Sold', StreetDirPrefix='', StreetDirSuffix='', StreetName='Shipyard', StreetNumber='70', StreetNumberNumeric='70', StreetSuffix='DRIVE', Style='', SubArea='Shipyard', TermLength='', TotalAcres='', Treatment='', Type='Townhouse/Multi-level', TypeofSpace='', UnbrandedVirtualTourURL='', UnitNumber='130', UnitType='', View='Golf', Water='', WeekAvailable='', Windows='Unknown', YearBuilt='1983', Zoning='' WHERE MLSNumber='383962';

UPDATE properties SET AC='Central,Electric,Heat Pump', AllowAVMs='0', Amenities='', Appliances='Dishwasher,Disposal,Dryer,Freezer,Ice Machine,Microwave,Oven Self-Cleaning,Range,Refrigerator,Washer', ApplicationFee='', ApproxHtdSqFt='1024', ApproximateBoatslipFt='', ApproxLotSize='', Area='Sea Pines', Attic='No Attic', Availability='', AvailableDate='', BathsFull='2', BathsHalf='0', BathsTotal='2.00', BedsTotal='2', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Hilton Head Island', CloseDate='2019-01-22', ClosePrice='410000.00', CommunityTourURL='', ConstructionFeatures='', ConstructionStatus='Not Applicable', ConsumerComments='0', CountyOrParish='Beaufort', CtyTaxRecordLivingArea='1024', ExteriorFeatures='Balcony,Handicap Access,Hurricane Protect,Just Painted', ExteriorType='Block/Stucco,Concrete Block,Masonry/Steel', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='Luxury Vinyl Plank (LVP)', FractionSize='', FractionUsage='', FurnishedYN='1', GreenFeatures='None', GrossOperatingIncome='', Heat='Electric Heat', IDXOptInYN='1', InteriorFeatures='Cable TV,Ceiling Fan(s),Elevator,Fire Alarm,Handicap Access,Just Painted In,Just Painted Out,Network Wiring,Separate Shower,Smooth Ceilings', Land='', LeaseNetItems='', LeaseType='', LegalAddress='MARINERS WAY VILLAS', LegalNumber='681', ListOfficeName='Premier Island Properties', ListPrice='429000.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='Unit Level', Matrix_Unique_ID='13911402', MatrixModifiedDT='2019-01-26T22:35:06.310', MLS='Hilton Head Island', MLSNumber='385894', ModelNameList='', MonthAvailable='', NetOperatingIncome='', NumAcres='', OpenHouseFlags='', Parking='', PetDeposit='', Pets='', PhotoCount='22', PhotoModificationTimestamp='2018-12-09T10:38:25.333', POAFee='Sea Pines I $1076', Pool='', PostalCode='29928', PostalCodePlus4='', PropertyFrontFaces='North', PropertySubType='', PropertyType='Villas/Condos', PropStatus='', PublicRemarks='Enjoy MAINTENANCE FREE LIVING IN PARADISE! Brand new fully furnished 2 BR Penthouse in Harbour Town with AMAZING income potential!\r\n2 BR villa on same floor grossed 60 K last year in rental income! \r\nINVESTORS: Units 681 and 683 are available. A combined offer will be considered.\r\nBright, fresh turnkey home minutes to golf, tennis, restaurants, shops and the delightful lighthouse and pier!\r\nLocation is more than IDEAL with trolley downstairs! Park your car for the week and bike and/or trolley everywhere!', QuarterAvailable='', RegimeFeePerOwner='284', Restrictions='', Roof='Asphalt', Rooms='Dining Area,Eat-In Kitchen,Family Room,Great Room,Kitchen', Row='', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='1024', StateOrProvince='South Carolina', Status='Sold', StreetDirPrefix='', StreetDirSuffix='', StreetName='Lighthouse', StreetNumber='147', StreetNumberNumeric='147', StreetSuffix='ROAD', Style='', SubArea='Harbour Town', TermLength='Short Term', TotalAcres='', Treatment='', Type='Penthouse', TypeofSpace='', UnbrandedVirtualTourURL='', UnitNumber='681', UnitType='', View='Sound', Water='City PSD', WeekAvailable='', Windows='Impact-Entire Home', YearBuilt='1977', Zoning='' WHERE MLSNumber='385894';

UPDATE properties SET AC='Central', AllowAVMs='0', Amenities='Clubhouse,Community Pool,Tennis,Golf Privileges,Leisure Trails,Sec Gate/Guard', Appliances='Dishwasher,Disposal,Microwave,Oven Self-Cleaning', ApplicationFee='', ApproxHtdSqFt='1888', ApproximateBoatslipFt='', ApproxLotSize='0.3474', Area='Hilton Head Plantation', Attic='Attic - Insulated,Stairs - Pull Down', Availability='', AvailableDate='', BathsFull='2', BathsHalf='0', BathsTotal='2.00', BedsTotal='3', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Hilton Head Island', CloseDate='2019-08-02', ClosePrice='328000.00', CommunityTourURL='', ConstructionFeatures='', ConstructionStatus='Not Applicable', ConsumerComments='0', CountyOrParish='Beaufort', CtyTaxRecordLivingArea='1888', ExteriorFeatures='Back Porch,Patio,Paved Drive,Storage Shed', ExteriorType='Block/Stucco,Wood Siding', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='Carpet,Manufac/Wood,Tile', FractionSize='', FractionUsage='', FurnishedYN='0', GreenFeatures='None', GrossOperatingIncome='', Heat='Central Heat', IDXOptInYN='1', InteriorFeatures='Book Shelves,Cathedral Ceilings,Ceiling Fan(s),Fireplace,Wet Bar', Land='Cul-de-Sac Street', LeaseNetItems='', LeaseType='', LegalAddress='MYRTLE BANK SUB', LegalNumber='45', ListOfficeName='Premier Island Properties', ListPrice='325000.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='1st Floor', Matrix_Unique_ID='14269980', MatrixModifiedDT='2019-08-06T15:18:34.030', MLS='Hilton Head Island', MLSNumber='387176', ModelNameList='', MonthAvailable='', NetOperatingIncome='', NumAcres='1/4 to 1/2 Acre', OpenHouseFlags='', Parking='Driveway', PetDeposit='', Pets='', PhotoCount='17', PhotoModificationTimestamp='2018-10-15T23:27:21.823', POAFee='HH Plant I $1370', Pool='Community', PostalCode='29926', PostalCodePlus4='', PropertyFrontFaces='NorthWest', PropertySubType='', PropertyType='Residential-Single Fam', PropStatus='', PublicRemarks='Light filled 3BR home on a quiet wooded lot located on a cul de sac in Hilton Head Plantation. Home boasts high ceilings w/ multiple sky lights, convertible BR options for office/den and room off of the kitchen areas. New roof and bathroom upgrades in 2012. Large living room complete with fireplace and hardwood floors. Dining room has its own built in bar. Separate laundry room. Large deck adjacent to plenty of private wooded area. Home being sold \"as is where is\".', QuarterAvailable='', RegimeFeePerOwner='', Restrictions='Community Covs and Restricts Apply,No Commercial,No Motorcycles,Pets OK', Roof='Asphalt', Rooms='Converted Bedroom,Den,Dining Room,Eat-In Kitchen,Family Room,Kitchen,Laun/Util Rm', Row='Over 12', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='1888', StateOrProvince='South Carolina', Status='Sold', StreetDirPrefix='', StreetDirSuffix='', StreetName='Maplewood', StreetNumber='4', StreetNumberNumeric='4', StreetSuffix='COURT', Style='1st Floor On Grade', SubArea='Dolphin Head', TermLength='', TotalAcres='', Treatment='', Type='Full Size', TypeofSpace='', UnbrandedVirtualTourURL='', UnitNumber='', UnitType='', View='Wooded', Water='City PSD', WeekAvailable='', Windows='Unknown', YearBuilt='1982', Zoning='' WHERE MLSNumber='387176';

UPDATE properties SET AC='', AllowAVMs='1', Amenities='Leisure Trails', Appliances='', ApplicationFee='', ApproxHtdSqFt='', ApproximateBoatslipFt='', ApproxLotSize='9,306', Area='Bluffton/Off Plantation', Attic='', Availability='', AvailableDate='', BathsFull='', BathsHalf='', BathsTotal='', BedsTotal='', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Bluffton', CloseDate='2019-10-03', ClosePrice='135000.00', CommunityTourURL='', ConstructionFeatures='', ConstructionStatus='', ConsumerComments='0', CountyOrParish='Beaufort', CtyTaxRecordLivingArea='', ExteriorFeatures='', ExteriorType='', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='', FractionSize='', FractionUsage='', FurnishedYN='', GreenFeatures='None', GrossOperatingIncome='', Heat='', IDXOptInYN='1', InteriorFeatures='', Land='Adjacent Lot Available', LeaseNetItems='', LeaseType='', LegalAddress='BLUFFTON TOWNSHIP', LegalNumber='3', ListOfficeName='Premier Island Properties', ListPrice='139900.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='', Matrix_Unique_ID='14274773', MatrixModifiedDT='2019-10-04T09:47:49.853', MLS='Hilton Head Island', MLSNumber='387308', ModelNameList='', MonthAvailable='', NetOperatingIncome='', NumAcres='Less than 1/4 Acres', OpenHouseFlags='', Parking='', PetDeposit='', Pets='', PhotoCount='1', PhotoModificationTimestamp='2018-10-20T15:28:08.747', POAFee='No POA Fee', Pool='', PostalCode='29910', PostalCodePlus4='', PropertyFrontFaces='', PropertySubType='', PropertyType='Land/Lots', PropStatus='', PublicRemarks='Excellent location in Old Town offering convenience to Pritchard Street\'s newly created \"Pocket Park\" and across from the completely renovated Town Center with new landscaping improving the quality of Pritchard Street\'s appearance. Lot can be residential, commercial or mixed use. (Think artist studio & resident - many other usages). Lot size is 9,306 square feet with over 60\' of frontage on Pritchard Street. This is a sought after nicely wooded lot; walk to Old Town, the new Town Hall and MC Reilley. Property backs up to School House Cove ((Heyward Cove) and is considered one (1) of the best streets to build on in OT. Tree and Topo Available.', QuarterAvailable='', RegimeFeePerOwner='', Restrictions='Motorcycles Allowed,Pets OK,No Restrictions', Roof='', Rooms='', Row='', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='', StateOrProvince='South Carolina', Status='Sold', StreetDirPrefix='', StreetDirSuffix='', StreetName='Pritchard', StreetNumber='54', StreetNumberNumeric='54', StreetSuffix='STREET', Style='', SubArea='Old Town Bluffton', TermLength='', TotalAcres='', Treatment='', Type='Full Lot', TypeofSpace='', UnbrandedVirtualTourURL='', UnitNumber='', UnitType='', View='Wooded', Water='City PSD', WeekAvailable='', Windows='', YearBuilt='', Zoning='Residential' WHERE MLSNumber='387308';

INSERT INTO properties SET AC='Central', AllowAVMs='1', Amenities='Boat Storage,No Amenities', Appliances='Dishwasher,Dryer,Microwave,Oven,Range - Gas,Refrigerator,Washer', ApplicationFee='', ApproxHtdSqFt='2040', ApproximateBoatslipFt='', ApproxLotSize='0.4419', Area='Bluffton/Off Plantation', Attic='Attic - Walk in,Unfinished', Availability='', AvailableDate='', BathsFull='3', BathsHalf='1', BathsTotal='4.00', BedsTotal='5', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Bluffton', CloseDate='2019-09-12', ClosePrice='645000.00', CommunityTourURL='', ConstructionFeatures='', ConstructionStatus='Not Applicable', ConsumerComments='0', CountyOrParish='Beaufort', CtyTaxRecordLivingArea='2040', ExteriorFeatures='Back Porch,Enclosed Porch,Irri System,Just Painted,Outdoor Shower,Paved Drive,Propane Tank - Above Ground,Screened Porch,Screens,Storage Shed', ExteriorType='Wood Siding', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='Carpet,Concrete,Pine', FractionSize='', FractionUsage='', FurnishedYN='0', GreenFeatures='None', GrossOperatingIncome='', Heat='Central Heat,Heat Pump,Multi Zone Heat', IDXOptInYN='1', InteriorFeatures='Book Shelves,Built-Ins,Cable TV,Ceiling Fan(s),Hot Tub/Spa,Many Closets,Network Wiring,Security Sys,Separate Shower,Smoke Alarm,Smooth Ceilings,Ventilating Fan,Wet Bar', Land='Corner Lot', LeaseNetItems='', LeaseType='', LegalAddress='PINE ISLAND', LegalNumber='27', ListOfficeName='Premier Island Properties', ListPrice='669000.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='1st Floor', Matrix_Unique_ID='14298948', MatrixModifiedDT='2019-09-17T12:10:15.320', MLS='Hilton Head Island', MLSNumber='387911', ModelNameList='', MonthAvailable='', NetOperatingIncome='', NumAcres='1 to 3 Acres', OpenHouseFlags='', Parking='Carport - 1 Car,Golf Cart Garage/Detached', PetDeposit='', Pets='', PhotoCount='15', PhotoModificationTimestamp='2018-11-14T12:17:45.830', POAFee='No POA fee reported', Pool='None', PostalCode='29910', PostalCodePlus4='', PropertyFrontFaces='North', PropertySubType='', PropertyType='Residential-Single Fam', PropStatus='', PublicRemarks='This 5BDRM/3.5BA home is the only available property for sale in the private, gated community of Little Pine Island. Heart of pine floors, ample outdoor living spaces which include(s) a full kitchen, inside/outside bar with air conditioning, both screened and unscreened porches, a half bath, and an outdoor shower. Panoramic marsh and water views from everywhere in the home. New roof 2016. This sale includes 29 Driftwood Drive Tax #R600-048-000-0029-0000, which has plenty of land to put another building. This lot could also be used for boat storage. No regime fees.', QuarterAvailable='', RegimeFeePerOwner='', Restrictions='Community Covs and Restricts Apply,Motorcycles Allowed,No Commercial,Pets OK', Roof='Metal', Rooms='Converted Garage,Den,Eat-In Kitchen,Family Room,Game Room,Great Room,Kitchen,Laun/Util Rm,Leisure Room,Living Room,Screen Pat/Por,Storage Room,Workshop', Row='', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='2040', StateOrProvince='South Carolina', Status='Sold', StreetDirPrefix='', StreetDirSuffix='', StreetName='Driftwood', StreetNumber='27', StreetNumberNumeric='27', StreetSuffix='DRIVE', Style='Two Story', SubArea='Alljoy Rd Area', TermLength='', TotalAcres='', Treatment='', Type='Full Size', TypeofSpace='', UnbrandedVirtualTourURL='', UnitNumber='', UnitType='', View='Marsh', Water='City PSD,Septic Tank', WeekAvailable='', Windows='Unknown', YearBuilt='1998', Zoning='' ;

INSERT INTO properties_order SET MLSNumber='387911', sort_order='1', date_added=now(), theStatus='Active', notes='Driftwood 27';

INSERT INTO pending_images SET MLSNumber='387911', date_added=now(), sort_order='3';

Update Image

UPDATE properties SET AC='', AllowAVMs='1', Amenities='Boat Storage,Day Dock,Deep Water Access', Appliances='', ApplicationFee='', ApproxHtdSqFt='', ApproximateBoatslipFt='', ApproxLotSize='0.1152', Area='Bluffton/Off Plantation', Attic='', Availability='', AvailableDate='', BathsFull='', BathsHalf='', BathsTotal='', BedsTotal='', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Bluffton', CloseDate='2019-07-01', ClosePrice='65000.00', CommunityTourURL='', ConstructionFeatures='', ConstructionStatus='', ConsumerComments='0', CountyOrParish='Beaufort', CtyTaxRecordLivingArea='', ExteriorFeatures='', ExteriorType='', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='', FractionSize='', FractionUsage='', FurnishedYN='', GreenFeatures='', GrossOperatingIncome='', Heat='', IDXOptInYN='1', InteriorFeatures='', Land='', LeaseNetItems='', LeaseType='', LegalAddress='BRIGHTON/PALMETTO BCH', LegalNumber='31', ListOfficeName='Premier Island Properties', ListPrice='74500.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='', Matrix_Unique_ID='14360716', MatrixModifiedDT='2019-07-02T15:23:07.210', MLS='Hilton Head Island', MLSNumber='389359', ModelNameList='', MonthAvailable='', NetOperatingIncome='', NumAcres='Less than 1/4 Acres', OpenHouseFlags='', Parking='', PetDeposit='', Pets='', PhotoCount='3', PhotoModificationTimestamp='2019-01-22T12:23:15.567', POAFee='No POA fee reported', Pool='', PostalCode='29910', PostalCodePlus4='', PropertyFrontFaces='', PropertySubType='', PropertyType='Land/Lots', PropStatus='', PublicRemarks='Wonderful lot located on Luray Street off of All Joy Road, close to the All Joy Boat Landing and Old Town Bluffton. Lot has been cleared and permitted for septic, all ready to build your dream residence. Please see attached new elevation and boundary survey.', QuarterAvailable='', RegimeFeePerOwner='', Restrictions='No Restrictions', Roof='', Rooms='', Row='', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='', StateOrProvince='South Carolina', Status='Sold', StreetDirPrefix='', StreetDirSuffix='', StreetName='Luray', StreetNumber='21', StreetNumberNumeric='21', StreetSuffix='STREET', Style='', SubArea='Alljoy Rd Area', TermLength='', TotalAcres='', Treatment='', Type='Full Lot', TypeofSpace='', UnbrandedVirtualTourURL='', UnitNumber='', UnitType='', View='Landscape', Water='Septic Tank', WeekAvailable='', Windows='', YearBuilt='', Zoning='' WHERE MLSNumber='389359';

INSERT INTO properties SET AC='', AllowAVMs='0', Amenities='', Appliances='', ApplicationFee='', ApproxHtdSqFt='', ApproximateBoatslipFt='', ApproxLotSize='0.84', Area='Hilton Head Commercial', Attic='', Availability='', AvailableDate='', BathsFull='', BathsHalf='', BathsTotal='', BedsTotal='', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Hilton Head Island', CloseDate='', ClosePrice='', CommunityTourURL='', ConstructionFeatures='', ConstructionStatus='Not Applicable', ConsumerComments='', CountyOrParish='Beaufort', CtyTaxRecordLivingArea='4352', ExteriorFeatures='', ExteriorType='', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='', FractionSize='', FractionUsage='', FurnishedYN='', GreenFeatures='', GrossOperatingIncome='', Heat='', IDXOptInYN='1', InteriorFeatures='', Land='', LeaseNetItems='', LeaseType='', LegalAddress='COMM BLDG SO', LegalNumber='11', ListOfficeName='Premier Island Properties', ListPrice='2000000.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='', Matrix_Unique_ID='14368900', MatrixModifiedDT='2019-09-20T16:14:57.740', MLS='Hilton Head Island', MLSNumber='389572', ModelNameList='', MonthAvailable='', NetOperatingIncome='', NumAcres='', OpenHouseFlags='', Parking='', PetDeposit='', Pets='', PhotoCount='15', PhotoModificationTimestamp='2019-01-30T16:32:32.500', POAFee='', Pool='', PostalCode='29928', PostalCodePlus4='', PropertyFrontFaces='', PropertySubType='', PropertyType='Commercial', PropStatus='', PublicRemarks='Completely renovated and upgraded restaurant building with major frontage on busy Pope Avenue. Dedicated building monument sign. Large interior dining and exterior covered dining space overlooking water. High quality interior and exterior furnishings , finishings, equipment and details throughout. Existing practically walk in condition. FF&E included in the sale.', QuarterAvailable='', RegimeFeePerOwner='', Restrictions='', Roof='', Rooms='', Row='', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='', StateOrProvince='South Carolina', Status='Under Contract', StreetDirPrefix='', StreetDirSuffix='', StreetName='Executive Park', StreetNumber='8', StreetNumberNumeric='8', StreetSuffix='ROAD', Style='', SubArea='', TermLength='', TotalAcres='', Treatment='', Type='', TypeofSpace='Commercial Building', UnbrandedVirtualTourURL='https://tour.hiltonheadmls.com/8-Executive-Park-ROAD-Hilton-Head-Island-SC-29928/unbranded', UnitNumber='', UnitType='', View='', Water='', WeekAvailable='', Windows='', YearBuilt='', Zoning='COMM CTR - CC' ;

INSERT INTO properties_order SET MLSNumber='389572', sort_order='1', date_added=now(), theStatus='Active', notes='Executive Park 8';

INSERT INTO properties SET AC='', AllowAVMs='0', Amenities='No Amenities', Appliances='', ApplicationFee='', ApproxHtdSqFt='', ApproximateBoatslipFt='', ApproxLotSize='0.23', Area='Bluffton/Off Plantation', Attic='', Availability='', AvailableDate='', BathsFull='', BathsHalf='', BathsTotal='', BedsTotal='', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Bluffton', CloseDate='', ClosePrice='', CommunityTourURL='', ConstructionFeatures='', ConstructionStatus='', ConsumerComments='0', CountyOrParish='Beaufort', CtyTaxRecordLivingArea='', ExteriorFeatures='', ExteriorType='', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='', FractionSize='', FractionUsage='', FurnishedYN='', GreenFeatures='', GrossOperatingIncome='', Heat='', IDXOptInYN='1', InteriorFeatures='', Land='', LeaseNetItems='', LeaseType='', LegalAddress='PALMETTO BEACH S/D', LegalNumber='1', ListOfficeName='Premier Island Properties', ListPrice='629000.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='', Matrix_Unique_ID='14433909', MatrixModifiedDT='2019-03-13T20:00:22.457', MLS='Hilton Head Island', MLSNumber='391955', ModelNameList='', MonthAvailable='', NetOperatingIncome='', NumAcres='Less than 1/4 Acres', OpenHouseFlags='', Parking='', PetDeposit='', Pets='', PhotoCount='4', PhotoModificationTimestamp='2019-03-13T18:15:11.823', POAFee='No POA fee reported', Pool='', PostalCode='29910', PostalCodePlus4='', PropertyFrontFaces='', PropertySubType='', PropertyType='Land/Lots', PropStatus='', PublicRemarks='Sewer is forthcoming. This property is to be sold with R610-029-00A-014C-0000. This is a \" Gateway to Old Town\" on Highway 46. Excellent frontage on a major road. Steps to The Promenade, Bluffton Village, and Calhoun Street. One of the last few available properties in Old Town Bluffton with mixed use appeal.', QuarterAvailable='', RegimeFeePerOwner='', Restrictions='Motorcycles Allowed', Roof='', Rooms='', Row='', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='', StateOrProvince='South Carolina', Status='Active', StreetDirPrefix='', StreetDirSuffix='', StreetName='Bluffton', StreetNumber='182', StreetNumberNumeric='182', StreetSuffix='ROAD', Style='', SubArea='Old Town Bluffton', TermLength='', TotalAcres='', Treatment='', Type='Full Lot', TypeofSpace='', UnbrandedVirtualTourURL='https://tour.hiltonheadmls.com/182-Bluffton-ROAD-Bluffton-SC-29910/unbranded', UnitNumber='', UnitType='', View='Landscape', Water='', WeekAvailable='', Windows='', YearBuilt='', Zoning='' ;

INSERT INTO properties_order SET MLSNumber='391955', sort_order='1', date_added=now(), theStatus='Active', notes='Bluffton 182';

INSERT INTO properties SET AC='', AllowAVMs='0', Amenities='', Appliances='', ApplicationFee='', ApproxHtdSqFt='', ApproximateBoatslipFt='', ApproxLotSize='1.352', Area='Bluffton/Off Plantation', Attic='', Availability='', AvailableDate='', BathsFull='', BathsHalf='', BathsTotal='', BedsTotal='', Building='Gas/Conv/Fastfood', BusinessType='Retail', CeilingHeight='', CheckIn='', City='Bluffton', CloseDate='', ClosePrice='', CommunityTourURL='', ConstructionFeatures='Block', ConstructionStatus='Not Applicable', ConsumerComments='', CountyOrParish='Beaufort', CtyTaxRecordLivingArea='', ExteriorFeatures='', ExteriorType='', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='', FractionSize='', FractionUsage='', FurnishedYN='', GreenFeatures='', GrossOperatingIncome='', Heat='', IDXOptInYN='1', InteriorFeatures='', Land='', LeaseNetItems='', LeaseType='', LegalAddress='MAY RIVER RD', LegalNumber='1189', ListOfficeName='Premier Island Properties', ListPrice='1500000.00', Loading='', Location='Corner Lot', MaintenanceFee='', MasterBedroom='', Matrix_Unique_ID='14445428', MatrixModifiedDT='2019-10-12T12:34:42.250', MLS='Hilton Head Island', MLSNumber='392182', ModelNameList='', MonthAvailable='', NetOperatingIncome='', NumAcres='', OpenHouseFlags='', Parking='', PetDeposit='', Pets='', PhotoCount='7', PhotoModificationTimestamp='2019-10-12T12:34:42.250', POAFee='', Pool='', PostalCode='29910', PostalCodePlus4='', PropertyFrontFaces='', PropertySubType='', PropertyType='Commercial', PropStatus='', PublicRemarks='Messex - Full service - One Stop Filling Station, Garage and Convenience Store along with rented property - excellent commercial opportunity, income producing within the direct path of Bluffton\'s growth, today and in the future.', QuarterAvailable='', RegimeFeePerOwner='', Restrictions='', Roof='', Rooms='', Row='', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='', StateOrProvince='South Carolina', Status='Active', StreetDirPrefix='', StreetDirSuffix='', StreetName='May River', StreetNumber='1189', StreetNumberNumeric='1189', StreetSuffix='ROAD', Style='', SubArea='', TermLength='', TotalAcres='1.4000', Treatment='', Type='', TypeofSpace='Commercial Building', UnbrandedVirtualTourURL='https://tour.hiltonheadmls.com/1189-May-River-ROAD-Bluffton-SC-29910/unbranded', UnitNumber='', UnitType='', View='', Water='', WeekAvailable='', Windows='', YearBuilt='', Zoning='General Com-Beau' ;

INSERT INTO properties_order SET MLSNumber='392182', sort_order='1', date_added=now(), theStatus='Active', notes='May River 1189';

UPDATE properties SET AC='Central', AllowAVMs='0', Amenities='No Amenities', Appliances='None', ApplicationFee='', ApproxHtdSqFt='1541', ApproximateBoatslipFt='', ApproxLotSize='0.6276', Area='Bluffton/Off Plantation', Attic='Unfinished', Availability='', AvailableDate='', BathsFull='2', BathsHalf='0', BathsTotal='2.00', BedsTotal='3', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Bluffton', CloseDate='', ClosePrice='', CommunityTourURL='', ConstructionFeatures='', ConstructionStatus='Not Applicable', ConsumerComments='0', CountyOrParish='Beaufort', CtyTaxRecordLivingArea='1541', ExteriorFeatures='None', ExteriorType='Brick', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='Concrete', FractionSize='', FractionUsage='', FurnishedYN='0', GreenFeatures='None', GrossOperatingIncome='', Heat='No Heating', IDXOptInYN='1', InteriorFeatures='Many Closets', Land='Adjacent Lot Available', LeaseNetItems='', LeaseType='', LegalAddress='BIG BUCK ISLAND', LegalNumber='12', ListOfficeName='Premier Island Properties', ListPrice='465000.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='1st Floor', Matrix_Unique_ID='14445808', MatrixModifiedDT='2019-09-26T15:33:45.303', MLS='Hilton Head Island', MLSNumber='392191', ModelNameList='', MonthAvailable='', NetOperatingIncome='', NumAcres='1/2 to 1 Acre', OpenHouseFlags='', Parking='Carport - 1 Car,Garage - 1 Car,Garage - Detached', PetDeposit='', Pets='', PhotoCount='12', PhotoModificationTimestamp='2019-03-21T14:44:11.960', POAFee='No POA Fee', Pool='None', PostalCode='29910', PostalCodePlus4='', PropertyFrontFaces='SouthWest', PropertySubType='', PropertyType='Residential-Single Fam', PropStatus='', PublicRemarks='Price Reduced - Spectacular marsh and river views. This home and and adjacent property makes a wonderful waterfront compound in a great neighbor. House is ready for a good renovation. Sellers requires both properties 59 and 57 Buck Point Rd be sold together (57) MLS and house (59) Buck Point Road.\r\nProperty is being sold \"as is, where is\".', QuarterAvailable='', RegimeFeePerOwner='', Restrictions='No Restrictions', Roof='Asphalt', Rooms='Kitchen,Living Room', Row='', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='1541', StateOrProvince='South Carolina', Status='Active', StreetDirPrefix='', StreetDirSuffix='', StreetName='Buck Point', StreetNumber='59', StreetNumberNumeric='59', StreetSuffix='ROAD', Style='One Story', SubArea='Hwy 46 –May River Side', TermLength='', TotalAcres='', Treatment='', Type='Full Size', TypeofSpace='', UnbrandedVirtualTourURL='https://tour.hiltonheadmls.com/59-Buck-Point-ROAD-Bluffton-SC-29910/unbranded', UnitNumber='', UnitType='', View='Marsh', Water='Septic Tank', WeekAvailable='', Windows='Not Applicable', YearBuilt='1962', Zoning='' WHERE MLSNumber='392191';

UPDATE properties SET AC='Central', AllowAVMs='0', Amenities='No Amenities', Appliances='Dishwasher,Disposal,Dryer,Microwave,Oven,Range,Range - Gas,Refrigerator', ApplicationFee='', ApproxHtdSqFt='2166', ApproximateBoatslipFt='', ApproxLotSize='0.4581', Area='Bluffton/Off Plantation', Attic='Attic - Crawl Space,Attic - Insulated,Attic - Partially Floored', Availability='', AvailableDate='', BathsFull='2', BathsHalf='1', BathsTotal='3.00', BedsTotal='3', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Bluffton', CloseDate='2019-05-17', ClosePrice='669500.00', CommunityTourURL='', ConstructionFeatures='', ConstructionStatus='Not Applicable', ConsumerComments='0', CountyOrParish='Beaufort', CtyTaxRecordLivingArea='2166', ExteriorFeatures='Back Porch,Deck,Enclosed Porch,Front Porch,Screened Porch,Screens', ExteriorType='Block/Stucco', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='Carpet,Tile,Wood', FractionSize='', FractionUsage='', FurnishedYN='0', GreenFeatures='None', GrossOperatingIncome='', Heat='Central Heat', IDXOptInYN='1', InteriorFeatures='Book Shelves,Cable TV,Window Treatments,Jetted Tub,Many Closets,Network Wiring,Security Sys,Separate Shower,Smoke Alarm,Smooth Ceilings,Sound Sys Wire,Water Soft Equipment', Land='', LeaseNetItems='', LeaseType='', LegalAddress='TOWN OF BLUFFTON', LegalNumber='48', ListOfficeName='Premier Island Properties', ListPrice='689900.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='3rd Floor', Matrix_Unique_ID='14446099', MatrixModifiedDT='2019-08-02T16:36:51.213', MLS='Hilton Head Island', MLSNumber='392197', ModelNameList='', MonthAvailable='', NetOperatingIncome='', NumAcres='1/4 to 1/2 Acre', OpenHouseFlags='', Parking='Garage - 2 Car,Under Parking', PetDeposit='', Pets='', PhotoCount='15', PhotoModificationTimestamp='2019-03-21T17:44:24.193', POAFee='No POA fee reported', Pool='None', PostalCode='29910', PostalCodePlus4='', PropertyFrontFaces='Unknown', PropertySubType='', PropertyType='Residential-Single Fam', PropStatus='', PublicRemarks='Great location', QuarterAvailable='', RegimeFeePerOwner='', Restrictions='No Restrictions', Roof='Metal', Rooms='Carolina Room,Den,Dining Area,Dining Room,Eat-In Kitchen,Great Room,Kitchen,Laun/Util Rm,Leisure Room,Library/Office,Living Room,Screen Pat/Por,Storage Room,Workshop', Row='', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='2166', StateOrProvince='South Carolina', Status='Sold', StreetDirPrefix='', StreetDirSuffix='', StreetName='Lawrence', StreetNumber='48', StreetNumberNumeric='48', StreetSuffix='STREET', Style='Three Story', SubArea='Old Town Bluffton', TermLength='', TotalAcres='', Treatment='', Type='Full Size', TypeofSpace='', UnbrandedVirtualTourURL='', UnitNumber='', UnitType='', View='Wooded', Water='City PSD,Sewer Available', WeekAvailable='', Windows='Insulated', YearBuilt='2003', Zoning='' WHERE MLSNumber='392197';

INSERT INTO properties SET AC='', AllowAVMs='1', Amenities='No Amenities', Appliances='', ApplicationFee='', ApproxHtdSqFt='', ApproximateBoatslipFt='', ApproxLotSize='0.4828', Area='Bluffton/Off Plantation', Attic='', Availability='', AvailableDate='', BathsFull='', BathsHalf='', BathsTotal='', BedsTotal='', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Bluffton', CloseDate='', ClosePrice='', CommunityTourURL='', ConstructionFeatures='', ConstructionStatus='', ConsumerComments='0', CountyOrParish='Beaufort', CtyTaxRecordLivingArea='', ExteriorFeatures='', ExteriorType='', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='', FractionSize='', FractionUsage='', FurnishedYN='', GreenFeatures='', GrossOperatingIncome='', Heat='', IDXOptInYN='1', InteriorFeatures='', Land='', LeaseNetItems='', LeaseType='', LegalAddress='BUCK ISLAND', LegalNumber='11', ListOfficeName='Premier Island Properties', ListPrice='235900.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='', Matrix_Unique_ID='14446183', MatrixModifiedDT='2019-09-10T18:54:27.920', MLS='Hilton Head Island', MLSNumber='392201', ModelNameList='', MonthAvailable='', NetOperatingIncome='', NumAcres='1/4 to 1/2 Acre', OpenHouseFlags='', Parking='', PetDeposit='', Pets='', PhotoCount='5', PhotoModificationTimestamp='2019-03-21T16:41:11.610', POAFee='No POA fee reported', Pool='', PostalCode='29910', PostalCodePlus4='', PropertyFrontFaces='', PropertySubType='', PropertyType='Land/Lots', PropStatus='', PublicRemarks='Property must be sold with adjacent property - 59 Buck Point Road. MLS #392191', QuarterAvailable='', RegimeFeePerOwner='', Restrictions='Motorcycles Allowed,No Truck/Trailer,Pets OK,No Restrictions', Roof='', Rooms='', Row='', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='', StateOrProvince='South Carolina', Status='Active', StreetDirPrefix='', StreetDirSuffix='', StreetName='Buck Point', StreetNumber='57', StreetNumberNumeric='57', StreetSuffix='ROAD', Style='', SubArea='Hwy 46 –May River Side', TermLength='', TotalAcres='', Treatment='', Type='Full Lot', TypeofSpace='', UnbrandedVirtualTourURL='https://tour.hiltonheadmls.com/57-Buck-Point-ROAD-Bluffton-SC-29910/unbranded', UnitNumber='', UnitType='', View='Marsh', Water='', WeekAvailable='', Windows='', YearBuilt='', Zoning='' ;

INSERT INTO properties_order SET MLSNumber='392201', sort_order='1', date_added=now(), theStatus='Active', notes='Buck Point 57';

UPDATE properties SET AC='', AllowAVMs='0', Amenities='No Amenities', Appliances='', ApplicationFee='', ApproxHtdSqFt='', ApproximateBoatslipFt='', ApproxLotSize='0.73', Area='Bluffton/Off Plantation', Attic='', Availability='', AvailableDate='', BathsFull='', BathsHalf='', BathsTotal='', BedsTotal='', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Bluffton', CloseDate='2019-04-30', ClosePrice='135000.00', CommunityTourURL='', ConstructionFeatures='', ConstructionStatus='', ConsumerComments='0', CountyOrParish='Beaufort', CtyTaxRecordLivingArea='', ExteriorFeatures='', ExteriorType='', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='', FractionSize='', FractionUsage='', FurnishedYN='', GreenFeatures='', GrossOperatingIncome='', Heat='', IDXOptInYN='1', InteriorFeatures='', Land='', LeaseNetItems='', LeaseType='', LegalAddress='BLUFFTON TOWNSHIP', LegalNumber='1', ListOfficeName='Premier Island Properties', ListPrice='135000.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='', Matrix_Unique_ID='14448217', MatrixModifiedDT='2019-05-29T12:23:00.510', MLS='Hilton Head Island', MLSNumber='392264', ModelNameList='', MonthAvailable='', NetOperatingIncome='', NumAcres='Less than 1/4 Acres', OpenHouseFlags='', Parking='', PetDeposit='', Pets='', PhotoCount='1', PhotoModificationTimestamp='2019-03-23T17:23:51.870', POAFee='No POA fee reported', Pool='', PostalCode='29910', PostalCodePlus4='', PropertyFrontFaces='', PropertySubType='', PropertyType='Land/Lots', PropStatus='', PublicRemarks='Excellent location in Old Town offering convenience to Pritchard Street\'s newly created \"Pocket Park\" and across from the completely renovated Town Center with new landscaping improving the quality of Pritchard Street\'s appearance. Lot can be residential, commercial or mixed use. (Think artist studio & resident - many other usages). Lot size is 9,306 square feet with over 60\' of frontage on Pritchard Street. This is a sought after nicely wooded lot; walk to Old Town, the new Town Hall and MC Reilley. Property backs up to School House Cove ((Heyward Cove) and is considered one (1) of the best streets to build on in OT.', QuarterAvailable='', RegimeFeePerOwner='', Restrictions='No Restrictions', Roof='', Rooms='', Row='', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='', StateOrProvince='South Carolina', Status='Sold', StreetDirPrefix='', StreetDirSuffix='', StreetName='Pritchard Street', StreetNumber='58', StreetNumberNumeric='58', StreetSuffix='', Style='', SubArea='Old Town Bluffton', TermLength='', TotalAcres='', Treatment='', Type='Full Lot', TypeofSpace='', UnbrandedVirtualTourURL='', UnitNumber='', UnitType='', View='Wooded', Water='', WeekAvailable='', Windows='', YearBuilt='', Zoning='' WHERE MLSNumber='392264';

UPDATE properties SET AC='Central', AllowAVMs='0', Amenities='Leisure Trails,Stables', Appliances='Central Vacuum,Convection Oven,Dishwasher,Disposal,Dryer,Ice Machine,Microwave,Oven,Oven Self-Cleaning,Range - Gas,Refrigerator,Washer', ApplicationFee='', ApproxHtdSqFt='2315', ApproximateBoatslipFt='', ApproxLotSize='5.6', Area='Jasper County', Attic='Attic - Insulated,Attic - Walk in', Availability='', AvailableDate='', BathsFull='3', BathsHalf='1', BathsTotal='4.00', BedsTotal='4', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Ridgeland', CloseDate='2019-06-27', ClosePrice='485000.00', CommunityTourURL='', ConstructionFeatures='', ConstructionStatus='Not Applicable', ConsumerComments='0', CountyOrParish='Jasper', CtyTaxRecordLivingArea='2315', ExteriorFeatures='Back Porch,Courtyard,Enclosed Porch,Front Porch,Gutters,Propane Tank - Owned,Satellite Dish,Screened Porch,Screens,Storage Shed', ExteriorType='Composite Siding', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='Carpet,Tile,Wood', FractionSize='', FractionUsage='', FurnishedYN='0', GreenFeatures='None', GrossOperatingIncome='', Heat='Central Heat,Gas', IDXOptInYN='1', InteriorFeatures='Book Shelves,Built-Ins,Ceiling Fan(s),Window Treatments,Fire Alarm,Network Wiring,Security Sys,Smooth Ceilings,Sunken Tub', Land='Horses Allowed,Livestock Allowed,Stables', LeaseNetItems='', LeaseType='', LegalAddress='HONEY HILL', LegalNumber='6', ListOfficeName='Premier Island Properties', ListPrice='499000.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='1st Floor', Matrix_Unique_ID='14492251', MatrixModifiedDT='2019-06-28T10:18:29.213', MLS='Hilton Head Island', MLSNumber='393249', ModelNameList='', MonthAvailable='', NetOperatingIncome='', NumAcres='5 to 10 Acres', OpenHouseFlags='', Parking='Driveway,Garage - 2 Car', PetDeposit='', Pets='', PhotoCount='44', PhotoModificationTimestamp='2019-05-17T15:36:45.570', POAFee='No POA Fee', Pool='None', PostalCode='29936', PostalCodePlus4='', PropertyFrontFaces='West', PropertySubType='', PropertyType='Residential-Single Fam', PropStatus='', PublicRemarks='6+/- acres in the private equestrian estate known as Honey Hill in Ridgeland, SC. Recently built, this exceptional property comes with stables, a barn, and a carriage house over the garage. It is a very special and unique property that offer a wonderful countryside lifestyle to be enjoyed with family and friends. This is definitely a must see property.', QuarterAvailable='', RegimeFeePerOwner='', Restrictions='Pets OK', Roof='Asphalt,Metal', Rooms='Dining Area,Eat-In Kitchen,Foyer Entrance,Garage,Great Room,Kitchen,Laun/Util Rm,Library/Office,Living Room,Pantry,Screen Pat/Por,Storage Room', Row='', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='2315', StateOrProvince='South Carolina', Status='Sold', StreetDirPrefix='', StreetDirSuffix='W', StreetName='Honey Hill', StreetNumber='2099', StreetNumberNumeric='2099', StreetSuffix='CIRCLE', Style='Two Story', SubArea='Ridgeland', TermLength='', TotalAcres='', Treatment='', Type='Full Size', TypeofSpace='', UnbrandedVirtualTourURL='', UnitNumber='', UnitType='', View='Landscape', Water='Septic Tank,Well Water', WeekAvailable='', Windows='Insulated', YearBuilt='2006', Zoning='Rural' WHERE MLSNumber='393249';

UPDATE properties SET AC='', AllowAVMs='1', Amenities='No Amenities', Appliances='', ApplicationFee='', ApproxHtdSqFt='', ApproximateBoatslipFt='', ApproxLotSize='0.2301', Area='Bluffton/Off Plantation', Attic='', Availability='', AvailableDate='', BathsFull='', BathsHalf='', BathsTotal='', BedsTotal='', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Bluffton', CloseDate='2019-08-07', ClosePrice='130000.00', CommunityTourURL='', ConstructionFeatures='', ConstructionStatus='', ConsumerComments='0', CountyOrParish='Beaufort', CtyTaxRecordLivingArea='', ExteriorFeatures='', ExteriorType='', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='', FractionSize='', FractionUsage='', FurnishedYN='', GreenFeatures='', GrossOperatingIncome='', Heat='', IDXOptInYN='1', InteriorFeatures='', Land='', LeaseNetItems='', LeaseType='', LegalAddress='BRIGHTON/PALMETTO BCH', LegalNumber='29', ListOfficeName='Premier Island Properties', ListPrice='130000.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='', Matrix_Unique_ID='14496618', MatrixModifiedDT='2019-08-08T13:03:47.250', MLS='Hilton Head Island', MLSNumber='393356', ModelNameList='', MonthAvailable='', NetOperatingIncome='', NumAcres='1/4 to 1/2 Acre', OpenHouseFlags='', Parking='', PetDeposit='', Pets='', PhotoCount='1', PhotoModificationTimestamp='2019-04-30T15:50:40.323', POAFee='No POA Fee', Pool='', PostalCode='29910', PostalCodePlus4='', PropertyFrontFaces='', PropertySubType='', PropertyType='Land/Lots', PropStatus='', PublicRemarks='Cleared lots on Luray Street. Adjacent lot available.', QuarterAvailable='', RegimeFeePerOwner='', Restrictions='No Restrictions', Roof='', Rooms='', Row='', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='', StateOrProvince='South Carolina', Status='Sold', StreetDirPrefix='', StreetDirSuffix='', StreetName='Luray', StreetNumber='17', StreetNumberNumeric='17', StreetSuffix='STREET', Style='', SubArea='Alljoy Rd Area', TermLength='', TotalAcres='', Treatment='', Type='Double Lot', TypeofSpace='', UnbrandedVirtualTourURL='', UnitNumber='', UnitType='', View='Landscape', Water='', WeekAvailable='', Windows='', YearBuilt='', Zoning='' WHERE MLSNumber='393356';

UPDATE properties SET AC='Central', AllowAVMs='0', Amenities='No Amenities', Appliances='Refrigerator', ApplicationFee='', ApproxHtdSqFt='2156', ApproximateBoatslipFt='', ApproxLotSize='2.47', Area='Bluffton/Off Plantation', Attic='Stairs - Pull Down', Availability='', AvailableDate='', BathsFull='2', BathsHalf='2', BathsTotal='4.00', BedsTotal='3', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Bluffton', CloseDate='', ClosePrice='', CommunityTourURL='', ConstructionFeatures='', ConstructionStatus='Not Applicable', ConsumerComments='0', CountyOrParish='Beaufort', CtyTaxRecordLivingArea='2156', ExteriorFeatures='Back Porch,Deck,Fenced Yard,Front Porch', ExteriorType='Unknown', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='Manufac/Wood', FractionSize='', FractionUsage='', FurnishedYN='0', GreenFeatures='None', GrossOperatingIncome='', Heat='Central Heat', IDXOptInYN='1', InteriorFeatures='Ceiling Fan(s)', Land='Dirt Road,Horses Allowed,Livestock Allowed', LeaseNetItems='', LeaseType='', LegalAddress='PRITCHARD FARMS', LegalNumber='4', ListOfficeName='Premier Island Properties', ListPrice='529900.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='1st Floor', Matrix_Unique_ID='14528242', MatrixModifiedDT='2019-09-26T15:58:02.500', MLS='Hilton Head Island', MLSNumber='394150', ModelNameList='', MonthAvailable='', NetOperatingIncome='', NumAcres='1 to 3 Acres', OpenHouseFlags='', Parking='Driveway', PetDeposit='', Pets='', PhotoCount='31', PhotoModificationTimestamp='2019-05-25T20:12:20.240', POAFee='No POA Fee', Pool='Private', PostalCode='29910', PostalCodePlus4='', PropertyFrontFaces='Unknown', PropertySubType='', PropertyType='Residential-Single Fam', PropStatus='', PublicRemarks='Almost 2.5 acres off May River Road/46 in the quiet neighborhood of Pritchard Farms. No POA/No restrictions. Peek a boo fireplace separates the kitchen and dining area from the living room. Perfect for entertaining with privacy with both front and back porches, and a fenced in pool with a half bath. Lots of yard and storage space.', QuarterAvailable='', RegimeFeePerOwner='', Restrictions='No Restrictions', Roof='Metal', Rooms='Kitchen,Laun/Util Rm,Pantry', Row='', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='2156', StateOrProvince='South Carolina', Status='Active', StreetDirPrefix='', StreetDirSuffix='', StreetName='Pritchard Farms', StreetNumber='94', StreetNumberNumeric='94', StreetSuffix='ROAD', Style='One Story', SubArea='Hwy 46 –May River Side', TermLength='', TotalAcres='', Treatment='', Type='Full Size', TypeofSpace='', UnbrandedVirtualTourURL='https://tour.hiltonheadmls.com/94-Pritchard-Farms-ROAD-Bluffton-SC-29910/unbranded', UnitNumber='', UnitType='', View='Wooded', Water='Private', WeekAvailable='', Windows='Unknown', YearBuilt='1996', Zoning='' WHERE MLSNumber='394150';

UPDATE properties SET AC='Window', AllowAVMs='0', Amenities='No Amenities', Appliances='Dryer,Oven,Washer', ApplicationFee='', ApproxHtdSqFt='1400', ApproximateBoatslipFt='', ApproxLotSize='0.41', Area='Bluffton/Off Plantation', Attic='Attic - Crawl Space', Availability='', AvailableDate='', BathsFull='1', BathsHalf='0', BathsTotal='1.00', BedsTotal='3', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Bluffton', CloseDate='', ClosePrice='', CommunityTourURL='', ConstructionFeatures='', ConstructionStatus='Not Applicable', ConsumerComments='0', CountyOrParish='Beaufort', CtyTaxRecordLivingArea='1400', ExteriorFeatures='Deck,Enclosed Porch', ExteriorType='Block/Stucco', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='Wood', FractionSize='', FractionUsage='', FurnishedYN='0', GreenFeatures='None', GrossOperatingIncome='', Heat='Electric Heat,Window Unit', IDXOptInYN='1', InteriorFeatures='Ceiling Fan(s)', Land='Adjacent Lot Available', LeaseNetItems='', LeaseType='', LegalAddress='SIMMONSVILLE', LegalNumber='91', ListOfficeName='Premier Island Properties', ListPrice='225000.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='1st Floor', Matrix_Unique_ID='14569997', MatrixModifiedDT='2019-06-27T22:37:02.860', MLS='Hilton Head Island', MLSNumber='395014', ModelNameList='', MonthAvailable='', NetOperatingIncome='', NumAcres='Less than 1/4 Acres', OpenHouseFlags='', Parking='Driveway', PetDeposit='', Pets='', PhotoCount='2', PhotoModificationTimestamp='2019-06-27T22:37:02.860', POAFee='No POA fee reported', Pool='None', PostalCode='29910', PostalCodePlus4='', PropertyFrontFaces='South', PropertySubType='', PropertyType='Residential-Single Fam', PropStatus='', PublicRemarks='Great location for a first home. Property sold \"as is, where is\". Excellent opportunity to invest in the fastest growing area of Bluffton. Own 1 or 2 properties 89 and/or 91 Goethe Road off the Parkway. Fix up and rent, use, or resale. Zoned General Residential.', QuarterAvailable='', RegimeFeePerOwner='', Restrictions='Pets OK,No Restrictions', Roof='Asphalt', Rooms='Living Room', Row='', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='1400', StateOrProvince='South Carolina', Status='Active', StreetDirPrefix='', StreetDirSuffix='', StreetName='Goethe', StreetNumber='91', StreetNumberNumeric='91', StreetSuffix='ROAD', Style='One Story', SubArea='Burnt Church to Simmonsville Rd', TermLength='', TotalAcres='', Treatment='', Type='Full Size', TypeofSpace='', UnbrandedVirtualTourURL='', UnitNumber='', UnitType='', View='Wooded', Water='City PSD,Sewer Available', WeekAvailable='', Windows='Unknown', YearBuilt='1984', Zoning='' WHERE MLSNumber='395014';