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-24T23:04:43.283' ,`MLSNumber` = '90461465' ,`ListAgentFullName` = 'Kimberley Ngo' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.874793' ,`Longitude` = '-95.670450' ,`PhotoCount` = '8' ,`PostalCode` = '77084' ,`RoomCount` = '8' ,`ListPrice` = '289999.00' ,`Status` = 'Active' ,`StreetName` = 'Glenpatti' ,`StreetNumber` = '17231' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1897' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A nice, cozy and spacious 3 bedrooms, 2 baths, and 2 car garage. Open floor plan, large master bedroom with separate shower and garden tub, large kitchen with breakfast bar, and build in computer desk. Tile floor throughout home. W/D and refrigerator included. Good school district. Minutes to hospitals, shopping centers, malls, entertainment, restaurants, movie theaters and park. ALL new appliances and new light fixtures.' ,`Acres` = '0.1309' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 3 CROSSING AT STONE CREEK SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '410' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'METCALF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LANGHAM CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'KAHLA MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Crossing At Stone Creek Sec 02' ,`TaxAmount` = '5616' ,`TaxRate` = '2.706' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642217' WHERE `Matrix_Unique_ID` = '212576117' --> 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','213509739','1669642217','213509739','2022-11-25T00:20:48.793','43399443','Sydney Ealy','Sydney Ealy','','','29.999690','-95.491583','0','77068','12','259990.00','Active','Croftwood','15002','Drive','Houston','2','1','4','2378','Single-Family','','0.2094','13','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','','Wood Burning Fireplace','1','1960/Cypress Creek North','Central Gas','1','LT 69 BLK 18 OAK CREEK VILLAGE SEC 2','Cul-De-Sac','9120','Appraisal District','','300','0','','2','','0','','','Electric Cooktop','','Composition','48 - Spring','PAT REYNOLDS ELEMENTARY SCHOOL','WESTFIELD HIGH SCHOOL','EDWIN M WELLS MIDDLE SCHOOL','Accompany,Appointment Required,Lockbox Front,No Photos/No Videos','Appraisal District','2','Traditional','Oak Creek Village Sec 02','4607','2.4592','Public Sewer','1973','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T23:46:51.383' ,`MLSNumber` = '6312858' ,`ListAgentFullName` = 'Cindy Cristiano' ,`ListOfficeName` = 'RE/MAX Space Center-Clear Lake' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.554380' ,`Longitude` = '-95.238692' ,`PhotoCount` = '37' ,`PostalCode` = '77581' ,`RoomCount` = '10' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Pinehill' ,`StreetNumber` = '2002' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2252' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cute 3 bedroom home nestled in the wooded neighborhood of Pine Shadows, in the heart of Pearland!\r\nNew roof installed (Nov. 2022), oversized lot with a storage shed for all your gardening needs. The sunroom on the back of the house is wonderful for enjoying those cool evenings or sipping your morning coffee. The bedrooms are nicely sized as are all the other living spaces. This well-maintained house is ready for move-in! The tax rate is fabulous with no MUD taxes or HOA dues. This home has not flooded. Close to Pearland Parkway, Beltway 8 and Hwy 45.' ,`Acres` = '0.2725' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 22, Block 1 Pine Shadows' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '11870' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'SHADYCREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH EAST' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pine Shadows' ,`TaxAmount` = '6964' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642217' WHERE `Matrix_Unique_ID` = '213836422' --> 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','214279717','1669642217','214279717','2022-11-25T00:20:48.013','74999315','Brandon Gorman','Virginia Malone Realty','','','29.772925','-94.924645','4','77521','10','389000.00','Active','Autumn','3601','Lane','Baytown','2','1','4','2936','Single-Family','Absolutely Stunning one story home in Whispering Pines in need of a new caretaker. This home offers a flowing floorplan with tons of amenities and features. Designer Hardwoods and tile throughout, this home has no carpet. Custom built-ins and entertainment center in family room with fireplace and recessed ceiling. Master bedroom is nice, but the master bath offers heated flooring, open shower to add to the luxury of this home. The fireplace in the family room currently offers a remote gas logs for cold winter nights or just ambiance. Beautiful kitchen with granite countertops and a bar with a sonic style ice maker. The house is also equipped with a new emergency generator that runs the house. The utility room offers a small sink and is equipped with connections for a gas or electric dryer. The 3 car garage is a great space for storage or mancave. This house has been completely rebuilt after hurricane Harvey.','0.2587','2','','','','','Sellers Disclosure','1','Freestanding,Wood Burning Fireplace','1','Baytown/Harris County','Central Gas','0','LT 45 WHISPERING PINES SEC 1 R/P','Corner','11269','Appraisal District','','75','0','','3','','0','','','','','Composition','23 - Goose Creek Consolidated','STEPHEN F. AUSTIN ELEMENTARY SCHOOL (GOOSE CREEK)','STERLING HIGH SCHOOL (GOOSE CREEK)','CEDAR BAYOU J H','Appointment Required','Appraisal District','1','Traditional','Whispering Pines Sec 01 R/P','3759','2.97','Public Sewer,Public Water','1974','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214389069','1669642217','214389069','2022-11-25T00:20:46.890','55726676','Dr. Brad Mitchell','eXp Realty, LLC','','','29.914290','-95.722928','32','77433','16','594900.00','Active','Kohle Springs','20419','Lane','Cypress','3','1','4','3113','Single-Family','Nestled in Miramesa\'s Canyon Lakes at Stone Gate, is this lovely 2 story clean line, contemporary home. Bright and open concept first level common areas. White kitchen. High Ceilings. Game room. Media room. Office. Note the extra details that have been added inside and outside. Custom stair railing. Custom fireplace. Custom backyard deck and porch additions. No back neighbors. Custom TV wall in the Primary. Custom wall/ceiling over the tub. Custom decorative wall(s) in upstairs bedroom. ...and so much more. For your sunset stroll, follow the path in front of the house to walk around the lake. There is a community dog park, tennis courts, play grounds, pool and community center. CFISD schools!','0.1578','25','','','Electric Dryer Connections','','Mud,Sellers Disclosure','1','','1','Cypress South','Central Gas','1','LT 33 BLK 1 MIRABELLA SEC 2','Subdivision Lot','6875','Appraisal District','','1000','0','','2','Freestanding Oven','1','Above Ground','','','','Composition','13 - Cypress-Fairbanks','POSTMA ELEMENTARY SCHOOL','CYPRESS SPRINGS HIGH SCHOOL','ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)','Appointment Required','Appraisal District','2','Contemporary/Modern','Mirabella Sec II','10282','3.041','Public Sewer,Public Water,Water District','2018','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T00:20:46.610' ,`MLSNumber` = '29165225' ,`ListAgentFullName` = 'Trisha Lauter' ,`ListOfficeName` = 'Realm Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.367952' ,`Longitude` = '-95.612272' ,`PhotoCount` = '36' ,`PostalCode` = '77356' ,`RoomCount` = '13' ,`ListPrice` = '1049900.00' ,`Status` = 'Active' ,`StreetName` = 'April Wind' ,`StreetNumber` = '106' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '4720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Resort style, Mod/Mid-Century Home! A place not only to live but to get away. Featuring great views of Lake Conroe/Golf Course, several gathering areas including automated pool/spa area w/ dedicated bath/kitchen, courtyard, and balconies- A Wine room/bar area is directly off pool & leads into the 4th bdrm being used as a poker room. 3 Large Bedrooms w/private bathrooms - new showers. The Owner\'s retreat with dedicated dressing/sitting area & huge jetted/soaker tub & double shower with steam sauna. The Living area is open for entertaining to the Dining, Game room, and Kitchen. The kitchen is sure to please any chef with 2 convection ovens, European Induction cooktop & large island with Brazilian granite. Hardwood flooring, tile, modern commercial-grade carpet, epoxy flooring, custom ceiling beams, modern paneled & stacked stone walls, modern lighting, Many large picture windows & skylights, Leaf guard gutters, large driveway/parking area. A truly amazing place to call HOME!' ,`Acres` = '0.166' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S215006 - APRIL SOUND 06, BLOCK 1, LOT 1, 2, ACRES 0.166' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot,Water View' ,`LotSize` = '7231' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '238' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'April Sound 06' ,`TaxAmount` = '7865' ,`TaxRate` = '2.2525' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642217' WHERE `Matrix_Unique_ID` = '214464549' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T00:37:08.740' ,`MLSNumber` = '36559113' ,`ListAgentFullName` = 'Gabriel Mendoza' ,`ListOfficeName` = 'Orchard Brokerage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.466603' ,`Longitude` = '-95.464389' ,`PhotoCount` = '27' ,`PostalCode` = '77583' ,`RoomCount` = '9' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Green Clover' ,`StreetNumber` = '727' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2098' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Pride of ownership and beautiful upgrades shine in this meticulously maintained 4-bedroom home sited on a spacious corner lot just a few blocks from the community park with jogging trails, a basketball court, and a playground. Featuring a covered entryway to the foyer and an attached garage with interior access. Open concept with a living-dining combination great for entertaining guests. Expansive wood laminate in the common areas, vaulted ceilings, and numerous windows capture every essence of daylight throughout the home. The chef\'s dream kitchen is upgraded with impressive granite, a spacious center island with a breakfast bar, a beautiful backsplash, SS appliances with a gas range, recessed and under-cabinet lighting upgrades, and a pantry. Luxurious primary with vaulted ceiling as well as an attached 5-piece bath with a walk-in closet. The fenced private yard has a covered patio overlooking the lush back lawn. Fort Bend ISD. Click the Virtual Tour link to view a 3D walkthrough' ,`Acres` = '0.1808' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SOUTHERN COLONY SEC 4A, BLOCK 6, LOT 29' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7875' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Southern Colony Sec 4a' ,`TaxAmount` = '7582' ,`TaxRate` = '3.1329' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642218' WHERE `Matrix_Unique_ID` = '214629496' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T00:32:10.663' ,`MLSNumber` = '46148140' ,`ListAgentFullName` = 'Kashif Gaddi' ,`ListOfficeName` = 'Texas Ally Real Estate Group,' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.471807' ,`Longitude` = '-95.163022' ,`PhotoCount` = '38' ,`PostalCode` = '77573' ,`RoomCount` = '5' ,`ListPrice` = '429500.00' ,`Status` = 'Active' ,`StreetName` = 'Southampton' ,`StreetNumber` = '565' ,`StreetSuffix` = 'Lane' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2598' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming one-story 3 bedroom, 2.5 bathroom, 3 car garage house is the perfect place to call home. Stone and brick elevation upgrade along with a well-manicured lawn offers great curb appeal. Walk into the home with tiles from front to backdoor. Secondary bedrooms are tucked away in the front of the home away from the primary bedroom offering privacy. Explore deeper and you will find a spacious study and formal dining room both with wood flooring. The family room with a fireplace is the perfect place to gather around on cold evenings. The kitchen is filled with countless upgrades and includes a large island, stainless steel appliances, double ovens, 42\" mocha cabinets with knobs, granite countertops, and recess lighting. Spacious primary bedroom with coffered ceilings. Primary bath comes with extra cabinets for storage along with a generous size walk-in closet. Backyard comes with a covered patio. Enjoy community swimming pools, tennis courts, and parks.' ,`Acres` = '0.1914' ,`Area` = '33' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WESTOVER PARK SEC 14B (2015) ABST 606 & 614, BLOCK 1, LOT 3,' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8338' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Westover Park Sec 14b 2015 A' ,`TaxAmount` = '9187' ,`TaxRate` = '2.5697' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669642218' WHERE `Matrix_Unique_ID` = '214699081' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T00:33:33.890' ,`MLSNumber` = '22207391' ,`ListAgentFullName` = 'Kashif Gaddi' ,`ListOfficeName` = 'Texas Ally Real Estate Group,' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.855961' ,`Longitude` = '-95.818923' ,`PhotoCount` = '34' ,`PostalCode` = '77493' ,`RoomCount` = '5' ,`ListPrice` = '252000.00' ,`Status` = 'Active' ,`StreetName` = 'Pampus Prairie' ,`StreetNumber` = '5714' ,`StreetSuffix` = 'Road' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1238' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Imagine your own lakefront home with direct access from your backyard. This recently painted 2019 built home offers great curb appeal and sits on a lakefront lot! Luxury vinyl plank floors greet you as you walk on all the way to the back door. Kitchen offers black energy appliances including refrigerator with 2022 installed stainless-steel dishwasher(not pictured). Primary bedroom is tucked away from the other bedrooms offering privacy and a great view of the lake. The secondary bedrooms come upgraded with new wood tiles. The backyard is the perfect place to unwind and enjoy the lovely views of the lake. Walk out of your backyard for a walk or run on the walking trail around the lake.' ,`Acres` = '0.1056' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 3 KATY CROSSING SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '665' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Katy Xing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642218' WHERE `Matrix_Unique_ID` = '214699287' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T23:11:45.063' ,`MLSNumber` = '53164661' ,`ListAgentFullName` = 'Danielle Wilson' ,`ListOfficeName` = 'Stanfield Properties' ,`SellingAgentFullName` = 'Susan Richard' ,`SellingOfficeName` = 'Top Guns Realty on Lake Conroe' ,`Latitude` = '30.253795' ,`Longitude` = '-95.428010' ,`PhotoCount` = '20' ,`PostalCode` = '77302' ,`RoomCount` = '8' ,`ListPrice` = '310000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Cumberland' ,`StreetNumber` = '455' ,`StreetSuffix` = 'Trail' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2003' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand new roof, improved price, & motivated seller! Peaceful country living with quick & easy city access! Located in the desirable River Plantation golf course community on the southern side of Conroe & the northern fringes of The Woodlands area, this single-story move-in ready home will wow you from start to finish! The oversized lot with established landscaping sets the stage for this open-concept design that boasts easy maintenance wood & tile flooring throughout, a family room with a wood or gas-burning corner fireplace, energy-efficient double-paned windows, and a kitchen with granite countertops with breakfast bar seating, stainless appliances, & an eat-in breakfast room. The split floorplan allows privacy for the master suite that boasts an en suite bath with a granite top vanity, a jetted tub, & a separate shower. Outdoors, enjoy a huge covered back porch for outdoor living on an oversized lot. Enjoy your own piece of paradise with this NEVER-FLOODED beauty in Conroe ISD!' ,`Acres` = '0.3537' ,`Area` = '19' ,`BuilderName` = 'Westwick Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RIVER PLANTATION 09, LOT 375-A, 376' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '15405' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '920' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'River Plantation 09' ,`TaxAmount` = '6218' ,`TaxRate` = '2.3888' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642218' WHERE `Matrix_Unique_ID` = '214777661' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T23:31:52.907' ,`MLSNumber` = '69031164' ,`ListAgentFullName` = 'Corina Garcia' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = 'Shannon Carreon' ,`SellingOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`Latitude` = '29.683337' ,`Longitude` = '-95.097572' ,`PhotoCount` = '47' ,`PostalCode` = '77536' ,`RoomCount` = '3' ,`ListPrice` = '300000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Pine Brook' ,`StreetNumber` = '2402' ,`StreetSuffix` = 'Court' ,`City` = 'Deer Park' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2271' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Move in ready home!! Beautiful split floor plan with indoor utility room and gorgeous dining room. Study is nice sized to have a sitting area with a desk. Bedrooms are all spacious and primary bedroom offers 2 closets. The primary bath has a vanity area with separate tub and shower. Come make this your new home just in time for the holidays!' ,`Acres` = '0.1983' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Deer Park' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 2 PINEY POINT SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8640' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'HERITAGE ELEMENTARY SCHOOL (LA PORTE)' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LOMAX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Piney Point' ,`TaxAmount` = '8604' ,`TaxRate` = '2.7308' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642219' WHERE `Matrix_Unique_ID` = '214924511' --> Updated record success