Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-20T12:54:52.787' ,`MLSNumber` = '30887235' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.402452' ,`Longitude` = '-95.059937' ,`PhotoCount` = '16' ,`PostalCode` = '77568' ,`RoomCount` = '15' ,`ListPrice` = '389990.00' ,`Status` = 'Active' ,`StreetName` = 'Sweet Bay' ,`StreetNumber` = '2211' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2785' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home is under construction. Create unforgettable moments in this Lake Ridge Builders home in Lago Mar. Situated on a spacious lot, this 4-sided brick home boasts a premium elevation, huge backyard, open ceilings, tile flooring, wrought iron spindles, faux wood blinds, study with French doors, full gutters, and a covered patio. Try a new recipe in the kitchen, complete with granite countertops, tile backsplash, stainless steel appliances, and 42” upper cabinets. The serene primary suite features dual vanities, a 42” tub, and a separate shower. Lago Mar is home to Texas’ largest crystal lagoon, a 12-acre Caribbean blue lagoon surrounded by white sand beaches. Other community amenities include a clubhouse, fitness center, and playground. Located off I-45, residents enjoy easy access to major business centers and popular shopping malls. Schools are zoned to Dickinson ISD. Call today to learn more!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 10 Block 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.5521' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216638' WHERE `Matrix_Unique_ID` = '204298936' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-20T12:54:30.960' ,`MLSNumber` = '56256646' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.403731' ,`Longitude` = '-95.051949' ,`PhotoCount` = '16' ,`PostalCode` = '77568' ,`RoomCount` = '11' ,`ListPrice` = '319990.00' ,`Status` = 'Active' ,`StreetName` = 'Sweet Bay' ,`StreetNumber` = '2203' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1869' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. Enjoy the comforts of this gorgeous Lake Ridge Builders Home in Lago Mar. This 4-sided brick home boasts a premium elevation, tile flooring, faux wood blinds, a guest suite, open great room, full gutters, and a covered patio. Spend quality time in the kitchen, complete with granite countertops, tile backsplash, stainless steel appliances, and 42” upper cabinets. Retreat to the tranquil primary suite, featuring dual vanities, a 42” tub, and a separate shower. Lago Mar is home to Texas’ largest crystal lagoon, a 12-acre Caribbean blue lagoon surrounded by white sand beaches. Other community amenities include a clubhouse, fitness center, and playground. Located off I-45, residents enjoy easy access to major business centers and popular shopping malls. Schools are zoned to Dickinson ISD. Book your private showing today!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 12 Block 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.5521' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216638' WHERE `Matrix_Unique_ID` = '205154048' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-20T12:55:08.527' ,`MLSNumber` = '55665363' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.403731' ,`Longitude` = '-95.051949' ,`PhotoCount` = '14' ,`PostalCode` = '77568' ,`RoomCount` = '13' ,`ListPrice` = '359990.00' ,`Status` = 'Active' ,`StreetName` = 'Islawild' ,`StreetNumber` = '2103' ,`StreetSuffix` = 'Way' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2408' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. Enjoy scenic views in this lakefront Lake Ridge Builders home in Lago Mar. Situated on a cul-de-sac lot, this 4-sided brick home boasts a premium elevation, no backyard neighbors, tile flooring, entry crown molding, wrought iron spindles, faux wood blinds, cast stone fireplace, full gutters, and a covered patio. Impress your guests in the kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, and 42” upper cabinets. With dual vanities, a 36” tub, and a separate shower the primary suite is the perfect place to relax. Lago Mar is home to Texas’ largest crystal lagoon, a 12-acre Caribbean blue lagoon surrounded by white sand beaches. Other community amenities include a clubhouse, fitness center, and playground. Located off I-45, residents enjoy easy access to major business centers and popular shopping malls. Schools are zoned to Dickinson ISD. You don’t want to miss this home!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 27 Block 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Waterfront' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.5521' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216638' WHERE `Matrix_Unique_ID` = '205589711' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-20T11:14:20.500' ,`MLSNumber` = '91374809' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.336410' ,`Longitude` = '-95.058500' ,`PhotoCount` = '30' ,`PostalCode` = '77327' ,`RoomCount` = '4' ,`ListPrice` = '229990.00' ,`Status` = 'Active' ,`StreetName` = 'Spring Creek' ,`StreetNumber` = '10061' ,`StreetSuffix` = 'Road' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1496' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'No Back Neighbors** Economical Bridgeport - C home with a Huge Family Room! Granite Kitchen Countertop and 42\" Dusk Cabinets! Lofty 9\' Ceilings. Super Shower with a Glass Door in Primary Bathroom! Quartz Countertops in all the Bathrooms. Stainless Steel Gas Range, Microwave, and Dishwasher. Very large 14 x 10 Uncovered Back Patio.' ,`Acres` = '' ,`Area` = '52' ,`BuilderName` = 'Rausch Coleman Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'N/A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'EASTSIDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Oaks Reserve' ,`TaxAmount` = '' ,`TaxRate` = '2.56' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216638' WHERE `Matrix_Unique_ID` = '207680162' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-20T11:39:12.537' ,`MLSNumber` = '46862126' ,`ListAgentFullName` = 'Paula Tullos' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.356913' ,`Longitude` = '-95.144669' ,`PhotoCount` = '19' ,`PostalCode` = '77328' ,`RoomCount` = '7' ,`ListPrice` = '149000.00' ,`Status` = 'Active' ,`StreetName` = 'A J Meekins' ,`StreetNumber` = '210' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1322' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PRICE REDUCED! Looking for some fresh country air? Come take a look at this 2 bedroom, 1 bath home on 1.516 acres in San Jacinto County. Beautiful yard with large trees. If you\'re looking for country, look no further.' ,`Acres` = '' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Coldspring/South San Jacinto County' ,`HeatSystem` = 'Wall Heater' ,`HOAMandatory` = '0' ,`Legal` = 'A259 Mary S Rucker, Tract 40.3, Acres 1.516' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'NORTHSIDE ELEMENTARY SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'NA' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675216639' WHERE `Matrix_Unique_ID` = '208376067' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-20T11:18:11.123' ,`MLSNumber` = '93843345' ,`ListAgentFullName` = 'Kati Hall' ,`ListOfficeName` = 'RE/MAX On The Water - Bolivar' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.456413' ,`Longitude` = '-94.628575' ,`PhotoCount` = '33' ,`PostalCode` = '77650' ,`RoomCount` = '3' ,`ListPrice` = '799500.00' ,`Status` = 'Active' ,`StreetName` = 'Royalville' ,`StreetNumber` = '1999' ,`StreetSuffix` = 'Court' ,`City` = 'Crystal Beach' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1890' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful New Construction located in the highly desired Crystal Beach Estates area! Enjoy the peaceful views on your large porch! Kitchen features oversized custom vent-a-hood with large island able to seat 10-12 people. Open to the large living room area. Half bath located off the living room area. Primary bedroom with oversized windows, built in King sized bed and fabulous primary bath! Primary bath features double sinks, soaker tub and tile shower with rain shower head. While walking upstairs you will enter a large area perfect for relaxing and can also be used as a sleeping area. Both guest bedrooms have custom built in bunk beds with plenty of room for additional bedding. 2 Full baths upstairs as well!! This home will sleep approximately 18-20 people!!' ,`Acres` = '0.1077' ,`Area` = '33' ,`BuilderName` = 'Easton Homes LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 11 BLK 1 CRYSTAL BEACH ESTATES (2021) ABST 179' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '4693' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Crystal Beach Ests' ,`TaxAmount` = '605' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216639' WHERE `Matrix_Unique_ID` = '208408661' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-20T11:47:35.637' ,`MLSNumber` = '82071675' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.897893' ,`Longitude` = '-95.739605' ,`PhotoCount` = '9' ,`PostalCode` = '77433' ,`RoomCount` = '9' ,`ListPrice` = '319990.00' ,`Status` = 'Active' ,`StreetName` = 'Costalinda' ,`StreetNumber` = '21422' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1416' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. Escape the city to this gorgeous Lake Ridge Builders home in Marvida! Nestled on a spacious lot, this 3-sided brick home boasts a stone elevation, tile flooring, faux wood blinds, full gutters, a sprinkler system, and a covered patio. Try a new recipe in the kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, 42” upper cabinets, and undercabinet lighting. Spend relaxing evenings in the primary suite, featuring dual vanities, a 42” tub, and a separate shower. Community amenities include clubhouses, pools, playgrounds, state-of-the-art workout facilities, tennis courts, basketball courts, and a dog park. Situated near the Grand Parkway and Highway 290, commuters enjoy the ease of access to the Energy Corridor, Houston Premium Outlets, and Downtown Houston. Schools are a part of the top-rated Cypress-Fairbanks ISD. Don’t miss out – call now for more information!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 17 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '980' ,`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` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WALKER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Marvida' ,`TaxAmount` = '' ,`TaxRate` = '3.59' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216639' WHERE `Matrix_Unique_ID` = '208689652' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-20T11:13:42.703' ,`MLSNumber` = '47744883' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.336410' ,`Longitude` = '-95.058500' ,`PhotoCount` = '26' ,`PostalCode` = '77327' ,`RoomCount` = '4' ,`ListPrice` = '239990.00' ,`Status` = 'Active' ,`StreetName` = 'Spring Creek' ,`StreetNumber` = '10031' ,`StreetSuffix` = 'Road' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1699' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous Cypress - D home with Brick and Stone Front Elevation and an enjoyable large Covered Front Porch! Granite Kitchen Countertop and 42\" Pebble Cabinets! Lofty 9\' Ceilings in Living Areas and Primary Bedroom. Super Shower with a Glass Door in Primary Bathroom! Quartz Countertops in all the Bathrooms. Stainless Steel Gas Range, Microwave, and Dishwasher. Very large 14 x 10 Uncovered Back Patio.' ,`Acres` = '' ,`Area` = '52' ,`BuilderName` = 'Rausch Coleman Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'N/A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'EASTSIDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Oaks Reserve' ,`TaxAmount` = '' ,`TaxRate` = '2.56' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216639' WHERE `Matrix_Unique_ID` = '210355472' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-20T11:51:10.740' ,`MLSNumber` = '67378173' ,`ListAgentFullName` = 'Thomas Murphy' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.060397' ,`Longitude` = '-95.659535' ,`PhotoCount` = '36' ,`PostalCode` = '77377' ,`RoomCount` = '7' ,`ListPrice` = '700000.00' ,`Status` = 'Active' ,`StreetName` = 'Cypress Garden' ,`StreetNumber` = '15703' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2656' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOTIVATED SELLER. Income producing property on 1.6+ acres convenient to 99 and Tomball. Property is unrestricted and has plenty of space to park construction equipment. There is a large workshop and other storage areas and buildings on the property. This property is designed for multiple families. Seller lives in the 3 bedroom double wide mobile home which could be use for office space or leased for about $1,600/month. The double wide has an enclosed room on the back approximately 42X13. Plus 2 gazebos 13X13. The other dwellings on the property are currently being leased for an approximate total of $4,000/month. The front and back apartments share a utility room with washer and dryer. Property has its own water well.' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 32 CYPRESS GARDENS U/R ABST 372 J M HOOPER' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '81000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Cypress Garden U/R' ,`TaxAmount` = '2529' ,`TaxRate` = '2.0872' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675216639' WHERE `Matrix_Unique_ID` = '210636132' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-20T12:28:50.710' ,`MLSNumber` = '20132969' ,`ListAgentFullName` = 'Claudia Da Silva' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.195078' ,`Longitude` = '-95.539002' ,`PhotoCount` = '50' ,`PostalCode` = '77382' ,`RoomCount` = '25' ,`ListPrice` = '6900000.00' ,`Status` = 'Active' ,`StreetName` = 'Grand Regency' ,`StreetNumber` = '51' ,`StreetSuffix` = 'Circle' ,`City` = 'The Woodlands' ,`BathsFull` = '8' ,`BathsHalf` = '4' ,`BedsTotal` = '8' ,`SqFtTotal` = '21353' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Introducing an extraordinary estate that is sure to impress. This 21,000 sf home offers the ultimate in luxury living on a sprawling 2.5 acres of breathtaking grounds. From the classic moldings and American Cherry Hardwoods to the Venetian Plaster and Rocky Mountain Hardware, this residence features all of the elegant touches you could ever want in a luxurious home. The heart of this home is its grand kitchen with double islands, double dishwashers, coffee stations, and Viking & Subzero appliances, perfect for entertaining guests or enjoying meals with loved ones! Enjoy views from the kitchen/breakfast area overlooking both pool and golf course. A 300+ bottle wine room for all your favorite vintages! This estate also offers a library complete with private office as well as mature trees throughout its landscaped grounds. Situated between Bear Branch Lake and Jack Nicklaus golf course holes No 7 & 8 - there’s no better place to call home than this stunning property!' ,`Acres` = '2.4331' ,`Area` = '15' ,`BuilderName` = 'Charles R Martin' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '8' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'WDLNDS VIL OF CARLTON WOODS 04, BLOCK 1, LOT 20' ,`LotDesciption` = 'On Golf Course,Water View,Wooded' ,`LotSize` = '105986' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '4250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '9' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'TOUGH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'French' ,`Subdivision` = 'Wdlnds Village Of Carlton Woods 04' ,`TaxAmount` = '106492' ,`TaxRate` = '2.1816' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675216640' WHERE `Matrix_Unique_ID` = '210895843' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-20T11:51:04.313' ,`MLSNumber` = '96677843' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.897893' ,`Longitude` = '-95.739605' ,`PhotoCount` = '6' ,`PostalCode` = '77433' ,`RoomCount` = '15' ,`ListPrice` = '449990.00' ,`Status` = 'Active' ,`StreetName` = 'Costalinda' ,`StreetNumber` = '21323' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2751' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. Create unforgettable memories in this incredible Briarwood Home in Marvida! Situated on a spacious lot, this 4-sided brick home boasts a stone elevation, tile flooring, full gutters, sprinkler system, crown molding, wrought iron spindles, faux wood blinds, a cast stone fireplace, study with French doors, and spacious covered patio. Master new recipes in the kitchen, complete with stainless steel appliances, 42” upper cabinets, pendant lighting, and undercabinet lighting. Residents of Marvida enjoy clubhouses, pools, playgrounds, state-of-the-art workout facilities, tennis courts, basketball courts, and a dog park. Situated near the Grand Parkway and Highway 290, commuters enjoy the ease of access to the Energy Corridor, Houston Premium Outlets, and Downtown Houston. Zoned to the top-rated Cypress-Fairbanks ISD. Call now to learn more!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Briarwood Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '980' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'ANDRE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Marvida' ,`TaxAmount` = '' ,`TaxRate` = '3.59' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216640' WHERE `Matrix_Unique_ID` = '211445067' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-20T12:39:06.017' ,`MLSNumber` = '8199396' ,`ListAgentFullName` = 'Traci Crawford' ,`ListOfficeName` = 'Origen Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.013412' ,`Longitude` = '-95.147637' ,`PhotoCount` = '50' ,`PostalCode` = '77346' ,`RoomCount` = '6' ,`ListPrice` = '600000.00' ,`Status` = 'Active' ,`StreetName` = 'Atascocita Lake' ,`StreetNumber` = '8511' ,`StreetSuffix` = 'Way' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '4595' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 6 bedroom, 3.5 bathroom, 3-car garage home is perfectly situated on 2 lots on The Golf Preserve of Atascocita. Inside you are greeted by new engineered hardwood floors in the foyer, an office/study, formal dining room, formal living room, and welcomed into the family great room. The chef\'s kitchen boasts a ton of cabinet space, 2 pantries, and all new appliances that will convey with the property. The living room/den is open to kitchen and is perfect for entertaining with all of the space, natural light, tall ceilings, and beautiful built-ins. The primary bedroom is located downstairs with a completely remodeled bathroom with walk-in shower and 2 walk-in closets. Double staircases lead up to 5 additional bedrooms with walk-in closets, 2 full bathrooms, oversized game room, and many attic entrances for additional storage and easy access to HVAC system and 2 new water heaters. If you are looking for a serene neighborhood with plenty of space, call for your showing today!' ,`Acres` = '0.4058' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LTS 23 & 24 BLK 2 PINEHURST OF ATASCOCITA SEC 11' ,`LotDesciption` = 'On Golf Course,Subdivision Lot' ,`LotSize` = '17675' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1125' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'PINEFOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pinehurst Atascocita Sec 11' ,`TaxAmount` = '8597' ,`TaxRate` = '2.216' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216640' WHERE `Matrix_Unique_ID` = '211586988' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-20T12:46:29.357' ,`MLSNumber` = '44407310' ,`ListAgentFullName` = 'Nancy Andrade' ,`ListOfficeName` = 'AAA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.028170' ,`Longitude` = '-95.447873' ,`PhotoCount` = '21' ,`PostalCode` = '77090' ,`RoomCount` = '4' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Redleaf' ,`StreetNumber` = '727' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3170' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifull Home! Never Flooded. Just reduce, this house has a great floor plan with spacious 4-bedroom, 2.5 baths, with formal dining area, and an office/study room. Brick front porch elevation with great curve appeal, tile floors on the first floor, and carpet on the second floor. Brand New Roof. A/C is 4 years old. Granite counter tops both in the kitchen and bathrooms. Big back yard with detached garage. Quiet community, close to I-45 and shopping area. Come see it; you won\'t be disappointed!' ,`Acres` = '0.2152' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 59 BLK 2 WESTADOR SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9375' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '590' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'BAMMEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westador Sec 05' ,`TaxAmount` = '5897' ,`TaxRate` = '2.3072' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216640' WHERE `Matrix_Unique_ID` = '211835734' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-20T12:04:13.417' ,`MLSNumber` = '37355978' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.816346' ,`Longitude` = '-95.784454' ,`PhotoCount` = '15' ,`PostalCode` = '77493' ,`RoomCount` = '16' ,`ListPrice` = '521990.00' ,`Status` = 'Active' ,`StreetName` = 'Persimmon Creek' ,`StreetNumber` = '23635' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3510' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. Settle into this gorgeous Briarwood Home in Morton Creek Ranch! Resting on a spacious lot, this 4-sided brick home boasts a brick and stone elevation, tile flooring, full gutters, sprinkler systems, crown molding, curved staircase, wrought iron spindles, faux wood blinds, cast stone fireplace, game and media rooms, study with French doors, and an extended covered patio. Impress your guests in the kitchen, complete with stainless steel appliances, 42” upper cabinets, pendant lighting, and undercabinet lighting. Community amenities include a playground, splash pad, children’s play area, and recreation center with a pavilion. Commuters enjoy close proximity to I-10 and the Grand Parkway. Delve into premier shopping, dining, and entertainment at Katy Mills Mall and LaCenterra at Cinco Ranch. Zoned to the nationally recognized Katy ISD.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Briarwood Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 15 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '598' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'LEONARD ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Morton Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.39' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216641' WHERE `Matrix_Unique_ID` = '212201021' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-20T11:42:29.387' ,`MLSNumber` = '30832997' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.816346' ,`Longitude` = '-95.784454' ,`PhotoCount` = '19' ,`PostalCode` = '77493' ,`RoomCount` = '14' ,`ListPrice` = '464990.00' ,`Status` = 'Active' ,`StreetName` = 'Batesville' ,`StreetNumber` = '23626' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2831' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. You don’t want to miss this incredible Lakewood Home in Morton Creek Ranch. Resting on a spacious cul-de-sac lot, this 4-sided brick home boasts a premium elevation, no back neighbors, tile flooring, full gutters, sprinkler system, wrought iron spindles, faux wood blinds, and an extended covered patio. Dream up new recipes in the kitchen, equipped with granite countertops, stainless steel appliances, 42” upper cabinets, pendant lighting, and undercabinet lighting. Community comforts include a playground, splash pad, a children’s play area, and a recreation center with a pavilion. Located off I-10 and the Grand Parkway, residents enjoy close proximity to popular dining and shopping at the Katy Mills Mall. Zoned to the highly acclaimed Katy ISD. Call today to book your private tour!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Lakewood Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 7 Block 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '598' ,`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` = '30 - Katy' ,`SchoolElementary` = 'LEONARD ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Morton Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.39' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216641' WHERE `Matrix_Unique_ID` = '212201384' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-20T11:16:02.820' ,`MLSNumber` = '90466097' ,`ListAgentFullName` = 'Dayna Simmons' ,`ListOfficeName` = 'Dayna Simmons Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.110432' ,`Longitude` = '-94.155655' ,`PhotoCount` = '35' ,`PostalCode` = '77706' ,`RoomCount` = '16' ,`ListPrice` = '1250000.00' ,`Status` = 'Active' ,`StreetName` = 'Littlewood Dr' ,`StreetNumber` = '4845' ,`StreetSuffix` = '' ,`City` = 'Beaumont' ,`BathsFull` = '4' ,`BathsHalf` = '3' ,`BedsTotal` = '7' ,`SqFtTotal` = '8990' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stately, one-of-a-kind Hill Country inspired estate was built in 1989 by Bill Little Construction, then later designed by David Davis in collaboration with builder Mike Jenkins for a renovated Rustic French Country feel. Use of different stones and woods, gorgeous 90 year old flooring, rustic 165 year old beams from Pennsylvania all add to the old world feel. Various applications of finishes in the house include the fauxs, crackles, and glazes. Extensive use of granite on nearly all countertops provide a great look with functionality. With 7bedrooms, 7 bathrooms, a study, home theatre, game room, and large shop - there\'s plenty more to see in this stunner.' ,`Acres` = '1.04' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 53 BLK 2 BELLECHASE SEC 2 PHASE II' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '45540' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'REGINAL-HOWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WEST BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL (BEAUMONT)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2.5' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Bellechase Sec 02 Ph 02' ,`TaxAmount` = '21018' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216641' WHERE `Matrix_Unique_ID` = '212216795' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-20T11:50:31.070' ,`MLSNumber` = '91685490' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.897854' ,`Longitude` = '-95.739542' ,`PhotoCount` = '40' ,`PostalCode` = '77433' ,`RoomCount` = '12' ,`ListPrice` = '455990.00' ,`Status` = 'Active' ,`StreetName` = 'Costalinda' ,`StreetNumber` = '21322' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2780' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cherish unforgettable moments in this stunning Briarwood home in Marvida. This 4-sided brick home boasts a premium elevation, tile flooring, wrought iron spindles, faux wood blinds, a natural stone fireplace, and a covered patio. Spend quality time in the island kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, 42” upper cabinets, and undercabinet lighting. Unwind in the serene primary suite features dual vanities, a drop-in tub, and a separate shower. Community comforts of Marvida include clubhouses, pools, splash pads, tennis courts, sports courts, parks, playgrounds, and a dog park. Commuters enjoy the ease of access to Katy, the Energy Corridor, and Downtown Houston via the Grand Parkway and Highway 290. Nearby schools are zoned to the Cypress-Fairbanks ISD. Don’t miss this home – call now to learn more!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Briarwood Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '980' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'ANDRE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Marvida' ,`TaxAmount` = '' ,`TaxRate` = '3.59' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216641' WHERE `Matrix_Unique_ID` = '212262729' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-20T11:53:30.807' ,`MLSNumber` = '42116833' ,`ListAgentFullName` = 'Lisa Corker' ,`ListOfficeName` = 'Hart Land Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.888101' ,`Longitude` = '-96.872392' ,`PhotoCount` = '30' ,`PostalCode` = '78945' ,`RoomCount` = '4' ,`ListPrice` = '445000.00' ,`Status` = 'Active' ,`StreetName` = 'Kathleen' ,`StreetNumber` = '102' ,`StreetSuffix` = 'Avenue' ,`City` = 'La Grange' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1726' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'For those looking to downsize, this is the perfect home! With a low-maintenance yard and smaller house size, you\'ll have more time to enjoy doing the things you want to do. You\'ll love the easy-care stained concrete floors and the primary bedroom with his and her custom closets, double vanity, and walk-in shower. The kitchen has a copper farmhouse sink, stainless appliances, eat-in bar, and is open to the dining and family room. When you\'re ready to relax outdoors, step out onto the covered patio with built-in gas grill. Located in the prestigious gated community aptly named \"The View,\" which sits on the bluff overlooking the Colorado River. You\'ll love calling The View home.' ,`Acres` = '0.1762' ,`Area` = '69' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'THE VIEW LOT 20, 0.1762 ACRES, HSE, GAR' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '7675' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '205 - La Grange' ,`SchoolElementary` = 'HERMES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA GRANGE HIGH SCHOOL' ,`SchoolMiddle` = 'LA GRANGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The View' ,`TaxAmount` = '3750' ,`TaxRate` = '1.8546' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216642' WHERE `Matrix_Unique_ID` = '212267220' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-20T12:38:25.770' ,`MLSNumber` = '90048940' ,`ListAgentFullName` = 'LaVonda Potts' ,`ListOfficeName` = 'TBT Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.114334' ,`Longitude` = '-95.083345' ,`PhotoCount` = '34' ,`PostalCode` = '77554' ,`RoomCount` = '7' ,`ListPrice` = '795000.00' ,`Status` = 'Active' ,`StreetName` = 'Monterey' ,`StreetNumber` = '25007' ,`StreetSuffix` = 'Court' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2566' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful beach views from living area and primary bedroom balconies. Downstairs entertaining area with soothing Swim Spa, Grand kitchen with abundant custom cabinets and breakfast bar, granite countertops, open concept into inviting living area with gorgeous rich wood tray ceiling, cozy gas log fireplace, hardwood and tile flooring, windows with amazing view of the beach, Spacious bedrooms, a welcome personal retreat in the primary bedroom with relaxing beach view, two car garage attached with outside shower. Standing ovation for this location. Home is furnished with some exclusions.' ,`Acres` = '0.1847' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 PAGE 10 LOT 27 BLK 1 LAGUNA SAN LUIS SUB' ,`LotDesciption` = 'Water View' ,`LotSize` = '8045' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Leave Business Card,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Laguna San Luis 88' ,`TaxAmount` = '11644' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216642' WHERE `Matrix_Unique_ID` = '212311237' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-20T12:53:55.160' ,`MLSNumber` = '36601332' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.817504' ,`Longitude` = '-95.785111' ,`PhotoCount` = '19' ,`PostalCode` = '77493' ,`RoomCount` = '12' ,`ListPrice` = '389990.00' ,`Status` = 'Active' ,`StreetName` = 'Dawn Redwood' ,`StreetNumber` = '3231' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2620' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. Escape the city to this charming Lake Ridge Builders home in Morton Creek Ranch! Situated on a spacious lot, this 3-sided brick home boasts a premium elevation, wood-look tile flooring, full gutters, a sprinkler system, wrought iron spindles, faux wood blinds, a study with French doors, and a covered patio. Spend all day in the kitchen, fully equipped with granite countertops, tile backsplash, stainless steel appliances, 42” upper cabinets, and undercabinet lighting. Seek comfort in the serene primary suite, featuring dual vanities, a 42” tub, and a separate shower. Community comforts include a playground, splash pad, children’s play area, and a recreation center with a pavilion. Located off I-10 and the Grand Parkway, residents enjoy close proximity to popular dining and shopping at the Katy Mills Mall. Zoned to the highly acclaimed Katy ISD. Call today to book your private tour!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 6 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '615' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'LEONARD ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Morton Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.47' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216642' WHERE `Matrix_Unique_ID` = '212352939' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-20T11:36:07.180' ,`MLSNumber` = '85212789' ,`ListAgentFullName` = 'Alexander Joseph' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.184134' ,`Longitude` = '-94.975122' ,`PhotoCount` = '50' ,`PostalCode` = '77554' ,`RoomCount` = '6' ,`ListPrice` = '589000.00' ,`Status` = 'Active' ,`StreetName` = 'Captain Kidd' ,`StreetNumber` = '16614' ,`StreetSuffix` = 'Road' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2044' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3 Bed/3 Bath home (+spacious 2nd story loft) on an Oversized Lot in Jamaica Beach w/potential to sleep 12-16. Excellent ground level living space for family and in-laws. Master en-suite w/private deck. Large loft on second level-ideal for gameroom, theatre, office or convert to 4th bedroom. Recent updates/upgrades: 2020 - New Hardi-Plank exterior, storm windows, Vinyl Plank flooring, Recessed lighting. 2021 - 12 pilings, new roof, new plumbing/elec in areas of home plus all new downstairs. Quartz countertops in custom designed kitchen w/large island, new SS appliances and built-in microwave. Bathrooms updated with quartz counters and new fixtures. 2” Blinds on all windows. Full width deck across front plus private deck off master suite. Covered area below w/concrete pad for addt\'l space to install a palapa, hot tub, outdoor kitchen...Walk, ride your bike or golf cart to the beach...4 short blocks away. Jamaica Beach is it\'s own municipality with Police/Fire/EMS and private park/pool' ,`Acres` = '0.201' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 6 BLK 3 JAMAICA BEACH SEC 1 RE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8760' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '10' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Jamaica Beach' ,`TaxAmount` = '4200' ,`TaxRate` = '1.7044' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216642' WHERE `Matrix_Unique_ID` = '212817964' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-20T11:12:54.407' ,`MLSNumber` = '30546976' ,`ListAgentFullName` = 'Marina Okorocha' ,`ListOfficeName` = 'Lone Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.727960' ,`Longitude` = '-95.543480' ,`PhotoCount` = '22' ,`PostalCode` = '77320' ,`RoomCount` = '11' ,`ListPrice` = '179000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue F' ,`StreetNumber` = '701' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2304' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Hidden Treasure is less than Minutes away from I-45, and Sam Houston University. Natural lighting, all Brick Home has plush white carpet in oversized bedrooms; ready to be styled and decorated; humongous bathrooms with vanity. Not to mention there are Skylights throughout the home! Take a walk to the historic downtown loaded with family fun and festivities for the seasons! The property Depicts mature oak and pine trees in a peaceful neighborhood. Relax under the covered patio porch and covered car parking spaces. This nice-sized home sits on half an acre of land. Don’t miss out on this Gem of an opportunity to own your own Country Oasis. Under market value. ' ,`Acres` = '0.5422' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WOODLAWN, LOT 34, 35, 36, 37' ,`LotDesciption` = 'Corner' ,`LotSize` = '23618' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'HUNTSVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Lockbox Left Side,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'WOODLAWN' ,`TaxAmount` = '3799' ,`TaxRate` = '1.901719' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216643' WHERE `Matrix_Unique_ID` = '212924157' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-20T11:05:24.437' ,`MLSNumber` = '96409645' ,`ListAgentFullName` = 'Laura Parks' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.589322' ,`Longitude` = '-95.567466' ,`PhotoCount` = '38' ,`PostalCode` = '77459' ,`RoomCount` = '11' ,`ListPrice` = '429000.00' ,`Status` = 'Active' ,`StreetName` = 'Brightwood' ,`StreetNumber` = '4007' ,`StreetSuffix` = 'Street' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3325' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2 story, well maintained,one owner, 4 bedroom 2.5 baths on a cul-de-sac with attached garage. Large 2 story open foyer with office on one side and living room on the other. No carpet downstairs.Waterproof laminate and tile are throughout the 1st floor.Large addition on 1st floor with its own a/c unit can be a great 2nd study or second family room.Kitchen has granite counters,island cooktop,under cabinet lighting and cedar ceiling.Refrigerator is included.Large size utility room. Lots of built-in bookcase and crown molding throughout house. Upstairs carpet was just installed. Every bedroom has a walk-in closet and ceiling fan. Primary has 2 walk-in closets. Backyard has a fountain and patio for a great place to relax with plenty of grass space also. Cedar on all garage walls. Double paned windows along the back side of the house on 1st and 2nd floor. Roof is 2 years old.Water heater is 4 years old. Subdivision has tennis courts,pool,and beautiful path along lake with benches.' ,`Acres` = '0.1812' ,`Area` = '29' ,`BuilderName` = 'Perry' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKESHORE AT BRIGHTWATER SEC 1, BLOCK 1, LOT 25' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7892' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '815' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEXINGTON CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakeshore At Brightwater Sec 1' ,`TaxAmount` = '7901' ,`TaxRate` = '2.71' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216643' WHERE `Matrix_Unique_ID` = '212971660' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-20T11:39:50.863' ,`MLSNumber` = '77725660' ,`ListAgentFullName` = 'Aly Garza Ferrante' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.664701' ,`Longitude` = '-95.472536' ,`PhotoCount` = '27' ,`PostalCode` = '77096' ,`RoomCount` = '3' ,`ListPrice` = '380000.00' ,`Status` = 'Active' ,`StreetName` = 'Stillbrooke' ,`StreetNumber` = '5255' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1634' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 5255 Stillbrooke Drive in the established Westbury subdivision. This fully remodeled home awaits new owner! Stunning curb appeal with painted white brick and black wood accents invites guest in. Open floor plan of the shared living space is bright, warm and elegant. Spacious living area, kitchen, and dining spaces flow effortlessly. Enjoy evenings by the fire, host holiday parties, or just enjoy everyday living in this great space. Primary retreat with en suite bath featuring double sinks, and separate tub and shower. Two additional bedrooms share a bath with walk-in shower. Beautifully remodeled, neutral colors, and stunning finishes make this home the perfect canvas to make this space your own. Roof replaced in 2016, new water heater in 2018, new AC in 2017, never flooded. Just outside the 610 loop for quick access and commutes in and around the Metro Area.' ,`Acres` = '0.1917' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 16 BLK 31 WESTBURY SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8350' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '365' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PARKER ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Westbury Sec 02' ,`TaxAmount` = '6409' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216643' WHERE `Matrix_Unique_ID` = '213033262' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-20T12:19:27.270' ,`MLSNumber` = '90773437' ,`ListAgentFullName` = 'Beverly Smith' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.422861' ,`Longitude` = '-95.641082' ,`PhotoCount` = '41' ,`PostalCode` = '77356' ,`RoomCount` = '13' ,`ListPrice` = '1399000.00' ,`Status` = 'Active' ,`StreetName` = 'W Shore' ,`StreetNumber` = '26' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '5366' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Beautiful Custom Home on the #5 hole of the Miller Golf Course immediately impresses you with a wall of windows for fabulous views of Lake Conroe in the gated community of Bentwater. Walking into the home through the front door captures the stunning views of the golf course and Lake Conroe. A focal point is a gourmet kitchen including bamboo floors, 6 burner gas cooktop, 2 ovens, warming drawer, 2 dishwashers and 2 stainless sinks with garbage disposals along with enough counter space for great preparatory work. The 2 primary bedrooms on two levels connected by an elevator between all three levels have private balconies, In addition to a guest bedroom on floor 3, there is a downstairs office, TV room or Bunk Bedroom possibility with full bath to accommodate many friends and family to spend the night. Additional extras include an exercise room, library/study, TV room, dry sauna, heated pool with lush landscaping and a 500 square foot primary bedroom closet.' ,`Acres` = '0.377' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Bentwater 44, Block 1, Lot 9' ,`LotDesciption` = 'In Golf Course Community,On Golf Course,Water View' ,`LotSize` = '16424' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1146' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '3' ,`Style` = 'Mediterranean,Spanish' ,`Subdivision` = 'Bentwater' ,`TaxAmount` = '14748' ,`TaxRate` = '2.4383' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675216643' WHERE `Matrix_Unique_ID` = '213193927' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-20T12:04:15.507' ,`MLSNumber` = '67118913' ,`ListAgentFullName` = 'Rebecca Ramirez' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.192845' ,`Longitude` = '-95.813032' ,`PhotoCount` = '32' ,`PostalCode` = '77355' ,`RoomCount` = '8' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Bluff View' ,`StreetNumber` = '25361' ,`StreetSuffix` = 'Court' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1920' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '4-bedroom 2-bathroom split floorplan home on just over ½ acre lot with mature shade trees located in Magnolia. Exterior features: cement board, back patio deck with seating space, and fencing. Kitchen includes an island with: sink, storage, and breakfast bar seating; also, breakfast nook seating area. Primary bedroom with en suite bathroom that has separate shower and soaking tub, and dual sinks. In house utility room. Close access to 1488, 1774, 1486, and 249.' ,`Acres` = '0.52' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Waller' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S732301 REMINGTON FOREST 1 BLK 3 LOT 13 ACRES .52 S# OC01122' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '22651' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'FIELDS STORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Remington Forest' ,`TaxAmount` = '3894' ,`TaxRate` = '2.0243' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216644' WHERE `Matrix_Unique_ID` = '213221074' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-20T11:59:02.033' ,`MLSNumber` = '3075805' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.838029' ,`Longitude` = '-95.693304' ,`PhotoCount` = '10' ,`PostalCode` = '77084' ,`RoomCount` = '15' ,`ListPrice` = '445990.00' ,`Status` = 'Active' ,`StreetName` = 'Gardens End' ,`StreetNumber` = '18127' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2848' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This house is under construction. Make new memories in this incredible Lakewood Home in Grand Oaks! Nestled on a spacious lot, this 4-side brick home boasts tile flooring, full gutters, crown molding, wrought iron spindles, faux wood blinds, a cast stone fireplace, and a covered patio. No recipe is a challenge in the kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, 42” upper cabinets, pendant lighting, and undercabinet lighting. Community amenities include an Olympic-size swimming pool with water slides, walking trails, and a playground. Situated near I-10, Hwy 6, and the Grand Parkway, residents enjoy easy access to the Energy Corridor and plenty of dining and shopping options. Nearby schools are a part of the highly-acclaimed Cypress-Fairbanks ISD. Call today to book your private showing!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Lakewood Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 25 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '7