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-10-01T05:01:59.173' ,`MLSNumber` = '76288148' ,`ListAgentFullName` = 'Gary Bailey' ,`ListOfficeName` = 'Gary S. Bailey' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.004217' ,`Longitude` = '-95.478402' ,`PhotoCount` = '46' ,`PostalCode` = '77068' ,`RoomCount` = '11' ,`ListPrice` = '665000.00' ,`Status` = 'Active' ,`StreetName` = 'Villa Fontana Way' ,`StreetNumber` = '16139' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3732' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Superb Luxury Golf Course Patio Home on Large Lot with Excellent Water and Golf Course Views! Gated Entry. Two Bedrooms Downstairs, and Two Bedrooms Upstairs, each with full baths. Kitchen Open to the den for family gathering and entertaining. Breakfast Area with views of the Golf Course and ponds create the perfect setting for a relaxing morning breakfast. Raised Study on Stairway has privacy- easy access.Second Bedroom on First Floor is tucked away and has an entry from the outside and via the garage for a quite, private and easy access.Flooring is a combination of Travertine and beautiful Engineered Wood! Gameroom Upstairs has a covered Balcony and plenty of room outside to view the Golf Course and Distant Golfers trying to avoid the scenic Water Ponds. Back Yard Bar B Que with a sizeable play area and covered patio for outdoor grilling. Excellent home for relaxation and backyard enjoyment. Room for swimming pool(All Measurements Not Exact).' ,`Acres` = '' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 19 Block 1 Northgate Forest Place' ,`LotDesciption` = 'In Golf Course Community,On Golf Course,Patio Lot,Subdivision Lot' ,`LotSize` = '9596' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3680' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PAT REYNOLDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Northgate Forest' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664652954' WHERE `Matrix_Unique_ID` = '206304508' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T05:44:51.820' ,`MLSNumber` = '41263688' ,`ListAgentFullName` = 'Wendy Cline' ,`ListOfficeName` = 'Wendy Cline Properties Group' ,`SellingAgentFullName` = 'Jose Padron' ,`SellingOfficeName` = '1st Class RE Luxury Living,LLC' ,`Latitude` = '29.927908' ,`Longitude` = '-95.484246' ,`PhotoCount` = '24' ,`PostalCode` = '77086' ,`RoomCount` = '8' ,`ListPrice` = '165000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Jillana Kaye' ,`StreetNumber` = '10335' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1484' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for an affordable home that has everything your family needs in a great location? Look no further! This Charming well kept 1 Story Home offers 3 spacious Bedrooms, 2 full Baths with a 2 Car Garage located within the Northwest Park subdivision. Amazing amenities of the neighborhood include public pool, playground, tennis courts and walking trails. Call to schedule your appointment. It won\'t last long! Conveniently located by Beltway 8 and Hwy 249. Zoned to Aldine ISD. ** Home is part of an Estate Sale & is Now Vacant ** SCHEDULE A SHOWING TODAY!' ,`Acres` = '0.1616' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Mud,Other Disclosures,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 27 BLK 12 NORTHWEST PARK SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7040' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '380' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CARMICHAEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAVIS HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'SHOTWELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Northwest Park Sec 02' ,`TaxAmount` = '3465' ,`TaxRate` = '2.4283' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664652954' WHERE `Matrix_Unique_ID` = '207226712' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T05:36:55.663' ,`MLSNumber` = '10840049' ,`ListAgentFullName` = 'Andrea Joseph' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.764144' ,`Longitude` = '-95.467982' ,`PhotoCount` = '49' ,`PostalCode` = '77056' ,`RoomCount` = '9' ,`ListPrice` = '2694899.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Forest' ,`StreetNumber` = '5203' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '5088' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully situated on an 16,000+ square foot corner lot in Bayou Bend / Tanglewood, you\'ll discover this gorgeous modern farm house inspired residence featuring 4 bedrooms, 5 baths and an enormous yard with a beautiful covered porch and lush lawn. Hardwood floors, high ceilings, weathered brick wine room. The casual elegance of the family room features a large fireplace and an abundance of light. Granite kitchen, Butler\'s Pantry + delightful breakfast room. Main floor primary bedroom offers space for a king-size bed cozy fire place and exquisite ensuite bathroom. Office or home gym space adjacent to the primary bed. The 4th bedroom is ideal for a teenager, visiting relative or live -in nanny. Game room or secondary living space upstairs. Unfinished suite above the garage is plumbed and ready you to make it your own. Outstanding public and private schools. Minutes to Galleria, Whole Foods, and easy access to I-610. Please click the film reel above the listing pic for virtual tour!' ,`Acres` = '0.3857' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Tanglewood Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 1 BAYOU GLEN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '16800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bayou Glen' ,`TaxAmount` = '61832' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664652954' WHERE `Matrix_Unique_ID` = '209898213' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T04:25:55.070' ,`MLSNumber` = '18904572' ,`ListAgentFullName` = 'Winnie Stearns' ,`ListOfficeName` = 'Stearns Property Company, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.786281' ,`Longitude` = '-95.189132' ,`PhotoCount` = '16' ,`PostalCode` = '77015' ,`RoomCount` = '5' ,`ListPrice` = '179900.00' ,`Status` = 'Active' ,`StreetName` = 'Halifax' ,`StreetNumber` = '13343' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '991' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Never Flooded! Security gated! Remodeled! Hurry! Great 2 or 3-1-1. Don\'t worry about your roof in storms. Seller put on Metal roof. New granite countertop, new HVAC system. Stainless DW, gas range. New laminate flooring in 2 bedrooms. Beautiful hardwood floors in living room. Great area close to shopping. Galina Park Schools. Large totally fenced lot with double gates to driveway. You can lock your cars behind gates! Another 12.5X6.5 room that could be 3rd bedroom or den. Wonderful large fenced back yard!' ,`Acres` = '0.186' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Home Protection Plan,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 804 BLK 28 HOME OWNED ESTATES SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'GREEN VALLEY ELEMENTARY SCHOOL (GALENA PARK)' ,`SchoolHigh` = 'NORTH SHORE SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'CUNNINGHAM MIDDLE SCHOOL (GALENA PARK)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Home Owned Estates Sec 02' ,`TaxAmount` = '2668' ,`TaxRate` = '2.7702' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1952' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664652954' WHERE `Matrix_Unique_ID` = '210373687' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T05:30:43.407' ,`MLSNumber` = '33777075' ,`ListAgentFullName` = 'Miguel Rosales' ,`ListOfficeName` = 'Miguel A. Rosales, REALTOR ' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.964145' ,`Longitude` = '-95.294403' ,`PhotoCount` = '17' ,`PostalCode` = '77396' ,`RoomCount` = '6' ,`ListPrice` = '214900.00' ,`Status` = 'Active' ,`StreetName` = 'Stapley' ,`StreetNumber` = '16719' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1232' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 3 bedroom 2 bath home is in excellent condition with many recent updates. Updates include flooring, paint, bathrooms, kitchen and attached covered patio/deck. Great location with easy access to downtown, sports venues, airport and more.' ,`Acres` = '0.1621' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 5 HEATHER RIDGE VILLAGE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7061' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'FRANCIS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Accompany,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Heather Ridge Village Sec 01' ,`TaxAmount` = '3221' ,`TaxRate` = '2.5119' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664652955' WHERE `Matrix_Unique_ID` = '210640683' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T05:08:55.127' ,`MLSNumber` = '25083340' ,`ListAgentFullName` = 'Dulce Davis' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.247236' ,`Longitude` = '-95.234629' ,`PhotoCount` = '31' ,`PostalCode` = '77577' ,`RoomCount` = '5' ,`ListPrice` = '279000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 776' ,`StreetNumber` = '215' ,`StreetSuffix` = '' ,`City` = 'Liverpool' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1430' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Renovated home with tons of perks! Sqr ftg is 1430 per professionally created floor plan. Main living area upstairs with beautiful water views of Chocolate Bayou. 2 bedrooms up and 1 bedroom down. Short list of updates: Paint, 2718 sqr ft of concrete, Granite in kitch/bath up, Luxury Vinyl Planking, Porcelain shower surrnd, LED Fans/lights, etc...Other amenities: Cvr deck up 734sqr ft, plus lg cvrd patio on side yard. Fully Cvrd driveway for 8 car parking with 51 ft uncvrd parking. Approx 33x13ft cvrd concrete pad behind home. Overszd 4 car garage spaces. One with workbench separated by cinderblock wall. Water softener, Generac generator w/dedicated propane tank. Half bath down is only toilet with ability to reinstate shower. The Gulf is 5-10 minutes by boat. Multiple boat launches within 2 minutes. This home is water VIEW, no direct access on the property itself. Lutes Marina basically at end of street where you input your boat. Ask for Full About Me Booklet!' ,`Acres` = '0.3444' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'HARBORVIEW HOMESITES (A0011 HENRY AUSTIN), LOT 8-9 SEC 1' ,`LotDesciption` = 'Cleared,Water View' ,`LotSize` = '15002' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'WALT DISNEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'ALVIN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Harborview Homesites' ,`TaxAmount` = '1963' ,`TaxRate` = '2.2507' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664652955' WHERE `Matrix_Unique_ID` = '211521050' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T05:53:23.367' ,`MLSNumber` = '25230852' ,`ListAgentFullName` = 'Mindy Buivantri' ,`ListOfficeName` = 'Hometown America Incorporated' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.764111' ,`Longitude` = '-94.951092' ,`PhotoCount` = '28' ,`PostalCode` = '77521' ,`RoomCount` = '14' ,`ListPrice` = '309000.00' ,`Status` = 'Active' ,`StreetName` = 'Jeanie' ,`StreetNumber` = '1201' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2780' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This newly renovated home in a quiet cul-de-sac located in the Knight C A subdivision. Situated on 8,890 sq.ft., est. GLA w/dimension floor plan 2747 sq.ft. This home features 5 bdrm/2.1 bath, study room, fireplace, new (roof, appliances, flooring, back fence, renovated kitchen and bathrooms and more)' ,`Acres` = '0.2041' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 WRIGHT C A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8890' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'CEDAR BAYOU J H' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wright C A' ,`TaxAmount` = '7234' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664652955' WHERE `Matrix_Unique_ID` = '211888918' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T05:56:56.167' ,`MLSNumber` = '10414913' ,`ListAgentFullName` = 'Maynor Vega' ,`ListOfficeName` = 'Pivot Up Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.817702' ,`Longitude` = '-95.386340' ,`PhotoCount` = '39' ,`PostalCode` = '77022' ,`RoomCount` = '3' ,`ListPrice` = '495000.00' ,`Status` = 'Active' ,`StreetName` = 'Europa Street' ,`StreetNumber` = '3422' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this lovely 2-story BRAND NEW construction. This is your chance to be the first person to live in this meticulously designed home. \r\n\r\nIt is full of luxurious amenities. Kitchen includes quartz countertops, a mosaic tile backsplash & custom shelving. Features include a pot filler, slide-in natural range, wall mounted range hood, farmhouse kitchen sink, stainless-steel appliances & pantry.\r\n\r\nThe gorgeous living room includes a bar with dual-zone cooler, and electric fireplace decorated by a unique white wave tile design. Upstairs are solid white oak steps leading to classy bedrooms and spa-like bathrooms. The luxury bathrooms feature frameless glass door on both showers. The master bathroom is a true treat, including Italian tile, a free-standing tub, rain shower head, wall-mounted vanity and LED mirrors. Home is prewired for all cable services, plus a ring doorbell. \r\n\r\nCome shine bright in the heart of Houston, close to The Heights, 610, I-45, & minutes away from Downtown.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'MEVS Bldg & Const' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 24 BLK 12' ,`LotDesciption` = 'Cleared' ,`LotSize` = '3000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BURRUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'LINCOLN HEIGHTS' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664652955' WHERE `Matrix_Unique_ID` = '211892900' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T05:48:58.920' ,`MLSNumber` = '55998825' ,`ListAgentFullName` = 'Tina Murphy' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.213895' ,`Longitude` = '-95.590530' ,`PhotoCount` = '34' ,`PostalCode` = '77354' ,`RoomCount` = '5' ,`ListPrice` = '389900.00' ,`Status` = 'Active' ,`StreetName` = 'Cimarron Canyon' ,`StreetNumber` = '10088' ,`StreetSuffix` = 'Lane' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2487' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'STOP THE CAR! You will be glad you did. Lovely 1 story KB home will not disappoint.With a Split floor plan you will enjoy your Primary retreat in the back of the home while the front of the home has separate hall with 2 bedrooms and bathroom. You will be greeted with high ceilings in foyer and wide hall leading to back of home.Easy to maintain LVP flooring in main areas.Granite countertops in kitchen with large eat at bar for 6 and 42\" black cabinets, SS appliances. You\'ll love the lighting from Fredricksburg,TX. Primary bath boast dual granite vanities, toilet closet, separate shower/tub.Primary closet has plenty of Space and custom shelving.Formal dinning is large enough to seat 12!(drumset not included) Office delights with double doors for privacy,cat 5 cable.Could be 4th bdrm with armoire.250sqft covered back porch has cat 5 cable and gas connection for grill.Close to The Woodlands shops,medical & entertainment.Fishing pond has bass, trails & community has nice pool. WELCOME HOME' ,`Acres` = '0.1683' ,`Area` = '15' ,`BuilderName` = 'KB HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S341103 - CIMARRON CREEK 03, BLOCK 2, LOT 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7330' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '965' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'BEAR BRANCH ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cimarron Creek 03' ,`TaxAmount` = '8144' ,`TaxRate` = '3.1887' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664652955' WHERE `Matrix_Unique_ID` = '212278272' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T05:38:12.260' ,`MLSNumber` = '11422961' ,`ListAgentFullName` = 'Wendy Cline' ,`ListOfficeName` = 'Wendy Cline Properties Group' ,`SellingAgentFullName` = 'Monita Armstrong' ,`SellingOfficeName` = 'Connect Realty' ,`Latitude` = '30.004915' ,`Longitude` = '-95.557509' ,`PhotoCount` = '27' ,`PostalCode` = '77379' ,`RoomCount` = '10' ,`ListPrice` = '240000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Grovetrail' ,`StreetNumber` = '16710' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1553' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don’t miss out on this Charming 3 Bedroom, 2 Bathroom Home that’s Ready for Immediate Move-In! This 1 Story Brick Home is located within the Champions Trail community offering a spacious layout with a split floor plan! Features Include: Open Living Room with a cozy gas log fireplace, a formal dining room, an Island Kitchen with Granite counters, upgraded lighting and plenty of cabinet space. The Primary suite has its own private access out to the patio, plus it has a large soaking tub, double sinks and a separate shower. The secondary bedrooms are roomy & spacious too! Relax or entertain family & friends out back under the Pergola covered patio! The outdoor kitchen just needs your personal touch to complete! Zoned to Klein ISD! Buyer will need to purchase a New Survey. Conveniently located within 5 minutes of Vintage Park, Retail Shopping, Dining, Entertainment, ALDI\'s, HEB & Whole Foods. Hurry, this will not be around long!' ,`Acres` = '0.132' ,`Area` = '13' ,`BuilderName` = 'RYLAND HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 2 CHAMPIONS TRAIL' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '525' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KRAHN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Champions Trail' ,`TaxAmount` = '4610' ,`TaxRate` = '2.3266' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664652955' WHERE `Matrix_Unique_ID` = '212723649' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T05:19:16.530' ,`MLSNumber` = '18311322' ,`ListAgentFullName` = 'Juan Monico' ,`ListOfficeName` = 'Sierra Vista Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.818420' ,`Longitude` = '-95.549964' ,`PhotoCount` = '14' ,`PostalCode` = '77043' ,`RoomCount` = '3' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'Westray' ,`StreetNumber` = '10410' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1470' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Completely redesigned home in Spring Branch. This three bedroom and two full bath home features an open floor plan with luxury wide plank vinyl, exterior and interior paint, new lighting fixtures and hardware. Gorgeous renovated kitchen with brand new shaker cabinets, Calacatta quartz counters and backsplash, new stainless steal appliances and LED recessed lighting. New HVAC system & ductwork, new double pane windows, new 40 gallon water heater, 30 year roof shingle, new fence, Zoned to Spring Branch ISD and conveniently located near I-10, Beltway 8, City Center, Memorial City and numerous restaurants.' ,`Acres` = '0.1787' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 5 MAC GREGOR WEST' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7786' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'TERRACE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING OAKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mac Gregor West' ,`TaxAmount` = '5904' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664652956' WHERE `Matrix_Unique_ID` = '212950473' --> 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','213057923','1664652956','213057923','2022-10-01T04:48:35.593','55235174','Matthew Landry','Marland Interest, Inc.','','','29.754360','-95.580995','41','77077','9','469500.00','Active','Brooklake','1422','Drive','Houston','3','1','4','2616','Single-Family','Located in the heart of Lakeside Place near Lakeside Country Club. Minutes from Memorial and the Energy Corridor\r\nCorner home sits on a 12,154 square foot lot. Classic architecture has an impressive high ceilings in the family Room with crown molding and cozy fireplace. Great bones. private back yard with gated driveway. Gorgeous\r\nmagnolia tree along with pines set house off. Ready for a redo, priced accordingly.','0.279','31','','','Electric Dryer Connections,Washer Connections','','Other Disclosures','1','Gaslog Fireplace','1','Energy Corridor','Central Gas','1','LT 1 BLK 7 LAKESIDE PLACE SEC 1','Corner','12154','Appraisal District','','860','0','','2','Double Oven,Electric Oven','0','','','Electric Cooktop','','Composition','27 - Houston','ASKEW ELEMENTARY SCHOOL','WESTSIDE HIGH SCHOOL','REVERE MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','2','Traditional','Lakeside Place Sec 01','7691','2.3307','Public Sewer,Public Water','1974','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','213066758','1664652956','213066758','2022-10-01T04:11:45.253','18055484','Daniel DiPetta','Bayou City Realty, LLC','','','29.869982','-95.663338','21','77084','6','289999.00','Active','Hunterstone','6403','Court','Houston','2','0','4','2105','Single-Family','Come take a look at this freshly remodeled property tucked away in a mature neighborhood of Cypress! This property includes many upgrades which are; new roof, new AC, new flooring, new paint, new appliances, quartz counter tops, remodeled bathrooms, and many more! Schedule a showing to view before it\'s gone, guaranteed to sell!','0.1572','8','','','','','Mud,Sellers Disclosure','1','','1','Bear Creek South','Central Gas','1','LT 24 BLK 2 STONE CREEK SEC 3','Subdivision Lot','6849','Appraisal District','','400','0','','2','','0','','','','','Composition','13 - Cypress-Fairbanks','HOLMSLEY ELEMENTARY SCHOOL','LANGHAM CREEK HIGH SCHOOL','KAHLA MIDDLE SCHOOL','Lockbox Front','Appraisal District','1','Traditional','Stone Creek Sec 03','6536','3.071','Water District','1997','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T05:51:32.470' ,`MLSNumber` = '63089275' ,`ListAgentFullName` = 'Phillip Collins' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.812768' ,`Longitude` = '-95.450409' ,`PhotoCount` = '37' ,`PostalCode` = '77092' ,`RoomCount` = '7' ,`ListPrice` = '525000.00' ,`Status` = 'Active' ,`StreetName` = 'Vollmer' ,`StreetNumber` = '2811' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1537' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'come see this beautiful home in Brook Wood Estates with a pool. This beautiful home features a large open floor plan perfect for entertaining. And a pool that is great for relaxing in and around. This home is on a oversized lot. The home has double-pane windows, 2\'\' blinds through out. This home offers a detached garage with a half bath & an extra-large storage shed for all of your pool and storage needs.' ,`Acres` = '0.27' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 84 BLK 4 BROOK-WOODS ESTATES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11760' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'STEVENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Brook-Woods Estates' ,`TaxAmount` = '6636' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1952' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664652956' WHERE `Matrix_Unique_ID` = '213109185' --> 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','213182592','1664652956','213182592','2022-10-01T05:31:01.783','8144413','Patricia Fleming','Patricia Fleming Realty LLC','','','29.853218','-95.694595','29','77449','8','294800.00','Active','Esk River','5703','Trail','Katy','2','1','3','1960','Single-Family','WELCOME HOME TO YOUR \"BETTER THAN NEW\" GORGEOUS LEGEND HOME*LOCATED IN THE HIGHLY ACCLAIMED COMMUNITY OF ADELAIDE*THIS BEAUTY SITS ON A LARGE CORNER LOT & IS \"ALL DRESSED UP AND READY TO CALL HOME!\"THIS LOVELY HOME FEATURES SOLID UPSCALE VINYL PLANK FLOORING THROUGHOUT THE MAIN LIVING AREAS*ABUNDANT STORAGE TO BE FOUND INCLUDING A LARGE CLOSET TUCKED UNDER THE STAIRS*THE GOURMET KITCHEN BOASTS PLENTY OF STORAGE SPACE WITH ITS 42\" MOCHA STAINED HARD MAPLE CABINETRY*EXPANSIVE GRANITE COUNTERS W LARGE SEATING BREAKFAST BAR*STAINLESS STEEL ENERGY STAR APPLIANCES WITH A FULL SIZED GAS RANGE*SS DISHWASHER & MICROWAVE*THE OPEN KITCHEN LEADS TO THE LARGE DEN AREA W LOTS OF NATURAL LIGHT*2\" WOOD BLINDS THROUGHOUT*THE PRIMARY SUITE IS TUCKED AWAY TOWARD THE BACK OF THE HOME FOR PEACE & PRIVACY*THE ATTACHED ENSUITE BATH W ITS OVERSIZED SOAKING TUB IS A PLUS ALONG W THE SEPARATE SHOWER & LARGE WALK IN CLOSET*THE ROOMY GUEST BEDROOMS ARE FOUND UPSTAIRS*EPOXY COATED FLOOR IN THE GARAGE IS A PLUS!','0.0796','25','Legend Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Bear Creek South','Central Gas','1','LT 10 BLK 4 ADELAIDE SEC 4','Corner','3469','Appraisal District','','500','0','','2','Gas Oven','0','','','Gas Cooktop,Gas Range','','Composition','13 - Cypress-Fairbanks','SHERIDAN ELEMENTARY SCHOOL','CYPRESS LAKES HIGH SCHOOL','WATKINS MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','2','Traditional','Adelaide Sec 2','5391','2.641','Water District','2020','Appraisal District'); --> New record created successfully