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-25T23:54:12.540' ,`MLSNumber` = '8963093' ,`ListAgentFullName` = 'Priscilla Ennis' ,`ListOfficeName` = 'RE/MAX Space Center-Clear Lake' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.570430' ,`Longitude` = '-95.040642' ,`PhotoCount` = '23' ,`PostalCode` = '77586' ,`RoomCount` = '11' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar' ,`StreetNumber` = '1010' ,`StreetSuffix` = 'Lane' ,`City` = 'El Lago' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2181' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Unique one-story, 4 bedroom, 2 bath, 2 car garage home in the highly desired El Lago subdivision. Complete kitchen remodel from the floor up with granite countertops, glass backsplash, SS appliances, modern cabinets, coffee bar, breakfast bar, gas range & oven. Recently replaced A/C & heater, microwave, range. Replaced all windows with argon gas. NO CARPET! Primary bedroom has 2 closets, adjoining updated bath, with granite countertops & tiled shower. A secondary bedroom has built-in desk nook. Formal dining with built-ins. Family room w/fireplace overlooks yard. Utility room is located next to breakfast room w/door to backyard & detached garage. New (double wide) garage door. Generously sized yard with patio. Find 3 community parks within walking distance including the El Lago pool. This house feeds into Ed White Elementary E-STEM (which is within walking distance), the Seabrook Intermediate Science Magnet School & the new Clear Lake Falls High School.' ,`Acres` = '0.2369' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 2 EL LAGO SEC 3' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '10320' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '40' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ED H WHITE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'El Lago' ,`TaxAmount` = '6164' ,`TaxRate` = '2.6666' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1963' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666781746' WHERE `Matrix_Unique_ID` = '207316840' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T22:16:34.490' ,`MLSNumber` = '90741246' ,`ListAgentFullName` = 'Marian Motamedi' ,`ListOfficeName` = 'Compass RE Texas, LLCHeights' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.766122' ,`Longitude` = '-95.525693' ,`PhotoCount` = '50' ,`PostalCode` = '77024' ,`RoomCount` = '14' ,`ListPrice` = '6085000.00' ,`Status` = 'Active' ,`StreetName` = 'Liberty Bell' ,`StreetNumber` = '18' ,`StreetSuffix` = 'Circle' ,`City` = 'Bunker Hill Village' ,`BathsFull` = '7' ,`BathsHalf` = '2' ,`BedsTotal` = '6' ,`SqFtTotal` = '9370' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Elegant Custom Home perfectly situated on 1+acre lot on a cul-de-sac in the heart of Bunker Hill Village. Wall to wall windows provide profusion of light. Exquisitely detailed high-end finishes which can only be appreciated with a personal tour. 6 Bdrms,7 full /2 half baths,Theater Rm, Office, 2 game rooms, foldable Nana door that allows for seamless entertaining between indoor and outdoor spaces. Primary wing includes kitchenette, steam shower, soaker tub and double vanity. Backyard features an outdoor kitchen, fireplace, pool/spa, lush landscaping & special canine turf area.2 Tankless Water Heaters, central vac. Full home automation system by Crestron with tablets in all rooms to control lights, window shades, TVs, AC, Audio and Security (16 cameras), 1100+bottles Wine cellar, water filtration system, built in dog kennel, Wifi Access points, 78kw Generac system. 5+car garage, front circle driveway, automatic gate, turf paver parking pad. All inclusive RV parking.' ,`Acres` = '' ,`Area` = '23' ,`BuilderName` = 'metropolitan' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'TR 6 LIBERTY BELL CIRCLE R/P' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '50860' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '5' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'MEMORIAL DRIVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Liberty Bell Circle & Rp' ,`TaxAmount` = '32421' ,`TaxRate` = '2.1656' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1666781746' WHERE `Matrix_Unique_ID` = '208478380' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T22:04:10.410' ,`MLSNumber` = '12069773' ,`ListAgentFullName` = 'Suzanne Heinrich' ,`ListOfficeName` = 'Main Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.814116' ,`Longitude` = '-94.839094' ,`PhotoCount` = '38' ,`PostalCode` = '77523' ,`RoomCount` = '5' ,`ListPrice` = '269500.00' ,`Status` = 'Active' ,`StreetName` = 'Snapping Turtle' ,`StreetNumber` = '5515' ,`StreetSuffix` = 'Road' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2326' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A must see! Come take at look at this updated, move-in ready, 4 bedrooms, 2.5 bathrooms, 2 car garage home in Barbers Hill ISD. New paint and flooring throughout, with waterproof wood-look vinyl on the first floor and new carpet on the second floor. This home features a water filtration system for the entire house and a reserve osmosis filter system in the kitchen. The open concept living area downstairs, secondary living area upstairs and fully fenced backyard make this home perfect for entertaining. Green space behind the house, so no backyard neighbors. Quick access to I-10 and Hwy 146 make for an easy commute to Baytown, Houston, or Beaumont. A neighborhood park and paved sidewalks are a bonus. This home is a short drive from local schools, restaurants, and shopping. Schedule your private showing today.' ,`Acres` = '0.126' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 33 BK 3 JOSEPHS COVE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5489' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding 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` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Joseph\'s Cove' ,`TaxAmount` = '4431' ,`TaxRate` = '1.7058' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666781746' WHERE `Matrix_Unique_ID` = '210089790' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T22:20:28.770' ,`MLSNumber` = '93143789' ,`ListAgentFullName` = 'Mohammad Khan' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.605764' ,`Longitude` = '-95.663323' ,`PhotoCount` = '32' ,`PostalCode` = '77479' ,`RoomCount` = '8' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Drake Elm' ,`StreetNumber` = '6403' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2647' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '4 Bed 2.5 Bath home located in Robinson Landing section of New Territory. Home features granite countertops in kitchen, laminate and tile flooring throughout the house (No Carpet), a large master bathroom with separate his/her vanities, and no backyard neighbors. There is plenty of natural light coming into the house to enjoy. Garage has an A/C installed to make it a living space to be enjoyed in the summer. HVAC system replaced in 2020 and Water Heater replaced in 2021. Samsung smart washer and dryer purchased in 2022 which will stay with property with all other appliances! Easy access to Hwy 90, Hwy 99, and Hwy 6. New Territory is a highly desirable community with access to 4 swimming pools, a sports complex, recreational center, and Excellent Schools! Don\'t miss this opportunity and schedule a showing today!' ,`Acres` = '0.1528' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ROBINSON LANDING SEC 1, BLOCK 1, LOT 8, R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6656' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'WALKER STATION ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'SARTARTIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Robinson Landing' ,`TaxAmount` = '6491' ,`TaxRate` = '2.4394' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1666781746' WHERE `Matrix_Unique_ID` = '210249136' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T22:49:47.837' ,`MLSNumber` = '61350924' ,`ListAgentFullName` = 'Vicky Turnbow' ,`ListOfficeName` = 'Keller Williams Elite' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '29.805131' ,`Longitude` = '-95.027081' ,`PhotoCount` = '20' ,`PostalCode` = '77521' ,`RoomCount` = '4' ,`ListPrice` = '215000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Godfrey' ,`StreetNumber` = '2119' ,`StreetSuffix` = 'Street' ,`City` = 'Baytown' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1524' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is occupied. Please do not approach or disturb tenants.**\r\n\r\nIf you need space this home is for You! Two living areas, and two entrances to this unique home. You will find ceramic tile throughout the home as well as brand new wood floors. Kitchen has been upgraded and also has several features such as storage and new fixtures and appliances. Down the hall you will find several rooms and 3 remodeled bathrooms. All the fixtures are brand new including ceiling fans and a chandelier in one of the living rooms. Home has a brand new central air conditioner and heater, new water heater and the front porch has been extended. Come see this home Today!' ,`Acres` = '0.2296' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 7 & 8 BLK 12 IN LT 7 N 1/2 OF LT 7 HIGHLAND FARMS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'HARLEM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Highland Farms' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666781746' WHERE `Matrix_Unique_ID` = '211338515' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T22:49:30.693' ,`MLSNumber` = '52403687' ,`ListAgentFullName` = 'Bobby Thomas' ,`ListOfficeName` = 'World Wide Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.084136' ,`Longitude` = '-95.260978' ,`PhotoCount` = '39' ,`PostalCode` = '77365' ,`RoomCount` = '13' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'Jaymarr' ,`StreetNumber` = '25106' ,`StreetSuffix` = 'Court' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3187' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous energy-efficient 4bdrm/2.5bath home on a premium cul de sac lot with mature trees. Walking distance to golf course. Few of the many updates include freshly painted interior, granite counters, utility room with designated sink and cabinetry, tankless water heater, mud room with built-ins, laminated wood floors, in-wall speakers in Primary room, Living, Dining areas, upstairs study with french doors plus additional private study downstairs with french doors off primary bedroom, cedar surround in primary bath w/ upgraded shower, 2 extra insulated rooms (great for man-cave or a musician), extended concrete for covered patio, extended workshop with AC, and storage shed stays. Community offers basketball courts, splash area, pool, club house, and multiple playgrounds. Low tax rate!' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood NW/Oakhurst' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BENTWOOD 01, BLOCK 8, LOT 39' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '7695' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'BENS BRANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WOODRIDGE FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bentwood' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666781746' WHERE `Matrix_Unique_ID` = '211649133' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T22:54:17.153' ,`MLSNumber` = '7117795' ,`ListAgentFullName` = 'Bobby Thomas' ,`ListOfficeName` = 'World Wide Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.649920' ,`Longitude` = '-95.582615' ,`PhotoCount` = '32' ,`PostalCode` = '77477' ,`RoomCount` = '7' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Brook Meadows' ,`StreetNumber` = '11706' ,`StreetSuffix` = 'Lane' ,`City` = 'Meadows Place' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1819' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this charming 3 bedroom, 2 bath one-story home in the City of Meadows Place. Kitchen completely updated with quartz countertops, elegant & stylish backsplash, and new stainless steel farmhouse sink, microwave, and dishwasher. Freshly painted, newly laid LVP flooring w/ upgraded 5 inch wood baseboards. Primary bathroom updated with modern fixtures and quality designer tile in shower. Lawn is easily manageable. Meadows Place has a lot to offer including tennis courts, parks, pools, discover & nature center, stocked lake with trout, & it\'s own Police Dept and EMS. Zoned to Ft Bend ISD and recently built, state of the art Meadows Elem School. Walking distance to Starbucks and Aldi grocery store. Mins to restaurants and shopping. Quick access to I-69 and Beltway 8 and new 192-acre commercial development, the Grid. NO HOA! LOW TAXES!' ,`Acres` = '0.1191' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Stafford Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'MEADOWGLEN SEC 1, BLOCK 6, LOT 18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5186' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'MEADOWS ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meadowglen' ,`TaxAmount` = '5197' ,`TaxRate` = '2.4949' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666781747' WHERE `Matrix_Unique_ID` = '211654896' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T23:01:40.593' ,`MLSNumber` = '45305819' ,`ListAgentFullName` = 'Oscar Martinez' ,`ListOfficeName` = 'Texas Sol Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.972851' ,`Longitude` = '-95.116865' ,`PhotoCount` = '31' ,`PostalCode` = '77532' ,`RoomCount` = '4' ,`ListPrice` = '293999.00' ,`Status` = 'Active' ,`StreetName` = 'Running Bear' ,`StreetNumber` = '1823' ,`StreetSuffix` = 'Trail' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1889' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a must see home! Completely remodeled from the inside and minutes away from the lake. Uniform porcelain tile throughout, open concept with recess lighting makes this beautiful corner lot home perfect for entertaining. The home has never flooded and has a two year roof. This home has no back neighbors so it provides a country feel with contemporary finishes. Don\'t miss out on making this beautiful home yours and book your appointment today!' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT1 BLK 10 Indian Shores' ,`LotDesciption` = 'Corner' ,`LotSize` = '19855' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'NEWPORT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Colonial,Contemporary/Modern' ,`Subdivision` = 'Indian Shores' ,`TaxAmount` = '' ,`TaxRate` = '2.67' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666781747' WHERE `Matrix_Unique_ID` = '211691401' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T23:25:00.430' ,`MLSNumber` = '71613556' ,`ListAgentFullName` = 'Ashley White' ,`ListOfficeName` = 'Kimberly Beggs' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.780170' ,`Longitude` = '-95.323747' ,`PhotoCount` = '22' ,`PostalCode` = '77020' ,`RoomCount` = '7' ,`ListPrice` = '130000.00' ,`Status` = 'Active' ,`StreetName` = 'Yates' ,`StreetNumber` = '2120' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '864' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great investment property in an even better location!! Surrounded by new home construction and just minutes away from Downtown Houston and the East Downtown Mix-Use Project. Home is just around the corner from the highly acclaimed Atherton Elementary school. Home has never flooded. Don\'t miss your opportunity to own a great income generating property near downtown.' ,`Acres` = '0.1148' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 94 AUGUSTA' ,`LotDesciption` = 'Other' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ATHERTON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'FLEMING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Left Side,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Augusta' ,`TaxAmount` = '3748' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1936' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666781747' WHERE `Matrix_Unique_ID` = '212045074' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T22:37:58.527' ,`MLSNumber` = '22492837' ,`ListAgentFullName` = 'Mingcen Wei' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.717366' ,`Longitude` = '-95.787640' ,`PhotoCount` = '44' ,`PostalCode` = '77494' ,`RoomCount` = '7' ,`ListPrice` = '1039800.00' ,`Status` = 'Active' ,`StreetName` = 'San Nicholas' ,`StreetNumber` = '23106' ,`StreetSuffix` = 'Place' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4623' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Roof replaced 2022. Fresh paint most place of interior and exterior. recent deep clean and sanitized carpet.\r\n Stunning Taylor Woodrow custom two story home located in the highly exclusive gated community of Avalon at Seven Meadows. This home offers endelss upgrades as well as a gorgeous backyard oasis with a sparkeling pool/spa and views of the lake. Grand 2-story entry with study, formal dining, spacious family, Granite island kitchen and a guest suite with individual entrance. Master retreat with views of the pool/lake and handsome ensuite bath. Gameroom and media room and private balcony are located upstairs. Home has many upgrades including a central vacuum!' ,`Acres` = '0.2501' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'AVALON AT SEVEN MEADOWS SEC 5, BLOCK 1, LOT 18' ,`LotDesciption` = 'Water View' ,`LotSize` = '10895' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'GRIFFIN ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'SEVEN LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'BECKENDORFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Avalon At Seven Meadows Sec 5' ,`TaxAmount` = '17612' ,`TaxRate` = '2.3845' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666781747' WHERE `Matrix_Unique_ID` = '212129224' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T22:29:11.673' ,`MLSNumber` = '13411009' ,`ListAgentFullName` = 'Trenda Carlisle' ,`ListOfficeName` = 'Fathom Realty' ,`SellingAgentFullName` = 'Kathryn Stakes' ,`SellingOfficeName` = 'Synergy Real Estate' ,`Latitude` = '30.428287' ,`Longitude` = '-95.578938' ,`PhotoCount` = '21' ,`PostalCode` = '77318' ,`RoomCount` = '6' ,`ListPrice` = '337500.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Virgo' ,`StreetNumber` = '12775' ,`StreetSuffix` = 'Drive' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1845' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A Must See! Lovely Stone and Stucco 3 Bedroom 2 Bath Home with additional approx. 160 feet long driveway and custom built back porch covered patio/bar in Lakefront Community with many amenities including Marina, Boat Ramps and Swimming Pools, Community Center and more *Galley Kitchen with oversized Granite Bar & Stainless Appliance Package makes cooking here fun *Spacious Living Room w additional seating area *Grand Foyer *Nice Breakfast Room & More *Primary Suite offers soaking tub w separate shower, oversized vanity *spacious closet *2 additional Bedrooms & Guest Bathroom *Utility closet off kitchen *2 car attached garage *Large lot enjoys mature majestic trees and privacy fenced backyard *RV, Boat, etc. parking in additional driveway *Solar Screens *Minutes to Lake Conroe *Nearby shopping *Willis ISD *Easy commute to I45 *Nearby Medical Facilities *Easily commute to several Colleges *Hurry' ,`Acres` = '0.2066' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'POINT AQUARIUS 06, BLOCK 5, LOT 28' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '9000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1020' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Point Aquarius' ,`TaxAmount` = '5166' ,`TaxRate` = '2.3849' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666781747' WHERE `Matrix_Unique_ID` = '212196321' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T23:07:47.733' ,`MLSNumber` = '98550486' ,`ListAgentFullName` = 'Jenine Cinco' ,`ListOfficeName` = 'Kay Stimson Properties , LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.213283' ,`Longitude` = '-95.589607' ,`PhotoCount` = '45' ,`PostalCode` = '77354' ,`RoomCount` = '12' ,`ListPrice` = '535000.00' ,`Status` = 'Active' ,`StreetName` = 'Bear Mountain' ,`StreetNumber` = '8907' ,`StreetSuffix` = 'Court' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3648' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UPGRADES GALORE and GENEROUS BACKYARD. Gorgeous 4 bedroom, 3.5 bath PLUS media and game room. 3,648 sqft, OVERSIZED, CUL DE SAC LOT, built in 2019. Brick and stone exterior with covered front porch and back patio. 2-story foyer with elegant ENGINEERED OAK WOOD floors. ABUNDANT NATURAL LIGHT and RAISED CEILINGS throughout. Open floor plan kitchen with GRANITE countertops, SS appliances, GAS cooktop and DOUBLE OVEN. Primary suite DOWN has expanded floor plan, oversized bath with double vanities, separate shower and soak tub. Second floor features a GUEST BEDROOM W/ ENSUITE BATH, 2 extra guest suites and a shared full bath. Media room plus a separate game room UP. Water softener, Sprinkler System, 3 min. drive to HEB, zoned to Magnolia ISD. Fully fenced backyard with room for pool. We cannot wait to see you! Schedule a preview today.' ,`Acres` = '0.226' ,`Area` = '15' ,`BuilderName` = 'KB Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S341107 - CIMARRON CREEK 07, BLOCK 2, LOT 23' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '9843' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '965' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'BEAR BRANCH ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cimarron Creek' ,`TaxAmount` = '6397' ,`TaxRate` = '3.1887' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666781748' WHERE `Matrix_Unique_ID` = '212233068' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T23:56:31.080' ,`MLSNumber` = '38211010' ,`ListAgentFullName` = 'Angela Revis' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.725518' ,`Longitude` = '-95.368899' ,`PhotoCount` = '8' ,`PostalCode` = '77004' ,`RoomCount` = '6' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Wheeler' ,`StreetNumber` = '2612' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1860' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nice 3 bedroom 2 full bathrooms with detached Garage, fireplace, original hardwood floors in excellent condition, home currently in good livable condition. Roof in great condition approximately 5-8 years old All windows replaced approximately 2-3 years ago' ,`Acres` = '0.1326' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Gas,Space Heater' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 22 WASHINGTON TERRACE' ,`LotDesciption` = 'Corner' ,`LotSize` = '5775' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOCKHART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Washington Terrace' ,`TaxAmount` = '3763' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1939' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666781748' WHERE `Matrix_Unique_ID` = '212363244' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T22:02:47.713' ,`MLSNumber` = '8217134' ,`ListAgentFullName` = 'Daisy Guzman' ,`ListOfficeName` = 'Texas Legacy Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.833522' ,`Longitude` = '-95.357455' ,`PhotoCount` = '11' ,`PostalCode` = '77022' ,`RoomCount` = '2' ,`ListPrice` = '319999.00' ,`Status` = 'Active' ,`StreetName` = 'Apache' ,`StreetNumber` = '1202' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '841' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come take a look at this rare opportunity just right outside the loop! This property wont last long. Almost 3/4 of an acre of cleared land. Endless opportunities. The main house is currently occupied which can be remodeled for the perfect home or for a Builder. The property also includes a 1200 sqft metal building with high ceilings that can easily be transformed into a work station or Rv/Boat/car storage. Easy to access hardy and other major highways. Buyer to do own due diligence.' ,`Acres` = '0.6884' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 11 & 12A ABST 163 J S BLACK' ,`LotDesciption` = 'Cleared' ,`LotSize` = '29987' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'JANOWSKI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SAM HOUSTON MATH SCIENCE AND TECHNOLOGY CENTER' ,`SchoolMiddle` = 'BURBANK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,English,Other Style,Traditional' ,`Subdivision` = 'Abst 163 J S Black' ,`TaxAmount` = '3935' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1927' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666781748' WHERE `Matrix_Unique_ID` = '212661674' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T23:02:34.023' ,`MLSNumber` = '16211498' ,`ListAgentFullName` = 'Patti Bodkins' ,`ListOfficeName` = 'ARG Real Estate, LLC' ,`SellingAgentFullName` = 'Isaias Contreras' ,`SellingOfficeName` = 'Keller Williams Signature' ,`Latitude` = '29.675797' ,`Longitude` = '-95.215897' ,`PhotoCount` = '38' ,`PostalCode` = '77502' ,`RoomCount` = '7' ,`ListPrice` = '192000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Queens' ,`StreetNumber` = '707' ,`StreetSuffix` = 'Road' ,`City` = 'Pasadena' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1383' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This mid-century home is ready to enjoy. Freshly painted inside and out, original wood floors in all the bedrooms and den. New gas stove purchased in 2022, dishwasher 2020, water heater 2019, PEX pipes 2019. Located near recently built schools. \r\nConveniently located close to I-45 and Hwy 225.' ,`Acres` = '0.1653' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 14 BLK 1 SKYLARK TERRACE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'L F SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PASADENA HIGH SCHOOL' ,`SchoolMiddle` = 'QUEENS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Skylark Terrace Sec 02' ,`TaxAmount` = '3334' ,`TaxRate` = '2.6514' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666781748' WHERE `Matrix_Unique_ID` = '212750271' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T22:23:46.980' ,`MLSNumber` = '98736065' ,`ListAgentFullName` = 'Adnew Tadesse' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.696978' ,`Longitude` = '-95.784163' ,`PhotoCount` = '40' ,`PostalCode` = '77406' ,`RoomCount` = '9' ,`ListPrice` = '639990.00' ,`Status` = 'Active' ,`StreetName` = 'San Ricci' ,`StreetNumber` = '23527' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3158' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful 4/3/1 Ashfton Home features a Hi-Tech Wi-Fi heated swimming pool & jacuzzi, an outdoor grill & wine cooler, covered patio with TV makes great for entertainment and gathering with family and friends, grand entry with 20\' ceiling, upgraded iron stair railing, a beautiful rotunda ceiling in the middle of the home, covered gourmet kitchen with large island, spacious family room with two story ceiling, large primary bedroom with bay window, primary bath with a separate shower and tub, large closets, game room and media room next to each other, secondary bedroom with balcony overlooking front area, home office or study room and many more to list. Community features resort style amenities and a convenient location at the corner of Westpark Tollway & Grand Parkway 99.' ,`Acres` = '0.1452' ,`Area` = '37' ,`BuilderName` = 'Ashton Woods' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKES OF BELLA TERRA SEC 33, BLOCK 1, LOT 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6325' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1195' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUBENAK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes/Bella Terra' ,`TaxAmount` = '10507' ,`TaxRate` = '3.0848' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666781748' WHERE `Matrix_Unique_ID` = '212797658' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T23:46:22.220' ,`MLSNumber` = '14682852' ,`ListAgentFullName` = 'Mary Dover' ,`ListOfficeName` = 'Coldwell Banker Realty, Cy-Fair Office' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.957121' ,`Longitude` = '-95.599173' ,`PhotoCount` = '39' ,`PostalCode` = '77429' ,`RoomCount` = '9' ,`ListPrice` = '292900.00' ,`Status` = 'Active' ,`StreetName` = 'Serendipity' ,`StreetNumber` = '11802' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2136' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Get your creative juices flowing at this magnificent Cypress home. Zoned for Millsap Elementary, Hamilton Middle and CyCreek High, the location of this little neighborhood is minutes from area conveniences, shopping and of course great for commuting. Minutes to 249, 290 and 1960, this home is nestled back near all parks and recreational activities. This split floorplan makes it ideal for the average person and the landscape is great for entertaining. Primary bedroom down with a magnificent bathroom that is a great way to relax after a long day of work. Soak in your claw foot tub, modern shower with the rain feature, a nice size vanity with bult in storage and large organized closet. As you enter the primary bedroom, you will see the set of French doors that can lead you to your stone paved back patio. Gas cooking in your large kitchen with an island and modern light fixtures. Upstairs, there are 3 additional bedrooms with one full bath. Look at the extraordinarily low tax rate!' ,`Acres` = '0.1768' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 1 TOWER OAK BEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '675' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MILLSAP ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tower Oak Bend' ,`TaxAmount` = '4013' ,`TaxRate` = '2.1637' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666781749' WHERE `Matrix_Unique_ID` = '213004065' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T23:19:39.633' ,`MLSNumber` = '15819944' ,`ListAgentFullName` = 'Alejandro Carrillo' ,`ListOfficeName` = 'Fratelli Properties International' ,`SellingAgentFullName` = 'Leigh Beard' ,`SellingOfficeName` = 'Coldwell Banker Realty, Cy-Fair Office' ,`Latitude` = '30.150848' ,`Longitude` = '-95.652247' ,`PhotoCount` = '50' ,`PostalCode` = '77362' ,`RoomCount` = '10' ,`ListPrice` = '450000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Hillside' ,`StreetNumber` = '33603' ,`StreetSuffix` = 'Drive' ,`City` = 'Pinehurst' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2171' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Situated in the fabulous Britwood Estates, this one story, 4 bedrooms and 2 baths home will impress you from the moment you arrive! Step inside and be greeted by the formal dining room area. Open design kitchen is equipped with stainless steel appliances, gas cooktop, gorgeous bold cabinets, & granite countertops. The kitchen overlooks the family room for an open concept. Live in a quiet, private, country setting without the hassles of big city living. This is your opportunity. This property has 1.5 acres fully fenced with lots of privacy. Backdoor leads out to the sprawling covered patio, enjoy outdoor entertaining and warm summer nights! Super low tax rate, not in the flood zone and is ready for a new owner to call home.' ,`Acres` = '1.5181' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'BRITWOOD ESTATES, BLOCK 1, LOT 1, ACRES 1.5181' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '66128' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Britwood Estates' ,`TaxAmount` = '3522' ,`TaxRate` = '1.9215' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666781749' WHERE `Matrix_Unique_ID` = '213016107' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T22:45:06.493' ,`MLSNumber` = '61278777' ,`ListAgentFullName` = 'Betty Taylor' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.562685' ,`Longitude` = '-95.338090' ,`PhotoCount` = '18' ,`PostalCode` = '77581' ,`RoomCount` = '10' ,`ListPrice` = '340000.00' ,`Status` = 'Active' ,`StreetName` = 'Stone Arbor' ,`StreetNumber` = '7614' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2020' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Open & bright 3/2/2. Nice entry with art nooks, columns & arched door ways. Study with glass doors, split bedrooms, large kitchen, breakfast room open den w/fireplace, separate tub & shower in master, formal dining, covered patio and fenced yard. Ready for fast move-in.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'AVALON TERRACE SEC 2 (A0505 H T & B) BLK 1 LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'LAWHON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GLENDA DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH WEST' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'AVALON TERRACE SEC 2 (A0505' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666781749' WHERE `Matrix_Unique_ID` = '213081010' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T23:47:05.010' ,`MLSNumber` = '61482350' ,`ListAgentFullName` = 'Jay Bradley' ,`ListOfficeName` = 'Equinox Realty Group' ,`SellingAgentFullName` = 'Viktoriya Harari' ,`SellingOfficeName` = 'Delux Realty, LLC' ,`Latitude` = '29.613169' ,`Longitude` = '-95.233542' ,`PhotoCount` = '19' ,`PostalCode` = '77089' ,`RoomCount` = '5' ,`ListPrice` = '229990.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Buena Park' ,`StreetNumber` = '10215' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1582' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This house is newly updated throughout. Welcome home to 10215 Buena Park Drive, this one story has been packed with luxury features that include Luxury Vinyl flooring throughout, Stainless steel appliances, Hvac and elegant lighting package. The Primary Bedroom features dual walk-in closets, and freshly redesigned bathroom. The seller has made this home a dream to tour and its ready for your private showing.' ,`Acres` = '0.161' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 29 BLK 16 BEVERLY HILLS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7015' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'BEVERLYHILLS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Beverly Hills' ,`TaxAmount` = '3662' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666781749' WHERE `Matrix_Unique_ID` = '213082480' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T22:03:18.760' ,`MLSNumber` = '83701987' ,`ListAgentFullName` = 'Daisy Guzman' ,`ListOfficeName` = 'Texas Legacy Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.785697' ,`Longitude` = '-95.353761' ,`PhotoCount` = '17' ,`PostalCode` = '77009' ,`RoomCount` = '5' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Chapman' ,`StreetNumber` = '2706' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1824' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location Location Location!!! This Property is in one of the Hottest upcoming neighborhoods in Houston. Just blooks from the inner loop , Heights area and downtown Houston. This fully remodeled crafts-man style home features 4 bedrooms 2 bath, stainless steel appliances, custom cabinets, quartz countertops. With spacious kitchen that flows nicely into the open concept living room area creating a perfect space for entertainment. House is fully fenced with automatic gate opener for your convenience. This house wont last long! Give me a call to schedule an appointment.' ,`Acres` = '0.1453' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 4 5 & 11B BLK 223 RYON' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6331' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MARTINEZ C ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Craftsman,Other Style,Traditional' ,`Subdivision` = 'Ryon' ,`TaxAmount` = '4958' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666781750' WHERE `Matrix_Unique_ID` = '213162585' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T23:02:19.500' ,`MLSNumber` = '27547761' ,`ListAgentFullName` = 'Lucia Clark' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.036307' ,`Longitude` = '-95.617068' ,`PhotoCount` = '47' ,`PostalCode` = '77377' ,`RoomCount` = '11' ,`ListPrice` = '468000.00' ,`Status` = 'Active' ,`StreetName` = 'Canyon Vista' ,`StreetNumber` = '19114' ,`StreetSuffix` = 'Court' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3103' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! This stunning two story, 4 bedroom, 2.5 bath home with a pool/spa is located on a culdesac street in the gated community of Canyon Gate at Northpointe. This home oozes with curb appeal with the covered front porch seating area to the long driveway leading up to the detached garage. The open floorplan allows for plenty of room for entertaining. The primary bedroom suite is absolutely breathtaking. The primary bath was recently updated in 2022. The backyard is a true oasis with the large sparkling pool, relaxing hot tub, gas firepit and plenty of seating areas as well as grass area. You will not only be amazed by the size of the this property, but also the amount of storage space it has as well. Each bedroom is equipped with fabulous walk-in closet space. Commuting to work is a breeze with easy access to Hwy 249 and 99. You are surrounded by fabulous shops and restaurants! This home is located in the highly acclaimed Tomball ISD. Schedule your appointment TODAY!' ,`Acres` = '0.2685' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 2 CANYON GATE AT NORTHPOINTE SEC 9' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '11697' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1149' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'CANYON POINTE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Gate At Northpointe' ,`TaxAmount` = '9552' ,`TaxRate` = '2.9165' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666781750' WHERE `Matrix_Unique_ID` = '213224173' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T23:18:28.670' ,`MLSNumber` = '29881417' ,`ListAgentFullName` = 'Karen Hoffpauir' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.965100' ,`Longitude` = '-94.011088' ,`PhotoCount` = '24' ,`PostalCode` = '77627' ,`RoomCount` = '7' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Mimosa' ,`StreetNumber` = '1007' ,`StreetSuffix` = 'Drive' ,`City` = 'Nederland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2262' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This house is a must see! So gorgeous and the perfect location! Beautiful home located in Helena Park Edition of Nederland. This is a wonderful neighborhood close to schools and shopping. This lovely 4 bedroom 2 bath home has been completely remodeled. The roof and garage door have been replaced and are windstorm certified. All windows have been replaced and are windstorm certified as well. New AC/ Gas heating. All new sheetrock and insulation, all new interior and exterior doors , trim, all new cabinets, quartz countertops and all new appliances. The home is accented with matte black handles and fixtures. Primary bath has a free standing tub and shower, and hall bath has a shower/tub combo, with a deep soaking bath tub. The home has so much natural light from all of the windows and the beautiful patio doors. There is so much storage . Vinyl plank flooring .The home is owned by the listing agent, Karen Hoffpauir, with EXP Realty.' ,`Acres` = '0.2235' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'HELENA PARK LT 4 BLK 2' ,`LotDesciption` = 'Other' ,`LotSize` = '9734' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '152 - Nederland' ,`SchoolElementary` = 'HELENA PARK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEDERLAND HIGH SCHOOL' ,`SchoolMiddle` = 'WILSON MIDDLE SCHOOL (NEDERLAND)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Back,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Helena Park 1' ,`TaxAmount` = '4913' ,`TaxRate` = '2.4292' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666781750' WHERE `Matrix_Unique_ID` = '213227229' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T22:56:28.363' ,`MLSNumber` = '94442024' ,`ListAgentFullName` = 'Rodney Thorin' ,`ListOfficeName` = 'RE/MAX Northwest, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.956707' ,`Longitude` = '-95.485927' ,`PhotoCount` = '28' ,`PostalCode` = '77066' ,`RoomCount` = '7' ,`ListPrice` = '198500.00' ,`Status` = 'Active' ,`StreetName` = 'Derbyhall' ,`StreetNumber` = '3806' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1484' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'An absolutely darling 1-1/2 story home just waiting for its SECOND owner. A very livable floorplan with spacious Den, eat-in Kitchen, and two Bedrooms and two Bathrooms downstairs and an oversized 3rd Bedroom/Game Room/Study upstairs. Off the Den is a lovely Patio and the backyard is a gardener\'s dream with raised beds as well as blooming and fruit-bearing plants. The house is ready for a new owner to put their own touches and details. The big stuff is all taken care of - new siding, fresh paint, newer HVAC (2018), newer water heater (2015), newer roof (2017) - all you need is to pick your new flooring! Don\'t miss this fantastic opportunity for a home of your own on a cul-de-sac in a quiet, established neighborhood. Schedule your private showing TODAY!' ,`Acres` = '0.1279' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 6 NORTHCLIFFE MANOR SEC 6' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5572' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '215' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KAISER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'WUNDERLICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Northcliffe Manor' ,`TaxAmount` = '3297' ,`TaxRate` = '2.7365' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666781750' WHERE `Matrix_Unique_ID` = '213246391' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T23:37:59.110' ,`MLSNumber` = '94633315' ,`ListAgentFullName` = 'Zheng Zhuang' ,`ListOfficeName` = 'KingFay Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.734023' ,`Longitude` = '-95.877497' ,`PhotoCount` = '30' ,`PostalCode` = '77494' ,`RoomCount` = '4' ,`ListPrice` = '389000.00' ,`Status` = 'Active' ,`StreetName` = 'Austins' ,`StreetNumber` = '3815' ,`StreetSuffix` = 'Pass' ,`City` = 'Fulshear' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2082' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Must see! Lake views house. comes with a fridge, washer, and dryer, and the owner will take care of the dead lawn before conveying, owner is also open to selling the furniture. This is the DR Horton Kingston plan is a one-story home featuring 4 bedrooms, 2 baths, and 2 car garage. The entry opens to the guest bedrooms, a bath with a linen closet. The Center kitchen includes an oversized breakfast bar with beautiful countertops and stainless steel appliances. The open concept floorplan boasts a large combined family room and dining area. The owner\'s suite features a sloped ceiling and an attractive master bath with dual vanities, a water closet, and a walk-in closet. The standard rear-covered patio is located off the family room.' ,`Acres` = '0.1492' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TAMARRON SEC 14, BLOCK 1, LOT 28' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '6500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'TAMARRON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Other Style' ,`Subdivision` = 'Tamarron Sec 14' ,`TaxAmount` = '4668' ,`TaxRate` = '3.0648' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666781750' WHERE `Matrix_Unique_ID` = '213268841' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T22:25:11.187' ,`MLSNumber` = '23613570' ,`ListAgentFullName` = 'Juan Miranda' ,`ListOfficeName` = 'Mission Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.517884' ,`Longitude` = '-96.664637' ,`PhotoCount` = '8' ,`PostalCode` = '78950' ,`RoomCount` = '3' ,`ListPrice` = '199000.00' ,`Status` = 'Active' ,`StreetName` = 'Bluebonnet' ,`StreetNumber` = '103' ,`StreetSuffix` = 'Bend' ,`City` = 'Sheridan' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '768' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.44' ,`Area` = '56' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 24 LAKE SHERIDAN & HOUSE' ,`LotDesciption` = 'Other' ,`LotSize` = '19166' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '161 - Rice Consolidated' ,`SchoolElementary` = 'SHERIDAN ELEMENTARY SCHOOL (RICE CISD)' ,`SchoolHigh` = 'RICE HIGH SCHOOL (RICE CISD)' ,`SchoolMiddle` = 'RICE JUNIOR HIGH SCHOOL (RICE CISD)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Sheridan' ,`TaxAmount` = '2171' ,`TaxRate` = '1.8372' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666781751' WHERE `Matrix_Unique_ID` = '213308832' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T22:48:09.980' ,`MLSNumber` = '69971757' ,`ListAgentFullName` = 'Cindy Page' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.979855' ,`Longitude` = '-95.116136' ,`PhotoCount` = '23' ,`PostalCode` = '77532' ,`RoomCount` = '10' ,`ListPrice` = '314900.00' ,`Status` = 'Active' ,`StreetName` = 'White Feather' ,`StreetNumber` = '2103' ,`StreetSuffix` = 'Trail' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '2584' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming home in Crosby\'s established lakeside community of Indian Shores. This beautiful residence has been renovated and remodeled since it was originally purchased in 2010 and is move in ready! It is on the golf course and features 2 Bedrooms, 2 Bath, a loft on the second floor with two closet\'s overlooking the golf course, an oversized entertainment room with the golf course view and huge backyard, wet bar, kitchen with new granite countertops and subway tile backsplash, stone fireplace, a two-car oversized garage, an outdoor shed with built in shelves, and rests neatly on a large lot.' ,`Acres` = '0.3223' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 28 INDIAN SHORES SEC 5' ,`LotDesciption` = 'In Golf Course Community,On Golf Course' ,`LotSize` = '14040' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '20' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'NEWPORT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Indian Shores' ,`TaxAmount` = '5569' ,`TaxRate` = '2.7056' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1666781751' WHERE `Matrix_Unique_ID` = '213404588' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T22:38:16.733' ,`MLSNumber` = '63044138' ,`ListAgentFullName` = 'Tamatha Mayfield' ,`ListOfficeName` = 'Lucky Money Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.164792' ,`Longitude` = '-95.293896' ,`PhotoCount` = '26' ,`PostalCode` = '77357' ,`RoomCount` = '4' ,`ListPrice` = '294000.00' ,`Status` = 'Active' ,`StreetName` = 'Timbermill' ,`StreetNumber` = '18357' ,`StreetSuffix` = 'Lane' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1880' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming one-story home in New Caney located in the Porters Mill community. This 4-bedroom, 2-bath home is Smart Home ready with a beautiful open floor plan. You have upgraded features like a complete sprinkler system front and back, granite countertops in the kitchen with endless hot water with your tankless water heater in the garage. Relax after a long day in your huge master bedroom with a gorgeous master bathroom featuring double sinks, a separate bathtub, a standing shower, and a massive walk-in closet. Enjoy your backyard on your covered patio on those beautiful days out back after a long day. The community features a beautiful neighborhood pool with a splash pad area with lifeguards onsite and a playground. You are within close proximity to local grocery stores, shopping centers, and restaurants!' ,`Acres` = '0.1382' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S812702 - PORTERS MILL 02, BLOCK 4, LOT 21' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6020' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'ROBERT CRIPPEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Porters Mill 02' ,`TaxAmount` = '6324' ,`TaxRate` = '3.0331' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666781751' WHERE `Matrix_Unique_ID` = '213447151' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T23:31:52.077' ,`MLSNumber` = '96122406' ,`ListAgentFullName` = 'Ishme Allah' ,`ListOfficeName` = 'Village Property Advisors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.434630' ,`Longitude` = '-95.417233' ,`PhotoCount` = '48' ,`PostalCode` = '77583' ,`RoomCount` = '12' ,`ListPrice` = '999900.00' ,`Status` = 'Active' ,`StreetName` = 'Coastal' ,`StreetNumber` = '10227' ,`StreetSuffix` = 'Court' ,`City` = 'Iowa Colony' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4196' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you\'re looking for a home that has it all, look no further! This home is packed with goodies and upgrades that are sure to check all your boxes and more. A few of the added amenities include a whole home generator with plenty of power to run the entire home, water softener system that eliminates hard water issues, storm shutters to protect your home no matter what Mother Nature has in store, premium camera system to ensure your protected whether at home or away and a bolted safe to store your valuables. Also features designer touches from wall molding and accent walls to custom 20 foot curtains. Last but not least the backyard has a resort style pool and patio that will make you never want to leave. Schedule your showing today, you will not be disappointed!' ,`Acres` = '0.4857' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MERIDIANA SEC 65 (A0513 HT&BRR) (IOWA COLONY) BLK 1 LOT 24 (' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '21157' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean,Traditional' ,`Subdivision` = 'Meridiana Sec 65' ,`TaxAmount` = '24430' ,`TaxRate` = '3.6249' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666781751' WHERE `Matrix_Unique_ID` = '213450670' --> 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','213518154','1666781751','213518154','2022-10-25T23:18:47.873','86744961','Alan Herrera','Walzel Properties','','','29.809833','-95.168877','13','77049','14','430000.00','Active','Banter Trails','307','Drive','Houston','2','1','5','4268','Single-Family','****NO Showings until November 1st. ****\r\n\r\nGreat opportunity to own a home with too multiple updates. Freshly painted inside out, new carpet, appliances updated kitchen. One of a kind for sure.','0.187','2','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','North Channel','Central Gas','1','LT 15 BLK 9 PLANTATION AT WOODFOREST SEC 4','Subdivision Lot','8145','Appraisal District','','485','0','','2','Freestanding Oven','1','In Ground','','Freestanding Range','','Composition','21 - Galena Park','DR SHIRLEY J WILLIAMSON ELEMENTARY SCHOOL','NORTH SHORE SENIOR HIGH SCHOOL','NORTH SHORE MIDDLE SCHOOL','Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox','Appraisal District','2','Traditional','Plantation At Woodforest','8122','2.9394','Public Sewer,Public Water','2000','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','213570503','1666781751','213570503','2022-10-25T22:36:27.910','66167450','Patrice Hightower','HomeSmart','','','29.550019','-95.380579','47','77584','12','592000.00','Active','Newbury','2710','Court','Pearland','3','1','5','3948','Single-Family','Spacious and elegant 5 bedroom golf course home in Sheldon Cove - only 2 streets in the subdivision so it feels like you’re entering a private retreat in the middle of Pearland. Peaceful backyard view of the 16th hole and beautifully landscaped garden from primary, living and family room! Large primary bedroom suite AND the secondary bedrooms are spacious as well; elbow room for everyone! Recent updates include new HVAC, Generac standby generator, GE double oven and hot water heater. Kitchen has large island, double ovens, breakfast room and lots of counter space. Office/study, formal living with fireplace, dining room, family room, upstairs game room. Lovely back garden to fuel your inner gardener. Plenty of room for all your interests. Upstairs bedrooms are on opposite side of house so there’s a feeling of privacy. Neighborhood pool and water play area, recreation room and golf course. Close to restaurants, shopping and Hwy 288. Make this great home your own!','0.2587','5','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Pearland','Central Gas','1','SHELDON COVE AT SILVERLAKE (A0539 HT&BRR), BLOCK 1, LOT 19,','Cul-De-Sac','11269','Appraisal District','','753','0','','3','Double Oven,Electric Oven','0','','','Gas Cooktop','','Composition','42 - Pearland','SILVERCREST ELEMENTARY SCHOOL','GLENDA DAWSON HIGH SCHOOL','BERRY MILLER JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','2','Traditional','Sheldon Cove At Silverlake','10436','2.3537','Water District','1998','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T22:28:28.820' ,`MLSNumber` = '57140815' ,`ListAgentFullName` = 'Thao Thi Nguyen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.681243' ,`Longitude` = '-95.652609' ,`PhotoCount` = '34' ,`PostalCode` = '77083' ,`RoomCount` = '5' ,`ListPrice` = '349500.00' ,`Status` = 'Active' ,`StreetName` = 'High Haven Dr' ,`StreetNumber` = '8918' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2564' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2 stories home in the heart of the peaceful Providence community which features 4 bedrooms and a study room, detached garage with long drive way. Primary and study room downstairs. Tile flooring in the family, kitchen and bathrooms; laminate flooring in the bedrooms, study, and dining. The bright living room features high ceiling with decorative wall over the fireplace, looking out to the gorgeous backyard where there is plenty of space for family outdoor gathering. Best of all, your family will have lots of quality time in the spacious kitchen. Schedule your showing TODAY.' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PROVIDENCE SEC 3, BLOCK 5, LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8377' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'FLEMING ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'KEMPNER HIGH SCHOOL' ,`SchoolMiddle` = 'HODGES BEND MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Providence' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666781751' WHERE `Matrix_Unique_ID` = '213585496' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T23:54:24.190' ,`MLSNumber` = '25660285' ,`ListAgentFullName` = 'Edgar Jammer' ,`ListOfficeName` = 'Jammer Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.940778' ,`Longitude` = '-95.206708' ,`PhotoCount` = '32' ,`PostalCode` = '77346' ,`RoomCount` = '8' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Golden Oasis' ,`StreetNumber` = '12119' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2444' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this beautiful energy efficient 4 bedroom,3.5 bath home in Humble, TX today. This spacious home features granite countertops in the kitchen, a walk-in pantry, large primary bedroom with a garden tub and separate shower in the bathroom, a game room, and energy efficient Low-E windows and tech-shield. Have your REALTOR show you this home today before it\'s gone!' ,`Acres` = '0.1324' ,`Area` = '1' ,`BuilderName` = '' ,`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 7 BLK 1 SUNSET RIDGE SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5768' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`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,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunset Ridge' ,`TaxAmount` = '7294' ,`TaxRate` = '3.0673' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666781752' WHERE `Matrix_Unique_ID` = '213687810' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T23:15:34.637' ,`MLSNumber` = '37932017' ,`ListAgentFullName` = 'CHUCK EJIM' ,`ListOfficeName` = 'Discovered Homes Inv. Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.673751' ,`Longitude` = '-95.491313' ,`PhotoCount` = '49' ,`PostalCode` = '77096' ,`RoomCount` = '9' ,`ListPrice` = '465000.00' ,`Status` = 'Active' ,`StreetName` = 'Queensloch' ,`StreetNumber` = '5834' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2174' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming Maplewood South home transformed into a sleek, contemporary design. Upon entry you are greeted with gleaming flooring that sets the tone for the neutral, warm color palette throughout. Dining area was built in with the entertainer in mind. Stainless steel appliances, gracious prep space, sleek Quartz countertops, and abundant storage entice your inner chef! Natural light flows in through expansive new windows and glass paned doors lead to a spacious patio ideal for dining, game nights or cookouts. Enjoy mornings in the accent-painted breakfast room & take in views of the large backyard. Two spacious secondary bedrooms with an abundance of closet space share an remodeled hall bath with granite countertops & tub/shower. Generous sized primary bedroom offers a remodeled bath complete with private shower, spacious walk in closet, and private access to the backyard retreat through French doors. Updates include designer fixtures &lighting and remote-controlled fans' ,`Acres` = '0.1928' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Meyerland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 12 MAPLEWOOD SOUTH SEC 4' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '489' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PARKER ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Maplewood South Sec 04' ,`TaxAmount` = '5644' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666781752' WHERE `Matrix_Unique_ID` = '213744531' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T22:21:13.493' ,`MLSNumber` = '29053554' ,`ListAgentFullName` = 'Chinonso Ochi-Okorie' ,`ListOfficeName` = 'The Goldstein Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.676424' ,`Longitude` = '-95.361256' ,`PhotoCount` = '46' ,`PostalCode` = '77051' ,`RoomCount` = '8' ,`ListPrice` = '499991.00' ,`Status` = 'Active' ,`StreetName` = 'Vera Lou' ,`StreetNumber` = '1122' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2650' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'An ideal location near med center, Dwntwn Houston,& Galleria. 4 bed 3 bath home w/2 rooms on the 1st floor w/ huge 2nd floor den on 14k sqft lot ready for pool-spa/pool house/pergola in the back yard for Airbnb. Home features: Open concept floor plan, custom brick/stone elevation, int/ext LED lighting pkg, 3x LED fireplaces, pre-wired for solar/EV charging, pre wired for int 5.1 surround sound & ext speakers, quartz counter tops w/waterfall, stainless steel appliances, spray foam insulation, double stacked custom cabinets w/glass/soft close doors w/smart LED lighting, apron sink, pot filler, 8 ft Iron front door, Matte black fixtures/hardware, 8ft int doors, painted garage, 7 light garage door, architectural fence w/wrought iron gate, remote security system & camera\'s, stained hardwood ceilings in patio/porch, & more. NO HOA NO MUD NOT IN A FLOOD ZONE. Deed Restricted(NO NEW MULTI-FAMILY DEV ALLOWED. ALL REASONABLE OFFERS WILL BE CONSIDERED DUE TO CURRENT INTEREST RATE CONDITIONS!' ,`Acres` = '0.3085' ,`Area` = '3' ,`BuilderName` = 'GENERATIONAL HOME' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 6 & 7A BLK F BROOKHAVEN R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13440' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'YOUNG ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Brookhaven R/P' ,`TaxAmount` = '819' ,`TaxRate` = '2.4216' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666781752' WHERE `Matrix_Unique_ID` = '213777399' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T23:17:10.577' ,`MLSNumber` = '91041598' ,`ListAgentFullName` = 'David Brown' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.808356' ,`Longitude` = '-95.379504' ,`PhotoCount` = '24' ,`PostalCode` = '77009' ,`RoomCount` = '7' ,`ListPrice` = '391000.00' ,`Status` = 'Active' ,`StreetName` = 'Link' ,`StreetNumber` = '705' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1850' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GORGEOUS FREESTANDING 3 STORY HOME WITH PRIVATE GUEST PARKING SPACE OWNED BY THIS HOME, 3 BDRMS, 3 FULL BATHS, 1 HALF BATH, 2 CAR GARAGE, SPACIOUS OPEN FLOORPLAN FEATURES HUGE 2ND FLOOR LIVINGROOM, BEAUTIFUL REAL HARDWOOD FLOORS, INTERIOR IS INVITING WITH LITE AND BRITE COLOR CONCEPT. LARGE GROUPED WINDOWS THAT ALLOWS FOR THE RIGHT AMOUNT OF NATURAL LIGHT. BEAUTIFUL SPACIOUS KITCHEN WHITE CABINETS, SOFT CLOSE SHAKER STYLE CANINETS WITH CUSTOM MOLDING. A FULL SPACIOUS DINING ROOM, MODERN BACKSPLASH PAIRED GRANITE COUNTERS. MASTER BEDROOM LUXURIOUS MASTER BATH, SEPERATE TUB & SHOWER, DOUBLE GRANITE VANITY, BIG WALK IN CLOSET, TWO NICE SECONDARY BDRMS W/ ENSUITE BATHS, ENGINEER DISIGNED FOUNDATION, ENERGY EFFICIENT WINDOWS. YOU ARE GOING TO FALL IN LOVE WITH THE CRAFTMANSHIP IN THIS HOME, SO MUCH TO EXPLORE IN THIS AREA, RESTAURANTS, HEB, WHOLE FOODS AND THE ONE OF THE BEST FARMERS MARKET HOUSTON HAS TO OFFER WITHIN WALKING DISTANCE. WALKING DISTANCE. CALL FOR PRIVATE SHOWING.' ,`Acres` = '0.0416' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 12 BLK 1 NEWER HEIGHTS T/H' ,`LotDesciption` = 'Cleared' ,`LotSize` = '1812' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'JEFFERSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Newer Heights Twnhms' ,`TaxAmount` = '9045' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666781752' WHERE `Matrix_Unique_ID` = '213833313' --> 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','213850040','1666781753','213850040','2022-10-25T23:44:52.350','61189894','Bobbie Holub','JLA Realty','','','30.638031','-94.872019','25','77351','3','225000.00','Active','Peterson Loop','192','Loop','Livingston','2','0','2','1342','Single-Family','This cute home has recently been painted, has new flooring, new appliances & granite countertops installed, and has 2 water heaters. The driveway & decks have been cleaned & sealed. The 30x16 RV garage has an attached shop and an 36x12 RV carport next to it. The gazebo is fully screened.','0.333','44','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Livingston Area','Central Electric','0','RAINBOW END SECTION 3 LOT 127','Subdivision Lot','14505','Appraisal District','','','0','','1','Electric Oven,Freestanding Oven','0','','','Electric Cooktop,Freestanding Range','','Composition','103 - Livingston','LISD OPEN ENROLL','LIVINGSTON HIGH SCHOOL','LIVINGSTON JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','1','Traditional','Rainbow End Sec 3','3409','1.8745','Public Water,Septic Tank','1993','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T22:21:13.447' ,`MLSNumber` = '40436020' ,`ListAgentFullName` = 'Kevin King' ,`ListOfficeName` = 'RE/MAX ONE - Premier' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.758901' ,`Longitude` = '-94.862628' ,`PhotoCount` = '38' ,`PostalCode` = '77523' ,`RoomCount` = '12' ,`ListPrice` = '549900.00' ,`Status` = 'Active' ,`StreetName` = 'Madison' ,`StreetNumber` = '3811' ,`StreetSuffix` = 'Avenue' ,`City` = 'Baytown' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3872' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Here is the one that you have been looking for! BHISD on 1 acre with 3800 sq. ft. 4 bedrooms, 3.5 bathrooms, oversized 3 car garage with Porte Cochere. Open floor plan with a cooks kitchen, formal dining, breakfast room, study and a game room up. This home has all porcelain tile and hardwood floors downstairs, fireplace in the living room, study, formal dining, breakfast area, island with cooktop, game room up. Plenty of room in the backyard for a pool and shop. This home is a must see.' ,`Acres` = '1' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 GREENBRIAR ESTATES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`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` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Greenbriar Estate' ,`TaxAmount` = '7443' ,`TaxRate` = '1.7058' ,`WaterSewer` = 'Aerobic,Other Water/Sewer' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666781753' WHERE `Matrix_Unique_ID` = '213901954' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T23:44:44.143' ,`MLSNumber` = '76084336' ,`ListAgentFullName` = 'Christine Kalmbach' ,`ListOfficeName` = 'Keller Williams Platinum' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.594479' ,`Longitude` = '-95.663430' ,`PhotoCount` = '49' ,`PostalCode` = '77479' ,`RoomCount` = '15' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Pointe Loma' ,`StreetNumber` = '915' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3011' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'So lovely in Lake Pointe in New Territory! Amazing David Weekley Floor Plan! Over $230K in updates--you have to see to believe! Stately Two Story Entry w/Solid Wood Door w/new hardware & Leaded Crystal Glass! Gorgeous Wood Tile on the 1st & 2nd floor! Brand new interior wall paint & trim (10/22)! Both formals w/Triple Crown Molding, White Woodwork Custom Built-ins, Plantation Shutters, updated lighting & new ceiling fans throughout (10/22) make it perfect for entertaining! Chef\'s Kitchen has Jenn Air Oven & Warming Tray + an Induction Cooktop! Granite Counters. Gorgeous White Cabinetry! Breakfast Room & Family Room overlook backyard oasis w/custom landscaping & rock waterfall pool w/spa, featuring a new deck paint, new pump, new heater, & new plaster (10/22)! Upstairs has a fabulous game room w/3 beautiful bedrooms & 2 full baths (one remodeled w/custom tub/shower surround)! Zoned to high performing FBISD schools! Amazing Master-planned Community & an incredible lifestyle awaits you!' ,`Acres` = '0.1845' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKE POINTE SEC 1, BLOCK 3, LOT 30' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '8038' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1160' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'WALKER STATION ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'SARTARTIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Georgian,Traditional' ,`Subdivision` = 'Lake Pointe' ,`TaxAmount` = '8145' ,`TaxRate` = '2.4394' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666781753' WHERE `Matrix_Unique_ID` = '213903184' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T22:27:55.407' ,`MLSNumber` = '65093673' ,`ListAgentFullName` = 'Ciera Alba' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.781574' ,`Longitude` = '-95.150327' ,`PhotoCount` = '49' ,`PostalCode` = '77530' ,`RoomCount` = '4' ,`ListPrice` = '1100000.00' ,`Status` = 'Active' ,`StreetName` = 'West' ,`StreetNumber` = '618-620' ,`StreetSuffix` = 'Drive' ,`City` = 'Channelview' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1792' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Made with the live/work lifestyle at the top of mind. This property comes with an owners special 1,792 square foot home on a merged double lot with a second guest residence nearly 1,300 square foot in size in its own private area. Drive onto the lot and take a look at the large office (with a conference room) connected to the primary home with a full separation created by the wide covered carport, allowing living right next to where you work (unrestricted). Across from the office spans a large 3 gate workshop adding to your working lifestyle. Whether you choose to use it as a mechanic, collector or convert the use to your liking, this residence is truly a turn key all-in-one. To top off the incredible quality of everything packed in this deal, there is a cleared lot space in the back with an incredible open area to park trucks, store items or anything you could imagine! \r\nCome take a tour of your next residence and commercial space, opportunity is knocking!' ,`Acres` = '2.53' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 11A BLK 19 OLD RIVER TERRACE SEC 5' ,`LotDesciption` = 'Cleared' ,`LotSize` = '110076' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '8 - Channelview' ,`SchoolElementary` = 'SCHOCHLER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CHANNELVIEW HIGH SCHOOL' ,`SchoolMiddle` = 'JOHNSON JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Old River Terrace' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666781753' WHERE `Matrix_Unique_ID` = '213941889' --> 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','214025857','1666781753','214025857','2022-10-25T23:29:34.987','92809936','Richard Francis','CB&A, Realtors','','','29.769675','-95.704335','12','77094','10','505000.00','Active','Marlstone','19311','Court','Houston','2','1','3','2697','Single-Family','Location! Location! Green Trails Subdivision Phase 2 located in Katy ISD. Gorgeous One\r\nStory Home with a Beautiful Backyard & Pool plus an Oversized Corner Lot! Formal Living & Dining, Large Rooms through out, Lovely Kitchen with 42\" Cabinets, Island w/Cook Top & Updated\r\nGranite Countertops. Large Master Bedroom & Bath also with Granite Countertops and updated fully Enclosed Glass Shower.\r\nTwo A/C Units, Fully Landscaped front & Back, Over Sized Utility Room, and easy access to Neighborhood Amenities. These\r\ninclude Tennis Courts, Play Grounds, Splash Pad, Clubhouse with Olympic size Pool, plus Hike & Bike Trails. Very Easy\r\nAccess to I-10 for Medical, Shopping, Restaurants, & Work. Bonus; Huge George Bush Park within walking or bike distance!\r\nPlease don\'t wait to view this wonderful property! Make it your own mini Texas Oasis!!','0.2755','36','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','1','Katy - Southeast','Central Gas','1','LT 58 BLK 5 GREEN TRAILS PARK SEC 9','Corner,Cul-De-Sac,Subdivision Lot','12000','Appraisal District','','1259','0','','2','Electric Oven','1','Gunite,Heated','','Electric Cooktop','','Composition','30 - Katy','NOTTINGHAM COUNTRY ELEMENTARY SCHOOL','TAYLOR HIGH SCHOOL (KATY)','MEMORIAL PARKWAY JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox,Temporarily No Showings','Appraisal District','1','Traditional','Green Trails Park','7811','2.2083','Water District','1993','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T22:38:44.767' ,`MLSNumber` = '26145722' ,`ListAgentFullName` = 'Sonya Bravo' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.119407' ,`Longitude` = '-95.411389' ,`PhotoCount` = '34' ,`PostalCode` = '77515' ,`RoomCount` = '6' ,`ListPrice` = '269900.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 220' ,`StreetNumber` = '2472' ,`StreetSuffix` = '' ,`City` = 'Angleton' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2664' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GIVE ME SPACE- This country kingdom offers 5 bedrooms (3 down and 2 up), 3 bathrooms, formal living room, formal dining room, sunroom and lots of outdoor space on close to an acre (.8 acre)! Huge living room, oversized dining room, cozy and efficient kitchen. Lower level split bedroom plan with 1st floor primary bedroom retreat large enough for a private sitting/workout/hobby or office space area, and 2 additional lower level bedroom on the other side of the home. 2nd floor features 2 bedrooms, a gameroom with outdoor access and a 3rd bathroom. This is your opportunity to have the country property you\'ve always dreamed of. Needs a little TLC but priced for a quick sale. Every morning as you have your coffee on your deck enjoying this unique property you will be thankful that you found this little piece of heaven before someone else snatched it up. No Flood Zone. Don\'t wait- Call your agent NOW' ,`Acres` = '0.82' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'A0134 E WALLER BLOCK 9 TRACT 8G1 (SD W/2) ACRES 0.82' ,`LotDesciption` = 'Other' ,`LotSize` = '35719' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'WESTSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'E Waller' ,`TaxAmount` = '4274' ,`TaxRate` = '2.0772' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666781753' WHERE `Matrix_Unique_ID` = '214026084' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T22:00:48.877' ,`MLSNumber` = '39823919' ,`ListAgentFullName` = 'Vera Mitrofanova' ,`ListOfficeName` = 'VAM Real Estate Solutions' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.822221' ,`Longitude` = '-95.440710' ,`PhotoCount` = '39' ,`PostalCode` = '77018' ,`RoomCount` = '11' ,`ListPrice` = '1374999.00' ,`Status` = 'Active' ,`StreetName` = 'Ebony' ,`StreetNumber` = '1626' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4447' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This immaculate house was built by GHBA award winning builder Ryland Homes is located in the heart of Oak Forest, right off of I-610. You will love the infusion of Craftsman style and elegant modern design. This house has everything you can think of, private office, formal dining, wine grotto, exquisite Chef\'s kitchen with a huge granite island that opens up to the living room with a soaring ceiling. Some of the features include custom made shutters, extended WIFI, wire for alarm/security system, surround system, tankless water heater, epoxy garage flooring, oak hardwood floors throughout whole first floor, HEPA filters, warming drawers in the kitchen, pot filler, large pantry, laundry room with sink, media room, game room with wet bar. Updated landscaping with kumquat and grapefruit trees. Beautiful pool to enjoy during hot Texas summer! The backyard has an outdoor kitchen, garden includes rosemary, dill, thyme, cucumbers, onions, peppers, parsley, etc. Call for your private showing!' ,`Acres` = '0.168' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 20 BLK 48 OAK FOREST SEC 6' ,`LotDesciption` = 'Patio Lot,Subdivision Lot' ,`LotSize` = '7320' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Enclosed' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'STEVENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Craftsman' ,`Subdivision` = 'Oak Forest Add Sec 06' ,`TaxAmount` = '20634' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666781753' WHERE `Matrix_Unique_ID` = '214028902' --> 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','214030026','1666781754','214030026','2022-10-25T22:27:11.913','8728465','Karla Serrano','RE/MAX Real Estate Assoc.','','','29.869725','-95.691306','44','77449','6','265000.00','Active','Austinville','6446','Drive','Katy','2','1','3','1308','Single-Family','Beautiful and well-maintained 2 Story home with 3 bedrooms, 2 1/2 baths, Located on a Charming Corner Lot, this home has lots to offer. Seller has taken excellent care of this property.\r\n\r\nCozy home with all the areas that you need. Spacious Living Area and formal Dining Room to gather with family and friends. Kitchen with lots of Cabinetry and more! Hardwood flooring in all the home. \r\nThe garage was converted into a large space used as an office and exercise area.\r\n\r\nTake advantage of the location of this house, with a corner lot, ideal for you to enjoy with your family and for your children to walk or run in front of. Never Flooded! \r\nCome see this gorgeous property before it\'s gone!','0.0869','25','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Bear Creek South','Central Gas','1','LT 43 BLK 3 AUSTINVILLE','Corner','3786','Appraisal District','','350','0','','2','Gas Oven','0','','','Gas Range','','Composition','13 - Cypress-Fairbanks','MCFEE ELEMENTARY SCHOOL','CYPRESS SPRINGS HIGH SCHOOL','KAHLA MIDDLE SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Appraisal','2','Traditional','AUSTINVILLE','4292','2.671','Water District','2007','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T23:13:46.517' ,`MLSNumber` = '45734509' ,`ListAgentFullName` = 'Darius Franklin' ,`ListOfficeName` = 'Texas Ally Real Estate Group,' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.046633' ,`Longitude` = '-95.423248' ,`PhotoCount` = '15' ,`PostalCode` = '77373' ,`RoomCount` = '10' ,`ListPrice` = '288800.00' ,`Status` = 'Active' ,`StreetName` = 'Dickson Park' ,`StreetNumber` = '19302' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2282' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Single story 4-bedroom floor plan in the conveniently located gated community of Spring Park Village. High ceilings, wide hallways and larger rooms as well as the flooring upgrades will catch your eye on this one. Brand new A/C condenser and evap coil (w/ 10-year warranty upon registration to the buyer), brand-new stainless-steel range and OTR microwave, brand new carpet in the 2 bedrooms that have it. Equipped with fully serviced sprinkler system, garage opener with walk in access keypad and brand-new smoke detectors. Take a look at the pictures... Washer and dryer as well as furniture also for sale but separately, not included in the list price.' ,`Acres` = '0.1611' ,`Area` = '12' ,`BuilderName` = 'Newmark Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 39 BLK 3 SPRING PARK VILLAGE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7016' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'GINGER MCNABB ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'TWIN CREEKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Spring Park Village' ,`TaxAmount` = '6070' ,`TaxRate` = '2.4967' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666781754' WHERE `Matrix_Unique_ID` = '214030489' --> 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','214033632','1666781754','214033632','2022-10-25T23:59:10.417','57073637','Jobin Johnson','Stride Real Estate, LLC','','','29.571545','-95.518441','9','77459','7','359990.00','Active','Griffith View Ln','1123','','Missouri City','2','0','4','2329','Single-Family','Gorgeous NEW D.R. Horton built HOLDEN PLAN (Elevation L) 1 STORY, 4BR/2BA and STUDY. Beautiful Brick & Stucco Exterior! Includes the NEWEST Packages, with Upgraded Kitchen, Covered Patio, Sprinkler System & Tankless Water Heater! Great Open Concept Interior Layout! Privately located Primary Suite Offers Lovely Bath with Dual Sinks. Park\'s Edge is located on the edge of Missouri City’s Community Park and is a 300 acre master planned community. At completion, Park’s Edge will have over 6 miles of walking trails and a future pedestrian bridge connecting to Community Park. The Lodge at Park’s Edge will offer an activity room, meeting spaces, covered patio overlooking the recreation complex which includes a lap pool, waterslides, playgrounds and sports fields. Conveniently located off the Fort Bend Tollroad, Parks Edge will be ideal for commuters. Plus, students will attend the highly acclaimed Fort Bend ISD. Come out to Parks Edge and make this new home yours TODAY!','','38','D.R. Horton','','','','No Disclosures','1','','','Missouri City Area','Central Gas','1','Lot 12 Block 2','Subdivision Lot','','','','900','1','Never Lived In','2','Electric Oven','0','','','Gas Cooktop','','Composition','19 - Fort Bend','PALMER ELEMENTARY SCHOOL (FORT BEND)','HIGHTOWER HIGH SCHOOL','LAKE OLYMPIA MIDDLE SCHOOL','Appointment Required','Builder','1','Contemporary/Modern','Park\'s Edge','','3.24','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214040808','1666781754','214040808','2022-10-25T23:39:18.263','92933176','Jason Laviage','Oakington Realty','','','29.701088','-95.454364','42','77401','11','749999.00','Active','Beverly','142','Lane','Bellaire','3','0','4','2130','Single-Family','This is NOT your run of the mill 1040\'s Bellaire cottage! From the updated exterior paint & beautiful landscaping, to the refreshingly spacious & tastefully appointed interior, this true gem is nestled on a corner lot of one of the few horseshoe streets in all of Bellaire. Combining the warmth & character of a classic bungalow, with fresh updates, vast natural light & a surprisingly flexible floorplan, you must see this home in person. Updated spacious kitchen incl. stained cabinetry, farmhouse sink, counter depth fridge, slide-in ridge & recent dishwasher. Primary suite touts a double marble vanity, large soaking tub & walk-in shower, along w/2 separate large walk-in closets. Refinished hardwoods throughout, other updates incl. windows, lighting/plumbing fixtures, paint, AC, roof, sprinkler system & turf in backyard. Situated on one of the more desirable streets in Bellaire, walk to Horn Elem, Nature Discovery Center, Evergreen Park/Pool & Evelyn\'s Park!','0.1607','17','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Owner/Agent,Sellers Disclosure','1','','','Bellaire Area','Central Gas','0','LT 41 BANNER PLACE','Corner,Subdivision Lot','7000','Appraisal District','','','0','','0','Electric Oven,Single Oven','0','','','Gas Cooktop','','Composition','27 - Houston','HORN ELEMENTARY SCHOOL (HOUSTON)','BELLAIRE HIGH SCHOOL','PERSHING MIDDLE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Seller','1.5','Ranch','Banner Place','12472','2.2271','Public Sewer,Public Water','1946','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T22:06:23.740' ,`MLSNumber` = '70455820' ,`ListAgentFullName` = 'Terri Osborne' ,`ListOfficeName` = 'Coldwell Banker RealtyREALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.030654' ,`Longitude` = '-95.568077' ,`PhotoCount` = '50' ,`PostalCode` = '77379' ,`RoomCount` = '10' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Bala Lake' ,`StreetNumber` = '1211' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3589' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2-story brick home located in an established section of Gleannloch Farms, on a quiet cul-de-sac just steps from walking trails and one of the beautiful neighborhood lakes. Huge 12,500 ft yard perfect for pool and outdoor entertainment area build-out, small fenced dog run close to back door. Well kept quality home has arches and rounded corners, high ceilings, recent neutral carpet and recent wood-look tile floors down, very neutral paint throughout. Bright living room has expansive windows, gas fireplace, ceiling fan. Upstairs game room and bantered hallway overlook open living room/kitchen plan. Extensive kitchen counters, long dining counter and center island, sizeable breakfast nook. 3+ car detached garage with wide driveway, extra bump out and enclosed workroom w/ AC. Double walk-in closets in Primary bedroom, plus walk-in closets in all other bedrooms, and tons of available storage. Master planned community with tons of amenities. Klein ISD.' ,`Acres` = '0.2902' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 2 THE LAKE ESTATES GLEANNLOCH FARMS SEC 2' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '12640' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'HASSLER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'DOERRE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Gleannloch Farms Sec 02' ,`TaxAmount` = '8639' ,`TaxRate` = '2.6115' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666781754' WHERE `Matrix_Unique_ID` = '214042959' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T23:06:02.687' ,`MLSNumber` = '98174003' ,`ListAgentFullName` = 'Leopoldo Mantecon' ,`ListOfficeName` = 'AQUI Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.133808' ,`Longitude` = '-95.572904' ,`PhotoCount` = '0' ,`PostalCode` = '77375' ,`RoomCount` = '11' ,`ListPrice` = '1087500.00' ,`Status` = 'Active' ,`StreetName` = 'Mariposa Woods' ,`StreetNumber` = '23' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3715' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFULL BRAND NEW, NEVER LIVED HOUSE AT MARIPOSA \r\nWOODS, OPEN BAR KITCHEN, GAME ROOM, MEDIA ROOM ,STUDY.\r\nWALKING DISTANCE TO POND AND TRAILS.\r\nGREAT FLOOR PLAN ,DOUBLE SINK ISLAND KITCHEN AND SLIDING GLASS DOOR TO COVERED OUTDOOR PATIO.\r\n4 FULL BATHROOMS AND I HALF.' ,`Acres` = '0.2156' ,`Area` = '14' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 BLK 2 THE WOODLANDS CREEKSIDE PARK WEST SEC 39' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9392' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'CREEKVIEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Woodlands Creekside Park West Se' ,`TaxAmount` = '1685' ,`TaxRate` = '2.7515' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666781754' WHERE `Matrix_Unique_ID` = '214062770' --> 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','214067194','1666781754','214067194','2022-10-25T22:18:06.327','61987280','Etha Eglin','Keller Williams Metropolitan','','','30.131733','-94.202546','40','77713','7','259999.00','Active','Lori','5780','Lane','Beaumont','2','0','3','1735','Single-Family','Welcome home to 5780 Lori Lane. Located in highly sought after Pine Glen. Situated on a corner lot with a freshly painted wood privacy fence. From the foyer the picturesque view of the open concept Marino Home Builders floor plan is a designers dream. Beach Oak luxury vinyl planks, Renaissance Hardware fixtures and fresh Sherwin Williams paint throughout. Enjoy morning coffee in the custom Chef\'s kitchen that boast a sit down counter height island finished in honed granite. Plenty of storage including reachable shelving, a pullout pantry, a hidden small appliance cabinet, and a pullout hanging pot organizer. The Owner\'s Retreat has a spa like feeling, a great space to relax after a long day with trey ceilings, tons of natural light and a contemporary oval freestanding tub!! New HVAC and 1 yr. old roof!!!','0.1824','51','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','','Central Gas','0','PINE GLEN 4TH PHASE 1 LOT 1 BLK 1','Subdivision Lot','7944','Appraisal District','','','0','','2','Gas Oven','0','','','Gas Range','','Composition','143 - Beaumont','GUESS ELEMENTARY SCHOOL','WEST BROOK HIGH SCHOOL','VINCENT MIDDLE SCHOOL','Accompany,Appointment Required,Lockbox Front','Appraisal District','1','Contemporary/Modern','Pine Glen 4th Ph 1','5219','2.645','Public Sewer,Public Water','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','214067263','1666781754','214067263','2022-10-25T22:44:01.177','35011660','Michelle Courtney','Double G Realty, LLC','','','29.520147','-96.668302','24','77475','5','309000.00','Active','Crooked Creek','400','Drive','Sheridan','1','1','2','1200','Single-Family','This charming country cottage is located in Lake Sheridan Estates, a restricted private lake community. The home features a perfect size living room, efficiently designed kitchen, 2 bedrooms, 1.5 bath and nice size closets.  Outdoors you will find a metal shed workshop, a metal storage shed with 2 roll up doors, metal carport for your vehicle or RV, a pool room with stand alone shower, sink, and a full size whirlpool washer/dryer (which will convey), above ground swimming pool, a sprinkler system, crape myrtles, lavender, yaupon and live oaks trees. HOA fee is approximately $100.00 per year.  The property is just minutes away Splashway Water Park. Call our office today to schedule an appointment to view!  Must see!  Once you see it, you\'ll want to own it!','0.42','56','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','','','','','Central Electric','1','LT 55 LAKE SHERIDAN HOUSE & BLDGS','Subdivision Lot','17043','Survey','','100','0','','0','Electric Oven','1','Above Ground','','Electric Range','','Aluminum','161 - Rice Consolidated','SHERIDAN ELEMENTARY SCHOOL (RICE CISD)','RICE HIGH SCHOOL (RICE CISD)','RICE JUNIOR HIGH SCHOOL (RICE CISD)','Accompany,Appointment Required','Appraisal District','1','Traditional','Lake Sheridan','2736','1.8372','Public Water,Septic Tank','2002','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214067506','1666781754','214067506','2022-10-25T23:05:32.703','53867034','Ciera Alba','NB Elite Realty','','','30.032470','-95.495529','38','77379','9','330000.00','Active','Cobble','5307','Lane','Spring','2','1','4','2462','Single-Family','You\'ve arrived at your next home, stop the car! This premium home rests on an over quarter acre lot, masterfully designed with a backyard oasis. Have a cookout on the grill and dip in the in-ground pool to shoot some hoops, or have an outdoor family movie night on your mounted TV that comes with the home. With plenty of space and a long list of upgrades such as NEW WINDOWS in Feb 2021, NEW PAINT and CARPETS, NEW FURNACE replaced in 2021, NEW UPSTAIRS BATHROOM, NEW living and dining room FLOORS, NEW GARAGE DOOR with a BRAND NEW ROOF, NEW EXTERIOR PAINT and NEW PEX PIPE PLUMBING throughout the entire house, this is a TURN KEY HOME awaiting your move. The interior features a rare wet bar serving the expansive living room for you and your hosting pleasures. Come out and take a tour, don\'t miss your chance!','0.2662','13','','','Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Champions Area','Central Gas','1','LT 386 BLK 9 TERRANOVA SEC 2','Cul-De-Sac,Subdivision Lot','11595','Appraisal District','','603','0','','1','Double Oven','1','In Ground','','Electric Cooktop','','Composition','32 - Klein','BENFER ELEMENTARY SCHOOL','KLEIN HIGH SCHOOL','STRACK INTERMEDIATE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Terranova Sec 02','5500','2.3266','Public Sewer,Water District','1979','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','214067518','1666781754','214067518','2022-10-25T22:13:35.077','75153765','Rachel Parsons','Keller Williams Realty Austin','','','29.297803','-97.161386','50','77995','6','485000.00','Active','Thiele','113','Drive','Yoakum','4','0','6','3802','Single-Family','Spacious home with 6 bedrooms, 4 baths, balcony, large living areas, open concept floor plan, and a huge shop to house multiple vehicles. The 2 bedroom, 1 bath efficiency apartment is perfect for a rental, or additional living space. A huge upstairs balcony is a wonderful place to relax while the open spaces both upstairs and downstairs provide plenty of room for family and friends to gather. Situated on over 3/4 of an acre, the backyard allows space for gardening and installing a pool. The outdoor cooking area is a bonus space to create delicious meals for your guests. While only a short distance from local stores and restaurants, the location of this property is less than 2 hours from Houston, Austin, San Antonio, and Corpus Christi. A beautiful front porch provides a perfect place for a few rocking chairs and patio furniture. Just add iced tea and cookies.','0.8264','83','','','','','Sellers Disclosure','','','','','Central Electric','0','7-12 3 THIELE YKM','Cleared','35998','Appraisal District','','','0','','3','','0','','','','','Composition','177 - Yoakum','','YOAKUM HIGH SCHOOL','YOAKUM JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,No Supra Keybox,Request Online Appointment','Appraisal District','2','Ranch,Traditional','Thiele Add','7452','1.8907','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','214067756','1666781755','214067756','2022-10-25T22:04:07.773','48220223','Anna Johnston','Country Pride Real Estate','','','29.313941','-96.097928','49','77488','3','255000.00','Active','Rusk','401','Street','Wharton','2','1','3','2000','Single-Family','DID NOT FLOOD! beautiful well maintained 3 bedroom 2 bath home with separate studio/office, 3 car garage with workshop in the back, 19x23 two-story lower level storage and laundry room, second story living quarters. Another storage shed 12x16 in the back on a .67 acre corner lot, FFA projects yard and separate garden yard. Bring your boat and RV, plenty of parking, RV hook up can be converted to EV charger. So much space, storage and potential. wraparound porch, covered deck, custom fireplace, original wood floors, high ceilings, double pane double hung windows, large rooms. 2 hours from Austin, 1 hour from Houston, 1 hour from the bay, 2.5 hours from Corpus Christi, 1 mile to HEB and blocks to downtown shopping. Priced to sell. Room dimensions approximate buyer to confirm.','0.6695','55','','','Electric Dryer Connections,Washer Connections','','Owner/Agent,Sellers Disclosure','0','Freestanding,Wood Burning Fireplace','1','','Central Gas','0','WHARTON BLOCK 30 LOT 12','Corner','29163','Appraisal District','','','0','','3','Convection Oven,Electric Oven,Freestanding Oven,Single Oven','0','','','Electric Cooktop','','Composition,Tile','180 - Wharton','CG SIVELLS/WHARTON ELEMENTARY SCHOOL','WHARTON HIGH SCHOOL','WHARTON JUNIOR HIGH','Accompany,Appointment Required,Leave Business Card','Appraisal District','1','Mediterranean,Spanish','Wharton','5208','2.3512','Public Sewer,Public Water','1927','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','214069904','1666781755','214069904','2022-10-25T23:29:59.023','90443967','Juan Salcedo','ASIN Realty','','','18.826242','-99.203252','32','62766','4','655000.00','Active','Bugambilias','30','Street','Cuernavaca','5','0','4','4704','Single-Family','This beautiful new house is the best option for your new home!! Marble and quarry finishes, 4 bedrooms, 5 bathrooms, gorgeous pool, open spaces, great natural lighting. Located on Golf Course with 24/7 security. Privileged view of golf course, no risk of balls.','','','Desarrollos Guayabo','','','','No Disclosures','0','','','','No Heating','0','Paraiso Country Club','In Golf Course Community,On Golf Course','','','','','1','Never Lived In','3','','1','Heated,In Ground','','','','Tile','','','','','Appointment Required','Seller','2','Contemporary/Modern','Emiliano Zapata','','','Other Water/Sewer','',''); --> 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','214070089','1666781755','214070089','2022-10-25T23:38:59.857','86536892','Juan Salcedo','ASIN Realty','','','18.949615','-99.268107','14','62156','13','340000.00','Active','Fracc Villa Internacional de Tenis Subida a Chalma','702','','Cuernavaca','4','0','3','4305','Single-Family','Be charmed by this beautiful colonial home with pool, garden, and exterior porch. 3 bedrooms, 4 baths, media room, and utility room. 24 hrs. surveillance, lots of vegetation, and a nice climate all year long.','','','','','','','No Disclosures','','','','','No Heating','0','FRACC VILLA INTERNACIONA DE TENIS SUBIDA A CHALMA 702 CASA 4','Other','6200','Other','','','0','','2','','1','In Ground','','','','Composition,Other','','','','','Appointment Required','Seller','2','Colonial','NA','','','Septic Tank','1988','Seller'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214070154','1666781755','214070154','2022-10-25T23:41:56.990','67195674','Juan Salcedo','ASIN Realty','','','18.938764','-99.212967','26','62290','11','275000.00','Active','Rio Danubio','114','','Cuernavaca','3','1','3','2852','Single-Family','Feel welcome to this cozy Mexican-modern 3 bedroom home in the center of the picturesque town. Pool, garden, and lots of surrounding vegetation. 3 baths and 1 half bath, septic tank, utility, and electric door.','','','','','','','No Disclosures','','','','','No Heating','0','RIO DANUBIO NO. 114','Other','','','','','0','','2','','1','In Ground','','','','Built Up','','','','','Appointment Required','Seller','2','Colonial,Contemporary/Modern','NA','','','Septic Tank','2021','Seller'); --> New record created successfully