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-11T09:29:55.890' ,`MLSNumber` = '59890390' ,`ListAgentFullName` = 'Joseph Peterson' ,`ListOfficeName` = 'Briko Realty Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.033692' ,`Longitude` = '-94.672500' ,`PhotoCount` = '6' ,`PostalCode` = '77535' ,`RoomCount` = '6' ,`ListPrice` = '110484.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 122' ,`StreetNumber` = '43' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1946' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ON GOING AUCTION Auction properties are sold AS IS /SIGHT UNSEEN without any guarantee or\r\nwarranty by seller. Property may be occupied.' ,`Acres` = '0.8798' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Liberty County East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'RAYWOOD, BLOCK D, LOT TR 3, ACRES .8798, MH LABEL# PFS103262' ,`LotDesciption` = 'Other' ,`LotSize` = '38324' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '108 - Hull-Daisetta' ,`SchoolElementary` = 'HULL-DAISETTA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HULL-DAISETTA HIGH SCHOOL' ,`SchoolMiddle` = 'HULL-DAISETTA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Raywood' ,`TaxAmount` = '1394' ,`TaxRate` = '2.0606' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663697046' WHERE `Matrix_Unique_ID` = '200432606' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T09:05:32.683' ,`MLSNumber` = '89353580' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '26.222055' ,`Longitude` = '-98.282102' ,`PhotoCount` = '28' ,`PostalCode` = '78572' ,`RoomCount` = '3' ,`ListPrice` = '339999.00' ,`Status` = 'Active' ,`StreetName` = 'Grapefruit' ,`StreetNumber` = '2217' ,`StreetSuffix` = '' ,`City` = 'Mission' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3012' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A must see elegant home with contemporary flair in Hackberry Manor. This new construction property has an open concept design from the grand foyer to the crimson dining room, leading into the modern kitchen. This beautiful home features an intimate living room area with a small space for a computer desk, and a spacious family room with a wet bar for entertaining your guests and family. This home consists of 3 spacious bedrooms with walk in closets, 3.5 luxurious bathrooms, a laundry room with a sink and 2 car garage. Bamboo wood and porcelain tile flooring are also features found inside this home, as well as granite countertops all throughout. Call us today for more details!' ,`Acres` = '0.17' ,`Area` = '85' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'HACKBERRY MANOR LOT 58' ,`LotDesciption` = 'Other' ,`LotSize` = '7426' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '919 - Sharyland' ,`SchoolElementary` = 'ROMULO D. MARTINEZ ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHARYLAND HIGH SCHOOL' ,`SchoolMiddle` = 'B. L. GRAY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hackberry Manor' ,`TaxAmount` = '9041' ,`TaxRate` = '2.7093' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697046' WHERE `Matrix_Unique_ID` = '201465484' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T09:56:39.257' ,`MLSNumber` = '18775698' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'KB Home Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.946538' ,`Longitude` = '-95.183251' ,`PhotoCount` = '8' ,`PostalCode` = '77044' ,`RoomCount` = '8' ,`ListPrice` = '304995.00' ,`Status` = 'Active' ,`StreetName` = 'Pear Orchard' ,`StreetNumber` = '12811' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1631' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Find total comfort in this charming KB Home in Lakewood Pines, boasting a brick elevation, tile flooring, extended entry, and an open great room. Whip up meals in the kitchen, complete with Silestone countertops, tile backsplash, stainless steel Energy Star® appliances, and 42-in. cabinets. Unwind in the serene primary suite, featuring extended dual vanities and a tub with a Moen Chateau Watersense® showerhead. Additional home features include full gutters. The desirable community of Lakewood Pines offers residents access to a pool, park, and recreation center. Commuters enjoy convenient access to the Houston Ship Channel and Generation Park via the Sam Houston Tollway. Nearby schools are zoned to the highly-rated Humble ISD.' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'KB Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '732' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'CENTENNIAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakewood Pines' ,`TaxAmount` = '' ,`TaxRate` = '3.613' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697047' WHERE `Matrix_Unique_ID` = '204853526' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T09:57:45.070' ,`MLSNumber` = '33772403' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'KB Home Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.553750' ,`Longitude` = '-95.502207' ,`PhotoCount` = '6' ,`PostalCode` = '77459' ,`RoomCount` = '10' ,`ListPrice` = '389995.00' ,`Status` = 'Active' ,`StreetName` = 'Lazarina' ,`StreetNumber` = '2931' ,`StreetSuffix` = 'Lane' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2526' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** You don’t want to miss this KB Home in the new Olympia Falls community, boasting a brick elevation, vinyl flooring, extended entry, and an open great room. Master new recipes in the kitchen, equipped with granite countertops, tile backsplash, stainless steel Energy Star® appliances, and 42-in. cabinets. The spa-like primary suite features extended dual vanities, a 42-in. Kohler Master Windward® tub, and a separate shower. Additional home features include faux wood blinds and full gutters. The community comforts of Olympia Falls include a park with a playground and walking paths. Conveniently located near Fort Bend Pkwy. Toll Rd., and I-69, residents enjoy nearby shopping and entertainment at Riverstone Shopping Center, Missouri City Shopping Center, First Colony Mall, and Pearland Town Center. Students attend the highly-rated highly-rated Fort Bend ISD schools.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'KB Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 28 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BLUE RIDGE ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'WILLOWRIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'MCAULIFFE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Olympia Falls' ,`TaxAmount` = '' ,`TaxRate` = '3.2629' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697047' WHERE `Matrix_Unique_ID` = '205482941' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T09:55:22.473' ,`MLSNumber` = '15037055' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'KB Home Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.843790' ,`Longitude` = '-95.810976' ,`PhotoCount` = '7' ,`PostalCode` = '77493' ,`RoomCount` = '11' ,`ListPrice` = '438101.00' ,`Status` = 'Active' ,`StreetName` = 'Dunston Manor' ,`StreetNumber` = '4615' ,`StreetSuffix` = 'Street' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2936' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**home is under construction.** This gorgeous KB Home on a spacious lot in Katy Manor boasts a brick front, a vinyl plank flooring, and an open great room. Spend quality time in the kitchen, equipped with Silestone countertops, tile backsplash, 30” gas cooktop, double wall oven, stainless steel Energy Star® appliances, and 42-in. cabinets. Complete with extended dual vanities, a 42-in. Kohler Master Windward® tub, and a separate shower, the primary suite is the ideal place to unwind. Additional home features include faux wood blinds, full gutters, and a covered patio. Additional home features include faux wood blinds, automatic sprinklers, and an extended covered patio. Katy Manor boasts a splash pad, park, and playground. The community is located near I-10 and the Grand Parkway, giving residents easy access to the Energy Corridor. Enjoy dining, shopping, and entertainment at the nearby Katy Mills Mall and LaCenterra at Cinco Ranch. Zoned to the highly-acclaimed Katy ISD.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'KB Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 Block 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '465' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Katy Manor' ,`TaxAmount` = '' ,`TaxRate` = '3.556' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697047' WHERE `Matrix_Unique_ID` = '207435578' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T09:31:48.890' ,`MLSNumber` = '81247196' ,`ListAgentFullName` = 'Jeremy Larkin' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.528527' ,`Longitude` = '-95.553294' ,`PhotoCount` = '39' ,`PostalCode` = '77459' ,`RoomCount` = '10' ,`ListPrice` = '340000.00' ,`Status` = 'Active' ,`StreetName` = 'La Crema' ,`StreetNumber` = '5830' ,`StreetSuffix` = '' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2238' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome HOME to Master-Planned living at Sienna!!! Featuring an impressive array of amenities, including 100+ acres of parks, miles of walking trails, waterparks, Sienna Golf Club + Grille, Sienna Stables, Camp Sienna Sports Park, Club Sienna and SO much more!! This STUNNING 4 bedroom, 2.5 bath features an OPEN family room with HIGH ceilings and gas-log fireplace! GOURMET corian ISLAND kitchen with breakfast bar, stainless steel appliances, tile backsplash, TONS of cabinet space and breakfast nook! PRIVATE downstairs master retreat with DUAL vanity, separate glass shower + soaking tub and WALK-IN closet!! Formal dining, UPSTAIRS gameroom and SPACIOUS secondary bedrooms! RELAXING backyard with patio -- PERFECT for entertaining! BRAND NEW ROOF completed 6/17!! Make the call today -- This property WONT last long!!' ,`Acres` = '0.1188' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIENNA VILLAGE OF ANDERSON SPRINGS SEC 5-A, BLOCK 6, LOT 17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5175' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SCHIFF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna Village Of Anderson Springs' ,`TaxAmount` = '6716' ,`TaxRate` = '2.8129' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697047' WHERE `Matrix_Unique_ID` = '207977457' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T09:53:13.560' ,`MLSNumber` = '10906907' ,`ListAgentFullName` = 'Wendy Jones' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.804893' ,`Longitude` = '-95.427121' ,`PhotoCount` = '9' ,`PostalCode` = '77008' ,`RoomCount` = '4' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = '21st' ,`StreetNumber` = '1533' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1232' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic opportunity to develop! Offering Location, Convenience and Lifestyle! Huge double lot available with over 11,280 in this highly desirable Greater Heights - Shady Acres subdivision. Close to shops, restaurants and easy access to all major freeways. Minutes from Memorial Park, the Heights/White Oak hike & bike trail & Downtown. Property is being sold for Lot Value only. There is a home on the property that will not be shown. The home on the lot to be sold in As-IS condition, no repairs will be done by sellers. The red shed on the property is not part of the sale and will be removed before closing.' ,`Acres` = '0.259' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'TR 205E SHADY ACRES SEC 2' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '11280' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Shady Acres Sec 02' ,`TaxAmount` = '10418' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1933' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697047' WHERE `Matrix_Unique_ID` = '207981527' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T09:02:09.670' ,`MLSNumber` = '74034682' ,`ListAgentFullName` = 'Lylian Alfaro' ,`ListOfficeName` = 'Lone Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.045850' ,`Longitude` = '-95.624576' ,`PhotoCount` = '50' ,`PostalCode` = '77377' ,`RoomCount` = '10' ,`ListPrice` = '1900000.00' ,`Status` = 'Active' ,`StreetName` = 'Boudreaux' ,`StreetNumber` = '13845' ,`StreetSuffix` = 'Road' ,`City` = 'Tomball' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3578' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '. No restrictions!! Could be commercial!!plus 6250 sq. ft. External building is warehouse, office, with central AC. Commercial.Country Home set on 3 acres w/pond & big city amenities!! NO FLOODING!!Front & back covered porches. 4 bedrooms each w/private baths, open game room, & study w/french doors or 4th bedroom. Large master bedroom downstairs w/French doors to back porch. His/Hers vanities, soaker tub, separate shower in master bath. High ceiling in living room open to 2nd story game room. Kitchen has granite tops & SS 5-burner gas range. Large utility w/built in cabinets and granite counter top. Private stairs lead to /gameroom/private office. We privet Pool The outside space is amazing & easy to maintain. Stocked pond with gazebo that has electricity & water. You even get to have chickens!!! This is a must see if you are wanting to have country living but need to be close to the amenities of life. Tomball ISD. No mud taxes' ,`Acres` = '3.004' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 1G-1 ABST 296 E GIRARD' ,`LotDesciption` = 'Other' ,`LotSize` = '130855' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Call Occupant' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Girard Emile' ,`TaxAmount` = '9648' ,`TaxRate` = '2.0264' ,`WaterSewer` = 'Aerobic,Septic Tank' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697047' WHERE `Matrix_Unique_ID` = '208068912' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T09:12:18.193' ,`MLSNumber` = '57236624' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = 'Yolanda Wilson' ,`SellingOfficeName` = 'The Lakes Group' ,`Latitude` = '29.203767' ,`Longitude` = '-95.407343' ,`PhotoCount` = '16' ,`PostalCode` = '77515' ,`RoomCount` = '8' ,`ListPrice` = '379990.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Prairie Rose' ,`StreetNumber` = '3619' ,`StreetSuffix` = 'Trail' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2817' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The spacious \"Concho\" floorplan by CastleRock Communities. Primary bedroom and home office downstairs. Bedrooms 2, 3, 4 plus a spacious game room are all upstairs. Beautiful open floorplan and soaring high ceilings.\r\n\r\nNew Windrose Green community in Angleton ISD! Windrose Green will offer easy access to I-35 & HWY 288 and will feature amenities such as a recreation center, lakes and walking trails, a play ground, and splash pad.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 22 Block 2 Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5625' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'RANCHO ISABELLA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Windrose Green' ,`TaxAmount` = '' ,`TaxRate` = '3.48' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697047' WHERE `Matrix_Unique_ID` = '208102356' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T09:07:04.737' ,`MLSNumber` = '50340801' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Gina Washington' ,`SellingOfficeName` = 'JLA Realty' ,`Latitude` = '29.852738' ,`Longitude` = '-95.742516' ,`PhotoCount` = '8' ,`PostalCode` = '77449' ,`RoomCount` = '5' ,`ListPrice` = '370990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Wine Palm Way' ,`StreetNumber` = '21614' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2482' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW D.R. Horton\'s Express two story! Wonderful open floor plan! Island kitchen has lots of cabinets and is open to the breakfast room and family room! Large primary bedroom with a spacious closet! Features a large shower in the primary bathroom as well! Hard surface flooring in all living areas and modern designer details! Covered Patio overlooking the backyard! Landscape package included and so much more! Hurry and call today!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 28 - Block 2- Section 24' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6511' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'GOLBOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'MCDONALD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Jasmine Heights' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697048' WHERE `Matrix_Unique_ID` = '208901145' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T09:39:59.327' ,`MLSNumber` = '87012541' ,`ListAgentFullName` = 'Randy French' ,`ListOfficeName` = 'Stylecraft Builders, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.723526' ,`Longitude` = '-95.550777' ,`PhotoCount` = '11' ,`PostalCode` = '77320' ,`RoomCount` = '10' ,`ListPrice` = '268900.00' ,`Status` = 'Active' ,`StreetName` = 'Rudder Way' ,`StreetNumber` = '108' ,`StreetSuffix` = '' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1620' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Upon entering this exceptional floor plan, you\'re immediately greeted with a high ceiling foyer. Walking into the open-concept kitchen and living room, you\'ll be stunned by the amount of space you have to gather. This three bedroom, two bath home has placed windows in the living room, primary bedroom, and dining room, crafting a home that is filled with natural light and charm. Granite countertops throughout and a large walk-in primary closet to top it all off and make this home exceptional. Additional options included: Stainless steel appliances, additional LED recessed lighting, integral blinds in rear door, dual primary bathroom vanity, single basin kitchen sink, study option, and an upgraded primary bathroom shower.' ,`Acres` = '' ,`Area` = '43' ,`BuilderName` = 'Stylecraft' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'STERLING RIDGE SEC-4, BLOCK 1, LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'SCOTT JOHNSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sterling Ridge' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697048' WHERE `Matrix_Unique_ID` = '208978219' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T08:32:33.570' ,`MLSNumber` = '44330693' ,`ListAgentFullName` = 'Misti Bruton' ,`ListOfficeName` = 'AVO Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.772249' ,`Longitude` = '-98.349040' ,`PhotoCount` = '30' ,`PostalCode` = '78163' ,`RoomCount` = '10' ,`ListPrice` = '645000.00' ,`Status` = 'Active' ,`StreetName` = 'Right' ,`StreetNumber` = '221' ,`StreetSuffix` = 'Fork' ,`City` = 'Bulverde' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1951' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you love the countryside and being outdoors this piece of Texas has everything you are looking for! This charming home with a workshop, huge storage shed and chicken coup sprawl across this unrestricted 5-acre property in Bulverde. Tucked away and private but don’t let that fool you, there is an easy commute to Hwy 46. The outdoor deck and wraparound porch give so much extra living space. Invite all the friends and family over for an outdoor bar-b-que, entertaining is easy here with the built-out bar and shaded back deck. Not to mention the 2 living areas where one could easily accommodate a pool table for a “man cave”, a large crafters oasis or a gameroom for the kids. Huge primary suite with barndoor bathroom give way to a rustic bath. Large windows throughout the home let in plenty of natural light. Schedule a viewing of this home today, to imagine the possibilities of making it all yours!' ,`Acres` = '5' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Heat Pump' ,`HOAMandatory` = '0' ,`Legal` = 'KAREN ESTATES, LOT 3' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '217800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '141 - Comal' ,`SchoolElementary` = 'JOHNSON RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SMITHSON VALLEY HIGH SCHOOL' ,`SchoolMiddle` = 'SMITHSON VALLEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Karen Estates' ,`TaxAmount` = '6235' ,`TaxRate` = '1.8256' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697048' WHERE `Matrix_Unique_ID` = '209024197' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T08:40:46.843' ,`MLSNumber` = '83495918' ,`ListAgentFullName` = 'Latisha Bradshaw' ,`ListOfficeName` = 'Texas Diamond Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.496347' ,`Longitude` = '-94.930274' ,`PhotoCount` = '16' ,`PostalCode` = '77539' ,`RoomCount` = '2' ,`ListPrice` = '200000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue C' ,`StreetNumber` = '1918' ,`StreetSuffix` = '' ,`City` = 'San Leon' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1419' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Look no more for your own oasis in Sunny San Leon. Close to the water where you can sit on the porch and smell the salty air. This home has Mature trees for shade on these hot Texas Days. A beautiful 2 bedroom 1 bath on 4 lots completely fenced in yard. The porch wraps around the whole house where you can entertain guests and enjoy the view all around. Property also has an extra light pole for a RV hookup or possibly mobile home. Measurements are not accurate so please measure if you need exact measurements. Home is sold as is with seller not doing any repairs. Seller will pay some of buyers concessions.' ,`Acres` = '0.3076' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 10 A EDWARDS LOT 1 TO 4 BLK 40 SAN LEON FEMA TRAILER' ,`LotDesciption` = 'Corner' ,`LotSize` = '13400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'SAN LEON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'San Leon' ,`TaxAmount` = '4082' ,`TaxRate` = '2.521' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697048' WHERE `Matrix_Unique_ID` = '209313507' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T09:04:24.530' ,`MLSNumber` = '17948228' ,`ListAgentFullName` = 'Deborah Torres' ,`ListOfficeName` = 'Jose Garza Agency' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '26.201098' ,`Longitude` = '-98.149977' ,`PhotoCount` = '19' ,`PostalCode` = '78589' ,`RoomCount` = '7' ,`ListPrice` = '200000.00' ,`Status` = 'Active' ,`StreetName` = 'Gonzalez' ,`StreetNumber` = '117' ,`StreetSuffix` = 'Drive' ,`City` = 'San Juan' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1630' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You will not want to miss this lovely updated four bedroom 2 bath home. It is very spacious with updates throughout the home, including tile throughout and granite counter tops. It has easy access to Express 83 and large fenced in front and backyard. The large backyard has a nice patio and is perfect for entertaining.' ,`Acres` = '0.264' ,`Area` = '85' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PECAN ESTATES LOT 9 BLK 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '817 - Pharr-San Juan-Alamo' ,`SchoolElementary` = 'DOEDYNS ELEMENTARY SCHOOL' ,`SchoolHigh` = '' ,`SchoolMiddle` = 'AUSTIN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pecan Estates' ,`TaxAmount` = '2877' ,`TaxRate` = '2.8264' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697048' WHERE `Matrix_Unique_ID` = '210694863' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T08:18:34.770' ,`MLSNumber` = '70714309' ,`ListAgentFullName` = 'Jessica Pena' ,`ListOfficeName` = 'Levi Rodgers Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.975128' ,`Longitude` = '-95.453400' ,`PhotoCount` = '28' ,`PostalCode` = '77014' ,`RoomCount` = '9' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Colony Hill' ,`StreetNumber` = '12559' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3012' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful and spacious home with an amazing floor plan. 3012 sqft, 4-bedroom, 2.5-bathroom, game room, media room, study/office and backs up to a greenbelt. Kitchen has granite countertops and open concept with a formal dining and large family room. Master bedroom is located downstairs with a garden tub and a glass enclosed shower. Upstairs you will fall in love with the massive game room and private media room, perfect for entertaining. The private backyard backs up to no neighbors with an ample covered patio. Shopping and dining are minutes away at the Willowbrook Mall or Greenspoint Mall. Easy access to I-45, BW 8 and about 25 minutes from downtown. Come see your new home today' ,`Acres` = '0.2052' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 2 SILVERGLEN NORTH SEC 10' ,`LotDesciption` = 'Other' ,`LotSize` = '8938' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'DELORAS E THOMPSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'STELLE CLAUGHTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Silverglen North Sec 10' ,`TaxAmount` = '7441' ,`TaxRate` = '2.8867' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697048' WHERE `Matrix_Unique_ID` = '210768017' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T09:01:06.913' ,`MLSNumber` = '36466027' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Hai Huynh' ,`SellingOfficeName` = 'Keller Williams Signature' ,`Latitude` = '29.852738' ,`Longitude` = '-95.742516' ,`PhotoCount` = '7' ,`PostalCode` = '77449' ,`RoomCount` = '4' ,`ListPrice` = '318490.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Bonita Vista Drive' ,`StreetNumber` = '21611' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1665' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WOW! CHARMING NEW D. R. HORTON BUILT 1 STORY 4 BEDROOM! Sought-After Split Plan Design with Private Primary Suite! Island Kitchen with Cabinetry Galore & Corner Walk-In Pantry - Opens to Spacious Breakfast Area & Living Room! Privately Located Primary Suite Features Spacious Walk-In Closet & Pretty Bath with Large Shower! Indoor Utility Room! Hard Surface Flooring in Living Area! Covered Patio Overlooks Backyard! Estimated Completion - September 2022.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 24 - Block 1 - Section 25' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6196' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'GOLBOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'MCDONALD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jasmine Heights' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697048' WHERE `Matrix_Unique_ID` = '210768439' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T09:29:52.987' ,`MLSNumber` = '57442304' ,`ListAgentFullName` = 'Teresa Hill McCray' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.765790' ,`Longitude` = '-95.058650' ,`PhotoCount` = '21' ,`PostalCode` = '77351' ,`RoomCount` = '7' ,`ListPrice` = '479720.00' ,`Status` = 'Active' ,`StreetName` = 'Hickory' ,`StreetNumber` = '118' ,`StreetSuffix` = 'Pines' ,`City` = 'Livingston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming home overlooking Lake Livingston has been designed to amplify your lake experience from each vantage point. Granite counter tops in the Kitchen and Bathrooms, custom porcelain tile in Kitchen and Bathrooms, Vinyl (waterproof) planking throughout the home. Your new water-view home gives you unobstructed access to this scenic oasis. Dimensions to be verified. Upgrade options are available. Luxury living on Lake Livingston, your piece of paradise is waiting for you.' ,`Acres` = '0.164' ,`Area` = '44' ,`BuilderName` = 'Owner/Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'PINWAH PINE SECTION 1 BLK 2 LOT 24' ,`LotDesciption` = 'Cul-De-Sac,Water View' ,`LotSize` = '7372' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Pinwah Pine #1' ,`TaxAmount` = '142' ,`TaxRate` = '1.7215' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697049' WHERE `Matrix_Unique_ID` = '210977754' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T09:07:20.413' ,`MLSNumber` = '13965359' ,`ListAgentFullName` = 'Michael Gaido' ,`ListOfficeName` = 'Sand N Sea Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.270124' ,`Longitude` = '-94.879457' ,`PhotoCount` = '30' ,`PostalCode` = '77554' ,`RoomCount` = '6' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = '103rd' ,`StreetNumber` = '1224' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1480' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see one of Galveston’s most desired water locations. This 3 bed 2 bath open plan with fire place is a one owner canal home with unobstructed West views. The island kitchen complete with ample cabinet and drawer space. Sit in the spacious living dining area that has ample windows that provide an abundance of natural light and canal views. The primary bedroom with ensuite bathroom and private deck access. The waterside bedroom has double doors with deck access. Enclosed garage down with water side garage door to allow for ample air flow when entertaining. Hot tub and washer dryer included. The lot to the NW is also for sale for 239,000.' ,`Acres` = '0.0976' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Near West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 26 AIRPORT HOMESITES SEC 4' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '4250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Airport Homesites' ,`TaxAmount` = '4595' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697049' WHERE `Matrix_Unique_ID` = '211050833' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T09:20:00.720' ,`MLSNumber` = '39719117' ,`ListAgentFullName` = 'Jo Ann Holba' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.961742' ,`Longitude` = '-96.245215' ,`PhotoCount` = '22' ,`PostalCode` = '77418' ,`RoomCount` = '9' ,`ListPrice` = '599900.00' ,`Status` = 'Active' ,`StreetName` = 'Lola Lane' ,`StreetNumber` = '134' ,`StreetSuffix` = '' ,`City` = 'Bellville' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a very special 4 bedroom 3.5 bath on 2.5 beautiful acres located just outside of Bellville. Property has a country feel yet convenient to town. The home features living room with vaulted ceiling, formal dining room, kitchen with ample cabinets, island bar and breakfast area; plus a game room. The primary bedroom is separate from the other bedrooms and primary bath has double vanity, walk-in closets, separate whirlpool tub and shower. Three bedrooms enjoy one bath with tub/shower and second bath with double vanity. There is a large 2-car attached garage with storage and a well house and storage shed. Property boasts shade trees, open and wooded areas. Beautiful setting and truly a very special property.' ,`Acres` = '' ,`Area` = '57' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Sub Lot of 45 Acres 2.000 Acres & .524 Ac- total 2.524 Acres' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '136 - Bellville' ,`SchoolElementary` = 'WEST END ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'BELLVILLE JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sander Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663697049' WHERE `Matrix_Unique_ID` = '211179102' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T08:42:21.987' ,`MLSNumber` = '98629944' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.949627' ,`Longitude` = '-95.198138' ,`PhotoCount` = '26' ,`PostalCode` = '77346' ,`RoomCount` = '16' ,`ListPrice` = '544967.00' ,`Status` = 'Active' ,`StreetName` = 'Banchory Leaf' ,`StreetNumber` = '12611' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3117' ,`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. Forget the world outside and come home to Balmoral, a community surrounded by beauty and peace in the West Lake Houston area of northeast Beltway 8 in Humble, TX. Balmoral offers residents connected living with luxurious homes and many amenities to choose from, including the Houston area\'s Crystal Clear Lagoon surrounded by glistening white sand beaches. Stop by the Westin Homes model home today to find out more about Balmoral!' ,`Acres` = '0.1435' ,`Area` = '1' ,`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` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1430' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'CENTENNIAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Balmoral' ,`TaxAmount` = '1668' ,`TaxRate` = '3.08' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697049' WHERE `Matrix_Unique_ID` = '211223662' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T08:49:39.193' ,`MLSNumber` = '15452297' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.154133' ,`Longitude` = '-95.584342' ,`PhotoCount` = '28' ,`PostalCode` = '77354' ,`RoomCount` = '17' ,`ListPrice` = '657842.00' ,`Status` = 'Active' ,`StreetName` = 'Davis Hill' ,`StreetNumber` = '27118' ,`StreetSuffix` = 'Lane' ,`City` = 'Magnolia' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Asher V, Elevation A) CURRENTLY BEING BUILT. Two story. 5 bedrooms. 4.5 baths. Elegant double front door entry, family room, informal 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. Three additional bedrooms, spacious game room and media room on second floor. Attached 3-car tandem garage. \r\n NorthGrove offers easy access to all the conveniences and necessities of modern living with The Woodlands, Tomball, and Conroe all a short distance away. With resort-style amenities, including The Retreat, a 9,400-sq.-ft. clubhouse, Northgrove is the perfect escape from the daily grind. Enjoy a fitness center, pool, children\'s play areas and more. Stop by the Westin Homes model home today to find out more about Northgrove!' ,`Acres` = '0.2214' ,`Area` = '15' ,`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` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BLOCK 1, LOT 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9646' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1295' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Northgrove' ,`TaxAmount` = '2250' ,`TaxRate` = '3.21' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697049' WHERE `Matrix_Unique_ID` = '211266352' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T09:16:22.497' ,`MLSNumber` = '95654745' ,`ListAgentFullName` = 'Tammi Freund' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.665556' ,`Longitude` = '-95.291409' ,`PhotoCount` = '49' ,`PostalCode` = '77061' ,`RoomCount` = '8' ,`ListPrice` = '520000.00' ,`Status` = 'Active' ,`StreetName` = 'Ashburn' ,`StreetNumber` = '7510' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '1836' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MUST SEE!! Come see your future home!! *This can definitely be a perfect INVESTMENT OPPORTUNITY**Completely remodeled two story home, **PLUS 2 Bedroom GARAGE APARTMENT on almost ONE ACRE!!**Lot offers recently installed beautiful flooring throughout the house, fresh paint, recently updated with electrical/plumbing, 2021 roof, recent driveway, recently installed kitchen appliances, beautiful cabinet, granite counter tops, backsplash, and vanities. Recently added siding insulation, drywall and doors. Decent size bedrooms & closet space, double sinks, updated windows and ducts, It\'s almost completely renovated home!! Plus a gorgeous wet bar in your living-room area, perfect for your guests. NO HOA, NO FLOOD ZONE AND MUCH MORE!! This home won\'t last long!! Come see this beautiful HOME TODAY' ,`Acres` = '0.9407' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 7 BLK 7 GARDEN VILLAS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '40975' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GARDEN VILLAS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HARTMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Garden Villas' ,`TaxAmount` = '4963' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697049' WHERE `Matrix_Unique_ID` = '211267020' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T09:47:10.480' ,`MLSNumber` = '83676866' ,`ListAgentFullName` = 'Ruben Chan' ,`ListOfficeName` = 'Intercontinental, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.699138' ,`Longitude` = '-95.329898' ,`PhotoCount` = '41' ,`PostalCode` = '77021' ,`RoomCount` = '2' ,`ListPrice` = '260000.00' ,`Status` = 'Active' ,`StreetName` = 'Beekman' ,`StreetNumber` = '5511' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1266' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2 bedroom 1 bath home in Macgregor Place. Quick commute to the Downtown, the Medical Center and UofH.' ,`Acres` = '0.1653' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 81 BLK 4 MACGREGOR PLACE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PECK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Macgregor Place Sec 03' ,`TaxAmount` = '2898' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697049' WHERE `Matrix_Unique_ID` = '211276537' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T09:02:53.880' ,`MLSNumber` = '79176188' ,`ListAgentFullName` = 'Christopher Phan' ,`ListOfficeName` = 'Truss Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.834939' ,`Longitude` = '-95.409721' ,`PhotoCount` = '9' ,`PostalCode` = '77018' ,`RoomCount` = '6' ,`ListPrice` = '429000.00' ,`Status` = 'Active' ,`StreetName` = 'Abbadean' ,`StreetNumber` = '4805' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1950' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Martin Court located in Independence Heights built by Oracle City Homes. This privately gated urban modern farmhouse community consists of 16 units total units with twelve 2 story homes and four 3 story homes that each come with a private yard. Each unit has been professionally designed interiors raising the bar with high end standard features that come with each home. First floor living with an oversized island countertop with seating of 3 that overlooks the living room that leads you to your own private backyard. The dining area is nestled in it\'s own private section with oversized windows along the adjoining walls giving plenty of natural lighting. The primary bedroom features 10 ft high ceilings and oversized windows that leads you to your own primary ensuite with separate his/her sinks along each wall that welcomes you into your own stand alone tub and walk in shower and closet. This community is a must see combining luxury and privacy!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Oracle City Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 Block 1 Martin Court' ,`LotDesciption` = 'Other' ,`LotSize` = '1100' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '125' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KENNEDY ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Other Style,Traditional' ,`Subdivision` = 'Martin Court' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697050' WHERE `Matrix_Unique_ID` = '211294448' --> Updated record success