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-20T02:43:19.300' ,`MLSNumber` = '58121832' ,`ListAgentFullName` = 'Kenna Stephenson' ,`ListOfficeName` = 'State 28 Real Estate, PLLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.461478' ,`Longitude` = '-95.398602' ,`PhotoCount` = '36' ,`PostalCode` = '77583' ,`RoomCount` = '9' ,`ListPrice` = '999000.00' ,`Status` = 'Active' ,`StreetName` = 'Pursley' ,`StreetNumber` = '8514' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Iowa Colony' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '4140' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LUXURY, LAND, AND LOCATION! 20 minutes South of Houston Medical Center! This elegant barndominium boasts tons of character with amazing attention to detail, from soaring tongue-and-groove ceilings to stained concrete floors, antique corbels and more. The kitchen is truly the heart of this home, with Viking and Frigidaire PRO appliances, plus plenty of seating room for guests. Formal dining and elaborate wet bar with built-in wine chiller. Decorative ledges and niches throughout the home. Primary and second en suite bedroom downstairs, two huge bedrooms upstairs, AND two large flex rooms above breezeway for storage, media, or additional beds. Fully wired for SmartHome capability, two staircases, two laundry stations, outdoor kitchen with bar, extensive covered porches, oversized garage/workshop with full bath, designated RV bay, well house/barn, storage shed, gated private drive, all situated on fully fenced 9 acres with agriculture exemption. ONE OF A KIND CUSTOM HOME IS A MUST SEE!' ,`Acres` = '9' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0517 H T & B R R TRACT 62-63-63A ACRES 9.0' ,`LotDesciption` = 'Cleared' ,`LotSize` = '392040' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'MANVEL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Barndominium' ,`Subdivision` = 'H T & B R R' ,`TaxAmount` = '10258' ,`TaxRate` = '2.6851' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663712864' WHERE `Matrix_Unique_ID` = '205903908' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T03:58:25.030' ,`MLSNumber` = '11568983' ,`ListAgentFullName` = 'Maaz Kazmi' ,`ListOfficeName` = 'Texas Ally Real Estate Group,' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.644721' ,`Longitude` = '-95.659021' ,`PhotoCount` = '50' ,`PostalCode` = '77498' ,`RoomCount` = '4' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Lost Maples' ,`StreetNumber` = '15518' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1968' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GREAT IBESTMENT OPPORTUNNITY. BEAUTIFUL SINGLE STORY HOME IN THE MOST DESIREBALE SUBDIVISON. THIS BEAUTIFUL HOME HAS 4 BEDROOMS AND 2 BATHS. OPEN FLOOR PLAN. CONVENIENT CENTRAL SAFE LOCATION. FORMAL DIING AREA. NEW ROOF. PARK ACROSS THE STREET. ZONED TO EXCELLENT EXEMPLARY FORT BEND SCHOOLS. EVRYTHING YOU NEED IS CLOSE BY, BANKS, RESTAURANTS, AND SHOPPING CENTER. HIGHWAY 6 AND HWY 90 FEW MINUTES AWAY.' ,`Acres` = '0.1635' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PARK POINTE SEC 5, BLOCK 2, LOT 4' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7123' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LAKEVIEW ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Colonial,Traditional' ,`Subdivision` = 'Park Pointe Sec 5' ,`TaxAmount` = '5925' ,`TaxRate` = '2.6329' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663712864' WHERE `Matrix_Unique_ID` = '207554564' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T03:30:21.590' ,`MLSNumber` = '60634766' ,`ListAgentFullName` = 'Aaron Cruz' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.684435' ,`Longitude` = '-95.495924' ,`PhotoCount` = '19' ,`PostalCode` = '77074' ,`RoomCount` = '8' ,`ListPrice` = '284000.00' ,`Status` = 'Active' ,`StreetName` = 'Jackwood' ,`StreetNumber` = '5905' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1424' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New paint throughout, energy effects windows, updated bedroom doors and closets, water filtration system in the kitchen, new gas stove and dryer machine per seller. Utility room has central AC. Exterior features include foundation done in May, 2022.Welcome to this well maintained move-in ready home with many extras. 5905 Jackwood is a 3 bedroom, 2 full bath with bonus room and screened in patio. Interior features include original hardwood floors in all bedrooms and living room. Roof and HVAC is 5 years old, Hardie siding is 7 years old, zoned to Harod Elementary and NEVER FLOODED per seller.' ,`Acres` = '0.1607' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 11 BRAEBURN TERRACE SEC 2 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HEROD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHARPSTOWN HIGH SCHOOL' ,`SchoolMiddle` = 'FONDREN MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Braeburn Terrace Sec 02 R/P' ,`TaxAmount` = '3858' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1954' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663712864' WHERE `Matrix_Unique_ID` = '209821553' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T03:10:33.570' ,`MLSNumber` = '8449970' ,`ListAgentFullName` = 'Lauren Friese' ,`ListOfficeName` = 'Tilbury Real Estate Advisors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.020175' ,`Longitude` = '-95.475458' ,`PhotoCount` = '37' ,`PostalCode` = '77068' ,`RoomCount` = '10' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Encreek' ,`StreetNumber` = '2319' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2630' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Grand one story newly renovated with open flowing floor plan. Faux wood porcelain tile light gray wash throughout home. This home ample over sized family/ game room with access to garage and back yard. The living room with cozy fire place with double paned sliding glass doors. The kitchen with Silestone counters and Ceiling high shaker cabinetry with soft closed drawers and modern kitchen faucet and undermount sink. \r\nThe spa inspired light and bright primary bath with quartz counter and Kholer faucets, spacious glass enclosed shower. The porcelain tile with Cearra marble inspired design. The Quartz double vanity with soft closed shaker cabinetry. Energy efficient HVAC & TRANE a/c and gas heater and low E windows and insulated doors. 2-10 Sellers Coverage Home warranty. The Seller will provide 2-10 Home Warranty for the Buyer. Appliance Pack for the home.' ,`Acres` = '0.4408' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek North' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 276 BAMMEL FOREST SEC 3' ,`LotDesciption` = 'Cleared,Other,Wooded' ,`LotSize` = '19200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PONDEROSA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Bammel Forest Sec 03' ,`TaxAmount` = '5720' ,`TaxRate` = '2.0892' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663712864' WHERE `Matrix_Unique_ID` = '211986823' --> 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','212022760','1663712864','212022760','2022-09-20T02:10:26.217','33139240','Chacole Franklin','eXp Realty, LLC','','','29.744118','-95.295305','5','77011','5','285000.00','Active','Avenue O','7120','','Houston','2','0','3','1346','Single-Family','Location! Location! Location! Great Opportunity for investors to add the finishing touches and make this home your own in Houston\'s Revitalized East End! This redesigned 3 bedroom 2 bathroom home is just minutes from Downtown Houston. This home is an open canvas waiting on the right person to add their finishes just the way they like. Don\'t miss out on this rare opportunity.\r\nPictures coming soon!','0.0849','4','','','','','Mud,Sellers Disclosure','','','','East End Revitalized','Central Electric','0','LT 36 & TR 35 BLK 130 MAGNOLIA PARK SEC 2','Subdivision Lot','3700','Appraisal District','','','0','','0','','0','','','','','Composition','27 - Houston','FRANKLIN ELEMENTARY SCHOOL (HOUSTON)','AUSTIN HIGH SCHOOL (HOUSTON)','EDISON MIDDLE SCHOOL','Appointment Required,Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Traditional','Magnolia Pk Sub Sec 2','1995','2.3307','Public Water','1935','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','212385389','1663712864','212385389','2022-09-20T03:29:09.630','81098418','Lauren Friese','Tilbury Real Estate Advisors','','','29.582149','-95.061603','50','77586','11','385000.00','Active','Crownwood','4239','Drive','Taylor Lake Village','2','0','4','2487','Single-Family','Another beautifully renovation by Texas Home Buyers, 25 years bringing quality homes. Modern ranch: 4 b/ 2.1B/2C/ Sunroom in the fabulous community in Clear Lake Forest with amenities 3 Pools, Tennis Courts, Greenspace, Dock & Swim team, and renowned Women\'s Club. Design scheme inspired by Coastal Living. Exterior: New trim, Freshly painted grey-green- beige accent the multi tone Sandstone hues brick, light fixtures, New insulated entry with inset TEXAS STAR glass panel and landscaping. Clean and Crips home interior freshly painted modern greige walls & crisp white trim & cabinetry & ergonomic flooring & Salt and Pepper Granite Counters & Gallery Frigidaire appliance package & Subway Tile backsplash & cedar closet & NEW Spa inspired Primary bath w/ rain shower seamless Glass enclosed& porcelain tile floor & double vanity & shaker cabinetry & Primary wrap around closet & New Guest BATH & LED lighting & Ceiling fans & 2\" blinds & Revamped Sunroom. Home warranty included!','0.2626','7','','','Gas Dryer Connections,Washer Connections','','Mud,No Disclosures,Sellers Disclosure','1','','1','Clear Lake Area','Central Gas','1','LT 10 & TR 9 BLK 22 CLEAR LAKE FOREST SEC 5','Cleared,Subdivision Lot','11438','Appraisal District','','300','0','','2','Double Oven,Electric Oven','0','In Ground','','Electric Cooktop,Electric Range','','Composition','9 - Clear Creek','ROBINSON ELEMENTARY SCHOOL (CLEAR CREEK)','CLEAR LAKE HIGH SCHOOL','SEABROOK INTERMEDIATE SCHOOL','Appointment Required,No Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Ranch','Clear Lake Forest Sec 05','6919','2.279','Public Sewer,Public Water','1973','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','212548434','1663712865','212548434','2022-09-20T02:31:38.947','22000367','Blake Vincent','DUX Realty, LLC','Joshua Hill','Compass RE Texas, LLCHeights','29.797147','-95.474784','38','77055','11','599900.00','Option Pending','CAYWOOD','1513','Lane','Houston','2','1','3','2532','Single-Family','* JUST COMPLETED * Mazzarino Construction & Development\'s new division is here in Houston\'s well established inner loop neighborhoods. MAZZTAO Homes features a new, stylish, well priced, quality home, but with an entirely different price point. Located in Spring Branch, this home features an extremely versatile and functional floor plan. This floor plan features 3 bedrooms, 2.5 bath rooms, 1st floor living, primary w/ sitting area, flex room, a private driveway, and approximately 1,500 s.f.+ of backyard space . Spring Branch is minutes to the newly renovated Memorial Park Conservatory, White Oak & Buffalo Bayou Greenway Parks & Trails, and plenty of Restaurants and Retail. Minutes to Downtown Houston, Galleria, and easy assess to I-10, 610, 290, and I-45. Inquire today to learn more about customization options during construction only!','','24','MAZZTAO HOMES','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','','','Spring Branch','Central Gas,Zoned','0','LT 3 BLK 1 SHADYVILLA GROVE','Subdivision Lot','3815','Appraisal District','','','1','To Be Built/Under Construction','2','Electric Oven,Single Oven','0','','','Gas Cooktop,Gas Range','','Composition','49 - Spring Branch','HOUSMAN ELEMENTARY SCHOOL','NORTHBROOK HIGH SCHOOL','LANDRUM MIDDLE SCHOOL','Appointment Required','Builder','2','Contemporary/Modern,Traditional','SHADYVILLA GROVE','','','Public Sewer,Public Water','2022','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','212579870','1663712865','212579870','2022-09-20T02:11:23.563','75566741','Heather Warson','BHGRE Gary Greene','','','29.799097','-95.418277','42','77008','8','785000.00','Active','Beall','1529','Street','Houston','2','1','4','3140','Single-Family','Over 80k in upgrades, this Lindsey custom build showcases a timeless transitional design with immense architectural details, elegant neutral color palette, soaring 12’ ceilings, extensive millwork, refinished oak hardwood floors, alder wood-stained doors, & stylish plantation shutters. The gourmet kitchen is adorned w/ luxurious Cambria quartz counters, custom cabinets, under cabinet lighting, stylish fixtures & hardware, apron sink, gorgeous lighting, beverage cooler, warming drawer, abundant walk-in pantry & well-appointed butler’s pantry w/wine storage. All bedrooms up w/ an updated secondary bath. The elite primary suite is adorned w/ a separate sitting area, private balcony & spacious his/her walk-in closets. The luxurious primary bath is a spa like retreat w/elegant marble look porcelain tile, contemporary flooring, lush hardware & fixtures, & a gorgeous cast iron soaking tub. Extremely energy efficient w/new spray foam insulation. Great location in the Heights!!','0.0832','9','Lindsey Custom','','Electric Dryer Connections,Washer Connections','','Exclusions,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Heights/Greater Heights','Central Gas,Zoned','0','LT 3 BLK 1 LINDSEY PINES SEC 03','Subdivision Lot','3625','Appraisal District','','','0','','2','Convection Oven,Single Oven','0','','','Gas Range','','Composition','27 - Houston','SINCLAIR ELEMENTARY SCHOOL (HOUSTON)','WALTRIP HIGH SCHOOL','BLACK MIDDLE SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Appraisal','2','Traditional,Victorian','Shady Acres','12689','2.3307','Public Sewer,Public Water','2008','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','212709243','1663712865','212709243','2022-09-20T03:48:04.627','65499068','Jan Kish','Tiger Team Realty','','','29.484637','-94.930092','0','77539','6','199000.00','Active','16th','906','Street','San Leon','2','0','3','1480','Single-Family','Lovely large 3 bedroom bungalow, well maintained and updated. Large living area and large master bedroom. Big kitchen. Located in San Leon in a quiet, older neighborhood walking distance to Galveston Bay. Just over a half acre corner lot with good frontage on FM 517. Great for vacation home\r\n\r\nInvestor only, tenant occupied','0.5383','33','','','','','Sellers Disclosure,Tenant Occupied','','','','Bacliff/San Leon','Central Electric','0','ABST 10 A EDWARDS LOTS 26-27- 28-29-30-31 & 32 BLK 162 SAN L','Cleared,Corner','23450','Appraisal District','','','0','','2','Electric Oven,Single Oven','0','','','Electric Cooktop,Electric Range','','Composition','17 - Dickinson','SAN LEON ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','JOHN AND SHAMARION BARBER MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Ranch','San Leon','3865','2.521','Public Sewer,Public Water','1967','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','212709717','1663712865','212709717','2022-09-20T03:22:13.160','45067676','Jan Kish','Tiger Team Realty','','','29.390919','-95.089646','0','77510','4','250000.00','Active','Fm 1764','12501','Road','Santa Fe','2','0','3','990','Single-Family','Country living in this 3 bedrooms mobile home with updated 2 bathrooms. Located on a one acre lot, no fence. Large 2 cars garage and 2 cars carport. Convenient located at FM 1764 and one block from FM 646.It can be commercial mix usage.\r\n\r\nInvestor only, tenants occupied. Contact agent for showing','1','33','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure,Tenant Occupied','','','','Santa Fe','Central Electric','0','ABST 1 PAGE 11 PT OF LOT 17 (17-6) THAMANS 1ST SUB MH 1984 M','Cleared','43560','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Cooktop,Electric Range,Freestanding Range','','Aluminum','45 - Santa Fe','WILLIAM F BARNETT ELEMENTARY SCHOOL','SANTA FE HIGH SCHOOL','SANTA FE JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Other Style','Thamans 1st Sub','2431','2.3536','Public Sewer,Public Water','1984','Appraisal District'); --> New record created successfully