Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-13T10:51:28.323' ,`MLSNumber` = '17855475' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.768721' ,`Longitude` = '-95.325654' ,`PhotoCount` = '21' ,`PostalCode` = '77020' ,`RoomCount` = '3' ,`ListPrice` = '338999.00' ,`Status` = 'Active' ,`StreetName` = 'Gunter' ,`StreetNumber` = '4427' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2127' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brick home with 3 bedrooms, 2 bathrooms, and an attached 2-car garage. Great-sized kitchen with spacious countertops. Home features new interior paint, new carpet, and new doors in select rooms. Easy access to I-10 and a short drive away from Ea-Do Houston! Contact us today for more information!' ,`Acres` = '0.2204' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 6 & 7 BLK 3 PHILLIPS' ,`LotDesciption` = 'Other' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HENDERSON N ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Phillips' ,`TaxAmount` = '4851' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090582' WHERE `Matrix_Unique_ID` = '203053851' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-13T09:37:03.623' ,`MLSNumber` = '39863095' ,`ListAgentFullName` = 'Lou Rosas' ,`ListOfficeName` = 'RE/MAX Real Estate Assoc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.694647' ,`Longitude` = '-95.284446' ,`PhotoCount` = '35' ,`PostalCode` = '77017' ,`RoomCount` = '9' ,`ListPrice` = '195000.00' ,`Status` = 'Active' ,`StreetName` = 'Detroit' ,`StreetNumber` = '7824' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '1576' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '4 bedroom, 2 full baths - or Office/Study, 3 bedrooms, with 2 full baths, no HOA, live and operate your small business from this easy freeway access location' ,`Acres` = '0.1435' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 18 BLK 204 PARK PLACE CIRCLE' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SANCHEZ ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'CHAVEZ HIGH SCHOOL' ,`SchoolMiddle` = 'ORTIZ MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Park Place Circle' ,`TaxAmount` = '3318' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1946' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090582' WHERE `Matrix_Unique_ID` = '205590750' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-13T09:02:53.873' ,`MLSNumber` = '51923070' ,`ListAgentFullName` = 'Gabriela Sanches' ,`ListOfficeName` = 'RCR Properties Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.867470' ,`Longitude` = '-97.400054' ,`PhotoCount` = '18' ,`PostalCode` = '76634' ,`RoomCount` = '3' ,`ListPrice` = '189000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 1700' ,`StreetNumber` = '159' ,`StreetSuffix` = '' ,`City` = 'Clifton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1380' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come take a look at this lovely home that\'s close to Lake Whitney. This is an excellent opportunity to purchase a house that will give you the chance to relax and enjoy nature. The property is situated on a 0.49-acre plot of land, close to a lake with trails for walking and boating. This property is outside of the city limits, which is great for those looking to live a rural lifestyle. Windows and doors are brand new. New lighting and lamps have been install through out the whole house. All of the walls in the house have new sheetrock. Recently, new 30 yr. roof The property\'s exterior backside also features two other buildings that are excellent for storage and one chicken coop house. Property has circular driveway. Fresh paint entire home,laminated floors, quartz on restrooms\r\nDon’t wait to long schedule you’re showing today!!\r\nExcellent location for the price. Homes are selling for more near area.' ,`Acres` = '0.493' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BIG ROCKY PT FSHX CMP BLOCK UNPLATTED LOT 3W & 4W BLOCK B LO' ,`LotDesciption` = 'Other' ,`LotSize` = '21475' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '421 - Clifton' ,`SchoolElementary` = 'CLIFTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLIFTON HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (CLIFTON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Big Rocky Pt Fshx Cmp' ,`TaxAmount` = '1360' ,`TaxRate` = '1.7588' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090582' WHERE `Matrix_Unique_ID` = '211283565' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-13T10:42:41.197' ,`MLSNumber` = '30780298' ,`ListAgentFullName` = 'Robert Bland' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.725226' ,`Longitude` = '-95.394385' ,`PhotoCount` = '50' ,`PostalCode` = '77005' ,`RoomCount` = '15' ,`ListPrice` = '4400000.00' ,`Status` = 'Active' ,`StreetName` = 'Shadow Lawn' ,`StreetNumber` = '14' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '5838' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Shadowlawn was developed in the early 1920’s by John H. Crooker who built 14 Shadow Lawn. Crooker had first choice of the Shadow Lawn lots and commissioned MIT trained architect Joseph W. Northrup, Jr., who was in Houston working on some of Rice University\'s early buildings, to design his home. A front porch opens into a gracious entry foyer w/ front stairs and cased openings to the major downstairs rooms; the living room w/access to the sunroom, a handsome library & home office and the formal dining room. The Island kitchen has access to the breakfast rm & butler’s pantry/wet bar. Upstairs to 4 bedrooms w/ private baths. The primary suite has an adjacent sitting room & sunroom with private views. 3rd floor game room w/dormer windows. This brick Colonial Revival style home w/a copper roof sits on a wonderfully private and wooded site; almost 2/3 of an acre. Grounds include a pool, patio and spa. Driveway gate to 3 car garage and updated guest suite. Many recent updates. A fine home.' ,`Acres` = '0.6295' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '4' ,`GeoMarketArea` = 'Rice/Museum District' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 14 & 15 SHADOWLAWN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '27419' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'POE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadowlawn' ,`TaxAmount` = '67589' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1923' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090582' WHERE `Matrix_Unique_ID` = '211927289' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-13T10:02:05.813' ,`MLSNumber` = '77708420' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.835617' ,`Longitude` = '-95.854885' ,`PhotoCount` = '14' ,`PostalCode` = '77493' ,`RoomCount` = '7' ,`ListPrice` = '354087.00' ,`Status` = 'Active' ,`StreetName` = 'Cambria Green' ,`StreetNumber` = '201' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2108' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Montauk plan features four bedrooms, two full bathrooms, and spacious walk-in closets!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 34, Block 1, Section 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '6465' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090582' WHERE `Matrix_Unique_ID` = '213170977' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-13T10:15:16.070' ,`MLSNumber` = '76474395' ,`ListAgentFullName` = 'Natalie Pierce-Cox' ,`ListOfficeName` = 'Markham Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.700700' ,`Longitude` = '-95.591700' ,`PhotoCount` = '33' ,`PostalCode` = '77340' ,`RoomCount` = '11' ,`ListPrice` = '439000.00' ,`Status` = 'Active' ,`StreetName` = 'Wood Forest' ,`StreetNumber` = '107' ,`StreetSuffix` = 'Lane' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '3' ,`SqFtTotal` = '2507' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'What a dream property! Located in the desirable Westridge Subdivision, this custom home has so much to offer and sits on a beautiful 1.15 acre tree shaded lot! 3 bedrooms, bonus room above the garage, swimming pool and incredible storage space, including multiple large storage rooms in the home. The family room and master bedroom have beautiful wood laminate flooring and the kitchen has been updated with granite counter tops and painted cabinets. There was no detail left out of this home and you truly have to see to appreciate. Sprinkler system, fenced back yard, gorgeous mature trees, double pane windows, and the setting is so private and peaceful!' ,`Acres` = '1.15' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WESTRIDGE - SEC 3, BLOCK 8, LOT 4, ACRES 1.15, RES F' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'SAMUEL W HOUSTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westridge' ,`TaxAmount` = '6291' ,`TaxRate` = '1.886819' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090583' WHERE `Matrix_Unique_ID` = '214655071' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-13T09:27:31.960' ,`MLSNumber` = '93102852' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = 'Enrique Culebro' ,`SellingOfficeName` = 'Realty Associates' ,`Latitude` = '30.066987' ,`Longitude` = '-95.724107' ,`PhotoCount` = '15' ,`PostalCode` = '77377' ,`RoomCount` = '8' ,`ListPrice` = '299142.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Brego' ,`StreetNumber` = '18910' ,`StreetSuffix` = 'Lane' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1456' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*home is under construction.* Your dream home awaits! This gorgeous Beazer home in the desirable community of Amira features a brick exterior, tile flooring, sprinkler system, energy-efficient features, a shower in the spacious primary suite, and a covered patio. The impressive kitchen is complete with quartz countertops, mosaic backsplash, Jasper® under-mount sink, 42” upper cabinets, and pendant lighting. Walk among 100-year-old oak trees to find Amira’s world-class comforts, including a glistening infinity-edge pool, clubhouse, dog park, and full fitness center. Nestled off the Grand Parkway and Hwy 249, residents are minutes from popular restaurants, shops, and parks in central Tomball and Cypress. Students attend the top-rated Tomball ISD.' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 50 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Amira' ,`TaxAmount` = '' ,`TaxRate` = '3.551993' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090583' WHERE `Matrix_Unique_ID` = '214908164' --> 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','215283070','1675090583','215283070','2022-12-13T10:44:12.160','12749112','Stephen Hemphill','Steve Hemphill - Urban Lofts','','','29.758401','-95.340143','20','77003','6','499900.00','Active','Decker','2855','Place','Houston','3','1','3','2116','Single-Family','UNDER CONSTRUCTION! To be completed in summer of 2023. Stunning Euro-Design townhome, situated in the popular East End neighborhood! This beautiful contemporary home features 3 beds, 3.5 baths, high ceilings and natural light throughout. The kitchen features a unique straight-line cooktop on the island with a magnificent stainless steel hood vent above it. Real 3/4\" oak floors! This is the home for any Astros fan with Minute Maid Park only a mile away, and perfect for anyone who enjoys being walking distance from entertainment like Houston\'s No. 1 TexMex restaurant, Ninfa\'s Original on Navigation, East End\'s Saturday Market, AND Midway\'s massive new mixed use development on the Bayou, EAST RIVER, which just opened up a brand new 9 hole golf course -- the East River 9!!','','4','Urban Lofts Townhome','','','','No Disclosures','1','','','East End Revitalized','Central Gas','1','Lot 11, Block 1','Other','','','','1452','1','To Be Built/Under Construction','2','Electric Oven','0','','','Gas Cooktop','','Aluminum','27 - Houston','BURNET ELEMENTARY SCHOOL (HOUSTON)','WHEATLEY HIGH SCHOOL','NAVARRO MIDDLE SCHOOL (HOUSTON)','Accompany,Appointment Required','Builder','3','Contemporary/Modern','Middle Street Lofts on the Bayou','','2.6','Public Sewer,Public Water','','Builder'); --> 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','215374448','1675090583','215374448','2022-12-13T10:38:46.067','69754507','Gidget Sauceda','RE/MAX Integrity','','','29.809965','-95.376880','42','77009','7','2395000.00','Active','Tabor','1808','Street','Houston','1','2','2','3336','Single-Family','This amazing 1890’s newly remodeled Farmhouse in nearby downtown Houston, sits on a beautiful 1 acre + property on the banks of Little White Oak Bayou in the Heights. This home has 2100 sq. ft. of living space in addition to 1,000 sq. ft. of useable basement space. Exceptional location with easy access to all major freeways, I-45, I-10, I-69 and I-610. Proximity to the Montrose area, Art Districts & Museums. Only minutes to Downtown and many Heights Hotspots. Walking distance to the newly remodeled Farmers Market and restaurants. For the outdoor recreation lovers, the Historic Heights Brooke Smith Park is nearby. This is a unique opportunity to live and work in a fabulous location.','1.2192','9','','','','','Sellers Disclosure','0','','0','Heights/Greater Heights','Central Electric','0','TR 7 SAPP GARDENS ABST 1 J AUSTIN','Cleared','53110','Appraisal District','','','0','','0','Electric Oven','0','','','Electric Range','','Composition','27 - Houston','JEFFERSON ELEMENTARY SCHOOL (HOUSTON)','HEIGHTS HIGH SCHOOL','HAMILTON MIDDLE SCHOOL (HOUSTON)','Appointment Required,Supra Keybox','Appraisal District','2','Other Style','Tract 7','','','Public Water','1890','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','215401611','1675090583','215401611','2022-12-13T10:20:19.277','35656283','Hannah Haynes','RE/MAX One','','','30.087811','-94.161654','31','77706','6','235000.00','Active','Clinton','5870','Street','Beaumont','2','0','3','1720','Single-Family','Great home in the West End of Beaumont ready for its new owner! The seller is offering $1000 in sellers concessions and including washer and dryer for new owners! This house offers space for everyone. This adorable home has wood flooring throughout and has been freshly painted. The back yard is everything! The covered pergola has been freshly stained and has plenty of room to relax unde ror host friends. The back yard also offers a workshop. This adorable home is a absolute must see and ready for you to schedule your appointment today!','0.2925','51','','','','','Sellers Disclosure','1','','0','','Central Electric','0','MARY HOWELL 3RD L10 B11','Subdivision Lot','12740','Appraisal District','','','0','','2','','0','','','Gas Range','','Composition','143 - Beaumont','CURTIS ELEMENTARY SCHOOL (BEAUMONT)','WEST BROOK HIGH SCHOOL','MARSHALL MIDDLE SCHOOL (BEAUMONT)','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Mary Howell Add 03','5485','2.6134','Public Sewer,Public Water','1978','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215494976','1675090583','215494976','2022-12-13T10:01:42.040','19894555','Kelly Barnett','Barnett Real Estate','','','30.496332','-96.457182','26','77878','8','290000.00','Active','County Road 268','1472','','Snook','2','0','3','2722','Single-Family','Beautiful spacious home on an acre in the City of Snook but with a country feel. The home has 3 bedrooms, 2 baths, office/den and a HUGE bonus room. Bonus room is large enough for a pool table or other games, ready for you to entertain with its sound system with speakers, large bar and seating and separate room for mixing all your beverages. If you need a 4th bedroom, this bonus room may be just what you are looking for. The home features a large kitchen with tons of cabinets and attached dining area, a lovely fireplace, vaulted ceiling in the den/office, and much more. There is a large, fenced backyard with gorgeous trees for shade for relaxation, the little ones to play or your animals to thrive. Located in the rural Snook area, with city services, this home is a short drive to Bryan/College Station. Come see this place that you can soon call home.','1','59','','','','','No Disclosures','','Wood Burning Fireplace','1','','Central Gas','0','S3301 SEBESTA LOT 10 1.0 ACRES','Cleared,Other,Wooded','43560','Appraisal District','','','0','','2','','0','','','','','Composition','192 - Snook','SNOOK ELEMENTARY SCHOOL','SNOOK SECONDARY SCHOOL','SNOOK MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Ranch','Sebesta','4244','2.2267','Public Sewer,Public Water','1963','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','215536930','1675090583','215536930','2022-12-13T09:41:41.467','18760181','Anissa Wilson','The Professional Landlords','','','30.048702','-95.375958','30','77373','5','320000.00','Active','Heeney Park','2403','Lane','Spring','3','0','5','2523','Single-Family','Energy Star qualified home! No high energy bills with this home! Only a year old, it features solar panels, a generator, a tankless water heater, a water softener system, a smart pad and more! There are 5 spacious bedrooms with a bedroom on the first floor and 3 full sized bathrooms! There are two family areas with the main living room on the first floor and a second family room on the second floor. Entertain family and guests in the island kitchen complete with stainless steel appliances including a fridge! Since this home sits on a cul-de-sac, it has a huge backyard! It is in close proximity to George Bush International Airport, The Grand Pkwy, Hardy Toll Rd, The Woodlands, major shopping centers, dining establishments and entertainment venues! Submit your offers today, this home will not last long!','','12','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Spring East','Central Gas','1','LT 10 BLK 1 BRECKENRIDGE WEST SEC 9','Cul-De-Sac','9384','Appraisal District','','440','0','','2','Gas Oven','0','','','Gas Range','','Composition','48 - Spring','GLORIA MARSHALL ELEMENTARY SCHOOL','SPRING HIGH SCHOOL','RICKY C BAILEY M S','Accompany,Appointment Required','Appraisal District','2','Traditional','Breckenridge West Sec 9','9420','3.0268','Public Sewer,Public Water','2021','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','215543674','1675090583','215543674','2022-12-13T10:57:38.203','87582874','Fabiola Oropeza','Vibrant Realty LLC','','','29.726423','-94.975053','19','77520','3','137500.00','Active','Daniel','304','Street','Baytown','1','0','3','1008','Single-Family','Charming updated 3 Bedroom 1 bath home. Newer flooring, hardware, and cabinetry through-out. Bright white kitchen with appliances. Schedule your showing today!','0.1148','2','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','','','','Baytown/Harris County','No Heating,Window Unit','0','LT 5 BLK 1 SCHILLING & MASSEY','Cleared','5000','Appraisal District','','','0','','0','Electric Oven','0','','','Electric Range','','Composition','23 - Goose Creek Consolidated','CARVER ELEMENTARY SCHOOL (GOOSE CREEK)','LEE HIGH SCHOOL (GOOSE CREEK)','HORACE MANN J H','Appointment Required,Lockbox Left Side,Request Online Appointment','Appraisal District','1','Other Style','Schilling & Massey','3161','2.97','Public Sewer,Public Water','1956','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','215547003','1675090583','215547003','2022-12-13T10:25:54.933','73801647','Mario Navarro','Prime Realty Group','','','29.690218','-95.650836','16','77083','3','235000.00','Active','Crestwick','8119','Drive','Houston','2','1','3','1388','Single-Family','Completely and Beautifully Updated and Move-in Ready!!! Wonderful all brick 3-bedroom 1.5 bath Two story home located in the very desirable subdivision.\r\n\r\nTHIS IS A MUST SEE!!! DON\'T WASTE ANY TIME!! GREAT LOCATION, Fort Bend County, MINUTES FROM HWY 6 AND WESTPARK TOLLWAY. Families with children will love the convince of the Elementary School and Middle School at walking distance, great for entertaining. So many accents in this home to long to list. Make your appointment today.','0.21','37','','','','','No Disclosures','','','1','Mission Bend Area','Central Electric','1','LT 6 BLK 3 MISSION GLEN EAST SEC 1','Subdivision Lot','9148','Appraisal District','','400','0','','2','','0','','','','','Composition','2 - Alief','PETROSKY ELEMENTARY SCHOOL','AISD DRAW','ALBRIGHT MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','2','Colonial','Mission Glen East Sec 01','3422','2.202','Public Sewer,Public Water','1985','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','215556235','1675090583','215556235','2022-12-13T09:52:59.657','67066331','Jennifer Grande','Grand Realty','','','29.296629','-94.915539','38','77554','7','899900.00','Active','Tiki','1303','Drive','Tiki Island','3','0','4','2878','Single-Family','Beautiful home on large canal front lot with ELEVATOR access to all 3 floors! Elevator makes taking in your groceries a breeze! Second floor has decking around the entire floor with 3 access doors - LOTS of outside space to relax or entertain. Room for a pool on second lot. Extra-long driveway for plenty of parking and puts distance between home and Tiki Drive. Sides to community lake - great place to take a walk or play with family & pets. Granite throughout 2nd floor with tile backsplash in kitchen. Barely used double oven and electric cooktop with 2nd sink in kitchen as well! Large double door stainless refrigerator to stay! Large game room on top floor! Master includes spacious jacuzzi tub with separate shower and double sinks. Come check out this gem today!','0.174','33','','','Electric Dryer Connections,Washer Connections','','Owner/Agent','1','Wood Burning Fireplace','2','Tiki Island','Central Electric','1','ABST 7 S C BUNDICK SUR LOT 57 TIKI ISLAND SEC 3','Subdivision Lot,Water View,Waterfront','7579','Appraisal District','','150','0','','2','Double Oven,Electric Oven','0','','','Electric Cooktop','','Composition','52 - Texas City','HAYLEY ELEMENTARY SCHOOL','LA MARQUE HIGH SCHOOL (TEXAS CITY)','LA MARQUE MIDDLE SCHOOL (TEXAS CITY)','Appointment Required','Appraisal District','2','Traditional','Tiki Island 3','','','Public Sewer,Public Water,Water District','2002','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215562880','1675090583','215562880','2022-12-13T10:58:08.420','43009071','Jessica Murphy','Birdsong Real Estate','','','29.162513','-95.623096','18','77486','4','360990.00','Active','Inwood','221','Drive','West Columbia','2','0','4','1878','Single-Family','Welcome home to 221 Inwood Drive, located in the beautiful community of Columbia Lakes. This sought-after Duval floorplan offers a gorgeous Farmhouse elevation, 4 bedrooms, 2 baths, 42\" Kent Moore Cabinets, an oversized island with hanging pendant lights, designer backsplash, and so much more. This open floor plan has tons of natural light flowing throughout, stainless steeled appliances, USB Plug in kitchen and master, as well as a spacious Primary bed and En-suite. Call your Realtor today to schedule a private showing.','0.2066','5','Kendall Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','','','West of the Brazos','Central Gas','1','COLUMBIA LAKES SEC 2 (A0133 M VARNER) BLK 17 LOT 6','In Golf Course Community','8999','Appraisal District','','150','1','Never Lived In','2','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','10 - Columbia-Brazoria','','COLUMBIA HIGH SCHOOL','WEST BRAZOS JUNIOR HIGH','Appointment Required,Lockbox Front','Builder','1','Traditional','Columbia Lakes Sec 1-2-3-4-5','743','2.0633','Public Sewer,Water District','2022','Builder'); --> New record created successfully