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-17T10:28:54.333' ,`MLSNumber` = '48048794' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.877218' ,`Longitude` = '-95.456727' ,`PhotoCount` = '6' ,`PostalCode` = '77422' ,`RoomCount` = '2' ,`ListPrice` = '64500.00' ,`Status` = 'Active' ,`StreetName` = 'Channel' ,`StreetNumber` = '1580' ,`StreetSuffix` = 'Drive' ,`City` = 'Brazoria' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '756' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Water front property, imagine the amazing views! This home consists of 2 bedrooms and 1 bath. Features a nice patio deck great for entertaining and those summer BBQs, and large yard for your pets and kids to play in! Located in a growing and expanding area with so much opportunity! As is.\r\n\r\nPropiedad frente al agua del lago Pelican! Esta casa consta de 2 dormitorios y 1 baño, y cuenta con una cubierta de patio agradable y un patio grande. Como es.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'UPTON-BAILEY (A0137 P WILLIAMS), LOT 4, ACRES 0.120' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5227' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Other' ,`SchoolDistrict` = '51 - Sweeny' ,`SchoolElementary` = 'SWEENY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SWEENY HIGH SCHOOL' ,`SchoolMiddle` = 'SWEENY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Upton-Bailey' ,`TaxAmount` = '164' ,`TaxRate` = '2.32333' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699799' WHERE `Matrix_Unique_ID` = '177076752' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T10:26:51.690' ,`MLSNumber` = '30442686' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.052534' ,`Longitude` = '-95.566862' ,`PhotoCount` = '18' ,`PostalCode` = '77422' ,`RoomCount` = '2' ,`ListPrice` = '164999.00' ,`Status` = 'Active' ,`StreetName` = 'Spencer' ,`StreetNumber` = '110' ,`StreetSuffix` = 'Street' ,`City` = 'Brazoria' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1767' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Excellent home for first time buyers! This country styled home consists of 2 bedrooms, 1 bathroom and located in Brazoria, TX. Walk into the lovely living room and enjoy all the natural lighting this home has to offer. This home is move in ready and features some sweet updates. It features new exterior and interior paint, new vinyl flooring in the kitchen area and living room area, as well as new carpet throughout. You will love this kitchen\'s painted cabinets, replaced countertops, as well as a new sink and faucet. The bathroom area has been renovated with a new tub for you to relax in, new toilet, vanity, and mirror. This home also features a roof replacement and foundation repairs! What are you waiting for? Give us a call and schedule a tour today!' ,`Acres` = '0.451' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'No Heating,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LAKESIDE SD (BRAZORIA), BLOCK 4, LOT 8' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '19646' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakeside SD Brazoria' ,`TaxAmount` = '2509' ,`TaxRate` = '2.5527' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1938' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699799' WHERE `Matrix_Unique_ID` = '177260476' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T10:10:24.850' ,`MLSNumber` = '18879235' ,`ListAgentFullName` = 'Lyla Gillaspie' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.531168' ,`Longitude` = '-94.108184' ,`PhotoCount` = '49' ,`PostalCode` = '75972' ,`RoomCount` = '9' ,`ListPrice` = '270000.00' ,`Status` = 'Active' ,`StreetName` = 'LIVINGSTON' ,`StreetNumber` = '208' ,`StreetSuffix` = 'Street' ,`City` = 'San Augustine' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2135' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Quiet, small town living at it\'s best. San Augustine, one of the oldest towns in Texas, nestled in the beautiful rolling hills of East Texas. This is a beautiful 1937 solid built brick Tudor-style home has tons of character and charm! The home is warm and inviting, reminiscent of the good ole days. The updates include, central ac/heat, double insulated (Don Young) windows throughout! The attic has been insulated, home rewired in 2004 and re plumbed in 2004. Peterson gas logs. All eves/facia board on exterior of home have been replaced with Hardie Board to make this home almost maintenance free! Beautiful hardwood floors throughout except kitchen and bath area. 5 spacious bedrooms. Beautiful crown/base moldings throughout. Spacious backyard is fully fenced. Lush mature landscaping. This home sits on a large corner lot with a great view of the historic First Presbyterian church in built 1836 and just 2 blocks from Historic downtown San Augustine.' ,`Acres` = '' ,`Area` = '78' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 88 BLK 14 SAN AUGUSTINE & IMPROVEMENT' ,`LotDesciption` = 'Corner' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '241 - San Augustine' ,`SchoolElementary` = 'SAN AUGUSTINE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SAN AUGUSTINE HIGH SCHOOL' ,`SchoolMiddle` = 'SAN AUGUSTINE HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'English' ,`Subdivision` = 'SAN AUGUSTINE, TEXAS' ,`TaxAmount` = '1095' ,`TaxRate` = '2.2657' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1937' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663699799' WHERE `Matrix_Unique_ID` = '204341834' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T11:11:14.967' ,`MLSNumber` = '81658130' ,`ListAgentFullName` = 'Sterling Bond' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.209585' ,`Longitude` = '-95.089456' ,`PhotoCount` = '24' ,`PostalCode` = '77327' ,`RoomCount` = '7' ,`ListPrice` = '245000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 347' ,`StreetNumber` = '1834' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1032' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW RENOVATION! Welcome to this gorgous 3 bedroom, 2 bath recently renovated Traditional craftsman home on 2+ acres of land. Everything is brand new throughout the entire home, and ample space in the backyard to create your very own version of a backyard oasis! Do not miss out on this ASTOUNDING home. Schedule your showing today!' ,`Acres` = '2.2971' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '000208 A HOLHOUSEN, TRACT 177, ACRES 2.2971' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '100062' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'A Holhousen' ,`TaxAmount` = '2684' ,`TaxRate` = '2.2178' ,`WaterSewer` = 'Well' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699799' WHERE `Matrix_Unique_ID` = '205126515' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T11:20:06.507' ,`MLSNumber` = '85620820' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = 'Zoraya Vela' ,`SellingOfficeName` = 'Doug Erdy Group' ,`Latitude` = '29.659700' ,`Longitude` = '-95.049500' ,`PhotoCount` = '16' ,`PostalCode` = '77571' ,`RoomCount` = '11' ,`ListPrice` = '389107.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Birdsong Crane' ,`StreetNumber` = '4005' ,`StreetSuffix` = 'Court' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2476' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Fall in love with this stunning Beazer home in Morgan’s Landing, boasting a brick façade, tile flooring, an open great room, a study with French doors, and a covered patio. Prepare incredible feasts in the kitchen, equipped with quartz countertops, mosaic backsplash, stainless steel appliances, 42” upper cabinets, pendant lighting, and under-counter lighting. With dual vanities and a shower, the primary suite is a wonderful place to unwind. Located in La Porte, this community gives residents easy access to Kemah, the Houston Ship Channel, and Bay Area. Clear Lake and the Johnson Space Center are just minutes away! Morgan’s Landing’s amenities include a dog park, resort-style pool, pocket parks, lakes, and walking trails. Schools are zoned to La Porte ISD. Arrange your private showing today!' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 10 Block 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'LOMAX ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Morgan\'s Landing' ,`TaxAmount` = '' ,`TaxRate` = '3.543251' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699799' WHERE `Matrix_Unique_ID` = '206092764' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T11:29:05.377' ,`MLSNumber` = '68354475' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = 'Beckie Martinez' ,`SellingOfficeName` = 'Keller Williams RealtyNortheast' ,`Latitude` = '29.806614' ,`Longitude` = '-94.893404' ,`PhotoCount` = '14' ,`PostalCode` = '77523' ,`RoomCount` = '8' ,`ListPrice` = '314887.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Tramontana' ,`StreetNumber` = '7635' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1651' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Feel at ease in this beautiful Beazer home in Southwinds, boasting a brick façade, tile flooring, an open great room, and an extended covered patio. Whip up meals for guests in the kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, and pendant lighting. The serene primary suite features dual vanities and a shower. With direct access to the Grand Parkway and I-10, commuters from Southwinds love the easy drive to Downtown Houston and other major business areas. A variety of popular restaurants, shops, and beaches are only a short distance away. Community comforts include a pool, recreation center, playground, and picnic area. Schools are zoned to Goose Creek CISD. Call today to learn more!' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Chambers County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'CLARK ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Southwinds' ,`TaxAmount` = '' ,`TaxRate` = '2.86069' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699799' WHERE `Matrix_Unique_ID` = '206141647' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T11:26:40.987' ,`MLSNumber` = '81378489' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = 'Crystal Diaz' ,`SellingOfficeName` = 'Keller Williams HoustonCentral' ,`Latitude` = '29.804262' ,`Longitude` = '-94.887309' ,`PhotoCount` = '18' ,`PostalCode` = '77523' ,`RoomCount` = '12' ,`ListPrice` = '367000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Gentle Breeze' ,`StreetNumber` = '2418' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2304' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Amazing Beazer home in Southwinds has it all, boasting a brick façade, sloped ceilings, tile flooring, a study with French doors, an open great room, and an extended covered patio. Spend quality time in the kitchen, equipped with quartz countertops, mosaic backsplash, stainless steel appliances, and 42” upper cabinets. Relax in the tranquil primary suite features a walk-in closet, dual vanities, a tub, and a separate shower. With direct access to the Grand Parkway and I-10, commuters from Southwinds love the easy drive to Downtown Houston and other major business areas. A variety of popular restaurants, shops, and beaches are only a short distance away. Community comforts include a pool, recreation center, playground, and picnic area. Schools are zoned to Goose Creek CISD. You don’t want to miss this home!' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Chambers County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 14 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'CLARK ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Southwinds' ,`TaxAmount` = '' ,`TaxRate` = '2.86069' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699800' WHERE `Matrix_Unique_ID` = '206231637' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T10:51:23.833' ,`MLSNumber` = '67012625' ,`ListAgentFullName` = 'Mohammed Bhuiyan' ,`ListOfficeName` = 'Bengal Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.676225' ,`Longitude` = '-95.671940' ,`PhotoCount` = '10' ,`PostalCode` = '77498' ,`RoomCount` = '8' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Virginia Grace' ,`StreetNumber` = '16310' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2439' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1314' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'EAGLEWOOD SEC 8, BLOCK 1, LOT 41' ,`LotDesciption` = 'Cleared,Cul-De-Sac' ,`LotSize` = '5725' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '435' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HOLLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'HODGES BEND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Eaglewood Sec 8' ,`TaxAmount` = '4816' ,`TaxRate` = '2.2989' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699800' WHERE `Matrix_Unique_ID` = '207688147' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T11:11:40.380' ,`MLSNumber` = '93308534' ,`ListAgentFullName` = 'Kay Krampitz' ,`ListOfficeName` = 'Texas Trust Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.772705' ,`Longitude` = '-96.166494' ,`PhotoCount` = '15' ,`PostalCode` = '77474' ,`RoomCount` = '6' ,`ListPrice` = '283000.00' ,`Status` = 'Active' ,`StreetName` = 'Shadowlake' ,`StreetNumber` = '1213' ,`StreetSuffix` = 'Drive' ,`City` = 'Sealy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1602' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL SHADE TREES!!!! This Awesome Custom Brick Home is in a great neighborhood and is in like-new condition surrounded by mature trees. The Living Room is so cozy and open to the dining room and kitchen. Privacy fenced yard with a 10x36 covered back porch. Double Wide concrete driveway with spacious attached 2 car garage. Kitchen has freshly painted cabinets, granite counter tops, built in oven, microwave, DW and huge walk-in Pantry. Laundry room closet with built in Cabinets. New Luxury Vinyl Plank Flooring, Lighted ceiling rans and tons of storage. Hurry, this one will not last long.' ,`Acres` = '0.172' ,`Area` = '57' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WESTVIEW SHADOWS BLOCK 1 LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7492' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '109 - Sealy' ,`SchoolElementary` = 'SELMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEALY HIGH SCHOOL' ,`SchoolMiddle` = 'SEALY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westview Shadows' ,`TaxAmount` = '3866' ,`TaxRate` = '2.149' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699800' WHERE `Matrix_Unique_ID` = '208628405' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T11:40:47.480' ,`MLSNumber` = '72352971' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Sandra Billings' ,`SellingOfficeName` = 'Billings Real Estate Group' ,`Latitude` = '29.877451' ,`Longitude` = '-95.793282' ,`PhotoCount` = '32' ,`PostalCode` = '77493' ,`RoomCount` = '12' ,`ListPrice` = '449953.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Winterberry Glen' ,`StreetNumber` = '7203' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2420' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Haven, Elevation C) CURRENTLY BEING BUILT. Two story. 4 bedrooms. 3 baths. Spacious island kitchen open to informal dining room and family room. Primary suite with large walk-in closet as well as secondary bedroom on first floor. Spacious game room upstairs. Covered patio and attached 2 car garage. Just minutes from the Grand Parkway, Elyson is located in the Heart of Katy! The Elyson Café is the center of this community and offers a full food and drinks menu plus a coffee bar. Community amenities also include a pool, fitness center, game room, event lawn, tennis courts, parks and trails, and so much more. Stop by the Westin Homes model to learn more about Elyson!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 8 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6016' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1242' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Elyson' ,`TaxAmount` = '' ,`TaxRate` = '3.4' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699800' WHERE `Matrix_Unique_ID` = '208690788' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T11:40:49.150' ,`MLSNumber` = '89395397' ,`ListAgentFullName` = 'Wayne Ngo' ,`ListOfficeName` = 'The Nguyens & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.336079' ,`Longitude` = '-95.310070' ,`PhotoCount` = '35' ,`PostalCode` = '77303' ,`RoomCount` = '4' ,`ListPrice` = '214500.00' ,`Status` = 'Active' ,`StreetName` = 'Crockett Bend' ,`StreetNumber` = '16389' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2128' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Home in the Quiet Crockett Trace Subdivision. House is Fully Renovated with the following Upgrades: New Interior and Exterior Paint, Remodeled Kitchen and Bathrooms, Granite Countertop, Stainless Steel Appliances, and Many More. Call to Schedule your Private Showing Today!!!!' ,`Acres` = '1.0118' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S356100 - CROCKETT TRACE 01, BLOCK 3, LOT 7, SERIAL # 123365' ,`LotDesciption` = 'Other' ,`LotSize` = '44074' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '260' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Crockett Trace 01' ,`TaxAmount` = '2562' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699800' WHERE `Matrix_Unique_ID` = '208957098' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T10:02:43.070' ,`MLSNumber` = '72366573' ,`ListAgentFullName` = 'Darren Morris' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.807530' ,`Longitude` = '-95.431447' ,`PhotoCount` = '10' ,`PostalCode` = '77008' ,`RoomCount` = '0' ,`ListPrice` = '2950000.00' ,`Status` = 'Active' ,`StreetName` = '24th' ,`StreetNumber` = '1816' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '0' ,`BathsHalf` = '0' ,`BedsTotal` = '0' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Very Rare-Unrestricted land inside the loop. Ready for residential, office building, retail, or industrial. On a quiet dead-end street right in the heart of Shady Acres, only 150 feet away from the North entrance to Little Thicket Park. New construction is all around. Walking distance to award winning Heights restaurants like Crisp, Barking Pig, King\'s Bierhaus, Cedar Creek Bar & Cafe, Tony\'s, Rainbow Lodge, and Cavatore. Three blocks away from access to the White Oak Hike and Bike Trail. Easy access to highway and close to great retail shopping-minutes away from the Galleria and Downtown. Improvements on the property include city water and sewer, electricity, cable, natural gas. House on lot does not stay, to be removed within 180 days after closing. Lots included are 1724, 1728, 1814, and 1816 W 24th. 90% of Shady Acres has been replatted. Did NOT flood in Allison or Harvey.\r\nPossible to add 1803, 1807, and 1815 W 23rd AND virtually the entire block on W 24th.' ,`Acres` = '1.14' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 171D-1 171D-3 172C 172D & 172F SHADY ACRES SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '49797' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Shady Acres Sec 02' ,`TaxAmount` = '19868' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663699800' WHERE `Matrix_Unique_ID` = '209092344' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T11:09:31.560' ,`MLSNumber` = '29643591' ,`ListAgentFullName` = 'Pablo Guerrero' ,`ListOfficeName` = 'Lucky Money Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.151543' ,`Longitude` = '-95.535447' ,`PhotoCount` = '24' ,`PostalCode` = '77389' ,`RoomCount` = '13' ,`ListPrice` = '1490000.00' ,`Status` = 'Active' ,`StreetName` = 'Johnathan Landing' ,`StreetNumber` = '27' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4496' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in Carlton Woods Fazio, this residence offers great open spaces to entertain friends and family. Hardwood flooring, four fireplaces, a formal dining room, open-plan gourmet kitchen with stainless steel appliances and granite island. The living room has double height ceilings and white bay windows with motorized drapery and french doors opening out to the backyard patio with a heated pool and spa and a separate dining area with grill. The house has four bedrooms, a media room, a library and lots of storage. The bedroom on the main level has french doors to the backyard and pool. The master bedroom is located on the second level and has a built-out walk-in closet, fireplace, and a balcony with a nice view. The master bath has a double shower and a spa-tub. The two other bedrooms upstairs have their own bathroom and closet. Downstairs, the library with floor to ceiling bookshelves can be used as a home-office. This house has an independent full-size room w/bathroom in the garage.' ,`Acres` = '0.2258' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '4' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 3 THE WOODLANDS CARLTON WOODS CREEKSIDE 6 IN THE VI' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '9838' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Slate' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TIMBER CREEK ELEMENTARY SCHOOL (Tomball)' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'The Woodlands Carlton Woods Creekside 06' ,`TaxAmount` = '33485' ,`TaxRate` = '2.6895' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699800' WHERE `Matrix_Unique_ID` = '209392417' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T10:22:30.243' ,`MLSNumber` = '59045990' ,`ListAgentFullName` = 'Faye Ausmus' ,`ListOfficeName` = 'Ausmus Premier Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.420578' ,`Longitude` = '-97.984718' ,`PhotoCount` = '15' ,`PostalCode` = '78155' ,`RoomCount` = '4' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Old Colony' ,`StreetNumber` = '436' ,`StreetSuffix` = 'Road' ,`City` = 'Seguin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1120' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A Private, Quiet, Unrestricted 11 Acre Haven Awaits! Paved Road Frontage. Make this 1,120sqft, 3 Bedroom, 2 bath your home sweet home. Plenty of room to roam or add additional buildings. Bring your livestock, the sky is the limit here. The land is level and cleared in the front and mature oak trees throughout the back. The property is mostly fenced, with a pond, gated entrance, barn, and 2 RV hookups. The 1,728sqft barn has 4 12x12 stalls with windows and 2 storage/tack rooms and water and electric. The front of the home sits way back off the road giving plenty of room for the kids to roam. An additional 5 acres is available for purchase adjacent to property. 8 minutes to the brand new Dollar General, 18 minutes to the HEB plus in Seguin, 22 minutes to Blakes Cafe, 30 minutes to Lake McQueeney, and 30 minutes to New Braunfels. Don\'t wait, this little piece of Texas won\'t last long!' ,`Acres` = '11.15' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABS: 59 SUR: J O BLAIR 11.1500AC MH=PFS0878301/302' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '157 - Seguin' ,`SchoolElementary` = 'VOGEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEGUIN HIGH SCHOOL (SEGUIN)' ,`SchoolMiddle` = 'A.J. BRIESEMEISTER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jakes Colony Sub' ,`TaxAmount` = '4837' ,`TaxRate` = '1.6645' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699800' WHERE `Matrix_Unique_ID` = '209884175' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T10:42:26.210' ,`MLSNumber` = '91227067' ,`ListAgentFullName` = 'Rebecca Vera' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.088211' ,`Longitude` = '-95.361594' ,`PhotoCount` = '35' ,`PostalCode` = '77386' ,`RoomCount` = '11' ,`ListPrice` = '1199900.00' ,`Status` = 'Active' ,`StreetName` = 'Benders Landing' ,`StreetNumber` = '27303' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Spring' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3874' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Extraordinary Custom Home located deep in the middle of the highly desired Benders Landing. This striking one-story home with it\'s own private entrance, exceptional interior and amazing outdoor living environments is a homeowner\'s dream. Imagine driving up to a private driveway and parking in one of three roomy garage spots. Then stepping through the elegant double glass door entry and leaving the hectic world behind. Once inside you have your choice to walk to the Primary Retreat, or visit the Study and Music room, or stride into the Kitchen to start preparing that gourmet meal while sipping a glass of your favorite beverage. Enjoy your meals in the gorgeous dining room and it\'s breath-taking chandelier, recessed ceiling, and open concept; or take your meals outside to one of the many outdoor entertaining areas and enjoy the striking sunrises and sunsets.' ,`Acres` = '1.0367' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BENDERS LANDING 02, BLOCK 16, LOT 12' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '45159' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '920' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'ANN K. SNYDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Benders Landing' ,`TaxAmount` = '13124' ,`TaxRate` = '1.8487' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699801' WHERE `Matrix_Unique_ID` = '210104611' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T11:08:21.000' ,`MLSNumber` = '49185307' ,`ListAgentFullName` = 'Vinod Ramani' ,`ListOfficeName` = 'Urban Living' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.772728' ,`Longitude` = '-95.322560' ,`PhotoCount` = '12' ,`PostalCode` = '77020' ,`RoomCount` = '9' ,`ListPrice` = '369990.00' ,`Status` = 'Active' ,`StreetName` = 'Market' ,`StreetNumber` = '4708' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1955' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'In the flourishing area of East Downtown lies Market Street. Market Street is walking distance from Midway\'s East River Project. These Single-Family homes offer Contemporary designs and hand selected finishes. Each home features an open concept living/dining/kitchen area perfect for urban lifestyle. This community features private driveways and large back yards.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Joes Construction' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 2 Block 1 N/A' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HENDERSON N ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'N/A' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699801' WHERE `Matrix_Unique_ID` = '210125296' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T10:54:24.150' ,`MLSNumber` = '97703464' ,`ListAgentFullName` = 'Katherine Maher' ,`ListOfficeName` = 'Keller Williams Advtge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.345341' ,`Longitude` = '-95.597705' ,`PhotoCount` = '23' ,`PostalCode` = '77316' ,`RoomCount` = '7' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Apache' ,`StreetNumber` = '1372 & 1378' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1264' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COUNTRY LIVING AMONG TREES, LIGHTED TENNIS COURT, ALL THIS ON 1.4100 ACRES. Comes with two separate homes both on the same well and septic. 1372 is 2/2 with LARGE LIVING AREA/LARGE EATING AREA, Cathedral ceiling, rock fireplace, newer roof, nice open floor plan large back porch. 1378 is another home on the property it is pier & beam, 1/1 perfect for a guest house or mother-in-law home. 1378 front yard is fenced in with cute picket fencing. Looking for a peaceful place to call home? This is it, come on out and take a tour of these two cute homes. Shared driveway with two story house at top of hill on Right' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'CRESTWOOD FARMS, LOT 19-E, ACRES 1.410' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '61420' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'KEENAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'CRESTWOOD FARMS' ,`TaxAmount` = '1065' ,`TaxRate` = '2.3413' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699801' WHERE `Matrix_Unique_ID` = '210230870' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T10:56:06.340' ,`MLSNumber` = '35910280' ,`ListAgentFullName` = 'Erik Jeffreys' ,`ListOfficeName` = 'World Wide Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.420721' ,`Longitude` = '-95.554835' ,`PhotoCount` = '22' ,`PostalCode` = '77318' ,`RoomCount` = '8' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Ridgecrest' ,`StreetNumber` = '12339' ,`StreetSuffix` = 'Drive' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2024' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come relax and enjoy this spacious 3 bed, 2 and-a-half bath with a game room in the envied Lake Conroe Hills subdivision. Kick off your shoes, sit back, and enjoy the sunshine and smell of the fresh-air flowing from Lake Conroe after a hard day\'s work! New appliances! New paint! New carpet! Residents enjoy a neighborhood boat ramp, private docking facilities, community parks and a corner grocery store within the neighborhood. With easy access to I-45 and comfortable living, Lake Conroe Hills provides residents with a peaceful year-round escape!' ,`Acres` = '0.2152' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LAKE CONROE HILLS 02, BLOCK 11, LOT 68' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9375' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Conroe Hills 02' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699801' WHERE `Matrix_Unique_ID` = '210534870' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T11:03:15.830' ,`MLSNumber` = '93447838' ,`ListAgentFullName` = 'Lynne Hoban-Montez' ,`ListOfficeName` = 'Keller Williams Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.460172' ,`Longitude` = '-95.540531' ,`PhotoCount` = '27' ,`PostalCode` = '77318' ,`RoomCount` = '3' ,`ListPrice` = '145000.00' ,`Status` = 'Active' ,`StreetName` = 'Darkwood' ,`StreetNumber` = '9592' ,`StreetSuffix` = 'Street' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1512' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Near the lake? CHECK! Shopping and medical care close by? CHECK! Affordable and ready to move in? CHECK! Come visit this Lake Conroe area subdivision with boat launch and new docks and check off more wish list boxes. The home is a split plan, roomy and inviting. This community has a swimming pool, playground, community center, Seniors Friendship Club, neighborhood watch, and easy access to Lake Conroe. Generator (propane/gasoline) conveys to keep AC and fridge cold in case of outages. Hall bathroom has been remodeled, all toilets are new. New washer being installed. HVAC a few years old. Foundation leveled in 2020. Yearly termite inspection and treatment for prevention has been done. A 10 x 20 storage building has been plumbed for water and sewer. Three lots provide spacious areas for gardening, relaxing.' ,`Acres` = '0.14' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S946201 - WALNUT COVE 01, BLOCK 14, LOT 19,20,21, SERIAL OC0' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '91' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'PARMLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Walnut Cove 01' ,`TaxAmount` = '1698' ,`TaxRate` = '1.8448' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699801' WHERE `Matrix_Unique_ID` = '210780815' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T11:17:53.707' ,`MLSNumber` = '51637676' ,`ListAgentFullName` = 'Lawrence Adams' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.438649' ,`Longitude` = '-95.750663' ,`PhotoCount` = '31' ,`PostalCode` = '77469' ,`RoomCount` = '12' ,`ListPrice` = '344900.00' ,`Status` = 'Active' ,`StreetName` = 'Vacek Meadows' ,`StreetNumber` = '8018' ,`StreetSuffix` = 'Loop' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2593' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home is like new with less than 6 months occupancy. Seller\'s move because of New Job. This open and spacious two-story home at Vacek Country Meadows features incredible entertaining space with a private dining room, spacious kitchen with breakfast bar, a huge family room, and an extended covered back patio. The upgraded kitchen includes stunning wood cabinetry, granite countertops, recessed LED lighting, luxury vinyl plank flooring, and a full suite of appliances by Whirlpool, including a refrigerator and built-in microwave. The private owner’s retreat features a soaker tub, a step-in shower, and a large walk-in closet. Two additional bedrooms and a second full bathroom offer space for a home office or hobbies! Tour this home today and experience the peaceful neighborhood of Vacek Country Meadows, where you will enjoy a friendly setting with open green spaces, sidewalks and street lights throughout the community.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Vacek Country Meadows Sec 2, BLOCK 6, Lot 25' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '38 - Needville' ,`SchoolElementary` = 'NEEDVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEEDVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'NEEDVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Vacek Country Meadows' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699801' WHERE `Matrix_Unique_ID` = '210817139' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T10:27:22.250' ,`MLSNumber` = '20132969' ,`ListAgentFullName` = 'Claudia Da Silva' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.195078' ,`Longitude` = '-95.539002' ,`PhotoCount` = '50' ,`PostalCode` = '77382' ,`RoomCount` = '25' ,`ListPrice` = '6900000.00' ,`Status` = 'Active' ,`StreetName` = 'Grand Regency' ,`StreetNumber` = '51' ,`StreetSuffix` = 'Circle' ,`City` = 'The Woodlands' ,`BathsFull` = '8' ,`BathsHalf` = '4' ,`BedsTotal` = '8' ,`SqFtTotal` = '21353' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spectacular architecture on 2.5 acres of breathtaking grounds on the entire property. Timeless in design and transitional and airy on the inside. It is rare to find a residence with 21,000 sqft, with a three story foyer, American Cherry Hardwoods, Classic Moldings, Alder Doors, Rocky Mountain Hardware, Osborne Cabinetry, Venetian Plaster, Hollywood Fixtures, Walker Zanger Stone, Isokerm Fireplaces, Viking and Subzero appliances. A classic Library with Private Office. A 300+ Bottle Wine room. The kitchen, breakfast and family views to the back overlooking pool, golf course (Jack Nicklaus Holes No 7 & 8) and bear branch lake. Double island, double dishwashers, coffee stations and views galore in the front gardens and back. Mature trees and landscape all around the property make the property feel like a completely private retreat. With 8 bedrooms that include a guest apartment. 9 Car Climatized Garage w/ 6 Hydraulic Lifts, Elevator, Conservatory & Beyond.' ,`Acres` = '2.4331' ,`Area` = '15' ,`BuilderName` = 'Charles R Martin' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '8' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'WDLNDS VIL OF CARLTON WOODS 04, BLOCK 1, LOT 20' ,`LotDesciption` = 'On Golf Course,Water View,Wooded' ,`LotSize` = '105986' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '4250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '9' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'TOUGH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'French' ,`Subdivision` = 'Wdlnds Village Of Carlton Woods 04' ,`TaxAmount` = '106492' ,`TaxRate` = '2.1816' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663699802' WHERE `Matrix_Unique_ID` = '210895843' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T11:23:04.963' ,`MLSNumber` = '86163890' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = 'Tracy Halverson' ,`SellingOfficeName` = 'Realty ONE Group, Experience' ,`Latitude` = '29.659817' ,`Longitude` = '-95.053657' ,`PhotoCount` = '50' ,`PostalCode` = '77571' ,`RoomCount` = '15' ,`ListPrice` = '552560.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Corbin Crest' ,`StreetNumber` = '733' ,`StreetSuffix` = 'Trail' ,`City` = 'La Porte' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3468' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy the lakefront view of this Beazer Home in Morgan’s Landing, featuring a brick façade, tile flooring, wrought iron spindles, a cast stone fireplace, a media room, a formal dining room, a study with French doors, an open great room, and an extended covered patio. Try new recipes in the kitchen, equipped with granite countertops, a mosaic backsplash, a double oven, a 36” cooktop, stainless steel appliances, 42” upper cabinets, pendant lighting, and under-counter lighting. The serene primary suite boasts a walk-in closet, dual vanities, and a mudset shower. Located in La Porte, this community gives residents easy access to Kemah, the Houston Ship Channel, and Bay Area. Clear Lake and the Johnson Space Center are just minutes away! Morgan’s Landing’s amenities include a dog park, resort-style pool, pocket parks, lakes, and walking trails. Schools are zoned to La Porte ISD. Call now to learn more!' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 8 Block 2' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'JENNIE REID ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Morgan\'s Landing' ,`TaxAmount` = '' ,`TaxRate` = '3.543251' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699802' WHERE `Matrix_Unique_ID` = '211102195' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T10:11:58.430' ,`MLSNumber` = '6575687' ,`ListAgentFullName` = 'Stephen Metarelis' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.892292' ,`Longitude` = '-95.483315' ,`PhotoCount` = '9' ,`PostalCode` = '77088' ,`RoomCount` = '3' ,`ListPrice` = '259900.00' ,`Status` = 'Active' ,`StreetName` = 'Bold Forest' ,`StreetNumber` = '8619' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1735' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Contemporary home in Inwood. Open plan for today’s modern lifestyles. The dining room is just off the entry & opens to the spacious living room featuring a vaulted ceiling & fireplace. Stunning kitchen features granite counters/subway tile backsplash. Refrigerator included. Adjacent breakfast room w/corner windows for natural light. Spacious primary suite features an ensuite bath with a long vanity with new granite counter. Off the ensuite is a large walk-in closet. Two additional bedrooms share a hall bath. A bonus room is located off the dining room and is perfect as a gameroom, office or music room. This space was converted space of the original 2 car garage. Home still has a 1 car garage space. Covered patio overlooks the lush landscaped backyard. A separate storage building for additional storage in the back yard. Recent updates include fresh interior and exterior paint, new carpet in bedrooms, several new light fixtures and ceiling fan in living room. New Roof! Come tour today!' ,`Acres` = '0.1896' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 20 017*I5645955-002-020-007 INWOOD NORTH SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8260' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'NITSCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'KLEIN INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Inwood North' ,`TaxAmount` = '4085' ,`TaxRate` = '2.6055' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699802' WHERE `Matrix_Unique_ID` = '211314524' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T10:51:20.293' ,`MLSNumber` = '97426471' ,`ListAgentFullName` = 'Rosalinda Frias' ,`ListOfficeName` = 'Manor, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.779999' ,`Longitude` = '-95.356235' ,`PhotoCount` = '6' ,`PostalCode` = '77009' ,`RoomCount` = '7' ,`ListPrice` = '424900.00' ,`Status` = 'Active' ,`StreetName` = 'Cochran' ,`StreetNumber` = '2013' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1885' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful new construction in the highly-desired Northside featuring a private driveway and back yard. This three-story single-family homes has an excellent entertaining space on the second floor which includes a large covered balcony. There are vinyl plank flooring throughout (no carpet), stainless steel appliances, cathedral ceilings, and plenty of natural light. Home under construction to be completed December 2022.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Greyden Building' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 1 Noble Oaks' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '1541' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHERMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Noble Oaks' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699802' WHERE `Matrix_Unique_ID` = '211346057' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T11:58:01.213' ,`MLSNumber` = '69149354' ,`ListAgentFullName` = 'Monique Burks' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.714324' ,`Longitude` = '-95.666585' ,`PhotoCount` = '29' ,`PostalCode` = '77082' ,`RoomCount` = '3' ,`ListPrice` = '255000.00' ,`Status` = 'Active' ,`StreetName` = 'Vineyard' ,`StreetNumber` = '3903' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1699' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3/2/2 patio home. Great floor plan that has formal dining and breakfast areas, family room and living room. Kitchen has updated cabinets with pullouts and large pan doors. Refrigerator stays. Great fireplace in family room. Sunroom off of breakfast area. Two covered patios and another patio area in front of house. Nicely landscaped yard area. Convenient to Hwy 6 and Westpark Tollway. Room dimensions are approximate.' ,`Acres` = '0.124' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 23 BLK 14 WINGATE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'REES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'ALBRIGHT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wingate Sec 02' ,`TaxAmount` = '4179' ,`TaxRate` = '2.4927' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699802' WHERE `Matrix_Unique_ID` = '211346458' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T10:42:45.307' ,`MLSNumber` = '47823258' ,`ListAgentFullName` = 'Reginald Bernard' ,`ListOfficeName` = 'Waterway Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.844811' ,`Longitude` = '-94.714009' ,`PhotoCount` = '41' ,`PostalCode` = '77597' ,`RoomCount` = '7' ,`ListPrice` = '239000.00' ,`Status` = 'Active' ,`StreetName` = 'Old Wallisville' ,`StreetNumber` = '1706' ,`StreetSuffix` = 'Road' ,`City` = 'Wallisville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1848' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The potential of this property is endless! Home is located in the Trinity Bay Area, city of Wallisville. This is a one-story home situated on a half acre lot with 3 to 4 bedrooms, 2 bathrooms and a wrap around patio. Complete this property and make it your own or convert to a rental property! Don\'t miss your chance to own this property!' ,`Acres` = '0.518' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County East' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 EDWARD WILEY LOTS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '22564' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '4 - Anahuac' ,`SchoolElementary` = 'ANAHUAC ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANAHUAC HIGH SCHOOL' ,`SchoolMiddle` = 'ANAHUAC MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Edward Wiley Lts' ,`TaxAmount` = '4789' ,`TaxRate` = '2.6602' ,`WaterSewer` = 'Other Water/Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663699802' WHERE `Matrix_Unique_ID` = '211415597' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T10:01:42.810' ,`MLSNumber` = '55351036' ,`ListAgentFullName` = 'Jack Simmons' ,`ListOfficeName` = 'Allstar Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.274998' ,`Longitude` = '-95.769205' ,`PhotoCount` = '36' ,`PostalCode` = '77316' ,`RoomCount` = '3' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Shady Oaks' ,`StreetNumber` = '24903' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1216' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a 3 bedroom, 2 full bath Manufactured home located on 2.626 acres. Partially cleared. The property is located about 1 mile from the Aggie Frwy. This area is growing fast and this is a chance to own land in this area. The property is only a block off of FM 1486. Home on an Aerobic system the motor replaced in last year. Water supplied by Everett Square water.' ,`Acres` = '2.626' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S874200 - SHADY OAK ESTATES 01, BLOCK 2, LOT 1-B, 2, SERIAL' ,`LotDesciption` = 'Wooded' ,`LotSize` = '114389' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Shady Oak Estates 01' ,`TaxAmount` = '2098' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699802' WHERE `Matrix_Unique_ID` = '211428182' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T10:43:04.913' ,`MLSNumber` = '83222073' ,`ListAgentFullName` = 'Charles Wells' ,`ListOfficeName` = 'Nexthome Elite Advisors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.735478' ,`Longitude` = '-95.349788' ,`PhotoCount` = '10' ,`PostalCode` = '77004' ,`RoomCount` = '3' ,`ListPrice` = '249997.00' ,`Status` = 'Active' ,`StreetName` = 'Hadley' ,`StreetNumber` = '3417' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1272' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WILL NOT LAST LONG! \r\n\r\nThis newly renovated 3 bedroom with bonus room for 4th bedroom and 2 bathroom home is perfect for any family that wants to be minutes away from downtown!\r\n\r\nWith stainless steel appliances, a new roof, A/C, plumbing, electrical, and so much more this home has everything you need and more. \r\n\r\nThe location can\'t be beat either with easy access to the medical center, downtown Houston, and the University of Houston. This one won\'t last long so don\'t miss your chance!' ,`Acres` = '0.0918' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 16 BLK 5 PRAIRIE HOME' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Prairie Home' ,`TaxAmount` = '2965' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1946' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663699803' WHERE `Matrix_Unique_ID` = '211453745' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T11:09:23.120' ,`MLSNumber` = '65936106' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.655938' ,`Longitude` = '-95.117791' ,`PhotoCount` = '13' ,`PostalCode` = '77505' ,`RoomCount` = '15' ,`ListPrice` = '567173.00' ,`Status` = 'Active' ,`StreetName` = 'Fairfield' ,`StreetNumber` = '5530' ,`StreetSuffix` = 'Lane' ,`City` = 'Pasadena' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3005' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming two-story Louise home with 4 bedrooms, 3.5 baths and 2 car attached garage with storage. Convenient home office with French doors and open dining room tucked off foyer. Beautiful maple cabinets, quartz countertops and farmhouse sink in gourmet kitchen. Cozy tile fireplace with Craftsman mantel in great room. Huge walk-in closet in owner\'s suite. Dual vanity sinks, separate tub and shower in owner\'s bath. Versatile activity room located upstairs. Bedrooms 2 and 3 share a Jack and Jill bath. Covered patio in backyard, perfect for entertaining. Offered by: K. Hovnanian Houston Parkway Trails, LLC.' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'K. Hovnanian' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '16/2/4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'JP DABBS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRMONT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkway Trails' ,`TaxAmount` = '' ,`TaxRate` = '2.6198' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699803' WHERE `Matrix_Unique_ID` = '211466744' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T11:52:18.977' ,`MLSNumber` = '28552388' ,`ListAgentFullName` = 'Melissa Shechter' ,`ListOfficeName` = 'Ironwood Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.778833' ,`Longitude` = '-94.956843' ,`PhotoCount` = '49' ,`PostalCode` = '77521' ,`RoomCount` = '10' ,`ListPrice` = '2700000.00' ,`Status` = 'Active' ,`StreetName` = 'Hartrick' ,`StreetNumber` = '500' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2688' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SOOOO MANY FEATURES! 21.5 acres with home offering 4 bedrooms, 2 full bathrooms, and 1 half bathroom in main house. Beautiful wood floors, slate tile, granite countertops with custom wood cabinets, SS appliances, island kitchen, lots of windows, screened back porch, primary bath w/ soaking tub, walk-in closet, and double sinks. Third bay of attached garage has been converted to a library. Guest Apartment 630 sq ft with 3 bedrooms, 1 bath, kitchen, living all inside large shop that can fit numerous cars. Large Shop 88x120 has office space and side RV parking. Seller\'s recreation building 32x39 with full kitchen and restroom great for entertaining. It also offers a front and back porch overlooking pasture. Secondary shop 30x40 for tools, etc., Storage building 15x22. Pond with deck. Down the street from school. So MANY things that this home offers.' ,`Acres` = '21.5' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'PT TRS 10M & 10N (HOMESITE) ABST 709 J W SINGLETON' ,`LotDesciption` = 'Cleared' ,`LotSize` = '936540' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'J W Singleton' ,`TaxAmount` = '10553' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699803' WHERE `Matrix_Unique_ID` = '211495363' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T10:27:20.830' ,`MLSNumber` = '45569557' ,`ListAgentFullName` = 'Whitnee Mahon' ,`ListOfficeName` = 'The McKellar Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.728586' ,`Longitude` = '-95.931684' ,`PhotoCount` = '36' ,`PostalCode` = '77423' ,`RoomCount` = '6' ,`ListPrice` = '299999.00' ,`Status` = 'Active' ,`StreetName` = 'Timber Point' ,`StreetNumber` = '32510' ,`StreetSuffix` = 'Drive' ,`City` = 'Brookshire' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1660' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this beautifully updated and well maintained 3 bedroom 2 full bath Anglia build! This charming one story is perfectly situated on a cul-de-sac with no back neighbors and neighbors on one side only. Upon entering this home you will be greeted with bright freshly painted walls and an open floor concept with high ceilings. The kitchen has beautiful granite countertops and under cabinet lighting. The primary suite is situated away from secondary bedrooms and the home study could even serve as a fourth bedroom! Located in the Vanbrooke comm. offers amenities such as a resort style pool, splashpad, park, walking path and soccer field. This home is zoned to highly desired Fulshear area schools. Updates include: New HVAC, new paint, primary bathroom remodel, new tile, ceiling fans and light fixtures, decorative feature walls in the living room and primary bedroom, whole home gutters, and thermoplastic high temp loom in attic. Whole home monitoring and security system included!' ,`Acres` = '0.1118' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'VANBROOKE SEC 1, BLOCK 1, LOT 47' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '4871' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Vanbrooke Sec 1' ,`TaxAmount` = '7005' ,`TaxRate` = '3.2948' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699803' WHERE `Matrix_Unique_ID` = '211498350' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T10:02:22.090' ,`MLSNumber` = '52977868' ,`ListAgentFullName` = 'Scott Miller' ,`ListOfficeName` = 'RE/MAX Signature Galleria' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.128487' ,`Longitude` = '-95.277619' ,`PhotoCount` = '9' ,`PostalCode` = '77365' ,`RoomCount` = '4' ,`ListPrice` = '339900.00' ,`Status` = 'Active' ,`StreetName` = 'Heatherwood' ,`StreetNumber` = '22074' ,`StreetSuffix` = 'Drive' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1820' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '10\' ceilings in kitchen/Living, open concept. Spacious kitchen with 42\" upper cabinets with large island, granite tops. Bedrooms with huge walk-in closet. Samsung Stainless Steel appliance package including easy clean top range with electric oven, 3 rack dishwasher, and microwave. 1 year warranty on appliances from Samsung. Ask agent about preferred lender benefits.' ,`Acres` = '0.4397' ,`Area` = '40' ,`BuilderName` = 'Starter Homes of TX' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S962003 - WOOD HOLLOW 03, LOT 150' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '19152' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'SORTERS MILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wood Hollow 03' ,`TaxAmount` = '817' ,`TaxRate` = '2.1331' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699803' WHERE `Matrix_Unique_ID` = '211507016' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T11:09:21.340' ,`MLSNumber` = '68752461' ,`ListAgentFullName` = 'Dayna Simmons' ,`ListOfficeName` = 'Dayna Simmons Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.168395' ,`Longitude` = '-94.317066' ,`PhotoCount` = '6' ,`PostalCode` = '77659' ,`RoomCount` = '7' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Wood Manor Ln' ,`StreetNumber` = '170' ,`StreetSuffix` = '' ,`City` = 'Sour Lake' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1794' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Another fabulous IH Homes new construction nestled in the Pinewood neighborhood in the sought-after HJ-ISD. Wood-look tile flooring, quartz countertops in the kitchen and bathrooms, an open concept floor plan, and spacious rooms. The master bathroom features include a vanity, single sink, and shower/tub combo. Relax and unwind outdoors on the covered patio. This home is waiting for you to make it your own! Estimated completion is end of September 2022.' ,`Acres` = '0.286' ,`Area` = '49' ,`BuilderName` = 'IH Homes Inc' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 18 BLK 24 PINEWOOD #3 P# HJ25-24-18 I# 2021-114826 5/13/' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12458' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '163 - Hardin-Jefferson' ,`SchoolElementary` = 'SOUR LAKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARDIN-JEFFERSON HIGH SCHOOL' ,`SchoolMiddle` = 'HENDERSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Pinewood Sec 03' ,`TaxAmount` = '5000' ,`TaxRate` = '2.158' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699803' WHERE `Matrix_Unique_ID` = '211507726' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T10:12:54.433' ,`MLSNumber` = '45185038' ,`ListAgentFullName` = 'Andrew Lin' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.741535' ,`Longitude` = '-95.487417' ,`PhotoCount` = '28' ,`PostalCode` = '77057' ,`RoomCount` = '9' ,`ListPrice` = '899900.00' ,`Status` = 'Active' ,`StreetName` = 'Nantucket' ,`StreetNumber` = '2436' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3706' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this stunning modern home in the Galleria neighborhood. The thoughtful floor plan\r\nfeatures 4 bedrooms, 4.5 bathrooms, study, and so much more! Top of the line finishes include\r\nwood floors, quartzite countertops, and Thermador appliances. Situated on a quiet yet\r\nconvenient street, the unmatched location is just minutes from the Galleria shopping and\r\nentertainment with easy access to major highways I-10 and 610. Schedule a tour today!' ,`Acres` = '0.0621' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Galleria' ,`HeatSystem` = 'Central Gas,Heat Pump' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 WESTHAVEN ESTATES SEC 1 8TH PAR R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2704' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Westhaven Estates Sec 1' ,`TaxAmount` = '18515' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699803' WHERE `Matrix_Unique_ID` = '211508002' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T11:28:59.340' ,`MLSNumber` = '19998085' ,`ListAgentFullName` = 'Scott Laird' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.872033' ,`Longitude` = '-95.607147' ,`PhotoCount` = '36' ,`PostalCode` = '77041' ,`RoomCount` = '12' ,`ListPrice` = '699000.00' ,`Status` = 'Active' ,`StreetName` = 'Emmett' ,`StreetNumber` = '13010' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '2' ,`BedsTotal` = '9' ,`SqFtTotal` = '5203' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION, LOCATION, LOCATION -- located just minutes from FM 529 with easy access to US 290 and I-10. DUAL USE PROPERTY -- commercial/residential. Property is a single family property being used as office space but can be easily converted back to single family home. Over 5000+ sqft of space and offers 9 office spaces, full kitchen space, 1 full bath, and two half baths. Recently added 3-CAR CARPORT and offering 12 total parking spaces. Fenced backyard area, fireplace in main area, private well & septic, and LOW TAX RATE. Located less than 1 miles from intersection of FM 529 and Eldrige Parkway. Call for your private tour!! This space has endless possibilities!!!' ,`Acres` = '0.3809' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'E 158 FT OF LT 46 BLK 4 SATSUMA ESTATES SEC 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '16590' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HAIRGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Satsuma Estates' ,`TaxAmount` = '9239' ,`TaxRate` = '2.091' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699804' WHERE `Matrix_Unique_ID` = '211508430' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T10:52:04.097' ,`MLSNumber` = '85047041' ,`ListAgentFullName` = 'Toyia Chenevert' ,`ListOfficeName` = 'Re/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.034861' ,`Longitude` = '-94.882765' ,`PhotoCount` = '3' ,`PostalCode` = '77535' ,`RoomCount` = '4' ,`ListPrice` = '324000.00' ,`Status` = 'Active' ,`StreetName` = 'Pebble' ,`StreetNumber` = '438' ,`StreetSuffix` = 'Drive' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1600' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 3 bedroom 2 bath 1-story home is nestled in the Stone Creek subdivision. Enjoy cooking in the gourmet kitchen which features 42 inch job built cabinets, granite counters, tile back splash and tons of space for storage all open to a cozy living area adorned with lots of windows allowing tons of natural light into the home. The primary retreat is is tucked away for privacy equipped with a luxury bath that contains dual sinks, soaking tub, large shower and access to a huge walk-in closet. Every square foot was thoughtfully crafted to envelop you in comfort and functionality. Not to mention the covered patio and huge back yard perfect for hosting outdoor events or parties.' ,`Acres` = '0.2502' ,`Area` = '52' ,`BuilderName` = 'Merritt Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'STONE CREEK, SEC 4, BLOCK 1, LOT 20, ACRES .2502' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10899' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'KIMMIE M. BROWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'STONE CREEK' ,`TaxAmount` = '611' ,`TaxRate` = '2.4832' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663699804' WHERE `Matrix_Unique_ID` = '211509964' --> Updated record success