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-28T06:14:30.037' ,`MLSNumber` = '5842093' ,`ListAgentFullName` = 'Kiki Baker' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.658434' ,`Longitude` = '-95.455456' ,`PhotoCount` = '18' ,`PostalCode` = '77035' ,`RoomCount` = '3' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Kingfisher' ,`StreetNumber` = '4621' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1461' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lease with option to own also available. Check out this remodeled Willowbrook home on Kingfisher with a flexible wide open space to welcome you in. A completely upgraded kitchen with gracious dining area overlooking the backyard. In the backyard you will find a covered patio with plenty of room for seating and plenty of yard for playing. The play structure can stay or go per Buyer preference (condition cannot be guaranteed). The primary suite is in the rear of the home, also completely updated with designer tile. Two more bedrooms in the home share a hall bath as well. Every appointment must be with a Realtor! If you do not have an agent helping in your search, we are happy to make a match. Flood Zone X (lowest risk) and low tax rate.' ,`Acres` = '0.1728' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Willow Meadows Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 16 WILLOWBROOK SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7525' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'RED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Willowbrook' ,`TaxAmount` = '5809' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652491' WHERE `Matrix_Unique_ID` = '211001515' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T05:07:58.533' ,`MLSNumber` = '5732673' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.829682' ,`Longitude` = '-95.553880' ,`PhotoCount` = '26' ,`PostalCode` = '77043' ,`RoomCount` = '3' ,`ListPrice` = '445995.00' ,`Status` = 'Active' ,`StreetName` = 'Centre Landing' ,`StreetNumber` = '3902' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2308' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous new 3 story home located in the gated, pocket community of Centrepark Terrace. The Rome II plan features 3 bedrooms, 3 full baths & half bath. Valet located off foyer. Flexible activity room with French doors, walk-in closet and bath with shower are also downstairs. Gourmet kitchen has maple cabinets, under cabinet lighting, quartz countertops, gas cooktop & stainless steel appliances that opens into the dining and great room with linear fireplace. Enjoy the view from the 2nd floor balcony. The upstairs owner\'s luxury suite attaches to the owner\'s luxury bath with soaker tub & separate shower, double sinks and walk-in closet. The 3rd floor also has 2 secondary bedrooms with a connected secondary bath. Community walking trail makes it easy to stay active. Great location, near Beltway 8 & I-10 and within minutes of CITYCENTRE, Memorial City Mall, Energy Corridor, parks & restaurants. Must see; schedule a tour today! Offered by: K. Hovnanian Houston III, L.L.C.' ,`Acres` = '' ,`Area` = '24' ,`BuilderName` = 'K. Hovnanian Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'na' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2068' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'TERRACE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING OAKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Centrepark Terrace' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669652491' WHERE `Matrix_Unique_ID` = '212065877' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T06:24:36.250' ,`MLSNumber` = '91259550' ,`ListAgentFullName` = 'Susan Petropolis' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.895285' ,`Longitude` = '-95.675579' ,`PhotoCount` = '48' ,`PostalCode` = '77095' ,`RoomCount` = '10' ,`ListPrice` = '655000.00' ,`Status` = 'Active' ,`StreetName` = 'Copper Lakes' ,`StreetNumber` = '8002' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4540' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous, Custom Built Partners in Building Traditional home nestled in an expansive cul-de-sac yard in Copper Lakes Estates. The sellers have meticulously maintained this lovely home. Imagine entertaining your guests in the large formal dining room that is open to the family room, study, and front foyer with a beautifully curved staircase. After dinner, retreat out back to your own private park for coffee and dessert, complete with a large pool, a fire pit, and a standalone covered gazebo that can double as an outdoor kitchen. This is a family dream home and is a one-of-a-kind property that is extremely rare to find in any neighborhood. The primary bedroom is down complete with an updated bath. Upstairs you will find 3 large bedrooms and 2 full baths, a spacious game room, a stand-alone exercise room, and a small office with a staircase that leads to a loft above. There is an extremely generous amount of storage throughout the home and a 3-car tandem garage.' ,`Acres` = '0.3453' ,`Area` = '8' ,`BuilderName` = 'Partners in Building' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 1 COPPER LAKES SEC 4 AMEND' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '15043' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '915' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'COPELAND ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'LANGHAM CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'ARAGON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Copper Lakes Sec 04 Amd P' ,`TaxAmount` = '10229' ,`TaxRate` = '2.5535' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1669652491' WHERE `Matrix_Unique_ID` = '213853253' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T06:04:38.860' ,`MLSNumber` = '72565254' ,`ListAgentFullName` = 'Charles Pritchett' ,`ListOfficeName` = 'Berkshire Hathaway HomeServicePremier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.581702' ,`Longitude` = '-95.659254' ,`PhotoCount` = '3' ,`PostalCode` = '77479' ,`RoomCount` = '8' ,`ListPrice` = '519750.00' ,`Status` = 'Active' ,`StreetName` = 'Black Oak' ,`StreetNumber` = '2102' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2589' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Immaculate 3 bedroom, 2 bathrooms, 2 car attached garage Sought after One story with high ceilings. Large Primary Suite with double sinks, Separate Shower, and Tub, and Two Large walk-in closets. Over-sized family room perfect for entertaining guests! Surround Sound System included.\r\n\r\nRoll Down Shutters on the exterior rear of the house. \r\n\r\n Recent Interior paint, New Carpets in the Bedrooms, and Study/Extra Room. Recent Laminate Wood Flooring, Perimeter Fencing. One of the largest lots in Telfair, with plenty of room for a pool and sports court.' ,`Acres` = '0.3318' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TELFAIR SEC 6, BLOCK 3, LOT 52' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14455' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'CORNERSTONE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'SARTARTIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Telfair Sec 6' ,`TaxAmount` = '10533' ,`TaxRate` = '2.9144' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652492' WHERE `Matrix_Unique_ID` = '213922535' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T06:43:44.410' ,`MLSNumber` = '61649078' ,`ListAgentFullName` = 'Robyn Davis' ,`ListOfficeName` = 'Main Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.662942' ,`Longitude` = '-95.053587' ,`PhotoCount` = '25' ,`PostalCode` = '77571' ,`RoomCount` = '6' ,`ListPrice` = '310000.00' ,`Status` = 'Active' ,`StreetName` = 'Winburn Tide' ,`StreetNumber` = '527' ,`StreetSuffix` = 'Lane' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1743' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3/2/2 in one of La Porte\'s newest subdivision; Morgan\'s Landing. Open concept, spacious home, neighborhood filled with amenities, fully fenced. Thew patio area in the backyard has been enlarged and is perfect for entertaining your guest. There are no neighbors to the back and the home faces a cul-de-sac. Neighborhood amenities abound - clubhouse, pool, on-site gym, dog park, playground, and lake with surrounding walking trails. Community is private, yet offers quick access to major roads and SH 146. No waiting on the builder or worrying about supply chain disruptions with this gorgeous home! Schedule your private tour today This home is a must see! Does have an assumable loan at just over 4%.' ,`Acres` = '0.1395' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 1 MORGANS LANDING SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6075' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '895' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'JENNIE REID ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Morgans Lndg Sec 5' ,`TaxAmount` = '8002' ,`TaxRate` = '3.5108' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652492' WHERE `Matrix_Unique_ID` = '214120561' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T06:47:59.617' ,`MLSNumber` = '72553502' ,`ListAgentFullName` = 'Jarrah Fulghum' ,`ListOfficeName` = 'Doug Erdy Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.928513' ,`Longitude` = '-95.082287' ,`PhotoCount` = '32' ,`PostalCode` = '77532' ,`RoomCount` = '4' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Windlass' ,`StreetNumber` = '702' ,`StreetSuffix` = 'Way' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2346' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Newport! A great Master Planned community. Amenities in this community are: swimming pools, walking trails, splash pad, parks, tennis courts, golf course community, gym, boat access to Lake Houston, beach access to San Jacinto river, and RV and Boat storage.' ,`Acres` = '0.2479' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 18 NEWPORT SEC 3' ,`LotDesciption` = 'Corner,In Golf Course Community' ,`LotSize` = '10800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'NEWPORT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Newport Sec 03' ,`TaxAmount` = '5853' ,`TaxRate` = '2.7105' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652492' WHERE `Matrix_Unique_ID` = '214286818' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T06:29:48.973' ,`MLSNumber` = '39945738' ,`ListAgentFullName` = 'Allen W. Torans Jr.' ,`ListOfficeName` = 'Southern Spaces Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.410153' ,`Longitude` = '-95.057031' ,`PhotoCount` = '31' ,`PostalCode` = '77568' ,`RoomCount` = '4' ,`ListPrice` = '415000.00' ,`Status` = 'Active' ,`StreetName` = 'Cobalt Cove' ,`StreetNumber` = '13013' ,`StreetSuffix` = 'Court' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2364' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful move in ready home with high ceilings! Complete Kitchen Upgrade with Silestone, Built-in Stainless Steel Appliances, Pendant Lights, Painted Cabinets, and Cabinet Hardware. Plank Tile flooring throughout common areas of the first floor. Smart from the Start’ Technology Package!' ,`Acres` = '0.1148' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 67 BLK 1 LAGO MAR POD 5 SEC 3 (2021) ABST 11' ,`LotDesciption` = 'Other' ,`LotSize` = '5001' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar Pod 5 Sec 3' ,`TaxAmount` = '9245' ,`TaxRate` = '3.5512' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652492' WHERE `Matrix_Unique_ID` = '214394942' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T06:55:09.087' ,`MLSNumber` = '77179330' ,`ListAgentFullName` = 'Susan Heflin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Kenny Hunt' ,`SellingOfficeName` = 'Nuvilla Realty' ,`Latitude` = '29.568683' ,`Longitude` = '-95.022242' ,`PhotoCount` = '23' ,`PostalCode` = '77586' ,`RoomCount` = '10' ,`ListPrice` = '225000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Capri' ,`StreetNumber` = '1833' ,`StreetSuffix` = 'Lane' ,`City` = 'Seabrook' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1679' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Seabrook! 1833 Capri is a gem just waiting to be seen. Once seen you will fall in love with the Miramar area with it\'s great schools, area pool, skate park, walking trails etc. This home features, 4 bedrooms, 2 bath with trendy colors throughout. 1833 hosts new a/c and gas furnace, beautiful hardwood floors and carpet in the bedrooms, beautiful updated lights and fans with granite throughout. I know you can turn this house into a home!' ,`Acres` = '0.1515' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 32 BLK 3 MIRAMAR SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Miramar Sec 01' ,`TaxAmount` = '4071' ,`TaxRate` = '2.2905' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652493' WHERE `Matrix_Unique_ID` = '214519925' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T06:00:56.100' ,`MLSNumber` = '36429528' ,`ListAgentFullName` = 'Isaias Contreras' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = 'Dami Olatunde' ,`SellingOfficeName` = 'Discovered Homes Inv. Inc.' ,`Latitude` = '29.616549' ,`Longitude` = '-95.394319' ,`PhotoCount` = '35' ,`PostalCode` = '77047' ,`RoomCount` = '9' ,`ListPrice` = '375000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Hillock' ,`StreetNumber` = '12531' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2608' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! Stunning 2,608 Sq Ft, 4 bedrooms, and 3 1/2 baths. Exterior boasts beautiful brick & stone elevation and a rare to find front porch with two story entry foyer welcoming you into the home! Upon entry, you are greeted by the formal dining room off of the foyer. Immaculate gourmet kitchen boasts walk-in pantry, granite countertops, stainless steel appliances and a large island. Exquisite two story living room boasts wall of windows creating natural light! Spacious primary retreat with ensuite bathroom is on the main floor. Upstairs features three spacious secondary bedrooms, two bathrooms and a game room/landing area!\r\n\r\nThis home is conveniently located only 15 minutes away from downtown Houston and the medical center.' ,`Acres` = '0.132' ,`Area` = '3' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 4 CITY PARK SOUTH SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5749' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1275' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ALMEDA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'City Park South Sec 4' ,`TaxAmount` = '8819' ,`TaxRate` = '3.0307' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652493' WHERE `Matrix_Unique_ID` = '214613218' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T06:34:27.740' ,`MLSNumber` = '43066188' ,`ListAgentFullName` = 'Margaret Matarazzo' ,`ListOfficeName` = 'Galveston First Realty' ,`SellingAgentFullName` = 'Nellie Zapata' ,`SellingOfficeName` = 'Joe Tramonte Realty, Inc.' ,`Latitude` = '29.320971' ,`Longitude` = '-94.770055' ,`PhotoCount` = '19' ,`PostalCode` = '77550' ,`RoomCount` = '8' ,`ListPrice` = '225000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Ferry' ,`StreetNumber` = '512' ,`StreetSuffix` = 'Road' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1176' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Very nice 4 bedroom 2 bath home located on large fenced in lot. Lots of storage. Located close to UTMB, Coast Guard, Seawall and Beach. Would be a great rental for UTMB students.' ,`Acres` = '0.1511' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOT 3 FERRY ROAD SUB' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6580' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ferry Road Sub 96' ,`TaxAmount` = '1939' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652493' WHERE `Matrix_Unique_ID` = '214647943' --> 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','214746827','1669652493','214746827','2022-11-28T06:25:22.130','92496024','Dayna Simon','BHGRE Gary Greene','','','29.993151','-95.122270','38','77532','8','599900.00','Active','Nogalus','2010','Drive','Crosby','2','1','3','2225','Single-Family','This is a perfect home for enjoying lake living at its finest! This one-story, Lake Houston WATERFRONT home on a double lot in Spanish Cove is located on private street. You\'ll be charmed by the meticulously maintained home w/3 spacious bedrooms, 2 1/2 baths, large dining area & sunroom with amazing lake views & lush landscaping! Family room boasts vaulted ceilings & a cozy fireplace that opens to the updated kitchen w/custom cabinets, granite countertops, stainless appliances, coffee bar w/pot filler, pull-out pantry & bench storage. You\'ll love the large utility room w/extra storage, sink, & 1/2 bath. Home features 3 car garage (one bay/workshop has been converted to a large Game-room) Some updates include: Double pane windows, NEW Water-heater, Home Re-piped with PEX, NEW motor for boat lift, 2014 Bulkhead replaced & boathouse rebuilt. Zoned to Huffman ISD. NEVER FLOODED! Don\'t miss your chance to call this place home!','0.8292','1','','','Electric Dryer Connections,Washer Connections','','Exclusions,Other Disclosures,Sellers Disclosure','1','Gaslog Fireplace','1','Huffman Area','Central Gas,Window Unit','1','LTS 6 & 7 BLK 1 SPANISH COVE SEC 1','Subdivision Lot,Waterfront','36120','Appraisal District','','120','0','','3','Electric Oven','0','','','Gas Cooktop','','Composition','28 - Huffman','HUFFMAN ELEMENTARY SCHOOL (HUFFMAN)','HARGRAVE HIGH SCHOOL','HUFFMAN MIDDLE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Spanish Cove','11340','2.4592','Public Sewer,Public Water','1993','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T06:28:02.447' ,`MLSNumber` = '73737289' ,`ListAgentFullName` = 'Victor Garza' ,`ListOfficeName` = 'MJR Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.686615' ,`Longitude` = '-95.178302' ,`PhotoCount` = '24' ,`PostalCode` = '77502' ,`RoomCount` = '3' ,`ListPrice` = '245900.00' ,`Status` = 'Active' ,`StreetName` = 'Leneva' ,`StreetNumber` = '1705' ,`StreetSuffix` = 'Lane' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1597' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this newly remodeled house! Including new appliances, granite counter tops, water resistant laminate flooring, and completely redone bathrooms. this house is light and bright with neutral colors throughout. new carpeting in bedrooms, and replaced all light fixtures and much more. fresh paint interior & exterior.' ,`Acres` = '0.1818' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 11 BLK 5 WILSHIRE PARK SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7920' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'MAE SMYTHE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SAM RAYBURN HIGH SCHOOL' ,`SchoolMiddle` = 'SOUTHMORE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wilshire Park Sec 01' ,`TaxAmount` = '4535' ,`TaxRate` = '2.6514' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1957' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652493' WHERE `Matrix_Unique_ID` = '214756019' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T05:07:34.993' ,`MLSNumber` = '60176612' ,`ListAgentFullName` = 'Jordan Schilleci' ,`ListOfficeName` = 'Jo & Co. Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.332933' ,`Longitude` = '-95.295379' ,`PhotoCount` = '24' ,`PostalCode` = '77306' ,`RoomCount` = '9' ,`ListPrice` = '318076.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar Crest' ,`StreetNumber` = '17691' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2002' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located on a lot that backs up to a reserve in Cedar Crossing, is this beautiful two-story, 4 bedroom, 2.5-bathroom home boasts an abundance of stunning features. Alta Homes built this new construction home with designer upgrades which include granite countertops, beautiful subway tile backsplash, tray ceilings, luxury vinyl floor planking, and shaker-style kitchen cabinets. On the first floor of this home, you will find the primary bedroom with an ensuite bathroom, large kitchen, vaulted dining, and family room that look out to a beautiful wooded reserve. 2nd floor: 3 bedrooms and bathroom. Exterior features include a fenced-in backyard, covered patio, and 2-car garage. The builder currently offers $8,500 for you to use how you like. LOW TAXES! Call or stop by today!' ,`Acres` = '0.139' ,`Area` = '19' ,`BuilderName` = 'Alta Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 18 Blk 4' ,`LotDesciption` = 'Greenbelt,Subdivision Lot,Wooded' ,`LotSize` = '6052' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cedar Crossing' ,`TaxAmount` = '' ,`TaxRate` = '1.91' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669652494' WHERE `Matrix_Unique_ID` = '214781230' --> 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','214997506','1669652494','214997506','2022-11-28T06:53:31.280','12213669','Penny Ngo','Coldwell Banker Realty','','','29.805507','-95.421999','37','77008','8','725000.00','Active','22nd','1246','Street','Houston','2','1','3','2993','Single-Family','Enjoy Greater Heights living in this 2,993 SF Victorian-style home built by Millennium Patio Homes, located in The Height’s desirable Shady Acres neighborhood. This impressive property features an incredibly charming 3BD/2.5BA with third floor office/study. A RARE find, covered front/back porch, spacious backyard with alleyway access to the detached garage. This home showcases an expansive living/dining room leading to an open gourmet kitchen with granite countertops, gorgeous family room and breakfast area, large pantry, and abundant storage. A bright, open layout greets you with hardwood floors, tall ceilings, custom shutters throughout and XL built-in doggie door. Upstairs, enjoy a spacious owner’s suite with tray ceiling, ensuite bathroom with jetted tub, walk-in shower, wainscoting, built-in cabinetry, plus two secondary bedrooms and third level study. Extensive updates include refinished floors, new carpet, fresh paint, patio ceiling fan, furnace, and HVAC. NEVER FLOODED!','0.1132','9','Millennium Patio Hms','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Heights/Greater Heights','Central Electric,Central Gas','0','LT 4 BLK 1 MILLENNIUM HOMES ON BEVIS','Patio Lot,Subdivision Lot','4930','Appraisal District','','','0','','2','','0','','','Gas Cooktop','','Composition','27 - Houston','SINCLAIR ELEMENTARY SCHOOL (HOUSTON)','WALTRIP HIGH SCHOOL','HAMILTON MIDDLE SCHOOL (HOUSTON)','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','2.5','Victorian','Millennium Homes On Bevis','11280','2.3307','Public Sewer,Public Water','2003','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','215093790','1669652494','215093790','2022-11-28T05:57:11.713','65422688','Luis Cardenas','Keller Williams RealtyNortheast','Michael O\'Neal','Keller Williams RealtyNortheast','29.937914','-95.230419','0','77396','3','200000.00','Option Pending','Sunset Villa','15002','Court','Humble','2','0','3','1464','Single-Family','Beautiful 1 story home located on a quiet low traffic Cul-de-sac!! This home offers a great floor plan with 3 bedrooms, 2 full bathrooms, formal living room, and family room. Primary bedroom features walk in closet. Huge Cul-de-sac lot for entertaining friends and family.','0.1523','1','','','','','Mud,Sellers Disclosure','','','','Humble Area East','Central Gas','1','LT 13 BLK 4 SUNSET RIDGE WEST SEC 1','Cul-De-Sac','6633','Appraisal District','','350','0','','2','','0','','','','','Composition','29 - Humble','AUTUMN CREEK ELEMENTARY SCHOOL','SUMMER CREEK HIGH SCHOOL','AUTUMN RIDGE MIDDLE SCHOOL','Supra Keybox','Appraisal District','1','Traditional','Sunset Ridge West','5230','3.0673','Water District','2006','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','215103343','1669652494','215103343','2022-11-28T06:03:15.013','904078','John Newsom','eXp Realty, LLC','','','29.712868','-95.809648','31','77494','10','599500.00','Active','Downing Park','27014','Boulevard','Katy','3','1','4','3374','Single-Family','Rare find for sale in this section of Cinco Ranch Southwest.','0.1529','36','','','','','Mud,Sellers Disclosure,Tenant Occupied','1','Gaslog Fireplace','1','Katy - Southwest','Central Gas,Zoned','1','CINCO RANCH SOUTHWEST SEC 9, BLOCK 3, LOT 4','Cul-De-Sac','6662','Appraisal District','','1150','0','','2','','0','','','','','Composition','30 - Katy','WILSON ELEMENTARY SCHOOL (KATY)','SEVEN LAKES HIGH SCHOOL','SEVEN LAKES JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','2','Craftsman','Cinco Ranch Southwest Sec 9','14564','2.7845','Public Sewer,Public Water,Water District','2010','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','215110014','1669652494','215110014','2022-11-28T05:36:30.850','95283303','Danielle Flores','Texas United Realty','','','29.943618','-95.684544','18','77433','4','499000.00','Active','Mountain Arbor','18103','Court','Cypress','3','1','4','2835','Single-Family','Welcome home! Come take a look at this immaculate gem sitting on a large corner lot in the heart of Cypress, Tx at Adler Trails! This beautiful 4-bedroom home features soaring ceilings and large energy efficient windows that allow natural light to flow throughout the home along with the privacy of having no back neighbors. This home features a large backyard patio, epoxied/ AC\'ed garage, and a huge entertainment game room upstairs. \r\nYou’ll enjoy the back patio both morning and night, so bring your coffee and wine, and make this house your home.','0.1844','25','','','Electric Dryer Connections','','Mud,Sellers Disclosure','1','','1','Cypress South','Central Electric','1','LT 1 BLK 1 ALDER TRAILS SEC 11','Subdivision Lot','8031','Appraisal District','','950','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','13 - Cypress-Fairbanks','WOODARD ELEMENTARY SCHOOL','CYPRESS RANCH HIGH SCHOOL','SPILLANE MIDDLE SCHOOL','Accompany,Appointment Required,Request Online Appointment,Supra Keybox','Appraisal District','2','Traditional','Alder Trls Sec 11','11739','2.711','Water District','2018','Appraisal District'); --> New record created successfully