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-30T04:48:58.210' ,`MLSNumber` = '97140292' ,`ListAgentFullName` = 'Alejandro Soules-Lara' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.145080' ,`Longitude` = '-95.491910' ,`PhotoCount` = '40' ,`PostalCode` = '77380' ,`RoomCount` = '10' ,`ListPrice` = '390000.00' ,`Status` = 'Active' ,`StreetName` = 'Kentwood' ,`StreetNumber` = '3323' ,`StreetSuffix` = 'Drive' ,`City` = 'The Woodlands' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2440' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEWLY AND COMPLETELY RENOVATED, READY TO MOVE-IN SPACIOUS HOME located on a corner lot with 2 driveways in a comfortable neighborhood in The Woodlands minutes away from The Woodlands Mall, Market St, and the Mitchell Nature Preserve where your family will enjoy miles of hiking and biking. Situated in the renowned Conroe ISD with “A” rated schools like Glen Loch Elementary. Amenities include a pool area with playground. The entire interior and exterior are newly painted with a new roof, gutters, sprinkler system and HVAC system. The 1st floor offers a large master bedroom with adjoining bath, two extra bedrooms, a dining room, breakfast room with bay window, and a large living room. The new section offers a huge tiled game room with high ceilings and gas connections for a new kitchen, a 2nd master bedroom with adjoining bathroom and bay window, a study/ office with 1/2 bath and balcony with French doors. Perfect for a mother-in-law’s apartment. Appliances included. Never flooded!' ,`Acres` = '0.2135' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TIMBER RIDGE 03, LOT 26' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '70' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GLEN LOCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Timber Ridge 03' ,`TaxAmount` = '4685' ,`TaxRate` = '2.5954' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1664542759' WHERE `Matrix_Unique_ID` = '209840329' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T05:38:55.963' ,`MLSNumber` = '75536290' ,`ListAgentFullName` = 'LaKitsha Lagunes' ,`ListOfficeName` = 'Home Alliance Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.926921' ,`Longitude` = '-95.075421' ,`PhotoCount` = '35' ,`PostalCode` = '77532' ,`RoomCount` = '6' ,`ListPrice` = '209999.00' ,`Status` = 'Active' ,`StreetName` = 'Lighthouse' ,`StreetNumber` = '16819' ,`StreetSuffix` = 'Drive' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2164' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 story home on a spacious 10746 square foot lot! Features a large back yard and nice driveway. Home may need some TLC. Interior features include an open kitchen and living room with the master bedroom downstairs and an expansive game-room upstairs! The Newport subdivision includes a pool, golf course, tennis courts, river access, walking trails, and a water splash park.' ,`Acres` = '0.2462' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 6 NEWPORT SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10726' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '660' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'NEWPORT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Newport Sec 03' ,`TaxAmount` = '5507' ,`TaxRate` = '2.7105' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664542759' WHERE `Matrix_Unique_ID` = '210309371' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T05:29:52.907' ,`MLSNumber` = '60580263' ,`ListAgentFullName` = 'Valerie Bertolini' ,`ListOfficeName` = 'Texas Living Company' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.851286' ,`Longitude` = '-95.420480' ,`PhotoCount` = '35' ,`PostalCode` = '77091' ,`RoomCount` = '7' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Mansfield' ,`StreetNumber` = '849' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1504' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful, *NEW* 2-story home located in the thriving Highland Heights, with excellent features! The home is under construction but at its final stages. This home includes 3 bedrooms and 2.5 bathrooms. The first-floor living area offers an open floor plan which features a stunning kitchen with an island, beautiful quartz countertops as well as soft closing cabinets and drawers, a pantry, stainless steel appliances, a dining area, a living room, and ceiling fans. Modern tile selection in the full bathrooms. The spacious primary bedroom is located on the second floor and includes an en suite bathroom, with free standing tub and separate shower, along with double sink vanity. The primary bedroom also offers a spacious walk-in closet. Utility room upstairs near all bedrooms. A charming gated community of 12 units in a terrific location with convenient access to I-10 and 45. It won\'t be long for move-in ready!' ,`Acres` = '0.0383' ,`Area` = '9' ,`BuilderName` = 'Elysium Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 1 CHEATEUS ON MANSFIELD STREET' ,`LotDesciption` = 'Other' ,`LotSize` = '1667' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HIGHLAND HEIGHTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Highland Heights Annex' ,`TaxAmount` = '1124' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664542759' WHERE `Matrix_Unique_ID` = '210688143' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T05:27:55.347' ,`MLSNumber` = '54902860' ,`ListAgentFullName` = 'Valerie Bertolini' ,`ListOfficeName` = 'Texas Living Company' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.851286' ,`Longitude` = '-95.420480' ,`PhotoCount` = '35' ,`PostalCode` = '77091' ,`RoomCount` = '7' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Mansfield' ,`StreetNumber` = '849' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1504' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful, *NEW* 2-story home located in the thriving Highland Heights, with excellent features! The home is under construction but at its final stages. This home includes 3 bedrooms and 2.5 bathrooms. The first-floor living area offers an open floor plan which features a stunning kitchen with an island, beautiful quartz countertops as well as soft closing cabinets and drawers, a pantry, stainless steel appliances, a dining area, a living room, and ceiling fans. Modern tile selection in the full bathrooms. The spacious primary bedroom is located on the second floor and includes an en suite bathroom, with free standing tub and separate shower, along with double sink vanity. The primary bedroom also offers a spacious walk-in closet. Utility room upstairs near all bedrooms. A charming gated community of 12 units in a terrific location with convenient access to I-10 and 45. It won\'t be long for move-in ready!' ,`Acres` = '0.0383' ,`Area` = '9' ,`BuilderName` = 'Elysium Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 1 CHEATEUS ON MANSFIELD STREET' ,`LotDesciption` = 'Other' ,`LotSize` = '1667' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HIGHLAND HEIGHTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Highland Heights Annex' ,`TaxAmount` = '1124' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664542759' WHERE `Matrix_Unique_ID` = '210719280' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T04:11:34.767' ,`MLSNumber` = '21316908' ,`ListAgentFullName` = 'Valerie Bertolini' ,`ListOfficeName` = 'Texas Living Company' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.851286' ,`Longitude` = '-95.420480' ,`PhotoCount` = '35' ,`PostalCode` = '77091' ,`RoomCount` = '7' ,`ListPrice` = '339900.00' ,`Status` = 'Active' ,`StreetName` = 'Mansfield' ,`StreetNumber` = '849' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1504' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful, *NEW* 2-story home located in the thriving Highland Heights, with excellent features! The home is under construction but at its final stages. This home includes 3 bedrooms and 2.5 bathrooms. The first-floor living area offers an open floor plan which features a stunning kitchen with an island, beautiful quartz countertops as well as soft closing cabinets and drawers, a pantry, stainless steel appliances, a dining area, a living room, and ceiling fans. Modern tile selection in the full bathrooms. The spacious primary bedroom is located on the second floor and includes an en suite bathroom, with free standing tub and separate shower, along with double sink vanity. The primary bedroom also offers a spacious walk-in closet. Utility room upstairs near all bedrooms. A charming gated community of 12 units in a terrific location with convenient access to I-10 and 45. It won\'t be long for move-in ready!' ,`Acres` = '0.0383' ,`Area` = '9' ,`BuilderName` = 'Elysium Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 1 CHEATEUS ON MANSFIELD STREET' ,`LotDesciption` = 'Other' ,`LotSize` = '1667' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HIGHLAND HEIGHTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Highland Heights Annex' ,`TaxAmount` = '1124' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664542760' WHERE `Matrix_Unique_ID` = '210719964' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T04:31:07.170' ,`MLSNumber` = '22845367' ,`ListAgentFullName` = 'Valerie Bertolini' ,`ListOfficeName` = 'Texas Living Company' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.851286' ,`Longitude` = '-95.420480' ,`PhotoCount` = '35' ,`PostalCode` = '77091' ,`RoomCount` = '7' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Mansfield' ,`StreetNumber` = '849' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1504' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful, *NEW* 2-story home located in the thriving Highland Heights, with excellent features! The home is under construction but at its final stages. This home includes 3 bedrooms and 2.5 bathrooms. The first-floor living area offers an open floor plan which features a stunning kitchen with an island, beautiful quartz countertops as well as soft closing cabinets and drawers, a pantry, stainless steel appliances, a dining area, a living room, and ceiling fans. Modern tile selection in the full bathrooms. The spacious primary bedroom is located on the second floor and includes an en suite bathroom, with free standing tub and separate shower, along with double sink vanity. The primary bedroom also offers a spacious walk-in closet. Utility room upstairs near all bedrooms. A charming gated community of 12 units in a terrific location with convenient access to I-10 and 45. It won\'t be long for move-in ready!' ,`Acres` = '0.0383' ,`Area` = '9' ,`BuilderName` = 'Elysium Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 1 CHEATEUS ON MANSFIELD STREET' ,`LotDesciption` = 'Other' ,`LotSize` = '1667' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HIGHLAND HEIGHTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Highland Heights Annex' ,`TaxAmount` = '1124' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664542760' WHERE `Matrix_Unique_ID` = '210720714' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T05:41:15.453' ,`MLSNumber` = '78321152' ,`ListAgentFullName` = 'Valerie Bertolini' ,`ListOfficeName` = 'Texas Living Company' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.851286' ,`Longitude` = '-95.420480' ,`PhotoCount` = '36' ,`PostalCode` = '77091' ,`RoomCount` = '7' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Mansfield' ,`StreetNumber` = '849' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1504' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful, *NEW* 2-story home located in the thriving Highland Heights, with excellent features! The home is under construction but at its final stages. This home includes 3 bedrooms and 2.5 bathrooms. The first-floor living area offers an open floor plan which features a stunning kitchen with an island, beautiful quartz countertops as well as soft closing cabinets and drawers, a pantry, stainless steel appliances, a dining area, a living room, and ceiling fans. Modern tile selection in the full bathrooms. The spacious primary bedroom is located on the second floor and includes an en suite bathroom, with free standing tub and separate shower, along with double sink vanity. The primary bedroom also offers a spacious walk-in closet. Utility room upstairs near all bedrooms. A charming gated community of 12 units in a terrific location with convenient access to I-10 and 45. It won\'t be long for move-in ready!' ,`Acres` = '0.0383' ,`Area` = '9' ,`BuilderName` = 'Elysium Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 1 CHEATEUS ON MANSFIELD STREET' ,`LotDesciption` = 'Corner' ,`LotSize` = '1667' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HIGHLAND HEIGHTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Highland Heights Annex' ,`TaxAmount` = '1124' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664542760' WHERE `Matrix_Unique_ID` = '210721169' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T05:43:37.967' ,`MLSNumber` = '37113875' ,`ListAgentFullName` = 'Valerie Bertolini' ,`ListOfficeName` = 'Texas Living Company' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.851285' ,`Longitude` = '-95.420672' ,`PhotoCount` = '36' ,`PostalCode` = '77091' ,`RoomCount` = '7' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Mansfield' ,`StreetNumber` = '853' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1504' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful, *NEW* 2-story home located in the thriving Highland Heights, with excellent features! The home is under construction but at its final stages. This home includes 3 bedrooms and 2.5 bathrooms. The first-floor living area offers an open floor plan which features a stunning kitchen with an island, beautiful quartz countertops as well as soft closing cabinets and drawers, a pantry, stainless steel appliances, a dining area, a living room, and ceiling fans. Modern tile selection in the full bathrooms. The spacious primary bedroom is located on the second floor and includes an en suite bathroom, with free standing tub and separate shower, along with double sink vanity. The primary bedroom also offers a spacious walk-in closet. Utility room upstairs near all bedrooms. A charming gated community of 12 units in a terrific location with convenient access to I-10 and 45. It won\'t be long for move-in ready!' ,`Acres` = '0.0383' ,`Area` = '9' ,`BuilderName` = 'Elysium Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 1 CHEATEUS ON MANSFIELD STREET' ,`LotDesciption` = 'Other' ,`LotSize` = '1668' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HIGHLAND HEIGHTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Highland Heights Annex' ,`TaxAmount` = '1124' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664542760' WHERE `Matrix_Unique_ID` = '210722873' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T05:01:43.897' ,`MLSNumber` = '29283209' ,`ListAgentFullName` = 'Patrick Lee' ,`ListOfficeName` = 'Dreams Come True Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.994456' ,`Longitude` = '-95.505690' ,`PhotoCount` = '34' ,`PostalCode` = '77069' ,`RoomCount` = '7' ,`ListPrice` = '305000.00' ,`Status` = 'Active' ,`StreetName` = 'Chasing Bend' ,`StreetNumber` = '14526' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2051' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2 story home with open concept floor plan. Family room, breakfast, and gameroom w/ laminate floors. Kitchen w/ stainless stainless steel appliances including gas stove. 1 Bedroom down with full bath good for guests or in law suite. Upstairs w/ game room and 3 additional bedrooms. Primary bedroom w/ en suite bath, dual sinks, separate glass shower and tub. Good size yard. Front and back sprinklers. Refrigerator, smart door bell, security system and camera stay.. Nearby restaurants and grocery.' ,`Acres` = '0' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 2 RETREAT AT CHAMPIONS LANDING SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4485' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MITTELSTADT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Retreat/Champions Lndg Sec 3' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664542760' WHERE `Matrix_Unique_ID` = '212347883' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T05:52:00.560' ,`MLSNumber` = '90195533' ,`ListAgentFullName` = 'Jennifer Francois' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.671170' ,`Longitude` = '-95.726802' ,`PhotoCount` = '48' ,`PostalCode` = '77407' ,`RoomCount` = '11' ,`ListPrice` = '410000.00' ,`Status` = 'Active' ,`StreetName` = 'Persimmon' ,`StreetNumber` = '5426' ,`StreetSuffix` = 'Pass' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3160' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome HOME! Step inside and fall in love with this 5 bedroom, 3 FULL bathroom house in Waterview Estates. This home features updates including gleaming bright hardwood flooring and marble-look tile, fresh plush carpet, designer paint, upgraded cabinets, chic tile backsplash, Granite countertops, high-end light fixtures, & recessed lighting. This home is in immaculate shape and has been well taken care of! Large upstairs game room, formal dining & flex room, PERFECT for entertaining! The chef’s kitchen is spacious and features a breakfast nook, sprawling counter space, an island & a luxe gas range. The living room is the heart of the home with a stylish gas log fireplace, the room\'s focal point. Natural light flows into every room with large bright windows throughout. The large fenced backyard features mature shade trees and a lush, spacious lawn that can easily accommodate a pool, playscape, or extended patio! Ideal location with easy access to Westpark & 99. Zoned to Fortbend ISD.' ,`Acres` = '0.1576' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WATERVIEW ESTATES SEC 3, BLOCK 5, LOT 7' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '6867' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '615' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'NEILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'BOWIE MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Waterview Estates' ,`TaxAmount` = '7223' ,`TaxRate` = '2.8929' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664542760' WHERE `Matrix_Unique_ID` = '212698539' --> 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','212813144','1664542761','212813144','2022-09-30T04:30:18.890','52659540','Emily Dieckmann','Keller Williams Realty C. P.','','','30.478503','-97.986131','40','78645','3','360000.00','Active','Stampede','21401','Trail','Lago Vista','2','0','3','1170','Single-Family','All brick home with solid foundation on a corner lot with VIEWS!! Look at the beautiful Hill Country hilltops from almost every room. The back deck can be expanded onto. This home is ready for its new family. Highly desirable location in Lago Vista. A+ rated schools: LVISD has established itself as one of the state’s top-ranking school systems, living up in every way to its “Excellence in all we do” motto. Enjoy Lago Vista’s winery, area golf courses, marinas, and performing arts, or take a 40-minute drive to downtown Austin or a 30-minute drive to The Domain to employment centers and entertainment offerings. For a minimal $11/month fee, you become members in the Lago Vista Property Owners Association with exclusive access to 9 private waterfront parks, basketball court, boat ramps, campground, disc golf course, fishing well, fitness center, hiking trail, marinas, parks, pavilions, pool, athletic field, tennis courts, pickleball courts, playgrounds and more!\r\nAgent','0.2458','83','','','','','Sellers Disclosure','','','','','Central Electric','1','LOT 8187 BAR-K RANCHES PLAT 8','In Golf Course Community','10707','Appraisal District','','150','0','','2','','0','','','','','Composition','114 - Lago Vista','LAGO VISTA ELEMENTARY SCHOOL','LAGO VISTA HIGH SCHOOL','','Appointment Required','Appraisal District','1','Ranch,Traditional','Bar-K Ranches 08','8436','2.4782','Public Sewer,Public Water','2003','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T05:57:05.123' ,`MLSNumber` = '48240550' ,`ListAgentFullName` = 'Lindsey Crockom' ,`ListOfficeName` = 'Yellow Keys Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.306985' ,`Longitude` = '-94.779153' ,`PhotoCount` = '37' ,`PostalCode` = '77550' ,`RoomCount` = '2' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = '11th' ,`StreetNumber` = '612' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1110' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home on sunny Galveston Island with easy access to UTMB (Less than 1/2 a mile), minutes to the beach and The Historic Strand. Just up the stairs you will find 2 bedrooms and 1 full bathroom loaded with investment property potential. Downstairs you will find the garage space and endless possibilities to finish out for more livable space. Great yard, perfect for relaxing or entertaining. This would make a great long term rental, vacation home, fix and flip or first home. Schedule a showing and make it yours today!' ,`Acres` = '0.0604' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR S 49 FT OF LOTS 1 & 2 (1-2) BLK 370' ,`LotDesciption` = 'Other' ,`LotSize` = '2632' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Galveston Townsite' ,`TaxAmount` = '4274' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664542761' WHERE `Matrix_Unique_ID` = '212988656' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T04:16:50.757' ,`MLSNumber` = '46360616' ,`ListAgentFullName` = 'Gretchen Barrilleaux' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.668591' ,`Longitude` = '-95.684791' ,`PhotoCount` = '38' ,`PostalCode` = '77407' ,`RoomCount` = '9' ,`ListPrice` = '430000.00' ,`Status` = 'Active' ,`StreetName` = 'Audrey Arbor Way' ,`StreetNumber` = '17147' ,`StreetSuffix` = '' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2781' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this FANTASTIC, well-maintained 4 bedroom/3.5 bath home with study and game room! A cozy front porch greets you home as soaring ceilings and great natural light sweeps you in! Upgraded brick and stone exterior. The family room boasts a wall of windows and is open to the island kitchen which features gas cooking, walk-in pantry, SS appliances, 42\" cabinets and more! Home is neutral throughout and has great storage! Relax in the private owner\'s retreat with dual sinks, soaking tub, separate shower and spacious walk-in closet. All bathrooms have granite! Nice secondary bedrooms! Mud space! Enjoy the private backyard with extended covered patio. Sprinkler system! Nice neighborhood amenities! Close to lots of shopping and restaurants!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Camellia Section 1, Block 1, Lot 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6338' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HOLLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'HODGES BEND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Camellia' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664542761' WHERE `Matrix_Unique_ID` = '213020206' --> 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','213046285','1664542761','213046285','2022-09-30T05:00:50.873','11573510','Virginia Ledwell','Led Well Realty','','','29.542958','-95.562979','42','77479','12','599900.00','Active','Bending Crest','5602','Court','Sugar Land','3','1','4','3360','Single-Family','Welcome home to 5602 Bending Crest. This 3,360 square foot beauty built in 2019 sits on a large, corner lot in a master planned community. With 4 beds, 3.5 baths, 3 car garage and loads of beautiful updates, this move-in ready home fits the needs of the most discerning of buyers. The first floor features: a dedicated office behind glass French doors; designer fixtures and features in the formal dining, kitchen and living room; a chef’s kitchen with island seating and quartz countertops, SS appliances, and breakfast nook; 2 story living room; ensuite primary w cathedral ceiling, 2 closets, quartz counters, garden tub, and standalone shower. The 2nd floor offers: a large flex space; media room; 3 large secondary rooms with walk-in closets; and 2 secondary full baths with quartz countertops and tub/shower combos. Entertaining is easy with a large covered veranda and loads of green space in the backyard. Come and check this beauty out today!','0.1545','29','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Seller may be subject to foreign tax and Buyer withholding per IRS,Sellers Disclosure','1','Gaslog Fireplace','1','Sugar Land South','Central Gas','1','CREEKSTONE VILLAGE AT RIVERSTONE SEC 9, BLOCK 3, LOT 15','Corner,Cul-De-Sac,Subdivision Lot','6729','Appraisal District','','1110','0','','3','Electric Oven','0','','','Gas Cooktop','','Composition','19 - Fort Bend','BUCHAR ELEMENTARY SCHOOL','ELKINS HIGH SCHOOL','FIRST COLONY MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Creekstone Village At Riverstone Sec 9','11032','2.6729','Public Sewer,Public Water','2019','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','213051677','1664542761','213051677','2022-09-30T05:01:19.437','39468045','Veronica Gonzalez','Nextgen Real Estate Properties','','','29.972690','-95.579612','34','77070','8','337900.00','Active','Creektree','10610','Drive','Houston','2','1','3','2200','Single-Family','Beautiful 2 story home with 3 bed/2.5 baths located in the Norchester subdivision. This home has a spacious kitchen with eye catching granite countertops, 42inch cabinets that give you a lot of storage, and stainless steel appliances. Recently updated A/C system and repiped. Not only do you have a good amount of space indoors but you have a large back yard too, perfect for outdoor activities. The garage also offers more storage with its cabinetry. This is a home you must see! Book your showing today!','0.2755','10','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections,Wood Burning Fireplace','1','Cypress North','Central Electric','1','LT 39 BLK 3 NORCHESTER SEC 1','Cul-De-Sac,Subdivision Lot','12000','Appraisal District','','675','0','','2','Electric Oven','0','','','Electric Range','','Composition','13 - Cypress-Fairbanks','MATZKE ELEMENTARY SCHOOL','CYPRESS CREEK HIGH SCHOOL','BLEYL MIDDLE SCHOOL','Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Norchester Sec 01','5546','2.4817','Water District','1970','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','213146629','1664542761','213146629','2022-09-30T05:44:05.060','97761775','Fernando Sierra','Century 21 Top Realty','','','29.768380','-95.726648','36','77450','7','345000.00','Active','Prince Creek','20419','Drive','Katy','2','1','4','2016','Single-Family','Located in the highly desired Nottigham country this gorgeous 4 Bedroom 2.5 bathroom home is waiting for a new family. Traditional style house has a great open layout with tall ceilings and numerous windows with plenty of natural light. Its perfect for entertaining your friends and family. Spacious laundry room. Master bedroom with direct access to the back yard just perfect to enjoy nature with a nice cup of coffee. This is one of those places that will give you the joy of calling it your home. Will not last! call for a showing today.','0.1716','36','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud','1','','1','Katy - Southeast','Central Gas','1','LT 2 BLK 10 NOTTINGHAM COUNTRY SEC 4','Subdivision Lot','7475','Appraisal District','','300','0','','2','Electric Oven,Single Oven','0','','','Electric Cooktop','','Composition','30 - Katy','NOTTINGHAM COUNTRY ELEMENTARY SCHOOL','TAYLOR HIGH SCHOOL (KATY)','MEMORIAL PARKWAY JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','2','Colonial','Nottingham Country Sec 04','5461','2.3693','Public Sewer,Public Water,Water District','1980','Appraisal District'); --> New record created successfully