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-22T07:26:03.400' ,`MLSNumber` = '52373900' ,`ListAgentFullName` = 'Michelle Courtney' ,`ListOfficeName` = 'Double G Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.700676' ,`Longitude` = '-96.539331' ,`PhotoCount` = '50' ,`PostalCode` = '78934' ,`RoomCount` = '8' ,`ListPrice` = '599900.00' ,`Status` = 'Active' ,`StreetName` = 'Travis' ,`StreetNumber` = '1620' ,`StreetSuffix` = 'Street' ,`City` = 'Columbus' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3014' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Victorian Style home, awaits it\'s new owners. Spacious den features a shiplap wall, large windows, built-in custom cabinetry, & a hall tree bench. Living room located to the back of the home great for entertaining.Formal dining area is perfect for your treasured antiques & features a elegant chandelier. Fully equipped kitchen with modern conveniences: farmhouse style sink, 2 stainless double ovens, dishwasher, 2 refrigerators to convey, island cook top, under cabinet lighting, tile backsplash, beautiful counter tops, & a butler\'s pantry. Primary bedroom is located downstairs. Upstairs are 3 bedrooms, 2 baths, & the laundry area. Additional features include crown molding, wood floors, tall ceilings, 4 decorative fireplaces, 2 gas log fireplaces, staircase, wood shutters. Enjoy summer evenings on the front, side or cozy back porch. Additional bonuses: manicured lawn, fenced backyard, trees, a studio, 2 car detached garage with an workshop area, & sprinkler system.' ,`Acres` = '0.5531' ,`Area` = '56' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '6' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'BLK 32 LT PT 2,3,5,6 COLUMBUS HOUSE & GARAGE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '24093' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '188 - Columbus' ,`SchoolElementary` = 'COLUMBUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLUMBUS HIGH SCHOOL' ,`SchoolMiddle` = 'COLUMBUS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Columbus' ,`TaxAmount` = '6234' ,`TaxRate` = '1.8359' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1880' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1666486812' WHERE `Matrix_Unique_ID` = '208332899' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T07:47:26.737' ,`MLSNumber` = '14578381' ,`ListAgentFullName` = 'Nancy Risk' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.760644' ,`Longitude` = '-95.499818' ,`PhotoCount` = '48' ,`PostalCode` = '77024' ,`RoomCount` = '15' ,`ListPrice` = '2159000.00' ,`Status` = 'Active' ,`StreetName` = 'Magnolia Bend' ,`StreetNumber` = '3' ,`StreetSuffix` = 'Drive' ,`City` = 'Hunters Creek Village' ,`BathsFull` = '6' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '8766' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nestled on a quiet ½+ acre cul-de-sac lot in the heart of Hunters Creek, this sleek & modern home was reimagined in 2021. Compare prices per sq ft of homes in Memorial! 2021 Elevator to all floors! 1st floor w/white Italian tile features large entertaining space, 900 bottle wine vault, full bath+ wall of glass doors leading to fenced yard & patio. The 2nd floor w/ engineered wd floors has: formal living, dining + family room, 2021\r\neat-in kitchen w/custom cabinets, quartz counters, cafe appliances, bkfst bar + 2 private bdrms; each w/ensuite baths &walk-in closets. The 2nd fl balcony spans the back of the home. The 3rd floor w/ engineered wood flrs features an oversized primary suite, large space + 2 add\'l bdrms [with ensuite baths] + a living, kitchen & office spaces- the perfect suite or apartment for guests, kids, or family. 2021 updates include windows, baths, ac & heat, LED lighting, fence, engineer-designed retaining wall + more. 2022 hot water heaters. All per Seller.' ,`Acres` = '0.6224' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Reports Available,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BAYOU BEND ESTATES' ,`LotDesciption` = 'Ravine' ,`LotSize` = '27110' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'HUNTERS CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,French' ,`Subdivision` = 'Bayou Bend Estates' ,`TaxAmount` = '32426' ,`TaxRate` = '2.1111' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666486812' WHERE `Matrix_Unique_ID` = '209937596' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T07:31:29.983' ,`MLSNumber` = '41971118' ,`ListAgentFullName` = 'Bret Richards' ,`ListOfficeName` = 'Coleman & Patterson, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.633545' ,`Longitude` = '-96.137298' ,`PhotoCount` = '50' ,`PostalCode` = '77861' ,`RoomCount` = '8' ,`ListPrice` = '634900.00' ,`Status` = 'Active' ,`StreetName` = 'Scarborough' ,`StreetNumber` = '9097' ,`StreetSuffix` = 'Drive' ,`City` = 'Iola' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3036' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to Country Living! Welcome Home to New Construction! Located in highly sought-after King Oaks, an acreage lot and lifestyle neighborhood located just 4 miles from all the convenience of south College Station, TX, this 4 Bed/2.5 Bath upcoming Manley Home will be ready for you soon! An open floor plan offers over 3,000 Sq.Ft of pure bliss with relaxing wood-burning fireplace in the living room opening to kitchen/dining, where you will find built-in appliances and spacious pantry. An additional flex space/ office downstairs plus 2nd floor bonus room with storage, your new home will provide the perfect indoor retreat to match all the exterior amenities of your tremendous neighborhood. Community amenities including the 60-acre nature preserve and trails, the stocked fishing pond and park, the community pool and summer kitchen as well as an outdoor fireplace.' ,`Acres` = '1.61' ,`Area` = '60' ,`BuilderName` = 'Manley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bedias/Roans Prairie Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'KING OAKS SECTION 3, LOT 464, ACRES 1.61, (RE-PLAT 1646/278)' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '70132' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '171 - Iola' ,`SchoolElementary` = 'IOLA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOLA HIGH SCHOOL' ,`SchoolMiddle` = 'IOLA HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style,Ranch' ,`Subdivision` = 'King Oaks Sec 3' ,`TaxAmount` = '544' ,`TaxRate` = '1.5955' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '202' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666486813' WHERE `Matrix_Unique_ID` = '210385861' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T07:55:37.240' ,`MLSNumber` = '17368205' ,`ListAgentFullName` = 'Phyllis Orman' ,`ListOfficeName` = 'Real Estate Connection Int' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.957982' ,`Longitude` = '-95.272556' ,`PhotoCount` = '36' ,`PostalCode` = '77396' ,`RoomCount` = '13' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Oriole Lane' ,`StreetNumber` = '7702' ,`StreetSuffix` = '' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3204' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful one of a kind large two story home (3204 sq ft) with additional lot (6900 sq ft) ready for move in. The home features 4 bedrooms with 2.5 bath, dining room, study/office and upstairs game room. Open concept kitchen to family room with fireplace. Separate large dining room and private study/office downstairs located in front of home. Utility room downstairs. Beautiful tile flooring throughout down stairs and wood flooring upstairs. Primary bedroom is located off the living area with a large walk in closet, garden tub and shower. Upstairs finds kids retreat with 3 comfortable bedrooms with large windows for natural light and large game/ media room. Backyard has extended patio with added storage. The home is completely fenced (home & lot) with plenty of room on the lot for an RV and build your own beautiful pool. Great location in Humble and No HOA. This property has easy access to shopping, restaurants, and Bush Intercontinental Airport. This home is a must see!!' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Humble Area East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 5 TIMBERWOOD SEC 9' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'JACK M. FIELDS SR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'ROSS STERLING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Timberwood' ,`TaxAmount` = '' ,`TaxRate` = '2.2965' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666486813' WHERE `Matrix_Unique_ID` = '210432080' --> 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','210802106','1666486813','210802106','2022-10-22T07:53:37.327','90001743','Hoa Pham','Lone Star Realty','','','29.558975','-95.711664','50','77469','10','385000.00','Active','Cozy Hollow','21739','Lane','Richmond','3','1','4','3278','Single-Family','Great floor plan highly sought in River Park West subdivision. New installed vinyl throughout first floor. High ceiling in the family room and primary room down. Large master bedroom, kitchen with island open to living room. It\'s good for entertainment and family interaction. Nice open floor plan, that has primary room with double-sink and separate shower. Huge game room and media/theater room upstairs, spacious bedrooms on 2nd floor. House needs TLC, sold As-Is. Don\'t miss this gem and it won\'t be available long. Thank you for interested','0.192','30','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','2','Fort Bend South/Richmond','Central Gas','1','RIVERPARK WEST SEC 6, BLOCK 1, LOT 15','Subdivision Lot','8364','Appraisal District','','850','0','','2','Electric Oven','0','','','','','Composition','33 - Lamar Consolidated','HUTCHISON ELEMENTARY SCHOOL','LAMAR CONSOLIDATED HIGH SCHOOL','WESSENDORF/LAMAR JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Riverpark West Sec 6','7708','2.8748','Public Sewer,Public Water,Water District','2005','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T07:10:14.400' ,`MLSNumber` = '38067658' ,`ListAgentFullName` = 'Steven Andrews' ,`ListOfficeName` = 'Texas Premier Realty' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '32.802187' ,`Longitude` = '-94.722470' ,`PhotoCount` = '29' ,`PostalCode` = '75683' ,`RoomCount` = '3' ,`ListPrice` = '215000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Redbud' ,`StreetNumber` = '206' ,`StreetSuffix` = 'Street' ,`City` = 'Ore City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your new home has a fresh new look and is absolutely a show stopper. This beauty is perfect with a nice sized back yard for the kids and Fido to play. This home features new granite countertops, new appliances, floors and much more. It also has a nice covered patio in the back yard great for entertaining. Call today to schedule your private home tour.' ,`Acres` = '0.4821' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 4-6, BLK 60 ORE CITY S269 (A297) .4821 ACRES & HOUSE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '21000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '793 - Ore City' ,`SchoolElementary` = 'ORE CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ORE CITY HIGH SCHOOL' ,`SchoolMiddle` = 'ORE CITY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Right Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ore City' ,`TaxAmount` = '2237' ,`TaxRate` = '2.5779' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666486813' WHERE `Matrix_Unique_ID` = '210870221' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T07:24:28.630' ,`MLSNumber` = '16836480' ,`ListAgentFullName` = 'Maria Diaz Diaz' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = 'Noelia Schmidt' ,`SellingOfficeName` = 'Keller Williams Realty - Memorial' ,`Latitude` = '29.801507' ,`Longitude` = '-95.416884' ,`PhotoCount` = '13' ,`PostalCode` = '77008' ,`RoomCount` = '2' ,`ListPrice` = '425000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = '18th' ,`StreetNumber` = '1018' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '736' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t miss out on the great investment opportunity this property offers! Centrally and conveniently located in a 10,950 sqft lot in Shady Acres and surrounded by many of the main points of interest the Heights area provides, at a walkable distance! For sale at lot value only and under an AS-IS condition. Deep and wide lot with enough capacity to fit 4-5 free standing properties. Drive by and visualize your dream residential project or any other development this space allows!' ,`Acres` = '0.2514' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'TR 353A SHADY ACRES EXTN SEC 3' ,`LotDesciption` = 'Other' ,`LotSize` = '10950' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Controlled Access,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Shady Acres Ext Sec 03' ,`TaxAmount` = '6502' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1666486813' WHERE `Matrix_Unique_ID` = '211177642' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T07:33:32.800' ,`MLSNumber` = '46788699' ,`ListAgentFullName` = 'Christina DeLaTorre' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.656084' ,`Longitude` = '-95.483886' ,`PhotoCount` = '21' ,`PostalCode` = '77035' ,`RoomCount` = '7' ,`ListPrice` = '319900.00' ,`Status` = 'Active' ,`StreetName` = 'Warm Springs' ,`StreetNumber` = '5531' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1574' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 5531 Warm Springs! You will not be disappointed in this charming 4-bedroom home located in the Westbury community. There\'s optimal space throughout. The kitchen is open to the formal dining area making it ideal for friends/family gatherings. Laminate flooring flows throughout the living, dining, kitchen and breakfast area. New carpet in all bedrooms. New tile surround and tile flooring in bathrooms. New shaker style cabinetry. Granite counter tops. New lighting package and ceiling fans in all rooms. Spacious backyard with plenty of room for a pool. Hager Park is next to Anderson Elementary and a SPARK playground is being installed and will be available for community use on weekends and after school hours. Westbury Park is 3 min. away on Mullins Dr. Park features include playgrounds, basketball court, picnic tables, pool & baseball/football field, walking trail. Only minutes to Medical Center, NRG, Galleria and Downtown. Overall, great family friendly community! NO FLOODING.' ,`Acres` = '0.1928' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 9 BLK 58 WESTBURY SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ANDERSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westbury Sec 03' ,`TaxAmount` = '4272' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1957' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666486813' WHERE `Matrix_Unique_ID` = '211282078' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T07:11:35.690' ,`MLSNumber` = '83497975' ,`ListAgentFullName` = 'Chambray Smith' ,`ListOfficeName` = 'Doug Erdy Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.162312' ,`Longitude` = '-95.418509' ,`PhotoCount` = '34' ,`PostalCode` = '77385' ,`RoomCount` = '8' ,`ListPrice` = '515000.00' ,`Status` = 'Active' ,`StreetName` = 'Flamingo' ,`StreetNumber` = '1311' ,`StreetSuffix` = 'Street' ,`City` = 'Conroe' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3380' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A one-of-a-kind new construction home built in the sought-after neighborhood, Chateau Woods. This all-black and white finished home features a two-car garage leading up to the front glass door. The 12 to 20-foot ceiling home features four oversized bedrooms, four bathrooms with under-cabinet lighting and tall showers, an oversized wet-bar area, a large open concept kitchen, and a connected living area leading you to a huge covered back patio through sliding glass doors. A warming electric fireplace stands tall in the living room next to the super-sized, shelved laundry room. Unique features are found throughout the inside and outside of the home. All appliances will be staying with the home.' ,`Acres` = '0.2314' ,`Area` = '15' ,`BuilderName` = 'Chamberlin Jones' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S656007 - LAKE CHATEAU WOODS 07, BLOCK 4, LOT 3-A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10080' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'HOUSER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Lake Chateau Woods 07' ,`TaxAmount` = '220' ,`TaxRate` = '2.1802' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666486814' WHERE `Matrix_Unique_ID` = '211921927' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T07:28:56.213' ,`MLSNumber` = '57576927' ,`ListAgentFullName` = 'Steven Girgenti' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = 'Trasel Holmes' ,`SellingOfficeName` = 'All City Real Estate, Ltd. Co.' ,`Latitude` = '29.686406' ,`Longitude` = '-95.684969' ,`PhotoCount` = '46' ,`PostalCode` = '77083' ,`RoomCount` = '7' ,`ListPrice` = '300000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Trace Glen' ,`StreetNumber` = '17335' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1762' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this open and bright 1 story located in Park at Mission Glen. With new flooring and carpet in the bedrooms and home completely re-painted, this split floorplan offers 4 bedrooms and 2 bathrooms (one of the bedrooms is set up to be used as a study). The kitchen is spacious, plenty of counter space and cabinets, with a separate eating area that is open to the living area. The living area is large enough for all your furniture and ready to watch some football. A separate dining room offers the flexibility of additional dining or another office space for those that work from home, perfect for entertaining during the upcoming holidays. The primary suite is large and the ensuite bathroom offers double sink vanity, a shower and separate jetted tub. The primary bath also has a huge walk-in closet for all your clothing needs. The backyard is large and fully fenced with plenty of room for your kids or pets. The refrigerator and washer to stay with home. Come see this beauty today' ,`Acres` = '0.1524' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PARK AT MISSION GLEN SEC 3, BLOCK 2, LOT 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6639' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'MISSION WEST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Park At Mission Glen Sec 3' ,`TaxAmount` = '4745' ,`TaxRate` = '2.4297' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666486814' WHERE `Matrix_Unique_ID` = '212369466' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T07:51:24.367' ,`MLSNumber` = '55548735' ,`ListAgentFullName` = 'Luis Nunez' ,`ListOfficeName` = 'Keller Williams HoustonCentral' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.936816' ,`Longitude` = '-95.752714' ,`PhotoCount` = '28' ,`PostalCode` = '77433' ,`RoomCount` = '10' ,`ListPrice` = '775000.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar Grove' ,`StreetNumber` = '16203' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3815' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One of the few 5 bedroom homes in the area, only two years old, 2-story home features an entry with 21’ ceilings that extend past the study. Open kitchen features 42” raised panel cabinets, granite countertop, and high-bar seating. Oversized 17’ x 23’ family room with 21’ ceilings, corner fireplace, and full wall of windows. Master bath includes a 6’ garden tub, separate shower, His & Hers vanities, and dual walk-in closets. Located upstairs are 3 bedrooms, 2 baths, media room, and a game room.' ,`Acres` = '0.236' ,`Area` = '25' ,`BuilderName` = 'Ravenna Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 35 BLK 1 BRIDGELAND PARKLAND VILLAGE SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10279' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WELLS ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland Parkland Village Sec 8' ,`TaxAmount` = '18433' ,`TaxRate` = '3.4929' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1666486814' WHERE `Matrix_Unique_ID` = '212552548' --> 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','212614598','1666486814','212614598','2022-10-22T07:59:53.547','5051388','Emily Wang','Intown Homes','','','29.823901','-95.533939','10','77080','7','599900.00','Active','Asher Landing','3406','Lane','Houston','3','0','4','2336','Single-Family','Modern Contemporary FOUR Bedroom Home on a Super Size private homesite----plenty of backyard for a pool and some. The first floor bedroom can serve as a guest suite or home office. The kitchen is filled with Bosch appliances and the eight foot island open into the family room. The first floor ceilings are 12 feet high. The family room features an Andersen 12\' x 10\' stacking glass door that opens to the patio and backyard. Primary Suite features and oversize bath and shower and a walk-in closet that will challenge you t0 fill it.\r\nAvondale is designed as an \"Anti-Cookie Cutter Neighborhood\"---Plans and Colors are carefully chosen throughout the community to create this effect---','0.107','24','InTown Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','','','Spring Branch','Central Gas,Zoned','1','LT 36 BLK 2 AVONDALE SQUARE','Subdivision Lot','4659','Appraisal District','','950','1','To Be Built/Under Construction','2','Electric Oven','0','','','Gas Cooktop','','Composition','49 - Spring Branch','SPRING SHADOW ELEMENTARY SCHOOL','NORTHBROOK HIGH SCHOOL','NORTHBROOK MIDDLE SCHOOL','Appointment Required','Builder','2','Contemporary/Modern','Avondale Square','2192','2.4415','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T07:18:34.687' ,`MLSNumber` = '32476065' ,`ListAgentFullName` = 'Rhonda Flanagan' ,`ListOfficeName` = 'Connect Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.081872' ,`Longitude` = '-94.175655' ,`PhotoCount` = '16' ,`PostalCode` = '77706' ,`RoomCount` = '4' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Chatwood' ,`StreetNumber` = '845' ,`StreetSuffix` = 'Drive' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2052' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'OPEN HOUSE ~ OCTOBER 23 ~ 1-4 PM \r\nTHIS IS THE HOME FOR YOU! Beautiful home well maintained inside and out. Four spacious-sized bedrooms, primary bath has large sunken tile shower, hall bath has granite tops with double sinks, shower/tub combo. Home has a formal dining room, kitchen features granite countertops, cooktop and a built-in oven, open to the breakfast room which is open to the living area that features a bricked fireplace. Low maintenance backyard oasis with pool, gazebo, and plenty of seating, pick your seat to gaze at the stars at night. Plenty of space to have family and friends over to enjoy an outdoor cookout. A MUST-SEE! Schedule an appointment, come fall in love and make an offer.' ,`Acres` = '0.2382' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'DOWLEN WEST UNIT 4 L3 B8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10375' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'CURTIS ELEMENTARY SCHOOL (BEAUMONT)' ,`SchoolHigh` = 'WEST BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL (BEAUMONT)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Dowlen West' ,`TaxAmount` = '5559' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666486814' WHERE `Matrix_Unique_ID` = '212633881' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T07:57:39.560' ,`MLSNumber` = '66573502' ,`ListAgentFullName` = 'Lisa Fay' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.198235' ,`Longitude` = '-95.738175' ,`PhotoCount` = '20' ,`PostalCode` = '77355' ,`RoomCount` = '6' ,`ListPrice` = '445000.00' ,`Status` = 'Active' ,`StreetName` = 'Maple Ct' ,`StreetNumber` = '31702' ,`StreetSuffix` = '' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1896' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Magnolia! Looking for the perfect home on land that is still conveniently located near Tomball, The Woodlands, and Montgomery. Look no further! Beautiful new Custom Home on 0.9 Acres with an open floor concept perfect for entertaining! The exterior is finished with brick and Austin stone accents. Kitchen island with quartz countertops, subway tile backsplash, and 42\" shaker cabinets. Generous primary tile shower and walk-in closet. You will find Luxury wood-look tile in main living areas, carpet in bedrooms, and a very impressive functional one-story home design. The laundry is complete with mudroom storage and lockers. Backyard covered patio & outdoor grill. Extra wide double driveway to house and garage. The third garage is extended to 13 x 35 - room for all your toys! High efficiency 14 SEER HVAC and the home is wired for CAT 5 Network. Well, septic, and no MUD tax! Low overall taxes!' ,`Acres` = '0.91' ,`Area` = '15' ,`BuilderName` = 'Vanguard Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'MAGNOLIA CROSSING, BLOCK 1, LOT 74, ACRES 0.910, S' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '39640' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Magnolia Crossing' ,`TaxAmount` = '56' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666486814' WHERE `Matrix_Unique_ID` = '212797525' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T07:58:12.787' ,`MLSNumber` = '7680739' ,`ListAgentFullName` = 'Lisa Fay' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.198558' ,`Longitude` = '-95.738131' ,`PhotoCount` = '23' ,`PostalCode` = '77355' ,`RoomCount` = '6' ,`ListPrice` = '369900.00' ,`Status` = 'Active' ,`StreetName` = 'Maple' ,`StreetNumber` = '31706' ,`StreetSuffix` = 'Court' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1602' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Magnolia! Looking for the perfect home on land that is still conveniently located near 249, Tomball, The Woodlands, and Montgomery. Look no further! Beautiful new Custom Home on 0.9 Acres with an open floor concept perfect for entertaining! Extra wide double driveway to house and garage. Kitchen island with granite countertops, subway tile backsplash, and 42\" shaker cabinets. You will find Luxury wood-look tile in main living areas, carpet in bedrooms, and a very impressive functional one-story home design. Generous primary tile shower and walk-in closet. The backyard boasts a covered patio & ample space. The third garage is extended to 13 x 35 - room for all your toys! High efficiency 14 SEER HVAC and the home is wired for CAT 5 Network. Well, septic, and no MUD tax! Low overall taxes!' ,`Acres` = '0.87' ,`Area` = '15' ,`BuilderName` = 'Vanguard Builders' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'MAGNOLIA CROSSING, BLOCK 1, LOT 75, ACRES 0.870' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '37897' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Magnolia Crossing' ,`TaxAmount` = '56' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666486815' WHERE `Matrix_Unique_ID` = '212797954' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T07:57:00.433' ,`MLSNumber` = '21195776' ,`ListAgentFullName` = 'Lisa Fay' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.198932' ,`Longitude` = '-95.738135' ,`PhotoCount` = '8' ,`PostalCode` = '77355' ,`RoomCount` = '8' ,`ListPrice` = '579900.00' ,`Status` = 'Active' ,`StreetName` = 'Maple Court' ,`StreetNumber` = '31710' ,`StreetSuffix` = '' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2563' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Magnolia! Looking for the perfect home on land that is still conveniently located near 249, Tomball, The Woodlands, and Montgomery. Look no further! Beautiful new Custom Home on almost 2 Acres with an open floor concept perfect for entertaining! Extra wide double driveway to house and garage. Kitchen island with quartz countertops, subway tile backsplash, and 42\" shaker cabinets. You will find Luxury wood-look tile in main living areas, carpet in bedrooms, and a very impressive functional home design. Generous primary tile shower and walk-in closet. The backyard boasts a covered patio & ample space. The third garage is extended to 13 x 35 - room for all your toys! High efficiency 14 SEER HVAC and the home is wired for CAT 5 Network. Well, septic, and no MUD tax! Low overall taxes!' ,`Acres` = '1.74' ,`Area` = '15' ,`BuilderName` = 'Vanguard Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'MAGNOLIA CROSSING, BLOCK 1, LOT 76, LOT 77 ACRES 1.74' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '75794' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Magnolia Crossing' ,`TaxAmount` = '56' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666486815' WHERE `Matrix_Unique_ID` = '212823986' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T07:42:17.220' ,`MLSNumber` = '55424913' ,`ListAgentFullName` = 'Christina DeLaTorre' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.958574' ,`Longitude` = '-95.592535' ,`PhotoCount` = '27' ,`PostalCode` = '77429' ,`RoomCount` = '4' ,`ListPrice` = '259900.00' ,`Status` = 'Active' ,`StreetName` = 'Bent Way' ,`StreetNumber` = '11402' ,`StreetSuffix` = '' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1836' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MUST SEE! Great floorplan with recent updating throughout. Spacious Corner Lot on a Cul-De-Sac Street. Family friendly community. Zoned to A rated Hamilton Middle School. Recently painted a nice neutral color throughout. Inviting living and formal dining area. Spacious kitchen with gas range, dishwasher, microwave and granite counter tops. Large kitchen window looks out into your backyard so you can keep an eye out on the little ones or pets while they enjoy all the green open space. There is a spacious den with fireplace as well that could also be used as a gameroom. The space is so versatile. Recently installed vinyl plank flooring is easy to maintain. Extra storage space in garage. Community Park and Pool. You won\'t want to miss this one. Set up your appt today.' ,`Acres` = '' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 50 Block 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '7475' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '520' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MILLSAP ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mill Ridge North' ,`TaxAmount` = '4391' ,`TaxRate` = '2.53' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666486815' WHERE `Matrix_Unique_ID` = '212838524' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T07:17:49.587' ,`MLSNumber` = '78818715' ,`ListAgentFullName` = 'Dean Melton' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Tito Manzur' ,`SellingOfficeName` = 'Zarco Properties, LLC' ,`Latitude` = '30.253306' ,`Longitude` = '-95.519842' ,`PhotoCount` = '47' ,`PostalCode` = '77384' ,`RoomCount` = '9' ,`ListPrice` = '499990.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Routt Forest' ,`StreetNumber` = '14027' ,`StreetSuffix` = 'Trail' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2829' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Delightful home with relaxing backyard oasis, sparkling gunite pool/spa, large end lot in the peaceful community of Fosters Ridge. Home has 4 bedrooms, 3 full baths, open floorplan with 3 bedrooms down, including primary suite. The 4th bdrm, 3rd bath & spacious gameroom are upstairs. Beautiful island kitchen, granite countertops, stainless steel appliances, butlers pantry, & walk-in pantry. The open kitchen, family room, breakfast area & patio overlook the pool. Great flow for entertaining. Home boasts tons of windows providing natural light. Custom chandelier & designer pressed tin ceiling in the formal dining room, custom valances in family & breakfast, electric FP, walk-in closets in most rooms, plenty of storage, easily accessible floored attic, 8\'x8\' storage shed on concrete pad & professional landscape lighting in backyard. Beautifully designed gunite pool has 3 waterfalls, raised hot tub, LED lights, removable table top, & tanning deck. Walking distance to park and rec center.' ,`Acres` = '0.2115' ,`Area` = '15' ,`BuilderName` = 'D R Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S516400 - FOSTERS RIDGE 01, BLOCK 2, LOT 17' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9212' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Fosters Ridge' ,`TaxAmount` = '9074' ,`TaxRate` = '3.1488' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666486815' WHERE `Matrix_Unique_ID` = '212854255' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T06:19:00.063' ,`MLSNumber` = '69896542' ,`ListAgentFullName` = 'Jose Soria' ,`ListOfficeName` = 'Lions Gate Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.327118' ,`Longitude` = '-95.081634' ,`PhotoCount` = '26' ,`PostalCode` = '77327' ,`RoomCount` = '7' ,`ListPrice` = '229900.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Bend' ,`StreetNumber` = '105' ,`StreetSuffix` = 'Court' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '580' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Home with 3 bedrooms 2 full baths ,House is totally redone with new, 30 yr roof , flooring, tankless water heater, A/C , Cabinets , Electrical box with Breakers and more you must see this one .' ,`Acres` = '0.338' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PINE BEND, BLOCK 1, LOT 5, ACRES 0.338' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '14723' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'EASTSIDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pine Bend' ,`TaxAmount` = '1926' ,`TaxRate` = '2.5563' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666486816' WHERE `Matrix_Unique_ID` = '212954073' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T07:38:49.257' ,`MLSNumber` = '74719408' ,`ListAgentFullName` = 'Renee House' ,`ListOfficeName` = 'Realty ONE Group, Experience' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.405570' ,`Longitude` = '-95.527675' ,`PhotoCount` = '50' ,`PostalCode` = '77318' ,`RoomCount` = '5' ,`ListPrice` = '1079940.00' ,`Status` = 'Active' ,`StreetName` = 'Forest Trails' ,`StreetNumber` = '11325' ,`StreetSuffix` = 'Drive' ,`City` = 'Willis' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '6585' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3 acres of country privacy and still have the perk of being 3 miles from Lake Conroe and the city. Enter through a custom gated entry and find this beautiful 5 bedroom / 2 story home. The 2nd floor offers an open concept plan. Enjoy a game room, family room, great room, home office and PLENTY of storage space.\r\nHOME FEATURES INCLUDE: 5 zoned HVAC units, 2 hot water heaters, a RainSoft water softener, a Central Vacuum system throughout, oversized laundry room, 2 pantries, and a 3 car attached garage. The cherry on top are the 3 outside buildings: a 2700 sqft A/C\'d building, a 2 car garage/workshop, and a barn with horse stalls. A perfect setup for horses and FFA projects. Recent updates include exterior paint and window replacements. NO MUD TAX. NO HOA FEES.' ,`Acres` = '3.066' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S516300 - FOREST TRAILS 12, BLOCK 1, LOT 3, 4-A, A0012 TRACT' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '133555' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Split Level,Traditional' ,`Subdivision` = 'Forest Trails 12' ,`TaxAmount` = '10146' ,`TaxRate` = '1.8448' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666486816' WHERE `Matrix_Unique_ID` = '212961982' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T07:51:38.547' ,`MLSNumber` = '94546395' ,`ListAgentFullName` = 'Clark Blair' ,`ListOfficeName` = 'Real Estate Solution Source' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.009146' ,`Longitude` = '-95.759563' ,`PhotoCount` = '35' ,`PostalCode` = '77433' ,`RoomCount` = '7' ,`ListPrice` = '469000.00' ,`Status` = 'Active' ,`StreetName` = 'Silver Blueberry' ,`StreetNumber` = '21910' ,`StreetSuffix` = 'Trail' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2898' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HURRY AND SEE THIS INCREDIBLE CUSTOM TRENDMAKER 1-STORY ON OVER 1/4 ACRE IN FAIRFIELD SOUTH!!! THIS HOME IS IMMACULATE AND VERY WELL MAINTAINED BY THE ORIGINAL OWNER. SUPER CLEAN AND OPEN FLOOR PLAN, ORIGINAL WOOD FLOORS T/O, TILE IN THE WET AREAS & UPGRADED CARPET ONLY IN THE BEDROOMS. TWO BEDROOMS HAVE A SHARED BATH IN-BETWEEN & THE 4TH BEDROOM OR OFFICE IS OFF THE FRONT WITH FRENCH DOORS. SPLIT 3 CAR GARAGE AND HUGE MASTER WITH HIS/HERS CLOSETS & SEPARATE VANITY AREAS. THERE IS A DOOR TO DIRECLY ACCESS THE AMAZING SCREENED-IN PORCH THAT IS PERFECT TO ENJOY YOUR NEW BACK YARD SPACE, WHICH INCLUDES EXTERIOR MOUNTED SPEAKERS, WIRED FOR TV AND AN AMAZING COOKING KITCHEN WITH GRANITE, PLUMBING AND A WEBER STAINLESS GAS GRILL. THE EXTENDED PATIO WAS ALSO BUILT ON A SLAB AND TIED INTO THE EXISTING ROOF SHINGLES TO INCLUDE AN AWESOME WOOD BURNING FIREPLACE TO HANG OUT BY THE FIRE AND ROAST S\'MORES! HURRY, AS THIS ONE IS THE NICEST AND BEST VALUE IN FAIRFIELD JUST STEPS AWAY FROM THE SCHOOL!' ,`Acres` = '0.2841' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 2 FAIRFIELD VILLAGE SOUTH SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12377' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'SWENKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Fairfield Village South Sec 05' ,`TaxAmount` = '9841' ,`TaxRate` = '2.746' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666486816' WHERE `Matrix_Unique_ID` = '212970318' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T07:56:27.347' ,`MLSNumber` = '97371324' ,`ListAgentFullName` = 'Shannon Hall' ,`ListOfficeName` = 'Gulf Coast, Realtors' ,`SellingAgentFullName` = 'Joshua Kartzmark' ,`SellingOfficeName` = 'Keller Williams Met Inner Loop' ,`Latitude` = '29.514006' ,`Longitude` = '-95.091310' ,`PhotoCount` = '31' ,`PostalCode` = '77573' ,`RoomCount` = '5' ,`ListPrice` = '215000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Kansas' ,`StreetNumber` = '321' ,`StreetSuffix` = 'Avenue' ,`City` = 'League City' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1309' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location, Location, Location! Situated on an amazing 10,500 sqft Corner lot in Old League City! Build new or have your charming cottage with an amazing yard! Updated with recent flooring, paint, granite counters. Easy access to shopping, park, and I-45! Large living room, dining area with wall of windows, two spacious bedrooms, and one car garage is auto opener. Central AC/Heat - X500 zone flood insurance not required Home is being sold as-is where is.' ,`Acres` = '0.241' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 3 PAGE 14 LOT 1 & NE 1/2 OF LOT 2 BLK 16 LEAGUE CITY TO' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '10500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'LEAGUE CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CLEAR CREEK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1400' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'League City Townsite Blk 1-48' ,`TaxAmount` = '3495' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1951' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1666486816' WHERE `Matrix_Unique_ID` = '212993116' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T07:24:50.550' ,`MLSNumber` = '97025543' ,`ListAgentFullName` = 'Dat Truong' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.551161' ,`Longitude` = '-95.339889' ,`PhotoCount` = '16' ,`PostalCode` = '77584' ,`RoomCount` = '8' ,`ListPrice` = '298000.00' ,`Status` = 'Active' ,`StreetName` = 'Foxden' ,`StreetNumber` = '2510' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1865' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home features high ceilings, a great open floor plan, hard surface floors, a huge kitchen with tons of counter space, covered pipes to protect from freezing, and has never flooded. Numerous windows fill the living room with natural light with a fireplace for cozy winter evenings. The kitchen oversees the living room and features a sunny dining area. The spacious Master bedroom boasts high ceilings, a walk-in closet, and a full bath with double basins. Enjoy the deck and beautiful, mature trees that provide cool shade in the backyard patio. Location zoned to the exemplary Pearland ISD with access to GT Academy, only minutes from the Pearland Medical Center and shopping destinations like the Pearland Town Center. Your morning commute into town is expedited being that you are a couple turns away from main roads that lead to Beltway 8 and HWY 288. Walking distance to park with a picnic area, two playgrounds, open field, crushed granite track with exercise stations, and pool.' ,`Acres` = '0.1515' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SOUTHWYCK, BLOCK 4, LOT 10 SEC 1-REPLAT, A0242 HT&BRR' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6599' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'SILVERLAKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GLENDA DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'BERRY MILLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Call Occupant,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Southwyck' ,`TaxAmount` = '5591' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666486816' WHERE `Matrix_Unique_ID` = '213000904' --> 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','213255050','1666486817','213255050','2022-10-22T06:02:08.990','45477291','Rosa Sanchez-Setticase','Walzel Properties','','','29.568620','-95.715159','5','77469','5','435000.00','Active','Rustic Canyon','22003','Lane','Richmond','3','1','4','2610','Single-Family','Come checkout this beautiful 2 story house in the heart of Riverpark. This residence features 4 bedrooms, 3.5 baths, and spacious game room upstairs and open to below. This elegant floorplan includes tall ceilings, tons of natural light, and formal dining.\r\nSchedule your appointment today!!!','0.1645','30','','','','','Mud,Sellers Disclosure','','','2','Fort Bend South/Richmond','Central Gas','1','RIVERPARK WEST SEC 10, BLOCK 2, LOT 14','Subdivision Lot','7167','Appraisal District','','850','0','','2','','0','','','','','Composition','33 - Lamar Consolidated','HUTCHISON ELEMENTARY SCHOOL','LAMAR CONSOLIDATED HIGH SCHOOL','WESSENDORF/LAMAR JUNIOR HIGH SCHOOL','Supra Keybox','Appraisal District','2','Traditional','Riverpark West','6778','2.8748','Public Sewer,Public Water,Water District','2009','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T07:20:09.067' ,`MLSNumber` = '38869293' ,`ListAgentFullName` = 'LaToya Glenn' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.926671' ,`Longitude` = '-95.246716' ,`PhotoCount` = '16' ,`PostalCode` = '77396' ,`RoomCount` = '6' ,`ListPrice` = '489000.00' ,`Status` = 'Active' ,`StreetName` = 'Breyana Park' ,`StreetNumber` = '14531' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3222' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for a suburban lifestyle with quick access to all things 20 mins from downtown Houston, right off Beltway 8 and IH 59/69, convenient ride to Grand Parkway and IH 45 without wasting 20 minutes plus just to get out of your community. Then, this barley lived in Westin Home Tuscany Estate Collection in highly sought-after Master Planned Fall Creek golf course community is right for you. This undeniable beauty is a spacious 2-story floorplan situated on a Cul de sac, huge backyard in a Top-rated school district, no back neighbors, energy efficient, abundant windows and natural/recess lighting. Private association amenities galore. This is home has 4-bedrooms and 3.5 bathrooms, media & game room can be used as office space, award-winning architectural details, eye-catching rotunda, media room, game room or transform into an office space, after-build hardwood flooring installation and sprinkler system. Convenient to all things work, shop, restaurants, lake, parks, and play.' ,`Acres` = '0.1933' ,`Area` = '1' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fall Creek Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 27 BLK 1 FALL CREEK SEC 40' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '8419' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1090' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'AUTUMN CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Split Level' ,`Subdivision` = 'Fall Creek' ,`TaxAmount` = '10497' ,`TaxRate` = '3.0673' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666486817' WHERE `Matrix_Unique_ID` = '213266664' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T06:53:37.837' ,`MLSNumber` = '2170145' ,`ListAgentFullName` = 'Elizabeth Beery' ,`ListOfficeName` = 'Weichert,REALTORS-Murray Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.754039' ,`Longitude` = '-95.714800' ,`PhotoCount` = '46' ,`PostalCode` = '77450' ,`RoomCount` = '13' ,`ListPrice` = '1190000.00' ,`Status` = 'Active' ,`StreetName` = 'Parklake Village' ,`StreetNumber` = '1730' ,`StreetSuffix` = 'Street' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4645' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Absolutely gorgeous custom home offers a SPARKLING POOL & OUTDOOR covered patio with Beautiful green space and fire pit situated on a large lot in desirable GATED community Park Lake. Spectacular front elevation, impressive double door leads to a grand foyer with high ceilings, it is elegant & welcoming. Excellent floor plan, Many features, upgrades & updates. quality construction with attention to details. Elegant arches, tray ceilings, crown moldings & high ceilings throughout. amazing island kitchen, half bath, 3 car garages with extra big space, Julietta Balcony with beautiful view of front Lakeview. Shows beautifully like a model home. Come to see today!' ,`Acres` = '0.3011' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 2 PARKLAKE VILLAGE' ,`LotDesciption` = 'Corner,Water View' ,`LotSize` = '13118' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'PATTISON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'MCMEANS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Left Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Parklake Village' ,`TaxAmount` = '16683' ,`TaxRate` = '2.3333' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666486817' WHERE `Matrix_Unique_ID` = '213333872' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T06:46:09.090' ,`MLSNumber` = '65572459' ,`ListAgentFullName` = 'Mark Dimas' ,`ListOfficeName` = 'Mark Dimas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.780634' ,`Longitude` = '-95.790448' ,`PhotoCount` = '48' ,`PostalCode` = '77494' ,`RoomCount` = '9' ,`ListPrice` = '390000.00' ,`Status` = 'Active' ,`StreetName` = 'Courtland Oaks' ,`StreetNumber` = '24110' ,`StreetSuffix` = 'Street' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3342' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A fantastic find! This charming 2-story home features 4 bedrooms, 3.5 baths, attached 2-car garage, neutral paint, and carpet, tile & vinyl wood flooring! The 1st floor offers a combination living/dining room, half bath, cozy living room with fireplace, & an eat-in kitchen with granite countertops, & tile backsplash! The spacious guest suite features an en-suite bath with a mosaic tile accent wall, tub/shower combo and walk-in closet! The 2nd floor opens to a huge gameroom, 2 secondary bedrooms, a full bath, & in-house utility room! The primary bedroom which boasts a separate lounging area & an en-suite bath with dual sinks, soaking tub, separate shower & walk-in closet! Enjoy the backyard with no rear neighbor for added privacy! Zoned to Katy ISD, this home is within proximity to I-10 & TX-99!' ,`Acres` = '0.1366' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 2 LAKES AT GRAND HARBOR SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5949' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '675' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WEST MEMORIAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'WEST MEMORIAL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes/Grand Harbor Sec 2' ,`TaxAmount` = '7956' ,`TaxRate` = '2.7033' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666486817' WHERE `Matrix_Unique_ID` = '213497582' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T07:43:04.300' ,`MLSNumber` = '77895125' ,`ListAgentFullName` = 'Luis Nunez' ,`ListOfficeName` = 'Keller Williams HoustonCentral' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.063786' ,`Longitude` = '-95.371986' ,`PhotoCount` = '28' ,`PostalCode` = '77373' ,`RoomCount` = '9' ,`ListPrice` = '260000.00' ,`Status` = 'Active' ,`StreetName` = 'Cimarron Pass' ,`StreetNumber` = '3115' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1866' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous & inviting one-story floor plan, charming covered front porch, large entry flows into large den with laminate wood floors, spacious family room with raised ceiling and gas log fireplace is open to large kitchen and dining area. Huge eat-in island kitchen with breakfast bar, tile floors, tile backsplash, study with French doors, roomy master suite with garden bath with separate tub and shower and walk-in closet! Split bedroom plan with master suite in back of home. An abundance of windows fills the home with natural light! Peaceful covered back porch with fan! You don’t want to miss this one!' ,`Acres` = '0.1268' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 43 BLK 3 BRECKENRIDGE FOREST SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5522' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '397' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'GLORIA MARSHALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Breckenridge Forest Sec 04' ,`TaxAmount` = '5567' ,`TaxRate` = '2.8117' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666486817' WHERE `Matrix_Unique_ID` = '213546633' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T07:55:36.133' ,`MLSNumber` = '11119377' ,`ListAgentFullName` = 'Laura Jackson' ,`ListOfficeName` = 'Styled Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.086412' ,`Longitude` = '-95.660228' ,`PhotoCount` = '50' ,`PostalCode` = '77377' ,`RoomCount` = '8' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Tomball Cemetery' ,`StreetNumber` = '22203' ,`StreetSuffix` = 'Road' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3981' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This elegant treelined home on almost ½ acre near Tomball ISD, Salem Lutheran School, Spring Creek Park & more! A ranch style fence & long driveway lead to an inviting brick porch. Open the 8’ tall wood door w/speakeasy & the space will take your breath away from low maintenance tiled floors that look like wood, Study w/ French doors & a captivating Chef’s Kitchen to the 2-story ceiling in the Family Room. The luxurious Owner’s suite has 2 walk-in closets & granite counters w/separate soaking tub & Frameless shower. There is plenty of space upstairs for LARGE FAMILIES w/ 3 Bedrooms, Game Rm, Media Rm w/ step-up for theatre seating, wall sconces, projector, screen plus a computer nook & 2 full baths. The backyard w/carefully selected trees & extended patio compliment the custom pool less than 5 yrs old. Power shades shield the sun so you can stay cool while outdoor cooking & you can watch TV or the sunset in this spacious backyard. This warm & inviting home is a must see!' ,`Acres` = '0.4606' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 2 PINE COUNTRY OF TOMBALL SEC 2 R/P' ,`LotDesciption` = 'Corner' ,`LotSize` = '20063' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'ROSEHILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pine Country/Tomball Sec 02 Rep' ,`TaxAmount` = '9509' ,`TaxRate` = '2.3767' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666486817' WHERE `Matrix_Unique_ID` = '213630116' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T06:52:01.100' ,`MLSNumber` = '33499301' ,`ListAgentFullName` = 'Norma Smalley' ,`ListOfficeName` = 'Cobb Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.495741' ,`Longitude` = '-95.126033' ,`PhotoCount` = '37' ,`PostalCode` = '77573' ,`RoomCount` = '6' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Barton' ,`StreetNumber` = '2508' ,`StreetSuffix` = 'Court' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1815' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'No showings until after Saturday’s Open House (10/15/22). Welcome to 2508 Barton Ct. This move-in ready home is absolutely stunning. A separate dining room, plenty of counter space in the kitchen, a breakfast area, an open concept, a large primary suite, and a great backyard are just a few of the many perks this beautiful home provides. This home also comes with many new and exciting upgrades such as: new water-resistant vinyl flooring (2022), new interior and exterior paint (2022), new stainless steel appliances (2022), granite countertops in the kitchen, new bathroom vanities (2022), new garage doors and garage door openers (2022), 2 new sliding doors (2022), new light fixtures (2022), new mirrors, and new door knobs. The A/C was replaced in August 2020. The foundation has been repaired this year. This home is truly move-in ready. Don\'t miss out on this on all this home has to offer! All room dimensions will need to be verified.' ,`Acres` = '0.1748' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 9 PAGE 2 LOT 12 BK 2 THE LANDING SEC 1' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '7616' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ROSS ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Landing' ,`TaxAmount` = '5631' ,`TaxRate` = '2.2667' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666486818' WHERE `Matrix_Unique_ID` = '213679828' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T07:08:57.617' ,`MLSNumber` = '62339493' ,`ListAgentFullName` = 'Charman Escobedo' ,`ListOfficeName` = 'Green And Associates, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.354531' ,`Longitude` = '-95.094479' ,`PhotoCount` = '18' ,`PostalCode` = '77510' ,`RoomCount` = '7' ,`ListPrice` = '239000.00' ,`Status` = 'Active' ,`StreetName` = '28th' ,`StreetNumber` = '12608' ,`StreetSuffix` = 'Street' ,`City` = 'Santa Fe' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1550' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Recently remodeled home on 1 full acre! Tired of the hustle and bustle of city life? You have found your new home! Enter from the cheery yellow front door into and open concept living and dining area. Kitchen has bright white cabinets, granite counter tops, and stainless steel appliances. Living area has luxury vinyl plank flooring and lots of windows to let natural light in. Large bonus room can be used as bedroom or additional family room. New carpet in all bedrooms. Large 2 car garage and covered carport. Well and septic system newly serviced. Great 1 acre lot with plenty of room for pets, hobbies, or expansion. No HOA. Close to Highway 6, SH-646, I 45 for easy access to Houston or Tx City for work, a short drive to Tanger Outlets for shopping, close to Galveston for dining, entertainment, shopping and fun in the sun! Make an appointment to view this home today. This one won\'t last long!' ,`Acres` = '1' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 47 L CRAWFORD SUR PT OF OUTLOT 307 (307-6) ALTA LOMA OU' ,`LotDesciption` = 'Cleared' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'DAN J KUBACAK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Alta Loma Outlots' ,`TaxAmount` = '2898' ,`TaxRate` = '2.0881' ,`WaterSewer` = 'Septic Tank,Water District,Well' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666486818' WHERE `Matrix_Unique_ID` = '213722214' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T07:10:24.367' ,`MLSNumber` = '15729055' ,`ListAgentFullName` = 'Maria Ritchie' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.352582' ,`Longitude` = '-95.524208' ,`PhotoCount` = '37' ,`PostalCode` = '77304' ,`RoomCount` = '4' ,`ListPrice` = '459900.00' ,`Status` = 'Active' ,`StreetName` = 'Woods Estates' ,`StreetNumber` = '3532' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2972' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This magnificent home is a well-maintained 4 bedroom/3 bath home on an oversized lot in the Estates of Wedgewood Falls! Prepare to fall in love with this beautiful home that features an open concept floorplan with high ceilings and an abundance of windows that welcome plenty of natural light. Downstairs has a spacious family room with a stone fireplace. It\'s open to the large chef’s kitchen that offers granite countertops, SS appliances, ample cabinets/storage, dedicated home office, private primary bedroom with tray ceilings and ensuite bath, a 2nd bedroom with bath and laundry room. Upstairs you will find a game room and two additional generous-sized bedrooms, and a full bath. Enjoy the shade on the south facing front patio in the mornings and relax on the covered back patio in the evening. The fenced-in backyard space is private and huge, enough room for great backyard entertaining, a new Generac Generator and alarm system. Come See and tell your friends about this awesome home.' ,`Acres` = '0.1969' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S456700 - ESTATES OF WEDGEWOOD FALLS, BLOCK 1, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8575' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GIESINGER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Estates Of Wedgewood Falls' ,`TaxAmount` = '9073' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666486818' WHERE `Matrix_Unique_ID` = '213743851' --> 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','213790747','1666486818','213790747','2022-10-22T07:33:36.327','77066571','Gay Milliorn','RE/MAX Eastside','','','29.767867','-94.948782','44','77521','7','225000.00','Active','Apache','1407','Trail','Baytown','2','0','3','1539','Single-Family','Welcome Home! This charming Baytown home offers 3 bedrooms, 2 baths, and a 2 car garage, plus a great formal dining room (could also be an office or game room), high ceiling in the living area, a breakfast room, and great covered patio. Need a spot to park your boat? You\'ll love the extra driveway and gate into the spacious backyard. The roof and HVAC are less than 5 years old, and this home is brick on all 4 sides! No flooding and no HOA! Convenient location with easy access to Hwy 146, Garth Rd, and I-10. This home is priced to SELL! You\'ll want to see it for yourself!','0.1793','2','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Baytown/Harris County','Central Electric','0','LT 9 BLK 4 CHAPARRAL VILLAGE SEC 1','Corner,Subdivision Lot','7810','Appraisal District','','','0','','2','Double Oven','0','','','Electric Cooktop','','Composition','23 - Goose Creek Consolidated','CROCKETT ELEMENTARY SCHOOL (GOOSE CREEK)','STERLING HIGH SCHOOL (GOOSE CREEK)','CEDAR BAYOU J H','Appointment Required','Appraisal District','1','Traditional','Chaparral Village Sec 01','4665','2.97','Public Sewer,Public Water','1970','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T07:49:44.437' ,`MLSNumber` = '49251660' ,`ListAgentFullName` = 'Cris Reyna' ,`ListOfficeName` = 'JAM Real Estate, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.871258' ,`Longitude` = '-95.718263' ,`PhotoCount` = '8' ,`PostalCode` = '77449' ,`RoomCount` = '7' ,`ListPrice` = '285750.00' ,`Status` = 'Active' ,`StreetName` = 'Cresent Creek' ,`StreetNumber` = '20043' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1839' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A charming, single-story home with no back neighbors and a great-sized backyard awaits for the perfect family to fit right in. Are you starting a small business? No problem, this home is equipped with a home office or a 4th bedroom, the choice is yours. Great size living and dining room area for all your family gatherings! Schedule your in-person tour today!!' ,`Acres` = '0.1584' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 45 BLK 1 ESTATES OF HIGHLAND CREEK SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'DURYEA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'HOPPER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Estates Highland Creek' ,`TaxAmount` = '4993' ,`TaxRate` = '2.69' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666486818' WHERE `Matrix_Unique_ID` = '213811692' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T07:43:29.900' ,`MLSNumber` = '71687764' ,`ListAgentFullName` = 'Bian Hu' ,`ListOfficeName` = 'KingFay Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.729144' ,`Longitude` = '-95.764716' ,`PhotoCount` = '9' ,`PostalCode` = '77450' ,`RoomCount` = '9' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Westbrook Cinco' ,`StreetNumber` = '22706' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3664' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic floor plan with formal dining, study, high ceiling living area; Roof replaced in 2019. Execellent schools! Water damage in parts of the home due to pipes frozen in Feb 2022. Demolition done. Great potential!' ,`Acres` = '0.1928' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CINCO RANCH CINCO FOREST SEC 1, BLOCK 1, LOT 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1115' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WILLIAMS ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'BECK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cinco Ranch Cinco Forest Sec 1' ,`TaxAmount` = '9867' ,`TaxRate` = '2.4395' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666486818' WHERE `Matrix_Unique_ID` = '213863912' --> 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','213902742','1666486819','213902742','2022-10-22T07:46:29.470','55411525','Sharon Powell','Insight Realty Network','','','29.837656','-95.792563','26','77493','9','450000.00','Active','Windflower Valley','4427','Lane','Katy','3','1','4','2764','Single-Family','This beautiful immaculate home has not been lived in long 4 bedroom, 3.5 bath 2-story home in Katy Pointe subdivision. This home comes with many customizations. Some customized features include a wall feature in the primary bedroom, cabinets and tile flooring in the laundry room, a tiled wall in the half bath, and outside lighting to display the exterior of the home. Other features include beautiful wood and glass entry door, and wood-look floors flowing through the first level with the exception of the custom flooring in the laundry room, and half bath. Carpet areas are all bedrooms, media room, gameroom, and stairs. A computer niche with a curved wall between the kitchen and dining room. It can also be used as a wine bar. Covered patio with a spacious backyard to make your dreams come true. Minutes away from the Grand Parkway and I-10.','0.1273','25','Meritage Homes','','Gas Dryer Connections','','Sellers Disclosure','1','','','Katy - Old Towne','Central Gas','1','LT 7 BLK 1 (PURE ACCT) (30 YR SPECIAL WAIVER)(JUR 356) (MAIN','Subdivision Lot','5546','Appraisal District','','590','0','','2','Gas Oven','0','','','Gas Range','','Composition','30 - Katy','BETHKE ELEMENTARY SCHOOL','PAETOW HIGH SCHOOL','STOCKDICK JUNIOR HIGH SCHOOL','Lockbox Front,Request Online Appointment,Supra Keybox','Builder','2','Contemporary/Modern','Katy Pointe','','','Public Sewer,Public Water','2019','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T07:46:08.410' ,`MLSNumber` = '14822890' ,`ListAgentFullName` = 'Kitten Strahan' ,`ListOfficeName` = 'Leopold & Strahan Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.354232' ,`Longitude` = '-95.015935' ,`PhotoCount` = '17' ,`PostalCode` = '77563' ,`RoomCount` = '3' ,`ListPrice` = '189900.00' ,`Status` = 'Active' ,`StreetName` = 'Crestview' ,`StreetNumber` = '206' ,`StreetSuffix` = 'Drive' ,`City` = 'Hitchcock' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1332' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cute single-family home right in the heart of Hitchcock, Tx!! This home is 3 bedrooms 2 baths with a formal dining area. Large spacious room living room. Tons of storage. Huge kitchen with an abundance of cabinet/countertop space. Ready for your pesonal touches. Large fenced in backyard with mature trees perfect for an outdoor barbecue. Estate Sale. Home will be listed on the open market for 7 days prior to presenting. HURRY UP AND MAKE AN OFFER TODAY!' ,`Acres` = '0.2065' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hitchcock' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 2 PAGE 11 LOT 16 OAK RIDGE' ,`LotDesciption` = 'Other' ,`LotSize` = '8995' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '26 - Hitchcock' ,`SchoolElementary` = 'HITCHCOCK PRIMARY/STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HITCHCOCK HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (HITCHCOCK)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Ridge' ,`TaxAmount` = '2474' ,`TaxRate` = '2.3428' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1957' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666486819' WHERE `Matrix_Unique_ID` = '213919018' --> 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','213968627','1666486819','213968627','2022-10-22T07:53:59.773','7048060','Michael Parker','Phyllis Foster Real Estate Ser','','','29.276962','-94.812042','47','77551','5','629000.00','Active','Sherman','4509','Boulevard','Galveston','2','0','3','1699','Single-Family','Tour this one of a kind property located in the heart of Galveston no flooding during IKE. Upon entering the home you are greeted by True hardwoods. The living room is located on the right which allows for great entertaing ability. The updated kitchen opens to the family room. The chefs kitchen is great for all those large gatherings. The family room and breakfast area over look the pool. The primary suite has direct access to the pool. The primary closet has its own washer/dryer. Updated primary bath with oversized shower. The pool/spa has recently had all equipment replaced and re-plastered. Recent improvement include A/C, Kitchen, and roof. Book your appointment today.','0.1998','33','','','Washer Connections','','Sellers Disclosure','1','','','Midtown - Galveston','Central Gas','1','ABST 628 M B MENARD SUR LOT 12 HARRIS-DAMIANI SPECIAL SUB &','Subdivision Lot','8704','Appraisal District','','20','0','','2','Freestanding Oven','1','Gunite,Heated,In Ground','','Gas Range','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','1','Traditional','Harris-Damiani Sub 96','5469','2.0662','Public Sewer,Public Water','1926','Appraisal District'); --> New record created successfully