Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)<br>Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)<br>Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)<br>Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)<br>Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)<br>Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)<br>Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)<br>Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)<br>Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)<br>Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)<br>Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)<br>Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)<br>Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)<br>Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)<br>Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)<br>Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)<br>Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)<br>Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)<br>Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)<br>Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)<br>Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)<br>Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)<br>Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)<br>Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)<br>Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)<br>Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)<br>Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)<br>Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)<br>Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)<br>Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)<br>Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)<br>Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)<br>Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)<br>Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)<br>Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)<br>Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)<br>Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)<br>Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)<br>Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)<br>Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)<br>Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)<br>Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)<br>Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)<br>Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)<br>Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)<br>Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)<br>Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)<br>Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)<br>Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)<br>Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)<br>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)<br>Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)<br>Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)<br>Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)<br>Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)<br>Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)<br>Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)<br>Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)<br>Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)<br>Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)<br>Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)<br>Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)<br>Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)<br>Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)<br>Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)<br>Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)<br>Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)<br>Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T09:36:01.543' ,`MLSNumber` = '47534440' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.726764' ,`Longitude` = '-95.373380' ,`PhotoCount` = '50' ,`PostalCode` = '77004' ,`RoomCount` = '5' ,`ListPrice` = '777999.00' ,`Status` = 'Active' ,`StreetName` = 'Ruth' ,`StreetNumber` = '2201' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Striking corner home full of large windows that provide great views of downtown at every turn. Spectacular modern flair in the historical area. Beautiful quartzite and copper accents give a perfect touch of class. French doors upstairs and downstairs. Home features not one but two master suites, including one on the first level. Beautiful herringbone design to the ceramic flooring. A huge auto gate opens up to a spacious three-car garage with plenty of parking for those weekend cookouts. Great location with speedy access to both downtown and the medical center. This one won\'t last long, come see what all the fuss is about! A true gem!' ,`Acres` = '0.1263' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 22 BLK B ALMEDA PLACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOCKHART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Almeda Place' ,`TaxAmount` = '18545' ,`TaxRate` = '2.5144' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696226' WHERE `Matrix_Unique_ID` = '199773090'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T09:02:21.667' ,`MLSNumber` = '68096603' ,`ListAgentFullName` = 'Ronald Linton' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.706294' ,`Longitude` = '-96.210242' ,`PhotoCount` = '32' ,`PostalCode` = '77465' ,`RoomCount` = '6' ,`ListPrice` = '439000.00' ,`Status` = 'Active' ,`StreetName` = 'Bay' ,`StreetNumber` = '1076' ,`StreetSuffix` = 'Drive' ,`City` = 'Palacios' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Outstanding Home Has It All In Design Features On 1.54 Acres!  Kitchen With Oversized Island Top Of The Line White, Black & Grey Granite*Stainless Appliances*Subway Tile Backsplash*42 Inch White Shaker Front Cabinets*2 Inch White Blinds Through-Out*Baths With Undermount Sinks & Granite Counters*Primary Shower Has 3 Heads*Designer Tile In Shower Surround Of Baths*Ceiling Fan In Primary Bath*Wide Trim Boards Through-Out The Home*Upgraded Light Fixture/Fans*Sprinklers*Garage Door Opener On Golf Cart Garage Or Storage Area*Home Looks Like No One Has Lived In The Home**Spotless.' ,`Acres` = '1.545' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WAYPOINT LANDING, LOT 66, SEC 2, ACRES 1.545' ,`LotDesciption` = 'Corner,Subdivision Lot,Water View' ,`LotSize` = '67300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '295' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '156 - Palacios' ,`SchoolElementary` = 'CENTRAL ELEMENTARY SCHOOL (PALACIOS)' ,`SchoolHigh` = 'PALACIOS HIGH SCHOOL' ,`SchoolMiddle` = 'PALACIOS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Waypoint Landing' ,`TaxAmount` = '2597' ,`TaxRate` = '1.9236' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696226' WHERE `Matrix_Unique_ID` = '206948028'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T09:26:22.817' ,`MLSNumber` = '64389701' ,`ListAgentFullName` = 'Casi De La Torre' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.049584' ,`Longitude` = '-93.807840' ,`PhotoCount` = '26' ,`PostalCode` = '77630' ,`RoomCount` = '3' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Patillo' ,`StreetNumber` = '5138' ,`StreetSuffix` = 'Road' ,`City` = 'Orange' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2334' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This spacious family home on .77 acres will not disappoint! The home features 2334 sqft of living space with large bed rooms and two living areas! There is no shortage for storage in this house. There\'s room for everything! Outside is your own little oasis with gunite pool and patio on a huge lot. Perfect for entertaining! You don\'t want to miss out on this one! Make your appointment now!' ,`Acres` = '0.769' ,`Area` = '50' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 1 THRU 3 BLK 1 HIGHLANDS A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '33498' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Slate' ,`SchoolDistrict` = '367 - Bridge City' ,`SchoolElementary` = 'BRIDGE CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGE CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BRIDGE CITY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Highlands A, B, C' ,`TaxAmount` = '3253' ,`TaxRate` = '1.7904' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663696226' WHERE `Matrix_Unique_ID` = '207852536'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T09:00:44.700' ,`MLSNumber` = '41232026' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.813923' ,`Longitude` = '-95.842735' ,`PhotoCount` = '14' ,`PostalCode` = '77493' ,`RoomCount` = '10' ,`ListPrice` = '789990.00' ,`Status` = 'Active' ,`StreetName` = 'Upland' ,`StreetNumber` = '3223' ,`StreetSuffix` = 'Street' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3404' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction by Shea Homes. Plan 6025. Est. Completion 1/2023. This inviting and spacious single story home offers 4 bedrooms, 3.5 baths, and a 3 car tandem garage.  As you walk through the gorgeous rotunda in the entry, you will find hallways that lead to the secondary bedrooms and Study with French doors.  The Great Room awaits at the end of the hall with a 12\' ceiling and stacked slider doors that fill the space with natural light.  An oversized Casual Dining Room leads out to your covered patio with an outdoor kitchen! Back inside, the gourmet Kitchen includes cabinets galore, double ovens, a 5 burner gas cooktop, large kitchen island and a walk in pantry/computer niche! The private primary suite is the perfect place to relax featuring a bay window and spa like bathroom with dual vanities, shower with bench seat, and garden tub.  A Media Room off the Great Room will provide the perfect space to entertain family and friends!  Come and Live the Difference in a Shea Home!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Shea Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 6, Block 1, Section 32' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9240' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double 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` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'French' ,`Subdivision` = 'Cane Island' ,`TaxAmount` = '' ,`TaxRate` = '3.4' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696226' WHERE `Matrix_Unique_ID` = '208321579'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T08:36:13.943' ,`MLSNumber` = '15805579' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Benson Akintunji' ,`SellingOfficeName` = 'Realty Associates' ,`Latitude` = '29.681761' ,`Longitude` = '-95.836925' ,`PhotoCount` = '30' ,`PostalCode` = '77406' ,`RoomCount` = '18' ,`ListPrice` = '697854.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Radiant River' ,`StreetNumber` = '26111' ,`StreetSuffix` = 'Trail' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3762' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Carter VI, Elevation F) CURRENTLY BEING BUILT. Two Story. 5 bedrooms, 4.5 baths. Private Primary Suite with spacious double walk-in closets downstairs. Formal Dining Room and Study with Spacious Kitchen and breakfast area open to Family Room. Spacious Game Room upstairs with private Media Room. Extended covered patio and attached 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` = '' ,`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 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8335' ,`LotSizeSource` = 'Other' ,`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`='1663696226' WHERE `Matrix_Unique_ID` = '208362936'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T08:31:03.747' ,`MLSNumber` = '26450512' ,`ListAgentFullName` = 'Marnie Wyatt' ,`ListOfficeName` = 'Wyatt Realty Group, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.261020' ,`Longitude` = '-95.633757' ,`PhotoCount` = '22' ,`PostalCode` = '77354' ,`RoomCount` = '9' ,`ListPrice` = '799990.00' ,`Status` = 'Active' ,`StreetName` = 'Corolla' ,`StreetNumber` = '3035' ,`StreetSuffix` = 'Road' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2771' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'STUNNING EQUESTRIAN ESTATE ON 4 ACRES!\r\nEnjoy country living at its finest. Custom stone-built home debuts after a full renovation.  This home is in a prime location and close proximity to HEB, the Woodlands retail, fine dining and world class medical facilities.  As you enter through the gated entrance and tree lined driveway you will see the 2-stall horse barn with separate tack room, run-in shed and 2 fenced paddocks.  The home consists of 3 bedrooms and 2 bathrooms, private pool oasis and 25X40 shop.  The 20KW backup home generator is a great piece of mind and added security.  The heart of the home is in the kitchen with custom cabinetry that is enhanced by the cultured quartz counter tops and professional 48\" gas range.  The kitchen opens to a cathedral style living room with a floor to ceiling stone fireplace.  3 large bedrooms on one side of the home have great views of the surrounding forest. On the opposite end you will find a tv media game room great for entertaining.' ,`Acres` = '4' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'A0397 - NICHOLS THOS J, TRACT 13-D, ACRES 4' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'BEAR BRANCH ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Tj Nichols Surv Abs #397' ,`TaxAmount` = '5182' ,`TaxRate` = '1.86' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696226' WHERE `Matrix_Unique_ID` = '208390284'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T08:40:31.960' ,`MLSNumber` = '96732996' ,`ListAgentFullName` = 'Jamie McMartin' ,`ListOfficeName` = 'Compass RE Texas, LLCKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.196410' ,`Longitude` = '-94.983966' ,`PhotoCount` = '33' ,`PostalCode` = '77554' ,`RoomCount` = '7' ,`ListPrice` = '685000.00' ,`Status` = 'Active' ,`StreetName` = 'Karankawa' ,`StreetNumber` = '4229' ,`StreetSuffix` = 'Way' ,`City` = 'Jamaica Beach' ,`BathsFull` = '1' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '1344' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fun in the sun on the main canal of Jamaica Beach!  Beautiful Sunsets from the deck and it comes completely furnished. Beautiful cypress plank ceilings in the living/dining room and kitchen with an open living space and kitchen! Stainless steel appliances.  recently updates with new vinyl plank flooring, fresh paint, and updated Kitchen.   You will love the downstairs bunk room with it\'s own AC, bath and a large laundry room. The outside is what it\'s all about!  Nothing but cool breezes under the deck and endless fishing from your dock. The whole family will love hanging out and getting together here. New pictures coming next week. Recently updated AC.  An amazing primary home and equally perfect second home for the family to come together!  If your looking for a canal home it doesn\'t get any better then being on the main canal with no one on top of you.  The main canal is about 60 yards wide while the other canals are as small as 20 yards wide.... come to the fun side!' ,`Acres` = '0.1377' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 58 JAMAICA BEACH SEC 26' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Jamaica Beach' ,`TaxAmount` = '7797' ,`TaxRate` = '1.7044' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696227' WHERE `Matrix_Unique_ID` = '208432931'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T09:25:31.367' ,`MLSNumber` = '4953839' ,`ListAgentFullName` = 'Cinthya Banta' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.781389' ,`Longitude` = '-95.056226' ,`PhotoCount` = '37' ,`PostalCode` = '77520' ,`RoomCount` = '6' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Ilfrey' ,`StreetNumber` = '340' ,`StreetSuffix` = 'Street' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2009' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WOW!!! 2 acres of Waterfront property and DIRECT ACCESS TO BURNET BAY! Sit back and relax on your deck and enjoy the sunset views. As you walk in, you will be greeted by a spacious living room, dining room and a galley kitchen. There is a formal dining room that is being used as an office and it is very spacious.2 bedrooms down, 1 bedroom upstairs with its own full bathroom. Outside you will find a 40x30 steel metal WORKSHOP where you can store your boat or work on projects. There’s 2 RV hookups. Go fishing in your own backyard or better yet now you have that perfect excuse to buy that boat you\'ve been wanting! NO RESTRICTIONS! Easy access to 1-10, Spur 330, 146 and 225. This home backs to a canal that feeds to the bay! Bring your boat and travel all the way to the gulf! Your oasis awaits! This is a one of a kind property you have been looking for! Don’t miss out!' ,`Acres` = '2.0644' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 4 & 5 BLK 10 LAKEVIEW HEIGHTS' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '89924' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'DEER PARK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'DEER PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakeview Heights' ,`TaxAmount` = '5043' ,`TaxRate` = '2.1539' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1946' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696227' WHERE `Matrix_Unique_ID` = '210142663'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T08:16:59.453' ,`MLSNumber` = '92678927' ,`ListAgentFullName` = 'John Prell' ,`ListOfficeName` = 'Creekview Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.942813' ,`Longitude` = '-95.701415' ,`PhotoCount` = '50' ,`PostalCode` = '77433' ,`RoomCount` = '18' ,`ListPrice` = '1390000.00' ,`Status` = 'Active' ,`StreetName` = 'Cypress Creek Lakes' ,`StreetNumber` = '11327' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '6' ,`BathsHalf` = '2' ,`BedsTotal` = '7' ,`SqFtTotal` = '9028' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Perry Builders home with secondary bedrooms that are large enough to fit a king sized bed with en-suite bathrooms and walk-in closets. Entertain your family and friends with a large pool with a swim-up bar/seating and a rock waterfall/slide, balcony facing the sunset, two outdoor patios with a kitchen, bathroom and fireplace, billiard room, media room, home office, and a giant gym. This home is located close to Sterling Country Club, Blackhorse Golf Club, the amenities of Towne Lake and Bridgeland, and zoned to a campus containing top-ranked elementary, middle, and high schools within exemplary Cy-Fair ISD. With a lower price per sq ft compared to similar listings in the area, this home is priced to sell!' ,`Acres` = '0.3734' ,`Area` = '25' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 4 CYPRESS CREEK LAKES SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '16266' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WARNER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Cypress Crk Lakes Sec 02' ,`TaxAmount` = '25497' ,`TaxRate` = '2.801' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696227' WHERE `Matrix_Unique_ID` = '210396349'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T09:15:07.480' ,`MLSNumber` = '69841371' ,`ListAgentFullName` = 'Jonathan McNabb' ,`ListOfficeName` = 'Nest Ahead' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.830515' ,`Longitude` = '-95.187363' ,`PhotoCount` = '8' ,`PostalCode` = '77049' ,`RoomCount` = '6' ,`ListPrice` = '329990.00' ,`Status` = 'Active' ,`StreetName` = 'Harrow Park' ,`StreetNumber` = '13418' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2688' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The two-story 5 bedroom and 3 bathroom Supernova floorplan is your perfect oasis. With 2 bonus spaces and a bedroom equipped with a full bathroom on the main floor, you\'re sure to have planty of space. New stainless appliances and a 2 car-garage complete the home. The photos are stock photos, and do not represent the exact home.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Starlight Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Imperial Forest Section 4 Block 4 Lot 29' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'ROYALWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'C.E. KING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Forest' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696227' WHERE `Matrix_Unique_ID` = '211150480'  --> Updated record success<br />