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-13T06:42:53.280' ,`MLSNumber` = '9778717' ,`ListAgentFullName` = 'Clinton Omiwade' ,`ListOfficeName` = 'ERA Legacy Living' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.750740' ,`Longitude` = '-95.610840' ,`PhotoCount` = '35' ,`PostalCode` = '77077' ,`RoomCount` = '11' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Beaconshire' ,`StreetNumber` = '1678' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3129' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home located at Stonehenge, this corner lot home has 4 beds and 2.5 baths. 2 car attached garage with concrete driveway. Huge living room with high ceiling & fireplace. Tile floor on living, kitchen & dining room. Carpet on all rooms upstairs. Master bed on 1st floor w/ stunning master bath. Den upstairs with fireplace as well. Backyard patio converted to theater adds coziness while relaxing.' ,`Acres` = '0.1199' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 STONEHENGE SEC 3 U/R R/P' ,`LotDesciption` = 'Corner,Patio Lot' ,`LotSize` = '5225' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '798' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DAILY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stonehenge Sec 03 U/R R/P' ,`TaxAmount` = '7835' ,`TaxRate` = '2.4216' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418581' WHERE `Matrix_Unique_ID` = '198858928' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T06:56:40.773' ,`MLSNumber` = '18610564' ,`ListAgentFullName` = 'Brandi Bertrand' ,`ListOfficeName` = 'Doug Erdy Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.162702' ,`Longitude` = '-94.930745' ,`PhotoCount` = '30' ,`PostalCode` = '77535' ,`RoomCount` = '9' ,`ListPrice` = '130000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 2341' ,`StreetNumber` = '19' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1280' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cozy 3 bedroom\'s 2 full bath manufactured home sitting on a cleared corner lot beautifully located on 1.094 acres of land. Home has been well taken care of. Recent upgrades: Fresh interior & exterior paint, recent roof & new flooring. The home has never flooded.' ,`Acres` = '1.094' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Dayton Oaks, Lot 164, Acres 1.094 (SEE 2ND TAX ID INFO)' ,`LotDesciption` = 'Cleared,Corner,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (DAYTON)' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Dayton Oaks' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank,Water District,Well' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1668418581' WHERE `Matrix_Unique_ID` = '209558595' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T06:43:12.967' ,`MLSNumber` = '36502097' ,`ListAgentFullName` = 'Clinton Omiwade' ,`ListOfficeName` = 'ERA Legacy Living' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.006921' ,`Longitude` = '-95.153783' ,`PhotoCount` = '46' ,`PostalCode` = '77346' ,`RoomCount` = '9' ,`ListPrice` = '565000.00' ,`Status` = 'Active' ,`StreetName` = '12th Fairway' ,`StreetNumber` = '8118' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3096' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous one-story, 3,096 sqft home in a great location ! This home features beautiful tile , and carpet floors through the whole house, stunning front entry with large beautiful kitchen, stunning countertops and so much more! Very spacious Main Living area With great Flooring. Large Sized Kitchen with a Open Concept. 3-car garage. Large backyard. House has been extensively taken care of. Located close to multiple grocery options , schools , highways ,swimming pool, Lake Houston. You will be hard-pressed to find this unique open floor plan in this neighborhood. This home has everything you could ever want! This gem will not last long - schedule a showing' ,`Acres` = '0.2459' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Atascocita North' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 9 PINEHURST OF ATASCOCITA SEC 1' ,`LotDesciption` = 'On Golf Course' ,`LotSize` = '10710' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'PINEFOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pinehurst Af Atascocita Sec 01' ,`TaxAmount` = '8949' ,`TaxRate` = '2.216' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418581' WHERE `Matrix_Unique_ID` = '211432239' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T06:43:52.403' ,`MLSNumber` = '65251660' ,`ListAgentFullName` = 'Larry Mercer' ,`ListOfficeName` = 'RE/MAX Metro' ,`SellingAgentFullName` = 'Roland Rasos' ,`SellingOfficeName` = 'Keller Williams HoustonCentral' ,`Latitude` = '29.731620' ,`Longitude` = '-95.443411' ,`PhotoCount` = '19' ,`PostalCode` = '77027' ,`RoomCount` = '9' ,`ListPrice` = '649500.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Portsmouth' ,`StreetNumber` = '4110' ,`StreetSuffix` = 'Avenue' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1722' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Opportunity knocks! Great 4 bedroom, 2 bath, 1,722sf home on a beautiful 7,500sf lot with a gorgeous, mature tree in the front yard! Wonderful Inner-Loop location close to shopping, restaurants and services. Original hardwood floors in the living areas and original bedrooms. A Primary bedroom addition has laminate floors and walls of windows with an ensuite bath and walk-in closet. The well-sized kitchen with nice gas cooktop could be opened to the living room to create an open living area with kitchen, dining room and living room as one space. The large second bath has been updated and features a shower/tub. There is a detached 2-car garage in back next to the lovely, fenced back yard. New water heater (2022). Here\'s your chance to make a home the way you want it! Make your move today!' ,`Acres` = '0.1722' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Highland Village/Midlane' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 7 WESLAYAN PLAZA SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SCHOOL AT ST GEORGE PLACE' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Weslayan Plaza Sec 02' ,`TaxAmount` = '12139' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418581' WHERE `Matrix_Unique_ID` = '211842784' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T05:21:41.833' ,`MLSNumber` = '25876222' ,`ListAgentFullName` = 'Kelly Kelley' ,`ListOfficeName` = 'RE/MAX Leading Edge' ,`SellingAgentFullName` = 'Elizabeth Lopez' ,`SellingOfficeName` = 'REALM Real Estate Professional' ,`Latitude` = '29.201304' ,`Longitude` = '-94.939861' ,`PhotoCount` = '41' ,`PostalCode` = '77554' ,`RoomCount` = '6' ,`ListPrice` = '799000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Pelican' ,`StreetNumber` = '4234' ,`StreetSuffix` = 'Lane' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1456' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in the desirable 1st block of Pirates Beach with unobstructed Gulf views this updated single-story home will not disappoint. Improvements include Trex decking (2021), newer range (2021), vinyl plank flooring installed & subflooring replaced (2021), updated light fixtures, Corian countertops, freshly painted inside & out (2021), and electrical box replaced (2021). In 2005 the metal roof was put on and in 2006 all new windows & doors were installed. The home is currently set up to sleep 8 & offers plenty of closet space making this home ideal for a short-term rental, 2nd home, or full-time home. It is tastefully decorated & furnished, all of which convey. Buy this home and enjoy a coveted social membership at Galveston Country Club. You are just a short golf cart ride from the Club and a short drive to everything Galveston has to offer. Rental history available.' ,`Acres` = '0.1883' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 PAGE 46 LOT 81 PIRATES BEACH SEC 6' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot,Water View' ,`LotSize` = '8202' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '168' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Pirates Beach' ,`TaxAmount` = '10601' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418581' WHERE `Matrix_Unique_ID` = '212251135' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T05:23:54.740' ,`MLSNumber` = '50891040' ,`ListAgentFullName` = 'Val Arbona' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.036452' ,`Longitude` = '-95.645775' ,`PhotoCount` = '48' ,`PostalCode` = '77429' ,`RoomCount` = '8' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'Greenford Glen' ,`StreetNumber` = '15206' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2227' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A must-see Beauty -decked out in shades of white and loads of natural light. Start with the front door and walk into the Kitchen, Dining and Living area. Walk around the well-equipped Kitchen w/stainless appliances. Check out the generous counter space and large, granite island with room for counter height stools. Follow the wood-look tile floor toward the area with a warm fireplace, stunning light fixtures and accents -surely the heart of the home. The primary bedroom -separate from the secondary rooms- features en-suite Bath area and walk-in closet. Step in from the Garage to the convenient Drop Zone with bench and storage. Nearby notice the huge Laundry room is big enough for appliances and a Desk area. For down time there\'s an easy-to-maintain small sized lawn and relaxing covered Patio. Hayden Lakes subdivision features sidewalk bordered lakes, Pool and Play area and dog park - designed for enjoying the outdoors and located for easy commuting. SH249, 99 and Beaudreaux are nearby.' ,`Acres` = '0.136' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 1 HAYDEN LAKES SEC 9' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5926' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '935' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hayden Lakes Sec 9' ,`TaxAmount` = '8729' ,`TaxRate` = '2.8172' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418582' WHERE `Matrix_Unique_ID` = '213254863' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T06:59:16.083' ,`MLSNumber` = '51877157' ,`ListAgentFullName` = 'Kathleen Merchant' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.119484' ,`Longitude` = '-95.479049' ,`PhotoCount` = '50' ,`PostalCode` = '77380' ,`RoomCount` = '15' ,`ListPrice` = '925000.00' ,`Status` = 'Active' ,`StreetName` = 'Northgate' ,`StreetNumber` = '99' ,`StreetSuffix` = 'Drive' ,`City` = 'The Woodlands' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '4265' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fabulous location in Grogan\'s Point on 24,000 sq ft golf course lot! High + dry, never flooded! Sellers just completed an impressive remodel + updates to the home, professionally designed by Studio G Interior Designers + constructed by James Whitley Construction. House now boasts a fresh, clean on-trend aesthetic. Kitchen + primary bath were completely remodeled. Both family room AND living room fireplace walls were updated. All dated oak (and other) millwork, moldings, trim + doors were updated with bright white paint + walls were freshly painted. Brand new carpeting upstairs. Recent expansion of 15x18 ft family room w/a 14x18 ft addition. Floor to ceiling windows provide amazing views of golf course + gorgeous hardwood trees! Recent enclosed sunroom + new deck added. Solid hardwood flooring in downstairs. Staircase has recent wood treads + white risers. 27x15 sq ft Texas basement, adjacent to gameroom could be a future media room, or additional bedroom.' ,`Acres` = '0.551' ,`Area` = '15' ,`BuilderName` = 'Jeff Paul' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL GROGANS ML 49, BLOCK 5, LOT 4' ,`LotDesciption` = 'On Golf Course' ,`LotSize` = '24000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAM HAILEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Grogans Ml 49' ,`TaxAmount` = '10594' ,`TaxRate` = '2.0501' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418582' WHERE `Matrix_Unique_ID` = '213325729' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T05:01:34.547' ,`MLSNumber` = '48746192' ,`ListAgentFullName` = 'Ava Sempe' ,`ListOfficeName` = 'Berkshire Hathaway HomeServicePremier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.088411' ,`Longitude` = '-96.067124' ,`PhotoCount` = '23' ,`PostalCode` = '77445' ,`RoomCount` = '6' ,`ListPrice` = '249000.00' ,`Status` = 'Active' ,`StreetName` = 'Cemetary' ,`StreetNumber` = '1719' ,`StreetSuffix` = '' ,`City` = 'Hempstead' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW Custom Construction - Welcome home to the serine countryside - overlooking a BEAUTIFUL horse ranch in the City of Hempstead. Home will have Stone Elevation w/Cement board siding w/Covered Front Porch. Open floorplan with Kitchen/Dining overlooking Family Room. 3 Spacious bedrooms, 2 full baths and a Covered Porch to enjoy your evening outdoors. CITY UTILITIES, NO HOA, LOW TAXES! EZ Access to Hwy 290 and to the City Amenities that include: Walking Track, Splashpad, Baseball Fields, Basketball Courts, Sand Volleyball and Playgrounds. Buyer/Agent to verify all measurements and/or information. *Price subject to change.' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'Hempstead Premier Ho' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hempstead' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 7, Block 417 City of Hempstead' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '24 - Hempstead' ,`SchoolElementary` = 'HEMPSTEAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEMPSTEAD HIGH SCHOOL' ,`SchoolMiddle` = 'HEMPSTEAD MIDDLE SCHOOL' ,`ShowInstructions` = 'No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'City of Hempstead' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668418582' WHERE `Matrix_Unique_ID` = '213560099' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T05:15:13.757' ,`MLSNumber` = '11422983' ,`ListAgentFullName` = 'Ava Sempe' ,`ListOfficeName` = 'Berkshire Hathaway HomeServicePremier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.088228' ,`Longitude` = '-96.067118' ,`PhotoCount` = '28' ,`PostalCode` = '77445' ,`RoomCount` = '7' ,`ListPrice` = '249000.00' ,`Status` = 'Active' ,`StreetName` = 'Cemetary' ,`StreetNumber` = '1739' ,`StreetSuffix` = '' ,`City` = 'Hempstead' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1260' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW Custom Construction - Estimated Completion by the end of December!!!Welcome home to the serine countryside - overlooking a BEAUTIFUL horse ranch in the City of Hempstead. Home will have Stone Elevation w/Cement board siding w/Covered Front Porch. Open floorplan with Kitchen/Dining overlooking Family Room. 3 Spacious bedrooms, 2 full baths and a Large Covered Porch to enjoy your evening outdoors. CITY UTILITIES, NO HOA, LOW TAXES! EZ Access to Hwy 290 and to the City Amenities that include: Walking Track, Splashpad, Baseball Fields, Basketball Courts, Sand Volleyball and Playgrounds. Buyer/Agent to verify all measurements and/or information. *Price subject to change.' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'Hempstead Premier Ho' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hempstead' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 9, BLK 417 City of Hempstead' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '24 - Hempstead' ,`SchoolElementary` = 'HEMPSTEAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEMPSTEAD HIGH SCHOOL' ,`SchoolMiddle` = 'HEMPSTEAD MIDDLE SCHOOL' ,`ShowInstructions` = 'No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'City of Hempstead' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668418582' WHERE `Matrix_Unique_ID` = '213560848' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T05:08:14.520' ,`MLSNumber` = '69410775' ,`ListAgentFullName` = 'Ava Sempe' ,`ListOfficeName` = 'Berkshire Hathaway HomeServicePremier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.088320' ,`Longitude` = '-96.067121' ,`PhotoCount` = '27' ,`PostalCode` = '77445' ,`RoomCount` = '6' ,`ListPrice` = '249000.00' ,`Status` = 'Active' ,`StreetName` = 'Cemetary' ,`StreetNumber` = '1729' ,`StreetSuffix` = '' ,`City` = 'Hempstead' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW Custom Construction - Estimated Completion- End of December! Welcome home to the serine countryside - overlooking a BEAUTIFUL horse ranch in the City of Hempstead. Home will have Stone Elevation w/Cement board siding w/Covered Front Porch. Open floorplan with Kitchen/Dining overlooking Family Room. 3 Spacious bedrooms, 2 full baths and a Covered Porch to enjoy your evening outdoors. CITY UTILITIES, NO HOA, LOW TAXES! EZ Access to Hwy 290 and to the City Amenities that include: Walking Track, Splashpad, Baseball Fields, Basketball Courts, Sand Volleyball and Playgrounds. Buyer/Agent to verify all measurements and/or information. *Price subject to change.' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'Hempstead Premier Ho' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hempstead' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 7, Block 417 City of Hempstead' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '24 - Hempstead' ,`SchoolElementary` = 'HEMPSTEAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEMPSTEAD HIGH SCHOOL' ,`SchoolMiddle` = 'HEMPSTEAD MIDDLE SCHOOL' ,`ShowInstructions` = 'No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'City of Hempstead' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668418583' WHERE `Matrix_Unique_ID` = '213561212' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T06:39:44.620' ,`MLSNumber` = '56090507' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Keller Williams Platinum' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.480315' ,`Longitude` = '-95.518202' ,`PhotoCount` = '50' ,`PostalCode` = '77459' ,`RoomCount` = '12' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'Foggy' ,`StreetNumber` = '10002' ,`StreetSuffix` = 'River' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3034' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This amazing 4-bedroom, 3-bathroom home on a corner lot in Sienna Village of Destrehan boasts a brick exterior, high ceilings, hardwood flooring, a gas log fireplace, game room, media room, study, formal dining room, and formal living room. Entertain guests in the spacious backyard, complete with a covered patio, outdoor fireplace, and outdoor kitchen. The island kitchen is complete with granite countertops, a tile backsplash, a walk-in pantry, new fridge and dishwasher, a gas cooktop, a breakfast bar, a dining nook, pendant lighting, and undercabinet lighting. Find a walk-in closet, dual vanities, soaking tub, and separate shower in the serene primary suite. The Sienna community includes a swimming pool, a fitness center, a dog park, walking trails, and numerous parks. Situated off Hwy 6, residents are close to shopping and dining at the First Colony Mall, Sugar Land Town Center, and Kitty Hollow Park. Zoned to Fort Bend ISD.' ,`Acres` = '0.147' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIENNA VILLAGE OF DESTREHAN SEC 3, BLOCK 2, LOT 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6402' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1254' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna Village Of Destrehan' ,`TaxAmount` = '10892' ,`TaxRate` = '3.1629' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418583' WHERE `Matrix_Unique_ID` = '213672809' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T06:09:45.867' ,`MLSNumber` = '36467216' ,`ListAgentFullName` = 'Brooke Clark' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.292077' ,`Longitude` = '-95.558002' ,`PhotoCount` = '36' ,`PostalCode` = '77316' ,`RoomCount` = '11' ,`ListPrice` = '540000.00' ,`Status` = 'Active' ,`StreetName` = 'Great Hills' ,`StreetNumber` = '326' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2267' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Built by Highland Homes in the Master-Planned Woodforest subdivision on an oversized lot! This custom 4b-2b has all the upgrades you could ask for! Guests are welcomed by gas-lit chandelier & entrance lanterns. Kitchen boasts a 5 burner gas range, double ovens, meat aging locker for choice-cuts to grill on the outdoor kitchen, room for oversized Subzero Refrigerator & more. Cozy up by the outdoor fireplace while relaxing under the extended patio cover overlooking the fenced-in privacy back yard that backs up to a greenbelt. Large primary suit includes a bay window & luxurious en-suite bath with independent valve rain shower. The water pressure and tankless water heater make this a retreat to come home to! Solid French doors on the 4th bedroom pose multi purposed use: bedroom, formal dining, den, or game room. When it’s time to work, the study overlooks the front garden as a relaxing backdrop. Water purifier in case of disaster - Hookup ready for Generac. Tons of community amenities!' ,`Acres` = '0.2154' ,`Area` = '39' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S965289 - WOODFOREST 89, BLOCK 1, LOT 8' ,`LotDesciption` = 'Greenbelt,In Golf Course Community,Subdivision Lot' ,`LotSize` = '9382' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1265' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest 89' ,`TaxAmount` = '11630' ,`TaxRate` = '2.8388' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418583' WHERE `Matrix_Unique_ID` = '214316980' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T06:15:57.480' ,`MLSNumber` = '919239' ,`ListAgentFullName` = 'Karim Tahri' ,`ListOfficeName` = 'K & T Realty Group, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.997609' ,`Longitude` = '-95.666526' ,`PhotoCount` = '32' ,`PostalCode` = '77429' ,`RoomCount` = '12' ,`ListPrice` = '329000.00' ,`Status` = 'Active' ,`StreetName` = 'Wolf Branch' ,`StreetNumber` = '15023' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2590' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 2,590 square foot single family home that has 4 bedrooms and 2.5 bathrooms. The house features a cozy living room and modern designed kitchen/dining. The primary bedroom has walk-in closet and an en-suite bathroom with double sinks. The other bedroom are spacious. It also shows off a hug backyard for your outdoor fun with family and guests. Located in the friendly neighborhood of Stablewood Farms subdivision in Harris County. Schedule your showing today!' ,`Acres` = '0.1545' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 1 STABLEWOOD FARMS NORTH SEC 4 R/P' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6732' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '665' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'FARNEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'GOODSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stablewood Farms Sec 4' ,`TaxAmount` = '7329' ,`TaxRate` = '2.94' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418583' WHERE `Matrix_Unique_ID` = '214419477' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T05:37:00.933' ,`MLSNumber` = '79643921' ,`ListAgentFullName` = 'Arash Asgharian' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.703942' ,`Longitude` = '-95.372160' ,`PhotoCount` = '46' ,`PostalCode` = '77021' ,`RoomCount` = '5' ,`ListPrice` = '499900.00' ,`Status` = 'Active' ,`StreetName` = 'Kelton' ,`StreetNumber` = '3326' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2618' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The lucky owner will be the first to reside in this home after being completely remodeled. This home is beautifully upgraded and Move-in Ready! With 5 Beds and 3 1/2 Baths, this open concept layout features a spacious open kitchen to the dining room and living area. High ceilings with windows allowing tons of natural light. The second floor features a large loft/entertainment room. The driveway is very spacious allowing 3 cars to be parked. Large backyard perfect for entertaining. Located near the Medical Center with convenient access to highways, downtown, and so many city attractions.' ,`Acres` = '0.1263' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Riverside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 7 BLK 39 SOUTHLAND TERRACE' ,`LotDesciption` = 'Other' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'THOMPSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Southland Terrace' ,`TaxAmount` = '3108' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418583' WHERE `Matrix_Unique_ID` = '214451338' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T05:44:31.103' ,`MLSNumber` = '39543730' ,`ListAgentFullName` = 'Donna Bolding' ,`ListOfficeName` = 'RE/MAX Eastside' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.821722' ,`Longitude` = '-94.976746' ,`PhotoCount` = '21' ,`PostalCode` = '77521' ,`RoomCount` = '7' ,`ListPrice` = '314900.00' ,`Status` = 'Active' ,`StreetName` = 'Annatto' ,`StreetNumber` = '5603' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2923' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Do You need a big, beautiful brick home? You have to come see this one! Wow! it\'s very well taken care of and loved. You feel the peace and joy as soon as you walk in. All the bedrooms are down stairs. There is a large game room and man cave upstairs. Back yard retreat with pond and storage. Call your realtor or call me I will show it to you.' ,`Acres` = '0.1905' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 SPRINGFIELD ESTATES SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8299' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '340' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'VICTORIA WALKER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial,Contemporary/Modern' ,`Subdivision` = 'Springfield Estates Sub Sec 5' ,`TaxAmount` = '8073' ,`TaxRate` = '3.095' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418584' WHERE `Matrix_Unique_ID` = '214463645' --> 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','214682917','1668418584','214682917','2022-11-13T05:44:24.193','91771736','Cameron Gossen','eXp Realty, LLC','','','29.953685','-95.561653','32','77070','8','345000.00','Active','Carsonmont','9406','Lane','Houston','3','0','4','2555','Single-Family','Wow this one is a Steal! Brand new Roof, fresh Paint throughout this entire Move-In Ready home. Gorgeous and bright 2-story, 4 spacious Bedroom home in an established neighborhood! Kitchen Cabinets repainted to create an even brighter appeal! Good sized Master bedroom and bath w/ Separate shower & garden bathtub. Walk-in closet. Open Floorplan w/ Vaulted Ceilings in Living, Spacious rooms throughout the house. Huge backyard, perfect for entertaining. Cy-Fair ISD. Very quiet neighborhood. Nearby Willowbrook Mall, Methodist Hospital, Costco/Sam\'s and 249!','0.1804','10','','','','','Exclusions,Sellers Disclosure','','','1','Willowbrook South','Central Electric','1','LT 8 BLK 3 LINNFIELD SEC 2','Subdivision Lot','7860','Appraisal District','','450','0','','2','','0','','','','','Composition','13 - Cypress-Fairbanks','HANCOCK ELEMENTARY SCHOOL (CY-FAIR)','CYPRESS CREEK HIGH SCHOOL','BLEYL MIDDLE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Linnfield','6676','2.8087','Public Sewer,Public Water','2003','Appraisal District'); --> New record created successfully