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-26T09:43:47.653' ,`MLSNumber` = '10757407' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.450801' ,`Longitude` = '-95.300914' ,`PhotoCount` = '23' ,`PostalCode` = '77511' ,`RoomCount` = '7' ,`ListPrice` = '449990.00' ,`Status` = 'Active' ,`StreetName` = 'Meritage' ,`StreetNumber` = '23502' ,`StreetSuffix` = 'Drive' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2799' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3 bedroom plus study and 2.5 baths, 2 car garage one-story home with granite kitchen countertops, very high-quality selections including crown molding, spectacular design detail and oversized upper kitchen cabinets awesome location. exceptional design elements, high ceilings, fireplace, fantastic curb appeal with rear covered patio, no back neighbors. Alvin ISD, close to medical centers, great dining, and shopping centers.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 39, Block 1, Section 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'HOOD-CASE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'G W HARBY J H' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Martha\'s Vineyard' ,`TaxAmount` = '' ,`TaxRate` = '3.748795' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703198' WHERE `Matrix_Unique_ID` = '203495732' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T08:39:42.867' ,`MLSNumber` = '85275800' ,`ListAgentFullName` = 'Darrell Anderson' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.697962' ,`Longitude` = '-95.364429' ,`PhotoCount` = '32' ,`PostalCode` = '77021' ,`RoomCount` = '3' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Luca' ,`StreetNumber` = '3631' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2734' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1993' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 27 BLK 5 LA SALETTE PLACE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8683' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'THOMPSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'La Salette Place Sec 02' ,`TaxAmount` = '3999' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703198' WHERE `Matrix_Unique_ID` = '204294490' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T08:22:45.527' ,`MLSNumber` = '59509300' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.220438' ,`Longitude` = '-95.712075' ,`PhotoCount` = '6' ,`PostalCode` = '77354' ,`RoomCount` = '8' ,`ListPrice` = '795900.00' ,`Status` = 'Active' ,`StreetName` = 'Ringbill' ,`StreetNumber` = '15418' ,`StreetSuffix` = 'Way' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3586' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 59509300 - Built by Drees Custom Homes - October completion! ~ The Eastland II is a fabulous design for a busy family. Private study rest at the front of the home. Just beyond the foyer, you\'ll enter the open living quad formed by the kitchen, family and breakfast rooms. The living space offers all the features you crave such as a walk-in pantry, ample serving island, cozy fireplace and access to the outdoor living area. The home also includes a media room and a luxurious owner\'s suite. Must See!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Drees Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 15 Block 2A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'WILLIE E. WILLIAMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Audubon' ,`TaxAmount` = '' ,`TaxRate` = '3.3' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703198' WHERE `Matrix_Unique_ID` = '205787809' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T09:30:43.010' ,`MLSNumber` = '48504533' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.950815' ,`Longitude` = '-95.197652' ,`PhotoCount` = '26' ,`PostalCode` = '77346' ,`RoomCount` = '15' ,`ListPrice` = '539957.00' ,`Status` = 'Active' ,`StreetName` = 'Roscobie Park' ,`StreetNumber` = '15651' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3040' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Ellicott, Elevation A) CURRENTLY BEING BUILT. Two story. 4 bedrooms, 3.5 baths. Primary suite with large walk-in closet. Second bedroom on first floor with private bath. Grand foyer with winding staircase & rotunda ceiling. First floor study and informal dining adjacent to the island kitchen. Upstairs additional 2 bedrooms, bathroom, game room and media room. Covered patio and attached 2 car garage. Forget the world outside and come home to Balmoral, a community surrounded by beauty and peace in the West Lake Houston area of northeast Beltway 8 in Humble, TX. Balmoral offers residents connected living with luxurious homes and many amenities to choose from, including the Houston area\'s Crystal Clear Lagoon surrounded by glistening white sand beaches. Stop by the Westin Homes model home today to find out more about Balmoral!' ,`Acres` = '0.1522' ,`Area` = '1' ,`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` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6629' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1430' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GROVES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Balmoral' ,`TaxAmount` = '1718' ,`TaxRate` = '3.5573' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703198' WHERE `Matrix_Unique_ID` = '205800946' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T09:23:25.693' ,`MLSNumber` = '63635920' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.342047' ,`Longitude` = '-95.026166' ,`PhotoCount` = '21' ,`PostalCode` = '77563' ,`RoomCount` = '8' ,`ListPrice` = '365990.00' ,`Status` = 'Active' ,`StreetName` = 'Parkview' ,`StreetNumber` = '7423' ,`StreetSuffix` = 'Drive' ,`City` = 'Hitchcock' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2817' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful one-story plan features 4 bedrooms, 2.5 bathrooms, Luxury Master bath with separate tub and shower and double sinks, 42\" inch cabinets, Granite countertops, Covered Patio, Large Family Room and Wrought Iron staircase, Upgraded Ridge Core flooring.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hitchcock' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 11, Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '26 - Hitchcock' ,`SchoolElementary` = 'HITCHCOCK PRIMARY/STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HITCHCOCK HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (HITCHCOCK)' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Parkview Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703198' WHERE `Matrix_Unique_ID` = '205941509' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T09:59:40.783' ,`MLSNumber` = '80961512' ,`ListAgentFullName` = 'Todd Anderson' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.690908' ,`Longitude` = '-95.474161' ,`PhotoCount` = '26' ,`PostalCode` = '77401' ,`RoomCount` = '5' ,`ListPrice` = '520000.00' ,`Status` = 'Active' ,`StreetName` = 'Maple' ,`StreetNumber` = '5221' ,`StreetSuffix` = 'Street' ,`City` = 'Bellaire' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1450' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Very charming, three bedroom two bath mid century Bellaire cottage on large lot in prime location. One floor living at its best. Steps away from Bellaire HS New with Praking garage. Enjoy the small town feel of Bellaire and convenient access to I-610, US 59, Med Center and Galleria Uptown destinations. Well maintained home with beautiful hardwood floors throughout the living area. Recently remodeled kitchen with granite countertops and stainless steel appliances. All bathrooms updated. Large fenced private yard with patio and storage shed. Painted in soft, neutral colors with abundant natural light. Pride of ownership throughout.' ,`Acres` = '0.1686' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bellaire Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 1 BRAEBURN GARDENS SEC 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7345' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Braeburn Gardens Sec 01' ,`TaxAmount` = '11097' ,`TaxRate` = '2.2271' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1952' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703198' WHERE `Matrix_Unique_ID` = '206706051' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T09:32:51.317' ,`MLSNumber` = '4635393' ,`ListAgentFullName` = 'Keith Owens' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.569144' ,`Longitude` = '-95.014056' ,`PhotoCount` = '44' ,`PostalCode` = '77586' ,`RoomCount` = '10' ,`ListPrice` = '725000.00' ,`Status` = 'Active' ,`StreetName` = 'Menard' ,`StreetNumber` = '2409' ,`StreetSuffix` = 'Avenue' ,`City` = 'Seabrook' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3922' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THE ULTIMATE COMBINATION OF SECLUSION, PRIVATE ENTERTAINING, FINE FINISHES & CONTEMPORARY STYLING JUST ONE BLOCK FROM THE BAY. THE GROUNDS ARE AN ENTERTAINERS DREAM W/ BRICK PATHWAYS LEADING TO PERGOLAS, DINING AREAS, FIREPITS, KOI POND, SCREENED IN PORCH & SITTING AREAS SURROUNDED BY TOWERING OAKS. STEP INSIDE TO WOOD & TILE FLOORS THROUGHOUT, SPACIOUS DEN W/ VAULTED CEILINGS & GAS FIREPLACE, FORMAL DINING W/ WETBAR OVERLOOKING THE LUSH GREENSPACE, UPDATED ISLAND KITCHEN W/ GRANITE COUNTERS, BUTLERS PANTRY & STAINLESS APPLIANCES, BREAKFAST ROOM W/ BALCONY, OFFICE W/ SLIDING FRENCH DOORS, FULL BATHROOM & A SPACIOUS PRIMARY SUITE W/ A SPA-LIKE BATH FEATURING MOLDED GLASS SINKS, WALK-IN SHOWER W/ LUXURY SHOWER SYSTEM & OVERSIZED FREESTANDING SOAKING TUB. 1ST LEVEL OFFERS 2 SECONDARY BEDROOMS, FULL BATH W/ DOUBLE SINKS, A 2ND PRIMARY SUITE W/ DBL SINKS & OVERSIZED WALK-IN SHOWER & A GRAND GAMEROOM LEADING TO THE OVERSIZED SCREENED-IN PORCH. ALSO INCL DBL PAIN WINDOWS & PEX PLUMBING.' ,`Acres` = '0.287' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 3 & 4 BLK 38 MORRISTOWN' ,`LotDesciption` = 'Greenbelt,Subdivision Lot,Wooded' ,`LotSize` = '12500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Morristown' ,`TaxAmount` = '12035' ,`TaxRate` = '2.2905' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703199' WHERE `Matrix_Unique_ID` = '207952923' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T08:43:20.620' ,`MLSNumber` = '37566585' ,`ListAgentFullName` = 'Elisa Rocha' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.239657' ,`Longitude` = '-94.907416' ,`PhotoCount` = '25' ,`PostalCode` = '77554' ,`RoomCount` = '6' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Sonny' ,`StreetNumber` = '2808' ,`StreetSuffix` = 'Lane' ,`City` = 'Galveston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '999' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A positively charming Galveston bungalow with updates and upgrades throughout! This three-bedroom home features a functional floorplan, complete with waterproof vinyl flooring, energy-efficient windows, new ceiling fans, modern paint color selection, and many ADA-compliant features. The kitchen is fitted with quartz countertops, new pendant lighting, stainless steel appliances including a new range, microwave, dishwasher, crisp white cabinetry, and a new stackable front loading washer and dryer. Classic subway tile completes the space Three bedrooms with ceiling fans share an updated bathroom, fitted with a tub and shower design, framed mirror, and brushed nickel fixtures. Outdoors, enjoy access to a covered balcony area, covered parking space, and an elevator lift for added convenience. Enjoy Moody Gardens Hotel and Spa just over 3 miles away. Conveniently located just blocks from Oxen Bayou, the West Bay, and minutes from Stewart Road.' ,`Acres` = '0.305' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 121 PAGE 59 LOT 3 SONNY LANE UNRECORDED SUB' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13286' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunnylane Unrec T&L' ,`TaxAmount` = '5492' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703199' WHERE `Matrix_Unique_ID` = '207966158' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T09:22:33.250' ,`MLSNumber` = '87466001' ,`ListAgentFullName` = 'Walter Bering' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.753138' ,`Longitude` = '-95.443145' ,`PhotoCount` = '50' ,`PostalCode` = '77019' ,`RoomCount` = '22' ,`ListPrice` = '7500000.00' ,`Status` = 'Active' ,`StreetName` = 'Inverness' ,`StreetNumber` = '3940' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '7' ,`BathsHalf` = '4' ,`BedsTotal` = '5' ,`SqFtTotal` = '11737' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Situated on approximately 2.8 acres, this River Oaks home has been called a \'residential country club\'. It has been the setting for many grand events and a motion picture. Situated in a park-like setting, the property offers swimming pools, lighted tennis court, party pavilion, outdoor kitchen and bar, and multi-level patio areas. The outdoor party pavilion is a large covered structure with beamed ceiling, bar area, and stage. Tennis court with gallery seating area. The interior living areas are nicely appointed with detailed moldings and hardwood floors. The formal living and dining rooms offer panoramic views of the wooded landscape. Primary bedroom suite features separate dressing areas and closets, office/sitting area, and fabulous views. The lower level is ideally suited as a large game room and open entertaining area with wetbar and adjoining separate dressing rooms/pool bath. Potential exercise room on the lower level. Truly nothing else like this property in River Oaks!' ,`Acres` = '2.8' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'River Oaks Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'TRS 2B-2 & 2C BLK 92 RIVER OAKS TALL TIMBERS' ,`LotDesciption` = 'Subdivision Lot,Waterfront,Wooded' ,`LotSize` = '122100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '4708' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'RIVER OAKS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2.5' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'River Oaks Tall Timbers' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703199' WHERE `Matrix_Unique_ID` = '208150069' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T08:20:04.150' ,`MLSNumber` = '8288504' ,`ListAgentFullName` = 'Blake Vincent' ,`ListOfficeName` = 'DUX Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.791254' ,`Longitude` = '-95.408138' ,`PhotoCount` = '42' ,`PostalCode` = '77008' ,`RoomCount` = '11' ,`ListPrice` = '739900.00' ,`Status` = 'Active' ,`StreetName` = 'ALEXANDER' ,`StreetNumber` = '1137' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2506' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Mazzarino Construction & Development\'s new division is here in Houston\'s well established inner loop neighborhoods. MazzTao Homes features a new, stylish, well priced, quality home, but with an entirely different price point. You no longer have to compromise your location to buy somewhere or something else, that you just don’t really want. This home features an extremely versatile and functional floor plan. The floor plan has 3 bedrooms, 2.5 bathrooms , primary suite with 2 generous walk-in closet, first floor living, flex room, a private driveway, and approx. 750 sf of backyard green space. Retail, restaurants, gym, groceries, you name it, it\'s walking distance away. Major freeways, downtown, medical center, parks, theater, art & museum districts are all within minutes. Ask about customization options during construction ONLY! * NOTE: PHOTOS IN LISTING ARE OF A MODEL HOME W/A SIMILAR FLOOR PLAN &/OR UPGRADE/ FINISHES. PLANS & SELECTIONS ARE SUBJECT TO CHANGE W/OUT NOTIFICATION *' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'MAZZTAO HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 ALEXANDER GREEN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'ALEXANDER GREEN' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703199' WHERE `Matrix_Unique_ID` = '209499862' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T09:37:32.080' ,`MLSNumber` = '68836954' ,`ListAgentFullName` = 'Vishal Patel' ,`ListOfficeName` = 'CB&A, Realtors-Katy' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.642750' ,`Longitude` = '-95.751286' ,`PhotoCount` = '50' ,`PostalCode` = '77406' ,`RoomCount` = '23' ,`ListPrice` = '1610000.00' ,`Status` = 'Active' ,`StreetName` = 'Hinkles Fry' ,`StreetNumber` = '2510' ,`StreetSuffix` = '' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '6458' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME HOME to this beautiful, custom-built marvel on a cul-de-sac in the prestigious TEXANA PLANTATION subdivision. The home sits on a HUMONGOUS 2.6-acre lot & has number of super spacious rooms that fits almost any buyers\' requirements. A private driveway leads to the beautiful double wide front door. Vaulted ceilings, stone, wood flooring, stucco and gable roof complete the home\'s beauty. The elegant kitchen with granite countertop is perfect for cooking all your famous culinary dishes and entertaining guests for a lovely dinner. The backyard boasts of a HUGE covered outdoor patio w/kitchen which overlooks the sparkling SWIMMING POOL with SPA. A spectacular large balcony on 2nd floor is accessible from Game room & bedroom. The home has so many extra rooms like the Home Office/Study, small library, GAME ROOM, the DEN with beautiful tall windows and acts as a GYM or extra bedroom. The super cozy MEDIA ROOM is perfect for movie nights & binge watching. The home has never flooded.' ,`Acres` = '2.5886' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Texana Plantation Sec 6, Block 1, Lot 7' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '112761' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Texana Plantation' ,`TaxAmount` = '' ,`TaxRate` = '2.16' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703199' WHERE `Matrix_Unique_ID` = '209606981' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T08:35:52.273' ,`MLSNumber` = '48079425' ,`ListAgentFullName` = 'Yeira Baldazo' ,`ListOfficeName` = 'Century 21 ExclusiveProperties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.664405' ,`Longitude` = '-95.268911' ,`PhotoCount` = '38' ,`PostalCode` = '77061' ,`RoomCount` = '10' ,`ListPrice` = '340000.00' ,`Status` = 'Active' ,`StreetName` = 'Anacortes' ,`StreetNumber` = '8206' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2334' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'O-M-G this home has been completely renovated! Who is ready for a New Kitchen, New Bathrooms, New Home! Come see all the new upgrades. This home has 4 roomy bedrooms, office space, den, family room, and 2 fully upgraded bathrooms! So much space to grow into. It sits on a 9000 sqft lot with a detached garage. Refinished hardwood floors and new tile flooring. The electrical box has also been updated. Close to I-45 and Hobby Airport.' ,`Acres` = '0.2066' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 9 & 10A BLK 14 MEADOWBROOK FREEWAY SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LEWIS/Bellfort Academy' ,`SchoolHigh` = 'CHAVEZ HIGH SCHOOL' ,`SchoolMiddle` = 'ORTIZ MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meadowbrook Fwy Sec 02' ,`TaxAmount` = '4456' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703199' WHERE `Matrix_Unique_ID` = '209773655' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T08:43:44.100' ,`MLSNumber` = '16499099' ,`ListAgentFullName` = 'Deborah Jamail' ,`ListOfficeName` = 'Neptune Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.386169' ,`Longitude` = '-94.898232' ,`PhotoCount` = '27' ,`PostalCode` = '77590' ,`RoomCount` = '6' ,`ListPrice` = '152000.00' ,`Status` = 'Active' ,`StreetName` = '3rd' ,`StreetNumber` = '201' ,`StreetSuffix` = 'Street' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1080' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful starter home on a corner lot in Texas City. Lots of renovations going on in this area. Great home with 3 bedrooms & 2 baths. Large living room and cozy kitchen which opens to the bright & sunny breakfast room. The back bedroom is being used for a laundry area [seller\'s elderly mother did not want to go out to garage] Can easily be changed back to that 3rd bedroom. Bath in this bedroom. Extra-large secondary bathroom for the other 2 bedrooms. Home got a new roof in 2019, new AC unit 2018 & new electric 2018. Sellers would like to sell furnished with a few exceptions. Park across the street. Close to plants, schools, restaurants & Dike. Bring your offers...Seller is ready to move this property.' ,`Acres` = '0.0918' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 205 PAGE 6 S 40 FT OF LOTS 13 THRU 16 (13-2) BLK 50 TEX' ,`LotDesciption` = 'Corner' ,`LotSize` = '4000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HEIGHTS ELEMENTARY SCHOOL (TEXAS CITY)' ,`SchoolHigh` = 'TEXAS CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BLOCKER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Texas City' ,`TaxAmount` = '3093' ,`TaxRate` = '2.5335' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703199' WHERE `Matrix_Unique_ID` = '209847816' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T09:33:47.320' ,`MLSNumber` = '26596894' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.153466' ,`Longitude` = '-95.580941' ,`PhotoCount` = '8' ,`PostalCode` = '77354' ,`RoomCount` = '16' ,`ListPrice` = '649747.00' ,`Status` = 'Active' ,`StreetName` = 'Regal Scott' ,`StreetNumber` = '27116' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3826' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Carter III, Elevation H) CURRENTLY BEING BUILT. Two Story. 4 bedrooms, 3.5 baths. Private Primary Suite with spacious double walk-in closets. Formal Living and Dining Rooms and Spacious Kitchen with breakfast area open to Family Room. Spacious Game Room and private Media Room upstairs. Extended covered patio and attached 2 car garage. NorthGrove offers easy access to all the conveniences and necessities of modern living with The Woodlands, Tomball, and Conroe all a short distance away. With resort-style amenities, including The Retreat, a 9,400-sq.-ft. clubhouse, Northgrove is the perfect escape from the daily grind. Enjoy a fitness center, pool, children\'s play areas and more. Stop by the Westin Homes model home today to find out more about Northgrove!' ,`Acres` = '0.1997' ,`Area` = '15' ,`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` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BLOCK 4, LOT 19' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8698' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1295' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Northgrove' ,`TaxAmount` = '2250' ,`TaxRate` = '3.2087' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703199' WHERE `Matrix_Unique_ID` = '210131226' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T08:06:43.520' ,`MLSNumber` = '4841743' ,`ListAgentFullName` = 'Mariko Fujita' ,`ListOfficeName` = 'Annoura Realty Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.685842' ,`Longitude` = '-95.800658' ,`PhotoCount` = '49' ,`PostalCode` = '77406' ,`RoomCount` = '9' ,`ListPrice` = '369500.00' ,`Status` = 'Active' ,`StreetName` = 'San Pellino' ,`StreetNumber` = '24507' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2375' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PRICE REDUCED!!!!!!!MOTIVATED SELLER!!!! Lovely 2 story home, 4 bedroom and 2.5 bathroom located in the popular Lakes of Bella Terra subdivision! This beautiful home has plenty to offer including stone and brink exterior, front and back covered porch with a nice hot tub, and NEWER ROOF (2019)! Kitchen has a granite countertop and tile backsplash (WOW!). Enjoy cooking with some companies at the breakfast bar or in living room. Master bedroom is downstairs and all bedrooms up. (ceiling fans in ALL rooms) Specious game room to enjoy movie night with family and friends. Elementary school is just around the corner and easy access to west park tollway for a commute! Beautiful subdivision offers 3 pools, fitness center, tennis courts, sand volleyball court, soccer field, 5 playgrounds, fishing pond, and walking/bike tails! NO CARPET in the house. This will not last long. BOOK YOUR SHOWINGS TODAY!' ,`Acres` = '0.144' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKES OF BELLA TERRA SEC 3, BLOCK 1, LOT 19' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6271' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUBENAK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes Of Bella Terra Sec 3' ,`TaxAmount` = '7237' ,`TaxRate` = '3.0848' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703200' WHERE `Matrix_Unique_ID` = '210250669' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T09:54:00.510' ,`MLSNumber` = '49400570' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.894045' ,`Longitude` = '-95.075137' ,`PhotoCount` = '16' ,`PostalCode` = '77532' ,`RoomCount` = '6' ,`ListPrice` = '278990.00' ,`Status` = 'Active' ,`StreetName` = 'Alberta Spruce' ,`StreetNumber` = '14306' ,`StreetSuffix` = 'Lane' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The attractive Pedernales plan holds four large bedrooms, two full bathrooms & an oversized pantry!' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 7, Block 4, Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'CROSBY ELEMENTARY SCHOOL (CROSBY)' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pecan Estates' ,`TaxAmount` = '' ,`TaxRate` = '3.6256' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703200' WHERE `Matrix_Unique_ID` = '210292314' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T08:44:11.333' ,`MLSNumber` = '30585023' ,`ListAgentFullName` = 'Deborah Jamail' ,`ListOfficeName` = 'Neptune Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.918224' ,`Longitude` = '-95.274915' ,`PhotoCount` = '49' ,`PostalCode` = '75862' ,`RoomCount` = '6' ,`ListPrice` = '255000.00' ,`Status` = 'Active' ,`StreetName` = 'Lakeway' ,`StreetNumber` = '132' ,`StreetSuffix` = 'Circle' ,`City` = 'Trinity' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2128' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful property, over 1/2 acre in sought after Timber Cove. Quaint home with lots of space. Extra Large Livingroom with wood burning fireplace, new laminate flooring. Formal dining room with ample space for entertaining family & friends. Spacious kitchen with a plethora of cupboards, countertops. Handy kitchen Island with drop in stove top, double ovens. New dishwasher double sinks & a second small sink [could be wet bar area] Generously sized bedrooms with 3rd bedroom being used as a music/game room. Master with en-suite bath. Sliding doors out to deck and hot tub [which remains with home] Lake views from patio & deck. Metal roof, newer AC [2018] new garage/workshop on cement slab. Chicken coup, storage building. So much in this great home. Make your appointment to see this home today. Please note... Vacation Rental is NOT allowed.' ,`Acres` = '0.58' ,`Area` = '42' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TIMBER COVE, LOT 01- 04' ,`LotDesciption` = 'Cleared,Corner,Water View' ,`LotSize` = '25250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (HEB)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Right Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Timber Cove' ,`TaxAmount` = '1916' ,`TaxRate` = '1.8863' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703200' WHERE `Matrix_Unique_ID` = '210337815' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T09:19:00.580' ,`MLSNumber` = '80116492' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.136778' ,`Longitude` = '-95.046886' ,`PhotoCount` = '6' ,`PostalCode` = '77327' ,`RoomCount` = '7' ,`ListPrice` = '230000.00' ,`Status` = 'Active' ,`StreetName` = 'Road 5203' ,`StreetNumber` = '614' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1189' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This two-story home offers everything you need to live a comfortable lifestyle, and is located on a LARGE HOMESITE! An open concept living area is in the back of the first floor with a modern kitchen and family room. Upstairs, two bedrooms are situated at the front of the home, perfect for kids or a home office. The owner’s suite is tucked into the back with a full bathroom and walk-in closet.\r\n\r\nPrices and features may vary and are subject to change. Photos are for illustrative purposes only.' ,`Acres` = '' ,`Area` = '52' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0004 BLK 068 LOT 6200' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13969' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Fe' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703200' WHERE `Matrix_Unique_ID` = '210386504' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T09:12:58.967' ,`MLSNumber` = '21431840' ,`ListAgentFullName` = 'Nathan Haley' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.297676' ,`Longitude` = '-94.811702' ,`PhotoCount` = '13' ,`PostalCode` = '77550' ,`RoomCount` = '1' ,`ListPrice` = '270000.00' ,`Status` = 'Active' ,`StreetName` = 'Winnie' ,`StreetNumber` = '3911' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '1506' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home has been updated. Kitchen has been remodeled with granite countertops, new sink, new appliances, and backsplash. Bathroom has updates which include a tile surround shower. This home has a new roof, new a/c window units, and has been painted inside and out. New ceiling fans and fixtures throughout home. To finish off the updates this property has new flooring throughout. You can live in one and rent the other two apartments and cash flow. All three are rented out now and cash flowing. In October one tenant will be moving out, you can rent out again or live in the home. Great investment property that we have done all the work on it already. This is two separate addresses with two legal separate lots sold as one.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Harborside' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR OT S 1 THRU 5 (5-1) BLK 399' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Galveston Townsite' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703200' WHERE `Matrix_Unique_ID` = '210811109' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T09:13:25.940' ,`MLSNumber` = '49045393' ,`ListAgentFullName` = 'Nathan Haley' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.297659' ,`Longitude` = '-94.811766' ,`PhotoCount` = '15' ,`PostalCode` = '77550' ,`RoomCount` = '1' ,`ListPrice` = '270000.00' ,`Status` = 'Active' ,`StreetName` = 'Winnie' ,`StreetNumber` = '3913' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '1506' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home has been updated. Kitchen has been remodeled with granite countertops, new sink, new appliances, and backsplash. Bathroom has updates which include a tile surround shower. This home has a new roof, new a/c window units, and has been painted inside and out. New ceiling fans, and fixtures throughout home. To finish off the updates this property has new flooring throughout. You can live in one and rent the other two apartments and cash flow. All three are rented out now and cash flowing. In October one tenant will be moving out, you can rent out again or live in the home. Great investment property that we have done all the work to it already. This is two separate addresses with two legal separate lots sold as one.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Harborside' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOT S 1 THRU 5 (4-3) BLK 339' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Galveston Townsite' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703200' WHERE `Matrix_Unique_ID` = '211003779' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T09:59:42.127' ,`MLSNumber` = '71473988' ,`ListAgentFullName` = 'Melissa Hegemeyer' ,`ListOfficeName` = 'Hegemeyer Realty & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.000224' ,`Longitude` = '-95.847714' ,`PhotoCount` = '42' ,`PostalCode` = '77447' ,`RoomCount` = '6' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Springflight' ,`StreetNumber` = '26927' ,`StreetSuffix` = 'Lane' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1669' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in Hockley, in the heart of rapidly growing western Harris County, this 1,669-sf home with 3 bedrooms and 2 ½ baths that sits on a corner 6,396-sf lot will exceed your expectations. The covered patio and large fenced back yard create a welcoming space for your pets as well as plenty of room for entertaining friends and family. The clean lines and neutral palette of its contemporary interior are sure to please and provide an amazing backdrop for your décor of choice. Updated flooring in living room and new carpet upstairs. Zoned for the highly-rated Waller ISD and convenient access to the US 290 corridor for commutes to nearby metropolitan areas make this home a particularly attractive choice. Call today for an appointment to come check it out.' ,`Acres` = '0.1468' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 3 MALLARD CROSSING SEC 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '6396' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '280' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = '' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mallard Crossing' ,`TaxAmount` = '5849' ,`TaxRate` = '3.256' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703200' WHERE `Matrix_Unique_ID` = '211094810' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T09:21:31.943' ,`MLSNumber` = '74182034' ,`ListAgentFullName` = 'Nazario Trujillo' ,`ListOfficeName` = 'SIS Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.014859' ,`Longitude` = '-95.322816' ,`PhotoCount` = '40' ,`PostalCode` = '77338' ,`RoomCount` = '5' ,`ListPrice` = '699910.00' ,`Status` = 'Active' ,`StreetName` = 'Maple' ,`StreetNumber` = '6715' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1204' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home with 2 bedrooms with full bath each, kitchen/living and family room, plus there is a 7000 sqft concrete slab that could be the foundation for your new home or business venture, seller already has the bluprints. The property has no restrictions. Build a commercial building or your dream home. Contact the listing agent for more details and information. All measurements should be verified by the buyer or buyer\'s agent. Please allow at least one hour to one hour and 30 minutes before showing.' ,`Acres` = '2.35' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 12 BLK 2 CYPRESS GARDENS' ,`LotDesciption` = 'Cleared,Other' ,`LotSize` = '102366' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CYPRESSWOOD ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Left Side,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style,Ranch' ,`Subdivision` = 'Cypress Gardens' ,`TaxAmount` = '7210' ,`TaxRate` = '2.0933' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703201' WHERE `Matrix_Unique_ID` = '211640342' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T09:54:03.053' ,`MLSNumber` = '37756188' ,`ListAgentFullName` = 'Michael Seder' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.090590' ,`Longitude` = '-95.341428' ,`PhotoCount` = '34' ,`PostalCode` = '77386' ,`RoomCount` = '12' ,`ListPrice` = '1425000.00' ,`Status` = 'Active' ,`StreetName` = 'Newport' ,`StreetNumber` = '5015' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4801' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spectacular custom home on over an acre in Benders Landing Estates! Situated on a corner lot, this home features a gated entry, travertine flooring, neutral paint palette, gorgeous wrought iron staircase, detailed trim work, plantation shutters, amazing storage, tons of windows and an open concept. Grand entry with rotunda ceiling; study with French doors; spacious formal dining; den with gas log fireplace opens to the breakfast room and huge island kitchen with breakfast bar and plenty of cabinet storage; owner\'s retreat down; 3 bedrooms, game room and media room up with kitchenette; private backyard has a covered patio, heated pool with PebbleTec finish and waterfall, spa, outdoor kitchen and fireplace, walking path and garden, all surrounded by impeccable landscaping. Benders Landing Estates amenities include a clubhouse with fitness center, stocked lakes for fishing, soccer fields, basketball and tennis courts, parks and playgrounds.' ,`Acres` = '1.065' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S257204 - BENDERS LANDING ESTATES 04, BLOCK 3, LOT 13' ,`LotDesciption` = 'Corner,Cul-De-Sac,Wooded' ,`LotSize` = '46392' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'ANN K. SNYDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'English' ,`Subdivision` = 'Benders Landing Estates 04' ,`TaxAmount` = '14916' ,`TaxRate` = '1.8487' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703201' WHERE `Matrix_Unique_ID` = '211701032' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T08:25:24.627' ,`MLSNumber` = '27776796' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.168525' ,`Longitude` = '-95.185775' ,`PhotoCount` = '7' ,`PostalCode` = '77357' ,`RoomCount` = '16' ,`ListPrice` = '524916.00' ,`Status` = 'Active' ,`StreetName` = 'Toscana' ,`StreetNumber` = '18915' ,`StreetSuffix` = 'Lane' ,`City` = 'New Caney' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3308' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Bellagio II, Elevation D) CURRENTLY BEING BUILT. Two story. 4 bedrooms. 3.5 baths. Family room, formal dining room, study. Spacious island kitchen with breakfast area open to family room. Primary suite downstairs with large walk-in closet. Spacious game room and media room upstairs. Extended covered patio and attached 2 car garage. Tavola, northeast Houston\'s newest master-planned community, features amenities such as a recreation center with a pool, park with a unique zip line and clubhouse, pocket parks and miles of wooded greenbelt trails that wind throughout the community. Tavola’s convenient location caters to major employment centers including the Greenspoint Business District and the new ExxonMobil campus. Located seven miles north of Kingwood and just two exits north of the new Grand Parkway, Tavola’s ideal location will easily link this community to any area of Houston. Stop by the Westin Homes home to learn more about Tavola!' ,`Acres` = '' ,`Area` = '40' ,`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` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 3 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7615' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'TAVOLA ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tavola' ,`TaxAmount` = '' ,`TaxRate` = '3.34' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703201' WHERE `Matrix_Unique_ID` = '211737917' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T08:10:00.260' ,`MLSNumber` = '40840350' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.960131' ,`Longitude` = '-95.202586' ,`PhotoCount` = '29' ,`PostalCode` = '77346' ,`RoomCount` = '16' ,`ListPrice` = '649587.00' ,`Status` = 'Active' ,`StreetName` = 'Gramina' ,`StreetNumber` = '11906' ,`StreetSuffix` = 'Way' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3792' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Hopkins III, Elevation F) Two Story. 4 bedrooms, 3.5 baths. Elegant double front door entry. Primary suite with spacious walk-in closet. Spacious island kitchen with breakfast area is open to the family room. Formal dining room. First floor study. Second floor game room, media room and additional 3 bedrooms. Extended covered rear patio and attached 2 car garage. Featuring new homes near Lake Houston and nearly 1,000 acres of wooded bliss, The Groves is a one-of-a-kind master-planned community. It is conveniently located in the acclaimed Humble ISD with easy access to Beltway 8 and Hwy 59. The Hearth Amenity Center is the center of this community and features a resort-style pool, an oversized hearth fireplace with cozy bistro seating and soft festoon lighting. Stop by the Westin Homes model home today to find out more about The Groves!' ,`Acres` = '' ,`Area` = '1' ,`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` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 29 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8386' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1056' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GROVES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Groves' ,`TaxAmount` = '' ,`TaxRate` = '3.7' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703201' WHERE `Matrix_Unique_ID` = '211741826' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T08:10:35.703' ,`MLSNumber` = '40574575' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.960131' ,`Longitude` = '-95.202995' ,`PhotoCount` = '29' ,`PostalCode` = '77346' ,`RoomCount` = '18' ,`ListPrice` = '659853.00' ,`Status` = 'Active' ,`StreetName` = 'Gramina' ,`StreetNumber` = '11902' ,`StreetSuffix` = 'Way' ,`City` = 'Humble' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Carter IX, Elevation M) CURRENTLY BEING BUILT. Two story. 5 bedrooms, 4.5 baths. Primary suite downstairs with large walk-in closet. Secondary bedroom on first floor with private bath as well. Formal dining room and study. Spacious island kitchen with breakfast area open to family room. Upstairs game room with media room plus three secondary bedrooms. Covered patio and 2 car attached garage. Featuring new homes near Lake Houston and nearly 1,000 acres of wooded bliss, The Groves is a one-of-a-kind master-planned community. It is conveniently located in the acclaimed Humble ISD with easy access to Beltway 8 and Hwy 59. The Hearth Amenity Center is the center of this community and features a resort-style pool, an oversized hearth fireplace with cozy bistro seating and soft festoon lighting. Stop by the Westin Homes model home today to find out more about The Groves!' ,`Acres` = '' ,`Area` = '1' ,`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` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 30 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8147' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1056' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GROVES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Groves' ,`TaxAmount` = '' ,`TaxRate` = '3.7' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703201' WHERE `Matrix_Unique_ID` = '211743241' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T08:09:26.003' ,`MLSNumber` = '7691469' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.960915' ,`Longitude` = '-95.201009' ,`PhotoCount` = '29' ,`PostalCode` = '77346' ,`RoomCount` = '18' ,`ListPrice` = '659852.00' ,`Status` = 'Active' ,`StreetName` = 'Walden Pines' ,`StreetNumber` = '11950' ,`StreetSuffix` = 'Road' ,`City` = 'Humble' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3774' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Carter IX, Elevation M) CURRENTLY BEING BUILT. Two story. 5 bedrooms, 4.5 baths. Primary suite downstairs with large double walk-in closets. Secondary bedroom on first floor with private bath as well. Formal dining room and study. Spacious island kitchen with breakfast area open to family room. Upstairs game room with media room plus three secondary bedrooms. Covered patio and 2 car attached garage. Featuring new homes near Lake Houston and nearly 1,000 acres of wooded bliss, The Groves is a one-of-a-kind master-planned community. It is conveniently located in the acclaimed Humble ISD with easy access to Beltway 8 and Hwy 59. The Hearth Amenity Center is the center of this community and features a resort-style pool, an oversized hearth fireplace with cozy bistro seating and soft festoon lighting. Stop by the Westin Homes model home today to find out more about The Groves!' ,`Acres` = '' ,`Area` = '1' ,`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` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8581' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1056' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GROVES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Groves' ,`TaxAmount` = '' ,`TaxRate` = '3.7' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703201' WHERE `Matrix_Unique_ID` = '211744138' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T08:22:46.963' ,`MLSNumber` = '30565060' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.842022' ,`Longitude` = '-95.861271' ,`PhotoCount` = '27' ,`PostalCode` = '77493' ,`RoomCount` = '13' ,`ListPrice` = '524637.00' ,`Status` = 'Active' ,`StreetName` = 'Bahia Bay' ,`StreetNumber` = '808' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2600' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Staten, Elevation A) CURRENTLY BEING BUILT. Two story. 4 bedrooms. 2.5 baths. Family Room, Study and Informal Dining. Spacious island kitchen open to living area. Primary suite with large double walk-in closets. Three additional bedrooms and game room upstairs. Covered patio with 2-car garage. Located a few miles north of Interstate 10 and west of the Grand Parkway in thriving Katy, Sunterra is an inviting 1,039-acre master-planned community featuring home designs that fit your lifestyle, Sunterra is a launch pad for family adventures. Splash, play, paddleboard, build sandcastles and more at our gorgeous Crystal Lagoons® amenity. Designed to fit your lifestyle, the master plan calls for approximately 2,200 homes, lakes, parks, playgrounds and an expansive Amenity Village with a clubhouse and a pool overlooking the lagoon. Stop by the Westin Homes sales model to learn more about Sunterra!' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 10 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7370' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.28' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703202' WHERE `Matrix_Unique_ID` = '211744839' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T09:18:50.987' ,`MLSNumber` = '45822238' ,`ListAgentFullName` = 'Maria Giovinale' ,`ListOfficeName` = 'RE/MAX Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.161551' ,`Longitude` = '-95.151233' ,`PhotoCount` = '7' ,`PostalCode` = '77357' ,`RoomCount` = '4' ,`ListPrice` = '289900.00' ,`Status` = 'Active' ,`StreetName` = 'Galaxy' ,`StreetNumber` = '19245' ,`StreetSuffix` = 'Boulevard' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1820' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 19245 Galaxy Blvd!! This gorgeous new construction home is surrounded by beautiful green scenarios and located inside a very peaceful and quiet neighborhood. The house has 10’ ceilings in the kitchen and living areas and an open concept floorplan which integrates perfectly all the common areas making it perfect for entertaining. The kitchen is equipped with 42” upper cabinets, a large functional kitchen island and granite countertops. The bedrooms have large and spacious walk-in closets. It comes with the Samsung Stainless Steel package including easy clean top range with electric oven, 3 racks dishwasher and microwave. Buyer will obtain 1 year warranty on appliances from Samsung. Come and see this beautiful home!' ,`Acres` = '0.39' ,`Area` = '40' ,`BuilderName` = 'Starter Homes of TX' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'KINGS COLONY 01, BLOCK 2, LOT 27, ACRES 0.390' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '16988' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '180' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'DOGWOOD ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kings Colony 01' ,`TaxAmount` = '18' ,`TaxRate` = '2.1331' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703202' WHERE `Matrix_Unique_ID` = '211783132' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T08:50:47.547' ,`MLSNumber` = '90840733' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.921078' ,`Longitude` = '-95.733290' ,`PhotoCount` = '18' ,`PostalCode` = '77433' ,`RoomCount` = '11' ,`ListPrice` = '751653.00' ,`Status` = 'Active' ,`StreetName` = 'Big Spring Park' ,`StreetNumber` = '15030' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3610' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW!!! Village Builders Wentworth Collection Preston design with Stucco/Stone/Brick Elevation \"J\" in Bridgeland! This fabulous two-story home features a gorgeous rotunda entry that leads to a large Great Room, adjoining the gourmet kitchen and dining room. The tucked away first-floor owner’s suite offers a luxurious bathroom, while three bedrooms near the foyer provide private space. Upstairs hosts a spacious game room and an optional media room addition on select homesites. Virtual tour is a representation of the floor plan not the actual home. *HOME ESTIMATED TO BE COMPLETE December, 2022*' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0047 BLK 001 LOT 024' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1197' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MCGOWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.5407' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703202' WHERE `Matrix_Unique_ID` = '211808482' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T09:10:27.713' ,`MLSNumber` = '17803269' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.920948' ,`Longitude` = '-95.732526' ,`PhotoCount` = '11' ,`PostalCode` = '77433' ,`RoomCount` = '12' ,`ListPrice` = '771493.00' ,`Status` = 'Active' ,`StreetName` = 'Big Spring Park' ,`StreetNumber` = '15014' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3936' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW!!! CY FAIR ISD! Village Builders Wentworth Collection Berkshire design with Stucco/Stone/Brick Elevation \"J\" in Bridgeland! This spacious two-story home features a grand entry foyer that flows into the kitchen, dining nook and Great Room. The first-floor owner’s suite offers separate vanities and a large shower with seating. Three bedrooms, a game room and an optional media room on the second floor offer endless possibilities. Virtual tour is a representation of the floor plan and not the actual home. *HOME ESTIMATED TO BE COMPLETE February, 2023*' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Village Builders' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0047 BLK 001 LOT 028' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1197' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MCGOWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.5407' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703202' WHERE `Matrix_Unique_ID` = '211828235' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T09:46:22.743' ,`MLSNumber` = '34252091' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '29.442210' ,`Longitude` = '-95.249264' ,`PhotoCount` = '16' ,`PostalCode` = '77511' ,`RoomCount` = '15' ,`ListPrice` = '436960.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Kenley' ,`StreetNumber` = '1860' ,`StreetSuffix` = 'Way' ,`City` = 'Alvin' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2839' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming Walton II home features a brick and stone elevation, 4 bedrooms, 3.5 baths and 2 car garage. Convenient home office off hall. Elegant dining room with easy access to kitchen. Maple cabinets and granite countertops in kitchen. Huge walk-in closet, dual vanity sinks, separate tub and shower in owner\'s luxury bath. Upstairs, you\'ll find a cozy activity room and all secondary bedrooms. Covered patio in backyard, perfect for entertaining. Offered by: K. Hovnanian Houston Midtown Park I, LLC.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'K. Hovnanian' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '14/4/3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'HASSE ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'G W HARBY J H' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Midtown Park' ,`TaxAmount` = '' ,`TaxRate` = '2.885' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703202' WHERE `Matrix_Unique_ID` = '211845872' --> Updated record success