UPDATE properties SET AC='Central', AllowAVMs='1', Amenities='No Amenities', Appliances='Dishwasher,Dryer,Microwave,Oven,Range,Refrigerator,Washer', ApplicationFee='', ApproxHtdSqFt='1743', ApproximateBoatslipFt='', ApproxLotSize='.67', Area='St. Helena Island', Attic='Stairs - Pull Down', Availability='', AvailableDate='', BathsFull='2', BathsHalf='0', BathsTotal='2.00', BedsTotal='4', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Saint Helena Island', CloseDate='', ClosePrice='', CommunityTourURL='', ConstructionFeatures='', ConstructionStatus='Not Applicable', ConsumerComments='1', CountyOrParish='Beaufort', CtyTaxRecordLivingArea='1743', ExteriorFeatures='Back Porch,Front Porch,Just Painted', ExteriorType='Concrete Block', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='Carpet,Tile', FractionSize='', FractionUsage='', FurnishedYN='0', GreenFeatures='None', GrossOperatingIncome='', Heat='Central Heat', IDXOptInYN='1', InteriorFeatures='Ceiling Fan(s),Fireplace,Just Painted In', Land='', LeaseNetItems='', LeaseType='', LegalAddress='FORT FREMONT S/D', LegalNumber='12-S', ListOfficeName='Engard Real Estate Company', ListPrice='690000.00', Loading='', Location='Sound Front', MaintenanceFee='', MasterBedroom='1st Floor', Matrix_Unique_ID='7196443', MatrixModifiedDT='2019-06-04T12:44:32.480', MLS='Hilton Head Island', MLSNumber='334201', ModelNameList='', MonthAvailable='', NetOperatingIncome='', NumAcres='1/2 to 1 Acre', OpenHouseFlags='', Parking='Garage - 1 Car,Garage - Detached', PetDeposit='', Pets='', PhotoCount='14', PhotoModificationTimestamp='2016-12-28T15:05:09.693', POAFee='No POA fee reported', Pool='None', PostalCode='29920', PostalCodePlus4='', PropertyFrontFaces='West', PropertySubType='', PropertyType='Residential-Single Fam', PropStatus='', PublicRemarks='Deep water homesite. 4 Bedrooms, 2 Baths. Home was updated in 2014 with new kitchen appliances, windows, heating and A/C, new metal roof, and detached garage. Views of Port Royal Sound are Magnificent! Deep water dock permit in hand. This property is one site over from Fort Freemont at Lands End.', QuarterAvailable='', RegimeFeePerOwner='', Restrictions='Community Covs and Restricts Apply', Roof='Metal,Tin', Rooms='Carolina Room,Dining Room', Row='', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='1743', StateOrProvince='South Carolina', Status='Active', StreetDirPrefix='', StreetDirSuffix='', StreetName='Bay Point', StreetNumber='175', StreetNumberNumeric='175', StreetSuffix='ROAD', Style='One Story', SubArea='St. Helena Island', TermLength='', TotalAcres='', Treatment='', Type='Full Size', TypeofSpace='', UnbrandedVirtualTourURL='http://tour.hiltonheadmls.com/175-Bay-Point-ROAD-Saint-Helena-Island-SC-29920/unbranded', UnitNumber='', UnitType='', View='Deep Water', Water='Public Water Available,Septic Tank,Well Water', WeekAvailable='', Windows='Unknown', YearBuilt='1950', Zoning='Residential' WHERE MLSNumber='334201';

UPDATE properties SET AC='', AllowAVMs='0', Amenities='Community Pool,Tennis,Fitness Facility', Appliances='', ApplicationFee='', ApproxHtdSqFt='', ApproximateBoatslipFt='', ApproxLotSize='0.52', Area='Hampton Hall', Attic='', Availability='', AvailableDate='', BathsFull='', BathsHalf='', BathsTotal='', BedsTotal='', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Bluffton', CloseDate='2017-11-15', ClosePrice='60000.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='HAMPTON HALL', LegalNumber='780', ListOfficeName='Engard Real Estate Company ', ListPrice='82500.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='', Matrix_Unique_ID='10312084', MatrixModifiedDT='2017-11-16T11:47:14.997', MLS='Hilton Head Island', MLSNumber='354109', ModelNameList='', MonthAvailable='', NetOperatingIncome='', NumAcres='1/4 to 1/2 Acre', OpenHouseFlags='', Parking='', PetDeposit='', Pets='', PhotoCount='13', PhotoModificationTimestamp='2016-12-28T14:56:54.963', POAFee='Hampton Hall I $3972', Pool='', PostalCode='29910', PostalCodePlus4='', PropertyFrontFaces='', PropertySubType='', PropertyType='Land/Lots', PropStatus='', PublicRemarks='Private estate home-site at end of Marchmont Avenue with privacy and views of 9th fairway, practice facility and golf club house.', 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='Marchmont', StreetNumber='15', StreetNumberNumeric='15', StreetSuffix='AVENUE', Style='', SubArea='Hampton Hall', TermLength='', TotalAcres='', Treatment='', Type='Full Lot', TypeofSpace='', UnbrandedVirtualTourURL='', UnitNumber='', UnitType='', View='Golf,Wooded', Water='', WeekAvailable='', Windows='', YearBuilt='', Zoning='' WHERE MLSNumber='354109';

