Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T06:54:13.087' ,`MLSNumber` = '64214413' ,`ListAgentFullName` = 'Nancy Garza' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.786857' ,`Longitude` = '-95.166763' ,`PhotoCount` = '19' ,`PostalCode` = '77015' ,`RoomCount` = '3' ,`ListPrice` = '219000.00' ,`Status` = 'Active' ,`StreetName` = 'Gainesville' ,`StreetNumber` = '14419' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1161' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely well done home. Stove that\'s currently in the home will be replaced with new stove. Seller has survey.' ,`Acres` = '0.1288' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 11 BLK 92 CLOVER LEAF' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5610' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'SAM HOUSTON ELEMENTARY SCHOOL (GALENA PARK)' ,`SchoolHigh` = 'NORTH SHORE SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'NORTH SHORE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Clover Leaf' ,`TaxAmount` = '2666' ,`TaxRate` = '2.5853' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1669641541' WHERE `Matrix_Unique_ID` = '209346914' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T06:44:32.877' ,`MLSNumber` = '65126120' ,`ListAgentFullName` = 'Ruby Pineda Cervantes' ,`ListOfficeName` = 'JPAR-The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.543719' ,`Longitude` = '-95.709436' ,`PhotoCount` = '13' ,`PostalCode` = '77469' ,`RoomCount` = '3' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Gonyo' ,`StreetNumber` = '327' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1836' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This single family home was built in 1950.The property has approximately 1836 square feet,\r\n3 beds and 2 baths with a lot size of 1.91 acres. Nearby shopping center with easy access to highway. With near by schools which include Reading J High School, George\r\nRanch High School, Polly Ryon Middle and Manford Williams Elementary School.' ,`Acres` = '1.9145' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = '0049 J KUYKENDALL, TRACT 105, ACRES 1.9145' ,`LotDesciption` = 'Cleared' ,`LotSize` = '83396' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'WILLIAMS ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'J Kuykendall' ,`TaxAmount` = '5638' ,`TaxRate` = '1.6948' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641541' WHERE `Matrix_Unique_ID` = '209735372' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T06:46:06.617' ,`MLSNumber` = '49923899' ,`ListAgentFullName` = 'Ruby Pineda Cervantes' ,`ListOfficeName` = 'JPAR-The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.696651' ,`Longitude` = '-95.716435' ,`PhotoCount` = '26' ,`PostalCode` = '77407' ,`RoomCount` = '3' ,`ListPrice` = '329000.00' ,`Status` = 'Active' ,`StreetName` = 'Rustic Stone' ,`StreetNumber` = '19107' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1664' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don’t miss out on this Gorgeous 3-bedroom, 2 bath home with Beautiful outdoor kitchen. This home features high ceilings with open layout, formal dining, and Breakfast nook.Beautiful granite counters tops & Tile flooring Throughout kitchen and breakfast nook. Hardwood floors throughout with the exception of tile flooring in kitchen and bathrooms. Primary bedroom features a large soaking tub, separate shower, double sinks, & walk-in closet. Beautiful landscaping with Sprinkler system for Hassle free lawn care. Newly replaced roof and Freshly painted kitchen cabinets and doors throughout home.This home is just minutes away from Westpark Tollway, 99 & i-10. Come out and take a look!' ,`Acres` = '0.1447' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND MISSION SEC 10, BLOCK 3, LOT 14' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6304' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '965' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Mission' ,`TaxAmount` = '4825' ,`TaxRate` = '2.5097' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641542' WHERE `Matrix_Unique_ID` = '210287744' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T06:37:18.150' ,`MLSNumber` = '3341337' ,`ListAgentFullName` = 'Jean Jabbour' ,`ListOfficeName` = 'Jabbour Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.681856' ,`Longitude` = '-95.999405' ,`PhotoCount` = '34' ,`PostalCode` = '77485' ,`RoomCount` = '4' ,`ListPrice` = '389000.00' ,`Status` = 'Active' ,`StreetName` = 'Pony' ,`StreetNumber` = '315' ,`StreetSuffix` = 'Lane' ,`City` = 'Simonton' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2271' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A beautiful Victorian house, sits on 3 lots totaling 2.76acres of land, best living you’ll desire. Recently painted, refinished wood floors, new carpet upstairs, new water heater, new gas tank… check this one out' ,`Acres` = '1.8365' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BRAZOS VALLEY SEC 2, BLOCK 35, LOT 11-12 - 13' ,`LotDesciption` = 'Cleared' ,`LotSize` = '80019' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MORGAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Victorian' ,`Subdivision` = 'Brazos Valley Sec 2' ,`TaxAmount` = '4762' ,`TaxRate` = '2.014' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641542' WHERE `Matrix_Unique_ID` = '211321951' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T06:10:35.157' ,`MLSNumber` = '2628118' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.614543' ,`Longitude` = '-95.074123' ,`PhotoCount` = '45' ,`PostalCode` = '77331' ,`RoomCount` = '6' ,`ListPrice` = '234990.00' ,`Status` = 'Active' ,`StreetName` = 'Southwood Shores' ,`StreetNumber` = '281' ,`StreetSuffix` = 'Drive' ,`City` = 'Coldspring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1440' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Southwood Shores, a tranquil lakeside community that inhabits the southeastern end of Lake Livingston. This small, deed restricted community is one of Coldspring\'s best kept secrets. Beautiful mature trees canvas this over-sized homesite, offering glimpses of the lake, and a very short stroll down to the recently renovated, private boat ramp. The home is a lightly lived-in Palm Harbor double-wide w/ a long list of structural & aesthetic upgrades. 3 Bedrooms | 2 Baths | 1,440SF. Open concept living, ample natural lighting, island kitchen w/ adjacent dining, and separate utility room. There is an extended, widened driveway for ample parking and a covered carport that attaches to a recently installed shed w/ electric & additional storage on the back. Enjoy front and back porch sittin\' on the covered decks! There are no back neighbors, providing a serene setting for watching wildlife. Hook up your boat and come on out!' ,`Acres` = '' ,`Area` = '64' ,`BuilderName` = 'Palm Harbor' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '1' ,`Legal` = 'MOBILE HOME ONLY ON LOT 26, SOUTHWOOD SHORES, ACRES 0.3959,' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '17245' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '240' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Southwood Shores' ,`TaxAmount` = '1498' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641542' WHERE `Matrix_Unique_ID` = '211938760' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T06:25:53.033' ,`MLSNumber` = '31273576' ,`ListAgentFullName` = 'Candy Chowdhury' ,`ListOfficeName` = 'Asset Property Realty' ,`SellingAgentFullName` = 'Kay Arnold' ,`SellingOfficeName` = 'Keller Williams Realty - Memor' ,`Latitude` = '29.557735' ,`Longitude` = '-95.672918' ,`PhotoCount` = '32' ,`PostalCode` = '77479' ,`RoomCount` = '11' ,`ListPrice` = '799000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Hunters Point' ,`StreetNumber` = '7507' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4196' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in the Greatwood Shores section of Greatwood, this beautiful Partners in Building semi-custom home has been immaculately maintained by the original owner. From the gourmet kitchen to the huge bonus room to the amazing master suite, you will not be disappointed. This home has 4 bedrooms, 3 1/2 baths down plus a bonus room up with its own full bath. The master bedroom has an unbelievable walk in closet and a separate tub and shower. New wood floors were installed downstairs in 2021. Plantation shutters throughout the house. Enjoy the backyard year round on your enclosed patio with remote controlled screens. The three car garage has one unit set up as a workshop with built-ins but will still accommodate a car. All the doorways in the house are extra wide. There is a Generac whole-house generator. The house sits on a beautifully landscaped large cul-du-sac lot. Enjoy all the amenities Greatwood has to offer. Great schools. Low tax rate. Easy access to 59 and First Colony.' ,`Acres` = '0.2722' ,`Area` = '30' ,`BuilderName` = 'Partners In Building' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GREATWOOD SHORES SEC 4, BLOCK 2, LOT 13' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '11858' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '935' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'DICKINSON ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Greatwood Shores Sec 4' ,`TaxAmount` = '11401' ,`TaxRate` = '2.3013' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641542' WHERE `Matrix_Unique_ID` = '212252499' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T06:58:07.050' ,`MLSNumber` = '4335943' ,`ListAgentFullName` = 'Lawrence Hegar' ,`ListOfficeName` = 'Deitra Robertson Real Estate,' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.458333' ,`Longitude` = '-95.481386' ,`PhotoCount` = '26' ,`PostalCode` = '77378' ,`RoomCount` = '8' ,`ListPrice` = '549900.00' ,`Status` = 'Active' ,`StreetName` = 'Amber' ,`StreetNumber` = '1433' ,`StreetSuffix` = 'Cove' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2788' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your forever home! This property truly has it all. As soon as you enter the home you are immediately captured by the views from the wall of sliding glass doors overlooking 649 sq ft screened in porch and stocked pond. The entire home offers hardwood flooring along with tile. All doorways and hallways are extra wide allowing room for scooters or walkers. The kitchen boast corian countertops, large farm house sink, Kitchen Aide appliances, double convection ovens, induction stovetop, pot filler, premium energy star dishwasher (very quiet) along with a large island and a pass through to living room making it easy for entertaining. Whole house has foam insulation, including roof, garage, & exterior walls. Home is set up for generator and offers a Reme Halo HVAC whole home air purification system that destroys germs & viruses.' ,`Acres` = '1.39' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Willis Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S454403 - EMERALD LAKES 03, BLOCK 3, LOT 29, ACRES 1.39' ,`LotDesciption` = 'Greenbelt,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '60548' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1554' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'C.C. HARDY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Emerald Lakes 03' ,`TaxAmount` = '7843' ,`TaxRate` = '1.8448' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641543' WHERE `Matrix_Unique_ID` = '213401757' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T06:18:49.990' ,`MLSNumber` = '34540375' ,`ListAgentFullName` = 'Karen Hoogendorn' ,`ListOfficeName` = 'Worth Clark Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.725248' ,`Longitude` = '-95.558532' ,`PhotoCount` = '19' ,`PostalCode` = '77320' ,`RoomCount` = '4' ,`ListPrice` = '134500.00' ,`Status` = 'Active' ,`StreetName` = '10th' ,`StreetNumber` = '1622' ,`StreetSuffix` = 'Street' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1120' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Farmhouse Style 3 bedroom, 2 baths, carport, storage building with backyard, located 1 block from Elementary school, near Historic downtown Huntsville. *Zoned for Residential or Commercial, great investment property.' ,`Acres` = '0.1515' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ROGERVILLE, LOT 7, ACRES 0.1515, (MH 7.1)' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6599' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'SAMUEL W HOUSTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Rogerville' ,`TaxAmount` = '194' ,`TaxRate` = '1.9609' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641543' WHERE `Matrix_Unique_ID` = '213455821' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T05:16:30.323' ,`MLSNumber` = '88605054' ,`ListAgentFullName` = 'Alma Puerto' ,`ListOfficeName` = 'Texas Fast Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.199834' ,`Longitude` = '-95.529025' ,`PhotoCount` = '22' ,`PostalCode` = '77381' ,`RoomCount` = '7' ,`ListPrice` = '714000.00' ,`Status` = 'Active' ,`StreetName` = 'Candle Pine Place' ,`StreetNumber` = '3' ,`StreetSuffix` = 'Place' ,`City` = 'The Woodlands' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3442' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SHowings start : Nov 26 th 2022 ****Centrally located LifeForms home on a large, cul-de-sac lot in Cochran\'s Crossing! Dramatic two story entry with sweeping wrought iron staircase, hardwood and tile flooring, designer carpet, and generous room sizes. Open concept island kitchen with granite counters, breakfast bar, stainless steel appliances and plenty of cabinet storage overlooks breakfast and family room with gas log fireplace and floor to ceiling windows; elegant formal dining and living private study with plenty built ins; master retreat up with sitting area; two bedrooms and loft up overlooking the pool; fenced yard provides a park-like setting in your large lot with sparkling pool. Ask for an opportunity to aquire the house directly from the owner. Hablo Espanol, directo trato con el Dueno de la casa con posibilidad de compra directa sin Banco.' ,`Acres` = '0.2666' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Real Estate Owned,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WDLNDS VIL COCHRANS CR 39, BLOCK 1, LOT 11' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '11613' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GALATAS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Cochrans Cr 39' ,`TaxAmount` = '11477' ,`TaxRate` = '2.1269' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641543' WHERE `Matrix_Unique_ID` = '214034313' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T06:43:26.423' ,`MLSNumber` = '65433614' ,`ListAgentFullName` = 'Kimberly Thorpe' ,`ListOfficeName` = 'RE/MAX Integrity' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.221100' ,`Longitude` = '-95.539807' ,`PhotoCount` = '49' ,`PostalCode` = '77382' ,`RoomCount` = '5' ,`ListPrice` = '799900.00' ,`Status` = 'Active' ,`StreetName` = 'Kerry Bog' ,`StreetNumber` = '349' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '3034' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ENJOY SPECTACULAR VIEWS IN THIS 3-3-2+ RARE FIND LOCATED IN A 55+ DEL WEBB THE WOODLANDS ACTIVE COMMUNITY* THIS BEAUTIFUL HOME COMES WITH LOTS OF FEATURES*LARGE ISLAND KITCHEN WITH A BREAKFAST BAR*DOUBLE OVEN*GAS STOVE TOP*BREAKFAST AREA WITH PLANTATION SHUTTERS*SPACIOUS DEN, SUNROOM, AND ENTRY WITH ENGINEERED WOOD FLOORING*LOTS OF WINDOWS IN DEN,SUNROOM AND PRIMARY BEDROOM WITH VIEWS OF WATER FOUNTAIN AND LAKE/POND*LARGE LAUNDRY ROOM WITH SINK*DROP ZONE BY GARAGE ENTRY*LOTS OF STORAGE SPACE*LARGE PATIO WITH OUTDOOR KITCHEN AND ELECTRIC SUNSCREEN SHADES*GREAT FOR ENTERTAINING FRIENDS AND FAMILY*THE GARAGE IS OVERSIZED SO YOU HAVE ROOM FOR 2 CARS AND A GOLF CART*EPOXY FLOORING IN THE GARAGE*TANGERLY OAK FLOOR PLAN WITH A SUNROOM*WALK OUT OF YOUR BACKYARD TO THE WALKING TRAILS*LOTS OF AMENITIES IN THE NEIGHBORHOOD*PICKLE BALL COURTS, TENNIS CORTS,BOCCEE BALL,2 POOLS,LODGE, EXERCISE EQUIPMENT*GREAT LOCATION*GROCERY STORES,RESTAURANTS,WOODLANDS MALL,HOSPITALS ALL CONVENIENTLY LOCATED' ,`Acres` = '0.1978' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S402302 - DEL WEBB THE WOODLANDS 02, BLOCK 1, LOT 26' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '8618' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2560' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'TOM R. ELLISOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Del Webb The Woodlands' ,`TaxAmount` = '9326' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641543' WHERE `Matrix_Unique_ID` = '214123016' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214583393','1669641544','214583393','2022-11-23T05:04:28.690','71020356','Harley Hedgpeth','Coldwell Banker Realty','','','29.837700','-95.458995','31','77092','10','525000.00','Active','Carleen','4614','Road','Houston','2','0','3','1480','Single-Family','Oak Forest Stunning Mid-Century Modern home. Everything was brought up to date. Recently Remodeled HVAC, Water Heater, Underground Plumbing. Electrical re-wire, windows, fresh paint, James Hardie siding. Gutters. Privacy fence. Roof shingles replaced in 2018. Recent kitchen cabinetry, quartz countertops, tile backsplash, walk in pantry. Stainless Steel appliances, designer tile & refinished original hardwood floors. Modern Bathrooms with recently updated plumbing, tile, cabinets, countertops. Recessed lights in Kitchen & Living. Ceiling fans w/ remote controls all bedrooms. Primary suite has custom organized closet and fully maximized master bath. Beautiful heated pool with wood deck. Great for entertaining on those Hot Summer days..*****NEVER FLOODED********** Please verify all room dimensions, square footage, schools and taxes.**********','0.1975','9','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Stove','1','Oak Forest West Area','Central Gas','0','LT 5 BLK 3 OAK FOREST SEC 15','Subdivision Lot','8605','Appraisal District','','','0','','1','Electric Oven,Single Oven','1','Gunite,Heated,In Ground','','Gas Range','','Composition','27 - Houston','SMITH ELEMENTARY SCHOOL (HOUSTON)','SCARBOROUGH HIGH SCHOOL','CLIFTON MIDDLE SCHOOL (HOUSTON)','Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Contemporary/Modern,Ranch','Oak Forest Sec 15','8339','2.3307','Public Sewer,Public Water','1955','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214601432','1669641544','214601432','2022-11-23T05:37:04.950','96205143','Kristie Farmer','Keller Williams Signature','','','29.490452','-94.919742','20','77539','7','325000.00','Active','8th','454','Street','San Leon','3','0','4','1886','Single-Family','Highly Maintained Home, Move in Ready, located minutes from Trinity Bay, East Galveston and Dickinson Bayou. A True Fisherman\'s Dream. This home offers 2 Primary bedrooms , for a total of 4 bedrooms & 3 full baths. You will enjoy front or back porch sitting under these 40x10 ft covered decks on both the front & back of the home. The home is situated perfectly on 4 lots. A concrete drives leads to the very private, fenced back yard that includes a 31x12 boat cover, & a 16x12 storage building. Primary bedroom #1 is located here in the front of the home, with its relaxing primary bath complete with jetted tub and separate show. 2 additional bedrooms & the full guest bath are also located in the front of the home. In the kitchen you will find tons of counter space and cabinets for storage. An island is right in the middle for added work surfaces and entertaining. The dinning room & primary bedroom #2 are located in the back of the home. You can have it all.','0.2938','33','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','0','Bacliff/San Leon','Central Gas','0','ABST 10 PAGE 9 LOTS 45 THRU 48 BLK 71 SAN LEON','Cleared,Corner','12800','Appraisal District','','','0','','0','Single Oven','0','','','','','Other','17 - Dickinson','SAN LEON ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','JOHN AND SHAMARION BARBER MIDDLE SCHOOL','Supra Keybox','Appraisal District','1','Traditional','San Leon','3464','2.521','Public Sewer,Public Water','1982','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214946790','1669641544','214946790','2022-11-23T05:03:28.257','89692344','Lynn Beardslee','JPAR - The Sears Group','','','29.175992','-94.983870','25','77554','2','525000.00','Active','San Luis Pass','17407','Road','Galveston','1','1','2','840','Single-Family','Beachside with an unobstructed beach view! Your perfect Galveston getaway. Established vacation rental with rental history. Reverse floor plan with living room and kitchen on the top level ensuring the best views. Recent updates include interior & exterior paint, new lighting, new appliances, and an outdoor shower. Open, bright, and beachy. Two large decks with breathtaking views on an oversized lot. Own your piece of paradise today!','0.1102','33','','','Electric Dryer Connections','','Sellers Disclosure','1','','','West End','Central Electric','0','ABST 121 HALL & JONES SUR TRACT C SMITH CORNER AT GULF PALMS','Water View','4800','Appraisal District','','','0','','1','Electric Oven','0','','','Electric Range','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Appointment Required','Appraisal District','2','Split Level','Smith Corner At Gulf Palms','7078','2.0324','Public Water,Septic Tank','2005','Appraisal District'); --> New record created successfully