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-19T00:20:49.993' ,`MLSNumber` = '11565974' ,`ListAgentFullName` = 'Yucelis Wentland' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.918198' ,`Longitude` = '-95.691882' ,`PhotoCount` = '49' ,`PostalCode` = '77433' ,`RoomCount` = '7' ,`ListPrice` = '559900.00' ,`Status` = 'Active' ,`StreetName` = 'Rockport Hills' ,`StreetNumber` = '9650' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2780' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'We are in the beautiful Ashton Woods Villa in the Gated Community of Towne Lake! The home is located on a corner lot with a large covered porch that allows additional parking space. This 2 story home is loaded with upgrades, Floorte flooring throughout the first floor. Open concept kitchen into the family room. Gorgeous white linen cabinets in the kitchen. A custom made fireplace that you can regulate to heat on/off (you will love it!) with spacious counter space that you can use as a sitting area! A very spacious master with silestone counter tops and a large mudset master shower. Fall in love with the utility room with sink and large countertops. Very cozy game room, and much more! Towne Lake offers 300 acre boatable lake, fishing, lazy river, numerous pools, waterpark, beach, and gyms.' ,`Acres` = '0.101' ,`Area` = '25' ,`BuilderName` = 'Ashton Wood Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 2 TOWNE LAKE SEC 40' ,`LotDesciption` = 'Corner' ,`LotSize` = '4400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2842' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'RENNELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Towne Lake Sec 40 Pt Rep 1' ,`TaxAmount` = '11825' ,`TaxRate` = '3.091' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040343' WHERE `Matrix_Unique_ID` = '211390221' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T00:08:10.670' ,`MLSNumber` = '68888246' ,`ListAgentFullName` = 'Marichka Oldag' ,`ListOfficeName` = 'Watkins Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.950517' ,`Longitude` = '-95.971162' ,`PhotoCount` = '47' ,`PostalCode` = '77414' ,`RoomCount` = '4' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Nicole' ,`StreetNumber` = '82' ,`StreetSuffix` = '' ,`City` = 'Bay City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3077' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous and unique fully renovated home located in Matagorda County! 4 (5) bed home sits on over 1 acre, perfect for all your wants and needs. Enjoy the quiet country living, beautiful sunsets, and amazing scenery from the comfort of your own home, which is is remodeled with the best quality materials. Brand new roof, HVAC unit, foundation fixed and a lot more. Brand new flooring, cabinets, countertops, carpet, plumbing, light and other fixtures, luxurious looking new bathrooms, fresh interior and exterior paint, new stainless steal appliances, garage doors... Huge garage and extra space that could be used as a shop next to the garage in the house or additional storage. Beautiful covered patio on the backyard. If you are looking for a \"small town feel\", this is the home for you! Make sure to schedule your showing now.' ,`Acres` = '1.105' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'AB 0045, E HALL, ACRES 1.105' ,`LotDesciption` = 'Other' ,`LotSize` = '48134' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '132 - Bay City' ,`SchoolElementary` = 'TENIE HOLMES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BAY CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BAY CITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'E Hall Surv A-45' ,`TaxAmount` = '4111' ,`TaxRate` = '2.1888' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040343' WHERE `Matrix_Unique_ID` = '212148144' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T00:09:44.300' ,`MLSNumber` = '35826425' ,`ListAgentFullName` = 'Marichka Oldag' ,`ListOfficeName` = 'Watkins Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.601037' ,`Longitude` = '-95.040903' ,`PhotoCount` = '45' ,`PostalCode` = '77331' ,`RoomCount` = '3' ,`ListPrice` = '289900.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar' ,`StreetNumber` = '270' ,`StreetSuffix` = 'Valley' ,`City` = 'Coldspring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2565' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous fully remodeled property that sits on the huge lot only minutes drive to the Lake Livingston and Trinity River. Private area in back of neighborhood just for residents: very nice boat launch, grilling area with multiple picnic tables and covered area overlooking river. Spacious full of natural light interior with the high ceilings and open floor plan. Brand new luxurious bathrooms with the free standing bath tub and glass door standing shower with oversized tropical shower head. Numerous updates were done at the house: NEW ROOF, 2 AC UNITS, water heater, wooden deck, flooring, carpet, interior and exterior paint, counter tops, tile, sheetrock, appliances, plumbing and light fixtures, and a lot more! This home is a perfect primary home or vocational house. No HOA!!!' ,`Acres` = '0.8156' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'CEDAR VALLEY #1, BLOCK 1, LOT 10, ACRES .8156' ,`LotDesciption` = 'Wooded' ,`LotSize` = '35528' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Other Style' ,`Subdivision` = 'Cedar Valley #1' ,`TaxAmount` = '2209' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040343' WHERE `Matrix_Unique_ID` = '212396732' --> 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','212458698','1669040343','212458698','2022-11-19T00:20:49.853','71134372','Beverly Bradley','Weekley Homes','','','29.978509','-95.740899','26','77433','8','525666.00','Active','Paseo La Paz','13906','Place','Cypress','3','0','4','2744','Single-Family','Dunham Pointe has arrived! Master planned community perfectly situated near distinctive restaurants, local and national brands, select services, and curated retail to offer a rich and varied lifestyle. Inspired by Romanesque architecture, this stunning community celebrates the zest for life and is designed to create a close-knit community. David Weekly is introducing the spacious and sophisticated Jewel plan. With natural light pouring through the walls of windows, you\'ll find it easy to relax. Meal time is family time working from the open kitchen, dining and family room. Weekends mean fun time in the oversized game room retreat! Upcoming amenities like walking trails,clubhouse, pool and Cy-Fair I.S.D schools, will help neighbors become fast friends. Join us!!','','25','David Weekley Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Home Protection Plan,Mud','1','','','Cypress South','Central Gas','1','Lot 46 Block 01','Subdivision Lot','6737','Other','','1000','1','To Be Built/Under Construction','2','Electric Oven,Single Oven','0','','','Gas Cooktop','','Composition','13 - Cypress-Fairbanks','AULT ELEMENTARY SCHOOL','BRIDGELAND HIGH SCHOOL','SALYARDS MIDDLE SCHOOL','Appointment Required,No Supra Keybox','Builder','2','Traditional','Dunham Pointe','','','Water District','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T00:01:49.230' ,`MLSNumber` = '17326839' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.887204' ,`Longitude` = '-95.834716' ,`PhotoCount` = '8' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '255000.00' ,`Status` = 'Active' ,`StreetName` = 'Vista Field' ,`StreetNumber` = '26906' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1461' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Homes Cottage Series, \'\'Chestnut\'\' Plan with Elevation \"A\" in Beautiful Winward! Charming Single Story with 3 Beds/2 Baths/2 Car Garage! An exterior features a smart layout that makes good use of the available space. The front door leads into an open concept family room which flows into the dining room and kitchen for effortless transitions during meals or parties. Two bedrooms share a hall bathroom at the front of the home, while the owner’s suite is tucked into the back corner for maximum privacy, along with a full bathroom and walk-in closet.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0007 BLK 003 LOT 014' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Winward' ,`TaxAmount` = '' ,`TaxRate` = '3.54' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669040343' WHERE `Matrix_Unique_ID` = '212478902' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T00:40:44.920' ,`MLSNumber` = '68196928' ,`ListAgentFullName` = 'Ryan Hajdik' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.833472' ,`Longitude` = '-95.794498' ,`PhotoCount` = '35' ,`PostalCode` = '77493' ,`RoomCount` = '3' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Asher Hollow' ,`StreetNumber` = '24218' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this Meritage Home- Caddo Floor plan. Open floor plan huge outdoor covered patio. The large back yard is plenty big enough for all your family get togethers. This kitchen is a dream for your family chief.NO carpet in this house at all! This house has a water softener & tankless hot water heater in the garage and is an energy-efficient home.The common area is equipped with an oversize family room which sits right next to the kitchen and dining room. The huge island provides plenty of space for people to gather around. Upgraded granite in the kitchen and quartz will be in the bathrooms. There is an office that could be used as a study and the home is walking distance from the recreation area. Katy Pointe offers easy access to the Grand Parkway, Katy Freeway, and a convenient commute to major employers. Just half an hour from metro-Houston, just off of I-10 with nearby shopping, dining, and entertainment. Schools in the sought-after Katy ISD, and close to the area’s golf courses.' ,`Acres` = '0.133' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 3 KATY POINTE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5793' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '590' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BETHKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Katy Pointe Sec 1' ,`TaxAmount` = '8088' ,`TaxRate` = '3.4768' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040344' WHERE `Matrix_Unique_ID` = '212752992' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T00:14:11.613' ,`MLSNumber` = '77620833' ,`ListAgentFullName` = 'Adelina Ochoa' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.322891' ,`Longitude` = '-95.461361' ,`PhotoCount` = '28' ,`PostalCode` = '77301' ,`RoomCount` = '2' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Everett' ,`StreetNumber` = '509' ,`StreetSuffix` = 'Street' ,`City` = 'Conroe' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '930' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Perfect for Residential or Commercial Use! This Street has Several Operating Businesses, Located in the HEART OF CONROE! Close to Shopping and Restaurant’s. Just Minutes to Interstate-45. Upgrades Include New Exterior Cement Board Siding, Interior and Exterior Paint, Sod, New Driveway, New Laminate Flooring, New sheetrock and texture, New Kitchen Self Closing Custom made Cabinets, New Sink’s, New Backsplash, New Granite Countertops, Beautiful Kitchen Pendant Lights, New Stainless Steel Kitchen Appliance package including Refrigerator. New Ceiling Fans. Huge Landry Room Could be used as a 3rd Bedroom or Office. Mature Trees, Large Backyard. Storage Shed is included. Schedule a Tour Today!' ,`Acres` = '0.1862' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PINE HILL, BLOCK 1, LOT 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8112' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'HOUSTON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Right Side,No Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Pine Hill' ,`TaxAmount` = '1638' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040344' WHERE `Matrix_Unique_ID` = '213166465' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T00:42:11.183' ,`MLSNumber` = '25957365' ,`ListAgentFullName` = 'Ryan Hajdik' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.726728' ,`Longitude` = '-95.928877' ,`PhotoCount` = '50' ,`PostalCode` = '77423' ,`RoomCount` = '9' ,`ListPrice` = '449999.00' ,`Status` = 'Active' ,`StreetName` = 'Hamilton Crest' ,`StreetNumber` = '32314' ,`StreetSuffix` = 'Drive' ,`City` = 'Brookshire' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3574' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'STOP THE BUS! See this home TODAY! READY for immediate move in! Awesome neighborhood with a home that offers plenty of room for your family. 2 story living room with soaring ceilings and fireplace. Open floor plan with a gorgeous kitchen that features granite counter tops and a huge island with upgraded back splash. Fridge, washer and dryer stay. Relax in the back yard with a huge outdoor covered patio with outdoor kitchen that is a dream come true for the family BBQ. Home features energy saving features like double paned windows and radiant barrier. Large upstairs game room, 2 full bathrooms upstairs including a jack-and-jill bathroom, walk in closets, oversized 2 car garage. Home also features a sprinkler system. Zoned to great schools, come see this beauty today! NO BACK NEIGHBORS. Neighborhood also features a pool and playground.' ,`Acres` = '0.1641' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'VANBROOKE SEC 1, BLOCK 1, LOT 27' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Vanbrooke Sec 1' ,`TaxAmount` = '11491' ,`TaxRate` = '3.2948' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040344' WHERE `Matrix_Unique_ID` = '214197187' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T00:58:17.967' ,`MLSNumber` = '75367206' ,`ListAgentFullName` = 'June Tyler' ,`ListOfficeName` = 'Krisher-McKay, Inc., REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.767433' ,`Longitude` = '-95.005862' ,`PhotoCount` = '26' ,`PostalCode` = '77521' ,`RoomCount` = '12' ,`ListPrice` = '282000.00' ,`Status` = 'Active' ,`StreetName` = 'Inverness' ,`StreetNumber` = '5119' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2315' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Bring on the holidays! If you are ready to host those endless holiday parties, then this is the perfect home for you! Situated on a large corner lot, this home has way too many upgrades to name including all new appliances, brand new quartz countertops, energy-efficient windows throughout and new showers. There is plenty of room for all of your out of town visitors, space to prepare those secret recipes and a variety of areas to play games, dance, talk quietly or enjoy the big meal. When you need to get away from it all, head outdoors, make s\'mores, stargaze or simply relax by the fire in the oversized backyard. The home is located in the very desirable Country Club Oaks subdivision right in the heart of Baytown, within close proximity to great shopping and dining while having easy access to Houston, Pasadena or Beaumont. Hurry...this one definitely won\'t last long, so call your favorite agent for a showing today!' ,`Acres` = '0.2755' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 15 COUNTRY CLUB OAKS SEC 5' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '12000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '50' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'BAYTOWN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Country Club Oaks Sec 05' ,`TaxAmount` = '5712' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040344' WHERE `Matrix_Unique_ID` = '214542797' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T23:04:14.103' ,`MLSNumber` = '24091458' ,`ListAgentFullName` = 'Enrique Escobar' ,`ListOfficeName` = 'Mr. Sold Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.919357' ,`Longitude` = '-95.712839' ,`PhotoCount` = '50' ,`PostalCode` = '77433' ,`RoomCount` = '9' ,`ListPrice` = '670000.00' ,`Status` = 'Active' ,`StreetName` = 'Peach Mill' ,`StreetNumber` = '20014' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3686' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'An exquisite home that you will you fall in love with! Located in the highly desirable community of Cypress Creek Lakes on a cul-de-sac lot with a serene yard and a sparking pool. A sense of pride in homeownership from the inside out. This home features 4 bedrooms, and 3 and 1 half bathrooms. There are plenty of windows to let in natural light, a two-story living room, a gourmet kitchen with an island, 42-inch raised panel cabinets, granite countertops, high-end appliances, and a butler\'s pantry that will impress the pickiest buyer.  A covered back porch, an outdoor kitchen and pool, professional landscaping are some of the outdoor features. There are 3 pools, a splash pad, two lovely clubhouses, parks, and endless trails around lakes in this wonderful community. Zoned to top-rated Cy-fair ISD schools, in close proximity to shopping, restaurants, Lifetime Fitness, and easy commute via 290 and 99 Grand Parkway, this beautiful home will not last long!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'PERRY HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 38 BLK 1 CYPRESS CREEK LAKES SEC 12' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7924' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WARNER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Lakes Sec 12' ,`TaxAmount` = '13058' ,`TaxRate` = '3.041' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040344' WHERE `Matrix_Unique_ID` = '214749666' --> 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','214823949','1669040345','214823949','2022-11-19T00:13:51.053','40199024','Donna Burke','Texas Legacy Properties','','','30.194865','-95.534836','28','77381','9','725000.00','Active','Steepbank','14','Drive','The Woodlands','2','1','3','3148','Single-Family','Quality abounds with this custom 1 story in the coveted Palmer Woods section, on an over-sized (17,996 sq. foot) wooded lot backing to a private reserve. This beauty boasts of real hardwood floors, plantation shutters throughout, soaring ceilings, extensive custom millwork and built ins, walls of huge windows, gas fireplace, study with French doors and cabinetry , carpet in bedrooms only, huge master closet with built ins, expansive kitchen, abundance of cabinets, under counter lighting, prep sink, large double ovens, 5 burner gas cooktop, built in microwave, stainless appliances, split plan, alarm, wrought iron fence across the back of yard, l sprinkler, covered porch over the veranda, large laundry with sink and cabinets, overs-sized side entry 2 car garage, and the best of everything. This house is all about the incredible views from every window. When you walk through the 10 foot front door and look through the wall of windows, it will take your breath away. Just WOW!','0.4131','15','John Post Custom Bui','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Estate,Mud','1','Freestanding,Gaslog Fireplace','1','The Woodlands','Central Gas,Zoned','0','WDLNDS Vil Cochrans CR 30, Block 1, Lot 31','Cul-De-Sac,Greenbelt,In Golf Course Community,Subdivision Lot,Wooded','17996','Appraisal District','','','0','','2','Double Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','GALATAS ELEMENTARY SCHOOL','THE WOODLANDS HIGH SCHOOL','MCCULLOUGH JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','1','Ranch,Traditional','The Woodlands Cochrans Crossing','11312','2.1884','Public Sewer,Public Water,Water District','1993','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T23:30:35.100' ,`MLSNumber` = '68657731' ,`ListAgentFullName` = 'Renae Gibson' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.787762' ,`Longitude` = '-95.587196' ,`PhotoCount` = '25' ,`PostalCode` = '77043' ,`RoomCount` = '4' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Forest' ,`StreetNumber` = '1227' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2834' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEVER FLOODED. Grand entrance with vaulted ceilings. Living room is the perfect place to entertain large group and friend gatherings. Cozy fireplace for those cold winter nights. Island Kitchen has tons of cabinets and counter space. Spacious breakfast room adjoins and massive formal Dining or Study is just off the kitchen. Laundry room located downstairs. Tons of windows and natural light pouring in. All bedrooms are up. No carpet in this home. Secluded, low traffic part of the energy corridor. 2 minute walk to Private Clubhouse, Community Swimming Pool, Tennis Courts and fenced Playground. Low maintenance landscaping. Close proximity to bicycle and paved walking path. Only minutes to Terry Hershey Park and Westside Tennis Club. Easy access to I-10. Great home in a great location for a great price.' ,`Acres` = '0.1396' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 7 WESTWICK SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6080' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '825' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'THORNWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STRATFORD HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westwick Sec 01' ,`TaxAmount` = '9457' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040345' WHERE `Matrix_Unique_ID` = '214837711' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T23:21:13.190' ,`MLSNumber` = '23782874' ,`ListAgentFullName` = 'Fafu Zeng' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.044303' ,`Longitude` = '-95.341531' ,`PhotoCount` = '35' ,`PostalCode` = '77373' ,`RoomCount` = '4' ,`ListPrice` = '199800.00' ,`Status` = 'Active' ,`StreetName` = 'Thadds' ,`StreetNumber` = '22835' ,`StreetSuffix` = 'Trail' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1444' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 1-story home on a huge corner lot located in the established neighborhood of Postwood. The home has been recently updated. This home features a large living room with a fireplace. Cozy dining kitchen combo equipped with plenty of cabinets and new countertops. New tile throughout entire home except 3 bedrooms with new carpets. Freshly painted both inside and outside. New lights and fans throughout. Spacious backyard with a patio perfect for entertaining. The huge side yard can be additional space for entertaining. Garage has a opener with remote controls. Quick access to shopping, dining, IAH, Mercer Arboretum, I45, Hardy Toll Rd, & Cypresswood Golf Course. Schedule your show today as it won\'t last at this price.' ,`Acres` = '0.2537' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 7 POST WOOD SEC 4' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '11050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CHET BURCHETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,No Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Post Wood Sec 04' ,`TaxAmount` = '3446' ,`TaxRate` = '2.5868' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040345' WHERE `Matrix_Unique_ID` = '214840951' --> 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','214931627','1669040345','214931627','2022-11-19T00:34:02.780','36188993','Johnny Page','Keller Williams Signature','','','30.165356','-95.038509','33','77327','8','139990.00','Active','Road 5246','142','','Cleveland','2','0','3','1680','Single-Family','Honey I\'m Home! This home is nothing less than beautiful, kept in mint condition. The seller added all the bells and whistles (upgrades) to this one. As soon as you walk in you see 1,580 square feet of amazing. The kitchen is equipped with a sleek farmhouse sink, sliding barn door spice cabinet, and a stand alone island to put the icing on the cake. The primary bedroom is huge! The primary bathroom comes with double sinks, huge garden tub, huge custom walk in shower and a walk in closet. Entertain your company on your 54\' by 17\' covered back patio. Located in the prestigious subdivision of Santa Fe. This subdivision is a great community to own in. If you are ready to own a home that you will LOVE at first site look no further. This home in Santa Fe will do the trick. Did I mention this home is located less than a mile and a half from SH 99 (Grand Parkway). New schools were built to accommodate the new growth in the area! I will say no more, grab your agent and come see for yourself.','0.4','52','','','Electric Dryer Connections','','Sellers Disclosure','1','','','Cleveland Area','Central Electric','1','SANTA FE, SEC 2, BLOCK 20, LOT 3041, ACRES 0.4000','Subdivision Lot','17424','Appraisal District','','120','0','','0','','0','','','','','Aluminum','100 - Cleveland','PINE BURR ELEMENTARY SCHOOL','CLEVELAND HIGH SCHOOL','CLEVELAND MIDDLE SCHOOL','Accompany,Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Santa Fe, Sec 2','1220','2.0417','Public Sewer,Public Water','2020','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214958032','1669040345','214958032','2022-11-19T00:33:20.580','97411188','Latiegre Diaz','Berkshire Hathaway HomeService','','','30.051621','-95.383037','25','77373','6','200000.00','Active','Prairie Bird','23346','Drive','Spring','2','0','3','1152','Single-Family','This 1 story home would make the perfect starter home, downsize property, or investment property. The entire interior has just been painted so that it\'s move in ready for it\'s new owners. Located in Cypress Trails in Spring right off of Aldine Westfield makes it a solid location for access to major roads and highways like, 1960, I-45, Hwy 69, Hardy toll road, and tollway 99. The kitchen & primary bathroom was remodeled in 2021. Roof is from 2018. This listing also has a preferred lender and qualifies for a game changing loan program that could save you THOUSANDS of dollars over the lifetime of the loan. The loan program has NO PRIVATE MORTGAGE INSURANCE, $0 DOWN, AND UP TO $10,000 TOWARD CLOSING COSTS. So not only is this the perfect starter home, but it has incentives that could get you moved in comfortably for the holidays. Please don\'t let this opportunity pass you by. Get your showing scheduled today!','0.0877','12','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Wood Burning Fireplace','1','Spring East','Central Electric','1','TR 1A BLK 6 CYPRESS TRAILS OF TIMBERLANE 2','Corner,Subdivision Lot','3822','Appraisal District','','335','0','','1','Electric Oven','0','','','Electric Range','','Composition','48 - Spring','GLORIA MARSHALL ELEMENTARY SCHOOL','SPRING HIGH SCHOOL','RICKY C BAILEY M S','Appointment Required,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Cypress Trails Timberlane','3809','3.0268','Water District','1982','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214962406','1669040345','214962406','2022-11-19T00:27:50.120','30670524','Theresa Almogabar','Keller Williams Woodlands','','','30.038719','-95.585424','21','77375','4','260000.00','Active','Telford','19006','Way','Tomball','2','0','3','1526','Single-Family','Single story home + cul-de-sac street + recent roof + great updates + open floor plan are just a few perks this home has that is ready for you to call it HOME! From the moment you walk in you\'ll notice the pride in ownership. The kitchen faces the front of the home and with plenty of counter and cabinet space, ceramic tile backsplash, and laminate floors for easy clean ups. Dining area is right next to the kitchen and also has laminate flooring. The living room is spacious and has freshly cleaned carpet. Down the hallway is your laundry room, two secondary bedrooms, and a bath. In the primary bedroom, you\'ll love the tray ceiling and plenty of natural light coming in from the windows. The primary bathroom features a soaking tub and separate shower. The back yard has a large patio area and plenty of space for all your outdoor needs. The hot water heater and central heat are both gas. Come by and see this beautiful home and fall in love.','0.1136','14','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','0','Spring/Klein/Tomball','Central Gas','1','LT 27 BLK 3 ASHFORD PLACE SEC 2','Subdivision Lot','4950','Appraisal District','','425','0','','2','Electric Oven','0','','','Electric Range','','Composition','32 - Klein','BLACKSHEAR ELEMENTARY SCHOOL (KLEIN)','KLEIN CAIN HIGH SCHOOL','ULRICH INTERMEDIATE SCHOOL','Supra Keybox','Appraisal District','1','Traditional','Ashford Place Sec 2 2','4657','2.7066','Public Water,Water District','2005','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214962605','1669040345','214962605','2022-11-19T00:37:23.687','76652721','Vera Mitrofanova','VAM Real Estate Solutions','','','29.891029','-95.688819','46','77433','11','360000.00','Active','Park Sage','18210','Court','Cypress','2','0','3','2430','Single-Family','Welcome Home! This immaculate and so loved by the current original owner house by KB Homes in the heart of Cypress features 3 bedrooms, 2 full bathrooms, den that open up to the dining, spacious office, formal living room with fireplace that opens up to the kitchen with silestone countertops and a plethora of cabinets and storage, breakfast nook. Huge primary bedroom with large bathroom that has separate shower, jacuzzi bathtub and two sinks. Carpet is only in the bedrooms. Covered patio, corner lot that offers a big yard and slab for your shed. Laundry room with lots of shelves. Garage has epoxy flooring. This house is one of a kind and offers everything you can think of. Surround system throughout the whole house. Full house gutters. Washer, dryer and fridge stay. Schedule your private showing today!','0.2089','25','','','Electric Dryer Connections,Washer Connections','','Exclusions,Mud','1','Gas Connections','1','Cypress South','Central Gas','1','LT 13 BLK 2 WESTGATE SEC 13','Corner,Subdivision Lot','9100','Appraisal District','','660','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','13 - Cypress-Fairbanks','COPELAND ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','CYPRESS SPRINGS HIGH SCHOOL','KAHLA MIDDLE SCHOOL','Accompany,Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Westgate Sec 13','6769','2.671','Water District','2006','Appraisal District'); --> New record created successfully