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-09T12:36:59.897' ,`MLSNumber` = '41361581' ,`ListAgentFullName` = 'Marilyn Shockley' ,`ListOfficeName` = 'Century 21 Olympian LakeJackson' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.899617' ,`Longitude` = '-95.494139' ,`PhotoCount` = '22' ,`PostalCode` = '77422' ,`RoomCount` = '9' ,`ListPrice` = '169995.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 469' ,`StreetNumber` = '5107' ,`StreetSuffix` = '' ,`City` = 'Brazoria' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1568' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'County living in a unique San Bernard River subdivision. Double-wide mobile home on a slab. Large Living room, Kitchen/Dining combo with an island cabinet, and lots of cabinets for storage. All appliances stay, including the washer and dryer! The primary bedroom suite features a large walk-in Closet garden tub & separate shower. Wood Deck along the front to enjoy the cool summer breeze. No flooding from Harvey. Concrete Driveway leads to the 30x40 Metal Building with a double carport attached to it. The building is set up for entertaining, with 2 separate areas where you can lock up your tools & equipment and still have a huge open storage area. To the Right of the building is an outdoor hot tub in a screened in building - that needs a little TLC. You also have a fenced back yard. Best of all there is a community boat ramp at the end of the subdivision for use only by homeowners for a small annual fee. The home is occupied, so please schedule your private showing with a Realtor.' ,`Acres` = '0.3399' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'FIESTA VILLAGE (A0004 C G & H H ALLSBERRY) LOT 34-35-53 MOBI' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '14806' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '51 - Sweeny' ,`SchoolElementary` = 'SWEENY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SWEENY HIGH SCHOOL' ,`SchoolMiddle` = 'SWEENY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Fiesta Village' ,`TaxAmount` = '1476' ,`TaxRate` = '2.0957' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696288' WHERE `Matrix_Unique_ID` = '205768787' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T13:02:05.157' ,`MLSNumber` = '81312650' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.866839' ,`Longitude` = '-95.838136' ,`PhotoCount` = '14' ,`PostalCode` = '77493' ,`RoomCount` = '10' ,`ListPrice` = '1024900.00' ,`Status` = 'Active' ,`StreetName` = 'Lady Bird' ,`StreetNumber` = '3223' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4411' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERRY HOMES NEW CONSTRUCTION! Entry framed by home office with French doors. Extended entry with 12-foot coffered ceiling flows past large game room with French doors and formal dining room. Spacious family room with a corner fireplace opens to morning area. Island kitchen with built-in seating space and a corner pantry. Secluded primary suite boasts a beautiful wall of windows. Primary bath offers dual vanities, garden tub, separate glass enclosed shower, two linen closets and two walk-in closets. Media room just off the kitchen area. Secondary bedrooms all offer full bathroom and walk-in closet. Utility room. Covered backyard patio. Mud room just off the three car garage.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Cane Island Lot 33, Blk 1, Section 31' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '13206' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cane Island' ,`TaxAmount` = '' ,`TaxRate` = '3.45' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696289' WHERE `Matrix_Unique_ID` = '206338205' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T13:09:30.260' ,`MLSNumber` = '23529072' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.798149' ,`Longitude` = '-95.843411' ,`PhotoCount` = '14' ,`PostalCode` = '77493' ,`RoomCount` = '11' ,`ListPrice` = '974900.00' ,`Status` = 'Active' ,`StreetName` = 'Mirabeau' ,`StreetNumber` = '6802' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4263' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERRY HOMES NEW CONSTRUCTION! Grand two-story entry with 19 foot ceilings. Formal dining room and home office with French doors set at entry. Family room features a wood mantel fireplace and a sliding glass door. Spacious kitchen with ample counter space, a double wall oven, 5-burner gas cooktop, island with built-in seating, large walk-in pantry and butler pantry. Primary suite features a wall of windows, two large walk-in closets with access to large utility room. Primary bathroom includes dual vanities, garden tub and separate large walk-in shower. Guest suite with private bathroom is included on the first floor. Theatre room, game room, secondary bedrooms and a Hollywood bathroom completes the second floor. Extended covered backyard patio. Mud room leads to three-car garage.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Cane Island Lot 7, Blk 1, Section 31' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10960' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BRYANT ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cane Island' ,`TaxAmount` = '' ,`TaxRate` = '3.45' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696289' WHERE `Matrix_Unique_ID` = '207004873' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T13:29:35.510' ,`MLSNumber` = '41297187' ,`ListAgentFullName` = 'Nicole Garner' ,`ListOfficeName` = 'Windsor Hill Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.046385' ,`Longitude` = '-95.423372' ,`PhotoCount` = '23' ,`PostalCode` = '77373' ,`RoomCount` = '12' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = 'Dickson Park' ,`StreetNumber` = '19215' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2382' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new home! This 3-bedroom, 2.5-bathroom home is ready for new owners. From the moment you walk in, you\'ll be impressed by the high ceilings and abundance of natural light. The gated community provides a quiet setting and leaves one with peace of mind. You\'ll love spending time in the kitchen, thanks to the ample countertop space and abundant storage. The primary bedroom suite features a large en-suite bathroom with a walk-in closet. Relax after a long day in the comfortable living room with high ceilings. With two additional bedrooms upstairs and a spacious gameroom, this floor plan could easily accommodate a multi-generational setup and allow for multiple living spaces.\r\n\r\nYou\'ll love the peaceful and scenic surroundings of this exclusive gated community, while also enjoying the convenience of being close to all the best shopping, dining, and entertainment that Houston has to offer. Don\'t miss out on this amazing opportunity - call today for a private tour!' ,`Acres` = '0.1523' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 1 SPRING PARK VILLAGE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6634' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '685' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'GINGER MCNABB ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'TWIN CREEKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Park Village' ,`TaxAmount` = '5520' ,`TaxRate` = '2.4967' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663696289' WHERE `Matrix_Unique_ID` = '207757862' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T13:16:17.797' ,`MLSNumber` = '6645323' ,`ListAgentFullName` = 'Kathryn Hensley' ,`ListOfficeName` = 'Keller Williams Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.236240' ,`Longitude` = '-94.772077' ,`PhotoCount` = '50' ,`PostalCode` = '75941' ,`RoomCount` = '4' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Settlers' ,`StreetNumber` = '390' ,`StreetSuffix` = 'Trail' ,`City` = 'Burke' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3264' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous Custom Built 3story Home! A must See! Come tour this 4bedroom, 3.5 bath located on 2 acres. This home offers a formal dining, Formal Living and an oversized Game Room! Come sit out of this fabulous back porch or take a swim in the pool. This home has so much to offer! All that is missing is YOU!' ,`Acres` = '2.1097' ,`Area` = '45' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angelina County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '4355 HERITAGE SOUTH BLK 1 LOT 29' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '91900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '266 - Diboll' ,`SchoolElementary` = 'TEMPLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DIBOLL HIGH SCHOOL' ,`SchoolMiddle` = 'DIBOLL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Heritage South' ,`TaxAmount` = '6588' ,`TaxRate` = '1.8119' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696289' WHERE `Matrix_Unique_ID` = '208304963' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T13:27:51.727' ,`MLSNumber` = '23723688' ,`ListAgentFullName` = 'Veronica Ceno' ,`ListOfficeName` = 'Ceno Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.736351' ,`Longitude` = '-94.924168' ,`PhotoCount` = '19' ,`PostalCode` = '77351' ,`RoomCount` = '7' ,`ListPrice` = '174000.00' ,`Status` = 'Active' ,`StreetName` = 'Talpa' ,`StreetNumber` = '108' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1344' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your peaceful oasis. This quaint home boasts a wonderfully lit living room with high ceilings, roomy bedrooms, and beautiful spacious yard. You can enjoy lounging outside during a warm summer\'s day while under the covered patio. This home is also only 15 minutes away from the gorgeous Lake Livingston State Park where you can enjoy fishing, camping, boating, hiking, and much more. Call and make your appointment today!' ,`Acres` = '0.2716' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LAKEVIEW SECTION 2 BLK 10 LOT 1 & 2 W PT' ,`LotDesciption` = 'Corner' ,`LotSize` = '11832' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakeview Sec 2' ,`TaxAmount` = '2037' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696289' WHERE `Matrix_Unique_ID` = '208668414' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T13:36:51.220' ,`MLSNumber` = '77365098' ,`ListAgentFullName` = 'Michael Crider' ,`ListOfficeName` = 'Keller Williams Platinum' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.877960' ,`Longitude` = '-95.710341' ,`PhotoCount` = '44' ,`PostalCode` = '77449' ,`RoomCount` = '10' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Flintside' ,`StreetNumber` = '19507' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2321' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Updated 2 story home on a corner/cul-de-sac lot. All bedrooms upstairs. Laminate wood floors througout and tile floors in bathrooms, utility room and kitchen. Upgrades include: Pex plumbing installed in 2020, LED lighting added throughout and vinyl double paned windows. The upgraded kitchen features granite counter tops, stainless steel appliances, upgraded soft close drawers and cabinets, brushed nickel hardware and updated tile floor and backsplash. 2nd bathroom and primary bathroom have both been remodeled. New counter tops and updated tile. Large primary bedroom has an extra large walk-in closet. AC replaced in 2014. Just walking distance from neighborhood pool. Don\'t miss out on this great find.' ,`Acres` = '0.2066' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 4 HIGHLAND CREEK VILLAGE SEC 1' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'DURYEA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'HOPPER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland Creek Village Sec 01' ,`TaxAmount` = '5440' ,`TaxRate` = '2.69' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696289' WHERE `Matrix_Unique_ID` = '209467949' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T12:41:49.470' ,`MLSNumber` = '50266715' ,`ListAgentFullName` = 'Tammi Freund' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.279613' ,`Longitude` = '-94.816425' ,`PhotoCount` = '24' ,`PostalCode` = '77551' ,`RoomCount` = '5' ,`ListPrice` = '339000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue' ,`StreetNumber` = '4802' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1424' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME HOME!!PERFECT INVESTMENT OR PRIMARY HOME!!Centrally located in Galveston and just a few blocks from the beach, perfect to make family memories special and fun. Move in ready for your family, beautiful 3 bedroom 2 bath beauty has everything you are looking for!!Beautiful flooring through the house, gorgeous kitchen, open concept, generous size fenced back yard, HVAC installed in 2020, located in a quiet neighborhood. THIS HOME NEVER FLOODED AND MUCH MORE!! COME SEE YOUR FUTURE HOME NEAR THE BEACH TODAY!' ,`Acres` = '0.1171' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Midtown - Galveston' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOT 26 L G HASSELMEIER SUB' ,`LotDesciption` = 'Other' ,`LotSize` = '5100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hasselmeier Sw & Se 130' ,`TaxAmount` = '3358' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696289' WHERE `Matrix_Unique_ID` = '210028183' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T13:18:06.493' ,`MLSNumber` = '10821503' ,`ListAgentFullName` = 'Joe Forkner' ,`ListOfficeName` = 'Anne Willis Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.524334' ,`Longitude` = '-94.486203' ,`PhotoCount` = '14' ,`PostalCode` = '77617' ,`RoomCount` = '3' ,`ListPrice` = '515000.00' ,`Status` = 'Active' ,`StreetName` = 'Faggard Slip Road' ,`StreetNumber` = '1279' ,`StreetSuffix` = '' ,`City` = 'Gilchrist' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.3099' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Gilchrist' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 64 E FRANKS SUR LOTS 73 THRU 78 BLK 1 FAGGARD SLIP UNRE' ,`LotDesciption` = 'Cleared,Water View,Waterfront' ,`LotSize` = '13500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '25 - High Island' ,`SchoolElementary` = 'HIGH ISLAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HIGH ISLAND HIGH SCHOOL' ,`SchoolMiddle` = 'HIGH ISLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Faggard Slip Ext' ,`TaxAmount` = '2097' ,`TaxRate` = '1.5543' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696289' WHERE `Matrix_Unique_ID` = '210056294' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T12:02:03.180' ,`MLSNumber` = '97728388' ,`ListAgentFullName` = 'Kelli Semar' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.590828' ,`Longitude` = '-95.136686' ,`PhotoCount` = '28' ,`PostalCode` = '77331' ,`RoomCount` = '3' ,`ListPrice` = '190000.00' ,`Status` = 'Active' ,`StreetName` = 'Berry' ,`StreetNumber` = '51' ,`StreetSuffix` = 'Street' ,`City` = 'Coldspring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1894' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a darling craftsman close to the center of town. This home embraces the small-town feel of Coldspring. One mile from the center of town where all the festivals are held. It\'s 3 bed 2 bath floor plan is large and traditional to the style of a home of its era. It has hardwood floors and high ceilings in the majority of the rooms. The wide hall is adorned with large traditional door casings. Outside on the edge of the large backyard, you will find a detached one-car garage with a workshop area. Some areas of the house have been updated like the new roof. Other areas of the house still have the original charm of a 1950\'s Craftsman. To appreciate it, you must see it.' ,`Acres` = '0.425' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Coldspring/South San Jacinto County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'A042 ROBERT RANKIN, TRACT 349.1, ACRES .425' ,`LotDesciption` = 'Cleared' ,`LotSize` = '18513' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'ROBERT RANKIN' ,`TaxAmount` = '1632' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663696290' WHERE `Matrix_Unique_ID` = '210152930' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T12:37:17.663' ,`MLSNumber` = '13903666' ,`ListAgentFullName` = 'Beverly Farris' ,`ListOfficeName` = 'World Wide Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.794947' ,`Longitude` = '-95.497791' ,`PhotoCount` = '21' ,`PostalCode` = '77055' ,`RoomCount` = '6' ,`ListPrice` = '925000.00' ,`Status` = 'Active' ,`StreetName` = 'Lofland' ,`StreetNumber` = '8412' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1936' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One of six Memorial Villages, Spring Valley Village is a special community with its own water system and police department. This 24,108 square foot lot is located about 20 minutes west of downtown Houston and surrounded by restaurants and shopping off of I-10. 8412 Lofland is a PRIME Spring Valley location easily accommodating a large home with plenty of room for a pool and outdoor space. This rare 24,108 square foot lot is one of the largest in Spring Valley and backs up to a ravine, park, with plenty of trees and privacy!! NEVER FLOODED!! Zoned to sought after Spring Branch School District....including Memorial High School!! Come make it your own!! Don\'t miss this rare find!!' ,`Acres` = '0.5534' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 152 BLK 8 SPRING OAKS SEC 2' ,`LotDesciption` = 'Ravine,Subdivision Lot,Wooded' ,`LotSize` = '24108' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'VALLEY OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Spring Oaks Sec 02' ,`TaxAmount` = '17338' ,`TaxRate` = '2.3056' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1953' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663696290' WHERE `Matrix_Unique_ID` = '210228936' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T12:11:06.340' ,`MLSNumber` = '7136897' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.223270' ,`Longitude` = '-95.702388' ,`PhotoCount` = '6' ,`PostalCode` = '77354' ,`RoomCount` = '7' ,`ListPrice` = '360698.00' ,`Status` = 'Active' ,`StreetName` = 'Berylline' ,`StreetNumber` = '40531' ,`StreetSuffix` = 'Lane' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2066' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2 Story Addington Floor Plan with 4 Bedrooms, 2 ½ Baths, with attached 2 car Garage. This home boasts a SPACIOUS OPEN CONCEPT FLOOR PLAN with the Family Room, Kitchen, Breakfast Room, Half Bath, Utility Room, and Owner’s Retreat downstairs. Upstairs you will find a Flex Space with Tech Center, 3 Bedrooms with walk in closets, and another Full Bath. The Kitchen has lots of cabinets, granite countertops with under the cabinet lighting, stainless steel appliances, and even a USB outlet. COVERED PATIO, SPRINKLER SYSTEM, and fenced backyard. COST AND ENERGY EFFICIENT FEATURES: 16 Seer HVAC System, Honeywell Programmable Thermostat, Pex Hot and cold Water Lines, Radiant Barrier, Rheem® Tankless Gas Water Heater, and Vinyl Double Pane Low E Windows that open to the inside of the home for easy cleaning. Located in Magnolia, TX the new master-planned community Audubon will be conveniently located on both sides of FM-1488 near Mill Creek Road, just along the TX-249 Toll Road.' ,`Acres` = '0.1056' ,`Area` = '15' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S221202 - AUDUBON CREEKSIDE NORTH 02A, BLOCK 4, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Audubon' ,`TaxAmount` = '539' ,`TaxRate` = '3.3087' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696290' WHERE `Matrix_Unique_ID` = '210589319' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T13:47:21.707' ,`MLSNumber` = '59560512' ,`ListAgentFullName` = 'Charlie Zaid' ,`ListOfficeName` = 'Century Properties Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.381044' ,`Longitude` = '-94.973814' ,`PhotoCount` = '10' ,`PostalCode` = '77591' ,`RoomCount` = '6' ,`ListPrice` = '155000.00' ,`Status` = 'Active' ,`StreetName` = 'Leroy' ,`StreetNumber` = '210' ,`StreetSuffix` = 'Street' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '984' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEWLY RENOVATED 3 BEDROOM - 2 BATH, NEW ROOF - NEW AC SYSTEM - NEW APPLIANCES. GRANITE COUNTERS IN KITCHEN. COMPLETELY REMODELED. LARGE BACKYARD.' ,`Acres` = '0.1148' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 197 T TOBY SUR LOT 17 MCDANIEL UNRECORDED SUB' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'SIMMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mc Daniel Tr Unrec' ,`TaxAmount` = '2151' ,`TaxRate` = '2.582' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1957' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696290' WHERE `Matrix_Unique_ID` = '210920801' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T13:03:45.760' ,`MLSNumber` = '6661873' ,`ListAgentFullName` = 'Norrita Johnson' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.885493' ,`Longitude` = '-96.081005' ,`PhotoCount` = '5' ,`PostalCode` = '77423' ,`RoomCount` = '1' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'Moore' ,`StreetNumber` = '7607' ,`StreetSuffix` = 'Road' ,`City` = 'Pattison' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1895' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Country Life...this is a great time to plan your own space for a weekend home(s), family getaway space. You will have a moment to get away from the busy city, as Houston grows larger and larger everyday. This could become your own 4 acres oasis of peace. The land is heavily treed, so you can have as much privacy as your heart desires. There is a small creek crossing the rear of the property that can offer a moment for you to occasionally hear the sound of water flowing, offering a piece of serenity and relaxation... Are you ready for FOUR ACRES of PRIVACY? If you are, this land is waiting for YOU!!!' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Brookshire' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ABS A304800 A-48 JUAN A PADILLO TRACT 161 SN1 AH02994522A HU' ,`LotDesciption` = 'Wooded' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '44 - Royal' ,`SchoolElementary` = 'ROYAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ROYAL HIGH SCHOOL' ,`SchoolMiddle` = 'ROYAL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,No Supra Keybox,Temporarily No Showings' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'JUAN A PADILLO' ,`TaxAmount` = '1633' ,`TaxRate` = '2.0226' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663696290' WHERE `Matrix_Unique_ID` = '210956609' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T13:35:30.290' ,`MLSNumber` = '73623381' ,`ListAgentFullName` = 'Kaye Kaye Smith' ,`ListOfficeName` = 'Legacy Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.268921' ,`Longitude` = '-94.637938' ,`PhotoCount` = '28' ,`PostalCode` = '75901' ,`RoomCount` = '3' ,`ListPrice` = '304900.00' ,`Status` = 'Active' ,`StreetName` = 'FM 326' ,`StreetNumber` = '6476' ,`StreetSuffix` = '' ,`City` = 'Lufkin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction on .75 acres in Bald Hill right off of FM 326! 3 Bedrooms, 2 Baths, quarts countertops throughout, gorgeous master bath (dual sinks, soaking tub and separate shower) and a huge back patio. This cozy home is open concept with a breakfast bar, cathedral ceiling, split bedroom plan. Master suite has a walk in closet with built in shelving, coat/shoe rack with bench for storage in the mud room area, and a spacious laundry room with a folding table. This property also offers a sprawling front and back yard giving you lots of elbow room. GREAT LOCATION TOO!' ,`Acres` = '' ,`Area` = '45' ,`BuilderName` = 'Absolute Builders' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angelina County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '3A124 FM 326 MILES RD SUBD PHASE BLK 1 LOT 3' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '186 - Lufkin' ,`SchoolElementary` = '' ,`SchoolHigh` = 'LUFKIN HIGH SCHOOL' ,`SchoolMiddle` = 'LUFKIN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Miles Road Subdivision' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696290' WHERE `Matrix_Unique_ID` = '211176117' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T12:29:06.480' ,`MLSNumber` = '8303826' ,`ListAgentFullName` = 'Joseph Peterson' ,`ListOfficeName` = 'Briko Realty Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.827244' ,`Longitude` = '-95.052974' ,`PhotoCount` = '6' ,`PostalCode` = '77562' ,`RoomCount` = '6' ,`ListPrice` = '224400.00' ,`Status` = 'Active' ,`StreetName` = 'Canal' ,`StreetNumber` = '404' ,`StreetSuffix` = 'Road' ,`City` = 'Highlands' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'On Going Auction! Auction properties are sold AS IS,SITE UNSEEN without any guarantee or warranty by seller. Property may be occupied.' ,`Acres` = '0.489' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 13 14 & 15 BLK 2 LAKEVIEW TERRACE' ,`LotDesciption` = 'Other' ,`LotSize` = '21300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'HOPPER/HIGHLANDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakeview Terrace' ,`TaxAmount` = '3972' ,`TaxRate` = '2.575' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696290' WHERE `Matrix_Unique_ID` = '211215349' --> Updated record success