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-20T13:15:46.237' ,`MLSNumber` = '47551938' ,`ListAgentFullName` = 'Tiffanie Purvis' ,`ListOfficeName` = 'Texas Real Estate & Co' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.732376' ,`Longitude` = '-95.393808' ,`PhotoCount` = '34' ,`PostalCode` = '77006' ,`RoomCount` = '11' ,`ListPrice` = '570000.00' ,`Status` = 'Active' ,`StreetName` = 'Mount Vernon' ,`StreetNumber` = '4506' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2427' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Contemporary, single-family home on a quiet street in the ever-popular Montrose Area. Currently, an Investment Income Producing property on Airbnb & Vrbo, & attracts professional long-term tenants. A perfect homestead if interested in participating in a Vanguard program. As you enter this home, you will find the 1st floor roomy bedroom w/ full bath. Spacious dining/living open concept has hardwood flooring & opens up to a balcony. Quartz, stainless steel, wine cooler & oversized island. Abundance of natural light, large glass-encased shower/soaking tub/spacious walk-in closet w/ built-ins in Primary. Enjoy the beautiful sunsets/view of downtown on roof deck. Impeccable location- offers the ability to walk to cafés/restaurants/bars, shopping, parks/jogging trails & is minutes to Midtown/Upper Kirby/Washington Corridor/Downtown/Heights + close to the stadiums/museums & minutes to Allen Parkway/610/45/59/288. Ask about purchasing Turnkey w/ furniture, kitchenware, toiletries & bedding.' ,`Acres` = '0.0376' ,`Area` = '16' ,`BuilderName` = 'Neoteric' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Montrose' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 MOUNT VERNON STREET LANDING' ,`LotDesciption` = 'Other' ,`LotSize` = '1594' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'POE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '4' ,`Style` = 'Traditional' ,`Subdivision` = 'Mount Vernon Street Lndg' ,`TaxAmount` = '11610' ,`TaxRate` = '2.4216' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675093556' WHERE `Matrix_Unique_ID` = '210165381' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-20T14:57:21.263' ,`MLSNumber` = '7755242' ,`ListAgentFullName` = 'Kaye Kaye Smith' ,`ListOfficeName` = 'Legacy Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.529057' ,`Longitude` = '-94.108587' ,`PhotoCount` = '23' ,`PostalCode` = '75972' ,`RoomCount` = '4' ,`ListPrice` = '115000.00' ,`Status` = 'Active' ,`StreetName` = 'East Main Street' ,`StreetNumber` = '214' ,`StreetSuffix` = '' ,`City` = 'San Augustine' ,`BathsFull` = '0' ,`BathsHalf` = '2' ,`BedsTotal` = '2' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GREAT location for residential or business on Main St. in San Augustine. This is a corner lot and was previously used as a dental office. Building has central heat/air, waiting room, reception area, lab, 2 operatories, office and a break room but can easily be converted for residential purposes.' ,`Acres` = '' ,`Area` = '78' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PT LOT 216 BLK 30 SAN AUGUSTINE AND IMPROVEMENT' ,`LotDesciption` = 'Corner' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '241 - San Augustine' ,`SchoolElementary` = 'SAN AUGUSTINE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SAN AUGUSTINE HIGH SCHOOL' ,`SchoolMiddle` = 'SAN AUGUSTINE HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'NONE' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '0' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093556' WHERE `Matrix_Unique_ID` = '213160620' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-20T14:25:44.997' ,`MLSNumber` = '42185953' ,`ListAgentFullName` = 'Isaiah Hinojosa' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.157736' ,`Longitude` = '-94.737247' ,`PhotoCount` = '31' ,`PostalCode` = '77575' ,`RoomCount` = '3' ,`ListPrice` = '160000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 2356' ,`StreetNumber` = '175' ,`StreetSuffix` = '' ,`City` = 'Hardin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1875' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home has many updates already but still needs some work. Foundation, Plumbing, Electrical all have been redone, Entire ac and heating is brand new. New recess lighting throughout. With the right touch this beautiful house will come to life.A little shy of an acre you will have plenty of room.The 70x50 shop with new plumbing and electric is also a big bonus. Schedule your private showing today.' ,`Acres` = '0.9125' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Liberty County East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LEXIE-5.89 AC, LOT 5 6, PT 7, ACRES 0.9125' ,`LotDesciption` = 'Cleared' ,`LotSize` = '39749' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '107 - Hardin' ,`SchoolElementary` = 'HARDIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARDIN HIGH SCHOOL' ,`SchoolMiddle` = 'HARDIN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Lexie-589 Ac' ,`TaxAmount` = '3769' ,`TaxRate` = '2.1438' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093556' WHERE `Matrix_Unique_ID` = '213646977' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-20T13:10:43.603' ,`MLSNumber` = '39267494' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.724519' ,`Longitude` = '-95.937958' ,`PhotoCount` = '7' ,`PostalCode` = '77423' ,`RoomCount` = '11' ,`ListPrice` = '430000.00' ,`Status` = 'Active' ,`StreetName` = 'Franklin Brooks' ,`StreetNumber` = '32914' ,`StreetSuffix` = 'Drive' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2821' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2 Story, The Bristol Floor Plan with 4 Bedrooms, 3 Baths, with a 2 CAR GARAGE. This floor plan boasts a SPACIOUS OPEN CONCEPT FLOOR PLAN with the Family Room w/Gas Log Fireplace, Kitchen, Breakfast Room, Dining Room, and the Study/Flex Space downstairs, along with a full bath. Upstairs you will find a Game Room, Primary Bedroom with ensuite Full Bath, 2 Bedrooms, and another Full Bath. You will love the Kitchen with lots of cabinets with under the cabinet lighting, Granite countertops, SS appliances, and even a USB outlet. COVERED Patio, with fenced backyard. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Wifi Programmable Thermostat, PEX Hot & Cold Water Lines, Radiant Barrier, Rheem® Tankless Gas Water Heater, and Vinyl Double Pane Low E Windows that open to the inside of the home for Cleaning. A scenic overlook greets visitors as soon as they drive in, revealing a lakeside view that gives way to an open-air pavilion and amenity center.' ,`Acres` = '0.1667' ,`Area` = '30' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'VANBROOKE SEC 2, BLOCK 1, LOT 86' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7260' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Vanbrooke' ,`TaxAmount` = '2082' ,`TaxRate` = '3.2948' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675093557' WHERE `Matrix_Unique_ID` = '213812850' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-20T13:04:52.070' ,`MLSNumber` = '15323648' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.724369' ,`Longitude` = '-95.938630' ,`PhotoCount` = '7' ,`PostalCode` = '77423' ,`RoomCount` = '11' ,`ListPrice` = '462000.00' ,`Status` = 'Active' ,`StreetName` = 'Franklin Brooks' ,`StreetNumber` = '32930' ,`StreetSuffix` = 'Drive' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2980' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to your beautiful Morton floor Plan with 5 Bedroom, 3 1/2 Bath, with a 2 Car Garage. This floor plan boasts a SPACIOUS OPEN CONCEPT FLOOR PLAN with the Family Room with direct vent Gas Log Fireplace, Kitchen, Breakfast Room, Dining Room, Study, and the Master Bedroom downstairs. Upstairs you will find 4 Bedrooms which 1 Bedroom has an ensuite bath and another full Bath that has 2 sinks. Tile and Carpet throughout. Comes with COVERED PATIO and fenced backyard. Blinds throughout and front gutters. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Thermostat, Pex Hot & Cold Water Lines, Radiant Barrier, Rheem® Tankless Gas Water Heater, and Vinyl Double Pane Low E Windows that open to the inside of the home for cleaning. A scenic overlook greets visitors as soon as they drive in, revealing a lakeside view that gives way to an open-air pavilion and amenity center. Amenities include RESORT-STYLE SWIMMING POOL! SPLASHPAD! CHILDREN’S PLAYGROUND!' ,`Acres` = '0.1667' ,`Area` = '30' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'VANBROOKE SEC 2, BLOCK 1, LOT 90' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7260' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Vanbrooke' ,`TaxAmount` = '2082' ,`TaxRate` = '3.2948' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675093557' WHERE `Matrix_Unique_ID` = '213812925' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-20T13:33:33.947' ,`MLSNumber` = '7094820' ,`ListAgentFullName` = 'Blake Levy' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.411401' ,`Longitude` = '-95.051479' ,`PhotoCount` = '33' ,`PostalCode` = '77568' ,`RoomCount` = '6' ,`ListPrice` = '439900.00' ,`Status` = 'Active' ,`StreetName` = 'Jetty Ridge' ,`StreetNumber` = '12624' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2378' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new oasis! Completed 2021 this smart home boast high ceilings, lots of natural light, and ample amount of storage. Multiple additions and updates were made after the completion of construction. Seller had wooden shutters installed on all windows, removed and replaced original light and fan fixtures throughout home with upgraded models, custom cabinets and shelves installed in primary bathroom, primary and hall closets, and front bedroom. All lower kitchen cabinets redesigned with slide out drawers making storage and access easier! Back-patio recently built and Astroturf installed giving the back yard a beautiful and clean look with little maintenance! This 3 bed-2 bath home with 3 car tandem is ready to call yours. Located next to the popular Lago Mar Lagoon/pool, this home is a short trip to Galveston Island or downtown Houston. Short proximity to malls and stores, wide selection of restaurants, parks, boat ramps, and more! Call to schedule your showing today!' ,`Acres` = '0.1722' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 13 BLK 3 LAGO MAR POD 6 SEC 1 (2020) ABST 11' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1730' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric 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,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Lago Mar Sec 1 Pod 6' ,`TaxAmount` = '13643' ,`TaxRate` = '3.5512' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093557' WHERE `Matrix_Unique_ID` = '213936027' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-20T14:41:16.197' ,`MLSNumber` = '91630351' ,`ListAgentFullName` = 'Edna Pena' ,`ListOfficeName` = 'RE/MAX 5 Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.944897' ,`Longitude` = '-95.130556' ,`PhotoCount` = '29' ,`PostalCode` = '77532' ,`RoomCount` = '8' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Lake Breeze' ,`StreetNumber` = '2942' ,`StreetSuffix` = 'Lane' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2268' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Custom built new construction in coveted Lake Shadows! Welcome to lake living this 1 story home features a brick & stone exterior with a covered front porch. 3 bed, 2.5 bath, 2 car garage with 10 ft ceilings. Plus a bonus study/office & Game Room that could be a fourth bedroom. Upon entering you\'re greeted by soaring 10 ft. ceilings throughout home including garage perfect for your pickup truck. Open concept leads to elegant kitchen and dining room. This layout features large family room that leads to an open kitchen. This Chef\'s kitchen features all soft-close 42\"cabinets, quartz counter tops w large breakfast island perfect for gatherings. Kitchen includes SS appliances, gas stove, dishwasher, mounted microwave. Retreat to primary suite with SPA like bath. Primary bedroom suite has dual sinks, soaking tub, super-size walk in shower w dual shower heads. Covered patio area. Walking distance or short golf cart drive to the subdivision\'s lake access.' ,`Acres` = '0.2089' ,`Area` = '1' ,`BuilderName` = 'Private Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 7 LAKE SHADOWS SEC 5' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '9100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'NEWPORT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Shadows Sec 05' ,`TaxAmount` = '682' ,`TaxRate` = '2.6843' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675093557' WHERE `Matrix_Unique_ID` = '214372655' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-20T13:16:15.640' ,`MLSNumber` = '53437744' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.722765' ,`Longitude` = '-95.939493' ,`PhotoCount` = '8' ,`PostalCode` = '77423' ,`RoomCount` = '9' ,`ListPrice` = '426117.00' ,`Status` = 'Active' ,`StreetName` = 'Silver Meadow' ,`StreetNumber` = '32962' ,`StreetSuffix` = 'Way' ,`City` = 'Fulshear' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2541' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to the beautiful 2 Story, The Donnington floor Plan with 4 Bedrooms, 2 1/2 Baths, with attached 2 Car Garage. This floor plan boasts a Spacious OPEN CONCEPT FLOOR PLAN with the Family Room, Kitchen and Dining Room, Study/Flex Space, and a Master Bedroom with his and her closets downstairs. Upstairs you will find a Game Room, 3 Bedrooms with another full bath. Tile and Carpet throughout. Fenced backyard. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Thermostat, Pex Hot & Cold Water Lines, Radiant Barrier, Rheem® Whole House Tankless Gas Water Heater, and Vinyl Double Pane Low E Windows that open to the inside of the home for cleaning. A scenic overlook greets visitors as soon as they drive in, revealing a lakeside view that gives way to an open-air pavilion and amenity center. Amenities include RESORT-STYLE SWIMMING POOL! SPLASHPAD! CHILDREN’S PLAYGROUND! Convenient to I-10, TX Hwy 359, and Westpark Tollway. Lamar CISD!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NA' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Vanbrooke' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675093558' WHERE `Matrix_Unique_ID` = '214827611' --> 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','215191148','1675093558','215191148','2022-12-20T14:42:20.997','68745386','Maggie Martinez','Compass RE Texas, LLC','','','28.952781','-95.350629','20','77541','4','189900.00','Active','1st','418','Street','Freeport','2','0','4','1735','Single-Family','With easy access to Freeport Beach, Surfside Beach and in close proximity to Brazos River this charming ranch-style single story home has ben generously updated all throughout. There have been several recent improvements to the home including all windows framed & painted inside & out including new cabinets which also have new hardware, new kitchen sink, all plumbing has been redone with PEX, new water heater, new stainless appliances, all ceiling fans & light fixtures replaced. Schedule your showings now!','0.1607','5','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Freeport','Central Electric','0','FREEPORT BLK 63 LOT 13','Cleared','7000','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Range','','Composition','7 - Brazosport','VELASCO ELEMENTARY SCHOOL','BRAZOSPORT HIGH SCHOOL','FREEPORT INTERMEDIATE SCHOOL','Appointment Required,Lockbox Front','Appraisal','1','Ranch','Freeport','3496','2.5981','Water District','1945','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','215393557','1675093558','215393557','2022-12-20T14:51:23.160','84656574','Marjorie Lucero','RE/MAX Grand','','','29.860483','-95.686219','39','77449','3','259000.00','Active','Wesley Manor','6031','Court','Katy','2','1','3','1772','Single-Family','Charming 3 bedroom, 2.5 bathroom home is now on the market! The kitchen is equipped with granite countertops, tile backsplash, ample cabinets, and a breakfast bar. Discover a bright interior w/ neutral tile floors and plush carpet in all the right places. Relax in your primary suite, complete with a walk-in closet, and an en suite bathroom with double sinks. Relax with your favorite drink in the fenced in backyard with lush grass, and great potential for adding personal touches. Hurry to see it won\'t last long! This home has been virtually staged to illustrate its potential.','0.0574','25','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Bear Creek South','Central Gas','1','LT 70 BLK 1 BRENWOOD MANOR T/H','Subdivision Lot','2500','Survey','','1100','0','','2','','0','','','Gas Range','','Composition','13 - Cypress-Fairbanks','SHERIDAN ELEMENTARY SCHOOL','CYPRESS LAKES HIGH SCHOOL','WATKINS MIDDLE SCHOOL','Appointment Required,Supra Keybox','Builder','2','Traditional','Brenwood Manor Town Homes','5211','2.641','Water District','2017','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','215715355','1675093558','215715355','2022-12-20T13:22:08.940','62869048','Phillip Collins','eXp Realty, LLC','','','29.782610','-95.390922','42','77007','4','700000.00','Active','E 6th 1/2','619','Street','Houston','1','0','4','1354','Single-Family','Come see this home which is 4 bedroom on a lot that is 6750 sqft and is perfect for you to build your dream home. This property is in the heart of the Heights. The heights walking trail and many restaurants are very close and within walking distance. Many new builds are being built on this street and all around this property.','0.155','9','','','','','Sellers Disclosure','','','','Heights/Greater Heights','Window Unit','0','TR 15 TAYLOR E A TRACT ABST 1 J AUSTIN','Subdivision Lot','6750','Appraisal District','','','0','','','','0','','','','','Composition','27 - Houston','HARVARD ELEMENTARY SCHOOL','HEIGHTS HIGH SCHOOL','HOGG MIDDLE SCHOOL (HOUSTON)','Supra Keybox','Appraisal District','1','Ranch','HEIGHTS/GREATER HEIGHTS','13983','2.3307','Public Sewer,Public Water','1910','Appraisal District'); --> New record created successfully