Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T14:00:32.003' ,`MLSNumber` = '95068602' ,`ListAgentFullName` = 'Manuel Borjas' ,`ListOfficeName` = 'AAA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.080931' ,`Longitude` = '-95.124166' ,`PhotoCount` = '43' ,`PostalCode` = '77336' ,`RoomCount` = '15' ,`ListPrice` = '589500.00' ,`Status` = 'Active' ,`StreetName` = 'Vista Del Lago' ,`StreetNumber` = '614' ,`StreetSuffix` = 'Drive' ,`City` = 'Huffman' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3352' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Back on Market. In The \"Commons of Lake Houston\" on Vista Del Lago there is a warm, wonderful sun dappled home with all the best of the country. Designed in the classic traditional style this property boasts 1.8 acres in a beautiful semi-wooded lot, this home exudes warmth upon entry. Large windows around bathe the home in light. Flanking the Foyer are a Study+ a Formal Dining Room. Great Room features double height vaulted ceiling with clerestory windows open to the Breakfast Room +Kitchen with a half bathroom nearby. Kitchen is equipped with a commercial grade 6 burner gas range, gas oven, a granite breakfast bar, granite counters+ 42\" cabinets. Huge Primary Bedroom, Bathroom huge walk in closet round out the First Floor. Head up to the second floor and you will find 3 great sized bedrooms, nice closets game room, 2 full baths, great sized closets. Outside is a nice covered patio, breezeway, + greenhouse. Huge 3 car garage with huge 430 sq ft 2nd floor.' ,`Acres` = '1.8485' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Gas,Propane' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 4 COMMONS OF LAKE HOUSTON SEC 3' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '80520' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'FALCON RIDGE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Commons Lake Houston Sec 03' ,`TaxAmount` = '9209' ,`TaxRate` = '2.0463' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706359' WHERE `Matrix_Unique_ID` = '202155516' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T14:54:42.290' ,`MLSNumber` = '11794212' ,`ListAgentFullName` = 'Velma Ellison' ,`ListOfficeName` = 'Alliance Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.919635' ,`Longitude` = '-95.104453' ,`PhotoCount` = '50' ,`PostalCode` = '77532' ,`RoomCount` = '15' ,`ListPrice` = '725000.00' ,`Status` = 'Active' ,`StreetName` = 'Chart' ,`StreetNumber` = '1966' ,`StreetSuffix` = 'Drive' ,`City` = 'Crosby' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '7' ,`SqFtTotal` = '5959' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One of a Kind French Style home located in Beautiful and sought after, Newport Subdivision. This home offers, 7 bedrooms, 4 full and 2 half baths. 4 fireplaces. 3 living areas, 1 library. Closets Galore!, Exterior Balcony. 2 Master Bedrooms. In-Ground Pool with a slide. Workshop. Pool house#1 (10 x 30) & Pool house #2 (12 x 25). Full yard inground sprinkler system. Professional landscaping. \r\nMature trees. 2500 sq ft addition completed in 2013. This stunning home could be yours. Call your Realtor today and schdule a showing.' ,`Acres` = '0.52' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '4' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 40 & 41B BLK 1 NEWPORT SEC 4' ,`LotDesciption` = 'Corner,In Golf Course Community' ,`LotSize` = '22775' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '660' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Enclosed,Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'CROSBY ELEMENTARY SCHOOL (CROSBY)' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'French' ,`Subdivision` = 'Newport' ,`TaxAmount` = '10135' ,`TaxRate` = '2.7105' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706359' WHERE `Matrix_Unique_ID` = '207323604' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T14:47:41.080' ,`MLSNumber` = '11353571' ,`ListAgentFullName` = 'Lisa Flores' ,`ListOfficeName` = 'RE/MAX Grand' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.787098' ,`Longitude` = '-95.581607' ,`PhotoCount` = '50' ,`PostalCode` = '77043' ,`RoomCount` = '11' ,`ListPrice` = '489000.00' ,`Status` = 'Active' ,`StreetName` = 'Ash Creek' ,`StreetNumber` = '11210' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3127' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL HOME IN A COZY CUL DE SAC AND THERE IS ALSO A GUEST HOUSE. THIS 4 BED, 3.5 BATH HOME WILL NOT LAST LONG! YOU ARE WELCOMED BY A FAMILY AREA, ACCOMPANIED BY A FORMAL DINING ROOM, AND LARGE LIVING AREA PERFECT FOR ENTERTAINING. THE KITCHEN HAS NEW GRANITE COUNTERTOPS, ABUNDANT CABINET SPACE, AND A BREAKFAST BAR. THE PRIMARY SUITE INCLUDES ITS OWN PRIVATE BATHROOM, AND DOUBLE WALK-IN CLOSETS. THE MAIN HOUSE AS WELL AS THE GUEST HOUSE HAVE ALL NEW LAMINATE WOOD FLOORING. THERE IS ALSO A BEAUTIFUL COURTYARD-LIKE BACKYARD AND PATIO, GREAT FOR SPENDING THE HOT TEXAS SUMMER DAYS OUTSIDE. DON\'T MISS OUT ON THE CHANCE TO CALL THIS YOUR NEXT HOME!' ,`Acres` = '0.2095' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 110 BLK 1 SHERWOOD OAKS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9125' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'SHERWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STRATFORD HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Back,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sherwood Oaks' ,`TaxAmount` = '8306' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663706359' WHERE `Matrix_Unique_ID` = '209517566' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T14:37:40.750' ,`MLSNumber` = '20477804' ,`ListAgentFullName` = 'Jackson Mathew' ,`ListOfficeName` = 'Land & Luxe Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.573543' ,`Longitude` = '-95.563269' ,`PhotoCount` = '50' ,`PostalCode` = '77459' ,`RoomCount` = '6' ,`ListPrice` = '329900.00' ,`Status` = 'Active' ,`StreetName` = 'Palm Grove' ,`StreetNumber` = '3654' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2430' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Move-in ready 3 beds, 2.5 baths .An immense formal Living Room with two-story windows gives you all the space you need to relax or entertain. . Master bedroom with double sink and huge closet. . Washer, Dryer, and Refrigerator are included. Recently upgraded home with new roof, New AC , Fresh Paint and new flooring .Easy access to sugar land and downtown via Hwy 6, Hwy 59 and Hwy 90, located next door to Quail Valley Middle school.' ,`Acres` = '0.4728' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'QUAIL VALLEY THUNDERBIRD WEST COURTYARD HOMES, BLOCK 1, LOT' ,`LotDesciption` = 'Corner' ,`LotSize` = '20594' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '435' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'QUAIL VALLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'QUAIL VALLEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Quail Valley Thunderbird West' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706359' WHERE `Matrix_Unique_ID` = '209567510' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T15:24:49.470' ,`MLSNumber` = '29883045' ,`ListAgentFullName` = 'Michel Coret' ,`ListOfficeName` = 'Delux Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.232051' ,`Longitude` = '-94.889166' ,`PhotoCount` = '21' ,`PostalCode` = '77554' ,`RoomCount` = '11' ,`ListPrice` = '2490000.00' ,`Status` = 'Active' ,`StreetName` = 'Beachside' ,`StreetNumber` = '11370' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3627' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The most amazing custom designed home in one the most sought out subdivisions in W Galveston. This stunning property has a very unique lot. NO homes built close to it giving it privacy and views that no other home has. Too many upgrades to all include here such as Elevator, outdoor kitchen looking off the 2nd floor rounded balconies with views of the gulf. There is a pond at the back of the home that gives you a pleasant view from the back.\r\nSome upgrades include owners closet + 1 guest closet, 2 pantries(owner/guest) making it the perfect rental property, 3 built in bunk beds, media room, 10 ft kitchen island for entertaining large groups. State of the art appliances with 48\" Dual range, built in refrigerator and freezer, separate ice maker, wet bar in dining room. 2000 SF of covered balconies and much more stunning features. If you are looking for the most eye catching and well designed beach house in Galveston, come take a look at this beauty. Client can still choose finishes.' ,`Acres` = '0.2081' ,`Area` = '33' ,`BuilderName` = 'Oceanside Interests' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'HOA First Right of Refusal,Home Protection Plan' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 512 BEACHSIDE VILLAGE SEC 5 (2019) ABST 121' ,`LotDesciption` = 'Corner,Subdivision Lot,Water View' ,`LotSize` = '9063' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '313' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Beachside Vlg-Sec 5' ,`TaxAmount` = '7359' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663706359' WHERE `Matrix_Unique_ID` = '210024449' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T14:28:03.917' ,`MLSNumber` = '86230453' ,`ListAgentFullName` = 'Diana Ayers' ,`ListOfficeName` = 'Ayers & Associates Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.759619' ,`Longitude` = '-95.485044' ,`PhotoCount` = '10' ,`PostalCode` = '77057' ,`RoomCount` = '0' ,`ListPrice` = '1050000.00' ,`Status` = 'Active' ,`StreetName` = 'Riverview' ,`StreetNumber` = '6012' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '0' ,`BathsHalf` = '0' ,`BedsTotal` = '0' ,`SqFtTotal` = '5013' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lucian Hood designed home in Tanglewood. This is a wonderful opportunity to build or restore in Tanglewood just a few blocks from the Houston Country Club!! Home has extensive water and foundation damage and is being sold for lot value although if you want a project this could again be the stately home it once was. Beautiful large trees on the perimeter of the property offer great shade and privacy. The present structure is set back from the street with a circular drive. There is an excellent public school about 10 minutes away which goes up to the of 6th grade (check school information independently). The Kinkaid School is one of the top three private schools in Houston and is a short 15 minutes away. The Houston Racquet Club is about 10 minutes away and has over 30 tennis courts, a children’s pool and an adult only pool. Drive by this beautiful building site within the neighborhood of stately homes.' ,`Acres` = '0.1845' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Tanglewood Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 51 BLK 64 TANGLEWOOD SEC 19' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8036' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tanglewood Sec 19' ,`TaxAmount` = '26390' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706359' WHERE `Matrix_Unique_ID` = '210337541' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T14:54:16.147' ,`MLSNumber` = '91573976' ,`ListAgentFullName` = 'Nicole Adams' ,`ListOfficeName` = 'BHGRE Hometown' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.155943' ,`Longitude` = '-96.372120' ,`PhotoCount` = '21' ,`PostalCode` = '77833' ,`RoomCount` = '6' ,`ListPrice` = '270000.00' ,`Status` = 'Active' ,`StreetName` = 'Maize' ,`StreetNumber` = '1917' ,`StreetSuffix` = 'Court' ,`City` = 'Brenham' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1276' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming home situated on a premium oversized cul-de-sac lot! This single story, 3 bedroom home features open living spaces, high ceilings, granite countertops in the kitchen & both bathrooms, vinyl plank floors, 2\" blinds throughout & a huge backyard. The kitchen boasts stainless steel appliances, undermount sink, a breakfast bar that provides extra seating space, and it opens directly to the dining area & family room. The private master retreat offers dual sinks, a soaking tub & separate shower. This house sits at the end of a cul-de-sac and has large yard both front and back. Ralston Creek is a charming community located off of Blue Bell Rd and only minutes away from Historic Downtown & Highway 290 for easy commuting. The community is built around gorgeous creeks and walking paths.' ,`Acres` = '0.23' ,`Area` = '58' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S4885 - RALSTON CREEK ESTATES, BLOCK 9, LOT 9, ACRES 0.23' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '10019' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '137 - Brenham' ,`SchoolElementary` = 'BISD DRAW' ,`SchoolHigh` = 'BRENHAM HIGH SCHOOL' ,`SchoolMiddle` = 'BRENHAM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ralston Creek Estates' ,`TaxAmount` = '3983' ,`TaxRate` = '2.0369' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663706360' WHERE `Matrix_Unique_ID` = '210656974' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T15:53:35.933' ,`MLSNumber` = '78293504' ,`ListAgentFullName` = 'Craig Jones' ,`ListOfficeName` = 'Eastex Real Estate Brokerage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.708858' ,`Longitude` = '-95.075373' ,`PhotoCount` = '22' ,`PostalCode` = '77351' ,`RoomCount` = '4' ,`ListPrice` = '799000.00' ,`Status` = 'Active' ,`StreetName` = 'Schmidt LN' ,`StreetNumber` = '231' ,`StreetSuffix` = 'Lane' ,`City` = 'Livingston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3338' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rare find! 2+- unrestricted acres on Lake Livingston with 200+- of canal front. The main house is a large 3338sq ft home with an indoor pool and a lot of porch space and a 2-car garage and additional storage building. This property is a perfect fit for a VRBO with a large back yard and boat house. The main lake is just a short boat ride away. There is plenty of room for a lot of guests with the large back deck! The home sits on half of the property and the other half could be used for additional homes or shop buildings. A concrete driveway leads you to the home and the home.' ,`Acres` = '2' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 81 J B WINN SURVEY TRACT 3' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '87120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'NA' ,`TaxAmount` = '16292' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706360' WHERE `Matrix_Unique_ID` = '211052727' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T15:28:44.527' ,`MLSNumber` = '49897821' ,`ListAgentFullName` = 'Kevin Sechelski' ,`ListOfficeName` = 'Sky Real Estate Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.821869' ,`Longitude` = '-95.437822' ,`PhotoCount` = '18' ,`PostalCode` = '77018' ,`RoomCount` = '12' ,`ListPrice` = '1589000.00' ,`Status` = 'Active' ,`StreetName` = 'Du Barry' ,`StreetNumber` = '1502' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '4320' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location, Location, Location... Here is your chance to own a one-of-a-kind Modern Home by the Award Winning and 2-time Custom Builder of the Year Echo Custom Homes. This home is located across the Street from an Oak Forest Park. Selections are still being made so if under contract soon the new owners can work directly with our Echo Custom Homes design team. This Home has it all, Open Concept, Indoor/Outdoor Living, Game room off the back patio for ultimate entertainment. Contact us today and set up a meeting to learn more!' ,`Acres` = '0.1625' ,`Area` = '9' ,`BuilderName` = 'Echo Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 23 BLK 19 OAK FOREST SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7080' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'OAK FOREST ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Oak Forest Sec 02' ,`TaxAmount` = '8580' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663706360' WHERE `Matrix_Unique_ID` = '211191135' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T14:12:55.477' ,`MLSNumber` = '56668568' ,`ListAgentFullName` = 'Roscoe Ford' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.538318' ,`Longitude` = '-95.742990' ,`PhotoCount` = '50' ,`PostalCode` = '77469' ,`RoomCount` = '11' ,`ListPrice` = '399999.00' ,`Status` = 'Active' ,`StreetName` = 'Crescent Lake' ,`StreetNumber` = '7515' ,`StreetSuffix` = 'Court' ,`City` = 'Rosenberg' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3468' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful and spacious 4 Bedroom 3.5 baths, game room and media room. Recently remodeled kitchen with upgraded Kitchen Aid Appliances and Wine Cooler. Fresh Recent Paint and Porcelain Floors throughout the first floor. Remodeled Bathroom Upstairs. This is a must see before its gone! Walking trails community pool and splash pad.' ,`Acres` = '0.1791' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Short Sale' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'SUMMER LAKES SEC 1, BLOCK 2, LOT 29' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'WILLIAMS ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Summer Lakes Sec 1' ,`TaxAmount` = '9134' ,`TaxRate` = '2.8448' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663706360' WHERE `Matrix_Unique_ID` = '211292917' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T15:59:14.967' ,`MLSNumber` = '75793064' ,`ListAgentFullName` = 'Salvador Caballero' ,`ListOfficeName` = 'ListWithFreedom.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.536531' ,`Longitude` = '-95.397126' ,`PhotoCount` = '21' ,`PostalCode` = '77578' ,`RoomCount` = '10' ,`ListPrice` = '460000.00' ,`Status` = 'Active' ,`StreetName` = 'Duffy' ,`StreetNumber` = '3515' ,`StreetSuffix` = 'Lane' ,`City` = 'Manvel' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4169' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A MUST SEE THAT WON\'T LAST LONG!!! ALL BRICK HOME in like-new condition! The home\'s LARGE kitchen with granite counters and lots of storage is the focal point of this 5/4/2 on a HUGE corner lot. Dramatic high ceilings at entryway, wood floors at dining, master, formal dining and living areas. Master bedroom and a secondary bedroom on the ground floor and an additional 3 bedrooms, game room and theatre room on the second. Covered patio with big backyard for kids to play. Excellent location! Minutes to Hwy 288, Beltway 8, Medical Center, Downtown. Close to shopping mall, grocery stores and eateries.' ,`Acres` = '0.1968' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SOUTHFORK SEC 5 (A0540 A C H & B) BLK 3 LOT 17' ,`LotDesciption` = 'Corner' ,`LotSize` = '8573' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '540' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'RED DUKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHADOW CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MCNAIR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Southfork Sec 5 A0540 A C H &' ,`TaxAmount` = '7967' ,`TaxRate` = '2.8294' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706360' WHERE `Matrix_Unique_ID` = '211502371' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T15:32:40.367' ,`MLSNumber` = '64172319' ,`ListAgentFullName` = 'Raquel Ginebra' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.695656' ,`Longitude` = '-95.241515' ,`PhotoCount` = '31' ,`PostalCode` = '77017' ,`RoomCount` = '4' ,`ListPrice` = '248500.00' ,`Status` = 'Active' ,`StreetName` = 'Christine' ,`StreetNumber` = '506' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1448' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Newly updated home! Beautiful modern look with an open concept floor plan. New luxury laminate vinyl plank flooring, new cabinets, and new granite! Gorgeous on the exterior as well as inside. You will not want to miss this Houston gem!' ,`Acres` = '0.1515' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 35 BLK 39 OAK MEADOWS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'RUCKER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CHAVEZ HIGH SCHOOL' ,`SchoolMiddle` = 'STEVENSON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Meadows Sec 02' ,`TaxAmount` = '2386' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706360' WHERE `Matrix_Unique_ID` = '211542620' --> 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','211863667','1663706360','211863667','2022-09-03T15:11:54.313','46393367','Jared Turner','LennarVillageBldr-JaredTurner','','','29.862964','-94.895184','6','77523','11','410000.00','Active','Augusta','14819','Avenue','Mont Belvieu','3','1','5','2721','Single-Family','BRAND NEW CONSTRUCTION by Lennar Homes, Wildflower Collection \'\'Dewberry II\" Elevation \"A\" in South Lakes! This spacious two-story home offers an inviting foyer that flows into the family room with an adjoining breakfast nook. The open kitchen features bar seating and overlooks the family room. Nearby is the owner’s suite which includes an en suite bathroom and a large walk-in closet. Upstairs are more bedrooms, bathrooms and a game room.','','53','Lennar Homes','','','','Mud','','','','Chambers County West','Central Gas','1','SEC 0001 BLK 005 LOT 002','Subdivision Lot','','','','450','1','To Be Built/Under Construction','3','','0','','','','','Composition','6 - Barbers Hill','BARBERS HILL NORTH ELEMENTARY SCHOOL','BARBERS HILL HIGH SCHOOL','BARBERS HILL NORTH MIDDLE SCHOOL','Accompany,Appointment Required','Builder','2','Traditional','South Lakes','','2.309','Water District','2023','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T14:12:10.703' ,`MLSNumber` = '25586144' ,`ListAgentFullName` = 'Brandy Mayr' ,`ListOfficeName` = 'RE/MAX Northwest, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.198977' ,`Longitude` = '-96.021701' ,`PhotoCount` = '25' ,`PostalCode` = '77445' ,`RoomCount` = '3' ,`ListPrice` = '302480.00' ,`Status` = 'Active' ,`StreetName` = 'Pin Oak' ,`StreetNumber` = '26579' ,`StreetSuffix` = 'Drive' ,`City` = 'Hempstead' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1772' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'All room measurements and school zoning to be verified by buyer. If you enter \"Deerwood Lakes\" into your GPS it will take you directly to the model home. The model home is open Thursday thru Saturday10-5 and Sunday 12-5 MOST weeks. Please text or email me BEFORE you bring your clients to confirm that either I or my assistant will be at the model.' ,`Acres` = '0.2344' ,`Area` = '26' ,`BuilderName` = 'Freedom Star Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Waller' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S455200 DEERWOOD LAKES 2 LOT 224' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '10210' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '110' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'FIELDS STORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Deerwood Lakes' ,`TaxAmount` = '300' ,`TaxRate` = '2.0243' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663706360' WHERE `Matrix_Unique_ID` = '211987013' --> 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','212163742','1663706361','212163742','2022-09-03T15:57:30.460','71784076','Pamela DeBlasio','Lake Homes Realty, LLC','','','30.682902','-95.035657','42','77351','9','1200000.00','Active','Woodhead','120','Circle','Livingston','2','1','4','3439','Single-Family','Beautifully understated, open waterfront home with stunning sunset views. This home was made for entertaining inside and out but cozy enough for two. Straight through the front door the lake view awaits. Open-concept, spacious living, kitchen, dining spaces with wood-look tile throughout. Big bedrooms, large home office perfect for overflow guests and huge game room. OUTSIDE IS WHERE THE PARTY IS...huge flagstone covered patio \"Palapa\" style, complete with wine fridge, utility fridge, dishwasher and two sinks spread out between 3 granite topped islands. Outdoor access only bathroom and separate shower for convenience. AND...in-ground pool overlooking the lake that is just the icing on the cake. Enjoy the large boathouse with boat and jet ski lifts, covered and uncovered decks all finished out with composite decking for easy maintenance. This lake home has it all! Call today for an appointment!','0.0067','44','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Lake Livingston Area','Central Electric','1','OAK TERRACE ESTATES SECTION 1 LOT 14, 15 & .231 AC OF RESERV','Cleared,Subdivision Lot,Water View,Waterfront','','Appraisal District','','25','0','','2','Electric Oven','1','Gunite,In Ground','','Electric Range','','Composition','103 - Livingston','LISD OPEN ENROLL','LIVINGSTON HIGH SCHOOL','LIVINGSTON JUNIOR HIGH SCHOOL','Accompany,Appointment Required','Appraisal District','1','Traditional','Oak Terrace Estates','15156','1.8745','Aerobic,Public Water','2000','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','212165052','1663706361','212165052','2022-09-03T15:09:36.753','87594004','Robert Saji','Zameen Realty','','','29.403592','-95.047895','22','77568','6','259999.00','Active','Nautica Terrace','2317','Drive','Texas City','2','0','3','1666','Single-Family','Welcome to Seacrest; originally part of Lago Mar but divided to be its own neighborhood. This home is 3 bedrooms and 2 baths and is one of the more sought out floor plans. The master area is at the back of the home and the guest bedrooms have their own hallway for access. Large living area and separate dining area make this the ideal family home. You will notice no back neighbors when you enjoy the backyard. Come check this wonderful home out. You will want to make it yours.','0.1377','33','','','','','Sellers Disclosure','','','','Texas City','Central Electric','1','LOT 5 BLK 1 SEACREST SEC 2 (2018) ABST 11','Subdivision Lot','6000','Appraisal District','','365','0','','2','','0','','','','','Composition','17 - Dickinson','LOBIT ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','LOBIT MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Seacrest Sec 2','8254','3.5512','Public Sewer,Public Water','2019','Appraisal District'); --> New record created successfully