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-11-06T05:43:58.030' ,`MLSNumber` = '88530849' ,`ListAgentFullName` = 'Josh Rodriguez' ,`ListOfficeName` = 'Fathom Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.603593' ,`Longitude` = '-95.749896' ,`PhotoCount` = '42' ,`PostalCode` = '77406' ,`RoomCount` = '9' ,`ListPrice` = '995000.00' ,`Status` = 'Active' ,`StreetName` = 'Drs' ,`StreetNumber` = '2703' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '1160' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 2703 DRS Drive! Belle Ranch encompasses approximately 18 acres located directly on the historical and stunning \"bend\" of the Brazos River in desirable Ft. Bend County. Located at the end of elite DRS Drive, Belle Ranch has by far the largest acreage of any estate on the street. A custom built 2,800 sq. ft. main house is carefully situated to take advantage of the sun to maximize energy efficiency to stay cool in the summer and warm in the sinter. Boasting a huge kitchen with French cabinets and granite, this house is sure to please the most discerning chef. There is also a guest house of 1,160 sq. ft., tastefully finished with custom cabinets and granite in the kitchen. The property included stables with tack shed and various outbuildings with electrical power. There is a private stocked pond. There is also a large orchard with producing fruit and pecan trees. All appliances stay, as well as other amenities, including a 48HP tractor, garden tiller, and more. C\'mon over!' ,`Acres` = '17.9953' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = '0042 R JONES, TRACT 1 (PT), ACRES 17.9953, U/R BASSETT S/D' ,`LotDesciption` = 'Cul-De-Sac,Other' ,`LotSize` = '783875' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'R Jones' ,`TaxAmount` = '10508' ,`TaxRate` = '1.6948' ,`WaterSewer` = 'Well' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834843' WHERE `Matrix_Unique_ID` = '209891424' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T05:57:37.457' ,`MLSNumber` = '51954928' ,`ListAgentFullName` = 'John Newsom' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Bessie Lopez' ,`SellingOfficeName` = 'White Picket Realty LLC' ,`Latitude` = '29.783069' ,`Longitude` = '-96.147697' ,`PhotoCount` = '34' ,`PostalCode` = '77474' ,`RoomCount` = '7' ,`ListPrice` = '155000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Live Oak' ,`StreetNumber` = '803' ,`StreetSuffix` = 'Street' ,`City` = 'Sealy' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Unique property in Sealy, Tx . Could be residence or continue as a church. 1/2 acre lot. Room for garage addition . Unrestricted corner lot. Possibilities are endless.' ,`Acres` = '0.4659' ,`Area` = '57' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Space Heater,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'A005 SAN FELIPE DE AUSTIN T T ACRES 0.4659' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '20295' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '109 - Sealy' ,`SchoolElementary` = 'SEALY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEALY HIGH SCHOOL' ,`SchoolMiddle` = 'SEALY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'None' ,`TaxAmount` = '644' ,`TaxRate` = '2.149' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1667834844' WHERE `Matrix_Unique_ID` = '210093241' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T05:26:29.350' ,`MLSNumber` = '33238956' ,`ListAgentFullName` = 'Stephen Casper' ,`ListOfficeName` = 'Coldwell Banker Pat Dickey,' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.096367' ,`Longitude` = '-95.498949' ,`PhotoCount` = '45' ,`PostalCode` = '75851' ,`RoomCount` = '5' ,`ListPrice` = '228500.00' ,`Status` = 'Active' ,`StreetName` = 'FM230' ,`StreetNumber` = '4118' ,`StreetSuffix` = 'Highway' ,`City` = 'Lovelady' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1755' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Traditional country home on 2 acres, situated just 4.1 miles from Lovelady. Close enough for convenience and still have your privacy. Great location within the Lovelady ISD. This home has plenty of room to expand with 4 bedrooms and 2 baths with a total of approximately 1775 sq. ft. Property has pens and pasture area for animals. Don\'t let this country home pass you by if you\'re in the market for property in Lovelady Texas. Seller is motivated and concessions are available.' ,`Acres` = '2' ,`Area` = '41' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lovelady/Weldon Area' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'JNO Welsh AB90 2 acres' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '62 - Lovelady' ,`SchoolElementary` = 'LOVELADY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LOVELADY J H HIGH SCHOOL' ,`SchoolMiddle` = 'LOVELADY J H HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'No' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1667834844' WHERE `Matrix_Unique_ID` = '211755019' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T06:36:21.680' ,`MLSNumber` = '95012642' ,`ListAgentFullName` = 'Lisa Davis' ,`ListOfficeName` = 'Realty ONE Group Iconic' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.217927' ,`Longitude` = '-95.802257' ,`PhotoCount` = '24' ,`PostalCode` = '77355' ,`RoomCount` = '7' ,`ListPrice` = '309900.00' ,`Status` = 'Active' ,`StreetName` = 'Maverick Ranch' ,`StreetNumber` = '27034' ,`StreetSuffix` = 'Road' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2148' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! Home features a Brick and stone entry and fresh paint throughout. Expansive kitchen, breakfast bar, under cabinet lighting, tons a cabinets, granite counter tops with a tile backsplash. Stainless steel refrigerator stays. A wall of windows in the living room overlooking the patio. Spacious primary bedroom, bathroom has dual sinks, garden tub with a large closet. Washer and Dryer stay with the home. Huge backyard with a large patio great for entertaining. Located on a cul-de-sac street. Great neighbors!' ,`Acres` = '0.3539' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S821103 - RANCH CREST 03, BLOCK 1, LOT 119' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '15415' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'WILLIE E. WILLIAMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ranch Crest 03' ,`TaxAmount` = '4590' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834844' WHERE `Matrix_Unique_ID` = '211824017' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T06:37:01.303' ,`MLSNumber` = '47578778' ,`ListAgentFullName` = 'Marlana Mack' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.069978' ,`Longitude` = '-95.534789' ,`PhotoCount` = '26' ,`PostalCode` = '77379' ,`RoomCount` = '4' ,`ListPrice` = '387121.00' ,`Status` = 'Active' ,`StreetName` = 'Rose Crossing' ,`StreetNumber` = '20931' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2576' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful two-story, four-bedroom, two-and-a-half-bathroom home is located in the well-sought-after Windrose Community. You can take your pick of which community amenity you will enjoy first. Windrose offers miles of hiking and biking trails nearby, many local restaurants, award-winning Klein ISD schools, a golf course, 2 pools, a tennis court, and half a dozen playgrounds and is minutes away from HWY 99 and 249. Schedule your viewing before this home is sold! OCTOBER 2022 UPDATES: New flooring, Upgraded guest bathroom, New dishwasher, New microwave, Entire home repainted, some New light fixtures, and some New blinds. The home has been deep cleaned and will have a touch-up cleaning prior to closing.' ,`Acres` = '0.1607' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 39 BLK 1 WINDROSE WEST SEC 15 AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6998' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BENIGNUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'KRIMMEL INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Windrose West Sec 15 Amd' ,`TaxAmount` = '7113' ,`TaxRate` = '2.7066' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834844' WHERE `Matrix_Unique_ID` = '212631630' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T06:33:43.220' ,`MLSNumber` = '67113746' ,`ListAgentFullName` = 'Sherrin Quire' ,`ListOfficeName` = 'Gulf Coast, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.471606' ,`Longitude` = '-95.085749' ,`PhotoCount` = '50' ,`PostalCode` = '77573' ,`RoomCount` = '4' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'Caine Hill' ,`StreetNumber` = '1415' ,`StreetSuffix` = 'Court' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3346' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This David Powers home has four bedrooms and one large office, as well as a two car garage and two quaint covered patios in the back. Enjoy a full kitchen with dishwasher, stovetop, oven, two full sized fridges, and large pantry. Large formal dining room. Washer/dryer in laundry room will remain. Amazing floor plan with tons of space! Custom built in Buffet and Wine bar, Gourmet kitchen, huge master suite with sitting area and spa-like master bathroom! Great guest room with private bath, additional bedrooms are very spacious with Jack n Jill baths with private vanities! Foyer truly has a grand entry with elegance everywhere you look! Peaceful Cul-de-sac lot! The extra one car garage has a built in lifestyle screen(2018) to pull down to escape the mosquitos! No back neighbors! New roof 2022. 14 foot ceilings and 8 ft doors! Koehler generator that automatically runs entire house! Electric oven 2020, 5 ton gas furnace 2019.' ,`Acres` = '0.2035' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'VICTORY LAKES SEC 1 (2001), ABST 3 S F AUSTIN SUR, BLOCK 2,' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '8863' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '779' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'RALPH PARR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'VICTORYLAKES INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Victory Lakes Sec 1 2001' ,`TaxAmount` = '7940' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834845' WHERE `Matrix_Unique_ID` = '213102130' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T06:23:22.640' ,`MLSNumber` = '92231686' ,`ListAgentFullName` = 'Evelyn Laniado' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.675385' ,`Longitude` = '-95.830295' ,`PhotoCount` = '30' ,`PostalCode` = '77406' ,`RoomCount` = '4' ,`ListPrice` = '349000.00' ,`Status` = 'Active' ,`StreetName` = 'Lilac Croft' ,`StreetNumber` = '10131' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2266' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home!!!! Gorgeous 2 story Brick and stone home front elevation with inviting covered front porch. Walk in to Open concept Cherry Slate kitchen cabinets with elegant Iced White Quartz counter tops with an eased edge and and a mesh mount tile kitchen back splash to compliment it all. Luxury Vinyl wood floors throughout the entry, kitchen, dining, utility room and powder room. Stainless steel Whirlpool kitchen appliances including a gas cook-top, built-in microwave, oven and dishwasher. Walk up the stairs to a loft area, perfect for Family gatherings. All 4 bedrooms up with walk-in closets and 2 bathrooms. Home Also has double Low E pane tilt out windows and fixed windows in the family room and dining area bringing in lots of natural light. Ready for move in and to be called Home.' ,`Acres` = '0.126' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CREEKSIDE RANCH SEC 12, BLOCK 1, LOT 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5490' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '825' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BENTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Creekside Ranch Sec 12' ,`TaxAmount` = '6148' ,`TaxRate` = '2.5248' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834845' WHERE `Matrix_Unique_ID` = '213743218' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T06:35:53.743' ,`MLSNumber` = '29053554' ,`ListAgentFullName` = 'Chinonso Ochi-Okorie' ,`ListOfficeName` = 'The Goldstein Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.676424' ,`Longitude` = '-95.361256' ,`PhotoCount` = '46' ,`PostalCode` = '77051' ,`RoomCount` = '8' ,`ListPrice` = '540215.00' ,`Status` = 'Active' ,`StreetName` = 'Vera Lou' ,`StreetNumber` = '1122' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2650' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'An ideal location near med center, Dwntwn Houston,& Galleria. 4 bed 3 bath home w/2 rooms on the 1st floor w/ huge 2nd floor den on 14k sqft lot ready for pool-spa/pool house/pergola in the back yard for Airbnb. Home features: Open concept floor plan, custom brick/stone elevation, int/ext LED lighting pkg, 3x LED fireplaces, pre-wired for solar/EV charging, pre wired for int 5.1 surround sound & ext speakers, quartz counter tops w/waterfall, stainless steel appliances, spray foam insulation, double stacked custom cabinets w/glass/soft close doors w/smart LED lighting, apron sink, pot filler, 8 ft Iron front door, Matte black fixtures/hardware, 8ft int doors, painted garage, 7 light garage door, architectural fence w/wrought iron gate, remote security system & camera\'s, stained hardwood ceilings in patio/porch, & more. NO HOA NO MUD NOT IN A FLOOD ZONE. Deed Restricted(NO NEW MULTI-FAMILY DEV ALLOWED. ALL REASONABLE OFFERS WILL BE CONSIDERED DUE TO CURRENT INTEREST RATE CONDITIONS!' ,`Acres` = '0.3085' ,`Area` = '3' ,`BuilderName` = 'GENERATIONAL HOME' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 6 & 7A BLK F BROOKHAVEN R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13440' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'YOUNG ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Brookhaven R/P' ,`TaxAmount` = '819' ,`TaxRate` = '2.4216' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667834845' WHERE `Matrix_Unique_ID` = '213777399' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T06:45:29.803' ,`MLSNumber` = '45594156' ,`ListAgentFullName` = 'Dona Angell' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.283875' ,`Longitude` = '-95.558900' ,`PhotoCount` = '50' ,`PostalCode` = '77316' ,`RoomCount` = '12' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'Cherry Oak' ,`StreetNumber` = '119' ,`StreetSuffix` = 'Lane' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3291' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning HOME on highly desired street - Cherry Oak Lane in award winning neighborhood of Woodforest! Feel at home the moment you arrive. Begins with beautiful architectural details and lush landscaping with welcoming front porch/entry. Two-story entry fills the room with natural light. Large dining room with detailed molding provides opportunities for gathering friends and family. Wood floors and open floor plan. Breakfast area, kitchen and family room all connect for easy lifestyle. Separate home office/study with French doors for privacy. Large primary bedroom with primary bath and walk-in closet on first floor. Laundry room with details that provides organization and style. 2 car attached garage with TV (TV stays). Generous Family room with fireplace for conversation or viewing TV. Back covered patio provides cozy coffee spot or relaxing evening space. Upstairs=FUN! Game room, Media room, 3 secondary bedrooms and 2 full baths. It\'s easy to plant roots when HOME feels this good!' ,`Acres` = '0.1665' ,`Area` = '39' ,`BuilderName` = 'Darling Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S965208 - WOODFOREST 08, BLOCK 1, LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7252' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1265' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest 08' ,`TaxAmount` = '9845' ,`TaxRate` = '2.6888' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834845' WHERE `Matrix_Unique_ID` = '213979634' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T06:51:36.313' ,`MLSNumber` = '91500958' ,`ListAgentFullName` = 'Umar Bawany' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.763969' ,`Longitude` = '-94.996431' ,`PhotoCount` = '19' ,`PostalCode` = '77521' ,`RoomCount` = '6' ,`ListPrice` = '339000.00' ,`Status` = 'Active' ,`StreetName` = 'Barnacle' ,`StreetNumber` = '3903' ,`StreetSuffix` = 'Court' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2443' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this 4 bedroom + study, 2.5 bathrooms home! The home features a study upon entry, an open to below family room with high ceilings and big windows, and a downstairs primary bedroom. A spacious game room and 3 secondary bedrooms with walk-in closets are located upstairs. The community has a covered pavilion, pool, playground, lake, and walking trails, with easy access to major streets and the freeway. \r\n\r\nCall today for a private showing!' ,`Acres` = '0.1705' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 3 GOOSE CREEK RESERVE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7429' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'BAYTOWN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Goose Crk Reserve Sec 3' ,`TaxAmount` = '9440' ,`TaxRate` = '3.63' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1667834845' WHERE `Matrix_Unique_ID` = '214075892' --> 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','214455497','1667834846','214455497','2022-11-06T06:50:33.057','82569528','Heather Albe','Evolve Real Estate','','','30.045820','-95.625094','20','77377','10','950000.00','Active','Boudreaux','13847','Road','Tomball','1','0','3','2453','Single-Family','2 +/- Acres frontage to Boudreaux. Outstanding investment opportunity with utilities on site. Directly across the street from 240 acre industrial park site \"Interchange 249\". Minutes away from Highway 99, Tomball, Magnolia, Vintage Park and Retail. Lots of new development in the area','1','35','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','0','','','Tomball South/Lakewood','Central Gas','0','PT TR 1G (HOMESITE) ABST 296 E GIRARD','Cleared','86772','Appraisal District','','','0','','','Electric Oven','0','','','Electric Range','','Composition','53 - Tomball','GRAND OAKS ELEMENTARY SCHOOL','TOMBALL MEMORIAL H S','GRAND LAKES JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Left Side,Request Online Appointment','Appraisal District','1','Ranch','GIRARD EMILE','4348','2.0264','Septic Tank,Well','1983','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T05:27:08.677' ,`MLSNumber` = '75095229' ,`ListAgentFullName` = 'Nicole Shields' ,`ListOfficeName` = 'CRI Real Estate Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.240707' ,`Longitude` = '-95.501654' ,`PhotoCount` = '35' ,`PostalCode` = '77384' ,`RoomCount` = '6' ,`ListPrice` = '436000.00' ,`Status` = 'Active' ,`StreetName` = 'Ripplewood' ,`StreetNumber` = '2474' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2315' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this custom built, corner lot home in the highly desired Carriage Hills neighborhood. Situated on just under 1/2 acre, this property features a wrap around porch and great curb appeal. Step inside an open floor plan complete with formal dining room, 2 story ceilings in living room, 2 sets of French doors off kitchen for back patio and front porch access. Kitchen with ample cabinets, dishwasher a few years old, panty half bath off kitchen, laundry room with cabinets and window.Custom blinds throughout home. Recently installed carpet on the stairs and upper level. Both HVAC replaced one in 2019 other in 2022. Septic recently serviced. Zoned to The Woodlands Schools, close to many restaurants, shopping and convenient access to I-45, This is a must see!!' ,`Acres` = '0.4729' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CARRIAGE HILLS 01, BLOCK 1, LOT 39' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '20600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Carriage Hills 01' ,`TaxAmount` = '5771' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834846' WHERE `Matrix_Unique_ID` = '214458687' --> 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','214463349','1667834846','214463349','2022-11-06T06:49:09.163','12906953','Cesar Espinoza','Equity Real Estate','','','29.828159','-95.489528','50','77092','4','479900.00','Active','Granite','6613','Street','Houston','3','1','4','2565','Single-Family','NEW CONSTRUCTION! This stunning 2-story home features 4 bedrooms, 3.5 baths, a two-car garage, and plenty of entertaining space for you and your guests. Downstairs features a formal dining room a large family room opens to the kitchen and breakfast area. The kitchen features SS appliances, granite countertops, and ample cabinet space with under-counter lighting. The primary suite is a perfect retreat after a long day featuring a spacious bathroom with a separate tub/shower and a large walk-in closet. The upstairs features a large game room, study, and three secondary bedrooms. High ceilings and abundant natural light throughout.','0.1414','24','TX Ranch Custom Home','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','Mock Fireplace','1','Spring Branch','Central Electric','0','LT 11 BLK 23 LANGWOOD SEC 1 R/P','Subdivision Lot','6160','Appraisal District','','','1','Never Lived In','2','Gas Oven','0','','','Gas Cooktop','','Composition','27 - Houston','BENBROOK ELEMENTARY SCHOOL (HOUSTON)','SCARBOROUGH HIGH SCHOOL','CLIFTON MIDDLE SCHOOL (HOUSTON)','Appointment Required','Builder','2','Traditional','Langwood Sec 01 R/P','1565','2.3307','Public Sewer,Public Water','2022','Builder'); --> New record created successfully