Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T16:24:30.650' ,`MLSNumber` = '46742646' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.376539' ,`Longitude` = '-95.649430' ,`PhotoCount` = '7' ,`PostalCode` = '77356' ,`RoomCount` = '4' ,`ListPrice` = '297890.00' ,`Status` = 'Active' ,`StreetName` = 'Meadow Point' ,`StreetNumber` = '18548' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '3' ,`SqFtTotal` = '1609' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready June 2022! Tucked at the rear of the home, the Cascade’s private primary suite boasts his-and-hers sinks and a large walk-in closet for ample storage. In the kitchen, a large island and spacious pantry maximize convenience. Located in Conroe off SH-105, Pine Lake Cove is just minutes from Lake Conroe with future access to a residents-only boat ramp. The community is zoned in the sought-after Montgomery ISD and is near parks and entertainment. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving you thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0166 Plan 330B' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Pine Lake Cove' ,`TaxAmount` = '' ,`TaxRate` = '3.08' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696726' WHERE `Matrix_Unique_ID` = '202930778' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T16:17:44.020' ,`MLSNumber` = '46486933' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.377705' ,`Longitude` = '-95.649940' ,`PhotoCount` = '7' ,`PostalCode` = '77356' ,`RoomCount` = '4' ,`ListPrice` = '331315.00' ,`Status` = 'Active' ,`StreetName` = 'Sunrise Maple' ,`StreetNumber` = '18496' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1986' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready August 2022! Turn the kids loose in the Olympic’s second-story loft space while hosting downstairs in the open concept living area. The private main level primary suite features dual sinks and walk-in closet for ample storage. Located in Conroe off SH-105, Pine Lake Cove is just minutes from Lake Conroe and future access to a residents-only boat ramp. The community is zoned in the sought-after Montgomery ISD and is near parks and entertainment. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric,Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0145 Plan 380B' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Pine Lake Cove' ,`TaxAmount` = '' ,`TaxRate` = '3.08' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696726' WHERE `Matrix_Unique_ID` = '204108828' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T16:44:04.127' ,`MLSNumber` = '19649632' ,`ListAgentFullName` = 'Ricardo Rodriguez' ,`ListOfficeName` = 'THE BROKER Real Estate Firm' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.683474' ,`Longitude` = '-95.431400' ,`PhotoCount` = '21' ,`PostalCode` = '77340' ,`RoomCount` = '1' ,`ListPrice` = '159900.00' ,`Status` = 'Active' ,`StreetName` = 'Main' ,`StreetNumber` = '152' ,`StreetSuffix` = 'Street' ,`City` = 'Huntsville' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Adorable Country Cottage!! This 1/1 Tiny home sits on 2.2 acres of partially wooded land. Lots of room to entertain or just enjoy the quiet country serenity. A short drive to Sam Houston State University and all the amenities that Huntsville has to offer.' ,`Acres` = '2.1466' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Wall Heater' ,`HOAMandatory` = '0' ,`Legal` = 'WATSON LAKE - SEC 2, BLOCK 4, LOT 24 & 25' ,`LotDesciption` = 'Wooded' ,`LotSize` = '46751' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'ESTELLA STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Back,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Watson Lake - Sec 2' ,`TaxAmount` = '263' ,`TaxRate` = '1.7534' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663696726' WHERE `Matrix_Unique_ID` = '207594995' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T17:00:23.637' ,`MLSNumber` = '47975138' ,`ListAgentFullName` = 'Terri Pirdy' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.761054' ,`Longitude` = '-95.815496' ,`PhotoCount` = '19' ,`PostalCode` = '77494' ,`RoomCount` = '10' ,`ListPrice` = '434999.00' ,`Status` = 'Active' ,`StreetName` = 'Emporia Chase' ,`StreetNumber` = '25019' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3280' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come on home to this beautiful David Weekley Gem located in Mills Pointe Subdivision. This is one of the largest floor plans in the neighborhood, it features 4 bedrooms 3 1/2 bathrooms. Huge primary bedroom to relax in at the end of the day, separate shower and soaking tub, large walk-in closet. You can work from the comfort of your own home with this private study. Large family room that opens to the breakfast and kitchen area. There is no carpeting only engineered wood floors and slate through out. Zoned for Katy ISD' ,`Acres` = '0.1361' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MILLS POINTE SEC 1, BLOCK 1, LOT 59' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5929' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '525' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WOODCREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMPKINS HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mills Pointe Sec 1' ,`TaxAmount` = '7023' ,`TaxRate` = '2.4143' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696726' WHERE `Matrix_Unique_ID` = '207795708' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T17:07:10.783' ,`MLSNumber` = '98253092' ,`ListAgentFullName` = 'Shelly Kane' ,`ListOfficeName` = 'Martindale Real EstateInvestments' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.901210' ,`Longitude` = '-94.406586' ,`PhotoCount` = '20' ,`PostalCode` = '75938' ,`RoomCount` = '5' ,`ListPrice` = '138000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 3190' ,`StreetNumber` = '1000' ,`StreetSuffix` = '' ,`City` = 'Colmesneil' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2016' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cozy waterfront home located on Lake Amanda in Colmesneil Texas. This 4 bedroom 2 bath home features a woodburning fireplace, central air and heat and an indoor utility room. The property features a small workshop/storage building, detached carport and fenced yard. This wonderful property is located approximately 20 minutes from Lake Sam Rayburn and 2 hours from Houston. Call today to schedule a showing of this property!' ,`Acres` = '0.4496' ,`Area` = '48' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tyler County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S3250 LAKE AMANDA (A9), BLK NW, LOT 2, ACRES .4496+/-' ,`LotDesciption` = 'Cleared,Waterfront' ,`LotSize` = '19585' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '427 - Colmesneil' ,`SchoolElementary` = 'COLMESNEIL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLMESNEIL HIGH SCHOOL' ,`SchoolMiddle` = 'COLMESNEIL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Amanda' ,`TaxAmount` = '5559' ,`TaxRate` = '2.8783' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696726' WHERE `Matrix_Unique_ID` = '208438914' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T16:53:51.357' ,`MLSNumber` = '69413839' ,`ListAgentFullName` = 'Imeldia Adams' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.534367' ,`Longitude` = '-95.107372' ,`PhotoCount` = '37' ,`PostalCode` = '77598' ,`RoomCount` = '7' ,`ListPrice` = '449000.00' ,`Status` = 'Active' ,`StreetName` = 'Water' ,`StreetNumber` = '529' ,`StreetSuffix` = 'Street' ,`City` = 'Webster' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2855' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderfully Located Home in Webster. Easy access to almost any location from Galveston to Downtown Houston. Very close to NASA and easy commute to UTMB Galveston. Beautiful 2-story Newmark Madeline plan. 4 spacious Bedrooms, Study with Door, Game Room, & Large Screened-In Covered Back Patio. Back Patio Plumbed for Gas Grill. Elegant designer touches throughout the home include Granite & Silestone counter tops, 20x20 Tiles, Hardwood flooring in Formal Dining and Study, Tall Cabinets with Large Crown Molding, and Tuscan style Cast Stone Fireplace Mantle. Private Master Suite features His and Hers Walk In Closets, a Whirlpool Tub w/ Separate Shower that both have gorgeous glass and stone tile accents. Full Privacy Fenced Backyard and Iron-type Fenced Front Yard. Extended Rain Guttering and French Drain. Gas & Electric. Primary Bedroom Carpet Update 8/8/22. Sprinkler System. Gorgeous Park, Walking Trails and Dog Park. This is a Beautiful House and Neighborhood in a Super Location!' ,`Acres` = '0.1488' ,`Area` = '7' ,`BuilderName` = 'Newmark' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 1 EDGEWATER SEC 3 AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6480' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'MCWHIRTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CLEAR CREEK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Edgewater Sec 3' ,`TaxAmount` = '10961' ,`TaxRate` = '3.2394' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663696727' WHERE `Matrix_Unique_ID` = '209878542' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T17:24:07.127' ,`MLSNumber` = '95286412' ,`ListAgentFullName` = 'Tracie Dillon' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.974568' ,`Longitude` = '-95.465039' ,`PhotoCount` = '27' ,`PostalCode` = '77014' ,`RoomCount` = '6' ,`ListPrice` = '279000.00' ,`Status` = 'Active' ,`StreetName` = 'Silverglen Run' ,`StreetNumber` = '13222' ,`StreetSuffix` = 'Trail' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1834' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous Home that you will never want to leave. Soaring ceilings, soothing palette, open floor plan, gorgeous wood-like flooring, upgraded lighting, window blinds, & lots of natural light throughout. Stunning open concept kitchen featuring a large center island with bar seating, granite counters, breakfast bar, Black appliances, under-mount sink & plenty of wood cabinets. Bedrooms are generously sized and the primary bedroom includes a bay window, upscale primary bath w/ his and her sinks, separate spa tub, and shower. Plush carpet in all bedrooms, ample closets, interior laundry room, & wall space for your art or family photos. Ring doorbell and alarm system installed for added security. Lush green backyard landscape with fire pit. Lots of room for pets, play, entertaining, and more. This gem won\'t last long! See it and make it yours! MOTIVATED SELLER!' ,`Acres` = '0.1606' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 2 SILVERGLEN NORTH SEC 15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6997' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '530' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'DELORAS E THOMPSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'STELLE CLAUGHTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Silverglen #rth Sec 15' ,`TaxAmount` = '5622' ,`TaxRate` = '2.8867' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696727' WHERE `Matrix_Unique_ID` = '210202696' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T17:17:02.943' ,`MLSNumber` = '45542692' ,`ListAgentFullName` = 'Vinod Ramani' ,`ListOfficeName` = 'Urban Living' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.732643' ,`Longitude` = '-95.368155' ,`PhotoCount` = '14' ,`PostalCode` = '77004' ,`RoomCount` = '11' ,`ListPrice` = '474990.00' ,`Status` = 'Active' ,`StreetName` = 'Berry' ,`StreetNumber` = '2217' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2097' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Sunshine Bastrop by Lexen Homes located in University Area! This development features 3 single family homes with a charming Modern farmhouse design. Each bedroom features a private en-suite bath and oversized closet space. Your open concept living space on the second floor is complete with an half bath, desk niche, and a covered balcony with storage. Conveniently located in Central Houston with easy access to Medical Center, Downtown, and Houston\'s favorite parks such as Discovery Green, Emancipation Park, and Hermann Park.' ,`Acres` = '' ,`Area` = '4' ,`BuilderName` = 'Lexen Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 1 SUNSHINE BASTROP' ,`LotDesciption` = 'Other' ,`LotSize` = '1550' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Temporarily No Showings' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'EMANCIPATION PARK AREA TOWNHOUSES' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696727' WHERE `Matrix_Unique_ID` = '210296318' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T17:16:07.940' ,`MLSNumber` = '35312587' ,`ListAgentFullName` = 'Vinod Ramani' ,`ListOfficeName` = 'Urban Living' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.732522' ,`Longitude` = '-95.367980' ,`PhotoCount` = '13' ,`PostalCode` = '77004' ,`RoomCount` = '11' ,`ListPrice` = '479990.00' ,`Status` = 'Active' ,`StreetName` = 'Bastrop' ,`StreetNumber` = '3520' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2097' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Sunshine Bastrop by Lexen Homes located in University Area! This development features 3 single family homes with a charming Modern farmhouse design. Each bedroom features a private en-suite bath and oversized closet space. Your open concept living space on the second floor is complete with an half bath, desk niche, and a covered balcony with storage. Conveniently located in Central Houston with easy access to Medical Center, Downtown, and Houston\'s favorite parks such as Discovery Green, Emancipation Park, and Hermann Park.' ,`Acres` = '' ,`Area` = '4' ,`BuilderName` = 'Lexen Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 SUNSHINE BASTROP' ,`LotDesciption` = 'Corner' ,`LotSize` = '1900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Temporarily No Showings' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'EMANCIPATION PARK AREA TOWNHOUSES' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696727' WHERE `Matrix_Unique_ID` = '210302623' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T17:17:46.373' ,`MLSNumber` = '74329977' ,`ListAgentFullName` = 'Vinod Ramani' ,`ListOfficeName` = 'Urban Living' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.732593' ,`Longitude` = '-95.368084' ,`PhotoCount` = '14' ,`PostalCode` = '77004' ,`RoomCount` = '11' ,`ListPrice` = '474990.00' ,`Status` = 'Active' ,`StreetName` = 'Berry' ,`StreetNumber` = '2219' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2097' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Sunshine Bastrop by Lexen Homes located in University Area! This development features 3 single family homes with a charming Modern farmhouse design. Each bedroom features a private en-suite bath and oversized closet space. Your open concept living space on the second floor is complete with an half bath, desk niche, and a covered balcony with storage. Conveniently located in Central Houston with easy access to Medical Center, Downtown, and Houston\'s favorite parks such as Discovery Green, Emancipation Park, and Hermann Park.' ,`Acres` = '' ,`Area` = '4' ,`BuilderName` = 'Lexen Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 SUNSHINE BASTROP' ,`LotDesciption` = 'Other' ,`LotSize` = '1550' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Temporarily No Showings' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'EMANCIPATION PARK AREA TOWNHOUSES' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696727' WHERE `Matrix_Unique_ID` = '210303320' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T16:59:15.280' ,`MLSNumber` = '34571490' ,`ListAgentFullName` = 'Merwin Weenig' ,`ListOfficeName` = 'AVOREC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.324058' ,`Longitude` = '-95.054446' ,`PhotoCount` = '34' ,`PostalCode` = '77327' ,`RoomCount` = '10' ,`ListPrice` = '799900.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 3180' ,`StreetNumber` = '121' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2896' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a very beautiful home located just east of Cleveland Texas on 3 acres. Home has been very well taken care of and offers a great setting for family fun and country living. There is a stand-alone mother-in-law suite that is completely self-sufficient, a large in-ground pool, a large shop with two roll-up doors and a hoist, 400 ft deep well. The kitchen is open to the breakfast area, all with veiws of pool and property. The primary bedroom is located on the first floor and the second and third are up sharing a full bath. Lots of wood features create a very warm and comforting feel throughout the home, truly would be and make a Great Home. Must see !!' ,`Acres` = '3' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'FOSTER PLACE, LOT 16, ACRES 3.0' ,`LotDesciption` = 'Cleared' ,`LotSize` = '130680' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'EASTSIDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Georgian' ,`Subdivision` = 'Foster Place' ,`TaxAmount` = '4935' ,`TaxRate` = '1.8013' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696727' WHERE `Matrix_Unique_ID` = '210720767' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T16:06:16.970' ,`MLSNumber` = '26026410' ,`ListAgentFullName` = 'Max Yeh' ,`ListOfficeName` = 'Intex Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.729972' ,`Longitude` = '-95.549712' ,`PhotoCount` = '37' ,`PostalCode` = '77042' ,`RoomCount` = '9' ,`ListPrice` = '359500.00' ,`Status` = 'Active' ,`StreetName` = 'Holly Crossing' ,`StreetNumber` = '3218' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2376' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Available today! 2 Story; 3 bed; 2.5 bath with game room, 1st Floor: All wood floors, living w/fireplace & built-ins, half bath, breakfast bar w/arch window, kitchen w/major appliances, dining area. 2nd Floor: utility room, Game Room as the split floor plan. Two guest bedrooms on one side w/guest bath w/tub-shower. The opposite side of Game Room; master bed w/closet & bath w/walk-in closet, double vanity sink, toilet room, separate shower w/garden tub Jacuzzi. Alarm & Sprinkler system. Double vehicle garage with opener. Last home on the cul-de-sac. Gated Community. All Offer considered! CALL NOW TO VIEW!' ,`Acres` = '0.0685' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Westchase Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 40 BLK 1 WESTCHASE TRAILS' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '2983' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'SNEED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'O\'DONNELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Westchase Trls' ,`TaxAmount` = '7929' ,`TaxRate` = '2.5311' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696727' WHERE `Matrix_Unique_ID` = '210810780' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T16:49:03.433' ,`MLSNumber` = '74397956' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.468840' ,`Longitude` = '-95.469094' ,`PhotoCount` = '34' ,`PostalCode` = '77583' ,`RoomCount` = '6' ,`ListPrice` = '293990.00' ,`Status` = 'Active' ,`StreetName` = 'Golden Rubia' ,`StreetNumber` = '7726' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1263' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DR Horton, America\'s #1 Builder since 2002! This NEW CONSTRUCTION Ashburn Plan with Elevation N, their NEWEST Modern design offers 3 spacious bedrooms and 2 bathrooms, covered patio and 2-car garage! This open concept home has a stunning kitchen which includes quartz countertops, 42\" cabinets, stainless steel appliances and a large breakfast bar. As you walk into the primary bathroom, you will see dual sinks, separate shower, garden tub (on select inventory) and a large walk-in closet! (All information provided by builder). Located in Rosharon\'s newest DR Horton Community known as Caldwell Ranch this gorgeous development will feature a relaxing pool, Tot Lot, Covered Pavilion with Picnic Tables, Shallow Splash area for the Kiddos, Water Slides and Soccer Fields.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'D.R. Horton, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Caldwell Ranch Lot 2 Block 1 Section 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Caldwell Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.29' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696728' WHERE `Matrix_Unique_ID` = '210820656' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T17:48:30.690' ,`MLSNumber` = '14953693' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = 'Julia Johnson' ,`SellingOfficeName` = 'Fathom Realty' ,`Latitude` = '29.624543' ,`Longitude` = '-95.378762' ,`PhotoCount` = '36' ,`PostalCode` = '77047' ,`RoomCount` = '5' ,`ListPrice` = '326120.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Barnsbury' ,`StreetNumber` = '12806' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1617' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'D.R. Horton, America\'s #1 Builder since 2002! This NEW CONSTRUCTION Paula Plan with Elevation M, their NEWEST Modern design offers 3 spacious bedrooms and 2 bathrooms, covered patio and 2-car garage! This open concept home has a stunning kitchen which includes quartz countertops, 42\" cabinets, large breakfast bar and stainless steel appliances including gas range, canopy vent hood and dishwasher. As you walk into the Primary bathroom, you will see dual sinks, Shower AND separate Tub, and a large walk-in closet! Water resistant vinyl flooring, 2\" blinds and a tankless water heater and Washer/Dryer are all included! You won\'t have to worry about yard maintenance at City Gate, the front yard irrigation is included with the landscape package and HOA maintains the front yard PLUS included is REAR Sod! (All information provided by builder). Located in Houston’s newest D.R. Horton Community known as City Gate, this gorgeous development features walking trails, tot lot and community park!' ,`Acres` = '' ,`Area` = '3' ,`BuilderName` = 'D.R. Horton, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 1 CITY GATE SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LAW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'City Gate' ,`TaxAmount` = '' ,`TaxRate` = '3.12' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696728' WHERE `Matrix_Unique_ID` = '211086356' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T17:57:40.073' ,`MLSNumber` = '60892745' ,`ListAgentFullName` = 'Grecia Berrios' ,`ListOfficeName` = 'Mark Dimas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.654226' ,`Longitude` = '-95.212103' ,`PhotoCount` = '50' ,`PostalCode` = '77587' ,`RoomCount` = '5' ,`ListPrice` = '254999.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue M' ,`StreetNumber` = '1410' ,`StreetSuffix` = '' ,`City` = 'South Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1599' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come and visit this 1 story, 3 bed, 2 bath home.NEW PAINT. Located in South Houston with easy access to the Gulf Freeway. The home has an extensive driveway and very spacious front and back yards for gatherings. Spacious bedrooms with natural lighting. Move in ready. Zoned to Pasadena ISD. Schedule your appointment before it’s gone!! Room measurements are approximate.' ,`Acres` = '0.2583' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'South Houston' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'W 75 FT OF LT 1 BLK 191 SOUTH HOUSTON' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'PEARL HALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SOUTH HOUSTON HIGH SCHOOL' ,`SchoolMiddle` = 'MILLER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'South Houston' ,`TaxAmount` = '4868' ,`TaxRate` = '2.8255' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696728' WHERE `Matrix_Unique_ID` = '211180039' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T16:10:24.190' ,`MLSNumber` = '94981046' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.138690' ,`Longitude` = '-94.880225' ,`PhotoCount` = '23' ,`PostalCode` = '77535' ,`RoomCount` = '11' ,`ListPrice` = '390990.00' ,`Status` = 'Active' ,`StreetName` = 'Scarlet' ,`StreetNumber` = '134' ,`StreetSuffix` = 'Drive' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2667' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOW TAXES!!! 24 HOUR/7 DAYS A WEEK MANNED GUARD GATE!!!! NO FENCES HERE!!!!! Welcome home to your beautiful 2 Story, The Ascot Floor Plan with 4 bedrooms and 2.5 bathrooms with attached 3 CAR GARAGE. Additional features include a formal living room, a formal dining room, a kitchen adjoined to the breakfast nook which looks out onto the spacious family room, an oversized primary suite with a large walk-in closet in the Owner’s Retreat, an upstairs game room, and a convenient upstairs utility room. COVERED PATIO! COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Programmable Thermostat, PEX Hot & Cold Water Lines, Radiant Barrier, Aerobic Septic System, Community Well, and Vinyl Double Pane Low E Windows that open to the inside of the home for Cleaning. Do not wait! Call now for your private tour.' ,`Acres` = '' ,`Area` = '52' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'NA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (DAYTON)' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Encino Estates' ,`TaxAmount` = '' ,`TaxRate` = '1.7512' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696728' WHERE `Matrix_Unique_ID` = '211273558' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T16:20:05.397' ,`MLSNumber` = '95398155' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.726388' ,`Longitude` = '-95.936342' ,`PhotoCount` = '7' ,`PostalCode` = '77423' ,`RoomCount` = '10' ,`ListPrice` = '419771.00' ,`Status` = 'Active' ,`StreetName` = 'Wyatt James' ,`StreetNumber` = '5315' ,`StreetSuffix` = 'Lane' ,`City` = 'Fulshear' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2541' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to the beautiful 2 Story, The Donnington floor Plan with 4 Bedrooms, 2 1/2 Baths, with attached 2 Car Garage. This floor plan boasts a Spacious OPEN CONCEPT FLOOR PLAN with the Family Room, Kitchen and Dining Room, Study/Flex Space, and a Master Bedroom downstairs. Upstairs you will find a Game Room, 3 Bedrooms with another full bath. Tile and Carpet throughout. Do not miss the COVERED PATIO with fenced backyard. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Thermostat, Pex Hot & Cold Water Lines, Radiant Barrier, Rheem® Whole House Tankless Gas Water Heater, and Vinyl Double Pane Low E Windows that open to the inside of the home for cleaning. A scenic overlook greets visitors as soon as they drive in, revealing a lakeside view that gives way to an open-air pavilion and amenity center. Amenities include RESORT-STYLE SWIMMING POOL! SPLASHPAD! CHILDREN’S PLAYGROUND! Convenient to I-10, TX Hwy 359, and Westpark Tollway. Lamar CISD!' ,`Acres` = '0.1241' ,`Area` = '30' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'VANBROOKE SEC 2, BLOCK 3, LOT 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5404' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Vanbrooke' ,`TaxAmount` = '1705' ,`TaxRate` = '3.2948' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696728' WHERE `Matrix_Unique_ID` = '211274385' --> Updated record success