Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T04:12:27.073' ,`MLSNumber` = '73893699' ,`ListAgentFullName` = 'Mary DeVore' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.971496' ,`Longitude` = '-95.571994' ,`PhotoCount` = '39' ,`PostalCode` = '77070' ,`RoomCount` = '9' ,`ListPrice` = '328000.00' ,`Status` = 'Active' ,`StreetName` = 'Indigo Trace' ,`StreetNumber` = '13418' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2162' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to an amazing one story home located in a quiet subdivision. Tile & laminate wood floors greet you at the front door & continue throughout. Light & bright Open floor plan which makes it perfect for entertaining. Formal living room with double sided fireplace to the Den. Granite countertops/stone backsplash & double pantry in the island kitchen. Breakfast area with a bench window seat, shelves & glass front cabinets. Split plan with Primary Bedroom separate from Secondary bedrooms. Primary bath with walk-in tub & separate shower & double closets. 4th bedroom has a wall of built-ins which makes for a great study if you work from home. Wonderful back Patio with windows/screens and fan. Whole house Generator. 2\" wood blinds, panel doors and ceiling fans throughout. No flooding per seller.' ,`Acres` = '0.1515' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 27 BLK 4 MANDOLIN VILLAGE ONE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HANCOCK ELEMENTARY SCHOOL (CY-FAIR)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mandolin Village 1' ,`TaxAmount` = '5981' ,`TaxRate` = '2.5937' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202641' WHERE `Matrix_Unique_ID` = '209538891' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T04:36:01.523' ,`MLSNumber` = '81737355' ,`ListAgentFullName` = 'Kourtney Walker' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.498953' ,`Longitude` = '-95.510650' ,`PhotoCount` = '50' ,`PostalCode` = '77459' ,`RoomCount` = '8' ,`ListPrice` = '339000.00' ,`Status` = 'Active' ,`StreetName` = 'Bahia' ,`StreetNumber` = '3506' ,`StreetSuffix` = 'Court' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2360' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely 2-story home on a cul-de-sac with a beautiful back yard that includes an outdoor kitchen and turf. This open floor plan features 4 bedrooms/2 bathroom home with a powder room on the first floor. The entryway has high ceilings and a view of the den/kitchen area. The kitchen has an abundance of cabinets, granite counter tops and is open to the den with a cozy fireplace. The oversized 2-car garage has a small workspace. The secondary floor offers a large primary bedroom with spa-like bathroom. As well as, three secondary bedrooms and a secondary bathroom. The master planned community of Sienna offers many amenities such as: pools, splashpads, parks and sidewalks. The community is located in the recognized schools of Fort Bend ISD. Call The Walker Team to schedule your private showing today.' ,`Acres` = '0.1514' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIENNA VILLAGE OF SHIPMAN\'S LANDING SEC 3, BLOCK 1, LOT 37' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6595' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SCANLAN OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna Village Of Shipmans Landing' ,`TaxAmount` = '' ,`TaxRate` = '2.5729' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202641' WHERE `Matrix_Unique_ID` = '209657116' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T05:12:39.573' ,`MLSNumber` = '66480785' ,`ListAgentFullName` = 'Jennifer Pachall' ,`ListOfficeName` = 'M. Moffett & Co. Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.797360' ,`Longitude` = '-94.438107' ,`PhotoCount` = '50' ,`PostalCode` = '75979' ,`RoomCount` = '14' ,`ListPrice` = '573900.00' ,`Status` = 'Active' ,`StreetName` = 'Forest Dr' ,`StreetNumber` = '147' ,`StreetSuffix` = 'Drive' ,`City` = 'Woodville' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '3669' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Secluded in a quiet lakefront addition 4bd/4 1/2 bth two-story 3,669 sqft executive home offers NEW ROOF, beautiful upgraded floors, counter tops, stunning kitchen opening to breakfast area & family room, 2 master suites, formal entry, formal dining, parlor rooms, walk-out French doors, two covered porches w/wonderful elevated views of 1.24 acres w/mature, shady hardwoods leading to a private lake below! The the updated home has engineered wood flooring, quartz countertops, block paneled ceilings; wainscoting; recessed lighting, oak stairwell, two fireplaces w/oak mantle. The home has dual circular concrete drives, an open two-car carport, outdoor storage, and one-half bath. Storage for outdoor equipment & personal items underneath the home. Private lake access w/side park pavilion, & fishing is excellent! A desirable private location a few minutes from the center of a small east Texas town & only a 90-minute drive from north Houston. Showings by appointment only.' ,`Acres` = '1.24' ,`Area` = '48' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Tyler County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'CHESSWOOD NORTH, LOT 2, (A20 & A433), S2251, 1.24+/- acs' ,`LotDesciption` = 'Cleared,Water View,Waterfront' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '253 - Woodville' ,`SchoolElementary` = 'WHEAT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WOODVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'WOODVILLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Chesswood' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202641' WHERE `Matrix_Unique_ID` = '210420950' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T05:13:57.337' ,`MLSNumber` = '69476582' ,`ListAgentFullName` = 'Jennifer Pachall' ,`ListOfficeName` = 'M. Moffett & Co. Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.862595' ,`Longitude` = '-94.447787' ,`PhotoCount` = '18' ,`PostalCode` = '75938' ,`RoomCount` = '4' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 2780' ,`StreetNumber` = '2080' ,`StreetSuffix` = 'Road' ,`City` = 'Colmesneil' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nice Brick Ranch Home with over 3500 sqft of living space on just over one acre featuring large master with large walk in closet, ensuite, large canning pantry, two sunrooms, living room/Den with wood burning fireplace, attached open kitchen, four bedrooms with three baths, tile flooring, formal dining with long wrap around enclosed walkout porch with large picture windows, fireplace in inviting guest bedroom, with convenient jack & jill bath, inviting siting porch attached, perfect for watching wildlife, decorative farmhouse furnishings throughout. Outside you can find a nice workshop with useful improvements for country living, unrestricted, this property sets privately at the end of a lonely country road, lots of pretty flowerings, mixed hard woods & pines, and fruit trees can be found throughout. Located in Colmesniel, TX, this property is only one and a half hours from North Houston, and only about 45 minutes from Lufkin.' ,`Acres` = '1' ,`Area` = '48' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Tyler County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0124 BBB & CRR CO,ACRES 1.0' ,`LotDesciption` = 'Wooded' ,`LotSize` = '43560' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '427 - Colmesneil' ,`SchoolElementary` = 'COLMESNEIL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLMESNEIL HIGH SCHOOL' ,`SchoolMiddle` = 'COLMESNEIL MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Right Side' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'None' ,`TaxAmount` = '2473' ,`TaxRate` = '2.0383' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1666202641' WHERE `Matrix_Unique_ID` = '210422981' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T05:20:44.523' ,`MLSNumber` = '60858969' ,`ListAgentFullName` = 'James Hickok' ,`ListOfficeName` = 'The Local Agents Real Estate LLC' ,`SellingAgentFullName` = 'James Hickok' ,`SellingOfficeName` = 'The Local Agents Real Estate LLC' ,`Latitude` = '28.955486' ,`Longitude` = '-95.283083' ,`PhotoCount` = '39' ,`PostalCode` = '77541' ,`RoomCount` = '3' ,`ListPrice` = '339000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Driftwood' ,`StreetNumber` = '319' ,`StreetSuffix` = 'Court' ,`City` = 'Surfside Beach' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1312' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 319 Driftwood Ct, which is a short walk to the beach where memories are made! This cute 3 bedroom 2 bath home has a split floorplan with bedrooms on either side with living, dining and kitchen within the center. Two rooms use a Jack and Jill bathroom, while the 3rd bedroom has access to the hallway bathroom. Multiple seating areas throughout the dining and living areas to enjoy water views, you can also separate the dining seating area with the living area with pocket doors for privacy. A large deck wraps around 2 sides with access only from within house, there is a separate deck with stairs to access the front door. Stackable washer and dryer inside the house in one of the bedroom closets. Two central AC units. Under the home has a full concrete pad with 3 storage rooms, one with a shower and toilet which is not counted in the listing. Walking distance to local restaurants and shopping. All furnishings included!' ,`Acres` = '0.14' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'KRAMIG LTS 46-46A (A0051 FJ CALVIT DIV 2 (B C I C)(SURFSIDE)' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '6098' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kramig Lts 46-46a' ,`TaxAmount` = '5158' ,`TaxRate` = '2.333' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202641' WHERE `Matrix_Unique_ID` = '211052569' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T05:07:11.243' ,`MLSNumber` = '89418793' ,`ListAgentFullName` = 'Jennifer Pachall' ,`ListOfficeName` = 'M. Moffett & Co. Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.790912' ,`Longitude` = '-94.432800' ,`PhotoCount` = '28' ,`PostalCode` = '75979' ,`RoomCount` = '6' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Wayne' ,`StreetNumber` = '12' ,`StreetSuffix` = 'Drive' ,`City` = 'Woodville' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Newly Renovated beautiful Ranch style home nestled in private subdivision community with private Lake/recreational access, including fishing, boating, etc. on almost one full acre offering little over 2500 sqft with large side yard w/ lots of open space, setting high & dry decorated in beautiful flowerings, large pine trees, oversized deck w/ attached screened in back porch, & oversized two car garage! This updated nicely kept home offers a stunning new kitchen with new cabinets and quartz countertops, stainless steel appliances add elegance, two large master bedrooms with shower & tub combination, three baths, large living area, large additional living area/den, oversized mudroom/laundry room with attached bathroom, and lots of storage throughout! Located in high demand location close to schools & in town conveniences, restaurants with no HOA fee, this home is only 2 hours south of North Houston and about 45 minutes from Lufkin or Beaumont.' ,`Acres` = '0.911' ,`Area` = '48' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Tyler County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S2250 CHESSWOOD (A20 & A433), BLK 1, LOT 2, ACRES 0.911' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '39683' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '253 - Woodville' ,`SchoolElementary` = 'WHEAT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WOODVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'WOODVILLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Chesswood' ,`TaxAmount` = '4817' ,`TaxRate` = '2.3293' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1666202642' WHERE `Matrix_Unique_ID` = '211092041' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T05:44:32.720' ,`MLSNumber` = '73274288' ,`ListAgentFullName` = 'Lisa Sanders' ,`ListOfficeName` = 'Living Vogue Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.480960' ,`Longitude` = '-94.938666' ,`PhotoCount` = '48' ,`PostalCode` = '77539' ,`RoomCount` = '8' ,`ListPrice` = '419000.00' ,`Status` = 'Active' ,`StreetName` = 'Dick Bay' ,`StreetNumber` = '1232' ,`StreetSuffix` = 'Drive' ,`City` = 'San Leon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1904' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for a property with PROVEN Airbnb income? You can live the high life upstairs while renting out the downstairs and an additional six income-producing covered boat slips with lifts! No HOA, so you can even store your RV in front! Perfect income-producing home! Just blocks from Top Water Grill! This fully furnished home sits on the mouth of the deepwater canal leading to Dickinson Bay in the historic city of San Leon. This property features two large living areas, two full kitchens, two full bathrooms, a bar, and a sunroom. Walk outside to the backyard and enjoy a covered patio with a swing, picnic table, fans, smoker, grill, and fire pit. Plenty of seating to relax and enjoy the boats and the water. Imagine fishing and catching crab out of the backyard. It comes furnished and is currently rented out consistently throughout the year. New Roof 2017, new storm windows 2015, New AC 2021, new plumbing 2021, new water heater 2021, boathouse built-in 2013, and over 220 ft of bulkhead.' ,`Acres` = '0.2459' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Central Gas,Other Heating,Propane' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 10 A EDWARDS SUR LOT 46 FIESTA ESTATES' ,`LotDesciption` = 'Other,Water View,Waterfront' ,`LotSize` = '10712' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'SAN LEON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Fiesta Estates' ,`TaxAmount` = '3507' ,`TaxRate` = '2.7147' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202642' WHERE `Matrix_Unique_ID` = '211911786' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T04:39:49.033' ,`MLSNumber` = '49941435' ,`ListAgentFullName` = 'Virginia Ledwell' ,`ListOfficeName` = 'Led Well Realty' ,`SellingAgentFullName` = 'Daisy Guzman' ,`SellingOfficeName` = 'Texas Legacy Properties' ,`Latitude` = '29.820832' ,`Longitude` = '-95.412058' ,`PhotoCount` = '22' ,`PostalCode` = '77018' ,`RoomCount` = '8' ,`ListPrice` = '600000.00' ,`Status` = 'Option Pending' ,`StreetName` = '38th' ,`StreetNumber` = '721' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2166' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 721 W 38th! This quintessential Garden Oaks gem sits on an over 14k square foot lot in the heart of Garden Oaks. While currently on the market for lot value, this livable home offers: two ensuite bedrooms- one with three walk-in closets, a large standalone shower, & garden tub, & the other with a tub/shower combo, a 3rd spacious secondary bedroom, a separate home office/flex space, cathedral ceiling & built-ins in the dining room, a 3rd full bath with shower, solid wood floors throughout, double pane windows, recessed lighting, a 2 car garage behind an iron gate, partially covered wood deck, & huge yard with mature foliage. The Oak Forest/Garden Oaks area, commonly known as the GOOF, has loads to offer when it comes to shopping, exercise, & restaurants. This home is just a couple of blocks from Wakefield Crowbar, William Price Distillery, Walking Stick, & D’Alba. Zoned to Garden Oaks Montessori Magnet and located central to 610, I10, I45, 59, & 290.' ,`Acres` = '0.3354' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Garden Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 24 GARDEN OAKS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14610' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`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` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Garden Oaks Sec 02' ,`TaxAmount` = '15770' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202642' WHERE `Matrix_Unique_ID` = '212772961' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T05:59:15.593' ,`MLSNumber` = '88101589' ,`ListAgentFullName` = 'Dawn Dietz' ,`ListOfficeName` = 'Top Guns Realty on Lake Conroe' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.369383' ,`Longitude` = '-95.598875' ,`PhotoCount` = '46' ,`PostalCode` = '77356' ,`RoomCount` = '10' ,`ListPrice` = '515000.00' ,`Status` = 'Active' ,`StreetName` = 'Lakeside' ,`StreetNumber` = '111' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2703' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Are you looking for a new home with plenty of space for everyone? Look no further than this gorgeous, split floorplan featuring 3 BR and 2.5 baths, all on one level with a bonus room upstairs that can be used as a game room, office space, or another bedroom. With all of the multiple upgrades/remodeling done over the last several years you won\'t have any worry when buying this home. Upgrades/Remodeling include:New Paint 2022, paint 2019 master, gameroon and half bath,2019 New Roof, A/C 2017, New Windows 2015, and more. If you enjoy cooking, this kitchen is going to be a dream for you. The amount of cabinets you will have to store all your goodies and prep space is amazing. Do you love entertaining outdoors? You will enjoy bringing all your friends and family out to your multilevel, huge, backyard deck. April Sound offers so many great amenities and is located just minutes from shopping, boating, multiple restaurants, hiking trails and much more. Call today for your private showing!' ,`Acres` = '0.2823' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S215004 - APRIL SOUND 04, BLOCK 3, LOT 18, ACRES 0.2823' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '12296' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '204' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Other Style' ,`Subdivision` = 'April Sound 04' ,`TaxAmount` = '6058' ,`TaxRate` = '2.3389' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202642' WHERE `Matrix_Unique_ID` = '212978206' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T05:37:45.347' ,`MLSNumber` = '80108114' ,`ListAgentFullName` = 'Troy Chase' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.527385' ,`Longitude` = '-95.046517' ,`PhotoCount` = '48' ,`PostalCode` = '77573' ,`RoomCount` = '6' ,`ListPrice` = '349999.00' ,`Status` = 'Active' ,`StreetName` = 'Dawn Crest' ,`StreetNumber` = '2006' ,`StreetSuffix` = 'Court' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2247' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the stunning 2006 Dawn Crest Court located in the sought after Harbour Park neighborhood! This home features four beds, two baths, an open concept kitchen with updated lighting and living area with crown molding. Enjoy the beautiful living area with high ceilings, fresh updated paint, no carpet, and natural lighting as you relax by the fireplace for a cozy movie day. Ac and Furnace update in 2018, and new hot water heater and gas was installed in 2022. Step outside to a cemented patio area great for any bbq outing and plenty of green space for many activities. We cannot forget the detached garage with a covered walkway, and driveway gate. Don’t miss out on this beautiful home and come out and see it today!' ,`Acres` = '0.1818' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 18 M MULDOON SUR LOT 9 BLK 1 HARBOUR PARK SEC 5' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7918' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '605' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'FERGUSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CLEAR CREEK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harbour Park Sec 5 93' ,`TaxAmount` = '6252' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202642' WHERE `Matrix_Unique_ID` = '213252610' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T05:53:54.640' ,`MLSNumber` = '98565951' ,`ListAgentFullName` = 'Telma Garcia' ,`ListOfficeName` = 'Prime Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.968115' ,`Longitude` = '-95.193799' ,`PhotoCount` = '30' ,`PostalCode` = '77346' ,`RoomCount` = '8' ,`ListPrice` = '310000.00' ,`Status` = 'Active' ,`StreetName` = 'Kobuk Valley' ,`StreetNumber` = '17239' ,`StreetSuffix` = 'Circle' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1851' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This fantastic one-story home combines desirable location, an open floor plan, and modern updates into one attractive package. Featuring 10-foot ceilings and hardwood or tile floors throughout(no carpet). This home also offers a newly remodeled primary bathroom with an amazing custom closet! Recent new A/C and Water heater units. The open living and kitchen area includes energy-efficient s.s. appliances and plenty of room for cooking or entertaining. The large backyard and covered patio make grilling with the family a breeze. Never flooded. Located in the master planned community of Eagle Springs and situated in a family-friendly cul-de-sac, this perfect home is also conveniently close to Atascocita, Humble, Beltway and Hwy 59. Neighborhood amenities include 24-hour fitness center, resort style pools, sports fields, splash pad, several parks, and seasonal events! Schedule your private showing before this home is gone!' ,`Acres` = '0.1515' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 28 BLK 1 EAGLE SPRINGS SEC 19' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6598' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '825' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'ATASCOCITA SPRINGS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Eagle Springs' ,`TaxAmount` = '5905' ,`TaxRate` = '2.913' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202643' WHERE `Matrix_Unique_ID` = '213393823' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213759047','1666202643','213759047','2022-10-18T05:53:13.300','62416718','Gretchen Barrilleaux','Coldwell Banker Realty','','','29.652527','-95.724758','45','77406','11','665000.00','Active','Reagan Ridge','4207','Court','Richmond','3','1','4','3842','Single-Family','Wow! Come see this Harvest Green Beauty that SHINES w/ the pride of ownership! Fantastic curb appeal greets you to this Westin Hopkins floor plan w/ 4 bedrooms/3.5 baths w/ study, formal dining, game room. LOADS of custom features! Soaring ceilings w/ dramatic rotunda ceiling & spiral staircase sweep you in! Extended tile & gorgeous rich wood floors! LOADS of natural light! Spacious family room w/ cozy fireplace is open to island kitchen that boasts custom cabinets w/ butler’s pantry, wine bar & private desk area. Gas cooking, pendant lights, & walk-in pantry! Relax in the private owner’s retreat w/ custom paint & millwork! Spa like bath w/ oversized shower, soaking tub, dual sinks, & vanity area! Large walk-in closet w/ direct access to laundry room! Great secondary bedrooms & storage! Covered patio! Sprinkler system! Highly desired Fort Bend ISD schools in the neighborhood! Award-wining Harvest Green amenities-parks, trails, pool & splash pad, gym, tennis and volleyball & more!','0.1653','37','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections','1','Fort Bend County North/Richmond','Central Gas','1','HARVEST GREEN SEC 11, BLOCK 1, LOT 41','Subdivision Lot','7200','Appraisal District','','1100','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','19 - Fort Bend','NEILL ELEMENTARY SCHOOL','TRAVIS HIGH SCHOOL (FORT BEND)','BOWIE MIDDLE SCHOOL (FORT BEND)','Appointment Required','Appraisal','2','Traditional','Harvest Green Sec 11','13718','3.1129','Water District','2017','Appraisal District'); --> New record created successfully