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-25T10:35:13.763' ,`MLSNumber` = '78027774' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Tri Pointe Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.947019' ,`Longitude` = '-95.782915' ,`PhotoCount` = '27' ,`PostalCode` = '77433' ,`RoomCount` = '9' ,`ListPrice` = '830000.00' ,`Status` = 'Active' ,`StreetName` = 'Heartleaf Aster' ,`StreetNumber` = '11110' ,`StreetSuffix` = 'Way' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4173' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this gorgeous Snyder floorplan. This grand home has 5 beds, 4.5 baths, and a 3 bay garage with a static foyer. Walking in you will be charmed with curved elegant stairs, stunning railing, and a high ceiling providing lots of lighting brightening the room. Enjoy the night by cozying up in the fireplace. The gourmet kitchen is conveniently located overlooking the great room and dining room. Enjoy cooking in the gourmet kitchen featuring Silestone Quartz countertops, tile backsplash, stainless steel appliances, and more. Do you enjoy gatherings or having friends over! The gameroom is specialized for entertainment and fun for you and your guests. This Lovely home has everything you need!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Tri Pointe Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PL06/01/26' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10182' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1197' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.52' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702825' WHERE `Matrix_Unique_ID` = '206199442' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T10:34:42.707' ,`MLSNumber` = '64120765' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Tri Pointe Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.947432' ,`Longitude` = '-95.782646' ,`PhotoCount` = '10' ,`PostalCode` = '77433' ,`RoomCount` = '7' ,`ListPrice` = '730000.00' ,`Status` = 'Active' ,`StreetName` = 'Heartleaf Aster' ,`StreetNumber` = '11114' ,`StreetSuffix` = 'Way' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3380' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming Benbrook floorplan featuring 4-bedroom, 4.5 bath, one-story home with a 3-car garage. This open concept layout features a gallery foyer, gameroom, study, casual dining room, spacious family room and covered patio. The primary suite includes two walk-in closets, dual vanities, and a garden tub. Options: extended covered patio, glass sliders at family room with extended covered patio option, glass sliders at gameroom, free standing tub, double entry door, 5 ft garage extension, 1-car garage bay.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Tri Pointe Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PL06/01/27' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1197' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.52' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702825' WHERE `Matrix_Unique_ID` = '206372625' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T11:40:44.533' ,`MLSNumber` = '60259020' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.958844' ,`Longitude` = '-95.488788' ,`PhotoCount` = '28' ,`PostalCode` = '77066' ,`RoomCount` = '6' ,`ListPrice` = '289900.00' ,`Status` = 'Active' ,`StreetName` = 'Mallard Landing' ,`StreetNumber` = '4702' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2607' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.216' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 2 KLEINBROOK SEC 4' ,`LotDesciption` = 'Other' ,`LotSize` = '9409' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KLENK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'WUNDERLICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kleinbrook Sec 4' ,`TaxAmount` = '5948' ,`TaxRate` = '2.9105' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702826' WHERE `Matrix_Unique_ID` = '206388577' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T11:38:42.360' ,`MLSNumber` = '39671779' ,`ListAgentFullName` = 'La Toya Burns' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.913324' ,`Longitude` = '-94.019204' ,`PhotoCount` = '23' ,`PostalCode` = '77640' ,`RoomCount` = '3' ,`ListPrice` = '90000.00' ,`Status` = 'Active' ,`StreetName` = '66th' ,`StreetNumber` = '2451' ,`StreetSuffix` = 'Street' ,`City` = 'Port Arthur' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1092' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOTIVATED SELLER! BRING ALL OFFERS! DOUBLE LOT! Original Victorian designed home with good bones and solid wood construction. This home perched on a quiet street in the Port Acres community can make a great rental or with it\'s connecting lot, it can serve as the perfect canvas to redesign your own home. And BONUS, this home has NEVER FLOODED and has NO HOA or DEED RESTRICTIONS.' ,`Acres` = '0.5399' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = '106.10 X 220 TR 3 LT 10 BLK 1 PORT ACRES' ,`LotDesciption` = 'Other' ,`LotSize` = '23518' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '236 - Port Arthur' ,`SchoolElementary` = '' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (PORT ARTHUR)' ,`SchoolMiddle` = 'LINCOLN MIDDLE SCHOOL (PORT ARTHUR)' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Port Acres' ,`TaxAmount` = '2210' ,`TaxRate` = '3.267' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702826' WHERE `Matrix_Unique_ID` = '206708733' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T11:17:28.640' ,`MLSNumber` = '92004298' ,`ListAgentFullName` = 'Kate Powell' ,`ListOfficeName` = 'Pam Westlake Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.286095' ,`Longitude` = '-95.632027' ,`PhotoCount` = '49' ,`PostalCode` = '77316' ,`RoomCount` = '12' ,`ListPrice` = '879900.00' ,`Status` = 'Active' ,`StreetName` = 'Queen Victoria' ,`StreetNumber` = '15649' ,`StreetSuffix` = 'Court' ,`City` = 'Montgomery' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4319' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely custom home on 2.83 acres in cul-de-sac backing to private farm in coveted Crown Oaks w/room for horses! Beautiful 2-story home has study, formal dining and main floor primary; primary ensuite has walk-ins and modern adjustable lighting mirrors! Giant game room up, wet bar, extra bedrooms-one could be converted to media room. Chef\'s kitchen w/view to back features stainless appliances, gas cooktop, extensive granite counters, oven/microwave, pantry, 18\" tile flooring. Features include: new water heaters 2019, freshly painted, new luxury vinyl flooring; water softener/filtration, crown molding & chair rail, arched doorways, iron balusters, plenty of storage, more! Fantastic extended covered back porch coated with granite grip, for entertaining & sunsets; newly revamped built-in bbq pit nearby. Property is lined with fencing/trees. Garage is oversized, has side door. Located in gated community w/2 lakes, 2 parks, low tax rate, newer MISD schools, close to Lake Conroe. Visit today!' ,`Acres` = '2.84' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'CROWN OAKS 04, BLOCK 1, LOT 15' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Wooded' ,`LotSize` = '123710' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'KEENAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Crown Oaks 04' ,`TaxAmount` = '8995' ,`TaxRate` = '1.825' ,`WaterSewer` = 'Aerobic,Other Water/Sewer,Septic Tank' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702826' WHERE `Matrix_Unique_ID` = '207638052' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T10:33:48.590' ,`MLSNumber` = '56632692' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Tri Pointe Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.947432' ,`Longitude` = '-95.782646' ,`PhotoCount` = '49' ,`PostalCode` = '77433' ,`RoomCount` = '7' ,`ListPrice` = '840000.00' ,`Status` = 'Active' ,`StreetName` = 'White Caterpillar' ,`StreetNumber` = '11011' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3783' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Carignan floorplan - An open concept, one-story home with 4 bedrooms, 3.5 baths and a 4-car garage. Featuring a gorgeous, incredibly livable layout with loads of natural light, you’ll find a large rectangular kitchen island, casual dining area, and spacious family room with a fireplace. Family-friendly spaces like a gameroom for gathering or a mud room for shoes and backpacks make this home perfect for kids of all ages. Or retreat to a large primary suite with abundant closet space and separate vanities in the bath. Choose from plan options such as sliders at family room, sliders at casual dining, sliders at gameroom, coffered ceiling at family room, beams at primary suite, groin vault ceiling at primary suite, 2nd primary suite from garage and gameroom, media room from garage, drop-in tub, bath 4, 2-car garage.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Tri Pointe Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PL07/02/05' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11113' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1197' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.52' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702826' WHERE `Matrix_Unique_ID` = '208457493' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T10:43:37.397' ,`MLSNumber` = '16099022' ,`ListAgentFullName` = 'Dayna Simmons' ,`ListOfficeName` = 'Dayna Simmons Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.106075' ,`Longitude` = '-94.158835' ,`PhotoCount` = '34' ,`PostalCode` = '77706' ,`RoomCount` = '14' ,`ListPrice` = '895000.00' ,`Status` = 'Active' ,`StreetName` = 'Oakleigh Blvd' ,`StreetNumber` = '19' ,`StreetSuffix` = '' ,`City` = 'Beaumont' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '5962' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stately beauty in the heart of Beaumont\'s West End! Rebuilt from the ground up in 2012 with all the extras, upgrades, and amenities to fit your fancy. Comfort and elegance found in each of the spacious 5 bedrooms. All bathrooms include linen closets to stash warm towels &toiletries for guests. Full house generator so you never have to lose the chance to cook on the upscale Viking cooktop or use the golf simulator/theatre and workout rooms. Cool down during these crisp SETX Summer days in your backyard private oasis complete with sparkling pool, hot tub, and an extended 2nd floor over back patio for added weather protection. Enjoy the peaceful sounds of the enchanting waterfall. Low traffic to keep the quiet prevailing. Live your life of luxury here!' ,`Acres` = '0.49' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'OAKLEIGH LT 19' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '21735' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '315' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'REGINAL-HOWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WEST BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL (BEAUMONT)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oakleigh' ,`TaxAmount` = '20578' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702826' WHERE `Matrix_Unique_ID` = '208532093' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T10:59:17.017' ,`MLSNumber` = '86008597' ,`ListAgentFullName` = 'Pamela Gabriel' ,`ListOfficeName` = 'Sand N Sea Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.283323' ,`Longitude` = '-94.816739' ,`PhotoCount` = '4' ,`PostalCode` = '77551' ,`RoomCount` = '9' ,`ListPrice` = '639000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue Q' ,`StreetNumber` = '4712' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1725' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction located in the mid town heart of Galveston known as the Denver Resurvey area. This 3 bedroom, 2 1/2 bath home will have all the modern amenities needed for enjoying your vacation home, permanent residence or vacation rental. It is centrally located along w/being minutes from the beach & other fun entertainment that Galveston has to offer. Come choose your colors, flooring selections, fixtures & more during the early stages of building. This 2 story home will have covered porch & balcony. Kitchen floor plan has large island, quartz counters, tons of cabinets, walk in pantry & breakfast nook. Kitchen opens to dining & living area. Owners suite w/double vanity, large walk in shower, walk in closet along w/private & covered balcony for enjoying morning paper and gulf breezes. Nice private back yard that will be fenced & will have private driveway from alley entrance. Room for garage or garage apartment.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Alta Vista Dev.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Midtown - Galveston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOT 18 BLK 130 DENVER RESURVEY' ,`LotDesciption` = 'Cleared' ,`LotSize` = '3000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric 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` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Denver Resurvey' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702826' WHERE `Matrix_Unique_ID` = '208535962' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T11:57:52.090' ,`MLSNumber` = '95870809' ,`ListAgentFullName` = 'Brad Shumway' ,`ListOfficeName` = 'Pin Drop Real Estate' ,`SellingAgentFullName` = 'Sara Black' ,`SellingOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`Latitude` = '29.773535' ,`Longitude` = '-95.372620' ,`PhotoCount` = '38' ,`PostalCode` = '77007' ,`RoomCount` = '15' ,`ListPrice` = '2750000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Houston' ,`StreetNumber` = '1719' ,`StreetSuffix` = 'Avenue' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '6524' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Hynes Bakery Building, built in 1916 & Landmarked as The E. Gustave Siadous Building, offers opportunity for luxurious urban residential or Flexible commercial. The architectural detail is a striking combination of Mission Revival and Arts and Crafts w/ commercial elements and Art Deco accents added later. Offering four unique spaces: Main Flat- 2 bed + library, great room-kitchen, 2 baths, & stairs to roof for amazing views of sunsets or fireworks. Guest Apt- Large two story w/ open concept living on the 1st floor with 1/2 bath. 2nd floor den and large bedroom and bath, and private garden patio. Shop- Massive open space on 1st floor offers 12’ ceilings and central AC. Studio-One room at the lower front of the property also with central and a full bath. Lot size is 10,000 sqft. The building was built at the Nothern property line maximizing the remaining lot for parking, garden or future development. Zoned to Award-wining Crockett Elementary.' ,`Acres` = '0.2296' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Washington East/Sabine' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 7 & 8 BLK 282 BAKER NSBB' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '10000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Built Up,Composition,Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Baker Nsbb' ,`TaxAmount` = '14686' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702826' WHERE `Matrix_Unique_ID` = '208537333' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T11:26:13.490' ,`MLSNumber` = '51595175' ,`ListAgentFullName` = 'Shahin Naghavi' ,`ListOfficeName` = 'Madison Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.838510' ,`Longitude` = '-95.402648' ,`PhotoCount` = '7' ,`PostalCode` = '77018' ,`RoomCount` = '7' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Woodstar' ,`StreetNumber` = '125' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1751' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*LIMITED PRE-SALES AT THIS ENTRY PRICE FOR MARCH 2023* Welcome to your next home located in the premier residential development of Independence Heights! The development has two floorplans, and this is the largest! This home features first floor kitchen-living-dining and powder bath. First floor has 10-foot ceilings. Kitchen is open to great room featuring large island with breakfast bar seating. Marble-look quartz countertops, subway backsplash, apron front farmhouse sink, brushed gold pull-down faucet, 30-inch gas range and so much more! Primary suite is on the second floor. Primary bath has dual vanities, one with a makeup vanity! Oversized closet with dual areas. Separate water closet. Guest bedrooms have separate walk-in closets and Hollywood bath. Call now for more info and to reserve your lot!\r\nPhase I now pre-selling w/ expected completion March 2023! Visit design center to select finishes and upgrades now!\r\nTo find the site on the maps type 4924 Yale St, Houston, TX 77008.' ,`Acres` = '0.0439' ,`Area` = '9' ,`BuilderName` = 'Elite Townhomes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 1 INDEPENDENCE HEIGHTS HOMES' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '1914' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KENNEDY ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Other Style,Traditional' ,`Subdivision` = 'INDEPENDENCE HEIGHTS HOMES' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702826' WHERE `Matrix_Unique_ID` = '208560582' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T11:21:41.743' ,`MLSNumber` = '1016061' ,`ListAgentFullName` = 'Brandi Cunda' ,`ListOfficeName` = 'Country Pride Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.968465' ,`Longitude` = '-96.658575' ,`PhotoCount` = '7' ,`PostalCode` = '77957' ,`RoomCount` = '3' ,`ListPrice` = '349999.00' ,`Status` = 'Active' ,`StreetName` = 'Apollo' ,`StreetNumber` = '111' ,`StreetSuffix` = 'Drive' ,`City` = 'Edna' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1778' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Step inside this one of a kind home! Featured on 0.88 of an acre, this house has all the upgrades you could want. It offers 3 bedrooms and 2 bathrooms with Porcelain tile throughout the home. From the open kitchen and large living area with a fire place to the large yard, there is plenty of space for the whole family to enjoy. This home is a must see and won\'t last long.' ,`Acres` = '0.88' ,`Area` = '67' ,`BuilderName` = 'KC Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'DUGGER EDNA, LOT 132X100FT 23, ACRES 0.3' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '246 - Edna' ,`SchoolElementary` = 'EDNA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'EDNA HIGH SCHOOL' ,`SchoolMiddle` = 'EDNA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Dugger Edna' ,`TaxAmount` = '131' ,`TaxRate` = '2.1055' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702827' WHERE `Matrix_Unique_ID` = '209140783' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T11:55:19.543' ,`MLSNumber` = '66234550' ,`ListAgentFullName` = 'Jesse Rodriguez' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.275284' ,`Longitude` = '-95.257674' ,`PhotoCount` = '24' ,`PostalCode` = '77577' ,`RoomCount` = '6' ,`ListPrice` = '369999.00' ,`Status` = 'Active' ,`StreetName` = 'Snug Harbor' ,`StreetNumber` = '210' ,`StreetSuffix` = 'Drive' ,`City` = 'Liverpool' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1080' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to 210 Snug Harbor Drive! Are you looking for privacy and space from city living? You\'ve found it here! The mobile home offers 3 bedrooms, 2 bathrooms, and a screened in back porch suitable for outdoor living without mosquitos. This property also includes two other lots for sale, bringing it to 1.447 Acres of unrestricted land! This property also comes with a HUGE 40’x50’ workshop perfect for your outdoor gym, boat/RV storage, mechanic\'s garage, the possibilities are endless! NO FLOODING AND NO HOA!! Come and see this one today!' ,`Acres` = '1.4474' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SNUG HARBOR SEC 2 (A0037 S F AUSTIN) BLK 2 LOT 6-7-8-9-13 S#' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '63050' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'WALT DISNEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'ALVIN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Snug Harbor Sec 2' ,`TaxAmount` = '2702' ,`TaxRate` = '2.2507' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702827' WHERE `Matrix_Unique_ID` = '209846543' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T10:23:46.120' ,`MLSNumber` = '26482724' ,`ListAgentFullName` = 'Dorothy Watts' ,`ListOfficeName` = 'Martindale Real EstateInvestments' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.779962' ,`Longitude` = '-94.425484' ,`PhotoCount` = '42' ,`PostalCode` = '75979' ,`RoomCount` = '10' ,`ListPrice` = '259000.00' ,`Status` = 'Active' ,`StreetName` = 'Temple Street' ,`StreetNumber` = '517' ,`StreetSuffix` = '' ,`City` = 'Woodville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1956' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Beautiful property sits on the corner and has a very large backyard with a gorgeous oak tree. It is fenced and the backyard has plenty of room for playing or for your animals. This home has been remodeled and has a nice big den and also living room with built in shelves and cabinets. The kitchen has a large island for entertaining and the dining area is also spacious. Its an open concept home. The den is a very large room so it can be used for extra living or a gameroom whichever you choose. It has a 2 car covered carport but the driveway can hold extra cars. It has a large gate in the back in case you need to store your boat or atv or motorhome.' ,`Acres` = '0.742' ,`Area` = '48' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tyler County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0657 J. Wheat Block 52, Tract B Acres .742' ,`LotDesciption` = 'Corner' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '253 - Woodville' ,`SchoolElementary` = 'WHEAT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WOODVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'WOODVILLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'n/a' ,`TaxAmount` = '3330' ,`TaxRate` = '2.3293' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702827' WHERE `Matrix_Unique_ID` = '209903009' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T10:37:28.870' ,`MLSNumber` = '37147587' ,`ListAgentFullName` = 'Karen Keating' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.333881' ,`Longitude` = '-95.023061' ,`PhotoCount` = '50' ,`PostalCode` = '77563' ,`RoomCount` = '3' ,`ListPrice` = '1125000.00' ,`Status` = 'Active' ,`StreetName` = 'Redfish' ,`StreetNumber` = '7902' ,`StreetSuffix` = 'Street' ,`City` = 'Hitchcock' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2756' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Waterfront acreage property with fishing pier, oasis pool, stocked pond, and crossed fenced pastures for horses... this estate home has it all! Recently remodeled, this home features an open floor plan with large study/home office, high ceilings, chef\'s kitchen, large dining room, and fantastic upstairs gameroom. The recently remodeled primary bedroom suite has a whirl pool tub and frameless glass freestanding shower. Water views from most rooms and wrap around expansive decks. The waterfront oasis swimming pool is less than two years young and features sunbathing deck and swim up bar area. New roof 2022, tankless water heater, recent interior and exterior paint, updated light fixtures, plumbing fixtures and appliances. Out buildings include horse shelters, barn, well house and shed. For the ultimate waterfront \"have it all\" lifestyle, THIS IS IT! Please give 24 hour notice for showings.' ,`Acres` = '5.724' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hitchcock' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 13 W H JACK SUR PT OF LOTS 24,26 & 28 (24-3) L M HITCHC' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '249337' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '26 - Hitchcock' ,`SchoolElementary` = 'HITCHCOCK PRIMARY/STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HITCHCOCK HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (HITCHCOCK)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Hitchcock L M East' ,`TaxAmount` = '10852' ,`TaxRate` = '2.2942' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663702827' WHERE `Matrix_Unique_ID` = '209956791' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T10:49:03.190' ,`MLSNumber` = '10981770' ,`ListAgentFullName` = 'Joseph Peterson' ,`ListOfficeName` = 'Briko Realty Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.112618' ,`Longitude` = '-94.161314' ,`PhotoCount` = '31' ,`PostalCode` = '77706' ,`RoomCount` = '13' ,`ListPrice` = '415000.00' ,`Status` = 'Active' ,`StreetName` = 'Foxbriar' ,`StreetNumber` = '3375' ,`StreetSuffix` = 'Lane' ,`City` = 'Beaumont' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3172' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning home in the Briar Creek community. Guests are greeted in a cozy foyer with a chandelier and first living/ sitting room and formal dining to the right. Then walk into the open concept family room with vaulted ceilings, crown molding, and customized white oak wood throughout downstairs floors and walls. Other features include a breakfast bar, fireplace, second dining area, kitchen island, and dual kitchen sinks. The Master bedroom is downstairs with a dual shower head in the master bath. The covered patio comes with lighting and ceiling fans to help with this Texas heat! Home comes fully furnished such as the custom-made formal living furniture and vases along with appliances Don’t miss out on this great opportunity!' ,`Acres` = '0.2477' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'BRIAR CREEK SUBD II LOT 10 BLK 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10790' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '175' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'REGINAL-HOWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WEST BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL (BEAUMONT)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Briar Creek Sec II' ,`TaxAmount` = '7990' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663702827' WHERE `Matrix_Unique_ID` = '210152695' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T11:29:13.927' ,`MLSNumber` = '14046614' ,`ListAgentFullName` = 'Reco Miller' ,`ListOfficeName` = 'JPAR-The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.691422' ,`Longitude` = '-95.458170' ,`PhotoCount` = '12' ,`PostalCode` = '77401' ,`RoomCount` = '2' ,`ListPrice` = '415000.00' ,`Status` = 'Active' ,`StreetName` = 'Maple' ,`StreetNumber` = '4626' ,`StreetSuffix` = 'Street' ,`City` = 'Bellaire' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great LOT for sale inside the 610 Loop. Great sized lot to build a fabulous home in the prestigious City of Bellaire. Very close proximity to Bellaire High School and walking distance to the Elementary school. Very short commute to The Texas Medical Center, Downtown, Meyerland, Rice University, U of H and all other points around Houston. Plenty of newly constructed luxury homes on the same street and in the area. Measurements are approximate.' ,`Acres` = '0.2014' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bellaire Area' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 33 BLK 4 POST OAK TERRACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8775' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HORN ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Post Oak Terrace Sec 01' ,`TaxAmount` = '9897' ,`TaxRate` = '2.2849' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663702827' WHERE `Matrix_Unique_ID` = '210282673' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T11:53:48.303' ,`MLSNumber` = '24060746' ,`ListAgentFullName` = 'Andrea Curran' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.745215' ,`Longitude` = '-95.529551' ,`PhotoCount` = '30' ,`PostalCode` = '77063' ,`RoomCount` = '7' ,`ListPrice` = '999000.00' ,`Status` = 'Active' ,`StreetName` = 'Shady' ,`StreetNumber` = '15' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3455' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated custom home nestled in the exclusive gated Cluster Oaks section of Piney Point Estates. Hand scraped wood flooring, high ceilings, fresh paint and new windows are just a few of the upgrades to this beautiful hone. Wrap around floor to ceiling windows in the family room offer panoramic view of the wooded area behind the home and Buffalo Bayou. Private owners retreat with floor to ceiling windows that offer views of the pool and wooded area, tray ceiling, marble topped double vanity, frameless glass shower, freestanding soaking tub and a custom designed walk-in closet. Chefs dream kitchen with custom shaker style cabinets, GE Cafe Series stainless steel appliances, quartz countertops, stainless steel farmhouse sink and a spacious island. Each of the spacious secondary bedrooms has a full en suite bathroom.' ,`Acres` = '0.2867' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'UNIT 1 BLDG 3 .125000 INT COMMON LAND & ELE CLUSTER OAKS T/H' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12489' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'EMERSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Cluster Oaks' ,`TaxAmount` = '10722' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702827' WHERE `Matrix_Unique_ID` = '210548626' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T11:07:30.010' ,`MLSNumber` = '55524811' ,`ListAgentFullName` = 'Rosa Martinez' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.650331' ,`Longitude` = '-95.240743' ,`PhotoCount` = '18' ,`PostalCode` = '77034' ,`RoomCount` = '7' ,`ListPrice` = '245000.00' ,`Status` = 'Active' ,`StreetName` = 'Globe' ,`StreetNumber` = '1131' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1594' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ready move-in completely remodeled call your Realtor today!' ,`Acres` = '0.1566' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 14 BLK 18 FREEWAY MANOR SEC 2' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6820' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'MATTHYS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SOUTH HOUSTON HIGH SCHOOL' ,`SchoolMiddle` = 'SOUTHHOUSTON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Freeway Manor Sec 02' ,`TaxAmount` = '3319' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1953' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702828' WHERE `Matrix_Unique_ID` = '210584303' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T10:26:57.370' ,`MLSNumber` = '21606165' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Tri Pointe Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.946597' ,`Longitude` = '-95.782824' ,`PhotoCount` = '29' ,`PostalCode` = '77433' ,`RoomCount` = '9' ,`ListPrice` = '834000.00' ,`Status` = 'Active' ,`StreetName` = 'Bluewood Aster' ,`StreetNumber` = '21327' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4428' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this gorgeous Snyder floorplan. This grand home has 5 beds, 4.5 baths, and a 3 bay garage with a static foyer. Walking in you will be charmed with curved elegant stairs, stunning railing, and a high ceiling providing lots of lighting brightening the room. Enjoy the night by cozying up in the fireplace. The gourmet kitchen is conveniently located overlooking the great room and dining room. Enjoy cooking in the gourmet kitchen featuring Silestone Quartz countertops, tile backsplash, stainless steel appliances, and more. Do you enjoy gatherings or having friends over! The gameroom is specialized for entertainment and fun for you and your guests. This Lovely home has everything you need!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Tri Pointe Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'na' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10764' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1197' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.52' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702828' WHERE `Matrix_Unique_ID` = '211195873' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T10:24:27.960' ,`MLSNumber` = '33188165' ,`ListAgentFullName` = 'Fiona Anderson' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.990890' ,`Longitude` = '-95.612918' ,`PhotoCount` = '47' ,`PostalCode` = '77429' ,`RoomCount` = '11' ,`ListPrice` = '1100000.00' ,`Status` = 'Active' ,`StreetName` = 'Hidden Valley Waters' ,`StreetNumber` = '15002' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '5250' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this stunning custom home by Kingston Custom Homes in the secluded gated community of Hidden Falls. Located on a corner lot, this home offers coffered ceilings, an elegant formal dining room, wine bar and wine room. Magnificent 23\' ceilings in the living room with a fireplace and floor to ceiling windows allows you to enjoy the fantastic backyard landscape while still indoors. The beautiful chef\'s kitchen with 42\" granite island will surely be a delight when preparing your favorite meals. Enjoy open concept living at its finest with easy access to the main areas of the home which makes entertaining and get togethers such a pleasure. Huge primary bedroom with bay windows, primary bath with deep soaker tub and grand double walk through shower is a must see! The spacious game room has a balcony overlooking the living area as well as access to another balcony overlooking the backyard. Don\'t forget the outdoor patio with fireplace and outdoor kitchen. Schedule your tour today!' ,`Acres` = '0.482' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 35 BLK 1 HIDDEN FALLS' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '20996' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1840' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Grill' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HAMILTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Hidden Falls' ,`TaxAmount` = '20526' ,`TaxRate` = '2.5197' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702828' WHERE `Matrix_Unique_ID` = '211202199' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T11:45:43.733' ,`MLSNumber` = '64752723' ,`ListAgentFullName` = 'Randall Martin' ,`ListOfficeName` = 'CB&A, Realtors- Southeast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.693043' ,`Longitude` = '-95.287753' ,`PhotoCount` = '22' ,`PostalCode` = '77087' ,`RoomCount` = '6' ,`ListPrice` = '215000.00' ,`Status` = 'Active' ,`StreetName` = 'McHenry' ,`StreetNumber` = '7702' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1177' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This move-in-ready 3-bed, 1-bath, 1-car garage beauty has gotten a facelift & is looking more stylish than EVER. Great curb appeal, an expansive covered front porch, and plenty of parking w/ a long driveway & carport. Inside has fresh paint & crown molding - large rooms too. Bedrooms & living room have recent carpet, while the kitchen, bathroom & dining room are tiled. I love the kitchen with its custom cabinets, tile backsplash, deep sink, and GRANITE counters. Just off the kitchen sits a back dining room which could easily become a second living area or perfect home office. Central A/C & ceiling fans to keep cool. The large backyard is fenced & offers great space for playing, gardening, or just relaxing. Being so close to I-45 & 610, you can get anywhere with ease - Downtown, the Med Center, great restaurants, shopping...you name it! This home may only be available to the buyer who acts now, so get that appointment set up today!' ,`Acres` = '0.1612' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 22 BLK 9 GREENWAY SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7021' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GOLFCREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HARTMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Greenway' ,`TaxAmount` = '2959' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702828' WHERE `Matrix_Unique_ID` = '211252283' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T10:42:28.680' ,`MLSNumber` = '33991737' ,`ListAgentFullName` = 'Cody McMillian' ,`ListOfficeName` = 'Vision Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.436165' ,`Longitude` = '-95.421734' ,`PhotoCount` = '34' ,`PostalCode` = '77583' ,`RoomCount` = '12' ,`ListPrice` = '690000.00' ,`Status` = 'Active' ,`StreetName` = 'Blythe' ,`StreetNumber` = '10118' ,`StreetSuffix` = 'Street' ,`City` = 'Iowa Colony' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '3650' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your dream home! 10118 Blythe impresses from every angle. The curb appeal is fantastic and as soon as you step in the soaring ceilings are sure to amaze. This highly functional floor plan features quartz counters, an incredible kitchen, HUGE master closet, and so much more. One of the original garage spaces was converted to a highly useful flex room just off the kitchen. All bedroom have en-suite baths, with 2 extra half baths located for your convenience. The Meridiana community has incredible amenities including a pool, gym access, clubhouse, and much more. The large covered patio looks out on a large back yard with an open field beyond. Little touches like pre-cut and ready-to-mount storm boards for all windows really put this one over the top. This home has barely been lived in and has been well cared for in that short time. Don\'t wait, schedule your showing today!' ,`Acres` = '0.2009' ,`Area` = '5' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'MERIDIANA SEC 66 (A0513 HT&BRR) (IOWA COLONY) BLK 1 LOT 25' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8751' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '1919' ,`TaxRate` = '3.6249' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702828' WHERE `Matrix_Unique_ID` = '211262122' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T11:13:45.320' ,`MLSNumber` = '56973548' ,`ListAgentFullName` = 'Sealy Moore' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.064170' ,`Longitude` = '-95.237816' ,`PhotoCount` = '24' ,`PostalCode` = '77339' ,`RoomCount` = '13' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Kings Mill' ,`StreetNumber` = '21309' ,`StreetSuffix` = 'Lane' ,`City` = 'Kingwood' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2346' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful home on Carter Lake is well designed, comfortable, and a delight to live in. From morning sun rises to evening sunsets reflected on the lake, white clouds and blue skies penetrate the home all day. This impressive home features a large dining room which can seat ten to twelve, large Family Room, and large Master Suite. Carter Lake is surrounded by a sidewalk where many friendly neighbors walk and talk together in the evenings and often chat over the fence.\r\n\r\nGasoline Powered Generator w/ Transfer Switch, Nine (9) Security Cameras, Whole House Water Purification Equipment, Reverse Osmosis Water System, Central Furnace Filter and UV Lite, Burglar Alarm and Fire Detection System, Custom Wood Deck, Water Sprinkler System, Manicured Garden w/ fruit trees and Compost Bin, Fenced Dog Yard, Doghouse w/ Shaded Porch (also shade trees), Water Supply to Dog Yard for Dog Shower and Water Bowl, Access Gates Both sides of yard' ,`Acres` = '0.2149' ,`Area` = '40' ,`BuilderName` = 'Gehan' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S642406 - KINGS MILL 06, BLOCK 1, LOT 8' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '9360' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'KINGS MANOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WOODRIDGE FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'French' ,`Subdivision` = 'Kings Mill 06' ,`TaxAmount` = '7917' ,`TaxRate` = '3.1831' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702828' WHERE `Matrix_Unique_ID` = '211398838' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T10:43:06.947' ,`MLSNumber` = '37436943' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Tri Pointe Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.947908' ,`Longitude` = '-95.781912' ,`PhotoCount` = '31' ,`PostalCode` = '77433' ,`RoomCount` = '7' ,`ListPrice` = '899000.00' ,`Status` = 'Active' ,`StreetName` = 'Blue Wood Aster' ,`StreetNumber` = '21314' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3803' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Burton flooprlan - An Open concept two-story plan has 5 bedrooms (2 downstairs), 3.5 baths with a 3-car garage. This plans has a dramatic long foyer, study, kitchen open to the casual dining area and living room, game room, Media room and a covered patio.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Tri Pointe Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PL06/01/45' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1197' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.52' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702828' WHERE `Matrix_Unique_ID` = '211439309' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T10:29:59.170' ,`MLSNumber` = '26612593' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Tri Pointe Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.947908' ,`Longitude` = '-95.781912' ,`PhotoCount` = '31' ,`PostalCode` = '77433' ,`RoomCount` = '7' ,`ListPrice` = '843000.00' ,`Status` = 'Active' ,`StreetName` = 'Heartleaf Aster' ,`StreetNumber` = '11135' ,`StreetSuffix` = 'Way' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3803' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Burton flooprlan - Open concept two-story plan has 4 bedrooms (2 downstairs), 3.5 baths with a 3-car garage. This plans has a dramatic long foyer, study, kitchen open to the casual dining area and family room, game room, media room and a covered patio. doors' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Tri Pointe Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PL06/01/46' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1197' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.52' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702829' WHERE `Matrix_Unique_ID` = '211467077' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T10:30:24.673' ,`MLSNumber` = '11712226' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Tri Pointe Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.947908' ,`Longitude` = '-95.781912' ,`PhotoCount` = '10' ,`PostalCode` = '77433' ,`RoomCount` = '7' ,`ListPrice` = '855000.00' ,`Status` = 'Active' ,`StreetName` = 'Heartleaf Aster' ,`StreetNumber` = '11111' ,`StreetSuffix` = 'Way' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3965' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Bogata flooprlan - Spacious, two-story plan has 4 bedrooms (two down), 3.5 baths and a 3-car garage. This plan features a formal dining area, study, media room, game room as well as an open concept living area leading to a covered patio. The primary suite has a large walk-in closet, separate shower and garden tub and dual vanities' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Tri Pointe Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PL06/01/52' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1197' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.52' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702829' WHERE `Matrix_Unique_ID` = '211467537' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T10:30:52.083' ,`MLSNumber` = '68274840' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Tri Pointe Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.947908' ,`Longitude` = '-95.781912' ,`PhotoCount` = '14' ,`PostalCode` = '77433' ,`RoomCount` = '7' ,`ListPrice` = '910000.00' ,`Status` = 'Active' ,`StreetName` = 'Shepards Needle' ,`StreetNumber` = '10910' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4058' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Siena flooprlan - Delightful one-story plan with 4 bedrooms, 3.5 baths with a 3-car garage. This plan includes a great room, game room, home office, dining room, breakfast area off kitchen and a large, covered patio. The primary suite features a large his & her walk-in closet and\r\na free-standing tub' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Tri Pointe Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PL07/01/13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1197' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.52' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702829' WHERE `Matrix_Unique_ID` = '211467979' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T10:31:46.150' ,`MLSNumber` = '76325712' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Tri Pointe Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.947908' ,`Longitude` = '-95.781912' ,`PhotoCount` = '13' ,`PostalCode` = '77433' ,`RoomCount` = '8' ,`ListPrice` = '940000.00' ,`Status` = 'Active' ,`StreetName` = 'Heartleaf Aster' ,`StreetNumber` = '11002' ,`StreetSuffix` = 'Way' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4081' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Messina flooprlan - Fantastic two-story plan has 5 bedrooms, 3.5 baths and a 3-car garage. This plan includes an open family room, study, casual dining, entertainment room and a large covered patio. HUGE OVERSIZED CORNER LOT.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Tri Pointe Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PL07/02/07' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1197' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.52' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702829' WHERE `Matrix_Unique_ID` = '211468461' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T10:32:13.527' ,`MLSNumber` = '84531140' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Tri Pointe Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.947908' ,`Longitude` = '-95.781912' ,`PhotoCount` = '41' ,`PostalCode` = '77433' ,`RoomCount` = '8' ,`ListPrice` = '915000.00' ,`Status` = 'Active' ,`StreetName` = 'Crescent Winged' ,`StreetNumber` = '21335' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4647' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Milan flooprlan - Open concept two-story has 5 bedroom, 4.5 baths with a 3-car garage. This plan includes a covered patio, casual dining open to the spacious great room and kitchen, home office, game room, and hidden storage. Primary suite includes free standing tub, large walk-in closet and dual vanities' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Tri Pointe Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PL07/02/13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1197' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.52' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702829' WHERE `Matrix_Unique_ID` = '211469437' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T10:47:51.870' ,`MLSNumber` = '27743414' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '29.943883' ,`Longitude` = '-95.198294' ,`PhotoCount` = '50' ,`PostalCode` = '77346' ,`RoomCount` = '14' ,`ListPrice` = '424990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Abbotshall Bend' ,`StreetNumber` = '15519' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2851' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy a peaceful lifestyle in this gorgeous Lake Ridge Builders home in Balmoral. Resting on a spacious lot, this 4-sided brick home boasts a premium elevation, tile flooring, wrought iron spindles, cast stone fireplace, a study, sprinkler system, and a covered patio. Try new cuisines in the kitchen, fully equipped with granite countertops, tile backsplash, stainless steel appliances, and 42” upper cabinets. The serene primary suite features dual vanities, a 42” tub, and a separate shower. The desirable Balmoral community includes white sand beaches, lakes, parks, an infinity pool, a recreation center, and walking trails. Located off Beltway 8 and Highway 59, commuters enjoy easy access to George Bush Intercontinental Airport and Downtown Houston. Zoned to Humble ISD. Don’t wait – call now to learn more!' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 101 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'RIDGE CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Balmoral' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702829' WHERE `Matrix_Unique_ID` = '211619215' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T10:09:56.727' ,`MLSNumber` = '69548367' ,`ListAgentFullName` = 'Tammie Bell' ,`ListOfficeName` = 'TBT Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.160663' ,`Longitude` = '-95.480673' ,`PhotoCount` = '20' ,`PostalCode` = '77515' ,`RoomCount` = '5' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Pecan Estates' ,`StreetNumber` = '419' ,`StreetSuffix` = 'Road' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2009' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! This is a beautifully updated home right outside of Angleton. The kitchen is a chef\'s dream with quartz counter tops and plenty of counter and cabinet space that opens up to the living room and dining room. Enjoy your meals with a view. The dining room windows look out into the back yard where Oyster Creek runs through. The primary bedroom is very spacious and has doors to access the back yard. The master bathroom has double vanities and a large soaker tub. Come see this beauty before it\'s gone. Schedule your private showing today!' ,`Acres` = '1.13' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0129 C SMITH, TRACT 5B1E, ACRES 1.130' ,`LotDesciption` = 'Cleared,Water View' ,`LotSize` = '49223' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'WESTSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'C Smith' ,`TaxAmount` = '4013' ,`TaxRate` = '1.9464' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702829' WHERE `Matrix_Unique_ID` = '211739682' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T10:28:53.620' ,`MLSNumber` = '48162980' ,`ListAgentFullName` = 'Jimmy Zarate' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.086986' ,`Longitude` = '-97.303544' ,`PhotoCount` = '13' ,`PostalCode` = '76501' ,`RoomCount` = '4' ,`ListPrice` = '175000.00' ,`Status` = 'Active' ,`StreetName` = 'Adams' ,`StreetNumber` = '3415' ,`StreetSuffix` = 'Avenue' ,`City` = 'Temple' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1368' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Handyman Investor Special. Need a little TLC. Plenty of potential with this boarder-line commercial location.' ,`Acres` = '1.96' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0014BC M MORENO, 165-1, OB 959-B, ACRES 1.96' ,`LotDesciption` = 'Other' ,`LotSize` = '85378' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '965 - Temple' ,`SchoolElementary` = 'HECTOR P. GARCIA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TEMPLE HIGH SCHOOL' ,`SchoolMiddle` = 'BONHAM MIDDLE SCHOOL (TEMPLE)' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'NA' ,`TaxAmount` = '2390' ,`TaxRate` = '2.5132' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1947' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702830' WHERE `Matrix_Unique_ID` = '211794240' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T11:05:55.197' ,`MLSNumber` = '68012810' ,`ListAgentFullName` = 'Shahin Naghavi' ,`ListOfficeName` = 'Madison Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.838510' ,`Longitude` = '-95.402648' ,`PhotoCount` = '7' ,`PostalCode` = '77018' ,`RoomCount` = '7' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Tolima Dove' ,`StreetNumber` = '123' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1751' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*LIMITED PRE-SALES AT THIS ENTRY PRICE FOR MARCH 2023* Welcome to your next home located in the premier residential development of Independence Heights! The development has two floorplans, and this is the largest! This home features first floor kitchen-living-dining and powder bath. First floor has 10-foot ceilings. Kitchen is open to great room featuring large island with breakfast bar seating. Marble-look quartz countertops, subway backsplash, apron front farmhouse sink, brushed gold pull-down faucet, 30-inch gas range and so much more! Primary suite is on the second floor. Primary bath has dual vanities, one with a makeup vanity! Oversized closet with dual areas. Separate water closet. Guest bedrooms have separate walk-in closets and Hollywood bath. Call now for more info and to reserve your lot!\r\nPhase I now pre-selling w/ expected completion March 2023! Visit design center to select finishes and upgrades now!\r\nTo find the site on the maps type 4924 Yale St, Houston, TX 77008.' ,`Acres` = '0.0439' ,`Area` = '9' ,`BuilderName` = 'Elite Townhomes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 2 INDEPENDENCE HEIGHTS HOMES' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '1716' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KENNEDY ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Other Style,Traditional' ,`Subdivision` = 'INDEPENDENCE HEIGHTS HOMES' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702830' WHERE `Matrix_Unique_ID` = '211809423' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T11:28:02.497' ,`MLSNumber` = '15012891' ,`ListAgentFullName` = 'Shahin Naghavi' ,`ListOfficeName` = 'Madison Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.838138' ,`Longitude` = '-95.402568' ,`PhotoCount` = '7' ,`PostalCode` = '77018' ,`RoomCount` = '7' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Tolima Dove' ,`StreetNumber` = '104' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1545' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*LIMITED PRE-SALES AT THIS ENTRY PRICE FOR MARCH 2023* Welcome to your home in a premier residential development of Independence Heights! This unique floorplan has two guest bedrooms on the first floor with the kitchen/living/dining & primary suite located on the second floor. Second floor has 10-foot ceilings. Kitchen is open to great room featuring large island with breakfast bar seating. Marble look quartz countertops, subway backsplash, apron front farmhouse sink, brushed gold pull-down faucet, 30-inch gas range and so much more! Powder bath is separated from kitchen/living/dining area for guest privacy. Primary suite on the second floor has a bathroom with a wrap-around vanity, kneespace for makeup included! HUGE closet. Separate water closet. Guest bedrooms have separate walk-in closets and Hollywood bath. Call now for more info and to reserve your lot! Visit design center to select finishes and upgrades now! To find the site on the maps type 4924 Yale St, Houston, TX 77008.' ,`Acres` = '0.03939' ,`Area` = '9' ,`BuilderName` = 'Elite Townhomes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 3 INDEPENDENCE HEIGHTS HOMES' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Other,Patio Lot,Subdivision Lot' ,`LotSize` = '1673' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KENNEDY ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Other Style,Traditional' ,`Subdivision` = 'INDEPENDENCE HEIGHTS HOMES' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702830' WHERE `Matrix_Unique_ID` = '211810602' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T11:41:39.243' ,`MLSNumber` = '26637525' ,`ListAgentFullName` = 'Shahin Naghavi' ,`ListOfficeName` = 'Madison Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.838510' ,`Longitude` = '-95.402648' ,`PhotoCount` = '7' ,`PostalCode` = '77018' ,`RoomCount` = '7' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Tolima Dove' ,`StreetNumber` = '121' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1751' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*LIMITED PRE-SALES AT THIS ENTRY PRICE FOR MARCH 2023* Welcome to your next home located in the premier residential development of Independence Heights! The development has two floorplans, and this is the largest! This home features first floor kitchen-living-dining and powder bath. First floor has 10-foot ceilings. Kitchen is open to great room featuring large island with breakfast bar seating. Marble-look quartz countertops, subway backsplash, apron front farmhouse sink, brushed gold pull-down faucet, 30-inch gas range and so much more! Primary suite is on the second floor. Primary bath has dual vanities, one with a makeup vanity! Oversized closet with dual areas. Separate water closet. Guest bedrooms have separate walk-in closets and Hollywood bath. Call now for more info and to reserve your lot!\r\nPhase I now pre-selling w/ expected completion March 2023! Visit design center to select finishes and upgrades now!\r\nTo find the site on the maps type 4924 Yale St, Houston, TX 77008.' ,`Acres` = '0.0439' ,`Area` = '9' ,`BuilderName` = 'Elite Townhomes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 2 INDEPENDENCE HEIGHTS HOMES' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '1716' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KENNEDY ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Other Style,Traditional' ,`Subdivision` = 'INDEPENDENCE HEIGHTS HOMES' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702830' WHERE `Matrix_Unique_ID` = '211811509' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T11:43:52.057' ,`MLSNumber` = '16524150' ,`ListAgentFullName` = 'Shahin Naghavi' ,`ListOfficeName` = 'Madison Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.838510' ,`Longitude` = '-95.402648' ,`PhotoCount` = '7' ,`PostalCode` = '77018' ,`RoomCount` = '7' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Tolima Dove' ,`StreetNumber` = '106' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1751' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*LIMITED PRE-SALES AT THIS ENTRY PRICE FOR MARCH 2023* Welcome to your next home located in the premier residential development of Independence Heights! The development has two floorplans, and this is the largest! This home features first floor kitchen-living-dining and powder bath. First floor has 10-foot ceilings. Kitchen is open to great room featuring large island with breakfast bar seating. Marble-look quartz countertops, subway backsplash, apron front farmhouse sink, brushed gold pull-down faucet, 30-inch gas range and so much more! Primary suite is on the second floor. Primary bath has dual vanities, one with a makeup vanity! Oversized closet with dual areas. Separate water closet. Guest bedrooms have separate walk-in closets and Hollywood bath. Call now for more info and to reserve your lot!\r\nPhase I now pre-selling w/ expected completion March 2023! Visit design center to select finishes and upgrades now!\r\nTo find the site on the maps type 4924 Yale St, Houston, TX 77008.' ,`Acres` = '0.0439' ,`Area` = '9' ,`BuilderName` = 'Elite Townhomes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 3 INDEPENDENCE HEIGHTS HOMES' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '1673' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KENNEDY ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Other Style,Traditional' ,`Subdivision` = 'INDEPENDENCE HEIGHTS HOMES' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702830' WHERE `Matrix_Unique_ID` = '211811545' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T11:51:18.750' ,`MLSNumber` = '12306867' ,`ListAgentFullName` = 'Shahin Naghavi' ,`ListOfficeName` = 'Madison Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.838510' ,`Longitude` = '-95.402648' ,`PhotoCount` = '7' ,`PostalCode` = '77018' ,`RoomCount` = '7' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Tolima Dove' ,`StreetNumber` = '119' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1751' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*LIMITED PRE-SALES AT THIS ENTRY PRICE FOR MARCH 2023* Welcome to your next home located in the premier residential development of Independence Heights! The development has two floorplans, and this is the largest! This home features first floor kitchen-living-dining and powder bath. First floor has 10-foot ceilings. Kitchen is open to great room featuring large island with breakfast bar seating. Marble-look quartz countertops, subway backsplash, apron front farmhouse sink, brushed gold pull-down faucet, 30-inch gas range and so much more! Primary suite is on the second floor. Primary bath has dual vanities, one with a makeup vanity! Oversized closet with dual areas. Separate water closet. Guest bedrooms have separate walk-in closets and Hollywood bath. Call now for more info and to reserve your lot!\r\nPhase I now pre-selling w/ expected completion March 2023! Visit design center to select finishes and upgrades now!\r\nTo find the site on the maps type 4924 Yale St, Houston, TX 77008.' ,`Acres` = '0.0439' ,`Area` = '9' ,`BuilderName` = 'Elite Townhomes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 2 INDEPENDENCE HEIGHTS HOMES' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '1716' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KENNEDY ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Other Style,Traditional' ,`Subdivision` = 'INDEPENDENCE HEIGHTS HOMES' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702830' WHERE `Matrix_Unique_ID` = '211812085' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T11:59:47.183' ,`MLSNumber` = '16031998' ,`ListAgentFullName` = 'Shahin Naghavi' ,`ListOfficeName` = 'Madison Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.838510' ,`Longitude` = '-95.402648' ,`PhotoCount` = '7' ,`PostalCode` = '77018' ,`RoomCount` = '7' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Tolima Dove' ,`StreetNumber` = '108' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1751' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*LIMITED PRE-SALES AT THIS ENTRY PRICE FOR MARCH 2023* Welcome to your next home located in the premier residential development of Independence Heights! The development has two floorplans, and this is the largest! This home features first floor kitchen-living-dining and powder bath. First floor has 10-foot ceilings. Kitchen is open to great room featuring large island with breakfast bar seating. Marble-look quartz countertops, subway backsplash, apron front farmhouse sink, brushed gold pull-down faucet, 30-inch gas range and so much more! Primary suite is on the second floor. Primary bath has dual vanities, one with a makeup vanity! Oversized closet with dual areas. Separate water closet. Guest bedrooms have separate walk-in closets and Hollywood bath. Call now for more info and to reserve your lot!\r\nPhase I now pre-selling w/ expected completion March 2023! Visit design center to select finishes and upgrades now!\r\nTo find the site on the maps type 4924 Yale St, Houston, TX 77008.' ,`Acres` = '0.0439' ,`Area` = '9' ,`BuilderName` = 'Elite Townhomes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 3 INDEPENDENCE HEIGHTS HOMES' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '1673' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KENNEDY ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Other Style,Traditional' ,`Subdivision` = 'INDEPENDENCE HEIGHTS HOMES' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702831' WHERE `Matrix_Unique_ID` = '211812620' --> Updated record success