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-11T14:43:22.747' ,`MLSNumber` = '83261164' ,`ListAgentFullName` = 'Angel Armadillo-Macias' ,`ListOfficeName` = 'RE/MAX American Dream' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.691173' ,`Longitude` = '-95.345486' ,`PhotoCount` = '28' ,`PostalCode` = '77021' ,`RoomCount` = '3' ,`ListPrice` = '185000.00' ,`Status` = 'Active' ,`StreetName` = 'Kelso' ,`StreetNumber` = '4910' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1132' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investment Opportunity!!! Tenant occupied until 6/2023. Located only minutes from the medical center, downtown Houston, University of Houston, Texas Southern University and NRG stadium. Beautifully updated home features a large living area that opens up into a lovely appointed dining and kitchen area and a bonus room or additional bedroom! New Roof and Central Heating and Air installed August 2021. PLEASE DO NOT DISTURB TENANT.' ,`Acres` = '0.1515' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'W 57 FT OF LT 289 & E 3 FT OF LT 290 BLK 11 MACGREGOR TERRAC' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HARTSFIELD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,No Photos/No Videos,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Macgregor Terrace Sec 01' ,`TaxAmount` = '2223' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1952' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697154' WHERE `Matrix_Unique_ID` = '206784343' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T14:15:18.480' ,`MLSNumber` = '47589309' ,`ListAgentFullName` = 'Arlene Hinsley' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.614909' ,`Longitude` = '-95.794058' ,`PhotoCount` = '47' ,`PostalCode` = '77406' ,`RoomCount` = '12' ,`ListPrice` = '1550000.00' ,`Status` = 'Active' ,`StreetName` = 'River Forest' ,`StreetNumber` = '3606' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '6014' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GATED private European/English Tudor estate embraces the wooded 2.57 acre LAKEfront lot in River Forest to offer an amazing one of a kind residence.The exterior boasts a brick/masonry/stucco elevation,whole-house GENERATOR , driveway GATE, circle drive, porte-cochere, 3.5 car garage, extensive trees, gardens, & expansive back patio.The interior features truss & beam ceilings, crown moldings, coffered/high ceiling, built-ins, hardwood floors, formal dining & living room, butler\'s panty w/ a catering/spice kitchen, elevator capable, all bedrooms w/ en-suite baths, a private balcony off the Primary bedroom, upstairs office area w/ adjoining sitting room/den, & generous gameroom/media room ready to entertain. The kitchen features a SUB-ZERO refrigerator/freezer, separate ICE MAKER, 36\' Wolf GAS range, hammered copper vent hood, newly expanded & painted cabinets open to the breakfast room & keeping room. A spacious home w/ attention to small details. Never flooded/elevation cert. in docs' ,`Acres` = '2.572' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'RIVER FOREST SEC 2, BLOCK 1, LOT 4, ACRES 2.572' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View,Waterfront,Wooded' ,`LotSize` = '112036' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '659' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Left Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'English,French,Traditional' ,`Subdivision` = 'River Forest Sec 2' ,`TaxAmount` = '18661' ,`TaxRate` = '1.6948' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697154' WHERE `Matrix_Unique_ID` = '208040218' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T14:38:56.120' ,`MLSNumber` = '23291362' ,`ListAgentFullName` = 'Nancy Lawrence' ,`ListOfficeName` = 'Lawrence Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.489446' ,`Longitude` = '-95.481204' ,`PhotoCount` = '22' ,`PostalCode` = '75844' ,`RoomCount` = '3' ,`ListPrice` = '224000.00' ,`Status` = 'Active' ,`StreetName` = 'Maple' ,`StreetNumber` = '402' ,`StreetSuffix` = 'Street' ,`City` = 'Grapeland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1642' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEAT AS A PIN! \r\n Except to be impressed when you visit this brick home situated on two tree-shaded lots in downtown Grapeland. This three bedroom, two bath home has been updated with new lighting, newly painted interior, new flooring, and a new roof. Laminate flooring spreads through the entire house all the way to attached single car garage and laundry room. All stainless-steel appliances will convey with the sale of the property. Located just minutes from the Grapeland school, this home is convenient to educators as well as parents looking to enroll children in the upcoming school year. Give us a call today to schedule a private tour.' ,`Acres` = '0.258' ,`Area` = '41' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Grapeland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'GRAPELAND LOT 11-12 BLK 11' ,`LotDesciption` = 'Corner' ,`LotSize` = '11238' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '58 - Grapeland' ,`SchoolElementary` = 'GRAPELAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAPELAND HIGH SCHOOL' ,`SchoolMiddle` = 'GRAPELAND JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'NA' ,`TaxAmount` = '2055' ,`TaxRate` = '2.1104' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697154' WHERE `Matrix_Unique_ID` = '208317511' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T15:55:22.563' ,`MLSNumber` = '36471393' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Olaiwola Taiwo' ,`SellingOfficeName` = 'Prime Focus Realty' ,`Latitude` = '30.201035' ,`Longitude` = '-95.337547' ,`PhotoCount` = '28' ,`PostalCode` = '77302' ,`RoomCount` = '17' ,`ListPrice` = '629981.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Berry Brook' ,`StreetNumber` = '14992' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Asher V, Elevation A) CURRENTLY BEING BUILT. Two story. 5 bedrooms. 4.5 baths. Elegant double front door entry, family room, informal dining room and study. Spacious island kitchen open to family room. Primary suite with large double walk-in closets and secondary bedroom on first floor. Three additional bedrooms, spacious game room and media room on second floor. Attached 3-car tandem garage. Artavia, a master-planned community, will thrill you with endless possibilities just minutes from your home in Conroe, Texas. You’ll enjoy wide, outdoor spaces great for an active lifestyle and its convenient location. Onsite school is currently under construction! Stop by the Westin Homes model home today to find out more about Artavia!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BLOCK 2, LOT 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9106' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '985' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Artavia' ,`TaxAmount` = '' ,`TaxRate` = '3.26' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697154' WHERE `Matrix_Unique_ID` = '208896761' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T15:57:33.343' ,`MLSNumber` = '50390363' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Almas Abdullah' ,`SellingOfficeName` = 'NextHome Fine Properties' ,`Latitude` = '29.683634' ,`Longitude` = '-95.835722' ,`PhotoCount` = '5' ,`PostalCode` = '77406' ,`RoomCount` = '15' ,`ListPrice` = '569434.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Alina Brook' ,`StreetNumber` = '10723' ,`StreetSuffix` = 'Trace' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3125' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Alden II, Elevation A) CURRENTLY BEING BUILT. Two story. 4 bedrooms. 3.5 baths. Family room, Living room/Study and Dining room. Spacious island kitchen open to Family room. Primary suite with large walk-in closet. Three additional bedrooms, spacious Game room, and media room on second floor. Covered patio and 2 car garage. Candela offers new homes for sale in Richmond, Texas. The community is the perfect combination of small-town charm and easy access to big city conveniences. Take a stroll through Downtown Historic Richmond, visit the Imperial Farmer\'s Market and enjoy the great outdoors at Brazos Bend State Park. Major employers in Houston, Katy and Sugar Land are only a short commute away. Great restaurants, and local and big box retail offerings are all close by. Visit Candela today to find your new home!' ,`Acres` = '0.1629' ,`Area` = '37' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BLOCK 1, LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7095' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BENTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Candela' ,`TaxAmount` = '' ,`TaxRate` = '3.15' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697154' WHERE `Matrix_Unique_ID` = '208981281' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T15:52:00.777' ,`MLSNumber` = '97739541' ,`ListAgentFullName` = 'Patrick Burbridge' ,`ListOfficeName` = 'CitiQuest Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.851582' ,`Longitude` = '-95.433759' ,`PhotoCount` = '33' ,`PostalCode` = '77091' ,`RoomCount` = '7' ,`ListPrice` = '379900.00' ,`Status` = 'Active' ,`StreetName` = 'Weathersby' ,`StreetNumber` = '5902' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1780' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNDER CONSTRUCTION! CORNER UNIT! MOVE-IN READY by October 2022. Gorgeous new construction by Disama Group. This stunning three-story home offers an open concept floor plan with the living area on the second floor and 3 bedrooms on the third floor. It\'s unique first floor offers a spacious home office/study on the first floor. Upgraded finishes throughout including smart home system, quartz counter tops, stainless-steel appliances, upgraded cabinets with soft close drawers. Enjoy this beautiful home located just minutes away from Downtown Houston, Galleria, City Centre. Easy access to I-45, 610 & 290. \r\nPhotos from another home by Disama Group. LAYOUT, FINISHES AND SELECTION WILL VARY!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Disama Group' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lt 1 Blk 1' ,`LotDesciption` = 'Corner,Patio Lot,Subdivision Lot' ,`LotSize` = '2210' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'ANDERSON ACADEMY' ,`SchoolHigh` = 'CARVER H S FOR APPLIED TECH/ENGINEERING/ARTS' ,`SchoolMiddle` = 'DREW ACADEMY' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland Landing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697154' WHERE `Matrix_Unique_ID` = '209682218' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T14:52:05.347' ,`MLSNumber` = '19649579' ,`ListAgentFullName` = 'Patrick Poteet' ,`ListOfficeName` = 'Patrick Poteet Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.697052' ,`Longitude` = '-96.781145' ,`PhotoCount` = '18' ,`PostalCode` = '78962' ,`RoomCount` = '8' ,`ListPrice` = '199900.00' ,`Status` = 'Active' ,`StreetName` = 'South' ,`StreetNumber` = '106' ,`StreetSuffix` = 'Street' ,`City` = 'Weimar' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2766' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This giant custom-built home is ready for a new updated look. The home sits on almost an acre, you can tell it was a real looker at one time but needs a total makeover, just lipstick probably won\'t get it. For all those owner investors looking for the next project, here it is. There also may be an opportunity to add a couple more houses to the adjacent land or even a small multi-family. The property has full city utilities including gas.' ,`Acres` = '0.967' ,`Area` = '56' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A-4 H AUSTIN BLK 104 WEIMAR .967 AC HOUSE & BLDGS' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '42123' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '203 - Weimar' ,`SchoolElementary` = 'WEIMAR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WEIMAR HIGH SCHOOL' ,`SchoolMiddle` = 'WEIMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Weimar' ,`TaxAmount` = '3489' ,`TaxRate` = '1.9586' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697155' WHERE `Matrix_Unique_ID` = '209753484' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T15:37:51.910' ,`MLSNumber` = '74118340' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.072199' ,`Longitude` = '-95.617482' ,`PhotoCount` = '22' ,`PostalCode` = '77375' ,`RoomCount` = '4' ,`ListPrice` = '400155.00' ,`Status` = 'Active' ,`StreetName` = 'Bristlecone' ,`StreetNumber` = '2218' ,`StreetSuffix` = 'Circle' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2067' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready December 2022! Enjoy dinner outside on the covered back patio. Linen cabinets with white-toned quartz countertops, beige tone EVP flooring with dark gray tweed carpet in our Balanced package. Whether you’re headed to work or for a night out, Cherry Pines is just minutes away from premier retail, restaurants, and employment centers. Send the kids to school in the sought-after Tomball school district and enjoy weekends at the future pool and playground. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '14' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0347 Plan L402D' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TOMBALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cherry Pines' ,`TaxAmount` = '' ,`TaxRate` = '2.46' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697155' WHERE `Matrix_Unique_ID` = '209916312' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T15:57:13.250' ,`MLSNumber` = '43549001' ,`ListAgentFullName` = 'Kayla Hayden' ,`ListOfficeName` = 'Top Guns Realty on Lake Conroe' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.943886' ,`Longitude` = '-95.912061' ,`PhotoCount` = '40' ,`PostalCode` = '77864' ,`RoomCount` = '14' ,`ListPrice` = '395000.00' ,`Status` = 'Active' ,`StreetName` = 'Elm' ,`StreetNumber` = '710' ,`StreetSuffix` = 'Street' ,`City` = 'Madisonville' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '3392' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Large house on a Large Lot! This antique home fully remodeled is full of character and boasts 6 bedrooms with 4 bathrooms or 5-bedrooms, 1-office and is located in the heart of Madisonville on 1.806 acres. The large rooms and big backyard makes it the perfect place for a big family! This corner house is just located around the bend from the hospital, also surrounded by residential and commercial properties makes for a prime location. Call the Wells Team today to schedule your showing!' ,`Acres` = '1.8061' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Madisonville Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0010 JOB S COLLARD TRACT 561 1.806 ACRES' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '78675' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '175 - Madisonville Consolidated' ,`SchoolElementary` = 'MADISONVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MADISONVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MADISONVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Victorian' ,`Subdivision` = 'J S Collard Surv A-10' ,`TaxAmount` = '4713' ,`TaxRate` = '2.4226' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697155' WHERE `Matrix_Unique_ID` = '210182198' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T14:50:42.157' ,`MLSNumber` = '63345857' ,`ListAgentFullName` = 'Timothy Williams' ,`ListOfficeName` = 'Keller Williams SoutheastTexas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.139150' ,`Longitude` = '-94.013062' ,`PhotoCount` = '33' ,`PostalCode` = '77662' ,`RoomCount` = '7' ,`ListPrice` = '195000.00' ,`Status` = 'Active' ,`StreetName` = 'Crestview' ,`StreetNumber` = '1390' ,`StreetSuffix` = 'Drive' ,`City` = 'Vidor' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1440' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Updated Farmhouse Style Interior with Shiplap is a Must See! Did NOT Flood! The Kitchen Features Granite Countertops with Tile Backsplash, Breakfast Bar with Custom Pendant Lighting, Sink with Pull-Down Sprayer Faucet, 6-Burner Gas Stove and Dishwasher. The Living Room Features White Shiplap Walls, Wood-Style Ceramic Tile Flooring and is Open to the Dining Area that also features the White Shiplap and a Chandelier. The Master Bedroom includes Cozy Carpet and an En Suite Bathroom including a Tub/Shower Combo with Tile Surround. Additional Amenities include 2 More Bedrooms, a Main Bathroom with a Tub/Shower Combo and an Inside Laundry Room. Double Doors lead to the Spacious, Fenced Backyard with a 320 sq ft storage building. New Water Heater. New A/C Ducts. New Roof 2021. Upgraded Electrical Panel 2021. New Windows 2021. New Outside HVAC Unit 2020. New Make your appointment to see today!' ,`Acres` = '0.295' ,`Area` = '50' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 15 & W 5\'OF 16 BLK 5 GREEN FOREST #4' ,`LotDesciption` = 'Cleared' ,`LotSize` = '12850' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1005 - Vidor' ,`SchoolElementary` = 'VIDOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'VIDOR HIGH SCHOOL' ,`SchoolMiddle` = 'VIDOR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Green Forest # 1-6' ,`TaxAmount` = '3285' ,`TaxRate` = '2.9308' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697155' WHERE `Matrix_Unique_ID` = '210374772' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T15:54:22.517' ,`MLSNumber` = '59124782' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.071725' ,`Longitude` = '-95.616526' ,`PhotoCount` = '24' ,`PostalCode` = '77375' ,`RoomCount` = '6' ,`ListPrice` = '405205.00' ,`Status` = 'Active' ,`StreetName` = 'Everpine' ,`StreetNumber` = '13110' ,`StreetSuffix` = 'Trail' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2336' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready January 2023! Unwind in the private main floor primary suite, complete with a sizeable walk-in closet and bath. Linen cabinets with white/grey granite countertops, brown grey EVP flooring with multi-tone carpet in our Fresh package. Whether you’re headed to work or for a night out, Cherry Pines is just minutes away from premier retail, restaurants, and employment centers. Send the kids to school in the sought-after Tomball school district and enjoy weekends at the future pool and playground. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '14' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0353 Plan 870C' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TOMBALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cherry Pines' ,`TaxAmount` = '' ,`TaxRate` = '2.4' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697155' WHERE `Matrix_Unique_ID` = '210572493' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T15:29:54.877' ,`MLSNumber` = '60946351' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.071725' ,`Longitude` = '-95.616817' ,`PhotoCount` = '23' ,`PostalCode` = '77375' ,`RoomCount` = '4' ,`ListPrice` = '395840.00' ,`Status` = 'Active' ,`StreetName` = 'Everpine' ,`StreetNumber` = '13107' ,`StreetSuffix` = 'Trail' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2067' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready December 2022! Enjoy dinner outside on the covered back patio. Linen cabinets with white-toned quartz countertops, beige tone EVP flooring with dark gray tweed carpet in our Elemental package. Whether you’re headed to work or for a night out, Cherry Pines is just minutes away from premier retail, restaurants, and employment centers. Send the kids to school in the sought-after Tomball school district and enjoy weekends at the future pool and playground. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '14' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0286 Plan L402B' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TOMBALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cherry Pines' ,`TaxAmount` = '' ,`TaxRate` = '2.46' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697155' WHERE `Matrix_Unique_ID` = '210573593' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T15:48:51.117' ,`MLSNumber` = '68485998' ,`ListAgentFullName` = 'Sam Masoudi' ,`ListOfficeName` = 'Houston Homeland' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.814639' ,`Longitude` = '-95.533855' ,`PhotoCount` = '27' ,`PostalCode` = '77080' ,`RoomCount` = '8' ,`ListPrice` = '675000.00' ,`Status` = 'Active' ,`StreetName` = 'Moorberry' ,`StreetNumber` = '9527' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2625' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This modern home is out in the charming Spring Shadows neighborhood. It features large 8,800 sf lot, slurried brick exterior, open floor plan, massive kitchen and living area with 4 bedrooms, 2 full bathrooms. This home includes custom site-built cabinets with soft-close hardware, Granite countertops, wood floors in all rooms (no carpet), fresh paint (inside and out), new stainless steel appliances and high-end fixtures throughout. Near great parks, trails, activities, dining options, great schools, and entertainment options.' ,`Acres` = '0.202' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 9A SPRING SHADOWS SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '336' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'SPRING SHADOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING WOODS MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Spring Shadows Sec 05' ,`TaxAmount` = '9917' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697155' WHERE `Matrix_Unique_ID` = '210608305' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T15:25:42.697' ,`MLSNumber` = '44319416' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.073935' ,`Longitude` = '-95.617750' ,`PhotoCount` = '22' ,`PostalCode` = '77375' ,`RoomCount` = '4' ,`ListPrice` = '394980.00' ,`Status` = 'Active' ,`StreetName` = 'Cherryvale' ,`StreetNumber` = '2235' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2067' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready January 2023! Enjoy dinner outside on the covered back patio. Indoors, the open concept kitchen flows seamlessly into the dining and family rooms. The versatile flex space makes a great office or game room. Whether you’re headed to work or for a night out, Cherry Pines is just minutes away from premier retail, restaurants, and employment centers. Send the kids to school in the sought-after Tomball school district and enjoy weekends at the future pool and playground. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '14' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0281 Plan L402C' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TOMBALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cherry Pines' ,`TaxAmount` = '' ,`TaxRate` = '2.46' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697156' WHERE `Matrix_Unique_ID` = '210772599' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T15:59:36.990' ,`MLSNumber` = '52973354' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.073304' ,`Longitude` = '-95.617760' ,`PhotoCount` = '23' ,`PostalCode` = '77375' ,`RoomCount` = '4' ,`ListPrice` = '407930.00' ,`Status` = 'Active' ,`StreetName` = 'Cherryvale' ,`StreetNumber` = '2203' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2067' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready January 2023! Fresh interior pkg - Jasmine white quartz countertops, Stone cabinet, soft white, oversized, textured subway tile backsplash. Wood look tile flooring. Enjoy dinner outside on the covered back patio. Indoors, the open concept kitchen flows seamlessly into the dining and family rooms. The versatile flex space makes a great office or game room. Whether you’re headed to work or for a night out, Cherry Pines is just minutes away from premier retail, restaurants, and employment centers. Send the kids to school in the sought-after Tomball school district and enjoy weekends at the future pool and playground. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '14' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0273 Plan L402C' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TOMBALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cherry Pines' ,`TaxAmount` = '' ,`TaxRate` = '2.46' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697156' WHERE `Matrix_Unique_ID` = '210777233' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T14:45:19.777' ,`MLSNumber` = '73042090' ,`ListAgentFullName` = 'Shanna Medeiros' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.536263' ,`Longitude` = '-94.928826' ,`PhotoCount` = '50' ,`PostalCode` = '77371' ,`RoomCount` = '12' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Thomas Castleberry' ,`StreetNumber` = '803' ,`StreetSuffix` = 'Road' ,`City` = 'Shepherd' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Need a Country Property that has space for everyone? Just SOUTH of Livingston sits this beautiful Property w/ over 3408 square footage combined on 11.5 acres UNRESTRICTED. The MAIN Barndominium (2400sqft) home has the most amazing use of Large Spaces & needs just a few finishing touches. 2Bedrooms & 2Full Baths, Large Family Room w/ Open Living Concept, Formal Dining & a Large Utility room & Fenced Backyard. Follow the stairs to the additional space where the possibilities are endless w/ Approximately 1200sf Area if finished out. The SECOND (1008sqft) home features a 2Bedrooms, 2Baths in this Brand new General Shelter. 60x60 Fenced Area for Chickens, Turkey, Ducks. Get ready to leave the stress & simply enjoy the outdoors. You need to see this one in person!! Come live the peaceful pace of Shepherd, Texas w/a short drive to Lake Livingston & Kingwood & IAH Airport. Peaceful country living! Well-Septic-Low Taxes. Call us to schedule your showing. Shepherd ISD*Horses Allowed' ,`Acres` = '11.5139' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Reports Available,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Coldspring/South San Jacinto County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'THOMAS-CASTLEBERRY ROAD SUBD., LOT PART OF 15, ACRES 11.5139' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '501545' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '130 - Shepherd' ,`SchoolElementary` = 'SHEPHERD PRIMARY SCHOOL' ,`SchoolHigh` = 'SHEPHERD HIGH SCHOOL' ,`SchoolMiddle` = 'SHEPHERD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,No Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1.5' ,`Style` = 'Barndominium,Traditional' ,`Subdivision` = 'Thomas-Castleberry Road Sub' ,`TaxAmount` = '6143' ,`TaxRate` = '1.8509' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697156' WHERE `Matrix_Unique_ID` = '211052465' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T15:20:28.880' ,`MLSNumber` = '78629830' ,`ListAgentFullName` = 'Dianne Stone' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.061604' ,`Longitude` = '-95.433398' ,`PhotoCount` = '29' ,`PostalCode` = '77566' ,`RoomCount` = '7' ,`ListPrice` = '355000.00' ,`Status` = 'Active' ,`StreetName` = 'Thyme' ,`StreetNumber` = '112' ,`StreetSuffix` = 'Trail' ,`City` = 'Lake Jackson' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2466' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! You’ll have room to grow in this 4-bed, 2.5 bath home with an additional large flex room upstairs. Located on a quiet cul-de-sac in Plantation Oaks subdivision, this home offers the new owners plenty of extras, such as tile flooring in the main areas, a spacious living and dining room PLUS a cute breakfast nook. The kitchen features a 5-burner gas range, microwave, dishwasher, instant hot water dispenser, water softener and a walk-in pantry. The laundry room has cabinets and folding area. Each room offers beautiful natural light. The bedrooms have plenty of closet room with organization add-ons, as well as an abundance of space. Check out the flex room with balcony! Outside, you’ll enjoy a recently added covered porch for morning coffee and evening entertaining. Recent roof, Hardi plank siding, second floor HVAC, LED lightening, smart Nest C0/smoke detectors, & digital thermostats. Washer, dryer and refrigerator to convey with acceptable offer. Come take a look!' ,`Acres` = '0.1928' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Jackson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'PLANTATION OAKS SEC 3 (LAKE JACKSON) BLK 5 LOT 19' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8398' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'BRANNEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE JACKSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Plantation Oaks Sec 3 Lake Ja' ,`TaxAmount` = '6407' ,`TaxRate` = '2.3371' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697156' WHERE `Matrix_Unique_ID` = '211132021' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T14:12:42.940' ,`MLSNumber` = '65627659' ,`ListAgentFullName` = 'John Mai' ,`ListOfficeName` = 'Altus Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.132990' ,`Longitude` = '-95.058215' ,`PhotoCount` = '24' ,`PostalCode` = '77554' ,`RoomCount` = '8' ,`ListPrice` = '835000.00' ,`Status` = 'Active' ,`StreetName` = 'Miramar' ,`StreetNumber` = '22903' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '3214' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Customer built with open premium floor plan and Lots of personal upgrades! Vacation Home!!!Private walking staircase to main floor. Two lots combine premium existing lot!! The house is fully furnished with all appliances, TV, and furnitures. Huge master bedroom with private balcony and wood fired place. 14 feet above ground, exquisite cargo lift and spiral staircase to go up first floor. Custom cat5 every room, Pre-wired entertainment in living room and security throughout house. premium trex decking throughout house to view beach side and bay side. Subdivision has private public pool, fishing, and outdoor boat ramp! Soaring crown molding ceiling with chandelier and custom granite counters, water softener, 5 tons energy efficiency A/C. Private security surround house included. Agent is related owner. Ready to move in !!' ,`Acres` = '0.2838' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 HALL & JONES SUR LOTS 140 & 141 (141-0) TERRAMAR BE' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '12362' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Back' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Terramar Sec 7' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663697156' WHERE `Matrix_Unique_ID` = '211236706' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T14:03:05.553' ,`MLSNumber` = '94857786' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.736438' ,`Longitude` = '-95.257810' ,`PhotoCount` = '16' ,`PostalCode` = '77029' ,`RoomCount` = '3' ,`ListPrice` = '238990.00' ,`Status` = 'Active' ,`StreetName` = 'Armstrong St' ,`StreetNumber` = '214' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1298' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# - Built by Ameritex Homes - November completion! ~ Beautiful new home for sale featuring 3 bedrooms, 2 bathrooms, an open concept floor plan and many more modern amenities throughout. The kitchen boasts a large island with upgraded countertops and energy-efficient appliances. Private master includes ensuite bathroom and walk-in closet. Smart home technology like a programmable thermostat, keyless smart locks connected and secured through a smart home hub comes standard. All these features and more make this home is a must see! Images may be reflective of a staged or representative unit; homes are unfurnished and features may vary by floor plan and location.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Ameritex Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 13 BLK 7 CLINTON PARK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5634' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PLEASANTVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FURR HIGH SCHOOL' ,`SchoolMiddle` = 'HOLLAND MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Clinton Park' ,`TaxAmount` = '' ,`TaxRate` = '0' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697156' WHERE `Matrix_Unique_ID` = '211311471' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T14:53:55.573' ,`MLSNumber` = '79121284' ,`ListAgentFullName` = 'Shamin Patel' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.540014' ,`Longitude` = '-95.692382' ,`PhotoCount` = '15' ,`PostalCode` = '77469' ,`RoomCount` = '7' ,`ListPrice` = '254999.00' ,`Status` = 'Active' ,`StreetName` = 'Tara Plantation' ,`StreetNumber` = '302' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1344' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home will not last long! ** Investor Friendly** This spectacular one story home was recently renovated with engineered bamboo flooring, a new vent hood, and granite countertops in the kitchen. The spa-like bath has been updated. Large backyard with no back neighbors. Home is not in flood zone and did not flood during Harvey. Home is zoned to great schools and is located near plenty of shopping and dining.' ,`Acres` = '0.1637' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TARA SEC 1, BLOCK 6, LOT 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7130' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'VELASQUEZ ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tara Sec 1' ,`TaxAmount` = '3657' ,`TaxRate` = '2.2923' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697156' WHERE `Matrix_Unique_ID` = '211313258' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T15:04:20.990' ,`MLSNumber` = '93565699' ,`ListAgentFullName` = 'Phillip Mason' ,`ListOfficeName` = 'Adriatico & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.658179' ,`Longitude` = '-95.529855' ,`PhotoCount` = '20' ,`PostalCode` = '77031' ,`RoomCount` = '4' ,`ListPrice` = '260000.00' ,`Status` = 'Active' ,`StreetName` = 'San Rocco' ,`StreetNumber` = '8703' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1393' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in a gated and growing community. This property has a very large primary bedroom with lots of natural lighting. This is a prime location, with a great commute to Medical Center, downtown, Sugar Land, Missouri City, Stafford, NRG, and 90. Buyer is to verify bedroom dimension.' ,`Acres` = '0.0568' ,`Area` = '20' ,`BuilderName` = 'A C Home' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 4 VENETIAN LUXURY HOMES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2475' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'VALLEY WEST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHARPSTOWN HIGH SCHOOL' ,`SchoolMiddle` = 'WELCH MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Mediterranean' ,`Subdivision` = 'Venetian' ,`TaxAmount` = '4125' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697157' WHERE `Matrix_Unique_ID` = '211317664' --> Updated record success