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-11T16:38:47.257' ,`MLSNumber` = '70267930' ,`ListAgentFullName` = 'Barbara Kearns' ,`ListOfficeName` = 'Coldwell Banker Southern Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.083338' ,`Longitude` = '-94.162794' ,`PhotoCount` = '30' ,`PostalCode` = '77706' ,`RoomCount` = '9' ,`ListPrice` = '199000.00' ,`Status` = 'Active' ,`StreetName` = 'Belvedere' ,`StreetNumber` = '465' ,`StreetSuffix` = 'Drive' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1989' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CURB APPEAL GALORE! Darling & quaint home located in the heart of Beaumont. This cutie is tucked away on a very large lot & will not last long. Equipped with 2 living areas & a spacious sunroom. The 2-car garage has extra storage & a ton of cabinet space making it a handyman\'s dream. Step outdoors to your HUGE backyard that includes a storage building with a ramp. Don\'t miss your chance to call this place your home!' ,`Acres` = '0.74' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'BELVEDERE S25\' L5 L6' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'CURTIS ELEMENTARY SCHOOL (BEAUMONT)' ,`SchoolHigh` = 'WEST BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL (BEAUMONT)' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Belvedere' ,`TaxAmount` = '3379' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697193' WHERE `Matrix_Unique_ID` = '204985076' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T17:37:26.217' ,`MLSNumber` = '4321443' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.436220' ,`Longitude` = '-95.461212' ,`PhotoCount` = '7' ,`PostalCode` = '77583' ,`RoomCount` = '7' ,`ListPrice` = '388200.00' ,`Status` = 'Active' ,`StreetName` = 'Scrub Oak' ,`StreetNumber` = '10506' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2377' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous Colina Home has it all! Offering 4bedrooms, 2.5bathrooms, 3 car garage, Study and Huge Game Room. Spacious Living/Dining area with tall ceilings. The kitchen features breakfast bar for those quick meals in the morning, 42\" cabinetry,& spacious walk in pantry. This home sits on a HUGE Cul-De-Sac lot and the covered back patio is great for grilling and family fun. Rosharon\'s best communities offering everything a family friendly community would want + amenities located in Sterling Lakes, with a spashpad, fitness center,Basketball Court, Lakes & Parks. Crystal Lagoon coming soon in Sierra Vista, Close to Pearland, Alvin,Manvel, Lake Jackson,30 minutes from Downtown Houston. SHOP AND WORK IN THE CITY AND COME HOME TO A QUIET PEACEFUL COMMUNITY @ SIERRA VISTA! Photos are representative ONLY.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 5 Blk 1 Sec 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7915' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista West' ,`TaxAmount` = '' ,`TaxRate` = '3.6' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697193' WHERE `Matrix_Unique_ID` = '207504561' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T17:30:17.480' ,`MLSNumber` = '21291199' ,`ListAgentFullName` = 'Ron Cyriac' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.578512' ,`Longitude` = '-95.600517' ,`PhotoCount` = '19' ,`PostalCode` = '77479' ,`RoomCount` = '7' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Hidden Creek' ,`StreetNumber` = '3326' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1843' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investors only - Tenants in place until July 1, 2023. Welcome to the charming and bright double story 3 bed 2.5 bath plan that is completely upgraded and updated in 2021. Quiet neighborhood with good school district. Remodeled kitchen with granite countertop, oven, microwave, and dishwasher along with new laminate floors in the family room, dining, and kitchen. Large kitchen with walk-in pantry, large master bedroom with a large walk-in closet and upgraded master bath. New Carpets replaced in 2021. There is also an extra room that can be converted to a bedroom in the 1st floor. Close to Mesquite park and trails. Easy access to HW-6 and US-59 for quick shopping, dining, and entertainment options. Zones to highly rated Fort Bend ISD school including Clements High School. Only 5 min walk to elementary school. Very low taxes and HOA.' ,`Acres` = '0.1416' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SETTLERS PARK SEC 2, BLOCK 13, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6169' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '498' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SETTLERS WAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Settlers Park Sec 2' ,`TaxAmount` = '5124' ,`TaxRate` = '2.1584' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697193' WHERE `Matrix_Unique_ID` = '207504959' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T17:01:32.293' ,`MLSNumber` = '4940920' ,`ListAgentFullName` = 'Roger Pool' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.882657' ,`Longitude` = '-95.527530' ,`PhotoCount` = '48' ,`PostalCode` = '77040' ,`RoomCount` = '21' ,`ListPrice` = '850000.00' ,`Status` = 'Active' ,`StreetName` = 'Congo' ,`StreetNumber` = '8710' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '5711' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This property is a rare find! UNRESTRICTED, no zoning, one acre property. PERFECT for live/workspace families or for expanding your business in this beautiful well secured compound. Great investment property to lease for business or residential. Perfect location for access to Houston, centered between beltway 8 and Hwy 290 just south of the racetrack. It features a great upgraded 2,455 sf., 3 bdrm., 2 bath primary home and several additional buildings including a multi-functional 25\' X 100\' steel workshop/storage building, two separate guest quarters with private baths (820 sf.), a 2 story partially unfinished office building with offices/additional living quarters $1,560 sf., an exercise/storage building (400 sf.), a 252 sf. tool shed, a 20\' X 30 (600 sf.) covered pavilion area, lots of patio space, an in-ground swimming pool, with giant live oak trees throughout the property with a 8\'-10\' wall or wrought iron fence surrounding the entire acre. Business Opportunity with LOW TAXES!' ,`Acres` = '1' ,`Area` = '11' ,`BuilderName` = 'NA' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 9F-1 & 9S-1 ABST 831 J WAUGH' ,`LotDesciption` = 'Other' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'GLEASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JERSEY VILLAGE HIGH SCHOOL' ,`SchoolMiddle` = 'COOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'NA' ,`TaxAmount` = '8663' ,`TaxRate` = '2.127' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697193' WHERE `Matrix_Unique_ID` = '208834106' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T17:33:06.593' ,`MLSNumber` = '14415150' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.437789' ,`Longitude` = '-95.434424' ,`PhotoCount` = '10' ,`PostalCode` = '77583' ,`RoomCount` = '8' ,`ListPrice` = '493620.00' ,`Status` = 'Active' ,`StreetName` = 'Amador Peak' ,`StreetNumber` = '10611' ,`StreetSuffix` = '' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2922' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous Colina Home has Amazing offerings! When you walk through the front door you will feel right at home. This home offers 4bedrooms,3.5bathrooms,dining & 3car garage! The living room, kitchen,area are open to each other with high ceilings. The kitchen features oversized island with seating,42\" cabinetry,& spacious walk in pantry. The primary bedroom is tucked away in the back of home with a spacious en suite bathroom & walk in closet. There is a Huge covered back patio great for grilling and fun. Rosharon\'s best communities offering everything a family friendly community want + amenities located in Sterling Lakes, with a spashpad, fitness center,Basketball Court, Lakes & Parks. Crystal Lagoon coming soon! Close to Pearland, Alvin,Manvel, Lake Jackson,30 minutes from Downtown Houston. SHOP AND WORK IN THE CITY AND\r\nCOME HOME TO A QUIET PEACEFUL COMMUNITY @ SIERRA VISTA!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Block 1 Sec 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697193' WHERE `Matrix_Unique_ID` = '209097203' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T16:17:07.567' ,`MLSNumber` = '13774390' ,`ListAgentFullName` = 'Jennifer Auer' ,`ListOfficeName` = 'Keller Williams Hou Preferred' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.192950' ,`Longitude` = '-95.343460' ,`PhotoCount` = '42' ,`PostalCode` = '77515' ,`RoomCount` = '3' ,`ListPrice` = '570000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 210' ,`StreetNumber` = '18120' ,`StreetSuffix` = '' ,`City` = 'Angleton' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2227' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Paradise right in front of your eyes! Modern home with all the luxuries of the city right at your fingertips. This beautiful quiet country location is in a prime location. Plenty of room to do whatever you like. Shade trees all over this beautiful property. Separate MIL quarters with covered parking for all your guest privacy needs. Screened in patio and swimming pool with hot tub for your relaxing evenings and entertaining weekends. 2 stall barn for all your farming or workshop needs. Another workshop/changing room attached to the pool area. This is one you wont want to miss. Call today to schedule your private viewing before it\'s gone!!' ,`Acres` = '3.84' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Probate,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Danbury' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0023 S F AUSTIN, BLOCK 22, TRACT 747D-747F, ACRES 3.840' ,`LotDesciption` = 'Other' ,`LotSize` = '167270' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'CENTRAL ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'S F Austin' ,`TaxAmount` = '7557' ,`TaxRate` = '2.0772' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697194' WHERE `Matrix_Unique_ID` = '209198496' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T17:26:41.613' ,`MLSNumber` = '65220697' ,`ListAgentFullName` = 'Shireen Hadi' ,`ListOfficeName` = 'Douglas Elliman Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.785887' ,`Longitude` = '-95.372255' ,`PhotoCount` = '21' ,`PostalCode` = '77009' ,`RoomCount` = '5' ,`ListPrice` = '465000.00' ,`Status` = 'Active' ,`StreetName` = 'Houston' ,`StreetNumber` = '3011' ,`StreetSuffix` = 'Avenue' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2402' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location! Location! Location! This gorgeous townhouse is in a small gated community within walking distance from several bars and restaurants the White Oak hiking trail and Uncle Bean\'s coffee just across the street. Quick bike ride to White Oak restaurants, bars, parks, and coffee shops. Zoned to one of the best elementary schools in Houston, Travis Elementary. Book your showing today! NO FLOODING EVER! (Please see images of empty bedrooms with updated carpet).' ,`Acres` = '0.0362' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 JABRI OAKS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1575' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Jabri Oaks' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697194' WHERE `Matrix_Unique_ID` = '209294777' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T17:34:22.953' ,`MLSNumber` = '65793563' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.071689' ,`Longitude` = '-95.617353' ,`PhotoCount` = '23' ,`PostalCode` = '77375' ,`RoomCount` = '4' ,`ListPrice` = '423740.00' ,`Status` = 'Active' ,`StreetName` = 'Bristlecone' ,`StreetNumber` = '2230' ,`StreetSuffix` = 'Circle' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2425' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready December 2022! Step your family\'s game nights up in the Pioneer\'s impressive second floor game room. Linen cabinets with white/grey granite countertops, brown grey EVP flooring with multi-tone carpet in our Elemental package. Whether you’re headed to work or for a night out, Cherry Pines is just minutes away from premier retail, restaurants, and employment centers. Send the kids to school in the sought-after Tomball school district and enjoy weekends at the future pool and playground. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '14' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0350 Plan L470C' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TOMBALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cherry Pines' ,`TaxAmount` = '' ,`TaxRate` = '2.5' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697194' WHERE `Matrix_Unique_ID` = '210156506' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T16:19:23.533' ,`MLSNumber` = '46306005' ,`ListAgentFullName` = 'Jon Skeele' ,`ListOfficeName` = 'Bayway Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.456773' ,`Longitude` = '-95.060117' ,`PhotoCount` = '6' ,`PostalCode` = '77539' ,`RoomCount` = '4' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Kristen' ,`StreetNumber` = '1909' ,`StreetSuffix` = 'Drive' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1778' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful open concept home has 3 bedrooms and 2 full baths. A inviting kitchen that includes a large island. You will have 1778 sq ft of inclosed space under the home for cars and storage. Enjoy your 2 covered patios. Walking distance to great restaurants and parks. Close to schools, trails, places of worship, medical facilities and employment. No sales office on site Sales office is located at 341 Bay Oaks La Porte' ,`Acres` = '0.1705' ,`Area` = '33' ,`BuilderName` = 'Bayway Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dickinson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 19 BLK 2 PEACOCK ISLES SUB (2021) ABST 19' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7427' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '980' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'CALDER ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Peacock Isles' ,`TaxAmount` = '234' ,`TaxRate` = '2.5214' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697194' WHERE `Matrix_Unique_ID` = '210324063' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T17:10:50.040' ,`MLSNumber` = '84314072' ,`ListAgentFullName` = 'Claudette Callebs' ,`ListOfficeName` = 'Taylor Real Estate Group, Inc.' ,`SellingAgentFullName` = 'Atila Arana' ,`SellingOfficeName` = 'Realty Associates' ,`Latitude` = '29.625764' ,`Longitude` = '-95.641247' ,`PhotoCount` = '46' ,`PostalCode` = '77498' ,`RoomCount` = '10' ,`ListPrice` = '775000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Silent Manor' ,`StreetNumber` = '91' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3011' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Outstanding 1.5 story home with glorious views of community lake. Location provides access to top-rated Fort Bend ISD, trails, parks, shops, freeways Constellation Feild and much more... Corner lot with decking and enjoyable covered outdoor kitchen. Tile Roof, Wooden Floors, Soaring 14\' High Ceilings, 8\'\' Crown Molding, Luxury Granite Baths, large island Kitchen. This GORGEOUS low maintenance home features an OPEN CONCEPT inside and out. Iron Fence with open views of the lake and neighborhood. COME SEE THIS ABSOLUTE STUNNING PREVIOUS MODEL HOME TODAY! Remarkable design, smart floorplan, featuring an expansive living room that opens beautifully to the island kitchen. High Performance Energy Efficient Features such as high efficiency HVAC with programable thermostats, Sprayed open cell foam, radiant barrier. Amazing laundry room with storage galore, hanging space, cabinets, and utility sink. Professionally built-in closet system in primary closet.' ,`Acres` = '0.2163' ,`Area` = '29' ,`BuilderName` = 'Sitterle homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SILENT MANOR AT IMPERIAL, BLOCK 2, LOT 1' ,`LotDesciption` = 'Corner,Subdivision Lot,Water View' ,`LotSize` = '9423' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '999' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LAKEVIEW ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'KEMPNER HIGH SCHOOL' ,`SchoolMiddle` = 'SUGAR LAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Mediterranean,Traditional' ,`Subdivision` = 'Silent Manor At Imperial' ,`TaxAmount` = '15353' ,`TaxRate` = '3.1094' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697194' WHERE `Matrix_Unique_ID` = '210493323' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T16:40:41.773' ,`MLSNumber` = '19164771' ,`ListAgentFullName` = 'Sandra Tsui' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.009507' ,`Longitude` = '-95.438139' ,`PhotoCount` = '10' ,`PostalCode` = '77090' ,`RoomCount` = '6' ,`ListPrice` = '269000.00' ,`Status` = 'Active' ,`StreetName` = 'Deveron' ,`StreetNumber` = '715' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1713' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This one story home has excellent floor plan with 3 good size bedrooms, formal dining room and family room. Kitchen is spacious with tons of cabinets, plenty of counter space, breakfast area. Tenants occupied, sale as is. Don\'t miss this great investment opportunity.' ,`Acres` = '0.0911' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 2 ELLA CROSSING SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3967' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '470' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'BAMMEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'BAMMEL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ella Xing Sec 1' ,`TaxAmount` = '4309' ,`TaxRate` = '2.7542' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697194' WHERE `Matrix_Unique_ID` = '210501983' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T16:06:39.043' ,`MLSNumber` = '77413346' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.071725' ,`Longitude` = '-95.616333' ,`PhotoCount` = '24' ,`PostalCode` = '77375' ,`RoomCount` = '6' ,`ListPrice` = '409965.00' ,`Status` = 'Active' ,`StreetName` = 'Everpine' ,`StreetNumber` = '13031' ,`StreetSuffix` = 'Trail' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2336' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready January 2023! Unwind in the private main floor primary suite, complete with a sizeable walk-in closet and bath. Linen cabinets with white/grey granite countertops, brown grey EVP flooring with multi-tone carpet in our Balanced package. Whether you’re headed to work or for a night out, Cherry Pines is just minutes away from premier retail, restaurants, and employment centers. Send the kids to school in the sought-after Tomball school district and enjoy weekends at the future pool and playground. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '14' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0283 Plan 870B' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TOMBALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cherry Pines' ,`TaxAmount` = '' ,`TaxRate` = '2.4' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697194' WHERE `Matrix_Unique_ID` = '210568413' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T16:11:36.560' ,`MLSNumber` = '69729036' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.071996' ,`Longitude` = '-95.616720' ,`PhotoCount` = '24' ,`PostalCode` = '77375' ,`RoomCount` = '6' ,`ListPrice` = '411680.00' ,`Status` = 'Active' ,`StreetName` = 'Everpine' ,`StreetNumber` = '13118' ,`StreetSuffix` = 'Trail' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2585' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready January 2023! Skip your commute and work from home in the quiet main level flex space. Slate cabinets with cotton white quartz countertops, cool grey EVP flooring and multi-tone tweed carpet in our Elemental package. Whether you’re headed to work or for a night out, Cherry Pines is just minutes away from premier retail, restaurants, and employment centers. Send the kids to school in the sought-after Tomball school district and enjoy weekends at the future pool and playground. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '14' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0355 Plan 880C' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TOMBALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cherry Pines' ,`TaxAmount` = '' ,`TaxRate` = '2.46' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697195' WHERE `Matrix_Unique_ID` = '210576630' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T17:41:35.387' ,`MLSNumber` = '85472591' ,`ListAgentFullName` = 'Raul Limas' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.483946' ,`Longitude` = '-95.025905' ,`PhotoCount` = '14' ,`PostalCode` = '77539' ,`RoomCount` = '10' ,`ListPrice` = '995000.00' ,`Status` = 'Active' ,`StreetName` = 'Windmill' ,`StreetNumber` = '5704' ,`StreetSuffix` = 'Lane' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2914' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A unique opportunity to live the one acre plus country lifestyle. Beautiful custom craftsman home with a private pond. Will have a 14\' tall garage door able to fit all your toys and RV. Plumbed for outdoor kitchen. Covered balcony and patio. Builder upgrades and options are available. Construction start date TBD. THE PICTURES POSTED ARE EXAMPLES ONLY OF THE PLANNED BUILD AND NOT THE ACUTAL HOME.' ,`Acres` = '1.0176' ,`Area` = '33' ,`BuilderName` = 'Mitch Mansions' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Dickinson' ,`HeatSystem` = 'Central Gas,Propane' ,`HOAMandatory` = '0' ,`Legal` = 'WINDMILL MEADOWS (2018) ABST 155, BLOCK 1, LOT 2, ACRES 1.01' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '44327' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'SAN LEON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'DUNBAR MIDDLE SCHOOL (DICKINSON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Craftsman' ,`Subdivision` = 'Windmill Meadows' ,`TaxAmount` = '2233' ,`TaxRate` = '2.0042' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697195' WHERE `Matrix_Unique_ID` = '210664911' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T16:50:20.453' ,`MLSNumber` = '72338258' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.073537' ,`Longitude` = '-95.617568' ,`PhotoCount` = '23' ,`PostalCode` = '77375' ,`RoomCount` = '6' ,`ListPrice` = '419430.00' ,`Status` = 'Active' ,`StreetName` = 'Bristlecone' ,`StreetNumber` = '2210' ,`StreetSuffix` = 'Circle' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2585' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready January 2023! Open main level has effortless flow between the kitchen, dining and family rooms. Upstairs game room and flex space. Whether you’re headed to work or for a night out, Cherry Pines is just minutes away from premier retail, restaurants, and employment centers. Send the kids to school in the sought-after Tomball school district and enjoy weekends at the future pool and playground. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '14' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0345 Plan 880C' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TOMBALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cherry Pines' ,`TaxAmount` = '' ,`TaxRate` = '2.46' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697195' WHERE `Matrix_Unique_ID` = '210774204' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T17:18:20.977' ,`MLSNumber` = '57986757' ,`ListAgentFullName` = 'Jonathan Williamson' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.767532' ,`Longitude` = '-95.334539' ,`PhotoCount` = '32' ,`PostalCode` = '77020' ,`RoomCount` = '6' ,`ListPrice` = '429000.00' ,`Status` = 'Active' ,`StreetName` = 'Cage' ,`StreetNumber` = '608' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2168' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Blocks from the hottest new multi-use development on the East Side, the East River Project. This home has multiple balconies, a 2-car garage with finished walls, and extra storage space. Abundant street parking. Current short-term rental inside a 3-home gated enclave. All three homes are also for sale as an income-producing investment.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Refuge' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 BLK 1 CAGE STREET COURT' ,`LotDesciption` = 'Patio Lot,Subdivision Lot' ,`LotSize` = '1833' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRUCE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Cage Street Court' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697195' WHERE `Matrix_Unique_ID` = '211012518' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T17:59:52.627' ,`MLSNumber` = '63308350' ,`ListAgentFullName` = 'Keith Robertson' ,`ListOfficeName` = 'Top Guns Realty on Lake Conroe' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.294539' ,`Longitude` = '-95.554739' ,`PhotoCount` = '50' ,`PostalCode` = '77316' ,`RoomCount` = '9' ,`ListPrice` = '548888.00' ,`Status` = 'Active' ,`StreetName` = 'Sundance Peak' ,`StreetNumber` = '305' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2598' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Immaculate stunner built by Perry Homes with 1 year remaining on the builder warranty. 4 bed, 3 1/2 baths, office, gameroom, 2-car garage, and covered back patio. The kitchen is open to the living and dining room creating a seamless space for social gatherings. The kitchen features a large island with a breakfast bar, a walk-in pantry, gas cooktop, under cabinet lighting, recessed lighting, herringbone backsplash, and beautiful engineered stone countertops. The dining and living room is illuminated with natural light coming through the wall of windows or the comforting glow from the fireplace. The primary bath features double vanities, a separate shower, a soaking tub, and a deep walk-in closet. The home sits on a sizable corner lot with room to add a custom-designed pool and spa, a full outdoor kitchen, and add some lush landscaping to produce your very own backyard oasis. Woodforest amenities include parks, playfields, walking trails, splash pad, pool, and more! Zoned to Conroe ISD.' ,`Acres` = '0.2065' ,`Area` = '39' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S965277 - WOODFOREST 77, BLOCK 1, LOT 10' ,`LotDesciption` = 'Corner,In Golf Course Community,Subdivision Lot' ,`LotSize` = '8996' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`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` = '1072' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697195' WHERE `Matrix_Unique_ID` = '211104794' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T16:32:30.170' ,`MLSNumber` = '49553275' ,`ListAgentFullName` = 'Khanh Tran' ,`ListOfficeName` = 'Loft Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.552618' ,`Longitude` = '-95.303743' ,`PhotoCount` = '24' ,`PostalCode` = '77584' ,`RoomCount` = '3' ,`ListPrice` = '269000.00' ,`Status` = 'Active' ,`StreetName` = 'Neches River' ,`StreetNumber` = '3010' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1496' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a beautiful country home you have been waiting for. This lovely home is 3 bedrooms and 2 bath. The property is completely updated with updated granite kitchen, modernized baths, new tile flooring, carpet, roof, fresh paint, water heater and new stainless steel appliances with MANY MORE. This property is a must see. Please schedule your appointment today.' ,`Acres` = '0.2121' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'CORRIGAN (PEARLAND), BLOCK 9, LOT 1 SEC 4' ,`LotDesciption` = 'Corner' ,`LotSize` = '9239' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'H C CARLESTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH SOUTH' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Corrigan Pearland' ,`TaxAmount` = '2718' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697195' WHERE `Matrix_Unique_ID` = '211130078' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T17:42:34.977' ,`MLSNumber` = '26704520' ,`ListAgentFullName` = 'Famen Wolf' ,`ListOfficeName` = 'Wolf Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.135281' ,`Longitude` = '-95.181808' ,`PhotoCount` = '14' ,`PostalCode` = '77357' ,`RoomCount` = '5' ,`ListPrice` = '238900.00' ,`Status` = 'Active' ,`StreetName` = 'Twin Oaks' ,`StreetNumber` = '25085' ,`StreetSuffix` = 'Drive' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1475' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Clayton Home with 3 bedrooms and two baths. Includes 60x20 concrete driveway, 19x8 covered front patio, shingled roof, concrete runners, built to FHA guidelines, landscaping package, upgraded back splash, LED recessed lighting through home, double pain windows, energy efficient water heater. Home will also have a 10x10 shed in the back. Great location with a country feel yet not too far off the beaten path. Minutes from the Grand Pkwy. Clayton Homes offers a new home warranty as well. Schedule your showing today!' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Clayton Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 7 WINDWOOD ESTATES 04' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'OAKLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Twin Village Estates & Windwood Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697195' WHERE `Matrix_Unique_ID` = '211233712' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T16:15:38.133' ,`MLSNumber` = '24107987' ,`ListAgentFullName` = 'Dante Cruz' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.755998' ,`Longitude` = '-96.027626' ,`PhotoCount` = '50' ,`PostalCode` = '77423' ,`RoomCount` = '6' ,`ListPrice` = '1400000.00' ,`Status` = 'Active' ,`StreetName` = 'Siedel' ,`StreetNumber` = '1347' ,`StreetSuffix` = 'Road' ,`City` = 'Brookshire' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '6' ,`SqFtTotal` = '7900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this beautiful home fully remodeled tons of upgrades !!' ,`Acres` = '4' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABS A302000 A-20 W COOPER TRACT 230-3 ACRES 4.17' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '44 - Royal' ,`SchoolElementary` = 'ROYAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ROYAL HIGH SCHOOL' ,`SchoolMiddle` = 'ROYAL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'English,Other Style,Ranch,Traditional' ,`Subdivision` = 'n/a' ,`TaxAmount` = '9954' ,`TaxRate` = '2.0226' ,`WaterSewer` = 'Well' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663697196' WHERE `Matrix_Unique_ID` = '211233801' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T16:14:10.903' ,`MLSNumber` = '20575758' ,`ListAgentFullName` = 'Karen Malek' ,`ListOfficeName` = 'Best Texas Reliable Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.813546' ,`Longitude` = '-95.044743' ,`PhotoCount` = '27' ,`PostalCode` = '77562' ,`RoomCount` = '2' ,`ListPrice` = '229900.00' ,`Status` = 'Active' ,`StreetName` = 'Edith' ,`StreetNumber` = '128' ,`StreetSuffix` = 'Street' ,`City` = 'Highlands' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '739' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come look at this beauty!!!! This house has been updated and has tons of potential!! Amazing yard size to entertain and more. Covered patio space in the front and side!! Spacious rooms, new paint and more!!Come check it out!!!' ,`Acres` = '0.1928' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'LT 60 PRAIRIE VILLAGE SEC 2 U/R' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'HOPPER/HIGHLANDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Prairie Village 2 Unr' ,`TaxAmount` = '759' ,`TaxRate` = '2.575' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663697196' WHERE `Matrix_Unique_ID` = '211240719' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T16:22:29.340' ,`MLSNumber` = '89603087' ,`ListAgentFullName` = 'Patrick Burbridge' ,`ListOfficeName` = 'CitiQuest Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.851582' ,`Longitude` = '-95.433759' ,`PhotoCount` = '33' ,`PostalCode` = '77091' ,`RoomCount` = '7' ,`ListPrice` = '369900.00' ,`Status` = 'Active' ,`StreetName` = 'Weathersby' ,`StreetNumber` = '5904' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1780' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNDER CONSTRUCTION! MOVE-IN READY by October 2022. Gorgeous new construction by Disama Group. This stunning three-story home offers an open concept floor plan with the living area on the second floor and 3 bedrooms on the third floor. It\'s unique first floor offers a spacious home office/study on the first floor. Upgraded finishes throughout including smart home system, quartz counter tops, stainless-steel appliances, upgraded cabinets with soft close drawers. Enjoy this beautiful home located just minutes away from Downtown Houston, Galleria, City Centre. Easy access to I-45, 610 & 290. \r\nPhotos from another home by Disama Group. LAYOUT, FINISHES AND SELECTION WILL VARY!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Disama Group' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lt 2 Blk 1' ,`LotDesciption` = 'Corner,Patio Lot,Subdivision Lot' ,`LotSize` = '1970' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'ANDERSON ACADEMY' ,`SchoolHigh` = 'CARVER H S FOR APPLIED TECH/ENGINEERING/ARTS' ,`SchoolMiddle` = 'DREW ACADEMY' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland Landing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697196' WHERE `Matrix_Unique_ID` = '211321863' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T16:44:27.327' ,`MLSNumber` = '13000020' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.484370' ,`Longitude` = '-95.463275' ,`PhotoCount` = '6' ,`PostalCode` = '77583' ,`RoomCount` = '7' ,`ListPrice` = '324400.00' ,`Status` = 'Active' ,`StreetName` = 'Escondido' ,`StreetNumber` = '6835' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to Glendale Lakes! This Belle Vue floor plan with elevation B offers 4 spacious Bedrooms and 3.5 Bathrooms. This open design floor plan is ready for May move-in! A modern Kitchen featuring 42’’ shaker Kitchen flat panel cabinetry, Quartz countertops with ceramic tile backsplash, high quality Frigidaire appliances and Kitchen island. Relaxing primary bath with double sinks, ceramic tile surround with tub, and Quartz countertops. Energy efficiency features: 16 SEER carrier AC system with programmable thermostat, 40 gallon gas water heater. Full sod front and back landscape package included, Rear Patio, Brick fronts with stone accents per elevation and many more. If you are looking for a great community with easy access to outstanding shopping, dining, and majors freeways, in one of the best school districts, look no further! Set up your appointment today!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Saratoga Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9 Block 3 Section GL-9 Glendale Lakes' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Glendale Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.14' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697196' WHERE `Matrix_Unique_ID` = '211323923' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T16:38:46.477' ,`MLSNumber` = '8301561' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.221248' ,`Longitude` = '-95.240160' ,`PhotoCount` = '14' ,`PostalCode` = '77357' ,`RoomCount` = '3' ,`ListPrice` = '266990.00' ,`Status` = 'Active' ,`StreetName` = 'Starry Night' ,`StreetNumber` = '21549' ,`StreetSuffix` = '' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1573' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FANTASTIC NEW D. R. HORTON BUILT HOME! Great Open Concept Interior Layout! Lovely Foyer Opens Onto Gourmet Island Kitchen with Corner Walk-In Pantry, Light & Bright Breakfast Area, & Spacious Living Area! Privately Located Primary Suite Offers Great Bath with Large Shower & Walk-In Closet! Indoor Utility Room! Covered Patio Overlooks Wonderful Backyard! Incredible Community with Trails, Rec Center, SplashPad, Pool, AND Elementary School in Subdivision! WOW!' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 22/ Block 1/ Section 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6250' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'TIMBER LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harrington Trails' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697196' WHERE `Matrix_Unique_ID` = '211324079' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T16:44:09.560' ,`MLSNumber` = '14516732' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.482381' ,`Longitude` = '-95.467254' ,`PhotoCount` = '7' ,`PostalCode` = '77583' ,`RoomCount` = '7' ,`ListPrice` = '324400.00' ,`Status` = 'Active' ,`StreetName` = 'Marvista' ,`StreetNumber` = '1238' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to Glendale Lakes! This Belle Vue floor plan offers 4 spacious Bedrooms and 3.5 Bathrooms. This open design floor plan is ready for May move-in! A modern Kitchen featuring 42’’ shaker Kitchen flat panel cabinetry, Quartz countertops with ceramic tile backsplash, high quality Frigidaire appliances and Kitchen island. This floor plan only has a garden tub in the primary bath. Energy efficiency features: 16 SEER carrier AC system with programmable thermostat, 40 gallon gas water heater. Full sod front and back landscape package included, Rear Patio, Brick fronts with stone accents per elevation and many more. If you are looking for a great community with easy access to outstanding shopping, dining, and majors freeways, in one of the best school districts, look no further! Set up your appointment today!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Saratoga Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 Block 2 Section GL-9 Glendale Lakes' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5507' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Glendale Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.14' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697196' WHERE `Matrix_Unique_ID` = '211324088' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T16:41:52.283' ,`MLSNumber` = '95051178' ,`ListAgentFullName` = 'Patrick Burbridge' ,`ListOfficeName` = 'CitiQuest Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.851582' ,`Longitude` = '-95.433759' ,`PhotoCount` = '33' ,`PostalCode` = '77091' ,`RoomCount` = '7' ,`ListPrice` = '372900.00' ,`Status` = 'Active' ,`StreetName` = 'Mansfield' ,`StreetNumber` = '1404' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1652' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNDER CONSTRUCTION! MOVE-IN READY by October 2022. Gorgeous new construction by Disama Group. This stunning three-story home offers an open concept floor plan with the living area on the second floor and 3 bedrooms on the third floor. It\'s unique first floor offers a spacious home office/study on the first floor. Upgraded finishes throughout including smart home system, quartz counter tops, stainless-steel appliances, upgraded cabinets with soft close drawers. Enjoy this beautiful home located just minutes away from Downtown Houston, Galleria, City Centre. Easy access to I-45, 610 & 290. \r\nPhotos from another home by Disama Group. LAYOUT, FINISHES AND SELECTION WILL VARY!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Disama Group' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lt 4 Blk 1' ,`LotDesciption` = 'Corner,Patio Lot,Subdivision Lot' ,`LotSize` = '2683' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'ANDERSON ACADEMY' ,`SchoolHigh` = 'CARVER H S FOR APPLIED TECH/ENGINEERING/ARTS' ,`SchoolMiddle` = 'DREW ACADEMY' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland Landing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697196' WHERE `Matrix_Unique_ID` = '211324180' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T16:56:36.293' ,`MLSNumber` = '71801818' ,`ListAgentFullName` = 'Patrick Burbridge' ,`ListOfficeName` = 'CitiQuest Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.851582' ,`Longitude` = '-95.433759' ,`PhotoCount` = '33' ,`PostalCode` = '77091' ,`RoomCount` = '7' ,`ListPrice` = '362900.00' ,`Status` = 'Active' ,`StreetName` = 'Mansfield' ,`StreetNumber` = '1406' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1652' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNDER CONSTRUCTION! MOVE-IN READY by October 2022. Gorgeous new construction by Disama Group. This stunning three-story home offers an open concept floor plan with the living area on the second floor and 3 bedrooms on the third floor. It\'s unique first floor offers a spacious home office/study on the first floor. Upgraded finishes throughout including smart home system, quartz counter tops, stainless-steel appliances, upgraded cabinets with soft close drawers. Enjoy this beautiful home located just minutes away from Downtown Houston, Galleria, City Centre. Easy access to I-45, 610 & 290. \r\nPhotos from another home by Disama Group. LAYOUT, FINISHES AND SELECTION WILL VARY!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Disama Group' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lt 3 Blk 1' ,`LotDesciption` = 'Corner,Patio Lot,Subdivision Lot' ,`LotSize` = '1750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'ANDERSON ACADEMY' ,`SchoolHigh` = 'CARVER H S FOR APPLIED TECH/ENGINEERING/ARTS' ,`SchoolMiddle` = 'DREW ACADEMY' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland Landing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697197' WHERE `Matrix_Unique_ID` = '211324718' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T17:01:46.570' ,`MLSNumber` = '25122974' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.652657' ,`Longitude` = '-95.121610' ,`PhotoCount` = '22' ,`PostalCode` = '77505' ,`RoomCount` = '15' ,`ListPrice` = '512346.00' ,`Status` = 'Active' ,`StreetName` = 'Firethorne Ridge' ,`StreetNumber` = '5814' ,`StreetSuffix` = 'Way' ,`City` = 'Pasadena' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2839' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming two-story Walton II home with 4 bedrooms, 3.5 baths and 3 car attached garage. Convenient home office tucked off hall. Elegant dining room with easy access to gourmet kitchen. Beautiful maple cabinets, under cabinet lighting, quartz countertops, farmhouse sink and walk-in pantry in kitchen. Huge walk-in closet, dual vanity sinks, separate tub and shower in owner\'s bath. Upstairs, you\'ll find a versatile activity room and all secondary bedrooms. Bedroom 2 features an en-suite bath. Enjoy your evening relaxing on your cover patio. Offered by: K. Hovnanian Houston Parkway Trails, LLC.' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'K. Hovnanian' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '4/2/5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'JP DABBS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRMONT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkway Trails' ,`TaxAmount` = '' ,`TaxRate` = '2.6198' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697197' WHERE `Matrix_Unique_ID` = '211325694' --> Updated record success