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-11-12T20:13:29.363' ,`MLSNumber` = '71315739' ,`ListAgentFullName` = 'Dennis Dunlap' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.326560' ,`Longitude` = '-94.939898' ,`PhotoCount` = '29' ,`PostalCode` = '77563' ,`RoomCount` = '10' ,`ListPrice` = '499999.00' ,`Status` = 'Active' ,`StreetName` = 'Pompano' ,`StreetNumber` = '494' ,`StreetSuffix` = 'Street' ,`City` = 'Hitchcock' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2328' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '!!!!!!!!!HUGE PRICE REDUCTION!!!!! CANAL HOME IN HIGHLY SOUGHT NEIGBORHOOD OF BAYOU VISTA. JUST MINUTES TO GALVESTON AND QUICK ACCESS TO IH 45. HOME HAS 2 LIVING AREA. THE UPSTAIRS HAS A OPEN CONCEPT BETWEEN LIVING ROOM AND KITCHEN. THE UPSTAIRS HAS 3 BEDROOMS AND 2 BATH WITH WOOD FIREPLACE. IT ALSO HAS A COVERED PORCH AND A SUN PORCH DETACHED FROM THE HOUSE THAT IS GREAT FOR ALL SOCIAL EVENTS. THIS IS ALSO A GREAT INVESTMENT PROPERTY. FLOORING UPSTAIRS IS HARDWOOD FLOORS AND KITCHEN HAS VERY NICE AND SPACIUOS CABINETS. DOWNSTAIRS IS 1 BEDROOM/1BATH EFFENCIECY APARTMENT WITH ITS OWN SHOWER AND HAS ITS OWN AC SYSTEM. THIS IS ALSO A GREAT PLACE FOR THE SPORTSMAN WITH A COVERED BOAT SHED WITH ELECTRIC LIFT. SHED IS EQUIPED WITH FISHING LIGHTS AND A FISH CLEANING STATION. ALL MEASUREMENTS ARE APPROXIMATE. PLEASE VERIFY SCHOOL ZONE DISTRICT. ALL MEASURENTS ARE APPROXIMATE SO PLEASE VERIFY.' ,`Acres` = '0.1267' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bayou Vista' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 7 PAGE 7 LOT 494 NEW BAYOU VISTA ADDN 4A' ,`LotDesciption` = 'Cleared,Waterfront' ,`LotSize` = '5520' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Convection Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HAYLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Left Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'New Bayou Vista 4a' ,`TaxAmount` = '8417' ,`TaxRate` = '2.635' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418264' WHERE `Matrix_Unique_ID` = '209635771' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T20:02:32.340' ,`MLSNumber` = '53734556' ,`ListAgentFullName` = 'Sammy Younis' ,`ListOfficeName` = 'RE/MAX Southwest' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.490549' ,`Longitude` = '-95.530193' ,`PhotoCount` = '48' ,`PostalCode` = '77459' ,`RoomCount` = '12' ,`ListPrice` = '1388000.00' ,`Status` = 'Active' ,`StreetName` = 'Sanctuary' ,`StreetNumber` = '19' ,`StreetSuffix` = 'Trail' ,`City` = 'Missouri City' ,`BathsFull` = '6' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '6650' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LUXURIOUS CUSTOM ESTATE LOCATED IN ONE OF SIENNA\'S PRESTIGIOUS GATED COMMUNITIES! SITUATED ON A NEARLY 3/4 ACRE LOT W/FABULOUS LAKE AND GOLF COURSE VIEWS! YOU WILL BE IMPRESSED FROM THE MOMENT YOU ARRIVE! GORGEOUS FRONT ELEVATION W/TILE ROOF AND CIRCLE DRIVEWAY. DOUBLE DOORS LEAD TO A DRAMATIC ENTRY W/SOARING CEILINGS, DOUBLE STAIRCASES, CUSTOM CEILING TREATMENTS AND GRAND CHANDELIER. TERRIFIC FLOOR PLAN W/3 BEDROOMS DOWN, 2 OFFICES, MULTIPLE LIVING AREAS, GAMEROOM, MEDIA (BONUS) RM, WINE GROTTO AND SO MUCH MORE. LUXURIOUS MASTER SUITE, SPA-LIKE MASTER BATH W/OVERSIZED SHOWER, & HIS/HERS CLOSETS. MAGAZINE WORTHY DESIGNER DETAILS THROUGHOUT! GORGEOUS, PARK-LIKE BACK YARD W/RESORT STYLE POOL & HOT TUB, MULTIPLE SEATING AREAS, OUTDOOR KITCHEN AND TONS OF LAND. TERRIFIC FORT BEND SCHOOLS! RARE OPPORTUNITY TO LIVE IN THIS UNIQUELY MAGNIFICENT HOME WHICH IS ONE OF ONLY 12 HOMES LOCATED IN THIS EXCLUSIVE GATED COMMUNITY. CALL THE AIDA YOUNIS TEAM TODAY!' ,`Acres` = '0.6099' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIENNA VILLAGE OF WATERS LAKE SEC 11, BLOCK 1, LOT 5' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,On Golf Course,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '26566' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3989' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SCANLAN OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Sienna' ,`TaxAmount` = '28887' ,`TaxRate` = '2.6079' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418264' WHERE `Matrix_Unique_ID` = '210118042' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T19:58:43.990' ,`MLSNumber` = '94084535' ,`ListAgentFullName` = 'Ahmad Adam' ,`ListOfficeName` = 'Adam Group Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.719617' ,`Longitude` = '-95.827936' ,`PhotoCount` = '38' ,`PostalCode` = '77494' ,`RoomCount` = '11' ,`ListPrice` = '639500.00' ,`Status` = 'Active' ,`StreetName` = 'Bell Mountain' ,`StreetNumber` = '4802' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3745' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Stunning home features the ultimate luxury privacy. No rear neighbors, a beautiful elevation with brick and stone, a gorgeous entryway with a tall ceiling, and a secluded and spacious master with a high ceiling and bay window that opens to a beautiful backyard; retreat highlights this Taylor Morrison home. This sought-after floor plan features soaring ceilings, a large media room with built-in speakers, a screen, a projector, and an elegant study with a custom build in bookshelf and desk millwork. Spacious Gameroom upstairs with lots of windows. A beautiful covered patio and a second-story balcony overlook Georges\'s backyard, green space, and water views. The kitchen features a butler\'s pantry, custom cabinets, under-counter lighting, stainless steel appliances, and exotic granite. Three-car garage. New water heaters, New Carpet throughout the upstairs, and fresh paint. Water softener, reverse osmosis with cold and hot water, Never flooded. Great Katy schools.' ,`Acres` = '0.2054' ,`Area` = '36' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CINCO RANCH SOUTHWEST SEC 27, BLOCK 1, LOT 9' ,`LotDesciption` = 'Greenbelt,Subdivision Lot,Water View' ,`LotSize` = '8946' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WILSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'TOMPKINS HIGH SCHOOL' ,`SchoolMiddle` = 'TAYS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cinco Ranch Southwest Sec 27' ,`TaxAmount` = '11509' ,`TaxRate` = '2.7045' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418264' WHERE `Matrix_Unique_ID` = '211200036' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T20:22:32.080' ,`MLSNumber` = '67234764' ,`ListAgentFullName` = 'Reyna Portillo' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.600093' ,`Longitude` = '-95.212687' ,`PhotoCount` = '24' ,`PostalCode` = '77089' ,`RoomCount` = '3' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = 'Sagehollow' ,`StreetNumber` = '11618' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1807' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'welcome to 11618 , This home has been beautifully remodeled . Bring your picky buyers and schedule a viewing soon.' ,`Acres` = '0.1641' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 12 SAGEMONT SEC 3' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'STUCHBERY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'THOMPSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Sagemont Sec 03' ,`TaxAmount` = '3773' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418265' WHERE `Matrix_Unique_ID` = '211321873' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T20:02:03.590' ,`MLSNumber` = '69149354' ,`ListAgentFullName` = 'Monique Burks' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.714324' ,`Longitude` = '-95.666585' ,`PhotoCount` = '28' ,`PostalCode` = '77082' ,`RoomCount` = '3' ,`ListPrice` = '255000.00' ,`Status` = 'Active' ,`StreetName` = 'Vineyard' ,`StreetNumber` = '3903' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1699' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3/2/2 patio home. Great floor plan that has formal dining and breakfast areas, family room and living room. Kitchen has updated cabinets with pullouts and large pan doors. Refrigerator stays. Great fireplace in family room. Sunroom off of breakfast area. Two covered patios and another patio area in front of house. Nicely landscaped yard area. Convenient to Hwy 6 and Westpark Tollway. Room dimensions are approximate.' ,`Acres` = '0.124' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 23 BLK 14 WINGATE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'REES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'ALBRIGHT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wingate Sec 02' ,`TaxAmount` = '4179' ,`TaxRate` = '2.4927' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418265' WHERE `Matrix_Unique_ID` = '211346458' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T20:30:16.663' ,`MLSNumber` = '75462322' ,`ListAgentFullName` = 'Ja\'Marcus Gilbert' ,`ListOfficeName` = 'TDRealty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.852017' ,`Longitude` = '-95.631364' ,`PhotoCount` = '50' ,`PostalCode` = '77084' ,`RoomCount` = '4' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Four Season' ,`StreetNumber` = '15618' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2394' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Near energy corridor, open floor plan with high ceilings as you enter this home. Two living areas gives you enough space for everyone, granite counter top on kitchen and all bathroom. No carpet in this house for the allergy sufferers. All bedrooms have walk-in closets. New paint throughout. Two huge live oak trees in the front yard and spacious backyard.' ,`Acres` = '0.2009' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TR 59 & TR 60A BLK 31 BEAR CREEK VILLAGE SEC 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '460' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BEAR CREEK ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CARDIFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bear Creek Village Sec 12' ,`TaxAmount` = '4395' ,`TaxRate` = '2.1736' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418265' WHERE `Matrix_Unique_ID` = '211760684' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T19:40:10.497' ,`MLSNumber` = '50366573' ,`ListAgentFullName` = 'Purva Shah' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.924195' ,`Longitude` = '-95.700015' ,`PhotoCount` = '48' ,`PostalCode` = '77433' ,`RoomCount` = '11' ,`ListPrice` = '2330000.00' ,`Status` = 'Active' ,`StreetName` = 'Austin Bayou' ,`StreetNumber` = '19211' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '6' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '7609' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A Magnificent Mediterranean Estate built in coveted Towne Lake. This extravagant custom-built home situated on almost 3/4th of an acre of double lot (Lot # 19211&19207) offers luxurious living spaces in a secure setting within a gated community. Step into a soaring 30’ foyer overlooking fire pit, summer kitchen, covered veranda, pavilion and spectacular pool with all the imaginable features. Casita offers an inherent flexibility to guests and owner’s privacy. The home was built to create a living experience that accommodates both large scale entertainment & warm living room inviting family life. The main house offers 5 bed, 5 full & 1 half-bath, executive office, game room, media room, gourmet kitchen, catering kitchen, butler’s pantry, formal dining with dry bar, 2 staircases, 4-car garage with golf cart parking space. Backyard retreat with lush landscaping & expansive lawn. Home boasts natural lighting & high-end elegant custom finishes throughout. Ask listing agent for exclusions.' ,`Acres` = '0.722' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 3 TOWNE LAKE SEC 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '31493' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2249' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'RENNELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Towne Lake' ,`TaxAmount` = '49091' ,`TaxRate` = '3.091' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668418265' WHERE `Matrix_Unique_ID` = '212103966' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T20:32:30.990' ,`MLSNumber` = '59184652' ,`ListAgentFullName` = 'Kimbriana Nzeogu' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.467176' ,`Longitude` = '-95.529582' ,`PhotoCount` = '26' ,`PostalCode` = '77459' ,`RoomCount` = '10' ,`ListPrice` = '610000.00' ,`Status` = 'Active' ,`StreetName` = 'Morning Glow' ,`StreetNumber` = '8810' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3048' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Luxury living in the highly desired Master Planned Community of Sienna with resort style amenities. This new construction, move-in ready Perry Home has NEVER been lived in. Meticulously crafted open-concept floor plan offers a 2-story family room and dining room with soaring 19\' ceilings, great for entertaining. With 5 bedrooms and 4.5 bathrooms, there is a bathroom for almost every room in the house. Home office with French doors is set at the 2-story entryway, very convenient for remote work. Chef\'s kitchen featuring engineered stone countertops overlooks the family room with a wall of windows. The massive primary suite does not disappoint with ensuite bathroom including 2 walk-in closets, double vanities, stand up shower, separate spa tub and private toilet room. As a bonus, there is a secondary bedroom with a full ensuite bathroom on the first floor. Custom shutters have been newly installed in each bedroom. Extended covered patio and oversized backyard complete this Smart Home.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Sienna - Section 32A, LOT 23, BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7490' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668418266' WHERE `Matrix_Unique_ID` = '212276654' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T19:21:33.320' ,`MLSNumber` = '67268617' ,`ListAgentFullName` = 'Wayne Cohen' ,`ListOfficeName` = 'Bernstein Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.795329' ,`Longitude` = '-95.419672' ,`PhotoCount` = '37' ,`PostalCode` = '77008' ,`RoomCount` = '8' ,`ListPrice` = '825000.00' ,`Status` = 'Active' ,`StreetName` = '14th' ,`StreetNumber` = '2010B' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '3' ,`SqFtTotal` = '2770' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully maintained home with quality finishes throughout on a cul-de-sac street in the greater Heights area. Bright and light open-concept first-floor living perfect for entertaining. Convenient island kitchen with stove top and breakfast bar. All bedrooms en-suite are up and the primary bedroom features two separate sinks, two toilets, and two closets. No sharing is required. Recently refinished pristine hardwoods in the living area and 2nd floor. Fresh paint throughout. The living room transitions to the backyard with a huge elevated deck and an easement/green space, creating the feeling of an even larger open space that is hard to find in The Heights area. Easy access to the White Oak trail, fantastic restaurants, and coffee shops. Did not flood during Harvey.' ,`Acres` = '0.1156' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Timbergrove/Lazybrook' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 1 SHADY PINES SEC 1' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '5035' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean,Traditional' ,`Subdivision` = 'Shady Pines/Houston Heights' ,`TaxAmount` = '11164' ,`TaxRate` = '2.33' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1668418266' WHERE `Matrix_Unique_ID` = '212460286' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T19:16:59.797' ,`MLSNumber` = '19721872' ,`ListAgentFullName` = 'Dan Anh Ngo' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.536335' ,`Longitude` = '-95.284179' ,`PhotoCount` = '36' ,`PostalCode` = '77584' ,`RoomCount` = '7' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Chartham' ,`StreetNumber` = '3917' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2048' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 3917 Chartham Ln, which sits on a quiet cul-de-sac lot of Canterbury Park & zoned to award-winning PISD. This COZY, WELL-MAINTENANCE home has it all. A formal living room and the kitchen merge together to create an open, spacious common area on the full tile 1st floor. Kitchen features ELEGANT COUNTERTOP, HIGH-QUALITY GE APPLIANCES, and ENERGY EFFECTIVE LED-LIGHTING with plenty of cabinets for storage. The 2nd floor is where all the bedrooms and 3 full baths are located. It even offers the 2nd PRIMARY BEDROOM WITH ITS OWN FULL BATH. All rooms have big windows to catch natural sunlight and decent size closets. Beautiful white stone upgraded front elevation. An oversized backyard can fit a pool and great ideal for family barbecues or gardening. Wifi thermostat and garage door. Very safe neighborhood, with less than 10\' access to HEB, Walmart, and shopping/dining areas. The recreation center and natatorium are within distance. This is a MUST SEE!' ,`Acres` = '0.1867' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CANTERBURY PARK SEC 6 (A0507-A0508 ACH&B) (PEARLAND) BLK 2 L' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '8133' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '265' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'MAGNOLIA ELEMENTARY SCHOOL (PEARLAND)' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH SOUTH' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'Canterbury Park Sec 6' ,`TaxAmount` = '8603' ,`TaxRate` = '3.3751' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418266' WHERE `Matrix_Unique_ID` = '212584890' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T19:23:57.270' ,`MLSNumber` = '29555816' ,`ListAgentFullName` = 'Brooke Browning' ,`ListOfficeName` = 'Keller Williams Hou Preferred' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.657685' ,`Longitude` = '-95.082722' ,`PhotoCount` = '17' ,`PostalCode` = '77571' ,`RoomCount` = '8' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Charmont' ,`StreetNumber` = '10002' ,`StreetSuffix` = 'Road' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1864' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the highly sought-after subdivision of Fairmont Park West in La Porte. Walk inside to be greeted with several upgrades in the kitchen including counters, new cabinets, subway-tiled backsplash, stainless steel appliances, and as an added bonus the fridge is included. Take in the spacious open-concept living room/dining combo to view the beautifully upgraded flooring and fresh paint throughout. This split plan offers 4 bedrooms with walk-in closets and 2 bathrooms. The primary suite is oversized with new double-sink vanity and a separate room for bathing/showering. Mosey on over to the other side of the house to view the other three rooms and the new vanity in the jack & jill bath. Enjoy the upgraded energy-efficient windows throughout. Exit to the fully fenced backyard which boasts a covered decking area perfect for entertaining, cooking, or relaxing after some gardening in the raised bed.' ,`Acres` = '0.154' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 24 FAIRMONT PARK WEST SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6710' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'JENNIE REID ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LOMAX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Right Side,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairmont Park West Sec 02' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418266' WHERE `Matrix_Unique_ID` = '212585660' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T19:22:11.913' ,`MLSNumber` = '4581515' ,`ListAgentFullName` = 'Alberto Mendez' ,`ListOfficeName` = 'Tu Casa Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.858347' ,`Longitude` = '-95.678774' ,`PhotoCount` = '36' ,`PostalCode` = '77084' ,`RoomCount` = '8' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Holly Forest' ,`StreetNumber` = '18143' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2486' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Renovated House! Brand porcelain wood tile on ground floor and bath on 2nd floor. Kitchen has granite counter tops, stainless steel farm sink, white light cabinets, brand new new GE appliances ( never used) brand new faux wood blinds on every window. All the bathrooms with undermount sinks and contemporary faucet. Principal bath has Ceramic wall tile and Frameless glass, bedrooms has new carpet and ceiling fans. House have been recently painted swiss Coffee. You have plenty room on the backyard for new project and design. The AC compressor unit has been replaced in 2018. This contemporary house has an excellent location, the playground and clubhouse are located across the street.' ,`Acres` = '0.1487' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 2 WINDSONG SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6477' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '430' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WILSON ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'WATKINS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Windsong' ,`TaxAmount` = '6734' ,`TaxRate` = '2.5618' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418266' WHERE `Matrix_Unique_ID` = '212711443' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T19:23:51.983' ,`MLSNumber` = '10491428' ,`ListAgentFullName` = 'Luis F. Mendoza' ,`ListOfficeName` = 'Veronica Mendoza Realty, LLC.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.555197' ,`Longitude` = '-95.633495' ,`PhotoCount` = '50' ,`PostalCode` = '77479' ,`RoomCount` = '11' ,`ListPrice` = '695000.00' ,`Status` = 'Active' ,`StreetName` = 'Cranston' ,`StreetNumber` = '5527' ,`StreetSuffix` = 'Court' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3212' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Largest lot in Subdivision, two story entry foyer with curved stairs, offers formal areas, home office, family den, ample kitchen, breakfast bar and ,morning area, all ceramic tile and wood floors (no carpet) main bedroom down, game room up, lots of crown moldings and custom closets, custom attic space, big patio cover with bar, superb sparkling pool and spa with a huge back yard.' ,`Acres` = '0.3417' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'AVALON - VILLAGES OF AVALON SEC 3, BLOCK 3, LOT 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14886' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'COMMONWEALTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'FORT SETTLEMENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Villages Of Avalon Sec 3' ,`TaxAmount` = '11043' ,`TaxRate` = '2.1244' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418267' WHERE `Matrix_Unique_ID` = '212989709' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T19:38:34.730' ,`MLSNumber` = '24350176' ,`ListAgentFullName` = 'Wayne Cohen' ,`ListOfficeName` = 'Bernstein Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.815759' ,`Longitude` = '-95.453213' ,`PhotoCount` = '49' ,`PostalCode` = '77092' ,`RoomCount` = '12' ,`ListPrice` = '999000.00' ,`Status` = 'Active' ,`StreetName` = 'Havel' ,`StreetNumber` = '3003' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4841' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Terrific custom 5-bedroom home on a 12,000+ lot (per HCAD) on a quiet cul-de-sac. Sides to green belt and no through traffic.\r\nRecent updates include interior and exterior painting,new carpet upstairs (July 2022-per seller), and complete home power washing to the exterior. Additional detailed update/maintenance list attached to docs. An impressive marble floor entry leads to a huge family room with high ceilings, and tons of natural light. The kitchen boasts an abundance of cabinets and counter space. The massive upstairs game room offers many possibilities. The shed in the backyard could be a workstation as it has electricity and was built on-site. Oversized garage with additional space for storage. Close to many new restaurants, and coffee shops, with easy access to the energy corridor, downtown, and galleria.' ,`Acres` = '0.2804' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 800 BLK 42 SHEPHERD FOREST SEC 3' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '12213' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'STEVENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Shepherd Forest/Oak forest Area' ,`TaxAmount` = '17152' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418267' WHERE `Matrix_Unique_ID` = '213240188' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T20:19:02.970' ,`MLSNumber` = '22075303' ,`ListAgentFullName` = 'Janna Westerbeck' ,`ListOfficeName` = 'Way Maker Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.421835' ,`Longitude` = '-95.236716' ,`PhotoCount` = '25' ,`PostalCode` = '77511' ,`RoomCount` = '4' ,`ListPrice` = '324900.00' ,`Status` = 'Active' ,`StreetName` = 'Shirley' ,`StreetNumber` = '335' ,`StreetSuffix` = 'Street' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1947' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful three-bedroom, two bath home on over a half of an acre cul-de-sac lot! The updated kitchen boasts granite countertops, stainless steel appliances and is open to the dining room and family room. The over-sized back yard is a rare find and has so many possibilities. This home offers a split floorplan with primary bedroom suite on one side and two bedrooms on the other. The three-car tandem garage is a dream, great for storage and will easily fit a small trailer/boat. Convenient location with walking trails nearby. Low taxes, no HOA and never flooded! Call today to schedule a showing of this amazing property!' ,`Acres` = '0.567' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TOWNE OAKS NORTHEAST (ALVIN) LOT 15 ACRES .567' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '24699' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'HASSE ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRVIEW JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Towne Oaks Northeast Alvin' ,`TaxAmount` = '6919' ,`TaxRate` = '2.8854' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418267' WHERE `Matrix_Unique_ID` = '213344842' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T19:25:17.517' ,`MLSNumber` = '2623255' ,`ListAgentFullName` = 'Sara Jimenez' ,`ListOfficeName` = 'RE/MAX Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.230305' ,`Longitude` = '-95.573345' ,`PhotoCount` = '45' ,`PostalCode` = '77354' ,`RoomCount` = '7' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Durango Creek' ,`StreetNumber` = '6843' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1992' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Move in Before the Holidays! Located minutes from The Woodlands, this spacious home backs up to a Greenbelt with zero back neighbors. The screened in porch adds extra space to enjoy the outdoors while the inside is equipped with tile and wood flooring throughout, high ceilings, granite counter tops, under mount lighting in the kitchen, and a large game room or flex space upstairs. The downstairs living room is wired for surround sound as well. The open concept allows for easy entertaining with plenty of room in the kitchen while overlooks the dining room/living room combo. This is a must see. Room dimensions are approximate, please independently verify.' ,`Acres` = '0.1263' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S406602 - DURANGO CREEK 02, BLOCK 1, LOT 11' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '440' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'BEAR BRANCH ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Durango Creek 02' ,`TaxAmount` = '4152' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418267' WHERE `Matrix_Unique_ID` = '213465967' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T20:55:31.177' ,`MLSNumber` = '47958632' ,`ListAgentFullName` = 'Eva Wolf' ,`ListOfficeName` = 'RE/MAX Elite Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.919663' ,`Longitude` = '-95.666726' ,`PhotoCount` = '37' ,`PostalCode` = '77095' ,`RoomCount` = '10' ,`ListPrice` = '355000.00' ,`Status` = 'Active' ,`StreetName` = 'Bluff Springs' ,`StreetNumber` = '16514' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2477' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great four-bedroom home in the master planned GOLF COURSE community of Stonegate. This home has never flooded and is not in a flood plain. A large oak tree is in the front yard and landscaping is lush in the front and back yard. Kitchen features GRANITE countertops, GAS stove, an upgraded Tiffany styled light fixure and is open to family room. Great location with easy access to 290. This home is in the award-winning Cy-Fair School district. \r\nWood floors, new carpet, and POOL and SPA! Cul-de-sac lot, GATED section of Stonegate.' ,`Acres` = '0.1104' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 43 BLK 2 STONE GATE SEC 14' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '4810' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1140' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'BIRKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'SPILLANE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Stone Gate Sec 14' ,`TaxAmount` = '6418' ,`TaxRate` = '2.561' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418268' WHERE `Matrix_Unique_ID` = '213641931' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T20:52:47.007' ,`MLSNumber` = '30685566' ,`ListAgentFullName` = 'Melody Oviedo' ,`ListOfficeName` = 'Sean Powers Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.839485' ,`Longitude` = '-94.833391' ,`PhotoCount` = '10' ,`PostalCode` = '77523' ,`RoomCount` = '4' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Meadowlands' ,`StreetNumber` = '14519' ,`StreetSuffix` = 'Drive' ,`City` = 'Mont Belvieu' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2857' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home ready for move in!' ,`Acres` = '0.2569' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BK 6 LAKES OF CHAMPIONS SEC 2B PHASE 2' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '11191' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL NORTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL NORTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes/Champion Estates Sec 2b Ph' ,`TaxAmount` = '7896' ,`TaxRate` = '2.1606' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418268' WHERE `Matrix_Unique_ID` = '213689106' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T19:45:32.580' ,`MLSNumber` = '70983390' ,`ListAgentFullName` = 'Glenda Johnson' ,`ListOfficeName` = 'A Action Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.849248' ,`Longitude` = '-95.197344' ,`PhotoCount` = '44' ,`PostalCode` = '75862' ,`RoomCount` = '2' ,`ListPrice` = '260000.00' ,`Status` = 'Active' ,`StreetName` = 'White Perch' ,`StreetNumber` = '142' ,`StreetSuffix` = 'Lane' ,`City` = 'Trinity' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1512' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cozy and well maintained home on 5 lots. This two bedroom one bath has a large livingroom and dining area.\r\nThe back porch is perfect for entertaining guest or just enjoying the evening relaxing. Flower garden is just around the corner of home with built in pond. Nice greenhouse for the plants great for the gardners of the family . Pool has a nice open deck ideal for those warm summer days. Guest Cottage is just across the yard with a mini kitchen, half bath and an outdoor shower. The lots are connected from one road to the other. Garage sits on the back lots with plent of room to store items. Garge has 3 roll up doors for convient access. Seller will sell furnished with full price offer. Subdivision has a boat ramp. Schedule your showing today.' ,`Acres` = '0.574' ,`Area` = '42' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'HAWG HEAVEN SECTION 2, LOT 351,352,385,386' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '25000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '59 - Groveton' ,`SchoolElementary` = 'GROVETON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GROVETON J H-H S' ,`SchoolMiddle` = 'GROVETON J H-H S' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Hawg Heaven Sec 2' ,`TaxAmount` = '2266' ,`TaxRate` = '1.5582' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418268' WHERE `Matrix_Unique_ID` = '213766626' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T19:41:37.307' ,`MLSNumber` = '59397651' ,`ListAgentFullName` = 'Lori Meadows' ,`ListOfficeName` = 'Accustar Realty' ,`SellingAgentFullName` = 'Luis Aguilar' ,`SellingOfficeName` = 'RE/MAX Northwest, REALTORS' ,`Latitude` = '30.030157' ,`Longitude` = '-95.520678' ,`PhotoCount` = '42' ,`PostalCode` = '77379' ,`RoomCount` = '6' ,`ListPrice` = '274900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Seven Pines' ,`StreetNumber` = '17215' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2206' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Updates Galore! 4 bedrooms, 2.5 bath with 2 car detached garage. This house has been completely updated and turn key ready! Updated lighting throughout, as you walkthrough the door you walk into a spacious living room with wood like tile throughout the entire first floor with 5 1/2 inch baseboards. Entertain your guests and family in your formal dining room or create a play room or den for the kids. This house has a grandeur look with updated door knobs, ceiling fans, updated lighting. Kitchen with all updated appliances, granite counter tops, subway tile backsplash. Keep your family cool with the AC unit recently installed. As you walk up the stairs, feel the soft updated carpet throughout the second floor. Fresh paint inside and out. Roof installed 9/22. Klein schools.' ,`Acres` = '0.1616' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 8 017*O0118825-001-008-024 OAKWOOD GLEN SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7040' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '492' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'EHRHARDT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oakwood Glen Sec 01' ,`TaxAmount` = '4644' ,`TaxRate` = '2.5085' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418268' WHERE `Matrix_Unique_ID` = '213992227' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T20:59:57.210' ,`MLSNumber` = '86239797' ,`ListAgentFullName` = 'Martha Perez' ,`ListOfficeName` = 'Texas MAP Real Estate' ,`SellingAgentFullName` = 'Maria Morales' ,`SellingOfficeName` = 'Jerry Fullerton Realty, Inc.' ,`Latitude` = '29.824962' ,`Longitude` = '-95.278402' ,`PhotoCount` = '11' ,`PostalCode` = '77028' ,`RoomCount` = '3' ,`ListPrice` = '215000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Tommye' ,`StreetNumber` = '6808' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1198' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Recently updated home with 3 bedroom with 2 bathrooms.Nice home close to 610 and 59, minutes from downtown.\r\nP' ,`Acres` = '0.1779' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 27A BLK 4 JUNE GARDENS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7749' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ELMORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'June Gardens' ,`TaxAmount` = '1404' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418268' WHERE `Matrix_Unique_ID` = '214064466' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T19:14:29.963' ,`MLSNumber` = '58646598' ,`ListAgentFullName` = 'Karim Tahri' ,`ListOfficeName` = 'K & T Realty Group, Inc.' ,`SellingAgentFullName` = 'Tod Frazer' ,`SellingOfficeName` = 'Erwing Realty' ,`Latitude` = '29.818939' ,`Longitude` = '-95.312224' ,`PhotoCount` = '38' ,`PostalCode` = '77028' ,`RoomCount` = '5' ,`ListPrice` = '239000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Shotwell' ,`StreetNumber` = '6522' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1665' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome! Don\'t miss the opportunity to live in this newly-built beautiful home with 3 bedrooms, 2 1/2 baths, 2 car garage, living room, dining room, and a nice kitchen with indoor utility room. There\'s a roomy covered patio in rear with sink and access to separate half bath. This amazing home also has a SPACIOUS BACKYARD perfect for family gatherings. The kitchen has a range and microwave. It is only less than 10 miles to Downtown Houston, 15 miles to both George Bush Intercontinental Airport and Hobby Airport, 12 MILES TO TEXAS MEDICAL CENTER, AND 15 MILES TO MEMORIAL PARK.\r\nWhat are you waiting for? Schedule your showing today!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'N/A' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 SHOTWELL SQUARE' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'COOK ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'SHOTWELL SQUARE' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668418269' WHERE `Matrix_Unique_ID` = '214083820' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T19:42:22.157' ,`MLSNumber` = '87067642' ,`ListAgentFullName` = 'Susan Freese' ,`ListOfficeName` = 'Freese & Co. ' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.299389' ,`Longitude` = '-96.086655' ,`PhotoCount` = '18' ,`PostalCode` = '77488' ,`RoomCount` = '7' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Salisbury' ,`StreetNumber` = '737' ,`StreetSuffix` = 'Lane' ,`City` = 'Wharton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1879' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great find!!! Over 5 acres with brick home sitting on the edge of the city limits. So convenient yet space for your country dreams. City water but NO city taxes. This home faces Salisbury Lane with the hay meadow extending from Wisteria Street to Kingston Street (if those streets extended back to this property). Many opportunities for development or your personal enjoyment. Roof - 2014; aerobic septic system - 2014; garage doors - Jan 2016; water heater (gas) - Apr 2018; Central Air and Heat (gas) - Aug 2020; master shower remodeled - Jan 2020.\r\nFormal living, three good size bedrooms, kitchen opens to huge family room, oversized utility room, great storage, built in desk and cabinetry, double garage, pecan and fruit trees dot this beautiful corner lot.' ,`Acres` = '5.7' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Blk 12D,12N' ,`LotDesciption` = 'Corner' ,`LotSize` = '249598' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '180 - Wharton' ,`SchoolElementary` = 'CG SIVELLS/WHARTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHARTON HIGH SCHOOL' ,`SchoolMiddle` = 'WHARTON JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Briargrove' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418269' WHERE `Matrix_Unique_ID` = '214088009' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T19:11:29.133' ,`MLSNumber` = '79517508' ,`ListAgentFullName` = 'James Pitman' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.724212' ,`Longitude` = '-95.367777' ,`PhotoCount` = '24' ,`PostalCode` = '77004' ,`RoomCount` = '6' ,`ListPrice` = '474900.00' ,`Status` = 'Active' ,`StreetName` = 'Rosewood' ,`StreetNumber` = '2801' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1999' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You will fall in love with this beautifully updated 3 bedroom 2 bath home. It is one of the largest single-story homes in the area and is conveniently within 10 minutes of the Medical Center, Downtown, Museum District, Montrose, the zoo, and quite literally hundreds of restaurants. Remodeled in 2020, this turnkey smart home will impress from the moment you walk through the arched front door. You will love the spacious feeling you get from the 10\' ceilings and your eyes will be drawn to the designer elements throughout. Having the roof, HVAC, plumbing, and foundation all replaced or upgraded during the renovation will bring you additional peace of mind. Additionally, the new fenced-in yard, with an electric gate, is perfect for your furry four-legged friends. May this home be your new sanctuary deep in the heart of Houston.' ,`Acres` = '0.1687' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 22 & TR 21 BLK 31 WASHINGTON TERRACE' ,`LotDesciption` = 'Corner' ,`LotSize` = '7350' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOCKHART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Washington Terrace' ,`TaxAmount` = '8437' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1942' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418269' WHERE `Matrix_Unique_ID` = '214183124' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T19:18:10.680' ,`MLSNumber` = '95098594' ,`ListAgentFullName` = 'Julie Woods' ,`ListOfficeName` = 'RE/MAX Space Center-Clear Lake' ,`SellingAgentFullName` = 'Rachel Page' ,`SellingOfficeName` = 'Southern Gold Realty' ,`Latitude` = '29.545038' ,`Longitude` = '-95.207655' ,`PhotoCount` = '37' ,`PostalCode` = '77546' ,`RoomCount` = '11' ,`ListPrice` = '920000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Southfield' ,`StreetNumber` = '505' ,`StreetSuffix` = 'Drive' ,`City` = 'Friendswood' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '3667' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Step into the grand entry of this beautiful Brentwood custom home & you will know this family made many wonderful memories here. Lot is largest & most private in Northfield Estates. Enjoy the salt water pool with water feature, hot tub, sunning deck & in-pool table and seats. 3 car garage attached to house and 2 car detached with carport & 1,300 sf space above the garage ready for whatever you can dream. Throughout the home you will notice custom crown molding, amazing door & window casings, beautiful ceilings, built-in cabinets & shelves. Incredible oversized dining room for family gatherings. Private study w/built-ins. Kitchen includes double ovens, silestone counters, butcher block island w/sink & separate bar area. Primary en suite is tucked away beside the living room w/features like a sitting area, rainfall shower, jetted tub & AMAZING closet! Secondary bedrooms/bathrooms have their own den/playroom area. Download \"Features & Upgrades\" sheet for all the details.' ,`Acres` = '0.675' ,`Area` = '33' ,`BuilderName` = 'Brentwood' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NORTHFIELD ESTATES (2008) ABST 20, BLOCK 1, LOT 11, ACRES 0.' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '29401' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '575' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '5' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '20 - Friendswood' ,`SchoolElementary` = 'WESTWOOD ELEMENTARY SCHOOL (FRIENDSWOOD)' ,`SchoolHigh` = 'FRIENDSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'FRIENDSWOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Northfield Estates' ,`TaxAmount` = '16935' ,`TaxRate` = '2.2832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418269' WHERE `Matrix_Unique_ID` = '214225134' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T19:07:00.913' ,`MLSNumber` = '43982207' ,`ListAgentFullName` = 'Hephzibah Navarro' ,`ListOfficeName` = 'Zarco Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.951137' ,`Longitude` = '-95.493984' ,`PhotoCount` = '20' ,`PostalCode` = '77066' ,`RoomCount` = '8' ,`ListPrice` = '285995.00' ,`Status` = 'Active' ,`StreetName` = 'Taylor Leigh' ,`StreetNumber` = '11902' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2401' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home in NW Houston is minutes from Sam Houston PKWY, 249, 1960 and major shopping areas. Upon entering the house you have a formal dining room. The spacious kitchen has a walk in pantry. Kitchen and breakfast area over look the grand backyard and living room. Upstairs is a game room along with all 4 bedrooms. Primary bedroom has two walk in closets! Primary bathroom has separate shower and tub along with dual sinks. Schedule your showing today!' ,`Acres` = '0.1455' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 2 COPPER FALLS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6336' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '460' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MCDOUGLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'WUNDERLICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Copper Falls' ,`TaxAmount` = '5142' ,`TaxRate` = '2.9105' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418270' WHERE `Matrix_Unique_ID` = '214298370' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T20:27:39.623' ,`MLSNumber` = '19967752' ,`ListAgentFullName` = 'Lisa Hudgens' ,`ListOfficeName` = 'RE/MAX Northwest, REALTORS' ,`SellingAgentFullName` = 'Rebecca Nelson' ,`SellingOfficeName` = 'BHGRE Gary Greene' ,`Latitude` = '30.229751' ,`Longitude` = '-95.439276' ,`PhotoCount` = '39' ,`PostalCode` = '77385' ,`RoomCount` = '9' ,`ListPrice` = '265000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Brook Forest' ,`StreetNumber` = '910' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2256' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated 4-bedroom home on a large Cul de sac lot. The entry to the home opens into the dining room with updated wood look tile, flex space for an office and tons of natural light. The kitchen was updated as well with white cabinets, countertops, brushed nickel hardware & dual sided ss sink. The breakfast room has large windows overlooking the backyard & opens into the family room. The family room has tile flooring, vaulted ceilings with exposed beams, brick surround fireplace & tons of natural light. The home has a split floor plan with the primary bedroom featuring updated wood look tile floors, En suite update bath, corner jetted tub and separate shower. The secondary bedrooms all have update wood look tile floors, ceiling fan and closets. The secondary bathroom was updated to match the kitchen and has a knee space vanity as well. The spacious backyard has a patio area for outdoor entertaining and tons of green space for a playscape, pool and room to play.' ,`Acres` = '0.8822' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RIVERBROOK-FOREST HLS GRN, LOT 41' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '38428' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '330' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverbrook-Forest Hls Grn' ,`TaxAmount` = '2276' ,`TaxRate` = '2.3044' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418270' WHERE `Matrix_Unique_ID` = '214323019' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T19:42:55.697' ,`MLSNumber` = '71777023' ,`ListAgentFullName` = 'Alejandro Barrella' ,`ListOfficeName` = 'Pinnacle Realty Advisors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.582258' ,`Longitude` = '-95.669293' ,`PhotoCount` = '24' ,`PostalCode` = '77479' ,`RoomCount` = '6' ,`ListPrice` = '649000.00' ,`Status` = 'Active' ,`StreetName` = 'Crisfield' ,`StreetNumber` = '1910' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3487' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic Weekley Plan with master & second bedroom with full bathroom down, plus both formals & upstairs game room. The house is immaculate, a new kitchen that was recently rebuild with an open concept and an amazing island, and really nice wood floors downstairs. The house is on a very large corner lot that is just across from a park area and with views of lake and fountain. The backyard has a huge pool with a spa, plenty of grassy play areas, a covered patio with deck above. Oversized garage with eight foot extension faces street for easy parking. This wonderful house is at walking distance to exemplary middle school and retail center.' ,`Acres` = '0.2669' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NEW TERRITORY PARCEL SF-22, BLOCK 2, LOT 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '11624' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1060' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'WALKER STATION ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'SARTARTIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'New Territory Prcl Sf-22' ,`TaxAmount` = '11098' ,`TaxRate` = '2.4394' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1668418270' WHERE `Matrix_Unique_ID` = '214341150' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T19:16:40.453' ,`MLSNumber` = '30743708' ,`ListAgentFullName` = 'Andrew Gordon' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = 'Carrie Smith' ,`SellingOfficeName` = 'RE/MAX Integrity' ,`Latitude` = '30.212585' ,`Longitude` = '-95.578805' ,`PhotoCount` = '36' ,`PostalCode` = '77354' ,`RoomCount` = '7' ,`ListPrice` = '324900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Wedgewood' ,`StreetNumber` = '7223' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2001' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in the heart of Magnolia\'s favorite neighborhood, Westwood! 7223 Wedgewood offers 3 bedrooms, 2 full and 1 half bath. The primary retreat and on-suite are located on the first story of this 2001 square foot home. The downstairs offers a semi open concept kitchen opening to the living area with access to the formal dining room. The half bath downstairs is a nice option when entertaining. Upstairs offers 2 nice sized bedrooms, a full bath and game room. Westwood offers a variety of neighborhood amenities, 2 pools, multiple basketball and tennis courts, a pavilion and 2 parks to play in. Very close to shopping, retail, grocery, entertainment, medical. Major thoroughfares are accessible and easy to get too.' ,`Acres` = '0.4591' ,`Area` = '15' ,`BuilderName` = 'Supreme Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WESTWOOD 02, BLOCK 9, LOT 17' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '20000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '228' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'BEAR BRANCH ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westwood 02' ,`TaxAmount` = '5286' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Aerobic,Public Sewer' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418270' WHERE `Matrix_Unique_ID` = '214366012' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T20:52:19.130' ,`MLSNumber` = '59837354' ,`ListAgentFullName` = 'Travis Nichols' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = 'Rhonda Delany' ,`SellingOfficeName` = 'CB&A, Realtors- Southeast' ,`Latitude` = '29.387779' ,`Longitude` = '-95.229362' ,`PhotoCount` = '25' ,`PostalCode` = '77511' ,`RoomCount` = '11' ,`ListPrice` = '279950.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Wildhorse' ,`StreetNumber` = '4349' ,`StreetSuffix` = 'Lane' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Priced to Sell! Welcome to this beautiful, ranch-style home located on a half acre lot in a quiet cul de sac location! There is ample of opportunities with this property. It features an open floor plan with a formal study that can be used as a 4th bedroom. Backyard has tons of space to add pool, play set, or anything to make it your own. Recent updates include A/C, roof, water heater, and a few appliances. Come see this wonderful property today and realize the opportunity today.' ,`Acres` = '0.5332' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WILDWINN ESTATES (A0466 HT&BRR)(ALVIN), BLOCK 1, LOT 20' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '23226' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'WALT DISNEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'ALVIN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Wildwinn Estates' ,`TaxAmount` = '7210' ,`TaxRate` = '2.8854' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418270' WHERE `Matrix_Unique_ID` = '214415388' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T20:26:13.920' ,`MLSNumber` = '3543485' ,`ListAgentFullName` = 'Jessica Montes' ,`ListOfficeName` = 'Century 21 Top Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.837706' ,`Longitude` = '-95.187302' ,`PhotoCount` = '30' ,`PostalCode` = '77049' ,`RoomCount` = '7' ,`ListPrice` = '170000.00' ,`Status` = 'Active' ,`StreetName` = 'Royalwood' ,`StreetNumber` = '7834' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1656' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One story 3 Bedroom with a study currently being used as a 4th bedroom! Garage has been converted into a large livingroom with a corner brick fireplace. This home has a spacious backyard with no back neighbors and a wood shed with electricity and AC window unit. Come take a look, the possibilities are endless!' ,`Acres` = '0.2204' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 12 ROYALWOOD SEC 2 R/P' ,`LotDesciption` = 'Other' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '85' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'ROYALWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'C.E. KING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Royalwood Sec 02 Rep' ,`TaxAmount` = '3181' ,`TaxRate` = '2.7361' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418271' WHERE `Matrix_Unique_ID` = '214441104' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T19:23:41.110' ,`MLSNumber` = '34364371' ,`ListAgentFullName` = 'Diane Lominac' ,`ListOfficeName` = 'Century 21 Realty Partners' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.195772' ,`Longitude` = '-95.486838' ,`PhotoCount` = '50' ,`PostalCode` = '77382' ,`RoomCount` = '13' ,`ListPrice` = '629000.00' ,`Status` = 'Active' ,`StreetName` = 'Townsend' ,`StreetNumber` = '23' ,`StreetSuffix` = 'Place' ,`City` = 'The Woodlands' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3214' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This sparkling clean 4/3.1/2 with pool & spa is nestled on a cul de sac homesite and backs to a wooded greenbelt reserve. This thoughtful plan offers a gameroom, office, & formal dining room. An oversized front porch is welcoming to guests as they enter the two-story foyer. The primary suite is situated on the 1st floor w an en’suite bath & custom closet. Updated kitchen boasts beauty & functionality: granite island, SS appliances, butler’s pantry, & a storage area. Cozy family room w extended living space & beautiful views. Easily work from home in the executive study. Generously sized gameroom upstairs. Enjoy endless hours of fun in the pool & spa. The pavilion provides a shade for outdoor dining & entertaining. Recent updates/upgrades incl: water heater \'22 & HVACs \'22, pool pump & much more. Conveniently located in The Woodlands, TX (Montgomery Co.) w easy access for commuters. Nearby world-class shopping, dining, & entertainment. No previous flooding. Low tax rate!' ,`Acres` = '0.2236' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL ALDEN BR 03, BLOCK 2, LOT 49' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,In Golf Course Community,Subdivision Lot,Wooded' ,`LotSize` = '9739' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'DAVID ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Call Occupant,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Village Alden Bridge' ,`TaxAmount` = '9060' ,`TaxRate` = '2.1269' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418271' WHERE `Matrix_Unique_ID` = '214508527' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T19:15:58.350' ,`MLSNumber` = '75330013' ,`ListAgentFullName` = 'Laura LoGiudice' ,`ListOfficeName` = 'Re/Max Property Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.023911' ,`Longitude` = '-95.576877' ,`PhotoCount` = '40' ,`PostalCode` = '77375' ,`RoomCount` = '11' ,`ListPrice` = '379900.00' ,`Status` = 'Active' ,`StreetName` = 'Memorial Way' ,`StreetNumber` = '10007' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GREAT CORNER LOT and close to Klein Cain HS. HCAD has incorrect square footage. NEW Tile flooring 2022, NEW wood flooring throughout home 2019, Tankless Water Heater 2021, Roof replaced 2016, NEW AC w/NEW pan 2021, sprinkler system front and back, NEW microwave 2022. Kitchen has great Granite countertops with tons of cabinet storage and opens up to the large, two-story family room. Huge primary bedroom with ensuite bath, Upstairs find a large game room, and good size secondary bedrooms, with two full baths. The covered patio provides great outdoor entertaining, and the concrete has just been painted. The home boasts beautiful natural light, an easy and spacious floor plan, and is ready for you to tour today!' ,`Acres` = '0.2214' ,`Area` = '14' ,`BuilderName` = 'Gehan' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 2 MEMORIAL SPRINGS SEC 3' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9646' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '430' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BLACKSHEAR ELEMENTARY SCHOOL (KLEIN)' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'ULRICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Springs Sec 03' ,`TaxAmount` = '6300' ,`TaxRate` = '2.4965' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418271' WHERE `Matrix_Unique_ID` = '214638920' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T19:52:16.610' ,`MLSNumber` = '36351053' ,`ListAgentFullName` = 'Christopher Davidson' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.661525' ,`Longitude` = '-95.357035' ,`PhotoCount` = '21' ,`PostalCode` = '77051' ,`RoomCount` = '6' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Larkspur' ,`StreetNumber` = '4637' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1710' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This lovely gem is a fully remodeled 4 bed, 2 bath home in the heart of Flower City Subdivision! Minutes away from the 288, 610 and Bltwy 8! This beautiful home was stripped to the studs and refurbished with all new Electrical, Plumbing, A/C, Flooring, Cabinets in the bathrooms & kitchen and much more! This property has endless potential! New composite roof, new flooring, new windows, new siding, new light fixutres, tile and new appliances in the kitchen including a microwave, gas range and stove! Primary bedroom comes with a brand new patio deck in the backyard to relax with friends & family and a spacious closet with custom built in cabinetry and shelving! This is a rare opportunity to own a fully remodeled home in South Houston. Call now to schedule a viewing today!' ,`Acres` = '0.1159' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 9 BLK 1 FLOWER CITY' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BASTIAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Flower City' ,`TaxAmount` = '2612' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418271' WHERE `Matrix_Unique_ID` = '214673895' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214699056','1668418272','214699056','2022-11-12T19:15:27.743','97061622','Joe Zhou','World Wide Realty','','','29.963097','-95.573646','19','77070','11','289000.00','Active','Iris Lake','10422','Court','Houston','2','0','4','1892','Single-Family','Fresh renovated one-story home with porcelain tile in the living room, dinning, kitchen and wet areas. laminate/vinyl plank in bedrooms, brand new granite countertop in kitchen & bathrooms, fresh paint, brand new stainless steel appliances, high ceiling, a few minutes away from 249, Beltway 8, 99 and 290. convenient location to shopping centers, less than 10 minutes to Costco, must see today!','0.1263','10','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Willowbrook South','Central Gas','1','LT 113 BLK 2 GRANTS TRACE','Subdivision Lot','5500','Appraisal District','','379','0','','2','Electric Oven','0','','','Gas Range','','Composition','13 - Cypress-Fairbanks','MATZKE ELEMENTARY SCHOOL','CYPRESS CREEK HIGH SCHOOL','BLEYL MIDDLE SCHOOL','Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Grants Trace','5223','2.5937','Public Sewer,Public Water','2006','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214699137','1668418272','214699137','2022-11-12T19:19:48.583','52232792','Cheryn Reynolds','Ameristar, REALTORS','','','30.064117','-95.571750','12','77375','9','279900.00','Active','Berrybriar','10122','Lane','Tomball','2','1','4','2048','Single-Family','2 living room areas! Kitchen features stainless steel appliances, a breakfast area and large family room - a wall of windows overlooking the backyard. Front living room area has a high ceiling. Primary bedroom in on the 1st floor and has an ensuite bathroom with separate bath and shower. Upstairs there\'s an open game room, and 3 additional bedrooms and a full bath. Outside is a fenced backyard with lots of potential for entertaining.','0.1136','14','','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','0','Spring/Klein/Tomball','Central Electric','1','LT 16 BLK 5 SUGARBERRY PLACE PHASE 2','Subdivision Lot','4949','Appraisal District','','450','0','','2','','0','','','Electric Range','','Composition','32 - Klein','BERNSHAUSEN ELEMENTARY SCHOOL','KLEIN CAIN HIGH SCHOOL','ULRICH INTERMEDIATE SCHOOL','Appointment Required,Lockbox Right Side','Appraisal District','2','Traditional','Sugarberry Place Ph 02','3851','2.0766','Public Sewer,Public Water','2006','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214699421','1668418272','214699421','2022-11-12T20:41:59.487','82997996','Fariah Qureshi','HomeSmart','','','29.706461','-95.691844','50','77407','9','305000.00','Active','Chestnut','17522','Trail','Richmond','2','0','4','2265','Single-Family','Priced to sell!!!4 Bedroom 2 Bath single story home located in the well-established West Oaks Village.Spacious kitchen with ample counter and cabinet space, breakfast bar, and breakfast room open to a generously sized family room. Generously sized primary suite with en suite featuring dual sinks, vanity, soaker tub, separate shower, and walk-in closet.Fully upgraded kitchen cabinets and sink,New Quartz countertop and backsplash in kitchen, New Ceramic tile floor, New carpet in bedrooms,Roof replaced in 2018,New AC unit was installed in 2019.Neighborhood Center with a beautiful gated pool, a newly renovated covered playground, a park, and a walking trail. Easy access to FM 1464, 1093, Westheimer, Hwy 6, and the Grand Parkway. Schedule your private showing today!','','37','','','','','Mud,Sellers Disclosure','1','','1','Mission Bend Area','Central Gas','1','WEST OAKS VILLAGE SEC 3, BLOCK 1, LOT 47','Subdivision Lot','6600','Appraisal District','','650','0','','2','Electric Oven','0','','','','','Composition','19 - Fort Bend','JORDAN ELEMENTARY SCHOOL (FORT BEND)','BUSH HIGH SCHOOL','CROCKETT MIDDLE SCHOOL (FORT BEND)','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','1','Traditional','West Oaks Village Sec 3','6420','2.4887','Public Sewer,Water District','1999','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214699476','1668418272','214699476','2022-11-12T20:28:36.360','13887567','Jeronimo Guerrero','Lucky Money Real Estate','','','30.247726','-95.544833','12','77384','12','829500.00','Active','West Forest Ct','5','','Conroe','3','1','3','3340','Single-Family','**ESTIMATED DELIVERY: DECEMBER** Beautiful modern farmhouse design at Lake Forest Subdivision. ** Low Tax Rate ** Zoned to highly acclaimed schools such as The Woodlands High School, close to parks and restaurants, and easy access to I-45, located in a quiet neighborhood surrounded by trees. This spacious two-story home with three bedrooms and 3.5 bathrooms, plus an office, TV room, an a huge game room/extra room upstairs. It will be completed in September 2022. Many upgrades throughout, such as top of the line countertops, stainless steel appliances, wood flooring, spacious bedrooms, and an open floor plan, are perfectly laid out. Great front porch. Massive rear covered patio with summer kitchen.','','15','Urbanika Const.','','','','HOA First Right of Refusal','','','','Conroe Southwest','Central Electric','1','Lot 22 Block 1 Lake Creek Forest Section 1 Montgomery TX','Cul-De-Sac','21780','Appraisal District','','265','1','Never Lived In','2','','0','','','','','Composition','11 - Conroe','BUSH ELEMENTARY SCHOOL (CONROE)','THE WOODLANDS HIGH SCHOOL','MCCULLOUGH JUNIOR HIGH SCHOOL','Appointment Required','Builder','2','Other Style','Lake Creek Forest','','','Septic Tank','2022','Builder'); --> New record created successfully