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-24T14:06:22.567' ,`MLSNumber` = '90476436' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'LaWona Cartwright' ,`SellingOfficeName` = 'ERA Legacy Living' ,`Latitude` = '29.494274' ,`Longitude` = '-95.386147' ,`PhotoCount` = '29' ,`PostalCode` = '77578' ,`RoomCount` = '12' ,`ListPrice` = '599637.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Limestone' ,`StreetNumber` = '4142' ,`StreetSuffix` = 'Terrace' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3459' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Preston III, Elevation B) Two story. 4 bedrooms. 3.5 baths. Master suite downstairs with large walk-in closet. Family room and formal dining and living room. Spacious island kitchen. Game room and media room upstairs. Covered back patio and attached 2-car garage.\r\nDel Bello Lakes, a master-planned community, is located in Manvel, TX, will feature Jaxon’s Cove, a modern amenity center equipped with a splash pad, resort-style pool, outdoor pavilion, playground, and spaces for residents to book private events. Del Bello Lakes will also feature over 40 acres of lakes, a five-mile trail system, and 15 acres of parks and open space. Stop by the Westin Homes model home today to find out more about Del Bello Lakes!' ,`Acres` = '' ,`Area` = '5' ,`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` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 12 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9438' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'E C MASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'MANVEL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Del Bello Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.8' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702511' WHERE `Matrix_Unique_ID` = '203404465' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T15:23:10.467' ,`MLSNumber` = '4506974' ,`ListAgentFullName` = 'Kelly Turner' ,`ListOfficeName` = 'BSRH Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.795336' ,`Longitude` = '-96.169681' ,`PhotoCount` = '19' ,`PostalCode` = '77474' ,`RoomCount` = '7' ,`ListPrice` = '466500.00' ,`Status` = 'Active' ,`StreetName` = 'Buckhorn' ,`StreetNumber` = '511' ,`StreetSuffix` = 'Street' ,`City` = 'Sealy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2641' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fully bricked with Stone front (Elv.A); 4 bedroom, 2 1/2 bath with 8\' interior doors and 5\' garage extension. Located on a premium lot.' ,`Acres` = '' ,`Area` = '57' ,`BuilderName` = '000' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 13, Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '109 - Sealy' ,`SchoolElementary` = 'SEALY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEALY HIGH SCHOOL' ,`SchoolMiddle` = 'SEALY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hunters Crossing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702511' WHERE `Matrix_Unique_ID` = '205468295' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T15:22:41.220' ,`MLSNumber` = '23477554' ,`ListAgentFullName` = 'Michael Furman' ,`ListOfficeName` = 'RE/MAX Unlimited' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.949837' ,`Longitude` = '-95.386041' ,`PhotoCount` = '32' ,`PostalCode` = '75862' ,`RoomCount` = '4' ,`ListPrice` = '130000.00' ,`Status` = 'Active' ,`StreetName` = 'Church' ,`StreetNumber` = '407' ,`StreetSuffix` = 'Street' ,`City` = 'Trinity' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1568' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '4 Bedroom 2 Bathroom home on beautiful 0.651 acre lot with NO RESTRICTIONS. The home features a covered porch with stairs and working solar panels! Large fenced area ready for horses or other livestock!Book your appointment now!' ,`Acres` = '0.651' ,`Area` = '42' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Trinity Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TRINITY, TR 23, LOT 4 PT OF & 5 PT OF LABEL # PFS0853527' ,`LotDesciption` = 'Other' ,`LotSize` = '28358' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (TRINITY)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Trinity Tr 23' ,`TaxAmount` = '1051' ,`TaxRate` = '2.5001' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702511' WHERE `Matrix_Unique_ID` = '205482587' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T15:30:39.453' ,`MLSNumber` = '62982058' ,`ListAgentFullName` = 'Ellisa Carswell' ,`ListOfficeName` = 'Carswell Real Estate Co. Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.080985' ,`Longitude` = '-95.787274' ,`PhotoCount` = '50' ,`PostalCode` = '77447' ,`RoomCount` = '13' ,`ListPrice` = '2795000.00' ,`Status` = 'Active' ,`StreetName` = 'Hunters Creek' ,`StreetNumber` = '707' ,`StreetSuffix` = 'Way' ,`City` = 'Hockley' ,`BathsFull` = '6' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '7161' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous sprawling house is located on 25.07 +/- beautiful acres! Entertaining property with stunning tropical Lagoon style pool that curves around the back of the house with waterfalls, slide, bridge, & gazebo. Basketball & volley ball courts. Meditation area with a fire pit. Home features large & private formal dining room. Fresh interior paint. Huge galley style island kitchen with steel appliances, double oven, warming tray, ice maker, & tons of cabinet storage. Plantation Shutters throughout. Primary Suite with home office & sun room with fabulous panoramic views of the backyard. Enjoy the Gym/Workout Room in the massive Game Room that features kitchenette, sauna, hot tub, bath & plenty of room to entertain. The 2300 +/- sq. ft. guest quarters (the sellers used this as an office for their business) features 2 kitchenettes (1 up & 1 down) living room, 1.5 baths, study area with built-in & lots of storage. 6 car carport. Barn with 2 stalls, tack room & round pen. Water well.' ,`Acres` = '25.071' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'PT LT 10 BLK 1 (HOMESITE AG USE) HUNTER CREEK ESTATES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1092115' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'EVELYN TURLINGTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Hunter Creek Estates' ,`TaxAmount` = '22205' ,`TaxRate` = '2.1056' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702511' WHERE `Matrix_Unique_ID` = '206214628' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T14:22:36.103' ,`MLSNumber` = '55965602' ,`ListAgentFullName` = 'Carolyn Bowen' ,`ListOfficeName` = 'Texas Home Team, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.072187' ,`Longitude` = '-94.800743' ,`PhotoCount` = '30' ,`PostalCode` = '77575' ,`RoomCount` = '5' ,`ListPrice` = '214500.00' ,`Status` = 'Active' ,`StreetName` = 'Holly' ,`StreetNumber` = '1520' ,`StreetSuffix` = 'Street' ,`City` = 'Liberty' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1443' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Old Southern Liberty feels like Charleston or Savannah! Canopy of HUGE Oaks, corner lot with room to enlarge. Make the attached garage into master suite and build a dream garage. Plenty room and frontage for that. Newly remodeled and updated with granite countertops, new appliances and updated plumbing. Quiet neighborhood with no neighbors across the street...well maybe a deer now and then. Near schools and old downtown with so many possibilities. Bedrooms are huge. Comfortable home with room to grow.' ,`Acres` = '0.303' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Liberty' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LIBERTY OUTER BLOCKS, BLOCK 2, LOT PT 2 TR 28, 30, ACRES .30' ,`LotDesciption` = 'Corner' ,`LotSize` = '13199' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '73 - Liberty' ,`SchoolElementary` = 'LIBERTY ELEMENTARY SCHOOL (LIBERTY)' ,`SchoolHigh` = 'LIBERTY HIGH SCHOOL (LIBERTY)' ,`SchoolMiddle` = 'LIBERTY MIDDLE SCHOOL (LIBERTY)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Liberty Outer Blocks' ,`TaxAmount` = '4060' ,`TaxRate` = '2.6826' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702511' WHERE `Matrix_Unique_ID` = '206700564' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T14:07:46.650' ,`MLSNumber` = '51861056' ,`ListAgentFullName` = 'Maria Bonilla' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.811751' ,`Longitude` = '-95.371807' ,`PhotoCount` = '47' ,`PostalCode` = '77009' ,`RoomCount` = '3' ,`ListPrice` = '649900.00' ,`Status` = 'Active' ,`StreetName` = 'Sylvester' ,`StreetNumber` = '304' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2323' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Are you are looking for your dream home inside the city? You found it! This Beautiful Custom Home with over $75,000 in upgrades - Only 20 mins from IAH & Hobby airports, 10 mins to Downtown, 13 mins to Memorial Park, 15 mins to Med Center, 5 mins to Houston Farmers Market. Schedule your showing today! This house won’t last long. Prime location with a prime opportunity!\r\nPlease see attached list of all upgrades on this one-of-a-kind house - too many to list here.' ,`Acres` = '0.1025' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 TERRA BETH ON SYLVESTER' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4465' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'JEFFERSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Terra Beth/Sylvester' ,`TaxAmount` = '1875' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663702511' WHERE `Matrix_Unique_ID` = '206946011' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T15:05:23.100' ,`MLSNumber` = '40605692' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.816346' ,`Longitude` = '-95.784454' ,`PhotoCount` = '14' ,`PostalCode` = '77493' ,`RoomCount` = '18' ,`ListPrice` = '599470.00' ,`Status` = 'Active' ,`StreetName` = 'Persimmon Creek' ,`StreetNumber` = '23622' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '4023' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. Seek comfort in this incredible Briarwood home in Morton Creek Ranch. Resting on a lakeside lot, this 4-sided brick home boasts a premium elevation, tile flooring, full gutters, sprinkler system, crown molding, wrought iron spindles, faux wood blinds, cast stone fireplace, study with French doors, spa-like primary suite, and an extended covered patio. Spend all day in the kitchen, complete with Omegastone countertops, double oven, stainless steel appliances, 42” upper cabinets, pendant lighting, and undercabinet lighting. Community amenities include a playground, splash pad, children’s play area, and recreation center with a pavilion. Commuters enjoy close proximity to I-10 and the Grand Parkway. Delve into premier shopping, dining, and entertainment at the nearby Katy Mills Mall and LaCenterra at Cinco Ranch. Zoned to the nationally recognized Katy ISD.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Briarwood Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 11 Block 2' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '598' ,`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` = 'LEONARD ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Morton Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.39' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702512' WHERE `Matrix_Unique_ID` = '206950115' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T14:07:58.100' ,`MLSNumber` = '25840101' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Brian Coyle' ,`SellingOfficeName` = 'HomeSmart' ,`Latitude` = '29.565320' ,`Longitude` = '-95.745638' ,`PhotoCount` = '24' ,`PostalCode` = '77469' ,`RoomCount` = '17' ,`ListPrice` = '638457.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Masterson Garden' ,`StreetNumber` = '23719' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Preston V, Elevation B) CURRENTLY BEING BUILT. Two Story. 5 bedrooms, 4.5 baths. Private Primary Suite with large walk-in closet. Spacious kitchen open to Family Room. Dining Room and Study. Game Room, 4 bedrooms, and 3 bathrooms upstairs. Covered patio and 2 car attached garage. Spanning nearly 600 acres of beautiful homes, lush landscaping, trails, and exciting amenities, Veranda embodies the legacy of historic Richmond with all the comforts of a luxurious master-planned community. Minutes to the newly expanded I-69 and the Grand Parkway, you are near exceptional shopping, dining and recreation. Stop by the Westin Homes model home today to find out more about Veranda!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 18 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8399' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUTCHISON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Veranda' ,`TaxAmount` = '' ,`TaxRate` = '3.22' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702512' WHERE `Matrix_Unique_ID` = '207739781' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T15:48:35.900' ,`MLSNumber` = '53000572' ,`ListAgentFullName` = 'Kelly Turner' ,`ListOfficeName` = 'BSRH Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.795506' ,`Longitude` = '-96.169725' ,`PhotoCount` = '11' ,`PostalCode` = '77474' ,`RoomCount` = '7' ,`ListPrice` = '432300.00' ,`Status` = 'Active' ,`StreetName` = 'Buckhorn' ,`StreetNumber` = '507' ,`StreetSuffix` = 'Street' ,`City` = 'Sealy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2372' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction in Hunters Crossing! Located on a premium lot, this lovely brick & stone 3 bedroom 2 1/2 bath with study, includes a spacious kitchen with granite counter-tops and stainless steel appliances. Wood floors in family, kitchen and dining. The master suite includes an oversized shower and master closet. Secondary bedrooms are spacious and each has its own walk-in closet. Don\'t forget the large covered patio where you can relax and enjoy the fresh country breeze! (Room measurements to be verified by buyer.) Zoned to Sealy Elementary.' ,`Acres` = '' ,`Area` = '57' ,`BuilderName` = '*****' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 15, Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '109 - Sealy' ,`SchoolElementary` = 'SEALY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEALY HIGH SCHOOL' ,`SchoolMiddle` = 'SEALY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hunters Crossing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702512' WHERE `Matrix_Unique_ID` = '208268774' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T14:04:52.137' ,`MLSNumber` = '64516078' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Vincent Oyubu' ,`SellingOfficeName` = 'Delta Realty Company' ,`Latitude` = '29.681029' ,`Longitude` = '-95.838564' ,`PhotoCount` = '30' ,`PostalCode` = '77406' ,`RoomCount` = '18' ,`ListPrice` = '697428.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Halley' ,`StreetNumber` = '10515' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3762' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Carter VI, Elevation F) CURRENTLY BEING BUILT. Two Story. 5 bedrooms, 4.5 baths. Private Primary Suite with spacious double walk-in closets downstairs. Formal Dining Room and Study with Spacious Kitchen and breakfast area open to Family Room. Spacious Game Room upstairs with private Media Room. Extended covered patio and attached 2 car garage. Candela offers new homes for sale in Richmond, Texas. The community is the perfect combination of small-town charm and easy access to big city conveniences. Take a stroll through Downtown Historic Richmond, visit the Imperial Farmer\'s Market and enjoy the great outdoors at Brazos Bend State Park. Major employers in Houston, Katy and Sugar Land are only a short commute away. Great restaurants, and local and big box retail offerings are all close by. Visit Candela today to find your new home!' ,`Acres` = '0.1722' ,`Area` = '37' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BLOCK 1, LOT 33' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BENTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Candela' ,`TaxAmount` = '' ,`TaxRate` = '3.15' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702512' WHERE `Matrix_Unique_ID` = '208362604' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T14:27:06.350' ,`MLSNumber` = '59732773' ,`ListAgentFullName` = 'Ty Robinson' ,`ListOfficeName` = 'Compass RE Texas, LLC-CitiQuest' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.849893' ,`Longitude` = '-94.669040' ,`PhotoCount` = '45' ,`PostalCode` = '77597' ,`RoomCount` = '4' ,`ListPrice` = '574900.00' ,`Status` = 'Active' ,`StreetName` = 'Navajo' ,`StreetNumber` = '328' ,`StreetSuffix` = 'Trail' ,`City` = 'Wallisville' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2762' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEVER FLOODED!! No HOA fees. Welcome Home! This fully remodeled Mid-Century Modern 4 bedroom/ 3 Full bath with huge bonus room features an open floor plan with tons of natural light and huge granite island perfect for hosting family and friends. Each spacious bedroom boasts high ceilings, hardwood beams and walk-in closets plus the primary suite has a soaking tub with gorgeous garden view. Located on a sprawling lot with incredible privacy, mature trees and huge patio, shed and extra parking, this home is perfect for entertaining. Upgrades include new appliances, windows, cabinets, floors, lighting, a/c, paint and fully restored exterior cedar siding, see upgrades attachment.\r\n\r\n15 minutes to HEB, 4 minutes to I-10 Easy commute to Houston or Beaumont. 46 Minutes to Downtown Houston!' ,`Acres` = '1.464' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Chambers County East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 2 BLK 5 INDIAN TRAILS' ,`LotDesciption` = 'Wooded' ,`LotSize` = '63772' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '4 - Anahuac' ,`SchoolElementary` = 'ANAHUAC ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANAHUAC HIGH SCHOOL' ,`SchoolMiddle` = 'ANAHUAC MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Indian Trails Rep' ,`TaxAmount` = '3412' ,`TaxRate` = '2.6602' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663702512' WHERE `Matrix_Unique_ID` = '208710202' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T14:12:53.867' ,`MLSNumber` = '23998990' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Shakil Ahmed' ,`SellingOfficeName` = 'Signature Realty' ,`Latitude` = '29.843297' ,`Longitude` = '-95.860264' ,`PhotoCount` = '31' ,`PostalCode` = '77494' ,`RoomCount` = '16' ,`ListPrice` = '599638.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Sarasota Shore' ,`StreetNumber` = '836' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Fairfax, Elevation AL). CURRENTLY BEING BUILT. Two story. 5 bedrooms. 3.5 baths. Spacious island kitchen open to family room and informal dining. Primary suite with large walk-in closet. Additional first floor bedroom with private bath. First floor study. 3 additional bedrooms, game room and media room on second floor. Covered patio and 2-car garage. Located a few miles north of Interstate 10 and west of the Grand Parkway in thriving Katy, Sunterra is an inviting 1,039-acre master-planned community featuring home designs that fit your lifestyle, Sunterra is a launch pad for family adventures. Splash, play, paddleboard, build sandcastles and more at our gorgeous Crystal Lagoons® amenity. Designed to fit your lifestyle, the master plan calls for approximately 2,200 homes, lakes, parks, playgrounds and an expansive Amenity Village with a clubhouse and a pool overlooking the lagoon. Stop by the Westin Homes sales model to learn more about Sunterra!' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 9 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7323' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.53' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702512' WHERE `Matrix_Unique_ID` = '209031937' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T14:20:14.867' ,`MLSNumber` = '72777257' ,`ListAgentFullName` = 'Dianna Cannan' ,`ListOfficeName` = 'Keller Williams Advntge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.867852' ,`Longitude` = '-95.443886' ,`PhotoCount` = '21' ,`PostalCode` = '77320' ,`RoomCount` = '3' ,`ListPrice` = '80000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 980' ,`StreetNumber` = '1851' ,`StreetSuffix` = 'Road' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '924' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'JUST REDUCED !!!\r\nHere\'s a 3 Bedroom, 2 Bath Manufactured Home on 1/2 Acre Lot. All appliances will remain with the property. This includes a Stove, Refrigerator, Microwave, Washer & Dryer.\r\nThis affordable home would make a perfect starter home, a place to retire, or could also be used as an Investment Property.\r\nCall for an Appointment To See it Today!' ,`Acres` = '' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Riverside (Walker)' ,`HeatSystem` = 'Other Heating,Propane' ,`HOAMandatory` = '0' ,`Legal` = 'ALLEN E (A-1), 14.1 (MH ONLY) TR 14, LABEL# DLS0037711, SN1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'HUNTSVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'n/a' ,`TaxAmount` = '72' ,`TaxRate` = '1.7134' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663702512' WHERE `Matrix_Unique_ID` = '209209019' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T15:42:28.217' ,`MLSNumber` = '6022827' ,`ListAgentFullName` = 'Malachi Goodson' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.152637' ,`Longitude` = '-94.170148' ,`PhotoCount` = '20' ,`PostalCode` = '77708' ,`RoomCount` = '7' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Park North' ,`StreetNumber` = '8225' ,`StreetSuffix` = 'Drive' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2100' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 3/2/2 2100 sq ft new construction home located in Park North.' ,`Acres` = '0.2066' ,`Area` = '51' ,`BuilderName` = 'Rami Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PARK NORTH PHASE II LOT 21 BLOCK 4' ,`LotDesciption` = 'Cleared' ,`LotSize` = '9000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'HOMER DRIVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BEAUMONT UNITED HIGH SCHOOL' ,`SchoolMiddle` = 'KING MIDDLE SCHOOL (BEAUMONT)' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Park North Ph II' ,`TaxAmount` = '143' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702512' WHERE `Matrix_Unique_ID` = '209230559' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T14:39:14.473' ,`MLSNumber` = '13870396' ,`ListAgentFullName` = 'Danielle Martinez' ,`ListOfficeName` = 'Century 21 Olympian Galleria' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.780369' ,`Longitude` = '-95.359511' ,`PhotoCount` = '23' ,`PostalCode` = '77009' ,`RoomCount` = '1' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Fulton' ,`StreetNumber` = '2115' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2248' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This property offers endless opportunities for Owner Occupants, Investors, Developers, and/or Builders. Centrally located to Downtown Houston, next to developing Hardy Yards, EaDo and it\'s vibrant appeal, Historic 6th Ward and is walking distance to the METRO Rail (exactly 0.5 miles). Blocks from St. Arnold\'s Brewery, White Oak Music Hall and 1.5 miles from Minute Maid Park. Did I mention that this property has never flooded and provides easy access to all the major freeways? Don\'t miss this opportunity to live in this rapidly growing Historic neighborhood. Located in Houston\'s East End Revitalization area with Mixtures of New Condos, Restored Homes and Warehouses. Being sold as is. Buyer to independently verify all information. 5,000 sq. ft. lot. There is an uninterrupted view of Downtown and Minute Maid Park from the end of Fulton. Join the evening joggers and dog walkers. No HOA nor MUD tax. Back Two Bedroom Apartment can potentially be a secondary income!' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Seller may be subject to foreign tax and Buyer withholding per IRS,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 13 BLK 58-A ALLEN A C' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KETELSEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Allen A C' ,`TaxAmount` = '5162' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702513' WHERE `Matrix_Unique_ID` = '209604719' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T15:55:17.320' ,`MLSNumber` = '10850592' ,`ListAgentFullName` = 'Charlie Kriegel' ,`ListOfficeName` = 'Winhill Advisors - Kirby' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.792876' ,`Longitude` = '-95.475423' ,`PhotoCount` = '30' ,`PostalCode` = '77055' ,`RoomCount` = '7' ,`ListPrice` = '530000.00' ,`Status` = 'Active' ,`StreetName` = 'Antoine' ,`StreetNumber` = '1302' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Mediterranean-style home located Spring Branch, zoned to Memorial High School. 3 full bedrooms and 3.5 bathrooms welcomes you with open living concept, natural oak hardwood floors, high ceilings and plenty of custom updates installed by the builder. A wonderfully inviting kitchen with Thermador stainless steel appliances, gas range, granite counter tops, tile backsplash, island in the middle, plenty of custom cabinetry, flows into the oversized dining area. Huge primary bedroom with coffered ceilings, recessed lighting, and double doors that lead outside to the Juliet balcony to enjoy your morning coffee. Primary en-suite bathroom was completely remodeled with separate seamless glass stand-up shower, oversized tub, dual vanities, and large walk-in closet. Please note, this home has the support of 15 foundation piers and a 50-year clay tile roof. You are only a minute from I10, which leads you to City Centre, Downtown, and the Galleria. Schedule your virtual open house today!' ,`Acres` = '0.0323' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 1 ANTOINE VILLAS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1405' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '185' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'HOUSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Antoine Villas' ,`TaxAmount` = '11467' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702513' WHERE `Matrix_Unique_ID` = '210161032' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T14:43:42.490' ,`MLSNumber` = '9357899' ,`ListAgentFullName` = 'Jamie McMartin' ,`ListOfficeName` = 'Compass RE Texas, LLCKaty' ,`SellingAgentFullName` = 'Matthew Loschiavo' ,`SellingOfficeName` = 'Mission Real Estate Group' ,`Latitude` = '29.734194' ,`Longitude` = '-95.865507' ,`PhotoCount` = '46' ,`PostalCode` = '77494' ,`RoomCount` = '10' ,`ListPrice` = '631990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Aidens Peak' ,`StreetNumber` = '3803' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3282' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Final Opportunities to purchase in Section 60 zoned to KATY ISD ZONED! D.R. Horton\'s Chloe Floorplan on OVERSIZED LAKE LOT with upgraded Media Room and Refreshment Center Upgrade! ATTACHMENTS SHOW COLOR PACKAGE. \"Smart Home\" all controllable through your Hub or smartphone. Kitchen with Silestone counters, 5 burner range and 42\" Cabinets! A secondary bedroom wing for the kiddos with a study nook. Large covered patio with plumed gas! Included is everything you are looking for in a community- resort pool, splashpad, fitness center, sports fields, lakes & walking trails ready for you! Call today for your own private tour! Please verify with sales agent options and any upgrades. **PHOTOS ARE WHAT YOU CAN EXPECT FROM THE FLOORPLAN! THEY DO NOT SHOW ACTUAL PROPERTY*At this time the builder does not sell to Investors in this neighborhood*' ,`Acres` = '' ,`Area` = '36' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 107; Block 2; Section 60' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '10055' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tamarron' ,`TaxAmount` = '' ,`TaxRate` = '3.17' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702513' WHERE `Matrix_Unique_ID` = '210314858' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T14:41:51.513' ,`MLSNumber` = '66583992' ,`ListAgentFullName` = 'Jamie McMartin' ,`ListOfficeName` = 'Compass RE Texas, LLCKaty' ,`SellingAgentFullName` = 'Koshy Oommen' ,`SellingOfficeName` = 'Worth Clark Realty' ,`Latitude` = '29.734185' ,`Longitude` = '-95.865518' ,`PhotoCount` = '27' ,`PostalCode` = '77494' ,`RoomCount` = '10' ,`ListPrice` = '464990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Ethan Park' ,`StreetNumber` = '3803' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2068' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Final Opportunities to purchase in Section 60 zoned to KATY ISD ZONED! Perfect D.R. Horton Lorenzo Floorplan ON LAKE LOT! ATTACHMENTS SHOW COLOR PACKAGE. \"Smart Home\" all controllable through your Hub or smartphone. Gorgeous Kitchen with Silestone counters and 42\" Cabinets! There is a secondary bedroom wing for the kiddos with a study nook. Large covered patio, ready for week-end BBQ\'s with plumed gas! Included is everything you are looking for in a family friendly community- resort pool, splashpad, fitness center, sports fields, lakes & walking trails ready for you! Call today for your own private tour! Please verify with sales agent options and any upgrades.**PHOTOS ARE WHAT YOU CAN EXPECT FROM THE FLOORPLAN THEY DO NOT SHOW ACTUAL PROPERTY***At this time builder does not sell to Investors in this neighborhood*' ,`Acres` = '' ,`Area` = '36' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 118; Block 2; Section 60' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '8516' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Tamarron' ,`TaxAmount` = '' ,`TaxRate` = '3.17' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702513' WHERE `Matrix_Unique_ID` = '210316376' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T14:38:56.470' ,`MLSNumber` = '26355505' ,`ListAgentFullName` = 'Jamie McMartin' ,`ListOfficeName` = 'Compass RE Texas, LLCKaty' ,`SellingAgentFullName` = 'Paty De la Garza' ,`SellingOfficeName` = 'Keller Williams Premier RealtyKaty' ,`Latitude` = '29.734246' ,`Longitude` = '-95.865485' ,`PhotoCount` = '32' ,`PostalCode` = '77494' ,`RoomCount` = '8' ,`ListPrice` = '463990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Pottharst Park' ,`StreetNumber` = '3819' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2446' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Final Opportunities to purchase in Section 60 zoned to Katy ISD! D.R. Horton\'s perfect Colby model! 4 Bedrooms! 3 Full Baths! Guest Room with private full bath (perfect In-Law suite if needed)! You are going to love this kitchen, 42” cabinets, stainless steel appliances 5 burner gas range AND Double ovens! ATTACHMENTS SHOW COLOR PACKAGE. Gorgeous flooring, backyard with a covered patio and plumbed for gas! Included is everything you are looking for in a community- resort pool, splashpad, fitness center, sports fields, lakes & walking trails all included and ready for you! Please verify with sales agent options and upgrades. **PHOTOS ARE WHAT YOU CAN EXPECT FROM THE FLOORPLAN! THEY DO NOT SHOW ACTUAL PROPERTY***At this time the builder does not sell to Investors in this neighborhood*' ,`Acres` = '' ,`Area` = '36' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 133; Block 2; Section 60' ,`LotDesciption` = 'Cleared,Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8266' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Tamarron' ,`TaxAmount` = '' ,`TaxRate` = '3.21' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702513' WHERE `Matrix_Unique_ID` = '210316732' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T14:36:06.560' ,`MLSNumber` = '31133840' ,`ListAgentFullName` = 'Jamie McMartin' ,`ListOfficeName` = 'Compass RE Texas, LLCKaty' ,`SellingAgentFullName` = 'Yenping Chen' ,`SellingOfficeName` = 'PY Realty Co' ,`Latitude` = '29.734206' ,`Longitude` = '-95.865460' ,`PhotoCount` = '29' ,`PostalCode` = '77494' ,`RoomCount` = '12' ,`ListPrice` = '539990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Halle Ray' ,`StreetNumber` = '28651' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3262' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'KATY ISD ZONED! Perfect D.R. Horton Magnolia Floor plan! 2 Story, 4 bedroom, 3 1/2 bath, Huge Media room. Ready to entertain with a huge Game Room upstairs ready to handle all the fun you bring. Open Kitchen with gorgeous designer 42” kitchen cabinets, 5 burner gas range, and Silestone Counters. Stainless Steel appliances! These are no ordinary rooms sizes! The Primary Bedroom with it\'s luxury Primary Bath & deep walk-in closet are your private oasis. Included is everything you are looking for in the Tamarron community- resort pool, splashpad, fitness center, sports fields, lakes & walking trails all included and ready for you! Call us today for your own private tour! **Pictures are what to expect from the floorplan**At this time the builder does not sell to Investors in this neighborhood*' ,`Acres` = '' ,`Area` = '36' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 70; Block 2; Section 60' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tamarron' ,`TaxAmount` = '' ,`TaxRate` = '3.17' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702513' WHERE `Matrix_Unique_ID` = '210380420' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T14:44:49.600' ,`MLSNumber` = '40221449' ,`ListAgentFullName` = 'Jamie McMartin' ,`ListOfficeName` = 'Compass RE Texas, LLCKaty' ,`SellingAgentFullName` = 'Lola Longe' ,`SellingOfficeName` = 'HomeSmart' ,`Latitude` = '29.734243' ,`Longitude` = '-95.865455' ,`PhotoCount` = '50' ,`PostalCode` = '77494' ,`RoomCount` = '10' ,`ListPrice` = '528990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Aidens Peak' ,`StreetNumber` = '3807' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2926' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Final Opportunities to purchase in Section 60 zoned to KATY ISD ZONED! D.R. Horton\'s Rockdale Floorplan on a HUGE Cul-Du-Sac Lot (see Survey attached)! ATTACHMENTS SHOW COLOR PACKAGE. \"Smart Home\" all controllable through your Hub or smartphone. Gorgeous Kitchen with Silestone counters and 42\" Cabinets! There is a secondary bedroom wing for the kiddos with a study nook. Large covered patio, ready for week-end BBQ\'s with plumed gas! Included is everything you are looking for in a family friendly community- resort pool, splashpad, fitness center, sports fields, lakes & walking trails ready for you! Call today for your own private tour! Please verify with sales agent options and any upgrades. **PHOTOS ARE WHAT YOU CAN EXPECT FROM THE FLOORPLAN! THEY DO NOT SHOW ACTUAL PROPERTY***At this time builder does not sell to Investors in this neighborhood*' ,`Acres` = '' ,`Area` = '36' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 108; Block 2; Section 60' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9004' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tamarron' ,`TaxAmount` = '' ,`TaxRate` = '3.17' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702513' WHERE `Matrix_Unique_ID` = '210380538' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T14:03:01.147' ,`MLSNumber` = '55155260' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Irfan Kadiwal' ,`SellingOfficeName` = 'United Real Estate' ,`Latitude` = '29.571639' ,`Longitude` = '-95.738116' ,`PhotoCount` = '27' ,`PostalCode` = '77469' ,`RoomCount` = '18' ,`ListPrice` = '699957.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Wilkinson' ,`StreetNumber` = '23407' ,`StreetSuffix` = 'Trail' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Carter VII, Elevation F) CURRENTLY BEING BUILT. Two story. 5 bedrooms. 4.5 baths. Family room, formal dining room and study. Spacious island kitchen open to family room. Primary suite with large double walk-in closets and secondary bedroom on first floor. Three additional bedrooms, spacious game room and media room on second floor. Extended covered rear patio and attached 3-car garage. Spanning nearly 600 acres of beautiful homes, lush landscaping, trails, and exciting amenities, Veranda embodies the legacy of historic Richmond with all the comforts of a luxurious master-planned community. Minutes to the newly expanded I-69 and the Grand Parkway, you are near exceptional shopping, dining and recreation. Stop by the Westin Homes model home today to find out more about Veranda!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 14, BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11862' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'PHELAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Veranda' ,`TaxAmount` = '' ,`TaxRate` = '3.22' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702514' WHERE `Matrix_Unique_ID` = '210601910' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T14:00:38.707' ,`MLSNumber` = '14941626' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Lizz Sansone' ,`SellingOfficeName` = 'RE/MAX Fine Properties' ,`Latitude` = '29.806579' ,`Longitude` = '-95.837459' ,`PhotoCount` = '27' ,`PostalCode` = '77493' ,`RoomCount` = '18' ,`ListPrice` = '664847.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Eden Terrace' ,`StreetNumber` = '6602' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3762' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Carter VI, Elevation B) CURRENTLY BEING BUILT. Two Story. 5 bedrooms, 4.5 baths. Private Primary Suite with spacious double walk-in closets downstairs. Formal Dining Room and Study with Spacious Kitchen and breakfast area open to Family Room. Spacious Game Room upstairs with private Media Room. Extended covered patio and attached 3 car garage. Located in the heart of Katy and minutes from the Grand Parkway and I-10, the Falls at Green Meadows is Katy’s premiere Community! Residents of the Falls at Green Meadows can enjoy the Community Recreation Center that features a crystal-blue pool and outdoor patio area. Other amenities include sparkling lakes, meandering walking trails, and a playground. Stop by the Westin Homes model home today to find out more about the Falls at Green Meadows!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 6 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14665' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'KATY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Falls at Green Meadows' ,`TaxAmount` = '' ,`TaxRate` = '3.48' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702514' WHERE `Matrix_Unique_ID` = '210641901' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T14:11:23.873' ,`MLSNumber` = '3758924' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Brume Akpomreta' ,`SellingOfficeName` = 'Jerry Fullerton Realty, Inc.' ,`Latitude` = '29.681740' ,`Longitude` = '-95.836917' ,`PhotoCount` = '24' ,`PostalCode` = '77406' ,`RoomCount` = '16' ,`ListPrice` = '589547.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Rigel Ridge' ,`StreetNumber` = '10534' ,`StreetSuffix` = 'Way' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3136' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Albany, Elevation H) CURRENLTY BEING BUILT. Two story. 4 bedrooms. 3.5 baths. Family room, study and formal dining room. Spacious island kitchen open to family room. Primary suite with large walk-in closet. Three additional bedrooms, spacious game room and media room on second floor. Covered patio and attached 2-car garage. Candela offers new homes for sale in Richmond, Texas. The community is the perfect combination of small-town charm and easy access to big city conveniences. Take a stroll through Downtown Historic Richmond, visit the Imperial Farmer\'s Market and enjoy the great outdoors at Brazos Bend State Park. Major employers in Houston, Katy and Sugar Land are only a short commute away. Great restaurants, and local and big box retail offerings are all close by. Visit Candela today to find your new home!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 43 BLK 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7118' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BENTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Candela' ,`TaxAmount` = '' ,`TaxRate` = '3.15' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702514' WHERE `Matrix_Unique_ID` = '211231882' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T15:14:28.943' ,`MLSNumber` = '28998468' ,`ListAgentFullName` = 'Morgan McMorris' ,`ListOfficeName` = 'John A. Griffin Company' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.712546' ,`Longitude` = '-95.367538' ,`PhotoCount` = '14' ,`PostalCode` = '77004' ,`RoomCount` = '3' ,`ListPrice` = '433000.00' ,`Status` = 'Active' ,`StreetName` = 'Binz' ,`StreetNumber` = '3236' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2406' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Attention remodeling enthusiasts looking to polish this gem and add some nice touches, this is the property for you. Home near Texas Medical Center and in the heart of the city. ' ,`Acres` = '0.1641' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Riverside' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 9 & TR 8 BLK 2 NORTH MACGREGOR OAKS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOCKHART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Lockbox Back,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'North Macgregor Oaks' ,`TaxAmount` = '8309' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1941' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702514' WHERE `Matrix_Unique_ID` = '211413368' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T15:42:06.270' ,`MLSNumber` = '52265979' ,`ListAgentFullName` = 'Malachi Goodson' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.058791' ,`Longitude` = '-94.203767' ,`PhotoCount` = '21' ,`PostalCode` = '77707' ,`RoomCount` = '7' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Shirley' ,`StreetNumber` = '1790' ,`StreetSuffix` = 'Circle' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2410' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Totally remodeled two story home situated on a corner lot in Beaumont\'s Washington West. This home is very spacious and all electric. Large living room and den make this the perfect home for entertaining. Stove, dishwasher and microwave is included. The kitchen and all bathrooms have granite countertops. The master bathroom has a garden tub, separate shower, dual vanities and a large walk in closet. This is a home you do not want to miss!' ,`Acres` = '0.1928' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WESTCALDER EST L18 B2' ,`LotDesciption` = 'Cleared' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'DISHMAN ELEMENTARY SCHOOL (BEAUMONT)' ,`SchoolHigh` = 'WEST BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'VINCENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'West Calder Estates' ,`TaxAmount` = '3862' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702514' WHERE `Matrix_Unique_ID` = '211425528' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T15:21:26.730' ,`MLSNumber` = '8549918' ,`ListAgentFullName` = 'William Onye' ,`ListOfficeName` = 'PRG, Realtors' ,`SellingAgentFullName` = 'Christian Reyes' ,`SellingOfficeName` = 'Texas Prominent Realty, Inc.' ,`Latitude` = '29.864505' ,`Longitude` = '-95.718313' ,`PhotoCount` = '7' ,`PostalCode` = '77449' ,`RoomCount` = '11' ,`ListPrice` = '264900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Cannon Fire' ,`StreetNumber` = '19811' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2908' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this great 2 story home with large primary down. 4 secondary bedrooms and large gameroom upstairs. The owners are newly empty nesters and are moving. The home has a huge backyard with plenty of room for great outdoor entertaining. Home is priced for condition and sold in present condition. Great location. Cy-Fair schools. Easy commute to all freeways.' ,`Acres` = '0.1158' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 3 BEAR CREEK MEADOWS SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5045' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '435' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HEMMENWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bear Crk Mdws Sec 03' ,`TaxAmount` = '6231' ,`TaxRate` = '2.671' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702514' WHERE `Matrix_Unique_ID` = '211475826' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T14:54:42.490' ,`MLSNumber` = '68706732' ,`ListAgentFullName` = 'Jose Zavala' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.033640' ,`Longitude` = '-95.415513' ,`PhotoCount` = '19' ,`PostalCode` = '77073' ,`RoomCount` = '12' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Burnwood' ,`StreetNumber` = '911' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2467' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come and see this beautiful 4 bedroom home with 2.5 baths and an a 2 car detached garage on an entrance to a culdesac. As you walk into the home on the right side of the home there is a big living/family room ready for your family to enjoy. It has a dining room to the left front side of the home with the kitchen and breakfast area directly behind it. The upstairs of the home has 4 bedrooms. The master bedroom is very spacious and has mare than enough room to put a very good size bedroom set. The master bath is also very spacious with a double sink to give you pleanty of elbow room. The back of the home has a deck as you walk out side with a very big and beautiful yard. There are some very well spaced trees that give you natural beauty and plenty of shade. Come and make this home yours before it is gone.' ,`Acres` = '0.191' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 6 INVERNESS FOREST SEC 4' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '8320' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '675' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'DUNN ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'LEWIS MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Inverness Forest Sec 04' ,`TaxAmount` = '4692' ,`TaxRate` = '2.5234' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702514' WHERE `Matrix_Unique_ID` = '211495303' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T15:19:28.563' ,`MLSNumber` = '92216502' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Nicole Freer' ,`SellingOfficeName` = 'NICOLE FREER GROUP' ,`Latitude` = '29.843652' ,`Longitude` = '-95.860231' ,`PhotoCount` = '34' ,`PostalCode` = '77493' ,`RoomCount` = '16' ,`ListPrice` = '574847.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Sarasota Shore' ,`StreetNumber` = '847' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3221' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Bailey III, Elevation D) CURRENTLY BEING BUILT. Two story. 4 bedrooms. 3.5 baths. Family room, Formal Living room/Study and Formal Dining room. Spacious island kitchen open to Family room. Primary suite with large walk in closet. Three additional bedrooms and spacious Game room and Media room on second floor. Covered patio and attached 2 car garage. Located a few miles north of Interstate 10 and west of the Grand Parkway in thriving Katy, Sunterra is an inviting 1,039-acre master-planned community featuring home designs that fit your lifestyle, Sunterra is a launch pad for family adventures. Splash, play, paddleboard, build sandcastles and more at our gorgeous Crystal Lagoons® amenity. Designed to fit your lifestyle, the master plan calls for approximately 2,200 homes, lakes, parks, playgrounds and an expansive Amenity Village with a clubhouse and a pool overlooking the lagoon. Stop by the Westin Homes sales model to learn more about Sunterra!' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 21 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8190' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.53' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702515' WHERE `Matrix_Unique_ID` = '211532177' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T14:20:48.543' ,`MLSNumber` = '82519561' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Michelle Garcia' ,`SellingOfficeName` = 'BHGRE Gary Greene' ,`Latitude` = '29.876514' ,`Longitude` = '-95.793135' ,`PhotoCount` = '29' ,`PostalCode` = '77493' ,`RoomCount` = '12' ,`ListPrice` = '454635.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Winterberry Glen' ,`StreetNumber` = '7030' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2425' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Haven, Elevation A) CURRENTLY BEING BUILT. Two story. 4 bedrooms. 3 baths. Spacious island kitchen open to informal dining room and family room. Primary suite with large walk-in closet as well as secondary bedroom on first floor. Spacious game room upstairs. Covered patio and attached 2 car garage. Just minutes from the Grand Parkway, Elyson is located in the Heart of Katy! The Elyson Café is the center of this community and offers a full food and drinks menu plus a coffee bar. Community amenities also include a pool, fitness center, game room, event lawn, tennis courts, parks and trails, and so much more. Stop by the Westin Homes model to learn more about Elyson!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 41 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6116' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1242' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Elyson' ,`TaxAmount` = '' ,`TaxRate` = '3.4' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702515' WHERE `Matrix_Unique_ID` = '211624079' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T14:42:18.940' ,`MLSNumber` = '71596464' ,`ListAgentFullName` = 'Sue Crow' ,`ListOfficeName` = 'Full Stringer Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.786550' ,`Longitude` = '-95.650783' ,`PhotoCount` = '15' ,`PostalCode` = '77414' ,`RoomCount` = '4' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Seagull' ,`StreetNumber` = '95' ,`StreetSuffix` = '' ,`City` = 'Bay City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '1137' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A charming place, off-water but good views of wide open Sargent spaces in back, creek view front. and features front screened porch. Open concept Living, Dining and Gourmet Kitchen, featuring granite island seated bar, Jenn-aire Gas cooktop, lots of cabinets stainless dishwasher, oven and Refrigerator/freezer combination. Nice Bedroom, and Family Room that can be converted to 2nd Bedroom. Primary Bathroom features large walk-in shower with granite bench.Laundry room complete with washer/dryer and storage closet. Off Family room is 2nd screened porch. A portion of the garage has been converted to 2 bedroom bunk space with large gathering area and full bath. 4 Large Landscaped lots offer lots of space for family fun times.' ,`Acres` = '0.473' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'DOWNEY CANEY CREEK SEC 7, LOT 72-75' ,`LotDesciption` = 'Cleared' ,`LotSize` = '20605' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '48' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '134 - Van Vleck' ,`SchoolElementary` = 'VAN VLECK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'VAN VLECK HIGH SCHOOL' ,`SchoolMiddle` = 'O H HERMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Downey Caney Creek' ,`TaxAmount` = '3740' ,`TaxRate` = '2.3895' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702515' WHERE `Matrix_Unique_ID` = '211661670' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T15:51:00.490' ,`MLSNumber` = '75437969' ,`ListAgentFullName` = 'Nicholas Meador' ,`ListOfficeName` = 'Coldwell Banker RealtyThe Willis Office' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.525191' ,`Longitude` = '-94.803489' ,`PhotoCount` = '13' ,`PostalCode` = '77351' ,`RoomCount` = '4' ,`ListPrice` = '90000.00' ,`Status` = 'Active' ,`StreetName` = 'Sally Mayes' ,`StreetNumber` = '389' ,`StreetSuffix` = 'Drive' ,`City` = 'Livingston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '776' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A Wild Country Getaway! Uniquely situated house and associated structures located on a quiet cull-de-sac in Wild Country Lake Estates. This waterfront property with old growth trees is an ideal weekend getaway or other option. Comfortable distance to Lake Livingston, Cleveland, National Forest, and a little over an hour to Houston, Huntsville, and Lufkin. The property resides on a small lake and is covered with beautiful woods. A perfectly balanced eco-space that must be seen to be appreciated!' ,`Acres` = '1.0652' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Livingston Area' ,`HeatSystem` = 'Space Heater' ,`HOAMandatory` = '1' ,`Legal` = 'WILD COUNTRY LAKES ESTATES SECTION 6 LOT 66 THRU 70' ,`LotDesciption` = 'Wooded' ,`LotSize` = '46400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wild Country Lakes Estates Sec' ,`TaxAmount` = '730' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702515' WHERE `Matrix_Unique_ID` = '211683111' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T15:35:25.410' ,`MLSNumber` = '15937271' ,`ListAgentFullName` = 'Kevin Duc Nguyen' ,`ListOfficeName` = 'ABSOLUTE Realty Group Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.614737' ,`Longitude` = '-95.230113' ,`PhotoCount` = '35' ,`PostalCode` = '77089' ,`RoomCount` = '3' ,`ListPrice` = '215000.00' ,`Status` = 'Active' ,`StreetName` = 'Seaford' ,`StreetNumber` = '10623' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1102' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This house is near major highways and grocery stores. This 3 bedrooms and 2 baths are very cozy. It is also a good investment for rental because of no HOA. \r\n\r\nThe vinyl and tile are through the floor.' ,`Acres` = '0.1653' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 22 BLK 20 BEVERLY HILLS SEC 6 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Slate' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'BEVERLYHILLS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Beverly Hills Sec 06 R/P' ,`TaxAmount` = '3338' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702515' WHERE `Matrix_Unique_ID` = '211711024' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T15:34:26.037' ,`MLSNumber` = '17226939' ,`ListAgentFullName` = 'Maria Giovinale' ,`ListOfficeName` = 'RE/MAX Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.161795' ,`Longitude` = '-95.151163' ,`PhotoCount` = '5' ,`PostalCode` = '77357' ,`RoomCount` = '4' ,`ListPrice` = '289900.00' ,`Status` = 'Active' ,`StreetName` = 'Galaxy' ,`StreetNumber` = '19241' ,`StreetSuffix` = 'Boulevard' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 19241 Galaxy Blvd!! This gorgeous new construction home is surrounded by beautiful green scenarios and located inside a very peaceful and quiet neighborhood. The house has 10’ ceilings in the kitchen and living areas and an open concept floorplan which integrates perfectly all the common areas making it perfect for entertaining. The kitchen is equipped with 42” upper cabinets, a large functional kitchen island and granite countertops. The bedrooms have large and spacious walk-in closets. It comes with the Samsung Stainless Steel package including easy clean top range with electric oven, 3 racks dishwasher and microwave. Buyer will obtain 1 year warranty on appliances from Samsung. Come and see this beautiful home!' ,`Acres` = '0.39' ,`Area` = '40' ,`BuilderName` = 'Starter Homes of Tex' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'KINGS COLONY 01, BLOCK 2, LOT 26, ACRES 0.390' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '16988' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '180' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'DOGWOOD ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = '' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kings Colony 01' ,`TaxAmount` = '18' ,`TaxRate` = '2.1331' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702515' WHERE `Matrix_Unique_ID` = '211761035' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T15:22:50.577' ,`MLSNumber` = '56371864' ,`ListAgentFullName` = 'Dora Lopez' ,`ListOfficeName` = 'RE/MAX Associates Northeast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.264219' ,`Longitude` = '-94.889009' ,`PhotoCount` = '11' ,`PostalCode` = '77327' ,`RoomCount` = '8' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 2309' ,`StreetNumber` = '312' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1870' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Must see this well kept home on over 2 acres located in Tarkington ISD. The original garage was turned into a large den also with added attached carport and laundry room with lots of storage cabinets. The 2 acre lot is cleared so there is plenty of room to add on, build a shop, RV cover or even do a little gardening. Personal well, and onsite conventional sewer. Propane tank on site supplies the gas range, Heating furnace and hot water heater. Home has never flood per previous owners. This property is far enough out to be in the country but still within a short drive to Cleveland and shopping areas.' ,`Acres` = '2.13' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Liberty County East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = '000329 M E PULIDO, Tract 8 Acres 2.13' ,`LotDesciption` = 'Cleared' ,`LotSize` = '92783' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '102 - Tarkington' ,`SchoolElementary` = 'TARKINGTON PRIMARY SCHOOL' ,`SchoolHigh` = 'TARKINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'TARKINGTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Call Occupant,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'M E Pulido' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702516' WHERE `Matrix_Unique_ID` = '211762894' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T14:08:30.530' ,`MLSNumber` = '12965547' ,`ListAgentFullName` = 'Debra Headrick' ,`ListOfficeName` = 'RE/MAX All Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.101889' ,`Longitude` = '-94.189339' ,`PhotoCount` = '34' ,`PostalCode` = '77713' ,`RoomCount` = '6' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Bluebonnet' ,`StreetNumber` = '7996' ,`StreetSuffix` = '' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come check out this beautiful well maintained house in Beaumont\'s west end. Open concept kitchen opens to the living room and breakfast/dining area. Master bedroom has shower, jet tub and double sink with large walk in closet. There is tons of natural light throughout the house. Sellers just replaced the Floor in all 3 bedrooms. They also enclosed the porch into study/office area which is not including the sq. Footage. it. The attic has flooring and plenty of storage space. A must see!!' ,`Acres` = '' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ORCHID ESTATES LOT 2' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'REGINAL-HOWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WEST BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL (BEAUMONT)' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Orchid Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702516' WHERE `Matrix_Unique_ID` = '211765694' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T15:26:56.740' ,`MLSNumber` = '64619236' ,`ListAgentFullName` = 'James Townsend' ,`ListOfficeName` = 'My Castle Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.248094' ,`Longitude` = '-95.853394' ,`PhotoCount` = '27' ,`PostalCode` = '77484' ,`RoomCount` = '8' ,`ListPrice` = '672000.00' ,`Status` = 'Active' ,`StreetName` = 'Royal Oak' ,`StreetNumber` = '17531' ,`StreetSuffix` = 'Court' ,`City` = 'Waller' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3100' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Country living at it’s best! 1.5 acre CUL DE SAC home available in Plantation Lakes. Quiet and serene neighborhood that boasts private fishing lakes, equestrian riding trails, day stables, private clubhouse, community pavilion with outdoor picnic tables and fire pits, private parks and children’s play area. LOW tax rate. No MUD taxes; public water/sewer. Lot is partially cleared. NO FLOODING HERE. Short drive to Magnolia, Tomball and The Woodlands. Come check it out!' ,`Acres` = '1.5' ,`Area` = '60' ,`BuilderName` = 'Drewry Commercial Se' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Plantersville Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'PLANTATION LAKES, SEC 3, BLOCK 1, LOT 34, ACRES 1.500' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Wooded' ,`LotSize` = '65340' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '210' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '129 - Navasota' ,`SchoolElementary` = 'HIGH POINT ELEMENTARY SCHOOL (Navasota)' ,`SchoolHigh` = 'NAVASOTA HIGH SCHOOL' ,`SchoolMiddle` = 'NAVASOTA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Plantation Lakes Sec 3' ,`TaxAmount` = '772' ,`TaxRate` = '1.7749' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702516' WHERE `Matrix_Unique_ID` = '211768906' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T14:29:00.460' ,`MLSNumber` = '35274408' ,`ListAgentFullName` = 'Scott Laird' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.381749' ,`Longitude` = '-95.306603' ,`PhotoCount` = '36' ,`PostalCode` = '77303' ,`RoomCount` = '8' ,`ListPrice` = '460312.00' ,`Status` = 'Active' ,`StreetName` = 'Crosby' ,`StreetNumber` = '16645' ,`StreetSuffix` = 'Street' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2174' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Make way for a little elbow room!!! NEW HOME OPPORTUNITY located on 1 ACRE LOT and just minutes from Lake Conroe and the upcoming HEB shopping center just minutes away! Enjoy a quick commute to The Woodlands with easy access to I-45. This 5 bed, 3 bath home w/ 3-CAR GARAGE is a must have!! Featuring -- an OPEN family room with HIGH 12\' ceilings and LUXURY vinyl plank flooring throughout! GOURMET granite island kitchen with breakfast bar, stainless steel appliances, TONS of cabinet space and breakfast nook! PRIVATE primary retreat with DUAL granite vanity, separate glass shower + soaking tub and WALK-IN closet! SPACIOUS secondary bedrooms AND formal dining!! GORGEOUS brick & stone elevation with front porch! Covered back patio with plenty of backyard space for entertaining all year round! Community features a super low TAX RATE and LOW HOA dues!' ,`Acres` = '1' ,`Area` = '19' ,`BuilderName` = 'First America Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Deer Pines 03, Block 1, Lot 12' ,`LotDesciption` = 'Cleared' ,`LotSize` = '43800' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Deer Pines' ,`TaxAmount` = '' ,`TaxRate` = '1.94' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702516' WHERE `Matrix_Unique_ID` = '211771877' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T14:27:52.417' ,`MLSNumber` = '98185144' ,`ListAgentFullName` = 'Helen Noble' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.260956' ,`Longitude` = '-95.826229' ,`PhotoCount` = '15' ,`PostalCode` = '77444' ,`RoomCount` = '3' ,`ListPrice` = '115000.00' ,`Status` = 'Active' ,`StreetName` = 'Birchmont' ,`StreetNumber` = '20402' ,`StreetSuffix` = 'Drive' ,`City` = 'Guy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '938' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WHERE WILDLIFE STILL ABOUNDS! THIS CHARMING 3 BEDROOM, 2 FULL BATHROOM HOME ON 3 LOTS, JUST A BIT OVER 1/2 AN ACRE OF PARK-LIKE SETTING. THE LARGE TREES ON THE PROPERTY PROVIDE AMPLE SHADE. THE FENCED AREA IS READY FOR YOUR PET, AND THE BACK DECK IS READY FOR AN EVENING OF RELAXATION. INSIDE THE HOME, YOU WILL FEEL THE WARM AND INVITING ATMOSPHERE. JUST A FEW OF THE MANY UPDATES INCLUDE: HVAC (LESS THAN A YEAR OLD), ROOF, APPLIANCES, WOOD CABINETS, FLOORING, EXTRA INSULATION, REINFORCED INNER WALLS AND AEROBIC SEPTIC. CALL NOW FOR MORE INFORMATION OR TO SCHEDULE AN APPOINTMENT TO VIEW THIS HOME.' ,`Acres` = '0.675' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TWIN LAKES (120 WM PRATER) BLK 6 LOT 293-294-295 ACRES .675' ,`LotDesciption` = 'Cleared' ,`LotSize` = '29403' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '14 - Damon' ,`SchoolElementary` = 'DAMON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAMON HIGH SCHOOL' ,`SchoolMiddle` = 'DAMON ELEMENTARY SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Twin Lakes 120 Wm Prater' ,`TaxAmount` = '394' ,`TaxRate` = '1.5443' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702516' WHERE `Matrix_Unique_ID` = '211775630' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T14:27:24.117' ,`MLSNumber` = '1051978' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.832673' ,`Longitude` = '-95.855734' ,`PhotoCount` = '19' ,`PostalCode` = '77493' ,`RoomCount` = '3' ,`ListPrice` = '376690.00' ,`Status` = 'Active' ,`StreetName` = 'Sunrise Gables' ,`StreetNumber` = '1545' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1620' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FANTASTIC NEW D. R. HORTON BUILT 1 STORY 4 BEDROOM! Incredible Features Abound: High Ceilings, Luxury Vinyl Plank Wood-Look Flooring, Stainless Appliances with 5 Burner Cooktop, Black & White Granite Countertops, White Subway Tile Backsplash & 42\" White Kitchen Cabinetry with Under Cabinet Lighting, Primary Bath with Separate Tub & Shower, Tankless Water Heater, Oversized Covered Patio, & Full Sprinkler System! WOW! Open Concept Interior Design with Island Kitchen Open to Spacious Dining & Living Areas! Privately Located Primary Suite with Pretty Garden Bath & Walk-In Closet! Indoor Utility Room! Zoned to Katy ISD Schools! Unbelievable Community with Crystal Lagoon & Amenity Center with Clubhouse, Playground, Trails, Pool, PLUS MORE! Easy Access to the Grand Parkway! Estimated Completion - February 2023.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '12/1/15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702516' WHERE `Matrix_Unique_ID` = '211778521' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T14:44:06.763' ,`MLSNumber` = '49726313' ,`ListAgentFullName` = 'Michael Silva' ,`ListOfficeName` = 'Happen Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.825238' ,`Longitude` = '-95.448263' ,`PhotoCount` = '42' ,`PostalCode` = '77018' ,`RoomCount` = '9' ,`ListPrice` = '1325000.00' ,`Status` = 'Active' ,`StreetName` = 'Althea' ,`StreetNumber` = '2010' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3696' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*PLEASE BE SURE TO VISIT OUR BUILDER SHOWCASE ON 8/07 FROM 2-4 PM AT 2011 ALTHEA* Harvard Homes’ latest new construction offers expansive front and back porches, and an open concept interior. Carefully-curated interior is awash with custom elements, featuring stain hardwoods, vaulted and coffered ceilings, designer wallpapers, and light fixtures from brands like Visual Comfort, Rejuvenation and McGee & Co. Well-executed floor plan melds open concept with organically designated spaces, lending to both entertaining and everyday living. A private office work station overlooks the backyard oasis, and an oversized 1st-floor living room next to your private wet bar completes the downstairs, while 4 bedrooms and a game room round out the 2nd level. Outdoors, the covered porch with summer kitchen transitions you to your ideal backdrop for outdoor enjoyment with ample green space for pets, play, or a pool. Completion is expected in early 2023.' ,`Acres` = '0.1685' ,`Area` = '9' ,`BuilderName` = 'Harvard Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 16 BLK 8 OAK FOREST SEC 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7340' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'STEVENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Forest' ,`TaxAmount` = '7829' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702516' WHERE `Matrix_Unique_ID` = '211779773' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T14:46:46.500' ,`MLSNumber` = '20870668' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.832216' ,`Longitude` = '-94.839897' ,`PhotoCount` = '42' ,`PostalCode` = '77523' ,`RoomCount` = '12' ,`ListPrice` = '650990.00' ,`Status` = 'Active' ,`StreetName` = 'Gretzky' ,`StreetNumber` = '13927' ,`StreetSuffix` = 'Drive' ,`City` = 'Mont Belvieu' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4052' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous brick and stone executive home built for entertaining with a large covered patio and 2nd-floor balcony. Enter through the 8 ft. mahogany leaded glass front door into an expansive 2-story entry with a sweeping circular staircase with stained treads & painted risers. The kitchen was designed for a chef in mind with 54\" high shaker style cabinetry, a wood cabinet range hood above a 36\"-5 burner gas cooktop, a large walk-in pantry, a butler\'s pantry & GE stainless steel built-in appliances. The fireplace in the family room is surrounded by floor-to-ceiling stone. The oversized master bedroom has an equally large master bath with his & her closets, a deep soaking tub, a walk-in shower with a seat, & separate vanities. There are 4 larger than average secondary bedrooms, 2 full bathrooms, a large game room with an 8\' x 32\' walk-out balcony & media room. Window blinds, garage door opener, security system, fully sodded front, sides and rear yard w/a full sprinkler system are included!' ,`Acres` = '0.2238' ,`Area` = '53' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 38, Block 2, Section 2' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '9750' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL NORTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL NORTH MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Reserve of Champions Estates' ,`TaxAmount` = '' ,`TaxRate` = '2.1606' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702517' WHERE `Matrix_Unique_ID` = '211780096' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T14:51:34.360' ,`MLSNumber` = '73524167' ,`ListAgentFullName` = 'Michael Silva' ,`ListOfficeName` = 'Happen Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.825291' ,`Longitude` = '-95.448650' ,`PhotoCount` = '45' ,`PostalCode` = '77018' ,`RoomCount` = '9' ,`ListPrice` = '1325000.00' ,`Status` = 'Active' ,`StreetName` = 'Althea' ,`StreetNumber` = '2018' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3784' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Harvard Homes’ latest new construction offers an expansive open floor plan, oversized backyard layout, and a carefully-curated interior that is awash with custom elements, featuring sand & stain hardwoods, designer wallpapers, and light fixtures from brands like Visual Comfort, Rejuvenation, and McGee & Co.’s Well-executed floor plan melds open concept with organically designated spaces, lending to both entertaining and everyday living. A private office is nestled next to a first-story full bathroom offering double access for functionality, while the oversized 1st-floor living room sits next to your private wet bar completing the downstairs level. Upstairs boasts 4 spacious bedrooms and a game room rounds out the 2nd level. Outdoors, the covered porch, and oversized backyard transition you to your ideal backdrop for outdoor enjoyment with ample green space on the 7,514 sqft lot.' ,`Acres` = '0.1787' ,`Area` = '9' ,`BuilderName` = 'Harvard Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 18 BLK 8 OAK FOREST SEC 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7514' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'STEVENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Forest' ,`TaxAmount` = '7206' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702517' WHERE `Matrix_Unique_ID` = '211780304' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T15:10:44.200' ,`MLSNumber` = '88740012' ,`ListAgentFullName` = 'Derek Boles' ,`ListOfficeName` = 'Legacy Homes & Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.659215' ,`Longitude` = '-95.530172' ,`PhotoCount` = '13' ,`PostalCode` = '77031' ,`RoomCount` = '3' ,`ListPrice` = '249999.00' ,`Status` = 'Active' ,`StreetName` = 'Torcello' ,`StreetNumber` = '8708' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1356' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Recently built townhome in a flourishing gated community. This home is gently lived in and will feel like new when you come to visit. Located at the end of the street for additional privacy. Spacious downstairs area with an updated kitchen. Upstairs hold 3 generous sized bedrooms and no back neighbors. Community is tucked away with little traffic. This is a great option for anyone looking to have a peaceful property as your next residence.' ,`Acres` = '0.0458' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 1 VENETIAN LUXURY HOMES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1994' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'VALLEY WEST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHARPSTOWN HIGH SCHOOL' ,`SchoolMiddle` = 'WELCH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Venetian Luxury Homes' ,`TaxAmount` = '4170' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702517' WHERE `Matrix_Unique_ID` = '211781021' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T15:02:26.327' ,`MLSNumber` = '39271173' ,`ListAgentFullName` = 'Michael Silva' ,`ListOfficeName` = 'Happen Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.823516' ,`Longitude` = '-95.437605' ,`PhotoCount` = '49' ,`PostalCode` = '77018' ,`RoomCount` = '10' ,`ListPrice` = '1595000.00' ,`Status` = 'Active' ,`StreetName` = 'Woodcrest' ,`StreetNumber` = '1434' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '4404' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*PLEASE BE SURE TO VISIT OUR BUILDER SHOWCASE ON 8/13 FROM 2-4 PM AT 2011 ALTHEA* Nestled on one of Oak Forest\'s most coveted blocks, this home built by Harvard Homes features stylish design w/ pieces from Rejuvenation, Visual Comfort & Phillip Jeffries as well as a well thought out floor plan & today\'s best building practices. Lush landscape ornaments painted brick & crank-out casement windows. Gutters tie into the French drain system maximizing optimal drainage. A solid wood door w/ a glass window leads to a wide foyer that serves as the spine of the home, delivering you into the sun-drenched main artery. Custom kitchen w/ designer cabinet accents & hand-selected hardware is set next to the formal dining area. Large living room w/ built-in shelving flanking a gas fireplace w/ custom surround.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Harvard Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 29 BLK 21 OAK FOREST SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7192' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'OAK FOREST ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Forest' ,`TaxAmount` = '9442' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702517' WHERE `Matrix_Unique_ID` = '211781234' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T15:08:01.967' ,`MLSNumber` = '7312023' ,`ListAgentFullName` = 'Michael Silva' ,`ListOfficeName` = 'Happen Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.823902' ,`Longitude` = '-95.426645' ,`PhotoCount` = '45' ,`PostalCode` = '77018' ,`RoomCount` = '9' ,`ListPrice` = '1549000.00' ,`Status` = 'Active' ,`StreetName` = '41st' ,`StreetNumber` = '1039' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '4324' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Harvard Homes’ latest new construction offers expansive front and back porches, an open concept interior that will be dressed with classic Cape Cod finishes. Carefully-curated interior is awash with custom elements, featuring sand & stain hardwoods, vaulted and coffered ceilings, designer wallpapers, and light fixtures from brands like Visual Comfort, Rejuvination and McGee & Co. Well-executed floor plan melds open concept with organically designated spaces, lending to both entertaining and everyday living. A private office work station with an additional study, and an oversized 1st-floor living room next to your private wet bar complete the downstairs, while 4 bedrooms and a game room round out the 2nd level. Outdoors, the covered porch with summer kitchen transitions you to your ideal backdrop for outdoor enjoyment with ample green space for pets, play, or a pool on the 9,000 sf lot.' ,`Acres` = '0.2066' ,`Area` = '9' ,`BuilderName` = 'Harvard Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Garden Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 10 BLK 49 GARDEN OAKS SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GARDEN OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Garden Oaks' ,`TaxAmount` = '9797' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702517' WHERE `Matrix_Unique_ID` = '211781688' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T15:58:47.697' ,`MLSNumber` = '43306754' ,`ListAgentFullName` = 'Lily Nguyen' ,`ListOfficeName` = 'B & W Realty Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.588834' ,`Longitude` = '-95.224440' ,`PhotoCount` = '25' ,`PostalCode` = '77089' ,`RoomCount` = '6' ,`ListPrice` = '274999.00' ,`Status` = 'Active' ,`StreetName` = 'Sagewillow' ,`StreetNumber` = '11215' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1876' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your future home sweet home! This gorgeous home has been fully remodeled featuring 4 bedrooms and two full baths. This home also has a formal dining room area and huge living room for family and guests. Tile flooring throughout with NO CARPET, cool toned color paints and texture. Kitchen has wood cabinetry and updated with granite countertops. Fully fenced backyard with a patio for lounging. Too many to mention, please see List of upgrades attached. Closed to schools, shopping, and restaurants. Make it yours ASAP!' ,`Acres` = '0.1629' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 25 BLK 43 SAGEMONT SEC 8' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7095' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'FRAZIER ELEMENTARY SCHOOL (PASADENA)' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'THOMPSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sagemont Sec 08' ,`TaxAmount` = '3939' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702517' WHERE `Matrix_Unique_ID` = '211782570' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T15:26:35.133' ,`MLSNumber` = '34088120' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'KB Home Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.999494' ,`Longitude` = '-95.501460' ,`PhotoCount` = '36' ,`PostalCode` = '77068' ,`RoomCount` = '11' ,`ListPrice` = '339995.00' ,`Status` = 'Active' ,`StreetName` = 'Shady Palmetto' ,`StreetNumber` = '4022' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2372' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Settle down in this wonderful KB Home in Cypress Creek Landing, boasting a beautiful brick front and a spacious, open great room. Prepare incredible feasts in the kitchen, fully equipped with granite countertops, stainless steel Energy Star® appliances, and 42-in. cabinets. The primary suite is ideal for relaxation, complete with extended dual vanities and a tub with a Moen Chateau ® WaterSense showerhead. The desirable Cypress Creek Landing community includes a park with a playground and a covered pavilion. Situated near Hwy 249 and I-45, commuters enjoy quick access to Downtown Houston. Zoned to the highly-rated Spring Independent School District.' ,`Acres` = '' ,`Area` = '13' ,`BuilderName` = 'KB Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '1960/Cypress Creek North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 8 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PAT REYNOLDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Creek Landing' ,`TaxAmount` = '' ,`TaxRate` = '2.459' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702517' WHERE `Matrix_Unique_ID` = '211782961' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T15:39:44.313' ,`MLSNumber` = '48566993' ,`ListAgentFullName` = 'Ryan Kutter' ,`ListOfficeName` = 'Connect Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.328263' ,`Longitude` = '-95.463609' ,`PhotoCount` = '38' ,`PostalCode` = '77301' ,`RoomCount` = '12' ,`ListPrice` = '449000.00' ,`Status` = 'Active' ,`StreetName` = 'Gay' ,`StreetNumber` = '510' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3840' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious Commercial/Residential property located minutes from I-45 in the heart of downtown Conroe. The location is perfect for an attorney, CPA, pool company, caterer, or any other type of small business. The property is situated on 1.501 acres, & features both cleared land & land w/ mature trees, & has sprinklers front & back. The home features five very large bedrooms/offices. The kitchen opens to the breakfast & living rooms & features a Pro Series gas range & an electric oven/broiler. The property offers LED lighting upgrades throughout, a two-car garage w/ WiFi Lift Master openers, & lots of space to accommodate additional parking. The house has nearly 10 tons of A/C increased for max flow for business use. With camera security, WiFi thermostats, Ring doorbells, a whole house water filtration & conditioner system along with a reverse osmosis system at the kitchen sink for purified water. Located right off of I-45 with ease of access from the Beltway/ I-10, and downtown Houston.' ,`Acres` = '1.501' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'A0002 - ALLEN W S, TRACT 52, 53, ACRES 1.43' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '62291' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'REAVES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Alexander A M' ,`TaxAmount` = '4735' ,`TaxRate` = '2.2478' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702518' WHERE `Matrix_Unique_ID` = '211783118' --> Updated record success