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-10-13T05:55:53.943' ,`MLSNumber` = '16306402' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.874800' ,`Longitude` = '-95.723065' ,`PhotoCount` = '27' ,`PostalCode` = '77449' ,`RoomCount` = '6' ,`ListPrice` = '229900.00' ,`Status` = 'Active' ,`StreetName` = 'Rusty Ridge' ,`StreetNumber` = '6822' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1422' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Instantly appealing, two story home with fantastic open layout. You will never miss out on the action from the spacious kitchen overlooking the dining and living room with charming fireplace accent wall! Enjoy the privacy of the expansive primary bedroom upstairs and two additional bedrooms downstairs. Book a tour with your real estate agent today and feel right at home!' ,`Acres` = '0.1026' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 32 BLK 1 HIGHLAND CREEK RANCH SEC 3' ,`LotDesciption` = 'Other' ,`LotSize` = '4468' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '446' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WALKER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland Crk Ranch Sec 03' ,`TaxAmount` = '4209' ,`TaxRate` = '2.69' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665667215' WHERE `Matrix_Unique_ID` = '205026875' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-13T05:51:01.853' ,`MLSNumber` = '30383832' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.035312' ,`Longitude` = '-95.350539' ,`PhotoCount` = '27' ,`PostalCode` = '77373' ,`RoomCount` = '7' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Sherilynn' ,`StreetNumber` = '5215' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2130' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great 4 bedroom, 2 bathroom home! This home offers a covered front porch, covered back porch, and a two car garage.' ,`Acres` = '0.1446' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 3 POSTWOOD SEC 5' ,`LotDesciption` = 'Other' ,`LotSize` = '6300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'ANDERSON ELEMENTARY SCHOOL (SPRING)' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Postwood Sec 05' ,`TaxAmount` = '5118' ,`TaxRate` = '2.5868' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665667216' WHERE `Matrix_Unique_ID` = '208201601' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-13T05:57:33.627' ,`MLSNumber` = '27599552' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.548346' ,`Longitude` = '-95.340944' ,`PhotoCount` = '28' ,`PostalCode` = '77584' ,`RoomCount` = '6' ,`ListPrice` = '314900.00' ,`Status` = 'Active' ,`StreetName` = 'Pecan Grove' ,`StreetNumber` = '4918' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2320' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great 3 bedroom, 2.5 bathroom home! This home also offers a two car garage, and a covered front porch.' ,`Acres` = '0.1629' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SOUTHWYCK, BLOCK 7, LOT 14 SEC 1-REPLAT, A0242 HT&BRR' ,`LotDesciption` = 'Other' ,`LotSize` = '7096' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'SILVERLAKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GLENDA DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'BERRY MILLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Southwyck' ,`TaxAmount` = '5958' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665667216' WHERE `Matrix_Unique_ID` = '208978349' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-13T05:53:56.633' ,`MLSNumber` = '41576702' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.464333' ,`Longitude` = '-95.469465' ,`PhotoCount` = '18' ,`PostalCode` = '77583' ,`RoomCount` = '5' ,`ListPrice` = '269900.00' ,`Status` = 'Active' ,`StreetName` = 'Tartan' ,`StreetNumber` = '8214' ,`StreetSuffix` = 'Court' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2094' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great 3 bedroom, 2 bathroom two story home! All bedrooms are upstairs, and there is also a 2 car garage.' ,`Acres` = '0.1157' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SOUTHERN COLONY SEC 1, BLOCK 4, LOT 38' ,`LotDesciption` = 'Other' ,`LotSize` = '5040' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Southern Colony Sec 1' ,`TaxAmount` = '5310' ,`TaxRate` = '3.1329' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665667216' WHERE `Matrix_Unique_ID` = '210393190' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-13T04:52:01.143' ,`MLSNumber` = '58484065' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.744271' ,`Longitude` = '-95.844492' ,`PhotoCount` = '30' ,`PostalCode` = '77494' ,`RoomCount` = '11' ,`ListPrice` = '684990.00' ,`Status` = 'Active' ,`StreetName` = 'Horizon Bluff' ,`StreetNumber` = '2811' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4198' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Beautiful Village Builders home features 5 bedrooms 4 and 1 half bathrooms. Spacious open floor plan with large windows letting in an abundance of natural light. Two-story entrance, Stunning Home Office with exposed beams, 2 Bedrooms down. Tile floors that look like wood throughout. Upgraded Shiplap paneling detail over fireplace. The gourmet kitchen boasts granite countertops, large basin sink, backsplash, stainless steel appliances including double ovens, and upgraded cabinets. The Primary Bedroom downstairs does not disappoint with oversized windows and spacious ensuite luxury bathroom. Upstairs has a large game room, media room complete with oversized custom projection screen and 3 secondary bedrooms. Spacious backyard with a large extended patio. Home is within walking distance to Jenks Elem, parks, pool, and tennis court! Minutes to I-10, Shopping, and Restaurants. Katy ISD!' ,`Acres` = '0.1935' ,`Area` = '36' ,`BuilderName` = 'Village Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CINCO RANCH NORTHWEST SEC 17, BLOCK 2, LOT 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8431' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'JENKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cinco Ranch Northwest Sec 17' ,`TaxAmount` = '13636' ,`TaxRate` = '2.7545' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665667216' WHERE `Matrix_Unique_ID` = '211136241' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-13T05:59:28.067' ,`MLSNumber` = '61846181' ,`ListAgentFullName` = 'Ivan Williams' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = 'Linda Blair' ,`SellingOfficeName` = 'Blair Realty Group' ,`Latitude` = '30.013351' ,`Longitude` = '-95.743561' ,`PhotoCount` = '43' ,`PostalCode` = '77433' ,`RoomCount` = '6' ,`ListPrice` = '310000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Blue Hyacinth' ,`StreetNumber` = '20502' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1600' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fabulous Master Plan Fairfield Gem – Cul-de-Sac Lot with covered patio, Gourmet Kitchen with Stainless Steel appliances and Granite counters with Tile back splash and spacious Breakfast Nook, 42\'\' cabinets and under cabinet lighting. Kitchen peninsula with breakfast bar seating is great for entertaining with surround sound wiring. Primary Bedroom with room for seating area and large windows open to backyard, Primary bath has dual sink vanity, large soaker tub and large glass shower and walk-in closet. Secondary Bedrooms all have walk-in closets for plenty of storage through-out. Ceiling fans, 2-inch Window blinds, 2 car garage with room for storage and garage door opener, full sprinkler system, and covered patio with natural gas outlet for entertaining/relaxing area with Fan and Light leading to the backyard with minimal back neighbors, large side yard in this Cul-de-Sac home. Easy access to Grand Parkway, Tomball, Katy and Houston Premium Outlets. Top-rated schools in Cy-Fair ISD.' ,`Acres` = '0.1455' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 34 BLK 1 FAIRFIELD VILLAGE NORTH SEC 10' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '6336' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1011' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'SWENKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Fairfield Village North Sec 10' ,`TaxAmount` = '6101' ,`TaxRate` = '2.611' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1665667216' WHERE `Matrix_Unique_ID` = '211936082' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-13T05:42:03.817' ,`MLSNumber` = '8877107' ,`ListAgentFullName` = 'Brandy Liss' ,`ListOfficeName` = 'Priority One Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.652837' ,`Longitude` = '-95.177025' ,`PhotoCount` = '40' ,`PostalCode` = '77504' ,`RoomCount` = '10' ,`ListPrice` = '400000.00' ,`Status` = 'Active' ,`StreetName` = 'Argentina' ,`StreetNumber` = '4310' ,`StreetSuffix` = 'Circle' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2653' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning Custom-Built Home in a Quiet Cul-de-Sac. Looking for something unique, one of a kind? You\'ll love this stunning custom built home! From the carved Tester bed to the copper roof accents, this home is full of beautiful details. Plus, it\'s located in a quiet cul-de-sac and has low HOA fees. Never flooded! You\'ll enjoy plenty of peace and privacy here. The lush landscaping and well-manicured lawn are just an added bonus. Inside you\'ll find plenty of space to spread out with three bedrooms and two and a half bathrooms. The large walk in closet is a real bonus and comes complete with built-ins. This home is perfect for those who love to entertain - the open floor plan makes it easy to host gatherings of all sizes. Don\'t miss out on this one - call today for your private showing! See attached Features and Updates sheet attached in forms--so many amazing features and upgrades.' ,`Acres` = '0.2057' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 1 VISTA VILLAS SEC 3' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '8960' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '25' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'JENSEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (PASADENA)' ,`SchoolMiddle` = 'PARKVIEW INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Vista Villas' ,`TaxAmount` = '7239' ,`TaxRate` = '2.6514' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665667217' WHERE `Matrix_Unique_ID` = '212202056' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-13T04:45:58.650' ,`MLSNumber` = '47857007' ,`ListAgentFullName` = 'Bob Nichols' ,`ListOfficeName` = 'Nichols & Associates Real' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.985410' ,`Longitude` = '-95.682328' ,`PhotoCount` = '50' ,`PostalCode` = '77429' ,`RoomCount` = '8' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Canyon Whisper' ,`StreetNumber` = '16706' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1916' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The home of your dreams is awaiting new owners on a treelined street. An inviting front porch welcomes you to this 3 bedroom, 2 bath home. Peaking through the leaded glass front door you will notice the luxury vinyl floors as they flow through all areas except for the carpet in the bedrooms. A captivating den overlooks a beautiful, updated kitchen + spacious dining room. The kitchen features plenty of storage, cabinets, drawers + counterspace seating for 4! Other kitchen improvements: Samsung appliances w/convection oven +5 gas burners, dishwasher, microwave + granite countertops w/tumbled marble backsplash + a double stainless steel sink. Primary suite is large enough for all styles of furniture, has a ceiling fan w/light, walk in closet, large soaking tub, separate shower, dual sinks + glass block window. Covered back patio w/ceiling fan, lights, wired for surround sound overlooks a fenced yard w/firepit for those get togethers. Roof 6/7 years old. HVAC in 2016. Water heater in 2009.' ,`Acres` = '0.1584' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 1 CYPRESS POINT LAKE ESTATES SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '575' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'FARNEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'GOODSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Cypress Point Lake Estates 05' ,`TaxAmount` = '5737' ,`TaxRate` = '2.751' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665667217' WHERE `Matrix_Unique_ID` = '212298431' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-13T05:58:36.120' ,`MLSNumber` = '75702705' ,`ListAgentFullName` = 'Shanna Carew' ,`ListOfficeName` = 'Henry Fuertes Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.816116' ,`Longitude` = '-95.022814' ,`PhotoCount` = '35' ,`PostalCode` = '77562' ,`RoomCount` = '5' ,`ListPrice` = '255000.00' ,`Status` = 'Active' ,`StreetName` = 'Foxglove' ,`StreetNumber` = '2503' ,`StreetSuffix` = 'Street' ,`City` = 'Highlands' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1868' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Must see one story home that has been fully renovated \"like new\" located in highlands, TX close to I-10 Lots of upgrades, all windows replaced with double paned energy efficient windows, new luxury vinyl throughout and new carpet in the bedrooms. Kitchen updated with new 42-inch elegant shaker cabinets, quartz countertops, polish marble mosaic tile backsplash and new stainless steel appliances including Gas range with air fryer and Wifi Connection. Bathrooms completely updated with double sinks as well as new shower and new cabinets, marble countertops and polish marble mosaic accent tiles in both bathrooms! HVAC systems updated in 2020 new ductwork, new furnace, and new condenser!! New 30-year roof installed in 2022. You don\'t want to miss the chance to own this \"like new\" home for creating great memories with your family!! Many other \r\nupgrades too numerous to mention!! You will not be disappointed! Call your agent and schedule your appointment today!\r\nHOUSE NEVER FLOODED' ,`Acres` = '0.2121' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 148 COUNTRY TERRACE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9240' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'HOPPER/HIGHLANDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Country Terrace Sec 02' ,`TaxAmount` = '3669' ,`TaxRate` = '2.235' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665667217' WHERE `Matrix_Unique_ID` = '212447892' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-13T04:25:24.923' ,`MLSNumber` = '7929886' ,`ListAgentFullName` = 'Fabiola Duenas' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.712794' ,`Longitude` = '-95.852576' ,`PhotoCount` = '50' ,`PostalCode` = '77441' ,`RoomCount` = '11' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Kenton Place' ,`StreetNumber` = '5119' ,`StreetSuffix` = 'Lane' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3573' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stylish & functional TRENDMAKER Home across greenbelt in award winning Cross Creek Ranch. TX sized front porch, majestic DOUBLE doors to soaring entry. STUDY w French doors w hardwoods & closet, DOWNSTAIRS 2ND BEDROOM w its own EN-SUITE BATH perfect guest suite. Breathtaking COFFERED ceilings in FORMAL dining, HUGE ISLAND in chef\'s kitchen, antique white cabinetry, hardware, double molding, matching backsplash w glass insert, XL PANTRY, SS appliances flows to breakfast & family room, fireplace w/ mantle & view of covered patio & OUTDOOR KITCHEN for easy grilling. LUX primary has spa like XL shower+ whirlpool tub perfect to relax. Upstairs is two spacious bedrooms, large bath w granite & double sinks, XL GAME room & formal MEDIA room w custom sectional & surround sound that stays! Energy Star home, sprinkler system, LED lights, 3 CAR tandem garage. A+ Katy ISD. Walk/bike to Randolph Elem; Adams Jr & Jordan High School is now #2 in district! Johnson Master planned resort like amenities!' ,`Acres` = '0.1775' ,`Area` = '36' ,`BuilderName` = 'TRENDMAKER' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CREEK BEND AT CROSS CREEK RANCH SEC 6, BLOCK 2, LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7731' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'JAMES E RANDOLPH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cross Creek Ranch' ,`TaxAmount` = '12842' ,`TaxRate` = '3.1375' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665667217' WHERE `Matrix_Unique_ID` = '212448506' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-13T05:58:42.237' ,`MLSNumber` = '54455319' ,`ListAgentFullName` = 'Stacey Robertson' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.306286' ,`Longitude` = '-95.396142' ,`PhotoCount` = '42' ,`PostalCode` = '77301' ,`RoomCount` = '11' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Piney Meadow' ,`StreetNumber` = '4004' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2432' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming four bedroom home on a beautiful one acre property surrounded by towering, mature trees! Spacious & open 4/2 split floor plan: large living room with wood-burning fireplace overlooking the front yard; large family room overlooking the backyard; generous kitchen with island and ample counter space and storage with the breakfast room to one side and the dining room to the other; oversized master suite with ensuite bath, double sinks, soaking tub, separate shower and large walk-in closet. Fresh interior and exterior paint. New carpet. Great location close to dining, shopping, schools, medical facilities and more. Call today and come appreciate this peaceful, private setting and all this home has to offer!' ,`Acres` = '1' ,`Area` = '19' ,`BuilderName` = 'Palm Harbor Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S801202 - PINEY MEADOWS 02, BLOCK 1, LOT 3, SERIAL # PH05167' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '60' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'PATTERSON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Piney Meadows' ,`TaxAmount` = '3019' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665667217' WHERE `Matrix_Unique_ID` = '212817831' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-13T05:31:52.800' ,`MLSNumber` = '94641588' ,`ListAgentFullName` = 'Patricia Rivera' ,`ListOfficeName` = 'Cornerstone Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.871573' ,`Longitude` = '-95.427177' ,`PhotoCount` = '17' ,`PostalCode` = '77088' ,`RoomCount` = '12' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Saint Clair' ,`StreetNumber` = '1065' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2049' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully designed NEWLY CONSTRUCTED home in Dream Homes Garden Subdivision. This home incorporates the following features: LED recessed lights, open concept, split bedrooms, frameless shower, quartz countertops, self closing cabinets, SS appliances, and covered patio. Estimated Completion date: SEPTEMBER 2022. OPTIONAL UPGRADES MAY BE AVAILABLE DEPENDING ON STATUS OF CONSTRUCTION.' ,`Acres` = '0.06492' ,`Area` = '11' ,`BuilderName` = 'D&C Dream Homes, LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 BLK 1 DREAM HOMES GARDEN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2828' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'OSBORNE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Dream Homes Garden' ,`TaxAmount` = '351' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665667218' WHERE `Matrix_Unique_ID` = '212848094' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-13T05:57:29.883' ,`MLSNumber` = '78717429' ,`ListAgentFullName` = 'Marie Janke' ,`ListOfficeName` = 'Janke and Co Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.233716' ,`Longitude` = '-94.890037' ,`PhotoCount` = '27' ,`PostalCode` = '77554' ,`RoomCount` = '9' ,`ListPrice` = '1317000.00' ,`Status` = 'Active' ,`StreetName` = 'STARFISH DR' ,`StreetNumber` = '11376' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2350' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'STUNNING Home is under construction, but don\'t let this stop you, make selections before it\'s too late! SHORT TERM RENTALS ALLOWED . This amazing 2,350 sq ft luxury vacation home has BEACHSIDE construction features that include 4-5 bedrooms and 3 full baths, DOUBLE BALCONIES, standing seam metal roof , a walk in closet in the primary bedroom with a walk out porch to enjoy your morning coffee! Also included are stainless kitchen appliances, pendant lighting over the kitchen island, easy care vinyl plank flooring, designer tile in bathrooms, custom wood kitchen cabinetry, quartz countertops and large kitchen island. Enjoy a bonus room and many more luxury amenities throughout . This neighborhood is highly sought after and does allow short term vacation rental opportunities for additional income. Photos are from a sister property & may differ from actual buildout. POOL IS OPTIONAL, inquire for details.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'SANDPIPER HOMES INC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 606' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '4800' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '313' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Other' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'BEACHSIDE VILLAGE' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665667218' WHERE `Matrix_Unique_ID` = '212868777' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-13T04:23:05.757' ,`MLSNumber` = '22974672' ,`ListAgentFullName` = 'Jeremiah Hobbs' ,`ListOfficeName` = 'United Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.701203' ,`Longitude` = '-95.476446' ,`PhotoCount` = '6' ,`PostalCode` = '77081' ,`RoomCount` = '4' ,`ListPrice` = '1499000.00' ,`Status` = 'Active' ,`StreetName` = 'Aspen' ,`StreetNumber` = '5500' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '4441' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Pre construction opportunity on a large corner lot zoned to Bellaire high school! This stunning custom contemporary design offers an open floor plan with custom countertops/cabinets, smart wiring, state of the art lighting, an EV charging station, cooled/heated garage, and generator for the entire home. The first level has high ceilings and expansive windows offering plenty of natural light! It also boasts a chef\'s kitchen with a massive walk-in pantry, wine storage room, flex room and catering kitchen. All bedrooms are on the second floor. The large primary suite has 2 walk in closets and spacious bath. The back yard offers over 700sf covered patio space and custom landscaping! Ask the builder about the pool and pool house/mother in law suite option! Currently there’s a renovated ranch style home with 4 bedrooms/2 baths on the lot. Earn rental income as you finalize plans! Schedule a meeting with the builder today!' ,`Acres` = '0.2162' ,`Area` = '17' ,`BuilderName` = 'Builder 44' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bellaire Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 28 BLK 8 RICHMOND PLAZA' ,`LotDesciption` = 'Corner' ,`LotSize` = '9418' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CONDIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Richmond Plaza' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665667218' WHERE `Matrix_Unique_ID` = '212980954' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-13T04:48:19.003' ,`MLSNumber` = '53293724' ,`ListAgentFullName` = 'Stacey Lochan-Joseph' ,`ListOfficeName` = 'CENTURY 21 Western Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.829944' ,`Longitude` = '-95.800964' ,`PhotoCount` = '50' ,`PostalCode` = '77493' ,`RoomCount` = '8' ,`ListPrice` = '369900.00' ,`Status` = 'Active' ,`StreetName` = 'Stefano Palette' ,`StreetNumber` = '3847' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2630' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Like new 2 story home located in Camillo Lakes! Covered front porch with an UPGRADED Glass Front Door. \r\nOpen floor concept, high ceilings, lots of natural light. Spacious living room overlooking huge kitchen, Granite countertops, 42\" cabinets, beautiful backsplash that also accommodates bar seating area and window seating\r\nUpgraded fixtures like the Farmhouse Lighting in the dining room. Primary bath has a tub, separate shower, walk in closet. Spacious utility room. HUGE Game room with separate nook area for an office/study. Zoned to Katy ISD. Excellent location for all your Restaurants, Shopping and Entertainment. Amazing home with lots of Great features, make an appointment today to make this YOUR Home!!!' ,`Acres` = '0.0836' ,`Area` = '25' ,`BuilderName` = 'Legend Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 69 BLK 4 CAMILLO LAKES SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3640' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'LEONARD ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Camillo Lakes Sec 4' ,`TaxAmount` = '9729' ,`TaxRate` = '3.5333' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665667218' WHERE `Matrix_Unique_ID` = '213254121' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-13T05:48:55.183' ,`MLSNumber` = '73352938' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.293380' ,`Longitude` = '-95.410845' ,`PhotoCount` = '9' ,`PostalCode` = '77301' ,`RoomCount` = '14' ,`ListPrice` = '499990.00' ,`Status` = 'Active' ,`StreetName` = 'Hawthorn Stream' ,`StreetNumber` = '1905' ,`StreetSuffix` = 'Way' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction.' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Briarwood Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1 Block 3' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'RUNYAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Barton Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '2.7863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665667218' WHERE `Matrix_Unique_ID` = '213503067' --> 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','213507371','1665667219','213507371','2022-10-13T05:50:34.913','22179357','Lorena Cousin','Surge Realty','','','29.669999','-95.269134','43','77061','4','299000.00','Active','Glenscott','8202','Street','Houston','2','0','4','2215','Single-Family','Just in time for Fall, this stunning, vibrant, 1-story, 4 bedroom 2 bathroom home, includes a bonus added room which you may access from the bedroom or living area. The home is conveniently located near I-45, 20 min to Downtown and 5 minutes to Hobby Airport. Numerous restaurants, shopping locations as well as the Port Of Houston. Includes an inviting open floor plan and high beamed ceiling that connects the spacious living, remodeled kitchen and breakfast area. The homes kitchen now features modern white cabinets, granite countertops, undermounted kitchen sink, vinyl plank throughout the living, kitchen and breakfast areas. Wood flooring is located throughout the rest of the home which includes the formal dining, bedrooms and baths. Fresh painting in select rooms inside and fully painted outside. All window frames are new and have been replaced. The wrap around drive up driveway, includes a newly replaced driveway gate. \r\nThe Welcoming backyard is ready for your families enjoyment.','0.1811','3','','','','','Sellers Disclosure','0','','','Hobby Area','Central Electric','0','LT 9 BLK 5 MEADOWBROOK FREEWAY','Subdivision Lot','7888','Appraisal District','','','0','','1','','0','','','','','Composition','27 - Houston','LEWIS/Bellfort Academy','CHAVEZ HIGH SCHOOL','ORTIZ MIDDLE SCHOOL','Accompany,Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Meadowbrook Fwy','4317','2.3307','Public Sewer,Public Water','1958','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','213525086','1665667219','213525086','2022-10-13T05:34:40.610','55141530','Jose Torres','eXp Realty, LLC','','','30.072764','-95.407483','25','77373','4','290000.00','Active','Hickory Valley Lane','25522','','Spring','2','0','4','1927','Single-Family','**OPEN HOUSE Saturday 10/15-10/16 1PM-3PM** This beautiful home built in 1971 has been fully renovated with modern style accents. Upon entering, you’re greeted with a formal living area that leads into the formal dining. The kitchen features quartz countertops and brand new stainless appliances (refrigerator included). From the kitchen you can enjoy the views of the wood burning fireplace and large brick pillars. You will also find built in book shelves conveniently located in the living area. This beautiful single story home has 4 large bedrooms with the primary bedroom conveniently located towards the back of the home. The primary bathroom features a custom built walk-in shower with dual sink vanity. Roof and A/C replaced June 2022! This home is conveniently located within minutes of the Woodlands, multiple restaurants and major freeways.','0.2101','12','','','Electric Dryer Connections','','Mud,Sellers Disclosure','1','Wood Burning Fireplace','1','Spring East','Central Electric','1','LT 6 BLK 5 LEXINGTON WOODS SEC 1','Subdivision Lot','9150','Appraisal District','','395','0','','2','Electric Oven','0','','','Electric Range','','Composition','48 - Spring','JOHN WINSHIP ELEMENTARY SCHOOL','SPRING HIGH SCHOOL','TWIN CREEKS MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Lexington Woods','3373','2.2769','Water District','1971','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-13T05:48:18.210' ,`MLSNumber` = '94792718' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.021789' ,`Longitude` = '-95.327917' ,`PhotoCount` = '12' ,`PostalCode` = '77338' ,`RoomCount` = '15' ,`ListPrice` = '478535.00' ,`Status` = 'Active' ,`StreetName` = 'Cypress Woods Mist' ,`StreetNumber` = '6839' ,`StreetSuffix` = 'Trail' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3177' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction.' ,`Acres` = '' ,`Area` = '12' ,`BuilderName` = 'Briarwood Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 24 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '310' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CYPRESSWOOD ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypresswood Point' ,`TaxAmount` = '' ,`TaxRate` = '2.93' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665667219' WHERE `Matrix_Unique_ID` = '213528127' --> 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','213535936','1665667219','213535936','2022-10-13T05:49:45.570','91828868','Michelle Cannon','RE/MAX Distinction','','','30.175684','-95.608864','38','77354','11','340000.00','Active','Champion Oaks','28611','Drive','Magnolia','2','0','3','1948','Single-Family','This amazing 1-story home sits on a beautiful lot with no back neighbors, gorgeous rock waterfall pool and no HOA! The home features a split plan with primary bedroom in the back of the house with it\'s own door out to the pool, island kitchen with breakfast bar, double ovens and gas cooktop, and large breakfast room all open to the family room. Large secondary bedrooms plus a study with french doors and formal dining room. High ceilings, laminate wood flooring throughout and lots of windows looking out to the backyard.','','15','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Magnolia/1488 East','Central Electric,Propane','0','Champion Glen 01, Block 4, Lot 5, Acres 0.210','Subdivision Lot','9000','Appraisal District','','','0','','2','Double Oven,Electric Oven','1','Gunite,In Ground','','Gas Cooktop','','Composition','36 - Magnolia','CEDRIC C. SMITH ELEMENTARY SCHOOL','MAGNOLIA HIGH SCHOOL','BEAR BRANCH JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Champion Glen','','1.97','Public Sewer,Public Water','2015','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','213571447','1665667219','213571447','2022-10-13T05:42:31.460','97704515','Nadia Carron','Martha Turner Sotheby\'s International Realty','','','29.875461','-95.667158','37','77084','6','235000.00','Active','Renata','6810','Circle','Houston','2','0','3','1323','Single-Family','Welcome Home! Lovely 3/2 home showcases beautiful front landscaping! Spacious family room boasts a corner gas fireplace that offers an open concept-perfect for entertaining! Dream kitchen is equipped with a serving bar, pantry and gas cooking! Large master and secondary bedrooms! Master bath features a whirlpool garden tub, separate shower, and walk-in closet! An open patio and well manicured yard completes the package!','0.1148','8','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Bear Creek South','Central Gas','1','LT 45 BLK 2 CROSSING AT STONE CREEK SEC 1','Subdivision Lot','5000','Appraisal District','','400','0','','2','Gas Oven','0','','','Gas Range','','Composition','13 - Cypress-Fairbanks','HOLMSLEY ELEMENTARY SCHOOL','LANGHAM CREEK HIGH SCHOOL','KAHLA MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Crossing At Stone Creek','4366','2.706','Public Sewer,Public Water','2002','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','213610924','1665667219','213610924','2022-10-13T04:26:11.830','76851392','Feras Rachid','Opendoor Brokerage, LLC','','','30.049357','-95.603200','29','77375','3','300000.00','Active','Cherokee Bluff','19443','Drive','Tomball','2','0','3','1838','Single-Family','This Tomball one-story home offers granite countertops, and a two-car garage.','0.26','14','','','','','Sellers Disclosure','1','','1','Spring/Klein/Tomball','Central Gas','1','LT 5 BLK 1 PINECREST FOREST SEC 2','Subdivision Lot','11326','Appraisal District','','370','0','','2','','0','','','','','Other','32 - Klein','KOHRVILLE ELEMENTARY SCHOOL','KLEIN CAIN HIGH SCHOOL','ULRICH INTERMEDIATE SCHOOL','Appointment Required,No Supra Keybox','Seller','1','Traditional','Pinecrest Forest Sec 02','5577','2.7066','Water District','1999','Seller'); --> New record created successfully