UPDATE properties SET AC='Central', AllowAVMs='1', Amenities='Clubhouse,Community Pool,Fitness Facility', Appliances='Dishwasher,Disposal,Dryer,Microwave,Oven,Oven Self-Cleaning,Range,Refrigerator,Washer', ApplicationFee='', ApproxHtdSqFt='1020', ApproximateBoatslipFt='', ApproxLotSize='0.14', Area='Bluffton/Off Plantation', Attic='Unfinished', Availability='', AvailableDate='', BathsFull='2', BathsHalf='1', BathsTotal='3.00', BedsTotal='3', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Okatie', CloseDate='', ClosePrice='', CommunityTourURL='', ConstructionFeatures='', ConstructionStatus='Not Applicable', ConsumerComments='0', CountyOrParish='Beaufort', CtyTaxRecordLivingArea='1020', ExteriorFeatures='Patio,Paved Drive', ExteriorType='Vinyl Siding', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='Carpet,Manufac/Wood', FractionSize='', FractionUsage='', FurnishedYN='0', GreenFeatures='None', GrossOperatingIncome='', Heat='Central Heat,Heat Pump', IDXOptInYN='1', InteriorFeatures='Just Painted In,Many Closets', Land='', LeaseNetItems='', LeaseType='', LegalAddress='UNIVERSITY PARK', LegalNumber='151', ListOfficeName='Engard Real Estate Company', ListPrice='199500.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='2nd Floor', Matrix_Unique_ID='10711667', MatrixModifiedDT='2019-08-30T12:14:24.047', MLS='Hilton Head Island', MLSNumber='371980', ModelNameList='', MonthAvailable='', NetOperatingIncome='', NumAcres='Less than 1/4 Acres', OpenHouseFlags='', Parking='Garage - 2 Car', PetDeposit='', Pets='', PhotoCount='7', PhotoModificationTimestamp='2017-10-24T10:05:13.623', POAFee='University Park $1260', Pool='Community', PostalCode='29909', PostalCodePlus4='', PropertyFrontFaces='East', PropertySubType='', PropertyType='Residential-Single Fam', PropStatus='', PublicRemarks='Newly painted, landscaped, new hardwood floors downstairs and new carpet upstairs. 3 Br, 2 1/2 BA, 2 car detached garage. Front porch overlooks wooded land. Easily accessible to all amenities of the community, pool, workout room. Walmart and Publix across the street as well as University of SC, Beaufort campus. Property across the street not to be developed.', QuarterAvailable='', RegimeFeePerOwner='', Restrictions='No Restrictions', Roof='Asphalt', Rooms='Dining Room,Kitchen,Laun/Util Rm,Living Room,Pantry', Row='', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='1020', StateOrProvince='South Carolina', Status='Active', StreetDirPrefix='', StreetDirSuffix='', StreetName='Southside', StreetNumber='138', StreetNumberNumeric='138', StreetSuffix='PARKWAY', Style='Two Story', SubArea='University Park', TermLength='Long Term', TotalAcres='', Treatment='', Type='Full Size', TypeofSpace='', UnbrandedVirtualTourURL='http://tour.hiltonheadmls.com/138-Southside-PARKWAY-Okatie-SC-29909/unbranded', UnitNumber='', UnitType='', View='Wooded', Water='City PSD', WeekAvailable='', Windows='Unknown', YearBuilt='2005', Zoning='Residential' WHERE MLSNumber='371980';

