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-10-30T07:12:35.297' ,`MLSNumber` = '47664485' ,`ListAgentFullName` = 'Christi Parham' ,`ListOfficeName` = 'RE/MAX Opportunities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.483663' ,`Longitude` = '-95.801821' ,`PhotoCount` = '46' ,`PostalCode` = '77469' ,`RoomCount` = '10' ,`ListPrice` = '649000.00' ,`Status` = 'Active' ,`StreetName` = 'Pleak' ,`StreetNumber` = '6104' ,`StreetSuffix` = 'Road' ,`City` = 'Pleak' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '3861' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well known and respected home builder Irvin Meyer\'s personal home with many custom touches and his outstanding eye for the details that make every home he built a piece of art. Gorgeous Terrazzo flooring and original hardwoods welcome you into this beautiful home. Large open living space is perfect for entertaining family and friends. Updated HVAC system with high energy efficient system. 3 spacious bedrooms with a study or you can turn the study into a bedroom. Storage galore throughout the whole house. Custom woodwork and built-ins. Brick fireplace. 60x30 workshop allows you to run your business out of your home with no deed restrictions. Call today for your personal tour.' ,`Acres` = '1.218' ,`Area` = '30' ,`BuilderName` = 'Irvin Meyer' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = '0090 C B STEWART, TRACT 26, ACRES 1.218' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '53056' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CULVER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'C B Stewart' ,`TaxAmount` = '9753' ,`TaxRate` = '1.7948' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145691' WHERE `Matrix_Unique_ID` = '207201740' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T06:58:15.293' ,`MLSNumber` = '16914471' ,`ListAgentFullName` = 'Kim Shoquist' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.945401' ,`Longitude` = '-96.252858' ,`PhotoCount` = '14' ,`PostalCode` = '77418' ,`RoomCount` = '8' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'LIVE OAK' ,`StreetNumber` = '236' ,`StreetSuffix` = 'Street' ,`City` = 'Bellville' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1576' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1938 charming home which has an updated kitchen and bath. Third bedroom could be an office/playroom. Extra bonus room used for family/game room or master bedroom. Picket fence adorns the backyard and wooden patio offers plenty of room to enjoy sitting outdoors. A side covered patio off of the den offers a nice quiet place to read or enjoy the sounds of Bellville. Located within walking distance to the elementary school, close to downtown, churches and shopping. If you are looking for a nice home, come review this home.' ,`Acres` = '0.17' ,`Area` = '57' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A073 J NICHOLS' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '136 - Bellville' ,`SchoolElementary` = 'WEST END ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'BELLVILLE JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'br300.fa' ,`TaxAmount` = '' ,`TaxRate` = '2.11' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1938' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145691' WHERE `Matrix_Unique_ID` = '210036872' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T07:31:39.340' ,`MLSNumber` = '57134313' ,`ListAgentFullName` = 'Barbara Bullock' ,`ListOfficeName` = 'Brockway Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.599093' ,`Longitude` = '-95.117283' ,`PhotoCount` = '47' ,`PostalCode` = '77059' ,`RoomCount` = '8' ,`ListPrice` = '274900.00' ,`Status` = 'Active' ,`StreetName` = 'Cavendish' ,`StreetNumber` = '15907' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1832' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DON\'T MISS YOUR OPPORTUNITY TO TOUR AND OWN THIS WELL TAKEN CARE OF, GREATLY LOVED, BEAUTIFULLY UPDATED, 3/2/2 WITH OFFICE (TEXAS BASEMENT) AND LARGE LAUNDRY ROOM IN HOUSE! IN THE WONDERFUL, SOUGHT AFTER COMMUNITY OF CLEAR LAKE CITY. HOME HAS NEW PAINT, COUNTERTOPS, BLINDS, LUXURY VINYL PLANK FLOORING, COZY FIREPLACE, LARGE, FULLY FENCED BACK YARD WITH COVERED PATIO AND HURRICANE CLIPS, NEW PEX PLUMBING THROUGHOUT. LOW TAX RATE AND LOW HOA! MOVE IN READY! NO FOUNDATION ISSUES!! ROOF HAS 30 YEAR SHINGLES AND 15 YEARS LEFT OF LIFE PER CONTRACTOR! SUBDIVISION HAS AN AREA POOL, RECREATIONAL FACILITY AND PLAYGROUND. SCHEDULE TO VIEW TODAY!! NEVER FLOODED!! ZONE X NO MANDATORY FLOOD INSURANCE REQUIRED BY LENDER.' ,`Acres` = '0.169' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 30 MIDDLEBROOK SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7360' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '455' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ARMAND BAYOU ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Middlebrook Sec 02' ,`TaxAmount` = '4973' ,`TaxRate` = '2.5769' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145692' WHERE `Matrix_Unique_ID` = '210631647' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T06:45:32.057' ,`MLSNumber` = '59235807' ,`ListAgentFullName` = 'Richard Blount' ,`ListOfficeName` = 'The Cameran Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.323477' ,`Longitude` = '-95.453161' ,`PhotoCount` = '49' ,`PostalCode` = '77583' ,`RoomCount` = '10' ,`ListPrice` = '680000.00' ,`Status` = 'Active' ,`StreetName` = 'Lakeland' ,`StreetNumber` = '202' ,`StreetSuffix` = 'Circle' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3736' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '25 Minutes from Surf Side, 15 Minutes from Pearland Town Center, 35 Minutes from Houston. Wow! Spa and Outdoor Kitchen on the Lake. What a life! Every inch of this beautiful home on acreage has been completely remodeled in 2019. Gourmet kitchen features island, quartz countertops and fairly new high end appliances. Primary bedroom downstairs is large and features his and hers walk-in closets. Spa-like master bath must be seen to be believed, with quartz counters, amazing tile work and new frameless shower. Three additional bedrooms upstairs, including one with it\'s own on-suite bath that could be a second primary. Game room upstairs provides plenty of room for activities, and there are two staircases for easy access.' ,`Acres` = '1' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rosharon' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'THE OAKS AT SUNCREEK ESTATES (A0067 & A0068 & A0069) BLK 5 L' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'FRONTIER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'The Oaks At Suncreek Estates' ,`TaxAmount` = '8098' ,`TaxRate` = '1.986' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145692' WHERE `Matrix_Unique_ID` = '211303279' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T07:42:48.323' ,`MLSNumber` = '19154952' ,`ListAgentFullName` = 'Michael Parker' ,`ListOfficeName` = 'Phyllis Foster Real Estate Ser' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.508604' ,`Longitude` = '-95.192224' ,`PhotoCount` = '47' ,`PostalCode` = '77546' ,`RoomCount` = '8' ,`ListPrice` = '519400.00' ,`Status` = 'Active' ,`StreetName` = 'Regency' ,`StreetNumber` = '505' ,`StreetSuffix` = 'Court' ,`City` = 'Friendswood' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3476' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come tour this 3476 square foot 5 Bedroom 4 Full bath home w/ 3 car detached garage.Upon entering the home you are greeted by a spacious dining room on the left.The kitchen offers ample countertop and storage space. Main living area, kitchen, breakfast room, utility room have been updated with wood laminate.Breakfast room adjoins the kitchen.Oversized utility room with separate plug for extra refrigerator/freezer. Family room has four large bay windows that offer natural light with gas fireplace.One bedroom/study down with full bath. The oversized primary suite includes a sitting area. Primary bath with separate shower and tub along with double sinks and oversized primary closet. Secondary bedrooms all have walk in closets. Game room upstairs. Upon entering the back yard, you are greeted by your own tropical oasis. The large pool is great for all those hot summer days. Recent improvements include wood laminate in main living areas,recent paint inside/outside, hardy board,A/C,pool pump.' ,`Acres` = '0.2598' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 151 PAGE 7 LOT 26 BLK 1 SUNWOOD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11318' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '175' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '20 - Friendswood' ,`SchoolElementary` = 'CLINE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FRIENDSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'FRIENDSWOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunwood 91' ,`TaxAmount` = '8130' ,`TaxRate` = '2.2832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145692' WHERE `Matrix_Unique_ID` = '211976364' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T06:43:05.700' ,`MLSNumber` = '59158108' ,`ListAgentFullName` = 'Kelly Kelley' ,`ListOfficeName` = 'RE/MAX Leading Edge' ,`SellingAgentFullName` = 'Brittany Cassin' ,`SellingOfficeName` = 'Compass RE Texas, LLC' ,`Latitude` = '29.219974' ,`Longitude` = '-94.936790' ,`PhotoCount` = '50' ,`PostalCode` = '77554' ,`RoomCount` = '8' ,`ListPrice` = '1625000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Moyenne' ,`StreetNumber` = '13419' ,`StreetSuffix` = 'Place' ,`City` = 'Galveston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2834' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Sprawling waterfront home has been expertly crafted for the avid entertainer whether you want to sip cocktails poolside, take in a stunning sunset from your gazebo or take the boat out for a day on the water. Impressive open floor plan includes a sprawling living area, separate dining, gourmet kitchen, office/den & 4 large bedrooms with 4 full bathrooms. Lower level houses the entertainment hub with plenty of room for gathering with friends & family poolside, sidle up to the built-in bar, relax by the fire pit or dine outdoors on warm summer nights. Up above a jetty takes you past the glistening pool & down to your gazebo. Perfect place to relax with a glass of wine at the end of a long day out on the boat. A boat lift is housed below along with a charming deck where you can sit with your morning coffee & watch the canal come to life as the boaters take just minutes to get to West Bay. Freshly painted interior. This must see home conveys furnished.' ,`Acres` = '0.3868' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 PAGE 44 LOT 5 BLK 6 PIRATES COVE SEC 6 REPLAT' ,`LotDesciption` = 'In Golf Course Community,Water View,Waterfront' ,`LotSize` = '16850' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '765' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Laffites Cove' ,`TaxAmount` = '' ,`TaxRate` = '2.03' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145692' WHERE `Matrix_Unique_ID` = '212093495' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T07:47:00.230' ,`MLSNumber` = '87912637' ,`ListAgentFullName` = 'Brandon Dunbar' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.887828' ,`Longitude` = '-95.606979' ,`PhotoCount` = '30' ,`PostalCode` = '77041' ,`RoomCount` = '8' ,`ListPrice` = '208000.00' ,`Status` = 'Active' ,`StreetName` = 'Fountaincrest' ,`StreetNumber` = '7510' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1344' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THIS ONE-OF-A-KIND PATIO HOME IS A MUST-SEE!! This 2-3/2 home is nestled into the prestigious Chimney Hill subdivision. The home has high ceilings and a large living room area that you and your family could enjoy. The home has a unique upstairs bedroom/home office/game room adding more living space and possibilities! Super easy access to HWY 290. The furniture seen in the home is all negotiable with the sale of the home. A refrigerator/Washer/Dryer comes with the home!' ,`Acres` = '0.1188' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 2 CHIMNEY HILL SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5175' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '381' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HAIRGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'LABAY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Left Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Mediterranean' ,`Subdivision` = 'Chimney Hill Sec 05' ,`TaxAmount` = '4174' ,`TaxRate` = '2.811' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145692' WHERE `Matrix_Unique_ID` = '212666702' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T07:25:57.767' ,`MLSNumber` = '25581412' ,`ListAgentFullName` = 'Thomas Richardson' ,`ListOfficeName` = 'Worrall Properties' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '29.784961' ,`Longitude` = '-95.443672' ,`PhotoCount` = '21' ,`PostalCode` = '77055' ,`RoomCount` = '5' ,`ListPrice` = '945000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Dunleigh Meadows' ,`StreetNumber` = '862' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3270' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 4-story canal front, corner lot home. The home features Thermador Appliances, whole home audio, a spacious designer primary closet, Epoxy garage floors, elevator to all floors, and plantation shutters. Sip on coffee and enjoy the view of the beautiful water features from one of the three balconies. The gated community of Somerset Green includes walking trails, dog parks, parks for children, a lake, and a large inviting pool. Conveniently located just minutes from Downtown, River Oaks and Memorial. Make an appointment to come see this gorgeous home.' ,`Acres` = '0.0459' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Timbergrove/Lazybrook' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 1 SOMERSET GREEN SEC 4' ,`LotDesciption` = 'Corner,Water View,Waterfront' ,`LotSize` = '2001' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2625' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '4' ,`Style` = 'English' ,`Subdivision` = 'Somerset Green Sec 4' ,`TaxAmount` = '21637' ,`TaxRate` = '2.8307' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145693' WHERE `Matrix_Unique_ID` = '212705704' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T06:43:08.273' ,`MLSNumber` = '32539381' ,`ListAgentFullName` = 'Kevin King' ,`ListOfficeName` = 'RE/MAX ONE - Premier' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819356' ,`Longitude` = '-95.071064' ,`PhotoCount` = '34' ,`PostalCode` = '77562' ,`RoomCount` = '9' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Hampton' ,`StreetNumber` = '307' ,`StreetSuffix` = 'Court' ,`City` = 'Highlands' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2147' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for a move-in ready 4 bedroom home in an established neighborhood within walking distance to tennis courts, walking track, splash pad, pavilion, playground and Highlands Community Center? Look no further because this is the home for you. 1 owner home with a split floorplan, all tile flooring, fireplace, formal dining and located on a Cul-de-sac street. Close to shopping and I-10. Community also has a boat ramp for access to the San Jacinto River. This home is a must see.' ,`Acres` = '0.1584' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 4 HIGHLAND WOODS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '212' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'HOPPER/HIGHLANDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland Woods Sec 02' ,`TaxAmount` = '4995' ,`TaxRate` = '2.575' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145693' WHERE `Matrix_Unique_ID` = '212937920' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T07:34:38.117' ,`MLSNumber` = '77019356' ,`ListAgentFullName` = 'Dana Johnson' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.757959' ,`Longitude` = '-95.555694' ,`PhotoCount` = '30' ,`PostalCode` = '77042' ,`RoomCount` = '7' ,`ListPrice` = '825000.00' ,`Status` = 'Active' ,`StreetName` = 'Shady River' ,`StreetNumber` = '10314' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3101' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great opportunity to make your home in Briargrove Park, with shopping and restaurants only minutes away. Easy access to Beltway 8, I-10, and Westpark Tollway. This lovely traditional home has brick exterior with a detached 2 car garage, covered patio and beautiful pool. The family room has a beautiful open concept. The home has 4 bedrooms, 2 ½ baths, formal living room, formal dining room, separate breakfast room, wet bar, storage and closets galore, and walls of windows overlooking a sparkling pool and spacious covered patio. Great bones in this original construction to make your own!' ,`Acres` = '0.2877' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Briargrove Park/Walnutbend' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 899 BLK 32 BRIARGROVE PARK SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12531' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '685' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WALNUT BEND ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Briargrove Park Sec 01' ,`TaxAmount` = '16294' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145693' WHERE `Matrix_Unique_ID` = '213166447' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T06:22:00.757' ,`MLSNumber` = '70922387' ,`ListAgentFullName` = 'Michelle Schlentz' ,`ListOfficeName` = 'Michelle Schlentz, Broker' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.658180' ,`Longitude` = '-95.090230' ,`PhotoCount` = '29' ,`PostalCode` = '77571' ,`RoomCount` = '4' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Desert Run' ,`StreetNumber` = '3638' ,`StreetSuffix` = 'Drive' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2715' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nicely located between Fairmont Pkwy and Spencer Hwy with easy access to Hwy 225 and Beltway 8. 3 bedrooms with an additional den/game room with closets for optional large 4th bedroom, 2 baths. Master suite has separate shower and tub with his and her sinks. Formal dining room and additional office make study or work from home easy. Additional bedrooms are a nice size with great closet space. Enjoy your mornings or evenings in the backyard under the covered patio. Roof is 2 years old. Call today to schedule your private showing. Make this your home today!' ,`Acres` = '0.1791' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 1 SUMMER WINDS SEC 3 AMEND' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'HERITAGE ELEMENTARY SCHOOL (LA PORTE)' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Colonial,Ranch' ,`Subdivision` = 'Summer Winds Sec 3' ,`TaxAmount` = '7561' ,`TaxRate` = '2.7208' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145693' WHERE `Matrix_Unique_ID` = '213192462' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T07:55:56.520' ,`MLSNumber` = '87491079' ,`ListAgentFullName` = 'Jean Jabbour' ,`ListOfficeName` = 'Jabbour Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.602357' ,`Longitude` = '-95.481943' ,`PhotoCount` = '18' ,`PostalCode` = '77489' ,`RoomCount` = '3' ,`ListPrice` = '229000.00' ,`Status` = 'Active' ,`StreetName` = 'Summer Ridge' ,`StreetNumber` = '6418' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1644' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A BEAUTIFULLY REMODELED HOUSE, WITH ALL NEW ROOF, PLYWOOD, FACIAL, NEW FLOORING, NEW KITCHEN, NEW APPLIANCES, NEW CABINETS, NEW WATER HEATER, NEW ELECTRIC BORD JUST WAITING FOR A NEW OWNER. CHECK IT OUT' ,`Acres` = '0.1494' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'BRIARGATE SEC 9, BLOCK 2, LOT 24' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6510' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BRIARGATE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLOWRIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'MCAULIFFE MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Briargate Sec 9' ,`TaxAmount` = '2441' ,`TaxRate` = '2.2137' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145693' WHERE `Matrix_Unique_ID` = '213406715' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T07:59:27.463' ,`MLSNumber` = '87679762' ,`ListAgentFullName` = 'Meriam Shaw' ,`ListOfficeName` = 'Keller Williams Elite' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.813065' ,`Longitude` = '-95.766685' ,`PhotoCount` = '44' ,`PostalCode` = '77449' ,`RoomCount` = '9' ,`ListPrice` = '279000.00' ,`Status` = 'Active' ,`StreetName` = 'Brafferton' ,`StreetNumber` = '22726' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2225' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You must see this fully renovated 2,225sqft 4 bed 3 1/2 bath including a 200sqft In-Law Suite featuring a walk-in closet & a bathroom located on the 1st floor! EXTERIOR UPDATES New Roof, New Vinyl Windows, Hardie Plank Siding, Paint, Exterior Doors, Gutters, Insulation, Lighting, Landscaping, New Sod, Fencing, & Mailbox with lock! INTERIOR UPDATES New Flooring throughout the home, Baseboards, Light fixtures, Interior Paint, Recess Lighting, Solid Interior Doors & Hardware, Ceiling Fans, Custom Cabinets w/ self closing drawers, Granite & Quartz Countertops, New Stainless Steel Appliances, New Pex Piping, &Hot Water Heater, New Fuse Box & relocated to the garage, brand new garage opener w/ keyless pad, New A/C, all bathrooms renovated! The BACKYARD features 15x15 Covered Patio& an Outdoor Kitchen w/ stainless steel premium grill along w/ sink, brick fireplace,& new drainage with drain boxes.*Seller has an active surveillance system everyone will be recorded when they enter the property*' ,`Acres` = '0.1529' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 29 WILLIAMSBURG COLONY SEC 4' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '6660' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '420' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WINBORN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MORTON RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'MORTON RANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Williamsburg Colony' ,`TaxAmount` = '3500' ,`TaxRate` = '2.4333' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145694' WHERE `Matrix_Unique_ID` = '213497967' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T07:49:57.150' ,`MLSNumber` = '75490065' ,`ListAgentFullName` = 'Burke Purdie' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.492387' ,`Longitude` = '-95.086934' ,`PhotoCount` = '26' ,`PostalCode` = '77573' ,`RoomCount` = '10' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Coleman Boylan' ,`StreetNumber` = '1375' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3070' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful 2-story traditional 4/2/1 located in Oaks of Clear Creek subdivision and much desired CCISD. Primary bedroom(s) /bath(s) both downstairs & upstairs. Game room. 3-car garage. Roof - 9 years, (2) 3-ton Trane XR condensers - 4 years, Trane Coils/Heater in the attic - 4 years. Water Heater - 15 years. High-corner location that did not flood during Harvey! Very close to area shopping, retail and parks.' ,`Acres` = '0.2102' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 3 PAGE 17 LOT 34 BLK 4 THE OAKS OF CLEAR CREEK SEC 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9157' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'RALPH PARR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'VICTORYLAKES INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'The Oaks Of Clear Creek Sec 2' ,`TaxAmount` = '7456' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145694' WHERE `Matrix_Unique_ID` = '213808854' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T06:39:21.170' ,`MLSNumber` = '24467530' ,`ListAgentFullName` = 'LaQuesha Spivey' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.576469' ,`Longitude` = '-95.609780' ,`PhotoCount` = '27' ,`PostalCode` = '77479' ,`RoomCount` = '13' ,`ListPrice` = '850000.00' ,`Status` = 'Active' ,`StreetName` = 'Hickory Run' ,`StreetNumber` = '3102' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '5273' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful, traditional, well-maintained custom home on sizeable lot w/high ceilings & great natural light. 2-story entry flanked by expansive dining room. Grand office overlooks mature trees & nicely landscaped esplanade & is open to 2nd floor library (great work-from-home space). Entertaining is easy in spacious living room w/fireplace & French doors leading to backyard w/covered patio, pergola, pool, & jacuzzi. Oversized garage includes workshop area. Spacious kitchen boasts center island, oversized pantry, subzero refrigerator, & opens to breakfast area & living room. Gracious 1st floor primary bedroom w/ensuite & sitting area overlooks pool. On the 2nd-floor, space & natural light abound in 3 large bedrooms, game room & library w/large closets & custom built-ins. Zoned to Clements High School, & close to elementary/middle schools (Buyer to verify eligibility). Conveniently located 2.4 miles from Sugar Land town square near shops, dining, & Sweetwater Country Club. Info per Seller' ,`Acres` = '' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'COLONY PARK, BLOCK 3, LOT 5' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '13866' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '812' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'COLONY BEND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Colony Park' ,`TaxAmount` = '14054' ,`TaxRate` = '2.1584' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145694' WHERE `Matrix_Unique_ID` = '214022214' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T07:07:55.013' ,`MLSNumber` = '48778313' ,`ListAgentFullName` = 'Anita Alvarado' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.560024' ,`Longitude` = '-95.576333' ,`PhotoCount` = '41' ,`PostalCode` = '77459' ,`RoomCount` = '6' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'Heritage Colony' ,`StreetNumber` = '3755' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2026' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You\'re going to love this Beautiful MOVE-IN-READY, single-story home in Heritage Colony! This property features 3 Bedrooms, 2 Full Baths, and a Home Office/Study. Home has a two car attached garage. Home is an open concept floor-plan with kitchen overlooking family room with natural light to your backyard & patio area. Home features a Formal Dining, spacious Family Room and Kitchen that is open to the Breakfast area. Primary Suite is an amazing size with it’s own little patio area. Primary Bathroom features double sinks, standup shower and soaking tub, with an oversize closet! Enjoy the many community amenities such as multiple pools, parks, aquatic center (year-round), volleyball courts, walking trails, and more. Conveniently located minutes from Highway 6 and zoned to great schools. This is one you don\'t want to miss! Home has NEVER FLOODED!' ,`Acres` = '0.1843' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'HERITAGE COLONY SEC 3, BLOCK 6, LOT 28' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8027' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '812' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'AUSTIN PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Heritage Colony Sec 3' ,`TaxAmount` = '6541' ,`TaxRate` = '2.71' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145694' WHERE `Matrix_Unique_ID` = '214151794' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T07:35:07.210' ,`MLSNumber` = '48944287' ,`ListAgentFullName` = 'Daniel DiPetta' ,`ListOfficeName` = 'Bayou City Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.753458' ,`Longitude` = '-95.591606' ,`PhotoCount` = '42' ,`PostalCode` = '77077' ,`RoomCount` = '6' ,`ListPrice` = '629950.00' ,`Status` = 'Active' ,`StreetName` = 'Lakecliff' ,`StreetNumber` = '1411' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2969' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated house in a mature neighborhood awaits you! This house has been completely remodeled from the ground up. New doubled paned windows. Foundation has been repaired. New roof. New modern interior paint throughout! New engineered wood flooring. Updated kitchen new cabinets, quartz counter tops, and tile backsplash. Updated bathrooms with new vanities, quartz counters, and tile flooring. Spacious backyard with a pool and patio that is perfect for those gatherings!' ,`Acres` = '0.2268' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 5 COUNTRY VILLAGE SEC 1 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9880' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '790' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ASHFORD/SHADOWBRIAR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Country Village Sec 01 R/P' ,`TaxAmount` = '8363' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145695' WHERE `Matrix_Unique_ID` = '214162592' --> Updated record success