Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:03:03.010' ,`MLSNumber` = '23659198' ,`ListAgentFullName` = 'Jose Portillo' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.777843' ,`Longitude` = '-95.318389' ,`PhotoCount` = '19' ,`PostalCode` = '77020' ,`RoomCount` = '4' ,`ListPrice` = '279900.00' ,`Status` = 'Active' ,`StreetName` = 'Hershe' ,`StreetNumber` = '5200' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1428' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WOW UPDATED HOUSE!!! UPDATED KITCHEN AND BATHROOMS!!!\r\nThis is a three bedroom two baths house. This home has many updates, kitchen cabinets, granite counter, appliances, lights, spotlights, carpet, vinyl laminate planks, fan, interior/exterior paint, doors, baseboards and many other. UPDATED A/C and HEATING!!!!!!! A GORGEOUS ISLAND HAS BEEN ADDED TO THE KITCHEN!!!!!!!! THIS HOUSE BOASTS A LUXURIOUS LAMINATE VINYL PLANKS.' ,`Acres` = '0.1274' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 10 PINECREST' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5550' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ATHERTON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pinecrest' ,`TaxAmount` = '2338' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1946' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764604' WHERE `Matrix_Unique_ID` = '207585563' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T06:47:54.277' ,`MLSNumber` = '71265316' ,`ListAgentFullName` = 'Rhonda Surovec' ,`ListOfficeName` = 'RE/MAX East' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.329723' ,`Longitude` = '-94.939698' ,`PhotoCount` = '49' ,`PostalCode` = '77563' ,`RoomCount` = '9' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Tarpon' ,`StreetNumber` = '104' ,`StreetSuffix` = 'Street' ,`City` = 'Bayou Vista' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2589' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous waterfront home in Hitchcock! Boasting 4 bedrooms, 3 bathrooms, 2 living areas, and an impressive outdoor space, this Bayou Vista home exudes relaxation vibes. Embark on an aquatic excursion with the on-site boat slip, cast your line from the fishing dock, or experience the excitement of Galveston just a few miles away. After a day spent exploring attractions, fire up the grill for true Texan BBQ or cozy up indoors for family game night!\nLighted photos or virtual enhanced. ' ,`Acres` = '0.1688' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bayou Vista' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 7 PAGE 7 LOT 104 NEW BAYOU VISTA ADDN 2' ,`LotDesciption` = 'Water View' ,`LotSize` = '7354' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HIGHLANDS ELEMENTARY SCHOOL (LA MARQUE)' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Back' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Bayou Vista 2' ,`TaxAmount` = '13091' ,`TaxRate` = '2.635' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764604' WHERE `Matrix_Unique_ID` = '207891058' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:58:48.863' ,`MLSNumber` = '26556166' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.444498' ,`Longitude` = '-95.400583' ,`PhotoCount` = '44' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '709990.00' ,`Status` = 'Active' ,`StreetName` = 'Coronado' ,`StreetNumber` = '4635' ,`StreetSuffix` = 'Court' ,`City` = 'Manvel' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '3520' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 26556166 - Built by Highland Homes - Ready Now! ~ Highland\'s signature soaring ceilings catch your eye as soon as you walk into this home! Off the entry is a spacious study, perfect for working from home. Secondary bedroom with en-suite bath is tucked away downstairs, ideal for a guest suite. You\'ll love to entertain in this kitchen with the huge kitchen island that can accommodate additional seating. Features upgrades galore such as built-in hutch, quartz countertops, marble backsplash, pendant lighting, and more! Gather around the fireplace in the family room, which features eye-catching tile extended to the ceiling. Sliding glass doors lead you to the covered patio where you can enjoy the tranquility of Meridiana. Owners suite is complete with luxurious freestanding tub and large walk-in closet! Host game/movie nights in your own entertainment room upstairs. EXPANDED secondary bedrooms upstairs both have ensuite baths! Make an appointment to tour today!!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MERIDIANA SEC 43 (A0286) (MANVEL) BLK 1 LOT 45' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '0' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '' ,`TaxRate` = '3.63' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665764604' WHERE `Matrix_Unique_ID` = '207983500' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:59:19.703' ,`MLSNumber` = '84394630' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.751295' ,`Longitude` = '-95.883829' ,`PhotoCount` = '50' ,`PostalCode` = '77494' ,`RoomCount` = '8' ,`ListPrice` = '651804.00' ,`Status` = 'Active' ,`StreetName` = 'Sycamore Wood' ,`StreetNumber` = '2818' ,`StreetSuffix` = 'Trace' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3009' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 84394630 - Built by Highland Homes - November completion! ~ Our top selling floorplan on a beautiful cul-de-sac lot!! Fully upgraded with sliding glass doors, upgraded wood floors, quartz countertops everywhere, and gourmet kitchen with glass front upper cabinets and 12-foot island. Enjoy this homes functionality with an oversized master closet attached DIRECTLY to a huge laundry room! We even thought of the little things with under cabinet lighting, gas line on patio, freestanding tub, soft-close cabinet drawers and upgraded lighting in each room. This section is in close proximity to the upcoming grocery store!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '9/2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9338' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jordan Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665764604' WHERE `Matrix_Unique_ID` = '208029609' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:59:42.213' ,`MLSNumber` = '76801188' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.293005' ,`Longitude` = '-95.565056' ,`PhotoCount` = '50' ,`PostalCode` = '77316' ,`RoomCount` = '4' ,`ListPrice` = '493000.00' ,`Status` = 'Active' ,`StreetName` = 'Sky Top' ,`StreetNumber` = '264' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2262' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 76801188 - Built by Highland Homes - December completion! ~ This beautiful floor plan features an enhanced outdoor living area, master separate shower with freestanding tub, pendant lighting over the kitchen island, built in appliances, painted kitchen cabinets, master bay window in primary bedroom, blinds throughout, quartz countertops in kitchen and secondary bathrooms, and vinyl plank flooring' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '2/2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5100' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest 40\' and 50\'' ,`TaxAmount` = '' ,`TaxRate` = '2.83' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665764604' WHERE `Matrix_Unique_ID` = '208208735' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:04:39.450' ,`MLSNumber` = '98121312' ,`ListAgentFullName` = 'Jose Portillo' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.090203' ,`Longitude` = '-95.620700' ,`PhotoCount` = '17' ,`PostalCode` = '77375' ,`RoomCount` = '5' ,`ListPrice` = '314000.00' ,`Status` = 'Active' ,`StreetName` = 'James' ,`StreetNumber` = '731' ,`StreetSuffix` = 'Street' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1649' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WOW UPDATED HOUSE !!! UPDATED KITCHEN AND BATHROOMS !!! A GORGEOUS ISLAND HAS BEEN ADDED TO THE KITCHEN!!!!!!\r\nThis is a three bedroom two baths house. This home has many updates, kitchen cabinets, granite counter, appliances, lights, spotlights, carpet, vinyl laminate planks, interior/exterior paint, baseboards, doors, and many other. THIS HOUSE BOASTS A LUXURIOUS LAMINATE VINYL PLANKS.' ,`Acres` = '0.1842' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 44 PECAN - TOMBALL' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8023' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TOMBALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pecan Tomball' ,`TaxAmount` = '3702' ,`TaxRate` = '2.3717' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764604' WHERE `Matrix_Unique_ID` = '208540079' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:57:54.827' ,`MLSNumber` = '82397962' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.270988' ,`Longitude` = '-95.467087' ,`PhotoCount` = '50' ,`PostalCode` = '77304' ,`RoomCount` = '4' ,`ListPrice` = '484028.00' ,`Status` = 'Active' ,`StreetName` = 'Sendero' ,`StreetNumber` = '831' ,`StreetSuffix` = 'Trail' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2380' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 82397962 - Built by Highland Homes - February completion! ~ A two-story entry and double stacked windows in the living area make the Everleigh inviting and bright from the start. The open concept kitchen and dining areas have a large island, window seat and great cabinet space. Beautiful bay windows in the primary suite provide a seating area. The primary suite and a 2nd bedroom are downstairs. There are 2 bedrooms, a full bath and game room upstairs. Includes a SMART HOME Package, tankless water heater, full sprinkler system and a 2 car garage.' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'L09, B03' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5040' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1072' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Central Park' ,`TaxAmount` = '' ,`TaxRate` = '3.08' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665764605' WHERE `Matrix_Unique_ID` = '208778465' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:58:18.257' ,`MLSNumber` = '87632803' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.292049' ,`Longitude` = '-95.561998' ,`PhotoCount` = '17' ,`PostalCode` = '77316' ,`RoomCount` = '7' ,`ListPrice` = '649645.00' ,`Status` = 'Active' ,`StreetName` = 'Everest' ,`StreetNumber` = '127' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2828' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 87632803 - Built by Highland Homes - February completion! ~ Lovely 1 story home with 3 beds & 2.5 bath. 10\' sliders that open to an extended covered patio. Extended Primary suite with 6\' drop-in rectangular tub & enlarged shower. Classic X Kitchen upgrade with 36 inch apron front sink. Extended brick fireplace & 72 inch Noir ceiling fan. Additional features include study, media room, formal dining area, & 2.5 car garage' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '26-1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1265' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest 55s' ,`TaxAmount` = '' ,`TaxRate` = '2.83' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665764605' WHERE `Matrix_Unique_ID` = '209028630' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:19:39.247' ,`MLSNumber` = '29991283' ,`ListAgentFullName` = 'Saira Alvarez' ,`ListOfficeName` = 'PRG, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.577781' ,`Longitude` = '-95.373687' ,`PhotoCount` = '43' ,`PostalCode` = '77584' ,`RoomCount` = '5' ,`ListPrice` = '299500.00' ,`Status` = 'Active' ,`StreetName` = 'Birchview' ,`StreetNumber` = '802' ,`StreetSuffix` = 'Court' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1618' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This newly renovated home is a 55+ community. No residents under age 18. home is nestled in the desirable Countryplace 55+ active adult Pearland Golf Club community with easy access to shopping, medical center and many other Houston metro areas. 24-7 manned security gate. Home sits on a corner cul-de-sac. Overall amenities include carpet and tile floors, ceiling fans. Kitchen with electric stove, dishwasher and dual stainless sink and breakfast area, utility room in the home. Spacious great room space off the Kitchen for the Dining and Family room. Primary and Full bath includes combined tub / shower. Sit and relax with a morning cup of coffee or evening beverage on the back closed patio. Community amenities pool, tennis and more. Golf course available.' ,`Acres` = '0.182' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Approved Seniors Project,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'COUNTRYPLACE SEC 1 (A0510 F B DRAKE) BLK 6 LOT 16' ,`LotDesciption` = 'Corner,Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '7928' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '180' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'CHALLENGER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GLENDA DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'BERRY MILLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Countryplace Sec 1' ,`TaxAmount` = '4665' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764605' WHERE `Matrix_Unique_ID` = '209377019' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T06:50:11.273' ,`MLSNumber` = '59489354' ,`ListAgentFullName` = 'Sally James' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.002806' ,`Longitude` = '-95.555118' ,`PhotoCount` = '50' ,`PostalCode` = '77379' ,`RoomCount` = '13' ,`ListPrice` = '664000.00' ,`Status` = 'Active' ,`StreetName` = 'Champions Cove' ,`StreetNumber` = '9715' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4874' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stately 5-bedroom executive home with 2 bedrooms, 2.5 bathrooms down sits on a quiet cul-de-sac lot in the highly desirable Estates at Windrush. Soaring 2-story entry leads to large kitchen, open to the family room & features granite counters, double ovens, gas stovetop, built-ins, & views of the backyard/covered patio. Off the family room is a 2nd bedroom/full bathroom, another private entrance to the backyard & a 2nd stairway leading upstairs. Custom features include tons of built in storage with 2 desk areas, large gameroom, media/bonus room. Spacious primary suite with bay windows, ensuite bathroom with builtins. Recent updates: *ROOF REPLACED 8/26/22* interior walls painted, tile/grout/carpet professionally cleaned, AC unit serviced, all toilets replaced, new smoke detectors installed, stucco recently painted. The theme of this stately home is plenty of space/storage, including the 4 car tandem garage within close proximity to Hwy 249 & Vintage shopping center.' ,`Acres` = '0.2007' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 1 ESTATES AT WINDRUSH SEC 4 AMD' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8742' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`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` = 'Traditional' ,`Subdivision` = 'Estates At Windrush Sec 04 Amd' ,`TaxAmount` = '11455' ,`TaxRate` = '2.3266' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665764605' WHERE `Matrix_Unique_ID` = '209527660' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:46:10.697' ,`MLSNumber` = '69185561' ,`ListAgentFullName` = 'Nancy Tullis' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.105349' ,`Longitude` = '-95.534389' ,`PhotoCount` = '49' ,`PostalCode` = '77389' ,`RoomCount` = '11' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Leblanc Landing' ,`StreetNumber` = '23838' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3310' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Motivated seller, below appraisal price!!! Beautiful home with stone accents in private GATED neighborhood, close to 99 and 45! Enter the home with an impressive high ceiling entry, home office to the right with french doors. Dining room to the left. Large Family/Kitchen area with eat at bar. Side by side refrigerator stays. Washer/Dryer included. Family room is centered around a gas log fireplace, and has surround sound already installed. 10 foot ceilings! Large Primary bedroom downstairs has separate shower, soaking tub large closet. Upstairs is a large Game Room and separate MEDIA room to watch your favorite movies! All equipment in media room and chairs will stay! Guest suite with ensuite bath and walk in closet on second floor. All bedrooms are large with lots of storage. Back yard is completely fenced, private and ready for your next barbeque! This is the home you have been waiting for!' ,`Acres` = '0.168' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 1 PRESERVE AT NORTHAMPTON SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7320' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'NORTHAMPTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HILDEBRANDT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Preserve/Northampton Sec 1' ,`TaxAmount` = '8427' ,`TaxRate` = '2.834' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1665764605' WHERE `Matrix_Unique_ID` = '209780794' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:06:19.367' ,`MLSNumber` = '90361947' ,`ListAgentFullName` = 'Jose Portillo' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.669025' ,`Longitude` = '-95.339334' ,`PhotoCount` = '14' ,`PostalCode` = '77033' ,`RoomCount` = '4' ,`ListPrice` = '204000.00' ,`Status` = 'Active' ,`StreetName` = 'Northridge' ,`StreetNumber` = '5607' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1334' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UPdated house!! Updated kitchen!! Updated bathrooms!!!\r\nUpdates include kitchen cabinets, granite counter, laminate vinyl planks, carpet, interior and exterior paint, lights, spotlights, baseboards, doors, and many more. AC AND HEATING WAS UPDATED!!!!!!!!\r\nSeller shall install oven and dishwasher.' ,`Acres` = '0.1515' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 20 BLK 6 EDGEWOOD SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ALCOTT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Edgewood' ,`TaxAmount` = '1240' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1948' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764605' WHERE `Matrix_Unique_ID` = '210209237' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:21:49.007' ,`MLSNumber` = '91399546' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.518742' ,`Longitude` = '-95.437334' ,`PhotoCount` = '16' ,`PostalCode` = '77583' ,`RoomCount` = '8' ,`ListPrice` = '310000.00' ,`Status` = 'Active' ,`StreetName` = 'Walworth Creek' ,`StreetNumber` = '14219' ,`StreetSuffix` = 'Court' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1857' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Brookstone Collection \"Onyx II\" Plan with Elevation \"B\" in Lakes of Savannah! The beautiful single story Onyx II floor plan by Lennar features a lovely entrance foyer, a dining room, kitchen with breakfast area, a generous family room with access to a relaxing covered rear patio and a walk-in utility room. The master bedroom features an en suite bathroom with dual sinks, separate tub and shower, private toilet enclosure and a large walk-in master closet. *HOME ESTIMATED TO BE COMPLETE, DECEMBER, 2022*' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0019 BLK 002 LOT 014' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'SAVANNAH LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes of Savannah Brookstone' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665764606' WHERE `Matrix_Unique_ID` = '210241362' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T06:59:47.047' ,`MLSNumber` = '66017865' ,`ListAgentFullName` = 'Juan Carlos Say' ,`ListOfficeName` = 'Security American Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.618128' ,`Longitude` = '-95.475967' ,`PhotoCount` = '28' ,`PostalCode` = '77085' ,`RoomCount` = '5' ,`ListPrice` = '246900.00' ,`Status` = 'Active' ,`StreetName` = 'Newquay' ,`StreetNumber` = '6122' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1502' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely one story house nestled in the stablished Windsor Village community. This house is well maintained and offers the comfort of 3 spacious bedrooms, living area and large backyard. House has been updated in the past few years and well maintained by owners. Conveniently located minutes from Sam Houston Parkway & 610.' ,`Acres` = '0.1942' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 23 WINDSOR VILLAGE SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8460' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '40' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WINDSOR VILLAGE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Windsor Village' ,`TaxAmount` = '3822' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764606' WHERE `Matrix_Unique_ID` = '210654419' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T06:03:33.777' ,`MLSNumber` = '82375753' ,`ListAgentFullName` = 'Stephen Metarelis' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.601130' ,`Longitude` = '-95.138307' ,`PhotoCount` = '15' ,`PostalCode` = '77059' ,`RoomCount` = '9' ,`ListPrice` = '369900.00' ,`Status` = 'Active' ,`StreetName` = 'Prairie Hill' ,`StreetNumber` = '2903' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2725' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Traditional 2-story brick home on cul-de-sac in the Northfolk community in the Clear Lake area. Open floor plan features both formals flanking a dramatic 2-story foyer. Beyond is a spacious family room with gas fireplace which opens to the large kitchen with adjoining breakfast room. Kitchen features beautiful stained cabinetry with granite counters and stainless steel appliances with a new microwave. Upstairs, 3 secondary bedrooms, a full bath and the laundry room share the 2nd floor with a luxurious primary suite. En-suite primary bath features dual vanities, large jetted tub and separate shower plus two large closets. Home has been updated with fresh interior paint and new carpet upstairs. Great shaded lot with a number of mature tress. Located within walking distance to the community pool, park/playground and tennis courts. Easy access to I-10 and Beltway 8 with only 30 mins to Downtown Houston and 40 mins to Galveston Island. Zoned to exemplary Clear Creek ISD.' ,`Acres` = '0.1994' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 6 NORTHFORK SEC 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8688' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '535' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'NORTH POINTE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'CLEARLAKE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Northfork' ,`TaxAmount` = '7858' ,`TaxRate` = '2.5769' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764606' WHERE `Matrix_Unique_ID` = '210723576' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:16:04.610' ,`MLSNumber` = '90430388' ,`ListAgentFullName` = 'Lisa Clary' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.773000' ,`Longitude` = '-94.682696' ,`PhotoCount` = '14' ,`PostalCode` = '77514' ,`RoomCount` = '10' ,`ListPrice` = '299990.00' ,`Status` = 'Active' ,`StreetName` = 'Big Spring' ,`StreetNumber` = '109' ,`StreetSuffix` = 'Drive' ,`City` = 'Anahuac' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1796' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand New Express Home by D.R. Horton - Cali Plan. Single story home with 4 bedrooms, 2 baths, and 2 car attached garage. Gourmet kitchen that is sure to impress! Kitchen includes granite counter tops, stainless steel appliances and breakfast bar that is all open to the living area. Built with smart home features including Honeywell bluetooth thermostat. Split floor plan. Primary suite has dual sinks, large closet, and walk in shower. Come see us today!' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'D.R. Horton Express' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Chambers County East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'N/A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '4 - Anahuac' ,`SchoolElementary` = 'ANAHUAC ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANAHUAC HIGH SCHOOL' ,`SchoolMiddle` = 'ANAHUAC MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Point' ,`TaxAmount` = '' ,`TaxRate` = '2.6' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665764606' WHERE `Matrix_Unique_ID` = '210762161' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:17:18.660' ,`MLSNumber` = '25835950' ,`ListAgentFullName` = 'Lisa Clary' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.773000' ,`Longitude` = '-94.682696' ,`PhotoCount` = '18' ,`PostalCode` = '77514' ,`RoomCount` = '9' ,`ListPrice` = '284990.00' ,`Status` = 'Active' ,`StreetName` = 'Big Spring' ,`StreetNumber` = '113' ,`StreetSuffix` = 'Drive' ,`City` = 'Anahuac' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1574' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Denton plan is a one-story home featuring 3 bedrooms, 2 baths, and 2 car garage. The foyer, with an entry coat closet, opens to the guest bedrooms and guest bath. Center kitchen includes large island with sink, beautiful grey Granite counter tops, stainless steel appliances and corner pantry and opens to family room. The owner\'s suite features a sloped ceiling and attractive master bath with dual vanities, water closet and spacious walk-in closet. Homes has a split floor plan. The standard rear covered patio is located off the dining area.' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'D.R. Horton Express' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Chambers County East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'N/A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '4 - Anahuac' ,`SchoolElementary` = 'ANAHUAC ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANAHUAC HIGH SCHOOL' ,`SchoolMiddle` = 'ANAHUAC MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Point' ,`TaxAmount` = '' ,`TaxRate` = '2.6' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665764606' WHERE `Matrix_Unique_ID` = '210764196' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:15:35.220' ,`MLSNumber` = '24733510' ,`ListAgentFullName` = 'John Branch' ,`ListOfficeName` = 'Cynthia Tibbs Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.858869' ,`Longitude` = '-95.223038' ,`PhotoCount` = '8' ,`PostalCode` = '77044' ,`RoomCount` = '3' ,`ListPrice` = '55000.00' ,`Status` = 'Active' ,`StreetName` = 'Grand Isle' ,`StreetNumber` = '9426' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1280' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOT IS NOT FOR SALE! Mobile home is in good shape, looking for savvy investors or buyers who want a place to call their home.' ,`Acres` = '0' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '1998 T0WN & COUNTRY 16X76 WHT/GRN HUD#NTA0825421 SER#TXCTCMW' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'GARRETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'MICHAEL R. NULL MIDDLE SCHOOL' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'N/A' ,`TaxAmount` = '439' ,`TaxRate` = '3.0293' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1665764607' WHERE `Matrix_Unique_ID` = '210882300' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:36:58.057' ,`MLSNumber` = '6339243' ,`ListAgentFullName` = 'Avelina Graham' ,`ListOfficeName` = 'Flyhomes Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.511060' ,`Longitude` = '-95.216767' ,`PhotoCount` = '50' ,`PostalCode` = '77546' ,`RoomCount` = '9' ,`ListPrice` = '1117000.00' ,`Status` = 'Active' ,`StreetName` = 'Falling Leaf' ,`StreetNumber` = '1304' ,`StreetSuffix` = 'Drive' ,`City` = 'Friendswood' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3855' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A tranquil paradise tucked away on approximately 2.29 acres in the horse-friendly neighborhood of Mustang Meadow. NO HOA! Estate includes main house, guest house, pool with cool decking, and barn. Main house features quartzite kitchen counters, stone accented fireplace, 4 bedrooms, and sun room. Guest house has full kitchen, living room, bathroom & 2 bedrooms (or 1 bd/1 flex). Lovely 2 story barn w/commercial kitchen fitting, office with window A/C, half bath, gas, 220V, on demand water heater, tool bench, RV hook up and RV dump station. temporary wall in barn held up with deck screws and can be easily torn down. Includes refrigerators in main house & guest house, washer/dryer, stand alone freezer, trash compactor, automatic pool cleaner, zero turn mower & 1 sit on top ocean kayak. This gem offers a rare degree of opulence w/flexible accommodations & resort-style amenities. Perfectly suited for multi-generational living & grand-scale entertaining! Your serenity awaits!' ,`Acres` = '2.296' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 83 PAGE 2 LOT 6 BLK 1 MUSTANG MEADOWS' ,`LotDesciption` = 'Cleared,Corner,Greenbelt,Wooded' ,`LotSize` = '100014' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '20 - Friendswood' ,`SchoolElementary` = 'WESTWOOD ELEMENTARY SCHOOL (FRIENDSWOOD)' ,`SchoolHigh` = 'FRIENDSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'FRIENDSWOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Mustang Meadow' ,`TaxAmount` = '17705' ,`TaxRate` = '2.2832' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764607' WHERE `Matrix_Unique_ID` = '210929994' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:37:58.320' ,`MLSNumber` = '49032437' ,`ListAgentFullName` = 'Kelly Kelley' ,`ListOfficeName` = 'RE/MAX Leading Edge' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.110685' ,`Longitude` = '-95.086826' ,`PhotoCount` = '47' ,`PostalCode` = '77554' ,`RoomCount` = '7' ,`ListPrice` = '889900.00' ,`Status` = 'Active' ,`StreetName` = 'Defender' ,`StreetNumber` = '4138' ,`StreetSuffix` = 'Lane' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '1795' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A beachside home with beachfront views in Playa San Luis with a 1.5 mile long non-driving beach that is maintained by the HOA! When you walk up to the covered deck you will be captivated by the views & enjoy the southerly breezes. The deck is your front-row seat to the gorgeous Galveston sunrises. Inside the home, the open floorplan greets you with the living room on the right, and kitchen & dining on the left. 2 bedrooms down and 3 bedrooms up including a large utility room and loft style office. The details of the home are complete with custom woodwork, recessed LED lighting, window treatments, stainless appliances, & 2 newer condensers (July 2022). New tile flooring installed 10/17/22. If you have not been to Playa San Luis, you are missing out! The subdivision has a tunnel that allows you to access the bayside pool, it has some of the largest beaches on the west end, & it is close to HWY 288 so you don\'t have to drive I45. The home conveys fully furnished!' ,`Acres` = '0.145' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 PAGE 6 LOT 47 BLK 1 PLAYA SAN LUIS SUB' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '6316' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Playa San Luis' ,`TaxAmount` = '9369' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764607' WHERE `Matrix_Unique_ID` = '211203268' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:07:37.740' ,`MLSNumber` = '10492804' ,`ListAgentFullName` = 'Jose Portillo' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.857302' ,`Longitude` = '-95.130129' ,`PhotoCount` = '18' ,`PostalCode` = '77049' ,`RoomCount` = '6' ,`ListPrice` = '192000.00' ,`Status` = 'Active' ,`StreetName` = 'Blairwood' ,`StreetNumber` = '17223' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1270' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Updated House!!! Updated kitchen!!!! Updated bathrooms!!! This is a three bedroom two bathrooms house. Updates include kitchen cabinets, granite counter, appliances, interior and exterior paint, lights, spotlights, fans, LUXURIOUS WATERPROOF VINYL LAMINATE PLANKS!!!!! and many more.' ,`Acres` = '0.1363' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 71 BLK 4 SHELDON WOODS SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5936' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'SHELDON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'MICHAEL R. NULL MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sheldon Woods' ,`TaxAmount` = '2868' ,`TaxRate` = '3.7643' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764607' WHERE `Matrix_Unique_ID` = '211212634' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:26:59.070' ,`MLSNumber` = '83202995' ,`ListAgentFullName` = 'Angela Ritchey' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.664039' ,`Longitude` = '-95.462327' ,`PhotoCount` = '50' ,`PostalCode` = '77035' ,`RoomCount` = '11' ,`ListPrice` = '850000.00' ,`Status` = 'Active' ,`StreetName` = 'Willowisp' ,`StreetNumber` = '10809' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4916' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Art of Symmetry, this Tuscan inspired home poses a sense of harmony and balance. A soothing view from the front door entrance through the rotunda to the rear one-half acre plaza. Downstairs north and south suites each have a comfortable bedroom, spacious sitting room, full bath, and private patio. Equal space under one roof offers multigenerational living. Plenty of windows array natural light throughout the versatile spaces from the downstairs family room to the upstairs breakfast-keeping room, to the meditation room. Contemporary kitchen showcases an island with seating, abundant counter space, stainless-steel appliances, and walk-in pantry. Extensive primary bedroom retreat wraps around the living room. The backyard oasis gives many options for a pool and entertaining. More amenities with three-level elevator shaft, laundry on first level and primary closet, two double-sided driveways and 4-car garage. Convenient to I-610, minutes from the Texas Medical Center and The Galleria.' ,`Acres` = '0.5018' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Willow Meadows Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 122 BLK 7 WILLOW BEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '21858' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '125' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'RED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Lockbox Right Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean,Other Style' ,`Subdivision` = 'Willow Bend Sec 01' ,`TaxAmount` = '18576' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764607' WHERE `Matrix_Unique_ID` = '211309862' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:45:13.350' ,`MLSNumber` = '55759476' ,`ListAgentFullName` = 'Evan Howell' ,`ListOfficeName` = 'Evan S. Howell, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.098740' ,`Longitude` = '-95.429640' ,`PhotoCount` = '35' ,`PostalCode` = '77373' ,`RoomCount` = '9' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Kobi Park' ,`StreetNumber` = '23227' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2653' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NICE 2 STORY CLOSE TO EXXON MOBIL CORP CAMPUS AND WALKING DISTANCE TO NORTHGATE ELEMENTARY.MASTER DOWN, LARGE BATH DOUBLE SINKS, SEP SHOWER AND JETTED TUB. AMAZING CLOSETS AND STORAGE. OPEN FLOOR PLAN. ENERGY STAR HOME. LOCATED ON CUL DE SAC STREET. TENNIS COURTS, PLAYGROUND AND SUBDIVISION POOL. WASHER/DRYER AND RANGE INCLUDED. NOTE HOME IS NOT FURNISHED PICTURES ARE FOR DEMONSTRATION PURPOSES ONLY.' ,`Acres` = '' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 1 VILLAGE NORTHGATE CROSSING 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7088' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '625' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'NORTHGATE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'SPRINGWOODS VILLAGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'VILLAGES OF NORTHGATE CROSS' ,`TaxAmount` = '5398' ,`TaxRate` = '3.6538' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764608' WHERE `Matrix_Unique_ID` = '211356962' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:28:29.330' ,`MLSNumber` = '88359774' ,`ListAgentFullName` = 'Amber Stevenson Burris' ,`ListOfficeName` = 'RE/MAX American Dream' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.381808' ,`Longitude` = '-95.135874' ,`PhotoCount` = '26' ,`PostalCode` = '77517' ,`RoomCount` = '11' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Ike Frank' ,`StreetNumber` = '4641' ,`StreetSuffix` = 'Road' ,`City` = 'Santa Fe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2268' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifull home on 2.92 acers. The Home has a split floor plain. The amazing Kitchen with granite counter tops is located on the second floor with the living room, Two bedrooms and a full bathroom. The first floor has so much to offer converted garage that can be used for a man cave, craft room and has the washer and dryer hook ups. Two bedrooms are on the first floor, one bedroom has a sitting room attached to it with a full bathroom. All floors have new vinyl. With so many upgrades. The property is fully fenced and ready for all your get togethers. Don\'t miss out on this amazing home!' ,`Acres` = '2.928' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 612 I & G N RR SUR SEC 18 PT OF LOTS A & B (1-2) BLK 78' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '127544' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'ROY J. WOLLAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Angell-Runge Add' ,`TaxAmount` = '5273' ,`TaxRate` = '2.0881' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764608' WHERE `Matrix_Unique_ID` = '211422195' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T06:48:32.807' ,`MLSNumber` = '81479197' ,`ListAgentFullName` = 'Marie Davis' ,`ListOfficeName` = 'Century 21 Realty Partners' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.131714' ,`Longitude` = '-95.522752' ,`PhotoCount` = '50' ,`PostalCode` = '77389' ,`RoomCount` = '9' ,`ListPrice` = '642700.00' ,`Status` = 'Active' ,`StreetName` = 'Carrick Bend' ,`StreetNumber` = '25211' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4111' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you love to entertain, this home is for you! This fantastic open floorplan is filled with natural light for a space that\'s easy to host in and you will love to show off! Gather with family in the impressive two-story family room that overlooks the kitchen. This kitchen is perfect for hosting guests with dual ovens, a huge granite island, under cabinet lighting, and more! A flex space tucked away off the breakfast nook offers so many possibilities...a study, hobby room, play area, and more! Relax and unwind in the luxurious primary suite with a spacious sitting area, spa-like bath, and walk-in closet. Upstairs, the kids will have their own space to play in the oversized game room with a homework desk and French Doors that close for sound control. Check out this amazing backyard! The extended patio offers loads of room for outdoor entertaining with grassy space left where the kids and pets can play. Sprinkler system. Close to Auburn Lakes Rec Center w a pool, splash-zone, and park!' ,`Acres` = '0.2646' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 1 AUBURN LAKES RETREAT SEC 1' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '11524' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '680' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'FRENCH ELEMENTARY SCHOOL (KLEIN)' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HOFIUS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Auburn Lakes Retreat Sec 1' ,`TaxAmount` = '13431' ,`TaxRate` = '2.914' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764608' WHERE `Matrix_Unique_ID` = '211430841' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:29:29.140' ,`MLSNumber` = '3657765' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.518503' ,`Longitude` = '-95.784257' ,`PhotoCount` = '6' ,`PostalCode` = '77471' ,`RoomCount` = '8' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Richglen' ,`StreetNumber` = '3628' ,`StreetSuffix` = 'Court' ,`City` = 'Rosenberg' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2731' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Fairway Collection \"Melrose\" Plan with Elevation \"E\" in Sendero! This new single-story home delivers modern comfort with a low-maintenance design. Down the foyer is a quiet study well-suited as an office, followed by a spacious open layout situated among the kitchen, dining room and family room. Direct access to the covered patio allows seamless for indoor-outdoor living. In a private corner is the owner’s suite with an adjoining bathroom and oversized walk-in closet, while at the front are three secondary bedrooms. A two-car garage completes the home. *HOME ESTIMATED TO BE COMPLETE, JANUARY, 2022*' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0005 BLK 001 LOT 002' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '756' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MEYER ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sendero' ,`TaxAmount` = '' ,`TaxRate` = '3.09' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665764608' WHERE `Matrix_Unique_ID` = '211510557' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T06:44:32.633' ,`MLSNumber` = '19306736' ,`ListAgentFullName` = 'Asha Charles' ,`ListOfficeName` = 'Blue Diamond Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.024222' ,`Longitude` = '-95.536243' ,`PhotoCount` = '50' ,`PostalCode` = '77379' ,`RoomCount` = '9' ,`ListPrice` = '544000.00' ,`Status` = 'Active' ,`StreetName` = 'Borough' ,`StreetNumber` = '17438' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4118' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful, spacious 5 Bedroom/3.5 Bath, is located in the quiet subdivision of Memorial Northwest. There are two staircases in the home which gives easy access to any area. The master bedroom is located on the main floor and has a beautiful view of the private pool in the backyard. The office is very spacious and perfect for someone working from home. The backyard has a private swimming pool and spa and is ideal for relaxing after a long day\'s work. The game room has a Pool/Tennis table that is great for entertaining guests. There is an additional play room on the second floor which can be potentially a nursery or 6th bedroom. Four bedrooms are located on the second floor and each room is connected with a Jack and Jill bathroom.' ,`Acres` = '0.1857' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 LESS SW 6 FT BLK 1 MEMORIAL NORTHWEST SEC 25' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8087' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '696' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Enclosed' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'THEISS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'DOERRE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Northwest' ,`TaxAmount` = '9620' ,`TaxRate` = '2.5085' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764608' WHERE `Matrix_Unique_ID` = '211593284' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T06:59:19.950' ,`MLSNumber` = '39149972' ,`ListAgentFullName` = 'Andrea Keiller' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = 'Ishme Allah' ,`SellingOfficeName` = 'Village Property Advisors' ,`Latitude` = '30.166685' ,`Longitude` = '-95.628003' ,`PhotoCount` = '50' ,`PostalCode` = '77354' ,`RoomCount` = '16' ,`ListPrice` = '1450000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Riata' ,`StreetNumber` = '23' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '7706' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in the desirable gated neighborhood of the Ranches of Pinehurst this outstanding home offers privacy, enormous entertaining space with convenient access to The Woodlands. Dramatic entry with sweeping iron staircase, wall of windows overlooking the fabulous backyard, both formals with wood flooring, huge master retreat with sitting room, exercise room & fireplace, powder with travertine sink, study with extensive built-ins and shelving, gourmet kitchen with butlers pantry, wine fridge, two warming drawers, double oven, vegetable sink, compactor, 6 ring gas range & large breakfast bar. Upstairs an incredible game room, outside patio with spiral iron staircase to below, extra room with full bar, fridge and media room with 110\" TV screen. 3 large secondary bedrooms with walk in closets. Tropical backyard with summer kitchen, fridge, 3 burners, griddle, grill & pool bath with shower. Sparkling pool with water features. 4 car garage with epoxy coating. The perfect entertaining home!' ,`Acres` = '5' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'A0205 FOSTER JOHN, TRACT 1E-3, ACRES 5.000' ,`LotDesciption` = 'Wooded' ,`LotSize` = '217800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '804' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`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,Controlled Access,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ranches of Pinehurst' ,`TaxAmount` = '22324' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764608' WHERE `Matrix_Unique_ID` = '211601648' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:34:11.810' ,`MLSNumber` = '4250156' ,`ListAgentFullName` = 'Robert (Bob) Murdock' ,`ListOfficeName` = 'Bernstein Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.037250' ,`Longitude` = '-95.640804' ,`PhotoCount` = '39' ,`PostalCode` = '77429' ,`RoomCount` = '12' ,`ListPrice` = '435000.00' ,`Status` = 'Active' ,`StreetName` = 'Hayden Pond' ,`StreetNumber` = '18506' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2139' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic home in the Enclave at Hayden Lakes. Prior model home features wonderful designer touches & seller upgrades of freestanding gas range, vent hood & farm sink. Open kitchen/dining/living area for a fabulous entertainment area. AND A HEATED SALT WATER POOL & SPA! Large back yard backs to neighborhood green belt that is heavily wooded for additional privacy. Seller has stained the fencing to further enhance the outdoor space. Covered patio & house orientation provides afternoon shade for enjoyment of pool. Views of the neighborhood lake from the front of the home. First floor has lovely wood look tile. No carpet on the first floor at all. Family room & primary bedroom look out on the heated pool & spa. Built in speakers in living, study & game room with individual volume controls. Island kitchen with beautiful granite + under counter lighting. WiFi controlled thermostat. Primary bedroom in on the first floor. Spacious primary bath with tub & separate shower.' ,`Acres` = '0.1624' ,`Area` = '35' ,`BuilderName` = 'Beazer' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 39 BLK 1 HAYDEN LAKES SEC 11' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '7072' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '935' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'WILDWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Hayden Lakes' ,`TaxAmount` = '5788' ,`TaxRate` = '2.0872' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764609' WHERE `Matrix_Unique_ID` = '211602629' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:35:33.177' ,`MLSNumber` = '96594147' ,`ListAgentFullName` = 'Crystal Gallegos' ,`ListOfficeName` = 'Scarlet Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.936639' ,`Longitude` = '-95.228916' ,`PhotoCount` = '24' ,`PostalCode` = '77396' ,`RoomCount` = '7' ,`ListPrice` = '259900.00' ,`Status` = 'Active' ,`StreetName` = 'Harbor Canyon' ,`StreetNumber` = '10534' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1560' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Open House this Saturday 10/15, from 2:00pm-4-00pm** Beautiful, well maintained, one story home in a great location! New carpet, freshly painted and a new garage door installed. Great layout with high ceilings, open concept with split bedrooms, and two living room spaces. Home is move in ready!' ,`Acres` = '0.1102' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Humble Area East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 46 BLK 4 SUNSET RIDGE WEST SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4801' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'AUTUMN CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunset Rdg West Sec 03' ,`TaxAmount` = '5152' ,`TaxRate` = '3.0673' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764609' WHERE `Matrix_Unique_ID` = '211673244' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:39:36.380' ,`MLSNumber` = '48833252' ,`ListAgentFullName` = 'Aaron Jistel' ,`ListOfficeName` = 'Listing Spark' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.044203' ,`Longitude` = '-95.248631' ,`PhotoCount` = '28' ,`PostalCode` = '77339' ,`RoomCount` = '8' ,`ListPrice` = '333999.00' ,`Status` = 'Active' ,`StreetName` = 'Laurel Springs' ,`StreetNumber` = '1906' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2110' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 4 Bed 2 bath home on corner lot Never Flooded, Not in a flood zone. 2110 sq ft. Large backyard can fit a full fledged pool. Matured trees gives a forest like feel. Completely remodeled in 2019 with engineered wood, shaker style cabinets, Standing Master shower, Open concept kitchen SS appliance package, Neutral Paints, Recessed lighting, Engineered Wood all through house.' ,`Acres` = '0.4408' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 46 FOREST COVE COUNTRY CLUB ESTATES SEC 4' ,`LotDesciption` = 'Corner' ,`LotSize` = '19200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '170' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'FOSTER ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Estates Sec 04' ,`TaxAmount` = '6605' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764609' WHERE `Matrix_Unique_ID` = '211686791' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T06:24:22.023' ,`MLSNumber` = '95619901' ,`ListAgentFullName` = 'Yvonne Cazares' ,`ListOfficeName` = 'The Monarch Team, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.421780' ,`Longitude` = '-95.260075' ,`PhotoCount` = '29' ,`PostalCode` = '77511' ,`RoomCount` = '6' ,`ListPrice` = '155000.00' ,`Status` = 'Active' ,`StreetName` = 'Blum' ,`StreetNumber` = '1602' ,`StreetSuffix` = 'Street' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2214' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 1604 West Blum St. Looking for a home to make it your own? Look no further. Customize to your liking and make it YOUR Home!! \r\nLarge 1-Story Home with 2 Carport and 2 Car Garage. Covered porch off the Kitchen, , covered patio in the back yard, fenced and lots of potential!!\r\nRoom sizes and school information should be verified by buyer and buyer\'s agent.' ,`Acres` = '0.287' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'EASTON (ALVIN) BLK 40 LOT 11-12' ,`LotDesciption` = 'Corner' ,`LotSize` = '12502' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MELBA PASSMORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRVIEW JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Easton Alvin' ,`TaxAmount` = '4935' ,`TaxRate` = '2.8854' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1948' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764609' WHERE `Matrix_Unique_ID` = '211699309' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:26:57.773' ,`MLSNumber` = '23813352' ,`ListAgentFullName` = 'Lindsey Smithson' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.294260' ,`Longitude` = '-95.412915' ,`PhotoCount` = '33' ,`PostalCode` = '77301' ,`RoomCount` = '11' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Tulip Poplar' ,`StreetNumber` = '2907' ,`StreetSuffix` = 'Trail' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2743' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! Come take a look at the beautiful two-story home that is less than two years old. Featuring FOUR good sized bedrooms, TWO large living spaces(one up and one down), an OFFICE, and THREE full bathrooms(plus a half)! Upon entry, you will find the private office just to the left. If you keep going, the dining room connects into the gorgeous kitchen. It is open to the living area which boasts a gaslog fireplace, vaulted ceilings and several windows keeping the home light and bright. Also downstairs is the primary bedroom. This great sized room has an ensuite with a large standup shower, double sinks, and a walk-in closet. Upstairs, the game room is located at the top of the stairs. In addition, you will find two bedrooms that share a Jack and Jill bathroom and another bedroom and full bathroom! The utility room is conveniently located upstairs. Outside, relax under the covered back patio and enjoy the large corner lot! You are just minutes from I-45 and Carl Barton\'s Park!' ,`Acres` = '0.1897' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S249602 - BARTON CREEK RANCH 02, BLOCK 2, LOT 21' ,`LotDesciption` = 'Corner' ,`LotSize` = '8264' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'RUNYAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Barton Creek Ranch 02' ,`TaxAmount` = '7049' ,`TaxRate` = '2.7863' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1665764609' WHERE `Matrix_Unique_ID` = '211740627' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:08:40.013' ,`MLSNumber` = '92363898' ,`ListAgentFullName` = 'Jose Portillo' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.700179' ,`Longitude` = '-95.272995' ,`PhotoCount` = '28' ,`PostalCode` = '77017' ,`RoomCount` = '6' ,`ListPrice` = '279000.00' ,`Status` = 'Active' ,`StreetName` = 'Dalton' ,`StreetNumber` = '2815' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1984' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Updated house!!! Updated kitchen!!! Updated bathrooms!!! Updates include kitchen cabinets, granite counter, appliances, interior and exterior paint, lights, spotlights, luxurious waterproof vinyl laminate flooring, carpet, doors, baseboards, and many more.' ,`Acres` = '0.1561' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 2A BLK 5 PARK PLACE ACRE VILLA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SANCHEZ ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'CHAVEZ HIGH SCHOOL' ,`SchoolMiddle` = 'DEADY MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Park Place Acre Villa' ,`TaxAmount` = '4078' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764610' WHERE `Matrix_Unique_ID` = '211863377' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T06:32:30.570' ,`MLSNumber` = '27021453' ,`ListAgentFullName` = 'Tanya Warner' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.928034' ,`Longitude` = '-95.283174' ,`PhotoCount` = '23' ,`PostalCode` = '77396' ,`RoomCount` = '9' ,`ListPrice` = '344000.00' ,`Status` = 'Active' ,`StreetName` = 'Dewberry Shores' ,`StreetNumber` = '7007' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2611' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 4 bedroom, 2 full and 1/2 bath home in prestigious Fall Creek! This beautiful home sits on oversized corner lot with plenty of space to create memories. As you enter your home, gorgeous engineered floors greet you! There is a spacious dining room which flows into the open family room with vaulted ceilings, custom fireplace mantel and gas fireplace. Your chefs kitchen is equipped with a gas stove, expansive island, new porcelain mosaic tile backsplash and exquisite cabinetry! The second story invites family time with a generous gameroom/media area, three bedrooms and bathroom. Ceiling fans in every bedroom! Enjoy your private fenced backyard complete with a covered patio! NEW roof 2021 with warranty, NEW sprinkler heads & controller 2022.' ,`Acres` = '0.1689' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fall Creek Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 2 FALL CREEK SEC 34' ,`LotDesciption` = 'Corner' ,`LotSize` = '7357' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1090' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'FALL CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fall Creek' ,`TaxAmount` = '8438' ,`TaxRate` = '2.9973' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764610' WHERE `Matrix_Unique_ID` = '211878395' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:31:40.897' ,`MLSNumber` = '5187918' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.518531' ,`Longitude` = '-95.784026' ,`PhotoCount` = '7' ,`PostalCode` = '77471' ,`RoomCount` = '10' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Springview' ,`StreetNumber` = '3624' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2732' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Fairway Collection \"Southwind\" Plan with Elevation \"F\" in Sendero! \r\nThe beautiful one and half story Southwind floor plan by Lennar features a welcoming front porch and a lovely entrance foyer, a formal dining room, kitchen with breakfast area, a generous family room and a walk-in utility room and mud room. The master bedroom features an en suite bathroom with dual sinks, stand-up shower, private toilet enclosure and dual walk-in master closets. *HOME ESTIMATED TO BE COMPLETE, NOVEMBER, 2022*' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0003 BLK 001 LOT 021' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '756' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MEYER ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Sendero' ,`TaxAmount` = '' ,`TaxRate` = '3.09' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665764610' WHERE `Matrix_Unique_ID` = '211989175' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T06:53:51.790' ,`MLSNumber` = '3858559' ,`ListAgentFullName` = 'Jose Portillo' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.858783' ,`Longitude` = '-95.287497' ,`PhotoCount` = '21' ,`PostalCode` = '77016' ,`RoomCount` = '6' ,`ListPrice` = '214500.00' ,`Status` = 'Active' ,`StreetName` = 'Woodwick' ,`StreetNumber` = '10110' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1748' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WOW!!!! Update house!!! Updated Kitchen!!! Updated Bathroom, Updated A/C and heating. New ROOF was intalled!!!! Updates include kitchen cabinets, granite counter, appliances, interior and exterior paint, doors, baseboards, lights, spotlights, luxurious waterproof laminate vinyl planks, carpet, and many more!!!!!!' ,`Acres` = '0.1653' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 12 SCENIC WOODS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHADYDALE ELEMENTARY' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Scenic Woods' ,`TaxAmount` = '2498' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764610' WHERE `Matrix_Unique_ID` = '212077425' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:54:04.197' ,`MLSNumber` = '50720689' ,`ListAgentFullName` = 'Barbara Miller' ,`ListOfficeName` = 'Vista Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.443687' ,`Longitude` = '-95.417376' ,`PhotoCount` = '38' ,`PostalCode` = '77583' ,`RoomCount` = '8' ,`ListPrice` = '419000.00' ,`Status` = 'Active' ,`StreetName` = 'Carson' ,`StreetNumber` = '9631' ,`StreetSuffix` = '' ,`City` = 'Iowa Colony' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2891' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Boasting an array of sleek finishes & a thoughtful open layout, this immaculate 3 bedroom, 2.5 bathroom, w/office, & gameroom is full of upgrades. The beautiful kitchen is the heart of the home complete w/an oversized island & stainless steel appliances. The open home has an open concept Exquisite details are not spared in the en-Suite bath where you can soak all your cares away in the dreamy soaking tub while relaxing. The sellers spared no expense w/upgrades including tile plank flooring, upgraded cabinets, upgraded quartz, 8\' doors, speakers in/out, & a large extended back patio w/fans where fun will be had by all. The gameroom is large & is the perfect place to hang out and/or play games. Meridiana offers a ton of amenities for all ages. The buyers of this home will be able to enjoy the new Adventure Cove offering a wave pool, tidal river, fitness center & pavilion - Coming Soon!' ,`Acres` = '0.21' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Meridiana Sec 7 Blk 2 Lot 35' ,`LotDesciption` = 'Cleared,Corner,Subdivision Lot' ,`LotSize` = '9425' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764610' WHERE `Matrix_Unique_ID` = '212194328' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T06:32:59.223' ,`MLSNumber` = '11922276' ,`ListAgentFullName` = 'Margaret Bowers' ,`ListOfficeName` = 'Fathom Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.417076' ,`Longitude` = '-95.412624' ,`PhotoCount` = '32' ,`PostalCode` = '77303' ,`RoomCount` = '7' ,`ListPrice` = '189500.00' ,`Status` = 'Active' ,`StreetName` = 'Royal Tricia' ,`StreetNumber` = '10443' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '990' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Home has Been Totally Remodeled. New A/C Unit and Duct Work. New Roof, New Windows, New Tankless Water Heater, and New Kitchen Cabinets, Counter Tops and Refrigerator. Original Bath Refurbished with New Tiled, Walk-in Shower and Sink/Vanity and Second Bath Added with Tiled, Walk-in Shower and Sink/Vanity. Large Lot with Fenced Backyard. Front Yard with New Sod. Location is close to Conroe Regional Airport, shopping and dining.' ,`Acres` = '0.225' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Willis Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ROYAL FOREST 02, LOT 1249' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '9800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '170' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'EDWARD B. CANNAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Royal Forest 02' ,`TaxAmount` = '1410' ,`TaxRate` = '1.8448' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764611' WHERE `Matrix_Unique_ID` = '212295881' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T06:58:09.437' ,`MLSNumber` = '38492186' ,`ListAgentFullName` = 'Melanie Shadwick' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.973601' ,`Longitude` = '-95.657198' ,`PhotoCount` = '39' ,`PostalCode` = '77429' ,`RoomCount` = '14' ,`ListPrice` = '509000.00' ,`Status` = 'Active' ,`StreetName` = 'Cypress Hall' ,`StreetNumber` = '15938' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3492' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Walk your children to school or join a home school group at this family-centered COLES CROSSING, CY-FAIR ISD 4 bed, 3 bath, open floor plan corner lot home with baja shelf gunite pool! Fence enclosed patio for a safe play area, eat-in kitchen dining, island, granite counters, walk-in pantry, built-in desk w.shelves. Split bed floor plan, primary- 2 vanities, updated faucets/fixtures/shower enclosure, jetted tub and 3 tier closet! Upstairs media room or homeschool classroom & bath, home has 3 attic access points and storage+. 2 of 3 zoned A/C units new 2020,Ecobee Thermostat, 2 Wi-Fi GD Openers, Whole house power surge protector 2021,NEVER FLOODED, 240V adapter for Electric Vehicle Charging added 2018, Polaris pool equipment 2022, home painted 2022. Master Plan Community Amenities- private event spaces, multiple pools, swim team, water slides, splash areas, playgrounds, volleyball, tennis, sports field area, park, stocked pond and greenbelt. Seller Home Warranty.' ,`Acres` = '0.2106' ,`Area` = '10' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 3 COLES CROSSING SEC 15' ,`LotDesciption` = 'Corner' ,`LotSize` = '9174' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`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,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Coles Crossing' ,`TaxAmount` = '9532' ,`TaxRate` = '2.531' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764611' WHERE `Matrix_Unique_ID` = '212332584' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:27:12.500' ,`MLSNumber` = '94679467' ,`ListAgentFullName` = 'Jessica Smith' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.696856' ,`Longitude` = '-95.809654' ,`PhotoCount` = '21' ,`PostalCode` = '77406' ,`RoomCount` = '3' ,`ListPrice` = '385000.00' ,`Status` = 'Active' ,`StreetName` = 'Tidmor' ,`StreetNumber` = '24958' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1787' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in the Lakes of Bella Terra is this charming home ready for new ownership. It offers a sizable backyard with a covered patio and no back neighbors. Enter through a beautiful glass-paned wooden door where you note beautiful hardwood floors under elegant lighting. A lovely open floor plan includes a classic island kitchen bathed in white with under-cabinet lighting, subway tile backsplash, and recessed lighting. The kitchen overlooks the dining room and family room where a wall of windows allows for an abundance of natural light. A well-appointed office with a French Door enclosure overlooks the backyard. It rests across from a relaxing primary bedroom that opens to an ideal private bath. The bath includes a garden tub separating 2 vanity areas and a separate shower. Secondary bedrooms offer easy access to the hall bath and laundry room. Enjoy neighborhood amenities that include a clubhouse, fitness center, playground, green space, and a junior Olympic swimming pool!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKES OF BELLA TERRA WEST SEC 4, BLOCK 1, LOT 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5080' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '925' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUBENAK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Photos/No Videos,Request Online Appointment' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes Of Bella Terra West Sec 4' ,`TaxAmount` = '7157' ,`TaxRate` = '3.0848' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764611' WHERE `Matrix_Unique_ID` = '212334912' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:16:35.263' ,`MLSNumber` = '17803818' ,`ListAgentFullName` = 'Yolanda Ingram' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.057609' ,`Longitude` = '-95.557867' ,`PhotoCount` = '38' ,`PostalCode` = '77379' ,`RoomCount` = '9' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Night Beacon Point' ,`StreetNumber` = '9106' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2457' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful One Story with Pool and Spa. On a Cul de Sac and on a Greenbelt. Spectacular floor open floor plan with 3 bedrooms, Game room down between the secondary bedrooms. Boasts a nice size formal dining room and an office/study. This kitchen offers an island with breakfast bar and a breakfast room. The secret.....there is a small basketball court inside the back yard! The spectacular pool and spa has privacy and lovely landscaping!\r\nThere are newer features with this home: roof 2016, pool heater 2020, and pool pump 2021. Kitchen cabinets will be painted white in the next few days.' ,`Acres` = '0.216' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 1 GLEANNLOCH FARMS SEC 30' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '9408' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'FRANK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'DOERRE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gleannloch Farms Sec 30' ,`TaxAmount` = '6872' ,`TaxRate` = '2.7315' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764611' WHERE `Matrix_Unique_ID` = '212460829' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:15:23.613' ,`MLSNumber` = '93711110' ,`ListAgentFullName` = 'Ashley Werner' ,`ListOfficeName` = 'Realty ONE Group Iconic' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.045744' ,`Longitude` = '-95.401759' ,`PhotoCount` = '25' ,`PostalCode` = '77373' ,`RoomCount` = '7' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Naplechase Crest' ,`StreetNumber` = '2043' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3045' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderfully spacious and updated home in the Park Springs neighborhood. This home boasts 4 bedrooms, 2 & 1 half baths. The kitchen has an abundant amount of cabinet space and displays a wonderful open floor plan with a large island. Upon entry to the living space you will notice the vaulted ceiling’s. Perfect for a 12’ Christmas Tree! The ample primary suite is located downstairs. The highlight of this home is the primary en-suite as well as the secondary bathroom remodel including marble tiling through out the showers for a luxurious feel. Enjoy the splendor of no carpeting downstairs with the entire first floor redone in porcelain tile and freshly replaced carpeting upstairs. Once on the second floor you will enter into the sizeable game room and enjoy the endless possibilities with this space. All other secondary rooms are located upstairs. This home is conveniently located with easy access to the Hardy Toll Road, Hwy 45, the Cypress Creek Hike & Bike Trail.' ,`Acres` = '0.1225' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 35 BLK 2 PARK SPRING SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5335' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '315' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PEARL M HIRSCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'TWIN CREEKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Park Spring' ,`TaxAmount` = '7228' ,`TaxRate` = '3.0268' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764611' WHERE `Matrix_Unique_ID` = '212489589' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:14:41.010' ,`MLSNumber` = '15456664' ,`ListAgentFullName` = 'Nery Mazariegos' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = 'Monique Collins' ,`SellingOfficeName` = 'Keller Williams Premier RealtyKaty' ,`Latitude` = '29.754348' ,`Longitude` = '-95.741964' ,`PhotoCount` = '34' ,`PostalCode` = '77450' ,`RoomCount` = '6' ,`ListPrice` = '382000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Park Timbers' ,`StreetNumber` = '21526' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1927' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME to this *NEWLY REMODELED* home offering 3 bedrooms, 2 bathrooms, POOL & attached two-car garage. This gem is LOADED WITH UPGRADES- designer paint, luxe flooring, natural stone surrounded fireplace, ceiling fans, stylish light fixtures and hardware & tall tray ceilings with luxe crown molding. The home’s UPDATES include; new HVAC, new 30 year roof, all new SS appliances, fresh carpet & flooring, gleaming new Quartz countertops, new water heaters & brand new pool equipment. The newly renovated kitchen features freshly painted cabinets, sprawling countertops, a walk-in pantry, and beautiful gold hardware. Windows spread across the entire rear of the home for ample amounts of natural lighting & views of the backyard oasis. The layout is open & inviting! Retreat to the luxe primary suite that offers a large closet & spa-like ensuite bathroom. Step outside to enjoy your backyard w/ in-ground POOL & TUB, green space, and covered patio. Zoned to Katy ISD. Easy access to 99 & I-10.' ,`Acres` = '0.1627' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 81 BLK 2 MEMORIAL PARKWAY SEC 18' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot,Wooded' ,`LotSize` = '7089' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '525' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'HAYES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'MCMEANS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Pkwy' ,`TaxAmount` = '6099' ,`TaxRate` = '2.4133' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764612' WHERE `Matrix_Unique_ID` = '212550496' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T06:36:23.250' ,`MLSNumber` = '13294062' ,`ListAgentFullName` = 'Owais Gopalani' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.502902' ,`Longitude` = '-95.719478' ,`PhotoCount` = '50' ,`PostalCode` = '77469' ,`RoomCount` = '9' ,`ListPrice` = '679900.00' ,`Status` = 'Active' ,`StreetName` = 'Turquoise Hill Lane' ,`StreetNumber` = '5838' ,`StreetSuffix` = '' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3399' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This IMMACULATE BRAND NEW PERRY HOME is LOADED with upgrades, too many to list. Walk in to luxury with a spiral stair case and rotunda welcoming you as well as upgraded lighting, crown molding, tray ceilings, and a modern and contemporary design throughout the home. Spacious living room with large windows. Huge kitchen with a spice cabinet in the pantry, new appliances, and a large game room upstairs. Escape to your backyard retreat with an EXTENDED COVERED PATIO, and no back neighbors. Oversized 3 car garage with an electric car plug. This home is covered under the 2 year Perry DOOR to DOOR warranty. Zones to top rated schools in Rosenberg and located minutes from highway 59 and the Brazos Town Center.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot(s): 10 Block: 1 Stonecreek Estates Section 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8777' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CARTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Stone Creek Estates' ,`TaxAmount` = '' ,`TaxRate` = '3.28' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1665764612' WHERE `Matrix_Unique_ID` = '212587846' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:01:14.840' ,`MLSNumber` = '45485230' ,`ListAgentFullName` = 'Jose Portillo' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.812574' ,`Longitude` = '-95.347889' ,`PhotoCount` = '17' ,`PostalCode` = '77026' ,`RoomCount` = '4' ,`ListPrice` = '224900.00' ,`Status` = 'Active' ,`StreetName` = 'Crittenden' ,`StreetNumber` = '2421' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1485' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t miss this opportunity, be almost at the center of any direction all. Close to almost all major freeways. Beautiful updated house. There are so many updates that is hard to count them. Updated kitchen. Updated bathrooms. Updates include kitchen cabinets, granite counter, appliances, lights, spotlights, interior and exterior paint, doors, baseboards, luxurious waterproof vinyl planks, carpet, and many more. ROOF!!! new roof was installed.' ,`Acres` = '0.1578' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 CENTRAL GARDENS SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6875' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ROSS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Central Gardens' ,`TaxAmount` = '1511' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764612' WHERE `Matrix_Unique_ID` = '212596974' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:09:33.507' ,`MLSNumber` = '60857606' ,`ListAgentFullName` = 'Jose Portillo' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.647049' ,`Longitude` = '-95.354931' ,`PhotoCount` = '13' ,`PostalCode` = '77048' ,`RoomCount` = '6' ,`ListPrice` = '214000.00' ,`Status` = 'Active' ,`StreetName` = 'Palisade' ,`StreetNumber` = '4721' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1533' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'House with many updates/remodeled. Updates include kitchen cabinets, granite counter, appliances, interior and exterior paint, lights, spotlights, carpet, luxurious waterproof vinyl laminate planks, and many more. NEW ROOF was installed!!! NEW A/C System and AIR Duct was installed!!!!!' ,`Acres` = '0.1515' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 22 BLK 3 SOUTH ACRES ESTATES SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WOODSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'South Acres Estates Sec 02' ,`TaxAmount` = '1817' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764612' WHERE `Matrix_Unique_ID` = '212658691' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:27:30.627' ,`MLSNumber` = '884873' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.146844' ,`Longitude` = '-95.678280' ,`PhotoCount` = '7' ,`PostalCode` = '77362' ,`RoomCount` = '10' ,`ListPrice` = '560000.00' ,`Status` = 'Active' ,`StreetName` = 'Lakemont Bend' ,`StreetNumber` = '1076' ,`StreetSuffix` = 'Lane' ,`City` = 'Pinehurst' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3376' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Awesome NEW Village Builders Wentworth Series, \'\'Rocklin\" Design with Elevation \"C\'\', located in Stunning Woodtrace! This Magnificent 1.5 home has 4 bedrooms, 3.5 baths and a 3 Car Garage w/ Storage space, also, a welcoming front porch with a Handsome Study off of the foyer, an Open concept layout with a really Large Family Room and a Gorgeous Formal Dining Room. Gourmet Island Kitchen has 42\" Cabinets & Great Appliance Pkg! Luxury Master Suite has a Shower, Separate Tub, and Huge W/I Closet with direct access to the laundry room. A Covered back patio is just waiting for you. This home has so much to offer, you will not want to miss it!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Village Builders' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Sect 13, BLOCK 3, Lot 14' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodtrace' ,`TaxAmount` = '' ,`TaxRate` = '3.4309' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665764612' WHERE `Matrix_Unique_ID` = '212708519' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T06:02:53.793' ,`MLSNumber` = '15915316' ,`ListAgentFullName` = 'Julie Chaddick' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.290099' ,`Longitude` = '-95.407027' ,`PhotoCount` = '37' ,`PostalCode` = '77301' ,`RoomCount` = '8' ,`ListPrice` = '549999.00' ,`Status` = 'Active' ,`StreetName` = 'Explorer' ,`StreetNumber` = '3285' ,`StreetSuffix` = 'Way' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4204' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful MUST SEE, ONE OWNER Home in BARTON WOODS!! Grand foyer with high ceilings with stunning open staircase, an Office with hardwood floors, Primary bedroom has 2 walk-in closets, separate tub/shower. This home has so many extras…..Large kitchen with all stainless steel appliances, with attached breakfast area, extra large pantry, butler’s pantry, formal dining room, all bedrooms have walk in closets, a second family room on the 2nd floor, a 3 car Tandem garage, tons of storage, 3 floored attics, 2 hot water heaters, gas fireplace, and Extra Large Laundry room. The beautiful landscape front and backyards bring great curb appeal. A new roof was added 9/21. The 2018 washer/dryer, security system and water-softener will convey to the new owner. Schedule an appointment TODAY!!' ,`Acres` = '0.2498' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S249502 - BARTON WOODS 02, BLOCK 5, LOT 22' ,`LotDesciption` = 'Other' ,`LotSize` = '10880' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Barton Woods' ,`TaxAmount` = '10976' ,`TaxRate` = '2.7863' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764612' WHERE `Matrix_Unique_ID` = '212741263' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:30:35.127' ,`MLSNumber` = '57494559' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.518503' ,`Longitude` = '-95.784257' ,`PhotoCount` = '6' ,`PostalCode` = '77471' ,`RoomCount` = '8' ,`ListPrice` = '370000.00' ,`Status` = 'Active' ,`StreetName` = 'Springview' ,`StreetNumber` = '3632' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosenberg' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2393' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Fairway Collection \"Russo IV\" Plan with Elevation \"B\" in Sendero! Beautiful single-story home featuring a cohesive design shared among the modern kitchen, dining and family room, with an attached covered patio. Three bedrooms and a study present ample flexibility in the front of the home. The owner’s suite highlights privacy tucked away at the end of the home, complete with a lavish bathroom and walk-in closet. *HOME ESTIMATED TO BE COMPLETE, DECEMBER, 2022*' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0003 BLK 001 LOT 019' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '756' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MEYER ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sendero' ,`TaxAmount` = '' ,`TaxRate` = '3.09' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665764613' WHERE `Matrix_Unique_ID` = '212769435' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T06:37:09.673' ,`MLSNumber` = '87983723' ,`ListAgentFullName` = 'Jason Hooley' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.859269' ,`Longitude` = '-95.600400' ,`PhotoCount` = '22' ,`PostalCode` = '77041' ,`RoomCount` = '9' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'Dove Brook' ,`StreetNumber` = '12806' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2865' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous Eldridge Park Home! Welcome Home to a meticulously maintained and thoughtfully updated 2-story 4-bedroom gem! Great David Weekley floorplan with primary suite on the ground floor and large den/office near the entry. The spacious kitchen boasts new backsplash, quartz tops, and stainless appliances. Formal dining room and oversized living room highlighted by soaring ceiling, lots of natural light, and a view of the garden-like backyard. Upstairs, the huge landing provides space for another family room, exercise space, or whatever you need! 2022 roof, HVAC upgrades, and lots of updates for you to enjoy! No flooding or freeze damage per seller. Wonderful location near Beltway, 290 and lots of amenities. Request a showing today!' ,`Acres` = '0.1686' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 33 BLK 2 ELDRIDGE PARK SEC 3' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7345' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '610' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'KIRK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Eldridge Park Sec 03' ,`TaxAmount` = '6728' ,`TaxRate` = '2.471' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764613' WHERE `Matrix_Unique_ID` = '212821041' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T06:58:17.800' ,`MLSNumber` = '59000202' ,`ListAgentFullName` = 'Angie Farish' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.544087' ,`Longitude` = '-95.666634' ,`PhotoCount` = '48' ,`PostalCode` = '77479' ,`RoomCount` = '11' ,`ListPrice` = '465000.00' ,`Status` = 'Active' ,`StreetName` = 'Terrace View' ,`StreetNumber` = '1342' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2940' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy Sugar Land living in this 4–5-bdrm home in the highly sought after Greatwood master planned community. This property is conveniently situated right next to a private park. Welcome your guests through your new sleek front door and invite them into this gorgeous two-story home that features a salt-water pool. Enjoy a home office, game room, and study room. The chef’s kitchen and spacious living area allow for great conversations and family time. The kitchen’s stainless steel appliances stay! Feel safe with a Nest doorbell, back outdoor camera, and Nest carbon monoxide/smoke detectors installed in different rooms. Relish in cool air with a new HVAC system. New garage door opener, remodeled secondary bathrooms and new 14 windows in the back of the house are some of the additional improvements we can’t wait to show you. You don’t want to miss all these great features. Come and tour this beautiful home today!' ,`Acres` = '0.1857' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GREATWOOD STONEBRIDGE SEC 1, BLOCK 6, LOT 1' ,`LotDesciption` = 'Corner,Greenbelt,In Golf Course Community,Subdivision Lot' ,`LotSize` = '8088' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '910' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Greatwood Stonebridge Sec 1' ,`TaxAmount` = '7224' ,`TaxRate` = '2.3013' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764613' WHERE `Matrix_Unique_ID` = '212822988' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:57:35.217' ,`MLSNumber` = '90526312' ,`ListAgentFullName` = 'Latosha Davis' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.484455' ,`Longitude` = '-95.364739' ,`PhotoCount` = '21' ,`PostalCode` = '77578' ,`RoomCount` = '6' ,`ListPrice` = '439500.00' ,`Status` = 'Active' ,`StreetName` = 'Marble Falls' ,`StreetNumber` = '6607' ,`StreetSuffix` = 'Lane' ,`City` = 'Manvel' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2552' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this meticulously maintained Cervelle Custom Home! This beautiful Waterfront property is immaculate and ready for immediate move in! As you enter the home there\'s a private study to your left that can easily be converted into a fourth bedroom. Nestled in the primary bath is a sensational soaker tub for relaxation. Kitchen presents massive storage, granite counter tops, built in microwave, oven, under cabinet lighting and a carbon monoxide detecter. This ultimate floor plan boost updated light fixtures, soaring ceilings, formal dining with columns, solar screens for energy savings, storm doors, extensive crown molding throughout home and bay windows in kitchen area with charming water views. Not to mention this spacious lot has an extended patio, plenty of parking space, and a huge backyard great for entertaining. AS AN ADDED PROTECTION YOUR HOME COMES WITH A CHOICE HOME WARRANTY AND A DEHUMIDIFIER FOR CLEANER AIR! SCHEDULE YOUR SHOWING TODAY!' ,`Acres` = '0.2444' ,`Area` = '5' ,`BuilderName` = 'Cervelle Custom Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LAKELAND SD SEC 4 (A0493 HT&BRR) (MANVEL) BLK 2 LOT 66' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '10646' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'E C MASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'MANVEL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Mediterranean,Traditional' ,`Subdivision` = 'Lakeland SD Sec 4 A0493 Ht&Br' ,`TaxAmount` = '11674' ,`TaxRate` = '3.5974' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764613' WHERE `Matrix_Unique_ID` = '212829268' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:52:47.430' ,`MLSNumber` = '47030144' ,`ListAgentFullName` = 'Melissa Land' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.692777' ,`Longitude` = '-95.214070' ,`PhotoCount` = '17' ,`PostalCode` = '77506' ,`RoomCount` = '8' ,`ListPrice` = '199900.00' ,`Status` = 'Active' ,`StreetName` = 'Denham' ,`StreetNumber` = '304' ,`StreetSuffix` = 'Avenue' ,`City` = 'Pasadena' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1634' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Must See Home with recently installed Central Air HVAC System in main house 3 beds 1 bath and back studio with 4th bedroom has AC window unit and storage that could be converted to a private bath. The back studio could be rented out for potential income. The home has just recently been renovated giving the interior of the home a modern feel. Recent updates include freshly painted interior and exterior, lighting throughout has been upgraded to LED, updated door knobs, recently installed carpet, LVT flooring, and tile. The entire bathroom has been redone: tub, tile, toilet, vanity, sink, faucet, and mirror. In the kitchen, you will find recently installed granite, backsplash, faucet, disposal, range, microwave, and hardware. For your privacy 2 “ faux wood blinds throughout. Other added features: electric hot water heater, PEX Plumbing system, and the utility room was moved inside the house. Make this home yours and enjoy the comforts of having a renovated home. owner/agent' ,`Acres` = '0.1896' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 33 SUNNYSLOPE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8260' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'MORALES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SAM RAYBURN HIGH SCHOOL' ,`SchoolMiddle` = 'SOUTHMORE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunnyslope Sec 01' ,`TaxAmount` = '2358' ,`TaxRate` = '2.6514' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1947' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764613' WHERE `Matrix_Unique_ID` = '212877450' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T06:07:00.583' ,`MLSNumber` = '77481389' ,`ListAgentFullName` = 'Julie Chaddick' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.406097' ,`Longitude` = '-95.568237' ,`PhotoCount` = '27' ,`PostalCode` = '77318' ,`RoomCount` = '4' ,`ListPrice` = '299316.00' ,`Status` = 'Active' ,`StreetName` = 'Gentle Breeze' ,`StreetNumber` = '6922' ,`StreetSuffix` = 'Drive' ,`City` = 'Willis' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1606' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Live in Seven Coves! This Colonial brick House features, Water Views of Lake Conroe from your Dining Room table! Walking distance to the Boat Ramp, pool, marina, basketball courts and tennis courts! Huge windows throughout this custom home, granite countertops, spacious upstair master suite with balcony over the deck in the backyard. The oversized 2 Car Garage has a large work area with sink and a bathroom. The Outside yard is ready for your summer BBQ’s to enjoy with family and friends. This is a MUST HAVE!' ,`Acres` = '0.1217' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SEVEN COVES 05, BLOCK 9, LOT 42' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '5300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '525' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'Seven Coves' ,`TaxAmount` = '4377' ,`TaxRate` = '2.3198' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764614' WHERE `Matrix_Unique_ID` = '212891677' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:32:20.207' ,`MLSNumber` = '82496625' ,`ListAgentFullName` = 'Angela Ritchey' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.663992' ,`Longitude` = '-95.459254' ,`PhotoCount` = '36' ,`PostalCode` = '77035' ,`RoomCount` = '9' ,`ListPrice` = '558844.00' ,`Status` = 'Active' ,`StreetName` = 'Willowbend' ,`StreetNumber` = '4801' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2925' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Traditional meets rustic in this beautiful 3 bed, 2 bath home with office. Separate living quarters add 1 bedroom and 1 full bath. Reclaimed wood accent walls, plantation shutters, white oak hardwood floors throughout. Expansive open-floor plan. Kitchen boasts island, granite counters, stainless steel appliances with space to add a wine chiller and wine rack. Immense primary bedroom suite boasts his and hers walk-in closets. Spacious primary bath flaunts granite counter, double sinks, walk-in shower. Abundance of closets, drawers, cabinets, open shelves. The handblown glass chandelier highlights the dining room. Comfortable family room is accented with French doors opening to flagstone patio, covered porch with outdoor kitchen. Plenty of parking: 2-car garage, circle, double sided, and single driveways; can park RV or boat. Whole-house water purifier. PVC plumbing inside and under house. Easy access to I-610, minutes to the Galleria and Medical Center. No previous flooding per seller.' ,`Acres` = '0.2152' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Willow Meadows Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 135 BLK 8 WILLOW BEND' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9375' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '125' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'RED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style,Ranch,Traditional' ,`Subdivision` = 'Willow Bend Sec 01' ,`TaxAmount` = '10058' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764614' WHERE `Matrix_Unique_ID` = '212983880' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:32:26.900' ,`MLSNumber` = '26833215' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.518643' ,`Longitude` = '-95.784026' ,`PhotoCount` = '6' ,`PostalCode` = '77471' ,`RoomCount` = '8' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Springview' ,`StreetNumber` = '3627' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2386' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Fairway Collection \"Cabot\" Plan with Elevation \"E\" in Sendero! A single-story layout with a large covered patio, this home offers private bedrooms with a shared bathroom near the foyer. Beyond the foyer is a spacious kitchen that overlooks the dining room and family room. Nearby is the owner’s suite which features a large shower with seating and an oversized walk-in closet. *HOME ESTIMATED TO BE COMPLETE, DECEMBER, 2022*' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0003 BLK 001 LOT 033' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '756' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MEYER ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sendero' ,`TaxAmount` = '' ,`TaxRate` = '3.09' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665764614' WHERE `Matrix_Unique_ID` = '212989249' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:20:55.920' ,`MLSNumber` = '15197166' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.514097' ,`Longitude` = '-95.443496' ,`PhotoCount` = '16' ,`PostalCode` = '77545' ,`RoomCount` = '8' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Walworth Creek' ,`StreetNumber` = '14238' ,`StreetSuffix` = 'Court' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1932' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW Lennar Homes Wildflower Collection, \'\'Clover II\'\' Plan Elevation \"B\" in Lakes of Savannah. This single-story home showcases a generous open floorplan shared between the family room, dining room and kitchen, leading directly to a covered patio for seamless indoor-outdoor living. A flex room off the foyer is perfect as a home office or bonus room. Four bedrooms complete this home. *HOME ESTIMATED TO BE COMPLETE, NOVEMBER, 2022*' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0019 BLK 002 LOT 005' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes of Savannah' ,`TaxAmount` = '' ,`TaxRate` = '3.09' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665764614' WHERE `Matrix_Unique_ID` = '213006337' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:00:24.063' ,`MLSNumber` = '30240555' ,`ListAgentFullName` = 'Larry Gozan' ,`ListOfficeName` = 'Boncler Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.484774' ,`Longitude` = '-98.521362' ,`PhotoCount` = '12' ,`PostalCode` = '78201' ,`RoomCount` = '3' ,`ListPrice` = '217000.00' ,`Status` = 'Active' ,`StreetName` = 'El Monte' ,`StreetNumber` = '1612' ,`StreetSuffix` = 'Boulevard' ,`City` = 'San Antonio' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1122' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This property is in great condition, Washer and Dryer only 2 years old, refrigerator 2 year old, ceiling fans in the living room and all 3 bedrooms, Living room floor is hard wood, tile in the hall ways and carpet in the bedrooms, The roof is only 7 years old, Granit counter tops, marble backsplash, double sink with a goose neck faucet. Centrally located near two large malls, medical center, super Walmart, Super Target, this house is only minutes away from most daily amenities.' ,`Acres` = '0.1708' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'NCB 9087 BLK 183 LOT E 37.5 FT OF 7 & W 25 FT OF 8' ,`LotDesciption` = 'Other' ,`LotSize` = '7440' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '239 - San Antonio' ,`SchoolElementary` = 'NEAL ELEMENTARY SCHOOL (SAN ANTONIO)' ,`SchoolHigh` = 'EDISON HIGH SCHOOL' ,`SchoolMiddle` = '' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Angeles Heights Add' ,`TaxAmount` = '4827' ,`TaxRate` = '2.7938' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1942' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764614' WHERE `Matrix_Unique_ID` = '213008864' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213147642','1665764615','213147642','2022-10-14T07:18:57.627','8553427','Garrett Mohnke','Complete Property Services','','','29.932126','-95.089664','19','77532','3','225000.00','Active','Forelock','17215','Way','Crosby','2','0','3','1954','Single-Family','Spacious move in ready home in sought after Newport. Living room with vaulted ceiling and corner fireplace, large den and dining area with built-in shelves. Fresh interior paint throughout the home and new carpet in the ample-sized bedrooms.','0.2066','1','','','','','Sellers Disclosure','','','1','Crosby Area','Central Gas','1','LT 12 BLK 3 NEWPORT SEC 10','Subdivision Lot','9000','Appraisal District','','55','0','','2','','0','','','','','Composition','12 - Crosby','NEWPORT ELEMENTARY SCHOOL','CROSBY HIGH SCHOOL','CROSBY MIDDLE SCHOOL (CROSBY)','Appointment Required','Appraisal District','1','Ranch,Traditional','Newport','4722','2.7105','Public Water','1979','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:37:01.143' ,`MLSNumber` = '34278550' ,`ListAgentFullName` = 'Brenda Hebert' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.469143' ,`Longitude` = '-95.115400' ,`PhotoCount` = '50' ,`PostalCode` = '77573' ,`RoomCount` = '4' ,`ListPrice` = '465000.00' ,`Status` = 'Active' ,`StreetName` = 'Amado' ,`StreetNumber` = '2001' ,`StreetSuffix` = 'Lane' ,`City` = 'League City' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2831' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Plan #253 offers 4 bedrooms and 3 full bathrooms in the home, MASSIVE Bonus Room with Glass French Doors, in addition to a Formal Dining Room with dual access from different areas of the home (french doors off of the front entry and second door off of the kitchen). This plan offers a second primary suite perfect for MIL or Guests as it has its own full/private bathroom. This split floor plan has the primary suite in the back of the home and two additional bedrooms with a 3rd large bathroom at the front of the home. The kitchen is large with 42\" cherry cabinets, granite countertops, a large island, and it\'s open to the family room and breakfast area. There\'s a walk in pantry and a generously sized laundry room right off the kitchen. The garage is a 2.5 car in size with a full bathroom and a 2.5 car porte-cache provides covered parking; double wide driveway; quiet corner lot. New luxury vinyl floors throughout; new paint throughout. See Attachments for full list of updates by builder' ,`Acres` = '0.2311' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEDONA SEC 5 (2017) ABST 3, BLOCK 8, LOT 54, ACRES 0.23' ,`LotDesciption` = 'Cleared,Corner,Subdivision Lot' ,`LotSize` = '10067' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BAUERSCHLAG ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'VICTORYLAKES INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sedona Sec 5' ,`TaxAmount` = '6067' ,`TaxRate` = '2.004626' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764615' WHERE `Matrix_Unique_ID` = '213208315' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:03:54.647' ,`MLSNumber` = '46855470' ,`ListAgentFullName` = 'Matthew Barnes' ,`ListOfficeName` = 'All City Real Estate, Ltd. Co.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.595073' ,`Longitude` = '-95.803879' ,`PhotoCount` = '30' ,`PostalCode` = '77471' ,`RoomCount` = '11' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'Winchester' ,`StreetNumber` = '2314' ,`StreetSuffix` = 'Lake' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2043' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 2314 Winchester Lake. LOVELY SINGLE STORY HOME WITH A WATER VIEW! This charming well-maintained ALL-BRICK home features 3 bedrooms, 2 full baths. Inviting curb appeal and landscaping. You\'ll love this freshly painted open concept floor plan with high-pitched ceilings, abundant natural light, and tasteful walnut engineered hardwood flooring. New roof in 2018, new appliances, and new water heater, Gorgeous professionally refinished white kitchen cabinets with black hardware pulls, granite counters, and distinctive transom windows create refreshingly elegant kitchen. Large living area with corner fireplace. Spacious master bedroom, en-suite bath with separate shower, jacuzzi tub, and walk-in closet. Attached flex space would work great for an office/study or private living area. Enjoy the evenings on your extended patio shaded in the afternoons which overlooks a small lake with access out of the back yard. A peaceful and serene view everyday!' ,`Acres` = '0.1386' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'KINGDOM HEIGHTS SEC 1, BLOCK 7, LOT 15' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '6038' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '660' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kingdom Heights' ,`TaxAmount` = '5803' ,`TaxRate` = '2.7948' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764615' WHERE `Matrix_Unique_ID` = '213216915' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213243422','1665764615','213243422','2022-10-14T06:10:40.807','60892942','Dawn Hill','Coldwell Banker Realty','','','30.802618','-95.187858','49','77364','5','220000.00','Active','Parkview','161','Drive','Point Blank','2','0','3','1465','Single-Family','Nestled in the waterfront community of Hidden Coves, this 3 bedroom, 2 bath home is waiting for your arrival! Updates throughout, the open floor plan has a central living area with high ceilings and expansive windows. The kitchen has been recently updated, has new stainless steel appliances, & the refrigerator is included. The primary bedroom has ample built-in cabinetry, French doors leading to the front porch, and an en suite bathroom. The additional 2 bedrooms are located across the living area from the primary bedroom with the additional bathroom between them. There is tile flooring throughout the home. Beautiful outdoor spaces, and the backyard area is very private. There is a carport and 2 storage sheds. One shed (8\'x9\') is smaller for tools, and the large shed (20\'x10\' with electricity & window unit) was previously used for crafting. Whole home generator. Hidden Coves has a community boat launch and swimming pool. Come enjoy Lake Livingston!','0.3478','64','','','Electric Dryer Connections,Washer Connections','','No Disclosures,Probate','1','','0','Lake Livingston Area','Central Electric','1','HIDDEN COVE #1, BLOCK 2, LOT 32 & 33, ACRES .3478','Subdivision Lot','15150','Appraisal District','','230','0','','0','Electric Oven,Freestanding Oven','0','','','Electric Range','','Composition','101 - Coldspring-Oakhurst Consolidated','JAMES STREET ELEMENTARY SCHOOL','COLDSPRING-OAKHURST HIGH SCHOOL','LINCOLN JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Other Style','Hidden Cove #1','2478','1.6254','Public Water,Septic Tank','1983','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:04:30.963' ,`MLSNumber` = '78753392' ,`ListAgentFullName` = 'David Mills' ,`ListOfficeName` = 'TBT Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.033630' ,`Longitude` = '-95.563728' ,`PhotoCount` = '21' ,`PostalCode` = '77422' ,`RoomCount` = '5' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = 'Mulberry' ,`StreetNumber` = '423' ,`StreetSuffix` = 'Lane' ,`City` = 'Brazoria' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2026' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This spacious home sits on a large corner lot. The updates to this home showcase the work of a true craftsman! The living room is open with updated flooring stretching across the entire area into the dining. Continuing into a kitchen that is a chef\'s delight! Here you will find custom cabinetry and beautiful countertops complimented by a coordinating backsplash and plenty of counter space, updated faucet, updated stove, and to \'top off\' the modern feel, a stainless steel pot filler. Partnering this beautiful kitchen is a walk-in pantry with matching countertops and more customized storage. Adjacent to the kitchen is an indoor wash room with access from the exterior and garage with plenty of space for a drop zone. There is no shortage of space outdoors either. With a large patio and lots of yard space, this is a canvas ready for perfection. More updates include Entire re-roof in 2019. Pex plumbing. Updated facia boards. Massive primary bedroom closet. Paint. Bathrooms. Come See!' ,`Acres` = '0.3857' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'GARDEN ACRES (BRAZORIA), BLOCK 3, LOT 4-5' ,`LotDesciption` = 'Corner' ,`LotSize` = '16801' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Garden Acres Brazoria' ,`TaxAmount` = '4178' ,`TaxRate` = '2.3372' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764615' WHERE `Matrix_Unique_ID` = '213245812' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:26:48.570' ,`MLSNumber` = '74667747' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.518503' ,`Longitude` = '-95.784257' ,`PhotoCount` = '6' ,`PostalCode` = '77471' ,`RoomCount` = '8' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'Springview' ,`StreetNumber` = '3619' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1990' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Fairway Collection \"Blackstone\" Plan with Elevation \"F\" in Sendero! The beautiful one-story Blackstone plan by Lennar features an inviting front porch and entry foyer, a dining room, an island kitchen with walk-in pantry and breakfast room that offers access to a relaxing covered rear patio, a generous open family room and a walk-in utility room. The master bedroom features an en suite master bathroom with dual sinks, stand-up shower, private toilet enclosure, and access to a large master closet. *HOME ESTIMATED TO BE COMPLETE, DECEMBER, 2022*' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0003 BLK 001 LOT 031' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '756' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MEYER ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sendero' ,`TaxAmount` = '' ,`TaxRate` = '3.09' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665764615' WHERE `Matrix_Unique_ID` = '213257973' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:15:34.627' ,`MLSNumber` = '35973336' ,`ListAgentFullName` = 'Antrechelle Schumack' ,`ListOfficeName` = 'ERA Legacy Living' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.560195' ,`Longitude` = '-95.364434' ,`PhotoCount` = '24' ,`PostalCode` = '77584' ,`RoomCount` = '9' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Sunlake' ,`StreetNumber` = '9306' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3561' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 5 bedroom home with NO back neighbors! Enjoy the lake view when entering. This home features 2 bedrooms down, one of which being the primary bedroom and bathroom. The kitchen has an open concept into the living room that makes it perfect for entertaining guest. A spacious living area awaits you upstairs that can be whatever you’d like, along with 3 additional bedrooms and 2 bathrooms. You do not want to miss out on this gem!' ,`Acres` = '0.2009' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SUNRISE LAKES SEC 1 (A0721) (PEARLAND) BLK 7 LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8751' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'LAWHON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GLENDA DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH WEST' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunrise Lakes Sec 1' ,`TaxAmount` = '10712' ,`TaxRate` = '2.8851' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764615' WHERE `Matrix_Unique_ID` = '213267169' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:29:58.670' ,`MLSNumber` = '9511367' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.146354' ,`Longitude` = '-95.678428' ,`PhotoCount` = '8' ,`PostalCode` = '77362' ,`RoomCount` = '9' ,`ListPrice` = '500000.00' ,`Status` = 'Active' ,`StreetName` = 'Platinum Stone' ,`StreetNumber` = '715' ,`StreetSuffix` = 'Lane' ,`City` = 'Pinehurst' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2770' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW!! Gorgeous Village Builders Wentworth Series \'\'Norwalk\" Design with Elevation \'\'C\'\' in Woodtrace! \r\nThis expansive single-story home is ideal for modern family living with an open-concept design shared by the kitchen, dining room and Great Room. A relaxing rear patio offers seamless indoor-outdoor living. Three secondary bedrooms and a versatile study are found off the foyer, while the lavish owner’s suite with a spa-style bathroom and walk-in closet is at the back of the home for privacy. Handy Workshop Space in garage. *Fireplace, Extended Covered Patio!!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Village Builders' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0013 BLK 002 LOT 013' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodtrace' ,`TaxAmount` = '' ,`TaxRate` = '3.4309' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665764616' WHERE `Matrix_Unique_ID` = '213297104' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:13:57.673' ,`MLSNumber` = '4953106' ,`ListAgentFullName` = 'Lauren Dito' ,`ListOfficeName` = 'Beth Wolff, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.706304' ,`Longitude` = '-95.816124' ,`PhotoCount` = '24' ,`PostalCode` = '77494' ,`RoomCount` = '10' ,`ListPrice` = '939900.00' ,`Status` = 'Active' ,`StreetName` = 'Cinco Ridge' ,`StreetNumber` = '9903' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4819' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 5 bedroom home in Cinco Ranch with a POOL and a TOTALLY REMODELED KITCHEN! Kitchen has a HUGE Island, Stainless Steel Appliances, and a Walk-In Pantry. The Family Room with floor-to-ceiling windows, Cast Stone Fireplace, and soaring ceiling opens to the kitchen and breakfast nook. The Primary Suite features bay windows and sitting area overlooking the Sparkling Pool. Primary En Suite has Dual Sinks, Vanity, Separate Frameless Shower, and Soaking Tub, and TWO Large Walk-In Closets. The main level also has a Second Bedroom and Full Bath near the pool. The upper level boasts a Media Room, Game Room, two-person study nook, and three generously sized secondary bedrooms. Beautiful Backyard features a Sparkling Pool with three waterfall features. Recent updates including wood-like tile throughout the main level, TANKLESS water heater, new water softener and reverse osmosis system, fence, carpet throughout the upper-level as well as paint throughout! ' ,`Acres` = '0.2647' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Mud,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CINCO RANCH SOUTHWEST SEC 18, BLOCK 3, LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11532' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'STANLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEVEN LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'SEVEN LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cinco Ranch Southwest Sec 18' ,`TaxAmount` = '16726' ,`TaxRate` = '2.7845' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764616' WHERE `Matrix_Unique_ID` = '213334158' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T06:55:39.710' ,`MLSNumber` = '82458100' ,`ListAgentFullName` = 'Greg Nino' ,`ListOfficeName` = 'RE/MAX Compass' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.807818' ,`Longitude` = '-95.707709' ,`PhotoCount` = '36' ,`PostalCode` = '77084' ,`RoomCount` = '8' ,`ListPrice` = '310000.00' ,`Status` = 'Active' ,`StreetName` = 'Harvest Stream' ,`StreetNumber` = '19331' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2348' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PRICED TO SELL! Check out this beautiful 4 Bedroom with 3 full baths! Roof is approximately 6 years old. AC installed last year! Get in before the holidays! One of the bedrooms is downstairs w/its own full bath, ideal guest bedroom! All recent flooring includes wood, tile & carpet. Expansive living room, separate breakfast room, open concept + upstairs (spacious) gameroom. *Huge* master w/his & her closets! Master bath provides two sinks, a separate tub and shower. Kitchen offers granite countertops & backsplash, stainless steel appliances (gas range) loads of cabinets and plenty of counter space. Covered back patio + generous sized backyard! Light & bright throughout! Close to I-10, grocery stores & just about everything you can think of! Great Find!' ,`Acres` = '0.1285' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 3 LAKE RIDGE SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5599' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '530' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'RHOADS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MAYDE CREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Rdg Sec 5' ,`TaxAmount` = '5315' ,`TaxRate` = '2.487' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764616' WHERE `Matrix_Unique_ID` = '213378383' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213403251','1665764616','213403251','2022-10-14T06:07:01.113','53919004','Susan Heflin','eXp Realty, LLC','','','29.600908','-94.988164','9','77586','10','239900.00','Active','Oak','4714','Street','Pasadena','2','0','4','1860','Single-Family','Welcome to El Jardiin! 4714 is a 4 bedroom 2 bath home that sits on a ten thousand square foot lot. This lovely remodel has been transformed from the inside out with all the trendy colors, new appliances, HVAC, vinyl flooring, full kitchen and baths and exterior siding, vinyl skirting and decking. Relax after work with a short walk to the beach then sitting on your extended porch reflecting on your day. El Jardin is a family community with beach access. What a great find for you and yours, Welcome Home!','0.2296','7','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Clear Lake Area','Central Gas','0','LTS 25 & 26 BLK 12 EL JARDIN BAY SHORE SEC 1','Subdivision Lot','10000','Appraisal District','','','0','','0','Gas Oven','0','','','Gas Range','','Composition','9 - Clear Creek','BAY ELEMENTARY SCHOOL','CLEAR FALLS HIGH SCHOOL','SEABROOK INTERMEDIATE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Other Style','El Jardin Bay Shore Add','2035','2.2819','Public Sewer,Public Water','1998','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:08:27.097' ,`MLSNumber` = '96158142' ,`ListAgentFullName` = 'Jonathan Garcia' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.799550' ,`Longitude` = '-95.108961' ,`PhotoCount` = '27' ,`PostalCode` = '77360' ,`RoomCount` = '8' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Panther' ,`StreetNumber` = '121' ,`StreetSuffix` = '' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1392' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this waterfront home with many features for the perfect place to relax. It has furnished 3 bedrooms, 2 baths, a deck, backyard, patio, pier, boat house, nook and even a catwalk! Inside you\'ll find a modern/clean home with a split floor plan. You can tan or brunch on the patio with friends. Sit in the shade under the deck while you watch the kids play in the backyard or out swimming in the clean open water of Lake Livingston. This home also features a pier, small boathouse and plug for an RV. Home is relatively new (2019) and waiting for its new owners.' ,`Acres` = '0.127' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'IMPALA WOODS SECTION 4 BLK 1 LOT 5 & 6' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '5560' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Right Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Split Level,Traditional' ,`Subdivision` = 'Impala Woods Sec 4' ,`TaxAmount` = '4913' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1665764616' WHERE `Matrix_Unique_ID` = '213446972' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:06:49.130' ,`MLSNumber` = '8324287' ,`ListAgentFullName` = 'Stephanie Phillips' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.235407' ,`Longitude` = '-95.565539' ,`PhotoCount` = '30' ,`PostalCode` = '77354' ,`RoomCount` = '11' ,`ListPrice` = '389000.00' ,`Status` = 'Active' ,`StreetName` = 'Weisinger' ,`StreetNumber` = '922' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2276' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your very own charming 4 bedroom, 3 1/2 bathroom log cabin home! You will fall in love from the circular drive to the large front porch with swing to the two primary bedrooms- all on almost a half-acre! The first floor offers a primary with en-suite bathroom plus a well-appointed cedar lined half bath. Enjoy the updated kitchen with eating area and views of the large backyard. The family room offers a beautiful stone mantel and standalone gas log fireplace. The second floor includes another primary bedroom with en-suite bathroom, two other secondary bedrooms, another full bath / utility room. The third level offers a loft which could be used as an office or game/flex room. Wyze doorbell camera and alarm stay with house. Fresh landscaping, 2 storage sheds and a workshop. Updated light fixtures, upgraded Waterproof Laminate Flooring, new counter tops...too many upgrades to list. Community pool, low HOA, no MUD and low taxes. Please see upgrade sheet.' ,`Acres` = '0.4591' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WESTWOOD 04, BLOCK 2, LOT 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '20000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '227' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'TOM R. ELLISOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Other Style,Ranch' ,`Subdivision` = 'Westwood 04' ,`TaxAmount` = '4882' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Aerobic,Other Water/Sewer' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764617' WHERE `Matrix_Unique_ID` = '213490710' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:19:57.280' ,`MLSNumber` = '83374120' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.518751' ,`Longitude` = '-95.437150' ,`PhotoCount` = '16' ,`PostalCode` = '77583' ,`RoomCount` = '7' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Penton Meadow' ,`StreetNumber` = '4938' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2086' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW Lennar Homes Wildflower Collection, \'\'Hanover II\'\' Plan with Elevation \"C\" in Lakes of Savannah. The lovely single story Hanover floor plan by Lennar features a welcoming front porch and entry foyer, a home office/ study, a spacious kitchen and adjoining casual dining room that offers access to a covered rear patio, and a generous open family room. The three bedroom home’s primary bedroom includes a spacious en suite bathroom featuring a private toilet enclosure, shower, and an oversized walk-in closet. *HOME ESTIMATED TO BE COMPLETE, NOVEMBER, 2022*' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0019 BLK 001 LOT 005' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'SAVANNAH LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes of Savannah' ,`TaxAmount` = '' ,`TaxRate` = '3.37' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665764617' WHERE `Matrix_Unique_ID` = '213495696' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:20:32.630' ,`MLSNumber` = '18627482' ,`ListAgentFullName` = 'Loretta Lynch' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.106334' ,`Longitude` = '-95.407453' ,`PhotoCount` = '32' ,`PostalCode` = '77386' ,`RoomCount` = '8' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = 'Pear Side' ,`StreetNumber` = '29311' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2424' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HOME HAS NEVER FLOODED! Priced to SELL!!! GREAT TWO STORY, 4-BEDROOM FLOOR PLAN, HUGE LIVING, DINING, SEPARATE BREAKFAST OFF SPACIOUS KITCHEN, 1 BEDROOM/STUDY WITH HALF BATH DOWN. PRIMARY PLUS 2 MORE BEDROOMS, A LARGE GAME ROOM, AND LAUNDRY ARE UP. LOCATED AT THE END OF A QUIET CUL-DE-SAC.' ,`Acres` = '0.1354' ,`Area` = '15' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S515907 - FOREST VILLAGE 07, BLOCK 2, LOT 16' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '5898' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '424' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'FORD ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Forest Village 07' ,`TaxAmount` = '6099' ,`TaxRate` = '2.8187' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764617' WHERE `Matrix_Unique_ID` = '213507950' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T06:14:55.787' ,`MLSNumber` = '45968378' ,`ListAgentFullName` = 'Ashlee Johnston' ,`ListOfficeName` = 'Realty ONE Group, Experience' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.324943' ,`Longitude` = '-95.481480' ,`PhotoCount` = '45' ,`PostalCode` = '77304' ,`RoomCount` = '9' ,`ListPrice` = '339900.00' ,`Status` = 'Active' ,`StreetName` = 'Oakhill' ,`StreetNumber` = '403' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2732' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Locations like this don\'t come along often! This wonderfully maintained 2-Story is located in the heart of Conroe but also tucked away on a quiet street with minimal traffic, no back neighbors and no HOA. Brand new AC and backyard fencing has just been installed. Exterior of the home has been freshly painted. The primary bedroom sits downstairs along with a formal living/flex space. Then all your secondary bedrooms are located on the second floor. Lush and well-maintained grass fills the oversized backyard. Plantation Shutters adorn the interior windows of the first story. All the carpet has been professionally cleaned upon activation of this listing. Another unique feature to take notice of is the neighborhood is full of large, mature trees which can not be duplicated in a newer communities. The owners have taken so much pride in the maintenance of this home - come see this beauty in person!' ,`Acres` = '0.2103' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WESTVIEW, BLOCK 1, LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9160' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'REAVES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westview' ,`TaxAmount` = '2955' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764617' WHERE `Matrix_Unique_ID` = '213515828' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:43:31.327' ,`MLSNumber` = '39643771' ,`ListAgentFullName` = 'Joe LaBorde' ,`ListOfficeName` = 'Green Residential' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.771256' ,`Longitude` = '-95.009526' ,`PhotoCount` = '21' ,`PostalCode` = '77521' ,`RoomCount` = '8' ,`ListPrice` = '175000.00' ,`Status` = 'Active' ,`StreetName` = 'Sage' ,`StreetNumber` = '4507' ,`StreetSuffix` = 'Circle' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1620' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Selling AS-IS. Single family home is ready to move in. The home sits on 0.24 acre lot in a cul-de-sac in the Ponderosa subdivision. Close to Spur 330 & I-10. Make this home your dream home! Home is available for a quick move in.' ,`Acres` = '0.2454' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 15 PONDEROSA SEC 1 R/P' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '10689' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'BAYTOWN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ponderosa Sec 01 R/P' ,`TaxAmount` = '4131' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764617' WHERE `Matrix_Unique_ID` = '213517662' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:58:35.853' ,`MLSNumber` = '14876921' ,`ListAgentFullName` = 'Janetta Penn' ,`ListOfficeName` = 'RE/MAX Associates Northeast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.051305' ,`Longitude` = '-95.156898' ,`PhotoCount` = '50' ,`PostalCode` = '77345' ,`RoomCount` = '12' ,`ListPrice` = '775000.00' ,`Status` = 'Active' ,`StreetName` = 'Seven Maples' ,`StreetNumber` = '2103' ,`StreetSuffix` = 'Drive' ,`City` = 'Kingwood' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4459' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Custom Klotz beauty in prestigious Kings Point, steps away from award winning schools! Soaring 2 story entry/double wrought iron front door! Lushly landscaped backyard paradise w/rec. re-plastered pool/spa/cool decking; located on OS corner lot *recent 150K upgrades including: triple panel windows dnstrs, plant. shutters, luxurious engineered wood flooring dnstrs; evap coil, hot water heaters, condenser, ductwork; pool automation; bonus room up; inviting French doored study w/f/p; dual sized f/p separates formal/family room *DID NOT FLOOD! Bonus room !' ,`Acres` = '0.343' ,`Area` = '32' ,`BuilderName` = 'KLOTZ' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 1 KINGS POINT VLG 1 AMEND R/P' ,`LotDesciption` = 'Corner' ,`LotSize` = '14932' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '585' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'WILLOW CREEK ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'RIVERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kings Point' ,`TaxAmount` = '14419' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764618' WHERE `Matrix_Unique_ID` = '213519051' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:12:59.923' ,`MLSNumber` = '48704848' ,`ListAgentFullName` = 'Jon Kraft' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.109541' ,`Longitude` = '-95.704577' ,`PhotoCount` = '50' ,`PostalCode` = '77355' ,`RoomCount` = '13' ,`ListPrice` = '799000.00' ,`Status` = 'Active' ,`StreetName` = 'Napa View Valley' ,`StreetNumber` = '23802' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4048' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous home with guest quarters, sparkling pool, and 30x40 garage/shop on a beautiful acre lot in a quiet community in Tomball ISD. Perfect for entertaining, the main floorplan offers 4 bedrooms, 3 full baths, formal dining, and study with closet & full bath could be another bedroom. Beautiful island kitchen with granite counters, stainless steel appliances, and plenty of cabinets and counterspace opens to family room with gaslog fireplace. Private primary suite downstairs with dual vanities and huge walk-in closet. Three large bedrooms upstairs. The first floor guest quarters has a living room, kitchenette, bedroom & full bath, and a private entrance. Extensive decking and covered patio to enjoy the wonderful backyard with sparkling pool and plenty of room to play. 3-car porte cochere and extended driveway that leads to the 1200 sqft garage/shop, providing plenty of parking. Great location with easy access to 249, Grand Parkway, and Aggie Expressway.' ,`Acres` = '1' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S885900 - SONOMA RIDGE 01, BLOCK 1, LOT 3' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sonoma Ridge' ,`TaxAmount` = '10753' ,`TaxRate` = '1.9215' ,`WaterSewer` = 'Other Water/Sewer,Septic Tank' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764618' WHERE `Matrix_Unique_ID` = '213526449' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213530961','1665764618','213530961','2022-10-14T07:57:39.990','23775944','Holly Flaskamp','Home Sweet Home RE Group','','','30.225003','-95.472127','50','77384','8','850000.00','Active','Goldenglade','2357','Drive','Conroe','3','1','4','3826','Single-Family','Exquisite, Gracepoint Carson floor plan with countless upgrades! Beautifully situated on an oversized lot, stunning trees behind back fence on a quiet street. This inviting home will captivate you instantly with casual elegance. This home boasts a grand entrance to a gorgeous open-concept kitchen and family room combination with breathtaking views of the lovely and private backyard. Kitchen is complete with large pantry, quartz countertops and a relaxed dining area. Spacious primary retreat has a sitting or additional office area with a glimpse of the serene outdoors. Spectacular spa-like bath includes a soaker tub, walk-in glass shower and capacious walk-in closet. Media room, home office, two more bedrooms, laundry, and one in a half bath completes the downstairs. Upstairs is heavenly with a fourth bedroom, private full bath and giant game room. Easy access to a spacious attic for storage and garage has sought after epoxy flooring! Zoned to the coveted Woodlands High School!','0.3182','15','Gracepoint Homes','','Gas Dryer Connections,Washer Connections','','Exclusions,Sellers Disclosure','1','Gaslog Fireplace','1','Conroe Southwest','Central Gas','1','S903304 - STILLWATER 04, BLOCK 2, LOT 15','Subdivision Lot','13859','Appraisal District','','1075','0','','3','Electric Oven,Single Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','POWELL ELEMENTARY SCHOOL (CONROE)','THE WOODLANDS HIGH SCHOOL','MCCULLOUGH JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','1.5','Traditional','Stillwater 04','3187','3.0663','Water District','2021','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:21:43.937' ,`MLSNumber` = '96323218' ,`ListAgentFullName` = 'Aaron Bertolino' ,`ListOfficeName` = 'Trillionaire Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.293983' ,`Longitude` = '-94.790700' ,`PhotoCount` = '26' ,`PostalCode` = '77550' ,`RoomCount` = '2' ,`ListPrice` = '500000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue O' ,`StreetNumber` = '2320' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1491' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Historic Galveston bungalow with unlimited potential for rental or island life seekers. Queen Anne style home constructed around 1900 according to the National Registry of Historic Places. Home is positioned on large lot with spacious backyard, close to the beach and island attractions. Home is two separate units with open living room and kitchen areas. One bedroom and full bath in each unit. Lots of cabinet and interior storage space inside each unit. Home has access to each unit facing Ave O with individual access to rear patio and backyard. Home has been used for rental and has solid record of use.' ,`Acres` = '0.145' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR PT OF LOTS 2,3,12,13 & ALLEY (3013-1' ,`LotDesciption` = 'Other' ,`LotSize` = '6317' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Galveston Outlots' ,`TaxAmount` = '9916' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764618' WHERE `Matrix_Unique_ID` = '213531032' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213548219','1665764618','213548219','2022-10-14T06:28:07.727','13250198','Carlito Rivera','Prime Realty Group','','','29.697758','-95.161177','29','77503','6','270000.00','Active','Anson','811','Circle','Pasadena','1','1','3','1697','Single-Family','Lovely 3-4 bedroom home. Garage has been converted to a living space that could be used as a family room or a primary suite. Has hard wood floors in family room and through-out the bedrooms. Home\'s exterior has been updated recently. Interior has many updated also. Call to schedule your appointment today.','0.1818','6','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','0','Pasadena','Central Gas','0','LT 22 BLK 23 TANGLEBRIAR SEC 4','Subdivision Lot','7920','Appraisal District','','','0','','0','Gas Oven','0','','','Gas Range','','Composition','41 - Pasadena','MCMASTERS ELEMENTARY SCHOOL','SAM RAYBURN HIGH SCHOOL','SANJACINTO INTERMEDIATE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Tanglebriar Sec 04','4129','2.6514','Public Sewer,Public Water','1963','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:52:46.930' ,`MLSNumber` = '48921392' ,`ListAgentFullName` = 'Ruth Carruthers' ,`ListOfficeName` = 'Compass RE Texas, LLCHeights' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.285336' ,`Longitude` = '-95.563984' ,`PhotoCount` = '41' ,`PostalCode` = '77316' ,`RoomCount` = '10' ,`ListPrice` = '795000.00' ,`Status` = 'Active' ,`StreetName` = 'Silverwolf Cove' ,`StreetNumber` = '102' ,`StreetSuffix` = 'Place' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3645' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A breathtaking and iconic Wendell Legacy Custom home perched on a picturesque corner lot in beautiful Woodforest. You will find layers upon layers of upgrades and improvements throughout this stunning home including a full sized generator, wood accent walls, designer fixtures and sconces, in-wall speakers, plantation shutters and epoxy garage floor! This home boasts an open floor plan with tons of natural light and a huge kitchen with ample storage - an entertainer\'s dream! The primary suite includes a large walk-in closet and spa-like bathroom. In addition to 4 bedrooms, you have a large game room AND media room upstairs! The large, fully fenced backyard includes a covered patio, mature trees and beautiful views of protected green space due to the location of the lot. Don\'t miss this gem!' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Wendell Legacy Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S965251 - Woodforest 51, Block 1, Lot 17, 50.000000% UDI' ,`LotDesciption` = 'Corner,In Golf Course Community,Subdivision Lot' ,`LotSize` = '11636' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1265' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764618' WHERE `Matrix_Unique_ID` = '213573718' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213592750','1665764618','213592750','2022-10-14T06:11:35.343','44943836','Johnnie Rae','CB&A, Realtors-Katy','','','29.664392','-95.362964','28','77051','6','210000.00','Active','Alvin','4341','Street','Houston','2','0','3','1264','Single-Family','Charming 1-story home with tons of upgrades including NEW ROOF!!! Enjoy cooking in a spacious kitchen with new appliances, granite counter tops and lots of cabinets for storage. Lovely new flooring throughout the home gives it a nice flow from each room. Relax in one of the 3 spacious bedrooms with new carpet and freshly painted. Both bathrooms are gorgeous and the tile work really makes the bathrooms stand out. The dinning area is connected to the kitchen making it perfect for entertaining guest and the laundry has its own designated room towards the back of the home. Home is located minutes away from NRG Stadium and Medical Center. Owner Financing Available.','0.1566','3','','','','','Sellers Disclosure','1','','','Medical Center South','Central Gas','0','LT 8 BLK 3 BLUE BONNET ESTATES','Subdivision Lot','6820','Appraisal District','','','0','','0','','0','','','','','Composition','27 - Houston','BASTIAN ELEMENTARY SCHOOL','WORTHING HIGH SCHOOL','ATTUCKS MIDDLE SCHOOL','Lockbox Back','Appraisal District','1','Traditional','Blue Bonnet Estates','3806','2.3307','Public Sewer,Public Water','1948','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:35:43.100' ,`MLSNumber` = '63262853' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.146493' ,`Longitude` = '-95.678428' ,`PhotoCount` = '8' ,`PostalCode` = '77362' ,`RoomCount` = '8' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Woodtrace' ,`StreetNumber` = '35424' ,`StreetSuffix` = 'Circle' ,`City` = 'Pinehurst' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2285' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW!! Gorgeous Village Builders Avante Collection \'\'Montecito\" Design with Elevation \'\'B\'\'. This two-story home is gorgeous! The primary suite is on the first floor with a full bathroom and walk-in closet, adjacent to the open concept family room, dining area and kitchen. Upstairs are three bedrooms and two full bathrooms.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Village Builders' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0015 BLK 001 LOT 033' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodtrace' ,`TaxAmount` = '' ,`TaxRate` = '3.3542' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665764618' WHERE `Matrix_Unique_ID` = '213593316' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T06:04:28.627' ,`MLSNumber` = '28557464' ,`ListAgentFullName` = 'Brian Covault' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.771136' ,`Longitude` = '-95.757403' ,`PhotoCount` = '22' ,`PostalCode` = '77450' ,`RoomCount` = '4' ,`ListPrice` = '316500.00' ,`Status` = 'Active' ,`StreetName` = 'Cimarron' ,`StreetNumber` = '22215' ,`StreetSuffix` = 'Parkway' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1758' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOTIVATED SELLER! Welcome home to this beautifully updated 4 Bedroom house in the sought after area of Cimarron. The remodeled kitchen boasts luxurious quartz counter tops with subway tile and new cabinets. Both bathrooms have been remodeled with custom tile work and brand-new vanities. Fresh paint throughout the house on the walls, ceilings, and trim. Enjoy new tile floors in the foyer, kitchen, and bathrooms, premium laminate flooring in the living areas as well as the primary bedroom plus new carpet in the secondary bedrooms. The laundry room is inside, along with ample storage space. Relax on your covered patio and enjoy outdoor activities in your oversized backyard. HVAC is only 4 years old and roof covering only 7 years old, plus vinyl siding for low maintenance and double pane windows too. Zoned to highly acclaimed Katy ISD and close to tons of dining and shopping. Schedule your showing today!' ,`Acres` = '0.2169' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 3 CIMARRON SEC 1 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9450' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '460' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CIMARRON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'WEST MEMORIAL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cimarron Sec 01 R/P' ,`TaxAmount` = '4381' ,`TaxRate` = '2.3283' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764619' WHERE `Matrix_Unique_ID` = '213595361' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213604665','1665764619','213604665','2022-10-14T06:51:03.970','68883576','Shelley Stone','eXp Realty, LLC','','','29.680598','-95.432821','26','77025','8','565000.00','Active','Sun Valley','3515','Drive','Houston','2','0','3','2362','Single-Family','Modern updates and classically styled this open and bright home sits on an oversized, corner lot nestled among the trees in the highly desired subdivision of Woodside. The 1 story ranch style home features 3 bedrooms / 2 baths, and an open floor plan including a formal living room, spacious kitchen which flows directly into the dining room and an open concept family room with doors accessing the outdoor patio. The kitchen features granite countertops w/updated cabinets, oversized island, and SS appliances. Spacious primary suite includes a walk in closet and remodeled bath. Original refurbished hardwood floors throughout, this home includes an all new HVAC system, energy-efficient double pane windows, tankless water heater, PEX plumbing and LED lighting. Home has NEVER FLOODED and is move in ready for you and your family. Minutes from Texas Med Center, Museum District, Herman Park, Downtown & U of H!','0.2303','17','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Knollwood/Woodside Area','Central Gas','0','LT 6 BLK 17 WOODSIDE SEC 3','Corner,Subdivision Lot','10033','Appraisal District','','225','0','','2','','0','','','Gas Range','','Composition','27 - Houston','LONGFELLOW ELEMENTARY SCHOOL (HOUSTON)','BELLAIRE HIGH SCHOOL','PERSHING MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Woodside','9323','2.3307','Public Sewer,Public Water','1957','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213613274','1665764619','213613274','2022-10-14T07:04:36.797','7075694','Neil Silverman','Bernstein Realty, Inc.','','','29.449171','-95.434768','47','77583','12','499000.00','Active','Emerald Pines','2706','Lane','Iowa Colony','3','1','4','3586','Single-Family','Beautiful Terrata Home built in 2019 that will not disappoint. Incredible home for entertaining! Open flowing concept filled w/natural light. This 4-bedroom, 3.5 bath home w/granite throughout, on a Cul-De-Sac, sits on a huge 17,193 sq foot lot (per Appraisal District). The first floor boasts a welcoming open floor plan w/ Primary down, 2 walk-in closets & double vanity sinks. Huge Living/Family room w/fireplace nicely appointed w/stone, open kitchen w/stainless steel appliances & stone backsplash, breakfast room, breakfast bar w/granite bull nose rounded corners giving ample extra seating, formal dining room & large walk-in pantry. Second floor includes 3 bedrooms, media room, study/office & 2 bathrooms, one with a full shower. Extra features, Tankless Water Heater, 3-Car Garage w/Epoxied Floor, Outdoor Kitchen for entertaining & beautifully landscaped. Huge lot will accommodate an expansive pool. Community amenities include a manned guard, rec facilities w/pool, trails, & tennis.','0.3947','5','Terrata','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Alvin North','Central Gas,Zoned','1','STERLING LAKES AT IOWA COLONY SEC 20 (A0289 HT&B) BLK 2 LOT','Subdivision Lot','17193','Appraisal District','','1200','0','','3','Convection Oven,Single Oven','0','','','Gas Cooktop','','Composition','3 - Alvin','SANCHEZ ELEMENTARY SCHOOL (ALVIN)','IOWA COLONY HIGH SCHOOL','CAFFEY JUNIOR HIGH SCHOOL','Appointment Required,Controlled Access,Lockbox Left Side,Supra Keybox','Appraisal District','2','Traditional','Sterling Lakes At Iowa Colony','14555','3.4099','Water District','2019','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213614176','1665764619','213614176','2022-10-14T07:19:34.647','23196148','William Underwood','Tammy Bateman Properties','','','29.813457','-95.437682','50','77018','3','445500.00','Active','Wilde Rock','2015','Way','Houston','2','0','3','1236','Single-Family','Welcome home to 2015 Wilde Rock Way! This exceptional Fully renovated, 3 bedroom 2 full bathroom home nestled in the heart of Oak Forest has been Completely redesigned to all of today\'s high-end luxury finishes. Upon entry, you will notice the open floor plan and rich wood flooring. The family room opens to the chef’s kitchen professionally designed around your 105ft custom island making this a perfect layout for entertaining or quiet nights at home. New Pex Plumbing, Electrical, Lighting, Roof, Double Pane Windows, AC replaced in 2018, Water Heater replaced in 2019. Custom 42in Cabinets, Pot Filler, Beautiful Hardwood Floors, Large Walk-In Pantry, Huge Laundry Room, Elfa Closet Shelving, Custom Linen Closet, New Bathroom added with Custom Plank Tile, Gas Appliances with new Refrigerator, a Coffee/Wine Bar, Nest Thermostat, Huge backyard with Patio, Tuff Shed perfect for Storage, Telsa Car Charger, Kenmore Refrigerator in Garage and Much More! A MUST-SEE! Inspired by Magnolia Home!','0.1612','9','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','','','Oak Forest East Area','Central Electric','0','LT 565 BLK 31 SHEPHERD FOREST SEC 2','Subdivision Lot','7020','Appraisal District','','','0','','1','Gas Oven','0','','','Gas Range','','Composition','27 - Houston','OAK FOREST ELEMENTARY SCHOOL (HOUSTON)','WALTRIP HIGH SCHOOL','BLACK MIDDLE SCHOOL','Appointment Required,Leave Business Card,Request Online Appointment,Vacant/Unoccupied','Appraisal','1','Ranch','Shepherd Forest Sec 02','6120','2.3307','Public Sewer,Public Water','1957','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213634807','1665764619','213634807','2022-10-14T06:51:25.620','34030102','Tommy Ruland','Tommy Ruland Properties, Inc','','','30.193032','-95.800743','12','77355','3','90000.00','Active','Hondo','26944','Circle','Magnolia','2','0','3','1568','Single-Family','Don\'t miss this opportunity!!!! 2004 double wide 1568 sf. on a 1/2 acre corner lot. New roof 2020. The interior will need complete renovation, seller is selling as is only. Buyer will have to purchase new survey if required.','0.5807','15','','','Electric Dryer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Magnolia/1488 West','Central Electric','0','S821100 - RANCH CREST 01, BLOCK 3, LOT 4, SERIAL # CW2009304','Corner','25295','Appraisal District','','','0','','0','Electric Oven','0','','','Electric Cooktop','','Composition','36 - Magnolia','WILLIE E. WILLIAMS ELEMENTARY SCHOOL','MAGNOLIA WEST HIGH SCHOOL','MAGNOLIA JUNIOR HIGH SCHOOL','Lockbox Front','Appraisal District','1','Traditional','Ranch Crest 01','2072','1.8587','Public Sewer,Public Water','2004','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T07:55:53.990' ,`MLSNumber` = '56692019' ,`ListAgentFullName` = 'Marie Dupres' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.768779' ,`Longitude` = '-95.559201' ,`PhotoCount` = '40' ,`PostalCode` = '77024' ,`RoomCount` = '12' ,`ListPrice` = '1349000.00' ,`Status` = 'Active' ,`StreetName` = 'Faust' ,`StreetNumber` = '419' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4583' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This custom home is move in ready! New carpet in bedrooms(2022), updated refrigerator(2018) double ovens(2018), air conditioners(2018,2020),dishwasher(2018). Entertain around the exotic Granite waterfall island. Your inner chef will be inspired by the high end stainless steel appliances and 6 burner gas cooktop. Enjoy casual meals in the shared breakfast area or formal dining room. Store leftovers in the second fridge. When you enter the home through the garage, the mudroom will keep your belongings out of sight. In the evening, retire to your serene primary suite. The spa inspired en suite features dual vanities, a separate shower and a private area to soak in the vessel tub. The oversized custom closet with built ins and shoe racks does not disappoint. Rest easy knowing your children are attending exemplary Schools (Rummel Creek Elementary, Memorial Middle/High).' ,`Acres` = '0.1928' ,`Area` = '23' ,`BuilderName` = 'Protege Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 4 MEMORIAL BEND SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'RUMMEL CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Bend Sec 01' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764619' WHERE `Matrix_Unique_ID` = '213636190' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213648624','1665764619','213648624','2022-10-14T07:41:04.563','50938807','Kimberly Cabrera','Keller Williams Premier RealtyKaty','','','29.811836','-95.800840','26','77493','9','375000.00','Active','Forest Canopy','24715','Drive','Katy','2','1','4','2671','Single-Family','Stunning 4 Bedrooms 2.5 Baths Home in the Lake Forest Community of Katy, Tx. Built on one of the largest lots in the subdivision. Interior it offers an ideal floor plan with the master bedroom downstairs, spacious living area, the kitchen opens up to a dining area and a breakfast area and the garage has an epoxy coated floor and a double wide driveway. Upstairs you will find a large game room, with three additional spacious bedrooms. The master bedroom has a walk-in closet with the primary bath featuring dual vanities, stand-in shower and a kohler master windward tub. BRAND NEW SOLAR PANELS ARE INCLUDED AND YOU DON\'T HAVE TO WORRY ABOUT ELECTRICITY BILLS. Schedule your showing today! Room description and measuremens should be verified by the buyer and buyer\'s agent.','0.3134','25','','','','','Mud,Sellers Disclosure','','','','Katy - Old Towne','Central Electric,Solar Assisted','1','LT 11 BLK 3 LAKECREST FOREST SEC 5','Cul-De-Sac,Subdivision Lot','13650','Appraisal District','','575','0','','2','','0','','','','','Composition','30 - Katy','KING ELEMENTARY SCHOOL','PAETOW HIGH SCHOOL','HASKETT JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front','Appraisal District','2','Traditional','Lakecrest Forest Sec 5','7204','2.6083','Public Sewer,Public Water','2014','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213656664','1665764619','213656664','2022-10-14T07:54:18.363','97647429','Edward McClintick','Joseph Walter Realty, LLC','','','29.287058','-94.829746','8','77551','5','205000.00','Active','57th','1302','Street','Galveston','1','0','2','624','Single-Family','Cute renovated 2/1 with attached WI-FI garage. Extra-large driveway that can park 4 vehicles. Low/No maintenance gravel backyard and side landscaping. Waterproof luxury vinyl flooring. Energy efficient double pane windows. Granite countertops. Beautiful walk-in shower. This little house has it all to make a nice home. Conveys with furnishings.','0.0459','33','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Midtown - Galveston','Central Electric','0','ABST 628 M B MENARD SUR LOT A (1-3) DENVER RESURVEY REPLAT A','Other','2000','Appraisal District','','','0','','1','','0','','','Gas Cooktop','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Appointment Required','Appraisal District','1','Other Style','Denver Resurvey','2583','2.0662','Public Sewer,Public Water','1958','Appraisal District'); --> New record created successfully