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-12-06T10:33:48.777' ,`MLSNumber` = '18335068' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = 'Natalie Tye' ,`SellingOfficeName` = 'Monarch Real Estate & Ranch' ,`Latitude` = '29.701834' ,`Longitude` = '-95.706431' ,`PhotoCount` = '27' ,`PostalCode` = '77407' ,`RoomCount` = '11' ,`ListPrice` = '367990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Bradford' ,`StreetNumber` = '6702' ,`StreetSuffix` = 'Terrace' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1778' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One Story Ranch Home on Large Cul De Sac Lot by D.R. Horton! Ready for move in! Ultra Modern & Chic Stucco W/Brick Elevation! Gorgeous Vinyl Wood Plank Floors throughout! Plush Carpeting in all Bedrooms! This home is perfect for entertaining! Outstanding Open Floor Plan! Dramatic Gourmet Kitchen with stunning Quartz Countertops, Tile Back-splash, Large Eat-in Working Island with Deep Under-mount Stainless Sink, Tall Shaker Cabinets, Stainless Steel Appliances, Walk In Pantry & More! Gourmet Kitchen gracefully flows into your Casual Dining area & Amazing Family Room with Wall of Windows! The Private Owner\'s Suite features a Luxurious Bathroom built for 2 with His & Her Sink Smooth Top Vanity, Massive Shower & Walk-in Closet! Energy Efficient Home: HERS Energy Rated, Tankless/On-Demand H2O Heater, 2 USB outlets & \"Smart Home System, which allows you to control lights, locks, & thermostat! Covered 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: 87 /Block: 2' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt' ,`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' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch' ,`Subdivision` = 'Lakeview Retreat' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675087943' WHERE `Matrix_Unique_ID` = '209632402' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-06T10:37:18.153' ,`MLSNumber` = '90690983' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = 'Gayla Gayden' ,`SellingOfficeName` = 'REALM Real Estate Professional' ,`Latitude` = '29.701865' ,`Longitude` = '-95.706406' ,`PhotoCount` = '50' ,`PostalCode` = '77407' ,`RoomCount` = '11' ,`ListPrice` = '384990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Telford Hollow' ,`StreetNumber` = '6823' ,`StreetSuffix` = 'Trail' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1780' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The New Construction-Grant Plan by D.R. Horton has everything you could ever want in a home! Amazing Elevation! This open floor plan features an abundance of natural light inside, high ceilings, Upgraded Vinyl 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, Tile Back-splash, Large Eat-in & Working Island w/Undermount Stainless Sink & plenty of room for extra seating if needed, Stainless Steel Appliances, Tall 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, 2 USB outlets & more! Outstanding Smart Home Automation System allowing you to control your home from anywhere, Lights, Thermostat & more! Covered Rear Covered Patio! NO FLOODING! Amenities include: Pool, Splash Pad & more! 20 minutes to The Galleria! More!' ,`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: 20 /Block: 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`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' ,`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`='1675087944' WHERE `Matrix_Unique_ID` = '209670256' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-06T10:58:27.800' ,`MLSNumber` = '91439754' ,`ListAgentFullName` = 'Judy Hansen' ,`ListOfficeName` = 'Neptune Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.327145' ,`Longitude` = '-94.940191' ,`PhotoCount` = '39' ,`PostalCode` = '77563' ,`RoomCount` = '8' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Ling' ,`StreetNumber` = '315' ,`StreetSuffix` = 'Street' ,`City` = 'Bayou Vista' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1032' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Perfect waterfront living and entertaining in this 2-bedroom beauty with a boathouse and party deck. One bathroom upstairs and a half-bath down. One-car garage with automatic door opener. Lots of updates. AC, 2016. Renovated kitchen in 2016, featuring new cabinets, quartz countertops and stone backsplash. Vinyl bulkhead, 2016. Roof, 2016. Porcelain plank flooring throughout upstairs, 2020. Stamped concrete downstairs and a custom-built table bar. In addition to the utility room downstairs, there is also a flex room that could be used for storage, a she-shed, etc. Bayou Vista is a golf-cart community with easy access to I-45 to Galveston or Houston. Come and enjoy the waterfront lifestyle; fishing, crabbing, swimming from your own dock or simply press a button to lower your boat into the water and take a relaxing, beautiful, sunset cruise.' ,`Acres` = '0.0976' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bayou Vista' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 7 PAGE 7 LOT 315 NEW BAYOU VISTA ADDN 3' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '4250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HAYLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'New Bayou Vista 3' ,`TaxAmount` = '5765' ,`TaxRate` = '2.635' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675087944' WHERE `Matrix_Unique_ID` = '209754804' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-06T09:56:33.220' ,`MLSNumber` = '68090195' ,`ListAgentFullName` = 'Nicole Freer' ,`ListOfficeName` = 'NICOLE FREER GROUP' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.401926' ,`Longitude` = '-95.060127' ,`PhotoCount` = '21' ,`PostalCode` = '77568' ,`RoomCount` = '8' ,`ListPrice` = '359990.00' ,`Status` = 'Active' ,`StreetName` = 'Sweet Bay' ,`StreetNumber` = '2129' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2375' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ASHTON WOODS NEW CONSTRUCTION - Welcome home to 2129 Sweet Bay Drive located in the community of Lago Mar and zoned to Dickinson ISD. The Washington floorplan features 4 bedrooms, 2 full baths, 1 half baths and an attached 2 car garage. The 1st floor includes an open concept kitchen and family room along with the primary owner\'s suite. Come upstairs where you will find 3 secondary bedrooms and a game room. Don\'t forget to step out back for a view of the backyard. Estimated completion date is January 2023. You don\'t want to miss all this home has to offer! Call to schedule your showing today!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Ashton Woods' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Shipmans Cove Section 5, Block 4, Lot 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5400' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1330' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.55' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675087944' WHERE `Matrix_Unique_ID` = '211704265' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-06T09:12:32.157' ,`MLSNumber` = '97457934' ,`ListAgentFullName` = 'Osaan Ronding' ,`ListOfficeName` = 'The Listing Firm' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.958722' ,`Longitude` = '-95.581492' ,`PhotoCount` = '49' ,`PostalCode` = '77070' ,`RoomCount` = '9' ,`ListPrice` = '389000.00' ,`Status` = 'Active' ,`StreetName` = 'Justin' ,`StreetNumber` = '12746' ,`StreetSuffix` = 'Trail' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2915' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful & meticulously kept by original owner, 5 bedroom, 3.5 bath home in quiet, established subdivision near shopping, dining, parks, hospitals and CFSID schools. Over $100k in upgrades. Please see upgrades list photo. 2 spacious master bedrooms (1 up & 1 down). Wall of windows and cozy gas log fireplace in the family room w/ dramatic two-story ceiling. Granite countertops in kitchen and 2 bathrooms. New SS appliances, including a gas range, refrigerator, microwave and super-quiet dishwasher. Fresh interior paint throughout. Lots of storage space plus a secret hide-away room. Enjoy the private backyard oasis from the comfort of your air-conditioned sunroom! NEVER FLOODED! Close to 1960, 249, 290, and Bwy 8. Owner willing to negotiate for pictured furniture to someone who wants to move in and start living immediately – dining room table & chairs, breakfast table, recliners, bedroom set & desk. Samsung washer & dryer and LG refrigerator are included in the price of the house.' ,`Acres` = '0.1515' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Willowbrook South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 1 SILVER PINES SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MATZKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Silver Pines Sec 01' ,`TaxAmount` = '6967' ,`TaxRate` = '2.7537' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675087944' WHERE `Matrix_Unique_ID` = '211779054' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-06T10:46:19.257' ,`MLSNumber` = '86814016' ,`ListAgentFullName` = 'Kimberly Smith' ,`ListOfficeName` = 'RE/MAX On The Water - Bolivar' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.518084' ,`Longitude` = '-94.474732' ,`PhotoCount` = '20' ,`PostalCode` = '77617' ,`RoomCount` = '4' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Audubon' ,`StreetNumber` = '2518' ,`StreetSuffix` = 'Avenue' ,`City` = 'Gilchrist' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1176' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Views! VIEWS! V.I.E.W.S. This fabulous three-level, hurricane-ready, 2020 construction home is your getaway beach escape! Located on Bolivar Peninsula in Gilchrist - the “quiet” “country” zone at the beach. And just a 10-minute drive to Crystal Beach stores and restaurants… and just a pleasant 20-minute ferry ride to the hustle and bustle of Galveston when you want it. It’s a private home that has never been rented. It has two bedrooms, two baths, a spacious open living area and kitchen, 360-degree covered and uncovered 3rd-level decks and porches, a fabulous covered 900 square feet 2nd-level entertainment and relaxation mezzanine, a 1st level shower, parking for 6+ cars, and an elevator/lift to all levels. It is fully furnished and ready for immediate move in. Unobstructed front views to the Gulf beach and unobstructed rear views to Galveston Bay, the Audubon Wildlife Reserve and the Inter-coastal Waterway. This IS your place at the beach!' ,`Acres` = '0.0773' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'HOA First Right of Refusal,Home Protection Plan,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Gilchrist' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'AUDUBON VILLAGE SEC 2 (2008) ABST 52, LOT 5, ACRES 0.077' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '3369' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '25 - High Island' ,`SchoolElementary` = 'HIGH ISLAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HIGH ISLAND HIGH SCHOOL' ,`SchoolMiddle` = 'HIGH ISLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Audubon Village Sec 2 2008' ,`TaxAmount` = '3675' ,`TaxRate` = '1.5543' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675087944' WHERE `Matrix_Unique_ID` = '213047105' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-06T09:03:13.207' ,`MLSNumber` = '96618474' ,`ListAgentFullName` = 'LaNelle McKay' ,`ListOfficeName` = 'Krisher-McKay, Inc., REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.913984' ,`Longitude` = '-95.050909' ,`PhotoCount` = '35' ,`PostalCode` = '77532' ,`RoomCount` = '6' ,`ListPrice` = '333000.00' ,`Status` = 'Active' ,`StreetName` = 'Alpha' ,`StreetNumber` = '1319' ,`StreetSuffix` = 'Lane' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1742' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Within minutes from Hwy 90 for easy commute**.76 acres**inground pool' ,`Acres` = '0.2534' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 17 BLK 8 RUNNEBERG ESTATES SEC 2 U/R ABST 518 A I LEWIS' ,`LotDesciption` = 'Other' ,`LotSize` = '33120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`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` = 'Runneberg Estates 15 Sec 2' ,`TaxAmount` = '4636' ,`TaxRate` = '2.5468' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675087945' WHERE `Matrix_Unique_ID` = '213150100' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-06T10:29:14.083' ,`MLSNumber` = '27173998' ,`ListAgentFullName` = 'Deanna Zugheri' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.814525' ,`Longitude` = '-95.422285' ,`PhotoCount` = '40' ,`PostalCode` = '77018' ,`RoomCount` = '6' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Stonecrest' ,`StreetNumber` = '1138' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2305' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nicely updated home in Shepherd Forest zoned to Garden Oaks Elementary. Nicely appointed kitchen with stainless appliances and modern stainless apron sink. Huge great room that has wall of windows looking out to backyard letting it an abundance of natural light. The study is spacious with pane window looking out to front. The dining area and bedrooms have beautiful hardwood floors, giving these areas a rich feel. Home is located in very popular area for walking to retail and very easy access to some of Houston\'s hottest spots.' ,`Acres` = '0.1594' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 237 BLK 13 SHEPHERD FOREST' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6944' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GARDEN OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Shepherd Forest' ,`TaxAmount` = '9614' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1953' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675087945' WHERE `Matrix_Unique_ID` = '213753352' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-06T10:54:17.723' ,`MLSNumber` = '84896202' ,`ListAgentFullName` = 'Shelly Mattingly-Arnold' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.439739' ,`Longitude` = '-95.452166' ,`PhotoCount` = '38' ,`PostalCode` = '77583' ,`RoomCount` = '7' ,`ListPrice` = '259900.00' ,`Status` = 'Active' ,`StreetName` = 'Pink Stone' ,`StreetNumber` = '1634' ,`StreetSuffix` = 'Drive' ,`City` = 'Iowa Colony' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1581' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this well maintainted 3 bedroom, 2 bath home in the gated Sterling Lakes Subdivision. This home features a large family room with an open concept, split floor plan, tile and wood plank flooring throughout all common areas, carpet in bedrooms, an abundance of natural lighting, formal dining, large breakfast bar, granite countertops, large primary bedroom with soaking tub, separate walk in shower, and oversized walk in closet, lots of storage space, and laundry room conveniently located in the home. Enjoy your evenings on your covered back patio with large back yard, offering lots of green space. Conveniently located just off of Hwy 288 with a short drive to downtown Houston, near shopping, dining, and entertainment, and Alvin ISD School District. Don\'t delay, come and make this home yours today!' ,`Acres` = '0.2015' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'STERLING LAKES WEST SEC 2 (A0714 WM PATTUS) BLK 1 LOT 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8777' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'SANCHEZ ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sterling Lakes West Sec 2 A07' ,`TaxAmount` = '7437' ,`TaxRate` = '3.4099' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675087945' WHERE `Matrix_Unique_ID` = '214654108' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-06T09:34:10.630' ,`MLSNumber` = '82918148' ,`ListAgentFullName` = 'Susan Kiel' ,`ListOfficeName` = 'Market Realty Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.151811' ,`Longitude` = '-96.396930' ,`PhotoCount` = '16' ,`PostalCode` = '77833' ,`RoomCount` = '5' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Austin' ,`StreetNumber` = '1903' ,`StreetSuffix` = 'Street' ,`City` = 'Brenham' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2443' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Newly remodeled duplex in Brenham. This very unique investment opportunity in the heart of Brenham close to historic downtown and major shopping. Two units 1903A is 3 bedroom 2 bath (1,341 SF per WCAD) with 1 car garage and 1903B is 2 bedroom 2 bath (1,102 SF living per WCAD) with 1 car garage. Exterior updated in 10/22 with hardi board trim and repainted. Each side has new interior paint, new laminate and carpet floors, new refrigerator, range/oven, fanhood and dishwasher in each unit. It had long term tenants for many years and the owner decided to sell and remodel. The new owner can establish their own market rent and select new tenants. The rental market in Brenham is very strong and this opportunity does not come around often. Great location for a rental unit or live in one side and lese the other to supplement your income.' ,`Acres` = '0.2' ,`Area` = '58' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WASHINGTON PARK, BLOCK S, LOT 2, ACRES 0.2, REPLAT OF BLOCK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8712' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '137 - Brenham' ,`SchoolElementary` = 'BISD DRAW' ,`SchoolHigh` = 'BRENHAM HIGH SCHOOL' ,`SchoolMiddle` = 'BRENHAM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Lockbox Right Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Washington Park' ,`TaxAmount` = '4457' ,`TaxRate` = '1.832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675087945' WHERE `Matrix_Unique_ID` = '214901183' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-06T10:49:12.550' ,`MLSNumber` = '70812091' ,`ListAgentFullName` = 'Tania Castelan' ,`ListOfficeName` = 'Connect Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.997566' ,`Longitude` = '-94.225046' ,`PhotoCount` = '42' ,`PostalCode` = '77713' ,`RoomCount` = '5' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Kidd' ,`StreetNumber` = '7638' ,`StreetSuffix` = 'Road' ,`City` = 'Beaumont' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3621' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous, custom designed brick home sitting on 2 acres of land secluded down a long driveway! Walk in to be greeted w/ an open floorplan, concrete stained floors, crown molding, recessed lighting & more! Off to the right you have a formal dining area currently being used as a sitting room. The living area boasts double French doors leading out to the back patio, allowing for an abundance of natural light to flow into the main area. The kitchen features custom built cabinets, granite countertops, a large island, built-in oven and tons of cabinet space for all your storage. Retreat to the large master suite where you\'ll find double sinks, a jetted tub, separate shower & a walk-in closet, along w/ your own private patio. You have 2 guest bedrooms downstairs w/ a full bath & half bath. Upstairs are 2 more guest bedrooms w/ a full bath as well. Sit out on your back patio & enjoy the Texas sunsets w/ no back neighbors & a fully stocked pond! Call today to schedule your personal tour!' ,`Acres` = '2' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'H T & B RR-ABS 146 TR 38 2.000 SO PARK' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '87120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'DISHMAN ELEMENTARY SCHOOL (BEAUMONT)' ,`SchoolHigh` = 'WEST BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'VINCENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'OTHER' ,`TaxAmount` = '4601' ,`TaxRate` = '1.8901' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675087946' WHERE `Matrix_Unique_ID` = '214986450' --> Updated record success
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','215240676','1675087946','215240676','2022-12-06T10:51:31.027','11446779','Monica Rojas','RE/MAX 1st Choice','','','29.375979','-94.989125','36','77568','13','549000.00','Active','Taylor','3030','Street','La Marque','2','1','4','2980','Single-Family','TALK ABOUT A FIND! CUSTOM BUILT, ONE OWNER HOME! FOUR BEDROOMS PLUS HOME OFFICE AND 16X16 MEDIA/BAR ENTERTAINING ROOM WITH SEPARATE ACCESS TO THREE CAR GARAGE AND ½ BATH EASILY ACCESSABLE TO BOTH MEDIA AND GARAGE AREA. LARGE MASTER ENSUITE. CUSTOM BLINDS. HIGH CEILINGS, MOLDINGS, GRANITE COUNTER TOPS, OPEN KITCHEN LIVING AND DINING AREAS. FORMAL ENTRY. INDOOR LAUNDRY (WITH HOOKUPS FOR TWO WASHER/DRYER SETS) FOLDING AREA. FULLY FENCED BACKYARD. FULLY COVERED FRONT PORCH AND FULL LENGTH COVERED BACK PATIO WITH OUTDOOR FIREPLACE. GAZEBO AND ADDITIONAL STORAGE AREA. BEAUTIFUL HOME. NO HOA. CITY SERVICES.','0.7446','33','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','0','La Marque','Central Gas,Zoned','0','ABST 2 PAGE 6 LOT 19 (19-1) LA MARQUE HEIGHTS','Cleared,Subdivision Lot','32432','Appraisal District','','','0','','3','Freestanding Oven,Gas Oven,Single Oven','0','','','Freestanding Range,Gas Range','','Composition','52 - Texas City','HAYLEY ELEMENTARY SCHOOL','LA MARQUE HIGH SCHOOL (TEXAS CITY)','LA MARQUE MIDDLE SCHOOL (TEXAS CITY)','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','La Marque Heights','10075','2.6428','Public Sewer,Public Water,Water District','2013','Appraisal District'); --> New record created successfully
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','215279753','1675087946','215279753','2022-12-06T10:19:06.000','93405947','Heidi Dugan','Greenwood King Properties','','','29.709876','-95.436110','6','77005','15','5399000.00','Active','Farber','3757','Street','Southside Place','7','2','6','7258','Single-Family','Spectacular new construction across from Firetruck park in Southside Place on coveted 11,250 sf lot (HCAD) by Georgetown Capital Bldrs, acclaimed luxury West U/Southside bldr for 20 years. This jaw dropping home with architecture by Kelly Cusimano features stunning front elevation & top of the line finishes throughout. Rare 1st floor bdrm w/full bath in addition to 1st flr study! Gorgeous white marble kitchen w/stainless Wolf/Subzero appliances opens to den w/wall of floor to ceiling sliding doors for indoor/outdoor living. Enjoy al fresco dining & entertaining in incredible outdoor living area w/ fireplace, summer kitchen, grill, pool bath & pool sized yard. Huge mudroom. Port cochere. Climate controlled wine room. Gorgeous primary bdrm w/attached office, luxurious white marble bath & fab closet. Additional 3 secondary bdrms up w/ensuite baths plus separate qtrs. Great 2nd floor gameroom. 3rd floor bonus room w/full bath. Elevator capable to all 3 floors. All per Seller.','','17','Georgetown Capital','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Other Disclosures','1','Gas Connections,Gaslog Fireplace,Wood Burning Fireplace','2','West University/Southside Area','Zoned','0','LT 24 BLK 6 SOUTHSIDE PLACE','Subdivision Lot','11250','Appraisal District','','','1','To Be Built/Under Construction','2','Convection Oven,Double Oven','0','','','Gas Range','','Composition','27 - Houston','WEST UNIVERSITY ELEMENTARY SCHOOL','LAMAR HIGH SCHOOL (HOUSTON)','PERSHING MIDDLE SCHOOL','Accompany,Appointment Required','Builder','3','Contemporary/Modern,Traditional','Southside Place','','','Public Sewer,Public Water','2023','Builder'); --> New record created successfully
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','215366115','1675087946','215366115','2022-12-06T09:23:49.223','92131811','Bradley Tiffan','Legend Home Corporation','','','29.502275','-95.446762','47','77583','9','323990.00','Active','Brooklyn Rose','5623','Drive','Rosharon','2','1','4','2628','Single-Family','Love where you live in Charleston Heights in Rosharon, TX! Conveniently located off Highway 6 near 288, Charleston Heights makes commuting a breeze! The Poole floor plan is a spacious two-story home with 4 bedrooms, 2.5 baths, game room, media room, and 2-car garage. This home has it all, including vinyl plank flooring, a cul-de-sac street, and no back neighbors! The gourmet kitchen is sure to please with tons of COUNTER SPACE, 42\" cabinets, and granite countertops! Enjoy the privacy and convenience of having the Owner\'s Suite on the first floor! Retreat to the Owner\'s Suite featuring a separate tub and shower and spacious walk-in closet. Enjoy the great outdoors with a covered patio! Don’t miss your opportunity to call Charleston Heights home, schedule a visit today!','','38','Legend Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','0','Missouri City Area','Central Gas','1','Lot 35 Block 3','Subdivision Lot','5625','Survey','','450','1','Never Lived In','2','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Cooktop','','Composition','19 - Fort Bend','HERITAGE ROSE ELEMENTARY SCHOOL','RIDGE POINT HIGH SCHOOL','BAINES MIDDLE SCHOOL','Accompany,Appointment Required,No Supra Keybox','Builder','2','Traditional','Charleston Heights','','3.26','Water District','2022','Builder'); --> New record created successfully
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','215366429','1675087946','215366429','2022-12-06T09:27:42.933','48863413','Bradley Tiffan','Legend Home Corporation','','','30.050714','-95.360308','44','77373','6','289990.00','Active','Montague','23511','Drive','Spring','2','1','4','2093','Single-Family','Love where you live in Cypresswood Landing in Spring, TX! Conveniently located with easy access to Grand Parkway, I-45, FM 1960, and I-69 - commuting to the Energy Corridor, The Woodlands, or Bush Intercontinental Airport is a breeze! The Payton floor plan is a spacious 2-story home with 4 bedrooms, 2.5 baths, game room, and 2-car garage. This home has it all, including vinyl plank flooring AND NOBACK NEIGHBORS! The first floor offers the perfect space for entertaining with a large galley-style kitchen open to both the living and dining areas! The gourmet kitchen is sure to please with 42\" cabinetry, granite countertops, and stainless steel appliances! Retreat to the first-floor Owner\'s Suite featuring a separate tub and shower and walk-in closet! Enjoy the great outdoors with a covered patio! Don\'t miss your opportunity to call Cypresswood Landing home, schedule a visit today!','','12','LEGEND HOMES','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Spring East','Central Gas','1','Lot 32 BLK. 2 CYPRESSWOOD LANDING SEC. 3','Subdivision Lot','4400','Survey','','450','1','Never Lived In','2','Gas Oven','0','','','Gas Range','','Composition','48 - Spring','CHET BURCHETT ELEMENTARY SCHOOL','SPRING HIGH SCHOOL','DUEITT MIDDLE SCHOOL','Accompany,Appointment Required,No Supra Keybox','Builder','2','Traditional','Cypresswood Landing','','2.61','Water District','2022','Builder'); --> New record created successfully
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','215369506','1675087946','215369506','2022-12-06T10:40:56.140','20996522','Bradley Tiffan','Legend Home Corporation','','','29.502475','-95.446714','44','77583','9','310990.00','Active','Brooklyn Rose','5619','Drive','Rosharon','2','1','4','2248','Single-Family','Love where you live in Charleston Heights in Rosharon, TX! Conveniently located off Highway 6 near 288, Charleston Heights makes commuting a breeze! The Ellington floor plan is a spacious 2-story home with 4 bedrooms, 2.5 bathrooms, game room, and 2-car garage. Complete with a STUDY and tray ceilings for some dramatic flair! The gourmet kitchen is sure to please with 42 inch cabinetry and granite countertops. Retreat to the Owner\'s Suite featuring a separate tub and shower and spacious walk-in closet! Secondary bedrooms have walk-in closets, too! Enjoy the great outdoors with a covered patio! Don\'t miss your opportunity to call Charleston Heights home, schedule a visit today!','','38','Legend Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','0','Missouri City Area','Central Gas','1','Lot 36 Block 3','Subdivision Lot','5625','Survey','','450','1','Never Lived In','2','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Cooktop','','Composition','19 - Fort Bend','HERITAGE ROSE ELEMENTARY SCHOOL','RIDGE POINT HIGH SCHOOL','BAINES MIDDLE SCHOOL','Accompany,Appointment Required,No Supra Keybox','Builder','2','Traditional','Charleston Heights','','3.26','Water District','2022','Builder'); --> New record created successfully