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-15T15:20:57.557' ,`MLSNumber` = '50832055' ,`ListAgentFullName` = 'Lisa ONeill' ,`ListOfficeName` = 'Alliance Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.993570' ,`Longitude` = '-95.049037' ,`PhotoCount` = '43' ,`PostalCode` = '77532' ,`RoomCount` = '10' ,`ListPrice` = '2390000.00' ,`Status` = 'Active' ,`StreetName` = 'Ramsey' ,`StreetNumber` = '21910' ,`StreetSuffix` = 'Road' ,`City` = 'Crosby' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '3' ,`SqFtTotal` = '6794' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Crosby area, Huffman ISD, this 24+ acre property has SO much to offer! The finest details combined with built-to-last construction. The home welcomes you inside with a great room complete with a massive stone fireplace, wet bar, custom built lift, gaming area, dining area, and a kitchen that any cook will love! The best appliances, custom cabinetry, granite countertops, large island, Blue Star 6 burner gas range with 2 ovens, 2 additional ovens, custom under-cabinet lighting. The x-large butler\'s pantry and utility room has plenty of room for second fridge and freezer. The primary suite is huge and has an oversize walk-in shower, double vanity and ample closet space. Off the primary suite is the 10\' x 20\' saferoom. All other bedrooms and 3 extra rooms are upstairs. The great room opens onto the covered pool and patio area, with outdoor kitchen. Enjoy time looking out over the 3 ponds and beautiful property. Home has never flooded! Call for a list of additional upgrades!' ,`Acres` = '24.474' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '0' ,`Legal` = 'Trs 6 & 6D Abst 289 J Gibson' ,`LotDesciption` = 'Other' ,`LotSize` = '1066087' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'FALCON RIDGE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'J Gibson' ,`TaxAmount` = '22109' ,`TaxRate` = '2.0083' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699017' WHERE `Matrix_Unique_ID` = '205122174' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T15:14:59.703' ,`MLSNumber` = '53122489' ,`ListAgentFullName` = 'Randy French' ,`ListOfficeName` = 'Stylecraft Builders, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.414959' ,`Longitude` = '-95.551629' ,`PhotoCount` = '34' ,`PostalCode` = '77318' ,`RoomCount` = '14' ,`ListPrice` = '369900.00' ,`Status` = 'Active' ,`StreetName` = 'North Sunshine Park' ,`StreetNumber` = '11924' ,`StreetSuffix` = 'Drive' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2653' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The beauty of this home goes well beyond the eye-catching façade. A large, open living room flows seamlessly into your dining area and large kitchen. Featuring a powder room on the first floor, your guests will enjoy their privacy without having to use a shared bathroom. Head upstairs where you’ll find all three bedrooms and a shared game room space for all your loved ones to enjoy. Home includes granite countertops throughout, wood cabinetry, ceramic tile in baths and utility. Primary suite includes a separate shower/garden tub and large walk-in closet with built-ins. Everything about this home delivers style, craftsmanship, and spaciousness. Additional options included: 42\" kitchen cabinets, stainless steel appliances, integral blinds in rear door, dual primary vanity, and painted flat panel doors throughout.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Stylecraft' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S906900 - Summerwood Trails 01, BLOCK 4, Lot 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'SUMMERWOOD TRAILS' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699017' WHERE `Matrix_Unique_ID` = '205277633' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T15:23:15.677' ,`MLSNumber` = '58102871' ,`ListAgentFullName` = 'Misti Bruton' ,`ListOfficeName` = 'AVO Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.943935' ,`Longitude` = '-98.392597' ,`PhotoCount` = '16' ,`PostalCode` = '78070' ,`RoomCount` = '6' ,`ListPrice` = '323500.00' ,`Status` = 'Active' ,`StreetName` = 'Fawn Creek' ,`StreetNumber` = '9236' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring Branch' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1694' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Time to get away from the hustle and bustle. This unique custom rustic red cedar home is a throwback to a simpler time. Located in Spring Branch on half an acre of land you can sprawl out and enjoy those sweet Texas nights next to the fire pit. Do you need to park your RV, then this property has the space. With a little attention and care the enclosed mini pool and sauna area can become your backyard oasis. An important feature for a home to have just in time for relaxing after a day of working on projects around the house. With mature landscaping you can enjoy those warm summer days under their shade. Schedule your viewing of this property today to imagine the possibilities!' ,`Acres` = '0.51' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'VALERO ESTATES 2, LOT 77' ,`LotDesciption` = 'Other' ,`LotSize` = '22216' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '141 - Comal' ,`SchoolElementary` = 'REBECCA CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CANYON LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'MOUNTAIN VALLEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Valero Estates 2' ,`TaxAmount` = '2826' ,`TaxRate` = '1.786' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699017' WHERE `Matrix_Unique_ID` = '206514080' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T15:55:13.887' ,`MLSNumber` = '37453482' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Ezelu Igweh' ,`SellingOfficeName` = 'B & G Realty' ,`Latitude` = '29.683170' ,`Longitude` = '-95.837117' ,`PhotoCount` = '26' ,`PostalCode` = '77406' ,`RoomCount` = '13' ,`ListPrice` = '459781.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Hypatia' ,`StreetNumber` = '26526' ,`StreetSuffix` = 'Trace' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2410' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Terrace, Elevation B). CURRENTLY UNDER CONSTRUCTION. Two story. 4 bedrooms. 3.5 baths. Spacious island kitchen open to informal dining room and family room. Primary suite with large walk in closet. Large Game Room and three additional bedrooms upstairs. 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.1171' ,`Area` = '37' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BLOCK 3, LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5099' ,`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`='1663699017' WHERE `Matrix_Unique_ID` = '206900388' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T15:34:29.683' ,`MLSNumber` = '23101169' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Pulte Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.132495' ,`Longitude` = '-95.659494' ,`PhotoCount` = '22' ,`PostalCode` = '77355' ,`RoomCount` = '7' ,`ListPrice` = '289999.00' ,`Status` = 'Active' ,`StreetName` = 'Red Clover' ,`StreetNumber` = '26404' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2032' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Lincoln new home floor plan at Decker Farms invites you in with a warm welcome and is built for entertaining. With your entertaining areas downstairs, the kitchen sparkles with 42” cabinetry, laminate countertops and stainless-steel appliances. An additional bedroom downstairs invites out of town friends and family for short or extended stays. This plan has an upstairs game room for quiet family play before bed. This plan is featured as our model home in Decker Farms.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Centex' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1, Block 7, Section 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Decker Farms' ,`TaxAmount` = '' ,`TaxRate` = '3.42' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699017' WHERE `Matrix_Unique_ID` = '208428768' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T15:32:24.030' ,`MLSNumber` = '29527469' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Pulte Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.132495' ,`Longitude` = '-95.659494' ,`PhotoCount` = '3' ,`PostalCode` = '77355' ,`RoomCount` = '5' ,`ListPrice` = '264880.00' ,`Status` = 'Active' ,`StreetName` = 'Decker Farms' ,`StreetNumber` = '26562' ,`StreetSuffix` = 'Lane' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1408' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Becket\'s new home layout features a covered front porch welcoming you into the spacious single-story home with three secondary bedrooms.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Centex' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 15, Block 3, Section 1' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Decker Farms' ,`TaxAmount` = '' ,`TaxRate` = '3.42' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699018' WHERE `Matrix_Unique_ID` = '208529249' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T14:42:05.210' ,`MLSNumber` = '31621176' ,`ListAgentFullName` = 'Arnold Garza' ,`ListOfficeName` = 'Houston Center Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.409373' ,`Longitude` = '-95.230628' ,`PhotoCount` = '50' ,`PostalCode` = '77511' ,`RoomCount` = '8' ,`ListPrice` = '289000.00' ,`Status` = 'Active' ,`StreetName` = 'South' ,`StreetNumber` = '1475' ,`StreetSuffix` = 'Street' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3007' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Two story, Residential home with a large yard. It includes 4 Bedrooms, 2.1 Baths. Residential home was previously used as a daycare business. It also has a frame garage and a long concrete driveway. Located in Dewitt Park Subdivision.' ,`Acres` = '0.66' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'DEWITT PARK (A0159 BBB&C) (ALVIN) LOT 2 ACRES .66' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '28750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'WALT DISNEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'ALVIN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Right Side,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Dewitt Park' ,`TaxAmount` = '7577' ,`TaxRate` = '2.9268' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1920' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699018' WHERE `Matrix_Unique_ID` = '208727523' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T15:04:50.043' ,`MLSNumber` = '25251696' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.842560' ,`Longitude` = '-94.828091' ,`PhotoCount` = '6' ,`PostalCode` = '77523' ,`RoomCount` = '8' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Lakewood' ,`StreetNumber` = '15211' ,`StreetSuffix` = 'Avenue' ,`City` = 'Mont Belvieu' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2097' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! **LENNAR IS NOW IN LAKES OF CHAMPIONS!!! Lennar Brookstone Collection \"Agate\" Plan with Brick/Stone Elevation \"C\" in Lakes of Champions! This single-story home has a smart layout that is perfect. A bedroom by the front door offers easy access to a bathroom in the hall. Down the hall is the open concept living area, which has a covered patio in the back. Next to the living area are three bedrooms, including the owner’s suite which features a private bathroom and a walk-in closet. \r\n*3-CAR GARAGE*\r\n*HOME ESTIMATED TO BE, November, 2022*' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0004 BLK 004 LOT 003' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '518' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`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` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes of Champions Estates' ,`TaxAmount` = '' ,`TaxRate` = '2.14' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699018' WHERE `Matrix_Unique_ID` = '208774263' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T15:30:50.307' ,`MLSNumber` = '84995512' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Pulte Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.132495' ,`Longitude` = '-95.659494' ,`PhotoCount` = '15' ,`PostalCode` = '77355' ,`RoomCount` = '5' ,`ListPrice` = '279990.00' ,`Status` = 'Active' ,`StreetName` = 'Balsamroot' ,`StreetNumber` = '25605' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1689' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The 4/2 Hewitt is a well-designed plan with 4 bedrooms. This home features an island kitchen boasting with 42\" cabinets, granite countertops and stainless steel appliances, as well as a large dining area. The owner’s suite has a nice garden tub and a separate shower. Come see us today!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Centex' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1, Block 8, Section 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Decker Farms' ,`TaxAmount` = '' ,`TaxRate` = '3.42' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699018' WHERE `Matrix_Unique_ID` = '208788482' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T15:36:44.853' ,`MLSNumber` = '10751124' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Pulte Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.132495' ,`Longitude` = '-95.659494' ,`PhotoCount` = '11' ,`PostalCode` = '77355' ,`RoomCount` = '5' ,`ListPrice` = '269940.00' ,`Status` = 'Active' ,`StreetName` = 'Red Clover' ,`StreetNumber` = '26481' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1642' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Pierce is a 4/2.5 two-story home in Decker Farms. This lovely home features a fabulous downstairs built for entertaining. This open concept island kitchen is lovely with 42” cabinetry, Luxury Laminate countertops, luxury vinyl plank flooring and stainless-steel appliances.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Centex' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 22, Block 3, Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Decker Farms' ,`TaxAmount` = '' ,`TaxRate` = '3.42' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699018' WHERE `Matrix_Unique_ID` = '208989483' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T15:57:24.097' ,`MLSNumber` = '38110931' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Nhu Nguyen' ,`SellingOfficeName` = 'B & W Realty Group LLC' ,`Latitude` = '29.832477' ,`Longitude` = '-95.856835' ,`PhotoCount` = '25' ,`PostalCode` = '77494' ,`RoomCount` = '16' ,`ListPrice` = '569740.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Sarasota Shore' ,`StreetNumber` = '851' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3142' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Albany, Elevation GL) CURRENTLY BEING BUILT. Two story. 4 bedrooms, 3.5 baths. Primary suite downstairs with large walk in closet. Formal Living/Study and Dining room. Spacious island kitchen with breakfast area open to Family room. Game Room upstairs with Media room. Covered patio and 2 car attached 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` = '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 20 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7924' ,`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` = 'BRYANT 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`='1663699018' WHERE `Matrix_Unique_ID` = '209029787' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T14:41:49.047' ,`MLSNumber` = '38752065' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = 'DeAngela Braden' ,`SellingOfficeName` = 'Braden Real Estate Group, LLC' ,`Latitude` = '29.482393' ,`Longitude` = '-95.467313' ,`PhotoCount` = '36' ,`PostalCode` = '77583' ,`RoomCount` = '7' ,`ListPrice` = '308400.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Marvista' ,`StreetNumber` = '1211' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1637' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to Glendale Lakes! This Clover floor plan offers 4 spacious Bedrooms and 2 Bathrooms. This open design floor plan is ready for August move-in! A modern Kitchen featuring 42’’ shaker Kitchen flat panel cabinetry, Quartz countertops with ceramic tile backsplash, high quality Frigidaire appliances and Kitchen island. Relaxing bathrooms with double sinks, separate tub and shower in the Primary Bath, ceramic tile surround with tub in Secondary Baths and Quartz countertops. Energy efficiency features: 16 SEER carrier AC system with programmable thermostat, 40 gallon gas water heater. Full sod front and back landscape package included, Rear Patio, Brick fronts with stone accents per elevation and many more. If you are looking for a great community with walking trail, easy access to majors freeways, in one of the best school districts, this is it! Set up your appointment today!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Saratoga Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 44 Block 1 Section GL-9 Glendale Lakes' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '5000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Glendale Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.14' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699018' WHERE `Matrix_Unique_ID` = '209188068' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T15:59:36.223' ,`MLSNumber` = '19478475' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Christelle Agah' ,`SellingOfficeName` = 'Keller Williams Signature' ,`Latitude` = '29.832841' ,`Longitude` = '-95.856801' ,`PhotoCount` = '25' ,`PostalCode` = '77494' ,`RoomCount` = '16' ,`ListPrice` = '549857.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Sarasota Shore' ,`StreetNumber` = '831' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3136' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Albany, Elevation GL) CURRENTLY BEING BUILT. Two story. 4 bedrooms, 3.5 baths. Primary suite downstairs with large walk in closet. Formal Living/Study and Dining room. Spacious island kitchen with breakfast area open to Family room. Game Room upstairs with Media room. Covered patio and 2 car attached 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` = '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 16 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6791' ,`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` = '' ,`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`='1663699019' WHERE `Matrix_Unique_ID` = '209308818' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T14:30:18.737' ,`MLSNumber` = '13157800' ,`ListAgentFullName` = 'Kyle Cunningham' ,`ListOfficeName` = 'Cunningham Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.798606' ,`Longitude` = '-95.484111' ,`PhotoCount` = '14' ,`PostalCode` = '77055' ,`RoomCount` = '11' ,`ListPrice` = '839000.00' ,`Status` = 'Active' ,`StreetName` = 'Johanna' ,`StreetNumber` = '1523 C' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3401' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Est. completion early August! Don\'t miss out on the opportunity to customize your DREAM HOME, selections left to be made! Are you buying from a reputable builder? With 30+ yrs experience & one of Houstons oldest builders, Award-winning Cunningham builds to the highest quality and standards. High End finishes Stunning open-living concept floor plan. Study down, kitchen opens to dinning & family room w/ custom fireplace, bar area w/ custom floating shelves and wine racks. Large primary bedroom & bath feat. His/hers vanities w/ free standing tub & walk-in shower w/ dual shower heads! Walk-in closets in all bedrooms w/ adjustable shelves. Game room, 2 secondary bedrooms w/ private baths. Extra large flex room on top floor. Covered patio, back yard w/ room for pool. ELEVATOR capable. SBISD. Super Energy Efficient, spray foam insulation, tankless H2O, instant endless hot water. Hardwood/tile flooring, natural counter tops, custom cabinetry. Truly a Superior Home!' ,`Acres` = '' ,`Area` = '24' ,`BuilderName` = 'Cunningham' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 P/R NO 35' ,`LotDesciption` = 'Cleared,Patio Lot,Subdivision Lot' ,`LotSize` = '4039' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'TREASURE FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Craig Woods' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699019' WHERE `Matrix_Unique_ID` = '209539540' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T14:14:58.740' ,`MLSNumber` = '43171404' ,`ListAgentFullName` = 'Lakeyta Amond' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.894088' ,`Longitude` = '-94.031650' ,`PhotoCount` = '29' ,`PostalCode` = '77640' ,`RoomCount` = '4' ,`ListPrice` = '399995.00' ,`Status` = 'Active' ,`StreetName` = 'Jade' ,`StreetNumber` = '6016' ,`StreetSuffix` = 'Avenue' ,`City` = 'Port Arthur' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1875' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Attention Investors & Potential Home Owners! Location! Location! Location! \r\n\r\nBack by popular demand; Ruby, The Alion Ranch has an impressive resume. Reviewed at a 5 star rating, has exceeded every guest expectations! She can continue to be used as a Turnkey business (Airbnb) or a beautiful ranch to call your own and surely will not disappoint! Sitting on 4.6 acres, there\'s plenty of space to maximize! \r\n\r\nCheck this out: From February 2022 - June 2022 $27097.26 Airbnb income. Who would like to earn this amount in only 5 months?\r\nMust see in person to appreciate! This Time It Won’t Last! Serious inquiries only and bring your best offer!' ,`Acres` = '4.618' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TRACT 1-A & 1-B REPLAT OF S 1/2 OF LT 1 BLK 7 PORT ACRES 4.6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '201161' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '236 - Port Arthur' ,`SchoolElementary` = '' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (PORT ARTHUR)' ,`SchoolMiddle` = 'LINCOLN MIDDLE SCHOOL (PORT ARTHUR)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Port Acres' ,`TaxAmount` = '5168' ,`TaxRate` = '3.267' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699019' WHERE `Matrix_Unique_ID` = '209558407' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T14:11:07.227' ,`MLSNumber` = '46599521' ,`ListAgentFullName` = 'Ashfaq Sharif' ,`ListOfficeName` = 'Avalon Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.711805' ,`Longitude` = '-95.736626' ,`PhotoCount` = '27' ,`PostalCode` = '77450' ,`RoomCount` = '10' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Morgan Canyon' ,`StreetNumber` = '6227' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3068' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Pride of ownership shows with this home. Large corner , Kitchen has select granite counter, stainless steel appliances. Wrought iron and glass door. Laminate floor. Security guard controlled access to this sudivision.' ,`Acres` = '' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CANYON GATE CINCO RANCH SEC 1, BLOCK 1, LOT 34' ,`LotDesciption` = 'Corner' ,`LotSize` = '11772' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1266' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CREECH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'BECK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Gate Cinco Ranch' ,`TaxAmount` = '' ,`TaxRate` = '2.6862' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699019' WHERE `Matrix_Unique_ID` = '209754163' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T15:31:21.960' ,`MLSNumber` = '8826779' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Pulte Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.132495' ,`Longitude` = '-95.659494' ,`PhotoCount` = '4' ,`PostalCode` = '77355' ,`RoomCount` = '6' ,`ListPrice` = '269970.00' ,`Status` = 'Active' ,`StreetName` = 'Decker Farms' ,`StreetNumber` = '26527' ,`StreetSuffix` = 'Lane' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1501' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Independence is a versatile one-story home in Decker Farms. Designed for families who may be working from home, this 3-bedroom, 2 bath home has a study right off the family room. This island kitchen is lovely with 42” cabinetry, granite countertops, and stainless-steel appliances with a large dining area making for comfortable family dining.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Centex' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 7, Block 3, Section 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Decker Farms' ,`TaxAmount` = '' ,`TaxRate` = '3.42' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699019' WHERE `Matrix_Unique_ID` = '210000594' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T15:38:15.190' ,`MLSNumber` = '10873329' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Pulte Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.132495' ,`Longitude` = '-95.659494' ,`PhotoCount` = '9' ,`PostalCode` = '77355' ,`RoomCount` = '9' ,`ListPrice` = '297990.00' ,`Status` = 'Active' ,`StreetName` = 'Decker Farms' ,`StreetNumber` = '26523' ,`StreetSuffix` = 'Lane' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2081' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Sandalwood floor plan at Decker Farms is ideal for families working from home. The large study downstairs can double as a 4th bedroom if needed. With your entertaining areas downstairs, the island kitchen sparkles with 42” cabinetry, granite countertops and stainless-steel appliances make this kitchen a cooks dream. This plan also has an upstairs game room for quiet family play or a movie or a retreat for kids while entertaining. The Sandalwood is sure to impress. Come see us today!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Centex' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 6, Block 3, Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Decker Farms' ,`TaxAmount` = '' ,`TaxRate` = '3.42' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699019' WHERE `Matrix_Unique_ID` = '210007231' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T15:13:56.977' ,`MLSNumber` = '57254431' ,`ListAgentFullName` = 'Christy Huckaby' ,`ListOfficeName` = 'Nextgen Real Estate Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.066670' ,`Longitude` = '-95.162569' ,`PhotoCount` = '31' ,`PostalCode` = '77345' ,`RoomCount` = '9' ,`ListPrice` = '555000.00' ,`Status` = 'Active' ,`StreetName` = 'Timberbrook' ,`StreetNumber` = '2315' ,`StreetSuffix` = 'Trail' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4155' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Absolutely Stunning 5 bedroom home offering no back neighbors as it is located on a private greenbelt and sits on a quiet culdesac street. The floorplan is seamless showcasing EVERYTHING a family would need. Formal dining and study off of the entry, a grand island kitchen is open to the family room and offers an added sunroom. Primary suite is located on the first floor and along with the grand staircase in the entry, there is also a back staircase that leads directly to the upstairs gameroom. The \"hard to find\" porte-cochere offers extra coverage and the owner has taken exceptional care of the yard. Front and back the landscaping is gorgeous and the backyard is breathtaking, fabulous and private. Roof, water heaters and both a/c units are under 5 years old! This home is SPECTACULAR and ready for a new family!' ,`Acres` = '0.268' ,`Area` = '32' ,`BuilderName` = 'Village' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 1 RIVERCHASE SEC 3' ,`LotDesciption` = 'Greenbelt,Subdivision Lot,Wooded' ,`LotSize` = '11674' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'SHADOW FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'RIVERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverchase Sec 3' ,`TaxAmount` = '10646' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699019' WHERE `Matrix_Unique_ID` = '210093557' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T14:20:55.047' ,`MLSNumber` = '46918274' ,`ListAgentFullName` = 'Nader Shirazi' ,`ListOfficeName` = 'Beachtown Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.323599' ,`Longitude` = '-94.741949' ,`PhotoCount` = '44' ,`PostalCode` = '77550' ,`RoomCount` = '5' ,`ListPrice` = '2950000.00' ,`Status` = 'Active' ,`StreetName` = 'Seaside' ,`StreetNumber` = '2617' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3333' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One of a kind Beachfront home in highly sought after East Village section of Beachtown Galveston. 5 bedroom, 4.5 bathroom is located on the island\'s only GROWING and non-driving beach. Built to Fortified standards with concrete pilings and a concrete podium (first level floor) construction. Home offers a heated swimming pool, beachfront yard, elevator, wide-plank walnut flooring, tall ceilings, Sub-Zero/Wolf appliances, 2 fireplaces, Andersen doors/windows, and many more features. The main level features a great room, kitchen, two covered porches, and an oversized bedroom suite. Upstairs features a large master suite in addition to a private porch and three additional bedrooms. The home is being offered furnished including outdoor furniture and electronics.' ,`Acres` = '0.1346' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'East Beach' ,`HeatSystem` = 'Central Electric,Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'BEACHTOWN GALVESTON EAST VILLAGE (2007) ABST 628, BLOCK 5, L' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '5864' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3458' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Beachtown Galveston East Village' ,`TaxAmount` = '42331' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699020' WHERE `Matrix_Unique_ID` = '210117320' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T14:22:06.133' ,`MLSNumber` = '4181901' ,`ListAgentFullName` = 'Juan Barron' ,`ListOfficeName` = 'RE/ImageProperties and Investm' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.737345' ,`Longitude` = '-95.815802' ,`PhotoCount` = '19' ,`PostalCode` = '77494' ,`RoomCount` = '7' ,`ListPrice` = '389000.00' ,`Status` = 'Active' ,`StreetName` = 'Autumn Branch' ,`StreetNumber` = '3711' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1614' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Owner\'s in the process of moving out, please excuse the mess.\r\n\r\nLovely and cozy one-story house located in a nearly 11,000 square foot cul-de-sac, the split floor plan provides privacy, plenty of natural light, an open concept kitchen with beautiful cabinets, and an extended island with plenty of storage, a covered patio perfect to enjoy with the family.' ,`Acres` = '0.2505' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SILVER RANCH SEC 1, BLOCK 1, LOT 17' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '10910' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WOODCREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMPKINS HIGH SCHOOL' ,`SchoolMiddle` = 'TAYS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Silver Ranch Sec 1' ,`TaxAmount` = '5438' ,`TaxRate` = '2.7545' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699020' WHERE `Matrix_Unique_ID` = '210225395' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T14:37:33.433' ,`MLSNumber` = '49954198' ,`ListAgentFullName` = 'Robert Findley' ,`ListOfficeName` = 'Realty Insight' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.357432' ,`Longitude` = '-95.645311' ,`PhotoCount` = '19' ,`PostalCode` = '77316' ,`RoomCount` = '6' ,`ListPrice` = '239900.00' ,`Status` = 'Active' ,`StreetName` = 'Shadow Lane' ,`StreetNumber` = '2342' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1475' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come and MARVEL at this 4 Bed 2 Bath on this spacious country lot in Marvin\'s Garden\'s. All the amenities of Conroe, Montgomery, and Lake Conroe are close by. It is under construction, but you can see a model of this beautiful home to be built at the Oakwood Homes sales park.' ,`Acres` = '0.2583' ,`Area` = '39' ,`BuilderName` = 'CMH Homes, Inc.' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'MARVINS GARDENS 02, BLOCK 1, LOT 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'KEENAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Marvins Gardens 02' ,`TaxAmount` = '144' ,`TaxRate` = '1.825' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663699020' WHERE `Matrix_Unique_ID` = '210387273' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T14:36:52.360' ,`MLSNumber` = '2522728' ,`ListAgentFullName` = 'Robert Findley' ,`ListOfficeName` = 'Realty Insight' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.357649' ,`Longitude` = '-95.645302' ,`PhotoCount` = '18' ,`PostalCode` = '77316' ,`RoomCount` = '6' ,`ListPrice` = '239900.00' ,`Status` = 'Active' ,`StreetName` = 'Shadow Lane' ,`StreetNumber` = '2348' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1475' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come and MARVEL at this Beautiful 4 Bed 2 Bath home on a spacious 1/4 acres lot. All the amenities of Montgomery, Conroe, and Lake Conroe are nearby.' ,`Acres` = '0.2583' ,`Area` = '39' ,`BuilderName` = 'CMH Homes, Inc.' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'MARVINS GARDENS 02, BLOCK 1, LOT 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'KEENAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Marvins Gardens 02' ,`TaxAmount` = '144' ,`TaxRate` = '1.825' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663699020' WHERE `Matrix_Unique_ID` = '210389023' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T14:38:34.460' ,`MLSNumber` = '63380160' ,`ListAgentFullName` = 'Robert Findley' ,`ListOfficeName` = 'Realty Insight' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.357947' ,`Longitude` = '-95.645356' ,`PhotoCount` = '17' ,`PostalCode` = '77316' ,`RoomCount` = '7' ,`ListPrice` = '269900.00' ,`Status` = 'Active' ,`StreetName` = 'Shadow Lane' ,`StreetNumber` = '2354' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1896' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The WONDER is wonderfully spacious! 4 bed 2 bath with a living room, family room, and dining room. The property is made up of both lots 13 and 14 and is approximately 1/2 acre. Come and view this beautiful lot and see a model home on the company sales lot while this home is under construction.' ,`Acres` = '0.2583' ,`Area` = '39' ,`BuilderName` = 'CMH Homes, Inc.' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'MARVINS GARDENS 02, BLOCK 1, LOT 13' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '11250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'KEENAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Marvins Gardens 02' ,`TaxAmount` = '144' ,`TaxRate` = '1.825' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663699020' WHERE `Matrix_Unique_ID` = '210428450' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T14:48:20.003' ,`MLSNumber` = '88403236' ,`ListAgentFullName` = 'Maria Cortes' ,`ListOfficeName` = 'Anchor Realty Assoc., Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.735423' ,`Longitude` = '-94.960638' ,`PhotoCount` = '14' ,`PostalCode` = '77520' ,`RoomCount` = '3' ,`ListPrice` = '189500.00' ,`Status` = 'Active' ,`StreetName` = 'Adoue' ,`StreetNumber` = '421' ,`StreetSuffix` = 'Street' ,`City` = 'Baytown' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1110' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cute and remodeled 3-bedroom, 1 full bath plus a 1/2 bath. This home is located on a corner lot with a detached garage/workshop. New central A/C and heat, updated electrical, flooring and so much more. Beautiful kitchen with new cabinets and floors. This home is ready for a new owner. MOVE-IN READY' ,`Acres` = '0.1148' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 BLK 1 WRIGHT PERKINS' ,`LotDesciption` = 'Corner' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'ASHBEL SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'HORACE MANN J H' ,`ShowInstructions` = 'Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wright Perkins' ,`TaxAmount` = '2157' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699020' WHERE `Matrix_Unique_ID` = '210849294' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T14:37:13.543' ,`MLSNumber` = '76749552' ,`ListAgentFullName` = 'Ross Richardson' ,`ListOfficeName` = 'Click Realty, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.753826' ,`Longitude` = '-95.754580' ,`PhotoCount` = '28' ,`PostalCode` = '77450' ,`RoomCount` = '11' ,`ListPrice` = '645000.00' ,`Status` = 'Active' ,`StreetName` = 'Glen Arden' ,`StreetNumber` = '22014' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4462' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Executive DELIGHT ! \r\nStunning 5 bedroom / 3.5 baths home with private swimming pool, luscious landscaping, custom built ins. This kitchen is set up for great entertaining, and the home has more closet space than anyone could imagine. Stainless appliances and granite countertops. Two HCAC systems. Two Stairwells. In home office / library located at the front door. \r\n\r\nNeighborhood has many wonderful amenities such as Lakes, Beach Club, Golf Course, Waterpark & Nature Trails with access to none neighborhood centers with community swimming, tennis, basketball and sports fields.' ,`Acres` = '0.1891' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 1 CINCO RANCH N LAKE VLG SEC 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8236' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1115' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WILLIAMS ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'BECK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cinco Ranch N Lake Village Sec' ,`TaxAmount` = '11615' ,`TaxRate` = '2.3333' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699020' WHERE `Matrix_Unique_ID` = '210908750' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T14:51:55.760' ,`MLSNumber` = '10391703' ,`ListAgentFullName` = 'Charlotte Blocker' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.147283' ,`Longitude` = '-95.680083' ,`PhotoCount` = '49' ,`PostalCode` = '77362' ,`RoomCount` = '8' ,`ListPrice` = '622000.00' ,`Status` = 'Active' ,`StreetName` = 'Falcon Hollow' ,`StreetNumber` = '926' ,`StreetSuffix` = 'Lane' ,`City` = 'Pinehurst' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2770' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Village Builders \"Wentworth Series\" single-story corner oversized lot home with 4 bedrooms, 3 baths, and an oversized 3-car garage. The craftsmanship of the upgraded exterior elevation and covered front porch provides a welcoming curb appeal. The kitchen and family room are open concept and both areas enjoy the patio views. The luxury Master Suite has a shower, separate soaker tub, and an impressive walk-in closet with direct access to the laundry room. Tech Specs: REOLINK H.265 4K Security Camera System, Wired Turret POE Cameras with Person Vehicle Detection. Other notable upgrades are Veneta Designer 2.5” Faux Wood Blinds in every room, high ceilings, a large kitchen island with seating, 42\" cabinets, herringbone-patterned backsplash, and an abundance of natural lighting. Make sure to check out all of the amenities that the magnificent neighborhood of Woodtrace has to offer.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Village Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S959412 - Woodtrace 12, Block 2, Lot 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13175' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodtrace' ,`TaxAmount` = '' ,`TaxRate` = '3.3178' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699021' WHERE `Matrix_Unique_ID` = '211246700' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T15:48:42.743' ,`MLSNumber` = '4099072' ,`ListAgentFullName` = 'Sara Mata' ,`ListOfficeName` = 'Lucky Money Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.742075' ,`Longitude` = '-95.257815' ,`PhotoCount` = '19' ,`PostalCode` = '77029' ,`RoomCount` = '3' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Georgia' ,`StreetNumber` = '275' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1224' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Completely renovated home on a revitalizing area. Home sits on 2 lots giving you about 12,744 sq * ft just in lot size. (Buyer to verify home and lot size.)\r\nHome ready for some new owners. There is a small apartment next to it ready to be completed. House is full of potential. Come and see and decide for yourself.' ,`Acres` = '0.1463' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 17, 18 BLK 22 CLINTON PARK' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PLEASANTVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FURR HIGH SCHOOL' ,`SchoolMiddle` = 'HOLLAND MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Clinton Park' ,`TaxAmount` = '1455' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663699021' WHERE `Matrix_Unique_ID` = '211250262' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T15:13:10.273' ,`MLSNumber` = '15924210' ,`ListAgentFullName` = 'Tram Bui' ,`ListOfficeName` = 'Precious Realty & Mortgage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.727091' ,`Longitude` = '-95.621597' ,`PhotoCount` = '30' ,`PostalCode` = '77082' ,`RoomCount` = '7' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Hazy Park' ,`StreetNumber` = '3059' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully REMODELED HOUSE on the 7,000 sqft CORNER LOT near Richmond & Eldridge. Very IDEAL for 1st time home buyer or Good investment home. Rare find 3 bedrooms plus 1 extra can be used as 4th bedroom or Home office/ Study room + 3 REMODELED FULL BATHROOMS. Enjoy the UPGRADES GALORES: New Tile Flooring, New Paint, New light fixture, New Ceiling fans, Brand New Upgraded Bathrooms with Standing shower, High level Granite stone in all Bathrooms, New Sinks, New Faucets, New toilets...Spacious Kitchen area with GRANITE COUNTERTOP and Solid wood Cabinets. 2016 NEW ROOF, 2016 NEW AC. LARGE FRONT DRIVEWAY can park 3 cars. House will be included with WASHER, DRYER, REFRIGERATOR for good price offer. Per seller, NEVER FLOODED. Prime location: few minutes to access Westheimer, Richmond, Bellaire, Hwy 6, I-10, Westpark Tollway,...Closed to Shopping mall, Hospital, Park,...PRICED TO SELL. MAKE IT YOUR HOME !' ,`Acres` = '0.1618' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 6 PARKHOLLOW PLACE SEC 2 R/P' ,`LotDesciption` = 'Corner' ,`LotSize` = '7050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'HEFLIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'O\'DONNELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkhollow Place & 03 Sec 02 R' ,`TaxAmount` = '4115' ,`TaxRate` = '2.4411' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699021' WHERE `Matrix_Unique_ID` = '211434832' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T15:15:49.310' ,`MLSNumber` = '3473286' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.259302' ,`Longitude` = '-95.507470' ,`PhotoCount` = '24' ,`PostalCode` = '77384' ,`RoomCount` = '4' ,`ListPrice` = '283981.00' ,`Status` = 'Active' ,`StreetName` = 'Lamprey' ,`StreetNumber` = '14040' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1311' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in River\'s Edge in Conroe, TX - zoned to The Woodlands schools! The Butler floor plan is a charming 2-story home with 3 bedrooms, 2.5 bathrooms and a 2-car garage. This home has it all, including blinds! The gourmet kitchen is sure to please with 42\" cabinets, granite countertops and center island! Retreat to the Owner\'s Suite featuring a sizable shower, marble vanity, and walk-in closet. Enjoy the great outdoors with full sod, sprinkler system, and a covered patio! Don\'t miss your opportunity to call River\'s Edge home, schedule a visit today!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Legend Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 16 Block 5 Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4044' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUCKALEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'River\'s Edge' ,`TaxAmount` = '' ,`TaxRate` = '3.34' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699021' WHERE `Matrix_Unique_ID` = '211439417' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T15:06:33.857' ,`MLSNumber` = '70268609' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = 'Carla Nettles' ,`SellingOfficeName` = 'Summit, Realtors' ,`Latitude` = '29.652796' ,`Longitude` = '-95.121492' ,`PhotoCount` = '17' ,`PostalCode` = '77505' ,`RoomCount` = '10' ,`ListPrice` = '441898.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Firethorne Ridge' ,`StreetNumber` = '5810' ,`StreetSuffix` = 'Way' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2243' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming one-story Chase home with 3 bedrooms, 2 baths and 3 car attached garage. Beautiful maple cabinets, granite countertops and farmhouse sink in kitchen. Convenient home office located across from great room. Double sinks, separate tub and shower in owner\'s bath. Enjoy your evening relaxing on your cover patio. Offered by: K. Hovnanian Houston Parkway Trails, LLC.' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'K. Hovnanian' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '3/2/5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'JP DABBS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRMONT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkway Trails' ,`TaxAmount` = '' ,`TaxRate` = '2.6198' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699021' WHERE `Matrix_Unique_ID` = '211440283' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T15:40:10.330' ,`MLSNumber` = '68998272' ,`ListAgentFullName` = 'Michelle Taylor' ,`ListOfficeName` = 'NextHome Realty Solutions BCS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.607949' ,`Longitude` = '-96.326138' ,`PhotoCount` = '23' ,`PostalCode` = '77840' ,`RoomCount` = '8' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'Timm' ,`StreetNumber` = '1105' ,`StreetSuffix` = 'Drive' ,`City` = 'College Station' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1892' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ready for some Aggie football? This home is less than a mile away from Texas A&M University and Kyle Field! Well kept 3 bedroom, 2 bath home has had one owner since 1964! With almost 1900 square feet this home features a formal living room as well as a family room with dining space. The oversized master bedroom has ensuite bathroom and walk in closet. Two additional bedrooms down the hall share a hallway bathroom. Adorable kitchen opens up to the family room and dining space for those family or friend gatherings. The family room also has backyard access to extend your events outdoors. Original wood floors are under the formal living room, the hallway, and the 2 secondary bedrooms! Roof and gas range replaced in 2021.' ,`Acres` = '0.225' ,`Area` = '61' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WOODSON VILLAGE PH 1, BLOCK 2, LOT 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '9801' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '153 - College Station' ,`SchoolElementary` = 'SOUTH KNOLL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'A & M CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'A & M CONSOLIDATED MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodson Village Ph 1' ,`TaxAmount` = '5842' ,`TaxRate` = '2.2433' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699021' WHERE `Matrix_Unique_ID` = '211440909' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T15:35:46.200' ,`MLSNumber` = '17161149' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.754406' ,`Longitude` = '-95.878941' ,`PhotoCount` = '14' ,`PostalCode` = '77494' ,`RoomCount` = '6' ,`ListPrice` = '428900.00' ,`Status` = 'Active' ,`StreetName` = 'Mesquite Oaks' ,`StreetNumber` = '29431' ,`StreetSuffix` = 'Drive' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1736' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERRY HOMES NEW CONSTRUCTION!! Entry leads to open family room, dining area and kitchen. Large windows and 10-foot ceilings throughout. Kitchen features generous counter space, corner walk-in pantry and large island with built-in seating space. Primary suite includes bedroom with 10-foot ceiling. Double doors lead to primary bath with dual vanities, separate glass-enclosed shower and walk-in closet. Covered backyard patio. Mud room with adjoining closet is just off two-car garage.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3, Block 1, Section 31' ,`LotDesciption` = 'Other' ,`LotSize` = '6635' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`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` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jordan Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699021' WHERE `Matrix_Unique_ID` = '211441567' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T15:51:13.903' ,`MLSNumber` = '53619922' ,`ListAgentFullName` = 'Rosann Zalman' ,`ListOfficeName` = 'Zalman & Company' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.166687' ,`Longitude` = '-96.254821' ,`PhotoCount` = '23' ,`PostalCode` = '77437' ,`RoomCount` = '3' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = 'Brent' ,`StreetNumber` = '377' ,`StreetSuffix` = 'Street' ,`City` = 'El Campo' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2375' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Traditional brick three bedroom, two bath home built in 1981. 2300 + sf. Den with fireplace. Formal dining. Separate office/library. Breakfast area and adjacent additional family room adds extra living space for \r\nroom options. All electric. Covered patio. 600 sf carport. 32\'X64\' garage/barn. Located on the edge of town.\r\n1.4 acre.' ,`Acres` = '1.4118' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SOUTHERN ACRES BLOCK 4 LOT 5,6' ,`LotDesciption` = 'Other' ,`LotSize` = '61498' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '198 - El Campo' ,`SchoolElementary` = '' ,`SchoolHigh` = 'EL CAMPO HIGH SCHOOL' ,`SchoolMiddle` = 'EL CAMPO MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Southern Acres' ,`TaxAmount` = '5380' ,`TaxRate` = '1.9674' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699022' WHERE `Matrix_Unique_ID` = '211442189' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T15:56:05.787' ,`MLSNumber` = '65520725' ,`ListAgentFullName` = 'Mayley Dinh' ,`ListOfficeName` = 'MTD Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.706542' ,`Longitude` = '-95.574104' ,`PhotoCount` = '18' ,`PostalCode` = '77072' ,`RoomCount` = '3' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Holworth' ,`StreetNumber` = '11039' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1687' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Newly updated home conveniently located close to Sam Houston Tollway and Westpark Tollway. Come see the open layout with high ceilings, spacious rooms and a beautiful indoor garden area. Bathrooms have been fully remodeled and home has a brand new roof, new AC and water heater. Property has never flooded. Schedule your showing today!' ,`Acres` = '0.1191' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 3 BRAYS VILLAGE SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5187' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '285' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'CHANCELLOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'ALIEF MIDDLE SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Brays Village Sec 04' ,`TaxAmount` = '3788' ,`TaxRate` = '2.4411' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699022' WHERE `Matrix_Unique_ID` = '211442494' --> Updated record success