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-07T05:22:00.803' ,`MLSNumber` = '69974520' ,`ListAgentFullName` = 'Patty Newton' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.609963' ,`Longitude` = '-95.623487' ,`PhotoCount` = '50' ,`PostalCode` = '77478' ,`RoomCount` = '15' ,`ListPrice` = '959000.00' ,`Status` = 'Active' ,`StreetName` = 'Skimmer' ,`StreetNumber` = '810' ,`StreetSuffix` = 'Court' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5785' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WOW!! Breathtaking, Spacious, Waterfront home in a quiet cul de sac w/one of the Lowest tax rates around. Magnificent 2 story iron doors greet you at the front entry w/ exquisite curved staircase off the Rotunda. Home Office is located 1/2 way up the stairs. Grass cloth walls w/ french doors & gorgeous wood floors & built in bookcase. Primary Bedroom Suite has unobstructed views of water. You\'ll ABSOLUTELY fall in love w/ the updated Primary Bath w/ Double Sink vanities, Tower storage, and 2 massive closets (hers w/ 3 level hanging racks). Plenty of space for Family & friends to relax in the Formal Living Room or Family Room both w/ spectacular views of water. The Kitchen has 42\" soft close Cabinetry w/ painted borders, a 5 burner gas stove, farmhouse sink & huge walk in pantry & is open to Family Room. Upstairs are 3 bedrooms (one a HUGE room w/ double walk ins & a cedar closet). A gameroom w/ outdoor balcony. Covered Patio & Koi pond in back!! 3 shoe cabinets in the garage!' ,`Acres` = '0.2409' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sugar Land North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SUGAR LAKES SEC 4, BLOCK 2, LOT 23' ,`LotDesciption` = 'Cul-De-Sac,Waterfront' ,`LotSize` = '10494' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '898' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HIGHLANDS ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sugar Lakes' ,`TaxAmount` = '12702' ,`TaxRate` = '2.0094' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665145384' WHERE `Matrix_Unique_ID` = '209849196' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T05:10:46.267' ,`MLSNumber` = '34334166' ,`ListAgentFullName` = 'Gregory Staples' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.772381' ,`Longitude` = '-95.421789' ,`PhotoCount` = '47' ,`PostalCode` = '77007' ,`RoomCount` = '8' ,`ListPrice` = '510000.00' ,`Status` = 'Active' ,`StreetName` = 'Schuler' ,`StreetNumber` = '5915' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2330' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exterior & Interior freshly painted, 20x20 backyard,updated bathroom downstairs,updated Master Bathroom, Very spacious open floor plan,hardwoods throughout the Second floor, Balcony off the Breakfast Room, Large Bedrooms,\r\n Hot Water Heater,Custom Blinds throughout the house, Gas light Fireplace, Gated and fenced entry to the house, Refigerator in the Kitchen and the garage, Washer and Dryer to stay.' ,`Acres` = '0.0427' ,`Area` = '16' ,`BuilderName` = 'Riverwood Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rice Military/Washington Corridor' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 RIVERWOOD ON SCHULER SEC 2' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '1860' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverwood/Schuler Sec 2' ,`TaxAmount` = '9087' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665145384' WHERE `Matrix_Unique_ID` = '210478629' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T05:54:15.323' ,`MLSNumber` = '95152737' ,`ListAgentFullName` = 'Jaime McLaughlin' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.534593' ,`Longitude` = '-95.215210' ,`PhotoCount` = '19' ,`PostalCode` = '77546' ,`RoomCount` = '4' ,`ListPrice` = '219500.00' ,`Status` = 'Active' ,`StreetName` = 'Stratmore' ,`StreetNumber` = '405' ,`StreetSuffix` = 'Drive' ,`City` = 'Friendswood' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1029' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Adorable and move in ready home nestled in the established neighborhood of Anna Alea and zoned to Friendswood ISD! This home offers like new interior paint and light fixtures, hard surface flooring throughout, gorgeous remodeled bathrooms, huge backyard with mature trees, covered/screened in porch outback perfect for relaxing and entertaining and all new PEX piping (2020)! Like new water heater (2018) and fence (2017) too! Please inquire about cabinet doors. Come take a peek at this one before its too late!' ,`Acres` = '0.1612' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 20 PERRY & AUSTIN SUR LOT 12 BLK 1 ANNALEA KINGSPARK SE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7020' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '20 - Friendswood' ,`SchoolElementary` = 'WESTWOOD ELEMENTARY SCHOOL (FRIENDSWOOD)' ,`SchoolHigh` = 'FRIENDSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'FRIENDSWOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Anna Alea Kingspark/Whitehall' ,`TaxAmount` = '3172' ,`TaxRate` = '2.2832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665145384' WHERE `Matrix_Unique_ID` = '210601766' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T04:56:36.793' ,`MLSNumber` = '66842828' ,`ListAgentFullName` = 'Cassandra Davenport' ,`ListOfficeName` = 'Bates-Brinkley Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.764990' ,`Longitude` = '-94.955249' ,`PhotoCount` = '41' ,`PostalCode` = '77521' ,`RoomCount` = '6' ,`ListPrice` = '239999.00' ,`Status` = 'Active' ,`StreetName` = 'Crestbriar' ,`StreetNumber` = '24' ,`StreetSuffix` = 'Court' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You\'ll love this home. Beautiful and clean with beautiful wood floor. and the second largest backyard in the neighborhood. Storage Building, nice patio covering for sitting out and grilling. Have your own garden too. 2 Car Garage and double gate into back yard. Bonus: A 5500 Generator with cord will light up your entire house. Newer roof and air conditioning unit including duct work was done in 2021.' ,`Acres` = '0.276' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 44 BRIARCREEK OF BAYTOWN SEC 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '12024' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'CEDAR BAYOU J H' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Briarcreek Baytown Sec 01' ,`TaxAmount` = '4696' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1665145384' WHERE `Matrix_Unique_ID` = '210967124' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T05:54:26.587' ,`MLSNumber` = '22526032' ,`ListAgentFullName` = 'Rosaura Arango' ,`ListOfficeName` = 'The Monarch Team, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.768739' ,`Longitude` = '-95.401345' ,`PhotoCount` = '42' ,`PostalCode` = '77007' ,`RoomCount` = '3' ,`ListPrice` = '660000.00' ,`Status` = 'Active' ,`StreetName` = 'Barnes' ,`StreetNumber` = '4005' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2225' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home...This property is located in the heart of Rice Village with easy access to Downtown Houston!! The first floor has a bedroom that includes a fridge and a spacious suite bar that can potentially be used as a short-term rental. All bedrooms are very spacious with walk-in closets! The primary room has an extra-large walk-in closet connected to the double vanity luxurious bathroom! Light sleeper?! The primary bedroom has soundproof isolation within the walls that\'s definitely a plus! The 4th story welcomes you to a rooftop patio that\'s perfect for a summer BBQ. In addition, for our furry best friends there is access to a dog park/play area right aside from the backyard. Furniture negotiable with reasonable offers. Inquire within for more information!!' ,`Acres` = '0.0415' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Rice Military/Washington Corridor' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 1 MEMORIAL PATIO HOMES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1808' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1195' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '4' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Memorial Patio Homes' ,`TaxAmount` = '12738' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665145384' WHERE `Matrix_Unique_ID` = '212183797' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T04:38:54.383' ,`MLSNumber` = '76981253' ,`ListAgentFullName` = 'JoeAnn Garcia' ,`ListOfficeName` = 'Prime Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.026338' ,`Longitude` = '-95.614500' ,`PhotoCount` = '24' ,`PostalCode` = '77377' ,`RoomCount` = '4' ,`ListPrice` = '284900.00' ,`Status` = 'Active' ,`StreetName` = 'Westwold' ,`StreetNumber` = '12318' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1776' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful two story home with 4 bedrooms and 2 baths. The primary bedroom is downstairs and 3 bedrooms are upstairs. Completely renovated inside and out. New roof and the A/C is 1 year old. The kitchen has been updated with all new stainless steel appliances, elegant quartz countertops, breakfast bar and lots of cabinet space. The living area is so inviting with tall ceilings, a fireplace and view of the nice backyard made for entertaining your guests. Garage conversion adds extra livable space perfect for home office or gameroom. Total of 1776 sqft. The details are gorgeous throughout. It’s a must see in Tomball.' ,`Acres` = '0.1125' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 45 BLK 3 WESTBOURNE SEC 1 PAR R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4902' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'WILLOW CREEK ELEMENTARY SCHOOL (TOMBALL)' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'WILLOW WOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westbourne Sec 01 Prcl R/P' ,`TaxAmount` = '3956' ,`TaxRate` = '2.5764' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665145384' WHERE `Matrix_Unique_ID` = '212183924' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T05:53:06.917' ,`MLSNumber` = '35895478' ,`ListAgentFullName` = 'Julie Buckner' ,`ListOfficeName` = 'JPAR-The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.711118' ,`Longitude` = '-95.745233' ,`PhotoCount` = '36' ,`PostalCode` = '77450' ,`RoomCount` = '4' ,`ListPrice` = '415000.00' ,`Status` = 'Active' ,`StreetName` = 'Grenoble' ,`StreetNumber` = '20803' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2368' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 20803 Grenoble Lane in Cinco Ranch Southpark! This home boasts a 2 story entry with gorgeous windows bringing in tons natural light. This spacious home has it all, freshly painted with 3 bedrooms, 2.5 bathrooms, a game room as well as a double-sided fireplace. The Primary bedroom is located upstairs and features a massive walk-in closet, an en suite bathroom with separate vanities, separate shower and a luxurious bathtub. The updated woodgrain tile flooring throughout the first floor compliments the new quartz counter tops and new stainless appliances. Minutes away from the Westpark Tollway and easy access to Grand Parkway and is convenient to all of Katy’s special amenities. Cinco Ranch offers 7 swimming areas, parks and recreation areas, tennis courts, golf courses, volleyball, basketball, cricket pitch and league play athletic fields. WELCOME HOME!!' ,`Acres` = '0.1439' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CINCO RANCH SOUTHPARK SEC 1, BLOCK 2, LOT 19' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6270' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CREECH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'BECK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Cinco Ranch Southpark Sec 1' ,`TaxAmount` = '6894' ,`TaxRate` = '2.6862' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665145385' WHERE `Matrix_Unique_ID` = '212623385' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T05:30:16.097' ,`MLSNumber` = '89408758' ,`ListAgentFullName` = 'Calvin Davis' ,`ListOfficeName` = 'Texas Premier Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.015983' ,`Longitude` = '-95.552782' ,`PhotoCount` = '32' ,`PostalCode` = '77379' ,`RoomCount` = '8' ,`ListPrice` = '319000.00' ,`Status` = 'Active' ,`StreetName` = 'Megan Springs' ,`StreetNumber` = '17314' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2346' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this elegant One story home on a beautiful lot, boasting 4 bedrooms. Located in the highly sought after neighborhood of Champion Springs Village! From the moment you enter, you will be amazed at all the upgrades this lovely home has to offer, including crown molding in the entry way and high ceilings. Formal dining room is right off the kitchen....No need for formal dining, no problem you can turn this into a study. The kitchen has plenty of room to entertain and is open to the living room. The owners suite is privately tucked away in the back corner of the home, which includes an oversized ensuite. Fresh paint on all the walls and trims to make this an easy move in. The large backyard has a covered and extended patio, which is great for entertaining. This family friendly neighborhood features excellent schools, a community pool, catch and release pond, park, trails, restaurants close by & more!' ,`Acres` = '0.1653' ,`Area` = '13' ,`BuilderName` = 'Pulte Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 2 CHAMPION SPRINGS VILLAGE' ,`LotDesciption` = 'Other' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '680' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KRAHN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Champion Spgs Village' ,`TaxAmount` = '4995' ,`TaxRate` = '2.3266' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665145385' WHERE `Matrix_Unique_ID` = '212729334' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T05:55:59.047' ,`MLSNumber` = '44803207' ,`ListAgentFullName` = 'Jaime Corona' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.793129' ,`Longitude` = '-95.166434' ,`PhotoCount` = '21' ,`PostalCode` = '77015' ,`RoomCount` = '9' ,`ListPrice` = '305000.00' ,`Status` = 'Active' ,`StreetName` = 'Duncannon' ,`StreetNumber` = '14415' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this oasis in the heart of Cloverleaf community! This Completely remodeled 4 bedroom 2 bathroom 2300 sqft home is perfect with a spacious bonus room that can be used as a study or home office! Kitchen features quartz countertops and kitchen peninsula! Large backyard oasis with private pool and lots of space for entertaining and outdoor activities. Home is within walking distance to North Shore Elementary School and Galena Park Daycare. Zoned to North Shore High School (4-minute drive). A short 3-minute drive to two shopping centers: grocery stores, restaurants, banks, pharmacies, and more! Immediate access to Beltway 8, US-90, and I-10. All large ticket items are taken care of! Brand new 4-ton HVAC, brand new roof, brand new garage doors, brand new flooring, and brand new appliances (water heater, range, dishwasher, and hood). Make your appointment today!' ,`Acres` = '0.1727' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 22 WOODFOREST SEC 15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7524' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'NORTH SHORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH SHORE SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'NORTH SHORE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest' ,`TaxAmount` = '4821' ,`TaxRate` = '2.5294' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665145385' WHERE `Matrix_Unique_ID` = '212837655' --> 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','212878206','1665145385','212878206','2022-10-07T04:08:19.000','22407251','Karina De Los Reyes','RE/MAX Northwest, REALTORS','','','29.794115','-95.358015','34','77009','7','395000.00','Active','Bunton','1003','Street','Houston','2','1','3','1848','Single-Family','Location! Location! Location! In the heart of downtown near restaurants and shopping, surrounded by all the major highways; 610, 45, 59, I-10 and the Hardy Toll. Beautiful home built in 2019 and ready for move-in! This modern farmhouse features 3 bedrooms and 2.5 bathrooms. Gorgeous Carrara Marble counter tops throughout the entire home. The over sized master suite includes dual vanities with a large walk-in shower. All bedrooms include huge walk-in closets plus built-in shelves in the master closet. The open floor plan is perfect for entertaining and high ceilings on the first floor make the living space feel even bigger. The home has an inviting covered front porch to go with a great neighborhood. Plus a back patio with storage shed and fully fenced backyard for pets and/or for weekend entertainment. Enjoy the open space living area with sleek and modern finishes throughout the house. Also has your very own driveway to park your cars. Property DID NOT FLOOD! No HOA!','0.0752','9','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Exclusions,Sellers Disclosure','1','','','Northside','Central Gas,Zoned','0','LT 4 BLK 1 TIMBER HO','Subdivision Lot','3275','Appraisal District','','','0','','0','Gas Oven','0','','','Gas Range','','Composition','27 - Houston','LOOSCAN ELEMENTARY SCHOOL','NORTHSIDE HIGH SCHOOL','MARSHALL MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','2','Contemporary/Modern','Timber Ho','7577','2.3307','Public Sewer,Public Water','2018','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T05:55:58.047' ,`MLSNumber` = '70904625' ,`ListAgentFullName` = 'Aaron Cruz' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.703848' ,`Longitude` = '-95.439166' ,`PhotoCount` = '29' ,`PostalCode` = '77025' ,`RoomCount` = '11' ,`ListPrice` = '1180000.00' ,`Status` = 'Active' ,`StreetName` = 'Bellefontaine' ,`StreetNumber` = '3840' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3944' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous one-of-a-kind Braes Heights home was built to impress! As you enter the home you are greeted by a beautiful private office and formal dining room. Endless high ceilings throughout, split living floor plan with primary bedroom separated from the 3 additional bedrooms which are all on one level. Huge upstairs bonus room great for home theater or gym. Wood/gas log fireplace, plantation shutters, multi-level crown molding throughout. Double insulation installed in attic and walls, spacious kitchen for cooking with custom wood cabinetry that flows into living room, breakfast and sun-room with planked engineered hardwood flooring. This home has closets and storage galore. The backyard has green space for a pool, with French drain, and a large covered patio area for outdoor grilling. Walking distance to the exemplary Mark Twain Elementary and Pershing Middle School. Neighborhood amenities include local shops, restaurants, YMCA, 2 parks with trails, McGovern Stella Link Library.' ,`Acres` = '0.2152' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Braeswood Place' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 24 & 25A BLK 3 BRAES HEIGHTS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9375' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '90' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'TWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial,Traditional' ,`Subdivision` = 'Braes Heights Add Sec 01' ,`TaxAmount` = '23257' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665145385' WHERE `Matrix_Unique_ID` = '213097430' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T04:37:39.440' ,`MLSNumber` = '38093214' ,`ListAgentFullName` = 'Kandice Fogle' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.531490' ,`Longitude` = '-95.738885' ,`PhotoCount` = '35' ,`PostalCode` = '77469' ,`RoomCount` = '9' ,`ListPrice` = '448500.00' ,`Status` = 'Active' ,`StreetName` = 'Quade' ,`StreetNumber` = '7915' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2893' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Two-story Westin home in Rivers Run featuring abundant, custom upgrades & design elements throughout! Four BRs, 3.5 BAs with an extended backyard living space for your added enjoyment. Upon entering, you\'ll be greated by an amazing, two-story foyer & rotunda that leads to a family room with soaring window views of the backyard retreat. Upgraded Kitchen cabinets & hardware, designer paint & light fixtures, custom built bookshelf niches anchoring the cast stone fireplace, shiplap enhanced powder bath & surround sound in the main living areas & back patio. The amazing backyard retreat features a custom, extended patio with slate pavers that lead a second, large patio with stone fire pit with gas connection. Located on a cul-de-sac and backing to a restricted reserve, this fabulous property is one-of-a-kind!' ,`Acres` = '0.1693' ,`Area` = '30' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RIVERS MIST SEC 3, BLOCK 2, LOT 43' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7374' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'ARREDONDO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Rivers Mist Sec 3' ,`TaxAmount` = '8711' ,`TaxRate` = '2.7148' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665145385' WHERE `Matrix_Unique_ID` = '213226080' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T04:23:25.180' ,`MLSNumber` = '98477174' ,`ListAgentFullName` = 'Kelly Andel' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.324228' ,`Longitude` = '-95.594298' ,`PhotoCount` = '47' ,`PostalCode` = '77430' ,`RoomCount` = '4' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Kings Oak' ,`StreetNumber` = '8702' ,`StreetSuffix` = 'Drive' ,`City` = 'Damon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1920' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wow! This showstopper is ready for new owners! Welcome to your gated home at 8702 Kings Oak. This beautiful acreage tract is adorned with oak trees providing a park like setting. Take a dip in the pool (replastered, new pool light and pump 2022) and relax by your outdoor fireplace or under the recent pergola. 3 decks off the home to enjoy the nature views including a pond. Shop outside to store your tools! Inside you’ll find 4 bedrooms with a living space on each floor. The primary bedroom is large with a gorgeous en suite bath. Enjoy the oversized tub and oversized walk-in shower. Entire interior has been recently painted. The garage has central AC/Heat and wainscot and can be used as game room or garage. Outside there is also a large carport for extra parking space. Lovely kitchen ready for the chef of the family. Laminate flooring throughout, no carpet! Call today to schedule a showing at this ideal country property!' ,`Acres` = '3.5' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0003 THOS ALLSBERRY TRACT 23F3A1-23F3B ACRES 3.5' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '152460' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Thos Allsberry' ,`TaxAmount` = '4514' ,`TaxRate` = '1.6563' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665145386' WHERE `Matrix_Unique_ID` = '213372292' --> Updated record success