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-16T10:32:46.157' ,`MLSNumber` = '80406791' ,`ListAgentFullName` = 'Jaimie Harvey' ,`ListOfficeName` = 'United Country JW Realty and' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.866090' ,`Longitude` = '-94.420500' ,`PhotoCount` = '50' ,`PostalCode` = '77665' ,`RoomCount` = '3' ,`ListPrice` = '1700000.00' ,`Status` = 'Active' ,`StreetName` = 'Bauer Road' ,`StreetNumber` = '1800' ,`StreetSuffix` = '' ,`City` = 'Winnie' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '4742' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Beautiful Iconic Bauer Ranch has so many wonderful things to say about it the ranch style home that overlooks the beautiful Landscaped Yard with Live Oaks that canopy over the front and back yard on 34 acres. This is truly a remarkable setting. This home has so many memories, with brides getting married and families celebrating milestone occasions. The home is elegantly decorated and designed, it is truly built to entertain, the kitchen is open to the dinning room with the formal dinning and living room just around the corner. The great room overlooks the backyard and the outdoor kitchen and wedding pavilion. This home comes with a built in ready to go Wedding Venue business, The Wedding Venue comes with most everything you would need to have a wedding. If you are looking for a place to call home as well as a venue business call today.' ,`Acres` = '34.5' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Chambers County East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '547 TR 1-1 JOHN E NOLTE (Metes and Bounds 34.5 acres)' ,`LotDesciption` = 'Cleared,Corner,Water View' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Composition' ,`SchoolDistrict` = '18 - East Chambers' ,`SchoolElementary` = 'EAST CHAMBERS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'EAST CHAMBERS HIGH SCHOOL' ,`SchoolMiddle` = 'EAST CHAMBERS J H' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Split Level' ,`Subdivision` = 'Winnie Suburbs' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '1951' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663699407' WHERE `Matrix_Unique_ID` = '193698386' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T11:57:38.047' ,`MLSNumber` = '39019582' ,`ListAgentFullName` = 'Lucy Knox' ,`ListOfficeName` = 'Trowbridge Realty Corp' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.835022' ,`Longitude` = '-95.419239' ,`PhotoCount` = '21' ,`PostalCode` = '77018' ,`RoomCount` = '9' ,`ListPrice` = '599999.00' ,`Status` = 'Active' ,`StreetName` = 'Martin' ,`StreetNumber` = '1008' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2549' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Light, bright, and beautifully updated home! Featuring fresh paint and new flooring throughout, this is the blank slate you have been searching for to quickly become your new home sweet home. The formal living and dining room are ideal for entertaining while the family room with french doors and wood-burning fireplace provides a cozy retreat for weekends with loved ones. Even novice chefs will be inspired to create memorable meals in the large kitchen boasting all new stainless steel appliances, sleek quartz countertops, and easy access to both the dining room and breakfast room. An open patio in the oversized backyard provides a comfortable outdoor space where family and friends can enjoy some fun in the sun. Retreat to the spacious primary bedroom complete with an updated en-suite bathroom where you can relax and recharge after a long day. A bonus room upstairs provides additional flex space to suit any of your household’s needs! Don’t miss out, showing your today!' ,`Acres` = '0.2009' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Shepherd Park Plaza Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 551 BLK 18 SHEPHERD PARK PLAZA SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DURHAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Shepherd Park Plaza' ,`TaxAmount` = '11038' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699407' WHERE `Matrix_Unique_ID` = '203723973' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T10:08:25.027' ,`MLSNumber` = '55138787' ,`ListAgentFullName` = 'Reginald Hays' ,`ListOfficeName` = 'RE/MAX Advanced Real Estate' ,`SellingAgentFullName` = 'Reginald Hays' ,`SellingOfficeName` = 'RE/MAX Advanced Real Estate' ,`Latitude` = '31.474645' ,`Longitude` = '-96.227308' ,`PhotoCount` = '48' ,`PostalCode` = '75831' ,`RoomCount` = '8' ,`ListPrice` = '175000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'FM 80' ,`StreetNumber` = '117' ,`StreetSuffix` = '' ,`City` = 'Buffalo' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1794' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy your morning coffee on the back patio in a country setting. Located in the small community of Donie and just west of Buffalo. This home features a spacious dining room, large spacious family room with a brick wall decor and wood burning F/P. Outside you will enjoy the large spacious back yard with lots of shade for those hot Texas summer months, circle drive, attached 2 car garage & workshop. This home requires very little maintenance with exterior brick and a metal roof.' ,`Acres` = '1' ,`Area` = '74' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Freestone County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = '1+/- acre in the N PECK Survey A-820' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '244 - Teague' ,`SchoolElementary` = 'TEAGUE ELEMENTARY SCHOOL (TEAGUE)' ,`SchoolHigh` = 'TEAGUE HIGH SCHOOL' ,`SchoolMiddle` = 'TEAGUE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'NA' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699407' WHERE `Matrix_Unique_ID` = '205755344' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T11:40:16.060' ,`MLSNumber` = '87693393' ,`ListAgentFullName` = 'Philip Rayos' ,`ListOfficeName` = 'Prime Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.730846' ,`Longitude` = '-94.941099' ,`PhotoCount` = '30' ,`PostalCode` = '77520' ,`RoomCount` = '8' ,`ListPrice` = '238900.00' ,`Status` = 'Active' ,`StreetName` = 'Olive' ,`StreetNumber` = '2309' ,`StreetSuffix` = 'Circle' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1748' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this beautifully updated home! As you walk in, you will notice almost everything in this house is brand new. There is new waterproof vinyl flooring, windows, paint, and ceiling fans throughout the home. In the kitchen, you will find brand new granite counters, sink, cabinets, and stainless appliances. The bathrooms also feature granite counters, modern sink, new tile, and fixtures. Come check out this home before it\'s gone!' ,`Acres` = '0.194' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 7 BLK 3 HOLLY HILLS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8452' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'LORENZO DE ZAVALA ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'CEDAR BAYOU J H' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Holly Hills Sec 01' ,`TaxAmount` = '4117' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1963' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699407' WHERE `Matrix_Unique_ID` = '207454803' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T11:10:38.663' ,`MLSNumber` = '16249575' ,`ListAgentFullName` = 'Nancy Lawrence' ,`ListOfficeName` = 'Lawrence Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.331442' ,`Longitude` = '-95.432055' ,`PhotoCount` = '23' ,`PostalCode` = '75835' ,`RoomCount` = '3' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Houston' ,`StreetNumber` = '2803' ,`StreetSuffix` = 'Avenue' ,`City` = 'Crockett' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2202' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Just outside Loop 304 in Crockett, TX, you will find this adorable ranch-style brick home situated on 2.15-acres with towering shade trees. From the moment you walk in the door, you will feel right at home. This home offers three bedrooms, two baths, and an open floor plan for seamless entertaining. The large living and dining area is complete with a pretty fireplace, nice flooring, and custom plantation shutters. The owners have enclosed the garage and made extra living space, but could be turned into a garage. The kitchen is spacious with great cabinet and countertop space and leads into the extra-large laundry/mud room. The primary bedroom has a private bath, while two guest bedrooms share a hall bath. Outside, you will enjoy the 2.15-acre property with a large, fenced backyard and small pond. There is plenty of room for a garden, livestock projects, and the kids to play! Don’t miss out on this amazing opportunity to live to town, with extra land and workspace.' ,`Acres` = '2.15' ,`Area` = '41' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crockett Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A E GOSSETT AB 423 2.15 AC' ,`LotDesciption` = 'Other' ,`LotSize` = '93654' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '57 - Crockett' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (CROCKETT)' ,`SchoolHigh` = 'CROCKETT HIGH SCHOOL (CROCKETT)' ,`SchoolMiddle` = 'CROCKETT JUNIOR HIGH SCHOOL (CROCKETT)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'NA' ,`TaxAmount` = '3708' ,`TaxRate` = '2.3627' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699408' WHERE `Matrix_Unique_ID` = '207565623' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T11:07:36.820' ,`MLSNumber` = '97243493' ,`ListAgentFullName` = 'Connie Raven' ,`ListOfficeName` = 'Virginia Malone & Assoc.,' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.823281' ,`Longitude` = '-94.992390' ,`PhotoCount` = '21' ,`PostalCode` = '77521' ,`RoomCount` = '7' ,`ListPrice` = '309900.00' ,`Status` = 'Active' ,`StreetName` = 'Willet' ,`StreetNumber` = '8647' ,`StreetSuffix` = 'Street' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1935' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is home ready for new owners! Extremely clean! Pride of ownership certainly shows! Great neighborhood with nice playground for your children. Spacious eat-in kitchen is open to family room. Nice size back yard. This a great location.' ,`Acres` = '0.1458' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 1 GOOSE CREEK LANDING SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6350' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'BANUELOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Goose Creek Landing' ,`TaxAmount` = '8405' ,`TaxRate` = '3.77' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699408' WHERE `Matrix_Unique_ID` = '208661590' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T11:07:08.117' ,`MLSNumber` = '67756274' ,`ListAgentFullName` = 'Connie Raven' ,`ListOfficeName` = 'Virginia Malone & Assoc.,' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.823415' ,`Longitude` = '-94.992430' ,`PhotoCount` = '22' ,`PostalCode` = '77521' ,`RoomCount` = '8' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Willet' ,`StreetNumber` = '8703' ,`StreetSuffix` = 'Street' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2350' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is very well kept. Carpet and custom paint are in excellent condition. Open floor plan with kitchen, dining and family all open to one another. Study or home office at front is a nice size. This home is a must see! You will not be disappointed!' ,`Acres` = '0.1458' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 1 GOOSE CREEK LANDING SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6350' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'BANUELOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Goose Creek Landing' ,`TaxAmount` = '9049' ,`TaxRate` = '3.77' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699408' WHERE `Matrix_Unique_ID` = '208676534' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T10:22:07.980' ,`MLSNumber` = '86357263' ,`ListAgentFullName` = 'Jarred DeMore' ,`ListOfficeName` = 'Keller Williams SoutheastTexas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.514478' ,`Longitude` = '-94.486635' ,`PhotoCount` = '47' ,`PostalCode` = '77617' ,`RoomCount` = '2' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Faggards Slip Rd' ,`StreetNumber` = '1024' ,`StreetSuffix` = '' ,`City` = 'Gilchrist' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1022' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well-constructed, beautifully designed beach hm on 3 lots just off hwy 87 w/amazing 180-degree beach views + lovely bay views! This hm is perfectly positioned so every beach view has been maximized! While sitting in your LR/DR/kit open concept area you will be amazed at the views of the gulf! 1 BR dwn & upstairs loft/2nd BR & bath! This kitchen is a dream-undermount lighting, tons of cabinets, b\'fast bar seats 3! Spacious laundry w/add\'l stg possibilities! Primary BR offers gorgeous, exposed beam ceiling & lg windows w/incredible views! Cozy but spacious bath! You will admire the craftsmanship as you walk up the open stairway to loft! Loft area is very inviting w/bay view & offers private bath! Lg bird sanctuary next door offers lots of privacy & awesome birdwatching! Downstairs offers gar, tiki bar, sand shwr & great amenities! Gorg landscaping! Sec gate leading to the upstairs for extra privacy! Lots of space on these 3 lots for all of your beach fun! PLUS has a cargo lift!' ,`Acres` = '0.1148' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Gilchrist' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 64 E FRANKS SUR LOTS 2 & 3 (3-0) BLK 1 FAGGARD SLIP UNR' ,`LotDesciption` = 'Water View' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '25 - High Island' ,`SchoolElementary` = 'HIGH ISLAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HIGH ISLAND HIGH SCHOOL' ,`SchoolMiddle` = 'HIGH ISLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Craftsman' ,`Subdivision` = 'Faggard Slip Ext' ,`TaxAmount` = '3776' ,`TaxRate` = '1.5543' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699408' WHERE `Matrix_Unique_ID` = '208993516' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T11:54:20.867' ,`MLSNumber` = '80438738' ,`ListAgentFullName` = 'Becky Wied' ,`ListOfficeName` = 'Wied Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.662157' ,`Longitude` = '-96.412176' ,`PhotoCount` = '42' ,`PostalCode` = '77979' ,`RoomCount` = '6' ,`ListPrice` = '237000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 307' ,`StreetNumber` = '160' ,`StreetSuffix` = '' ,`City` = 'Port Lavaca' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1088' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning Caranchua Bay views from this adorable Port Alto home front porch. Move-in ready, updated throughout home. Recent roof, siding, windows, electrical, plumbing, fixtures, lighting (including recessed lighting), applianes, custom concrete countertops, wood plant feature walls and interior/exterior paint. Central air and heat in the main house (installed less than 2 years ago) and a wall unit in the guest quarters. Separate water heaters for the house and guest quarters. Washer and dryer are located inside the house. Pergola over back cement patio. Storage room for lawn equipment or golf cart.' ,`Acres` = '0.1607' ,`Area` = '65' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PORT ALTO UNIT ONE, BLOCK 4, LOT 18' ,`LotDesciption` = 'Water View' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '169 - Calhoun County' ,`SchoolElementary` = 'HARRISON/JEFFERSON/MADISON eLEMENTARY SCHOOL' ,`SchoolHigh` = 'CALHOUN HIGH SCHOOL' ,`SchoolMiddle` = 'TRAVIS MIDDLE SCHOOL (CALHOUN COUNTY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Port Alto Unit One' ,`TaxAmount` = '1250' ,`TaxRate` = '1.7153' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1967' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663699408' WHERE `Matrix_Unique_ID` = '209131222' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T11:13:49.383' ,`MLSNumber` = '84021787' ,`ListAgentFullName` = 'Katherine Rodriguez' ,`ListOfficeName` = 'C.R.Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.829364' ,`Longitude` = '-95.447960' ,`PhotoCount` = '27' ,`PostalCode` = '77018' ,`RoomCount` = '15' ,`ListPrice` = '1200000.00' ,`Status` = 'Active' ,`StreetName` = 'Cheshire' ,`StreetNumber` = '2002' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3384' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION... COMING END OF YEAR! Located in the astounded Oak Forest Community and zoned to Stevens elementary. Modern Contemporary living that offers a very spacious floor plan w/ custom touches throughout. Home will feature a gorgeous Chef\'s kitchen included w/ high end appliances, oversized island & custom cabinets. Kitchen and formal dining room are connected by a butler pantry & huge walk-in pantry. Living a=& breakfast rm are surrounded by natural light that will overflow in to your home. The large living rm complete w. a fireplace and 16 foot sliding doors that open to the backyard fully fenced & ready to entertain. GUEST SUITE w/ private bath & study DOWNSTAIRS. PRIMARY bedroom w/ 2 additional bedrooms UPSTAIRS. THIS HOUSE WILL CHECK EVERY BOX ON YOUR LIST! Give me a call today to get all the details and begin to customize your dream home!' ,`Acres` = '0.1934' ,`Area` = '9' ,`BuilderName` = 'H-Tex Enterprises' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 14 BLK 8 OAK FOREST SEC 14' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8424' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'STEVENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Oak Forest Sec 14' ,`TaxAmount` = '7976' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699408' WHERE `Matrix_Unique_ID` = '209467396' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T10:05:50.527' ,`MLSNumber` = '76735035' ,`ListAgentFullName` = 'Rogelio Olivetti' ,`ListOfficeName` = 'Texas Real Estate & Co.' ,`SellingAgentFullName` = 'Justin Flanagan' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.795584' ,`Longitude` = '-95.576261' ,`PhotoCount` = '31' ,`PostalCode` = '77043' ,`RoomCount` = '6' ,`ListPrice` = '499900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Upland' ,`StreetNumber` = '1661' ,`StreetSuffix` = 'Lakes' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2780' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Absolutely gorgeous 4 bedroom move in ready home with open floor plan,high ceilings & much character.CALCUTTA MARBLE kitchen totally gutted & remodeled. Thermadortop of the line steel appliances include built in fridge & microwave,gas range,Kohler farm sink. Home features first floor living and most bedrooms are located on the 2nd floor. The flex space/bedroom/gameroom/office with full bathroom is located on the 3rd floor. This home also has one of the larger driveways so you can park two cars in your driveway. Home was recently painted, new roof and never flooded. The community is gated with about 200 homes with a swimming pool, running trail, dog park and lake.' ,`Acres` = '0.0579' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas,Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 1 UPLAND PARK PAR R/P AMEND' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '2520' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'SHERWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STRATFORD HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Upland Park Pt Rep 01 Amendi' ,`TaxAmount` = '10339' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699408' WHERE `Matrix_Unique_ID` = '209876564' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T11:33:54.167' ,`MLSNumber` = '51592171' ,`ListAgentFullName` = 'Jessica Flowers' ,`ListOfficeName` = 'White Ivy Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.785583' ,`Longitude` = '-95.540394' ,`PhotoCount` = '36' ,`PostalCode` = '77320' ,`RoomCount` = '5' ,`ListPrice` = '400000.00' ,`Status` = 'Active' ,`StreetName` = 'Pinecrest' ,`StreetNumber` = '187' ,`StreetSuffix` = 'Drive' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2084' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful 3 bed 2 bath Ranch style home just off 980 offers country living close to town. Just 5 miles (approx) from the heart of Huntsville, these 2.4 Acres are crossed fences and able to house livestock. No restrictions!! 1,559 Sqft of beautiful semi open concept, farmhouse feel. The home features an open concept living and dining area, with a wood burning fireplace, kitchen complete with breakfast nook. Outdoor shed conveys. The home has 3 traditional bedrooms and 1 large multi-use room. Currently the multi-use room is being used as a 4th bedroom, however, it would make a great home gym or playroom for young children. The home is currently being repainted and minor upgrades such as doorknobs are being installed for the future owner. Beautiful shade trees throughout the yard providing nice coverage for horses or livestock in the cross fenced area.' ,`Acres` = '2.49' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PINECREST ACRES, LOT 2, ACRES 2.49, A-37 PARKER W, ETJ' ,`LotDesciption` = 'Cleared,Other' ,`LotSize` = '108464' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'HUNTSVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Pinecrest Acres' ,`TaxAmount` = '4270' ,`TaxRate` = '1.6534' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699409' WHERE `Matrix_Unique_ID` = '210026567' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T10:28:21.447' ,`MLSNumber` = '30680433' ,`ListAgentFullName` = 'Arnulfo Villarreal' ,`ListOfficeName` = 'Metro Plus Realty PLLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.885282' ,`Longitude` = '-95.303852' ,`PhotoCount` = '29' ,`PostalCode` = '77016' ,`RoomCount` = '6' ,`ListPrice` = '401280.00' ,`Status` = 'Active' ,`StreetName` = 'Hartwick' ,`StreetNumber` = '5831' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1579' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to his beautiful brick and stone house!! It has a metal gate at the entrance as well as security cameras. Fresh paint. No carpet. The ceiling is high and has moldings. Ceiling fans are around the house! It has wooden stairs that go to an extra room that can be used as a family room or as a bedroom. The kitchen has a large island made of granite as well as granite countertops. It has beautiful wooden cabinets. Bathrooms have showers with tile and a bench. In the patio you can enjoy a kiosk, paved and roofed patio with ample parking. Never flooded! In the backyard there is a Guest Suite with a kitchen that has granite countertops measuring 25 x 8, living room and dining of 14 x 2, 1 full bath, 2 bedrooms perfect for family guests or a rental with separate gas line, water and electricity. Primary room is 18 x 16 and the second room is 13 x 11. Guest suite has a mini split and access to a covered garage. This is a great opportunity for buying two houses at the price of one!!' ,`Acres` = '0.2105' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 182 BLK 8 EDGEWORTH PLACE SEC 2' ,`LotDesciption` = 'Other' ,`LotSize` = '9169' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MARSHALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Edgeworth Place Add Sec 02' ,`TaxAmount` = '4615' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699409' WHERE `Matrix_Unique_ID` = '210080066' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T10:48:38.600' ,`MLSNumber` = '79760924' ,`ListAgentFullName` = 'Rochelle Jones' ,`ListOfficeName` = 'Aplomb Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.752316' ,`Longitude` = '-95.566233' ,`PhotoCount` = '16' ,`PostalCode` = '77042' ,`RoomCount` = '4' ,`ListPrice` = '361000.00' ,`Status` = 'Active' ,`StreetName` = 'Lynbrook' ,`StreetNumber` = '10722' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3014' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home located in Walnut Bend. Walnut Bend is an active, established neighborhood of lovely homes and mature trees located in west Houston. The neighborhood is sought after for its community feel, location near great restaurants, upscale shopping, and close proximity to the west side Energy Corridor. The Buffalo Bayou and Terry Hershey Park border the subdivision to the North and provide a natural setting for walking, jogging, biking, and exploring. All residents of Walnut Bend can enjoy seasonal community events as well as amenities such as recreation center gymnasium, pool, park, playground, tennis courts and many active social and civic groups.' ,`Acres` = '0.2238' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Real Estate Owned' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Briargrove Park/Walnutbend' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 23 WALNUT BEND SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '75' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WALNUT BEND ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Walnut Bend Sec 07' ,`TaxAmount` = '8326' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699409' WHERE `Matrix_Unique_ID` = '210366586' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T11:00:38.597' ,`MLSNumber` = '2901759' ,`ListAgentFullName` = 'Christina German' ,`ListOfficeName` = 'Texas Signature Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.795656' ,`Longitude` = '-95.812854' ,`PhotoCount` = '32' ,`PostalCode` = '77493' ,`RoomCount` = '7' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Chilton' ,`StreetNumber` = '1639' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1852' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful new listing in Katyland! 4 big bedrooms and 2 full baths.\r\nBeautiful large tile floors, updated kitchen, huge utility room, renovated baths, whole house water softener and reverse osmosis in kitchen, new ac unit, alarm/video system stays, paint inside and out, new patio, ceiling fans and light fixtures. \r\nThis is a well loved home, come and see!!' ,`Acres` = '0.1692' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK G KATYLAND SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7370' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'HUTSELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Katyland Sec 02' ,`TaxAmount` = '4304' ,`TaxRate` = '2.3852' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699409' WHERE `Matrix_Unique_ID` = '210385407' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T10:18:25.670' ,`MLSNumber` = '65768166' ,`ListAgentFullName` = 'Anastasia Konik' ,`ListOfficeName` = 'Brent Allen Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.793071' ,`Longitude` = '-95.492292' ,`PhotoCount` = '8' ,`PostalCode` = '77055' ,`RoomCount` = '14' ,`ListPrice` = '3299000.00' ,`Status` = 'Active' ,`StreetName` = 'Friarcreek' ,`StreetNumber` = '1311' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '6' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '6904' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exquisite new construction by RobRyan Builders on a ravine lot surrounded by beautiful scenery & private creek-access. 1st floor features spacious primary retreat + spa-like ensuite bath, generous walk-in closets, library/study, formal dining w/ wet bar & wine room adj., catering kitchen, butler\'s pantry, mudroom, 2 powder baths, pool bath + home office/hobby room. Stunning island kitchen, 48\'\' Wolf gas range & Subzero appliances that overlooks the double-height great room showcasing breath-taking views of towering trees & lush landscape that is your backyard. Upstairs offers a large game room w/ wet bar + half bath, 4 secondary bedrooms up each w/ private ensuite baths. Utility rooms up & down; 3 wood-burning fireplaces; Front & back stairs + 3-car attached garage. Covered outdoor living & summer kitchen with ample green space for play & the dream pool. Superior quality build w/ designer-selected finishes & no detail overlooked; this is your chance to customize/build your dream home.' ,`Acres` = '0.5937' ,`Area` = '24' ,`BuilderName` = 'RobRyan Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 FRIARCREEK' ,`LotDesciption` = 'Ravine,Subdivision Lot,Water View,Wooded' ,`LotSize` = '25861' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range,Grill' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'VALLEY OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,English' ,`Subdivision` = 'Friarcreek' ,`TaxAmount` = '20928' ,`TaxRate` = '2.4805' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699409' WHERE `Matrix_Unique_ID` = '210504073' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T11:02:50.070' ,`MLSNumber` = '96566835' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.071605' ,`Longitude` = '-95.616630' ,`PhotoCount` = '25' ,`PostalCode` = '77375' ,`RoomCount` = '6' ,`ListPrice` = '428705.00' ,`Status` = 'Active' ,`StreetName` = 'Everpine' ,`StreetNumber` = '13027' ,`StreetSuffix` = 'Trail' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2757' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready December 2022! Skip your commute and work from home in the Pearl\'s private study. Linen cabinets with white/grey granite countertops, brown grey EVP flooring with multi-tone carpet in our Elemental package. Whether you’re headed to work or for a night out, Cherry Pines is just minutes away from premier retail, restaurants, and employment centers. Send the kids to school in the sought-after Tomball school district and enjoy weekends at the future pool and playground. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '14' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0282 Plan L452B' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TOMBALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cherry Pines' ,`TaxAmount` = '' ,`TaxRate` = '2.46' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699409' WHERE `Matrix_Unique_ID` = '210564943' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T11:00:10.440' ,`MLSNumber` = '94208023' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.072460' ,`Longitude` = '-95.616898' ,`PhotoCount` = '25' ,`PostalCode` = '77375' ,`RoomCount` = '6' ,`ListPrice` = '423065.00' ,`Status` = 'Active' ,`StreetName` = 'Cherryvale' ,`StreetNumber` = '2118' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2757' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready January 2023! Skip your commute and work from home in the private study. Relax in the spacious primary suite. Slate cabinets with cotton white quartz countertops, cool grey EVP flooring and multi-tone tweed carpet in our Sleek package. Whether you’re headed to work or for a night out, Cherry Pines is just minutes away from premier retail, restaurants, and employment centers. Send the kids to school in the sought-after Tomball school district and enjoy weekends at the future pool and playground. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '14' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0342 Plan L452B' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TOMBALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cherry Pines' ,`TaxAmount` = '' ,`TaxRate` = '2.46' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699409' WHERE `Matrix_Unique_ID` = '210577549' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T10:48:51.393' ,`MLSNumber` = '38236753' ,`ListAgentFullName` = 'Nicole Wood' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.663864' ,`Longitude` = '-95.267280' ,`PhotoCount` = '38' ,`PostalCode` = '77061' ,`RoomCount` = '0' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Cayton' ,`StreetNumber` = '8319' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2352' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great investment potential as a rental, Air bnb flip or family home. Property has been used as an Air bnb to corporate entities during conventions due to easy access to Hobby Airport and downtown Houston. It\'s also been leased to government entities after natural disasters due to the fact that it did not flood during Hurricane Ike or Harvey, per seller. Property has potential to be leased as Air bnb during sporting events including but not limited to Houston Live Stock Show and Rodeo, March Madness, and the World Cup to be held in Houston in 2026. Washer, dryer and primary bedroom furniture included. Being sold as is. Buyer will need to purchase a new survey.' ,`Acres` = '0.2204' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 30 & TR 29 BLK 14 MEADOWBROOK FREEWAY SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'SOUTH HOUSTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CHAVEZ HIGH SCHOOL' ,`SchoolMiddle` = 'SOUTHHOUSTON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Meadowbrook Fwy' ,`TaxAmount` = '4970' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699410' WHERE `Matrix_Unique_ID` = '210683990' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T10:50:40.060' ,`MLSNumber` = '47449657' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.073462' ,`Longitude` = '-95.617438' ,`PhotoCount` = '32' ,`PostalCode` = '77375' ,`RoomCount` = '3' ,`ListPrice` = '404780.00' ,`Status` = 'Active' ,`StreetName` = 'Bristlecone' ,`StreetNumber` = '2222' ,`StreetSuffix` = 'Circle' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1831' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready January 2023! A private study makes a perfect home office or play room. Stone cabinets with marble-look white quartz countertops, warm wood-look tile flooring with beige tweed carpet in our Fresh package. Whether you’re headed to work or for a night out, Cherry Pines is just minutes away from premier retail, restaurants, and employment centers. Send the kids to school in the sought-after Tomball school district and enjoy weekends at the future pool and playground. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '14' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0348 Plan L401D' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TOMBALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cherry Pines' ,`TaxAmount` = '' ,`TaxRate` = '2.46' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699410' WHERE `Matrix_Unique_ID` = '210774865' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T10:58:55.530' ,`MLSNumber` = '20564082' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.073769' ,`Longitude` = '-95.617545' ,`PhotoCount` = '32' ,`PostalCode` = '77375' ,`RoomCount` = '3' ,`ListPrice` = '383090.00' ,`Status` = 'Active' ,`StreetName` = 'Cherryvale' ,`StreetNumber` = '2215' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1831' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready January 2023! Crisp interior. No rear neighbor. A private study makes a perfect home office or play room. Clear sight lines from the kitchen through the family room bring everyone together, while twin secondary bedrooms are tucked away in their own hall. Whether you’re headed to work or for a night out, Cherry Pines is just minutes away from premier retail, restaurants, and employment centers. Send the kids to school in the sought-after Tomball school district and enjoy weekends at the future pool and playground. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '14' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0276 Plan L401B' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TOMBALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cherry Pines' ,`TaxAmount` = '' ,`TaxRate` = '2.46' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699410' WHERE `Matrix_Unique_ID` = '210779318' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T10:10:58.697' ,`MLSNumber` = '97107162' ,`ListAgentFullName` = 'Nicole Hohman' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.780971' ,`Longitude` = '-95.320975' ,`PhotoCount` = '19' ,`PostalCode` = '77020' ,`RoomCount` = '5' ,`ListPrice` = '395000.00' ,`Status` = 'Active' ,`StreetName` = 'Nichols' ,`StreetNumber` = '4902' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1797' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stylish and affordable city living by Urbanlux Developments! 2-story with 3 bedrooms, 2.5\r\nbaths, 2-car garage and private driveway. Second floor living with soaring 12 foot ceilings.\r\nThe kitchen will feature a breakfast bar, GE stainless steel appliances, wine refrigerator,\r\npantry, shaker style cabinets, quartz countertops and engineered wood floors. 2 sizable guest\r\nrooms downstairs with a shared bathroom. Walk-in closets in every room. Extra side yard space!\r\nClose proximity to I-10 and East Downtown destinations! Approximate completion timeframe is\r\nAugust 2022.\r\nAsk us about affordable home grant loans!' ,`Acres` = '0.0551' ,`Area` = '2' ,`BuilderName` = 'Urban Lux' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 NICHOLS CORNER' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ATHERTON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Nichols Corner' ,`TaxAmount` = '576' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699410' WHERE `Matrix_Unique_ID` = '210894457' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T10:10:42.957' ,`MLSNumber` = '66748199' ,`ListAgentFullName` = 'Nicole Hohman' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.781259' ,`Longitude` = '-95.319963' ,`PhotoCount` = '21' ,`PostalCode` = '77020' ,`RoomCount` = '6' ,`ListPrice` = '389999.00' ,`Status` = 'Active' ,`StreetName` = 'Nichols' ,`StreetNumber` = '5009' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1767' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stylish and affordable city living by Urbanlux Developments! 2-story with 3 bedrooms, 2.5\r\nbaths, 2-car garage and private driveway. First floor living with with all bedrooms upstairs.\r\nFrench doors in the living room lead out to the backyard space. The kitchen will feature a\r\nbreakfast bar, GE stainless steel appliances, pantry, shaker style cabinets, quartz countertops\r\nand luxury vinyl plank floors. 2 sizable guest rooms with a shared bathroom. Walk-in closets in\r\nevery room. Close proximity to I-10 and East Downtown destinations! Less than 10 minutes away\r\nfrom the East River Project. Approximate completion timeframe is August 2022.\r\nAsk us about affordable home grant loans!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Urbanlux Development' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 Nichols Landing' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ATHERTON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Nichols Landing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699410' WHERE `Matrix_Unique_ID` = '210894785' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T10:14:48.493' ,`MLSNumber` = '10016083' ,`ListAgentFullName` = 'LaNelle McKay' ,`ListOfficeName` = 'Krisher-McKay, Inc., REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.820913' ,`Longitude` = '-95.031875' ,`PhotoCount` = '24' ,`PostalCode` = '77562' ,`RoomCount` = '10' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Highlands' ,`StreetNumber` = '8606' ,`StreetSuffix` = 'Crossing' ,`City` = 'Highlands' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2480' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '4/2.5/2 home in Highlands. This two story beauty offers a spacious living area, formal dining, kitchen with breakfast bar open to the breakfast and living areas. A spacious first floor primary, upstairs game room and three additional generous sized bedrooms and guest bath. The exterior offers a partially fenced backyard and covered patio. Convenient to I-10 and Spur 330 for a quick commute. Schedule your appointment today!' ,`Acres` = '0.153' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 48 BLK 1 HIGHLANDS CROSSING' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6665' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'HOPPER/HIGHLANDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Highlands Xing' ,`TaxAmount` = '4664' ,`TaxRate` = '2.235' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699410' WHERE `Matrix_Unique_ID` = '211001282' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T11:47:30.117' ,`MLSNumber` = '58280666' ,`ListAgentFullName` = 'Jessica Cejka' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.820776' ,`Longitude` = '-95.114826' ,`PhotoCount` = '24' ,`PostalCode` = '77360' ,`RoomCount` = '4' ,`ListPrice` = '180000.00' ,`Status` = 'Active' ,`StreetName` = 'South Canyon Circle' ,`StreetNumber` = '163' ,`StreetSuffix` = 'Road' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1039' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW HOME!! Welcome to Canyon Park, an East Texas subdivision in Onalaska, Texas off Highway 356. Located just over 1 mile from Lake Livingston, 80 miles north of Houston, the Onalaska area offers outdoor & recreational activities that provide fun for all ages. Conveniently located near a great selection of campgrounds, RV parks, marinas & restaurants. This spacious never-lived in 3/2 by Tru, the Glory model, is a single wide mobile home with open floor plan & modern details. Sitting on two lots it features 3 bedrooms, 2 baths, large living room, kitchen with dining area & a full-size utility room with ample space. \r\n\r\nPer survey done by seller, square footage is different than tax rolls. This property includes lot 93 (C0400-0316-00) and lot 94 (C0400-0317-00) for a total of 1.39 acres.\r\n\r\nReady for its new owners, it is vacant and easy to show. Call today to set up a time to see it!' ,`Acres` = '1.39' ,`Area` = '44' ,`BuilderName` = 'CMH Manufacturing' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CANYON PARK SECTION 2 LOT 93 and 94' ,`LotDesciption` = 'Cleared' ,`LotSize` = '60548' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '65' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Park Sec 2' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699410' WHERE `Matrix_Unique_ID` = '211135841' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T10:59:15.513' ,`MLSNumber` = '75509766' ,`ListAgentFullName` = 'Daniela Alarcon' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.751507' ,`Longitude` = '-95.343270' ,`PhotoCount` = '14' ,`PostalCode` = '77003' ,`RoomCount` = '1' ,`ListPrice` = '420000.00' ,`Status` = 'Active' ,`StreetName` = 'Ennis' ,`StreetNumber` = '307' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '708' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location, location!! Calling all investors to work on this great project, in one of the areas of rapid growth, the East End Revitalized area.\r\nThese 3 houses can be renovated to be used as long term rentals, or short vacation homes, since they are in a privileged location closed to Minute Maid Park, downtown area attractions' ,`Acres` = '0.1671' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 4 & 5 DUKE' ,`LotDesciption` = 'Other' ,`LotSize` = '7280' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BURNET ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Dukes Add' ,`TaxAmount` = '5790' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699411' WHERE `Matrix_Unique_ID` = '211318129' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T11:12:04.290' ,`MLSNumber` = '2820418' ,`ListAgentFullName` = 'Charles Vu' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.970530' ,`Longitude` = '-95.436278' ,`PhotoCount` = '14' ,`PostalCode` = '77014' ,`RoomCount` = '6' ,`ListPrice` = '230000.00' ,`Status` = 'Active' ,`StreetName` = 'Beckwith' ,`StreetNumber` = '13914' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'beautiful 1-story home in a great location, close to major freeways, local shopping and recreational areas nearby. Features include spacious entry way leads right into the formal dining with laminate flooring throughout, elegant living room with vaulted ceilings boasts openness, with built in shelves to open the wall between living and formal dining. Kitchen with granite counter tops. Both bathrooms have granite counter tops, with the master having separate shower and spa tub. Roof is less than 2 yrs old.' ,`Acres` = '0.1476' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 2 CRANBROOK SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6431' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CLARK ELEMENTARY SCHOOL (SPRING)' ,`SchoolHigh` = 'ANDY DEKANEY H S' ,`SchoolMiddle` = 'STELLE CLAUGHTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cranbrook Sec 01' ,`TaxAmount` = '3873' ,`TaxRate` = '2.7192' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663699411' WHERE `Matrix_Unique_ID` = '211318514' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T10:07:02.753' ,`MLSNumber` = '82518718' ,`ListAgentFullName` = 'Wendi Bangoy' ,`ListOfficeName` = 'Keller Williams SoutheastTexas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.075695' ,`Longitude` = '-94.033004' ,`PhotoCount` = '48' ,`PostalCode` = '75931' ,`RoomCount` = '3' ,`ListPrice` = '1334000.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Haven' ,`StreetNumber` = '223,323,373 & Lot 46' ,`StreetSuffix` = 'Drive' ,`City` = 'Brookeland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1936' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Custom Mediterranean Villas in the heart of Rayburn Country at Lake Sam Rayburn! These beautiful villas located on Oakhaven Dr in the unrestricted section 6 of Rayburn Country, make up a fruitful vacation rental business. All 3 villas feature 3 Bed / 3.5 Baths and offer guests\'/ owners\' close proximity to all of Lake Sam Rayburn\'s amenities from public boat ramps, state parks, Rayburn Resort, local restaurants/shopping and a plethora of outdoor sport/activities. This investment property is ready to welcome you and your family/guests to rest, relax and enjoy lake life transported through architecture and style. Investment information available upon request. Call today for more information!' ,`Acres` = '1.07' ,`Area` = '46' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 47 SEC 6 RAYBURN COUNTRY 808 /1043 0.28 ACRES' ,`LotDesciption` = 'Cleared,Corner,In Golf Course Community' ,`LotSize` = '46609' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '144 - Brookeland' ,`SchoolElementary` = 'BROOKELAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BROOKELAND HIGH SCHOOL' ,`SchoolMiddle` = 'BROOKELAND HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Rayburn Country' ,`TaxAmount` = '2630' ,`TaxRate` = '1.6721' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699411' WHERE `Matrix_Unique_ID` = '211370950' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T10:20:49.717' ,`MLSNumber` = '37352393' ,`ListAgentFullName` = 'Ashfaq Sharif' ,`ListOfficeName` = 'Avalon Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.723527' ,`Longitude` = '-95.757900' ,`PhotoCount` = '22' ,`PostalCode` = '77450' ,`RoomCount` = '11' ,`ListPrice` = '495000.00' ,`Status` = 'Active' ,`StreetName` = 'Davids Crest' ,`StreetNumber` = '22318' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3206' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous house in highly desired Cinco Ranch area. High ceiling. Open floor plan. Updated kitchen and wood floor. Great location and school.' ,`Acres` = '0.1913' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CINCO RANCH GREENWAY VILLAGE SEC 10, BLOCK 2, LOT 25' ,`LotDesciption` = 'Corner' ,`LotSize` = '8333' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1075' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WILLIAMS ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'BECK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cinco Ranch Greenway Village' ,`TaxAmount` = '7719' ,`TaxRate` = '2.4662' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699411' WHERE `Matrix_Unique_ID` = '211414172' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T11:50:36.750' ,`MLSNumber` = '79304196' ,`ListAgentFullName` = 'Sammy Younis' ,`ListOfficeName` = 'RE/MAX Southwest' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.619580' ,`Longitude` = '-95.612091' ,`PhotoCount` = '41' ,`PostalCode` = '77478' ,`RoomCount` = '12' ,`ListPrice` = '3299000.00' ,`Status` = 'Active' ,`StreetName` = 'Alkire Lake' ,`StreetNumber` = '323' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '6' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '7395' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNBELIEVABLE OPPORTUNITY TO OWN THIS GORGEOUS, MODERN 1.5 STORY ESTATE SITUATED ON A 2.3 ACRE WATERFRONT LOT IN HIGHLY DESIRABLE ALKIRE LAKE! ENJOY BREATHTAKING WATER VIEWS IN THE HEART OF SUGAR LAND! THIS ESTATE WILL IMPRESS FROM THE MOMENT YOU ENTER THE GATES & DRIVE UP THE CIRCULAR DRIVEWAY. BEAUTIFUL FRONT STUCCO ELEVATION W/COPPER ROOF. THIS ARCHITECTURAL MASTERPIECE IS DESIGNED TO HAVE BEAUTIFUL VIEWS FROM EVERY ROOM IN THE HOUSE BY WRAPPING AROUND A GORGEOUS POOL & COURTYARD. SOARING CATHEDRAL CEILINGS WITH WOOD BEAMS ACCENTED BY UPLIGHTING ARE FEATURED THROUGHOUT THE HOME. OVERSIZED WINDOWS ALLOW FOR PLENTY OF NATURAL LIGHT. CHEF\'S DREAM KITCHEN W/HIGH END APPLIANCES, QUARTZITE COUNTER TOPS, & ENDLESS CUSTOM CABINETRY. MASTER SUITE HAS VIEWS OF BOTH THE LAKE & POOL PLUS A SPA-LIKE MASTER BATH. OVERSIZED GAME ROOM, WET BAR, & LARGE FORMALS ARE PERFECT FOR ENTERTAINING! GUEST HOUSE W/FULL BATH & KITCHENETTE, OUTDOOR KITCHEN, LOW TAX RATE, & LOCATED MINUTES TO MAJOR FREEWAYS!' ,`Acres` = '2.3584' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land North' ,`HeatSystem` = 'Central Gas,Heat Pump,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'ALKIRE LAKE S/D SEC 2, BLOCK 1, LOT 10, ACRES 2.343' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '102730' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HIGHLANDS ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Alkire Lake' ,`TaxAmount` = '42628' ,`TaxRate` = '2.0299' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699411' WHERE `Matrix_Unique_ID` = '211426510' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T11:30:00.173' ,`MLSNumber` = '72940145' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.904512' ,`Longitude` = '-95.734231' ,`PhotoCount` = '6' ,`PostalCode` = '77433' ,`RoomCount` = '7' ,`ListPrice` = '380990.00' ,`Status` = 'Active' ,`StreetName` = 'Blue Tuna' ,`StreetNumber` = '21330' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2086' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Wildflower Collection \"Hanover II\" Plan with Elevation \"A\" in Marvida! This single-story home enjoys an open-concept layout that’s ideal for modern family living. A spacious kitchen overlooks the family room and attached covered patio, ready for indoor-outdoor entertaining. Two bedrooms are privately situated near the family room, while the owner’s suite boasts an en-suite bathroom and walk-in closet at the end of the home. \r\n\r\n*HOME ESTIMATED TO BE COMPLETE, DECEMBER, 2022*' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0005 BLK 002 LOT 037' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'ANDRE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Marvida' ,`TaxAmount` = '' ,`TaxRate` = '3.59' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699411' WHERE `Matrix_Unique_ID` = '211448144' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T10:32:15.113' ,`MLSNumber` = '27208805' ,`ListAgentFullName` = 'Kamica Hampton' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.477151' ,`Longitude` = '-98.344589' ,`PhotoCount` = '19' ,`PostalCode` = '78244' ,`RoomCount` = '8' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Lost Tree' ,`StreetNumber` = '5331' ,`StreetSuffix` = '' ,`City` = 'San Antonio' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2424' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 5331 Lost Tree located in San Antonio, TX. This home is in the limited access gated community of Woodlake Park. Designed to fulfill your single-family home dream wish list with all 3 bedrooms up and an expansive game room. Downstairs boasts a dining room and breakfast area with built in cabinetry. Proximity to shopping, dining, and entertainment. Schedule your tour today!' ,`Acres` = '0.1573' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CB 5080E BLK 37 LOT 17 WOODLAKE PARK SUBD UT-7D' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6851' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '151' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '634 - Judson' ,`SchoolElementary` = 'WOODLAKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KAREN WAGNER HIGH SCHOOL' ,`SchoolMiddle` = 'HENRY METZGER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodlake Park Sub' ,`TaxAmount` = '4511' ,`TaxRate` = '2.114' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699411' WHERE `Matrix_Unique_ID` = '211459791' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T10:28:21.557' ,`MLSNumber` = '14226046' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.655640' ,`Longitude` = '-95.118381' ,`PhotoCount` = '13' ,`PostalCode` = '77505' ,`RoomCount` = '15' ,`ListPrice` = '564927.00' ,`Status` = 'Active' ,`StreetName` = 'Highland' ,`StreetNumber` = '5515' ,`StreetSuffix` = 'Drive' ,`City` = 'Pasadena' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3005' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming two-story Louise home with 4 bedrooms, 3.5 baths and 2 car attached garage with storage. Convenient home office with French doors and open dining room tucked off foyer. Beautiful maple cabinets, quartz countertops and farmhouse sink in gourmet kitchen. Cozy tile fireplace with maple mantel in great room. Huge walk-in closet in owner\'s suite. Dual vanity sinks, separate tub and shower in owner\'s bath. Versatile activity room located upstairs. Bedrooms 2 and 3 share a Jack and Jill bath. Covered patio in backyard, perfect for entertaining. Offered by: K. Hovnanian Houston Parkway Trails, LLC.' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'K. Hovnanian' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '7/2/4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'JP DABBS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRMONT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkway Trails' ,`TaxAmount` = '' ,`TaxRate` = '2.6198' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699412' WHERE `Matrix_Unique_ID` = '211464552' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T10:58:07.810' ,`MLSNumber` = '6656749' ,`ListAgentFullName` = 'Loretta Blendermann' ,`ListOfficeName` = 'Legacy Texas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.219530' ,`Longitude` = '-95.741215' ,`PhotoCount` = '20' ,`PostalCode` = '77354' ,`RoomCount` = '6' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Rolling Hills' ,`StreetNumber` = '17702' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1856' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION...LOCATION Just off FM 1488 within the city limits of Magnolia on Rolling Hills Dr. sits The Little Blue House. It was once a home then a very busy Tea Room. Lots of potential here with the revamping of FM 1488 in this area. Beautiful 1.27 acre lot partially wooded. \r\nContact Agent for additional information.' ,`Acres` = '1.27' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'DOGWOOD PATCHES 01, BLOCK 1, LOT 3-B, MH LABEL # UNK, ACRES' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '55321' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'WILLIE E. WILLIAMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Dogwood Patches 01' ,`TaxAmount` = '3431' ,`TaxRate` = '2.2638' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699412' WHERE `Matrix_Unique_ID` = '211467908' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T11:24:45.390' ,`MLSNumber` = '15307886' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.656889' ,`Longitude` = '-95.117845' ,`PhotoCount` = '13' ,`PostalCode` = '77505' ,`RoomCount` = '16' ,`ListPrice` = '599412.00' ,`Status` = 'Active' ,`StreetName` = 'Fairfield' ,`StreetNumber` = '5510' ,`StreetSuffix` = 'Lane' ,`City` = 'Pasadena' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3386' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming two-story Arthur home with 4 bedrooms, 3.5 baths and 3 car attached garage with storage. Convenient home office with French doors tucked off foyer. Open dining room with easy access to gourmet kitchen. Beautiful maple cabinets, quartz countertops and farmhouse sink in gourmet kitchen. Cozy tile fireplace with Craftsman mantel in great room. Dual vanity sinks, separate tub and shower in owner\'s bath. Versatile loft space and serene media room located upstairs. All bedrooms feature walk-in closets. Covered patio in backyard, perfect for entertaining. Offered by: K. Hovnanian Houston Parkway Trails, LLC.' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'K. Hovnanian' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '21/2/4' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'JP DABBS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRMONT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkway Trails' ,`TaxAmount` = '' ,`TaxRate` = '2.6198' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699412' WHERE `Matrix_Unique_ID` = '211468418' --> Updated record success