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-07T15:26:39.253' ,`MLSNumber` = '51743185' ,`ListAgentFullName` = 'Jocellyn Camarillo' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.989994' ,`Longitude` = '-95.537667' ,`PhotoCount` = '50' ,`PostalCode` = '77069' ,`RoomCount` = '28' ,`ListPrice` = '8000000.00' ,`Status` = 'Active' ,`StreetName` = 'Champions' ,`StreetNumber` = '14525' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '9' ,`BathsHalf` = '9' ,`BedsTotal` = '7' ,`SqFtTotal` = '37132' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Magnificent 37,000+ square foot, 7+ acres of land, French inspired estate property is tucked away in a forested corner of Northwest Houston. It sits in a private, gated property, caddy corner to the Champions Country Club and Golf Course of North Houston. The grand entrance welcomes visitors, accommodating nearly 1000 guests, with historical statues, gorgeous gardens, and elegantly designed architecture, such as glorious European imported antique fixtures and Italian hand-painted murals. The decadent marble floors will lead you to 2 ballrooms that can host up to 750 guests for a seated dinner, stunning stairwells, a billiard room and 7 private suites, one of which is 1,200 square feet. Originally built as a single family residence it also comes with a highly appointed chef’s kitchen offers everything needed to throw extravagant dinner parties with ample parking for all, with a circular driveway around a majestic Italian imported fountain, for easy valet service. Welcome to brilliance!' ,`Acres` = '7.28' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '10' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 32B 32C & 32D PT ABANDONED CAMPTOWN CIR COMMON AREA A-1' ,`LotDesciption` = 'Cul-De-Sac,Ravine,Wooded' ,`LotSize` = '317117' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '5' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'YEAGER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '3' ,`Style` = 'French' ,`Subdivision` = 'Champions' ,`TaxAmount` = '192689' ,`TaxRate` = '2.5156' ,`WaterSewer` = 'Water District,Well' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675106094' WHERE `Matrix_Unique_ID` = '205895874' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-07T16:46:14.667' ,`MLSNumber` = '17368205' ,`ListAgentFullName` = 'Phyllis Orman' ,`ListOfficeName` = 'Real Estate Connection Int' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.957982' ,`Longitude` = '-95.272556' ,`PhotoCount` = '36' ,`PostalCode` = '77396' ,`RoomCount` = '13' ,`ListPrice` = '384900.00' ,`Status` = 'Active' ,`StreetName` = 'Oriole Lane' ,`StreetNumber` = '7702' ,`StreetSuffix` = '' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3204' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful two story home (3204 sq ft) is move in ready. The home features 4 bedrooms with 2.5 bath, dining room, study/office and upstairs game room. Open concept kitchen to family room with fireplace. Separate large dining room and private study/office downstairs located in front of home. Utility room downstairs. Beautiful tile flooring throughout down stairs and wood flooring upstairs. Primary bedroom is located off the living area with a large walk in closet, garden tub and shower. Upstairs finds kids retreat with 3 comfortable bedrooms with large windows for natural light and large game/ media room. Backyard has extended patio with added storage. Lot next to home is not included, but is available for additional purchase. Great location in Humble and No HOA. This property has easy access to shopping, restaurants, and Bush Intercontinental Airport. This home is a must see!!' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Humble Area East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 5 TIMBERWOOD SEC 9' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'JACK M. FIELDS SR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'ROSS STERLING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Timberwood' ,`TaxAmount` = '' ,`TaxRate` = '2.2965' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675106094' WHERE `Matrix_Unique_ID` = '210432080' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-07T16:44:24.800' ,`MLSNumber` = '75218125' ,`ListAgentFullName` = 'Yue Mao' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.769351' ,`Longitude` = '-95.757561' ,`PhotoCount` = '17' ,`PostalCode` = '77450' ,`RoomCount` = '4' ,`ListPrice` = '246500.00' ,`Status` = 'Active' ,`StreetName` = 'Red Rock Canyon' ,`StreetNumber` = '814' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1616' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The house is being remodeled currently. No showings. Welcome to Cimarron at Katy!! This house features a great flowing floor plan, open concept kitchen, wood flooring in living room. Step outside and enjoy a great open view in your good sized back yard. Zoned to Katy ISD, minutes from Hwy 99 and I-10. House has great bones. It\'s waiting for your personal touch. The possibility is endless. A great value for Cimarron and the area.... don\'t miss it! AC warranty attached. With some TLC, this house will shine. Room sizes are approximate, please verify on your own.' ,`Acres` = '0.1763' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 15 CIMARRON SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7680' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '462' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CIMARRON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'WEST MEMORIAL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cimarron' ,`TaxAmount` = '4134' ,`TaxRate` = '2.3283' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675106094' WHERE `Matrix_Unique_ID` = '210621709' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-07T15:42:44.023' ,`MLSNumber` = '40295760' ,`ListAgentFullName` = 'Cesar Ramirez' ,`ListOfficeName` = 'Vylla Home' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.932336' ,`Longitude` = '-95.277699' ,`PhotoCount` = '35' ,`PostalCode` = '77396' ,`RoomCount` = '4' ,`ListPrice` = '324900.00' ,`Status` = 'Active' ,`StreetName` = 'Fall Creek' ,`StreetNumber` = '7331' ,`StreetSuffix` = 'Bend' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2451' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming home boasts great curb appeal, large living room with fireplace and vaulted ceilings, spacious eat in kitchen with plenty of counter and cabinet space, big master bedroom with ensuite bathroom and walk in closet. Located in the desirable Fall Creek neighborhood and zoned to Humble ISD, this home won\'t last long!' ,`Acres` = '0.1584' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fall Creek Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 3 FALL CREEK SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1090' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'FALL CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fall Creek Sec 05' ,`TaxAmount` = '8059' ,`TaxRate` = '2.9973' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675106095' WHERE `Matrix_Unique_ID` = '211617991' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-07T15:35:58.730' ,`MLSNumber` = '64675020' ,`ListAgentFullName` = 'Cesar Ramirez' ,`ListOfficeName` = 'Vylla Home' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.502618' ,`Longitude` = '-95.398674' ,`PhotoCount` = '24' ,`PostalCode` = '77578' ,`RoomCount` = '8' ,`ListPrice` = '294900.00' ,`Status` = 'Active' ,`StreetName` = 'Rodeo' ,`StreetNumber` = '72' ,`StreetSuffix` = 'Drive' ,`City` = 'Manvel' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1995' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Open House Saturday and Sunday 11-1pm. Come take a personal tour of this 3 bedroom 2 bathroom home with a formal dining and flex room that can be a study or converted to 4th bedroom. Open the door and notice a high skylight in the foyer, nest thermostat, split floorplan with master bedroom on opposite side of home. Includes appliances, fridge, samsung washer and dryer. Features open kitchen with large island and large living are with fireplace. Nice size patio with fenced backyard. Garage is extended with workshop and water and sink as well. Neighborhood lakes and pool within walking distance.' ,`Acres` = '0.1749' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RODEO PALMS, PALM COURT SEC 1 (A0459 & A0299)(MANVEL) BLK 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7619' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'DON JETER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Rodeo Palms, Palm Court Sec 1' ,`TaxAmount` = '8308' ,`TaxRate` = '3.6694' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675106095' WHERE `Matrix_Unique_ID` = '211953328' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-07T16:09:01.747' ,`MLSNumber` = '22218537' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Newmark Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.944109' ,`Longitude` = '-95.690508' ,`PhotoCount` = '16' ,`PostalCode` = '77433' ,`RoomCount` = '10' ,`ListPrice` = '1396043.00' ,`Status` = 'Active' ,`StreetName` = 'San Gabriel Glen' ,`StreetNumber` = '18018' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4902' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The MESSINA is the perfect home for the family that loves entertaining and the recreational lifestyle of Towne Lake! You\'ll have the best of both worlds in this home that is situated on a lake lot in the gated section of Marina Bay in Towne Lake. This is one of the very last opportunities to build or buy new on the main lake. The homesite is approved for a boat dock as well! As you enter the home you\'ll be delighted with the open floor plan, high ceilings and lake views right outside the windows. There is a media room on the main floor! The kitchen will feature double ovens, a 36\" cooktop and stylish floating shelves on the cooktop wall. The utility room is outfitted with cabinets and a sink, and the mud room space will have a built-in mud bench! Upstairs off the game room there is a balcony with birdseye views of the lake and Marina Bay park! This is a must see home. There is still time to personalize if you act fast!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Newmark Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 05 Block 01' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '10531' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1699' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`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` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'French,Other Style,Traditional' ,`Subdivision` = 'Towne Lake' ,`TaxAmount` = '' ,`TaxRate` = '3.47' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675106095' WHERE `Matrix_Unique_ID` = '213990830' --> 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','215453024','1675106095','215453024','2023-01-07T16:27:23.263','86310819','Shannon Lester','BHGRE Gary Greene','','','30.196840','-95.768754','45','77355','9','799000.00','Active','Abney','509','Lane','Magnolia','3','0','4','3298','Single-Family','FULLY RENOVATED 4 ACRE HORSE FARM IN THE COUNTRY! Amenities include 4 stall horse barn with wash bay, 30x70 covered shop area, and new heated pool and spa (2021).Complete home Renovation includes custom mill work, custom cabinets throughout , new paint interior/exterior, custom built LED fireplace, gated entry, 2 tankless hot water heaters, custom ordered 48\" range in kitchen, all new carpet and lighting fixtures. This Magnolia home is in the country but so close to medical facilities and The Woodlands retail and restaurants. Gated entrance. 75x40 metal covered parking area for boats, RVs, cars or equipment. Inside the home you will find an amazing kitchen with an 8 burner gas range with 2 ovens. Custom cabinetry, quartz counter tops, backsplash, new dishwasher and microwave. Fantastic game room/media room is great for entertaining. Three bathrooms and 4 bedrooms are completely updated. An additional adjoining 2.3 acres is also available for separate purchase.','4.285','15','','','Washer Connections','','Sellers Disclosure','1','Freestanding','1','Magnolia/1488 West','Central Electric','0','A0613 - WARD CYRUS, TRACT 6, ACRES 6.52','Cleared,Wooded','186655','Survey','','','0','','0','Gas Oven','1','Heated,In Ground','','Gas Range','','Composition','36 - Magnolia','WILLIE E. WILLIAMS ELEMENTARY SCHOOL','MAGNOLIA WEST HIGH SCHOOL','MAGNOLIA JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Seller','1','Traditional','N/A','13228','1.8587','Septic Tank,Well','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','215538108','1675106095','215538108','2023-01-07T16:11:37.727','78499490','Sheila Craniotis','Redfin Corporation','','','29.827336','-95.283372','17','77028','6','175000.00','Active','Safebuy','7925','Street','Houston','2','0','4','1311','Single-Family','Own a spacious 4B/2B home with one large residential lot in an unrestricted rapidly growing area of Houston. All the major mechanicals recently upgraded, new electrical, PEX plumbing, leveled P&B, newer roof. Great starter home or investment property in a quiet neighborhood. No carpet, redistribution of the floor plan since purchase. Wall units are included, Washer, dryer and fridge can also be included. Tax record reflects two lots 8 & 9, however the properties are being spilt and sold as two separate residence per the seller. The driveway, garage and 2B/1B property to the right of subject property is also being renovated for sale should your buyer be interested. Close to 610 and Hwy 59 with in minutes to Downtown, the Heights or Bush Airport.','0.1102','2','','','Electric Dryer Connections,Washer Connections','','Other Disclosures,Sellers Disclosure','0','','','Northeast Houston','Other Heating,Window Unit','0','LTS 8 & 9 BLK 1 LIBERTY ROAD MANOR SEC 22 U/R','Subdivision Lot','4800','Appraisal District','','','0','','0','Freestanding Oven','0','','','Electric Range','','Composition','27 - Houston','ELMORE ELEMENTARY SCHOOL','KASHMERE HIGH SCHOOL','KEY MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Colonial','Liberty Road Manor Sec 22 U/R','1091','2.3307','Public Sewer,Public Water','1952','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','215560308','1675106095','215560308','2023-01-07T15:55:45.217','16790866','David Atkins','Martha Turner Sotheby\'s International Realty','','','29.734665','-95.329683','34','77023','5','279000.00','Active','Dumble','1508','Street','Houston','1','0','1','623','Single-Family','In this town, the word y\'all we exclaim proudly and never mumble. Where we lend a helping hand, if we see someone fall from a stumble. In the Eado bars they pour mead from bees that bumble. And have numerous bakeries that serve cookies that crumble. Stroll over to a music venue where the baseline will rumble. Or walk to the football stadium, where they score goals and do not fumble. With all of these amenities, why sit in frustrating traffic that makes you grumble? When you can live in the heart of Eado on a street called Dumble.','0.044','4','Refuge Development','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','0','East End Revitalized','Central Electric','0','LT 2 BLK 1 TRAJAN ESTATES','Patio Lot','1915','Appraisal District','','','0','','0','Electric Oven,Freestanding Oven','0','','','Electric Range,Freestanding Range','','Aluminum','27 - Houston','CAGE ELEMENTARY SCHOOL','AUSTIN HIGH SCHOOL (HOUSTON)','NAVARRO MIDDLE SCHOOL (HOUSTON)','Appointment Required,Lockbox Front','Builder','1','Contemporary/Modern','Trajan Estates','1444','2.6764','Public Sewer,Public Water','2018','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','215560918','1675106095','215560918','2023-01-07T15:55:26.670','16406433','David Atkins','Martha Turner Sotheby\'s International Realty','','','29.734657','-95.329686','41','77023','6','299000.00','Active','Dumble','1510','Street','Houston','1','0','2','800','Single-Family','In this town, the word y\'all we exclaim proudly and never mumble. Where we lend a helping hand, if we see someone fall from a stumble. In the Eado bars they pour mead from bees that bumble. And have numerous bakeries that serve cookies that crumble. Stroll over to a music venue where the baseline will rumble. Or walk to the football stadium, where they score goals and do not fumble. With all of these amenities, why sit in frustrating traffic that makes you grumble? When you can live in the heart of Eado on a street called Dumble.','0.0553','4','Refuge Development','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','0','East End Revitalized','Central Electric','0','LT 1 BLK 1 TRAJAN ESTATES','Subdivision Lot','2408','Appraisal District','','','0','','0','Electric Oven,Freestanding Oven','0','','','Electric Range,Freestanding Range','','Aluminum','27 - Houston','CAGE ELEMENTARY SCHOOL','AUSTIN HIGH SCHOOL (HOUSTON)','NAVARRO MIDDLE SCHOOL (HOUSTON)','Appointment Required,Lockbox Front','Builder','2','Contemporary/Modern','Trajan Estates','3955','2.3307','Public Sewer','2019','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','215668201','1675106096','215668201','2023-01-07T16:03:12.970','12652215','Jackie Crawford','RE/MAX Associates Northeast','','','30.014139','-95.318840','0','77338','6','190000.00','Active','Fox Knoll','7011','Lane','Humble','2','0','3','1685','Single-Family','THIS AN ESTATE PROPERTY, SO THERE ARE NO SELLERS DISCLOSURES. IT IS A GREAT HOUSE IN A VERY CONVENIENT LOCATION AND IS ABLE TO BE LIVED IN, JUST NEEDS SOME UPDATES. IT IS A ONE STORY SPANISH STYLE HOME FEATURING 3 BEDROOMS AN 2 BATHS. THE BACK YARD IS FULLY FENCED, ONE SIDE IS NEWER AND IS VERY PRIVATE. IT HAS A GREAT COVERED PATIO. IF YOU LIKE TO ENJOY THE OUTSIDE, BUT YET BE PRIVATE, THIS IS A PROPERTY YOU SHOULD SEE. IT IS CLOSE TO THE GRAMMAR SCHOOL, PARK WITH SWIMMING POOL. IT IS CLOSE TO SHOPPING, HIGHWAY 45 AND ACCESS TO THE TOLL ROAD. COME AND SEE FOR YOURSELF. START YOUR FAMILY MEMORIES HERE! !','0.1584','12','N/A','','Electric Dryer Connections,Washer Connections','','Estate,No Disclosures,Probate','1','Wood Burning Fireplace','1','Humble Area West','Central Gas','1','LT 21 BLK 3 FOXWOOD SEC 2','Cleared,Subdivision Lot','6900','Appraisal District','','325','0','','2','Electric Oven','0','','','Electric Range','','Composition','1 - Aldine','CYPRESSWOOD ELEMENTARY SCHOOL (ALDINE)','NIMITZ HIGH SCHOOL (ALDINE)','JONES MIDDLE SCHOOL (ALDINE)','Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Ranch','Foxwood','4441','2.7734','Water District','1977','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','215764392','1675106096','215764392','2023-01-07T16:52:09.493','45842894','Michelle Doss','Mega Realty','','','28.977548','-95.566302','29','77422','7','892400.00','Active','Riverview Ranch','1135','Drive','Brazoria','3','1','3','2838','Single-Family','Put this home on your “must see” list, an HOA subdivision on the San Bernard River.This impeccably maintained home is being offered, boasts a tall open concept floor plan with soaring knotty pine ceilings.The floor plan is ideal for entertaining.The San Bernard River will for sure meet all your boating expectations.Lauch your vessel from your private boathouse with a click of a switch. Relax in your own personal oasis of the many amenities that are included with this home. RRE also has it’s own private boat ramp for all owners. Contact Michelle for more info on this spectacular home.This real estate won’t last long!','1.09','5','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','West of the Brazos','Central Electric','1','RIVERVIEW RANCH ESTATES SEC 1 (A0041 T B BELL) BLK 1 LOT 12','Water View,Waterfront','47478','Appraisal District','','36','0','','7','Electric Oven','1','Fiberglass','','','','Composition','51 - Sweeny','SWEENY ELEMENTARY SCHOOL','SWEENY HIGH SCHOOL','SWEENY JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Lockbox Front','Appraisal District','2','Traditional','SSW RIVER','','','Septic Tank,Well','1995','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','215789713','1675106096','215789713','2023-01-07T15:26:35.790','45871059','Victor Varela','eXp Realty, LLC','Victor Varela','eXp Realty, LLC','29.667583','-95.080143','24','77571','3','264000.00','Pending Continue to Show','Stone Creek Dr','5422','Drive','La Porte','2','0','3','1634','Single-Family','Minutes from Beltway 8 this property is a must see. Updated with new floors, and paint this property also features a one of kind pool designed to host large parties. The exterior of the property was updated with new hardy board and trim to include a new front door. Roof is within 5 years old with new duct work throughout the attic space. The AC/Furnace is 4 months old. This is a first-time homebuyer\'s dream. With the low tax rate and access to the local schools within minutes this property will not last long. Consult with our in-house lender to get your pre-approval within minutes.','0.154','7','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','1','La Porte/Shoreacres','Central Gas','0','LT 18 BLK 2 CREEKMONT SEC 1','Subdivision Lot','6710','Appraisal District','','','0','','2','Convection Oven','1','Gunite','','Gas Range','','Composition','35 - La Porte','JENNIE REID ELEMENTARY SCHOOL','LA PORTE HIGH SCHOOL','LOMAX JUNIOR HIGH SCHOOL','Lockbox Front','Appraisal District','1','Contemporary/Modern,Ranch','Creekmont','5912','2.7208','Public Water','1983','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','215873298','1675106096','215873298','2023-01-07T15:10:18.790','41573904','Hung Nguyen','The Nguyens & Associates','','','29.710503','-95.579414','13','77072','6','310000.00','Active','Bugle','4331','Road','Houston','3','0','4','2155','Single-Family','Location ! Location ! Location ! In the heart of Asian Town. Extensive upgrade....better than NEW. Updated home with great floor plan, designed perfectly for entertaining. Granite counter top, ceramic tile floors. Grand entry, high ceiling. RECENT ROOF, SIDING, APPLIANCES, DRIVE WAY, AC, WATER HEATER, LIGHTINGs....and more. Desired location, in the heart of Asian Town. This is a must see home waiting to be yours. Ready to move in. Walking distance to Bellaire & Boone. HongKong Market 4, Lee Sandwich.....Rests, Schools....','0.1216','28','','','Electric Dryer Connections,Washer Connections','','Owner/Agent,Sellers Disclosure','1','Wood Burning Fireplace','1','Alief','Central Gas','1','LT 8 BLK 1 BRAYS VILLAGE SEC 2 R/P','Subdivision Lot','5298','Appraisal District','','299','0','','0','','0','','','Electric Cooktop,Electric Range','','Composition','2 - Alief','CHANCELLOR ELEMENTARY SCHOOL','AISD DRAW','ALIEF MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Brays Village Sec 02 R/P','4535','2.4411','Public Sewer,Public Water','1976','Seller'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216002754','1675106096','216002754','2023-01-07T15:00:17.973','32210898','Sammy Younis','RE/MAX Southwest','','','29.545797','-95.576307','50','77479','16','2798880.00','Active','Sunset Park','32','Lane','Sugar Land','6','1','6','6448','Single-Family','MAJESTIC is not enough to describe this WATERFRONT stucco estate with tile roof!This home embodies exquisite design &luxury with a tech-savvy flair. Seller spared no expense.Dramatic first impression as you enter,stunning double drs,gracefully curved staircase,elegant formal dining w/ custom temp.controlled wine display.Breathtaking open concept w/endless panoramic waterviews. Striking primary retreat,come home &unwind in your opulent ensuite bath w/soaking tub,Kohler lux rain shower system, custom California closets.Gourmet island kitchen features new cabinetry &high-end appliances,overlooking the designer family rm.No details overlooked &only the highest quality materials used. Lustrous chandeliers ,TWO bedrms down,handsome study, game room w/wet bar, 2nd primary room up w/ensuite & balcony.Watch Hollywood hits in your theater or enjoy a moonlight evening in your infinity pool, covered veranda w/outdoor kitchen & fireplace, overlooking the lake!Call the Aida Younis Team today.','0.3935','29','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace,Wood Burning Fireplace','2','Sugar Land South','Central Gas,Zoned','1','HARTFORD LANDING AT RIVERSTONE, BLOCK 1, LOT 11','Waterfront','17141','Appraisal District','','1870','0','','4','Convection Oven,Double Oven','1','Heated,In Ground','','Gas Cooktop','','Tile','19 - Fort Bend','SULLIVAN ELEMENTARY SCHOOL','ELKINS HIGH SCHOOL','FIRST COLONY MIDDLE SCHOOL','Accompany,Appointment Required','Builder','2','Contemporary/Modern,Mediterranean','Riverstone','35910','2.3554','Water District','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','216097635','1675106096','216097635','2023-01-07T16:15:58.957','89312915','Isaac Hernandez','eXp Realty, LLC','','','30.017343','-95.304315','29','77338','3','224900.00','Active','Neva','20910','Court','Humble','2','1','3','1996','Single-Family','Great two story home in a peaceful mature neighborhood. This home is located at the end of a dead end street, Therefore traffic is minimal. Bring your dogs to this big back yard. Minutes away from shopping centers, Restaurants, Stores. Come and take a tour before it\'s gone.','0.1211','12','','','','','Sellers Disclosure','','','1','Humble Area West','Central Gas','1','LT 48 BLK 2 KENSWICK GLEN','Cleared','5273','Appraisal District','','270','0','','2','','0','','','','','Composition','1 - Aldine','JONES ELEMENTARY SCHOOL (ALDINE)','NIMITZ HIGH SCHOOL (ALDINE)','JONES MIDDLE SCHOOL (ALDINE)','Appointment Required','Appraisal District','2','Traditional','Kenswick Glen','5871','2.7433','Public Sewer,Public Water','2004','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','216143992','1675106096','216143992','2023-01-07T15:31:36.033','49750838','Jimmy Franklin','Newmark Homes','','','30.135423','-95.311814','15','77365','8','502043.00','Active','Angels Landing Lane','7562','','Porter','3','0','4','2449','Single-Family','NEWMARK HOMES NEW CONSTRUCTION - UMBRIA - Welcome home to 7562 Angels Landing Lane located in the master planned community of The Highlands and zoned to New Caney ISD. This gorgeous home will feature 4 bedrooms, 3 full baths and an attached 3 car tandem garage. You don\'t want to miss all this gorgeous home will have to offer, estimated completion is April 2023! Schedule your showing today!','','40','Newmark Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Porter/New Caney West','Central Gas','1','060202','Subdivision Lot','6101','Survey','','1420','1','To Be Built/Under Construction','3','Double Oven','0','','','Gas Cooktop','','Composition','39 - New Caney','ROBERT CRIPPEN ELEMENTARY SCHOOL','PORTER HIGH SCHOOL (NEW CANEY)','WHITE OAK MIDDLE SCHOOL (NEW CANEY)','Accompany,Appointment Required,No Appointment Required','Builder','1','Contemporary/Modern','The Highlands','','3.38','Public Sewer,Public Water,Water District','2023','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','216167187','1675106096','216167187','2023-01-07T15:50:19.700','52310799','Justin Carswell','Carswell Real Estate Co. Inc.','','','30.165331','-95.709677','50','77355','6','949900.00','Active','Post Oak','36118','Circle','Magnolia','3','1','4','3396','Single-Family','Welcome Home to the highly sought after golf course community, High Meadow Ranch! This immaculate 4 bedroom, 3.5 bathroom is drenched in luxury. Enjoy entertaining your guests in the pristine kitchen that has an Ilve range, built in wine fridge and gorgeous Bardiglio marble countertops, that are also placed in the Primary bathroom with the custom mosaic designed marble floors. Exceptional construction, high end finishes, fixtures and incredible attention to detail. Updated and remodeled in 2022. This 2.26 acre property also has a 3 car garage with Epoxy flooring, AC unit and furnaces recently installed, two tankless water heaters and many more updates. Enjoy the High Meadow Ranch lifestyle at it\'s finest!','2.26','15','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Magnolia/1488 West','Central Gas','1','HIGH MEADOW RANCH 01, BLOCK 1, LOT 22, ACRES 2.26','Subdivision Lot,Wooded','98446','Appraisal District','','750','0','','3','','0','','','Gas Range','','Composition','36 - Magnolia','MAGNOLIA ELEMENTARY SCHOOL (MAGNOLIA)','MAGNOLIA WEST HIGH SCHOOL','MAGNOLIA JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','High Meadow Ranch','12645','1.8587','Aerobic,Public Water','1997','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','216175439','1675106096','216175439','2023-01-07T16:34:46.210','13639356','Ran Lu','K & L Realty LLC','','','29.529017','-95.728475','17','77469','8','317530.00','Active','Pickett Hill','919','Lane','Rosenberg','2','0','3','2256','Single-Family','New carpet for bedrooms and game room; 5 new ceiling fans, new 9\" kitchen sink and faucet; new faucets for bathrooms; new toilets; new wall painting; new epoxy floor for garage and backyard patio; granite countertop.','0.1452','30','','','','','HOA First Right of Refusal,Owner/Agent','1','','','Fort Bend South/Richmond','Central Gas','1','BONBROOK PLANTATION SOUTH SEC 2, BLOCK 1, LOT 8','Other','6325','Appraisal District','','700','0','','2','','0','','','','','Other','33 - Lamar Consolidated','CARTER ELEMENTARY SCHOOL','GEORGE RANCH HIGH SCHOOL','RYON/READING JUNIOR HIGH SCHOOL','Appointment Required,Vacant/Unoccupied','Appraisal District','1','Other Style','Bonbrook Plantation South Sec 2','7864','2.6948','Public Sewer,Public Water,Water District','2006','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','216176059','1675106096','216176059','2023-01-07T16:42:04.777','27955550','Lituany Polanco','Styled Real Estate','','','30.099989','-95.187184','12','77365','9','290000.00','Active','Rimini Landing Lane, porter','6008','','Porter','2','1','4','','Single-Family','New Lennar La Mirada model located in country Colony on a Corner Lot. These 4 bedrooms 2.5 bath has a spacious living area with a kitchen dining combo. Huge primary Bedroom with an En suite bathroom and 2 walk in closets. \r\nAwesome backyard','','40','','','','','Sellers Disclosure','','','','Porter/New Caney East','Central Gas','1','S349206, BLOCK 2 LOT 1','Corner','','','','700','0','','2','','0','','','','','Composition','39 - New Caney','PORTER ELEMENTARY SCHOOL (NEW CANEY)','NEW CANEY HIGH SCHOOL','NEW CANEY MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front','','2','Colonial','contry colony 06','','','Water District','2020','Appraisal District'); --> New record created successfully