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-23T21:15:32.577' ,`MLSNumber` = '85910971' ,`ListAgentFullName` = 'Bridget Hensley' ,`ListOfficeName` = 'Re/Max Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.042396' ,`Longitude` = '-95.709739' ,`PhotoCount` = '26' ,`PostalCode` = '77480' ,`RoomCount` = '7' ,`ListPrice` = '349999.00' ,`Status` = 'Active' ,`StreetName` = 'Victory' ,`StreetNumber` = '204' ,`StreetSuffix` = 'Lane' ,`City` = 'Sweeny' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2238' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME to 204 Victory Lane! This stunning custom built home nested on huge lot with trees on an established cul-de-sac is waiting for you in the highly desirable Sweeny ISD! Features include 4 spacious bedrooms and 3 full bathrooms with a split floor plan for added privacy for the master suite! Master bath offers a nice size claw tub and walk in shower! A gourmet kitchen with a 6 burner gas stove, tons of storage for your baking and cooking needs! Lots of built-ins! Additional charming living area, perfect for a home office or game room! Retreat after a long day on the covered patio, tons of shade for outdoor fun and entertaining! Plenty of space for a sparkling pool! This home has never flooded Don\'t delay and schedule your showing for this gem today!' ,`Acres` = '0.3' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PROMISED LAND ESTATES SEC 2 (SWEENY), LOT 7' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '13068' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '51 - Sweeny' ,`SchoolElementary` = 'SWEENY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SWEENY HIGH SCHOOL' ,`SchoolMiddle` = 'SWEENY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Promised Land Estates Sec 1-2' ,`TaxAmount` = '8167' ,`TaxRate` = '2.8427' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675218186' WHERE `Matrix_Unique_ID` = '210898562' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T21:34:52.263' ,`MLSNumber` = '56600593' ,`ListAgentFullName` = 'Derek Montes' ,`ListOfficeName` = 'Luxely Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.391197' ,`Longitude` = '-94.899186' ,`PhotoCount` = '28' ,`PostalCode` = '77590' ,`RoomCount` = '2' ,`ListPrice` = '89900.00' ,`Status` = 'Active' ,`StreetName` = '4th' ,`StreetNumber` = '616' ,`StreetSuffix` = 'Street' ,`City` = 'Texas City' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '805' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Recently renovated with new updates: kitchen, bath, HVAC, plumbing, electric, range, dishwasher, flooring, sheetrock, paint, fixtures, water heater, windows, doors, and more. This home has been brought back to life and it is perfect for a starter home or for a rental property. TURN KEY READY or RENT READY!!! Close to all local amenities including the refineries. Come check this one out, IT WILL NOT LAST LONG!' ,`Acres` = '0.0631' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 205 LOT 3 BLK 127 TEXAS CITY' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'ROOSEVELT-WILSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TEXAS CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BLOCKER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Texas City' ,`TaxAmount` = '2149' ,`TaxRate` = '2.5335' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675218186' WHERE `Matrix_Unique_ID` = '211453878' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T21:03:05.483' ,`MLSNumber` = '28214242' ,`ListAgentFullName` = 'Tahira Syed' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.723959' ,`Longitude` = '-95.426692' ,`PhotoCount` = '7' ,`PostalCode` = '77005' ,`RoomCount` = '9' ,`ListPrice` = '1900000.00' ,`Status` = 'Active' ,`StreetName` = 'Albans' ,`StreetNumber` = '3112' ,`StreetSuffix` = 'Road' ,`City` = 'West University Place' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3535' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stylish West U new construction home to be built by Detamore Development Team.. 3112 Albans defines modern elegance with timeless finishes featuring 4-5 bedrooms and 5 FULL bathrooms, open and airy spaces, large windows, high ceilings and a conveniently located first floor office/bedroom with a FULL bathroom! The sunlit Kitchen will showcase Wolf/Sub-Zero Appliances, custom built cabinetry, natural stone countertops, large center island and a walk-in pantry. Primary retreat on second floor with a custom fitted closet and a luxurious spa like bathroom! Game-room and three additional secondary bedrooms with walk-in closets and en-suite bathrooms on the second floor. Pergola with outdoor kitchen and a spacious backyard to fit a sizable pool (see renderings in pictures). Tucked in the heart of West University Place, short walk to the Rice Village, Parks, Shops and Restaurants. A SHOWSTOPPER!' ,`Acres` = '0.1205' ,`Area` = '17' ,`BuilderName` = 'Detamore Development' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West University/Southside Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 21 BLK 3 MONTICELLO' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WEST UNIVERSITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,French,Other Style' ,`Subdivision` = 'Monticello' ,`TaxAmount` = '15345' ,`TaxRate` = '2.0584' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675218186' WHERE `Matrix_Unique_ID` = '211775293' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T21:06:21.257' ,`MLSNumber` = '50366573' ,`ListAgentFullName` = 'Purva Shah' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.924195' ,`Longitude` = '-95.700015' ,`PhotoCount` = '48' ,`PostalCode` = '77433' ,`RoomCount` = '11' ,`ListPrice` = '2330000.00' ,`Status` = 'Active' ,`StreetName` = 'Austin Bayou' ,`StreetNumber` = '19211' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '6' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '7609' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A Magnificent Mediterranean Estate built in coveted Towne Lake. This extravagant custom-built home situated on almost 3/4th of an acre of double lot (Lot # 19211&19207) offers luxurious living spaces in a secure setting within a gated community. Step into a soaring 30’ foyer overlooking fire pit, summer kitchen, covered veranda, pavilion and spectacular pool with all the imaginable features. Casita offers an inherent flexibility to guests and owner’s privacy. The home was built to create a living experience that accommodates both large scale entertainment & warm living room inviting family life. The main house offers 5 beds, 5 full & 1 half-bath, executive office, game room, media room, gourmet kitchen, catering kitchen, butler’s pantry, formal dining with dry bar, 2 staircases, 4-car garage with golf cart parking space. Backyard retreat with lush landscaping & expansive lawn. Home boasts natural lighting & high-end elegant custom finishes throughout. Ask listing agent for exclusions.' ,`Acres` = '0.722' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 3 TOWNE LAKE SEC 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '31493' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2249' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'RENNELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Towne Lake' ,`TaxAmount` = '49091' ,`TaxRate` = '3.091' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675218186' WHERE `Matrix_Unique_ID` = '212103966' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T21:24:24.973' ,`MLSNumber` = '41067966' ,`ListAgentFullName` = 'Paula Miller' ,`ListOfficeName` = 'World Wide Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.704440' ,`Longitude` = '-95.337683' ,`PhotoCount` = '6' ,`PostalCode` = '77021' ,`RoomCount` = '4' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Ventura' ,`StreetNumber` = '4931' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2399' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Luxury Home! Finish gorgeous plan under construction. Being sold as is. Centrally located Houston Subdivision Lot! No HOA! Located in the inner city of Houston, Texas near Medical Center, Downtown, University of Houston Central Campus and TSU! Three to four awesome bedrooms! Make the extra room fit your lifestyle, make it an office, kid nursery, guest room, formal living or dining. High ceilings, open space living area with plans for a built in large island for family, dining and entertaining! Beautiful neighborhood! Awesome location!' ,`Acres` = '0.1769' ,`Area` = '4' ,`BuilderName` = 'Nikmard Investments' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 16 BLK 92 RIVERSIDE TERRACE SEC 22' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7704' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PECK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverside Terrace Sec 22' ,`TaxAmount` = '3249' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675218187' WHERE `Matrix_Unique_ID` = '212598972' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T21:25:57.150' ,`MLSNumber` = '95821117' ,`ListAgentFullName` = 'Zenobia Washington' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.975477' ,`Longitude` = '-95.239117' ,`PhotoCount` = '35' ,`PostalCode` = '77396' ,`RoomCount` = '9' ,`ListPrice` = '310000.00' ,`Status` = 'Active' ,`StreetName` = 'Serenata' ,`StreetNumber` = '9610' ,`StreetSuffix` = 'Court' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2768' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOVE-IN READY HOME! With approximately 2800 SF, it sits on over 1/4 of an acre, CUL-DE-SAC lot. Only 4 homes on this street, and it is not very close to neighbors. This home has been rejuvenated with fresh paint inside and out, new carpet, new blinds, and several new fixtures, with many modern family features, including 4 bedrooms, 2.5 baths, an open kitchen family room concept, breakfast area, a gas fireplace, wrap-around kitchen bar for extra seating, office/study, formal dining, large game room/media room, and plenty of yard space to create your backyard dream oasis! Lots of space for entertaining family and friends. Located minutes from Hwy 59/69 and 3 Minutes from Guy M. Sconzo Early College High School. Original owners! A must-see. *FYI: Family room dimensions include the Breakfast area*' ,`Acres` = '0.2777' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Humble Area East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 29 BLK 2 WOODLAND PINES SEC 1' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '12095' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'RIVER PINES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'ROSS STERLING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodland Pines Sec 01' ,`TaxAmount` = '6185' ,`TaxRate` = '2.933' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675218187' WHERE `Matrix_Unique_ID` = '212888649' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T21:02:32.320' ,`MLSNumber` = '61733804' ,`ListAgentFullName` = 'Sherri Barrett' ,`ListOfficeName` = 'Emblem Properties' ,`SellingAgentFullName` = 'Pamela Rogers' ,`SellingOfficeName` = 'Coleman & Patterson, LLC' ,`Latitude` = '31.079912' ,`Longitude` = '-96.214079' ,`PhotoCount` = '49' ,`PostalCode` = '77871' ,`RoomCount` = '8' ,`ListPrice` = '399900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Golfview' ,`StreetNumber` = '22' ,`StreetSuffix` = 'Drive' ,`City` = 'Hilltop Lakes' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2431' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'YOU FOUND IT! The peace and serenity that you have been looking for built in 2012 on the 5th Green across from the airstrip of Hilltop Lakes\' own private airport. FREE GOLF for YOU and YOUR GUEST. Hilltop Lakes Golf Course has challenging narrow fairways. No one playing the course will ever forget Hole #14, nicknamed “Bear Claw”, because it will grab you!! (HTL) This home offers a relaxing outdoor living area under the Veranda with a nicely shaded view of the fenced backyard and the golfcourse. Enter at the portico to a beautiful living area lined with glass windows and a wood burning fireplace with a study off the entrance. This split bedroom plan has a large primary suite with small sitting area and opens to the ensuite bath. Two guest bedrooms each with a separate entrance to guest bath and each with individual sinks. Hilltop Lakes is a wonderful, \"tucked away\" community with many other amenities such as horse stables, pool, tennis, disc golf, putt-putt golf, etc. See for yourself!' ,`Acres` = '0.2466' ,`Area` = '63' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Normangee/Marquez Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'HILLTOP LAKES SEC 3A BLK 1 LT 2' ,`LotDesciption` = 'On Golf Course' ,`LotSize` = '10741' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '131 - Normangee' ,`SchoolElementary` = 'NORMANGEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORMANGEE HIGH SCHOOL' ,`SchoolMiddle` = 'NORMANGEE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hilltop Lakes Sec 3-A' ,`TaxAmount` = '5039' ,`TaxRate` = '1.8865' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675218187' WHERE `Matrix_Unique_ID` = '212956552' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T22:27:36.133' ,`MLSNumber` = '22974672' ,`ListAgentFullName` = 'Jeremiah Hobbs' ,`ListOfficeName` = 'United Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.701203' ,`Longitude` = '-95.476446' ,`PhotoCount` = '11' ,`PostalCode` = '77081' ,`RoomCount` = '5' ,`ListPrice` = '1199000.00' ,`Status` = 'Active' ,`StreetName` = 'Aspen' ,`StreetNumber` = '5500' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '4441' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Pre construction opportunity on a large corner lot zoned to Bellaire high school! This stunning custom contemporary design offers an open floor plan with custom countertops/cabinets, smart wiring, state of the art lighting, an EV charging station, cooled/heated garage, and generator for the entire home. The first level has high ceilings and expansive windows offering plenty of natural light! It also boasts a chef\'s kitchen with a massive walk-in pantry, wine storage room, flex room and catering kitchen. All bedrooms are on the second floor. The large primary suite has 2 walk in closets and spacious bath. The back yard offers over 700sf covered patio space and custom landscaping! Ask the builder about the pool and pool house/mother in law suite option! Currently there’s a renovated ranch style home with 4 bedrooms/2 baths on the lot. Earn rental income as you finalize plans! Schedule a meeting with the builder today!' ,`Acres` = '0.2162' ,`Area` = '17' ,`BuilderName` = 'Builder 44' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bellaire Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 28 BLK 8 RICHMOND PLAZA' ,`LotDesciption` = 'Corner' ,`LotSize` = '9418' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CONDIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Richmond Plaza' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675218187' WHERE `Matrix_Unique_ID` = '212980954' --> 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','215602488','1675218188','215602488','2023-01-23T21:23:59.670','63180879','Ty Robinson','Nan & Company PropertiesChristie\'s International R','','','29.674540','-95.353083','37','77033','3','198900.00','Active','Edfield','4815','Street','Houston','2','0','3','1482','Single-Family','Nicely updated 3/2 with tile floors, spacious kitchen, tankless hot water heater, & large front and back yards with new fence. Come check out this kitchen with custom title, cabinets and new windows! All new electrical and new pex plumbing. \r\n\r\n Close to 610 Loop and the Medical Center. Investors welcome!','0.1439','3','','','','','Sellers Disclosure','1','','','Medical Center South','Central Electric','0','W 32 FT OF LT 19 & E 25 FT OF LT 20 BLK 5 EAST SUNNYSIDE COU','Cleared,Subdivision Lot','6270','Appraisal District','','','0','','0','','0','','','','','Composition','27 - Houston','BASTIAN ELEMENTARY SCHOOL','WORTHING HIGH SCHOOL','ATTUCKS MIDDLE SCHOOL','Appointment Required,Request Online Appointment,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','East Sunnyside Court Sec 03','3350','2.3307','Public Sewer,Public Water','1955','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','216120556','1675218188','216120556','2023-01-23T21:01:41.323','36850746','Angelica Davis','RE/MAX 5 Star Realty','','','29.520682','-95.011536','27','77573','3','385000.00','Active','Lorca','4813','Lane','League City','2','0','3','1992','Single-Family','Immaculate 3 BR , 2 Bath ,2 car garage 1 story ~Shows like new- Nestled in in Mar Bella. As you walk through the front doors to the entry you will notice the beautiful tile floors,high ceilings throughout. The private study has double french doors~House features split floor plan~fire place ~Gourmet kitchen~ oversized island open to the living area with lots of cabinet space ~ Stainless Steel Appliances~Recessed Lighting ~ Tile Backsplash~ Primary bedroom is spacious ~Master Bath with Garden Tub~ Tile Surround~ Standup Shower~Oversized Closet with access to the utility room! The Guest bedrooms have a large secondary bathroom~ Neutral Colors throughout~ Covered patio ~ Perfect for entertaining~\r\nHouse is in a great location with easy access to 518 & 146~HEB and many amenities nearby','0.148','33','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','League City','Central Gas','1','MAR BELLA SEC 16-A (2015) ABST 32, BLOCK 1, LOT 7, ACRES 0.1','Subdivision Lot','6446','Appraisal District','','1060','0','','2','Gas Oven','0','','','Gas Range','','Composition','9 - Clear Creek','SANDRA MOSSMAN ELEMENTARY SCHOOL','CLEAR FALLS HIGH SCHOOL','BAYSIDE INTERMEDIATE SCHOOL','Appointment Required','Appraisal','1','Traditional','Mar Bella Sec 16-A','8464','2.5762','Public Sewer,Public Water','2015','Appraisal'); --> 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','216346554','1675218188','216346554','2023-01-23T21:44:40.973','85711258','John Cantu','Teifke Real Estate','','','29.862014','-95.195641','18','77044','3','258000.00','Active','Montane Manor','13255','Lane','Houston','2','1','3','1840','Single-Family','Come see this beautiful 2018 build ready to welcome a new family! This is the perfect home for hosting or hanging out with the family as it offers an open floor-plan that connects the kitchen to the living room so that you can cook and not miss out on any entertainment. All the bedrooms are upstairs with plenty of linen and closet space. The attic offers great additional storage space to help keep your home clean and organized. The backyard is the perfect size for grilling or hosting with plenty of space for patio furniture. The neighborhood is friendly and the drive is not far from shopping and groceries. This is YOUR HOME!','0.095','2','','','','','Mud','','','','North Channel','Central Gas','1','LT 25 BLK 1 HIDDEN MEADOW SEC 8','Subdivision Lot','4140','Appraisal District','','450','0','','2','','0','','','','','Composition','46 - Sheldon','CARROLL ELEMENTARY SCHOOL (SHELDON)','CE KING HIGH SCHOOL','MICHAEL R. NULL MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','2','Traditional','Hidden Mdw Sec 8','6300','3.0293','Public Sewer,Public Water','2018','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','216350480','1675218188','216350480','2023-01-23T22:50:30.970','76109511','Yvonne Duell','Bing Daniel Realty','Susan Salinger','Compass RE Texas, LLC','30.124995','-95.459495','43','77380','9','369900.00','Option Pending','Songful Woods','122','Place','The Woodlands','2','1','4','2417','Single-Family','This great family home is vacant and ready for a new family. Very private oversized lot backs to greenbelt with extensive hardwood trees. Perfect location with easy access to I45. Large Picture windows to enjoy the tranquility of the lovely property. Enter this light bright home with study on right and dining room on left. Past the winding staircase to the extensive living room and the open kitchen 1/2 bath and large laundry room. Large master & 3 further bedrooms up','0.2287','15','Emerald','','Electric Dryer Connections','','Mud,Owner/Agent','1','Gas Connections,Gaslog Fireplace,Mock Fireplace','1','The Woodlands','Central Gas,Zoned','1','WDLNDS VIL GROGANS ML 65, BLOCK 3, LOT 27','Cul-De-Sac,In Golf Course Community,Subdivision Lot,Wooded','10089','Appraisal District','','','0','','2','Electric Oven,Single Oven','0','','','Electric Range','','Composition','11 - Conroe','SAM HAILEY ELEMENTARY SCHOOL','THE WOODLANDS COLLEGE PARK HIGH SCHOOL','KNOX JUNIOR HIGH SCHOOL','Lockbox Front,No Supra Keybox,Vacant/Unoccupied','Appraisal District','2','Split Level','Wdlnds Village Grogans Ml 65','7325','2.1816','Public Sewer,Public Water,Water District','1994','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','216443916','1675218188','216443916','2023-01-23T22:10:32.867','82095865','Jackie Greer','Berkshire Hathaway HomeService','','','29.299659','-94.925818','38','77554','7','629900.00','Active','Tiki','1850','Drive','Tiki Island','2','0','3','1490','Single-Family','Beautiful Tiki 3 bedroom, 2 bath home with double jet ski lift & boat lift with easy access, swim dock, cedar bar & large area down for entertaining. Kitchen remodeled with SS appliances, custom soft close cabinets, Quartz countertops, tile backsplash. Roof replaced in 2020, HVAC system, water heater, underwater fishing light replaced 2018/ bulb 2022, 25 year vinyl bulkhead in 2016, top & bottom decking replaced 2016. Extra large upper deck great overflow for inside entertaining. Open concept with living, dining & kitchen. Large TV in living room, washer/dryer, both refrigerators up & down, cedar bar & golf cart convey with closing. Great home for fulltime or weekend living. Should be room for a small pool!! This is a must see make your appointment today!!','0.113','33','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Tiki Island','Central Electric','1','ABST 7 S C BUNDICK SUR LOT 62 TIKI ISLAND SEC 10','Cul-De-Sac,Subdivision Lot,Water View,Waterfront','4922','Appraisal District','','100','0','','0','Electric Oven,Freestanding Oven,Single Oven','0','','','Electric Cooktop,Electric Range,Freestanding Range','','Composition','26 - Hitchcock','HITCHCOCK PRIMARY/STEWART ELEMENTARY SCHOOL','HITCHCOCK HIGH SCHOOL','CROSBY MIDDLE SCHOOL (HITCHCOCK)','Appointment Required,Leave Business Card,Lockbox Right Side,Supra Keybox','Appraisal','1.5','Other Style','Tiki Island','9435','2.5058','Water District','1982','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','216474118','1675218188','216474118','2023-01-23T21:52:32.643','35581610','Reyna Portillo','Realty Associates','','','29.588592','-95.234348','20','77089','4','310000.00','Active','Sageyork','10826','Drive','Houston','2','0','4','2005','Single-Family','Home has easy access to freeway close to schools, parks, hospital and shopping center. This home has 4 bedrooms and 2 full baths. Each Room have walk in closets. Home has smoke and carbon monoxide detectors. Granite countertops and a very good size food pantry. Covered Patio and fenced backyard.','0.1716','3','','','','','Mud,Sellers Disclosure','1','','','Southbelt/Ellington','Central Gas','1','LT 7 BLK 5 SAGEMEADOW SEC 1','Subdivision Lot','7475','Appraisal District','','175','0','','2','','0','','','','','Composition','41 - Pasadena','FRAZIER ELEMENTARY SCHOOL (PASADENA)','DOBIE HIGH SCHOOL','THOMPSON INTERMEDIATE SCHOOL','Accompany,Appointment Required,Lockbox Front','Appraisal District','2','Other Style','Sagemeadow Sec 01','5802','2.6355','Water District','1972','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','216583761','1675218188','216583761','2023-01-23T22:35:37.363','47705588','Kitten Leopold','Leopold & Strahan Realty Group','Corey Toms','Priority One Real Estate','29.386811','-94.993377','24','77591','5','249900.00','Option Pending','Nightingale','7405','Circle','Texas City','2','0','3','1301','Single-Family','Amazing 3 Bedroom 2 Bath tastefully remodeled with ALL the bells and whistles! This home has it all. New HVAC, New Roof, New Electrical & New Interior Plumbing. Spacious kitchen with new appliances, new cabinetry, granite countertops and an island with a separate breakfast bar. Recessed lighting and new flooring. Both bathrooms boast glass enclosed showers with exquisite new tile. Fenced in backyard. Schedule your showing today! Room measurements are approximate.','0.147','33','','','Washer Connections','','Sellers Disclosure','1','','','Texas City','Central Gas','0','ABST 2 PAGE 3 W 61 FT OF LOT 108 (108-1) BLK 7 SOUTH ACRE MA','Subdivision Lot','6405','Appraisal District','','','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','52 - Texas City','SIMMS ELEMENTARY SCHOOL (TEXAS CITY)','LA MARQUE HIGH SCHOOL (TEXAS CITY)','LA MARQUE MIDDLE SCHOOL','Lockbox Back','Appraisal District','1','Contemporary/Modern,Traditional','South Acre Manor 4','2865','2.491','Public Sewer,Public Water','1981','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','216587733','1675218188','216587733','2023-01-23T21:32:18.310','57544811','Luis Perret','Prime Realty Group','','','30.099937','-94.936757','38','77535','3','375000.00','Active','Fm 686','1031','','Dayton','2','0','3','1150','Single-Family','Nearly 15 acres of land that would be a great pasture for a small farm. There is a small pond located on property. Multiple sheds and a home built on stilts. Huge porch to enjoy nice evenings. Home consists of 2 detached buildings, 1 has a full bath/kitchen/living and a bedroom. Second building consists of 2 bedrooms and a full bath. Home has been sitting vacant for a while so will need updating and repairs.','14.4946','52','','','','','No Disclosures','','','','Dayton','Window Unit','0','000285 IG&N-9, TRACT 25 (Q-14), ACRES 9.98','Cleared','631184','Appraisal District','','','0','','0','','0','','','','','Aluminum','74 - Dayton','STEPHEN F. AUSTIN ELEMENTARY SCHOOL (DAYTON)','DAYTON HIGH SCHOOL','WOODROW WILSON JUNIOR HIGH SCHOOL','Lockbox Front','Seller','1','Other Style','Ig&N-9','8330','2.3761','No Water,Septic Tank','2011','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','216665489','1675218188','216665489','2023-01-23T21:13:28.297','55238926','Teri Walter','K. Hovnanian of Houston II, LL','','','29.655080','-95.117823','21','77505','13','528329.00','Active','Fairfield','5550','Lane','Pasadena','3','0','4','2931','Single-Family','Charming one-story Margaret home with 4 bedrooms, 3 baths and 3 car tandem garage on a corner lot. Elegant dining room tucked off foyer with easy access to gourmet kitchen. Beautiful maple cabinets, quartz countertops and farmhouse sink in kitchen. Cozy box mantel fireplace with crown and tile surrounds in great room. Owner\'s suite features a versatile sitting room. Huge walk-in closet, dual vanity sinks, separate tub and shower in owner\'s bath. Double sinks in hall bath. Enjoy your evening relaxing on your covered patio. Offered by: K. Hovnanian Houston Parkway Trails, LLC.','','7','K. Hovnanian','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','Gaslog Fireplace','1','Pasadena','Central Gas','1','11/2/4','Corner,Subdivision Lot','','Survey','','900','1','Never Lived In','3','Gas Oven','0','','','Freestanding Range,Gas Cooktop','','Composition','16 - Deer Park','JP DABBS ELEMENTARY SCHOOL','DEER PARK HIGH SCHOOL','FAIRMONT JUNIOR HIGH SCHOOL','Accompany,Appointment Required','Builder','1','Traditional','Parkway Trails','','2.470865','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','216682344','1675218188','216682344','2023-01-23T21:29:22.287','16930974','Christopher Almaraz','eXp Realty, LLC','','','30.159702','-95.085424','11','77327','3','254990.00','Active','Road 51024','55','','Cleveland','2','0','3','1321','Single-Family','Welcome home to The Bungalow Floor Plan a Casas-Houston new construction home. This 3 bedroom 2 bath home features 9\' ceilings with open concept kitchen, family and dinning area. The kitchen cabinets boast crown molding and granite counter tops with under cabinet lighting. The Bungalow comes loaded with energy features such as a 16-SHEER HVAC system, Low-E windows, blown insulation and much more. Double wide driveway plus a two car garage makes it easy to store your weekend toys for example bikes, motorcycles, wave runners and so much more. Take advantage of the low tax rate at 1.99 and low POA with brand new schools and a Splash Pad. Appliance package includes Refrigerator, dishwasher, microwave and stove black on stainless steel. Schedule your tour today!','','52','Morris Homes LLC','','','','Other Disclosures','1','','','Cleveland Area','Central Gas','1','SANTA FE, SEC 3, BLOCK 50, LOT 6434, ACRES 0.1600','Subdivision Lot','6969','Appraisal District','','','1','Never Lived In','2','Gas Oven','0','','','','','Composition','100 - Cleveland','COTTONWOOD SCHOOL (CLEVELAND)','CLEVELAND HIGH SCHOOL','CLEVELAND MIDDLE SCHOOL','Appointment Required','Builder','1','Traditional','Santa Fe','','','Public Sewer','2022','Builder'); --> New record created successfully