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-09-03T11:20:20.433' ,`MLSNumber` = '45452493' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties ' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.524346' ,`Longitude` = '-95.409173' ,`PhotoCount` = '42' ,`PostalCode` = '77578' ,`RoomCount` = '14' ,`ListPrice` = '1199990.00' ,`Status` = 'Active' ,`StreetName` = 'Elm Manor' ,`StreetNumber` = '2216' ,`StreetSuffix` = 'Drive' ,`City` = 'Manvel' ,`BathsFull` = '6' ,`BathsHalf` = '2' ,`BedsTotal` = '6' ,`SqFtTotal` = '5729' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HXT314-This modern stucco and brick home stands out in the Estates of Plum Creek. This house sits at the end of a cul-de-sac on an 18,000 sq. ft. lot with all the room you need for your luxury pool. The double entry doors draw you into the fantastic foyer featuring double curved staircases and a dome ceiling flanked by a private home office and a spacious formal dining room. The open-concept design has windows galore with sliding doors to the patio. It combines the gourmet kitchen with under-cabinet lighting, a family room featuring 20-foot ceilings, and an open railing above the second floor. The breakfast area boasts the perfect meeting space for family and friends. Upstairs, you can continue the entertaining to the spacious game room or watch your favorite shows in the media room, complete with a tray ceiling and rope lighting. Take outdoor living to a new level on the Texas-sized covered back patio that looks out onto the backyard with no back neighbors. Don\'t miss out on this gem!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9 Block 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Water View' ,`LotSize` = '18086' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1190' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'POMONA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Pomona' ,`TaxAmount` = '' ,`TaxRate` = '3.72' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663706296' WHERE `Matrix_Unique_ID` = '203789688' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T11:48:58.863' ,`MLSNumber` = '46205510' ,`ListAgentFullName` = 'Lisa Clary' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.788621' ,`Longitude` = '-94.663553' ,`PhotoCount` = '13' ,`PostalCode` = '77514' ,`RoomCount` = '6' ,`ListPrice` = '315990.00' ,`Status` = 'Active' ,`StreetName` = 'Lakeway' ,`StreetNumber` = '111' ,`StreetSuffix` = 'Circle' ,`City` = 'Anahuac' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2161' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Midland plan is a two-story home featuring 4 bedrooms, 3 baths, and 2 car garage. The entry opens to a downstairs guest bedroom and bath with hall linen closet. The kitchen includes a breakfast bar with beautiful counter tops, stainless steel appliances and corner pantry. Open concept floorplan boasts spacious family room and dining area. Extra storage space under the stairs is a plus. The private primary suite with attractive primary bath features dual vanities, water closet and walk-in closet. A versatile loft area greets you at the top of the stairs and opens to two additional bedrooms and bath. The standard rear covered patio is located off the dining area.' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'D.R. Horton Express' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lakeway' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '4 - Anahuac' ,`SchoolElementary` = 'ANAHUAC ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANAHUAC HIGH SCHOOL' ,`SchoolMiddle` = 'ANAHUAC MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakeway' ,`TaxAmount` = '' ,`TaxRate` = '2.6' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663706296' WHERE `Matrix_Unique_ID` = '203849730' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T10:43:00.827' ,`MLSNumber` = '38005069' ,`ListAgentFullName` = 'Lisa Sanders' ,`ListOfficeName` = 'Living Vogue Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.542202' ,`Longitude` = '-95.097957' ,`PhotoCount` = '50' ,`PostalCode` = '77058' ,`RoomCount` = '4' ,`ListPrice` = '1300000.00' ,`Status` = 'Active' ,`StreetName` = 'Nassau Bay' ,`StreetNumber` = '18246' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3773' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning custom-built home is nestled within a pristine waterside enclave in the city of Nassau Bay with a backyard that stretches to the water’s edge. It\'s newly elevated and offers an authentic life of luxury. Stunning views of the waterfront so you can relax and entertain in style. Take your pick from the sunken lounge with glossy terrazzo floors underfoot, office, formal dining, a fireplace, and walls of windows for an abundance of natural light throughout the home. Your luxury gourmet kitchen awaits and there are numerous decks and patios to enjoy when you want indoor or outdoor dining. The bedrooms are impressive, with a large laundry room, an upper-level loft, and an attached garage that fits seven-plus cars plus storage. New 50-year roof, HVAC, plumbing, electric wiring, storm windows, and electrical panel in 2018. New water heater, driveway, landscaping in 2022. See the attached complete list of updates. Do not miss this chance! Call to schedule a walk-through today!' ,`Acres` = '0.6569' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 1 NASSAU BAY SEC 1' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '28616' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '286' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '7' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ROBINSON ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Nassau Bay Sec 01' ,`TaxAmount` = '11197' ,`TaxRate` = '2.4882' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706296' WHERE `Matrix_Unique_ID` = '206052406' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T10:14:28.043' ,`MLSNumber` = '52664968' ,`ListAgentFullName` = 'Trinh Tran' ,`ListOfficeName` = 'Lone Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.839008' ,`Longitude` = '-95.682217' ,`PhotoCount` = '19' ,`PostalCode` = '77084' ,`RoomCount` = '4' ,`ListPrice` = '323000.00' ,`Status` = 'Active' ,`StreetName` = 'Oakhampton' ,`StreetNumber` = '18307' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2465' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PRICE REDUCED! Nice and cozy 4 bedrooms with primary room downstairs. 2 bathrooms upgraded last years. House painted and new carpet replaced 2021. Plenty spaces with long driveway to detached garage. Hug room for outdoor party in the backyard. This house won’t last long! Call agent today to make appointment.' ,`Acres` = '0.2066' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 40 DEERFIELD VILLAGE SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WILSON ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'WATKINS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Deerfield Village Sec 04' ,`TaxAmount` = '5115' ,`TaxRate` = '2.251' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706296' WHERE `Matrix_Unique_ID` = '207160295' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T11:49:39.330' ,`MLSNumber` = '10738535' ,`ListAgentFullName` = 'Chantal Andrade' ,`ListOfficeName` = 'CJM Realty Advisors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.794565' ,`Longitude` = '-95.312496' ,`PhotoCount` = '7' ,`PostalCode` = '77026' ,`RoomCount` = '1' ,`ListPrice` = '99999.00' ,`Status` = 'Active' ,`StreetName` = 'Easy' ,`StreetNumber` = '3807' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '828' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CALLING ALL INVESTORS. COME TAKE A LOOK.' ,`Acres` = '0.1657' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 12 BLK 3 COLONIA WEISENBERGER SEC 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '7220' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ISAACS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'FLEMING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Colonia Weisenberger Sec 02' ,`TaxAmount` = '1475' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663706296' WHERE `Matrix_Unique_ID` = '207806775' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T11:55:37.563' ,`MLSNumber` = '56338374' ,`ListAgentFullName` = 'Benny Benavides' ,`ListOfficeName` = 'RE/MAX 5 Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.629898' ,`Longitude` = '-95.271058' ,`PhotoCount` = '9' ,`PostalCode` = '77075' ,`RoomCount` = '8' ,`ListPrice` = '134990.00' ,`Status` = 'Active' ,`StreetName` = 'Tavenor' ,`StreetNumber` = '8302' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1280' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming one-story home! The foundation has been leveled and comes with warranty. Home has been re-piped with new pex pipes. It has all new electrical wiring and new breaker box. Home also has a brand-new roof. Come and see this amazing home today!' ,`Acres` = '' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 55 HOUSTON SKYSCRAPER SHADOWS 3' ,`LotDesciption` = 'Corner' ,`LotSize` = '8576' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DEANDA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'House Skyscraper Shadows 03' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706297' WHERE `Matrix_Unique_ID` = '208026047' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T10:39:49.027' ,`MLSNumber` = '97574773' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.834323' ,`Longitude` = '-95.857753' ,`PhotoCount` = '31' ,`PostalCode` = '77493' ,`RoomCount` = '4' ,`ListPrice` = '481000.00' ,`Status` = 'Active' ,`StreetName` = 'Malibu Shore' ,`StreetNumber` = '908' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2380' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 97574773 - Built by Highland Homes - November completion! ~ Built by Highland Homes - Walking distance to the famous 3.5 acre Crystal Lagoon in a community that\'s just 15 minutes from both I-10 and 99! The Everleigh features a lovely front porch, two-story entry, 8\' solid doors plus two bedrooms downstairs! Downstairs is an open family room with double-stacked windows climbing the tall ceilings, large kitchen island with peninsula, window seat, extra cabinet space, a fourth bedroom and bathroom, and the primary suite. This kitchen is a show stopper featuring a 5 piece GE stainless appliance package, endless cabinets and quartz countertops! Primary suite includes a bay window, large walk in closet and separate tub and shower. Upstairs are two spacious bedrooms, a full bath, walk-in linen closet, and game room open to below. Full sprinkler system, tank less water heater, and SMARTHOME PACKAGE included!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '69/1' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BRYANT ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.53' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663706297' WHERE `Matrix_Unique_ID` = '208843094' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T10:20:22.847' ,`MLSNumber` = '53415023' ,`ListAgentFullName` = 'Marla Norsworthy' ,`ListOfficeName` = 'Charles Arnold Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.423035' ,`Longitude` = '-95.559088' ,`PhotoCount` = '7' ,`PostalCode` = '75835' ,`RoomCount` = '2' ,`ListPrice` = '249500.00' ,`Status` = 'Active' ,`StreetName` = 'Private Road 6050' ,`StreetNumber` = '891' ,`StreetSuffix` = '' ,`City` = 'Crockett' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home on two waterfront lots (approx. 1.206 ac.) on Houston County Lake. Large pier, partially wooded lots with a nice views of the lake and great fishing, utility barn and storage. Home has some updates to be done to add your own personal touch. This property has one of the only \"pepper trees\" in the area according to the owner. Waterfront living at the Houston County Lake, sit back and enjoy!' ,`Acres` = '1.206' ,`Area` = '41' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Grapeland Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'R DE LA GARZA AB 33 1.206 AC' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '52533' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '61 - Latexo' ,`SchoolElementary` = 'LATEXO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LATEXO HIGH SCHOOL' ,`SchoolMiddle` = 'LATEXO HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'N/A' ,`TaxAmount` = '1774' ,`TaxRate` = '1.6377' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706297' WHERE `Matrix_Unique_ID` = '208876846' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T10:42:04.217' ,`MLSNumber` = '94644725' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.815013' ,`Longitude` = '-95.836769' ,`PhotoCount` = '50' ,`PostalCode` = '77493' ,`RoomCount` = '13' ,`ListPrice` = '1249466.00' ,`Status` = 'Active' ,`StreetName` = 'Lady Bird' ,`StreetNumber` = '3211' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '5' ,`BathsHalf` = '3' ,`BedsTotal` = '5' ,`SqFtTotal` = '4909' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 94644725 - Built by Highland Homes - December completion! ~ This Highland Home in Cane Island is a show stopper. With it\'s elegant spiral staircase this home is ideal for entertaining. With over 4900 sq ft it comes with an extended outdoor living space, a pool bath, extended primary suite, 2 study\'s for those who both work from home, flex gen suite upstairs, a retreat off the game room upstairs, and a jack and jill bathroom for bedrooms 3 and 4 upstairs.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '30/1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12020' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BRYANT ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cane Island 80s' ,`TaxAmount` = '' ,`TaxRate` = '3.4' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663706297' WHERE `Matrix_Unique_ID` = '209220508' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T11:30:34.270' ,`MLSNumber` = '82684382' ,`ListAgentFullName` = 'Genesis Garcia' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.164360' ,`Longitude` = '-95.394562' ,`PhotoCount` = '50' ,`PostalCode` = '77385' ,`RoomCount` = '5' ,`ListPrice` = '1195000.00' ,`Status` = 'Active' ,`StreetName` = 'White Oak Pass' ,`StreetNumber` = '11943' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4905' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'An entertainer\'s paradise! Privacy, tranquility, updates, & access to the park & lake await you at this one of a kind five-bedroom single-level home. Beautiful finishes & craftsman design fill the open concept floor plan that has been meticulously maintained & includes many modern conveniences, soaring high ceilings, & hand-selected details through the expansive 3.805+/- sq ft. floor plan. Lined with tall custom cabinets, expansive counters, & Italian Porcelain floors, the kitchen is perfect for large gatherings. Laughter & conversation flow easily between the kitchen & living room, grounded by tons of natural light and dining space overlooking the vast 2.9+/- acre lot beyond french doors. Just beyond the main house, you can take full advantage of the 1,110-square-foot warehouse, with A/C providing you with space to hone your skills in crafts, motor repairs, or simply a space to house your toys. New Roof 2022. The property backs up to the park, with lake. Disclosure-Related to seller.' ,`Acres` = '2.8278' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WHITE OAK ESTATES 02, BLOCK 1, LOT 7' ,`LotDesciption` = 'Cleared,Other,Wooded' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '625' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'HOUSER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Other Style' ,`Subdivision` = 'White Oak Estates 02' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Other Water/Sewer' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663706297' WHERE `Matrix_Unique_ID` = '209503506' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T11:39:34.320' ,`MLSNumber` = '92300434' ,`ListAgentFullName` = 'Bruce Ham' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.683568' ,`Longitude` = '-95.371407' ,`PhotoCount` = '50' ,`PostalCode` = '77021' ,`RoomCount` = '10' ,`ListPrice` = '720000.00' ,`Status` = 'Active' ,`StreetName` = 'Goodhope' ,`StreetNumber` = '3613' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4646' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'First time on the Market! Make this Dream Home your Client\'s Reality! Rare Tusan 2-story, 4bd, 2.5ba w/ upstairs outdoor Terrace, back & side covered patio. The grand entrance features Kohler fixtures, 10ft vaulted ceilings, Gas Fireplace, Chef style kitchen equipped w/ SS JennAir appliances, Pot filler, farm sink and soft close drawers. The front wing downstairs includes 2 Rooms that can be used as an study/office with waiting room - built to commercial specification, playroom or even bedroom conversions. Both downstairs rooms have separate entrances and are handicap accessible. Currently, being used for home based business. Primary suite showcasing a spa retreat w/ double vanity, spa tub and separate shower. DREAM closet tucked away upstairs & Hollywood style game room! Tankless Rheem water heater, 2 18-ton Lennox AC units, built green - Higher rated insulation, oversized overhangs, water catchment & solar panels. Call to schedule your private tour today!' ,`Acres` = '0.1148' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 18 BLK 39 SOUTH END SUNNYSIDE U/R' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WHIDBY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'South End Sunnyside U/R' ,`TaxAmount` = '11653' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706297' WHERE `Matrix_Unique_ID` = '209643458' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T10:45:53.097' ,`MLSNumber` = '94860317' ,`ListAgentFullName` = 'Alyssa Kantis' ,`ListOfficeName` = 'Surge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.424433' ,`Longitude` = '-95.631170' ,`PhotoCount` = '43' ,`PostalCode` = '77356' ,`RoomCount` = '5' ,`ListPrice` = '939500.00' ,`Status` = 'Active' ,`StreetName` = 'Marietta' ,`StreetNumber` = '17' ,`StreetSuffix` = 'Court' ,`City` = 'Montgomery' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5189' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'RICH with exterior and interior features such as a brand new GENERAC GENERATOR, new ROOF and new HEATED SWIMMING POOL that can easily be controlled straight from your phone! This captivating traditional with a modern touch home is on a quiet, oversized cul-de-sac lot in the prestigious 24-hour manned gated community of Bentwater on Lake Conroe. Home is two story with 5-6 bedrooms, including a HUGE downstairs primary bedroom w/double sided fireplace and seating area; 5.1 bath, 3.2 garage. Attached 1,100 s.f. guest quarters includes full Kit/LV/BR/Utility Room/large Bathroom/and walk-in closet. In addition, the pool house is perfect for “stay-at-home” college student or home office. Located in walking distance to Country club, Fitness Facility, 11-Tennis Courts, and Day Spa/Salon. Adding to your enjoyment, this pristine home and community offers lake-resort living, 54 holes golf and Yacht Club w/Marina.' ,`Acres` = '0.357' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BENTWATER 19, BLOCK 2, LOT 13' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Other' ,`LotSize` = '15553' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1091' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Bentwater 19' ,`TaxAmount` = '11129' ,`TaxRate` = '2.1142' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663706297' WHERE `Matrix_Unique_ID` = '209779324' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T11:50:33.663' ,`MLSNumber` = '26969376' ,`ListAgentFullName` = 'Jo Anne Johnson' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.935651' ,`Longitude` = '-95.688141' ,`PhotoCount` = '43' ,`PostalCode` = '77433' ,`RoomCount` = '12' ,`ListPrice` = '709000.00' ,`Status` = 'Active' ,`StreetName` = 'Dawn River' ,`StreetNumber` = '10711' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3541' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LIKE NEW w/UPGRADES THROUGHOUT! Situated in coveted Towne Lake community w/amenities ranging from Lazy River, Splash Pad, resort pools, Boardwalk w/shops, dining, daily services, trails, parks, recreational courts, lake use, boating & more! This Village Builders home is fresh & inspiring, keeping with modern buyer demands! Premium cul-de-sac lot and classic stone & stucco elevation w/oversized 2+1 garage w/carriage door accents - framing its irresistible curb appeal! Contemporary entry & welcoming foyer highlight 1st impressions as you step inside plus study w/beamed ceiling, versatile dining rm, offset utility rm & powder rm, gourmet kitchen w/walk-in pantry, custom encased cooking hearth w/stainless vent hood, 2-story den, cast stone fireplace, wall of wdws overlooking private backyard oasis, and secluded owners retreat w/luxe primary bath w/dressing mirror! Spacious secondary BR\'s feature a guest suite + game/media rooms upstairs! Awesome storage w/TX basement! Top-ranked schools!' ,`Acres` = '0.1693' ,`Area` = '25' ,`BuilderName` = 'Village Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 4 TOWNE LAKE SEC 46' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7376' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1699' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`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` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Towne Lake' ,`TaxAmount` = '16942' ,`TaxRate` = '3.471' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663706298' WHERE `Matrix_Unique_ID` = '209825587' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T11:23:05.900' ,`MLSNumber` = '87430139' ,`ListAgentFullName` = 'Timothy Verge' ,`ListOfficeName` = 'RE/MAX Grand' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.707242' ,`Longitude` = '-95.764273' ,`PhotoCount` = '37' ,`PostalCode` = '77494' ,`RoomCount` = '7' ,`ListPrice` = '435000.00' ,`Status` = 'Active' ,`StreetName` = 'Blossom Meadow' ,`StreetNumber` = '22114' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2605' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GREAT LOCATION IN KATY AT I-10 AND GRANDPARKWAY, EASY TO GET TO FREEWAY OUT NEIGHBORHOODON CUL DE SAC. CLOSE TO SCHOOLS, PARKS AND SHOPPING.LOCATED IN SOME OF THE MOST TOP RATED SCHOOLS IN TEXAS. UPDATED OPEN FLOOR PLAN WITH 2 MASTER BEDROOMS ONE DOWN AND ONE UP LARGE ENOUGH TO MAKE GAMEROOM OR MEDIA ROOM IF YOU LIKE.THIS 1.5 STORY FEATURES OPEN KITCHEN WITH HIGH CEILING AND LOTS OF NATURAL LIGHT OVERING LOOKING LARGE PATIO WITH DECK.ORIGINAL OWNER , NO FLOODING PER OWNER.2 MINUTES TO GET ON WESTPARK TOLL IF YOU HAVE TO GO TO THE OFFICE, WHEN THIS HOUSE HAS ONE.' ,`Acres` = '0.1727' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND LAKES SEC 14, BLOCK 2, LOT 57' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7524' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1060' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ALEXANDER ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'SEVEN LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'BECKENDORFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Grand Lakes Sec 14' ,`TaxAmount` = '7237' ,`TaxRate` = '2.4613' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706298' WHERE `Matrix_Unique_ID` = '209908530' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T11:42:12.643' ,`MLSNumber` = '14022581' ,`ListAgentFullName` = 'Tyrone Void' ,`ListOfficeName` = 'Fathom Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.675791' ,`Longitude` = '-95.107749' ,`PhotoCount` = '9' ,`PostalCode` = '77536' ,`RoomCount` = '7' ,`ListPrice` = '289999.00' ,`Status` = 'Active' ,`StreetName` = 'Jackson' ,`StreetNumber` = '1518' ,`StreetSuffix` = 'Drive' ,`City` = 'Deer Park' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1894' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Note: Seller is working on fixing items that need attention in the home, but willing to sell as is or upon completion. Lock in pricing now!**\r\nLOCATION, LOCATION, LOCATION CLOSE TO SHOPPING, RESTAURANTS, & LOCAL SCHOOLS! BEAUTIFUL POOL AND BACKYARD SPACE W/ COVERED PATIO!! THIS BEAUTIFUL TRADITIONAL HOME HAS A CUSTOM FEEL WITH PLENTY OF WINDOWS OVERLOOKING THE BACKYARD VIEW! GREAT FOR FAMILIES AS HOME SITS ACROSS FROM A PARK STREET! 3 BEDROOMS WITH 2 FULL BATH AND A SPLIT BEDROOM PLAN! GORGEOUS KITCHEN WITH STAINLESS STEEL APPLIANCES, LARGE DINING AND BUILT-INS AND PLENTY OF STORAGE! DON\'T MISS OUT ON THIS CHARMING HOME!!' ,`Acres` = '0.1641' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Deer Park' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 BLK 7 PARK MEADOWS SEC 3' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'JP DABBS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'BONNETTE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Park Meadows Sec 03' ,`TaxAmount` = '6594' ,`TaxRate` = '2.8239' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706298' WHERE `Matrix_Unique_ID` = '210247033' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T11:06:54.157' ,`MLSNumber` = '63782428' ,`ListAgentFullName` = 'Alexander Navarrete' ,`ListOfficeName` = 'Rayfield Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.504218' ,`Longitude` = '-95.398622' ,`PhotoCount` = '48' ,`PostalCode` = '77578' ,`RoomCount` = '9' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Palomar' ,`StreetNumber` = '18' ,`StreetSuffix` = 'Drive' ,`City` = 'Manvel' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2897' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful corner lot home located in Rodeo Palms. Open kitchen with island and breakfast area, high ceilings and fireplace in the family room. Home includes 5 bedrooms, a study, and a large game room. The spacious backyard comes with a covered patio and you can enjoy great amenities like the pool and park. Brand new AC 2022. Call today for your private showing.' ,`Acres` = '0.2189' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RODEO PALMS, PALM COURT SEC 1 (A0459 & A0299)(MANVEL) BLK 4' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9535' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'DON JETER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Rodeo Palms, Palm Court Sec 1' ,`TaxAmount` = '10147' ,`TaxRate` = '3.6694' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706298' WHERE `Matrix_Unique_ID` = '210686646' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T11:10:32.600' ,`MLSNumber` = '79675988' ,`ListAgentFullName` = 'D\'Adrienne Truitt-Sweatt' ,`ListOfficeName` = 'Sapphire Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.023553' ,`Longitude` = '-95.605692' ,`PhotoCount` = '19' ,`PostalCode` = '77422' ,`RoomCount` = '4' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 686' ,`StreetNumber` = '2708' ,`StreetSuffix` = '' ,`City` = 'Brazoria' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '2040' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 4 bedroom 2 bath home is situated on one acre in the Sweeny school district. Enjoy country living nestled in the peaceful backdrop of Brazoria. A few of the items that make this home desirable are loads of upgrades including a chef\'s kitchen, three-car garage, custom shower, large living areas, fruit and pecan trees, new roof, new siding, new fixtures throughout, and fresh paint. The rear of the property meets trails for your enjoyment. New aerobic septic systems were installed in 2012, a new ac unit in 2013, and all plumbing was replaced in 2014. Contact Sapphire Realty to set your showing appointment!' ,`Acres` = '1' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Electric,Propane' ,`HOAMandatory` = '0' ,`Legal` = 'DAVIS S/D SE 1/2 10-11 (A0138 S M WILLIAMS), LOT 44, ACRES 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '51 - Sweeny' ,`SchoolElementary` = 'SWEENY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SWEENY HIGH SCHOOL' ,`SchoolMiddle` = 'SWEENY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Davis Sub Se 1/2 10-11' ,`TaxAmount` = '3063' ,`TaxRate` = '2.0957' ,`WaterSewer` = 'Aerobic,Septic Tank' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706298' WHERE `Matrix_Unique_ID` = '211056012' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T11:41:30.120' ,`MLSNumber` = '97681760' ,`ListAgentFullName` = 'Tricia Turner' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.062722' ,`Longitude` = '-95.374176' ,`PhotoCount` = '38' ,`PostalCode` = '77373' ,`RoomCount` = '11' ,`ListPrice` = '340000.00' ,`Status` = 'Active' ,`StreetName` = 'Cimarron Pass' ,`StreetNumber` = '3007' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2642' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This BEAUTIFUL 4 bed | 2.5 bath home is perfectly situated in the lovely community of Breckenridge Forest! Upon entering this incredible home, you\'re greeted by an elegant entry with soaring ceilings, a spacious formal living, & a formal dining room. The kitchen boasts gorgeous granite counters, a gas range, a pantry, & a large center island. The breakfast room is just off the kitchen with two cushioned window seats. The family room features high ceilings & a wall of windows overlooking the backyard. Spacious first-floor owner\'s retreat with a soaking tub, separate shower, double sinks, & walk-in closet. A huge game room, three spacious secondary bedrooms, & a full bath complete the second floor. Wood-look laminate & ceramic tile throughout the first floor. Neutral carpet on the second floor. PEX pipes. The extended covered patio with a stained wood ceiling is perfect for entertaining family & friends! Community amenities include a swimming pool, playground & clubhouse. Spring ISD!!' ,`Acres` = '0.1389' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 5 BRECKENRIDGE FOREST SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'GLORIA MARSHALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Breckenridge Forest' ,`TaxAmount` = '7313' ,`TaxRate` = '2.8117' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706298' WHERE `Matrix_Unique_ID` = '211576263' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T10:19:51.100' ,`MLSNumber` = '37387269' ,`ListAgentFullName` = 'Faye Ausmus' ,`ListOfficeName` = 'Ausmus Premier Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.434856' ,`Longitude` = '-95.622518' ,`PhotoCount` = '10' ,`PostalCode` = '77356' ,`RoomCount` = '5' ,`ListPrice` = '561984.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Branch' ,`StreetNumber` = '149' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2722' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for privacy? Beautiful Traditional Home to be built. Backs up to a wooded area. Kitchen, Living and dining area all look out at the privacy wooded area. Gas Fireplace, High Ceilings, Large Windows across back looking out to the Back Porch and Outdoor Kitchen. the Kitchen overlooks the family room to enjoy interaction with family and friends while cooking. The Kitchen features a 9\' Island, Solid Surface counter, Stainless Steel Appliances, Pot filler over the stove, 42\" Custom Built Cabinets, Easy Glide Doors and Drawers. 8\' tall doors thru-out the house. Bronze or black hardware and light fixtures throughout. Solid surface flooring thru out Wet and living areas, Carpet in Bedroom. PUT YOU PERSONAL TOUCHES ON YOUR HOME--COME EARLY AND MAKE YOUR OWN SELECTIONS!' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'SKA homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 19, Block 1, Bentwater 40' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '10400' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bentwater' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663706298' WHERE `Matrix_Unique_ID` = '211876667' --> 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','212064655','1663706299','212064655','2022-09-03T11:19:34.320','88842692','Lance Loken','Keller Williams Platinum','','','29.580387','-95.379535','48','77584','8','299999.00','Active','Larkspur','2731','Circle','Pearland','2','0','3','1783','Single-Family','Live in the heart of Pearland in this stunning brick home nestled in the gated 55+ community of CountryPlace. This fantastic 3-bedroom, 2-bathroom property boasts high ceilings, tile flooring, a wet bar, gas log fireplace, formal dining room, formal living room, and a covered patio in the spacious backyard. No recipe is a challenge in the island kitchen, equipped with granite countertops, a walk-in pantry, gas cooktop, dining nook, and breakfast bar. Relax in the primary suite, featuring a walk-in closet, dual vanities, jetted tub, and separate shower. Community comforts include a clubhouse with a fitness center, an 18-hole golf course, a resort-style pool, tennis courts, walking trails, and a scenic lake. Situated off Highway 288, residents enjoy quick access to Downtown Houston and Pearland Town Center while still enjoying the peace and charm of the suburbs. Call to tour your dream home today!','0.1584','5','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Pearland','Central Gas','1','COUNTRYPLACE SEC 3 (A0174-A0510) BLK 1 LOT 7','In Golf Course Community,Subdivision Lot','6900','Appraisal District','','180','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','42 - Pearland','CHALLENGER ELEMENTARY SCHOOL','GLENDA DAWSON HIGH SCHOOL','BERRY MILLER JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','Countryplace','4636','2.5552','Public Sewer,Public Water,Water District','1992','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','212120071','1663706299','212120071','2022-09-03T10:42:30.593','40204274','Amy Greene','New Leaf Real Estate','','','29.503177','-95.399048','34','77578','10','349000.00','Active','Palomar','4','','Manvel','3','1','5','3174','Single-Family','Unique opportunity in the fabulous Rodeo Palms subdivision on a great block. 5 bedrooms, 3 and one half bath with a Primary suite down, large game room up and open concept island kitchen and Den/Family room. All four secondary bedrooms are located upstairs. Large, green fenced backyard with covered patio. Minutes to Med Center and Downtown Houston! Seller has never occupied property. Sellers Disclosure to come.','','5','','','','','Mud,Sellers Disclosure','1','','','Alvin North','Central Gas','1','RODEO PALMS, PALM COURT SEC 1 (A0459 & A0299)(MANVEL) BLK','Subdivision Lot','6399','Appraisal District','','600','0','','2','','0','','','Gas Range','','Composition','3 - Alvin','DON JETER ELEMENTARY SCHOOL','MANVEL HIGH SCHOOL','RODEO PALMS JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','2','Traditional','Rodeo Palms','','','Water District','2005','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','212122020','1663706299','212122020','2022-09-03T11:17:09.210','85122159','David Jones','Evans and Associates','','','30.284623','-95.173275','17','77328','3','325000.00','Active','Morgan Cemetery','25106','Road','Cleveland','2','0','3','2000','Single-Family','This is a New still under construction 3 bedroom 2 bath Home with a 2 car garage Fronting Morgan Cemetery rd. Fire place , large lot, easy access to HWY 59. Choises still can be made in some of the items, colors counter tops ect...','0.272','40','SAPEC DESIGN & CONST','','','','No Disclosures','','','','Cleveland Area','Central Electric','1','NORTH WOODS 01, LOT 63','Subdivision Lot','11850','Appraisal District','','100','1','To Be Built/Under Construction','2','','0','','','','','Composition','47 - Splendora','GREENLEAF ELEMENTARY SCHOOL','SPLENDORA HIGH SCHOOL','SPLENDORA JUNIOR HIGH','Lockbox Front','Seller','1','Traditional','North Woods 01','139','2.0783','Public Water,Septic Tank','2022','Seller'); --> 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','212137322','1663706299','212137322','2022-09-03T10:28:11.963','76955256','Steven Montgomery','Keller Williams Premier RealtyKaty','','','29.778659','-95.726252','36','77450','10','350000.00','Active','Langton','714','Court','Katy','2','1','4','2589','Single-Family','STOP THE CAR!!! This wonderful 4 bedroom home on a CUL-DE-SAC street in the MUCH DESIRED neighborhood of Nottingham Country features 2.5 bathrooms, lush landscaping, a sparkling POOL, and garage entry from the alley! NO CARPET DOWNSTAIRS, a gas log fireplace in the den, 2018 Lennox HVAC recent paint inside and out, 2014 roof, ZONED TO TOP RATED KatyISD SCHOOLS which are in walking distance, and easy access to I-10 make this home a MUST SEE! You will be impressed by the large mature trees provides a canopy of shade throughout the neighborhood! This home is priced to sell and will not last long!','0.1608','36','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Katy - Southeast','Central Gas','1','LT 20 BLK 13 NOTTINGHAM COUNTRY SEC 3','Cul-De-Sac,Subdivision Lot','7005','Appraisal District','','300','0','','2','Freestanding Oven,Gas Oven','1','Gunite,In Ground','','Freestanding Range,Gas Range','','Composition','30 - Katy','NOTTINGHAM COUNTRY ELEMENTARY SCHOOL','TAYLOR HIGH SCHOOL (KATY)','MEMORIAL PARKWAY JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Nottingham Country','6076','2.3693','Public Sewer,Public Water,Water District','1976','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','212158356','1663706299','212158356','2022-09-03T10:06:03.640','85303951','Vivian Nguyen','Nextgen Real Estate Properties','','','29.774602','-95.544699','20','77024','8','900000.00','Active','Perthshire','12302','Road','Houston','2','0','4','2242','Single-Family','This beautiful, completely remodeled one-story home sits on a corner lot ideally located in one of Houston\'s most desirable areas, zoned to exemplary Bunker Hill Elementary, Memorial Middle and High School. Interior features and finishes include all brand new tile floors, quartz countertops, stainless steel appliances and fresh paint all throughout. This four bedroom home also offers generously sized bedrooms with built-in cabinetry, beautifully remodeled bathrooms and a new tankless water heater. Additional upgrades to the home include a brand new roof, new fence, PEX plumbing throughout and a resurfaced driveway with a new automatic driveway gate. Just minutes away from the Memorial City Mall, City Center - restaurants and shopping!','0.2273','23','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','1','Memorial West','Central Gas','1','LT 1 BLK 2 MEMORIAL HOLLOW SEC 1','Corner','9900','Appraisal District','','495','0','','1','Electric Oven,Freestanding Oven','0','','','Electric Cooktop,Electric Range,Freestanding Range','','Composition','49 - Spring Branch','BUNKER HILL ELEMENTARY SCHOOL','MEMORIAL HIGH SCHOOL (SPRING BRANCH)','MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)','Appointment Required,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Contemporary/Modern,Traditional','Memorial Hollow Sec 01','12915','2.4415','Public Sewer,Public Water','1961','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','212158762','1663706299','212158762','2022-09-03T10:49:27.797','72878752','Yohan Adhitama','REALM Real Estate Professional','','','29.887713','-95.436171','24','77088','7','244900.00','Active','Drayton','2123','Lane','Houston','2','0','4','1962','Single-Family','Lovely one story house with 4 beds and 2 baths. Tons of upgrade. Fresh interior paint, new roof, new HVAC, new Quartz countertops and backsplash, new gas oven, new cooktop, new light fixture, new kitchen sink & faucet, new mirror, & new dishwasher. Easy access to I-45 & Hwy. 249, & also 610. Schedule your showing today.','0.1515','11','','','Washer Connections','','Owner/Agent,Sellers Disclosure','1','','','Northwest Houston','Central Gas','0','LT 836 BLK 26 HEATHER GLEN SEC 3','Subdivision Lot','6600','Appraisal District','','','0','','0','Gas Oven','0','','','Gas Cooktop','','Composition','1 - Aldine','HILL ELEMENTARY SCHOOL (ALDINE)','EISENHOWER HIGH SCHOOL','GARCIA MIDDLE SCHOOL','Lockbox Front','Appraisal District','1','Traditional','Heather Glen Sec 03','3075','2.1553','Public Sewer,Public Water','1977','Appraisal District'); --> New record created successfully