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-02T11:01:59.110' ,`MLSNumber` = '91897099' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.010223' ,`Longitude` = '-95.584001' ,`PhotoCount` = '21' ,`PostalCode` = '77070' ,`RoomCount` = '4' ,`ListPrice` = '729999.00' ,`Status` = 'Active' ,`StreetName` = 'Cossey' ,`StreetNumber` = '10610' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1732' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A large 4 bed 2 bath home. This property features ceramic tile throughout the main areas of the home, carpet in the bedrooms, a cozy fireplace in the living area, spacious gourmet kitchen, an attached 2 car garage, and an extended driveway that leads to the main road. The bedrooms are also very spacious with large closets, and there is a designated covered-patio area that leads to the backyard. Sitting on 3.45 acres of land, this home is perfect for a with pets! There is also a shop in the back that you can utilize however you desire. You will also be zoned to Klein ISD, which is ranked as one of the top school districts in the state of Texas. Having State Highway 249 down the road is a huge plus for getting around town efficiently. There are so many things you can do in this area like grabbing a bite to eat at one of the many popular restaurants and eateries nearby as well as being about 12 miles from the Houston Premium Outlets for when you want to do some shopping.' ,`Acres` = '3.452' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'No Heating,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'TR 2 IN 3 ABST 826 T K WHEELER' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '150369' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KRAHN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'ULRICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wheeler Tobias K' ,`TaxAmount` = '7561' ,`TaxRate` = '2.2586' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086471' WHERE `Matrix_Unique_ID` = '178016887' --> 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','205770989','1675086471','205770989','2022-12-02T12:30:46.030','76373643','Justin Dickey','Keller Williams Professionals','','','30.151200','-95.616300','16','77354','8','303055.00','Active','Grey Fox','27302','Run','Magnolia','3','0','3','1784','Single-Family','Colina Homes believes in building your dream 1-Story w/ 3 Bedrooms + 3 Full Baths at a price you CAN afford! Come see this open-concept home that lives BIG. Large, Spacious Kitchen with 42” Dark, Rich Cabinets + Luxury Granite + Subway Tile Backsplash on Grid + Stainless \"Farmhouse\" Single-Bowl Sink +Stainless Frigidaire Dishwasher, Vented Microwave & 5-BURNER GAS RANGE! Wood-like Flooring at Entry, Kitchen, Dining, Family Rm, Hallways, Utility & ALL Baths. Extra-Large Master Suite that boasts a walk-in Closet, 36\" Cabinets w/ Double Sinks, Large soaking Garden Tub with Arm Rests & Spacious Separate Shower with Shampoo Ledge! 3-Sides Acme Brick, 2” Faux Wood Blinds, 16 SEER Lennox Air System, In-Wall Pest Defense System & much more! Garage door opener included! This Energy Efficient home will SAVE you $$$! CALL & MAKE YOUR APPOINTMENT TO VISIT TODAY!','','15','Colina Homes','','Electric Dryer Connections','','No Disclosures','1','','0','Magnolia/1488 East','Central Gas','1','Lot 15 Block 2 Sec 2','Cul-De-Sac,Subdivision Lot','','Survey','','450','1','To Be Built/Under Construction','','','0','','','Freestanding Range,Gas Cooktop,Gas Range','','Composition','36 - Magnolia','CEDRIC C. SMITH ELEMENTARY SCHOOL','MAGNOLIA HIGH SCHOOL','BEAR BRANCH JUNIOR HIGH SCHOOL','Accompany','Builder','1','Traditional','Mill Creek Trails','','','Water District','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T12:05:18.770' ,`MLSNumber` = '16815282' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = 'Yzamar Paz' ,`SellingOfficeName` = 'AREA Texas Realty' ,`Latitude` = '29.829255' ,`Longitude` = '-94.987713' ,`PhotoCount` = '13' ,`PostalCode` = '77521' ,`RoomCount` = '14' ,`ListPrice` = '379897.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Brazos' ,`StreetNumber` = '9031' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2950' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Find total comfort in this lovely Beazer home in Ashbel Cove, boasting a brick façade, tile flooring, wrought iron spindles, a study with French doors, an open great room, and an extended covered patio. Create new dishes in the kitchen, equipped with quartz countertops, mosaic backsplash, stainless steel appliances, pendant lighting, and under-counter lighting. With dual vanities and a shower, the primary suite is a perfect place to relax. Situated near I-10 and Hwy 90, residents love the quick access to popular dining, shopping, and entertainment in the Greater Houston area. The serene Ashbel Cove community includes a park, serene lakes, and walking trails. Students attend schools zoned to Goose Creek CISD. There’s no time to lose – call today for more information!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'BANUELOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ashbel Cove' ,`TaxAmount` = '' ,`TaxRate` = '3.545293' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086471' WHERE `Matrix_Unique_ID` = '206221435' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T12:22:49.587' ,`MLSNumber` = '43900276' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '29.659700' ,`Longitude` = '-95.049500' ,`PhotoCount` = '19' ,`PostalCode` = '77571' ,`RoomCount` = '8' ,`ListPrice` = '387935.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Vanessa Cay' ,`StreetNumber` = '2316' ,`StreetSuffix` = 'Lane' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2032' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Retreat to this lovely Beazer Home in Morgan’s Landing, boasting a brick façade, sloped ceilings, luxury vinyl plank flooring, a fireplace, an open great room, and an extended covered patio. Cook up new cuisines in the kitchen, equipped with quartz countertops, mosaic backsplash, large cove molding, stainless steel appliances, pendant lighting, and under-counter lighting. The serene primary suite features a walk-in closet, dual vanities, a tub, and a separate shower. Located in La Porte, this community gives residents easy access to Kemah, the Houston Ship Channel, and Bay Area. Clear Lake and the Johnson Space Center are just minutes away! Morgan’s Landing’s amenities include a dog park, resort-style pool, pocket parks, lakes, and walking trails. Schools are zoned to La Porte ISD. You don’t want to miss this home – call now!' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'LOMAX ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Morgan\'s Landing' ,`TaxAmount` = '' ,`TaxRate` = '3.543251' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086471' WHERE `Matrix_Unique_ID` = '207812215' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T11:48:00.730' ,`MLSNumber` = '31269773' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.066273' ,`Longitude` = '-95.235073' ,`PhotoCount` = '28' ,`PostalCode` = '77339' ,`RoomCount` = '12' ,`ListPrice` = '472966.00' ,`Status` = 'Active' ,`StreetName` = 'Kings Mill' ,`StreetNumber` = '26039' ,`StreetSuffix` = 'Lane' ,`City` = 'Kingwood' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2590' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Create memories that will last forever in this desirable community. Resting on a spacious lot, this home features a stone elevation, luxury vinyl plank flooring, a game room, faux wood blinds, and an extended covered patio. Try a new recipe in the kitchen, complete with granite countertops, a tile backsplash, and stainless steel appliances. With a bay window, a walk-in closet, dual vanities, a tub, and a separate shower, the spa-like primary suite is perfect for relaxing after a tiring day. Situated off US 59, commuters love the easy access to the Sam Houston Parkway, and Bush International Airport. Popular shopping, dining, and entertainment are also a short drive away. Community comforts include a recreation center, playground, walking trails nestled in the piney woods, and a peaceful community lake. Schools are zoned to New Caney ISD. Call today!' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Liberty Home Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9 Block 2 Section 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'KINGS MANOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WOODRIDGE FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kings Mill' ,`TaxAmount` = '' ,`TaxRate` = '3.183' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086471' WHERE `Matrix_Unique_ID` = '209245660' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T11:46:26.680' ,`MLSNumber` = '98028230' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.061834' ,`Longitude` = '-95.242623' ,`PhotoCount` = '3' ,`PostalCode` = '77339' ,`RoomCount` = '13' ,`ListPrice` = '456811.00' ,`Status` = 'Active' ,`StreetName` = 'Kings Guild' ,`StreetNumber` = '21441' ,`StreetSuffix` = 'Lane' ,`City` = 'Kingwood' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2881' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Create unforgettable moments in this beautiful property. This home boasts a stone elevation, 2-car garage, versatile flex room downstairs, luxury vinyl plank flooring, spacious game room upstairs, and an extended covered patio. Cook up new recipes in the island kitchen, fully equipped with granite countertops, tile backsplash, 30” gas cooktop, and stainless steel appliances. Get some rest and relaxation in the tranquil primary suite, complete with a bay window, a walk-in closet, dual vanities, a tub, and a separate shower. Situated off US 59, residents have quick access to the Sam Houston Parkway, and Bush International Airport. Popular shopping, dining, and entertainment are also a short drive away. Community amenities include a recreation center, playground, walking trails nestled in the piney woods, and a peaceful community lake. Schools are zoned to New Caney ISD. You don’t want to miss this home – call now!' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Liberty Home Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 38 Block 1 Section 11' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'KINGS MANOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WOODRIDGE FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kings Mill' ,`TaxAmount` = '' ,`TaxRate` = '3.183' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086471' WHERE `Matrix_Unique_ID` = '209246456' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T12:00:43.830' ,`MLSNumber` = '27626379' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.066710' ,`Longitude` = '-95.236951' ,`PhotoCount` = '24' ,`PostalCode` = '77339' ,`RoomCount` = '13' ,`ListPrice` = '452721.00' ,`Status` = 'Active' ,`StreetName` = 'Somerset Shores' ,`StreetNumber` = '21458' ,`StreetSuffix` = 'Crossing' ,`City` = 'Kingwood' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Escape the city to this beautiful property. Resting on a spacious lot, this home boasts a stone elevation, luxury vinyl plank flooring, a game room, a study, and an extended covered patio. Amaze guests with meals made from the kitchen, complete with granite countertops, a tile backsplash, and stainless steel appliances. The spa-like primary suite is fully equipped with a bay window, a walk-in closet, dual vanities, a tub, and a separate shower. Situated near US 59, residents have easy access to the Sam Houston Parkway, and Bush International Airport. Popular shopping, dining, and entertainment are also a short drive away. Community comforts include a recreation center, playground, walking trails nestled in the piney woods, and a peaceful community lake. Schools are zoned to New Caney ISD. Don’t miss out – call now!' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Liberty Home Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 20 Block 1 Section 10' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'KINGS MANOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WOODRIDGE FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kings Mill' ,`TaxAmount` = '' ,`TaxRate` = '3.183' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086472' WHERE `Matrix_Unique_ID` = '209265094' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T12:50:02.190' ,`MLSNumber` = '11694330' ,`ListAgentFullName` = 'Joseline Vana' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.846555' ,`Longitude` = '-95.269188' ,`PhotoCount` = '9' ,`PostalCode` = '77028' ,`RoomCount` = '4' ,`ListPrice` = '344900.00' ,`Status` = 'Active' ,`StreetName` = 'Hillis' ,`StreetNumber` = '9213' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1786' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction-Beautiful new home in north side of Houston, wonderful layout on a super huge lot. Professional pictures coming soon- features 4 bedroom 3 bath open-concept 1 story with high ceilings at living room, granite island at kitchen for entertaining, Stainless steel appliances (gas range, dishwasher and built-in microwave). Large master suite with big closet, walking shower and large tub for relaxing after a hard day of work, other bedrooms are good sizes too. The covered back patio is excellent for barbecue at the huge back yard to accommodate amenities. Hurry up and call for more details. Low taxes and access to main freeways and shopping centers. Completion dates around December 2022.' ,`Acres` = '0.3174' ,`Area` = '2' ,`BuilderName` = 'Zuniga Builders LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 152 BLK 11 TIMMERMAN PLACE' ,`LotDesciption` = 'Corner' ,`LotSize` = '13826' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HILLIARD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Timmerman Place' ,`TaxAmount` = '627' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086472' WHERE `Matrix_Unique_ID` = '209417072' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T12:53:51.410' ,`MLSNumber` = '96473379' ,`ListAgentFullName` = 'Daniel Loria' ,`ListOfficeName` = 'RE/MAX Eastside' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.934391' ,`Longitude` = '-94.835336' ,`PhotoCount` = '33' ,`PostalCode` = '77535' ,`RoomCount` = '4' ,`ListPrice` = '735000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 1409' ,`StreetNumber` = '9643' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '2688' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful Establishment sits on 5 unrestricted Acres off of FM 1409 just outside of Dayton. The exterior offers a beautiful covered patio with ceiling fans to keep you cool all summer long, a large parking lot, and an awesome flex building on the side, that could be used for endless possibilities. The interior is a lovely rustic style, with Cedar and sheet metal around the whole bar. The bar top is a 25-30 feet, 2 inch thick, hand crafted, Cedar bar, and is a beautiful site to see. There is plenty of room for games, dancing, events, concerts and more. \r\nThe property is also wired with phase 3 wiring, which can hold 50-80 RV\'s, for someone interested in a potential RV park. Property sits less than 4 miles from Barbers Hill ISD.' ,`Acres` = '5' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = '000119 J A WILLIAMS, TRACT 35, ACRES 5.0' ,`LotDesciption` = 'Cleared,Other' ,`LotSize` = '217800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'KIMMIE M. BROWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'J A Williams' ,`TaxAmount` = '7605' ,`TaxRate` = '1.7625' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086472' WHERE `Matrix_Unique_ID` = '210463477' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T12:22:24.440' ,`MLSNumber` = '77589352' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`Selling