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-09-29T05:32:50.937' ,`MLSNumber` = '57510180' ,`ListAgentFullName` = 'Michael Ramirez' ,`ListOfficeName` = 'MJR Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.808755' ,`Longitude` = '-95.147832' ,`PhotoCount` = '36' ,`PostalCode` = '77049' ,`RoomCount` = '9' ,`ListPrice` = '288000.00' ,`Status` = 'Active' ,`StreetName` = 'Sonoma Park' ,`StreetNumber` = '15922' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2341' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*2006 BUILD WITH 2341 SQ FT* * 4 SPACIOUS BEDROOMS WITH *GAMEROOM* 2 BATHROOMS AND 1/2* \r\n30 YEAR RIDGE VENT ROOF REPLACED A FEW YEARS AGO* CENTRAL AC HAS DUAL THERMOSTAT FEATURE \" INSPECTED AND OPERATING AS INTENDED\" ** WOOD LAMINATE FLOORS 2022 \"NO CARPET\" * PORCELAIN TILE 2022* INTERIOR PAINT 2022* SPACIOUS ISLAND KITCHEN WITH LOTS OF CABINETS AND COUNTER SPACE* QUARTZ COUNTER TOPS 2022* NEW GAS STOVE 2022* NEW DISHWASHER 2022* NEW CEILING FANS AND LOTS OF RECESSES LIGHTNING* GARAGE DOOR OPENER *' ,`Acres` = '0.1332' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 4 SONOMA RANCH SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5801' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '8 - Channelview' ,`SchoolElementary` = 'Brown Elementary School (Channelview)' ,`SchoolHigh` = 'CHANNELVIEW HIGH SCHOOL' ,`SchoolMiddle` = 'AGUIRRE JUNIOR HIGH' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sonoma Ranch Sec 06' ,`TaxAmount` = '5390' ,`TaxRate` = '2.518' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664449273' WHERE `Matrix_Unique_ID` = '210476545' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-29T05:44:00.717' ,`MLSNumber` = '18382681' ,`ListAgentFullName` = 'Norma Andersson' ,`ListOfficeName` = 'RE/MAX Compass' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.639565' ,`Longitude` = '-95.676772' ,`PhotoCount` = '34' ,`PostalCode` = '77498' ,`RoomCount` = '8' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Basewood' ,`StreetNumber` = '16806' ,`StreetSuffix` = 'Court' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2061' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this beautifully updated and maintained 4-bedroom 2-bath home featuring an oversized backyard and pool! This lovely home features warm wood-look laminate flooring throughout the living, dining, and kitchen areas. The warm paint palette, blanket of natural light, and spacious floorplan are a homeowner\'s delight when relaxing or entertaining. Each bedroom features plush neutral carpet and large closets. The kitchen features stainless appliances, tons of cabinets for plenty of storage, and an island breakfast bar! The dining room can also be used as a den. The double-sided fireplace makes for excellent use of space. The home is located on a cul-de-sac and greets you with lovely curb appeal. The large backyard and pool are perfect for relaxing, gardening, playing & pets. No back neighbors and walking distance to Austin High School, Garcia Middle School and tennis courts make this home very desirable.' ,`Acres` = '0.2088' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SUMMERFIELD SEC 4, BLOCK 3, LOT 23' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '9095' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '485' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground,Vinyl Lined' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'OYSTER CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Summerfield' ,`TaxAmount` = '5977' ,`TaxRate` = '2.6329' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664449273' WHERE `Matrix_Unique_ID` = '210556661' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-29T05:49:23.757' ,`MLSNumber` = '44734950' ,`ListAgentFullName` = 'Kasie Clement' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = 'Enrique Rosales' ,`SellingOfficeName` = 'RRR Agency, LLC' ,`Latitude` = '30.138952' ,`Longitude` = '-95.524583' ,`PhotoCount` = '29' ,`PostalCode` = '77389' ,`RoomCount` = '8' ,`ListPrice` = '439900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Rocky Point' ,`StreetNumber` = '93' ,`StreetSuffix` = 'Circle' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2571' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Look no further this Village Juniper home is the one that has it all! This floorplan offers 4 bedrooms, 2 1/2 baths, an office with french doors, plus a game room. Plenty of room to spread out and the privacy needed to work from home. This home features a granite & stainless kitchen with upgraded 42\'\' cabinets, and a large backyard W/mature trees! Zoned to the award winning Creekside Forest Elementary. Located only minutes from the amazing Rob Fleming Park and Aquatic Center and The Grand Parkway (Toll 99),' ,`Acres` = '0.1896' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 19 BLK 2 THE WOODLANDS VLG OF CREEKSIDE PARK 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8259' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'CREEKSIDE FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Creekside Park 05' ,`TaxAmount` = '8971' ,`TaxRate` = '2.6895' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664449273' WHERE `Matrix_Unique_ID` = '211054858' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-29T05:30:53.610' ,`MLSNumber` = '85147131' ,`ListAgentFullName` = 'Michael Ramirez' ,`ListOfficeName` = 'MJR Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.772267' ,`Longitude` = '-94.947648' ,`PhotoCount` = '36' ,`PostalCode` = '77521' ,`RoomCount` = '6' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = 'Broken Arrow' ,`StreetNumber` = '1604' ,`StreetSuffix` = 'Street' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1561' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL FULL BRICK HOME** BACKS TO PARK * \"NEW\" 30 YEAR RIDGE VENT ROOF 2022* FULL 2 CAR GARAGE WITH DOUBLE DRIVEWAY* JUST UPDATED * UPDATED KITCHEN WITH NEW 2022 QUARTZ COUNTER TOPS* NEW DISHWASHER AND NEW STOVE* ALL NEW PORCELAIN TILE IN KITCHEN AND BATHROOMS* NEW WOOD LAMINATE FLOORS IN DEN AND ALL BEDROOMS* BOTH BATHROOMS ARE COMPLETELY UPDATED * NEW TILE , NEW TUB,AND FAUCET, NEW VANITIES AND NEW TOILETS* 2 NEW GARAGE DOORS* NEW FRONT AND BACK EXTERIOR DOORS* CEILNG FANS IN ALL ROOMS*' ,`Acres` = '0.1848' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 30 BLK 1 CHAPARRAL VILLAGE SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'CEDAR BAYOU J H' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Chaparral Village Sec 04' ,`TaxAmount` = '4463' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664449273' WHERE `Matrix_Unique_ID` = '211555122' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-29T04:08:59.210' ,`MLSNumber` = '27874287' ,`ListAgentFullName` = 'Betsy Russell' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = 'Carolyn Swan' ,`SellingOfficeName` = 'CORCORAN FERESTER REALTY' ,`Latitude` = '30.169540' ,`Longitude` = '-95.586652' ,`PhotoCount` = '39' ,`PostalCode` = '77354' ,`RoomCount` = '8' ,`ListPrice` = '550000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Alamito Canyon' ,`StreetNumber` = '11' ,`StreetSuffix` = 'Place' ,`City` = 'The Woodlands' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Please click on link above for a virtual tour! This is a rare property in that it is a nearly new single-story home located in The Woodlands. Built by highly respected builder (Westin Homes) with many upscale architectural features and a floorplan that cannot be beat. The eight-foot doors, decorative ceilings, archways, tall baseboards, and central rotunda give this home a stunning appearance as it combines elegance with practicality making it perfect for anyone. Spectacular owners\' retreat with huge shower (with bench). Fireplace. Light-colored staggered, rectangular tile throughout all main living spaces including office. A half-bath in addition to three full bathrooms. The kitchen features ceiling-height expresso cabinets, granite, comfortable counter seating and a large dining area. A huge cul-de-sac lot has plenty of room for a pool. 2.5 car garage and excess attic storage.' ,`Acres` = '0.3313' ,`Area` = '15' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S969989 - WDLNDS VIL STERLING RIDGE 89, BLOCK 3, LOT 37' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '14442' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Sterling Ridge 89' ,`TaxAmount` = '9021' ,`TaxRate` = '2.2915' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664449273' WHERE `Matrix_Unique_ID` = '211673472' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-29T05:30:30.010' ,`MLSNumber` = '2866880' ,`ListAgentFullName` = 'Otilia Robles' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.600276' ,`Longitude` = '-95.211355' ,`PhotoCount` = '29' ,`PostalCode` = '77089' ,`RoomCount` = '10' ,`ListPrice` = '238990.00' ,`Status` = 'Active' ,`StreetName` = 'Sagehaven Dr' ,`StreetNumber` = '11230' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1585' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful, all brick, one-story, split 3-bedroom/ 2-bathroom home in the popular established neighborhood of Sagemont. As you walk in the door to your right you will find a spacious flex room perfect for a formal dining room, home office, gym, game room, or 2nd living room. The remodeled bathrooms and kitchen, solid surface flooring (no carpet), freshly painted interior, mature trees, private backyard, epoxy garage floor, and added sunroom with a private office make this home a must see. Easy access to major freeways. Close to hospitals, Ellington Field, NASA, Galveston, Kemah, San Jacinto College South, University of Houston Clear Lake, BayBrook Mall, and many restaurants and entertainment venues. Low tax rate and maintenance fund.' ,`Acres` = '' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 10 SAGEMONT SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7580' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '50' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'STUCHBERY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'THOMPSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sagemont Sec 02' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664449273' WHERE `Matrix_Unique_ID` = '212341085' --> 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','212366331','1664449274','212366331','2022-09-29T05:25:13.440','60200891','Bobbie Higginbotham','UTR TEXAS, REALTORS','','','29.558938','-95.429398','25','77584','8','362000.00','Active','Moonlit Lake','13420','Lane','Pearland','2','0','3','2329','Single-Family','This lovely home is nestled in the beautiful and highly desired neighborhood of Shadow Creek Ranch. Welcome your guest to your lovely 3 bedrooms, 2 full bathrooms, spacious office with walls of built-in shelving. You\'ll love the free-flowing floor plan between the dining room, kitchen, & living areas, wired for surround sounds w/plenty of flexibility for entertaining. The kitchen overlooks the living area & features granite countertops, a sizable pantry w/SS appliances. A wall of large windows to let in all the natural light to greet you each morning. Spacious Primary suite w/a garden tub, double sinks, glass enclosed shower, walk-in closets. Crown molding through the home. Backyard with a patio, room to play and is low maintenance, no backyard neighbors. Brand new flooring in common areas, water heater, & AC system in the last 2 years. Easy walking distance to great amenities including walking trails, community pools, playgrounds + zoned to Alvin ISD schools! PER SELLER NEVER FLOODED','0.142','5','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Pearland','Central Electric,Central Gas','1','SHADOW CREEK RANCH SF41 (PEARLAND), BLOCK 1, LOT 10','Subdivision Lot','6186','Appraisal District','','999','0','','2','Double Oven,Gas Oven','0','','','Gas Range','','Composition','3 - Alvin','YORK ELEMENTARY SCHOOL','SHADOW CREEK HIGH SCHOOL','MCNAIR JUNIOR HIGH SCHOOL','Supra Keybox','Appraisal District','1','Traditional','Shadow Creek Ranch Sf1-Sf2-Sf3','9162','3.5409','Public Sewer,Public Water','2008','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-29T05:36:11.113' ,`MLSNumber` = '60205541' ,`ListAgentFullName` = 'Ayo Oluwi' ,`ListOfficeName` = 'J. Lindsey Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.548902' ,`Longitude` = '-95.799830' ,`PhotoCount` = '27' ,`PostalCode` = '77471' ,`RoomCount` = '3' ,`ListPrice` = '256000.00' ,`Status` = 'Active' ,`StreetName` = 'Madison' ,`StreetNumber` = '2601' ,`StreetSuffix` = 'Avenue' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1625' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home in a great neighborhood with a private pool and fireplace.New floor, new washable paint and fittings (2022)with Quartz counter top in the kitchen.Primary bedroom is very spacious and the house layout is very welcoming.' ,`Acres` = '0.1834' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'CAMBRIDGE VILLAGE SEC 1, BLOCK 2, LOT 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7991' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'RAY ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'TERRY HIGH SCHOOL' ,`SchoolMiddle` = 'NAVARRO/GEORGE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'English' ,`Subdivision` = 'Cambridge Village Sec 1' ,`TaxAmount` = '4026' ,`TaxRate` = '2.0748' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664449274' WHERE `Matrix_Unique_ID` = '212401167' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-29T05:13:16.067' ,`MLSNumber` = '17803818' ,`ListAgentFullName` = 'Yolanda Ingram' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.057609' ,`Longitude` = '-95.557867' ,`PhotoCount` = '36' ,`PostalCode` = '77379' ,`RoomCount` = '9' ,`ListPrice` = '472000.00' ,`Status` = 'Active' ,`StreetName` = 'Night Beacon Point' ,`StreetNumber` = '9106' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2457' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful One Story with Pool and Spa. On a Cul de Sac and on a Greenbelt. Spectacular floor open floor plan with 3 bedrooms, Game room down between the secondary bedrooms. Boasts a nice size formal dining room and an office/study. This kitchen offers an island with breakfast bar and a breakfast room. The secret.....there is a small basketball court inside the back yard! The spectacular pool and spa has privacy and lovely landscaping!\r\nThere are newer features with this home: roof 2016, pool heater 2020, and pool pump 2021. Kitchen cabinets will be painted white in the next few days.' ,`Acres` = '0.216' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 1 GLEANNLOCH FARMS SEC 30' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '9408' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'FRANK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'DOERRE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gleannloch Farms Sec 30' ,`TaxAmount` = '6872' ,`TaxRate` = '2.7315' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664449274' WHERE `Matrix_Unique_ID` = '212460829' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-29T05:14:56.373' ,`MLSNumber` = '44293765' ,`ListAgentFullName` = 'Victoria Fernandez' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.327195' ,`Longitude` = '-94.942263' ,`PhotoCount` = '31' ,`PostalCode` = '77563' ,`RoomCount` = '11' ,`ListPrice` = '420000.00' ,`Status` = 'Active' ,`StreetName` = 'Barracuda' ,`StreetNumber` = '196' ,`StreetSuffix` = 'Street' ,`City` = 'Bayou Vista' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1847' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy and relax yourself at home, front canal residence. Renovated beautiful house with new appliances, bonus washer and dryer. An additional refrigerator at lower level. New cabinets throughout the house, quartz counters. Upper-level laminated flooring and 2 carpeted bedrooms, 2 full bathrooms. Lower-level tile flooring and 2 additional bedrooms and 1 full bathroom. Plenty of storage space inside and outside. Minutes away from Galveston and shops.\r\nRooms dimensions are approximate.' ,`Acres` = '0.1033' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bayou Vista' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 7 PAGE 7 LOT 196 NEW BAYOU VISTA ADDN 2' ,`LotDesciption` = 'Water View' ,`LotSize` = '4500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HAYLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'New Bayou Vista 2' ,`TaxAmount` = '5257' ,`TaxRate` = '2.635' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664449274' WHERE `Matrix_Unique_ID` = '212706960' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-29T05:55:03.677' ,`MLSNumber` = '7330603' ,`ListAgentFullName` = 'Theresa Burkham' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.396833' ,`Longitude` = '-95.603732' ,`PhotoCount` = '24' ,`PostalCode` = '77356' ,`RoomCount` = '6' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Woodland' ,`StreetNumber` = '3526' ,`StreetSuffix` = 'Lane' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1585' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful single-story home located on a cul-de-sac corner lot in highly desired section of Walden on Lake Conroe. Granite countertops, lots of cabinets and storage, stainless steel appliances in kitchen, new dishwasher, carpet and tile flooring, separate jet tub/shower in primary bath, large walk-in closet. Vaulted ceiling and wood burning fireplace in living room. Two nice sized bedrooms that can also be used as an office. Large fully fenced yard with screened in patio and professional landscaping with seven zones sprinkler system. Great starter home, retirement home or second home near the lake. Close to Lake Conroe and amazing restaurants. Amenities in Walden on Lake Conroe include 2 boat ramps, tennis and fitness center, subdivision pool and adult lap pool, access to golf course, dog parks and lots of walking trails and so much more. Come see this beautiful home before it is gone!' ,`Acres` = '0.1552' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S945503 - WALDEN 03, BLOCK 14, LOT 7, 34.000000% UDI' ,`LotDesciption` = 'Corner,In Golf Course Community,Subdivision Lot' ,`LotSize` = '6760' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MADELEY RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Walden 03' ,`TaxAmount` = '4272' ,`TaxRate` = '2.1392' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664449274' WHERE `Matrix_Unique_ID` = '212782422' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-29T05:13:20.357' ,`MLSNumber` = '67869697' ,`ListAgentFullName` = 'Jon Forde' ,`ListOfficeName` = 'Keller Williams Advtge Realty' ,`SellingAgentFullName` = 'Elda Armenta' ,`SellingOfficeName` = 'White Picket Realty LLC' ,`Latitude` = '29.913261' ,`Longitude` = '-95.588050' ,`PhotoCount` = '33' ,`PostalCode` = '77065' ,`RoomCount` = '4' ,`ListPrice` = '249900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Travelers Way' ,`StreetNumber` = '11339' ,`StreetSuffix` = 'Circle' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1962' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Four bedroom split floorplan, three bedrooms on one side with primary bedroom on the other with a courtyard in-between. Vaulted ceilings in living room with a wood burning fireplace. Light and bright with a transom above the backyard double doors leading to a courtyard that is backed up to a ravine / greenspace with no backyard neighbors! Lots of privacy! Kitchen and primary bath were remodeled approximately 10 years ago, beautiful custom cabinets & granite countertops in kitchen. This home also has a breakfast room & formal dining room, come see this beautiful single story zoned to Cy-Fair schools! Steeplechase also has a pool & clubhouse just around the corner! Thank you for showing!' ,`Acres` = '0.1417' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 74 BLK 1 STEEPLECHASE SEC 5 PAR R/P AMD' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '6172' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '610' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'EMMOTT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'CAMPBELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Steeplechase' ,`TaxAmount` = '5549' ,`TaxRate` = '2.541' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664449274' WHERE `Matrix_Unique_ID` = '212844493' --> 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','213005258','1664449275','213005258','2022-09-29T05:41:32.190','3776726','Rafael Mata','CB&A, Realtors','','','29.895437','-95.731895','41','77433','8','335000.00','Active','Aleppo Pine','8115','Lane','Cypress','2','1','4','2340','Single-Family','Welcome to this beautiful 2-story Beazer Home in Pine Creek/Canyon Lakes West Neighborhood. This spacious home has its primary bedroom on the first floor & 3 other bedrooms together with large game room on the second. This home has no direct back yard neighbors and faces west, so you could enjoy those sunsets as much as you would like. Zoned to top rated Cypress-Fairbanks Independent School District and with access to lake by side walking trails, community pool, parks, splash pad, amenities this home offers a lifestyle dreams are made of. Booked your private showing today!','0.1148','25','Beazer','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Cypress South','Central Gas','1','LT 21 BLK 1 PINE CREEK AT CANYON LAKES WEST SEC 12','Subdivision Lot','5000','Appraisal District','','1000','0','','2','Convection Oven','0','','','Gas Range','','Composition','13 - Cypress-Fairbanks','ANDRE ELEMENTARY SCHOOL','CYPRESS SPRINGS HIGH SCHOOL','ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Pine Creek/Canyon Lakes West Sec','7759','3.041','Water District','2016','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-29T05:35:20.477' ,`MLSNumber` = '4505362' ,`ListAgentFullName` = 'Pedro Rodriguez' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.534420' ,`Longitude` = '-97.647818' ,`PhotoCount` = '0' ,`PostalCode` = '78665' ,`RoomCount` = '9' ,`ListPrice` = '430000.00' ,`Status` = 'Active' ,`StreetName` = 'Klondike' ,`StreetNumber` = '1004' ,`StreetSuffix` = 'Loop' ,`City` = 'Round Rock' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2093' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Please call for title company.' ,`Acres` = '0.1676' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S7823 - CHANDLER CREEK SEC 19, BLOCK J, LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '125 - Round Rock' ,`SchoolElementary` = 'DOUBLE FILE TRAIL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STONY POINT HIGH SCHOOL' ,`SchoolMiddle` = 'HERNANDEZ MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Chandler Creek Sec 19' ,`TaxAmount` = '9359' ,`TaxRate` = '2.1343' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664449275' WHERE `Matrix_Unique_ID` = '213024885' --> 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','213030863','1664449275','213030863','2022-09-29T04:19:34.220','27971538','Jared English','Congress Realty, Inc.','','','29.566442','-95.711651','25','77469','5','442000.00','Active','Trinity Manor','2223','Lane','Richmond','3','1','5','4482','Single-Family','Inviting home kept in excellent condition. Dual master suites upstairs and down. This house comes partially furnished and is ready for a move in when you are! Downstairs Formal Living & Dining Room, Study w/ large walk-in closet, Great Room, Kitchen & Breakfast Rooms, Master Suite w/ jacuzzi tub, separate shower, dual counters + additional half-bath. Upstairs is where the party starts. You\'ll have your own Theater (film projector, surround sound & receiver come installed w/ house) complete with platform seating; Game Room, Workout Room; 4 bedrooms & 2 bathrooms. 2 of the bedrooms connect with an ensuite bathroom to form the upstairs mother-in-law suite. The backyard is cozy with plenty of shade from 2 oaks, several pear & plumb trees, peach & fig trees, etc.','0.2038','30','Meritage','','Electric Dryer Connections,Washer Connections','','Mud','1','Gaslog Fireplace','1','Fort Bend South/Richmond','Central Gas','1','RIVERPARK WEST SEC 8, BLOCK 1, LOT 23','Subdivision Lot','8877','Appraisal District','','880','0','','3','Gas Oven,Single Oven','0','','','Gas Range','','Composition','33 - Lamar Consolidated','HUTCHISON ELEMENTARY SCHOOL','LAMAR CONSOLIDATED HIGH SCHOOL','WESSENDORF/LAMAR JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front','Appraisal District','2','Contemporary/Modern','Riverpark West Sec 8','9612','2.8748','Public Sewer,Public Water','2007','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','213080731','1664449275','213080731','2022-09-29T05:57:47.150','8483250','Tai Nguyen','Midtown Realty Group','','','29.539871','-95.172403','8','77546','5','300000.00','Active','Bisontine','2534','Street','Friendswood','2','0','4','2168','Single-Family','This is a great single story home with brand new Hardy siding and New Composite Roof. All tile flooring throughout the house. Good size Master Bedroom and Living room. Additional Sun room in back of the house.','0.1446','7','','','','','No Disclosures','1','','1','Friendswood','Central Gas','1','LT 9 BLK 16 HERITAGE PARK SEC 7','Subdivision Lot','6300','Appraisal District','','220','0','','2','','0','','','','','Composition','9 - Clear Creek','LANDOLT ELEMENTARY SCHOOL','CLEAR BROOK HIGH SCHOOL','WESTBROOK INTERMEDIATE SCHOOL','Lockbox Front','Appraisal District','1','Contemporary/Modern','Heritage Park Sec 07','5373','2.166','Water District','1983','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','213088002','1664449275','213088002','2022-09-29T04:01:50.620','790169','Feras Rachid','Opendoor Brokerage, LLC','','','30.131944','-95.283077','35','77365','4','310000.00','Active','Shire Horse','19110','Boulevard','Porter','2','1','4','2325','Single-Family','Built in 2014, this Porter two-story home offers granite countertops, and a two-car garage.','0.1449','40','','','','','Sellers Disclosure','1','','0','Porter/New Caney West','Central Gas','1','S360406 - CUMBERLAND CROSSING 06, BLOCK 1, LOT 23','Subdivision Lot','6312','Appraisal District','','400','0','','2','','0','','','','','Composition','39 - New Caney','ROBERT CRIPPEN ELEMENTARY SCHOOL','PORTER HIGH SCHOOL (NEW CANEY)','WHITE OAK MIDDLE SCHOOL (NEW CANEY)','Appointment Required,No Supra Keybox','Seller','2','Traditional','Cumberland Crossing 06','4997','2.1331','Other Water/Sewer','2014','Seller'); --> 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','213088052','1664449275','213088052','2022-09-29T04:03:22.007','37311231','Feras Rachid','Opendoor Brokerage, LLC','','','30.152303','-95.503424','32','77381','3','420000.00','Active','Meadow Beauty','3','Court','Spring','2','1','3','2186','Single-Family','Welcome home to this professionally remodeled beauty in a great neighborhood. Brand new kitchen featuring granite counters, shaker cabinets, subway tile backsplash and stainless steel appliance package. Bathrooms both feature new showers and vanities with all the modern finishing touches. All of the flooring has been replaced and the neutral paint inside and out is fresh. Great Woodlands location. Hurry and make your offer today as this one will not last.','0.3079','15','','','','','Sellers Disclosure','1','','1','The Woodlands','Central Gas','0','WDLNDS VIL PANTHER CK 07, BLOCK 1, LOT 60','Subdivision Lot','13414','Appraisal District','','','0','','2','','0','','','','','Composition','11 - Conroe','GLEN LOCH ELEMENTARY SCHOOL','THE WOODLANDS HIGH SCHOOL','MCCULLOUGH JUNIOR HIGH SCHOOL','Appointment Required,No Supra Keybox','Seller','2','Traditional','Wdlnds Village Panther Ck 07','4222','2.0869','Water District','1982','Seller'); --> New record created successfully