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-25T14:38:45.927' ,`MLSNumber` = '23234999' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = 'Brandell Flores' ,`SellingOfficeName` = 'Equity First Realty Partners, LLC' ,`Latitude` = '30.061794' ,`Longitude` = '-95.720924' ,`PhotoCount` = '19' ,`PostalCode` = '77377' ,`RoomCount` = '15' ,`ListPrice` = '631812.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Flaxen Haflinger' ,`StreetNumber` = '19114' ,`StreetSuffix` = 'Trail' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3695' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Magnificent Beazer home in the gorgeous 484-acre community of Amira features elevated amenities, including a beautiful brick front, tile flooring, energy efficient features, stone fireplace, media room, study with French doors, spa-like primary suite with dual vanities, open great room, and an extended covered patio. The exquisite kitchen is equipped with quartz countertops, mosaic backsplash, double wall oven, 36” built-in gas cooktop, stainless steel appliances, Kohler® farmhouse sink, and under-counter lighting. Walk among 100-year-old oak trees to find Amira’s world-class comforts, including a glistening infinity-edge pool, clubhouse, dog park, and full fitness center. Nestled off the Grand Parkway and Hwy 249, residents are minutes from popular restaurants, shops, and parks in central Tomball and Cypress. Students attend the top-rated Tomball ISD.' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4 Block 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Amira' ,`TaxAmount` = '' ,`TaxRate` = '3.551993' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702888' WHERE `Matrix_Unique_ID` = '206208520' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T14:19:02.170' ,`MLSNumber` = '69138435' ,`ListAgentFullName` = 'Wendy Roloff' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.176681' ,`Longitude` = '-95.895525' ,`PhotoCount` = '50' ,`PostalCode` = '77484' ,`RoomCount` = '18' ,`ListPrice` = '1500000.00' ,`Status` = 'Active' ,`StreetName` = 'Bowler' ,`StreetNumber` = '975' ,`StreetSuffix` = 'Road' ,`City` = 'Waller' ,`BathsFull` = '6' ,`BathsHalf` = '3' ,`BedsTotal` = '6' ,`SqFtTotal` = '6083' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning English influenced stone estate nestled on 28+ acres of unrestricted property: private home, weekend retreat or event venue! Unique architectural details include cinderblock walls w/ Austin stone inside & outside. Through the historic 1800’s solid wood & leaded glass front door is a breathtaking 2-story entry w/ stone walls, tin ceiling, wood tile flrs, wood stairs, wrought iron & crystal chandelier & wrought iron sconces. The “Wow factor” continues throughout the home w/ stone walls & huge wood beams in the formal living room, quiet theatre room, stunning Formal dining rm, private master bedrm, both w/ stone walls & fireplace. Kitchen w/ Thermador appliances, antique 1800’s windows, bead board ceiling. The breakfast area & den feature beautiful wood accents w/ doors to the huge pavilion w/ outdoor kitchen & carriage house. Beautiful stone, hardwood floors, 6 fireplaces, tin ceilings, wood accents throughout. Read descriptions for more information. AMAZING property!' ,`Acres` = '28.504' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '6' ,`GeoMarketArea` = 'Waller' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABS A326900 A-269 OWEN WINGFIELD TRACT 60 ACRES 15.634' ,`LotDesciption` = 'Other' ,`LotSize` = '1241634' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'FIELDS STORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'English,Traditional' ,`Subdivision` = 'Waller' ,`TaxAmount` = '16484' ,`TaxRate` = '2.0243' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663702888' WHERE `Matrix_Unique_ID` = '206923689' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T15:09:59.053' ,`MLSNumber` = '40157873' ,`ListAgentFullName` = 'Shelley Naiser' ,`ListOfficeName` = 'Shelley Naiser Properties,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.564691' ,`Longitude` = '-95.407333' ,`PhotoCount` = '47' ,`PostalCode` = '77584' ,`RoomCount` = '14' ,`ListPrice` = '595000.00' ,`Status` = 'Active' ,`StreetName` = 'Sparkling Brook' ,`StreetNumber` = '2502' ,`StreetSuffix` = 'Court' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4092' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BACK ON THE MARKET DUE TO BUYER ISSUE! Don\'t miss this hard to find large home on an oversized cul de sac lot! 5 bedrooms, 3.5 baths and a 3 car detached garage on a 1/3 acre lot!!! Home features primary bedrom downstairs with large family room, study, formal dining & kitchen. Upstairs game/living area is plumbed for kitchenett/wet bar and ready to entertain! Solar panels (2019) offset power consumption by about 75% (per owner)!!! The large backyard is pre-wired for a pool and has an exisiting covered patio. The 3 car garage is built out with insulation, sturdy storage shelves, cabinetry, sink and additional lighting and power outlets. Recent updates include: A/C 2020, New windows (2021) Dishwasher 2021, Water Heaters 2022. This home is zoned to Alvin ISD and currently attends Brothers Elementary, McNair Junior High and Shadow Creek High School.' ,`Acres` = '0.357' ,`Area` = '5' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SHADOW CREEK RANCH SF12 (PEARLAND), BLOCK 2, LOT 18' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '15551' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'BROTHERS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHADOW CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MCNAIR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadow Creek Ranch DF-12 (Pearland)' ,`TaxAmount` = '11537' ,`TaxRate` = '2.9209' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702888' WHERE `Matrix_Unique_ID` = '208406292' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T14:03:45.947' ,`MLSNumber` = '90704568' ,`ListAgentFullName` = 'Nicole Sterling' ,`ListOfficeName` = 'Mega Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.969531' ,`Longitude` = '-95.447544' ,`PhotoCount` = '31' ,`PostalCode` = '77541' ,`RoomCount` = '4' ,`ListPrice` = '349700.00' ,`Status` = 'Active' ,`StreetName` = 'F Austin' ,`StreetNumber` = '6423' ,`StreetSuffix` = '' ,`City` = 'Jones Creek' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1542' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*LOCATION LOCATION LOCATION* Welcome to 6423 Stephen F. Austin in Jones Creek, TX! This beautiful property boasts just over six acres, four car detached garage/workshop, plenty of parking, two driveways, fenced/cross fenced and so much more! Inside the home you will find two living areas, 2-3 bedrooms, one full bathroom and an open concept kitchen! In town and just off highway 36, this land and home has endless possibilities and wont last long! Call today to schedule your showing!' ,`Acres` = '6.17' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Freeport' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'HERVEY #2 (A0020 S F AUSTIN DIV 18) LOT 14E-14F-15-15B-15B1' ,`LotDesciption` = 'Wooded' ,`LotSize` = '268765' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (BRAZOSPORT)' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Hervey #2' ,`TaxAmount` = '3778' ,`TaxRate` = '2.5124' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702889' WHERE `Matrix_Unique_ID` = '209054582' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T14:31:06.533' ,`MLSNumber` = '26602494' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.507051' ,`Longitude` = '-95.004341' ,`PhotoCount` = '11' ,`PostalCode` = '77573' ,`RoomCount` = '13' ,`ListPrice` = '528869.00' ,`Status` = 'Active' ,`StreetName` = 'Finns Landing' ,`StreetNumber` = '4919' ,`StreetSuffix` = 'Street' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2811' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Caledon floor plan includes an open-concept kitchen and double-height great room with plenty of natural light, and a private owner’s retreat with a spacious walk-in closet and ensuite on the main floor. Additional 5th bedroom with a full bath downstairs that can double as a study. The second floor offers three bedrooms that conveniently surround the game room. Comes with a covered patio and a front stone accent.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 16 Block 1 Section 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6243' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '935' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'SANDRA MOSSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BAYSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Coastal Point' ,`TaxAmount` = '' ,`TaxRate` = '2.8' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702889' WHERE `Matrix_Unique_ID` = '209446874' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T14:30:40.140' ,`MLSNumber` = '6578533' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.506368' ,`Longitude` = '-95.005251' ,`PhotoCount` = '7' ,`PostalCode` = '77573' ,`RoomCount` = '11' ,`ListPrice` = '458084.00' ,`Status` = 'Active' ,`StreetName` = 'Finns Landing' ,`StreetNumber` = '4903' ,`StreetSuffix` = 'Street' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1860' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Stratford floor plan is located in a cul-de-sac lot and comes with a covered porch, four-sided brick, and the optional fourth bedroom that can double as a study. Stratford has a spacious kitchen, which includes a walk-in pantry and an oversized island with a breakfast bar. The spacious owner’s retreat includes a large walk-in closet and spa-like ensuite with double sinks.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 8 Block 1 Section 4' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6046' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '935' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'SANDRA MOSSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BAYSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Coastal Point' ,`TaxAmount` = '' ,`TaxRate` = '2.8' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702889' WHERE `Matrix_Unique_ID` = '209448711' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T14:28:27.997' ,`MLSNumber` = '42673332' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.479395' ,`Longitude` = '-95.119406' ,`PhotoCount` = '3' ,`PostalCode` = '77573' ,`RoomCount` = '10' ,`ListPrice` = '640840.00' ,`Status` = 'Active' ,`StreetName` = 'Harbor Brooks' ,`StreetNumber` = '4916' ,`StreetSuffix` = 'Lane' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2760' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lakefront Home! A spacious, open-concept floor plan featuring 4 bedrooms and 3 bathrooms. This home has a sizable kitchen with an oversized island, a walk-in pantry, a fireplace, and a great room at the heart of the home. This floorplan is accommodating with 2 bedrooms down and 2 bedrooms up. The first-floor owner\'s suite is both spacious and bright with grand bow windows, double sinks in the ensuite bathroom, and an impressive walk-in closet. There is a large upper-level flex room that can double have a game room or media area with 2 additional bedrooms that share a common bath with double sinks.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 8 Block 2 Section 4' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '7811' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '935' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BAUERSCHLAG ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'VICTORYLAKES INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Coastal Point' ,`TaxAmount` = '' ,`TaxRate` = '2.8' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702889' WHERE `Matrix_Unique_ID` = '209466312' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T14:28:53.797' ,`MLSNumber` = '89163679' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.501279' ,`Longitude` = '-95.089828' ,`PhotoCount` = '3' ,`PostalCode` = '77573' ,`RoomCount` = '11' ,`ListPrice` = '597588.00' ,`Status` = 'Active' ,`StreetName` = 'Opal Sunset' ,`StreetNumber` = '4913' ,`StreetSuffix` = 'Court' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2712' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Built by Empire Communities. Under Construction- Our Breton floor plan boasts 4 spacious bedrooms, 3 FULL bathrooms, and 2,712 Square feet of living space. This plan gives nothing but the most open concept of a floorplan, every space is oversized from the front porch and into the home and throughout. The inviting kitchen includes a chef\'s dream island and lots of beautiful cabinetry with a walk-in pantry overlooking the dining room & great room. The Owner\'s Retreat is privately tucked away with a spacious bathroom and his and her walk-in closets. The large utility room sits just off the kitchen and center of the home for everyone. Sitting on a 60’ homesite just up the road from a cul-de-sac. Located between Houston & Galveston, just minutes from Kemah, and easy access to nearby shopping, dining, water activities, & within the Village Education Center of CCISD.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 15 Block 3 Section 4' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '7324' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '935' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'RALPH PARR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'VICTORYLAKES INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Coastal Point' ,`TaxAmount` = '' ,`TaxRate` = '2.8' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702889' WHERE `Matrix_Unique_ID` = '209467728' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T14:29:51.407' ,`MLSNumber` = '32917827' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.501279' ,`Longitude` = '-95.089828' ,`PhotoCount` = '3' ,`PostalCode` = '77573' ,`RoomCount` = '11' ,`ListPrice` = '584554.00' ,`Status` = 'Active' ,`StreetName` = 'Opal Sunset' ,`StreetNumber` = '4922' ,`StreetSuffix` = 'Court' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2518' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Built by Empire Communities. Under Construction Our Popular Nokota floor plan boasts four delightful bedrooms, 3 FULL bathrooms, and 2,518 Square feet of living space. This beautiful plan boasts 3 large picture windows to give the open concept floor plan lots of natural light! The inviting kitchen includes a chef\'s dream island and lots of beautiful cabinetry with a walk-in pantry overlooking the family room. The Study sits at the front of the home with French doors. The large utility room is just off the 2-car garage. Sitting on a 60’ homesite just up the road from a cul-de-sac. Located between Houston & Galveston, just minutes from Kemah, and easy access to nearby shopping, dining, water activities, & within the Village Education Center of CCISD.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 8 Block 3 Section 4' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '7769' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '935' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'RALPH PARR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'VICTORYLAKES INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Coastal Point' ,`TaxAmount` = '' ,`TaxRate` = '2.8' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702889' WHERE `Matrix_Unique_ID` = '209470582' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T14:29:19.910' ,`MLSNumber` = '11623579' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.501279' ,`Longitude` = '-95.089828' ,`PhotoCount` = '3' ,`PostalCode` = '77573' ,`RoomCount` = '10' ,`ListPrice` = '587383.00' ,`Status` = 'Active' ,`StreetName` = 'Opal Sunset' ,`StreetNumber` = '4920' ,`StreetSuffix` = 'Court' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2438' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Built by Empire Communities. Under Construction Our Popular Bridle floorplan boasts three delightful bedrooms, 2 FULL bathrooms and 2,438 Square feet of living space. This beautiful plan boasts 3 large picture windows and an also a bay window in your dining room to give the open concept floorplan lots of natural light! The inviting kitchen includes a chef\'s dream island and lots of beautiful cabinetry with a walk- in pantry overlooking the family room. The Owner\'s Retreat privately tucked away with a bay window and calming Owners En-suite with His and Her Vanity and a Closet you could only dream of in size. The Study sits at the front of the home with French doors, yet this also has a closet so you can make it a bedroom as well! Optional 4 bedrooms! The large utility room is just off the 3-car tandem garage. This home will have a upgraded brick to the exterior and additional lighting to the exterior of the house to make it the perfect home to come home to.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9 Block 3 Section 4' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '7769' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '935' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'RALPH PARR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'VICTORYLAKES INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Coastal Point' ,`TaxAmount` = '' ,`TaxRate` = '2.8' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702889' WHERE `Matrix_Unique_ID` = '209742848' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T14:27:54.240' ,`MLSNumber` = '47949284' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.220673' ,`Longitude` = '-95.711333' ,`PhotoCount` = '3' ,`PostalCode` = '77354' ,`RoomCount` = '9' ,`ListPrice` = '587000.00' ,`Status` = 'Active' ,`StreetName` = 'Legacy Park' ,`StreetNumber` = '15375' ,`StreetSuffix` = 'Way' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3100' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to Empire\'s Eastland beauty! The foyer leads you into the open-concept living and dining room, which flows seamlessly onto the patio, making indoor and outdoor entertaining a breeze. The eat-in kitchen includes a large pantry, granite countertops, and built-in GE appliances with ample cabinetry for storage. A spacious owner\'s retreat on the main floor includes a walk-in closet, dual sinks, and a garden tub with a separate walk-in shower. The secondary bedroom on the first floor works perfectly for overnight guests. This home features painted brick on the exterior with a gray and white interior color palette. Audubon will feature an on-site elementary school, resort-style amenities, and retail space. Come out for a tour today, estimated November 2022 completion!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 22 Block 6 Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Audubon' ,`TaxAmount` = '' ,`TaxRate` = '3.3087' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702889' WHERE `Matrix_Unique_ID` = '209984367' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T15:03:36.757' ,`MLSNumber` = '8044858' ,`ListAgentFullName` = 'Matthew Krenek' ,`ListOfficeName` = 'Jane Byrd Properties INTL.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.734965' ,`Longitude` = '-96.163156' ,`PhotoCount` = '36' ,`PostalCode` = '77474' ,`RoomCount` = '11' ,`ListPrice` = '495000.00' ,`Status` = 'Active' ,`StreetName` = 'FM 3013' ,`StreetNumber` = '1619' ,`StreetSuffix` = '' ,`City` = 'Sealy' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3992' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy country living in this spacious home that sits on over an acre in Sealy, Texas. Great for entertaining, this home features living room, family room, formal dining room, and breakfast area. On the first floor, you\'ll find primary suite, two secondary bedrooms, and office/study. Upstairs includes two additional secondary bedrooms, game room and bathroom. Oversized covered patio is great for relaxing. 10\' x 15\' Storage Shed included. Located conveniently to I-10. Zoned to Sealy ISD. Room sizes to be independently verified.' ,`Acres` = '1.412' ,`Area` = '57' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SEALY SUB BLOCK 19 LOT 4' ,`LotDesciption` = 'Corner' ,`LotSize` = '61507' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '109 - Sealy' ,`SchoolElementary` = 'SELMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEALY HIGH SCHOOL' ,`SchoolMiddle` = 'SEALY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sealy Sub' ,`TaxAmount` = '6752' ,`TaxRate` = '1.8832' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702890' WHERE `Matrix_Unique_ID` = '210035256' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T14:50:51.413' ,`MLSNumber` = '37885482' ,`ListAgentFullName` = 'Mel Reyna' ,`ListOfficeName` = 'The Reyna Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.807366' ,`Longitude` = '-95.494101' ,`PhotoCount` = '50' ,`PostalCode` = '77055' ,`RoomCount` = '7' ,`ListPrice` = '979000.00' ,`Status` = 'Active' ,`StreetName` = 'Restridge' ,`StreetNumber` = '1949' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This NEW CONSTRUCTION Built by Quintessa Homes is located in the bustling subdivision of Ridgecrest in Spring Branch and offers a RARE 3-Car Garage, 1st Floor Study/Guest Suite, 4/5 bedrooms, 4.5 Baths, Seasonal storage closet & Covered Patio. Exterior features include vertical lap siding w/ Metal roof accents, Designer Coach Lights at Garage & Custom Metal/Glass Door at Front Entry. Interior features include Oak Wood floors throughout, soaring 20 ft ceilings & Home Audio/Security system prewire. Chef\'s Kitchen offers a Large island w/ Quartz countertops, Designer selected hardware & fixtures and High End stainless steel appliances. Primary Suite features large windows, Dual vanities, Soaking Tub & separate walk-in shower w/ bench and a Large Custom Designed Walk-in Closet. Additional features include Amazon Closet at Front Porch, 16 SEER AC System & Sprinkler System (Front Yard Only). EV/Tesla Charging Ready Home! Schedule your showing TODAY!' ,`Acres` = '0.1835' ,`Area` = '24' ,`BuilderName` = 'Quintessa Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 76 BLK 5 RIDGECREST SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7995' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'RIDGECREST ELEMENTARY SCHOOL (SPRING BRANCH)' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Right Side,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ridgecrest Sec 01' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702890' WHERE `Matrix_Unique_ID` = '210421103' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T14:26:41.250' ,`MLSNumber` = '92580351' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.224349' ,`Longitude` = '-95.711510' ,`PhotoCount` = '6' ,`PostalCode` = '77354' ,`RoomCount` = '9' ,`ListPrice` = '685000.00' ,`Status` = 'Active' ,`StreetName` = 'Legacy Park' ,`StreetNumber` = '15410' ,`StreetSuffix` = 'Way' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '3518' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Step inside Empire\'s luxurious Harris layout to find your study with french doors and a private guest bedroom near a full bathroom off the foyer beaming with high ceilings. The mudroom, utility room, and powder bath are conveniently located right off of the garage entrance. Wow, your guests with your wine bar, open entertaining space, and oversized covered patio. The owner\'s retreat features gorgeous bay windows offering tons of natural light and provides a peaceful sitting area. The second floor features a media room, game room, and two spacious secondary bedrooms with a jack-and-jill bathroom. Upgrades include quartz countertops, luxury vinyl plank wood flooring in main areas, GE stainless steel built-in appliances, trendy tile patterns, white brick and bronze window frames. Located on a cul-de-sac street in the new master-planned community of Audubon Park with easy access to 249, shopping, dining, & schools, this Empire home is the perfect spot to call home.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 14 Section 4' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7684' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Audubon' ,`TaxAmount` = '' ,`TaxRate` = '3.3' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702890' WHERE `Matrix_Unique_ID` = '210673599' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T14:20:34.253' ,`MLSNumber` = '3001938' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.220673' ,`Longitude` = '-95.711333' ,`PhotoCount` = '45' ,`PostalCode` = '77354' ,`RoomCount` = '10' ,`ListPrice` = '644000.00' ,`Status` = 'Active' ,`StreetName` = 'Legacy Park' ,`StreetNumber` = '15414' ,`StreetSuffix` = 'Way' ,`City` = 'Magnolia' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3100' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to Empire\'s stunning Shire layout. Enjoy open concept living with a great room that is beaming with natural light & boasts 2 story ceilings! Kitchen features built in stainless steel GE appliances, ample storage & oversized kitchen island. Massive shower & soaking tub in the owner\'s retreat. Primary & secondary bedrooms on 1st floor along with home office. 2 large secondary bedrooms on second floor with one being an en-suite located near gameroom. Exterior is inspired by a modern design, with stucco and white brick. Interior features include wood flooring, quartz countertops and trendy tile patterns. Located on an oversized homesite on a cul-de-sac in the new master planned community of Audubon Park with easy access to 249, shopping, dining, & schools, this Empire home is the perfect spot to call home.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 13 Block 4 Section 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8113' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Audubon' ,`TaxAmount` = '' ,`TaxRate` = '3.3087' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702890' WHERE `Matrix_Unique_ID` = '210674953' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T14:56:36.303' ,`MLSNumber` = '46576803' ,`ListAgentFullName` = 'Ryan Hartsell' ,`ListOfficeName` = 'Ryan Hartsell' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.523542' ,`Longitude` = '-95.020028' ,`PhotoCount` = '17' ,`PostalCode` = '77565' ,`RoomCount` = '3' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Kemah' ,`StreetNumber` = '2301' ,`StreetSuffix` = 'Drive' ,`City` = 'Kemah' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2758' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COMMERCIAL BUILDING:\r\n\r\n2,758 SF, 2-Sty Converted to Office; \r\n1980 YOC/Remodeled 2016; \r\nA/C and Roof Replaced in 2020; \r\nHardi-plank Siding/Concrete Slab; \r\n\r\nLAND:\r\n\r\n1.0012 AC or 43,612 SF; \r\n262 FF on N/L of S Kemah Drive; \r\nZoned General Use Commercial; \r\nCity of Kemah Utilities; \r\nOutside 100-Year Flood Plain; \r\n1/4 Mile North of Hwy 96/League City\r\nParkway; \r\nAdjacent to Kemah Crossing Mixed Use\r\nDevelopment' ,`Acres` = '1' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 18 M MULDOON SUR PT OF LOT 6 (6-3) BLK 7 JARBOE ADDN UN' ,`LotDesciption` = 'Cleared' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BAYSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style,Split Level' ,`Subdivision` = 'Jarboe' ,`TaxAmount` = '4601' ,`TaxRate` = '1.7835' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702890' WHERE `Matrix_Unique_ID` = '210675430' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T14:58:23.783' ,`MLSNumber` = '64377120' ,`ListAgentFullName` = 'Charlie Zaid' ,`ListOfficeName` = 'Century Properties Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.346518' ,`Longitude` = '-95.005886' ,`PhotoCount` = '7' ,`PostalCode` = '77563' ,`RoomCount` = '5' ,`ListPrice` = '153000.00' ,`Status` = 'Active' ,`StreetName` = 'Prino' ,`StreetNumber` = '6701' ,`StreetSuffix` = 'Road' ,`City` = 'Hitchcock' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '910' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Newly Remodeled 3 Bedroom - 2 Bath. Granite countertops in Kitchen. New Cabinets. Beautiful wood look porcelain tile throughout and carpet in the bedrooms. New built-in microwave, dishwasher and gas stove.' ,`Acres` = '0.168' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hitchcock' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 140 M KNOWLTON SUR N 1/2 OF LOT 11 (11-1) ROBERTS SUB' ,`LotDesciption` = 'Corner' ,`LotSize` = '7319' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '26 - Hitchcock' ,`SchoolElementary` = 'HITCHCOCK PRIMARY/STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HITCHCOCK HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (HITCHCOCK)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Roberts' ,`TaxAmount` = '1752' ,`TaxRate` = '2.2942' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702890' WHERE `Matrix_Unique_ID` = '210732647' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T14:29:22.610' ,`MLSNumber` = '80972117' ,`ListAgentFullName` = 'Jane NgaDung Nguyen' ,`ListOfficeName` = 'Alpha, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.708034' ,`Longitude` = '-95.583005' ,`PhotoCount` = '14' ,`PostalCode` = '77072' ,`RoomCount` = '6' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Belle Park' ,`StreetNumber` = '4406' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2267' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Easy access to Beechnut & Beltway 8. Low HOA, Low Tax Rate. May need some TLC. \"AS IS\" Property. Seller will make NO REPAIRS.' ,`Acres` = '0.2537' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Electric,Window Unit' ,`HOAMandatory` = '1' ,`Legal` = 'LT 42 & TR 41B BLK 3 N 17 FT LT 41 BRAYS FOREST SEC 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '11050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '144' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'CHANCELLOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'ALIEF MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Brays Forest Sec 01' ,`TaxAmount` = '4868' ,`TaxRate` = '2.4411' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702890' WHERE `Matrix_Unique_ID` = '210827884' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T15:06:23.627' ,`MLSNumber` = '10365019' ,`ListAgentFullName` = 'Marlene Baltazar' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.617506' ,`Longitude` = '-95.596467' ,`PhotoCount` = '48' ,`PostalCode` = '77478' ,`RoomCount` = '6' ,`ListPrice` = '951000.00' ,`Status` = 'Active' ,`StreetName` = 'Sugar Creek' ,`StreetNumber` = '611' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Sugar Land' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5596' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.3375' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sugar Land East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SUGAR CREEK SEC 4, BLOCK 9, LOT 55' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '14700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '644' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'DULLES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Sugar Creek' ,`TaxAmount` = '10180' ,`TaxRate` = '2.0094' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702891' WHERE `Matrix_Unique_ID` = '210920978' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T14:16:15.723' ,`MLSNumber` = '85492166' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Newmark Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.930665' ,`Longitude` = '-95.742211' ,`PhotoCount` = '22' ,`PostalCode` = '77433' ,`RoomCount` = '13' ,`ListPrice` = '1695492.00' ,`Status` = 'Active' ,`StreetName` = 'Park Poetry Court' ,`StreetNumber` = '15714' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4778' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 2 story home on a huge lot. 5 spacious bedrooms,5.5 baths and an 4 car split garage. High ceilings and a courtyard with double sliding glass doors are a few highlights of this fabulous home. Open concept from a 2 story family room to a gourmet kitchen, breakfast room and large windows with a view of a fabulous back yard. Winding staircase leading up to a loft area, game room, and a cozy media with our theatre room option. Also up you will find\r\n3 large bedrooms with private en-suit bathrooms. Huge main suit with a luxurious walk in closet including a full closet system. Large bay windows adds to the allure if this room. Second room down with a perfect location for a mother in law or guest suit. Oversized covered patio ready to entertain guests or family for gilling or chilling.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Fedrick Harris' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '480228' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '20856' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1997' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MCGOWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Bridgeland, Sheldon Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.626985' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702891' WHERE `Matrix_Unique_ID` = '210957098' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T14:15:37.830' ,`MLSNumber` = '18746526' ,`ListAgentFullName` = 'Barbara Kearns' ,`ListOfficeName` = 'Coldwell Banker Southern Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.874790' ,`Longitude` = '-94.130290' ,`PhotoCount` = '45' ,`PostalCode` = '77705' ,`RoomCount` = '10' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Grace Circle N' ,`StreetNumber` = '15365' ,`StreetSuffix` = '' ,`City` = 'Beaumont' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3412' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'STUNNING waterfront home located in The Cove at Taylor Landing subdivision. Elegant & graceful throughout with a settling like no other on a large lot. If you love to entertain, this home is for you! 4 bedrooms, 3 car garage, game room with a wet bar, 2 dining areas, utility room & an office nook with a built-in desk. You are welcomed in by the entry room with soaring ceilings & beautiful Travertine flooring. Living room has a woodburning fireplace & opens up into the gorgeous formal dining room. The fabulous kitchen has granite countertops, island work center, breakfast bar, gorgeous wood-look tile, & stunning cabinetry. The primary suite is spacious & leads into the spa-like bathroom with double sinks, garden tub, separate shower & MASSIVE walk-in closet! The 2 bedrooms upstairs are both equipped with their own vanity. This neighborhood also as a fishing dock, a private concrete boat launch & so much more! HAMSHIRE-FANNETT SCHOOL DISTRICT. *SELLER STATES THAT THIS HOME NEVER FLOODED*' ,`Acres` = '' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LAKE ESTATES SEC 1 LOT 10' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '110 - Hamshire-Fannett' ,`SchoolElementary` = 'HAMSHIRE-FANNETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HAMSHIRE-FANNETT HIGH SCHOOL' ,`SchoolMiddle` = 'HAMSHIRE-FANNETT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Cove at Taylor Landing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702891' WHERE `Matrix_Unique_ID` = '210984756' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T14:47:51.737' ,`MLSNumber` = '3983375' ,`ListAgentFullName` = 'Vincent Tramonte' ,`ListOfficeName` = 'Joe Tramonte Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.288018' ,`Longitude` = '-94.795235' ,`PhotoCount` = '44' ,`PostalCode` = '77550' ,`RoomCount` = '5' ,`ListPrice` = '949500.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue Q 1/2' ,`StreetNumber` = '2828' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3681' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location matters! 2 blocks from beach, steps from Seawall restaurants and the Pleasure Pier! Constant coastal breezes and the pleasant sounds of the Gulf, plus the meticulous upkeep of this property help this bright and airy coastal cottage keep its 5 star, Superhost rating! Main home is 2,469sf; FULLY FURNISHED; Classic, 1913 old time Island charm with modern day amenities. High ceilings, original wood floors, large windows, oversized front porch and tasteful European antiques throughout the home are notable, unique features. Kitchen includes s/s appliances, Quartz countertops, modern backsplash and plenty of pantry and storage space. Home is kept cool with 9 efficient split systems. Passive income provided by 2 back garage apartments leased by long-term tenants. Plenty of street parking, plus there is a curb cut for carport/small garage if needed. This home will accommodate large and extended families on vacation or better yet, make this your own year-round getaway retreat.' ,`Acres` = '0.1184' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOT 14 NW BLK 115 GALVESTON OUTLOTS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5160' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Craftsman' ,`Subdivision` = 'Galveston Outlots' ,`TaxAmount` = '8979' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1913' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663702891' WHERE `Matrix_Unique_ID` = '210989151' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T15:01:49.323' ,`MLSNumber` = '18243843' ,`ListAgentFullName` = 'Monica Callis' ,`ListOfficeName` = 'Callis & Co Realty,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.439623' ,`Longitude` = '-95.442356' ,`PhotoCount` = '42' ,`PostalCode` = '77583' ,`RoomCount` = '3' ,`ListPrice` = '254990.00' ,`Status` = 'Active' ,`StreetName` = 'Onyx Trail' ,`StreetNumber` = '9918' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1466' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come home to this beautiful home in a gated community and 24-hour guard. This three-bedroom home has an open floor plan with natural light flowing to the kitchen, beautiful granite countertops, a gas stove, and a breakfast bar. The primary suite has a walk-in closet and a private bathroom with dual vanity. This split plan has two additional bedrooms and another full bathroom. Kick back and relax on your covered patio for a cool breeze in the evening after work. Enjoy the community amenities, including a playground, swimming pool, and clubhouse. This home is just what you\'ve been searching for!' ,`Acres` = '0.1358' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'STERLING LAKES AT IOWA COLONY SEC 2 (A0289 HT&B) BLK 2 LOT 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '5915' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '860' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'SANCHEZ ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Split Level,Traditional' ,`Subdivision` = 'Sterling Lakes At Iowa Colony' ,`TaxAmount` = '5982' ,`TaxRate` = '3.4099' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702891' WHERE `Matrix_Unique_ID` = '211030711' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T14:50:11.977' ,`MLSNumber` = '6473836' ,`ListAgentFullName` = 'Joshua Hill' ,`ListOfficeName` = 'Compass RE Texas, LLCHeights' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.799798' ,`Longitude` = '-95.418839' ,`PhotoCount` = '19' ,`PostalCode` = '77008' ,`RoomCount` = '7' ,`ListPrice` = '635000.00' ,`Status` = 'Active' ,`StreetName` = '16th' ,`StreetNumber` = '1136' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2442' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'STUNNING NEW CONSTRUCTION! 16th Street Manor will offer a coveted modern lifestyle. This is one of five unique homes built in the community. This home features 3 stories of modern indoor living and a 4th story rooftop deck, an entertainer\'s dream! The 2nd story offers a spacious open floorplan with a chef\'s dream kitchen including state of the art appliances and large dining and living rooms. 4 large bedrooms with en-suite bathroom and walk-in closets. Primary suite features a spa like wet room with oversized shower and freestanding bathtub. Buyers will have the opportunity to select interior finishes in the building process, if under contract before builder\'s selections. Courtyards will be turfed and future private pool installation will be possible in each turfed area. Call today!' ,`Acres` = '0.057' ,`Area` = '9' ,`BuilderName` = 'Claypoole Group' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 1 WEST 16TH STREET MANORS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2464' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '4' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'West 16th Street Manors' ,`TaxAmount` = '2956' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702892' WHERE `Matrix_Unique_ID` = '211465554' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T15:41:59.903' ,`MLSNumber` = '18308828' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.727478' ,`Longitude` = '-95.930457' ,`PhotoCount` = '20' ,`PostalCode` = '77423' ,`RoomCount` = '14' ,`ListPrice` = '454265.00' ,`Status` = 'Active' ,`StreetName` = 'Dew Crest' ,`StreetNumber` = '32427' ,`StreetSuffix` = 'Street' ,`City` = 'Fulshear' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2785' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This house is under construction. This gorgeous Lake Ridge Builders home in Vanbrooke truly has it all! Nestled on a spacious lot, this 4-sided brick home boasts a premium elevation, no back neighbors, open ceilings, tile flooring, wrought iron spindles, faux wood blinds, a cast stone fireplace, study with French doors, and covered patio. Dream up new recipes in the kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, and 42” upper cabinets. Relax in the spa-like primary suite, featuring dual vanities, a 42” tub, and a separate shower. Community comforts include a playground, splash pad, pavilion with a fire pit, and a swimming pool with a lounge. Located between I-10 and the Grand Parkway, residents can find shops and restaurants at the nearby Katy Mills Mall and LaCenterra at Cinco Ranch. Zoned to Lamar Consolidated ISD. This home is exactly what you’ve been searching for – call today!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 7 Block 1' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single 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` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Vanbrooke' ,`TaxAmount` = '' ,`TaxRate` = '3.29' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702892' WHERE `Matrix_Unique_ID` = '211586407' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T15:52:06.430' ,`MLSNumber` = '33221838' ,`ListAgentFullName` = 'Dan VanDeventer' ,`ListOfficeName` = 'VanDeventer Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.449627' ,`Longitude` = '-94.668991' ,`PhotoCount` = '47' ,`PostalCode` = '77650' ,`RoomCount` = '5' ,`ListPrice` = '479500.00' ,`Status` = 'Active' ,`StreetName` = 'Helen Dowdy' ,`StreetNumber` = '1118' ,`StreetSuffix` = '' ,`City` = 'Crystal Beach' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1223' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in the Blue Water Subdivision on the bayside, this Canal front home is a perfect place for your weekend retreat or permanent residence. A two (could be three) bedroom 1 + full bath home is ready for you to bring your boat and golf cart to start enjoying being a local. Lots of covered and open decks to chill outside. This home fronts 100\' of canal frontage that has a covered boat lift you can lower your own boat in the water and access the bay and Gulf from in no time. The boat house currently holds a 22\' boat and there is plenty of space to increase the length of it if so desired. The entire bulkhead was completely rebuilt approx. 4 years ago and is in excellent condition. Also there is a 12\'x16\' storage building for all your gear, ice chest, crawfish cookers, lawn mower, etc... Beautiful large front and back yard with Saint Augustine grass to walk bare footed in and a double wide long concrete driveway for plenty of parking. Don\'t wait! Call to see this house!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 179 J SHAW SUR LOTS 232 & 233 BLUE WATER ADDN 4' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '10000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Blue Water 4' ,`TaxAmount` = '3523' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702892' WHERE `Matrix_Unique_ID` = '211614009' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T15:42:42.287' ,`MLSNumber` = '50641048' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.727380' ,`Longitude` = '-95.930614' ,`PhotoCount` = '15' ,`PostalCode` = '77423' ,`RoomCount` = '16' ,`ListPrice` = '430500.00' ,`Status` = 'Active' ,`StreetName` = 'Dew Crest' ,`StreetNumber` = '32435' ,`StreetSuffix` = 'Street' ,`City` = 'Fulshear' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2836' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**home is under construction.** Create unforgettable moments in this lovely Lake Ridge Builders home in Vanbrooke. Nestled on a spacious lot, this 4-sided brick home boasts no back neighbors, open ceilings, tile floorings, wrought iron spindles, a media room, and a covered patio. Prepare incredible feasts in the kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, and 42” upper cabinets. Unwind in the tranquil primary suite, featuring dual vanities, a 42” tub, and a separate shower. Community comforts include a playground, splash pad, pavilion with a fire pit, and a swimming pool with a lounge. Located between I-10 and the Grand Parkway, residents can find nearby shops and restaurants at the Katy Mills Mall and LaCenterra at Cinco Ranch. Zoned to Lamar Consolidated ISD. This home is exactly what you’ve been searching for – call today!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single 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` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Vanbrooke' ,`TaxAmount` = '' ,`TaxRate` = '3.29' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702892' WHERE `Matrix_Unique_ID` = '211625874' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T14:42:37.517' ,`MLSNumber` = '80181124' ,`ListAgentFullName` = 'Abimbade Jones' ,`ListOfficeName` = 'All About Texas Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.012086' ,`Longitude` = '-95.489088' ,`PhotoCount` = '37' ,`PostalCode` = '77068' ,`RoomCount` = '9' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Banty Falls' ,`StreetNumber` = '15703' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3185' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This one is a find! Corner lot, Cul-de-sac, Luxury CertainTeed roof with a lifetime transferable warranty. Never flooded and not in flood plain. No pipe burst during freeze. Highly desirable section of Olde Oaks. 5mins walk to Northgate Country Club and Golf Course. Beautiful high ceilings with lots of windows! Unique contemporary floor plan. Wet bar. Walk-in closet in all bedrooms. Faux wood blinds throughout. Large backyard with storage house. Inground sprinkler system. Three car garage! Don\'t wait. Submit an offer now!' ,`Acres` = '0.2229' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 15 OLDE OAKS SEC 1' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '9711' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PAT REYNOLDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Photos/No Videos,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Olde Oaks Sec 01' ,`TaxAmount` = '5526' ,`TaxRate` = '2.3342' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702892' WHERE `Matrix_Unique_ID` = '211642481' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T15:09:22.630' ,`MLSNumber` = '45120771' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '32.517961' ,`Longitude` = '-94.603380' ,`PhotoCount` = '11' ,`PostalCode` = '75650' ,`RoomCount` = '3' ,`ListPrice` = '86999.00' ,`Status` = 'Active' ,`StreetName` = 'Edgemere' ,`StreetNumber` = '447' ,`StreetSuffix` = 'Avenue' ,`City` = 'Hallsville' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'In the peaceful outskirts of Hallsville, TX is a great investment opportunity. T Short commute to Hallsville High School and Hallsville North Elementary School while also having easy access to HWY 80. Give us a call today for more information! As Is' ,`Acres` = '0.624' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ACRES: 0.624, LOT: 10-11, BLK: 4, SUBD: EASTWOOD PARK, HSE' ,`LotDesciption` = 'Cleared' ,`LotSize` = '27181' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '574 - Hallsville' ,`SchoolElementary` = 'HALLSVILLE EAST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HALLSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'HALLSVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Eastwood Park' ,`TaxAmount` = '226' ,`TaxRate` = '1.657' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702892' WHERE `Matrix_Unique_ID` = '211703659' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T14:57:46.890' ,`MLSNumber` = '9122187' ,`ListAgentFullName` = 'Denise Hernandez' ,`ListOfficeName` = 'CB&A, Realtors- Southeast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.780134' ,`Longitude` = '-95.168689' ,`PhotoCount` = '10' ,`PostalCode` = '77015' ,`RoomCount` = '6' ,`ListPrice` = '195500.00' ,`Status` = 'Active' ,`StreetName` = 'Waxahachie' ,`StreetNumber` = '14327' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1445' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Updated Starter house in Clover Leaf ready for you to call HOME! This house features 3 bedrooms, 1 bath has laminate flooring throughout. Upon entry is what could be a mud room that leads to the family room that is opened up to the kitchen area. The kitchen has updated cabinets, gas range, refrigerator stays, breakfast bar. The bedrooms are tucked at the back of the home and are large in size. Call today for an appointment!' ,`Acres` = '0.1263' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 11 BLK 73 CLOVER LEAF' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'CLOVERLEAF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH SHORE SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'NORTH SHORE MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Clover Leaf' ,`TaxAmount` = '2191' ,`TaxRate` = '2.5853' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702892' WHERE `Matrix_Unique_ID` = '211710596' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T15:00:58.000' ,`MLSNumber` = '71334101' ,`ListAgentFullName` = 'Dayna Simmons' ,`ListOfficeName` = 'Dayna Simmons Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.081740' ,`Longitude` = '-94.142700' ,`PhotoCount` = '27' ,`PostalCode` = '77707' ,`RoomCount` = '9' ,`ListPrice` = '219900.00' ,`Status` = 'Active' ,`StreetName` = 'Holland Dr' ,`StreetNumber` = '3880' ,`StreetSuffix` = '' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1897' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come take a peek at this charming 3 bedroom home located in the West End of Beaumont that sits on approximately .25 acres. You will be captivated by the beauty this home has to offer upon pulling in the driveway! The landscaping, stunning carport, and adorable exterior make this home picture perfect. Cook dinner for friends in the beautifully updated kitchen with stainless appliances. Retreat to the sunroom after a long day and read a book while watching the sunset. The backyard is absolutely perfect for entertaining! Give us a call today to schedule a showing!' ,`Acres` = '0.25' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'RUSSELL PLACE L2 SW14FT L3 B 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11250' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'CALDWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WEST BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'ODOM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Russell Place 1' ,`TaxAmount` = '2522' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702893' WHERE `Matrix_Unique_ID` = '211783961' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T14:49:22.700' ,`MLSNumber` = '30164610' ,`ListAgentFullName` = 'Connie Moreno' ,`ListOfficeName` = 'Houston Preferred Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.016083' ,`Longitude` = '-95.171724' ,`PhotoCount` = '17' ,`PostalCode` = '77346' ,`RoomCount` = '8' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Amber Ash' ,`StreetNumber` = '6811' ,`StreetSuffix` = 'Court' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2272' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ONE STORY LENNAR, , SAN BENITO PLAN WITH A GREAT OPEN CONCEPT FLOORPLAN ON A CUL-DE-SAC STREET \r\nBOTH BATHROOMS HAVE TILE FLOOR AND WOODFLOORS IN ALL BEDROOMS DINING AND LIVINGROOM.. 10 FT HIGH CEILINGS AND FORMAL DININGROOM AND SPACIOUS LIVINGROOM WITH FIREPLACE AND A WALL OF WINDOWS THAT OVERLOOKS THE BEAUTIFUL BACKYARD, GREAT KITCHEN WITH LARGE ISLAND , PLENTY OF CABINETS AND A PANTRY AND REFRIGERATOR.\r\nENJOY COVERED PATIO AND A GREAT LOOKING BACKYARD WITH SPRINKLER SYSTEM.\r\nATTIC STORAGE IN HOUSE AND GARAGE FOR YOUR SEASON DECORATIONS.THIS BEATIFULL HOME IS HIGH AND DRY WALK TO SHOPPING AND RESTAURANTS NEARBY.' ,`Acres` = '0.1851' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 1 KINGS RIVER VILLAGE SEC 8' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '8063' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GREENTREE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Kings River Village Sec 08' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702893' WHERE `Matrix_Unique_ID` = '211788070' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T14:23:09.610' ,`MLSNumber` = '54762688' ,`ListAgentFullName` = 'Ozzie Ramirez' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.630069' ,`Longitude` = '-95.444783' ,`PhotoCount` = '13' ,`PostalCode` = '77045' ,`RoomCount` = '5' ,`ListPrice` = '230000.00' ,`Status` = 'Active' ,`StreetName` = 'Jorns' ,`StreetNumber` = '4414' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1340' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Three-bedroom brick home with spacious double wide driveway and carport! Walk into the large living area and notice the tile throughout the home except bedrooms. Spacious dining area with French doors that lead to the patio area and into the large backyard! Kitchen is roomy as well and features lots of cabinet storage space! Cozy carpeted primary room has large windows that provide plenty of natural light! Make your appointment to see this house today!' ,`Acres` = '0.1569' ,`Area` = '18' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 25 BLK 10 PAMELA HEIGHTS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6834' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HOBBY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pamela Heights 2' ,`TaxAmount` = '3342' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702893' WHERE `Matrix_Unique_ID` = '211788251' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T14:34:42.620' ,`MLSNumber` = '96547274' ,`ListAgentFullName` = 'David Tyer' ,`ListOfficeName` = 'Tyer Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.323806' ,`Longitude` = '-95.450549' ,`PhotoCount` = '38' ,`PostalCode` = '75835' ,`RoomCount` = '4' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Gordon' ,`StreetNumber` = '505' ,`StreetSuffix` = 'Drive' ,`City` = 'Crockett' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1821' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A must See!!!!! This is a 4 bedroom 2 bath home within walking distance from downtown Crockett. You will find 1,821 square feet of living space with central air and heat, along with a tankless hot water heater. This home offers a circle drive with a two-car carport with a bonus storage area. Inside you will find beautiful wood tile flooring in the living room, kitchen, dining, guest bath and front bedroom. The separate dining room offers a beautiful view of the front yard and a sliding glass door onto the front porch. All the bedrooms are a great size with one being recently added but just needs the finishing touches of flooring and paint. This is a beautiful home call us to see it today!' ,`Acres` = '0.375' ,`Area` = '41' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crockett Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PINECREST LOT NE PT OF 18-A BLK A' ,`LotDesciption` = 'Cleared' ,`LotSize` = '16335' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '57 - Crockett' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (CROCKETT)' ,`SchoolHigh` = 'CROCKETT HIGH SCHOOL (CROCKETT)' ,`SchoolMiddle` = 'CROCKETT JUNIOR HIGH SCHOOL (CROCKETT)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'N/A' ,`TaxAmount` = '3136' ,`TaxRate` = '2.3627' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1942' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702893' WHERE `Matrix_Unique_ID` = '211804279' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T14:15:40.017' ,`MLSNumber` = '44581346' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.597719' ,`Longitude` = '-95.805671' ,`PhotoCount` = '23' ,`PostalCode` = '77471' ,`RoomCount` = '15' ,`ListPrice` = '530685.00' ,`Status` = 'Active' ,`StreetName` = 'Mason' ,`StreetNumber` = '6019' ,`StreetSuffix` = 'Way' ,`City` = 'Rosenberg' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '3219' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning two-story Leo home design features 6 bedrooms, 4 baths and 2 car attached garage. Open dining room off hall. Beautiful maple cabinets, quartz countertops and farmhouse sink in gourmet kitchen. Two bedrooms, including owner\'s suite, located downstairs. Huge walk-in closet, double sinks, separate tub and shower in owner\'s bath. Upstairs, you\'ll find a loft space and 4 secondary bedrooms. Covered patio in backyard, perfect for entertaining. \r\nEnjoy the convenience of the community\'s Recreation Center, Lakes and Parks. Kingdom Heights in Rosenberg is conveniently located between Sugar Land and Katy/Fulshear with easy access to the major Highway 99 (Grand Pkwy). Offered by: K. Hovnanian of Houston II, L.L.C' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'K. Hovnanian Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '10/4/1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '665' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kingdom Heights' ,`TaxAmount` = '' ,`TaxRate` = '2.7948' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702893' WHERE `Matrix_Unique_ID` = '211819392' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T15:35:06.687' ,`MLSNumber` = '90728598' ,`ListAgentFullName` = 'Jena Valley' ,`ListOfficeName` = 'Tramco Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.636886' ,`Longitude` = '-95.466972' ,`PhotoCount` = '17' ,`PostalCode` = '77085' ,`RoomCount` = '3' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Violet Path' ,`StreetNumber` = '5530' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1945' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Two story home in great location with large fenced in backyard! Hard floors throughout whole home! Open concept living/kitchen area. Fridge, microwave, and range all updated to stainless units. Utility room in house. Fridge, washer, and dryer included. Schedule your showing today!' ,`Acres` = '' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 3 POST OAK PLACE SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '285' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HINES-CALDWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'POST OAK PLACE' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702893' WHERE `Matrix_Unique_ID` = '211824413' --> Updated record success