UPDATE properties SET AC='Central', AllowAVMs='1', Amenities='No Amenities', Appliances='Range - Gas', ApplicationFee='', ApproxHtdSqFt='1774', ApproximateBoatslipFt='', ApproxLotSize='0.3691', Area='Bluffton/Off Plantation', Attic='Attic - Crawl Space', Availability='', AvailableDate='', BathsFull='2', BathsHalf='1', BathsTotal='3.00', BedsTotal='3', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Bluffton', CloseDate='2018-09-11', ClosePrice='210000.00', CommunityTourURL='', ConstructionFeatures='', ConstructionStatus='Not Applicable', ConsumerComments='0', CountyOrParish='Beaufort', CtyTaxRecordLivingArea='1488', ExteriorFeatures='Back Porch,Enclosed Porch,Storage Shed', ExteriorType='Vinyl Siding', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='Carpet,Vinyl,Wood', FractionSize='', FractionUsage='', FurnishedYN='0', GreenFeatures='Unknown', GrossOperatingIncome='', Heat='Heat Pump', IDXOptInYN='1', InteriorFeatures='Cable TV', Land='', LeaseNetItems='', LeaseType='', LegalAddress='MYRTLE ISLAND', LegalNumber='C-3', ListOfficeName='Engard Real Estate Company', ListPrice='235000.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='1st Floor', Matrix_Unique_ID='10718552', MatrixModifiedDT='2019-02-22T12:02:51.747', MLS='Hilton Head Island', MLSNumber='372153', ModelNameList='Bluffton Cottage', MonthAvailable='', NetOperatingIncome='', NumAcres='1/4 to 1/2 Acre', OpenHouseFlags='', Parking='Unassigned Parking', PetDeposit='', Pets='', PhotoCount='11', PhotoModificationTimestamp='2017-10-31T14:37:44.247', POAFee='No POA fee reported', Pool='None', PostalCode='29910', PostalCodePlus4='', PropertyFrontFaces='NorthWest', PropertySubType='', PropertyType='Residential-Single Fam', PropStatus='', PublicRemarks='Bluffton cottage. Living all on one floor with steps down to the kitchen. 3BR, 2 1/2 BA on desirable Myrtle Island Road. Beautiful homesite, 1940 home with a lot of character. No property or lead based paint known. Purchaser to be aware of age of home and obtain inspections as it relates to property.', QuarterAvailable='', RegimeFeePerOwner='', Restrictions='Motorcycles Allowed', Roof='Metal', Rooms='Dining Area,Foyer Entrance,Kitchen,Laun/Util Rm,Storage Room', Row='Over 12', SecurityDeposit='', Size='', SpecialCircumstances='Real Estate Owned,Not Applicable', SqFtTotal='1774', StateOrProvince='South Carolina', Status='Sold', StreetDirPrefix='', StreetDirSuffix='', StreetName='Myrtle Island', StreetNumber='11', StreetNumberNumeric='11', StreetSuffix='ROAD', Style='1st Floor On Grade', SubArea='Alljoy Rd Area', TermLength='', TotalAcres='', Treatment='', Type='Full Size', TypeofSpace='', UnbrandedVirtualTourURL='', UnitNumber='', UnitType='', View='Wooded', Water='City PSD,Septic Tank', WeekAvailable='', Windows='Not Applicable', YearBuilt='1940', Zoning='Residential' WHERE MLSNumber='372153';

UPDATE properties SET AC='', AllowAVMs='1', Amenities='Clubhouse,Community Pool,Tennis,Fitness Facility,Golf Privileges,Sec Gate/Guard', Appliances='', ApplicationFee='', ApproxHtdSqFt='', ApproximateBoatslipFt='', ApproxLotSize='0.36', Area='Hampton Hall', Attic='', Availability='', AvailableDate='', BathsFull='', BathsHalf='', BathsTotal='', BedsTotal='', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Bluffton', CloseDate='2018-01-25', ClosePrice='80900.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='HAMPTON HALL', LegalNumber='369', ListOfficeName='Engard Real Estate Company', ListPrice='87500.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='', Matrix_Unique_ID='10772165', MatrixModifiedDT='2018-01-26T10:50:58.113', MLS='Hilton Head Island', MLSNumber='374451', ModelNameList='', MonthAvailable='', NetOperatingIncome='', NumAcres='1/4 to 1/2 Acre', OpenHouseFlags='', Parking='', PetDeposit='', Pets='', PhotoCount='4', PhotoModificationTimestamp='2018-01-12T11:23:38.897', POAFee='Hampton Hall U $3163.20', Pool='', PostalCode='29910', PostalCodePlus4='', PropertyFrontFaces='', PropertySubType='', PropertyType='Land/Lots', PropStatus='', PublicRemarks='Fabulous homesite with the best view of the big lagoon at Hampton Hall. Build your personal residence on this outstanding homesite.', 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='Farnsleigh', StreetNumber='70', StreetNumberNumeric='70', StreetSuffix='AVENUE', Style='', SubArea='Hampton Hall', TermLength='', TotalAcres='', Treatment='', Type='Full Lot', TypeofSpace='', UnbrandedVirtualTourURL='', UnitNumber='', UnitType='', View='Lagoon', Water='City PSD', WeekAvailable='', Windows='', YearBuilt='', Zoning='Residential' WHERE MLSNumber='374451';

