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` = '2023-01-30T14:52:30.990' ,`MLSNumber` = '85611075' ,`ListAgentFullName` = 'Darren Upp' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.781212' ,`Longitude` = '-95.369568' ,`PhotoCount` = '6' ,`PostalCode` = '77009' ,`RoomCount` = '6' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Wrightwood' ,`StreetNumber` = '1218' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1889' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3 bedroom, 2 bath. Has detached 1 car garage. Close to downtown & bayou. Located in the 100 year flood plain and property has previously flooded. Serious buyers only.' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 24 WRIGHTWOOD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wrightwood' ,`TaxAmount` = '' ,`TaxRate` = '2.330662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1904' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675266366' WHERE `Matrix_Unique_ID` = '188979737' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T13:00:45.880' ,`MLSNumber` = '35707204' ,`ListAgentFullName` = 'Asad Asaduddin' ,`ListOfficeName` = 'Columbia Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.590510' ,`Longitude` = '-96.342465' ,`PhotoCount` = '7' ,`PostalCode` = '77434' ,`RoomCount` = '3' ,`ListPrice` = '141500.00' ,`Status` = 'Active' ,`StreetName` = 'Hubbards Ferry' ,`StreetNumber` = '403' ,`StreetSuffix` = 'Road' ,`City` = 'Eagle Lake' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1320' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well maintained home close to golf course. Extra-large lot. Never flooded!' ,`Acres` = '0.46' ,`Area` = '56' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BLK 7 LT 2-4 SIMMONS EAGLE LAKE & HOUSE' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '20200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '161 - Rice Consolidated' ,`SchoolElementary` = 'EAGLE LAKE INTERMEDIATE SCHOOL' ,`SchoolHigh` = 'RICE HIGH SCHOOL (RICE CISD)' ,`SchoolMiddle` = 'RICE JUNIOR HIGH SCHOOL (RICE CISD)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'English' ,`Subdivision` = 'Simmons' ,`TaxAmount` = '2541' ,`TaxRate` = '2.5343' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266366' WHERE `Matrix_Unique_ID` = '204317421' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T13:58:37.013' ,`MLSNumber` = '46113122' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.397936' ,`Longitude` = '-95.498648' ,`PhotoCount` = '34' ,`PostalCode` = '77318' ,`RoomCount` = '10' ,`ListPrice` = '690000.00' ,`Status` = 'Active' ,`StreetName` = 'Rivus Overlook' ,`StreetNumber` = '279' ,`StreetSuffix` = 'Drive' ,`City` = 'Willis' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3689' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 46113122 - Built by Highland Homes - Ready Now! ~ All brick, Open floor plan with 13\' ceilings and large entry. Family room with fireplace opens to island kitchen with white upper cabinets and natural look lower cabinets and hutch, with white countertops on all. Complementary tile backsplash complete with under counter lights. Large walk-in pantry, stainless appliances and Farm house apron front single basin sink. Butlers pantry included at dining area. All bedrooms have walk-in closets. Master bed expanded to include sitting area. Master bath includes free-standing tub and separate shower. Upgraded cabinets in this area. Game room adjacent to Entertainment room. Tankless water heater and smart home technology also included. Extended Covered patio. Full yard sod and sprinkler system with upgraded landscape package!' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S927110 - THE WOODLANDS HILLS 10, BLOCK 2, LOT 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11294' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Hills' ,`TaxAmount` = '' ,`TaxRate` = '3.25' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266366' WHERE `Matrix_Unique_ID` = '204995151' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T14:02:58.430' ,`MLSNumber` = '29372782' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.226611' ,`Longitude` = '-95.705888' ,`PhotoCount` = '50' ,`PostalCode` = '77354' ,`RoomCount` = '9' ,`ListPrice` = '540000.00' ,`Status` = 'Active' ,`StreetName` = 'Parkside Oaks' ,`StreetNumber` = '40023' ,`StreetSuffix` = 'Way' ,`City` = 'Magnolia' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3100' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Empire Communities-Est Completion Summer 2022. This home features 4 bds, 4 full baths, a home office, game room & 2 car garage! The open concept living, great room that is beaming with natural light & boasts 2 story ceilings! Kitchen with built in stainless steel GE appliances, ample storage & oversized kitchen island. Massive shower & soaking tub in the owner\'s retreat. Primary & secondary bedrooms on 1st floor! 2 large secondary bedrooms with there own bathroom on second floor, game room. This home is located in Magnolia in a beautiful architectural community called Audubon. This community will include future schools, churches, forested environments, creeks, walkable parks and trails. The best time to visit and make this home yours!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Block 3 Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Audubon' ,`TaxAmount` = '' ,`TaxRate` = '3.3087' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266366' WHERE `Matrix_Unique_ID` = '205034478' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T13:24:01.603' ,`MLSNumber` = '75261274' ,`ListAgentFullName` = 'Sandra Tsui' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.704495' ,`Longitude` = '-95.418003' ,`PhotoCount` = '24' ,`PostalCode` = '77030' ,`RoomCount` = '8' ,`ListPrice` = '720000.00' ,`Status` = 'Active' ,`StreetName` = 'Gramercy' ,`StreetNumber` = '2526' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2767' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful home is located on a large corner lot (9520 sqft) at Gramercy and Kirby. Minutes to medical center, rice village, and Herman Park. This timeless single story home boasts 3 large bedrooms, extremely spacious living and family rooms along with formal dining. The home boasts an outstanding open kitchen, updated granite counter tops in kitchen, dryer, dishwasher, furnaces, and refrigerator. Alon with wood flooring in family, kitchen, and breakfast.' ,`Acres` = '0.2185' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Rice/Museum District' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 18 & TR 19A BLK 27 BRAESWOOD' ,`LotDesciption` = 'Corner' ,`LotSize` = '9520' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ROBERTS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Braeswood' ,`TaxAmount` = '13450' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266366' WHERE `Matrix_Unique_ID` = '207773613' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T14:22:11.380' ,`MLSNumber` = '12884988' ,`ListAgentFullName` = 'Pamela Green' ,`ListOfficeName` = 'Coldwell Banker PropertiesUnlimited' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.155084' ,`Longitude` = '-96.390913' ,`PhotoCount` = '50' ,`PostalCode` = '77833' ,`RoomCount` = '10' ,`ListPrice` = '675000.00' ,`Status` = 'Active' ,`StreetName` = 'Lee' ,`StreetNumber` = '1606' ,`StreetSuffix` = 'Street' ,`City` = 'Brenham' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3138' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous custom home on oversized lot! Upon entry you will immediately be taken in by the cathedral wood-beamed ceilings over the dining & living rooms with fireplace. The kitchen, semi-open to the living areas, has a large breakfast room with two-way fireplace. Kitchen features an island with cooktop, sub-zero refrigerator, double oven and ice maker. A dry bar is between the kitchen and DR. The master suite shares the two-way fireplace and has separate his/hers bathrooms, vanities and closet space with a common shower between them. Upstairs, a library/gameroom features bookshelves with a library ladder, an office with built in desk, two bedrooms sharing a Hollywood bath plus another bedroom with ensuite/hall bath. Outside, meander along the stone walkways through your very own lushly landscaped park to the fish pond w/waterfall, fire pit, pergola and play area. You will not believe you are right in town and minutes away from all amenities. Meticulously maintained inside and out.' ,`Acres` = '0.466' ,`Area` = '58' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'S3502-KEYS 2ND, BLOCK M, LOT 1E' ,`LotDesciption` = 'Wooded' ,`LotSize` = '20299' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '137 - Brenham' ,`SchoolElementary` = 'BISD DRAW' ,`SchoolHigh` = 'BRENHAM HIGH SCHOOL' ,`SchoolMiddle` = 'BRENHAM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Keys 2nd' ,`TaxAmount` = '12532' ,`TaxRate` = '2.0369' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266367' WHERE `Matrix_Unique_ID` = '207952888' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T14:24:05.300' ,`MLSNumber` = '10828530' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.536128' ,`Longitude` = '-95.754992' ,`PhotoCount` = '17' ,`PostalCode` = '77469' ,`RoomCount` = '8' ,`ListPrice` = '442000.00' ,`Status` = 'Active' ,`StreetName` = 'Park Heights' ,`StreetNumber` = '919' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosenberg' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2706' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The charming Frost plan includes three bedrooms with walk-in closets, three bathrooms, and an upstairs bonus room!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1, Block 2, Section 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7651' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'ARREDONDO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Summer Park' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266367' WHERE `Matrix_Unique_ID` = '208614899' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T14:24:43.240' ,`MLSNumber` = '38120287' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.537317' ,`Longitude` = '-95.753096' ,`PhotoCount` = '16' ,`PostalCode` = '77469' ,`RoomCount` = '8' ,`ListPrice` = '443000.00' ,`Status` = 'Active' ,`StreetName` = 'Altman Pass' ,`StreetNumber` = '823' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosenberg' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2703' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The uniquely-designed Emerson floor plan provides comfort and flexibility for the entire family. On the first floor, you are greeted by a large foyer that leads to your guest bedroom and third bathroom located just beside the bedroom. Down the hall, you are led to your welcoming formal dining room with the stairway to your second floor, a walk-in utility room, and the entry to your two-car garage just across the way. Connected to your formal dining room is your spacious family room with the conveniently adjoined kitchen and breakfast area. Upgraded features include quartz kitchen countertops, tile throughout the first floor with the exception of bedrooms, only one neighbor on the left side with lake on the right, stainless steel appliances, blinds, garage door opener, full sod, sprinkler system, and more!' ,`Acres` = '0.2481' ,`Area` = '30' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SUMMER PARK SEC 3, BLOCK 2, LOT 26' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '10809' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'ARREDONDO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Summer Park Sec 3' ,`TaxAmount` = '1181' ,`TaxRate` = '2.8448' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266367' WHERE `Matrix_Unique_ID` = '208645287' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T14:24:30.107' ,`MLSNumber` = '36231778' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.537763' ,`Longitude` = '-95.755307' ,`PhotoCount` = '16' ,`PostalCode` = '77469' ,`RoomCount` = '8' ,`ListPrice` = '443000.00' ,`Status` = 'Active' ,`StreetName` = 'Summer Village' ,`StreetNumber` = '906' ,`StreetSuffix` = 'Way' ,`City` = 'Rosenberg' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2703' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The uniquely-designed Emerson floor plan provides comfort and flexibility for the entire family. On the first floor, you are greeted by a large foyer that leads to your guest bedroom and third bathroom located just beside the bedroom. Down the hall, you are led to your welcoming formal dining room with the stairway to your second floor, a walk-in utility room, and the entry to your two-car garage just across the way. Connected to your formal dining room is your spacious family room with the conveniently adjoined kitchen and breakfast area. Upgraded features include quartz kitchen countertops, tile throughout the first floor with the exception of bedrooms, only one neighbor on the left side with lake on the right, stainless steel appliances, blinds, garage door opener, full sod, sprinkler system, and more!' ,`Acres` = '0.1794' ,`Area` = '30' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SUMMER PARK SEC 3, BLOCK 1, LOT 17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7814' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'ARREDONDO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Summer Park Sec 3' ,`TaxAmount` = '1181' ,`TaxRate` = '2.8448' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266367' WHERE `Matrix_Unique_ID` = '208646058' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T14:23:15.320' ,`MLSNumber` = '81057205' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.536840' ,`Longitude` = '-95.755160' ,`PhotoCount` = '16' ,`PostalCode` = '77469' ,`RoomCount` = '7' ,`ListPrice` = '443000.00' ,`Status` = 'Active' ,`StreetName` = 'Northview' ,`StreetNumber` = '5819' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosenberg' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2703' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The uniquely-designed Emerson floor plan provides comfort and flexibility for the entire family. On the first floor, you are greeted by a large foyer that leads to your guest bedroom and third bathroom located just beside the bedroom. Down the hall, you are led to your welcoming formal dining room with the stairway to your second floor, a walk-in utility room, and the entry to your two-car garage just across the way. Connected to your formal dining room is your spacious family room with the conveniently adjoined kitchen and breakfast area. Upgraded features include quartz kitchen countertops, tile throughout the first floor with the exception of bedrooms, only one neighbor on the left side with lake on the right, stainless steel appliances, blinds, garage door opener, full sod, sprinkler system, and more!' ,`Acres` = '0.2373' ,`Area` = '30' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SUMMER PARK SEC 3, BLOCK 2, LOT 6' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '10336' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'ARREDONDO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Summer Park Sec 3' ,`TaxAmount` = '1181' ,`TaxRate` = '2.8448' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266368' WHERE `Matrix_Unique_ID` = '208649393' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T13:47:34.563' ,`MLSNumber` = '40633883' ,`ListAgentFullName` = 'Jeffrey Welch' ,`ListOfficeName` = 'Welch Realty Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.787038' ,`Longitude` = '-95.355695' ,`PhotoCount` = '25' ,`PostalCode` = '77009' ,`RoomCount` = '5' ,`ListPrice` = '337900.00' ,`Status` = 'Active' ,`StreetName` = 'Mcneil' ,`StreetNumber` = '1228' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1623' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CLOSEOUT PRICING - ONLY 3 HOMES LEFT AT THIS LOCATION!!!! Prime location minutes from downtown and the Galleria. A few blocks from the north rail line - connecting you to everything in the city including downtown, the museum district, the medical center, the theater, sports stadiums, and the University of Houston. Brand new development with modern design. You will fall in love with this 3 bedroom, 2 1/2 bath home featuring an open floor plan and beautiful kitchen. Motivated sellers! Come and see this fantastic property!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Deacon Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 1 RYON GROVE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1771' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MARTINEZ C ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Ryon Grove' ,`TaxAmount` = '' ,`TaxRate` = '2.5' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266368' WHERE `Matrix_Unique_ID` = '209119516' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T14:17:26.327' ,`MLSNumber` = '22963497' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.864700' ,`Longitude` = '-95.282900' ,`PhotoCount` = '6' ,`PostalCode` = '77016' ,`RoomCount` = '4' ,`ListPrice` = '237125.00' ,`Status` = 'Active' ,`StreetName` = 'Vinca Minor' ,`StreetNumber` = '10514' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1459' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This amazing one story home will be move-in ready upon the completion in September or October of 2022. The Ridgeland floorplan showcases 4 bedrooms 2 full bathrooms and a 2 car garage! This open concept kitchen is full of high quality cabinetry, a pantry and a large eating area that is blanketed with natural lighting illuminating from the breakfast area windows. It is completed with hard surface flooring throughout the common areas. And for family fun times, it has an amazing covered front porch and back patio that comes standard with this home.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Rausch Coleman Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '12/2/11' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHADYDALE ELEMENTARY' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wayside Village' ,`TaxAmount` = '' ,`TaxRate` = '3.13' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266368' WHERE `Matrix_Unique_ID` = '209293738' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T14:46:55.490' ,`MLSNumber` = '4642735' ,`ListAgentFullName` = 'Tamintris Robinson' ,`ListOfficeName` = 'Adams Homes Realty, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.434757' ,`Longitude` = '-95.434266' ,`PhotoCount` = '44' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '291900.00' ,`Status` = 'Active' ,`StreetName` = 'Whitney Reach' ,`StreetNumber` = '10238' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1902' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This HOME IS READY!!\r\nWe LOVE Realtors! NEW HOMES available call Tamintris for more details.\r\n \r\nRoom sizes have been estimated. Bring us your buyers! Room sizes are estimated. \r\nTaxes on CAD are currently for LOT value only! Agents, please advise your buyer once closed your buyer will have to pay. Taxes based on land and structure!!!\r\nAlvin ISD' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Adams Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SIERRA VISTA SEC 5 (A0288 HT&BRR) BLK 1 LOT 17' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'SIERRA VISTA' ,`TaxAmount` = '1683' ,`TaxRate` = '3.606' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266368' WHERE `Matrix_Unique_ID` = '209309079' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T13:23:15.270' ,`MLSNumber` = '60340874' ,`ListAgentFullName` = 'Sandra Tsui' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.009446' ,`Longitude` = '-95.438259' ,`PhotoCount` = '22' ,`PostalCode` = '77090' ,`RoomCount` = '10' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Deveron' ,`StreetNumber` = '719' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3064' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 2 stories home with 4 bedrooms and an office can be a 5th bedroom. Home is very spacious, features high ceiling, formal dining and living, study room, family room with fire place, large island kitchen with tons of storage and plenty of counter space for multiple uses. Priced to sale, great investment opportunity. Tenants occupied, sale as is.' ,`Acres` = '0.1026' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 2 ELLA CROSSING SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4471' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '470' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'BAMMEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'BAMMEL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ella Crossing' ,`TaxAmount` = '5937' ,`TaxRate` = '2.7542' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675266369' WHERE `Matrix_Unique_ID` = '209325206' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T13:41:34.213' ,`MLSNumber` = '92653434' ,`ListAgentFullName` = 'Allen Hebert' ,`ListOfficeName` = 'Register Real Estate Advisors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.171385' ,`Longitude` = '-95.157995' ,`PhotoCount` = '7' ,`PostalCode` = '77357' ,`RoomCount` = '8' ,`ListPrice` = '409990.00' ,`Status` = 'Active' ,`StreetName` = 'Mockingbird' ,`StreetNumber` = '2710' ,`StreetSuffix` = 'Lane' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2125' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UC - Located in popular Roman Forest Large 4 bedrooms or 3 bedrooms with study. 2 full Baths. Craftsman style front door.White Brick on 3 sides w/white mortar and dark brown trim on Exterior. Vinyl plank throughout main areas, halls, and second bathroom. Carpet in bedrooms and closets. -Tile in master bath floor and shower surround. Double pane Vinyl windows. Kitchen and bathrooms solid surface top (Silestone),Kitchen backsplash 3x12 tile on broken joint, Job built custom cabinets to the ceiling, SS Appliances. Gas heater, stove, Furness, fireplace & dryer. High efficiency 16 seer AC, Batt Walls R13, Slope ceiling R19, and Attic blown R38., Moen Faucets (chrome). Interior paint light grey with white trim, Baseboard 1x4 with 1x4 Casing, 8’ Interior doors with 6” base and 3 1/2 casing. . Gas Fireplace. Garage door Opener, Kitchen features Breakfast bar. Covered front porch. Enjoy the 12\'x11\' covered back patio. Front of home gutters Fantastic location,30 Year\r\nArchitectural shingles' ,`Acres` = '0.4846' ,`Area` = '40' ,`BuilderName` = 'M. Taylor Custom Hom' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S839701 - ROMAN FOREST 01, BLOCK 6, LOT 14' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '21107' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'DOGWOOD ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Roman Forest 01' ,`TaxAmount` = '614' ,`TaxRate` = '2.9064' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266369' WHERE `Matrix_Unique_ID` = '209332331' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T14:30:27.570' ,`MLSNumber` = '13438078' ,`ListAgentFullName` = 'Christina Flores' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.193232' ,`Longitude` = '-95.022283' ,`PhotoCount` = '44' ,`PostalCode` = '77327' ,`RoomCount` = '10' ,`ListPrice` = '206990.00' ,`Status` = 'Active' ,`StreetName` = 'Road 3550' ,`StreetNumber` = '4638' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1790' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous Brand new home by Cavco Homes ready for a family to make it their own. Enjoy country living on a large lot with plenty of space for outdoor entertaining. Open floor plan with 4 bedrooms and 2 full bath and garden tub with separate shower. Take advantage of the low tax rate low POA with brand new schools and a splash pad. Appliance package includes stainless steel refrigerator, stove and dishwasher. No restrictions, schedule your tour today!' ,`Acres` = '' ,`Area` = '52' ,`BuilderName` = 'Cavco Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Santa Fe, Sec 6, Block 43, Lot 3394, Acres 0.23' ,`LotDesciption` = 'Corner' ,`LotSize` = '10000' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'PINE BURR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Fe' ,`TaxAmount` = '' ,`TaxRate` = '2.15' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1675266369' WHERE `Matrix_Unique_ID` = '210427848' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T13:22:19.237' ,`MLSNumber` = '19164771' ,`ListAgentFullName` = 'Sandra Tsui' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.009507' ,`Longitude` = '-95.438139' ,`PhotoCount` = '27' ,`PostalCode` = '77090' ,`RoomCount` = '6' ,`ListPrice` = '269000.00' ,`Status` = 'Active' ,`StreetName` = 'Deveron' ,`StreetNumber` = '715' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1713' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This one story home has excellent floor plan with 3 good size bedrooms, formal dining room and family room. Ceiling fans in family and master bedrooms. Tile floor in entrance and all wet areas, carpet in all other rooms. Kitchen is spacious with tons of cabinets, plenty of counter space, breakfast area. Tenants occupied, sale as is. Refrigerator is included. Don\'t miss this great investment opportunity.' ,`Acres` = '0.0911' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 2 ELLA CROSSING SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3967' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '470' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'BAMMEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'BAMMEL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ella Xing Sec 1' ,`TaxAmount` = '4309' ,`TaxRate` = '2.7542' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266369' WHERE `Matrix_Unique_ID` = '210501983' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T13:34:12.247' ,`MLSNumber` = '37686328' ,`ListAgentFullName` = 'James Carter' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.994048' ,`Longitude` = '-95.676272' ,`PhotoCount` = '49' ,`PostalCode` = '77429' ,`RoomCount` = '13' ,`ListPrice` = '1300000.00' ,`Status` = 'Active' ,`StreetName` = 'Huffmeister' ,`StreetNumber` = '16721' ,`StreetSuffix` = 'Road' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3515' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this Family retreat THIS PROPERTY HAS SOMETHING FOR EVERY ONE GREAT CY-FAIR SCHOOLS This Home on 1.9 Acres has room for your cars, boat, motor home, and trailer NO UTILITY DISTRICT. has Aerobic sewer system, own Water well saves you money. All electric with a tax rate of 2.0 and you file homestead keeps taxes lower. Zoned Air & Heat 2 units central system a digital program Thermostat ,Front entry on left is the Study having French Doors to the right Formal dining Home is split plan , two pantries one large walk-in pantery between kitchen and Dining rm. One in the kitchen with tons of storage space . Breakfast bar and dining . Den has gas fireplace out back large covered patio, pool with water fall COVERED HOT TUB, covered walk to garage BIG Shop & Outdoor Kitchen with full bath rm Come See It ASAP THIS PR0PERTY HAS SO MUCH TO OFFER READY TO GO CAN CLOSE AND MOVE QUICKLY . SO BRING EVERYONE AND CHECK OUT YOUR NEXT HOME.' ,`Acres` = '1.9' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'TR 42 CYPRESS COUNTRY SEC 2 U/R' ,`LotDesciption` = 'Other' ,`LotSize` = '86248' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'FARNEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'GOODSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'CYPRESS COUNTRY' ,`TaxAmount` = '13938' ,`TaxRate` = '2.09' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266370' WHERE `Matrix_Unique_ID` = '210770088' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T13:09:52.080' ,`MLSNumber` = '26382296' ,`ListAgentFullName` = 'Cherry Ruffino' ,`ListOfficeName` = 'Coldwell Banker Apex, REALTORS LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.657435' ,`Longitude` = '-96.397186' ,`PhotoCount` = '25' ,`PostalCode` = '77803' ,`RoomCount` = '10' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'Beck' ,`StreetNumber` = '2713' ,`StreetSuffix` = 'Street' ,`City` = 'Bryan' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2283' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful New Builder home conveniently located 5 minutes from Downtown Bryan, 10 minutes to Blinn campus, 11 minutes to RELLIS campus, 11 minutes to Texas A&M Health Science Center, and less than 15 minutes to Texas A&M main campus! Great 2-story home with 4 bedrooms, 2.5 bathrooms, and a 2-car garage. The kitchen has a large island with an eating bar and opens to the spacious living room and dining area with a beautiful neutral color scheme and lots of natural light. Great space for spending time with family and entertaining friends! There is a home office on the main floor along with the master bedroom which was designed with efficiency in mind and has easy access from the master bath to a large walk-in closet and to the laundry room. Beautiful wood grain steps take you upstairs where you will find 3 bedrooms along with a bonus room that could be used for a second living space, reading, or game area. Call TODAY and schedule your private showing!' ,`Acres` = '0.2771' ,`Area` = '61' ,`BuilderName` = 'Historic Homes LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'FOUR POINT O SOUTH, BLOCK 1, LOT 7' ,`LotDesciption` = 'Other' ,`LotSize` = '12070' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '148 - Bryan' ,`SchoolElementary` = 'MARY BRANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRYAN HIGH SCHOOL' ,`SchoolMiddle` = 'STEPHEN F. AUSTIN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Four Point O North' ,`TaxAmount` = '496' ,`TaxRate` = '2.3493' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266370' WHERE `Matrix_Unique_ID` = '210810063' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T13:45:51.543' ,`MLSNumber` = '3983375' ,`ListAgentFullName` = 'Vincent Tramonte' ,`ListOfficeName` = 'Joe Tramonte Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.288018' ,`Longitude` = '-94.795235' ,`PhotoCount` = '44' ,`PostalCode` = '77550' ,`RoomCount` = '5' ,`ListPrice` = '949500.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue Q 1/2' ,`StreetNumber` = '2828' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3681' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location matters! 2 blocks from beach, steps from Seawall restaurants and the Pleasure Pier! Constant coastal breezes and the pleasant sounds of the Gulf, plus the meticulous upkeep of this property help this bright and airy coastal cottage keep its 5 star, Superhost rating! Main home is 2,469sf; FULLY FURNISHED; Classic, 1913 old time Island charm with modern day amenities. High ceilings, original wood floors, large windows, oversized front porch and tasteful European antiques throughout the home are notable, unique features. Kitchen includes s/s appliances, Quartz countertops, modern backsplash and plenty of pantry and storage space. Home is kept cool with 9 efficient split systems. Passive income provided by 2 back garage apartments leased by long-term tenants. Plenty of street parking, plus there is a curb cut for carport/small garage if needed. This home will accommodate large and extended families on vacation or better yet, make this your own year-round getaway retreat.' ,`Acres` = '0.1184' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOT 14 NW BLK 115 GALVESTON OUTLOTS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5160' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Craftsman' ,`Subdivision` = 'Galveston Outlots' ,`TaxAmount` = '8979' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1913' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675266370' WHERE `Matrix_Unique_ID` = '210989151' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T14:09:34.863' ,`MLSNumber` = '95677503' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.492608' ,`Longitude` = '-95.386226' ,`PhotoCount` = '19' ,`PostalCode` = '77578' ,`RoomCount` = '10' ,`ListPrice` = '719990.00' ,`Status` = 'Active' ,`StreetName` = 'Dancing Oaks' ,`StreetNumber` = '5815' ,`StreetSuffix` = 'Court' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3404' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Shea Homes Plan 6025. Est. Completion 1/2023. This inviting and spacious single story home offers 4 bedrooms, 3.5 baths, and a 3 car tandem garage. As you walk through the gorgeous rotunda in the entry, you will find hallways that lead to the secondary bedrooms. A separate hallway leads to the Study with French doors and a very spacious Media Room, perfect for movie nights at home! The Great Room awaits at the end of the hall with a 12\' ceiling and stacked slider doors that fill the space with natural light. An oversized Casual Dining Room leads out to your extended covered patio and oversized outdoor oasis with complete privacy! Back inside, the gourmet Kitchen includes cabinets galore, double ovens, a 5 burner gas cooktop, large kitchen island and a dream oversized walk-in pantry! The private primary suite is the perfect place to relax featuring a bay window and spa like bathroom with dual vanities, free-standing tub and separate shower. Come and Live the Difference in a Shea Home!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Shea Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9, Block 1, Section 10' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '14469' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '980' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'E C MASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'MANVEL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,French' ,`Subdivision` = 'Del Bello Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.638696' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266370' WHERE `Matrix_Unique_ID` = '211093321' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T13:24:53.033' ,`MLSNumber` = '64735812' ,`ListAgentFullName` = 'Barbara Trammell' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = 'Monica Foster' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.377451' ,`Longitude` = '-95.206574' ,`PhotoCount` = '36' ,`PostalCode` = '77511' ,`RoomCount` = '8' ,`ListPrice` = '425000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Cytherea' ,`StreetNumber` = '2805' ,`StreetSuffix` = 'Circle' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fabulous 3 bedroom, 2 bath home on just under 3 acres! This wonderful, warm, and inviting home is perfectly situated on a quiet cul-de-sac just minutes from shopping & dining while still living in the county. Inside the home, you will find a galley-style kitchen that features tons of storage & counter space, a living room w/additional storage & a wood-burning fireplace, and three bedrooms that are all comfortably sized with walk-in closets. Off the kitchen & dining room, there is a large flex space that works as a craft room, office, perhaps a school room, or almost anything. For the hunters, the attached garage has a 7x6 air-conditioned loading room and a separate 7x13 storage room which could be converted to an office. Outside you will find a huge metal shop! and a lovely pond! Pls note: Several years ago, the workshop was partitioned to make a temporary apartment that is not currently livable. The wall dividing the space is not load-bearing & could be removed.' ,`Acres` = '2.92' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'MUSTANG ESTATES SEC 1 (A0223 H T & B R R), BLOCK 1, LOT 10-1' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '126760' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap`