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-23T01:22:01.040' ,`MLSNumber` = '66818177' ,`ListAgentFullName` = 'Tammie Bell' ,`ListOfficeName` = 'TBT Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.035607' ,`Longitude` = '-95.419197' ,`PhotoCount` = '35' ,`PostalCode` = '77531' ,`RoomCount` = '9' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Meadow Ridge' ,`StreetNumber` = '101' ,`StreetSuffix` = 'Way' ,`City` = 'Clute' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2851' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Woodshore! This is a beautiful 4 bedroom, 2.5 bathroom home with 2 living areas, media room and a screened in patio. The spacious kitchen opens up to the living room, making entertaining easy. Plenty of counter and cabinet space and an island. The primary room is down stairs with plenty of natural lighting. The master bathroom has double sinks, a separate shower and a soaker tub with a big walk-in closet. Enjoy all the space this home has to offer. Call today for your private showing.' ,`Acres` = '0.1868' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Clute' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WOODSHORE SEC 1 (A0066 J E GROCE) (CLUTE) BLK 11 LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8137' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'POLK ELEMENTARY SCHOOL (BRAZOSPORT)' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CLUTE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodshore' ,`TaxAmount` = '8400' ,`TaxRate` = '2.6231' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641479' WHERE `Matrix_Unique_ID` = '209594856' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T01:22:01.040' ,`MLSNumber` = '93797838' ,`ListAgentFullName` = 'Jay Schulz' ,`ListOfficeName` = 'Zarco Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.239755' ,`Longitude` = '-95.484597' ,`PhotoCount` = '33' ,`PostalCode` = '77384' ,`RoomCount` = '5' ,`ListPrice` = '646690.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Summit Dr' ,`StreetNumber` = '1010' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3054' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW EMERALD HOME located in gated section of Oak Estates at Jacobs Reserve and in the extremely sought-after Woodlands school zone! Located on NEALRY 1/4 ACRE just near Jones State Forest. 4 beds, 3.5 full bath home with MODERN charm featuring GOURMET kitchen w/ sleek quartz countertops featuring ISLAND, built-in Jenn-Aire appliances, double convection oven, & stunning grey cabinetry. Open to dining and family room w/ gas fireplace. French door office off the entryway & HIGH ceilings. HUGE 5-STAR RETREAT w/ sitting area, split vanities, oversized shower, and relaxing soaking tub. On-demand water heater and smart home features. Front porch & covered patio -- perfect for entertaining! JUST A FEW NEW HOME OPPROTUNITIES REMAIN!!! Amazing property tax rate of 2.7488%.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Emerald Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S748402 - Oak Estates At Jacobs Reserve 02, Block 01, Lot 34' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10129' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1195' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GALATAS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Oak Estates at Jacob\'s Reserve' ,`TaxAmount` = '' ,`TaxRate` = '2.7488' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669641479' WHERE `Matrix_Unique_ID` = '211422962' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T01:22:01.040' ,`MLSNumber` = '50537796' ,`ListAgentFullName` = 'Charity Yarborough' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.737996' ,`Longitude` = '-95.420727' ,`PhotoCount` = '49' ,`PostalCode` = '77098' ,`RoomCount` = '11' ,`ListPrice` = '2650000.00' ,`Status` = 'Active' ,`StreetName` = 'Virginia' ,`StreetNumber` = '3007' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '6001' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This fabulous soft contemporary home is located in the desirable Upper Kirby District. This show stopping home has it all, starting w/impressive curb appeal & dynamic open concept floor plan featuring high ceilings & walls of windows & doors.The wide entrance foyer is flanked by lovely formal rooms & leads into the huge great room w/a fireplace & large chef-ready kitchen & breakfast area, perfect for entertaining cozy dinner parties or large functions. The spacious gourmet kitchen w/top line SS appliances features a Thermador full size wine fridge and Butler\'s pantry w/ wet bar. Dramatic staircase leads to an upstairs living area, enormous owner\'s retreat w/ sitting area & large balcony and fireplace, spa like bath w/a large shower & deep soaking tub, 2 water closets & separate walk in closets & dual vanities. 3 additional bedrooms w/ensuite baths. The outdoor living room & deluxe kitchen are complete w/wood-burning pizza oven, gas grill, wet-bar, cascading fountain wall & outdoor FP!!' ,`Acres` = '0.1791' ,`Area` = '16' ,`BuilderName` = 'Blackstone Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Upper Kirby' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 6 DAVID CROCKETT R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Grill' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'POE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'David Crockett 02 Rep' ,`TaxAmount` = '48455' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641479' WHERE `Matrix_Unique_ID` = '212251256' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T01:03:04.287' ,`MLSNumber` = '76285375' ,`ListAgentFullName` = 'Rayito Stephens' ,`ListOfficeName` = 'Real Properties of Texas, PLLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.841418' ,`Longitude` = '-95.682924' ,`PhotoCount` = '31' ,`PostalCode` = '77084' ,`RoomCount` = '9' ,`ListPrice` = '389990.00' ,`Status` = 'Active' ,`StreetName` = 'Longmoor' ,`StreetNumber` = '18335' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3113' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful custom home in fantastic community with mature trees. Stately, located on quiet cul de sac lot with approx.3,113 sq. ft. 4 bedrooms (two with built in desks), 3.5 baths, 2 car detached garage. New carpeting throughout. Master on 1st floor with custom walk in jetted tub, separate shower, double closets and sinks. Kitchen has Chef\'s Cooktop on island with granite countertops, open to breakfast with a beautiful bay window view of the backyard. Large walk in pantry. Great home for entertaining. Three bedrooms and gameroom upstairs with two full baths. Two bedrooms have built in desks and shelves, and living area, gameroom, and study/office have cabinets with shelves above. Formal dining room, Spacious office/study/library by main entry. Beautiful wood and mosaique flooring downstairs with carpet in downstairs master. Gazebo in the back. Community Pool, walking trails, close shopping, easy commute. LOW TAXES! Estimated room measurements.' ,`Acres` = '0.2652' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 47 DEERFIELD VILLAGE SEC 5' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '11551' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '835' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WILSON ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'WATKINS MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Deerfield Village Sec 05' ,`TaxAmount` = '6079' ,`TaxRate` = '2.251' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641479' WHERE `Matrix_Unique_ID` = '212668677' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T01:22:01.040' ,`MLSNumber` = '12405562' ,`ListAgentFullName` = 'Olga Lozano' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.792413' ,`Longitude` = '-94.949210' ,`PhotoCount` = '49' ,`PostalCode` = '77521' ,`RoomCount` = '8' ,`ListPrice` = '1399000.00' ,`Status` = 'Active' ,`StreetName` = 'Archer' ,`StreetNumber` = '1321' ,`StreetSuffix` = 'Road' ,`City` = 'Baytown' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4780' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stately custom built home set on 7.91 acres offers plenty of living space with country sized backyard! Upon entry, you\'re greeted with a wall of windows that flood the home with natural light & beautiful views of your lush backyard! Home offers 4 bedrooms, primary wing located downstairs, and 3 bedrooms upstairs with a flex space that could also work as a fifth bedroom. All bedrooms offer ensuite bathrooms along with walk-in closets. Chef’s kitchen overlooks the family room and offers the perfect backdrop for all your family gatherings. Home offers great flow for your entertaining needs. Two balconies, a covered patio area, and a porte-cochere are just a few of the features this home has to offer. The backyard has tons of potential and is only limited to your imagination. A pond can also be found in the middle of the property! Home offers a three-car garage and ample parking space for your guests. Schedule your appointment today!' ,`Acres` = '7.91' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 LEYVAS' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '344559' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'LEYVAS' ,`TaxAmount` = '24636' ,`TaxRate` = '2.285' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641479' WHERE `Matrix_Unique_ID` = '213343900' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T01:22:01.040' ,`MLSNumber` = '32837480' ,`ListAgentFullName` = 'Peter Techmanski' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.624280' ,`Longitude` = '-95.738866' ,`PhotoCount` = '27' ,`PostalCode` = '77406' ,`RoomCount` = '17' ,`ListPrice` = '489000.00' ,`Status` = 'Active' ,`StreetName` = 'Plantation' ,`StreetNumber` = '2102' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3140' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Architect Charles L. Smith custom-designed home for longtime Pecan Grove resident; current Seller is 2nd owner. Built in 1981, this 3BR, 2-story brick home showcases a nature-rich siting, with views panning the adjacent PGPCC. Bucolic vistas extend beyond a knee-high brick-walled patio, across uninterrupted lawns and a tree grove set amidst jasmine, to arrive at a duck pond. Inside, first floor includes large Primary BR, LR with Fireplace and window-walled Sun Room, all focused toward this Serene Setting. Parquet floored Formal Dining, Wood Paneled Study and a fully equipped Utility Room complete the First Level. Upstairs, 2 BRs share a TV Play area and generous-sized Hollywood bathroom. Recent updates include white floor tiling throughout; kitchen remodel with quartz counters and stainless appliances; 2 Carrier brand HVAC systems and new water heater. Transferable Warranty for comprehensive 2018 foundation re-stabilizing. Circle drive leads to 3-car garage; room for pool in backyard.' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PECAN GROVE PLANTATION SEC 1, BLOCK 10, LOT 18' ,`LotDesciption` = 'On Golf Course,Water View' ,`LotSize` = '13820' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '209' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PECAN GROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'BOWIE MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pecan Grove Plantation' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641480' WHERE `Matrix_Unique_ID` = '213462710' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T01:22:01.040' ,`MLSNumber` = '90412643' ,`ListAgentFullName` = 'Chad Peltier' ,`ListOfficeName` = 'Peltier Home And Ranch Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.221398' ,`Longitude` = '-95.352781' ,`PhotoCount` = '37' ,`PostalCode` = '77534' ,`RoomCount` = '10' ,`ListPrice` = '875000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 171' ,`StreetNumber` = '16337' ,`StreetSuffix` = '' ,`City` = 'Danbury' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3403' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spectacular country estate, featuring an amazing air conditioned 40\' x 60\' shop, 40\' x 20\' RV/boat storage, and carport/canopy length of building (engineered steel building).\r\nPrivacy, security and comfort are what the homeowners will enjoy every day. Extremely convenient to Brazosport (Freeport, Lake Jackson) area as well as Angleton. \r\nClose enough to Houston for a daily commute, while being far enough to enjoy the serenity of the country.\r\nVery large saltwater pool, 9\' deep end, with dedicated pool house for equipment. Large Hot tub located under Pergola.\r\nExtensive fencing/access gates, mature trees, flagpole, and stunning soffit lighting.\r\nOversized owners retreat, large family rooms (2), many updated fixtures including Fisher and Paykel dishwasher.' ,`Acres` = '3.3992' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Danbury' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0013 HENRY AUSTIN TRACT 4A7-4A8 (CALLED LOTS 6-7) ACRES 3.' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '148069' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '15 - Danbury' ,`SchoolElementary` = 'DANBURY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DANBURY HIGH SCHOOL' ,`SchoolMiddle` = 'DANBURY MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Henry Austin' ,`TaxAmount` = '13234' ,`TaxRate` = '2.2192' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641480' WHERE `Matrix_Unique_ID` = '213758474' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T01:22:01.040' ,`MLSNumber` = '53105478' ,`ListAgentFullName` = 'Madeline Phillips' ,`ListOfficeName` = 'Premier Property Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.758709' ,`Longitude` = '-94.960801' ,`PhotoCount` = '46' ,`PostalCode` = '77351' ,`RoomCount` = '4' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Robinson Tract' ,`StreetNumber` = '175' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2432' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! Located in the highly sought-after area of 350 N lies this attractive 4bed/2.5 bath situated on just under one acre! This home features a vaulted ceiling in the living area with a wood burning fireplace, amazing country kitchen with breakfast area, and oversized bedrooms throughout! Concrete circle driveway features tons of parking space-fenced backyard- shop with electric- attached carport- and so much more! Ideal family home in a great subdivision! No HOA! Don\'t miss this one!' ,`Acres` = '0.835' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 9 JOHN D BURKS SURVEY TRACT 55-4 (THE TRACE) LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '36373' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Right Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Trace' ,`TaxAmount` = '4970' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641480' WHERE `Matrix_Unique_ID` = '214005963' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T01:22:01.040' ,`MLSNumber` = '17830321' ,`ListAgentFullName` = 'Lisa Kornhauser' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.693750' ,`Longitude` = '-95.468363' ,`PhotoCount` = '34' ,`PostalCode` = '77401' ,`RoomCount` = '16' ,`ListPrice` = '1749000.00' ,`Status` = 'Active' ,`StreetName` = 'Valerie' ,`StreetNumber` = '5102' ,`StreetSuffix` = 'Street' ,`City` = 'Bellaire' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5164' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t miss this 5/6 bedroom home situated on a \"half-acre\" lot in Bellaire\'s most esteemed area, Braeburn Country Club Estates! This move-in ready home offers an exceptional floor plan! On the 1st floor you\'ll find a grand entrance w/dramatic staircase, private office/library, game room, formal dining & living room, an open plan family room & kitchen w/eat in breakfast area. The large first floor game room w/en-suit bathroom could serve as an in-law suite (6th bedroom). The second floor features 5 bedrooms plus a study desk & second floor loft area, perfect for games & reading. The primary bedroom suite w/vaulted ceilings includes a spacious bathroom, large walk-in closet & private balcony. The huge backyard provides a private setting w/two covered patios, a beautiful pool, large mature trees & plenty of green space left over for pets and play. Additional features include a sport court situated behind a double wide driveway gate & mosquito system, excellent storage & more! No flooding!' ,`Acres` = '0.4339' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bellaire Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BRAEBURN CNTRY CLUB ESTS SEC B' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '18900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CONDIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Braeburn Cntry Club Estates Se' ,`TaxAmount` = '36169' ,`TaxRate` = '2.2271' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641480' WHERE `Matrix_Unique_ID` = '214518592' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T01:22:01.040' ,`MLSNumber` = '46632648' ,`ListAgentFullName` = 'Debbie Levine' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.702015' ,`Longitude` = '-95.420971' ,`PhotoCount` = '26' ,`PostalCode` = '77025' ,`RoomCount` = '9' ,`ListPrice` = '799000.00' ,`Status` = 'Active' ,`StreetName` = 'Glen Haven' ,`StreetNumber` = '2714' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '3194' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated home with pool in sought after Cambridge Green. This home is situated on a charming courtyard and features spacious living area with wood burning fireplace and plantation shutters, gourmet kitchen with custom cabinetry and granite countertops, large primary suite with sitting area and spa-like bath, study with new bamboo flooring, flex space, updated secondary bath, new carpet and recent paint. Other great features include a backyard oasis with heated pool and spa, new roof and recent PEX plumbing lines. This home is in a fabulous location in close proximity to Rice Village, The Medical Center and Downtown.' ,`Acres` = '0.1377' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Braeswood Place' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 1 & 1/29 INT COMMON ELE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'TWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cambridge Green' ,`TaxAmount` = '14390' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641481' WHERE `Matrix_Unique_ID` = '214535213' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T02:08:54.303' ,`MLSNumber` = '58107081' ,`ListAgentFullName` = 'Jimmy Zarate' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.086986' ,`Longitude` = '-97.303544' ,`PhotoCount` = '13' ,`PostalCode` = '76501' ,`RoomCount` = '4' ,`ListPrice` = '120000.00' ,`Status` = 'Active' ,`StreetName` = 'Adams' ,`StreetNumber` = '3415' ,`StreetSuffix` = 'Avenue' ,`City` = 'Temple' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1368' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'TLC Needed. Investor Special. A perfect starter home with the right updates can become an income-producing property for the right buyer. Almost 2 Acre lot! Buyer to verify all information.' ,`Acres` = '1.96' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0014BC M MORENO, 165-1, OB 959-B, ACRES 1.96' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '85378' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '965 - Temple' ,`SchoolElementary` = 'HECTOR P. GARCIA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TEMPLE HIGH SCHOOL' ,`SchoolMiddle` = 'BONHAM MIDDLE SCHOOL (TEMPLE)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'N/a' ,`TaxAmount` = '2390' ,`TaxRate` = '2.5132' ,`WaterSewer` = 'Public Sewer,Well' ,`YearBuilt` = '1947' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641481' WHERE `Matrix_Unique_ID` = '214657235' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T01:22:01.040' ,`MLSNumber` = '12576540' ,`ListAgentFullName` = 'Ruthie Porterfield' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.709485' ,`Longitude` = '-95.426167' ,`PhotoCount` = '36' ,`PostalCode` = '77005' ,`RoomCount` = '10' ,`ListPrice` = '1195000.00' ,`Status` = 'Active' ,`StreetName` = 'Vanderbilt' ,`StreetNumber` = '6542' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2439' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This absolutely charming 4 bedroom, 3 bath home is a rare find in West U and features a great floor plan with generous rooms filled with natural light & a spacious back yard! The living room with gas log fireplace & hardwood floors opens to a sitting area w/ double height windows. Large dining room, ideal for small or large gatherings. A wonderful island kitchen with tons of counter & cabinet space opens to the breakfast room with views of the back yard. The upstairs primary suite has a walk-in closet with built-ins, a large bathroom w/ double sinks, tub & walk-in shower and direct access to a wrap-around balcony overlooking the back yard, perfect for relaxing before bedtime. Two spacious secondary bedrooms upstairs with walk-in closets plus a third bedroom downstairs which would make a great study! Recent updates include HardiePlank house siding, tankless water heater and deck. Beautiful upgraded back yard with turf & landscape lighting, perfect for pets, play & entertaining!' ,`Acres` = '' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West University/Southside Area' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'TR 1C BLK 11 WEST UNIVERSITY PLACE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WEST UNIVERSITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'West University' ,`TaxAmount` = '18155' ,`TaxRate` = '2.0584' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1934' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641481' WHERE `Matrix_Unique_ID` = '214668399' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T01:22:01.040' ,`MLSNumber` = '55728146' ,`ListAgentFullName` = 'Diane Schrakamp' ,`ListOfficeName` = 'Honeywood Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.918298' ,`Longitude` = '-95.171942' ,`PhotoCount` = '46' ,`PostalCode` = '77044' ,`RoomCount` = '13' ,`ListPrice` = '540000.00' ,`Status` = 'Active' ,`StreetName` = 'Hawkins' ,`StreetNumber` = '13134' ,`StreetSuffix` = 'Bend' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '4539' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 6-bedroom, 3.5-bathroom Taylor Morrison home (Riviera Plan) in highly desirable Summerwood. You will love the 2-story entry & wood floors! To the right is the home office. To the left, the large formal dining room. The kitchen is spacious with granite countertops, stainless appliances, gas cooktop, big island, butler\'s pantry & walk in pantry. The kitchen overlooks the 2-story living room w/corner gas log fireplace. The master suite (downstairs) is HUGE & has a door that opens to the back patio. The master bathroom has dbl sinks, soaker tub, separate walk-in shower (mud set), & 2 large walk in closets. Upstairs-5 additional bedrooms, 2 additional bathrooms, Gameroom, media room, and balcony that overlooks a huge backyard (ready for a pool) w/ NO BACK NEIGHBORS! Tankless water heater, water softener, irrigation system, energy star appliances, pex plumbing. 3 car tandem garage! Close to IAH, Beltway 8, HWY 69, Lake Houston, & restaurants/schools.' ,`Acres` = '0.265' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 3 SUMMERWOOD SEC 33' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '11545' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '916' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'SUMMERWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Summerwood' ,`TaxAmount` = '12790' ,`TaxRate` = '2.7932' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669641481' WHERE `Matrix_Unique_ID` = '214806717' --> 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','215036461','1669641482','215036461','2022-11-23T02:00:06.240','89808907','Leon Castro','Compass RE Texas, LLC','','','29.968987','-95.379509','36','77073','8','239000.00','Active','Stonehedge','17335','Drive','Houston','2','0','4','1787','Single-Family','Great looking one story located in the Stonehedge community. Home features 4 bedrooms, and 2 full baths with a 2 car garage. 4th bedroom can be used as an office or bedroom (has a closet). Home is very spacious with high ceilings and big windows that let in plenty of natural lighting. The living area includes an open layout to the kitchen and breakfast area. The spacious kitchen offers lots of counter space & storage, includes appliances such as a microwave, a dishwasher and a gas range. The community has 3 lakes, a playground and walking trails. The home is located near three major freeways such as Hardy, beltway 8 and 45. It also has access to the George Bush airport. Must see....schedule your appointment today !!! **NEVER FLOODED**','0.126','12','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Exclusions,Sellers Disclosure','1','','0','Aldine Area','Central Gas','1','LT 13 BLK 8 STONEHEDGE','Subdivision Lot','5490','Appraisal District','','533','0','','2','Gas Oven','0','','','Gas Range','','Composition','1 - Aldine','PARKER ELEMENTARY SCHOOL (ALDINE)','NIMITZ HIGH SCHOOL (ALDINE)','TEAGUE MIDDLE SCHOOL','Appointment Required,Leave Business Card','Appraisal District','1','Traditional','Stonehedge','4944','2.5707','Public Sewer,Public Water','2013','Appraisal District'); --> New record created successfully