UPDATE properties SET AC='Central,Electric', AllowAVMs='0', Amenities='Fitness Facility,Garbage Service Included,Pest Control,Pool Outdoor,Sec Gate/Guard', Appliances='Dishwasher,Disposal,Dryer,Microwave,Washer', ApplicationFee='', ApproxHtdSqFt='1076', ApproximateBoatslipFt='', ApproxLotSize='', Area='Bluffton/Off Plantation', Attic='Unknown', Availability='', AvailableDate='', BathsFull='2', BathsHalf='0', BathsTotal='2.00', BedsTotal='2', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Bluffton', CloseDate='2018-09-10', ClosePrice='121250.00', CommunityTourURL='', ConstructionFeatures='', ConstructionStatus='Not Applicable', ConsumerComments='0', CountyOrParish='Beaufort', CtyTaxRecordLivingArea='1076', ExteriorFeatures='End Unit,Front Porch,Irri System', ExteriorType='Block/Stucco', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='Carpet,Vinyl', FractionSize='', FractionUsage='', FurnishedYN='0', GreenFeatures='Unknown', GrossOperatingIncome='', Heat='Electric Heat', IDXOptInYN='1', InteriorFeatures='Cable TV,Ceiling Fan(s),Smooth Ceilings', Land='', LeaseNetItems='', LeaseType='', LegalAddress='PLANTATION POINT', LegalNumber='2007', ListOfficeName='Engard Real Estate Company', ListPrice='119900.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='2nd Floor', Matrix_Unique_ID='10874190', MatrixModifiedDT='2018-10-20T17:41:33.287', MLS='Hilton Head Island', MLSNumber='378599', ModelNameList='', MonthAvailable='', NetOperatingIncome='', NumAcres='', OpenHouseFlags='', Parking='Unassigned Parking', PetDeposit='', Pets='Dogs Weight Restricted,Leash Law,Renter Yes', PhotoCount='10', PhotoModificationTimestamp='2018-04-16T14:19:02.813', POAFee='No POA fee reported', Pool='Above Ground,Community,Unheated', PostalCode='29910', PostalCodePlus4='', PropertyFrontFaces='Unknown', PropertySubType='', PropertyType='Villas/Condos', PropStatus='', PublicRemarks='Highly desirable 2nd floor, 2 bedroom, 2 bath with vaulted ceilings. All Appliances and private balcony.', QuarterAvailable='', RegimeFeePerOwner='222.62', Restrictions='Community Covs and Restricts Apply,Pets-Owners Only', Roof='Asphalt', Rooms='Dining Area,Foyer Entrance,Kitchen,Laun/Util Rm,Living Room,Pantry', Row='', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='1076', StateOrProvince='South Carolina', Status='Sold', StreetDirPrefix='', StreetDirSuffix='', StreetName='Fording Island', StreetNumber='897', StreetNumberNumeric='897', StreetSuffix='ROAD', Style='', SubArea='Burnt Church to Simmonsville Rd', TermLength='Long Term', TotalAcres='', Treatment='', Type='Townhouse/Multi-level', TypeofSpace='', UnbrandedVirtualTourURL='', UnitNumber='2007', UnitType='', View='Wooded', Water='City PSD', WeekAvailable='', Windows='Insulated', YearBuilt='1997', Zoning='' WHERE MLSNumber='378599';

UPDATE properties SET AC='Central,Electric,Heat Pump', AllowAVMs='0', Amenities='Community Pool,Fitness Facility', Appliances='Dishwasher,Disposal,Dryer,Microwave,Outdoor Grill,Oven,Oven Self-Cleaning,Range,Refrigerator,Washer', ApplicationFee='', ApproxHtdSqFt='1120', ApproximateBoatslipFt='', ApproxLotSize='0.13', Area='Bluffton/Off Plantation', Attic='Unknown', Availability='', AvailableDate='', BathsFull='2', BathsHalf='1', BathsTotal='3.00', BedsTotal='3', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Okatie', CloseDate='2018-12-27', ClosePrice='165250.00', CommunityTourURL='', ConstructionFeatures='', ConstructionStatus='Not Applicable', ConsumerComments='0', CountyOrParish='Beaufort', CtyTaxRecordLivingArea='1120', ExteriorFeatures='Courtyard,Fence-Privacy,Front Porch,Irri System,Patio,Paved Drive,Screens', ExteriorType='Vinyl Siding', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='Carpet,Tile', FractionSize='', FractionUsage='', FurnishedYN='0', GreenFeatures='Energy Star Home', GrossOperatingIncome='', Heat='Central Heat,Electric Heat,Heat Pump', IDXOptInYN='1', InteriorFeatures='Cable TV,Ceiling Fan(s),Fireplace,Smoke Alarm', Land='', LeaseNetItems='', LeaseType='', LegalAddress='UNIVERSITY PARK', LegalNumber='247', ListOfficeName='Engard Real Estate Company', ListPrice='169500.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='2nd Floor', Matrix_Unique_ID='10910856', MatrixModifiedDT='2019-01-02T13:26:38.967', MLS='Hilton Head Island', MLSNumber='379331', ModelNameList='', MonthAvailable='', NetOperatingIncome='', NumAcres='Less than 1/4 Acres', OpenHouseFlags='', Parking='Driveway', PetDeposit='', Pets='', PhotoCount='12', PhotoModificationTimestamp='2018-04-27T17:05:36.473', POAFee='University Park $1260', Pool='Community,Enclosed', PostalCode='29909', PostalCodePlus4='', PropertyFrontFaces='East', PropertySubType='', PropertyType='Residential-Single Fam', PropStatus='', PublicRemarks='Enjoy the sunrise with coffee or a Bloody Mary on the private porch off the upstairs master suite. Fireplace in living space with lots of windows. Tile flooring on entire 1st floor; perfect for pets and plants! Check out the private pool and workout room!', QuarterAvailable='', RegimeFeePerOwner='', Restrictions='No Restrictions', Roof='Asphalt', Rooms='Dining Room,Kitchen,Laun/Util Rm,Living Room', Row='', SecurityDeposit='', Size='', SpecialCircumstances='Real Estate Owned', SqFtTotal='1120', StateOrProvince='South Carolina', Status='Sold', StreetDirPrefix='', StreetDirSuffix='', StreetName='Student Union', StreetNumber='205', StreetNumberNumeric='205', StreetSuffix='STREET', Style='Two Story', SubArea='University Park', TermLength='Short Term', TotalAcres='', Treatment='', Type='Full Size', TypeofSpace='', UnbrandedVirtualTourURL='', UnitNumber='', UnitType='', View='Landscape,Wooded', Water='City PSD', WeekAvailable='', Windows='Insulated', YearBuilt='2006', Zoning='' WHERE MLSNumber='379331';

