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-31T20:16:50.877' ,`MLSNumber` = '50157414' ,`ListAgentFullName` = 'Susanna Mayberry' ,`ListOfficeName` = 'RE/MAX Leading Edge' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.297825' ,`Longitude` = '-94.799303' ,`PhotoCount` = '50' ,`PostalCode` = '77550' ,`RoomCount` = '13' ,`ListPrice` = '1100000.00' ,`Status` = 'Active' ,`StreetName` = 'Broadway' ,`StreetNumber` = '2911' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4692' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the 1915 Brockman-Estrada House. Step back in time entering the grand foyer of this beautiful brick Prairie School inspired home situated on Broadway, one of Galveston Island\'s most prestigious streets. Current owner was awarded the Sally B. Wallace Preservation Award in 2020-if you have a love of these old homes, you will appreciate how well this home has been preserved and maintained to look as it did back in the day. Downstairs you will find a formal parlor and study to the east of the entry along with a full bath and utility room. On the south side of the first floor, you will find a formal dining room connected to a butler\'s pantry, kitchen with walk-in pantry and breakfast room. Don\'t forget to check out the back staircase as well! Upstairs boasts four oversized bedrooms, two of which offer private balconies; two solariums/sunrooms; and a full bath with soaking tub. Carriage house with apartment! Sellers recently installed leaf filters and electric driveway gate!' ,`Acres` = '0.236' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Reports Available,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOTS 4 & 5 BLK 149 GALVESTON' ,`LotDesciption` = 'Cleared' ,`LotSize` = '10280' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`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' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Galveston Townsite' ,`TaxAmount` = '7117' ,`TaxRate` = '2.262' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1915' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266887' WHERE `Matrix_Unique_ID` = '199190166' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T19:54:17.897' ,`MLSNumber` = '86429322' ,`ListAgentFullName` = 'Donna Cannon' ,`ListOfficeName` = 'R.E.D (Real Estate Driven)' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.361784' ,`Longitude` = '-95.797241' ,`PhotoCount` = '50' ,`PostalCode` = '77461' ,`RoomCount` = '10' ,`ListPrice` = '585000.00' ,`Status` = 'Active' ,`StreetName` = 'Morgan' ,`StreetNumber` = '13220' ,`StreetSuffix` = 'Lane' ,`City` = 'Needville' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4393' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Motivated Seller! Fabulous 2 acres of land with a beautifully modified custom home! Over 4300 square feet of country living space ready for your customization. Enormous Master suite downstairs (includes a private entrance). Also on the first floor, just off the kitchen, is an-law suite with a private full bath and jetted tub (or an office). Three bedrooms upstairs share a full bathroom. Bonus space is the enclosed Porte Cochere. Move In Ready! No HOA!' ,`Acres` = '2' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'MORGAN ACRES, LOT 3, ACRES 2.00' ,`LotDesciption` = 'Cleared' ,`LotSize` = '87120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven,Electric Oven,Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '38 - Needville' ,`SchoolElementary` = 'NEEDVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEEDVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'NEEDVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Back,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Morgan Acres' ,`TaxAmount` = '7699' ,`TaxRate` = '1.8957' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266888' WHERE `Matrix_Unique_ID` = '204345320' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T19:32:29.123' ,`MLSNumber` = '29896445' ,`ListAgentFullName` = 'Brenda Moon' ,`ListOfficeName` = 'Alliance Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.047512' ,`Longitude` = '-95.335551' ,`PhotoCount` = '42' ,`PostalCode` = '77373' ,`RoomCount` = '12' ,`ListPrice` = '1999999.00' ,`Status` = 'Active' ,`StreetName` = 'Treaschwig' ,`StreetNumber` = '6530' ,`StreetSuffix` = 'Road' ,`City` = 'Spring' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4528' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful unrestricted Ranch Style home on approximately 27.34 acres. Located in desirable Spring, Texas. Area attractions include but not limited too, scenic forested trails in Carter Park along Spring Creek great for hiking, biking and equestrian activities. Cypresswood Golf Club, Property has a 6 stall barn and tack room with a fully fenced pasture. Home features 5/6 bedrooms with built-ins and large closets. Primary suite on 1st floor. Kitchen is a cooks dream and offers great entertaining options, formal dining, Executive Study/Office to allow privacy for remote work from home. Huge bonus room upstairs that can be used for game room or whatever your heart desires. Crown molding, 6 car garage with loft, plenty of parking for entertaining, RV, ETC. Easy access to Houston IAH Airport, shopping, and dining. Property is AG EXEMPT so bring your horses. Great Income Development Opportunity. THIS PROPERTY IS A MUST SEE!!! All sizes are approximate and should be verified.' ,`Acres` = '27.34' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 11C-2 23A-1A 23A-2 & 23B-1 (HOMESITE) ABST 282 R GILES' ,`LotDesciption` = 'Cleared' ,`LotSize` = '1190930' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CHET BURCHETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Giles Robert' ,`TaxAmount` = '9226' ,`TaxRate` = '2.1367' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266888' WHERE `Matrix_Unique_ID` = '206847096' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T19:18:11.363' ,`MLSNumber` = '45226466' ,`ListAgentFullName` = 'Esmeralda Broadbent' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.664135' ,`Longitude` = '-95.482447' ,`PhotoCount` = '19' ,`PostalCode` = '77096' ,`RoomCount` = '9' ,`ListPrice` = '479000.00' ,`Status` = 'Active' ,`StreetName` = 'Briarbend' ,`StreetNumber` = '5502' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2450' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous, remodeled home is located in the Parkwest subdivision of the Westbury community. Elementary school within walking distance and literally around the corner. Home has a modern open concept living, kitchen, dining, and breakfast area. Kitchen has updated cabinets, quartz countertops, tiled backsplash, wide sink, and new appliances. The master bedroom features two walk-in closets and custom bath. The spacious backyard is perfect for entertaining and family gatherings with an extended concrete patio. Backyard is fenced and gated. Your story begins here.' ,`Acres` = '0.2562' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 182 PARKWEST SEC 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '11160' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PARKER ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkwest Sec 01' ,`TaxAmount` = '7162' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266889' WHERE `Matrix_Unique_ID` = '207791717' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T20:38:01.210' ,`MLSNumber` = '77982283' ,`ListAgentFullName` = 'Kimberley Terral' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.758314' ,`Longitude` = '-95.190415' ,`PhotoCount` = '39' ,`PostalCode` = '77364' ,`RoomCount` = '3' ,`ListPrice` = '795000.00' ,`Status` = 'Active' ,`StreetName` = 'Holly Glen' ,`StreetNumber` = '11' ,`StreetSuffix` = 'Drive' ,`City` = 'Point Blank' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2866' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful waterfront home on 2.028 acres in a small quiet neighborhood. Spacious open concept living, dining and sunroom are just off the kitchen (great for entertaining). Features include tray ceiling, fireplace, granite countertops, double ovens, large deck, sunroom, oversized garage, water softener system, plus STUNNING views of the lovely landscaped yard and beautiful lake cove. *This is a very special home that is move-in ready.' ,`Acres` = '2.028' ,`Area` = '64' ,`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` = 'HOLLY GLENN, LOT 8-9, 36-38, Community Reserve 1 ACRES 2.028' ,`LotDesciption` = 'Cul-De-Sac,Water View,Waterfront' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Holly Glenn' ,`TaxAmount` = '6817' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266890' WHERE `Matrix_Unique_ID` = '209237912' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T20:54:38.193' ,`MLSNumber` = '68029109' ,`ListAgentFullName` = 'Oscar Morales Velandia' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = 'Oscar Morales Velandia' ,`SellingOfficeName` = 'Keller Williams Metropolitan' ,`Latitude` = '30.854102' ,`Longitude` = '-95.971035' ,`PhotoCount` = '30' ,`PostalCode` = '77831' ,`RoomCount` = '3' ,`ListPrice` = '299000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Bankhead' ,`StreetNumber` = '26245' ,`StreetSuffix` = 'Drive' ,`City` = 'Bedias' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gem won\'t last long! Come and see this beautiful home sitting on a 6.00 Acre cleared property. This newly remodelled 3/2 home offers a great floor plan, Gorgeous Kitchen, laminate water proof flooring throughout the house and amazing new bathrooms. The property offers many mature trees, big fenced backyard. This unrestricted mini ranch can accommodate for a few farm animals too. Located only 10 miles from Madisonville in Madisonville ISD; approximately 30 miles from Huntsville and 45 minutes from Bryan/College Station this property offers country living, low taxes, and proximity to bigger city amenities within a reasonable distance.\r\nListed room sizes are approximate and should be verified by buyer.' ,`Acres` = '6.209' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Madisonville Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SHANNON PLACE EST BLK 3 LOT 26 6.209' ,`LotDesciption` = 'Cleared' ,`LotSize` = '270464' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '175 - Madisonville Consolidated' ,`SchoolElementary` = 'MADISONVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MADISONVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MADISONVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Right Side,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Skannon Place' ,`TaxAmount` = '1229' ,`TaxRate` = '1.7287' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266890' WHERE `Matrix_Unique_ID` = '210556133' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T20:45:16.843' ,`MLSNumber` = '92840489' ,`ListAgentFullName` = 'Delilah McKenna' ,`ListOfficeName` = 'McKenna Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.720465' ,`Longitude` = '-95.443258' ,`PhotoCount` = '24' ,`PostalCode` = '77005' ,`RoomCount` = '3' ,`ListPrice` = '850000.00' ,`Status` = 'Active' ,`StreetName` = 'Judson' ,`StreetNumber` = '4102' ,`StreetSuffix` = 'Avenue' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1870' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great contemporary home. Zoned to sought after West U Elementary. New roof, new exterior paint, updates to the kitchen. Split level floor plan with primary bedroom suite downstairs. Large open living area, formal dining area and guest bath are on the first floor. Upper level has a second living area/den, two roomy bedrooms and full bath. Tall ceilings in the living areas. Large covered patio in the back. Easy care garden. Available now. (please verify schools and room dimensions).' ,`Acres` = '0.1295' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West University/Southside Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 9 BLK 22 COLLEGE COURT PLACE' ,`LotDesciption` = 'Corner' ,`LotSize` = '5640' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WEST UNIVERSITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'College Court Place' ,`TaxAmount` = '12128' ,`TaxRate` = '2.0584' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266891' WHERE `Matrix_Unique_ID` = '211021920' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T19:07:28.240' ,`MLSNumber` = '80924885' ,`ListAgentFullName` = 'Kimberly Capps-Rumfield' ,`ListOfficeName` = 'Keller Williams Realty-FM' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '32.417900' ,`Longitude` = '-96.827082' ,`PhotoCount` = '33' ,`PostalCode` = '75165' ,`RoomCount` = '7' ,`ListPrice` = '338000.00' ,`Status` = 'Active' ,`StreetName` = 'Blue Roan' ,`StreetNumber` = '204' ,`StreetSuffix` = 'Drive' ,`City` = 'Waxahachie' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2297' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '$2000 offered by sellers to help buyers with interest rate buydown, fresh paint or whatever they desire. This great three bedroom two bath is located in a great neighborhood and is close to everything. All bedrooms are upstairs with a large open living area. Downstairs features a space for either formal dining or study with an open floor plan from the living room to the kitchen. Waxahachie is a growing community but still holding on to that small town charm.' ,`Acres` = '0.18' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 2 BLK C MUSTANG CREEK PH I 0.18 AC' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7841' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1014 - Waxahachie' ,`SchoolElementary` = 'SHACKELFORD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WAXAHACHIE HIGH SCHOOL' ,`SchoolMiddle` = 'EDDIE FINLEY SR SEVENTH GRADE CENTER' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mustang Creek Ph I' ,`TaxAmount` = '5006' ,`TaxRate` = '2.3435' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266892' WHERE `Matrix_Unique_ID` = '211370805' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T20:28:53.493' ,`MLSNumber` = '65461187' ,`ListAgentFullName` = 'Pamela Castello' ,`ListOfficeName` = 'Comiskey Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.300538' ,`Longitude` = '-94.919690' ,`PhotoCount` = '33' ,`PostalCode` = '77554' ,`RoomCount` = '3' ,`ListPrice` = '869000.00' ,`Status` = 'Active' ,`StreetName` = 'Windsong' ,`StreetNumber` = '1531' ,`StreetSuffix` = 'Way' ,`City` = 'Tiki Island' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1572' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great house with a pool come and enjoy coastal living in this beautiful home on the canal. Fish from your backyard and you have a boat house for your boat. Come to Tiki and check this one out. Check out some extra features this home offers:\r\n-Foundation is on concrete stilts\r\n-Additional concrete Boat trailer or other parking behind build line of 10x30 size\r\n-Both garage doors are oversized. One at 10x10 the other 12x10. Wider for jet ski trailer\r\n-Heated Pool,propane tank installed June 2021\r\n-10ft Ceilings throughout the home\r\n- Foam Insulation \r\n-Custom Built cabinets \r\n-boathouse 12x12 oversized deck pillars\r\n-checkout how extra stout our boat lift is. \r\n-overhead green light\r\n-Elevated foundation \r\n-Quick access to JONES lake\r\n-furnishings negotiable \r\nBuilt and lived in by one owner.' ,`Acres` = '0.124' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tiki Island' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 7 S C BUNDICK SUR LOT 61 TIKI ISLAND SEC 8' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '5401' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HAYLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tiki Island 8' ,`TaxAmount` = '11692' ,`TaxRate` = '2.4912' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266892' WHERE `Matrix_Unique_ID` = '211571988' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T20:11:28.387' ,`MLSNumber` = '70272534' ,`ListAgentFullName` = 'Christina Boston' ,`ListOfficeName` = 'Boston Real Estate Group' ,`SellingAgentFullName` = 'Nguyen Wilson' ,`SellingOfficeName` = 'Wilson Realty & Inv Grp, LLC' ,`Latitude` = '30.028938' ,`Longitude` = '-95.573338' ,`PhotoCount` = '35' ,`PostalCode` = '77379' ,`RoomCount` = '4' ,`ListPrice` = '385000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Birdsnest' ,`StreetNumber` = '9743' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2311' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Two-year-old, meticulously maintained home zoned to excellent Klein ISD Schools & located w/in the Gleannloch Farms Community with access to amenities like, pools, parks, horse stables, etc. Tucked in the back of the section on a cul de sac lot, it is quiet with very little traffic & a nice long driveway leading to your attached garage. This popular Pulte Sheldon plan is great for any stage in life with its 3 bedrooms, 2 baths, spacious study (big enough to convert to 4th bedroom), mud room area & bonus desk space just off the kitchen! This is the open plan you are looking for with the central island, open dining area & spacious living room (this is great for entertaining and day to day living). Additional upgrades incl. solid surface flooring throughout, modified 2nd bath for safety/grab bars, beautiful custom stacked stone accents in the kitchen wall & island, & an extended back patio w/ ceiling fan & screen door. Easy commute to 249, 99, & 45, from The Woodlands to Downtown Houston' ,`Acres` = '0.1945' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 1 GROVE AT GLEANNLOCH FARMS SEC 2' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '8471' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1175' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'HASSLER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'DOERRE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grove at Gleannloch Farms' ,`TaxAmount` = '8173' ,`TaxRate` = '2.7315' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266893' WHERE `Matrix_Unique_ID` = '211761770' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T20:23:19.010' ,`MLSNumber` = '89011768' ,`ListAgentFullName` = 'Jennifer Arriaga' ,`ListOfficeName` = 'Daniel Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.717179' ,`Longitude` = '-95.586916' ,`PhotoCount` = '44' ,`PostalCode` = '77082' ,`RoomCount` = '11' ,`ListPrice` = '2449000.00' ,`Status` = 'Active' ,`StreetName` = 'Portofino' ,`StreetNumber` = '11906' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '6400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One of the best golf course views situated on a cul-de-sac in Royal Oaks Country Club, this spectacular home offers 5 bedrooms, including guest quarters on the 1st floor, 5 full bathrooms & 1half bath. This custom-designed home was well thought through with the use of space & layout. Unbelievable backyard tucked away on the golf course with a beautiful pool, spa, fire pit, outdoor kitchen, multiple outdoor living spaces, green space, and a full pool bath. The mosquito system makes entertaining enjoyable year-round. Formal entry, study, dining, and living room with two-story windows offering tons of natural light. The master retreat offers a view from every angle, sitting room, and fireplace with an enormous master bathroom and closet. Entertaining at its finest with a second-floor game room, card room, balcony, media room, and last but not least the outdoor living areas and pool all overlooking the lakes of holes 15 and 16. You will not want to miss out on this view!' ,`Acres` = '0.3099' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Westchase Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 2 ROYAL OAKS COUNTRY CLUB SEC 13' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,On Golf Course,Subdivision Lot' ,`LotSize` = '13500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'OUTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'O\'DONNELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Mediterranean,Spanish' ,`Subdivision` = 'Royal Oaks Country Club Sec 13' ,`TaxAmount` = '42783' ,`TaxRate` = '2.6086' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266894' WHERE `Matrix_Unique_ID` = '212639621' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T20:58:30.627' ,`MLSNumber` = '22675475' ,`ListAgentFullName` = 'Cecilly West' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.335824' ,`Longitude` = '-95.517630' ,`PhotoCount` = '12' ,`PostalCode` = '77583' ,`RoomCount` = '6' ,`ListPrice` = '695000.00' ,`Status` = 'Active' ,`StreetName` = 'Tankersley' ,`StreetNumber` = '3903' ,`StreetSuffix` = 'Circle' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3045' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new home!! This brand-new, stunning, CUSTOM home built by JHI Homes, is nestled on a 1 acre lot with a gorgeous lake view and breath taking sunsets, and NO MUD TAX. It has 5 large bedrooms, 3.5 bathrooms AND a home office, amongst a large walk in pantry and wash room. The builders have installed a septic-drip system underground and a propane tank, gutters, and so much more. Come take a look at this gorgeous home and make it yours!!' ,`Acres` = '1' ,`Area` = '5' ,`BuilderName` = 'JHI Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Rosharon' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'SUNCREEK RANCH SEC 2 (A0125 A ROBINSON) BLK 3 LOT 20' ,`LotDesciption` = 'Subdivision Lot,Water View,Wooded' ,`LotSize` = '43560' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'FRONTIER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Suncreek Ranch Sec 1-2-3-4' ,`TaxAmount` = '1168' ,`TaxRate` = '1.986' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266894' WHERE `Matrix_Unique_ID` = '213070594' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T20:23:56.713' ,`MLSNumber` = '13261857' ,`ListAgentFullName` = 'Susy Stapp' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = 'Christy Buck' ,`SellingOfficeName` = 'Infinity Real Estate Group' ,`Latitude` = '29.540749' ,`Longitude` = '-95.045501' ,`PhotoCount` = '50' ,`PostalCode` = '77573' ,`RoomCount` = '13' ,`ListPrice` = '389900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Golden Sails' ,`StreetNumber` = '2216' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2781' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful, well-maintained 4 bedroom, 3 bath home. The cherrywood floors throughout are absolutely gorgeous and the floor to ceiling insulated windows create a stunning impression The kitchen sports beautiful white soft-close cabinets, under the cabinet lighting, a wine fridge, granite counters and a 6-burner gas cooktop. The living area has high ceilings, overlooks the kitchen, and offers a cozy fire place for the approaching cool evenings.The large primary bedroom is downstairs with huge windows, along with 2 updated baths, & a home office. The upstairs has 3 generous bedrooms & a game room. It’s an ideal place for entertaining w a peaceful backyard & a private patio behind the garage, which is the perfect place to watch Kemah fireworks! Attention to detail is obvious, & this home offers security and insulation like you rarely see with security doors, cameras, double insulation and radiant barrier. There are many upgrades so check it out yourself!' ,`Acres` = '0.1964' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 18 M MULDOON SUR LOT 30 BLK 4 HARBOUR PARK SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8556' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '606' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'FERGUSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CLEAR CREEK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harbour Park Sec 4 91' ,`TaxAmount` = '6747' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266895' WHERE `Matrix_Unique_ID` = '213425164' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T20:11:12.507' ,`MLSNumber` = '81609059' ,`ListAgentFullName` = 'Lina Liu' ,`ListOfficeName` = 'RE/MAX RESULTS' ,`SellingAgentFullName` = 'Stephanie Warren' ,`SellingOfficeName` = 'Redfin Corporation' ,`Latitude` = '29.751400' ,`Longitude` = '-95.793717' ,`PhotoCount` = '20' ,`PostalCode` = '77494' ,`RoomCount` = '4' ,`ListPrice` = '349900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Sterling Cloud' ,`StreetNumber` = '25250' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2333' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well maintained corner two story home in the Parkway Oaks. Large open Kitchen to the living room with Master bedroom down. Remodeled Master bath with walk in closet. Three bedrooms and a game room upstairs. Home has never flooded and Zoned to Best Katy ISD Schools, Come see this Wonderful and Cozy home!!' ,`Acres` = '0.1409' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PARKWAY OAKS SEC 2, BLOCK 3, LOT 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6136' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'RYLANDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'CINCO RANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkway Oaks Sec' ,`TaxAmount` = '6389' ,`TaxRate` = '2.7295' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266895' WHERE `Matrix_Unique_ID` = '213550708' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T20:17:07.960' ,`MLSNumber` = '92306922' ,`ListAgentFullName` = 'Monica Munoz' ,`ListOfficeName` = 'INNOVA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.666498' ,`Longitude` = '-95.103488' ,`PhotoCount` = '33' ,`PostalCode` = '77536' ,`RoomCount` = '13' ,`ListPrice` = '329000.00' ,`Status` = 'Active' ,`StreetName` = 'Meadow' ,`StreetNumber` = '4726' ,`StreetSuffix` = 'Drive' ,`City` = 'Deer Park' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2690' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Spacious home and ready to move in. Custom built staircase. Family room is open to kitchen and breakfast area. Arched entry ways. Large primary room with walk in closet and bathtub that is separate from shower. The house sits on a nice sized lot with no neighbors backing to property. The refrigerator, washer and dryer stay with the home! The home has energy efficient solar screens. New AC/Heating equipment installed in 2022, comes with a 10 year transferable warranty. House comes with one year of Warranty - Ultimate Plan.' ,`Acres` = '0.2261' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Deer Park' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 1 EAST MEADOW' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9849' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'COLLEGE PARK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LOMAX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'East Mdw Final' ,`TaxAmount` = '7732' ,`TaxRate` = '2.7308' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266896' WHERE `Matrix_Unique_ID` = '213587759' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T19:27:38.577' ,`MLSNumber` = '20405187' ,`ListAgentFullName` = 'Nancy Stow' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.708413' ,`Longitude` = '-95.455750' ,`PhotoCount` = '34' ,`PostalCode` = '77401' ,`RoomCount` = '12' ,`ListPrice` = '1299000.00' ,`Status` = 'Active' ,`StreetName` = 'Spruce' ,`StreetNumber` = '4601' ,`StreetSuffix` = 'Street' ,`City` = 'Bellaire' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '4751' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Updated and gorgeous brick traditional in Bellaire! Situated on a corner lot with pool, covered porch and large side yard. Light-filled with modern upgrades zoned to Horn Elementary. 5 beds, 4.2 baths including attached quarters with separate entry. The spacious quarters/5th bedroom updated in 2018 w/ quartzite and marble kitchen, built-in desk area, and full bath. High ceilings and hardwoods throughout all living areas, kitchen, bedrooms and 3rd floor playroom. Beautiful kitchen features quartzite counters, SS Whirlpool refrig and dishwasher(2020), SS Bosch double ovens and Dacor 5-burner cooktop. Family room has recent built-ins with brick surround gas fireplace. Living Room/future study has a wood-burning fireplace w/marble surround. Side fence (2020); back fence (2017). 5-ton upstairs A/C (2022) downstairs A/C (2014). New water heater (2022), Roof (2011). New and recent paint throughout home. Move-in condition! Walk to Evelyn\'s Park and Betsy\'s Cafe - close to TX Med Center!' ,`Acres` = '0.2014' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Bellaire Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 22 HARDING PLACE' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8775' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HORN ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Harding Place' ,`TaxAmount` = '19918' ,`TaxRate` = '2.2271' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266897' WHERE `Matrix_Unique_ID` = '213640877' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T20:07:44.470' ,`MLSNumber` = '46823957' ,`ListAgentFullName` = 'Susan Cline' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.768494' ,`Longitude` = '-95.767605' ,`PhotoCount` = '24' ,`PostalCode` = '77450' ,`RoomCount` = '7' ,`ListPrice` = '289000.00' ,`Status` = 'Active' ,`StreetName` = 'Cascade Creek' ,`StreetNumber` = '1027' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1808' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CARPET installed 12/12/2022. (not shown in photos) ROOF replaced 2022. 4A/C replaced 2020, for a 2-stage, 4 ton unit. You\'re going to love the fully renovated kitchen with soft close drawers, Whirlpool gas cooktop and oven, Bosch microwave, granite counter tops...a must-see! Whole house water softener, screened porch, all located walking distance from Cimarron Elementary. Call for your private appointment today!' ,`Acres` = '0.1737' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 40 CIMARRON SEC 9 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7565' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '460' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CIMARRON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'WEST MEMORIAL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Cimarron Sec 09 R/P' ,`TaxAmount` = '4384' ,`TaxRate` = '2.3833' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266897' WHERE `Matrix_Unique_ID` = '213815622' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T19:34:26.660' ,`MLSNumber` = '54408628' ,`ListAgentFullName` = 'Claudette Callebs' ,`ListOfficeName` = 'Taylor Real Estate Group, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.085803' ,`Longitude` = '-95.189078' ,`PhotoCount` = '22' ,`PostalCode` = '77365' ,`RoomCount` = '8' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Willow Park Terrace' ,`StreetNumber` = '5803' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2603' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning Village Builders \"Claremore\" floor plan in the livable forest. One of the best 1 story plans in the community. Well-appointed and very current finishes. Light and bright with dramatic 11ft ceilings. Designer touches throughout - custom blinds, lighting, counters and paint. Finishes are in line with current trends with white kitchen, light stone counters and light, neutral paint on the walls. Kitchen has upgraded SS appliances and 5 burner gas cooktop. Large island with sink, granite counters and pendant lighting. Large laundry room with storage space and room for an additional refrigerator. Covered patio in your private treelined back yard has been extended with pavers for additional outdoor entertaining space and outdoor speakers. Garage with additional storage systems, shelving, hanging and professionally finished flooring. Full sprinkler system. Wired for Christmas Lights under the eaves. Keyless front entry. So many upgrades and high end finishes!' ,`Acres` = '0.1701' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 28 BLK 2 ROYAL BROOK AT KINGWOOD SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7409' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'ELM GROVE ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Royal Brook/Kingwood Sec 1' ,`TaxAmount` = '8245' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266898' WHERE `Matrix_Unique_ID` = '214074848' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T19:24:30.963' ,`MLSNumber` = '65933121' ,`ListAgentFullName` = 'Nnenna Strother' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = 'Nnenna Strother' ,`SellingOfficeName` = 'Realty Associates' ,`Latitude` = '29.689792' ,`Longitude` = '-95.636044' ,`PhotoCount` = '9' ,`PostalCode` = '77083' ,`RoomCount` = '5' ,`ListPrice` = '259000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Beech Glen' ,`StreetNumber` = '14206' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1543' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful location close to Bayway 8 close to Sugar Land Highway 6 so many place to shop on eat very lovely location' ,`Acres` = '0.09' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 44 BLK 1 BEECHNUT MEADOWS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3920' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'HICKS ELEMENTARY SCHOOL (ALIEF)' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'ALBRIGHT MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Beechnut Meadows' ,`TaxAmount` = '4230' ,`TaxRate` = '2.5785' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675266899' WHERE `Matrix_Unique_ID` = '214184553' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T20:16:56.743' ,`MLSNumber` = '42098355' ,`ListAgentFullName` = 'Chet Polniazek' ,`ListOfficeName` = '1st Texas Realty Services' ,`SellingAgentFullName` = 'Christian Meacham' ,`SellingOfficeName` = 'Keller Williams Woodlands' ,`Latitude` = '30.145275' ,`Longitude` = '-95.564800' ,`PhotoCount` = '50' ,`PostalCode` = '77375' ,`RoomCount` = '9' ,`ListPrice` = '1395000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Curly Willow' ,`StreetNumber` = '114' ,`StreetSuffix` = 'Circle' ,`City` = 'Tomball' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5504' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Totally Remodeled (late 2020) Toll Bros home featuring 5 Large Bedrooms, 5 Ensuites, 1 Half Bath, 3 Car Garage. Remodel included New Hardwoods, Painted inside and out, Custom Built-In Cabinets in Study, Living room shelves, Mantel, Wine Room, Light Fixtures, Quartz Countertops, Custom Iron Front Door, Outdoor Kitchen, Primary Bath and all Ensuites. Kitchen features oversize Island, 6 Burner Gas Cooktop, Double Oven, Built in Refrigerator, all JennAir Appliances. Living Room features 2 Story Windows, with a Quartz Fireplace, custom Solid Wood Mantel and Custom side Shelves. 2 Bedrooms down and 3 Bedrooms upstairs all with Ensuites. Built in cabinets in Primary closets. Lots of Extra closets throughout and storage racks in Garage. Modern Style home with Luxury Finishes and Colors.' ,`Acres` = '0.3275' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 12 BLK 1 THE WOODLANDS CREEKSIDE PARK WEST SEC 15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14266' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'CREEKVIEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Woodlands Creekside Park West Se' ,`TaxAmount` = '25824' ,`TaxRate` = '2.6895' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266899' WHERE `Matrix_Unique_ID` = '214485655' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T20:06:56.940' ,`MLSNumber` = '14561022' ,`ListAgentFullName` = 'Richard Barro' ,`ListOfficeName` = 'Aron Realty' ,`SellingAgentFullName` = 'Miranda Melchor' ,`SellingOfficeName` = 'Infinity Real Estate Group' ,`Latitude` = '29.895797' ,`Longitude` = '-95.474385' ,`PhotoCount` = '21' ,`PostalCode` = '77088' ,`RoomCount` = '7' ,`ListPrice` = '203749.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Fairview Forest' ,`StreetNumber` = '5631' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1810' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come out to see these 3 beds 2 bath home located in Klein ISD. This house has a large cathedral ceiling living room with wood burning/gas fireplace. Breakfast room with side desk area. Wet bar with open counter into dining/living room. Ceiling fans. Large main bedroom with walk-in closet, and whirlpool tub. Utility room in house with washer and gas/electric dryer connections. Covered back patio. Large tree for lots of shade. Please use your imagination to make this your dream home with minor updates. Schedule a showing appointment TODAY!' ,`Acres` = '0.1584' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 6 017*I5645955-006-006-004 INWOOD NORTH SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'NITSCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'KLEIN INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Inwood North Sec 06' ,`TaxAmount` = '4527' ,`TaxRate` = '2.6485' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266900' WHERE `Matrix_Unique_ID` = '214521883' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T19:38:54.053' ,`MLSNumber` = '52232792' ,`ListAgentFullName` = 'Cheryn Reynolds' ,`ListOfficeName` = 'Ameristar, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.064117' ,`Longitude` = '-95.571750' ,`PhotoCount` = '30' ,`PostalCode` =