Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T08:16:34.880' ,`MLSNumber` = '25820524' ,`ListAgentFullName` = 'Robert Miles' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = 'Anne Bielstein' ,`SellingOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`Latitude` = '29.721256' ,`Longitude` = '-95.572579' ,`PhotoCount` = '38' ,`PostalCode` = '77082' ,`RoomCount` = '9' ,`ListPrice` = '635000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'St Laurent' ,`StreetNumber` = '11215' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2861' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy a quiet secure lifestyle in this guard gated community. Located on a quiet cul-de-sac street in fabulous Royal Oaks Country Club, this 3 bedroom property features no carpet and a delightful pool/spa with tranquil water feature & pergola. Downstairs primary suite with hardwood floors has an elegant en-suite bath with whirlpool tub & two walk in closets. The large family room features gleaming hardwood floors, gas log fireplace, and a view of the beautiful pool/spa. The kitchen is open to the family & breakfast rooms. Kitchen features include granite counters, 5 burner gas cooktop, builtin refrigerator, convection oven, microwave, under cabinet lighting, and plenty of storage and prep space. The adjacent butlers pantry area makes for easy serving to the dining room. Upstairs is an extra large gameroom with wood floors. Two bedrooms & hollywood bath complete the upstairs - one bedroom includes a computer/study niche. Close to shopping, entertainment and major roads.' ,`Acres` = '0.1397' ,`Area` = '31' ,`BuilderName` = 'McVaugh Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Westchase Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 62 BLK 2 ROYAL OAKS COUNTRY CLUB SEC 9' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community' ,`LotSize` = '6086' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3295' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'OUTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'O\'DONNELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Royal Oaks Country Club' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641967' WHERE `Matrix_Unique_ID` = '206935858' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T08:45:38.723' ,`MLSNumber` = '18457625' ,`ListAgentFullName` = 'David Hageman' ,`ListOfficeName` = 'Century 21 Realty Partners' ,`SellingAgentFullName` = 'Megan Stultz' ,`SellingOfficeName` = 'Fairwater Westmont Real Estate' ,`Latitude` = '30.309543' ,`Longitude` = '-95.792488' ,`PhotoCount` = '50' ,`PostalCode` = '77316' ,`RoomCount` = '13' ,`ListPrice` = '2050000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Jacks Barn' ,`StreetNumber` = '26358' ,`StreetSuffix` = 'Road' ,`City` = 'Montgomery' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3546' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SPEND CHRISTMAS IN YOUR NEW HOME! \"Live where it feels like the vacation of a lifetime, every day\" at Bluejack National, a private residential club offering an unprecedented mix of amenities and activities for every lifestyle. 767 acres of rolling hills in Montgomery, TX. BlueJack is the 1st Tiger Woods-designed course in the US. Experience the championship golf course, and explore “The Fort” Golf Inc.’s Amenity of the Year and the hub of family activity. Rejuvenate with a palette of wellness offerings, massage therapies, and body treatments at The Sanctuary. Your Tipler Luxury Homes masterpiece features 4 master suites, each with a master suite bath, fireplace & sitting area. Vaulted wood beam ceilings grace the family room & kitchen that feature stunning views of #10 hole. Oversized island w quartz counters & professional series dacor appliances. Relax on your screened-in patio or watch the sunset around your firepit. Home gym & ½ bath over garage. FURNISHINGS INCLUDED (excl apply).' ,`Acres` = '0.5009' ,`Area` = '39' ,`BuilderName` = 'Tipler Luxury Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '5' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S263700 - BLUEJACK NATIONAL PHASE 1A PARTIAL REPLAT NO 1 # 2' ,`LotDesciption` = 'In Golf Course Community,On Golf Course' ,`LotSize` = '21819' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`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` = 'Accompany,Appointment Required,Controlled Access,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bluejack National' ,`TaxAmount` = '37627' ,`TaxRate` = '3.1092' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641967' WHERE `Matrix_Unique_ID` = '207632167' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T08:42:29.063' ,`MLSNumber` = '79986089' ,`ListAgentFullName` = 'Maria Barnabe' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.847203' ,`Longitude` = '-95.591676' ,`PhotoCount` = '38' ,`PostalCode` = '77041' ,`RoomCount` = '12' ,`ListPrice` = '594900.00' ,`Status` = 'Active' ,`StreetName` = 'Chase' ,`StreetNumber` = '5514' ,`StreetSuffix` = 'Harbor' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3582' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful multi-tonal brick home with unique facade that sets the tone for the rest of the house. Arched and semi arched windows graces this Cottage-Style home. Lot backs to the green belt contributing to the privacy of the lush green backyard and refreshing pool and spa. Impressive and welcoming foyer leads the way to the living area that flows to breakfast room and kitchen. Double-pane windows on first floor, well kept Cherry wood floors, high ceilings in living room, 2020 new roof, built in office cabinets, these are just a few of the array of details that makes this property very desirable. Gated community built around a lake with cycling/jog/walk trail. Buses stop here for the Awty, British International, and Village school. Within minutes to the energy corridor area, shopping area, restaurants and venues, I-10, Hwy 8, and 290. Summer time pool time! \r\nNEW PHOTOS COMING UP! In the meantime imagine your personal style in this white canvas.' ,`Acres` = '0.212' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 1 LAKES ON ELDRIDGE SEC 18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9235' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1670' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'KIRK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Right Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes On Eldridge Sec 18' ,`TaxAmount` = '11767' ,`TaxRate` = '2.471' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641967' WHERE `Matrix_Unique_ID` = '209797089' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T07:07:24.327' ,`MLSNumber` = '27464629' ,`ListAgentFullName` = 'Kristi Scott' ,`ListOfficeName` = 'JPAR-The Sears Group' ,`SellingAgentFullName` = 'Dayana Nunez' ,`SellingOfficeName` = 'REALM Real Estate Professional' ,`Latitude` = '29.680084' ,`Longitude` = '-95.814680' ,`PhotoCount` = '29' ,`PostalCode` = '77406' ,`RoomCount` = '7' ,`ListPrice` = '395000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Easton Ramsey' ,`StreetNumber` = '25219' ,`StreetSuffix` = 'Way' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2475' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is it! This meticulously maintained 3 bedroom, 2.5 bathroom home features high ceilings, designer colors, open living spaces, upgraded flooring, gameroom & covered back patio. This stunning open concept kitchen boasts a large island, 42-inch cabinetry, stainless steel appliances. The spacious family room is wired for surround sound and perfect for entertaining. The oversized primary suite is its own retreat from the rest of the home! The primary en-suite has double sinks, garden tub, separate shower, and a large walk-in closet. Recent upgrades include a water softer system, reverse osmosis system under the sink, new duct work, zone/climate-controlled thermostat, in-line air scrubber in the ductwork, sprinkler system and Hot Tub. All of this is positioned on a corner lot with an oversized back yard. Home is across the street from the splash pad and rec. center. Come check out this incredible home asap…it won’t last long!' ,`Acres` = '0.2657' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BRISCOE FALLS SEC 1, BLOCK 2, LOT 3' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '11576' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '768' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BENTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Briscoe Falls' ,`TaxAmount` = '7219' ,`TaxRate` = '2.5248' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641967' WHERE `Matrix_Unique_ID` = '209885125' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T08:55:33.253' ,`MLSNumber` = '40296642' ,`ListAgentFullName` = 'Gwynneth Rutherford' ,`ListOfficeName` = 'Keller Williams Hou Preferred' ,`SellingAgentFullName` = 'Seungjae Lee' ,`SellingOfficeName` = 'Keller Williams Realty - Memorial' ,`Latitude` = '29.849577' ,`Longitude` = '-95.598765' ,`PhotoCount` = '33' ,`PostalCode` = '77041' ,`RoomCount` = '10' ,`ListPrice` = '532000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Evening Shore' ,`StreetNumber` = '5611' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3572' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Motivated Seller! Just off Eldridge Parkway is one of West Houston’s most desirable private gated communities….Lakes on Eldridge North. Just Minutes from the Sam Houston toll way, Interstate 10, Highway 290 and the Energy Corridor, this picturesque area is an enclave of distinctive homes, cool lakes and sparkling fountains. \r\nLovely 4 bedroom,3.5 bath brick home with a big 3 car detached garage. Impressive foyer,spacious study,large family room w/tile floors and remote control fireplace. Big updated kitchen has granite countertops,stainless appliances,large island,gas connection for stovetop. Farmer’s sink,vent hood,wine frig,dishwasher,garbage disposal & lighting. Master suite down has a lavish,updated 2020 bathroom. Upstairs is a large game room,3 more bedrooms plus 2 updated bathrooms. Beautiful hardwood floors in study,dining room,master bedroom. Big,landscaped yard with sprinkler system (room to add a pool). Located on a quiet culdesac street.' ,`Acres` = '0.2467' ,`Area` = '8' ,`BuilderName` = 'VILLAGE' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 2 LAKES ON ELDRIDGE SEC 3 AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10747' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1670' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'KIRK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes on Eldridge' ,`TaxAmount` = '3150' ,`TaxRate` = '2.471' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641967' WHERE `Matrix_Unique_ID` = '210731752' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T08:27:05.400' ,`MLSNumber` = '70573674' ,`ListAgentFullName` = 'Melissa Wilson' ,`ListOfficeName` = 'MMW Realty Partners' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.682422' ,`Longitude` = '-95.735022' ,`PhotoCount` = '32' ,`PostalCode` = '77407' ,`RoomCount` = '4' ,`ListPrice` = '464900.00' ,`Status` = 'Active' ,`StreetName` = 'Laila Manor' ,`StreetNumber` = '20226' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2559' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stop your car and come view this lovely 4 bedroom,3 bathroom Coventry home! This home features roaring high ceilings with an open modern concept that includes a separate private office. This home includes a water softener and whole home 22k back up generator! No more sitting with the lights out while you hope Centerpoint crews make it to your street! This home also features a covered back patio. If you are looking for a convenient location in a great neighborhood near lots of shopping..... Book your appointment today!' ,`Acres` = '0.181' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND MISSION ESTATES SEC 24, BLOCK 4, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7883' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '895' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Grand Mission Estates Sec 24' ,`TaxAmount` = '8545' ,`TaxRate` = '2.7529' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641968' WHERE `Matrix_Unique_ID` = '211160870' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T08:29:34.017' ,`MLSNumber` = '73965794' ,`ListAgentFullName` = 'Melissa Wilson' ,`ListOfficeName` = 'MMW Realty Partners' ,`SellingAgentFullName` = 'Kathy Jones' ,`SellingOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`Latitude` = '29.791341' ,`Longitude` = '-95.386786' ,`PhotoCount` = '27' ,`PostalCode` = '77009' ,`RoomCount` = '4' ,`ListPrice` = '775000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Key' ,`StreetNumber` = '1118' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1920' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stop your car right now and come check out this completely renovated beauty! This home was recently converted from a duplex to single family home. Why not experience the greatness of this historical with a modern look inside?This home features 3 bedroom 2 bathrooms and located conveniently from great restaurants and coffee shops. You also are minutes away from the nightlife and enjoyment the heights have to offer. If you can\'t make it to the home? Well check out my virtual tour! Book an appt with us today!' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 BLK 132 NORTH NORHILL' ,`LotDesciption` = 'Other' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BROWNING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'North Norhill' ,`TaxAmount` = '8008' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1669641968' WHERE `Matrix_Unique_ID` = '211160978' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T08:14:32.083' ,`MLSNumber` = '79896925' ,`ListAgentFullName` = 'Christopher Ward' ,`ListOfficeName` = 'Orchard Brokerage' ,`SellingAgentFullName` = 'Nicole Sherrod' ,`SellingOfficeName` = 'Redfin Corporation' ,`Latitude` = '30.171014' ,`Longitude` = '-95.194826' ,`PhotoCount` = '30' ,`PostalCode` = '77357' ,`RoomCount` = '11' ,`ListPrice` = '329000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Banks Mill' ,`StreetNumber` = '23490' ,`StreetSuffix` = 'Drive' ,`City` = 'New Caney' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2753' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Back on Market. This residence will impress form the moment you enter w/ soaring ceilings, art niches, & tons of natural light. 5 bedrooms, 3.1 baths & a loft/game room upstairs! Fresh paint, steamed carpets, & refreshed landscaping make this home ready for new owners. Hard surface flooring throughout the main level is a breeze to maintain while all bedrooms have soft carpeting underfoot. Both formal & informal dining spaces. Large living room is a great space to relax or entertain guests. The kitchen checks all of the boxes- stainless steel appliances, granite countertops, recessed lighting, & a walk-in pantry. The primary bedroom is the only bedroom downstairs which makes for optimal privacy & features a walk-in closet, soaking tub, & separate shower. Enjoy outdoor activities or relax on the covered patio in the fenced backyard! Community is nestled close to greenbelt trails, lakes, & amazing views. Easy access to US 69. Click the Virtual Tour link for a 3D walkthrough.' ,`Acres` = '0.1377' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S921108 - TAVOLA 08, BLOCK 3, LOT 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'TAVOLA ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tavola 08' ,`TaxAmount` = '8202' ,`TaxRate` = '3.3731' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641968' WHERE `Matrix_Unique_ID` = '211702715' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T07:13:15.957' ,`MLSNumber` = '61666100' ,`ListAgentFullName` = 'Denise Garza' ,`ListOfficeName` = 'Mission Realty' ,`SellingAgentFullName` = 'Orlando Godoy' ,`SellingOfficeName` = 'Realty Right' ,`Latitude` = '30.190261' ,`Longitude` = '-95.619165' ,`PhotoCount` = '20' ,`PostalCode` = '77354' ,`RoomCount` = '3' ,`ListPrice` = '165000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Boardwalk' ,`StreetNumber` = '30018' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1834' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great starter home in Magnolia sits on a large lot. This 3 bedroom home offers plenty of open space with a combo dining, and the living room offers a separate sitting area and fireplace. The center of the home has a large room that can be used has a separate living area and or game room. Primary bath has dual vanities, standing shower and separate soaking tub. There is also a small storage shed in corner of the property.' ,`Acres` = '0.3788' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S774800 - PARK PLACE MH PARK, BLOCK 1, LOT 49, SERIAL # TXFL' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '16500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Park Place Mh Park' ,`TaxAmount` = '2990' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1669641968' WHERE `Matrix_Unique_ID` = '211901612' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T07:55:04.097' ,`MLSNumber` = '14141820' ,`ListAgentFullName` = 'Meagan Bordelon' ,`ListOfficeName` = 'Bernstein Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.762687' ,`Longitude` = '-95.540331' ,`PhotoCount` = '29' ,`PostalCode` = '77024' ,`RoomCount` = '11' ,`ListPrice` = '890000.00' ,`Status` = 'Active' ,`StreetName` = 'Stoney Creek' ,`StreetNumber` = '266' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2463' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Four Bedroom, 2 Bath, well-loved, Vintage Charmer located in Bunker Hill Village in the Whispering Oaks Subdivision. Renovate or Build your dream home! Wonderful floorplan with the potential to make your own. Large bathrooms and closets make for a wonderful footprint. Bright sunroom attached to the back. Wooded lot in backyard overlooks tranquil Stoney Creek. Walking distance to Memorial Forest Pool and Frostwood Elementary. Zoned to exemplary Memorial Middle School and Memorial High School. Per Seller there has been no history of flooding. Schedule an appointment to see this one-of-a-kind home today.' ,`Acres` = '0.2571' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Block 3 Whispering Oaks' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '11200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'FROSTWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Whispering Oaks' ,`TaxAmount` = '15760' ,`TaxRate` = '2.1865' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641969' WHERE `Matrix_Unique_ID` = '211942261' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T07:39:25.083' ,`MLSNumber` = '6861526' ,`ListAgentFullName` = 'Stuart Scholer' ,`ListOfficeName` = '5th Stream Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.809813' ,`Longitude` = '-95.407653' ,`PhotoCount` = '50' ,`PostalCode` = '77008' ,`RoomCount` = '8' ,`ListPrice` = '985000.00' ,`Status` = 'Active' ,`StreetName` = '26th' ,`StreetNumber` = '540' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3159' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t Miss This Immaculate Home with an ELEVATOR in the Heart of The Heights! 4 Bedrooms (or 3 Bedrooms Plus a Study or Media Room), 3.5 Baths and a Game Room with a Wet Bar and a Covered Outdoor Terrace. The Family Room Overlooks the Picturesque Backyard with Room for Your Outdoor Kitchen and Pool. The Primary Suite is Designed Like a Hotel Suite with a Foyer, Coffee Bar, Lavish Bath with a Soaking Tub & Huge Walk-in Shower and Custom Closet. Over $150,000 in Custom Upgrades Including an ELEVATOR! This Amazing Home Also Showcases Hardwood Floors, Custom Iron Doors, 48\" Thermador Appliance Package, an Extended Kitchen Island, Soft Close Cabinets and Drawers, Data Smart and Built in Speakers, Lush Backyard Landscaping with Uplighting and Sprinkler System.' ,`Acres` = '0.0752' ,`Area` = '9' ,`BuilderName` = 'TITAN HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 19 BLK 32 HOUSTON HEIGHTS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3275' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HELMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Houston Hts' ,`TaxAmount` = '17931' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641969' WHERE `Matrix_Unique_ID` = '213217458' --> 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','213223094','1669641969','213223094','2022-11-24T07:26:42.593','93544229','Carl Collins','Equity House Properties','','','29.802858','-94.909541','26','77521','4','239900.00','Active','Maple','7514','Lane','Baytown','2','0','4','1713','Single-Family','Fresh paint inside and out on this 4/2/2 on nearly 12,000 sq. ft. cul de sac lot and has no backyard neighbors. Upon entering the primary bedroom and one secondary bedroom are on the left. Go through the family room to find a wood burning stone fireplace and on the back side is a grand dining room. On the right is a country styled kitchen with ample cabinets, and an area for a breakfast table. The other two bedrooms and bathroom are on this side as well. There is low maintenance flooring throughout for easy cleaning.','0.2665','53','','','','','Sellers Disclosure','','','','Baytown/Chambers County','Central Electric','1','132 PINEHURST S/D','Cul-De-Sac','11610','Appraisal District','','88','0','','2','','0','','','','','Composition','23 - Goose Creek Consolidated','CLARK ELEMENTARY SCHOOL (GOOSE CREEK)','STERLING HIGH SCHOOL (GOOSE CREEK)','GENTRY JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','Pinehurst Sub','5692','2.9232','Public Sewer,Public Water','1978','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T08:26:10.350' ,`MLSNumber` = '47948766' ,`ListAgentFullName` = 'Stacey Fuentes Nelson' ,`ListOfficeName` = 'Coldwell Banker RealtyREALTORS' ,`SellingAgentFullName` = 'Ken Ho' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '30.044671' ,`Longitude` = '-95.585065' ,`PhotoCount` = '26' ,`PostalCode` = '77375' ,`RoomCount` = '6' ,`ListPrice` = '225000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Bold River' ,`StreetNumber` = '19346' ,`StreetSuffix` = 'Road' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1403' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new home! This adorable 3 bedroom 2 bath home with recent exterior paint gives it a new fresh look. Split floor plan with tile flooring throughout the home makes this a must see. Spacious kitchen with beautiful countertops, deep kitchen sink, tile backsplash with upgraded appliances would please any cook in the family. Kitchen opens up to the living room so you always feel part of the conversation while cooking. Down the hall there are two hallway closets for storage that is always needed. Primary bathroom has a relaxing garden tub to relax in on those long days. Inside the garage you will find storage cabinets and a water heater replaced in 2021. Easy access to 249 and 99 for that easy commute.' ,`Acres` = '0.1407' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 2 NORTHERN POINT SEC 4' ,`LotDesciption` = 'Corner' ,`LotSize` = '6129' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KOHRVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'ULRICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Northern Point Sec 04' ,`TaxAmount` = '3885' ,`TaxRate` = '2.7066' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641969' WHERE `Matrix_Unique_ID` = '213812025' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T08:40:52.270' ,`MLSNumber` = '17529371' ,`ListAgentFullName` = 'Anja Drewes Neidhardt' ,`ListOfficeName` = 'Anja DrewesProperties, LLC' ,`SellingAgentFullName` = 'Giesla Lazar' ,`SellingOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`Latitude` = '29.647955' ,`Longitude` = '-95.728708' ,`PhotoCount` = '42' ,`PostalCode` = '77406' ,`RoomCount` = '9' ,`ListPrice` = '319900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Cane Lake' ,`StreetNumber` = '3710' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1919' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful one story home in sought after Waterside Estates subdivision! Spacious 4 bedroom/2 bath/2 car garage. Open floorplan with huge living room, vaulted ceilings, formal dining, lots of closet space. 2022 updates: brand-new flooring (carpet with upgraded pad and luxury vinyl plank ), all freshly painted, incl trim and doors, new doorknobs, new front and rear door, new dual flush toilets, new kitchen faucet, new range hood. 2019 updates included: new hvac, water heater, garbage disposal, garage door and motor. Waterside Estates offers a beautiful fishing lake, walking trails, parks, community tennis courts and pool with kiddie splash pad. Zoned to Fort Bend ISD award-winning schools and easy commute make this a great place to call home! Easy access to 99, nearby shopping, dining, and entertainment. The Lifestyle You’re Looking For!' ,`Acres` = '0.135' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WATERSIDE ESTATES SEC 9, BLOCK 1, LOT 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5881' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '640' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'OAKLAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'BOWIE MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Waterside Estates' ,`TaxAmount` = '4741' ,`TaxRate` = '2.2929' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641969' WHERE `Matrix_Unique_ID` = '213910743' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T08:09:17.393' ,`MLSNumber` = '61028493' ,`ListAgentFullName` = 'Brandi Jackson' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.377550' ,`Longitude` = '-95.635246' ,`PhotoCount` = '50' ,`PostalCode` = '77356' ,`RoomCount` = '8' ,`ListPrice` = '729750.00' ,`Status` = 'Active' ,`StreetName` = 'Shore' ,`StreetNumber` = '2025' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3235' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Classic style and timeless elegance, paired with breathtaking Lake Conroe waterfront views! This luxurious lake home is located in the prestigious gated enclave of South Shore Estates. The outdoor oasis delivers a newly refinished & painted dock, a newly covered 39-foot boat slip with a lift, & you\'re very own pool! A desirable open plan offers a large family room with soaring ceilings, travertine flooring throughout, a chef\'s kitchen with generous storage, stainless steel appliances, breakfast room & walk-in pantry. The primary retreat is complete with a sitting area, dual vanities, soaking jet tub, separate walk-in shower, & generous walk-in closet. The second floor provides two additional bedrooms with en-suite baths. Featuring all new carpet, newly painted interior walls, exterior wood replaced & painted, move in today! Zoned to the highly acclaimed Montgomery ISD & minutes to restaurants, shopping, The Woodlands & more. Come enjoy luxury lake style living, here!' ,`Acres` = '0.1551' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SOUTH SHORE ESTATES 02, BLOCK 1, LOT 11' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '6757' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '480' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'South Shore Estates 02' ,`TaxAmount` = '13355' ,`TaxRate` = '2.3542' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641970' WHERE `Matrix_Unique_ID` = '214157409' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T08:38:47.350' ,`MLSNumber` = '52767780' ,`ListAgentFullName` = 'Annie Hewitt' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '29.765029' ,`Longitude` = '-95.566514' ,`PhotoCount` = '42' ,`PostalCode` = '77079' ,`RoomCount` = '12' ,`ListPrice` = '1749000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Hermitage' ,`StreetNumber` = '12954' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5487' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great opportunity to get into the highly-coveted Memorial Glen neighborhood. The house is walking distance to Terry Hershey Park\'s 500+ acres of green space which includes a pathed running and biking trail. It is also an easy bike or golf cart ride to the neighborhood pool, home of the mighty Barracudas swim team! The house has a formal dining room, two offices, a beautiful family room with cathedral ceiling, a fabulous kitchen that was completely renovated in 2018 and a massive upstairs playroom. Very spacious primary suite is downstairs. Four secondary bedrooms are upstairs. Two of the secondary bedrooms have their own bathrooms, and the other two share. The playroom has a full bathroom and could be converted to an extra bedroom suite. Large laundry room is upstairs. There is also a stackable washer/dryer in the primary closet. Outdoor kitchen leaves enough room for green space and a small pool.' ,`Acres` = '0.202' ,`Area` = '23' ,`BuilderName` = 'Morgan Moore' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 3 MEMORIAL GLEN SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'RUMMEL CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STRATFORD HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Glen' ,`TaxAmount` = '44723' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641970' WHERE `Matrix_Unique_ID` = '214170584' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T07:33:58.647' ,`MLSNumber` = '85385791' ,`ListAgentFullName` = 'Jason Gracey' ,`ListOfficeName` = 'Great Houston Properties' ,`SellingAgentFullName` = 'Robert Aguilar' ,`SellingOfficeName` = 'Opendoor Brokerage, LLC' ,`Latitude` = '29.931354' ,`Longitude` = '-95.243578' ,`PhotoCount` = '41' ,`PostalCode` = '77396' ,`RoomCount` = '11' ,`ListPrice` = '365000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Vesper Lake' ,`StreetNumber` = '14830' ,`StreetSuffix` = 'Court' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2688' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WOW! Don\'t miss this cul-de-sac beauty. Lightly lived in, home features fantastic floor plan & upgraded finishes throughout. Starting w/beautiful curb appeal buyers will notice the wood shutters and attractive elevation incorporating siding, brick & stone. Covered entry porch is big enough for seating allowing you to observe life from the front porch. Inside find beautiful wood floors, wide welcoming foyer/hall, formal dining on right, & living room/study on left. Handmade asymmetrical shelves stay. Warm custom paint throughout. Kitchen w/huge island, gas cooktop, stainless appliances, & custom tile backsplash. High ceilings & lots of windows. Large downstairs primary w/huge closet. 3 beds, 1 bath & gameroom upstairs - all with lots of storage/closet space. Covered patio off breakfast room is ready for the grill & community has tons of amenities & great schools. Washer/Dryer/Fridge stay. Family Room TV/mount stay. Garage is air conditioned & wood brackets/overhead storage rack stay.' ,`Acres` = '0.1602' ,`Area` = '1' ,`BuilderName` = 'Trinity Signature' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fall Creek Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 34 BLK 1 EAGLE CREEK SEC 1' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '6977' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1090' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'AUTUMN CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Photos/No Videos,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Eagle Crk Sec 1' ,`TaxAmount` = '8667' ,`TaxRate` = '3.0673' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641970' WHERE `Matrix_Unique_ID` = '214329002' --> 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','214453151','1669641970','214453151','2022-11-24T08:35:25.973','74070984','Ernesto Perez','My Texas Realty','','','29.721139','-95.317535','24','77023','8','230000.00','Active','Craig','5709','Street','Houston','2','0','3','965','Single-Family','Absolutely beautiful inside and out!! Come take a look at this home in an established neighborhood. Minutes away from shopping, schools, businesses and much more. This home boasts in detail and craftsmanship. Spacious rooms, open living concept, new kitchen, tile flooring/ original wood floor and 2 bathrooms. Don\'t miss out on this one!! call me for more information. Corner lot with house on one side , lots of potential.','0.1307','4','','','','','Sellers Disclosure','','','','East End Revitalized','Central Gas','0','LT 7 BLK 9 SUNNYLAN','Cleared','5695','Appraisal District','','','0','','0','','0','','','','','Composition','27 - Houston','HENDERSON J ELEMENTARY SCHOOL','AUSTIN HIGH SCHOOL (HOUSTON)','NAVARRO MIDDLE SCHOOL (HOUSTON)','Appointment Required,Supra Keybox','Seller','2','Traditional','Sunnylan','3376','2.3307','Public Sewer,Public Water','1940','Appraisal'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T07:50:52.960' ,`MLSNumber` = '71028603' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = 'Kaitlin Henicke' ,`SellingOfficeName` = 'RE/MAX ONE - Premier' ,`Latitude` = '29.817909' ,`Longitude` = '-95.037799' ,`PhotoCount` = '34' ,`PostalCode` = '77562' ,`RoomCount` = '3' ,`ListPrice` = '279990.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Cindyrella' ,`StreetNumber` = '510' ,`StreetSuffix` = 'Drive' ,`City` = 'Highlands' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1540' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Super Clean and Well Cared for 3 Bedroom Home w/4 CAR GARAGE. Bring your toys as there\'s plenty of room for boats, rv\'s, atv\'s etc.. Smart Design split floor plan secludes the Primary Bedroom from the Second Bedrooms. Soaring Ceilings in Family Room overlook your Covered Back Patio and Oversized Back Yard. No Carpet thru the Entire Home, Lightly Remodeled Bathrooms, Open and Bright Kitchen featuring Stainless Appliances and pull out racks in cabinets. Formal Dining or Study adjacent to kitchen surrounded by windows creates a great space to work or have a gathering. This is a Must See, call today for your Private Tour.' ,`Acres` = '0.2324' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 38 CREEL COUNTRY ESTATES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10125' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'HOPPER/HIGHLANDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Creel Country Estates' ,`TaxAmount` = '4607' ,`TaxRate` = '2.575' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641970' WHERE `Matrix_Unique_ID` = '214485471' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T07:49:40.547' ,`MLSNumber` = '69523487' ,`ListAgentFullName` = 'Jennifer Hansen' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = 'Jeffrey Lookabaugh' ,`SellingOfficeName` = 'Compass RE Texas, LLCKaty' ,`Latitude` = '29.770793' ,`Longitude` = '-95.861311' ,`PhotoCount` = '50' ,`PostalCode` = '77494' ,`RoomCount` = '13' ,`ListPrice` = '575000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Penny Ranch' ,`StreetNumber` = '1130' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4863' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MAGNIFICENT 5 BEDROOM (2 BEDROOMS DOWN & a 2ND PRIMARY UP) 4.5 Bath 4800 sq ft+ home in ANSERRA! Upon entry you will be greeted with high ceilings, a sweeping staircase and gorgeous gray laminate wood flooring in all the main areas. Formal living and dining area w/ butlers pantry and onto the huge isle kitchen w/double ovens, custom lighting, huge walk in pantry, stainless appliances and open to the spacious family room with wall of windows to the custom screened in back covered patio area plumbed with gas. Large primary suite w/ensuite bath and walk in closet. Upstairs game room w/ceiling speakers and second story balcony access. Large prewired media room w/surround sound speakers.3 Secondary bedrooms up including an ensuite second primary bedroom. Upgrades galore including a water softener, reverse osmosis system, and solar panels that convey with the home. Walking distance to community pool. Just minutes from I-10 for an easy commute to the energy corridor. KATY ISD. NEVER FLOODED!' ,`Acres` = '0.1992' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ANSERRA SEC 3, BLOCK 2, LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8675' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1064' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BRYANT ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Anserra Sec 3' ,`TaxAmount` = '13603' ,`TaxRate` = '3.2845' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641971' WHERE `Matrix_Unique_ID` = '214507873' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T07:32:41.430' ,`MLSNumber` = '89823564' ,`ListAgentFullName` = 'Jason Gracey' ,`ListOfficeName` = 'Great Houston Properties' ,`SellingAgentFullName` = 'Malcolm Ruben' ,`SellingOfficeName` = 'Truss Real Estate' ,`Latitude` = '29.671037' ,`Longitude` = '-95.420776' ,`PhotoCount` = '37' ,`PostalCode` = '77054' ,`RoomCount` = '7' ,`ListPrice` = '395000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Capewalk' ,`StreetNumber` = '2603' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2329' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous home is a CORNER UNIT!! Nestled in the private & gated Bedford Falls Community near the Medical Center & Downtown. It has a very attractive floor plan w/lots of flexibility. Sellers just repainted the entire home including cabinetry & trim within last few months & replaced/upgraded cabinet hardware, lighting, & fans. Downstairs 1/2 bath has been updated as well as kitchen faucet. Gorgeous wood floors & tile throughout. So cute backyard garden patio with a gate out to the side green space. On the 3rd floor, buyers will find a huge room w/private full bath that is currently a home office but could be a 4th bedroom or flex room. Location in community is excellent. Home sits just a few doors down from community pool, clubhouse/gym, and around the corner from lake & walking trails. HOA includes water/sewer. Spacious, bright, & modern the home has a welcoming feel. Don\'t wait - this beauty won\'t last long. The immaculate condition & location make it one of the area\'s top picks.' ,`Acres` = '0.0433' ,`Area` = '18' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Medical Center Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 3 BEDFORD FALLS AMEND' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '1885' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHEARN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Bedford Falls' ,`TaxAmount` = '7134' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641971' WHERE `Matrix_Unique_ID` = '214555598' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T08:20:25.037' ,`MLSNumber` = '63233082' ,`ListAgentFullName` = 'Danny Vu' ,`ListOfficeName` = 'Danny Vu Realty' ,`SellingAgentFullName` = 'Jorge Maldonado' ,`SellingOfficeName` = 'Keller Williams Woodlands' ,`Latitude` = '29.907672' ,`Longitude` = '-95.313258' ,`PhotoCount` = '13' ,`PostalCode` = '77039' ,`RoomCount` = '8' ,`ListPrice` = '199900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Sandydale' ,`StreetNumber` = '5223' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful large brick home in a great neighborhood, with 4 bedrooms (2 primary) and 3 full baths, large formal living room could be 5 bedroom or media room, huge kitchen with granite countertops, SS appliances, 6 yrs old roof and furnace, fully fenced backyard with no back neighbor. Minutes from downtown, Bush Airport, Dearbrook Mall, Hwy 59, and BW8. Come see it today before it\'s gone tomorrow.' ,`Acres` = '0.1818' ,`Area` = '34' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 210 BLK 2 FAIRGREEN SEC 2' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7920' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'OLESON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MACARTHUR HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'MEAD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairgreen Sec 02' ,`TaxAmount` = '4452' ,`TaxRate` = '2.9881' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641971' WHERE `Matrix_Unique_ID` = '214647841' --> 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','214893732','1669641971','214893732','2022-11-24T08:26:47.960','5487846','Laurie Long','RE/MAX Space Center-Clear Lake','','','29.623705','-95.024950','45','77571','8','305000.00','Active','Country Club','1028','Drive','Shoreacres','3','0','4','2496','Single-Family','Welcome home to Shoreacres! Steps away from the bay, this Lovely home on huge lot exceeding 3/4 acre,is nested away from the street with soaring mature trees providing wonderful shade and relief from the heat in the summer. Home has amazing decking surrounding for outdoor entertaining. Entry to this split level living with large open space between the family and dining rooms. Updated gourmet kitchen with granite, island and storage galore! Primary suite located on the main floor with fantastic space. Has gorgeous en suite bathroom , laundry room and huge walk in closet. Additional bedrooms and secondary full bathroom downstairs for your guests. Back deck is expansive and overlooks the huge backyard. Imagine the fun entertaining with friends and family with the amazing decks surrounding the home and the large backyard. The yard provides plenty of space for a pool and there are no back neighbors. Wonderful privacy. Welcome Home. Excellent quiet and private area located LPISD','0.7955','7','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Shoreacres/La Porte','Central Electric','0','LT 10 BLK 41 SHOREACRES','Cleared,Subdivision Lot,Wooded','34650','Appraisal District','','','0','','0','Double Oven,Gas Oven','0','','','Gas Cooktop','','Aluminum,Other','35 - La Porte','BAYSHORE ELEMENTARY SCHOOL','LA PORTE HIGH SCHOOL','LA PORTE J H','Appointment Required','Appraisal District','2','Mediterranean,Traditional','Shoreacres','6963','2.8597','Public Water','1984','Appraisal'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T08:42:48.533' ,`MLSNumber` = '12808657' ,`ListAgentFullName` = 'Chad Hallmark' ,`ListOfficeName` = 'Seamless Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.885632' ,`Longitude` = '-95.531152' ,`PhotoCount` = '34' ,`PostalCode` = '77040' ,`RoomCount` = '11' ,`ListPrice` = '599900.00' ,`Status` = 'Active' ,`StreetName` = 'Allegro' ,`StreetNumber` = '7738' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3593' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated home with 2 BEDROOMS DOWN! This spacious home features both formals with high ceilings, gorgeous kitchen with new Quartz countertops and backsplash, waterfall island, high-end appliances, and family room with gas fireplace. Primary bedroom features remote controlled electric blinds and a sitting area which includes an updated gas fireplace with a chunky wood mantel! Primary bath features new Delta fixtures, new Quartz countertops and shower walls, and free-standing tub! High end vinyl plank floors throughout the home and stairs, no carpet, designer light fixtures & hardware. 3 bedrooms and game room up. Woodwind Lakes has Adult & Family Pools, Tennis/Pickleball Courts, Pavilion, Dog Park, 3 Wooded Lakes w/Walking Trails and Catch & Release Fishing. Schedule your showing today!' ,`Acres` = '0.1907' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 3 WOODWIND LAKES SEC 2 AMENDED' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8309' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'GLEASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JERSEY VILLAGE HIGH SCHOOL' ,`SchoolMiddle` = 'COOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodwind Lakes Sec 02 Amd' ,`TaxAmount` = '10847' ,`TaxRate` = '2.591' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641971' WHERE `Matrix_Unique_ID` = '214943581' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T08:48:47.040' ,`MLSNumber` = '75988148' ,`ListAgentFullName` = 'Dao Vo' ,`ListOfficeName` = 'Intercontinental Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.228092' ,`Longitude` = '-95.242473' ,`PhotoCount` = '20' ,`PostalCode` = '77357' ,`RoomCount` = '5' ,`ListPrice` = '260000.00' ,`Status` = 'Active' ,`StreetName` = 'Paddock Point' ,`StreetNumber` = '15038' ,`StreetSuffix` = 'Lane' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New and beauti home. All floor is anti water laminate, Bedrooms are carpet. Two clothe sets in Master bedroom. large Living room. Granit counter top; Sprinkler for front yard. Vacant home. Good school right out side the neighborhood. A quiet and nice subdivision.' ,`Acres` = '0.1383' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`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` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'TIMBER LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harrington Trails 03' ,`TaxAmount` = '663' ,`TaxRate` = '2.0783' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669641972' WHERE `Matrix_Unique_ID` = '214992614' --> 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','215036093','1669641972','215036093','2022-11-24T08:40:22.723','65233776','Nusrat Ghafoor','Walzel Properties','','','29.697582','-95.586157','23','77072','7','249900.00','Active','Triola','11807','Lane','Houston','2','0','3','1858','Single-Family','Beautiful 3 bedrooms 2 bathrooms House. Study room upon entrance.','0.1392','28','','','','','Sellers Disclosure','','','1','Alief','Central Electric','1','LT 3 BLK 15 BELLAIRE WEST SEC 3','Subdivision Lot','6064','Appraisal District','','120','0','','0','','0','','','','','Composition','2 - Alief','MARTIN ELEMENTARY SCHOOL (ALIEF)','AISD DRAW','KILLOUGH MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Bellaire West Sec 03','4658','2.4411','Public Sewer,Public Water','1967','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','215075077','1669641972','215075077','2022-11-24T08:21:34.580','18754134','Michael Ramirez','MJR Real Estate','','','29.692339','-95.277120','29','77017','0','150000.00','Active','Grafton','8114','Street','Houston','0','0','0','1518','Single-Family','HUGE LOT JUST OUTSIDE 610* BIG REHAB JOB OR TEAR DOWN FOR BUILD UP* LOTS OF UPSIDE ON THIS \r\n11250 SQ FT OVERSIZE LOT* HAS TWO BUILDING * WAS A DUPLEX IN FRONT WITH MORE APTS IN BACK .... NEEDS EVERYTHING AND THEN SOME*','0.2583','3','','','','','Sellers Disclosure','','','1','Hobby Area','No Heating','0','LT 5 BLK 48 PARK PLACE','Subdivision Lot','11250','Appraisal District','','','0','','','','0','','','','','Composition','27 - Houston','PARK PLACE ELEMENTARY SCHOOL','CHAVEZ HIGH SCHOOL','ORTIZ MIDDLE SCHOOL','Vacant/Unoccupied','Appraisal District','1','Traditional','Park Place','4438','2.3307','Public Sewer,Public Water','1936','Appraisal District'); --> New record created successfully