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-08-19T19:23:03.027' ,`MLSNumber` = '57021183' ,`ListAgentFullName` = 'Patricia Savage' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.482682' ,`Longitude` = '-95.180253' ,`PhotoCount` = '49' ,`PostalCode` = '77546' ,`RoomCount` = '14' ,`ListPrice` = '3490000.00' ,`Status` = 'Active' ,`StreetName` = 'Sierra Madre' ,`StreetNumber` = '2517' ,`StreetSuffix` = '' ,`City` = 'Friendswood' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '6550' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This remarkable Texas Hill Country type home encompassing 4.86 acres is situated near the end of a private street in coveted Rancho Viejo. An iron entry gate opens to spacious grounds and this sprawling one-story with front and rear courtyards. Three entry doors lead to generous living spaces with tall ceilings, quarried stone accent walls and stained-wood beams. Walls of glass reveal expansive sheltered patios with an outdoor fireplace, enormous resort pool and spa, stucco cabanas and an elaborate summer kitchen. The interior floor plan rivals the exterior amenities. Its primary wing includes a secluded multi-room suite with bedroom, library and an extra room with pool access. The secondary wing has a game room, children\'s study and four bedrooms with en-suite baths. Spacious grounds allow for a barn with air-conditioned storage, a stocked pond with a Spindletop-style vintage oil derrick, a pavilion and space for horses.' ,`Acres` = '4.86' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 143' ,`LotDesciption` = 'Cleared,Cul-De-Sac' ,`LotSize` = '211858' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Grill' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '20 - Friendswood' ,`SchoolElementary` = 'CLINE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FRIENDSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'FRIENDSWOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Rancho Viejo' ,`TaxAmount` = '32353' ,`TaxRate` = '2.28' ,`WaterSewer` = 'Public Sewer,Public Water,Well' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700688' WHERE `Matrix_Unique_ID` = '203749763' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T18:09:54.830' ,`MLSNumber` = '59558937' ,`ListAgentFullName` = 'Roxanne Walker' ,`ListOfficeName` = 'Texas Trust Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.592320' ,`Longitude` = '-96.330529' ,`PhotoCount` = '18' ,`PostalCode` = '77434' ,`RoomCount` = '6' ,`ListPrice` = '159900.00' ,`Status` = 'Active' ,`StreetName` = 'Prairie' ,`StreetNumber` = '107' ,`StreetSuffix` = 'Avenue' ,`City` = 'Eagle Lake' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1418' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This cute home features 3 bedrooms and 2 baths, with gorgeous granite counter tops, backsplash, built-in electric cook top stove, built-in electric oven & free standing microwave. No carpet in the home. There is wood vinyl and linoleum flooring with ceiling fans throughout. Great backyard, an oversized workshop with covered parking. The back has plenty of space for your toys with chain linked fencing. Call & schedule to view today.' ,`Acres` = '0.353' ,`Area` = '56' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BLK 42 PT LT 7 EAGLE LAKE & HOUSE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15377' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '161 - Rice Consolidated' ,`SchoolElementary` = 'EAGLE LAKE INTERMEDIATE SCHOOL' ,`SchoolHigh` = 'RICE HIGH SCHOOL (RICE CISD)' ,`SchoolMiddle` = 'RICE JUNIOR HIGH SCHOOL (RICE CISD)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Eagle Lake' ,`TaxAmount` = '3252' ,`TaxRate` = '2.5343' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700688' WHERE `Matrix_Unique_ID` = '205227691' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T19:05:35.643' ,`MLSNumber` = '27061465' ,`ListAgentFullName` = 'Holly Jackson' ,`ListOfficeName` = 'RE/MAX ONE - Premier' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.794213' ,`Longitude` = '-94.660931' ,`PhotoCount` = '42' ,`PostalCode` = '77514' ,`RoomCount` = '8' ,`ListPrice` = '485000.00' ,`Status` = 'Active' ,`StreetName` = 'Oetken' ,`StreetNumber` = '223' ,`StreetSuffix` = '' ,`City` = 'Anahuac' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2386' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You\'ll love this newly remodeled home which sits on 1.2 acres. The kitchen features new shaker style cabinetry, gorgeous Quartz countertops, huge breakfast island, stainless appliances and fabulous Frigidaire Professional Refrigerator. Other updates include all new baths, Oak Vinyl flooring, high pile carpet, paint (inside & out), lighting and new upstairs A/C. The back yard has a small storage building and fully fenced, huge yard. The subdivision is one of the most sought after in the area. Call today to make this beautiful home yours!' ,`Acres` = '1.293' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Chambers County East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '13 OETKEN WEST AND LOT 3 OF RILEY SUBDIVISION' ,`LotDesciption` = 'Wooded' ,`LotSize` = '56323' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '4 - Anahuac' ,`SchoolElementary` = 'ANAHUAC ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANAHUAC HIGH SCHOOL' ,`SchoolMiddle` = 'ANAHUAC MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oetken West' ,`TaxAmount` = '6018' ,`TaxRate` = '2.6602' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700688' WHERE `Matrix_Unique_ID` = '209026087' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T18:16:18.067' ,`MLSNumber` = '78563599' ,`ListAgentFullName` = 'Lily Khan' ,`ListOfficeName` = 'Home Team RE Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.202621' ,`Longitude` = '-96.266697' ,`PhotoCount` = '11' ,`PostalCode` = '77437' ,`RoomCount` = '6' ,`ListPrice` = '258500.00' ,`Status` = 'Active' ,`StreetName` = 'West' ,`StreetNumber` = '606' ,`StreetSuffix` = 'Street' ,`City` = 'El Campo' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1477' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOOK AGAIN...The home is just about completed!! The Builder is in the final stages and the home will be move in ready soon! This BEAUTIFUL Single story home has 3 bedroom, 2.5 bath and offers several unique features and custom qualities. The open floor plan includes a 12\' cathedral ceiling in the living/dining room areas with open space living/entertaining. The modern designed kitchen features a very classic coffered ceiling and 42” custom cabinets and an island. The light and bright granite counter tops enhance the stainless steel appliances and featured gas stove and walk in corner pantry. The Primary Bedroom features a coffered ceiling, custom closet drawers/shelves. The Primary Bath is a combo tub/shower and a double sink vanity. The secondary bedrooms also include custom closets and finishes. The utility room opens to backyard and the garage has been fully finished for future expansion. This location is close to shopping and public agencies.' ,`Acres` = '0.186' ,`Area` = '55' ,`BuilderName` = 'Medina' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'EL CAMPO BLOCK 25 LOT 16,17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8102' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '198 - El Campo' ,`SchoolElementary` = '' ,`SchoolHigh` = 'EL CAMPO HIGH SCHOOL' ,`SchoolMiddle` = 'EL CAMPO MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'El Campo' ,`TaxAmount` = '744' ,`TaxRate` = '2.4815' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700689' WHERE `Matrix_Unique_ID` = '209477103' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T18:12:35.147' ,`MLSNumber` = '93196477' ,`ListAgentFullName` = 'Joseph Huber' ,`ListOfficeName` = 'Alchemist Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.747788' ,`Longitude` = '-95.593716' ,`PhotoCount` = '28' ,`PostalCode` = '77077' ,`RoomCount` = '3' ,`ListPrice` = '445000.00' ,`Status` = 'Active' ,`StreetName` = 'Sugar Springs' ,`StreetNumber` = '12054' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2745' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Completely Remodeled Luxury Home on a corner lot, wrapped around a courtyard Home has a nice open floorplan and high ceilings. New appliances in the kitchen including a double oven and a new cooktop with a stainless vent hood. Bedrooms are in a separate wing. Master Bedroom has a massive walk-in closet! Bathrooms completely remodeled with frameless glass showers and luxury tile, Great Location!!! close to energy corridor, parks, shopping and a prestigious private Briarwood School.' ,`Acres` = '0.2089' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 27 BLK 9 ASHFORD VILLAGE SEC 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9098' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '670' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ASHFORD/SHADOWBRIAR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ashford Village Sec 01' ,`TaxAmount` = '8743' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700689' WHERE `Matrix_Unique_ID` = '209676867' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T19:37:12.937' ,`MLSNumber` = '52716631' ,`ListAgentFullName` = 'Erica Mouton' ,`ListOfficeName` = 'Divine Dreams Real Estate' ,`SellingAgentFullName` = 'Gary Lidiak' ,`SellingOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`Latitude` = '29.442203' ,`Longitude` = '-95.414962' ,`PhotoCount` = '46' ,`PostalCode` = '77583' ,`RoomCount` = '12' ,`ListPrice` = '675000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Carver' ,`StreetNumber` = '9807' ,`StreetSuffix` = 'Drive' ,`City` = 'Iowa Colony' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4649' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FINALLY!! YOUR DREAM HOME IS ON THE MARKET. THIS ABSOLUTELY STUNNING FLOOR PLAN HAS ALL THE UPGRADES YOU COULD POSSIBLY WANT. AS YOU ENTER THIS STUNNING STUCCO HOME THERE IS A COURTYARD WITH A FIREPLACE PERFECT FOR RELAXING. 5 BEDROOM / 4.5 BATH GREAT FOR. THE GOURMET KITCHEN HAS AN OVERSIZED ISLAND WITH CUSTOM\r\nCABINETS AND UNDERMOUNT LIGHTS.OPEN CONCEPT LIVINGROOM AREA, FEATURES SOARING CEILINGS. SELLER HAS ADDED A GORGEOUS TILED WALL W/AN ELECTRIC FIREPLACE AND CUSTOM BUILT- INS ALL AROUND. ENJOY YOUR LARGE COVERED PATIO AND OUTDOOR KITCHEN THRU YOUR GLASS SLIDING DOORS. LARGE DOWNSTAIRS PRIMARY SUITE WITH 2ND BEDROOM AND BATH PERFECT FOR GUEST OR MOTHER-N-LAW. A PRIVATE STUDY/OFFICE AND A FORMAL DINING ROOM. UPSTAIRS HAS A BALCONY OFF THE GAMEROOM, AS WELL AS 3 GREAT SIZE BEDROOMS WITH 2 BATHROOMS AND A LARGE MEDIA ROOM THAT HAS AN ATTACHED TEXAS BONUS ROOM. OVERSIZED BACKYARD PERFECT FOR A POOL AND FAMILY EVENTS. DONT MISS OUT!! SCHEDULE YOUR SHOWING TODAY!' ,`Acres` = '0.3202' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MERIDIANA SEC 5 (A0515 HT&BRR) BLK 1 LOT 17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13948' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Meridiana Sec 5 A0515 Ht&Brr' ,`TaxAmount` = '18689' ,`TaxRate` = '3.5849' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700689' WHERE `Matrix_Unique_ID` = '209791398' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T19:23:13.090' ,`MLSNumber` = '26659297' ,`ListAgentFullName` = 'Toni Berthia' ,`ListOfficeName` = 'Astute Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.662643' ,`Longitude` = '-95.345597' ,`PhotoCount` = '9' ,`PostalCode` = '77033' ,`RoomCount` = '3' ,`ListPrice` = '175000.00' ,`Status` = 'Active' ,`StreetName` = 'Larkspur' ,`StreetNumber` = '5147' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1310' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Property conveniently located near downtown and the Medical Center. Close to major freeways. Plenty of new construction in the area. This home sits on an oversized lot with a possibility of adding to the structure or an additional structure.' ,`Acres` = '0.3104' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 13 BLK 15 SUNNYSIDE GARDENS' ,`LotDesciption` = 'Other' ,`LotSize` = '13520' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WOODSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunnyside Gardens' ,`TaxAmount` = '1962' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700689' WHERE `Matrix_Unique_ID` = '210480369' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T19:30:15.663' ,`MLSNumber` = '752757' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.139581' ,`Longitude` = '-94.881770' ,`PhotoCount` = '23' ,`PostalCode` = '77535' ,`RoomCount` = '11' ,`ListPrice` = '399990.00' ,`Status` = 'Active' ,`StreetName` = 'CR 6615' ,`StreetNumber` = '73' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2667' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOW TAXES!!! 24 HOUR/7 DAYS A WEEK MANNED GUARD GATE!!!! NO FENCES HERE!!!!! Welcome home to your beautiful 2 Story, The Ascot Floor Plan with 4 bedrooms and 2.5 bathrooms with attached 3 CAR GARAGE. Additional features include a formal living room, a formal dining room, a kitchen adjoined to the breakfast nook which looks out onto the spacious family room, an oversized primary suite with a large walk-in closet in the Owner’s Retreat, an upstairs game room, and a convenient upstairs utility room. COVERED PATIO! COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Programmable Thermostat, PEX Hot & Cold Water Lines, Radiant Barrier, Aerobic Septic System, Community Well, and Vinyl Double Pane Low E Windows that open to the inside of the home for Cleaning. Do not wait! Call now for your private tour.' ,`Acres` = '0.689' ,`Area` = '52' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ENCINO ESTATES, SEC 2, BLOCK 8, LOT 7, ACRES 0.6890' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '30013' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (DAYTON)' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Encino Estates' ,`TaxAmount` = '609' ,`TaxRate` = '1.7512' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700689' WHERE `Matrix_Unique_ID` = '211274069' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T18:00:46.943' ,`MLSNumber` = '83913769' ,`ListAgentFullName` = 'Steven Snyder' ,`ListOfficeName` = 'Jane Byrd Properties INTL.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.941391' ,`Longitude` = '-95.274586' ,`PhotoCount` = '34' ,`PostalCode` = '75862' ,`RoomCount` = '5' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = 'Holly' ,`StreetNumber` = '615' ,`StreetSuffix` = 'Lane' ,`City` = 'Trinity' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2176' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Back on the market with Price Improvement!! Wonderful waterfront home in a quiet neighborhood that could be a great weekend retreat or even a full-time home. There are 3 bedrooms and 2 baths with TWO kitchens and TWO living areas, each upstairs and downstairs. Perfect for multiple-family use or get togethers at the lake! The upstairs also has a loft area currently being used as a bedroom. Outside boasts a large deck for entertaining and relaxing complete with a swingbed on the porch. There is also a workshop next to the house. Come see for yourself what this home has to offer your family! Home is being sold AS-IS. **Exercise caution when walking on decking down by the water**' ,`Acres` = '0.3373' ,`Area` = '42' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Stove' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '1' ,`Legal` = 'GLEN HAVEN ESTATES SECTION 2, BLOCK 11 LOT 33 1/2 OF,34' ,`LotDesciption` = 'Cleared,Subdivision Lot,Waterfront' ,`LotSize` = '14693' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '50' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (HEB)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Glen Haven Estates' ,`TaxAmount` = '3958' ,`TaxRate` = '1.8863' ,`WaterSewer` = 'Other Water/Sewer,Septic Tank' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700689' WHERE `Matrix_Unique_ID` = '211586657' --> Updated record success