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` = '2023-01-16T19:21:09.113' ,`MLSNumber` = '22506333' ,`ListAgentFullName` = 'Julianna Lind' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.786708' ,`Longitude` = '-95.399569' ,`PhotoCount` = '33' ,`PostalCode` = '77007' ,`RoomCount` = '9' ,`ListPrice` = '799000.00' ,`Status` = 'Active' ,`StreetName` = 'W 9th' ,`StreetNumber` = '216' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2267' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UPDATED Craftsman style home nestled in the Heights. Newly renovated! This 3 bedroom, 2 full baths, 1 half bath plus 2 living areas, dining room and office is on a 6,600 sq.ft. lot. Wet bar in family room. Island Kitchen complete with stainless steel appliances, stylish tile countertops and gas cooktop. Primary bedroom has 1 walk-in closet plus 2 more closets. The completely renovated primary bath features a soaking tub, oversize shower with frameless glass enclosure, designer finishes including wall tile and Limestone basket weave tile. Secondary bedrooms share a renovated bathroom with designer finishes. Charming covered front porch and wood deck off the kitchen are perfect for sitting outdoors. Nice green space in the backyard. Property is fully fenced including a double iron gate entrance and an automatic driveway gate leading to the two car detached garage.' ,`Acres` = '0.1515' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 23A & 24A BLK 245 HOUSTON HEIGHTS' ,`LotDesciption` = 'Other' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HARVARD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Houston Heights' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675187644' WHERE `Matrix_Unique_ID` = '211865887' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-16T20:57:07.423' ,`MLSNumber` = '93464293' ,`ListAgentFullName` = 'Vicki Emerson' ,`ListOfficeName` = 'Hunter Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.606453' ,`Longitude` = '-95.440899' ,`PhotoCount` = '41' ,`PostalCode` = '77053' ,`RoomCount` = '10' ,`ListPrice` = '799500.00' ,`Status` = 'Active' ,`StreetName` = 'Anderson' ,`StreetNumber` = '4122-4130' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This exclusive retreat is an incomparable property nestled within Century Old trees situated on 2.6 fully fenced acres. The secluded homestead has been in the same family for over 100 years. Horses Are Allowed. The property can be Self Sustaining with its own Water well, Septic System and Propane Tanks. Iron Fence with Automatic Entry Gates. There are two homes on the property. The Back Property has a 2 B/R 2 Bath (3062 Sq Ft) House with an Automatic Back up Generator. The Front Property includes a 3 B/R 2 Bath (1618 Sq Ft) One Story home. There are Three Separate Covered parking areas including one for an RV, a Greenhouse & Aerated Pond. Green Space borders the Back Property Line. Property has NEVER FLOODED. Selling AS IS. Endless possibilities to live in Current Homes, Remodel or Build New Construction. Country Living close to the City. 1/2 mile to Beltway 8, 3 miles to HWY 288, 15 - 20 minutes to the Medical Center & Downtown.' ,`Acres` = '2.6' ,`Area` = '18' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas,Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'TR 15A GARDEN PLACE TO ALMEDA' ,`LotDesciption` = 'Wooded' ,`LotSize` = '113020' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style,Ranch' ,`Subdivision` = 'Garden Place' ,`TaxAmount` = '1828' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675187644' WHERE `Matrix_Unique_ID` = '213463045' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-16T19:26:48.763' ,`MLSNumber` = '30897958' ,`ListAgentFullName` = 'Lesia Rounsavall' ,`ListOfficeName` = 'Lone Star, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.495121' ,`Longitude` = '-95.482947' ,`PhotoCount` = '43' ,`PostalCode` = '75844' ,`RoomCount` = '11' ,`ListPrice` = '249996.00' ,`Status` = 'Active' ,`StreetName` = 'Selkirk' ,`StreetNumber` = '416' ,`StreetSuffix` = 'Street' ,`City` = 'Grapeland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2155' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Entertainer\'s Dream, provides all the space you need to host amazing get togethers & Celebrations. This home offers an open concept with a split floor plan. You will love family/dinning room combo complete with breakfast bar, and double french doors leading out to the covered patio, that overlooks the pool area. Kitchen has a gas cooktop and double ovens for all the holiday baking. Backyard is fenced, and has a nice pool house, with a full bath and kitchen-serving area. Shoot some hoops on the basket ball court and then cool of in the the pool. RV awning with concrete floor and electricity. Retractable screened in carport. Bring the whole family home for the Holidays and make memories here that will last a life time. Welcome Home.' ,`Acres` = '0.367' ,`Area` = '41' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Grapeland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'SELKIRK ADDN LOTS 5-6 BLK 3' ,`LotDesciption` = 'Cleared' ,`LotSize` = '15987' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground,Vinyl Lined' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '58 - Grapeland' ,`SchoolElementary` = 'GRAPELAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAPELAND HIGH SCHOOL' ,`SchoolMiddle` = 'GRAPELAND JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Selkirk Add' ,`TaxAmount` = '3729' ,`TaxRate` = '2.1104' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675187644' WHERE `Matrix_Unique_ID` = '213672464' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-16T19:30:38.920' ,`MLSNumber` = '91429682' ,`ListAgentFullName` = 'Gladys Lopez' ,`ListOfficeName` = 'Can-2 Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.806632' ,`Longitude` = '-95.139941' ,`PhotoCount` = '23' ,`PostalCode` = '77049' ,`RoomCount` = '9' ,`ListPrice` = '279900.00' ,`Status` = 'Active' ,`StreetName` = 'Eola Creek' ,`StreetNumber` = '16350' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2729' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME HOME! 4bedroom possible 5 bedroom. Specious 2 story home is located on a large lot in an stablished neighborhood of Sonoma Ranch. All bedrooms are located on second-level. Beltway 8 close to I-10, Conveniently located near shopping and schools. Schedule your private showing today.' ,`Acres` = '0.2198' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 23 BLK 2 SONOMA RANCH SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9576' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '8 - Channelview' ,`SchoolElementary` = 'Brown Elementary School (Channelview)' ,`SchoolHigh` = 'CHANNELVIEW HIGH SCHOOL' ,`SchoolMiddle` = 'AGUIRRE JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sonoma Ranch Sec 02' ,`TaxAmount` = '5933' ,`TaxRate` = '2.518' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675187645' WHERE `Matrix_Unique_ID` = '214019315' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-16T20:41:20.830' ,`MLSNumber` = '3788491' ,`ListAgentFullName` = 'Michael Pulaski' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.779724' ,`Longitude` = '-95.316457' ,`PhotoCount` = '6' ,`PostalCode` = '77020' ,`RoomCount` = '6' ,`ListPrice` = '369000.00' ,`Status` = 'Active' ,`StreetName` = 'Harlem' ,`StreetNumber` = '2010' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1745' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2 story new construction in up and coming 5th Ward area just 1 block from serene park overlooking majestic treetops. Located minutes from Downtown and ease of access to freeways this modern home was designed for ease of living and open space. Open floorplan downstairs with bedrooms up. This Historic district has new connstruction and development.' ,`Acres` = '0.0574' ,`Area` = '2' ,`BuilderName` = 'Moderno' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 MODERNO ENGLEWOOD PLACE' ,`LotDesciption` = 'Other' ,`LotSize` = '2500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ATHERTON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Harlem Estates' ,`TaxAmount` = '583' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675187645' WHERE `Matrix_Unique_ID` = '214181077' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-16T20:54:54.407' ,`MLSNumber` = '74679288' ,`ListAgentFullName` = 'Emily Pickens' ,`ListOfficeName` = 'Keller Williams Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.450586' ,`Longitude` = '-96.056584' ,`PhotoCount` = '46' ,`PostalCode` = '75831' ,`RoomCount` = '8' ,`ListPrice` = '215000.00' ,`Status` = 'Active' ,`StreetName` = 'Bridget' ,`StreetNumber` = '348' ,`StreetSuffix` = 'Avenue' ,`City` = 'Buffalo' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1064' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Buffalo, Tx - located halfway between Houston and Dallas - 3 bed/2 bath w/ bonus building. Two separate lots total to 3.55 acres. Great investment property in a quiet location just minutes from both Buffalo and Centerville. The interior has been thoroughly cleaned and has been repainted. The large covered front porch is great for relaxing or entertaining. A large add on adjacent to the front porch is perfect for storage, while the bonus building with a full kitchen has endless possibilities. The cleared upper lot is the perfect site for a forever home.' ,`Acres` = '3.55' ,`Area` = '63' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Buffalo Area' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'JENNIFER LAND CO TRACT 28 and 29 3.55 AC AB 999 ROB' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '194 - Buffalo' ,`SchoolElementary` = 'BUFFALO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BUFFALO HIGH SCHOOL' ,`SchoolMiddle` = 'BUFFALO JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jennifer Land Co' ,`TaxAmount` = '1790' ,`TaxRate` = '2.0777' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675187645' WHERE `Matrix_Unique_ID` = '214901378' --> 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','215517078','1675187645','215517078','2023-01-16T19:16:05.110','10069520','Bevan Walker','Allsource Properties','','','29.695003','-95.359864','23','77021','3','230000.00','Active','Daphne','3923','Street','Houston','2','0','3','1542','Single-Family','Newly updated home, garage conversion 3rd bedroom. Bonus storage room in the back of the house, currently used as a hair studio. Two full bathrooms, lots of closet space. Totally remodeled, living room area, bathrooms, flooring paint. Desired location minutes from the Medical Center & Downtown.','0.1412','4','','','','','Sellers Disclosure','','','0','University Area','Central Gas','0','LT 18 BLK 10 SCOTT TERRACE SEC 3','Subdivision Lot','6150','Appraisal District','','','0','','0','Electric Oven','0','','','Electric Cooktop,Electric Range','','Composition','27 - Houston','FOSTER ELEMENTARY SCHOOL (HOUSTON)','YATES HIGH SCHOOL','CULLEN MIDDLE SCHOOL (HOUSTON)','Appointment Required,No Supra Keybox','Appraisal District','1','Traditional','Scott Terrace Sec 03','1926','2.3307','Public Water','1960','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','215517241','1675187645','215517241','2023-01-16T20:14:20.003','46188282','Kelly Wang','KingFay Inc','','','29.602224','-95.671470','32','77479','7','435000.00','Active','pendelton place dr','5923','','Sugar Land','3','3','4','2696','Single-Family','beautifully 2-story home, offering 4 bedroom and 3 bathroom. 2 bedrooms down and including master bedroom. lovely brick elevation for sale in Wilkins Crossing. Great floor plan with both formals and master downstairs, 2 bedrooms and a gameroom upstairs. Nice Laminated wood floor in all living area downstairs, tiles in kitchen and all bathrooms, island kitchen with granite counter top. New interior and exterior paint. new roof. Awesome location, walking distance to Walker Station elementary school and neighborhood swimming pool. Lot size good enough to put in a swimming pool and more! Zone to outstanding Sugar Land schools and close to everything! automatic app-controlled sprinkler system.Highly rated and desirable Fort Bend Schools,easy access to Hwy 90 & 99.','','29','','','Electric Dryer Connections,Gas Dryer Connections','','Sellers Disclosure','1','Freestanding,Gas Connections','1','Sugar Land West','Central Electric,Central Gas','1','LOT 8 BLK 2','Subdivision Lot','11158','Appraisal District','','1135','0','','2','Electric Oven','0','','','Electric Cooktop','','Wood Shingle','19 - Fort Bend','WALKER STATION ELEMENTARY SCHOOL','AUSTIN HIGH SCHOOL (FORT BEND)','SARTARTIA MIDDLE SCHOOL','Appointment Required,Lockbox Front,Vacant/Unoccupied','Appraisal District','2','Traditional','WILKINS CROSSING','6717','','Public Water','1991','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','215723158','1675187645','215723158','2023-01-16T20:52:46.367','57627009','Terri Zinke Jackson','Stanfield Properties','','','29.694036','-95.107337','26','77536','11','314000.00','Active','Cherokee','1502','Street','Deer Park','3','0','4','2652','Single-Family','Excellent value in the desirable Runningbrook community in Deer Park ISD! This 2-story home with generously sized bedrooms features high ceilings, a home office, a formal dining, & a spacious island kitchen with a soaring ceiling that opens to the cozy den, plus an upstairs with a catwalk that overlooks the kitchen & front entry! The primary suite features French doors to a flex space that could be a home office, nursery, or 4th bedroom with hallway access, plus a SHOW-STOPPING master bath with a dramatic arched window above the jetted tub & dual sinks, vanities, & closets. You’ll enjoy summer BBQs on the expansive private 21\'x15\' covered patio, complete with ceiling fans for a cool breeze. The laundry room has a full-size tiled shower perfect for after boating or garage work showers. Updated include front windows(2019), roof(2020), & furnace(2021). Add your preferred paint & carpet to make it PERFECT! Bring your boat or trailer to this 2-car garage with 2-car porte-cochere & NO HOA!','0.1597','6','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Deer Park','Central Gas','0','LT 6 BLK 4 RUNNINGBROOK SEC 2','Subdivision Lot','6955','Appraisal District','','','0','','2','Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','16 - Deer Park','DEER PARK ELEMENTARY SCHOOL','DEER PARK HIGH SCHOOL','DEER PARK JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Runningbrook Sec 02','8781','2.8239','Public Sewer,Public Water','1989','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','216117232','1675187645','216117232','2023-01-16T20:08:38.140','57362062','Pamela Ledet','Texas Ethics Realty, LLC','','','30.823046','-95.128619','26','77360','6','144900.00','Active','Popular','344','Street','Onalaska','2','0','3','1152','Single-Family','Lovely home in Onalaska - Located in Lakeside subdivision close to the boat ramp. With just a little \"cosmetic\'s\" this cute 3 bedroom 2 bath home on 3 lots could be yours. The 3rd lot is empty to the left side. House leveled, new roof, AC, and exterior paint were done in 2020. Included in this property are a 26x22 man shop, a 32x7 screened-in porch, and an extra shed.','0.5','44','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','','','','Lake Livingston Area','Central Electric','1','PINE HARBOR SECTION 3 BLK 7 LOT 18','Cleared,Subdivision Lot','24029','Appraisal District','','180','0','','0','','0','','','Electric Range,Freestanding Range','','Composition','104 - Onalaska','ONALASKA ELEMENTARY SCHOOL','ONALASKA JR/SR HIGH SCHOOL','ONALASKA JR/SR HIGH SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','1','Traditional','Pine Harbor Sec 3','1821','2.054','Public Sewer,Public Water','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','216118514','1675187645','216118514','2023-01-16T20:11:08.080','47815244','Darrell Mayfield','Darrell Mayfield, REALTOR','','','29.816166','-95.394233','7','77018','3','230000.00','Active','33rd','408','Street','Houston','1','0','3','1622','Single-Family','Great opportunity to rehab or tear down. New construction thru out area. Home currently 3 bdrm and two living areas. Investor must see.','0.1435','9','','','','','Sellers Disclosure','','','','Northwest Houston','Central Gas','0','LTS 4 & 5 BLK 44 INDEPENDENCE HEIGHTS ANNEX','Subdivision Lot','6250','Appraisal District','','','0','','','','0','','','','','Composition','27 - Houston','BURRUS ELEMENTARY SCHOOL','WASHINGTON HIGH SCHOOL','HAMILTON MIDDLE SCHOOL (HOUSTON)','Appointment Required','Appraisal District','1','Traditional','Independence Heights Annex','4808','2.3307','Public Sewer,Public Water','1948','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','216323515','1675187646','216323515','2023-01-16T20:18:21.220','8141787','Feras Rachid','Opendoor Brokerage, LLC','','','29.905432','-95.080302','26','77532','4','343000.00','Active','Galley','810','Drive','Crosby','3','1','4','2618','Single-Family','Check out this stunner! This home has fresh exterior paint and partial flooring replacement. Discover a bright and open interior with plenty of natural light and a neutral color palette, complimented by a fireplace. Step into the kitchen, complete with an eye catching stylish backsplash. You won’t want to leave the serene primary suite, the perfect space to relax. Additional bedrooms provide nice living or office space. The primary bathroom is fully equipped with a separate tub and shower, double sinks, and plenty of under sink storage. Take it easy in the fenced in back yard. The sitting area makes it great for BBQs! Like what you hear? Come see it for yourself!\r\nThis home has been virtually staged to illustrate its potential.','0.1934','1','','','','','Sellers Disclosure','1','','1','Crosby Area','Central Electric','1','LT 4 BLK 3 NEWPORT SEC 8 4TH PAR R/P','Subdivision Lot','8423','Appraisal District','','55','0','','3','Gas Oven','0','','','Gas Range','','Composition,Other','12 - Crosby','CROSBY ELEMENTARY SCHOOL (CROSBY)','CROSBY HIGH SCHOOL','CROSBY MIDDLE SCHOOL (CROSBY)','Appointment Required,No Supra Keybox,Vacant/Unoccupied','Seller','2','Traditional','Newport Sec 8','9387','2.7105','Water District','2018','Seller'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216442961','1675187646','216442961','2023-01-16T19:24:44.717','56235671','K.C. Lam','RE/MAX Southwest','','','29.523620','-95.477333','34','77545','10','279900.00','Active','Regal Blue','1622','Court','Fresno','2','0','4','1966','Single-Family','Beautiful one story four bedroom home in quiet till Run subdivision with lots of upgrades. Fresh paint, new wood floor in entry, flex room and den. Ceramic tile in dining, kitchen, bkft n both baths. Kitchen remodeled with granite counter, refinished cabinets, s.s. undermounted sink, goose neck faucet and gas stove n extra strength vent hood. New dining light, and all crim lights replaced. Wood floor thru out. Both baths remodeled with vanity lurks, sink faucets, shower and tub surround replaced. Hall bath with recent vanity cabinet and tub faucet replaced. 2 large walk-ins and ceiling fans. Partial fence replaced. Recent water heater. Foundation repaired this year with lifetime transferable warranty. Excellent condition and price to sell fast.','0.1349','38','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Missouri City Area','Central Gas','1','TEAL RUN SEC 1, BLOCK 2, LOT 43','Subdivision Lot','5875','Appraisal District','','650','0','','2','Gas Oven,Single Oven','0','','','Gas Range','','Composition','19 - Fort Bend','BURTON ELEMENTARY SCHOOL (FORT BEND)','HIGHTOWER HIGH SCHOOL','LAKE OLYMPIA MIDDLE SCHOOL','Appointment Required,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Teal Run Sec 1','5725','2.4829','Public Sewer,Water District','1993','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','216444617','1675187646','216444617','2023-01-16T19:50:20.243','39613374','Mark Sonnier','George E. Johnson Properties','','','29.781086','-95.342768','9','77026','4','190000.00','Active','Davis','2112','Street','Houston','2','0','3','1096','Single-Family','Home centrally located minutes from Downtown, Med Center, HCC, UofH & TSU and near public transportation. Ceramic tile throughout. Granite countertops in kitchen & baths. Ceramic backsplash in kitchen & ceramic tub. Shower surrounds in both baths. Ceiling fans in family room & master bedroom. MEASUREMENTS ARE ESTIMATES - RE-MEASURE IF IMPORTANT. PLEASE DO NOT DISTURB TENANT.','0.0781','9','','','Washer Connections','','Seller may be subject to foreign tax and Buyer withholding per IRS,Tenant Occupied','1','','','Northside','Central Gas','0','LT 4 BLK 1 NORTHSIDE ESTATES','Subdivision Lot','3400','Appraisal District','','','0','','0','Freestanding Oven,Gas Oven','0','','','Gas Range','','Composition','27 - Houston','SHERMAN ELEMENTARY SCHOOL','NORTHSIDE HIGH SCHOOL','FLEMING MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Northside Estates','4175','2.3307','Public Sewer,Public Water','2013','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','216444669','1675187646','216444669','2023-01-16T19:49:14.287','45336427','Amberly Savage','Ward Real Estate, Inc','','','28.953487','-95.973621','28','77414','3','357900.00','Active','Sailfish','1310','','Bay City','2','0','3','1889','Single-Family','Looking for a custom home but don\'t want to wait? This home features open concept kitchen to dining space, custom cabinets & drawers throughout the home all with soft close, quartz counter tops, large island and stainless steel appliances. The living room boasts decorative beams, built in entertainment center & natural light. Primary bedroom is spacious, bathroom features double sinks, quartz counter tops, large walk-in shower and fabulous closet. Guest bedrooms have a unique touch for built in cabinets as closet. Ceramic tile that looks like wood allows every room to flow perfectly together.','','54','RGV Summit Const.','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','','Central Gas','0','Bay Ridge Sec 1 Block 2 lot 18','Subdivision Lot','','','','','1','Never Lived In','2','','0','','','Gas Range','','Composition','132 - Bay City','TENIE HOLMES ELEMENTARY SCHOOL','BAY CITY HIGH SCHOOL','BAY CITY JUNIOR HIGH SCHOOL','Lockbox Front','Builder','1','Traditional','Bay Ridge','','','Public Sewer,Public Water','2022','Builder'); --> New record created successfully