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-08T20:16:18.033' ,`MLSNumber` = '3902135' ,`ListAgentFullName` = 'Hester Bell' ,`ListOfficeName` = 'RE/MAX One' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '30.051183' ,`Longitude` = '-94.174455' ,`PhotoCount` = '36' ,`PostalCode` = '77707' ,`RoomCount` = '18' ,`ListPrice` = '1300000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Lakeside' ,`StreetNumber` = '7730' ,`StreetSuffix` = '' ,`City` = 'Beaumont' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '7' ,`SqFtTotal` = '6242' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Everyday is a vacation in this beautiful estate in the sophisticated Crescent on Walden community! Construction completed by Anderson in August 2021, this perfectly appointed home, on just over an acre, has been lovingly designed with every modern convenience you desire: Luxury vinyl plank flooring; wood-wrapped beams; arched doorways; elegant lighting; art niches and a five-foot sliding barn door. Gourmet kitchen is a dream with its professional Thermador range, quartz counters, large center island and spacious breakfast area. The adjacent mother-in-law suite offers privacy with its own seating area and full bath complete with walk-in shower. Primary en suite overlooks the pond and continues the resort feel with its spa-like bathroom. Carefully designed to maximize storage space throughout. Outdoor entertaining is a breeze with gas fireplace and private access to the dock. Storage building finished to match the house. Truly a masterpiece and joy to show!' ,`Acres` = '1.03' ,`Area` = '51' ,`BuilderName` = 'Anderson' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 36 The Crescent on Walden Phase II' ,`LotDesciption` = 'Cleared,Waterfront' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1885' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '6' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'DISHMAN ELEMENTARY SCHOOL (BEAUMONT)' ,`SchoolHigh` = 'WEST BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'VINCENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Crescent on Walden' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1665344157' WHERE `Matrix_Unique_ID` = '206899862' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T20:29:45.043' ,`MLSNumber` = '43927599' ,`ListAgentFullName` = 'Krystal Bradford' ,`ListOfficeName` = 'Krystal Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.144791' ,`Longitude` = '-95.043987' ,`PhotoCount` = '34' ,`PostalCode` = '77554' ,`RoomCount` = '8' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Reeves' ,`StreetNumber` = '4010' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1182' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cute Beach Cottage....Desirable Sea Isle home offers a style that brings together cozy & casual elements to reflect an easy-going way of coastal life. Large open kitchen with ample counter & cabinet space. Living & dining has good space & fireplace with raised hearth. Downstairs offers 290 sq. ft. of air conditioned bonus space... could be bedroom, game room or multipurpose room! Other features include luxury wood laminate floors, covered decks to enjoy the beautiful sunrise & sunsets & hear the waves, huge tandem sized garage, tons of space, washer & dryer as well as a half bath. New AC 7-25-22. Doublewide drive offers great space for ample parking. Park a boat or RV Large backyard, outdoor shower & more! Sea Isle offers: pool, boat ramp, fishing pier, sports courts, Clay Walkers West End restaurants, Marina store & playground. New Beachside Bar & Grill at neighborhood entrance. Higher elevated than other surrounded homes & downstairs has NEVER flooded.' ,`Acres` = '0.1377' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Special Addendum' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 PAGE 19 LOT 657 SEA ISLE' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '236' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Lockbox Left Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sea Isle Orig' ,`TaxAmount` = '5775' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1665344158' WHERE `Matrix_Unique_ID` = '207124275' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T20:03:35.937' ,`MLSNumber` = '89467700' ,`ListAgentFullName` = 'Michelle Murray' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '30.350684' ,`Longitude` = '-95.820406' ,`PhotoCount` = '50' ,`PostalCode` = '77363' ,`RoomCount` = '3' ,`ListPrice` = '395000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Highway 105' ,`StreetNumber` = '17996' ,`StreetSuffix` = '' ,`City` = 'Plantersville' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2174' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to one of the fastest growing areas South Central Texas. This property sits between Montgomery & Plantersville and can be residential or commercial use. With 178\' of prime FM 105 frontage, this 2 acre tract with custom 3bed, 2bath single family home could be your next best business or tucked away family home. Wooded and surrounded by family farms. Over 1300sf metal barn complet with tack and stalls, electricity. Plenty of space for your family and your business. City water. 2 car garage has been turned into an office, but can be converted back garage space. Lots of storage. The home boasts warm brick walls in living & kitchen. Granite kitchen with lots of space. MUD ROOM, UTILITY ROOM. Make it home and make it a business...its your call. Bring the horses or bring the employees. So many oppotunities with this property. Call your Realtor today! Please do not enter the property gate without a Realtor.' ,`Acres` = '2' ,`Area` = '60' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Plantersville Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0063 A YEAMAN, TRACT 19-1, ACRES 2' ,`LotDesciption` = 'Wooded' ,`LotSize` = '87120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '129 - Navasota' ,`SchoolElementary` = 'HIGH POINT ELEMENTARY SCHOOL (Navasota)' ,`SchoolHigh` = 'NAVASOTA HIGH SCHOOL' ,`SchoolMiddle` = 'NAVASOTA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Dyer Mill' ,`TaxAmount` = '4828' ,`TaxRate` = '1.7749' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1665344158' WHERE `Matrix_Unique_ID` = '208430561' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T21:27:53.883' ,`MLSNumber` = '73151345' ,`ListAgentFullName` = 'Daryl Pavlicek' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = 'Robert Miller' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.699044' ,`Longitude` = '-95.829289' ,`PhotoCount` = '18' ,`PostalCode` = '77494' ,`RoomCount` = '7' ,`ListPrice` = '379900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Salt Creek' ,`StreetNumber` = '26110' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2516' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful one story home in a cul-de-sac lot. Rotunda entrance with tile. Archway into the formal dining and game room/media. Game room can easily be converted into a 4th bedroom. Butlers pantry leading into the kitchen. Great for entertaining. Outdoor space touts covered patio and extended pressed stone patio.' ,`Acres` = '0.2082' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CINCO RANCH SOUTHWEST SEC 15, BLOCK 7, LOT 20' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9068' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'STANLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEVEN LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'SEVEN LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Cinco Ranch Southwest Sec 15' ,`TaxAmount` = '8717' ,`TaxRate` = '2.7845' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344158' WHERE `Matrix_Unique_ID` = '209518292' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T21:02:10.407' ,`MLSNumber` = '10334924' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.504650' ,`Longitude` = '-95.718948' ,`PhotoCount` = '35' ,`PostalCode` = '77406' ,`RoomCount` = '7' ,`ListPrice` = '500000.00' ,`Status` = 'Active' ,`StreetName` = 'Garnet Peak' ,`StreetNumber` = '5915' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2858' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Relax in the comfort and luxury of The Brookdale dream home plan. The spacious study presents a versatile opportunity to create your ideal home office, fun and games parlor, or arts and crafts workshop. Cook up culinary delights in the streamlined kitchen that features a deluxe pantry and a presentation island. Your open floor plan offers a sunlit space ready to fulfill your lifestyle and décor ambition. Calm relaxation and sensational social gatherings are waiting for you on your serene covered patio. Your awe-inspiring Owner’s Retreat provides a glamorous way to begin and end each day, and includes a superb en suite bathroom and a wardrobe-expanding walk-in closet. Each spare bedroom and guest suite supports growing minds and personalities by combining unique features and plenty of space to thrive. Contact our Internet Advisor to learn more about this incredible new home plan.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Block 1' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CARTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Stonecreek Estates' ,`TaxAmount` = '' ,`TaxRate` = '3.22' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665344158' WHERE `Matrix_Unique_ID` = '209959249' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T21:19:44.190' ,`MLSNumber` = '20300244' ,`ListAgentFullName` = 'Melissa Rodriguez' ,`ListOfficeName` = 'The Reyna Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.878081' ,`Longitude` = '-95.437948' ,`PhotoCount` = '34' ,`PostalCode` = '77088' ,`RoomCount` = '3' ,`ListPrice` = '288000.00' ,`Status` = 'Active' ,`StreetName` = 'Tower' ,`StreetNumber` = '9305' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1592' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction home located in the newly Highland Heights subdivision. This home will offer a 3/Bedrooms, 2.5/Baths/2 Car Garage fully fenced in. No HOA! No Deed Restrictions! Home will feature a spacious living area with open kitchen family layout. Kitchen will offer quartz counter tops with pendant lighting. Laminate wood flooring throughout. All bedrooms are located on the 2nd floor. Primary bathroom features dual sinks with shower/tub combo. Conveniently located by all the major highways.' ,`Acres` = '0.0413' ,`Area` = '11' ,`BuilderName` = 'Ecua Homes on Tower' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 ECUA HOMES ON TOWER' ,`LotDesciption` = 'Other' ,`LotSize` = '1800' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'ANDERSON ACADEMY' ,`SchoolHigh` = 'CARVER H S FOR APPLIED TECH/ENGINEERING/ARTS' ,`SchoolMiddle` = 'DREW ACADEMY' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland Heights' ,`TaxAmount` = '315' ,`TaxRate` = '2.5119' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665344158' WHERE `Matrix_Unique_ID` = '210238458' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T21:34:52.053' ,`MLSNumber` = '70951464' ,`ListAgentFullName` = 'Rita Bray' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.116989' ,`Longitude` = '-95.246145' ,`PhotoCount` = '21' ,`PostalCode` = '77365' ,`RoomCount` = '8' ,`ListPrice` = '253500.00' ,`Status` = 'Active' ,`StreetName` = 'Sullivan Forest' ,`StreetNumber` = '21498' ,`StreetSuffix` = 'Drive' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1613' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this beautiful, lovely, and desirable one-story home in Porter. The lot is beautifully landscaped and has a stunning front-stone elevation. Very well maintained! Chef\'s Dream kitchen with granite-inspired counter tops, and an abundance of cabinets. The living room is cozy and includes a fireplace and custom-built cabinets surrounding the fireplace. A very spacious entrance. The large primary suite offers walk-in closets. The primary bath has double sinks, a tub & potential separate shower(The plumbing is ready for it). A WATER SOFTENER AND FILTRATION SYSTEM WAS ADDED TO THE HOUSE 1 YEAR AGO (valued at $8000). It\'s a split floor plan. Spacious utility room with ample room for washer/dryer/fridge or freezer. Front and back have covered patios and a fully fenced-in backyard. All kitchen appliances are included. Just minutes away from Valley Ranch Town Center, Movie Theater, Restaurants, and more! Schedule your tour today!' ,`Acres` = '0.1900367' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S508803 - FOREST COLONY 03, BLOCK 3, LOT 15' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '8278' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '615' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'VALLEY RANCH ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'NEW CANEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'FOREST COLONY 03, BLOCK 3, LOT 15' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1665344158' WHERE `Matrix_Unique_ID` = '210911347' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T20:19:49.257' ,`MLSNumber` = '56270650' ,`ListAgentFullName` = 'Taha Elhajj' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.634415' ,`Longitude` = '-95.759649' ,`PhotoCount` = '27' ,`PostalCode` = '77406' ,`RoomCount` = '4' ,`ListPrice` = '569000.00' ,`Status` = 'Active' ,`StreetName` = 'CLAYHEAD' ,`StreetNumber` = '3220' ,`StreetSuffix` = '' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'OPEN HOUSE SATURDAY1PM-3 PM 10-8-2022 SOFT DRINKS. 1.4 ACRES. WELCOME HOME ,RARE FIND,RELAXED LIVING .4 BEDROOMS 2 FULL BATHS IN THE CITY OF RICHMOND.TILE AND CARPET FLOORING .RECENT PAINT,GRANITE COUNTER TOPS AND SPACIOUS FORMAL LIVING AND DINING AREA.LIVING ROOM WITH WOOD BURNING FIREPLACE.GREAT VIEW ,ENJOY THE POOL.PEACAN TREES ,2 CAR GARAGE ,FIRE PIT AND BARN WITH CHICKEN.SWIMMING POOL.SELLERS DISCLOSURE IS ATTACHED.IF LISTING AGENT SHOWS PROPERTY THEN BUYERS AGENT COMMISION IS 1.5 PERCENT .' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '0046 KNIGHT AND WHITE,TRACT 54,ACRES 1.4' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'KNIGHT AND WHITE' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1665344159' WHERE `Matrix_Unique_ID` = '210990833' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T21:37:00.953' ,`MLSNumber` = '45423072' ,`ListAgentFullName` = 'Christina Belter-Moss' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.928552' ,`Longitude` = '-95.278394' ,`PhotoCount` = '27' ,`PostalCode` = '77396' ,`RoomCount` = '12' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Red Creek' ,`StreetNumber` = '14511' ,`StreetSuffix` = 'Court' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3973' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful open concept home is in the prestigious Golf Club of Houston golf course community and is situated on the corner lot of a cul-de-sac, with a family pool, elementary school and lap pool just blocks away! The Fall Creek subdivision provides many more amenities such as parks, sand volleyball courts, baseball, and softball fields to enjoy with your family! This 1 ½ story home includes 4 bedrooms, 3 ½ baths, formal dining room, office, and media/game room. The spacious granite island and counter tops compliment the tile backsplash and fixed with a breakfast bar open to the large family room, perfect for entertaining! Fall Creek is a master-planned community near IAH, downtown, 59 and beltway 8. Schedule your showing today!' ,`Acres` = '0.2575' ,`Area` = '1' ,`BuilderName` = 'David Weekley' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fall Creek Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 1 FALL CREEK SEC 25' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '11215' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1090' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'FALL CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Fall Creek' ,`TaxAmount` = '9981' ,`TaxRate` = '2.9973' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344159' WHERE `Matrix_Unique_ID` = '211005475' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T20:21:39.657' ,`MLSNumber` = '61932825' ,`ListAgentFullName` = 'Teri Brockway' ,`ListOfficeName` = 'Simien Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.593029' ,`Longitude` = '-95.116934' ,`PhotoCount` = '35' ,`PostalCode` = '77059' ,`RoomCount` = '8' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Crestbrook' ,`StreetNumber` = '15722' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2252' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Brook Forest! This one-story, four bedroom home offers multiple living areas with flexibility to meet your family\'s needs. The kids and pets will enjoy the spacious back yard and there is plenty of room for entertaining. The beautiful neighborhood offers play grounds, swimming pool, tennis courts, and a greenbelt for those who like to walk or bike. Zoned to fantastic Clear Creek ISD schools, and located near lots of shopping, dining, and entertainment. No flooding! Now is your opportunity to put your special touches on this home in the heart of Clear Lake.' ,`Acres` = '0.2206' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 62 BROOK FOREST SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9610' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '508' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ARMAND BAYOU ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Brook Forest Sec 03' ,`TaxAmount` = '7398' ,`TaxRate` = '2.5769' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1665344159' WHERE `Matrix_Unique_ID` = '211011825' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T21:45:45.860' ,`MLSNumber` = '5343969' ,`ListAgentFullName` = 'Melissa Seureau' ,`ListOfficeName` = 'RE/MAX Preferred Homes' ,`SellingAgentFullName` = 'Monica Vaca' ,`SellingOfficeName` = 'PRG, Realtors' ,`Latitude` = '29.888690' ,`Longitude` = '-95.702082' ,`PhotoCount` = '29' ,`PostalCode` = '77433' ,`RoomCount` = '8' ,`ListPrice` = '280000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Prairie Fire' ,`StreetNumber` = '7803' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1976' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEE in LOVE!! Updated home in Yaupon Ranch with gorgeous travertine tile throughout first floor. Second floor features updated paint, and luxury vinyl floors. Living room is open to formal dining room which could be used as a study or playroom. Kitchen has tons of white cabinets, granite countertops, and updated SS Whirlpool appliances! Eat-in breakfast. Good size back yard with patio. All bedrooms up with game room. Huge Primary Suite is Sweet!! Large closets. Cy-Fair ISD. All appliances included with a full price offer. Furnace replaced in 2020, outside A/C unit and water heater replaced in 2022. Give Busy Bee a buzz for a private showing today!!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 3 YAUPON RANCH SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'JOWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'HOPPER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Yaupon Ranch' ,`TaxAmount` = '5474' ,`TaxRate` = '3.041' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344159' WHERE `Matrix_Unique_ID` = '211059765' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T21:16:23.623' ,`MLSNumber` = '45330800' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.209379' ,`Longitude` = '-95.750782' ,`PhotoCount` = '37' ,`PostalCode` = '77354' ,`RoomCount` = '8' ,`ListPrice` = '354658.00' ,`Status` = 'Active' ,`StreetName` = 'Summer Crest' ,`StreetNumber` = '42533' ,`StreetSuffix` = 'Road' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2229' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW DAVID WEEKLEY HOME! Guaranteed heating and cooling usage for three years with our Environments for Living program! Treat yourself to the captivating lifestyle experience of the elegant and effortless Woodworth dream home plan. Play host and get the most out of everyday life in your welcoming and beautiful open-concept living spaces. The modern kitchen features a large pantry, plenty of prep space, and a full-function island. Each guest suite and spare bedroom presents a wonderful place for individual styles to shine. Your bright and airy study is the perfect place for a productive home office, a music room, or a family movie theater. End each day and wake up refreshed in the luxurious Owner’s Retreat that includes a serene en suite bathroom and a spacious walk-in closet. Experience the LifeDesign? advantages of this new home plan.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1 Block 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Magnolia Escondido' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665344159' WHERE `Matrix_Unique_ID` = '211476630' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T21:00:26.823' ,`MLSNumber` = '52403687' ,`ListAgentFullName` = 'Bobby Thomas' ,`ListOfficeName` = 'World Wide Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.084136' ,`Longitude` = '-95.260978' ,`PhotoCount` = '39' ,`PostalCode` = '77365' ,`RoomCount` = '11' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'Jaymarr' ,`StreetNumber` = '25106' ,`StreetSuffix` = 'Court' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3187' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous energy-efficient 4bdrm/2.5bath home on a premium cul de sac lot with mature trees. Walking distance to golf course. Few of the many updates include granite counters, utility room with designated sink and cabinetry, tankless water heater, mud room with built-ins, laminated wood floors, in-wall speakers in Primary room, Living, Dining areas, upstairs study with french doors plus additional private study downstairs with french doors off primary bedroom, cedar surround in primary bath w/ upgraded shower, 2 extra insulated rooms (great for man-cave or a musician), extended concrete for covered patio, extended workshop with AC, and storage shed stays. Community offers basketball courts, splash area, pool, club house, and multiple playgrounds. Low tax rate!' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood NW/Oakhurst' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BENTWOOD 01, BLOCK 8, LOT 39' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '7695' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'BENS BRANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WOODRIDGE FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bentwood' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344160' WHERE `Matrix_Unique_ID` = '211649133' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T20:07:01.183' ,`MLSNumber` = '4910514' ,`ListAgentFullName` = 'Jack Lipar' ,`ListOfficeName` = 'LGI Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.182784' ,`Longitude` = '-95.799589' ,`PhotoCount` = '8' ,`PostalCode` = '77355' ,`RoomCount` = '9' ,`ListPrice` = '261900.00' ,`Status` = 'Active' ,`StreetName` = 'Shakespeare' ,`StreetNumber` = '23013' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1366' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand-new beautiful 3 bedroom, 2 bathroom, one story home showcasing an open floor plan between the entertaining areas of the home. The spacious flow between the kitchen living and dining is a true dream. The kitchen is loaded with modern upgrades including granite countertops, vinyl plank flooring, and all brand new Whirlpool appliances included. Even a refrigerator and microwave. This home also includes a 2-car garage with an automatic garage door opener. This lot features close and easy access to the on site amenities. You are short walking distance to the playground, splashpad, and shaded picnic areas in this wonderfully wooded community of Williams Trace located in Magnolia.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'LGI Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'MGL L2, Bl2, Sec3 of Williams Trace' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '348' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'WILLIE E. WILLIAMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Williams Trace' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665344160' WHERE `Matrix_Unique_ID` = '211950959' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T21:27:12.110' ,`MLSNumber` = '98550486' ,`ListAgentFullName` = 'Jenine Cinco' ,`ListOfficeName` = 'Kay Stimson Properties , LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.213283' ,`Longitude` = '-95.589607' ,`PhotoCount` = '45' ,`PostalCode` = '77354' ,`RoomCount` = '12' ,`ListPrice` = '535000.00' ,`Status` = 'Active' ,`StreetName` = 'Bear Mountain' ,`StreetNumber` = '8907' ,`StreetSuffix` = 'Court' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3648' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UPGRADES GALORE and GENEROUS BACKYARD. Gorgeous 4 bedroom, 3.5 bath PLUS media and game room. 3,648 sqft, OVERSIZED, CUL DE SAC LOT, built in 2019. Brick and stone exterior with covered front porch and back patio. 2-story foyer with elegant ENGINEERED OAK WOOD floors. ABUNDANT NATURAL LIGHT and RAISED CEILINGS throughout. Open floor plan kitchen with GRANITE countertops, SS appliances, GAS cooktop and DOUBLE OVEN. Primary suite DOWN has expanded floor plan, oversized bath with double vanities, separate shower and soak tub. Second floor features a GUEST BEDROOM W/ ENSUITE BATH, 2 extra guest suites and a shared full bath. Media room plus a separate game room UP. Water softener, Sprinkler System, 3 min. drive to HEB, zoned to Magnolia ISD. Fully fenced backyard with room for pool. We cannot wait to see you! Schedule a preview today.' ,`Acres` = '0.226' ,`Area` = '15' ,`BuilderName` = 'KB Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S341107 - CIMARRON CREEK 07, BLOCK 2, LOT 23' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '9843' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '965' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'BEAR BRANCH ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cimarron Creek' ,`TaxAmount` = '6397' ,`TaxRate` = '3.1887' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344160' WHERE `Matrix_Unique_ID` = '212233068' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T21:30:25.890' ,`MLSNumber` = '58354600' ,`ListAgentFullName` = 'Liz Guevara Backman' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.568582' ,`Longitude` = '-95.764792' ,`PhotoCount` = '41' ,`PostalCode` = '77469' ,`RoomCount` = '7' ,`ListPrice` = '277000.00' ,`Status` = 'Active' ,`StreetName` = 'Long' ,`StreetNumber` = '1702' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2115' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nestled on a tree-lined street, this recently remodeled home welcomes you with a wide open floor plan, perfect for entertaining. Super cute kitchen with tons of storage and lots of counter space for all your prep work. Eat meals in the breakfast area next to the kitchen or right at the kitchen bar. Large bedrooms with original hardwood floors and lots of natural light. No carpet in the home! Don’t forget the enclosed back patio area that allows for backyard entertaining without worries about weather or bugs. Huge yard with shed for all outdoor extras or convert it to fun space for hobbies. Important improvements completed by the sellers include new AC and ductwork (5/2017), kitchen and living rooms floors replaced (12/2020), exterior painting and fence (2/2020), interior painting (9/2022), and all new plumbing under the house (10/2020) to connect to the city line. Never flooded and no HOA. Conveniently located minutes from Brazos Town Center for shopping, dining, and entertainment.' ,`Acres` = '0.2537' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WINSTON TERRACE SEC 2, BLOCK 11, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LONG ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Winston Terrace Sec 2' ,`TaxAmount` = '4314' ,`TaxRate` = '2.3748' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344160' WHERE `Matrix_Unique_ID` = '212245847' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T21:07:01.170' ,`MLSNumber` = '96585656' ,`ListAgentFullName` = 'Shary Luthe' ,`ListOfficeName` = 'Home Sweet Home Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.353090' ,`Longitude` = '-95.079577' ,`PhotoCount` = '25' ,`PostalCode` = '77327' ,`RoomCount` = '3' ,`ListPrice` = '266000.00' ,`Status` = 'Active' ,`StreetName` = 'Deputy O Mcduffie Jr' ,`StreetNumber` = '1216' ,`StreetSuffix` = 'Street' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1658' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Appraisal And Survey Complete- Beautiful New Custom Home In The Heart Of Cleveland With No HOA And No Restrictions! The Home Features A Gorgeous Stone Exterior Front Built On A Slab- Close To Schools And Shopping! This 3 Bedroom/ 2.5 Bath Home Has A 2 Car Attached Garage, An Oversized Covered Back Patio- Plenty Of Space For An Outdoor Kitchen. This Home Has Upgraded Finishes Throughout! The Kitchen Boasts Tons Of Cabinet Space With Sparkling White Quartz Countertops, Subway Tile Backsplash And A Huge Island With Sink And Dishwasher Overlooking The Family Room. The Primary Bathroom Has A HUGE Separate Soaking Tub And Stand Up Shower, Dual Sinks And Tons Of Closet Space! NO RESTRICTIONS And No HOA To Worry About! Don\'t Wait- This One Won\'t Last Long!' ,`Acres` = '' ,`Area` = '52' ,`BuilderName` = 'JCNB General Contrac' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'MAYFIELD, BLOCK 1, LOT 19 20, ACRES .3214' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '7000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'NORTHSIDE ELEMENTARY SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mayfield' ,`TaxAmount` = '351' ,`TaxRate` = '2.564' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665344160' WHERE `Matrix_Unique_ID` = '212459457' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T20:42:01.763' ,`MLSNumber` = '32898864' ,`ListAgentFullName` = 'Marcy alBeirakdar' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.403343' ,`Longitude` = '-94.927279' ,`PhotoCount` = '25' ,`PostalCode` = '77590' ,`RoomCount` = '6' ,`ListPrice` = '164999.00' ,`Status` = 'Active' ,`StreetName` = '20th' ,`StreetNumber` = '2217' ,`StreetSuffix` = 'Avenue' ,`City` = 'Texas City' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1053' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in the heart of Texas City, this home will be great for first time home buyer or investor. Tile and lament flooring, granite counter tops in kitchen and bathroom. Low maintenance...roof, ac, water heater, driveway replaced about 5 years ago. *professional pictures coming soon*' ,`Acres` = '0.1412' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 167 D RICHARDSON SUR LOT 14 BLK 4 CLEARVIEW TERRACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'GUAJARDO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TEXAS CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BLOCKER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Clearview Terrace' ,`TaxAmount` = '2740' ,`TaxRate` = '2.5335' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344160' WHERE `Matrix_Unique_ID` = '212536058' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T20:38:18.123' ,`MLSNumber` = '10320848' ,`ListAgentFullName` = 'Yvette Williams' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.810373' ,`Longitude` = '-94.896018' ,`PhotoCount` = '27' ,`PostalCode` = '77523' ,`RoomCount` = '10' ,`ListPrice` = '305000.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`='1665344161' WHERE `Matrix_Unique_ID` = '212570168' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T21:12:16.430' ,`MLSNumber` = '22269773' ,`ListAgentFullName` = 'Carolyn Kelly' ,`ListOfficeName` = 'RE/MAX Northwest, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.699373' ,`Longitude` = '-94.837179' ,`PhotoCount` = '31' ,`PostalCode` = '77351' ,`RoomCount` = '3' ,`ListPrice` = '175000.00' ,`Status` = 'Active' ,`StreetName` = 'Amber Lane' ,`StreetNumber` = '170' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1508' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Pure country living with the tin roof to boot! Come feel the cabin charm with cedar island and cabinets, free standing wood burning fireplace, real wood floors and a tin roof. Property surrounded by bamboo tress. House sits on .5627 acres and there is an additional .561 acres for a garden or chickens or whatever your heart desires. There are 2 additional building on this property could be used for storage, guest room, she shed or man cave. New AC unit installed 8-22.\r\n\r\nMeasurements and information are approximate and should be verified.' ,`Acres` = '1.1' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Menard Creek Estates Lot 17 & 18' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Menard Creek Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344161' WHERE `Matrix_Unique_ID` = '212593657' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T21:15:57.620' ,`MLSNumber` = '91083672' ,`ListAgentFullName` = 'Angela Wells' ,`ListOfficeName` = 'Stanfield Properties' ,`SellingAgentFullName` = 'Charlotte Norambuena' ,`SellingOfficeName` = 'UTR TEXAS, REALTORS' ,`Latitude` = '29.343874' ,`Longitude` = '-95.480577' ,`PhotoCount` = '30' ,`PostalCode` = '77583' ,`RoomCount` = '12' ,`ListPrice` = '629000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Suncreek' ,`StreetNumber` = '16711' ,`StreetSuffix` = 'Ranch' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3219' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Picture perfect 3 bedroom, 2.5 bath custom home on a sprawling 4.3 acre lot in Rosharon\'s tranquil Suncreek Ranch community! From this slice of heaven, you\'ll enjoy unobstructed views of sunsets from your covered porches along with roaming deer and tiny hummingbirds. Custom built by the current owner, this split floorplan home features a spacious family room with a gas-log fireplace, built-in shelving & cabinetry, and a beautiful view of the pristinely manicured landscape. The chef’s kitchen boasts custom cabinets & granite counters, an island with a 5-burner gas cooktop, and a corner sink with windows. A lovely master bedroom with an updated en-suite bath boasts a spa tub and separate shower and a large walk-in closet. Upstairs, find a secluded gameroom with a balcony porch to enjoy a cup of coffee in the morning. Suncreek Ranch boasts a low tax rate, no MUD tax, & an easy drive to the Medical Center, Pearland shopping & entertainment, Dow, & Surfside Beach.' ,`Acres` = '4.32' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rosharon' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'SUNCREEK RANCH SEC 1 (A0125 A ROBINSON) BLK 4 LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '188179' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'FRONTIER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Ranch' ,`Subdivision` = 'Suncreek Ranch Sec 1-2-3-4' ,`TaxAmount` = '9207' ,`TaxRate` = '1.986' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344161' WHERE `Matrix_Unique_ID` = '212599629' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T20:39:15.857' ,`MLSNumber` = '90398357' ,`ListAgentFullName` = 'Larisa Filippov' ,`ListOfficeName` = 'Texas Signature Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.886690' ,`Longitude` = '-95.526301' ,`PhotoCount` = '23' ,`PostalCode` = '77040' ,`RoomCount` = '11' ,`ListPrice` = '548800.00' ,`Status` = 'Active' ,`StreetName` = 'Adagio' ,`StreetNumber` = '7818' ,`StreetSuffix` = 'Avenue' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3280' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated home in the heart of Woodwind Lakes, close to the walking trails and the Lake. Two story Brick home with Private Remote Operated Driveway Gate. Oversized kitchen with QUARTZ countertops, Marble Backsplash and new applience package is open to the main family room with Fireplace and HIGH ceiling. The Office/5th bedroom with full BATH downstairs. Brand New Primary bath with marble floors, marble shower and soaking tub. High end vinyl plank floors ( No carpet) and new paint throught out. All new designer lighting and hardware. Gorgeous Lakes, Trails, Mature Trees, Pools, Pavilion, Parks, Tennis Court. Easy Access to Major Freeways, Schools Zoned to the Highly-Acclaimed Cypress-Fairbanks ISD. NO FLOOD!' ,`Acres` = '0.1835' ,`Area` = '11' ,`BuilderName` = 'Trendmaker' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 44 & TR 45A BLK 2 WOODWIND LAKES SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7993' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '816' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'GLEASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JERSEY VILLAGE HIGH SCHOOL' ,`SchoolMiddle` = 'COOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodwind Lakes Sec 03' ,`TaxAmount` = '8883' ,`TaxRate` = '2.591' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344161' WHERE `Matrix_Unique_ID` = '212631667' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T21:03:32.430' ,`MLSNumber` = '91090214' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.925282' ,`Longitude` = '-95.734184' ,`PhotoCount` = '38' ,`PostalCode` = '77433' ,`RoomCount` = '8' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Momentous' ,`StreetNumber` = '15223' ,`StreetSuffix` = 'Path' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2625' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You\'ll love the convenience of living in the beautiful master planned community of Bridgeland. The ample amenities and nearby shopping and dinning will make you wish you lived here sooner. Sophisticated design and easy elegance combine in The Edgeport new home plan. Enjoy the exquisite sanctuary of your Owner\'s Retreat, which features a splendid en suite bathroom and a walk-in closet. The kitchen island and open dining area offer a streamlined variety of mealtime settings. Flex your interior design skills in the limitless lifestyle potential of the upstairs retreat, the welcoming living area, and the deluxe family room. Everyday refinements include David Weekley Homes guarantees heating and cooling usage for 3 years thought the Environments For Living® program.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 05 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1380' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MCGOWN ELEMENTARY SCHOOL' ,`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` = 'Ranch,Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.54' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665344161' WHERE `Matrix_Unique_ID` = '212661848' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T21:02:27.923' ,`MLSNumber` = '39207854' ,`ListAgentFullName` = 'Diane Morales' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.699402' ,`Longitude` = '-95.820088' ,`PhotoCount` = '41' ,`PostalCode` = '77494' ,`RoomCount` = '9' ,`ListPrice` = '389999.00' ,`Status` = 'Active' ,`StreetName` = 'Nightingale Hill' ,`StreetNumber` = '9506' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2090' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Meticulous one-story home in Cinco Ranch has 3-Bedrooms and 2-full baths. Impressive Brick & Flagstone front elevation; Two-car Garage with additional double-wide parking. Entry of the home has High Ceilings, lots of natural lighting. Carpet in the Bedrooms, Engineered Hardwood and Tile Flooring. The Kitchen has Stainless Steel appliances, spacious dark cherry-wood cabinetry with Granite Counters; Formal Dining room has hardwood flooring, Desk area with built-in desk. The Primary Bedroom has a spacious bathroom and walk-in closet. The backyard offers a Covered Patio deck. Low maintenance landscape; Sprinkler system in the front and back. No Backyard Neighbors. The home is zoned to a Highly Acclaimed School District in Katy. Location of the home is within minutes to the West Park Tollway, 99 Grand Parkway Tollway and I-10 Freeway. The only thing missing in this home is \"You\".' ,`Acres` = '0.1773' ,`Area` = '36' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CINCO RANCH SOUTHWEST SEC 10, BLOCK 1, LOT 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7722' ,`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` = '30 - Katy' ,`SchoolElementary` = 'STANLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEVEN LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'SEVEN LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cinco Ranch Southwest Sec 10' ,`TaxAmount` = '7308' ,`TaxRate` = '2.7845' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344162' WHERE `Matrix_Unique_ID` = '212693848' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T21:14:21.990' ,`MLSNumber` = '47149427' ,`ListAgentFullName` = 'Andy Onder Yaltir' ,`ListOfficeName` = 'VITA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.714154' ,`Longitude` = '-95.427381' ,`PhotoCount` = '42' ,`PostalCode` = '77005' ,`RoomCount` = '16' ,`ListPrice` = '2850000.00' ,`Status` = 'Active' ,`StreetName` = 'Buffalo Speedway' ,`StreetNumber` = '6317' ,`StreetSuffix` = '' ,`City` = 'West University Place' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3989' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A stunning contemporary home under construction to be completed by end of November on an oversize 10,000sqft West U. lot. Pool could be added before or after closing. This amazing home is located in the heart of West University Place close to beautiful parks and great schools.Spacious plan with 12\' wood ceiling, separated kitchen and formal dining room from living room opens to large covered patio with big sliding doors and 38\" Kalamazoo K750HB grill. Huge windows for natural lights throughout the house. Mind blowing Madeval contemporary kitchen cabinets with Wolf/Subzero appliances. Home office/study room at the first floor, primary bedroom at the second floor along with other 3 rooms and game room. 16\' high 3 car garage has all CMU walls and elevator shaft. Aluminum metal flat roof has 2 rooftop terraces, one is facing backyard with the access from primary bedroom and the second is facing the street with access from guest room. Listing broker is seller and builder.' ,`Acres` = '0.2296' ,`Area` = '17' ,`BuilderName` = 'Uniform Construction' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West University/Southside Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 10 BLK 17 WEST UNIVERSITY PLACE SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '10000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WEST UNIVERSITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'West University Place Sec 01' ,`TaxAmount` = '22249' ,`TaxRate` = '2.1629' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665344162' WHERE `Matrix_Unique_ID` = '212706095' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T20:31:45.663' ,`MLSNumber` = '41696281' ,`ListAgentFullName` = 'Edlin Santana' ,`ListOfficeName` = 'Surge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.804142' ,`Longitude` = '-95.843606' ,`PhotoCount` = '50' ,`PostalCode` = '77493' ,`RoomCount` = '13' ,`ListPrice` = '829999.00' ,`Status` = 'Active' ,`StreetName` = 'Savannah' ,`StreetNumber` = '7018' ,`StreetSuffix` = 'Run' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4558' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to a beautifully designed house by Shea Homes in the Cane Island community. This beauty has a grand floor plan that features 2 stories, 5 bedrooms (2 down and 3 up), 4 full bathrooms, a 3-car garage, 20 ft high ceilings, and a large covered patio. The gourmet kitchen features an oversized 13-foot island, double oven, stainless steel appliance, walk-in pantry, and lots of cabinet space, all open to the family room with lots of natural light from the oversized windows. Private courtyard with a fireplace, spacious media room (with a wet bar), Gameroom, private home office, sprinkler system, gutters, underground drains, five-burner gas cooktop, and walk-in closets in ALL bedrooms. Let\'s not forget the amenities Cane Island offers (restaurant, 24-hour gym, playgrounds, pool, and more). Easy access to highways 10 and 99, shopping, and restaurants. Come view this beauty located in the Cane Island neighborhood.' ,`Acres` = '0.1955' ,`Area` = '25' ,`BuilderName` = 'Shea Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S422381 CANE ISLAND SECTION 21 BLK 1 LOT 41 ACRES .1955' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'French,Traditional' ,`Subdivision` = 'Cane Island Sec 21' ,`TaxAmount` = '6990' ,`TaxRate` = '3.4077' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344162' WHERE `Matrix_Unique_ID` = '212709471' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T20:35:51.173' ,`MLSNumber` = '43934379' ,`ListAgentFullName` = 'Anna Teplitskaya' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.783297' ,`Longitude` = '-95.424731' ,`PhotoCount` = '32' ,`PostalCode` = '77007' ,`RoomCount` = '10' ,`ListPrice` = '750000.00' ,`Status` = 'Active' ,`StreetName` = 'Arabelle' ,`StreetNumber` = '5723' ,`StreetSuffix` = 'Crest' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3977' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Luxury gated community in Cottage Grove. Beautifully appointed contemprorary-style executive corner unit with 4-5 bedrooms, 4 full and 1 half baths with an exquisite views of the lake. It boasts a patio, a balcony, or a terrace on each of its 4 floors. This is the only unit that has the four floors of views. Gourmet kitchen with Miele appliances, custom cabinets and a huge island that separates it from the living room. Butler\'s Pantry + delightful dining room. Hardwood floors, marble floors and high ceilings. The casual elegance of the family room features a fireplace and abundance of light. Rooftop terrace provides magnificent view of the lake below. The community features a dog park, a private pool and walking trails.\r\nThe property is close proximity to Houston Downtown and The Galleria. Convenient access to Memorial Park, Heights Biking Trail, White Oak Biking Trail, Allen Parkway, Buffalo Bayou Trail and all of the restaurants & attractions of the nearby Heights area.' ,`Acres` = '0.0545' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cottage Grove' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 2 COTTAGE GROVE SEC 8 R/P' ,`LotDesciption` = 'Other' ,`LotSize` = '2372' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2547' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '4' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Cottage Grove Sec 08 Rep 01' ,`TaxAmount` = '14346' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344162' WHERE `Matrix_Unique_ID` = '212764859' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T20:18:54.907' ,`MLSNumber` = '12795373' ,`ListAgentFullName` = 'Stephanie Luna' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = 'Savannah Dietz' ,`SellingOfficeName` = 'Simien Properties' ,`Latitude` = '29.557278' ,`Longitude` = '-95.304662' ,`PhotoCount` = '32' ,`PostalCode` = '77584' ,`RoomCount` = '4' ,`ListPrice` = '255000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Livingston' ,`StreetNumber` = '2715' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1464' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy a backyard BBQ in this roomy outdoor living space with two covered patios for entertaining and fun! As you walk through the front door of this traditional home in the established Corrigan subdivision in central Pearland, you will be led into the main living area. With a great view into the backyard, it is open to the breakfast area and tastefully updated kitchen. The primary bedroom is off the living room with a walk-in closet and new barn door into the dressing area. Down the hall from the primary bedroom, you will find two spacious secondary bedrooms with a full bath. Fresh paint throughout with a new dishwasher and disposal. Memories abound in this future home of yours!' ,`Acres` = '0.1953' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'CORRIGAN (PEARLAND), BLOCK 2, LOT 51 SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8507' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'H C CARLESTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH SOUTH' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Corrigan Pearland' ,`TaxAmount` = '3552' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344162' WHERE `Matrix_Unique_ID` = '212775817' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T21:52:00.487' ,`MLSNumber` = '10199164' ,`ListAgentFullName` = 'Tricia Turner' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.799707' ,`Longitude` = '-95.400484' ,`PhotoCount` = '50' ,`PostalCode` = '77008' ,`RoomCount` = '8' ,`ListPrice` = '850000.00' ,`Status` = 'Active' ,`StreetName` = 'Allston' ,`StreetNumber` = '1545' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2171' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nestled in the Houston Heights Historic District on a huge corner lot, is this gorgeous craftsman-style 1,312 sq ft 2 bed | 2 bath home with an 859 sq ft 1 bed | 1.5 bath separate guest house! A beautiful sunroom & formal dining room perfect for gathering with family & friends! The kitchen boasts 4 windows with stunning views of the gardens & includes a gas range/oven, plenty of storage plus a pantry. Exquisite long leaf heart of pine original hardwood floors flow through the main house & waterproof laminate. Porcelain tile in baths & original clawfoot tub. Full privacy fence with remote gate access. The 1 bed | 1.5 bath guest house has its own private street frontage entrance with a full kitchen, living area, dining room, bedroom with ensuite plus a half bath. The shared outdoor living area features a covered deck, outdoor kitchen, raised vegetable gardens, grape arbor, dartboard & firepit. Close to I-10/610. HISD! Also listed & For Sale is adjoining lot MLS # 78675025.' ,`Acres` = '0.1147' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 143 HOUSTON HEIGHTS' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Houston Heights' ,`TaxAmount` = '16725' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1920' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344162' WHERE `Matrix_Unique_ID` = '212820294' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T21:11:18.427' ,`MLSNumber` = '97840344' ,`ListAgentFullName` = 'Nicole Handy' ,`ListOfficeName` = 'Braden Real Estate Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.714640' ,`Longitude` = '-95.428055' ,`PhotoCount` = '42' ,`PostalCode` = '77005' ,`RoomCount` = '13' ,`ListPrice` = '3700000.00' ,`Status` = 'Active' ,`StreetName` = 'University' ,`StreetNumber` = '3201' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '7040' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Seize the opportunity to own the most iconic home in Houston, nestled behind breathtaking majestic oak trees on a primer 18K sqft corner lot in the heart of the prestigious West University. Internationally renowned, with over 7K sqft of spacious living, this unique design features 2 grand floating staircases with towering floor-to-ceiling windows lining the entire rear of the home. The backyard oasis is seen from every room in the home. Significant upgrades and features include a state-of-the-art lighting system, 3 new AC units, new water heater, 2 new ice makers, new dishwasher, new oven, 72\' sub zero fridge, wet bar, stunning wine room, a home study with a 360 view of the 1st floor, 4 car show garage, & security camera system. Delight on the 2nd story balcony that overlooks the brand new pool & spa. This home was built to entertain. Located minutes from the world-renowned Texas Medical Center, Rice University, Rice U Elementary, & Rice Village premier shopping and dining.' ,`Acres` = '0.4132' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West University/Southside Area' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 6A 7 & 8B BLK 21 WEST UNIVERSITY PLACE SEC 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '18000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WEST UNIVERSITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'West University Place Sec 01' ,`TaxAmount` = '66863' ,`TaxRate` = '2.0584' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344163' WHERE `Matrix_Unique_ID` = '212917104' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T21:12:31.247' ,`MLSNumber` = '54387640' ,`ListAgentFullName` = 'Charlie Neath' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.749620' ,`Longitude` = '-95.503553' ,`PhotoCount` = '25' ,`PostalCode` = '77063' ,`RoomCount` = '8' ,`ListPrice` = '1150000.00' ,`Status` = 'Active' ,`StreetName` = 'Woodway' ,`StreetNumber` = '7702' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2997' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'No showings until Open House on Sunday, October 9th, 2-4pm.\r\nWell cared for and updated modern ranch-style home in Charnwood sits on beautiful 27,300 square foot ravine lot. Three bedrooms and 3.5 baths with stunning views of green space from almost every room in the home. City living with an outdoor feel, this extensively remodeled home has undergone transformation both in and out. Ebony stained hardwood floors, kitchen island with Caesarstone Oyster Quartz counter, gas range, Sub Zero fridge, Bosch double ovens (2020), walk-in pantry, and ample lighting. Master bedroom is open and airy with large windows, cathedral ceilings, Thibaut wallpaper and two Space-Man designed walk-in closets. Built-in basketball hoop, tree house, automatic gate, and two car garage. Neighborhood patrol and private trash pick-up two days a week. Conveniently located near The Kinkaid School, St. Francis, St. Martin\'s, Trader Joe\'s, Kroger, and Whole Foods. This home DID NOT flood. (per Seller)' ,`Acres` = '0.6267' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Charnwood/Briarbend' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 4 CHARNWOOD' ,`LotDesciption` = 'Ravine,Subdivision Lot' ,`LotSize` = '27300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Charnwood' ,`TaxAmount` = '19947' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344163' WHERE `Matrix_Unique_ID` = '212927508' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T21:01:09.380' ,`MLSNumber` = '13379443' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.927779' ,`Longitude` = '-95.732800' ,`PhotoCount` = '50' ,`PostalCode` = '77433' ,`RoomCount` = '8' ,`ListPrice` = '663000.00' ,`Status` = 'Active' ,`StreetName` = 'Keepers Dwelling' ,`StreetNumber` = '18711' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3100' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fulfill your lifestyle ambitions in the vibrant and innovative Milburn home plan. The Jack-and-Jill bedrooms and a separate front bedroom offer plenty of personal space for your growing residents and overnight guests. A quiet media room and front study present unparalleled opportunities to craft the family movie theater and home office you’ve been dreaming of. The streamlined kitchen provides an easy culinary layout for the resident chef with an extended pantry and prep area and a delightful view of the sunny family and dining spaces. Spend quality time together in the shade of your covered patio. Your blissful Owner’s Retreat offers an everyday escape from the outside world, and includes a spa-inspired en suite bathroom and a luxury walk-in closet.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Block 1' ,`LotDesciption` = 'Cul-De-Sac,Other,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1284' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MCGOWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.68' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665344163' WHERE `Matrix_Unique_ID` = '212946573' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T20:07:28.827' ,`MLSNumber` = '45528882' ,`ListAgentFullName` = 'Anthonio Sardinea' ,`ListOfficeName` = 'JPAR-The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.514993' ,`Longitude` = '-95.439557' ,`PhotoCount` = '32' ,`PostalCode` = '77583' ,`RoomCount` = '7' ,`ListPrice` = '359900.00' ,`Status` = 'Active' ,`StreetName` = 'Birchwood Bluff' ,`StreetNumber` = '4948' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1991' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**No Showings until After Open House this Saturday and Sunday from 12pm-4pm (October 8 & 9)**Welcome to This beautiful, one-story, open concept 3-bedroom, 2 bathroom Home! This Home features, a large kitchen island, plenty of cabinet & pantry storage, crown modeling throughout, elevated ceilings and neutral tones complemented by an abundance of natural light. The home lends beautifully to entertaining family and friends with a spacious backyard with covered patio and large kitchen which is open to the spacious family and dining room. The en-suite Owner\'s Retreat boasts a large walk-in closet, double sinks and a stunning massive walk in Shower. The Home sits just steps away from beautiful scenic lakes and area walking trails. Community amenities include a recreation center with swimming pool & exercise area and playground areas throughout. Zoned for highly desired area schools. Conveniently located to Hwy 288 & nearby shopping centers. Don\'t miss out on this must-see opportunity!' ,`Acres` = '0.1738' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'STEWART HEIGHTS SEC 11 (A0403 & A0625) BLK 1 LOT 3' ,`LotDesciption` = 'Other' ,`LotSize` = '7571' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'SAVANNAH LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Stewart Hts/Savannah Sec 11' ,`TaxAmount` = '9117' ,`TaxRate` = '3.3694' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344163' WHERE `Matrix_Unique_ID` = '212987227' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T20:14:01.300' ,`MLSNumber` = '13864133' ,`ListAgentFullName` = 'Jean-Marc Bassil' ,`ListOfficeName` = 'Prime Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.795261' ,`Longitude` = '-95.701268' ,`PhotoCount` = '19' ,`PostalCode` = '77084' ,`RoomCount` = '10' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Park Harbor Estates' ,`StreetNumber` = '1719' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3059' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Adorable 2 story 3-bedroom home built on red bricks in the lovely neighborhood of Lakeside Estates. Freshly painted, remodeled bathrooms, upgraded kitchen, wood and tile flooring throughout. The backyard is spacious with room for kids to play - features rope swing, fruit trees, and a new cedar board raised garden and cattle panel trellises! Perfect for all the urban gardener! Roof replaced in 2016. Attic foam insulation upgrade. Stainless steel appliances added and stay with the house. Water Heater replaced in 2020. New Back Fence 2021. Big backyard and very spacious. Excellent location! Conveniently located near Barker Cypress Road for easy access to I10. Katy Mall, Texas Childrens, shopping, dining and Energy Corridor just minutes away. PROPERTY NEVER FLOODED. Make your appointment today!' ,`Acres` = '0.1865' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 2 PARK HARBOR ESTATES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8125' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '333' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MAYDE CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MAYDE CREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Park Harbor Estates' ,`TaxAmount` = '6519' ,`TaxRate` = '2.4889' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344163' WHERE `Matrix_Unique_ID` = '213005940' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T21:22:43.370' ,`MLSNumber` = '5348641' ,`ListAgentFullName` = 'Thuraya Mayet' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.875635' ,`Longitude` = '-95.740864' ,`PhotoCount` = '35' ,`PostalCode` = '77449' ,`RoomCount` = '6' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Scarlet Sagebrush' ,`StreetNumber` = '6842' ,`StreetSuffix` = 'Street' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1448' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this beautiful 1 story home in the new and fast growing community of Lantana (click on the video). This beautiful, cozy home is move-in ready. It offers 3 bedrooms, 2 baths and a large family room open to the kitchen and dining area, making it perfect for entertaining. The primary suite boasts plenty of natural light, a large walk-in shower and a spacious walk-in closet. This is a smart home fully equipped with the latest smart home systems and includes a Fridge, Washer and Dryer. This home also has a nice size private backyard along with a sprinkler system. It is an ideal starter home in a wonderful community. It is surrounded by many upcoming grocery/retail stores and restaurants. Exiting the community is the highly ranked Cypress Park High School. The community has a park, trails, splash pad, and picnic area. This community has a direct access to the Grand Parkway. Contact me directly for private showing or schedule a time on-line.' ,`Acres` = '0.1148' ,`Area` = '25' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 2 LANTANA SEC 4' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WALKER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lantana' ,`TaxAmount` = '5738' ,`TaxRate` = '2.831' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665344164' WHERE `Matrix_Unique_ID` = '213043782' --> 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','213047684','1665344164','213047684','2022-10-08T21:58:29.983','66237702','Claudia Oakley','Keller Williams Professionals','','','31.194020','-94.714375','48','75941','7','785000.00','Active','Old Burke','3540','Road','Diboll','3','0','3','2432','Single-Family','Welcome to this one of kind, custom built country home on 6 acres! You are welcomed through the gated private drive where you will find main residence with over 2,750 sq. ft. This home has been completely renovated! Spacious gourmet kitchen with a 9.5 ft. custom made butcher block island, top of the line stainless appliances including a Kutch professional gas oven, Dekon countertops, farm sink, and large pantry. Laundry room with farm sink and cedar lined storage room/second pantry. Formal dining and private office with french pocket doors. The oversized family room with floor to ceiling windows is the perfect place to relax & enjoy views of the immaculately maintained backyard w/covered patio! 3 car garage with second story unfinished apartment or extra storage. Adjacent to the main house you will find a fully equipped cottage style guest house w/private drive. Underground wiring to all 3 locations. 4,000 sq.ft. shop, well house and a chicken house! Low utilities. \r\nA must see!!!','5.99','45','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Angelina County','Propane','0','ABS 0031 MORIN J.,TRACT 1.1.1,ACRES 5.99','Wooded','260924','Appraisal District','','','0','','3','Gas Oven','0','','','Gas Range','','Composition','266 - Diboll','TEMPLE ELEMENTARY SCHOOL','DIBOLL HIGH SCHOOL','DIBOLL JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox','Appraisal District','1','Ranch','ABS 0031 MORIN J.,TRACT 1.1.1,ACRES 5.99','5945','1.8119','Septic Tank','1993','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T20:41:24.197' ,`MLSNumber` = '98716796' ,`ListAgentFullName` = 'Zuri Perez-Majul' ,`ListOfficeName` = 'Zuri Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.949039' ,`Longitude` = '-95.721394' ,`PhotoCount` = '39' ,`PostalCode` = '77433' ,`RoomCount` = '12' ,`ListPrice` = '589000.00' ,`Status` = 'Active' ,`StreetName` = 'Williams Elm' ,`StreetNumber` = '18147' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3764' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful traditional home nestled in the sought after master planned community of Bridgeland. This lovely 5 bedroom home offers a sparkling pool and spa with no back neighbors! High ceilings and gorgeous glass raindrop chandelier welcomes you as you step inside the foyer. Study to your left with French doors is perfect for working from home. Formal dining room for all your holiday dinners. Kitchen has updated shaker style white cabinets, granite countertops, double ovens, gas cooktop and large island. Open and desirable floor plan w high ceilings in the family room, cozy gas fireplace and views of your blue lagoon. Large primary suite w sitting area, access to the pool area and an en-suite bathroom. Primary bath features dual sinks, separate shower and jetted tub. Upstairs you\'ll find a game room, theatre and 4 additional spacious bedrooms plus two full bathrooms. No back neighbors as home backs up to a greenbelt, No carpet, luxury vinyl floors throughout and tile in the bathrooms.' ,`Acres` = '0.1801' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 1 FIRST BEND SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7845' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1197' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MCGOWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '12181' ,`TaxRate` = '3.4329' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344164' WHERE `Matrix_Unique_ID` = '213072430' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T21:17:27.363' ,`MLSNumber` = '62926354' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.209379' ,`Longitude` = '-95.750782' ,`PhotoCount` = '45' ,`PostalCode` = '77354' ,`RoomCount` = '9' ,`ListPrice` = '364047.00' ,`Status` = 'Active' ,`StreetName` = 'Quail Valley' ,`StreetNumber` = '42434' ,`StreetSuffix` = 'Lane' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2552' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW DAVID WEEKLEY HOME! Guaranteed heating and cooling usage for three years with our Environments for Living program! Breathtaking luxury and enchanting comforts make The Brinwood a once-in-a-lifetime family home plan. Craft your ideal specialty rooms in the sensational versatility of the downstairs study and the upstairs retreat. Each spare bedroom offers a walk-in closet and plenty of room for personal growth and decorative style. Your cheerful open floor plan is the perfect place for daily life and hosting unforgettable celebrations. The glamorous kitchen features a full-function island, a walk in pantry, and an abundance of cabinets and countertops. Your awe-inspiring Owner’s Retreat provides a serene way to begin and end each day with a modern bathroom and a wardrobe-expanding walk-in closet. Bonus features include a downstairs powder room and extra storage spaces. Build your future with the peace of mind that Our Industry-leading Warranty brings to this new home plan.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 25 Block 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Magnolia Escondido' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665344164' WHERE `Matrix_Unique_ID` = '213127357' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T20:52:00.390' ,`MLSNumber` = '78207737' ,`ListAgentFullName` = 'Yesenia Guerra' ,`ListOfficeName` = 'CJM Realty Advisors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.663536' ,`Longitude` = '-95.358175' ,`PhotoCount` = '20' ,`PostalCode` = '77051' ,`RoomCount` = '5' ,`ListPrice` = '379900.00' ,`Status` = 'Active' ,`StreetName` = 'Brinkley' ,`StreetNumber` = '4609A' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2304' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '46059A Brinkley is a gem in the heart of Houston, this home is located close to the Medical Center, Downtown Houston and many major highways. The Builder spared no expense and paid great attention to detail when creating this 3 bedroom 2.5 bath Estate! Woodlike flooring, granite counter tops in kitchen and bathrooms, large kitchen island, stainless steel appliances, stand alone bathtub in master, large walk-in closets with built-in shelves; the list goes on and on! A MUST SEE!!!' ,`Acres` = '' ,`Area` = '3' ,`BuilderName` = 'TEAM HBC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 2 BLK 1 BRINKLEY SPRINGS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4048' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BASTIAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Mediterranean,Other Style,Traditional' ,`Subdivision` = 'Brinkley Springs' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665344164' WHERE `Matrix_Unique_ID` = '213161948' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T20:38:52.147' ,`MLSNumber` = '78989908' ,`ListAgentFullName` = 'Dao Vo' ,`ListOfficeName` = 'Intercontinental Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.228092' ,`Longitude` = '-95.242473' ,`PhotoCount` = '0' ,`PostalCode` = '77357' ,`RoomCount` = '6' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Paddock Point' ,`StreetNumber` = '15038' ,`StreetSuffix` = 'Lane' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1383' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S573303 - HARRINGTON TRAILS 03, BLOCK 1, LOT 29' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6025' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'TIMBER LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harrington Trails 03' ,`TaxAmount` = '663' ,`TaxRate` = '2.0783' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665344164' WHERE `Matrix_Unique_ID` = '213188429' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T20:07:01.183' ,`MLSNumber` = '41822208' ,`ListAgentFullName` = 'Kayla Beamon' ,`ListOfficeName` = 'Legacy Homes & Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.509924' ,`Longitude` = '-95.407561' ,`PhotoCount` = '24' ,`PostalCode` = '77578' ,`RoomCount` = '1' ,`ListPrice` = '310000.00' ,`Status` = 'Active' ,`StreetName` = 'Garden Grove' ,`StreetNumber` = '39' ,`StreetSuffix` = 'Drive' ,`City` = 'Manvel' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2151' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A beautiful community in Manvel, Texas, Rodeo Palms Master Planned community will redefine luxurious lakeside living. Rodeo Palms has several sparkling lakes and pocket parks throughout along with a family friendly pool area. This charming home includes large kitchen with NEW CABINETRY and 5 range stove top, open natural lighting, cozy breakfast area and formal dining room. This lovely home has New Carpet, New Flooring, OVER SIZED PRIMARY and HUGE walk-in closet! Home is Perfectly Chic for the new home buyer! Beautiful one story home has been freshly painted and has NO BACKYARD NEIGHBORS! Only 10 minutes to Pearland Town Center and Downtown! Accepting all offers, schedule your showing today!' ,`Acres` = '0.1214' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'RODEO PALMS THE COLONY SEC 1 (A0299 HT&BRR)(MANVEL) BLK 4 LO' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5288' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'DON JETER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Rodeo Palms, The Colony Sec 1' ,`TaxAmount` = '8899' ,`TaxRate` = '3.6694' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344165' WHERE `Matrix_Unique_ID` = '213197340' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T20:07:16.860' ,`MLSNumber` = '64086664' ,`ListAgentFullName` = 'Ryan Jockers' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.113228' ,`Longitude` = '-95.509162' ,`PhotoCount` = '38' ,`PostalCode` = '77389' ,`RoomCount` = '10' ,`ListPrice` = '570000.00' ,`Status` = 'Active' ,`StreetName` = 'Willow Rose' ,`StreetNumber` = '24110' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3238' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Now is your opportunity to own this beautiful NEW CONSTRUCTION home in the distinctive GATED community of Inway Oak Estates, & zoned to the acclaimed Klein schools! Enjoy this thoughtfully designed modern masterpiece, featuring a gorgeous brick & stone exterior, lovely open floor plan, high ceilings, covered patio, large windows, tons of natural light, wrought iron banister, large doors, quartz counter tops, gorgeous wood-look tile floors, modern color palettes, sleek light fixtures, & spacious family room with beautiful stone fireplace. The modern kitchen features quartz countertops, large island, breakfast bar, farmhouse sink, modern tile backsplash, & stainless steel appliances. This exquisite home also features a spacious primary suite with bay window, huge walk-in closet, & lovely primary bath, w/ separate shower & free-standing tub. Inway Oaks Estates amenities include a community pool, recreation center, & fitness center. Close proximity to 99, 45, & the Hardy Toll road.' ,`Acres` = '0.161' ,`Area` = '14' ,`BuilderName` = 'J&D Homes LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 1 INWAY OAKS ESTATES SEC 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7012' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '766' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'NORTHAMPTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HILDEBRANDT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Inway Oaks Estates' ,`TaxAmount` = '1788' ,`TaxRate` = '2.664' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665344165' WHERE `Matrix_Unique_ID` = '213221216' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T20:00:11.950' ,`MLSNumber` = '85917112' ,`ListAgentFullName` = 'Becky Cornelius' ,`ListOfficeName` = 'Pat Griffin Realty ' ,`SellingAgentFullName` = 'Elissa Campbell' ,`SellingOfficeName` = 'Lucid Realty, LLC' ,`Latitude` = '29.545042' ,`Longitude` = '-95.260043' ,`PhotoCount` = '50' ,`PostalCode` = '77581' ,`RoomCount` = '12' ,`ListPrice` = '690000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Redwood Grove' ,`StreetNumber` = '3302' ,`StreetSuffix` = 'Street' ,`City` = 'Pearland' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4035' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you are looking for a beautiful home with everything, Here it is! Spacious Rotunda entry, formal dining turned parlor area, bar with quartz counter and back quartz display, formal dining, 16X 17 kitchen with breakfast area, gas cooking, butler counter, nest thermostats, gameroom and media room, screen and media seating negotiable, pool table negotiable, den fireplace with glass rocks, gas starter, 3 car garage with 10 foot extension, beautiful covered patio in addition to freestanding fireplace ( can be wood or gas), Evo grill, sink, mini bar and sit up bar all in this outdoor kitchen, large gunite pool resurfaced 4 years ago with hot tub, bubblers, waterfall, sprayers, no back neighbors, full house generator including garage and pool, sprinkler system, downstairs office or study, basketball court, full bath in garage, lift in garage, lots of outdoor recessed lighting. Microwave doubles as convection oven. NEVER FLOODED!' ,`Acres` = '0.4899' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'THE VILLAGES AT MARY\'S CREEK SEC 1 PH 2 (A0070 W D C HALL) P' ,`LotDesciption` = 'Cleared,Greenbelt' ,`LotSize` = '21340' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'SHADYCREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH EAST' ,`ShowInstructions` = 'Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Villages At Marys Creek S' ,`TaxAmount` = '14772' ,`TaxRate` = '2.8451' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344165' WHERE `Matrix_Unique_ID` = '213242163' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T20:23:14.393' ,`MLSNumber` = '40020983' ,`ListAgentFullName` = 'Cecilia Cardenas' ,`ListOfficeName` = 'RE/MAX Grand' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.852355' ,`Longitude` = '-95.220914' ,`PhotoCount` = '29' ,`PostalCode` = '77044' ,`RoomCount` = '6' ,`ListPrice` = '169500.00' ,`Status` = 'Active' ,`StreetName` = 'Drifting Winds' ,`StreetNumber` = '12006' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '1890' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 MOBILE HOMES IN ONE. ONE HAS 3 BEDROOMS 2 BATHS, AND THE OTHER ONE HAS 1 BEDROOM ONE BATH\r\nRECENTLY REMODELED. LAMINATED WOOD, FRESH PAITING, MICROWAVE, AND MORE' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LTS 1 & 2 BLK 4 PARKWAY SEC 1 R/P' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '115' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'MONAHAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'C.E. KING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkway Sec 01 R/P' ,`TaxAmount` = '1286' ,`TaxRate` = '3.0293' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1665344165' WHERE `Matrix_Unique_ID` = '213245131' --> 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','213266031','1665344165','213266031','2022-10-08T21:40:19.150','27030613','Brandi Bryant','JLA Realty','','','30.089212','-94.862091','46','77535','9','750000.00','Active','Fm 1008','2555','','Dayton','2','0','3','2240','Single-Family','','5.01','52','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Mock Fireplace','1','Dayton','Propane','0','WHITE OAK TRAILS, SEC 1, LOT 7, ACRES 5.01','Wooded','218236','Appraisal District','','350','0','','2','','0','','','Gas Cooktop,Gas Range','','Composition','74 - Dayton','RICHTER ELEMENTARY SCHOOL','DAYTON HIGH SCHOOL','WOODROW WILSON JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','1','Traditional','White Oak Trails','9708','1.7512','Aerobic','2019','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T20:45:23.267' ,`MLSNumber` = '52118625' ,`ListAgentFullName` = 'Candice DeLeon' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.830158' ,`Longitude` = '-95.467858' ,`PhotoCount` = '30' ,`PostalCode` = '77092' ,`RoomCount` = '7' ,`ListPrice` = '280000.00' ,`Status` = 'Active' ,`StreetName` = 'Georgi' ,`StreetNumber` = '5126' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1522' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '5126 Georgi is an original home in the charming neighborhood of Mangum Manor, located adjacent to the fast growing neighborhood of Oak Forest. This 3 bedroom 1.5 bath home is just waiting for someone to come in and make it their own! It was lovingly cared for by the second owner who purchased the home in 1968! The sewer line has been updated and the original parquet wood floors can be found in the living room and bedrooms. The utility room is located inside which is rare for a home in this neighborhood! Outside you will find a covered patio leading to a spacious and peaceful yard. There is so much potential here! The home has never flooded, and is within walking distance to the neighborhood park where there are tennis courts, a playground and walking path. You will also be close to many new restaurants, shopping and bars. Easy access to hwy 290 and 610 make it convenient to commute to work! Don\'t miss your chance to get into this great neighborhood!!' ,`Acres` = '0.1465' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 11 & TR 12A BLK 1 MANGUM MANOR SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6380' ,`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` = 'WAINWRIGHT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Mangum Manor Sec 03' ,`TaxAmount` = '5644' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344165' WHERE `Matrix_Unique_ID` = '213290597' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T20:41:58.220' ,`MLSNumber` = '38365123' ,`ListAgentFullName` = 'Gretchen Pattillo' ,`ListOfficeName` = 'NextHome Realty Center' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.040219' ,`Longitude` = '-95.586730' ,`PhotoCount` = '25' ,`PostalCode` = '77375' ,`RoomCount` = '8' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Kingsnorth' ,`StreetNumber` = '11111' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1914' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this beautifully maintained home in the quiet neighborhood of Ashford Place. It features an open floor plan great for entertaining. Granite countertops, black GE appliances, and a huge island appoint this kitchen with an over-sized eat in area. Primary bedroom offers a large walk in closet with custom shelving. Upstairs is a gameroom and second full bathroom. All 3 secondary bedrooms also have walk-in closets for much needed storage! Move-in ready condition. Come check out this beautiful space and make it your NextHome!' ,`Acres` = '0.1402' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 3 ASHFORD PLACE SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6107' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BLACKSHEAR ELEMENTARY SCHOOL (KLEIN)' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'ULRICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ashford Place Sec 4' ,`TaxAmount` = '6071' ,`TaxRate` = '2.7066' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344166' WHERE `Matrix_Unique_ID` = '213290993' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T21:07:08.457' ,`MLSNumber` = '61594696' ,`ListAgentFullName` = 'Stephanie Childress' ,`ListOfficeName` = 'Rockin 4C Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.401778' ,`Longitude` = '-94.909354' ,`PhotoCount` = '35' ,`PostalCode` = '77590' ,`RoomCount` = '5' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = '18th' ,`StreetNumber` = '1013' ,`StreetSuffix` = 'Avenue' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1932' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home, Open spacious floor plan ready for all the entertaining. Large open kitchen has plenty of space for the chef in the family and open to the living area, Primary bedroom is a great space to relax with the ensuite bathroom and double sinks. Huge Backyard with an above ground pool and covered patio. Home has been well cared for and shows pride of ownership. New Solar Screens and freshly painted on the outside. Underground plumbing has been redone, front half of roof has been replaced with ice and water barrier, French drain in back yard, NO Flooding! Make your appt today!' ,`Acres` = '0.2497' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 167 PAGE 5 LOT 8 BLK 32 MAINLAND PARK SEC A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10875' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'ROOSEVELT-WILSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TEXAS CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BLOCKER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mainland Park' ,`TaxAmount` = '4914' ,`TaxRate` = '2.5335' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344166' WHERE `Matrix_Unique_ID` = '213300027' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T20:07:01.183' ,`MLSNumber` = '33180797' ,`ListAgentFullName` = 'Christopher Case' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.838744' ,`Longitude` = '-95.478756' ,`PhotoCount` = '33' ,`PostalCode` = '77092' ,`RoomCount` = '3' ,`ListPrice` = '359900.00' ,`Status` = 'Active' ,`StreetName` = 'Hoover' ,`StreetNumber` = '6011' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1481' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! 3 Bedroom / 2 full bath / 2 car garage home located in the sought after neighborhood of Forest Pines. This newly renovated home features nice white kitchen cabinetry and a stove, with sizeable counter space. This beautiful home has luxury vinyl laminate flooring and fresh paint thru-out. A spacious master suite and fully updated bathrooms that include new showers & courtz countertops. Enjoy the large back patio and green space, which is perfect for entertaining. Located minutes to the major roads like Highway 290, 610, and Beltway 8. Excellent location- close to The Galleria, Spring Branch and Memorial Park makes for an easy commute. Move in ready- schedule your showing today!' ,`Acres` = '0.1567' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 17 FOREST PINES SEC 2A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6825' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WAINWRIGHT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Forest Pines Sec 02a' ,`TaxAmount` = '5652' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344166' WHERE `Matrix_Unique_ID` = '213302918' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T20:20:49.673' ,`MLSNumber` = '66948036' ,`ListAgentFullName` = 'Sonya Nelson' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.803785' ,`Longitude` = '-95.839443' ,`PhotoCount` = '38' ,`PostalCode` = '77493' ,`RoomCount` = '9' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Banyon Gulch' ,`StreetNumber` = '2543' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3419' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Breathtaking 1.5 story Lennar home with 3 car over-sized garage. The exterior showcases the well manicured lawn and beautiful wrought iron entry door. This 4 bedroom home boasts elegance; from the arched entries, crystal chandeliers, and spiraled ironed staircase, no details were spared. Upon entering, you will fall in love with the separate in-law-suite; private en suite, kitchenette and full bath. The primary living and kitchen features an open floor plan with an abundance of windows and natural sunlight. Massive island and chef\'s kitchen w/double ovens and gas cook top is the perfect space for entertaining. Two additional bedrooms down, including large master retreat with recess lighting. His & Her vanities in master bath with separate bath and shower. Bedroom, game-room and full bath on 2nd story. Home sits on oversized lot, more than 1/2 ace. This backyard is your canvas! Home is conveniently located near shopping markets and restaurants. View this stunning home today!' ,`Acres` = '0.5236' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S474812 FALLS AT GREEN MEADOWS SECTION 7 BLK 1 LOT 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '22808' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'KATY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Falls at Green Meadows' ,`TaxAmount` = '14527' ,`TaxRate` = '3.4277' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344166' WHERE `Matrix_Unique_ID` = '213307828' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T20:18:45.843' ,`MLSNumber` = '68720709' ,`ListAgentFullName` = 'Renee Leslie-Buckhoff' ,`ListOfficeName` = 'RE/MAX Elite Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.975278' ,`Longitude` = '-95.542672' ,`PhotoCount` = '48' ,`PostalCode` = '77069' ,`RoomCount` = '14' ,`ListPrice` = '625000.00' ,`Status` = 'Active' ,`StreetName` = 'Vintage Centre' ,`StreetNumber` = '13715' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '4251' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the Oasis of your dreams. This home is the definition of AMAZING. This FANTASTIC Custom built Home in an Exclusive Gated Community of only 33 homes. Lot size is a plus in this community! The outdoor kitchen has a wood burning firepit, also an outdoor shower, this is exactly how to end a long day. This home includes a private Study/Office, Primary is located downstairs with access to the patio, 14\' ceilings and a built in bench. Additional bedrooms are upstairs, 2 with their own bathrooms. This home also includes a Bonus room upstairs that could be used as a craft room, wine room, or a small office for the kiddos. The open floor concept allows for great entertainment with the kitchen looking into the living room, drop station is off the kitchen. This home also has an additional living space that could be used for many different options. This home has all the bells and whistles, not to mention 3 AC units. ITS A MUST SEE. LUXURY LIVING AT ITS FINEST!!' ,`Acres` = '0.338' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 1 CHAMPIONS CENTRE MIRAGE' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '14725' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,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,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Champions Centre Mirage' ,`TaxAmount` = '12868' ,`TaxRate` = '2.4106' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344166' WHERE `Matrix_Unique_ID` = '213341861' --> 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','213376596','1665344167','213376596','2022-10-08T20:13:32.207','36532619','Tamarah Curtis','Creighton Realty Partners, LLC','','','30.202757','-95.518535','36','77381','6','675000.00','Active','Summer Cloud','95','Drive','The Woodlands','3','1','4','3310','Single-Family','','0.3328','15','','','Washer Connections','','Sellers Disclosure','1','Freestanding','1','The Woodlands','Central Gas','0','WDLNDS VIL COCHRANS CR 28, BLOCK 5, LOT 7','Cul-De-Sac','14496','Appraisal District','','','0','','3','','1','In Ground','','','','Composition','11 - Conroe','GALATAS ELEMENTARY SCHOOL','THE WOODLANDS HIGH SCHOOL','MCCULLOUGH JUNIOR HIGH SCHOOL','Accompany','Appraisal','2','Traditional','Wdlnds Village Cochrans Cr 28','9896','2.0869','Water District','1992','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T20:13:07.263' ,`MLSNumber` = '56258812' ,`ListAgentFullName` = 'Brandi Brantner' ,`ListOfficeName` = 'RE/MAX Integrity' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.981211' ,`Longitude` = '-95.576516' ,`PhotoCount` = '41' ,`PostalCode` = '77070' ,`RoomCount` = '4' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Cypress Forest' ,`StreetNumber` = '14119' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1709' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Hurry! This is your chance to have almost a 1/2 acre to run and play! This 1 story, 4 bedroom, 2 bath home is ready for its next owners. This home has been remodeled and includes luxury vinyl plank flooring, stone countertops and backsplash, updated cabinets, almost all new windows and more! Don\'t miss your chance to tour this adorable home and huge lot!' ,`Acres` = '0.3903' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 2 CYPRESS FOREST SEC 2 U/R' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '17000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MOORE ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Cypress Forest Sec 02 U/R' ,`TaxAmount` = '4613' ,`TaxRate` = '2.1637' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344167' WHERE `Matrix_Unique_ID` = '213389841' --> 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','213402656','1665344167','213402656','2022-10-08T21:02:13.247','98889271','Dolores Quiroga','Prime Realty Group','','','29.670308','-95.339404','35','77033','6','279900.00','Active','Sharondale','7818','Drive','Houston','2','0','4','1779','Single-Family','Centrally located near 610 loop, 288 Medical Center, and Downtown for quick commute. Never lived-in new construction. Spacious 4 bedroom 2 full bath. Gas stove included. Breathtaking breakfast bar/granite countertop designed for entertaining. Super clean, modern archways. Pristine stand up tiled and glass slide door showers. Move-in ready. Gated wrought iron fence in front and privacy wood panel fence lines the rear. Oversized yard large enough to host parties or get togethers. Features a rear sun porch that is barbecue ready. Manicured lawn boasts picturesque landscaping. Call your agent to book a tour today!','0.1791','3','Seller','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','','','','Medical Center South','Central Gas','0','LT 5 BLK 1 EDGEWOOD SEC 1','Subdivision Lot','7800','Appraisal District','','','1','Never Lived In','0','Gas Oven','0','','','Gas Range','','Composition','27 - Houston','ALCOTT ELEMENTARY SCHOOL','WORTHING HIGH SCHOOL','ATTUCKS MIDDLE SCHOOL','Lockbox Right Side,Request Online Appointment','Seller','1','Traditional','Edgewood Sec 01','3564','2.3307','Public Sewer,Public Water','2019','Seller'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T20:12:37.500' ,`MLSNumber` = '9668554' ,`ListAgentFullName` = 'Meggan Flanagan' ,`ListOfficeName` = 'TADA Homes, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.567997' ,`Longitude` = '-95.105858' ,`PhotoCount` = '34' ,`PostalCode` = '77058' ,`RoomCount` = '9' ,`ListPrice` = '239900.00' ,`Status` = 'Active' ,`StreetName` = 'Sunlight Way' ,`StreetNumber` = '16614' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1458' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This lovely well maintained 3 bedroom patio home is ready to be your new home! When you enter the gate you are greeted with a Zen-like spa feel as you listen to the relaxing water fountain. Go inside to see a large breakfast room which could also be used as a dining room that opens to the kitchen with granite countertops. Cook while you watch favorite shows with the articulating TV mount. Enjoy family time in the vaulted ceiling living room with custom built in shelving. The primary bedroom has large walk in closet and en-suite master bathroom. Enjoy a relaxing bath in the jetted garden tub. The outdoor area is a tropical paradise and easily maintained. Entertain on the patio, utilizing the pass through bar area to the kitchen. The garage has a workbend and storage area including a ceiling mounted storage rack. BOSE surround sound stays. AC is 5 years old. Great location with close access to NASA and medical centers. Make an offer today! Buyer verify information.' ,`Acres` = '0.1607' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 58 BLK 3 UNIVERSITY GREEN SEC 2 R/P' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '790' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'FALCON PASS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'University Green Sec 02 R/P' ,`TaxAmount` = '5005' ,`TaxRate` = '2.5769' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344167' WHERE `Matrix_Unique_ID` = '213404012' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T21:38:18.410' ,`MLSNumber` = '35424504' ,`ListAgentFullName` = 'Kayin Lawrence' ,`ListOfficeName` = 'Exit Realty 360' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.930057' ,`Longitude` = '-95.484674' ,`PhotoCount` = '0' ,`PostalCode` = '77086' ,`RoomCount` = '9' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Sandswept' ,`StreetNumber` = '6626' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2241' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This loving renovated home is located in the family friendly Northwest Park subdivision near Beltway 8. This property has vaulted ceiling with huge new windows throughout. The kitchen has plenty of space with new soft close cabinet, granite, tile backlash and new appliances. Utility room is equipped with brand new hot water heater. The new vinyl flooring and tile throughout along with fresh interior paint gives off that new home vibe. This property offers patio/backyard for entertaining. We have upgraded all light fixtures with cozy wood burning fireplace for the family. PVC piping replaced just minutes away from highways, schools and shopping. Don\'t wait, call now for showing!' ,`Acres` = '0.1591' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 36 NORTHWEST PARK SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6930' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '380' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CARMICHAEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAVIS HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'SHOTWELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Northwest Park Sec 04' ,`TaxAmount` = '3747' ,`TaxRate` = '2.4283' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344167' WHERE `Matrix_Unique_ID` = '213417342' --> 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','213449283','1665344167','213449283','2022-10-08T20:25:52.683','48963084','Lynette Lew','BHGRE Gary Greene','','','29.862817','-95.589008','49','77041','16','680000.00','Active','Indigo Cove','12015','Lane','Houston','3','1','4','4505','Single-Family','Resort-style living without the long commute! This 4-bedroom executive home has sought-after entertainment spaces with a game room, media room, card room and even a hidden bonus room! The first floor has warm hardwood and stone flooring including the stately study located off the grand two story entry. Your dining, breakfast and family rooms are perfect for gatherings; plus the kitchen has abundant storage and a deep, walk-in pantry. The decadent primary suite includes a sitting area with serene views of the sweeping backyard. The spacious primary bathroom features dual vanities and a makeup station plus a cabinet that opens to the laundry room for easy access. Two is the magic number with dual closets and dual shower heads in the massive shower. Upstairs includes the entertainment space plus a desk area, laundry chute and that fun hidden room. The backyard is pool-sized too! LOEN is a manned, gated community with bus service available to Awty, The Village School and BISH.','0.2222','8','Trendmaker','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Corporate Listing,Mud,Other Disclosures,Seller may be subject to foreign tax and Buyer withholding per IRS,Sellers Disclosure,Special Addendum','1','Gaslog Fireplace','1','Eldridge North','Central Gas,Zoned','1','LT 35 BLK 1 LAKES ON ELDRIDGE NORTH SEC 17','Cul-De-Sac,Subdivision Lot','9677','Appraisal District','','1854','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','13 - Cypress-Fairbanks','KIRK ELEMENTARY SCHOOL','CYPRESS RIDGE HIGH SCHOOL','TRUITT MIDDLE SCHOOL','Appointment Required,Controlled Access,Lockbox Front,Request Online Appointment,Supra Keybox','Appraisal','2','Traditional','Lakes on Eldridge North','12595','2.431','Public Sewer,Public Water,Water District','2005','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213465974','1665344167','213465974','2022-10-08T20:18:17.560','20625606','Brionna Pickens','eXp Realty, LLC','','','29.710863','-95.747580','34','77450','8','389000.00','Active','Marble Hollow','6118','Lane','Katy','2','1','4','2798','Single-Family','** NEW LANDSCAPING IN FRONT YARD!! BACKYARD FENCE FIXING!!! ** Move in Ready! New Paint & New Carpet ! New High Voltage Microwave! Zoned to top rated Katy ISD schools and award winning Seven Lakes High School! Open & bright renovated home with master bedroom downstairs and large game room with 3 bedrooms upstairs! Alot of natural light, and high ceilings! Family room opens to the kitchen & breakfast area. Foyer in home; great energy; stair case facing away from doorway! Spacious Patio leading to Spacious backyard! Floor plan is perfect for entertaining guests and spending time with your family. Excellent Katy ISD schools. Located in the master planned subdivision Grand Lakes which has lakes, playgrounds, pools, splash pad, tennis courts, jogging paths! Walk to the nearby Barn Park.Kitchen with Brand New Microwave. A Must See!','0.2355','36','','','','','Mud,Sellers Disclosure','1','','2','Katy - Southeast','Central Gas','1','GRAND LAKES PHASE THREE SEC 9, BLOCK 2, LOT 18','Subdivision Lot','10256','Appraisal District','','1150','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','30 - Katy','ALEXANDER ELEMENTARY SCHOOL (KATY)','SEVEN LAKES HIGH SCHOOL','BECKENDORFF JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox,Vacant/Unoccupied','Appraisal District','2','Traditional','Grand Lakes Ph Three Sec 9','7878','2.5063','Water District','2005','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213466960','1665344167','213466960','2022-10-08T21:48:32.713','76819080','Sylvia Reyes','JLA Realty','','','29.986039','-95.195222','17','77346','4','245000.00','Active','Glen Crossing','12202','Circle','Humble','2','2','3','1526','Single-Family','','0.1085','1','','','Gas Dryer Connections','','Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Atascocita South','Central Gas','1','LT 2 BLK 2 CLAYTONS CORNER SEC 3','Subdivision Lot','4725','Appraisal District','','','0','','2','Gas Oven','0','','','Freestanding Range','','Composition','29 - Humble','ATASCOCITA SPRINGS ELEMENTARY SCHOOL','ATASCOCITA HIGH SCHOOL','TIMBERWOOD MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Claytons Corner Sec 3','4952','2.933','Public Sewer,Public Water','2005','Appraisal District'); --> New record created successfully