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` = '2023-01-24T15:41:07.477' ,`MLSNumber` = '33117975' ,`ListAgentFullName` = 'Dana Staples' ,`ListOfficeName` = 'Staples Sotheby\'sInternational' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.792223' ,`Longitude` = '-95.618550' ,`PhotoCount` = '47' ,`PostalCode` = '75803' ,`RoomCount` = '2' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'State Highway 155' ,`StreetNumber` = '2601' ,`StreetSuffix` = '' ,`City` = 'Palestine' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1648' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Highly visible, high traffic count, level triangular lot on corner of State Hwy 155 and FM 315 (Gardner Drive), Palestine, TX. The propertyis across the state highway from a new Family Dollar Store, a new Texas Farm Bureau Insurance Office building and a recently openedMahindra Tractor Store. On about 1.66 acres, with about 420\' of Hwy road frontage, located within city limits at 2601 State Highway 155,Palestine, TX 75801, just 1 mile north of Loop 256 and about 12 miles south of Frankston, TX. Two buildings on the property are in needof total rehab or demolition. Property has potential to operate 1, 2 or 3 commercial concerns. Must see for all potential. In addition, theadjoining lot of 4.666 acres is available in a separate listing as 1230 FM 315. Buildings on lot are not in good condition.' ,`Acres` = '1.66' ,`Area` = '75' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Palestine Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'NORWOOD HEIGHTS (CITY) BLOCK 2 LOT A' ,`LotDesciption` = 'Corner' ,`LotSize` = '72310' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '71 - Palestine' ,`SchoolElementary` = 'SOUTHSIDE PRIMARY SCHOOL' ,`SchoolHigh` = 'PALESTINE HIGH SCHOOL' ,`SchoolMiddle` = 'PALESTINE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Norwood Heights City' ,`TaxAmount` = '2691' ,`TaxRate` = '2.7504' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675224540' WHERE `Matrix_Unique_ID` = '194609378' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T16:18:53.857' ,`MLSNumber` = '21915970' ,`ListAgentFullName` = 'Georganna Zaba' ,`ListOfficeName` = 'Keller Williams Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.535943' ,`Longitude` = '-98.399128' ,`PhotoCount` = '25' ,`PostalCode` = '78657' ,`RoomCount` = '7' ,`ListPrice` = '1200000.00' ,`Status` = 'Active' ,`StreetName` = 'Blue Ground' ,`StreetNumber` = '311' ,`StreetSuffix` = '' ,`City` = 'Horseshoe Bay' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2854' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Custom Ram Rock golf course home with views of the #11 green and #12 tee box. One of the prettiest golf course settings in Horseshoe Bay! Heated swimming pool and hot tub, built-in poolside gas grill, spacious covered patio and wrought iron fence with stone columns around the beautifully landscaped backyard. This single story, 4-bedroom golf course home with granite island kitchen, breakfast bar, wet bar with ice maker, 2 dining areas, and 3-car garage was remodeled in 2011 by Bob Rowan. The swimming pool and hot tub were added in 2012. Anderson Renewal windows were installed in 2020. The electric range and microwave were replaced in 2020 and 2021.Terrific location on Blue Ground, a popular street in Horseshoe Bay West with easy access to W FM 2147, Horseshoe Bay Resort\'s award-winning Ram Rock and Apple Rock golf courses, and recently opened Cap Rock Restaurant.' ,`Acres` = '0.311' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Heat Pump,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'HORSESHOE BAY WEST LT W1034' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,On Golf Course,Subdivision Lot,Wooded' ,`LotSize` = '13549' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '695' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '183 - Llano' ,`SchoolElementary` = 'LLANO ELEMENTARY' ,`SchoolHigh` = 'LLANO HIGH SCHOOL' ,`SchoolMiddle` = 'LLANO JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Photos/No Videos,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Horseshoe Bay West' ,`TaxAmount` = '6898' ,`TaxRate` = '1.6137' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675224540' WHERE `Matrix_Unique_ID` = '198684510' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T15:42:08.640' ,`MLSNumber` = '51296016' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.222032' ,`Longitude` = '-95.749825' ,`PhotoCount` = '27' ,`PostalCode` = '77354' ,`RoomCount` = '12' ,`ListPrice` = '599664.00' ,`Status` = 'Active' ,`StreetName` = 'Black Bronco' ,`StreetNumber` = '548' ,`StreetSuffix` = 'Road' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2817' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy your own slice of paradise in this Beazer Home on an oversized lot in the desirable Timber Hollow, boasting a stone elevation, a 3-car side load garage with additonal single-car detached garage, a study, an open great room, a mud set shower in the primary suites, and an extended covered patio. Residents of Timber Hollow enjoy a 9-acre lake, rolling hills, and walking trails. Commuters enjoy the ease of access to HWY 249 and the Grand Parkway. Schools are zoned to the Magnolia ISD. You don’t want to miss this home – call today!' ,`Acres` = '0.5' ,`Area` = '15' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 15 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '4' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'WILLIE E. WILLIAMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Timber Hollow' ,`TaxAmount` = '' ,`TaxRate` = '3.36' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675224540' WHERE `Matrix_Unique_ID` = '205406781' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T16:18:17.743' ,`MLSNumber` = '57668630' ,`ListAgentFullName` = 'Randall Martin' ,`ListOfficeName` = 'CB&A, Realtors- Southeast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.566857' ,`Longitude` = '-95.333007' ,`PhotoCount` = '44' ,`PostalCode` = '77581' ,`RoomCount` = '12' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Reid' ,`StreetNumber` = '2341' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1976' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '\"Country in the city\" is calling all you city slickers! If you\'ve been tirelessly hunting for a home w/ guest questers, this would be ideal. Sale includes main home, mobile home & 3 storage buildings sitting on about 2.48 acres in Pearland. Adjacent 4+ acres currently owned by city. This property has so much potential...it would a great opportunity for you to have horses, create rental income, and/or build your custom home in a private location back off of the main road. There is even a RV pad w/ electric hook-up. Roof on the main home was replaced a few years ago & both home & mobile have updated PEX water pipes thanks to the infamous ice storm. Seller says flood water never entered into the main home, nor into the mobile home. Home measurements & square footages listed include main home + mobile. Seller does not have a survey. Buyers are encouraged to verify all information including but not limited to specific uses, restrictions, utility availability, measurements & property lines.' ,`Acres` = '2.4808' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0234 H T & B R R TRACT 26 ACRES 2.4808' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '108064' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'LAWHON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GLENDA DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH WEST' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'H T & B R R' ,`TaxAmount` = '3243' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675224541' WHERE `Matrix_Unique_ID` = '205956865' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T15:34:53.897' ,`MLSNumber` = '84351034' ,`ListAgentFullName` = 'Kate Myhan' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '6.100832' ,`Longitude` = '-75.418329' ,`PhotoCount` = '6' ,`PostalCode` = '00000' ,`RoomCount` = '4' ,`ListPrice` = '4000000.00' ,`Status` = 'Active' ,`StreetName` = 'El Callejon' ,`StreetNumber` = '0' ,`StreetSuffix` = '' ,`City` = 'Other' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1722' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Perfectly located land or site for 62 condominium development project. Located close to Medellin in Columbia in vicinity of the airport. Used to be use used as cow ranch. Right now can be used to grow cannabis or development .\r\n15 minutes from the airport , 40 minutes from center of Medellin.' ,`Acres` = '' ,`Area` = '' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'M.I. 001-70598,M.I. 001-70599,M.I. 001-70600,M.I001-26302' ,`LotDesciption` = 'Other,Wooded' ,`LotSize` = '2281949' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '' ,`SchoolElementary` = '' ,`SchoolHigh` = '' ,`SchoolMiddle` = '' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Tierra Alta' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675224541' WHERE `Matrix_Unique_ID` = '206222112' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T15:40:40.830' ,`MLSNumber` = '36978601' ,`ListAgentFullName` = 'Dana Staples' ,`ListOfficeName` = 'Staples Sotheby\'sInternational' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.770928' ,`Longitude` = '-95.626040' ,`PhotoCount` = '48' ,`PostalCode` = '75801' ,`RoomCount` = '8' ,`ListPrice` = '899000.00' ,`Status` = 'Active' ,`StreetName` = 'Hodges' ,`StreetNumber` = '601' ,`StreetSuffix` = 'Street' ,`City` = 'Palestine' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '6244' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'An impeccable example of the grandeur of historical homes of the South is now for sale in historic Palestine Texas! . A generous wrap around porch, massive classical columns and a two\r\nstory pedimented portico grace the Greek Revival style home, with equally significant interior features. Upon entering you will be amazed by the beauty of the grand entry hall with carved staircase, extensive solid wood crown molding, soaring coffered ceilings, wood floors, elegant light fixtures, leaded glass transoms, and floor to ceiling windows. With 7 bedrooms and 3.5 baths plus 3 living areas, a dining area that welcomes dining tables seating 12 +, a large kitchen breakfast area, 3 wood burning fireplaces and so much more, this home has the craftsmanship and quality of materials that are no longer available for new homes. This majestic estate is located on 3.22 wooded and landscaped acres in the hills and trees of East\r\nTexas.' ,`Acres` = '3.2' ,`Area` = '75' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '4' ,`GeoMarketArea` = 'Palestine Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'A0065 Wells Samuel G, Block 867 Tract 6' ,`LotDesciption` = 'Corner' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '71 - Palestine' ,`SchoolElementary` = 'SOUTHSIDE PRIMARY SCHOOL' ,`SchoolHigh` = 'PALESTINE HIGH SCHOOL' ,`SchoolMiddle` = 'PALESTINE MIDDLE SCHOOL' ,`ShowInstructions` = 'Controlled Access' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'City of Palestine' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1911' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675224541' WHERE `Matrix_Unique_ID` = '208828726' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T15:44:47.193' ,`MLSNumber` = '13944209' ,`ListAgentFullName` = 'Ronald Wickes' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '32.316407' ,`Longitude` = '-96.150952' ,`PhotoCount` = '27' ,`PostalCode` = '75156' ,`RoomCount` = '5' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Legendary' ,`StreetNumber` = '610' ,`StreetSuffix` = 'Lane' ,`City` = 'Gun Barrel City' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Waterfront, Cedar Creek Reservoir!! Boat slip, boatlift, metal bulkhead. Bring your visualization skills and your dreams and make it happen. Cedar Creek Reservoir is the 8th largest reservoir in Texas. It has a surface area of almost 33,000 acres, that\'s over 50 square miles of water surface. And it is over 18 miles long. Fish in the lake include white bass, blue catfish, largemouth bass, channel catfish and flathead catfish. Sounds like dinner! Big city convenience combined with Texas lake country living. This can be the perfect weekend retreat. Fun is waiting for you!! Estate owned. Executor/heirs know nothing about the property. AS-IS sale.' ,`Acres` = '0.216' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ACRES: 0.216 LOT: TRODE SUR AB 696 H M STRODE SUR TR 2C (RE:' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '9409' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '703 - Mabank' ,`SchoolElementary` = 'SOUTHSIDE ELEMENTARY' ,`SchoolHigh` = 'MABANK HIGH SCHOOL' ,`SchoolMiddle` = 'MABANK JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'none' ,`TaxAmount` = '1835' ,`TaxRate` = '1.7075' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675224541' WHERE `Matrix_Unique_ID` = '209254587' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T16:04:50.310' ,`MLSNumber` = '87758041' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '35.679322' ,`Longitude` = '-101.400373' ,`PhotoCount` = '12' ,`PostalCode` = '79007' ,`RoomCount` = '3' ,`ListPrice` = '91777.00' ,`Status` = 'Active' ,`StreetName` = 'Nelson' ,`StreetNumber` = '917' ,`StreetSuffix` = 'Street' ,`City` = 'Borger' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '992' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic 3 bed 1 bath home available in Borger, TX. This single-family home is nestled in a great location near Hutchinson County Airport and features a nice sized living room, great kitchen, covered back patio area, large backyard, and an attached one-car garage. It will also feature a couple of upgrades including new interior/exterior paint, light fixtures, and other minor cosmetic repairs throughout. Here you will have quick and easy access to all the main roads like HWY 136, 152, and 207. Give us a call today for more information!' ,`Acres` = '0.1832' ,`Area` = '87' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = '31 BLK 17 GATEWAY HTS' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7980' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '357 - Borger' ,`SchoolElementary` = 'PAUL BELTON EARLY CHILDHOOD CENTER' ,`SchoolHigh` = 'BORGER HIGH SCHOOL' ,`SchoolMiddle` = 'BORGER MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gateway Heights' ,`TaxAmount` = '767' ,`TaxRate` = '3.0714' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '0' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675224542' WHERE `Matrix_Unique_ID` = '209268944' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T15:49:05.650' ,`MLSNumber` = '9388069' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '34.145688' ,`Longitude` = '-99.280670' ,`PhotoCount` = '6' ,`PostalCode` = '76384' ,`RoomCount` = '2' ,`ListPrice` = '38999.00' ,`Status` = 'Active' ,`StreetName` = 'Bowie' ,`StreetNumber` = '2517' ,`StreetSuffix` = 'Street' ,`City` = 'Vernon' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1174' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Easy access to HWY 183 and HWY 287. A cute home in a quiet neighborhood right next Sunshine Park and only a few minutes away from Vernon College Student Center. AS IS' ,`Acres` = '0.1653' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'N/2 OF THE SW/4 BLK 55 SOUTH ADDITION VERNON' ,`LotDesciption` = 'Other' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1004 - Vernon' ,`SchoolElementary` = 'SHIVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'VERNON HIGH SCHOOL' ,`SchoolMiddle` = 'VERNON MIDDLE SCHOOL (VERNON)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'South Add' ,`TaxAmount` = '487' ,`TaxRate` = '2.6223' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675224542' WHERE `Matrix_Unique_ID` = '209300749' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T15:35:25.063' ,`MLSNumber` = '60296712' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.220568' ,`Longitude` = '-95.752055' ,`PhotoCount` = '9' ,`PostalCode` = '77354' ,`RoomCount` = '12' ,`ListPrice` = '515945.00' ,`Status` = 'Active' ,`StreetName` = 'Black Bronco' ,`StreetNumber` = '539' ,`StreetSuffix` = 'Road' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2505' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction** Feel at ease in this stunning Beazer Home in Timber Hollow, boasting tile flooring, a study with French doors, an open great room, a mud set shower in the primary suite, and an extended covered patio. Prepare incredible feasts in the kitchen, equipped with quartz countertops, mosaic backsplash, 30” cooktop, stainless steel appliances, pendant lighting, and under-counter lighting. Residents of the 68-acre Timber Hollow community enjoy many amenities, including a 9-acre lake, rolling hills, and walking trails. Commuters can easily access central Magnolia via Highway 249 and the Grand Parkway. Zoned to the Magnolia ISD. You don’t want to miss this home – call today!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4 Block 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'WILLIE E. WILLIAMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Timber Hollow' ,`TaxAmount` = '' ,`TaxRate` = '3.36' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675224542' WHERE `Matrix_Unique_ID` = '209332506' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T15:20:46.763' ,`MLSNumber` = '85079682' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = 'Robert (Bob) Murdock' ,`SellingOfficeName` = 'Bernstein Realty, Inc.' ,`Latitude` = '29.941985' ,`Longitude` = '-95.203328' ,`PhotoCount` = '36' ,`PostalCode` = '77346' ,`RoomCount` = '12' ,`ListPrice` = '439995.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Westburn Loch' ,`StreetNumber` = '15215' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2543' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ready to move-in! Located in the desirable Balmoral community, this two-story Ashville home features brick with stone accents, 4 bedrooms, 3 baths and 2 car garage. Beautiful maple cabinets, under cabinet lighting and quartz countertops with low bar top in kitchen. Cozy tile fireplace with Craftsman mantel and crown molding in great room. Two bedrooms, including the owner\'s suite, located downstairs. Huge walk-in closet, separate tub and shower in owner\'s bath. Double sinks in owner\'s bath and hall bath 2. Upstairs, you\'ll find a versatile loft space and two secondary bedrooms, plus a convenient built-in desk in hall 3. Covered patio in backyard, perfect for entertaining. This home is a must see!\r\nEnjoy all the amenities that Balmoral has to offer, such as a lagoon, pool, playground, sand volleyball, putt-putt golf, fitness center and bar & grill. Offered by: K. Hovnanian of Houston II, LLC.' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'K. Hovnanian Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = '14/4/23' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'RIDGE CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Balmoral' ,`TaxAmount` = '' ,`TaxRate` = '2.987' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675224542' WHERE `Matrix_Unique_ID` = '209534096' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T16:26:03.640' ,`MLSNumber` = '80656140' ,`ListAgentFullName` = 'Jonathan McNabb' ,`ListOfficeName` = 'Nest Ahead' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.830903' ,`Longitude` = '-95.190298' ,`PhotoCount` = '9' ,`PostalCode` = '77049' ,`RoomCount` = '4' ,`ListPrice` = '283990.00' ,`Status` = 'Active' ,`StreetName` = 'Evitale' ,`StreetNumber` = '7223' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1598' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Moonbeam is the ideal home for first time homebuyers. It is a single story 3 bedroom, 2 bath floorplan with an open family room, dining and kitchen area. The kitchen offers a large island. This home also features a spacious covered patio, a covered porch, and a 2-car garage. Schedule a visit today to learn how you can make this home yours! The photos are stock photos, and do not represent the exact home.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Starlight Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Imperial Forest Section 4 Block 2 Lot 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'ROYALWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'C.E. KING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Forest' ,`TaxAmount` = '' ,`TaxRate` = '3.6051' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675224543' WHERE `Matrix_Unique_ID` = '209796374' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T16:11:04.730' ,`MLSNumber` = '73544105' ,`ListAgentFullName` = 'Sean Moncada' ,`ListOfficeName` = 'Las Lomas Realty Elite' ,`SellingAgentFullName` = 'Herbert Anderson' ,`SellingOfficeName` = 'Realty Associates' ,`Latitude` = '30.347184' ,`Longitude` = '-95.167299' ,`PhotoCount` = '27' ,`PostalCode` = '77328' ,`RoomCount` = '3' ,`ListPrice` = '229990.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Trails End' ,`StreetNumber` = '50' ,`StreetSuffix` = 'Drive' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1190' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '.75 acres (3/4) Fully Renovated. Country Living. No Restrictions.' ,`Acres` = '0.75' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Coldspring/South San Jacinto County' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRAILS END #1, BLOCK 6, LOT 31, ACRES .75' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '32800' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'NORTHSIDE ELEMENTARY SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Trails End #1' ,`TaxAmount` = '1491' ,`TaxRate` = '1.9249' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675224543' WHERE `Matrix_Unique_ID` = '210318375' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T16:25:47.697' ,`MLSNumber` = '4172451' ,`ListAgentFullName` = 'Jonathan McNabb' ,`ListOfficeName` = 'Nest Ahead' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.831058' ,`Longitude` = '-95.190438' ,`PhotoCount` = '9' ,`PostalCode` = '77049' ,`RoomCount` = '5' ,`ListPrice` = '293990.00' ,`Status` = 'Active' ,`StreetName` = 'Wembley Heights' ,`StreetNumber` = '13407' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1847' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The one-story 4 bedroom and 3 bathroom Prism plan is the ideal home for a family. In this home, you will enjoy a spacious kitchen, dining and family room area. The kitchen features brand new stainless steel appliances, granite countertops, large island and upgraded cabinets. The photos are stock photos, and do not represent the exact home.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Starlight Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Imperial Forest Section 4 Block 4 Lot 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'ROYALWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'C.E. KING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Forest' ,`TaxAmount` = '' ,`TaxRate` = '3.6051' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675224543' WHERE `Matrix_Unique_ID` = '210328126' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T15:34:51.667' ,`MLSNumber` = '11152043' ,`ListAgentFullName` = 'Jim Fredricks' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.255464' ,`Longitude` = '-95.435711' ,`PhotoCount` = '47' ,`PostalCode` = '77302' ,`RoomCount` = '9' ,`ListPrice` = '419000.00' ,`Status` = 'Active' ,`StreetName` = 'Stonewall Jackson' ,`StreetNumber` = '681' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '3321' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BACK ON THE MARKET! This beautiful Colonial-style home in River Plantation subdivision has been thoroughly updated with gorgeous finishes throughout, from the rich wood floors to lovely granite counters, stainless steel appliances and a stunning primary bedroom and bathroom downstairs. This home was made for entertaining and provides generous spaces for your family and guests. There is a screened in patio downstairs and another porch upstairs connected to one of the bedrooms that could also be an office. In addition to the five spacious bedrooms there is a separate quarters outside suitable for your at-home office. The subdivision has an 18-hole golf course, pool, tennis and basketball courts, and playgrounds and is just across the highway from the new Grand Central Park master planned community and numerous shopping and dining opportunities. Never flooded! Numerous recent updates, including new roof, paint, new dishwasher, light fixtures, new wood floors, and new sprinkler system!' ,`Acres` = '0.3501' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RIVER PLANTATION 08, LOT 255' ,`LotDesciption` = 'In Golf Course Community' ,`LotSize` = '15251' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '275' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'River Plantation 08' ,`TaxAmount` = '4657' ,`TaxRate` = '2.3888' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675224543' WHERE `Matrix_Unique_ID` = '210544614' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T16:19:30.577' ,`MLSNumber` = '57415353' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.038145' ,`Longitude` = '-95.705902' ,`PhotoCount` = '9' ,`PostalCode` = '77480' ,`RoomCount` = '3' ,`ListPrice` = '139999.00' ,`Status` = 'Active' ,`StreetName` = '6th' ,`StreetNumber` = '609' ,`StreetSuffix` = 'Street' ,`City` = 'Sweeny' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1008' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 3 bed 1 bath single-family home available in Sweeny, TX. The property sits on an oversized corner lot and was originally built as a 2 bed/1 bath home; however, the garage has been converted into an additional living area or bedroom. It features ceramic tile flooring throughout the main areas, carpet in the bedrooms, a beautifully updated kitchen, and large backyard. It does come equipped with some upgrades including new interior/exterior paint, a brand-new roof, foundation repairs, electrical fixes, and other minor cosmetic repairs throughout. Here you will have easy access to TX-35 and be near plenty of shops, markets, eateries, and local parks. Contact us today for more information! NO A/C.' ,`Acres` = '0.1148' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'SWEENY BLK 12 LOT 15' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5001' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '51 - Sweeny' ,`SchoolElementary` = 'SWEENY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SWEENY HIGH SCHOOL' ,`SchoolMiddle` = 'SWEENY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sweeny' ,`TaxAmount` = '1137' ,`TaxRate` = '2.8427' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675224543' WHERE `Matrix_Unique_ID` = '210637825' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T16:27:25.693' ,`MLSNumber` = '30526473' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Sarah Hanif' ,`SellingOfficeName` = 'Nextgen Real Estate Properties' ,`Latitude` = '29.680791' ,`Longitude` = '-95.833601' ,`PhotoCount` = '36' ,`PostalCode` = '77406' ,`RoomCount` = '16' ,`ListPrice` = '639963.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Lyra Glen' ,`StreetNumber` = '10514' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3640' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Carter LVL, Elevation M) CURRENTLY BEING BUILT. Two story. 4 bedrooms. 3.5 baths. Family room, formal dining room and study. Spacious island kitchen open to family room. Primary suite with large double walk-in closets and secondary bedroom on first floor. Two additional bedrooms, spacious game room and media room on second floor. Covered rear patio and attached 2-car garage. Candela offers new homes for sale in Richmond, Texas. The community is the perfect combination of small-town charm and easy access to big city conveniences. Take a stroll through Downtown Historic Richmond, visit the Imperial Farmer\'s Market and enjoy the great outdoors at Brazos Bend State Park. Major employers in Houston, Katy and Sugar Land are only a short commute away. Great restaurants, and local and big box retail offerings are all close by. Visit Candela today to find your new home!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 38 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8467' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BENTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Candela' ,`TaxAmount` = '' ,`TaxRate` = '3.15' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675224544' WHERE `Matrix_Unique_ID` = '210735313' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T16:25:28.090' ,`MLSNumber` = '14890217' ,`ListAgentFullName` = 'Wanda Simons' ,`ListOfficeName` = 'RE/MAX Associates Northeast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.997056' ,`Longitude` = '-95.263899' ,`PhotoCount` = '45' ,`PostalCode` = '77338' ,`RoomCount` = '11' ,`ListPrice` = '520000.00' ,`Status` = 'Active' ,`StreetName` = 'Granberry' ,`StreetNumber` = '301' ,`StreetSuffix` = 'Street' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '4438' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic opportunity to own a piece of history located in the heart of Uptown Humble! This completely renovated 1925 Historic home with a hint of European influence in its design has maintained its charm while at the same time displaying elegant contemporary accents and finishes. This home is an absolute gem with tons of livable square footage that includes an apartment equipped with full kitchen above the oversized garage (could be counted as a 4th bedroom), an enormous multi-purpose game room downstairs, and TWO sunrooms! According to the city of Humble, it can also be used for commercial purposes. Whether it is used for a personal living space or creative commercial venture, this home has a beautiful, welcoming atmosphere with many +++\'s! It is one you will definitely want to see for yourself.' ,`Acres` = '0.1515' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Humble Area East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 & TRS 11A-1 & 11B BLK 8 HUMBLE' ,`LotDesciption` = 'Corner' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'HUMBLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'ROSS STERLING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'French' ,`Subdivision` = 'Town/Humble Rev Map' ,`TaxAmount` = '7072' ,`TaxRate` = '2.2965' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1925' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675224544' WHERE `Matrix_Unique_ID` = '210858262' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T16:13:37.107' ,`MLSNumber` = '77019490' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Tucker May' ,`SellingOfficeName` = 'Keller Williams Metropolitan' ,`Latitude` = '29.402576' ,`Longitude` = '-95.070860' ,`PhotoCount` = '30' ,`PostalCode` = '77568' ,`RoomCount` = '16' ,`ListPrice` = '499232.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Bellano Bay' ,`StreetNumber` = '2225' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3136' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Albany, Elevation G) CURRENTLY BEING BUILT. Two story. 4 bedrooms. 3.5 baths. Family room, study and formal dining room. Spacious island kitchen open to family room. Primary suite with large walk-in closet. Three additional bedrooms, spacious game room and media room on second floor. Covered patio and attached 2-car garage. Representing a prime location off I-45 South in the Galveston-Clear Lake corridor, you’ll find Lago Mar and its resort style living! Bay Area breezes will caress you while you lounge on white-sand beaches, swim in Caribbean-blue waters or dine lagoon-side on our beach boardwalk. Lago Mar includes 2 private resident gyms, 2 resident pools, playgrounds and acres of outdoor space. It’s an unparalleled standard of living where life is truly a breeze! Stop by the Westin Homes model home today to find out more about Lago Mar!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 4 BLK 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1404' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.47' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675224544' WHERE `Matrix_Unique_ID` = '211231185' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T15:25:57.600' ,`MLSNumber` = '97353929' ,`ListAgentFullName` = 'Jessica Reyes' ,`ListOfficeName` = 'Jason Mitchell Real Estate LLC' ,`SellingAgentFullName` = 'Leticia Gomez' ,`SellingOfficeName` = 'REALM Real Estate Professional' ,`Latitude` = '29.495191' ,`Longitude` = '-95.770637' ,`PhotoCount` = '24' ,`PostalCode` = '77469' ,`RoomCount` = '3' ,`ListPrice` = '243000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Atwood Preserve' ,`StreetNumber` = '6927' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1366' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This delightful 3-bedroom, 2-bathroom Traditional is a great starter home within the Richmond/Rosenberg area. Perfect for first time buyers! The home is easily driveable to shopping and restaurants. The primary bedroom includes a walk-in closet and private bath. Energy Efficient windows through out the home. Attached two-car garage. The inviting patio and large Texas size backyard is perfect for socializing. Your future self will thank you for acting fast on this one!' ,`Acres` = '0.181' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SUNRISE MEADOW SEC 7, BLOCK 1, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7886' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '330' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MEYER ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunrise Meadow Sec 7' ,`TaxAmount` = '4815' ,`TaxRate` = '2.8148' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675224544' WHERE `Matrix_Unique_ID` = '211233318' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T16:25:13.550' ,`MLSNumber` = '76171340' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Denny Nguyen' ,`SellingOfficeName` = 'MDK Realty Associates' ,`Latitude` = '29.842080' ,`Longitude` = '-95.861710' ,`PhotoCount` = '26' ,`PostalCode` = '77493' ,`RoomCount` = '16' ,`ListPrice` = '559452.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Bahia Bay' ,`StreetNumber` = '812' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3136' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Albany, Elevation GL) CURRENLTY BEING BUILT. Two story. 4 bedrooms. 3.5 baths. Family room, study and formal dining room. Spacious island kitchen open to family room. Primary suite with large walk-in closet. Three additional bedrooms, spacious game room and media room on second floor. Covered patio and attached 2-car garage. Located a few miles north of Interstate 10 and west of the Grand Parkway in thriving Katy, Sunterra is an inviting 1,039-acre master-planned community featuring home designs that fit your lifestyle, Sunterra is a launch pad for family adventures. Splash, play, paddleboard, build sandcastles and more at our gorgeous Crystal Lagoons® amenity. Designed to fit your lifestyle, the master plan calls for approximately 2,200 homes, lakes, parks, playgrounds and an expansive Amenity Village with a clubhouse and a pool overlooking the lagoon. Stop by the Westin Homes sales model to learn more about Sunterra!' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 9 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7267' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.53' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675224545' WHERE `Matrix_Unique_ID` = '211233487' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T15:45:19.703' ,`MLSNumber` = '53021949' ,`ListAgentFullName` = 'Jill Navarro' ,`ListOfficeName` = 'Navarro Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.261373' ,`Longitude` = '-94.642160' ,`PhotoCount` = '44' ,`PostalCode` = '75901' ,`RoomCount` = '3' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Loving' ,`StreetNumber` = '317' ,`StreetSuffix` = 'Road' ,`City` = 'Lufkin' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '3054' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Room to roam. This gorgeous home sits on 5 incredible acres. Fenced, barn, stables, small pond, and small pine thicket offer everything you need for peaceful country convenience. A hop & skip to both Lufkin and Huntington makes this a fantastic location. Shelf lined office is the perfect getaway for the avid reader or home office space. The upstairs bonus room is large and would be excellent for a game room or theater. The spacious primary bedroom offers 2 walk-in closets while the bath affords garden tub and separate shower. Fresh paint throughout. Granite Counter tops. Island Kitchen' ,`Acres` = '5' ,`Area` = '45' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Angelina County' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '0' ,`Legal` = 'ABS 0575 SPENCER HENRY,TRACT 24.2,ACRES 5.0' ,`LotDesciption` = 'Cleared' ,`LotSize` = '217800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '186 - Lufkin' ,`SchoolElementary` = 'SLACK ELEMENTARY' ,`SchoolHigh` = 'LUFKIN HIGH SCHOOL' ,`SchoolMiddle` = 'LUFKIN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Henry Spencer Surv Abs #575' ,`TaxAmount` = '6285' ,`TaxRate` = '1.8544' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675224545' WHERE `Matrix_Unique_ID` = '211381856' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T15:40:09.943' ,`MLSNumber` = '73802161' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.366464' ,`Longitude` = '-95.489303' ,`PhotoCount` = '8' ,`PostalCode` = '77304' ,`RoomCount` = '9' ,`ListPrice` = '688671.00' ,`Status` = 'Active' ,`StreetName` = 'Divino' ,`StreetNumber` = '1707' ,`StreetSuffix` = 'Pass' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3078' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 73802161 - Built by Toll Brothers, Inc. - April completion! ~ The Indio Transitional comes complete with top-tier design features in a desirable location, this is the home you have always dreamed of. The open-concept great room is the perfect atmosphere for entertaining, with connectivity to the dining area and expansive views of the outdoor living space. A private office with sloped ceilings and double-glass door entry is ideal for working from home. Spacious secondary bedrooms make room for friends and family. The media room is ready for movie nights and popcorn. The stunning kitchen with casual dining area and deep walk-in pantry are ready to host a house full. Find respite in the primary bedroom with dramatic sloped ceiling and luxurious bath with walk-in closet. Call today to schedule your appointment to view this amazing home.' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S922790 - Teaswood Avenue, BLOCK 1, Lot 8' ,`LotDesciption` = 'Cleared,Other,Subdivision Lot' ,`LotSize` = '9509' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'LAGWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Teaswood Avenue' ,`TaxAmount` = '' ,`TaxRate` = '2.18' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675224545' WHERE `Matrix_Unique_ID` = '211462144' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T16:52:17.167' ,`MLSNumber` = '15307886' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '29.656889' ,`Longitude` = '-95.117845' ,`PhotoCount` = '30' ,`PostalCode` = '77505' ,`RoomCount` = '16' ,`ListPrice` = '599990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Fairfield' ,`StreetNumber` = '5510' ,`StreetSuffix` = 'Lane' ,`City` = 'Pasadena' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3386' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming two-story Arthur home with 4 bedrooms, 3.5 baths and 3 car attached garage with storage. Convenient home office with French doors tucked off foyer. Open dining room with easy access to gourmet kitchen. Beautiful maple cabinets, quartz countertops and farmhouse sink in gourmet kitchen. Cozy tile fireplace with Craftsman mantel in great room. Dual vanity sinks, separate tub and shower in owner\'s bath. Versatile loft space and serene media room located upstairs. All bedrooms feature walk-in closets. Covered patio in backyard, perfect for entertaining. Offered by: K. Hovnanian Houston Parkway Trails, LLC.' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'K. Hovnanian' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '21/2/4' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'JP DABBS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRMONT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkway Trails' ,`TaxAmount` = '' ,`TaxRate` = '2.470865' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675224545' WHERE `Matrix_Unique_ID` = '211468418' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T15:48:39.393' ,`MLSNumber` = '47895470' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.402000' ,`Longitude` = '-95.500000' ,`PhotoCount` = '28' ,`PostalCode` = '77318' ,`RoomCount` = '8' ,`ListPrice` = '507000.00' ,`Status` = 'Active' ,`StreetName` = 'Carina Gaze' ,`StreetNumber` = '550' ,`StreetSuffix` = 'Drive' ,`City` = 'Willis' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2564' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW DAVID WEEKLEY HOME! Delightful livability and superb craftsmanship combine in the remarkable Bynum luxury home plan. Fulfill your interior design ambition with this open floor plan’s sunlit expanse of unforgettable celebration potential. The gourmet kitchen offers a sensational culinary arts studio with a deluxe corner pantry, a full-function island, and extended countertops. Unique decorative styles and blossoming personalities will find wonderful places to grow in the spare bedrooms and private suite. Create a home office, entertainment lounge, or a functional multi-purpose room in the spacious and adaptable enclosed study. Leave the outside world behind and lavish in the everyday elegance of your Owner’s Retreat, featuring a superb en suite bathroom and extensive walk-in closet and super shower. Relax into your leisurely evenings on the breezy comfort of your large outdoor living space. Come see this beautiful home with no back neighbor in The Woodlands Hills today!' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 03 Block 01' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8008' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'The Woodlands Hills' ,`TaxAmount` = '' ,`TaxRate` = '3.22' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675224546' WHERE `Matrix_Unique_ID` = '211471572' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T15:09:19.807' ,`MLSNumber` = '71073932' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.828741' ,`Longitude` = '-94.990996' ,`PhotoCount` = '11' ,`PostalCode` = '77521' ,`RoomCount` = '8' ,`ListPrice` = '319950.00' ,`Status` = 'Active' ,`StreetName` = 'Wildflower' ,`StreetNumber` = '4454' ,`StreetSuffix` = 'Way' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2032' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Create lifelong memories in this gorgeous Beazer Home in the Southwinds community, which boasts a brick exterior, sloped ceilings, open great room, and an extended covered patio. No recipe is a challenge in the island kitchen, fully equipped with a walk-in pantry, stainless steel appliances, and a dining nook. Unwind in the serene primary suite, featuring a walk-in closet, dual vanities, a tub, and separate shower. With direct access to the Grand Parkway and I-10, commuters from Southwinds love the easy drive to Downtown Houston and other major business areas. A variety of popular restaurants, shops, and beaches are only a short distance away. Community comforts include a pool, recreation center, playground, and picnic area. Zoned to Goose Creek CISD. This could be your dream home – call now!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 5 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'PUMPHREY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ashbel Cove' ,`TaxAmount` = '' ,`TaxRate` = '3.545293' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675224546' WHERE `Matrix_Unique_ID` = '211484633' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T15:37:49.390' ,`MLSNumber` = '2993801' ,`ListAgentFullName` = 'Stanley Mani' ,`ListOfficeName` = 'MIH REALTY, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.353667' ,`Longitude` = '-95.507635' ,`PhotoCount` = '50' ,`PostalCode` = '77583' ,`RoomCount` = '12' ,`ListPrice` = '688888.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 1462' ,`StreetNumber` = '2806' ,`StreetSuffix` = '' ,`City` = 'Rosharon' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '4694' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COUNTRY LIVING that\'s been Fully renovated with modern upgrades & a touch of elegance! This 4bed/4full bath home is nestled on close to 3 acres that offer comfort and cozy scenic views. The home\'s first floor is equipped with all the bedrooms/ 3 full baths downstairs, 2-car attached garage, Living, formal dining, kitchen with breakfast nook, office or study. Th second level has the gameroom with wet bar, full bath and a media room. The large open kitchen boasts stainless steel appliances, an island with cooktop & seating space as a breakfast bar, and an ample amount of counter/cabinet space. Enjoy the many Covered porches/balconies or relax on the sun deck with your favorite book. There\'s also a covered gazebo on the property great for picnics, gatherings or just to hang out and hide from the sun! Great location- not too tucked away- Only a 35-minute drive to the Galleria or Medical Center. Zoned to great schools, claim this home as yours today!!!' ,`Acres` = '2.91' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Rosharon' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'A0125 A ROBINSON TRACT 15B-15C4 ACRES 2.91' ,`LotDesciption` = 'Other' ,`LotSize` = '126760' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'FRONTIER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'A Robinson' ,`TaxAmount` = '5653' ,`TaxRate` = '1.986' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675224546' WHERE `Matrix_Unique_ID` = '211515319' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T16:59:04.830' ,`MLSNumber` = '70820513' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Sandra Lewis' ,`SellingOfficeName` = 'Walzel Properties' ,`Latitude` = '30.168362' ,`Longitude` = '-95.185934' ,`PhotoCount` = '31' ,`PostalCode` = '77357' ,`RoomCount` = '15' ,`ListPrice` = '523627.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Toscana' ,`StreetNumber` = '18908' ,`StreetSuffix` = 'Lane' ,`City` = 'New Caney' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Lexington, Elevation B) CURRENTLY BEING BUILT. Two story. 4 bedrooms. 3.5 baths. Family room, informal dining room, and study. Spacious island kitchen open to Family room. Primary suite with large double walk-in closets. Second bedroom downstairs with private bath. Spacious game room and media room on second floor. Covered patio and 2-car garage. Tavola, northeast Houston\'s newest master-planned community, features amenities such as a recreation center with a pool, park with a unique zip line and clubhouse, pocket parks and miles of wooded greenbelt trails that wind throughout the community. Tavola’s convenient location caters to major employment centers including the Greenspoint Business District and the new ExxonMobil campus. Located seven miles north of Kingwood and just two exits north of the new Grand Parkway, Tavola’s ideal location will easily link this community to any area of Houston. Stop by the Westin Homes home to learn more about Tavola!' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 31 BLK 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6934' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'TAVOLA ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tavola' ,`TaxAmount` = '' ,`TaxRate` = '3.34' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675224546' WHERE `Matrix_Unique_ID` = '211581343' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T15:29:46.367' ,`MLSNumber` = '92359010' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.366602' ,`Longitude` = '-95.489203' ,`PhotoCount` = '8' ,`PostalCode` = '77304' ,`RoomCount` = '11' ,`ListPrice` = '759771.00' ,`Status` = 'Active' ,`StreetName` = 'Divino' ,`StreetNumber` = '1705' ,`StreetSuffix` = 'Pass' ,`City` = 'Conroe' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3766' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 92359010 - Built by Toll Brothers, Inc. - April completion! ~ Now available! The Lansing Transitional home has a welcoming exterior with stucco finish, sleek lines and bronze colored finishes. This beautifully crafted home is filled with well-appointed interior finishes. The pronounced front entry opens to a two-story foyer with grand curved staircase. The gourmet kitchen makes a statement with it\'s premium finishes, upgraded cabinets, and stainless steel appliances. The open-concept kitchen flows effortlessly into the great room and dining area, making this the ideal floor plan for entertaining. A first-floor office provides the space to work from home. Don\'t miss this opportunity. Call today to schedule your appointment.' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S922790 - Teaswood Avenue, BLOCK 1, Lot 7' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '8478' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'LAGWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Teaswood Avenue' ,`TaxAmount` = '' ,`TaxRate` = '2.18' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675224547' WHERE `Matrix_Unique_ID` = '211649261' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T16:17:19.790' ,`MLSNumber` = '20584500' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Gayla Gayden' ,`SellingOfficeName` = 'REALM Real Estate Professional' ,`Latitude` = '29.680148' ,`Longitude` = '-95.833698' ,`PhotoCount` = '40' ,`PostalCode` = '77406' ,`RoomCount` = '18' ,`ListPrice` = '684578.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Lyra Glen' ,`StreetNumber` = '10502' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Carter VI, Elevation KS) CURRENTLY BEING BUILT. Two Story cul-de-sac lot. 5 bedrooms, 4.5 baths. Private Primary Suite with spacious double walk-in closets downstairs. Formal Dining Room and Study with Spacious Kitchen and breakfast area open to Family Room. Spacious Game Room upstairs with private Media Room. Extended covered patio and attached 2 car garage. Candela offers new homes for sale in Richmond, Texas. The community is the perfect combination of small-town charm and easy access to big city conveniences. Take a stroll through Downtown Historic Richmond, visit the Imperial Farmer\'s Market and enjoy the great outdoors at Brazos Bend State Park. Major employers in Houston, Katy and Sugar Land are only a short commute away. Great restaurants, and local and big box retail offerings are all close by. Visit Candela today to find your new home!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 35 BLK 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '12672' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BENTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Candela' ,`TaxAmount` = '' ,`TaxRate` = '3.15' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675224547' WHERE `Matrix_Unique_ID` = '211853291' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T15:36:22.690' ,`MLSNumber` = '91017332' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.222032' ,`Longitude` = '-95.749825' ,`PhotoCount` = '6' ,`PostalCode` = '77354' ,`RoomCount` = '9' ,`ListPrice` = '531098.00' ,`Status` = 'Active' ,`StreetName` = 'Running Iron' ,`StreetNumber` = '624' ,`StreetSuffix` = 'Lane' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2337' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Find total comfort in this amazing Beazer Home in Timber Hollow, boasting a brick exterior, tile flooring, a study, an extended covered patio, and an addtional RV garage. Impress your guests in the kitchen, fully equipped with quartz countertops, mosaic backsplash, large cove molding, 30” cooktop, stainless steel appliances, 42” upper cabinets, and pendant lighting. Residents of the 68-acre Timber Hollow community enjoy many amenities, including a 9-acre lake, rolling hills, and walking trails. Commuters can easily access central Magnolia via Highway 249 and the Grand Parkway. Zoned to Magnolia ISD. You don’t want to miss this home – call today!' ,`Acres` = '0.42' ,`Area` = '15' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9 Block 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '18272' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'WILLIE E. WILLIAMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Timber Hollow' ,`TaxAmount` = '' ,`TaxRate` = '3.36' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675224547' WHERE `Matrix_Unique_ID` = '211943710' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T16:21:34.580' ,`MLSNumber` = '92664497' ,`ListAgentFullName` = 'Jonathan McNabb' ,`ListOfficeName` = 'Nest Ahead' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.346540' ,`Longitude` = '-95.587490' ,`PhotoCount` = '6' ,`PostalCode` = '77316' ,`RoomCount` = '4' ,`ListPrice` = '235990.00' ,`Status` = 'Active' ,`StreetName` = 'Calderon' ,`StreetNumber` = '14810' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1412' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Odyssey is a great place for anyone looking for a 3 bedroom, 2 bath home. The kitchen features brand new stainless steel appliances, granite countertops and a spacious island. There\'s room to spread out with a 2-car garage and a covered patio. The photos are stock photos, and do not represent the exact home.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Starlight Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Chapel Run Section 2 Block 1 Lot 29' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Chapel Run' ,`TaxAmount` = '' ,`TaxRate` = '3.08' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675224547' WHERE `Matrix_Unique_ID` = '211954773' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T16:22:44.900' ,`MLSNumber` = '27654101' ,`ListAgentFullName` = 'Jonathan McNabb' ,`ListOfficeName` = 'Nest Ahead' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.346553' ,`Longitude` = '-95.587622' ,`PhotoCount` = '7' ,`PostalCode` = '77316' ,`RoomCount` = '6' ,`ListPrice` = '277990.00' ,`Status` = 'Active' ,`StreetName` = 'Calderon' ,`StreetNumber` = '14814' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2260' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This two-story plan is ideal for a family looking for lots of space and a place to create new memories. Wake up to brand new stainless steel appliances, granite countertops and open living spaces that look out onto your own private patio. The photos are stock photos, and do not represent the exact home.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Starlight Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Chapel Run Section 2 Block 1 Lot 30' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Chapel Run' ,`TaxAmount` = '' ,`TaxRate` = '3.08' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675224547' WHERE `Matrix_Unique_ID` = '211955322' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T16:22:09.367' ,`MLSNumber` = '39498789' ,`ListAgentFullName` = 'Jonathan McNabb' ,`ListOfficeName` = 'Nest Ahead' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.346544' ,`Longitude` = '-95.587364' ,`PhotoCount` = '8' ,`PostalCode` = '77316' ,`RoomCount` = '5' ,`ListPrice` = '255990.00' ,`Status` = 'Active' ,`StreetName` = 'Calderon' ,`StreetNumber` = '14806' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1826' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Create memories when you step inside your new home that includes modern finishes from top to bottom. Cook family meals in your open kitchen complete with stainless steel appliances, granite countertops and a large island. This two-story home also provides plenty of space with extra loft space and a patio that\'s perfect for entertaining guests. The photos are stock photos, and do not represent the exact home.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Starlight Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Chapel Run Section 2 Block 1 Lot 28' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`