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-12-08T14:15:50.500' ,`MLSNumber` = '69592065' ,`ListAgentFullName` = 'Jacquelyn Shillingburg' ,`ListOfficeName` = 'My Real Estate Expert LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.082053' ,`Longitude` = '-95.602297' ,`PhotoCount` = '40' ,`PostalCode` = '77375' ,`RoomCount` = '6' ,`ListPrice` = '1500000.00' ,`Status` = 'Active' ,`StreetName` = 'Agg' ,`StreetNumber` = '919' ,`StreetSuffix` = 'Road' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2689' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*PRICE REDUCED* Beautiful one-story Tilson Home nestled on +/- 5.862 acres overlooking a beautiful stocked pond. This property offers partial fencing, has (1) RV Hookup, Water Well w/Septic System, Garage is decked for use and insulated with 2 window units, all-electric, has a generator connection, water softener, and more. The possibilities are endless concerning the property location and surrounding development. Located off of Agg Rd. and minutes from Downtown Tomball and 249.' ,`Acres` = '5.862' ,`Area` = '14' ,`BuilderName` = 'TILSON HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 283A-2 & 285B-1, TR283A-1, TR285B TOMBALL OUTLOTS' ,`LotDesciption` = 'Corner,Water View' ,`LotSize` = '255348' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TOMBALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'TOMBALL OUTLOTS' ,`TaxAmount` = '10441' ,`TaxRate` = '2.3717' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675088758' WHERE `Matrix_Unique_ID` = '206186600' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-08T13:51:56.340' ,`MLSNumber` = '13131185' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Sherry Haynes-Cabrera' ,`SellingOfficeName` = 'Walzel Properties' ,`Latitude` = '30.183837' ,`Longitude` = '-95.147941' ,`PhotoCount` = '7' ,`PostalCode` = '77357' ,`RoomCount` = '6' ,`ListPrice` = '365590.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Republic Road' ,`StreetNumber` = '919' ,`StreetSuffix` = '' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2565' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Over 20,000 square foot wooded lot and 3 car garage! This 4 bedroom property has a great home office and gameroom!! Amazing use of natural light! Open kitchen features shaker cabinets, granite countertops and stainless-steel appliances! The spacious Primary Suite is tucked away for your own private retreat with separate shower, garden tub and two closets! The home has front sprinklers, and a home automation system. You will appreciate the great storage and energy efficient features throughout. Hurry and call TODAY!' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 28 Block 10 Section 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '20108' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'DOGWOOD ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Estates at Roman Forest' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675088759' WHERE `Matrix_Unique_ID` = '209089684' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-08T13:38:43.150' ,`MLSNumber` = '84177838' ,`ListAgentFullName` = 'Dora Lopez' ,`ListOfficeName` = 'RE/MAX Associates Northeast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.186659' ,`Longitude` = '-95.166328' ,`PhotoCount` = '41' ,`PostalCode` = '77357' ,`RoomCount` = '3' ,`ListPrice` = '378500.00' ,`Status` = 'Active' ,`StreetName` = 'Four Fountains' ,`StreetNumber` = '1002' ,`StreetSuffix` = '' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1910' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Absolutely gorgeous Custom home Ready for move in ! Stunning High ceiling in family room with beautiful views of backyard and pond. Island Kitchen with breakfast bar opens to dinning room for easy entertaining or family gatherings. Covered patio perfect to enjoy your coffee or meal and enjoy the water view. Hardwood floors in kitchen and dining and family room , Spacious Primary bedroom suite with an oversize shower and a corner separate tub, two vanity area, linen closet. Split bedroom floor plan for more privacy, one of the bedroom has was a water view. Great size laundry room with wash sink. Extra room off Kitchen perfect for a study area !Call today for your private showing.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Piedra Construction' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 12 Block 17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14274' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'DOGWOOD ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Roman Forest' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675088759' WHERE `Matrix_Unique_ID` = '209520321' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-08T14:58:44.630' ,`MLSNumber` = '53983634' ,`ListAgentFullName` = 'Yolanda Graham' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.397079' ,`Longitude` = '-95.046508' ,`PhotoCount` = '19' ,`PostalCode` = '77568' ,`RoomCount` = '4' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Turquoise Trade' ,`StreetNumber` = '301' ,`StreetSuffix` = 'Drive' ,`City` = 'La Marque' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2017' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Time for school in the Santa Fe ISD! Large one-story home on a corner lot with 4 bedrooms, 2 baths, and an office that offers the perfect work-from-home environment. Great large kitchen with a breakfast/dinner area that overlooks the family room. The Utility Room is conveniently located across from the Primary Bedroom. A large concrete patio 14x15 is attached to the home so you could add a cover later. Energy star certified. Convenient location to I-45, Galveston, Kemah, and the Nasa Space Center. Nice park and playground in the community.' ,`Acres` = '0.1403' ,`Area` = '33' ,`BuilderName` = 'Grand View' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Marque' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PAINTED MEADOWS SEC 2 (2008) ABST 161, BLOCK 5, LOT 10, ACRE' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6110' ,`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` = '45 - Santa Fe' ,`SchoolElementary` = 'WILLIAM F BARNETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Painted Meadows (2008)' ,`TaxAmount` = '5746' ,`TaxRate` = '2.5543' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675088759' WHERE `Matrix_Unique_ID` = '211257847' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-08T13:03:57.727' ,`MLSNumber` = '62299124' ,`ListAgentFullName` = 'Jessica LaForce' ,`ListOfficeName` = 'Tricia Turner Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.097226' ,`Longitude` = '-95.374449' ,`PhotoCount` = '37' ,`PostalCode` = '77386' ,`RoomCount` = '15' ,`ListPrice` = '968000.00' ,`Status` = 'Active' ,`StreetName` = 'Starship' ,`StreetNumber` = '3906' ,`StreetSuffix` = 'Crossing' ,`City` = 'Spring' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '6' ,`SqFtTotal` = '5044' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 6 bedroom|4 Bath|2 half bath meticulously maintained home situated on an oversized corner lot. The kitchen is open to a family room including a breakfast room, features stainless steel appliances and a farmhouse sink, granite countertops, ample cabinet space, and a walk-in pantry. Spacious primary suite with seating area and en suite with dual sinks, vanity whirlpool tub, separate shower, and walk-in closet. The ground level also includes an office, formal dining room, dry bar, and second bedroom with an en suite. Located on the second level is a game room, media room, as well as four secondary bedrooms, Jack and Jill bathroom, and an additional full and half bathroom. Other features include architectural details, luxury vinyl flooring, and plantation shutters throughout. Step outside, where you will find a pool, outdoor kitchen, lush lawn, and mature landscaping. Truly an entertainer dream for family and friends. Call today to schedule a private showing!' ,`Acres` = '0.2658' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S213200 - ALLEGRO AT HARMONY 01, BLOCK 1, LOT 109' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '11577' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1756' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BROADWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Allegro At Harmony 01' ,`TaxAmount` = '16089' ,`TaxRate` = '2.9587' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675088759' WHERE `Matrix_Unique_ID` = '211669850' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-08T13:52:59.970' ,`MLSNumber` = '17112747' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '30.232307' ,`Longitude` = '-95.235042' ,`PhotoCount` = '9' ,`PostalCode` = '77357' ,`RoomCount` = '7' ,`ListPrice` = '277990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Owl' ,`StreetNumber` = '21354' ,`StreetSuffix` = 'Road' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1748' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WONDERFUL NEW D. R. HORTON BUILT 1 STORY 4 BEDROOM! Great Open Concept Design! Beautiful Elevation with Covered Front Porch! Lovely Foyer Opens to Gourmet Island Kitchen with Corner Walk-In Pantry, Spacious Dining Area, & Supersized Living Room! Privately Located Primary Suite Features Huge Walk-In Closet & Lovely Bath with Oversized Shower! Big Secondary Bedrooms! Convenient Indoor Utility Room! Large Covered Patio Overlooks Backyard! Carrier 16 SEER A/C, Tankless Water Heater, Built-In Home Automation System Controlled from a Single App, & Great Appliance Package! Fantastic Community with Pool, Playground, Splash Pad, Recreation Center, & Elementary School in Subdivision! Easy Access to Hwy 59, TX 242, & the Grand Parkway! Estimated Completion - November 2022.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'D. R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Harrington Trails 8, BLOCK 1, Lot 54' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6438' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'TIMBER LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harrington Trails' ,`TaxAmount` = '' ,`TaxRate` = '3.42' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675088759' WHERE `Matrix_Unique_ID` = '211691593' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-08T14:53:42.653' ,`MLSNumber` = '40895188' ,`ListAgentFullName` = 'Esther Rhone' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.870281' ,`Longitude` = '-95.066713' ,`PhotoCount` = '15' ,`PostalCode` = '77532' ,`RoomCount` = '11' ,`ListPrice` = '150000.00' ,`Status` = 'Active' ,`StreetName` = 'Oak' ,`StreetNumber` = '411' ,`StreetSuffix` = 'Avenue' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '0' ,`SqFtTotal` = '1216' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 3 bd 2 bath Cozy home is nestled away in the heart of Barrett Station. The oversized lot is has enough space to host family outings. The shed in the front gives you extra storage. The Electric gate opener provides security and privacy for your family to make this house a home.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'HOA First Right of Refusal,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '2009 CMH SIERRA VISTA 16X76 GREEN/WHITE HUD# HWC0400266 SER#' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'DREW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Colonial' ,`Subdivision` = 'Barrett Station' ,`TaxAmount` = '797' ,`TaxRate` = '3.0343' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675088760' WHERE `Matrix_Unique_ID` = '211708207' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-08T13:11:24.747' ,`MLSNumber` = '16147344' ,`ListAgentFullName` = 'Yesenia Cavazos' ,`ListOfficeName` = 'Premier One Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.923087' ,`Longitude` = '-95.094139' ,`PhotoCount` = '34' ,`PostalCode` = '77532' ,`RoomCount` = '5' ,`ListPrice` = '284000.00' ,`Status` = 'Active' ,`StreetName` = 'Chart' ,`StreetNumber` = '1603' ,`StreetSuffix` = 'Drive' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1888' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ready for immediate move in, this charming home offers the opportunity for easy living in the popular Newport neighborhood, located on a quiet cul-de-sac, . Offers a generous, extended drive that will accommodate additional vehicles/golf carts. Newport is an established neighborhood that offers convenient access to Lake Houston, pools, area playgrounds, golf course, tennis courts, hike and bike trails. Make your appointment today to see this lovely property.IS VERY COZY TRADITIONAL HOUSE HAS 4 BEDROOMS 2 1/2 BATHROOMS A KITCHEN ROOM AND LARGE PATIO FOR YOU TO SPEND WITH FAMILY.' ,`Acres` = '0.3375' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 19 NEWPORT SEC 4' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '14700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'CROSBY ELEMENTARY SCHOOL (CROSBY)' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Newport Sec 04' ,`TaxAmount` = '4729' ,`TaxRate` = '2.7105' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675088760' WHERE `Matrix_Unique_ID` = '213113809' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-08T14:28:09.437' ,`MLSNumber` = '15357071' ,`ListAgentFullName` = 'Edward McClintick' ,`ListOfficeName` = 'Joseph Walter Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.711754' ,`Longitude` = '-95.650646' ,`PhotoCount` = '23' ,`PostalCode` = '77082' ,`RoomCount` = '4' ,`ListPrice` = '199000.00' ,`Status` = 'Active' ,`StreetName` = 'Barnwell' ,`StreetNumber` = '4114' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1471' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DONT MISS THIS ONE!!!!!! \r\nThis Houston one-story home offers 3 beds, 2 baths, 1,471 SqFt, a large patio, and a spacious garage. Tile flooring along the house, ceiling fans, and sizable closets. A great home and neighborhood to make new memories. Showings have started so don\'t miss your chance to BranchOut to Houston Texas!' ,`Acres` = '0.1354' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 32 BLK 3 WEST BEND SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '5900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '646' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'HOLMQUIST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'ALBRIGHT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'West Bend Sec 01' ,`TaxAmount` = '3534' ,`TaxRate` = '2.405' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675088760' WHERE `Matrix_Unique_ID` = '213716841' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-08T13:26:16.260' ,`MLSNumber` = '76942097' ,`ListAgentFullName` = 'Celeste Taylor-Velasco' ,`ListOfficeName` = 'Redfin Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.434863' ,`Longitude` = '-95.440397' ,`PhotoCount` = '37' ,`PostalCode` = '77583' ,`RoomCount` = '12' ,`ListPrice` = '430000.00' ,`Status` = 'Active' ,`StreetName` = 'Thunderbolt Peak' ,`StreetNumber` = '2321' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2882' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous home with lots of natural light! Step into the spacious living room with soaring 2-story ceilings and vinyl plank wood floors. Open concept kitchen is just steps away featuring granite counters, breakfast bar, SS appliances, and ample counter space including an area that would make a great coffee bar. Downstairs primary has all the privacy and a large en-suite bath with dual sinks and a soaking tub. Secondary bedroom downstairs would also make a wonderful home office. Upstairs, enjoy the roomy game room and 3 more bedrooms, one with its own en-suite bath, making a perfect guest suite or second primary bedroom. Don\'t miss the backyard with a patio slab and lots of green space. The Master-planned community of Sierra Vista has all the amenities including a park at the end of the street, as well as lakes, pools, splash pad, and more!' ,`Acres` = '0.1383' ,`Area` = '5' ,`BuilderName` = 'Castlerock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SIERRA VISTA SEC 2 (A0288 HT&BRR) BLK 3 LOT 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6024' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '11713' ,`TaxRate` = '3.6007' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675088760' WHERE `Matrix_Unique_ID` = '214308833' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-08T14:52:26.560' ,`MLSNumber` = '20233511' ,`ListAgentFullName` = 'Xiaoming Shao' ,`ListOfficeName` = '31 Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.098831' ,`Longitude` = '-95.247083' ,`PhotoCount` = '39' ,`PostalCode` = '77365' ,`RoomCount` = '4' ,`ListPrice` = '319000.00' ,`Status` = 'Active' ,`StreetName` = 'Hubbard Run' ,`StreetNumber` = '21362' ,`StreetSuffix` = 'Drive' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2580' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well maintained 4 bedroom 2.5 bath 2 story single family house in Auburn Trails at Oakhurst. Primary bedroom down 3 guest bedrooms upstairs with a big living area. Big kitchen island. Beautiful backsplash. Spacious primary bedroom and primary bathroom. Decent backyard with covered patio. Move in ready.' ,`Acres` = '0.1487' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S221112 - AUBURN TRAILS AT OAKHURST 12, BLOCK 1, LOT 18' ,`LotDesciption` = 'Other' ,`LotSize` = '6478' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'BENS BRANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WOODRIDGE FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Auburn Trails At Oakhurst 12' ,`TaxAmount` = '10414' ,`TaxRate` = '3.2481' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675088761' WHERE `Matrix_Unique_ID` = '214607885' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-08T14:38:39.660' ,`MLSNumber` = '93568946' ,`ListAgentFullName` = 'Patricia McCulley' ,`ListOfficeName` = 'Country World Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.703720' ,`Longitude` = '-94.900962' ,`PhotoCount` = '30' ,`PostalCode` = '77351' ,`RoomCount` = '7' ,`ListPrice` = '349000.00' ,`Status` = 'Active' ,`StreetName` = 'Walnut Ridge' ,`StreetNumber` = '450' ,`StreetSuffix` = 'Road' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1394' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a one of a kind property with road frontage on two sides. Completely fenced and ready for you to have your own mini farm. It even has a hendominium! Property offers a 3 Bedroom, 2 Bath Cedar Exterior home with a 576 SF garage with workshop, 1/2 bath and utility area. The rustic wood in the living and dining room gives you that ranch house feeling. There is a great open deck that you can exit from Primary bedroom and have access to the garage and the guest cottage which offers open concept, 3/4 bath and CAH, plus it\'s own sitting porch. The 2700 SF pole barn has a tack and feed room and is ready to be divided in to stables or pens. Let\'s not forget hendominium. It is a cadillac of a chicken house! This Jewel is the perfect place to become self-sufficient and have your own animals, and raise your own vegetables. Call for a viewing today.' ,`Acres` = '3' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '3.0 Acres in the JM Dikes ABST 27' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '130680' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'N/A' ,`TaxAmount` = '3437' ,`TaxRate` = '1.742' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675088761' WHERE `Matrix_Unique_ID` = '214657804' --> 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','214788524','1675088761','214788524','2022-12-08T13:15:50.127','21918939','Ozzie Ramirez','eXp Realty, LLC','','','28.968011','-95.699662','34','77414','2','325000.00','Active','County Road 163','582','','Bay City','1','0','2','1188','Single-Family','Country living at it\'s best! This gorgeous property has 10.05 acres with abundant wild life! Enjoy lots of fishing in the live water creek and 2 ponds. This property includes a beautiful 2 bedroom one bath home with a large front porch. Interior home features include a large living area with open concept, a large kitchen with lots of counter space, and a maple butcher block island for food prep or extra seating. GPS will take you to the property before it. This property is gated, but gate will be open for showings. Two parcels being sold together on a total 10.05 acres Land is partially wooded and partially cleared.','10.05','54','','','','','Other Disclosures,Sellers Disclosure,Tenant Occupied','0','','0','','Central Electric','0','AB 0502, S F AUSTIN, ACRES 4.58','Cleared,Wooded','199505','Appraisal District','','','0','','0','Electric Oven','0','','','Electric Cooktop,Electric Range','','Composition','134 - Van Vleck','VAN VLECK ELEMENTARY SCHOOL','VAN VLECK HIGH SCHOOL','O H HERMAN MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','S F Austin','2941','1.9671','Septic Tank,Well','2019','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215227233','1675088761','215227233','2022-12-08T14:40:31.740','50936738','Cyndi Kornegay','Gatehouse Properties','','','29.949720','-95.780144','7','77433','11','780556.00','Active','Cosmopolitan','11355','Drive','Cypress','3','1','4','3687','Single-Family','This gorgeous, 2-story home invites you in with a towering foyer with a spiral staircase, a cozy guest suite with it\'s own private bath, and a study. The spacious formal dining room is perfect for family and friends to gather and a butler\'s pantry that makes it convenient to entertain. The open-concept kitchen offers an abundant pantry and stainless steel appliances. Retreat to your master suite with an oversized walk-in closet, a shower with seat and a garden tub. With 2 bedrooms, a game room, powder bath, and a media room upstairs, this home is perfect for any family. Or if you\'d prefer, go thru your sliding glass doors to spend a Texas evening in your oversized covered patio with a yard large enough for a future pool. Don\'t miss out on this incredible home!','','25','Coventry Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','HOA First Right of Refusal,Mi/Lenders Approval,Mud','1','Gaslog Fireplace','1','Cypress South','Central Gas','1','Lot 14 Block 1','Greenbelt,Subdivision Lot','11888','Appraisal District','','1197','1','To Be Built/Under Construction','3','Electric Oven','0','','','Electric Cooktop,Gas Cooktop','','Composition','55 - Waller','ROBERTS ROAD ELEMENTARY SCHOOL','WALLER HIGH SCHOOL','WALLER JUNIOR HIGH SCHOOL','Accompany,Appointment Required,No Supra Keybox','Builder','2','Traditional','Bridgeland','','3.52','Public Sewer,Public Water,Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215408658','1675088761','215408658','2022-12-08T13:51:57.713','47068246','Lei Jin','eXp Realty, LLC','','','29.865276','-95.206408','12','77044','8','265000.00','Active','Myrtle Field Lane','10015','','Houston','2','1','4','2153','Single-Family','4 Bedroom / 2.5 Bath, Master Suite down, Spacious Game Room, Open Kitchen, Walk-in Closets in all bedrooms, Separate Tub and Shower in Master Bath, Dual Vanity Sinks in Master Bath, 42 upper Kitchen Cabinets, Granite Kitchen Countertops, Black Appliances (Microwave, Stove, Dishwasher, Refrigerator) Radiant Barrier Tech Shield, Covered Rear Patio, Utility Room downstairs, Irrigation System, 2-car attached garage.','','2','','','Gas Dryer Connections,Washer Connections','','No Disclosures','1','','','North Channel','Central Gas','1','Lot 4, Blk 3','Subdivision Lot','5564','Appraisal District','','275','0','','2','Gas Oven','0','','','Gas Range','','Composition','46 - Sheldon','CARROLL ELEMENTARY SCHOOL (SHELDON)','CE KING HIGH SCHOOL','MICHAEL R. NULL MIDDLE SCHOOL','Lockbox Front','Appraisal District','2','Traditional','Hidden Meadow','','','Water District','2015','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215438329','1675088761','215438329','2022-12-08T14:01:52.337','97781387','Ricky Torres','Keller Williams Realty - Memor','','','29.877135','-95.451612','8','77088','5','310000.00','Active','Sunnyhill','8415','','Houston','2','1','3','1675','Single-Family','Imagine yourself coming home to 8415 Sunny Hill St every day – it would be like a dream come true! This luxury brand new construction home has everything you could want and more. From the modern design to the open floor concept layout, this home will make you feel right at home. You’ll appreciate all of the extra features this home offers, such as the large energy efficient windows, luxurious tub and stand up shower in the suite bathroom, and much more. Make 8415 Sunny Hill St #B your next address – schedule your showing today!','0.0573921','11','AE Construction Serv','','Gas Dryer Connections,Washer Connections','','No Disclosures','1','','','Northwest Houston','Central Gas','0','LTS 4 BLK 1 WASHINGTON HEIGHTS ANNEX SEC 1','Cleared','2750','Survey','','','1','To Be Built/Under Construction','1','Gas Oven','0','','','Gas Range','','Composition','1 - Aldine','ANDERSON ACADEMY','CARVER H S FOR APPLIED TECH/ENGINEERING/ARTS','DREW ACADEMY','Appointment Required,Request Online Appointment','Builder','2','Contemporary/Modern','Washington Heights Annex Sec 0','967','2.5119','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215446519','1675088761','215446519','2022-12-08T13:25:11.257','59922672','Wendi Bangoy','Keller Williams SoutheastTexas','','','31.068714','-94.027607','40','75931','9','420000.00','Active','Broadmoor','236','Drive','Brookeland','2','0','4','2200','Single-Family','Completely Remodeled Golf Front home on Rayburn Resort\'s Golf Course! This 4 Bedroom / 2 Bath features a fresh interior ready for you and your family/friends! A great home for entertaining, this property features a large living room with vaulted ceilings and a stone faced w/b fireplace that opens onto both the kitchen/dining spaces along with the 20\'x18\' covered deck that overlooks the golf course! With spacious bedrooms throughout and a 4th bedroom that could easily become a bunk room or secondary living space, this property gives you plenty of potential for a primary, secondary or vacation rental property! This property also features a 2 car oversized garage with golf cart bay that could house a cart, jet ski or other recreational accessories! A short cart ride to the Resort/Pool/Restaurant/Coffeeshop and a short drive to Lake Sam Rayburn, Shopping, Restaurants and multiple boat ramps! Call for more information!','0.505','46','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Wood Burning Fireplace','1','','Central Electric','1','LOT 2 BLK 3 SEC 5 RAYBURN COUNTRY 0.505 ACRES','Cleared,In Golf Course Community,On Golf Course','21998','Appraisal District','','100','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','149 - Jasper','BROOKELAND ELEMENTARY SCHOOL','BROOKELAND HIGH SCHOOL','BROOKELAND HIGH SCHOOL','Appointment Required','Seller','1','Ranch','Rayburn Country Sec 5','3444','1.9267','Public Sewer,Public Water,Water District','1980','Seller'); --> New record created successfully