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-10-15T21:01:49.997' ,`MLSNumber` = '91352094' ,`ListAgentFullName` = 'Bobbie Alexander' ,`ListOfficeName` = 'Alexander Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.914415' ,`Longitude` = '-95.737340' ,`PhotoCount` = '46' ,`PostalCode` = '77433' ,`RoomCount` = '12' ,`ListPrice` = '536981.00' ,`Status` = 'Active' ,`StreetName` = 'Copan Terrace' ,`StreetNumber` = '21046' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2937' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS#91352094 REPRESENTATIVE PHOTOS ADDED! Built by Taylor Morrison, Ready October - The attractive Camelia has it all! Soaring ceilings and natural light from upper windows, but with added peace and quiet of private second floor living spaces. Open kitchen with incredible cabinet storage, oversized pantry, windows over the sink and prep space! A second main level bedroom is perfect for guests! The owner\'s suite is perfectly tucked in the back of home with dual sinks and extra large closet. Three additional large bedrooms are upstairs connected to the game room. Structural options added to 21046 Copan Terrace Dr include: Media room, study, slide-in tub at owner\'s bath, bench at owner\'s entry, bath 4, 8\' interior doors and bay window in owner\'s suite.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 3 BRIDGE CREEK SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8289' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WELLS ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Bridge Creek 45\'s' ,`TaxAmount` = '' ,`TaxRate` = '3.59' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665928751' WHERE `Matrix_Unique_ID` = '206207987' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T21:20:29.097' ,`MLSNumber` = '23999580' ,`ListAgentFullName` = 'Michael Alexander' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819412' ,`Longitude` = '-95.437276' ,`PhotoCount` = '27' ,`PostalCode` = '77018' ,`RoomCount` = '0' ,`ListPrice` = '449999.00' ,`Status` = 'Active' ,`StreetName` = 'Oatfield' ,`StreetNumber` = '2116' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2112' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your palace awaits! Newly constructed. The perfect blend of City and Suburban living right in the heart of the beloved community of Oak Forest. This elegant home includes 3 bedrooms, 3.5 baths, 3 story living, a 2-car garage, and an open floor plan with ample natural lighting. Inside this one-of-a-kind home you will find huge walk-in closets, High ceilings, a Gourmet kitchen with an abundance of solid wood Cabinets, Calacatta Quartz countertops and over-sized island, Bamboo and Porcelain flooring, sleek and modern fixtures and features, and covered balconies. Location! Only a few minutes away from freeway access which places you less than 10 mi. from popular areas like the Medical Center, Heights, the Galleria, Energy Corridor, and Downtown Houston. Both Airports are less than 20 mi. away and there are also plenty of local restaurants, bars and attractions within walking distance. Video Tour: https://youtu.be/1WI8i386J6M' ,`Acres` = '0.0359' ,`Area` = '9' ,`BuilderName` = 'Fisher Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 1 FISHER ESTATES AT OAK FOREST' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1562' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'OAK FOREST ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Other Style' ,`Subdivision` = 'Fisher Ests/Oak Forest' ,`TaxAmount` = '4263' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928751' WHERE `Matrix_Unique_ID` = '207102911' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T20:31:47.030' ,`MLSNumber` = '87873391' ,`ListAgentFullName` = 'Aaron Harris' ,`ListOfficeName` = 'Aaron Harris Realty' ,`SellingAgentFullName` = 'Jeronimo Guerrero' ,`SellingOfficeName` = 'Lucky Money Real Estate' ,`Latitude` = '29.789016' ,`Longitude` = '-95.379103' ,`PhotoCount` = '48' ,`PostalCode` = '77009' ,`RoomCount` = '13' ,`ListPrice` = '1545000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Merrill' ,`StreetNumber` = '629' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3924' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning Modern Farmhouse, Recent Construction on Corner Lot in the Heart of The Heights! Charming Front Porch welcomes to Two Story Foyer & Staircase w/ Minimalist, Sleek Railings. Generous Private Study w/ Powder Bath. Wood Floors & Natural Light Flood All Areas of this Spectacular Home! Open Concept Living w/ All of the Amenities, Meticulously Planned for Function highlighting Natural Finishes. Stunning Quartz Island Kitchen, Thermador Towers Fridge & Freezer, Freestanding Range, Elegant Custom Cabinetry & Floating Shelves. 2nd Sink in Caterer Kitchen & Ultimate Pantry. Family & Dining Along Walls of Windows w/ Sophisticated Fireplace & Lighting. Seamless Indoor/Outdoor Entertaining w/ Serving Bar & Inlaid Wood Ceiling Treatment Opens out to Patio & Gardens. Primary Sanctuary w/ Inlaid Wood Ceilings, Serene Spa features Freestanding Soaking Tub, Exquisite Oversized Shower, Extensive Dual Vanities, Dressing Area w/ Massive Closet. Contemporary Game/Media. Pristine Secondary Ensuites!' ,`Acres` = '0.1435' ,`Area` = '9' ,`BuilderName` = 'Aspire Fine Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 12 WILLBORG' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Willborg Woodland Heights' ,`TaxAmount` = '36887' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928751' WHERE `Matrix_Unique_ID` = '207874561' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T20:07:00.677' ,`MLSNumber` = '30019042' ,`ListAgentFullName` = 'Fred Michael' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.657048' ,`Longitude` = '-95.121455' ,`PhotoCount` = '30' ,`PostalCode` = '77505' ,`RoomCount` = '8' ,`ListPrice` = '525000.00' ,`Status` = 'Active' ,`StreetName` = 'Merritt' ,`StreetNumber` = '7519' ,`StreetSuffix` = 'Lane' ,`City` = 'Pasadena' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2935' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A Rare find! Stunning one-story Margaret floorplan featuring 4 bedrooms, 3 baths, with 3 car tandem garage on large lot. Beautiful maple cabinets and quartz countertops in kitchen. Open concept with elegant dining room. Easy access kitchen and walk-in pantry. Stone fireplace with cedar mantel and raised heath. Dual vanity sinks, huge walk-in closet and separate tub and shower in owner\'s luxury bath. Covered backyard patio. Thousands in upgrades from base builder model (per seller).' ,`Acres` = '0.2288' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 1 (PR YR IMPS ONLY 2020*1408540010032) PARKWAY TRA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9967' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'JP DABBS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRMONT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkway Trails' ,`TaxAmount` = '10370' ,`TaxRate` = '2.6198' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928751' WHERE `Matrix_Unique_ID` = '208337838' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T21:18:36.637' ,`MLSNumber` = '34185037' ,`ListAgentFullName` = 'Kati Hall' ,`ListOfficeName` = 'RE/MAX On The Water - Bolivar' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.472624' ,`Longitude` = '-94.592249' ,`PhotoCount` = '41' ,`PostalCode` = '77650' ,`RoomCount` = '3' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Gateway' ,`StreetNumber` = '939' ,`StreetSuffix` = '' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1559' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION home just minutes from the Beach! Home will offer vaulted ceiling in the living room area and open to the kitchen. Upstairs you will find the Primary bedroom with private balcony! Enjoy the sound of the waves and the beautiful views while sipping your morning coffee. This property is the perfect location! Close to Restaurant\'s and Shopping. Call today this one won\'t last long! \r\nPhotos are not of the current home but of similar homes completed.' ,`Acres` = '0.1033' ,`Area` = '33' ,`BuilderName` = 'Prestige' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 65 B FRANKS SUR LOT 26 BLK 7 GATEWAY' ,`LotDesciption` = 'Other' ,`LotSize` = '4500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Gateway' ,`TaxAmount` = '333' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665928752' WHERE `Matrix_Unique_ID` = '208402184' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T20:41:01.620' ,`MLSNumber` = '90578914' ,`ListAgentFullName` = 'Ekaterine Khmaladze' ,`ListOfficeName` = 'R. Alexa Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.669427' ,`Longitude` = '-95.502742' ,`PhotoCount` = '34' ,`PostalCode` = '77096' ,`RoomCount` = '9' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Bob White' ,`StreetNumber` = '10210' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2310' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful, updated home is located in Maplewood. Easy commute to TMC, Downtown, Galleria. Architect\'s Influence throughout the House. Walls have been opened between the Foyer, Formal LR, and Family Room.Underground plumbing replaced with PVC to City Sewer, new PEX Piping in the whole house, New water heater. Marble Floors in the Foyer and Formal LR. Den has High Cathedral Ceiling, Marble-Faced Fireplace.New ceiling fans and recess lights in whole house.The home is enhanced by tile floors. Kitchen was remodeled with Shaker Cabinets,Granite Counters; it\'s equipped with brand new LG Stainless Steel Appliance Package. 4th Bedroom opens to primary bedroom--wall could be reconstructed. Primary Bedroom with en suite bath and walk-in closets Primary Bath has dual sinks,vanity area. A 2-car attached garage with covered walkway to the house. The garage has built in cabinets. In the attic there is an extra storage room that is air conditioned and has shelves for easy storage. ' ,`Acres` = '0.2017' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 37 MAPLEWOOD SOUTH SEC 7 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8784' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '488' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ELROD ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'FONDREN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Maplewood South Sec 07 R/P' ,`TaxAmount` = '6120' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928752' WHERE `Matrix_Unique_ID` = '209066972' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T21:32:37.563' ,`MLSNumber` = '89771518' ,`ListAgentFullName` = 'Ali Guven' ,`ListOfficeName` = 'REB365' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.649689' ,`Longitude` = '-95.595130' ,`PhotoCount` = '11' ,`PostalCode` = '77477' ,`RoomCount` = '8' ,`ListPrice` = '289900.00' ,`Status` = 'Active' ,`StreetName` = 'Brook Meadows' ,`StreetNumber` = '12410' ,`StreetSuffix` = 'Lane' ,`City` = 'Meadows Place' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2114' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION, LOCATION, LOCATION! Welcome to 12410 Brook Meadows Ln, ZONED to top rated FORT BEND ISD schools, including the brand new Meadows Elementary School. Fridge, washer & dryer are included.\r\nLow Tax rate of 2.5% and NO HOA !!! This beauty won\'t last long. Schedule your tour today!' ,`Acres` = '0.1255' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Stafford Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'MEADOWGLEN SEC 2, BLOCK 10, LOT 32' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5468' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'MEADOWS ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Lockbox Right Side,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Meadowglen' ,`TaxAmount` = '5413' ,`TaxRate` = '2.4949' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928752' WHERE `Matrix_Unique_ID` = '209926429' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T20:37:01.087' ,`MLSNumber` = '29054908' ,`ListAgentFullName` = 'Violet Gonzalez' ,`ListOfficeName` = 'Crown Eagle Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.574152' ,`Longitude` = '-95.358782' ,`PhotoCount` = '39' ,`PostalCode` = '77584' ,`RoomCount` = '6' ,`ListPrice` = '359899.00' ,`Status` = 'Active' ,`StreetName` = 'Norfolk' ,`StreetNumber` = '1035' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2144' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new home in the highly sought after community of Southdown. Zoned to the exemplary Pearland ISD, and highly desired Dawson High School. This popular floorplan boast 3 bedroom, 2 full baths, and a study/office with French doors with a spacious island kitchen and ample storage. The separate study which can be easily used a media room, game room, or craft room; leaving your dedicated bedrooms for you and your family. Massive chef’s kitchen with granite counter tops, new backsplash, large island and breakfast area ready for family gatherings and Sunday morning breakfast as you over look the inviting family room. Split plan with secondary bedrooms equipped with large closets and plenty of storage. Brand new roof 2022. Nice gazebo to enjoy the backyard and playground setup for kids. Make your appt today to come view this gem in Southdown!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SOUTHDOWN S/D, BLOCK 1, LOT 25 SEC 7, A0506 H T & B' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'CHALLENGER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GLENDA DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'BERRY MILLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Southdown Sub' ,`TaxAmount` = '5867' ,`TaxRate` = '2.70021' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928752' WHERE `Matrix_Unique_ID` = '210417902' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T21:56:03.200' ,`MLSNumber` = '91982021' ,`ListAgentFullName` = 'Jineane Owen' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.132594' ,`Longitude` = '-95.298597' ,`PhotoCount` = '31' ,`PostalCode` = '77365' ,`RoomCount` = '7' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Woodsdale' ,`StreetNumber` = '18166' ,`StreetSuffix` = 'Court' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1587' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come fall in love with this meticulously maintained single story home located in Cumberland Community. Primary suite has sitting area with large walk-in closet. This lovely kitchen features a raised bar which opens up to the dining and living room and easily flows to the back patio for outdoor entertaining. The fenced back yard off the living room has a replastered & tiled pool with a slide & back patio for summers out in the sun. The home offers a split floor plan with a home office at the front of the home. exterior paint (2021), HVAC (2020), Fence (2020), sprinkler system, pool pump (2021). NCISD Crippen Elementary school within the subdivision. Community pool, park, basketball court & walking trails. Easy access to 99 & Valley Ranch.' ,`Acres` = '0.1377' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CUMBERLAND PHASE I, BLOCK 8, LOT 16' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'ROBERT CRIPPEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cumberland Ph I' ,`TaxAmount` = '4333' ,`TaxRate` = '2.7931' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928752' WHERE `Matrix_Unique_ID` = '210676314' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T20:11:18.370' ,`MLSNumber` = '66728944' ,`ListAgentFullName` = 'Francis Choy' ,`ListOfficeName` = 'TOPRO Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.575214' ,`Longitude` = '-95.428723' ,`PhotoCount` = '39' ,`PostalCode` = '77584' ,`RoomCount` = '12' ,`ListPrice` = '549000.00' ,`Status` = 'Active' ,`StreetName` = 'Mystic Arbor' ,`StreetNumber` = '13509' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This waterfront home is conveniently located in the high demanded Shadow Creek Ranch in Pearland. House features 4-bedrooms and 4 full bathrooms. 3-car garage. High ceiling, contemporary flooring, wrought iron basket spindles, gas log fireplace, large window allows lots of natural lighting throughout. Study room, game room, media room and spacious balcony. Nice size extended covered patio at the backyard for perfect guests entertaining. Relaxing to enjoy quiet evenings with spectacular waterfront viewing from balcony and more. Easy access to major highway including TX 288 and Beltway 8. Perfect location for many nearby amenities. Must see!' ,`Acres` = '0.1546' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SHADOW CREEK RANCH SF-45A, BLOCK 1, LOT 15' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '6734' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '999' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BLUE RIDGE ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'WILLOWRIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'MCAULIFFE MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadow Creek Ranch Sf-45a' ,`TaxAmount` = '11089' ,`TaxRate` = '3.2123' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928753' WHERE `Matrix_Unique_ID` = '210776905' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T20:32:00.243' ,`MLSNumber` = '10126259' ,`ListAgentFullName` = 'Joyce Quinn-Nichols' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.018051' ,`Longitude` = '-95.291854' ,`PhotoCount` = '26' ,`PostalCode` = '77338' ,`RoomCount` = '7' ,`ListPrice` = '229900.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Lodge Meadow' ,`StreetNumber` = '20434' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1412' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in Deerbrook Estates, NEW CARPET IN SOME BEDROOMS. this 3 bedroom home features 2 full baths, formal dining room with one living area. Kitchen has granite counter tops. Detached cover patio will remain. This location has community playgrounds, walking paths, a community pool. There are a number area amenities, Deerbrook Mall and Movie theater are approximately a 15 minute drive. There are major banks, grocery stores, minor emergency centers, health clubs, strip malls, dine in and fast food restaurants. Bush intercontinental Airport as well as interstate 59 are is an approximately a 15 to 20 minute drive away.' ,`Acres` = '0.1266' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 4 DEERBROOK ESTATES SEC 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5516' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'JONES ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Deerbrook Estates' ,`TaxAmount` = '4457' ,`TaxRate` = '2.7433' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928753' WHERE `Matrix_Unique_ID` = '210840455' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T21:12:04.613' ,`MLSNumber` = '88294207' ,`ListAgentFullName` = 'Sally Harris' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.029729' ,`Longitude` = '-95.477339' ,`PhotoCount` = '39' ,`PostalCode` = '77388' ,`RoomCount` = '4' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Annawood' ,`StreetNumber` = '4230' ,`StreetSuffix` = 'Circle' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3559' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Incredible opportunity to purchase this beautifully renovated property in Cypresswood- 4230 Annawood Circle! Stunning $40K Renovation recently completed August 2022! home offers 3559 sq ft of living area with beautiful kitchen, 4 spacious bedrooms, 3.5 bathrooms, huge game room with built-ins, large lot with hot tub & deck. Extensive renovation just completed including- New HVAC system, exterior & interior paint, laminate flooring, carpet upstairs bedrooms, Stainless-Steel appliances, vanities, toilets, faucets, mirrors, ceiling fans & light fixtures, hardware throughout, front & back doors re-painted, freshly landscaped flower beds, trees trimmed, deck repainted, hot tub repainted, garage door repainted & much more! Zoned to Klein ISD. Close to major highways, shopping & dining. Cypresswood amenities include pools, clubhouse, playgrounds, walking trails, pavilion, tennis courts & more! NO flood zone!' ,`Acres` = '0.2244' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 2 CYPRESSWOOD SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9775' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '484' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'HAUDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'STRACK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypresswood Sec 01' ,`TaxAmount` = '7070' ,`TaxRate` = '2.4565' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928753' WHERE `Matrix_Unique_ID` = '210926265' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T20:28:21.660' ,`MLSNumber` = '49269045' ,`ListAgentFullName` = 'Gil McCollin' ,`ListOfficeName` = 'RE/MAX Northwest, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.014819' ,`Longitude` = '-95.652840' ,`PhotoCount` = '45' ,`PostalCode` = '77429' ,`RoomCount` = '3' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Chestnut Branch' ,`StreetNumber` = '15719' ,`StreetSuffix` = 'Trail' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2188' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful well maintained two story home. Impressive backyard water view! The backyard is a generous size the could accommodate a pool and no neighbors directly behind the home. Nice home office or dining room situated just inside the front entrance. Family room with wall of windows opens to large gourmet kitchen with granite counter tops. Large primary bedroom and primary bath with double vanities and garden soaking tub. Spacious open game room. The two car garage is currently a state of the art workout gym. Walking and bike riding around the lake behind the house for leisurely or intense exercise. The playground is a short walking distance from this lovely home. Minutes from the future Grand Parkway Town Center (99 and 249). Schedule your showing soon!' ,`Acres` = '0.141' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 4 TELGE RANCH SEC 1' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '6144' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'BLACK ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Telge Ranch Sec 1' ,`TaxAmount` = '7377' ,`TaxRate` = '2.821' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928753' WHERE `Matrix_Unique_ID` = '211039662' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T20:44:05.260' ,`MLSNumber` = '92764359' ,`ListAgentFullName` = 'Patrick Ma' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.985635' ,`Longitude` = '-95.958836' ,`PhotoCount` = '18' ,`PostalCode` = '77414' ,`RoomCount` = '4' ,`ListPrice` = '149000.00' ,`Status` = 'Active' ,`StreetName` = '9th' ,`StreetNumber` = '2609' ,`StreetSuffix` = 'Street' ,`City` = 'Bay City' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '840' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3 bedroom 1 bath single story home. Property needs work. New pier and beam foundation, new HVAC, New flooring, new paint, new hot water heater, new windows, new doors, and new siding. You\'ll love this small house that\'s conveniently located in the city. Walking distance to Starbucks, HEB and elementary school.' ,`Acres` = '0.161' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ZIEGENHALS ADDITION, BLOCK 2, LOT 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7013' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '132 - Bay City' ,`SchoolElementary` = 'TENIE HOLMES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BAY CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BAY CITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ziegenhals Add' ,`TaxAmount` = '1219' ,`TaxRate` = '2.8238' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1665928753' WHERE `Matrix_Unique_ID` = '211486339' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T20:38:45.510' ,`MLSNumber` = '53292983' ,`ListAgentFullName` = 'Peggy West' ,`ListOfficeName` = 'Peggy West Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.833740' ,`Longitude` = '-95.468393' ,`PhotoCount` = '26' ,`PostalCode` = '77092' ,`RoomCount` = '8' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'De Milo' ,`StreetNumber` = '5129' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1522' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'JUST LISTED! Welcome to the most charming & well-loved home in sought-after Oak Forest. 5129 De Milo has been tastefully restored leaving a touch of its original charm. Owners have cared for this home meticulously. Features 4 Bedrooms, large Family room overlooking screened porch & wonderful Dining room with original hard wood floors, doublewide driveway with covered carport. Primary bedroom with adjoining Bonus Room - Perfect for baby room or home office. Fresh paint, new A/C (1 year labor warranty, 10 year equipment warranty), roof replaced. Large fenced backyard ready for family fun! Established Oak Forest subdivision has easy access to major freeways. Near great restaurants & shopping. They have their very own “Oak Forest Restaurant Week” with many participating restaurants. Home is move-in ready!' ,`Acres` = '0.1446' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 7 BLK 14 OAK FOREST SEC 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SMITH ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Forest Sec 16' ,`TaxAmount` = '5423' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928753' WHERE `Matrix_Unique_ID` = '211611615' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T20:05:12.243' ,`MLSNumber` = '2308936' ,`ListAgentFullName` = 'Gabriela Galaviz' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.624201' ,`Longitude` = '-95.381432' ,`PhotoCount` = '37' ,`PostalCode` = '77047' ,`RoomCount` = '7' ,`ListPrice` = '364990.00' ,`Status` = 'Active' ,`StreetName` = 'Skyview Point' ,`StreetNumber` = '2634' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2650' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 2634 Skyview Point Drive! This stunning home sits on a 4,400 sq/ft lot and offers a spacious 2,650 sq/ft of living space with 5 bedrooms, 2 and a half bathrooms, sits on a quiet street with beautiful landscaping, brick exterior, and all zoned to Houston ISD! You\'ll love all the incredible features this home has to offer, including a gorgeous primary suite, spacious living room, upstairs game room, wood cabinets, granite countertops and kitchen island, fully fenced backyard, covered back patio with no grass, and so much more! The home has been recently painted, has the original roof, new high end carpet in 2021, carpet on the stairs replaced with wood, upgraded primary bathroom with walk-in closet, and the house is ready to move in! Skyview Park is minutes from 288 and Sam Houston Tollway - in an excellent location! Schedule your private showing today!' ,`Acres` = '0.101' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 3 SKYVIEW PARK SEC 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LAW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Skyview Park' ,`TaxAmount` = '7083' ,`TaxRate` = '2.9307' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928754' WHERE `Matrix_Unique_ID` = '211720547' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T20:02:41.517' ,`MLSNumber` = '90429241' ,`ListAgentFullName` = 'Alex Arenas' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.606748' ,`Longitude` = '-95.596507' ,`PhotoCount` = '40' ,`PostalCode` = '77478' ,`RoomCount` = '11' ,`ListPrice` = '770000.00' ,`Status` = 'Active' ,`StreetName` = 'Sugar Creek' ,`StreetNumber` = '1218' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4181' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous and fully remodeled home located on prestigious Sugar Creek Boulevard inside Sugar Creek subdivision. This spacious home with an open floor plan was fully remodeled and painted in July 2022. A large Calcatta Vicenza quartz island with a new Euro-Style 36-inch 5-element Jenn-Air cooktop with downdraft and seating for four is the centerpiece of this Chef\'s kitchen. New stainless steel appliances, a farmhouse sink, stunning Calcatta Vicenza quartz countertops with white cabinetry and under-mount lighting, and a butler\'s pantry with a wine fridge complete the kitchen. Calcatta quartz is used throughout the home in the bathrooms and wet bar. New low-E french doors open up from the kitchen and from the gym/ sun room unto the new concrete deck and kitchen pad that are ready for your outdoor patio furniture and your new outside kitchen. This home boasts spa-like master bathrooms in both upstairs and downstairs primary suites with large vanities, jetted tubs, and separate showers.' ,`Acres` = '0.2441' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land East' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'SUGAR CREEK SEC 21, BLOCK 6, LOT 17' ,`LotDesciption` = 'In Golf Course Community' ,`LotSize` = '10633' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'DULLES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sugar Creek Sec 21' ,`TaxAmount` = '11194' ,`TaxRate` = '2.0094' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928754' WHERE `Matrix_Unique_ID` = '211896201' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T20:18:03.407' ,`MLSNumber` = '94843600' ,`ListAgentFullName` = 'Courtney Okanlomo' ,`ListOfficeName` = 'Collective Realty Co.' ,`SellingAgentFullName` = 'Matthew Garvin' ,`SellingOfficeName` = 'Keller Williams Metropolitan' ,`Latitude` = '29.618540' ,`Longitude` = '-95.391154' ,`PhotoCount` = '48' ,`PostalCode` = '77047' ,`RoomCount` = '8' ,`ListPrice` = '379900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Lake City' ,`StreetNumber` = '1406' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2292' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in City Park and built in 2019, this spacious DR Horton home has a serene lake view (no rear neighbor), has been FRESHLY PAINTED, and is only minutes from the Medical Center and downtown! The beautiful, open kitchen is complete with granite countertops, tile floors and all stainless steel appliances. The first floor master bedroom boasts double sinks and has an oversized shower. The 2nd story features a huge gameroom with 3 other bedrooms! The upstairs utility room is complete with Washer and Dryer and floating shelving. The community is complete with walking trails and parks just steps away! Enjoy easy access to Hwy 288, Beltway 8 and Loop 610, and views of the Houston City skyline from the Neighborhood. Shopping, Grocery Stores, Restaurants, and Hospitals are only moments away in Pearland. Contact me today to tour and purchase this beautiful home!' ,`Acres` = '0.101' ,`Area` = '3' ,`BuilderName` = 'DR HORTON' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 1 CITY PARK SOUTH SEC 6' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '4400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1275' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ALMEDA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'City Park South Sec 6' ,`TaxAmount` = '8049' ,`TaxRate` = '3.0307' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928754' WHERE `Matrix_Unique_ID` = '211932415' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T20:24:32.857' ,`MLSNumber` = '35633050' ,`ListAgentFullName` = 'Hai Huynh' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.687067' ,`Longitude` = '-95.657998' ,`PhotoCount` = '27' ,`PostalCode` = '77083' ,`RoomCount` = '3' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Schumann' ,`StreetNumber` = '15411' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1362' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful updated home ready to move-in with 3 bed, 2 bath, 1-story. This home is conveniently located near Highway 6, Westpark Tollway and Highway 90. Minutes to Sugar Land shopping center and Colony Mall.' ,`Acres` = '0.1434' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MISSION GLEN SEC 2, BLOCK 5, LOT 37' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6246' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '291' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'MISSION GLEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'HODGES BEND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mission Glen Sec 2' ,`TaxAmount` = '3120' ,`TaxRate` = '2.2857' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928754' WHERE `Matrix_Unique_ID` = '211995178' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T21:32:46.563' ,`MLSNumber` = '2437891' ,`ListAgentFullName` = 'Peggy Dean' ,`ListOfficeName` = 'David Tracy Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.033919' ,`Longitude` = '-95.510712' ,`PhotoCount` = '28' ,`PostalCode` = '77379' ,`RoomCount` = '10' ,`ListPrice` = '410000.00' ,`Status` = 'Active' ,`StreetName` = 'Misty Creek' ,`StreetNumber` = '17007' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2703' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This lovely home has been thoroughly renovated and is ready for move-in. Soaring 2-story ceiling in the family room. Formal dining room is just off the entry and leads to a sparkling clean kitchen that is a chef\'s dream; totally upgraded with quartz countertops, all new appliances, tons of drawers, cabinets, and countertop space along with a large walk-in pantry; ample space for hosting all of your family holiday gatherings. Downstairs primary suite with double sinks and separate tub and shower in the bathroom. Large game room up with three spacious bedrooms and two completely renovated bathrooms. One of the baths is a Jack & Jill. This gorgeous home is on a quarter of an acre (pool size) lot and has a perfect garden spot behind the garage. Beautiful neighborhood, peaceful street, and great neighbors make this the perfect home for your family. You family will love living here!' ,`Acres` = '0.2663' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 5 SPRING CREEK OAKS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '940' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KUEHNLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Creek Oaks' ,`TaxAmount` = '6726' ,`TaxRate` = '2.5965' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928754' WHERE `Matrix_Unique_ID` = '212138540' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T20:26:53.410' ,`MLSNumber` = '3423723' ,`ListAgentFullName` = 'Sandra Hasty' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = 'Kerisha Loctor' ,`SellingOfficeName` = 'All City Real Estate, Ltd. Co.' ,`Latitude` = '29.866160' ,`Longitude` = '-95.192115' ,`PhotoCount` = '31' ,`PostalCode` = '77044' ,`RoomCount` = '8' ,`ListPrice` = '254000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Gardenia Mist' ,`StreetNumber` = '13355' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1980' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 1980 sq ft , 4 bedroom, 3 full bath, 2 car garage home in Sunrise Pines. Open concept kitchen, dining and living area. Well designed floor plan. One bedroom down, 3 up (including primary with en-suite bath and walk in closet), Game room upstairs! You will love the space and appreciate the layout of the bedrooms. Backyard is ready to be customized to your taste! Close to major highways for a quick and easy commute. Don\'t wait! Schedule your showing , Make this home yours today!' ,`Acres` = '0.1014' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 3 SUNRISE PINES SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4419' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '363' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'SHELDON LAKEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'C.E. KING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunrise Pines Sec 2' ,`TaxAmount` = '5940' ,`TaxRate` = '2.9993' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928755' WHERE `Matrix_Unique_ID` = '212212871' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T20:04:12.043' ,`MLSNumber` = '36001196' ,`ListAgentFullName` = 'Devin Hooper' ,`ListOfficeName` = 'Virginia Malone Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.473424' ,`Longitude` = '-94.924728' ,`PhotoCount` = '50' ,`PostalCode` = '77539' ,`RoomCount` = '19' ,`ListPrice` = '499900.00' ,`Status` = 'Active' ,`StreetName` = '8th' ,`StreetNumber` = '1422' ,`StreetSuffix` = 'Street' ,`City` = 'San Leon' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2471' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Imagine sitting on your covered porch watching the sunrise or sunset, Maybe watch a thunderstorm gather in the distance as it crosses the Galveston Bay. All of that is possible in this Amazing Water View Home. The house sits on a peninsula with water views on 3 sides and there is great restaurant’s, marinas and fishing just minutes away. This home has so many features it’s hard to list them all. Gas Generator built into home in case you lose power. Main living area upstairs features 2100 sqft of living space, downstairs could be an apartment with kitchen/living/dining combo, bedroom & bathroom or could be a bar or entertainment area. There is a spiral staircase that could be converted into an elevator. There is also a workout/craft room. Pull through garage, plenty of parking and Storage. This could be used as weekend rental, and it is move-in ready.\r\nCheck out Video Walk Through. Home is Occupied. Motivated Seller, Submit all Offers.' ,`Acres` = '0.2307' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Central Gas,Wall Heater,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 10 A EDWARDS LOTS 35 TO 37 BLK 211 SAN LEON' ,`LotDesciption` = 'Water View' ,`LotSize` = '10050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'SAN LEON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'San Leon WV Southeast' ,`TaxAmount` = '9703' ,`TaxRate` = '2.521' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928755' WHERE `Matrix_Unique_ID` = '212223280' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T21:56:12.967' ,`MLSNumber` = '67796717' ,`ListAgentFullName` = 'Sinai Paz' ,`ListOfficeName` = 'Jason Mitchell Real Estate LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.078555' ,`Longitude` = '-95.205742' ,`PhotoCount` = '35' ,`PostalCode` = '77339' ,`RoomCount` = '7' ,`ListPrice` = '308000.00' ,`Status` = 'Active' ,`StreetName` = 'Creek Manor' ,`StreetNumber` = '2811' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2212' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great Family home includes 4 bed/2.5 bath plus game room on a huge lot. The backyard is an entertainers dream with an inground heated pool. The kitchen has an amazing view of the pool area. Home has a new roof installed last year, New water heater in 2021. Elmgrove Village subdivision offers two parks, tennis courts and a swimming pool. Close to Hwy 59 and Hwy 99, retail shopping, entertainment, airport, dining, Golfing and much more.' ,`Acres` = '0.2438' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 22 ELM GROVE VILLAGE SEC 2' ,`LotDesciption` = 'Cleared' ,`LotSize` = '10618' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '398' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'ELM GROVE ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Elm Grove Village Sec 02' ,`TaxAmount` = '5965' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928755' WHERE `Matrix_Unique_ID` = '212376708' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T20:07:35.420' ,`MLSNumber` = '12204715' ,`ListAgentFullName` = 'Durran Starks' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.490802' ,`Longitude` = '-95.387759' ,`PhotoCount` = '39' ,`PostalCode` = '77578' ,`RoomCount` = '5' ,`ListPrice` = '619000.00' ,`Status` = 'Active' ,`StreetName` = 'Basin Park' ,`StreetNumber` = '4238' ,`StreetSuffix` = 'Drive' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3133' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stop your car HERE IT IS! One of Shea Homes recently built property is now available. Beautiful 2-story stucco exterior, 3-car garage, with 4 bedrooms, 3 baths. Home office with French doors set at entry with 10-foot ceiling. The fabulous kitchen comes with built-in oven, a 5-burner gas cooktop and an oversized island with easy care granite countertop and cabinets galore. An abundance of natural light throughout the home. Dining area flows into family room with wall of windows and 20 ft ceiling. Primary suite includes hallway entry to the En-suite bath with dual vanities, garden tub, separate glass-enclosed shower and large walk-in closet. Tons of living space upstairs connected to spacious bedrooms with walk-in closets. Oversize covered backyard patio. With over $20,000 worth of upgrades and NO BACK NEIGHBORS this one won\'t last long...' ,`Acres` = '0.186' ,`Area` = '5' ,`BuilderName` = 'Shea Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'DEL BELLO LAKES SEC 3 (A0460 HT&BRR) (MANVEL) BLK 2 LOT 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8102' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'E C MASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'MANVEL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Del Bello Lks' ,`TaxAmount` = '17278' ,`TaxRate` = '3.7394' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928755' WHERE `Matrix_Unique_ID` = '212419719' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T21:34:17.480' ,`MLSNumber` = '75702705' ,`ListAgentFullName` = 'Shanna Carew' ,`ListOfficeName` = 'Henry Fuertes Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.816116' ,`Longitude` = '-95.022814' ,`PhotoCount` = '35' ,`PostalCode` = '77562' ,`RoomCount` = '5' ,`ListPrice` = '255000.00' ,`Status` = 'Active' ,`StreetName` = 'Foxglove' ,`StreetNumber` = '2503' ,`StreetSuffix` = 'Street' ,`City` = 'Highlands' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1868' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Must see one story home that has been fully renovated \"like new\" located in highlands, TX close to I-10 Lots of upgrades, all windows replaced with double paned energy efficient windows, new luxury vinyl throughout and new carpet in the bedrooms. Kitchen updated with new 42-inch elegant shaker cabinets, quartz countertops, polish marble mosaic tile backsplash and new stainless steel appliances including Gas range with air fryer and Wifi Connection. Bathrooms completely updated with double sinks as well as new shower and new cabinets, marble countertops and polish marble mosaic accent tiles in both bathrooms! HVAC systems updated in 2020 new ductwork, new furnace, and new condenser!! New 30-year roof installed in 2022. You don\'t want to miss the chance to own this \"like new\" home for creating great memories with your family!! Many other \r\nupgrades too numerous to mention!! You will not be disappointed! Call your agent and schedule your appointment today!\r\nHOUSE NEVER FLOODED' ,`Acres` = '0.2121' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 148 COUNTRY TERRACE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9240' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'HOPPER/HIGHLANDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Country Terrace Sec 02' ,`TaxAmount` = '3669' ,`TaxRate` = '2.235' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928755' WHERE `Matrix_Unique_ID` = '212447892' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T20:46:43.427' ,`MLSNumber` = '10320848' ,`ListAgentFullName` = 'Yvette Williams' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.810373' ,`Longitude` = '-94.896018' ,`PhotoCount` = '27' ,`PostalCode` = '77523' ,`RoomCount` = '10' ,`ListPrice` = '294000.00' ,`Status` = 'Active' ,`StreetName` = 'Laurel' ,`StreetNumber` = '8102' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2649' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Country Meadows: This spacious 4 bedroom home comes with a large game room and offers an extra bonus room above the garage. Backyard is completely fenced in and has a covered back patio. Desired corner lot. Roof replaced in 2015. Check out the 3-D tour link and take a virtual walk-thru.' ,`Acres` = '0.174' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Chambers County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 43 COUNTRY MEADOWS SEC 4' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7579' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '175' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'CLARK ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Country Mdws Sec 4' ,`TaxAmount` = '7039' ,`TaxRate` = '2.8882' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928756' WHERE `Matrix_Unique_ID` = '212570168' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T20:45:36.393' ,`MLSNumber` = '40739322' ,`ListAgentFullName` = 'Patrick Ma' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.136567' ,`Longitude` = '-95.652587' ,`PhotoCount` = '10' ,`PostalCode` = '77486' ,`RoomCount` = '13' ,`ListPrice` = '219900.00' ,`Status` = 'Active' ,`StreetName` = 'Columbia' ,`StreetNumber` = '912' ,`StreetSuffix` = 'Drive' ,`City` = 'West Columbia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1650' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Heavily renovated 4 bedroom, 3 baths home sitting on a large lot. Unrestricted and very private even though it\'s on highway 36. 2 new HVAC systems, new flooring, new kitchen appliances, countertops, and garage doors. Brand new paint and lights throughout. Tons of storage and closets with a huge laundry room, storage under the stairs, bonus room behind the garage, and a sunroom upstairs you can use as an office. Oversized garage that can park 2 cars and many toys. Easy access to highway 36 with stores down the street and high school across the street. Setback from the main road so it\'s quiet and private. No known restrictions but buyer and buyer\'s agent to verify all dimensions, restrictions, and details of the home.' ,`Acres` = '0.28' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOGGINS S/D TRS 4-4A (A0040 J H BELL DIV 1)(WEST COLUMBIA),' ,`LotDesciption` = 'Wooded' ,`LotSize` = '12197' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Loggins Sub Trs 4-4a' ,`TaxAmount` = '2445' ,`TaxRate` = '2.4263' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928756' WHERE `Matrix_Unique_ID` = '212584791' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T20:23:06.090' ,`MLSNumber` = '67499718' ,`ListAgentFullName` = 'Glenda Nochez' ,`ListOfficeName` = 'Coldwell Banker PropertiesUnlimited' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.180219' ,`Longitude` = '-96.412071' ,`PhotoCount` = '22' ,`PostalCode` = '77833' ,`RoomCount` = '4' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Mckinney' ,`StreetNumber` = '1506' ,`StreetSuffix` = 'Court' ,`City` = 'Brenham' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1783' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Liberty Village. Look at this charm, beautiful inside and out. This house was completed in 2021. When you enter the house you have a room that can be used as a home office or a 4th bedroom. Walk into an open concept kitchen with a large island and stainless-steel appliances. Opens to dinning room and living room perfect for family gatherings. Primary shower with beautiful tiles and flooring. Double sink for extra space, and spacious walk-in-closet. All newly built wooded fence for privacy. Located in a cul-de-sac. Near elementary school, groceries store, and new shopping center. About an hour drive away from Houston. And 45 min drive to College Station. There is a walk way that leads straight to the elementary near by. This 4 bedroom 2 full bathroom home is the one to call home! This gem won\'t last long. Call and schedule your showing today. Square footage to be verified by buyer.' ,`Acres` = '0.182' ,`Area` = '58' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S3803 - LIBERTY VILLAGE S/D, BLOCK 5, LOT 4, ACRES 0.182' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7928' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '365' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '137 - Brenham' ,`SchoolElementary` = 'BISD DRAW' ,`SchoolHigh` = 'BRENHAM HIGH SCHOOL' ,`SchoolMiddle` = 'BRENHAM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Liberty Vlg Sub' ,`TaxAmount` = '346' ,`TaxRate` = '2.0369' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928756' WHERE `Matrix_Unique_ID` = '212609286' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T21:30:53.073' ,`MLSNumber` = '10972314' ,`ListAgentFullName` = 'Rebecca Ramirez' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = 'Jill Evans' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '30.007648' ,`Longitude` = '-95.195760' ,`PhotoCount` = '32' ,`PostalCode` = '77346' ,`RoomCount` = '8' ,`ListPrice` = '239900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Misty Moon' ,`StreetNumber` = '5303' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2001' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '4 bedroom 2 ½ bathroom home in Atascocita located on corner lot of a subdivision street with the convenience of sidewalks and features: a spacious backyard, front landscape bedding area, backyard water fountain with pond, and shade trees. In the kitchen: gas oven/range, breakfast bar, and pantry. Home also has: fireplace, in house utility room with cabinets and shelving, large concrete back patio slab, high ceiling, and fenced backyard. Interior recently painted, recently purchased a new dishwasher, and newer carpet. Area features: local shopping, dining, gym, and entertainment. Close access to 1960, W Lake Houston Pkwy, Beltway 8, and Lindsay Lyons Park and Sports Complex.' ,`Acres` = '0.2237' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 9 ATASCOCITA WEST SEC 2' ,`LotDesciption` = 'Cleared,Corner,Subdivision Lot' ,`LotSize` = '9744' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'TIMBERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Back,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Atascocita West' ,`TaxAmount` = '4134' ,`TaxRate` = '2.613' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928756' WHERE `Matrix_Unique_ID` = '212652381' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T20:58:00.710' ,`MLSNumber` = '21007467' ,`ListAgentFullName` = 'Renae Gibson' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.811880' ,`Longitude` = '-95.401230' ,`PhotoCount` = '29' ,`PostalCode` = '77008' ,`RoomCount` = '5' ,`ListPrice` = '439900.00' ,`Status` = 'Active' ,`StreetName` = '28th' ,`StreetNumber` = '258' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2212' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NO HOA FEES. 3 story corner home on premium lot with nice sized yard. Very rare find. Primary bedroom located on 3rd floor and it looks like an upscale luxury suite. Primary bathroom has large shower and separate garden soaking tub. Long vanity gives you great space to prepare for your day. Second bedroom w private bathroom plus laundry also on the 3rd floor. There is another bedroom on 1st floor with full bath that includes a large shower. Home has been painted inside with modern updated designer colors. Chef\'s kitchen that has custom cabinetry, large island, stainless appliances and granite countertops. Updated backsplash, handles and faucets throughout. Custom wet bar with wine fridge are here and the formal dining will accommodate large gatherings. Notice the updated light fixtures. Living room boasts wood flooring and is a great entertaining space. 5 minutes to hike/bike trail, shopping and great restaurants.' ,`Acres` = '0.0415' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 BLK 1 ERIN PARK ON WEST 28TH STREET' ,`LotDesciption` = 'Corner' ,`LotSize` = '1807' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HELMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Erin Pk/West 28th Street' ,`TaxAmount` = '10408' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928756' WHERE `Matrix_Unique_ID` = '212667750' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T20:15:32.960' ,`MLSNumber` = '35270013' ,`ListAgentFullName` = 'Jacque Kendrick' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.085666' ,`Longitude` = '-95.665664' ,`PhotoCount` = '43' ,`PostalCode` = '77377' ,`RoomCount` = '13' ,`ListPrice` = '1950000.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Country' ,`StreetNumber` = '16011' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2002' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Seller bought as distressed property and has remediated, refurbished, remodeled and cleaned it up. Hauled off four 40-cubic yards containers of trash! Mold remediation including removing all insulation in house attic except addition, treated & replaced with new insulation, remediated & replaced lower cabinet shelves and doors in the kitchen.. Replaced wood floors, installed new carpet, added crown molding, trimmed out windows, repaired damaged sheetrock, painted complete interior and exterior of both the main house and guest house. Corrected drainage across front of house & updated landscaping, restored garage spaces. All 3 non-working AC units have been serviced and non-working units replaced or repaired. Replaced roofs on both house and guest house. Had electrical checked and removed unused or dangling wires. Added some new fence and painted and restored other sections. Continuing to work on improving the land and homes. Worked with the Harris County to have Ag Exemption re-instated.' ,`Acres` = '8.074' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Reports Available,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'PT TR 4 (HOMESITE) PINE COUNTRY OF TOMBALL SEC 3 2ND R/P' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Water View' ,`LotSize` = '351720' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'ROSEHILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman,Ranch,Traditional' ,`Subdivision` = 'Pine Country of Tomball' ,`TaxAmount` = '4500' ,`TaxRate` = '2.3767' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928757' WHERE `Matrix_Unique_ID` = '212784857' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T20:26:39.400' ,`MLSNumber` = '44693174' ,`ListAgentFullName` = 'Karen Woodworth' ,`ListOfficeName` = 'CB&A, Realtors-Katy' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.834887' ,`Longitude` = '-95.748251' ,`PhotoCount` = '45' ,`PostalCode` = '77449' ,`RoomCount` = '6' ,`ListPrice` = '297500.00' ,`Status` = 'Active' ,`StreetName` = 'Mt Everest' ,`StreetNumber` = '4142' ,`StreetSuffix` = 'Way' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2060' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this beautifully maintained Ryland gem with 3 bedrooms, 2 baths in Mason Lakes. This floorplan is rarely duplicated and when you see it, you will fall in love. Designed with entertaining in mind, this beauty features a Family room with gas log fireplace; Open Concept Kitchen with granite countertops, island and breakfast bar along with 42\" tall cabinets and a large Breakfast Area with box window seat. French doors open to the study with tile throughout the entryway, kitchen, breakfast area, family room and bathrooms. The spacious primary bedroom is secluded and the primary bath features double sinks, separate shower and jetted tub as well as taller cabinetry. Recent microwave, fencing and secondary bedroom carpeting, Ceiling fans in all bedrooms, office, family room as well as back patio. Zoned to award-winning Katy ISD schools. Conveniently located to shopping, schools and commuter routes including Grand Parkway/99 & I-10. Come make this house your new home.' ,`Acres` = '0.1388' ,`Area` = '25' ,`BuilderName` = 'Ryland' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 5 MASON LAKES SEC 1 AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6048' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'GOLBOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'MCDONALD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mason Lakes Sec 01 Amd' ,`TaxAmount` = '6361' ,`TaxRate` = '2.7857' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928757' WHERE `Matrix_Unique_ID` = '212787391' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T21:45:47.397' ,`MLSNumber` = '51685536' ,`ListAgentFullName` = 'Jennifer Cannon' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.448282' ,`Longitude` = '-95.098405' ,`PhotoCount` = '29' ,`PostalCode` = '77539' ,`RoomCount` = '4' ,`ListPrice` = '289900.00' ,`Status` = 'Active' ,`StreetName` = 'Fox Springs' ,`StreetNumber` = '217' ,`StreetSuffix` = 'Court' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2197' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '4 Bedroom Move-In Ready 2 STORY with game-room in Bay Colony! CORNER LOT AND NEVER FLOODED! Large primary located on 1st Floor with Formal Dining, Breakfast and Living. Upgraded kitchen appliances with a fireplace to keep you warm this winter. 3 bedrooms upstairs with large closets, game-room and a full bath. Come see this property and its many upgraded features! New HVAC in 2016 with brand new condenser coil this past month. New AC evaporator coil in 2020. Solar Screens on all windows. Extra wide driveway with concrete sidewalk all the way to the backyard. Huge back patio slab that runs beyond the entire length of the home. Double gates for for vehicle access to the backyard. Work bench and shelves built into the garage. Home is wired for 30 amp generator plug and breaker for portable generator backup. Come by to see all this lovely home has to offer!' ,`Acres` = '0.1369' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BAY COLONY POINTE SEC 2 (2000), ABST 19, BLOCK 3, LOT 10, AC' ,`LotDesciption` = 'Corner' ,`LotSize` = '5962' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '296' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'CALDER ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bay Colony Pointe West' ,`TaxAmount` = '6473' ,`TaxRate` = '2.8897' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928757' WHERE `Matrix_Unique_ID` = '212824743' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T20:03:48.440' ,`MLSNumber` = '42742235' ,`ListAgentFullName` = 'Juan Marin' ,`ListOfficeName` = 'Executive Texas Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.853605' ,`Longitude` = '-95.200415' ,`PhotoCount` = '30' ,`PostalCode` = '77044' ,`RoomCount` = '6' ,`ListPrice` = '309900.00' ,`Status` = 'Active' ,`StreetName` = 'Hunters Field' ,`StreetNumber` = '12911' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2413' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated three bedroom, two and a half bathroom house with office on the main floor! High ceilings throughout the entire first floor. Spacious kitchen has been updated with new Calacatta quartz countertops, new paint, and new stainless appliances. Primary bedroom is oversized with an updated, luxurious primary bathroom. All new carpet and paint throughout the house. NEW HVAC, NEW ROOF, and energy efficient Nest thermostats in both up and downstairs. Come see this gorgeous home. It wont last long!' ,`Acres` = '0.1798' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 2 STONEFIELD TERRACE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7833' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '480' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'MONAHAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'C.E. KING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stonefield Terrace Sec 01' ,`TaxAmount` = '6593' ,`TaxRate` = '2.9993' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928757' WHERE `Matrix_Unique_ID` = '212847503' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T20:41:38.730' ,`MLSNumber` = '15442581' ,`ListAgentFullName` = 'Joann Logsdon' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.079120' ,`Longitude` = '-95.771935' ,`PhotoCount` = '13' ,`PostalCode` = '77447' ,`RoomCount` = '4' ,`ListPrice` = '274000.00' ,`Status` = 'Active' ,`StreetName` = 'Solstice Point' ,`StreetNumber` = '20822' ,`StreetSuffix` = 'Drive' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1414' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Hurry! You won’t want to miss it! New home built in 2021 on a large corner lot. This home is full of natural light. Long beautiful hallway leading to a light and bright open concept living space. This home is a blank canvas waiting for new owners to make their own. The kitchen offers stainless still appliances and granite counter tops. Fairly large dining room and living rooms. Large backyard and another blank canvas for owner to make their own.' ,`Acres` = '0.213' ,`Area` = '35' ,`BuilderName` = 'LGI' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 35 BLK 11 BAUER LANDING SEC 7' ,`LotDesciption` = 'Corner' ,`LotSize` = '9277' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'EVELYN TURLINGTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Bauer Landing' ,`TaxAmount` = '677' ,`TaxRate` = '2.8556' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928757' WHERE `Matrix_Unique_ID` = '212931476' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T21:37:41.120' ,`MLSNumber` = '72750103' ,`ListAgentFullName` = 'Maria Espitia' ,`ListOfficeName` = 'Ross & Marshall Realty' ,`SellingAgentFullName` = 'Joseph Chen' ,`SellingOfficeName` = 'Casablanca Properties' ,`Latitude` = '29.994044' ,`Longitude` = '-95.730700' ,`PhotoCount` = '25' ,`PostalCode` = '77433' ,`RoomCount` = '9' ,`ListPrice` = '346000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Vinegrove Falls' ,`StreetNumber` = '14930' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2636' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful 5-bedroom home in Cypress has everything you need under one roof! Built in 2014 this home sits on a rare, oversized, cul-de-sac lot of 8,643 sq ft. The huge covered back patio with ceiling fans is the perfect spot to enjoy family gatherings. This lot can easily fit a pool and still have plenty of green space to enjoy! As you walk into a large living area, you\'ll notice the kitchen with an adjoining nook and dining room. There\'s one bedroom down that can also be used as an office with a half bath. Upstairs you will find the generous sized primary bedroom with an ensuite bathroom and large walk-in closet. 3 additional bedrooms, another full bathroom, game room and large utility room are also located upstairs. \r\nLOCATION, LOCATION, LOCATION!!! Villages of Cypress Lakes offers great amenities such as a community pool, parks, trail, kids splash pad and playground. Houston Premium Outlets, Costco, medical facilities, grocery stores and much more are only minutes away!' ,`Acres` = '0.1984' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 3 VILLAGES OF CYPRESS LAKES SEC 28' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8643' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '614' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'AULT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Villages/Cypress Lakes Sec 28' ,`TaxAmount` = '7893' ,`TaxRate` = '3.061' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928758' WHERE `Matrix_Unique_ID` = '212979159' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T20:56:24.897' ,`MLSNumber` = '60396663' ,`ListAgentFullName` = 'Fie Fie Sutandi' ,`ListOfficeName` = 'CENTURY 21 Western Realty' ,`SellingAgentFullName` = 'Ashley LaGrone' ,`SellingOfficeName` = 'HomeSmart' ,`Latitude` = '29.835844' ,`Longitude` = '-95.675555' ,`PhotoCount` = '37' ,`PostalCode` = '77084' ,`RoomCount` = '11' ,`ListPrice` = '385700.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Amber Lake' ,`StreetNumber` = '4318' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2770' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well maintained and move in ready home in Deerfield Village. This 4 bedrooms home features a formal dining, a study, kitchen with granite counter tops, stainless steel appliances and more. Refrigerator is included. Den/Family room is very bright with lots of windows, fireplace and view to swimming pool. Primary bedroom is on first floor and has it\'s own primary bathroom. The other 3 bedrooms are on second floor. Game room is very spacious with window seats/storage. Recently installed luxury vinyl planks and brand new carpets (Sept 2022). No back neighbor, big backyard with swimming pool and detached garage with long driveway. NEVER FLOODED per sellers. Come and schedule your showing today!' ,`Acres` = '0.2039' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 6 DEERFIELD VILLAGE 8 AMENDED' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8880' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`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 Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Deerfield Village' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1665928758' WHERE `Matrix_Unique_ID` = '212983791' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T21:29:23.250' ,`MLSNumber` = '16117564' ,`ListAgentFullName` = 'Tara Anderson' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = 'Angela Baldon' ,`SellingOfficeName` = 'RORECO' ,`Latitude` = '29.620563' ,`Longitude` = '-95.598796' ,`PhotoCount` = '27' ,`PostalCode` = '77478' ,`RoomCount` = '8' ,`ListPrice` = '345000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Country Club' ,`StreetNumber` = '2513' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1927' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1731' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SUGAR CREEK SEC 27, LOT 4' ,`LotDesciption` = 'In Golf Course Community,Patio Lot' ,`LotSize` = '7540' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'DULLES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sugar Creek Sec 27' ,`TaxAmount` = '4932' ,`TaxRate` = '2.0094' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928758' WHERE `Matrix_Unique_ID` = '213084549' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T21:14:24.780' ,`MLSNumber` = '34924392' ,`ListAgentFullName` = 'Chris Glapa' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = 'Iqbal Hasnani' ,`SellingOfficeName` = 'Keller Williams Metropolitan' ,`Latitude` = '29.649893' ,`Longitude` = '-95.728590' ,`PhotoCount` = '50' ,`PostalCode` = '77406' ,`RoomCount` = '10' ,`ListPrice` = '549900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Bivins Lake' ,`StreetNumber` = '3910' ,`StreetSuffix` = 'Circle' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3765' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nestled on a oversized lot in established Waterside Estates, this stunning waterfront home offers luxurious finishes & contemporary living! Remarkable curb appeal boasts mature Oaks, professional landscaping, & porte-cochere! Grand entry w/soaring ceilings, elegant pillars w/intricate molding, wrought iron staircase, & endless natural light is flanked by the formal dining & den w/gorgeous hardwood floors! Family room w/elevated ceilings, custom molding, & oversized windows w/open-concept floorplan ideal for entertaining! Gourmet Chef\'s tiered island kitchen w/granite, painted cabinetry, custom lighting, stainless steel appliances w/gas cooktop & Jenn-Air double ovens, & large pantry! Master retreat w/wall of windows w/scenic views, & en suite bath w/granite vanity w/dual sinks, separate walk-in shower & jetted tub, & HUGE closet! Gameroom offers adjacent flex room w/direct balcony access! Pool-sized backyard w/covered patio & access to walking trails on the lake! Endless storage space!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WATERSIDE ESTATES SEC 12, BLOCK 2, LOT 8' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '11183' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '528' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'OAKLAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'BOWIE MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Waterside Estates Sec 12' ,`TaxAmount` = '8004' ,`TaxRate` = '2.2929' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928758' WHERE `Matrix_Unique_ID` = '213128530' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T21:07:01.383' ,`MLSNumber` = '24233394' ,`ListAgentFullName` = 'Heather Groom' ,`ListOfficeName` = 'Doug Erdy Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.096038' ,`Longitude` = '-95.259520' ,`PhotoCount` = '30' ,`PostalCode` = '77365' ,`RoomCount` = '10' ,`ListPrice` = '464999.00' ,`Status` = 'Active' ,`StreetName` = 'Enloe Rd' ,`StreetNumber` = '24274' ,`StreetSuffix` = 'Drive' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1620' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for solitude? Looking for a place to call home? Look no further! This 3-bedroom 2 bath home sits on 4.372 acres 35 mins from Downtown Houston. Enjoy living on acreage but the convenience of the city! Not a part of this home goes unnoticed, start with the custom-built iron door, new wood flooring, updated bathrooms, modern fixtures, a flex room to be used as your office or craft room, or let me not forget the large building in the back yard! Come enjoy a cup of coffee on the front porch, bring your animals, run your business! The possibilities are endless!' ,`Acres` = '4.372' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0393-MCFADDENSARAH,TRACT 2A-9,ACRES4.372' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '190444' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'BENS BRANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'SARAH MCFADDEN' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665928758' WHERE `Matrix_Unique_ID` = '213199776' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T20:33:11.813' ,`MLSNumber` = '66449824' ,`ListAgentFullName` = 'Joy Padvorac' ,`ListOfficeName` = 'Village Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.215605' ,`Longitude` = '-95.663823' ,`PhotoCount` = '50' ,`PostalCode` = '77354' ,`RoomCount` = '12' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Thousand Oaks' ,`StreetNumber` = '33318' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3009' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this stunning home nestled on a MASSIVE 1.3 acre lot featuring 4 spacious bedrooms, 3 FULL bathrooms & an attached oversized 3-car garage. The open floorplan of this home is very functional & convenient. Luxe flooring, designer paint & tall ceilings throughout. Enjoy your chef’s kitchen w/ sprawling counter space, ample amounts of cabinet storage & walk-through access to the formal dining room. The spacious living room boasts impressive two-story ceilings, bright natural light & a stunning stone-cast fireplace. Downstairs you’ll find the primary luxury suite with a tray ceiling, bright windows & a spa-inspired ensuite bathroom. Also located downstairs is a separate guest room w/ secondary bathroom. Upstairs enjoy your oversized game room and two additional guest rooms & bathroom. The sprawling backyard is an OUTDOOR PARADISE that has been well-maintained with lush landscaping & over a dozen fruit-bearing trees. Zoned to Magnolia ISD, w/ easy access to 249, I45 & 99.' ,`Acres` = '1.274' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S924300 - THOUSAND OAKS 01, BLOCK 3, LOT 2, ACRES 1.274' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '55495' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Thousand Oaks 01' ,`TaxAmount` = '7209' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Aerobic,Septic Tank' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928758' WHERE `Matrix_Unique_ID` = '213228165' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T20:01:22.427' ,`MLSNumber` = '68847362' ,`ListAgentFullName` = 'Durran Starks' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.945397' ,`Longitude` = '-95.241683' ,`PhotoCount` = '29' ,`PostalCode` = '77396' ,`RoomCount` = '4' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Clanton Pines' ,`StreetNumber` = '9826' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2408' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THIS IS THE ONE! Simply AMAZING!! located in the gated community of Canyon Gate at Park Lake. This expansive 1 story home comes with, 42” Upper Cabinets, large kitchen island, DOUBLE OVENS, floor to ceiling windows, tile flooring, and equipped for surround sound. The space in the primary bedroom suite is MASSIVE! Equipped with a walk-in closet, two vanities, garden tub with sitting bench and stand-up shower. The secondary and third bedrooms are both very nice size. Long covered patio with good size backyard! Amenities include community pool, splash pad, basketball courts, playground, and walking trails around the community lake. Conveniently located near Beltway 8, 59, IAH. Theaters, dining, and lots of shopping nearby! You don\'t want to miss this! Schedule your private tour TODAY!\n' ,`Acres` = '0.1378' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'HOA First Right of Refusal,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Humble Area East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 38 BLK 5 CANYON GATE AT PARK LAKES SEC 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6003' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'PARK LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'HUMBLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Gate/Pk Lakes Sec 16' ,`TaxAmount` = '7525' ,`TaxRate` = '2.9873' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928759' WHERE `Matrix_Unique_ID` = '213234009' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T20:19:58.407' ,`MLSNumber` = '21137956' ,`ListAgentFullName` = 'Bianca Henderson' ,`ListOfficeName` = 'Realty Preferred City Centre' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.963028' ,`Longitude` = '-95.491299' ,`PhotoCount` = '28' ,`PostalCode` = '77066' ,`RoomCount` = '5' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Mint' ,`StreetNumber` = '12626' ,`StreetSuffix` = 'Field' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home!! This is a charming 4 bed 3 1/2 bath 2-story home in a gated community with an open floor plan and 2 car attached garage. The living area is abundantly spacious and the home comes with a large media home on the second floor of the home. Appliances are stainless steel and kitchen counter top are granite. There is a welcoming patio in the front of the home with a spacious backyard. Home is loactaed in Klein ISD.' ,`Acres` = '0.0971' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 5 KLEIN ARBOR' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4230' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KLENK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'WUNDERLICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Klein Arbor' ,`TaxAmount` = '6635' ,`TaxRate` = '2.9105' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928759' WHERE `Matrix_Unique_ID` = '213323847' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T20:53:25.870' ,`MLSNumber` = '47897411' ,`ListAgentFullName` = 'Valentina Lares' ,`ListOfficeName` = 'Energy Realty' ,`SellingAgentFullName` = 'Martine Nerrant' ,`SellingOfficeName` = 'Energy Realty' ,`Latitude` = '29.761179' ,`Longitude` = '-95.485798' ,`PhotoCount` = '39' ,`PostalCode` = '77057' ,`RoomCount` = '8' ,`ListPrice` = '2177000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Crab Orchard' ,`StreetNumber` = '6023' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4454' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This masterfully REMODELED home is situated on a quiet street in the heart of TANGLEWOOD.\r\nRenovated from top to bottom by MCP HOMES–entering through the dramatic OVERSIZED\r\nSTEEL FRAME and glass doors will be sure to impress.Interior features include 21ft\r\nCEILINGS, QUARTZ countertops, contemporary French Oak HARDWOOD floors, new electrical,\r\nLED LIGHTS throughout, PEX plumbing,new HVAC systems,DOUBLE-PANE windows.The\r\nChef\'s kitchen boasts a 48in-7 BURNER and Double Oven Gas Range,48in sink,WINE\r\nCELLAR,butler\'s pantry,and ISLAND with plenty of room for seating. Home offers 4\r\nbedrooms, 5.5 bathrooms, and 2 ADDITIONAL FLEX ROOM spaces, convertible into home office,\r\ngym or 5 th bedroom.Updated exterior features include a METAL ROOF,WHITE GERMAN\r\nSCHMEAR painted bricks, artificial Turf, new sprinklers and drainage, TRAVERTINE pool decking,\r\nreplastering of pool, coping and all new pool equipment, GENERATOR (Generac Protector 36KW\r\nStandby Generator), electric gate and new driveway.' ,`Acres` = '0.1857' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tanglewood Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 64 TANGLEWOOD SEC 18' ,`LotDesciption` = 'Cleared' ,`LotSize` = '8088' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Tanglewood Sec 18' ,`TaxAmount` = '27651' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928759' WHERE `Matrix_Unique_ID` = '213337953' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T20:44:28.177' ,`MLSNumber` = '27299263' ,`ListAgentFullName` = 'Patrick Ma' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.479694' ,`Longitude` = '-95.573654' ,`PhotoCount` = '24' ,`PostalCode` = '77318' ,`RoomCount` = '5' ,`ListPrice` = '110000.00' ,`Status` = 'Active' ,`StreetName` = 'Hill' ,`StreetNumber` = '14378' ,`StreetSuffix` = 'Drive' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '960' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Why rent when you can own your own home. Buy on the lake before prices go up further. There is hardly ever any property for sale in this neighborhood. Handyman Special 3 bedroom 2 baths mobile home on a nice size lot. Steps from Lake Conroe and the marina. Needs carpet, paint, and some minor repairs perfect for someone handy. Home was just levelled and ready for you to make it your own. Very quiet lake side community with lots of new build homes and new communities being build nearby.' ,`Acres` = '0.1928' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S622000 - JOHNSON BLUFF, BLOCK 1, LOT 44-B, 45, SERIAL # UNK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'PARMLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Johnson Bluff' ,`TaxAmount` = '900' ,`TaxRate` = '1.8448' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928759' WHERE `Matrix_Unique_ID` = '213353978' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T21:51:28.283' ,`MLSNumber` = '88244474' ,`ListAgentFullName` = 'Carlos Guerra' ,`ListOfficeName` = 'Exit Realty 360' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.641026' ,`Longitude` = '-95.548000' ,`PhotoCount` = '22' ,`PostalCode` = '77031' ,`RoomCount` = '7' ,`ListPrice` = '260000.00' ,`Status` = 'Active' ,`StreetName` = 'AIRPORT' ,`StreetNumber` = '9579' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1853' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GREAT LOCATION ONE OF THE HEART PART OF THE SOUTHWEST AREA BEAUTIFULL INSIDE LIGHT HOUSE EASY ACCESS,20 MINUTES TO DOWNTOWN TO FREEWAY 12 MINUTES TO GALLERIA AND EASY ACCESS TO SUGARLAND AND AREAS AROUND A LOT SPACE TO ENTERTEIMENT FAMILY AND FRIENDS HAS NICE BACK YRAD READY TO BUILD A POOL ,LARGE DRIVE WAY TO HOLD PEOPLE OVER AND HIGH CATEDRAL CEILING AT LIVING ROOM AND MASTER BEDROOM ,NEW PORCELAIN FLOORS,LAMINATE FLOORS,QUARTZ TOP COUNTER KITCHEN ,NEW A/C DUCTS BEEN REPLACED COME TO SEE!!!!' ,`Acres` = '0.2182' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Stove' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 28 GLENSHIRE SEC 9' ,`LotDesciption` = 'Greenbelt' ,`LotSize` = '9504' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '516' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BELL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'WELCH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Glenshire' ,`TaxAmount` = '3775' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928759' WHERE `Matrix_Unique_ID` = '213354234' --> 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','213373793','1665928760','213373793','2022-10-15T21:10:53.820','40448233','Jamie McMartin','Compass RE Texas, LLCKaty','','','29.822365','-95.068490','27','77562','8','235000.00','Active','Brompton','519','Lane','Highlands','2','1','3','2328','Single-Family','519 Brompton sits on a large corner lot in section 2 of Highlands Woods Neighborhood. This beautiful 2-story home features 3 bedrooms, 2.5 bathrooms, and an oversized 30’x24’ detached 2-car garage. Interior features include a large den area complete with wet bar, open kitchen/living areas, wood burning fireplace, large upstairs game room/study, covered wooden deck, and private boat ramp access to the San Jacinto river. This cozy family neighborhood is situated in the heart of Highlands (Low Taxes!), near the Highlands community center, Stratford library and park, and community basketball and tennis courts. Conveniently located with easy access to HWY-90, I-10, TX-146 via SPUR-330 and SH-225 via the Lynchburg Ferry, you’ll have plenty of options for your daily commute! Schedule your showing to see this exceptional home today!','0.1716','2','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Wood Burning Fireplace','1','Baytown/Harris County','Central Electric','1','LT 5 BLK 2 HIGHLAND WOODS SEC 2','Corner','7475','Appraisal District','','195','0','','2','Convection Oven,Freestanding Oven','0','','','Gas Range','','Composition','23 - Goose Creek Consolidated','HOPPER/HIGHLANDS ELEMENTARY SCHOOL','GOOSE CREEK MEMORIAL','HIGHLANDS JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','2','Ranch','Highlands Woods 2','5140','2.575','Public Sewer,Public Water,Water District','1985','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T20:32:23.660' ,`MLSNumber` = '15077263' ,`ListAgentFullName` = 'Carmen Valderrama' ,`ListOfficeName` = 'CB&A, Realtors-Katy' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.820556' ,`Longitude` = '-95.812041' ,`PhotoCount` = '31' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Rachel' ,`StreetNumber` = '3261' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1648' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MULTIPLE OFFERS: Please submit Highest & Best by 7pm Sun, 10/16/22. Thank you. WELCOME HOME to this charming 1 story on a cul-de-sac street in established Heritage Park West. Ready for a new homeowner, it is beautifully located in desirable Katy ISD and in the heart of Katy. Subd is tucked away yet very close to everything: shopping, dining, entertainment, parks, & more. No carpet: Title and vinyl plank flooring throughout. Kitchen opens to the family room, which is perfect for gatherings. Kitchen also features lovely cabinets and a ceiling hanging rack for pots and pans. This split plan home has 2 secondary bedrooms separate from the primary bedroom. Dining Room is very versatile and can be used as a study, play area, craft area, or flex area, offering lots of natural light. Fresh paint. Ceiling fans. 5-year-old Roof (have docs) and A/C is from 2019. Gas log granite surround fireplace with a mantel is perfect for your décor. NO MUD and Low tax rate in 77493 zip code. Don’t miss out!' ,`Acres` = '0.1113' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 91 HERITAGE PARK WEST SEC 1' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '4850' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'HUTSELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Heritage Park West Sec 01' ,`TaxAmount` = '4417' ,`TaxRate` = '2.3852' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928760' WHERE `Matrix_Unique_ID` = '213394747' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T21:55:11.860' ,`MLSNumber` = '42158285' ,`ListAgentFullName` = 'Bryan Wood' ,`ListOfficeName` = 'Keller Williams Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.826971' ,`Longitude` = '-95.108642' ,`PhotoCount` = '30' ,`PostalCode` = '77360' ,`RoomCount` = '9' ,`ListPrice` = '199900.00' ,`Status` = 'Active' ,`StreetName` = 'Long' ,`StreetNumber` = '166' ,`StreetSuffix` = 'Drive' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1115' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful new build home in Onalaska TX with low maintenance in mind. Although it has a decent size back yard the over yard size is smaller with less to mow. Cement board siding, tile floors throughout this home. Quartz countertops in the kitchen and bathrooms. For lower utility costs the home\'s environmental footprint was kept small. Yet everything you need is in this home. Open concept living-dining-kitchen. Good size primary bedroom with ensuite bath and walk in closet. Well appointed bathrooms. Kitchen features stainless steel appliances and quartz countertops. In-House Laundry. Nest thermostat. Well crafted painted cabinets. Home features a ultraviolet light on the AC return to kill unwanted germs in the air. 50 amp outside plug for a generator into the home. Garage Door has frosted windows to let in light into your finished garage. Yard will be full fenced with a privacy fence. Less than 5 minutes from all the Onalaska Schools.' ,`Acres` = '0.115' ,`Area` = '44' ,`BuilderName` = 'Hird Zavala Develop.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ONALASKA WOODS Replat Lot 45 A' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Onalaska Woods' ,`TaxAmount` = '356' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665928760' WHERE `Matrix_Unique_ID` = '213402853' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T21:37:47.920' ,`MLSNumber` = '66681503' ,`ListAgentFullName` = 'Susy Stapp' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.474634' ,`Longitude` = '-95.132498' ,`PhotoCount` = '42' ,`PostalCode` = '77573' ,`RoomCount` = '11' ,`ListPrice` = '615000.00' ,`Status` = 'Active' ,`StreetName` = 'Ashley Falls' ,`StreetNumber` = '2316' ,`StreetSuffix` = 'Lane' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3503' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this stunning 1 story home with 4 bedrooms & 3 baths. Rich hickory hardwood floors, crisp white plantation shutters and decorative stacked stone are just a few of the accessories that adorn this beautiful home. Your family will love the media room with an elevated floor and high end Onkyo surround sound throughout the media room, living area and outdoor area. Family time will be a blast with outdoor cooking while you enjoy the relaxing pool and spa. Fire bowls and table will add ambience to your evening rendezvous’. The primary bedroom is very spacious and the custom barn door is stunning. This home has too many upgrades to list, so come by and see for yourself!' ,`Acres` = '0.2459' ,`Area` = '33' ,`BuilderName` = 'K Hovnanian' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MAGNOLIA CREEK SEC 11 PH II (2016) ABST 654, BLOCK 3, LOT 6,' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '10710' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '772' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'GILMORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'VICTORYLAKES INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Magnolia Crk Sec 11 Ph 2' ,`TaxAmount` = '11272' ,`TaxRate` = '2.2667' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928760' WHERE `Matrix_Unique_ID` = '213428709' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T20:06:57.933' ,`MLSNumber` = '34848559' ,`ListAgentFullName` = 'Penny Wilson' ,`ListOfficeName` = 'The Wilson Agency II' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.602629' ,`Longitude` = '-95.516565' ,`PhotoCount` = '6' ,`PostalCode` = '77489' ,`RoomCount` = '7' ,`ListPrice` = '198000.00' ,`Status` = 'Active' ,`StreetName` = 'Summers' ,`StreetNumber` = '907' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1812' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3 Bedroom 2 bath 1800 sq ft 2 car garage with large back yard' ,`Acres` = '0.2257' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'HUNTERS GLEN SEC 1, BLOCK 1, LOT 28, (SEC 1-A)' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9831' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HUNTERS GLEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MARSHALL HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'MISSOURI CITY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hunters Glen Sec 1' ,`TaxAmount` = '4681' ,`TaxRate` = '2.693' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928760' WHERE `Matrix_Unique_ID` = '213435681' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T21:01:25.270' ,`MLSNumber` = '36276578' ,`ListAgentFullName` = 'Tilda Young' ,`ListOfficeName` = 'Diamond Crest Realty, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.298692' ,`Longitude` = '-97.150473' ,`PhotoCount` = '7' ,`PostalCode` = '77995' ,`RoomCount` = '2' ,`ListPrice` = '57000.00' ,`Status` = 'Active' ,`StreetName` = 'Mathew' ,`StreetNumber` = '317' ,`StreetSuffix` = 'Street' ,`City` = 'Yoakum' ,`BathsFull` = '0' ,`BathsHalf` = '0' ,`BedsTotal` = '0' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'House is a Teardown!! No Entry allowed. Two Lotsl. One Lot has the house, one is Vacant. Lot and house are fully fenced.\r\nLot 10,11' ,`Acres` = '0.2663' ,`Area` = '68' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'PARK HEIGHTS, BLK 1121 (10), LOT 10-11, UNDIVIDED INTEREST 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '177 - Yoakum' ,`SchoolElementary` = '' ,`SchoolHigh` = 'YOAKUM HIGH SCHOOL' ,`SchoolMiddle` = 'YOAKUM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Supra Keybox' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Park Heights' ,`TaxAmount` = '391' ,`TaxRate` = '2.3117' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1665928761' WHERE `Matrix_Unique_ID` = '213464465' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T20:20:08.517' ,`MLSNumber` = '50088009' ,`ListAgentFullName` = 'Steve Aziegbe' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.589368' ,`Longitude` = '-95.095507' ,`PhotoCount` = '18' ,`PostalCode` = '77058' ,`RoomCount` = '4' ,`ListPrice` = '333900.00' ,`Status` = 'Active' ,`StreetName` = 'Rutgers Park' ,`StreetNumber` = '12427' ,`StreetSuffix` = 'Court' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2086' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely, charming residence with a fantastic floor plan for a place to call home. Located in highly sought after University Park- a quiet neighborhood centrally located to shopping, medical and dining. Operated as a low maintenance property that allows you to enjoy fireside dinners. Master bedroom is positioned away from the other bedrooms for extra privacy. In the master, enjoy the spaciousness and comfort with 2 large closets and separate tub/shower. Newly installed water softener to provide best quality water for your everyday needs. Come live, play and be a part of a great school district and community. \r\n\r\nConsider this as a key to your next home: low-maintenance, close proximity, fabulous schools and an active community makes this an ideal place to call home. \r\n\r\nUbicado en el popular barrio Parque Universitario. Cerca de tiendas, médicos, restaurantes y buenas escuelas. La suite principal tiene 2 armarios. Se instala un ablandador de agua nuevo.' ,`Acres` = '0.116' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 1 UNIVERSITY PARK PATIO HOMES 4' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '5053' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1325' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BROOKWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'University Park Patio Homes 04' ,`TaxAmount` = '6164' ,`TaxRate` = '2.5419' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928761' WHERE `Matrix_Unique_ID` = '213467134' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T20:06:16.920' ,`MLSNumber` = '4400433' ,`ListAgentFullName` = 'Alisha Melton' ,`ListOfficeName` = 'Allegiance Realty Assoc., LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.665532' ,`Longitude` = '-95.011166' ,`PhotoCount` = '27' ,`PostalCode` = '77571' ,`RoomCount` = '4' ,`ListPrice` = '175000.00' ,`Status` = 'Active' ,`StreetName` = 'Brownell' ,`StreetNumber` = '314' ,`StreetSuffix` = 'Street' ,`City` = 'La Porte' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1119' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Adorable home in the heart of La Porte. This well maintained charmer is move in ready. The cozy built in bench in the dining area and added island maximize the space in your kitchen. As you enter the backyard you walk out on to the wood deck that enters into your fully fenced back yard. There is plenty of space for back yard BBQ\'s or play toys for the kids. Spacious bedrooms are a great find in this home. A/C replaced 2017. Roof, Hot Water Heater, Windows, Electrical Panel and Blinds all replaced in 2016. Shed in the backyard was purchased in 2018 and stays with the home. Washer and Dryer to stay as well. Schedule your showing today. This one won\'t last long!' ,`Acres` = '0.1435' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 21 & 22 BLK 65 BAY FRONT TO LA PORTE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'LA PORTE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bay Front La Porte' ,`TaxAmount` = '3297' ,`TaxRate` = '2.7208' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928761' WHERE `Matrix_Unique_ID` = '213480533' --> 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','213498853','1665928761','213498853','2022-10-15T20:35:53.693','34650263','Michelle Eads','Redfin Corporation','','','30.200762','-95.490341','49','77382','4','630000.00','Active','Silver Crescent','83','Circle','The Woodlands','3','0','4','2762','Single-Family','Stunning Village builders home w/ amazing outdoor entertaining space on one of the largest lots & features NO back neighbors, desirable schools, & quick access to multiple parks, private schools, & I45. This homes curb appeal begins w/ lush landscaping, large shade trees, & an oversize detach 3-car garage w/ a finished room perfect for a workout space or in-law suite. Inside, find an open-concept layout that offers wood flooring, crown molding, decorative lighting, & TONS of natural light. A dedicated home office w/ French doors & formal dining area offer NEW Acacia wood floors & leads into the spacious living room w/ a fireplace, tile flooring, & great backyard views. Adjacent, find a completely remodeled chef\'s kitchen that boasts granite counters, high-end SS appliances, ample cabinet storage, an island, & a cozy breakfast nook. The backyard will leave your guest speechless from the refinished pool w/new heaters, large covered pavilion w/ TV, grill, pizza oven, & ample grass space!','0.3752','15','Village Builders','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','The Woodlands','Central Gas','0','WDLNDS VIL ALDEN BR 01, BLOCK 2, LOT 31','Greenbelt,Subdivision Lot','16344','Appraisal District','','','0','','2','Gas Oven','1','Gunite,In Ground,Salt Water','','Gas Cooktop','','Composition','11 - Conroe','DAVID ELEMENTARY SCHOOL','THE WOODLANDS COLLEGE PARK HIGH SCHOOL','KNOX JUNIOR HIGH SCHOOL','Supra Keybox','Appraisal District','1','Traditional','Wdlnds Village Alden Br','8181','2.1269','Water District','1994','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T20:43:42.080' ,`MLSNumber` = '14815594' ,`ListAgentFullName` = 'Yavon Shaw-Cooper' ,`ListOfficeName` = 'RE/MAX Grand' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.974026' ,`Longitude` = '-95.539124' ,`PhotoCount` = '50' ,`PostalCode` = '77069' ,`RoomCount` = '10' ,`ListPrice` = '439900.00' ,`Status` = 'Active' ,`StreetName` = 'Centre Grove' ,`StreetNumber` = '7019' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2511' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! Fully remodeled 4 bdrm/3 full bath home-/Vintage Park is only 1.3 miles away. Light & Bright! High ceilings with flowing floorplan. New appliances. Smart thermostat keepING bills low. Built-in dishwasher, refrigerator and wine rack. Undermount lighting;Custom island(cooktop professionally re-positioned); white granite countertops;Wood-like tile throughout; Natural stone fireplace, floor to ceiling; 6 inch woodwork;Neutral colors; Beadboard ceiling; All new door handles. Grill & fridge included. NO FLOODING. Almost everything is new in this home. Light fixtures, toilets, sinks, primary shower used once, new designer soaker tub (no jets). Attic is completely floored over the garage. These homeowners did not miss a beat when they re-designed this home. It is like walking into a brand new home but with a mature tree lined neighborhood. Culdesac lot so quiet you can hear a pin drop. Circle driveway gives lots of parking. Come to the open house!!' ,`Acres` = '0.2204' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 2 CHAMPIONS CENTRE ESTS 1 AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1225' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'YEAGER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Champions Centre Estates' ,`TaxAmount` = '6195' ,`TaxRate` = '2.4106' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928761' WHERE `Matrix_Unique_ID` = '213528478' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T20:15:27.267' ,`MLSNumber` = '75487623' ,`ListAgentFullName` = 'Kristin McAlister' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.887471' ,`Longitude` = '-95.667444' ,`PhotoCount` = '32' ,`PostalCode` = '77095' ,`RoomCount` = '3' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Dogwood Falls' ,`StreetNumber` = '7318' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1976' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home will not disappoint. Nestled in a quiet cul-de-sac, this home has it all. The open concept kitchen and ample living room with soaring ceilings are perfect for entertaining. In the back yard, you will find plenty of green space and is complete with a sizable covered patio ( 2021), pool and spa (built 2016). There is a dedicated office/ playroom and a formal dining room. The kitchen features SS appliances, recessed lighting and quartz countertops. The garage has been finished and is currently used as a Gameroom. It has an A/C and heat- but the door is still functional- s it is your choice how you use it! The interior was painted 2020, ceilings were also scraped and painted then too. NO CARPET!! Roof replaced 2016. Breaker box replaced 2017. Never flooded. ' ,`Acres` = '0.1956' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 44 BLK 1 COPPERFIELD SOUTHCREEK VILLAGE SEC 8' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8520' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '695' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'LOWERY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LANGHAM CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'ARAGON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Copperfield Southcreek Village' ,`TaxAmount` = '5403' ,`TaxRate` = '2.537' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928761' WHERE `Matrix_Unique_ID` = '213569096' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T20:47:30.057' ,`MLSNumber` = '58077316' ,`ListAgentFullName` = 'Claudia Buckalew' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.658596' ,`Longitude` = '-95.728840' ,`PhotoCount` = '47' ,`PostalCode` = '77406' ,`RoomCount` = '9' ,`ListPrice` = '395000.00' ,`Status` = 'Active' ,`StreetName` = 'Lake Pinkston' ,`StreetNumber` = '4514' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2626' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in family friendly Waterside Estates this spacious, Perry built home is ready for you to move right in and call it home! Wood floors are in both formal areas in addition to the den/family room. 2 inch blinds and/or drapes in every room. The spacious kitchen allows for multiple cooks.....more than ample counter space plus gas cooktop & built-in Jennaire oven/microwave.....Whirlpool refrigerator stays.\r\nCome take a look. You\'ll be glad you did!' ,`Acres` = '0.1843' ,`Area` = '37' ,`BuilderName` = 'Perry' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WATERSIDE ESTATES SEC 6, BLOCK 1, LOT 36' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8028' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'OAKLAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'BOWIE MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Waterside Estates Sec 6' ,`TaxAmount` = '6677' ,`TaxRate` = '2.2929' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928762' WHERE `Matrix_Unique_ID` = '213598684' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T20:41:53.567' ,`MLSNumber` = '9596878' ,`ListAgentFullName` = 'Maria Hernandez' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.841787' ,`Longitude` = '-95.463468' ,`PhotoCount` = '14' ,`PostalCode` = '77091' ,`RoomCount` = '3' ,`ListPrice` = '284000.00' ,`Status` = 'Active' ,`StreetName` = 'Broom' ,`StreetNumber` = '4916' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1456' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great opportunity to own this beautiful totally renovated 3 bedrooms and 2 full bathrooms. Everything is new here, except part of the frame and the water heather. Upgraded with hight ceiling and master bedroom addition. Granite kitchen countertops, master vanities and shower seat. Quartz second bath vanity. Wood look water resistance laminate flooring throughout. New electrical, plumbing, HVAC Systems. Two sink in master and walk in closet. Stainless Steel appliances. Soft close cabinets including lazy Susan in kitchen for your storage convenience. Within minutes to the Galleria, Houston Downtown, TC Jester Park and Kroger. Quiet neighborhood, low taxes, no HOA, no in a flood zone. Schedule your showing today!' ,`Acres` = '0.1' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 27 BLK 23 ROSSLYN HEIGHTS SEC 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '3000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SMITH ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Rosslyn Heights Sec 01' ,`TaxAmount` = '2742' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928762' WHERE `Matrix_Unique_ID` = '213606738' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T20:30:54.303' ,`MLSNumber` = '88990563' ,`ListAgentFullName` = 'Terri Cole' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.054277' ,`Longitude` = '-95.376636' ,`PhotoCount` = '23' ,`PostalCode` = '77373' ,`RoomCount` = '6' ,`ListPrice` = '255000.00' ,`Status` = 'Active' ,`StreetName` = 'Barrington Bluff' ,`StreetNumber` = '23115' ,`StreetSuffix` = 'Trail' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1442' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'YOU WILL LOVE THIS BEAUTIFUL LITTLE GEM! PERFECTLY MAINTAINED AND LIVED IN VERY LIGHTLY. VERY OPEN FLOORPLAN FLOWS FROM THE FRONT DOOR TO THE CUTEST EVER COVERED PATIO IN BACKYARD. BEAUTIFUL LAMINATE FLOORS THROUGHOUT, DECORATOR PAINT, THE KITCHEN HAS AN AWESOME EAT AT ISLAND WITH BREAKFAST BAR ON ONE SIDE AND IS FOCAL POINT OF THE HOME, BEAUTIFUL DARK CABINETS, PANTRY, HIGH CEILINGS AND CANNED LIGHTING, DINING AREA ALSO OPEN TO ALL. PRIMARY BEDROOM IS IN THE BACK OF THE HOUSE, IT HAS A GREAT BATHROOM WITH DOUBLE SINKS, INVITING TUB AND A WALK IN CLOSET, SPLIT FROM SECONDARY BEDROOMS AND LARGE BATHROOM. THE HOUSE OVERALL LOOKS LIKE BRAND NEW. ONE OCCUPANT ONLY. PURCHASED IN 2020. THE YARD IS AWESOME AND IF YOU CHECK IT OUT I THINK YOU\'LL LOVE IT.' ,`Acres` = '0.1151' ,`Area` = '12' ,`BuilderName` = 'Horton' ,`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 10 BLK 3 BRECKENRIDGE WEST SEC 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5014' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,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,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'BRECKENRIDGE WEST' ,`TaxAmount` = '5552' ,`TaxRate` = '3.0268' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928762' WHERE `Matrix_Unique_ID` = '213612305' --> 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','213622328','1665928762','213622328','2022-10-15T20:15:17.377','39407267','Anthony Macaluso','Realty Solutions','','','29.451867','-95.103171','21','77539','4','297500.00','Active','Aguila Creek','3015','Court','League City','2','0','3','1873','Single-Family','Welcome to 3015 Aguila Creek CT. This home offers 3 bedrooms and 2 full bathrooms. First thing you will notice are the high ceilings throughout the entire home. You will also notice when you walk in is the large office that can be easily converted to a 4th bedroom if needed. The home offers an open concept kitchen into the large living area. When outside you will notice the 10x40 covered patio and amazing hot tube. perfect for those amazing nights under the stars. Don\'t miss out on this beautiful home.','0.1506','33','','','','','Sellers Disclosure','1','','','League City','Central Gas','1','BAY COLONY POINTE WEST SEC 10 (2016) ABST 19, BLOCK 1, LOT 8','Subdivision Lot','6558','Appraisal District','','560','0','','2','','0','','','','','Composition','17 - Dickinson','CALDER ROAD ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','LOBIT MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Bay Colony Pointe West Sec 10','9471','3.4497','Public Sewer,Public Water','2016','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T21:15:51.327' ,`MLSNumber` = '35725131' ,`ListAgentFullName` = 'Chris Glapa' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.845055' ,`Longitude` = '-95.725293' ,`PhotoCount` = '38' ,`PostalCode` = '77449' ,`RoomCount` = '7' ,`ListPrice` = '269900.00' ,`Status` = 'Active' ,`StreetName` = 'Juniper Spring' ,`StreetNumber` = '5131' ,`StreetSuffix` = 'Trail' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2020' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Tucked away on a quiet oversized culdesac lot in desirable Ricewood Village, this inviting 2-story home features luxurious updates & modern floorplan! Eye-catching curb appeal boasts a mature Oak tree & potted plants along the sidewalk that leads you to the covered front porch! Upon entering you\'re greeted by gorgeous laminate flooring, custom accent wallpaper, & tons of natural light! Gourmet Chef\'s island kitchen w/exquisite granite counters, custom glass tile backsplash, endless cabinetry, & stainless steel appliances w/gas range & built-in microwave is a dream! Conveniently located half bath & utility space is at the rear of the kitchen & adjacent to the garage access! Spacious master suite w/custom ceiling fan offers an en suite bath w/walk-in shower & separate garden soaking tub, extended vanity w/dual sinks, along w/2 HUGE walk-in closets! Large secondary bedrooms & flex/media/bedroom w/projector & equipment! Oversized private backyard w/extended decking & tons of greenspace!' ,`Acres` = '0.1229' ,`Area` = '25' ,`BuilderName` = 'Foxwood' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 31 BLK 1 RICEWOOD VILLAGE SEC 4' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5352' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '478' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'M ROBINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (CY-FAIR)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ricewood Village Sec 4' ,`TaxAmount` = '5611' ,`TaxRate` = '3.011' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928762' WHERE `Matrix_Unique_ID` = '213647830' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T21:25:08.117' ,`MLSNumber` = '64833133' ,`ListAgentFullName` = 'Gretchen Barrilleaux' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.728156' ,`Longitude` = '-95.810509' ,`PhotoCount` = '32' ,`PostalCode` = '77494' ,`RoomCount` = '9' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Cole Trace' ,`StreetNumber` = '26410' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2611' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WOW! Come see this FANTASTIC 4 bedroom/3.5 bath Cinco Ranch Beauty located in the heart of Cinco Ranch! A darling front porch greets you home! Rich wood floors throughout (tile in the wet areas) no carpet! The island kitchen boast granite, subway marble tile backsplash, gas cooking, custom painted 42\" cabinets and undercabinet lighting! Open to to the family room with cozy gas fireplace! Private owners retreat with dual sinks, soaking tub, separate shower and walk-in pantry. Upstairs you will find 3 spacious bedrooms (one en suite), 2 baths and a game room! Extended covered patio with lush landscaping and no back neighbors! Community park behind home! Close to schools, amenities and shopping! Easy access to freeways! AWARD WINNING Katy ISD schools!' ,`Acres` = '0.137' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CINCO RANCH WEST SEC 32, BLOCK 1, LOT 32' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '5969' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1195' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'KILPATRICK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMPKINS HIGH SCHOOL' ,`SchoolMiddle` = 'CINCO RANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cinco Ranch' ,`TaxAmount` = '7542' ,`TaxRate` = '2.6245' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928762' WHERE `Matrix_Unique_ID` = '213655242' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T21:43:25.593' ,`MLSNumber` = '87335543' ,`ListAgentFullName` = 'Alex Narvaez' ,`ListOfficeName` = 'Velasco Realty Partners' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.982612' ,`Longitude` = '-95.672322' ,`PhotoCount` = '32' ,`PostalCode` = '77429' ,`RoomCount` = '3' ,`ListPrice` = '279000.00' ,`Status` = 'Active' ,`StreetName` = 'Cypress Trace' ,`StreetNumber` = '16138' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1932' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1653' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 98 BLK 2 CYPRESS POINT SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '575' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'FARNEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'GOODSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Point Sec 02' ,`TaxAmount` = '5805' ,`TaxRate` = '2.751' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928763' WHERE `Matrix_Unique_ID` = '213664041' --> 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','213694753','1665928763','213694753','2022-10-15T21:33:14.580','39065376','Alma Howard','HomeSmart','','','30.732733','-95.537362','11','77320','5','250000.00','Active','Bernice','113','Drive','Huntsville','2','0','3','1324','Single-Family','Gorgeous and well maintained property, tucked away in a cul-de-sac neighborhood, located close to SHSU. This home features an open floor plan, 3 bedrooms, 2 full baths, and a spacious fenced in backyard that is perfect for entertaining and includes a covered patio. This home was built in 2019 and includes sophisticated quartz counter tops, stainless steel appliances, barnyard doors in master bedroom & bathroom, a built in central vacuum system, sprinkler system in the front yard, and a 2.0 Ton Inverter 18 SEER Electric Heat Pump with Media Filter. No HOA. Nearby Downtown, I-45, and major retail shopping. Schedule your showing today!','0.2563','43','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','0','Huntsville Area','Heat Pump','0','THE MEADOW AT HORSE CREEK, BLOCK 1, LOT 8','Cul-De-Sac,Subdivision Lot','11166','Appraisal District','','','0','','0','Electric Oven,Freestanding Oven','0','','','Electric Cooktop,Freestanding Range','','Composition','64 - Huntsville','HUNTSVILLE ELEMENTARY SCHOOL','HUNTSVILLE HIGH SCHOOL','MANCE PARK MIDDLE SCHOOL','Accompany,Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','The Meadow At Horse Creek','3343','1.9609','Public Sewer,Public Water','2019','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','213696310','1665928763','213696310','2022-10-15T20:50:50.840','13606940','Kelsey Cadavid','Winhill Advisors - Kirby','','','29.765843','-95.340093','0','77020','3','450000.00','Active','Eado Park','360','Circle','Houston','3','1','3','2291','Single-Family','Modern/Contemporary gated single family home in the coveted Eado. Close to East River project, midtown, and downtown. Minutes away from I-10 and I-45 for an easy commute. Private turf covered backyard and HOA dog parks. The 1st floor has a mother-in-law suite with bedroom, full bath, stackable washer/dryer, kitchenette, and separate entrance! The 2nd floor is open concept bringing together the living, dining, and gourmet kitchen. The 3rd floor contains the primary and additional bedroom both with full bathrooms. Laundry area with washer and dryer combo included. Primary bath boasts spacious walk in closet, freestanding shower, soaking tub, and updated fixtures. Can be used as a long term rentals of 6 months or more. INCOME PRODUCING PROPERTY. Come tour today!','0.043','2','','','','','Sellers Disclosure','1','','','Denver Harbor','Central Gas','1','LT 63 BLK 1 NOBILITY PARK R/P','Corner','1875','Appraisal District','','1195','0','','2','','0','','','Gas Cooktop','','Composition','27 - Houston','BRUCE ELEMENTARY SCHOOL','WHEATLEY HIGH SCHOOL','MCREYNOLDS MIDDLE SCHOOL','Appointment Required','Appraisal District','4','Contemporary/Modern','Nobility Park Rep 1','9426','2.3307','Public Sewer,Public Water','2017','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','213698126','1665928763','213698126','2022-10-15T21:54:04.063','45080213','Yun Zhang','Texas Southwest Real Estate','','','29.829781','-95.795960','41','77493','10','565000.00','Active','Kee Cresta','24307','Court','Katy','3','1','5','3271','Single-Family','A RARE FIND - STUNNING LAKE FRONT HOME! Welcome to resort style living, luxury and charm are waiting! This gorgeous 5-bedroom home has been newly installed with wood imitation tile floors in the common area and newly painted with neutral color throughout the house. As you enter this home it will take your breath away – it boasts a spacious family room with two-story soaring ceilings overlooking the lake and fountain view, home office, formal dining, media room and game room. Kitchen open to the family room, with large granite countertop island and a breakfast bar. You don’t want to miss all that this gorgeous home has to offer! House is located in a quiet cul-de-sac in the heart of Katy. Great community amenities. Highly sought after Katy ISD. Check out the virtual 3D tour and schedule your showing today!','0.1559','25','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Katy - Old Towne','Central Gas','1','LT 8 BLK 1 MARCELLO LAKES SEC 1','Cul-De-Sac,Water View,Waterfront','6793','Appraisal District','','1500','0','','2','Freestanding Oven,Gas Oven','0','','','Gas Cooktop','','Composition','30 - Katy','LEONARD ELEMENTARY SCHOOL (KATY)','PAETOW HIGH SCHOOL','HASKETT JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Marcello Lakes Sec 1','','','Public Sewer,Public Water,Water District','2018','Appraisal'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T21:21:25.333' ,`MLSNumber` = '85531874' ,`ListAgentFullName` = 'Nataliya Chernis' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.627592' ,`Longitude` = '-95.621014' ,`PhotoCount` = '6' ,`PostalCode` = '77498' ,`RoomCount` = '7' ,`ListPrice` = '220000.00' ,`Status` = 'Active' ,`StreetName` = 'Rolling Mill' ,`StreetNumber` = '842' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1898' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SOLD AS-IS, priced right! Great location, excellent layout, high ceilings! Needs TLC, very rare investment opportunity! Screened-in back porch, split 3 bedroom plan, large utility room, great kitchen with a wall of glass looking out to backyard. Pool size backyard, low taxes! Hurry, won\'t last!' ,`Acres` = '0.2327' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SUGARMILL SEC 2, BLOCK 2, LOT 39, R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10135' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '814' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LAKEVIEW ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'KEMPNER HIGH SCHOOL' ,`SchoolMiddle` = 'SUGAR LAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sugarmill Sec 2' ,`TaxAmount` = '4929' ,`TaxRate` = '2.0094' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928763' WHERE `Matrix_Unique_ID` = '213721727' --> 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','213732162','1665928763','213732162','2022-10-15T21:05:48.033','46876892','Huy Vu','Aimpro Realty & Management LLC','','','29.700391','-95.635670','27','77083','10','398000.00','Active','Ironwood Forest','7011','Drive','Houston','2','1','4','2487','Single-Family','Welcome home! You’ll love this two-story home with 18\' high ceiling in great room. Newly renovated with large tiles and wood flooring throughout the first and second floors. A spacious master bedroom downstairs with three bedrooms and a game room upstairs. 42\'\' maple upper cabinets and granite countertops in kitchen. Dual sinks and separate oversized tub/shower in master bath. Maple cabinets in bathroom. Large covered concrete patio at rear and around the sides. Sprinkler system in front yard. LED lights installed around the exterior of the house. Home is very well maintained by the owner. Minutes from schools, easy access to West Park Toll, and tons of restaurants and supermarkets nearby. Call to schedule\r\na showing today!','0.0958','28','K. Hovnanian® Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Alief','Central Gas','1','LT 3 BLK 3 TERRA DEL SOL SEC 9','Cleared,Subdivision Lot','4173','Appraisal District','','560','0','','2','Gas Oven,Single Oven','0','','','Freestanding Range,Gas Range','','Composition','2 - Alief','HICKS ELEMENTARY SCHOOL (ALIEF)','AISD DRAW','ALBRIGHT MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','2','Traditional','Terra Del Sol','6957','2.5785','Water District','2017','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','213732346','1665928763','213732346','2022-10-15T20:51:18.233','44650930','Ronnie Dees','JLA Realty','','','29.464746','-94.607370','31','77650','7','499900.00','Active','Whitecap','2599','','Port Bolivar','2','0','3','1200','Single-Family','Cozy and Quiet 3 bedroom 2 full bath beach house in Holiday Beach Subdivision. Enjoy the serene gulf winds and ocean sounds on your covered upper or lower patios with partial view of the beach and gulf waters. Beautiful vinyl wood-look flooring, granite countertops, recessed lighting and ceiling fans throughout. Living area made for entertaining with an easy open floor plan. Spacious living room boasts large windows allowing in plenty of natural light creating a bright and open space. Gourmet kitchen features a breakfast bar, undermount sink, stainless appliances and tile backsplash. recent updates/upgrades to include: New breaker box, A/C serviced, added 6\" of insulation, new roof vents, New deck, new soffit throughput, new lighting, new paint inside & out, new water heater, new appliances, new toilets, vanity & fixtures!! Property located in flood zone A! Schedule your showing of this perfectly priced home today!!','0.1736','33','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','0','Crystal Beach','Central Electric','0','ABST 65 B FRANKS SUR LOT 243 HOLIDAY BEACH','Corner,Subdivision Lot,Water View','7562','Appraisal District','','','0','','1','Electric Oven,Freestanding Oven','0','','','Electric Cooktop,Freestanding Range','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','1','Other Style','Holiday Beach','4802','1.6103','Public Water,Septic Tank','1982','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','213732815','1665928763','213732815','2022-10-15T21:59:11.163','14498190','Melida Marquez','RE/MAX Lake Livingston','','','30.683920','-94.747298','35','77351','8','186500.00','Active','Matheus','557','Drive','Livingston','1','1','2','1125','Single-Family','Spacious home sitting on beautiful 1+/-acres, 2/2 possible 3 bedrooms, beautiful spacious back porch with privacy all around, storage/workshop, fenced in back yard, 24x34 RV Parking with hookup plenty of room for your Boat. Enjoy the wildlife on your own private and the spacious yard for family gatherings. Located between Livingston and Woodville and 10 minutes from the Naskila Gaming Casino and reservation. Perfect for your RV, weekend retreat.','1.1478','44','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','0','Livingston Area','Central Electric','1','INDIAN SPRINGS LAKE ESTATES SECTION 3 LOT 254, 255, 354 & 35','Cleared,Subdivision Lot','50000','Appraisal District','','40','0','','0','Gas Oven','0','','','Gas Range','','Aluminum','103 - Livingston','LISD OPEN ENROLL','LIVINGSTON HIGH SCHOOL','LIVINGSTON JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment','Seller','1','Ranch','Indian Spgs Lake Estates','1481','1.8745','Public Water,Septic Tank','1970','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','213732956','1665928763','213732956','2022-10-15T21:46:48.813','22937243','Azeez Elegbeji','The Elegbeji Group','','','29.745705','-95.873741','0','77494','4','370000.00','Active','Vernon Forest Ct','29203','','Katy','2','1','4','2236','Single-Family','Neatly Kept 4 Bedroom, 2.5 Bath And 2 Story Zoned To LCISD.','','30','DR Horton','','','','Sellers Disclosure','1','','1','Katy - Southwest','Central Electric,Central Gas','1','Tamarron Sec 22, Block 4, Lot 28','Cul-De-Sac','','','','1250','0','','2','Electric Oven,Gas Oven','0','','','Electric Cooktop,Gas Cooktop','','Composition','33 - Lamar Consolidated','TAMARRON ELEMENTARY SCHOOL','FULSHEAR HIGH SCHOOL','ROBERTS/LEAMAN JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front','Appraisal District','2','English','Tamarron','','','Public Sewer,Public Water','2016','Appraisal District'); --> New record created successfully