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-19T11:39:40.320' ,`MLSNumber` = '74570258' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.193528' ,`Longitude` = '-95.423706' ,`PhotoCount` = '44' ,`PostalCode` = '77385' ,`RoomCount` = '14' ,`ListPrice` = '599990.00' ,`Status` = 'Active' ,`StreetName` = 'Shoebutton' ,`StreetNumber` = '17519' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3344' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This popular Shea Home features beautiful finishes like high ceilings, eight-foot doors, great room fireplace, wood floors throughout with stain treads and painted risers. At the center of it all is an impressive kitchen with stainless-steel appliances including dishwasher, double ovens, a 36-inch 5 burner gas cooktop, built-in microwave, and gorgeous wood-vent hood. This home has plenty of room to entertain and enjoy with family and friends. Retreat upstairs to this home’s massive game room and media room for endless game time and movie nights with the family. This home has it all and is a homeowner’s dream. Be sure to put this home at the top of your list. Included are 2 bedrooms down & 2 large bedrooms up, 3 bathrooms, game room, media room, study, great room fireplace, laundry off primary closet, outdoor living, 3 car garage, brick elevation, and more!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Shea Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 14 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1128' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SUCHMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'South Village Harpers Preserve' ,`TaxAmount` = '' ,`TaxRate` = '3' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216179' WHERE `Matrix_Unique_ID` = '206801592' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T12:20:02.603' ,`MLSNumber` = '5944928' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'KB Home Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.482009' ,`Longitude` = '-95.470549' ,`PhotoCount` = '6' ,`PostalCode` = '77583' ,`RoomCount` = '11' ,`ListPrice` = '334995.00' ,`Status` = 'Active' ,`StreetName` = 'Bakersfield' ,`StreetNumber` = '7211' ,`StreetSuffix` = 'Court' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2372' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Enjoy peace and quiet in this beautiful KB Home on an oversized lot in Glendale Lakes, boasting a brick front and stone veneer, boasting vinyl plank flooring, wrought iron spindles, and an open great room. Prepare incredible feasts in the kitchen, equipped with granite countertops, tile backsplash, stainless steel Energy Star® appliances, 42-in. cabinets, and pendant lighting. Unwind in the serene primary suite, featuring extended dual vanities, a 42-in. Kohler Master Windward® tub, and a separate shower. Additional home features include faux wood blinds, full gutters, and an extended covered patio. Community comforts of Glendale lakes include a jr. Olympic-sized swimming pool, a park, playground, and a clubhouse. Situated off FM-521, Hwy 288, and Beltway 8, commuters enjoy the ease of access to downtown Houston, Pearland, Sugarland, and Texas Medical Center. Zoned to the Fort Bend ISD.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'KB Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9 Block 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Glendale Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216179' WHERE `Matrix_Unique_ID` = '207376461' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T11:31:03.510' ,`MLSNumber` = '5412500' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.680377' ,`Longitude` = '-95.832787' ,`PhotoCount` = '33' ,`PostalCode` = '77406' ,`RoomCount` = '8' ,`ListPrice` = '599988.00' ,`Status` = 'Active' ,`StreetName` = 'Aurora Valley' ,`StreetNumber` = '26302' ,`StreetSuffix` = 'Way' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2858' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This attractive, sizeable one-story home is located on a corner lot with an ample yard! Many upgrades throughout the home include the kitchen cabinetry, flooring, and elevation. The floor plan has soaring ceilings and a luxurious primary bath suite- a must-see! This home will not last in Candela. One of the hottest locations in west Houston, with excellent schools and amenities.' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Coventry' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1 Block 2' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven,Single 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` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'English,Traditional' ,`Subdivision` = 'Candela' ,`TaxAmount` = '' ,`TaxRate` = '3.17' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216180' WHERE `Matrix_Unique_ID` = '210069570' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T11:24:51.647' ,`MLSNumber` = '7866107' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.679475' ,`Longitude` = '-95.831698' ,`PhotoCount` = '33' ,`PostalCode` = '77406' ,`RoomCount` = '8' ,`ListPrice` = '439111.00' ,`Status` = 'Active' ,`StreetName` = 'Cecilia Star' ,`StreetNumber` = '10526' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1871' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this charming one-story design. The 8\' front door will welcome you into the open-concept layout. At the heart of the home, you will discover the family room and kitchen. The gourmet kitchen boasts a large granite island, 42-inch cabinets and stainless-steel appliances, perfect for the chef of the house. This home has 3 bedrooms, 2 full bathrooms, a powder room, and a perfectly situated study with french doors. The primary bedroom is secluded at the back of the home complemented by beautiful bowed windows and a primary bath that features separate sinks. Take entertaining outdoors on the Texas-sized covered patio where there is plenty of room for enjoyment. This home is certified Environments for Living and offers some of the highest energy features. Come visit this beautiful home today!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 16 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5428' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas 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` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Candela' ,`TaxAmount` = '' ,`TaxRate` = '3.14' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216180' WHERE `Matrix_Unique_ID` = '210071770' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T11:51:33.673' ,`MLSNumber` = '61493496' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.211148' ,`Longitude` = '-95.329843' ,`PhotoCount` = '38' ,`PostalCode` = '77302' ,`RoomCount` = '9' ,`ListPrice` = '409859.00' ,`Status` = 'Active' ,`StreetName` = 'Vino Vines' ,`StreetNumber` = '17423' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2041' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning home greets you with a stunning elevation. Featuring an open concept design, this home is ideal for entertaining. Entering through the foyer, you will be led into the casual dining area overlooking the gourmet kitchen featuring omega stone countertops. The chef of the family will enjoy preparing everyone’s favorite dishes in the kitchen equipped with a spacious island. Complete with a secondary bedroom with full bath situated on the first floor, this home has it all. Come see this spectacular home today!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 10 BLOCK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5194' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Artavia' ,`TaxAmount` = '' ,`TaxRate` = '3.18' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216180' WHERE `Matrix_Unique_ID` = '210404079' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T11:52:24.543' ,`MLSNumber` = '69042756' ,`ListAgentFullName` = 'Irma Lucadou' ,`ListOfficeName` = 'Prime Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.753971' ,`Longitude` = '-95.344961' ,`PhotoCount` = '12' ,`PostalCode` = '77003' ,`RoomCount` = '6' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Nagle' ,`StreetNumber` = '118' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1471' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a re-work of the description: Ready to redevelop or renovate, this property is perfectly located! Walk to Minute Maid and PNC stadiums or Original Ninfas, El Tiempo Cantina and Moontower Inn for eats and drinks. Very convenient to doctors, dentists, hospital, metro, schools/college, parks and everything in and around downtown. Avoid railroad hold-ups with nearby underpasses and is not influenced by the I-45 expansion project. The area is quickly developing with new construction and this address is a residential sweet spot that will add tremendous value to your project. Never flooded.' ,`Acres` = '0.1331' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 14 SETTEGAST SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BURNET ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Settegast Sec 03' ,`TaxAmount` = '4247' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1935' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216180' WHERE `Matrix_Unique_ID` = '210412266' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T11:53:46.957' ,`MLSNumber` = '77388092' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.152023' ,`Longitude` = '-95.582370' ,`PhotoCount` = '28' ,`PostalCode` = '77354' ,`RoomCount` = '17' ,`ListPrice` = '649863.00' ,`Status` = 'Active' ,`StreetName` = 'Chartres Wind' ,`StreetNumber` = '8215' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Asher V, Elevation A) CURRENTLY BEING BUILT. Two story. 5 bedrooms. 4.5 baths. Elegant double front door entry, Family room, informal dining room and study. Spacious island kitchen open to family room. Primary suite with large double walk-in closets and secondary bedroom on first floor. Three additional bedrooms, spacious game room and media room on second floor. Attached 3-car tandem garage. NorthGrove offers easy access to all the conveniences and necessities of modern living with The Woodlands, Tomball, and Conroe all a short distance away. With resort-style amenities, including The Retreat, a 9,400-sq.-ft. clubhouse, Northgrove is the perfect escape from the daily grind. Enjoy a fitness center, pool, children\'s play areas and more. Stop by the Westin Homes model home today to find out more about Northgrove!' ,`Acres` = '0.2187' ,`Area` = '15' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BLOCK 2, LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9526' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1295' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Northgrove' ,`TaxAmount` = '2250' ,`TaxRate` = '3.21' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216180' WHERE `Matrix_Unique_ID` = '211274716' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T11:03:10.270' ,`MLSNumber` = '71336350' ,`ListAgentFullName` = 'Joana Benavides' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.873315' ,`Longitude` = '-95.447342' ,`PhotoCount` = '29' ,`PostalCode` = '77088' ,`RoomCount` = '3' ,`ListPrice` = '318000.00' ,`Status` = 'Active' ,`StreetName` = 'Moon Beam' ,`StreetNumber` = '8022' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1682' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THIS BEAUTIFUL NEW CONSTRUCTION 3 BEDROOM 2 BATH HOME IN ACRES HOMES IS 1674SQ FT. \r\nNO RESTRICTIONS, NO HOA. OPEN FLOOR PLAN, QUARTZ KITCHEN COUNTERTOP, CEILING FANS, COVERED PATIO, TILE FLOORING IN COMMON AREAS AND CARPET IN BEDROOMS. DOUBLE SINK IN MASTE BATH WITH LARGE SPACIOUS SHOWER. PLENTY OF STORAGE SPACE AND WASHER/DRYER CONNECTIONS.' ,`Acres` = '0.4083' ,`Area` = '11' ,`BuilderName` = 'RAKK PROPERTIES LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lt 2 BLK 15 HARVEST HEIGHTS ANNEX SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7292' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'ANDERSON ACADEMY' ,`SchoolHigh` = 'CARVER H S FOR APPLIED TECH/ENGINEERING/ARTS' ,`SchoolMiddle` = 'DREW ACADEMY' ,`ShowInstructions` = 'Accompany,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harvest Heights Annex Sec 02' ,`TaxAmount` = '' ,`TaxRate` = '2.5119' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216181' WHERE `Matrix_Unique_ID` = '211893834' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T11:34:25.787' ,`MLSNumber` = '97149375' ,`ListAgentFullName` = 'Jose Ramon' ,`ListOfficeName` = 'Can-2 Realty' ,`SellingAgentFullName` = 'Jose Ramon' ,`SellingOfficeName` = 'Can-2 Realty' ,`Latitude` = '29.784526' ,`Longitude` = '-95.188897' ,`PhotoCount` = '14' ,`PostalCode` = '77015' ,`RoomCount` = '7' ,`ListPrice` = '210000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Indianapolis' ,`StreetNumber` = '13347' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1518' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Never Flooded!! This Home features an amazing small apartment it could be consider a Duplex with an additional Driveway and gate, covered carport, A/C unit is 2 years old, Beautiful ornate Iron fence. This Property is a must See!' ,`Acres` = '0.1791' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 889 BLK 3O HOME OWNED ESTATES SEC 2A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'CIMARRON ELEMENTARY SCHOOL (GALENA PARK)' ,`SchoolHigh` = 'NORTH SHORE SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'NORTH SHORE MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Home Owned Estates Sec 02a' ,`TaxAmount` = '2849' ,`TaxRate` = '2.7702' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1952' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216181' WHERE `Matrix_Unique_ID` = '211897604' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T11:19:06.007' ,`MLSNumber` = '65298942' ,`ListAgentFullName` = 'Morgan Evans' ,`ListOfficeName` = 'RE/MAX Lake Livingston' ,`SellingAgentFullName` = 'Morgan Evans' ,`SellingOfficeName` = 'RE/MAX Lake Livingston' ,`Latitude` = '30.721402' ,`Longitude` = '-95.105205' ,`PhotoCount` = '11' ,`PostalCode` = '77351' ,`RoomCount` = '2' ,`ListPrice` = '89000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Water Ridge' ,`StreetNumber` = '187' ,`StreetSuffix` = 'Drive' ,`City` = 'Livingston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '896' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t miss this cozy 2Bed/1Bath/1Car Garage located in the desirable Crescent Shores subdivision in Livingston. Amenities include a gate controlled park with boat launch, fishing pier, and picnic tables making it a breeze to enjoy life at the lake. Property is being sold as is.' ,`Acres` = '0.1538' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CRESCENT SHORES BLK 4 LOT 1' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '6698' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '80' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Crescent Shores' ,`TaxAmount` = '1765' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Public Sewer,Septic Tank' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216181' WHERE `Matrix_Unique_ID` = '211931409' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T11:06:22.113' ,`MLSNumber` = '67586178' ,`ListAgentFullName` = 'Nazario Trujillo' ,`ListOfficeName` = 'SIS Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.973399' ,`Longitude` = '-95.644824' ,`PhotoCount` = '49' ,`PostalCode` = '77429' ,`RoomCount` = '6' ,`ListPrice` = '849900.00' ,`Status` = 'Active' ,`StreetName` = 'Huffmeister' ,`StreetNumber` = '14135' ,`StreetSuffix` = 'Road' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '4439' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ANOTHER PRICE DROP!!!! OWNER WANTS IT SOLD!!!!!! Land size is by Owner, Buyer to verify. The building size is larger than what county records show according to the owner. Property can be used as Commercial or Residential or both, live in the house and use the other buildings for your business or to lease it out and get income from them. Currently being used as the headquarters for Restore Your Door Inc. Sparkling pool in the back with green areas to enjoy this summer heat. Seller is willing to look at any reasonable offers.' ,`Acres` = '1.28' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 8E ABST 133 A BODIN' ,`LotDesciption` = 'Other' ,`LotSize` = '55756' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven,Electric Oven,Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'SAMPSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPILLANE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style,Ranch' ,`Subdivision` = 'N/A' ,`TaxAmount` = '8991' ,`TaxRate` = '2.091' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216181' WHERE `Matrix_Unique_ID` = '212017719' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T11:35:09.623' ,`MLSNumber` = '17116126' ,`ListAgentFullName` = 'William Klingberg' ,`ListOfficeName` = 'Aim Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.909574' ,`Longitude` = '-95.599870' ,`PhotoCount` = '23' ,`PostalCode` = '77065' ,`RoomCount` = '5' ,`ListPrice` = '222000.00' ,`Status` = 'Active' ,`StreetName` = 'Dapple' ,`StreetNumber` = '12207' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1381' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 bedroom, 2 bath, 2 garage house with a fenced back yard. The kitchen and dining areas have vinyl plank flooring. The living area has a fireplace and is open to the dining area and kitchen.' ,`Acres` = '0.1377' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 8 STEEPLECHASE SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '610' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'EMMOTT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'CAMPBELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Steeplechase' ,`TaxAmount` = '3850' ,`TaxRate` = '2.541' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216182' WHERE `Matrix_Unique_ID` = '212030213' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T11:52:41.703' ,`MLSNumber` = '33035570' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.152646' ,`Longitude` = '-95.581700' ,`PhotoCount` = '37' ,`PostalCode` = '77354' ,`RoomCount` = '17' ,`ListPrice` = '649871.00' ,`Status` = 'Active' ,`StreetName` = 'Renly Ridge' ,`StreetNumber` = '27045' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3793' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Rowan V, Elevation F) CURRENTLY BEING BUILT. Two story. 5 bedrooms. 4.5 baths. Family room, informal dining room/breakfast area and study. Spacious island kitchen open to family room. Primary suite with large walk-in closet and secondary bedroom on first floor. Three additional bedrooms, spacious game room and media room on second floor. Covered patio and attached 2-car garage. NorthGrove offers easy access to all the conveniences and necessities of modern living with The Woodlands, Tomball, and Conroe all a short distance away. With resort-style amenities, including The Retreat, a 9,400-sq.-ft. clubhouse, Northgrove is the perfect escape from the daily grind. Enjoy a fitness center, pool, children\'s play areas and more. Stop by the Westin Homes model home today to find out more about Northgrove!' ,`Acres` = '0.1932' ,`Area` = '15' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BLOCK 4, LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8416' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1295' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Northgrove' ,`TaxAmount` = '2250' ,`TaxRate` = '3.21' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216182' WHERE `Matrix_Unique_ID` = '212142096' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T12:08:09.923' ,`MLSNumber` = '11962937' ,`ListAgentFullName` = 'David Brown' ,`ListOfficeName` = 'Venture Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.003868' ,`Longitude` = '-95.546053' ,`PhotoCount` = '36' ,`PostalCode` = '77379' ,`RoomCount` = '6' ,`ListPrice` = '342900.00' ,`Status` = 'Active' ,`StreetName` = 'Godstone' ,`StreetNumber` = '9115' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2856' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home, nestled on a quiet a cul de sac was totally renovated in 2022 and is perfect for your family! 2022 Upgrades include: Exterior paint, interior paint, interior vinyl plank floors downstairs and new carpet upstairs, New soft close Shaker style KITCHEN CABINETS with new GRANITE countertops. The home also has all new APPLIANCES. new ENERGY EFFICIENT DOUBLE PANE, TILT TO CLEAN, WINDOWS throughout the home and a NEW HVAC system. The unfinished garage apartment would make a perfect mother in laws home or guest house. The home has a large backyard for the kids to play or to entertain guests. Zoned to popular KLEIN SCHOOLS. Great location close to numerous parks, public library, Vintage Park shopping and restaurants, Hwy 249 and the Grand Parkway.' ,`Acres` = '0.2204' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 28 BLK 5 CHAMPION FOREST SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BRILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'CHAMPION FOREST' ,`TaxAmount` = '6788' ,`TaxRate` = '2.3465' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216182' WHERE `Matrix_Unique_ID` = '212194691' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T12:10:07.670' ,`MLSNumber` = '97639978' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.133995' ,`Longitude` = '-95.317052' ,`PhotoCount` = '6' ,`PostalCode` = '77365' ,`RoomCount` = '8' ,`ListPrice` = '424689.00' ,`Status` = 'Active' ,`StreetName` = 'Cascades Pass' ,`StreetNumber` = '7522' ,`StreetSuffix` = 'Drive' ,`City` = 'Porter' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2032' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful, 1-story Coventry Home has a 3-car garage which is perfect for the newest semi-private golf course community. This home is built with 4 bedrooms, 3 bathrooms, and a mud room. The open concept has an impressive kitchen that overlooks the dining and living area and is equipped with GE stainless-steel appliances, 42-inch grey cabinets, and beautiful granite countertops with designer backsplash. Enjoy the beautiful views from a large back patio and added gas line for outdoor cooking. The primary suite offers additional space with the bow windows and has 2 huge walk-in closets. Rest assured in this Environments for Living Platinum Level energy-efficient home with a 3-year heating and cooling guarantee. This community offers a waterpark, walking trails, workout area, and more. Don\'t miss out on this one!' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 6 Block 4' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1420' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'ROBERT CRIPPEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Highlands' ,`TaxAmount` = '' ,`TaxRate` = '3.38' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216182' WHERE `Matrix_Unique_ID` = '212295900' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T11:26:36.647' ,`MLSNumber` = '71694956' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.679605' ,`Longitude` = '-95.831065' ,`PhotoCount` = '31' ,`PostalCode` = '77406' ,`RoomCount` = '8' ,`ListPrice` = '424631.00' ,`Status` = 'Active' ,`StreetName` = 'Cecilia Star' ,`StreetNumber` = '10422' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1650' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming one-story home boasts everything you have been dreaming of and more. Enter through the lovely 8-foot front door and discover luxurious architectural details throughout. The gourmet kitchen hosts 42-inch cabinetry, granite countertops, stainless steel appliances, and a large island workspace perfect for preparing everyone’s favorite dish. The primary suite features luxurious dual vanity sinks. The covered patio provides the ideal spot for relaxing outside or hosting neighborhood barbeques. This home is certified Environments for Living and offers some of the highest energy features available today. Visit this beautiful home today!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5431' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Single 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` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Candela' ,`TaxAmount` = '' ,`TaxRate` = '3.14' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216183' WHERE `Matrix_Unique_ID` = '212416966' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T12:39:41.837' ,`MLSNumber` = '64395393' ,`ListAgentFullName` = 'Karen Sherrill' ,`ListOfficeName` = 'Simien Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.533426' ,`Longitude` = '-95.219044' ,`PhotoCount` = '28' ,`PostalCode` = '77546' ,`RoomCount` = '6' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Avondale' ,`StreetNumber` = '516' ,`StreetSuffix` = 'Lane' ,`City` = 'Friendswood' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1514' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Do you want a home on a large corner lot? Do you want a home with lots of storage? How about a pool? THIS is the home for you. Tile floors throughout this home make it a maintenance dream - like wet feet coming in from the pool outside. Speaking of outside - French doors lead to covered patio and spacious yard, fire pit area and side gate access is perfect for when you entertain. Oversized bedroom with french doors leading to backyard is another feature you will appreciate. Flexible floor plan has space to dine in kitchen and/or set a table in the oversized den for dining. You\'ll appreciate: recessed lights, updated baths, updated wiring, new electric panel, projection unit, large retractable screen and surround sound (all stay) just in time for the Super Bowl! Home is wired with ethernet if you work from home. Large garage with additional storage. Potential to convert to a 4 bedroom. See attached for updates/upgrades (like PEX!), and schedule a showing!' ,`Acres` = '0.2155' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 20 PERRY & AUSTIN SUR PT OF LOT 3 (3-1) BLK 10 ANNALEA' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9386' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '144' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '20 - Friendswood' ,`SchoolElementary` = 'WESTWOOD ELEMENTARY SCHOOL (FRIENDSWOOD)' ,`SchoolHigh` = 'FRIENDSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'FRIENDSWOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Anna Alea Kingspark/Whitehall' ,`TaxAmount` = '5000' ,`TaxRate` = '2.2832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216183' WHERE `Matrix_Unique_ID` = '212582173' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T11:34:16.007' ,`MLSNumber` = '10353073' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.681932' ,`Longitude` = '-95.832579' ,`PhotoCount` = '33' ,`PostalCode` = '77406' ,`RoomCount` = '9' ,`ListPrice` = '749980.00' ,`Status` = 'Active' ,`StreetName` = 'Dappled Glade' ,`StreetNumber` = '26203' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3688' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Popular and spacious single story home plan offer in Candela, the best location situated close to everything in a quiet country setting! This home has a sizeable kitchen with all the upgrades, volume ceilings throughout much of the main level, and an owner\'s bath suit anyone will envy! Many additions including upgraded flooring, tile, appliances, cabinets, and more.' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'lot 1, block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven,Single 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` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Candela' ,`TaxAmount` = '6500' ,`TaxRate` = '3.14' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216183' WHERE `Matrix_Unique_ID` = '212736122' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T11:18:08.757' ,`MLSNumber` = '53070033' ,`ListAgentFullName` = 'Thor Paulsen' ,`ListOfficeName` = 'D. Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.054565' ,`Longitude` = '-95.395418' ,`PhotoCount` = '17' ,`PostalCode` = '77373' ,`RoomCount` = '3' ,`ListPrice` = '229900.00' ,`Status` = 'Active' ,`StreetName` = 'Arica' ,`StreetNumber` = '2610' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1437' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this Beautiful and Cozy home! Laminate flooring throughout including primary bedroom. ‘His’ and ‘hers’ separate vanity. Granite countertops in kitchen and bathrooms. Bar area that over looks living room, great for entertaining family and friends. Refrigerator included! Tour home today before it’s too late!' ,`Acres` = '0.0878' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 1 TIFFANY MEADOWS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3826' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PEARL M HIRSCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'TWIN CREEKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tiffany Mdws' ,`TaxAmount` = '4603' ,`TaxRate` = '2.8117' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216183' WHERE `Matrix_Unique_ID` = '212792764' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T12:18:06.090' ,`MLSNumber` = '27478399' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'KB Home Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.999680' ,`Longitude` = '-95.501224' ,`PhotoCount` = '7' ,`PostalCode` = '77068' ,`RoomCount` = '12' ,`ListPrice` = '379995.00' ,`Status` = 'Active' ,`StreetName` = 'Cypress Creek' ,`StreetNumber` = '14630' ,`StreetSuffix` = 'Landing' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2646' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction** Find everything you desire in this amazing KB Home in Cypress Creek Landing, which boasts a brick front, tile flooring, extended entry, wrought iron spindles, and an open great room. Impress your guests in the lovely kitchen, equipped with Silestone countertops, stainless steel Energy Star® appliances, and 42-in. cabinets. The spa-like primary suite features extended dual vanities, a 42-in. Kohler Master Windward® tub, and a separate shower. Additional home features include cable pre-wiring, a fully equipped security system, full gutters, and a covered patio. The desirable Cypress Creek Landing community includes a park with a playground and a covered pavilion. Situated near Hwy 249 and I-45, commuters enjoy quick access to Downtown Houston. Zoned to the highly-rated Spring Independent School District.' ,`Acres` = '' ,`Area` = '13' ,`BuilderName` = 'KB Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '1960/Cypress Creek North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 6 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PAT REYNOLDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Creek Landing' ,`TaxAmount` = '' ,`TaxRate` = '2.459' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216183' WHERE `Matrix_Unique_ID` = '212873382' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T12:56:47.633' ,`MLSNumber` = '98344980' ,`ListAgentFullName` = 'John Cacolice' ,`ListOfficeName` = 'The Lakes Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.502251' ,`Longitude` = '-95.433734' ,`PhotoCount` = '28' ,`PostalCode` = '77583' ,`RoomCount` = '9' ,`ListPrice` = '287900.00' ,`Status` = 'Active' ,`StreetName` = 'Lilywood' ,`StreetNumber` = '5605' ,`StreetSuffix` = 'Court' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2354' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Price Reduced! All bedrooms up! Home at the end of a quiet cul de sac. 4 bedrooms & 2 and a half bathrooms! Brand new roof 2022! Remodeled master shower and guest shower. Granite counters. Upgraded electric range/stove. All bedrooms on 2nd floor along with 2 full bathrooms. Downstairs formal dining room currently serving as a home office, family room open to kitchen and breakfast nook large enough to serve as your primary dining area. Water Softener installed. Generous sized patio in a easterly facing backyard. This makes for shaded evenings on the patio sipping lemonade and enjoying the outdoors after a long day of work. All of this in the Lakes of Savannah!' ,`Acres` = '0.1588' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SAVANNAH MEADOWS SEC 3 (A0403-A0562) BLK 2 LOT 9' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6917' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '670' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'SAVANNAH LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'MANVEL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Right Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Savannah Meadows Sec 1-2-3-4-5' ,`TaxAmount` = '8059' ,`TaxRate` = '3.1908' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216184' WHERE `Matrix_Unique_ID` = '212989658' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T11:24:06.313' ,`MLSNumber` = '11447811' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.681556' ,`Longitude` = '-95.831018' ,`PhotoCount` = '34' ,`PostalCode` = '77406' ,`RoomCount` = '10' ,`ListPrice` = '499902.00' ,`Status` = 'Active' ,`StreetName` = 'Herschel Heights' ,`StreetNumber` = '26106' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2301' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'As you enter this beautiful 2-story home, you will be welcomed by a grand entry opening to a study complemented by French doors. The open-concept design offers a large game room overlooking the family room, complete with soaring 2-story ceilings and ideal for entertaining family and friends. The gourmet kitchen is equipped with gleaming granite countertops, stainless steel appliances, and a spacious island. After a long day, retreat to the primary suite featuring a stunning bay window, dual sinks, a separate tub and shower, ceramic tile flooring, and walk-in closets. This gorgeous home is energy efficient and Environments for Living certified. Visit today!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7656' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Single 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` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Candela' ,`TaxAmount` = '' ,`TaxRate` = '3.14' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216184' WHERE `Matrix_Unique_ID` = '213001267' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T11:24:39.167' ,`MLSNumber` = '10320590' ,`ListAgentFullName` = 'Carole Jones' ,`ListOfficeName` = 'Eastex Real Estate Brokerage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.814136' ,`Longitude` = '-94.873303' ,`PhotoCount` = '36' ,`PostalCode` = '77351' ,`RoomCount` = '1' ,`ListPrice` = '220000.00' ,`Status` = 'Active' ,`StreetName` = 'US Highway 59' ,`StreetNumber` = '8851' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '990' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOOKING FOR A PROPERTY THAT PROVIDES A HOME AND CAN ALSO BE USED AS COMMERCIAL? This property offers both by having highway 59 frontage and access from two sides. There is the main 1-bedroom dwelling with very nice finishes that sits at the back of the property. There is also a small cabin/guesthouse that could be converted into some sort of business if desired. Let\'s not forget the outdoor covered entertainment area in addition to an outdoor firepit gathering place. The porches are so inviting that it may be difficult to get much work done. This is a must-see property!' ,`Acres` = '0.64' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Livingston Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 36 B J HARPER SURVEY TRACT 213-1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '27878' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '151 - Leggett' ,`SchoolElementary` = 'LEGGETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LEGGETT HIGH SCHOOL' ,`SchoolMiddle` = 'LEGGETT HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'None' ,`TaxAmount` = '1603' ,`TaxRate` = '1.8753' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216184' WHERE `Matrix_Unique_ID` = '213734909' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T12:27:28.237' ,`MLSNumber` = '14567736' ,`ListAgentFullName` = 'Steven Koleno' ,`ListOfficeName` = 'Beycome Brokerage Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.169205' ,`Longitude` = '-97.001621' ,`PhotoCount` = '17' ,`PostalCode` = '78382' ,`RoomCount` = '4' ,`ListPrice` = '239000.00' ,`Status` = 'Active' ,`StreetName` = 'Club Oak' ,`StreetNumber` = '359' ,`StreetSuffix` = 'Lane' ,`City` = 'Rockport' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '640' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Just bring your boat and your golf cart, cause this house is fully furnished and move in ready with plenty of parking! The small but fully equipped house is brand new, with stainless appliances, full laundry center, separate rec room with 72\" tv, and already income producing on AirBnB! \r\n\r\nThe neighborhood has boat ramps, park, pool, fishing pier and is golf cart friendly.' ,`Acres` = '0.1148' ,`Area` = '85' ,`BuilderName` = 'n/a' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S2684 HOLIDAY BEACH MESQUITE TREE LOT 359' ,`LotDesciption` = 'Other' ,`LotSize` = '5001' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '50' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '310 - Aransas County' ,`SchoolElementary` = 'LIVE OAK 1-3 LEARNING CENTER' ,`SchoolHigh` = 'ROCKPORT-FULTON HIGH SCHOOL' ,`SchoolMiddle` = 'ROCKPORT-FULTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Holiday Beach Mesquite Tree' ,`TaxAmount` = '132' ,`TaxRate` = '1.3696' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216184' WHERE `Matrix_Unique_ID` = '213939968' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T11:37:33.293' ,`MLSNumber` = '46402079' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.209945' ,`Longitude` = '-95.339651' ,`PhotoCount` = '14' ,`PostalCode` = '77302' ,`RoomCount` = '9' ,`ListPrice` = '464895.00' ,`Status` = 'Active' ,`StreetName` = 'Chestnut Cove' ,`StreetNumber` = '17428' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2533' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in the master-planned community of ARTAVIA, this spacious one-story home boasts everything you have been searching for and more. The foyer opens into an open-concept design in the kitchen, family room and dining room, ideal for entertaining family and friends. The chef’s gourmet kitchen is equipped with an oversized island, an abundance of countertop space and built-in stainless-steel appliances. Beautiful wood floors pave your way throughout the living and dining areas and give the home a custom finish look. After a long day, relax in the spacious primary suite complemented by beautiful windows or enjoy the covered patio featuring a backyard large enough for a pool. Complete with a 3-car tandem garage, this home has something for everyone. Don’t miss out on this lovely home, come visit today!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7148' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Artavia' ,`TaxAmount` = '' ,`TaxRate` = '3.198' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216185' WHERE `Matrix_Unique_ID` = '214077826' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T11:53:05.120' ,`MLSNumber` = '24516480' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.152579' ,`Longitude` = '-95.581553' ,`PhotoCount` = '32' ,`PostalCode` = '77354' ,`RoomCount` = '17' ,`ListPrice` = '649586.00' ,`Status` = 'Active' ,`StreetName` = 'Renly Ridge' ,`StreetNumber` = '27049' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Asher V, Elevation A) CURRENTLY BEING BUILT. Two story. 5 bedrooms. 4.5 baths. Elegant double front door entry, Family room, informal dining room and study. Spacious island kitchen open to family room. Primary suite with large double walk-in closets and secondary bedroom on first floor. Three additional bedrooms, spacious game room and media room on second floor. Attached 3-car tandem garage. NorthGrove offers easy access to all the conveniences and necessities of modern living with The Woodlands, Tomball, and Conroe all a short distance away. With resort-style amenities, including The Retreat, a 9,400-sq.-ft. clubhouse, Northgrove is the perfect escape from the daily grind. Enjoy a fitness center, pool, children\'s play areas and more. Stop by the Westin Homes model home today to find out more about Northgrove!' ,`Acres` = '0.1918' ,`Area` = '15' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BLOCK 4, LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8356' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1295' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Northgrove' ,`TaxAmount` = '3000' ,`TaxRate` = '3.21' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216185' WHERE `Matrix_Unique_ID` = '214107809' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T11:11:46.567' ,`MLSNumber` = '12570944' ,`ListAgentFullName` = 'Samantha Lake' ,`ListOfficeName` = 'Greystone Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.738618' ,`Longitude` = '-95.549305' ,`PhotoCount` = '42' ,`PostalCode` = '77042' ,`RoomCount` = '13' ,`ListPrice` = '699000.00' ,`Status` = 'Active' ,`StreetName` = 'Wickersham' ,`StreetNumber` = '10014' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3227' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 10014 Wickersham Ln located in the highly desirable Briargrove Park subdivision. This home has been COMPLETELY renovated to wow all guests! As you enter, you\'ll notice the open concept layout that invites friends and family. The kitchen is a dream with calacatta countertops, custom cabinets, stainless steel appliances, and sleek, dark hardware to tie everything together. A newly added utility room makes doing laundry a breeze, with tons of storage to fold and hang! This home comes with TWO game rooms: one downstairs, separated by gorgeous french doors, with wet bar and large windows to allow a lot of sun light, and one upstairs! You can convert into another bedroom, media room, storage, or game room! New roof, ac, wood floors, fresh paint, new carpet, this home is ready for a new family to enjoy! Don\'t miss out on this opportunity, schedule your showing today!' ,`Acres` = '0.1822' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Briargrove Park/Walnutbend' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 68 BLK 3 BRIARGROVE PARK SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7936' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '685' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WALNUT BEND ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Briargrove Park Sec 01' ,`TaxAmount` = '11601' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1963' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216185' WHERE `Matrix_Unique_ID` = '214143117' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T11:35:41.587' ,`MLSNumber` = '25718896' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.682969' ,`Longitude` = '-95.832639' ,`PhotoCount` = '34' ,`PostalCode` = '77406' ,`RoomCount` = '9' ,`ListPrice` = '774970.00' ,`Status` = 'Active' ,`StreetName` = 'Klaria Cresent' ,`StreetNumber` = '10710' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3585' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A NEW home by Coventry is located in the beautiful master-planned community of Candela! Located only minutes to 99 and Westpark for an easy commute! This home\'s gorgeous curb appeal and modern front elevation are sure to stand out. Entering the home, you will be impressed with the curved staircase and soaring ceilings! This one has it all! Two bedrooms on the first floor, a game room for easy entertaining, and many upgrades. Upstairs, you will find a media room! The rear Texas-sized patio offers plenty of yard space for a pool! This home guarantees heating and cooling usage for three years with our Platinum Level Environments for Living program! You do not want to miss out on this home! Schedule an appointment today!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Coventry' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 14 Block 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '70' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven,Single 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` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Candela' ,`TaxAmount` = '' ,`TaxRate` = '3.14' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216185' WHERE `Matrix_Unique_ID` = '214185301' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T11:32:37.730' ,`MLSNumber` = '80662728' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.681182' ,`Longitude` = '-95.835392' ,`PhotoCount` = '34' ,`PostalCode` = '77406' ,`RoomCount` = '8' ,`ListPrice` = '699978.00' ,`Status` = 'Active' ,`StreetName` = 'Lyra Glen' ,`StreetNumber` = '10415' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3432' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This great floorplan features a main floor media room and formal dining, with a grand foyer featuring circular staircase and volume ceilings throughout much of the main level. Popular modern elevation has great curb appeal, with added interior upgrades to enjoy. Enjoy a cul-de-sac home site in family friendly Candela, with a beautiful community pool and splash pad park, plus access to a full gym exclusively for residents. Do not miss this home, which is one of the last available in the 60\' home section!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Coventry' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 22 Block 2' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '60' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven,Single 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` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Candela' ,`TaxAmount` = '' ,`TaxRate` = '3.14' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216186' WHERE `Matrix_Unique_ID` = '214265384' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T11:31:46.220' ,`MLSNumber` = '2000450' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.681231' ,`Longitude` = '-95.834141' ,`PhotoCount` = '34' ,`PostalCode` = '77406' ,`RoomCount` = '8' ,`ListPrice` = '724988.00' ,`Status` = 'Active' ,`StreetName` = 'Aurora Valley' ,`StreetNumber` = '26314' ,`StreetSuffix` = 'Way' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3416' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful 2-story home with space for everyone! A well-designed floor plan features a media room, a covered patio with volume ceilings and soaring windows, a spacious primary bath, and a prominent owner\'s closet! Nicely appointed with upgrades, including the kitchen stacked cabinets, and it has no rear neighbor! Make an appointment today, and don\'t miss out on this lovely home in Candela! Zoned to top-rated schools and enjoy the wonderful community atmosphere and amenities close to conveniences and Grand Parkway/Highway 59 south!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Coventry' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4 Block 2' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '60' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven,Single 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` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Candela' ,`TaxAmount` = '' ,`TaxRate` = '3.14' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216186' WHERE `Matrix_Unique_ID` = '214265681' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T11:25:42.423' ,`MLSNumber` = '92640172' ,`ListAgentFullName` = 'Thao Phuong Le' ,`ListOfficeName` = 'ABSOLUTE Realty Group Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.681799' ,`Longitude` = '-95.723853' ,`PhotoCount` = '19' ,`PostalCode` = '77407' ,`RoomCount` = '3' ,`ListPrice` = '405000.00' ,`Status` = 'Active' ,`StreetName` = 'Blair Orchard' ,`StreetNumber` = '19607' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2248' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Large, nice 1 story home with front porch and enclosed patio in the backyard. Open kitchen with granite counter top. High celling. Ready to move in.' ,`Acres` = '0.132' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND MISSION ESTATES SEC 20, BLOCK 2, LOT 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Colonial' ,`Subdivision` = 'Grand Mission Estates Sec 20' ,`TaxAmount` = '6179' ,`TaxRate` = '2.3529' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216186' WHERE `Matrix_Unique_ID` = '214319190' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T12:25:07.730' ,`MLSNumber` = '85686194' ,`ListAgentFullName` = 'Greg Person' ,`ListOfficeName` = 'Northwest Showcase Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.909378' ,`Longitude` = '-95.330020' ,`PhotoCount` = '10' ,`PostalCode` = '77039' ,`RoomCount` = '4' ,`ListPrice` = '175000.00' ,`Status` = 'Active' ,`StreetName` = 'Connorvale' ,`StreetNumber` = '4414' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1136' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a 4 Bedroom Home that sits just off the main road to Beltway 8! Location is great! This has a attached one car garage And you can enter through kitchen. When you enter home from front door the den is on the right.\r\nThis house has a newer central air conditioner and hot water heater as well. The seller is selling as is, so no repairs to be given. There is a full bath that sits between hall bedrooms and half bath in master bedroom. \r\nThis home is priced below subdivision prices! Thanks for showing!' ,`Acres` = '0.148' ,`Area` = '34' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 323 BLK 14 HIGH MEADOWS SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6448' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'OLESON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MACARTHUR HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'MEAD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Spanish' ,`Subdivision` = 'High Meadows Sec 06' ,`TaxAmount` = '2525' ,`TaxRate` = '2.1553' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216186' WHERE `Matrix_Unique_ID` = '214329203' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T12:24:38.170' ,`MLSNumber` = '89808516' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.692671' ,`Longitude` = '-95.729501' ,`PhotoCount` = '29' ,`PostalCode` = '77407' ,`RoomCount` = '14' ,`ListPrice` = '829000.00' ,`Status` = 'Active' ,`StreetName` = 'Beecham Lake' ,`StreetNumber` = '7407' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 4500+ square foot, waterfront, 5 bedroom home. Beautiful Lake view from most of open floorplan. Downstairs includes primary bedroom, home office and music/flex room. Upstairs has additional 4 bedrooms, large game room and large covered balcony overlooking lake. This beautiful home is perfect for entertaining inside and out.' ,`Acres` = '0.3348' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND MISSION ESTATES SEC 1, BLOCK 3, LOT 22' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '14583' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '827' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Mission Estates Sec 1' ,`TaxAmount` = '13073' ,`TaxRate` = '2.8397' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216187' WHERE `Matrix_Unique_ID` = '214379639' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T12:37:03.940' ,`MLSNumber` = '29012933' ,`ListAgentFullName` = 'David Atkins' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.812223' ,`Longitude` = '-95.399909' ,`PhotoCount` = '26' ,`PostalCode` = '77008' ,`RoomCount` = '10' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = '28th' ,`StreetNumber` = '220' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1980' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in the Heights, 220 W. 28th Street is a three bedroom home that features an ideal floorplan. Boasting\r\n1,980 square feet, this three-story, freestanding home has high quality features such as Low-E windows,\r\nradiant barrier, hardwood floors and stone counters. The fenced yard provides additional outdoor living\r\nopportunities for you and your four-legged friend. As an end unit, this home is afforded an abundance of\r\nnatural light coming through oversized windows facing east, north and west.' ,`Acres` = '0.0402' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 ENCLAVE AT WEST 28TH STREET' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '1750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HELMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Houston Heights' ,`TaxAmount` = '7721' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216187' WHERE `Matrix_Unique_ID` = '214433233' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T11:24:53.283' ,`MLSNumber` = '98284829' ,`ListAgentFullName` = 'Oscar Torres' ,`ListOfficeName` = 'Torres Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.147330' ,`Longitude` = '-94.642835' ,`PhotoCount` = '21' ,`PostalCode` = '77564' ,`RoomCount` = '4' ,`ListPrice` = '180000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 2430' ,`StreetNumber` = '64' ,`StreetSuffix` = '' ,`City` = 'Hull' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1701' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Talk about Country living!! Come and see this wonderful 4 bedroom 2 Bath Home with recent updated features. Walk in on this luxury vinyl flooring throughout