UPDATE properties SET AC='Central,Electric,Heat Pump', AllowAVMs='0', Amenities='No Amenities', Appliances='Dishwasher,Disposal,Microwave,Oven Self-Cleaning,Range,Refrigerator', ApplicationFee='', ApproxHtdSqFt='1378', ApproximateBoatslipFt='', ApproxLotSize='0.18', Area='Bluffton/Off Plantation', Attic='Attic - Insulated,Attic - Partially Floored,Stairs - Pull Down', Availability='', AvailableDate='', BathsFull='2', BathsHalf='0', BathsTotal='2.00', BedsTotal='3', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Okatie', CloseDate='2019-01-31', ClosePrice='201500.00', CommunityTourURL='', ConstructionFeatures='', ConstructionStatus='Not Applicable', ConsumerComments='0', CountyOrParish='Beaufort', CtyTaxRecordLivingArea='1228', ExteriorFeatures='Fence-Privacy,Patio,Paved Drive', ExteriorType='Vinyl Siding', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='Carpet,Manufac/Wood,Tile', FractionSize='', FractionUsage='', FurnishedYN='0', GreenFeatures='Unknown', GrossOperatingIncome='', Heat='Central Heat,Electric Heat', IDXOptInYN='1', InteriorFeatures='Cathedral Ceilings,Ceiling Fan(s),Window Treatments,Fireplace,Security Sys,Smoke Alarm', Land='Cul-de-Sac Street', LeaseNetItems='', LeaseType='', LegalAddress='RIVERS END', LegalNumber='54', ListOfficeName='Engard Real Estate Company', ListPrice='209500.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='1st Floor', Matrix_Unique_ID='10953938', MatrixModifiedDT='2019-02-14T15:51:20.800', MLS='Hilton Head Island', MLSNumber='381302', ModelNameList='', MonthAvailable='', NetOperatingIncome='', NumAcres='1/4 to 1/2 Acre', OpenHouseFlags='', Parking='Garage - 2 Car', PetDeposit='', Pets='', PhotoCount='11', PhotoModificationTimestamp='2018-05-16T17:05:59.690', POAFee='No POA fee reported', Pool='None', PostalCode='29909', PostalCodePlus4='', PropertyFrontFaces='East', PropertySubType='', PropertyType='Residential-Single Fam', PropStatus='', PublicRemarks='Home all on one floor, is ready to move in with great location for families on cul-de-sac street in Rivers End. Fireplace, vaulted ceiling in living room, hardwood veneer flooring, tile in bathrooms. Double vanity, granite tops, and TV in Master Bath. Large Master closet, ceiling fans in living room, master bedroom, bedroom #2. Enclosed sun room with split HVAC system. Outside fire pit, nicely landscaped with beautiful trees and privacy fencing in back and side yards. Come see!', QuarterAvailable='', RegimeFeePerOwner='', Restrictions='Motorcycles Allowed,Pets OK', Roof='Asphalt', Rooms='Carolina Room,Dining Area,Foyer Entrance,Garage,Great Room,Kitchen,Living Room', Row='', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='1378', StateOrProvince='South Carolina', Status='Sold', StreetDirPrefix='', StreetDirSuffix='', StreetName='Capers Creek', StreetNumber='5', StreetNumberNumeric='5', StreetSuffix='DRIVE', Style='1st Floor On Grade,One Story', SubArea='170 North to Oldfield', TermLength='', TotalAcres='', Treatment='', Type='Full Size', TypeofSpace='', UnbrandedVirtualTourURL='', UnitNumber='', UnitType='', View='Landscape', Water='City PSD', WeekAvailable='', Windows='Insulated', YearBuilt='2000', Zoning='' WHERE MLSNumber='381302';

