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-03T16:27:35.247' ,`MLSNumber` = '86258166' ,`ListAgentFullName` = 'Kati Hall' ,`ListOfficeName` = 'RE/MAX On The Water - Bolivar' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.465535' ,`Longitude` = '-94.606157' ,`PhotoCount` = '13' ,`PostalCode` = '77650' ,`RoomCount` = '5' ,`ListPrice` = '850000.00' ,`Status` = 'Active' ,`StreetName` = 'Breaker' ,`StreetNumber` = '2630' ,`StreetSuffix` = 'Drive' ,`City` = 'Crystal Beach' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1792' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful New Construction located in Holiday Beach! This property offers one of a kind homes just walking distance to the beach! Enjoy the peaceful views on your large front porch! This home will offer custom style along with beach house views that will take your breath away. 3 Bedrooms along with a Game Room area and Bunk Room! Call today to get the detail\'s regarding this property! Photos represent a previous home built by the builder to show the same quality and style that will be used for this home.' ,`Acres` = '0.116' ,`Area` = '33' ,`BuilderName` = 'Easton Homes LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 65 B FRANKS SUR LOT 217 HOLIDAY BEACH' ,`LotDesciption` = 'Other' ,`LotSize` = '5051' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Holiday Beach' ,`TaxAmount` = '651' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Public Sewer,Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694078' WHERE `Matrix_Unique_ID` = '208414047' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T16:13:34.400' ,`MLSNumber` = '3050651' ,`ListAgentFullName` = 'Gerald Gonzalez' ,`ListOfficeName` = 'Lone Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.730329' ,`Longitude` = '-95.510739' ,`PhotoCount` = '13' ,`PostalCode` = '77063' ,`RoomCount` = '6' ,`ListPrice` = '625000.00' ,`Status` = 'Active' ,`StreetName` = 'Ann Arbor Dr' ,`StreetNumber` = '3202' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '2918' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming, luxurious, well-maintained property that has been renovated with fresh paint sits on one of the largest lots in the area and has a driveway that fits 11 cars!! Updated 2-story house. It has four bedrooms, 2.5 baths, and a 2-car garage with a large backyard and a covered patio/deck. It displays excellent curb appeal. The property is equipped with a primary bedroom and bathroom, and an entire room converted into a large open master closet with LOTS of custom shelving and drawers, a study/office, a family area, formal dining, a kitchen with breakfast room and bar, and a den and utility on the 1st floor. With the additional two beds (one room equipped with a small balcony), one full bath, on the 2nd floor! The kitchen has ample granite counter space, cabinets, and a food pantry and is open to the family room, Spacious bedrooms, and an extra kitchenette in the closed-in sunroom/gym area. Only minutes away from major highways, shopping, and dining, minutes from Galleria Area!!' ,`Acres` = '0.3316' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Briarmeadow/Tanglewilde' ,`HeatSystem` = 'Central Electric,Central Gas,Other Heating' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 13 BRIARMEADOW SEC 1' ,`LotDesciption` = 'Corner,Cul-De-Sac,Other' ,`LotSize` = '14446' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '723' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PINEY POINT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Other Style,Traditional' ,`Subdivision` = 'Briarmeadow Sec 01' ,`TaxAmount` = '11730' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694078' WHERE `Matrix_Unique_ID` = '209167376' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T16:50:50.387' ,`MLSNumber` = '53833503' ,`ListAgentFullName` = 'Sean Namli' ,`ListOfficeName` = 'Dr. Sean Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.548695' ,`Longitude` = '-95.750489' ,`PhotoCount` = '6' ,`PostalCode` = '77469' ,`RoomCount` = '7' ,`ListPrice` = '377990.00' ,`Status` = 'Active' ,`StreetName` = 'Sunbreeze Lane' ,`StreetNumber` = '7215' ,`StreetSuffix` = '' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2329' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Holden is a single story home with 4 bedrooms, 2 bathrooms, and a study. As you enter the home into the foyer, a hallway to your left will take you to the three, spacious, extra bedrooms, a large extra bathroom, and the open laundry room. Continuing down the foyer, into the home, you will enter the wide open living space with plenty of natural lighting. The spacious kitchen offers a large kitchen island, walk-in pantry, granite countertops, stainless steel appliances, and decorative tile backsplash. The kitchen island overlooks the large dining room and family room that faces the covered patio and backyard. This home provides plenty of open space, perfect for entertaining. The main bedroom, bedroom 1, and study are located at the back of the home, off the family room. Bedroom 1 offers lots of natural lighting, a large bathroom, and a spacious walk-in closet.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Sunese Crossing lot 32 blok-2 section-7' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'PHELAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunset Crossing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694079' WHERE `Matrix_Unique_ID` = '209701795' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T16:10:38.543' ,`MLSNumber` = '34961934' ,`ListAgentFullName` = 'Kristi Simmons' ,`ListOfficeName` = 'Re/Max Property Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.969681' ,`Longitude` = '-95.494071' ,`PhotoCount` = '26' ,`PostalCode` = '77066' ,`RoomCount` = '7' ,`ListPrice` = '245000.00' ,`Status` = 'Active' ,`StreetName` = 'Heritagestone' ,`StreetNumber` = '4250' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '4 bedroom and 2 1/2 bath home in Timber Meadow. UPDATED FLOORING downstairs. Open concept between the family, kitchen and dining area, great for entertaining or family nights. NO BACKYARD NEIGHBORS! Private backyard. Large primary with en-suite bathroom. Three secondary bedrooms upstairs with secondary bathroom and flex area. NEVER FLOODED. Great location, close to 249, beltway 8, shopping, restaurants, and entertainment.' ,`Acres` = '0.0959' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 1 TIMBER MEADOW SEC 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '4176' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KAISER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'WUNDERLICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Timber Mdw' ,`TaxAmount` = '3747' ,`TaxRate` = '2.3715' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694079' WHERE `Matrix_Unique_ID` = '210604248' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T16:22:30.817' ,`MLSNumber` = '75936546' ,`ListAgentFullName` = 'Kenneth Rodrick' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.808742' ,`Longitude` = '-95.477427' ,`PhotoCount` = '8' ,`PostalCode` = '77055' ,`RoomCount` = '3' ,`ListPrice` = '439000.00' ,`Status` = 'Active' ,`StreetName` = 'Thonig Rd Unit A' ,`StreetNumber` = '2022' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1859' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous new construction by oVL Construction in Spring Branch area! There are so many thoughtful elements incorporated in these skillfully drawn floorplans & they are the best built homes in this price range that you will find! You will be impressed by the quality craftsmanship that goes into each of these four new homes including custom-built kitchens w/quartz worktops, SS appliances, a powder room & lots of storage in addition to the wide windows for tons of natural light. There is an option to upgrade to a premium finish package, which includes a custom dry bar feature, wine storage & a wine refrigerator. The 2nd level is similarly remarkable, featuring a large master bedroom, gorgeous master bathroom, custom walk-in closet & two additional bedrooms. Bonus small back yard space! Even the most discerning buyers will appreciate the attention to detail & high standard quality of work in these homes. Included 1/2/10 warranty. Be sure to ask about and upgrade options!' ,`Acres` = '' ,`Area` = '24' ,`BuilderName` = 'oVL Construction' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 THONIG TRACT' ,`LotDesciption` = 'Other' ,`LotSize` = '2130' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'TREASURE FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Thonig Villas' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694079' WHERE `Matrix_Unique_ID` = '210730667' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T16:27:18.290' ,`MLSNumber` = '43974482' ,`ListAgentFullName` = 'Hector Reyes' ,`ListOfficeName` = 'PROXY REALTY, INC.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.665972' ,`Longitude` = '-95.293539' ,`PhotoCount` = '29' ,`PostalCode` = '77061' ,`RoomCount` = '8' ,`ListPrice` = '895000.00' ,`Status` = 'Active' ,`StreetName` = 'Santa Fe' ,`StreetNumber` = '7432' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4465' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come tour this beautiful brick home in Garden Villas built in 2007. Large lot and 4465 sqft of living space. Home has an office and a media room, can either remain or it can easily be 6 bedrooms. Great for gatherings. Each room has its own restroom. Large inground pool and huge open garage. There are 3 showers and a full bath for your pool parties. Home is gated. Great for your large and even for a vacation gateaway investment.' ,`Acres` = '0.7107' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 20 BLK 4 GARDEN VILLAS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '30960' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GARDEN VILLAS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HARTMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Garden Villas' ,`TaxAmount` = '14277' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694079' WHERE `Matrix_Unique_ID` = '210754692' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T17:14:50.733' ,`MLSNumber` = '77702357' ,`ListAgentFullName` = 'Emilie Hamby' ,`ListOfficeName` = 'Coldwell Banker D\'Ann Harper' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.064235' ,`Longitude` = '-95.130236' ,`PhotoCount` = '48' ,`PostalCode` = '77336' ,`RoomCount` = '9' ,`ListPrice` = '649000.00' ,`Status` = 'Active' ,`StreetName` = 'Redwood Cliff' ,`StreetNumber` = '28506' ,`StreetSuffix` = 'Lane' ,`City` = 'Huffman' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2822' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful and Serene Country Home w/city conveniences in highly desired waterway section of the Commons! This immaculate 2015, 1 story, 4 BDRM/3 BATH Signorelli Custom home has all the bells and whistles incl private elec double gate in driveway! Enjoy morning coffee sitting on the front porch, and evenings cooling off in the sparkling pool w/fountains and beautiful waterfall. Chefs kitchen includes gas cooking, granite counters, custom cabinets, and s/s appliances. You won’t find any carpet in this home--wood like tile flooring along with fireplace in family room. Lg 4TH BDRM can serve as a 2ND MASTER or Game Room. Sep dining room and office. Master suite has crown molding, bath has dbl granite vanities, glass shower & tub. Backyard oasis has outdoor kitchen, cov patio, and many trees. Nearby shopping off newly developed Grand Pkwy-SH99, 45 min to IAH airport. The Commons offers private lake access w/boat ramp, fishing pier, horse trails, parks and pavilion. This home won’t last long!' ,`Acres` = '0.7861' ,`Area` = '' ,`BuilderName` = 'Signorelli' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas,Propane' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 4 COMMONS WATERWAY SEC 7' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '34244' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = '' ,`SchoolHigh` = '' ,`SchoolMiddle` = '' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Commons Waterway Sec 7' ,`TaxAmount` = '12271' ,`TaxRate` = '3.2592' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694079' WHERE `Matrix_Unique_ID` = '210863922' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T17:26:21.027' ,`MLSNumber` = '88121293' ,`ListAgentFullName` = 'Emily Lopez' ,`ListOfficeName` = 'Near Town Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.689038' ,`Longitude` = '-95.183190' ,`PhotoCount` = '25' ,`PostalCode` = '77502' ,`RoomCount` = '6' ,`ListPrice` = '244900.00' ,`Status` = 'Active' ,`StreetName` = 'Martha' ,`StreetNumber` = '2109' ,`StreetSuffix` = 'Lane' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1600' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Incrediblly updated property in an open-concept style. Beautiful new flooring throughout. Attractive carpet in bedrooms. Brand new applicances in kitchen with granite countertops. New LED light system installed. Tile in bathrooms and kitchen. All new doors throughout the home. Freshly painted interior and exterior in appealing colors. Great curb appeal!' ,`Acres` = '0.1446' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 10 BLK 1 CLEAR BROOK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'MAE SMYTHE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SAM RAYBURN HIGH SCHOOL' ,`SchoolMiddle` = 'SOUTHMORE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Clear Brook' ,`TaxAmount` = '3908' ,`TaxRate` = '2.6514' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694079' WHERE `Matrix_Unique_ID` = '210924422' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T17:55:29.083' ,`MLSNumber` = '516440' ,`ListAgentFullName` = 'Jaimie Harvey' ,`ListOfficeName` = 'United Country JW Realty and' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.851103' ,`Longitude` = '-94.406428' ,`PhotoCount` = '43' ,`PostalCode` = '77665' ,`RoomCount` = '3' ,`ListPrice` = '999000.00' ,`Status` = 'Active' ,`StreetName` = 'Bancroft' ,`StreetNumber` = '1135' ,`StreetSuffix` = 'Road' ,`City` = 'Winnie' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '3575' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Beautiful estate is built for anyone who loves to entertain and have a good time, the patio and outdoor kitchen is definitely the main attraction of the property.  \r\n\r\nThe home is over 3,500 sq feet with large living spaces and an additional kitchen, double oven, and subzero fridge, when guests come over with food that needs to be prepared or warmed you will have the space to be able to accommodate everyone.  There is over 6,200 sq feet under roof.\r\n\r\nThe Home has 3 bedrooms however one room is currently being used as an office, the master suite is breathtaking, the master bathroom has ceiling-to-floor windows that overlook the secluded Outdoor area, and from the master suite, you can walk out to the covered hot-tub or sit in the steam room.  \r\n\r\nThis home is remarkable and classy and has tons of character, it has a custom Wine Cooler in the Living area that is Beautiful.' ,`Acres` = '4' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Chambers County East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '11-60-3-2 WINNIE SUBURBS 4 acres only' ,`LotDesciption` = 'Cleared' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '18 - East Chambers' ,`SchoolElementary` = 'EAST CHAMBERS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'EAST CHAMBERS HIGH SCHOOL' ,`SchoolMiddle` = 'EAST CHAMBERS J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Spanish' ,`Subdivision` = 'Winnie Suburbs Sub' ,`TaxAmount` = '7454' ,`TaxRate` = '2.1546' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663694079' WHERE `Matrix_Unique_ID` = '211012663' --> Updated record success