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-12-06T20:19:00.053' ,`MLSNumber` = '55121274' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Lisa White' ,`SellingOfficeName` = 'GBR Realty' ,`Latitude` = '29.494572' ,`Longitude` = '-95.387824' ,`PhotoCount` = '35' ,`PostalCode` = '77578' ,`RoomCount` = '17' ,`ListPrice` = '639452.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Limestone' ,`StreetNumber` = '4303' ,`StreetSuffix` = 'Terrace' ,`City` = 'Manvel' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3793' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Rowan V, Elevation F) CURRENTLY BEING BUILT. Two story. 5 bedrooms. 4.5 baths. Family room, informal dining room/breakfast area and study. Spacious island kitchen open to family room. Primary suite with large walk-in closet and secondary bedroom on first floor. Three additional bedrooms, spacious game room and media room on second floor. Covered patio and attached 2-car garage. Del Bello Lakes, located in Manvel, TX, will feature Jaxon’s Cove, a modern amenity center equipped with a splash pad, resort-style pool, outdoor pavilion, playground, and spaces for residents to book private events. Del Bello Lakes will also feature over 40 acres of lakes, a five-mile trail system, and 15 acres of parks and open space. Stop by the Westin Homes model home today to find out more about Del Bello Lakes!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 5 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7663' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '920' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'E C MASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'MANVEL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Del Bello Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.8' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675088099' WHERE `Matrix_Unique_ID` = '211626592' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-06T20:25:47.543' ,`MLSNumber` = '22771622' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Wenjie Wang' ,`SellingOfficeName` = 'Sunet Group' ,`Latitude` = '29.905999' ,`Longitude` = '-95.734071' ,`PhotoCount` = '26' ,`PostalCode` = '77433' ,`RoomCount` = '15' ,`ListPrice` = '567524.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Coral View' ,`StreetNumber` = '21103' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction. (Lexington, Elevation A.) CURRENTLY BEING BUILT. Two story. 4 bedrooms. 3.5 baths. Family room, informal dining room, and study. Spacious island kitchen open to Family room. Primary suite with large double walk-in closets. Second bedroom downstairs with private bath. Spacious game room and media room on second floor. Covered patio and 2-car garage. Marvida is a pocket of paradise for adventurous people who want it all, including innovative home designs, premium amenities, and unparalleled value. It\'s stellar location speeds you to Katy, the Energy Corridor and Downtown Houston via the Grand Parkway and Highway 290. Gold-standard Cypress-Fairbanks ISD challenges students to excel. Stop by the Westin Homes model home to learn more about Marvida!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 46 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9188' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'ANDRE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Marvida' ,`TaxAmount` = '' ,`TaxRate` = '3.59' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675088099' WHERE `Matrix_Unique_ID` = '211738889' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-06T20:57:00.940' ,`MLSNumber` = '66091827' ,`ListAgentFullName` = 'Michele Reprogle' ,`ListOfficeName` = 'Designed Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.915022' ,`Longitude` = '-95.436616' ,`PhotoCount` = '25' ,`PostalCode` = '77038' ,`RoomCount` = '9' ,`ListPrice` = '224900.00' ,`Status` = 'Active' ,`StreetName` = 'Crestbrook' ,`StreetNumber` = '943' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1530' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home, to this well-kept one-story 4 BEDROOM 2 1/2 BATH located in Fallbrook. This WELL KEPT Home features open concept living, dining, and kitchen spaces. cFaux wood floors are actually ceramic tile - Large exterior carport and spacious backyard. Home features granite countertops and updated backsplash, kitchen island and expanded living area. Even with 4 bedrooms owners have carved out a small home office/flex space. Both bathrooms have been redone with tile and updated fixtures. This Home is minutes away from Entertainment, Dining, and Shopping.' ,`Acres` = '0.1818' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 12 BLK 1 FALLBROOK SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7920' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'GRAY ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'ALDINE HIGH SCHOOL' ,`SchoolMiddle` = 'STOVALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fallbrook Sec 01' ,`TaxAmount` = '2393' ,`TaxRate` = '2.4008' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675088100' WHERE `Matrix_Unique_ID` = '212402459' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-06T19:08:59.890' ,`MLSNumber` = '8464068' ,`ListAgentFullName` = 'Lorena Martinez' ,`ListOfficeName` = 'J Perez Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.777889' ,`Longitude` = '-95.342785' ,`PhotoCount` = '6' ,`PostalCode` = '77026' ,`RoomCount` = '3' ,`ListPrice` = '107000.00' ,`Status` = 'Active' ,`StreetName` = 'Davis' ,`StreetNumber` = '1808' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1082' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.0482' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'TR 2C BLK 9 PARKER SMITH' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '2100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHERMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'FLEMING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Parker Smith' ,`TaxAmount` = '984' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1944' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675088100' WHERE `Matrix_Unique_ID` = '213206836' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-06T20:10:01.557' ,`MLSNumber` = '17631380' ,`ListAgentFullName` = 'Stanley Cleberg' ,`ListOfficeName` = 'Fowler Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.668392' ,`Longitude` = '-94.379413' ,`PhotoCount` = '45' ,`PostalCode` = '77624' ,`RoomCount` = '11' ,`ListPrice` = '45000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 1013' ,`StreetNumber` = '543' ,`StreetSuffix` = '' ,`City` = 'Hillister' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1156' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Unique older home, a 1930\'s shotgun style with additions turned 3 bedroom and 2 baths will need plenty of love and TLC for 21st century convenience. The property sits on a nice sized lot with asphalt roads on 2 sides. There are screened porches on the front and back to catch those spring and fall breezes a great way to enjoy the country. Only 2 hours from Houston, an hour from Beaumont, and 10 minutes from the county seat of Woodville. Come take a look and make it a modern masterpiece.' ,`Acres` = '0.35' ,`Area` = '48' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tyler County' ,`HeatSystem` = 'Space Heater,Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'A0450 J. B. MOSER,ACRES .35' ,`LotDesciption` = 'Cleared' ,`LotSize` = '15246' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Other' ,`SchoolDistrict` = '253 - Woodville' ,`SchoolElementary` = 'WHEAT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WOODVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'WOODVILLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Rural' ,`TaxAmount` = '688' ,`TaxRate` = '2.0672' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1935' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675088100' WHERE `Matrix_Unique_ID` = '213307962' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-06T19:10:30.990' ,`MLSNumber` = '41035065' ,`ListAgentFullName` = 'Misti Bruton' ,`ListOfficeName` = 'AVO Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.515930' ,`Longitude` = '-98.358241' ,`PhotoCount` = '18' ,`PostalCode` = '78239' ,`RoomCount` = '8' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'David' ,`StreetNumber` = '6551' ,`StreetSuffix` = 'Drive' ,`City` = 'San Antonio' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1569' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Classic ranch style home on large semi cul-de-sac lot has brand new roof and recent foundation repair. You are immediately invited in to the home with vaulted wood beamed ceilings throughout the living, dining and kitchen. Large double fireplace allows for a warm cozy feel in the living room and kitchen area. Plenty of cabinets and counter space to make cooking a delight. You will be showered with morning light in the bedrooms. Primary bath has standup shower and wall of mirrors. Exterior of the home could be a gardeners dream and with no back neighbors privacy is a premium. Schedule your tour today to see all this home has to offer.' ,`Acres` = '0.2674' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'CB 5051F BLK 3 LOT 26' ,`LotDesciption` = 'Other' ,`LotSize` = '11649' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '274 - North East' ,`SchoolElementary` = 'WINDCREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ROOSEVELT HIGH SCHOOL (NORTH EAST)' ,`SchoolMiddle` = 'WHITE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Camelot' ,`TaxAmount` = '3728' ,`TaxRate` = '2.0965' ,`WaterSewer` = 'Other Water/Sewer,Public Sewer' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675088100' WHERE `Matrix_Unique_ID` = '213814984' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-06T20:16:30.593' ,`MLSNumber` = '69348244' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Hillary Chaires' ,`SellingOfficeName` = 'RE/MAX The Woodlands & Spring' ,`Latitude` = '29.906078' ,`Longitude` = '-95.733526' ,`PhotoCount` = '28' ,`PostalCode` = '77433' ,`RoomCount` = '16' ,`ListPrice` = '549971.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Flounder Rosa' ,`StreetNumber` = '8711' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3137' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Albany, Elevation GL) CURRENTLY BEING BUILT. Two story. 4 bedrooms. 3.5 baths. Family room, study and formal dining room. Spacious island kitchen open to family room. Primary suite with large walk-in closet. Three additional bedrooms, spacious game room and media room on second floor. Covered patio and attached 2-car garage. Marvida is a pocket of paradise for adventurous people who want it all, including innovative home designs, premium amenities, and unparalleled value. It\'s stellar location speeds you to Katy, the Energy Corridor and Downtown Houston via the Grand Parkway and Highway 290. Gold-standard Cypress-Fairbanks ISD challenges students to excel. Stop by the Westin Homes model home to learn more about Marvida!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 24 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7755' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'ANDRE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Marvida' ,`TaxAmount` = '' ,`TaxRate` = '3.59' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675088101' WHERE `Matrix_Unique_ID` = '214618529' --> 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','215379250','1675088101','215379250','2022-12-06T19:28:22.227','39625987','Juan Cuevas','JLA Realty','','','29.666305','-95.077335','10','77571','5','190000.00','Active','Glenvalley','5225','Drive','La Porte','2','0','3','1968','Single-Family','INVESTORS!!! Look no further if you are looking for your next fix and flip or buy and hold. There is a lot of built in equity. This home sits on a beautiful, well manicured street in La Porte, Texas. It has great bones and needs a bit of TLC. It is priced to move and the seller is extremely motivated. All REASONABLE offers will be entertained. Don\'t let this amazing deal be the one that got away!','0.188','7','','','','','Sellers Disclosure','','','1','La Porte/Shoreacres','Central Gas','0','LT 2 BLK 4 GLEN MEADOWS SEC 1','Subdivision Lot','8190','Appraisal District','','','0','','2','','0','','','','','Composition','35 - La Porte','LOMAX ELEMENTARY SCHOOL','LA PORTE HIGH SCHOOL','LOMAX JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Ranch','Glen Meadows Sec 01','6555','2.7208','Public Sewer,Public Water','1978','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','215387701','1675088101','215387701','2022-12-06T19:41:22.003','96530760','Toni Hite','Coldwell Banker Realty','','','29.491991','-95.763160','19','77469','6','439000.00','Active','Mourning Dove','5026','Drive','Richmond','2','1','4','2912','Single-Family','LOW TAX AREA! Nice custom built home on more than one acre of land. This unique, functional home features a large open concept living and dining room. The galley style kitchen has ample storage and counter space. There are 2 large bedrooms upstairs with 2 full baths. The primary bedroom has a large walk in closet and the primary bath has separate shower and double vanity. Downstairs you will find an additional 2 bedrooms and a half bath. There is an abundance of storage space throughout the home. Another feature, there are plenty of windows! Downstairs is designed to be converted into a 2 bedroom 1 bath completed unit if needed. There is a 4 car attached carport and a 4 car drive through garage! Also included in this purchase is a fully functioning shop! Schedule a showing soon!','1.151','30','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Fort Bend South/Richmond','Central Gas,Propane','0','DOVE MEADOWS SEC 3, LOT 33 (PT), ACRES 1.151','Cleared,Other','50138','Appraisal District','','','0','','4','Freestanding Oven,Gas Oven,Single Oven','0','','','Freestanding Range,Gas Cooktop','','Composition','33 - Lamar Consolidated','MEYER ELEMENTARY SCHOOL (LAMAR)','RANDLE HIGH SCHOOL','WRIGHT JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','2','Traditional','Dove Meadows Sec 3','3359','1.7948','Aerobic,Well','2005','Appraisal District'); --> New record created successfully