UPDATE properties SET AC='Central,Heat Pump,Wall', AllowAVMs='0', Amenities='No Amenities', Appliances='Convection Oven,Dishwasher,Disposal,Dryer,Freezer,Ice Machine,Microwave,Oven Self-Cleaning,Range - Gas,Refrigerator,Washer,Wine Cooler', ApplicationFee='', ApproxHtdSqFt='3110', ApproximateBoatslipFt='', ApproxLotSize='0.55', Area='Bluffton/Off Plantation', Attic='Attic - Floored,Attic - Insulated,Attic - Walk in', Availability='', AvailableDate='', BathsFull='3', BathsHalf='1', BathsTotal='4.00', BedsTotal='4', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Bluffton', CloseDate='2018-10-26', ClosePrice='589500.00', CommunityTourURL='', ConstructionFeatures='', ConstructionStatus='Not Applicable', ConsumerComments='0', CountyOrParish='Beaufort', CtyTaxRecordLivingArea='128000', ExteriorFeatures='Front Porch,Irri System,Patio,Propane Tank - In Ground,Satellite Dish,Screens,Tankless Water Heater', ExteriorType='Board/Batten,Composite Siding', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='Pine,Tile,Wood', FractionSize='', FractionUsage='', FurnishedYN='0', GreenFeatures='Spray Foam Insulation,Tankless Water Heater', GrossOperatingIncome='', Heat='Central Heat,Electric Heat,Wall Unit', IDXOptInYN='1', InteriorFeatures='Cathedral Ceilings,Ceiling Fan(s),Fireplace,Separate Shower,Smoke Alarm,Smooth Ceilings,Tankless Water Heater', Land='Corner Lot', LeaseNetItems='', LeaseType='', LegalAddress='EST OF C W HARPER S/D', LegalNumber='3', ListOfficeName='Engard Real Estate Company', ListPrice='625500.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='1st Floor', Matrix_Unique_ID='13904390', MatrixModifiedDT='2018-11-02T13:09:00.867', MLS='Hilton Head Island', MLSNumber='385701', ModelNameList='', MonthAvailable='', NetOperatingIncome='', NumAcres='1/2 to 1 Acre', OpenHouseFlags='', Parking='Garage - 2 Car,Garage - Detached', PetDeposit='', Pets='', PhotoCount='37', PhotoModificationTimestamp='2018-08-17T20:18:08.637', POAFee='No POA fee reported', Pool='None', PostalCode='29910', PostalCodePlus4='', PropertyFrontFaces='West', PropertySubType='', PropertyType='Residential-Single Fam', PropStatus='', PublicRemarks='One-of-a-kind 3105 sq.ft. home on .55 acres; entry gas lanterns, wrap-around front & side porches, metal roof; 4 BR, 3 1/2 BA includes 1BR/1BA apt above 30\'X25\', over-sized 2-car garage w/built-in workshop space; reclaimed heart pine & custom tile flooring;100-yr old brick fireplace surround; Kitchen: tin ceiling, farmhouse sink, 6 burner gas convection range, heart pine island, quartz counter tops, reclaimed early 1900s drugstore storage w/glass fronts; 8\' solid core & barn doors, 10\' & vaulted ceilings; Master BA claw foot tub, dual sinks, 8\' walk-in shower; spray foam insulation, tank-less water heater, 150 gal in-ground propane tank', QuarterAvailable='', RegimeFeePerOwner='', Restrictions='Motorcycles Allowed,Pets OK,No Restrictions', Roof='Metal', Rooms='Dining Area,Eat-In Kitchen,Garage,Great Room,In-Law Suite,Kitchen,Laun/Util Rm,Storage Room', Row='', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='3110', StateOrProvince='South Carolina', Status='Sold', StreetDirPrefix='', StreetDirSuffix='', StreetName='River Oaks', StreetNumber='4', StreetNumberNumeric='4', StreetSuffix='DRIVE', Style='1st Elevated,Two Story', SubArea='Alljoy Rd Area', TermLength='', TotalAcres='', Treatment='', Type='Full Size', TypeofSpace='', UnbrandedVirtualTourURL='', UnitNumber='', UnitType='', View='Wooded', Water='City PSD,Septic Tank', WeekAvailable='', Windows='Insulated,Tinted', YearBuilt='2017', Zoning='' WHERE MLSNumber='385701';

UPDATE properties SET AC='', AllowAVMs='0', Amenities='No Amenities', Appliances='', ApplicationFee='', ApproxHtdSqFt='', ApproximateBoatslipFt='', ApproxLotSize='3.31', 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='Unknown', GrossOperatingIncome='', Heat='', IDXOptInYN='1', InteriorFeatures='', Land='Can Be Subdivided', LeaseNetItems='', LeaseType='', LegalAddress='BUCK ISLAND', LegalNumber='15c', ListOfficeName='Engard Real Estate Company', ListPrice='349500.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='', Matrix_Unique_ID='14363255', MatrixModifiedDT='2019-09-11T16:22:39.940', MLS='Hilton Head Island', MLSNumber='389437', ModelNameList='', MonthAvailable='', NetOperatingIncome='', NumAcres='3 to 5 Acres', OpenHouseFlags='', Parking='', PetDeposit='', Pets='', PhotoCount='15', PhotoModificationTimestamp='2019-05-23T12:01:43.937', POAFee='No POA fee reported', Pool='', PostalCode='29910', PostalCodePlus4='', PropertyFrontFaces='', PropertySubType='', PropertyType='Land/Lots', PropStatus='', PublicRemarks='3.1 acres to develop, zoned - 4 units per acre, water and sewer. Views of Pine Crest Golf Course at back of property. Or buy and place your home on property with privacy and roam your acreage. Heavily wooded.', QuarterAvailable='', RegimeFeePerOwner='', Restrictions='No Restrictions', Roof='', Rooms='', Row='', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='', StateOrProvince='South Carolina', Status='Active', StreetDirPrefix='', StreetDirSuffix='', StreetName='Buck Island', StreetNumber='262', StreetNumberNumeric='262', StreetSuffix='ROAD', Style='', SubArea='Simmonsville Rd to Buckwalter', TermLength='', TotalAcres='', Treatment='', Type='Acreage', TypeofSpace='', UnbrandedVirtualTourURL='https://tour.hiltonheadmls.com/262-Buck-Island-ROAD-Bluffton-SC-29910/unbranded', UnitNumber='', UnitType='', View='Landscape,Wooded', Water='City PSD', WeekAvailable='', Windows='', YearBuilt='', Zoning='Residential' WHERE MLSNumber='389437';

