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-11-23T20:13:50.843' ,`MLSNumber` = '86260891' ,`ListAgentFullName` = 'Robin Landua' ,`ListOfficeName` = 'BHGRE Hometown' ,`SellingAgentFullName` = 'Marcella Feagin' ,`SellingOfficeName` = 'Coldwell Banker PropertiesUnlimited' ,`Latitude` = '30.210895' ,`Longitude` = '-96.420923' ,`PhotoCount` = '24' ,`PostalCode` = '77833' ,`RoomCount` = '3' ,`ListPrice` = '299000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Possum Trot' ,`StreetNumber` = '3004' ,`StreetSuffix` = 'Street' ,`City` = 'Brenham' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1792' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3 bedroom, 2 bath brick home on a half acre lot in desirable Oak Hill Acres. Inside you will find a large living room with wood burning fireplace, lighted built in display cabinet, and sliding glass doors out to the covered patio. The living room is open to the dining room and kitchen that has a breakfast nook, tons of cabinet space, bar and bar sink. On the opposite side of the house are two guest bedrooms, hall bath, and primary bedroom with attached bath and large walk in closet. The entire interior of the house has recently been painted and brand new laminate flooring in the living, kitchen and dining room and new carpet in the bedrooms. Outside there is a fenced back yard and beautiful live oak trees.' ,`Acres` = '0.5008' ,`Area` = '58' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'OAK HILL ACRES SEC III , LOT 75' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '21813' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '137 - Brenham' ,`SchoolElementary` = 'BISD DRAW' ,`SchoolHigh` = 'BRENHAM HIGH SCHOOL' ,`SchoolMiddle` = 'BRENHAM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Oak Hill Acres' ,`TaxAmount` = '3409' ,`TaxRate` = '1.9088' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641779' WHERE `Matrix_Unique_ID` = '208906168' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T19:37:55.670' ,`MLSNumber` = '96752474' ,`ListAgentFullName` = 'Dakar Gibbs' ,`ListOfficeName` = 'Century 21 ExclusiveProperties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.849981' ,`Longitude` = '-95.418344' ,`PhotoCount` = '39' ,`PostalCode` = '77091' ,`RoomCount` = '7' ,`ListPrice` = '522944.00' ,`Status` = 'Active' ,`StreetName` = 'Paul Quinn' ,`StreetNumber` = '807' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2264' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Paul Quinn Place features 4 individually gated single family contemporary homes with remote gate access and guest parking. 807 Paul Quinn features the 2,264SF Oleander plan with 3 BR, 3.5 BTH, game room and massive 3rd floor patio set up for outdoor kitchen. Front elevation features 21” of beautiful stone! Porcelain, quartz and glass in bathrooms! Soft close cabinets! 10’ ceilings on 1st and 2nd floors! 9’ ceiling on 3rd floor! Large bedrooms/closets! Tall ceilings! Custom doors throughout! Plenty of natural light! Custom glass balcony rails! Smart wired including garage! Lots of storage space! Great finishes! Plenty of amenities within 3 miles or less (Memorial Hermann Greater Heights, Starbucks, BofA, Chase, BBVA, Home Depot, Lowe’s, HEB, Kroger, Berryhill, Five Guys, Walking Stick, Oak Forest Public Library, I-45, and 610) No HOA dues! Centrally located 8 miles from downtown! Appliances included! Close by January 15, 2023 and get a free smart TV! Custom Urban Living!' ,`Acres` = '0' ,`Area` = '9' ,`BuilderName` = '44 Builders LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 PAUL QUINN PLACE' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '1991' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HIGHLAND HEIGHTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'HIGHLAND HEIGHTS ANNEX' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669641779' WHERE `Matrix_Unique_ID` = '209533973' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T20:52:58.957' ,`MLSNumber` = '84526929' ,`ListAgentFullName` = 'Kimberly Gaido' ,`ListOfficeName` = 'Sand N Sea Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.279874' ,`Longitude` = '-94.808216' ,`PhotoCount` = '40' ,`PostalCode` = '77550' ,`RoomCount` = '10' ,`ListPrice` = '649000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue T' ,`StreetNumber` = '4116' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2782' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investors dream or full-time residence, this completely remodeled 5 bedroom 3 bath unique coastal beauty is located just one block from the beach. \r\nThis property features 2 homes in one w/ separate access for each if needed. Hear the Gulf of Mexico and feel the southern breezes from the front porch or deck.Both levels offer bedroom/bath, kitchen, and open living-dining areas. Live in one and rent the other or a mother-in-law suite. Wood floors, custom wood cabinetry, SS appliances, quartz counters, Breakfast bar, spacious laundry/mud room, two car garage, outdoor shower & hot tub. Other Features: new light fixtures and hardware. Please see the attached documents that lists all improvements and with in the last several years. \r\nLow flood insurance.' ,`Acres` = '0.1185' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Midtown - Galveston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOT 11 SE BLK 158 GALVESTON OUTLOTS' ,`LotDesciption` = 'Other' ,`LotSize` = '5160' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Galveston Outlots' ,`TaxAmount` = '6108' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1938' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641780' WHERE `Matrix_Unique_ID` = '210772310' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T20:37:20.050' ,`MLSNumber` = '69468069' ,`ListAgentFullName` = 'Elpidia Orantes' ,`ListOfficeName` = 'Keller Williams Platinum' ,`SellingAgentFullName` = 'Rashad Ajalov' ,`SellingOfficeName` = 'Walzel Properties' ,`Latitude` = '29.774835' ,`Longitude` = '-95.424778' ,`PhotoCount` = '8' ,`PostalCode` = '77007' ,`RoomCount` = '4' ,`ListPrice` = '385000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Tyne' ,`StreetNumber` = '6126' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1430' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NO SHOWINGS!!! This property is Being sold as is. Lot value only. Sale cash or investors only.' ,`Acres` = '0.092' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Rice Military/Washington Corridor' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'TR 13 BLK 9 ADAM CLAY SEC 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '4008' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Adam Clay Sec 02' ,`TaxAmount` = '7150' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1927' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641780' WHERE `Matrix_Unique_ID` = '210884398' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T20:10:57.133' ,`MLSNumber` = '42298621' ,`ListAgentFullName` = 'Trey Perez' ,`ListOfficeName` = 'Keller Williams Elite' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.734048' ,`Longitude` = '-94.944122' ,`PhotoCount` = '16' ,`PostalCode` = '77520' ,`RoomCount` = '11' ,`ListPrice` = '235900.00' ,`Status` = 'Active' ,`StreetName` = 'Dwinnell' ,`StreetNumber` = '1201' ,`StreetSuffix` = 'Street' ,`City` = 'Baytown' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2281' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! You must see this beautiful 1 story 3 bedroom 2 bathroom home including an attached Mother In Law Quarters/Guest Suite with an additional bedroom, handicap bathroom, and a full kitchen! This fabulous spacious home sits on a large corner lot with many large shade trees! Updates to the home include a new roof installed July 2022 and laminate flooring. Great location with easy access to I-10, HWY 146, Grand Parkway 99, and Spur 330! Call today to schedule your private showing!' ,`Acres` = '0.2287' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 & S 14 FT OF LT 2 BLK 8 PLUMWOOD SEC 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9960' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'LORENZO DE ZAVALA ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'CEDAR BAYOU J H' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Plumwood Sec 02' ,`TaxAmount` = '4922' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641780' WHERE `Matrix_Unique_ID` = '211043221' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T20:14:45.423' ,`MLSNumber` = '28315364' ,`ListAgentFullName` = 'Cesar Calderon' ,`ListOfficeName` = 'Camelot Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.866219' ,`Longitude` = '-95.701757' ,`PhotoCount` = '22' ,`PostalCode` = '77449' ,`RoomCount` = '6' ,`ListPrice` = '268900.00' ,`Status` = 'Active' ,`StreetName` = 'Gettysburg Valley' ,`StreetNumber` = '6303' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1947' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*$2,000 Buyer Incentive!**Roof Replaced 2021, HVAC replaced 2018, No flooding during Harvey* Come see this great 3 bed, 2 bath single story 2 car garage home. Located at the corner of a cul-de-sac this freshly painted home offers a cozy floor plan perfect for a starting family or those who are ready for a low-maintenance downsize. This beauty provides a spacious living room, formal dining room, receiving area, large kitchen with breakfast area, walk-in closet in the primary bedroom, and a whirlpool tub in the primary bathroom. It is conveniently located within walking distance of Jowell Elementary School. Great shopping nearby. less than 30 minutes away from the Houston Premium Outlets, 2 Costco Stores, Katy Mills, Hospitals, The Boardwalk at Towne Lake, and much more! Quick Access to 290, I-10, and 99. Don\'t miss out!' ,`Acres` = '0.1889' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 28 BLK 2 BEAR CREEK PLANTATON SEC 3' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8229' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '460' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'JOWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bear Creek Plantaton' ,`TaxAmount` = '4942' ,`TaxRate` = '2.671' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641780' WHERE `Matrix_Unique_ID` = '212558210' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T19:14:37.480' ,`MLSNumber` = '27151541' ,`ListAgentFullName` = 'Elena Tsilina' ,`ListOfficeName` = 'House Hunter Houston, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.249274' ,`Longitude` = '-95.528635' ,`PhotoCount` = '46' ,`PostalCode` = '77384' ,`RoomCount` = '7' ,`ListPrice` = '515000.00' ,`Status` = 'Active' ,`StreetName` = 'Kerrick Vista' ,`StreetNumber` = '14402' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3134' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful two-story home with 3 car garage in a desirable community of Foster`s Ridge. This home features gorgeous brick\r\nand stone exterior and includes a 4 bed/3 baths and a spacious Game Room! Features include upgraded SS appliances w/gas\r\nburner cooktop, granite countertops, Osmosis system and 42\" cabinets in Kitchen, Smart Home Package, Tankless Water\r\nHeater, Covered Patio, and Full Sprinkler System. The property showcases expansive front and back yards with landscaping\r\nfeatures. This home is zoned to highly acclaimed Woodlands Schools within Conroe ISD. Better than new! Barely lived in for 6\r\nmonths and no building delays, part of DR Horton\'s classic line. Fosters Ridge offers a beautiful community center,\r\nplayground, and pool. This is a must-see home that offers affordable luxury in a premium location for whatever adventures you\r\nseek.' ,`Acres` = '0.3493' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S516407 - FOSTERS RIDGE 07, BLOCK 3, LOT 5' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '15217' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,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 Left Side' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fosters Ridge 07' ,`TaxAmount` = '1242' ,`TaxRate` = '3.1488' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641781' WHERE `Matrix_Unique_ID` = '212574118' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T19:10:21.040' ,`MLSNumber` = '84411423' ,`ListAgentFullName` = 'Kathryn Lawrence' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.252174' ,`Longitude` = '-95.444291' ,`PhotoCount` = '22' ,`PostalCode` = '77302' ,`RoomCount` = '8' ,`ListPrice` = '324900.00' ,`Status` = 'Active' ,`StreetName` = 'River Plantation' ,`StreetNumber` = '522' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2600' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ready for a quick close!! Gorgeous southern beauty on a peaceful lot, with Golf Course views in front, views of Charleston Park on side & back! Two living areas & dining areas downstairs; one could make a great study/office, if that fits your needs. The family room features a bay window overlooking the backyard and park, gas log fireplace, & nearby wet-bar. There is a 1/2 bath downstairs, too! Huge, private, primary bedroom up w/3 walk-in closets & updated en-suite bathroom retreat, w/ separate jetted tub! Secondary bedrooms are split by the conveniently-located upstairs laundry room! Very recent gutters & whole house water softener. Oversized garage. Convenient to The Woodlands & Lake Conroe. Nearby amenities include world-class hospitals, shopping, dining/entertainment, schools. Neighborhood offers community parks, walking trails, pool, tennis & basketball. Membership to golf course is optional, and the Grill is open to the public! Don\'t miss out! Make an appointment today!' ,`Acres` = '0.237' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'RIVER PLANTATION 02, LOT 51' ,`LotDesciption` = 'Greenbelt,In Golf Course Community' ,`LotSize` = '10325' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '233' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Colonial,Georgian,Traditional' ,`Subdivision` = 'River Plantation' ,`TaxAmount` = '3811' ,`TaxRate` = '2.1648' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641781' WHERE `Matrix_Unique_ID` = '212796369' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T19:45:47.370' ,`MLSNumber` = '94857184' ,`ListAgentFullName` = 'Marina Gaitan' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.865615' ,`Longitude` = '-95.732521' ,`PhotoCount` = '8' ,`PostalCode` = '77449' ,`RoomCount` = '6' ,`ListPrice` = '270000.00' ,`Status` = 'Active' ,`StreetName` = 'Stoney Haven' ,`StreetNumber` = '21039' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1628' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great starter home in a prime Katy location close to schools shopping and restaurants. Zoned to highly acclaimed Cy-Fair ISD. The primary room has an ensuite bath with tub and separate shower and a large closet. Secondary bedrooms are all well sized and also feature great closet space. Resent inside paint and wood finished vinyl throughout the house. The huge backyard is fully fenced.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7262' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WALKER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Settlers Village' ,`TaxAmount` = '4964' ,`TaxRate` = '6.44' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641781' WHERE `Matrix_Unique_ID` = '213012633' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T19:21:49.760' ,`MLSNumber` = '9986626' ,`ListAgentFullName` = 'Edward Beard' ,`ListOfficeName` = 'Everyones, Realtor LLC' ,`SellingAgentFullName` = 'Alan Doan' ,`SellingOfficeName` = 'Nextgen Real Estate Properties' ,`Latitude` = '29.883384' ,`Longitude` = '-95.617299' ,`PhotoCount` = '35' ,`PostalCode` = '77041' ,`RoomCount` = '6' ,`ListPrice` = '242500.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Fieldstone' ,`StreetNumber` = '13715' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1504' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DON\'T MISS THIS ONE OWNER GEM! TOTALLY UPGRADED INSIDE! High end Quartz kitchen counters, some new appliances, charming new backsplash, High end Faucet, and undermount sink. Push button fireplace in large living room, Brand new water resistant luxury vinyl floors, new ceiling fans, light fixtures, huge primary bedroom! Fresh paint inside and out including Covered back porch with large back yard. Award winning Cy Fair Schools. Close to shopping and fine dinning. Neighborhood Pool , Park and Lake.' ,`Acres` = '0.1584' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 3 CHIMNEY HILL SEC 1' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '6900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '385' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HAIRGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'LABAY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Chimney Hill Sec 01' ,`TaxAmount` = '4223' ,`TaxRate` = '2.811' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641781' WHERE `Matrix_Unique_ID` = '213217292' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T19:43:53.257' ,`MLSNumber` = '39986074' ,`ListAgentFullName` = 'Bobby McMahon' ,`ListOfficeName` = 'Southern Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.907559' ,`Longitude` = '-95.250216' ,`PhotoCount` = '44' ,`PostalCode` = '75862' ,`RoomCount` = '3' ,`ListPrice` = '679900.00' ,`Status` = 'Active' ,`StreetName` = 'Bellamy' ,`StreetNumber` = '219' ,`StreetSuffix` = 'Drive' ,`City` = 'Trinity' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1843' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 3.59 acres of unrestricted waterfront paradise. This wonderfully remodeled 2-bedroom 2-bath was taken down to the studs and made into the beautiful home you see today. From the granite counter tops to the river rock shower floor this home is absolutely gorgeous. Watch the sunset from almost any room in the house or from the custom-built fire pit overlooking Lake Livingston. Take a walk down your own private board walk to your very own pier and cast a line or walk along approximately 250 feet of your bulkhead and see what\'s biting. All updates have been done in the last 4 years including the bulkhead. Public boat ramp just down the street, 30 foot deep channel just out from your private pier. This wonderful property has the potential to your personal weekend getaway, a income producing Air BB, or build more houses on the 3.59 unrestricted waterfront property.' ,`Acres` = '3.59' ,`Area` = '42' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Stove' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'A0411 MC KIM, WILLIAM,3.59 ACRES' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '156380' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '59 - Groveton' ,`SchoolElementary` = 'GROVETON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GROVETON J H-H S' ,`SchoolMiddle` = 'GROVETON J H-H S' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'no' ,`TaxAmount` = '2550' ,`TaxRate` = '1.6133' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1669641781' WHERE `Matrix_Unique_ID` = '213248974' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T19:01:10.923' ,`MLSNumber` = '44864347' ,`ListAgentFullName` = 'Elena Tsilina' ,`ListOfficeName` = 'House Hunter Houston, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.593026' ,`Longitude` = '-95.230809' ,`PhotoCount` = '46' ,`PostalCode` = '77089' ,`RoomCount` = '5' ,`ListPrice` = '230000.00' ,`Status` = 'Active' ,`StreetName` = 'Sagevale' ,`StreetNumber` = '10811' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1514' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful one-story 3-bedroom/ 2-bathroom house in the popular established neighborhood of Sagemont. As you walk in the\r\ndoor to your right you will find a spacious flex room perfect for a formal dining room, home office, gym, game room, or 2nd\r\nliving room. This home also features recent AC and water heater units, tile flooring, a shed, and a large backyard.\r\nWasher/dryer, refrigerator – all negotiable! Call today to schedule your private showing!' ,`Acres` = '0.1667' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 32 BLK 53 SAGEMONT SEC 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7260' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'FRAZIER ELEMENTARY SCHOOL (PASADENA)' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'THOMPSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Sagemont Sec 09' ,`TaxAmount` = '4215' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641782' WHERE `Matrix_Unique_ID` = '214010376' --> 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','214044188','1669641782','214044188','2022-11-23T19:57:17.710','78798340','Leslie Jerez','HomeSmart','','','29.900127','-95.688325','19','77433','7','370000.00','Active','Woodland Knoll','8426','Lane','Cypress','2','1','5','3072','Single-Family','5 bedroom 2.5 bathroom home tucked into the Lone Oak neighborhood in Cypress is waiting for your personal touch to turn this into your dream home! Master bedroom located downstairs and 4 bedrooms and game room is upstairs. Situated right next to a walking trail in this tree-lined neighborhood. Priced to sell! Let your imagination run wild and come grab this opportunity before it is too late!','0.1879','25','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections','1','Cypress South','Central Gas','1','LT 7 BLK 4 LONE OAK VILLAGE SEC 2','Subdivision Lot','8185','Appraisal District','','772','0','','2','Electric Oven','0','','','Gas Range','','Composition','13 - Cypress-Fairbanks','POSTMA ELEMENTARY SCHOOL','CYPRESS SPRINGS HIGH SCHOOL','ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Lone Oak Village Sec 02','6432','2.5535','Water District','2004','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T20:23:38.843' ,`MLSNumber` = '4039783' ,`ListAgentFullName` = 'Jennifer Hansen' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.752030' ,`Longitude` = '-95.848896' ,`PhotoCount` = '50' ,`PostalCode` = '77494' ,`RoomCount` = '11' ,`ListPrice` = '715000.00' ,`Status` = 'Active' ,`StreetName` = 'Pinpoint Crossing' ,`StreetNumber` = '27815' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '3973' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**RARE FIND 3900 sq ft+ ONE STORY**FEATURING 5 BEDROOMS 4 FULL & 2 HALF BATHS w/ POOL/SPA/OUTDOOR KITCHEN/FIRE PIT and a 3 CAR GARAGE nestled on an 11,000 sq ft+ LOT in FIRETHORNE. Upon entry you will be greeted with SOARING CEILINGS (10-13ft) & a wide entry leading to the OFFICE STUDY, ENSUITE BEDROOM 2 & FORMAL DINING. Spacious ISLE KITCHEN w/CUSTOM LIGHTING, STAINLESS APPLIANCES,REVERSE OSMOSIS WATER SYSTEM & WRAP AROUND BREAKFAST/SERVING BAR. FAMILY ROOM w/FLOOR TO CEILING TILED FIREPLACE and WINDOW WALL w/GORGEOUS POOL VIEWS & access to the GAME/MEDIA ROOM w/CUSTOM BUILT-INS.TEXAS SIZED PRIMARY SUITE w/POOL VIEWS & ENSUITE BATH w/UPGRADED WALK-IN RAIN SHOWER & 2 PRIMARY CLOSETS. CUSTOM \"MIL/GUEST WING\" added after purchase features a LARGE BEDROOM w/ENSUITE BATH (walk in shower) & POOL VIEWS. BUILT-INS in ALL CLOSETS & UTILITY ROOM. EASY COMMUTE to the ENERGY CORRIDOR. LOADS OF NEIGHBORHOOD AMENITIES. WATER SOFTENER AND TANKLESS WATER HEATER. LOW TAX RATE! KATY ISD. NEVER FLOODED.' ,`Acres` = '0.2683' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'FIRETHORNE SEC 19, BLOCK 3, LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11685' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WOLMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Firethorne Sec 19' ,`TaxAmount` = '13717' ,`TaxRate` = '2.6945' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641782' WHERE `Matrix_Unique_ID` = '214068457' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T19:35:27.910' ,`MLSNumber` = '86335821' ,`ListAgentFullName` = 'Steve Hardcastle' ,`ListOfficeName` = 'RE/MAX Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.851763' ,`Longitude` = '-95.595875' ,`PhotoCount` = '50' ,`PostalCode` = '77041' ,`RoomCount` = '11' ,`ListPrice` = '710000.00' ,`Status` = 'Active' ,`StreetName` = 'Marina Vista' ,`StreetNumber` = '5707' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4249' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful DR Horton Custom Series 5 BR home on a large lot backing to a green belt and creek. Large pool,big covered patio with outdoor kitchen. Grand entry,both formals,big 2 story family room with fireplace,granite island kitchen with stainless appliances and butlers pantry,large master suite with sitting area and lavish remodeled bath,second bedroom down,large gameroom,2 staircases,4 full baths. 4045 sq ft in main house,plus 17x12 AC & heated room in third bay of the stacked garage (can be easily converted back to a 3 car garage). Incredible updates include all new double pane energy efficient windows and solar panels for significant electricity savings,recently replaced roof/AC and water heater,most flooring,plantation shutters and more.' ,`Acres` = '0.266' ,`Area` = '8' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas,Solar Assisted,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 1 LAKES ON ELDRIDGE NORTH SEC 1' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '11586' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1860' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'KIRK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes On Eldridge North' ,`TaxAmount` = '13126' ,`TaxRate` = '2.431' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641782' WHERE `Matrix_Unique_ID` = '214219503' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T19:33:14.673' ,`MLSNumber` = '47711691' ,`ListAgentFullName` = 'Duni Mejia' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.703459' ,`Longitude` = '-95.666710' ,`PhotoCount` = '28' ,`PostalCode` = '77083' ,`RoomCount` = '8' ,`ListPrice` = '254900.00' ,`Status` = 'Active' ,`StreetName` = 'Escondido' ,`StreetNumber` = '6822' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1694' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 6822 Escondido Drive! Beautiful, well-maintained single-story w/ 3 bedrooms & 2 full bathrooms! The home has been recently upgraded with a brand-new roof (10 Months Old), AC is only 2 years old, fully replaced backyard fencing, new energy efficient double pane windows have been installed. No carpet in the entire home! The kitchen features new Formica countertops, cabinets, stainless steel gas range and more! The large living room has vaulted ceilings with a living/dining combo featuring a gas log fireplace. The entire home has fresh paint on the interior. Close to many amenities with easy access to Hwy 6 and West Park Toll Road. Schedule your private tour today!' ,`Acres` = '0.1736' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 1 MISSION BEND SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '330' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'PETROSKY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'ALBRIGHT MIDDLE SCHOOL' ,`ShowInstructions` = 'Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mission Bend Sec 01' ,`TaxAmount` = '4596' ,`TaxRate` = '2.437' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641782' WHERE `Matrix_Unique_ID` = '214441318' --> 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','214503731','1669641783','214503731','2022-11-23T19:18:12.257','50031455','Leroy Johnson','Keller Williams Premier RealtyKaty','','','29.467653','-95.027798','34','77539','9','275000.00','Active','Thistle','5405','Drive','Dickinson','2','0','3','2516','Single-Family','INVESTOR SPECIAL: This home is located in Briar Glen and offers one of the most expansive floor plans in the neighborhood. The massive den/family room sets this home apart from others in the neighborhood. The 4th bedroom upstairs could be used as a game room, exercise room, office, or playroom. Located within walking distance of Dickson High School and John Barber Middle School, the home\'s location is extremely desirable. This home is being sold \"AS IS\" and does need some TLC. If you can give this home a little love, you have found yourself a diamond in the rough.','0.2135','33','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Wood Burning Fireplace','1','Dickinson','Central Electric','0','ABST 60 E P EPPERSON SUR LOT 21 BRIAR GLEN SUB','Subdivision Lot','9300','Appraisal District','','','0','','2','Electric Oven,Freestanding Oven','0','','','Electric Range,Freestanding Range','','Composition','17 - Dickinson','HUGHES ROAD ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','JOHN AND SHAMARION BARBER MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','BRIAR GLEN','6069','2.5214','Public Sewer,Public Water','1982','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T19:33:36.157' ,`MLSNumber` = '64027478' ,`ListAgentFullName` = 'Michael Green' ,`ListOfficeName` = 'Reward Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.530770' ,`Longitude` = '-95.186413' ,`PhotoCount` = '13' ,`PostalCode` = '77546' ,`RoomCount` = '7' ,`ListPrice` = '222500.00' ,`Status` = 'Active' ,`StreetName` = 'Royal' ,`StreetNumber` = '5347' ,`StreetSuffix` = 'Parkway' ,`City` = 'Friendswood' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2086' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investor special on this home with oversized lot.The potential is endless.' ,`Acres` = '0.2388' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 5 WEDGEWOOD VILLAGE SEC 8 U/R' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '45' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'WEDGEWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'BROOKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Wedgewood Village Sec 08 U/R' ,`TaxAmount` = '5627' ,`TaxRate` = '2.2534' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641783' WHERE `Matrix_Unique_ID` = '214560339' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T19:53:58.350' ,`MLSNumber` = '58425271' ,`ListAgentFullName` = 'Charles Blakely' ,`ListOfficeName` = 'RE/MAX Leading Edge' ,`SellingAgentFullName` = 'Cindy Kipling' ,`SellingOfficeName` = 'Realty Associates' ,`Latitude` = '29.569265' ,`Longitude` = '-95.123940' ,`PhotoCount` = '30' ,`PostalCode` = '77062' ,`RoomCount` = '4' ,`ListPrice` = '325000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Beachcomber' ,`StreetNumber` = '1418' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2591' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great opportunity to own an updated home on a quiet, tree lined street with an oversized lot. Plenty of parking on the recently replaced large driveway leading to a full two car garage. Newly painted inside and out along with all new rain gutters. Inside you will find new tile flooring and original hardwood flooring complimented by Saltillo tile. Beautifully updated kitchen with new quartz countertops, cabinets and appliances. Owner credit for dishwasher and microwave. Enjoy the view of the expansive backyard from your owner’s suite with large sliding glass doors. Your fully remodeled owner\'s ensuite bath is complete with new tile flooring, cabinets, quartz countertops and a custom walk-in shower. There’s even a custom cedar lined walk-in closet! Relax in the oversized sunroom overlooking the backyard. Walking distance to elementary school and the amazing Exploration Green nature trail complex. Call today for your private showing!' ,`Acres` = '0.2342' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 504 BLK 38 CLEAR LAKE CITY SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '82' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'CLEAR LAKE CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Clear Lake City Sec 03 Reserve H' ,`TaxAmount` = '6616' ,`TaxRate` = '2.5769' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641783' WHERE `Matrix_Unique_ID` = '214629431' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T19:48:18.637' ,`MLSNumber` = '6896140' ,`ListAgentFullName` = 'James Alford' ,`ListOfficeName` = 'Alford Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.043703' ,`Longitude` = '-95.720103' ,`PhotoCount` = '34' ,`PostalCode` = '77480' ,`RoomCount` = '3' ,`ListPrice` = '370000.00' ,`Status` = 'Active' ,`StreetName` = 'Azalea' ,`StreetNumber` = '1600' ,`StreetSuffix` = 'Street' ,`City` = 'Sweeny' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2502' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Custom built home with many amenities. Walking in through the front door you immediately notice the craftsmanship. Marble floor tile, the spiral staircase, block paneling and glass expands the entire length to the high ceiling. A woodburning fireplace equipped gas logs, and a wet bar are perfect for gatherings. Covered patio can also be accessed from living area. Large primary bedroom with a bath that is roomy. Oversized tub and separate shower/double sink vanity and double walk-in closet. Each bedroom upstairs has its own vanity with sink. The view out of the back yard makes one feel like they\'re in the country. D Squared foundation is under contract to be repaired November 28, 2022. Three car garage with extra parking on .44 acre make this a gem near the end of a cul-de-sac.' ,`Acres` = '0.444' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'SAN BERNARD VILLA SEC III (A0046 C BREEN) (SWEENY) BLK 1 LOT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '19341' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '51 - Sweeny' ,`SchoolElementary` = 'SWEENY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SWEENY HIGH SCHOOL' ,`SchoolMiddle` = 'SWEENY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'San Bernard Villa Sec III' ,`TaxAmount` = '5525' ,`TaxRate` = '2.8427' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641783' WHERE `Matrix_Unique_ID` = '214744267' --> 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','214823043','1669641783','214823043','2022-11-23T20:39:29.743','95141781','Heather Lange','RE/MAX One','','','29.944303','-93.902030','25','77619','12','375000.00','Active','Magnolia','2801','Lane','Groves','3','0','4','2506','Single-Family','Step into this entertainer\'s dream located in PNG-ISD. This lovely home features welcoming columns, high ceilings, split floor plan, and an upstairs game room with a full bathroom that could be a 4th bedroom. The master bedroom has a partial wall for a quiet sitting area or an office. Lots of room to host plenty of guests for dinner; with a formal dining area, breakfast table area and a bar. The backyard has a covered patio and 2 areas for storage. This home is a must-see!','','51','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','','Central Gas','0','LT 10 BLK 5 PLAZA TERRACE NO 2','Subdivision Lot','','','','','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','233 - Port Neches-Groves','PORT NECHES ELEMENTARY SCHOOL','PORT NECHES-GROVES HIGH SCHOOL','GROVES MIDDLE SCHOOL','Appointment Required','Seller','1.5','Traditional','Plaza Terrace','','','Public Sewer,Public Water','2007','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','214939717','1669641783','214939717','2022-11-23T19:00:57.663','13398304','Carley Ricciardi','BHGRE Gary Greene','','','30.219838','-95.515856','46','77382','10','489000.00','Active','York Gate','39','Court','The Woodlands','2','1','4','2667','Single-Family','Private backyard oasis! This 2 story home sits on a wooded, oversized corner 10,317 sq foot lot, on a culdesac street in Alden Bridge. Bike to nearby Bush Elementary and Mitchell Intermediate schools! \r\nNumerous updates include roof (2014), 6’6” backyard privacy fence (2017), gates, water heater, downstairs AC/furnace (2017), steel back door, laminate flooring (2019), upstairs AC/furnace, dishwasher, wall oven (2021), microwave, recessed LED can lighting (2022). \r\nLocated in the master-planned community of The Woodlands which offers multiple parks, golf clubs, walking trails, pools, and close by to The Woodlands Mall, Market Street, shopping, dining, and more!','0.2368','15','Ryland','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace,Wood Burning Fireplace','1','The Woodlands','Central Gas,Zoned','0','WDLNDS VIL ALDEN BR 19, BLOCK 2, LOT 19','Corner,Cul-De-Sac,Wooded','10317','Appraisal District','','','0','','2','Electric Oven,Single Oven','1','Gunite,In Ground','','Gas Cooktop','','Composition','11 - Conroe','BUSH ELEMENTARY SCHOOL (CONROE)','THE WOODLANDS HIGH SCHOOL','MCCULLOUGH JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Wdlnds Village Alden Br 19','7249','2.1811','Public Sewer,Public Water,Water District','1996','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','214961807','1669641784','214961807','2022-11-23T19:53:32.580','6366138','Melissa Rod','The Real Estate Service','','','29.201302','-96.267203','35','77437','2','210000.00','Active','Market','404','Street','El Campo','2','0','2','1212','Single-Family','This very well maintained home is definitely move in ready. Brick, 2 bedrooms, 2 baths, 2 car garage with nicely landscaped yard, nice storage shed and fenced back yard. Recently replaced roof, hot water heater and central air & heat system are a plus. The nice designer paint colors are very inviting. Granite, carpet & laminate flooring, window coverings, new kitchen cabinetry and appliances (refrigerator, range, dishwasher, wash machine & dryer) remain. Nice master suite with great closet space, shower & vanity area. Huge guest bedroom that could easily be transformed into a third bed room if needed. Guest bath has tub/shower combo. Wonderful neighborhood.','0.1168','55','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','','Central Electric','0','CALHOUN PARK LOT 12','Subdivision Lot','5088','Appraisal District','','','0','','2','','0','','','Electric Range','','Composition','198 - El Campo','','EL CAMPO HIGH SCHOOL','EL CAMPO MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card','Appraisal District','1','Traditional','Calhoun Park','3915','2.3981','Public Sewer,Public Water','2001','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','215015393','1669641784','215015393','2022-11-23T19:12:05.620','36079469','Eufracio Molina','RE/MAX RESULTS','','','29.826385','-95.386117','40','77022','7','549018.00','Active','Rogers','4215','Street','Houston','2','1','3','','Single-Family','Modern New Construction, By Quality Builders Group, LLC, centrally located in The Fabulously up and coming Independence Heights! Approximate completion date, May 2023. This Contemporary design boasts two wonderfully designed floors with downstairs living, 3 bedroom 2.5 baths. This home features high end finishes, high ceilings, quartz counters, island kitchen, and balconies off of each bedroom. The exterior features a back patio, a fenced back yard and a double wide driveway. Conveniently located minutes from Downtown, The Texas Medical Center, and Galleria Area. Easy access to the North Fwy and the North Loop. Close to some of Houston\'s great Restaurants, Bars, Shopping and Schools. Schedule your tour today!','0.0574','9','Quality Builders Grp','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','','Northwest Houston','Central Gas','0','LT 1 BLK 1 ROGERS MANOR','Subdivision Lot','2500','Appraisal District','','','1','To Be Built/Under Construction','2','Electric Oven','0','','','Gas Range','','Composition','27 - Houston','KENNEDY ELEMENTARY SCHOOL (HOUSTON)','WASHINGTON HIGH SCHOOL','WILLIAMS MIDDLE SCHOOL','No Appointment Required','','2','Contemporary/Modern','Rogers Manor','2098','2.3307','Public Sewer,Public Water','',''); --> 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','215070403','1669641784','215070403','2022-11-23T19:13:04.850','29540810','Will Puente','SavvyWay Realty, Inc.','','','28.942780','-95.296990','19','77541','5','475000.00','Active','Thunder','414','Road','Surfside Beach','2','0','3','1280','Single-Family','Wonderful Surfside home built in 2019 is turn-key ready to be a short term rental or second home. Just blocks from jetty park, and a short walk to the beach. This home is fresh and modern and has exactly what you need to relax and enjoy the Texas coast.','0.1544','5','','','','','Sellers Disclosure','1','','','Surfside','Central Electric','0','SURFSIDE BLK 553 LOT 11','Ravine','6726','Appraisal District','','','0','','2','','0','','','','','Composition','7 - Brazosport','VELASCO ELEMENTARY SCHOOL','BRAZOSPORT HIGH SCHOOL','FREEPORT INTERMEDIATE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Surfside Townsite','9052','2.333','Public Sewer,Public Water','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','215070616','1669641784','215070616','2022-11-23T20:00:38.837','17931159','Joseph Perez','J Perez Properties','','','29.609709','-95.195413','20','77034','5','279900.00','Active','Plum Dale','10735','Way','Houston','2','1','3','1761','Single-Family','LOWEST IN NEIGHBORHOOD! Located near Ellington Field with access to Hwy 3, Beltway 8 and Interstate 45. Privacy with no backyard neighbors. Walking trail and children’s playground nearby. This well maintained 3 bedroom 2.5 bath comes with many features including intercom system, security cameras, deep freezer, washer, dryer and generator. Tools in garage are included. Never flooded.','0.0865','6','','','Gas Dryer Connections','','Sellers Disclosure','1','','','Southbelt/Ellington','Central Electric','1','LT 24 BLK 2 SOUTHDOWN TRACE SEC 2','Subdivision Lot','3766','Appraisal District','','500','0','','2','Electric Oven','0','','','Gas Range','','Composition','41 - Pasadena','TEAGUE ELEMENTARY SCHOOL (PASADENA)','MEMORIAL HIGH SCHOOL (PASADENA)','BONDY INTERMEDIATE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','2','Traditional','Southdown Trace','5906','3.2463','Water District','2008','Appraisal District'); --> New record created successfully