Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T08:50:47.537' ,`MLSNumber` = '89256456' ,`ListAgentFullName` = 'Leon Shapiro' ,`ListOfficeName` = 'RE/MAX Space Center-Clear Lake' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.432883' ,`Longitude` = '-95.143864' ,`PhotoCount` = '37' ,`PostalCode` = '77539' ,`RoomCount` = '13' ,`ListPrice` = '3099944.00' ,`Status` = 'Active' ,`StreetName` = 'Lakeview' ,`StreetNumber` = '418' ,`StreetSuffix` = '' ,`City` = 'Dickinson' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '9409' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CUSTOM ONE STORY MEDITERRANEAN STYLE STUCCO STUNNER WITH HIGH QUALITY OUTSTANDING FINISHES ON 3+ WATERFRONT ACRES! FROM THE GOURMET KITCHEN WITH CHEF\'S PANTRY PLUS APPLIANCE PANTRY AND SEPARATE BUILT-IN REFRIGERATOR AND FREEZER - TO THE HUGE PRIMARY BEDROOM WITH SITTING ROOM, REMOTE CONTROLLED CURTAINS AND DROP DOWN TV - TO THE HUGE PRIMARY BATH WITH MAKE-UP STATIONS, HUGE GLASS BLOCK SHOWER, STEAM ROOM, AND GARDEN BATH WITH FIREPLACE - SEPARATE HIS & HER CLOSETS WITH BUILT-INS, DRY-CLEANING STYLE SPINNER RACKS, AND ONE WITH A STAIRWAY TO MORE SHELVED AREAS - NO DETAIL WAS OVERLOOKED IN BUILDING THIS DREAM HOME! HUGE CIRCULAR DRIVEWAYE, DOUBLE METAL ENTRY DOORS, 40\' ROTUNDA W/ CHANDELIER, BARREL STYLE WET BAR, OUTDOOR KITCHEN, THEATER ROOM W/ BALCONY SEATING, 4 SIDED DEN FIREPLACE, 5 CAR GARAGE WITH OVERSIZED DOORS! TWO DRIVEWAY GATES PLUS GATED \'CATERING\' ENTRY, LOADS OF COVERED OUTSUDE SEATING AREAS - INGROUND GUNITE POOL WITH HUGE WATERFALL AND OVERSIZED HOT TUB INSTALLED 7/2021.' ,`Acres` = '3.02' ,`Area` = '33' ,`BuilderName` = 'JIMMY BROWN' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Propane,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'THE LAKES OF BAY AREA SEC 3 (2006) ABST 15, BLOCK 2, LOT 16,' ,`LotDesciption` = 'Corner,Water View,Waterfront' ,`LotSize` = '131909' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '5' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'ROY J. WOLLAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Lakes Of Bay Area' ,`TaxAmount` = '56907' ,`TaxRate` = '2.1677' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663693952' WHERE `Matrix_Unique_ID` = '198707086' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T08:54:11.580' ,`MLSNumber` = '52284326' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.019545' ,`Longitude` = '-95.415841' ,`PhotoCount` = '20' ,`PostalCode` = '77073' ,`RoomCount` = '5' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Queenbury Hills' ,`StreetNumber` = '22335' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1946' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1205' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 1 IMPERIAL GARDEN SEC 3' ,`LotDesciption` = 'Other' ,`LotSize` = '5250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CAROLEE BOOKER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANDY DEKANEY H S' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Garden Sec 03' ,`TaxAmount` = '5136' ,`TaxRate` = '2.7904' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693952' WHERE `Matrix_Unique_ID` = '206638466' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T09:28:55.440' ,`MLSNumber` = '61619989' ,`ListAgentFullName` = 'David Mills' ,`ListOfficeName` = 'TBT Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.046632' ,`Longitude` = '-95.696766' ,`PhotoCount` = '18' ,`PostalCode` = '77480' ,`RoomCount` = '4' ,`ListPrice` = '175000.00' ,`Status` = 'Active' ,`StreetName` = 'Maple' ,`StreetNumber` = '603' ,`StreetSuffix` = 'Street' ,`City` = 'Sweeny' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1112' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming home is full of updates that has given it life for another 50 years! Walk into the huge living area surrounded by large updated, windstorm certified windows that allow lots of light to come in while helping to maintain energy efficiency. The kitchen has been beautifully updated with cabinetry and appliances. A large rolling kitchen Island is perfect for preparing meals for guest and then storing it away when not needed. A large room on the back side of the garage can easily be used as a garage apartment, workshop or home office. It has been updated with drywall in 2021 and has easy access to utilities. The huge back yard allows for the perfect amount of sunlight for flower beds and small gardens as well as shade from trees and covered porches. Foundation was leveled and completely repaired in 2021. Pex Plumbing in 2021 means that all is left is for you to do is get the keys!' ,`Acres` = '0.3306' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'MEADOR (SWEENY) BLK 4 LOT 7 (REPLAT)' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '51 - Sweeny' ,`SchoolElementary` = 'SWEENY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SWEENY HIGH SCHOOL' ,`SchoolMiddle` = 'SWEENY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meador Sweeny' ,`TaxAmount` = '4050' ,`TaxRate` = '2.8427' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1953' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693952' WHERE `Matrix_Unique_ID` = '208769700' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T09:56:47.180' ,`MLSNumber` = '52965247' ,`ListAgentFullName` = 'Jobin Johnson' ,`ListOfficeName` = 'Stride Real Estate, LLC' ,`SellingAgentFullName` = 'Lisa Mitchell' ,`SellingOfficeName` = 'Kenyson Roane Realty' ,`Latitude` = '29.469599' ,`Longitude` = '-95.471593' ,`PhotoCount` = '18' ,`PostalCode` = '77583' ,`RoomCount` = '6' ,`ListPrice` = '338690.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Brushwood Drive' ,`StreetNumber` = '7938' ,`StreetSuffix` = '' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1817' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous D.R. Horton New Construction Home Cali plan is a one-story home featuring 4 bedrooms, 2 baths, and 2 car garage. The long foyer with an entry coat closet leads to the open concept kitchen and breakfast area. The kitchen includes a breakfast bar with beautiful counter tops, stainless steel appliances, 42\" cabinets with crown molding, corner pantry and opens to the family room. The primary suite features a sloped ceiling and attractive primary bath with dual vanities, water closet and spacious walk-in closet. The standard rear covered patio is located off the breakfast area and is great for entertaining guests. LOW utility bills as this home is energy rated along with tankless gas water heater and high-efficiency 16 seer carrier A/C system. The upcoming amenity center features include community pool, water slides, playground for kids, soccer fields and MUCH MORE! Onsite Fort Bend ISD schools in the community. Come out to Caldwell Ranch and make this new home yours TODAY!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Caldwell Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.2629' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693953' WHERE `Matrix_Unique_ID` = '209154460' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T09:55:11.553' ,`MLSNumber` = '82063849' ,`ListAgentFullName` = 'Jobin Johnson' ,`ListOfficeName` = 'Stride Real Estate, LLC' ,`SellingAgentFullName` = 'Vaibhav Sharma' ,`SellingOfficeName` = 'All City Real Estate, Ltd. Co.' ,`Latitude` = '29.469599' ,`Longitude` = '-95.471593' ,`PhotoCount` = '44' ,`PostalCode` = '77583' ,`RoomCount` = '6' ,`ListPrice` = '334990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Cattleman Valley Drive' ,`StreetNumber` = '7731' ,`StreetSuffix` = '' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1850' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COME SEE this Brand New D.R. Horton Justin floorplan. This Modern home features 4 spacious bedrooms, 2 bathrooms and 2 car garage. Walk into a beautiful open concept floorplan. Kitchen includes silestone countertops with straight edge, stainless steel appliances and 42\" painted cabinets with crown molding. Other Interior features include Smart Home Automation and 2\" smooth white blinds. Landscape package including front and rear sod with full irrigation system. Comes with high-efficiency 16 seer carrier A/C system and tankless gas water heater. Enjoy a relaxing time on your own covered patio. The upcoming amenity center features include community pool, covered Pavilion with picnic tables, water slides, shallow splash area for kids, soccer field and MUCH MORE! Onsite Fort Bend ISD schools in the community. Schedule your showing today!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'D.R.HORTON' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Caldwell Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.2629' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693953' WHERE `Matrix_Unique_ID` = '209154652' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T09:58:01.437' ,`MLSNumber` = '72851849' ,`ListAgentFullName` = 'Jobin Johnson' ,`ListOfficeName` = 'Stride Real Estate, LLC' ,`SellingAgentFullName` = 'Roshanna Washington' ,`SellingOfficeName` = 'Connect Realty' ,`Latitude` = '29.469599' ,`Longitude` = '-95.471593' ,`PhotoCount` = '5' ,`PostalCode` = '77583' ,`RoomCount` = '5' ,`ListPrice` = '365365.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'William Lane' ,`StreetNumber` = '211' ,`StreetSuffix` = '' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2475' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful NEW D.R. Horton Ozark floorplan! This two story open concept home with 4BR/3BA, GAME ROOM and 2 car garage includes 2 bedrooms downstairs. This new construction home features gorgeous brick and stucco exterior. Features include stainless steel appliances w/ gas burner cooktop, silestone countertops and 42\" cabinets in Kitchen, Smart Home Package, Tankless Gas Water Heater, Covered Patio and Full Sprinkler System. The upcoming amenity center features include community pool, water slides, shallow splash area for kids, playground, soccer field and MUCH MORE! Onsite Fort Bend ISD schools in the community. Come out to Caldwell Ranch and make this new home yours TODAY!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'D.R.HORTON' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Caldwell Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693953' WHERE `Matrix_Unique_ID` = '209156861' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T09:59:39.700' ,`MLSNumber` = '19806708' ,`ListAgentFullName` = 'Jobin Johnson' ,`ListOfficeName` = 'Stride Real Estate, LLC' ,`SellingAgentFullName` = 'Christopher Williams' ,`SellingOfficeName` = 'Keller Williams Premier RealtyKaty' ,`Latitude` = '29.469599' ,`Longitude` = '-95.471593' ,`PhotoCount` = '5' ,`PostalCode` = '77583' ,`RoomCount` = '5' ,`ListPrice` = '368169.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'John House' ,`StreetNumber` = '307' ,`StreetSuffix` = '' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2475' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful NEW D.R. Horton Ozark floorplan! This two story open concept home with 4BR/3BA, GAME ROOM and 2 car garage includes 2 bedrooms downstairs. This new construction home features gorgeous brick and stucco exterior. Features include stainless steel appliances w/ gas burner cooktop, silestone countertops and 42\" cabinets in Kitchen, Smart Home Package, Tankless Gas Water Heater, Covered Patio and Full Sprinkler System. The upcoming amenity center features include community pool, water slides, shallow splash area for kids, playground, soccer field and MUCH MORE! Onsite Fort Bend ISD schools in the community. Come out to Caldwell Ranch and make this new home yours TODAY!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'D.R.HORTON' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Caldwell Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693953' WHERE `Matrix_Unique_ID` = '209157328' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T08:34:20.533' ,`MLSNumber` = '10354268' ,`ListAgentFullName` = 'Angela Stancik' ,`ListOfficeName` = 'ThisIsLivin Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.839443' ,`Longitude` = '-96.541918' ,`PhotoCount` = '38' ,`PostalCode` = '77979' ,`RoomCount` = '3' ,`ListPrice` = '137000.00' ,`Status` = 'Active' ,`StreetName` = 'Pecan' ,`StreetNumber` = '399' ,`StreetSuffix` = 'Street' ,`City` = 'Lolita' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1611' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERFECT Investment or Starter Home with 3 bedrooms, 2.5 bathrooms and over 1700sf. Great sized living room and kitchen. Dining room could also serve as another living or home office. Covered back porch and a large utility barn with storage loft. Short commutes to major plants in the area. About 40 miles from Victoria. This home is Ready to move in! Don\'t miss out on this opportunity - call today to schedule your tour.' ,`Acres` = '0.2222' ,`Area` = '67' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'EAST LOLITA, BLOCK 2, LOT PT, ACRES 0.22' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9680' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '273 - Industrial' ,`SchoolElementary` = 'INDUSTRIAL EAST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'INDUSTRIAL HIGH SCHOOL' ,`SchoolMiddle` = 'INDUSTRIAL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'East Lolita' ,`TaxAmount` = '1777' ,`TaxRate` = '2.1499' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1935' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693953' WHERE `Matrix_Unique_ID` = '209474702' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T08:42:50.120' ,`MLSNumber` = '42745161' ,`ListAgentFullName` = 'Cindy Burns' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.689936' ,`Longitude` = '-95.436643' ,`PhotoCount` = '32' ,`PostalCode` = '77025' ,`RoomCount` = '8' ,`ListPrice` = '995000.00' ,`Status` = 'Active' ,`StreetName` = 'Braeswood' ,`StreetNumber` = '3719' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2782' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The building site for this custom home was decided upon in order to provide the very best sunset views year round for the owners. Amazing sunsets from the expansive deck or inside the home with it\'s wall of windows. Great entertaining space. Primary suite is down with 2 other bedrooms and shared bath on the second floor. Large backyard is easily pool size plus more space. Elevator. Oversized garage. Open interiors with high ceilings in the main living areas. An exciting and most unusual home. Great wall space for art.' ,`Acres` = '0.2984' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Knollwood/Woodside Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 11 & 12A BLK 2 LINKWOOD' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '13000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LONGFELLOW ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Linkwood' ,`TaxAmount` = '21777' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693953' WHERE `Matrix_Unique_ID` = '209885209' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T08:48:17.527' ,`MLSNumber` = '47385577' ,`ListAgentFullName` = 'Beto Tentori' ,`ListOfficeName` = 'Tentori Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.119033' ,`Longitude` = '-95.549596' ,`PhotoCount` = '19' ,`PostalCode` = '77515' ,`RoomCount` = '7' ,`ListPrice` = '399999.00' ,`Status` = 'Active' ,`StreetName` = 'Longhorn' ,`StreetNumber` = '855' ,`StreetSuffix` = 'Trail' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1939' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Single story open floor plan with a large covered patio sitting on large lot. Features include porcelain tile floors in kitchen, dining and living room areas, carpet in bedrooms, tile in wet areas, large master closet, plenty of natural lighting, ss appliances, large bedrooms and a yard that can accommodate a large pool and much more!! Homes are selling fast in this gem of a community. Please don\'t miss your chance to own your dream home and meet your great neighbors!!' ,`Acres` = '1' ,`Area` = '5' ,`BuilderName` = 'JRF Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'BAR X RANCH SEC 2 (A0038 J B BAILEY) BLK 3 LOT 422 (A0053 CA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bar X Ranch Sec 2' ,`TaxAmount` = '170' ,`TaxRate` = '1.5738' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693953' WHERE `Matrix_Unique_ID` = '209947881' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T08:10:02.853' ,`MLSNumber` = '62214619' ,`ListAgentFullName` = 'Wendi Bangoy' ,`ListOfficeName` = 'Keller Williams SoutheastTexas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.341208' ,`Longitude` = '-93.858035' ,`PhotoCount` = '38' ,`PostalCode` = '75948' ,`RoomCount` = '6' ,`ListPrice` = '188000.00' ,`Status` = 'Active' ,`StreetName` = 'Worth' ,`StreetNumber` = '825' ,`StreetSuffix` = 'Street' ,`City` = 'Hemphill' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1568' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Adorable 1950s charmer in the quaint country town of Hemphill,TX! This recently retouched home features all of the charm from days gone by, while still giving you the comfort of modern amenities. Within walking distance of the historic and bustling courthouse square, this home gives you a taste of country living within a stones\' throw of \"city\" conveniences! This home features 3 spacious bedrooms with a primary bedroom feat. an en-suite bath, a cozy living space that opens onto the dining room framed by built-in cabinetry and leads to the roomy kitchen with original crank windows and gas stove! Enjoy Southern evenings entertaining on the covered patio porch overlooking the backyard with storage shed. A home too easy to fall in love with! Call today for more information and to schedule your viewing!' ,`Acres` = '0.615' ,`Area` = '79' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ACRES: 0.615 ABST: 57 JOSEPH WALKER HOUSE/IMPROVEMENTS' ,`LotDesciption` = 'Cleared' ,`LotSize` = '26789' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Composition' ,`SchoolDistrict` = '217 - Hemphill' ,`SchoolElementary` = 'HEMPHILL ELEMENTARY SCHOOL (HEMPHILL)' ,`SchoolHigh` = 'HEMPHILL HIGH SCHOOL' ,`SchoolMiddle` = 'HEMPHILL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'N/A' ,`TaxAmount` = '1442' ,`TaxRate` = '1.4607' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1953' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693953' WHERE `Matrix_Unique_ID` = '210143975' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T08:47:44.987' ,`MLSNumber` = '63782479' ,`ListAgentFullName` = 'Daisy Lopez' ,`ListOfficeName` = 'Move Up America' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.907803' ,`Longitude` = '-95.710904' ,`PhotoCount` = '34' ,`PostalCode` = '77433' ,`RoomCount` = '6' ,`ListPrice` = '458390.00' ,`Status` = 'Active' ,`StreetName` = 'Butler Mountain' ,`StreetNumber` = '14914' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2413' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning new Chesmar Home is a single story that offers plenty of entertainment space indoors & outdoors. Home showcases a spacious living room w/ tall ceilings that opens up into a grand kitchen w/ lots of countertop space. Kitchen has beautiful cabinets w/ hardware, granite countertop, & designer backsplash. Primary bedroom is grand & located at the back of the home, primary bath has separate garden tub + shower, & has 2 separate closets! Back patio is covered w/ tall ceiling and spacious!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Chesmar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot: 23 Block: 2 Section: 43' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1210' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'POSTMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.54' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693954' WHERE `Matrix_Unique_ID` = '210633286' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T09:14:49.570' ,`MLSNumber` = '89118857' ,`ListAgentFullName` = 'Jose Guevara' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.172408' ,`Longitude` = '-96.392359' ,`PhotoCount` = '18' ,`PostalCode` = '77833' ,`RoomCount` = '5' ,`ListPrice` = '180000.00' ,`Status` = 'Active' ,`StreetName` = 'Gay Hill' ,`StreetNumber` = '801' ,`StreetSuffix` = 'Street' ,`City` = 'Brenham' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '1803' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Buyer is to independently verify all room sizes.' ,`Acres` = '0.264' ,`Area` = '58' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'FIELDS, JIM, BLOCK 1, LOT 1 & 2 IMPTS' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '11500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '137 - Brenham' ,`SchoolElementary` = 'BISD DRAW' ,`SchoolHigh` = 'BRENHAM HIGH SCHOOL' ,`SchoolMiddle` = 'BRENHAM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Fields Jim' ,`TaxAmount` = '2732' ,`TaxRate` = '2.0369' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693954' WHERE `Matrix_Unique_ID` = '210699208' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T09:42:26.100' ,`MLSNumber` = '77155445' ,`ListAgentFullName` = 'Mark Mcglone' ,`ListOfficeName` = 'Realty ONE Group Iconic' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.895673' ,`Longitude` = '-95.729876' ,`PhotoCount` = '44' ,`PostalCode` = '77433' ,`RoomCount` = '7' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Oxbow Manor' ,`StreetNumber` = '8126' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3309' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to the exquisite, family-friendly neighborhood of Pine Creek at Canyon Lakes. Located just minutes from Bridgeland and Towne Lake. You\'ll love to take advantage of the community playground and the lake-view trail through the neighborhood. This meticulously maintained Beazer home boasts 4 beds, 3 full baths, home office, gameroom, and media room! Soak in the natural light from the wall of windows in the open-concept living and kitchen areas with vaulted ceilings. Enjoy the outdoors with family and friends as you entertain on the sizeable covered back patio! Storage space is optimal with two upstairs storage closets, and multiple lower level closet spaces. You’ve found the ideal home here.' ,`Acres` = '0.2083' ,`Area` = '25' ,`BuilderName` = 'Beazer' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 1 PINE CREEK AT CANYON LAKES WEST SEC 9' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9074' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'ANDRE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pine Crk/Canyon Lakes West Sec 9' ,`TaxAmount` = '10785' ,`TaxRate` = '3.041' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693954' WHERE `Matrix_Unique_ID` = '210899465' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T09:48:06.113' ,`MLSNumber` = '73544285' ,`ListAgentFullName` = 'Bet Jennings' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.759634' ,`Longitude` = '-95.463691' ,`PhotoCount` = '42' ,`PostalCode` = '77056' ,`RoomCount` = '11' ,`ListPrice` = '1375000.00' ,`Status` = 'Active' ,`StreetName` = 'Exbury' ,`StreetNumber` = '9' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '4004' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully reimagined for everyday living and entertaining. Perfect lock and leave in gated close-in Tanglewood area with hardwood floors and smart home features. Light-filled living room with sleek modern marble gas fireplace, French doors open to pergola-covered outdoor area with fountains and lush private garden area for relaxing. Study/home office looks out on European-like gardens. Spacious dining room with curated butler’s pantry. Epicurean island kitchen complete with Wolf range and double ovens, Sub-Zero refrigerator opens to breakfast area and living room. Up the sweeping, curved staircase is a private primary suite with luxe spa-like bath and huge closet. Conveniently located utility room. Two additional bedrooms with Jack-n-Jill bath. Third floor bonus/exercise room with 3/4 bath. Attached/detached garage and extra parking. Close to Galleria shops and fine dining. All information is per Seller.' ,`Acres` = '0.1637' ,`Area` = '22' ,`BuilderName` = 'Corinthian' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tanglewood Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 1 HOMEWOOD 2ND R/P' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7132' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '5000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2.5' ,`Style` = 'English' ,`Subdivision` = 'Homewood 2 R/P' ,`TaxAmount` = '18851' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693954' WHERE `Matrix_Unique_ID` = '210961388' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T09:44:30.807' ,`MLSNumber` = '1098261' ,`ListAgentFullName` = 'Linh Nguyen' ,`ListOfficeName` = 'The Professional Landlords' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.147041' ,`Longitude` = '-95.639626' ,`PhotoCount` = '31' ,`PostalCode` = '77486' ,`RoomCount` = '10' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Bowie' ,`StreetNumber` = '406' ,`StreetSuffix` = 'Street' ,`City` = 'West Columbia' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '6' ,`SqFtTotal` = '3744' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Attention Investors! Huge income potential for a boarding house, with several chemical plants and manufacturing facilities nearby, or someone with a big family! Originally designed as a duplex, the property has been set up perfectly as a boarding house for blue-collar workers. Potentially 10 bedrooms. Also has 4 full and 2 half baths. Two full kitchens. Big back porch for outdoor relaxation for residents or owners. Right in town with shopping and restaurants nearby. Contact seller for showings and offers.' ,`Acres` = '0.2169' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ALAMO HEIGHTS (WEST COLUMBIA) BLK 2 LOT 5' ,`LotDesciption` = 'Other' ,`LotSize` = '9448' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '56' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Alamo Heights West Columbia' ,`TaxAmount` = '5795' ,`TaxRate` = '2.4263' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693954' WHERE `Matrix_Unique_ID` = '210967143' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T08:30:58.237' ,`MLSNumber` = '58626152' ,`ListAgentFullName` = 'Brenda Clute' ,`ListOfficeName` = 'CB&A, Realtors- Loop Central' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.797495' ,`Longitude` = '-95.097883' ,`PhotoCount` = '32' ,`PostalCode` = '77530' ,`RoomCount` = '3' ,`ListPrice` = '260000.00' ,`Status` = 'Active' ,`StreetName` = 'Forest Trail' ,`StreetNumber` = '16904' ,`StreetSuffix` = 'Drive' ,`City` = 'Channelview' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2077' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious Living Room with high ceilings, fireplace and large windows to a view of the spacious back yard. Island kitchen, electric range, single oven, Large window in Kitchen/breakfast room. Tons of cabinet storage! Bar seating in kitchen area. Primary suite has double sinks, stand up shower, and a tub. **PROPERTY DID NOT FLOOD**' ,`Acres` = '0.3186' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 11 & 12 BLK 11 FOREST RIVER ESTATES' ,`LotDesciption` = 'Cleared' ,`LotSize` = '13879' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '8 - Channelview' ,`SchoolElementary` = 'CRENSHAW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CHANNELVIEW HIGH SCHOOL' ,`SchoolMiddle` = 'AGUIRRE JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Forest River Estates' ,`TaxAmount` = '2964' ,`TaxRate` = '2.118' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693954' WHERE `Matrix_Unique_ID` = '210975836' --> Updated record success