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-10-04T04:14:35.327' ,`MLSNumber` = '70859154' ,`ListAgentFullName` = 'Lizabeth Comiskey' ,`ListOfficeName` = 'Comiskey Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.295228' ,`Longitude` = '-94.922485' ,`PhotoCount` = '35' ,`PostalCode` = '77554' ,`RoomCount` = '8' ,`ListPrice` = '895598.00' ,`Status` = 'Active' ,`StreetName` = 'Copra' ,`StreetNumber` = '1627' ,`StreetSuffix` = 'Street' ,`City` = 'Tiki Island' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1844' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A RARE FIND!\r\nEVERY DAY IS A SUNSET!\r\nBeautiful bay front home illustrates a Great location for Living the life on Tiki~ \r\nHome excels with Walls of windows displaying the wonderful sparkling Bay.\r\nHigh ceilings bringing in the natural light. Open floor plan including the family room, breakfast room, dining room and kitchen all as one.\r\nFront driveway can easily park 10-15 cars along with the two private garages.\r\nThe porch offers limitless sunset views! \r\nThe boat dock is oversized and extra wide for the much larger boats. Keep it oversized or construct to the two slips to include a jet ski lift. \r\nOwners use to have a 56foot boat parked on outer side of slip as well, \r\nAlready has plugs for the larger boats!\r\nYou will be amazed of all the fish you can catch off your dock.\r\nPlease look for the airconditioned bonus room with walk in closet and full bath! \r\nMust Come see this wonderful home!' ,`Acres` = '0.15' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Tiki Island' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 7 S C BUNDICK SUR LOT 56 TIKI ISLAND SEC 7' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '6534' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '110' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '26 - Hitchcock' ,`SchoolElementary` = 'HITCHCOCK PRIMARY/STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HITCHCOCK HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (HITCHCOCK)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Other Style' ,`Subdivision` = 'Tiki Island' ,`TaxAmount` = '13375' ,`TaxRate` = '2.2119' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664894029' WHERE `Matrix_Unique_ID` = '207011703' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T05:55:09.263' ,`MLSNumber` = '17112571' ,`ListAgentFullName` = 'Vanessa Cochran' ,`ListOfficeName` = 'Doug Erdy Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.054802' ,`Longitude` = '-94.809158' ,`PhotoCount` = '7' ,`PostalCode` = '77575' ,`RoomCount` = '4' ,`ListPrice` = '180000.00' ,`Status` = 'Active' ,`StreetName` = 'Washington' ,`StreetNumber` = '910' ,`StreetSuffix` = 'Street' ,`City` = 'Liberty' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1544' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The beautiful home has been Remodeling its sits on 1.3177 acres it has enough room to build another home plus a back porch to sit on and relax Concrete slab for a BBQ pit and picnic area Lots of Back yards' ,`Acres` = '1.3177' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Liberty' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LIBERTY OUTER BLOCKS, BLOCK 31, LOT PT 2 TR 11, ACRES 1.3177' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '57399' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '73 - Liberty' ,`SchoolElementary` = 'LIBERTY ELEMENTARY SCHOOL (LIBERTY)' ,`SchoolHigh` = 'LIBERTY HIGH SCHOOL (LIBERTY)' ,`SchoolMiddle` = 'LIBERTY MIDDLE SCHOOL (LIBERTY)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Liberty Outer Blocks' ,`TaxAmount` = '3678' ,`TaxRate` = '2.6826' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664894029' WHERE `Matrix_Unique_ID` = '211912422' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T04:34:40.803' ,`MLSNumber` = '16505084' ,`ListAgentFullName` = 'Kate Powell' ,`ListOfficeName` = 'Pam Westlake Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.282981' ,`Longitude` = '-95.617672' ,`PhotoCount` = '35' ,`PostalCode` = '77316' ,`RoomCount` = '10' ,`ListPrice` = '599900.00' ,`Status` = 'Active' ,`StreetName` = 'Queen Elizabeth' ,`StreetNumber` = '15517' ,`StreetSuffix` = 'Court' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2712' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exceptional 1-story brick/stone home on 1+ ac w/4-car garage & sparkling pool/spa! Home has split plan+study w/closet, formal dining, updated woodgrain tile flooring, granite counters, light neutral paint, travertine/stacked stone fireplace, new HVAC, upgrades. Kitchen has enormous island, storage, veggie sink, cabinetry w/drawers, stainless appliances, oil-rubbed bronze fixtures, bar seating, breakfast space. Giant primary suite has room for workout equipment & sitting area. Primary bath: 2 sinks, vanity, lovely tile floor, walk-in shower, whirlpool tub, huge walk-in closet (about 11\'x14\') w/built ins. Extra bedrooms share tub/toilet w/separate sinks & walk-in closets. Massive covered back patio has outdoor kitchen; newer pool/spa, waterfalls, extra sun deck. Enjoy landscaped back yard, lighting & screened/fenced garden/greenhouse w/ 4\'x20\' beds, paver walkways! Also custom gate w/RV/Boat pad behind. Water softener. On cul-de-sac street. MISD schools, 2 parks/lakes, gated community.' ,`Acres` = '1.007' ,`Area` = '39' ,`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` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CROWN OAKS 04, BLOCK 1, LOT 77' ,`LotDesciption` = 'Greenbelt,Subdivision Lot,Wooded' ,`LotSize` = '43865' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'KEENAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Crown Oaks 04' ,`TaxAmount` = '6982' ,`TaxRate` = '1.825' ,`WaterSewer` = 'Other Water/Sewer,Septic Tank' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664894030' WHERE `Matrix_Unique_ID` = '211912482' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T05:04:30.713' ,`MLSNumber` = '34247100' ,`ListAgentFullName` = 'Cathy Tabor' ,`ListOfficeName` = 'The Real Estate Broker' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.096227' ,`Longitude` = '-95.646206' ,`PhotoCount` = '50' ,`PostalCode` = '77377' ,`RoomCount` = '20' ,`ListPrice` = '799950.00' ,`Status` = 'Active' ,`StreetName` = 'Imperial Creek' ,`StreetNumber` = '29311' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4270' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Elegance & Classic Beauty are throughout this Spacious 2-Story Home. Located in the Intimate & Highly Desired Gated Spring Creek Estates. High Ceilings & a Wrought-Iron & Wood Staircase graces the Entry. Formal Living & Dining Area. Study w/Double French Doors & Built-Ins. Island Kitchen w/Breakfast Bar & Breakfast Room is Open to the Family Room w/a Gas-Log Fireplace, Floor-to-Ceiling Windows & Built-Ins. Downstairs Primary Bedroom w/Spa-Like En-Suite Bath. The Upstairs has a Game Room, 3-Additional Bedrooms, a Hall Bath & a Hollywood Bath. Downstairs Utility Room w/Soak Sink & Built-Ins. Beautifully Landscaped on Over 1/2 Acre. Sprinkler System. Cul-de-Sac Lot w/No Back Neighbors. In-Ground Heated Pool & Spa w/Water Features. Covered & Uncovered Patio Areas. Fire Pit Area. An Expanded Driveway (w/Porte-Cochere) can accommodate up to 14 cars & leads to the 3-Car Extended Garage w/covered Breezeway to the Kitchen Area. NO MUD TAXES! CALL TODAY for a List of Upgrades! WATCH THE VIDEO!' ,`Acres` = '0.6348' ,`Area` = '35' ,`BuilderName` = 'Imperial Homes Texas' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 46 BLK 1 SPRING CREEK ESTATES R/P' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '27652' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '495' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'ROSEHILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Photos/No Videos,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'SPRING CREEK ESTATES' ,`TaxAmount` = '11325' ,`TaxRate` = '2.3717' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664894030' WHERE `Matrix_Unique_ID` = '211995049' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T05:39:16.037' ,`MLSNumber` = '82067947' ,`ListAgentFullName` = 'Lisa Rigdon' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.752063' ,`Longitude` = '-95.553185' ,`PhotoCount` = '44' ,`PostalCode` = '77042' ,`RoomCount` = '7' ,`ListPrice` = '775000.00' ,`Status` = 'Active' ,`StreetName` = 'Lynbrook Hollow' ,`StreetNumber` = '10119' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3287' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this wonderful 4-bedroom, 3-bath home nestled on a corner lot, north of Briar Forest Dr, in Briargrove Park. This lovely home features two primary suites, one upstairs and one downstairs, along with an office/flex space, and a beautiful kitchen showcasing granite countertops and stainless steel appliances. The kitchen is a home chef\'s dream with double ovens and a gas cooktop! There is an abundance of storage space with 11 closets, 7 are walk-in and 1 is a cedar closet! Step out into the spacious backyard with space for a pool and extra parking space for up to 3 cars! Recent updates to the home include new carpet on the second floor, fresh paint throughout the interior of the home, a new downstairs furnace and new sewer lines. Enjoy the neighborhood amenities such as a community pool and tennis courts as well as a short walk to the Mary Ann Francklow Park. This home is ideally located with convenient access to Beltway 8, I-10 and Westpark Tollway. Schedule a tour today!' ,`Acres` = '0.2153' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Briargrove Park/Walnutbend' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 1 BRIARGROVE PARK SEC 3' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9380' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '685' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WALNUT BEND ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Briargrove Park Sec 3' ,`TaxAmount` = '13822' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664894030' WHERE `Matrix_Unique_ID` = '212205603' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T05:13:02.560' ,`MLSNumber` = '29014013' ,`ListAgentFullName` = 'Lyssa Lechuga' ,`ListOfficeName` = 'New Home Star Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.314752' ,`Longitude` = '-96.114490' ,`PhotoCount` = '2' ,`PostalCode` = '77488' ,`RoomCount` = '6' ,`ListPrice` = '139999.00' ,`Status` = 'Active' ,`StreetName` = 'Outlar' ,`StreetNumber` = '106' ,`StreetSuffix` = 'Street' ,`City` = 'Wharton' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This brand new Construction Energy-efficient home comes with a Low Tax rate! This home has a 5-step stairway leading to the front door and is placed on an elevated corner lot overlooking a large scenic view. Open concept kitchen overlooking the large living-dining combo, which makes it perfect for entertaining. Vinyl plank flooring in living areas and plush carpet in the bedrooms. Moen fixtures in a timeless chrome finish are placed throughout the home. The Energy efficient features in the home will be reflected in your utility bills. Beautiful black appliance package included, home is engineered and inspected by a third-party engineer, has a seer HVAC system, double pane insulated Low-E windows.\r\nReady for move-in. No HOA!\r\nFantastic Builder \'1-2-10\' Warranty' ,`Acres` = '0.1537' ,`Area` = '55' ,`BuilderName` = 'Censeo' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SMITH GARDEN SPOT BLOCK 2 LOT 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '6695' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '180 - Wharton' ,`SchoolElementary` = 'CG SIVELLS/WHARTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHARTON HIGH SCHOOL' ,`SchoolMiddle` = 'WHARTON JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Left Side,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Smith Garden Spot' ,`TaxAmount` = '1386' ,`TaxRate` = '2.4334' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664894030' WHERE `Matrix_Unique_ID` = '212612569' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T05:14:44.893' ,`MLSNumber` = '45395765' ,`ListAgentFullName` = 'Lyssa Lechuga' ,`ListOfficeName` = 'New Home Star Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.183396' ,`Longitude` = '-96.275563' ,`PhotoCount` = '1' ,`PostalCode` = '77437' ,`RoomCount` = '2' ,`ListPrice` = '134999.00' ,`Status` = 'Active' ,`StreetName` = 'Roth' ,`StreetNumber` = '810' ,`StreetSuffix` = '' ,`City` = 'El Campo' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction. Small touch-ups on paint needed then move-in ready! - This one-story plan with 2 bedrooms, 1 bath, one-story home is energy efficient, with an open concept kitchen overlooking the large living-dining combo, making this home perfect for entertaining. This home includes LED Lighting and vinyl plank flooring, and carpet in all bedrooms. Moen fixtures in a timeless chrome finish are placed throughout the home with Espresso stained cabinetry. Beautiful black appliance package included, home is engineered and inspected by a third-party engineer, has a seer HVAC system, double pane insulated Low-E windows.\r\nFantastic Builder \'1-2-10\' Warranty' ,`Acres` = '0.165' ,`Area` = '55' ,`BuilderName` = 'Censeo' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PHILLIPS BLOCK 2 LOT 26' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7187' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '198 - El Campo' ,`SchoolElementary` = '' ,`SchoolHigh` = 'EL CAMPO HIGH SCHOOL' ,`SchoolMiddle` = 'EL CAMPO MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Phillips' ,`TaxAmount` = '1901' ,`TaxRate` = '2.4815' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664894030' WHERE `Matrix_Unique_ID` = '212621973' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T05:15:29.680' ,`MLSNumber` = '76539270' ,`ListAgentFullName` = 'Lyssa Lechuga' ,`ListOfficeName` = 'New Home Star Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.181917' ,`Longitude` = '-96.279300' ,`PhotoCount` = '17' ,`PostalCode` = '77437' ,`RoomCount` = '3' ,`ListPrice` = '144999.00' ,`Status` = 'Active' ,`StreetName` = 'Sam' ,`StreetNumber` = '1307' ,`StreetSuffix` = 'Street' ,`City` = 'El Campo' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1040' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction ready for move-in immediately - This one story Plan with 3 bedrooms, 1 bath, one-story home is energy efficient, with an open concept kitchen overlooking the large living-dining combo, making this home perfect for entertaining. This home includes LED Lighting and vinyl plank flooring, and carpet in all bedrooms. Moen fixtures in a timeless chrome finish are placed throughout the home with white cabinetry. Beautiful black appliance package included, home is engineered and inspected by a third-party engineer, has a seer HVAC system, double pane insulated Low-E windows.\r\nFantastic Builder \'1-2-10\' Warranty' ,`Acres` = '0.1607' ,`Area` = '55' ,`BuilderName` = 'Censeo' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SAM STREET SUBD BLOCK 1 LOT 5' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '198 - El Campo' ,`SchoolElementary` = '' ,`SchoolHigh` = 'EL CAMPO HIGH SCHOOL' ,`SchoolMiddle` = 'EL CAMPO MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sam Street Sub' ,`TaxAmount` = '1748' ,`TaxRate` = '2.4815' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664894031' WHERE `Matrix_Unique_ID` = '212627517' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T05:15:43.660' ,`MLSNumber` = '77204561' ,`ListAgentFullName` = 'Lyssa Lechuga' ,`ListOfficeName` = 'New Home Star Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.976760' ,`Longitude` = '-95.976173' ,`PhotoCount` = '1' ,`PostalCode` = '77414' ,`RoomCount` = '2' ,`ListPrice` = '129000.00' ,`Status` = 'Active' ,`StreetName` = '1st' ,`StreetNumber` = '1117' ,`StreetSuffix` = 'Street' ,`City` = 'Bay City' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home will have an open concept kitchen overlooking the large living-dining combo, which makes it perfect for entertaining. Vinyl plank flooring in living areas and plush carpet in the bedrooms. Moen fixtures in a timeless chrome finish are placed throughout the home. The Energy efficient features in the home will be reflected in your utility bills. Beautiful black appliance package included, home is engineered and inspected by a third-party engineer, has a seer HVAC system, double pane insulated Low-E windows, ENERGY EFFICIENT!\r\nProperty is expected to be completed before the end of the year.\r\nFantastic Builder \'1-2-10\' Warranty' ,`Acres` = '0.1722' ,`Area` = '54' ,`BuilderName` = 'Censeo' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BAY CITY ORIGINAL TOWNSITE, BLOCK 2, LOT 5' ,`LotDesciption` = 'Other' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '132 - Bay City' ,`SchoolElementary` = 'TENIE HOLMES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BAY CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BAY CITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bay City Original Townsite' ,`TaxAmount` = '205' ,`TaxRate` = '2.8238' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664894031' WHERE `Matrix_Unique_ID` = '212851247' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T05:15:59.710' ,`MLSNumber` = '98025529' ,`ListAgentFullName` = 'Lyssa Lechuga' ,`ListOfficeName` = 'New Home Star Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.170893' ,`Longitude` = '-95.436532' ,`PhotoCount` = '1' ,`PostalCode` = '77515' ,`RoomCount` = '3' ,`ListPrice` = '149999.00' ,`Status` = 'Active' ,`StreetName` = 'Miller' ,`StreetNumber` = '403' ,`StreetSuffix` = 'Street' ,`City` = 'Angleton' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction ready for move-in winter of 2022 or sooner - This one-story plan with 3 bedrooms, 1 bath, one-story home is energy efficient, with an open concept kitchen overlooking the large living-dining combo, making this home perfect for entertaining. This home includes LED Lighting and vinyl plank flooring, and carpet in all bedrooms. Moen fixtures in a timeless chrome finish are placed throughout the home with white cabinetry. Beautiful black appliance package included, home is engineered and inspected by a third-party engineer, has a seer HVAC system, double pane insulated Low-E windows.\r\nFantastic Builder \'1-2-10\' Warranty' ,`Acres` = '0.0803' ,`Area` = '5' ,`BuilderName` = 'Censeo' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'JACKSON (ANGLETON) BLK 3 LOT 11' ,`LotDesciption` = 'Other' ,`LotSize` = '3498' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'WESTSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jackson Angleton' ,`TaxAmount` = '82' ,`TaxRate` = '2.6102' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664894031' WHERE `Matrix_Unique_ID` = '212852434' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T05:13:33.430' ,`MLSNumber` = '43392663' ,`ListAgentFullName` = 'Lyssa Lechuga' ,`ListOfficeName` = 'New Home Star Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.976262' ,`Longitude` = '-95.970859' ,`PhotoCount` = '14' ,`PostalCode` = '77414' ,`RoomCount` = '3' ,`ListPrice` = '169999.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue B' ,`StreetNumber` = '2721' ,`StreetSuffix` = '' ,`City` = 'Bay City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1278' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction ready for move-in immediately - This one-story plan with 3 bedrooms, 2 bath, one-story home is energy efficient, with an open concept kitchen overlooking the large living-dining combo, making this home perfect for entertaining. This home includes LED Lighting and vinyl plank flooring, and carpet in all bedrooms. Moen fixtures in a timeless chrome finish are placed throughout the home with espresso cabinetry. Beautiful black appliance package included, home is engineered and inspected by a third-party engineer, has a seer HVAC system, double pane insulated Low-E windows.\r\nOn a corner lot with no HOA!\r\nFantastic Builder \'1-2-10\' Warranty' ,`Acres` = '' ,`Area` = '54' ,`BuilderName` = 'Censeo' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BAY CITY ORIGINAL TOWNSITE, BLOCK 84, LOT 1-2 (W-50\')' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '132 - Bay City' ,`SchoolElementary` = 'TENIE HOLMES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BAY CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BAY CITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bay City Original Townsite' ,`TaxAmount` = '1347' ,`TaxRate` = '2.8238' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664894031' WHERE `Matrix_Unique_ID` = '212955479' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T05:16:16.807' ,`MLSNumber` = '98039262' ,`ListAgentFullName` = 'Lyssa Lechuga' ,`ListOfficeName` = 'New Home Star Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.188392' ,`Longitude` = '-96.274981' ,`PhotoCount` = '14' ,`PostalCode` = '77437' ,`RoomCount` = '3' ,`ListPrice` = '169999.00' ,`Status` = 'Active' ,`StreetName` = 'Greely' ,`StreetNumber` = '316' ,`StreetSuffix` = 'Street' ,`City` = 'El Campo' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1549' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction ready for move-in immediately - This two-story plan with 3 bedrooms, and 2.5 baths, is energy efficient, with an open concept kitchen overlooking the large living-dining combo, making this home perfect for entertaining. This home includes LED Lighting and vinyl plank flooring, and carpet in all bedrooms. Moen fixtures in a timeless chrome finish are placed throughout the home with Espresso cabinetry. Beautiful black appliance package included, home is engineered and inspected by a third-party engineer, has a seer HVAC system, double pane insulated Low-E windows.\r\nFantastic Builder \'1-2-10\' Warranty \r\n—Follow link to the builder website to see floorplan—' ,`Acres` = '0.1579' ,`Area` = '55' ,`BuilderName` = 'Censeo' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'HARLEM LOT 35,36' ,`LotDesciption` = 'Other' ,`LotSize` = '6878' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '198 - El Campo' ,`SchoolElementary` = '' ,`SchoolHigh` = 'EL CAMPO HIGH SCHOOL' ,`SchoolMiddle` = 'EL CAMPO MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harlem' ,`TaxAmount` = '2394' ,`TaxRate` = '2.4815' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664894031' WHERE `Matrix_Unique_ID` = '212956417' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T05:15:14.207' ,`MLSNumber` = '52989151' ,`ListAgentFullName` = 'Lyssa Lechuga' ,`ListOfficeName` = 'New Home Star Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.303546' ,`Longitude` = '-96.063819' ,`PhotoCount` = '1' ,`PostalCode` = '77488' ,`RoomCount` = '3' ,`ListPrice` = '199999.00' ,`Status` = 'Active' ,`StreetName` = 'Cline' ,`StreetNumber` = '3614' ,`StreetSuffix` = 'Road' ,`City` = 'Wharton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Under construction and ready to be called home in the winter of 2022/23! This property will have a beautiful brick exterior, energy-efficient features that will be reflected in monthly utility bills, vinyl plank flooring, lush carpet in each bedroom, and an open floor plan with the kitchen open to the living room. Perfect for entertaining. Walking distance to a well-maintained park.\r\nWarranty: 1yr workmanship & materials, 2yr on plumbing, electrical, HVAC & other Mechanical Systems,10yr Major Structural components' ,`Acres` = '0.254' ,`Area` = '55' ,`BuilderName` = 'Censeo' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BAKER #1 LOT 7,8' ,`LotDesciption` = 'Other' ,`LotSize` = '11064' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '180 - Wharton' ,`SchoolElementary` = 'CG SIVELLS/WHARTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHARTON HIGH SCHOOL' ,`SchoolMiddle` = 'WHARTON JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Baker #1' ,`TaxAmount` = '966' ,`TaxRate` = '2.4334' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664894031' WHERE `Matrix_Unique_ID` = '212956869' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T05:14:29.013' ,`MLSNumber` = '44759905' ,`ListAgentFullName` = 'Lyssa Lechuga' ,`ListOfficeName` = 'New Home Star Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.320924' ,`Longitude` = '-96.111719' ,`PhotoCount` = '14' ,`PostalCode` = '77488' ,`RoomCount` = '4' ,`ListPrice` = '195000.00' ,`Status` = 'Active' ,`StreetName` = 'N Spanish Camp' ,`StreetNumber` = '803' ,`StreetSuffix` = 'Street' ,`City` = 'Wharton' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1549' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Overlooks a scenic farm view that must be seen in person! The property is expected to be completed December - January of 2023. No HOA!\r\nThis 2 story plan with 4 bedrooms, 2 and a half baths, is energy efficient, with an open Concept Kitchen overlooking the large living-dining combo, making this home perfect for entertaining. This home includes LED Lighting, and vinyl plank flooring in the living room, dining, kitchen, and baths. Moen fixtures in a timeless chrome finish are placed throughout the home. All bedrooms are upstairs with lush carpeting in the bedrooms. 3 of the rooms have walk-in closets. Beautiful loft area at the top of the stairs. Perfect for reading or homework. Black appliance package included, home is engineered and inspected by a third-party engineer, has a seer HVAC system, double pane insulated Low-E windows.\r\n—Follow link to the builder website to see floorplan—\r\nFantastic Builder \'1-2-10\' Warranty' ,`Acres` = '0.1579' ,`Area` = '55' ,`BuilderName` = 'Censeo' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WHARTON A.JACKSON BLK.52 LOT 2A' ,`LotDesciption` = 'Other' ,`LotSize` = '6878' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '180 - Wharton' ,`SchoolElementary` = 'CG SIVELLS/WHARTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHARTON HIGH SCHOOL' ,`SchoolMiddle` = 'WHARTON JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wharton A jackson' ,`TaxAmount` = '2394' ,`TaxRate` = '2.4815' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664894032' WHERE `Matrix_Unique_ID` = '212956995' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T05:13:18.673' ,`MLSNumber` = '30910159' ,`ListAgentFullName` = 'Lyssa Lechuga' ,`ListOfficeName` = 'New Home Star Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.313372' ,`Longitude` = '-96.109832' ,`PhotoCount` = '17' ,`PostalCode` = '77488' ,`RoomCount` = '3' ,`ListPrice` = '132500.00' ,`Status` = 'Active' ,`StreetName` = 'W Milam' ,`StreetNumber` = '1007' ,`StreetSuffix` = 'Street' ,`City` = 'Wharton' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1040' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This one Story Plan with 3 bedrooms, 1 bath, one-story home is energy efficient, with an open Concept Kitchen overlooking the large living-dining combo, making this home perfect for entertaining. This home includes LED Lighting, and vinyl plank flooring in the living room, dining, kitchen, and baths. Moen fixtures in a timeless chrome finish are placed throughout the home. Lush carpeting in the bedrooms. Beautiful black appliance package included, home is engineered and inspected by a third-party engineer, has a seer HVAC system, double pane insulated Low-E windows!\r\nReady for move-in. No HOA!\r\nFantastic Builder \'1-2-10\' Warranty' ,`Acres` = '0.1607' ,`Area` = '55' ,`BuilderName` = 'Censeo' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'CLINE BLOCK 2 LOT 2' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '180 - Wharton' ,`SchoolElementary` = 'CG SIVELLS/WHARTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHARTON HIGH SCHOOL' ,`SchoolMiddle` = 'WHARTON JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cline' ,`TaxAmount` = '1748' ,`TaxRate` = '2.4815' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664894032' WHERE `Matrix_Unique_ID` = '212982758' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T05:12:24.387' ,`MLSNumber` = '51394514' ,`ListAgentFullName` = 'Lyssa Lechuga' ,`ListOfficeName` = 'New Home Star Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.970958' ,`Longitude` = '-95.976852' ,`PhotoCount` = '17' ,`PostalCode` = '77414' ,`RoomCount` = '3' ,`ListPrice` = '139999.00' ,`Status` = 'Active' ,`StreetName` = 'Moore Avenue' ,`StreetNumber` = '3212' ,`StreetSuffix` = 'Avenue' ,`City` = 'Bay City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1040' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction ready for move-in immediately - This one-story plan with 3 bedrooms, 2 bath, one-story home is energy efficient, with an open concept kitchen overlooking the large living-dining combo, making this home perfect for entertaining. This home includes LED Lighting and vinyl plank flooring, and carpet in all bedrooms. Moen fixtures in a timeless chrome finish are placed throughout the home with espresso cabinetry. Beautiful black appliance package included, home is engineered and inspected by a third-party engineer, has a seer HVAC system, double pane insulated Low-E windows.\r\nFantastic Builder \'1-2-10\' Warranty' ,`Acres` = '0.1607' ,`Area` = '54' ,`BuilderName` = 'Censeo' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 21 BLK 7' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '132 - Bay City' ,`SchoolElementary` = 'TENIE HOLMES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BAY CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BAY CITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Morton-Corbett' ,`TaxAmount` = '1748' ,`TaxRate` = '2.4815' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664894032' WHERE `Matrix_Unique_ID` = '212986583' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213246709','1664894032','213246709','2022-10-04T05:12:06.633','62855367','Daniela Antelo','Keller Williams Realty - Memorial','','','29.827752','-95.446960','43','77018','8','1149900.00','Active','Saxon','1846','Drive','Houston','4','0','5','3386','Single-Family','SOFT CONTEMPORARY, original owner beauty in the heart of sought-after OAK FOREST. Completely custom-designed by Brickmoon Architects. Walking distance to TC Jester Park and trails. Home boasts countless details for the pickiest of buyers and PLENTY OF STORAGE SPACE. Kitchen has an oversized QUARTZ island, ideal to gather your entire family. OPEN CONCEPT, with the best incorporation of interior/exterior living. Exterior area boasts a POOL, green spaces and lounge area for your patio furniture. A true entertainer\'s dream, with easy to maintain POLISHED CONCRETE floors. First floor features a large office with a walk-in closet, which could be converted into a second primary room or gym. Second floor features real hard wood floors, oversized ceilings and plenty of natural light showering all the spaces of the home. A cozy media room with it\'s own bar! Second floor has access to a balcony, ideal to catch the sunrise or relax after long day of work. Easy access to all major areas of Houston.','0.1625','9','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','1','Oak Forest East Area','Central Gas','0','LT 27 BLK 75 OAK FOREST SEC 11','Patio Lot,Subdivision Lot','7080','Appraisal District','','','0','','2','Gas Oven','1','In Ground','','Gas Cooktop,Gas Range','','Composition','27 - Houston','STEVENS ELEMENTARY SCHOOL','WALTRIP HIGH SCHOOL','BLACK MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Contemporary/Modern,Traditional','Oak Forest Sec 11','19495','2.3307','Public Sewer,Public Water','2018','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T04:01:10.610' ,`MLSNumber` = '72495135' ,`ListAgentFullName` = 'Gregory Thomas' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.563036' ,`Longitude` = '-95.432330' ,`PhotoCount` = '32' ,`PostalCode` = '77584' ,`RoomCount` = '6' ,`ListPrice` = '469500.00' ,`Status` = 'Active' ,`StreetName` = 'Night Song' ,`StreetNumber` = '2703' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2950' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The two-story entry opens to a formal dining room currently used as a office while the family room features a soaring 20ft ceiling starting at the front door. The living room includes a wall of windows , corner cast-stone fireplace, granite countertops, and ceramic tile backsplash. Lighting features recessed can lighting and 42inch J-Kraft cabinets. The master bath has a separate shower and garden tub , dual vanities and a walk in closet. Large upstairs game room that overlooks the living room and the entry way.' ,`Acres` = '0.1584' ,`Area` = '38' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SHADOW CREEK RANCH SF-51B, BLOCK 2, LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6900' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '999' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BLUE RIDGE ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'WILLOWRIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'MCAULIFFE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadow Creek Ranch Sf-51b' ,`TaxAmount` = '9266' ,`TaxRate` = '3.2123' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664894032' WHERE `Matrix_Unique_ID` = '213247246' --> Updated record success