Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)<br>Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)<br>Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)<br>Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)<br>Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)<br>Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)<br>Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)<br>Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)<br>Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)<br>Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)<br>Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)<br>Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)<br>Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)<br>Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)<br>Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)<br>Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)<br>Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)<br>Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)<br>Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)<br>Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)<br>Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)<br>Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)<br>Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)<br>Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)<br>Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)<br>Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)<br>Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)<br>Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)<br>Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)<br>Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)<br>Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)<br>Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)<br>Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)<br>Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)<br>Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)<br>Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)<br>Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)<br>Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)<br>Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)<br>Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)<br>Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)<br>Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)<br>Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)<br>Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)<br>Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)<br>Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)<br>Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)<br>Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)<br>Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)<br>Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)<br>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)<br>Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)<br>Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)<br>Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)<br>Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)<br>Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)<br>Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)<br>Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)<br>Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)<br>Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)<br>Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)<br>Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)<br>Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)<br>Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)<br>Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)<br>Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)<br>Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)<br>Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-12T11:13:51.277' ,`MLSNumber` = '59867843' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS                       ' ,`Latitude` = '29.818641' ,`Longitude` = '-94.854717' ,`PhotoCount` = '27' ,`PostalCode` = '77523' ,`RoomCount` = '10' ,`ListPrice` = '315950.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Baywatch' ,`StreetNumber` = '8430' ,`StreetSuffix` = 'Circle' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1767' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ready to move-in! This one-story Coral brick home with stone accents features 3 bedrooms, 2 baths and a two-car garage. Convenient home office tucked off hall. Lovely kitchen overlooks great room and dining area. Beautiful maple cabinets, quartz countertops with low bar top, tile backsplash and walk-in pantry add to the kitchen\'s ambiance. Two walk-in closets in owner\'s suite. Double sinks and shower in the owner\'s spa bath. Covered patio in backyard, perfect for entertaining.\r\nStudents are zoned to Barbers Hill ISD and low taxes make Legends Bay a desirable community to live in. Come on out! We would love to see you! Offered by: K Hovnanian of Houston II, L.L.C.' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'K. Hovnanian Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = '43/1/7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5750' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Legends Bay' ,`TaxAmount` = '' ,`TaxRate` = '1.69399' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090237' WHERE `Matrix_Unique_ID` = '212787619'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-12T11:03:48.477' ,`MLSNumber` = '81675732' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'RE/MAX Legends' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.130891' ,`Longitude` = '-95.597612' ,`PhotoCount` = '34' ,`PostalCode` = '77375' ,`RoomCount` = '8' ,`ListPrice` = '385000.00' ,`Status` = 'Active' ,`StreetName` = 'Morgan' ,`StreetNumber` = '25402' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2410' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOVE-IN READY! FANTASTIC 1 STORY! EXPANSIVE .95 ACRE (per HCAD) CUL-DE-SAC LOT WITH POOL! Loaded with Updates & Upgrades! Beautiful Double Door Foyer! GIGANTIC 40 x 19 Family Room - Wood-Look Tile Flooring, Majestic Fireplace, & Dual Sets of French Doors Leading to Backyard & Pool! Chef\'s Dream Kitchen: Granite Counters, Double Ovens, Stainless Microwave, & Updated Cabinetry! Big Walk-In Pantry! Spacious Dining Area - Wet Bar with Glass-Front Cabinetry! King-Sized Master Suite - Dramatic Tray Ceiling! Updated Bath with Dual Sinks, Jetted Tub/Shower, & Walk-In Closet! Big Secondary Bedrooms - Both with Walk-In Closets! Lovely Updated Guest Bath - Wall of Built-In Cabinetry, Dual Sinks, & Framed Mirrors! Oversized 13 x 10 Utility Room! Detached Garage! Super Private Retreat-Style Backyard: Heated Pool with Extensive Decking, Outdoor Shower, Mature Landscaping, & Storage Building! Recent Roof, Paint, Fence, Pool Pump,++! Easy Access to The Woodlands + Tomball! Super Low Tax Rate! WOW!' ,`Acres` = '0.95' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 15 BLK 2 NORTH WOODS ESTATES' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Wooded' ,`LotSize` = '41382' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TOMBALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Northwood Estates' ,`TaxAmount` = '3457' ,`TaxRate` = '2.0872' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090238' WHERE `Matrix_Unique_ID` = '212824271'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-12T11:03:24.097' ,`MLSNumber` = '36198642' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'RE/MAX Legends' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.073820' ,`Longitude` = '-95.270546' ,`PhotoCount` = '23' ,`PostalCode` = '77365' ,`RoomCount` = '7' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Northpark Spruce' ,`StreetNumber` = '25610' ,`StreetSuffix` = 'Drive' ,`City` = 'Porter' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2017' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ABSOLUTELY PRISTINE - YOU\'LL THINK YOU\'RE TOURING A MODEL! Gorgeous 2020 Built 1 Story 4 Bedroom - Premium Corner Lot! Craftsman-Style Exterior with Front Porch & Stone Accents! Desirable Interior Layout - Split Plan PLUS 3 Full Baths! Gourmet Island Kitchen: Granite Counters, Stainless Appliances, 42\" White Shaker-Style Cabinetry Galore, & Subway Tile Backsplash! Opens to Light & Bright Dining Area & Spacious Family Room! Privately Located Master Suite - Big Walk-In Closet + Lovely Bath with Oversized Shower! Guest Suite/Second Bedroom with En-Suite Bath! Convenient Indoor Utility Room with Built-In Shelving! Manicured Backyard with Covered Patio! Automatic Sprinkler System Adds to Ease of Maintenance! UPGRADES GALORE: Kitchen & Bath Faucets, Cabinetry Hardware, Light Fixtures, Front Porch Lighting, Gutters, & Custom Paint! Walk to Community Pavilion, Park, & Splash Pad! Easy Access to Highway 59 & the Grand Parkway! WHY WAIT TO BUILD? TRULY RIVALS NEW CONSTRUCTION! MUST SEE!' ,`Acres` = '0.1581' ,`Area` = '40' ,`BuilderName` = 'Century Communities' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S747100 - NORTHPARK WOODS 01, BLOCK 2, LOT 4' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6887' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '660' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'BROOKWOOD FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WOODRIDGE FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Craftsman,Traditional' ,`Subdivision` = 'Northpark Woods' ,`TaxAmount` = '8177' ,`TaxRate` = '3.6131' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090238' WHERE `Matrix_Unique_ID` = '213664296'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-12T12:33:44.703' ,`MLSNumber` = '30186611' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.309560' ,`Longitude` = '-95.421810' ,`PhotoCount` = '6' ,`PostalCode` = '77301' ,`RoomCount` = '3' ,`ListPrice` = '229115.00' ,`Status` = 'Active' ,`StreetName` = 'Brushy Cedar' ,`StreetNumber` = '1843' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1248' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cooper – D home with brick and fiber cement exterior.  3 bedrooms and 2 baths.  Open concept design with 9’ ceilings.   Super Shower in the Primary Bath.  42” Cabinets in the Kitchen. Extended Island Countertop in the Kitchen;  Luxury Vinyl Plank Flooring in every room except for bedrooms and closets.  Stainless Steel Gas Range, Stainless Steel Microwave, and Stainless Steel Dishwasher.' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Rausch Coleman Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'N/A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'RUNYAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hidden Creek Preserve' ,`TaxAmount` = '' ,`TaxRate` = '2.7' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090238' WHERE `Matrix_Unique_ID` = '214046180'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-12T12:08:55.277' ,`MLSNumber` = '20787625' ,`ListAgentFullName` = 'Gerald Gonzalez' ,`ListOfficeName` = 'Lone Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.876451' ,`Longitude` = '-95.442788' ,`PhotoCount` = '9' ,`PostalCode` = '77088' ,`RoomCount` = '3' ,`ListPrice` = '245000.00' ,`Status` = 'Active' ,`StreetName` = 'Montgomery' ,`StreetNumber` = '9119' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1220' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This property is Located in the heart of Houston Hispanic Center. This property is excellent and ready to be a Fix and Flip opportunity or a property that can be converted into a small business! It has great potential, especially being a 3 bedroom and 1 bath. Take a chance to check out this incredible opportunity and start your journey with this beautiful potential home!' ,`Acres` = '0.3616' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 5 & 6 OF LT 28 BLK 1 HIGHLAND ACRE HOMES' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Other' ,`LotSize` = '15750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'ANDERSON ACADEMY' ,`SchoolHigh` = 'CARVER H S FOR APPLIED TECH/ENGINEERING/ARTS' ,`SchoolMiddle` = 'DREW ACADEMY' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland Acre Homes' ,`TaxAmount` = '1746' ,`TaxRate` = '2.5119' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1948' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090238' WHERE `Matrix_Unique_ID` = '214695225'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-12T12:34:32.110' ,`MLSNumber` = '21402992' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.309560' ,`Longitude` = '-95.421810' ,`PhotoCount` = '26' ,`PostalCode` = '77301' ,`RoomCount` = '4' ,`ListPrice` = '239215.00' ,`Status` = 'Active' ,`StreetName` = 'Brushy Cedar' ,`StreetNumber` = '1823' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1459' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ridgeland – C home with brick and fiber cement exterior.  4 bedrooms and 2 baths.  Open concept design with 9’ ceilings.   Garden Tub in the Master Bath.  42” Cabinets in the Kitchen. Quartz Countertop in the Kitchen; Quartz Countertops in the Bathrooms; Luxury Vinyl Plank Flooring in every room except for bedrooms and closets.  Stainless Steel Gas Range, Stainless Steel Microwave, and Stainless Steel Dishwasher.  Full Sod in the front and back yards!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Rausch Coleman Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'N/A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'RUNYAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hidden Creek Preserve' ,`TaxAmount` = '' ,`TaxRate` = '2.7' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090239' WHERE `Matrix_Unique_ID` = '214737734'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-12T12:28:22.730' ,`MLSNumber` = '24324441' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.309560' ,`Longitude` = '-95.421810' ,`PhotoCount` = '6' ,`PostalCode` = '77301' ,`RoomCount` = '3' ,`ListPrice` = '228925.00' ,`Status` = 'Active' ,`StreetName` = 'Brushy Cedar' ,`StreetNumber` = '1827' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1248' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cooper – C home with brick and fiber cement exterior.  3 bedrooms and 2 baths.  Open concept design with 9’ ceilings.   Garden Tub in the Master Bath.  42” Cabinets in the Kitchen. Extended Island Countertop in the Kitchen;  Luxury Vinyl Plank Flooring in every room except for bedrooms and closets.  Stainless Steel Gas Range, Stainless Steel Microwave, and Stainless Steel Dishwasher.   Full sod in the front and back yards!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Rausch Coleman Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'N/A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'RUNYAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hidden Creek Preserve' ,`TaxAmount` = '' ,`TaxRate` = '2.7' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090239' WHERE `Matrix_Unique_ID` = '214738150'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-12T12:36:05.583' ,`MLSNumber` = '64355713' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.309560' ,`Longitude` = '-95.421810' ,`PhotoCount` = '22' ,`PostalCode` = '77301' ,`RoomCount` = '3' ,`ListPrice` = '239925.00' ,`Status` = 'Active' ,`StreetName` = 'Brushy Cedar' ,`StreetNumber` = '1835' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1402' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Somerville – C home with brick and fiber cement exterior.  3 bedrooms and 2 baths.  Open concept design with 9’ ceilings.   Garden Tub in the Master Bath.  42” Cabinets in the Kitchen. Granite Countertop in the Kitchen; Quartz Countertops in the Bathrooms; Luxury Vinyl Plank Flooring in every room except for bedrooms and closets.  Stainless Steel Gas Range, Stainless Steel Microwave, and Stainless Steel Dishwasher.   Full sod in the front and back yards!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Rausch Coleman Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'N/A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'RUNYAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hidden Creek Preserve' ,`TaxAmount` = '' ,`TaxRate` = '2.7' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090239' WHERE `Matrix_Unique_ID` = '214738396'  --> Updated record success<br />INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215417459','1675090239','215417459','2022-12-12T12:03:48.370','85294866','Maria Guzman','RE/MAX Pearland','','','29.679694','-95.240015','12','77017','6','279900.00','Active','Possum Creek','2010','Road','Houston','2','0','3','1876','Single-Family','Stunning recently remodeled 3 bedroom, 2 full bath home located in Meadowcreek Village! Beautiful kitchen with stainless steel appliances (all electric), new cabinets, granite countertops, gorgeous backsplash, and tons of natural lighting. Open floor plan for the kitchen and living room, home has new laminate and carpet flooring. Brand new paint in and out, has a new roof, and foundation repair was done. Primary bedroom with en-suite bathroom! Laundry room inside, plus a bonus game room great for friends and family to hang out! Fenced backyard with 2 sheds. Call and make you appointment today! Conveniently located near I-45, 225, Hobby Airport, and 610!','0.1552','3','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Owner/Agent,Sellers Disclosure','0','','0','Hobby Area','Central Gas','0','LT 20 BLK 28 MEADOWCREEK VILLAGE SEC 5','Subdivision Lot','6760','Appraisal District','','','0','','0','Electric Oven','0','','','Electric Range','','Composition','27 - Houston','PATTERSON ELEMENTARY SCHOOL (HOUSTON)','CHAVEZ HIGH SCHOOL','STEVENSON MIDDLE SCHOOL (HOUSTON)','No Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Meadowcreek Village Sec 05','','','Public Sewer,Public Water','1957','Appraisal District');  --> New record created successfully<br />INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215535088','1675090239','215535088','2022-12-12T12:17:39.437','15712932','Vince Quoc Nguyen','Flash Realty','','','29.849601','-95.647758','25','77084','3','345000.00','Active','Sheffield Run','16406','Drive','Houston','2','0','3','1904','Single-Family','Gorgeous house features 3 bedrooms, 2 full bathroom and an attached 2 car garage. High ceiling,  tile & laminated flooring through out the whole house. The upgraded kitchen with granite countertop, appliances and is open to the main living area. Master bedroom with walk-in closet, his and her sink, separated stand-in shower and bathtub. This house is located conveniently minutes away from shopping, entertaining and dining center. Easy access to major routes such as Hwy 6, FM 529 and I-10. Room sizes are approximate. Buyer shall independently verify the measurements. Never been flooded/ Not in the flood zone. Schedule your showing TODAY!','','8','','','','','Mud,Sellers Disclosure','1','','','Bear Creek South','Central Gas','1','LT 9 BLK 2 BERKSHIRE PLACE SEC 3','Corner','6281','Appraisal District','','725','0','','2','','0','','','','','Composition','13 - Cypress-Fairbanks','LIEDER ELEMENTARY SCHOOL','CYPRESS LAKES HIGH SCHOOL','WATKINS MIDDLE SCHOOL','Lockbox Front','Appraisal District','1','Traditional','Berkshire Place Sec 3','5553','2.601','Water District','2013','Appraisal District');  --> New record created successfully<br />