Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-09T06:11:45.127' ,`MLSNumber` = '25108659' ,`ListAgentFullName` = 'Armando Espinosa Jr' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.797777' ,`Longitude` = '-95.384671' ,`PhotoCount` = '29' ,`PostalCode` = '77009' ,`RoomCount` = '7' ,`ListPrice` = '544000.00' ,`Status` = 'Active' ,`StreetName` = 'Michaux' ,`StreetNumber` = '4617' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1215' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A MUST SEE! Beautifully remodeled bungalow in the Norhill Historic District! From the perfectly updated front porch to the designer finishes, this home has been thoughtfully redesigned with today\'s buyer and trends in mind. The newly crafted open floorplan allows for an easy flow from one room to the next with generous space in each living area. The living room is light & bright with the plenty of room for oversized furniture & guests. The updated kitchen includes a stainless steel stove, rows of counter space and ample storage with plenty of room for multiple cooks. The dining area includes a gorgeous hanging lamp to showcase the best of meals & marvelous full paned French Doors overlooking the backyard. Both bedrooms are equally delightful and the fully remodeled bath is extraordinary with it\'s oversized tiled shower and designer touches. Don\'t miss the designer flooring throughout the house! Step outside onto the oversized back patio and lush lawn, ready for summer parties!' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 9 BLK 115 NORTH NORHILL' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'FIELD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'North Norhill' ,`TaxAmount` = '8522' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344527' WHERE `Matrix_Unique_ID` = '208327912' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-09T07:01:25.290' ,`MLSNumber` = '95451201' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819780' ,`Longitude` = '-94.820866' ,`PhotoCount` = '31' ,`PostalCode` = '77523' ,`RoomCount` = '10' ,`ListPrice` = '295990.00' ,`Status` = 'Active' ,`StreetName` = 'Cold Water' ,`StreetNumber` = '14807' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1409' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Baxtor Plan by D.R. Horton Homes Ready for Move In! Located in TOP #1 School District for all ages! Beautiful Stylish Timeless Chic 1 story home features Grand Entry W/High Ceilings, Gorgeous Luxury Vinyl Wood Floors throughout! Tile in all Bathrooms, Laundry Room & Plush Carpeting in Bedrooms! Amazing Open Floor Plan W/Huge Family Area that Flows into the Gourmet Kitchen W/Gorgeous Silestone Counters, Tile Back-splash, Large Eat-in Island W/Undermount Stainless Sink, Stainless Steel Appliances, Tall Upgraded Shaker Cabinets & more! Private Primary Suite has a Luxurious Bathroom featuring His & Her Undermount Deep Sink, Vanity has Cultured Marble Countertops \"Massive\" Shower with Tile Surroundings & Walk-in Closet! Enjoy the Covered Patio! Standard Energy Features: HERS Energy Rated, Tankless/On-Demand H2O Heater, 2 USB outlets &\"Smart Home\" w/Amazon Echo & Dot, Skybell, Smart Lighting, Electric Deadbolt, Thermostat & Wireless Security, Control your home from anywhere! NO FLOODING' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Raintree Lot: 34 /Block: 3' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '6600' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Raintree' ,`TaxAmount` = '' ,`TaxRate` = '1.69' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665344527' WHERE `Matrix_Unique_ID` = '210306412' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-09T07:00:04.870' ,`MLSNumber` = '42171712' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819798' ,`Longitude` = '-94.820789' ,`PhotoCount` = '25' ,`PostalCode` = '77523' ,`RoomCount` = '12' ,`ListPrice` = '317990.00' ,`Status` = 'Active' ,`StreetName` = 'Cold Water' ,`StreetNumber` = '14811' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1831' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New D. R. Horton Home Ready! Best Schools! The Harris! Chic Stucco & Brick Elevation, Covered Patio, Large Backyard & Sprinkler System! Stunning Entry W/High Ceilings! Luxury Vinyl Wood Flooring! 2 Full Baths & a Half Guest Bathroom! Huge Family Rm features Walls of Windows projecting abundance of natural light inside! Casual Dining flows gracefully into your Gourmet Kitchen features Beautiful Quartz Counters, Tall Gorgeous Shaker Cabinets, Stainless Appliances, Large Eat-in & Working Island, Under-mount Stainless Sink & more! Private Owner\'s Suite W/High Tray Ceilings & features Luxurious bathroom with His & Her Undermount Sinks Vanity W/Cultured Marble Counters, deep Soaker Tub, Large Seamless Glass Shower & Huge Walk-in Closet. Energy Efficient Home(HERS Rated),Tankless Water Heater! \"Smart Home Automation System\" where you are able to control your home from anywhere, Camera Doorbell, Lighting, Electric Deadbolt, Thermostat & so much more! NO FLOODING! Not In Flood Zone at this time' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Raintree Lot: 33 /Block: 3' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '6600' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Raintree' ,`TaxAmount` = '' ,`TaxRate` = '1.69' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665344528' WHERE `Matrix_Unique_ID` = '210326509' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-09T07:57:55.257' ,`MLSNumber` = '44589827' ,`ListAgentFullName` = 'Amanda Evans' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.738390' ,`Longitude` = '-95.842661' ,`PhotoCount` = '50' ,`PostalCode` = '77494' ,`RoomCount` = '8' ,`ListPrice` = '1500000.00' ,`Status` = 'Active' ,`StreetName` = 'Cumberland Brook' ,`StreetNumber` = '3022' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '5621' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Luxury living in the exclusive Ironwood section of Cinco Ranch Northwest. This stunning home features 6 bedrooms, a home gym, study, a resort style pool with slide, game room off of the back patio with sliding doors and a 36KW Generac generator. The gourmet kitchen comes equipped with a 48\" Viking Range, TWO Jenn-Air 36\" fully integrated Built-in bottom freezer refrigerators and an impressive 9 foot island with plenty of seating. Gorgeous gas lanterns are placed at the two story entry as well as in the expansive covered back patio. The primary bedroom and one secondary bedroom are downstairs and the other 4 bedrooms are upstairs and all have attached bathrooms and 3\' wainscoting along with the main living areas. The lighting and built-in speakers can be controlled by the Control4 Smart Home OS. Make sure to check out the VIDEO TOUR.' ,`Acres` = '0.3006' ,`Area` = '36' ,`BuilderName` = 'Partners In Building' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CINCO RANCH NORTHWEST SEC 6, BLOCK 3, LOT 33' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13093' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1285' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'JENKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Cinco Ranch Northwest Sec 6' ,`TaxAmount` = '23051' ,`TaxRate` = '2.7545' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344528' WHERE `Matrix_Unique_ID` = '210355929' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-09T07:20:29.160' ,`MLSNumber` = '43892943' ,`ListAgentFullName` = 'Richard Henderson' ,`ListOfficeName` = 'RE/MAX Grand' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.832837' ,`Longitude` = '-95.713169' ,`PhotoCount` = '32' ,`PostalCode` = '77449' ,`RoomCount` = '10' ,`ListPrice` = '279900.00' ,`Status` = 'Active' ,`StreetName` = 'Field Meadow' ,`StreetNumber` = '4215' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2328' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This well maintained home is now ready for its new family. It features tile throughout the 1st floor, Lam. hard woods on the stairs and upstairs. Secondary bedrooms have carpet. The wet bar is centrally located to serve at those family functions or parties. The master suite have is own fireplace along with one in the family room. Stainless steel appliances French doors leading to the covered patio with extended decking in the backyard. There is an extra room in the back used as a gym. Full sprinkler system. All bathrooms upgraded in the last 5 yrs along with recent dishwasher and 4 stainless steel ceiling fans' ,`Acres` = '0.1143' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 18 CYPRESS MEADOWS 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4980' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'M ROBINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (CY-FAIR)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Meadows 03' ,`TaxAmount` = '5322' ,`TaxRate` = '2.796' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344528' WHERE `Matrix_Unique_ID` = '210360931' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-09T07:31:49.347' ,`MLSNumber` = '95152737' ,`ListAgentFullName` = 'Jaime McLaughlin' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.534593' ,`Longitude` = '-95.215210' ,`PhotoCount` = '19' ,`PostalCode` = '77546' ,`RoomCount` = '4' ,`ListPrice` = '216500.00' ,`Status` = 'Active' ,`StreetName` = 'Stratmore' ,`StreetNumber` = '405' ,`StreetSuffix` = 'Drive' ,`City` = 'Friendswood' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1029' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Adorable and move in ready home nestled in the established neighborhood of Anna Alea and zoned to Friendswood ISD! This home offers like new interior paint and light fixtures, hard surface flooring throughout, gorgeous remodeled bathrooms, huge backyard with mature trees, covered/screened in porch outback perfect for relaxing and entertaining and all new PEX piping (2020)! Like new water heater (2018) and fence (2017) too! Please inquire about cabinet doors. Come take a peek at this one before its too late!' ,`Acres` = '0.1612' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 20 PERRY & AUSTIN SUR LOT 12 BLK 1 ANNALEA KINGSPARK SE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7020' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '20 - Friendswood' ,`SchoolElementary` = 'WESTWOOD ELEMENTARY SCHOOL (FRIENDSWOOD)' ,`SchoolHigh` = 'FRIENDSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'FRIENDSWOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Anna Alea Kingspark/Whitehall' ,`TaxAmount` = '3172' ,`TaxRate` = '2.2832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344528' WHERE `Matrix_Unique_ID` = '210601766' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-09T07:52:56.740' ,`MLSNumber` = '89633998' ,`ListAgentFullName` = 'Susan Kinder' ,`ListOfficeName` = 'MV Realty Of Texas LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.938836' ,`Longitude` = '-95.211822' ,`PhotoCount` = '17' ,`PostalCode` = '77396' ,`RoomCount` = '9' ,`ListPrice` = '298000.00' ,`Status` = 'Active' ,`StreetName` = 'Sierra Sunset' ,`StreetNumber` = '15002' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2079' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful 3 bedroom, 2 bath house is waiting for you to make it a home. With a short commute downtown and the convenience of having shopping centers all around you, you could live a life of ease when making it your new home. The open floor plan exposes the kitchen to the living room, allowing ease of conversation with your guests and meal prepping. The home is located inside the Sunset community partnered with the Balmoral community. You have all access to the Balmoral facilities. Stop in and see what your new life could look like.' ,`Acres` = '0.1263' ,`Area` = '1' ,`BuilderName` = 'David Weekley' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 52 BLK 1 SUNSET RIDGE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'RIDGE CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunset Rdg Sec 02' ,`TaxAmount` = '6320' ,`TaxRate` = '3.0673' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344528' WHERE `Matrix_Unique_ID` = '210734737' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-09T07:45:38.633' ,`MLSNumber` = '44270485' ,`ListAgentFullName` = 'Roston Veal' ,`ListOfficeName` = 'Legacy Homes & Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.136849' ,`Longitude` = '-95.380684' ,`PhotoCount` = '39' ,`PostalCode` = '77386' ,`RoomCount` = '13' ,`ListPrice` = '387500.00' ,`Status` = 'Active' ,`StreetName` = 'Pinewood Bend' ,`StreetNumber` = '3717' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2492' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this gem in the highly sought after Imperial Oaks subdivision in Spring, Texas! This beautiful two-story has it all! It all starts from the grand entry in the foyer, to the dining room, kitchen with a pantry and adjoining breakfast nook, family room, and functional walk-in utility room. The first floor owner\'s bedroom features an en suite bathroom with dual sinks, stand-up shower along with a soaker tub and a generous walk-in closet. The second floor features a spacious game room, three additional secondary bedrooms, and a full bathroom,.' ,`Acres` = '0.141' ,`Area` = '15' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S504221 - FALLS AT IMPERIAL OAKS 21, BLOCK 1, LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6141' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BRADLEY ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Falls At Imperial Oaks 21' ,`TaxAmount` = '9360' ,`TaxRate` = '3.1987' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344529' WHERE `Matrix_Unique_ID` = '210950985' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-09T07:51:45.167' ,`MLSNumber` = '34712057' ,`ListAgentFullName` = 'Fred Michael' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.530079' ,`Longitude` = '-95.161753' ,`PhotoCount` = '11' ,`PostalCode` = '77598' ,`RoomCount` = '6' ,`ListPrice` = '239900.00' ,`Status` = 'Active' ,`StreetName` = 'Heritage Bend' ,`StreetNumber` = '2443' ,`StreetSuffix` = 'Drive' ,`City` = 'Webster' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1740' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location - Location - Location. Heritage Park has easy access to parks, shopping, movie theatres, and cultural dining. One of the larger sqft in this older section of Heritage Park. This home boasts of 3 Bedrooms, 2 Baths, 2 Car Attached garage. All tile flooring, Updated tub/shower tile. Low HOA fees, no neighbors directly behind. Transferrable foundation warranty. Priced Right! Make your appointment today! All descriptions and measurements deemed reliable but not guarantied, to be independently verified by buyers. UP TO 2% SELLER HELP WITH BUYER CLOSING COST.' ,`Acres` = '0.2222' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 49 BLK 16 HERITAGE PARK SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9680' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '165' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'GREENE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'BROOKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Heritage Park Sec 05' ,`TaxAmount` = '4208' ,`TaxRate` = '2.166' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344529' WHERE `Matrix_Unique_ID` = '211099541' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-09T07:24:47.620' ,`MLSNumber` = '29512647' ,`ListAgentFullName` = 'Judy Langston' ,`ListOfficeName` = 'Nacol Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.616443' ,`Longitude` = '-95.022661' ,`PhotoCount` = '31' ,`PostalCode` = '77331' ,`RoomCount` = '4' ,`ListPrice` = '59900.00' ,`Status` = 'Active' ,`StreetName` = 'Janning' ,`StreetNumber` = '781' ,`StreetSuffix` = 'Street' ,`City` = 'Coldspring' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One of Best Values in San Jacinto County. Has two metal outbuilding, Garage/Workshop. Bathroom in one of metal buildings. Huge beautiful Mature trees. Three of lots on Janning Street under chain link fencing. One lot behind house on Mudd Street not fenced. Lot on Mudd St. would make terrific garden spot. Trinity River at one end of road and Lake Livingston Dam at other end. Private boat ramp for property owner\'s only into Trinity River and can launch your boat free into Lake Livingston at nearby Marina if you pay your maintenance fee. Large country kitchen with lots of cabinet space, One large bath in house has tub w/shower as well as bath in workshop with shower. Front and Back Stairs with covered porches. One car garage plus carport.' ,`Acres` = '0.48' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'Lots 1043, 1044 & 1045 Camilla Twin Harbors, Sec. 4' ,`LotDesciption` = 'Cleared,Subdivision Lot,Wooded' ,`LotSize` = '20996' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '96' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Camilla Twin Harbors' ,`TaxAmount` = '429' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344529' WHERE `Matrix_Unique_ID` = '211406741' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-09T06:56:36.690' ,`MLSNumber` = '20838647' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.820263' ,`Longitude` = '-94.818848' ,`PhotoCount` = '31' ,`PostalCode` = '77523' ,`RoomCount` = '13' ,`ListPrice` = '353990.00' ,`Status` = 'Active' ,`StreetName` = 'Cold Water' ,`StreetNumber` = '14911' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2251' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Mitchell Plan by D.R. Horton New 2 Story Home! Outstanding Schools! Ready for Move In! Grand 2 Story Entry! Private Owner\'s Suite W/Luxurious Bathroom & Guest Suite with Full Bathroom Downstairs! Beautiful Vinyl Wood Like Carefree Flooring Throughout, Tile In all Bathrooms & Lush Carpeting in all Bedrooms! Casual Dining & Amazing Family Rm that flows gracefully into the Gourmet Kitchen W/Upgraded Quartz Counters, Tile Back-splash, Large Eat-in Working Island, Deep Under-mount Stainless Sink, Tall gorgeous Grey Cabinets & more! The Private Owner\'s Suite features High Ceilings, Luxurious Bath W/Cultured Marble Vanity, Deep Undermount Dual Sink, Deep Soaker Tub, Separate Shower & Walk-in Closet! Upstairs discover a Game Room, 2 Secondary Bedrms & 1 Full Bath! Covered Patio, Sprinkler System! HERS Energy Rated, Tankless Gas Water Heater & \"Smart Home Automation System W/Amazon Echo allowing you to control your home for anywhere! NO FLOODING! LOW TAXES!! Not in Flood Zone at this time!' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 3 RAINTREE SEC 2' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '6620' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Raintree' ,`TaxAmount` = '' ,`TaxRate` = '1.7058' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665344529' WHERE `Matrix_Unique_ID` = '211682420' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-09T06:42:12.197' ,`MLSNumber` = '10643688' ,`ListAgentFullName` = 'Gwen Cannon' ,`ListOfficeName` = 'White Label Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.514964' ,`Longitude` = '-95.074480' ,`PhotoCount` = '48' ,`PostalCode` = '77573' ,`RoomCount` = '18' ,`ListPrice` = '999500.00' ,`Status` = 'Active' ,`StreetName` = 'Dellore' ,`StreetNumber` = '1919' ,`StreetSuffix` = 'Lane' ,`City` = 'League City' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '6' ,`SqFtTotal` = '5644' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If seclusion, space and class are what you are looking for… look no further! This property is over 2 acres hidden within the heart if League City and has the charm of being in the country. This custom gated spread hosts 2 complete homes with the larger home having 4 bedrooms with game room and the second home is a smaller replica of the larger one with 2 primary bedrooms, office and a complete kitchen. The second home could be a MIL wing, guest home or a tenant space. There is a large shop/garage on the property that has an office with air and a full bath. There is plenty room in the shop for a large motor home. The options for this property are endless. The roof was replaced in 2017, the larger home has 2 ac units that were replaced in 2018. A security gate surrounds the property with 2 entrances. The interior walls are insulated and the has bell bottom piers. The outdoor area is beautiful and offers beauty and peace.' ,`Acres` = '2.3' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 18 M MULDOON SUR PT OF LOT 18 (18-5) DIV C LEAGUE CITY' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Greenbelt' ,`LotSize` = '100168' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '6' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'LEAGUE CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'LEAGUECITY INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'League City Div C' ,`TaxAmount` = '23143' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Other Water/Sewer,Well' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344529' WHERE `Matrix_Unique_ID` = '212125367' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-09T07:28:58.090' ,`MLSNumber` = '28322364' ,`ListAgentFullName` = 'Jojo Tharayil' ,`ListOfficeName` = 'Excel Realty Co' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.560348' ,`Longitude` = '-95.548730' ,`PhotoCount` = '17' ,`PostalCode` = '77459' ,`RoomCount` = '8' ,`ListPrice` = '349000.00' ,`Status` = 'Active' ,`StreetName` = 'King Cotton' ,`StreetNumber` = '4106' ,`StreetSuffix` = 'Lane' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2586' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GREAT BIG KITCHEN WITH ISLAND AND BREAKFAST AREA, FAMILY ROOM, FORMAL LIVING AND DINING ROOMS, FIREPLACE, HUGE BACKYARD. MASTER DOWNSTAIRS AND ALL OTHER BEDROOMS UP. GREAT COMMUNITY. YOU WILL WANT TO COME HOME!' ,`Acres` = '0.1736' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PALMER PLNT-LAKE OLYMPIA SEC 1, BLOCK 4, LOT 14, R/P' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7561' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PALMER ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Olympia Sec 1' ,`TaxAmount` = '6252' ,`TaxRate` = '2.81' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344529' WHERE `Matrix_Unique_ID` = '212170778' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-09T07:49:13.940' ,`MLSNumber` = '51630216' ,`ListAgentFullName` = 'Debbie Hagan' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.807990' ,`Longitude` = '-95.366435' ,`PhotoCount` = '6' ,`PostalCode` = '77009' ,`RoomCount` = '5' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'English' ,`StreetNumber` = '321' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1201' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is ready for all your renovation dreams! Ideally located in one of Houston’s hottest neighborhoods this home has easy access to the MetroRail and is minutes to both IAH & Hobby airport, White Oak Music Hall, downtown and more! This 1 story brick homes sits on a wide street, with a lot over 7900+ sq ft and includes a fully fenced backyard. Exterior paint and front yard landscaping were installed September 2022 *the roof is ~ 6 years old. Buyer will need to verify all room dimensions.' ,`Acres` = '0.1825' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 42 & TR 43A BLK 32 LINDALE PARK SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7950' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'JEFFERSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lindale Park Sec 05' ,`TaxAmount` = '6652' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344530' WHERE `Matrix_Unique_ID` = '212217811' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-09T06:56:10.187' ,`MLSNumber` = '38492186' ,`ListAgentFullName` = 'Melanie Shadwick' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.973601' ,`Longitude` = '-95.657198' ,`PhotoCount` = '39' ,`PostalCode` = '77429' ,`RoomCount` = '14' ,`ListPrice` = '516000.00' ,`Status` = 'Active' ,`StreetName` = 'Cypress Hall' ,`StreetNumber` = '15938' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3492' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Walk your children to school or join a home school group at this family-centered COLES CROSSING, CY-FAIR ISD 4 bed, 3 bath, open floor plan corner lot home with baja shelf gunite pool! Fence enclosed patio for a safe play area, eat-in kitchen dining, island, granite counters, walk-in pantry, built-in desk w.shelves. Split bed floor plan, primary- 2 vanities, updated faucets/fixtures/shower enclosure, jetted tub and 3 tier closet! Upstairs media room or homeschool classroom & bath, home has 3 attic access points and storage+. 2 of 3 zoned A/C units new 2020,Ecobee Thermostat, 2 Wi-Fi GD Openers, Whole house power surge protector 2021,NEVER FLOODED, 240V adapter for Electric Vehicle Charging added 2018, Polaris pool equipment 2022, home painted 2022. Master Plan Community Amenities- private event spaces, multiple pools, swim team, water slides, splash areas, playgrounds, volleyball, tennis, sports field area, park, stocked pond and greenbelt. Seller carpet credit and Home Warranty.' ,`Acres` = '0.2106' ,`Area` = '10' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 3 COLES CROSSING SEC 15' ,`LotDesciption` = 'Corner' ,`LotSize` = '9174' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'SAMPSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPILLANE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Coles Crossing' ,`TaxAmount` = '9532' ,`TaxRate` = '2.531' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344530' WHERE `Matrix_Unique_ID` = '212332584' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-09T06:52:13.337' ,`MLSNumber` = '38862122' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819798' ,`Longitude` = '-94.820789' ,`PhotoCount` = '36' ,`PostalCode` = '77523' ,`RoomCount` = '12' ,`ListPrice` = '315990.00' ,`Status` = 'Active' ,`StreetName` = 'Lost Creek' ,`StreetNumber` = '626' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1831' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New D. R. Horton Home Ready! Best Schools! Dramatic Chic Stucco & Brick Elevation! Sprinkler System! Huge Backyard & Covered Patio! Stunning Entry W/High Ceilings! Luxury Vinyl Wood Flooring! 2 Full Baths & a Half Guest Bathroom! Large Family Rm features Walls of Windows projecting abundance of natural light inside! Casual Dining flows gracefully into your Gourmet Kitchen features Beautiful Quartz Counters, White Tall Gorgeous Shaker Cabinets, Stainless Appliances, Large Eat-in & Working Island, Under-mount Stainless Sink & more! Private Owner\'s Suite W/High Tray Ceilings & features Luxurious bathroom W/His & Her Undermount Sinks Vanity W/Cultured Marble Counters, Deep Soaker Tub, Large Seamless Glass Shower & Huge Walk-in Closet. Energy Efficient Home(HERS Rated),Tankless Water Heater! \"Smart Home Automation System\" where you are able to control your home from anywhere, Camera Doorbell, Lighting, Electric Deadbolt, Thermostat & so much more! NO FLOODING! Not In Flood Zone at this time' ,`Acres` = '0.15' ,`Area` = '53' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Raintree Lot: 21 /Block: 2' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '6663' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Raintree' ,`TaxAmount` = '' ,`TaxRate` = '1.69' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665344530' WHERE `Matrix_Unique_ID` = '212369831' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-09T06:47:28.640' ,`MLSNumber` = '49549562' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819798' ,`Longitude` = '-94.820789' ,`PhotoCount` = '30' ,`PostalCode` = '77523' ,`RoomCount` = '11' ,`ListPrice` = '315990.00' ,`Status` = 'Active' ,`StreetName` = 'Sweetwater' ,`StreetNumber` = '14502' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1778' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One Story Home The Gaven Plan by D.R. Horton! Ready for move in! Ultra Modern & Chic Elevation! Sprinkler System! Stunning Entry W/High Ceilings! Gorgeous Carefree Luxury Vinyl Wood Flooring! Huge Family Room features Walls of Windows projecting abundance of natural light inside & Looks out to your Huge Backyard & Covered Patio! Casual Dining flows gracefully into Gourmet Kitchen W/Beautiful Quartz Counters, Tall Gorgeous Shaker Cabinets, Tile Backsplash, Stainless Appliances, Large Eat-in & Working Island, Under-mount Stainless Sink & more! Private Owner\'s Suite W/High Tray Ceilings & features Luxurious bathroom with His & Her Undermount Sinks Vanity W/Cultured Marble Counters, Deep Soaker Tub, Large Glass Shower & Huge Walk-in Closet. Energy Efficient Home(HERS Rated),Tankless Water Heater! \"Smart Home Automation System\" where you are able to control your home from anywhere, Camera Doorbell, Lighting, Electric Deadbolt, Thermostat & More! NO FLOODING! Not In Flood Zone at this time' ,`Acres` = '0.19' ,`Area` = '53' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Raintree Lot: 13 /Block: 5' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '8134' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Raintree' ,`TaxAmount` = '' ,`TaxRate` = '1.69' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665344530' WHERE `Matrix_Unique_ID` = '212371334' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-09T07:14:28.790' ,`MLSNumber` = '66458844' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819798' ,`Longitude` = '-94.820789' ,`PhotoCount` = '29' ,`PostalCode` = '77523' ,`RoomCount` = '11' ,`ListPrice` = '310990.00' ,`Status` = 'Active' ,`StreetName` = 'Rain Tree' ,`StreetNumber` = '14826' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1717' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning One Story Home By D.R. Horton! Ready for move in! Ultra Modern & Chic Stucco & Brick Elevation! Stunning Entry W/High Ceilings! Luxury Vinyl Wood Flooring! Dramatic Family Rm features Walls of Windows for natural lightning & Looks out to your Huge Backyard & Covered Patio! Sprinkler System! Casual Dining flows into Gourmet Kitchen that Features Beautiful Quartz Counters, Tall Gorgeous Shaker Cabinets, Tile Backsplash, Stainless Steel Appliances, Large Eat-in & Working Island, Under-mount Stainless Sink & more! Private Owner\'s Suite W/High Tray Ceilings & features Luxurious bathroom W/His & Her Undermount Sinks Vanity, Deep Soaker Tub, Large Glass Shower & Huge Walk-in Closet. 2 Inches Blinds! Energy Efficient Home(HERS Rated),Tankless Water Heater! \"Smart Home Automation System\" where you are able to control your home anywhere, Camera Doorbell, Lighting, Electric Deadbolt, Thermostat & More! NO FLOODING! Not In Flood Zone at this time! Outstanding Schools for all Ages! More' ,`Acres` = '0.18' ,`Area` = '53' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Raintree Lot: 7 /Block: 2' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '7804' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch' ,`Subdivision` = 'Raintree' ,`TaxAmount` = '' ,`TaxRate` = '1.69' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665344530' WHERE `Matrix_Unique_ID` = '212464255' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-09T07:15:22.873' ,`MLSNumber` = '2660302' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819780' ,`Longitude` = '-94.820866' ,`PhotoCount` = '36' ,`PostalCode` = '77523' ,`RoomCount` = '10' ,`ListPrice` = '304990.00' ,`Status` = 'Active' ,`StreetName` = 'Lost Creek' ,`StreetNumber` = '614' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1595' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction Ready for Move In! Dramatic Chic Elevation W/Stucco & Brick! Covered Patio & Sprinkler System! Stunning Entry W/Gorgeous Luxurious Wood Vinyl Floors leading the path into the Huge Family & Casual Dining Area! Gourmet Kitchen Boast Gorgeous Quartz Countertops, Tile Back-splash, Large Eat-in Working Island w/Undermount Stainless Sink, Drinking Water Filtration System, Stainless Steel Appliances, Stunning Tall Shaker Cabinets! Gourmet Kitchen open to the Amazing Family Rm W/High Ceilings & Wall of Windows overlooking Huge Backyard! Private Owner\'s Suite W/Luxurious Bath featuring Huge Vanity W/Cultural Marble Counters, Deep Undermount Sinks, Massive Shower & Huge Walk-in Closet! Standard Energy Features: HERS Energy Rated, Tankless/On-Demand H2O Heater, 2 USB outlets & \"Smart Home\" allows you to control the Skybell, Lighting, Deadbolt, Thermostat, Wireless Security & almost from anywhere!! 2 Inches White Blinds! NO FLOODING! LOW PROPERTY TAXES, OUTSTANDING SCHOOLS & MORE!' ,`Acres` = '0.16' ,`Area` = '53' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Raintree Lot: 18 /Block: 2' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '6821' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Raintree' ,`TaxAmount` = '' ,`TaxRate` = '1.69' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665344531' WHERE `Matrix_Unique_ID` = '212465677' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-09T07:51:58.147' ,`MLSNumber` = '64663715' ,`ListAgentFullName` = 'Sunli Whitcomb' ,`ListOfficeName` = 'Houston Sunshine Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.535932' ,`Longitude` = '-95.472267' ,`PhotoCount` = '20' ,`PostalCode` = '77545' ,`RoomCount` = '8' ,`ListPrice` = '289000.00' ,`Status` = 'Active' ,`StreetName` = 'Bergen Bay Lane' ,`StreetNumber` = '2743' ,`StreetSuffix` = '' ,`City` = 'Fresno' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1704' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2018 HR Horton energy efficiency Home! Granite countertop, Breakfast Bar, tile back splash, tiles in wet area, 36\'\'cabinets, Laundry Room in house, high efficiency 14 seers AC, double pane tilt sash low-E windows and R-30 fiberglass insulation in flat ceiling for energy saving, 2\'\'Faux Blinds. Desired Fort Bend ISD, easy excess to Houston medical center. Great location!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'D. R. Horton' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 37, Block 4, Cambridge Falls Section 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PARKS ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'HIGHTOWER HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cambridge Falls' ,`TaxAmount` = '5176' ,`TaxRate` = '2.4829' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665344531' WHERE `Matrix_Unique_ID` = '212473454' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-09T07:09:59.367' ,`MLSNumber` = '66339530' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819780' ,`Longitude` = '-94.820866' ,`PhotoCount` = '33' ,`PostalCode` = '77523' ,`RoomCount` = '10' ,`ListPrice` = '295990.00' ,`Status` = 'Active' ,`StreetName` = 'Cold Water' ,`StreetNumber` = '14907' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1409' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Amazing Chic Stucco & Brick Elevation W/Covered Patio by D.R. Horton Homes! Located in TOP #1 School District for all ages! Stylish Timeless Chic 1 story home features Grand Entry W/High Ceilings, Gorgeous Luxury Vinyl Wood Floors throughout! Tile in all Bathrooms & Laundry Rm! Ask about Move In Package! Amazing Open Floor Plan W/Huge Family Area that Flows into the Gourmet Kitchen W/Gorgeous Silestone Counters, Tile Back-splash, Large Eat-in Island W/Undermount Stainless Sink, Stainless Steel Appliances, Tall Upgraded Shaker Cabinets & more! Private Primary Suite has a Luxurious Bathroom featuring His & Her Undermount Deep Sink, Vanity W/Cultured Marble Countertops \"Massive\" Shower with Tile Surroundings & Walk-in Closet! Enjoy Huge Backyard! Energy Features: HERS Energy Rated, Tankless/On-Demand H2O Heater, 2 USB outlets &\"Smart Home\" w/Amazon Echo & Dot, Skybell, Smart Lighting, Electric Deadbolt, Thermostat & Wireless Security, Control your home from anywhere! NO FLOODING' ,`Acres` = '0.15' ,`Area` = '53' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Raintree Lot: 27 /Block: 2' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '6620' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch' ,`Subdivision` = 'Raintree' ,`TaxAmount` = '' ,`TaxRate` = '1.69' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665344531' WHERE `Matrix_Unique_ID` = '212648170' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-09T07:08:29.777' ,`MLSNumber` = '16916940' ,`ListAgentFullName` = 'Sheila Lewis' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.928101' ,`Longitude` = '-95.185751' ,`PhotoCount` = '30' ,`PostalCode` = '77044' ,`RoomCount` = '10' ,`ListPrice` = '415000.00' ,`Status` = 'Active' ,`StreetName` = 'Chartley Falls' ,`StreetNumber` = '14434' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3065' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Make this beautiful 4-bedroom, 3.5 bathroom house your new home. Great open floorplan. Elegant entry with winding stair case. Beautiful luxury vinyl tile on first floor. Island kitchen with double ovens and stainless steel appliances. Primary bedroom has en-suite bath with double vanities, jetted garden tub, separate shower and walk-in closets. Three spacious bedrooms upstairs with two full baths. Beautiful covered back patio with super spacious backyard, possibly one of the largest backyards in the community. First floor is 100% brick exterior. Add your personal touch and make this the perfect home for your family.' ,`Acres` = '0.3476' ,`Area` = '1' ,`BuilderName` = 'Partners In Building' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 1 SUMMERWOOD SEC 7 EDGEWATER VLG' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '15141' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'SUMMERWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Back,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Summerwood Sec 07 Edgewater 06' ,`TaxAmount` = '7811' ,`TaxRate` = '2.683' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344531' WHERE `Matrix_Unique_ID` = '212653212' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-09T07:54:00.667' ,`MLSNumber` = '87912637' ,`ListAgentFullName` = 'Brandon Dunbar' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.887828' ,`Longitude` = '-95.606979' ,`PhotoCount` = '23' ,`PostalCode` = '77041' ,`RoomCount` = '8' ,`ListPrice` = '220000.00' ,`Status` = 'Active' ,`StreetName` = 'Fountaincrest' ,`StreetNumber` = '7510' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1344' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THIS ONE-OF-A-KIND PATIO HOME IS A MUST-SEE!! This 2-3/2 home is nestled into the prestigious Chimney Hill subdivision. The home has high ceilings and a large living room area that you and your family could enjoy. The home has a unique upstairs bedroom/home office/game room adding more living space and possibilities! Super easy access to HWY 290. The furniture seen in the home is all negotiable with the sale of the home. Refrigerator/Washer/Dryer comes with the home!' ,`Acres` = '0.1188' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 2 CHIMNEY HILL SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5175' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '381' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HAIRGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'LABAY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Left Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Mediterranean' ,`Subdivision` = 'Chimney Hill Sec 05' ,`TaxAmount` = '4174' ,`TaxRate` = '2.811' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344531' WHERE `Matrix_Unique_ID` = '212666702' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-09T06:24:34.650' ,`MLSNumber` = '87212824' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819780' ,`Longitude` = '-94.820866' ,`PhotoCount` = '31' ,`PostalCode` = '77523' ,`RoomCount` = '10' ,`ListPrice` = '295900.00' ,`Status` = 'Active' ,`StreetName` = 'Lost Creek' ,`StreetNumber` = '610' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1409' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Baxtor Plan by D.R. Horton Homes Ready for Move In! Located in TOP #1 School District for all ages! Stylish Timeless Chic 1 story home with Amazing Stucco & Brick Elevation! Grand Entry W/High Ceilings, Gorgeous Luxury Vinyl Wood Floors throughout! Lush Carpeting in all the Bedrms! Amazing Open Floor Plan W/Huge Family Area that Flows into the Gourmet Kitchen W/Gorgeous Silestone Counters, Tile Back-splash, Large Eat-in Island W/Undermount Stainless Sink, Stainless Steel Appliances, Tall Upgraded Shaker Cabinets & more! Private Primary Suite has a Luxurious Bathroom featuring His & Her Undermount Deep Sinks, Vanity has Cultured Marble Countertops \"Massive\" Shower with Tile Surroundings & Walk-in Closet! Enjoy the Covered Patio! Move-in Pkg! Standard Energy Features: HERS Energy Rated, Tankless/On-Demand H2O Heater, 2 USB outlets &\"Smart Home\" w/Amazon Echo & Dot, Skybell, Smart Lighting, Electric Deadbolt, Thermostat & Wireless Security, Control your home from anywhere! NO FLOODING' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Raintree Lot: 17 /Block: 2' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '6600' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Raintree' ,`TaxAmount` = '' ,`TaxRate` = '1.69' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665344531' WHERE `Matrix_Unique_ID` = '212958850' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-09T07:04:27.777' ,`MLSNumber` = '4454328' ,`ListAgentFullName` = 'Emely Valdez Rivas' ,`ListOfficeName` = 'Exceed Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.730798' ,`Longitude` = '-95.869329' ,`PhotoCount` = '32' ,`PostalCode` = '77494' ,`RoomCount` = '7' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'Yellowstone Preserve' ,`StreetNumber` = '28711' ,`StreetSuffix` = 'Lane' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2448' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Built in 2020, and located in the highly acclaimed Katy ISD. 4 Bed, 3 Bath. Guest Room with private full bath (perfect in-law suite if needed) or office! Large dining room and walk-in pantry.\r\n\r\nComes with a video doorbell, thermostat, and key-less Entry including the garage door, all controllable through your Alexa or smartphone. 42\" inch cabinets, stainless steel appliances, AND double ovens! Gorgeous designer finishes, with a backyard-covered patio and irrigation system. You’ll find Epoxy flooring and full air conditioning in the garage ready for entertaining. Included is everything you are looking for in a community- a resort pool, splash pad, fitness center, sports fields, lakes & walking trails all waiting for you!' ,`Acres` = '0.1829' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TAMARRON SEC 24, BLOCK 2, LOT 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7965' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Tamarron' ,`TaxAmount` = '9997' ,`TaxRate` = '3.3775' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665344532' WHERE `Matrix_Unique_ID` = '213029874' --> 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','213151679','1665344532','213151679','2022-10-09T07:55:08.667','84919585','Erick Harbert','Realty Right','','','29.841336','-95.691697','50','77084','10','485000.00','Active','Gardens End','18243','Lane','Houston','3','1','4','2931','Single-Family','Area amenities include a recreation center complete with an Olympic-size swimming pool, water slides, walking trails, children’s pool, and a playground.','0.1422','25','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','1','Bear Creek South','Central Gas','1','LT 5 BLK 1 GRAND OAKS SEC 12','Subdivision Lot','6196','Appraisal District','','735','0','','3','Freestanding Oven,Gas Oven,Single Oven','0','','','','','Composition','13 - Cypress-Fairbanks','WILSON ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','CYPRESS LAKES HIGH SCHOOL','WATKINS MIDDLE SCHOOL','Appointment Required,Controlled Access,No Supra Keybox','Appraisal District','2','Traditional','Grand Oaks','8674','2.731','Public Sewer,Public Water','2020','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-09T07:44:20.523' ,`MLSNumber` = '12379456' ,`ListAgentFullName` = 'Stacey Dawn Ocampo' ,`ListOfficeName` = 'Stacey Dawn Realty & Mortgage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.229720' ,`Longitude` = '-95.705296' ,`PhotoCount` = '19' ,`PostalCode` = '77354' ,`RoomCount` = '7' ,`ListPrice` = '999995.00' ,`Status` = 'Active' ,`StreetName` = 'Mill Creek' ,`StreetNumber` = '40025' ,`StreetSuffix` = 'Road' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1437' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNRESTRICTED COMMERICAL PROPERTY. 1.18 ACRES. City Water/Sewer is Available.Currenlty includes 1 Story 3 Bedroom, 2 Full Bath , 3 Car Garage and Large Workshop Metal Building. 1 Large Residential Development across Street and 1 across 1488 Road. 1.5 Miles to Hwy 249 Toll Road (Aggie expressway)and 1.5 Miles from Muiltiple New Commerical Developments & Multi Use Developments.(Example Heb, Gas Stations, CVS, Fast Food Restaurants etc).' ,`Acres` = '1.18' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'John B Richards 1.1800 AC' ,`LotDesciption` = 'Other,Wooded' ,`LotSize` = '51401' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'WILLIE E. WILLIAMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'John B Richards' ,`TaxAmount` = '3606' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344532' WHERE `Matrix_Unique_ID` = '213193614' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-09T07:51:58.783' ,`MLSNumber` = '50136810' ,`ListAgentFullName` = 'Jon Forde' ,`ListOfficeName` = 'Keller Williams Advtge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.380481' ,`Longitude` = '-95.496641' ,`PhotoCount` = '44' ,`PostalCode` = '77304' ,`RoomCount` = '8' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Hiwon' ,`StreetNumber` = '102' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2445' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3 bedroom single-story home on the Golf Course in Panorama Subdivision conveniently located just minutes from I-45 with a 27-hole Golf Course, clubhouse, swimming pool, 3 parks, Pavilion. NO HOA FEES + NO MUD TAX. Two car garage with a golf cart garage. Sprinkler system, Roof 4 1/2 years old, New AC, New dishwasher, oven / Micro will be replaced by home warranty company in November. Refrigerator included and washer & Dryer (one year old) will also stay. Jenn-Air 4 burner cooktop. Gas log fireplace, beautiful views of the golf course. 18 minutes to the Woodlands Mall. Willis ISD! Golf packages available!' ,`Acres` = '0.229' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'PANORAMA-HIWON 01, LOT 102' ,`LotDesciption` = 'In Golf Course Community,On Golf Course' ,`LotSize` = '9975' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'LAGWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Panorama-Hiwon' ,`TaxAmount` = '6240' ,`TaxRate` = '2.4982' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344532' WHERE `Matrix_Unique_ID` = '213264902' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-09T06:55:02.280' ,`MLSNumber` = '80555422' ,`ListAgentFullName` = 'David Aldridge' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.594941' ,`Longitude` = '-95.229338' ,`PhotoCount` = '34' ,`PostalCode` = '77089' ,`RoomCount` = '4' ,`ListPrice` = '319000.00' ,`Status` = 'Active' ,`StreetName` = 'Sagewind' ,`StreetNumber` = '10803' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2639' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious and modernized 4-bedroom home! Features large living / dinning area with vaulted ceilings and fire place. Renovated kitchen with an open concept, granite countertops with full backsplash and new stainless steel appliances. Both bathrooms have been updated. New luxury vinyl tile plank floors, LED lights, full 2 car garage. Modern cabinets and trendy hardware. Spacious backyard! This home is conveniently located to shopping and local retail.' ,`Acres` = '0.1785' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 18 BLK 39 SAGEMONT SEC 8' ,`LotDesciption` = 'Other' ,`LotSize` = '7777' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'FRAZIER ELEMENTARY SCHOOL (PASADENA)' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'THOMPSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Sagemont Sec 08' ,`TaxAmount` = '5005' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344532' WHERE `Matrix_Unique_ID` = '213274567' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-09T07:03:48.650' ,`MLSNumber` = '2600540' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819798' ,`Longitude` = '-94.820789' ,`PhotoCount` = '31' ,`PostalCode` = '77523' ,`RoomCount` = '11' ,`ListPrice` = '309990.00' ,`Status` = 'Active' ,`StreetName` = 'Rain Tree' ,`StreetNumber` = '14926' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1717' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 Story Home The Forest Plan by D.R. Horton! Ready for move in! Ultra Modern & Chic Stucco & Brick Elevation! Stunning Entry W/High Ceilings! Luxury Carefree Vinyl Wood Floors! Lush Carpeting in all bedrooms! Huge Family Rm features Walls of Windows to bring that natural light inside & Looks out to your Huge Backyard! Casual Dining flows into your Gourmet Kitchen that Features Beautiful Quartz Counters, Tall Gorgeous Shaker Cabinets, Tile Backsplash, Stainless Steel Appliances, Large Eat-in & Working Island, Under-mount Stainless Sink & more! Private Owner\'s Suite W/High Tray Ceilings & features Luxurious bathroom W/His & Her Undermount Sinks Vanity, Large Glass Shower & Huge Walk-in Closet! 2\" Inches Blinds! Energy Efficient Home(HERS Rated),Tankless Water Heater! \"Smart Home Automation System\" where you are able to control your home anywhere, Camera Doorbell, Lighting, Electric Deadbolt, Thermostat & More! NO FLOODING! Not In Flood Zone at this time! AMAZING LOW Property Taxes!' ,`Acres` = '0.18' ,`Area` = '53' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Raintree Lot: 15 /Block: 2' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch' ,`Subdivision` = 'Raintree' ,`TaxAmount` = '' ,`TaxRate` = '1.69' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665344532' WHERE `Matrix_Unique_ID` = '213313188' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-09T07:48:26.550' ,`MLSNumber` = '68938559' ,`ListAgentFullName` = 'Edward McClintick' ,`ListOfficeName` = 'Joseph Walter Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.076867' ,`Longitude` = '-94.004837' ,`PhotoCount` = '21' ,`PostalCode` = '75931' ,`RoomCount` = '6' ,`ListPrice` = '105000.00' ,`Status` = 'Active' ,`StreetName` = 'Arrowhead' ,`StreetNumber` = '120' ,`StreetSuffix` = 'Drive' ,`City` = 'Brookeland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1288' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.43' ,`Area` = '46' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 284-285 SEC 14 RAYBURN COUNTRY 0.43 ACRES' ,`LotDesciption` = 'Other' ,`LotSize` = '18731' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '144 - Brookeland' ,`SchoolElementary` = 'BROOKELAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BROOKELAND HIGH SCHOOL' ,`SchoolMiddle` = 'BROOKELAND HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Rayburn Country' ,`TaxAmount` = '980' ,`TaxRate` = '1.6721' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1665344533' WHERE `Matrix_Unique_ID` = '213421311' --> 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','213423314','1665344533','213423314','2022-10-09T06:58:24.097','10762184','Cyril Okeke','Keller Williams Hou Preferred','','','30.019954','-95.312002','25','77338','8','219900.00','Active','Kenswick Meadows','21126','Court','Humble','2','1','3','1547','Single-Family','Great opportunity to own this well maintained 2-story single family house in a nicely located subdivision in Humble TX. 3 Bedrooms, 2.5 bathrooms and 1-spaced garage on a big lot. Nice interior, very clean and warm paint color.\r\nOpen floor plan and stainless steel kitchen appliances. Nice sized bedrooms with huge windows producing natural light. Huge backyard with covered patio.\r\nNicely located, very close to Deerbrook Mall and every shopping you may want. Less 30 minutes to Downtown Houston.','0.0964','12','','','Electric Dryer Connections,Washer Connections','','Mud,Seller may be subject to foreign tax and Buyer withholding per IRS,Sellers Disclosure','1','','','Humble Area West','Central Gas','1','LT 19 BLK 4 KENSWICK MEADOWS AMEND','Subdivision Lot','4200','Appraisal District','','200','0','','1','Electric Oven','0','','','Gas Range','','Composition','1 - Aldine','CYPRESSWOOD ELEMENTARY SCHOOL (ALDINE)','NIMITZ HIGH SCHOOL (ALDINE)','JONES MIDDLE SCHOOL (ALDINE)','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Kenswick Mdws','4157','2.7433','Public Sewer,Water District','2005','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','213453256','1665344533','213453256','2022-10-09T06:50:32.887','20293267','Sarah Conway','BHGRE Gary Greene','','','30.351731','-95.527877','36','77304','9','425000.00','Active','Falcon','3580','Way','Conroe','3','1','3','2594','Single-Family','A GORGEOUS 2-story home on a spacious lot, offering privacy with no rear neighbors! This floorplan has three bedrooms and a media room that could be a fourth bedroom option on the second floor. Rich wood floors, bright sunny windows, 2-story living RM w/ gas fireplace, granite countertops & a Large Kitchen w/ Island that opens to the breakfast and living areas. Attractive owners retreat w/ spa-like bath & generous closet. Formal dining RM just off the foyer & butler bar, Game RM & sizable Secondary BRs upstairs. Extend entertaining outdoors w/ covered porch & serene backyard. This gem is tucked away in the Estates of Wedgewood Falls and just minutes from Lake Conroe where you will enjoy restaurants, shopping, entertainment, and lake life! Close to I-45 with quick access to The Woodlands and The Medical Center, you cannot beat the location!','0.1587','19','Cal Atlantic','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Lake Conroe Area','Central Electric,Zoned','1','ESTATES OF WEDGEWOOD FALLS, BLOCK 3, LOT 9','Cul-De-Sac,Subdivision Lot','6913','Appraisal District','','300','0','','2','Single Oven','0','','','Gas Range','','Composition','11 - Conroe','GIESINGER ELEMENTARY SCHOOL','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Appointment Required,Controlled Access,Request Online Appointment,Supra Keybox','Appraisal District','2','Traditional','Estates Of Wedgewood Falls','6301','2.1863','Public Sewer,Public Water','2015','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','213470414','1665344533','213470414','2022-10-09T07:48:08.813','36089388','Emily Dieckmann','Keller Williams Realty C. P.','','','30.438602','-98.012026','39','78645','4','485000.00','Active','Mount View','21338','Drive','Lago Vista','2','1','3','2264','Single-Family','Very popular floor plan on an oversized corner lot! This “treehouse” has views of Lake Travis when it is full and is shaded by tons of trees in the back. Special features include NEW CARPET, fresh paint, crown molding, roof replacement in 2009, LOTS of STORAGE, parking space for 11! Come enjoy the lake life in Lago Vista! Highly desirable location in Lago Vista. A+ rated schools: LVISD has established itself as one of the state’s top-ranking school systems, living up in every way to its “Excellence in all we do” motto. Enjoy Lago Vista’s winery, area golf courses, marinas, and performing arts. For a minimal $11/month fee, you become members in the Lago Vista Property Owners Association with exclusive access to 9 private waterfront parks, basketball court, boat ramps, campground, disc golf course, fishing well, fitness center, hiking trail, marinas, parks, pavilions, pool, athletic field, tennis courts, pickleball courts, playgrounds and more!','0.2902','83','','','','','Sellers Disclosure','','','1','','Central Electric','1','LOT 1760 COUNTRY CLUB ESTATES SEC 8','Corner,In Golf Course Community,Patio Lot','12641','Appraisal District','','150','0','','2','Electric Oven','0','','','Freestanding Range','','Composition','114 - Lago Vista','LAGO VISTA ELEMENTARY SCHOOL','LAGO VISTA HIGH SCHOOL','','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','2','Split Level,Traditional','Country Club Estates Sec 08','8708','2.4782','Public Sewer,Public Water','2001','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','213470522','1665344533','213470522','2022-10-09T07:53:10.717','58626415','Aline Clark','Exceed Realty','','','29.752684','-94.955622','0','77521','9','185000.00','Active','Midway','607','Drive','Baytown','2','0','3','1342','Single-Family','Perfect Starter Home! Spacious House with tons of Storage, Double car garage, Fully Fenced lot wih a long driveway at the end of a quite street! Big open living room with a tall ceiling, Each room has a ceiling fans, Primary Bedroom has a cute vintage vanity built in and is bright with big windows. Bonus enclosed room in the back that is not included in the sq footage of the home. Come Make this Home YOURS!','0.1661','2','','','','','Sellers Disclosure','1','','','Baytown/Harris County','Central Electric','0','TR 134A BLK 5 LT 134 LESS 6.8 FT FAIR PARK SEC 5','Cul-De-Sac','7235','Appraisal District','','','0','','2','','0','','','','','Built Up','23 - Goose Creek Consolidated','JAMES BOWIE ELEMENTARY SCHOOL (GOOSE CREEK)','STERLING HIGH SCHOOL (GOOSE CREEK)','CEDAR BAYOU J H','Accompany,Leave Business Card,Lockbox Front','Appraisal District','1','Ranch','Fair Park Sec 05','3766','2.97','Public Sewer,Public Water','1974','Seller'); --> New record created successfully