UPDATE properties SET AC='', AllowAVMs='0', Amenities='No Amenities', Appliances='', ApplicationFee='', ApproxHtdSqFt='', ApproximateBoatslipFt='', ApproxLotSize='41.16', 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='Can Be Subdivided', LeaseNetItems='', LeaseType='', LegalAddress='TOWN OF BLUFFTON', LegalNumber='Lot A', ListOfficeName='Engard Real Estate Company', ListPrice='2900000.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='', Matrix_Unique_ID='14398277', MatrixModifiedDT='2019-05-23T15:09:49.930', MLS='Hilton Head Island', MLSNumber='390439', ModelNameList='', MonthAvailable='', NetOperatingIncome='', NumAcres='20 to 50 Acres', OpenHouseFlags='', Parking='', PetDeposit='', Pets='', PhotoCount='4', PhotoModificationTimestamp='2019-05-23T15:09:49.930', POAFee='No POA fee reported', Pool='', PostalCode='29910', PostalCodePlus4='', PropertyFrontFaces='', PropertySubType='', PropertyType='Land/Lots', PropStatus='', PublicRemarks='41.16 gross acres which buyer will pay $100,000/acre for buildable acreage', QuarterAvailable='', RegimeFeePerOwner='', Restrictions='No Restrictions', Roof='', Rooms='', Row='', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='', StateOrProvince='South Carolina', Status='Active', StreetDirPrefix='', StreetDirSuffix='', StreetName='Ulmer', StreetNumber='34', StreetNumberNumeric='34', StreetSuffix='ROAD', Style='', SubArea='Alljoy Rd Area', TermLength='', TotalAcres='', Treatment='', Type='Acreage', TypeofSpace='', UnbrandedVirtualTourURL='https://tour.hiltonheadmls.com/34-Ulmer-ROAD-Bluffton-SC-29910/unbranded', UnitNumber='', UnitType='', View='Wooded', Water='', WeekAvailable='', Windows='', YearBuilt='', Zoning='' WHERE MLSNumber='390439';

UPDATE properties SET AC='', AllowAVMs='0', Amenities='Clubhouse,Golf Privileges,Leisure Trails,Marina,Sec Gate/Guard,Stables', Appliances='', ApplicationFee='', ApproxHtdSqFt='', ApproximateBoatslipFt='', ApproxLotSize='0.4', Area='Sea Pines', Attic='', Availability='', AvailableDate='', BathsFull='', BathsHalf='', BathsTotal='', BedsTotal='', Building='', BusinessType='', CeilingHeight='', CheckIn='', City='Hilton Head Island', 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='HARLESTON GREEN', LegalNumber='229', ListOfficeName='Engard Real Estate Company', ListPrice='699500.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='', Matrix_Unique_ID='14498268', MatrixModifiedDT='2019-07-15T12:58:13.153', MLS='Hilton Head Island', MLSNumber='393388', ModelNameList='', MonthAvailable='', NetOperatingIncome='', NumAcres='1/4 to 1/2 Acre', OpenHouseFlags='', Parking='', PetDeposit='', Pets='', PhotoCount='32', PhotoModificationTimestamp='2019-07-15T12:58:13.153', POAFee='Sea Pines U $641', Pool='', PostalCode='29928', PostalCodePlus4='', PropertyFrontFaces='', PropertySubType='', PropertyType='Land/Lots', PropStatus='', PublicRemarks='Gorgeous homesite on private Harleston Green Road between 5th Green and 6th Tee and long views of the 6th Fairway on Harbor Town Course. Last buildable site in this area. Existing homes on right and left of homesite.', QuarterAvailable='', RegimeFeePerOwner='', Restrictions='Community Covs and Restricts Apply,No Motorcycles', Roof='', Rooms='', Row='Over 12', SecurityDeposit='', Size='', SpecialCircumstances='Not Applicable', SqFtTotal='', StateOrProvince='South Carolina', Status='Active', StreetDirPrefix='', StreetDirSuffix='', StreetName='Harleston Green', StreetNumber='28', StreetNumberNumeric='28', StreetSuffix='ROAD', Style='', SubArea='Harbour Town', TermLength='', TotalAcres='', Treatment='', Type='Full Lot', TypeofSpace='', UnbrandedVirtualTourURL='https://tour.hiltonheadmls.com/28-Harleston-Green-ROAD-Hilton-Head-Island-SC-29928/unbranded', UnitNumber='', UnitType='', View='Golf', Water='City PSD,Sewer Available', WeekAvailable='', Windows='', YearBuilt='', Zoning='' WHERE MLSNumber='393388';

