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-23T10:48:29.640' ,`MLSNumber` = '70517320' ,`ListAgentFullName` = 'Travis Edmunds' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.396189' ,`Longitude` = '-95.504494' ,`PhotoCount` = '41' ,`PostalCode` = '77318' ,`RoomCount` = '12' ,`ListPrice` = '634824.00' ,`Status` = 'Active' ,`StreetName` = 'Calmato Woods' ,`StreetNumber` = '338' ,`StreetSuffix` = 'Way' ,`City` = 'Willis' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3328' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin-Homes New Construction! Your NEW, low maintenance, energy-efficient certified home conveniently located in the newest Master-Planned Community of The Woodlands Hills! This showpiece, breathtaking and functional 1 story home w/ 3 car tandem garage has soaring Ceilings, 8ft doors, & large 7in Base Trim. The Texas-size open island kitchen features beautiful quartz countertops, stainless appliances, & quality Kentmoore cabinetry. The Family Room features a cathedral ceiling, tons of natural light, 36in gas log fireplace & adjacent Formal Dining. You\'ll love this plan & neighborhood!' ,`Acres` = '0.22' ,`Area` = '39' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'The Woodlands Hills 02, BLOCK 2, Lot 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9611' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '992' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`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` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'The Woodlands Hills' ,`TaxAmount` = '' ,`TaxRate` = '3.35' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702074' WHERE `Matrix_Unique_ID` = '200070201' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T11:29:23.853' ,`MLSNumber` = '93964066' ,`ListAgentFullName` = 'Robert Lopez' ,`ListOfficeName` = 'Legacy Texas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.204906' ,`Longitude` = '-95.263723' ,`PhotoCount` = '14' ,`PostalCode` = '77306' ,`RoomCount` = '5' ,`ListPrice` = '80000.00' ,`Status` = 'Active' ,`StreetName` = 'FM 1485' ,`StreetNumber` = '16807' ,`StreetSuffix` = 'Road' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1617' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This property sits on just under 3 acres. Property is being sold where is as is. Schedule your showing today.' ,`Acres` = '2.84' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'A0420 PREWETT BEASLEY, TRACT 94-A, ACRES 2.840' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '123710' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'MILAM ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Beasley Pruitt Surv Abs 420' ,`TaxAmount` = '2733' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Other Water/Sewer,Well' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663702074' WHERE `Matrix_Unique_ID` = '205493607' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T11:23:32.863' ,`MLSNumber` = '10717587' ,`ListAgentFullName` = 'Tracie Benton' ,`ListOfficeName` = 'Lux StyleDesignRealEstateGroup' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.536909' ,`Longitude` = '-95.734257' ,`PhotoCount` = '39' ,`PostalCode` = '77469' ,`RoomCount` = '14' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Round Lake' ,`StreetNumber` = '330' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosenberg' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3567' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this gorgeous one-story home that features an open concept design and soaring 14-foot ceilings! As you enter through the front door you are sure to be amazed by the stunning foyer and architectural design. Enjoy making family memories in the gourmet kitchen that is complete with an abundance of storage space and a large island that overlooks the family room. Just steps away from the family room is a spacious study that is the ideal place to work from home.\r\nThis attractive one-story plan has 4 bedrooms, 4 baths. Each bedroom has its own bathroom. Complete with a 3-car garage, you do not want to miss out on this home. Come visit today!' ,`Acres` = '0.2357' ,`Area` = '30' ,`BuilderName` = 'Drees Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SUMMER LAKES SEC 7, BLOCK 4, LOT 15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10268' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'ARREDONDO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Summer Lakes Sec 7' ,`TaxAmount` = '13204' ,`TaxRate` = '2.8448' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702074' WHERE `Matrix_Unique_ID` = '206541313' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T10:23:32.007' ,`MLSNumber` = '62661508' ,`ListAgentFullName` = 'Megan Stultz' ,`ListOfficeName` = 'Fairwater Westmont Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.318805' ,`Longitude` = '-95.786372' ,`PhotoCount` = '36' ,`PostalCode` = '77316' ,`RoomCount` = '15' ,`ListPrice` = '4100000.00' ,`Status` = 'Active' ,`StreetName` = 'Lily Bean' ,`StreetNumber` = '4529' ,`StreetSuffix` = 'Road' ,`City` = 'Montgomery' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '6638' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This five-bedroom, five-bathroom elegant home presents a spacious open-concept layout featuring soaring ceilings, marble floors, premium appliances and spectacular finishes. This private resort community, located in the premier Montgomery school district, is gated with security. Additional luxurious spaces include an expansive kitchen, breakfast nook, dining room, formal dining room, office/study, two media rooms and a family room that can be transformed to fit the homeowner’s lifestyle. The master features a gorgeous bathroom with his and her sinks, beautiful walk-in closet and luxurious finishes. Surrounded by stately pines and lush greenery, this home is complete with a full outdoor kitchen, covered porch and outdoor firepit to enjoy Bluejack’s natural beauty and views of the golf course. Located within close proximity of Blake Cottage, a resident-favorite amenity, homeowners can walk-in and enjoy fresh fruits, snacks, beverages, bars and all your favorite sweet treats!' ,`Acres` = '0.98' ,`Area` = '39' ,`BuilderName` = 'Bluejack Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Montgomery County Northwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S263701 - Bluejack National Phase 1B, BLOCK 1, Lot 2' ,`LotDesciption` = 'In Golf Course Community,On Golf Course,Subdivision Lot' ,`LotSize` = '42688' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven,Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Craftsman,Traditional' ,`Subdivision` = 'Bluejack National' ,`TaxAmount` = '7811' ,`TaxRate` = '3.075' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702074' WHERE `Matrix_Unique_ID` = '206767631' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T10:34:37.360' ,`MLSNumber` = '61509530' ,`ListAgentFullName` = 'Sharon Higgins' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.371621' ,`Longitude` = '-95.324044' ,`PhotoCount` = '45' ,`PostalCode` = '77303' ,`RoomCount` = '5' ,`ListPrice` = '420000.00' ,`Status` = 'Active' ,`StreetName` = 'Williams' ,`StreetNumber` = '8540' ,`StreetSuffix` = 'Road' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1956' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '***PRICE REDUCTION*** Wow! This great one story brick home has a pool and sits on one acre!! Home was built by Tilson with a nice split floor plan that includes 3 bedrooms (2 are masters), 2 bathrooms and a 2 car garage. The sellers are the original owners and had the home and pool built. The kitchen/dining area is open to the den which creates an open homey feel. Kitchen and Dining combo makes gathering for dinner easy. All electric home, roof replaced in 2015, carpets removed in 2017 and pool pump replaced this year. This one is ready for you to move in and start enjoying the pool! Located close enough to all the amenities of Conroe, but far enough out for a little more rural feel. It is approximately 4 miles to Conroe Regional Airport, 6 miles to Conroe, 18 miles to Lake Conroe and 9 miles to the Fairgrounds. Only about a half hour to The Woodlands! Please wear a mask when touring the property.' ,`Acres` = '1' ,`Area` = '19' ,`BuilderName` = 'Tilson' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0651 - SIMMONS J C, TRACT 5-A (0.577 AC), GROCEVILLE ESTATE' ,`LotDesciption` = 'Cleared' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Abstract Area 1' ,`TaxAmount` = '3480' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702074' WHERE `Matrix_Unique_ID` = '207055183' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T10:11:49.440' ,`MLSNumber` = '83437285' ,`ListAgentFullName` = 'Wendy Riffe' ,`ListOfficeName` = 'Coldwell Banker Southern Homes' ,`SellingAgentFullName` = 'Wendy Riffe' ,`SellingOfficeName` = 'Coldwell Banker Southern Homes' ,`Latitude` = '30.172245' ,`Longitude` = '-94.193165' ,`PhotoCount` = '6' ,`PostalCode` = '77713' ,`RoomCount` = '0' ,`ListPrice` = '319999.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Broussard' ,`StreetNumber` = '7465' ,`StreetSuffix` = 'Road' ,`City` = 'Beaumont' ,`BathsFull` = '0' ,`BathsHalf` = '0' ,`BedsTotal` = '0' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Flood Zone X - Get ready to pick paint color, flooring, granite, lighting fixtures, and appliances. This 3/2/3 family brick home boast superior craftsmanship & custom features, fabulous open floor plan w/fireplace. The home offers inviting tile in foyer, open concept living with tile flooring through-out, carpet in bedrooms, energy efficient double pane vinyl windows, trey ceilings with crown, gourmet kitchen w/ granite counters, custom cabinetry, walk-in pantry, energy efficient stainless gas appliances, custom designer interior paint colors,brilliant light fixtures, All Pictures shown are for illustration purpose only, builder\'s work. Actual plans will vary. covered patio, full gas conveniences; 1- year mechanical warranty, and 1- year structural warranty• Under-Mount Sinks andQuality Plumbing Fixtures • Energy Efficient Windows • Custom Cabinets Through-Out •Quality Light Fixtures & Ceiling Fans-Insulation; R 13-Walls; R 30-Ceilings •H VAC; 3.5 Ton.' ,`Acres` = '' ,`Area` = '51' ,`BuilderName` = 'Galaxy Builders' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BURNET PARK .170AC' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'GUESS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WEST BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'KING MIDDLE SCHOOL (BEAUMONT)' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Burnet Park' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663702075' WHERE `Matrix_Unique_ID` = '207106162' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T10:49:21.993' ,`MLSNumber` = '7509133' ,`ListAgentFullName` = 'Elizabeth Lopez' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.201847' ,`Longitude` = '-94.945391' ,`PhotoCount` = '13' ,`PostalCode` = '77554' ,`RoomCount` = '4' ,`ListPrice` = '389000.00' ,`Status` = 'Active' ,`StreetName` = 'Oleander' ,`StreetNumber` = '4015' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '600' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This must see beachside charming coastal gem was renovated in 2017. It is a perfect weekend getaway or vacation rental property. This 2 bedroom 2 bath has newly painted expansive wrap around porch to enjoy the views and coastal breeze! Features include an open kitchen, breakfast bar, and new furnishings. Downstairs has a concrete slab that allows for an additional entertainment area and parking. Enjoy the short walk or golf cart ride to the beach. Comes fully furnished with coastal decor. Fully stocked kitchen and linens all included. This one is turnkey and move-in ready. In addition, the property has over $15,000 short-term rental gross income in June and July of 2022 alone!' ,`Acres` = '0.1148' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT A WHITING ESTATES RPLT OF LT 6' ,`LotDesciption` = 'Other' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Palm Beach' ,`TaxAmount` = '2720' ,`TaxRate` = '2.2215' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702075' WHERE `Matrix_Unique_ID` = '207346447' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T11:15:16.923' ,`MLSNumber` = '6637340' ,`ListAgentFullName` = 'Aaron Mancilla' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.794912' ,`Longitude` = '-95.363436' ,`PhotoCount` = '11' ,`PostalCode` = '77009' ,`RoomCount` = '6' ,`ListPrice` = '260000.00' ,`Status` = 'Active' ,`StreetName` = 'Hain' ,`StreetNumber` = '3801/3803' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '975' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investment opportunity, Duplex property update from the inside and fully leased. Property was updated in 2021 with plumbing, electrical, HVAC, and new roof they are fully leased. Duplex has a 1 bedroom and 1 Bath on each side, it can also be turned into an AIR BNB there is no restrictions.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Tenant Occupied' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Mancilla Subdivision, Block 1, Lot 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '4394' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOOSCAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mancilla' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702075' WHERE `Matrix_Unique_ID` = '208124207' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T11:16:02.397' ,`MLSNumber` = '86865846' ,`ListAgentFullName` = 'Aaron Mancilla' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.794602' ,`Longitude` = '-95.363577' ,`PhotoCount` = '15' ,`PostalCode` = '77009' ,`RoomCount` = '7' ,`ListPrice` = '219000.00' ,`Status` = 'Active' ,`StreetName` = 'Kennon' ,`StreetNumber` = '3806' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1047' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investor ready home, ready for your new or first-time investment home, bring all offers. The home is currently located 10 miles away from downtown, 3 miles from the heights and close to 45, Hardy toll, 610 North loop. Metro rail is just a few blocks away. Home is a 3-bedroom 1 bath, home and it also comes with a small apartment in the back perfect for extra rents or Airbnb. Home is currently leased on a month to month.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Owner/Agent' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Space Heater' ,`HOAMandatory` = '0' ,`Legal` = 'Mancilla subdivision block 1 lot 2' ,`LotDesciption` = 'Other' ,`LotSize` = '4099' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOOSCAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mancilla' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1948' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702075' WHERE `Matrix_Unique_ID` = '208125454' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T11:35:23.937' ,`MLSNumber` = '62651193' ,`ListAgentFullName` = 'Nicole Espinosa' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.495597' ,`Longitude` = '-95.355513' ,`PhotoCount` = '11' ,`PostalCode` = '77578' ,`RoomCount` = '7' ,`ListPrice` = '224900.00' ,`Status` = 'Active' ,`StreetName` = 'Del Bello' ,`StreetNumber` = '6919' ,`StreetSuffix` = 'Road' ,`City` = 'Manvel' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1656' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Country living with a dash of city feel. This property is located in an established neighborhood. 3B 2B, large kitchen with lots of cabinet space and spacious pantry, easy access to living room and remaining rooms. Landscaped, large backyard great for entertaining! AS-IS, WHERE-IS, BUYER TO PURCHASE SURVEY, SELLER TO MAKE NO REPAIRS.' ,`Acres` = '1.1' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Short Sale' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'A0319 H N LITTLE, TRACT 1-1A3, ACRES 60.00' ,`LotDesciption` = 'Cleared' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'E C MASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'MANVEL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'H N Little' ,`TaxAmount` = '106' ,`TaxRate` = '2.7874' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702075' WHERE `Matrix_Unique_ID` = '208832415' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T11:25:52.260' ,`MLSNumber` = '23490365' ,`ListAgentFullName` = 'Jessica Blauvelt' ,`ListOfficeName` = 'Keller Williams Hou Preferred' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.481000' ,`Longitude` = '-94.929028' ,`PhotoCount` = '41' ,`PostalCode` = '77539' ,`RoomCount` = '3' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue K' ,`StreetNumber` = '1402' ,`StreetSuffix` = '' ,`City` = 'San Leon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2117' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Reverse living at its finest with water views! Master suite with fully updated bathroom on ground floor along with additional bedrooms, bath and laundry. Upstairs you\'ll enjoy an open floor plan with light and bright features. Fresh paint, updated kitchen, new floors throughout. Exposed beams and vaulted ceilings. New siding, new AC/furnace, roof from 2019, new blinds/screens...too many updates to list! Tons of special one-of-a-kind features that you need to see in person. Oversized lot with large \"man cave\" shed for supplies and hanging out. Oversized two car attached garage with storage above. In the heart of San Leon, this home is a dream and just steps away from the water.' ,`Acres` = '0.1538' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 10 A EDWARDS LOTS 47-48 BLK 184 SAN LEON & IMPS' ,`LotDesciption` = 'Cleared,Corner,Water View' ,`LotSize` = '6700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'SAN LEON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'San Leon' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702075' WHERE `Matrix_Unique_ID` = '208985154' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T10:15:35.577' ,`MLSNumber` = '16596709' ,`ListAgentFullName` = 'Emily Dieckmann' ,`ListOfficeName` = 'Keller Williams Realty C. P.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.427760' ,`Longitude` = '-98.001462' ,`PhotoCount` = '20' ,`PostalCode` = '78645' ,`RoomCount` = '3' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Highland Lake' ,`StreetNumber` = '20542' ,`StreetSuffix` = 'Drive' ,`City` = 'Lago Vista' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1920' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located on the 18th hole of the Highland lakes golf course this charming home has 1,920 square feet of well planned living space including 3 huge bedrooms and 2 full bathrooms. The main living has vaulted ceilings and an exposed beam along with full wood paneling and built in bookcases/ desk. Large owners retreat has en suite bath with adjoining cedar closet. The secondary bedrooms offer ample space for your guests and extra storage. Multiple large oak trees in the back yard provide tons of privacy, plenty of shade, and beautiful views of the golf course. Also enjoy the hill country lifestyle from the fully screened-in back patio. This home is also located just a few minutes walk or golf cart ride from one of Lago Vista\'s amazing restaurants: The Grille at Highland Lakes. Lago Vista has an exemplary school district, Lake Travis waterfront parks, marina, fitness center, fishing well, shopping, restaurants, clubhouse, community pool and so much more! Lago Vista is lake life at it’s best.' ,`Acres` = '0.235' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 10089 HIGHLAND LAKE ESTATES SEC 10' ,`LotDesciption` = 'On Golf Course' ,`LotSize` = '10237' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '114 - Lago Vista' ,`SchoolElementary` = 'LAGO VISTA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAGO VISTA HIGH SCHOOL' ,`SchoolMiddle` = 'LAGO VISTA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Highland Lake Estates Sec 10' ,`TaxAmount` = '6042' ,`TaxRate` = '2.4782' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702075' WHERE `Matrix_Unique_ID` = '209258407' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T11:50:31.267' ,`MLSNumber` = '10370970' ,`ListAgentFullName` = 'Destiny Winters' ,`ListOfficeName` = 'Keller Williams Elite' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.040321' ,`Longitude` = '-94.738561' ,`PhotoCount` = '38' ,`PostalCode` = '77575' ,`RoomCount` = '7' ,`ListPrice` = '895000.00' ,`Status` = 'Active' ,`StreetName` = 'Teme' ,`StreetNumber` = '1133' ,`StreetSuffix` = 'Lane' ,`City` = 'Ames' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '4523' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Hidden gem tucked away on a beautifully maintained lot. 1133 Teme is perfect for a large or even a multi-generational. Boasting of 5bedrooms, 3 full baths and 2 half baths and a ton of amenities. This home has well-appointed bedroom sizes and custom details throughout. The kitchen has full wood custom cabinetry, granite counter tops and opens to living and dining room. Storage space can be found throughout with the walk-in pantry and walk-in closets in every bedroom. The attic can be walked is full length and offers a ton of storage or possibilities to be finished. The home was constructed with 2x6 frame instead of the standard 2x4 and is secured with hurricane ties. The galvanized metal roof gives piece of mind during the southeast Texas hurricane season. Outdoors, you will find the pond is stocked with bass, several beautiful places to sit and enjoy company and a shop for all your toys!' ,`Acres` = '0.7' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Liberty' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'O\'BRIEN, SEC 1, LOT 3 4, TRACT 24, ACRES .7' ,`LotDesciption` = 'Cleared,Other' ,`LotSize` = '30492' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '73 - Liberty' ,`SchoolElementary` = 'LIBERTY ELEMENTARY SCHOOL (LIBERTY)' ,`SchoolHigh` = 'LIBERTY HIGH SCHOOL (LIBERTY)' ,`SchoolMiddle` = 'LIBERTY MIDDLE SCHOOL (LIBERTY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman,Traditional' ,`Subdivision` = 'Obrien, Sec 1' ,`TaxAmount` = '11519' ,`TaxRate` = '2.5796' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702075' WHERE `Matrix_Unique_ID` = '209405688' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T11:25:48.533' ,`MLSNumber` = '12248869' ,`ListAgentFullName` = 'Fransiska Rindorindo' ,`ListOfficeName` = 'RE/MAX Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.886446' ,`Longitude` = '-95.454052' ,`PhotoCount` = '30' ,`PostalCode` = '77088' ,`RoomCount` = '5' ,`ListPrice` = '299999.00' ,`Status` = 'Active' ,`StreetName` = 'Whitehead' ,`StreetNumber` = '10017' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1894' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You\'ll love the plenty of natural lightings in this new construction home. All bedrooms are upstairs. House features open floor plan with 10 ft high downstairs, 9 ft high ceiling upstairs. Within 15 miles from IAH airport and Downtown. Check out the interactive 3D VIRTUAL TOUR! Call today to schedule your showing!' ,`Acres` = '0.1263' ,`Area` = '11' ,`BuilderName` = 'MendozaHomesofTexas' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 39 BLK B GARDEN CITY PARK SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'NITSCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'KLEIN INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Garden City Park Sec 01' ,`TaxAmount` = '699' ,`TaxRate` = '2.6111' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702076' WHERE `Matrix_Unique_ID` = '209784749' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T11:25:19.987' ,`MLSNumber` = '5730912' ,`ListAgentFullName` = 'Lisa Hudgens' ,`ListOfficeName` = 'RE/MAX Northwest, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.948045' ,`Longitude` = '-95.599268' ,`PhotoCount` = '44' ,`PostalCode` = '77065' ,`RoomCount` = '12' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Cassia' ,`StreetNumber` = '11811' ,`StreetSuffix` = 'Circle' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You won\'t want to miss this large 5-bedroom 3.5 bath home on an oversized lot with a lush, landscaped front yard & backyard oasis complete with pool. The home features a kitchen remodel, whole house generator, roof updated 2013, updated windows & two tankless water heaters. There are 2 primary bedrooms & 3 secondary bedrooms. On the main floor of the home, you will find 1 oversized primary bedroom with En-suite bath, family room, office, dining room, breakfast room and kitchen. The family room features built in bookshelves, fireplace and plush carpet. The dining room features wood floors, ceiling fan and is easily accessible to the primary bedroom, kitchen & family room. The second floor of the home you will find the 2nd primary bedroom with En-suite bath & the 3 additional bedrooms with another full bath. The backyard is a private oasis with landscaped flower beds, large covered back porch, deck area & pool. There are two storage sheds for workshop and pool house.' ,`Acres` = '0.4408' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 17 BEINHORN TERRACE' ,`LotDesciption` = 'Cul-De-Sac,Wooded' ,`LotSize` = '19200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'ADAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'ARNOLD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Beinhorn Terrace' ,`TaxAmount` = '5445' ,`TaxRate` = '2.091' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702076' WHERE `Matrix_Unique_ID` = '209929229' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T11:16:09.867' ,`MLSNumber` = '68663304' ,`ListAgentFullName` = 'Stephanie Callahan' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.199451' ,`Longitude` = '-95.524871' ,`PhotoCount` = '50' ,`PostalCode` = '77381' ,`RoomCount` = '6' ,`ListPrice` = '1580000.00' ,`Status` = 'Active' ,`StreetName` = 'Silvershire' ,`StreetNumber` = '299' ,`StreetSuffix` = 'Circle' ,`City` = 'The Woodlands' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '4855' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This well-appointed CUSTOM home w/breathtaking water & golf course views sits on a PRIME LOT that overlooks the #7 green of the PALMER GOLF COURSE & water feature pond. Nestled in a cul-de-sac of Cochran\'s Crossing w/ a sparkling pool & spa. Walking distance to top ranked Galatas Elementary. Kitchen is a chef\'s dream w/ SubZero refrigerator & matching separate SubZero freezer, cabinets w/ built in pullout step up platforms! Stereo speakers throughout inclusive of the porches, garage/workshop. Central vacuum system w/ electric dustpan & an oversized utility room w/ built in electric dog door & an associated separate fenced dog run outside. Electric remote-control shades in family & breakfast rooms w/ large 4 1/2\" Texas shutters on front elevation windows & most rear. 5 car garage w/ walk-up stairs to attic. Circle drive w lots of parking! Builder thought of it all! Central Woodlands location!(Home is priced according to heated/cooled sq footage not represented in the listing sq footage)' ,`Acres` = '0.3322' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL COCHRANS CR 43, BLOCK 2, LOT 24' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,On Golf Course,Water View,Waterfront' ,`LotSize` = '14470' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '5' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GALATAS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Cochrans Cr 43' ,`TaxAmount` = '18680' ,`TaxRate` = '2.1269' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702076' WHERE `Matrix_Unique_ID` = '210050266' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T10:18:21.467' ,`MLSNumber` = '62672875' ,`ListAgentFullName` = 'Ling Gao' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.825612' ,`Longitude` = '-95.761933' ,`PhotoCount` = '32' ,`PostalCode` = '77449' ,`RoomCount` = '4' ,`ListPrice` = '395000.00' ,`Status` = 'Active' ,`StreetName` = 'Auburn Valley' ,`StreetNumber` = '22522' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2730' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful & Bright!!! Corner Lot Home with 4 bedrooms located in CyFair ISD. This home is open with high ceilings, lots of windows allowing natural lighting into all areas of the home. Fresh paint cover whole house and garage , Replace new carpet. Conveniently located within 10 miles of Katy Mills Mall and lots of shopping and restaurants in the area. Easy Access to I 10 and Hwy 99.' ,`Acres` = '0.1219' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 3 WATERSTONE SEC 9 AMEND' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '5312' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MORTON RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MORTON RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'MCDONALD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Waterstone' ,`TaxAmount` = '8127' ,`TaxRate` = '3.1233' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702076' WHERE `Matrix_Unique_ID` = '210235685' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T10:03:15.340' ,`MLSNumber` = '15140215' ,`ListAgentFullName` = 'Blake Vincent' ,`ListOfficeName` = 'DUX Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.731079' ,`Longitude` = '-95.456122' ,`PhotoCount` = '41' ,`PostalCode` = '77027' ,`RoomCount` = '14' ,`ListPrice` = '799900.00' ,`Status` = 'Active' ,`StreetName` = 'MERWIN' ,`StreetNumber` = '4708' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3060' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home, zoned to St. George Place elementary, features a large backyard with close to 1,050sf of green space with plenty of room for a pool! Mazzarino Construction & Development\'s new division is here in Houston\'s well established inner loop neighborhoods. MAZZTAO Homes features a new, stylish, well priced, quality home, but with an entirely different price point. You no longer have to compromise your location to buy somewhere or something else, that you just don’t really want. This home features an extremely versatile and functional floor plan. The floor plan has 4 bedrooms, 3.5 bath rooms, first floor living, a private driveway, flex room, game room, and approx. 1,050 sf backyard! Retail, restaurants, gym, groceries, you name it, it\'s walking distance away. Major freeways, downtown, medical center, parks, theater, art & museum districts are all within minutes. Contact us today to learn more about customization options available during construction only!' ,`Acres` = '' ,`Area` = '16' ,`BuilderName` = 'MAZZTAO HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Royden Oaks/Afton Oaks' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 MERWIN GROVE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3540' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SCHOOL AT ST GEORGE PLACE' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'MERWIN GROVE' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702076' WHERE `Matrix_Unique_ID` = '210382398' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T10:33:47.220' ,`MLSNumber` = '39246160' ,`ListAgentFullName` = 'Connie Strban' ,`ListOfficeName` = 'Crockett Springs Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.303782' ,`Longitude` = '-95.465966' ,`PhotoCount` = '18' ,`PostalCode` = '75835' ,`RoomCount` = '3' ,`ListPrice` = '122500.00' ,`Status` = 'Active' ,`StreetName` = 'Sowescor' ,`StreetNumber` = '111' ,`StreetSuffix` = 'Street' ,`City` = 'Crockett' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1225' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cute 3 bedroom, 2 bath brick home just inside the loop and close to schools! Spacious galley style kitchen, split floorplan, tile and laminate flooring throughout. Has an attached carport with storage room recently added and a huge fenced back yard with a new deck off the back of the home. All appliances convey! Give us a call today!' ,`Acres` = '0.202' ,`Area` = '41' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crockett Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'CROCKETT HTS LOT A 7' ,`LotDesciption` = 'Cleared' ,`LotSize` = '8799' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '57 - Crockett' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (CROCKETT)' ,`SchoolHigh` = 'CROCKETT HIGH SCHOOL (CROCKETT)' ,`SchoolMiddle` = 'CROCKETT JUNIOR HIGH SCHOOL (CROCKETT)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Crockett Heights Sub' ,`TaxAmount` = '1261' ,`TaxRate` = '2.3627' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702076' WHERE `Matrix_Unique_ID` = '210716466' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T10:55:20.673' ,`MLSNumber` = '86929025' ,`ListAgentFullName` = 'Gary Bisha' ,`ListOfficeName` = 'My Castle Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.978917' ,`Longitude` = '-95.156557' ,`PhotoCount` = '42' ,`PostalCode` = '77044' ,`RoomCount` = '9' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Bosphorus' ,`StreetNumber` = '7810' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3053' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful like new DR Horton home is located in a culdesac! This home has everything, including a spacious study, stainless steel appliances, new dishwasher, double oven, large granite breakfast bar, large dining room, hardwood floors throughout the living space. This home is unique in the fact that is features 2 bedrooms down and 2 bedrooms up. The covered back patio and covered front porch offer plenty of outdoor space to keep you out of the sun and in the shade!' ,`Acres` = '0.1815' ,`Area` = '1' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 3 BRIDGES ON LAKE HOUSTON SEC 1 AMEND' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7906' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'LAKESHORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridges on Lake Houston' ,`TaxAmount` = '11589' ,`TaxRate` = '3.863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702076' WHERE `Matrix_Unique_ID` = '210961979' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T11:32:55.880' ,`MLSNumber` = '29421598' ,`ListAgentFullName` = 'John Johnson' ,`ListOfficeName` = 'Lifestyles Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.056125' ,`Longitude` = '-95.564004' ,`PhotoCount` = '31' ,`PostalCode` = '77422' ,`RoomCount` = '2' ,`ListPrice` = '139900.00' ,`Status` = 'Active' ,`StreetName` = 'Camp' ,`StreetNumber` = '402' ,`StreetSuffix` = 'Street' ,`City` = 'Brazoria' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '918' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this charming 2 bedroom and 1 bathroom home. It has be remodeled from top to bottom! The kitchen boasts granite countertops and a gas range! The maintenance free wood like vinal plank was installed in 2020 along with a new HVAC system and roof! Recently appraised for $159,000!!' ,`Acres` = '0.1414' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'MCGREAL (BRAZORIA) BLK 4 LOT 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6160' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mcgreal Brazoria' ,`TaxAmount` = '1181' ,`TaxRate` = '2.3372' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702077' WHERE `Matrix_Unique_ID` = '211044468' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T11:09:06.263' ,`MLSNumber` = '48223403' ,`ListAgentFullName` = 'Khrissondra Pope' ,`ListOfficeName` = 'Cedar Stone Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.397820' ,`Longitude` = '-94.925824' ,`PhotoCount` = '6' ,`PostalCode` = '77590' ,`RoomCount` = '6' ,`ListPrice` = '189000.00' ,`Status` = 'Active' ,`StreetName` = '14th Ave N' ,`StreetNumber` = '2113' ,`StreetSuffix` = '' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1758' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This house has so much potential sitting on two lots with option to purchase adjoining lot. This is an AS IS property owner will not make any repairs. Close to elementary, middle school, high school and businesses. Don\'t miss out! Schedule your showing today!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 205 J B WELLS SUR LOTS 5 & 6 BLK 5 KOHFELDT HEIGHTS ADD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'GUAJARDO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TEXAS CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BLOCKER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'KOHFELDT HEIGHTS A205' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702077' WHERE `Matrix_Unique_ID` = '211060855' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T10:39:59.910' ,`MLSNumber` = '28728725' ,`ListAgentFullName` = 'Brian Schweiker' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.153389' ,`Longitude` = '-95.466914' ,`PhotoCount` = '5' ,`PostalCode` = '77380' ,`RoomCount` = '14' ,`ListPrice` = '2400000.00' ,`Status` = 'Active' ,`StreetName` = 'Doe Run' ,`StreetNumber` = '16' ,`StreetSuffix` = 'Drive' ,`City` = 'The Woodlands' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '6465' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rare opportunity for new construction in Grogans Mill! This fantastic home is to be built on over a 1/3 of an acre in the established neighborhood of Doe Run by sought after Cornerstone Construction. Thoughtfully designed floor plan with 6,465 square feet of total living space including a first floor apartment for guest quarters or elderly parents with full kitchen, living room and private bedroom & bath. The main house will be perfect for entertaining with a spacious family room open to a gourmet kitchen with oversized island. The plans also include a home office/study, 4 bedrooms, 4 full and two half baths and a 3 car attached garage. Upstairs you will find the 3 secondary bedrooms each with en-suite baths & walk-in closets plus a Texas basement, large game room and a media room. The Grogans Mill location is walking distance to country club, golf, tennis, shops, store, dining and entertainment. Floor plans attached for review.' ,`Acres` = '0.3825' ,`Area` = '15' ,`BuilderName` = 'Cornerstone' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL GROGANS ML 16, BLOCK 2, LOT 4' ,`LotDesciption` = 'In Golf Course Community' ,`LotSize` = '16661' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'LAMAR ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Wdlnds Village Grogans Mill' ,`TaxAmount` = '10363' ,`TaxRate` = '2.0079' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702077' WHERE `Matrix_Unique_ID` = '211112562' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T10:35:44.047' ,`MLSNumber` = '37857284' ,`ListAgentFullName` = 'Cathy Johnson' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.343728' ,`Longitude` = '-95.441996' ,`PhotoCount` = '20' ,`PostalCode` = '77303' ,`RoomCount` = '7' ,`ListPrice` = '309900.00' ,`Status` = 'Active' ,`StreetName` = 'Arbor' ,`StreetNumber` = '984' ,`StreetSuffix` = 'Glen' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1626' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming Stone/Brick Home with Country Porch. Enjoy an open floor plan everyone is looking for with high ceilings and fireplace as the living room focal point. Entertain with a fabulous kitchen that has granite counters, maple cabinets, stainless steel appliances and a great pantry. Retreat to your primary bedroom and bath after a long day to relax. The bath has a huge shower, separate soaker tub, double vanity sinks and over-sided closet that we all dream of. The back yard is perfect for outdoor outings with privacy fencing surrounding all sides. Arbor Place subdivision is close to all city amenities yet feels as though you have retreated. The Lions Community Park is right inside Arbor Place and convenient for all residence. Room sizes are approximate so please verify measurements.' ,`Acres` = '0.1826' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S215802 - ARBOR PLACE 02, BLOCK 1, LOT 21' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7956' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'ANDERSON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Arbor Place 02' ,`TaxAmount` = '4597' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702077' WHERE `Matrix_Unique_ID` = '211128866' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T10:41:24.397' ,`MLSNumber` = '81530628' ,`ListAgentFullName` = 'Jane NgaDung Nguyen' ,`ListOfficeName` = 'Alpha, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.429905' ,`Longitude` = '-94.674328' ,`PhotoCount` = '50' ,`PostalCode` = '77650' ,`RoomCount` = '7' ,`ListPrice` = '1648000.00' ,`Status` = 'Active' ,`StreetName` = 'Villa' ,`StreetNumber` = '680' ,`StreetSuffix` = 'Drive' ,`City` = 'Crystal Beach' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '4226' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous waterfront estate overlooking the Gulf of Mexico sits on an acre+ & offers 166+ of beach frontage! True oasis is nestled in the gated golf community of Rancho Carribe on Galveston Counties Crystal Beach. With absolutely no obstructed views, this incredible property is ideal for year round entertaining. Features like Control4 Home Automation System; professionally decorated & fully furnished; all bedrooms with en-suite baths; high-end Stainless Steel appliances; all around speaker system, gas fireplace. 2nd floor balcony game room/wet bar, media room with theater seating to enjoy 120\" projection screen. Outdoor stadium lights create an ideal setting for watching the waves roll in. Wrap around deck offers endless views & enjoyment; 9 hole Golf Course; Automatic roll shutters; high impact windows; alarm system & more!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 203 VAN NORSTRAND SUR LOT 16 & E 33.33 FT OF LOT 15 RAN' ,`LotDesciption` = 'In Golf Course Community,Water View,Waterfront' ,`LotSize` = '41817' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1083' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Leave Business Card' ,`SqFtSource` = 'Seller' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Rancho Carribe Sec 1 & 2' ,`TaxAmount` = '12944' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702077' WHERE `Matrix_Unique_ID` = '211183294' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T10:08:30.540' ,`MLSNumber` = '53643579' ,`ListAgentFullName` = 'Claudia Wright' ,`ListOfficeName` = 'R & W Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.571754' ,`Longitude` = '-95.758516' ,`PhotoCount` = '50' ,`PostalCode` = '77469' ,`RoomCount` = '14' ,`ListPrice` = '675000.00' ,`Status` = 'Active' ,`StreetName` = 'Foster Dr' ,`StreetNumber` = '606' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '5738' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful, Custom, Colonial, one story on one quietest streets. Truly a jewel of Richmond, never been on the market, original owners. Large Oak trees in front with circular drive. Perfect for entertaining with large spacious rooms, being approx. 5,138 sf., 4 bedrooms, 4.5 baths, gameroom and guest suite with kitchen. Grand Entry flowing into large formals, vaulted ceiling in family room and Game room. Large exercise room and many built-ins and storage thru out the house. Amazing view from family room, game room and guest suite of the pool. Perfect pool area and patio for entertaining outside. Two car garage and 2 car carport. Buyer must verify exact room sizes and square footage. Chandeliers reserved. \r\nA must see!! Being sold \"AS Is\" needs some updates. Endless possibilities!!!' ,`Acres` = '0.5464' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'BICKHAM HEIGHTS, LOT 16 - 17' ,`LotDesciption` = 'Cleared' ,`LotSize` = '22567' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LONG ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Colonial' ,`Subdivision` = 'Bickham Heights' ,`TaxAmount` = '8023' ,`TaxRate` = '2.3748' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663702077' WHERE `Matrix_Unique_ID` = '211209840' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T10:21:12.233' ,`MLSNumber` = '66697149' ,`ListAgentFullName` = 'Brittani Davis' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.084542' ,`Longitude` = '-95.993105' ,`PhotoCount` = '20' ,`PostalCode` = '77445' ,`RoomCount` = '4' ,`ListPrice` = '154990.00' ,`Status` = 'Active' ,`StreetName` = 'Pine' ,`StreetNumber` = '300' ,`StreetSuffix` = 'Street' ,`City` = 'Prairie View' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '945' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this cozy 3 bedroom home located in the historic Alta Vista neighbordhood. Just a short walk to the esteemed Prairie View A&M University, and located near the student shuttle, this charmer is a great place for students looking to ditch the dorm. (Great income property for INVESTORS!) This home was recently renovated with luxury vinyl tile throughout the enite home, complete replacement of HVAC duct work, improved plumbing. The kitchen has upgraded granite countertops, and the bathroom has an upgraded vanity. Some improvements are still needed, home is being sold as it. Age of the home is unknown and room sizes are approximate, please verify. Schedule a visit today!' ,`Acres` = '0.1791' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Waller' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S352000 ALTA VISTA BLK 3 LOT 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7802' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'H T JONES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Alta Vista' ,`TaxAmount` = '1966' ,`TaxRate` = '2.7548' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '0' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663702077' WHERE `Matrix_Unique_ID` = '211389166' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T11:11:15.287' ,`MLSNumber` = '10425518' ,`ListAgentFullName` = 'David Cole' ,`ListOfficeName` = 'First Class, Realtors®' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.799925' ,`Longitude` = '-95.413414' ,`PhotoCount` = '32' ,`PostalCode` = '77008' ,`RoomCount` = '13' ,`ListPrice` = '1300000.00' ,`Status` = 'Active' ,`StreetName` = '16th' ,`StreetNumber` = '825' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Very light and bright with a open concept. This Newly Built property has all the comforts you can imagine. Let\'s start with the beautiful stucco exterior that makes you want to come inside to see the perfect floorplan. The home even has a elevator that takes you to the 3rd floor and you can walk back down the wood stairs with rod iron stair rails. Invite your friends to come over and watch a movie in the theater room and after you can sit outside on the large balcony and enjoy the views of Downtown Houston. The Primary bedroom and bath is a must see also with a double sided fireplace. 2 utilities rooms and a wine room and much more. This is the property that you\'ve been waiting to buy. Motivated seller says bring offers. This is a must see property and it will go fast.' ,`Acres` = '0.1613' ,`Area` = '9' ,`BuilderName` = 'HEARTSTONE HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 31 BLK 126 TR L (ABANDONED ALLEYWAY) HOUSTON HEIGHT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Split Level' ,`Subdivision` = 'Houston Heights' ,`TaxAmount` = '38390' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702078' WHERE `Matrix_Unique_ID` = '211477323' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T10:10:03.657' ,`MLSNumber` = '77204277' ,`ListAgentFullName` = 'Wendy Riffe' ,`ListOfficeName` = 'Coldwell Banker Southern Homes' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '30.053953' ,`Longitude` = '-94.198643' ,`PhotoCount` = '26' ,`PostalCode` = '77707' ,`RoomCount` = '3' ,`ListPrice` = '163000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Mockingbird' ,`StreetNumber` = '9130' ,`StreetSuffix` = 'Lane' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1284' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Move-In Ready! Well maintained 3/2/2 family home. Brick and vinyl siding exterior, inviting front porch & foyer, fresh paint, waterproof luxury vinyl plank flooring throughout, a cozy wood-burning fireplace, spacious living room, and breakfast area, the kitchen is updated with butcher block countertops, high-end appliances, farmhouse sink, custom cabinets, inside laundry room, lots of storage & closet space, huge master bedroom with an updated master bathroom that features touch screen mirror, new sink & countertop, white tile shower surround with niche & bench. Covered back patio with storage shed, wood privacy fencing & landscaping.\r\nADDITIONAL PICTURES' ,`Acres` = '0.1515' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SOMERSET VILLAGE SEC II LT 23 BLK 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'DISHMAN ELEMENTARY SCHOOL (BEAUMONT)' ,`SchoolHigh` = 'WEST BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'VINCENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Somerset Village' ,`TaxAmount` = '3223' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702078' WHERE `Matrix_Unique_ID` = '211479101' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T11:37:18.517' ,`MLSNumber` = '54735395' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.399528' ,`Longitude` = '-95.548656' ,`PhotoCount` = '7' ,`PostalCode` = '77318' ,`RoomCount` = '10' ,`ListPrice` = '807850.00' ,`Status` = 'Active' ,`StreetName` = 'Lake Mist' ,`StreetNumber` = '11041' ,`StreetSuffix` = 'Lane' ,`City` = 'Willis' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2850' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located on Lake Conroe, this stunning 4 bed, 3.5 bath 2-story home is sure to provide the most exquisite water views! Boasting 2,850 square feet of living space, this home features soaring high ceilings, elegant wood finishes, an oversized gourmet kitchen, a home office + game room upstairs, and generously sized bedrooms and utility room. The kitchen flaunts sleek modern cabinetry and pendant lighting, large island, granite countertops, a gas range, a walk-in pantry and opens up to the family and dining area creating a masterfully planned open concept. The primary bedroom is located on the first floor with a private en-suite bath flaunting tile flooring, dual vanities, a separate shower + stand alone tub, and a massive walk-in closet. The second story boasts a bedroom, full bath, and a large game room. Exterior features include an attached 2-car garage, access to Lake Conroe, an area pool, and SO much more! Schedule a private tour today!' ,`Acres` = '0.1292' ,`Area` = '39' ,`BuilderName` = 'Level TX' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S654503 - LAKE BREEZE 03, BLOCK 1, LOT 59' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '5628' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'LAGWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Lake Breeze 03' ,`TaxAmount` = '1018' ,`TaxRate` = '2.5148' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702078' WHERE `Matrix_Unique_ID` = '211576885' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T11:11:15.927' ,`MLSNumber` = '4192524' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.398932' ,`Longitude` = '-95.548575' ,`PhotoCount` = '9' ,`PostalCode` = '77318' ,`RoomCount` = '10' ,`ListPrice` = '856661.00' ,`Status` = 'Active' ,`StreetName` = 'Lake Mist' ,`StreetNumber` = '10736' ,`StreetSuffix` = 'Lane' ,`City` = 'Willis' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3084' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located on Lake Conroe, this stunning 4 bed, 4.5 bath 2-story home is sure to provide the most exquisite water views! Boasting 3,084 square feet of living space, this home features soaring high ceilings, elegant wood finishes, an oversized gourmet kitchen, a home office + game room upstairs, and generously sized bedrooms and utility room. The kitchen flaunts sleek modern cabinetry and pendant lighting, large island, granite countertops, a gas range, a walk-in pantry and opens up to the family and dining area creating a masterfully planned open concept. The primary bedroom is located on the first floor with a private en-suite bath flaunting tile flooring, dual vanities, a separate shower + stand alone tub, and a massive walk-in closet. The second story boasts 2 bedrooms, 2 full baths, and a large game room. Exterior features include an attached 2-car garage, access to Lake Conroe, an area pool, and SO much more! Schedule a private tour today!' ,`Acres` = '0.1328' ,`Area` = '39' ,`BuilderName` = 'Level TX' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S654502 - Lake Breeze 02, BLOCK 1, Lot 39' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '5786' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'LAGWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Lake Breeze 02' ,`TaxAmount` = '1018' ,`TaxRate` = '2.5148' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702078' WHERE `Matrix_Unique_ID` = '211582917' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T11:41:04.600' ,`MLSNumber` = '69393995' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.399430' ,`Longitude` = '-95.548438' ,`PhotoCount` = '6' ,`PostalCode` = '77318' ,`RoomCount` = '10' ,`ListPrice` = '882050.00' ,`Status` = 'Active' ,`StreetName` = 'Lake Mist' ,`StreetNumber` = '11037' ,`StreetSuffix` = 'Lane' ,`City` = 'Willis' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3123' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located on Lake Conroe, this stunning 4 bed, 3.5 bath 2-story home is sure to provide the most exquisite water views! Boasting 3,123 square feet of living space, this home features soaring high ceilings, elegant wood finishes, an oversized gourmet kitchen, a home office + game room upstairs, and generously sized bedrooms and utility room. The kitchen flaunts sleek modern cabinetry and pendant lighting, large island, granite countertops, a gas range, a walk-in pantry and opens up to the family and dining area creating a masterfully planned open concept. The primary bedroom is located on the first floor with a private en-suite bath flaunting tile flooring, dual vanities, a separate shower + stand alone tub, and a massive walk-in closet. The second story boasts 3 bedrooms, 2 full baths, and a large game room. Exterior features include an attached 2-car garage, access to Lake Conroe, an area pool, and SO much more! Schedule a private tour today!' ,`Acres` = '0.1294' ,`Area` = '39' ,`BuilderName` = 'Level TX' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S654503 - Lake Breeze 03, BLOCK 1, Lot 58' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '5640' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'LAGWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Lake Breeze 03' ,`TaxAmount` = '1018' ,`TaxRate` = '2.5148' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702078' WHERE `Matrix_Unique_ID` = '211583416' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T11:36:28.690' ,`MLSNumber` = '9686487' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.398985' ,`Longitude` = '-95.548848' ,`PhotoCount` = '6' ,`PostalCode` = '77318' ,`RoomCount` = '8' ,`ListPrice` = '667181.00' ,`Status` = 'Active' ,`StreetName` = 'Lake Mist' ,`StreetNumber` = '10740' ,`StreetSuffix` = 'Lane' ,`City` = 'Willis' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2458' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located on Lake Conroe, this stunning 3 bed, 3.5 bath 1-story home is sure to provide the most exquisite water views! Boasting 2,458 square feet of living space, this home features soaring high ceilings, elegant wood finishes, an oversized gourmet kitchen, a home office, game room, and generously sized bedrooms and utility room. The kitchen flaunts sleek modern cabinetry and pendant lighting, large island, granite countertops, a gas range, a walk-in pantry and opens up to the family and dining area creating a masterfully planned open concept. The primary boasts a private en-suite bath flaunting tile flooring, dual vanities, a separate shower + stand alone tub, and a massive walk-in closet. Exterior features include an attached 2-car garage, access to Lake Conroe, an area pool, and SO much more! Schedule a private tour today!' ,`Acres` = '0.1328' ,`Area` = '39' ,`BuilderName` = 'Level TX' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S654502 - Lake Breeze 02, BLOCK 1, Lot 40' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '5786' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'LAGWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Lake Breeze 02' ,`TaxAmount` = '1018' ,`TaxRate` = '2.5148' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702078' WHERE `Matrix_Unique_ID` = '211584627' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T10:20:20.553' ,`MLSNumber` = '88205216' ,`ListAgentFullName` = 'Rodrigo Munguia' ,`ListOfficeName` = 'D&R Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.768908' ,`Longitude` = '-95.407372' ,`PhotoCount` = '27' ,`PostalCode` = '77007' ,`RoomCount` = '3' ,`ListPrice` = '646900.00' ,`Status` = 'Active' ,`StreetName` = 'Rose' ,`StreetNumber` = '4601' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2630' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GREAT LOCATION! Stunning three-story home in the heart of the highly sought after Rice Military, Spacious home w/ balcony out of Principal Bedroom, features 3 beds/3 baths/a guest bathroom and 2 car attached garage with lots of natural light on a corner lot. One bedroom 1st Floor which can be utilized as a guest room, Home office, or gym and other two bedrooms are on 3rd floor. 2nd floor features living room dining room, kitchen features breakfast bar and stainless steel appliances as well as a separate breakfast area; Primary bedroom with EnSite bath is located on the 3rd floor along with utility. Primary bedroom features two large walk in closets. Primary bathroom features a garden tub with separate shower.' ,`Acres` = '' ,`Area` = '16' ,`BuilderName` = 'Milano Home Builders' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rice Military/Washington Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 MILANO ON ROSE STREET' ,`LotDesciption` = 'Corner' ,`LotSize` = '1900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Brunner' ,`TaxAmount` = '10096' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702079' WHERE `Matrix_Unique_ID` = '211665464' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T10:33:53.900' ,`MLSNumber` = '17970605' ,`ListAgentFullName` = 'Alicia Grifaldo' ,`ListOfficeName` = 'Redfin Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.065476' ,`Longitude` = '-95.369072' ,`PhotoCount` = '28' ,`PostalCode` = '77373' ,`RoomCount` = '10' ,`ListPrice` = '318000.00' ,`Status` = 'Active' ,`StreetName` = 'Breckenridge Dale' ,`StreetNumber` = '23515' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2329' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful move-in ready home on a culdesac! Enjoy your morning coffee on the tucked away porch before stepping inside where wood-look tile floors make maintenance a breeze. Open concept living room has lots of natural light and flows easily into the kitchen with a breakfast bar, granite counters, and ample storage. All bedrooms are upstairs, including the primary separated from the secondary bedrooms and featuring dual sinks, tub, and large glassed-in shower. Enjoy time with friends and family in the game room! Don\'t miss the fully fenced backyard with a covered patio and lots of green space. Conveniently located near parks with easy access to highways, shopping, and dining!' ,`Acres` = '0.1055' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 3 BRECKENRIDGE PARK 2ND PAR R/P' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '4594' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'GLORIA MARSHALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Breckenridge Park Prcl R/P #2' ,`TaxAmount` = '6420' ,`TaxRate` = '2.8117' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702079' WHERE `Matrix_Unique_ID` = '211690670' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T11:58:34.883' ,`MLSNumber` = '21799919' ,`ListAgentFullName` = 'Sophia Pickens-Graves' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.813776' ,`Longitude` = '-95.284331' ,`PhotoCount` = '6' ,`PostalCode` = '77028' ,`RoomCount` = '5' ,`ListPrice` = '190000.00' ,`Status` = 'Active' ,`StreetName` = 'Sparta' ,`StreetNumber` = '7985' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful newly under construction home is located in the up-and-coming Settagast Community. It consists of 3 bedrooms 2 bath with gorgeous high ceiling and open concept with a perfect view of the house. Oversized Island Kitchen with granite counter tops. This beautiful 1 story home is a jewel that offers energy efficient design plenty of windows for natural sunlight. Schools are in HISD. Perfect Location, full of new development. Elevation subject to change without notice. Lot 47 only' ,`Acres` = '0.0964' ,`Area` = '2' ,`BuilderName` = 'MHL Properties LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 47 BLK 51 LIBERTY ROAD MANOR SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4199' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ELMORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Liberty Road Manor Sec 06' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663702079' WHERE `Matrix_Unique_ID` = '211705647' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T11:32:29.550' ,`MLSNumber` = '52296807' ,`ListAgentFullName` = 'Chandler Sampson' ,`ListOfficeName` = 'My Castle Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.436162' ,`Longitude` = '-97.998609' ,`PhotoCount` = '18' ,`PostalCode` = '78645' ,`RoomCount` = '7' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Outpost' ,`StreetNumber` = '4098' ,`StreetSuffix` = 'Trace' ,`City` = 'Lago Vista' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1852' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful, well maintained home located on the Lago Vista Golf Course! About one mile from the waters of Lake Travis this home has high Ceilings, an open kitchen, and wonderful views of the golf course with large glass doors in almost every room. Lago Vista boasts dozens of amenities for its members, including private access parks, boat launch points, an RV park, restaurants and trails with an abundance of deer and wildlife.' ,`Acres` = '0.2724' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 2708 LAGO VISTA COUNTRY CLUB ESTATES SEC 11' ,`LotDesciption` = 'In Golf Course Community,On Golf Course' ,`LotSize` = '11866' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '114 - Lago Vista' ,`SchoolElementary` = 'LAGO VISTA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAGO VISTA HIGH SCHOOL' ,`SchoolMiddle` = '' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Lago Vista Country Club Estate' ,`TaxAmount` = '6458' ,`TaxRate` = '2.4782' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702079' WHERE `Matrix_Unique_ID` = '211706836' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T11:58:14.870' ,`MLSNumber` = '19605034' ,`ListAgentFullName` = 'Sophia Pickens-Graves' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.813776' ,`Longitude` = '-95.284331' ,`PhotoCount` = '6' ,`PostalCode` = '77028' ,`RoomCount` = '5' ,`ListPrice` = '190000.00' ,`Status` = 'Active' ,`StreetName` = 'Angus' ,`StreetNumber` = '7957' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful newly under construction home is located in the up-and-coming Settagast Community. It consists of 3 bedrooms 2 bath with gorgeous high ceiling and open concept with a perfect view of the house. Oversized Island Kitchen with granite counter tops. This beautiful 1 story home is a jewel that offers energy efficient design plenty of windows for natural sunlight. Schools are in HISD. Perfect Location, full of new development. Elevation subject to change without notice. Lot 47 only' ,`Acres` = '0.0964' ,`Area` = '2' ,`BuilderName` = 'MHL Properties LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 37 BLK G LIBERTY ROAD MANOR SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4199' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ELMORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Liberty Road Manor Sec 06' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663702079' WHERE `Matrix_Unique_ID` = '211708234' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T11:57:53.530' ,`MLSNumber` = '10728597' ,`ListAgentFullName` = 'Sophia Pickens-Graves' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.813776' ,`Longitude` = '-95.284331' ,`PhotoCount` = '6' ,`PostalCode` = '77028' ,`RoomCount` = '5' ,`ListPrice` = '190000.00' ,`Status` = 'Active' ,`StreetName` = 'Haight St' ,`StreetNumber` = '5907' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful newly under construction home is located in the up-and-coming Settagast Community. It consists of 3 bedrooms 2 bath with gorgeous high ceiling and open concept with a perfect view of the house. Oversized Island Kitchen with granite counter tops. This beautiful 1 story home is a jewel that offers energy efficient design plenty of windows for natural sunlight. Schools are in HISD. Perfect Location, full of new development. Elevation subject to change without notice. Lot 47 only' ,`Acres` = '0.0964' ,`Area` = '2' ,`BuilderName` = 'MHL Properties LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 BLK 2 LIBERTY ROAD MANOR' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4199' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ELMORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'LIBERTY TERRACE' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663702079' WHERE `Matrix_Unique_ID` = '211708469' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T10:40:59.970' ,`MLSNumber` = '15262862' ,`ListAgentFullName` = 'Sean Ward' ,`ListOfficeName` = 'Vylla Home' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.676257' ,`Longitude` = '-95.492476' ,`PhotoCount` = '17' ,`PostalCode` = '77096' ,`RoomCount` = '11' ,`ListPrice` = '460000.00' ,`Status` = 'Active' ,`StreetName` = 'Braesheather' ,`StreetNumber` = '5866' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2587' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.3002' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Meyerland Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 15 MAPLEWOOD SOUTH SEC 4' ,`LotDesciption` = 'Corner' ,`LotSize` = '13077' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HEROD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Maplewood South Sec 04' ,`TaxAmount` = '8735' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702079' WHERE `Matrix_Unique_ID` = '211721384' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T11:06:33.650' ,`MLSNumber` = '2516263' ,`ListAgentFullName` = 'Daisy Lopez' ,`ListOfficeName` = 'Move Up America' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.795386' ,`Longitude` = '-95.848854' ,`PhotoCount` = '30' ,`PostalCode` = '77493' ,`RoomCount` = '9' ,`ListPrice` = '504990.00' ,`Status` = 'Active' ,`StreetName` = 'Hanover' ,`StreetNumber` = '7406' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HE BROCTON IS A BOASTING BEAUTY! This Split Plan Single Story offers it all with 4 Bedrooms, 3 Bathrooms, a Study w/ Storage, a Central Game Room, Oversized Covered Patio + 2 Car Garage. Huge Quartz Island Kitchen w/ Adjacent Casual Dining that\'s Open to the Vaulted Ceiling Family Room that carries out to the Outdoor Living Space! Exquisite Owner\'s Retreat offering a Bay-wall of Windows overlooking the Backyard! Secondary Bedrooms offer convenience to Game Room. Private Study located off Foyer. Stainless Steel Appliances, 8\' Doors, 2\" Blinds, Upgraded Wood Tile Flooring, Security System, Sprinkler System, Fully Sodded Yard + Landscaping Pkg all included!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Chesmar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot: 9 Block: 2 Section: 15' ,`LotDesciption` = 'Corner' ,`LotSize` = '10270' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cane Island' ,`TaxAmount` = '' ,`TaxRate` = '3.41' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702080' WHERE `Matrix_Unique_ID` = '211724711' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T11:16:39.023' ,`MLSNumber` = '89768861' ,`ListAgentFullName` = 'John Goerner' ,`ListOfficeName` = 'Keller Williams Advtge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.456619' ,`Longitude` = '-95.466611' ,`PhotoCount` = '11' ,`PostalCode` = '77378' ,`RoomCount` = '3' ,`ListPrice` = '247900.00' ,`Status` = 'Active' ,`StreetName` = 'Bonham' ,`StreetNumber` = '14986' ,`StreetSuffix` = 'Lane' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1554' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**THIS HOME INCLUDES TWO LOTS 96 AND 97 TOTALING 8,137 SQFT OF LAND!!**\r\nNew construction by Quality Custom Homes! Two story 3 bed 2.5 bath charmer with a multi-purpose bonus room! Large open-concept living area with lots of natural light, wood look tile floors, and high vaulted ceilings which provide a wonderful sense of space. The kitchen boasts a fresh modern look with gorgeous granite countertops, an island, beautiful wood cabinets, large pantry for storage, and stainless steel appliances. This builder includes higher quality fixtures throughout the home. The primary bath has a very nice shower with a calming spa feel. There is a dedicated laundry room and a beautiful patio! PLEASE NOTE: This house will be completed by mid May. If you put under contract fast enough you can select from a variety of custom colors/material options to give this home your personal touch!' ,`Acres` = '0.0933' ,`Area` = '19' ,`BuilderName` = 'SJP Capital' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Willis Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'FRONTIER LAKES 03, BLOCK 18, LOT 96' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4062' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '165' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'PARMLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Frontier Lakes 03' ,`TaxAmount` = '67' ,`TaxRate` = '1.8448' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702080' WHERE `Matrix_Unique_ID` = '211724799' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T11:40:08.970' ,`MLSNumber` = '41250986' ,`ListAgentFullName` = 'Bob DiTullio' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.363304' ,`Longitude` = '-95.588448' ,`PhotoCount` = '33' ,`PostalCode` = '77356' ,`RoomCount` = '8' ,`ListPrice` = '649999.00' ,`Status` = 'Active' ,`StreetName` = 'Old Aqua' ,`StreetNumber` = '354' ,`StreetSuffix` = 'Landing' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3007' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Luxury Lake Life in Lake Conroe! Three stories of tranquil views of the twenty two mile lake Conroe. Gated for security, close to all the entertainment Lake Conroe has to offer. Modified aluminum boat lift converted for dual jet skis, jet skis not included, closed in lower deck to relax. Over $150k in renovations with a transferrable warranty on majority of workmanship. Amenities include: Kent Moore cabinets, new flooring, island kitchen, extra deep/wide kitchen sink, upgraded fixtures, and freshly painted. The primary bathroom will overwhelm you with waterfall, rain, targeted jets shower and bath, level 5 authentic Carrera marble sinks and modern faucets.\r\nYour journey to a phenomenal lake home is awaiting you!\r\n****PROPERTY CANNOT BE LEASED OUT FOR LESS THAN A YEAR****' ,`Acres` = '0.0537' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S252600 - BAY POINTE LANDING ON LAKE CONROE, BLOCK 1, LOT 25' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '2340' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2310' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Bay Pointe Landing On Lake Con' ,`TaxAmount` = '9278' ,`TaxRate` = '2.2863' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702080' WHERE `Matrix_Unique_ID` = '211725073' --> Updated record success