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-12-09T09:23:54.597' ,`MLSNumber` = '2771324' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '32.538434' ,`Longitude` = '-94.389870' ,`PhotoCount` = '6' ,`PostalCode` = '75670' ,`RoomCount` = '3' ,`ListPrice` = '33999.00' ,`Status` = 'Active' ,`StreetName` = 'Cass' ,`StreetNumber` = '2413' ,`StreetSuffix` = 'Street' ,`City` = 'Marshall' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Just Charming! Perfect for downsizing or first time buyers. Call now to schedule your private tour this beauty wont last long. Close to Baptist University and shopping nearby' ,`Acres` = '0.165' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'No Heating,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ACRES: 0.165, LOT: 12, BLK: 4, SUBD: COLLEGE HTS 2ND, HSE' ,`LotDesciption` = 'Other' ,`LotSize` = '7187' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '99 - Other' ,`SchoolElementary` = 'G W CARVER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MARSHALL HIGH SCHOOL (MARSHALL)' ,`SchoolMiddle` = 'MARSHALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'College Heights 2nd' ,`TaxAmount` = '497' ,`TaxRate` = '2.157' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675089081' WHERE `Matrix_Unique_ID` = '192042061' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-09T09:27:14.690' ,`MLSNumber` = '36448138' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '33.424754' ,`Longitude` = '-94.106230' ,`PhotoCount` = '22' ,`PostalCode` = '75501' ,`RoomCount` = '4' ,`ListPrice` = '79900.00' ,`Status` = 'Active' ,`StreetName` = 'Arizona' ,`StreetNumber` = '633' ,`StreetSuffix` = 'Avenue' ,`City` = 'Wake Village' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1447' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you\'re looking for a decent home with good country living, look no further. This home is close to Wake Village Elementary School and a variety of small shops and eateries, making it perfect for you and your family. This home does need some renovating, but offers a great investment for first time home buyers. Property is also close to major highways. Call today to schedule a viewing!' ,`Acres` = '0.2' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'No Heating,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'WAKE VILLAGE LOT 10 2016-6892 06/02/16 BLK/TRACT 9 0.2 ACRES' ,`LotDesciption` = 'Cleared' ,`LotSize` = '8712' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '99 - Other' ,`SchoolElementary` = 'WAKE VILLAGE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TEXAS HIGH SCHOOL' ,`SchoolMiddle` = 'TEXAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Wake Village' ,`TaxAmount` = '1275' ,`TaxRate` = '2.2158' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '0' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675089081' WHERE `Matrix_Unique_ID` = '192203994' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-09T10:07:15.903' ,`MLSNumber` = '43786928' ,`ListAgentFullName` = 'Krystle Gonzalez' ,`ListOfficeName` = 'Weichert,REALTORS-Murray Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.697502' ,`Longitude` = '-95.240264' ,`PhotoCount` = '30' ,`PostalCode` = '77017' ,`RoomCount` = '5' ,`ListPrice` = '489900.00' ,`Status` = 'Active' ,`StreetName` = 'Ogilvie' ,`StreetNumber` = '202' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This modern stucco and exceptional two story home features 3,300 square feet of living space with 5-bedrooms, 4 1/2 baths and 3,300 square feet of living space! As you enter through the front door, you are sure to be amazed by the extended foyer, large winding staircase, high ceiling and the open concept design. Flanking the foyer is a spacious study that is the perfect spot to work from home. Leading into the heart of the home you will discover gorgeous tile floors that pave your way throughout. Enjoy making delicious meals for the family in the gourmet kitchen that is equipped with lots of counter space and an island that overlooks the dining and family room. This floor plan will make holiday gatherings a breeze! Come see what this stunning home has to offer today!' ,`Acres` = '0.1689' ,`Area` = '3' ,`BuilderName` = 'Star Nova Contractor' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 24 BLK 38 OAK MEADOWS SEC 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '7356' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'RUCKER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CHAVEZ HIGH SCHOOL' ,`SchoolMiddle` = 'STEVENSON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Meadows Sec 02' ,`TaxAmount` = '5229' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675089081' WHERE `Matrix_Unique_ID` = '207626835' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-09T09:39:08.720' ,`MLSNumber` = '24615313' ,`ListAgentFullName` = 'Libby Mitchell' ,`ListOfficeName` = 'REGENCY REAL ESTATE PROF' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.999911' ,`Longitude` = '-93.814653' ,`PhotoCount` = '6' ,`PostalCode` = '77611' ,`RoomCount` = '6' ,`ListPrice` = '253600.00' ,`Status` = 'Active' ,`StreetName` = 'Zachary' ,`StreetNumber` = '211' ,`StreetSuffix` = 'Lane' ,`City` = 'Bridge City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1656' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Here\'s another brand new construction in Marsh Estates! DSLD Homes\' \"Dogwood\" plan offers a 3 bedroom and 2 full bathroom open floor plan in BCISD! Special features: Stainless appliances, 3 cm granite countertops & undermount sinks throughout, birch cabinets throughout, Luxury Vinyl Plank flooring in living area & halls, ceramic tile in wet areas & carpet in bedrooms. LED lighting throughout, ceiling fans in the living area and master bedroom, Bronze plumbing fixtures, post tension slab, and more! Energy Efficient Features: Tankless gas water heater, low E tilt-in windows, radiant barrier roof decking, and more! Property is located in Flood Zone X.' ,`Acres` = '' ,`Area` = '50' ,`BuilderName` = 'DSLD Homes, LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 12' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '53' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '367 - Bridge City' ,`SchoolElementary` = 'BRIDGE CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGE CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BRIDGE CITY MIDDLE SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Marsh Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675089082' WHERE `Matrix_Unique_ID` = '207762651' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-09T10:11:16.573' ,`MLSNumber` = '76268506' ,`ListAgentFullName` = 'Nancy Lawrence' ,`ListOfficeName` = 'Lawrence Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.089983' ,`Longitude` = '-95.530923' ,`PhotoCount` = '50' ,`PostalCode` = '75851' ,`RoomCount` = '4' ,`ListPrice` = '590000.00' ,`Status` = 'Active' ,`StreetName` = 'FM 3151' ,`StreetNumber` = '4591' ,`StreetSuffix` = '' ,`City` = 'Lovelady' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3225' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This three bedroom, two and one-half bath limestone home has ample space to accommodate with guests. The focal point in the living area is the pretty fireplace to keep you cozy in the winter. The kitchen is outfitted with an abundance of cabinet and countertop space, as well as a pantry. The master suite offers privacy from the guest bedrooms and has a large bath with a great vanity, his and her sinks, walk-in shower and large soaking tub. Two guest bedrooms are nice sized and share a hall bath. There is a bonus room that is currently being used as a home gym, but would make a great study or craft room, as well. Outdoors, you’ll find an in-ground swimming pool to cool off on hot summer days, as well as a 2-car garage with a half bath. There is a stock tank situated near the front of the property to provide water for livestock, as well as a horse stall as the back of the property. This would make a great weekend home for somebody looking to retreat! Call today!' ,`Acres` = '10' ,`Area` = '41' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lovelady/Weldon Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'F PEREZ AB 63 1.00 AC' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '62 - Lovelady' ,`SchoolElementary` = 'LOVELADY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LOVELADY J H HIGH SCHOOL' ,`SchoolMiddle` = 'LOVELADY J H HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'NA' ,`TaxAmount` = '5554' ,`TaxRate` = '1.8562' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675089082' WHERE `Matrix_Unique_ID` = '209395425' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-09T09:40:35.890' ,`MLSNumber` = '39276846' ,`ListAgentFullName` = 'Libby Mitchell' ,`ListOfficeName` = 'REGENCY REAL ESTATE PROF' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.035900' ,`Longitude` = '-93.854800' ,`PhotoCount` = '6' ,`PostalCode` = '77611' ,`RoomCount` = '6' ,`ListPrice` = '269280.00' ,`Status` = 'Active' ,`StreetName` = 'Zachary' ,`StreetNumber` = '208' ,`StreetSuffix` = 'Lane' ,`City` = 'Bridge City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1710' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Here\'s another brand new construction in Marsh Estates! DSLD Homes\' \"LaSalle\" plan offers a 3 bedroom and 2 full bathroom open floor plan in BCISD! Special features: Stainless appliances, 3 cm granite countertops & undermount sinks throughout, birch cabinets throughout, Luxury Vinyl Plank flooring in living area & halls, ceramic tile in wet areas & carpet in bedrooms. LED lighting throughout, ceiling fans in the living area and master bedroom, Bronze plumbing fixtures, post tension slab, and more! Energy Efficient Features: Tankless gas water heater, low E tilt-in windows, radiant barrier roof decking, and more!' ,`Acres` = '' ,`Area` = '50' ,`BuilderName` = 'DSLD Homes, LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 20' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '53' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '367 - Bridge City' ,`SchoolElementary` = 'BRIDGE CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGE CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BRIDGE CITY MIDDLE SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Marsh Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675089082' WHERE `Matrix_Unique_ID` = '213163874' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-09T09:38:03.653' ,`MLSNumber` = '20036076' ,`ListAgentFullName` = 'Libby Mitchell' ,`ListOfficeName` = 'REGENCY REAL ESTATE PROF' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.038530' ,`Longitude` = '-93.856252' ,`PhotoCount` = '6' ,`PostalCode` = '77611' ,`RoomCount` = '6' ,`ListPrice` = '265220.00' ,`Status` = 'Active' ,`StreetName` = 'Zachary' ,`StreetNumber` = '215' ,`StreetSuffix` = 'Lane' ,`City` = 'Bridge City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1770' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DSLD Homes \"Nerine\" plan offers a 3 bedroom and 2 full bathroom open floor plan. Special features: Stainless appliances, 3 cm granite countertops & undermount sinks throughout, birch cabinets throughout, Luxury Vinyl Plank flooring in living area & halls, ceramic tile in wet areas & carpet in bedrooms. LED lighting throughout, ceiling fans in the living area and master bedroom, Bronze plumbing fixtures, post tension slab, and more! Energy Efficient Features: Tankless gas water heater, low E tilt-in windows, radiant barrier roof decking, and more!' ,`Acres` = '' ,`Area` = '50' ,`BuilderName` = 'DSLD Homes, LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 14' ,`LotDesciption` = 'Cleared,Cul-De-Sac' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '53' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '367 - Bridge City' ,`SchoolElementary` = 'BRIDGE CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGE CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BRIDGE CITY MIDDLE SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Marsh Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675089082' WHERE `Matrix_Unique_ID` = '213285123' --> 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','214235781','1675089083','214235781','2022-12-09T10:37:12.613','88802613','Nicole Cheramie','Cobb Real Estate','','','29.451885','-94.666566','50','77650','10','3250000.00','Active','Lagoon','1239','Drive','Crystal Beach','3','2','5','5450','Single-Family','Unparalleled Custom Bay House in Prestigious Gated Waterways Community, this custom-built home is on 2 lots and has every amenity plus! Enjoy the Sunrise or Sunset on the deck and just a few mins to the beach! The home features, Putting Green, Pool, Hot Tub, Steam Room, Theater Room,3000 bottles Climate-Controlled Wine Room, Gourmet Kitchen with 3 Viking Ovens, an Elevator,2 Fireplaces, Teak Outdoor Decking, a Boathouse, a BoatLift, and room to dock to 70ft with Shore Power, a Fenced yard, an Outdoor Kitchen with Wolf ovens with tons of room for entertaining, Custom Cabinetry, Hardwood Floors, Wrap around Porch and much much MORE! Please be sure and watch the Video also. This Property is for qualified buyers, please contact the listing agent for a showing.','','33','','','Electric Dryer Connections,Washer Connections','','Other Disclosures,Sellers Disclosure,Special Addendum','1','Freestanding','2','Crystal Beach','Central Electric','1','WATERWAYS SEC 2 ABST 179, LOT 73, ACRES 0.289','Cleared,Other,Subdivision Lot,Water View,Waterfront','25178','Appraisal District','','800','0','','3','Convection Oven,Double Oven,Electric Oven','1','Enclosed,Gunite,Heated,In Ground','','Electric Cooktop,Gas Cooktop,Gas Range','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Accompany,Appointment Required','Appraisal District','2','Other Style','Waterways Sec 2','19396','1.6103','Public Water,Septic Tank','2008','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-09T09:45:19.053' ,`MLSNumber` = '68606457' ,`ListAgentFullName` = 'Libby Mitchell' ,`ListOfficeName` = 'REGENCY REAL ESTATE PROF' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.081609' ,`Longitude` = '-93.792919' ,`PhotoCount` = '6' ,`PostalCode` = '77630' ,`RoomCount` = '7' ,`ListPrice` = '272325.00' ,`Status` = 'Active' ,`StreetName` = 'Mimosa' ,`StreetNumber` = '4502' ,`StreetSuffix` = 'Drive' ,`City` = 'Orange' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2092' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous and spacious \"Falkner\" model by DSLD Homes offers a 4 bedroom and 3 full bathroom open floor plan. Special features: Black appliances, 3 cm granite countertops throughout, birch cabinets throughout, Luxury Vinyl Plank flooring in living area, halls, and wet areas with carpet in bedrooms; ceiling fans in the living area and master bedroom, Bronze plumbing fixtures in the bathrooms, posttension slab, and more! Energy Efficient Features: Tankless gas water heater, low E tilt-in windows, radiant barrier roof decking, and more!' ,`Acres` = '' ,`Area` = '50' ,`BuilderName` = 'DSLD Homes, LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 35 Sec. 2' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '130' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '367 - Bridge City' ,`SchoolElementary` = 'BRIDGE CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGE CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BRIDGE CITY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypresswood Village' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675089083' WHERE `Matrix_Unique_ID` = '214278856' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-09T10:24:58.670' ,`MLSNumber` = '24347873' ,`ListAgentFullName` = 'Friday Brume' ,`ListOfficeName` = 'RE/MAX East' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.821593' ,`Longitude` = '-95.358865' ,`PhotoCount` = '15' ,`PostalCode` = '77022' ,`RoomCount` = '12' ,`ListPrice` = '299990.00' ,`Status` = 'Active' ,`StreetName` = 'Bennington' ,`StreetNumber` = '932' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2976' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a huge home with 3 master bedrooms, livingrooms, gameroom, breakfast area, dining room and lots more. Electronically gated property and lots more. Per seller, occasionally water do sip into the back part of the property through the sides of the house. Easy access to 610-north and couple of minutes away from downtown, shopping malls etc. Home is being sold As-is.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 12 BLK 10 BEVERLY PLACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7072' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HERRERA ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'SAM HOUSTON MATH SCIENCE AND TECHNOLOGY CENTER' ,`SchoolMiddle` = 'BURBANK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'BEVERLY PLACE' ,`TaxAmount` = '3944' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675089083' WHERE `Matrix_Unique_ID` = '214823145' --> 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','215156971','1675089083','215156971','2022-12-09T09:47:28.870','89141213','Libby Mitchell','REGENCY REAL ESTATE PROF','','','30.081257','-93.792908','6','77630','6','239140.00','Active','Mimosa','4505','Drive','Orange','2','0','3','1710','Single-Family','DSLD Homes \"LaSalle\" plan offers a 3 bedroom and 2 full bathroom open floor plan. Special features: Black appliances, 3 cm granite countertops throughout, birch cabinets throughout, Luxury Vinyl Plank flooring in living area, halls, and wet areas with carpet in bedrooms; ceiling fans in the living area and master bedroom, Bronze plumbing fixtures in the bathrooms, post tension slab, and more! Energy Efficient Features: Tankless gas water heater, low E tilt-in windows, radiant barrier roof decking, and more!','','50','DSLD Homes, LLC','','','','No Disclosures','1','','','','Central Gas','1','Lot 10','Cleared','','','','130','1','To Be Built/Under Construction','2','Electric Oven,Freestanding Oven','0','','','Electric Range,Freestanding Range','','Composition','367 - Bridge City','BRIDGE CITY ELEMENTARY SCHOOL','BRIDGE CITY HIGH SCHOOL','BRIDGE CITY MIDDLE SCHOOL','Appointment Required','Builder','1','Traditional','Cypresswood Village','','','Public Sewer,Public Water','2022','Builder'); --> 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','215370521','1675089083','215370521','2022-12-09T09:31:16.477','55288892','Libby Mitchell','REGENCY REAL ESTATE PROF','','','30.081257','-93.792908','6','77630','6','239140.00','Active','Mimosa','4513','Drive','Orange','2','0','3','1710','Single-Family','DSLD Homes \"LaSalle\" plan offers a 3 bedroom and 2 full bathroom open floor plan. Special features: Black appliances, 3 cm granite countertops throughout, birch cabinets throughout, Luxury Vinyl Plank flooring in living area, halls, and wet areas with carpet in bedrooms; ceiling fans in the living area and master bedroom, Bronze plumbing fixtures in the bathrooms, post tension slab, and more! Energy Efficient Features: Tankless gas water heater, low E tilt-in windows, radiant barrier roof decking, and more!','0.2','50','DSLD Homes, LLC','','','','No Disclosures','1','','','','Central Gas','1','Lot 14','Cleared','','','','130','1','To Be Built/Under Construction','2','Electric Oven,Freestanding Oven','0','','','Electric Range,Freestanding Range','','Composition','367 - Bridge City','BRIDGE CITY ELEMENTARY SCHOOL','BRIDGE CITY HIGH SCHOOL','BRIDGE CITY MIDDLE SCHOOL','Appointment Required','Builder','1','Traditional','Cypresswood Village','','','Public Sewer,Public Water','2023','Builder'); --> 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','215370878','1675089083','215370878','2022-12-09T09:27:52.190','90824341','Libby Mitchell','REGENCY REAL ESTATE PROF','','','30.080922','-93.793520','6','77630','7','256200.00','Active','Mimosa','4509','Drive','Orange','2','1','4','1851','Single-Family','The family friendly \"Yucca\" model by DSLD Homes offers a 4 bedroom and 2½ bath open floor plan. Special features: Black appliances, 3 cm granite countertops throughout, birch cabinets throughout, Luxury Vinyl Plank flooring in living area, halls, and wet areas with carpet in bedrooms; ceiling fans in the living area and master bedroom, Bronze plumbing fixtures in the bathrooms, post tension slab, and more! Energy Efficient Features: Tankless gas water heater, low E tilt-in windows, radiant barrier roof decking, and more!','0.22','50','DSLD Homes, LLC','','','','No Disclosures','1','','','','Central Gas','1','Lot 12 Sec. 2','Cleared','','','','130','1','To Be Built/Under Construction','2','Electric Oven,Freestanding Oven','0','','','Electric Range,Freestanding Range','','Composition','367 - Bridge City','BRIDGE CITY ELEMENTARY SCHOOL','BRIDGE CITY HIGH SCHOOL','BRIDGE CITY MIDDLE SCHOOL','Vacant/Unoccupied','Builder','1','Traditional','Cypresswood Village','','','Public Sewer,Public Water','2023','Builder'); --> 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','215441752','1675089083','215441752','2022-12-09T09:36:37.920','51910336','Lucy Ware','Birdsong Real Estate','','','29.148224','-95.672626','17','77486','3','85000.00','Active','County Road 943','1050','','West Columbia','2','0','2','924','Single-Family','Investor Special! 2 bedroom 2 bath sits on large lot. Book your appointment today!','1.117','5','','','','','No Disclosures','','','','West of the Brazos','Central Electric','0','BLIDELL LANDS INC (A0040 J H BELL DIV 9) LOT 26 ACRES 1.117','Subdivision Lot','48657','Appraisal District','','','0','','0','','0','','','','','Aluminum','10 - Columbia-Brazoria','','COLUMBIA HIGH SCHOOL','WEST BRAZOS JUNIOR HIGH','Leave Business Card,Lockbox Front','Appraisal District','1','Other Style','Blidell Lands Inc','261','1.5833','Septic Tank,Well','2017','Appraisal District'); --> New record created successfully