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-08-15T12:12:04.043' ,`MLSNumber` = '74027204' ,`ListAgentFullName` = 'Victoria Staff' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.718912' ,`Longitude` = '-95.408773' ,`PhotoCount` = '12' ,`PostalCode` = '77005' ,`RoomCount` = '9' ,`ListPrice` = '3300000.00' ,`Status` = 'Active' ,`StreetName` = 'Rice' ,`StreetNumber` = '2136' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rare opportunity for almost half an acre premier corner lot (19,800 sq. ft.per HCAD) in highly desirable Southampton Place. The value is in the land. Property has beautiful frontage along Rice Blvd. (across from the acclaimed Rice University campus) and expansive footage with garage access along Shepherd Dr. Beautiful and perfectly placed mature oak trees in the front and back yard await your vision for luxurious new construction with ample room for a pool, or remodel existing home (w/ civic club approval). Residents enjoy private security patrols and an active Civic Club. Deed restrictions/building guidelines are available on the civic club website. This desirable, prosperous residential neighborhood with no commercial or multi-family properties is zoned to 3 highly rated schools (Buyer to verify eligibility) and offers close proximity to the Texas Medical Center, Museum District, Hermann Park & popular Rice Village. Please do not walk lot without an appointment. All info per Seller.' ,`Acres` = '0.4545' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rice/Museum District' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 4 SOUTHAMPTON PLACE' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '19800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'POE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = '' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Southampton Place' ,`TaxAmount` = '43473' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698978' WHERE `Matrix_Unique_ID` = '201955521' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T12:09:03.090' ,`MLSNumber` = '72091414' ,`ListAgentFullName` = 'Dan McCarver' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.594646' ,`Longitude` = '-95.124341' ,`PhotoCount` = '50' ,`PostalCode` = '77059' ,`RoomCount` = '15' ,`ListPrice` = '2150000.00' ,`Status` = 'Active' ,`StreetName` = 'Acorn Wood' ,`StreetNumber` = '3119' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '7679' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Incredible contemporary residence on .75 acre site on Bay Oaks CC Golf Course. Circular paver drive and water features lead to the soaring entry. Walls of glass, wood flooring, and stone accents create a breath-taking living and dining area. Dramatic floating staircase has stainless steel railing. The great room with 25\' ceiling height, family area, and kitchen overlook the infinity pool and manicured backyard. Primary suite and home office are located on the main level. Pool-view seating area in master suite spa bath with dual wardrobes. Guest suite down. Upstairs features workout room, game room, tiered theater, and four bedrooms each with built-in desk. Game room has balcony with spiral staircase to patio. Kitchen is open to family room and offers granite counters, stainless steel island, walk-in pantry. Outdoor kitchen, extensive patio areas. Gated four car garage, Play court. Self-cleaning pool system. Dual staircase, 4 car garage. Wine storage. Aquarium.' ,`Acres` = '0.767' ,`Area` = '7' ,`BuilderName` = 'Reed Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 3 BAY OAKS SEC 17' ,`LotDesciption` = 'On Golf Course,Wooded' ,`LotSize` = '33411' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '930' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'FALCON PASS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Bay Oaks Sec 17' ,`TaxAmount` = '47435' ,`TaxRate` = '2.7319' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698978' WHERE `Matrix_Unique_ID` = '201962010' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T13:40:59.070' ,`MLSNumber` = '90369840' ,`ListAgentFullName` = 'Vanessa Hagler' ,`ListOfficeName` = 'Styled Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.328958' ,`Longitude` = '-95.246393' ,`PhotoCount` = '25' ,`PostalCode` = '77328' ,`RoomCount` = '2' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Highway 105' ,`StreetNumber` = '20611' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1906' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You are going to LOVE this one! It exudes southern charm and has been thoughtfully updated while keeping in mind the original character you just can\'t find anymore. Inside features new flooring, fresh paint, HUGE rooms, the most adorable custom breakfast nook and built-in China cabinet. French doors leading out to a spacious back porch overlooking the pond stocked with bass & catfish! And if that isn\'t enough to make you smile, outside is an oversized garage, barn/workshop & sheds! Not to mention over 2.5 acres of tranquility for your enjoyment. The attic space is sized for more living space to be built out if you need it. Conveniently located between Conroe & Cleveland & NO FLOODING per seller. Come check out your fairy tale dream home!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'A0595 WRENTMORE E, TRACT 41-B' ,`LotDesciption` = 'Cleared,Water View' ,`LotSize` = '121455' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Left Side,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'n/a' ,`TaxAmount` = '3882' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698978' WHERE `Matrix_Unique_ID` = '206410847' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T13:34:01.670' ,`MLSNumber` = '59101959' ,`ListAgentFullName` = 'Michele Kimmons' ,`ListOfficeName` = 'Michele Kimmons Properties,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.807582' ,`Longitude` = '-95.071072' ,`PhotoCount` = '38' ,`PostalCode` = '77351' ,`RoomCount` = '5' ,`ListPrice` = '199888.00' ,`Status` = 'Active' ,`StreetName` = 'US Highway 190' ,`StreetNumber` = '11623' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '912' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home and several shops right off Hwy 190 just outside Onalaska. This home is very cozy and could be used for a personall residence and/or commercial business. The property has a shop, RV carport and another shop conected to the primary residence. Another 2 buildings are behind the home, and another 2 buildings are beside the home. with one being used as a BBQ area with interior/exterior seating, and the other used as a retail shop area. The lot is almost 1 acre and has plenty of parking space for a business. Many great features for a homeowner or a business owner.' ,`Acres` = '0.8528' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'CEDAR POINT SECTION 4 LOT 39 THRU 43' ,`LotDesciption` = 'Cleared' ,`LotSize` = '37150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Cedar Point Sec 4' ,`TaxAmount` = '3260' ,`TaxRate` = '1.7215' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698978' WHERE `Matrix_Unique_ID` = '207160051' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T13:19:16.820' ,`MLSNumber` = '95261882' ,`ListAgentFullName` = 'Kaye Kaye Smith' ,`ListOfficeName` = 'Legacy Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.126301' ,`Longitude` = '-94.093291' ,`PhotoCount` = '28' ,`PostalCode` = '75929' ,`RoomCount` = '3' ,`ListPrice` = '255000.00' ,`Status` = 'Active' ,`StreetName` = 'FM 705' ,`StreetNumber` = '21830' ,`StreetSuffix` = '' ,`City` = 'Broaddus' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1728' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cute \'n Cozy home near Powell Park Marina, backs up to Corp. of Engineer land, 5.17 acres, 6\' wrap around porch, One 2 car garage plus another 2 car garage/wood working shop. One of the two car garages used to be used as an apartment and has a kitchenette and bathroom (could easily be converted back to apartment). Partially wooded giving lots of privacy, fish and deer cleaning station, boat launches nearby. Storm closet with solid concrete wall in one of the bedrooms, House roof replaced 2017. Matching Garage roof replaced 2019. Large storage building and an enclosed boat storage. SELLING AS IS' ,`Acres` = '5.17' ,`Area` = '78' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'AB 40 WT SHANNON TRACT 2 & IMP - 5.17 ACRES' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '232 - Broaddus' ,`SchoolElementary` = 'BROADDUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BROADDUS HIGH SCHOOL' ,`SchoolMiddle` = 'BROADDUS HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'NONE' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698978' WHERE `Matrix_Unique_ID` = '207255200' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T12:46:55.350' ,`MLSNumber` = '22523979' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = 'Adrianne Osorio' ,`SellingOfficeName` = 'Camelot Realty' ,`Latitude` = '30.064312' ,`Longitude` = '-95.721298' ,`PhotoCount` = '17' ,`PostalCode` = '77377' ,`RoomCount` = '12' ,`ListPrice` = '578372.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Lusitano Glen' ,`StreetNumber` = '20603' ,`StreetSuffix` = 'Lane' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2817' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Admire waterfront views from this fantastic Beazer Home in Amira, boasting a brick façade, luxury vinyl plank flooring, stone fireplace, energy efficient features, game room, study with French doors, and an extended covered patio. The lavish kitchen is fully equipped with quartz countertops, mosaic backsplash, large cove molding, 36” built-in gas cooktop, stainless steel appliances, 42” upper cabinets, and pendant and under-counter lighting. The primary suite is complete with a walk-in closet, dual vanities, a tub, and a separate shower. Nestled among 100-year-old oak trees are Amira’s world-class comforts, including a glistening infinity-edge pool, clubhouse, dog park, and full fitness center. Located off the Grand Parkway and Hwy 249, residents are minutes from popular restaurants, shops, and parks in central Tomball and Cypress. Zoned to the top-rated Tomball ISD.' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 25 Block 3' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Amira' ,`TaxAmount` = '' ,`TaxRate` = '3.551993' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663698978' WHERE `Matrix_Unique_ID` = '207768297' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T13:50:29.170' ,`MLSNumber` = '17246957' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.436920' ,`Longitude` = '-95.438449' ,`PhotoCount` = '32' ,`PostalCode` = '77583' ,`RoomCount` = '7' ,`ListPrice` = '385940.00' ,`Status` = 'Active' ,`StreetName` = 'Sequoia Run' ,`StreetNumber` = '1602' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2201' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gated- Home READY NOVEMBER 2022. Nice size rear yard. This Colina Home is 2 stories with 3 bedrooms 2.5 baths and a gameroom. Master down with dining/study option, window coverings, tile backsplash, extensive vinyl wood plank throughout. One of the countries top 25 selling masterplan communities and also the future home of the 1.25 million SF amenity village, anchored by the crystal clear lagoon, a turquoise-blue 5 acre lake with white sand beaches, a beach front clubhouse with a restaurant and fitness center. The celebration lawn, for community events and performances, rental cabanas and a splash pad for the kids. All only 20 minutes from the medical center and only 30 minutes to Downtown Houston. Photos are representative ONLY. Appointments are not required but recommended' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 6 Blk 3 Section 6' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '12304' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista West' ,`TaxAmount` = '' ,`TaxRate` = '3.6' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663698979' WHERE `Matrix_Unique_ID` = '207921113' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T12:11:41.517' ,`MLSNumber` = '11889847' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Julie Pruski' ,`SellingOfficeName` = 'RE/MAX Integrity' ,`Latitude` = '29.912306' ,`Longitude` = '-95.457369' ,`PhotoCount` = '8' ,`PostalCode` = '77038' ,`RoomCount` = '4' ,`ListPrice` = '303940.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Landon Light' ,`StreetNumber` = '12623' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1778' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely brand NEW DR Horton Home in the best location! Charming one story floor plan with open living spaces and modern finishes! Features include hard surface flooring, maple cabinetry, recessed lighting, home automation system, appliance package, and so much more! The primary suite has a nice bathroom! Great covered patio for outdoor living! Also includes landscaping! Energy features include radiant barrier decking, double paned low- E- vinyl windows, and Rinnai Tankless Water Heater! Hurry and call TODAY!' ,`Acres` = '' ,`Area` = '11' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 Block 1 Section 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5896' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '290' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'SAMMONS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'EISENHOWER HIGH SCHOOL' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Call Occupant' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Princeton' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663698979' WHERE `Matrix_Unique_ID` = '208247120' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T12:21:21.900' ,`MLSNumber` = '31414116' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '29.852738' ,`Longitude` = '-95.742516' ,`PhotoCount` = '7' ,`PostalCode` = '77449' ,`RoomCount` = '4' ,`ListPrice` = '338490.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Ternberry Forest Lane' ,`StreetNumber` = '5230' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1869' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW D.R. Horton\'s Express one story! Wonderful open floor plan! Island kitchen has lots of cabinets and is open to the breakfast room and family room! Large primary bedroom with a spacious closet! Features a large shower in the primary bathroom as well! Hard surface flooring in all living areas and modern designer details! Covered Patio overlooking the backyard! Landscape package included and so much more! Hurry and call today!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 21 - Block 2 - Section 24' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'GOLBOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'MCDONALD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jasmine Heights' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663698979' WHERE `Matrix_Unique_ID` = '208320682' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T13:02:24.770' ,`MLSNumber` = '53495859' ,`ListAgentFullName` = 'Sammy Younis' ,`ListOfficeName` = 'RE/MAX Southwest' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.547952' ,`Longitude` = '-95.604957' ,`PhotoCount` = '33' ,`PostalCode` = '77479' ,`RoomCount` = '9' ,`ListPrice` = '838880.00' ,`Status` = 'Active' ,`StreetName` = 'Hawksbury' ,`StreetNumber` = '4902' ,`StreetSuffix` = 'Court' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3830' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'EXCEPTIONAL one story home on ½ ACRE cul-de-sac, corner lot located in the gated community of the sought after Riverstone subdivision! Beautiful private backyard views of a nature reserve. Enter into you tranquil courtyard w/ cascading waterfall feature which is just 1 of 3 outdoor living space to enjoy year around. Amazing open concept floorplan, LARGE family room with custom crafted cabinetry, high ceilings & brick fireplace. Gourmet Island kitchen w/ cabinets and counterspace galore, walk-in pantry & SS appliances. Elegant formal dining with vaulted ceilings, great for entertaining. Handsome study w/ French doors & private outdoor area. HUGE primary retreat w/ sitting area that features his/her vanity & large walk-in closets. Generous size secondary bedrooms w/king beds. Full house water softener system & GENERATOR! Zoned to exemplary schools, minutes from amenities and entertainment! Easy access to major highways. Call the Aida Younis Team!' ,`Acres` = '0.5102' ,`Area` = '29' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'AVALON AT RIVERSTONE SEC 1, BLOCK 1, LOT 13' ,`LotDesciption` = 'Corner,Cul-De-Sac,Greenbelt,Wooded' ,`LotSize` = '22224' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1810' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'COMMONWEALTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'FORT SETTLEMENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Riverstone' ,`TaxAmount` = '15424' ,`TaxRate` = '2.4529' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698979' WHERE `Matrix_Unique_ID` = '208718436' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T13:14:33.530' ,`MLSNumber` = '13303609' ,`ListAgentFullName` = 'Candy Chowdhury' ,`ListOfficeName` = 'Asset Property Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.617280' ,`Longitude` = '-95.629136' ,`PhotoCount` = '50' ,`PostalCode` = '77478' ,`RoomCount` = '11' ,`ListPrice` = '595000.00' ,`Status` = 'Active' ,`StreetName` = 'Falling Water' ,`StreetNumber` = '8210' ,`StreetSuffix` = 'Court' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3778' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Remodeled 5 bedroom, 3.5 bath home in the beautiful tree-lined subdivision of Sugar Lakes. As you enter this home you will be greeted by the dramatic 2 story foyer and family room. The family room looks out over the backyard and sparkling pool. The kitchen features all new stainless steel appliances. The entire house has been painted inside and out. New engineered wood floors in master, study, entry, dining and family room. The spacious master is down with a large walk-in closet and a wall of windows that look out over the inviting pool and backyard. Upstairs are 4 more spacious bedrooms (see the room measurements) with 2 full baths and a bonus room that can be used as a craft room, playroom or media room. Most windows have plantation shutters. The finished garage has epoxy flooring. This property offers easy access to 59 and is within walking distance to the subdivision lake for those afternoon strolls. Zoned to great Fort Bend schools. Low tax rate!! This house has it all.' ,`Acres` = '0.1867' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SUGAR LAKES SEC 3, BLOCK 1, LOT 29, R/P' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8133' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '898' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HIGHLANDS ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sugar Lakes Sec 3' ,`TaxAmount` = '8778' ,`TaxRate` = '2.0094' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698979' WHERE `Matrix_Unique_ID` = '208845529' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T12:41:53.497' ,`MLSNumber` = '23166498' ,`ListAgentFullName` = 'Gary Bisha' ,`ListOfficeName` = 'My Castle Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.052485' ,`Longitude` = '-93.889993' ,`PhotoCount` = '39' ,`PostalCode` = '77630' ,`RoomCount` = '9' ,`ListPrice` = '370000.00' ,`Status` = 'Active' ,`StreetName` = 'Morrison' ,`StreetNumber` = '5115' ,`StreetSuffix` = 'Circle' ,`City` = 'Orange' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2282' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEVER FLOODED! Move in ready home, 2,286 SF Living Area & 3,288 SF under roof in Bridge City IDS school district with three bedrooms and two half baths on 1 acre of land. Custom painted kitchen cabinets for tons of storage. Pantry, large storage closet & utility room with additional storage cabinets. Large primary bedroom with tray ceiling & bathroom with double vanities, jetted tub, separate large shower and over-sized closet that also connects to the utility room for easy laundry access. Includes a breakfast area & formal dining room that can be used for a home office or study. Property also includes a 20 x 12 storage building with ramps and a Z-Turn Gravely riding mower and a 100’ well for watering the property using a Hunter underground sprinkler system. This property also includes a 1 year Choice Home Warranty. It is also located in FEMA Flood Zone X for the best rates available. This lovely home is ready for you, so make your appointment today!' ,`Acres` = '1' ,`Area` = '50' ,`BuilderName` = 'Carlis Simmons' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 38 BRIDGEFIELD ESTATES PHASE IV' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '367 - Bridge City' ,`SchoolElementary` = 'BRIDGE CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGE CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BRIDGE CITY MIDDLE SCHOOL' ,`ShowInstructions` = 'Call Occupant' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgefield Estate' ,`TaxAmount` = '4663' ,`TaxRate` = '1.7904' ,`WaterSewer` = 'Public Sewer,Public Water,Well' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698979' WHERE `Matrix_Unique_ID` = '209736487' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T12:24:31.497' ,`MLSNumber` = '35443811' ,`ListAgentFullName` = 'Hong Zhang' ,`ListOfficeName` = 'PRG, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.875811' ,`Longitude` = '-95.731648' ,`PhotoCount` = '31' ,`PostalCode` = '77449' ,`RoomCount` = '6' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Carmel Valley' ,`StreetNumber` = '21047' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1669' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Only for investor, tenant pay $1950/month, Looking for a great one story home in Settlers Village, then look no further! This gorgeous three - four bedroom split plan, has a generously sized family room featuring a gaslog fireplace and opens to the kitchen. Over $30000 in recent upgrades including : New A/C, New paint in and out, new Laminate floor, new master bathroom shower , new sinks with granite countertops... You won\'t want to miss this lovely home and MAKE THIS YOUR \"HOME SWEET HOME!\"' ,`Acres` = '0.1515' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 7 SETTLERS VILLAGE SEC 1 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '318' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WALKER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Settlers Village Sec 1 & R/P' ,`TaxAmount` = '5561' ,`TaxRate` = '2.831' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698979' WHERE `Matrix_Unique_ID` = '209788535' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T12:20:28.110' ,`MLSNumber` = '70178052' ,`ListAgentFullName` = 'Santiago Galindo' ,`ListOfficeName` = 'Mission Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.075048' ,`Longitude` = '-94.738309' ,`PhotoCount` = '6' ,`PostalCode` = '77535' ,`RoomCount` = '4' ,`ListPrice` = '189900.00' ,`Status` = 'Active' ,`StreetName` = '-4021-A' ,`StreetNumber` = '162 R' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1568' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Liberty' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Inddian Ridge,Sec2,Lot12,Acres.5,MHLabel#' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '21780' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '73 - Liberty' ,`SchoolElementary` = 'LIBERTY ELEMENTARY SCHOOL (LIBERTY)' ,`SchoolHigh` = 'LIBERTY HIGH SCHOOL (LIBERTY)' ,`SchoolMiddle` = 'LIBERTY MIDDLE SCHOOL (LIBERTY)' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Indian Ridge' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698980' WHERE `Matrix_Unique_ID` = '210369508' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T12:56:46.710' ,`MLSNumber` = '83481361' ,`ListAgentFullName` = 'Danielle Thurman' ,`ListOfficeName` = 'Redfin Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.801864' ,`Longitude` = '-95.495745' ,`PhotoCount` = '40' ,`PostalCode` = '77055' ,`RoomCount` = '9' ,`ListPrice` = '474900.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Leaf Pass' ,`StreetNumber` = '1704' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2315' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3-story home with custom touches throughout in a gated community! First floor bedroom with en-suite bath and outside access could double as a second primary bedroom, game room, living room, or office. Second story has a spacious living room with 2-story ceilings for loads of natural light! Gorgeous engineered wood floors throughout living area including the kitchen with an oversized island with seating, granite counters, pantry, and SS appliances. Balcony access has views for days! Secondary bedroom with en-suite on 2nd floor. Don\'t miss the primary bedroom retreat which takes up the entire third floor for the ultimate in privacy. Tray ceiling, balcony overlooking the living room, and an en-suite with dual granite counter vanities, tub, walk-in shower with bench, and his and hers closets. Outside has a covered patio and artificial grass for green space with easy maintenance! Zoned for Spring Branch Middle School' ,`Acres` = '0.0495' ,`Area` = '24' ,`BuilderName` = 'Ryland' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 1 RESERVE ON MORITZ' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2155' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'VALLEY OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Reserve/Moritz' ,`TaxAmount` = '9282' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698980' WHERE `Matrix_Unique_ID` = '210419030' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T13:02:22.070' ,`MLSNumber` = '26740130' ,`ListAgentFullName` = 'Esteban Arriaga' ,`ListOfficeName` = 'Unitex Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.893330' ,`Longitude` = '-95.217344' ,`PhotoCount` = '16' ,`PostalCode` = '77044' ,`RoomCount` = '3' ,`ListPrice` = '280000.00' ,`Status` = 'Active' ,`StreetName` = 'Greenmesa' ,`StreetNumber` = '12214' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2414' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 2 story home.Ceramic tile on first floor ,One bedroom on the first floor. Large family room, kitchen and dinette eating area. Dining room opens to kitchen and family room. 3 bedrooms and Gameroom upstairs. Great home with a large backyard! Home is conveniently located to downtown, ship channel, hospitals and shopping. Make you appointment today.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 3 GREENSBROOK SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5316' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'GARRETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'MICHAEL R. NULL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'GREENSBROOK' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698980' WHERE `Matrix_Unique_ID` = '210649336' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T12:39:55.363' ,`MLSNumber` = '98550725' ,`ListAgentFullName` = 'Jay Bradley' ,`ListOfficeName` = 'Equinox Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.709167' ,`Longitude` = '-95.373484' ,`PhotoCount` = '26' ,`PostalCode` = '77021' ,`RoomCount` = '6' ,`ListPrice` = '349990.00' ,`Status` = 'Active' ,`StreetName` = 'Shenandoah' ,`StreetNumber` = '3208' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2424' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Find your dream home in this ready-to-improve Riverside Terrace residence located in the heart of the inner 610 loop. This house features an entertaining-style floor plan with all bedrooms up and multiple downstairs living spaces with an add-on sunroom. The neighborhood provides quick access to highways 288 and 59 and is within blocks of Brays Bayou hike-and-bike trails, the Texas Medical Center, the Houston Museum District, Hermann Park zoo and golf course, and Downtown Houston. It is also conveniently located near universities and within 0.5 miles of the new multimillion-dollar 53-acre Levit Green life sciences development. The classic charm of this home greets you with majestic columns leading into the spacious entry of the family room and features original hardwood flooring throughout. The entire first floor is perfect for entertaining family and friends and offers a spacious floorplan and backyard ready to be customized to your vision. Call today for more information or a tour!' ,`Acres` = '0.1811' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Riverside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 3 & 4A BLK 47' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7888' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'THOMPSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverside Terrace' ,`TaxAmount` = '7591' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1949' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698980' WHERE `Matrix_Unique_ID` = '210717613' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T12:40:47.247' ,`MLSNumber` = '69401727' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '29.852738' ,`Longitude` = '-95.742516' ,`PhotoCount` = '7' ,`PostalCode` = '77449' ,`RoomCount` = '4' ,`ListPrice` = '321490.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Oakwood Meadows Lane' ,`StreetNumber` = '21607' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1748' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SMART NEW D. R. HORTON BUILT 1 STORY 4 BEDROOM! Sought-After Split Plan Design with Private Primary Suite! Island Kitchen with Cabinetry Galore & Corner Walk-In Pantry - Opens to Spacious Breakfast Area & Living Room! Privately Located Primary Suite Features Spacious Walk-In Closet & Pretty Bath with Large Shower! Indoor Utility Room! Hard Surface Flooring in Living Area! Covered Patio Overlooks Backyard! Estimated Completion - October 2022.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 29 - Block 2 - Section 25' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6209' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'GOLBOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'MCDONALD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jasmine Heights' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663698980' WHERE `Matrix_Unique_ID` = '210767312' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T12:38:17.803' ,`MLSNumber` = '29270833' ,`ListAgentFullName` = 'Shara Hymowitz' ,`ListOfficeName` = 'Houston Home Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819802' ,`Longitude` = '-95.420456' ,`PhotoCount` = '12' ,`PostalCode` = '77018' ,`RoomCount` = '9' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'West 35th Street' ,`StreetNumber` = '909-B' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2706' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'From award-winning homebuilder, ROC Homes, this 3-story freestanding new construction features a rare \"1st Floor Lifestyle\" in the heart of Garden Oaks. The 1st floor features your kitchen, living and casual dining space, and Primary and 2 bedrooms are on the 2nd floor, 4th bedroom, study, full bathroom and game room are on the third. Enormous Balcony! Home is estimated to be complete by August 2022, so now is the perfect time to come in our ROC Studio and personalize your finishes! \r\n\r\nOur intimate Oak Grove Park community includes an exclusive Pergola with picnic area, and is in a walkable neighborhood surrounded by family-friendly local shops, restaurants and breweries. It\'s also walking distance from American Legion Park with a baseball/softball field, and it\'s close to major freeways so work will be closer to home and the commute to meet friends and family short.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'ROC Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'na' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1880' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GARDEN OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Garden Oaks' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663698980' WHERE `Matrix_Unique_ID` = '210805490' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T12:24:13.290' ,`MLSNumber` = '80259615' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Ramina Archer' ,`SellingOfficeName` = 'Rocket, Realtors' ,`Latitude` = '30.231843' ,`Longitude` = '-95.241008' ,`PhotoCount` = '20' ,`PostalCode` = '77357' ,`RoomCount` = '8' ,`ListPrice` = '301990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Hazel Branch' ,`StreetNumber` = '14737' ,`StreetSuffix` = 'Drive' ,`City` = 'New Caney' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2498' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PHENOMENAL NEW D. R. HORTON BUILT F-I-V-E BEDROOM! Wonderful Open Concept Interior Layout! Island Kitchen with Corner Walk-In Pantry Opens to Spacious Dining Area & Living Room! Wonderful First Floor Guest Suite/Bedroom with Adjoining Full Bath! Oversized Indoor Utility Room! Incredible Primary Suite with Sitting Area! Lovely Bath with Oversized Shower & Huge Walk-In Closet! Versatile Gameroom/Media Room! Big Secondary Bedrooms! Covered Back Patio! Subdivision offers Pool, Trails, Recreation Center, Splash Pad, AND Elementary School is in the Community! Easy Access to 242, the Grand Parkway, & Hwy 59! Estimated Completion - September 2022.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'D. R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S573392 - Harrington Trails 05B, BLOCK 4, Lot 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4920' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'TIMBER LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harrington Trails' ,`TaxAmount` = '' ,`TaxRate` = '3.42832' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663698980' WHERE `Matrix_Unique_ID` = '210816741' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T12:08:34.107' ,`MLSNumber` = '13681078' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Regan Maas' ,`SellingOfficeName` = 'MVP Realty & Associates' ,`Latitude` = '30.231168' ,`Longitude` = '-95.241934' ,`PhotoCount` = '15' ,`PostalCode` = '77357' ,`RoomCount` = '3' ,`ListPrice` = '251990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Cypress Hollow' ,`StreetNumber` = '14955' ,`StreetSuffix` = '' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1535' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FANTASTIC NEW D. R. HORTON BUILT 1 STORY! Sought-After Open Concept Interior Layout! Gourmet Island Kitchen with Corner Walk-In Pantry - Opens to Spacious Dining Area & Living Room! Privately Located Primary Suite Features Great Bath with Oversized Shower & Big Walk-In Closet! Convenient Indoor Utility Room! Covered Back Patio! Wonderful Community with Pool, Splash Pad, Recreation Center, & Walking Trails - PLUS On-Site Elementary School! Easy Access to Hwy 59, the Grand Parkway, & 242! WOW! Estimated Completion - August 2022.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Express Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Harrington Trails 05A, BLOCK 3, Lot 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4920' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'TIMBER LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harrington Trails' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663698981' WHERE `Matrix_Unique_ID` = '210833608' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T12:55:17.420' ,`MLSNumber` = '4259773' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Kira Kavanaugh' ,`SellingOfficeName` = 'Texas United Realty' ,`Latitude` = '30.061642' ,`Longitude` = '-95.357024' ,`PhotoCount` = '7' ,`PostalCode` = '77373' ,`RoomCount` = '7' ,`ListPrice` = '262990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Kentwood Springs' ,`StreetNumber` = '24046' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1489' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WONDERFUL NEW D. R. HORTON BUILT 1 STORY! Fantastic Location - Easy Access to I-45 & the Hardy Toll Road! Great Interior Layout with Open Living Spaces & Modern Finishes! Lovely Island Kitchen with Espresso Cabinetry - Opens to Spacious Dining Area & Living Room! Privately Located Primary Suite Features Incredible Bath with Oversized Shower & Walk-In Closet! Big Secondary Bedrooms! Convenient Indoor Utility Room! Covered Back Patio & Landscaping Package! Fantastic Community! MUST SEE! Estimated Completion - October 2022.' ,`Acres` = '' ,`Area` = '12' ,`BuilderName` = 'D. R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 19 Block 6 Breckenridge East Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4800' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CHET BURCHETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Breckenridge Forest' ,`TaxAmount` = '' ,`TaxRate` = '3.112' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663698981' WHERE `Matrix_Unique_ID` = '210986535' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T12:13:26.720' ,`MLSNumber` = '97877360' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Lauren Henley' ,`SellingOfficeName` = 'Nextgen Real Estate Properties' ,`Latitude` = '30.533940' ,`Longitude` = '-95.531340' ,`PhotoCount` = '14' ,`PostalCode` = '77358' ,`RoomCount` = '6' ,`ListPrice` = '463785.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Jim Hall' ,`StreetNumber` = '113' ,`StreetSuffix` = 'Lane' ,`City` = 'New Waverly' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2464' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GORGEOUS NEW D. R. HORTON BUILT 1 STORY! EXPANSIVE 1 ACRE LOT! 3 CAR GARAGE! Versatile Interior Layout with Home Office/Study/4th Bedroom! Island Kitchen with Upgraded White Cabinetry! Spacious Living Area with Picture Windows Overlooking HUGE Backyard Oasis! Privately Located Primary Suite Features Garden Bath with Dual Sinks & Big Walk-In Closet! Large Secondary Bedrooms - Both with Walk-In Closets! Home Office/Study/4th Bedroom with Handy Storage Closet! Indoor Utility Room! Extended Covered Back Patio! Double Pane Low-E Windows + LED Lighting for Energy Efficiency! Subdivision is Deed Restricted, but Allows RV Garages & Horses! Great Wooded Homesite with Easy Access to National Park, Lake Conroe, & Boat Slip! Super Low Tax Rate! Estimated Completion - September 2022.' ,`Acres` = '' ,`Area` = '43' ,`BuilderName` = 'D. R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'New Waverly Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WAVERLY PLACE - SEC 1, BLOCK 6, LOT 8' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '43561' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '105 - New Waverly' ,`SchoolElementary` = 'NEW WAVERLY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEW WAVERLY HIGH SCHOOL' ,`SchoolMiddle` = 'NEW WAVERLY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Waverly Place' ,`TaxAmount` = '' ,`TaxRate` = '1.84' ,`WaterSewer` = 'Aerobic,Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663698981' WHERE `Matrix_Unique_ID` = '210988686' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T12:45:00.177' ,`MLSNumber` = '22304523' ,`ListAgentFullName` = 'Aaron Jistel' ,`ListOfficeName` = 'Listing Spark' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.660174' ,`Longitude` = '-95.266121' ,`PhotoCount` = '25' ,`PostalCode` = '77061' ,`RoomCount` = '7' ,`ListPrice` = '224900.00' ,`Status` = 'Active' ,`StreetName` = 'Meadville' ,`StreetNumber` = '8514' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1325' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Recently updated 4 Bedroom, 2 Bathroom home in Gulf Freeway Oaks. The property features upgraded cabinetry with granite countertops (quartz pearl white), new tile shower surround, new EE and plumbing fixtures. The house features a contemporary floor plan, stainless steel appliances, grey scale paint interior and the hardwoods have been resurfaced. Easy to show, cleaned weekly, and schedule today! Brand new AC installed inside and out. Please review agent remarks and MLS documents. Schedule a showing today!!' ,`Acres` = '0.1599' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 15 BLK 1 GULF FREEWAY OAKS SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '6967' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'SOUTH HOUSTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SOUTH HOUSTON HIGH SCHOOL' ,`SchoolMiddle` = 'SOUTHHOUSTON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gulf Fwy Oaks Sec 01' ,`TaxAmount` = '3084' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698981' WHERE `Matrix_Unique_ID` = '211057574' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T12:09:44.660' ,`MLSNumber` = '2109808' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Quynh Drach' ,`SellingOfficeName` = 'CA Modern Realty, LLC' ,`Latitude` = '29.913615' ,`Longitude` = '-95.458064' ,`PhotoCount` = '10' ,`PostalCode` = '77038' ,`RoomCount` = '4' ,`ListPrice` = '303090.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Landon Light' ,`StreetNumber` = '12518' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1717' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful brand NEW Express Home in Fantastic location! Charming curb appeal! Perfect floor plan with open living spaces and modern finishes! Lovely island kitchen with espresso cabinetry! Great Primary suite with large closet and oversized shower! Great outdoor space with covered back patio and landscape package! Hurry and call today because this home will sell FAST!!' ,`Acres` = '' ,`Area` = '11' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 23, Block 2, Section 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6698' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '290' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'SAMMONS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'EISENHOWER HIGH SCHOOL' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Princeton' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663698981' WHERE `Matrix_Unique_ID` = '211105285' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T12:25:42.753' ,`MLSNumber` = '94818453' ,`ListAgentFullName` = 'Jennifer Hurst' ,`ListOfficeName` = 'KJ Platinum Properties LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.698848' ,`Longitude` = '-95.381891' ,`PhotoCount` = '38' ,`PostalCode` = '77054' ,`RoomCount` = '6' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'Charline' ,`StreetNumber` = '3026' ,`StreetSuffix` = 'Avenue' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1945' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great location near the Medical Center. Like new home with 3 bedrooms, 3 full bathrooms plus a half bathroom for guests. There is one bedroom downstairs with a private bathroom. The main level on the second floor has a beautiful island kitchen that is open to the large den. Great space for entertaining. Plus a nice patio to enjoy. The 3rd level has the primary bedroom with a luxurious private bathroom. A must see oversized shower and walk in closet. The 3rd bedroom is on the 3rd floor with a private bathroom. Cool floor plan with lots of space to spread out. Real wood floors through out most of the home. Sleek & modern finishes throughout. Enjoy easy access to the parks nearby. 2 Gated entrances into the community plus a dog park. A must see to appreciate.' ,`Acres` = '0.0326' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 1 BOULEVARD ON GRAND' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '1419' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1195' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'THOMPSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Medical Center' ,`TaxAmount` = '8285' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698981' WHERE `Matrix_Unique_ID` = '211182028' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T13:39:17.360' ,`MLSNumber` = '44098935' ,`ListAgentFullName` = 'Barbie Tucker' ,`ListOfficeName` = 'Etheredge Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.411516' ,`Longitude` = '-94.936836' ,`PhotoCount` = '22' ,`PostalCode` = '77590' ,`RoomCount` = '6' ,`ListPrice` = '500000.00' ,`Status` = 'Active' ,`StreetName` = '29th' ,`StreetNumber` = '2924' ,`StreetSuffix` = 'Street' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '4037' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Large home has 4 bedrooms and 2 baths up front with an adjoining 2 bedrooms and 1 bath in back. This home sits on a total of 5 acres with property #187221. This would be nice for upscale patio homes, a small 55+ community or build your single family dream home on 5 acres! Pictures coming 8.13' ,`Acres` = '0.404' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 142 R LOGAN SUR PT OF LOT 124 (124-6) JEMISON ADDN' ,`LotDesciption` = 'Other' ,`LotSize` = '17598' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'GUAJARDO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TEXAS CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BLOCKER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Jemison Add' ,`TaxAmount` = '4206' ,`TaxRate` = '2.5335' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663698981' WHERE `Matrix_Unique_ID` = '211268933' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T12:42:42.777' ,`MLSNumber` = '34527671' ,`ListAgentFullName` = 'Carrington Shaw' ,`ListOfficeName` = 'Cameron Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.461891' ,`Longitude` = '-95.005794' ,`PhotoCount` = '20' ,`PostalCode` = '77371' ,`RoomCount` = '7' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Marie' ,`StreetNumber` = '921' ,`StreetSuffix` = 'Street' ,`City` = 'Shepherd' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1612' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This unrestricted 4.57 acre property is a great investment opportunity! Could be used as a rural residential property or small home business. Located less than 5 minutes from Hwy 59 in Shepherd! The property has several structures which include a 1,612 sq. ft. house with screened in back porch, a garage/workshop, attached covered carport, shed with fridge included and additional outside covered storage. This property also includes a walk-in game cooler, meat smoker, game hoist and gambrel, dog kennel and a 20 kW Generac generator that is hooked up to the house. The garage/workshop is furnished with double sinks and includes 2 freezers. Large yard with scattered mature trees, including some nice magnolia trees, provides plenty of shade. The front side yard is also home to several fruit trees. Wooded front property line offers tons of privacy!' ,`Acres` = '4.57' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Stove' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Coldspring/South San Jacinto County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'CHERRY CREEK #2, LOT 315 - 319, ACRES 4.59' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '199069' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '130 - Shepherd' ,`SchoolElementary` = 'SHEPHERD PRIMARY SCHOOL' ,`SchoolHigh` = 'SHEPHERD HIGH SCHOOL' ,`SchoolMiddle` = 'SHEPHERD MIDDLE SCHOOL' ,`ShowInstructions` = 'Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cherry Creek #2' ,`TaxAmount` = '2846' ,`TaxRate` = '1.8509' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698982' WHERE `Matrix_Unique_ID` = '211299610' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T13:55:44.420' ,`MLSNumber` = '28376851' ,`ListAgentFullName` = 'Edward McClintick' ,`ListOfficeName` = 'Joseph Walter Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.902289' ,`Longitude` = '-93.920857' ,`PhotoCount` = '10' ,`PostalCode` = '77642' ,`RoomCount` = '4' ,`ListPrice` = '69000.00' ,`Status` = 'Active' ,`StreetName` = '13th' ,`StreetNumber` = '3342' ,`StreetSuffix` = 'Street' ,`City` = 'Port Arthur' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1314' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'AMAZING INVESTMENT OPPORTUNITY!!! PRICED TO SELL!!! WELL UNDER MARKET VALUE!!!' ,`Acres` = '0.1607' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 16 LAMBERT' ,`LotDesciption` = 'Other' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '236 - Port Arthur' ,`SchoolElementary` = 'DEQUEEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (PORT ARTHUR)' ,`SchoolMiddle` = 'LINCOLN MIDDLE SCHOOL (PORT ARTHUR)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Lambert' ,`TaxAmount` = '2137' ,`TaxRate` = '3.267' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663698982' WHERE `Matrix_Unique_ID` = '211407066' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T12:08:34.527' ,`MLSNumber` = '83875437' ,`ListAgentFullName` = 'Michael Munoz' ,`ListOfficeName` = 'M5 Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.724922' ,`Longitude` = '-95.318711' ,`PhotoCount` = '17' ,`PostalCode` = '77023' ,`RoomCount` = '12' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Dismuke' ,`StreetNumber` = '1408' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1584' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great location, close to downtown, shopping centers and schools. Easy access to freeway. Main house located at 5543 Truett with garage apartment on 1408 Dismuke. Main Home is 1584 sq ft, very spacious with 3-bed,1 bath, update kitchen, large living, dining area and two extra open rooms, with lovely laminate and original hardwood floors. Apartment is 882 sq ft 1.bed, 1 bath with living and kitchen. Great for potential income or guest living. Could possible be used for commercial' ,`Acres` = '0.1148' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 22 BLK 3 PLAZA PLACE' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HENDERSON J ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Plaza Place' ,`TaxAmount` = '4436' ,`TaxRate` = '2.6764' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1938' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663698982' WHERE `Matrix_Unique_ID` = '211414020' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T13:04:10.020' ,`MLSNumber` = '87055486' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.431583' ,`Longitude` = '-95.459833' ,`PhotoCount` = '12' ,`PostalCode` = '77583' ,`RoomCount` = '8' ,`ListPrice` = '396030.00' ,`Status` = 'Active' ,`StreetName` = 'Red Hills' ,`StreetNumber` = '1238' ,`StreetSuffix` = 'Drive' ,`City` = 'Iowa Colony' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2502' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'See sample VIRTUAL TOUR! Beautiful Beckenham Floor Plan with 4 Bedrooms, 2 ½ Baths, with attached 2 car Garage. This floor plan boasts a SPACIOUS OPEN CONCEPT FLOOR PLAN with the Family Room, Kitchen, Breakfast Room, Half Bath, Utility Room, and Owner’s Retreat downstairs. Upstairs you will find a Game room, 3 Bedrooms, 2 with walk in closets, & another Full Bath. You will love the Kitchen with lots of cabinets & granite countertops with under the cabinet lighting, stainless steel appliances, and even a USB outlet. Covered Patio & Fenced Backyard. COST AND ENERGY EFFICIENT FEATURES: 16 Seer HVAC System, Honeywell Programmable Thermostat, Pex Hot and cold Water Lines, Radiant Barrier, Rheem® Tankless Gas Water Heater, and Vinyl Double Pane Low E Windows that open to the inside of the home for easy cleaning. Amenities include Playground, Dog Park, Splash Pad and Olympic size pool, Hiking/Biking Trails and 4 ACRE Lagoon coming soon.' ,`Acres` = '0.1519' ,`Area` = '5' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIERRA VISTA WEST SEC 3 (A0329 LAV NAV CO) BLK 2 LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6617' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista West' ,`TaxAmount` = '1470' ,`TaxRate` = '3.6007' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663698982' WHERE `Matrix_Unique_ID` = '211431945' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T13:01:04.383' ,`MLSNumber` = '81987797' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.432054' ,`Longitude` = '-95.460226' ,`PhotoCount` = '11' ,`PostalCode` = '77583' ,`RoomCount` = '8' ,`ListPrice` = '343337.00' ,`Status` = 'Active' ,`StreetName` = 'Red Hills' ,`StreetNumber` = '1229' ,`StreetSuffix` = 'Drive' ,`City` = 'Iowa Colony' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1725' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 1 story, Devon Floor Plan with 4 Bedrooms, 2 Baths, and an attached 2 Car Garage. This floor plan boasts a SPACIOUS OPEN CONCEPT FLOOR PLAN and HIGH CEILINGS with a Family Room, Kitchen, Breakfast Room, and 4 Bedrooms with 2 full Baths. Tile and carpet flooring. You will love the Kitchen with lots of cabinets and granite countertops with under the cabinet lighting, stainless steel appliances, and even a USB outlet. Comes with COVERED PATIO and fenced backyard. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Thermostat, Pex Hot & Cold Water Lines, Radiant Barrier, Rheem Gas Tankless Water Heater, and Low E Windows that open to the inside of the home for cleaning. Amenities include Playground, Dog Park, Splash Pad and Olympic size pool, Hiking/Biking Trails and 4 ACRE Lagoon coming soon. Convenient to Downtown Houston, Medical Center, Pearland, & the Beach! Alvin ISD. Call today for your private tour!' ,`Acres` = '0.1435' ,`Area` = '5' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIERRA VISTA WEST SEC 3 (A0329 LAV NAV CO) BLK 3 LOT 15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6251' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Sierra Vista West' ,`TaxAmount` = '1406' ,`TaxRate` = '3.6007' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663698982' WHERE `Matrix_Unique_ID` = '211432827' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T13:45:47.630' ,`MLSNumber` = '20326832' ,`ListAgentFullName` = 'Senon Sabando' ,`ListOfficeName` = 'Ameri Choice Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.711576' ,`Longitude` = '-95.525693' ,`PhotoCount` = '27' ,`PostalCode` = '77036' ,`RoomCount` = '8' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Golf Green' ,`StreetNumber` = '8126' ,`StreetSuffix` = 'Circle' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2078' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful renovated 2 story 4 Bedroom Home in a Gated Community surrounded by Golf Course. Laminate Wood Floors throughout except wet areas. Updated Kitchen with Granite Counter Tops accented with Subway Tile Backsplash. Spacious Living/Family Room with Updated Powder Room. Four Bedrooms Upstairs with Spacious Game Room. Primary Bedroom with en-suite Bath, Granite Counters, Separate Shower and Garden Tub with Walk-in Closet. This property has easy access to Highway 59, Beltway 8, & Westpark Toll Rd., It\'s located in the Heart of China Town. Annual HOA Fees includes Garbage/Trash, and Front Loan Maintenance. Measurements are approximate, buyer must independently verify. NEVER FLOODED!!!' ,`Acres` = '0.0993' ,`Area` = '21' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sharpstown Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 1 GOLF GREEN GARDEN HOMES 2 AMND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4326' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '688' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'NEFF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHARPSTOWN HIGH SCHOOL' ,`SchoolMiddle` = 'SUGAR GROVE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Golf Green Garden Homes 02 Amd' ,`TaxAmount` = '5214' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698982' WHERE `Matrix_Unique_ID` = '211434815' --> Updated record success