UPDATE properties SET AC='', AllowAVMs='0', Amenities='Clubhouse,Community Pool,Tennis,Fitness Facility,Golf Privileges,Sec Gate/Guard', Appliances='', ApplicationFee='', ApproxHtdSqFt='', ApproximateBoatslipFt='', ApproxLotSize='0.39', Area='Hampton Hall', 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='HAMPTON HALL', LegalNumber='484', ListOfficeName='Engard Real Estate Company', ListPrice='135500.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='', Matrix_Unique_ID='14498297', MatrixModifiedDT='2019-05-21T11:22:24.317', MLS='Hilton Head Island', MLSNumber='393395', ModelNameList='', MonthAvailable='', NetOperatingIncome='', NumAcres='1/4 to 1/2 Acre', OpenHouseFlags='', Parking='', PetDeposit='', Pets='', PhotoCount='35', PhotoModificationTimestamp='2019-05-13T12:46:58.830', POAFee='Hampton Hall U $3163.20', Pool='', PostalCode='29910', PostalCodePlus4='', PropertyFrontFaces='', PropertySubType='', PropertyType='Land/Lots', PropStatus='', PublicRemarks='Enjoy Hampton Hall the best around with huge fitness center, indoor and outdoor pools, championship tennis. Award Winning Pete Dye Golf Course par 3 #14 with big lagoon and water views of tee to green and beyond. Postcard picture. All that is missing is your buyer. If you love golf and water, this is the homesite for you.\r\n\r\nHampton Hall has a $6,000 transfer fee paid by the purchaser plus $810 working capital fund. Golf membership is not required but social membership is.', QuarterAvailable='', RegimeFeePerOwner='', Restrictions='Community Covs and Restricts Apply', Roof='', Rooms='', Row='', SecurityDeposit='', Size='', SpecialCircumstances='Real Estate Owned', SqFtTotal='', StateOrProvince='South Carolina', Status='Active', StreetDirPrefix='', StreetDirSuffix='', StreetName='Farnsleigh', StreetNumber='288', StreetNumberNumeric='288', StreetSuffix='AVENUE', Style='', SubArea='Hampton Hall', TermLength='', TotalAcres='', Treatment='', Type='Full Lot', TypeofSpace='', UnbrandedVirtualTourURL='https://tour.hiltonheadmls.com/288-Farnsleigh-AVENUE-Bluffton-SC-29910/unbranded', UnitNumber='', UnitType='', View='Golf,Lagoon', Water='City PSD,Sewer Available', WeekAvailable='', Windows='', YearBuilt='', Zoning='' WHERE MLSNumber='393395';

UPDATE properties SET AC='', AllowAVMs='0', Amenities='', Appliances='', ApplicationFee='', ApproxHtdSqFt='', ApproximateBoatslipFt='', ApproxLotSize='0.36', 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='', ExteriorFeatures='', ExteriorType='', FixedWeeksYN='', FixturesEquipment='', FloatingWeeksYN='', FloorPlanName='', Floors='', FractionSize='', FractionUsage='', FurnishedYN='', GreenFeatures='', GrossOperatingIncome='', Heat='', IDXOptInYN='1', InteriorFeatures='', Land='', LeaseNetItems='', LeaseType='', LegalAddress='COMM ACREAGE', LegalNumber='49', ListOfficeName='Engard Real Estate Company', ListPrice='750000.00', Loading='', Location='', MaintenanceFee='', MasterBedroom='', Matrix_Unique_ID='14512528', MatrixModifiedDT='2019-08-16T14:25:29.783', MLS='Hilton Head Island', MLSNumber='393796', ModelNameList='', MonthAvailable='', NetOperatingIncome='', NumAcres='', OpenHouseFlags='', Parking='', PetDeposit='', Pets='', PhotoCount='26', PhotoModificationTimestamp='2019-05-21T13:39:51.370', POAFee='', Pool='', PostalCode='29928', PostalCodePlus4='', PropertyFrontFaces='', PropertySubType='', PropertyType='Commercial', PropStatus='', PublicRemarks='The last available double site with sewer, water, underground utilities on New Orleans Road. .93 Acres. A 10,000 square foot building with a 2,000 square foot roof deck was designed. No POA fees. Site is 176.98 x 235.64 x 177 x 243.31.', QuarterAvailable='', RegimeFeePerOwner='', Restrictions='', Roof='', Rooms='', Row='', SecurityDeposit='', Size='', SpecialCircumstances='Real Estate Owned', SqFtTotal='', StateOrProvince='South Carolina', Status='Active', StreetDirPrefix='', StreetDirSuffix='', StreetName='New Orleans', StreetNumber='27', StreetNumberNumeric='27', StreetSuffix='ROAD', Style='', SubArea='', TermLength='', TotalAcres='', Treatment='', Type='', TypeofSpace='Commercial Acreage', UnbrandedVirtualTourURL='https://tour.hiltonheadmls.com/27-New-Orleans-ROAD-Hilton-Head-Island-SC-29928/unbranded', UnitNumber='', UnitType='', View='', Water='City PSD,Public Water Available', WeekAvailable='', Windows='', YearBuilt='', Zoning='General Com-Beau' WHERE MLSNumber='393796';