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-11-21T06:57:33.663' ,`MLSNumber` = '48580188' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.701865' ,`Longitude` = '-95.706406' ,`PhotoCount` = '47' ,`PostalCode` = '77407' ,`RoomCount` = '11' ,`ListPrice` = '338990.00' ,`Status` = 'Active' ,`StreetName` = 'Lakeway Bluff' ,`StreetNumber` = '7315' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1780' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Home Completed! Grant Plan by D.R. Horton has everything you could ever want! Private Cul De Sac Lot! This open floor plan features an abundance of natural light inside, high ceilings, Upgraded Vinyl Wood Plank Flooring throughout, Tile in all wet areas & Plush Carpeting in all bedrooms! Your Casual Dining area & Family Room flows gracefully into the Gourmet Kitchen w/Upgraded Quartz Counters, Beautiful Tile Back-splash, Large Eat-in & Working Island w/Under-mount Stainless Sink & plenty of room for extra seating if needed, Stainless Steel Appliances, Tall Beautiful Shaker Cabinets & more! The Owner\'s Suite features Luxurious Bath w/Dual Sink Vanity, Separate Shower, Deep Soaker Tub & Walk-in Closet! HERS Energy Rated, Tankless/On-Demand H2O Heater! Outstanding Smart Home Automation System allowing you to control your home from anywhere, Lights, Thermostat & more! Covered Rear Patio! NO FLOODING! Amenities include: Pool, Splash Pad & more! 20 minutes to The Galleria!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lakeview Retreat Lot: 5 /Block: 1' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Lakeview Retreat' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669060063' WHERE `Matrix_Unique_ID` = '210365602'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T06:46:00.373' ,`MLSNumber` = '91342647' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.701848' ,`Longitude` = '-95.706490' ,`PhotoCount` = '30' ,`PostalCode` = '77407' ,`RoomCount` = '12' ,`ListPrice` = '333990.00' ,`Status` = 'Active' ,`StreetName` = 'Lakeway Bluff' ,`StreetNumber` = '7311' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1831' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New D. R. Horton Home under Construction - This Harris! As you enter this lovely home you are greeted with High Ceilings, extended hallway and Beautiful Vinyl Plank Wood Flooring throughout! Luxurious Carpeting in all bedrooms! Two Full Baths plus Half Bath! The Family Room features Walls of Windows projecting abundance of natural light inside! Your Casual Dining area flows gracefully into your Gourmet Kitchen which features Quartz Counters, lots of Tall Shaker Cabinets for storage space, Stainless Appliances, Large Eat-in & Working Island w/Under-mount Stainless Sink & more! Private Owner\'s Suite features Luxurious bathroom w/Soaker Tub & Shower & Huge Walk-in Closet. Energy Efficient Home(HERS Rated),Tankless Water Heater & features the \"Smart Home Automation System\" where you are able to control your home from anywhere, Camera Doorbell, Lighting, Electric Deadbolt, Thermostat & so much more! NO FLOODING! Amenities include: Pool, Splash Pad & More! Just 20 minutes to The Galleria!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lakeview Retreat Lot:  6 /Block: 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Lakeview Retreat' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669060063' WHERE `Matrix_Unique_ID` = '210367830'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T06:35:42.197' ,`MLSNumber` = '85598647' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.701869' ,`Longitude` = '-95.706565' ,`PhotoCount` = '26' ,`PostalCode` = '77407' ,`RoomCount` = '10' ,`ListPrice` = '321990.00' ,`Status` = 'Active' ,`StreetName` = 'Lakeway Bluff' ,`StreetNumber` = '7303' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1595' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Just Completed! The Caden Plan by D.R.Horton Lake Lot on Cul De Sac! Upon Entry of this lovely 3 Bedroom 2 Full Bathroom home you are greeted with Upgraded Luxurious Vinyl Wood Large Plank Flooring which leads the path into the Casual Dining Room & the Gourmet Kitchen w/Gorgeous Quartz Counters, Tile Back-splash, Large Eat-in Working Island w/Under-mount Stainless Sink & provides extra seating, Drinking Water Filtration System, Stainless Steel Appliances, Tall Cabinets, Subway Tile Backsplash & more! Amazing Family Room w/Wall of Windows overlooking Covered Patio! The Owner\'s Suite W/Luxurious Bath featuring Dual Sink Vanity, Separate Shower, Deep Soaker Tub & Huge Walk-in Closet!  Standard Energy Features: HERS Energy Rated, Tankless/On-Demand H2O Heater, 2 USB outlets & \"Smart Home\" allowing you to control the Skybell, Lighting, Deadbolt, Thermostat, Wireless Security & more from anywhere!! NO FLOODING! Amenities include: Pool, Splash Pad & More! Just 20 minutes to The Galleria!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lakeview Retreat Lot: 8 /Block: 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Water View' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Lakeview Retreat' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669060063' WHERE `Matrix_Unique_ID` = '210369551'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T06:12:47.157' ,`MLSNumber` = '19729826' ,`ListAgentFullName` = 'Brandi Bertrand' ,`ListOfficeName` = 'Doug Erdy Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.987554' ,`Longitude` = '-95.160792' ,`PhotoCount` = '47' ,`PostalCode` = '77346' ,`RoomCount` = '17' ,`ListPrice` = '515000.00' ,`Status` = 'Active' ,`StreetName` = 'Polo Meadow' ,`StreetNumber` = '18722' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '4792' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Open and spacious 6 bedrooms, 3 full bath, 1/2 bath 2 story brick home beautifully located on par 4 overlooking Walden of Lake Houston prestigious golf course. Home features a welcoming entryway, office area, formal dining & formal sitting area, and lots of natural light. Large living room with gas fireplace, large open concept kitchen with lots of cabinets & workable space. Relax outdoors with your very own oasis, beautiful inground saltwater swimming pool, lavish tropical landscaping, patio area covered pergola, outdoor landscaping lights & inground sprinkler system. New interior and exterior paint as of 08/2022. New saltwater filtration swimming pool pump installed 08/2022. AC/HVAC system was recently replaced and is under warranty until 2029. A New 30-year shingle roof put on in 2020. Inground saltwater swimming pool overlooking par 4' ,`Acres` = '0.2168' ,`Area` = '1' ,`BuilderName` = 'BRIGHTON HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 46 SPRINTERS VILLAGE WALDEN ON LAKE HOUSTON PH VII' ,`LotDesciption` = 'Cleared,In Golf Course Community,Subdivision Lot' ,`LotSize` = '9445' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '377' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'MAPLEBROOK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Walden On Lake Houston Ph 07' ,`TaxAmount` = '9869' ,`TaxRate` = '2.5885' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1669060063' WHERE `Matrix_Unique_ID` = '211592585'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T06:38:24.570' ,`MLSNumber` = '63859346' ,`ListAgentFullName` = 'Anne Hettiger' ,`ListOfficeName` = 'Segue Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.646623' ,`Longitude` = '-95.122522' ,`PhotoCount` = '42' ,`PostalCode` = '77505' ,`RoomCount` = '9' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Flora' ,`StreetNumber` = '4206' ,`StreetSuffix` = 'Drive' ,`City` = 'Pasadena' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2651' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this stunning 4/3.5 home in Village Grove Community, zoned to Deer Park ISD. Nestled on a quiet street w/community pool. Your guests will enter through grand lead glass door. As you step in you will feel right at home with the open concept floor plan & high, vaulted, open ceilings. The impressive light & bright chef\'s kitchen boasts beautiful granite countertops & extensive cabinetry for tons of storage. Gorgeous newly installed waterproof vinyl plank flooring. Cozy fireplace is the perfect centerpiece for your spacious family room that is open to upstairs floor. The master suite is located on 1st floor w/private bath, double sinks, walk-in closet, & separate standup shower. It is the ultimate retreat on its own separate floor. Oversized gameroom and 3 spacious guest bedrooms are upstairs.This home has a large backyard that is great for get togethers and bbq! Also has tankless water heater.  GENERAC Generator for complete peace of mind for any power issues installed May 2022' ,`Acres` = '0.2056' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 36 BLK 2 VILLAGE GROVE EAST SEC 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8957' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'JP DABBS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRMONT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Village Grove East' ,`TaxAmount` = '7498' ,`TaxRate` = '2.8798' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669060063' WHERE `Matrix_Unique_ID` = '211987567'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T06:42:37.160' ,`MLSNumber` = '42646866' ,`ListAgentFullName` = 'Kristy Pennetta' ,`ListOfficeName` = 'Real Property Management Prefe' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.996374' ,`Longitude` = '-95.491046' ,`PhotoCount` = '37' ,`PostalCode` = '77068' ,`RoomCount` = '8' ,`ListPrice` = '260000.00' ,`Status` = 'Active' ,`StreetName` = 'Stillview' ,`StreetNumber` = '3830' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2569' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**JUST REDUCED!!\r\nDon\'t miss out out on this two story home located in the Oak Creek Village Subdivision. Open kitchen with plenty of cabinets and counter space. Spacious living room with a cozy fireplace. Easy access to 249 and I-45. \r\nCall to schedule your appointment today!!' ,`Acres` = '0.2185' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 10 OAK CREEK VILLAGE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9520' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`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` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Creek Village Sec 01' ,`TaxAmount` = '4550' ,`TaxRate` = '2.4592' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669060064' WHERE `Matrix_Unique_ID` = '212653082'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T06:14:49.443' ,`MLSNumber` = '93032966' ,`ListAgentFullName` = 'Cheryl Stovall' ,`ListOfficeName` = 'Birdsong Real Estate' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS                       ' ,`Latitude` = '28.409664' ,`Longitude` = '-96.718022' ,`PhotoCount` = '15' ,`PostalCode` = '77983' ,`RoomCount` = '5' ,`ListPrice` = '120000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Washington' ,`StreetNumber` = '701' ,`StreetSuffix` = 'Avenue' ,`City` = 'Seadrift' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1008' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming home on almost a quarter-acre corner lot.  This home offers you two bedrooms, one bathroom, a living room, separate dining room, and an indoor utility room.  Enjoy a glass of tea on your large front porch or take a stroll one block over to enjoy the bay.  Home is being sold As-Is.' ,`Acres` = '0.2445' ,`Area` = '65' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'SEADRIFT TOWNSITE, BLOCK 73, LOT 8' ,`LotDesciption` = 'Cleared,Corner,Water View' ,`LotSize` = '10650' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '169 - Calhoun County' ,`SchoolElementary` = 'SEADRIFT SCHOOL' ,`SchoolHigh` = 'CALHOUN HIGH SCHOOL' ,`SchoolMiddle` = 'SEADRIFT SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Seadrift Townsite' ,`TaxAmount` = '2375' ,`TaxRate` = '2.2666' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669060064' WHERE `Matrix_Unique_ID` = '212785784'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T05:23:41.090' ,`MLSNumber` = '88441763' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Tri Pointe Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.719533' ,`Longitude` = '-95.871403' ,`PhotoCount` = '50' ,`PostalCode` = '77441' ,`RoomCount` = '9' ,`ListPrice` = '720000.00' ,`Status` = 'Active' ,`StreetName` = 'Ember Crest' ,`StreetNumber` = '28906' ,`StreetSuffix` = 'Lane' ,`City` = 'Fulshear' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3831' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This new Bethel plan is a stunning 2-story, 5-bedroom home with designer touches\r\nthroughout.  After a long\r\nday, enjoy iced tea on the back covered patio or by the cozy decorative tile fireplace in\r\nthe great room. The great room is spacious with double height ceilings and open into the\r\nkitchen where cooking is a breeze with the Chef\'s appliance package featuring stainless\r\nsteel appliances, double ovens, Silestone Quartz countertops, LED under cabinet lighting,\r\nand a 36-inch built-in gas cooktop. For overnight guests, you need a private room,\r\nand the 2nd bedroom downstairs is perfect. Retreat to the primary suite with a large walkin closet, dual sinks, and a sleek freestanding tub. Entertain in the upstairs game room\r\nwith shuffleboard or the soccer match and catch your favorite movie in the added media\r\nroom. Complete with a 3-car tandem garage and luxury vinyl floors in the downstairs main\r\nliving areas, this home is sure to be on the top of your list!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Tri Pointe Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '37/01/CT05' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9219' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`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` = 'Cross Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.33' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669060064' WHERE `Matrix_Unique_ID` = '213370268'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T06:40:08.667' ,`MLSNumber` = '77062375' ,`ListAgentFullName` = 'Tara Anderson' ,`ListOfficeName` = 'Keller Williams Realty - Memor' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.392005' ,`Longitude` = '-95.673823' ,`PhotoCount` = '19' ,`PostalCode` = '77356' ,`RoomCount` = '10' ,`ListPrice` = '1373620.00' ,`Status` = 'Active' ,`StreetName` = 'Mia Lago' ,`StreetNumber` = '114' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gated community. This lot backs up to the community walking trail and water feature. Currently a vacant. Price includes a landscape. Contact Tara for more information.' ,`Acres` = '2.4563' ,`Area` = '39' ,`BuilderName` = 'Gryphon Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S456200 - ESTATES OF MIA LAGO 01, BLOCK 2, LOT 3, ACRES 2.45' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View' ,`LotSize` = '106996' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition,Tile' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = '' ,`Stories` = '2.5' ,`Style` = 'Colonial,Mediterranean' ,`Subdivision` = 'Estates Of Mia Lago 01' ,`TaxAmount` = '4917' ,`TaxRate` = '2.2242' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669060064' WHERE `Matrix_Unique_ID` = '213371997'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T06:59:53.547' ,`MLSNumber` = '59815879' ,`ListAgentFullName` = 'Deanna Parsons' ,`ListOfficeName` = 'Hill & Associates' ,`SellingAgentFullName` = 'David Tello' ,`SellingOfficeName` = 'Lions Gate Realty' ,`Latitude` = '29.987820' ,`Longitude` = '-95.017868' ,`PhotoCount` = '22' ,`PostalCode` = '77532' ,`RoomCount` = '6' ,`ListPrice` = '119900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Felscher' ,`StreetNumber` = '4670' ,`StreetSuffix` = 'Lane' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1240' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Metal roof!  Almost a whole acre!  3/2 with a large livingroom and a kitchen with breakfast space.  Call your favorite realtor for a showing today!' ,`Acres` = '0.93' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Real Estate Owned' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 3C-10 HONEY TREE COUNTRY U/R ABST 1384 HT&BRR CO SEC 6' ,`LotDesciption` = 'Cleared' ,`LotSize` = '40510' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'BARRETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Honey Tree Country Tract 10 Pc' ,`TaxAmount` = '960' ,`TaxRate` = '2.0943' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669060065' WHERE `Matrix_Unique_ID` = '214519144'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T05:16:04.507' ,`MLSNumber` = '13424823' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.816035' ,`Longitude` = '-95.844125' ,`PhotoCount` = '48' ,`PostalCode` = '77493' ,`RoomCount` = '10' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'San Bernard' ,`StreetNumber` = '6906' ,`StreetSuffix` = 'Trail' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3918' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The front porch welcomes you home each day to your beautiful new home in Cane Island, located in Old Katy.  This home is located at the end of a cul de sac street adjacent to a green space.  The chef\'s kitchen features a large island, two pantries, double convection ovens, and under cabinet lighting.  The White Summit granite countertops make the kitchen light & bright.  Walk out onto the oversized patio from the large sliding glass doors in your family room.  Relax in your private owners retreat, featuring high ceilings, soaker tub, large shower & double vanity sinks.  The home has a second bedroom on the first floor with an in-suite bath which is perfect for guests.  Enjoy family movie night in your upstairs media room.  The second floor also provides a retreat & bonus space so there is so much space for your family to grow.  Children attend KISD schools.  David Weekley Homes guarantees heating & cooling usage for three years with our Environments for Living Program.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 30 Block 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8251' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cane Island' ,`TaxAmount` = '' ,`TaxRate` = '3.45' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669060065' WHERE `Matrix_Unique_ID` = '214663397'  --> 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','214821486','1669060065','214821486','2022-11-21T05:32:32.597','32427827','Stacey Simpson','Southern Properties & Estates','','','30.211518','-95.423493','41','77385','9','379900.00','Active','Up Country','9962','Lane','Conroe','2','1','4','3047','Single-Family','This beautiful 4+ bedroom home on a gorgeous oversized cul de sac lot has been remodeled & ready for a new owner! NEW ROOF! Tons of windows w natural light! Fresh paint throughout & NEW Greenguard Gold laminate wood flooring plus NEW carpet everywhere! Brand NEW kitchen update is stunning. Great dining off the kitchen & bonus/extra room downstairs that could be used as secondary bedroom in addition to open living space. Spacious primary & bath suite w large walk in closet. Media room, game room or play room shared upstairs for whatever your needs may be. Large secondary rooms w great bath, double basins & great shower/tub combo. Side covered porch/patio. Great wrap around yard. Brand new fence w room for a pool! Walking is no problem to school nearby. Quick walk to catch bus as well. Newer HEB near, hospitals close, Starbucks/Chickfila/Walmart/Lowes. Quick commute drives to I-45/99/59. Room sizes approx. Never flooded, not in flood zone.','0.2351','15','','','Electric Dryer Connections','','Mud,Sellers Disclosure','1','Gas Connections','1','Conroe Southeast','Central Gas','1','S720805 - MONTGOMERY CREEK RANCH 05, BLOCK 5, LOT 17','Cul-De-Sac,Greenbelt,Subdivision Lot','10241','Appraisal District','','320','0','','2','Gas Oven','0','','','Gas Range','','Composition','11 - Conroe','SUCHMA ELEMENTARY SCHOOL','OAK RIDGE HIGH SCHOOL','IRONS JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Montgomery Creek Ranch 05','7010','2.6088','Public Sewer,Public Water','2009','Appraisal District');  --> New record created successfully<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T06:47:19.713' ,`MLSNumber` = '73442376' ,`ListAgentFullName` = 'Inna Ogbeide' ,`ListOfficeName` = 'Braden Real Estate Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.630243' ,`Longitude` = '-96.401559' ,`PhotoCount` = '32' ,`PostalCode` = '77807' ,`RoomCount` = '13' ,`ListPrice` = '395000.00' ,`Status` = 'Active' ,`StreetName` = 'Viva' ,`StreetNumber` = '2000' ,`StreetSuffix` = 'Road' ,`City` = 'Bryan' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2609' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Just like new! Built by Stylecraft in 2018, this home is a real gem! This gorgeous 4 bed, 3.5 bath, 2 story home is located in the heart of College Station in a quiet, family friendly neighborhood. With a wood and brick exterior, this beautiful home features a 2-car garage, a 3+ car extended driveway and a massive corner lot. Upon entry, you are greeted with high ceilings and tons of natural light. This home offers an open floorplan concept and is perfect for entertaining family and friends. The spacious and bright kitchen features a peninsula island with granite countertops, mocha cabinets, matching stainless steel appliances and a walk in pantry. Downstairs you will find the primary ensuite with abundance of space, including double sinks in the bathroom, a soaking tub with a separate shower and a walk-in closet. There are 3 additional bedrooms upstairs, 2 full baths and a game/media room. This home has a fully fenced, large backyard and comes w/ appliances. This is a must-see!' ,`Acres` = '0.2171' ,`Area` = '61' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'EDGEWATER PH 2, BLOCK 14, LOT 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '9457' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition,Wood Shingle' ,`SchoolDistrict` = '148 - Bryan' ,`SchoolElementary` = 'MARY BRANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRYAN HIGH SCHOOL' ,`SchoolMiddle` = 'STEPHEN F. AUSTIN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Edgewater Ph 2' ,`TaxAmount` = '8307' ,`TaxRate` = '2.193' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669060065' WHERE `Matrix_Unique_ID` = '214840308'  --> 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','214911651','1669060065','214911651','2022-11-21T05:26:17.723','83698998','Deanna Parsons','Hill & Associates','','','29.918367','-95.064494','34','77532','8','269900.00','Active','Savory','519','Lane','Crosby','2','1','4','1908','Single-Family','You are going to love this beauty!  This one is move in ready with beautiful paint and flooring!  Four bedrooms!  Downstairs features the primary bedroom, large livingroom and breakfast area.  Upstairs are three more bedrooms, with a large gameroom area.  All of this, plus a nice sized fenced in backyard.  Call your favorite realtor to schedule your showing today!','0.1575','1','','','','','Real Estate Owned','','','','Crosby Area','Central Gas','1','LT 5 BLK 2 CROSBY VILLAGE SEC 1','Subdivision Lot','6862','Appraisal District','','250','0','','2','','0','','','','','Composition','12 - Crosby','CROSBY ELEMENTARY SCHOOL (CROSBY)','CROSBY HIGH SCHOOL','CROSBY MIDDLE SCHOOL (CROSBY)','Appointment Required','Appraisal District','2','Traditional','Crosby Village Sec 1','5278','2.5468','Public Sewer,Public Water','2007','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','214968024','1669060065','214968024','2022-11-21T05:21:35.530','91008220','Kristy Pennetta','Real Property Management Prefe','','','29.843763','-95.638977','0','77084','3','265000.00','Active','Hickory Downs','4711','Drive','Houston','2','0','3','1834','Single-Family','Don\'t miss out on this beauty! Spacious light and bright single story in the well-established Bear Creek Village. The living area brings in plenty of natural light with the skylights and a cozy fireplace. The kitchen has plenty of storage and counter space, stainless appliances and a breakfast bar. The 3 bedrooms are spacious with walk in closets. \r\nThis beauty would be a wonderful place to call HOME!!','0.1613','8','','','','','No Disclosures','','','1','Katy - North','Central Gas','1','LT 64 BLK 16 BEAR CREEK VILLAGE SEC 9','Subdivision Lot','7025','Appraisal District','','475','0','','2','','0','','','','','Composition','30 - Katy','BEAR CREEK ELEMENTARY SCHOOL (KATY)','MAYDE CREEK HIGH SCHOOL','CARDIFF JUNIOR HIGH SCHOOL','Vacant/Unoccupied','Appraisal District','1','Traditional','Bear Creek Village Sec 09','4744','2.1736','Public Sewer,Public Water','1977','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','214989042','1669060065','214989042','2022-11-21T06:42:36.817','97805561','Jordan Hogan','NextHome Realty Center','','','29.441943','-94.663598','8','77650','5','569880.00','Active','Selwyn','979','Road','Crystal Beach','2','1','3','1490','Single-Family','Anticipated Construction Completion Date is Marc 31, 2023. This is an exceptional opportunity to purchase a brand new ocean side, custom beach villa that is moments from the beach. This will make the perfect weekend getaway or a primary residence.The floor plan is wide open with vaulted ceilings, eat up kitchen island, 3 bedrooms, 3 bathrooms, incredible finishes, etc. IT WILL NOT LAST AT THIS PRICE.','0.1631','33','TRI Contracting','','','','No Disclosures','','','','Crystal Beach','Central Electric','0','ABST 179 J SHAW SUR LOT 241 BLUE WATER ADDN NO 2','Cleared','7105','Appraisal District','','','1','To Be Built/Under Construction','','','0','','','','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','No Appointment Required','Builder','1','Contemporary/Modern','Blue Water 2','727','1.6103','Public Water','2022','Builder');  --> New record created successfully<br />