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-08-12T16:35:37.047' ,`MLSNumber` = '52069845' ,`ListAgentFullName` = 'Kyle Watters' ,`ListOfficeName` = 'Exl Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.124292' ,`Longitude` = '-95.449542' ,`PhotoCount` = '50' ,`PostalCode` = '77380' ,`RoomCount` = '6' ,`ListPrice` = '9500000.00' ,`Status` = 'Active' ,`StreetName` = 'Budde' ,`StreetNumber` = '24901' ,`StreetSuffix` = 'Road' ,`City` = 'Spring' ,`BathsFull` = '6' ,`BathsHalf` = '3' ,`BedsTotal` = '6' ,`SqFtTotal` = '8919' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This tranquil and serene ten-acre estate 20 minutes north of Houston is your very own slice of Texas heaven. The main home has 6 bedrooms, 6 full bath, and 3 half baths. Guest home consists of 2 large bedrooms and 2 full baths. The over 10,000 square feet of residential space between the main residence and guest house is only outdone by the beauty of the grounds they rest on. Outdoor features include full kitchen area, pool, bass pond, tennis and basketball court, climate-controlled bungalow, and reflection pool. The vast amount of storage space on the grounds provide space for your ATVs, RV, or boats, and climate controlled storage for your more temperate belongings. The 500-year-old oak trees provide ample shade in the hot summers, while an outdoor chimney is available for cold nights. All this, along with two private wells and private septic encompassed by a surrounding privacy fence, makes this exclusive compound a one of a kind opportunity. Schedule your showing today!' ,`Acres` = '10' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'A0599 WALKER CO SCH L, TRACT 32, ACRES 10.000' ,`LotDesciption` = 'Other,Waterfront' ,`LotSize` = '435600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAM HAILEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Mediterranean,Traditional' ,`Subdivision` = 'Walker Co' ,`TaxAmount` = '19241' ,`TaxRate` = '1.9103' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697660' WHERE `Matrix_Unique_ID` = '203837279' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T17:26:00.703' ,`MLSNumber` = '60994687' ,`ListAgentFullName` = 'Norma Garcia-Carreon' ,`ListOfficeName` = 'Norma Garcia Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.803810' ,`Longitude` = '-95.150477' ,`PhotoCount` = '10' ,`PostalCode` = '77530' ,`RoomCount` = '6' ,`ListPrice` = '210000.00' ,`Status` = 'Active' ,`StreetName` = 'Littleport' ,`StreetNumber` = '1506' ,`StreetSuffix` = 'Lane' ,`City` = 'Channelview' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1491' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Front burglar door offers privacy into patio area and front door. Enter Littleport into a spacious living room 19X19. Living-dining room combo ideal for family gatherings. Warming invite by tradition wood burning brick fireplace. \r\nOpen dining room with two bar windows open for family interaction yet privacy for kitchen work station. Bedroom split floor plan.' ,`Acres` = '0.14' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 1 STERLING GREEN SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6098' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '270' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '8 - Channelview' ,`SchoolElementary` = 'Brown Elementary School (Channelview)' ,`SchoolHigh` = 'CHANNELVIEW HIGH SCHOOL' ,`SchoolMiddle` = 'AGUIRRE JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Sterling Green Sec 08' ,`TaxAmount` = '3826' ,`TaxRate` = '2.518' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663697660' WHERE `Matrix_Unique_ID` = '208336063' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T17:38:50.463' ,`MLSNumber` = '61226900' ,`ListAgentFullName` = 'Haley Johnson' ,`ListOfficeName` = 'Tejas Land Co.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.836244' ,`Longitude` = '-95.070544' ,`PhotoCount` = '14' ,`PostalCode` = '77351' ,`RoomCount` = '11' ,`ListPrice` = '115000.00' ,`Status` = 'Active' ,`StreetName` = 'Bluebird' ,`StreetNumber` = '391' ,`StreetSuffix` = 'Lane' ,`City` = 'Livingston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1155' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Subdivision offers a private boat launch and fishing pier for residents to enjoy that is less than a mile from the property. 3 bedrooms, 2 bathroom inside the home that is located on 2 lots. There is an extra room on the of backside of the home that is being used as a bedroom now. Another bedroom is located inside the garage. Both additional rooms are equipped with a full bathrooms. 5 total potential bedrooms. One car garage and RV/Camper spot with hook up already in place on the property. This home will require some TLC, but can be lived in while renovating. Would make a great starter home or investment property for those who enjoy living in a lake subdivision. All appliances go with the home and are included with the sale.' ,`Acres` = '0.3003' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'KICKAPOO ESTATES BLK 8 LOT 12 & 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13080' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '180' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Back' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kickapoo Estates' ,`TaxAmount` = '480' ,`TaxRate` = '1.7215' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663697661' WHERE `Matrix_Unique_ID` = '208478891' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T16:41:42.140' ,`MLSNumber` = '7402235' ,`ListAgentFullName` = 'Alex Westbrook-McCollum' ,`ListOfficeName` = 'Swede\'s Real Estate LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.456751' ,`Longitude` = '-94.624378' ,`PhotoCount` = '34' ,`PostalCode` = '77650' ,`RoomCount` = '6' ,`ListPrice` = '799000.00' ,`Status` = 'Active' ,`StreetName` = 'Mills' ,`StreetNumber` = '2100' ,`StreetSuffix` = '' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1576' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming, one owner, two story beach cabin on quiet, dead end street in the heart of the peninsula - close to restaurants, the beach, short drive to the ferry, and more! Large deck is perfect spot to watch for fireworks or look for \"pirate ships\" from the upstairs dormers. Eat in kitchen features granite countertops, ample storage with two pantries, gas cooktop, pot filler, drink fridge. Primary bedroom has jacuzzi tub and separate shower. Upstairs bedrooms have bunk beds - room for plenty of guests. Home features elevator for convenience. Short walk, golf cart, or car ride to the beach for shell shopping or hunting for shark teeth.' ,`Acres` = '0.1148' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 65 B FRANKS SUR LOT 77 ALBERDIE ADDN NO 1' ,`LotDesciption` = 'Water View' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`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' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Alberdie Add 1' ,`TaxAmount` = '5402' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697661' WHERE `Matrix_Unique_ID` = '208795544' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T17:23:34.270' ,`MLSNumber` = '87104901' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Charles Wells' ,`SellingOfficeName` = 'Nexthome Elite Advisors' ,`Latitude` = '29.852738' ,`Longitude` = '-95.742516' ,`PhotoCount` = '8' ,`PostalCode` = '77449' ,`RoomCount` = '5' ,`ListPrice` = '360490.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Riverdew Drive' ,`StreetNumber` = '21327' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2294' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW D.R. Horton two story! Wonderful open floor plan! Island kitchen has lots of cabinets and is open to the breakfast room and family room! Large primary bedroom with a spacious closet! Features a large shower in the primary bathroom as well! Hard surface flooring in all living areas and modern designer details! Covered Patio overlooking the backyard! Landscape package included and so much more! Hurry and call today!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 7 - Block 3 - Section 23' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6842' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'GOLBOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'MCDONALD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Jasmine Heights' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697661' WHERE `Matrix_Unique_ID` = '208897708' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T16:47:10.400' ,`MLSNumber` = '2729107' ,`ListAgentFullName` = 'Cody Richards' ,`ListOfficeName` = 'Richards & Assoc. Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.473719' ,`Longitude` = '-95.564552' ,`PhotoCount` = '50' ,`PostalCode` = '77318' ,`RoomCount` = '3' ,`ListPrice` = '725000.00' ,`Status` = 'Active' ,`StreetName` = 'Calvary' ,`StreetNumber` = '13840' ,`StreetSuffix` = 'Road' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2512' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3.5 unrestricted acres with partial Lake Conroe view to the West and the South as it is adjacent to Stow-A-Way Marina on Lake Conroe. This property is directly on Calvary Rd with a brick home on a hill and room for your commercial operation down in front or possible storage or RV/boat parking near a launch. Across the road and down closer to the lake than Corinthian Point! Many opportunities are possible with this property!' ,`Acres` = '3.5' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0528 SADDLER JOHN, TRACT 19, ACRES 3.500' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '152460' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'PARMLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Area 19' ,`TaxAmount` = '4808' ,`TaxRate` = '1.8448' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697661' WHERE `Matrix_Unique_ID` = '209074963' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T17:19:35.163' ,`MLSNumber` = '4230711' ,`ListAgentFullName` = 'Corina Garcia' ,`ListOfficeName` = 'Rise Texas Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.809898' ,`Longitude` = '-94.807245' ,`PhotoCount` = '34' ,`PostalCode` = '77523' ,`RoomCount` = '3' ,`ListPrice` = '750000.00' ,`Status` = 'Active' ,`StreetName` = 'Ben Mar Overlook' ,`StreetNumber` = '1302' ,`StreetSuffix` = '' ,`City` = 'Baytown' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3054' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Custom 2-story home offers a serenity & peaceful view while fully enjoying the back patio & pool areas with screened enclosure. The outdoor club house is ready for hosting a pool/favorite sports game party. It comes with a full bathroom & an electric tankless hot water heater. This home comes with a Generac whole house generator & 500-gallon propane tank. Front entrance has granite flooring that leads you to a solid wood staircase & to a study & formal room/free room. The kitchen offers a custom backsplash, stainless steel appliances including double convection oven, spacious pantry that pours straight out into the breakfast then living room. Master suite has an oversized walk-in closet, gorgeous shower and a corner Jacuzzi tub. Additional features: tankless whole house water heater, game room that leads to balcony, a fitness/free room, a huge media room with central ac unit & one upstairs secondary bedroom with full private bathroom, 3-car garage & covered parking area for a boat.' ,`Acres` = '1.704' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BEN MAR COVE S/D FC FOR 2ND STORY PORCH' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '74226' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ben Mar Cove' ,`TaxAmount` = '6973' ,`TaxRate` = '1.7058' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697661' WHERE `Matrix_Unique_ID` = '209094332' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T17:51:48.240' ,`MLSNumber` = '35165682' ,`ListAgentFullName` = 'Ivannia Recio' ,`ListOfficeName` = 'Ace Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.848583' ,`Longitude` = '-95.230373' ,`PhotoCount` = '35' ,`PostalCode` = '77078' ,`RoomCount` = '3' ,`ListPrice` = '214900.00' ,`Status` = 'Active' ,`StreetName` = 'Valley Forest' ,`StreetNumber` = '8623' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1264' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful updated 3 bed 2 baths with lots of upgrades! Home offers an open concept kitchen with lots of natural light and a great floorplan layout. New features include new flooring throughout the house, new appliances, and remodeled kitchen and bathrooms. New Paint and New fixtures and lots of space to entertain. Schedule your showing today!' ,`Acres` = '0.1625' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 129 BLK 4 PARKWOOD EAST SEC 1 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7080' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ELMORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkwood East Sec 01 R/P' ,`TaxAmount` = '3512' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697661' WHERE `Matrix_Unique_ID` = '209444827' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T17:01:32.820' ,`MLSNumber` = '88163526' ,`ListAgentFullName` = 'Melanie Moore' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.283862' ,`Longitude` = '-97.134644' ,`PhotoCount` = '16' ,`PostalCode` = '77995' ,`RoomCount` = '3' ,`ListPrice` = '145000.00' ,`Status` = 'Active' ,`StreetName` = 'Maple St' ,`StreetNumber` = '704' ,`StreetSuffix` = '' ,`City` = 'Yoakum' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1013' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cozy home in quiet location just minutes from Downtown Yoakum. 2 Bedroom, 1 Bathroom Home updated in 2018 including new windows and exterior doors, Hardy board siding under the covered front porch, laminate wood-type flooring throughout, freshly painted interior, barn wood accent wall in living room, sliding barn door on bathroom, new toilet and pedestal sink, new closet doors in bedrooms, crown molding and more! All City of Yoakum utilities and gas. Small storage building with electric. Privacy and chain-link fenced back yard. Refrigerator, Gas Stove, Washing Machine and Dryer convey.' ,`Acres` = '0.3396' ,`Area` = '68' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'OAK RIDGE, BLK1, LOT 16-FR, 17, FR 18' ,`LotDesciption` = 'Cleared' ,`LotSize` = '14793' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '177 - Yoakum' ,`SchoolElementary` = '' ,`SchoolHigh` = 'YOAKUM HIGH SCHOOL' ,`SchoolMiddle` = 'YOAKUM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'N/A' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697661' WHERE `Matrix_Unique_ID` = '209618669' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T16:12:15.350' ,`MLSNumber` = '39906038' ,`ListAgentFullName` = 'Brooke Mason' ,`ListOfficeName` = 'Cross-Town Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.145778' ,`Longitude` = '-96.367963' ,`PhotoCount` = '22' ,`PostalCode` = '77833' ,`RoomCount` = '10' ,`ListPrice` = '389000.00' ,`Status` = 'Active' ,`StreetName` = 'Springwood' ,`StreetNumber` = '2201' ,`StreetSuffix` = 'Drive' ,`City` = 'Brenham' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1935' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You’ll want to see this one! This is Terry Ward built home! This Brenham home is beautiful, light-filled, and has easy access to HWY 290 and HWY 50. A gourmet kitchen with island, perfect for entertaining all of your friends, an oversized bedroom, and an independent laundry room make this home a dream come true! Don\'t miss the upstairs space large enough to be a game room or another living space. No direct neighbors, just lots of outdoor retreat space complete with your own blackberry vine! Call today to schedule your appointment!' ,`Acres` = '0.2032' ,`Area` = '58' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S5714 - SPRINGCREEK VILLAGE S/D, LOT 8A, PLAT 542A' ,`LotDesciption` = 'Greenbelt' ,`LotSize` = '8850' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '325' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '137 - Brenham' ,`SchoolElementary` = 'BISD DRAW' ,`SchoolHigh` = 'BRENHAM HIGH SCHOOL' ,`SchoolMiddle` = 'BRENHAM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Springcreek Village' ,`TaxAmount` = '4680' ,`TaxRate` = '2.0369' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663697661' WHERE `Matrix_Unique_ID` = '209697324' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T17:55:45.230' ,`MLSNumber` = '97364180' ,`ListAgentFullName` = 'Ivannia Recio' ,`ListOfficeName` = 'Ace Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.848969' ,`Longitude` = '-95.234373' ,`PhotoCount` = '32' ,`PostalCode` = '77078' ,`RoomCount` = '6' ,`ListPrice` = '194900.00' ,`Status` = 'Active' ,`StreetName` = 'Valley Flag' ,`StreetNumber` = '8634' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1208' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful updated 3 bed 2 baths with lots of upgrades! Home offers an open concept kitchen with lots of natural light and a great floorplan layout. New features new appliances and remodeled kitchen and bathrooms. New Paint and New fixtures and lots of space to entertain. Schedule your showing today!' ,`Acres` = '0.1263' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 13 BLK 4 PARKWOOD EAST SEC 1 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ELMORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkwood East Sec 01 R/P' ,`TaxAmount` = '3419' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697662' WHERE `Matrix_Unique_ID` = '209838110' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T17:54:44.843' ,`MLSNumber` = '43916727' ,`ListAgentFullName` = 'Ivannia Recio' ,`ListOfficeName` = 'Ace Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.849106' ,`Longitude` = '-95.234367' ,`PhotoCount` = '32' ,`PostalCode` = '77078' ,`RoomCount` = '6' ,`ListPrice` = '199900.00' ,`Status` = 'Active' ,`StreetName` = 'Valley Flag' ,`StreetNumber` = '8638' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1314' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful updated 3 bed 2 baths with lots of upgrades! Home offers an open concept kitchen with lots of natural light and a great floorplan layout. New features new appliances, and remodeled kitchen and bathrooms. New Paint and New fixtures and lots of space to entertain. Schedule your showing today!' ,`Acres` = '0.1263' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 12 BLK 4 PARKWOOD EAST SEC 1 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ELMORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Parkwood East Sec 01 R/P' ,`TaxAmount` = '3644' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663697662' WHERE `Matrix_Unique_ID` = '209839522' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T16:16:03.353' ,`MLSNumber` = '37838137' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.813923' ,`Longitude` = '-95.842735' ,`PhotoCount` = '6' ,`PostalCode` = '77493' ,`RoomCount` = '11' ,`ListPrice` = '879021.00' ,`Status` = 'Active' ,`StreetName` = 'Shoreline View' ,`StreetNumber` = '7002' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3959' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction by Shea Homes. Plan 6030. Estimated Completion 3/2023. This beautiful two story stucco home is located on a corner lot. As you enter the home, you will be amazed at the spacious entry with a soaring 20 ft ceiling. A study with french doors and a guest suite with full bath are located off the foyer. This home offers a total of 4 bedrooms, 4 full baths, and a half bath. Stacking slider doors are the perfect addition to the great room providing access to a large covered patio with an outdoor kitchen! The primary bedroom includes a bay window and a spa like bathroom with dual vanities and a freestanding tub. The kitchen features quartz countertops, stacked kitchen cabinets that extend to the ceiling, double oven, 5 burner gas cooktop, large island, and walk in pantry. Upstairs is the perfect spot to entertain family and friends with a huge gameroom and media room! Full gutters and a sprinkler system are included! Come and Live the Difference in a Shea Home!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Shea Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 6, Block 1, Section 32' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9517' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'French' ,`Subdivision` = 'Cane Island' ,`TaxAmount` = '' ,`TaxRate` = '3.4' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697662' WHERE `Matrix_Unique_ID` = '209987745' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T16:40:24.983' ,`MLSNumber` = '19632420' ,`ListAgentFullName` = 'Yesenia Gonzalez' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = 'David Tello' ,`SellingOfficeName` = 'Lions Gate Realty' ,`Latitude` = '29.937287' ,`Longitude` = '-95.255861' ,`PhotoCount` = '24' ,`PostalCode` = '77396' ,`RoomCount` = '10' ,`ListPrice` = '276900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Mystic Forest' ,`StreetNumber` = '4815' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1908' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well maintained home located conveniently near beltway 8 with easy access to Hwy 59. Brick exterior and fresh landscaping give this home lovely curb appeal. Recently updated bamboo flooring in bedrooms and hallway and neutral paint throughout. Open floor plan, one story layout with formal dining room. Backyard boasts a covered patio overlooking a generous sized backyard. Enjoy neighborhood amenities including splash pad, pools, soccer field, basketball court, clubhouse, gym and children\'s play space. Schedule your showing today!' ,`Acres` = '0.1263' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Humble Area East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 3 CANYON VILLAGE AT PARK LAKES SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'PARK LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'HUMBLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Vlg/Pk Lakes Sec 04' ,`TaxAmount` = '5551' ,`TaxRate` = '2.9873' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697662' WHERE `Matrix_Unique_ID` = '210355485' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T17:11:58.283' ,`MLSNumber` = '35901116' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Avery Taylor' ,`SellingOfficeName` = 'Nexthome Elite Advisors' ,`Latitude` = '29.852738' ,`Longitude` = '-95.742516' ,`PhotoCount` = '8' ,`PostalCode` = '77449' ,`RoomCount` = '4' ,`ListPrice` = '363990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Violet Ridge Way' ,`StreetNumber` = '21538' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2294' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW D.R. Horton\'s Express two story! Wonderful open floor plan! Island kitchen has lots of cabinets and is open to the breakfast room and family room! Large primary bedroom with a spacious closet! Features a large shower in the primary bathroom as well! Hard surface flooring in all living areas and modern designer details! Covered Patio overlooking the backyard! Landscape package included and so much more! Hurry and call today!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4 - Block 4 - Section 21' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7404' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'GOLBOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'MCDONALD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Jasmine Heights' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697662' WHERE `Matrix_Unique_ID` = '210819161' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T17:37:27.757' ,`MLSNumber` = '34922486' ,`ListAgentFullName` = 'Patricia Navar' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.159841' ,`Longitude` = '-95.072368' ,`PhotoCount` = '45' ,`PostalCode` = '77327' ,`RoomCount` = '12' ,`ListPrice` = '449900.00' ,`Status` = 'Active' ,`StreetName` = 'Road 5102L' ,`StreetNumber` = '177' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! No restrictions! No HOA! No MUD taxes. Lovely two-story custom-built 4-bedroom 2.5 bath home nestled on an oversized lot in Cleveland, Texas. Open concept floor plan with living/dining combo, island kitchen with seating, granite countertops, farmhouse sink, stainless steel appliances with plenty of storage! Spacious primary bedroom with an in-suite full bath, walk-in closet, including a private front balcony to sip your morning coffee while enjoying a gorgeous view of morning sunrises. Entertain family or guests on the oversized backyard terrace offering plenty of room for seating and your favorite patio furniture. Independent from the main house is a cozy 800 sq. ft. guest house which includes 2 bedrooms, 1 bath and a full kitchen with granite countertops and stainless steel appliances. Conveniently located minutes from Hwy 99 with an easy commute to town. Schedule your private showing today.' ,`Acres` = '0.32' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,No Disclosures,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SANTA FE, SEC 3, BLOCK 49, LOT 4874, ACRES .32' ,`LotDesciption` = 'Cleared' ,`LotSize` = '13939' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Other Style,Ranch,Traditional' ,`Subdivision` = 'Santa Fe Sec 7' ,`TaxAmount` = '879' ,`TaxRate` = '2.1513' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663697662' WHERE `Matrix_Unique_ID` = '211100976' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T17:02:47.400' ,`MLSNumber` = '87648535' ,`ListAgentFullName` = 'Lauren Raynes' ,`ListOfficeName` = 'Cornerstone, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.189285' ,`Longitude` = '-95.425458' ,`PhotoCount` = '40' ,`PostalCode` = '77515' ,`RoomCount` = '4' ,`ListPrice` = '459900.00' ,`Status` = 'Active' ,`StreetName` = 'Keystone' ,`StreetNumber` = '12' ,`StreetSuffix` = 'Court' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2560' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Custom and upgraded, this 4 bedroom, 2.5 bath home is sure to be a show stopper! This home boasts an open floor plan of 2200 sq ft with a finished upstairs bonus room, coffer ceiling in the primary bedroom, eye-catching cathedral ceiling in the living area as well as a corner fireplace and double French doors to an outdoor, covered patio! The remarkable attention to detail is not to be easily missed - come take a look and see what the home has to offer you!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Cornerstone Builders' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 62, BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'NORTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'GREYSTONE' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697662' WHERE `Matrix_Unique_ID` = '211225796' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T17:01:12.290' ,`MLSNumber` = '47718891' ,`ListAgentFullName` = 'Matias Bulox' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.762797' ,`Longitude` = '-95.888794' ,`PhotoCount` = '50' ,`PostalCode` = '77423' ,`RoomCount` = '9' ,`ListPrice` = '445000.00' ,`Status` = 'Active' ,`StreetName` = 'Twisting Springs Drive' ,`StreetNumber` = '30014' ,`StreetSuffix` = '' ,`City` = 'Brookshire' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2653' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Want to live in a brand new home, you have found the ideal one. This lovely home features a stone and brick exterior, once inside you are greeted by an open floor plan and a great layout. This home has 4 bedrooms, 3.5 baths, and a study making it a perfect size. It also offers a sleek white kitchen with lots of cabinet space, granite countertops, great size owners retreat, an en-suite bath with double sinks, a separate shower, and a soaking tub. This home is perfect for inviting friends and family and making new memories. Come visit and make it yours.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 23, Block 1, Tamarron Sec 36' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Willow Creek Farms' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663697663' WHERE `Matrix_Unique_ID` = '211365031' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T16:44:22.830' ,`MLSNumber` = '16131734' ,`ListAgentFullName` = 'Alex Westbrook-McCollum' ,`ListOfficeName` = 'Swede\'s Real Estate LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.401185' ,`Longitude` = '-94.713302' ,`PhotoCount` = '28' ,`PostalCode` = '77650' ,`RoomCount` = '5' ,`ListPrice` = '979000.00' ,`Status` = 'Active' ,`StreetName` = 'Marble' ,`StreetNumber` = '3802' ,`StreetSuffix` = 'Street' ,`City` = 'Port Bolivar' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Luxury on the Peninsula! This 3 bedroom and 2.5 bathroom is nestled on the slough in the highly sought after Biscayne subdivision. Enjoy the stunning views of the Gulf of Mexico on this beautiful deck!! The home features amazing high end finishes such as glass backsplash, shiplap walls, a huge walk in shower for the primary bathroom, fabulous LED lit mirrors, stainless steel appliances, and a bunk room to fit all of your guests. There is an attached garage to fit all of your beach toys and an outdoor shower to wash off the sand before coming inside. The Biscayne is a gated community with limited beach access by walkover to avoid traffic from non-property owners. Call for your private showing!' ,`Acres` = '0.2056' ,`Area` = '33' ,`BuilderName` = 'NXT Properties LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Port Bolivar' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'THE BISCAYNE SEC 3 (2006), ABST 162, BLOCK 1, LOT 81, ACRES' ,`LotDesciption` = 'Corner,Water View,Waterfront' ,`LotSize` = '8954' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'The Biscayne Sec 3 2006' ,`TaxAmount` = '577' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697663' WHERE `Matrix_Unique_ID` = '211369931' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T16:10:50.443' ,`MLSNumber` = '94175990' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.221248' ,`Longitude` = '-95.240160' ,`PhotoCount` = '18' ,`PostalCode` = '77357' ,`RoomCount` = '5' ,`ListPrice` = '315740.00' ,`Status` = 'Active' ,`StreetName` = 'Starry Night' ,`StreetNumber` = '21554' ,`StreetSuffix` = '' ,`City` = 'New Caney' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2041' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FANTASTIC BRAND NEW DR HORTON HOME! AMAZING 1 STORY FLOOR PLAN WITH 3 CAR GARAGE!!! Perfect location!!! Spacious island kitchen with great space for entertaining! Modern finishes and designer details at every corner!! Primary suite secluded to back of the home for privacy with spa like bath retreat! Also features a home office!! Wonderful outdoor space with landscape package and covered patio!! Hurry and call TODAY!!' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '08/04/08' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'TIMBER LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harrington Trails' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697663' WHERE `Matrix_Unique_ID` = '211370066' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T16:30:53.900' ,`MLSNumber` = '44856772' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.221248' ,`Longitude` = '-95.240160' ,`PhotoCount` = '18' ,`PostalCode` = '77357' ,`RoomCount` = '5' ,`ListPrice` = '317990.00' ,`Status` = 'Active' ,`StreetName` = 'Owl Road' ,`StreetNumber` = '21382' ,`StreetSuffix` = '' ,`City` = 'New Caney' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2482' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FANTASTIC NEW D. R. HORTON BUILT HOME! Great Open Concept Interior Layout! Lovely Foyer Opens Onto Gourmet Island Kitchen with Corner Walk-In Pantry, Light & Bright Breakfast Area, & Spacious Living Area! Privately Located Primary Suite Offers Great Bath with Large Shower & Walk-In Closet! Indoor Utility Room! Covered Patio Overlooks Wonderful Backyard! Incredible Community with Trails, Rec Center, SplashPad, Pool, AND Elementary School in Subdivision! WOW!' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 47/ Block 1/ Section 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6880' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'TIMBER LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harrington Trails' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697663' WHERE `Matrix_Unique_ID` = '211371850' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T16:53:39.093' ,`MLSNumber` = '69566384' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Pulte Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.620399' ,`Longitude` = '-95.207647' ,`PhotoCount` = '6' ,`PostalCode` = '77034' ,`RoomCount` = '5' ,`ListPrice` = '316450.00' ,`Status` = 'Active' ,`StreetName` = 'Adobe Shores' ,`StreetNumber` = '12406' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1824' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'January estimated completion. This oversized homesite has no rear neighbors and a 40\' deep and 51 wide backyard with full sprinkler system included. The Springfield has a 2 story entry which leads to an inviting and open living space which features wood look LVP throughout the first floor. HUGE Kitchen has 42\" white cabinets with marble look laminate countertops. Family and friends have plenty of countertop space, and gathering space in this Springfield floorplan.' ,`Acres` = '' ,`Area` = '3' ,`BuilderName` = 'Centex' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 23, Block 1, Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'GENOA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (PASADENA)' ,`SchoolMiddle` = 'BONDY INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Clearwick' ,`TaxAmount` = '' ,`TaxRate` = '2.69' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697663' WHERE `Matrix_Unique_ID` = '211372576' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T16:46:11.637' ,`MLSNumber` = '86141737' ,`ListAgentFullName` = 'Paula Forno-Engler' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.806399' ,`Longitude` = '-95.389142' ,`PhotoCount` = '18' ,`PostalCode` = '77008' ,`RoomCount` = '6' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Main' ,`StreetNumber` = '6107-6109' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1196' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Two Houses sold together 6107 & 6109 N Main St. Both houses have been completely remodeled and\r\nwonderfully reimagined. Great opportunity to live in The Heights. Living and dining opens to\r\nbreakfast bar and kitchen. Homes feature wood floors throughout, windows with blinds, quartz\r\ncountertops, stainless steel appliances, indoor utility room and plenty of storage space.\r\nShared driveway gate with parking space in the back. Fully fenced back patio.\r\n6107- 623 sq ft & 6109- 573 sq ft.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'NA' ,`LotDesciption` = 'Cleared' ,`LotSize` = '3632' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'FIELD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gostick' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663697663' WHERE `Matrix_Unique_ID` = '211373025' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T16:54:58.807' ,`MLSNumber` = '60510669' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.221248' ,`Longitude` = '-95.240160' ,`PhotoCount` = '8' ,`PostalCode` = '77357' ,`RoomCount` = '5' ,`ListPrice` = '345740.00' ,`Status` = 'Active' ,`StreetName` = 'Owl Road' ,`StreetNumber` = '21386' ,`StreetSuffix` = '' ,`City` = 'New Caney' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2561' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FANTASTIC NEW D. R. HORTON BUILT HOME! Amazing 2 story plan!!! Great Open Concept Interior Layout! Lovely Foyer Opens Onto Gourmet Island Kitchen with Corner Walk-In Pantry, Light & Bright Breakfast Area, & Spacious Living Area! Privately Located Primary Suite Offers Great Bath with Large Shower & Walk-In Closet! Indoor Utility Room! Game Room!! Covered Patio Overlooks Wonderful Backyard! Incredible Community with Trails, Rec Center, SplashPad, Pool, AND Elementary School in Subdivision! WOW!' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '46/01/08' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8179' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'TIMBER LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harrington Trails' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697663' WHERE `Matrix_Unique_ID` = '211373132' --> Updated record success