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-05T14:34:08.933' ,`MLSNumber` = '43494328' ,`ListAgentFullName` = 'Gabriel Samet' ,`ListOfficeName` = 'Samet Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.800752' ,`Longitude` = '-95.363982' ,`PhotoCount` = '36' ,`PostalCode` = '77009' ,`RoomCount` = '13' ,`ListPrice` = '398000.00' ,`Status` = 'Active' ,`StreetName` = 'Averill' ,`StreetNumber` = '4501' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '1391' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great Investment Property! Long-term Residents. Fabulous location, minutes away to Downtown, Light rail, Shopping, and Restaurants. Main House with Three bedrooms and Extra room, Living Room Eat-in Kitchen on1st floor and additional room in Attic. The Large Garage Apartment is 1125sq.ft. and has 2 Bedrooms, Living Room, Kitchen and Full bath. Three Open Garage spaces. Utility Room in Main House used by all Residents. Make your appointment today!' ,`Acres` = '0.1263' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Space Heater' ,`HOAMandatory` = '0' ,`Legal` = 'LT 17 BLK 69 IRVINGTON' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOOSCAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Irvington' ,`TaxAmount` = '5519' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1935' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675087630' WHERE `Matrix_Unique_ID` = '202611551' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-05T13:14:57.343' ,`MLSNumber` = '18026547' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.495075' ,`Longitude` = '-95.810915' ,`PhotoCount` = '18' ,`PostalCode` = '77471' ,`RoomCount` = '14' ,`ListPrice` = '433736.00' ,`Status` = 'Active' ,`StreetName` = 'Fogmist' ,`StreetNumber` = '3247' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2785' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. This amazing Lake Ridge Builders home in Briarwood Crossing is what you’ve been dreaming of. Situated on a spacious lot, this 3-sided brick home boasts a prem elevation, tile flooring, 3-car garage, sprinkler system, wrought iron spindles, faux wood blinds, study with French doors, and a covered patio. Try a new recipe in the kitchen, equipped with granite countertops, stainless steel appliances, and 42” upper cabinets. Complete with dual vanities, a 42” tub, and a separate shower, the primary suite is the perfect place to unwind. Community comforts include a 5-acre park, pool, recreation area with a splash pad, and walking trails. Commuters enjoy easy access to Hwy 59 and the Grand Parkway. Schools are zoned to the highly-acclaimed Lamar Consolidated ISD. Don’t wait – call today!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '533' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CULVER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Briarwood Crossing' ,`TaxAmount` = '' ,`TaxRate` = '3.47' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675087630' WHERE `Matrix_Unique_ID` = '208746192' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-05T14:07:53.817' ,`MLSNumber` = '64718933' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Caitlyn Henderson' ,`SellingOfficeName` = 'The Christopher Dynasty Real Estate Group' ,`Latitude` = '29.715221' ,`Longitude` = '-95.914225' ,`PhotoCount` = '28' ,`PostalCode` = '77441' ,`RoomCount` = '16' ,`ListPrice` = '554964.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Albany Shores' ,`StreetNumber` = '5018' ,`StreetSuffix` = 'Lane' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3238' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Preston, Elevation D) CURRENTLY BEING BUILT. Two story. 4 bedrooms. 3.5 baths. Primary suite downstairs with large walk-in closet. Spacious island kitchen open to Family room. Formal Dining and Study. Game room and Media Room upstairs. Covered back patio and attached 2 car garage. Located in Fulshear, one of the fastest growing cities in Texas, Cross Creek West is located minutes from major roadways including Interstate 10. As a sister community to Cross Creek Ranch, homeowners will have access to the fabulous amenities available! Stop by the Westin Homes sales model to learn more about Cross Creek West!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 18 BLK 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6879' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1350' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cross Creek West' ,`TaxAmount` = '' ,`TaxRate` = '3.29' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675087630' WHERE `Matrix_Unique_ID` = '212523654' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-05T13:55:49.763' ,`MLSNumber` = '90860192' ,`ListAgentFullName` = 'Chelsea Tucker' ,`ListOfficeName` = 'Krueger Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.149367' ,`Longitude` = '-95.637470' ,`PhotoCount` = '13' ,`PostalCode` = '77354' ,`RoomCount` = '5' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Hardin Store' ,`StreetNumber` = '26146' ,`StreetSuffix` = 'Road' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2368' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous, sprawling 1.5-acre country lot is teeming with potential. Land is situated on a large corner lot with no deed restrictions! Property includes the 2-story home with large garage, secondary storage building/garage, and custom-made iron front gate. Home will be cleared by sellers prior to close of sale. HVAC is 7 years old and has been serviced annually. Water pump is 1 year old and water heater was recently replaced. Located in a quickly developing popular area only minutes away from the Woodlands, Tomball, and Magnolia.' ,`Acres` = '1.5' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0343 MURY BARTLEY, TRACT 28, ACRES 1.500' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '65340' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'MURY BARTLEY (Southeast Magnolia)' ,`TaxAmount` = '4119' ,`TaxRate` = '1.9215' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675087631' WHERE `Matrix_Unique_ID` = '212861195' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-05T13:46:58.227' ,`MLSNumber` = '27142921' ,`ListAgentFullName` = 'Andrea Rocha' ,`ListOfficeName` = 'Knob and Key Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.916330' ,`Longitude` = '-98.380218' ,`PhotoCount` = '38' ,`PostalCode` = '78070' ,`RoomCount` = '8' ,`ListPrice` = '199000.00' ,`Status` = 'Active' ,`StreetName` = 'Country Haven' ,`StreetNumber` = '139' ,`StreetSuffix` = 'Drive' ,`City` = 'Canyon Lake' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1536' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Major price reduction -$37,500. Seller wants to sell! Cute manufactured home sits on .44 acre lot, 1/2 the property has oak and a few cedars scattered throughout. New deck has been added and new skirting since pictures were taken. Storage building on property with two car carport. Perfect home for a first time home owner or second home near Canyon Lake.' ,`Acres` = '0.44' ,`Area` = '83' ,`BuilderName` = 'Cavco' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'REBECCA CREEK PARK THIRD FILING, BLOCK 50, LOT 3' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Wooded' ,`LotSize` = '9875' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '141 - Comal' ,`SchoolElementary` = 'REBECCA CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CANYON LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'MOUNTAIN VALLEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Lockbox Left Side,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Rebecca Creek Park 3' ,`TaxAmount` = '793' ,`TaxRate` = '1.786' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675087631' WHERE `Matrix_Unique_ID` = '213263934' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-05T13:47:17.680' ,`MLSNumber` = '41898695' ,`ListAgentFullName` = 'Marisa Yansen' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.441600' ,`Longitude` = '-95.451961' ,`PhotoCount` = '29' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Texas Cut' ,`StreetNumber` = '9802' ,`StreetSuffix` = '' ,`City` = 'Iowa Colony' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2121' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful updated 2133 sq ft 2 story home with 4 bedrooms, 2.5 baths Nestled into the beautiful coastal plains of Brazoria County just south of Pearland. Convenient access to upscale shopping, fine dining and many more. Homeowners will find an incredible array of amenities including paved walking trails, recreation center, which hosts a playground, tennis courts, basketball pavilion, fitness center and the community’s very own waterpark.\r\nCALL TODAY FOR AN APPOINTMENT!!' ,`Acres` = '0.1263' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'STERLING LAKES WEST SEC 2 (A0714 WM PATTUS) BLK 4 LOT 13' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '5502' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'SANCHEZ ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sterling Lakes West Sec 2 A07' ,`TaxAmount` = '8226' ,`TaxRate` = '3.4099' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675087631' WHERE `Matrix_Unique_ID` = '214241058' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-05T14:23:57.313' ,`MLSNumber` = '80486683' ,`ListAgentFullName` = 'Zhaoqi Li' ,`ListOfficeName` = 'Agent Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.942993' ,`Longitude` = '-95.174429' ,`PhotoCount` = '38' ,`PostalCode` = '77044' ,`RoomCount` = '8' ,`ListPrice` = '579000.00' ,`Status` = 'Active' ,`StreetName` = 'Easton Gate' ,`StreetNumber` = '15406' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '6' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '4973' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wow, this stunning 6 bedroom 6.5 bathroom house offers 4973 sqft of living. Located in a gated community, in the beautiful neighborhood of Lakewood Pines. It features open floor plan. Big windows let in plenty of natural light. Common area of first floor has luxury hardwood floor. Kitchen boast beautiful white cabinetry, granite countertops, and stainless steel appliances. On the first floor, you will find spacious living area, and a formal dinning area. Large backyard with cover patio, great for entertaining. The primary suite is very spacious, there is enough space for adding a reading area by the huge windows. The primary bathroom offers dual sinks, separate shower and tub. Did I mention this home has 5 additional bedrooms, and total of 6.5 bathrooms, call to schedule your showings, and make this your dream home!' ,`Acres` = '0.2078' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 2 LAKEWOOD PINES SEC 3' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '9053' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'CENTENNIAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Call Occupant' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakewood Pines' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675087631' WHERE `Matrix_Unique_ID` = '214702791' --> 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','215172099','1675087631','215172099','2022-12-05T14:45:04.783','93653974','Ronnie Matthews','D.R. Horton Homes',' Non-MLS Agent','Non-MLS ','30.245745','-95.201728','7','77372','3','218990.00','Pending Continue to Show','Fern Meadows','14244','','Splendora','2','0','3','1296','Single-Family','WONDERFUL NEW D.R. HORTON BUILT 1 STORY! Fantastic Open Concept Interior Layout! Beautiful Finishes with espresso colored cabinetry and Stainless Steel Appliances! Lovely Foyer Opens to Island Kitchen with Spacious Corner Pantry, Dining Area, & Large Living Room! Privately Located Primary Suite Features Oversized Shower & Walk-In Closet! Spacious Secondary Bedrooms! Great Guest Bath with Tub/Shower Combo! Indoor Utility Room! Covered Patio Overlooks Tranquil Backyard! Landscape Package Included! Hurry and call today!!','','40','DR Horton','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Cleveland Area','Central Gas','1','Lot 49 Block 1','Cul-De-Sac,Subdivision Lot','','','','450','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','47 - Splendora','PINEY WOODS ELEMENTARY SCHOOL','SPLENDORA HIGH SCHOOL','SPLENDORA JUNIOR HIGH','Appointment Required','Builder','1','Traditional','Presswoods','','','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','215235664','1675087632','215235664','2022-12-05T14:52:00.950','48299292','Ronnie Matthews','D.R. Horton Homes','Jana Koshnick','Keller Williams RealtyNortheast','30.246301','-95.201084','7','77372','3','217590.00','Pending Continue to Show','Upper Gardenia','14105','','Splendora','2','0','3','1296','Single-Family','WONDERFUL NEW D.R. HORTON BUILT 1 STORY! Fantastic Open Concept Interior Layout! Beautiful Finishes with espresso colored cabinetry and Stainless Steel Appliances! Lovely Foyer Opens to Island Kitchen with Spacious Corner Pantry, Dining Area, & Large Living Room! Privately Located Primary Suite Features Oversized Shower & Walk-In Closet! Spacious Secondary Bedrooms! Great Guest Bath with Tub/Shower Combo! Indoor Utility Room! Covered Patio Overlooks Tranquil Backyard! Landscape Package Included!','','40','DR Horton','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Cleveland Area','Central Gas','1','Lot 38 Block 1','Subdivision Lot','','','','450','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','47 - Splendora','PINEY WOODS ELEMENTARY SCHOOL','SPLENDORA HIGH SCHOOL','SPLENDORA JUNIOR HIGH','Appointment Required','Builder','1','Traditional','Presswoods','','','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','215268814','1675087632','215268814','2022-12-05T14:23:55.893','88645396','Laura Ruple','eXp Realty, LLC','','','29.481479','-95.528337','50','77459','11','730000.00','Active','Marble Hill','2511','Drive','Missouri City','4','0','4','3737','Single-Family','Gorgeous Home in a prestigious community! Step past the lush landscaping & covered front porch, and enter a sprawling open floorplan graced with soaring ceilings, intricate crown molding, large windows & gorgeous floors, plus NO CARPET & 2 TANKLESS HOT WATER HEATERS! The gourmet kitchen boasts a large kitchen island with breakfast bar, glass upper cabinets for displaying your favorite treasures, a wine rack & cooler, walk-in pantry, and a plethora of additional storage. Work from home in the executive home office, or entertain guests in either the game room or media room. The luxurious primary suite will keep you feeling right at home, featuring a large walk-in shower, separate tub, massive closet & a cozy bay window seating area in the bedroom. Enjoy a backyard barbecue this summer, using the large covered patio with a built-in kitchen station, or take advantage of fun community amenities like a water park & clubhouse. Builder:Coventry','0.2393','38','Coventry','','Gas Dryer Connections,Washer Connections','','Levee District,Mud,Other Disclosures,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Sienna Area','Central Gas','1','SIENNA VILLAGE OF DESTREHAN SEC 7B, BLOCK 5, LOT 11','In Golf Course Community,Subdivision Lot','10426','Appraisal District','','1307','0','','3','Double Oven,Electric Oven','0','','','Gas Cooktop','','Composition','19 - Fort Bend','LEONETTI ELEMENTARY SCHOOL','RIDGE POINT HIGH SCHOOL','THORNTON MIDDLE SCHOOL (FORT BEND)','Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox','Appraisal District','1','Contemporary/Modern,Ranch,Traditional','Sienna Village Of Destrehan Sec 7b','16416','3.1629','Water District','2019','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','215287408','1675087632','215287408','2022-12-05T14:47:48.923','52715031','Cody Scurlock','Keller Williams Realty - Clear Lake/ NASA','','','29.619852','-95.011094','44','77571','6','299000.00','Active','Shore Acres','403','Boulevard','Shoreacres','2','1','3','1454','Single-Family','Come out and see this stunning home, it is for sure to check off all your boxes! The home sits on a double corner lot just under 1/2 an acre and has been updated from the outside in! The outside has been painted a beautiful white with black trim accents on the trim and garage. As you walk into the home you\'re greeted with beautiful light brown and grey laminate wood flooring, that accentuates the white walls throughout the home. In the kitchen, you will find beautiful granite countertops, plenty of cabinet space, stainless steel appliances, and a wine fridge. Make your way further into the home to see the wonderful bedrooms that offer an abundance of space. The home also offers a sunroom, that you can use as an enclosed porch, game room, etc, with glass walls looking out into the huge backyard that offers an extra garage/workshop with a half bathroom. Make an offer before this home is gone!','0.4596','7','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Shoreacres/La Porte','Central Electric,Central Gas','0','LTS 5 & 6 BLK 25 SHOREACRES','Subdivision Lot','20020','Appraisal District','','','0','','4','Electric Oven','0','','','Electric Cooktop','','Composition','35 - La Porte','BAYSHORE ELEMENTARY SCHOOL','LA PORTE HIGH SCHOOL','LA PORTE J H','Appointment Required','Appraisal District','1','Traditional','Shoreacres','6761','2.8597','Public Sewer,Public Water','1965','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','215349757','1675087632','215349757','2022-12-05T14:49:25.360','11818252','Clarissa Castleberry','Surge Realty','','','29.941323','-95.197455','29','77346','9','414900.00','Active','Barclay Terrace','12630','Drive','Humble','2','1','4','2805','Single-Family','This beautiful Long Lake ltd home features an airy 2-story ceiling family room filled with natural light. With wood like tile flooring throughout the first floor, the open concept gourmet kitchen comes equipped with stainless steel appliances, tons of cabinets for storage, tile backsplash and an over-sized granite island. Unwind in your luxurious Primary Retreat with a beautiful bath featuring dual sinks, soaking tub, separate shower and walk-in closet. Also on the first floor is a dedicated dining room, utility, half bath and a home office. Upstairs you will find three secondary bedrooms, full bath, loft and a spacious game room. The inviting backyard includes a large covered patio. This home is MOVE-IN ready for you to enjoy the OUTSTANDING amenities - BOARDWALK, CRYSTAL LAGOON, CLUBHOUSE, TENNIS & VOLLEYBALL COURTS! You\'ll Love the convenience of nearby shopping, restaurants, and close proximity to Beltway 8.','0.1624','1','Long Lake ltd','','','','Mud,Sellers Disclosure','1','','','Summerwood/Lakeshore','Central Gas','1','LT 38 BLK 2 BALMORAL SEC 12','Subdivision Lot','7074','Appraisal District','','1150','0','','2','','0','','','','','Composition','29 - Humble','RIDGE CREEK ELEMENTARY SCHOOL','SUMMER CREEK HIGH SCHOOL','AUTUMN RIDGE MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Balmoral Sec 12','7549','2.9873','Water District','2020','Appraisal District'); --> New record created successfully