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-01T02:51:48.977' ,`MLSNumber` = '16080755' ,`ListAgentFullName` = 'Mike Livingston' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.700014' ,`Longitude` = '-95.461694' ,`PhotoCount` = '50' ,`PostalCode` = '77401' ,`RoomCount` = '16' ,`ListPrice` = '1599000.00' ,`Status` = 'Active' ,`StreetName` = 'PALM' ,`StreetNumber` = '4800' ,`StreetSuffix` = '' ,`City` = 'Bellaire' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5972' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This elegant French Provincial Bellaire Showcase home by Scott Frasier was designed by Sandra Castellanos. A quiet retreat, it has the premier location at the top of the Palm St. cul-de-sac. A welcoming space for entertaining but also a warm and functional setting for the family. Charming entry gate opens to the quiet interior courtyard with its exterior guest house, distinctive fireplace and vine-covered pergola leading to front door. The towering turret is clad in a striking Flemish bond brick pattern. Finely detailed custom finishes throughout bring this home to life: SEE the attached Floor Plan and Video Tour; complete details in the photo captions. Wine Rooms include 388 bottle-capacity coolers. Media Room and extensive AV equipment inventory (list available). Well-maintained by this original owner. First occupied after its Showcase presentation. Never flooded.' ,`Acres` = '0.1887' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bellaire Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 9 BLK 1 GAWLEY PLACE' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '8220' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Tile' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CONDIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2.5' ,`Style` = 'French' ,`Subdivision` = 'Gawley Place' ,`TaxAmount` = '30808' ,`TaxRate` = '2.2271' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664618660' WHERE `Matrix_Unique_ID` = '209496354' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T03:07:00.850' ,`MLSNumber` = '86605101' ,`ListAgentFullName` = 'Michelle Mitchell' ,`ListOfficeName` = 'Arbor One Realty, PLLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.535275' ,`Longitude` = '-95.012866' ,`PhotoCount` = '49' ,`PostalCode` = '77565' ,`RoomCount` = '10' ,`ListPrice` = '628900.00' ,`Status` = 'Active' ,`StreetName` = 'Kipp' ,`StreetNumber` = '1408' ,`StreetSuffix` = 'Avenue' ,`City` = 'Kemah' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2912' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Prepare to relax in your very own resort style setting with a double lot back yard. It contains a heated salt water pool with waterfall, palapa/bar, and stand alone hot tub. Exterior pool deck, patio area, and sidewalk is custom stamped concrete with beautiful compass rose. It also contains a Koi pond within view from the living room and dining area. Gather around the custom fire pit on cool fall nights. 1408 Kipp is a 4/5 BR, 3 full bath two-story house with ample room to entertain. All bedrooms are upstairs, area for a game room or home office, with a covered balcony. The primary bedroom with en suite has French door with balcony. The house features insulated/low-e hurricane rated windows, 2-High Efficiency HVAC, radiant barrier, 19k Generac generator, commercial grade security camera system hardwired to house, and much more... It is a stones throw to the fun of the Kemah Boardwalk, great dining, community events, parks, golf carts, and Galveston Bay. Call today for a tour!' ,`Acres` = '0.303' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 18 M MULDOON SUR LOT 24A (25-0) HARBOR HOMES SUB REPLAT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BAYSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harbor Homes' ,`TaxAmount` = '8107' ,`TaxRate` = '2.0134' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618660' WHERE `Matrix_Unique_ID` = '211265999' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T03:47:51.160' ,`MLSNumber` = '14587356' ,`ListAgentFullName` = 'Emily Wang' ,`ListOfficeName` = 'Intown Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.769190' ,`Longitude` = '-95.372022' ,`PhotoCount` = '12' ,`PostalCode` = '77007' ,`RoomCount` = '7' ,`ListPrice` = '675000.00' ,`Status` = 'Active' ,`StreetName` = 'Hickory' ,`StreetNumber` = '1207' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2801' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ABSOLUTELY STUNNING SKYLINE VIEWS of DOWNTOWN! in the LOWER HEIGHTS DISTRICT. SPACIOUS 150+ SF ROOFTOP TERRACE home in HOUSTON VIEWS, a FULLY GATED community w/ a DOG PARK!! NEW construction by Houston\'s award winning builder, InTown Homes. 1207B Hickory St. is a one-of-a-kind 4 Story w/ 12 FT living room ceilings, 10 FT sliding tri-panoramic doors, Luxury BOSCH appliances, quartz counters and custom soft close cabinetry. Luxurious Primary Suite, HUGE walk in closet! Free Standing Tub! 4th Floor game room with the covered roof top deck! Quiet street with NO through traffic!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'InTown Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Washington East/Sabine' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 14 BLOCK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '4' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Houston Views' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664618660' WHERE `Matrix_Unique_ID` = '211655523' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T02:04:50.023' ,`MLSNumber` = '82192866' ,`ListAgentFullName` = 'Yuhong Zhi' ,`ListOfficeName` = 'J. Lindsey Properties' ,`SellingAgentFullName` = 'Yvette Maldonado' ,`SellingOfficeName` = 'Keller Williams RealtyNortheast' ,`Latitude` = '30.074684' ,`Longitude` = '-95.172707' ,`PhotoCount` = '25' ,`PostalCode` = '77345' ,`RoomCount` = '7' ,`ListPrice` = '275000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Sandberry' ,`StreetNumber` = '2807' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1964' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful newly update, one story home in the peaceful neighbourhood of Woodspring Forest, office/work space closed, open concept kitchen with new granite island, new paint, new flooring, family room with warm fireplace welcoming all guests. Primary bedroom has walk-in closet and a separate tub and shower, house sits within walking distance to park and pool, rare pearl!' ,`Acres` = '0.132' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 1 WOODSPRING FOREST SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`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' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Woodspring Forest' ,`TaxAmount` = '4875' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1664618660' WHERE `Matrix_Unique_ID` = '211967298' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T03:47:56.417' ,`MLSNumber` = '82067947' ,`ListAgentFullName` = 'Lisa Rigdon' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.752063' ,`Longitude` = '-95.553185' ,`PhotoCount` = '44' ,`PostalCode` = '77042' ,`RoomCount` = '7' ,`ListPrice` = '775000.00' ,`Status` = 'Active' ,`StreetName` = 'Lynbrook Hollow' ,`StreetNumber` = '10119' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3287' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this wonderful 4-bedroom, 3-bath home nestled on a corner lot in Briargrove Park. This lovely home features two primary suites, one upstairs and one downstairs, along with an office/flex space, and a beautiful kitchen showcasing granite countertops and stainless steel appliances. The kitchen is a home chef\'s dream with double ovens and a gas cooktop! There is an abundance of storage space with 11 closets, 7 are walk-in and 1 is a cedar closet! Step out into the spacious backyard with space for a pool and extra parking space for up to 3 cars! Recent updates to the home include new carpet on the second floor, fresh paint throughout the interior of the home, a new downstairs furnace and new sewer lines. Enjoy the wonderful neighborhood amenities such as a community pool and tennis courts as well as a short walk to the Mary Ann Francklow Park. This home is ideally located with convenient access to Beltway 8, I-10 and Westpark Tollway. Schedule a tour today!' ,`Acres` = '0.2153' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Briargrove Park/Walnutbend' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 1 BRIARGROVE PARK SEC 3' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9380' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '685' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WALNUT BEND ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Briargrove Park Sec 3' ,`TaxAmount` = '13822' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618660' WHERE `Matrix_Unique_ID` = '212205603' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T02:49:13.650' ,`MLSNumber` = '50602242' ,`ListAgentFullName` = 'Cynthia Corder' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.280275' ,`Longitude` = '-94.822887' ,`PhotoCount` = '43' ,`PostalCode` = '77551' ,`RoomCount` = '4' ,`ListPrice` = '359000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue Q 1/2' ,`StreetNumber` = '5301' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1162' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2013 Beautifully renovated and fully furnished home is turn-key and ready for your short-term rental investment! Only blocks from the beach and a golf cart ride to The Strand. Updated kitchen including shaker cabinets, new quartz countertops, farm sink, brass hardware, updated lighting & new appliances. The large living room is styled with fine furniture & accessories. New flooring throughout. The bathrooms are spacious with designer tiles and blue beach vibe cabinets. The tile shower in the primary bath is gorgeous! The walk-in closet in the primary is great for an owner\'s closet or storing seasonal items. Bring your pets to enjoy the fenced backyard which is also great for BBQ\'s! You can store all of your beach toys in the large shed which has access from the street. Enjoy the breeze on the expansive front porch. The corner lot has a convenient double-wide driveway for off-street parking. Come take a look at this beautiful home and fall in love!' ,`Acres` = '0.1024' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Midtown - Galveston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR PT OF LOTS 11,12 & 10 (11-0) BLK 146' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '4459' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Denver Resurvey' ,`TaxAmount` = '3990' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618661' WHERE `Matrix_Unique_ID` = '212887396' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T02:22:09.770' ,`MLSNumber` = '35537525' ,`ListAgentFullName` = 'Ashton Ferrari' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.743250' ,`Longitude` = '-95.505061' ,`PhotoCount` = '28' ,`PostalCode` = '77063' ,`RoomCount` = '15' ,`ListPrice` = '1000000.00' ,`Status` = 'Active' ,`StreetName` = 'Stoney Brook' ,`StreetNumber` = '2303' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '4503' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is priced to sell. There will be no further reductions via MLS. Corner lot in Briarbend near The Kinkaid School! 4 BD custom home w/ 2 kitchens, primary suite + in-law suite(w/ private driveway access), 2nd-floor game & 3-4 car garage or can be converted to home gym. Kitchen 1-island facing living room w/ custom built cabinetry, 4 burner electric top, & microwave drawer. Kitchen 2 - Wolf 4 Burners + Infrared Griddle, 2 convection ovens+commercial ventilation system. Living room offers custom built-ins, high ceilings w/ recessed lighting, fireplace & surround sound speakers w/ projector screen. Primary suite-cozy sitting area w/fireplace, built-in nooks, spa bathroom w/ heated controlled floors, separate vanities & designer closet. Home is equipped w/ water softener, vacuum system, surveillance system, skylights & large floored attic space w/ safe room. HOA provides courtesy patrol, trash/recycling & fun neighborhood events. All info per seller.' ,`Acres` = '' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Charnwood/Briarbend' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 7 BRIARBEND' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '10560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '490' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Gas Range,Grill' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Briarbend' ,`TaxAmount` = '27541' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618661' WHERE `Matrix_Unique_ID` = '213025761' --> 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','213182544','1664618661','213182544','2022-10-01T02:00:04.047','80157078','Vicki Rogers','UTR TEXAS, REALTORS','','','30.226506','-95.660157','35','77354','10','475000.00','Active','Stallion','12414','Court','Magnolia','2','0','4','2270','Single-Family','This beautiful home boasts high ceilings, architectual details and loads of windows on a quiet cul-de-sac street - complete with parks, playground and walking trail - welcome home! Updates include brand new interior paint (9/2022), carpet (9/2022), roof (4/2020), HVAC system (8/2018 Goodman 14 seer 5 ton). 18x12 Sunroom overlooks the backyard & pathway that leads down to a secluded picnic area amid your trees. This property is light & bright, wooded & inviting! Central to 1488 new shopping & restaurants in Magnolia ISD.','0.6523','15','','','','','Sellers Disclosure','1','Gaslog Fireplace','1','Magnolia/1488 East','Central Gas','1','S730802 - MOSTYN MANOR 02, BLOCK 2, LOT 18, ACRES 0.65','Cul-De-Sac,Wooded','28416','Appraisal District','','500','0','','3','Double Oven','0','','','Gas Cooktop','','Composition','36 - Magnolia','MAGNOLIA PARKWAY ELEMENTARY SCHOOL','MAGNOLIA HIGH SCHOOL','BEAR BRANCH JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied','Builder','1','Traditional','Mostyn Manor 02','6190','1.8587','Aerobic,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','213183955','1664618661','213183955','2022-10-01T03:34:03.777','90320909','Gregory Sanders','NB Elite Realty','','','30.502749','-95.388391','32','77378','7','395000.00','Active','Oak Springs','11510','Drive','Willis','2','0','3','1614','Single-Family','Immaculate, easy to maintain one story home is move-in ready!!! No flooding. Fabulous one-story 3 bedroom home is too marvelous to miss!!! Original owner is selling this beautiful custom built Gentry Classic home on a huge 3.396 wooded acre lot located on a quiet cul-de-sac road. Home features three spacious bedrooms in a split floor plan. Each feature luxurious custom closet systems for maximum organization! Large kitchen featuring granite tile countertops and stainless steel appliances opens up to the living room with built in fireplace. Large front and back covered porch for enjoying the outdoors. Fresh paint inside and out and NEW roof 8/2022! Has an oversized garage with a covered back porch and no rear neighbors but your own acreage! See aerial view for lot layout. Home Warranty offered. Refrigerator is included.','3.396','19','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Willis Area','Central Electric','0','S765100 - OAK SPRINGS, BLOCK 1, LOT 5, 6, ACRES 3.396','Wooded','147930','Appraisal District','','','0','','2','Electric Oven,Freestanding Oven,Single Oven','0','','','Electric Range','','Composition','56 - Willis','PARMLEY ELEMENTARY SCHOOL','WILLIS HIGH SCHOOL','LYNN LUCAS MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Back,Supra Keybox,Vacant/Unoccupied','Builder','1','Ranch','Oak Spgs','5123','1.8448','Public Water','2009','Appraisal District'); --> New record created successfully