Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)<br>Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)<br>Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)<br>Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)<br>Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)<br>Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)<br>Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)<br>Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)<br>Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)<br>Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)<br>Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)<br>Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)<br>Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)<br>Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)<br>Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)<br>Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)<br>Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)<br>Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)<br>Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)<br>Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)<br>Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)<br>Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)<br>Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)<br>Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)<br>Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)<br>Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)<br>Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)<br>Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)<br>Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)<br>Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)<br>Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)<br>Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)<br>Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)<br>Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)<br>Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)<br>Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)<br>Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)<br>Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)<br>Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)<br>Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)<br>Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)<br>Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)<br>Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)<br>Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)<br>Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)<br>Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)<br>Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)<br>Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)<br>Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)<br>Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)<br>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)<br>Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)<br>Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)<br>Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)<br>Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)<br>Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)<br>Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)<br>Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)<br>Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)<br>Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)<br>Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)<br>Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)<br>Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)<br>Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)<br>Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)<br>Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)<br>Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)<br>Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-28T14:26:48.300' ,`MLSNumber` = '93605078' ,`ListAgentFullName` = 'Dana Olejniczak' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.028909' ,`Longitude` = '-95.223977' ,`PhotoCount` = '50' ,`PostalCode` = '77339' ,`RoomCount` = '18' ,`ListPrice` = '2999050.00' ,`Status` = 'Active' ,`StreetName` = 'Deer Ridge Estates' ,`StreetNumber` = '1' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Kingwood' ,`BathsFull` = '6' ,`BathsHalf` = '2' ,`BedsTotal` = '7' ,`SqFtTotal` = '9374' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A magnificent showcase estate named \"Las Tierras Altas\", resting on 2 acres in the 24 hour manned gated community of Deer Ridge Estates, boast artistic design and craftmanship built into every room and detail. Entering into the expansive double doors, you will be stunned by views through panel glass walls to the stone paved courtyard revealing 3 large multi-tiered pools, cascading waterfalls, multi level gardens topped by a grand scale pavilion all as the center point of the incredible layout designed for relaxation and resort style living. Using natural materials, sculpted fixtures and hand carved surfaces, all creates a warm and inviting home which was designed and built for a healthy and active lifestyle with exercise room, lap pool, and steam room. Step through unique Indonesian doors to a wonderful refuge in your own personal wine cellar. The Primary retreat is a luxury escape. The Casitas boast a living room, full kitchen and large bedroom. Such a nature lovers private estate.' ,`Acres` = '' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '6' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 & 5 BLK 3  DEER RIDGE ESTATES SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '79388' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '13750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '6' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'FOSTER ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Deer Ridge Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Well' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704092' WHERE `Matrix_Unique_ID` = '206836243'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-28T15:20:23.190' ,`MLSNumber` = '84404424' ,`ListAgentFullName` = 'Mohamed Abdelbaky' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.091510' ,`Longitude` = '-95.484149' ,`PhotoCount` = '26' ,`PostalCode` = '77389' ,`RoomCount` = '9' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Fenway Park' ,`StreetNumber` = '4423' ,`StreetSuffix` = 'Way' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2880' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great location near Exxon and HP Headquarter. 1.5 story with 4 bedrooms and 3 full bathrooms. Fresh paint throughout the house, new carpet and many new upgrades. The dining room is just off the main entry of the home and features high ceilings, chair railing and a picture window. Open floorplan for the kitchen, breakfast room and family room. The kitchen features granite counters and middle island. A separate hallway leads to the secondary bedroom\'s & bath with tub/shower combo. The family features a media niche, windows with 2-inch blinds overlooking the backyard and the hall leading to the primary bedroom. The primary bedroom has an En-suite bath with separate shower and tub. Upstairs is a huge Gameroom great for family entertaining and the fourth bedroom which could be used as a  guest bedroom with an adjacent full bath. The backyard has a covered patio and sprinkler system. Buyer to verify all dimensions.\r\nThe house is also listed for rent at $2,650/month.' ,`Acres` = '0.1377' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 3 PARK AT KLEIN SEC 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '575' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'ZWINK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'HILDEBRANDT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Park/Klein Sec 1' ,`TaxAmount` = '8018' ,`TaxRate` = '3.0041' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704092' WHERE `Matrix_Unique_ID` = '208197221'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-28T14:31:56.920' ,`MLSNumber` = '89744441' ,`ListAgentFullName` = 'Amy Dupont' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.797549' ,`Longitude` = '-95.354548' ,`PhotoCount` = '34' ,`PostalCode` = '77009' ,`RoomCount` = '6' ,`ListPrice` = '499999.00' ,`Status` = 'Active' ,`StreetName` = 'Finch' ,`StreetNumber` = '1317' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2250' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rare opportunity to purchase a 2-story home in the Northside/Lindale area equipped with 3 bedrooms, 3.5 bath, fenced yard space, outdoor patio for entertaining, and a 2nd floor balcony.This home shows like new construction with fresh paint throughout, beachwood oak engineered hardwood flooring,quartz kitchen/bathroom countertops, gas cooking, new(2022)kitchen backsplash,SS appliances,updated island light pendants and dining fixture, new(2022) black matte hardware throughout,updated living room accent wall, each bedroom has an ensuite bathroom each w/new tubs and gorgeous new tile and toilets.Oversized primary bedroom w/solar blinds, 2 ceiling fans,access to 2nd story balcony,primary bath offers a soaking tub, updated primary shower tile/sub-floor/shower pan, massive walk-in closet.Gutters 2019,Astroturf in yard(2020),rod iron fence for yard installed in 2019.Fantastic Airbnb and/or rental property!3 miles from the New East End River Development/phase 1 completion expected 2023!' ,`Acres` = '0.0727' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 DEVELOPMENT ON FINCH STREET' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3166' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOOSCAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Development/Finch Street' ,`TaxAmount` = '9373' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704092' WHERE `Matrix_Unique_ID` = '209125348'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-28T14:35:35.093' ,`MLSNumber` = '6019883' ,`ListAgentFullName` = 'Dana Olejniczak' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.029789' ,`Longitude` = '-95.226219' ,`PhotoCount` = '49' ,`PostalCode` = '77339' ,`RoomCount` = '14' ,`ListPrice` = '1695000.00' ,`Status` = 'Active' ,`StreetName` = 'Magnolia Woods' ,`StreetNumber` = '5' ,`StreetSuffix` = 'Drive' ,`City` = 'Kingwood' ,`BathsFull` = '4' ,`BathsHalf` = '3' ,`BedsTotal` = '5' ,`SqFtTotal` = '5878' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Here it is! A magnificent 1.5 story in a 24 hour manned gated community of Deer Ridge Estates.This spectacular home sprawled across an acre is private and features a fantastic outdoor kitchen stocked with Viking appliances including grill, oven, ice maker, warming drawer, refrigerator and a microwave. This wonderful outdoor kitchen and living space overlooks the sparkling pool and also has a half bath for convivence. The custom interior of this home features a chef\'s kitchen that is sure to be the heart of the family. The kitchen is complete with a Thermador cooktop, Sub Zero refrigerator, 2 sinks and a large eat in island. The butlers pantry and large wine grotto / serving area is perfect for a party or large gatherings. The Primary Suite is tucked away for privacy with an expansive bath, his/ her vanities, large tub overlooking a courtyard with a fountain, separate shower and fantastic closet. Upstairs you will find a large media/game room, kitchenette and private bedroom.' ,`Acres` = '' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 & 7 BLK 2 DEER RIDGE ESTATES SEC 1' ,`LotDesciption` = 'Corner,Subdivision Lot,Wooded' ,`LotSize` = '43360' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '6810' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'FOSTER ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Deer Ridge Estates' ,`TaxAmount` = '4544' ,`TaxRate` = '2.0083' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704092' WHERE `Matrix_Unique_ID` = '209639438'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-28T14:28:59.583' ,`MLSNumber` = '36109827' ,`ListAgentFullName` = 'Lisa Carnes' ,`ListOfficeName` = 'Carnes Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.797969' ,`Longitude` = '-95.387746' ,`PhotoCount` = '48' ,`PostalCode` = '77008' ,`RoomCount` = '3' ,`ListPrice` = '645000.00' ,`Status` = 'Active' ,`StreetName` = 'Studewood' ,`StreetNumber` = '1426' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1238' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A lovely Craftsman home in the heart of Historic Norhill is inviting from the moment you walk in, with easy access to everything the Heights has to offer. This Meticulously cared-for home has 2 bedrooms, one bath and a 3rd room that could easily be made into a 2nd bathroom in the main house, Plus a large bonus room/bedroom and bathroom on top of the oversized 2 car garage for a perfect guest ensuite or Gameroom, or Airbnb with extra storage spaces throughout both the home and garage. An electronic gate to enter the oversized driveway makes it easy to enter from the street, with extra parking for the entire family.\r\nThe updates are abundant in the kitchen which includes custom cabinets, x-beverage/wine fridge, an island with a gas cooktop. \r\nOutside amenities abound, with a spacious back deck, and a fully fenced backyard with room to play, expand, and garden.  This Unique home offers so many extra\'s inside and out. Call us to schedule your showing time.' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 BLK 112 NORTH NORHILL' ,`LotDesciption` = 'Cleared,Other' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'FIELD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Call Occupant,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'North Norhill Add' ,`TaxAmount` = '8496' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704092' WHERE `Matrix_Unique_ID` = '209879116'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-28T14:33:53.277' ,`MLSNumber` = '62581085' ,`ListAgentFullName` = 'William Dodson' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = 'Martin Ruiz' ,`SellingOfficeName` = 'CitiQuest Properties' ,`Latitude` = '29.822231' ,`Longitude` = '-95.422576' ,`PhotoCount` = '32' ,`PostalCode` = '77018' ,`RoomCount` = '13' ,`ListPrice` = '525000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Olde Bourbon' ,`StreetNumber` = '3803' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2860' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful recent construction by one of Houston\'s premier builders in burgeoning Oak Forest area. 3 bedrooms, all with ensuite baths.  Second floor open living with chef\'s kitchen offering Thermador and Samsung appliances, quartz counters, half bath and wiring for sound.  Gorgeous white oak flooring and plantation shutters throughout main living areas and bedrooms (no carpet).  Spacious outdoor living areas include two balconies and covered patio in the back.  All appliances may stay.  Automatic gate for development coming soon (already paid for).  Outstanding location in the ever-popular Oak Forest neighborhood, walkable to acclaimed d\'Alba Restaurant, Great Heights Brewing, Decant Urban Winery and much more.  Easy access to downtown.' ,`Acres` = '0.0413' ,`Area` = '9' ,`BuilderName` = 'Smith Family Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 1 BOURBON COURT' ,`LotDesciption` = 'Patio Lot,Subdivision Lot' ,`LotSize` = '1800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GARDEN OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Bourbon Court' ,`TaxAmount` = '9765' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704093' WHERE `Matrix_Unique_ID` = '211220944'  --> Updated record success<br />