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-09T15:08:40.723' ,`MLSNumber` = '59715297' ,`ListAgentFullName` = 'Kyle Pryor' ,`ListOfficeName` = 'Pryor Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.395491' ,`Longitude` = '-95.688556' ,`PhotoCount` = '35' ,`PostalCode` = '77356' ,`RoomCount` = '4' ,`ListPrice` = '445000.00' ,`Status` = 'Active' ,`StreetName` = 'Abner' ,`StreetNumber` = '163' ,`StreetSuffix` = 'Lane' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2457' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3 car garage one story. Very open floor plan on a large lot. 3 bedroom & study. Ceramic tile floors thru whole house except for bedrooms. Granite counter tops both baths & kitchen. Very open floor plan. Located in Montgomery schools. Low tax rate & low HOA dues! view virtual tour, 3D image. & pics.' ,`Acres` = '0.3299' ,`Area` = '39' ,`BuilderName` = 'Camillo Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Montgomery County Northwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S456900 - ESTATES OF LAKE CREEK VILLAGE, BLOCK 1, LOT 1' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '14369' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Estates Of Lake Creek Village' ,`TaxAmount` = '' ,`TaxRate` = '2.2698' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675089168' WHERE `Matrix_Unique_ID` = '204860578' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-09T16:11:10.293' ,`MLSNumber` = '48497086' ,`ListAgentFullName` = 'Pamela Castello' ,`ListOfficeName` = 'Comiskey Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.293468' ,`Longitude` = '-94.915030' ,`PhotoCount` = '33' ,`PostalCode` = '77554' ,`RoomCount` = '3' ,`ListPrice` = '849672.00' ,`Status` = 'Active' ,`StreetName` = 'Lanai' ,`StreetNumber` = '114' ,`StreetSuffix` = 'Street' ,`City` = 'Tiki Island' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1940' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Bay View Swimming Pool 3 Car Garage Storm Shutters, Fantastic View of Bay not being on the bay! Boat Lift drives straight in, Jet Ski lift for 2. Come and enjoy one of the best sought after areas of Galveston, Tiki Island you can Fish from you back yard. Bring you swimsuits and fishing poles it is ready for you to enjoy your summer.' ,`Acres` = '0.149' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tiki Island' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 7 S C BUNDICK SUR LOT 83 TIKI ISLAND' ,`LotDesciption` = 'Cleared,Subdivision Lot,Waterfront' ,`LotSize` = '6490' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HITCHCOCK PRIMARY/STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HITCHCOCK HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (HITCHCOCK)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Tiki Island' ,`TaxAmount` = '13439' ,`TaxRate` = '2.4912' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675089168' WHERE `Matrix_Unique_ID` = '209154140' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-09T15:26:56.390' ,`MLSNumber` = '31693916' ,`ListAgentFullName` = 'Daisy Lopez' ,`ListOfficeName` = 'Move Up America' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.014155' ,`Longitude` = '-95.782819' ,`PhotoCount` = '16' ,`PostalCode` = '77447' ,`RoomCount` = '7' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Broadleaf Oak' ,`StreetNumber` = '17202' ,`StreetSuffix` = 'Drive' ,`City` = 'Hockley' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2432' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The San Francisco is a 2 story / 4 bedroom / 3.5 baths / formal dining / 2 car -attached garage / covered patio. This beautiful home has wood look tile flooring with Maple Rye cabinets and Santa Cecilia Light granite in the kitchen. This home has modern black plumbing fixtures, with Matte Black cabinet hardware. Decorative tiles in the bathrooms and an irrigation system for the yard. Home is available for immediate move-in!' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Chesmar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot:43 Block:1 Section:10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Dellrose' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675089168' WHERE `Matrix_Unique_ID` = '210036169' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-09T16:28:40.127' ,`MLSNumber` = '74867043' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.746151' ,`Longitude` = '-95.512334' ,`PhotoCount` = '31' ,`PostalCode` = '77320' ,`RoomCount` = '4' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Simmons' ,`StreetNumber` = '3001' ,`StreetSuffix` = 'Street' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2096' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This pristine 4/2.5 1-story home is priced to sell and won\'t last long! The family room boasts a brick wood burning fireplace, hardwood floors, and an open concept that seamlessly transitions into the breakfast room and kitchen area. The kitchen boasts granite countertops, a gas cooktop, double ovens, breakfast bar and ample cabinetry and counter space. The primary bedroom is oversized and flaunts a private en-suite bath and a vanity area. Additionally, one of the secondary bedrooms features a half bath + built-in shelving. Exterior features include 0.4 acres of cleared and unrestricted land, 2-car detached garage, and partial fencing. Recent upgrades also include a new AC unit, ducts, etc. This home is priced to sell and won\'t last long. Schedule a private tour today!' ,`Acres` = '0.4' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'BOBO F (A-74), TRACT 30.1, ACRES .4' ,`LotDesciption` = 'Cleared,Other' ,`LotSize` = '17424' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'SCOTT JOHNSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'N/A' ,`TaxAmount` = '2864' ,`TaxRate` = '1.9609' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675089169' WHERE `Matrix_Unique_ID` = '211865810' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-09T16:16:10.960' ,`MLSNumber` = '9922706' ,`ListAgentFullName` = 'Heather Perry' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.745688' ,`Longitude` = '-94.848991' ,`PhotoCount` = '23' ,`PostalCode` = '77523' ,`RoomCount` = '11' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Mccollum Park' ,`StreetNumber` = '8710' ,`StreetSuffix` = 'Road' ,`City` = 'Beach City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2064' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! This 4/5 Bedroom - 3 Bath home sits on 3 Acres tucked away in Beach City! Home Has many updates, which includes New Roof, New 5 ton A/C, Granite Counters, Hickory Cabinets in Kitchen, Second Primary Bedroom, New flooring in majority of Home. Home has a open concept with high ceilings and plenty of room for entertainment. Property has a 1200 sq ftt shop fully insulated, electric and plumbing in place which is ready for a restroom. Property also has several fruit trees! Fully Fenced which has been recently replaced. Pool included with built on deck. Come tour today ad be in before the Holidays!' ,`Acres` = '3' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '3 TR 43A-1-3 S BARROW' ,`LotDesciption` = 'Other' ,`LotSize` = '130680' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Solomon Barrow League' ,`TaxAmount` = '5982' ,`TaxRate` = '1.7058' ,`WaterSewer` = 'Aerobic,Septic Tank' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675089169' WHERE `Matrix_Unique_ID` = '214411521' --> 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','215292209','1675089169','215292209','2022-12-09T16:46:49.083','87117338','Dinah Wicker','Texas Team Real Estate','','','28.984961','-95.368964','25','77541','10','227000.00','Active','Avenue T','1813','','Freeport','1','0','3','1315','Single-Family','This \"ready to move into home has two family rooms to enjoy. The dining area is located in front with a beautiful window that offers great views while dining or working from home. The roomy kitchen has space for more than one chef with lots of cabinets and areas for storage. There are more shelves in the utility room just off the kitchen. Enjoy three nice sized bedrooms, one with a built-in desk. There is a nice bathroom with tub and multi-head shower. As a bonus, there is a nice garage apartment or \"she shed/man cave\" connected to the garage. This apartment has its own bathroom and small kitchen. A fenced, separate area in the backyard to keep your pets or grow a garden away from little feet. Privacy surrounds this backyard where you can enjoy your stone, free standing firepit and ground fire pit area. Owner has installed new A/C complete with new insulation and duct work, new roof, fresh paint, two hot water heaters and landscaping.','0.2152','5','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','0','Freeport','Central Electric','0','VELASCO (FREEPORT), BLOCK 813, LOT 18-19-20','Subdivision Lot','9374','Appraisal District','','','0','','1','Electric Oven,Freestanding Oven','0','','','Freestanding Range','','Composition','7 - Brazosport','VELASCO ELEMENTARY SCHOOL','BRAZOSPORT HIGH SCHOOL','FREEPORT INTERMEDIATE SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Ranch','Velasco Freeport','2451','2.5981','Public Sewer,Public Water','1955','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','215340179','1675089169','215340179','2022-12-09T16:33:05.973','97042648','Jennifer Grande','Grand Realty','','','29.369297','-94.958295','32','77568','6','189900.00','Active','Ross','840','Street','La Marque','2','0','3','1080','Single-Family','Beautiful updated home, with 4 car detached garage - previously used for a workshop! Oversized lot, with all new flooring, brand new kitchen with new appliances. New 2 Full bathrooms with all new plumbing and electrical. Roof from 2012 and new windows from 2013. Come check out today!','0.2754','33','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Owner/Agent','1','','','La Marque','Central Gas','0','ABST 150 J D MOORE SUR LOTS 9 & 10 BLK 2 MCNEELS SUB','Cleared,Subdivision Lot','12000','Appraisal District','','','0','','4','Electric Oven,Freestanding Oven','0','','','Electric Cooktop','','Composition','52 - Texas City','HAYLEY ELEMENTARY SCHOOL','LA MARQUE HIGH SCHOOL (TEXAS CITY)','LA MARQUE MIDDLE SCHOOL (TEXAS CITY)','Appointment Required','Appraisal District','1','Traditional','Mcneels','1713','2.4627','Public Sewer,Public Water','1930','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','215356786','1675089169','215356786','2022-12-09T15:41:06.020','7484493','Alicia Richards','GoUpRE','','','29.842060','-95.395050','7','77022','7','289900.00','Active','E BURRESS','5206','','Houston','1','0','3','1100','Single-Family','Built by Award Winning Custom Builder, Legion Custom Home Builders. This community will consist of 19 homes with two different floor plans. There will be 10 homes with 3 stories and 9 homes with 2 stories. 3 story homes have an average yard size of 30\' X 14\'. 2 story homes have an average yard size of 20\' X 10\'. 1st phase of construction has begun, and estimated completion date is March 2023. Quiet area with quick freeway access. Easy access to downtown, medical center and heights. This home qualifies for 0 DP and no PMI!','','9','LEGION BUILDERS','','','','No Disclosures','1','','','Northwest Houston','Central Gas','1','LOT 18 BLOCK 1 GARDEN ACRES LANDING','Patio Lot,Subdivision Lot','','','','1600','1','To Be Built/Under Construction','2','','0','','','','','Composition','27 - Houston','HIGHLAND HEIGHTS ELEMENTARY SCHOOL','WASHINGTON HIGH SCHOOL','WILLIAMS MIDDLE SCHOOL','Appointment Required','Builder','2','Contemporary/Modern','GARDEN ACRES LANDING','','','Public Sewer,Public Water','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215358784','1675089169','215358784','2022-12-09T15:20:15.277','59305782','Noe Hernandez','Vive Realty LLC','','','29.876196','-95.314973','42','77093','6','360000.00','Active','Cedar Hill','5018','Lane','Houston','3','0','6','3540','Single-Family','Spectacular home located in the Darden Place Subdivision in Aldine area Houston! This home has 6 bedrooms and 3 wonderful bathrooms!! Enter the home and you\'ll see personality from the start! Home is equipped with a magnificent open free flowing floor plan. Attached/Detached Carport has enough room for 2 cars! Gorgeous flooring throughout. Lots of natural sunlight and lovely white finished paint! Clean-lined kitchen comes with plush matching appliances, matching backsplash and counter tops, open storage and a large sink! Comfortable master bedroom! Master bathroom has phenomenal ample sized stand up shower with amazing tile! All rooms are upstairs and are accompanied by carpet and lovely neutral paint. Call today to schedule a showing on this glorious home!!!','0.1436','2','','','','','Sellers Disclosure','','','','Aldine Area','Central Electric','0','LT 87 DARDEN PLACE','Subdivision Lot','6254','Appraisal District','','','0','','0','','0','','','','','Composition','1 - Aldine','ESCAMILLA ELEMENTARY SCHOOL','MACARTHUR HIGH SCHOOL (ALDINE)','HAMBRICK MIDDLE SCHOOL','Lockbox Front','Appraisal District','2','Traditional','Darden Place','4197','2.1553','Public Sewer,Public Water','2019','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215379837','1675089169','215379837','2022-12-09T15:32:44.523','51432131','Daisy Lopez','Move Up America','','','30.016022','-95.784575','19','77447','4','317715.00','Active','Balsam Hawk','31219','Lane','Hockley','2','0','3','1518','Single-Family','\"The Charleston is a 1 story / 3 bedroom / 2 baths / 2 car attached garage / Covered Patio\r\n\r\nUpgrades to the home include GE stainless steel appliances including dishwasher, range, and microwave. This astonishing home has Linen (white) cabinets throughout whole home with modern black lighting fixtures and black plumbing fixtures throughout whole home. The home has beautiful wood look tile flooring except in the bedrooms. The kitchen has Shell White Quartz counter tops, upgraded kitchen backsplash, under kitchen cabinet lighting, and black Zaily Pendants. The Home has upgraded carpet, an irrigation system for the yard, and an electronic front door lock.','','35','Chesmar Homes','','Electric Dryer Connections','','No Disclosures','1','','0','Hockley','Central Gas','1','Lot:12 Block:3 Section:10','Subdivision Lot','','Other','','1000','1','To Be Built/Under Construction','2','','0','','','','','Composition','55 - Waller','ROBERTS ROAD ELEMENTARY SCHOOL','WALLER HIGH SCHOOL','WALLER JUNIOR HIGH SCHOOL','Leave Business Card','Builder','1','Traditional','Dellrose','','3.68','Public Sewer,Public Water,Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215426779','1675089169','215426779','2022-12-09T16:59:09.347','91544744','Alex Lopez','Liv Texas','','','30.085618','-96.069812','15','77445','4','320000.00','Active','2nd','2036','Street','Hempstead','2','0','4','1871','Single-Family','This lovely home includes a spacious backyard with a covered patio. Featuring four bedrooms, this open-concept home boasts tray ceilings through the entryway and beautiful ceramic flooring and high ceilings throughout the main living areas. The kitchen is open to both the family room and dining area and contains a large island with sleek countertops that make entertaining your guests a pleasure. With designer finishes and plenty of windows for natural light, this gorgeous home is built to provide a brighter lifestyle. Schedule your showing today!','0.2152','26','Ponce\'s Hometown','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','','','','Hempstead','Central Electric','0','S519000 HEMPSTEAD BLK 496 LOT S/2 OF 4 & ALL OF 5','Corner','9374','Appraisal District','','','1','Never Lived In','2','Electric Oven','0','','','Electric Range','','Composition','24 - Hempstead','HEMPSTEAD ELEMENTARY SCHOOL','HEMPSTEAD HIGH SCHOOL','HEMPSTEAD MIDDLE SCHOOL','Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied','Builder','1','Contemporary/Modern','Hempstead','571','2.4184','Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215446832','1675089169','215446832','2022-12-09T15:51:00.207','95645523','Raquel Ginebra','HomeSmart','','','29.833512','-95.456684','33','77092','3','428000.00','Active','Lido','4322','Lane','Houston','2','0','3','1479','Single-Family','Newly updated home! Beautiful modern look with an open concept floor plan. New luxury laminate vinyl plank flooring, new cabinets, and new granite! NEW ROOF! NEW WINDOWS! NEW WATER HEATER! 3 NEW APPLIANCES! Gorgeous on the exterior as well as inside. You will not want to miss this Houston gem!','0.1653','9','','','','','Sellers Disclosure','','','','Oak Forest West Area','Central Electric','0','LT 18 BLK 14 OAK FOREST SEC 15','Subdivision Lot','7200','Appraisal District','','','0','','0','','0','','','','','Composition','27 - Houston','SMITH ELEMENTARY SCHOOL (HOUSTON)','SCARBOROUGH HIGH SCHOOL','CLIFTON MIDDLE SCHOOL (HOUSTON)','Appointment Required,Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Traditional','Oak Forest Sec 15','6012','2.3307','Public Sewer,Public Water','1954','Appraisal'); --> 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','215488002','1675089169','215488002','2022-12-09T15:12:37.960','14499784','Jerry Walker','eXp Realty, LLC','','','30.497616','-95.491059','46','77378','6','675000.00','Active','Highway 75','17741','','Willis','2','0','3','1416','Single-Family','AWESOME OPPORTUNITY! - NORTH MONTGOMERY COUNTY! Beautiful +/- 3 UNRESTRICTED ACRES in Willis TX! Here you have 472 feet of HIGHWAY 75 ROAD FRONTAGE! Plus approx. 1416 Sq.Ft. single family home with a 2 car garage. Minutes from I-45 and the New Willis HEB/shopping center! EXPERIENCE THE AREA GROWTH! Willis is being developed by some of the top developers that will make Willis a wonderful destination place to live and grow with its close proximity to area resorts and Lake Conroe.','3.043','19','','','','','Sellers Disclosure','','','','Willis Area','Central Electric','0','A0023 LINDLEY SAMUEL, TRACT 51, ACRES 3.043','Cleared','132553','Appraisal District','','','0','','2','','0','','','','','Composition','56 - Willis','PARMLEY ELEMENTARY SCHOOL','WILLIS HIGH SCHOOL','LYNN LUCAS MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Ranch,Traditional','LINDLEY SAMUEL','1554','1.8448','Public Water,Septic Tank','1972','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','215489765','1675089169','215489765','2022-12-09T15:40:02.920','73162959','Alicia Richards','GoUpRE','','','29.842060','-95.395050','7','77022','7','339900.00','Active','E BURRESS','5207','','Houston','2','0','3','1600','Single-Family','Built by Award Winning Custom Builder, Legion Custom Home Builders. This community will consist of 19 homes with two different floor plans. There will be 10 homes with 3 stories and 9 homes with 2 stories. 3 story homes have an average yard size of 30\' X 14\'. 2 story homes have an average yard size of 20\' X 10\'. 1st phase of construction has begun, and estimated completion date is March 2023. Quiet area with quick freeway access. Easy access to downtown, medical center and heights. This home qualifies for 0 DP and no PMI!','','9','LEGION BUILDERS','','','','No Disclosures','1','','','Northwest Houston','Central Gas','1','LOT 2 BLOCK 1 GARDEN ACRES LANDING','Patio Lot,Subdivision Lot','','','','1600','1','To Be Built/Under Construction','2','','0','','','','','Composition','27 - Houston','HIGHLAND HEIGHTS ELEMENTARY SCHOOL','WASHINGTON HIGH SCHOOL','WILLIAMS MIDDLE SCHOOL','Appointment Required','Builder','3','Contemporary/Modern','GARDEN ACRES LANDING','','','Public Sewer,Public Water','2023','Builder'); --> New record created successfully