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-24T17:25:49.740' ,`MLSNumber` = '58349297' ,`ListAgentFullName` = 'Richard Fenyes' ,`ListOfficeName` = 'Rocket, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.084967' ,`Longitude` = '-95.234763' ,`PhotoCount` = '25' ,`PostalCode` = '77365' ,`RoomCount` = '7' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Cascade Mountain' ,`StreetNumber` = '22008' ,`StreetSuffix` = 'Drive' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2690' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Super clean & spacious 4-BEDROOM (largest floor-plan) newer home with many fabulous upgrades, including many features, located in a great location, close to 99 Grand Parkway, 59/69, close to restaurants, a new shopping center (new grocery store) and so much more.The family functional floorplan is open and inviting including upgraded elevated ceilings w/recessed lighting,ceiling fans w/lighting,an expansive(great for entertaining)all-granite island kitchen including ample aesthetically pleasing wrap-around counter space,also providing a barstool seating area;extremely nice,the kitchen also opens to dining & family room areas all harmoniously working together for optimum living.Home includes a guest powder-bath and the large Primary Bedroom is down with wonderful closet space;Primary bath includes separate garden tub & shower w/dual vanities.The upstairs game-FLEX room is it\'s own separate oasis that can provide space for more!Large in-home utility and beautiful backyard w/covered patio.' ,`Acres` = '0.1008' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S269800 - BROOKLYN TRAILS 01, BLOCK 1, LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4393' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'PORTER ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WOODRIDGE FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Brooklyn Trails 01' ,`TaxAmount` = '2863' ,`TaxRate` = '3.6031' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1669642122' WHERE `Matrix_Unique_ID` = '211594477' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T17:14:29.617' ,`MLSNumber` = '98674114' ,`ListAgentFullName` = 'Lili Wu' ,`ListOfficeName` = 'Forever Realty' ,`SellingAgentFullName` = 'Paul Gay' ,`SellingOfficeName` = 'Keller Williams Realty - Memor' ,`Latitude` = '29.568336' ,`Longitude` = '-95.144177' ,`PhotoCount` = '26' ,`PostalCode` = '77062' ,`RoomCount` = '9' ,`ListPrice` = '235000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Stradbrook' ,`StreetNumber` = '15210' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1723' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A great location, two story, high ceiling Open Floor plan home~ Elegant details throughout such as crown molding, high ceilings, granite countertops, hard surface flooring. Primary bedroom down stairs, two bedrooms upstairs, and a 4th extra room in Garage with a window AC. Easy walk to Park, pool, and Tennis court. Big backyard space with a patio and pergola overhead. Near Baybook mall, perfect for all of your shopping and dining needs. LOW HOA, LOW TAX, Great School Zone.' ,`Acres` = '0.1663' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 58 BLK 9 MEADOWGREEN SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7245' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '79' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'CLEAR LAKE CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'CLEARLAKE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Meadowgreen Sec 02' ,`TaxAmount` = '4867' ,`TaxRate` = '2.5769' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642123' WHERE `Matrix_Unique_ID` = '212801724' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T18:47:14.270' ,`MLSNumber` = '25755519' ,`ListAgentFullName` = 'Jennifer Jaeger-Karp' ,`ListOfficeName` = 'RE/MAX Associates Northeast' ,`SellingAgentFullName` = 'Greg Fazzino' ,`SellingOfficeName` = 'RE/MAX Associates Northeast' ,`Latitude` = '30.072110' ,`Longitude` = '-95.182158' ,`PhotoCount` = '14' ,`PostalCode` = '77345' ,`RoomCount` = '6' ,`ListPrice` = '215000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Still Glade' ,`StreetNumber` = '4107' ,`StreetSuffix` = 'Lane' ,`City` = 'Kingwood' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1214' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this charming 3 bedroom, 2 bathroom home situated on a quiet cul de sac just steps away from the neighborhood maintained greenbelt. Features include a spacious family room that has a cozy fireplace, plantation shutters with high ceilings & is open to the dining area plus a flex room that can be used as a study that is located off of the family room or as a third bedroom. Home has a covered patio with a generous deck along the side and back yard. Easy to maintain. Recent updates include freshly painted throughout the interior and new carpet installed in all 3 bedrooms (10/2022) HVAC system (2020) Kitchen appliances (2017) Water heater (2012) Plantation Shutters (2019) FULL HOUSE GENERATOR AND SOLAR PANELS (owned) Neighborhood greenbelts, pool, parks, tennis and boat access to Lake Houston. NEVER FLOODED. Good schools! With walking distance to Elementary school. Home has been virtually staged to show its full potential.' ,`Acres` = '0.1217' ,`Area` = '32' ,`BuilderName` = 'Weekley' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 7 MILLS BRANCH VILLAGE SEC 1' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot,Wooded' ,`LotSize` = '5303' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '440' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'HIDDEN HOLLOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mills Branch Village Sec 01' ,`TaxAmount` = '4380' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642123' WHERE `Matrix_Unique_ID` = '213645275' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T17:26:31.063' ,`MLSNumber` = '97050256' ,`ListAgentFullName` = 'Sara Englishbee' ,`ListOfficeName` = 'Home Sweet Home RE Group' ,`SellingAgentFullName` = 'Anya Delacruz' ,`SellingOfficeName` = 'William Lo, REALTOR' ,`Latitude` = '30.049353' ,`Longitude` = '-95.384943' ,`PhotoCount` = '33' ,`PostalCode` = '77373' ,`RoomCount` = '4' ,`ListPrice` = '185000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Summer Pine' ,`StreetNumber` = '23239' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1167' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home originally was a one bedroom / one bath. In 2020, a 288 sq. ft. one bedroom / one bath\r\naddition was added. A back patio and new roof were also completed in 2020. In 2015, the original bath was\r\nredone, and also expanded at both ends. A new Carrier A/C was installed along with all new ductwork.\r\nThe home has been transformed and is in very good condition. It is located on a quiet street\r\nconveniently located close to town. The 3 large living room windows look out onto the street and\r\nbrightens the home each morning.' ,`Acres` = '0.0895' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TRS 46B & 47B BLK 2 CYPRESS TRAILS OF TIMBERLANE 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '335' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'GLORIA MARSHALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Trails Timberlane 02' ,`TaxAmount` = '3166' ,`TaxRate` = '3.0268' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642123' WHERE `Matrix_Unique_ID` = '213832223' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T17:04:43.323' ,`MLSNumber` = '17674318' ,`ListAgentFullName` = 'Claudia Oakley' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.116657' ,`Longitude` = '-95.561289' ,`PhotoCount` = '34' ,`PostalCode` = '77375' ,`RoomCount` = '9' ,`ListPrice` = '398000.00' ,`Status` = 'Active' ,`StreetName` = 'Running Eagle Falls' ,`StreetNumber` = '9111' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2819' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this charming 1.5 story Pulte home situated on a beautiful waterfront lot in the community of Wimbledon Falls! This spacious open floor plan has 4 bedrooms and 3 baths. All beds located on first floor except 4th bedroom is on second floor w/ another full bath and oversized game room. This floor plan offers the private office in the first floor, mud room and huge laundry room. You will find a pristine chef\'s kitchen with oversized island, stainless steel appliances and granite countertops all of which is open to the family room! You don\'t want to miss the quiet backyard oasis where you can sit under the covered patio or gazebo and enjoy the lush landscaping and gorgeous views of the lake! This excellent masterplan community offers resort swimming pool, clubhouse, walking trails, green space and fitness center! Wonderful location and excellent schools! OPEN HOUSE Saturday and Sunday from 1-3p MOTIVATED SELLER HAS REDUCED THE PRICE $17k Awesome opportunity! Don’t miss it!!' ,`Acres` = '0.1758' ,`Area` = '14' ,`BuilderName` = 'Pulte' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 1 WIMBLEDON FALLS SEC 7' ,`LotDesciption` = 'Greenbelt,Water View' ,`LotSize` = '7658' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '990' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'METZLER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HOFIUS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wimbledon Falls Sec 7' ,`TaxAmount` = '8139' ,`TaxRate` = '2.834' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642123' WHERE `Matrix_Unique_ID` = '214336217' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T17:12:55.130' ,`MLSNumber` = '77746828' ,`ListAgentFullName` = 'Teresa Solache' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.156970' ,`Longitude` = '-95.325513' ,`PhotoCount` = '25' ,`PostalCode` = '77365' ,`RoomCount` = '7' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Youpon' ,`StreetNumber` = '20222' ,`StreetSuffix` = 'Lane' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1416' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful fully updated ranch style Property in the Golden Trails Subdivision in Porter TX. \r\nHome sits on almost an acre of cleared land and has new updates includes flooring, paint in and out, granite countertops, remodel both bathrooms, beautiful crown and base molding throughout, new fencing and more. \r\nFor that full peaceful country living, welcome your horses and chickens and let them run wild. \r\nIt\'s a great piece of property with so much potential for creativity. Make your memories here!\r\nCome check out this property before its gone!' ,`Acres` = '0.6786' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S536500 - GOLDEN TRAILS, LOT 20' ,`LotDesciption` = 'Cleared' ,`LotSize` = '29559' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'ROBERT CRIPPEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Right Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Golden Trails' ,`TaxAmount` = '4981' ,`TaxRate` = '2.1331' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642123' WHERE `Matrix_Unique_ID` = '214435635' --> 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','215005300','1669642124','215005300','2022-11-24T17:26:47.333','62609582','Graciela Lombard','Keller Williams Premier RealtyKaty','','','29.649647','-95.597338','48','77477','10','329000.00','Active','Cedar Form','12046','Lane','Meadows Place','2','0','4','2193','Single-Family','Immaculate 2-story home located in the desirable City of Meadows Place! It has its own Police, Fire, EMS, pool, tennis courts, nature center, beautiful lake, + a low tax rate! Zoned to the new Meadows Elem School. Enter the house through a real wood front door with stained- glass accent. Fresh paint throughout, double pane windows, dry cleaned custom draperies. Customized shelving in walk in closets as well as other areas of the house. A State -of-the-Art pantry, Double oven to cook for family and friends. Garage with insulated doors, ceiling fan, working area and epoxy flooring, 2nd fridge included. Fantastic backyard boasting a pond, aquaponic garden with solar and wind energy. rainwater collection system with 5 barrels to collect the water and a TREE HOUSE (All these improvements can stay or go) Beautifully manicured lawn, lots of plants, herbal garden, custom built shed, protected garden and working area with irrigation system. Covered patio for entertaining. room for a pool.','','29','','','Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections','1','Stafford Area','Central Gas','0','The Meadows Sec 4, Block 36, Lot 62','Cleared','9849','Appraisal District','','','0','','2','Double Oven','0','','','Electric Cooktop','','Composition','19 - Fort Bend','MEADOWS ELEMENTARY SCHOOL (FORT BEND)','DULLES HIGH SCHOOL','DULLES MIDDLE SCHOOL','Accompany,Appointment Required,Lockbox Right Side,Supra Keybox,Vacant/Unoccupied','Appraisal District','2','Traditional','The Meadows','5667','2.4949','Water District','1974','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','215077942','1669642124','215077942','2022-11-24T17:36:54.860','96272575','Eric Robinson','RE/MAX Preferred Homes','','','30.392077','-95.335813','16','77303','3','199999.00','Active','Dogwood','15037','Lane','Conroe','1','0','3','748','Single-Family','Bring all offers to This beautifully remodeled home that sits on 1 acre of totally fenced and cleared land complete with a Detached Garage with enough space to fit your car or Toys. So if you been looking for a unrestricted property to have a home and all your hobbies you have found it! The inside Showcases of a large living Room connected to the kitchen area, Down the hall on one side and on the other two generous sized bedrooms with a huge bathroom with a Tub/Shower Combo. So look no further, this is the home for you! Schedule your private showing today.','1','19','','','','','Sellers Disclosure','','','','Conroe Northeast','Central Electric','0','S945300 - WALCO ACRES, LOT 119, ACRES 1','Subdivision Lot','43560','Appraisal District','','','0','','1','','0','','','','','Composition','11 - Conroe','AUSTIN ELEMENTARY SCHOOL (CONROE)','CANEY CREEK HIGH SCHOOL','MOORHEAD JUNIOR HIGH SCHOOL','Lockbox Front','Appraisal District','1','Traditional','Walco Acres','3377','1.8488','Septic Tank,Well','1982','Appraisal District'); --> New record created successfully