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-23T13:04:05.297' ,`MLSNumber` = '34178468' ,`ListAgentFullName` = 'Bridget Moore' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.456360' ,`Longitude` = '-95.472070' ,`PhotoCount` = '50' ,`PostalCode` = '77378' ,`RoomCount` = '10' ,`ListPrice` = '324999.00' ,`Status` = 'Active' ,`StreetName` = 'Indian Hill' ,`StreetNumber` = '14816' ,`StreetSuffix` = 'Trail' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '3010' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investor opportunity with a 12 month lease in place. Cozy single-story ranch-style home situated on 4 lots in Arrowhead Lakes. Extensive wraparound covered porch welcomes you into this home & provides the perfect spot to enjoy the morning Texas air. Entry way leads to office/study space as well as oversized den. Den complete w/ brick fireplace & pass-through kitchen window. Kitchen open to breakfast room & features large pantry, gas range/oven, & plenty of cabinets for all of your storage needs. Large 2nd living space open to dining room. An entertainer’s dream! Primary bedroom w/ unique separate closets/shelves & french doors leading to porch. Primary bathroom features separate shower, double sink vanity, & a large tub that is sure to provide ample relaxation on even the hardest days. 28x17 secondary bedroom can accommodate multiple beds. 3rd bedroom is generously sized. Back/side yard is enormous! Per seller home was renovated and expanded from 1500 sq ft. to 3000+ sq ft in 2000.' ,`Acres` = '0.5919' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Willis Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ARROWHEAD LAKES 03, BLOCK 31, LOT 18,19,20,&21' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '25785' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '240' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'PARMLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Arrowhead Lakes 03' ,`TaxAmount` = '3654' ,`TaxRate` = '1.9149' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702105' WHERE `Matrix_Unique_ID` = '202617599' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T13:57:56.270' ,`MLSNumber` = '47946575' ,`ListAgentFullName` = 'Jeffrey Welch' ,`ListOfficeName` = 'Welch Realty Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.833332' ,`Longitude` = '-95.365638' ,`PhotoCount` = '7' ,`PostalCode` = '77022' ,`RoomCount` = '2' ,`ListPrice` = '138000.00' ,`Status` = 'Active' ,`StreetName` = 'Helmers' ,`StreetNumber` = '7816' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '888' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location, Location, Location! This lot is for sale at lot value only. The home is uninhabitable so no access will be granted. This is a tear-down and a new home to be built. This location is close to everything! Let\'s make a deal.' ,`Acres` = '0.1921' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 9 OAKCREST' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8370' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'JANOWSKI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SAM HOUSTON MATH SCIENCE AND TECHNOLOGY CENTER' ,`SchoolMiddle` = 'BURBANK MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required,No Photos/No Videos,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oakcrest' ,`TaxAmount` = '2175' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1938' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702105' WHERE `Matrix_Unique_ID` = '205192210' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T12:23:49.270' ,`MLSNumber` = '97747067' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Tanequia Nunn' ,`SellingOfficeName` = 'Keller Williams Professionals' ,`Latitude` = '29.910331' ,`Longitude` = '-95.712649' ,`PhotoCount` = '27' ,`PostalCode` = '77433' ,`RoomCount` = '16' ,`ListPrice` = '619857.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Southern Stream' ,`StreetNumber` = '19910' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3792' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Hopkins III, Elevation F) Two Story. 4 bedrooms, 3.5 baths. Primary suite with spacious walk-in closet. Spacious island kitchen with breakfast area is open to the family room. Formal dining room. First floor study. Second floor game room, media room and additional 3 bedrooms. Covered patio and attached 2 car garage. Miramesa is part of the Canyon Gate family of communities. Its master plan includes approximately 920 acres south of U.S. 290 off Fry Road. Miramesa is centered on the concept that your home is a peaceful refuge at the end of each day. Miramesa is home to a multi-faceted recreation complex and is planned for an on-site school. Plus, residents of Miramesa have full privileges to the amenities within Stone Gate & Canyon Lakes West. Stop by the Westin Homes model home today to find out more about Miramesa!' ,`Acres` = '0.1792' ,`Area` = '25' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7804' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '940' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'POSTMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Miramesa' ,`TaxAmount` = '1852' ,`TaxRate` = '3.041' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702105' WHERE `Matrix_Unique_ID` = '205259578' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T12:47:20.250' ,`MLSNumber` = '45587276' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = 'Patrick Beneventi' ,`SellingOfficeName` = 'Keller Williams Signature' ,`Latitude` = '29.837430' ,`Longitude` = '-94.816132' ,`PhotoCount` = '24' ,`PostalCode` = '77523' ,`RoomCount` = '14' ,`ListPrice` = '676856.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Arenosa' ,`StreetNumber` = '15106' ,`StreetSuffix` = 'Avenue' ,`City` = 'Mont Belvieu' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3404' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to Icet Creek Crossing. The one-story Hayden brick home with stone accents features 4 bedrooms, 3 baths and 3 car attached garage with storage. Convenient home office tucked off foyer. Versatile activity room is located off hall 2. Open dining room with easy access to gourmet kitchen. Beautiful maple cabinets, quartz countertops and farmhouse sink in kitchen. Cozy stone fireplace with cedar mantel and raised hearth in great room. The owner\'s luxury bath has a huge walk-in closet, linen closet, dual vanity sinks, separate tub and shower. Spacious laundry room includes a sink. Grill outside or relax under the covered patio. \r\nStudents are zoned to Barbers Hill ISD. Icet Creek Crossing is located within close proximity to Eagle Pointe Golf Course and Mont Belvieu City Park. Icet Creek Crossing is offered by K. Hovnanian of Houston II, L.L.C.' ,`Acres` = '0.75' ,`Area` = '53' ,`BuilderName` = 'K. Hovnanian Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '2/1/4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '32671' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '525' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL NORTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL NORTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Icet Creek Crossing' ,`TaxAmount` = '' ,`TaxRate` = '2.16' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702105' WHERE `Matrix_Unique_ID` = '205277515' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T13:42:19.223' ,`MLSNumber` = '24615313' ,`ListAgentFullName` = 'Libby Mitchell' ,`ListOfficeName` = 'REGENCY REAL ESTATE PROF' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.999911' ,`Longitude` = '-93.814653' ,`PhotoCount` = '6' ,`PostalCode` = '77611' ,`RoomCount` = '6' ,`ListPrice` = '253600.00' ,`Status` = 'Active' ,`StreetName` = 'Zachary' ,`StreetNumber` = '211' ,`StreetSuffix` = 'Lane' ,`City` = 'Bridge City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1656' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Here\'s another brand new construction in Marsh Estates! DSLD Homes\' \"Dogwood\" plan offers a 3 bedroom and 2 full bathroom open floor plan in BCISD! Special features: Stainless appliances, 3 cm granite countertops & undermount sinks throughout, birch cabinets throughout, Luxury Vinyl Plank flooring in living area & halls, ceramic tile in wet areas & carpet in bedrooms. LED lighting throughout, ceiling fans in the living area and master bedroom, Bronze plumbing fixtures, post tension slab, and more! Energy Efficient Features: Tankless gas water heater, low E tilt-in windows, radiant barrier roof decking, and more!' ,`Acres` = '' ,`Area` = '50' ,`BuilderName` = 'DSLD Homes, LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 12' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '53' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '367 - Bridge City' ,`SchoolElementary` = 'BRIDGE CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGE CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BRIDGE CITY MIDDLE SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Marsh Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702105' WHERE `Matrix_Unique_ID` = '207762651' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T12:21:55.723' ,`MLSNumber` = '77343035' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Chris Loera' ,`SellingOfficeName` = 'Texas United Realty' ,`Latitude` = '30.274459' ,`Longitude` = '-95.535133' ,`PhotoCount` = '23' ,`PostalCode` = '77316' ,`RoomCount` = '16' ,`ListPrice` = '644976.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Tawny Leaf' ,`StreetNumber` = '509' ,`StreetSuffix` = 'Court' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3459' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Preston III, Elevation B) CURRENTLY BEING BUILT. Two story. 4 bedrooms. 3.5 baths. Primary suite downstairs with large walk-in closet. Family room, formal dining, and living room. Spacious island kitchen. Game room and media room upstairs. Covered back patio and attached 2-car garage. You\'ll fall in love with the Woodforest lifestyle—there’s something for everyone! The frequent social events and community amenities are a quick golf cart ride away. These days, residents of Woodforest can be found biking along miles of scenic trails, dining and shopping at The Shops at Woodforest, relaxing by the pool, touring the community via golf cart, or hitting the links at the renowned Woodforest Golf Club. Stop by the Westin Homes sales model to learn more about Woodforest!' ,`Acres` = '0.3361' ,`Area` = '39' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BLOCK 1, LOT 23' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14639' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1265' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest' ,`TaxAmount` = '1560' ,`TaxRate` = '2.6888' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702106' WHERE `Matrix_Unique_ID` = '208242579' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T12:25:27.377' ,`MLSNumber` = '63638015' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Robin Prouse' ,`SellingOfficeName` = 'UTR TEXAS, REALTORS' ,`Latitude` = '29.409291' ,`Longitude` = '-95.055009' ,`PhotoCount` = '38' ,`PostalCode` = '77568' ,`RoomCount` = '15' ,`ListPrice` = '544637.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Secret Lagoon' ,`StreetNumber` = '2910' ,`StreetSuffix` = 'Lane' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction. (Lexington, Elevation A.) CURRENTLY BEING BUILT. Lake front lot. Two story. 4 bedrooms. 3.5 baths. Family room, informal dining room, and study. Spacious island kitchen open to Family room. Primary suite with large double walk-in closets. Second bedroom downstairs with private bath. Spacious game room and media room on second floor. Covered patio and 2-car garage. Representing a prime location off I-45 South in the Galveston-Clear Lake corridor, you’ll find Lago Mar and its resort style living! Bay Area breezes will caress you while you lounge on white-sand beaches, swim in Caribbean-blue waters or dine lagoon-side on our beach boardwalk. Lago Mar includes 2 private resident gyms, 2 resident pools, playgrounds and acres of outdoor space. It’s an unparalleled standard of living where life is truly a breeze! Stop by the Westin Homes model home today to find out more about Lago Mar!' ,`Acres` = '0.2204' ,`Area` = '33' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 17 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9601' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1730' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '1991' ,`TaxRate` = '3.55' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702106' WHERE `Matrix_Unique_ID` = '208627795' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T12:11:56.047' ,`MLSNumber` = '85476987' ,`ListAgentFullName` = 'Grace Weng' ,`ListOfficeName` = 'Intex Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.733885' ,`Longitude` = '-95.485462' ,`PhotoCount` = '41' ,`PostalCode` = '77057' ,`RoomCount` = '6' ,`ListPrice` = '380000.00' ,`Status` = 'Active' ,`StreetName` = 'Fairdale Estates' ,`StreetNumber` = '3007' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1962' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Kitchen- 42\'\' Oak cabinets, granite countertops, stainless steel under-mount sink, stainless steel w/ blk appliances, 12\'\'x12\'\' tile backsplash. Wood flooring- certain areas- 2nd fl. Hand-stained handrails w/ spindles- stairs. Crown molding- master, dining, living, flex w/ high ceilings. Master bath- jetted tub, shower, 2 vanities. marble vanity tops w/ integrated wave bowls full baths. Stucco ext front w/ 8\' mahogany & glass front door, wrought iron railings & keystone accents.' ,`Acres` = '0.0321' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Galleria' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 2 FAIRDALE PLACE ESTATES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PILGRIM ACADEMY' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Sunset Rdg West Sec 7' ,`TaxAmount` = '8579' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702106' WHERE `Matrix_Unique_ID` = '208946042' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T12:44:29.670' ,`MLSNumber` = '4488794' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = 'Kirk Williams' ,`SellingOfficeName` = 'UTR TEXAS, REALTORS' ,`Latitude` = '29.837998' ,`Longitude` = '-94.816641' ,`PhotoCount` = '10' ,`PostalCode` = '77523' ,`RoomCount` = '14' ,`ListPrice` = '667800.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Arenosa' ,`StreetNumber` = '15107' ,`StreetSuffix` = 'Avenue' ,`City` = 'Mont Belvieu' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3070' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to Icet Creek Crossing. The one-story Matthew brick home with stone accents features 4 bedrooms, 3.5 baths and 3 car tandem garage. Versatile bonus room and open dining room located off foyer. Beautiful maple cabinets, quartz countertops, double ovens, gas cooktop and farmhouse sink in gourmet kitchen. Cozy Craftsman mantel fireplace with crown and tile surrounds in great room. Huge owner\'s walk-in closet, dual vanity sinks, separate tub and shower in owner\'s bath. Double sinks in hall bath. Bedroom 4 features an en-suite bath with shower. Grill outside or relax under the covered patio. \r\nStudents are zoned to Barbers Hill ISD. Icet Creek Crossing is located within close proximity to Eagle Pointe Golf Course and Mont Belvieu City Park. Icet Creek Crossing is offered by K. Hovnanian of Houston II, L.L.C.' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'K. Hovnanian Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '2/3/4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '33770' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '525' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL NORTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL NORTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Icet Creek Crossing' ,`TaxAmount` = '' ,`TaxRate` = '2.16' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702106' WHERE `Matrix_Unique_ID` = '209061355' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T13:27:24.077' ,`MLSNumber` = '19679151' ,`ListAgentFullName` = 'Libby Mitchell' ,`ListOfficeName` = 'REGENCY REAL ESTATE PROF' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.082287' ,`Longitude` = '-93.794743' ,`PhotoCount` = '6' ,`PostalCode` = '77630' ,`RoomCount` = '6' ,`ListPrice` = '233490.00' ,`Status` = 'Active' ,`StreetName` = 'Cottonwood' ,`StreetNumber` = '701' ,`StreetSuffix` = 'Drive' ,`City` = 'Orange' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1624' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DSLD Homes \"Brookdale\" plan offers a 3 bedroom and 2 full bathroom open floor plan. Special features: Black appliances, 3 cm granite countertops throughout, birch cabinets throughout, Luxury Vinyl Plank flooring in living area, halls, and wet areas with carpet in bedrooms; ceiling fans in the living area and master bedroom, Bronze plumbing fixtures in the bathrooms, post tension slab, and more! Energy Efficient Features: Tankless gas water heater, low E tilt-in windows, radiant barrier roof decking, and more!' ,`Acres` = '' ,`Area` = '50' ,`BuilderName` = 'DSLD Homes, LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 17 Sec. 2' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '70' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '367 - Bridge City' ,`SchoolElementary` = 'BRIDGE CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGE CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BRIDGE CITY MIDDLE SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypresswood Village' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702106' WHERE `Matrix_Unique_ID` = '209172389' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T13:54:34.197' ,`MLSNumber` = '51891704' ,`ListAgentFullName` = 'Libby Mitchell' ,`ListOfficeName` = 'REGENCY REAL ESTATE PROF' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.082287' ,`Longitude` = '-93.794743' ,`PhotoCount` = '6' ,`PostalCode` = '77630' ,`RoomCount` = '7' ,`ListPrice` = '262480.00' ,`Status` = 'Active' ,`StreetName` = 'Cottonwood' ,`StreetNumber` = '602' ,`StreetSuffix` = 'Drive' ,`City` = 'Orange' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1885' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DSLD Homes \"Ravenswood\" plan offers a 4 bedroom and 2 full bathroom open floor plan. Special features: Black appliances, 3 cm granite countertops throughout, birch cabinets throughout, Luxury Vinyl Plank flooring in living area, halls, and wet areas with carpet in bedrooms; ceiling fans in the living area and master bedroom, Bronze plumbing fixtures in the bathrooms, post tension slab, and more! Energy Efficient Features: Tankless gas water heater, low E tilt-in windows, radiant barrier roof decking, and more!' ,`Acres` = '' ,`Area` = '50' ,`BuilderName` = 'DSLD Homes, LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 27 Sec. 2' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '70' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '367 - Bridge City' ,`SchoolElementary` = 'BRIDGE CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGE CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BRIDGE CITY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypresswood Village' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702106' WHERE `Matrix_Unique_ID` = '209175375' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T13:04:52.033' ,`MLSNumber` = '79619701' ,`ListAgentFullName` = 'Kenneth Jones' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.701589' ,`Longitude` = '-95.452538' ,`PhotoCount` = '44' ,`PostalCode` = '77401' ,`RoomCount` = '12' ,`ListPrice` = '3900000.00' ,`Status` = 'Active' ,`StreetName` = 'Oleander' ,`StreetNumber` = '4516' ,`StreetSuffix` = 'Street' ,`City` = 'Bellaire' ,`BathsFull` = '6' ,`BathsHalf` = '2' ,`BedsTotal` = '6' ,`SqFtTotal` = '7816' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Jaw dropping design by Houston’s renowned, award-winning architect Mark Mucasey & built by Watermark. Situated on 30,000 square feet of prestigious Bellaire real estate this unique property offers extraordinary entertaining opportunities with a functional modern design. Upon entry guests will be wowed by soaring 24\' paneled ceilings & a wall of windows overlooking the spectacular grounds. Brilliantly designed downstairs floor plan includes full guest quarters with separate living area, full bath & large, bright bedroom. Downstairs also features one of two studies, incredible game room, large mud area & separate laundry facility with dog washing station. Upstairs primary suite features amazing windows overlooking the property, a peaceful private balcony & dual closets. Custom paneled study, large family/media room & full gym complete the second story layout. All bedrooms feature en-suite baths. This is a truly one-of-a-kind opportunity being offered by the original owner.' ,`Acres` = '0.6887' ,`Area` = '17' ,`BuilderName` = 'Watermark' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Bellaire Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 33 CRANFORD PLACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '30000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HORN ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Other Style' ,`Subdivision` = 'Cranford Place' ,`TaxAmount` = '55534' ,`TaxRate` = '2.2271' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702106' WHERE `Matrix_Unique_ID` = '209253073' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T13:26:56.947' ,`MLSNumber` = '32558620' ,`ListAgentFullName` = 'Michelle Doss' ,`ListOfficeName` = 'Mega Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.165850' ,`Longitude` = '-95.625444' ,`PhotoCount` = '40' ,`PostalCode` = '77486' ,`RoomCount` = '4' ,`ListPrice` = '364500.00' ,`Status` = 'Active' ,`StreetName` = 'Amherst' ,`StreetNumber` = '205' ,`StreetSuffix` = 'Drive' ,`City` = 'West Columbia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2185' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The pictures just do not do this home justice! Come tour this BEAUTIFUL newly built (2021) home right inside Columbia Lakes. This 4 bedroom, 2.5 bath home is filled with all kinds of detailed upgrades like new kitchen backsplash, frosted pantry doors, and new light fixtures just to name a few. The formal dining room is just right off of the kitchen with plenty of space for those family Thanksgiving gatherings! The kitchen is dressed in granite countertops, matching appliances, a breakfast table nook & a bar top that opens up to the living room. Who doesn\'t love a good open-concept home? The primary bedroom has a convenient ensuite bathroom with his and hers sinks. Outside the back yard features a solid covered porch, the most needed when living in this Texas heat! It is also equipped with a new privacy fence, built June 2021, with a 2-year warranty! Bring your family and come see this home for yourselves, your future awaits!' ,`Acres` = '0.2152' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'COLUMBIA LAKES SEC 4 (A0133 M VARNER) BLK 23 LOT 38' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9374' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection 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` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Columbia Lakes Sec 1-2-3-4-5' ,`TaxAmount` = '277' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702107' WHERE `Matrix_Unique_ID` = '209356064' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T13:41:21.927' ,`MLSNumber` = '91278720' ,`ListAgentFullName` = 'Hung Nguyen' ,`ListOfficeName` = 'The Nguyens & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.725551' ,`Longitude` = '-95.619122' ,`PhotoCount` = '27' ,`PostalCode` = '77082' ,`RoomCount` = '5' ,`ListPrice` = '309000.00' ,`Status` = 'Active' ,`StreetName` = 'Hollow Creek' ,`StreetNumber` = '3134' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2701' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2 story 4 bedrooms, 2.5 bathrooms home that offer high ceilling, large kitchen with tons of storage space and cabinets. Gorgeous tile flooring throughout common area and luxurious laminate flooring in all bedrooms. Long driveway that can accommodate good quantities of cars. Master bathroom features double vanity and walk-in shower. Conveniently located that is close to shopping, entertainment and dining. Only a short drive to the Galleria and easy access to major thoroughfares such as Westheimer Parkway, Beltway 8 and Highway 6. Please schedule your showing today!' ,`Acres` = '0.1452' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 30 BLK 15 PARKHOLLOW PLACE SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6325' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'HEFLIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'O\'DONNELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkhollow Place Sec 05' ,`TaxAmount` = '5401' ,`TaxRate` = '2.4411' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702107' WHERE `Matrix_Unique_ID` = '209595577' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T13:14:13.647' ,`MLSNumber` = '36343070' ,`ListAgentFullName` = 'Cheryle Sanderson' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.745951' ,`Longitude` = '-95.424296' ,`PhotoCount` = '50' ,`PostalCode` = '77019' ,`RoomCount` = '14' ,`ListPrice` = '5998900.00' ,`Status` = 'Active' ,`StreetName` = 'Avalon' ,`StreetNumber` = '3233' ,`StreetSuffix` = 'Place' ,`City` = 'Houston' ,`BathsFull` = '6' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '7924' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Presenting this River Oaks masterpiece, 6 homes from River Oaks Boulevard. French modern design with clean lines, lots of windows & light, the \"Bradford\" is perfect for today\'s modern style of living.Custom flooring & unique skylight feature in entryway.Nine-inch white oak flooring, climate controlled wine room, Lutron lighting system, Smart Home Technology, 3-story elevator.Up-to-the-minute kitchen boasts quartz countertops.Expansive island.Abundant cabinetry.Miele suite of appliances including built-in espresso system.Primary bedroom on 2nd floor has fireplace.Sitting area.Spa-like bathroom w/soaking tub, framed glass shower, mosaic tile flooring, Calcutta vanity counters.Showcase closet w/boutique-style planning. 3 more exquisitely designed ensuites opposite the primary. 3rd floor has fully equipped incredible theater w/ adjoining flex room & full bath, wet bar. 3-car attached 859SF garage suite w/kitchenette (not included in SF). Sparkling pool/spa, outdoor kitchen, generator!' ,`Acres` = '0.2583' ,`Area` = '16' ,`BuilderName` = 'Al Ross Luxury Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'River Oaks Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 18 RIVER OAKS COUNTRY CLUB ESTATE' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '11250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2460' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Freestanding Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'RIVER OAKS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'River Oaks Country Club Estate' ,`TaxAmount` = '112529' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702107' WHERE `Matrix_Unique_ID` = '209668340' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T13:37:33.563' ,`MLSNumber` = '39587673' ,`ListAgentFullName` = 'Chris Carpentier' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.710124' ,`Longitude` = '-95.097768' ,`PhotoCount` = '38' ,`PostalCode` = '77351' ,`RoomCount` = '2' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'Muscovy' ,`StreetNumber` = '398' ,`StreetSuffix` = 'Trail' ,`City` = 'Livingston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '2104' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this lovely updated gem! Home contains 2 full bedrooms and 2 full bathrooms with 3rd bedroom efficiency apartment attached to garage. New roof, AC, kitchens , baths, floors and windows make this home ready for immediate move in. The kitchen is open to living area w/ fireplace that has electric insert added. There is a large area that was once a porch enclosed that contains the laundry space and could be great game room or even an additional bedroom if needed. Large fenced in side yard and large front yard for plenty of space for pets and outdoor activities. This garage is very large and has room for multiple cars, RV or Boat and has a huge space above 2 car area (accessed by drop down steps ) that adds lots of room for storage. The efficiency apartment is not included in sq footage. Lot next door can be purchased separately. Schedule your showing today.' ,`Acres` = '0.5' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'NUGENT\'S COVE SECTION 2 BLK 6 LOT 53 THRU 56' ,`LotDesciption` = 'Cleared,Water View' ,`LotSize` = '22150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '160' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Nugents Cove Sec 2' ,`TaxAmount` = '3040' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702107' WHERE `Matrix_Unique_ID` = '209702100' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T12:40:41.197' ,`MLSNumber` = '84135377' ,`ListAgentFullName` = 'Rebecca Rawlinson' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.070332' ,`Longitude` = '-94.797684' ,`PhotoCount` = '15' ,`PostalCode` = '77575' ,`RoomCount` = '4' ,`ListPrice` = '155000.00' ,`Status` = 'Active' ,`StreetName` = 'Maple' ,`StreetNumber` = '1807' ,`StreetSuffix` = 'Street' ,`City` = 'Liberty' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1320' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you are in the market for an investment home or your next project, you\'ve found it! This has been a great rental and is located near a daycare center and the hospital. Fresh paint and new flooring! Appliances stay as well!' ,`Acres` = '0.2307' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Liberty' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'PARTLOW L-LIB, BLOCK 11, LOT 6, ACRES .2307' ,`LotDesciption` = 'Other' ,`LotSize` = '10049' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '73 - Liberty' ,`SchoolElementary` = 'LIBERTY ELEMENTARY SCHOOL (LIBERTY)' ,`SchoolHigh` = 'LIBERTY HIGH SCHOOL (LIBERTY)' ,`SchoolMiddle` = 'LIBERTY MIDDLE SCHOOL (LIBERTY)' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Partlow L-Lib' ,`TaxAmount` = '2502' ,`TaxRate` = '2.6826' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1948' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702107' WHERE `Matrix_Unique_ID` = '210603210' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T12:28:55.430' ,`MLSNumber` = '10771580' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Brad Thompson' ,`SellingOfficeName` = 'NB Elite Realty' ,`Latitude` = '29.494531' ,`Longitude` = '-95.388030' ,`PhotoCount` = '7' ,`PostalCode` = '77578' ,`RoomCount` = '16' ,`ListPrice` = '579857.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Limestone' ,`StreetNumber` = '4223' ,`StreetSuffix` = 'Terrace' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3450' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Preston III, Elevation CP) CURRENTLY BEING BUILT. Two Story. 4 bedrooms, 3.5 baths. Private Primary Suite with large walk-in closet. Spacious kitchen open to Family Room. Dining Room and Study. Media Room and Game Room upstairs. Covered patio and 2 car attached garage. Del Bello Lakes, located in Manvel, TX, will feature Jaxon’s Cove, a modern amenity center equipped with a splash pad, resort-style pool, outdoor pavilion, playground, and spaces for residents to book private events. Del Bello Lakes will also feature over 40 acres of lakes, a five-mile trail system, and 15 acres of parks and open space. Stop by the Westin Homes model home today to find out more about Del Bello Lakes!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BLK 2, LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7650' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '920' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'E C MASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'MANVEL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Del Bello Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.8' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702107' WHERE `Matrix_Unique_ID` = '210767244' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T13:24:28.767' ,`MLSNumber` = '71016322' ,`ListAgentFullName` = 'Syed Chishty' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.645708' ,`Longitude` = '-95.768189' ,`PhotoCount` = '38' ,`PostalCode` = '77406' ,`RoomCount` = '8' ,`ListPrice` = '369000.00' ,`Status` = 'Active' ,`StreetName` = 'Singing Flower' ,`StreetNumber` = '3735' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2281' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'IF YOU ARE LOOKING FOR A HOME IN THE MCCRARY NEIGHBORHOOD, THIS IS 4 BEDROOM,2 1/2 BATHROOM AND A GAME ROOM, 2281 SQFT HOME MIGH BE THE BEST IN THE MARKET RIGHT NOW. THE ENCHANTING TWO-STORY FLOOR PLAN FEATURES A SPACIOUS KITCHEN WITH A WALK-IN PANTRY, AN ADJOINING BREAKFAST ROOM\r\nTHAT OFFERS ACCESS TO A COVERED REAR PATIO, A GENEROUS FAMILY ROOM, AND A WALK-IN UTILITY ROOM. THE SPACIOUS FIRST FLOOR MASTER BEDROOM FEATURES AN EN SUITE MASTER BATHROOM OFFERING DUAL SINKS, A SEPERATE SHOWER AND TUB, A PRIVATE TOILET ENCLOSURE, AND A LARGE MASTER CLOSET. THE SECOND FLOOR FEATURES A LARGE GAME ROOM AND A FULL BATHROOM. ALL SECONDARY BATHROOMS IN THE FLOOR PLAN FEATURE WALK-IN CLOSETS.' ,`Acres` = '0.1557' ,`Area` = '37' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MCCRARY MEADOWS SEC 5, BLOCK 5, LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6784' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mccrary Meadows Sec 5' ,`TaxAmount` = '6941' ,`TaxRate` = '2.8548' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702107' WHERE `Matrix_Unique_ID` = '211062816' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T12:20:34.730' ,`MLSNumber` = '50770043' ,`ListAgentFullName` = 'Destiny Todd' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.963270' ,`Longitude` = '-95.229176' ,`PhotoCount` = '37' ,`PostalCode` = '77396' ,`RoomCount` = '10' ,`ListPrice` = '255000.00' ,`Status` = 'Active' ,`StreetName` = 'Old Draw' ,`StreetNumber` = '2806' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1567' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully maintained two story in Atascocita! Built in 2018, this 3 bedroom 2.5 bath beauty has it all and is so well kept! This home boasts an open concept living/kitchen/dining, large Primary bedroom with walk in closet and en suite bath, and a game room/loft area upstairs that\'s perfect for kiddos or a workspace! Yard is fenced and includes fruit trees: Meyer lemon, blood orange and a lime tree! All appliances stay! No flooding! No houses behind! Minutes to I-69 and IAH Airport, close to shopping and dining! Perfect spot to plant some roots!' ,`Acres` = '0.107' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Humble Area East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 2 ATOSCOCITA TRACE SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4661' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '366' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'RIVER PINES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'HUMBLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Atascocita Trace' ,`TaxAmount` = '5223' ,`TaxRate` = '2.933' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702108' WHERE `Matrix_Unique_ID` = '211323012' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T13:36:37.623' ,`MLSNumber` = '70970820' ,`ListAgentFullName` = 'Tessa Williamson' ,`ListOfficeName` = 'Crockett Springs Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.173362' ,`Longitude` = '-95.306462' ,`PhotoCount` = '22' ,`PostalCode` = '75851' ,`RoomCount` = '8' ,`ListPrice` = '159900.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 4200' ,`StreetNumber` = '5727' ,`StreetSuffix` = '' ,`City` = 'Lovelady' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1123' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This secluded 3 bedroom 1 bath home situated on 1-acre is waiting for you! The front porch is perfect for sitting and enjoying the peace and quiet. The living, kitchen, and dining areas are spacious with nice tile floors and plenty of closet space for coats, linens and blankets. There is a sliding glass door in the dining area offering gorgeous views of the back of the property to enjoy during dinner time. The primary bedroom shares a full bath with 2 guest bedrooms. Call today to schedule a showing of this incredible property!' ,`Acres` = '1.002' ,`Area` = '41' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Groveton Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'E TYLER AB 1019 1.002 AC' ,`LotDesciption` = 'Cleared,Other' ,`LotSize` = '43647' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '59 - Groveton' ,`SchoolElementary` = 'GROVETON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GROVETON J H-H S' ,`SchoolMiddle` = 'GROVETON J H-H S' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'none' ,`TaxAmount` = '1210' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702108' WHERE `Matrix_Unique_ID` = '211391445' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T13:26:30.910' ,`MLSNumber` = '2751523' ,`ListAgentFullName` = 'Astrid Lopez' ,`ListOfficeName` = 'Value Roc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.833720' ,`Longitude` = '-95.100729' ,`PhotoCount` = '17' ,`PostalCode` = '77360' ,`RoomCount` = '8' ,`ListPrice` = '125000.00' ,`Status` = 'Active' ,`StreetName` = 'Yaupon Oak' ,`StreetNumber` = '234' ,`StreetSuffix` = '' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1664' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nice and clean 2 bedroom 2 bath mobile home on almost half an acre in Yaupon Cove. Featuring new appliances. Huge living room space and a bonus extra room with a sink and cabinet space. Home has a central A/C and heater system. Property is just minutes away from Lake Livingston.Contact your agent to schedule your tour before is gone!' ,`Acres` = '0.4545' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'YAUPON COVE MOBILE HOME SECTION 1 LOT 8, 9 & 10' ,`LotDesciption` = 'Cleared' ,`LotSize` = '19800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Yaupon Cove Mobile Home Sectio' ,`TaxAmount` = '2292' ,`TaxRate` = '2.1464' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702108' WHERE `Matrix_Unique_ID` = '211641258' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T12:08:34.903' ,`MLSNumber` = '14118087' ,`ListAgentFullName` = 'Keely Ritchey' ,`ListOfficeName` = 'Key Real Estate PropertiesLLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.467060' ,`Longitude` = '-94.608764' ,`PhotoCount` = '36' ,`PostalCode` = '77650' ,`RoomCount` = '6' ,`ListPrice` = '699000.00' ,`Status` = 'Active' ,`StreetName` = 'ALBATROSS' ,`StreetNumber` = '976' ,`StreetSuffix` = 'Lane' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL NEW CONSTRUCTION 4 BEDROOM 2 BATH BEACH CABIN ON OVERSIZED LOT IN DESIRABLE HOLIDAY BEACH SUBDIVISION WITH BEACH ACCESS. INCLUDES A 1 CAR GARAGE THAT IS 12 X 30 GREAT FOR HOUSING A BOAT, VEHICLE OR BEACH TOYS. AMAZING OPEN FLOOR PLAN WITH LUXURY VINYL FLOORING THROUGHOUT. INCLUDES BEAMED CEILING IN LIVING AREA. KITCHEN INCLUDES QUARTZ COUNTERTOPS, BEAUTIFUL OVERSIZED ISLAND WITH LOTS OF SEATING AND STORAGE, SUBWAY BACKSPLASH, REFRIGERATOR, SEPARATE PANTRY AND OWNERS CLOSET FOR VACATION RENTAL OPTION. PRIMARY SUITE INCLUDES DOUBLE SINK, TUB TILE SURROUND, QUARTZ COUNTERTOP. UTILITY ROOM INCLUDES WASHER AND DRYER AND CABINETS FOR EXTRA STORAGE. BEACH LIVING AT IT\'S BEST WITH GREAT DECK SPACE TO ENJOY THE BEACH BREEZE. UNDER CABIN AREA SPACE IS BIG ENOUGH TO PARK EXTRA VEHICLES UNDER OR USE IT FOR GREAT OUTDOOR ENTERTAINING AREA.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'OLYMPIC BUILDERS' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TRACT 122-A BEING LOT 122 AND THE SOUTH 1/2 OF LOT 121' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'HOLIDAY BEACH' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702108' WHERE `Matrix_Unique_ID` = '211660648' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T12:03:12.103' ,`MLSNumber` = '92765662' ,`ListAgentFullName` = 'Sophia Pickens-Graves' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.813776' ,`Longitude` = '-95.284331' ,`PhotoCount` = '7' ,`PostalCode` = '77028' ,`RoomCount` = '5' ,`ListPrice` = '190000.00' ,`Status` = 'Active' ,`StreetName` = 'Fowlie' ,`StreetNumber` = '7982' ,`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.' ,`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 23 BLK K 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`='1663702108' WHERE `Matrix_Unique_ID` = '211666320' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T12:16:16.557' ,`MLSNumber` = '71565319' ,`ListAgentFullName` = 'Teresa Luo Mock' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.594602' ,`Longitude` = '-95.695419' ,`PhotoCount` = '27' ,`PostalCode` = '77479' ,`RoomCount` = '10' ,`ListPrice` = '399998.00' ,`Status` = 'Active' ,`StreetName` = 'Crestridge' ,`StreetNumber` = '403' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2462' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well-maintained beautiful house with a big lot is situated on the Cul de sac in New Territory, execllet school district, easy access to HWHY 90, 6 & 59. Just a minute to Memorial Hermann Hospital, First Colony Mall, Costco, HEB, and Sugar Land Asian Market. Features 4 bedrooms and 2 full bathrooms and 1 hall bath. No Carpet on the 1st floor. High ceiling, kitchen open to the living room, the formal dining room could be used as an office, huge game room on the upstairs. you will love the abundance of natural lights. The huge backyard has a playground and raised beds. there is enough space to build your pool. Never flood! Is a Germ MUST SEE!' ,`Acres` = '0.2758' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'AUTUMN RIDGE SEC 1, BLOCK 3, LOT 24' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '12015' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1060' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BRAZOS BEND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'SARTARTIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Autumn Ridge Sec 1' ,`TaxAmount` = '6207' ,`TaxRate` = '2.4394' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702108' WHERE `Matrix_Unique_ID` = '211670464' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T12:00:00.510' ,`MLSNumber` = '23578975' ,`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` = 'Fowlie' ,`StreetNumber` = '7973' ,`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.' ,`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 34 BLK H 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`='1663702108' WHERE `Matrix_Unique_ID` = '211707843' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T12:01:32.063' ,`MLSNumber` = '47300447' ,`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` = 'Fowlie' ,`StreetNumber` = '7965' ,`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.' ,`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 36 BLK H 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`='1663702109' WHERE `Matrix_Unique_ID` = '211707981' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T12:02:00.423' ,`MLSNumber` = '67935817' ,`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` = '7921' ,`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.' ,`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 32 BLK 51 LIBERTY ROAD MANOR SEC 14' ,`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`='1663702109' WHERE `Matrix_Unique_ID` = '211708103' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T12:00:21.663' ,`MLSNumber` = '36487905' ,`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` = '7977' ,`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 46 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`='1663702109' WHERE `Matrix_Unique_ID` = '211708144' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T12:30:10.727' ,`MLSNumber` = '70127792' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '33.912813' ,`Longitude` = '-98.515143' ,`PhotoCount` = '12' ,`PostalCode` = '76301' ,`RoomCount` = '3' ,`ListPrice` = '51900.00' ,`Status` = 'Active' ,`StreetName` = 'Lakewood' ,`StreetNumber` = '215' ,`StreetSuffix` = 'Drive' ,`City` = 'Wichita Falls' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cute as a button and perfectly priced. If you\'re a first time buyer, don\'t look past this one without seeing it in person. Looking for home to buy? Property in need of some TLC but could make cute home once fixed up. Located near the medical district, restaurants, and shopping. As Is' ,`Acres` = '0.2231' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 5 BLK 6 INGLEWOOD' ,`LotDesciption` = 'Cleared' ,`LotSize` = '9718' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1036 - Wichita Falls' ,`SchoolElementary` = 'BURGESS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WICHITA FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BARWISE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Inglewood' ,`TaxAmount` = '1308' ,`TaxRate` = '2.7399' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1954' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702109' WHERE `Matrix_Unique_ID` = '211725814' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T12:31:47.507' ,`MLSNumber` = '68204130' ,`ListAgentFullName` = 'John Goerner' ,`ListOfficeName` = 'Keller Williams Advtge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.456772' ,`Longitude` = '-95.466623' ,`PhotoCount` = '12' ,`PostalCode` = '77378' ,`RoomCount` = '3' ,`ListPrice` = '254900.00' ,`Status` = 'Active' ,`StreetName` = 'Bonham' ,`StreetNumber` = '14996' ,`StreetSuffix` = 'Lane' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1554' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**PLEASE NOTE THIS HOME INCLUDES 3 LOTS 98, 99, 100 TOTALING 12,062 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 the end of September. 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.0935' ,`Area` = '19' ,`BuilderName` = 'SJP Capital' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Willis Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S522003 - FRONTIER LAKES 03, BLOCK 18, LOT 98' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4075' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '165' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`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` = '68' ,`TaxRate` = '1.8448' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702109' WHERE `Matrix_Unique_ID` = '211725851' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T13:32:35.300' ,`MLSNumber` = '546446' ,`ListAgentFullName` = 'Tania Krowski' ,`ListOfficeName` = 'Mary Dunn Real Estate, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.742525' ,`Longitude` = '-94.843570' ,`PhotoCount` = '50' ,`PostalCode` = '77523' ,`RoomCount` = '6' ,`ListPrice` = '1490000.00' ,`Status` = 'Active' ,`StreetName` = 'FM 2354' ,`StreetNumber` = '14328' ,`StreetSuffix` = 'Road' ,`City` = 'Beach City' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1564' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WOW 12 Acres! This almost impossible-to-find property is located off of FM 2354 in BHISD. The property consists of 12 +/- total acres, divided into three parcels. There\'s a 5.490 tract with the home, and two separate parcels each consisting of 3.255 +/- acres. Sellers have brought approximately 800 loads of dirt in to raise & level the property. There are approximately 60 live oaks located on the property, most on the border of property(this does not include trees in the creek area) creek area(pine, hickory, oaks, magnolia, pecan, willow, ash, cedar). There\'s also an RV hook-up on property. Circular drive in front of the darling home. Home was built in 2012, built with 2x6 exterior walls, metal roof. Well-built farmhouse has 2 bedrooms, 1 bath & a huge upstairs game room. Gorgeous crown molding, wood & tile flooring, carpet in bedrooms & game room, large open living area situated off kitchen. Kitchen boasts custom cabinets, granite countertops, stainless appliances, & oversized sink.' ,`Acres` = '12' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 1-3 KELLEY ESTATES MINOR PLAT' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '522720' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kelley Estates Minor Plat' ,`TaxAmount` = '3515' ,`TaxRate` = '1.7058' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702109' WHERE `Matrix_Unique_ID` = '211726325' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T12:57:42.937' ,`MLSNumber` = '48522361' ,`ListAgentFullName` = 'Scott Laird' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.273885' ,`Longitude` = '-94.890178' ,`PhotoCount` = '20' ,`PostalCode` = '77327' ,`RoomCount` = '7' ,`ListPrice` = '254990.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 2309' ,`StreetNumber` = '1000' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1568' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'RARE FIND on 1 ACRE UNRESTRICTED LOT!!! Enjoy peaceful country living with easy access to Hwy 105, US 59, and just a short distance from Grand Parkway. This 3 bed, 2 bath home features an OPEN plan w/ kitchen/dining combo, kitchen w/ 42\" cabinetry featuring hardware, stainless steel appliances, concrete countertops, and breakfast bar opening to family room. Neutral paint colors throughout, high ceilings, tile flooring, and rich laminate wood flooring in family room and all bedrooms. Private primary retreat w/ tub/shower combo & spacious guest rooms. Relaxing front porch area and HUGE YARD space with plenty of mature trees. Private water well, septic, and propane. SUPER LOW TAXES and NO HOA. THIS WON\'T LAST LONG!!!!' ,`Acres` = '1' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '000150 BBB&C, TRACT 52, ACRES 1.0' ,`LotDesciption` = 'Corner' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '102 - Tarkington' ,`SchoolElementary` = 'TARKINGTON PRIMARY SCHOOL' ,`SchoolHigh` = 'TARKINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'TARKINGTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bbb&C' ,`TaxAmount` = '2721' ,`TaxRate` = '1.5309' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702109' WHERE `Matrix_Unique_ID` = '211729820' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T12:52:14.783' ,`MLSNumber` = '68989510' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.314848' ,`Longitude` = '-96.898339' ,`PhotoCount` = '9' ,`PostalCode` = '76661' ,`RoomCount` = '3' ,`ListPrice` = '76900.00' ,`Status` = 'Active' ,`StreetName` = 'Ward' ,`StreetNumber` = '811' ,`StreetSuffix` = 'Street' ,`City` = 'Marlin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1984' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Single-family home located in a quiet neighborhood. Enjoy relaxing outside surrounded by trees and the sound of birds chirping. This property comes with a huge backyard for outdoor activities. It has easy access to HWY 77 plus short drives to places like Belton Lake, Dr. Pepper Museum, and many more. It is zoned in Marlin ISD! Begin enjoying the countryside and call this place your own home. Give us a call for more information!' ,`Acres` = '0.74' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'S3720 NW ORIGINAL BLK OL 69 LOT 3-4 .74 ACRES' ,`LotDesciption` = 'Cleared' ,`LotSize` = '32234' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '199 - Marlin' ,`SchoolElementary` = 'MARLIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MARLIN HIGH SCHOOL' ,`SchoolMiddle` = 'MARLIN MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Nw Original' ,`TaxAmount` = '1713' ,`TaxRate` = '2.8333' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1924' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702110' WHERE `Matrix_Unique_ID` = '211730259' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T13:22:33.487' ,`MLSNumber` = '49411049' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.703590' ,`Longitude` = '-95.331726' ,`PhotoCount` = '15' ,`PostalCode` = '77021' ,`RoomCount` = '4' ,`ListPrice` = '229999.00' ,`Status` = 'Active' ,`StreetName` = 'Nassau' ,`StreetNumber` = '5131' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1560' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '4 bedroom, 2 bathroom home near downtown Houston! This home consists of wood floors in select areas, ceramic tile in the bathroom, and a great sized backyard for your children to play in or your furry friends! A great location that offers you quick access to I-45 South and destinations like the Museum District and Texas Medical Center. It features new interior paint and cosmetic repairs. Give us a call today for more information!' ,`Acres` = '0.1667' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 36 BLK 6 MACGREGOR PLACE SEC 2' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7260' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PECK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Macgregor Place Sec 02' ,`TaxAmount` = '2967' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702110' WHERE `Matrix_Unique_ID` = '211731463' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T13:32:44.460' ,`MLSNumber` = '16298012' ,`ListAgentFullName` = 'Aimee Thomas' ,`ListOfficeName` = 'Full Circle Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.025391' ,`Longitude` = '-95.156711' ,`PhotoCount` = '35' ,`PostalCode` = '77346' ,`RoomCount` = '11' ,`ListPrice` = '610000.00' ,`Status` = 'Active' ,`StreetName` = 'Atascocita Point' ,`StreetNumber` = '21027' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2664' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Look no further! A Gorgeous 2 story home backing to water with covered patio on the the first floor and a perfect balcony retreat on the second floor. This home has so much to offer! Soaring ceilings, spacious rooms, tons of natural light! Enjoy the sunroom with views of lush landscaping and a beautiful fountain. Tons of upgrades throughout the home. Granite countertops in kitchen, with a HUGE pantry, high-end stainless appliances, coffee bar, and breakfast bar. Spacious Primary bedroom with water views. Travertine in the Primary bath with two huge custom closets!! Office can be a fourth bedroom. Along with the two bedrooms, bath, and balcony retreat upstairs there is a nice sized walk in attic! * Hidden Storage Closet on first floor * Schedule your tour today!' ,`Acres` = '0.5535' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TR 10 BLK 1 KINGS RIVER ESTATES SEC 3' ,`LotDesciption` = 'In Golf Course Community,Waterfront' ,`LotSize` = '24111' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'PINEFOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kings River Estates Sec 03' ,`TaxAmount` = '7978' ,`TaxRate` = '2.216' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663702110' WHERE `Matrix_Unique_ID` = '211731577' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T13:40:14.210' ,`MLSNumber` = '4665266' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.042554' ,`Longitude` = '-94.881026' ,`PhotoCount` = '6' ,`PostalCode` = '77535' ,`RoomCount` = '8' ,`ListPrice` = '315190.00' ,`Status` = 'Active' ,`StreetName` = 'Young' ,`StreetNumber` = '501' ,`StreetSuffix` = 'Street' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1616' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to the beautiful 1 Story, The Leeds Floor Plan, 3 Bedrooms, 2 Baths, with a 2 Car Garage. Open concept living with the spacious Family Room open to the Kitchen with the option of a Study or 4th Bedroom. You will love the Kitchen with lots of cabinets, stainless steel appliances, and even a USB outlet. Don\'t miss all the recessed lighting throughout the home. Vinyl and Carpet throughout. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Programmable Thermostat, PEX Hot & Cold Water Lines, Radiant Barrier, Rheem® Whole House Tankless Gas Water Heater, and Vinyl Double Pane Low E Windows that open to the inside of the home for cleaning. Located in the quaint city of Dayton, TX just east of Kingwood in Liberty County. Minutes from historic Downtown Dayton and convenient access to US-90 and FM-1960 providing nearby dining and shopping opportunities. Dayton ISD.' ,`Acres` = '' ,`Area` = '52' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'na' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'KIMMIE M. BROWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Brookstone' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702110' WHERE `Matrix_Unique_ID` = '211733039' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T13:56:19.850' ,`MLSNumber` = '95330082' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.014323' ,`Longitude` = '-95.414597' ,`PhotoCount` = '28' ,`PostalCode` = '77073' ,`RoomCount` = '6' ,`ListPrice` = '269990.00' ,`Status` = 'Active' ,`StreetName` = 'Sovereign Heights' ,`StreetNumber` = '22207' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1849' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Imperial Heights in Houston, TX! The Chestnut floor plan is a charming 2-story home with 3 bedrooms, 2.5 bathrooms, and 2-car garage! This home has it all, including blinds! The first floor offers the perfect entertainment space with a large kitchen island overlooking the family and dining rooms! The gourmet kitchen is sure to please with 42\" cabinets, granite countertops, and stainless steel appliances! The second floor offers a private retreat for all bedrooms! Retreat to the Owner\'s Suite featuring a sizable shower and spacious walk-in closet! Secondary bedrooms have walk-in closets, too! Enjoy the great outdoors with full sod and a covered patio! Don’t miss your opportunity to call Imperial Heights home, schedule a visit today!' ,`Acres` = '' ,`Area` = '12' ,`BuilderName` = 'Legend Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4 Block 4 Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3244' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CAROLEE BOOKER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANDY DEKANEY H S' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Heights' ,`TaxAmount` = '' ,`TaxRate` = '2.73' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702110' WHERE `Matrix_Unique_ID` = '211733199' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T13:45:08.370' ,`MLSNumber` = '7287478' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.042560' ,`Longitude` = '-94.881014' ,`PhotoCount` = '6' ,`PostalCode` = '77535' ,`RoomCount` = '9' ,`ListPrice` = '319799.00' ,`Status` = 'Active' ,`StreetName` = 'Young' ,`StreetNumber` = '503' ,`StreetSuffix` = 'Street' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1892' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this beautiful Elgin floorplan with 2 Story, 4 Bedroom, 2 1/2 Bath, and a 2 Car Garage. Open concept living with the spacious Family Room open to the Kitchen and a Formal Dining Room. You will love the Kitchen with lots of cabinets, breakfast bar, recessed lighting, and stainless steel appliances, and even a USB outlet. All Bedrooms and a Loft area are upstairs where you will find the spacious Master Bedroom with a large walk-in closet and with ensuite bath. Fenced backyard. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Thermostat, Pex Hot & Cold Water Lines, Radiant Barrier, Rheem® Tankless Gas Water Heater, and Vinyl Double Pane Low E Windows that open to the inside of the home for cleaning. Located in the quaint city of Dayton, TX just east of Kingwood in Liberty County. Minutes from historic Downtown Dayton and convenient access to US-90 and FM-1960 providing nearby dining and shopping opportunities. Dayton ISD.' ,`Acres` = '' ,`Area` = '52' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'na' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'KIMMIE M. BROWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Brookstone' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702110' WHERE `Matrix_Unique_ID` = '211733498' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T13:49:43.123' ,`MLSNumber` = '42668037' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.835209' ,`Longitude` = '-95.772265' ,`PhotoCount` = '12' ,`PostalCode` = '77449' ,`RoomCount` = '5' ,`ListPrice` = '453890.00' ,`Status` = 'Active' ,`StreetName` = 'San Leo' ,`StreetNumber` = '4202' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2258' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW MODERN DESIGN! This beautiful one story home on a cul-da-sac street features an open concept with luxurious designer details at every corner! Amazing floor plan!! Abundance of cabinetry space in the kitchen with under cabinet lighting, stainless steel built-in appliances & quartz countertops! The primary bath has quartz counter tops, double sinks and a separate shower and tub!! Smart Home Technology, fully landscaped front & back including sprinkler system. Tankless water heater. Garage door opener. Large covered back patio. 16-SEER A/C and SO MUCH MORE!' ,`Acres` = '0.312' ,`Area` = '25' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 3 (PR YR IMPS 2020*1500420030060) VENTANA LAKES EAS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13589' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BETHKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Ventana Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702111' WHERE `Matrix_Unique_ID` = '211733666' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T13:54:15.663' ,`MLSNumber` = '83039095' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.225898' ,`Longitude` = '-95.702700' ,`PhotoCount` = '6' ,`PostalCode` = '77354' ,`RoomCount` = '7' ,`ListPrice` = '363852.00' ,`Status` = 'Active' ,`StreetName` = 'Bay Warbler' ,`StreetNumber` = '40403' ,`StreetSuffix` = 'Way' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2066' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2 Story Addington Floor Plan with 4 Bedrooms, 2 ½ Baths, with attached 2 car Garage. This home boasts a SPACIOUS OPEN CONCEPT FLOOR PLAN with the Family Room, Kitchen, Breakfast Room, Half Bath, Utility Room, and Owner’s Retreat downstairs. Upstairs you will find a Flex Space with Tech Center, 3 Bedrooms with walk in closets, and another Full Bath. The Kitchen has lots of cabinets, quartz countertops with under the cabinet lighting, stainless steel appliances, and even a USB outlet. COVERED PATIO, SPRINKLER SYSTEM, and fenced backyard. COST AND ENERGY EFFICIENT FEATURES: 16 Seer HVAC System, Honeywell Programmable Thermostat, Pex Hot and cold Water Lines, Radiant Barrier, Rheem® Tankless Gas Water Heater, and Vinyl Double Pane Low E Windows that open to the inside of the home for easy cleaning. Located in Magnolia, TX the new master-planned community Audubon will be conveniently located on both sides of FM-1488 near Mill Creek Road, just along the TX-249 Toll Road.' ,`Acres` = '0.1056' ,`Area` = '15' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S221202 - AUDUBON CREEKSIDE NORTH 02A, BLOCK 2, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4601' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Audubon' ,`TaxAmount` = '539' ,`TaxRate` = '3.3087' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702111' WHERE `Matrix_Unique_ID` = '211734114' --> Updated record success